bigmac
420 rows where "date" is on date 2013-01-01
This data as json, CSV (advanced)
Suggested facets: currency_code, name, local_price, dollar_ex, dollar_price
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
637 | 637 | 2013-01-01 | AED | UAE | 12.0 | 3.67305 | 3.2670396536938 |
638 | 638 | 2013-01-01 | ARS | Argentina | 19.0 | 4.9765 | 3.81794433839044 |
639 | 639 | 2013-01-01 | AUD | Australia | 4.7 | 0.959094615 | 4.90045499838408 |
640 | 640 | 2013-01-01 | BRL | Brazil | 11.25 | 1.99335 | 5.64376552035518 |
641 | 641 | 2013-01-01 | CAD | Canada | 5.41 | 1.0029 | 5.394356366537041 |
642 | 642 | 2013-01-01 | CHF | Switzerland | 6.5 | 0.9123 | 7.12484928203442 |
643 | 643 | 2013-01-01 | CLP | Chile | 2050.0 | 471.75 | 4.34552199258082 |
644 | 644 | 2013-01-01 | CNY | China | 16.0 | 6.2204 | 2.572181853257029 |
645 | 645 | 2013-01-01 | COP | Colombia | 8600.0 | 1773.175 | 4.85005710096296 |
646 | 646 | 2013-01-01 | CRC | Costa Rica | 2200.0 | 500.83 | 4.39270810454645 |
647 | 647 | 2013-01-01 | CZK | Czech Republic | 70.33 | 18.89495 | 3.72215856617774 |
648 | 648 | 2013-01-01 | DKK | Denmark | 28.5 | 5.49795 | 5.18375030693258 |
649 | 649 | 2013-01-01 | EGP | Egypt | 16.0 | 6.68575 | 2.3931496092435403 |
650 | 650 | 2013-01-01 | EUR | Euro area | 3.594849572 | 0.7369468290000001 | 4.878031128620269 |
651 | 651 | 2013-01-01 | GBP | Britain | 2.69 | 0.633211968 | 4.248182498028839 |
652 | 652 | 2013-01-01 | HKD | Hong Kong | 17.0 | 7.7591 | 2.19097575749765 |
653 | 653 | 2013-01-01 | HUF | Hungary | 830.0 | 217.46935 | 3.81662979173847 |
654 | 654 | 2013-01-01 | IDR | Indonesia | 27939.0 | 9767.5 | 2.86040440235475 |
655 | 655 | 2013-01-01 | INR | India | 89.0 | 53.395 | 1.66682273621126 |
656 | 656 | 2013-01-01 | ILS | Israel | 14.9 | 3.72455 | 4.00048327985931 |
657 | 657 | 2013-01-01 | JPY | Japan | 320.0 | 91.065 | 3.5139735353868105 |
658 | 658 | 2013-01-01 | KRW | South Korea | 3700.0 | 1085.475 | 3.40864598447684 |
659 | 659 | 2013-01-01 | LKR | Sri Lanka | 350.0 | 126.45 | 2.76789244760775 |
660 | 660 | 2013-01-01 | MXN | Mexico | 37.0 | 12.7384 | 2.9046034038811803 |
661 | 661 | 2013-01-01 | MYR | Malaysia | 7.95 | 3.083 | 2.5786571521245496 |
662 | 662 | 2013-01-01 | NOK | Norway | 43.0 | 5.4831 | 7.842279002753919 |
663 | 663 | 2013-01-01 | NZD | New Zealand | 5.2 | 1.202428906 | 4.32458000140592 |
664 | 664 | 2013-01-01 | PKR | Pakistan | 290.0 | 97.665 | 2.96933394767829 |
665 | 665 | 2013-01-01 | PEN | Peru | 10.0 | 2.5595 | 3.90701308849385 |
666 | 666 | 2013-01-01 | PHP | Philippines | 118.0 | 40.6 | 2.9064039408867 |
667 | 667 | 2013-01-01 | PLN | Poland | 9.1 | 3.092 | 2.94307891332471 |
668 | 668 | 2013-01-01 | RUB | Russia | 72.88 | 30.045 | 2.4256947911466096 |
669 | 669 | 2013-01-01 | SAR | Saudi Arabia | 11.0 | 3.7502 | 2.93317689723215 |
670 | 670 | 2013-01-01 | SGD | Singapore | 4.5 | 1.23485 | 3.64416730777017 |
671 | 671 | 2013-01-01 | SEK | Sweden | 40.55930138 | 6.3492 | 6.38809635544636 |
672 | 672 | 2013-01-01 | THB | Thailand | 87.0 | 29.755 | 2.9238783397748302 |
673 | 673 | 2013-01-01 | TRY | Turkey | 8.45 | 1.76875 | 4.7773851590106 |
674 | 674 | 2013-01-01 | TWD | Taiwan | 75.0 | 29.502 | 2.54220052877771 |
675 | 675 | 2013-01-01 | UAH | Ukraine | 19.0 | 8.144 | 2.33300589390963 |
676 | 676 | 2013-01-01 | UYU | Uruguay | 105.0 | 19.28 | 5.44605809128631 |
677 | 677 | 2013-01-01 | USD | United States | 4.367395833 | 1.0 | 4.367395833 |
678 | 678 | 2013-01-01 | ZAR | South Africa | 20.9 | 9.047 | 2.3101580634464502 |
1967 | 1967 | 2013-01-01 | AED | UAE | 12.0 | 3.67305 | 3.2670396536938 |
1968 | 1968 | 2013-01-01 | ARS | Argentina | 19.0 | 4.9765 | 3.81794433839044 |
1969 | 1969 | 2013-01-01 | AUD | Australia | 4.7 | 0.959094615 | 4.90045499838408 |
1970 | 1970 | 2013-01-01 | BRL | Brazil | 11.25 | 1.99335 | 5.64376552035518 |
1971 | 1971 | 2013-01-01 | CAD | Canada | 5.41 | 1.0029 | 5.394356366537041 |
1972 | 1972 | 2013-01-01 | CHF | Switzerland | 6.5 | 0.9123 | 7.12484928203442 |
1973 | 1973 | 2013-01-01 | CLP | Chile | 2050.0 | 471.75 | 4.34552199258082 |
1974 | 1974 | 2013-01-01 | CNY | China | 16.0 | 6.2204 | 2.572181853257029 |
1975 | 1975 | 2013-01-01 | COP | Colombia | 8600.0 | 1773.175 | 4.85005710096296 |
1976 | 1976 | 2013-01-01 | CRC | Costa Rica | 2200.0 | 500.83 | 4.39270810454645 |
1977 | 1977 | 2013-01-01 | CZK | Czech Republic | 70.33 | 18.89495 | 3.72215856617774 |
1978 | 1978 | 2013-01-01 | DKK | Denmark | 28.5 | 5.49795 | 5.18375030693258 |
1979 | 1979 | 2013-01-01 | EGP | Egypt | 16.0 | 6.68575 | 2.3931496092435403 |
1980 | 1980 | 2013-01-01 | EUR | Euro area | 3.594849572 | 0.7369468290000001 | 4.878031128620269 |
1981 | 1981 | 2013-01-01 | GBP | Britain | 2.69 | 0.633211968 | 4.248182498028839 |
1982 | 1982 | 2013-01-01 | HKD | Hong Kong | 17.0 | 7.7591 | 2.19097575749765 |
1983 | 1983 | 2013-01-01 | HUF | Hungary | 830.0 | 217.46935 | 3.81662979173847 |
1984 | 1984 | 2013-01-01 | IDR | Indonesia | 27939.0 | 9767.5 | 2.86040440235475 |
1985 | 1985 | 2013-01-01 | INR | India | 89.0 | 53.395 | 1.66682273621126 |
1986 | 1986 | 2013-01-01 | ILS | Israel | 14.9 | 3.72455 | 4.00048327985931 |
1987 | 1987 | 2013-01-01 | JPY | Japan | 320.0 | 91.065 | 3.5139735353868105 |
1988 | 1988 | 2013-01-01 | KRW | South Korea | 3700.0 | 1085.475 | 3.40864598447684 |
1989 | 1989 | 2013-01-01 | LKR | Sri Lanka | 350.0 | 126.45 | 2.76789244760775 |
1990 | 1990 | 2013-01-01 | MXN | Mexico | 37.0 | 12.7384 | 2.9046034038811803 |
1991 | 1991 | 2013-01-01 | MYR | Malaysia | 7.95 | 3.083 | 2.5786571521245496 |
1992 | 1992 | 2013-01-01 | NOK | Norway | 43.0 | 5.4831 | 7.842279002753919 |
1993 | 1993 | 2013-01-01 | NZD | New Zealand | 5.2 | 1.202428906 | 4.32458000140592 |
1994 | 1994 | 2013-01-01 | PKR | Pakistan | 290.0 | 97.665 | 2.96933394767829 |
1995 | 1995 | 2013-01-01 | PEN | Peru | 10.0 | 2.5595 | 3.90701308849385 |
1996 | 1996 | 2013-01-01 | PHP | Philippines | 118.0 | 40.6 | 2.9064039408867 |
1997 | 1997 | 2013-01-01 | PLN | Poland | 9.1 | 3.092 | 2.94307891332471 |
1998 | 1998 | 2013-01-01 | RUB | Russia | 72.88 | 30.045 | 2.4256947911466096 |
1999 | 1999 | 2013-01-01 | SAR | Saudi Arabia | 11.0 | 3.7502 | 2.93317689723215 |
2000 | 2000 | 2013-01-01 | SGD | Singapore | 4.5 | 1.23485 | 3.64416730777017 |
2001 | 2001 | 2013-01-01 | SEK | Sweden | 40.55930138 | 6.3492 | 6.38809635544636 |
2002 | 2002 | 2013-01-01 | THB | Thailand | 87.0 | 29.755 | 2.9238783397748302 |
2003 | 2003 | 2013-01-01 | TRY | Turkey | 8.45 | 1.76875 | 4.7773851590106 |
2004 | 2004 | 2013-01-01 | TWD | Taiwan | 75.0 | 29.502 | 2.54220052877771 |
2005 | 2005 | 2013-01-01 | UAH | Ukraine | 19.0 | 8.144 | 2.33300589390963 |
2006 | 2006 | 2013-01-01 | UYU | Uruguay | 105.0 | 19.28 | 5.44605809128631 |
2007 | 2007 | 2013-01-01 | USD | United States | 4.367395833 | 1.0 | 4.367395833 |
2008 | 2008 | 2013-01-01 | ZAR | South Africa | 20.9 | 9.047 | 2.3101580634464502 |
3297 | 3297 | 2013-01-01 | AED | UAE | 12.0 | 3.67305 | 3.2670396536938 |
3298 | 3298 | 2013-01-01 | ARS | Argentina | 19.0 | 4.9765 | 3.81794433839044 |
3299 | 3299 | 2013-01-01 | AUD | Australia | 4.7 | 0.959094615 | 4.90045499838408 |
3300 | 3300 | 2013-01-01 | BRL | Brazil | 11.25 | 1.99335 | 5.64376552035518 |
3301 | 3301 | 2013-01-01 | CAD | Canada | 5.41 | 1.0029 | 5.394356366537041 |
3302 | 3302 | 2013-01-01 | CHF | Switzerland | 6.5 | 0.9123 | 7.12484928203442 |
3303 | 3303 | 2013-01-01 | CLP | Chile | 2050.0 | 471.75 | 4.34552199258082 |
3304 | 3304 | 2013-01-01 | CNY | China | 16.0 | 6.2204 | 2.572181853257029 |
3305 | 3305 | 2013-01-01 | COP | Colombia | 8600.0 | 1773.175 | 4.85005710096296 |
3306 | 3306 | 2013-01-01 | CRC | Costa Rica | 2200.0 | 500.83 | 4.39270810454645 |
3307 | 3307 | 2013-01-01 | CZK | Czech Republic | 70.33 | 18.89495 | 3.72215856617774 |
3308 | 3308 | 2013-01-01 | DKK | Denmark | 28.5 | 5.49795 | 5.18375030693258 |
3309 | 3309 | 2013-01-01 | EGP | Egypt | 16.0 | 6.68575 | 2.3931496092435403 |
3310 | 3310 | 2013-01-01 | EUR | Euro area | 3.594849572 | 0.7369468290000001 | 4.878031128620269 |
3311 | 3311 | 2013-01-01 | GBP | Britain | 2.69 | 0.633211968 | 4.248182498028839 |
3312 | 3312 | 2013-01-01 | HKD | Hong Kong | 17.0 | 7.7591 | 2.19097575749765 |
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 );