bigmac
420 rows where "date" is on date 2012-01-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
12566 | 12566 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
12565 | 12565 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
12564 | 12564 | 2012-01-01 | UYU | Uruguay | 90.0 | 19.45 | 4.62724935732648 |
12563 | 12563 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
12562 | 12562 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
12561 | 12561 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
12560 | 12560 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
12559 | 12559 | 2012-01-01 | SEK | Sweden | 41.0 | 6.9338 | 5.91306354379994 |
12558 | 12558 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
12557 | 12557 | 2012-01-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
12556 | 12556 | 2012-01-01 | RUB | Russia | 81.0 | 31.7693 | 2.54963124777694 |
12555 | 12555 | 2012-01-01 | PLN | Poland | 9.1 | 3.52045 | 2.58489681716826 |
12554 | 12554 | 2012-01-01 | PHP | Philippines | 118.0 | 44.005 | 2.6815134643790497 |
12553 | 12553 | 2012-01-01 | PEN | Peru | 10.0 | 2.6925 | 3.71402042711235 |
12552 | 12552 | 2012-01-01 | PKR | Pakistan | 260.0 | 90.05 | 2.88728484175458 |
12551 | 12551 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
12550 | 12550 | 2012-01-01 | NOK | Norway | 41.0 | 6.0399 | 6.78819185748108 |
12549 | 12549 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
12548 | 12548 | 2012-01-01 | MXN | Mexico | 37.0 | 13.6844 | 2.7038087164946902 |
12547 | 12547 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
12546 | 12546 | 2012-01-01 | KRW | South Korea | 3700.0 | 1158.75 | 3.19309600862999 |
12545 | 12545 | 2012-01-01 | JPY | Japan | 320.0 | 76.92 | 4.16016640665627 |
12544 | 12544 | 2012-01-01 | ILS | Israel | 15.9 | 3.8485 | 4.13147979732363 |
12543 | 12543 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
12542 | 12542 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
12541 | 12541 | 2012-01-01 | HUF | Hungary | 645.0 | 245.69425 | 2.6252140617861404 |
12540 | 12540 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
12539 | 12539 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
12538 | 12538 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
12537 | 12537 | 2012-01-01 | EGP | Egypt | 15.5 | 6.037000000000001 | 2.56750041411297 |
12536 | 12536 | 2012-01-01 | DKK | Denmark | 31.5 | 5.86135 | 5.374188540182719 |
12535 | 12535 | 2012-01-01 | CZK | Czech Republic | 70.22 | 20.36535 | 3.44801341494254 |
12534 | 12534 | 2012-01-01 | CRC | Costa Rica | 2050.0 | 509.54 | 4.02323664481689 |
12533 | 12533 | 2012-01-01 | COP | Colombia | 8400.0 | 1852.15 | 4.535269821558731 |
12532 | 12532 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
12531 | 12531 | 2012-01-01 | CLP | Chile | 2050.0 | 506.05 | 4.0509831044363205 |
12530 | 12530 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
12529 | 12529 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
12528 | 12528 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
12527 | 12527 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
12526 | 12526 | 2012-01-01 | ARS | Argentina | 20.0 | 4.3135 | 4.63660600440478 |
12525 | 12525 | 2012-01-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
11236 | 11236 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
11235 | 11235 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
11234 | 11234 | 2012-01-01 | UYU | Uruguay | 90.0 | 19.45 | 4.62724935732648 |
11233 | 11233 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
11232 | 11232 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
11231 | 11231 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
11230 | 11230 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
11229 | 11229 | 2012-01-01 | SEK | Sweden | 41.0 | 6.9338 | 5.91306354379994 |
11228 | 11228 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
11227 | 11227 | 2012-01-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
11226 | 11226 | 2012-01-01 | RUB | Russia | 81.0 | 31.7693 | 2.54963124777694 |
11225 | 11225 | 2012-01-01 | PLN | Poland | 9.1 | 3.52045 | 2.58489681716826 |
11224 | 11224 | 2012-01-01 | PHP | Philippines | 118.0 | 44.005 | 2.6815134643790497 |
11223 | 11223 | 2012-01-01 | PEN | Peru | 10.0 | 2.6925 | 3.71402042711235 |
11222 | 11222 | 2012-01-01 | PKR | Pakistan | 260.0 | 90.05 | 2.88728484175458 |
11221 | 11221 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
11220 | 11220 | 2012-01-01 | NOK | Norway | 41.0 | 6.0399 | 6.78819185748108 |
11219 | 11219 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
11218 | 11218 | 2012-01-01 | MXN | Mexico | 37.0 | 13.6844 | 2.7038087164946902 |
11217 | 11217 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
11216 | 11216 | 2012-01-01 | KRW | South Korea | 3700.0 | 1158.75 | 3.19309600862999 |
11215 | 11215 | 2012-01-01 | JPY | Japan | 320.0 | 76.92 | 4.16016640665627 |
11214 | 11214 | 2012-01-01 | ILS | Israel | 15.9 | 3.8485 | 4.13147979732363 |
11213 | 11213 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
11212 | 11212 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
11211 | 11211 | 2012-01-01 | HUF | Hungary | 645.0 | 245.69425 | 2.6252140617861404 |
11210 | 11210 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
11209 | 11209 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
11208 | 11208 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
11207 | 11207 | 2012-01-01 | EGP | Egypt | 15.5 | 6.037000000000001 | 2.56750041411297 |
11206 | 11206 | 2012-01-01 | DKK | Denmark | 31.5 | 5.86135 | 5.374188540182719 |
11205 | 11205 | 2012-01-01 | CZK | Czech Republic | 70.22 | 20.36535 | 3.44801341494254 |
11204 | 11204 | 2012-01-01 | CRC | Costa Rica | 2050.0 | 509.54 | 4.02323664481689 |
11203 | 11203 | 2012-01-01 | COP | Colombia | 8400.0 | 1852.15 | 4.535269821558731 |
11202 | 11202 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
11201 | 11201 | 2012-01-01 | CLP | Chile | 2050.0 | 506.05 | 4.0509831044363205 |
11200 | 11200 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
11199 | 11199 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
11198 | 11198 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
11197 | 11197 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
11196 | 11196 | 2012-01-01 | ARS | Argentina | 20.0 | 4.3135 | 4.63660600440478 |
11195 | 11195 | 2012-01-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
9906 | 9906 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
9905 | 9905 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
9904 | 9904 | 2012-01-01 | UYU | Uruguay | 90.0 | 19.45 | 4.62724935732648 |
9903 | 9903 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
9902 | 9902 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
9901 | 9901 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
9900 | 9900 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
9899 | 9899 | 2012-01-01 | SEK | Sweden | 41.0 | 6.9338 | 5.91306354379994 |
9898 | 9898 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
9897 | 9897 | 2012-01-01 | SAR | Saudi Arabia | 10.0 | 3.7502 | 2.66652445202923 |
9896 | 9896 | 2012-01-01 | RUB | Russia | 81.0 | 31.7693 | 2.54963124777694 |
9895 | 9895 | 2012-01-01 | PLN | Poland | 9.1 | 3.52045 | 2.58489681716826 |
9894 | 9894 | 2012-01-01 | PHP | Philippines | 118.0 | 44.005 | 2.6815134643790497 |
9893 | 9893 | 2012-01-01 | PEN | Peru | 10.0 | 2.6925 | 3.71402042711235 |
9892 | 9892 | 2012-01-01 | PKR | Pakistan | 260.0 | 90.05 | 2.88728484175458 |
9891 | 9891 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
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 );