bigmac
10 rows where "date" is on date 2003-04-01 and local_price = "23.0"
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
106 | 106 | 2003-04-01 | MXN | Mexico | 23.0 | 10.53 | 2.18423551756885 |
1436 | 1436 | 2003-04-01 | MXN | Mexico | 23.0 | 10.53 | 2.18423551756885 |
2766 | 2766 | 2003-04-01 | MXN | Mexico | 23.0 | 10.53 | 2.18423551756885 |
4096 | 4096 | 2003-04-01 | MXN | Mexico | 23.0 | 10.53 | 2.18423551756885 |
5426 | 5426 | 2003-04-01 | MXN | Mexico | 23.0 | 10.53 | 2.18423551756885 |
6756 | 6756 | 2003-04-01 | MXN | Mexico | 23.0 | 10.53 | 2.18423551756885 |
8086 | 8086 | 2003-04-01 | MXN | Mexico | 23.0 | 10.53 | 2.18423551756885 |
9416 | 9416 | 2003-04-01 | MXN | Mexico | 23.0 | 10.53 | 2.18423551756885 |
10746 | 10746 | 2003-04-01 | MXN | Mexico | 23.0 | 10.53 | 2.18423551756885 |
12076 | 12076 | 2003-04-01 | MXN | Mexico | 23.0 | 10.53 | 2.18423551756885 |
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 );