home / pf

reviews_authors

37 rows where author_id = 496

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
11649 11649 <em>Wild Songs</em> 11649 Hari Ashurst 496
11664 11664 <em>Stubborn Heart</em> 11664 Hari Ashurst 496
11784 11784 <em>Good Don't Sleep</em> 11784 Hari Ashurst 496
12250 12250 <em>Do Things</em> 12250 Hari Ashurst 496
12263 12263 <em>LP</em> 12263 Hari Ashurst 496
12320 12320 <em>Sunburn EP</em> 12320 Hari Ashurst 496
12334 12334 <em>Into the Trees</em> 12334 Hari Ashurst 496
12394 12394 <em>Dark York</em> 12394 Hari Ashurst 496
12412 12412 <em>All Hell</em> 12412 Hari Ashurst 496
12443 12443 <em>Plateau Vision</em> 12443 Hari Ashurst 496
12584 12584 <em>King Con</em> 12584 Hari Ashurst 496
12605 12605 <em>Sounds From Nowheresville</em> 12605 Hari Ashurst 496
12670 12670 <em>Given to the Wild</em> 12670 Hari Ashurst 496
12700 12700 <em>Ester</em> 12700 Hari Ashurst 496
12756 12756 <em>Fallen Empires</em> 12756 Hari Ashurst 496
12911 12911 <em>King Krule EP</em> 12911 Hari Ashurst 496
12928 12928 <em>GLAQJO XAACSSO</em> 12928 Hari Ashurst 496
12950 12950 <em>Eyes on You EP</em> 12950 Hari Ashurst 496
13070 13070 <em>The Stepkids</em> 13070 Hari Ashurst 496
13124 13124 <em>Dreams Come True</em> 13124 Hari Ashurst 496
13154 13154 <em>Forget</em> 13154 Hari Ashurst 496
13198 13198 <em>Atlantic EP</em> 13198 Hari Ashurst 496
13253 13253 <em>Famous First Words</em> 13253 Hari Ashurst 496
13289 13289 <em>nyc stuff and nyc bags</em> 13289 Hari Ashurst 496
13314 13314 <em>Virtue</em> 13314 Hari Ashurst 496
13376 13376 <em>Limerence</em> 13376 Hari Ashurst 496
13383 13383 <em>Realism</em> 13383 Hari Ashurst 496
13405 13405 <em>With U EP</em> 13405 Hari Ashurst 496
13503 13503 <em>Diaper Island</em> 13503 Hari Ashurst 496
13506 13506 <em>93 Million Miles</em> 13506 Hari Ashurst 496
13560 13560 <em>The Only She Chapters</em> 13560 Hari Ashurst 496
13724 13724 <em>Sauna</em> 13724 Hari Ashurst 496
13776 13776 <em>Anna Calvi</em> 13776 Hari Ashurst 496
13786 13786 <em>Passive Aggressive: Singles 2002-2010</em> 13786 Hari Ashurst 496
13831 13831 <em>La Sera</em> 13831 Hari Ashurst 496
13940 13940 <em>The Soft Moon</em> 13940 Hari Ashurst 496
13979 13979 <em>Worry</em> 13979 Hari Ashurst 496

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE reviews_authors (
	review_id integer NOT NULL,
	author_id integer NOT NULL,
	FOREIGN KEY(review_id) REFERENCES reviews(id),
	FOREIGN KEY(author_id) REFERENCES authors(id),
	UNIQUE(review_id,author_id)
);
Powered by Datasette · Queries took 66.178ms