Reviews are the m:n mapping table between books and shelves. This means books that are just on your to-read shelf still have a review, connecting the book with your shelf. I don't make the rules.

1 row where book_id = 27394352

View and edit SQL

Suggested facets: date_added (date), date_updated (date), read_at (date)

id ▼ book_id user_id rating text date_added date_updated read_at started_at
2984016376 It Was You Who Made My Blue Eyes Blue 27394352 rixx 41972609 4 [It Was You Who Made My Blue Eyes Blue](<a target="_blank" href="" rel="nofollow"></a>) is a rationalist short story by Scott Alexander, exploring the impact of logic and colonialisation on an island tribe. KIDDING! While technically correct, it is also false, and I can't tell you more than that without giving away the best part of the punch line. Go read it! It's not long, and a lot of fun, particularly the first half, before the smug rationalist author breaks through. 2019-09-20T04:41:02-07:00 2020-02-23T11:16:36-08:00 2019-09-20  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [reviews] (
   [book_id] TEXT REFERENCES [books]([id]),
   [user_id] TEXT REFERENCES [users]([id]),
   [rating] TEXT,
   [text] TEXT,
   [date_added] TEXT,
   [date_updated] TEXT
, [read_at] TEXT, [started_at] TEXT);