bigmac
420 rows where "date" is on date 2013-07-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
12690 | 12690 | 2013-07-01 | ZAR | South Africa | 22.5 | 10.04725 | 2.23941874642315 |
12689 | 12689 | 2013-07-01 | USD | United States | 4.556666667 | 1.0 | 4.556666667 |
12688 | 12688 | 2013-07-01 | UYU | Uruguay | 105.0 | 21.085 | 4.97984349063315 |
12687 | 12687 | 2013-07-01 | UAH | Ukraine | 19.0 | 8.155 | 2.3298589822195 |
12686 | 12686 | 2013-07-01 | TWD | Taiwan | 79.0 | 30.0285 | 2.63083404099439 |
12685 | 12685 | 2013-07-01 | TRY | Turkey | 8.5 | 1.95745 | 4.34238422437355 |
12684 | 12684 | 2013-07-01 | THB | Thailand | 89.0 | 31.275 | 2.8457234212629903 |
12683 | 12683 | 2013-07-01 | SEK | Sweden | 41.61 | 6.7583 | 6.156873770030921 |
12682 | 12682 | 2013-07-01 | SGD | Singapore | 4.7 | 1.2747 | 3.68714207264454 |
12681 | 12681 | 2013-07-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
12680 | 12680 | 2013-07-01 | RUB | Russia | 87.0 | 32.9389 | 2.64125395808603 |
12679 | 12679 | 2013-07-01 | PLN | Poland | 9.2 | 3.3655 | 2.7336205615807496 |
12678 | 12678 | 2013-07-01 | PHP | Philippines | 115.21 | 43.44 | 2.6521639042357297 |
12677 | 12677 | 2013-07-01 | PEN | Peru | 10.0 | 2.783 | 3.5932446999640697 |
12676 | 12676 | 2013-07-01 | PKR | Pakistan | 300.0 | 100.035 | 2.99895036737142 |
12675 | 12675 | 2013-07-01 | NZD | New Zealand | 5.5 | 1.279344975 | 4.29907500125211 |
12674 | 12674 | 2013-07-01 | NOK | Norway | 46.0 | 6.1281 | 7.506404921590709 |
12673 | 12673 | 2013-07-01 | MYR | Malaysia | 7.3 | 3.1805 | 2.2952365980191805 |
12672 | 12672 | 2013-07-01 | MXN | Mexico | 37.0 | 12.94115 | 2.8590967572433703 |
12671 | 12671 | 2013-07-01 | LKR | Sri Lanka | 370.0 | 130.8 | 2.828746177370029 |
12670 | 12670 | 2013-07-01 | KRW | South Korea | 3900.0 | 1135.7 | 3.4340054591881697 |
12669 | 12669 | 2013-07-01 | JPY | Japan | 320.0 | 100.105 | 3.1966435242994904 |
12668 | 12668 | 2013-07-01 | ILS | Israel | 17.5 | 3.64595 | 4.79984640491504 |
12667 | 12667 | 2013-07-01 | INR | India | 90.0 | 59.98 | 1.50050016672224 |
12666 | 12666 | 2013-07-01 | IDR | Indonesia | 27939.0 | 9965.0 | 2.80371299548419 |
12665 | 12665 | 2013-07-01 | HUF | Hungary | 860.0 | 228.462 | 3.76430215965894 |
12664 | 12664 | 2013-07-01 | HKD | Hong Kong | 17.0 | 7.75665 | 2.19166779473097 |
12663 | 12663 | 2013-07-01 | GBP | Britain | 2.69 | 0.669142494 | 4.02007049936362 |
12662 | 12662 | 2013-07-01 | EUR | Euro area | 3.623870489 | 0.777756173 | 4.65939148386547 |
12661 | 12661 | 2013-07-01 | EGP | Egypt | 16.75 | 7.00915 | 2.38973341988686 |
12660 | 12660 | 2013-07-01 | DKK | Denmark | 28.5 | 5.8006 | 4.91328483260352 |
12659 | 12659 | 2013-07-01 | CZK | Czech Republic | 70.45 | 20.1828 | 3.49059595298967 |
12658 | 12658 | 2013-07-01 | CRC | Costa Rica | 2150.0 | 498.675 | 4.31142527698401 |
12657 | 12657 | 2013-07-01 | COP | Colombia | 8600.0 | 1921.0 | 4.47683498178032 |
12656 | 12656 | 2013-07-01 | CNY | China | 16.0 | 6.1341 | 2.60836960597317 |
12655 | 12655 | 2013-07-01 | CLP | Chile | 2000.0 | 508.155 | 3.93580698802531 |
12654 | 12654 | 2013-07-01 | CHF | Switzerland | 6.5 | 0.9674 | 6.7190407277238 |
12653 | 12653 | 2013-07-01 | CAD | Canada | 5.53 | 1.05125 | 5.260404280618309 |
12652 | 12652 | 2013-07-01 | BRL | Brazil | 12.0 | 2.27065 | 5.28483033492612 |
12651 | 12651 | 2013-07-01 | AUD | Australia | 5.035 | 1.089858863 | 4.61986425117506 |
12650 | 12650 | 2013-07-01 | ARS | Argentina | 21.0 | 5.4125 | 3.87990762124711 |
12649 | 12649 | 2013-07-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
11360 | 11360 | 2013-07-01 | ZAR | South Africa | 22.5 | 10.04725 | 2.23941874642315 |
11359 | 11359 | 2013-07-01 | USD | United States | 4.556666667 | 1.0 | 4.556666667 |
11358 | 11358 | 2013-07-01 | UYU | Uruguay | 105.0 | 21.085 | 4.97984349063315 |
11357 | 11357 | 2013-07-01 | UAH | Ukraine | 19.0 | 8.155 | 2.3298589822195 |
11356 | 11356 | 2013-07-01 | TWD | Taiwan | 79.0 | 30.0285 | 2.63083404099439 |
11355 | 11355 | 2013-07-01 | TRY | Turkey | 8.5 | 1.95745 | 4.34238422437355 |
11354 | 11354 | 2013-07-01 | THB | Thailand | 89.0 | 31.275 | 2.8457234212629903 |
11353 | 11353 | 2013-07-01 | SEK | Sweden | 41.61 | 6.7583 | 6.156873770030921 |
11352 | 11352 | 2013-07-01 | SGD | Singapore | 4.7 | 1.2747 | 3.68714207264454 |
11351 | 11351 | 2013-07-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
11350 | 11350 | 2013-07-01 | RUB | Russia | 87.0 | 32.9389 | 2.64125395808603 |
11349 | 11349 | 2013-07-01 | PLN | Poland | 9.2 | 3.3655 | 2.7336205615807496 |
11348 | 11348 | 2013-07-01 | PHP | Philippines | 115.21 | 43.44 | 2.6521639042357297 |
11347 | 11347 | 2013-07-01 | PEN | Peru | 10.0 | 2.783 | 3.5932446999640697 |
11346 | 11346 | 2013-07-01 | PKR | Pakistan | 300.0 | 100.035 | 2.99895036737142 |
11345 | 11345 | 2013-07-01 | NZD | New Zealand | 5.5 | 1.279344975 | 4.29907500125211 |
11344 | 11344 | 2013-07-01 | NOK | Norway | 46.0 | 6.1281 | 7.506404921590709 |
11343 | 11343 | 2013-07-01 | MYR | Malaysia | 7.3 | 3.1805 | 2.2952365980191805 |
11342 | 11342 | 2013-07-01 | MXN | Mexico | 37.0 | 12.94115 | 2.8590967572433703 |
11341 | 11341 | 2013-07-01 | LKR | Sri Lanka | 370.0 | 130.8 | 2.828746177370029 |
11340 | 11340 | 2013-07-01 | KRW | South Korea | 3900.0 | 1135.7 | 3.4340054591881697 |
11339 | 11339 | 2013-07-01 | JPY | Japan | 320.0 | 100.105 | 3.1966435242994904 |
11338 | 11338 | 2013-07-01 | ILS | Israel | 17.5 | 3.64595 | 4.79984640491504 |
11337 | 11337 | 2013-07-01 | INR | India | 90.0 | 59.98 | 1.50050016672224 |
11336 | 11336 | 2013-07-01 | IDR | Indonesia | 27939.0 | 9965.0 | 2.80371299548419 |
11335 | 11335 | 2013-07-01 | HUF | Hungary | 860.0 | 228.462 | 3.76430215965894 |
11334 | 11334 | 2013-07-01 | HKD | Hong Kong | 17.0 | 7.75665 | 2.19166779473097 |
11333 | 11333 | 2013-07-01 | GBP | Britain | 2.69 | 0.669142494 | 4.02007049936362 |
11332 | 11332 | 2013-07-01 | EUR | Euro area | 3.623870489 | 0.777756173 | 4.65939148386547 |
11331 | 11331 | 2013-07-01 | EGP | Egypt | 16.75 | 7.00915 | 2.38973341988686 |
11330 | 11330 | 2013-07-01 | DKK | Denmark | 28.5 | 5.8006 | 4.91328483260352 |
11329 | 11329 | 2013-07-01 | CZK | Czech Republic | 70.45 | 20.1828 | 3.49059595298967 |
11328 | 11328 | 2013-07-01 | CRC | Costa Rica | 2150.0 | 498.675 | 4.31142527698401 |
11327 | 11327 | 2013-07-01 | COP | Colombia | 8600.0 | 1921.0 | 4.47683498178032 |
11326 | 11326 | 2013-07-01 | CNY | China | 16.0 | 6.1341 | 2.60836960597317 |
11325 | 11325 | 2013-07-01 | CLP | Chile | 2000.0 | 508.155 | 3.93580698802531 |
11324 | 11324 | 2013-07-01 | CHF | Switzerland | 6.5 | 0.9674 | 6.7190407277238 |
11323 | 11323 | 2013-07-01 | CAD | Canada | 5.53 | 1.05125 | 5.260404280618309 |
11322 | 11322 | 2013-07-01 | BRL | Brazil | 12.0 | 2.27065 | 5.28483033492612 |
11321 | 11321 | 2013-07-01 | AUD | Australia | 5.035 | 1.089858863 | 4.61986425117506 |
11320 | 11320 | 2013-07-01 | ARS | Argentina | 21.0 | 5.4125 | 3.87990762124711 |
11319 | 11319 | 2013-07-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
10030 | 10030 | 2013-07-01 | ZAR | South Africa | 22.5 | 10.04725 | 2.23941874642315 |
10029 | 10029 | 2013-07-01 | USD | United States | 4.556666667 | 1.0 | 4.556666667 |
10028 | 10028 | 2013-07-01 | UYU | Uruguay | 105.0 | 21.085 | 4.97984349063315 |
10027 | 10027 | 2013-07-01 | UAH | Ukraine | 19.0 | 8.155 | 2.3298589822195 |
10026 | 10026 | 2013-07-01 | TWD | Taiwan | 79.0 | 30.0285 | 2.63083404099439 |
10025 | 10025 | 2013-07-01 | TRY | Turkey | 8.5 | 1.95745 | 4.34238422437355 |
10024 | 10024 | 2013-07-01 | THB | Thailand | 89.0 | 31.275 | 2.8457234212629903 |
10023 | 10023 | 2013-07-01 | SEK | Sweden | 41.61 | 6.7583 | 6.156873770030921 |
10022 | 10022 | 2013-07-01 | SGD | Singapore | 4.7 | 1.2747 | 3.68714207264454 |
10021 | 10021 | 2013-07-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
10020 | 10020 | 2013-07-01 | RUB | Russia | 87.0 | 32.9389 | 2.64125395808603 |
10019 | 10019 | 2013-07-01 | PLN | Poland | 9.2 | 3.3655 | 2.7336205615807496 |
10018 | 10018 | 2013-07-01 | PHP | Philippines | 115.21 | 43.44 | 2.6521639042357297 |
10017 | 10017 | 2013-07-01 | PEN | Peru | 10.0 | 2.783 | 3.5932446999640697 |
10016 | 10016 | 2013-07-01 | PKR | Pakistan | 300.0 | 100.035 | 2.99895036737142 |
10015 | 10015 | 2013-07-01 | NZD | New Zealand | 5.5 | 1.279344975 | 4.29907500125211 |
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 );