bigmac
10 rows where date = "2020-01-14" and name = "Israel"
This data as json, CSV (advanced)
| Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
|---|---|---|---|---|---|---|---|
| 1299 | 1299 | 2020-01-14 | ILS | Israel | 17.0 | 3.4595 | 4.91400491400492 |
| 2629 | 2629 | 2020-01-14 | ILS | Israel | 17.0 | 3.4595 | 4.91400491400492 |
| 3959 | 3959 | 2020-01-14 | ILS | Israel | 17.0 | 3.4595 | 4.91400491400492 |
| 5289 | 5289 | 2020-01-14 | ILS | Israel | 17.0 | 3.4595 | 4.91400491400492 |
| 6619 | 6619 | 2020-01-14 | ILS | Israel | 17.0 | 3.4595 | 4.91400491400492 |
| 7949 | 7949 | 2020-01-14 | ILS | Israel | 17.0 | 3.4595 | 4.91400491400492 |
| 9279 | 9279 | 2020-01-14 | ILS | Israel | 17.0 | 3.4595 | 4.91400491400492 |
| 10609 | 10609 | 2020-01-14 | ILS | Israel | 17.0 | 3.4595 | 4.91400491400492 |
| 11939 | 11939 | 2020-01-14 | ILS | Israel | 17.0 | 3.4595 | 4.91400491400492 |
| 13269 | 13269 | 2020-01-14 | ILS | Israel | 17.0 | 3.4595 | 4.91400491400492 |
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 );