bigmac
390 rows where "date" is on date 2004-05-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
120 | 120 | 2004-05-01 | ARS | Argentina | 4.36 | 2.95 | 1.4779661016949202 |
121 | 121 | 2004-05-01 | AUD | Australia | 3.25 | 1.43 | 2.2727272727272703 |
122 | 122 | 2004-05-01 | BRL | Brazil | 5.4 | 3.18 | 1.69811320754717 |
123 | 123 | 2004-05-01 | CAD | Canada | 3.19 | 1.37 | 2.3284671532846697 |
124 | 124 | 2004-05-01 | CHF | Switzerland | 6.3 | 1.29 | 4.88372093023256 |
125 | 125 | 2004-05-01 | CLP | Chile | 1400.0 | 641.0 | 2.18408736349454 |
126 | 126 | 2004-05-01 | CNY | China | 10.4 | 8.28 | 1.256038647343 |
127 | 127 | 2004-05-01 | COP | Colombia | 6500.0 | 2769.83 | 2.3467144192964904 |
128 | 128 | 2004-05-01 | CRC | Costa Rica | 1130.0 | 433.55 | 2.60638911313574 |
129 | 129 | 2004-05-01 | CZK | Czech Republic | 56.42 | 26.5 | 2.12905660377359 |
130 | 130 | 2004-05-01 | DKK | Denmark | 27.75 | 6.22 | 4.46141479099679 |
131 | 131 | 2004-05-01 | EGP | Egypt | 10.0 | 6.19 | 1.6155088852988702 |
132 | 132 | 2004-05-01 | EUR | Euro area | 2.74 | 0.833333333 | 3.2880000013152 |
133 | 133 | 2004-05-01 | GBP | Britain | 1.88 | 0.558659218 | 3.3651999992596604 |
134 | 134 | 2004-05-01 | HKD | Hong Kong | 12.0 | 7.79 | 1.54043645699615 |
135 | 135 | 2004-05-01 | HUF | Hungary | 530.0 | 211.0 | 2.51184834123223 |
136 | 136 | 2004-05-01 | IDR | Indonesia | 16100.0 | 9120.0 | 1.76535087719298 |
137 | 137 | 2004-05-01 | JPY | Japan | 262.0 | 113.0 | 2.31858407079646 |
138 | 138 | 2004-05-01 | KRW | South Korea | 3200.0 | 1177.0 | 2.71877655055225 |
139 | 139 | 2004-05-01 | LKR | Sri Lanka | 140.0 | 99.0 | 1.41414141414141 |
140 | 140 | 2004-05-01 | MXN | Mexico | 24.0 | 11.6 | 2.06896551724138 |
141 | 141 | 2004-05-01 | MYR | Malaysia | 5.04 | 3.8 | 1.32631578947368 |
142 | 142 | 2004-05-01 | NOK | Norway | 35.5 | 6.8491 | 5.183162751310389 |
143 | 143 | 2004-05-01 | NZD | New Zealand | 4.35 | 1.64 | 2.6524390243902403 |
144 | 144 | 2004-05-01 | PKR | Pakistan | 110.0 | 57.76 | 1.90443213296399 |
145 | 145 | 2004-05-01 | PEN | Peru | 8.99 | 3.49 | 2.57593123209169 |
146 | 146 | 2004-05-01 | PHP | Philippines | 69.0 | 55.9 | 1.23434704830054 |
147 | 147 | 2004-05-01 | PLN | Poland | 6.3 | 3.87 | 1.6279069767441898 |
148 | 148 | 2004-05-01 | RUB | Russia | 42.0 | 29.0 | 1.44827586206897 |
149 | 149 | 2004-05-01 | SAR | Saudi Arabia | 2.4 | 3.7502 | 0.639965868487014 |
150 | 150 | 2004-05-01 | SGD | Singapore | 3.3 | 1.71 | 1.9298245614035097 |
151 | 151 | 2004-05-01 | SEK | Sweden | 30.0 | 7.61 | 3.94218134034166 |
152 | 152 | 2004-05-01 | THB | Thailand | 59.0 | 40.8 | 1.44607843137255 |
153 | 153 | 2004-05-01 | TRY | Turkey | 3950000.0 | 1531000.0 | 2.58001306335728 |
154 | 154 | 2004-05-01 | TWD | Taiwan | 75.0 | 33.4 | 2.24550898203593 |
155 | 155 | 2004-05-01 | UAH | Ukraine | 7.25 | 5.3315 | 1.35984244584076 |
156 | 156 | 2004-05-01 | UYU | Uruguay | 29.8 | 29.735 | 1.00218597612241 |
157 | 157 | 2004-05-01 | USD | United States | 2.9 | 1.0 | 2.9 |
158 | 158 | 2004-05-01 | ZAR | South Africa | 12.4 | 6.66 | 1.86186186186186 |
1450 | 1450 | 2004-05-01 | ARS | Argentina | 4.36 | 2.95 | 1.4779661016949202 |
1451 | 1451 | 2004-05-01 | AUD | Australia | 3.25 | 1.43 | 2.2727272727272703 |
1452 | 1452 | 2004-05-01 | BRL | Brazil | 5.4 | 3.18 | 1.69811320754717 |
1453 | 1453 | 2004-05-01 | CAD | Canada | 3.19 | 1.37 | 2.3284671532846697 |
1454 | 1454 | 2004-05-01 | CHF | Switzerland | 6.3 | 1.29 | 4.88372093023256 |
1455 | 1455 | 2004-05-01 | CLP | Chile | 1400.0 | 641.0 | 2.18408736349454 |
1456 | 1456 | 2004-05-01 | CNY | China | 10.4 | 8.28 | 1.256038647343 |
1457 | 1457 | 2004-05-01 | COP | Colombia | 6500.0 | 2769.83 | 2.3467144192964904 |
1458 | 1458 | 2004-05-01 | CRC | Costa Rica | 1130.0 | 433.55 | 2.60638911313574 |
1459 | 1459 | 2004-05-01 | CZK | Czech Republic | 56.42 | 26.5 | 2.12905660377359 |
1460 | 1460 | 2004-05-01 | DKK | Denmark | 27.75 | 6.22 | 4.46141479099679 |
1461 | 1461 | 2004-05-01 | EGP | Egypt | 10.0 | 6.19 | 1.6155088852988702 |
1462 | 1462 | 2004-05-01 | EUR | Euro area | 2.74 | 0.833333333 | 3.2880000013152 |
1463 | 1463 | 2004-05-01 | GBP | Britain | 1.88 | 0.558659218 | 3.3651999992596604 |
1464 | 1464 | 2004-05-01 | HKD | Hong Kong | 12.0 | 7.79 | 1.54043645699615 |
1465 | 1465 | 2004-05-01 | HUF | Hungary | 530.0 | 211.0 | 2.51184834123223 |
1466 | 1466 | 2004-05-01 | IDR | Indonesia | 16100.0 | 9120.0 | 1.76535087719298 |
1467 | 1467 | 2004-05-01 | JPY | Japan | 262.0 | 113.0 | 2.31858407079646 |
1468 | 1468 | 2004-05-01 | KRW | South Korea | 3200.0 | 1177.0 | 2.71877655055225 |
1469 | 1469 | 2004-05-01 | LKR | Sri Lanka | 140.0 | 99.0 | 1.41414141414141 |
1470 | 1470 | 2004-05-01 | MXN | Mexico | 24.0 | 11.6 | 2.06896551724138 |
1471 | 1471 | 2004-05-01 | MYR | Malaysia | 5.04 | 3.8 | 1.32631578947368 |
1472 | 1472 | 2004-05-01 | NOK | Norway | 35.5 | 6.8491 | 5.183162751310389 |
1473 | 1473 | 2004-05-01 | NZD | New Zealand | 4.35 | 1.64 | 2.6524390243902403 |
1474 | 1474 | 2004-05-01 | PKR | Pakistan | 110.0 | 57.76 | 1.90443213296399 |
1475 | 1475 | 2004-05-01 | PEN | Peru | 8.99 | 3.49 | 2.57593123209169 |
1476 | 1476 | 2004-05-01 | PHP | Philippines | 69.0 | 55.9 | 1.23434704830054 |
1477 | 1477 | 2004-05-01 | PLN | Poland | 6.3 | 3.87 | 1.6279069767441898 |
1478 | 1478 | 2004-05-01 | RUB | Russia | 42.0 | 29.0 | 1.44827586206897 |
1479 | 1479 | 2004-05-01 | SAR | Saudi Arabia | 2.4 | 3.7502 | 0.639965868487014 |
1480 | 1480 | 2004-05-01 | SGD | Singapore | 3.3 | 1.71 | 1.9298245614035097 |
1481 | 1481 | 2004-05-01 | SEK | Sweden | 30.0 | 7.61 | 3.94218134034166 |
1482 | 1482 | 2004-05-01 | THB | Thailand | 59.0 | 40.8 | 1.44607843137255 |
1483 | 1483 | 2004-05-01 | TRY | Turkey | 3950000.0 | 1531000.0 | 2.58001306335728 |
1484 | 1484 | 2004-05-01 | TWD | Taiwan | 75.0 | 33.4 | 2.24550898203593 |
1485 | 1485 | 2004-05-01 | UAH | Ukraine | 7.25 | 5.3315 | 1.35984244584076 |
1486 | 1486 | 2004-05-01 | UYU | Uruguay | 29.8 | 29.735 | 1.00218597612241 |
1487 | 1487 | 2004-05-01 | USD | United States | 2.9 | 1.0 | 2.9 |
1488 | 1488 | 2004-05-01 | ZAR | South Africa | 12.4 | 6.66 | 1.86186186186186 |
2780 | 2780 | 2004-05-01 | ARS | Argentina | 4.36 | 2.95 | 1.4779661016949202 |
2781 | 2781 | 2004-05-01 | AUD | Australia | 3.25 | 1.43 | 2.2727272727272703 |
2782 | 2782 | 2004-05-01 | BRL | Brazil | 5.4 | 3.18 | 1.69811320754717 |
2783 | 2783 | 2004-05-01 | CAD | Canada | 3.19 | 1.37 | 2.3284671532846697 |
2784 | 2784 | 2004-05-01 | CHF | Switzerland | 6.3 | 1.29 | 4.88372093023256 |
2785 | 2785 | 2004-05-01 | CLP | Chile | 1400.0 | 641.0 | 2.18408736349454 |
2786 | 2786 | 2004-05-01 | CNY | China | 10.4 | 8.28 | 1.256038647343 |
2787 | 2787 | 2004-05-01 | COP | Colombia | 6500.0 | 2769.83 | 2.3467144192964904 |
2788 | 2788 | 2004-05-01 | CRC | Costa Rica | 1130.0 | 433.55 | 2.60638911313574 |
2789 | 2789 | 2004-05-01 | CZK | Czech Republic | 56.42 | 26.5 | 2.12905660377359 |
2790 | 2790 | 2004-05-01 | DKK | Denmark | 27.75 | 6.22 | 4.46141479099679 |
2791 | 2791 | 2004-05-01 | EGP | Egypt | 10.0 | 6.19 | 1.6155088852988702 |
2792 | 2792 | 2004-05-01 | EUR | Euro area | 2.74 | 0.833333333 | 3.2880000013152 |
2793 | 2793 | 2004-05-01 | GBP | Britain | 1.88 | 0.558659218 | 3.3651999992596604 |
2794 | 2794 | 2004-05-01 | HKD | Hong Kong | 12.0 | 7.79 | 1.54043645699615 |
2795 | 2795 | 2004-05-01 | HUF | Hungary | 530.0 | 211.0 | 2.51184834123223 |
2796 | 2796 | 2004-05-01 | IDR | Indonesia | 16100.0 | 9120.0 | 1.76535087719298 |
2797 | 2797 | 2004-05-01 | JPY | Japan | 262.0 | 113.0 | 2.31858407079646 |
2798 | 2798 | 2004-05-01 | KRW | South Korea | 3200.0 | 1177.0 | 2.71877655055225 |
2799 | 2799 | 2004-05-01 | LKR | Sri Lanka | 140.0 | 99.0 | 1.41414141414141 |
2800 | 2800 | 2004-05-01 | MXN | Mexico | 24.0 | 11.6 | 2.06896551724138 |
2801 | 2801 | 2004-05-01 | MYR | Malaysia | 5.04 | 3.8 | 1.32631578947368 |
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 );