bigmac
420 rows where "date" is on date 2013-07-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
679 | 679 | 2013-07-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
680 | 680 | 2013-07-01 | ARS | Argentina | 21.0 | 5.4125 | 3.87990762124711 |
681 | 681 | 2013-07-01 | AUD | Australia | 5.035 | 1.089858863 | 4.61986425117506 |
682 | 682 | 2013-07-01 | BRL | Brazil | 12.0 | 2.27065 | 5.28483033492612 |
683 | 683 | 2013-07-01 | CAD | Canada | 5.53 | 1.05125 | 5.260404280618309 |
684 | 684 | 2013-07-01 | CHF | Switzerland | 6.5 | 0.9674 | 6.7190407277238 |
685 | 685 | 2013-07-01 | CLP | Chile | 2000.0 | 508.155 | 3.93580698802531 |
686 | 686 | 2013-07-01 | CNY | China | 16.0 | 6.1341 | 2.60836960597317 |
687 | 687 | 2013-07-01 | COP | Colombia | 8600.0 | 1921.0 | 4.47683498178032 |
688 | 688 | 2013-07-01 | CRC | Costa Rica | 2150.0 | 498.675 | 4.31142527698401 |
689 | 689 | 2013-07-01 | CZK | Czech Republic | 70.45 | 20.1828 | 3.49059595298967 |
690 | 690 | 2013-07-01 | DKK | Denmark | 28.5 | 5.8006 | 4.91328483260352 |
691 | 691 | 2013-07-01 | EGP | Egypt | 16.75 | 7.00915 | 2.38973341988686 |
692 | 692 | 2013-07-01 | EUR | Euro area | 3.623870489 | 0.777756173 | 4.65939148386547 |
693 | 693 | 2013-07-01 | GBP | Britain | 2.69 | 0.669142494 | 4.02007049936362 |
694 | 694 | 2013-07-01 | HKD | Hong Kong | 17.0 | 7.75665 | 2.19166779473097 |
695 | 695 | 2013-07-01 | HUF | Hungary | 860.0 | 228.462 | 3.76430215965894 |
696 | 696 | 2013-07-01 | IDR | Indonesia | 27939.0 | 9965.0 | 2.80371299548419 |
697 | 697 | 2013-07-01 | INR | India | 90.0 | 59.98 | 1.50050016672224 |
698 | 698 | 2013-07-01 | ILS | Israel | 17.5 | 3.64595 | 4.79984640491504 |
699 | 699 | 2013-07-01 | JPY | Japan | 320.0 | 100.105 | 3.1966435242994904 |
700 | 700 | 2013-07-01 | KRW | South Korea | 3900.0 | 1135.7 | 3.4340054591881697 |
701 | 701 | 2013-07-01 | LKR | Sri Lanka | 370.0 | 130.8 | 2.828746177370029 |
702 | 702 | 2013-07-01 | MXN | Mexico | 37.0 | 12.94115 | 2.8590967572433703 |
703 | 703 | 2013-07-01 | MYR | Malaysia | 7.3 | 3.1805 | 2.2952365980191805 |
704 | 704 | 2013-07-01 | NOK | Norway | 46.0 | 6.1281 | 7.506404921590709 |
705 | 705 | 2013-07-01 | NZD | New Zealand | 5.5 | 1.279344975 | 4.29907500125211 |
706 | 706 | 2013-07-01 | PKR | Pakistan | 300.0 | 100.035 | 2.99895036737142 |
707 | 707 | 2013-07-01 | PEN | Peru | 10.0 | 2.783 | 3.5932446999640697 |
708 | 708 | 2013-07-01 | PHP | Philippines | 115.21 | 43.44 | 2.6521639042357297 |
709 | 709 | 2013-07-01 | PLN | Poland | 9.2 | 3.3655 | 2.7336205615807496 |
710 | 710 | 2013-07-01 | RUB | Russia | 87.0 | 32.9389 | 2.64125395808603 |
711 | 711 | 2013-07-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
712 | 712 | 2013-07-01 | SGD | Singapore | 4.7 | 1.2747 | 3.68714207264454 |
713 | 713 | 2013-07-01 | SEK | Sweden | 41.61 | 6.7583 | 6.156873770030921 |
714 | 714 | 2013-07-01 | THB | Thailand | 89.0 | 31.275 | 2.8457234212629903 |
715 | 715 | 2013-07-01 | TRY | Turkey | 8.5 | 1.95745 | 4.34238422437355 |
716 | 716 | 2013-07-01 | TWD | Taiwan | 79.0 | 30.0285 | 2.63083404099439 |
717 | 717 | 2013-07-01 | UAH | Ukraine | 19.0 | 8.155 | 2.3298589822195 |
718 | 718 | 2013-07-01 | UYU | Uruguay | 105.0 | 21.085 | 4.97984349063315 |
719 | 719 | 2013-07-01 | USD | United States | 4.556666667 | 1.0 | 4.556666667 |
720 | 720 | 2013-07-01 | ZAR | South Africa | 22.5 | 10.04725 | 2.23941874642315 |
2009 | 2009 | 2013-07-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
2010 | 2010 | 2013-07-01 | ARS | Argentina | 21.0 | 5.4125 | 3.87990762124711 |
2011 | 2011 | 2013-07-01 | AUD | Australia | 5.035 | 1.089858863 | 4.61986425117506 |
2012 | 2012 | 2013-07-01 | BRL | Brazil | 12.0 | 2.27065 | 5.28483033492612 |
2013 | 2013 | 2013-07-01 | CAD | Canada | 5.53 | 1.05125 | 5.260404280618309 |
2014 | 2014 | 2013-07-01 | CHF | Switzerland | 6.5 | 0.9674 | 6.7190407277238 |
2015 | 2015 | 2013-07-01 | CLP | Chile | 2000.0 | 508.155 | 3.93580698802531 |
2016 | 2016 | 2013-07-01 | CNY | China | 16.0 | 6.1341 | 2.60836960597317 |
2017 | 2017 | 2013-07-01 | COP | Colombia | 8600.0 | 1921.0 | 4.47683498178032 |
2018 | 2018 | 2013-07-01 | CRC | Costa Rica | 2150.0 | 498.675 | 4.31142527698401 |
2019 | 2019 | 2013-07-01 | CZK | Czech Republic | 70.45 | 20.1828 | 3.49059595298967 |
2020 | 2020 | 2013-07-01 | DKK | Denmark | 28.5 | 5.8006 | 4.91328483260352 |
2021 | 2021 | 2013-07-01 | EGP | Egypt | 16.75 | 7.00915 | 2.38973341988686 |
2022 | 2022 | 2013-07-01 | EUR | Euro area | 3.623870489 | 0.777756173 | 4.65939148386547 |
2023 | 2023 | 2013-07-01 | GBP | Britain | 2.69 | 0.669142494 | 4.02007049936362 |
2024 | 2024 | 2013-07-01 | HKD | Hong Kong | 17.0 | 7.75665 | 2.19166779473097 |
2025 | 2025 | 2013-07-01 | HUF | Hungary | 860.0 | 228.462 | 3.76430215965894 |
2026 | 2026 | 2013-07-01 | IDR | Indonesia | 27939.0 | 9965.0 | 2.80371299548419 |
2027 | 2027 | 2013-07-01 | INR | India | 90.0 | 59.98 | 1.50050016672224 |
2028 | 2028 | 2013-07-01 | ILS | Israel | 17.5 | 3.64595 | 4.79984640491504 |
2029 | 2029 | 2013-07-01 | JPY | Japan | 320.0 | 100.105 | 3.1966435242994904 |
2030 | 2030 | 2013-07-01 | KRW | South Korea | 3900.0 | 1135.7 | 3.4340054591881697 |
2031 | 2031 | 2013-07-01 | LKR | Sri Lanka | 370.0 | 130.8 | 2.828746177370029 |
2032 | 2032 | 2013-07-01 | MXN | Mexico | 37.0 | 12.94115 | 2.8590967572433703 |
2033 | 2033 | 2013-07-01 | MYR | Malaysia | 7.3 | 3.1805 | 2.2952365980191805 |
2034 | 2034 | 2013-07-01 | NOK | Norway | 46.0 | 6.1281 | 7.506404921590709 |
2035 | 2035 | 2013-07-01 | NZD | New Zealand | 5.5 | 1.279344975 | 4.29907500125211 |
2036 | 2036 | 2013-07-01 | PKR | Pakistan | 300.0 | 100.035 | 2.99895036737142 |
2037 | 2037 | 2013-07-01 | PEN | Peru | 10.0 | 2.783 | 3.5932446999640697 |
2038 | 2038 | 2013-07-01 | PHP | Philippines | 115.21 | 43.44 | 2.6521639042357297 |
2039 | 2039 | 2013-07-01 | PLN | Poland | 9.2 | 3.3655 | 2.7336205615807496 |
2040 | 2040 | 2013-07-01 | RUB | Russia | 87.0 | 32.9389 | 2.64125395808603 |
2041 | 2041 | 2013-07-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
2042 | 2042 | 2013-07-01 | SGD | Singapore | 4.7 | 1.2747 | 3.68714207264454 |
2043 | 2043 | 2013-07-01 | SEK | Sweden | 41.61 | 6.7583 | 6.156873770030921 |
2044 | 2044 | 2013-07-01 | THB | Thailand | 89.0 | 31.275 | 2.8457234212629903 |
2045 | 2045 | 2013-07-01 | TRY | Turkey | 8.5 | 1.95745 | 4.34238422437355 |
2046 | 2046 | 2013-07-01 | TWD | Taiwan | 79.0 | 30.0285 | 2.63083404099439 |
2047 | 2047 | 2013-07-01 | UAH | Ukraine | 19.0 | 8.155 | 2.3298589822195 |
2048 | 2048 | 2013-07-01 | UYU | Uruguay | 105.0 | 21.085 | 4.97984349063315 |
2049 | 2049 | 2013-07-01 | USD | United States | 4.556666667 | 1.0 | 4.556666667 |
2050 | 2050 | 2013-07-01 | ZAR | South Africa | 22.5 | 10.04725 | 2.23941874642315 |
3339 | 3339 | 2013-07-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
3340 | 3340 | 2013-07-01 | ARS | Argentina | 21.0 | 5.4125 | 3.87990762124711 |
3341 | 3341 | 2013-07-01 | AUD | Australia | 5.035 | 1.089858863 | 4.61986425117506 |
3342 | 3342 | 2013-07-01 | BRL | Brazil | 12.0 | 2.27065 | 5.28483033492612 |
3343 | 3343 | 2013-07-01 | CAD | Canada | 5.53 | 1.05125 | 5.260404280618309 |
3344 | 3344 | 2013-07-01 | CHF | Switzerland | 6.5 | 0.9674 | 6.7190407277238 |
3345 | 3345 | 2013-07-01 | CLP | Chile | 2000.0 | 508.155 | 3.93580698802531 |
3346 | 3346 | 2013-07-01 | CNY | China | 16.0 | 6.1341 | 2.60836960597317 |
3347 | 3347 | 2013-07-01 | COP | Colombia | 8600.0 | 1921.0 | 4.47683498178032 |
3348 | 3348 | 2013-07-01 | CRC | Costa Rica | 2150.0 | 498.675 | 4.31142527698401 |
3349 | 3349 | 2013-07-01 | CZK | Czech Republic | 70.45 | 20.1828 | 3.49059595298967 |
3350 | 3350 | 2013-07-01 | DKK | Denmark | 28.5 | 5.8006 | 4.91328483260352 |
3351 | 3351 | 2013-07-01 | EGP | Egypt | 16.75 | 7.00915 | 2.38973341988686 |
3352 | 3352 | 2013-07-01 | EUR | Euro area | 3.623870489 | 0.777756173 | 4.65939148386547 |
3353 | 3353 | 2013-07-01 | GBP | Britain | 2.69 | 0.669142494 | 4.02007049936362 |
3354 | 3354 | 2013-07-01 | HKD | Hong Kong | 17.0 | 7.75665 | 2.19166779473097 |
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 );