bigmac
10 rows where "date" is on date 2003-04-01 and local_price = "70.0"
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
117 | 117 | 2003-04-01 | TWD | Taiwan | 70.0 | 34.8 | 2.01149425287356 |
1447 | 1447 | 2003-04-01 | TWD | Taiwan | 70.0 | 34.8 | 2.01149425287356 |
2777 | 2777 | 2003-04-01 | TWD | Taiwan | 70.0 | 34.8 | 2.01149425287356 |
4107 | 4107 | 2003-04-01 | TWD | Taiwan | 70.0 | 34.8 | 2.01149425287356 |
5437 | 5437 | 2003-04-01 | TWD | Taiwan | 70.0 | 34.8 | 2.01149425287356 |
6767 | 6767 | 2003-04-01 | TWD | Taiwan | 70.0 | 34.8 | 2.01149425287356 |
8097 | 8097 | 2003-04-01 | TWD | Taiwan | 70.0 | 34.8 | 2.01149425287356 |
9427 | 9427 | 2003-04-01 | TWD | Taiwan | 70.0 | 34.8 | 2.01149425287356 |
10757 | 10757 | 2003-04-01 | TWD | Taiwan | 70.0 | 34.8 | 2.01149425287356 |
12087 | 12087 | 2003-04-01 | TWD | Taiwan | 70.0 | 34.8 | 2.01149425287356 |
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 );