bigmac
10 rows where currency_code = "HUF" and "date" is on date 2015-07-01
This data as json, CSV (advanced)
| Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
|---|---|---|---|---|---|---|---|
| 865 | 865 | 2015-07-01 | HUF | Hungary | 900.0 | 282.8778 | 3.1815858296409303 |
| 2195 | 2195 | 2015-07-01 | HUF | Hungary | 900.0 | 282.8778 | 3.1815858296409303 |
| 3525 | 3525 | 2015-07-01 | HUF | Hungary | 900.0 | 282.8778 | 3.1815858296409303 |
| 4855 | 4855 | 2015-07-01 | HUF | Hungary | 900.0 | 282.8778 | 3.1815858296409303 |
| 6185 | 6185 | 2015-07-01 | HUF | Hungary | 900.0 | 282.8778 | 3.1815858296409303 |
| 7515 | 7515 | 2015-07-01 | HUF | Hungary | 900.0 | 282.8778 | 3.1815858296409303 |
| 8845 | 8845 | 2015-07-01 | HUF | Hungary | 900.0 | 282.8778 | 3.1815858296409303 |
| 10175 | 10175 | 2015-07-01 | HUF | Hungary | 900.0 | 282.8778 | 3.1815858296409303 |
| 11505 | 11505 | 2015-07-01 | HUF | Hungary | 900.0 | 282.8778 | 3.1815858296409303 |
| 12835 | 12835 | 2015-07-01 | HUF | Hungary | 900.0 | 282.8778 | 3.1815858296409303 |
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 );