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 |
---|---|---|---|---|---|---|---|
2481 | 2481 | 2018-07-01 | RUB | Russia | 130.0 | 62.14065 | 2.09202832606353 |
2482 | 2482 | 2018-07-01 | SAR | Saudi Arabia | 12.0 | 3.7504 | 3.19965870307167 |
2483 | 2483 | 2018-07-01 | SGD | Singapore | 5.8 | 1.35585 | 4.27775933915994 |
2484 | 2484 | 2018-07-01 | SEK | Sweden | 51.0 | 8.7526 | 5.826840024678379 |
2485 | 2485 | 2018-07-01 | THB | Thailand | 119.0 | 33.17 | 3.5875791377751 |
2486 | 2486 | 2018-07-01 | TRY | Turkey | 10.75 | 4.70625 | 2.28419654714475 |
2487 | 2487 | 2018-07-01 | TWD | Taiwan | 69.0 | 30.3725 | 2.27179191703021 |
2488 | 2488 | 2018-07-01 | UAH | Ukraine | 50.0 | 26.199 | 1.90846978892324 |
2489 | 2489 | 2018-07-01 | UYU | Uruguay | 140.0 | 31.31 | 4.47141488342383 |
2490 | 2490 | 2018-07-01 | USD | United States | 5.51 | 1.0 | 5.51 |
2491 | 2491 | 2018-07-01 | VND | Vietnam | 65000.0 | 23039.5 | 2.82124178042058 |
2492 | 2492 | 2018-07-01 | ZAR | South Africa | 31.0 | 13.3619 | 2.32002933714517 |
3767 | 3767 | 2018-07-01 | AED | United Arab Emirates | 14.0 | 3.67315 | 3.81144249486136 |
3768 | 3768 | 2018-07-01 | ARS | Argentina | 75.0 | 27.725 | 2.705139765554549 |
3769 | 3769 | 2018-07-01 | AUD | Australia | 6.05 | 1.33985395591881 | 4.51541749999998 |
3770 | 3770 | 2018-07-01 | AZN | Azerbaijan | 3.95 | 1.70175 | 2.32114000293815 |
3771 | 3771 | 2018-07-01 | BHD | Bahrain | 1.2 | 0.37955 | 3.161638782769069 |
3772 | 3772 | 2018-07-01 | BRL | Brazil | 16.9 | 3.83835 | 4.4029335521773705 |
3773 | 3773 | 2018-07-01 | CAD | Canada | 6.65 | 1.31235 | 5.067245780470151 |
3774 | 3774 | 2018-07-01 | CHF | Switzerland | 6.5 | 0.99325 | 6.54417316889001 |
3775 | 3775 | 2018-07-01 | CLP | Chile | 2640.0 | 651.73 | 4.05075721541129 |
3776 | 3776 | 2018-07-01 | CNY | China | 20.5 | 6.622000000000001 | 3.09574146783449 |
3777 | 3777 | 2018-07-01 | COP | Colombia | 11900.0 | 2874.07 | 4.14046978674841 |
3778 | 3778 | 2018-07-01 | CRC | Costa Rica | 2290.0 | 567.8 | 4.03311025008806 |
3779 | 3779 | 2018-07-01 | CZK | Czech Republic | 75.0 | 22.06475 | 3.39908677868546 |
3780 | 3780 | 2018-07-01 | DKK | Denmark | 30.0 | 6.3591 | 4.71764872387602 |
3781 | 3781 | 2018-07-01 | EGP | Egypt | 31.37 | 17.905 | 1.7520245741413 |
3782 | 3782 | 2018-07-01 | EUR | Euro area | 4.04 | 0.8532059212490941 | 4.735082 |
3783 | 3783 | 2018-07-01 | GBP | Britain | 3.19 | 0.7538635506973241 | 4.231535 |
3784 | 3784 | 2018-07-01 | GTQ | Guatemala | 25.0 | 7.4871 | 3.33907654499072 |
3785 | 3785 | 2018-07-01 | HKD | Hong Kong | 20.0 | 7.84825 | 2.54833880164368 |
3786 | 3786 | 2018-07-01 | HNL | Honduras | 85.0 | 23.9926 | 3.5427590173636903 |
3787 | 3787 | 2018-07-01 | HRK | Croatia | 21.0 | 6.31275 | 3.32660092669597 |
3788 | 3788 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
3789 | 3789 | 2018-07-01 | IDR | Indonesia | 31500.0 | 14360.0 | 2.19359331476323 |
3790 | 3790 | 2018-07-01 | INR | India | 173.0 | 68.825 | 2.51362150381402 |
3791 | 3791 | 2018-07-01 | ILS | Israel | 17.0 | 3.6349 | 4.67688244518419 |
3792 | 3792 | 2018-07-01 | JOD | Jordan | 1.95 | 0.71005 | 2.74628547285402 |
3793 | 3793 | 2018-07-01 | JPY | Japan | 390.0 | 111.25 | 3.50561797752809 |
3794 | 3794 | 2018-07-01 | KRW | South Korea | 4500.0 | 1116.0 | 4.03225806451613 |
3795 | 3795 | 2018-07-01 | KWD | Kuwait | 1.05 | 0.3025 | 3.47107438016529 |
3796 | 3796 | 2018-07-01 | LBP | Lebanon | 6500.0 | 1511.0 | 4.3017868960953 |
3797 | 3797 | 2018-07-01 | LKR | Sri Lanka | 580.0 | 159.27 | 3.6416148678344897 |
3798 | 3798 | 2018-07-01 | MDL | Moldova | 43.0 | 16.6526 | 2.58217935937932 |
3799 | 3799 | 2018-07-01 | MXN | Mexico | 49.0 | 19.0515 | 2.57197595989817 |
3800 | 3800 | 2018-07-01 | MYR | Malaysia | 8.45 | 4.0225 | 2.10068365444375 |
3801 | 3801 | 2018-07-01 | NIO | Nicaragua | 103.0 | 31.5872 | 3.26081450714213 |
3802 | 3802 | 2018-07-01 | NOK | Norway | 42.0 | 8.0415 | 5.22290617422123 |
3803 | 3803 | 2018-07-01 | NZD | New Zealand | 6.2 | 1.46434324205594 | 4.23397999999999 |
3804 | 3804 | 2018-07-01 | OMR | Oman | 1.05 | 0.385 | 2.7272727272727297 |
3805 | 3805 | 2018-07-01 | PKR | Pakistan | 375.0 | 121.49 | 3.0866738003127794 |
3806 | 3806 | 2018-07-01 | PEN | Peru | 10.5 | 3.2715 | 3.20953690967446 |
3807 | 3807 | 2018-07-01 | PHP | Philippines | 140.0 | 53.487 | 2.6174584478471403 |
3808 | 3808 | 2018-07-01 | PLN | Poland | 10.1 | 3.68695 | 2.73939163807483 |
3809 | 3809 | 2018-07-01 | QAR | Qatar | 12.0 | 3.641 | 3.29579785773139 |
3810 | 3810 | 2018-07-01 | RON | Romania | 9.2 | 3.97325 | 2.3154848046309704 |
3811 | 3811 | 2018-07-01 | RUB | Russia | 130.0 | 62.14065 | 2.09202832606353 |
3812 | 3812 | 2018-07-01 | SAR | Saudi Arabia | 12.0 | 3.7504 | 3.19965870307167 |
3813 | 3813 | 2018-07-01 | SGD | Singapore | 5.8 | 1.35585 | 4.27775933915994 |
3814 | 3814 | 2018-07-01 | SEK | Sweden | 51.0 | 8.7526 | 5.826840024678379 |
3815 | 3815 | 2018-07-01 | THB | Thailand | 119.0 | 33.17 | 3.5875791377751 |
3816 | 3816 | 2018-07-01 | TRY | Turkey | 10.75 | 4.70625 | 2.28419654714475 |
3817 | 3817 | 2018-07-01 | TWD | Taiwan | 69.0 | 30.3725 | 2.27179191703021 |
3818 | 3818 | 2018-07-01 | UAH | Ukraine | 50.0 | 26.199 | 1.90846978892324 |
3819 | 3819 | 2018-07-01 | UYU | Uruguay | 140.0 | 31.31 | 4.47141488342383 |
3820 | 3820 | 2018-07-01 | USD | United States | 5.51 | 1.0 | 5.51 |
3821 | 3821 | 2018-07-01 | VND | Vietnam | 65000.0 | 23039.5 | 2.82124178042058 |
3822 | 3822 | 2018-07-01 | ZAR | South Africa | 31.0 | 13.3619 | 2.32002933714517 |
5097 | 5097 | 2018-07-01 | AED | United Arab Emirates | 14.0 | 3.67315 | 3.81144249486136 |
5098 | 5098 | 2018-07-01 | ARS | Argentina | 75.0 | 27.725 | 2.705139765554549 |
5099 | 5099 | 2018-07-01 | AUD | Australia | 6.05 | 1.33985395591881 | 4.51541749999998 |
5100 | 5100 | 2018-07-01 | AZN | Azerbaijan | 3.95 | 1.70175 | 2.32114000293815 |
5101 | 5101 | 2018-07-01 | BHD | Bahrain | 1.2 | 0.37955 | 3.161638782769069 |
5102 | 5102 | 2018-07-01 | BRL | Brazil | 16.9 | 3.83835 | 4.4029335521773705 |
5103 | 5103 | 2018-07-01 | CAD | Canada | 6.65 | 1.31235 | 5.067245780470151 |
5104 | 5104 | 2018-07-01 | CHF | Switzerland | 6.5 | 0.99325 | 6.54417316889001 |
5105 | 5105 | 2018-07-01 | CLP | Chile | 2640.0 | 651.73 | 4.05075721541129 |
5106 | 5106 | 2018-07-01 | CNY | China | 20.5 | 6.622000000000001 | 3.09574146783449 |
5107 | 5107 | 2018-07-01 | COP | Colombia | 11900.0 | 2874.07 | 4.14046978674841 |
5108 | 5108 | 2018-07-01 | CRC | Costa Rica | 2290.0 | 567.8 | 4.03311025008806 |
5109 | 5109 | 2018-07-01 | CZK | Czech Republic | 75.0 | 22.06475 | 3.39908677868546 |
5110 | 5110 | 2018-07-01 | DKK | Denmark | 30.0 | 6.3591 | 4.71764872387602 |
5111 | 5111 | 2018-07-01 | EGP | Egypt | 31.37 | 17.905 | 1.7520245741413 |
5112 | 5112 | 2018-07-01 | EUR | Euro area | 4.04 | 0.8532059212490941 | 4.735082 |
5113 | 5113 | 2018-07-01 | GBP | Britain | 3.19 | 0.7538635506973241 | 4.231535 |
5114 | 5114 | 2018-07-01 | GTQ | Guatemala | 25.0 | 7.4871 | 3.33907654499072 |
5115 | 5115 | 2018-07-01 | HKD | Hong Kong | 20.0 | 7.84825 | 2.54833880164368 |
5116 | 5116 | 2018-07-01 | HNL | Honduras | 85.0 | 23.9926 | 3.5427590173636903 |
5117 | 5117 | 2018-07-01 | HRK | Croatia | 21.0 | 6.31275 | 3.32660092669597 |
5118 | 5118 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
5119 | 5119 | 2018-07-01 | IDR | Indonesia | 31500.0 | 14360.0 | 2.19359331476323 |
5120 | 5120 | 2018-07-01 | INR | India | 173.0 | 68.825 | 2.51362150381402 |
5121 | 5121 | 2018-07-01 | ILS | Israel | 17.0 | 3.6349 | 4.67688244518419 |
5122 | 5122 | 2018-07-01 | JOD | Jordan | 1.95 | 0.71005 | 2.74628547285402 |
5123 | 5123 | 2018-07-01 | JPY | Japan | 390.0 | 111.25 | 3.50561797752809 |
5124 | 5124 | 2018-07-01 | KRW | South Korea | 4500.0 | 1116.0 | 4.03225806451613 |
5125 | 5125 | 2018-07-01 | KWD | Kuwait | 1.05 | 0.3025 | 3.47107438016529 |
5126 | 5126 | 2018-07-01 | LBP | Lebanon | 6500.0 | 1511.0 | 4.3017868960953 |
5127 | 5127 | 2018-07-01 | LKR | Sri Lanka | 580.0 | 159.27 | 3.6416148678344897 |
5128 | 5128 | 2018-07-01 | MDL | Moldova | 43.0 | 16.6526 | 2.58217935937932 |
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 );