Query the data

Build a question below, or write SQL yourself. Runs SQLite in your browser over the same data. Nothing is sent anywhere.

Try:

Show per

whereno filters: every coffee

Variety and process also match the coffee's name, because many shops only put them there. Gesha also matches Geisha. Price per kg is each coffee's cheapest €/kg offer (often the largest bag); prices below €8/kg are left out as misreads.

SQL · the builder writes here; edit it to go further

The SQL engine loads when you open this tab.

Tables: roasters · coffees (roaster_id, roast_level, process, decaf, organic…) · coffee_origins (coffee_id, country) · coffee_tasting_notes (coffee_id, note) · offers (coffee_id, package_g, price, price_per_kg, in_stock…). Prices are in EUR.