bigmac
400 rows where "date" is on date 2008-06-01 sorted by date
This data as json, CSV (advanced)
Link | rowid | date ▼ | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
350 | 350 | 2008-06-01 | AED | UAE | 10.0 | 3.67285 | 2.7226812965408302 |
351 | 351 | 2008-06-01 | ARS | Argentina | 11.0 | 3.0195 | 3.64298724954463 |
352 | 352 | 2008-06-01 | AUD | Australia | 3.45 | 1.026 | 3.36257309941521 |
353 | 353 | 2008-06-01 | BRL | Brazil | 7.5 | 1.5846 | 4.73305566073457 |
354 | 354 | 2008-06-01 | CAD | Canada | 4.09 | 1.00355 | 4.07553186189029 |
355 | 355 | 2008-06-01 | CHF | Switzerland | 6.5 | 1.02215 | 6.35914493958812 |
356 | 356 | 2008-06-01 | CLP | Chile | 1550.0 | 494.65 | 3.13352875770747 |
357 | 357 | 2008-06-01 | CNY | China | 12.5 | 6.834 | 1.82908984489318 |
358 | 358 | 2008-06-01 | COP | Colombia | 7000.0 | 1798.65 | 3.89180774469741 |
359 | 359 | 2008-06-01 | CRC | Costa Rica | 1800.0 | 551.02 | 3.2666690864215497 |
360 | 360 | 2008-06-01 | CZK | Czech Republic | 66.08 | 14.49795 | 4.55788577005715 |
361 | 361 | 2008-06-01 | DKK | Denmark | 28.0 | 4.7044 | 5.951874840574781 |
362 | 362 | 2008-06-01 | EGP | Egypt | 13.0 | 5.3125 | 2.44705882352941 |
363 | 363 | 2008-06-01 | EUR | Euro area | 3.36856 | 0.630497147 | 5.342704588003469 |
364 | 364 | 2008-06-01 | GBP | Britain | 2.29 | 0.5010396570000001 | 4.5704965026351205 |
365 | 365 | 2008-06-01 | HKD | Hong Kong | 13.3 | 7.7974 | 1.7056967707184398 |
366 | 366 | 2008-06-01 | HUF | Hungary | 670.0 | 144.2578 | 4.64446289905988 |
367 | 367 | 2008-06-01 | IDR | Indonesia | 18700.0 | 9152.0 | 2.04326923076923 |
368 | 368 | 2008-06-01 | JPY | Japan | 280.0 | 106.855 | 2.62037340320996 |
369 | 369 | 2008-06-01 | KRW | South Korea | 3200.0 | 1018.05 | 3.1432640832965 |
370 | 370 | 2008-06-01 | LKR | Sri Lanka | 210.0 | 107.55 | 1.95258019525802 |
371 | 371 | 2008-06-01 | MXN | Mexico | 32.0 | 10.1685 | 3.1469734965825804 |
372 | 372 | 2008-06-01 | MYR | Malaysia | 5.5 | 3.238 | 1.6985793699814702 |
373 | 373 | 2008-06-01 | NOK | Norway | 40.0 | 5.07915 | 7.87533347115167 |
374 | 374 | 2008-06-01 | NZD | New Zealand | 4.9 | 1.3177 | 3.7186005919405 |
375 | 375 | 2008-06-01 | PKR | Pakistan | 140.0 | 70.9 | 1.97461212976023 |
376 | 376 | 2008-06-01 | PEN | Peru | 9.5 | 2.84 | 3.34507042253521 |
377 | 377 | 2008-06-01 | PHP | Philippines | 87.0 | 44.485 | 1.95571540968866 |
378 | 378 | 2008-06-01 | PLN | Poland | 7.0 | 2.03145 | 3.44581456595043 |
379 | 379 | 2008-06-01 | RUB | Russia | 59.0 | 23.2336 | 2.5394256593898503 |
380 | 380 | 2008-06-01 | SAR | Saudi Arabia | 10.0 | 3.74955 | 2.66698670507128 |
381 | 381 | 2008-06-01 | SGD | Singapore | 3.95 | 1.35275 | 2.9199778229532405 |
382 | 382 | 2008-06-01 | SEK | Sweden | 38.0 | 5.96085 | 6.374929749951769 |
383 | 383 | 2008-06-01 | THB | Thailand | 62.0 | 33.36 | 1.85851318944844 |
384 | 384 | 2008-06-01 | TRY | Turkey | 5.15 | 1.19275 | 4.31775309159505 |
385 | 385 | 2008-06-01 | TWD | Taiwan | 75.0 | 30.3625 | 2.4701523260601097 |
386 | 386 | 2008-06-01 | UAH | Ukraine | 11.0 | 4.6 | 2.39130434782609 |
387 | 387 | 2008-06-01 | UYU | Uruguay | 61.0 | 19.15 | 3.1853785900783302 |
388 | 388 | 2008-06-01 | USD | United States | 3.57 | 1.0 | 3.57 |
389 | 389 | 2008-06-01 | ZAR | South Africa | 16.95 | 7.56325 | 2.24110005619277 |
1680 | 1680 | 2008-06-01 | AED | UAE | 10.0 | 3.67285 | 2.7226812965408302 |
1681 | 1681 | 2008-06-01 | ARS | Argentina | 11.0 | 3.0195 | 3.64298724954463 |
1682 | 1682 | 2008-06-01 | AUD | Australia | 3.45 | 1.026 | 3.36257309941521 |
1683 | 1683 | 2008-06-01 | BRL | Brazil | 7.5 | 1.5846 | 4.73305566073457 |
1684 | 1684 | 2008-06-01 | CAD | Canada | 4.09 | 1.00355 | 4.07553186189029 |
1685 | 1685 | 2008-06-01 | CHF | Switzerland | 6.5 | 1.02215 | 6.35914493958812 |
1686 | 1686 | 2008-06-01 | CLP | Chile | 1550.0 | 494.65 | 3.13352875770747 |
1687 | 1687 | 2008-06-01 | CNY | China | 12.5 | 6.834 | 1.82908984489318 |
1688 | 1688 | 2008-06-01 | COP | Colombia | 7000.0 | 1798.65 | 3.89180774469741 |
1689 | 1689 | 2008-06-01 | CRC | Costa Rica | 1800.0 | 551.02 | 3.2666690864215497 |
1690 | 1690 | 2008-06-01 | CZK | Czech Republic | 66.08 | 14.49795 | 4.55788577005715 |
1691 | 1691 | 2008-06-01 | DKK | Denmark | 28.0 | 4.7044 | 5.951874840574781 |
1692 | 1692 | 2008-06-01 | EGP | Egypt | 13.0 | 5.3125 | 2.44705882352941 |
1693 | 1693 | 2008-06-01 | EUR | Euro area | 3.36856 | 0.630497147 | 5.342704588003469 |
1694 | 1694 | 2008-06-01 | GBP | Britain | 2.29 | 0.5010396570000001 | 4.5704965026351205 |
1695 | 1695 | 2008-06-01 | HKD | Hong Kong | 13.3 | 7.7974 | 1.7056967707184398 |
1696 | 1696 | 2008-06-01 | HUF | Hungary | 670.0 | 144.2578 | 4.64446289905988 |
1697 | 1697 | 2008-06-01 | IDR | Indonesia | 18700.0 | 9152.0 | 2.04326923076923 |
1698 | 1698 | 2008-06-01 | JPY | Japan | 280.0 | 106.855 | 2.62037340320996 |
1699 | 1699 | 2008-06-01 | KRW | South Korea | 3200.0 | 1018.05 | 3.1432640832965 |
1700 | 1700 | 2008-06-01 | LKR | Sri Lanka | 210.0 | 107.55 | 1.95258019525802 |
1701 | 1701 | 2008-06-01 | MXN | Mexico | 32.0 | 10.1685 | 3.1469734965825804 |
1702 | 1702 | 2008-06-01 | MYR | Malaysia | 5.5 | 3.238 | 1.6985793699814702 |
1703 | 1703 | 2008-06-01 | NOK | Norway | 40.0 | 5.07915 | 7.87533347115167 |
1704 | 1704 | 2008-06-01 | NZD | New Zealand | 4.9 | 1.3177 | 3.7186005919405 |
1705 | 1705 | 2008-06-01 | PKR | Pakistan | 140.0 | 70.9 | 1.97461212976023 |
1706 | 1706 | 2008-06-01 | PEN | Peru | 9.5 | 2.84 | 3.34507042253521 |
1707 | 1707 | 2008-06-01 | PHP | Philippines | 87.0 | 44.485 | 1.95571540968866 |
1708 | 1708 | 2008-06-01 | PLN | Poland | 7.0 | 2.03145 | 3.44581456595043 |
1709 | 1709 | 2008-06-01 | RUB | Russia | 59.0 | 23.2336 | 2.5394256593898503 |
1710 | 1710 | 2008-06-01 | SAR | Saudi Arabia | 10.0 | 3.74955 | 2.66698670507128 |
1711 | 1711 | 2008-06-01 | SGD | Singapore | 3.95 | 1.35275 | 2.9199778229532405 |
1712 | 1712 | 2008-06-01 | SEK | Sweden | 38.0 | 5.96085 | 6.374929749951769 |
1713 | 1713 | 2008-06-01 | THB | Thailand | 62.0 | 33.36 | 1.85851318944844 |
1714 | 1714 | 2008-06-01 | TRY | Turkey | 5.15 | 1.19275 | 4.31775309159505 |
1715 | 1715 | 2008-06-01 | TWD | Taiwan | 75.0 | 30.3625 | 2.4701523260601097 |
1716 | 1716 | 2008-06-01 | UAH | Ukraine | 11.0 | 4.6 | 2.39130434782609 |
1717 | 1717 | 2008-06-01 | UYU | Uruguay | 61.0 | 19.15 | 3.1853785900783302 |
1718 | 1718 | 2008-06-01 | USD | United States | 3.57 | 1.0 | 3.57 |
1719 | 1719 | 2008-06-01 | ZAR | South Africa | 16.95 | 7.56325 | 2.24110005619277 |
3010 | 3010 | 2008-06-01 | AED | UAE | 10.0 | 3.67285 | 2.7226812965408302 |
3011 | 3011 | 2008-06-01 | ARS | Argentina | 11.0 | 3.0195 | 3.64298724954463 |
3012 | 3012 | 2008-06-01 | AUD | Australia | 3.45 | 1.026 | 3.36257309941521 |
3013 | 3013 | 2008-06-01 | BRL | Brazil | 7.5 | 1.5846 | 4.73305566073457 |
3014 | 3014 | 2008-06-01 | CAD | Canada | 4.09 | 1.00355 | 4.07553186189029 |
3015 | 3015 | 2008-06-01 | CHF | Switzerland | 6.5 | 1.02215 | 6.35914493958812 |
3016 | 3016 | 2008-06-01 | CLP | Chile | 1550.0 | 494.65 | 3.13352875770747 |
3017 | 3017 | 2008-06-01 | CNY | China | 12.5 | 6.834 | 1.82908984489318 |
3018 | 3018 | 2008-06-01 | COP | Colombia | 7000.0 | 1798.65 | 3.89180774469741 |
3019 | 3019 | 2008-06-01 | CRC | Costa Rica | 1800.0 | 551.02 | 3.2666690864215497 |
3020 | 3020 | 2008-06-01 | CZK | Czech Republic | 66.08 | 14.49795 | 4.55788577005715 |
3021 | 3021 | 2008-06-01 | DKK | Denmark | 28.0 | 4.7044 | 5.951874840574781 |
3022 | 3022 | 2008-06-01 | EGP | Egypt | 13.0 | 5.3125 | 2.44705882352941 |
3023 | 3023 | 2008-06-01 | EUR | Euro area | 3.36856 | 0.630497147 | 5.342704588003469 |
3024 | 3024 | 2008-06-01 | GBP | Britain | 2.29 | 0.5010396570000001 | 4.5704965026351205 |
3025 | 3025 | 2008-06-01 | HKD | Hong Kong | 13.3 | 7.7974 | 1.7056967707184398 |
3026 | 3026 | 2008-06-01 | HUF | Hungary | 670.0 | 144.2578 | 4.64446289905988 |
3027 | 3027 | 2008-06-01 | IDR | Indonesia | 18700.0 | 9152.0 | 2.04326923076923 |
3028 | 3028 | 2008-06-01 | JPY | Japan | 280.0 | 106.855 | 2.62037340320996 |
3029 | 3029 | 2008-06-01 | KRW | South Korea | 3200.0 | 1018.05 | 3.1432640832965 |
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 );