bigmac
420 rows where "date" is on date 2011-07-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
12524 | 12524 | 2011-07-01 | ZAR | South Africa | 19.45 | 6.76885 | 2.87345708650657 |
12523 | 12523 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
12522 | 12522 | 2011-07-01 | UYU | Uruguay | 90.0 | 18.45 | 4.87804878048781 |
12521 | 12521 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
12520 | 12520 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
12519 | 12519 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
12518 | 12518 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
12517 | 12517 | 2011-07-01 | SEK | Sweden | 48.4 | 6.3352 | 7.6398535168581905 |
12516 | 12516 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
12515 | 12515 | 2011-07-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
12514 | 12514 | 2011-07-01 | RUB | Russia | 75.0 | 27.7525 | 2.70245923790649 |
12513 | 12513 | 2011-07-01 | PLN | Poland | 8.63 | 2.7968 | 3.08566933638444 |
12512 | 12512 | 2011-07-01 | PHP | Philippines | 118.0 | 42.41 | 2.78236265031832 |
12511 | 12511 | 2011-07-01 | PEN | Peru | 10.0 | 2.7375 | 3.65296803652968 |
12510 | 12510 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
12509 | 12509 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
12508 | 12508 | 2011-07-01 | NOK | Norway | 45.0 | 5.41405 | 8.31170750177778 |
12507 | 12507 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
12506 | 12506 | 2011-07-01 | MXN | Mexico | 32.0 | 11.67075 | 2.74189747873958 |
12505 | 12505 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
12504 | 12504 | 2011-07-01 | KRW | South Korea | 3700.0 | 1056.2 | 3.50312440825601 |
12503 | 12503 | 2011-07-01 | JPY | Japan | 320.0 | 78.365 | 4.08345562432208 |
12502 | 12502 | 2011-07-01 | ILS | Israel | 15.9 | 3.40335 | 4.67186742474327 |
12501 | 12501 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
12500 | 12500 | 2011-07-01 | IDR | Indonesia | 22534.0 | 8523.0 | 2.64390472838203 |
12499 | 12499 | 2011-07-01 | HUF | Hungary | 760.0 | 188.0724 | 4.04099697775963 |
12498 | 12498 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
12497 | 12497 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
12496 | 12496 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
12495 | 12495 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
12494 | 12494 | 2011-07-01 | DKK | Denmark | 28.5 | 5.19845 | 5.48240340870837 |
12493 | 12493 | 2011-07-01 | CZK | Czech Republic | 69.32 | 17.0219 | 4.072400848318931 |
12492 | 12492 | 2011-07-01 | CRC | Costa Rica | 2050.0 | 504.305 | 4.06500034701222 |
12491 | 12491 | 2011-07-01 | COP | Colombia | 8400.0 | 1770.5 | 4.74442247952556 |
12490 | 12490 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
12489 | 12489 | 2011-07-01 | CLP | Chile | 1850.0 | 462.75 | 3.99783900594273 |
12488 | 12488 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
12487 | 12487 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
12486 | 12486 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
12485 | 12485 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
12484 | 12484 | 2011-07-01 | ARS | Argentina | 20.0 | 4.1325 | 4.83968542044767 |
12483 | 12483 | 2011-07-01 | AED | UAE | 12.0 | 3.67305 | 3.2670396536938 |
11194 | 11194 | 2011-07-01 | ZAR | South Africa | 19.45 | 6.76885 | 2.87345708650657 |
11193 | 11193 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
11192 | 11192 | 2011-07-01 | UYU | Uruguay | 90.0 | 18.45 | 4.87804878048781 |
11191 | 11191 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
11190 | 11190 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
11189 | 11189 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
11188 | 11188 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
11187 | 11187 | 2011-07-01 | SEK | Sweden | 48.4 | 6.3352 | 7.6398535168581905 |
11186 | 11186 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
11185 | 11185 | 2011-07-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
11184 | 11184 | 2011-07-01 | RUB | Russia | 75.0 | 27.7525 | 2.70245923790649 |
11183 | 11183 | 2011-07-01 | PLN | Poland | 8.63 | 2.7968 | 3.08566933638444 |
11182 | 11182 | 2011-07-01 | PHP | Philippines | 118.0 | 42.41 | 2.78236265031832 |
11181 | 11181 | 2011-07-01 | PEN | Peru | 10.0 | 2.7375 | 3.65296803652968 |
11180 | 11180 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
11179 | 11179 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
11178 | 11178 | 2011-07-01 | NOK | Norway | 45.0 | 5.41405 | 8.31170750177778 |
11177 | 11177 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
11176 | 11176 | 2011-07-01 | MXN | Mexico | 32.0 | 11.67075 | 2.74189747873958 |
11175 | 11175 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
11174 | 11174 | 2011-07-01 | KRW | South Korea | 3700.0 | 1056.2 | 3.50312440825601 |
11173 | 11173 | 2011-07-01 | JPY | Japan | 320.0 | 78.365 | 4.08345562432208 |
11172 | 11172 | 2011-07-01 | ILS | Israel | 15.9 | 3.40335 | 4.67186742474327 |
11171 | 11171 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
11170 | 11170 | 2011-07-01 | IDR | Indonesia | 22534.0 | 8523.0 | 2.64390472838203 |
11169 | 11169 | 2011-07-01 | HUF | Hungary | 760.0 | 188.0724 | 4.04099697775963 |
11168 | 11168 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
11167 | 11167 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
11166 | 11166 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
11165 | 11165 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
11164 | 11164 | 2011-07-01 | DKK | Denmark | 28.5 | 5.19845 | 5.48240340870837 |
11163 | 11163 | 2011-07-01 | CZK | Czech Republic | 69.32 | 17.0219 | 4.072400848318931 |
11162 | 11162 | 2011-07-01 | CRC | Costa Rica | 2050.0 | 504.305 | 4.06500034701222 |
11161 | 11161 | 2011-07-01 | COP | Colombia | 8400.0 | 1770.5 | 4.74442247952556 |
11160 | 11160 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
11159 | 11159 | 2011-07-01 | CLP | Chile | 1850.0 | 462.75 | 3.99783900594273 |
11158 | 11158 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
11157 | 11157 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
11156 | 11156 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
11155 | 11155 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
11154 | 11154 | 2011-07-01 | ARS | Argentina | 20.0 | 4.1325 | 4.83968542044767 |
11153 | 11153 | 2011-07-01 | AED | UAE | 12.0 | 3.67305 | 3.2670396536938 |
9864 | 9864 | 2011-07-01 | ZAR | South Africa | 19.45 | 6.76885 | 2.87345708650657 |
9863 | 9863 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
9862 | 9862 | 2011-07-01 | UYU | Uruguay | 90.0 | 18.45 | 4.87804878048781 |
9861 | 9861 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
9860 | 9860 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
9859 | 9859 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
9858 | 9858 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
9857 | 9857 | 2011-07-01 | SEK | Sweden | 48.4 | 6.3352 | 7.6398535168581905 |
9856 | 9856 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
9855 | 9855 | 2011-07-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
9854 | 9854 | 2011-07-01 | RUB | Russia | 75.0 | 27.7525 | 2.70245923790649 |
9853 | 9853 | 2011-07-01 | PLN | Poland | 8.63 | 2.7968 | 3.08566933638444 |
9852 | 9852 | 2011-07-01 | PHP | Philippines | 118.0 | 42.41 | 2.78236265031832 |
9851 | 9851 | 2011-07-01 | PEN | Peru | 10.0 | 2.7375 | 3.65296803652968 |
9850 | 9850 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
9849 | 9849 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
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 );