bigmac
10 rows where currency_code = "HUF" and "date" is on date 2019-01-01
This data as json, CSV (advanced)
| Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
|---|---|---|---|---|---|---|---|
| 1184 | 1184 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
| 2514 | 2514 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
| 3844 | 3844 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
| 5174 | 5174 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
| 6504 | 6504 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
| 7834 | 7834 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
| 9164 | 9164 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
| 10494 | 10494 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
| 11824 | 11824 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
| 13154 | 13154 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
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 );