Downloads
All files are licensed CC BY 4.0. Credit “Roastbook Open Coffee” and link to data.roastbook.coffee. Images are licensed per file; see each place's image credit.
Open in Datasette LiteManifest (index.json)
Datasette Lite runs in your browser and loads the CSV straight from this site.
Source files
The canonical data, one JSON file per city (coffee places) or per dataset, validated against the schema named in its $schema.
| File | Dataset | Records | Size |
|---|---|---|---|
| brew-methods/brew-methods.json | brew-methods | 21 | 43.1 KB |
Compiled artifacts
Built from the source files on every release. Columns in CSV, GeoJSON and GeoParquet use the schema's dotted field paths, for example serving.filter; per-field provenance is only in the JSON and NDJSON files.
| File | Format | Records | Size |
|---|---|---|---|
| coffee-places.csv | CSV, flat columns | 0 | 1 B |
Quick start
curl -sO https://data.roastbook.coffee/datasets/coffee-places/de/munich.json
duckdb -c "INSTALL spatial; LOAD spatial; SELECT name, \"serving.filter\" FROM 'https://data.roastbook.coffee/artifacts/coffee-places.geoparquet' WHERE specialty_tier = 'A'"