NFL ELO Ratings

NFL ELO Game & Quarterback Ratings 1920 - 2021

@kaggle.dtrade84_nfl_elo_ratings

Table List

1 table(2.93 MB)

Nfl Elo

@kaggle.dtrade84_nfl_elo_ratings.nfl_elo

2.93 MB
17095 rows
33 columns

date Date	season Season	playoff Playoff	team1 Team1	team2 Team2	elo1_pre Elo1 Pre	elo2_pre Elo2 Pre	elo_prob1 Elo Prob1	elo_prob2 Elo Prob2	elo1_post Elo1 Post	elo2_post Elo2 Post	qb1 Qb1	qb2 Qb2	score1 Score1	score2 Score2
Sun Sep 26 1920 00:00:00 GMT+0000 (Coordinated Universal Time)	1920	nan	RII	STP	1503.947	1300	0.8246512009492516	0.1753487990507484	1516.108	1287.838	nan	nan	48
Sun Oct 03 1920 00:00:00 GMT+0000 (Coordinated Universal Time)	1920	nan	CBD	PTQ	1504.688	1300	0.8252671507782987	0.1747328492217013	1516.803	1287.885	nan	nan	48
Sun Oct 03 1920 00:00:00 GMT+0000 (Coordinated Universal Time)	1920	nan	CHI	MUT	1368.333	1300	0.6829855714913705	0.3170144285086295	1386.533	1281.8	nan	nan	20
Sun Oct 03 1920 00:00:00 GMT+0000 (Coordinated Universal Time)	1920	nan	RII	MUN	1516.108	1478.004	0.6441710901126361	0.3558289098873639	1542.135	1451.977	nan	nan	45
Sun Oct 03 1920 00:00:00 GMT+0000 (Coordinated Universal Time)	1920	nan	DAY	COL	1493.002	1504.908	0.5758191240920725	0.4241808759079275	1515.434	1482.475	nan	nan	14
Sun Oct 03 1920 00:00:00 GMT+0000 (Coordinated Universal Time)	1920	nan	RCH	ABU	1503.42	1300	0.8242120973373386	0.1757879026626614	1510.934	1292.486	nan	nan	10
Sun Oct 03 1920 00:00:00 GMT+0000 (Coordinated Universal Time)	1920	nan	BFF	WBU	1478.004	1300	0.8020003005487033	0.1979996994512967	1489.757	1288.247	nan	nan	32	6
Sun Oct 03 1920 00:00:00 GMT+0000 (Coordinated Universal Time)	1920	nan	AKR	WHE	1503.42	1300	0.8242120973373386	0.1757879026626614	1515.278	1288.142	nan	nan	43
Sun Oct 10 1920 00:00:00 GMT+0000 (Coordinated Universal Time)	1920	nan	RII	HAM	1542.135	1444.259	0.7186125156699114	0.2813874843300886	1559.405	1426.99	nan	nan	26
Sun Oct 10 1920 00:00:00 GMT+0000 (Coordinated Universal Time)	1920	nan	RCH	FTP	1510.934	1300	0.8303914086394528	0.1696085913605471	1523.607	1287.327	nan	nan	66


CREATE TABLE nfl_elo (
  "date" TIMESTAMP,
  "season" BIGINT,
  "neutral" BIGINT,
  "playoff" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "elo1_pre" DOUBLE,
  "elo2_pre" DOUBLE,
  "elo_prob1" DOUBLE,
  "elo_prob2" DOUBLE,
  "elo1_post" DOUBLE,
  "elo2_post" DOUBLE,
  "qbelo1_pre" DOUBLE,
  "qbelo2_pre" DOUBLE,
  "qb1" VARCHAR,
  "qb2" VARCHAR,
  "qb1_value_pre" DOUBLE,
  "qb2_value_pre" DOUBLE,
  "qb1_adj" DOUBLE,
  "qb2_adj" DOUBLE,
  "qbelo_prob1" DOUBLE,
  "qbelo_prob2" DOUBLE,
  "qb1_game_value" DOUBLE,
  "qb2_game_value" DOUBLE,
  "qb1_value_post" DOUBLE,
  "qb2_value_post" DOUBLE,
  "qbelo1_post" DOUBLE,
  "qbelo2_post" DOUBLE,
  "score1" BIGINT,
  "score2" BIGINT,
  "quality" DOUBLE,
  "importance" DOUBLE,
  "total_rating" DOUBLE
);