bigmac
400 rows where "date" is on date 2005-06-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
12168 | 12168 | 2005-06-01 | ZAR | South Africa | 13.95 | 6.6482 | 2.09831232514064 |
12167 | 12167 | 2005-06-01 | USD | United States | 3.06 | 1.0 | 3.06 |
12166 | 12166 | 2005-06-01 | UYU | Uruguay | 44.0 | 24.125 | 1.8238341968911895 |
12165 | 12165 | 2005-06-01 | UAH | Ukraine | 7.25 | 5.06 | 1.43280632411067 |
12164 | 12164 | 2005-06-01 | TWD | Taiwan | 75.0 | 31.175 | 2.40577385725742 |
12163 | 12163 | 2005-06-01 | TRY | Turkey | 4.0 | 1.369 | 2.9218407596786 |
12162 | 12162 | 2005-06-01 | THB | Thailand | 60.0 | 40.53 | 1.48038490007402 |
12161 | 12161 | 2005-06-01 | SEK | Sweden | 31.0 | 7.4402 | 4.16655466250907 |
12160 | 12160 | 2005-06-01 | SGD | Singapore | 3.6 | 1.6607 | 2.16776058288673 |
12159 | 12159 | 2005-06-01 | SAR | Saudi Arabia | 9.0 | 3.7501 | 2.39993600170662 |
12158 | 12158 | 2005-06-01 | RUB | Russia | 42.0 | 28.4055 | 1.47858689338332 |
12157 | 12157 | 2005-06-01 | PLN | Poland | 6.5 | 3.3096 | 1.96398356296833 |
12156 | 12156 | 2005-06-01 | PHP | Philippines | 80.0 | 54.55 | 1.4665444546287798 |
12155 | 12155 | 2005-06-01 | PEN | Peru | 8.99 | 3.2546 | 2.76224420819763 |
12154 | 12154 | 2005-06-01 | PKR | Pakistan | 130.0 | 59.62 | 2.18047635021805 |
12153 | 12153 | 2005-06-01 | NZD | New Zealand | 4.45 | 1.4023 | 3.1733580546245497 |
12152 | 12152 | 2005-06-01 | NOK | Norway | 39.0 | 6.4326 | 6.06286726984423 |
12151 | 12151 | 2005-06-01 | MYR | Malaysia | 5.25 | 3.8 | 1.38157894736842 |
12150 | 12150 | 2005-06-01 | MXN | Mexico | 28.0 | 10.8675 | 2.5764895330112703 |
12149 | 12149 | 2005-06-01 | LKR | Sri Lanka | 175.0 | 99.945 | 1.75096302966632 |
12148 | 12148 | 2005-06-01 | KRW | South Korea | 2500.0 | 1005.5 | 2.48632521133764 |
12147 | 12147 | 2005-06-01 | JPY | Japan | 250.0 | 106.715 | 2.34268846928735 |
12146 | 12146 | 2005-06-01 | IDR | Indonesia | 14600.0 | 9545.0 | 1.5295966474594 |
12145 | 12145 | 2005-06-01 | HUF | Hungary | 530.0 | 203.643 | 2.6025937547571 |
12144 | 12144 | 2005-06-01 | HKD | Hong Kong | 12.0 | 7.7807 | 1.54227768709756 |
12143 | 12143 | 2005-06-01 | GBP | Britain | 1.88 | 0.546448087 | 3.44040000271792 |
12142 | 12142 | 2005-06-01 | EUR | Euro area | 2.92 | 0.814929509 | 3.58313199823029 |
12141 | 12141 | 2005-06-01 | EGP | Egypt | 9.0 | 5.8 | 1.55172413793103 |
12140 | 12140 | 2005-06-01 | DKK | Denmark | 27.75 | 6.0647 | 4.57565914224941 |
12139 | 12139 | 2005-06-01 | CZK | Czech Republic | 56.42 | 24.5409 | 2.29901918837532 |
12138 | 12138 | 2005-06-01 | CRC | Costa Rica | 1130.0 | 475.3 | 2.3774458236903 |
12137 | 12137 | 2005-06-01 | COP | Colombia | 6500.0 | 2327.7 | 2.79245607251794 |
12136 | 12136 | 2005-06-01 | CNY | China | 10.5 | 8.2764 | 1.26866753661012 |
12135 | 12135 | 2005-06-01 | CLP | Chile | 1500.0 | 592.45 | 2.53185922862689 |
12134 | 12134 | 2005-06-01 | CHF | Switzerland | 6.3 | 1.2475 | 5.0501002004008 |
12133 | 12133 | 2005-06-01 | CAD | Canada | 3.28 | 1.2494 | 2.6252601248599303 |
12132 | 12132 | 2005-06-01 | BRL | Brazil | 5.9 | 2.4648 | 2.39370334307043 |
12131 | 12131 | 2005-06-01 | AUD | Australia | 3.25 | 1.3015 | 2.4971187091817098 |
12130 | 12130 | 2005-06-01 | ARS | Argentina | 4.75 | 2.897 | 1.6396272005522998 |
12129 | 12129 | 2005-06-01 | AED | UAE | 9.0 | 3.6725 | 2.45064669843431 |
10838 | 10838 | 2005-06-01 | ZAR | South Africa | 13.95 | 6.6482 | 2.09831232514064 |
10837 | 10837 | 2005-06-01 | USD | United States | 3.06 | 1.0 | 3.06 |
10836 | 10836 | 2005-06-01 | UYU | Uruguay | 44.0 | 24.125 | 1.8238341968911895 |
10835 | 10835 | 2005-06-01 | UAH | Ukraine | 7.25 | 5.06 | 1.43280632411067 |
10834 | 10834 | 2005-06-01 | TWD | Taiwan | 75.0 | 31.175 | 2.40577385725742 |
10833 | 10833 | 2005-06-01 | TRY | Turkey | 4.0 | 1.369 | 2.9218407596786 |
10832 | 10832 | 2005-06-01 | THB | Thailand | 60.0 | 40.53 | 1.48038490007402 |
10831 | 10831 | 2005-06-01 | SEK | Sweden | 31.0 | 7.4402 | 4.16655466250907 |
10830 | 10830 | 2005-06-01 | SGD | Singapore | 3.6 | 1.6607 | 2.16776058288673 |
10829 | 10829 | 2005-06-01 | SAR | Saudi Arabia | 9.0 | 3.7501 | 2.39993600170662 |
10828 | 10828 | 2005-06-01 | RUB | Russia | 42.0 | 28.4055 | 1.47858689338332 |
10827 | 10827 | 2005-06-01 | PLN | Poland | 6.5 | 3.3096 | 1.96398356296833 |
10826 | 10826 | 2005-06-01 | PHP | Philippines | 80.0 | 54.55 | 1.4665444546287798 |
10825 | 10825 | 2005-06-01 | PEN | Peru | 8.99 | 3.2546 | 2.76224420819763 |
10824 | 10824 | 2005-06-01 | PKR | Pakistan | 130.0 | 59.62 | 2.18047635021805 |
10823 | 10823 | 2005-06-01 | NZD | New Zealand | 4.45 | 1.4023 | 3.1733580546245497 |
10822 | 10822 | 2005-06-01 | NOK | Norway | 39.0 | 6.4326 | 6.06286726984423 |
10821 | 10821 | 2005-06-01 | MYR | Malaysia | 5.25 | 3.8 | 1.38157894736842 |
10820 | 10820 | 2005-06-01 | MXN | Mexico | 28.0 | 10.8675 | 2.5764895330112703 |
10819 | 10819 | 2005-06-01 | LKR | Sri Lanka | 175.0 | 99.945 | 1.75096302966632 |
10818 | 10818 | 2005-06-01 | KRW | South Korea | 2500.0 | 1005.5 | 2.48632521133764 |
10817 | 10817 | 2005-06-01 | JPY | Japan | 250.0 | 106.715 | 2.34268846928735 |
10816 | 10816 | 2005-06-01 | IDR | Indonesia | 14600.0 | 9545.0 | 1.5295966474594 |
10815 | 10815 | 2005-06-01 | HUF | Hungary | 530.0 | 203.643 | 2.6025937547571 |
10814 | 10814 | 2005-06-01 | HKD | Hong Kong | 12.0 | 7.7807 | 1.54227768709756 |
10813 | 10813 | 2005-06-01 | GBP | Britain | 1.88 | 0.546448087 | 3.44040000271792 |
10812 | 10812 | 2005-06-01 | EUR | Euro area | 2.92 | 0.814929509 | 3.58313199823029 |
10811 | 10811 | 2005-06-01 | EGP | Egypt | 9.0 | 5.8 | 1.55172413793103 |
10810 | 10810 | 2005-06-01 | DKK | Denmark | 27.75 | 6.0647 | 4.57565914224941 |
10809 | 10809 | 2005-06-01 | CZK | Czech Republic | 56.42 | 24.5409 | 2.29901918837532 |
10808 | 10808 | 2005-06-01 | CRC | Costa Rica | 1130.0 | 475.3 | 2.3774458236903 |
10807 | 10807 | 2005-06-01 | COP | Colombia | 6500.0 | 2327.7 | 2.79245607251794 |
10806 | 10806 | 2005-06-01 | CNY | China | 10.5 | 8.2764 | 1.26866753661012 |
10805 | 10805 | 2005-06-01 | CLP | Chile | 1500.0 | 592.45 | 2.53185922862689 |
10804 | 10804 | 2005-06-01 | CHF | Switzerland | 6.3 | 1.2475 | 5.0501002004008 |
10803 | 10803 | 2005-06-01 | CAD | Canada | 3.28 | 1.2494 | 2.6252601248599303 |
10802 | 10802 | 2005-06-01 | BRL | Brazil | 5.9 | 2.4648 | 2.39370334307043 |
10801 | 10801 | 2005-06-01 | AUD | Australia | 3.25 | 1.3015 | 2.4971187091817098 |
10800 | 10800 | 2005-06-01 | ARS | Argentina | 4.75 | 2.897 | 1.6396272005522998 |
10799 | 10799 | 2005-06-01 | AED | UAE | 9.0 | 3.6725 | 2.45064669843431 |
9508 | 9508 | 2005-06-01 | ZAR | South Africa | 13.95 | 6.6482 | 2.09831232514064 |
9507 | 9507 | 2005-06-01 | USD | United States | 3.06 | 1.0 | 3.06 |
9506 | 9506 | 2005-06-01 | UYU | Uruguay | 44.0 | 24.125 | 1.8238341968911895 |
9505 | 9505 | 2005-06-01 | UAH | Ukraine | 7.25 | 5.06 | 1.43280632411067 |
9504 | 9504 | 2005-06-01 | TWD | Taiwan | 75.0 | 31.175 | 2.40577385725742 |
9503 | 9503 | 2005-06-01 | TRY | Turkey | 4.0 | 1.369 | 2.9218407596786 |
9502 | 9502 | 2005-06-01 | THB | Thailand | 60.0 | 40.53 | 1.48038490007402 |
9501 | 9501 | 2005-06-01 | SEK | Sweden | 31.0 | 7.4402 | 4.16655466250907 |
9500 | 9500 | 2005-06-01 | SGD | Singapore | 3.6 | 1.6607 | 2.16776058288673 |
9499 | 9499 | 2005-06-01 | SAR | Saudi Arabia | 9.0 | 3.7501 | 2.39993600170662 |
9498 | 9498 | 2005-06-01 | RUB | Russia | 42.0 | 28.4055 | 1.47858689338332 |
9497 | 9497 | 2005-06-01 | PLN | Poland | 6.5 | 3.3096 | 1.96398356296833 |
9496 | 9496 | 2005-06-01 | PHP | Philippines | 80.0 | 54.55 | 1.4665444546287798 |
9495 | 9495 | 2005-06-01 | PEN | Peru | 8.99 | 3.2546 | 2.76224420819763 |
9494 | 9494 | 2005-06-01 | PKR | Pakistan | 130.0 | 59.62 | 2.18047635021805 |
9493 | 9493 | 2005-06-01 | NZD | New Zealand | 4.45 | 1.4023 | 3.1733580546245497 |
9492 | 9492 | 2005-06-01 | NOK | Norway | 39.0 | 6.4326 | 6.06286726984423 |
9491 | 9491 | 2005-06-01 | MYR | Malaysia | 5.25 | 3.8 | 1.38157894736842 |
9490 | 9490 | 2005-06-01 | MXN | Mexico | 28.0 | 10.8675 | 2.5764895330112703 |
9489 | 9489 | 2005-06-01 | LKR | Sri Lanka | 175.0 | 99.945 | 1.75096302966632 |
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 );