bigmac
410 rows where "date" is on date 2010-07-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
3150 | 3150 | 2010-07-01 | ILS | Israel | 14.9 | 3.8619 | 3.85820451073306 |
3151 | 3151 | 2010-07-01 | JPY | Japan | 320.0 | 87.18 | 3.67056664372563 |
3152 | 3152 | 2010-07-01 | KRW | South Korea | 3400.0 | 1204.45 | 2.82286520818631 |
3153 | 3153 | 2010-07-01 | LKR | Sri Lanka | 210.0 | 112.775 | 1.86211483041454 |
3154 | 3154 | 2010-07-01 | MXN | Mexico | 32.0 | 12.782 | 2.50352057580973 |
3155 | 3155 | 2010-07-01 | MYR | Malaysia | 7.05 | 3.2135 | 2.19386961257196 |
3156 | 3156 | 2010-07-01 | NOK | Norway | 45.0 | 6.24625 | 7.20432259355613 |
3157 | 3157 | 2010-07-01 | NZD | New Zealand | 5.0 | 1.39275766 | 3.5900000004308 |
3158 | 3158 | 2010-07-01 | PKR | Pakistan | 210.0 | 85.525 | 2.4554223911137103 |
3159 | 3159 | 2010-07-01 | PEN | Peru | 10.0 | 2.8275 | 3.5366931918656097 |
3160 | 3160 | 2010-07-01 | PHP | Philippines | 102.0 | 46.47 | 2.19496449322143 |
3161 | 3161 | 2010-07-01 | PLN | Poland | 8.3 | 3.1969 | 2.59626513184648 |
3162 | 3162 | 2010-07-01 | RUB | Russia | 71.0 | 30.44325 | 2.3322082891938303 |
3163 | 3163 | 2010-07-01 | SAR | Saudi Arabia | 10.0 | 3.75045 | 2.66634670506206 |
3164 | 3164 | 2010-07-01 | SGD | Singapore | 4.23 | 1.3742 | 3.0781545626546403 |
3165 | 3165 | 2010-07-01 | SEK | Sweden | 48.4 | 7.37355 | 6.564002414033951 |
3166 | 3166 | 2010-07-01 | THB | Thailand | 70.0 | 32.305 | 2.16684723726977 |
3167 | 3167 | 2010-07-01 | TRY | Turkey | 5.95 | 1.5293 | 3.89066893349899 |
3168 | 3168 | 2010-07-01 | TWD | Taiwan | 75.0 | 32.1055 | 2.336048340627 |
3169 | 3169 | 2010-07-01 | UAH | Ukraine | 14.5 | 7.899 | 1.8356754019496104 |
3170 | 3170 | 2010-07-01 | UYU | Uruguay | 79.0 | 21.1 | 3.74407582938389 |
3171 | 3171 | 2010-07-01 | USD | United States | 3.733333333 | 1.0 | 3.733333333 |
3172 | 3172 | 2010-07-01 | ZAR | South Africa | 18.45 | 7.5365 | 2.44808598155643 |
4462 | 4462 | 2010-07-01 | AED | UAE | 11.0 | 3.67285 | 2.99494942619492 |
4463 | 4463 | 2010-07-01 | ARS | Argentina | 14.0 | 3.93375 | 3.55894502700985 |
4464 | 4464 | 2010-07-01 | AUD | Australia | 4.35 | 1.133722578 | 3.8369175002881497 |
4465 | 4465 | 2010-07-01 | BRL | Brazil | 8.71 | 1.77495 | 4.907180483957299 |
4466 | 4466 | 2010-07-01 | CAD | Canada | 4.17 | 1.04235 | 4.000575622391709 |
4467 | 4467 | 2010-07-01 | CHF | Switzerland | 6.5 | 1.05085 | 6.185468906123611 |
4468 | 4468 | 2010-07-01 | CLP | Chile | 1750.0 | 523.65 | 3.34192685954359 |
4469 | 4469 | 2010-07-01 | CNY | China | 13.2 | 6.7769 | 1.9477932387965 |
4470 | 4470 | 2010-07-01 | COP | Colombia | 8200.0 | 1868.45 | 4.388664400974069 |
4471 | 4471 | 2010-07-01 | CRC | Costa Rica | 2000.0 | 522.115 | 3.83057372417954 |
4472 | 4472 | 2010-07-01 | CZK | Czech Republic | 67.64 | 19.7476 | 3.4252263566205494 |
4473 | 4473 | 2010-07-01 | DKK | Denmark | 28.5 | 5.81365 | 4.90225589775786 |
4474 | 4474 | 2010-07-01 | EGP | Egypt | 13.0 | 5.699 | 2.28110194771012 |
4475 | 4475 | 2010-07-01 | EUR | Euro area | 3.3800310710000003 | 0.78015291 | 4.33252382664316 |
4476 | 4476 | 2010-07-01 | GBP | Britain | 2.29 | 0.657375756 | 3.48354799990525 |
4477 | 4477 | 2010-07-01 | HKD | Hong Kong | 14.8 | 7.7742 | 1.90373285997273 |
4478 | 4478 | 2010-07-01 | HUF | Hungary | 740.0 | 221.96915 | 3.33379661092544 |
4479 | 4479 | 2010-07-01 | IDR | Indonesia | 22780.0 | 9063.0 | 2.5135164956416203 |
4480 | 4480 | 2010-07-01 | ILS | Israel | 14.9 | 3.8619 | 3.85820451073306 |
4481 | 4481 | 2010-07-01 | JPY | Japan | 320.0 | 87.18 | 3.67056664372563 |
4482 | 4482 | 2010-07-01 | KRW | South Korea | 3400.0 | 1204.45 | 2.82286520818631 |
4483 | 4483 | 2010-07-01 | LKR | Sri Lanka | 210.0 | 112.775 | 1.86211483041454 |
4484 | 4484 | 2010-07-01 | MXN | Mexico | 32.0 | 12.782 | 2.50352057580973 |
4485 | 4485 | 2010-07-01 | MYR | Malaysia | 7.05 | 3.2135 | 2.19386961257196 |
4486 | 4486 | 2010-07-01 | NOK | Norway | 45.0 | 6.24625 | 7.20432259355613 |
4487 | 4487 | 2010-07-01 | NZD | New Zealand | 5.0 | 1.39275766 | 3.5900000004308 |
4488 | 4488 | 2010-07-01 | PKR | Pakistan | 210.0 | 85.525 | 2.4554223911137103 |
4489 | 4489 | 2010-07-01 | PEN | Peru | 10.0 | 2.8275 | 3.5366931918656097 |
4490 | 4490 | 2010-07-01 | PHP | Philippines | 102.0 | 46.47 | 2.19496449322143 |
4491 | 4491 | 2010-07-01 | PLN | Poland | 8.3 | 3.1969 | 2.59626513184648 |
4492 | 4492 | 2010-07-01 | RUB | Russia | 71.0 | 30.44325 | 2.3322082891938303 |
4493 | 4493 | 2010-07-01 | SAR | Saudi Arabia | 10.0 | 3.75045 | 2.66634670506206 |
4494 | 4494 | 2010-07-01 | SGD | Singapore | 4.23 | 1.3742 | 3.0781545626546403 |
4495 | 4495 | 2010-07-01 | SEK | Sweden | 48.4 | 7.37355 | 6.564002414033951 |
4496 | 4496 | 2010-07-01 | THB | Thailand | 70.0 | 32.305 | 2.16684723726977 |
4497 | 4497 | 2010-07-01 | TRY | Turkey | 5.95 | 1.5293 | 3.89066893349899 |
4498 | 4498 | 2010-07-01 | TWD | Taiwan | 75.0 | 32.1055 | 2.336048340627 |
4499 | 4499 | 2010-07-01 | UAH | Ukraine | 14.5 | 7.899 | 1.8356754019496104 |
4500 | 4500 | 2010-07-01 | UYU | Uruguay | 79.0 | 21.1 | 3.74407582938389 |
4501 | 4501 | 2010-07-01 | USD | United States | 3.733333333 | 1.0 | 3.733333333 |
4502 | 4502 | 2010-07-01 | ZAR | South Africa | 18.45 | 7.5365 | 2.44808598155643 |
5792 | 5792 | 2010-07-01 | AED | UAE | 11.0 | 3.67285 | 2.99494942619492 |
5793 | 5793 | 2010-07-01 | ARS | Argentina | 14.0 | 3.93375 | 3.55894502700985 |
5794 | 5794 | 2010-07-01 | AUD | Australia | 4.35 | 1.133722578 | 3.8369175002881497 |
5795 | 5795 | 2010-07-01 | BRL | Brazil | 8.71 | 1.77495 | 4.907180483957299 |
5796 | 5796 | 2010-07-01 | CAD | Canada | 4.17 | 1.04235 | 4.000575622391709 |
5797 | 5797 | 2010-07-01 | CHF | Switzerland | 6.5 | 1.05085 | 6.185468906123611 |
5798 | 5798 | 2010-07-01 | CLP | Chile | 1750.0 | 523.65 | 3.34192685954359 |
5799 | 5799 | 2010-07-01 | CNY | China | 13.2 | 6.7769 | 1.9477932387965 |
5800 | 5800 | 2010-07-01 | COP | Colombia | 8200.0 | 1868.45 | 4.388664400974069 |
5801 | 5801 | 2010-07-01 | CRC | Costa Rica | 2000.0 | 522.115 | 3.83057372417954 |
5802 | 5802 | 2010-07-01 | CZK | Czech Republic | 67.64 | 19.7476 | 3.4252263566205494 |
5803 | 5803 | 2010-07-01 | DKK | Denmark | 28.5 | 5.81365 | 4.90225589775786 |
5804 | 5804 | 2010-07-01 | EGP | Egypt | 13.0 | 5.699 | 2.28110194771012 |
5805 | 5805 | 2010-07-01 | EUR | Euro area | 3.3800310710000003 | 0.78015291 | 4.33252382664316 |
5806 | 5806 | 2010-07-01 | GBP | Britain | 2.29 | 0.657375756 | 3.48354799990525 |
5807 | 5807 | 2010-07-01 | HKD | Hong Kong | 14.8 | 7.7742 | 1.90373285997273 |
5808 | 5808 | 2010-07-01 | HUF | Hungary | 740.0 | 221.96915 | 3.33379661092544 |
5809 | 5809 | 2010-07-01 | IDR | Indonesia | 22780.0 | 9063.0 | 2.5135164956416203 |
5810 | 5810 | 2010-07-01 | ILS | Israel | 14.9 | 3.8619 | 3.85820451073306 |
5811 | 5811 | 2010-07-01 | JPY | Japan | 320.0 | 87.18 | 3.67056664372563 |
5812 | 5812 | 2010-07-01 | KRW | South Korea | 3400.0 | 1204.45 | 2.82286520818631 |
5813 | 5813 | 2010-07-01 | LKR | Sri Lanka | 210.0 | 112.775 | 1.86211483041454 |
5814 | 5814 | 2010-07-01 | MXN | Mexico | 32.0 | 12.782 | 2.50352057580973 |
5815 | 5815 | 2010-07-01 | MYR | Malaysia | 7.05 | 3.2135 | 2.19386961257196 |
5816 | 5816 | 2010-07-01 | NOK | Norway | 45.0 | 6.24625 | 7.20432259355613 |
5817 | 5817 | 2010-07-01 | NZD | New Zealand | 5.0 | 1.39275766 | 3.5900000004308 |
5818 | 5818 | 2010-07-01 | PKR | Pakistan | 210.0 | 85.525 | 2.4554223911137103 |
5819 | 5819 | 2010-07-01 | PEN | Peru | 10.0 | 2.8275 | 3.5366931918656097 |
5820 | 5820 | 2010-07-01 | PHP | Philippines | 102.0 | 46.47 | 2.19496449322143 |
5821 | 5821 | 2010-07-01 | PLN | Poland | 8.3 | 3.1969 | 2.59626513184648 |
5822 | 5822 | 2010-07-01 | RUB | Russia | 71.0 | 30.44325 | 2.3322082891938303 |
5823 | 5823 | 2010-07-01 | SAR | Saudi Arabia | 10.0 | 3.75045 | 2.66634670506206 |
5824 | 5824 | 2010-07-01 | SGD | Singapore | 4.23 | 1.3742 | 3.0781545626546403 |
5825 | 5825 | 2010-07-01 | SEK | Sweden | 48.4 | 7.37355 | 6.564002414033951 |
5826 | 5826 | 2010-07-01 | THB | Thailand | 70.0 | 32.305 | 2.16684723726977 |
5827 | 5827 | 2010-07-01 | TRY | Turkey | 5.95 | 1.5293 | 3.89066893349899 |
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 );