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 |
---|---|---|---|---|---|---|---|
3695 | 3695 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
3696 | 3696 | 2017-07-01 | HKD | Hong Kong | 19.2 | 7.8115 | 2.45791461307047 |
3697 | 3697 | 2017-07-01 | HUF | Hungary | 862.0 | 268.6239 | 3.20894752849616 |
3698 | 3698 | 2017-07-01 | IDR | Indonesia | 32126.0 | 13369.5 | 2.40293204682299 |
3699 | 3699 | 2017-07-01 | INR | India | 178.0 | 64.5575 | 2.7572319250280803 |
3700 | 3700 | 2017-07-01 | ILS | Israel | 16.9 | 3.5405 | 4.773337099279759 |
3701 | 3701 | 2017-07-01 | JPY | Japan | 380.0 | 113.06 | 3.36104723155846 |
3702 | 3702 | 2017-07-01 | KRW | South Korea | 4400.0 | 1144.65 | 3.84396977241952 |
3703 | 3703 | 2017-07-01 | LKR | Sri Lanka | 580.0 | 153.725 | 3.77297121483168 |
3704 | 3704 | 2017-07-01 | MXN | Mexico | 49.0 | 17.79075 | 2.75424026530641 |
3705 | 3705 | 2017-07-01 | MYR | Malaysia | 8.6 | 4.2935 | 2.0030278327704703 |
3706 | 3706 | 2017-07-01 | NOK | Norway | 49.0 | 8.2852 | 5.91416018925313 |
3707 | 3707 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
3708 | 3708 | 2017-07-01 | PKR | Pakistan | 375.0 | 105.15 | 3.56633380884451 |
3709 | 3709 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
3710 | 3710 | 2017-07-01 | PHP | Philippines | 134.0 | 50.5765 | 2.6494518205095297 |
3711 | 3711 | 2017-07-01 | PLN | Poland | 10.1 | 3.7086 | 2.7233996656420203 |
3712 | 3712 | 2017-07-01 | RUB | Russia | 137.0 | 60.1369 | 2.27813538775694 |
3713 | 3713 | 2017-07-01 | SAR | Saudi Arabia | 12.0 | 3.75015 | 3.1998720051198 |
3714 | 3714 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
3715 | 3715 | 2017-07-01 | SEK | Sweden | 48.97 | 8.41565 | 5.81892070131244 |
3716 | 3716 | 2017-07-01 | THB | Thailand | 119.0 | 34.0365 | 3.4962466763621403 |
3717 | 3717 | 2017-07-01 | TRY | Turkey | 10.75 | 3.57605 | 3.00611009353896 |
3718 | 3718 | 2017-07-01 | TWD | Taiwan | 69.0 | 30.4775 | 2.26396522024444 |
3719 | 3719 | 2017-07-01 | UAH | Ukraine | 44.0 | 25.915 | 1.69785838317577 |
3720 | 3720 | 2017-07-01 | UYU | Uruguay | 130.0 | 28.705 | 4.528827730360571 |
3721 | 3721 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
3722 | 3722 | 2017-07-01 | VND | Vietnam | 60000.0 | 22732.5 | 2.63939293962389 |
3723 | 3723 | 2017-07-01 | ZAR | South Africa | 30.0 | 13.27 | 2.26073850791259 |
5011 | 5011 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
5012 | 5012 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
5013 | 5013 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
5014 | 5014 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
5015 | 5015 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
5016 | 5016 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
5017 | 5017 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
5018 | 5018 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
5019 | 5019 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
5020 | 5020 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
5021 | 5021 | 2017-07-01 | CZK | Czech Republic | 75.0 | 22.8561 | 3.28139971386194 |
5022 | 5022 | 2017-07-01 | DKK | Denmark | 30.0 | 6.51255 | 4.60649054517816 |
5023 | 5023 | 2017-07-01 | EGP | Egypt | 31.37 | 17.885 | 1.7539837852949398 |
5024 | 5024 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
5025 | 5025 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
5026 | 5026 | 2017-07-01 | HKD | Hong Kong | 19.2 | 7.8115 | 2.45791461307047 |
5027 | 5027 | 2017-07-01 | HUF | Hungary | 862.0 | 268.6239 | 3.20894752849616 |
5028 | 5028 | 2017-07-01 | IDR | Indonesia | 32126.0 | 13369.5 | 2.40293204682299 |
5029 | 5029 | 2017-07-01 | INR | India | 178.0 | 64.5575 | 2.7572319250280803 |
5030 | 5030 | 2017-07-01 | ILS | Israel | 16.9 | 3.5405 | 4.773337099279759 |
5031 | 5031 | 2017-07-01 | JPY | Japan | 380.0 | 113.06 | 3.36104723155846 |
5032 | 5032 | 2017-07-01 | KRW | South Korea | 4400.0 | 1144.65 | 3.84396977241952 |
5033 | 5033 | 2017-07-01 | LKR | Sri Lanka | 580.0 | 153.725 | 3.77297121483168 |
5034 | 5034 | 2017-07-01 | MXN | Mexico | 49.0 | 17.79075 | 2.75424026530641 |
5035 | 5035 | 2017-07-01 | MYR | Malaysia | 8.6 | 4.2935 | 2.0030278327704703 |
5036 | 5036 | 2017-07-01 | NOK | Norway | 49.0 | 8.2852 | 5.91416018925313 |
5037 | 5037 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
5038 | 5038 | 2017-07-01 | PKR | Pakistan | 375.0 | 105.15 | 3.56633380884451 |
5039 | 5039 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
5040 | 5040 | 2017-07-01 | PHP | Philippines | 134.0 | 50.5765 | 2.6494518205095297 |
5041 | 5041 | 2017-07-01 | PLN | Poland | 10.1 | 3.7086 | 2.7233996656420203 |
5042 | 5042 | 2017-07-01 | RUB | Russia | 137.0 | 60.1369 | 2.27813538775694 |
5043 | 5043 | 2017-07-01 | SAR | Saudi Arabia | 12.0 | 3.75015 | 3.1998720051198 |
5044 | 5044 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
5045 | 5045 | 2017-07-01 | SEK | Sweden | 48.97 | 8.41565 | 5.81892070131244 |
5046 | 5046 | 2017-07-01 | THB | Thailand | 119.0 | 34.0365 | 3.4962466763621403 |
5047 | 5047 | 2017-07-01 | TRY | Turkey | 10.75 | 3.57605 | 3.00611009353896 |
5048 | 5048 | 2017-07-01 | TWD | Taiwan | 69.0 | 30.4775 | 2.26396522024444 |
5049 | 5049 | 2017-07-01 | UAH | Ukraine | 44.0 | 25.915 | 1.69785838317577 |
5050 | 5050 | 2017-07-01 | UYU | Uruguay | 130.0 | 28.705 | 4.528827730360571 |
5051 | 5051 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
5052 | 5052 | 2017-07-01 | VND | Vietnam | 60000.0 | 22732.5 | 2.63939293962389 |
5053 | 5053 | 2017-07-01 | ZAR | South Africa | 30.0 | 13.27 | 2.26073850791259 |
6341 | 6341 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
6342 | 6342 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
6343 | 6343 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
6344 | 6344 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
6345 | 6345 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
6346 | 6346 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
6347 | 6347 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
6348 | 6348 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
6349 | 6349 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
6350 | 6350 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
6351 | 6351 | 2017-07-01 | CZK | Czech Republic | 75.0 | 22.8561 | 3.28139971386194 |
6352 | 6352 | 2017-07-01 | DKK | Denmark | 30.0 | 6.51255 | 4.60649054517816 |
6353 | 6353 | 2017-07-01 | EGP | Egypt | 31.37 | 17.885 | 1.7539837852949398 |
6354 | 6354 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
6355 | 6355 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
6356 | 6356 | 2017-07-01 | HKD | Hong Kong | 19.2 | 7.8115 | 2.45791461307047 |
6357 | 6357 | 2017-07-01 | HUF | Hungary | 862.0 | 268.6239 | 3.20894752849616 |
6358 | 6358 | 2017-07-01 | IDR | Indonesia | 32126.0 | 13369.5 | 2.40293204682299 |
6359 | 6359 | 2017-07-01 | INR | India | 178.0 | 64.5575 | 2.7572319250280803 |
6360 | 6360 | 2017-07-01 | ILS | Israel | 16.9 | 3.5405 | 4.773337099279759 |
6361 | 6361 | 2017-07-01 | JPY | Japan | 380.0 | 113.06 | 3.36104723155846 |
6362 | 6362 | 2017-07-01 | KRW | South Korea | 4400.0 | 1144.65 | 3.84396977241952 |
6363 | 6363 | 2017-07-01 | LKR | Sri Lanka | 580.0 | 153.725 | 3.77297121483168 |
6364 | 6364 | 2017-07-01 | MXN | Mexico | 49.0 | 17.79075 | 2.75424026530641 |
6365 | 6365 | 2017-07-01 | MYR | Malaysia | 8.6 | 4.2935 | 2.0030278327704703 |
6366 | 6366 | 2017-07-01 | NOK | Norway | 49.0 | 8.2852 | 5.91416018925313 |
6367 | 6367 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
6368 | 6368 | 2017-07-01 | PKR | Pakistan | 375.0 | 105.15 | 3.56633380884451 |
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 );