It looks like you're offline.
Donate
English
Open Library logo

Open Library Data Dumps → Diff

Added
Modified
Removed
Not changed
Revision 34 by Drini August 7, 2024
Revision 35 by raybb January 4, 2025
body
0 Open Library provides dumps of all its data, generated every month. Most of the data dumps are formatted as tab separated files with the following columns: 0 Open Library provides dumps of all its data, generated every month. Most of the data dumps are formatted as tab separated files with the following columns:
... ...
39 39
40 ### DuckDB
41
42 [DuckDB](https://duckdb.org/) is another easy tool to query the dump without much work.
43
44 For example:
45 If you wanted to get all the Wikidata IDs currently in the authors table:
46 ```
47 SELECT json_extract(column4, '$.remote_ids.wikidata') as wikidata_id
48 FROM read_csv('ol_dump_authors_2024-07-31.txt.gz')
49 WHERE wikidata_id IS NOT NULL
50 LIMIT 100;
51 ```
52
40 ## GraphQL 40 ## GraphQL
... ...
66 - https://archive.org/details/covers_0014 66 - https://archive.org/details/covers_0014