home / calmcode

bigmac

10 rows where currency_code = "HUF" and date = "2015-07-01"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ date currency_code name local_price dollar_ex dollar_price
865 865 2015-07-01 HUF Hungary 900.0 282.8778 3.1815858296409303
2195 2195 2015-07-01 HUF Hungary 900.0 282.8778 3.1815858296409303
3525 3525 2015-07-01 HUF Hungary 900.0 282.8778 3.1815858296409303
4855 4855 2015-07-01 HUF Hungary 900.0 282.8778 3.1815858296409303
6185 6185 2015-07-01 HUF Hungary 900.0 282.8778 3.1815858296409303
7515 7515 2015-07-01 HUF Hungary 900.0 282.8778 3.1815858296409303
8845 8845 2015-07-01 HUF Hungary 900.0 282.8778 3.1815858296409303
10175 10175 2015-07-01 HUF Hungary 900.0 282.8778 3.1815858296409303
11505 11505 2015-07-01 HUF Hungary 900.0 282.8778 3.1815858296409303
12835 12835 2015-07-01 HUF Hungary 900.0 282.8778 3.1815858296409303

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