SQLite export of all Magnatune data
Download from:
http://he3.magnatune.com/info/sqlite_magnatune.db
or
http://he3.magnatune.com/info/sqlite_magnatune.db.gz
You should be able to open the database file up directly from inside SQLite. Feel free to have your own software program(s) automatically download from this URL, it is stable. Please download the gzipped version of the file if you have gzipping capability on your platform.
Tables exported: artists, albums, collections, genres, songs
Explanation:
- Artists have albums
- Albums have genres, collections and songs
Notes:
A URL to play a song is created with this pseudo code:
url = "http://he3.magnatune.com/all/".urlenc($mp3)
Where "urlenc" is a function that replaces " " with "%20" to make a valid URL.
----------
An artist's page is located at:
url = "http://magnatune.com/artists/".$page
----------
An album's page is located at:
url = "http://magnatune.com/artists/albums/".urlenc($sku)
Where "urlenc" is a function that replaces " " with "%20" to make a valid URL.
----------
Cover art is available at this url:
url = "http://he3.magnatune.com/music/".urlenc($artist)."/".urlenc(album)."/cover_100.jpg"
Where "urlenc" is a function that replaces " " with "%20" to make a valid URL.
Cover art is available in a variety of sizes, and is always square:
cover_50.jpg
cover_75.jpg
cover_100.jpg
cover_160.jpg
cover_200.jpg
cover_300.jpg
cover_600.jpg
cover_1400.jpg
Sample data:
artists(artist) = Zilla
artists(city) = (this is empty if artist is from the USA)
artists(country) = USA
artists(description) = live, improvised electronica
artists(homepage) = zilla
artists(state) = CO (this is empty if artist is from outside the USA)
======================
albums(albumname) = Egg (Note: album names are unique at Magnatune)
albums(artist) = Zilla
albums(launchdate) = 1159513200
albums(sku) = zilla-egg
albums(upc) = 876809005078
======================
collections(albumname) = Egg
collections(collection) = Experimental Electronic
======================
genres(albumname) = Egg
genres(genre) = Electronica
======================
songs(albumname) = Egg
songs(desc) = Soupy Sails
songs(duration) = 357
songs(mp3) = 13-Soupy Sails-Zilla.mp3
======================
