bigmac
560 rows where "date" is on date 2019-01-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
2537 | 2537 | 2019-01-01 | RUB | Russia | 110.17 | 66.685 | 1.65209567368974 |
2538 | 2538 | 2019-01-01 | SAR | Saudi Arabia | 12.0 | 3.75115 | 3.1990189675166296 |
2539 | 2539 | 2019-01-01 | SGD | Singapore | 5.8 | 1.3559 | 4.27760159303783 |
2540 | 2540 | 2019-01-01 | SEK | Sweden | 52.0 | 8.90625 | 5.838596491228071 |
2541 | 2541 | 2019-01-01 | THB | Thailand | 119.0 | 32.0075 | 3.71787862219792 |
2542 | 2542 | 2019-01-01 | TRY | Turkey | 10.75 | 5.3834 | 1.99687929561244 |
2543 | 2543 | 2019-01-01 | TWD | Taiwan | 69.0 | 30.803 | 2.24004155439405 |
2544 | 2544 | 2019-01-01 | UAH | Ukraine | 54.0 | 27.8 | 1.94244604316547 |
2545 | 2545 | 2019-01-01 | UYU | Uruguay | 140.0 | 32.51 | 4.30636727160874 |
2546 | 2546 | 2019-01-01 | USD | United States | 5.58 | 1.0 | 5.58 |
2547 | 2547 | 2019-01-01 | VND | Vietnam | 65000.0 | 23199.0 | 2.801844907108069 |
2548 | 2548 | 2019-01-01 | ZAR | South Africa | 31.0 | 13.8675 | 2.23544258157563 |
3823 | 3823 | 2019-01-01 | AED | United Arab Emirates | 14.0 | 3.67315 | 3.81144249486136 |
3824 | 3824 | 2019-01-01 | ARS | Argentina | 75.0 | 37.455 | 2.00240288346015 |
3825 | 3825 | 2019-01-01 | AUD | Australia | 6.1 | 1.4016399187048798 | 4.352045000000009 |
3826 | 3826 | 2019-01-01 | AZN | Azerbaijan | 3.95 | 1.6965 | 2.3283230179781897 |
3827 | 3827 | 2019-01-01 | BHD | Bahrain | 1.2 | 0.377 | 3.18302387267905 |
3828 | 3828 | 2019-01-01 | BRL | Brazil | 16.9 | 3.71795 | 4.545515673960111 |
3829 | 3829 | 2019-01-01 | CAD | Canada | 6.77 | 1.3314 | 5.08487306594562 |
3830 | 3830 | 2019-01-01 | CHF | Switzerland | 6.5 | 0.98165 | 6.621504609585901 |
3831 | 3831 | 2019-01-01 | CLP | Chile | 2640.0 | 678.99 | 3.8881279547563294 |
3832 | 3832 | 2019-01-01 | CNY | China | 20.9 | 6.8497 | 3.05122852095712 |
3833 | 3833 | 2019-01-01 | COP | Colombia | 11900.0 | 3191.5 | 3.72865423781921 |
3834 | 3834 | 2019-01-01 | CRC | Costa Rica | 2290.0 | 606.975 | 3.77280777626756 |
3835 | 3835 | 2019-01-01 | CZK | Czech Republic | 85.0 | 22.31165 | 3.80966893976913 |
3836 | 3836 | 2019-01-01 | DKK | Denmark | 30.0 | 6.51545 | 4.60444021518084 |
3837 | 3837 | 2019-01-01 | EGP | Egypt | 40.0 | 17.91 | 2.23338916806253 |
3838 | 3838 | 2019-01-01 | EUR | Euro area | 4.05 | 0.87248614928238 | 4.641907499999999 |
3839 | 3839 | 2019-01-01 | GBP | Britain | 3.19 | 0.783208020050125 | 4.072992 |
3840 | 3840 | 2019-01-01 | GTQ | Guatemala | 25.0 | 7.7283 | 3.23486407101174 |
3841 | 3841 | 2019-01-01 | HKD | Hong Kong | 20.0 | 7.83435 | 2.55286016070255 |
3842 | 3842 | 2019-01-01 | HNL | Honduras | 85.0 | 24.3391 | 3.4923230522081803 |
3843 | 3843 | 2019-01-01 | HRK | Croatia | 21.0 | 6.47885 | 3.2413159742855604 |
3844 | 3844 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
3845 | 3845 | 2019-01-01 | IDR | Indonesia | 33000.0 | 14090.0 | 2.34208658623137 |
3846 | 3846 | 2019-01-01 | INR | India | 178.0 | 69.685 | 2.55435172562244 |
3847 | 3847 | 2019-01-01 | ILS | Israel | 17.0 | 3.70785 | 4.584867241123559 |
3848 | 3848 | 2019-01-01 | JOD | Jordan | 1.95 | 0.7096 | 2.74802705749718 |
3849 | 3849 | 2019-01-01 | JPY | Japan | 390.0 | 108.44 | 3.59645887126522 |
3850 | 3850 | 2019-01-01 | KRW | South Korea | 4500.0 | 1118.6 | 4.0228857500447 |
3851 | 3851 | 2019-01-01 | KWD | Kuwait | 1.05 | 0.3031 | 3.46420323325635 |
3852 | 3852 | 2019-01-01 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
3853 | 3853 | 2019-01-01 | LKR | Sri Lanka | 580.0 | 182.245 | 3.18252901314165 |
3854 | 3854 | 2019-01-01 | MDL | Moldova | 40.0 | 17.262999999999998 | 2.31709436366796 |
3855 | 3855 | 2019-01-01 | MXN | Mexico | 49.0 | 19.30875 | 2.53770958762219 |
3856 | 3856 | 2019-01-01 | MYR | Malaysia | 9.05 | 4.1175 | 2.19793564055859 |
3857 | 3857 | 2019-01-01 | NIO | Nicaragua | 103.0 | 32.3607 | 3.18287305280788 |
3858 | 3858 | 2019-01-01 | NOK | Norway | 50.0 | 8.5329 | 5.85967256149726 |
3859 | 3859 | 2019-01-01 | NZD | New Zealand | 6.2 | 1.4792899408284 | 4.191200000000009 |
3860 | 3860 | 2019-01-01 | OMR | Oman | 1.05 | 0.3849 | 2.7279812938425603 |
3861 | 3861 | 2019-01-01 | PKR | Pakistan | 460.0 | 138.88 | 3.3122119815668194 |
3862 | 3862 | 2019-01-01 | PEN | Peru | 10.5 | 3.3485 | 3.1357324175003702 |
3863 | 3863 | 2019-01-01 | PHP | Philippines | 140.0 | 52.3925 | 2.6721381877177097 |
3864 | 3864 | 2019-01-01 | PLN | Poland | 10.5 | 3.74845 | 2.8011578118955804 |
3865 | 3865 | 2019-01-01 | QAR | Qatar | 12.0 | 3.64125 | 3.29557157569516 |
3866 | 3866 | 2019-01-01 | RON | Romania | 9.3 | 4.06695 | 2.2867259248331098 |
3867 | 3867 | 2019-01-01 | RUB | Russia | 110.17 | 66.685 | 1.65209567368974 |
3868 | 3868 | 2019-01-01 | SAR | Saudi Arabia | 12.0 | 3.75115 | 3.1990189675166296 |
3869 | 3869 | 2019-01-01 | SGD | Singapore | 5.8 | 1.3559 | 4.27760159303783 |
3870 | 3870 | 2019-01-01 | SEK | Sweden | 52.0 | 8.90625 | 5.838596491228071 |
3871 | 3871 | 2019-01-01 | THB | Thailand | 119.0 | 32.0075 | 3.71787862219792 |
3872 | 3872 | 2019-01-01 | TRY | Turkey | 10.75 | 5.3834 | 1.99687929561244 |
3873 | 3873 | 2019-01-01 | TWD | Taiwan | 69.0 | 30.803 | 2.24004155439405 |
3874 | 3874 | 2019-01-01 | UAH | Ukraine | 54.0 | 27.8 | 1.94244604316547 |
3875 | 3875 | 2019-01-01 | UYU | Uruguay | 140.0 | 32.51 | 4.30636727160874 |
3876 | 3876 | 2019-01-01 | USD | United States | 5.58 | 1.0 | 5.58 |
3877 | 3877 | 2019-01-01 | VND | Vietnam | 65000.0 | 23199.0 | 2.801844907108069 |
3878 | 3878 | 2019-01-01 | ZAR | South Africa | 31.0 | 13.8675 | 2.23544258157563 |
5153 | 5153 | 2019-01-01 | AED | United Arab Emirates | 14.0 | 3.67315 | 3.81144249486136 |
5154 | 5154 | 2019-01-01 | ARS | Argentina | 75.0 | 37.455 | 2.00240288346015 |
5155 | 5155 | 2019-01-01 | AUD | Australia | 6.1 | 1.4016399187048798 | 4.352045000000009 |
5156 | 5156 | 2019-01-01 | AZN | Azerbaijan | 3.95 | 1.6965 | 2.3283230179781897 |
5157 | 5157 | 2019-01-01 | BHD | Bahrain | 1.2 | 0.377 | 3.18302387267905 |
5158 | 5158 | 2019-01-01 | BRL | Brazil | 16.9 | 3.71795 | 4.545515673960111 |
5159 | 5159 | 2019-01-01 | CAD | Canada | 6.77 | 1.3314 | 5.08487306594562 |
5160 | 5160 | 2019-01-01 | CHF | Switzerland | 6.5 | 0.98165 | 6.621504609585901 |
5161 | 5161 | 2019-01-01 | CLP | Chile | 2640.0 | 678.99 | 3.8881279547563294 |
5162 | 5162 | 2019-01-01 | CNY | China | 20.9 | 6.8497 | 3.05122852095712 |
5163 | 5163 | 2019-01-01 | COP | Colombia | 11900.0 | 3191.5 | 3.72865423781921 |
5164 | 5164 | 2019-01-01 | CRC | Costa Rica | 2290.0 | 606.975 | 3.77280777626756 |
5165 | 5165 | 2019-01-01 | CZK | Czech Republic | 85.0 | 22.31165 | 3.80966893976913 |
5166 | 5166 | 2019-01-01 | DKK | Denmark | 30.0 | 6.51545 | 4.60444021518084 |
5167 | 5167 | 2019-01-01 | EGP | Egypt | 40.0 | 17.91 | 2.23338916806253 |
5168 | 5168 | 2019-01-01 | EUR | Euro area | 4.05 | 0.87248614928238 | 4.641907499999999 |
5169 | 5169 | 2019-01-01 | GBP | Britain | 3.19 | 0.783208020050125 | 4.072992 |
5170 | 5170 | 2019-01-01 | GTQ | Guatemala | 25.0 | 7.7283 | 3.23486407101174 |
5171 | 5171 | 2019-01-01 | HKD | Hong Kong | 20.0 | 7.83435 | 2.55286016070255 |
5172 | 5172 | 2019-01-01 | HNL | Honduras | 85.0 | 24.3391 | 3.4923230522081803 |
5173 | 5173 | 2019-01-01 | HRK | Croatia | 21.0 | 6.47885 | 3.2413159742855604 |
5174 | 5174 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
5175 | 5175 | 2019-01-01 | IDR | Indonesia | 33000.0 | 14090.0 | 2.34208658623137 |
5176 | 5176 | 2019-01-01 | INR | India | 178.0 | 69.685 | 2.55435172562244 |
5177 | 5177 | 2019-01-01 | ILS | Israel | 17.0 | 3.70785 | 4.584867241123559 |
5178 | 5178 | 2019-01-01 | JOD | Jordan | 1.95 | 0.7096 | 2.74802705749718 |
5179 | 5179 | 2019-01-01 | JPY | Japan | 390.0 | 108.44 | 3.59645887126522 |
5180 | 5180 | 2019-01-01 | KRW | South Korea | 4500.0 | 1118.6 | 4.0228857500447 |
5181 | 5181 | 2019-01-01 | KWD | Kuwait | 1.05 | 0.3031 | 3.46420323325635 |
5182 | 5182 | 2019-01-01 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
5183 | 5183 | 2019-01-01 | LKR | Sri Lanka | 580.0 | 182.245 | 3.18252901314165 |
5184 | 5184 | 2019-01-01 | MDL | Moldova | 40.0 | 17.262999999999998 | 2.31709436366796 |
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 );