College Football Bowl Games (1902 - 2022)

Data from every college football bowl game (1902 - 2022)

@kaggle.mattop_college_football_bowl_games_1902_2022

Table List

1 table(85.25 KB)

Collegefootballbowl

@kaggle.mattop_college_football_bowl_games_1902_2022.collegefootballbowl

85.25 KB
1527 rows
14 columns

id Id	year Year	date Date	day Day	winner_tie Winner Tie	winner_rank Winner Rank	winner_points Winner Points	loser_tie Loser Tie	loser_rank Loser Rank	loser_points Loser Points	attendance Attendance	mvp Mvp	sponsor Sponsor	bowl_name Bowl Name
1	2021	Wed Dec 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed	Oklahoma	14	47	Oregon	15	32	59121	Oklahoma RB Kennedy Brooks, Oklahoma S Pat Fields	Valero	Alamo Bowl
2	2020	Tue Dec 29 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue	Texas	20	55	Colorado	nan	23	10822	Texas RB Bijan Robinson, Texas LB DeMarvion Overshown	Valero	Alamo Bowl
3	2019	Tue Dec 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue	Texas	nan	38	Utah	12	10	60147	Texas QB Sam Ehlinger, Texas LB Joseph Ossai	Valero	Alamo Bowl
4	2018	Fri Dec 28 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri	Washington State	12	28	Iowa State	25	26	60675	Washington State QB Gardner Minshew, Washington State LB Peyton Pelluer	Valero	Alamo Bowl
5	2017	Thu Dec 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu	Texas Christian	13	39	Stanford	15	37	57653	TCU QB Kenny Hill, TCU LB Travin Howard	Valero	Alamo Bowl
6	2016	Thu Dec 29 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu	Oklahoma State	13	38	Colorado	11	8	59815	OSU WR James Washington, OSU DT Vincent Taylor	Valero	Alamo Bowl
7	2015	Sat Jan 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat	Texas Christian	11	47	Oregon	15	41	64569	TCU QB Brian Kohlhausen, TCU S Travin Howard	Valero	Alamo Bowl
8	2014	Fri Jan 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri	UCLA	14	40	Kansas State	11	35	60517	RB Paul Perkins (UCLA), LB Eric Kendricks (UCLA)	Valero	Alamo Bowl
9	2013	Mon Dec 30 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon	Oregon	10	30	Texas	nan	7	65918	QB Marcus Mariota (Oregon), SS Avery Patterson (Oregon)	Valero Energy Corporation	Alamo Bowl
10	2012	Sat Dec 29 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat	Texas	nan	31	Oregon State	15	27	65277	WR Marquise Goodwin (Texas), DL Alex Okafor (Texas)	Valero Energy Corporation	Alamo Bowl


CREATE TABLE collegefootballbowl (
  "id" BIGINT,
  "year" BIGINT,
  "date" TIMESTAMP,
  "day" VARCHAR,
  "winner_tie" VARCHAR,
  "winner_rank" VARCHAR,
  "winner_points" BIGINT,
  "loser_tie" VARCHAR,
  "loser_rank" VARCHAR,
  "loser_points" BIGINT,
  "attendance" DOUBLE,
  "mvp" VARCHAR,
  "sponsor" VARCHAR,
  "bowl_name" VARCHAR
);