NFL Pick ‘Em for 2021-2022 Season Schedule

I had written a little clever script for last season that was supposed to work for every season until the end of time. Well, those hopes were crushed when the NFL changed their links to something that I cannot identify.  The following script is a culmination of several hours of work, many edits and minor scripts to search and replace.

This is for the complete 18 week, 17 game season. The Washington Redskins is changed to Washington Football Team, and The Raiders are in Las Vegas.  I’ll leave those fixes to you. This particular script worked for me as I never got around to hacking the PHP/database to accommodate the changes I have mentioned.

Without further ado, this is a “working” NFL Pick ‘Em SQL script for 2021-2022 season of the NFL.

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

DROP TABLE IF EXISTS `nflp_schedule`;
CREATE TABLE IF NOT EXISTS `nflp_schedule` (
`gameID` int(11) NOT NULL AUTO_INCREMENT,
`weekNum` int(11) NOT NULL,
`gameTimeEastern` datetime DEFAULT NULL,
`homeID` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`homeScore` int(11) DEFAULT NULL,
`visitorID` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`visitorScore` int(11) DEFAULT NULL,
`overtime` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`gameID`),
KEY `GameID` (`gameID`),
KEY `HomeID` (`homeID`),
KEY `VisitorID` (`visitorID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=273 ;

INSERT INTO `nflp_schedule` (`gameID`, `weekNum`, `gameTimeEastern`, `homeID`, `homeScore`, `visitorID`, `visitorScore`, `overtime`) VALUES
(1,1,'2021-09-09 20:20:00','TB',NULL,'DAL',NULL,0),
(2,1,'2021-09-12 13:00:00','ATL',NULL,'PHI',NULL,0),
(3,1,'2021-09-12 13:00:00','BUF',NULL,'PIT',NULL,0),
(4,1,'2021-09-12 13:00:00','CAR',NULL,'NYJ',NULL,0),
(5,1,'2021-09-12 13:00:00','CINs',NULL,'MIN',NULL,0),
(6,1,'2021-09-12 13:00:00','DET',NULL,'SF',NULL,0),
(7,1,'2021-09-12 13:00:00','HOU',NULL,'JAX',NULL,0),
(8,1,'2021-09-12 13:00:00','IND',NULL,'SEA',NULL,0),
(9,1,'2021-09-12 13:00:00','TEN',NULL,'ARI',NULL,0),
(10,1,'2021-09-12 13:00:00','WAS',NULL,'LAC',NULL,0),
(11,1,'2021-09-12 16:25:00','KC',NULL,'CLE',NULL,0),
(12,1,'2021-09-12 16:25:00','NE',NULL,'MIA',NULL,0),
(13,1,'2021-09-12 16:25:00','NO',NULL,'GB',NULL,0),
(14,1,'2021-09-12 16:25:00','NYG',NULL,'DEN',NULL,0),
(15,1,'2021-09-12 20:20:00','LAR',NULL,'CHI',NULL,0),
(16,1,'2021-09-13 20:15:00','OAK',NULL,'BAL',NULL,0),
(17,2,'2021-09-16 20:20:00','WAS',NULL,'NYG',NULL,0),
(18,2,'2021-09-19 13:00:00','CAR',NULL,'NO',NULL,0),
(19,2,'2021-09-19 13:00:00','CHI',NULL,'CINs',NULL,0),
(20,2,'2021-09-19 13:00:00','CLE',NULL,'HOU',NULL,0),
(21,2,'2021-09-19 13:00:00','IND',NULL,'LAR',NULL,0),
(22,2,'2021-09-19 13:00:00','JAX',NULL,'DEN',NULL,0),
(23,2,'2021-09-19 13:00:00','MIA',NULL,'BUF',NULL,0),
(24,2,'2021-09-19 13:00:00','NYJ',NULL,'NE',NULL,0),
(25,2,'2021-09-19 13:00:00','PHI',NULL,'SF',NULL,0),
(26,2,'2021-09-19 13:00:00','PIT',NULL,'OAK',NULL,0),
(27,2,'2021-09-19 16:05:00','ARI',NULL,'MIN',NULL,0),
(28,2,'2021-09-19 16:05:00','TB',NULL,'ATL',NULL,0),
(29,2,'2021-09-19 16:25:00','LAC',NULL,'DAL',NULL,0),
(30,2,'2021-09-19 16:25:00','SEA',NULL,'TEN',NULL,0),
(31,2,'2021-09-19 20:20:00','BAL',NULL,'KC',NULL,0),
(32,2,'2021-09-20 20:15:00','GB',NULL,'DET',NULL,0),
(33,3,'2021-09-23 20:20:00','HOU',NULL,'CAR',NULL,0),
(34,3,'2021-09-26 13:00:00','BUF',NULL,'WAS',NULL,0),
(35,3,'2021-09-26 13:00:00','CLE',NULL,'CHI',NULL,0),
(36,3,'2021-09-26 13:00:00','DET',NULL,'BAL',NULL,0),
(37,3,'2021-09-26 13:00:00','JAX',NULL,'ARI',NULL,0),
(38,3,'2021-09-26 13:00:00','KC',NULL,'LAC',NULL,0),
(39,3,'2021-09-26 13:00:00','NE',NULL,'NO',NULL,0),
(40,3,'2021-09-26 13:00:00','NYG',NULL,'ATL',NULL,0),
(41,3,'2021-09-26 13:00:00','PIT',NULL,'CINs',NULL,0),
(42,3,'2021-09-26 13:00:00','TEN',NULL,'IND',NULL,0),
(43,3,'2021-09-26 16:05:00','DEN',NULL,'NYJ',NULL,0),
(44,3,'2021-09-26 16:05:00','OAK',NULL,'MIA',NULL,0),
(45,3,'2021-09-26 16:25:00','LAR',NULL,'TB',NULL,0),
(46,3,'2021-09-26 16:25:00','MIN',NULL,'SEA',NULL,0),
(47,3,'2021-09-26 20:20:00','SF',NULL,'GB',NULL,0),
(48,3,'2021-09-27 20:15:00','DAL',NULL,'PHI',NULL,0),
(49,4,'2021-09-30 20:20:00','CINs',NULL,'JAX',NULL,0),
(50,4,'2021-10-03 13:00:00','ATL',NULL,'WAS',NULL,0),
(51,4,'2021-10-03 13:00:00','BUF',NULL,'HOU',NULL,0),
(52,4,'2021-10-03 13:00:00','CHI',NULL,'DET',NULL,0),
(53,4,'2021-10-03 13:00:00','DAL',NULL,'CAR',NULL,0),
(54,4,'2021-10-03 13:00:00','MIA',NULL,'IND',NULL,0),
(55,4,'2021-10-03 13:00:00','MIN',NULL,'CLE',NULL,0),
(56,4,'2021-10-03 13:00:00','NO',NULL,'NYG',NULL,0),
(57,4,'2021-10-03 13:00:00','NYJ',NULL,'TEN',NULL,0),
(58,4,'2021-10-03 13:00:00','PHI',NULL,'KC',NULL,0),
(59,4,'2021-10-03 16:05:00','LAR',NULL,'ARI',NULL,0),
(60,4,'2021-10-03 16:05:00','SF',NULL,'SEA',NULL,0),
(61,4,'2021-10-03 16:25:00','DEN',NULL,'BAL',NULL,0),
(62,4,'2021-10-03 16:25:00','GB',NULL,'PIT',NULL,0),
(63,4,'2021-10-03 20:20:00','NE',NULL,'TB',NULL,0),
(64,4,'2021-10-04 20:15:00','LAC',NULL,'OAK',NULL,0),
(65,5,'2021-10-07 20:20:00','SEA',NULL,'LAR',NULL,0),
(66,5,'2021-10-10 09:30:00','ATL',NULL,'NYJ',NULL,0),
(67,5,'2021-10-10 13:00:00','CAR',NULL,'PHI',NULL,0),
(68,5,'2021-10-10 13:00:00','CINs',NULL,'GB',NULL,0),
(69,5,'2021-10-10 13:00:00','HOU',NULL,'NE',NULL,0),
(70,5,'2021-10-10 13:00:00','JAX',NULL,'TEN',NULL,0),
(71,5,'2021-10-10 13:00:00','MIN',NULL,'DET',NULL,0),
(72,5,'2021-10-10 13:00:00','PIT',NULL,'DEN',NULL,0),
(73,5,'2021-10-10 13:00:00','TB',NULL,'MIA',NULL,0),
(74,5,'2021-10-10 13:00:00','WAS',NULL,'NO',NULL,0),
(75,5,'2021-10-10 16:05:00','OAK',NULL,'CHI',NULL,0),
(76,5,'2021-10-10 16:05:00','LAC',NULL,'CLE',NULL,0),
(77,5,'2021-10-10 16:25:00','ARI',NULL,'SF',NULL,0),
(78,5,'2021-10-10 16:25:00','DAL',NULL,'NYG',NULL,0),
(79,5,'2021-10-10 20:20:00','KC',NULL,'BUF',NULL,0),
(80,5,'2021-10-11 20:15:00','BAL',NULL,'IND',NULL,0),
(81,6,'2021-10-14 20:20:00','PHI',NULL,'TB',NULL,0),
(82,6,'2021-10-17 09:30:00','JAX',NULL,'MIA',NULL,0),
(83,6,'2021-10-17 13:00:00','BAL',NULL,'LAC',NULL,0),
(84,6,'2021-10-17 13:00:00','CAR',NULL,'MIN',NULL,0),
(85,6,'2021-10-17 13:00:00','CHI',NULL,'GB',NULL,0),
(86,6,'2021-10-17 13:00:00','DET',NULL,'CINs',NULL,0),
(87,6,'2021-10-17 13:00:00','IND',NULL,'HOU',NULL,0),
(88,6,'2021-10-17 13:00:00','NYG',NULL,'LAR',NULL,0),
(89,6,'2021-10-17 13:00:00','WAS',NULL,'KC',NULL,0),
(90,6,'2021-10-17 16:05:00','CLE',NULL,'ARI',NULL,0),
(91,6,'2021-10-17 16:25:00','DEN',NULL,'OAK',NULL,0),
(92,6,'2021-10-17 16:25:00','NE',NULL,'DAL',NULL,0),
(93,6,'2021-10-17 20:20:00','PIT',NULL,'SEA',NULL,0),
(94,6,'2021-10-18 20:15:00','TEN',NULL,'BUF',NULL,0),
(95,7,'2021-10-21 20:20:00','CLE',NULL,'DEN',NULL,0),
(96,7,'2021-10-24 13:00:00','BAL',NULL,'CINs',NULL,0),
(97,7,'2021-10-24 13:00:00','GB',NULL,'WAS',NULL,0),
(98,7,'2021-10-24 13:00:00','MIA',NULL,'ATL',NULL,0),
(99,7,'2021-10-24 13:00:00','NE',NULL,'NYJ',NULL,0),
(100,7,'2021-10-24 13:00:00','NYG',NULL,'CAR',NULL,0),
(101,7,'2021-10-24 13:00:00','TEN',NULL,'KC',NULL,0),
(102,7,'2021-10-24 16:05:00','OAK',NULL,'PHI',NULL,0),
(103,7,'2021-10-24 16:05:00','LAR',NULL,'DET',NULL,0),
(104,7,'2021-10-24 16:25:00','ARI',NULL,'HOU',NULL,0),
(105,7,'2021-10-24 16:25:00','TB',NULL,'CHI',NULL,0),
(106,7,'2021-10-24 20:20:00','SF',NULL,'IND',NULL,0),
(107,7,'2021-10-25 20:15:00','SEA',NULL,'NO',NULL,0),
(108,8,'2021-10-28 20:20:00','ARI',NULL,'GB',NULL,0),
(109,8,'2021-10-31 13:00:00','ATL',NULL,'CAR',NULL,0),
(110,8,'2021-10-31 13:00:00','BUF',NULL,'MIA',NULL,0),
(111,8,'2021-10-31 13:00:00','CHI',NULL,'SF',NULL,0),
(112,8,'2021-10-31 13:00:00','CLE',NULL,'PIT',NULL,0),
(113,8,'2021-10-31 13:00:00','DET',NULL,'PHI',NULL,0),
(114,8,'2021-10-31 13:00:00','HOU',NULL,'LAR',NULL,0),
(115,8,'2021-10-31 13:00:00','IND',NULL,'TEN',NULL,0),
(116,8,'2021-10-31 13:00:00','NYJ',NULL,'CINs',NULL,0),
(117,8,'2021-10-31 16:05:00','LAC',NULL,'NE',NULL,0),
(118,8,'2021-10-31 16:05:00','SEA',NULL,'JAX',NULL,0),
(119,8,'2021-10-31 16:25:00','DEN',NULL,'WAS',NULL,0),
(120,8,'2021-10-31 16:25:00','NO',NULL,'TB',NULL,0),
(121,8,'2021-10-31 20:20:00','MIN',NULL,'DAL',NULL,0),
(122,8,'2021-11-01 20:15:00','KC',NULL,'NYG',NULL,0),
(123,9,'2021-11-04 20:20:00','IND',NULL,'NYJ',NULL,0),
(124,9,'2021-11-07 13:00:00','BAL',NULL,'MIN',NULL,0),
(125,9,'2021-11-07 13:00:00','CAR',NULL,'NE',NULL,0),
(126,9,'2021-11-07 13:00:00','CINs',NULL,'CLE',NULL,0),
(127,9,'2021-11-07 13:00:00','DAL',NULL,'DEN',NULL,0),
(128,9,'2021-11-07 13:00:00','JAX',NULL,'BUF',NULL,0),
(129,9,'2021-11-07 13:00:00','MIA',NULL,'HOU',NULL,0),
(130,9,'2021-11-07 13:00:00','NO',NULL,'ATL',NULL,0),
(131,9,'2021-11-07 13:00:00','NYG',NULL,'OAK',NULL,0),
(132,9,'2021-11-07 16:05:00','PHI',NULL,'LAC',NULL,0),
(133,9,'2021-11-07 16:25:00','KC',NULL,'GB',NULL,0),
(134,9,'2021-11-07 16:25:00','SF',NULL,'ARI',NULL,0),
(135,9,'2021-11-07 20:20:00','LAR',NULL,'TEN',NULL,0),
(136,9,'2021-11-08 20:15:00','PIT',NULL,'CHI',NULL,0),
(137,10,'2021-11-11 20:20:00','MIA',NULL,'BAL',NULL,0),
(138,10,'2021-11-14 13:00:00','DAL',NULL,'ATL',NULL,0),
(139,10,'2021-11-14 13:00:00','IND',NULL,'JAX',NULL,0),
(140,10,'2021-11-14 13:00:00','NE',NULL,'CLE',NULL,0),
(141,10,'2021-11-14 13:00:00','NYJ',NULL,'BUF',NULL,0),
(142,10,'2021-11-14 13:00:00','PIT',NULL,'DET',NULL,0),
(143,10,'2021-11-14 13:00:00','TEN',NULL,'NO',NULL,0),
(144,10,'2021-11-14 13:00:00','WAS',NULL,'TB',NULL,0),
(145,10,'2021-11-14 16:05:00','ARI',NULL,'CAR',NULL,0),
(146,10,'2021-11-14 16:05:00','LAC',NULL,'MIN',NULL,0),
(147,10,'2021-11-14 16:25:00','DEN',NULL,'PHI',NULL,0),
(148,10,'2021-11-14 16:25:00','GB',NULL,'SEA',NULL,0),
(149,10,'2021-11-14 20:20:00','OAK',NULL,'KC',NULL,0),
(150,10,'2021-11-15 20:15:00','SF',NULL,'LAR',NULL,0),
(151,11,'2021-11-18 20:20:00','ATL',NULL,'NE',NULL,0),
(152,11,'2021-11-21 13:00:00','BUF',NULL,'IND',NULL,0),
(153,11,'2021-11-21 13:00:00','CAR',NULL,'WAS',NULL,0),
(154,11,'2021-11-21 13:00:00','CHI',NULL,'BAL',NULL,0),
(155,11,'2021-11-21 13:00:00','CLE',NULL,'DET',NULL,0),
(156,11,'2021-11-21 13:00:00','JAX',NULL,'SF',NULL,0),
(157,11,'2021-11-21 13:00:00','MIN',NULL,'GB',NULL,0),
(158,11,'2021-11-21 13:00:00','NYJ',NULL,'MIA',NULL,0),
(159,11,'2021-11-21 13:00:00','PHI',NULL,'NO',NULL,0),
(160,11,'2021-11-21 13:00:00','TEN',NULL,'HOU',NULL,0),
(161,11,'2021-11-21 16:05:00','OAK',NULL,'CINs',NULL,0),
(162,11,'2021-11-21 16:25:00','KC',NULL,'DAL',NULL,0),
(163,11,'2021-11-21 16:25:00','SEA',NULL,'ARI',NULL,0),
(164,11,'2021-11-21 20:20:00','LAC',NULL,'PIT',NULL,0),
(165,11,'2021-11-22 20:15:00','TB',NULL,'NYG',NULL,0),
(166,12,'2021-11-25 12:30:00','DET',NULL,'CHI',NULL,0),
(167,12,'2021-11-25 16:30:00','DAL',NULL,'OAK',NULL,0),
(168,12,'2021-11-25 20:20:00','NO',NULL,'BUF',NULL,0),
(169,12,'2021-11-28 13:00:00','CINs',NULL,'PIT',NULL,0),
(170,12,'2021-11-28 13:00:00','HOU',NULL,'NYJ',NULL,0),
(171,12,'2021-11-28 13:00:00','IND',NULL,'TB',NULL,0),
(172,12,'2021-11-28 13:00:00','JAX',NULL,'ATL',NULL,0),
(173,12,'2021-11-28 13:00:00','MIA',NULL,'CAR',NULL,0),
(174,12,'2021-11-28 13:00:00','NE',NULL,'TEN',NULL,0),
(175,12,'2021-11-28 13:00:00','NYG',NULL,'PHI',NULL,0),
(176,12,'2021-11-28 16:05:00','DEN',NULL,'LAC',NULL,0),
(177,12,'2021-11-28 16:25:00','GB',NULL,'LAR',NULL,0),
(178,12,'2021-11-28 16:25:00','SF',NULL,'MIN',NULL,0),
(179,12,'2021-11-28 20:20:00','BAL',NULL,'CLE',NULL,0),
(180,12,'2021-11-29 20:15:00','WAS',NULL,'SEA',NULL,0),
(181,13,'2021-12-02 20:20:00','NO',NULL,'DAL',NULL,0),
(182,13,'2021-12-05 13:00:00','ATL',NULL,'TB',NULL,0),
(183,13,'2021-12-05 13:00:00','CHI',NULL,'ARI',NULL,0),
(184,13,'2021-12-05 13:00:00','CINs',NULL,'LAC',NULL,0),
(185,13,'2021-12-05 13:00:00','DET',NULL,'MIN',NULL,0),
(186,13,'2021-12-05 13:00:00','HOU',NULL,'IND',NULL,0),
(187,13,'2021-12-05 13:00:00','KC',NULL,'DEN',NULL,0),
(188,13,'2021-12-05 13:00:00','MIA',NULL,'NYG',NULL,0),
(189,13,'2021-12-05 13:00:00','NYJ',NULL,'PHI',NULL,0),
(190,13,'2021-12-05 16:05:00','OAK',NULL,'WAS',NULL,0),
(191,13,'2021-12-05 16:25:00','LAR',NULL,'JAX',NULL,0),
(192,13,'2021-12-05 16:25:00','PIT',NULL,'BAL',NULL,0),
(193,13,'2021-12-05 20:20:00','SEA',NULL,'SF',NULL,0),
(194,13,'2021-12-06 20:15:00','BUF',NULL,'NE',NULL,0),
(195,14,'2021-12-09 20:20:00','MIN',NULL,'PIT',NULL,0),
(196,14,'2021-12-12 13:00:00','CAR',NULL,'ATL',NULL,0),
(197,14,'2021-12-12 13:00:00','CINs',NULL,'SF',NULL,0),
(198,14,'2021-12-12 13:00:00','CLE',NULL,'BAL',NULL,0),
(199,14,'2021-12-12 13:00:00','HOU',NULL,'SEA',NULL,0),
(200,14,'2021-12-12 13:00:00','KC',NULL,'OAK',NULL,0),
(201,14,'2021-12-12 13:00:00','NYJ',NULL,'NO',NULL,0),
(202,14,'2021-12-12 13:00:00','TEN',NULL,'JAX',NULL,0),
(203,14,'2021-12-12 13:00:00','WAS',NULL,'DAL',NULL,0),
(204,14,'2021-12-12 16:05:00','DEN',NULL,'DET',NULL,0),
(205,14,'2021-12-12 16:05:00','LAC',NULL,'NYG',NULL,0),
(206,14,'2021-12-12 16:25:00','TB',NULL,'BUF',NULL,0),
(207,14,'2021-12-12 20:20:00','GB',NULL,'CHI',NULL,0),
(208,14,'2021-12-13 20:15:00','ARI',NULL,'LAR',NULL,0),
(209,15,'2021-12-16 20:20:00','LAC',NULL,'KC',NULL,0),
(210,15,'2021-12-19 13:00:00','BAL',NULL,'GB',NULL,0),
(211,15,'2021-12-19 13:00:00','BUF',NULL,'CAR',NULL,0),
(212,15,'2021-12-19 13:00:00','CLE',NULL,'OAK',NULL,0),
(213,15,'2021-12-19 13:00:00','DET',NULL,'ARI',NULL,0),
(214,15,'2021-12-19 13:00:00','IND',NULL,'NE',NULL,0),
(215,15,'2021-12-19 13:00:00','JAX',NULL,'HOU',NULL,0),
(216,15,'2021-12-19 13:00:00','MIA',NULL,'NYJ',NULL,0),
(217,15,'2021-12-19 13:00:00','NYG',NULL,'DAL',NULL,0),
(218,15,'2021-12-19 13:00:00','PHI',NULL,'WAS',NULL,0),
(219,15,'2021-12-19 13:00:00','PIT',NULL,'TEN',NULL,0),
(220,15,'2021-12-19 16:05:00','DEN',NULL,'CINs',NULL,0),
(221,15,'2021-12-19 16:05:00','SF',NULL,'ATL',NULL,0),
(222,15,'2021-12-19 16:25:00','LAR',NULL,'SEA',NULL,0),
(223,15,'2021-12-19 20:20:00','TB',NULL,'NO',NULL,0),
(224,15,'2021-12-20 20:15:00','CHI',NULL,'MIN',NULL,0),
(225,16,'2021-12-23 20:20:00','TEN',NULL,'SF',NULL,0),
(226,16,'2021-12-25 16:30:00','GB',NULL,'CLE',NULL,0),
(227,16,'2021-12-25 20:15:00','ARI',NULL,'IND',NULL,0),
(228,16,'2021-12-26 13:00:00','ATL',NULL,'DET',NULL,0),
(229,16,'2021-12-26 13:00:00','CAR',NULL,'TB',NULL,0),
(230,16,'2021-12-26 13:00:00','CINs',NULL,'BAL',NULL,0),
(231,16,'2021-12-26 13:00:00','HOU',NULL,'LAC',NULL,0),
(232,16,'2021-12-26 13:00:00','MIN',NULL,'LAR',NULL,0),
(233,16,'2021-12-26 13:00:00','NE',NULL,'BUF',NULL,0),
(234,16,'2021-12-26 13:00:00','NYJ',NULL,'JAX',NULL,0),
(235,16,'2021-12-26 13:00:00','PHI',NULL,'NYG',NULL,0),
(236,16,'2021-12-26 16:05:00','SEA',NULL,'CHI',NULL,0),
(237,16,'2021-12-26 16:25:00','KC',NULL,'PIT',NULL,0),
(238,16,'2021-12-26 16:25:00','OAK',NULL,'DEN',NULL,0),
(239,16,'2021-12-26 20:20:00','DAL',NULL,'WAS',NULL,0),
(240,16,'2021-12-27 20:15:00','NO',NULL,'MIA',NULL,0),
(241,17,'2022-01-02 13:00:00','BUF',NULL,'ATL',NULL,0),
(242,17,'2022-01-02 13:00:00','CHI',NULL,'NYG',NULL,0),
(243,17,'2022-01-02 13:00:00','CINs',NULL,'KC',NULL,0),
(244,17,'2022-01-02 13:00:00','DAL',NULL,'ARI',NULL,0),
(245,17,'2022-01-02 13:00:00','IND',NULL,'OAK',NULL,0),
(246,17,'2022-01-02 13:00:00','NE',NULL,'JAX',NULL,0),
(247,17,'2022-01-02 13:00:00','NO',NULL,'CAR',NULL,0),
(248,17,'2022-01-02 13:00:00','NYJ',NULL,'TB',NULL,0),
(249,17,'2022-01-02 13:00:00','TEN',NULL,'MIA',NULL,0),
(250,17,'2022-01-02 13:00:00','WAS',NULL,'PHI',NULL,0),
(251,17,'2022-01-02 16:05:00','LAC',NULL,'DEN',NULL,0),
(252,17,'2022-01-02 16:05:00','SF',NULL,'HOU',NULL,0),
(253,17,'2022-01-02 16:25:00','BAL',NULL,'LAR',NULL,0),
(254,17,'2022-01-02 16:25:00','SEA',NULL,'DET',NULL,0),
(255,17,'2022-01-02 20:20:00','GB',NULL,'MIN',NULL,0),
(256,17,'2022-01-03 20:15:00','PIT',NULL,'CLE',NULL,0),
(257,18,'2022-01-09 13:00:00','ATL',NULL,'NO',NULL,0),
(258,18,'2022-01-09 13:00:00','BAL',NULL,'PIT',NULL,0),
(259,18,'2022-01-09 13:00:00','BUF',NULL,'NYJ',NULL,0),
(260,18,'2022-01-09 13:00:00','CLE',NULL,'CINs',NULL,0),
(261,18,'2022-01-09 13:00:00','DET',NULL,'GB',NULL,0),
(262,18,'2022-01-09 13:00:00','HOU',NULL,'TEN',NULL,0),
(263,18,'2022-01-09 13:00:00','JAX',NULL,'IND',NULL,0),
(264,18,'2022-01-09 13:00:00','MIA',NULL,'NE',NULL,0),
(265,18,'2022-01-09 13:00:00','MIN',NULL,'CHI',NULL,0),
(266,18,'2022-01-09 13:00:00','NYG',NULL,'WAS',NULL,0),
(267,18,'2022-01-09 13:00:00','PHI',NULL,'DAL',NULL,0),
(268,18,'2022-01-09 13:00:00','TB',NULL,'CAR',NULL,0),
(269,18,'2022-01-09 16:25:00','ARI',NULL,'SEA',NULL,0),
(270,18,'2022-01-09 16:25:00','DEN',NULL,'KC',NULL,0),
(271,18,'2022-01-09 16:25:00','OAK',NULL,'LAC',NULL,0),
(272,18,'2022-01-09 16:25:00','LAR',NULL,'SF',NULL,0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Results