home / calmcode

bigmac

10 rows where currency_code = "HUF" and "date" is on date 2018-07-01

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ date currency_code name local_price dollar_ex dollar_price
1128 1128 2018-07-01 HUF Hungary 850.0 276.4302 3.07491728472504
2458 2458 2018-07-01 HUF Hungary 850.0 276.4302 3.07491728472504
3788 3788 2018-07-01 HUF Hungary 850.0 276.4302 3.07491728472504
5118 5118 2018-07-01 HUF Hungary 850.0 276.4302 3.07491728472504
6448 6448 2018-07-01 HUF Hungary 850.0 276.4302 3.07491728472504
7778 7778 2018-07-01 HUF Hungary 850.0 276.4302 3.07491728472504
9108 9108 2018-07-01 HUF Hungary 850.0 276.4302 3.07491728472504
10438 10438 2018-07-01 HUF Hungary 850.0 276.4302 3.07491728472504
11768 11768 2018-07-01 HUF Hungary 850.0 276.4302 3.07491728472504
13098 13098 2018-07-01 HUF Hungary 850.0 276.4302 3.07491728472504

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