bigmac
420 rows where "date" is on date 2012-01-01 sorted by date
This data as json, CSV (advanced)
Link | rowid | date ▼ | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
555 | 555 | 2012-01-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
556 | 556 | 2012-01-01 | ARS | Argentina | 20.0 | 4.3135 | 4.63660600440478 |
557 | 557 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
558 | 558 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
559 | 559 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
560 | 560 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
561 | 561 | 2012-01-01 | CLP | Chile | 2050.0 | 506.05 | 4.0509831044363205 |
562 | 562 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
563 | 563 | 2012-01-01 | COP | Colombia | 8400.0 | 1852.15 | 4.535269821558731 |
564 | 564 | 2012-01-01 | CRC | Costa Rica | 2050.0 | 509.54 | 4.02323664481689 |
565 | 565 | 2012-01-01 | CZK | Czech Republic | 70.22 | 20.36535 | 3.44801341494254 |
566 | 566 | 2012-01-01 | DKK | Denmark | 31.5 | 5.86135 | 5.374188540182719 |
567 | 567 | 2012-01-01 | EGP | Egypt | 15.5 | 6.037000000000001 | 2.56750041411297 |
568 | 568 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
569 | 569 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
570 | 570 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
571 | 571 | 2012-01-01 | HUF | Hungary | 645.0 | 245.69425 | 2.6252140617861404 |
572 | 572 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
573 | 573 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
574 | 574 | 2012-01-01 | ILS | Israel | 15.9 | 3.8485 | 4.13147979732363 |
575 | 575 | 2012-01-01 | JPY | Japan | 320.0 | 76.92 | 4.16016640665627 |
576 | 576 | 2012-01-01 | KRW | South Korea | 3700.0 | 1158.75 | 3.19309600862999 |
577 | 577 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
578 | 578 | 2012-01-01 | MXN | Mexico | 37.0 | 13.6844 | 2.7038087164946902 |
579 | 579 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
580 | 580 | 2012-01-01 | NOK | Norway | 41.0 | 6.0399 | 6.78819185748108 |
581 | 581 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
582 | 582 | 2012-01-01 | PKR | Pakistan | 260.0 | 90.05 | 2.88728484175458 |
583 | 583 | 2012-01-01 | PEN | Peru | 10.0 | 2.6925 | 3.71402042711235 |
584 | 584 | 2012-01-01 | PHP | Philippines | 118.0 | 44.005 | 2.6815134643790497 |
585 | 585 | 2012-01-01 | PLN | Poland | 9.1 | 3.52045 | 2.58489681716826 |
586 | 586 | 2012-01-01 | RUB | Russia | 81.0 | 31.7693 | 2.54963124777694 |
587 | 587 | 2012-01-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
588 | 588 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
589 | 589 | 2012-01-01 | SEK | Sweden | 41.0 | 6.9338 | 5.91306354379994 |
590 | 590 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
591 | 591 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
592 | 592 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
593 | 593 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
594 | 594 | 2012-01-01 | UYU | Uruguay | 90.0 | 19.45 | 4.62724935732648 |
595 | 595 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
596 | 596 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
1885 | 1885 | 2012-01-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
1886 | 1886 | 2012-01-01 | ARS | Argentina | 20.0 | 4.3135 | 4.63660600440478 |
1887 | 1887 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
1888 | 1888 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
1889 | 1889 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
1890 | 1890 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
1891 | 1891 | 2012-01-01 | CLP | Chile | 2050.0 | 506.05 | 4.0509831044363205 |
1892 | 1892 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
1893 | 1893 | 2012-01-01 | COP | Colombia | 8400.0 | 1852.15 | 4.535269821558731 |
1894 | 1894 | 2012-01-01 | CRC | Costa Rica | 2050.0 | 509.54 | 4.02323664481689 |
1895 | 1895 | 2012-01-01 | CZK | Czech Republic | 70.22 | 20.36535 | 3.44801341494254 |
1896 | 1896 | 2012-01-01 | DKK | Denmark | 31.5 | 5.86135 | 5.374188540182719 |
1897 | 1897 | 2012-01-01 | EGP | Egypt | 15.5 | 6.037000000000001 | 2.56750041411297 |
1898 | 1898 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
1899 | 1899 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
1900 | 1900 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
1901 | 1901 | 2012-01-01 | HUF | Hungary | 645.0 | 245.69425 | 2.6252140617861404 |
1902 | 1902 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
1903 | 1903 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
1904 | 1904 | 2012-01-01 | ILS | Israel | 15.9 | 3.8485 | 4.13147979732363 |
1905 | 1905 | 2012-01-01 | JPY | Japan | 320.0 | 76.92 | 4.16016640665627 |
1906 | 1906 | 2012-01-01 | KRW | South Korea | 3700.0 | 1158.75 | 3.19309600862999 |
1907 | 1907 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
1908 | 1908 | 2012-01-01 | MXN | Mexico | 37.0 | 13.6844 | 2.7038087164946902 |
1909 | 1909 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
1910 | 1910 | 2012-01-01 | NOK | Norway | 41.0 | 6.0399 | 6.78819185748108 |
1911 | 1911 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
1912 | 1912 | 2012-01-01 | PKR | Pakistan | 260.0 | 90.05 | 2.88728484175458 |
1913 | 1913 | 2012-01-01 | PEN | Peru | 10.0 | 2.6925 | 3.71402042711235 |
1914 | 1914 | 2012-01-01 | PHP | Philippines | 118.0 | 44.005 | 2.6815134643790497 |
1915 | 1915 | 2012-01-01 | PLN | Poland | 9.1 | 3.52045 | 2.58489681716826 |
1916 | 1916 | 2012-01-01 | RUB | Russia | 81.0 | 31.7693 | 2.54963124777694 |
1917 | 1917 | 2012-01-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
1918 | 1918 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
1919 | 1919 | 2012-01-01 | SEK | Sweden | 41.0 | 6.9338 | 5.91306354379994 |
1920 | 1920 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
1921 | 1921 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
1922 | 1922 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
1923 | 1923 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
1924 | 1924 | 2012-01-01 | UYU | Uruguay | 90.0 | 19.45 | 4.62724935732648 |
1925 | 1925 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
1926 | 1926 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
3215 | 3215 | 2012-01-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
3216 | 3216 | 2012-01-01 | ARS | Argentina | 20.0 | 4.3135 | 4.63660600440478 |
3217 | 3217 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
3218 | 3218 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
3219 | 3219 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
3220 | 3220 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
3221 | 3221 | 2012-01-01 | CLP | Chile | 2050.0 | 506.05 | 4.0509831044363205 |
3222 | 3222 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
3223 | 3223 | 2012-01-01 | COP | Colombia | 8400.0 | 1852.15 | 4.535269821558731 |
3224 | 3224 | 2012-01-01 | CRC | Costa Rica | 2050.0 | 509.54 | 4.02323664481689 |
3225 | 3225 | 2012-01-01 | CZK | Czech Republic | 70.22 | 20.36535 | 3.44801341494254 |
3226 | 3226 | 2012-01-01 | DKK | Denmark | 31.5 | 5.86135 | 5.374188540182719 |
3227 | 3227 | 2012-01-01 | EGP | Egypt | 15.5 | 6.037000000000001 | 2.56750041411297 |
3228 | 3228 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
3229 | 3229 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
3230 | 3230 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
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 );