bigmac
400 rows where "date" is on date 2007-01-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
270 | 270 | 2007-01-01 | AED | UAE | 10.0 | 3.6726 | 2.72286663399227 |
271 | 271 | 2007-01-01 | ARS | Argentina | 8.25 | 3.08875 | 2.67098340752732 |
272 | 272 | 2007-01-01 | AUD | Australia | 3.45 | 1.266865 | 2.72325780568569 |
273 | 273 | 2007-01-01 | BRL | Brazil | 6.4 | 2.1335 | 2.99976564330912 |
274 | 274 | 2007-01-01 | CAD | Canada | 3.63 | 1.17485 | 3.0897561390815897 |
275 | 275 | 2007-01-01 | CHF | Switzerland | 6.3 | 1.2485 | 5.04605526631958 |
276 | 276 | 2007-01-01 | CLP | Chile | 1670.0 | 540.15 | 3.09173377765436 |
277 | 277 | 2007-01-01 | CNY | China | 11.0 | 7.7743 | 1.41491838493498 |
278 | 278 | 2007-01-01 | COP | Colombia | 6900.0 | 2239.325 | 3.0812856552755896 |
279 | 279 | 2007-01-01 | CRC | Costa Rica | 1130.0 | 509.535 | 2.2177083026681204 |
280 | 280 | 2007-01-01 | CZK | Czech Republic | 52.1 | 21.50115 | 2.42312620487741 |
281 | 281 | 2007-01-01 | DKK | Denmark | 27.75 | 5.75305 | 4.8235283892891605 |
282 | 282 | 2007-01-01 | EGP | Egypt | 9.09 | 5.7 | 1.59473684210526 |
283 | 283 | 2007-01-01 | EUR | Euro area | 2.94 | 0.771813376 | 3.80921099765962 |
284 | 284 | 2007-01-01 | GBP | Britain | 1.94 | 0.506034461 | 3.83373099959688 |
285 | 285 | 2007-01-01 | HKD | Hong Kong | 12.0 | 7.79845 | 1.53876731914675 |
286 | 286 | 2007-01-01 | HUF | Hungary | 590.0 | 194.4237 | 3.03460946376393 |
287 | 287 | 2007-01-01 | IDR | Indonesia | 15900.0 | 9090.0 | 1.74917491749175 |
288 | 288 | 2007-01-01 | JPY | Japan | 280.0 | 121.585 | 2.3029156557141097 |
289 | 289 | 2007-01-01 | KRW | South Korea | 2900.0 | 940.15 | 3.08461415731532 |
290 | 290 | 2007-01-01 | LKR | Sri Lanka | 190.0 | 102.955 | 1.84546646593172 |
291 | 291 | 2007-01-01 | MXN | Mexico | 29.0 | 10.8894 | 2.66314030157768 |
292 | 292 | 2007-01-01 | MYR | Malaysia | 5.5 | 3.502 | 1.57053112507139 |
293 | 293 | 2007-01-01 | NOK | Norway | 41.5 | 6.1023 | 6.800714484702491 |
294 | 294 | 2007-01-01 | NZD | New Zealand | 4.6 | 1.42796 | 3.2213787501050497 |
295 | 295 | 2007-01-01 | PKR | Pakistan | 140.0 | 60.055 | 2.33119640329698 |
296 | 296 | 2007-01-01 | PEN | Peru | 9.5 | 3.1895 | 2.9785232795109 |
297 | 297 | 2007-01-01 | PHP | Philippines | 85.0 | 49.05 | 1.7329255861366 |
298 | 298 | 2007-01-01 | PLN | Poland | 6.9 | 2.97175 | 2.32186422141836 |
299 | 299 | 2007-01-01 | RUB | Russia | 49.0 | 26.5335 | 1.84672206832872 |
300 | 300 | 2007-01-01 | SAR | Saudi Arabia | 9.0 | 3.749 | 2.40064017071219 |
301 | 301 | 2007-01-01 | SGD | Singapore | 3.6 | 1.53795 | 2.34077830878767 |
302 | 302 | 2007-01-01 | SEK | Sweden | 32.0 | 7.04125 | 4.544647612284749 |
303 | 303 | 2007-01-01 | THB | Thailand | 62.0 | 35.3 | 1.75637393767705 |
304 | 304 | 2007-01-01 | TRY | Turkey | 4.55 | 1.40975 | 3.22752261039191 |
305 | 305 | 2007-01-01 | TWD | Taiwan | 75.0 | 32.9255 | 2.27786973622268 |
306 | 306 | 2007-01-01 | UAH | Ukraine | 9.0 | 5.05 | 1.7821782178217802 |
307 | 307 | 2007-01-01 | UYU | Uruguay | 55.0 | 23.925 | 2.29885057471264 |
308 | 308 | 2007-01-01 | USD | United States | 3.22 | 1.0 | 3.22 |
309 | 309 | 2007-01-01 | ZAR | South Africa | 15.5 | 7.10975 | 2.1801047856816296 |
1600 | 1600 | 2007-01-01 | AED | UAE | 10.0 | 3.6726 | 2.72286663399227 |
1601 | 1601 | 2007-01-01 | ARS | Argentina | 8.25 | 3.08875 | 2.67098340752732 |
1602 | 1602 | 2007-01-01 | AUD | Australia | 3.45 | 1.266865 | 2.72325780568569 |
1603 | 1603 | 2007-01-01 | BRL | Brazil | 6.4 | 2.1335 | 2.99976564330912 |
1604 | 1604 | 2007-01-01 | CAD | Canada | 3.63 | 1.17485 | 3.0897561390815897 |
1605 | 1605 | 2007-01-01 | CHF | Switzerland | 6.3 | 1.2485 | 5.04605526631958 |
1606 | 1606 | 2007-01-01 | CLP | Chile | 1670.0 | 540.15 | 3.09173377765436 |
1607 | 1607 | 2007-01-01 | CNY | China | 11.0 | 7.7743 | 1.41491838493498 |
1608 | 1608 | 2007-01-01 | COP | Colombia | 6900.0 | 2239.325 | 3.0812856552755896 |
1609 | 1609 | 2007-01-01 | CRC | Costa Rica | 1130.0 | 509.535 | 2.2177083026681204 |
1610 | 1610 | 2007-01-01 | CZK | Czech Republic | 52.1 | 21.50115 | 2.42312620487741 |
1611 | 1611 | 2007-01-01 | DKK | Denmark | 27.75 | 5.75305 | 4.8235283892891605 |
1612 | 1612 | 2007-01-01 | EGP | Egypt | 9.09 | 5.7 | 1.59473684210526 |
1613 | 1613 | 2007-01-01 | EUR | Euro area | 2.94 | 0.771813376 | 3.80921099765962 |
1614 | 1614 | 2007-01-01 | GBP | Britain | 1.94 | 0.506034461 | 3.83373099959688 |
1615 | 1615 | 2007-01-01 | HKD | Hong Kong | 12.0 | 7.79845 | 1.53876731914675 |
1616 | 1616 | 2007-01-01 | HUF | Hungary | 590.0 | 194.4237 | 3.03460946376393 |
1617 | 1617 | 2007-01-01 | IDR | Indonesia | 15900.0 | 9090.0 | 1.74917491749175 |
1618 | 1618 | 2007-01-01 | JPY | Japan | 280.0 | 121.585 | 2.3029156557141097 |
1619 | 1619 | 2007-01-01 | KRW | South Korea | 2900.0 | 940.15 | 3.08461415731532 |
1620 | 1620 | 2007-01-01 | LKR | Sri Lanka | 190.0 | 102.955 | 1.84546646593172 |
1621 | 1621 | 2007-01-01 | MXN | Mexico | 29.0 | 10.8894 | 2.66314030157768 |
1622 | 1622 | 2007-01-01 | MYR | Malaysia | 5.5 | 3.502 | 1.57053112507139 |
1623 | 1623 | 2007-01-01 | NOK | Norway | 41.5 | 6.1023 | 6.800714484702491 |
1624 | 1624 | 2007-01-01 | NZD | New Zealand | 4.6 | 1.42796 | 3.2213787501050497 |
1625 | 1625 | 2007-01-01 | PKR | Pakistan | 140.0 | 60.055 | 2.33119640329698 |
1626 | 1626 | 2007-01-01 | PEN | Peru | 9.5 | 3.1895 | 2.9785232795109 |
1627 | 1627 | 2007-01-01 | PHP | Philippines | 85.0 | 49.05 | 1.7329255861366 |
1628 | 1628 | 2007-01-01 | PLN | Poland | 6.9 | 2.97175 | 2.32186422141836 |
1629 | 1629 | 2007-01-01 | RUB | Russia | 49.0 | 26.5335 | 1.84672206832872 |
1630 | 1630 | 2007-01-01 | SAR | Saudi Arabia | 9.0 | 3.749 | 2.40064017071219 |
1631 | 1631 | 2007-01-01 | SGD | Singapore | 3.6 | 1.53795 | 2.34077830878767 |
1632 | 1632 | 2007-01-01 | SEK | Sweden | 32.0 | 7.04125 | 4.544647612284749 |
1633 | 1633 | 2007-01-01 | THB | Thailand | 62.0 | 35.3 | 1.75637393767705 |
1634 | 1634 | 2007-01-01 | TRY | Turkey | 4.55 | 1.40975 | 3.22752261039191 |
1635 | 1635 | 2007-01-01 | TWD | Taiwan | 75.0 | 32.9255 | 2.27786973622268 |
1636 | 1636 | 2007-01-01 | UAH | Ukraine | 9.0 | 5.05 | 1.7821782178217802 |
1637 | 1637 | 2007-01-01 | UYU | Uruguay | 55.0 | 23.925 | 2.29885057471264 |
1638 | 1638 | 2007-01-01 | USD | United States | 3.22 | 1.0 | 3.22 |
1639 | 1639 | 2007-01-01 | ZAR | South Africa | 15.5 | 7.10975 | 2.1801047856816296 |
2930 | 2930 | 2007-01-01 | AED | UAE | 10.0 | 3.6726 | 2.72286663399227 |
2931 | 2931 | 2007-01-01 | ARS | Argentina | 8.25 | 3.08875 | 2.67098340752732 |
2932 | 2932 | 2007-01-01 | AUD | Australia | 3.45 | 1.266865 | 2.72325780568569 |
2933 | 2933 | 2007-01-01 | BRL | Brazil | 6.4 | 2.1335 | 2.99976564330912 |
2934 | 2934 | 2007-01-01 | CAD | Canada | 3.63 | 1.17485 | 3.0897561390815897 |
2935 | 2935 | 2007-01-01 | CHF | Switzerland | 6.3 | 1.2485 | 5.04605526631958 |
2936 | 2936 | 2007-01-01 | CLP | Chile | 1670.0 | 540.15 | 3.09173377765436 |
2937 | 2937 | 2007-01-01 | CNY | China | 11.0 | 7.7743 | 1.41491838493498 |
2938 | 2938 | 2007-01-01 | COP | Colombia | 6900.0 | 2239.325 | 3.0812856552755896 |
2939 | 2939 | 2007-01-01 | CRC | Costa Rica | 1130.0 | 509.535 | 2.2177083026681204 |
2940 | 2940 | 2007-01-01 | CZK | Czech Republic | 52.1 | 21.50115 | 2.42312620487741 |
2941 | 2941 | 2007-01-01 | DKK | Denmark | 27.75 | 5.75305 | 4.8235283892891605 |
2942 | 2942 | 2007-01-01 | EGP | Egypt | 9.09 | 5.7 | 1.59473684210526 |
2943 | 2943 | 2007-01-01 | EUR | Euro area | 2.94 | 0.771813376 | 3.80921099765962 |
2944 | 2944 | 2007-01-01 | GBP | Britain | 1.94 | 0.506034461 | 3.83373099959688 |
2945 | 2945 | 2007-01-01 | HKD | Hong Kong | 12.0 | 7.79845 | 1.53876731914675 |
2946 | 2946 | 2007-01-01 | HUF | Hungary | 590.0 | 194.4237 | 3.03460946376393 |
2947 | 2947 | 2007-01-01 | IDR | Indonesia | 15900.0 | 9090.0 | 1.74917491749175 |
2948 | 2948 | 2007-01-01 | JPY | Japan | 280.0 | 121.585 | 2.3029156557141097 |
2949 | 2949 | 2007-01-01 | KRW | South Korea | 2900.0 | 940.15 | 3.08461415731532 |
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 );