NCAA Bowl Games
Explore College Football History: NCAA bowl games data from 1902 to today!
@kaggle.jonathanpilafas_ncaa_bowl_games
Explore College Football History: NCAA bowl games data from 1902 to today!
@kaggle.jonathanpilafas_ncaa_bowl_games
Excited to share a glimpse into the world of college football! Just finished building a dashboard in Domo that dives into the historical data of NCAA bowl games. Explore the journey of college football from 1902 to today at this link: https://public.domo.com/embed/pages/Z4PoJ.
This interactive dashboard provides a comprehensive view of past bowl games, which includes the final scores, sponsorships, game locations, and more. Whether you're a sports enthusiast or are a data geek, this dashboard brings the history of college football to life through data analytics.
Huge kudos to the Domo platform for making this process a breeze with its user-friendly design! Check out the dashboard, let me know your thoughts, and share some more ideas for similar dashboard designs!
CREATE TABLE ncaa_bowl_games (
"bowl_name" VARCHAR,
"year" BIGINT,
"date" VARCHAR,
"day" VARCHAR,
"winner_tie" VARCHAR,
"winner_pts" BIGINT,
"loser_tie" VARCHAR,
"loser_pts" BIGINT,
"attendance" BIGINT,
"mvp" VARCHAR,
"sponsor" VARCHAR,
"game" VARCHAR -- Game?,
"covid_flag" VARCHAR,
"bowl_location_site_name" VARCHAR,
"bowl_location_city" VARCHAR,
"bowl_location_state" VARCHAR,
"bowl_location_zip" BIGINT,
"winner_tie_stripped" VARCHAR,
"loser_tie_stripped" VARCHAR,
"zip" BIGINT,
"zip_string_leading_zeroes" VARCHAR,
"zip_string" VARCHAR,
"fips" BIGINT,
"fips_string" VARCHAR,
"state" VARCHAR,
"county_name" VARCHAR,
"n__batch_id" BIGINT -- BATCH ID,
"n__batch_last_run" TIMESTAMP -- BATCH LAST RUN,
"winner_conference" VARCHAR -- Winner | Conference,
"winner_ncaa_division" VARCHAR -- Winner | NCAA Division,
"winner_defunct" VARCHAR -- Winner | Defunct?,
"loser_conference" VARCHAR -- Loser | Conference,
"loser_ncaa_division" VARCHAR -- Loser | NCAA Division,
"loser_defunct" VARCHAR -- Loser | Defunct?
);Anyone who has the link will be able to view this.