bigmac
420 rows where "date" is on date 2014-01-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
12732 | 12732 | 2014-01-01 | ZAR | South Africa | 23.5 | 10.87765 | 2.16039309961251 |
12731 | 12731 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
12730 | 12730 | 2014-01-01 | UYU | Uruguay | 105.0 | 21.38 | 4.911131898971 |
12729 | 12729 | 2014-01-01 | UAH | Ukraine | 19.0 | 8.379 | 2.2675736961451203 |
12728 | 12728 | 2014-01-01 | TWD | Taiwan | 79.0 | 30.161 | 2.6192765491860404 |
12727 | 12727 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
12726 | 12726 | 2014-01-01 | THB | Thailand | 96.0 | 32.875 | 2.92015209125475 |
12725 | 12725 | 2014-01-01 | SEK | Sweden | 40.7 | 6.47315 | 6.287510717347809 |
12724 | 12724 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
12723 | 12723 | 2014-01-01 | SAR | Saudi Arabia | 11.0 | 3.7504 | 2.9330204778157003 |
12722 | 12722 | 2014-01-01 | RUB | Russia | 89.0 | 33.93925 | 2.62233255007108 |
12721 | 12721 | 2014-01-01 | PLN | Poland | 9.2 | 3.0684 | 2.99830530569678 |
12720 | 12720 | 2014-01-01 | PHP | Philippines | 135.0 | 45.23 | 2.98474463851426 |
12719 | 12719 | 2014-01-01 | PEN | Peru | 10.0 | 2.8065 | 3.56315695706396 |
12718 | 12718 | 2014-01-01 | PKR | Pakistan | 320.0 | 105.415 | 3.03562111653939 |
12717 | 12717 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
12716 | 12716 | 2014-01-01 | NOK | Norway | 48.0 | 6.15745 | 7.79543479849613 |
12715 | 12715 | 2014-01-01 | MYR | Malaysia | 7.4 | 3.3235 | 2.2265683767113 |
12714 | 12714 | 2014-01-01 | MXN | Mexico | 37.0 | 13.33275 | 2.77512141156176 |
12713 | 12713 | 2014-01-01 | LKR | Sri Lanka | 350.0 | 130.8 | 2.67584097859327 |
12712 | 12712 | 2014-01-01 | KRW | South Korea | 3700.0 | 1067.3 | 3.46669165183173 |
12711 | 12711 | 2014-01-01 | JPY | Japan | 310.0 | 104.245 | 2.97376372967528 |
12710 | 12710 | 2014-01-01 | ILS | Israel | 17.5 | 3.4882 | 5.01691416776561 |
12709 | 12709 | 2014-01-01 | INR | India | 95.0 | 61.845 | 1.5360983102918602 |
12708 | 12708 | 2014-01-01 | IDR | Indonesia | 27939.0 | 12140.0 | 2.30140032948929 |
12707 | 12707 | 2014-01-01 | HUF | Hungary | 860.0 | 223.09705 | 3.8548246155652897 |
12706 | 12706 | 2014-01-01 | HKD | Hong Kong | 18.0 | 7.75785 | 2.32023047622731 |
12705 | 12705 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
12704 | 12704 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
12703 | 12703 | 2014-01-01 | EGP | Egypt | 16.93 | 6.961 | 2.43212182157736 |
12702 | 12702 | 2014-01-01 | DKK | Denmark | 28.5 | 5.5014 | 5.18049950921584 |
12701 | 12701 | 2014-01-01 | CZK | Czech Republic | 70.45 | 20.2838 | 3.47321507804258 |
12700 | 12700 | 2014-01-01 | CRC | Costa Rica | 2150.0 | 501.92 | 4.2835511635320405 |
12699 | 12699 | 2014-01-01 | COP | Colombia | 8600.0 | 1982.795 | 4.33731172410663 |
12698 | 12698 | 2014-01-01 | CNY | China | 16.6 | 6.0513 | 2.74321220233669 |
12697 | 12697 | 2014-01-01 | CLP | Chile | 2000.0 | 541.95 | 3.6903773410831295 |
12696 | 12696 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
12695 | 12695 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
12694 | 12694 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
12693 | 12693 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
12692 | 12692 | 2014-01-01 | ARS | Argentina | 21.0 | 6.92125 | 3.03413400758534 |
12691 | 12691 | 2014-01-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
11402 | 11402 | 2014-01-01 | ZAR | South Africa | 23.5 | 10.87765 | 2.16039309961251 |
11401 | 11401 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
11400 | 11400 | 2014-01-01 | UYU | Uruguay | 105.0 | 21.38 | 4.911131898971 |
11399 | 11399 | 2014-01-01 | UAH | Ukraine | 19.0 | 8.379 | 2.2675736961451203 |
11398 | 11398 | 2014-01-01 | TWD | Taiwan | 79.0 | 30.161 | 2.6192765491860404 |
11397 | 11397 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
11396 | 11396 | 2014-01-01 | THB | Thailand | 96.0 | 32.875 | 2.92015209125475 |
11395 | 11395 | 2014-01-01 | SEK | Sweden | 40.7 | 6.47315 | 6.287510717347809 |
11394 | 11394 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
11393 | 11393 | 2014-01-01 | SAR | Saudi Arabia | 11.0 | 3.7504 | 2.9330204778157003 |
11392 | 11392 | 2014-01-01 | RUB | Russia | 89.0 | 33.93925 | 2.62233255007108 |
11391 | 11391 | 2014-01-01 | PLN | Poland | 9.2 | 3.0684 | 2.99830530569678 |
11390 | 11390 | 2014-01-01 | PHP | Philippines | 135.0 | 45.23 | 2.98474463851426 |
11389 | 11389 | 2014-01-01 | PEN | Peru | 10.0 | 2.8065 | 3.56315695706396 |
11388 | 11388 | 2014-01-01 | PKR | Pakistan | 320.0 | 105.415 | 3.03562111653939 |
11387 | 11387 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
11386 | 11386 | 2014-01-01 | NOK | Norway | 48.0 | 6.15745 | 7.79543479849613 |
11385 | 11385 | 2014-01-01 | MYR | Malaysia | 7.4 | 3.3235 | 2.2265683767113 |
11384 | 11384 | 2014-01-01 | MXN | Mexico | 37.0 | 13.33275 | 2.77512141156176 |
11383 | 11383 | 2014-01-01 | LKR | Sri Lanka | 350.0 | 130.8 | 2.67584097859327 |
11382 | 11382 | 2014-01-01 | KRW | South Korea | 3700.0 | 1067.3 | 3.46669165183173 |
11381 | 11381 | 2014-01-01 | JPY | Japan | 310.0 | 104.245 | 2.97376372967528 |
11380 | 11380 | 2014-01-01 | ILS | Israel | 17.5 | 3.4882 | 5.01691416776561 |
11379 | 11379 | 2014-01-01 | INR | India | 95.0 | 61.845 | 1.5360983102918602 |
11378 | 11378 | 2014-01-01 | IDR | Indonesia | 27939.0 | 12140.0 | 2.30140032948929 |
11377 | 11377 | 2014-01-01 | HUF | Hungary | 860.0 | 223.09705 | 3.8548246155652897 |
11376 | 11376 | 2014-01-01 | HKD | Hong Kong | 18.0 | 7.75785 | 2.32023047622731 |
11375 | 11375 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
11374 | 11374 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
11373 | 11373 | 2014-01-01 | EGP | Egypt | 16.93 | 6.961 | 2.43212182157736 |
11372 | 11372 | 2014-01-01 | DKK | Denmark | 28.5 | 5.5014 | 5.18049950921584 |
11371 | 11371 | 2014-01-01 | CZK | Czech Republic | 70.45 | 20.2838 | 3.47321507804258 |
11370 | 11370 | 2014-01-01 | CRC | Costa Rica | 2150.0 | 501.92 | 4.2835511635320405 |
11369 | 11369 | 2014-01-01 | COP | Colombia | 8600.0 | 1982.795 | 4.33731172410663 |
11368 | 11368 | 2014-01-01 | CNY | China | 16.6 | 6.0513 | 2.74321220233669 |
11367 | 11367 | 2014-01-01 | CLP | Chile | 2000.0 | 541.95 | 3.6903773410831295 |
11366 | 11366 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
11365 | 11365 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
11364 | 11364 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
11363 | 11363 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
11362 | 11362 | 2014-01-01 | ARS | Argentina | 21.0 | 6.92125 | 3.03413400758534 |
11361 | 11361 | 2014-01-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
10072 | 10072 | 2014-01-01 | ZAR | South Africa | 23.5 | 10.87765 | 2.16039309961251 |
10071 | 10071 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
10070 | 10070 | 2014-01-01 | UYU | Uruguay | 105.0 | 21.38 | 4.911131898971 |
10069 | 10069 | 2014-01-01 | UAH | Ukraine | 19.0 | 8.379 | 2.2675736961451203 |
10068 | 10068 | 2014-01-01 | TWD | Taiwan | 79.0 | 30.161 | 2.6192765491860404 |
10067 | 10067 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
10066 | 10066 | 2014-01-01 | THB | Thailand | 96.0 | 32.875 | 2.92015209125475 |
10065 | 10065 | 2014-01-01 | SEK | Sweden | 40.7 | 6.47315 | 6.287510717347809 |
10064 | 10064 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
10063 | 10063 | 2014-01-01 | SAR | Saudi Arabia | 11.0 | 3.7504 | 2.9330204778157003 |
10062 | 10062 | 2014-01-01 | RUB | Russia | 89.0 | 33.93925 | 2.62233255007108 |
10061 | 10061 | 2014-01-01 | PLN | Poland | 9.2 | 3.0684 | 2.99830530569678 |
10060 | 10060 | 2014-01-01 | PHP | Philippines | 135.0 | 45.23 | 2.98474463851426 |
10059 | 10059 | 2014-01-01 | PEN | Peru | 10.0 | 2.8065 | 3.56315695706396 |
10058 | 10058 | 2014-01-01 | PKR | Pakistan | 320.0 | 105.415 | 3.03562111653939 |
10057 | 10057 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
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 );