bigmac
10 rows where currency_code = "HUF" and date = "2012-07-01"
This data as json, CSV (advanced)
| Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
|---|---|---|---|---|---|---|---|
| 612 | 612 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
| 1942 | 1942 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
| 3272 | 3272 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
| 4602 | 4602 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
| 5932 | 5932 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
| 7262 | 7262 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
| 8592 | 8592 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
| 9922 | 9922 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
| 11252 | 11252 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
| 12582 | 12582 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
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 );