bigmac
400 rows where "date" is on date 2012-07-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
3277 | 3277 | 2012-07-01 | KRW | South Korea | 3700.0 | 1151.0 | 3.2145960034752403 |
3278 | 3278 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
3279 | 3279 | 2012-07-01 | MXN | Mexico | 37.0 | 13.687 | 2.70329509753781 |
3280 | 3280 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
3281 | 3281 | 2012-07-01 | NOK | Norway | 43.0 | 6.09205 | 7.05837936326852 |
3282 | 3282 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
3283 | 3283 | 2012-07-01 | PKR | Pakistan | 285.0 | 94.605 | 3.01252576502299 |
3284 | 3284 | 2012-07-01 | PHP | Philippines | 118.0 | 42.2 | 2.7962085308056897 |
3285 | 3285 | 2012-07-01 | PLN | Poland | 9.1 | 3.46035 | 2.6297917840680896 |
3286 | 3286 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
3287 | 3287 | 2012-07-01 | SAR | Saudi Arabia | 10.0 | 3.75025 | 2.6664889007399504 |
3288 | 3288 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
3289 | 3289 | 2012-07-01 | SEK | Sweden | 39.97301987 | 6.9777 | 5.72868135202144 |
3290 | 3290 | 2012-07-01 | THB | Thailand | 82.0 | 31.7 | 2.58675078864353 |
3291 | 3291 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
3292 | 3292 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
3293 | 3293 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
3294 | 3294 | 2012-07-01 | UYU | Uruguay | 99.0 | 21.87 | 4.52674897119342 |
3295 | 3295 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
3296 | 3296 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
4587 | 4587 | 2012-07-01 | AED | UAE | 12.0 | 3.67295 | 3.26712860234961 |
4588 | 4588 | 2012-07-01 | ARS | Argentina | 19.0 | 4.56625 | 4.16096359156857 |
4589 | 4589 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
4590 | 4590 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
4591 | 4591 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
4592 | 4592 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
4593 | 4593 | 2012-07-01 | CLP | Chile | 2050.0 | 493.05 | 4.15779332724876 |
4594 | 4594 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
4595 | 4595 | 2012-07-01 | COP | Colombia | 8600.0 | 1804.475 | 4.76592914836725 |
4596 | 4596 | 2012-07-01 | CZK | Czech Republic | 70.33 | 21.048 | 3.34141011022425 |
4597 | 4597 | 2012-07-01 | DKK | Denmark | 28.5 | 6.1356 | 4.6450224916878495 |
4598 | 4598 | 2012-07-01 | EGP | Egypt | 16.0 | 6.0665 | 2.63743509437072 |
4599 | 4599 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
4600 | 4600 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
4601 | 4601 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
4602 | 4602 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
4603 | 4603 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
4604 | 4604 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
4605 | 4605 | 2012-07-01 | ILS | Israel | 11.9 | 4.07625 | 2.91934989267096 |
4606 | 4606 | 2012-07-01 | JPY | Japan | 320.0 | 78.22 | 4.09102531321913 |
4607 | 4607 | 2012-07-01 | KRW | South Korea | 3700.0 | 1151.0 | 3.2145960034752403 |
4608 | 4608 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
4609 | 4609 | 2012-07-01 | MXN | Mexico | 37.0 | 13.687 | 2.70329509753781 |
4610 | 4610 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
4611 | 4611 | 2012-07-01 | NOK | Norway | 43.0 | 6.09205 | 7.05837936326852 |
4612 | 4612 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
4613 | 4613 | 2012-07-01 | PKR | Pakistan | 285.0 | 94.605 | 3.01252576502299 |
4614 | 4614 | 2012-07-01 | PHP | Philippines | 118.0 | 42.2 | 2.7962085308056897 |
4615 | 4615 | 2012-07-01 | PLN | Poland | 9.1 | 3.46035 | 2.6297917840680896 |
4616 | 4616 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
4617 | 4617 | 2012-07-01 | SAR | Saudi Arabia | 10.0 | 3.75025 | 2.6664889007399504 |
4618 | 4618 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
4619 | 4619 | 2012-07-01 | SEK | Sweden | 39.97301987 | 6.9777 | 5.72868135202144 |
4620 | 4620 | 2012-07-01 | THB | Thailand | 82.0 | 31.7 | 2.58675078864353 |
4621 | 4621 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
4622 | 4622 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
4623 | 4623 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
4624 | 4624 | 2012-07-01 | UYU | Uruguay | 99.0 | 21.87 | 4.52674897119342 |
4625 | 4625 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
4626 | 4626 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
5917 | 5917 | 2012-07-01 | AED | UAE | 12.0 | 3.67295 | 3.26712860234961 |
5918 | 5918 | 2012-07-01 | ARS | Argentina | 19.0 | 4.56625 | 4.16096359156857 |
5919 | 5919 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
5920 | 5920 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
5921 | 5921 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
5922 | 5922 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
5923 | 5923 | 2012-07-01 | CLP | Chile | 2050.0 | 493.05 | 4.15779332724876 |
5924 | 5924 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
5925 | 5925 | 2012-07-01 | COP | Colombia | 8600.0 | 1804.475 | 4.76592914836725 |
5926 | 5926 | 2012-07-01 | CZK | Czech Republic | 70.33 | 21.048 | 3.34141011022425 |
5927 | 5927 | 2012-07-01 | DKK | Denmark | 28.5 | 6.1356 | 4.6450224916878495 |
5928 | 5928 | 2012-07-01 | EGP | Egypt | 16.0 | 6.0665 | 2.63743509437072 |
5929 | 5929 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
5930 | 5930 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
5931 | 5931 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
5932 | 5932 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
5933 | 5933 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
5934 | 5934 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
5935 | 5935 | 2012-07-01 | ILS | Israel | 11.9 | 4.07625 | 2.91934989267096 |
5936 | 5936 | 2012-07-01 | JPY | Japan | 320.0 | 78.22 | 4.09102531321913 |
5937 | 5937 | 2012-07-01 | KRW | South Korea | 3700.0 | 1151.0 | 3.2145960034752403 |
5938 | 5938 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
5939 | 5939 | 2012-07-01 | MXN | Mexico | 37.0 | 13.687 | 2.70329509753781 |
5940 | 5940 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
5941 | 5941 | 2012-07-01 | NOK | Norway | 43.0 | 6.09205 | 7.05837936326852 |
5942 | 5942 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
5943 | 5943 | 2012-07-01 | PKR | Pakistan | 285.0 | 94.605 | 3.01252576502299 |
5944 | 5944 | 2012-07-01 | PHP | Philippines | 118.0 | 42.2 | 2.7962085308056897 |
5945 | 5945 | 2012-07-01 | PLN | Poland | 9.1 | 3.46035 | 2.6297917840680896 |
5946 | 5946 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
5947 | 5947 | 2012-07-01 | SAR | Saudi Arabia | 10.0 | 3.75025 | 2.6664889007399504 |
5948 | 5948 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
5949 | 5949 | 2012-07-01 | SEK | Sweden | 39.97301987 | 6.9777 | 5.72868135202144 |
5950 | 5950 | 2012-07-01 | THB | Thailand | 82.0 | 31.7 | 2.58675078864353 |
5951 | 5951 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
5952 | 5952 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
5953 | 5953 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
5954 | 5954 | 2012-07-01 | UYU | Uruguay | 99.0 | 21.87 | 4.52674897119342 |
5955 | 5955 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
5956 | 5956 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
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 );