bigmac
430 rows where "date" is on date 2017-07-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
1021 | 1021 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
1022 | 1022 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
1023 | 1023 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
1024 | 1024 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
1025 | 1025 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
1026 | 1026 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
1027 | 1027 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
1028 | 1028 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
1029 | 1029 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
1030 | 1030 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
1031 | 1031 | 2017-07-01 | CZK | Czech Republic | 75.0 | 22.8561 | 3.28139971386194 |
1032 | 1032 | 2017-07-01 | DKK | Denmark | 30.0 | 6.51255 | 4.60649054517816 |
1033 | 1033 | 2017-07-01 | EGP | Egypt | 31.37 | 17.885 | 1.7539837852949398 |
1034 | 1034 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
1035 | 1035 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
1036 | 1036 | 2017-07-01 | HKD | Hong Kong | 19.2 | 7.8115 | 2.45791461307047 |
1037 | 1037 | 2017-07-01 | HUF | Hungary | 862.0 | 268.6239 | 3.20894752849616 |
1038 | 1038 | 2017-07-01 | IDR | Indonesia | 32126.0 | 13369.5 | 2.40293204682299 |
1039 | 1039 | 2017-07-01 | INR | India | 178.0 | 64.5575 | 2.7572319250280803 |
1040 | 1040 | 2017-07-01 | ILS | Israel | 16.9 | 3.5405 | 4.773337099279759 |
1041 | 1041 | 2017-07-01 | JPY | Japan | 380.0 | 113.06 | 3.36104723155846 |
1042 | 1042 | 2017-07-01 | KRW | South Korea | 4400.0 | 1144.65 | 3.84396977241952 |
1043 | 1043 | 2017-07-01 | LKR | Sri Lanka | 580.0 | 153.725 | 3.77297121483168 |
1044 | 1044 | 2017-07-01 | MXN | Mexico | 49.0 | 17.79075 | 2.75424026530641 |
1045 | 1045 | 2017-07-01 | MYR | Malaysia | 8.6 | 4.2935 | 2.0030278327704703 |
1046 | 1046 | 2017-07-01 | NOK | Norway | 49.0 | 8.2852 | 5.91416018925313 |
1047 | 1047 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
1048 | 1048 | 2017-07-01 | PKR | Pakistan | 375.0 | 105.15 | 3.56633380884451 |
1049 | 1049 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
1050 | 1050 | 2017-07-01 | PHP | Philippines | 134.0 | 50.5765 | 2.6494518205095297 |
1051 | 1051 | 2017-07-01 | PLN | Poland | 10.1 | 3.7086 | 2.7233996656420203 |
1052 | 1052 | 2017-07-01 | RUB | Russia | 137.0 | 60.1369 | 2.27813538775694 |
1053 | 1053 | 2017-07-01 | SAR | Saudi Arabia | 12.0 | 3.75015 | 3.1998720051198 |
1054 | 1054 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
1055 | 1055 | 2017-07-01 | SEK | Sweden | 48.97 | 8.41565 | 5.81892070131244 |
1056 | 1056 | 2017-07-01 | THB | Thailand | 119.0 | 34.0365 | 3.4962466763621403 |
1057 | 1057 | 2017-07-01 | TRY | Turkey | 10.75 | 3.57605 | 3.00611009353896 |
1058 | 1058 | 2017-07-01 | TWD | Taiwan | 69.0 | 30.4775 | 2.26396522024444 |
1059 | 1059 | 2017-07-01 | UAH | Ukraine | 44.0 | 25.915 | 1.69785838317577 |
1060 | 1060 | 2017-07-01 | UYU | Uruguay | 130.0 | 28.705 | 4.528827730360571 |
1061 | 1061 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
1062 | 1062 | 2017-07-01 | VND | Vietnam | 60000.0 | 22732.5 | 2.63939293962389 |
1063 | 1063 | 2017-07-01 | ZAR | South Africa | 30.0 | 13.27 | 2.26073850791259 |
2351 | 2351 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
2352 | 2352 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
2353 | 2353 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
2354 | 2354 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
2355 | 2355 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
2356 | 2356 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
2357 | 2357 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
2358 | 2358 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
2359 | 2359 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
2360 | 2360 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
2361 | 2361 | 2017-07-01 | CZK | Czech Republic | 75.0 | 22.8561 | 3.28139971386194 |
2362 | 2362 | 2017-07-01 | DKK | Denmark | 30.0 | 6.51255 | 4.60649054517816 |
2363 | 2363 | 2017-07-01 | EGP | Egypt | 31.37 | 17.885 | 1.7539837852949398 |
2364 | 2364 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
2365 | 2365 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
2366 | 2366 | 2017-07-01 | HKD | Hong Kong | 19.2 | 7.8115 | 2.45791461307047 |
2367 | 2367 | 2017-07-01 | HUF | Hungary | 862.0 | 268.6239 | 3.20894752849616 |
2368 | 2368 | 2017-07-01 | IDR | Indonesia | 32126.0 | 13369.5 | 2.40293204682299 |
2369 | 2369 | 2017-07-01 | INR | India | 178.0 | 64.5575 | 2.7572319250280803 |
2370 | 2370 | 2017-07-01 | ILS | Israel | 16.9 | 3.5405 | 4.773337099279759 |
2371 | 2371 | 2017-07-01 | JPY | Japan | 380.0 | 113.06 | 3.36104723155846 |
2372 | 2372 | 2017-07-01 | KRW | South Korea | 4400.0 | 1144.65 | 3.84396977241952 |
2373 | 2373 | 2017-07-01 | LKR | Sri Lanka | 580.0 | 153.725 | 3.77297121483168 |
2374 | 2374 | 2017-07-01 | MXN | Mexico | 49.0 | 17.79075 | 2.75424026530641 |
2375 | 2375 | 2017-07-01 | MYR | Malaysia | 8.6 | 4.2935 | 2.0030278327704703 |
2376 | 2376 | 2017-07-01 | NOK | Norway | 49.0 | 8.2852 | 5.91416018925313 |
2377 | 2377 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
2378 | 2378 | 2017-07-01 | PKR | Pakistan | 375.0 | 105.15 | 3.56633380884451 |
2379 | 2379 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
2380 | 2380 | 2017-07-01 | PHP | Philippines | 134.0 | 50.5765 | 2.6494518205095297 |
2381 | 2381 | 2017-07-01 | PLN | Poland | 10.1 | 3.7086 | 2.7233996656420203 |
2382 | 2382 | 2017-07-01 | RUB | Russia | 137.0 | 60.1369 | 2.27813538775694 |
2383 | 2383 | 2017-07-01 | SAR | Saudi Arabia | 12.0 | 3.75015 | 3.1998720051198 |
2384 | 2384 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
2385 | 2385 | 2017-07-01 | SEK | Sweden | 48.97 | 8.41565 | 5.81892070131244 |
2386 | 2386 | 2017-07-01 | THB | Thailand | 119.0 | 34.0365 | 3.4962466763621403 |
2387 | 2387 | 2017-07-01 | TRY | Turkey | 10.75 | 3.57605 | 3.00611009353896 |
2388 | 2388 | 2017-07-01 | TWD | Taiwan | 69.0 | 30.4775 | 2.26396522024444 |
2389 | 2389 | 2017-07-01 | UAH | Ukraine | 44.0 | 25.915 | 1.69785838317577 |
2390 | 2390 | 2017-07-01 | UYU | Uruguay | 130.0 | 28.705 | 4.528827730360571 |
2391 | 2391 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
2392 | 2392 | 2017-07-01 | VND | Vietnam | 60000.0 | 22732.5 | 2.63939293962389 |
2393 | 2393 | 2017-07-01 | ZAR | South Africa | 30.0 | 13.27 | 2.26073850791259 |
3681 | 3681 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
3682 | 3682 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
3683 | 3683 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
3684 | 3684 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
3685 | 3685 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
3686 | 3686 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
3687 | 3687 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
3688 | 3688 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
3689 | 3689 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
3690 | 3690 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
3691 | 3691 | 2017-07-01 | CZK | Czech Republic | 75.0 | 22.8561 | 3.28139971386194 |
3692 | 3692 | 2017-07-01 | DKK | Denmark | 30.0 | 6.51255 | 4.60649054517816 |
3693 | 3693 | 2017-07-01 | EGP | Egypt | 31.37 | 17.885 | 1.7539837852949398 |
3694 | 3694 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
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 );