IDX_OperationalPresence
The database schema for this table is:
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| location_code | varchar(255) | YES | NULL | ||
| location_name | varchar(255) | YES | NULL | ||
| admin1_code | varchar(255) | YES | NULL | ||
| admin1_name | varchar(255) | YES | NULL | ||
| admin2_code | varchar(255) | YES | NULL | ||
| admin2_name | varchar(255) | YES | NULL | ||
| admin_level | int | YES | NULL | ||
| resource_hdx_id | varchar(255) | YES | NULL | ||
| org_acronym | varchar(255) | YES | NULL | ||
| org_name | varchar(255) | YES | NULL | ||
| sector_code | varchar(255) | YES | NULL | ||
| sector_name | varchar(255) | YES | NULL | ||
| reference_period_start | datetime | YES | NULL | ||
| reference_period_end | datetime | YES | NULL | ||
| org_type_code | varchar(255) | YES | NULL | ||
| org_type_description | varchar(255) | YES | NULL |
An example object of this dataset is:
"location_code": "MOZ", "location_name": "Mozambique", "admin1_code": "MZ01", "admin1_name": "Cabo Delgado", "admin2_code": "MZ0101", "admin2_name": "Ancuabe", "admin_level": "2", "resource_hdx_id": "f52d2606-0f26-4fd3-8226-7c85ee83e0e0", "org_acronym": "AeA", "org_name": "AeA", "sector_code": "SHL", "sector_name": "Emergency Shelter and NFI", "reference_period_start": "2024-12-01 00:00:00", "reference_period_end": "2025-06-30 23:59:59", "org_type_code": "437", "org_type_description": "International NGO",