bigmac
400 rows where "date" is on date 2007-06-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
310 | 310 | 2007-06-01 | AED | UAE | 10.0 | 3.67285 | 2.7226812965408302 |
311 | 311 | 2007-06-01 | ARS | Argentina | 8.25 | 3.0915 | 2.66860747210092 |
312 | 312 | 2007-06-01 | AUD | Australia | 3.45 | 1.17 | 2.94871794871795 |
313 | 313 | 2007-06-01 | BRL | Brazil | 6.9 | 1.913 | 3.60690015682175 |
314 | 314 | 2007-06-01 | CAD | Canada | 3.88 | 1.05345 | 3.6831363614789514 |
315 | 315 | 2007-06-01 | CHF | Switzerland | 6.3 | 1.2112 | 5.2014531043593095 |
316 | 316 | 2007-06-01 | CLP | Chile | 1565.0 | 526.75 | 2.9710488846701497 |
317 | 317 | 2007-06-01 | CNY | China | 11.0 | 7.6047 | 1.4464738911462598 |
318 | 318 | 2007-06-01 | COP | Colombia | 6900.0 | 1956.0 | 3.52760736196319 |
319 | 319 | 2007-06-01 | CRC | Costa Rica | 1130.0 | 518.625 | 2.17883827428296 |
320 | 320 | 2007-06-01 | CZK | Czech Republic | 52.9 | 21.11675 | 2.5051203428557898 |
321 | 321 | 2007-06-01 | DKK | Denmark | 27.75 | 5.4603 | 5.082138344047031 |
322 | 322 | 2007-06-01 | EGP | Egypt | 9.54 | 5.69025 | 1.67655199683669 |
323 | 323 | 2007-06-01 | EUR | Euro area | 3.057482443 | 0.7337564659999999 | 4.1668899487422 |
324 | 324 | 2007-06-01 | GBP | Britain | 1.99 | 0.496610632 | 4.0071635034990605 |
325 | 325 | 2007-06-01 | HKD | Hong Kong | 12.0 | 7.81555 | 1.5354005796137198 |
326 | 326 | 2007-06-01 | HUF | Hungary | 600.0 | 180.2106 | 3.32943789100086 |
327 | 327 | 2007-06-01 | IDR | Indonesia | 15900.0 | 9015.0 | 1.76372712146423 |
328 | 328 | 2007-06-01 | JPY | Japan | 280.0 | 122.315 | 2.2891714017087 |
329 | 329 | 2007-06-01 | KRW | South Korea | 2900.0 | 922.5 | 3.14363143631436 |
330 | 330 | 2007-06-01 | LKR | Sri Lanka | 210.0 | 111.4 | 1.8850987432675 |
331 | 331 | 2007-06-01 | MXN | Mexico | 29.0 | 10.76755 | 2.693277486522 |
332 | 332 | 2007-06-01 | MYR | Malaysia | 5.5 | 3.4345 | 1.60139758334547 |
333 | 333 | 2007-06-01 | NOK | Norway | 40.0 | 5.8139 | 6.88006329658233 |
334 | 334 | 2007-06-01 | NZD | New Zealand | 4.6 | 1.2797 | 3.59459248261311 |
335 | 335 | 2007-06-01 | PKR | Pakistan | 140.0 | 60.37 | 2.31903263210204 |
336 | 336 | 2007-06-01 | PEN | Peru | 9.5 | 3.167 | 2.99968424376381 |
337 | 337 | 2007-06-01 | PHP | Philippines | 85.0 | 45.8975 | 1.85195272073642 |
338 | 338 | 2007-06-01 | PLN | Poland | 6.9 | 2.75185 | 2.50740410996239 |
339 | 339 | 2007-06-01 | RUB | Russia | 52.0 | 25.64825 | 2.0274287719435 |
340 | 340 | 2007-06-01 | SAR | Saudi Arabia | 9.0 | 3.75045 | 2.3997120345558502 |
341 | 341 | 2007-06-01 | SGD | Singapore | 3.95 | 1.52375 | 2.5922887612797405 |
342 | 342 | 2007-06-01 | SEK | Sweden | 33.0 | 6.79165 | 4.85890762922118 |
343 | 343 | 2007-06-01 | THB | Thailand | 62.0 | 34.455 | 1.79944855608765 |
344 | 344 | 2007-06-01 | TRY | Turkey | 4.75 | 1.2981 | 3.6591942069178 |
345 | 345 | 2007-06-01 | TWD | Taiwan | 75.0 | 32.7705 | 2.2886437497139203 |
346 | 346 | 2007-06-01 | UAH | Ukraine | 9.25 | 5.0275 | 1.83988065638986 |
347 | 347 | 2007-06-01 | UYU | Uruguay | 62.0 | 23.945 | 2.5892670703696 |
348 | 348 | 2007-06-01 | USD | United States | 3.41 | 1.0 | 3.41 |
349 | 349 | 2007-06-01 | ZAR | South Africa | 15.5 | 6.971 | 2.22349734614833 |
1640 | 1640 | 2007-06-01 | AED | UAE | 10.0 | 3.67285 | 2.7226812965408302 |
1641 | 1641 | 2007-06-01 | ARS | Argentina | 8.25 | 3.0915 | 2.66860747210092 |
1642 | 1642 | 2007-06-01 | AUD | Australia | 3.45 | 1.17 | 2.94871794871795 |
1643 | 1643 | 2007-06-01 | BRL | Brazil | 6.9 | 1.913 | 3.60690015682175 |
1644 | 1644 | 2007-06-01 | CAD | Canada | 3.88 | 1.05345 | 3.6831363614789514 |
1645 | 1645 | 2007-06-01 | CHF | Switzerland | 6.3 | 1.2112 | 5.2014531043593095 |
1646 | 1646 | 2007-06-01 | CLP | Chile | 1565.0 | 526.75 | 2.9710488846701497 |
1647 | 1647 | 2007-06-01 | CNY | China | 11.0 | 7.6047 | 1.4464738911462598 |
1648 | 1648 | 2007-06-01 | COP | Colombia | 6900.0 | 1956.0 | 3.52760736196319 |
1649 | 1649 | 2007-06-01 | CRC | Costa Rica | 1130.0 | 518.625 | 2.17883827428296 |
1650 | 1650 | 2007-06-01 | CZK | Czech Republic | 52.9 | 21.11675 | 2.5051203428557898 |
1651 | 1651 | 2007-06-01 | DKK | Denmark | 27.75 | 5.4603 | 5.082138344047031 |
1652 | 1652 | 2007-06-01 | EGP | Egypt | 9.54 | 5.69025 | 1.67655199683669 |
1653 | 1653 | 2007-06-01 | EUR | Euro area | 3.057482443 | 0.7337564659999999 | 4.1668899487422 |
1654 | 1654 | 2007-06-01 | GBP | Britain | 1.99 | 0.496610632 | 4.0071635034990605 |
1655 | 1655 | 2007-06-01 | HKD | Hong Kong | 12.0 | 7.81555 | 1.5354005796137198 |
1656 | 1656 | 2007-06-01 | HUF | Hungary | 600.0 | 180.2106 | 3.32943789100086 |
1657 | 1657 | 2007-06-01 | IDR | Indonesia | 15900.0 | 9015.0 | 1.76372712146423 |
1658 | 1658 | 2007-06-01 | JPY | Japan | 280.0 | 122.315 | 2.2891714017087 |
1659 | 1659 | 2007-06-01 | KRW | South Korea | 2900.0 | 922.5 | 3.14363143631436 |
1660 | 1660 | 2007-06-01 | LKR | Sri Lanka | 210.0 | 111.4 | 1.8850987432675 |
1661 | 1661 | 2007-06-01 | MXN | Mexico | 29.0 | 10.76755 | 2.693277486522 |
1662 | 1662 | 2007-06-01 | MYR | Malaysia | 5.5 | 3.4345 | 1.60139758334547 |
1663 | 1663 | 2007-06-01 | NOK | Norway | 40.0 | 5.8139 | 6.88006329658233 |
1664 | 1664 | 2007-06-01 | NZD | New Zealand | 4.6 | 1.2797 | 3.59459248261311 |
1665 | 1665 | 2007-06-01 | PKR | Pakistan | 140.0 | 60.37 | 2.31903263210204 |
1666 | 1666 | 2007-06-01 | PEN | Peru | 9.5 | 3.167 | 2.99968424376381 |
1667 | 1667 | 2007-06-01 | PHP | Philippines | 85.0 | 45.8975 | 1.85195272073642 |
1668 | 1668 | 2007-06-01 | PLN | Poland | 6.9 | 2.75185 | 2.50740410996239 |
1669 | 1669 | 2007-06-01 | RUB | Russia | 52.0 | 25.64825 | 2.0274287719435 |
1670 | 1670 | 2007-06-01 | SAR | Saudi Arabia | 9.0 | 3.75045 | 2.3997120345558502 |
1671 | 1671 | 2007-06-01 | SGD | Singapore | 3.95 | 1.52375 | 2.5922887612797405 |
1672 | 1672 | 2007-06-01 | SEK | Sweden | 33.0 | 6.79165 | 4.85890762922118 |
1673 | 1673 | 2007-06-01 | THB | Thailand | 62.0 | 34.455 | 1.79944855608765 |
1674 | 1674 | 2007-06-01 | TRY | Turkey | 4.75 | 1.2981 | 3.6591942069178 |
1675 | 1675 | 2007-06-01 | TWD | Taiwan | 75.0 | 32.7705 | 2.2886437497139203 |
1676 | 1676 | 2007-06-01 | UAH | Ukraine | 9.25 | 5.0275 | 1.83988065638986 |
1677 | 1677 | 2007-06-01 | UYU | Uruguay | 62.0 | 23.945 | 2.5892670703696 |
1678 | 1678 | 2007-06-01 | USD | United States | 3.41 | 1.0 | 3.41 |
1679 | 1679 | 2007-06-01 | ZAR | South Africa | 15.5 | 6.971 | 2.22349734614833 |
2970 | 2970 | 2007-06-01 | AED | UAE | 10.0 | 3.67285 | 2.7226812965408302 |
2971 | 2971 | 2007-06-01 | ARS | Argentina | 8.25 | 3.0915 | 2.66860747210092 |
2972 | 2972 | 2007-06-01 | AUD | Australia | 3.45 | 1.17 | 2.94871794871795 |
2973 | 2973 | 2007-06-01 | BRL | Brazil | 6.9 | 1.913 | 3.60690015682175 |
2974 | 2974 | 2007-06-01 | CAD | Canada | 3.88 | 1.05345 | 3.6831363614789514 |
2975 | 2975 | 2007-06-01 | CHF | Switzerland | 6.3 | 1.2112 | 5.2014531043593095 |
2976 | 2976 | 2007-06-01 | CLP | Chile | 1565.0 | 526.75 | 2.9710488846701497 |
2977 | 2977 | 2007-06-01 | CNY | China | 11.0 | 7.6047 | 1.4464738911462598 |
2978 | 2978 | 2007-06-01 | COP | Colombia | 6900.0 | 1956.0 | 3.52760736196319 |
2979 | 2979 | 2007-06-01 | CRC | Costa Rica | 1130.0 | 518.625 | 2.17883827428296 |
2980 | 2980 | 2007-06-01 | CZK | Czech Republic | 52.9 | 21.11675 | 2.5051203428557898 |
2981 | 2981 | 2007-06-01 | DKK | Denmark | 27.75 | 5.4603 | 5.082138344047031 |
2982 | 2982 | 2007-06-01 | EGP | Egypt | 9.54 | 5.69025 | 1.67655199683669 |
2983 | 2983 | 2007-06-01 | EUR | Euro area | 3.057482443 | 0.7337564659999999 | 4.1668899487422 |
2984 | 2984 | 2007-06-01 | GBP | Britain | 1.99 | 0.496610632 | 4.0071635034990605 |
2985 | 2985 | 2007-06-01 | HKD | Hong Kong | 12.0 | 7.81555 | 1.5354005796137198 |
2986 | 2986 | 2007-06-01 | HUF | Hungary | 600.0 | 180.2106 | 3.32943789100086 |
2987 | 2987 | 2007-06-01 | IDR | Indonesia | 15900.0 | 9015.0 | 1.76372712146423 |
2988 | 2988 | 2007-06-01 | JPY | Japan | 280.0 | 122.315 | 2.2891714017087 |
2989 | 2989 | 2007-06-01 | KRW | South Korea | 2900.0 | 922.5 | 3.14363143631436 |
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 );