home / calmcode

bigmac

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

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ date currency_code name local_price dollar_ex dollar_price
612 612 2012-07-01 HUF Hungary 830.0 238.2151 3.48424596089836
1942 1942 2012-07-01 HUF Hungary 830.0 238.2151 3.48424596089836
3272 3272 2012-07-01 HUF Hungary 830.0 238.2151 3.48424596089836
4602 4602 2012-07-01 HUF Hungary 830.0 238.2151 3.48424596089836
5932 5932 2012-07-01 HUF Hungary 830.0 238.2151 3.48424596089836
7262 7262 2012-07-01 HUF Hungary 830.0 238.2151 3.48424596089836
8592 8592 2012-07-01 HUF Hungary 830.0 238.2151 3.48424596089836
9922 9922 2012-07-01 HUF Hungary 830.0 238.2151 3.48424596089836
11252 11252 2012-07-01 HUF Hungary 830.0 238.2151 3.48424596089836
12582 12582 2012-07-01 HUF Hungary 830.0 238.2151 3.48424596089836

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