bigmac
430 rows where "date" is on date 2017-01-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
3652 | 3652 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
3653 | 3653 | 2017-01-01 | HKD | Hong Kong | 19.2 | 7.75595 | 2.47551879524752 |
3654 | 3654 | 2017-01-01 | HUF | Hungary | 900.0 | 294.6172 | 3.05481146382492 |
3655 | 3655 | 2017-01-01 | IDR | Indonesia | 31000.0 | 13329.0 | 2.32575587065796 |
3656 | 3656 | 2017-01-01 | INR | India | 170.0 | 68.3275 | 2.48801726976693 |
3657 | 3657 | 2017-01-01 | ILS | Israel | 16.9 | 3.855 | 4.38391699092088 |
3658 | 3658 | 2017-01-01 | JPY | Japan | 380.0 | 116.665 | 3.2571893884198304 |
3659 | 3659 | 2017-01-01 | KRW | South Korea | 4400.0 | 1196.45 | 3.67754607380166 |
3660 | 3660 | 2017-01-01 | LKR | Sri Lanka | 550.0 | 150.06 | 3.66520058643209 |
3661 | 3661 | 2017-01-01 | MXN | Mexico | 49.0 | 21.9505 | 2.23229539190451 |
3662 | 3662 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
3663 | 3663 | 2017-01-01 | NOK | Norway | 49.0 | 8.64835 | 5.66582064786925 |
3664 | 3664 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
3665 | 3665 | 2017-01-01 | PKR | Pakistan | 375.0 | 104.775 | 3.57909806728704 |
3666 | 3666 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
3667 | 3667 | 2017-01-01 | PHP | Philippines | 133.0 | 49.615 | 2.68064093520105 |
3668 | 3668 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
3669 | 3669 | 2017-01-01 | RUB | Russia | 130.0 | 60.4375 | 2.15098241985522 |
3670 | 3670 | 2017-01-01 | SAR | Saudi Arabia | 12.0 | 3.75065 | 3.19944542945889 |
3671 | 3671 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
3672 | 3672 | 2017-01-01 | SEK | Sweden | 48.0 | 9.12455 | 5.260533396167481 |
3673 | 3673 | 2017-01-01 | THB | Thailand | 119.0 | 35.573 | 3.34523374469401 |
3674 | 3674 | 2017-01-01 | TRY | Turkey | 10.75 | 3.91115 | 2.74855221610012 |
3675 | 3675 | 2017-01-01 | TWD | Taiwan | 69.0 | 31.905 | 2.16267042783263 |
3676 | 3676 | 2017-01-01 | UAH | Ukraine | 42.0 | 27.235 | 1.54213328437672 |
3677 | 3677 | 2017-01-01 | UYU | Uruguay | 125.0 | 28.725 | 4.35161009573542 |
3678 | 3678 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
3679 | 3679 | 2017-01-01 | VND | Vietnam | 60000.0 | 22572.0 | 2.6581605528974 |
3680 | 3680 | 2017-01-01 | ZAR | South Africa | 26.32 | 13.9525 | 1.88640028668697 |
4968 | 4968 | 2017-01-01 | AED | UAE | 13.0 | 3.673 | 3.5393411380342994 |
4969 | 4969 | 2017-01-01 | ARS | Argentina | 55.0 | 15.8575 | 3.4683903515686603 |
4970 | 4970 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
4971 | 4971 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
4972 | 4972 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
4973 | 4973 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
4974 | 4974 | 2017-01-01 | CLP | Chile | 2450.0 | 672.805 | 3.64147115434636 |
4975 | 4975 | 2017-01-01 | CNY | China | 19.6 | 6.9266 | 2.8296711229174503 |
4976 | 4976 | 2017-01-01 | COP | Colombia | 9900.0 | 2994.625 | 3.30592311224277 |
4977 | 4977 | 2017-01-01 | CRC | Costa Rica | 2250.0 | 554.33 | 4.058954052640121 |
4978 | 4978 | 2017-01-01 | CZK | Czech Republic | 75.0 | 25.81175 | 2.90565343302953 |
4979 | 4979 | 2017-01-01 | DKK | Denmark | 30.0 | 7.10125 | 4.2246083436014805 |
4980 | 4980 | 2017-01-01 | EGP | Egypt | 27.49 | 18.77 | 1.46457112413426 |
4981 | 4981 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
4982 | 4982 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
4983 | 4983 | 2017-01-01 | HKD | Hong Kong | 19.2 | 7.75595 | 2.47551879524752 |
4984 | 4984 | 2017-01-01 | HUF | Hungary | 900.0 | 294.6172 | 3.05481146382492 |
4985 | 4985 | 2017-01-01 | IDR | Indonesia | 31000.0 | 13329.0 | 2.32575587065796 |
4986 | 4986 | 2017-01-01 | INR | India | 170.0 | 68.3275 | 2.48801726976693 |
4987 | 4987 | 2017-01-01 | ILS | Israel | 16.9 | 3.855 | 4.38391699092088 |
4988 | 4988 | 2017-01-01 | JPY | Japan | 380.0 | 116.665 | 3.2571893884198304 |
4989 | 4989 | 2017-01-01 | KRW | South Korea | 4400.0 | 1196.45 | 3.67754607380166 |
4990 | 4990 | 2017-01-01 | LKR | Sri Lanka | 550.0 | 150.06 | 3.66520058643209 |
4991 | 4991 | 2017-01-01 | MXN | Mexico | 49.0 | 21.9505 | 2.23229539190451 |
4992 | 4992 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
4993 | 4993 | 2017-01-01 | NOK | Norway | 49.0 | 8.64835 | 5.66582064786925 |
4994 | 4994 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
4995 | 4995 | 2017-01-01 | PKR | Pakistan | 375.0 | 104.775 | 3.57909806728704 |
4996 | 4996 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
4997 | 4997 | 2017-01-01 | PHP | Philippines | 133.0 | 49.615 | 2.68064093520105 |
4998 | 4998 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
4999 | 4999 | 2017-01-01 | RUB | Russia | 130.0 | 60.4375 | 2.15098241985522 |
5000 | 5000 | 2017-01-01 | SAR | Saudi Arabia | 12.0 | 3.75065 | 3.19944542945889 |
5001 | 5001 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
5002 | 5002 | 2017-01-01 | SEK | Sweden | 48.0 | 9.12455 | 5.260533396167481 |
5003 | 5003 | 2017-01-01 | THB | Thailand | 119.0 | 35.573 | 3.34523374469401 |
5004 | 5004 | 2017-01-01 | TRY | Turkey | 10.75 | 3.91115 | 2.74855221610012 |
5005 | 5005 | 2017-01-01 | TWD | Taiwan | 69.0 | 31.905 | 2.16267042783263 |
5006 | 5006 | 2017-01-01 | UAH | Ukraine | 42.0 | 27.235 | 1.54213328437672 |
5007 | 5007 | 2017-01-01 | UYU | Uruguay | 125.0 | 28.725 | 4.35161009573542 |
5008 | 5008 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
5009 | 5009 | 2017-01-01 | VND | Vietnam | 60000.0 | 22572.0 | 2.6581605528974 |
5010 | 5010 | 2017-01-01 | ZAR | South Africa | 26.32 | 13.9525 | 1.88640028668697 |
6298 | 6298 | 2017-01-01 | AED | UAE | 13.0 | 3.673 | 3.5393411380342994 |
6299 | 6299 | 2017-01-01 | ARS | Argentina | 55.0 | 15.8575 | 3.4683903515686603 |
6300 | 6300 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
6301 | 6301 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
6302 | 6302 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
6303 | 6303 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
6304 | 6304 | 2017-01-01 | CLP | Chile | 2450.0 | 672.805 | 3.64147115434636 |
6305 | 6305 | 2017-01-01 | CNY | China | 19.6 | 6.9266 | 2.8296711229174503 |
6306 | 6306 | 2017-01-01 | COP | Colombia | 9900.0 | 2994.625 | 3.30592311224277 |
6307 | 6307 | 2017-01-01 | CRC | Costa Rica | 2250.0 | 554.33 | 4.058954052640121 |
6308 | 6308 | 2017-01-01 | CZK | Czech Republic | 75.0 | 25.81175 | 2.90565343302953 |
6309 | 6309 | 2017-01-01 | DKK | Denmark | 30.0 | 7.10125 | 4.2246083436014805 |
6310 | 6310 | 2017-01-01 | EGP | Egypt | 27.49 | 18.77 | 1.46457112413426 |
6311 | 6311 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
6312 | 6312 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
6313 | 6313 | 2017-01-01 | HKD | Hong Kong | 19.2 | 7.75595 | 2.47551879524752 |
6314 | 6314 | 2017-01-01 | HUF | Hungary | 900.0 | 294.6172 | 3.05481146382492 |
6315 | 6315 | 2017-01-01 | IDR | Indonesia | 31000.0 | 13329.0 | 2.32575587065796 |
6316 | 6316 | 2017-01-01 | INR | India | 170.0 | 68.3275 | 2.48801726976693 |
6317 | 6317 | 2017-01-01 | ILS | Israel | 16.9 | 3.855 | 4.38391699092088 |
6318 | 6318 | 2017-01-01 | JPY | Japan | 380.0 | 116.665 | 3.2571893884198304 |
6319 | 6319 | 2017-01-01 | KRW | South Korea | 4400.0 | 1196.45 | 3.67754607380166 |
6320 | 6320 | 2017-01-01 | LKR | Sri Lanka | 550.0 | 150.06 | 3.66520058643209 |
6321 | 6321 | 2017-01-01 | MXN | Mexico | 49.0 | 21.9505 | 2.23229539190451 |
6322 | 6322 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
6323 | 6323 | 2017-01-01 | NOK | Norway | 49.0 | 8.64835 | 5.66582064786925 |
6324 | 6324 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
6325 | 6325 | 2017-01-01 | PKR | Pakistan | 375.0 | 104.775 | 3.57909806728704 |
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 );