bigmac
13,300 rows
This data as json, CSV (advanced)
date (date) >30 ✖
- 2018-07-01 560
- 2019-01-01 560
- 2019-07-09 560
- 2020-01-14 560
- 2014-07-01 430
- 2015-01-01 430
- 2015-07-01 430
- 2016-01-01 430
- 2016-07-01 430
- 2017-01-01 430
- 2017-07-01 430
- 2018-01-01 430
- 2011-07-01 420
- 2012-01-01 420
- 2013-01-01 420
- 2013-07-01 420
- 2014-01-01 420
- 2009-07-01 410
- 2010-01-01 410
- 2010-07-01 410
- 2005-06-01 400
- 2006-05-01 400
- 2007-01-01 400
- 2007-06-01 400
- 2008-06-01 400
- 2012-07-01 400
- 2004-05-01 390
- 2006-01-01 310
- 2003-04-01 298
- 2002-04-01 288
- …
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
101 | 101 | 2003-04-01 | HKD | Hong Kong | 11.5 | 7.8 | 1.47435897435897 |
102 | 102 | 2003-04-01 | HUF | Hungary | 490.0 | 224.0 | 2.1875 |
103 | 103 | 2003-04-01 | IDR | Indonesia | 16100.0 | 8740.0 | 1.8421052631578896 |
104 | 104 | 2003-04-01 | JPY | Japan | 262.0 | 120.0 | 2.18333333333333 |
105 | 105 | 2003-04-01 | KRW | South Korea | 3300.0 | 1220.0 | 2.7049180327868902 |
106 | 106 | 2003-04-01 | MXN | Mexico | 23.0 | 10.53 | 2.18423551756885 |
107 | 107 | 2003-04-01 | MYR | Malaysia | 5.04 | 3.8 | 1.32631578947368 |
108 | 108 | 2003-04-01 | NZD | New Zealand | 3.95 | 1.78 | 2.21910112359551 |
109 | 109 | 2003-04-01 | PEN | Peru | 7.9 | 3.46 | 2.28323699421965 |
110 | 110 | 2003-04-01 | PHP | Philippines | 65.0 | 52.5 | 1.23809523809524 |
111 | 111 | 2003-04-01 | PLN | Poland | 6.3 | 3.89 | 1.6195372750642698 |
112 | 112 | 2003-04-01 | RUB | Russia | 41.0 | 31.1 | 1.31832797427653 |
113 | 113 | 2003-04-01 | SGD | Singapore | 3.3 | 1.78 | 1.85393258426966 |
114 | 114 | 2003-04-01 | SEK | Sweden | 30.0 | 8.34 | 3.5971223021582697 |
115 | 115 | 2003-04-01 | THB | Thailand | 59.0 | 42.7 | 1.38173302107728 |
116 | 116 | 2003-04-01 | TRY | Turkey | 3750000.0 | 1600500.0 | 2.3430178069353302 |
117 | 117 | 2003-04-01 | TWD | Taiwan | 70.0 | 34.8 | 2.01149425287356 |
118 | 118 | 2003-04-01 | USD | United States | 2.71 | 1.0 | 2.71 |
119 | 119 | 2003-04-01 | ZAR | South Africa | 13.95 | 7.56 | 1.8452380952381 |
120 | 120 | 2004-05-01 | ARS | Argentina | 4.36 | 2.95 | 1.4779661016949202 |
121 | 121 | 2004-05-01 | AUD | Australia | 3.25 | 1.43 | 2.2727272727272703 |
122 | 122 | 2004-05-01 | BRL | Brazil | 5.4 | 3.18 | 1.69811320754717 |
123 | 123 | 2004-05-01 | CAD | Canada | 3.19 | 1.37 | 2.3284671532846697 |
124 | 124 | 2004-05-01 | CHF | Switzerland | 6.3 | 1.29 | 4.88372093023256 |
125 | 125 | 2004-05-01 | CLP | Chile | 1400.0 | 641.0 | 2.18408736349454 |
126 | 126 | 2004-05-01 | CNY | China | 10.4 | 8.28 | 1.256038647343 |
127 | 127 | 2004-05-01 | COP | Colombia | 6500.0 | 2769.83 | 2.3467144192964904 |
128 | 128 | 2004-05-01 | CRC | Costa Rica | 1130.0 | 433.55 | 2.60638911313574 |
129 | 129 | 2004-05-01 | CZK | Czech Republic | 56.42 | 26.5 | 2.12905660377359 |
130 | 130 | 2004-05-01 | DKK | Denmark | 27.75 | 6.22 | 4.46141479099679 |
131 | 131 | 2004-05-01 | EGP | Egypt | 10.0 | 6.19 | 1.6155088852988702 |
132 | 132 | 2004-05-01 | EUR | Euro area | 2.74 | 0.833333333 | 3.2880000013152 |
133 | 133 | 2004-05-01 | GBP | Britain | 1.88 | 0.558659218 | 3.3651999992596604 |
134 | 134 | 2004-05-01 | HKD | Hong Kong | 12.0 | 7.79 | 1.54043645699615 |
135 | 135 | 2004-05-01 | HUF | Hungary | 530.0 | 211.0 | 2.51184834123223 |
136 | 136 | 2004-05-01 | IDR | Indonesia | 16100.0 | 9120.0 | 1.76535087719298 |
137 | 137 | 2004-05-01 | JPY | Japan | 262.0 | 113.0 | 2.31858407079646 |
138 | 138 | 2004-05-01 | KRW | South Korea | 3200.0 | 1177.0 | 2.71877655055225 |
139 | 139 | 2004-05-01 | LKR | Sri Lanka | 140.0 | 99.0 | 1.41414141414141 |
140 | 140 | 2004-05-01 | MXN | Mexico | 24.0 | 11.6 | 2.06896551724138 |
141 | 141 | 2004-05-01 | MYR | Malaysia | 5.04 | 3.8 | 1.32631578947368 |
142 | 142 | 2004-05-01 | NOK | Norway | 35.5 | 6.8491 | 5.183162751310389 |
143 | 143 | 2004-05-01 | NZD | New Zealand | 4.35 | 1.64 | 2.6524390243902403 |
144 | 144 | 2004-05-01 | PKR | Pakistan | 110.0 | 57.76 | 1.90443213296399 |
145 | 145 | 2004-05-01 | PEN | Peru | 8.99 | 3.49 | 2.57593123209169 |
146 | 146 | 2004-05-01 | PHP | Philippines | 69.0 | 55.9 | 1.23434704830054 |
147 | 147 | 2004-05-01 | PLN | Poland | 6.3 | 3.87 | 1.6279069767441898 |
148 | 148 | 2004-05-01 | RUB | Russia | 42.0 | 29.0 | 1.44827586206897 |
149 | 149 | 2004-05-01 | SAR | Saudi Arabia | 2.4 | 3.7502 | 0.639965868487014 |
150 | 150 | 2004-05-01 | SGD | Singapore | 3.3 | 1.71 | 1.9298245614035097 |
151 | 151 | 2004-05-01 | SEK | Sweden | 30.0 | 7.61 | 3.94218134034166 |
152 | 152 | 2004-05-01 | THB | Thailand | 59.0 | 40.8 | 1.44607843137255 |
153 | 153 | 2004-05-01 | TRY | Turkey | 3950000.0 | 1531000.0 | 2.58001306335728 |
154 | 154 | 2004-05-01 | TWD | Taiwan | 75.0 | 33.4 | 2.24550898203593 |
155 | 155 | 2004-05-01 | UAH | Ukraine | 7.25 | 5.3315 | 1.35984244584076 |
156 | 156 | 2004-05-01 | UYU | Uruguay | 29.8 | 29.735 | 1.00218597612241 |
157 | 157 | 2004-05-01 | USD | United States | 2.9 | 1.0 | 2.9 |
158 | 158 | 2004-05-01 | ZAR | South Africa | 12.4 | 6.66 | 1.86186186186186 |
159 | 159 | 2005-06-01 | AED | UAE | 9.0 | 3.6725 | 2.45064669843431 |
160 | 160 | 2005-06-01 | ARS | Argentina | 4.75 | 2.897 | 1.6396272005522998 |
161 | 161 | 2005-06-01 | AUD | Australia | 3.25 | 1.3015 | 2.4971187091817098 |
162 | 162 | 2005-06-01 | BRL | Brazil | 5.9 | 2.4648 | 2.39370334307043 |
163 | 163 | 2005-06-01 | CAD | Canada | 3.28 | 1.2494 | 2.6252601248599303 |
164 | 164 | 2005-06-01 | CHF | Switzerland | 6.3 | 1.2475 | 5.0501002004008 |
165 | 165 | 2005-06-01 | CLP | Chile | 1500.0 | 592.45 | 2.53185922862689 |
166 | 166 | 2005-06-01 | CNY | China | 10.5 | 8.2764 | 1.26866753661012 |
167 | 167 | 2005-06-01 | COP | Colombia | 6500.0 | 2327.7 | 2.79245607251794 |
168 | 168 | 2005-06-01 | CRC | Costa Rica | 1130.0 | 475.3 | 2.3774458236903 |
169 | 169 | 2005-06-01 | CZK | Czech Republic | 56.42 | 24.5409 | 2.29901918837532 |
170 | 170 | 2005-06-01 | DKK | Denmark | 27.75 | 6.0647 | 4.57565914224941 |
171 | 171 | 2005-06-01 | EGP | Egypt | 9.0 | 5.8 | 1.55172413793103 |
172 | 172 | 2005-06-01 | EUR | Euro area | 2.92 | 0.814929509 | 3.58313199823029 |
173 | 173 | 2005-06-01 | GBP | Britain | 1.88 | 0.546448087 | 3.44040000271792 |
174 | 174 | 2005-06-01 | HKD | Hong Kong | 12.0 | 7.7807 | 1.54227768709756 |
175 | 175 | 2005-06-01 | HUF | Hungary | 530.0 | 203.643 | 2.6025937547571 |
176 | 176 | 2005-06-01 | IDR | Indonesia | 14600.0 | 9545.0 | 1.5295966474594 |
177 | 177 | 2005-06-01 | JPY | Japan | 250.0 | 106.715 | 2.34268846928735 |
178 | 178 | 2005-06-01 | KRW | South Korea | 2500.0 | 1005.5 | 2.48632521133764 |
179 | 179 | 2005-06-01 | LKR | Sri Lanka | 175.0 | 99.945 | 1.75096302966632 |
180 | 180 | 2005-06-01 | MXN | Mexico | 28.0 | 10.8675 | 2.5764895330112703 |
181 | 181 | 2005-06-01 | MYR | Malaysia | 5.25 | 3.8 | 1.38157894736842 |
182 | 182 | 2005-06-01 | NOK | Norway | 39.0 | 6.4326 | 6.06286726984423 |
183 | 183 | 2005-06-01 | NZD | New Zealand | 4.45 | 1.4023 | 3.1733580546245497 |
184 | 184 | 2005-06-01 | PKR | Pakistan | 130.0 | 59.62 | 2.18047635021805 |
185 | 185 | 2005-06-01 | PEN | Peru | 8.99 | 3.2546 | 2.76224420819763 |
186 | 186 | 2005-06-01 | PHP | Philippines | 80.0 | 54.55 | 1.4665444546287798 |
187 | 187 | 2005-06-01 | PLN | Poland | 6.5 | 3.3096 | 1.96398356296833 |
188 | 188 | 2005-06-01 | RUB | Russia | 42.0 | 28.4055 | 1.47858689338332 |
189 | 189 | 2005-06-01 | SAR | Saudi Arabia | 9.0 | 3.7501 | 2.39993600170662 |
190 | 190 | 2005-06-01 | SGD | Singapore | 3.6 | 1.6607 | 2.16776058288673 |
191 | 191 | 2005-06-01 | SEK | Sweden | 31.0 | 7.4402 | 4.16655466250907 |
192 | 192 | 2005-06-01 | THB | Thailand | 60.0 | 40.53 | 1.48038490007402 |
193 | 193 | 2005-06-01 | TRY | Turkey | 4.0 | 1.369 | 2.9218407596786 |
194 | 194 | 2005-06-01 | TWD | Taiwan | 75.0 | 31.175 | 2.40577385725742 |
195 | 195 | 2005-06-01 | UAH | Ukraine | 7.25 | 5.06 | 1.43280632411067 |
196 | 196 | 2005-06-01 | UYU | Uruguay | 44.0 | 24.125 | 1.8238341968911895 |
197 | 197 | 2005-06-01 | USD | United States | 3.06 | 1.0 | 3.06 |
198 | 198 | 2005-06-01 | ZAR | South Africa | 13.95 | 6.6482 | 2.09831232514064 |
199 | 199 | 2006-01-01 | ARS | Argentina | 4.75 | 3.0638 | 1.5503622951889802 |
200 | 200 | 2006-01-01 | AUD | Australia | 3.25 | 1.3308 | 2.4421400661256403 |
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 );