bigmac
410 rows where "date" is on date 2010-07-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
472 | 472 | 2010-07-01 | AED | UAE | 11.0 | 3.67285 | 2.99494942619492 |
473 | 473 | 2010-07-01 | ARS | Argentina | 14.0 | 3.93375 | 3.55894502700985 |
474 | 474 | 2010-07-01 | AUD | Australia | 4.35 | 1.133722578 | 3.8369175002881497 |
475 | 475 | 2010-07-01 | BRL | Brazil | 8.71 | 1.77495 | 4.907180483957299 |
476 | 476 | 2010-07-01 | CAD | Canada | 4.17 | 1.04235 | 4.000575622391709 |
477 | 477 | 2010-07-01 | CHF | Switzerland | 6.5 | 1.05085 | 6.185468906123611 |
478 | 478 | 2010-07-01 | CLP | Chile | 1750.0 | 523.65 | 3.34192685954359 |
479 | 479 | 2010-07-01 | CNY | China | 13.2 | 6.7769 | 1.9477932387965 |
480 | 480 | 2010-07-01 | COP | Colombia | 8200.0 | 1868.45 | 4.388664400974069 |
481 | 481 | 2010-07-01 | CRC | Costa Rica | 2000.0 | 522.115 | 3.83057372417954 |
482 | 482 | 2010-07-01 | CZK | Czech Republic | 67.64 | 19.7476 | 3.4252263566205494 |
483 | 483 | 2010-07-01 | DKK | Denmark | 28.5 | 5.81365 | 4.90225589775786 |
484 | 484 | 2010-07-01 | EGP | Egypt | 13.0 | 5.699 | 2.28110194771012 |
485 | 485 | 2010-07-01 | EUR | Euro area | 3.3800310710000003 | 0.78015291 | 4.33252382664316 |
486 | 486 | 2010-07-01 | GBP | Britain | 2.29 | 0.657375756 | 3.48354799990525 |
487 | 487 | 2010-07-01 | HKD | Hong Kong | 14.8 | 7.7742 | 1.90373285997273 |
488 | 488 | 2010-07-01 | HUF | Hungary | 740.0 | 221.96915 | 3.33379661092544 |
489 | 489 | 2010-07-01 | IDR | Indonesia | 22780.0 | 9063.0 | 2.5135164956416203 |
490 | 490 | 2010-07-01 | ILS | Israel | 14.9 | 3.8619 | 3.85820451073306 |
491 | 491 | 2010-07-01 | JPY | Japan | 320.0 | 87.18 | 3.67056664372563 |
492 | 492 | 2010-07-01 | KRW | South Korea | 3400.0 | 1204.45 | 2.82286520818631 |
493 | 493 | 2010-07-01 | LKR | Sri Lanka | 210.0 | 112.775 | 1.86211483041454 |
494 | 494 | 2010-07-01 | MXN | Mexico | 32.0 | 12.782 | 2.50352057580973 |
495 | 495 | 2010-07-01 | MYR | Malaysia | 7.05 | 3.2135 | 2.19386961257196 |
496 | 496 | 2010-07-01 | NOK | Norway | 45.0 | 6.24625 | 7.20432259355613 |
497 | 497 | 2010-07-01 | NZD | New Zealand | 5.0 | 1.39275766 | 3.5900000004308 |
498 | 498 | 2010-07-01 | PKR | Pakistan | 210.0 | 85.525 | 2.4554223911137103 |
499 | 499 | 2010-07-01 | PEN | Peru | 10.0 | 2.8275 | 3.5366931918656097 |
500 | 500 | 2010-07-01 | PHP | Philippines | 102.0 | 46.47 | 2.19496449322143 |
501 | 501 | 2010-07-01 | PLN | Poland | 8.3 | 3.1969 | 2.59626513184648 |
502 | 502 | 2010-07-01 | RUB | Russia | 71.0 | 30.44325 | 2.3322082891938303 |
503 | 503 | 2010-07-01 | SAR | Saudi Arabia | 10.0 | 3.75045 | 2.66634670506206 |
504 | 504 | 2010-07-01 | SGD | Singapore | 4.23 | 1.3742 | 3.0781545626546403 |
505 | 505 | 2010-07-01 | SEK | Sweden | 48.4 | 7.37355 | 6.564002414033951 |
506 | 506 | 2010-07-01 | THB | Thailand | 70.0 | 32.305 | 2.16684723726977 |
507 | 507 | 2010-07-01 | TRY | Turkey | 5.95 | 1.5293 | 3.89066893349899 |
508 | 508 | 2010-07-01 | TWD | Taiwan | 75.0 | 32.1055 | 2.336048340627 |
509 | 509 | 2010-07-01 | UAH | Ukraine | 14.5 | 7.899 | 1.8356754019496104 |
510 | 510 | 2010-07-01 | UYU | Uruguay | 79.0 | 21.1 | 3.74407582938389 |
511 | 511 | 2010-07-01 | USD | United States | 3.733333333 | 1.0 | 3.733333333 |
512 | 512 | 2010-07-01 | ZAR | South Africa | 18.45 | 7.5365 | 2.44808598155643 |
1802 | 1802 | 2010-07-01 | AED | UAE | 11.0 | 3.67285 | 2.99494942619492 |
1803 | 1803 | 2010-07-01 | ARS | Argentina | 14.0 | 3.93375 | 3.55894502700985 |
1804 | 1804 | 2010-07-01 | AUD | Australia | 4.35 | 1.133722578 | 3.8369175002881497 |
1805 | 1805 | 2010-07-01 | BRL | Brazil | 8.71 | 1.77495 | 4.907180483957299 |
1806 | 1806 | 2010-07-01 | CAD | Canada | 4.17 | 1.04235 | 4.000575622391709 |
1807 | 1807 | 2010-07-01 | CHF | Switzerland | 6.5 | 1.05085 | 6.185468906123611 |
1808 | 1808 | 2010-07-01 | CLP | Chile | 1750.0 | 523.65 | 3.34192685954359 |
1809 | 1809 | 2010-07-01 | CNY | China | 13.2 | 6.7769 | 1.9477932387965 |
1810 | 1810 | 2010-07-01 | COP | Colombia | 8200.0 | 1868.45 | 4.388664400974069 |
1811 | 1811 | 2010-07-01 | CRC | Costa Rica | 2000.0 | 522.115 | 3.83057372417954 |
1812 | 1812 | 2010-07-01 | CZK | Czech Republic | 67.64 | 19.7476 | 3.4252263566205494 |
1813 | 1813 | 2010-07-01 | DKK | Denmark | 28.5 | 5.81365 | 4.90225589775786 |
1814 | 1814 | 2010-07-01 | EGP | Egypt | 13.0 | 5.699 | 2.28110194771012 |
1815 | 1815 | 2010-07-01 | EUR | Euro area | 3.3800310710000003 | 0.78015291 | 4.33252382664316 |
1816 | 1816 | 2010-07-01 | GBP | Britain | 2.29 | 0.657375756 | 3.48354799990525 |
1817 | 1817 | 2010-07-01 | HKD | Hong Kong | 14.8 | 7.7742 | 1.90373285997273 |
1818 | 1818 | 2010-07-01 | HUF | Hungary | 740.0 | 221.96915 | 3.33379661092544 |
1819 | 1819 | 2010-07-01 | IDR | Indonesia | 22780.0 | 9063.0 | 2.5135164956416203 |
1820 | 1820 | 2010-07-01 | ILS | Israel | 14.9 | 3.8619 | 3.85820451073306 |
1821 | 1821 | 2010-07-01 | JPY | Japan | 320.0 | 87.18 | 3.67056664372563 |
1822 | 1822 | 2010-07-01 | KRW | South Korea | 3400.0 | 1204.45 | 2.82286520818631 |
1823 | 1823 | 2010-07-01 | LKR | Sri Lanka | 210.0 | 112.775 | 1.86211483041454 |
1824 | 1824 | 2010-07-01 | MXN | Mexico | 32.0 | 12.782 | 2.50352057580973 |
1825 | 1825 | 2010-07-01 | MYR | Malaysia | 7.05 | 3.2135 | 2.19386961257196 |
1826 | 1826 | 2010-07-01 | NOK | Norway | 45.0 | 6.24625 | 7.20432259355613 |
1827 | 1827 | 2010-07-01 | NZD | New Zealand | 5.0 | 1.39275766 | 3.5900000004308 |
1828 | 1828 | 2010-07-01 | PKR | Pakistan | 210.0 | 85.525 | 2.4554223911137103 |
1829 | 1829 | 2010-07-01 | PEN | Peru | 10.0 | 2.8275 | 3.5366931918656097 |
1830 | 1830 | 2010-07-01 | PHP | Philippines | 102.0 | 46.47 | 2.19496449322143 |
1831 | 1831 | 2010-07-01 | PLN | Poland | 8.3 | 3.1969 | 2.59626513184648 |
1832 | 1832 | 2010-07-01 | RUB | Russia | 71.0 | 30.44325 | 2.3322082891938303 |
1833 | 1833 | 2010-07-01 | SAR | Saudi Arabia | 10.0 | 3.75045 | 2.66634670506206 |
1834 | 1834 | 2010-07-01 | SGD | Singapore | 4.23 | 1.3742 | 3.0781545626546403 |
1835 | 1835 | 2010-07-01 | SEK | Sweden | 48.4 | 7.37355 | 6.564002414033951 |
1836 | 1836 | 2010-07-01 | THB | Thailand | 70.0 | 32.305 | 2.16684723726977 |
1837 | 1837 | 2010-07-01 | TRY | Turkey | 5.95 | 1.5293 | 3.89066893349899 |
1838 | 1838 | 2010-07-01 | TWD | Taiwan | 75.0 | 32.1055 | 2.336048340627 |
1839 | 1839 | 2010-07-01 | UAH | Ukraine | 14.5 | 7.899 | 1.8356754019496104 |
1840 | 1840 | 2010-07-01 | UYU | Uruguay | 79.0 | 21.1 | 3.74407582938389 |
1841 | 1841 | 2010-07-01 | USD | United States | 3.733333333 | 1.0 | 3.733333333 |
1842 | 1842 | 2010-07-01 | ZAR | South Africa | 18.45 | 7.5365 | 2.44808598155643 |
3132 | 3132 | 2010-07-01 | AED | UAE | 11.0 | 3.67285 | 2.99494942619492 |
3133 | 3133 | 2010-07-01 | ARS | Argentina | 14.0 | 3.93375 | 3.55894502700985 |
3134 | 3134 | 2010-07-01 | AUD | Australia | 4.35 | 1.133722578 | 3.8369175002881497 |
3135 | 3135 | 2010-07-01 | BRL | Brazil | 8.71 | 1.77495 | 4.907180483957299 |
3136 | 3136 | 2010-07-01 | CAD | Canada | 4.17 | 1.04235 | 4.000575622391709 |
3137 | 3137 | 2010-07-01 | CHF | Switzerland | 6.5 | 1.05085 | 6.185468906123611 |
3138 | 3138 | 2010-07-01 | CLP | Chile | 1750.0 | 523.65 | 3.34192685954359 |
3139 | 3139 | 2010-07-01 | CNY | China | 13.2 | 6.7769 | 1.9477932387965 |
3140 | 3140 | 2010-07-01 | COP | Colombia | 8200.0 | 1868.45 | 4.388664400974069 |
3141 | 3141 | 2010-07-01 | CRC | Costa Rica | 2000.0 | 522.115 | 3.83057372417954 |
3142 | 3142 | 2010-07-01 | CZK | Czech Republic | 67.64 | 19.7476 | 3.4252263566205494 |
3143 | 3143 | 2010-07-01 | DKK | Denmark | 28.5 | 5.81365 | 4.90225589775786 |
3144 | 3144 | 2010-07-01 | EGP | Egypt | 13.0 | 5.699 | 2.28110194771012 |
3145 | 3145 | 2010-07-01 | EUR | Euro area | 3.3800310710000003 | 0.78015291 | 4.33252382664316 |
3146 | 3146 | 2010-07-01 | GBP | Britain | 2.29 | 0.657375756 | 3.48354799990525 |
3147 | 3147 | 2010-07-01 | HKD | Hong Kong | 14.8 | 7.7742 | 1.90373285997273 |
3148 | 3148 | 2010-07-01 | HUF | Hungary | 740.0 | 221.96915 | 3.33379661092544 |
3149 | 3149 | 2010-07-01 | IDR | Indonesia | 22780.0 | 9063.0 | 2.5135164956416203 |
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 );