bigmac
420 rows where "date" is on date 2014-01-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
721 | 721 | 2014-01-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
722 | 722 | 2014-01-01 | ARS | Argentina | 21.0 | 6.92125 | 3.03413400758534 |
723 | 723 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
724 | 724 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
725 | 725 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
726 | 726 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
727 | 727 | 2014-01-01 | CLP | Chile | 2000.0 | 541.95 | 3.6903773410831295 |
728 | 728 | 2014-01-01 | CNY | China | 16.6 | 6.0513 | 2.74321220233669 |
729 | 729 | 2014-01-01 | COP | Colombia | 8600.0 | 1982.795 | 4.33731172410663 |
730 | 730 | 2014-01-01 | CRC | Costa Rica | 2150.0 | 501.92 | 4.2835511635320405 |
731 | 731 | 2014-01-01 | CZK | Czech Republic | 70.45 | 20.2838 | 3.47321507804258 |
732 | 732 | 2014-01-01 | DKK | Denmark | 28.5 | 5.5014 | 5.18049950921584 |
733 | 733 | 2014-01-01 | EGP | Egypt | 16.93 | 6.961 | 2.43212182157736 |
734 | 734 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
735 | 735 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
736 | 736 | 2014-01-01 | HKD | Hong Kong | 18.0 | 7.75785 | 2.32023047622731 |
737 | 737 | 2014-01-01 | HUF | Hungary | 860.0 | 223.09705 | 3.8548246155652897 |
738 | 738 | 2014-01-01 | IDR | Indonesia | 27939.0 | 12140.0 | 2.30140032948929 |
739 | 739 | 2014-01-01 | INR | India | 95.0 | 61.845 | 1.5360983102918602 |
740 | 740 | 2014-01-01 | ILS | Israel | 17.5 | 3.4882 | 5.01691416776561 |
741 | 741 | 2014-01-01 | JPY | Japan | 310.0 | 104.245 | 2.97376372967528 |
742 | 742 | 2014-01-01 | KRW | South Korea | 3700.0 | 1067.3 | 3.46669165183173 |
743 | 743 | 2014-01-01 | LKR | Sri Lanka | 350.0 | 130.8 | 2.67584097859327 |
744 | 744 | 2014-01-01 | MXN | Mexico | 37.0 | 13.33275 | 2.77512141156176 |
745 | 745 | 2014-01-01 | MYR | Malaysia | 7.4 | 3.3235 | 2.2265683767113 |
746 | 746 | 2014-01-01 | NOK | Norway | 48.0 | 6.15745 | 7.79543479849613 |
747 | 747 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
748 | 748 | 2014-01-01 | PKR | Pakistan | 320.0 | 105.415 | 3.03562111653939 |
749 | 749 | 2014-01-01 | PEN | Peru | 10.0 | 2.8065 | 3.56315695706396 |
750 | 750 | 2014-01-01 | PHP | Philippines | 135.0 | 45.23 | 2.98474463851426 |
751 | 751 | 2014-01-01 | PLN | Poland | 9.2 | 3.0684 | 2.99830530569678 |
752 | 752 | 2014-01-01 | RUB | Russia | 89.0 | 33.93925 | 2.62233255007108 |
753 | 753 | 2014-01-01 | SAR | Saudi Arabia | 11.0 | 3.7504 | 2.9330204778157003 |
754 | 754 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
755 | 755 | 2014-01-01 | SEK | Sweden | 40.7 | 6.47315 | 6.287510717347809 |
756 | 756 | 2014-01-01 | THB | Thailand | 96.0 | 32.875 | 2.92015209125475 |
757 | 757 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
758 | 758 | 2014-01-01 | TWD | Taiwan | 79.0 | 30.161 | 2.6192765491860404 |
759 | 759 | 2014-01-01 | UAH | Ukraine | 19.0 | 8.379 | 2.2675736961451203 |
760 | 760 | 2014-01-01 | UYU | Uruguay | 105.0 | 21.38 | 4.911131898971 |
761 | 761 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
762 | 762 | 2014-01-01 | ZAR | South Africa | 23.5 | 10.87765 | 2.16039309961251 |
2051 | 2051 | 2014-01-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
2052 | 2052 | 2014-01-01 | ARS | Argentina | 21.0 | 6.92125 | 3.03413400758534 |
2053 | 2053 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
2054 | 2054 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
2055 | 2055 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
2056 | 2056 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
2057 | 2057 | 2014-01-01 | CLP | Chile | 2000.0 | 541.95 | 3.6903773410831295 |
2058 | 2058 | 2014-01-01 | CNY | China | 16.6 | 6.0513 | 2.74321220233669 |
2059 | 2059 | 2014-01-01 | COP | Colombia | 8600.0 | 1982.795 | 4.33731172410663 |
2060 | 2060 | 2014-01-01 | CRC | Costa Rica | 2150.0 | 501.92 | 4.2835511635320405 |
2061 | 2061 | 2014-01-01 | CZK | Czech Republic | 70.45 | 20.2838 | 3.47321507804258 |
2062 | 2062 | 2014-01-01 | DKK | Denmark | 28.5 | 5.5014 | 5.18049950921584 |
2063 | 2063 | 2014-01-01 | EGP | Egypt | 16.93 | 6.961 | 2.43212182157736 |
2064 | 2064 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
2065 | 2065 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
2066 | 2066 | 2014-01-01 | HKD | Hong Kong | 18.0 | 7.75785 | 2.32023047622731 |
2067 | 2067 | 2014-01-01 | HUF | Hungary | 860.0 | 223.09705 | 3.8548246155652897 |
2068 | 2068 | 2014-01-01 | IDR | Indonesia | 27939.0 | 12140.0 | 2.30140032948929 |
2069 | 2069 | 2014-01-01 | INR | India | 95.0 | 61.845 | 1.5360983102918602 |
2070 | 2070 | 2014-01-01 | ILS | Israel | 17.5 | 3.4882 | 5.01691416776561 |
2071 | 2071 | 2014-01-01 | JPY | Japan | 310.0 | 104.245 | 2.97376372967528 |
2072 | 2072 | 2014-01-01 | KRW | South Korea | 3700.0 | 1067.3 | 3.46669165183173 |
2073 | 2073 | 2014-01-01 | LKR | Sri Lanka | 350.0 | 130.8 | 2.67584097859327 |
2074 | 2074 | 2014-01-01 | MXN | Mexico | 37.0 | 13.33275 | 2.77512141156176 |
2075 | 2075 | 2014-01-01 | MYR | Malaysia | 7.4 | 3.3235 | 2.2265683767113 |
2076 | 2076 | 2014-01-01 | NOK | Norway | 48.0 | 6.15745 | 7.79543479849613 |
2077 | 2077 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
2078 | 2078 | 2014-01-01 | PKR | Pakistan | 320.0 | 105.415 | 3.03562111653939 |
2079 | 2079 | 2014-01-01 | PEN | Peru | 10.0 | 2.8065 | 3.56315695706396 |
2080 | 2080 | 2014-01-01 | PHP | Philippines | 135.0 | 45.23 | 2.98474463851426 |
2081 | 2081 | 2014-01-01 | PLN | Poland | 9.2 | 3.0684 | 2.99830530569678 |
2082 | 2082 | 2014-01-01 | RUB | Russia | 89.0 | 33.93925 | 2.62233255007108 |
2083 | 2083 | 2014-01-01 | SAR | Saudi Arabia | 11.0 | 3.7504 | 2.9330204778157003 |
2084 | 2084 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
2085 | 2085 | 2014-01-01 | SEK | Sweden | 40.7 | 6.47315 | 6.287510717347809 |
2086 | 2086 | 2014-01-01 | THB | Thailand | 96.0 | 32.875 | 2.92015209125475 |
2087 | 2087 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
2088 | 2088 | 2014-01-01 | TWD | Taiwan | 79.0 | 30.161 | 2.6192765491860404 |
2089 | 2089 | 2014-01-01 | UAH | Ukraine | 19.0 | 8.379 | 2.2675736961451203 |
2090 | 2090 | 2014-01-01 | UYU | Uruguay | 105.0 | 21.38 | 4.911131898971 |
2091 | 2091 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
2092 | 2092 | 2014-01-01 | ZAR | South Africa | 23.5 | 10.87765 | 2.16039309961251 |
3381 | 3381 | 2014-01-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
3382 | 3382 | 2014-01-01 | ARS | Argentina | 21.0 | 6.92125 | 3.03413400758534 |
3383 | 3383 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
3384 | 3384 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
3385 | 3385 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
3386 | 3386 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
3387 | 3387 | 2014-01-01 | CLP | Chile | 2000.0 | 541.95 | 3.6903773410831295 |
3388 | 3388 | 2014-01-01 | CNY | China | 16.6 | 6.0513 | 2.74321220233669 |
3389 | 3389 | 2014-01-01 | COP | Colombia | 8600.0 | 1982.795 | 4.33731172410663 |
3390 | 3390 | 2014-01-01 | CRC | Costa Rica | 2150.0 | 501.92 | 4.2835511635320405 |
3391 | 3391 | 2014-01-01 | CZK | Czech Republic | 70.45 | 20.2838 | 3.47321507804258 |
3392 | 3392 | 2014-01-01 | DKK | Denmark | 28.5 | 5.5014 | 5.18049950921584 |
3393 | 3393 | 2014-01-01 | EGP | Egypt | 16.93 | 6.961 | 2.43212182157736 |
3394 | 3394 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
3395 | 3395 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
3396 | 3396 | 2014-01-01 | HKD | Hong Kong | 18.0 | 7.75785 | 2.32023047622731 |
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 );