tracks

Data license: MIT

13,395 rows sorted by playcount descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user_loved, wiki_published_at (date), enriched_at (date), created_at (date), updated_at (date)

Next page

CREATE TABLE tracks (
  id INTEGER PRIMARY KEY,
  artist_id INTEGER NOT NULL REFERENCES artists(id),
  album_id INTEGER REFERENCES albums(id),
  name TEXT NOT NULL,
  name_normalized TEXT NOT NULL,
  mbid TEXT,
  url TEXT,
  image_url TEXT,
  images TEXT,
  duration_ms INTEGER,
  listeners INTEGER,
  playcount INTEGER,
  user_playcount INTEGER,
  user_loved INTEGER NOT NULL DEFAULT 0,
  streamable INTEGER,
  wiki_summary TEXT,
  wiki_content TEXT,
  wiki_published_at TEXT,
  enriched_at TEXT,
  created_at TEXT NOT NULL,
  updated_at TEXT NOT NULL
);
CREATE UNIQUE INDEX idx_tracks_artist_name ON tracks(artist_id, name_normalized);
CREATE INDEX idx_tracks_mbid ON tracks(mbid);
CREATE INDEX idx_tracks_enriched_at ON tracks(enriched_at);