home / calmcode

bigmac

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

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ date currency_code name local_price dollar_ex dollar_price
529 529 2011-07-01 HUF Hungary 760.0 188.0724 4.04099697775963
1859 1859 2011-07-01 HUF Hungary 760.0 188.0724 4.04099697775963
3189 3189 2011-07-01 HUF Hungary 760.0 188.0724 4.04099697775963
4519 4519 2011-07-01 HUF Hungary 760.0 188.0724 4.04099697775963
5849 5849 2011-07-01 HUF Hungary 760.0 188.0724 4.04099697775963
7179 7179 2011-07-01 HUF Hungary 760.0 188.0724 4.04099697775963
8509 8509 2011-07-01 HUF Hungary 760.0 188.0724 4.04099697775963
9839 9839 2011-07-01 HUF Hungary 760.0 188.0724 4.04099697775963
11169 11169 2011-07-01 HUF Hungary 760.0 188.0724 4.04099697775963
12499 12499 2011-07-01 HUF Hungary 760.0 188.0724 4.04099697775963

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