home / calmcode

bigmac

10 rows where date = "2020-01-14" and name = "Poland"

✎ 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
1316 1316 2020-01-14 PLN Poland 11.0 3.7966 2.89732918927461
2646 2646 2020-01-14 PLN Poland 11.0 3.7966 2.89732918927461
3976 3976 2020-01-14 PLN Poland 11.0 3.7966 2.89732918927461
5306 5306 2020-01-14 PLN Poland 11.0 3.7966 2.89732918927461
6636 6636 2020-01-14 PLN Poland 11.0 3.7966 2.89732918927461
7966 7966 2020-01-14 PLN Poland 11.0 3.7966 2.89732918927461
9296 9296 2020-01-14 PLN Poland 11.0 3.7966 2.89732918927461
10626 10626 2020-01-14 PLN Poland 11.0 3.7966 2.89732918927461
11956 11956 2020-01-14 PLN Poland 11.0 3.7966 2.89732918927461
13286 13286 2020-01-14 PLN Poland 11.0 3.7966 2.89732918927461

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