hdx_povertyrates
HDX Poverty Rates
This is the database schema for the poverty rates table:
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| location_code | varchar(10) | YES | NULL | ||
| location_name | varchar(100) | YES | NULL | ||
| mpi | decimal(6,4) | YES | NULL | ||
| headcount_ratio | decimal(7,4) | YES | NULL | ||
| intensity_of_deprivation | decimal(7,4) | YES | NULL | ||
| vulnerable_to_poverty | decimal(6,4) | YES | NULL | ||
| in_severe_poverty | decimal(6,4) | YES | NULL | ||
| reference_period_start | datetime | YES | NULL | ||
| reference_period_end | datetime | YES | NULL |
An example JSON object from the table:
{
"location_code": "MOZ",
"location_name": "Mozambique",
"admin1_code": null,
"admin1_name": null,
"admin_level": 0,
"resource_hdx_id": "7c131db3-a172-4280-b37a-85f678192fbe",
"mpi": 0.3302,
"headcount_ratio": 59.8541,
"intensity_of_deprivation": 55.1671,
"vulnerable_to_poverty": 17.0609,
"in_severe_poverty": 38.3217,
"reference_period_start": "2022-01-01T00:00:00",
"reference_period_end": "2023-12-31T23:59:59"
}
hdx_povertyrates.txt · Last modified: by alex.nevin