bigmac
410 rows where "date" is on date 2009-07-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
390 | 390 | 2009-07-01 | AED | UAE | 10.0 | 3.673 | 2.7225701061802297 |
391 | 391 | 2009-07-01 | ARS | Argentina | 11.5 | 3.81125 | 3.0173827484421096 |
392 | 392 | 2009-07-01 | AUD | Australia | 4.34 | 1.2869 | 3.37244541145388 |
393 | 393 | 2009-07-01 | BRL | Brazil | 8.03 | 1.9971 | 4.0208302037955 |
394 | 394 | 2009-07-01 | CAD | Canada | 3.89 | 1.16085 | 3.3509928069948702 |
395 | 395 | 2009-07-01 | CHF | Switzerland | 6.5 | 1.08605 | 5.98499148289674 |
396 | 396 | 2009-07-01 | CLP | Chile | 1750.0 | 548.55 | 3.19022878497858 |
397 | 397 | 2009-07-01 | CNY | China | 12.5 | 6.8327 | 1.82943785033735 |
398 | 398 | 2009-07-01 | COP | Colombia | 7000.0 | 2095.6 | 3.3403321244512303 |
399 | 399 | 2009-07-01 | CRC | Costa Rica | 2000.0 | 582.57 | 3.43306383782206 |
400 | 400 | 2009-07-01 | CZK | Czech Republic | 67.92 | 18.66155 | 3.63956906044782 |
401 | 401 | 2009-07-01 | DKK | Denmark | 29.5 | 5.3375 | 5.52693208430913 |
402 | 402 | 2009-07-01 | EGP | Egypt | 13.0 | 5.58475 | 2.32776758135995 |
403 | 403 | 2009-07-01 | EUR | Euro area | 3.31 | 0.7168972690000001 | 4.6171189975617 |
404 | 404 | 2009-07-01 | GBP | Britain | 2.29 | 0.620886626 | 3.6882740006063504 |
405 | 405 | 2009-07-01 | HKD | Hong Kong | 13.3 | 7.7505 | 1.71601832139862 |
406 | 406 | 2009-07-01 | HUF | Hungary | 720.0 | 199.1577 | 3.61522552228711 |
407 | 407 | 2009-07-01 | IDR | Indonesia | 20900.0 | 10200.0 | 2.04901960784314 |
408 | 408 | 2009-07-01 | ILS | Israel | 15.0 | 3.97425 | 3.7742970371768303 |
409 | 409 | 2009-07-01 | JPY | Japan | 320.0 | 92.565 | 3.45703019499811 |
410 | 410 | 2009-07-01 | KRW | South Korea | 3400.0 | 1314.5 | 2.58653480410803 |
411 | 411 | 2009-07-01 | LKR | Sri Lanka | 210.0 | 114.86 | 1.82831272853909 |
412 | 412 | 2009-07-01 | MXN | Mexico | 33.0 | 13.8104 | 2.38950356253258 |
413 | 413 | 2009-07-01 | MYR | Malaysia | 6.77 | 3.602 | 1.87951138256524 |
414 | 414 | 2009-07-01 | NOK | Norway | 40.0 | 6.50925 | 6.14510120213542 |
415 | 415 | 2009-07-01 | NZD | New Zealand | 4.9 | 1.59235 | 3.07721292429428 |
416 | 416 | 2009-07-01 | PKR | Pakistan | 190.0 | 82.6 | 2.30024213075061 |
417 | 417 | 2009-07-01 | PEN | Peru | 8.056000000000001 | 3.0274 | 2.66102926603686 |
418 | 418 | 2009-07-01 | PHP | Philippines | 99.39 | 48.385 | 2.0541490131239 |
419 | 419 | 2009-07-01 | PLN | Poland | 7.6 | 3.15525 | 2.4086839394659703 |
420 | 420 | 2009-07-01 | RUB | Russia | 67.0 | 32.7959 | 2.04293829411603 |
421 | 421 | 2009-07-01 | SAR | Saudi Arabia | 11.0 | 3.7504 | 2.9330204778157003 |
422 | 422 | 2009-07-01 | SGD | Singapore | 4.22 | 1.4645 | 2.8815295322635697 |
423 | 423 | 2009-07-01 | SEK | Sweden | 39.0 | 7.90915 | 4.930997641971639 |
424 | 424 | 2009-07-01 | THB | Thailand | 64.49 | 34.165 | 1.88760427337919 |
425 | 425 | 2009-07-01 | TRY | Turkey | 5.65 | 1.55005 | 3.64504370826748 |
426 | 426 | 2009-07-01 | TWD | Taiwan | 75.0 | 33.1755 | 2.2607044355021 |
427 | 427 | 2009-07-01 | UAH | Ukraine | 14.0 | 7.66 | 1.82767624020888 |
428 | 428 | 2009-07-01 | UYU | Uruguay | 61.0 | 23.17 | 2.63271471730686 |
429 | 429 | 2009-07-01 | USD | United States | 3.57 | 1.0 | 3.57 |
430 | 430 | 2009-07-01 | ZAR | South Africa | 17.95 | 8.2805 | 2.16774349375038 |
1720 | 1720 | 2009-07-01 | AED | UAE | 10.0 | 3.673 | 2.7225701061802297 |
1721 | 1721 | 2009-07-01 | ARS | Argentina | 11.5 | 3.81125 | 3.0173827484421096 |
1722 | 1722 | 2009-07-01 | AUD | Australia | 4.34 | 1.2869 | 3.37244541145388 |
1723 | 1723 | 2009-07-01 | BRL | Brazil | 8.03 | 1.9971 | 4.0208302037955 |
1724 | 1724 | 2009-07-01 | CAD | Canada | 3.89 | 1.16085 | 3.3509928069948702 |
1725 | 1725 | 2009-07-01 | CHF | Switzerland | 6.5 | 1.08605 | 5.98499148289674 |
1726 | 1726 | 2009-07-01 | CLP | Chile | 1750.0 | 548.55 | 3.19022878497858 |
1727 | 1727 | 2009-07-01 | CNY | China | 12.5 | 6.8327 | 1.82943785033735 |
1728 | 1728 | 2009-07-01 | COP | Colombia | 7000.0 | 2095.6 | 3.3403321244512303 |
1729 | 1729 | 2009-07-01 | CRC | Costa Rica | 2000.0 | 582.57 | 3.43306383782206 |
1730 | 1730 | 2009-07-01 | CZK | Czech Republic | 67.92 | 18.66155 | 3.63956906044782 |
1731 | 1731 | 2009-07-01 | DKK | Denmark | 29.5 | 5.3375 | 5.52693208430913 |
1732 | 1732 | 2009-07-01 | EGP | Egypt | 13.0 | 5.58475 | 2.32776758135995 |
1733 | 1733 | 2009-07-01 | EUR | Euro area | 3.31 | 0.7168972690000001 | 4.6171189975617 |
1734 | 1734 | 2009-07-01 | GBP | Britain | 2.29 | 0.620886626 | 3.6882740006063504 |
1735 | 1735 | 2009-07-01 | HKD | Hong Kong | 13.3 | 7.7505 | 1.71601832139862 |
1736 | 1736 | 2009-07-01 | HUF | Hungary | 720.0 | 199.1577 | 3.61522552228711 |
1737 | 1737 | 2009-07-01 | IDR | Indonesia | 20900.0 | 10200.0 | 2.04901960784314 |
1738 | 1738 | 2009-07-01 | ILS | Israel | 15.0 | 3.97425 | 3.7742970371768303 |
1739 | 1739 | 2009-07-01 | JPY | Japan | 320.0 | 92.565 | 3.45703019499811 |
1740 | 1740 | 2009-07-01 | KRW | South Korea | 3400.0 | 1314.5 | 2.58653480410803 |
1741 | 1741 | 2009-07-01 | LKR | Sri Lanka | 210.0 | 114.86 | 1.82831272853909 |
1742 | 1742 | 2009-07-01 | MXN | Mexico | 33.0 | 13.8104 | 2.38950356253258 |
1743 | 1743 | 2009-07-01 | MYR | Malaysia | 6.77 | 3.602 | 1.87951138256524 |
1744 | 1744 | 2009-07-01 | NOK | Norway | 40.0 | 6.50925 | 6.14510120213542 |
1745 | 1745 | 2009-07-01 | NZD | New Zealand | 4.9 | 1.59235 | 3.07721292429428 |
1746 | 1746 | 2009-07-01 | PKR | Pakistan | 190.0 | 82.6 | 2.30024213075061 |
1747 | 1747 | 2009-07-01 | PEN | Peru | 8.056000000000001 | 3.0274 | 2.66102926603686 |
1748 | 1748 | 2009-07-01 | PHP | Philippines | 99.39 | 48.385 | 2.0541490131239 |
1749 | 1749 | 2009-07-01 | PLN | Poland | 7.6 | 3.15525 | 2.4086839394659703 |
1750 | 1750 | 2009-07-01 | RUB | Russia | 67.0 | 32.7959 | 2.04293829411603 |
1751 | 1751 | 2009-07-01 | SAR | Saudi Arabia | 11.0 | 3.7504 | 2.9330204778157003 |
1752 | 1752 | 2009-07-01 | SGD | Singapore | 4.22 | 1.4645 | 2.8815295322635697 |
1753 | 1753 | 2009-07-01 | SEK | Sweden | 39.0 | 7.90915 | 4.930997641971639 |
1754 | 1754 | 2009-07-01 | THB | Thailand | 64.49 | 34.165 | 1.88760427337919 |
1755 | 1755 | 2009-07-01 | TRY | Turkey | 5.65 | 1.55005 | 3.64504370826748 |
1756 | 1756 | 2009-07-01 | TWD | Taiwan | 75.0 | 33.1755 | 2.2607044355021 |
1757 | 1757 | 2009-07-01 | UAH | Ukraine | 14.0 | 7.66 | 1.82767624020888 |
1758 | 1758 | 2009-07-01 | UYU | Uruguay | 61.0 | 23.17 | 2.63271471730686 |
1759 | 1759 | 2009-07-01 | USD | United States | 3.57 | 1.0 | 3.57 |
1760 | 1760 | 2009-07-01 | ZAR | South Africa | 17.95 | 8.2805 | 2.16774349375038 |
3050 | 3050 | 2009-07-01 | AED | UAE | 10.0 | 3.673 | 2.7225701061802297 |
3051 | 3051 | 2009-07-01 | ARS | Argentina | 11.5 | 3.81125 | 3.0173827484421096 |
3052 | 3052 | 2009-07-01 | AUD | Australia | 4.34 | 1.2869 | 3.37244541145388 |
3053 | 3053 | 2009-07-01 | BRL | Brazil | 8.03 | 1.9971 | 4.0208302037955 |
3054 | 3054 | 2009-07-01 | CAD | Canada | 3.89 | 1.16085 | 3.3509928069948702 |
3055 | 3055 | 2009-07-01 | CHF | Switzerland | 6.5 | 1.08605 | 5.98499148289674 |
3056 | 3056 | 2009-07-01 | CLP | Chile | 1750.0 | 548.55 | 3.19022878497858 |
3057 | 3057 | 2009-07-01 | CNY | China | 12.5 | 6.8327 | 1.82943785033735 |
3058 | 3058 | 2009-07-01 | COP | Colombia | 7000.0 | 2095.6 | 3.3403321244512303 |
3059 | 3059 | 2009-07-01 | CRC | Costa Rica | 2000.0 | 582.57 | 3.43306383782206 |
3060 | 3060 | 2009-07-01 | CZK | Czech Republic | 67.92 | 18.66155 | 3.63956906044782 |
3061 | 3061 | 2009-07-01 | DKK | Denmark | 29.5 | 5.3375 | 5.52693208430913 |
3062 | 3062 | 2009-07-01 | EGP | Egypt | 13.0 | 5.58475 | 2.32776758135995 |
3063 | 3063 | 2009-07-01 | EUR | Euro area | 3.31 | 0.7168972690000001 | 4.6171189975617 |
3064 | 3064 | 2009-07-01 | GBP | Britain | 2.29 | 0.620886626 | 3.6882740006063504 |
3065 | 3065 | 2009-07-01 | HKD | Hong Kong | 13.3 | 7.7505 | 1.71601832139862 |
3066 | 3066 | 2009-07-01 | HUF | Hungary | 720.0 | 199.1577 | 3.61522552228711 |
3067 | 3067 | 2009-07-01 | IDR | Indonesia | 20900.0 | 10200.0 | 2.04901960784314 |
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 );