bigmac
560 rows where "date" is on date 2018-07-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
5129 | 5129 | 2018-07-01 | MXN | Mexico | 49.0 | 19.0515 | 2.57197595989817 |
5130 | 5130 | 2018-07-01 | MYR | Malaysia | 8.45 | 4.0225 | 2.10068365444375 |
5131 | 5131 | 2018-07-01 | NIO | Nicaragua | 103.0 | 31.5872 | 3.26081450714213 |
5132 | 5132 | 2018-07-01 | NOK | Norway | 42.0 | 8.0415 | 5.22290617422123 |
5133 | 5133 | 2018-07-01 | NZD | New Zealand | 6.2 | 1.46434324205594 | 4.23397999999999 |
5134 | 5134 | 2018-07-01 | OMR | Oman | 1.05 | 0.385 | 2.7272727272727297 |
5135 | 5135 | 2018-07-01 | PKR | Pakistan | 375.0 | 121.49 | 3.0866738003127794 |
5136 | 5136 | 2018-07-01 | PEN | Peru | 10.5 | 3.2715 | 3.20953690967446 |
5137 | 5137 | 2018-07-01 | PHP | Philippines | 140.0 | 53.487 | 2.6174584478471403 |
5138 | 5138 | 2018-07-01 | PLN | Poland | 10.1 | 3.68695 | 2.73939163807483 |
5139 | 5139 | 2018-07-01 | QAR | Qatar | 12.0 | 3.641 | 3.29579785773139 |
5140 | 5140 | 2018-07-01 | RON | Romania | 9.2 | 3.97325 | 2.3154848046309704 |
5141 | 5141 | 2018-07-01 | RUB | Russia | 130.0 | 62.14065 | 2.09202832606353 |
5142 | 5142 | 2018-07-01 | SAR | Saudi Arabia | 12.0 | 3.7504 | 3.19965870307167 |
5143 | 5143 | 2018-07-01 | SGD | Singapore | 5.8 | 1.35585 | 4.27775933915994 |
5144 | 5144 | 2018-07-01 | SEK | Sweden | 51.0 | 8.7526 | 5.826840024678379 |
5145 | 5145 | 2018-07-01 | THB | Thailand | 119.0 | 33.17 | 3.5875791377751 |
5146 | 5146 | 2018-07-01 | TRY | Turkey | 10.75 | 4.70625 | 2.28419654714475 |
5147 | 5147 | 2018-07-01 | TWD | Taiwan | 69.0 | 30.3725 | 2.27179191703021 |
5148 | 5148 | 2018-07-01 | UAH | Ukraine | 50.0 | 26.199 | 1.90846978892324 |
5149 | 5149 | 2018-07-01 | UYU | Uruguay | 140.0 | 31.31 | 4.47141488342383 |
5150 | 5150 | 2018-07-01 | USD | United States | 5.51 | 1.0 | 5.51 |
5151 | 5151 | 2018-07-01 | VND | Vietnam | 65000.0 | 23039.5 | 2.82124178042058 |
5152 | 5152 | 2018-07-01 | ZAR | South Africa | 31.0 | 13.3619 | 2.32002933714517 |
6427 | 6427 | 2018-07-01 | AED | United Arab Emirates | 14.0 | 3.67315 | 3.81144249486136 |
6428 | 6428 | 2018-07-01 | ARS | Argentina | 75.0 | 27.725 | 2.705139765554549 |
6429 | 6429 | 2018-07-01 | AUD | Australia | 6.05 | 1.33985395591881 | 4.51541749999998 |
6430 | 6430 | 2018-07-01 | AZN | Azerbaijan | 3.95 | 1.70175 | 2.32114000293815 |
6431 | 6431 | 2018-07-01 | BHD | Bahrain | 1.2 | 0.37955 | 3.161638782769069 |
6432 | 6432 | 2018-07-01 | BRL | Brazil | 16.9 | 3.83835 | 4.4029335521773705 |
6433 | 6433 | 2018-07-01 | CAD | Canada | 6.65 | 1.31235 | 5.067245780470151 |
6434 | 6434 | 2018-07-01 | CHF | Switzerland | 6.5 | 0.99325 | 6.54417316889001 |
6435 | 6435 | 2018-07-01 | CLP | Chile | 2640.0 | 651.73 | 4.05075721541129 |
6436 | 6436 | 2018-07-01 | CNY | China | 20.5 | 6.622000000000001 | 3.09574146783449 |
6437 | 6437 | 2018-07-01 | COP | Colombia | 11900.0 | 2874.07 | 4.14046978674841 |
6438 | 6438 | 2018-07-01 | CRC | Costa Rica | 2290.0 | 567.8 | 4.03311025008806 |
6439 | 6439 | 2018-07-01 | CZK | Czech Republic | 75.0 | 22.06475 | 3.39908677868546 |
6440 | 6440 | 2018-07-01 | DKK | Denmark | 30.0 | 6.3591 | 4.71764872387602 |
6441 | 6441 | 2018-07-01 | EGP | Egypt | 31.37 | 17.905 | 1.7520245741413 |
6442 | 6442 | 2018-07-01 | EUR | Euro area | 4.04 | 0.8532059212490941 | 4.735082 |
6443 | 6443 | 2018-07-01 | GBP | Britain | 3.19 | 0.7538635506973241 | 4.231535 |
6444 | 6444 | 2018-07-01 | GTQ | Guatemala | 25.0 | 7.4871 | 3.33907654499072 |
6445 | 6445 | 2018-07-01 | HKD | Hong Kong | 20.0 | 7.84825 | 2.54833880164368 |
6446 | 6446 | 2018-07-01 | HNL | Honduras | 85.0 | 23.9926 | 3.5427590173636903 |
6447 | 6447 | 2018-07-01 | HRK | Croatia | 21.0 | 6.31275 | 3.32660092669597 |
6448 | 6448 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
6449 | 6449 | 2018-07-01 | IDR | Indonesia | 31500.0 | 14360.0 | 2.19359331476323 |
6450 | 6450 | 2018-07-01 | INR | India | 173.0 | 68.825 | 2.51362150381402 |
6451 | 6451 | 2018-07-01 | ILS | Israel | 17.0 | 3.6349 | 4.67688244518419 |
6452 | 6452 | 2018-07-01 | JOD | Jordan | 1.95 | 0.71005 | 2.74628547285402 |
6453 | 6453 | 2018-07-01 | JPY | Japan | 390.0 | 111.25 | 3.50561797752809 |
6454 | 6454 | 2018-07-01 | KRW | South Korea | 4500.0 | 1116.0 | 4.03225806451613 |
6455 | 6455 | 2018-07-01 | KWD | Kuwait | 1.05 | 0.3025 | 3.47107438016529 |
6456 | 6456 | 2018-07-01 | LBP | Lebanon | 6500.0 | 1511.0 | 4.3017868960953 |
6457 | 6457 | 2018-07-01 | LKR | Sri Lanka | 580.0 | 159.27 | 3.6416148678344897 |
6458 | 6458 | 2018-07-01 | MDL | Moldova | 43.0 | 16.6526 | 2.58217935937932 |
6459 | 6459 | 2018-07-01 | MXN | Mexico | 49.0 | 19.0515 | 2.57197595989817 |
6460 | 6460 | 2018-07-01 | MYR | Malaysia | 8.45 | 4.0225 | 2.10068365444375 |
6461 | 6461 | 2018-07-01 | NIO | Nicaragua | 103.0 | 31.5872 | 3.26081450714213 |
6462 | 6462 | 2018-07-01 | NOK | Norway | 42.0 | 8.0415 | 5.22290617422123 |
6463 | 6463 | 2018-07-01 | NZD | New Zealand | 6.2 | 1.46434324205594 | 4.23397999999999 |
6464 | 6464 | 2018-07-01 | OMR | Oman | 1.05 | 0.385 | 2.7272727272727297 |
6465 | 6465 | 2018-07-01 | PKR | Pakistan | 375.0 | 121.49 | 3.0866738003127794 |
6466 | 6466 | 2018-07-01 | PEN | Peru | 10.5 | 3.2715 | 3.20953690967446 |
6467 | 6467 | 2018-07-01 | PHP | Philippines | 140.0 | 53.487 | 2.6174584478471403 |
6468 | 6468 | 2018-07-01 | PLN | Poland | 10.1 | 3.68695 | 2.73939163807483 |
6469 | 6469 | 2018-07-01 | QAR | Qatar | 12.0 | 3.641 | 3.29579785773139 |
6470 | 6470 | 2018-07-01 | RON | Romania | 9.2 | 3.97325 | 2.3154848046309704 |
6471 | 6471 | 2018-07-01 | RUB | Russia | 130.0 | 62.14065 | 2.09202832606353 |
6472 | 6472 | 2018-07-01 | SAR | Saudi Arabia | 12.0 | 3.7504 | 3.19965870307167 |
6473 | 6473 | 2018-07-01 | SGD | Singapore | 5.8 | 1.35585 | 4.27775933915994 |
6474 | 6474 | 2018-07-01 | SEK | Sweden | 51.0 | 8.7526 | 5.826840024678379 |
6475 | 6475 | 2018-07-01 | THB | Thailand | 119.0 | 33.17 | 3.5875791377751 |
6476 | 6476 | 2018-07-01 | TRY | Turkey | 10.75 | 4.70625 | 2.28419654714475 |
6477 | 6477 | 2018-07-01 | TWD | Taiwan | 69.0 | 30.3725 | 2.27179191703021 |
6478 | 6478 | 2018-07-01 | UAH | Ukraine | 50.0 | 26.199 | 1.90846978892324 |
6479 | 6479 | 2018-07-01 | UYU | Uruguay | 140.0 | 31.31 | 4.47141488342383 |
6480 | 6480 | 2018-07-01 | USD | United States | 5.51 | 1.0 | 5.51 |
6481 | 6481 | 2018-07-01 | VND | Vietnam | 65000.0 | 23039.5 | 2.82124178042058 |
6482 | 6482 | 2018-07-01 | ZAR | South Africa | 31.0 | 13.3619 | 2.32002933714517 |
7757 | 7757 | 2018-07-01 | AED | United Arab Emirates | 14.0 | 3.67315 | 3.81144249486136 |
7758 | 7758 | 2018-07-01 | ARS | Argentina | 75.0 | 27.725 | 2.705139765554549 |
7759 | 7759 | 2018-07-01 | AUD | Australia | 6.05 | 1.33985395591881 | 4.51541749999998 |
7760 | 7760 | 2018-07-01 | AZN | Azerbaijan | 3.95 | 1.70175 | 2.32114000293815 |
7761 | 7761 | 2018-07-01 | BHD | Bahrain | 1.2 | 0.37955 | 3.161638782769069 |
7762 | 7762 | 2018-07-01 | BRL | Brazil | 16.9 | 3.83835 | 4.4029335521773705 |
7763 | 7763 | 2018-07-01 | CAD | Canada | 6.65 | 1.31235 | 5.067245780470151 |
7764 | 7764 | 2018-07-01 | CHF | Switzerland | 6.5 | 0.99325 | 6.54417316889001 |
7765 | 7765 | 2018-07-01 | CLP | Chile | 2640.0 | 651.73 | 4.05075721541129 |
7766 | 7766 | 2018-07-01 | CNY | China | 20.5 | 6.622000000000001 | 3.09574146783449 |
7767 | 7767 | 2018-07-01 | COP | Colombia | 11900.0 | 2874.07 | 4.14046978674841 |
7768 | 7768 | 2018-07-01 | CRC | Costa Rica | 2290.0 | 567.8 | 4.03311025008806 |
7769 | 7769 | 2018-07-01 | CZK | Czech Republic | 75.0 | 22.06475 | 3.39908677868546 |
7770 | 7770 | 2018-07-01 | DKK | Denmark | 30.0 | 6.3591 | 4.71764872387602 |
7771 | 7771 | 2018-07-01 | EGP | Egypt | 31.37 | 17.905 | 1.7520245741413 |
7772 | 7772 | 2018-07-01 | EUR | Euro area | 4.04 | 0.8532059212490941 | 4.735082 |
7773 | 7773 | 2018-07-01 | GBP | Britain | 3.19 | 0.7538635506973241 | 4.231535 |
7774 | 7774 | 2018-07-01 | GTQ | Guatemala | 25.0 | 7.4871 | 3.33907654499072 |
7775 | 7775 | 2018-07-01 | HKD | Hong Kong | 20.0 | 7.84825 | 2.54833880164368 |
7776 | 7776 | 2018-07-01 | HNL | Honduras | 85.0 | 23.9926 | 3.5427590173636903 |
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 );