bigmac
420 rows where "date" is on date 2012-01-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
3231 | 3231 | 2012-01-01 | HUF | Hungary | 645.0 | 245.69425 | 2.6252140617861404 |
3232 | 3232 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
3233 | 3233 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
3234 | 3234 | 2012-01-01 | ILS | Israel | 15.9 | 3.8485 | 4.13147979732363 |
3235 | 3235 | 2012-01-01 | JPY | Japan | 320.0 | 76.92 | 4.16016640665627 |
3236 | 3236 | 2012-01-01 | KRW | South Korea | 3700.0 | 1158.75 | 3.19309600862999 |
3237 | 3237 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
3238 | 3238 | 2012-01-01 | MXN | Mexico | 37.0 | 13.6844 | 2.7038087164946902 |
3239 | 3239 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
3240 | 3240 | 2012-01-01 | NOK | Norway | 41.0 | 6.0399 | 6.78819185748108 |
3241 | 3241 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
3242 | 3242 | 2012-01-01 | PKR | Pakistan | 260.0 | 90.05 | 2.88728484175458 |
3243 | 3243 | 2012-01-01 | PEN | Peru | 10.0 | 2.6925 | 3.71402042711235 |
3244 | 3244 | 2012-01-01 | PHP | Philippines | 118.0 | 44.005 | 2.6815134643790497 |
3245 | 3245 | 2012-01-01 | PLN | Poland | 9.1 | 3.52045 | 2.58489681716826 |
3246 | 3246 | 2012-01-01 | RUB | Russia | 81.0 | 31.7693 | 2.54963124777694 |
3247 | 3247 | 2012-01-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
3248 | 3248 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
3249 | 3249 | 2012-01-01 | SEK | Sweden | 41.0 | 6.9338 | 5.91306354379994 |
3250 | 3250 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
3251 | 3251 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
3252 | 3252 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
3253 | 3253 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
3254 | 3254 | 2012-01-01 | UYU | Uruguay | 90.0 | 19.45 | 4.62724935732648 |
3255 | 3255 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
3256 | 3256 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
4545 | 4545 | 2012-01-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
4546 | 4546 | 2012-01-01 | ARS | Argentina | 20.0 | 4.3135 | 4.63660600440478 |
4547 | 4547 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
4548 | 4548 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
4549 | 4549 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
4550 | 4550 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
4551 | 4551 | 2012-01-01 | CLP | Chile | 2050.0 | 506.05 | 4.0509831044363205 |
4552 | 4552 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
4553 | 4553 | 2012-01-01 | COP | Colombia | 8400.0 | 1852.15 | 4.535269821558731 |
4554 | 4554 | 2012-01-01 | CRC | Costa Rica | 2050.0 | 509.54 | 4.02323664481689 |
4555 | 4555 | 2012-01-01 | CZK | Czech Republic | 70.22 | 20.36535 | 3.44801341494254 |
4556 | 4556 | 2012-01-01 | DKK | Denmark | 31.5 | 5.86135 | 5.374188540182719 |
4557 | 4557 | 2012-01-01 | EGP | Egypt | 15.5 | 6.037000000000001 | 2.56750041411297 |
4558 | 4558 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
4559 | 4559 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
4560 | 4560 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
4561 | 4561 | 2012-01-01 | HUF | Hungary | 645.0 | 245.69425 | 2.6252140617861404 |
4562 | 4562 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
4563 | 4563 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
4564 | 4564 | 2012-01-01 | ILS | Israel | 15.9 | 3.8485 | 4.13147979732363 |
4565 | 4565 | 2012-01-01 | JPY | Japan | 320.0 | 76.92 | 4.16016640665627 |
4566 | 4566 | 2012-01-01 | KRW | South Korea | 3700.0 | 1158.75 | 3.19309600862999 |
4567 | 4567 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
4568 | 4568 | 2012-01-01 | MXN | Mexico | 37.0 | 13.6844 | 2.7038087164946902 |
4569 | 4569 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
4570 | 4570 | 2012-01-01 | NOK | Norway | 41.0 | 6.0399 | 6.78819185748108 |
4571 | 4571 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
4572 | 4572 | 2012-01-01 | PKR | Pakistan | 260.0 | 90.05 | 2.88728484175458 |
4573 | 4573 | 2012-01-01 | PEN | Peru | 10.0 | 2.6925 | 3.71402042711235 |
4574 | 4574 | 2012-01-01 | PHP | Philippines | 118.0 | 44.005 | 2.6815134643790497 |
4575 | 4575 | 2012-01-01 | PLN | Poland | 9.1 | 3.52045 | 2.58489681716826 |
4576 | 4576 | 2012-01-01 | RUB | Russia | 81.0 | 31.7693 | 2.54963124777694 |
4577 | 4577 | 2012-01-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
4578 | 4578 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
4579 | 4579 | 2012-01-01 | SEK | Sweden | 41.0 | 6.9338 | 5.91306354379994 |
4580 | 4580 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
4581 | 4581 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
4582 | 4582 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
4583 | 4583 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
4584 | 4584 | 2012-01-01 | UYU | Uruguay | 90.0 | 19.45 | 4.62724935732648 |
4585 | 4585 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
4586 | 4586 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
5875 | 5875 | 2012-01-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
5876 | 5876 | 2012-01-01 | ARS | Argentina | 20.0 | 4.3135 | 4.63660600440478 |
5877 | 5877 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
5878 | 5878 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
5879 | 5879 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
5880 | 5880 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
5881 | 5881 | 2012-01-01 | CLP | Chile | 2050.0 | 506.05 | 4.0509831044363205 |
5882 | 5882 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
5883 | 5883 | 2012-01-01 | COP | Colombia | 8400.0 | 1852.15 | 4.535269821558731 |
5884 | 5884 | 2012-01-01 | CRC | Costa Rica | 2050.0 | 509.54 | 4.02323664481689 |
5885 | 5885 | 2012-01-01 | CZK | Czech Republic | 70.22 | 20.36535 | 3.44801341494254 |
5886 | 5886 | 2012-01-01 | DKK | Denmark | 31.5 | 5.86135 | 5.374188540182719 |
5887 | 5887 | 2012-01-01 | EGP | Egypt | 15.5 | 6.037000000000001 | 2.56750041411297 |
5888 | 5888 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
5889 | 5889 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
5890 | 5890 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
5891 | 5891 | 2012-01-01 | HUF | Hungary | 645.0 | 245.69425 | 2.6252140617861404 |
5892 | 5892 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
5893 | 5893 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
5894 | 5894 | 2012-01-01 | ILS | Israel | 15.9 | 3.8485 | 4.13147979732363 |
5895 | 5895 | 2012-01-01 | JPY | Japan | 320.0 | 76.92 | 4.16016640665627 |
5896 | 5896 | 2012-01-01 | KRW | South Korea | 3700.0 | 1158.75 | 3.19309600862999 |
5897 | 5897 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
5898 | 5898 | 2012-01-01 | MXN | Mexico | 37.0 | 13.6844 | 2.7038087164946902 |
5899 | 5899 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
5900 | 5900 | 2012-01-01 | NOK | Norway | 41.0 | 6.0399 | 6.78819185748108 |
5901 | 5901 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
5902 | 5902 | 2012-01-01 | PKR | Pakistan | 260.0 | 90.05 | 2.88728484175458 |
5903 | 5903 | 2012-01-01 | PEN | Peru | 10.0 | 2.6925 | 3.71402042711235 |
5904 | 5904 | 2012-01-01 | PHP | Philippines | 118.0 | 44.005 | 2.6815134643790497 |
5905 | 5905 | 2012-01-01 | PLN | Poland | 9.1 | 3.52045 | 2.58489681716826 |
5906 | 5906 | 2012-01-01 | RUB | Russia | 81.0 | 31.7693 | 2.54963124777694 |
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 );