home / calmcode

bigmac

10 rows where currency_code = "HUF", "date" is on date 2020-01-14 and local_price = "900.0"

✎ 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
1296 1296 2020-01-14 HUF Hungary 900.0 298.7502 3.0125502844851697
2626 2626 2020-01-14 HUF Hungary 900.0 298.7502 3.0125502844851697
3956 3956 2020-01-14 HUF Hungary 900.0 298.7502 3.0125502844851697
5286 5286 2020-01-14 HUF Hungary 900.0 298.7502 3.0125502844851697
6616 6616 2020-01-14 HUF Hungary 900.0 298.7502 3.0125502844851697
7946 7946 2020-01-14 HUF Hungary 900.0 298.7502 3.0125502844851697
9276 9276 2020-01-14 HUF Hungary 900.0 298.7502 3.0125502844851697
10606 10606 2020-01-14 HUF Hungary 900.0 298.7502 3.0125502844851697
11936 11936 2020-01-14 HUF Hungary 900.0 298.7502 3.0125502844851697
13266 13266 2020-01-14 HUF Hungary 900.0 298.7502 3.0125502844851697

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