bigmac
420 rows where "date" is on date 2011-07-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
3189 | 3189 | 2011-07-01 | HUF | Hungary | 760.0 | 188.0724 | 4.04099697775963 |
3190 | 3190 | 2011-07-01 | IDR | Indonesia | 22534.0 | 8523.0 | 2.64390472838203 |
3191 | 3191 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
3192 | 3192 | 2011-07-01 | ILS | Israel | 15.9 | 3.40335 | 4.67186742474327 |
3193 | 3193 | 2011-07-01 | JPY | Japan | 320.0 | 78.365 | 4.08345562432208 |
3194 | 3194 | 2011-07-01 | KRW | South Korea | 3700.0 | 1056.2 | 3.50312440825601 |
3195 | 3195 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
3196 | 3196 | 2011-07-01 | MXN | Mexico | 32.0 | 11.67075 | 2.74189747873958 |
3197 | 3197 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
3198 | 3198 | 2011-07-01 | NOK | Norway | 45.0 | 5.41405 | 8.31170750177778 |
3199 | 3199 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
3200 | 3200 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
3201 | 3201 | 2011-07-01 | PEN | Peru | 10.0 | 2.7375 | 3.65296803652968 |
3202 | 3202 | 2011-07-01 | PHP | Philippines | 118.0 | 42.41 | 2.78236265031832 |
3203 | 3203 | 2011-07-01 | PLN | Poland | 8.63 | 2.7968 | 3.08566933638444 |
3204 | 3204 | 2011-07-01 | RUB | Russia | 75.0 | 27.7525 | 2.70245923790649 |
3205 | 3205 | 2011-07-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
3206 | 3206 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
3207 | 3207 | 2011-07-01 | SEK | Sweden | 48.4 | 6.3352 | 7.6398535168581905 |
3208 | 3208 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
3209 | 3209 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
3210 | 3210 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
3211 | 3211 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
3212 | 3212 | 2011-07-01 | UYU | Uruguay | 90.0 | 18.45 | 4.87804878048781 |
3213 | 3213 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
3214 | 3214 | 2011-07-01 | ZAR | South Africa | 19.45 | 6.76885 | 2.87345708650657 |
4503 | 4503 | 2011-07-01 | AED | UAE | 12.0 | 3.67305 | 3.2670396536938 |
4504 | 4504 | 2011-07-01 | ARS | Argentina | 20.0 | 4.1325 | 4.83968542044767 |
4505 | 4505 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
4506 | 4506 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
4507 | 4507 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
4508 | 4508 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
4509 | 4509 | 2011-07-01 | CLP | Chile | 1850.0 | 462.75 | 3.99783900594273 |
4510 | 4510 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
4511 | 4511 | 2011-07-01 | COP | Colombia | 8400.0 | 1770.5 | 4.74442247952556 |
4512 | 4512 | 2011-07-01 | CRC | Costa Rica | 2050.0 | 504.305 | 4.06500034701222 |
4513 | 4513 | 2011-07-01 | CZK | Czech Republic | 69.32 | 17.0219 | 4.072400848318931 |
4514 | 4514 | 2011-07-01 | DKK | Denmark | 28.5 | 5.19845 | 5.48240340870837 |
4515 | 4515 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
4516 | 4516 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
4517 | 4517 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
4518 | 4518 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
4519 | 4519 | 2011-07-01 | HUF | Hungary | 760.0 | 188.0724 | 4.04099697775963 |
4520 | 4520 | 2011-07-01 | IDR | Indonesia | 22534.0 | 8523.0 | 2.64390472838203 |
4521 | 4521 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
4522 | 4522 | 2011-07-01 | ILS | Israel | 15.9 | 3.40335 | 4.67186742474327 |
4523 | 4523 | 2011-07-01 | JPY | Japan | 320.0 | 78.365 | 4.08345562432208 |
4524 | 4524 | 2011-07-01 | KRW | South Korea | 3700.0 | 1056.2 | 3.50312440825601 |
4525 | 4525 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
4526 | 4526 | 2011-07-01 | MXN | Mexico | 32.0 | 11.67075 | 2.74189747873958 |
4527 | 4527 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
4528 | 4528 | 2011-07-01 | NOK | Norway | 45.0 | 5.41405 | 8.31170750177778 |
4529 | 4529 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
4530 | 4530 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
4531 | 4531 | 2011-07-01 | PEN | Peru | 10.0 | 2.7375 | 3.65296803652968 |
4532 | 4532 | 2011-07-01 | PHP | Philippines | 118.0 | 42.41 | 2.78236265031832 |
4533 | 4533 | 2011-07-01 | PLN | Poland | 8.63 | 2.7968 | 3.08566933638444 |
4534 | 4534 | 2011-07-01 | RUB | Russia | 75.0 | 27.7525 | 2.70245923790649 |
4535 | 4535 | 2011-07-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
4536 | 4536 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
4537 | 4537 | 2011-07-01 | SEK | Sweden | 48.4 | 6.3352 | 7.6398535168581905 |
4538 | 4538 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
4539 | 4539 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
4540 | 4540 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
4541 | 4541 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
4542 | 4542 | 2011-07-01 | UYU | Uruguay | 90.0 | 18.45 | 4.87804878048781 |
4543 | 4543 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
4544 | 4544 | 2011-07-01 | ZAR | South Africa | 19.45 | 6.76885 | 2.87345708650657 |
5833 | 5833 | 2011-07-01 | AED | UAE | 12.0 | 3.67305 | 3.2670396536938 |
5834 | 5834 | 2011-07-01 | ARS | Argentina | 20.0 | 4.1325 | 4.83968542044767 |
5835 | 5835 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
5836 | 5836 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
5837 | 5837 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
5838 | 5838 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
5839 | 5839 | 2011-07-01 | CLP | Chile | 1850.0 | 462.75 | 3.99783900594273 |
5840 | 5840 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
5841 | 5841 | 2011-07-01 | COP | Colombia | 8400.0 | 1770.5 | 4.74442247952556 |
5842 | 5842 | 2011-07-01 | CRC | Costa Rica | 2050.0 | 504.305 | 4.06500034701222 |
5843 | 5843 | 2011-07-01 | CZK | Czech Republic | 69.32 | 17.0219 | 4.072400848318931 |
5844 | 5844 | 2011-07-01 | DKK | Denmark | 28.5 | 5.19845 | 5.48240340870837 |
5845 | 5845 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
5846 | 5846 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
5847 | 5847 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
5848 | 5848 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
5849 | 5849 | 2011-07-01 | HUF | Hungary | 760.0 | 188.0724 | 4.04099697775963 |
5850 | 5850 | 2011-07-01 | IDR | Indonesia | 22534.0 | 8523.0 | 2.64390472838203 |
5851 | 5851 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
5852 | 5852 | 2011-07-01 | ILS | Israel | 15.9 | 3.40335 | 4.67186742474327 |
5853 | 5853 | 2011-07-01 | JPY | Japan | 320.0 | 78.365 | 4.08345562432208 |
5854 | 5854 | 2011-07-01 | KRW | South Korea | 3700.0 | 1056.2 | 3.50312440825601 |
5855 | 5855 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
5856 | 5856 | 2011-07-01 | MXN | Mexico | 32.0 | 11.67075 | 2.74189747873958 |
5857 | 5857 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
5858 | 5858 | 2011-07-01 | NOK | Norway | 45.0 | 5.41405 | 8.31170750177778 |
5859 | 5859 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
5860 | 5860 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
5861 | 5861 | 2011-07-01 | PEN | Peru | 10.0 | 2.7375 | 3.65296803652968 |
5862 | 5862 | 2011-07-01 | PHP | Philippines | 118.0 | 42.41 | 2.78236265031832 |
5863 | 5863 | 2011-07-01 | PLN | Poland | 8.63 | 2.7968 | 3.08566933638444 |
5864 | 5864 | 2011-07-01 | RUB | Russia | 75.0 | 27.7525 | 2.70245923790649 |
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 );