Top Music Singles – Historical Data – SQL & CSV.

A download that contains the top-selling music singles from the past 40+ years. The data is available in SQL and CSV formats (both formats are contained in the ZIP file). Screenshot from phpMyAdmin:

Top Selling Singles

The data contains a list of the top-selling / chart-topping singles for both the United States and the United Kingdom. The data ranges from the start of 1960 to the end of 2013.

Example snippet from the CSV file (2009):

The columns:

  • id: Unique integer value / primary key.
  • dafeFrom: The date from which the song was on top of the singles charts.
  • name: The name of the song and the music artist that released it.
  • country: The country (this will be the United States or the United Kingdom).

Example SQL query – Finding all chart-topping singles by Britney Spears:

Result:

Britney Spears top singles.

Selecting music singles data from the early 1990s:

Result snippet (shown in CSV format):

Comments

comments