bigmac
430 rows where "date" is on date 2016-01-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
12904 | 12904 | 2016-01-01 | ZAR | South Africa | 28.0 | 15.81375 | 1.7706110188917898 |
12903 | 12903 | 2016-01-01 | VND | Vietnam | 60000.0 | 22467.5 | 2.6705240903527296 |
12902 | 12902 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
12901 | 12901 | 2016-01-01 | UYU | Uruguay | 113.0 | 30.185 | 3.74358124896472 |
12900 | 12900 | 2016-01-01 | UAH | Ukraine | 36.0 | 23.35 | 1.54175588865096 |
12899 | 12899 | 2016-01-01 | TWD | Taiwan | 69.0 | 33.2315 | 2.07634322856326 |
12898 | 12898 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
12897 | 12897 | 2016-01-01 | THB | Thailand | 112.0 | 36.22 | 3.09221424627278 |
12896 | 12896 | 2016-01-01 | SEK | Sweden | 45.0 | 8.60185 | 5.23143277318251 |
12895 | 12895 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
12894 | 12894 | 2016-01-01 | SAR | Saudi Arabia | 12.0 | 3.7543 | 3.1963348693498097 |
12893 | 12893 | 2016-01-01 | RUB | Russia | 114.0 | 74.655 | 1.52702431183444 |
12892 | 12892 | 2016-01-01 | PLN | Poland | 9.6 | 4.0477 | 2.37171727153692 |
12891 | 12891 | 2016-01-01 | PHP | Philippines | 131.0 | 47.0225 | 2.7859003668456603 |
12890 | 12890 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
12889 | 12889 | 2016-01-01 | PKR | Pakistan | 300.0 | 104.885 | 2.86027553987701 |
12888 | 12888 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
12887 | 12887 | 2016-01-01 | NOK | Norway | 46.8 | 8.97465 | 5.21468803797363 |
12886 | 12886 | 2016-01-01 | MYR | Malaysia | 8.0 | 4.3925 | 1.82128628343768 |
12885 | 12885 | 2016-01-01 | MXN | Mexico | 49.0 | 17.43675 | 2.81015670924914 |
12884 | 12884 | 2016-01-01 | LKR | Sri Lanka | 350.0 | 144.05 | 2.42971190558834 |
12883 | 12883 | 2016-01-01 | KRW | South Korea | 4300.0 | 1197.75 | 3.59006470465456 |
12882 | 12882 | 2016-01-01 | JPY | Japan | 370.0 | 118.645 | 3.11854692570273 |
12881 | 12881 | 2016-01-01 | ILS | Israel | 16.9 | 3.94105 | 4.288197307824061 |
12880 | 12880 | 2016-01-01 | INR | India | 127.0 | 66.8025 | 1.9011264548482496 |
12879 | 12879 | 2016-01-01 | IDR | Indonesia | 30500.0 | 13947.5 | 2.18677182290733 |
12878 | 12878 | 2016-01-01 | HUF | Hungary | 900.0 | 292.67905 | 3.07504073147702 |
12877 | 12877 | 2016-01-01 | HKD | Hong Kong | 19.2 | 7.75235 | 2.4766683650764 |
12876 | 12876 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
12875 | 12875 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
12874 | 12874 | 2016-01-01 | EGP | Egypt | 16.93 | 7.83005 | 2.1621828723954497 |
12873 | 12873 | 2016-01-01 | DKK | Denmark | 30.0 | 6.9405 | 4.32245515452777 |
12872 | 12872 | 2016-01-01 | CZK | Czech Republic | 75.0 | 25.1442 | 2.98279523707257 |
12871 | 12871 | 2016-01-01 | CRC | Costa Rica | 2150.0 | 535.25 | 4.01681457262961 |
12870 | 12870 | 2016-01-01 | COP | Colombia | 7900.0 | 3253.9 | 2.42785580380467 |
12869 | 12869 | 2016-01-01 | CNY | China | 17.6 | 6.5582 | 2.68366320026837 |
12868 | 12868 | 2016-01-01 | CLP | Chile | 2100.0 | 715.215 | 2.9361800297812497 |
12867 | 12867 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
12866 | 12866 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
12865 | 12865 | 2016-01-01 | BRL | Brazil | 13.5 | 4.0248 | 3.35420393559928 |
12864 | 12864 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
12863 | 12863 | 2016-01-01 | ARS | Argentina | 33.0 | 13.80925 | 2.3897025544472004 |
12862 | 12862 | 2016-01-01 | AED | UAE | 13.0 | 3.6731 | 3.5392447796139503 |
11574 | 11574 | 2016-01-01 | ZAR | South Africa | 28.0 | 15.81375 | 1.7706110188917898 |
11573 | 11573 | 2016-01-01 | VND | Vietnam | 60000.0 | 22467.5 | 2.6705240903527296 |
11572 | 11572 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
11571 | 11571 | 2016-01-01 | UYU | Uruguay | 113.0 | 30.185 | 3.74358124896472 |
11570 | 11570 | 2016-01-01 | UAH | Ukraine | 36.0 | 23.35 | 1.54175588865096 |
11569 | 11569 | 2016-01-01 | TWD | Taiwan | 69.0 | 33.2315 | 2.07634322856326 |
11568 | 11568 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
11567 | 11567 | 2016-01-01 | THB | Thailand | 112.0 | 36.22 | 3.09221424627278 |
11566 | 11566 | 2016-01-01 | SEK | Sweden | 45.0 | 8.60185 | 5.23143277318251 |
11565 | 11565 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
11564 | 11564 | 2016-01-01 | SAR | Saudi Arabia | 12.0 | 3.7543 | 3.1963348693498097 |
11563 | 11563 | 2016-01-01 | RUB | Russia | 114.0 | 74.655 | 1.52702431183444 |
11562 | 11562 | 2016-01-01 | PLN | Poland | 9.6 | 4.0477 | 2.37171727153692 |
11561 | 11561 | 2016-01-01 | PHP | Philippines | 131.0 | 47.0225 | 2.7859003668456603 |
11560 | 11560 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
11559 | 11559 | 2016-01-01 | PKR | Pakistan | 300.0 | 104.885 | 2.86027553987701 |
11558 | 11558 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
11557 | 11557 | 2016-01-01 | NOK | Norway | 46.8 | 8.97465 | 5.21468803797363 |
11556 | 11556 | 2016-01-01 | MYR | Malaysia | 8.0 | 4.3925 | 1.82128628343768 |
11555 | 11555 | 2016-01-01 | MXN | Mexico | 49.0 | 17.43675 | 2.81015670924914 |
11554 | 11554 | 2016-01-01 | LKR | Sri Lanka | 350.0 | 144.05 | 2.42971190558834 |
11553 | 11553 | 2016-01-01 | KRW | South Korea | 4300.0 | 1197.75 | 3.59006470465456 |
11552 | 11552 | 2016-01-01 | JPY | Japan | 370.0 | 118.645 | 3.11854692570273 |
11551 | 11551 | 2016-01-01 | ILS | Israel | 16.9 | 3.94105 | 4.288197307824061 |
11550 | 11550 | 2016-01-01 | INR | India | 127.0 | 66.8025 | 1.9011264548482496 |
11549 | 11549 | 2016-01-01 | IDR | Indonesia | 30500.0 | 13947.5 | 2.18677182290733 |
11548 | 11548 | 2016-01-01 | HUF | Hungary | 900.0 | 292.67905 | 3.07504073147702 |
11547 | 11547 | 2016-01-01 | HKD | Hong Kong | 19.2 | 7.75235 | 2.4766683650764 |
11546 | 11546 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
11545 | 11545 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
11544 | 11544 | 2016-01-01 | EGP | Egypt | 16.93 | 7.83005 | 2.1621828723954497 |
11543 | 11543 | 2016-01-01 | DKK | Denmark | 30.0 | 6.9405 | 4.32245515452777 |
11542 | 11542 | 2016-01-01 | CZK | Czech Republic | 75.0 | 25.1442 | 2.98279523707257 |
11541 | 11541 | 2016-01-01 | CRC | Costa Rica | 2150.0 | 535.25 | 4.01681457262961 |
11540 | 11540 | 2016-01-01 | COP | Colombia | 7900.0 | 3253.9 | 2.42785580380467 |
11539 | 11539 | 2016-01-01 | CNY | China | 17.6 | 6.5582 | 2.68366320026837 |
11538 | 11538 | 2016-01-01 | CLP | Chile | 2100.0 | 715.215 | 2.9361800297812497 |
11537 | 11537 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
11536 | 11536 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
11535 | 11535 | 2016-01-01 | BRL | Brazil | 13.5 | 4.0248 | 3.35420393559928 |
11534 | 11534 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
11533 | 11533 | 2016-01-01 | ARS | Argentina | 33.0 | 13.80925 | 2.3897025544472004 |
11532 | 11532 | 2016-01-01 | AED | UAE | 13.0 | 3.6731 | 3.5392447796139503 |
10244 | 10244 | 2016-01-01 | ZAR | South Africa | 28.0 | 15.81375 | 1.7706110188917898 |
10243 | 10243 | 2016-01-01 | VND | Vietnam | 60000.0 | 22467.5 | 2.6705240903527296 |
10242 | 10242 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
10241 | 10241 | 2016-01-01 | UYU | Uruguay | 113.0 | 30.185 | 3.74358124896472 |
10240 | 10240 | 2016-01-01 | UAH | Ukraine | 36.0 | 23.35 | 1.54175588865096 |
10239 | 10239 | 2016-01-01 | TWD | Taiwan | 69.0 | 33.2315 | 2.07634322856326 |
10238 | 10238 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
10237 | 10237 | 2016-01-01 | THB | Thailand | 112.0 | 36.22 | 3.09221424627278 |
10236 | 10236 | 2016-01-01 | SEK | Sweden | 45.0 | 8.60185 | 5.23143277318251 |
10235 | 10235 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
10234 | 10234 | 2016-01-01 | SAR | Saudi Arabia | 12.0 | 3.7543 | 3.1963348693498097 |
10233 | 10233 | 2016-01-01 | RUB | Russia | 114.0 | 74.655 | 1.52702431183444 |
10232 | 10232 | 2016-01-01 | PLN | Poland | 9.6 | 4.0477 | 2.37171727153692 |
10231 | 10231 | 2016-01-01 | PHP | Philippines | 131.0 | 47.0225 | 2.7859003668456603 |
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 );