Name: College Football Fight Songs
Creator: FiveThirtyEight
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

College Football Fight Songs

This dataset includes information on the fight songs of all schools in the NCAA Power Five conferences — ACC, Big Ten, Big 12, Pac-12, and SEC — plus Notre Dame.
For each song, it includes metadata such as the school, songwriter, year, whether it’s officially recognized, and how it was selected.
It also includes lyrical analysis based on common themes or 'tropes' like references to 'fight,' 'victory,' 'rah,' or school colors.
Musical attributes like tempo (bpm) and duration are based on available Spotify recordings.

Tables

College Fight Songs With Tropes And Musical Features

@fivethirtyeight.fight_songs.fight_songs

20.65 KB
65 rows
23 columns


CREATE TABLE fight_songs (
  "school" VARCHAR,
  "conference" VARCHAR,
  "song_name" VARCHAR,
  "writers" VARCHAR,
  "year" VARCHAR,
  "student_writer" VARCHAR,
  "official_song" VARCHAR,
  "contest" VARCHAR,
  "bpm" BIGINT,
  "sec_duration" BIGINT,
  "fight" VARCHAR,
  "number_fights" BIGINT,
  "victory" VARCHAR,
  "win_won" VARCHAR,
  "victory_win_won" VARCHAR,
  "rah" VARCHAR,
  "nonsense" VARCHAR,
  "colors" VARCHAR,
  "men" VARCHAR,
  "opponents" VARCHAR,
  "spelling" VARCHAR,
  "trope_count" BIGINT,
  "spotify_id" VARCHAR
);