bigmac
430 rows where "date" is on date 2017-01-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
12990 | 12990 | 2017-01-01 | ZAR | South Africa | 26.32 | 13.9525 | 1.88640028668697 |
12989 | 12989 | 2017-01-01 | VND | Vietnam | 60000.0 | 22572.0 | 2.6581605528974 |
12988 | 12988 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
12987 | 12987 | 2017-01-01 | UYU | Uruguay | 125.0 | 28.725 | 4.35161009573542 |
12986 | 12986 | 2017-01-01 | UAH | Ukraine | 42.0 | 27.235 | 1.54213328437672 |
12985 | 12985 | 2017-01-01 | TWD | Taiwan | 69.0 | 31.905 | 2.16267042783263 |
12984 | 12984 | 2017-01-01 | TRY | Turkey | 10.75 | 3.91115 | 2.74855221610012 |
12983 | 12983 | 2017-01-01 | THB | Thailand | 119.0 | 35.573 | 3.34523374469401 |
12982 | 12982 | 2017-01-01 | SEK | Sweden | 48.0 | 9.12455 | 5.260533396167481 |
12981 | 12981 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
12980 | 12980 | 2017-01-01 | SAR | Saudi Arabia | 12.0 | 3.75065 | 3.19944542945889 |
12979 | 12979 | 2017-01-01 | RUB | Russia | 130.0 | 60.4375 | 2.15098241985522 |
12978 | 12978 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
12977 | 12977 | 2017-01-01 | PHP | Philippines | 133.0 | 49.615 | 2.68064093520105 |
12976 | 12976 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
12975 | 12975 | 2017-01-01 | PKR | Pakistan | 375.0 | 104.775 | 3.57909806728704 |
12974 | 12974 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
12973 | 12973 | 2017-01-01 | NOK | Norway | 49.0 | 8.64835 | 5.66582064786925 |
12972 | 12972 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
12971 | 12971 | 2017-01-01 | MXN | Mexico | 49.0 | 21.9505 | 2.23229539190451 |
12970 | 12970 | 2017-01-01 | LKR | Sri Lanka | 550.0 | 150.06 | 3.66520058643209 |
12969 | 12969 | 2017-01-01 | KRW | South Korea | 4400.0 | 1196.45 | 3.67754607380166 |
12968 | 12968 | 2017-01-01 | JPY | Japan | 380.0 | 116.665 | 3.2571893884198304 |
12967 | 12967 | 2017-01-01 | ILS | Israel | 16.9 | 3.855 | 4.38391699092088 |
12966 | 12966 | 2017-01-01 | INR | India | 170.0 | 68.3275 | 2.48801726976693 |
12965 | 12965 | 2017-01-01 | IDR | Indonesia | 31000.0 | 13329.0 | 2.32575587065796 |
12964 | 12964 | 2017-01-01 | HUF | Hungary | 900.0 | 294.6172 | 3.05481146382492 |
12963 | 12963 | 2017-01-01 | HKD | Hong Kong | 19.2 | 7.75595 | 2.47551879524752 |
12962 | 12962 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
12961 | 12961 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
12960 | 12960 | 2017-01-01 | EGP | Egypt | 27.49 | 18.77 | 1.46457112413426 |
12959 | 12959 | 2017-01-01 | DKK | Denmark | 30.0 | 7.10125 | 4.2246083436014805 |
12958 | 12958 | 2017-01-01 | CZK | Czech Republic | 75.0 | 25.81175 | 2.90565343302953 |
12957 | 12957 | 2017-01-01 | CRC | Costa Rica | 2250.0 | 554.33 | 4.058954052640121 |
12956 | 12956 | 2017-01-01 | COP | Colombia | 9900.0 | 2994.625 | 3.30592311224277 |
12955 | 12955 | 2017-01-01 | CNY | China | 19.6 | 6.9266 | 2.8296711229174503 |
12954 | 12954 | 2017-01-01 | CLP | Chile | 2450.0 | 672.805 | 3.64147115434636 |
12953 | 12953 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
12952 | 12952 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
12951 | 12951 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
12950 | 12950 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
12949 | 12949 | 2017-01-01 | ARS | Argentina | 55.0 | 15.8575 | 3.4683903515686603 |
12948 | 12948 | 2017-01-01 | AED | UAE | 13.0 | 3.673 | 3.5393411380342994 |
11660 | 11660 | 2017-01-01 | ZAR | South Africa | 26.32 | 13.9525 | 1.88640028668697 |
11659 | 11659 | 2017-01-01 | VND | Vietnam | 60000.0 | 22572.0 | 2.6581605528974 |
11658 | 11658 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
11657 | 11657 | 2017-01-01 | UYU | Uruguay | 125.0 | 28.725 | 4.35161009573542 |
11656 | 11656 | 2017-01-01 | UAH | Ukraine | 42.0 | 27.235 | 1.54213328437672 |
11655 | 11655 | 2017-01-01 | TWD | Taiwan | 69.0 | 31.905 | 2.16267042783263 |
11654 | 11654 | 2017-01-01 | TRY | Turkey | 10.75 | 3.91115 | 2.74855221610012 |
11653 | 11653 | 2017-01-01 | THB | Thailand | 119.0 | 35.573 | 3.34523374469401 |
11652 | 11652 | 2017-01-01 | SEK | Sweden | 48.0 | 9.12455 | 5.260533396167481 |
11651 | 11651 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
11650 | 11650 | 2017-01-01 | SAR | Saudi Arabia | 12.0 | 3.75065 | 3.19944542945889 |
11649 | 11649 | 2017-01-01 | RUB | Russia | 130.0 | 60.4375 | 2.15098241985522 |
11648 | 11648 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
11647 | 11647 | 2017-01-01 | PHP | Philippines | 133.0 | 49.615 | 2.68064093520105 |
11646 | 11646 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
11645 | 11645 | 2017-01-01 | PKR | Pakistan | 375.0 | 104.775 | 3.57909806728704 |
11644 | 11644 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
11643 | 11643 | 2017-01-01 | NOK | Norway | 49.0 | 8.64835 | 5.66582064786925 |
11642 | 11642 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
11641 | 11641 | 2017-01-01 | MXN | Mexico | 49.0 | 21.9505 | 2.23229539190451 |
11640 | 11640 | 2017-01-01 | LKR | Sri Lanka | 550.0 | 150.06 | 3.66520058643209 |
11639 | 11639 | 2017-01-01 | KRW | South Korea | 4400.0 | 1196.45 | 3.67754607380166 |
11638 | 11638 | 2017-01-01 | JPY | Japan | 380.0 | 116.665 | 3.2571893884198304 |
11637 | 11637 | 2017-01-01 | ILS | Israel | 16.9 | 3.855 | 4.38391699092088 |
11636 | 11636 | 2017-01-01 | INR | India | 170.0 | 68.3275 | 2.48801726976693 |
11635 | 11635 | 2017-01-01 | IDR | Indonesia | 31000.0 | 13329.0 | 2.32575587065796 |
11634 | 11634 | 2017-01-01 | HUF | Hungary | 900.0 | 294.6172 | 3.05481146382492 |
11633 | 11633 | 2017-01-01 | HKD | Hong Kong | 19.2 | 7.75595 | 2.47551879524752 |
11632 | 11632 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
11631 | 11631 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
11630 | 11630 | 2017-01-01 | EGP | Egypt | 27.49 | 18.77 | 1.46457112413426 |
11629 | 11629 | 2017-01-01 | DKK | Denmark | 30.0 | 7.10125 | 4.2246083436014805 |
11628 | 11628 | 2017-01-01 | CZK | Czech Republic | 75.0 | 25.81175 | 2.90565343302953 |
11627 | 11627 | 2017-01-01 | CRC | Costa Rica | 2250.0 | 554.33 | 4.058954052640121 |
11626 | 11626 | 2017-01-01 | COP | Colombia | 9900.0 | 2994.625 | 3.30592311224277 |
11625 | 11625 | 2017-01-01 | CNY | China | 19.6 | 6.9266 | 2.8296711229174503 |
11624 | 11624 | 2017-01-01 | CLP | Chile | 2450.0 | 672.805 | 3.64147115434636 |
11623 | 11623 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
11622 | 11622 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
11621 | 11621 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
11620 | 11620 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
11619 | 11619 | 2017-01-01 | ARS | Argentina | 55.0 | 15.8575 | 3.4683903515686603 |
11618 | 11618 | 2017-01-01 | AED | UAE | 13.0 | 3.673 | 3.5393411380342994 |
10330 | 10330 | 2017-01-01 | ZAR | South Africa | 26.32 | 13.9525 | 1.88640028668697 |
10329 | 10329 | 2017-01-01 | VND | Vietnam | 60000.0 | 22572.0 | 2.6581605528974 |
10328 | 10328 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
10327 | 10327 | 2017-01-01 | UYU | Uruguay | 125.0 | 28.725 | 4.35161009573542 |
10326 | 10326 | 2017-01-01 | UAH | Ukraine | 42.0 | 27.235 | 1.54213328437672 |
10325 | 10325 | 2017-01-01 | TWD | Taiwan | 69.0 | 31.905 | 2.16267042783263 |
10324 | 10324 | 2017-01-01 | TRY | Turkey | 10.75 | 3.91115 | 2.74855221610012 |
10323 | 10323 | 2017-01-01 | THB | Thailand | 119.0 | 35.573 | 3.34523374469401 |
10322 | 10322 | 2017-01-01 | SEK | Sweden | 48.0 | 9.12455 | 5.260533396167481 |
10321 | 10321 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
10320 | 10320 | 2017-01-01 | SAR | Saudi Arabia | 12.0 | 3.75065 | 3.19944542945889 |
10319 | 10319 | 2017-01-01 | RUB | Russia | 130.0 | 60.4375 | 2.15098241985522 |
10318 | 10318 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
10317 | 10317 | 2017-01-01 | PHP | Philippines | 133.0 | 49.615 | 2.68064093520105 |
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 );