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 = 21535271 sorted by id descending

View and edit SQL

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

date_updated (date)

id ▲ book_id user_id rating text date_added date_updated read_at started_at
1688510931 The Slow Regard of Silent Things 21535271 rixx 41972609 2 **The Slow Regard of Silent Things** is a novella in *Patrick Rothfuss*'s **Kingkiller Chronicle** and didn't work for me at all. It's very lyrical, with beautiful, lyrical prose for its own sake, but it didn't touch me. 2016-07-05T04:18:02-07:00 2020-02-23T12:17:27-08:00 2018-09-28T00:00:00-07:00 2018-09-28T00:00:00-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);
Powered by Datasette · Query took 55.427ms