bigmac
400 rows where "date" is on date 2008-06-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
12359 | 12359 | 2008-06-01 | ZAR | South Africa | 16.95 | 7.56325 | 2.24110005619277 |
12358 | 12358 | 2008-06-01 | USD | United States | 3.57 | 1.0 | 3.57 |
12357 | 12357 | 2008-06-01 | UYU | Uruguay | 61.0 | 19.15 | 3.1853785900783302 |
12356 | 12356 | 2008-06-01 | UAH | Ukraine | 11.0 | 4.6 | 2.39130434782609 |
12355 | 12355 | 2008-06-01 | TWD | Taiwan | 75.0 | 30.3625 | 2.4701523260601097 |
12354 | 12354 | 2008-06-01 | TRY | Turkey | 5.15 | 1.19275 | 4.31775309159505 |
12353 | 12353 | 2008-06-01 | THB | Thailand | 62.0 | 33.36 | 1.85851318944844 |
12352 | 12352 | 2008-06-01 | SEK | Sweden | 38.0 | 5.96085 | 6.374929749951769 |
12351 | 12351 | 2008-06-01 | SGD | Singapore | 3.95 | 1.35275 | 2.9199778229532405 |
12350 | 12350 | 2008-06-01 | SAR | Saudi Arabia | 10.0 | 3.74955 | 2.66698670507128 |
12349 | 12349 | 2008-06-01 | RUB | Russia | 59.0 | 23.2336 | 2.5394256593898503 |
12348 | 12348 | 2008-06-01 | PLN | Poland | 7.0 | 2.03145 | 3.44581456595043 |
12347 | 12347 | 2008-06-01 | PHP | Philippines | 87.0 | 44.485 | 1.95571540968866 |
12346 | 12346 | 2008-06-01 | PEN | Peru | 9.5 | 2.84 | 3.34507042253521 |
12345 | 12345 | 2008-06-01 | PKR | Pakistan | 140.0 | 70.9 | 1.97461212976023 |
12344 | 12344 | 2008-06-01 | NZD | New Zealand | 4.9 | 1.3177 | 3.7186005919405 |
12343 | 12343 | 2008-06-01 | NOK | Norway | 40.0 | 5.07915 | 7.87533347115167 |
12342 | 12342 | 2008-06-01 | MYR | Malaysia | 5.5 | 3.238 | 1.6985793699814702 |
12341 | 12341 | 2008-06-01 | MXN | Mexico | 32.0 | 10.1685 | 3.1469734965825804 |
12340 | 12340 | 2008-06-01 | LKR | Sri Lanka | 210.0 | 107.55 | 1.95258019525802 |
12339 | 12339 | 2008-06-01 | KRW | South Korea | 3200.0 | 1018.05 | 3.1432640832965 |
12338 | 12338 | 2008-06-01 | JPY | Japan | 280.0 | 106.855 | 2.62037340320996 |
12337 | 12337 | 2008-06-01 | IDR | Indonesia | 18700.0 | 9152.0 | 2.04326923076923 |
12336 | 12336 | 2008-06-01 | HUF | Hungary | 670.0 | 144.2578 | 4.64446289905988 |
12335 | 12335 | 2008-06-01 | HKD | Hong Kong | 13.3 | 7.7974 | 1.7056967707184398 |
12334 | 12334 | 2008-06-01 | GBP | Britain | 2.29 | 0.5010396570000001 | 4.5704965026351205 |
12333 | 12333 | 2008-06-01 | EUR | Euro area | 3.36856 | 0.630497147 | 5.342704588003469 |
12332 | 12332 | 2008-06-01 | EGP | Egypt | 13.0 | 5.3125 | 2.44705882352941 |
12331 | 12331 | 2008-06-01 | DKK | Denmark | 28.0 | 4.7044 | 5.951874840574781 |
12330 | 12330 | 2008-06-01 | CZK | Czech Republic | 66.08 | 14.49795 | 4.55788577005715 |
12329 | 12329 | 2008-06-01 | CRC | Costa Rica | 1800.0 | 551.02 | 3.2666690864215497 |
12328 | 12328 | 2008-06-01 | COP | Colombia | 7000.0 | 1798.65 | 3.89180774469741 |
12327 | 12327 | 2008-06-01 | CNY | China | 12.5 | 6.834 | 1.82908984489318 |
12326 | 12326 | 2008-06-01 | CLP | Chile | 1550.0 | 494.65 | 3.13352875770747 |
12325 | 12325 | 2008-06-01 | CHF | Switzerland | 6.5 | 1.02215 | 6.35914493958812 |
12324 | 12324 | 2008-06-01 | CAD | Canada | 4.09 | 1.00355 | 4.07553186189029 |
12323 | 12323 | 2008-06-01 | BRL | Brazil | 7.5 | 1.5846 | 4.73305566073457 |
12322 | 12322 | 2008-06-01 | AUD | Australia | 3.45 | 1.026 | 3.36257309941521 |
12321 | 12321 | 2008-06-01 | ARS | Argentina | 11.0 | 3.0195 | 3.64298724954463 |
12320 | 12320 | 2008-06-01 | AED | UAE | 10.0 | 3.67285 | 2.7226812965408302 |
11029 | 11029 | 2008-06-01 | ZAR | South Africa | 16.95 | 7.56325 | 2.24110005619277 |
11028 | 11028 | 2008-06-01 | USD | United States | 3.57 | 1.0 | 3.57 |
11027 | 11027 | 2008-06-01 | UYU | Uruguay | 61.0 | 19.15 | 3.1853785900783302 |
11026 | 11026 | 2008-06-01 | UAH | Ukraine | 11.0 | 4.6 | 2.39130434782609 |
11025 | 11025 | 2008-06-01 | TWD | Taiwan | 75.0 | 30.3625 | 2.4701523260601097 |
11024 | 11024 | 2008-06-01 | TRY | Turkey | 5.15 | 1.19275 | 4.31775309159505 |
11023 | 11023 | 2008-06-01 | THB | Thailand | 62.0 | 33.36 | 1.85851318944844 |
11022 | 11022 | 2008-06-01 | SEK | Sweden | 38.0 | 5.96085 | 6.374929749951769 |
11021 | 11021 | 2008-06-01 | SGD | Singapore | 3.95 | 1.35275 | 2.9199778229532405 |
11020 | 11020 | 2008-06-01 | SAR | Saudi Arabia | 10.0 | 3.74955 | 2.66698670507128 |
11019 | 11019 | 2008-06-01 | RUB | Russia | 59.0 | 23.2336 | 2.5394256593898503 |
11018 | 11018 | 2008-06-01 | PLN | Poland | 7.0 | 2.03145 | 3.44581456595043 |
11017 | 11017 | 2008-06-01 | PHP | Philippines | 87.0 | 44.485 | 1.95571540968866 |
11016 | 11016 | 2008-06-01 | PEN | Peru | 9.5 | 2.84 | 3.34507042253521 |
11015 | 11015 | 2008-06-01 | PKR | Pakistan | 140.0 | 70.9 | 1.97461212976023 |
11014 | 11014 | 2008-06-01 | NZD | New Zealand | 4.9 | 1.3177 | 3.7186005919405 |
11013 | 11013 | 2008-06-01 | NOK | Norway | 40.0 | 5.07915 | 7.87533347115167 |
11012 | 11012 | 2008-06-01 | MYR | Malaysia | 5.5 | 3.238 | 1.6985793699814702 |
11011 | 11011 | 2008-06-01 | MXN | Mexico | 32.0 | 10.1685 | 3.1469734965825804 |
11010 | 11010 | 2008-06-01 | LKR | Sri Lanka | 210.0 | 107.55 | 1.95258019525802 |
11009 | 11009 | 2008-06-01 | KRW | South Korea | 3200.0 | 1018.05 | 3.1432640832965 |
11008 | 11008 | 2008-06-01 | JPY | Japan | 280.0 | 106.855 | 2.62037340320996 |
11007 | 11007 | 2008-06-01 | IDR | Indonesia | 18700.0 | 9152.0 | 2.04326923076923 |
11006 | 11006 | 2008-06-01 | HUF | Hungary | 670.0 | 144.2578 | 4.64446289905988 |
11005 | 11005 | 2008-06-01 | HKD | Hong Kong | 13.3 | 7.7974 | 1.7056967707184398 |
11004 | 11004 | 2008-06-01 | GBP | Britain | 2.29 | 0.5010396570000001 | 4.5704965026351205 |
11003 | 11003 | 2008-06-01 | EUR | Euro area | 3.36856 | 0.630497147 | 5.342704588003469 |
11002 | 11002 | 2008-06-01 | EGP | Egypt | 13.0 | 5.3125 | 2.44705882352941 |
11001 | 11001 | 2008-06-01 | DKK | Denmark | 28.0 | 4.7044 | 5.951874840574781 |
11000 | 11000 | 2008-06-01 | CZK | Czech Republic | 66.08 | 14.49795 | 4.55788577005715 |
10999 | 10999 | 2008-06-01 | CRC | Costa Rica | 1800.0 | 551.02 | 3.2666690864215497 |
10998 | 10998 | 2008-06-01 | COP | Colombia | 7000.0 | 1798.65 | 3.89180774469741 |
10997 | 10997 | 2008-06-01 | CNY | China | 12.5 | 6.834 | 1.82908984489318 |
10996 | 10996 | 2008-06-01 | CLP | Chile | 1550.0 | 494.65 | 3.13352875770747 |
10995 | 10995 | 2008-06-01 | CHF | Switzerland | 6.5 | 1.02215 | 6.35914493958812 |
10994 | 10994 | 2008-06-01 | CAD | Canada | 4.09 | 1.00355 | 4.07553186189029 |
10993 | 10993 | 2008-06-01 | BRL | Brazil | 7.5 | 1.5846 | 4.73305566073457 |
10992 | 10992 | 2008-06-01 | AUD | Australia | 3.45 | 1.026 | 3.36257309941521 |
10991 | 10991 | 2008-06-01 | ARS | Argentina | 11.0 | 3.0195 | 3.64298724954463 |
10990 | 10990 | 2008-06-01 | AED | UAE | 10.0 | 3.67285 | 2.7226812965408302 |
9699 | 9699 | 2008-06-01 | ZAR | South Africa | 16.95 | 7.56325 | 2.24110005619277 |
9698 | 9698 | 2008-06-01 | USD | United States | 3.57 | 1.0 | 3.57 |
9697 | 9697 | 2008-06-01 | UYU | Uruguay | 61.0 | 19.15 | 3.1853785900783302 |
9696 | 9696 | 2008-06-01 | UAH | Ukraine | 11.0 | 4.6 | 2.39130434782609 |
9695 | 9695 | 2008-06-01 | TWD | Taiwan | 75.0 | 30.3625 | 2.4701523260601097 |
9694 | 9694 | 2008-06-01 | TRY | Turkey | 5.15 | 1.19275 | 4.31775309159505 |
9693 | 9693 | 2008-06-01 | THB | Thailand | 62.0 | 33.36 | 1.85851318944844 |
9692 | 9692 | 2008-06-01 | SEK | Sweden | 38.0 | 5.96085 | 6.374929749951769 |
9691 | 9691 | 2008-06-01 | SGD | Singapore | 3.95 | 1.35275 | 2.9199778229532405 |
9690 | 9690 | 2008-06-01 | SAR | Saudi Arabia | 10.0 | 3.74955 | 2.66698670507128 |
9689 | 9689 | 2008-06-01 | RUB | Russia | 59.0 | 23.2336 | 2.5394256593898503 |
9688 | 9688 | 2008-06-01 | PLN | Poland | 7.0 | 2.03145 | 3.44581456595043 |
9687 | 9687 | 2008-06-01 | PHP | Philippines | 87.0 | 44.485 | 1.95571540968866 |
9686 | 9686 | 2008-06-01 | PEN | Peru | 9.5 | 2.84 | 3.34507042253521 |
9685 | 9685 | 2008-06-01 | PKR | Pakistan | 140.0 | 70.9 | 1.97461212976023 |
9684 | 9684 | 2008-06-01 | NZD | New Zealand | 4.9 | 1.3177 | 3.7186005919405 |
9683 | 9683 | 2008-06-01 | NOK | Norway | 40.0 | 5.07915 | 7.87533347115167 |
9682 | 9682 | 2008-06-01 | MYR | Malaysia | 5.5 | 3.238 | 1.6985793699814702 |
9681 | 9681 | 2008-06-01 | MXN | Mexico | 32.0 | 10.1685 | 3.1469734965825804 |
9680 | 9680 | 2008-06-01 | LKR | Sri Lanka | 210.0 | 107.55 | 1.95258019525802 |
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 );