bigmac
410 rows where "date" is on date 2010-01-01 sorted by date
This data as json, CSV (advanced)
Link | rowid | date ▼ | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
431 | 431 | 2010-01-01 | AED | UAE | 11.0 | 3.673 | 2.9948271167982594 |
432 | 432 | 2010-01-01 | ARS | Argentina | 7.0 | 3.7985 | 1.84283269711728 |
433 | 433 | 2010-01-01 | AUD | Australia | 4.35 | 1.09355 | 3.97787023912944 |
434 | 434 | 2010-01-01 | BRL | Brazil | 8.2 | 1.7233 | 4.75831253989439 |
435 | 435 | 2010-01-01 | CAD | Canada | 4.12 | 1.0368 | 3.9737654320987694 |
436 | 436 | 2010-01-01 | CHF | Switzerland | 6.5 | 1.03115 | 6.30364156524269 |
437 | 437 | 2010-01-01 | CLP | Chile | 1600.0 | 503.1 | 3.18028225004969 |
438 | 438 | 2010-01-01 | CNY | China | 12.5 | 6.8272 | 1.83091164752754 |
439 | 439 | 2010-01-01 | COP | Colombia | 8200.0 | 2095.6 | 3.91296048864287 |
440 | 440 | 2010-01-01 | CRC | Costa Rica | 2050.0 | 582.57 | 3.5188904337676203 |
441 | 441 | 2010-01-01 | CZK | Czech Republic | 67.64 | 18.21005 | 3.7144324150675 |
442 | 442 | 2010-01-01 | DKK | Denmark | 30.94 | 5.16195 | 5.99385890990808 |
443 | 443 | 2010-01-01 | EGP | Egypt | 13.0 | 5.465 | 2.37877401646844 |
444 | 444 | 2010-01-01 | EUR | Euro area | 3.36 | 0.693649638 | 4.84394399698368 |
445 | 445 | 2010-01-01 | GBP | Britain | 2.29 | 0.623752495 | 3.671328000058741 |
446 | 446 | 2010-01-01 | HKD | Hong Kong | 14.8 | 7.75655 | 1.9080647968491105 |
447 | 447 | 2010-01-01 | HUF | Hungary | 720.0 | 186.6508 | 3.85747074215594 |
448 | 448 | 2010-01-01 | IDR | Indonesia | 20900.0 | 9320.0 | 2.2424892703862698 |
449 | 449 | 2010-01-01 | ILS | Israel | 14.9 | 3.7325 | 3.9919624916276 |
450 | 450 | 2010-01-01 | JPY | Japan | 320.0 | 91.54 | 3.49573956740223 |
451 | 451 | 2010-01-01 | KRW | South Korea | 3400.0 | 1140.5 | 2.98114861902674 |
452 | 452 | 2010-01-01 | LKR | Sri Lanka | 210.0 | 114.86 | 1.82831272853909 |
453 | 453 | 2010-01-01 | MXN | Mexico | 32.0 | 12.81375 | 2.49731733489416 |
454 | 454 | 2010-01-01 | MYR | Malaysia | 7.05 | 3.3875 | 2.08118081180812 |
455 | 455 | 2010-01-01 | NOK | Norway | 40.0 | 5.69555 | 7.02302674895313 |
456 | 456 | 2010-01-01 | NZD | New Zealand | 4.9 | 1.35685 | 3.611305597523681 |
457 | 457 | 2010-01-01 | PKR | Pakistan | 200.0 | 82.6 | 2.42130750605327 |
458 | 458 | 2010-01-01 | PEN | Peru | 8.056000000000001 | 2.8705 | 2.8064797073680494 |
459 | 459 | 2010-01-01 | PHP | Philippines | 101.52 | 45.92 | 2.2108013937282203 |
460 | 460 | 2010-01-01 | PLN | Poland | 8.1 | 2.83565 | 2.85648793045686 |
461 | 461 | 2010-01-01 | RUB | Russia | 70.0 | 29.927 | 2.3390249607378 |
462 | 462 | 2010-01-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
463 | 463 | 2010-01-01 | SGD | Singapore | 4.45 | 1.39555 | 3.18870696141306 |
464 | 464 | 2010-01-01 | SEK | Sweden | 39.0 | 7.0821 | 5.50684119117211 |
465 | 465 | 2010-01-01 | THB | Thailand | 70.0 | 33.135 | 2.112569790252 |
466 | 466 | 2010-01-01 | TRY | Turkey | 5.65 | 1.47455 | 3.83167746092028 |
467 | 467 | 2010-01-01 | TWD | Taiwan | 75.0 | 31.8425 | 2.35534270236319 |
468 | 468 | 2010-01-01 | UAH | Ukraine | 14.0 | 7.66 | 1.82767624020888 |
469 | 469 | 2010-01-01 | UYU | Uruguay | 77.0 | 23.17 | 3.32326283987915 |
470 | 470 | 2010-01-01 | USD | United States | 3.58 | 1.0 | 3.58 |
471 | 471 | 2010-01-01 | ZAR | South Africa | 17.95 | 7.3045 | 2.45738928058046 |
1761 | 1761 | 2010-01-01 | AED | UAE | 11.0 | 3.673 | 2.9948271167982594 |
1762 | 1762 | 2010-01-01 | ARS | Argentina | 7.0 | 3.7985 | 1.84283269711728 |
1763 | 1763 | 2010-01-01 | AUD | Australia | 4.35 | 1.09355 | 3.97787023912944 |
1764 | 1764 | 2010-01-01 | BRL | Brazil | 8.2 | 1.7233 | 4.75831253989439 |
1765 | 1765 | 2010-01-01 | CAD | Canada | 4.12 | 1.0368 | 3.9737654320987694 |
1766 | 1766 | 2010-01-01 | CHF | Switzerland | 6.5 | 1.03115 | 6.30364156524269 |
1767 | 1767 | 2010-01-01 | CLP | Chile | 1600.0 | 503.1 | 3.18028225004969 |
1768 | 1768 | 2010-01-01 | CNY | China | 12.5 | 6.8272 | 1.83091164752754 |
1769 | 1769 | 2010-01-01 | COP | Colombia | 8200.0 | 2095.6 | 3.91296048864287 |
1770 | 1770 | 2010-01-01 | CRC | Costa Rica | 2050.0 | 582.57 | 3.5188904337676203 |
1771 | 1771 | 2010-01-01 | CZK | Czech Republic | 67.64 | 18.21005 | 3.7144324150675 |
1772 | 1772 | 2010-01-01 | DKK | Denmark | 30.94 | 5.16195 | 5.99385890990808 |
1773 | 1773 | 2010-01-01 | EGP | Egypt | 13.0 | 5.465 | 2.37877401646844 |
1774 | 1774 | 2010-01-01 | EUR | Euro area | 3.36 | 0.693649638 | 4.84394399698368 |
1775 | 1775 | 2010-01-01 | GBP | Britain | 2.29 | 0.623752495 | 3.671328000058741 |
1776 | 1776 | 2010-01-01 | HKD | Hong Kong | 14.8 | 7.75655 | 1.9080647968491105 |
1777 | 1777 | 2010-01-01 | HUF | Hungary | 720.0 | 186.6508 | 3.85747074215594 |
1778 | 1778 | 2010-01-01 | IDR | Indonesia | 20900.0 | 9320.0 | 2.2424892703862698 |
1779 | 1779 | 2010-01-01 | ILS | Israel | 14.9 | 3.7325 | 3.9919624916276 |
1780 | 1780 | 2010-01-01 | JPY | Japan | 320.0 | 91.54 | 3.49573956740223 |
1781 | 1781 | 2010-01-01 | KRW | South Korea | 3400.0 | 1140.5 | 2.98114861902674 |
1782 | 1782 | 2010-01-01 | LKR | Sri Lanka | 210.0 | 114.86 | 1.82831272853909 |
1783 | 1783 | 2010-01-01 | MXN | Mexico | 32.0 | 12.81375 | 2.49731733489416 |
1784 | 1784 | 2010-01-01 | MYR | Malaysia | 7.05 | 3.3875 | 2.08118081180812 |
1785 | 1785 | 2010-01-01 | NOK | Norway | 40.0 | 5.69555 | 7.02302674895313 |
1786 | 1786 | 2010-01-01 | NZD | New Zealand | 4.9 | 1.35685 | 3.611305597523681 |
1787 | 1787 | 2010-01-01 | PKR | Pakistan | 200.0 | 82.6 | 2.42130750605327 |
1788 | 1788 | 2010-01-01 | PEN | Peru | 8.056000000000001 | 2.8705 | 2.8064797073680494 |
1789 | 1789 | 2010-01-01 | PHP | Philippines | 101.52 | 45.92 | 2.2108013937282203 |
1790 | 1790 | 2010-01-01 | PLN | Poland | 8.1 | 2.83565 | 2.85648793045686 |
1791 | 1791 | 2010-01-01 | RUB | Russia | 70.0 | 29.927 | 2.3390249607378 |
1792 | 1792 | 2010-01-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
1793 | 1793 | 2010-01-01 | SGD | Singapore | 4.45 | 1.39555 | 3.18870696141306 |
1794 | 1794 | 2010-01-01 | SEK | Sweden | 39.0 | 7.0821 | 5.50684119117211 |
1795 | 1795 | 2010-01-01 | THB | Thailand | 70.0 | 33.135 | 2.112569790252 |
1796 | 1796 | 2010-01-01 | TRY | Turkey | 5.65 | 1.47455 | 3.83167746092028 |
1797 | 1797 | 2010-01-01 | TWD | Taiwan | 75.0 | 31.8425 | 2.35534270236319 |
1798 | 1798 | 2010-01-01 | UAH | Ukraine | 14.0 | 7.66 | 1.82767624020888 |
1799 | 1799 | 2010-01-01 | UYU | Uruguay | 77.0 | 23.17 | 3.32326283987915 |
1800 | 1800 | 2010-01-01 | USD | United States | 3.58 | 1.0 | 3.58 |
1801 | 1801 | 2010-01-01 | ZAR | South Africa | 17.95 | 7.3045 | 2.45738928058046 |
3091 | 3091 | 2010-01-01 | AED | UAE | 11.0 | 3.673 | 2.9948271167982594 |
3092 | 3092 | 2010-01-01 | ARS | Argentina | 7.0 | 3.7985 | 1.84283269711728 |
3093 | 3093 | 2010-01-01 | AUD | Australia | 4.35 | 1.09355 | 3.97787023912944 |
3094 | 3094 | 2010-01-01 | BRL | Brazil | 8.2 | 1.7233 | 4.75831253989439 |
3095 | 3095 | 2010-01-01 | CAD | Canada | 4.12 | 1.0368 | 3.9737654320987694 |
3096 | 3096 | 2010-01-01 | CHF | Switzerland | 6.5 | 1.03115 | 6.30364156524269 |
3097 | 3097 | 2010-01-01 | CLP | Chile | 1600.0 | 503.1 | 3.18028225004969 |
3098 | 3098 | 2010-01-01 | CNY | China | 12.5 | 6.8272 | 1.83091164752754 |
3099 | 3099 | 2010-01-01 | COP | Colombia | 8200.0 | 2095.6 | 3.91296048864287 |
3100 | 3100 | 2010-01-01 | CRC | Costa Rica | 2050.0 | 582.57 | 3.5188904337676203 |
3101 | 3101 | 2010-01-01 | CZK | Czech Republic | 67.64 | 18.21005 | 3.7144324150675 |
3102 | 3102 | 2010-01-01 | DKK | Denmark | 30.94 | 5.16195 | 5.99385890990808 |
3103 | 3103 | 2010-01-01 | EGP | Egypt | 13.0 | 5.465 | 2.37877401646844 |
3104 | 3104 | 2010-01-01 | EUR | Euro area | 3.36 | 0.693649638 | 4.84394399698368 |
3105 | 3105 | 2010-01-01 | GBP | Britain | 2.29 | 0.623752495 | 3.671328000058741 |
3106 | 3106 | 2010-01-01 | HKD | Hong Kong | 14.8 | 7.75655 | 1.9080647968491105 |
3107 | 3107 | 2010-01-01 | HUF | Hungary | 720.0 | 186.6508 | 3.85747074215594 |
3108 | 3108 | 2010-01-01 | IDR | Indonesia | 20900.0 | 9320.0 | 2.2424892703862698 |
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 );