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 |
---|---|---|---|---|---|---|---|
3437 | 3437 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
3438 | 3438 | 2014-07-01 | HKD | Hong Kong | 18.8 | 7.75045 | 2.42566560651317 |
3439 | 3439 | 2014-07-01 | HUF | Hungary | 860.0 | 228.30615 | 3.76687180787727 |
3440 | 3440 | 2014-07-01 | IDR | Indonesia | 27939.0 | 11505.0 | 2.42842242503259 |
3441 | 3441 | 2014-07-01 | INR | India | 105.0 | 60.08875 | 1.7474152815626898 |
3442 | 3442 | 2014-07-01 | ILS | Israel | 17.5 | 3.4138 | 5.12625227019743 |
3443 | 3443 | 2014-07-01 | JPY | Japan | 370.0 | 101.53 | 3.6442430808628 |
3444 | 3444 | 2014-07-01 | KRW | South Korea | 4100.0 | 1023.75 | 4.00488400488401 |
3445 | 3445 | 2014-07-01 | LKR | Sri Lanka | 350.0 | 130.255 | 2.6870369659514 |
3446 | 3446 | 2014-07-01 | MXN | Mexico | 42.0 | 12.93255 | 3.24761937900878 |
3447 | 3447 | 2014-07-01 | MYR | Malaysia | 7.63 | 3.1675 | 2.40883977900553 |
3448 | 3448 | 2014-07-01 | NOK | Norway | 48.0 | 6.1873 | 7.75782651560455 |
3449 | 3449 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
3450 | 3450 | 2014-07-01 | PKR | Pakistan | 300.0 | 98.68 | 3.04012971220105 |
3451 | 3451 | 2014-07-01 | PEN | Peru | 10.0 | 2.7880000000000003 | 3.5868005738880897 |
3452 | 3452 | 2014-07-01 | PHP | Philippines | 160.0 | 43.205 | 3.7032750839023296 |
3453 | 3453 | 2014-07-01 | PLN | Poland | 9.2 | 3.0714 | 2.99537670117862 |
3454 | 3454 | 2014-07-01 | RUB | Russia | 89.0 | 34.83725 | 2.5547366683650403 |
3455 | 3455 | 2014-07-01 | SAR | Saudi Arabia | 11.0 | 3.75035 | 2.93305958110576 |
3456 | 3456 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
3457 | 3457 | 2014-07-01 | SEK | Sweden | 40.7 | 6.836 | 5.95377413692218 |
3458 | 3458 | 2014-07-01 | THB | Thailand | 99.0 | 31.78 | 3.11516677155444 |
3459 | 3459 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
3460 | 3460 | 2014-07-01 | TWD | Taiwan | 79.0 | 29.982 | 2.63491428190248 |
3461 | 3461 | 2014-07-01 | UAH | Ukraine | 19.0 | 11.685 | 1.6260162601626 |
3462 | 3462 | 2014-07-01 | UYU | Uruguay | 113.0 | 22.97 | 4.91946016543317 |
3463 | 3463 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
3464 | 3464 | 2014-07-01 | VND | Vietnam | 60000.0 | 21230.0 | 2.82618935468676 |
3465 | 3465 | 2014-07-01 | ZAR | South Africa | 24.5 | 10.5145 | 2.33011555471016 |
4753 | 4753 | 2014-07-01 | AED | UAE | 13.0 | 3.67305 | 3.5392929581682795 |
4754 | 4754 | 2014-07-01 | ARS | Argentina | 21.0 | 8.16875 | 2.5707727620505 |
4755 | 4755 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
4756 | 4756 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
4757 | 4757 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
4758 | 4758 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
4759 | 4759 | 2014-07-01 | CLP | Chile | 2100.0 | 564.14 | 3.72248023540256 |
4760 | 4760 | 2014-07-01 | CNY | China | 16.9 | 6.1983 | 2.72655405514415 |
4761 | 4761 | 2014-07-01 | COP | Colombia | 8600.0 | 1847.65 | 4.654561199361349 |
4762 | 4762 | 2014-07-01 | CRC | Costa Rica | 2150.0 | 537.3 | 4.0014889261120405 |
4763 | 4763 | 2014-07-01 | CZK | Czech Republic | 70.45 | 20.3877 | 3.4555148447348194 |
4764 | 4764 | 2014-07-01 | DKK | Denmark | 28.5 | 5.5388 | 5.14551888495703 |
4765 | 4765 | 2014-07-01 | EGP | Egypt | 16.93 | 7.15005 | 2.36781560968105 |
4766 | 4766 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
4767 | 4767 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
4768 | 4768 | 2014-07-01 | HKD | Hong Kong | 18.8 | 7.75045 | 2.42566560651317 |
4769 | 4769 | 2014-07-01 | HUF | Hungary | 860.0 | 228.30615 | 3.76687180787727 |
4770 | 4770 | 2014-07-01 | IDR | Indonesia | 27939.0 | 11505.0 | 2.42842242503259 |
4771 | 4771 | 2014-07-01 | INR | India | 105.0 | 60.08875 | 1.7474152815626898 |
4772 | 4772 | 2014-07-01 | ILS | Israel | 17.5 | 3.4138 | 5.12625227019743 |
4773 | 4773 | 2014-07-01 | JPY | Japan | 370.0 | 101.53 | 3.6442430808628 |
4774 | 4774 | 2014-07-01 | KRW | South Korea | 4100.0 | 1023.75 | 4.00488400488401 |
4775 | 4775 | 2014-07-01 | LKR | Sri Lanka | 350.0 | 130.255 | 2.6870369659514 |
4776 | 4776 | 2014-07-01 | MXN | Mexico | 42.0 | 12.93255 | 3.24761937900878 |
4777 | 4777 | 2014-07-01 | MYR | Malaysia | 7.63 | 3.1675 | 2.40883977900553 |
4778 | 4778 | 2014-07-01 | NOK | Norway | 48.0 | 6.1873 | 7.75782651560455 |
4779 | 4779 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
4780 | 4780 | 2014-07-01 | PKR | Pakistan | 300.0 | 98.68 | 3.04012971220105 |
4781 | 4781 | 2014-07-01 | PEN | Peru | 10.0 | 2.7880000000000003 | 3.5868005738880897 |
4782 | 4782 | 2014-07-01 | PHP | Philippines | 160.0 | 43.205 | 3.7032750839023296 |
4783 | 4783 | 2014-07-01 | PLN | Poland | 9.2 | 3.0714 | 2.99537670117862 |
4784 | 4784 | 2014-07-01 | RUB | Russia | 89.0 | 34.83725 | 2.5547366683650403 |
4785 | 4785 | 2014-07-01 | SAR | Saudi Arabia | 11.0 | 3.75035 | 2.93305958110576 |
4786 | 4786 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
4787 | 4787 | 2014-07-01 | SEK | Sweden | 40.7 | 6.836 | 5.95377413692218 |
4788 | 4788 | 2014-07-01 | THB | Thailand | 99.0 | 31.78 | 3.11516677155444 |
4789 | 4789 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
4790 | 4790 | 2014-07-01 | TWD | Taiwan | 79.0 | 29.982 | 2.63491428190248 |
4791 | 4791 | 2014-07-01 | UAH | Ukraine | 19.0 | 11.685 | 1.6260162601626 |
4792 | 4792 | 2014-07-01 | UYU | Uruguay | 113.0 | 22.97 | 4.91946016543317 |
4793 | 4793 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
4794 | 4794 | 2014-07-01 | VND | Vietnam | 60000.0 | 21230.0 | 2.82618935468676 |
4795 | 4795 | 2014-07-01 | ZAR | South Africa | 24.5 | 10.5145 | 2.33011555471016 |
6083 | 6083 | 2014-07-01 | AED | UAE | 13.0 | 3.67305 | 3.5392929581682795 |
6084 | 6084 | 2014-07-01 | ARS | Argentina | 21.0 | 8.16875 | 2.5707727620505 |
6085 | 6085 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
6086 | 6086 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
6087 | 6087 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
6088 | 6088 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
6089 | 6089 | 2014-07-01 | CLP | Chile | 2100.0 | 564.14 | 3.72248023540256 |
6090 | 6090 | 2014-07-01 | CNY | China | 16.9 | 6.1983 | 2.72655405514415 |
6091 | 6091 | 2014-07-01 | COP | Colombia | 8600.0 | 1847.65 | 4.654561199361349 |
6092 | 6092 | 2014-07-01 | CRC | Costa Rica | 2150.0 | 537.3 | 4.0014889261120405 |
6093 | 6093 | 2014-07-01 | CZK | Czech Republic | 70.45 | 20.3877 | 3.4555148447348194 |
6094 | 6094 | 2014-07-01 | DKK | Denmark | 28.5 | 5.5388 | 5.14551888495703 |
6095 | 6095 | 2014-07-01 | EGP | Egypt | 16.93 | 7.15005 | 2.36781560968105 |
6096 | 6096 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
6097 | 6097 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
6098 | 6098 | 2014-07-01 | HKD | Hong Kong | 18.8 | 7.75045 | 2.42566560651317 |
6099 | 6099 | 2014-07-01 | HUF | Hungary | 860.0 | 228.30615 | 3.76687180787727 |
6100 | 6100 | 2014-07-01 | IDR | Indonesia | 27939.0 | 11505.0 | 2.42842242503259 |
6101 | 6101 | 2014-07-01 | INR | India | 105.0 | 60.08875 | 1.7474152815626898 |
6102 | 6102 | 2014-07-01 | ILS | Israel | 17.5 | 3.4138 | 5.12625227019743 |
6103 | 6103 | 2014-07-01 | JPY | Japan | 370.0 | 101.53 | 3.6442430808628 |
6104 | 6104 | 2014-07-01 | KRW | South Korea | 4100.0 | 1023.75 | 4.00488400488401 |
6105 | 6105 | 2014-07-01 | LKR | Sri Lanka | 350.0 | 130.255 | 2.6870369659514 |
6106 | 6106 | 2014-07-01 | MXN | Mexico | 42.0 | 12.93255 | 3.24761937900878 |
6107 | 6107 | 2014-07-01 | MYR | Malaysia | 7.63 | 3.1675 | 2.40883977900553 |
6108 | 6108 | 2014-07-01 | NOK | Norway | 48.0 | 6.1873 | 7.75782651560455 |
6109 | 6109 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
6110 | 6110 | 2014-07-01 | PKR | Pakistan | 300.0 | 98.68 | 3.04012971220105 |
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 );