bigmac
560 rows where "date" is on date 2019-07-09
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
1219 | 1219 | 2019-07-09 | AED | United Arab Emirates | 14.75 | 3.67315 | 4.01562691422893 |
1220 | 1220 | 2019-07-09 | ARS | Argentina | 120.0 | 41.8045 | 2.87050437153895 |
1221 | 1221 | 2019-07-09 | AUD | Australia | 6.15 | 1.4436263894904 | 4.260105 |
1222 | 1222 | 2019-07-09 | AZN | Azerbaijan | 3.95 | 1.6965 | 2.3283230179781897 |
1223 | 1223 | 2019-07-09 | BHD | Bahrain | 1.4 | 0.377 | 3.7135278514588896 |
1224 | 1224 | 2019-07-09 | BRL | Brazil | 17.5 | 3.8073 | 4.59643316786174 |
1225 | 1225 | 2019-07-09 | CAD | Canada | 6.77 | 1.31305 | 5.1559346559537 |
1226 | 1226 | 2019-07-09 | CHF | Switzerland | 6.5 | 0.99355 | 6.54219717175784 |
1227 | 1227 | 2019-07-09 | CLP | Chile | 2640.0 | 689.75 | 3.82747372236318 |
1228 | 1228 | 2019-07-09 | CNY | China | 21.0 | 6.8846 | 3.0502861458908304 |
1229 | 1229 | 2019-07-09 | COP | Colombia | 11900.0 | 3227.0 | 3.6876355748373104 |
1230 | 1230 | 2019-07-09 | CRC | Costa Rica | 2290.0 | 581.935 | 3.93514739618686 |
1231 | 1231 | 2019-07-09 | CZK | Czech Republic | 85.0 | 22.7993 | 3.72818463724764 |
1232 | 1232 | 2019-07-09 | DKK | Denmark | 30.0 | 6.6593 | 4.50497800069076 |
1233 | 1233 | 2019-07-09 | EGP | Egypt | 42.0 | 16.615 | 2.52783629250677 |
1234 | 1234 | 2019-07-09 | EUR | Euro area | 4.08 | 0.892339267389462 | 4.572252 |
1235 | 1235 | 2019-07-09 | GBP | Britain | 3.29 | 0.8021819348628271 | 4.101314 |
1236 | 1236 | 2019-07-09 | GTQ | Guatemala | 25.0 | 7.6802 | 3.2551235644905097 |
1237 | 1237 | 2019-07-09 | HKD | Hong Kong | 20.5 | 7.8105 | 2.6246719160105 |
1238 | 1238 | 2019-07-09 | HNL | Honduras | 86.0 | 24.4834 | 3.5125840365308703 |
1239 | 1239 | 2019-07-09 | HRK | Croatia | 22.0 | 6.5981 | 3.3342932056198 |
1240 | 1240 | 2019-07-09 | HUF | Hungary | 900.0 | 290.5412 | 3.0976673876200698 |
1241 | 1241 | 2019-07-09 | IDR | Indonesia | 32000.0 | 14130.0 | 2.26468506723284 |
1242 | 1242 | 2019-07-09 | INR | India | 183.0 | 68.5544 | 2.66941290420454 |
1243 | 1243 | 2019-07-09 | ILS | Israel | 17.0 | 3.5667 | 4.76631059522808 |
1244 | 1244 | 2019-07-09 | JOD | Jordan | 2.3 | 0.7090000000000001 | 3.24400564174894 |
1245 | 1245 | 2019-07-09 | JPY | Japan | 390.0 | 108.765 | 3.58571231554268 |
1246 | 1246 | 2019-07-09 | KRW | South Korea | 4500.0 | 1180.55 | 3.81178264368303 |
1247 | 1247 | 2019-07-09 | KWD | Kuwait | 1.1 | 0.3045 | 3.61247947454844 |
1248 | 1248 | 2019-07-09 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
1249 | 1249 | 2019-07-09 | LKR | Sri Lanka | 640.0 | 175.675 | 3.64309093496513 |
1250 | 1250 | 2019-07-09 | MDL | Moldova | 43.0 | 17.8142 | 2.41380471758485 |
1251 | 1251 | 2019-07-09 | MXN | Mexico | 50.0 | 18.89525 | 2.6461676876463702 |
1252 | 1252 | 2019-07-09 | MYR | Malaysia | 8.85 | 4.1425 | 2.1363910681955303 |
1253 | 1253 | 2019-07-09 | NIO | Nicaragua | 110.0 | 33.1621 | 3.3170396325926297 |
1254 | 1254 | 2019-07-09 | NOK | Norway | 42.0 | 8.65275 | 4.853948166767791 |
1255 | 1255 | 2019-07-09 | NZD | New Zealand | 6.4 | 1.5134317063942502 | 4.2288 |
1256 | 1256 | 2019-07-09 | OMR | Oman | 1.21 | 0.385 | 3.14285714285714 |
1257 | 1257 | 2019-07-09 | PKR | Pakistan | 480.0 | 157.45 | 3.0485868529692 |
1258 | 1258 | 2019-07-09 | PEN | Peru | 10.5 | 3.2868 | 3.19459656809054 |
1259 | 1259 | 2019-07-09 | PHP | Philippines | 142.0 | 51.3175 | 2.76708725093779 |
1260 | 1260 | 2019-07-09 | PLN | Poland | 10.8 | 3.80775 | 2.83632066180815 |
1261 | 1261 | 2019-07-09 | QAR | Qatar | 13.0 | 3.64175 | 3.5697123635614707 |
1262 | 1262 | 2019-07-09 | RON | Romania | 9.3 | 4.2192 | 2.20420932878271 |
1263 | 1263 | 2019-07-09 | RUB | Russia | 130.0 | 63.83875 | 2.03638072487322 |
1264 | 1264 | 2019-07-09 | SAR | Saudi Arabia | 13.0 | 3.75035 | 3.46634314130681 |
1265 | 1265 | 2019-07-09 | SGD | Singapore | 5.8 | 1.3613 | 4.26063321824726 |
1266 | 1266 | 2019-07-09 | SEK | Sweden | 51.0 | 9.47505 | 5.38255734798233 |
1267 | 1267 | 2019-07-09 | THB | Thailand | 119.0 | 30.8275 | 3.86018976563134 |
1268 | 1268 | 2019-07-09 | TRY | Turkey | 13.99 | 5.722 | 2.44494931842013 |
1269 | 1269 | 2019-07-09 | TWD | Taiwan | 72.0 | 31.172 | 2.3097651738739904 |
1270 | 1270 | 2019-07-09 | UAH | Ukraine | 57.0 | 25.6475 | 2.2224388341943704 |
1271 | 1271 | 2019-07-09 | UYU | Uruguay | 164.0 | 35.1695 | 4.66313140647436 |
1272 | 1272 | 2019-07-09 | USD | United States | 5.74 | 1.0 | 5.74 |
1273 | 1273 | 2019-07-09 | VND | Vietnam | 65000.0 | 23231.0 | 2.79798545047566 |
1274 | 1274 | 2019-07-09 | ZAR | South Africa | 31.0 | 14.175 | 2.18694885361552 |
2549 | 2549 | 2019-07-09 | AED | United Arab Emirates | 14.75 | 3.67315 | 4.01562691422893 |
2550 | 2550 | 2019-07-09 | ARS | Argentina | 120.0 | 41.8045 | 2.87050437153895 |
2551 | 2551 | 2019-07-09 | AUD | Australia | 6.15 | 1.4436263894904 | 4.260105 |
2552 | 2552 | 2019-07-09 | AZN | Azerbaijan | 3.95 | 1.6965 | 2.3283230179781897 |
2553 | 2553 | 2019-07-09 | BHD | Bahrain | 1.4 | 0.377 | 3.7135278514588896 |
2554 | 2554 | 2019-07-09 | BRL | Brazil | 17.5 | 3.8073 | 4.59643316786174 |
2555 | 2555 | 2019-07-09 | CAD | Canada | 6.77 | 1.31305 | 5.1559346559537 |
2556 | 2556 | 2019-07-09 | CHF | Switzerland | 6.5 | 0.99355 | 6.54219717175784 |
2557 | 2557 | 2019-07-09 | CLP | Chile | 2640.0 | 689.75 | 3.82747372236318 |
2558 | 2558 | 2019-07-09 | CNY | China | 21.0 | 6.8846 | 3.0502861458908304 |
2559 | 2559 | 2019-07-09 | COP | Colombia | 11900.0 | 3227.0 | 3.6876355748373104 |
2560 | 2560 | 2019-07-09 | CRC | Costa Rica | 2290.0 | 581.935 | 3.93514739618686 |
2561 | 2561 | 2019-07-09 | CZK | Czech Republic | 85.0 | 22.7993 | 3.72818463724764 |
2562 | 2562 | 2019-07-09 | DKK | Denmark | 30.0 | 6.6593 | 4.50497800069076 |
2563 | 2563 | 2019-07-09 | EGP | Egypt | 42.0 | 16.615 | 2.52783629250677 |
2564 | 2564 | 2019-07-09 | EUR | Euro area | 4.08 | 0.892339267389462 | 4.572252 |
2565 | 2565 | 2019-07-09 | GBP | Britain | 3.29 | 0.8021819348628271 | 4.101314 |
2566 | 2566 | 2019-07-09 | GTQ | Guatemala | 25.0 | 7.6802 | 3.2551235644905097 |
2567 | 2567 | 2019-07-09 | HKD | Hong Kong | 20.5 | 7.8105 | 2.6246719160105 |
2568 | 2568 | 2019-07-09 | HNL | Honduras | 86.0 | 24.4834 | 3.5125840365308703 |
2569 | 2569 | 2019-07-09 | HRK | Croatia | 22.0 | 6.5981 | 3.3342932056198 |
2570 | 2570 | 2019-07-09 | HUF | Hungary | 900.0 | 290.5412 | 3.0976673876200698 |
2571 | 2571 | 2019-07-09 | IDR | Indonesia | 32000.0 | 14130.0 | 2.26468506723284 |
2572 | 2572 | 2019-07-09 | INR | India | 183.0 | 68.5544 | 2.66941290420454 |
2573 | 2573 | 2019-07-09 | ILS | Israel | 17.0 | 3.5667 | 4.76631059522808 |
2574 | 2574 | 2019-07-09 | JOD | Jordan | 2.3 | 0.7090000000000001 | 3.24400564174894 |
2575 | 2575 | 2019-07-09 | JPY | Japan | 390.0 | 108.765 | 3.58571231554268 |
2576 | 2576 | 2019-07-09 | KRW | South Korea | 4500.0 | 1180.55 | 3.81178264368303 |
2577 | 2577 | 2019-07-09 | KWD | Kuwait | 1.1 | 0.3045 | 3.61247947454844 |
2578 | 2578 | 2019-07-09 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
2579 | 2579 | 2019-07-09 | LKR | Sri Lanka | 640.0 | 175.675 | 3.64309093496513 |
2580 | 2580 | 2019-07-09 | MDL | Moldova | 43.0 | 17.8142 | 2.41380471758485 |
2581 | 2581 | 2019-07-09 | MXN | Mexico | 50.0 | 18.89525 | 2.6461676876463702 |
2582 | 2582 | 2019-07-09 | MYR | Malaysia | 8.85 | 4.1425 | 2.1363910681955303 |
2583 | 2583 | 2019-07-09 | NIO | Nicaragua | 110.0 | 33.1621 | 3.3170396325926297 |
2584 | 2584 | 2019-07-09 | NOK | Norway | 42.0 | 8.65275 | 4.853948166767791 |
2585 | 2585 | 2019-07-09 | NZD | New Zealand | 6.4 | 1.5134317063942502 | 4.2288 |
2586 | 2586 | 2019-07-09 | OMR | Oman | 1.21 | 0.385 | 3.14285714285714 |
2587 | 2587 | 2019-07-09 | PKR | Pakistan | 480.0 | 157.45 | 3.0485868529692 |
2588 | 2588 | 2019-07-09 | PEN | Peru | 10.5 | 3.2868 | 3.19459656809054 |
2589 | 2589 | 2019-07-09 | PHP | Philippines | 142.0 | 51.3175 | 2.76708725093779 |
2590 | 2590 | 2019-07-09 | PLN | Poland | 10.8 | 3.80775 | 2.83632066180815 |
2591 | 2591 | 2019-07-09 | QAR | Qatar | 13.0 | 3.64175 | 3.5697123635614707 |
2592 | 2592 | 2019-07-09 | RON | Romania | 9.3 | 4.2192 | 2.20420932878271 |
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 );