**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",