home / pf

reviews_authors

69 rows where author_id = 215

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
1366 1366 <em>Dawn of Chromatica</em> 1366 Jamieson Cox 215
3122 3122 <em>If I Am Only My Thoughts</em> 3122 Jamieson Cox 215
3228 3228 <em>Sing the Melody</em> 3228 Jamieson Cox 215
3490 3490 <em>Gold: Greatest Hits</em> 3490 Jamieson Cox 215
3778 3778 <em>Clarity</em> 3778 Jamieson Cox 215
4414 4414 <em>Let Go</em> 4414 Jamieson Cox 215
4700 4700 <em>Chris</em> 4700 Jamieson Cox 215
4710 4710 <em>Lilac Everything</em> 4710 Jamieson Cox 215
4770 4770 <em>Bloom</em> 4770 Jamieson Cox 215
4975 4975 <em>Scorpion</em> 4975 Jamieson Cox 215
5018 5018 <em>Nothing Is Still</em> 5018 Jamieson Cox 215
5093 5093 <em>Shawn Mendes</em> 5093 Jamieson Cox 215
5169 5169 <em>Conexão EP</em> 5169 Jamieson Cox 215
5323 5323 <em>The Rite of May EP</em> 5323 Jamieson Cox 215
5379 5379 <em>Francis Trouble</em> 5379 Jamieson Cox 215
5380 5380 <em>Have fun EP</em> 5380 Jamieson Cox 215
5520 5520 <em>Man of the Woods</em> 5520 Jamieson Cox 215
5579 5579 <em>Camila</em> 5579 Jamieson Cox 215
5657 5657 <em>Daydream</em> 5657 Jamieson Cox 215
5743 5743 <em>Reputation</em> 5743 Jamieson Cox 215
5763 5763 <em>The Thrill of It All</em> 5763 Jamieson Cox 215
5885 5885 <em>Tell Me You Love Me</em> 5885 Jamieson Cox 215
5901 5901 <em>Now</em> 5901 Jamieson Cox 215
5961 5961 <em>Communicating</em> 5961 Jamieson Cox 215
6170 6170 <em>Kaleidoscope EP</em> 6170 Jamieson Cox 215
6381 6381 <em>Harry Styles</em> 6381 Jamieson Cox 215
8867 8867 <em>Fading Love</em> 8867 Jamieson Cox 215
8910 8910 <em>Kindred</em> 8910 Jamieson Cox 215
8945 8945 <em>Drink More Water 5</em> 8945 Jamieson Cox 215
9021 9021 <em>Reminisce</em> 9021 Jamieson Cox 215
9112 9112 <em>Over Easy EP</em> 9112 Jamieson Cox 215
9128 9128 <em>Guitars and Microphones</em> 9128 Jamieson Cox 215
9277 9277 <em>Sucker</em> 9277 Jamieson Cox 215
9315 9315 <em>Noctilucence EP</em> 9315 Jamieson Cox 215
9353 9353 <em>Soft</em> 9353 Jamieson Cox 215
9374 9374 <em>Michael</em> 9374 Jamieson Cox 215
9464 9464 <em>We Come From the Same Place</em> 9464 Jamieson Cox 215
9497 9497 <em>Our Love</em> 9497 Jamieson Cox 215
9522 9522 <em>Chimes EP</em> 9522 Jamieson Cox 215
9536 9536 <em>Hey Hey</em> 9536 Jamieson Cox 215
9586 9586 <em>Ritual in Repeat</em> 9586 Jamieson Cox 215
9590 9590 <em>Commonwealth</em> 9590 Jamieson Cox 215
9669 9669 <em>EP1</em> 9669 Jamieson Cox 215
9706 9706 <em>Seven Years Week</em> 9706 Jamieson Cox 215
9711 9711 <em>Pe'ahi</em> 9711 Jamieson Cox 215
9760 9760 <em>Conversations</em> 9760 Jamieson Cox 215
9765 9765 <em>Complete Surrender</em> 9765 Jamieson Cox 215
9801 9801 <em>Careers</em> 9801 Jamieson Cox 215
9871 9871 <em>Love Me</em> 9871 Jamieson Cox 215
9881 9881 <em>Northtown EP</em> 9881 Jamieson Cox 215
9884 9884 <em>L'Aventura</em> 9884 Jamieson Cox 215
10004 10004 <em>Life Among the Savages</em> 10004 Jamieson Cox 215
10118 10118 <em>NOW + 4EVA</em> 10118 Jamieson Cox 215
10224 10224 <em>Pulsing EP</em> 10224 Jamieson Cox 215
10231 10231 <em>Apocalypse Soon EP</em> 10231 Jamieson Cox 215
10264 10264 <em>Someday, the Moon Will Be Gold</em> 10264 Jamieson Cox 215
10343 10343 <em>In Roses</em> 10343 Jamieson Cox 215
10539 10539 <em>Pastel and Pass Out EP</em> 10539 Jamieson Cox 215
10551 10551 <em>Aleph</em> 10551 Jamieson Cox 215
10660 10660 <em>You Gots 2 Chill</em> 10660 Jamieson Cox 215
10713 10713 <em>Stay / True EP</em> 10713 Jamieson Cox 215
10749 10749 <em>Pull My Hair Back</em> 10749 Jamieson Cox 215
10818 10818 <em>Mourning Trance</em> 10818 Jamieson Cox 215
10860 10860 <em>Home</em> 10860 Jamieson Cox 215
11004 11004 <em>Sob Story</em> 11004 Jamieson Cox 215
11099 11099 <em>Other Life</em> 11099 Jamieson Cox 215
11224 11224 <em>The Great Perhaps</em> 11224 Jamieson Cox 215
11353 11353 <em>Pretend To Be Brave</em> 11353 Jamieson Cox 215
25312 25312 <em>Gloria</em> 25308 Jamieson Cox 215

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