Top Books By Rating
top_books_by_ratingFind top-rated or lowest-rated books by setting a minimum-ratings threshold, with options for publication year, language, and edition grouping.
Instructions
Highest- or lowest-rated books, subject to a minimum-ratings threshold.
The threshold is the whole point: raise it for a result about well-known books, lower it to reach the long tail. Ties break toward the more heavily rated book.
Under the default unit="editions" a work with several editions can take several places in the list -- all with the same rating, since editions of one work largely share a rating pool. Pass unit="works" for a list of distinct works.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| unit | No | 'editions' ranks the table as stored, so several editions of one work can occupy several places in the list. 'works' collapses editions sharing a normalised title and ranks the best-rated edition of each, giving a list of distinct works. | editions |
| limit | No | Books to return, max 100. | |
| year_to | No | Latest publish_year, inclusive. | |
| language | No | language_normalised ISO code, e.g. 'en'. | |
| direction | No | 'desc' for highest rated first, 'asc' for lowest rated first. | desc |
| year_from | No | Earliest publish_year, inclusive. | |
| min_ratings | No | Minimum ratings a book must have to be ranked. Floor 1. At low values the top of the list is obscure books with a handful of 5-star ratings. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||