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 = 18211295

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
1249274995 The Rhesus Chart 18211295 rixx 41972609 4 Just a review to remind myself what happened here and why I liked the book.<br /><br />We meet Mhari again! Bob is amazingly grown-up about it. Everybody realizes they get played early on … and still: people die. A lot of them. Including Angleton. Because their opponent is a century-old PHANG.<br /><br />Written very smoothly, Stross is really in his element here. Feels effortless, and is easy to read. 2015-04-08T06:49:23-07:00 2016-05-07T16:04:04-07:00 2015-08-04T05:44:23-07:00  

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