home / calmcode

bigmac

10 rows where date = "2006-05-01" and local_price = "13.95"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ date currency_code name local_price dollar_ex dollar_price
269 269 2006-05-01 ZAR South Africa 13.95 6.597 2.11459754433834
1599 1599 2006-05-01 ZAR South Africa 13.95 6.597 2.11459754433834
2929 2929 2006-05-01 ZAR South Africa 13.95 6.597 2.11459754433834
4259 4259 2006-05-01 ZAR South Africa 13.95 6.597 2.11459754433834
5589 5589 2006-05-01 ZAR South Africa 13.95 6.597 2.11459754433834
6919 6919 2006-05-01 ZAR South Africa 13.95 6.597 2.11459754433834
8249 8249 2006-05-01 ZAR South Africa 13.95 6.597 2.11459754433834
9579 9579 2006-05-01 ZAR South Africa 13.95 6.597 2.11459754433834
10909 10909 2006-05-01 ZAR South Africa 13.95 6.597 2.11459754433834
12239 12239 2006-05-01 ZAR South Africa 13.95 6.597 2.11459754433834

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "bigmac" (
"date" TEXT,
  "currency_code" TEXT,
  "name" TEXT,
  "local_price" REAL,
  "dollar_ex" REAL,
  "dollar_price" REAL
);
Powered by Datasette · Queries took 1121.703ms