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 |
---|---|---|---|---|---|---|---|
513 | 513 | 2011-07-01 | AED | UAE | 12.0 | 3.67305 | 3.2670396536938 |
514 | 514 | 2011-07-01 | ARS | Argentina | 20.0 | 4.1325 | 4.83968542044767 |
515 | 515 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
516 | 516 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
517 | 517 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
518 | 518 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
519 | 519 | 2011-07-01 | CLP | Chile | 1850.0 | 462.75 | 3.99783900594273 |
520 | 520 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
521 | 521 | 2011-07-01 | COP | Colombia | 8400.0 | 1770.5 | 4.74442247952556 |
522 | 522 | 2011-07-01 | CRC | Costa Rica | 2050.0 | 504.305 | 4.06500034701222 |
523 | 523 | 2011-07-01 | CZK | Czech Republic | 69.32 | 17.0219 | 4.072400848318931 |
524 | 524 | 2011-07-01 | DKK | Denmark | 28.5 | 5.19845 | 5.48240340870837 |
525 | 525 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
526 | 526 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
527 | 527 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
528 | 528 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
529 | 529 | 2011-07-01 | HUF | Hungary | 760.0 | 188.0724 | 4.04099697775963 |
530 | 530 | 2011-07-01 | IDR | Indonesia | 22534.0 | 8523.0 | 2.64390472838203 |
531 | 531 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
532 | 532 | 2011-07-01 | ILS | Israel | 15.9 | 3.40335 | 4.67186742474327 |
533 | 533 | 2011-07-01 | JPY | Japan | 320.0 | 78.365 | 4.08345562432208 |
534 | 534 | 2011-07-01 | KRW | South Korea | 3700.0 | 1056.2 | 3.50312440825601 |
535 | 535 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
536 | 536 | 2011-07-01 | MXN | Mexico | 32.0 | 11.67075 | 2.74189747873958 |
537 | 537 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
538 | 538 | 2011-07-01 | NOK | Norway | 45.0 | 5.41405 | 8.31170750177778 |
539 | 539 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
540 | 540 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
541 | 541 | 2011-07-01 | PEN | Peru | 10.0 | 2.7375 | 3.65296803652968 |
542 | 542 | 2011-07-01 | PHP | Philippines | 118.0 | 42.41 | 2.78236265031832 |
543 | 543 | 2011-07-01 | PLN | Poland | 8.63 | 2.7968 | 3.08566933638444 |
544 | 544 | 2011-07-01 | RUB | Russia | 75.0 | 27.7525 | 2.70245923790649 |
545 | 545 | 2011-07-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
546 | 546 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
547 | 547 | 2011-07-01 | SEK | Sweden | 48.4 | 6.3352 | 7.6398535168581905 |
548 | 548 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
549 | 549 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
550 | 550 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
551 | 551 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
552 | 552 | 2011-07-01 | UYU | Uruguay | 90.0 | 18.45 | 4.87804878048781 |
553 | 553 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
554 | 554 | 2011-07-01 | ZAR | South Africa | 19.45 | 6.76885 | 2.87345708650657 |
1843 | 1843 | 2011-07-01 | AED | UAE | 12.0 | 3.67305 | 3.2670396536938 |
1844 | 1844 | 2011-07-01 | ARS | Argentina | 20.0 | 4.1325 | 4.83968542044767 |
1845 | 1845 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
1846 | 1846 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
1847 | 1847 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
1848 | 1848 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
1849 | 1849 | 2011-07-01 | CLP | Chile | 1850.0 | 462.75 | 3.99783900594273 |
1850 | 1850 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
1851 | 1851 | 2011-07-01 | COP | Colombia | 8400.0 | 1770.5 | 4.74442247952556 |
1852 | 1852 | 2011-07-01 | CRC | Costa Rica | 2050.0 | 504.305 | 4.06500034701222 |
1853 | 1853 | 2011-07-01 | CZK | Czech Republic | 69.32 | 17.0219 | 4.072400848318931 |
1854 | 1854 | 2011-07-01 | DKK | Denmark | 28.5 | 5.19845 | 5.48240340870837 |
1855 | 1855 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
1856 | 1856 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
1857 | 1857 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
1858 | 1858 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
1859 | 1859 | 2011-07-01 | HUF | Hungary | 760.0 | 188.0724 | 4.04099697775963 |
1860 | 1860 | 2011-07-01 | IDR | Indonesia | 22534.0 | 8523.0 | 2.64390472838203 |
1861 | 1861 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
1862 | 1862 | 2011-07-01 | ILS | Israel | 15.9 | 3.40335 | 4.67186742474327 |
1863 | 1863 | 2011-07-01 | JPY | Japan | 320.0 | 78.365 | 4.08345562432208 |
1864 | 1864 | 2011-07-01 | KRW | South Korea | 3700.0 | 1056.2 | 3.50312440825601 |
1865 | 1865 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
1866 | 1866 | 2011-07-01 | MXN | Mexico | 32.0 | 11.67075 | 2.74189747873958 |
1867 | 1867 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
1868 | 1868 | 2011-07-01 | NOK | Norway | 45.0 | 5.41405 | 8.31170750177778 |
1869 | 1869 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
1870 | 1870 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
1871 | 1871 | 2011-07-01 | PEN | Peru | 10.0 | 2.7375 | 3.65296803652968 |
1872 | 1872 | 2011-07-01 | PHP | Philippines | 118.0 | 42.41 | 2.78236265031832 |
1873 | 1873 | 2011-07-01 | PLN | Poland | 8.63 | 2.7968 | 3.08566933638444 |
1874 | 1874 | 2011-07-01 | RUB | Russia | 75.0 | 27.7525 | 2.70245923790649 |
1875 | 1875 | 2011-07-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
1876 | 1876 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
1877 | 1877 | 2011-07-01 | SEK | Sweden | 48.4 | 6.3352 | 7.6398535168581905 |
1878 | 1878 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
1879 | 1879 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
1880 | 1880 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
1881 | 1881 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
1882 | 1882 | 2011-07-01 | UYU | Uruguay | 90.0 | 18.45 | 4.87804878048781 |
1883 | 1883 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
1884 | 1884 | 2011-07-01 | ZAR | South Africa | 19.45 | 6.76885 | 2.87345708650657 |
3173 | 3173 | 2011-07-01 | AED | UAE | 12.0 | 3.67305 | 3.2670396536938 |
3174 | 3174 | 2011-07-01 | ARS | Argentina | 20.0 | 4.1325 | 4.83968542044767 |
3175 | 3175 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
3176 | 3176 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
3177 | 3177 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
3178 | 3178 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
3179 | 3179 | 2011-07-01 | CLP | Chile | 1850.0 | 462.75 | 3.99783900594273 |
3180 | 3180 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
3181 | 3181 | 2011-07-01 | COP | Colombia | 8400.0 | 1770.5 | 4.74442247952556 |
3182 | 3182 | 2011-07-01 | CRC | Costa Rica | 2050.0 | 504.305 | 4.06500034701222 |
3183 | 3183 | 2011-07-01 | CZK | Czech Republic | 69.32 | 17.0219 | 4.072400848318931 |
3184 | 3184 | 2011-07-01 | DKK | Denmark | 28.5 | 5.19845 | 5.48240340870837 |
3185 | 3185 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
3186 | 3186 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
3187 | 3187 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
3188 | 3188 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
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 );