bigmac
560 rows where "date" is on date 2018-07-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
1107 | 1107 | 2018-07-01 | AED | United Arab Emirates | 14.0 | 3.67315 | 3.81144249486136 |
1108 | 1108 | 2018-07-01 | ARS | Argentina | 75.0 | 27.725 | 2.705139765554549 |
1109 | 1109 | 2018-07-01 | AUD | Australia | 6.05 | 1.33985395591881 | 4.51541749999998 |
1110 | 1110 | 2018-07-01 | AZN | Azerbaijan | 3.95 | 1.70175 | 2.32114000293815 |
1111 | 1111 | 2018-07-01 | BHD | Bahrain | 1.2 | 0.37955 | 3.161638782769069 |
1112 | 1112 | 2018-07-01 | BRL | Brazil | 16.9 | 3.83835 | 4.4029335521773705 |
1113 | 1113 | 2018-07-01 | CAD | Canada | 6.65 | 1.31235 | 5.067245780470151 |
1114 | 1114 | 2018-07-01 | CHF | Switzerland | 6.5 | 0.99325 | 6.54417316889001 |
1115 | 1115 | 2018-07-01 | CLP | Chile | 2640.0 | 651.73 | 4.05075721541129 |
1116 | 1116 | 2018-07-01 | CNY | China | 20.5 | 6.622000000000001 | 3.09574146783449 |
1117 | 1117 | 2018-07-01 | COP | Colombia | 11900.0 | 2874.07 | 4.14046978674841 |
1118 | 1118 | 2018-07-01 | CRC | Costa Rica | 2290.0 | 567.8 | 4.03311025008806 |
1119 | 1119 | 2018-07-01 | CZK | Czech Republic | 75.0 | 22.06475 | 3.39908677868546 |
1120 | 1120 | 2018-07-01 | DKK | Denmark | 30.0 | 6.3591 | 4.71764872387602 |
1121 | 1121 | 2018-07-01 | EGP | Egypt | 31.37 | 17.905 | 1.7520245741413 |
1122 | 1122 | 2018-07-01 | EUR | Euro area | 4.04 | 0.8532059212490941 | 4.735082 |
1123 | 1123 | 2018-07-01 | GBP | Britain | 3.19 | 0.7538635506973241 | 4.231535 |
1124 | 1124 | 2018-07-01 | GTQ | Guatemala | 25.0 | 7.4871 | 3.33907654499072 |
1125 | 1125 | 2018-07-01 | HKD | Hong Kong | 20.0 | 7.84825 | 2.54833880164368 |
1126 | 1126 | 2018-07-01 | HNL | Honduras | 85.0 | 23.9926 | 3.5427590173636903 |
1127 | 1127 | 2018-07-01 | HRK | Croatia | 21.0 | 6.31275 | 3.32660092669597 |
1128 | 1128 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
1129 | 1129 | 2018-07-01 | IDR | Indonesia | 31500.0 | 14360.0 | 2.19359331476323 |
1130 | 1130 | 2018-07-01 | INR | India | 173.0 | 68.825 | 2.51362150381402 |
1131 | 1131 | 2018-07-01 | ILS | Israel | 17.0 | 3.6349 | 4.67688244518419 |
1132 | 1132 | 2018-07-01 | JOD | Jordan | 1.95 | 0.71005 | 2.74628547285402 |
1133 | 1133 | 2018-07-01 | JPY | Japan | 390.0 | 111.25 | 3.50561797752809 |
1134 | 1134 | 2018-07-01 | KRW | South Korea | 4500.0 | 1116.0 | 4.03225806451613 |
1135 | 1135 | 2018-07-01 | KWD | Kuwait | 1.05 | 0.3025 | 3.47107438016529 |
1136 | 1136 | 2018-07-01 | LBP | Lebanon | 6500.0 | 1511.0 | 4.3017868960953 |
1137 | 1137 | 2018-07-01 | LKR | Sri Lanka | 580.0 | 159.27 | 3.6416148678344897 |
1138 | 1138 | 2018-07-01 | MDL | Moldova | 43.0 | 16.6526 | 2.58217935937932 |
1139 | 1139 | 2018-07-01 | MXN | Mexico | 49.0 | 19.0515 | 2.57197595989817 |
1140 | 1140 | 2018-07-01 | MYR | Malaysia | 8.45 | 4.0225 | 2.10068365444375 |
1141 | 1141 | 2018-07-01 | NIO | Nicaragua | 103.0 | 31.5872 | 3.26081450714213 |
1142 | 1142 | 2018-07-01 | NOK | Norway | 42.0 | 8.0415 | 5.22290617422123 |
1143 | 1143 | 2018-07-01 | NZD | New Zealand | 6.2 | 1.46434324205594 | 4.23397999999999 |
1144 | 1144 | 2018-07-01 | OMR | Oman | 1.05 | 0.385 | 2.7272727272727297 |
1145 | 1145 | 2018-07-01 | PKR | Pakistan | 375.0 | 121.49 | 3.0866738003127794 |
1146 | 1146 | 2018-07-01 | PEN | Peru | 10.5 | 3.2715 | 3.20953690967446 |
1147 | 1147 | 2018-07-01 | PHP | Philippines | 140.0 | 53.487 | 2.6174584478471403 |
1148 | 1148 | 2018-07-01 | PLN | Poland | 10.1 | 3.68695 | 2.73939163807483 |
1149 | 1149 | 2018-07-01 | QAR | Qatar | 12.0 | 3.641 | 3.29579785773139 |
1150 | 1150 | 2018-07-01 | RON | Romania | 9.2 | 3.97325 | 2.3154848046309704 |
1151 | 1151 | 2018-07-01 | RUB | Russia | 130.0 | 62.14065 | 2.09202832606353 |
1152 | 1152 | 2018-07-01 | SAR | Saudi Arabia | 12.0 | 3.7504 | 3.19965870307167 |
1153 | 1153 | 2018-07-01 | SGD | Singapore | 5.8 | 1.35585 | 4.27775933915994 |
1154 | 1154 | 2018-07-01 | SEK | Sweden | 51.0 | 8.7526 | 5.826840024678379 |
1155 | 1155 | 2018-07-01 | THB | Thailand | 119.0 | 33.17 | 3.5875791377751 |
1156 | 1156 | 2018-07-01 | TRY | Turkey | 10.75 | 4.70625 | 2.28419654714475 |
1157 | 1157 | 2018-07-01 | TWD | Taiwan | 69.0 | 30.3725 | 2.27179191703021 |
1158 | 1158 | 2018-07-01 | UAH | Ukraine | 50.0 | 26.199 | 1.90846978892324 |
1159 | 1159 | 2018-07-01 | UYU | Uruguay | 140.0 | 31.31 | 4.47141488342383 |
1160 | 1160 | 2018-07-01 | USD | United States | 5.51 | 1.0 | 5.51 |
1161 | 1161 | 2018-07-01 | VND | Vietnam | 65000.0 | 23039.5 | 2.82124178042058 |
1162 | 1162 | 2018-07-01 | ZAR | South Africa | 31.0 | 13.3619 | 2.32002933714517 |
2437 | 2437 | 2018-07-01 | AED | United Arab Emirates | 14.0 | 3.67315 | 3.81144249486136 |
2438 | 2438 | 2018-07-01 | ARS | Argentina | 75.0 | 27.725 | 2.705139765554549 |
2439 | 2439 | 2018-07-01 | AUD | Australia | 6.05 | 1.33985395591881 | 4.51541749999998 |
2440 | 2440 | 2018-07-01 | AZN | Azerbaijan | 3.95 | 1.70175 | 2.32114000293815 |
2441 | 2441 | 2018-07-01 | BHD | Bahrain | 1.2 | 0.37955 | 3.161638782769069 |
2442 | 2442 | 2018-07-01 | BRL | Brazil | 16.9 | 3.83835 | 4.4029335521773705 |
2443 | 2443 | 2018-07-01 | CAD | Canada | 6.65 | 1.31235 | 5.067245780470151 |
2444 | 2444 | 2018-07-01 | CHF | Switzerland | 6.5 | 0.99325 | 6.54417316889001 |
2445 | 2445 | 2018-07-01 | CLP | Chile | 2640.0 | 651.73 | 4.05075721541129 |
2446 | 2446 | 2018-07-01 | CNY | China | 20.5 | 6.622000000000001 | 3.09574146783449 |
2447 | 2447 | 2018-07-01 | COP | Colombia | 11900.0 | 2874.07 | 4.14046978674841 |
2448 | 2448 | 2018-07-01 | CRC | Costa Rica | 2290.0 | 567.8 | 4.03311025008806 |
2449 | 2449 | 2018-07-01 | CZK | Czech Republic | 75.0 | 22.06475 | 3.39908677868546 |
2450 | 2450 | 2018-07-01 | DKK | Denmark | 30.0 | 6.3591 | 4.71764872387602 |
2451 | 2451 | 2018-07-01 | EGP | Egypt | 31.37 | 17.905 | 1.7520245741413 |
2452 | 2452 | 2018-07-01 | EUR | Euro area | 4.04 | 0.8532059212490941 | 4.735082 |
2453 | 2453 | 2018-07-01 | GBP | Britain | 3.19 | 0.7538635506973241 | 4.231535 |
2454 | 2454 | 2018-07-01 | GTQ | Guatemala | 25.0 | 7.4871 | 3.33907654499072 |
2455 | 2455 | 2018-07-01 | HKD | Hong Kong | 20.0 | 7.84825 | 2.54833880164368 |
2456 | 2456 | 2018-07-01 | HNL | Honduras | 85.0 | 23.9926 | 3.5427590173636903 |
2457 | 2457 | 2018-07-01 | HRK | Croatia | 21.0 | 6.31275 | 3.32660092669597 |
2458 | 2458 | 2018-07-01 | HUF | Hungary | 850.0 | 276.4302 | 3.07491728472504 |
2459 | 2459 | 2018-07-01 | IDR | Indonesia | 31500.0 | 14360.0 | 2.19359331476323 |
2460 | 2460 | 2018-07-01 | INR | India | 173.0 | 68.825 | 2.51362150381402 |
2461 | 2461 | 2018-07-01 | ILS | Israel | 17.0 | 3.6349 | 4.67688244518419 |
2462 | 2462 | 2018-07-01 | JOD | Jordan | 1.95 | 0.71005 | 2.74628547285402 |
2463 | 2463 | 2018-07-01 | JPY | Japan | 390.0 | 111.25 | 3.50561797752809 |
2464 | 2464 | 2018-07-01 | KRW | South Korea | 4500.0 | 1116.0 | 4.03225806451613 |
2465 | 2465 | 2018-07-01 | KWD | Kuwait | 1.05 | 0.3025 | 3.47107438016529 |
2466 | 2466 | 2018-07-01 | LBP | Lebanon | 6500.0 | 1511.0 | 4.3017868960953 |
2467 | 2467 | 2018-07-01 | LKR | Sri Lanka | 580.0 | 159.27 | 3.6416148678344897 |
2468 | 2468 | 2018-07-01 | MDL | Moldova | 43.0 | 16.6526 | 2.58217935937932 |
2469 | 2469 | 2018-07-01 | MXN | Mexico | 49.0 | 19.0515 | 2.57197595989817 |
2470 | 2470 | 2018-07-01 | MYR | Malaysia | 8.45 | 4.0225 | 2.10068365444375 |
2471 | 2471 | 2018-07-01 | NIO | Nicaragua | 103.0 | 31.5872 | 3.26081450714213 |
2472 | 2472 | 2018-07-01 | NOK | Norway | 42.0 | 8.0415 | 5.22290617422123 |
2473 | 2473 | 2018-07-01 | NZD | New Zealand | 6.2 | 1.46434324205594 | 4.23397999999999 |
2474 | 2474 | 2018-07-01 | OMR | Oman | 1.05 | 0.385 | 2.7272727272727297 |
2475 | 2475 | 2018-07-01 | PKR | Pakistan | 375.0 | 121.49 | 3.0866738003127794 |
2476 | 2476 | 2018-07-01 | PEN | Peru | 10.5 | 3.2715 | 3.20953690967446 |
2477 | 2477 | 2018-07-01 | PHP | Philippines | 140.0 | 53.487 | 2.6174584478471403 |
2478 | 2478 | 2018-07-01 | PLN | Poland | 10.1 | 3.68695 | 2.73939163807483 |
2479 | 2479 | 2018-07-01 | QAR | Qatar | 12.0 | 3.641 | 3.29579785773139 |
2480 | 2480 | 2018-07-01 | RON | Romania | 9.2 | 3.97325 | 2.3154848046309704 |
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 );