home / calmcode

bigmac

10 rows where date = "2020-01-14", "date" is on date 2020-01-14 and local_price = "5.9"

✎ 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
1321 1321 2020-01-14 SGD Singapore 5.9 1.34715 4.37961622684928
2651 2651 2020-01-14 SGD Singapore 5.9 1.34715 4.37961622684928
3981 3981 2020-01-14 SGD Singapore 5.9 1.34715 4.37961622684928
5311 5311 2020-01-14 SGD Singapore 5.9 1.34715 4.37961622684928
6641 6641 2020-01-14 SGD Singapore 5.9 1.34715 4.37961622684928
7971 7971 2020-01-14 SGD Singapore 5.9 1.34715 4.37961622684928
9301 9301 2020-01-14 SGD Singapore 5.9 1.34715 4.37961622684928
10631 10631 2020-01-14 SGD Singapore 5.9 1.34715 4.37961622684928
11961 11961 2020-01-14 SGD Singapore 5.9 1.34715 4.37961622684928
13291 13291 2020-01-14 SGD Singapore 5.9 1.34715 4.37961622684928

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