home / pf

albums_artists

15 rows where artist_id = 290

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
297 297 284 284 290 290
6560 6560 6271 6271 290 290
8181 8181 7862 7862 290 290
10204 10204 9865 9865 290 290
12026 12026 11686 11686 290 290
13128 13128 12789 12789 290 290
15341 15341 14998 14998 290 290
15588 15588 15249 15249 290 290
16371 16371 16057 16057 290 290
17897 17897 17602 17602 290 290
19764 19764 19568 19568 290 290
20348 20348 20180 20180 290 290
21431 21431 21309 21309 290 290
22353 22353 22262 22262 290 290
24676 24676 24553 24553 290 290

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