bigmac
430 rows where "date" is on date 2015-07-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
3523 | 3523 | 2015-07-01 | GBP | Britain | 2.89 | 0.640450877 | 4.512446002943019 |
3524 | 3524 | 2015-07-01 | HKD | Hong Kong | 19.2 | 7.7508 | 2.47716364762347 |
3525 | 3525 | 2015-07-01 | HUF | Hungary | 900.0 | 282.8778 | 3.1815858296409303 |
3526 | 3526 | 2015-07-01 | IDR | Indonesia | 30500.0 | 13344.5 | 2.28558582187418 |
3527 | 3527 | 2015-07-01 | INR | India | 116.25 | 63.43 | 1.83272899259026 |
3528 | 3528 | 2015-07-01 | ILS | Israel | 17.5 | 3.77835 | 4.63165138221711 |
3529 | 3529 | 2015-07-01 | JPY | Japan | 370.0 | 123.935 | 2.98543591398717 |
3530 | 3530 | 2015-07-01 | KRW | South Korea | 4300.0 | 1143.5 | 3.76038478355925 |
3531 | 3531 | 2015-07-01 | LKR | Sri Lanka | 350.0 | 133.85 | 2.61486738886814 |
3532 | 3532 | 2015-07-01 | MXN | Mexico | 49.0 | 15.73975 | 3.1131371209835 |
3533 | 3533 | 2015-07-01 | MYR | Malaysia | 7.65 | 3.8065 | 2.00972021542099 |
3534 | 3534 | 2015-07-01 | NOK | Norway | 46.0 | 8.14255 | 5.6493358960031 |
3535 | 3535 | 2015-07-01 | NZD | New Zealand | 5.9 | 1.509092281 | 3.90963499998182 |
3536 | 3536 | 2015-07-01 | PKR | Pakistan | 350.0 | 101.7 | 3.44149459193707 |
3537 | 3537 | 2015-07-01 | PEN | Peru | 10.0 | 3.1835 | 3.14119679597927 |
3538 | 3538 | 2015-07-01 | PHP | Philippines | 163.0 | 45.2125 | 3.6051976776334 |
3539 | 3539 | 2015-07-01 | PLN | Poland | 9.6 | 3.7736 | 2.5439898240407004 |
3540 | 3540 | 2015-07-01 | RUB | Russia | 107.0 | 56.815 | 1.88330546510605 |
3541 | 3541 | 2015-07-01 | SAR | Saudi Arabia | 12.0 | 3.75055 | 3.19953073549213 |
3542 | 3542 | 2015-07-01 | SGD | Singapore | 4.7 | 1.3664 | 3.4396955503512903 |
3543 | 3543 | 2015-07-01 | SEK | Sweden | 43.7 | 8.52265 | 5.127513156119281 |
3544 | 3544 | 2015-07-01 | THB | Thailand | 108.0 | 34.0875 | 3.1683168316831702 |
3545 | 3545 | 2015-07-01 | TRY | Turkey | 10.25 | 2.6457 | 3.8742109838606 |
3546 | 3546 | 2015-07-01 | TWD | Taiwan | 79.0 | 31.02 | 2.5467440361057405 |
3547 | 3547 | 2015-07-01 | UAH | Ukraine | 34.0 | 21.95 | 1.54897494305239 |
3548 | 3548 | 2015-07-01 | UYU | Uruguay | 113.0 | 27.345 | 4.1323825196562405 |
3549 | 3549 | 2015-07-01 | USD | United States | 4.79 | 1.0 | 4.79 |
3550 | 3550 | 2015-07-01 | VND | Vietnam | 60000.0 | 21810.0 | 2.75103163686382 |
3551 | 3551 | 2015-07-01 | ZAR | South Africa | 26.0 | 12.41455 | 2.0943167492982 |
4839 | 4839 | 2015-07-01 | AED | UAE | 13.0 | 3.67295 | 3.53938931921208 |
4840 | 4840 | 2015-07-01 | ARS | Argentina | 28.0 | 9.135 | 3.06513409961686 |
4841 | 4841 | 2015-07-01 | AUD | Australia | 5.3 | 1.35126005 | 3.9222649999901895 |
4842 | 4842 | 2015-07-01 | BRL | Brazil | 13.5 | 3.15235 | 4.28251939029613 |
4843 | 4843 | 2015-07-01 | CAD | Canada | 5.85 | 1.2897 | 4.53593859036985 |
4844 | 4844 | 2015-07-01 | CHF | Switzerland | 6.5 | 0.9528 | 6.82199832073888 |
4845 | 4845 | 2015-07-01 | CLP | Chile | 2100.0 | 642.45 | 3.26873686668223 |
4846 | 4846 | 2015-07-01 | CNY | China | 17.0 | 6.2092 | 2.73787283385943 |
4847 | 4847 | 2015-07-01 | COP | Colombia | 7900.0 | 2708.9 | 2.91631289453284 |
4848 | 4848 | 2015-07-01 | CRC | Costa Rica | 2150.0 | 533.3 | 4.0315019688730604 |
4849 | 4849 | 2015-07-01 | CZK | Czech Republic | 70.0 | 24.70225 | 2.83374996204799 |
4850 | 4850 | 2015-07-01 | DKK | Denmark | 34.59 | 6.81105 | 5.07851212368137 |
4851 | 4851 | 2015-07-01 | EGP | Egypt | 16.93 | 7.83005 | 2.1621828723954497 |
4852 | 4852 | 2015-07-01 | EUR | Euro area | 3.7 | 0.912700224 | 4.05390499827466 |
4853 | 4853 | 2015-07-01 | GBP | Britain | 2.89 | 0.640450877 | 4.512446002943019 |
4854 | 4854 | 2015-07-01 | HKD | Hong Kong | 19.2 | 7.7508 | 2.47716364762347 |
4855 | 4855 | 2015-07-01 | HUF | Hungary | 900.0 | 282.8778 | 3.1815858296409303 |
4856 | 4856 | 2015-07-01 | IDR | Indonesia | 30500.0 | 13344.5 | 2.28558582187418 |
4857 | 4857 | 2015-07-01 | INR | India | 116.25 | 63.43 | 1.83272899259026 |
4858 | 4858 | 2015-07-01 | ILS | Israel | 17.5 | 3.77835 | 4.63165138221711 |
4859 | 4859 | 2015-07-01 | JPY | Japan | 370.0 | 123.935 | 2.98543591398717 |
4860 | 4860 | 2015-07-01 | KRW | South Korea | 4300.0 | 1143.5 | 3.76038478355925 |
4861 | 4861 | 2015-07-01 | LKR | Sri Lanka | 350.0 | 133.85 | 2.61486738886814 |
4862 | 4862 | 2015-07-01 | MXN | Mexico | 49.0 | 15.73975 | 3.1131371209835 |
4863 | 4863 | 2015-07-01 | MYR | Malaysia | 7.65 | 3.8065 | 2.00972021542099 |
4864 | 4864 | 2015-07-01 | NOK | Norway | 46.0 | 8.14255 | 5.6493358960031 |
4865 | 4865 | 2015-07-01 | NZD | New Zealand | 5.9 | 1.509092281 | 3.90963499998182 |
4866 | 4866 | 2015-07-01 | PKR | Pakistan | 350.0 | 101.7 | 3.44149459193707 |
4867 | 4867 | 2015-07-01 | PEN | Peru | 10.0 | 3.1835 | 3.14119679597927 |
4868 | 4868 | 2015-07-01 | PHP | Philippines | 163.0 | 45.2125 | 3.6051976776334 |
4869 | 4869 | 2015-07-01 | PLN | Poland | 9.6 | 3.7736 | 2.5439898240407004 |
4870 | 4870 | 2015-07-01 | RUB | Russia | 107.0 | 56.815 | 1.88330546510605 |
4871 | 4871 | 2015-07-01 | SAR | Saudi Arabia | 12.0 | 3.75055 | 3.19953073549213 |
4872 | 4872 | 2015-07-01 | SGD | Singapore | 4.7 | 1.3664 | 3.4396955503512903 |
4873 | 4873 | 2015-07-01 | SEK | Sweden | 43.7 | 8.52265 | 5.127513156119281 |
4874 | 4874 | 2015-07-01 | THB | Thailand | 108.0 | 34.0875 | 3.1683168316831702 |
4875 | 4875 | 2015-07-01 | TRY | Turkey | 10.25 | 2.6457 | 3.8742109838606 |
4876 | 4876 | 2015-07-01 | TWD | Taiwan | 79.0 | 31.02 | 2.5467440361057405 |
4877 | 4877 | 2015-07-01 | UAH | Ukraine | 34.0 | 21.95 | 1.54897494305239 |
4878 | 4878 | 2015-07-01 | UYU | Uruguay | 113.0 | 27.345 | 4.1323825196562405 |
4879 | 4879 | 2015-07-01 | USD | United States | 4.79 | 1.0 | 4.79 |
4880 | 4880 | 2015-07-01 | VND | Vietnam | 60000.0 | 21810.0 | 2.75103163686382 |
4881 | 4881 | 2015-07-01 | ZAR | South Africa | 26.0 | 12.41455 | 2.0943167492982 |
6169 | 6169 | 2015-07-01 | AED | UAE | 13.0 | 3.67295 | 3.53938931921208 |
6170 | 6170 | 2015-07-01 | ARS | Argentina | 28.0 | 9.135 | 3.06513409961686 |
6171 | 6171 | 2015-07-01 | AUD | Australia | 5.3 | 1.35126005 | 3.9222649999901895 |
6172 | 6172 | 2015-07-01 | BRL | Brazil | 13.5 | 3.15235 | 4.28251939029613 |
6173 | 6173 | 2015-07-01 | CAD | Canada | 5.85 | 1.2897 | 4.53593859036985 |
6174 | 6174 | 2015-07-01 | CHF | Switzerland | 6.5 | 0.9528 | 6.82199832073888 |
6175 | 6175 | 2015-07-01 | CLP | Chile | 2100.0 | 642.45 | 3.26873686668223 |
6176 | 6176 | 2015-07-01 | CNY | China | 17.0 | 6.2092 | 2.73787283385943 |
6177 | 6177 | 2015-07-01 | COP | Colombia | 7900.0 | 2708.9 | 2.91631289453284 |
6178 | 6178 | 2015-07-01 | CRC | Costa Rica | 2150.0 | 533.3 | 4.0315019688730604 |
6179 | 6179 | 2015-07-01 | CZK | Czech Republic | 70.0 | 24.70225 | 2.83374996204799 |
6180 | 6180 | 2015-07-01 | DKK | Denmark | 34.59 | 6.81105 | 5.07851212368137 |
6181 | 6181 | 2015-07-01 | EGP | Egypt | 16.93 | 7.83005 | 2.1621828723954497 |
6182 | 6182 | 2015-07-01 | EUR | Euro area | 3.7 | 0.912700224 | 4.05390499827466 |
6183 | 6183 | 2015-07-01 | GBP | Britain | 2.89 | 0.640450877 | 4.512446002943019 |
6184 | 6184 | 2015-07-01 | HKD | Hong Kong | 19.2 | 7.7508 | 2.47716364762347 |
6185 | 6185 | 2015-07-01 | HUF | Hungary | 900.0 | 282.8778 | 3.1815858296409303 |
6186 | 6186 | 2015-07-01 | IDR | Indonesia | 30500.0 | 13344.5 | 2.28558582187418 |
6187 | 6187 | 2015-07-01 | INR | India | 116.25 | 63.43 | 1.83272899259026 |
6188 | 6188 | 2015-07-01 | ILS | Israel | 17.5 | 3.77835 | 4.63165138221711 |
6189 | 6189 | 2015-07-01 | JPY | Japan | 370.0 | 123.935 | 2.98543591398717 |
6190 | 6190 | 2015-07-01 | KRW | South Korea | 4300.0 | 1143.5 | 3.76038478355925 |
6191 | 6191 | 2015-07-01 | LKR | Sri Lanka | 350.0 | 133.85 | 2.61486738886814 |
6192 | 6192 | 2015-07-01 | MXN | Mexico | 49.0 | 15.73975 | 3.1131371209835 |
6193 | 6193 | 2015-07-01 | MYR | Malaysia | 7.65 | 3.8065 | 2.00972021542099 |
6194 | 6194 | 2015-07-01 | NOK | Norway | 46.0 | 8.14255 | 5.6493358960031 |
6195 | 6195 | 2015-07-01 | NZD | New Zealand | 5.9 | 1.509092281 | 3.90963499998182 |
6196 | 6196 | 2015-07-01 | PKR | Pakistan | 350.0 | 101.7 | 3.44149459193707 |
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 );