Table 2.
The table reports the covariates, other than epidemiological variables, included in the database and their coverage as of November 27, 2021.
| Field | Description | N. of Administrative Areas | ||
|---|---|---|---|---|
| Level 1 | Level 2 | Level 3 | ||
| id | Unique identifier for the geographical entity | 236 | 763 | 12,124 |
| administrative_area_level | Level of the administrative area: 1 for countries; 2 for states, regions, cantons, or local equivalent; 3 for cities, municipalities, or local equivalent | 236 | 763 | 12,124 |
| administrative_area_level_1 | Name of the administrative area of level 1 | 236 | 763 | 12,124 |
| administrative_area_level_2 | Name of the administrative area of level 2 | 763 | 12,124 | |
| administrative_area_level_3 | Name of the administrative area of level 3 | 12,124 | ||
| latitude | Latitude | 229 | 763 | 12,124 |
| longitude | Longitude | 229 | 763 | 12,124 |
| population | Total population | 235 | 763 | 12,124 |
| iso_alpha_3 | 3-letter code of the country according to the standard ISO 3166-1 Alpha-3 | 233 | 763 | 12,124 |
| iso_alpha_2 | 2-letter code of the country according to the standard ISO 3166-1 Alpha-2 | 233 | 763 | 12,124 |
| iso_numeric | Numeric code of the country according to the standard ISO 3166-1 Numeric | 232 | 763 | 12,124 |
| iso_currency | 3-letter code of the currency used in the country according to the standard ISO 4217 | 233 | 763 | 12,124 |
| key_local | The administrative area identifier used by the local authorities, usually the national institute of statistics or local equivalent. E.g., FIPS codes for United States, IBGE codes for Brazil, ISTAT codes for Italy, etc. | 568 | 12,053 | |
| key_google_mobility | The place_id used in Google Mobility Reports. The identifier also allows to interact with the Google Places and Google Maps API | 135 | 539 | 6,825 |
| key_apple_mobility | The administrative area identifier identifier used in Apple Mobility Reports. This is constructed by concatenating region and, when not null, sub-region in Apple Mobility Reports: i.e., <region>, <sub-region> | 67 | 475 | 2,159 |
| key_jhu_csse | The administrative area identifier identifier used in the JHU CSSE Unified COVID-19 Dataset. In particular, this enables to match administrative areas with the Hydromet dataset | 192 | 508 | 10,708 |
| key_nuts | The 2021 NUTS codes for Europe, by Eurostat | 232 | 1,864 | |
| key_gadm | The identifier (GID) used in the GADM database version 3.6 | 233 | 760 | 11,977 |
The last three columns report the number of countries (level 1), sub-national regions (level 2), and lower-level administrative areas (level 3) for which the corresponding variable is available.