Baselight

Classic Rock Song Airplay Data

Radio Airplay and Song Information for Classic Rock Tracks

@fivethirtyeight.classic_rock

Classic Rock Songs And Airplay Data
@fivethirtyeight.classic_rock.classic_rock_songs

Column Description
Song Clean The name of the song
ARTIST CLEAN The name of the artist
Release Year The year the song was released, according to SongFacts. Blank if no entry found
COMBINED Combined field of song and artist, used to connect with classic-rock-raw-data
First? Always 1 (indicates first occurrence)
Year? 1 if a release year was found, 0 if not
PlayCount Number of times the song was played across all stations
F*G Number of plays of the song across all stations, if a release year was found
  • 96.15 KB
  • 2229 rows
  • 8 columns
song_clean

Song Clean

artist_clean

ARTIST CLEAN

release_year

Release Year

combined

COMBINED

first

First?

year

Year?

playcount

PlayCount

f_g

F*G

Caught Up in You.38 Special1982Caught Up in You by .38 Special118282
Fantasy Girl.38 SpecialFantasy Girl by .38 Special13
Hold On Loosely.38 Special1981Hold On Loosely by .38 Special118585
Rockin' Into the Night.38 Special1980Rockin' Into the Night by .38 Special111818
Art For Arts Sake10cc1975Art For Arts Sake by 10cc1111
Kryptonite3 Doors Down2000Kryptonite by 3 Doors Down111313
Loser3 Doors Down2000Loser by 3 Doors Down1111
When I'm Gone3 Doors Down2002When I'm Gone by 3 Doors Down1166
What's Up?4 Non Blondes1992What's Up? by 4 Non Blondes1133
Take On Mea-ha1985Take On Me by a-ha1111

CREATE TABLE classic_rock_songs (
  "song_clean" VARCHAR,
  "artist_clean" VARCHAR,
  "release_year" VARCHAR,
  "combined" VARCHAR,
  "first" BIGINT,
  "year" BIGINT,
  "playcount" BIGINT,
  "f_g" BIGINT
);

Share link

Anyone who has the link will be able to view this.