bigmac
400 rows where "date" is on date 2012-07-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
12606 | 12606 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
12605 | 12605 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
12604 | 12604 | 2012-07-01 | UYU | Uruguay | 99.0 | 21.87 | 4.52674897119342 |
12603 | 12603 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
12602 | 12602 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
12601 | 12601 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
12600 | 12600 | 2012-07-01 | THB | Thailand | 82.0 | 31.7 | 2.58675078864353 |
12599 | 12599 | 2012-07-01 | SEK | Sweden | 39.97301987 | 6.9777 | 5.72868135202144 |
12598 | 12598 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
12597 | 12597 | 2012-07-01 | SAR | Saudi Arabia | 10.0 | 3.75025 | 2.6664889007399504 |
12596 | 12596 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
12595 | 12595 | 2012-07-01 | PLN | Poland | 9.1 | 3.46035 | 2.6297917840680896 |
12594 | 12594 | 2012-07-01 | PHP | Philippines | 118.0 | 42.2 | 2.7962085308056897 |
12593 | 12593 | 2012-07-01 | PKR | Pakistan | 285.0 | 94.605 | 3.01252576502299 |
12592 | 12592 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
12591 | 12591 | 2012-07-01 | NOK | Norway | 43.0 | 6.09205 | 7.05837936326852 |
12590 | 12590 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
12589 | 12589 | 2012-07-01 | MXN | Mexico | 37.0 | 13.687 | 2.70329509753781 |
12588 | 12588 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
12587 | 12587 | 2012-07-01 | KRW | South Korea | 3700.0 | 1151.0 | 3.2145960034752403 |
12586 | 12586 | 2012-07-01 | JPY | Japan | 320.0 | 78.22 | 4.09102531321913 |
12585 | 12585 | 2012-07-01 | ILS | Israel | 11.9 | 4.07625 | 2.91934989267096 |
12584 | 12584 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
12583 | 12583 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
12582 | 12582 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
12581 | 12581 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
12580 | 12580 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
12579 | 12579 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
12578 | 12578 | 2012-07-01 | EGP | Egypt | 16.0 | 6.0665 | 2.63743509437072 |
12577 | 12577 | 2012-07-01 | DKK | Denmark | 28.5 | 6.1356 | 4.6450224916878495 |
12576 | 12576 | 2012-07-01 | CZK | Czech Republic | 70.33 | 21.048 | 3.34141011022425 |
12575 | 12575 | 2012-07-01 | COP | Colombia | 8600.0 | 1804.475 | 4.76592914836725 |
12574 | 12574 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
12573 | 12573 | 2012-07-01 | CLP | Chile | 2050.0 | 493.05 | 4.15779332724876 |
12572 | 12572 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
12571 | 12571 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
12570 | 12570 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
12569 | 12569 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
12568 | 12568 | 2012-07-01 | ARS | Argentina | 19.0 | 4.56625 | 4.16096359156857 |
12567 | 12567 | 2012-07-01 | AED | UAE | 12.0 | 3.67295 | 3.26712860234961 |
11276 | 11276 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
11275 | 11275 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
11274 | 11274 | 2012-07-01 | UYU | Uruguay | 99.0 | 21.87 | 4.52674897119342 |
11273 | 11273 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
11272 | 11272 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
11271 | 11271 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
11270 | 11270 | 2012-07-01 | THB | Thailand | 82.0 | 31.7 | 2.58675078864353 |
11269 | 11269 | 2012-07-01 | SEK | Sweden | 39.97301987 | 6.9777 | 5.72868135202144 |
11268 | 11268 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
11267 | 11267 | 2012-07-01 | SAR | Saudi Arabia | 10.0 | 3.75025 | 2.6664889007399504 |
11266 | 11266 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
11265 | 11265 | 2012-07-01 | PLN | Poland | 9.1 | 3.46035 | 2.6297917840680896 |
11264 | 11264 | 2012-07-01 | PHP | Philippines | 118.0 | 42.2 | 2.7962085308056897 |
11263 | 11263 | 2012-07-01 | PKR | Pakistan | 285.0 | 94.605 | 3.01252576502299 |
11262 | 11262 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
11261 | 11261 | 2012-07-01 | NOK | Norway | 43.0 | 6.09205 | 7.05837936326852 |
11260 | 11260 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
11259 | 11259 | 2012-07-01 | MXN | Mexico | 37.0 | 13.687 | 2.70329509753781 |
11258 | 11258 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
11257 | 11257 | 2012-07-01 | KRW | South Korea | 3700.0 | 1151.0 | 3.2145960034752403 |
11256 | 11256 | 2012-07-01 | JPY | Japan | 320.0 | 78.22 | 4.09102531321913 |
11255 | 11255 | 2012-07-01 | ILS | Israel | 11.9 | 4.07625 | 2.91934989267096 |
11254 | 11254 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
11253 | 11253 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
11252 | 11252 | 2012-07-01 | HUF | Hungary | 830.0 | 238.2151 | 3.48424596089836 |
11251 | 11251 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
11250 | 11250 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
11249 | 11249 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
11248 | 11248 | 2012-07-01 | EGP | Egypt | 16.0 | 6.0665 | 2.63743509437072 |
11247 | 11247 | 2012-07-01 | DKK | Denmark | 28.5 | 6.1356 | 4.6450224916878495 |
11246 | 11246 | 2012-07-01 | CZK | Czech Republic | 70.33 | 21.048 | 3.34141011022425 |
11245 | 11245 | 2012-07-01 | COP | Colombia | 8600.0 | 1804.475 | 4.76592914836725 |
11244 | 11244 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
11243 | 11243 | 2012-07-01 | CLP | Chile | 2050.0 | 493.05 | 4.15779332724876 |
11242 | 11242 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
11241 | 11241 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
11240 | 11240 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
11239 | 11239 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
11238 | 11238 | 2012-07-01 | ARS | Argentina | 19.0 | 4.56625 | 4.16096359156857 |
11237 | 11237 | 2012-07-01 | AED | UAE | 12.0 | 3.67295 | 3.26712860234961 |
9946 | 9946 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
9945 | 9945 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
9944 | 9944 | 2012-07-01 | UYU | Uruguay | 99.0 | 21.87 | 4.52674897119342 |
9943 | 9943 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
9942 | 9942 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
9941 | 9941 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
9940 | 9940 | 2012-07-01 | THB | Thailand | 82.0 | 31.7 | 2.58675078864353 |
9939 | 9939 | 2012-07-01 | SEK | Sweden | 39.97301987 | 6.9777 | 5.72868135202144 |
9938 | 9938 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
9937 | 9937 | 2012-07-01 | SAR | Saudi Arabia | 10.0 | 3.75025 | 2.6664889007399504 |
9936 | 9936 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
9935 | 9935 | 2012-07-01 | PLN | Poland | 9.1 | 3.46035 | 2.6297917840680896 |
9934 | 9934 | 2012-07-01 | PHP | Philippines | 118.0 | 42.2 | 2.7962085308056897 |
9933 | 9933 | 2012-07-01 | PKR | Pakistan | 285.0 | 94.605 | 3.01252576502299 |
9932 | 9932 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
9931 | 9931 | 2012-07-01 | NOK | Norway | 43.0 | 6.09205 | 7.05837936326852 |
9930 | 9930 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
9929 | 9929 | 2012-07-01 | MXN | Mexico | 37.0 | 13.687 | 2.70329509753781 |
9928 | 9928 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
9927 | 9927 | 2012-07-01 | KRW | South Korea | 3700.0 | 1151.0 | 3.2145960034752403 |
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 );