bigmac
400 rows where "date" is on date 2007-06-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
12319 | 12319 | 2007-06-01 | ZAR | South Africa | 15.5 | 6.971 | 2.22349734614833 |
12318 | 12318 | 2007-06-01 | USD | United States | 3.41 | 1.0 | 3.41 |
12317 | 12317 | 2007-06-01 | UYU | Uruguay | 62.0 | 23.945 | 2.5892670703696 |
12316 | 12316 | 2007-06-01 | UAH | Ukraine | 9.25 | 5.0275 | 1.83988065638986 |
12315 | 12315 | 2007-06-01 | TWD | Taiwan | 75.0 | 32.7705 | 2.2886437497139203 |
12314 | 12314 | 2007-06-01 | TRY | Turkey | 4.75 | 1.2981 | 3.6591942069178 |
12313 | 12313 | 2007-06-01 | THB | Thailand | 62.0 | 34.455 | 1.79944855608765 |
12312 | 12312 | 2007-06-01 | SEK | Sweden | 33.0 | 6.79165 | 4.85890762922118 |
12311 | 12311 | 2007-06-01 | SGD | Singapore | 3.95 | 1.52375 | 2.5922887612797405 |
12310 | 12310 | 2007-06-01 | SAR | Saudi Arabia | 9.0 | 3.75045 | 2.3997120345558502 |
12309 | 12309 | 2007-06-01 | RUB | Russia | 52.0 | 25.64825 | 2.0274287719435 |
12308 | 12308 | 2007-06-01 | PLN | Poland | 6.9 | 2.75185 | 2.50740410996239 |
12307 | 12307 | 2007-06-01 | PHP | Philippines | 85.0 | 45.8975 | 1.85195272073642 |
12306 | 12306 | 2007-06-01 | PEN | Peru | 9.5 | 3.167 | 2.99968424376381 |
12305 | 12305 | 2007-06-01 | PKR | Pakistan | 140.0 | 60.37 | 2.31903263210204 |
12304 | 12304 | 2007-06-01 | NZD | New Zealand | 4.6 | 1.2797 | 3.59459248261311 |
12303 | 12303 | 2007-06-01 | NOK | Norway | 40.0 | 5.8139 | 6.88006329658233 |
12302 | 12302 | 2007-06-01 | MYR | Malaysia | 5.5 | 3.4345 | 1.60139758334547 |
12301 | 12301 | 2007-06-01 | MXN | Mexico | 29.0 | 10.76755 | 2.693277486522 |
12300 | 12300 | 2007-06-01 | LKR | Sri Lanka | 210.0 | 111.4 | 1.8850987432675 |
12299 | 12299 | 2007-06-01 | KRW | South Korea | 2900.0 | 922.5 | 3.14363143631436 |
12298 | 12298 | 2007-06-01 | JPY | Japan | 280.0 | 122.315 | 2.2891714017087 |
12297 | 12297 | 2007-06-01 | IDR | Indonesia | 15900.0 | 9015.0 | 1.76372712146423 |
12296 | 12296 | 2007-06-01 | HUF | Hungary | 600.0 | 180.2106 | 3.32943789100086 |
12295 | 12295 | 2007-06-01 | HKD | Hong Kong | 12.0 | 7.81555 | 1.5354005796137198 |
12294 | 12294 | 2007-06-01 | GBP | Britain | 1.99 | 0.496610632 | 4.0071635034990605 |
12293 | 12293 | 2007-06-01 | EUR | Euro area | 3.057482443 | 0.7337564659999999 | 4.1668899487422 |
12292 | 12292 | 2007-06-01 | EGP | Egypt | 9.54 | 5.69025 | 1.67655199683669 |
12291 | 12291 | 2007-06-01 | DKK | Denmark | 27.75 | 5.4603 | 5.082138344047031 |
12290 | 12290 | 2007-06-01 | CZK | Czech Republic | 52.9 | 21.11675 | 2.5051203428557898 |
12289 | 12289 | 2007-06-01 | CRC | Costa Rica | 1130.0 | 518.625 | 2.17883827428296 |
12288 | 12288 | 2007-06-01 | COP | Colombia | 6900.0 | 1956.0 | 3.52760736196319 |
12287 | 12287 | 2007-06-01 | CNY | China | 11.0 | 7.6047 | 1.4464738911462598 |
12286 | 12286 | 2007-06-01 | CLP | Chile | 1565.0 | 526.75 | 2.9710488846701497 |
12285 | 12285 | 2007-06-01 | CHF | Switzerland | 6.3 | 1.2112 | 5.2014531043593095 |
12284 | 12284 | 2007-06-01 | CAD | Canada | 3.88 | 1.05345 | 3.6831363614789514 |
12283 | 12283 | 2007-06-01 | BRL | Brazil | 6.9 | 1.913 | 3.60690015682175 |
12282 | 12282 | 2007-06-01 | AUD | Australia | 3.45 | 1.17 | 2.94871794871795 |
12281 | 12281 | 2007-06-01 | ARS | Argentina | 8.25 | 3.0915 | 2.66860747210092 |
12280 | 12280 | 2007-06-01 | AED | UAE | 10.0 | 3.67285 | 2.7226812965408302 |
10989 | 10989 | 2007-06-01 | ZAR | South Africa | 15.5 | 6.971 | 2.22349734614833 |
10988 | 10988 | 2007-06-01 | USD | United States | 3.41 | 1.0 | 3.41 |
10987 | 10987 | 2007-06-01 | UYU | Uruguay | 62.0 | 23.945 | 2.5892670703696 |
10986 | 10986 | 2007-06-01 | UAH | Ukraine | 9.25 | 5.0275 | 1.83988065638986 |
10985 | 10985 | 2007-06-01 | TWD | Taiwan | 75.0 | 32.7705 | 2.2886437497139203 |
10984 | 10984 | 2007-06-01 | TRY | Turkey | 4.75 | 1.2981 | 3.6591942069178 |
10983 | 10983 | 2007-06-01 | THB | Thailand | 62.0 | 34.455 | 1.79944855608765 |
10982 | 10982 | 2007-06-01 | SEK | Sweden | 33.0 | 6.79165 | 4.85890762922118 |
10981 | 10981 | 2007-06-01 | SGD | Singapore | 3.95 | 1.52375 | 2.5922887612797405 |
10980 | 10980 | 2007-06-01 | SAR | Saudi Arabia | 9.0 | 3.75045 | 2.3997120345558502 |
10979 | 10979 | 2007-06-01 | RUB | Russia | 52.0 | 25.64825 | 2.0274287719435 |
10978 | 10978 | 2007-06-01 | PLN | Poland | 6.9 | 2.75185 | 2.50740410996239 |
10977 | 10977 | 2007-06-01 | PHP | Philippines | 85.0 | 45.8975 | 1.85195272073642 |
10976 | 10976 | 2007-06-01 | PEN | Peru | 9.5 | 3.167 | 2.99968424376381 |
10975 | 10975 | 2007-06-01 | PKR | Pakistan | 140.0 | 60.37 | 2.31903263210204 |
10974 | 10974 | 2007-06-01 | NZD | New Zealand | 4.6 | 1.2797 | 3.59459248261311 |
10973 | 10973 | 2007-06-01 | NOK | Norway | 40.0 | 5.8139 | 6.88006329658233 |
10972 | 10972 | 2007-06-01 | MYR | Malaysia | 5.5 | 3.4345 | 1.60139758334547 |
10971 | 10971 | 2007-06-01 | MXN | Mexico | 29.0 | 10.76755 | 2.693277486522 |
10970 | 10970 | 2007-06-01 | LKR | Sri Lanka | 210.0 | 111.4 | 1.8850987432675 |
10969 | 10969 | 2007-06-01 | KRW | South Korea | 2900.0 | 922.5 | 3.14363143631436 |
10968 | 10968 | 2007-06-01 | JPY | Japan | 280.0 | 122.315 | 2.2891714017087 |
10967 | 10967 | 2007-06-01 | IDR | Indonesia | 15900.0 | 9015.0 | 1.76372712146423 |
10966 | 10966 | 2007-06-01 | HUF | Hungary | 600.0 | 180.2106 | 3.32943789100086 |
10965 | 10965 | 2007-06-01 | HKD | Hong Kong | 12.0 | 7.81555 | 1.5354005796137198 |
10964 | 10964 | 2007-06-01 | GBP | Britain | 1.99 | 0.496610632 | 4.0071635034990605 |
10963 | 10963 | 2007-06-01 | EUR | Euro area | 3.057482443 | 0.7337564659999999 | 4.1668899487422 |
10962 | 10962 | 2007-06-01 | EGP | Egypt | 9.54 | 5.69025 | 1.67655199683669 |
10961 | 10961 | 2007-06-01 | DKK | Denmark | 27.75 | 5.4603 | 5.082138344047031 |
10960 | 10960 | 2007-06-01 | CZK | Czech Republic | 52.9 | 21.11675 | 2.5051203428557898 |
10959 | 10959 | 2007-06-01 | CRC | Costa Rica | 1130.0 | 518.625 | 2.17883827428296 |
10958 | 10958 | 2007-06-01 | COP | Colombia | 6900.0 | 1956.0 | 3.52760736196319 |
10957 | 10957 | 2007-06-01 | CNY | China | 11.0 | 7.6047 | 1.4464738911462598 |
10956 | 10956 | 2007-06-01 | CLP | Chile | 1565.0 | 526.75 | 2.9710488846701497 |
10955 | 10955 | 2007-06-01 | CHF | Switzerland | 6.3 | 1.2112 | 5.2014531043593095 |
10954 | 10954 | 2007-06-01 | CAD | Canada | 3.88 | 1.05345 | 3.6831363614789514 |
10953 | 10953 | 2007-06-01 | BRL | Brazil | 6.9 | 1.913 | 3.60690015682175 |
10952 | 10952 | 2007-06-01 | AUD | Australia | 3.45 | 1.17 | 2.94871794871795 |
10951 | 10951 | 2007-06-01 | ARS | Argentina | 8.25 | 3.0915 | 2.66860747210092 |
10950 | 10950 | 2007-06-01 | AED | UAE | 10.0 | 3.67285 | 2.7226812965408302 |
9659 | 9659 | 2007-06-01 | ZAR | South Africa | 15.5 | 6.971 | 2.22349734614833 |
9658 | 9658 | 2007-06-01 | USD | United States | 3.41 | 1.0 | 3.41 |
9657 | 9657 | 2007-06-01 | UYU | Uruguay | 62.0 | 23.945 | 2.5892670703696 |
9656 | 9656 | 2007-06-01 | UAH | Ukraine | 9.25 | 5.0275 | 1.83988065638986 |
9655 | 9655 | 2007-06-01 | TWD | Taiwan | 75.0 | 32.7705 | 2.2886437497139203 |
9654 | 9654 | 2007-06-01 | TRY | Turkey | 4.75 | 1.2981 | 3.6591942069178 |
9653 | 9653 | 2007-06-01 | THB | Thailand | 62.0 | 34.455 | 1.79944855608765 |
9652 | 9652 | 2007-06-01 | SEK | Sweden | 33.0 | 6.79165 | 4.85890762922118 |
9651 | 9651 | 2007-06-01 | SGD | Singapore | 3.95 | 1.52375 | 2.5922887612797405 |
9650 | 9650 | 2007-06-01 | SAR | Saudi Arabia | 9.0 | 3.75045 | 2.3997120345558502 |
9649 | 9649 | 2007-06-01 | RUB | Russia | 52.0 | 25.64825 | 2.0274287719435 |
9648 | 9648 | 2007-06-01 | PLN | Poland | 6.9 | 2.75185 | 2.50740410996239 |
9647 | 9647 | 2007-06-01 | PHP | Philippines | 85.0 | 45.8975 | 1.85195272073642 |
9646 | 9646 | 2007-06-01 | PEN | Peru | 9.5 | 3.167 | 2.99968424376381 |
9645 | 9645 | 2007-06-01 | PKR | Pakistan | 140.0 | 60.37 | 2.31903263210204 |
9644 | 9644 | 2007-06-01 | NZD | New Zealand | 4.6 | 1.2797 | 3.59459248261311 |
9643 | 9643 | 2007-06-01 | NOK | Norway | 40.0 | 5.8139 | 6.88006329658233 |
9642 | 9642 | 2007-06-01 | MYR | Malaysia | 5.5 | 3.4345 | 1.60139758334547 |
9641 | 9641 | 2007-06-01 | MXN | Mexico | 29.0 | 10.76755 | 2.693277486522 |
9640 | 9640 | 2007-06-01 | LKR | Sri Lanka | 210.0 | 111.4 | 1.8850987432675 |
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 );