bigmac
560 rows where "date" is on date 2018-07-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
11758 | 11758 | 2018-07-01 | CRC | Costa Rica | 2290.0 | 567.8 | 4.03311025008806 |
11757 | 11757 | 2018-07-01 | COP | Colombia | 11900.0 | 2874.07 | 4.14046978674841 |
11756 | 11756 | 2018-07-01 | CNY | China | 20.5 | 6.622000000000001 | 3.09574146783449 |
11755 | 11755 | 2018-07-01 | CLP | Chile | 2640.0 | 651.73 | 4.05075721541129 |
11754 | 11754 | 2018-07-01 | CHF | Switzerland | 6.5 | 0.99325 | 6.54417316889001 |
11753 | 11753 | 2018-07-01 | CAD | Canada | 6.65 | 1.31235 | 5.067245780470151 |
11752 | 11752 | 2018-07-01 | BRL | Brazil | 16.9 | 3.83835 | 4.4029335521773705 |
11751 | 11751 | 2018-07-01 | BHD | Bahrain | 1.2 | 0.37955 | 3.161638782769069 |
11750 | 11750 | 2018-07-01 | AZN | Azerbaijan | 3.95 | 1.70175 | 2.32114000293815 |
11749 | 11749 | 2018-07-01 | AUD | Australia | 6.05 | 1.33985395591881 | 4.51541749999998 |
11748 | 11748 | 2018-07-01 | ARS | Argentina | 75.0 | 27.725 | 2.705139765554549 |
11747 | 11747 | 2018-07-01 | AED | United Arab Emirates | 14.0 | 3.67315 | 3.81144249486136 |
10472 | 10472 | 2018-07-01 | ZAR | South Africa | 31.0 | 13.3619 | 2.32002933714517 |
10471 | 10471 | 2018-07-01 | VND | Vietnam | 65000.0 | 23039.5 | 2.82124178042058 |
10470 | 10470 | 2018-07-01 | USD | United States | 5.51 | 1.0 | 5.51 |
10469 | 10469 | 2018-07-01 | UYU | Uruguay | 140.0 | 31.31 | 4.47141488342383 |
10468 | 10468 | 2018-07-01 | UAH | Ukraine | 50.0 | 26.199 | 1.90846978892324 |
10467 | 10467 | 2018-07-01 | TWD | Taiwan | 69.0 | 30.3725 | 2.27179191703021 |
10466 | 10466 | 2018-07-01 | TRY | Turkey | 10.75 | 4.70625 | 2.28419654714475 |
10465 | 10465 | 2018-07-01 | THB | Thailand | 119.0 | 33.17 | 3.5875791377751 |
10464 | 10464 | 2018-07-01 | SEK | Sweden | 51.0 | 8.7526 | 5.826840024678379 |
10463 | 10463 | 2018-07-01 | SGD | Singapore | 5.8 | 1.35585 | 4.27775933915994 |
10462 | 10462 | 2018-07-01 | SAR | Saudi Arabia | 12.0 | 3.7504 | 3.19965870307167 |
10461 | 10461 | 2018-07-01 | RUB | Russia | 130.0 | 62.14065 | 2.09202832606353 |
10460 | 10460 | 2018-07-01 | RON | Romania | 9.2 | 3.97325 | 2.3154848046309704 |
10459 | 10459 | 2018-07-01 | QAR | Qatar | 12.0 | 3.641 | 3.29579785773139 |
10458 | 10458 | 2018-07-01 | PLN | Poland | 10.1 | 3.68695 | 2.73939163807483 |
10457 | 10457 | 2018-07-01 | PHP | Philippines | 140.0 | 53.487 | 2.6174584478471403 |
10456 | 10456 | 2018-07-01 | PEN | Peru | 10.5 | 3.2715 | 3.20953690967446 |
10455 | 10455 | 2018-07-01 | PKR | Pakistan | 375.0 | 121.49 | 3.0866738003127794 |
10454 | 10454 | 2018-07-01 | OMR | Oman | 1.05 | 0.385 | 2.7272727272727297 |
10453 | 10453 | 2018-07-01 | NZD | New Zealand | 6.2 | 1.46434324205594 | 4.23397999999999 |
10452 | 10452 | 2018-07-01 | NOK | Norway | 42.0 | 8.0415 | 5.22290617422123 |
10451 | 10451 | 2018-07-01 | NIO | Nicaragua | 103.0 | 31.5872 | 3.26081450714213 |
10450 | 10450 | 2018-07-01 | MYR | Malaysia | 8.45 | 4.0225 | 2.10068365444375 |
10449 | 10449 | 2018-07-01 | MXN | Mexico | 49.0 | 19.0515 | 2.57197595989817 |
10448 | 10448 | 2018-07-01 | MDL | Moldova | 43.0 | 16.6526 | 2.58217935937932 |
10447 | 10447 | 2018-07-01 | LKR | Sri Lanka | 580.0 | 159.27 | 3.6416148678344897 |
10446 | 10446 | 2018-07-01 | LBP | Lebanon | 6500.0 | 1511.0 | 4.3017868960953 |
10445 | 10445 | 2018-07-01 | KWD | Kuwait | 1.05 | 0.3025 | 3.47107438016529 |
10444 | 10444 | 2018-07-01 | KRW | South Korea | 4500.0 | 1116.0 | 4.03225806451613 |
10443 | 10443 | 2018-07-01 | JPY | Japan | 390.0 | 111.25 | 3.50561797752809 |
10442 | 10442 | 2018-07-01 | JOD | Jordan | 1.95 | 0.71005 | 2.74628547285402 |
10441 | 10441 | 2018-07-01 | ILS | Israel | 17.0 | 3.6349 | 4.67688244518419 |
10440 | 10440 | 2018-07-01 | INR | India | 173.0 | 68.825 | 2.51362150381402 |
10439 | 10439 | 2018-07-01 | IDR | Indonesia | 31500.0 | 14360.0 | 2.19359331476323 |
10438 | 10438 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
10437 | 10437 | 2018-07-01 | HRK | Croatia | 21.0 | 6.31275 | 3.32660092669597 |
10436 | 10436 | 2018-07-01 | HNL | Honduras | 85.0 | 23.9926 | 3.5427590173636903 |
10435 | 10435 | 2018-07-01 | HKD | Hong Kong | 20.0 | 7.84825 | 2.54833880164368 |
10434 | 10434 | 2018-07-01 | GTQ | Guatemala | 25.0 | 7.4871 | 3.33907654499072 |
10433 | 10433 | 2018-07-01 | GBP | Britain | 3.19 | 0.7538635506973241 | 4.231535 |
10432 | 10432 | 2018-07-01 | EUR | Euro area | 4.04 | 0.8532059212490941 | 4.735082 |
10431 | 10431 | 2018-07-01 | EGP | Egypt | 31.37 | 17.905 | 1.7520245741413 |
10430 | 10430 | 2018-07-01 | DKK | Denmark | 30.0 | 6.3591 | 4.71764872387602 |
10429 | 10429 | 2018-07-01 | CZK | Czech Republic | 75.0 | 22.06475 | 3.39908677868546 |
10428 | 10428 | 2018-07-01 | CRC | Costa Rica | 2290.0 | 567.8 | 4.03311025008806 |
10427 | 10427 | 2018-07-01 | COP | Colombia | 11900.0 | 2874.07 | 4.14046978674841 |
10426 | 10426 | 2018-07-01 | CNY | China | 20.5 | 6.622000000000001 | 3.09574146783449 |
10425 | 10425 | 2018-07-01 | CLP | Chile | 2640.0 | 651.73 | 4.05075721541129 |
10424 | 10424 | 2018-07-01 | CHF | Switzerland | 6.5 | 0.99325 | 6.54417316889001 |
10423 | 10423 | 2018-07-01 | CAD | Canada | 6.65 | 1.31235 | 5.067245780470151 |
10422 | 10422 | 2018-07-01 | BRL | Brazil | 16.9 | 3.83835 | 4.4029335521773705 |
10421 | 10421 | 2018-07-01 | BHD | Bahrain | 1.2 | 0.37955 | 3.161638782769069 |
10420 | 10420 | 2018-07-01 | AZN | Azerbaijan | 3.95 | 1.70175 | 2.32114000293815 |
10419 | 10419 | 2018-07-01 | AUD | Australia | 6.05 | 1.33985395591881 | 4.51541749999998 |
10418 | 10418 | 2018-07-01 | ARS | Argentina | 75.0 | 27.725 | 2.705139765554549 |
10417 | 10417 | 2018-07-01 | AED | United Arab Emirates | 14.0 | 3.67315 | 3.81144249486136 |
9142 | 9142 | 2018-07-01 | ZAR | South Africa | 31.0 | 13.3619 | 2.32002933714517 |
9141 | 9141 | 2018-07-01 | VND | Vietnam | 65000.0 | 23039.5 | 2.82124178042058 |
9140 | 9140 | 2018-07-01 | USD | United States | 5.51 | 1.0 | 5.51 |
9139 | 9139 | 2018-07-01 | UYU | Uruguay | 140.0 | 31.31 | 4.47141488342383 |
9138 | 9138 | 2018-07-01 | UAH | Ukraine | 50.0 | 26.199 | 1.90846978892324 |
9137 | 9137 | 2018-07-01 | TWD | Taiwan | 69.0 | 30.3725 | 2.27179191703021 |
9136 | 9136 | 2018-07-01 | TRY | Turkey | 10.75 | 4.70625 | 2.28419654714475 |
9135 | 9135 | 2018-07-01 | THB | Thailand | 119.0 | 33.17 | 3.5875791377751 |
9134 | 9134 | 2018-07-01 | SEK | Sweden | 51.0 | 8.7526 | 5.826840024678379 |
9133 | 9133 | 2018-07-01 | SGD | Singapore | 5.8 | 1.35585 | 4.27775933915994 |
9132 | 9132 | 2018-07-01 | SAR | Saudi Arabia | 12.0 | 3.7504 | 3.19965870307167 |
9131 | 9131 | 2018-07-01 | RUB | Russia | 130.0 | 62.14065 | 2.09202832606353 |
9130 | 9130 | 2018-07-01 | RON | Romania | 9.2 | 3.97325 | 2.3154848046309704 |
9129 | 9129 | 2018-07-01 | QAR | Qatar | 12.0 | 3.641 | 3.29579785773139 |
9128 | 9128 | 2018-07-01 | PLN | Poland | 10.1 | 3.68695 | 2.73939163807483 |
9127 | 9127 | 2018-07-01 | PHP | Philippines | 140.0 | 53.487 | 2.6174584478471403 |
9126 | 9126 | 2018-07-01 | PEN | Peru | 10.5 | 3.2715 | 3.20953690967446 |
9125 | 9125 | 2018-07-01 | PKR | Pakistan | 375.0 | 121.49 | 3.0866738003127794 |
9124 | 9124 | 2018-07-01 | OMR | Oman | 1.05 | 0.385 | 2.7272727272727297 |
9123 | 9123 | 2018-07-01 | NZD | New Zealand | 6.2 | 1.46434324205594 | 4.23397999999999 |
9122 | 9122 | 2018-07-01 | NOK | Norway | 42.0 | 8.0415 | 5.22290617422123 |
9121 | 9121 | 2018-07-01 | NIO | Nicaragua | 103.0 | 31.5872 | 3.26081450714213 |
9120 | 9120 | 2018-07-01 | MYR | Malaysia | 8.45 | 4.0225 | 2.10068365444375 |
9119 | 9119 | 2018-07-01 | MXN | Mexico | 49.0 | 19.0515 | 2.57197595989817 |
9118 | 9118 | 2018-07-01 | MDL | Moldova | 43.0 | 16.6526 | 2.58217935937932 |
9117 | 9117 | 2018-07-01 | LKR | Sri Lanka | 580.0 | 159.27 | 3.6416148678344897 |
9116 | 9116 | 2018-07-01 | LBP | Lebanon | 6500.0 | 1511.0 | 4.3017868960953 |
9115 | 9115 | 2018-07-01 | KWD | Kuwait | 1.05 | 0.3025 | 3.47107438016529 |
9114 | 9114 | 2018-07-01 | KRW | South Korea | 4500.0 | 1116.0 | 4.03225806451613 |
9113 | 9113 | 2018-07-01 | JPY | Japan | 390.0 | 111.25 | 3.50561797752809 |
9112 | 9112 | 2018-07-01 | JOD | Jordan | 1.95 | 0.71005 | 2.74628547285402 |
9111 | 9111 | 2018-07-01 | ILS | Israel | 17.0 | 3.6349 | 4.67688244518419 |
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 );