home / pf

reviews_authors

911 rows where author_id = 16

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
20 20 <em>Yesterday’s Tomorrow Is Not Today</em> 20 Ian Cohen 16
153 153 <em>Paraglow EP</em> 153 Ian Cohen 16
167 167 <em>Gris Klein</em> 167 Ian Cohen 16
266 266 <em>Asphalt Meadows</em> 266 Ian Cohen 16
289 289 <em>Arrangements</em> 289 Ian Cohen 16
300 300 <em>Nothing’s Shocking</em> 300 Ian Cohen 16
378 378 <em>Visions From the Bridge</em>  378 Ian Cohen 16
425 425 <em>Love the Stranger</em> 425 Ian Cohen 16
431 431 <em>Pool Kids</em> 431 Ian Cohen 16
472 472 <em>The Other Side of Make-Believe</em> 472 Ian Cohen 16
510 510 <em>New Low</em> EP 510 Ian Cohen 16
545 545 <em>Life Is Yours</em> 545 Ian Cohen 16
584 584 <em>The Great Awakening</em> 584 Ian Cohen 16
653 653 <em>Waterslide, Diving Board, Ladder to the Sky</em> 653 Ian Cohen 16
675 675 <em>Headful of Sugar</em> 675 Ian Cohen 16
680 680 <em>Profound Morality</em> 680 Ian Cohen 16
728 728 <em>Prince Daddy &amp; the Hyena</em> 728 Ian Cohen 16
775 775 <em>Live at Shea Stadium</em> 775 Ian Cohen 16
815 815 <em>Diaspora Problems</em> 815 Ian Cohen 16
876 876 <em>This World Is Going to Ruin You</em> 876 Ian Cohen 16
914 914 <em>caroline</em> 914 Ian Cohen 16
976 976 <em>Ants From Up There</em> 976 Ian Cohen 16
993 993 <em>Little Green House</em> 993 Ian Cohen 16
1005 1005 <em>Shoals</em> 1005 Ian Cohen 16
1011 1011 <em>Havasu</em> 1011 Ian Cohen 16
1047 1047 <em>Dartland</em> 1047 Ian Cohen 16
1102 1102 <em>The Romance of Affliction</em> 1102 Ian Cohen 16
1191 1191 <em>Projector</em> 1191 Ian Cohen 16
1215 1215 <em>My Morning Jacket</em> 1215 Ian Cohen 16
1236 1236 <em>A Tear in the Fabric of Life</em> 1236 Ian Cohen 16
1344 1344 <em>Texis</em> 1344 Ian Cohen 16
1397 1397 <em>Glow On</em> 1397 Ian Cohen 16
1438 1438 <em>Complacency EP</em> 1438 Ian Cohen 16
1503 1503 <em>Spiral</em> 1503 Ian Cohen 16
1519 1519 <em>TX, ’98</em> 1519 Ian Cohen 16
1578 1578 <em>Fate in Seven Lessons</em> 1578 Ian Cohen 16
1611 1611 <em>Blue Weekend</em> 1611 Ian Cohen 16
1675 1675 <em>Between the Richness</em> 1675 Ian Cohen 16
1810 1810 <em>I Became Birds</em>  1810 Ian Cohen 16
1837 1837 <em>Joyce Manor</em> 1837 Ian Cohen 16
1847 1847 <em>Half a Human EP</em> 1847 Ian Cohen 16
1852 1852 <em>Green to Gold</em> 1852 Ian Cohen 16
1867 1867 <em>To See the Next Part of the Dream</em> 1867 Ian Cohen 16
1900 1900 <em>Everything Nice EP</em> 1900 Ian Cohen 16
1955 1955 <em>In Spite Of</em> 1955 Ian Cohen 16
1979 1979 <em>New Fragility</em> 1979 Ian Cohen 16
2022 2022 <em>We Are Always Alone</em> 2022 Ian Cohen 16
2027 2027 <em>OK Human</em> 2027 Ian Cohen 16
2088 2088 <em>No Driver</em> 2088 Ian Cohen 16
2117 2117 <em>Ground Aswim</em> 2117 Ian Cohen 16
2145 2145 <em>CYR</em> 2145 Ian Cohen 16
2179 2179 <em>Songs to Yeet at the Sun EP</em> 2179 Ian Cohen 16
2253 2253 <em>Floral Prince</em> 2253 Ian Cohen 16
2290 2290 <em>Atlas Vending</em> 2290 Ian Cohen 16
2293 2293 <em>Lament</em> 2293 Ian Cohen 16
2387 2387 <em>The Universal Want</em> 2387 Ian Cohen 16
2404 2404 <em>Awake in the Brain Chamber</em> 2404 Ian Cohen 16
2467 2467 <em>Welcome to Conceptual Beach</em> 2467 Ian Cohen 16
2495 2495 <em>Dreamland</em> 2495 Ian Cohen 16
2506 2506 <em>Impenetrable Cerebral Fortress</em> 2506 Ian Cohen 16
2584 2584 <em>The Avalanche</em> 2584 Ian Cohen 16
2595 2595 <em>As We Suffer From Memory and Imagination</em> 2595 Ian Cohen 16
2604 2604 <em>Massey Fucking Hall</em> 2604 Ian Cohen 16
2623 2623 <em>Inlet</em> 2623 Ian Cohen 16
2714 2714 <em>Pop Music / False B​-​Sides II</em> 2714 Ian Cohen 16
2735 2735 <em>NO DREAM</em> 2735 Ian Cohen 16
2759 2759 <em>Beneath</em> 2759 Ian Cohen 16
2818 2818 <em>Making a Door Less Open</em> 2818 Ian Cohen 16
2859 2859 <em>Viewing</em> 2859 Ian Cohen 16
2908 2908 <em>You’ll Be Fine</em> 2908 Ian Cohen 16
2977 2977 <em>Melee</em> 2977 Ian Cohen 16
2988 2988 <em>Youth Pastoral</em> 2988 Ian Cohen 16
3055 3055 <em>White Ladder (20th Anniversary Edition)</em> 3055 Ian Cohen 16
3100 3100 <em>27 Miles Underwater</em> 3100 Ian Cohen 16
3144 3144 <em>Death of the Neon</em> 3144 Ian Cohen 16
3165 3165 <em>You Can Never Have a Long Enough Head Start</em> 3165 Ian Cohen 16
3179 3179 <em>Dreamin’</em> 3179 Ian Cohen 16
3196 3196 <em>The Deadbeat Bang of Heartbreak City</em> 3196 Ian Cohen 16
3205 3205 <em>Super Enthusiast</em> 3205 Ian Cohen 16
3217 3217 <em>Fates Worse Than Death</em> 3217 Ian Cohen 16
3278 3278 <em>Somewhere City</em> 3278 Ian Cohen 16
3323 3323 <em>New Hell</em> 3323 Ian Cohen 16
3372 3372 <em>Assorted Works</em> 3372 Ian Cohen 16
3412 3412 <em>You Deserve Love</em> 3412 Ian Cohen 16
3453 3453 <em>Hello Exile</em> 3453 Ian Cohen 16
3484 3484 <em>Prison on a Hill</em> 3484 Ian Cohen 16
3519 3519 <em>Home Made Satan</em> 3519 Ian Cohen 16
3524 3524 <em>Giving Birth to Thunder</em> 3524 Ian Cohen 16
3551 3551 <em>The Blue EP</em> 3551 Ian Cohen 16
3609 3609 <em>A Healthy Earth</em> 3609 Ian Cohen 16
3633 3633 <em>I Spent the Winter Writing Songs About Getting Better</em> 3633 Ian Cohen 16
3635 3635 <em>Basking in the Glow</em> 3635 Ian Cohen 16
3680 3680 <em>The Tennessee Fire: 20th Anniversary Edition</em> 3680 Ian Cohen 16
3695 3695 <em>Remembering the Rockets</em> 3695 Ian Cohen 16
3757 3757 <em>Cosmic Thrill Seekers</em> 3757 Ian Cohen 16
3780 3780 <em>The Fleeting Light of Impermanence</em> 3780 Ian Cohen 16
3799 3799 <em>Commit Yourself Completely</em> 3799 Ian Cohen 16
3933 3933 <em>The Movie</em> 3933 Ian Cohen 16
3958 3958 <em>Failed Entertainment</em> 3958 Ian Cohen 16
3990 3990 <em>Violet Street</em> 3990 Ian Cohen 16

Next page

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