reviews_authors

26,382 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
1 1 <em>Jumping/Dancing/Fighting</em> EP 1 Nina Corcoran 1
2 2 <em>To Illustrate</em> 2 Philip Sherburne 2
3 3 <em>The Smile (Live at Montreux Jazz Festival, July 2022)</em> 3 Zach Schonfeld 3
4 4 <em>Niger EP Vol. 1</em> / <em>Niger EP Vol. 2</em> 4 Andy Cush 4
5 5 <em>Live at The Whisky 1977</em> 5 Stuart Berman 5
6 6 <em>Live Fire</em> 6 Stephen Kearse 6
7 7 <em>Ground Groove</em> 7 Philip Sherburne 2
8 8 <em>Ice, Death, Planets, Lungs, Mushrooms and Lava</em> 8 Stuart Berman 5
9 9 <em>Solos</em> 9 Jonathan Williger 7
10 10 <em>Keep It Lit</em> EP 10 Heven Haile 8
11 11 <em>Full Moon Mystery Garden</em> 11 Colin Joyce 9
12 12 <em>NO THANK YOU</em> 12 Will Pritchard 10
13 13 <em>Premonition</em> 13 Zach Schonfeld 3
14 14 <em>The Way It Is</em> 14 Clover Hope 11
15 15 <em>The 7&quot; Singles</em> 15 Jayson Greene 12
16 16 <em>Herbert</em> 16 Dylan Green 13
17 17 <em>hypochondriac</em> 17 H.D. Angel 14
18 18 <em>Call and Response</em> 18 Philip Sherburne 2
19 19 <em>Vacabularee</em> 19 Alphonse Pierre 15
20 20 <em>Yesterday’s Tomorrow Is Not Today</em> 20 Ian Cohen 16
21 21 <em>Live at Budokan</em> 21 Marty Sartini Garner 17
22 22 <em>VMAK&lt;KOMBZ&lt;&lt;&lt;DUGLAS&lt;&lt;6NDR7&lt;&lt;&lt;</em> 22 Steven Arroyo 18
23 23 <em>Snake Eyes</em> EP 23 Joshua Minsoo Kim 19
24 24 <em>Snake Chain</em> 24 Madison Bloom 20
25 25 <em>Watertown</em> 25 Sam Sodomsky 21
26 26 <em>Divine Symmetry</em>  26 Jane Bua 22
27 27 <em>SOS</em> 27 Julianne Escobedo Shepherd 23
28 28 <em>Plasma</em> 28 Philip Sherburne 2
29 29 <em>MOB</em> 29 Dylan Green 13
30 30 <em>Heroes &amp; Villains</em> 30 Brady Brickner-Wood 24
31 31 <em>All Roads Lead to the Gun (Deluxe)</em> 31 Nina Corcoran 1
32 32 <em>Lucifer on the Moon</em> 32 Tal Rosenberg 25
33 33 <em>A Complete Anthology of Solo and Duo Violin Pieces</em>  33 Vanessa Ague 26
34 34 <em>Palaces of Pity</em> EP 34 Arjun Ram Srivatsa  27
35 35 <em>Live at the Fillmore (1997)</em> 35 Caryn Rose 28
36 36 <em>Type 4: City on the Type of Forever</em> 36 Jayson Greene 12
37 37 <em>Dusk</em> 37 Daniel Bromfield 29
38 38 <em>HIS HAPPINESS SHALL COME FIRST EVEN THOUGH WE ARE SUFFERING</em>  38 Adlan Jackson 30
39 39 <em>Back to the Woodlands</em> 39 Sam Goldner 31
40 40 <em>Respect the Come Up</em>  40 Will Pritchard 10
41 41 <em>Promethean Pathology</em>  41 Brad Sanders 32
42 42 <em>Hejira</em> 42 Jenn Pelly 33
43 43 <em>Upright and Even</em> EP 43 Sophie Kemp 34
44 44 <em>100% Galcher</em> 44 Philip Sherburne 2
45 45 <em>Broken Spectre</em> 45 Matthew Blackwell 35
46 46 <em>World Record</em> 46 Stephen Thomas Erlewine 36
47 47 <em>And I Have Been</em> 47 Madison Bloom 20
48 48 <em>This Is What I Mean</em> 48 Will Pritchard 10
49 49 <em>On the way to Beatenberg EP</em>  49 Brady Brickner-Wood 24
50 50 <em>Wane Into It</em> 50 Patrick Lyons 37
51 51 <em>Flipped It</em> EP 51 Linnie Greene 38
52 52 <em>Flaming Swords</em> 52 Travis Shosa 39
53 53 <em>SATURNO</em> 53 Stefanie Fernández 40
54 54 <em>Feed tha Streets III</em> 54 Serge Selenou 41
55 55 <em>Spirit Roaming</em>  55 Matthew Ritchie 42
56 56 <em>Onwards!</em> 56 Jayson Greene 12
57 57 <em>foam</em> 57 Will Lynch 43
58 58 <em>The Hands of Grace</em> 58 Matthew Blackwell 35
59 59 <em>Isomonstrosity</em> 59 Hannah Jocelyn 44
60 60 <em>Black Girl Magic</em>  60 Eric Torres 45
61 61 <em>Back 2 Life</em> 61 Sam Goldner 31
62 62 <em>Please Have a Seat</em> 62 Nina Corcoran 1
63 63 <em>STR4TASFEAR</em> 63 Ben Cardew 46
64 64 <em>The Roches</em>  64 Andy Cush 4
65 65 <em>Redcar les adorables étoiles (prologue)</em> 65 Sophie Kemp 34
66 66 <em>Big Time Things</em> 66 Ted Davis 47
67 67 <em>I Don’t Give a Fuck About This Rap Shit, Imma Just Drop Until I Don’t Feel Like It Anymore</em> 67 Dylan Green 13
68 68 <em>The Family</em> 68 Pete Tosiello 48
69 69 <em>11•11•11</em> 69 Evan Rytlewski 49
70 70 <em>King’s Disease III</em> 70 Paul A. Thompson 50
71 71 <em>softCORE</em> 71 DeAsia Paige 51
72 72 <em>Almanac Behind</em> 72 Matthew Blackwell 35
73 73 <em>Vivid</em> 73 Stuart Berman 5
74 74 <em>On the Impossible Past (10th Anniversary Edition)</em> 74 Anna Gaca 52
75 75 <em>And in the Darkness, Hearts Aglow</em>  75 Andy Cush 4
76 76 <em>The Ruby Cord</em> 76 Sam Goldner 31
77 77 <em>Maternity Beat</em> 77 Hugh Morris 53
78 78 <em>Tempus</em> 78 Matthew Blackwell 35
79 79 <em>CAZIMI</em> 79 Brad Shoup 54
80 80 <em>Meeting With a Judas Tree</em> 80 Philip Sherburne 2
81 81 <em>Anyways, Life’s Great…</em> EP 81 Heven Haile 8
82 82 <em>Chimæra I</em> 82 Matthew Blackwell 35
83 83 <em>An Orange Colored Day</em> 83 Vrinda Jagota 55
84 84 <em>RTJ Cu4tro</em> 84 Matthew Ismael Ruiz 56
85 85 <em>What Had Happened Was…</em> 85 Dylan Green 13
86 86 <em>We’re Not Here to Be Loved</em> 86 Patrick Lyons 37
87 87 <em>Hayday</em> 87 Abby Jones 57
88 88 <em>Song of Salvation</em> 88 Sam Sodomsky 21
89 89 <em>Myself in the Way</em> 89 Margaret Farrell 58
90 90 <em>5 to the Eye With Stars</em> 90 Stephen Kearse 6
91 91 <em>How the Light Felt</em>  91 Jude Noel 59
92 92 <em>HH5</em> 92 Alphonse Pierre 15
93 93 <em>Scarecrow (Deluxe Edition)</em> 93 Stephen Thomas Erlewine 36
94 94 <em>MK 3.5: Die Cuts | City Planning</em> 94 Philip Sherburne 2
95 95 <em>Nothing You Do Matters</em> EP 95 Marty Sartini Garner 17
96 96 <em>They’re All Gonna Laugh at You!</em> 96 Jayson Greene 12
97 97 <em>Mondays at the Enfield Tennis Academy</em> 97 Daniel Felsenthal 60
98 98 <em>Only the Strong Survive</em> 98 Sam Sodomsky 21
99 99 <em>Black Panther: Wakanda Forever - Music From and Inspired By</em> 99 Dylan Green 13
100 100 <em>Through a Room</em> 100 Matthew Blackwell 35

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)
);