bigmac
400 rows where "date" is on date 2007-01-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
12279 | 12279 | 2007-01-01 | ZAR | South Africa | 15.5 | 7.10975 | 2.1801047856816296 |
12278 | 12278 | 2007-01-01 | USD | United States | 3.22 | 1.0 | 3.22 |
12277 | 12277 | 2007-01-01 | UYU | Uruguay | 55.0 | 23.925 | 2.29885057471264 |
12276 | 12276 | 2007-01-01 | UAH | Ukraine | 9.0 | 5.05 | 1.7821782178217802 |
12275 | 12275 | 2007-01-01 | TWD | Taiwan | 75.0 | 32.9255 | 2.27786973622268 |
12274 | 12274 | 2007-01-01 | TRY | Turkey | 4.55 | 1.40975 | 3.22752261039191 |
12273 | 12273 | 2007-01-01 | THB | Thailand | 62.0 | 35.3 | 1.75637393767705 |
12272 | 12272 | 2007-01-01 | SEK | Sweden | 32.0 | 7.04125 | 4.544647612284749 |
12271 | 12271 | 2007-01-01 | SGD | Singapore | 3.6 | 1.53795 | 2.34077830878767 |
12270 | 12270 | 2007-01-01 | SAR | Saudi Arabia | 9.0 | 3.749 | 2.40064017071219 |
12269 | 12269 | 2007-01-01 | RUB | Russia | 49.0 | 26.5335 | 1.84672206832872 |
12268 | 12268 | 2007-01-01 | PLN | Poland | 6.9 | 2.97175 | 2.32186422141836 |
12267 | 12267 | 2007-01-01 | PHP | Philippines | 85.0 | 49.05 | 1.7329255861366 |
12266 | 12266 | 2007-01-01 | PEN | Peru | 9.5 | 3.1895 | 2.9785232795109 |
12265 | 12265 | 2007-01-01 | PKR | Pakistan | 140.0 | 60.055 | 2.33119640329698 |
12264 | 12264 | 2007-01-01 | NZD | New Zealand | 4.6 | 1.42796 | 3.2213787501050497 |
12263 | 12263 | 2007-01-01 | NOK | Norway | 41.5 | 6.1023 | 6.800714484702491 |
12262 | 12262 | 2007-01-01 | MYR | Malaysia | 5.5 | 3.502 | 1.57053112507139 |
12261 | 12261 | 2007-01-01 | MXN | Mexico | 29.0 | 10.8894 | 2.66314030157768 |
12260 | 12260 | 2007-01-01 | LKR | Sri Lanka | 190.0 | 102.955 | 1.84546646593172 |
12259 | 12259 | 2007-01-01 | KRW | South Korea | 2900.0 | 940.15 | 3.08461415731532 |
12258 | 12258 | 2007-01-01 | JPY | Japan | 280.0 | 121.585 | 2.3029156557141097 |
12257 | 12257 | 2007-01-01 | IDR | Indonesia | 15900.0 | 9090.0 | 1.74917491749175 |
12256 | 12256 | 2007-01-01 | HUF | Hungary | 590.0 | 194.4237 | 3.03460946376393 |
12255 | 12255 | 2007-01-01 | HKD | Hong Kong | 12.0 | 7.79845 | 1.53876731914675 |
12254 | 12254 | 2007-01-01 | GBP | Britain | 1.94 | 0.506034461 | 3.83373099959688 |
12253 | 12253 | 2007-01-01 | EUR | Euro area | 2.94 | 0.771813376 | 3.80921099765962 |
12252 | 12252 | 2007-01-01 | EGP | Egypt | 9.09 | 5.7 | 1.59473684210526 |
12251 | 12251 | 2007-01-01 | DKK | Denmark | 27.75 | 5.75305 | 4.8235283892891605 |
12250 | 12250 | 2007-01-01 | CZK | Czech Republic | 52.1 | 21.50115 | 2.42312620487741 |
12249 | 12249 | 2007-01-01 | CRC | Costa Rica | 1130.0 | 509.535 | 2.2177083026681204 |
12248 | 12248 | 2007-01-01 | COP | Colombia | 6900.0 | 2239.325 | 3.0812856552755896 |
12247 | 12247 | 2007-01-01 | CNY | China | 11.0 | 7.7743 | 1.41491838493498 |
12246 | 12246 | 2007-01-01 | CLP | Chile | 1670.0 | 540.15 | 3.09173377765436 |
12245 | 12245 | 2007-01-01 | CHF | Switzerland | 6.3 | 1.2485 | 5.04605526631958 |
12244 | 12244 | 2007-01-01 | CAD | Canada | 3.63 | 1.17485 | 3.0897561390815897 |
12243 | 12243 | 2007-01-01 | BRL | Brazil | 6.4 | 2.1335 | 2.99976564330912 |
12242 | 12242 | 2007-01-01 | AUD | Australia | 3.45 | 1.266865 | 2.72325780568569 |
12241 | 12241 | 2007-01-01 | ARS | Argentina | 8.25 | 3.08875 | 2.67098340752732 |
12240 | 12240 | 2007-01-01 | AED | UAE | 10.0 | 3.6726 | 2.72286663399227 |
10949 | 10949 | 2007-01-01 | ZAR | South Africa | 15.5 | 7.10975 | 2.1801047856816296 |
10948 | 10948 | 2007-01-01 | USD | United States | 3.22 | 1.0 | 3.22 |
10947 | 10947 | 2007-01-01 | UYU | Uruguay | 55.0 | 23.925 | 2.29885057471264 |
10946 | 10946 | 2007-01-01 | UAH | Ukraine | 9.0 | 5.05 | 1.7821782178217802 |
10945 | 10945 | 2007-01-01 | TWD | Taiwan | 75.0 | 32.9255 | 2.27786973622268 |
10944 | 10944 | 2007-01-01 | TRY | Turkey | 4.55 | 1.40975 | 3.22752261039191 |
10943 | 10943 | 2007-01-01 | THB | Thailand | 62.0 | 35.3 | 1.75637393767705 |
10942 | 10942 | 2007-01-01 | SEK | Sweden | 32.0 | 7.04125 | 4.544647612284749 |
10941 | 10941 | 2007-01-01 | SGD | Singapore | 3.6 | 1.53795 | 2.34077830878767 |
10940 | 10940 | 2007-01-01 | SAR | Saudi Arabia | 9.0 | 3.749 | 2.40064017071219 |
10939 | 10939 | 2007-01-01 | RUB | Russia | 49.0 | 26.5335 | 1.84672206832872 |
10938 | 10938 | 2007-01-01 | PLN | Poland | 6.9 | 2.97175 | 2.32186422141836 |
10937 | 10937 | 2007-01-01 | PHP | Philippines | 85.0 | 49.05 | 1.7329255861366 |
10936 | 10936 | 2007-01-01 | PEN | Peru | 9.5 | 3.1895 | 2.9785232795109 |
10935 | 10935 | 2007-01-01 | PKR | Pakistan | 140.0 | 60.055 | 2.33119640329698 |
10934 | 10934 | 2007-01-01 | NZD | New Zealand | 4.6 | 1.42796 | 3.2213787501050497 |
10933 | 10933 | 2007-01-01 | NOK | Norway | 41.5 | 6.1023 | 6.800714484702491 |
10932 | 10932 | 2007-01-01 | MYR | Malaysia | 5.5 | 3.502 | 1.57053112507139 |
10931 | 10931 | 2007-01-01 | MXN | Mexico | 29.0 | 10.8894 | 2.66314030157768 |
10930 | 10930 | 2007-01-01 | LKR | Sri Lanka | 190.0 | 102.955 | 1.84546646593172 |
10929 | 10929 | 2007-01-01 | KRW | South Korea | 2900.0 | 940.15 | 3.08461415731532 |
10928 | 10928 | 2007-01-01 | JPY | Japan | 280.0 | 121.585 | 2.3029156557141097 |
10927 | 10927 | 2007-01-01 | IDR | Indonesia | 15900.0 | 9090.0 | 1.74917491749175 |
10926 | 10926 | 2007-01-01 | HUF | Hungary | 590.0 | 194.4237 | 3.03460946376393 |
10925 | 10925 | 2007-01-01 | HKD | Hong Kong | 12.0 | 7.79845 | 1.53876731914675 |
10924 | 10924 | 2007-01-01 | GBP | Britain | 1.94 | 0.506034461 | 3.83373099959688 |
10923 | 10923 | 2007-01-01 | EUR | Euro area | 2.94 | 0.771813376 | 3.80921099765962 |
10922 | 10922 | 2007-01-01 | EGP | Egypt | 9.09 | 5.7 | 1.59473684210526 |
10921 | 10921 | 2007-01-01 | DKK | Denmark | 27.75 | 5.75305 | 4.8235283892891605 |
10920 | 10920 | 2007-01-01 | CZK | Czech Republic | 52.1 | 21.50115 | 2.42312620487741 |
10919 | 10919 | 2007-01-01 | CRC | Costa Rica | 1130.0 | 509.535 | 2.2177083026681204 |
10918 | 10918 | 2007-01-01 | COP | Colombia | 6900.0 | 2239.325 | 3.0812856552755896 |
10917 | 10917 | 2007-01-01 | CNY | China | 11.0 | 7.7743 | 1.41491838493498 |
10916 | 10916 | 2007-01-01 | CLP | Chile | 1670.0 | 540.15 | 3.09173377765436 |
10915 | 10915 | 2007-01-01 | CHF | Switzerland | 6.3 | 1.2485 | 5.04605526631958 |
10914 | 10914 | 2007-01-01 | CAD | Canada | 3.63 | 1.17485 | 3.0897561390815897 |
10913 | 10913 | 2007-01-01 | BRL | Brazil | 6.4 | 2.1335 | 2.99976564330912 |
10912 | 10912 | 2007-01-01 | AUD | Australia | 3.45 | 1.266865 | 2.72325780568569 |
10911 | 10911 | 2007-01-01 | ARS | Argentina | 8.25 | 3.08875 | 2.67098340752732 |
10910 | 10910 | 2007-01-01 | AED | UAE | 10.0 | 3.6726 | 2.72286663399227 |
9619 | 9619 | 2007-01-01 | ZAR | South Africa | 15.5 | 7.10975 | 2.1801047856816296 |
9618 | 9618 | 2007-01-01 | USD | United States | 3.22 | 1.0 | 3.22 |
9617 | 9617 | 2007-01-01 | UYU | Uruguay | 55.0 | 23.925 | 2.29885057471264 |
9616 | 9616 | 2007-01-01 | UAH | Ukraine | 9.0 | 5.05 | 1.7821782178217802 |
9615 | 9615 | 2007-01-01 | TWD | Taiwan | 75.0 | 32.9255 | 2.27786973622268 |
9614 | 9614 | 2007-01-01 | TRY | Turkey | 4.55 | 1.40975 | 3.22752261039191 |
9613 | 9613 | 2007-01-01 | THB | Thailand | 62.0 | 35.3 | 1.75637393767705 |
9612 | 9612 | 2007-01-01 | SEK | Sweden | 32.0 | 7.04125 | 4.544647612284749 |
9611 | 9611 | 2007-01-01 | SGD | Singapore | 3.6 | 1.53795 | 2.34077830878767 |
9610 | 9610 | 2007-01-01 | SAR | Saudi Arabia | 9.0 | 3.749 | 2.40064017071219 |
9609 | 9609 | 2007-01-01 | RUB | Russia | 49.0 | 26.5335 | 1.84672206832872 |
9608 | 9608 | 2007-01-01 | PLN | Poland | 6.9 | 2.97175 | 2.32186422141836 |
9607 | 9607 | 2007-01-01 | PHP | Philippines | 85.0 | 49.05 | 1.7329255861366 |
9606 | 9606 | 2007-01-01 | PEN | Peru | 9.5 | 3.1895 | 2.9785232795109 |
9605 | 9605 | 2007-01-01 | PKR | Pakistan | 140.0 | 60.055 | 2.33119640329698 |
9604 | 9604 | 2007-01-01 | NZD | New Zealand | 4.6 | 1.42796 | 3.2213787501050497 |
9603 | 9603 | 2007-01-01 | NOK | Norway | 41.5 | 6.1023 | 6.800714484702491 |
9602 | 9602 | 2007-01-01 | MYR | Malaysia | 5.5 | 3.502 | 1.57053112507139 |
9601 | 9601 | 2007-01-01 | MXN | Mexico | 29.0 | 10.8894 | 2.66314030157768 |
9600 | 9600 | 2007-01-01 | LKR | Sri Lanka | 190.0 | 102.955 | 1.84546646593172 |
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 );