fivethirtyeight: fight-songs/fight-songs: 65 rows

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 · About: simonw/fivethirtyeight-datasette

65 rows

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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

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
);

fight-songs: fight-songs.csv

65 rows

Advanced export