bigmac
430 rows where "date" is on date 2016-01-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
892 | 892 | 2016-01-01 | AED | UAE | 13.0 | 3.6731 | 3.5392447796139503 |
893 | 893 | 2016-01-01 | ARS | Argentina | 33.0 | 13.80925 | 2.3897025544472004 |
894 | 894 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
895 | 895 | 2016-01-01 | BRL | Brazil | 13.5 | 4.0248 | 3.35420393559928 |
896 | 896 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
897 | 897 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
898 | 898 | 2016-01-01 | CLP | Chile | 2100.0 | 715.215 | 2.9361800297812497 |
899 | 899 | 2016-01-01 | CNY | China | 17.6 | 6.5582 | 2.68366320026837 |
900 | 900 | 2016-01-01 | COP | Colombia | 7900.0 | 3253.9 | 2.42785580380467 |
901 | 901 | 2016-01-01 | CRC | Costa Rica | 2150.0 | 535.25 | 4.01681457262961 |
902 | 902 | 2016-01-01 | CZK | Czech Republic | 75.0 | 25.1442 | 2.98279523707257 |
903 | 903 | 2016-01-01 | DKK | Denmark | 30.0 | 6.9405 | 4.32245515452777 |
904 | 904 | 2016-01-01 | EGP | Egypt | 16.93 | 7.83005 | 2.1621828723954497 |
905 | 905 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
906 | 906 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
907 | 907 | 2016-01-01 | HKD | Hong Kong | 19.2 | 7.75235 | 2.4766683650764 |
908 | 908 | 2016-01-01 | HUF | Hungary | 900.0 | 292.67905 | 3.07504073147702 |
909 | 909 | 2016-01-01 | IDR | Indonesia | 30500.0 | 13947.5 | 2.18677182290733 |
910 | 910 | 2016-01-01 | INR | India | 127.0 | 66.8025 | 1.9011264548482496 |
911 | 911 | 2016-01-01 | ILS | Israel | 16.9 | 3.94105 | 4.288197307824061 |
912 | 912 | 2016-01-01 | JPY | Japan | 370.0 | 118.645 | 3.11854692570273 |
913 | 913 | 2016-01-01 | KRW | South Korea | 4300.0 | 1197.75 | 3.59006470465456 |
914 | 914 | 2016-01-01 | LKR | Sri Lanka | 350.0 | 144.05 | 2.42971190558834 |
915 | 915 | 2016-01-01 | MXN | Mexico | 49.0 | 17.43675 | 2.81015670924914 |
916 | 916 | 2016-01-01 | MYR | Malaysia | 8.0 | 4.3925 | 1.82128628343768 |
917 | 917 | 2016-01-01 | NOK | Norway | 46.8 | 8.97465 | 5.21468803797363 |
918 | 918 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
919 | 919 | 2016-01-01 | PKR | Pakistan | 300.0 | 104.885 | 2.86027553987701 |
920 | 920 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
921 | 921 | 2016-01-01 | PHP | Philippines | 131.0 | 47.0225 | 2.7859003668456603 |
922 | 922 | 2016-01-01 | PLN | Poland | 9.6 | 4.0477 | 2.37171727153692 |
923 | 923 | 2016-01-01 | RUB | Russia | 114.0 | 74.655 | 1.52702431183444 |
924 | 924 | 2016-01-01 | SAR | Saudi Arabia | 12.0 | 3.7543 | 3.1963348693498097 |
925 | 925 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
926 | 926 | 2016-01-01 | SEK | Sweden | 45.0 | 8.60185 | 5.23143277318251 |
927 | 927 | 2016-01-01 | THB | Thailand | 112.0 | 36.22 | 3.09221424627278 |
928 | 928 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
929 | 929 | 2016-01-01 | TWD | Taiwan | 69.0 | 33.2315 | 2.07634322856326 |
930 | 930 | 2016-01-01 | UAH | Ukraine | 36.0 | 23.35 | 1.54175588865096 |
931 | 931 | 2016-01-01 | UYU | Uruguay | 113.0 | 30.185 | 3.74358124896472 |
932 | 932 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
933 | 933 | 2016-01-01 | VND | Vietnam | 60000.0 | 22467.5 | 2.6705240903527296 |
934 | 934 | 2016-01-01 | ZAR | South Africa | 28.0 | 15.81375 | 1.7706110188917898 |
2222 | 2222 | 2016-01-01 | AED | UAE | 13.0 | 3.6731 | 3.5392447796139503 |
2223 | 2223 | 2016-01-01 | ARS | Argentina | 33.0 | 13.80925 | 2.3897025544472004 |
2224 | 2224 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
2225 | 2225 | 2016-01-01 | BRL | Brazil | 13.5 | 4.0248 | 3.35420393559928 |
2226 | 2226 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
2227 | 2227 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
2228 | 2228 | 2016-01-01 | CLP | Chile | 2100.0 | 715.215 | 2.9361800297812497 |
2229 | 2229 | 2016-01-01 | CNY | China | 17.6 | 6.5582 | 2.68366320026837 |
2230 | 2230 | 2016-01-01 | COP | Colombia | 7900.0 | 3253.9 | 2.42785580380467 |
2231 | 2231 | 2016-01-01 | CRC | Costa Rica | 2150.0 | 535.25 | 4.01681457262961 |
2232 | 2232 | 2016-01-01 | CZK | Czech Republic | 75.0 | 25.1442 | 2.98279523707257 |
2233 | 2233 | 2016-01-01 | DKK | Denmark | 30.0 | 6.9405 | 4.32245515452777 |
2234 | 2234 | 2016-01-01 | EGP | Egypt | 16.93 | 7.83005 | 2.1621828723954497 |
2235 | 2235 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
2236 | 2236 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
2237 | 2237 | 2016-01-01 | HKD | Hong Kong | 19.2 | 7.75235 | 2.4766683650764 |
2238 | 2238 | 2016-01-01 | HUF | Hungary | 900.0 | 292.67905 | 3.07504073147702 |
2239 | 2239 | 2016-01-01 | IDR | Indonesia | 30500.0 | 13947.5 | 2.18677182290733 |
2240 | 2240 | 2016-01-01 | INR | India | 127.0 | 66.8025 | 1.9011264548482496 |
2241 | 2241 | 2016-01-01 | ILS | Israel | 16.9 | 3.94105 | 4.288197307824061 |
2242 | 2242 | 2016-01-01 | JPY | Japan | 370.0 | 118.645 | 3.11854692570273 |
2243 | 2243 | 2016-01-01 | KRW | South Korea | 4300.0 | 1197.75 | 3.59006470465456 |
2244 | 2244 | 2016-01-01 | LKR | Sri Lanka | 350.0 | 144.05 | 2.42971190558834 |
2245 | 2245 | 2016-01-01 | MXN | Mexico | 49.0 | 17.43675 | 2.81015670924914 |
2246 | 2246 | 2016-01-01 | MYR | Malaysia | 8.0 | 4.3925 | 1.82128628343768 |
2247 | 2247 | 2016-01-01 | NOK | Norway | 46.8 | 8.97465 | 5.21468803797363 |
2248 | 2248 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
2249 | 2249 | 2016-01-01 | PKR | Pakistan | 300.0 | 104.885 | 2.86027553987701 |
2250 | 2250 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
2251 | 2251 | 2016-01-01 | PHP | Philippines | 131.0 | 47.0225 | 2.7859003668456603 |
2252 | 2252 | 2016-01-01 | PLN | Poland | 9.6 | 4.0477 | 2.37171727153692 |
2253 | 2253 | 2016-01-01 | RUB | Russia | 114.0 | 74.655 | 1.52702431183444 |
2254 | 2254 | 2016-01-01 | SAR | Saudi Arabia | 12.0 | 3.7543 | 3.1963348693498097 |
2255 | 2255 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
2256 | 2256 | 2016-01-01 | SEK | Sweden | 45.0 | 8.60185 | 5.23143277318251 |
2257 | 2257 | 2016-01-01 | THB | Thailand | 112.0 | 36.22 | 3.09221424627278 |
2258 | 2258 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
2259 | 2259 | 2016-01-01 | TWD | Taiwan | 69.0 | 33.2315 | 2.07634322856326 |
2260 | 2260 | 2016-01-01 | UAH | Ukraine | 36.0 | 23.35 | 1.54175588865096 |
2261 | 2261 | 2016-01-01 | UYU | Uruguay | 113.0 | 30.185 | 3.74358124896472 |
2262 | 2262 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
2263 | 2263 | 2016-01-01 | VND | Vietnam | 60000.0 | 22467.5 | 2.6705240903527296 |
2264 | 2264 | 2016-01-01 | ZAR | South Africa | 28.0 | 15.81375 | 1.7706110188917898 |
3552 | 3552 | 2016-01-01 | AED | UAE | 13.0 | 3.6731 | 3.5392447796139503 |
3553 | 3553 | 2016-01-01 | ARS | Argentina | 33.0 | 13.80925 | 2.3897025544472004 |
3554 | 3554 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
3555 | 3555 | 2016-01-01 | BRL | Brazil | 13.5 | 4.0248 | 3.35420393559928 |
3556 | 3556 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
3557 | 3557 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
3558 | 3558 | 2016-01-01 | CLP | Chile | 2100.0 | 715.215 | 2.9361800297812497 |
3559 | 3559 | 2016-01-01 | CNY | China | 17.6 | 6.5582 | 2.68366320026837 |
3560 | 3560 | 2016-01-01 | COP | Colombia | 7900.0 | 3253.9 | 2.42785580380467 |
3561 | 3561 | 2016-01-01 | CRC | Costa Rica | 2150.0 | 535.25 | 4.01681457262961 |
3562 | 3562 | 2016-01-01 | CZK | Czech Republic | 75.0 | 25.1442 | 2.98279523707257 |
3563 | 3563 | 2016-01-01 | DKK | Denmark | 30.0 | 6.9405 | 4.32245515452777 |
3564 | 3564 | 2016-01-01 | EGP | Egypt | 16.93 | 7.83005 | 2.1621828723954497 |
3565 | 3565 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
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 );