bigmac
400 rows where "date" is on date 2006-05-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
12239 | 12239 | 2006-05-01 | ZAR | South Africa | 13.95 | 6.597 | 2.11459754433834 |
12238 | 12238 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
12237 | 12237 | 2006-05-01 | UYU | Uruguay | 42.28 | 23.925 | 1.76718913270637 |
12236 | 12236 | 2006-05-01 | UAH | Ukraine | 8.5 | 5.05 | 1.68316831683168 |
12235 | 12235 | 2006-05-01 | TWD | Taiwan | 75.0 | 32.141 | 2.3334681559379 |
12234 | 12234 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
12233 | 12233 | 2006-05-01 | THB | Thailand | 60.0 | 38.445 | 1.56067108856808 |
12232 | 12232 | 2006-05-01 | SEK | Sweden | 33.0 | 7.28455 | 4.53013569815569 |
12231 | 12231 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
12230 | 12230 | 2006-05-01 | SAR | Saudi Arabia | 9.0 | 3.749 | 2.40064017071219 |
12229 | 12229 | 2006-05-01 | RUB | Russia | 48.0 | 27.06375 | 1.77359013440488 |
12228 | 12228 | 2006-05-01 | PLN | Poland | 6.5 | 3.09915 | 2.09734927318781 |
12227 | 12227 | 2006-05-01 | PHP | Philippines | 85.0 | 52.625 | 1.6152019002375302 |
12226 | 12226 | 2006-05-01 | PEN | Peru | 9.5 | 3.261 | 2.91321680466115 |
12225 | 12225 | 2006-05-01 | PKR | Pakistan | 130.0 | 60.055 | 2.16468237449005 |
12224 | 12224 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
12223 | 12223 | 2006-05-01 | NOK | Norway | 43.0 | 6.1023 | 7.04652344198089 |
12222 | 12222 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
12221 | 12221 | 2006-05-01 | MXN | Mexico | 29.0 | 11.3031 | 2.56566782564075 |
12220 | 12220 | 2006-05-01 | LKR | Sri Lanka | 190.0 | 102.955 | 1.84546646593172 |
12219 | 12219 | 2006-05-01 | KRW | South Korea | 2500.0 | 952.4 | 2.62494750104998 |
12218 | 12218 | 2006-05-01 | JPY | Japan | 250.0 | 112.105 | 2.23005218322109 |
12217 | 12217 | 2006-05-01 | IDR | Indonesia | 14600.0 | 9325.0 | 1.5656836461126 |
12216 | 12216 | 2006-05-01 | HUF | Hungary | 560.0 | 206.3444 | 2.71390936705818 |
12215 | 12215 | 2006-05-01 | HKD | Hong Kong | 12.0 | 7.7533 | 1.54772806417912 |
12214 | 12214 | 2006-05-01 | GBP | Britain | 1.94 | 0.531801744 | 3.64797600212458 |
12213 | 12213 | 2006-05-01 | EUR | Euro area | 2.939573529 | 0.780365992 | 3.76691649704796 |
12212 | 12212 | 2006-05-01 | EGP | Egypt | 9.5 | 5.77075 | 1.6462331586015702 |
12211 | 12211 | 2006-05-01 | DKK | Denmark | 27.75 | 5.81825 | 4.76947535771065 |
12210 | 12210 | 2006-05-01 | CZK | Czech Republic | 59.05 | 22.1078 | 2.67100299441826 |
12209 | 12209 | 2006-05-01 | CRC | Costa Rica | 1130.0 | 509.535 | 2.2177083026681204 |
12208 | 12208 | 2006-05-01 | COP | Colombia | 6500.0 | 2503.6 | 2.59626138360761 |
12207 | 12207 | 2006-05-01 | CNY | China | 10.5 | 8.026 | 1.30824819337154 |
12206 | 12206 | 2006-05-01 | CLP | Chile | 1560.0 | 529.95 | 2.9436739315029703 |
12205 | 12205 | 2006-05-01 | CHF | Switzerland | 6.3 | 1.20885 | 5.211564710261821 |
12204 | 12204 | 2006-05-01 | CAD | Canada | 3.52 | 1.12045 | 3.1415948949083 |
12203 | 12203 | 2006-05-01 | BRL | Brazil | 6.4 | 2.3045 | 2.77717509221089 |
12202 | 12202 | 2006-05-01 | AUD | Australia | 3.25 | 1.33253 | 2.43896947911116 |
12201 | 12201 | 2006-05-01 | ARS | Argentina | 7.0 | 3.0565 | 2.29020121053493 |
12200 | 12200 | 2006-05-01 | AED | UAE | 9.0 | 3.6726 | 2.45057997059304 |
10909 | 10909 | 2006-05-01 | ZAR | South Africa | 13.95 | 6.597 | 2.11459754433834 |
10908 | 10908 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
10907 | 10907 | 2006-05-01 | UYU | Uruguay | 42.28 | 23.925 | 1.76718913270637 |
10906 | 10906 | 2006-05-01 | UAH | Ukraine | 8.5 | 5.05 | 1.68316831683168 |
10905 | 10905 | 2006-05-01 | TWD | Taiwan | 75.0 | 32.141 | 2.3334681559379 |
10904 | 10904 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
10903 | 10903 | 2006-05-01 | THB | Thailand | 60.0 | 38.445 | 1.56067108856808 |
10902 | 10902 | 2006-05-01 | SEK | Sweden | 33.0 | 7.28455 | 4.53013569815569 |
10901 | 10901 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
10900 | 10900 | 2006-05-01 | SAR | Saudi Arabia | 9.0 | 3.749 | 2.40064017071219 |
10899 | 10899 | 2006-05-01 | RUB | Russia | 48.0 | 27.06375 | 1.77359013440488 |
10898 | 10898 | 2006-05-01 | PLN | Poland | 6.5 | 3.09915 | 2.09734927318781 |
10897 | 10897 | 2006-05-01 | PHP | Philippines | 85.0 | 52.625 | 1.6152019002375302 |
10896 | 10896 | 2006-05-01 | PEN | Peru | 9.5 | 3.261 | 2.91321680466115 |
10895 | 10895 | 2006-05-01 | PKR | Pakistan | 130.0 | 60.055 | 2.16468237449005 |
10894 | 10894 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
10893 | 10893 | 2006-05-01 | NOK | Norway | 43.0 | 6.1023 | 7.04652344198089 |
10892 | 10892 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
10891 | 10891 | 2006-05-01 | MXN | Mexico | 29.0 | 11.3031 | 2.56566782564075 |
10890 | 10890 | 2006-05-01 | LKR | Sri Lanka | 190.0 | 102.955 | 1.84546646593172 |
10889 | 10889 | 2006-05-01 | KRW | South Korea | 2500.0 | 952.4 | 2.62494750104998 |
10888 | 10888 | 2006-05-01 | JPY | Japan | 250.0 | 112.105 | 2.23005218322109 |
10887 | 10887 | 2006-05-01 | IDR | Indonesia | 14600.0 | 9325.0 | 1.5656836461126 |
10886 | 10886 | 2006-05-01 | HUF | Hungary | 560.0 | 206.3444 | 2.71390936705818 |
10885 | 10885 | 2006-05-01 | HKD | Hong Kong | 12.0 | 7.7533 | 1.54772806417912 |
10884 | 10884 | 2006-05-01 | GBP | Britain | 1.94 | 0.531801744 | 3.64797600212458 |
10883 | 10883 | 2006-05-01 | EUR | Euro area | 2.939573529 | 0.780365992 | 3.76691649704796 |
10882 | 10882 | 2006-05-01 | EGP | Egypt | 9.5 | 5.77075 | 1.6462331586015702 |
10881 | 10881 | 2006-05-01 | DKK | Denmark | 27.75 | 5.81825 | 4.76947535771065 |
10880 | 10880 | 2006-05-01 | CZK | Czech Republic | 59.05 | 22.1078 | 2.67100299441826 |
10879 | 10879 | 2006-05-01 | CRC | Costa Rica | 1130.0 | 509.535 | 2.2177083026681204 |
10878 | 10878 | 2006-05-01 | COP | Colombia | 6500.0 | 2503.6 | 2.59626138360761 |
10877 | 10877 | 2006-05-01 | CNY | China | 10.5 | 8.026 | 1.30824819337154 |
10876 | 10876 | 2006-05-01 | CLP | Chile | 1560.0 | 529.95 | 2.9436739315029703 |
10875 | 10875 | 2006-05-01 | CHF | Switzerland | 6.3 | 1.20885 | 5.211564710261821 |
10874 | 10874 | 2006-05-01 | CAD | Canada | 3.52 | 1.12045 | 3.1415948949083 |
10873 | 10873 | 2006-05-01 | BRL | Brazil | 6.4 | 2.3045 | 2.77717509221089 |
10872 | 10872 | 2006-05-01 | AUD | Australia | 3.25 | 1.33253 | 2.43896947911116 |
10871 | 10871 | 2006-05-01 | ARS | Argentina | 7.0 | 3.0565 | 2.29020121053493 |
10870 | 10870 | 2006-05-01 | AED | UAE | 9.0 | 3.6726 | 2.45057997059304 |
9579 | 9579 | 2006-05-01 | ZAR | South Africa | 13.95 | 6.597 | 2.11459754433834 |
9578 | 9578 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
9577 | 9577 | 2006-05-01 | UYU | Uruguay | 42.28 | 23.925 | 1.76718913270637 |
9576 | 9576 | 2006-05-01 | UAH | Ukraine | 8.5 | 5.05 | 1.68316831683168 |
9575 | 9575 | 2006-05-01 | TWD | Taiwan | 75.0 | 32.141 | 2.3334681559379 |
9574 | 9574 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
9573 | 9573 | 2006-05-01 | THB | Thailand | 60.0 | 38.445 | 1.56067108856808 |
9572 | 9572 | 2006-05-01 | SEK | Sweden | 33.0 | 7.28455 | 4.53013569815569 |
9571 | 9571 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
9570 | 9570 | 2006-05-01 | SAR | Saudi Arabia | 9.0 | 3.749 | 2.40064017071219 |
9569 | 9569 | 2006-05-01 | RUB | Russia | 48.0 | 27.06375 | 1.77359013440488 |
9568 | 9568 | 2006-05-01 | PLN | Poland | 6.5 | 3.09915 | 2.09734927318781 |
9567 | 9567 | 2006-05-01 | PHP | Philippines | 85.0 | 52.625 | 1.6152019002375302 |
9566 | 9566 | 2006-05-01 | PEN | Peru | 9.5 | 3.261 | 2.91321680466115 |
9565 | 9565 | 2006-05-01 | PKR | Pakistan | 130.0 | 60.055 | 2.16468237449005 |
9564 | 9564 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
9563 | 9563 | 2006-05-01 | NOK | Norway | 43.0 | 6.1023 | 7.04652344198089 |
9562 | 9562 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
9561 | 9561 | 2006-05-01 | MXN | Mexico | 29.0 | 11.3031 | 2.56566782564075 |
9560 | 9560 | 2006-05-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 );