bigmac
430 rows where "date" is on date 2016-07-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
3609 | 3609 | 2016-07-01 | GBP | Britain | 2.99 | 0.758840492 | 3.94022199859098 |
3610 | 3610 | 2016-07-01 | HKD | Hong Kong | 19.2 | 7.7554 | 2.4756943549011 |
3611 | 3611 | 2016-07-01 | HUF | Hungary | 900.0 | 285.6397 | 3.15082252221943 |
3612 | 3612 | 2016-07-01 | IDR | Indonesia | 31000.0 | 13112.5 | 2.36415633937083 |
3613 | 3613 | 2016-07-01 | INR | India | 162.0 | 67.2 | 2.41071428571429 |
3614 | 3614 | 2016-07-01 | ILS | Israel | 16.9 | 3.85875 | 4.37965662455458 |
3615 | 3615 | 2016-07-01 | JPY | Japan | 370.0 | 106.725 | 3.46685406418365 |
3616 | 3616 | 2016-07-01 | KRW | South Korea | 4400.0 | 1140.95 | 3.85643542661817 |
3617 | 3617 | 2016-07-01 | LKR | Sri Lanka | 530.0 | 146.2 | 3.6251709986320098 |
3618 | 3618 | 2016-07-01 | MXN | Mexico | 44.0 | 18.535 | 2.37388724035608 |
3619 | 3619 | 2016-07-01 | MYR | Malaysia | 8.0 | 4.027 | 1.9865905140303 |
3620 | 3620 | 2016-07-01 | NOK | Norway | 46.8 | 8.49355 | 5.51006351878779 |
3621 | 3621 | 2016-07-01 | NZD | New Zealand | 6.0 | 1.4213630869999998 | 4.221300000595839 |
3622 | 3622 | 2016-07-01 | PKR | Pakistan | 375.0 | 104.82 | 3.57756153405839 |
3623 | 3623 | 2016-07-01 | PEN | Peru | 10.0 | 3.30585 | 3.02494063554003 |
3624 | 3624 | 2016-07-01 | PHP | Philippines | 133.0 | 47.115 | 2.82288018677704 |
3625 | 3625 | 2016-07-01 | PLN | Poland | 9.6 | 3.96565 | 2.42078852142776 |
3626 | 3626 | 2016-07-01 | RUB | Russia | 130.0 | 63.40755 | 2.05022903423961 |
3627 | 3627 | 2016-07-01 | SAR | Saudi Arabia | 12.0 | 3.7505 | 3.19957339021464 |
3628 | 3628 | 2016-07-01 | SGD | Singapore | 5.45 | 1.3577 | 4.01414156293732 |
3629 | 3629 | 2016-07-01 | SEK | Sweden | 44.94 | 8.59485 | 5.228712542976321 |
3630 | 3630 | 2016-07-01 | THB | Thailand | 119.0 | 34.965 | 3.4034034034034 |
3631 | 3631 | 2016-07-01 | TRY | Turkey | 10.75 | 3.04305 | 3.53263995005011 |
3632 | 3632 | 2016-07-01 | TWD | Taiwan | 69.0 | 32.029 | 2.1542976677386103 |
3633 | 3633 | 2016-07-01 | UAH | Ukraine | 39.0 | 24.8 | 1.5725806451612905 |
3634 | 3634 | 2016-07-01 | UYU | Uruguay | 123.0 | 30.165 | 4.07757334659373 |
3635 | 3635 | 2016-07-01 | USD | United States | 5.04 | 1.0 | 5.04 |
3636 | 3636 | 2016-07-01 | VND | Vietnam | 60000.0 | 22300.0 | 2.69058295964126 |
3637 | 3637 | 2016-07-01 | ZAR | South Africa | 30.0 | 14.27375 | 2.10176022418776 |
4925 | 4925 | 2016-07-01 | AED | UAE | 13.0 | 3.6731 | 3.5392447796139503 |
4926 | 4926 | 2016-07-01 | ARS | Argentina | 50.0 | 14.935 | 3.3478406427854 |
4927 | 4927 | 2016-07-01 | AUD | Australia | 5.75 | 1.335737661 | 4.3047375003975406 |
4928 | 4928 | 2016-07-01 | BRL | Brazil | 15.5 | 3.24145 | 4.78181060944948 |
4929 | 4929 | 2016-07-01 | CAD | Canada | 6.0 | 1.3030000000000002 | 4.60475825019187 |
4930 | 4930 | 2016-07-01 | CHF | Switzerland | 6.5 | 0.9861 | 6.59162356758949 |
4931 | 4931 | 2016-07-01 | CLP | Chile | 2300.0 | 651.12 | 3.53237498464185 |
4932 | 4932 | 2016-07-01 | CNY | China | 18.6 | 6.678 | 2.7852650494159903 |
4933 | 4933 | 2016-07-01 | COP | Colombia | 8900.0 | 2929.0 | 3.0385797200409703 |
4934 | 4934 | 2016-07-01 | CRC | Costa Rica | 2250.0 | 546.39 | 4.11793773678142 |
4935 | 4935 | 2016-07-01 | CZK | Czech Republic | 75.0 | 24.54655 | 3.0554191933285897 |
4936 | 4936 | 2016-07-01 | DKK | Denmark | 30.0 | 6.75715 | 4.43974160703847 |
4937 | 4937 | 2016-07-01 | EGP | Egypt | 23.0 | 8.87995 | 2.5901046740128 |
4938 | 4938 | 2016-07-01 | EUR | Euro area | 3.82 | 0.908306463 | 4.20562899815015 |
4939 | 4939 | 2016-07-01 | GBP | Britain | 2.99 | 0.758840492 | 3.94022199859098 |
4940 | 4940 | 2016-07-01 | HKD | Hong Kong | 19.2 | 7.7554 | 2.4756943549011 |
4941 | 4941 | 2016-07-01 | HUF | Hungary | 900.0 | 285.6397 | 3.15082252221943 |
4942 | 4942 | 2016-07-01 | IDR | Indonesia | 31000.0 | 13112.5 | 2.36415633937083 |
4943 | 4943 | 2016-07-01 | INR | India | 162.0 | 67.2 | 2.41071428571429 |
4944 | 4944 | 2016-07-01 | ILS | Israel | 16.9 | 3.85875 | 4.37965662455458 |
4945 | 4945 | 2016-07-01 | JPY | Japan | 370.0 | 106.725 | 3.46685406418365 |
4946 | 4946 | 2016-07-01 | KRW | South Korea | 4400.0 | 1140.95 | 3.85643542661817 |
4947 | 4947 | 2016-07-01 | LKR | Sri Lanka | 530.0 | 146.2 | 3.6251709986320098 |
4948 | 4948 | 2016-07-01 | MXN | Mexico | 44.0 | 18.535 | 2.37388724035608 |
4949 | 4949 | 2016-07-01 | MYR | Malaysia | 8.0 | 4.027 | 1.9865905140303 |
4950 | 4950 | 2016-07-01 | NOK | Norway | 46.8 | 8.49355 | 5.51006351878779 |
4951 | 4951 | 2016-07-01 | NZD | New Zealand | 6.0 | 1.4213630869999998 | 4.221300000595839 |
4952 | 4952 | 2016-07-01 | PKR | Pakistan | 375.0 | 104.82 | 3.57756153405839 |
4953 | 4953 | 2016-07-01 | PEN | Peru | 10.0 | 3.30585 | 3.02494063554003 |
4954 | 4954 | 2016-07-01 | PHP | Philippines | 133.0 | 47.115 | 2.82288018677704 |
4955 | 4955 | 2016-07-01 | PLN | Poland | 9.6 | 3.96565 | 2.42078852142776 |
4956 | 4956 | 2016-07-01 | RUB | Russia | 130.0 | 63.40755 | 2.05022903423961 |
4957 | 4957 | 2016-07-01 | SAR | Saudi Arabia | 12.0 | 3.7505 | 3.19957339021464 |
4958 | 4958 | 2016-07-01 | SGD | Singapore | 5.45 | 1.3577 | 4.01414156293732 |
4959 | 4959 | 2016-07-01 | SEK | Sweden | 44.94 | 8.59485 | 5.228712542976321 |
4960 | 4960 | 2016-07-01 | THB | Thailand | 119.0 | 34.965 | 3.4034034034034 |
4961 | 4961 | 2016-07-01 | TRY | Turkey | 10.75 | 3.04305 | 3.53263995005011 |
4962 | 4962 | 2016-07-01 | TWD | Taiwan | 69.0 | 32.029 | 2.1542976677386103 |
4963 | 4963 | 2016-07-01 | UAH | Ukraine | 39.0 | 24.8 | 1.5725806451612905 |
4964 | 4964 | 2016-07-01 | UYU | Uruguay | 123.0 | 30.165 | 4.07757334659373 |
4965 | 4965 | 2016-07-01 | USD | United States | 5.04 | 1.0 | 5.04 |
4966 | 4966 | 2016-07-01 | VND | Vietnam | 60000.0 | 22300.0 | 2.69058295964126 |
4967 | 4967 | 2016-07-01 | ZAR | South Africa | 30.0 | 14.27375 | 2.10176022418776 |
6255 | 6255 | 2016-07-01 | AED | UAE | 13.0 | 3.6731 | 3.5392447796139503 |
6256 | 6256 | 2016-07-01 | ARS | Argentina | 50.0 | 14.935 | 3.3478406427854 |
6257 | 6257 | 2016-07-01 | AUD | Australia | 5.75 | 1.335737661 | 4.3047375003975406 |
6258 | 6258 | 2016-07-01 | BRL | Brazil | 15.5 | 3.24145 | 4.78181060944948 |
6259 | 6259 | 2016-07-01 | CAD | Canada | 6.0 | 1.3030000000000002 | 4.60475825019187 |
6260 | 6260 | 2016-07-01 | CHF | Switzerland | 6.5 | 0.9861 | 6.59162356758949 |
6261 | 6261 | 2016-07-01 | CLP | Chile | 2300.0 | 651.12 | 3.53237498464185 |
6262 | 6262 | 2016-07-01 | CNY | China | 18.6 | 6.678 | 2.7852650494159903 |
6263 | 6263 | 2016-07-01 | COP | Colombia | 8900.0 | 2929.0 | 3.0385797200409703 |
6264 | 6264 | 2016-07-01 | CRC | Costa Rica | 2250.0 | 546.39 | 4.11793773678142 |
6265 | 6265 | 2016-07-01 | CZK | Czech Republic | 75.0 | 24.54655 | 3.0554191933285897 |
6266 | 6266 | 2016-07-01 | DKK | Denmark | 30.0 | 6.75715 | 4.43974160703847 |
6267 | 6267 | 2016-07-01 | EGP | Egypt | 23.0 | 8.87995 | 2.5901046740128 |
6268 | 6268 | 2016-07-01 | EUR | Euro area | 3.82 | 0.908306463 | 4.20562899815015 |
6269 | 6269 | 2016-07-01 | GBP | Britain | 2.99 | 0.758840492 | 3.94022199859098 |
6270 | 6270 | 2016-07-01 | HKD | Hong Kong | 19.2 | 7.7554 | 2.4756943549011 |
6271 | 6271 | 2016-07-01 | HUF | Hungary | 900.0 | 285.6397 | 3.15082252221943 |
6272 | 6272 | 2016-07-01 | IDR | Indonesia | 31000.0 | 13112.5 | 2.36415633937083 |
6273 | 6273 | 2016-07-01 | INR | India | 162.0 | 67.2 | 2.41071428571429 |
6274 | 6274 | 2016-07-01 | ILS | Israel | 16.9 | 3.85875 | 4.37965662455458 |
6275 | 6275 | 2016-07-01 | JPY | Japan | 370.0 | 106.725 | 3.46685406418365 |
6276 | 6276 | 2016-07-01 | KRW | South Korea | 4400.0 | 1140.95 | 3.85643542661817 |
6277 | 6277 | 2016-07-01 | LKR | Sri Lanka | 530.0 | 146.2 | 3.6251709986320098 |
6278 | 6278 | 2016-07-01 | MXN | Mexico | 44.0 | 18.535 | 2.37388724035608 |
6279 | 6279 | 2016-07-01 | MYR | Malaysia | 8.0 | 4.027 | 1.9865905140303 |
6280 | 6280 | 2016-07-01 | NOK | Norway | 46.8 | 8.49355 | 5.51006351878779 |
6281 | 6281 | 2016-07-01 | NZD | New Zealand | 6.0 | 1.4213630869999998 | 4.221300000595839 |
6282 | 6282 | 2016-07-01 | PKR | Pakistan | 375.0 | 104.82 | 3.57756153405839 |
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 );