bigmac
400 rows where "date" is on date 2012-07-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
597 | 597 | 2012-07-01 | AED | UAE | 12.0 | 3.67295 | 3.26712860234961 |
598 | 598 | 2012-07-01 | ARS | Argentina | 19.0 | 4.56625 | 4.16096359156857 |
599 | 599 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
600 | 600 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
601 | 601 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
602 | 602 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
603 | 603 | 2012-07-01 | CLP | Chile | 2050.0 | 493.05 | 4.15779332724876 |
604 | 604 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
605 | 605 | 2012-07-01 | COP | Colombia | 8600.0 | 1804.475 | 4.76592914836725 |
606 | 606 | 2012-07-01 | CZK | Czech Republic | 70.33 | 21.048 | 3.34141011022425 |
607 | 607 | 2012-07-01 | DKK | Denmark | 28.5 | 6.1356 | 4.6450224916878495 |
608 | 608 | 2012-07-01 | EGP | Egypt | 16.0 | 6.0665 | 2.63743509437072 |
609 | 609 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
610 | 610 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
611 | 611 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
612 | 612 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
613 | 613 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
614 | 614 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
615 | 615 | 2012-07-01 | ILS | Israel | 11.9 | 4.07625 | 2.91934989267096 |
616 | 616 | 2012-07-01 | JPY | Japan | 320.0 | 78.22 | 4.09102531321913 |
617 | 617 | 2012-07-01 | KRW | South Korea | 3700.0 | 1151.0 | 3.2145960034752403 |
618 | 618 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
619 | 619 | 2012-07-01 | MXN | Mexico | 37.0 | 13.687 | 2.70329509753781 |
620 | 620 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
621 | 621 | 2012-07-01 | NOK | Norway | 43.0 | 6.09205 | 7.05837936326852 |
622 | 622 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
623 | 623 | 2012-07-01 | PKR | Pakistan | 285.0 | 94.605 | 3.01252576502299 |
624 | 624 | 2012-07-01 | PHP | Philippines | 118.0 | 42.2 | 2.7962085308056897 |
625 | 625 | 2012-07-01 | PLN | Poland | 9.1 | 3.46035 | 2.6297917840680896 |
626 | 626 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
627 | 627 | 2012-07-01 | SAR | Saudi Arabia | 10.0 | 3.75025 | 2.6664889007399504 |
628 | 628 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
629 | 629 | 2012-07-01 | SEK | Sweden | 39.97301987 | 6.9777 | 5.72868135202144 |
630 | 630 | 2012-07-01 | THB | Thailand | 82.0 | 31.7 | 2.58675078864353 |
631 | 631 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
632 | 632 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
633 | 633 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
634 | 634 | 2012-07-01 | UYU | Uruguay | 99.0 | 21.87 | 4.52674897119342 |
635 | 635 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
636 | 636 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
1927 | 1927 | 2012-07-01 | AED | UAE | 12.0 | 3.67295 | 3.26712860234961 |
1928 | 1928 | 2012-07-01 | ARS | Argentina | 19.0 | 4.56625 | 4.16096359156857 |
1929 | 1929 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
1930 | 1930 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
1931 | 1931 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
1932 | 1932 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
1933 | 1933 | 2012-07-01 | CLP | Chile | 2050.0 | 493.05 | 4.15779332724876 |
1934 | 1934 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
1935 | 1935 | 2012-07-01 | COP | Colombia | 8600.0 | 1804.475 | 4.76592914836725 |
1936 | 1936 | 2012-07-01 | CZK | Czech Republic | 70.33 | 21.048 | 3.34141011022425 |
1937 | 1937 | 2012-07-01 | DKK | Denmark | 28.5 | 6.1356 | 4.6450224916878495 |
1938 | 1938 | 2012-07-01 | EGP | Egypt | 16.0 | 6.0665 | 2.63743509437072 |
1939 | 1939 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
1940 | 1940 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
1941 | 1941 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
1942 | 1942 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
1943 | 1943 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
1944 | 1944 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
1945 | 1945 | 2012-07-01 | ILS | Israel | 11.9 | 4.07625 | 2.91934989267096 |
1946 | 1946 | 2012-07-01 | JPY | Japan | 320.0 | 78.22 | 4.09102531321913 |
1947 | 1947 | 2012-07-01 | KRW | South Korea | 3700.0 | 1151.0 | 3.2145960034752403 |
1948 | 1948 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
1949 | 1949 | 2012-07-01 | MXN | Mexico | 37.0 | 13.687 | 2.70329509753781 |
1950 | 1950 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
1951 | 1951 | 2012-07-01 | NOK | Norway | 43.0 | 6.09205 | 7.05837936326852 |
1952 | 1952 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
1953 | 1953 | 2012-07-01 | PKR | Pakistan | 285.0 | 94.605 | 3.01252576502299 |
1954 | 1954 | 2012-07-01 | PHP | Philippines | 118.0 | 42.2 | 2.7962085308056897 |
1955 | 1955 | 2012-07-01 | PLN | Poland | 9.1 | 3.46035 | 2.6297917840680896 |
1956 | 1956 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
1957 | 1957 | 2012-07-01 | SAR | Saudi Arabia | 10.0 | 3.75025 | 2.6664889007399504 |
1958 | 1958 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
1959 | 1959 | 2012-07-01 | SEK | Sweden | 39.97301987 | 6.9777 | 5.72868135202144 |
1960 | 1960 | 2012-07-01 | THB | Thailand | 82.0 | 31.7 | 2.58675078864353 |
1961 | 1961 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
1962 | 1962 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
1963 | 1963 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
1964 | 1964 | 2012-07-01 | UYU | Uruguay | 99.0 | 21.87 | 4.52674897119342 |
1965 | 1965 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
1966 | 1966 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
3257 | 3257 | 2012-07-01 | AED | UAE | 12.0 | 3.67295 | 3.26712860234961 |
3258 | 3258 | 2012-07-01 | ARS | Argentina | 19.0 | 4.56625 | 4.16096359156857 |
3259 | 3259 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
3260 | 3260 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
3261 | 3261 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
3262 | 3262 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
3263 | 3263 | 2012-07-01 | CLP | Chile | 2050.0 | 493.05 | 4.15779332724876 |
3264 | 3264 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
3265 | 3265 | 2012-07-01 | COP | Colombia | 8600.0 | 1804.475 | 4.76592914836725 |
3266 | 3266 | 2012-07-01 | CZK | Czech Republic | 70.33 | 21.048 | 3.34141011022425 |
3267 | 3267 | 2012-07-01 | DKK | Denmark | 28.5 | 6.1356 | 4.6450224916878495 |
3268 | 3268 | 2012-07-01 | EGP | Egypt | 16.0 | 6.0665 | 2.63743509437072 |
3269 | 3269 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
3270 | 3270 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
3271 | 3271 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
3272 | 3272 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
3273 | 3273 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
3274 | 3274 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
3275 | 3275 | 2012-07-01 | ILS | Israel | 11.9 | 4.07625 | 2.91934989267096 |
3276 | 3276 | 2012-07-01 | JPY | Japan | 320.0 | 78.22 | 4.09102531321913 |
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 );