lastfm
Data license: MIT
Queries
- Top artists (all time)
- Top tracks (all time)
- Top albums (all time)
- Scrobbles per day
- Listening by hour of day (UTC)
- Listening by weekday (UTC, 0=Sunday)
- Top genres/tags across your artists
- New artists discovered per month
- Recently played
Tables
albums
id, artist_id, name, name_normalized, mbid, url, image_url, images, listeners, playcount, user_playcount, release_date, wiki_summary, wiki_content, wiki_published_at, enriched_at, created_at, updated_at
4,846 rows
artists
id, name, name_normalized, mbid, url, image_url, images, listeners, playcount, user_playcount, streamable, ontour, bio_summary, bio_content, bio_published_at, enriched_at, created_at, updated_at
2,185 rows
import_runs
id, kind, status, started_at, finished_at, scrobbles_imported, entities_touched, error, created_at
106 rows
profile_snapshots
id, captured_at, username, realname, country, url, image_url, playcount, artist_count, track_count, album_count, registered_uts, registered_at, subscriber, raw, created_at
11 rows
scrobbles
id, track_id, artist_id, album_id, played_at, uts, signature, artist_name, track_name, album_name, artist_mbid, track_mbid, album_mbid, image_url, loved, created_at
44,106 rows
top_snapshot_entries
id, top_snapshot_id, entity_type, entity_id, rank, playcount, created_at, updated_at
0 rows
tracks
id, artist_id, album_id, name, name_normalized, mbid, url, image_url, images, duration_ms, listeners, playcount, user_playcount, user_loved, streamable, wiki_summary, wiki_content, wiki_published_at, enriched_at, created_at, updated_at
13,395 rows
weekly_chart_entries
id, weekly_chart_period_id, entity_type, entity_id, rank, playcount, created_at, updated_at
0 rows
weekly_chart_periods
id, from_uts, to_uts, from_at, to_at, fetched_at, created_at, updated_at
0 rows