home / pf

albums_artists

15 rows where artist_id = 232

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
238 238 228 228 232 232
2948 2948 2778 2778 232 232
4081 4081 3882 3882 232 232
4843 4843 4623 4623 232 232
5375 5375 5123 5123 232 232
7064 7064 6767 6767 232 232
8865 8865 8532 8532 232 232
10983 10983 10640 10640 232 232
11788 11788 11447 11447 232 232
12729 12729 12390 12390 232 232
13840 13840 13482 13482 232 232
14289 14289 13931 13931 232 232
15382 15382 15039 15039 232 232
16448 16448 16135 16135 232 232
16449 16449 16136 16136 232 232

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 50.262ms