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
HKG 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% |
- |
HKG 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% |
- |
HKG joshua_project - languages
— 1 rows, 7 columns
Standards-Aligned Fields (7)
| Field Name | Type | Schema | Nulls | Unique |
language_code |
string |
CCL
|
0% |
1 |
language_name |
string |
SEL
|
0% |
1 |
iso639_3 |
string |
CCL
|
100% |
- |
country_code |
string |
SEL+
|
0% |
1 |
population |
string |
CCL
|
100% |
- |
primary_religion |
string |
CCL
|
0% |
1 |
people_groups_count |
string |
CCL
|
100% |
- |
HKG joshua_project - people_groups
— 19 rows, 25 columns
Standards-Aligned Fields (25)
| Field Name | Type | Schema | Nulls | Unique |
people_id |
integer |
CCL
|
0% |
19 |
rop3_code |
string |
CCL
|
0% |
1 |
people_name |
string |
SEL
|
0% |
19 |
people_name_global |
string |
CCL
|
0% |
19 |
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% |
19 |
population_global |
string |
CCL
|
100% |
- |
primary_religion |
string |
CCL
|
0% |
6 |
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% |
17 |
language_code |
string |
CCL
|
0% |
17 |
language_iso |
string |
CCL
|
0% |
1 |
people_cluster |
string |
CCL
|
0% |
13 |
affinity_bloc |
string |
CCL
|
0% |
6 |
ethnicity_family |
string |
CCL
|
100% |
- |
latitude |
float |
CCL
|
0% |
19 |
longitude |
float |
CCL
|
0% |
19 |
HKG 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% |
64 |
gdp_per_capita_usd |
float |
SEL
|
1.5% |
65 |
literacy_rate_pct |
string |
SEL
|
100% |
- |
under5_mortality_per_1000 |
string |
SEL
|
100% |
- |
poverty_headcount_pct |
string |
SEL
|
100% |
- |
HKG 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% |
64 |
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% |
61 |
birth_rate_per_1000 |
float |
SEL
|
3% |
55 |
death_rate_per_1000 |
float |
SEL
|
3% |
23 |
physicians_per_1000 |
float |
SEL
|
86.4% |
9 |
hospital_beds_per_1000 |
float |
SEL
|
90.9% |
6 |
vaccination_rate_pct |
string |
SEL
|
100% |
- |
health_expenditure_pct_gdp |
string |
SEL
|
100% |
- |
HKG wvs - country_aggregates
— 1 rows, 26 columns
Standards-Aligned Fields (26)
| Field Name | Type | Schema | Nulls | Unique |
country_code |
string |
CCL
|
0% |
1 |
wave |
integer |
CCL
|
0% |
1 |
wave_years |
string |
CCL
|
0% |
1 |
source |
string |
CCL
|
0% |
1 |
importance_religion |
integer |
CCL
|
0% |
1 |
importance_family |
integer |
CCL
|
0% |
1 |
importance_friends |
integer |
CCL
|
0% |
1 |
trust_people |
integer |
CCL
|
0% |
1 |
trust_family |
integer |
CCL
|
0% |
1 |
life_satisfaction |
integer |
CCL
|
0% |
1 |
happiness |
integer |
CCL
|
0% |
1 |
freedom_choice |
integer |
CCL
|
0% |
1 |
gender_jobs_scarce |
integer |
CCL
|
0% |
1 |
gender_political_leaders |
integer |
CCL
|
0% |
1 |
gender_university |
integer |
CCL
|
0% |
1 |
justifiable_divorce |
integer |
CCL
|
0% |
1 |
justifiable_homosexuality |
integer |
CCL
|
0% |
1 |
immigration_policy |
integer |
CCL
|
0% |
1 |
immigrants_jobs |
integer |
CCL
|
0% |
1 |
immigrants_culture |
integer |
CCL
|
0% |
1 |
confidence_government |
integer |
CCL
|
0% |
1 |
confidence_parliament |
integer |
CCL
|
0% |
1 |
confidence_police |
integer |
CCL
|
0% |
1 |
confidence_courts |
integer |
CCL
|
0% |
1 |
confidence_press |
integer |
CCL
|
0% |
1 |
democracy_importance |
integer |
CCL
|
0% |
1 |