home / calmcode

bigmac

10 rows where currency_code = "HUF" and date = "2019-01-01"

✎ 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
1184 1184 2019-01-01 HUF Hungary 850.0 280.26875 3.0328033360836697
2514 2514 2019-01-01 HUF Hungary 850.0 280.26875 3.0328033360836697
3844 3844 2019-01-01 HUF Hungary 850.0 280.26875 3.0328033360836697
5174 5174 2019-01-01 HUF Hungary 850.0 280.26875 3.0328033360836697
6504 6504 2019-01-01 HUF Hungary 850.0 280.26875 3.0328033360836697
7834 7834 2019-01-01 HUF Hungary 850.0 280.26875 3.0328033360836697
9164 9164 2019-01-01 HUF Hungary 850.0 280.26875 3.0328033360836697
10494 10494 2019-01-01 HUF Hungary 850.0 280.26875 3.0328033360836697
11824 11824 2019-01-01 HUF Hungary 850.0 280.26875 3.0328033360836697
13154 13154 2019-01-01 HUF Hungary 850.0 280.26875 3.0328033360836697

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