bigmac
430 rows where "date" is on date 2014-07-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
12775 | 12775 | 2014-07-01 | ZAR | South Africa | 24.5 | 10.5145 | 2.33011555471016 |
12774 | 12774 | 2014-07-01 | VND | Vietnam | 60000.0 | 21230.0 | 2.82618935468676 |
12773 | 12773 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
12772 | 12772 | 2014-07-01 | UYU | Uruguay | 113.0 | 22.97 | 4.91946016543317 |
12771 | 12771 | 2014-07-01 | UAH | Ukraine | 19.0 | 11.685 | 1.6260162601626 |
12770 | 12770 | 2014-07-01 | TWD | Taiwan | 79.0 | 29.982 | 2.63491428190248 |
12769 | 12769 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
12768 | 12768 | 2014-07-01 | THB | Thailand | 99.0 | 31.78 | 3.11516677155444 |
12767 | 12767 | 2014-07-01 | SEK | Sweden | 40.7 | 6.836 | 5.95377413692218 |
12766 | 12766 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
12765 | 12765 | 2014-07-01 | SAR | Saudi Arabia | 11.0 | 3.75035 | 2.93305958110576 |
12764 | 12764 | 2014-07-01 | RUB | Russia | 89.0 | 34.83725 | 2.5547366683650403 |
12763 | 12763 | 2014-07-01 | PLN | Poland | 9.2 | 3.0714 | 2.99537670117862 |
12762 | 12762 | 2014-07-01 | PHP | Philippines | 160.0 | 43.205 | 3.7032750839023296 |
12761 | 12761 | 2014-07-01 | PEN | Peru | 10.0 | 2.7880000000000003 | 3.5868005738880897 |
12760 | 12760 | 2014-07-01 | PKR | Pakistan | 300.0 | 98.68 | 3.04012971220105 |
12759 | 12759 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
12758 | 12758 | 2014-07-01 | NOK | Norway | 48.0 | 6.1873 | 7.75782651560455 |
12757 | 12757 | 2014-07-01 | MYR | Malaysia | 7.63 | 3.1675 | 2.40883977900553 |
12756 | 12756 | 2014-07-01 | MXN | Mexico | 42.0 | 12.93255 | 3.24761937900878 |
12755 | 12755 | 2014-07-01 | LKR | Sri Lanka | 350.0 | 130.255 | 2.6870369659514 |
12754 | 12754 | 2014-07-01 | KRW | South Korea | 4100.0 | 1023.75 | 4.00488400488401 |
12753 | 12753 | 2014-07-01 | JPY | Japan | 370.0 | 101.53 | 3.6442430808628 |
12752 | 12752 | 2014-07-01 | ILS | Israel | 17.5 | 3.4138 | 5.12625227019743 |
12751 | 12751 | 2014-07-01 | INR | India | 105.0 | 60.08875 | 1.7474152815626898 |
12750 | 12750 | 2014-07-01 | IDR | Indonesia | 27939.0 | 11505.0 | 2.42842242503259 |
12749 | 12749 | 2014-07-01 | HUF | Hungary | 860.0 | 228.30615 | 3.76687180787727 |
12748 | 12748 | 2014-07-01 | HKD | Hong Kong | 18.8 | 7.75045 | 2.42566560651317 |
12747 | 12747 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
12746 | 12746 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
12745 | 12745 | 2014-07-01 | EGP | Egypt | 16.93 | 7.15005 | 2.36781560968105 |
12744 | 12744 | 2014-07-01 | DKK | Denmark | 28.5 | 5.5388 | 5.14551888495703 |
12743 | 12743 | 2014-07-01 | CZK | Czech Republic | 70.45 | 20.3877 | 3.4555148447348194 |
12742 | 12742 | 2014-07-01 | CRC | Costa Rica | 2150.0 | 537.3 | 4.0014889261120405 |
12741 | 12741 | 2014-07-01 | COP | Colombia | 8600.0 | 1847.65 | 4.654561199361349 |
12740 | 12740 | 2014-07-01 | CNY | China | 16.9 | 6.1983 | 2.72655405514415 |
12739 | 12739 | 2014-07-01 | CLP | Chile | 2100.0 | 564.14 | 3.72248023540256 |
12738 | 12738 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
12737 | 12737 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
12736 | 12736 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
12735 | 12735 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
12734 | 12734 | 2014-07-01 | ARS | Argentina | 21.0 | 8.16875 | 2.5707727620505 |
12733 | 12733 | 2014-07-01 | AED | UAE | 13.0 | 3.67305 | 3.5392929581682795 |
11445 | 11445 | 2014-07-01 | ZAR | South Africa | 24.5 | 10.5145 | 2.33011555471016 |
11444 | 11444 | 2014-07-01 | VND | Vietnam | 60000.0 | 21230.0 | 2.82618935468676 |
11443 | 11443 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
11442 | 11442 | 2014-07-01 | UYU | Uruguay | 113.0 | 22.97 | 4.91946016543317 |
11441 | 11441 | 2014-07-01 | UAH | Ukraine | 19.0 | 11.685 | 1.6260162601626 |
11440 | 11440 | 2014-07-01 | TWD | Taiwan | 79.0 | 29.982 | 2.63491428190248 |
11439 | 11439 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
11438 | 11438 | 2014-07-01 | THB | Thailand | 99.0 | 31.78 | 3.11516677155444 |
11437 | 11437 | 2014-07-01 | SEK | Sweden | 40.7 | 6.836 | 5.95377413692218 |
11436 | 11436 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
11435 | 11435 | 2014-07-01 | SAR | Saudi Arabia | 11.0 | 3.75035 | 2.93305958110576 |
11434 | 11434 | 2014-07-01 | RUB | Russia | 89.0 | 34.83725 | 2.5547366683650403 |
11433 | 11433 | 2014-07-01 | PLN | Poland | 9.2 | 3.0714 | 2.99537670117862 |
11432 | 11432 | 2014-07-01 | PHP | Philippines | 160.0 | 43.205 | 3.7032750839023296 |
11431 | 11431 | 2014-07-01 | PEN | Peru | 10.0 | 2.7880000000000003 | 3.5868005738880897 |
11430 | 11430 | 2014-07-01 | PKR | Pakistan | 300.0 | 98.68 | 3.04012971220105 |
11429 | 11429 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
11428 | 11428 | 2014-07-01 | NOK | Norway | 48.0 | 6.1873 | 7.75782651560455 |
11427 | 11427 | 2014-07-01 | MYR | Malaysia | 7.63 | 3.1675 | 2.40883977900553 |
11426 | 11426 | 2014-07-01 | MXN | Mexico | 42.0 | 12.93255 | 3.24761937900878 |
11425 | 11425 | 2014-07-01 | LKR | Sri Lanka | 350.0 | 130.255 | 2.6870369659514 |
11424 | 11424 | 2014-07-01 | KRW | South Korea | 4100.0 | 1023.75 | 4.00488400488401 |
11423 | 11423 | 2014-07-01 | JPY | Japan | 370.0 | 101.53 | 3.6442430808628 |
11422 | 11422 | 2014-07-01 | ILS | Israel | 17.5 | 3.4138 | 5.12625227019743 |
11421 | 11421 | 2014-07-01 | INR | India | 105.0 | 60.08875 | 1.7474152815626898 |
11420 | 11420 | 2014-07-01 | IDR | Indonesia | 27939.0 | 11505.0 | 2.42842242503259 |
11419 | 11419 | 2014-07-01 | HUF | Hungary | 860.0 | 228.30615 | 3.76687180787727 |
11418 | 11418 | 2014-07-01 | HKD | Hong Kong | 18.8 | 7.75045 | 2.42566560651317 |
11417 | 11417 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
11416 | 11416 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
11415 | 11415 | 2014-07-01 | EGP | Egypt | 16.93 | 7.15005 | 2.36781560968105 |
11414 | 11414 | 2014-07-01 | DKK | Denmark | 28.5 | 5.5388 | 5.14551888495703 |
11413 | 11413 | 2014-07-01 | CZK | Czech Republic | 70.45 | 20.3877 | 3.4555148447348194 |
11412 | 11412 | 2014-07-01 | CRC | Costa Rica | 2150.0 | 537.3 | 4.0014889261120405 |
11411 | 11411 | 2014-07-01 | COP | Colombia | 8600.0 | 1847.65 | 4.654561199361349 |
11410 | 11410 | 2014-07-01 | CNY | China | 16.9 | 6.1983 | 2.72655405514415 |
11409 | 11409 | 2014-07-01 | CLP | Chile | 2100.0 | 564.14 | 3.72248023540256 |
11408 | 11408 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
11407 | 11407 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
11406 | 11406 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
11405 | 11405 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
11404 | 11404 | 2014-07-01 | ARS | Argentina | 21.0 | 8.16875 | 2.5707727620505 |
11403 | 11403 | 2014-07-01 | AED | UAE | 13.0 | 3.67305 | 3.5392929581682795 |
10115 | 10115 | 2014-07-01 | ZAR | South Africa | 24.5 | 10.5145 | 2.33011555471016 |
10114 | 10114 | 2014-07-01 | VND | Vietnam | 60000.0 | 21230.0 | 2.82618935468676 |
10113 | 10113 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
10112 | 10112 | 2014-07-01 | UYU | Uruguay | 113.0 | 22.97 | 4.91946016543317 |
10111 | 10111 | 2014-07-01 | UAH | Ukraine | 19.0 | 11.685 | 1.6260162601626 |
10110 | 10110 | 2014-07-01 | TWD | Taiwan | 79.0 | 29.982 | 2.63491428190248 |
10109 | 10109 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
10108 | 10108 | 2014-07-01 | THB | Thailand | 99.0 | 31.78 | 3.11516677155444 |
10107 | 10107 | 2014-07-01 | SEK | Sweden | 40.7 | 6.836 | 5.95377413692218 |
10106 | 10106 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
10105 | 10105 | 2014-07-01 | SAR | Saudi Arabia | 11.0 | 3.75035 | 2.93305958110576 |
10104 | 10104 | 2014-07-01 | RUB | Russia | 89.0 | 34.83725 | 2.5547366683650403 |
10103 | 10103 | 2014-07-01 | PLN | Poland | 9.2 | 3.0714 | 2.99537670117862 |
10102 | 10102 | 2014-07-01 | PHP | Philippines | 160.0 | 43.205 | 3.7032750839023296 |
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 );