bigmac
430 rows where "date" is on date 2018-01-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
3738 | 3738 | 2018-01-01 | GBP | Britain | 3.19 | 0.72285673 | 4.41304599875552 |
3739 | 3739 | 2018-01-01 | HKD | Hong Kong | 20.5 | 7.819 | 2.62181864688579 |
3740 | 3740 | 2018-01-01 | HUF | Hungary | 864.0 | 252.14215 | 3.42663850530346 |
3741 | 3741 | 2018-01-01 | IDR | Indonesia | 35750.0 | 13359.0 | 2.6760985103675403 |
3742 | 3742 | 2018-01-01 | INR | India | 180.0 | 63.86125 | 2.8186106598289298 |
3743 | 3743 | 2018-01-01 | ILS | Israel | 16.5 | 3.43635 | 4.80160635558078 |
3744 | 3744 | 2018-01-01 | JPY | Japan | 380.0 | 110.725 | 3.4319259426507096 |
3745 | 3745 | 2018-01-01 | KRW | South Korea | 4400.0 | 1069.25 | 4.115033902267951 |
3746 | 3746 | 2018-01-01 | LKR | Sri Lanka | 580.0 | 153.8 | 3.77113133940182 |
3747 | 3747 | 2018-01-01 | MXN | Mexico | 48.0 | 18.6635 | 2.57186486993329 |
3748 | 3748 | 2018-01-01 | MYR | Malaysia | 9.0 | 3.954 | 2.27617602427921 |
3749 | 3749 | 2018-01-01 | NOK | Norway | 49.0 | 7.8501 | 6.24195870116304 |
3750 | 3750 | 2018-01-01 | NZD | New Zealand | 6.2 | 1.374664925 | 4.51019000139252 |
3751 | 3751 | 2018-01-01 | PKR | Pakistan | 375.0 | 110.505 | 3.3935116058096897 |
3752 | 3752 | 2018-01-01 | PEN | Peru | 10.5 | 3.212 | 3.26899128268991 |
3753 | 3753 | 2018-01-01 | PHP | Philippines | 134.0 | 50.725 | 2.6416954164613102 |
3754 | 3754 | 2018-01-01 | PLN | Poland | 10.1 | 3.40575 | 2.96557292813624 |
3755 | 3755 | 2018-01-01 | RUB | Russia | 130.0 | 56.745 | 2.2909507445589905 |
3756 | 3756 | 2018-01-01 | SAR | Saudi Arabia | 12.0 | 3.7503 | 3.1997440204783603 |
3757 | 3757 | 2018-01-01 | SGD | Singapore | 5.8 | 1.32255 | 4.38546746814865 |
3758 | 3758 | 2018-01-01 | SEK | Sweden | 49.1 | 8.0188 | 6.12311068987879 |
3759 | 3759 | 2018-01-01 | THB | Thailand | 119.0 | 31.95 | 3.724569640062601 |
3760 | 3760 | 2018-01-01 | TRY | Turkey | 10.75 | 3.8026 | 2.827013096302529 |
3761 | 3761 | 2018-01-01 | TWD | Taiwan | 69.0 | 29.553 | 2.33478834636078 |
3762 | 3762 | 2018-01-01 | UAH | Ukraine | 47.0 | 28.715 | 1.6367752045969 |
3763 | 3763 | 2018-01-01 | UYU | Uruguay | 140.0 | 28.58 | 4.898530440867741 |
3764 | 3764 | 2018-01-01 | USD | United States | 5.28 | 1.0 | 5.28 |
3765 | 3765 | 2018-01-01 | VND | Vietnam | 65000.0 | 22711.5 | 2.861986218435589 |
3766 | 3766 | 2018-01-01 | ZAR | South Africa | 30.0 | 12.25815 | 2.4473513539971403 |
5054 | 5054 | 2018-01-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
5055 | 5055 | 2018-01-01 | ARS | Argentina | 75.0 | 18.9375 | 3.96039603960396 |
5056 | 5056 | 2018-01-01 | AUD | Australia | 5.9 | 1.253682693 | 4.70613499966375 |
5057 | 5057 | 2018-01-01 | BRL | Brazil | 16.5 | 3.2279 | 5.11168251804579 |
5058 | 5058 | 2018-01-01 | CAD | Canada | 6.55 | 1.2459 | 5.257243759531259 |
5059 | 5059 | 2018-01-01 | CHF | Switzerland | 6.5 | 0.96085 | 6.76484362803768 |
5060 | 5060 | 2018-01-01 | CLP | Chile | 2600.0 | 605.935 | 4.29088928680469 |
5061 | 5061 | 2018-01-01 | CNY | China | 20.4 | 6.432 | 3.17164179104478 |
5062 | 5062 | 2018-01-01 | COP | Colombia | 10900.0 | 2844.12 | 3.83246839092584 |
5063 | 5063 | 2018-01-01 | CRC | Costa Rica | 2290.0 | 568.53 | 4.02793168346437 |
5064 | 5064 | 2018-01-01 | CZK | Czech Republic | 79.0 | 20.747 | 3.80777943799104 |
5065 | 5065 | 2018-01-01 | DKK | Denmark | 30.0 | 6.0827 | 4.93202031992372 |
5066 | 5066 | 2018-01-01 | EGP | Egypt | 34.21 | 17.7 | 1.93276836158192 |
5067 | 5067 | 2018-01-01 | EUR | Euro area | 3.95 | 0.816826629 | 4.8357874973246 |
5068 | 5068 | 2018-01-01 | GBP | Britain | 3.19 | 0.72285673 | 4.41304599875552 |
5069 | 5069 | 2018-01-01 | HKD | Hong Kong | 20.5 | 7.819 | 2.62181864688579 |
5070 | 5070 | 2018-01-01 | HUF | Hungary | 864.0 | 252.14215 | 3.42663850530346 |
5071 | 5071 | 2018-01-01 | IDR | Indonesia | 35750.0 | 13359.0 | 2.6760985103675403 |
5072 | 5072 | 2018-01-01 | INR | India | 180.0 | 63.86125 | 2.8186106598289298 |
5073 | 5073 | 2018-01-01 | ILS | Israel | 16.5 | 3.43635 | 4.80160635558078 |
5074 | 5074 | 2018-01-01 | JPY | Japan | 380.0 | 110.725 | 3.4319259426507096 |
5075 | 5075 | 2018-01-01 | KRW | South Korea | 4400.0 | 1069.25 | 4.115033902267951 |
5076 | 5076 | 2018-01-01 | LKR | Sri Lanka | 580.0 | 153.8 | 3.77113133940182 |
5077 | 5077 | 2018-01-01 | MXN | Mexico | 48.0 | 18.6635 | 2.57186486993329 |
5078 | 5078 | 2018-01-01 | MYR | Malaysia | 9.0 | 3.954 | 2.27617602427921 |
5079 | 5079 | 2018-01-01 | NOK | Norway | 49.0 | 7.8501 | 6.24195870116304 |
5080 | 5080 | 2018-01-01 | NZD | New Zealand | 6.2 | 1.374664925 | 4.51019000139252 |
5081 | 5081 | 2018-01-01 | PKR | Pakistan | 375.0 | 110.505 | 3.3935116058096897 |
5082 | 5082 | 2018-01-01 | PEN | Peru | 10.5 | 3.212 | 3.26899128268991 |
5083 | 5083 | 2018-01-01 | PHP | Philippines | 134.0 | 50.725 | 2.6416954164613102 |
5084 | 5084 | 2018-01-01 | PLN | Poland | 10.1 | 3.40575 | 2.96557292813624 |
5085 | 5085 | 2018-01-01 | RUB | Russia | 130.0 | 56.745 | 2.2909507445589905 |
5086 | 5086 | 2018-01-01 | SAR | Saudi Arabia | 12.0 | 3.7503 | 3.1997440204783603 |
5087 | 5087 | 2018-01-01 | SGD | Singapore | 5.8 | 1.32255 | 4.38546746814865 |
5088 | 5088 | 2018-01-01 | SEK | Sweden | 49.1 | 8.0188 | 6.12311068987879 |
5089 | 5089 | 2018-01-01 | THB | Thailand | 119.0 | 31.95 | 3.724569640062601 |
5090 | 5090 | 2018-01-01 | TRY | Turkey | 10.75 | 3.8026 | 2.827013096302529 |
5091 | 5091 | 2018-01-01 | TWD | Taiwan | 69.0 | 29.553 | 2.33478834636078 |
5092 | 5092 | 2018-01-01 | UAH | Ukraine | 47.0 | 28.715 | 1.6367752045969 |
5093 | 5093 | 2018-01-01 | UYU | Uruguay | 140.0 | 28.58 | 4.898530440867741 |
5094 | 5094 | 2018-01-01 | USD | United States | 5.28 | 1.0 | 5.28 |
5095 | 5095 | 2018-01-01 | VND | Vietnam | 65000.0 | 22711.5 | 2.861986218435589 |
5096 | 5096 | 2018-01-01 | ZAR | South Africa | 30.0 | 12.25815 | 2.4473513539971403 |
6384 | 6384 | 2018-01-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
6385 | 6385 | 2018-01-01 | ARS | Argentina | 75.0 | 18.9375 | 3.96039603960396 |
6386 | 6386 | 2018-01-01 | AUD | Australia | 5.9 | 1.253682693 | 4.70613499966375 |
6387 | 6387 | 2018-01-01 | BRL | Brazil | 16.5 | 3.2279 | 5.11168251804579 |
6388 | 6388 | 2018-01-01 | CAD | Canada | 6.55 | 1.2459 | 5.257243759531259 |
6389 | 6389 | 2018-01-01 | CHF | Switzerland | 6.5 | 0.96085 | 6.76484362803768 |
6390 | 6390 | 2018-01-01 | CLP | Chile | 2600.0 | 605.935 | 4.29088928680469 |
6391 | 6391 | 2018-01-01 | CNY | China | 20.4 | 6.432 | 3.17164179104478 |
6392 | 6392 | 2018-01-01 | COP | Colombia | 10900.0 | 2844.12 | 3.83246839092584 |
6393 | 6393 | 2018-01-01 | CRC | Costa Rica | 2290.0 | 568.53 | 4.02793168346437 |
6394 | 6394 | 2018-01-01 | CZK | Czech Republic | 79.0 | 20.747 | 3.80777943799104 |
6395 | 6395 | 2018-01-01 | DKK | Denmark | 30.0 | 6.0827 | 4.93202031992372 |
6396 | 6396 | 2018-01-01 | EGP | Egypt | 34.21 | 17.7 | 1.93276836158192 |
6397 | 6397 | 2018-01-01 | EUR | Euro area | 3.95 | 0.816826629 | 4.8357874973246 |
6398 | 6398 | 2018-01-01 | GBP | Britain | 3.19 | 0.72285673 | 4.41304599875552 |
6399 | 6399 | 2018-01-01 | HKD | Hong Kong | 20.5 | 7.819 | 2.62181864688579 |
6400 | 6400 | 2018-01-01 | HUF | Hungary | 864.0 | 252.14215 | 3.42663850530346 |
6401 | 6401 | 2018-01-01 | IDR | Indonesia | 35750.0 | 13359.0 | 2.6760985103675403 |
6402 | 6402 | 2018-01-01 | INR | India | 180.0 | 63.86125 | 2.8186106598289298 |
6403 | 6403 | 2018-01-01 | ILS | Israel | 16.5 | 3.43635 | 4.80160635558078 |
6404 | 6404 | 2018-01-01 | JPY | Japan | 380.0 | 110.725 | 3.4319259426507096 |
6405 | 6405 | 2018-01-01 | KRW | South Korea | 4400.0 | 1069.25 | 4.115033902267951 |
6406 | 6406 | 2018-01-01 | LKR | Sri Lanka | 580.0 | 153.8 | 3.77113133940182 |
6407 | 6407 | 2018-01-01 | MXN | Mexico | 48.0 | 18.6635 | 2.57186486993329 |
6408 | 6408 | 2018-01-01 | MYR | Malaysia | 9.0 | 3.954 | 2.27617602427921 |
6409 | 6409 | 2018-01-01 | NOK | Norway | 49.0 | 7.8501 | 6.24195870116304 |
6410 | 6410 | 2018-01-01 | NZD | New Zealand | 6.2 | 1.374664925 | 4.51019000139252 |
6411 | 6411 | 2018-01-01 | PKR | Pakistan | 375.0 | 110.505 | 3.3935116058096897 |
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 );