fight-songs: fight-songs.csv

This table contains data behind the story Our Guide To The Exuberant Nonsense Of College Fight Songs.

fight-songs.csv contains data about fight songs from all schools in the Power Five conferences — the ACC, Big Ten, Big 12, Pac-12 and SEC — plus Notre Dame. Some schools have more than one fight song, and some of the songs sanctioned as “official” by their schools aren’t the ones that fans sing out. We chose the songs that seemed best-known and best-loved. We also limited our analysis to the lyrics sung most regularly and also published by the school, so some verses were not included in the analysis. The tempo and length information come from the version of the song we chose from those available on Spotify.

Column definitions:

Column Description
school School name
conference School college football conference
song_name Song title
writers Song author
year Year the song written. Some values are Unknown
student_writer Was the author a student? Some values are Unknown
official_song Is the song the official fight song according to the university?
contest Was the song chosen as the result of a contest?
bpm Beats per minute
sec_duration Duration of song in seconds
fight Does the song say “fight”?
number_fights Number of times the song says “fight”?
victory Does the song say “victory”?
win_won Does the song say “win” or “won”?
victory_win_won Does the song say “victory,” “win” or “won”?
rah Does the song say “rah”?
nonsense Does the song use nonsense syllables (e.g. "Whoo-Rah" or "Hooperay")
colors Does the song mention the school colors?
men Does the song refer to a group of men (e.g. men, boys, sons, etc.)?
opponents Does the song mention any opponents?
spelling Does the song spell anything?
trope_count Total number of tropes (fight, victory, win_won, rah, nonsense,colors, men, opponents, and spelling).
spotify_id Spotify id for the song

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

65 rows

View and edit SQL

Suggested facets: conference, student_writer, official_song, contest, fight, number_fights, victory, win_won, victory_win_won, rah, nonsense, colors, men, opponents, spelling, trope_count

Link rowid school conference song_name writers year student_writer official_song contest bpm sec_duration fight number_fights victory win_won victory_win_won rah nonsense colors men opponents spelling trope_count spotify_id
1 Notre Dame Independent Victory March Michael J. Shea and John F. Shea 1908 No Yes No 152 64 Yes 1 Yes Yes Yes Yes No Yes Yes No No 6 15a3ShKX3XWKzq0lSS48yr
2 Baylor Big 12 Old Fight Dick Baker and Frank Boggs 1947 Yes Yes No 76 99 Yes 4 Yes Yes Yes No No Yes No No Yes 5 2ZsaI0Cu4nz8DHfBkPt0Dl
3 Iowa State Big 12 Iowa State Fights Jack Barker, Manly Rice, Paul Gnam, Rosalind K. Cook 1930 Yes Yes No 155 55 Yes 5 No No No Yes No No Yes No Yes 4 3yyfoOXZQCtR6pfRJqu9pl
4 Kansas Big 12 I'm a Jayhawk George "Dumpy" Bowles 1912 Yes Yes No 137 62 No 0 No No No No Yes No Yes Yes No 3 0JzbjZgcjugS0dmPjF9R89
5 Kansas State Big 12 Wildcat Victory Harry E. Erickson 1927 Yes Yes No 80 67 Yes 6 Yes No Yes No No Yes No No No 3 4xxDK4g1OHhZ44sTFy8Ktm
6 Oklahoma Big 12 Boomer Sooner Arthur M. Alden 1905 Yes Yes No 153 37 No 0 No No No Yes No No No No Yes 2 0QXC8Gg1oKWkORegslTXoT
7 Oklahoma State Big 12 Ride 'Em Cowboys J.K. Long 1934 No Yes No 180 29 Yes 5 Yes No Yes No No No Yes Yes No 4 0mTJqaacUZPG740Y1YDn5j
8 Texas Big 12 Texas Fight Walter S. Hunnicutt, James E. King and Burnett Pharr 1923 No Yes No 81 65 Yes 17 No Yes Yes No No Yes No Yes No 4 53CytfvDMSkJHY5PtrcZiD
9 TCU Big 12 TCU Fight Song Claude Sammis 1928 No Yes No 149 47 Yes 2 Yes No Yes Yes No Yes Yes No Yes 6 0ItcRLvqHlbkaqMCPtQKUl
10 Texas Tech Big 12 Fight, Raiders, Fight Carroll McMath 1936 Yes Yes No 159 54 Yes 8 Yes No Yes No No Yes No No No 3 3DfKi9Iqvtxf4DIjs8ezTq
11 West Virginia Big 12 Hail West Virginia Earl Miller, Ed McWhorter and Fred Deem 1915 Yes Yes No 152 92 No 0 No No No No No No Yes No No 1 1VqZp811UsBJy66R8TTkei
12 Illinois Big Ten Oskee-Wow-Wow H.R. Green and H.V. Hill 1910 Yes Yes No 162 60 No 0 Yes No Yes Yes Yes Yes Yes Yes No 6 6C0vaoMxzM21yYgJBmGx5K
13 Indiana Big Ten Indiana, Our Indiana Russell P. Harker and Karl L. King 1912 Yes Yes No 150 63 Yes 1 No No No No No Yes No No Yes 3 2Wbo5zdRDnq4pOgWL9avaG
14 Iowa Big Ten Iowa Fight Song Meredith Willson 1950 No Yes No 150 72 Yes 9 No Yes Yes Yes No No No No No 3 604ELPPFgbFlW0SHoEYVJw
15 Maryland Big Ten Maryland Fight Song Ralph Davis 1939 Yes Yes No 142 56 Yes 8 Yes Yes Yes No No No No No No 3 6PKoPWKJLOBI2K33RkFvbc
16 Michigan Big Ten The Victors Louis Elbel 1898 Yes Yes No 83 122 No 0 No No No No No No No No No 0 6wVbHLCBOCqp6052WcWXLG
17 Michigan State Big Ten Victory for MSU Francis Irving Lankey and Arthur L. Sayles 1915 Yes Yes No 145 112 Yes 6 Yes Yes Yes Yes No Yes No No Yes 5 4BSrPApxbeUNPA5Q8LyfMd
18 Minnesota Big Ten The Minnesota Rouser Floyd Hutsell 1909 No Yes Yes 151 60 No 0 No No No Yes Yes No No No Yes 3 2EeyLSmHKdZulOKGcTpLS0
19 Nebraska Big Ten Dear Old Nebraska U. Harry Pecha 1924 Yes No No 136 94 No 0 No No No No No No Yes No No 1 7z2TihIyf3IZR1r0AmI1Ik
20 Northwestern Big Ten Go! U Northwestern Theodore C. Van Etten 1912 Yes Yes No 140 57 Yes 1 Yes Yes Yes Yes No No No No No 4 4iWO9U49SZ0vvzto7qxRxN
21 Ohio State Big Ten Buckeye Battle Cry Frank Crumit 1919 No Yes Yes 178 89 Yes 1 Yes Yes Yes No No Yes Yes No No 5 2faIedehtxwQqYxRRc6T2L
22 Penn State Big Ten Fight On, State Joseph Sanders 1933 No Yes No 145 81 Yes 5 Yes Yes Yes No No Yes No No Yes 5 5InlNNfIFQAvCL78VFgR5O
23 Purdue Big Ten Hail Purdue James R. Morrison and Edward S. Wotawa 1912 Yes Yes No 160 86 No 0 Yes No Yes No No Yes No No No 2 1bYZgec19T5gQJAUeIzq9W
24 Rutgers Big Ten The Bells Must Ring Richard Hadden and W.E. Sanford 1931 Yes Yes Yes 75 74 Yes 10 Yes Yes Yes Yes Yes Yes Yes No Yes 8 7EdGMXzZjJKNHJaszbWTHi
25 Wisconsin Big Ten On, Wisconsin William Purdy and Carl Beck 1909 No Yes No 132 134 Yes 5 No Yes Yes No No No Yes No No 3 4DmMOLdp4ZYvrAqemDBBbJ
26 Arizona Pac-12 Bear Down, Arizona Jack K. Lee 1952 No No No 144 83 No 0 No No No No No Yes No No No 1 2ckfyC5awK1YD3kbOfCHeP
27 Arizona State Pac-12 Maroon and Gold Felix McKernan 1948 No Yes No 150 106 Yes 3 Yes No Yes No No Yes No No Yes 4 138TmlsqwA1J0pGeJBoGUS
28 California Pac-12 Fight for California Earl Elleson McCoy and Robert N. Fitch 1909 No Yes No 134 88 Yes 2 Yes Yes Yes No No Yes Yes No No 5 06Qz83gVtmHtWTClrucgjX
29 Colorado Pac-12 Fight CU Richard Durnett Unknown Unknown Yes No 151 27 Yes 8 Yes Yes Yes No No No No No Yes 4 0Q3VKlBT4lugyLG5n9LKIz
30 Oregon Pac-12 Mighty Oregon DeWitt Gilbert and Albert John Perfect 1916 Yes Yes No 65 80 Yes 2 Yes Yes Yes No No No Yes Yes No 5 4zPgdoDF3Od2dwQdPlGJtt
31 Oregon State Pac-12 Hail to Old OSU Harold Wilkins 1914 No Yes No 137 63 Yes 2 No No No No No No No No Yes 2 4IV43tyrxewZDmBMp2rtHh
32 Stanford Pac-12 Come Join the Band Aurania Ellerbeck Rouverol, Robert Browne Hall 1907 Yes Yes No 135 63 No 0 No Yes Yes No No Yes Yes No No 3 3Zw53YIiVtdcQBmwbBQ2JS
33 UCLA Pac-12 Sons of Westwood Harold P. Williams and N. Loyall McLaren; Kelly James 1959 No Yes No 72 69 Yes 3 No No No No No Yes Yes Yes Yes 5 0XxQcPAThn9dOZ6NVFUfGl
34 USC Pac-12 Fight On, USC Milo Sweet 1922 Yes Yes Yes 75 60 Yes 5 Yes Yes Yes No No No Yes No Yes 5 23EM48kuqZWVltXE9bApcK
35 Utah Pac-12 Utah Man Harvey Holmes and the football team 1904 No Yes No 168 66 Yes 1 No No No No Yes Yes Yes No No 4 5pwoauvjUb3aRkDDvibaco
36 Washington Pac-12 Bow Down to Washington Lester J. Wilson 1915 No Yes Yes 139 89 Yes 1 Yes No Yes Yes No Yes No No No 4 0OLQPcJ1jMwrXJbt81hHrx
37 Washington State Pac-12 The Fight Song Zella Melcher and Phyllis Sayles 1919 Yes Yes No 81 64 Yes 7 Yes Yes Yes No No Yes No No Yes 5 5VErX42t9bSJGas8aOtQyD
38 Alabama SEC Yea Alabama Ethelred Lundy (Epp) Sykes 1926 Yes Yes Yes 153 59 Yes 3 Yes Yes Yes No No Yes Yes Yes No 6 1lkKK6lbsPYD6n5QZbiH1q
39 Arkansas SEC Arkansas Fight William Edwin Douglass 1913 Yes Yes No 77 88 Yes 3 No No No Yes No No No No Yes 3 20iLjYvQOdAO3lPYkfycGn
40 Auburn SEC War Eagle Robert Allen and Al Stillman 1955 No Yes No 77 27 Yes 1 Yes Yes Yes No No Yes No No No 4 1WSPADIiYIO5GfNTJ2vwnM
41 Florida SEC The Orange and Blue George Hamilton and Thornton Whitney Allen 1925 No Yes No 71 66 Yes 1 No No No No No Yes No No No 2 15yyBZUfgNbft50mMB7a4V
42 Georgia SEC Glory, Glory Hugh Hodgson, based on traditional song 1915 Yes No No 162 41 No 0 No No No No No No No No Yes 1 7masdC1Jz6f4okFu4tAwOz
43 Kentucky SEC On! On! U of K Troy Perkins and Charles A. Lampert 1923 Yes Yes Yes 79 52 Yes 4 Yes Yes Yes No No Yes No No Yes 5 6QMYhg8EaZm7P1n4FZrCWB
44 LSU SEC Fight for LSU Castro Carazo and W.G. Higginbotham 1937 No Yes No 168 83 Yes 5 No Yes Yes Yes No Yes No No Yes 5 5AeAxCC07c4eyWY8eKopQ4
45 Mississippi SEC Forward Rebels E.F. Yerby Unknown Unknown Yes No 153 65 Yes 6 Yes Yes Yes No No Yes No No No 4 301ClIQs4cI8poO11mklxg
46 Mississippi State SEC Hail State Joseph Peavey 1936 No Yes Yes 146 54 Yes 2 Yes Yes Yes No No No No No Yes 4 3WN6SK7WfjUSRDFH4PlMNV
47 Missouri SEC Fight Tiger Donald MacKay and Robert Karsch 1946 Yes Yes Yes 138 86 Yes 4 Yes Yes Yes No No No No No No 3 4nrVmzJetWGvMa3OKGJm2Q
48 South Carolina SEC The Fighting Gamecocks Lead the Way (Step to the Rear) Paul Dietzel and Elmer Bernstein, arranged by James Pritchard 1968 No Yes No 153 64 Yes 4 No Yes Yes No No Yes No No Yes 4 65X66oBRmSp8gDkoRGbLjD
49 Tennessee SEC Rocky Top Felice and Boudleaux Bryant 1967 No No No 149 53 No 0 No No No No No No No No No 0 5BRY9YO0PDey8RQcDOV9aP
50 Texas A&M SEC Aggie War Hymn J.V. “Pinky” Wilson 1918 Yes No Yes 117 172 Yes 1 No No No No Yes No Yes Yes No 4 4mssGSMkmNIv0XR5e6j9Ky
51 Vanderbilt SEC Dynamite Francis Craig 1941 No Yes No 72 45 Yes 3 Yes Yes Yes No No No No No No 3 5tXWqJHiTDHRYtOngsBPAW
52 Boston College ACC For Boston T.J. Hurley Unknown No Yes No 147 84 No 0 No No No No No No No No No 0 4E8cLR6NcYCCJWqD2iwz7c
53 Clemson ACC Tiger Rag Original Dixieland Jass Band 1917 No Yes No 145 78 No 0 No No No No No No No No Yes 1 7hGtgN4N9ebZTlC7xhvKIE
54 Duke ACC Fight Blue Devils Joe Hewitt and Doug Ballin 1947 No Yes No 139 58 Yes 5 No Yes Yes No No Yes No Yes No 4 0fDiYvMTYWSSrIuHVJGMZj
55 Florida State ACC FSU Fight Song Doug Alley and Tommie Wright 1950 Yes Yes No 135 92 Yes 6 Yes Yes Yes No Yes No No No Yes 5 552UZRLtAO5YXvIVRLjphI
56 Georgia Tech ACC Ramblin' Wreck From Georgia Tech Unknown Unknown Yes Yes No 148 68 No 0 No No No No No Yes Yes Yes No 3 0ZOzvjnZDwrtluHrwbtvGR
57 Louisville ACC Fight! U of L Robert B. Griffith 1962 No Yes No 139 80 Yes 3 Yes Yes Yes Yes No No No No Yes 5 1sCmJDLWfD4hsCHyc9hqUr
58 Miami ACC Miami U How-Dee-Doo Henry Fillmore 1950 No Yes No 75 73 Yes 3 Yes No Yes No No No No No Yes 3 2TDHghruqAnMmH4L9GFUUr
59 North Carolina ACC I'm a Tar Heel Born Unknown Unknown Unknown Yes No 158 38 No 0 No No No Yes No No No No No 1 23cCr6w4YgxQaYlr3eNTUr
60 North Carolina State ACC The Red & White Song J. Perry Watson 1961 No No No 90 82 No 0 No No No No No Yes No Yes Yes 3 2Pn76lkyMhOxJj8maIrIRT
61 Pitt ACC Hail to Pitt George Kirk and Lester Milton Taylor 1911 Yes Yes No 79 110 No 0 Yes Yes Yes No Yes Yes Yes No Yes 6 55nndPja6lpTsGMinT1SJy
62 Syracuse ACC Down the Field Ralph Murphy and C. Harold Lewis 1914 Yes Yes No 137 85 Yes 3 Yes No Yes Yes No Yes Yes Yes No 6 4zrPkQ9AFljRbPy0JNW6cA
63 Virginia ACC The Good Old Song Edward H. Craighill 1893 Yes No No 112 42 No 0 No No No Yes Yes No No No Yes 3 4zymLpKnHG2KURvrSUyUy8
64 Virginia Tech ACC Tech Triumph Wilfred P. Maddux and Mattie Eppes 1919 Yes Yes No 133 71 No 0 No Yes Yes No Yes Yes Yes No Yes 5 5v3wGg8VMD8MMYGb8SXBss
65 Wake Forest ACC O Here's To Wake Forest C.P. Weaver 1908 No Yes No 146 69 No 0 No No No Yes No Yes Yes No No 3 3u6THWNCTIdCcGIcJ1FQsN

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "fight-songs/fight-songs" (
"school" TEXT,
  "conference" TEXT,
  "song_name" TEXT,
  "writers" TEXT,
  "year" TEXT,
  "student_writer" TEXT,
  "official_song" TEXT,
  "contest" TEXT,
  "bpm" INTEGER,
  "sec_duration" INTEGER,
  "fight" TEXT,
  "number_fights" INTEGER,
  "victory" TEXT,
  "win_won" TEXT,
  "victory_win_won" TEXT,
  "rah" TEXT,
  "nonsense" TEXT,
  "colors" TEXT,
  "men" TEXT,
  "opponents" TEXT,
  "spelling" TEXT,
  "trope_count" INTEGER,
  "spotify_id" TEXT
)
Powered by Datasette · Query took 71.671ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub