bigmac
430 rows where "date" is on date 2014-07-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
763 | 763 | 2014-07-01 | AED | UAE | 13.0 | 3.67305 | 3.5392929581682795 |
764 | 764 | 2014-07-01 | ARS | Argentina | 21.0 | 8.16875 | 2.5707727620505 |
765 | 765 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
766 | 766 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
767 | 767 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
768 | 768 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
769 | 769 | 2014-07-01 | CLP | Chile | 2100.0 | 564.14 | 3.72248023540256 |
770 | 770 | 2014-07-01 | CNY | China | 16.9 | 6.1983 | 2.72655405514415 |
771 | 771 | 2014-07-01 | COP | Colombia | 8600.0 | 1847.65 | 4.654561199361349 |
772 | 772 | 2014-07-01 | CRC | Costa Rica | 2150.0 | 537.3 | 4.0014889261120405 |
773 | 773 | 2014-07-01 | CZK | Czech Republic | 70.45 | 20.3877 | 3.4555148447348194 |
774 | 774 | 2014-07-01 | DKK | Denmark | 28.5 | 5.5388 | 5.14551888495703 |
775 | 775 | 2014-07-01 | EGP | Egypt | 16.93 | 7.15005 | 2.36781560968105 |
776 | 776 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
777 | 777 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
778 | 778 | 2014-07-01 | HKD | Hong Kong | 18.8 | 7.75045 | 2.42566560651317 |
779 | 779 | 2014-07-01 | HUF | Hungary | 860.0 | 228.30615 | 3.76687180787727 |
780 | 780 | 2014-07-01 | IDR | Indonesia | 27939.0 | 11505.0 | 2.42842242503259 |
781 | 781 | 2014-07-01 | INR | India | 105.0 | 60.08875 | 1.7474152815626898 |
782 | 782 | 2014-07-01 | ILS | Israel | 17.5 | 3.4138 | 5.12625227019743 |
783 | 783 | 2014-07-01 | JPY | Japan | 370.0 | 101.53 | 3.6442430808628 |
784 | 784 | 2014-07-01 | KRW | South Korea | 4100.0 | 1023.75 | 4.00488400488401 |
785 | 785 | 2014-07-01 | LKR | Sri Lanka | 350.0 | 130.255 | 2.6870369659514 |
786 | 786 | 2014-07-01 | MXN | Mexico | 42.0 | 12.93255 | 3.24761937900878 |
787 | 787 | 2014-07-01 | MYR | Malaysia | 7.63 | 3.1675 | 2.40883977900553 |
788 | 788 | 2014-07-01 | NOK | Norway | 48.0 | 6.1873 | 7.75782651560455 |
789 | 789 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
790 | 790 | 2014-07-01 | PKR | Pakistan | 300.0 | 98.68 | 3.04012971220105 |
791 | 791 | 2014-07-01 | PEN | Peru | 10.0 | 2.7880000000000003 | 3.5868005738880897 |
792 | 792 | 2014-07-01 | PHP | Philippines | 160.0 | 43.205 | 3.7032750839023296 |
793 | 793 | 2014-07-01 | PLN | Poland | 9.2 | 3.0714 | 2.99537670117862 |
794 | 794 | 2014-07-01 | RUB | Russia | 89.0 | 34.83725 | 2.5547366683650403 |
795 | 795 | 2014-07-01 | SAR | Saudi Arabia | 11.0 | 3.75035 | 2.93305958110576 |
796 | 796 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
797 | 797 | 2014-07-01 | SEK | Sweden | 40.7 | 6.836 | 5.95377413692218 |
798 | 798 | 2014-07-01 | THB | Thailand | 99.0 | 31.78 | 3.11516677155444 |
799 | 799 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
800 | 800 | 2014-07-01 | TWD | Taiwan | 79.0 | 29.982 | 2.63491428190248 |
801 | 801 | 2014-07-01 | UAH | Ukraine | 19.0 | 11.685 | 1.6260162601626 |
802 | 802 | 2014-07-01 | UYU | Uruguay | 113.0 | 22.97 | 4.91946016543317 |
803 | 803 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
804 | 804 | 2014-07-01 | VND | Vietnam | 60000.0 | 21230.0 | 2.82618935468676 |
805 | 805 | 2014-07-01 | ZAR | South Africa | 24.5 | 10.5145 | 2.33011555471016 |
2093 | 2093 | 2014-07-01 | AED | UAE | 13.0 | 3.67305 | 3.5392929581682795 |
2094 | 2094 | 2014-07-01 | ARS | Argentina | 21.0 | 8.16875 | 2.5707727620505 |
2095 | 2095 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
2096 | 2096 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
2097 | 2097 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
2098 | 2098 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
2099 | 2099 | 2014-07-01 | CLP | Chile | 2100.0 | 564.14 | 3.72248023540256 |
2100 | 2100 | 2014-07-01 | CNY | China | 16.9 | 6.1983 | 2.72655405514415 |
2101 | 2101 | 2014-07-01 | COP | Colombia | 8600.0 | 1847.65 | 4.654561199361349 |
2102 | 2102 | 2014-07-01 | CRC | Costa Rica | 2150.0 | 537.3 | 4.0014889261120405 |
2103 | 2103 | 2014-07-01 | CZK | Czech Republic | 70.45 | 20.3877 | 3.4555148447348194 |
2104 | 2104 | 2014-07-01 | DKK | Denmark | 28.5 | 5.5388 | 5.14551888495703 |
2105 | 2105 | 2014-07-01 | EGP | Egypt | 16.93 | 7.15005 | 2.36781560968105 |
2106 | 2106 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
2107 | 2107 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
2108 | 2108 | 2014-07-01 | HKD | Hong Kong | 18.8 | 7.75045 | 2.42566560651317 |
2109 | 2109 | 2014-07-01 | HUF | Hungary | 860.0 | 228.30615 | 3.76687180787727 |
2110 | 2110 | 2014-07-01 | IDR | Indonesia | 27939.0 | 11505.0 | 2.42842242503259 |
2111 | 2111 | 2014-07-01 | INR | India | 105.0 | 60.08875 | 1.7474152815626898 |
2112 | 2112 | 2014-07-01 | ILS | Israel | 17.5 | 3.4138 | 5.12625227019743 |
2113 | 2113 | 2014-07-01 | JPY | Japan | 370.0 | 101.53 | 3.6442430808628 |
2114 | 2114 | 2014-07-01 | KRW | South Korea | 4100.0 | 1023.75 | 4.00488400488401 |
2115 | 2115 | 2014-07-01 | LKR | Sri Lanka | 350.0 | 130.255 | 2.6870369659514 |
2116 | 2116 | 2014-07-01 | MXN | Mexico | 42.0 | 12.93255 | 3.24761937900878 |
2117 | 2117 | 2014-07-01 | MYR | Malaysia | 7.63 | 3.1675 | 2.40883977900553 |
2118 | 2118 | 2014-07-01 | NOK | Norway | 48.0 | 6.1873 | 7.75782651560455 |
2119 | 2119 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
2120 | 2120 | 2014-07-01 | PKR | Pakistan | 300.0 | 98.68 | 3.04012971220105 |
2121 | 2121 | 2014-07-01 | PEN | Peru | 10.0 | 2.7880000000000003 | 3.5868005738880897 |
2122 | 2122 | 2014-07-01 | PHP | Philippines | 160.0 | 43.205 | 3.7032750839023296 |
2123 | 2123 | 2014-07-01 | PLN | Poland | 9.2 | 3.0714 | 2.99537670117862 |
2124 | 2124 | 2014-07-01 | RUB | Russia | 89.0 | 34.83725 | 2.5547366683650403 |
2125 | 2125 | 2014-07-01 | SAR | Saudi Arabia | 11.0 | 3.75035 | 2.93305958110576 |
2126 | 2126 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
2127 | 2127 | 2014-07-01 | SEK | Sweden | 40.7 | 6.836 | 5.95377413692218 |
2128 | 2128 | 2014-07-01 | THB | Thailand | 99.0 | 31.78 | 3.11516677155444 |
2129 | 2129 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
2130 | 2130 | 2014-07-01 | TWD | Taiwan | 79.0 | 29.982 | 2.63491428190248 |
2131 | 2131 | 2014-07-01 | UAH | Ukraine | 19.0 | 11.685 | 1.6260162601626 |
2132 | 2132 | 2014-07-01 | UYU | Uruguay | 113.0 | 22.97 | 4.91946016543317 |
2133 | 2133 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
2134 | 2134 | 2014-07-01 | VND | Vietnam | 60000.0 | 21230.0 | 2.82618935468676 |
2135 | 2135 | 2014-07-01 | ZAR | South Africa | 24.5 | 10.5145 | 2.33011555471016 |
3423 | 3423 | 2014-07-01 | AED | UAE | 13.0 | 3.67305 | 3.5392929581682795 |
3424 | 3424 | 2014-07-01 | ARS | Argentina | 21.0 | 8.16875 | 2.5707727620505 |
3425 | 3425 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
3426 | 3426 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
3427 | 3427 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
3428 | 3428 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
3429 | 3429 | 2014-07-01 | CLP | Chile | 2100.0 | 564.14 | 3.72248023540256 |
3430 | 3430 | 2014-07-01 | CNY | China | 16.9 | 6.1983 | 2.72655405514415 |
3431 | 3431 | 2014-07-01 | COP | Colombia | 8600.0 | 1847.65 | 4.654561199361349 |
3432 | 3432 | 2014-07-01 | CRC | Costa Rica | 2150.0 | 537.3 | 4.0014889261120405 |
3433 | 3433 | 2014-07-01 | CZK | Czech Republic | 70.45 | 20.3877 | 3.4555148447348194 |
3434 | 3434 | 2014-07-01 | DKK | Denmark | 28.5 | 5.5388 | 5.14551888495703 |
3435 | 3435 | 2014-07-01 | EGP | Egypt | 16.93 | 7.15005 | 2.36781560968105 |
3436 | 3436 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
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 );