home / calmcode

bigmac

10 rows where date = "2020-01-14", "date" is on date 2020-01-14 and name = "Israel"

✎ 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
1299 1299 2020-01-14 ILS Israel 17.0 3.4595 4.91400491400492
2629 2629 2020-01-14 ILS Israel 17.0 3.4595 4.91400491400492
3959 3959 2020-01-14 ILS Israel 17.0 3.4595 4.91400491400492
5289 5289 2020-01-14 ILS Israel 17.0 3.4595 4.91400491400492
6619 6619 2020-01-14 ILS Israel 17.0 3.4595 4.91400491400492
7949 7949 2020-01-14 ILS Israel 17.0 3.4595 4.91400491400492
9279 9279 2020-01-14 ILS Israel 17.0 3.4595 4.91400491400492
10609 10609 2020-01-14 ILS Israel 17.0 3.4595 4.91400491400492
11939 11939 2020-01-14 ILS Israel 17.0 3.4595 4.91400491400492
13269 13269 2020-01-14 ILS Israel 17.0 3.4595 4.91400491400492

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 641.78ms