bigmac
10 rows where currency_code = "HUF" and "date" is on date 2018-07-01
This data as json, CSV (advanced)
| Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
|---|---|---|---|---|---|---|---|
| 1128 | 1128 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
| 2458 | 2458 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
| 3788 | 3788 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
| 5118 | 5118 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
| 6448 | 6448 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
| 7778 | 7778 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
| 9108 | 9108 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
| 10438 | 10438 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
| 11768 | 11768 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
| 13098 | 13098 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
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 );