SEL — DGIWG Spatial Entity Listing standard
SEL+ — Platform extension (not in DGIWG core spec)
CCL — DGIWG Cross-Cultural Language standard
Extension — Preserved in extension tables (not in core SEL/CCL schema)
Pending — Awaiting mapping
MAC unhcr - hosted_populations
— 75 rows, 24 columns
Standards-Aligned Fields (24)
| Field Name | Type | Schema | Nulls | Unique |
year |
integer |
CCL
|
0% |
75 |
country_of_origin |
string |
CCL
|
100% |
- |
country_of_origin_iso |
string |
CCL
|
0% |
1 |
country_of_asylum |
string |
CCL
|
100% |
- |
country_of_asylum_iso |
string |
CCL
|
0% |
1 |
population_type |
string |
CCL
|
100% |
- |
refugees |
integer |
CCL
|
0% |
75 |
asylum_seekers |
integer |
CCL
|
0% |
34 |
idps |
integer |
CCL
|
0% |
34 |
stateless |
integer |
CCL
|
0% |
23 |
others_of_concern |
integer |
CCL
|
0% |
30 |
total_population |
string |
CCL
|
100% |
- |
female_total |
string |
CCL
|
100% |
- |
male_total |
string |
CCL
|
100% |
- |
female_0_4 |
string |
CCL
|
100% |
- |
female_5_11 |
string |
CCL
|
100% |
- |
female_12_17 |
string |
CCL
|
100% |
- |
female_18_59 |
string |
CCL
|
100% |
- |
female_60_plus |
string |
CCL
|
100% |
- |
male_0_4 |
string |
CCL
|
100% |
- |
male_5_11 |
string |
CCL
|
100% |
- |
male_12_17 |
string |
CCL
|
100% |
- |
male_18_59 |
string |
CCL
|
100% |
- |
male_60_plus |
string |
CCL
|
100% |
- |
MAC unhcr - origin_populations
— 75 rows, 24 columns
Standards-Aligned Fields (24)
| Field Name | Type | Schema | Nulls | Unique |
year |
integer |
CCL
|
0% |
75 |
country_of_origin |
string |
CCL
|
100% |
- |
country_of_origin_iso |
string |
CCL
|
0% |
1 |
country_of_asylum |
string |
CCL
|
100% |
- |
country_of_asylum_iso |
string |
CCL
|
0% |
1 |
population_type |
string |
CCL
|
100% |
- |
refugees |
integer |
CCL
|
0% |
75 |
asylum_seekers |
integer |
CCL
|
0% |
34 |
idps |
integer |
CCL
|
0% |
34 |
stateless |
integer |
CCL
|
0% |
23 |
others_of_concern |
integer |
CCL
|
0% |
30 |
total_population |
string |
CCL
|
100% |
- |
female_total |
string |
CCL
|
100% |
- |
male_total |
string |
CCL
|
100% |
- |
female_0_4 |
string |
CCL
|
100% |
- |
female_5_11 |
string |
CCL
|
100% |
- |
female_12_17 |
string |
CCL
|
100% |
- |
female_18_59 |
string |
CCL
|
100% |
- |
female_60_plus |
string |
CCL
|
100% |
- |
male_0_4 |
string |
CCL
|
100% |
- |
male_5_11 |
string |
CCL
|
100% |
- |
male_12_17 |
string |
CCL
|
100% |
- |
male_18_59 |
string |
CCL
|
100% |
- |
male_60_plus |
string |
CCL
|
100% |
- |
MAC joshua_project - languages
— 9 rows, 7 columns
Standards-Aligned Fields (7)
| Field Name | Type | Schema | Nulls | Unique |
language_code |
string |
CCL
|
0% |
9 |
language_name |
string |
SEL
|
0% |
9 |
iso639_3 |
string |
CCL
|
100% |
- |
country_code |
string |
SEL+
|
0% |
1 |
population |
string |
CCL
|
100% |
- |
primary_religion |
string |
CCL
|
0% |
4 |
people_groups_count |
string |
CCL
|
100% |
- |
MAC joshua_project - people_groups
— 29 rows, 25 columns
Standards-Aligned Fields (25)
| Field Name | Type | Schema | Nulls | Unique |
people_id |
integer |
CCL
|
0% |
29 |
rop3_code |
string |
CCL
|
0% |
1 |
people_name |
string |
SEL
|
0% |
29 |
people_name_global |
string |
CCL
|
0% |
29 |
country_code |
string |
SEL+
|
0% |
1 |
country_name |
string |
CCL
|
0% |
1 |
continent |
string |
CCL
|
0% |
1 |
region |
string |
CCL
|
0% |
1 |
population |
integer |
CCL
|
0% |
28 |
population_global |
string |
CCL
|
100% |
- |
primary_religion |
string |
CCL
|
0% |
4 |
religion_pct_christianity |
string |
CCL
|
100% |
- |
religion_pct_islam |
string |
CCL
|
100% |
- |
religion_pct_hinduism |
string |
CCL
|
100% |
- |
religion_pct_buddhism |
string |
CCL
|
100% |
- |
religion_pct_ethnic |
string |
CCL
|
100% |
- |
religion_pct_other |
string |
CCL
|
100% |
- |
primary_language |
string |
CCL
|
0% |
16 |
language_code |
string |
CCL
|
0% |
16 |
language_iso |
string |
CCL
|
0% |
1 |
people_cluster |
string |
CCL
|
0% |
12 |
affinity_bloc |
string |
CCL
|
0% |
4 |
ethnicity_family |
string |
CCL
|
100% |
- |
latitude |
float |
CCL
|
0% |
29 |
longitude |
float |
CCL
|
0% |
29 |
MAC world_bank - development_indicators
— 66 rows, 9 columns
Standards-Aligned Fields (9)
| Field Name | Type | Schema | Nulls | Unique |
country_code |
string |
SEL+
|
0% |
1 |
country_name |
string |
SEL
|
0% |
1 |
year |
integer |
SEL
|
0% |
66 |
population_count |
float |
SEL
|
1.5% |
65 |
life_expectancy |
float |
SEL
|
3% |
62 |
gdp_per_capita_usd |
string |
SEL
|
34.8% |
43 |
literacy_rate_pct |
string |
SEL
|
92.4% |
5 |
under5_mortality_per_1000 |
string |
SEL
|
100% |
- |
poverty_headcount_pct |
string |
SEL
|
100% |
- |
MAC world_bank - health_indicators
— 66 rows, 14 columns
Standards-Aligned Fields (14)
| Field Name | Type | Schema | Nulls | Unique |
country_code |
string |
SEL+
|
0% |
1 |
country_name |
string |
SEL
|
0% |
1 |
year |
integer |
SEL
|
0% |
66 |
life_expectancy |
float |
SEL
|
3% |
62 |
infant_mortality_per_1000 |
string |
SEL
|
100% |
- |
under5_mortality_per_1000 |
string |
SEL
|
100% |
- |
maternal_mortality_per_100k |
string |
SEL
|
100% |
- |
fertility_rate |
float |
SEL
|
3% |
62 |
birth_rate_per_1000 |
float |
SEL
|
3% |
58 |
death_rate_per_1000 |
float |
SEL
|
3% |
38 |
physicians_per_1000 |
float |
SEL
|
90.9% |
6 |
hospital_beds_per_1000 |
float |
SEL
|
97% |
2 |
vaccination_rate_pct |
string |
SEL
|
100% |
- |
health_expenditure_pct_gdp |
string |
SEL
|
100% |
- |
MAC gdl - subnational_indices
— 2788 rows, 11 columns
Standards-Aligned Fields (11)
| Field Name | Type | Schema | Nulls | Unique |
country_code |
string |
SEL+
|
0% |
1 |
region_code |
string |
SEL
|
100% |
- |
region_name |
string |
SEL
|
0% |
82 |
year |
integer |
SEL
|
0% |
2 |
level |
string |
SEL
|
0% |
2 |
human_development_index |
float |
SEL
|
0% |
85 |
health_index |
float |
SEL
|
0% |
69 |
education_index |
float |
SEL
|
0% |
85 |
income_index |
float |
SEL
|
0% |
90 |
life_expectancy |
float |
SEL
|
0% |
75 |
mean_years_schooling |
float |
SEL
|
0% |
98 |