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 |
---|---|---|---|---|---|---|---|
1064 | 1064 | 2018-01-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
1065 | 1065 | 2018-01-01 | ARS | Argentina | 75.0 | 18.9375 | 3.96039603960396 |
1066 | 1066 | 2018-01-01 | AUD | Australia | 5.9 | 1.253682693 | 4.70613499966375 |
1067 | 1067 | 2018-01-01 | BRL | Brazil | 16.5 | 3.2279 | 5.11168251804579 |
1068 | 1068 | 2018-01-01 | CAD | Canada | 6.55 | 1.2459 | 5.257243759531259 |
1069 | 1069 | 2018-01-01 | CHF | Switzerland | 6.5 | 0.96085 | 6.76484362803768 |
1070 | 1070 | 2018-01-01 | CLP | Chile | 2600.0 | 605.935 | 4.29088928680469 |
1071 | 1071 | 2018-01-01 | CNY | China | 20.4 | 6.432 | 3.17164179104478 |
1072 | 1072 | 2018-01-01 | COP | Colombia | 10900.0 | 2844.12 | 3.83246839092584 |
1073 | 1073 | 2018-01-01 | CRC | Costa Rica | 2290.0 | 568.53 | 4.02793168346437 |
1074 | 1074 | 2018-01-01 | CZK | Czech Republic | 79.0 | 20.747 | 3.80777943799104 |
1075 | 1075 | 2018-01-01 | DKK | Denmark | 30.0 | 6.0827 | 4.93202031992372 |
1076 | 1076 | 2018-01-01 | EGP | Egypt | 34.21 | 17.7 | 1.93276836158192 |
1077 | 1077 | 2018-01-01 | EUR | Euro area | 3.95 | 0.816826629 | 4.8357874973246 |
1078 | 1078 | 2018-01-01 | GBP | Britain | 3.19 | 0.72285673 | 4.41304599875552 |
1079 | 1079 | 2018-01-01 | HKD | Hong Kong | 20.5 | 7.819 | 2.62181864688579 |
1080 | 1080 | 2018-01-01 | HUF | Hungary | 864.0 | 252.14215 | 3.42663850530346 |
1081 | 1081 | 2018-01-01 | IDR | Indonesia | 35750.0 | 13359.0 | 2.6760985103675403 |
1082 | 1082 | 2018-01-01 | INR | India | 180.0 | 63.86125 | 2.8186106598289298 |
1083 | 1083 | 2018-01-01 | ILS | Israel | 16.5 | 3.43635 | 4.80160635558078 |
1084 | 1084 | 2018-01-01 | JPY | Japan | 380.0 | 110.725 | 3.4319259426507096 |
1085 | 1085 | 2018-01-01 | KRW | South Korea | 4400.0 | 1069.25 | 4.115033902267951 |
1086 | 1086 | 2018-01-01 | LKR | Sri Lanka | 580.0 | 153.8 | 3.77113133940182 |
1087 | 1087 | 2018-01-01 | MXN | Mexico | 48.0 | 18.6635 | 2.57186486993329 |
1088 | 1088 | 2018-01-01 | MYR | Malaysia | 9.0 | 3.954 | 2.27617602427921 |
1089 | 1089 | 2018-01-01 | NOK | Norway | 49.0 | 7.8501 | 6.24195870116304 |
1090 | 1090 | 2018-01-01 | NZD | New Zealand | 6.2 | 1.374664925 | 4.51019000139252 |
1091 | 1091 | 2018-01-01 | PKR | Pakistan | 375.0 | 110.505 | 3.3935116058096897 |
1092 | 1092 | 2018-01-01 | PEN | Peru | 10.5 | 3.212 | 3.26899128268991 |
1093 | 1093 | 2018-01-01 | PHP | Philippines | 134.0 | 50.725 | 2.6416954164613102 |
1094 | 1094 | 2018-01-01 | PLN | Poland | 10.1 | 3.40575 | 2.96557292813624 |
1095 | 1095 | 2018-01-01 | RUB | Russia | 130.0 | 56.745 | 2.2909507445589905 |
1096 | 1096 | 2018-01-01 | SAR | Saudi Arabia | 12.0 | 3.7503 | 3.1997440204783603 |
1097 | 1097 | 2018-01-01 | SGD | Singapore | 5.8 | 1.32255 | 4.38546746814865 |
1098 | 1098 | 2018-01-01 | SEK | Sweden | 49.1 | 8.0188 | 6.12311068987879 |
1099 | 1099 | 2018-01-01 | THB | Thailand | 119.0 | 31.95 | 3.724569640062601 |
1100 | 1100 | 2018-01-01 | TRY | Turkey | 10.75 | 3.8026 | 2.827013096302529 |
1101 | 1101 | 2018-01-01 | TWD | Taiwan | 69.0 | 29.553 | 2.33478834636078 |
1102 | 1102 | 2018-01-01 | UAH | Ukraine | 47.0 | 28.715 | 1.6367752045969 |
1103 | 1103 | 2018-01-01 | UYU | Uruguay | 140.0 | 28.58 | 4.898530440867741 |
1104 | 1104 | 2018-01-01 | USD | United States | 5.28 | 1.0 | 5.28 |
1105 | 1105 | 2018-01-01 | VND | Vietnam | 65000.0 | 22711.5 | 2.861986218435589 |
1106 | 1106 | 2018-01-01 | ZAR | South Africa | 30.0 | 12.25815 | 2.4473513539971403 |
2394 | 2394 | 2018-01-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
2395 | 2395 | 2018-01-01 | ARS | Argentina | 75.0 | 18.9375 | 3.96039603960396 |
2396 | 2396 | 2018-01-01 | AUD | Australia | 5.9 | 1.253682693 | 4.70613499966375 |
2397 | 2397 | 2018-01-01 | BRL | Brazil | 16.5 | 3.2279 | 5.11168251804579 |
2398 | 2398 | 2018-01-01 | CAD | Canada | 6.55 | 1.2459 | 5.257243759531259 |
2399 | 2399 | 2018-01-01 | CHF | Switzerland | 6.5 | 0.96085 | 6.76484362803768 |
2400 | 2400 | 2018-01-01 | CLP | Chile | 2600.0 | 605.935 | 4.29088928680469 |
2401 | 2401 | 2018-01-01 | CNY | China | 20.4 | 6.432 | 3.17164179104478 |
2402 | 2402 | 2018-01-01 | COP | Colombia | 10900.0 | 2844.12 | 3.83246839092584 |
2403 | 2403 | 2018-01-01 | CRC | Costa Rica | 2290.0 | 568.53 | 4.02793168346437 |
2404 | 2404 | 2018-01-01 | CZK | Czech Republic | 79.0 | 20.747 | 3.80777943799104 |
2405 | 2405 | 2018-01-01 | DKK | Denmark | 30.0 | 6.0827 | 4.93202031992372 |
2406 | 2406 | 2018-01-01 | EGP | Egypt | 34.21 | 17.7 | 1.93276836158192 |
2407 | 2407 | 2018-01-01 | EUR | Euro area | 3.95 | 0.816826629 | 4.8357874973246 |
2408 | 2408 | 2018-01-01 | GBP | Britain | 3.19 | 0.72285673 | 4.41304599875552 |
2409 | 2409 | 2018-01-01 | HKD | Hong Kong | 20.5 | 7.819 | 2.62181864688579 |
2410 | 2410 | 2018-01-01 | HUF | Hungary | 864.0 | 252.14215 | 3.42663850530346 |
2411 | 2411 | 2018-01-01 | IDR | Indonesia | 35750.0 | 13359.0 | 2.6760985103675403 |
2412 | 2412 | 2018-01-01 | INR | India | 180.0 | 63.86125 | 2.8186106598289298 |
2413 | 2413 | 2018-01-01 | ILS | Israel | 16.5 | 3.43635 | 4.80160635558078 |
2414 | 2414 | 2018-01-01 | JPY | Japan | 380.0 | 110.725 | 3.4319259426507096 |
2415 | 2415 | 2018-01-01 | KRW | South Korea | 4400.0 | 1069.25 | 4.115033902267951 |
2416 | 2416 | 2018-01-01 | LKR | Sri Lanka | 580.0 | 153.8 | 3.77113133940182 |
2417 | 2417 | 2018-01-01 | MXN | Mexico | 48.0 | 18.6635 | 2.57186486993329 |
2418 | 2418 | 2018-01-01 | MYR | Malaysia | 9.0 | 3.954 | 2.27617602427921 |
2419 | 2419 | 2018-01-01 | NOK | Norway | 49.0 | 7.8501 | 6.24195870116304 |
2420 | 2420 | 2018-01-01 | NZD | New Zealand | 6.2 | 1.374664925 | 4.51019000139252 |
2421 | 2421 | 2018-01-01 | PKR | Pakistan | 375.0 | 110.505 | 3.3935116058096897 |
2422 | 2422 | 2018-01-01 | PEN | Peru | 10.5 | 3.212 | 3.26899128268991 |
2423 | 2423 | 2018-01-01 | PHP | Philippines | 134.0 | 50.725 | 2.6416954164613102 |
2424 | 2424 | 2018-01-01 | PLN | Poland | 10.1 | 3.40575 | 2.96557292813624 |
2425 | 2425 | 2018-01-01 | RUB | Russia | 130.0 | 56.745 | 2.2909507445589905 |
2426 | 2426 | 2018-01-01 | SAR | Saudi Arabia | 12.0 | 3.7503 | 3.1997440204783603 |
2427 | 2427 | 2018-01-01 | SGD | Singapore | 5.8 | 1.32255 | 4.38546746814865 |
2428 | 2428 | 2018-01-01 | SEK | Sweden | 49.1 | 8.0188 | 6.12311068987879 |
2429 | 2429 | 2018-01-01 | THB | Thailand | 119.0 | 31.95 | 3.724569640062601 |
2430 | 2430 | 2018-01-01 | TRY | Turkey | 10.75 | 3.8026 | 2.827013096302529 |
2431 | 2431 | 2018-01-01 | TWD | Taiwan | 69.0 | 29.553 | 2.33478834636078 |
2432 | 2432 | 2018-01-01 | UAH | Ukraine | 47.0 | 28.715 | 1.6367752045969 |
2433 | 2433 | 2018-01-01 | UYU | Uruguay | 140.0 | 28.58 | 4.898530440867741 |
2434 | 2434 | 2018-01-01 | USD | United States | 5.28 | 1.0 | 5.28 |
2435 | 2435 | 2018-01-01 | VND | Vietnam | 65000.0 | 22711.5 | 2.861986218435589 |
2436 | 2436 | 2018-01-01 | ZAR | South Africa | 30.0 | 12.25815 | 2.4473513539971403 |
3724 | 3724 | 2018-01-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
3725 | 3725 | 2018-01-01 | ARS | Argentina | 75.0 | 18.9375 | 3.96039603960396 |
3726 | 3726 | 2018-01-01 | AUD | Australia | 5.9 | 1.253682693 | 4.70613499966375 |
3727 | 3727 | 2018-01-01 | BRL | Brazil | 16.5 | 3.2279 | 5.11168251804579 |
3728 | 3728 | 2018-01-01 | CAD | Canada | 6.55 | 1.2459 | 5.257243759531259 |
3729 | 3729 | 2018-01-01 | CHF | Switzerland | 6.5 | 0.96085 | 6.76484362803768 |
3730 | 3730 | 2018-01-01 | CLP | Chile | 2600.0 | 605.935 | 4.29088928680469 |
3731 | 3731 | 2018-01-01 | CNY | China | 20.4 | 6.432 | 3.17164179104478 |
3732 | 3732 | 2018-01-01 | COP | Colombia | 10900.0 | 2844.12 | 3.83246839092584 |
3733 | 3733 | 2018-01-01 | CRC | Costa Rica | 2290.0 | 568.53 | 4.02793168346437 |
3734 | 3734 | 2018-01-01 | CZK | Czech Republic | 79.0 | 20.747 | 3.80777943799104 |
3735 | 3735 | 2018-01-01 | DKK | Denmark | 30.0 | 6.0827 | 4.93202031992372 |
3736 | 3736 | 2018-01-01 | EGP | Egypt | 34.21 | 17.7 | 1.93276836158192 |
3737 | 3737 | 2018-01-01 | EUR | Euro area | 3.95 | 0.816826629 | 4.8357874973246 |
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 );