bigmac
430 rows where "date" is on date 2017-07-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
13033 | 13033 | 2017-07-01 | ZAR | South Africa | 30.0 | 13.27 | 2.26073850791259 |
13032 | 13032 | 2017-07-01 | VND | Vietnam | 60000.0 | 22732.5 | 2.63939293962389 |
13031 | 13031 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
13030 | 13030 | 2017-07-01 | UYU | Uruguay | 130.0 | 28.705 | 4.528827730360571 |
13029 | 13029 | 2017-07-01 | UAH | Ukraine | 44.0 | 25.915 | 1.69785838317577 |
13028 | 13028 | 2017-07-01 | TWD | Taiwan | 69.0 | 30.4775 | 2.26396522024444 |
13027 | 13027 | 2017-07-01 | TRY | Turkey | 10.75 | 3.57605 | 3.00611009353896 |
13026 | 13026 | 2017-07-01 | THB | Thailand | 119.0 | 34.0365 | 3.4962466763621403 |
13025 | 13025 | 2017-07-01 | SEK | Sweden | 48.97 | 8.41565 | 5.81892070131244 |
13024 | 13024 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
13023 | 13023 | 2017-07-01 | SAR | Saudi Arabia | 12.0 | 3.75015 | 3.1998720051198 |
13022 | 13022 | 2017-07-01 | RUB | Russia | 137.0 | 60.1369 | 2.27813538775694 |
13021 | 13021 | 2017-07-01 | PLN | Poland | 10.1 | 3.7086 | 2.7233996656420203 |
13020 | 13020 | 2017-07-01 | PHP | Philippines | 134.0 | 50.5765 | 2.6494518205095297 |
13019 | 13019 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
13018 | 13018 | 2017-07-01 | PKR | Pakistan | 375.0 | 105.15 | 3.56633380884451 |
13017 | 13017 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
13016 | 13016 | 2017-07-01 | NOK | Norway | 49.0 | 8.2852 | 5.91416018925313 |
13015 | 13015 | 2017-07-01 | MYR | Malaysia | 8.6 | 4.2935 | 2.0030278327704703 |
13014 | 13014 | 2017-07-01 | MXN | Mexico | 49.0 | 17.79075 | 2.75424026530641 |
13013 | 13013 | 2017-07-01 | LKR | Sri Lanka | 580.0 | 153.725 | 3.77297121483168 |
13012 | 13012 | 2017-07-01 | KRW | South Korea | 4400.0 | 1144.65 | 3.84396977241952 |
13011 | 13011 | 2017-07-01 | JPY | Japan | 380.0 | 113.06 | 3.36104723155846 |
13010 | 13010 | 2017-07-01 | ILS | Israel | 16.9 | 3.5405 | 4.773337099279759 |
13009 | 13009 | 2017-07-01 | INR | India | 178.0 | 64.5575 | 2.7572319250280803 |
13008 | 13008 | 2017-07-01 | IDR | Indonesia | 32126.0 | 13369.5 | 2.40293204682299 |
13007 | 13007 | 2017-07-01 | HUF | Hungary | 862.0 | 268.6239 | 3.20894752849616 |
13006 | 13006 | 2017-07-01 | HKD | Hong Kong | 19.2 | 7.8115 | 2.45791461307047 |
13005 | 13005 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
13004 | 13004 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
13003 | 13003 | 2017-07-01 | EGP | Egypt | 31.37 | 17.885 | 1.7539837852949398 |
13002 | 13002 | 2017-07-01 | DKK | Denmark | 30.0 | 6.51255 | 4.60649054517816 |
13001 | 13001 | 2017-07-01 | CZK | Czech Republic | 75.0 | 22.8561 | 3.28139971386194 |
13000 | 13000 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
12999 | 12999 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
12998 | 12998 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
12997 | 12997 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
12996 | 12996 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
12995 | 12995 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
12994 | 12994 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
12993 | 12993 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
12992 | 12992 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
12991 | 12991 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
11703 | 11703 | 2017-07-01 | ZAR | South Africa | 30.0 | 13.27 | 2.26073850791259 |
11702 | 11702 | 2017-07-01 | VND | Vietnam | 60000.0 | 22732.5 | 2.63939293962389 |
11701 | 11701 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
11700 | 11700 | 2017-07-01 | UYU | Uruguay | 130.0 | 28.705 | 4.528827730360571 |
11699 | 11699 | 2017-07-01 | UAH | Ukraine | 44.0 | 25.915 | 1.69785838317577 |
11698 | 11698 | 2017-07-01 | TWD | Taiwan | 69.0 | 30.4775 | 2.26396522024444 |
11697 | 11697 | 2017-07-01 | TRY | Turkey | 10.75 | 3.57605 | 3.00611009353896 |
11696 | 11696 | 2017-07-01 | THB | Thailand | 119.0 | 34.0365 | 3.4962466763621403 |
11695 | 11695 | 2017-07-01 | SEK | Sweden | 48.97 | 8.41565 | 5.81892070131244 |
11694 | 11694 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
11693 | 11693 | 2017-07-01 | SAR | Saudi Arabia | 12.0 | 3.75015 | 3.1998720051198 |
11692 | 11692 | 2017-07-01 | RUB | Russia | 137.0 | 60.1369 | 2.27813538775694 |
11691 | 11691 | 2017-07-01 | PLN | Poland | 10.1 | 3.7086 | 2.7233996656420203 |
11690 | 11690 | 2017-07-01 | PHP | Philippines | 134.0 | 50.5765 | 2.6494518205095297 |
11689 | 11689 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
11688 | 11688 | 2017-07-01 | PKR | Pakistan | 375.0 | 105.15 | 3.56633380884451 |
11687 | 11687 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
11686 | 11686 | 2017-07-01 | NOK | Norway | 49.0 | 8.2852 | 5.91416018925313 |
11685 | 11685 | 2017-07-01 | MYR | Malaysia | 8.6 | 4.2935 | 2.0030278327704703 |
11684 | 11684 | 2017-07-01 | MXN | Mexico | 49.0 | 17.79075 | 2.75424026530641 |
11683 | 11683 | 2017-07-01 | LKR | Sri Lanka | 580.0 | 153.725 | 3.77297121483168 |
11682 | 11682 | 2017-07-01 | KRW | South Korea | 4400.0 | 1144.65 | 3.84396977241952 |
11681 | 11681 | 2017-07-01 | JPY | Japan | 380.0 | 113.06 | 3.36104723155846 |
11680 | 11680 | 2017-07-01 | ILS | Israel | 16.9 | 3.5405 | 4.773337099279759 |
11679 | 11679 | 2017-07-01 | INR | India | 178.0 | 64.5575 | 2.7572319250280803 |
11678 | 11678 | 2017-07-01 | IDR | Indonesia | 32126.0 | 13369.5 | 2.40293204682299 |
11677 | 11677 | 2017-07-01 | HUF | Hungary | 862.0 | 268.6239 | 3.20894752849616 |
11676 | 11676 | 2017-07-01 | HKD | Hong Kong | 19.2 | 7.8115 | 2.45791461307047 |
11675 | 11675 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
11674 | 11674 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
11673 | 11673 | 2017-07-01 | EGP | Egypt | 31.37 | 17.885 | 1.7539837852949398 |
11672 | 11672 | 2017-07-01 | DKK | Denmark | 30.0 | 6.51255 | 4.60649054517816 |
11671 | 11671 | 2017-07-01 | CZK | Czech Republic | 75.0 | 22.8561 | 3.28139971386194 |
11670 | 11670 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
11669 | 11669 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
11668 | 11668 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
11667 | 11667 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
11666 | 11666 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
11665 | 11665 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
11664 | 11664 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
11663 | 11663 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
11662 | 11662 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
11661 | 11661 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
10373 | 10373 | 2017-07-01 | ZAR | South Africa | 30.0 | 13.27 | 2.26073850791259 |
10372 | 10372 | 2017-07-01 | VND | Vietnam | 60000.0 | 22732.5 | 2.63939293962389 |
10371 | 10371 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
10370 | 10370 | 2017-07-01 | UYU | Uruguay | 130.0 | 28.705 | 4.528827730360571 |
10369 | 10369 | 2017-07-01 | UAH | Ukraine | 44.0 | 25.915 | 1.69785838317577 |
10368 | 10368 | 2017-07-01 | TWD | Taiwan | 69.0 | 30.4775 | 2.26396522024444 |
10367 | 10367 | 2017-07-01 | TRY | Turkey | 10.75 | 3.57605 | 3.00611009353896 |
10366 | 10366 | 2017-07-01 | THB | Thailand | 119.0 | 34.0365 | 3.4962466763621403 |
10365 | 10365 | 2017-07-01 | SEK | Sweden | 48.97 | 8.41565 | 5.81892070131244 |
10364 | 10364 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
10363 | 10363 | 2017-07-01 | SAR | Saudi Arabia | 12.0 | 3.75015 | 3.1998720051198 |
10362 | 10362 | 2017-07-01 | RUB | Russia | 137.0 | 60.1369 | 2.27813538775694 |
10361 | 10361 | 2017-07-01 | PLN | Poland | 10.1 | 3.7086 | 2.7233996656420203 |
10360 | 10360 | 2017-07-01 | PHP | Philippines | 134.0 | 50.5765 | 2.6494518205095297 |
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 );