bigmac
400 rows where "date" is on date 2006-05-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
2910 | 2910 | 2006-05-01 | LKR | Sri Lanka | 190.0 | 102.955 | 1.84546646593172 |
2911 | 2911 | 2006-05-01 | MXN | Mexico | 29.0 | 11.3031 | 2.56566782564075 |
2912 | 2912 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
2913 | 2913 | 2006-05-01 | NOK | Norway | 43.0 | 6.1023 | 7.04652344198089 |
2914 | 2914 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
2915 | 2915 | 2006-05-01 | PKR | Pakistan | 130.0 | 60.055 | 2.16468237449005 |
2916 | 2916 | 2006-05-01 | PEN | Peru | 9.5 | 3.261 | 2.91321680466115 |
2917 | 2917 | 2006-05-01 | PHP | Philippines | 85.0 | 52.625 | 1.6152019002375302 |
2918 | 2918 | 2006-05-01 | PLN | Poland | 6.5 | 3.09915 | 2.09734927318781 |
2919 | 2919 | 2006-05-01 | RUB | Russia | 48.0 | 27.06375 | 1.77359013440488 |
2920 | 2920 | 2006-05-01 | SAR | Saudi Arabia | 9.0 | 3.749 | 2.40064017071219 |
2921 | 2921 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
2922 | 2922 | 2006-05-01 | SEK | Sweden | 33.0 | 7.28455 | 4.53013569815569 |
2923 | 2923 | 2006-05-01 | THB | Thailand | 60.0 | 38.445 | 1.56067108856808 |
2924 | 2924 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
2925 | 2925 | 2006-05-01 | TWD | Taiwan | 75.0 | 32.141 | 2.3334681559379 |
2926 | 2926 | 2006-05-01 | UAH | Ukraine | 8.5 | 5.05 | 1.68316831683168 |
2927 | 2927 | 2006-05-01 | UYU | Uruguay | 42.28 | 23.925 | 1.76718913270637 |
2928 | 2928 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
2929 | 2929 | 2006-05-01 | ZAR | South Africa | 13.95 | 6.597 | 2.11459754433834 |
4220 | 4220 | 2006-05-01 | AED | UAE | 9.0 | 3.6726 | 2.45057997059304 |
4221 | 4221 | 2006-05-01 | ARS | Argentina | 7.0 | 3.0565 | 2.29020121053493 |
4222 | 4222 | 2006-05-01 | AUD | Australia | 3.25 | 1.33253 | 2.43896947911116 |
4223 | 4223 | 2006-05-01 | BRL | Brazil | 6.4 | 2.3045 | 2.77717509221089 |
4224 | 4224 | 2006-05-01 | CAD | Canada | 3.52 | 1.12045 | 3.1415948949083 |
4225 | 4225 | 2006-05-01 | CHF | Switzerland | 6.3 | 1.20885 | 5.211564710261821 |
4226 | 4226 | 2006-05-01 | CLP | Chile | 1560.0 | 529.95 | 2.9436739315029703 |
4227 | 4227 | 2006-05-01 | CNY | China | 10.5 | 8.026 | 1.30824819337154 |
4228 | 4228 | 2006-05-01 | COP | Colombia | 6500.0 | 2503.6 | 2.59626138360761 |
4229 | 4229 | 2006-05-01 | CRC | Costa Rica | 1130.0 | 509.535 | 2.2177083026681204 |
4230 | 4230 | 2006-05-01 | CZK | Czech Republic | 59.05 | 22.1078 | 2.67100299441826 |
4231 | 4231 | 2006-05-01 | DKK | Denmark | 27.75 | 5.81825 | 4.76947535771065 |
4232 | 4232 | 2006-05-01 | EGP | Egypt | 9.5 | 5.77075 | 1.6462331586015702 |
4233 | 4233 | 2006-05-01 | EUR | Euro area | 2.939573529 | 0.780365992 | 3.76691649704796 |
4234 | 4234 | 2006-05-01 | GBP | Britain | 1.94 | 0.531801744 | 3.64797600212458 |
4235 | 4235 | 2006-05-01 | HKD | Hong Kong | 12.0 | 7.7533 | 1.54772806417912 |
4236 | 4236 | 2006-05-01 | HUF | Hungary | 560.0 | 206.3444 | 2.71390936705818 |
4237 | 4237 | 2006-05-01 | IDR | Indonesia | 14600.0 | 9325.0 | 1.5656836461126 |
4238 | 4238 | 2006-05-01 | JPY | Japan | 250.0 | 112.105 | 2.23005218322109 |
4239 | 4239 | 2006-05-01 | KRW | South Korea | 2500.0 | 952.4 | 2.62494750104998 |
4240 | 4240 | 2006-05-01 | LKR | Sri Lanka | 190.0 | 102.955 | 1.84546646593172 |
4241 | 4241 | 2006-05-01 | MXN | Mexico | 29.0 | 11.3031 | 2.56566782564075 |
4242 | 4242 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
4243 | 4243 | 2006-05-01 | NOK | Norway | 43.0 | 6.1023 | 7.04652344198089 |
4244 | 4244 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
4245 | 4245 | 2006-05-01 | PKR | Pakistan | 130.0 | 60.055 | 2.16468237449005 |
4246 | 4246 | 2006-05-01 | PEN | Peru | 9.5 | 3.261 | 2.91321680466115 |
4247 | 4247 | 2006-05-01 | PHP | Philippines | 85.0 | 52.625 | 1.6152019002375302 |
4248 | 4248 | 2006-05-01 | PLN | Poland | 6.5 | 3.09915 | 2.09734927318781 |
4249 | 4249 | 2006-05-01 | RUB | Russia | 48.0 | 27.06375 | 1.77359013440488 |
4250 | 4250 | 2006-05-01 | SAR | Saudi Arabia | 9.0 | 3.749 | 2.40064017071219 |
4251 | 4251 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
4252 | 4252 | 2006-05-01 | SEK | Sweden | 33.0 | 7.28455 | 4.53013569815569 |
4253 | 4253 | 2006-05-01 | THB | Thailand | 60.0 | 38.445 | 1.56067108856808 |
4254 | 4254 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
4255 | 4255 | 2006-05-01 | TWD | Taiwan | 75.0 | 32.141 | 2.3334681559379 |
4256 | 4256 | 2006-05-01 | UAH | Ukraine | 8.5 | 5.05 | 1.68316831683168 |
4257 | 4257 | 2006-05-01 | UYU | Uruguay | 42.28 | 23.925 | 1.76718913270637 |
4258 | 4258 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
4259 | 4259 | 2006-05-01 | ZAR | South Africa | 13.95 | 6.597 | 2.11459754433834 |
5550 | 5550 | 2006-05-01 | AED | UAE | 9.0 | 3.6726 | 2.45057997059304 |
5551 | 5551 | 2006-05-01 | ARS | Argentina | 7.0 | 3.0565 | 2.29020121053493 |
5552 | 5552 | 2006-05-01 | AUD | Australia | 3.25 | 1.33253 | 2.43896947911116 |
5553 | 5553 | 2006-05-01 | BRL | Brazil | 6.4 | 2.3045 | 2.77717509221089 |
5554 | 5554 | 2006-05-01 | CAD | Canada | 3.52 | 1.12045 | 3.1415948949083 |
5555 | 5555 | 2006-05-01 | CHF | Switzerland | 6.3 | 1.20885 | 5.211564710261821 |
5556 | 5556 | 2006-05-01 | CLP | Chile | 1560.0 | 529.95 | 2.9436739315029703 |
5557 | 5557 | 2006-05-01 | CNY | China | 10.5 | 8.026 | 1.30824819337154 |
5558 | 5558 | 2006-05-01 | COP | Colombia | 6500.0 | 2503.6 | 2.59626138360761 |
5559 | 5559 | 2006-05-01 | CRC | Costa Rica | 1130.0 | 509.535 | 2.2177083026681204 |
5560 | 5560 | 2006-05-01 | CZK | Czech Republic | 59.05 | 22.1078 | 2.67100299441826 |
5561 | 5561 | 2006-05-01 | DKK | Denmark | 27.75 | 5.81825 | 4.76947535771065 |
5562 | 5562 | 2006-05-01 | EGP | Egypt | 9.5 | 5.77075 | 1.6462331586015702 |
5563 | 5563 | 2006-05-01 | EUR | Euro area | 2.939573529 | 0.780365992 | 3.76691649704796 |
5564 | 5564 | 2006-05-01 | GBP | Britain | 1.94 | 0.531801744 | 3.64797600212458 |
5565 | 5565 | 2006-05-01 | HKD | Hong Kong | 12.0 | 7.7533 | 1.54772806417912 |
5566 | 5566 | 2006-05-01 | HUF | Hungary | 560.0 | 206.3444 | 2.71390936705818 |
5567 | 5567 | 2006-05-01 | IDR | Indonesia | 14600.0 | 9325.0 | 1.5656836461126 |
5568 | 5568 | 2006-05-01 | JPY | Japan | 250.0 | 112.105 | 2.23005218322109 |
5569 | 5569 | 2006-05-01 | KRW | South Korea | 2500.0 | 952.4 | 2.62494750104998 |
5570 | 5570 | 2006-05-01 | LKR | Sri Lanka | 190.0 | 102.955 | 1.84546646593172 |
5571 | 5571 | 2006-05-01 | MXN | Mexico | 29.0 | 11.3031 | 2.56566782564075 |
5572 | 5572 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
5573 | 5573 | 2006-05-01 | NOK | Norway | 43.0 | 6.1023 | 7.04652344198089 |
5574 | 5574 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
5575 | 5575 | 2006-05-01 | PKR | Pakistan | 130.0 | 60.055 | 2.16468237449005 |
5576 | 5576 | 2006-05-01 | PEN | Peru | 9.5 | 3.261 | 2.91321680466115 |
5577 | 5577 | 2006-05-01 | PHP | Philippines | 85.0 | 52.625 | 1.6152019002375302 |
5578 | 5578 | 2006-05-01 | PLN | Poland | 6.5 | 3.09915 | 2.09734927318781 |
5579 | 5579 | 2006-05-01 | RUB | Russia | 48.0 | 27.06375 | 1.77359013440488 |
5580 | 5580 | 2006-05-01 | SAR | Saudi Arabia | 9.0 | 3.749 | 2.40064017071219 |
5581 | 5581 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
5582 | 5582 | 2006-05-01 | SEK | Sweden | 33.0 | 7.28455 | 4.53013569815569 |
5583 | 5583 | 2006-05-01 | THB | Thailand | 60.0 | 38.445 | 1.56067108856808 |
5584 | 5584 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
5585 | 5585 | 2006-05-01 | TWD | Taiwan | 75.0 | 32.141 | 2.3334681559379 |
5586 | 5586 | 2006-05-01 | UAH | Ukraine | 8.5 | 5.05 | 1.68316831683168 |
5587 | 5587 | 2006-05-01 | UYU | Uruguay | 42.28 | 23.925 | 1.76718913270637 |
5588 | 5588 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
5589 | 5589 | 2006-05-01 | ZAR | South Africa | 13.95 | 6.597 | 2.11459754433834 |
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 );