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 |
---|---|---|---|---|---|---|---|
10359 | 10359 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
10358 | 10358 | 2017-07-01 | PKR | Pakistan | 375.0 | 105.15 | 3.56633380884451 |
10357 | 10357 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
10356 | 10356 | 2017-07-01 | NOK | Norway | 49.0 | 8.2852 | 5.91416018925313 |
10355 | 10355 | 2017-07-01 | MYR | Malaysia | 8.6 | 4.2935 | 2.0030278327704703 |
10354 | 10354 | 2017-07-01 | MXN | Mexico | 49.0 | 17.79075 | 2.75424026530641 |
10353 | 10353 | 2017-07-01 | LKR | Sri Lanka | 580.0 | 153.725 | 3.77297121483168 |
10352 | 10352 | 2017-07-01 | KRW | South Korea | 4400.0 | 1144.65 | 3.84396977241952 |
10351 | 10351 | 2017-07-01 | JPY | Japan | 380.0 | 113.06 | 3.36104723155846 |
10350 | 10350 | 2017-07-01 | ILS | Israel | 16.9 | 3.5405 | 4.773337099279759 |
10349 | 10349 | 2017-07-01 | INR | India | 178.0 | 64.5575 | 2.7572319250280803 |
10348 | 10348 | 2017-07-01 | IDR | Indonesia | 32126.0 | 13369.5 | 2.40293204682299 |
10347 | 10347 | 2017-07-01 | HUF | Hungary | 862.0 | 268.6239 | 3.20894752849616 |
10346 | 10346 | 2017-07-01 | HKD | Hong Kong | 19.2 | 7.8115 | 2.45791461307047 |
10345 | 10345 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
10344 | 10344 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
10343 | 10343 | 2017-07-01 | EGP | Egypt | 31.37 | 17.885 | 1.7539837852949398 |
10342 | 10342 | 2017-07-01 | DKK | Denmark | 30.0 | 6.51255 | 4.60649054517816 |
10341 | 10341 | 2017-07-01 | CZK | Czech Republic | 75.0 | 22.8561 | 3.28139971386194 |
10340 | 10340 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
10339 | 10339 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
10338 | 10338 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
10337 | 10337 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
10336 | 10336 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
10335 | 10335 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
10334 | 10334 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
10333 | 10333 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
10332 | 10332 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
10331 | 10331 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
9043 | 9043 | 2017-07-01 | ZAR | South Africa | 30.0 | 13.27 | 2.26073850791259 |
9042 | 9042 | 2017-07-01 | VND | Vietnam | 60000.0 | 22732.5 | 2.63939293962389 |
9041 | 9041 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
9040 | 9040 | 2017-07-01 | UYU | Uruguay | 130.0 | 28.705 | 4.528827730360571 |
9039 | 9039 | 2017-07-01 | UAH | Ukraine | 44.0 | 25.915 | 1.69785838317577 |
9038 | 9038 | 2017-07-01 | TWD | Taiwan | 69.0 | 30.4775 | 2.26396522024444 |
9037 | 9037 | 2017-07-01 | TRY | Turkey | 10.75 | 3.57605 | 3.00611009353896 |
9036 | 9036 | 2017-07-01 | THB | Thailand | 119.0 | 34.0365 | 3.4962466763621403 |
9035 | 9035 | 2017-07-01 | SEK | Sweden | 48.97 | 8.41565 | 5.81892070131244 |
9034 | 9034 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
9033 | 9033 | 2017-07-01 | SAR | Saudi Arabia | 12.0 | 3.75015 | 3.1998720051198 |
9032 | 9032 | 2017-07-01 | RUB | Russia | 137.0 | 60.1369 | 2.27813538775694 |
9031 | 9031 | 2017-07-01 | PLN | Poland | 10.1 | 3.7086 | 2.7233996656420203 |
9030 | 9030 | 2017-07-01 | PHP | Philippines | 134.0 | 50.5765 | 2.6494518205095297 |
9029 | 9029 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
9028 | 9028 | 2017-07-01 | PKR | Pakistan | 375.0 | 105.15 | 3.56633380884451 |
9027 | 9027 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
9026 | 9026 | 2017-07-01 | NOK | Norway | 49.0 | 8.2852 | 5.91416018925313 |
9025 | 9025 | 2017-07-01 | MYR | Malaysia | 8.6 | 4.2935 | 2.0030278327704703 |
9024 | 9024 | 2017-07-01 | MXN | Mexico | 49.0 | 17.79075 | 2.75424026530641 |
9023 | 9023 | 2017-07-01 | LKR | Sri Lanka | 580.0 | 153.725 | 3.77297121483168 |
9022 | 9022 | 2017-07-01 | KRW | South Korea | 4400.0 | 1144.65 | 3.84396977241952 |
9021 | 9021 | 2017-07-01 | JPY | Japan | 380.0 | 113.06 | 3.36104723155846 |
9020 | 9020 | 2017-07-01 | ILS | Israel | 16.9 | 3.5405 | 4.773337099279759 |
9019 | 9019 | 2017-07-01 | INR | India | 178.0 | 64.5575 | 2.7572319250280803 |
9018 | 9018 | 2017-07-01 | IDR | Indonesia | 32126.0 | 13369.5 | 2.40293204682299 |
9017 | 9017 | 2017-07-01 | HUF | Hungary | 862.0 | 268.6239 | 3.20894752849616 |
9016 | 9016 | 2017-07-01 | HKD | Hong Kong | 19.2 | 7.8115 | 2.45791461307047 |
9015 | 9015 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
9014 | 9014 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
9013 | 9013 | 2017-07-01 | EGP | Egypt | 31.37 | 17.885 | 1.7539837852949398 |
9012 | 9012 | 2017-07-01 | DKK | Denmark | 30.0 | 6.51255 | 4.60649054517816 |
9011 | 9011 | 2017-07-01 | CZK | Czech Republic | 75.0 | 22.8561 | 3.28139971386194 |
9010 | 9010 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
9009 | 9009 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
9008 | 9008 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
9007 | 9007 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
9006 | 9006 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
9005 | 9005 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
9004 | 9004 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
9003 | 9003 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
9002 | 9002 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
9001 | 9001 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
7713 | 7713 | 2017-07-01 | ZAR | South Africa | 30.0 | 13.27 | 2.26073850791259 |
7712 | 7712 | 2017-07-01 | VND | Vietnam | 60000.0 | 22732.5 | 2.63939293962389 |
7711 | 7711 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
7710 | 7710 | 2017-07-01 | UYU | Uruguay | 130.0 | 28.705 | 4.528827730360571 |
7709 | 7709 | 2017-07-01 | UAH | Ukraine | 44.0 | 25.915 | 1.69785838317577 |
7708 | 7708 | 2017-07-01 | TWD | Taiwan | 69.0 | 30.4775 | 2.26396522024444 |
7707 | 7707 | 2017-07-01 | TRY | Turkey | 10.75 | 3.57605 | 3.00611009353896 |
7706 | 7706 | 2017-07-01 | THB | Thailand | 119.0 | 34.0365 | 3.4962466763621403 |
7705 | 7705 | 2017-07-01 | SEK | Sweden | 48.97 | 8.41565 | 5.81892070131244 |
7704 | 7704 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
7703 | 7703 | 2017-07-01 | SAR | Saudi Arabia | 12.0 | 3.75015 | 3.1998720051198 |
7702 | 7702 | 2017-07-01 | RUB | Russia | 137.0 | 60.1369 | 2.27813538775694 |
7701 | 7701 | 2017-07-01 | PLN | Poland | 10.1 | 3.7086 | 2.7233996656420203 |
7700 | 7700 | 2017-07-01 | PHP | Philippines | 134.0 | 50.5765 | 2.6494518205095297 |
7699 | 7699 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
7698 | 7698 | 2017-07-01 | PKR | Pakistan | 375.0 | 105.15 | 3.56633380884451 |
7697 | 7697 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
7696 | 7696 | 2017-07-01 | NOK | Norway | 49.0 | 8.2852 | 5.91416018925313 |
7695 | 7695 | 2017-07-01 | MYR | Malaysia | 8.6 | 4.2935 | 2.0030278327704703 |
7694 | 7694 | 2017-07-01 | MXN | Mexico | 49.0 | 17.79075 | 2.75424026530641 |
7693 | 7693 | 2017-07-01 | LKR | Sri Lanka | 580.0 | 153.725 | 3.77297121483168 |
7692 | 7692 | 2017-07-01 | KRW | South Korea | 4400.0 | 1144.65 | 3.84396977241952 |
7691 | 7691 | 2017-07-01 | JPY | Japan | 380.0 | 113.06 | 3.36104723155846 |
7690 | 7690 | 2017-07-01 | ILS | Israel | 16.9 | 3.5405 | 4.773337099279759 |
7689 | 7689 | 2017-07-01 | INR | India | 178.0 | 64.5575 | 2.7572319250280803 |
7688 | 7688 | 2017-07-01 | IDR | Indonesia | 32126.0 | 13369.5 | 2.40293204682299 |
7687 | 7687 | 2017-07-01 | HUF | Hungary | 862.0 | 268.6239 | 3.20894752849616 |
7686 | 7686 | 2017-07-01 | HKD | Hong Kong | 19.2 | 7.8115 | 2.45791461307047 |
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 );