bigmac
430 rows where "date" is on date 2015-01-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
3480 | 3480 | 2015-01-01 | GBP | Britain | 2.89 | 0.6615944429999999 | 4.36823499740308 |
3481 | 3481 | 2015-01-01 | HKD | Hong Kong | 18.8 | 7.75135 | 2.42538396537377 |
3482 | 3482 | 2015-01-01 | HUF | Hungary | 860.0 | 271.39345 | 3.16883108269562 |
3483 | 3483 | 2015-01-01 | IDR | Indonesia | 27939.0 | 12480.0 | 2.23870192307692 |
3484 | 3484 | 2015-01-01 | INR | India | 116.25 | 61.615 | 1.88671589710298 |
3485 | 3485 | 2015-01-01 | ILS | Israel | 17.5 | 3.93415 | 4.4482289694088895 |
3486 | 3486 | 2015-01-01 | JPY | Japan | 370.0 | 117.765 | 3.14185029507918 |
3487 | 3487 | 2015-01-01 | KRW | South Korea | 4100.0 | 1083.3 | 3.7847318379027097 |
3488 | 3488 | 2015-01-01 | LKR | Sri Lanka | 350.0 | 131.875 | 2.65402843601896 |
3489 | 3489 | 2015-01-01 | MXN | Mexico | 49.0 | 14.6275 | 3.34985472568792 |
3490 | 3490 | 2015-01-01 | MYR | Malaysia | 7.63 | 3.6155 | 2.11035818005808 |
3491 | 3491 | 2015-01-01 | NOK | Norway | 48.0 | 7.6225 | 6.29714660544441 |
3492 | 3492 | 2015-01-01 | NZD | New Zealand | 5.9 | 1.313283866 | 4.49255500105261 |
3493 | 3493 | 2015-01-01 | PKR | Pakistan | 300.0 | 100.735 | 2.97811088499528 |
3494 | 3494 | 2015-01-01 | PEN | Peru | 10.0 | 3.008 | 3.32446808510638 |
3495 | 3495 | 2015-01-01 | PHP | Philippines | 163.0 | 44.41 | 3.67034451700068 |
3496 | 3496 | 2015-01-01 | PLN | Poland | 9.2 | 3.7066 | 2.4820590298386698 |
3497 | 3497 | 2015-01-01 | RUB | Russia | 89.0 | 65.227 | 1.36446563539639 |
3498 | 3498 | 2015-01-01 | SAR | Saudi Arabia | 11.0 | 3.7569 | 2.9279459128536804 |
3499 | 3499 | 2015-01-01 | SGD | Singapore | 4.7 | 1.33315 | 3.5254847541537004 |
3500 | 3500 | 2015-01-01 | SEK | Sweden | 40.7 | 8.19145 | 4.96859530363977 |
3501 | 3501 | 2015-01-01 | THB | Thailand | 99.0 | 32.605 | 3.03634411900015 |
3502 | 3502 | 2015-01-01 | TRY | Turkey | 9.25 | 2.33345 | 3.964087509910221 |
3503 | 3503 | 2015-01-01 | TWD | Taiwan | 79.0 | 31.493 | 2.50849395103674 |
3504 | 3504 | 2015-01-01 | UAH | Ukraine | 19.0 | 15.822 | 1.2008595626343102 |
3505 | 3505 | 2015-01-01 | UYU | Uruguay | 113.0 | 24.425 | 4.62640736949846 |
3506 | 3506 | 2015-01-01 | USD | United States | 4.79 | 1.0 | 4.79 |
3507 | 3507 | 2015-01-01 | VND | Vietnam | 60000.0 | 21380.0 | 2.8063610851262903 |
3508 | 3508 | 2015-01-01 | ZAR | South Africa | 25.5 | 11.47875 | 2.22149624305782 |
4796 | 4796 | 2015-01-01 | AED | UAE | 13.0 | 3.67305 | 3.5392929581682795 |
4797 | 4797 | 2015-01-01 | ARS | Argentina | 28.0 | 8.61 | 3.2520325203252 |
4798 | 4798 | 2015-01-01 | AUD | Australia | 5.3 | 1.227219734 | 4.31870499892076 |
4799 | 4799 | 2015-01-01 | BRL | Brazil | 13.5 | 2.59275 | 5.20682672837721 |
4800 | 4800 | 2015-01-01 | CAD | Canada | 5.7 | 1.22855 | 4.63961580725245 |
4801 | 4801 | 2015-01-01 | CHF | Switzerland | 6.5 | 0.86165 | 7.54366622178379 |
4802 | 4802 | 2015-01-01 | CLP | Chile | 2100.0 | 627.485 | 3.34669354645928 |
4803 | 4803 | 2015-01-01 | CNY | China | 17.2 | 6.2115 | 2.7690573935442298 |
4804 | 4804 | 2015-01-01 | COP | Colombia | 7900.0 | 2364.98 | 3.340408798383069 |
4805 | 4805 | 2015-01-01 | CRC | Costa Rica | 2150.0 | 536.09 | 4.01052062153743 |
4806 | 4806 | 2015-01-01 | CZK | Czech Republic | 70.45 | 24.13325 | 2.9192089751691097 |
4807 | 4807 | 2015-01-01 | DKK | Denmark | 34.5 | 6.4174 | 5.37600897559759 |
4808 | 4808 | 2015-01-01 | EGP | Egypt | 16.93 | 7.35005 | 2.3033856912538 |
4809 | 4809 | 2015-01-01 | EUR | Euro area | 3.68 | 0.8630734040000001 | 4.26383200194175 |
4810 | 4810 | 2015-01-01 | GBP | Britain | 2.89 | 0.6615944429999999 | 4.36823499740308 |
4811 | 4811 | 2015-01-01 | HKD | Hong Kong | 18.8 | 7.75135 | 2.42538396537377 |
4812 | 4812 | 2015-01-01 | HUF | Hungary | 860.0 | 271.39345 | 3.16883108269562 |
4813 | 4813 | 2015-01-01 | IDR | Indonesia | 27939.0 | 12480.0 | 2.23870192307692 |
4814 | 4814 | 2015-01-01 | INR | India | 116.25 | 61.615 | 1.88671589710298 |
4815 | 4815 | 2015-01-01 | ILS | Israel | 17.5 | 3.93415 | 4.4482289694088895 |
4816 | 4816 | 2015-01-01 | JPY | Japan | 370.0 | 117.765 | 3.14185029507918 |
4817 | 4817 | 2015-01-01 | KRW | South Korea | 4100.0 | 1083.3 | 3.7847318379027097 |
4818 | 4818 | 2015-01-01 | LKR | Sri Lanka | 350.0 | 131.875 | 2.65402843601896 |
4819 | 4819 | 2015-01-01 | MXN | Mexico | 49.0 | 14.6275 | 3.34985472568792 |
4820 | 4820 | 2015-01-01 | MYR | Malaysia | 7.63 | 3.6155 | 2.11035818005808 |
4821 | 4821 | 2015-01-01 | NOK | Norway | 48.0 | 7.6225 | 6.29714660544441 |
4822 | 4822 | 2015-01-01 | NZD | New Zealand | 5.9 | 1.313283866 | 4.49255500105261 |
4823 | 4823 | 2015-01-01 | PKR | Pakistan | 300.0 | 100.735 | 2.97811088499528 |
4824 | 4824 | 2015-01-01 | PEN | Peru | 10.0 | 3.008 | 3.32446808510638 |
4825 | 4825 | 2015-01-01 | PHP | Philippines | 163.0 | 44.41 | 3.67034451700068 |
4826 | 4826 | 2015-01-01 | PLN | Poland | 9.2 | 3.7066 | 2.4820590298386698 |
4827 | 4827 | 2015-01-01 | RUB | Russia | 89.0 | 65.227 | 1.36446563539639 |
4828 | 4828 | 2015-01-01 | SAR | Saudi Arabia | 11.0 | 3.7569 | 2.9279459128536804 |
4829 | 4829 | 2015-01-01 | SGD | Singapore | 4.7 | 1.33315 | 3.5254847541537004 |
4830 | 4830 | 2015-01-01 | SEK | Sweden | 40.7 | 8.19145 | 4.96859530363977 |
4831 | 4831 | 2015-01-01 | THB | Thailand | 99.0 | 32.605 | 3.03634411900015 |
4832 | 4832 | 2015-01-01 | TRY | Turkey | 9.25 | 2.33345 | 3.964087509910221 |
4833 | 4833 | 2015-01-01 | TWD | Taiwan | 79.0 | 31.493 | 2.50849395103674 |
4834 | 4834 | 2015-01-01 | UAH | Ukraine | 19.0 | 15.822 | 1.2008595626343102 |
4835 | 4835 | 2015-01-01 | UYU | Uruguay | 113.0 | 24.425 | 4.62640736949846 |
4836 | 4836 | 2015-01-01 | USD | United States | 4.79 | 1.0 | 4.79 |
4837 | 4837 | 2015-01-01 | VND | Vietnam | 60000.0 | 21380.0 | 2.8063610851262903 |
4838 | 4838 | 2015-01-01 | ZAR | South Africa | 25.5 | 11.47875 | 2.22149624305782 |
6126 | 6126 | 2015-01-01 | AED | UAE | 13.0 | 3.67305 | 3.5392929581682795 |
6127 | 6127 | 2015-01-01 | ARS | Argentina | 28.0 | 8.61 | 3.2520325203252 |
6128 | 6128 | 2015-01-01 | AUD | Australia | 5.3 | 1.227219734 | 4.31870499892076 |
6129 | 6129 | 2015-01-01 | BRL | Brazil | 13.5 | 2.59275 | 5.20682672837721 |
6130 | 6130 | 2015-01-01 | CAD | Canada | 5.7 | 1.22855 | 4.63961580725245 |
6131 | 6131 | 2015-01-01 | CHF | Switzerland | 6.5 | 0.86165 | 7.54366622178379 |
6132 | 6132 | 2015-01-01 | CLP | Chile | 2100.0 | 627.485 | 3.34669354645928 |
6133 | 6133 | 2015-01-01 | CNY | China | 17.2 | 6.2115 | 2.7690573935442298 |
6134 | 6134 | 2015-01-01 | COP | Colombia | 7900.0 | 2364.98 | 3.340408798383069 |
6135 | 6135 | 2015-01-01 | CRC | Costa Rica | 2150.0 | 536.09 | 4.01052062153743 |
6136 | 6136 | 2015-01-01 | CZK | Czech Republic | 70.45 | 24.13325 | 2.9192089751691097 |
6137 | 6137 | 2015-01-01 | DKK | Denmark | 34.5 | 6.4174 | 5.37600897559759 |
6138 | 6138 | 2015-01-01 | EGP | Egypt | 16.93 | 7.35005 | 2.3033856912538 |
6139 | 6139 | 2015-01-01 | EUR | Euro area | 3.68 | 0.8630734040000001 | 4.26383200194175 |
6140 | 6140 | 2015-01-01 | GBP | Britain | 2.89 | 0.6615944429999999 | 4.36823499740308 |
6141 | 6141 | 2015-01-01 | HKD | Hong Kong | 18.8 | 7.75135 | 2.42538396537377 |
6142 | 6142 | 2015-01-01 | HUF | Hungary | 860.0 | 271.39345 | 3.16883108269562 |
6143 | 6143 | 2015-01-01 | IDR | Indonesia | 27939.0 | 12480.0 | 2.23870192307692 |
6144 | 6144 | 2015-01-01 | INR | India | 116.25 | 61.615 | 1.88671589710298 |
6145 | 6145 | 2015-01-01 | ILS | Israel | 17.5 | 3.93415 | 4.4482289694088895 |
6146 | 6146 | 2015-01-01 | JPY | Japan | 370.0 | 117.765 | 3.14185029507918 |
6147 | 6147 | 2015-01-01 | KRW | South Korea | 4100.0 | 1083.3 | 3.7847318379027097 |
6148 | 6148 | 2015-01-01 | LKR | Sri Lanka | 350.0 | 131.875 | 2.65402843601896 |
6149 | 6149 | 2015-01-01 | MXN | Mexico | 49.0 | 14.6275 | 3.34985472568792 |
6150 | 6150 | 2015-01-01 | MYR | Malaysia | 7.63 | 3.6155 | 2.11035818005808 |
6151 | 6151 | 2015-01-01 | NOK | Norway | 48.0 | 7.6225 | 6.29714660544441 |
6152 | 6152 | 2015-01-01 | NZD | New Zealand | 5.9 | 1.313283866 | 4.49255500105261 |
6153 | 6153 | 2015-01-01 | PKR | Pakistan | 300.0 | 100.735 | 2.97811088499528 |
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 );