Superbowl Fun Stats

Wins, losses, other states like largest score gap, most wins, etc.

@kaggle.damonnarkiewicz_superbowl_fun_stats

Table List

4 tables(27.39 KB)

Last10

Sblargestgap

Super Bowl Ratings

Superbowldata

Super Bowl Ratings

@kaggle.damonnarkiewicz_superbowl_fun_stats.super_bowl_ratings

9.48 KB
58 rows
9 columns

super_bowl Super Bowl	super_bowl_number Super Bowl Number	date Date	network Network	average_viewers Average Viewers	total_viewers Total Viewers	household_rating Household Rating	household_share Household Share	cost_of_30_second_ad_usd Cost Of 30 Second Ad Usd
I	1	Sun Jan 15 1967 00:00:00 GMT+0000 (Coordinated Universal Time)	NBC	24430000	35600000	18.5	36	37500
II	2	Sun Jan 14 1968 00:00:00 GMT+0000 (Coordinated Universal Time)	CBS	39120000	51300000	36.8	68	54500
III	3	Sun Jan 12 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	NBC	41660000	54500000	36	70	55000
IV	4	Sun Jan 11 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	CBS	44270000	59200000	39.4	69	78200
V	5	Sun Jan 17 1971 00:00:00 GMT+0000 (Coordinated Universal Time)	NBC	46040000	58500000	39.9	75	72500
VI	6	Sun Jan 16 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	CBS	56640000	67300000	44.2	74	86100
VII	7	Sun Jan 14 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	NBC	53320000	67700000	42.7	72	88100
VIII	8	Sun Jan 13 1974 00:00:00 GMT+0000 (Coordinated Universal Time)	CBS	51700000	63200000	41.6	73	103500
IX	9	Sun Jan 12 1975 00:00:00 GMT+0000 (Coordinated Universal Time)	NBC	56050000	71300000	42.4	72	107000
X	10	Sun Jan 18 1976 00:00:00 GMT+0000 (Coordinated Universal Time)	CBS	57710000	73300000	42.3	78	110000


CREATE TABLE super_bowl_ratings (
  "super_bowl" VARCHAR,
  "super_bowl_number" BIGINT,
  "date" TIMESTAMP,
  "network" VARCHAR,
  "average_viewers" BIGINT,
  "total_viewers" DOUBLE,
  "household_rating" DOUBLE,
  "household_share" DOUBLE,
  "cost_of_30_second_ad_usd" DOUBLE
);