home / calmcode

bigmac

10 rows where date = "2016-07-01", "date" is on date 2016-07-01 and dollar_ex = "6.678"

✎ 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
942 942 2016-07-01 CNY China 18.6 6.678 2.7852650494159903
2272 2272 2016-07-01 CNY China 18.6 6.678 2.7852650494159903
3602 3602 2016-07-01 CNY China 18.6 6.678 2.7852650494159903
4932 4932 2016-07-01 CNY China 18.6 6.678 2.7852650494159903
6262 6262 2016-07-01 CNY China 18.6 6.678 2.7852650494159903
7592 7592 2016-07-01 CNY China 18.6 6.678 2.7852650494159903
8922 8922 2016-07-01 CNY China 18.6 6.678 2.7852650494159903
10252 10252 2016-07-01 CNY China 18.6 6.678 2.7852650494159903
11582 11582 2016-07-01 CNY China 18.6 6.678 2.7852650494159903
12912 12912 2016-07-01 CNY China 18.6 6.678 2.7852650494159903

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