bigmac
10 rows where date = "2016-07-01", "date" is on date 2016-07-01 and dollar_ex = "6.678"
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
CREATE TABLE "bigmac" ( "date" TEXT, "currency_code" TEXT, "name" TEXT, "local_price" REAL, "dollar_ex" REAL, "dollar_price" REAL );