home / pf

albums_artists

7 rows where artist_id = 2613

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3311 3311 3127 3127 2613 2613
5384 5384 5132 5132 2613 2613
9585 9585 9239 9239 2613 2613
11420 11420 11081 11081 2613 2613
13224 13224 12882 12882 2613 2613
14368 14368 14009 14009 2613 2613
15417 15417 15074 15074 2613 2613

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE albums_artists (
	album_id integer NOT NULL,
	artist_id integer NOT NULL,
	FOREIGN KEY(artist_id) REFERENCES artists(id),
	FOREIGN KEY(album_id) REFERENCES albums(id),
	UNIQUE(album_id, artist_id)
);
Powered by Datasette · Queries took 53.467ms