bigmac
430 rows where "date" is on date 2016-01-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
3566 | 3566 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
3567 | 3567 | 2016-01-01 | HKD | Hong Kong | 19.2 | 7.75235 | 2.4766683650764 |
3568 | 3568 | 2016-01-01 | HUF | Hungary | 900.0 | 292.67905 | 3.07504073147702 |
3569 | 3569 | 2016-01-01 | IDR | Indonesia | 30500.0 | 13947.5 | 2.18677182290733 |
3570 | 3570 | 2016-01-01 | INR | India | 127.0 | 66.8025 | 1.9011264548482496 |
3571 | 3571 | 2016-01-01 | ILS | Israel | 16.9 | 3.94105 | 4.288197307824061 |
3572 | 3572 | 2016-01-01 | JPY | Japan | 370.0 | 118.645 | 3.11854692570273 |
3573 | 3573 | 2016-01-01 | KRW | South Korea | 4300.0 | 1197.75 | 3.59006470465456 |
3574 | 3574 | 2016-01-01 | LKR | Sri Lanka | 350.0 | 144.05 | 2.42971190558834 |
3575 | 3575 | 2016-01-01 | MXN | Mexico | 49.0 | 17.43675 | 2.81015670924914 |
3576 | 3576 | 2016-01-01 | MYR | Malaysia | 8.0 | 4.3925 | 1.82128628343768 |
3577 | 3577 | 2016-01-01 | NOK | Norway | 46.8 | 8.97465 | 5.21468803797363 |
3578 | 3578 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
3579 | 3579 | 2016-01-01 | PKR | Pakistan | 300.0 | 104.885 | 2.86027553987701 |
3580 | 3580 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
3581 | 3581 | 2016-01-01 | PHP | Philippines | 131.0 | 47.0225 | 2.7859003668456603 |
3582 | 3582 | 2016-01-01 | PLN | Poland | 9.6 | 4.0477 | 2.37171727153692 |
3583 | 3583 | 2016-01-01 | RUB | Russia | 114.0 | 74.655 | 1.52702431183444 |
3584 | 3584 | 2016-01-01 | SAR | Saudi Arabia | 12.0 | 3.7543 | 3.1963348693498097 |
3585 | 3585 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
3586 | 3586 | 2016-01-01 | SEK | Sweden | 45.0 | 8.60185 | 5.23143277318251 |
3587 | 3587 | 2016-01-01 | THB | Thailand | 112.0 | 36.22 | 3.09221424627278 |
3588 | 3588 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
3589 | 3589 | 2016-01-01 | TWD | Taiwan | 69.0 | 33.2315 | 2.07634322856326 |
3590 | 3590 | 2016-01-01 | UAH | Ukraine | 36.0 | 23.35 | 1.54175588865096 |
3591 | 3591 | 2016-01-01 | UYU | Uruguay | 113.0 | 30.185 | 3.74358124896472 |
3592 | 3592 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
3593 | 3593 | 2016-01-01 | VND | Vietnam | 60000.0 | 22467.5 | 2.6705240903527296 |
3594 | 3594 | 2016-01-01 | ZAR | South Africa | 28.0 | 15.81375 | 1.7706110188917898 |
4882 | 4882 | 2016-01-01 | AED | UAE | 13.0 | 3.6731 | 3.5392447796139503 |
4883 | 4883 | 2016-01-01 | ARS | Argentina | 33.0 | 13.80925 | 2.3897025544472004 |
4884 | 4884 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
4885 | 4885 | 2016-01-01 | BRL | Brazil | 13.5 | 4.0248 | 3.35420393559928 |
4886 | 4886 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
4887 | 4887 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
4888 | 4888 | 2016-01-01 | CLP | Chile | 2100.0 | 715.215 | 2.9361800297812497 |
4889 | 4889 | 2016-01-01 | CNY | China | 17.6 | 6.5582 | 2.68366320026837 |
4890 | 4890 | 2016-01-01 | COP | Colombia | 7900.0 | 3253.9 | 2.42785580380467 |
4891 | 4891 | 2016-01-01 | CRC | Costa Rica | 2150.0 | 535.25 | 4.01681457262961 |
4892 | 4892 | 2016-01-01 | CZK | Czech Republic | 75.0 | 25.1442 | 2.98279523707257 |
4893 | 4893 | 2016-01-01 | DKK | Denmark | 30.0 | 6.9405 | 4.32245515452777 |
4894 | 4894 | 2016-01-01 | EGP | Egypt | 16.93 | 7.83005 | 2.1621828723954497 |
4895 | 4895 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
4896 | 4896 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
4897 | 4897 | 2016-01-01 | HKD | Hong Kong | 19.2 | 7.75235 | 2.4766683650764 |
4898 | 4898 | 2016-01-01 | HUF | Hungary | 900.0 | 292.67905 | 3.07504073147702 |
4899 | 4899 | 2016-01-01 | IDR | Indonesia | 30500.0 | 13947.5 | 2.18677182290733 |
4900 | 4900 | 2016-01-01 | INR | India | 127.0 | 66.8025 | 1.9011264548482496 |
4901 | 4901 | 2016-01-01 | ILS | Israel | 16.9 | 3.94105 | 4.288197307824061 |
4902 | 4902 | 2016-01-01 | JPY | Japan | 370.0 | 118.645 | 3.11854692570273 |
4903 | 4903 | 2016-01-01 | KRW | South Korea | 4300.0 | 1197.75 | 3.59006470465456 |
4904 | 4904 | 2016-01-01 | LKR | Sri Lanka | 350.0 | 144.05 | 2.42971190558834 |
4905 | 4905 | 2016-01-01 | MXN | Mexico | 49.0 | 17.43675 | 2.81015670924914 |
4906 | 4906 | 2016-01-01 | MYR | Malaysia | 8.0 | 4.3925 | 1.82128628343768 |
4907 | 4907 | 2016-01-01 | NOK | Norway | 46.8 | 8.97465 | 5.21468803797363 |
4908 | 4908 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
4909 | 4909 | 2016-01-01 | PKR | Pakistan | 300.0 | 104.885 | 2.86027553987701 |
4910 | 4910 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
4911 | 4911 | 2016-01-01 | PHP | Philippines | 131.0 | 47.0225 | 2.7859003668456603 |
4912 | 4912 | 2016-01-01 | PLN | Poland | 9.6 | 4.0477 | 2.37171727153692 |
4913 | 4913 | 2016-01-01 | RUB | Russia | 114.0 | 74.655 | 1.52702431183444 |
4914 | 4914 | 2016-01-01 | SAR | Saudi Arabia | 12.0 | 3.7543 | 3.1963348693498097 |
4915 | 4915 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
4916 | 4916 | 2016-01-01 | SEK | Sweden | 45.0 | 8.60185 | 5.23143277318251 |
4917 | 4917 | 2016-01-01 | THB | Thailand | 112.0 | 36.22 | 3.09221424627278 |
4918 | 4918 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
4919 | 4919 | 2016-01-01 | TWD | Taiwan | 69.0 | 33.2315 | 2.07634322856326 |
4920 | 4920 | 2016-01-01 | UAH | Ukraine | 36.0 | 23.35 | 1.54175588865096 |
4921 | 4921 | 2016-01-01 | UYU | Uruguay | 113.0 | 30.185 | 3.74358124896472 |
4922 | 4922 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
4923 | 4923 | 2016-01-01 | VND | Vietnam | 60000.0 | 22467.5 | 2.6705240903527296 |
4924 | 4924 | 2016-01-01 | ZAR | South Africa | 28.0 | 15.81375 | 1.7706110188917898 |
6212 | 6212 | 2016-01-01 | AED | UAE | 13.0 | 3.6731 | 3.5392447796139503 |
6213 | 6213 | 2016-01-01 | ARS | Argentina | 33.0 | 13.80925 | 2.3897025544472004 |
6214 | 6214 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
6215 | 6215 | 2016-01-01 | BRL | Brazil | 13.5 | 4.0248 | 3.35420393559928 |
6216 | 6216 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
6217 | 6217 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
6218 | 6218 | 2016-01-01 | CLP | Chile | 2100.0 | 715.215 | 2.9361800297812497 |
6219 | 6219 | 2016-01-01 | CNY | China | 17.6 | 6.5582 | 2.68366320026837 |
6220 | 6220 | 2016-01-01 | COP | Colombia | 7900.0 | 3253.9 | 2.42785580380467 |
6221 | 6221 | 2016-01-01 | CRC | Costa Rica | 2150.0 | 535.25 | 4.01681457262961 |
6222 | 6222 | 2016-01-01 | CZK | Czech Republic | 75.0 | 25.1442 | 2.98279523707257 |
6223 | 6223 | 2016-01-01 | DKK | Denmark | 30.0 | 6.9405 | 4.32245515452777 |
6224 | 6224 | 2016-01-01 | EGP | Egypt | 16.93 | 7.83005 | 2.1621828723954497 |
6225 | 6225 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
6226 | 6226 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
6227 | 6227 | 2016-01-01 | HKD | Hong Kong | 19.2 | 7.75235 | 2.4766683650764 |
6228 | 6228 | 2016-01-01 | HUF | Hungary | 900.0 | 292.67905 | 3.07504073147702 |
6229 | 6229 | 2016-01-01 | IDR | Indonesia | 30500.0 | 13947.5 | 2.18677182290733 |
6230 | 6230 | 2016-01-01 | INR | India | 127.0 | 66.8025 | 1.9011264548482496 |
6231 | 6231 | 2016-01-01 | ILS | Israel | 16.9 | 3.94105 | 4.288197307824061 |
6232 | 6232 | 2016-01-01 | JPY | Japan | 370.0 | 118.645 | 3.11854692570273 |
6233 | 6233 | 2016-01-01 | KRW | South Korea | 4300.0 | 1197.75 | 3.59006470465456 |
6234 | 6234 | 2016-01-01 | LKR | Sri Lanka | 350.0 | 144.05 | 2.42971190558834 |
6235 | 6235 | 2016-01-01 | MXN | Mexico | 49.0 | 17.43675 | 2.81015670924914 |
6236 | 6236 | 2016-01-01 | MYR | Malaysia | 8.0 | 4.3925 | 1.82128628343768 |
6237 | 6237 | 2016-01-01 | NOK | Norway | 46.8 | 8.97465 | 5.21468803797363 |
6238 | 6238 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
6239 | 6239 | 2016-01-01 | PKR | Pakistan | 300.0 | 104.885 | 2.86027553987701 |
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 );