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 |
---|---|---|---|---|---|---|---|
978 | 978 | 2017-01-01 | AED | UAE | 13.0 | 3.673 | 3.5393411380342994 |
979 | 979 | 2017-01-01 | ARS | Argentina | 55.0 | 15.8575 | 3.4683903515686603 |
980 | 980 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
981 | 981 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
982 | 982 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
983 | 983 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
984 | 984 | 2017-01-01 | CLP | Chile | 2450.0 | 672.805 | 3.64147115434636 |
985 | 985 | 2017-01-01 | CNY | China | 19.6 | 6.9266 | 2.8296711229174503 |
986 | 986 | 2017-01-01 | COP | Colombia | 9900.0 | 2994.625 | 3.30592311224277 |
987 | 987 | 2017-01-01 | CRC | Costa Rica | 2250.0 | 554.33 | 4.058954052640121 |
988 | 988 | 2017-01-01 | CZK | Czech Republic | 75.0 | 25.81175 | 2.90565343302953 |
989 | 989 | 2017-01-01 | DKK | Denmark | 30.0 | 7.10125 | 4.2246083436014805 |
990 | 990 | 2017-01-01 | EGP | Egypt | 27.49 | 18.77 | 1.46457112413426 |
991 | 991 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
992 | 992 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
993 | 993 | 2017-01-01 | HKD | Hong Kong | 19.2 | 7.75595 | 2.47551879524752 |
994 | 994 | 2017-01-01 | HUF | Hungary | 900.0 | 294.6172 | 3.05481146382492 |
995 | 995 | 2017-01-01 | IDR | Indonesia | 31000.0 | 13329.0 | 2.32575587065796 |
996 | 996 | 2017-01-01 | INR | India | 170.0 | 68.3275 | 2.48801726976693 |
997 | 997 | 2017-01-01 | ILS | Israel | 16.9 | 3.855 | 4.38391699092088 |
998 | 998 | 2017-01-01 | JPY | Japan | 380.0 | 116.665 | 3.2571893884198304 |
999 | 999 | 2017-01-01 | KRW | South Korea | 4400.0 | 1196.45 | 3.67754607380166 |
1000 | 1000 | 2017-01-01 | LKR | Sri Lanka | 550.0 | 150.06 | 3.66520058643209 |
1001 | 1001 | 2017-01-01 | MXN | Mexico | 49.0 | 21.9505 | 2.23229539190451 |
1002 | 1002 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
1003 | 1003 | 2017-01-01 | NOK | Norway | 49.0 | 8.64835 | 5.66582064786925 |
1004 | 1004 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
1005 | 1005 | 2017-01-01 | PKR | Pakistan | 375.0 | 104.775 | 3.57909806728704 |
1006 | 1006 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
1007 | 1007 | 2017-01-01 | PHP | Philippines | 133.0 | 49.615 | 2.68064093520105 |
1008 | 1008 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
1009 | 1009 | 2017-01-01 | RUB | Russia | 130.0 | 60.4375 | 2.15098241985522 |
1010 | 1010 | 2017-01-01 | SAR | Saudi Arabia | 12.0 | 3.75065 | 3.19944542945889 |
1011 | 1011 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
1012 | 1012 | 2017-01-01 | SEK | Sweden | 48.0 | 9.12455 | 5.260533396167481 |
1013 | 1013 | 2017-01-01 | THB | Thailand | 119.0 | 35.573 | 3.34523374469401 |
1014 | 1014 | 2017-01-01 | TRY | Turkey | 10.75 | 3.91115 | 2.74855221610012 |
1015 | 1015 | 2017-01-01 | TWD | Taiwan | 69.0 | 31.905 | 2.16267042783263 |
1016 | 1016 | 2017-01-01 | UAH | Ukraine | 42.0 | 27.235 | 1.54213328437672 |
1017 | 1017 | 2017-01-01 | UYU | Uruguay | 125.0 | 28.725 | 4.35161009573542 |
1018 | 1018 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
1019 | 1019 | 2017-01-01 | VND | Vietnam | 60000.0 | 22572.0 | 2.6581605528974 |
1020 | 1020 | 2017-01-01 | ZAR | South Africa | 26.32 | 13.9525 | 1.88640028668697 |
2308 | 2308 | 2017-01-01 | AED | UAE | 13.0 | 3.673 | 3.5393411380342994 |
2309 | 2309 | 2017-01-01 | ARS | Argentina | 55.0 | 15.8575 | 3.4683903515686603 |
2310 | 2310 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
2311 | 2311 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
2312 | 2312 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
2313 | 2313 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
2314 | 2314 | 2017-01-01 | CLP | Chile | 2450.0 | 672.805 | 3.64147115434636 |
2315 | 2315 | 2017-01-01 | CNY | China | 19.6 | 6.9266 | 2.8296711229174503 |
2316 | 2316 | 2017-01-01 | COP | Colombia | 9900.0 | 2994.625 | 3.30592311224277 |
2317 | 2317 | 2017-01-01 | CRC | Costa Rica | 2250.0 | 554.33 | 4.058954052640121 |
2318 | 2318 | 2017-01-01 | CZK | Czech Republic | 75.0 | 25.81175 | 2.90565343302953 |
2319 | 2319 | 2017-01-01 | DKK | Denmark | 30.0 | 7.10125 | 4.2246083436014805 |
2320 | 2320 | 2017-01-01 | EGP | Egypt | 27.49 | 18.77 | 1.46457112413426 |
2321 | 2321 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
2322 | 2322 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
2323 | 2323 | 2017-01-01 | HKD | Hong Kong | 19.2 | 7.75595 | 2.47551879524752 |
2324 | 2324 | 2017-01-01 | HUF | Hungary | 900.0 | 294.6172 | 3.05481146382492 |
2325 | 2325 | 2017-01-01 | IDR | Indonesia | 31000.0 | 13329.0 | 2.32575587065796 |
2326 | 2326 | 2017-01-01 | INR | India | 170.0 | 68.3275 | 2.48801726976693 |
2327 | 2327 | 2017-01-01 | ILS | Israel | 16.9 | 3.855 | 4.38391699092088 |
2328 | 2328 | 2017-01-01 | JPY | Japan | 380.0 | 116.665 | 3.2571893884198304 |
2329 | 2329 | 2017-01-01 | KRW | South Korea | 4400.0 | 1196.45 | 3.67754607380166 |
2330 | 2330 | 2017-01-01 | LKR | Sri Lanka | 550.0 | 150.06 | 3.66520058643209 |
2331 | 2331 | 2017-01-01 | MXN | Mexico | 49.0 | 21.9505 | 2.23229539190451 |
2332 | 2332 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
2333 | 2333 | 2017-01-01 | NOK | Norway | 49.0 | 8.64835 | 5.66582064786925 |
2334 | 2334 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
2335 | 2335 | 2017-01-01 | PKR | Pakistan | 375.0 | 104.775 | 3.57909806728704 |
2336 | 2336 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
2337 | 2337 | 2017-01-01 | PHP | Philippines | 133.0 | 49.615 | 2.68064093520105 |
2338 | 2338 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
2339 | 2339 | 2017-01-01 | RUB | Russia | 130.0 | 60.4375 | 2.15098241985522 |
2340 | 2340 | 2017-01-01 | SAR | Saudi Arabia | 12.0 | 3.75065 | 3.19944542945889 |
2341 | 2341 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
2342 | 2342 | 2017-01-01 | SEK | Sweden | 48.0 | 9.12455 | 5.260533396167481 |
2343 | 2343 | 2017-01-01 | THB | Thailand | 119.0 | 35.573 | 3.34523374469401 |
2344 | 2344 | 2017-01-01 | TRY | Turkey | 10.75 | 3.91115 | 2.74855221610012 |
2345 | 2345 | 2017-01-01 | TWD | Taiwan | 69.0 | 31.905 | 2.16267042783263 |
2346 | 2346 | 2017-01-01 | UAH | Ukraine | 42.0 | 27.235 | 1.54213328437672 |
2347 | 2347 | 2017-01-01 | UYU | Uruguay | 125.0 | 28.725 | 4.35161009573542 |
2348 | 2348 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
2349 | 2349 | 2017-01-01 | VND | Vietnam | 60000.0 | 22572.0 | 2.6581605528974 |
2350 | 2350 | 2017-01-01 | ZAR | South Africa | 26.32 | 13.9525 | 1.88640028668697 |
3638 | 3638 | 2017-01-01 | AED | UAE | 13.0 | 3.673 | 3.5393411380342994 |
3639 | 3639 | 2017-01-01 | ARS | Argentina | 55.0 | 15.8575 | 3.4683903515686603 |
3640 | 3640 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
3641 | 3641 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
3642 | 3642 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
3643 | 3643 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
3644 | 3644 | 2017-01-01 | CLP | Chile | 2450.0 | 672.805 | 3.64147115434636 |
3645 | 3645 | 2017-01-01 | CNY | China | 19.6 | 6.9266 | 2.8296711229174503 |
3646 | 3646 | 2017-01-01 | COP | Colombia | 9900.0 | 2994.625 | 3.30592311224277 |
3647 | 3647 | 2017-01-01 | CRC | Costa Rica | 2250.0 | 554.33 | 4.058954052640121 |
3648 | 3648 | 2017-01-01 | CZK | Czech Republic | 75.0 | 25.81175 | 2.90565343302953 |
3649 | 3649 | 2017-01-01 | DKK | Denmark | 30.0 | 7.10125 | 4.2246083436014805 |
3650 | 3650 | 2017-01-01 | EGP | Egypt | 27.49 | 18.77 | 1.46457112413426 |
3651 | 3651 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
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 );