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 |
---|---|---|---|---|---|---|---|
3068 | 3068 | 2009-07-01 | ILS | Israel | 15.0 | 3.97425 | 3.7742970371768303 |
3069 | 3069 | 2009-07-01 | JPY | Japan | 320.0 | 92.565 | 3.45703019499811 |
3070 | 3070 | 2009-07-01 | KRW | South Korea | 3400.0 | 1314.5 | 2.58653480410803 |
3071 | 3071 | 2009-07-01 | LKR | Sri Lanka | 210.0 | 114.86 | 1.82831272853909 |
3072 | 3072 | 2009-07-01 | MXN | Mexico | 33.0 | 13.8104 | 2.38950356253258 |
3073 | 3073 | 2009-07-01 | MYR | Malaysia | 6.77 | 3.602 | 1.87951138256524 |
3074 | 3074 | 2009-07-01 | NOK | Norway | 40.0 | 6.50925 | 6.14510120213542 |
3075 | 3075 | 2009-07-01 | NZD | New Zealand | 4.9 | 1.59235 | 3.07721292429428 |
3076 | 3076 | 2009-07-01 | PKR | Pakistan | 190.0 | 82.6 | 2.30024213075061 |
3077 | 3077 | 2009-07-01 | PEN | Peru | 8.056000000000001 | 3.0274 | 2.66102926603686 |
3078 | 3078 | 2009-07-01 | PHP | Philippines | 99.39 | 48.385 | 2.0541490131239 |
3079 | 3079 | 2009-07-01 | PLN | Poland | 7.6 | 3.15525 | 2.4086839394659703 |
3080 | 3080 | 2009-07-01 | RUB | Russia | 67.0 | 32.7959 | 2.04293829411603 |
3081 | 3081 | 2009-07-01 | SAR | Saudi Arabia | 11.0 | 3.7504 | 2.9330204778157003 |
3082 | 3082 | 2009-07-01 | SGD | Singapore | 4.22 | 1.4645 | 2.8815295322635697 |
3083 | 3083 | 2009-07-01 | SEK | Sweden | 39.0 | 7.90915 | 4.930997641971639 |
3084 | 3084 | 2009-07-01 | THB | Thailand | 64.49 | 34.165 | 1.88760427337919 |
3085 | 3085 | 2009-07-01 | TRY | Turkey | 5.65 | 1.55005 | 3.64504370826748 |
3086 | 3086 | 2009-07-01 | TWD | Taiwan | 75.0 | 33.1755 | 2.2607044355021 |
3087 | 3087 | 2009-07-01 | UAH | Ukraine | 14.0 | 7.66 | 1.82767624020888 |
3088 | 3088 | 2009-07-01 | UYU | Uruguay | 61.0 | 23.17 | 2.63271471730686 |
3089 | 3089 | 2009-07-01 | USD | United States | 3.57 | 1.0 | 3.57 |
3090 | 3090 | 2009-07-01 | ZAR | South Africa | 17.95 | 8.2805 | 2.16774349375038 |
4380 | 4380 | 2009-07-01 | AED | UAE | 10.0 | 3.673 | 2.7225701061802297 |
4381 | 4381 | 2009-07-01 | ARS | Argentina | 11.5 | 3.81125 | 3.0173827484421096 |
4382 | 4382 | 2009-07-01 | AUD | Australia | 4.34 | 1.2869 | 3.37244541145388 |
4383 | 4383 | 2009-07-01 | BRL | Brazil | 8.03 | 1.9971 | 4.0208302037955 |
4384 | 4384 | 2009-07-01 | CAD | Canada | 3.89 | 1.16085 | 3.3509928069948702 |
4385 | 4385 | 2009-07-01 | CHF | Switzerland | 6.5 | 1.08605 | 5.98499148289674 |
4386 | 4386 | 2009-07-01 | CLP | Chile | 1750.0 | 548.55 | 3.19022878497858 |
4387 | 4387 | 2009-07-01 | CNY | China | 12.5 | 6.8327 | 1.82943785033735 |
4388 | 4388 | 2009-07-01 | COP | Colombia | 7000.0 | 2095.6 | 3.3403321244512303 |
4389 | 4389 | 2009-07-01 | CRC | Costa Rica | 2000.0 | 582.57 | 3.43306383782206 |
4390 | 4390 | 2009-07-01 | CZK | Czech Republic | 67.92 | 18.66155 | 3.63956906044782 |
4391 | 4391 | 2009-07-01 | DKK | Denmark | 29.5 | 5.3375 | 5.52693208430913 |
4392 | 4392 | 2009-07-01 | EGP | Egypt | 13.0 | 5.58475 | 2.32776758135995 |
4393 | 4393 | 2009-07-01 | EUR | Euro area | 3.31 | 0.7168972690000001 | 4.6171189975617 |
4394 | 4394 | 2009-07-01 | GBP | Britain | 2.29 | 0.620886626 | 3.6882740006063504 |
4395 | 4395 | 2009-07-01 | HKD | Hong Kong | 13.3 | 7.7505 | 1.71601832139862 |
4396 | 4396 | 2009-07-01 | HUF | Hungary | 720.0 | 199.1577 | 3.61522552228711 |
4397 | 4397 | 2009-07-01 | IDR | Indonesia | 20900.0 | 10200.0 | 2.04901960784314 |
4398 | 4398 | 2009-07-01 | ILS | Israel | 15.0 | 3.97425 | 3.7742970371768303 |
4399 | 4399 | 2009-07-01 | JPY | Japan | 320.0 | 92.565 | 3.45703019499811 |
4400 | 4400 | 2009-07-01 | KRW | South Korea | 3400.0 | 1314.5 | 2.58653480410803 |
4401 | 4401 | 2009-07-01 | LKR | Sri Lanka | 210.0 | 114.86 | 1.82831272853909 |
4402 | 4402 | 2009-07-01 | MXN | Mexico | 33.0 | 13.8104 | 2.38950356253258 |
4403 | 4403 | 2009-07-01 | MYR | Malaysia | 6.77 | 3.602 | 1.87951138256524 |
4404 | 4404 | 2009-07-01 | NOK | Norway | 40.0 | 6.50925 | 6.14510120213542 |
4405 | 4405 | 2009-07-01 | NZD | New Zealand | 4.9 | 1.59235 | 3.07721292429428 |
4406 | 4406 | 2009-07-01 | PKR | Pakistan | 190.0 | 82.6 | 2.30024213075061 |
4407 | 4407 | 2009-07-01 | PEN | Peru | 8.056000000000001 | 3.0274 | 2.66102926603686 |
4408 | 4408 | 2009-07-01 | PHP | Philippines | 99.39 | 48.385 | 2.0541490131239 |
4409 | 4409 | 2009-07-01 | PLN | Poland | 7.6 | 3.15525 | 2.4086839394659703 |
4410 | 4410 | 2009-07-01 | RUB | Russia | 67.0 | 32.7959 | 2.04293829411603 |
4411 | 4411 | 2009-07-01 | SAR | Saudi Arabia | 11.0 | 3.7504 | 2.9330204778157003 |
4412 | 4412 | 2009-07-01 | SGD | Singapore | 4.22 | 1.4645 | 2.8815295322635697 |
4413 | 4413 | 2009-07-01 | SEK | Sweden | 39.0 | 7.90915 | 4.930997641971639 |
4414 | 4414 | 2009-07-01 | THB | Thailand | 64.49 | 34.165 | 1.88760427337919 |
4415 | 4415 | 2009-07-01 | TRY | Turkey | 5.65 | 1.55005 | 3.64504370826748 |
4416 | 4416 | 2009-07-01 | TWD | Taiwan | 75.0 | 33.1755 | 2.2607044355021 |
4417 | 4417 | 2009-07-01 | UAH | Ukraine | 14.0 | 7.66 | 1.82767624020888 |
4418 | 4418 | 2009-07-01 | UYU | Uruguay | 61.0 | 23.17 | 2.63271471730686 |
4419 | 4419 | 2009-07-01 | USD | United States | 3.57 | 1.0 | 3.57 |
4420 | 4420 | 2009-07-01 | ZAR | South Africa | 17.95 | 8.2805 | 2.16774349375038 |
5710 | 5710 | 2009-07-01 | AED | UAE | 10.0 | 3.673 | 2.7225701061802297 |
5711 | 5711 | 2009-07-01 | ARS | Argentina | 11.5 | 3.81125 | 3.0173827484421096 |
5712 | 5712 | 2009-07-01 | AUD | Australia | 4.34 | 1.2869 | 3.37244541145388 |
5713 | 5713 | 2009-07-01 | BRL | Brazil | 8.03 | 1.9971 | 4.0208302037955 |
5714 | 5714 | 2009-07-01 | CAD | Canada | 3.89 | 1.16085 | 3.3509928069948702 |
5715 | 5715 | 2009-07-01 | CHF | Switzerland | 6.5 | 1.08605 | 5.98499148289674 |
5716 | 5716 | 2009-07-01 | CLP | Chile | 1750.0 | 548.55 | 3.19022878497858 |
5717 | 5717 | 2009-07-01 | CNY | China | 12.5 | 6.8327 | 1.82943785033735 |
5718 | 5718 | 2009-07-01 | COP | Colombia | 7000.0 | 2095.6 | 3.3403321244512303 |
5719 | 5719 | 2009-07-01 | CRC | Costa Rica | 2000.0 | 582.57 | 3.43306383782206 |
5720 | 5720 | 2009-07-01 | CZK | Czech Republic | 67.92 | 18.66155 | 3.63956906044782 |
5721 | 5721 | 2009-07-01 | DKK | Denmark | 29.5 | 5.3375 | 5.52693208430913 |
5722 | 5722 | 2009-07-01 | EGP | Egypt | 13.0 | 5.58475 | 2.32776758135995 |
5723 | 5723 | 2009-07-01 | EUR | Euro area | 3.31 | 0.7168972690000001 | 4.6171189975617 |
5724 | 5724 | 2009-07-01 | GBP | Britain | 2.29 | 0.620886626 | 3.6882740006063504 |
5725 | 5725 | 2009-07-01 | HKD | Hong Kong | 13.3 | 7.7505 | 1.71601832139862 |
5726 | 5726 | 2009-07-01 | HUF | Hungary | 720.0 | 199.1577 | 3.61522552228711 |
5727 | 5727 | 2009-07-01 | IDR | Indonesia | 20900.0 | 10200.0 | 2.04901960784314 |
5728 | 5728 | 2009-07-01 | ILS | Israel | 15.0 | 3.97425 | 3.7742970371768303 |
5729 | 5729 | 2009-07-01 | JPY | Japan | 320.0 | 92.565 | 3.45703019499811 |
5730 | 5730 | 2009-07-01 | KRW | South Korea | 3400.0 | 1314.5 | 2.58653480410803 |
5731 | 5731 | 2009-07-01 | LKR | Sri Lanka | 210.0 | 114.86 | 1.82831272853909 |
5732 | 5732 | 2009-07-01 | MXN | Mexico | 33.0 | 13.8104 | 2.38950356253258 |
5733 | 5733 | 2009-07-01 | MYR | Malaysia | 6.77 | 3.602 | 1.87951138256524 |
5734 | 5734 | 2009-07-01 | NOK | Norway | 40.0 | 6.50925 | 6.14510120213542 |
5735 | 5735 | 2009-07-01 | NZD | New Zealand | 4.9 | 1.59235 | 3.07721292429428 |
5736 | 5736 | 2009-07-01 | PKR | Pakistan | 190.0 | 82.6 | 2.30024213075061 |
5737 | 5737 | 2009-07-01 | PEN | Peru | 8.056000000000001 | 3.0274 | 2.66102926603686 |
5738 | 5738 | 2009-07-01 | PHP | Philippines | 99.39 | 48.385 | 2.0541490131239 |
5739 | 5739 | 2009-07-01 | PLN | Poland | 7.6 | 3.15525 | 2.4086839394659703 |
5740 | 5740 | 2009-07-01 | RUB | Russia | 67.0 | 32.7959 | 2.04293829411603 |
5741 | 5741 | 2009-07-01 | SAR | Saudi Arabia | 11.0 | 3.7504 | 2.9330204778157003 |
5742 | 5742 | 2009-07-01 | SGD | Singapore | 4.22 | 1.4645 | 2.8815295322635697 |
5743 | 5743 | 2009-07-01 | SEK | Sweden | 39.0 | 7.90915 | 4.930997641971639 |
5744 | 5744 | 2009-07-01 | THB | Thailand | 64.49 | 34.165 | 1.88760427337919 |
5745 | 5745 | 2009-07-01 | TRY | Turkey | 5.65 | 1.55005 | 3.64504370826748 |
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 );