| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
Number / SEX AND AGE / Total population |
Number / SEX AND AGE / Total population | integer | SEL | 0% | - | 153836 |
Number / MEDIAN AGE BY SEX / Both sexes |
Number / MEDIAN AGE BY SEX / Both sexes | integer | SEL | 0% | - | 33.7 |
Number / RACE / Total population / One Race / Native Hawaiian and Other Pacific Islander |
Number / RACE / Total population / One Race / Native Hawaiian and Other Pacific Islander | integer | CCL | 0% | - | 70809 |
Number / RACE / Total population / One Race / Asian |
Number / RACE / Total population / One Race / Asian | integer | CCL | 0% | - | 54586 |
Number / RACE / Total population / One Race / White |
Number / RACE / Total population / One Race / White | integer | CCL | 0% | - | 10491 |
Number / RACE / Total population / One Race / Black or African American |
Number / RACE / Total population / One Race / Black or African American | integer | CCL | 0% | - | 1340 |
Number / RACE / Total population / One Race / American Indian and Alaska Native |
Number / RACE / Total population / One Race / American Indian and Alaska Native | integer | CCL | 0% | - | 214 |
Number / RACE / Total population / One Race / Some Other Race |
Number / RACE / Total population / One Race / Some Other Race | integer | CCL | 0% | - | 955 |
Number / RACE / Total population / Two or More Races |
Number / RACE / Total population / Two or More Races | integer | CCL | 0% | - | 15441 |
Number / HISPANIC OR LATINO ORIGIN / Total population / Hispanic or Latino (of any race) |
Number / HISPANIC OR LATINO ORIGIN / Total population / Hispanic or Latino (of any race) | integer | CCL | 0% | - | 4522 |
Number / HISPANIC OR LATINO ORIGIN / Total population / Not Hispanic or Latino |
Number / HISPANIC OR LATINO ORIGIN / Total population / Not Hispanic or Latino | integer | CCL | 0% | - | 149314 |
Number / HOUSEHOLDS BY TYPE / Total households |
Number / HOUSEHOLDS BY TYPE / Total households | integer | SEL | 0% | - | 43381 |
name |
name | string | SEL | 0% | - | Guam |
state |
state | string | SEL | 0% | - | 66 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
Number / SEX AND AGE / Total population / Under 5 years |
Number / SEX AND AGE / Total population / Under 5 years | integer | 0% | - | 10626 |
Number / SEX AND AGE / Total population / 5 to 9 years |
Number / SEX AND AGE / Total population / 5 to 9 years | integer | 0% | - | 11439 |
Number / SEX AND AGE / Total population / 10 to 14 years |
Number / SEX AND AGE / Total population / 10 to 14 years | integer | 0% | - | 12232 |
Number / SEX AND AGE / Total population / 15 to 19 years |
Number / SEX AND AGE / Total population / 15 to 19 years | integer | 0% | - | 11782 |
Number / SEX AND AGE / Total population / 20 to 24 years |
Number / SEX AND AGE / Total population / 20 to 24 years | integer | 0% | - | 11889 |
Number / SEX AND AGE / Total population / 25 to 29 years |
Number / SEX AND AGE / Total population / 25 to 29 years | integer | 0% | - | 11463 |
Number / SEX AND AGE / Total population / 30 to 34 years |
Number / SEX AND AGE / Total population / 30 to 34 years | integer | 0% | - | 10028 |
Number / SEX AND AGE / Total population / 35 to 39 years |
Number / SEX AND AGE / Total population / 35 to 39 years | integer | 0% | - | 9456 |
Number / SEX AND AGE / Total population / 40 to 44 years |
Number / SEX AND AGE / Total population / 40 to 44 years | integer | 0% | - | 9200 |
Number / SEX AND AGE / Total population / 45 to 49 years |
Number / SEX AND AGE / Total population / 45 to 49 years | integer | 0% | - | 10145 |
Number / SEX AND AGE / Total population / 50 to 54 years |
Number / SEX AND AGE / Total population / 50 to 54 years | integer | 0% | - | 10237 |
Number / SEX AND AGE / Total population / 55 to 59 years |
Number / SEX AND AGE / Total population / 55 to 59 years | integer | 0% | - | 9865 |
Number / SEX AND AGE / Total population / 60 to 64 years |
Number / SEX AND AGE / Total population / 60 to 64 years | integer | 0% | - | 8284 |
Number / SEX AND AGE / Total population / 65 to 69 years |
Number / SEX AND AGE / Total population / 65 to 69 years | integer | 0% | - | 6686 |
Number / SEX AND AGE / Total population / 70 to 74 years |
Number / SEX AND AGE / Total population / 70 to 74 years | integer | 0% | - | 4885 |
Number / SEX AND AGE / Total population / 75 to 79 years |
Number / SEX AND AGE / Total population / 75 to 79 years | integer | 0% | - | 2637 |
Number / SEX AND AGE / Total population / 80 to 84 years |
Number / SEX AND AGE / Total population / 80 to 84 years | integer | 0% | - | 1765 |
Number / SEX AND AGE / Total population / 85 years and over |
Number / SEX AND AGE / Total population / 85 years and over | integer | 0% | - | 1217 |
Number / SEX AND AGE / Total population / Selected Age Categories / 16 years and over |
Number / SEX AND AGE / Total population / Selected Age Categories / 16 years and over | integer | 0% | - | 117126 |
Number / SEX AND AGE / Total population / Selected Age Categories / 18 years and over |
Number / SEX AND AGE / Total population / Selected Age Categories / 18 years and over | integer | 0% | - | 112349 |
Number / SEX AND AGE / Total population / Selected Age Categories / 21 years and over |
Number / SEX AND AGE / Total population / Selected Age Categories / 21 years and over | integer | 0% | - | 105364 |
Number / SEX AND AGE / Total population / Selected Age Categories / 62 years and over |
Number / SEX AND AGE / Total population / Selected Age Categories / 62 years and over | integer | 0% | - | 21945 |
Number / SEX AND AGE / Total population / Selected Age Categories / 65 years and over |
Number / SEX AND AGE / Total population / Selected Age Categories / 65 years and over | integer | 0% | - | 17190 |
Number / SEX AND AGE / Male population |
Number / SEX AND AGE / Male population | integer | 0% | - | 78271 |
Number / SEX AND AGE / Male population / Under 5 years |
Number / SEX AND AGE / Male population / Under 5 years | integer | 0% | - | 5575 |
Number / SEX AND AGE / Male population / 5 to 9 years |
Number / SEX AND AGE / Male population / 5 to 9 years | integer | 0% | - | 5897 |
Number / SEX AND AGE / Male population / 10 to 14 years |
Number / SEX AND AGE / Male population / 10 to 14 years | integer | 0% | - | 6249 |
Number / SEX AND AGE / Male population / 15 to 19 years |
Number / SEX AND AGE / Male population / 15 to 19 years | integer | 0% | - | 6092 |
Number / SEX AND AGE / Male population / 20 to 24 years |
Number / SEX AND AGE / Male population / 20 to 24 years | integer | 0% | - | 6324 |
Number / SEX AND AGE / Male population / 25 to 29 years |
Number / SEX AND AGE / Male population / 25 to 29 years | integer | 0% | - | 6052 |
| +116 more extension fields — download the CSV/Parquet to see them all. | |||||
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
Number / SEX AND AGE / Total population |
Number / SEX AND AGE / Total population | integer | SEL | 0% | - | 153836 |
Number / MEDIAN AGE BY SEX / Both sexes |
Number / MEDIAN AGE BY SEX / Both sexes | integer | SEL | 0% | - | 33.7 |
Number / RACE / Total population / One Race / Native Hawaiian and Other Pacific Islander |
Number / RACE / Total population / One Race / Native Hawaiian and Other Pacific Islander | integer | CCL | 0% | - | 70809 |
Number / RACE / Total population / One Race / Asian |
Number / RACE / Total population / One Race / Asian | integer | CCL | 0% | - | 54586 |
Number / RACE / Total population / One Race / White |
Number / RACE / Total population / One Race / White | integer | CCL | 0% | - | 10491 |
Number / RACE / Total population / One Race / Black or African American |
Number / RACE / Total population / One Race / Black or African American | integer | CCL | 0% | - | 1340 |
Number / RACE / Total population / One Race / American Indian and Alaska Native |
Number / RACE / Total population / One Race / American Indian and Alaska Native | integer | CCL | 0% | - | 214 |
Number / RACE / Total population / One Race / Some Other Race |
Number / RACE / Total population / One Race / Some Other Race | integer | CCL | 0% | - | 955 |
Number / RACE / Total population / Two or More Races |
Number / RACE / Total population / Two or More Races | integer | CCL | 0% | - | 15441 |
Number / HISPANIC OR LATINO ORIGIN / Total population / Hispanic or Latino (of any race) |
Number / HISPANIC OR LATINO ORIGIN / Total population / Hispanic or Latino (of any race) | integer | CCL | 0% | - | 4522 |
Number / HISPANIC OR LATINO ORIGIN / Total population / Not Hispanic or Latino |
Number / HISPANIC OR LATINO ORIGIN / Total population / Not Hispanic or Latino | integer | CCL | 0% | - | 149314 |
Number / HOUSEHOLDS BY TYPE / Total households |
Number / HOUSEHOLDS BY TYPE / Total households | integer | SEL | 0% | - | 43381 |
name |
name | string | SEL | 0% | - | Guam, Guam |
county |
county | string | SEL | 0% | - | 010 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
Number / SEX AND AGE / Total population / Under 5 years |
Number / SEX AND AGE / Total population / Under 5 years | integer | 0% | - | 10626 |
Number / SEX AND AGE / Total population / 5 to 9 years |
Number / SEX AND AGE / Total population / 5 to 9 years | integer | 0% | - | 11439 |
Number / SEX AND AGE / Total population / 10 to 14 years |
Number / SEX AND AGE / Total population / 10 to 14 years | integer | 0% | - | 12232 |
Number / SEX AND AGE / Total population / 15 to 19 years |
Number / SEX AND AGE / Total population / 15 to 19 years | integer | 0% | - | 11782 |
Number / SEX AND AGE / Total population / 20 to 24 years |
Number / SEX AND AGE / Total population / 20 to 24 years | integer | 0% | - | 11889 |
Number / SEX AND AGE / Total population / 25 to 29 years |
Number / SEX AND AGE / Total population / 25 to 29 years | integer | 0% | - | 11463 |
Number / SEX AND AGE / Total population / 30 to 34 years |
Number / SEX AND AGE / Total population / 30 to 34 years | integer | 0% | - | 10028 |
Number / SEX AND AGE / Total population / 35 to 39 years |
Number / SEX AND AGE / Total population / 35 to 39 years | integer | 0% | - | 9456 |
Number / SEX AND AGE / Total population / 40 to 44 years |
Number / SEX AND AGE / Total population / 40 to 44 years | integer | 0% | - | 9200 |
Number / SEX AND AGE / Total population / 45 to 49 years |
Number / SEX AND AGE / Total population / 45 to 49 years | integer | 0% | - | 10145 |
Number / SEX AND AGE / Total population / 50 to 54 years |
Number / SEX AND AGE / Total population / 50 to 54 years | integer | 0% | - | 10237 |
Number / SEX AND AGE / Total population / 55 to 59 years |
Number / SEX AND AGE / Total population / 55 to 59 years | integer | 0% | - | 9865 |
Number / SEX AND AGE / Total population / 60 to 64 years |
Number / SEX AND AGE / Total population / 60 to 64 years | integer | 0% | - | 8284 |
Number / SEX AND AGE / Total population / 65 to 69 years |
Number / SEX AND AGE / Total population / 65 to 69 years | integer | 0% | - | 6686 |
Number / SEX AND AGE / Total population / 70 to 74 years |
Number / SEX AND AGE / Total population / 70 to 74 years | integer | 0% | - | 4885 |
Number / SEX AND AGE / Total population / 75 to 79 years |
Number / SEX AND AGE / Total population / 75 to 79 years | integer | 0% | - | 2637 |
Number / SEX AND AGE / Total population / 80 to 84 years |
Number / SEX AND AGE / Total population / 80 to 84 years | integer | 0% | - | 1765 |
Number / SEX AND AGE / Total population / 85 years and over |
Number / SEX AND AGE / Total population / 85 years and over | integer | 0% | - | 1217 |
Number / SEX AND AGE / Total population / Selected Age Categories / 16 years and over |
Number / SEX AND AGE / Total population / Selected Age Categories / 16 years and over | integer | 0% | - | 117126 |
Number / SEX AND AGE / Total population / Selected Age Categories / 18 years and over |
Number / SEX AND AGE / Total population / Selected Age Categories / 18 years and over | integer | 0% | - | 112349 |
Number / SEX AND AGE / Total population / Selected Age Categories / 21 years and over |
Number / SEX AND AGE / Total population / Selected Age Categories / 21 years and over | integer | 0% | - | 105364 |
Number / SEX AND AGE / Total population / Selected Age Categories / 62 years and over |
Number / SEX AND AGE / Total population / Selected Age Categories / 62 years and over | integer | 0% | - | 21945 |
Number / SEX AND AGE / Total population / Selected Age Categories / 65 years and over |
Number / SEX AND AGE / Total population / Selected Age Categories / 65 years and over | integer | 0% | - | 17190 |
Number / SEX AND AGE / Male population |
Number / SEX AND AGE / Male population | integer | 0% | - | 78271 |
Number / SEX AND AGE / Male population / Under 5 years |
Number / SEX AND AGE / Male population / Under 5 years | integer | 0% | - | 5575 |
Number / SEX AND AGE / Male population / 5 to 9 years |
Number / SEX AND AGE / Male population / 5 to 9 years | integer | 0% | - | 5897 |
Number / SEX AND AGE / Male population / 10 to 14 years |
Number / SEX AND AGE / Male population / 10 to 14 years | integer | 0% | - | 6249 |
Number / SEX AND AGE / Male population / 15 to 19 years |
Number / SEX AND AGE / Male population / 15 to 19 years | integer | 0% | - | 6092 |
Number / SEX AND AGE / Male population / 20 to 24 years |
Number / SEX AND AGE / Male population / 20 to 24 years | integer | 0% | - | 6324 |
Number / SEX AND AGE / Male population / 25 to 29 years |
Number / SEX AND AGE / Male population / 25 to 29 years | integer | 0% | - | 6052 |
| +117 more extension fields — download the CSV/Parquet to see them all. | |||||
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_of_origin_iso |
Country of origin iso | string | CCL | 0% | 1 | -, -, -, -, - |
refugees |
Refugees | integer | CCL | 0% | 75 | 2116011, 1952928, 1847304, 1749628, 1717966 |
idps |
Idps | integer | CCL | 0% | 34 | 0, 0, 0, 0, 0 |
stateless |
Stateless | integer | CCL | 0% | 23 | 0, 0, 0, 0, 0 |
others_of_concern |
Others of concern | integer | CCL | 0% | 30 | 0, 0, 0, 0, 0 |
total_population |
Total population | string | CCL | 100% | - | - |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
year |
year | integer | 0% | 75 | 1951, 1952, 1953, 1954, 1955 |
country_of_origin |
country_of_origin | string | 100% | - | - |
country_of_asylum |
country_of_asylum | string | 100% | - | - |
country_of_asylum_iso |
country_of_asylum_iso | string | 0% | 1 | -, -, -, -, - |
population_type |
population_type | string | 100% | - | - |
asylum_seekers |
asylum_seekers | integer | 0% | 34 | 0, 0, 0, 0, 0 |
female_total |
female_total | string | 100% | - | - |
male_total |
male_total | string | 100% | - | - |
female_0_4 |
female_0_4 | string | 100% | - | - |
female_5_11 |
female_5_11 | string | 100% | - | - |
female_12_17 |
female_12_17 | string | 100% | - | - |
female_18_59 |
female_18_59 | string | 100% | - | - |
female_60_plus |
female_60_plus | string | 100% | - | - |
male_0_4 |
male_0_4 | string | 100% | - | - |
male_5_11 |
male_5_11 | string | 100% | - | - |
male_12_17 |
male_12_17 | string | 100% | - | - |
male_18_59 |
male_18_59 | string | 100% | - | - |
male_60_plus |
male_60_plus | string | 100% | - | - |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_of_origin_iso |
Country of origin iso | string | CCL | 0% | 1 | -, -, -, -, - |
refugees |
Refugees | integer | CCL | 0% | 75 | 2116011, 1952928, 1847304, 1749628, 1717966 |
idps |
Idps | integer | CCL | 0% | 34 | 0, 0, 0, 0, 0 |
stateless |
Stateless | integer | CCL | 0% | 23 | 0, 0, 0, 0, 0 |
others_of_concern |
Others of concern | integer | CCL | 0% | 30 | 0, 0, 0, 0, 0 |
total_population |
Total population | string | CCL | 100% | - | - |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
year |
year | integer | 0% | 75 | 1951, 1952, 1953, 1954, 1955 |
country_of_origin |
country_of_origin | string | 100% | - | - |
country_of_asylum |
country_of_asylum | string | 100% | - | - |
country_of_asylum_iso |
country_of_asylum_iso | string | 0% | 1 | -, -, -, -, - |
population_type |
population_type | string | 100% | - | - |
asylum_seekers |
asylum_seekers | integer | 0% | 34 | 0, 0, 0, 0, 0 |
female_total |
female_total | string | 100% | - | - |
male_total |
male_total | string | 100% | - | - |
female_0_4 |
female_0_4 | string | 100% | - | - |
female_5_11 |
female_5_11 | string | 100% | - | - |
female_12_17 |
female_12_17 | string | 100% | - | - |
female_18_59 |
female_18_59 | string | 100% | - | - |
female_60_plus |
female_60_plus | string | 100% | - | - |
male_0_4 |
male_0_4 | string | 100% | - | - |
male_5_11 |
male_5_11 | string | 100% | - | - |
male_12_17 |
male_12_17 | string | 100% | - | - |
male_18_59 |
male_18_59 | string | 100% | - | - |
male_60_plus |
male_60_plus | string | 100% | - | - |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | GU, GU, GU, GU, GU |
population_count |
Population count | float | SEL | 2% | 65 | 69525.0, 71311.0, 73192.0, 75095.0, 77008.0 |
life_expectancy |
Life expectancy | float | SEL | 3% | 64 | 62.882, 63.226, 63.349, 63.833, 64.104 |
gdp_per_capita_usd |
Gdp per capita usd | float | SEL | 68% | 21 | 20909.9590302806, 21877.3178371553, 23618.8266894573,... |
literacy_rate_pct |
Literacy rate percent | float | SEL | 97% | 2 | 96.4199981689453, 99.370002746582 |
under5_mortality_per_1000 |
Under5 mortality per 1000 | string | SEL | 100% | - | - |
poverty_headcount_pct |
Poverty headcount percent | string | SEL | 100% | - | - |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
country_name |
country_name | string | 0% | 1 | Guam, Guam, Guam, Guam, Guam |
year |
year | integer | 0% | 66 | 1960, 1961, 1962, 1963, 1964 |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | GU, GU, GU, GU, GU |
life_expectancy |
Life expectancy | float | SEL | 3% | 64 | 62.882, 63.226, 63.349, 63.833, 64.104 |
infant_mortality_per_1000 |
Infant mortality per 1000 | string | SEL | 100% | - | - |
under5_mortality_per_1000 |
Under5 mortality per 1000 | string | SEL | 100% | - | - |
maternal_mortality_per_100k |
Maternal mortality per 100k | string | SEL | 100% | - | - |
fertility_rate |
Fertility rate | float | SEL | 3% | 60 | 5.969, 5.948, 5.899, 5.571, 5.393 |
birth_rate_per_1000 |
Birth rate per 1000 | float | SEL | 3% | 64 | 35.334, 34.703, 34.115, 32.205, 31.441 |
death_rate_per_1000 |
Death rate per 1000 | float | SEL | 3% | 64 | 6.062, 5.898, 5.837, 5.586, 5.481 |
physicians_per_1000 |
Physicians per 1000 | float | SEL | 97% | 2 | 1.187, 1.084 |
hospital_beds_per_1000 |
Hospital beds per 1000 | string | SEL | 100% | - | - |
vaccination_rate_pct |
Vaccination rate percent | string | SEL | 100% | - | - |
health_expenditure_pct_gdp |
Health expenditure percent gdp | string | SEL | 100% | - | - |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
country_name |
country_name | string | 0% | 1 | Guam, Guam, Guam, Guam, Guam |
year |
year | integer | 0% | 66 | 1960, 1961, 1962, 1963, 1964 |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
telephones_fixed_lines_subscriptions_per_100_inhabitants_numeric |
Fixed line subscriptions per 100 | float | SEL | 0% | 1 | 43.0 |
telephones_mobile_cellular_subscriptions_per_100_inhabitants_numeric |
Mobile subscriptions per 100 | float | SEL | 0% | 1 | 62.0 |
internet_country_code_text |
Internet country code text | string | SEL+ | 0% | 1 | .gu |
internet_users_percent_of_population_numeric |
Internet penetration percent | float | SEL | 0% | 1 | 81.0 |
broadband_fixed_subscriptions_subscriptions_per_100_inhabitants_numeric |
Broadband subscriptions per 100 | float | SEL | 0% | 1 | 2.0 |
country_code |
Country code | string | SEL | 0% | 1 | GUM |
country_name |
Country name | string | SEL | 0% | 1 | Guam |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
telephones_fixed_lines_total_subscriptions_text |
telephones_fixed_lines_total_subscriptions_text | string | 0% | 1 | 70,000 (2021 est.) |
telephones_fixed_lines_total_subscriptions_numeric |
telephones_fixed_lines_total_subscriptions_numeric | float | 0% | 1 | 70000.0 |
telephones_fixed_lines_subscriptions_per_100_inhabitants_text |
telephones_fixed_lines_subscriptions_per_100_inhabitants_text | string | 0% | 1 | 43 (2022 est.) |
telephones_mobile_cellular_total_subscriptions_text |
telephones_mobile_cellular_total_subscriptions_text | string | 0% | 1 | 98,000 (2009 est.) |
telephones_mobile_cellular_total_subscriptions_numeric |
telephones_mobile_cellular_total_subscriptions_numeric | float | 0% | 1 | 98000.0 |
telephones_mobile_cellular_subscriptions_per_100_inhabitants_text |
telephones_mobile_cellular_subscriptions_per_100_inhabitants_text | string | 0% | 1 | 62 (2009 est.) |
broadcast_media_text |
broadcast_media_text | string | 0% | 1 | about a dozen TV channels, including digital;... |
broadcast_media_numeric |
broadcast_media_numeric | float | 0% | 1 | 20.0 |
internet_users_percent_of_population_text |
internet_users_percent_of_population_text | string | 0% | 1 | 81% (2017 est.) |
broadband_fixed_subscriptions_total_text |
broadband_fixed_subscriptions_total_text | string | 0% | 1 | 3,000 (2022 est.) |
broadband_fixed_subscriptions_total_numeric |
broadband_fixed_subscriptions_total_numeric | float | 0% | 1 | 3000.0 |
broadband_fixed_subscriptions_subscriptions_per_100_inhabitants_text |
broadband_fixed_subscriptions_subscriptions_per_100_inhabitants_text | string | 0% | 1 | 2 (2022 est.) |
source_section |
source_section | string | 0% | 1 | Communications |
source_profile_path |
source_profile_path | string | 0% | 1 | australia-oceania/gq.json |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
gdp_official_exchange_rate_numeric |
Gdp total usd | float | SEL | 0% | 1 | 6.91 |
country_code |
Country code | string | SEL | 0% | 1 | GUM |
country_name |
Country name | string | SEL | 0% | 1 | Guam |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
economic_overview_text |
economic_overview_text | string | 0% | 1 | small Pacific island US territorial economy; upper... |
economic_overview_numeric |
economic_overview_numeric | float | 0% | 1 | -19.0 |
real_gdp_growth_rate_real_gdp_growth_rate_2022_text |
Real gdp growth rate 2022 (text) | string | 0% | 1 | 5.1% (2022 est.) |
real_gdp_growth_rate_real_gdp_growth_rate_2022_numeric |
Real gdp growth rate 2022 (numeric) | float | 0% | 1 | 5.1 |
real_gdp_growth_rate_real_gdp_growth_rate_2021_text |
Real gdp growth rate 2021 (text) | string | 0% | 1 | 2.1% (2021 est.) |
real_gdp_growth_rate_real_gdp_growth_rate_2021_numeric |
Real gdp growth rate 2021 (numeric) | float | 0% | 1 | 2.1 |
real_gdp_growth_rate_real_gdp_growth_rate_2020_text |
Real gdp growth rate 2020 (text) | string | 0% | 1 | -10.5% (2020 est.) |
real_gdp_growth_rate_real_gdp_growth_rate_2020_numeric |
Real gdp growth rate 2020 (numeric) | float | 0% | 1 | -10.5 |
real_gdp_growth_rate_note |
real_gdp_growth_rate_note | string | 0% | 1 | note: annual GDP % growth based on constant local currency |
real_gdp_per_capita_real_gdp_per_capita_2016_text |
Real gdp per capita 2016 (text) | string | 0% | 1 | $35,600 (2016 est.) |
real_gdp_per_capita_real_gdp_per_capita_2016_numeric |
Real gdp per capita 2016 (numeric) | float | 0% | 1 | 35600.0 |
real_gdp_per_capita_real_gdp_per_capita_2015_text |
Real gdp per capita 2015 (text) | string | 0% | 1 | $35,200 (2015 est.) |
real_gdp_per_capita_real_gdp_per_capita_2015_numeric |
Real gdp per capita 2015 (numeric) | float | 0% | 1 | 35200.0 |
real_gdp_per_capita_real_gdp_per_capita_2014_text |
Real gdp per capita 2014 (text) | string | 0% | 1 | $34,400 (2014 est.) |
real_gdp_per_capita_real_gdp_per_capita_2014_numeric |
Real gdp per capita 2014 (numeric) | float | 0% | 1 | 34400.0 |
gdp_official_exchange_rate_text |
gdp_official_exchange_rate_text | string | 0% | 1 | $6.91 billion (2022 est.) |
agricultural_products_text |
agricultural_products_text | string | 0% | 1 | fruits, copra, vegetables; eggs, pork, poultry, beef |
industries_text |
industries_text | string | 0% | 1 | national defense, tourism, construction, transshipment... |
labor_force_text |
labor_force_text | string | 0% | 1 | 77,700 (2024 est.) |
labor_force_numeric |
labor_force_numeric | float | 0% | 1 | 77700.0 |
unemployment_rate_unemployment_rate_2024_text |
Unemployment rate 2024 (text) | string | 0% | 1 | 5.6% (2024 est.) |
unemployment_rate_unemployment_rate_2024_numeric |
Unemployment rate 2024 (numeric) | float | 0% | 1 | 5.6 |
unemployment_rate_unemployment_rate_2023_text |
Unemployment rate 2023 (text) | string | 0% | 1 | 5.4% (2023 est.) |
unemployment_rate_unemployment_rate_2023_numeric |
Unemployment rate 2023 (numeric) | float | 0% | 1 | 5.4 |
unemployment_rate_unemployment_rate_2022_text |
Unemployment rate 2022 (text) | string | 0% | 1 | 5.5% (2022 est.) |
unemployment_rate_unemployment_rate_2022_numeric |
Unemployment rate 2022 (numeric) | float | 0% | 1 | 5.5 |
unemployment_rate_note |
unemployment_rate_note | string | 0% | 1 | note: % of labor force seeking employment |
youth_unemployment_rate_ages_15_24_total_text |
youth_unemployment_rate_ages_15_24_total_text | string | 0% | 1 | 13.7% (2024 est.) |
youth_unemployment_rate_ages_15_24_total_numeric |
youth_unemployment_rate_ages_15_24_total_numeric | float | 0% | 1 | 13.7 |
youth_unemployment_rate_ages_15_24_male_text |
youth_unemployment_rate_ages_15_24_male_text | string | 0% | 1 | 13.3% (2024 est.) |
| +39 more extension fields — download the CSV/Parquet to see them all. | |||||
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
electricity_access_electrification_total_population_numeric |
Electricity access percent | float | SEL | 0% | 1 | 100.0 |
country_code |
Country code | string | SEL | 0% | 1 | GUM |
country_name |
Country name | string | SEL | 0% | 1 | Guam |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
electricity_access_electrification_total_population_text |
electricity_access_electrification_total_population_text | string | 0% | 1 | 100% (2022 est.) |
electricity_installed_generating_capacity_text |
electricity_installed_generating_capacity_text | string | 0% | 1 | 525,000 kW (2023 est.) |
electricity_installed_generating_capacity_numeric |
electricity_installed_generating_capacity_numeric | float | 0% | 1 | 525000.0 |
electricity_consumption_text |
electricity_consumption_text | string | 0% | 1 | 1.715 billion kWh (2023 est.) |
electricity_consumption_numeric |
electricity_consumption_numeric | float | 0% | 1 | 1.715 |
electricity_transmission_distribution_losses_text |
electricity_transmission_distribution_losses_text | string | 0% | 1 | 90.023 million kWh (2023 est.) |
electricity_transmission_distribution_losses_numeric |
electricity_transmission_distribution_losses_numeric | float | 0% | 1 | 90.023 |
electricity_generation_sources_fossil_fuels_text |
electricity_generation_sources_fossil_fuels_text | string | 0% | 1 | 92.1% of total installed capacity (2023 est.) |
electricity_generation_sources_fossil_fuels_numeric |
electricity_generation_sources_fossil_fuels_numeric | float | 0% | 1 | 92.1 |
electricity_generation_sources_solar_text |
electricity_generation_sources_solar_text | string | 0% | 1 | 7.8% of total installed capacity (2023 est.) |
electricity_generation_sources_solar_numeric |
electricity_generation_sources_solar_numeric | float | 0% | 1 | 7.8 |
electricity_generation_sources_wind_text |
electricity_generation_sources_wind_text | string | 0% | 1 | 0.1% of total installed capacity (2023 est.) |
electricity_generation_sources_wind_numeric |
electricity_generation_sources_wind_numeric | float | 0% | 1 | 0.1 |
petroleum_refined_petroleum_consumption_text |
petroleum_refined_petroleum_consumption_text | string | 0% | 1 | 11,000 bbl/day (2023 est.) |
petroleum_refined_petroleum_consumption_numeric |
petroleum_refined_petroleum_consumption_numeric | float | 0% | 1 | 11000.0 |
energy_consumption_per_capita_total_energy_consumption_per_capita_2019_text |
energy_consumption_per_capita_total_energy_consumption_per_capita_2019_text | string | 0% | 1 | 150.555 million Btu/person (2019 est.) |
energy_consumption_per_capita_total_energy_consumption_per_capita_2019_numeric |
energy_consumption_per_capita_total_energy_consumption_per_capita_2019_numeric | float | 0% | 1 | 150.555 |
source_section |
source_section | string | 0% | 1 | Energy |
source_profile_path |
source_profile_path | string | 0% | 1 | australia-oceania/gq.json |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
land_use_agricultural_land_numeric |
Agricultural land percent | float | SEL | 0% | 1 | 29.6 |
land_use_forest_numeric |
Forest area percent | float | SEL | 0% | 1 | 52.4 |
urbanization_urban_population_numeric |
Urban population percent | float | SEL | 0% | 1 | 95.2 |
urbanization_rate_of_urbanization_numeric |
Urban growth rate percent | float | SEL | 0% | 1 | 0.84 |
waste_and_recycling_municipal_solid_waste_generated_annually_numeric |
Municipal waste kg per capita | float | SEL | 0% | 1 | 141500.0 |
country_code |
Country code | string | SEL | 0% | 1 | GUM |
country_name |
Country name | string | SEL | 0% | 1 | Guam |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
environmental_issues_text |
environmental_issues_text | string | 0% | 1 | freshwater scarcity; reef damage; inadequate sewage... |
climate_text |
climate_text | string | 0% | 1 | tropical marine; generally warm and humid, moderated by... |
land_use_agricultural_land_text |
land_use_agricultural_land_text | string | 0% | 1 | 29.6% (2023 est.) |
land_use_agricultural_land_arable_land_text |
land_use_agricultural_land_arable_land_text | string | 0% | 1 | arable land: 1.9% (2023 est.) |
land_use_agricultural_land_arable_land_numeric |
land_use_agricultural_land_arable_land_numeric | float | 0% | 1 | 1.9 |
land_use_agricultural_land_permanent_crops_text |
land_use_agricultural_land_permanent_crops_text | string | 0% | 1 | permanent crops: 13% (2023 est.) |
land_use_agricultural_land_permanent_crops_numeric |
land_use_agricultural_land_permanent_crops_numeric | float | 0% | 1 | 13.0 |
land_use_agricultural_land_permanent_pasture_text |
land_use_agricultural_land_permanent_pasture_text | string | 0% | 1 | permanent pasture: 14.8% (2023 est.) |
land_use_agricultural_land_permanent_pasture_numeric |
land_use_agricultural_land_permanent_pasture_numeric | float | 0% | 1 | 14.8 |
land_use_forest_text |
land_use_forest_text | string | 0% | 1 | 52.4% (2023 est.) |
land_use_other_text |
land_use_other_text | string | 0% | 1 | 18% (2023 est.) |
land_use_other_numeric |
land_use_other_numeric | float | 0% | 1 | 18.0 |
urbanization_urban_population_text |
urbanization_urban_population_text | string | 0% | 1 | 95.2% of total population (2022) |
urbanization_rate_of_urbanization_text |
urbanization_rate_of_urbanization_text | string | 0% | 1 | 0.84% annual rate of change (2020-25 est.) |
carbon_dioxide_emissions_total_emissions_text |
carbon_dioxide_emissions_total_emissions_text | string | 0% | 1 | 1.819 million metric tonnes of CO2 (2023 est.) |
carbon_dioxide_emissions_total_emissions_numeric |
carbon_dioxide_emissions_total_emissions_numeric | float | 0% | 1 | 1.819 |
carbon_dioxide_emissions_from_petroleum_and_other_liquids_text |
carbon_dioxide_emissions_from_petroleum_and_other_liquids_text | string | 0% | 1 | 1.819 million metric tonnes of CO2 (2023 est.) |
carbon_dioxide_emissions_from_petroleum_and_other_liquids_numeric |
carbon_dioxide_emissions_from_petroleum_and_other_liquids_numeric | float | 0% | 1 | 1.819 |
waste_and_recycling_municipal_solid_waste_generated_annually_text |
waste_and_recycling_municipal_solid_waste_generated_annually_text | string | 0% | 1 | 141,500 tons (2024 est.) |
waste_and_recycling_percent_of_municipal_solid_waste_recycled_text |
waste_and_recycling_percent_of_municipal_solid_waste_recycled_text | string | 0% | 1 | 17.9% (2011 est.) |
waste_and_recycling_percent_of_municipal_solid_waste_recycled_numeric |
waste_and_recycling_percent_of_municipal_solid_waste_recycled_numeric | float | 0% | 1 | 17.9 |
source_section |
source_section | string | 0% | 1 | Environment |
source_profile_path |
source_profile_path | string | 0% | 1 | australia-oceania/gq.json |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | GUM |
country_name |
Country name | string | SEL | 0% | 1 | Guam |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
nationality_noun_text |
nationality_noun_text | string | 0% | 1 | Guamanian(s) (US citizens) |
nationality_adjective_text |
nationality_adjective_text | string | 0% | 1 | Guamanian |
ethnic_groups_text |
ethnic_groups_text | string | 0% | 1 | Native Hawaiian and other Pacific Islander 46.1%... |
ethnic_groups_numeric |
ethnic_groups_numeric | float | 0% | 1 | 46.1 |
source_section |
source_section | string | 0% | 1 | People and Society:ethnic_groups |
source_profile_path |
source_profile_path | string | 0% | 1 | australia-oceania/gq.json |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
area_total_numeric |
Area sqkm | float | SEL | 0% | 1 | 544.0 |
area_land_numeric |
Area land sqkm | float | SEL | 0% | 1 | 544.0 |
area_water_numeric |
Area water sqkm | float | SEL | 0% | 1 | 0.0 |
land_boundaries_total_numeric |
Land boundary km | float | SEL | 0% | 1 | 0.0 |
coastline_numeric |
Coastline km | float | SEL | 0% | 1 | 125.5 |
elevation_highest_point_numeric |
Elevation max m | float | SEL | 0% | 1 | 406.0 |
elevation_lowest_point_numeric |
Elevation min m | float | SEL | 0% | 1 | 0.0 |
land_use_agricultural_land_numeric |
Agricultural land percent | float | SEL | 0% | 1 | 29.6 |
land_use_forest_numeric |
Forest area percent | float | SEL | 0% | 1 | 52.4 |
irrigated_land_numeric |
Irrigated land sqkm | float | SEL | 0% | 1 | 2.0 |
country_code |
Country code | string | SEL | 0% | 1 | GUM |
country_name |
Country name | string | SEL | 0% | 1 | Guam |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
location_text |
location_text | string | 0% | 1 | Oceania, island in the North Pacific Ocean, about... |
geographic_coordinates_text |
geographic_coordinates_text | string | 0% | 1 | 13 28 N, 144 47 E |
geographic_coordinates_numeric |
geographic_coordinates_numeric | float | 0% | 1 | 13.0 |
map_references_text |
map_references_text | string | 0% | 1 | Oceania |
area_total_text |
area_total_text | string | 0% | 1 | 544 sq km |
area_land_text |
area_land_text | string | 0% | 1 | 544 sq km |
area_water_text |
area_water_text | string | 0% | 1 | 0 sq km |
area_comparative_text |
area_comparative_text | string | 0% | 1 | three times the size of Washington, D.C. |
land_boundaries_total_text |
land_boundaries_total_text | string | 0% | 1 | 0 km |
coastline_text |
coastline_text | string | 0% | 1 | 125.5 km |
maritime_claims_territorial_sea_text |
maritime_claims_territorial_sea_text | string | 0% | 1 | 12 nm |
maritime_claims_territorial_sea_numeric |
maritime_claims_territorial_sea_numeric | float | 0% | 1 | 12.0 |
maritime_claims_exclusive_economic_zone_text |
maritime_claims_exclusive_economic_zone_text | string | 0% | 1 | 200 nm |
maritime_claims_exclusive_economic_zone_numeric |
maritime_claims_exclusive_economic_zone_numeric | float | 0% | 1 | 200.0 |
climate_text |
climate_text | string | 0% | 1 | tropical marine; generally warm and humid, moderated by... |
terrain_text |
terrain_text | string | 0% | 1 | volcanic origin, surrounded by coral reefs; relatively... |
elevation_highest_point_text |
elevation_highest_point_text | string | 0% | 1 | Mount Lamlam 406 m |
elevation_lowest_point_text |
elevation_lowest_point_text | string | 0% | 1 | Pacific Ocean 0 m |
natural_resources_text |
natural_resources_text | string | 0% | 1 | aquatic wildlife (supporting tourism), fishing (largely... |
land_use_agricultural_land_text |
land_use_agricultural_land_text | string | 0% | 1 | 29.6% (2023 est.) |
land_use_agricultural_land_arable_land_text |
land_use_agricultural_land_arable_land_text | string | 0% | 1 | arable land: 1.9% (2023 est.) |
land_use_agricultural_land_arable_land_numeric |
land_use_agricultural_land_arable_land_numeric | float | 0% | 1 | 1.9 |
land_use_agricultural_land_permanent_crops_text |
land_use_agricultural_land_permanent_crops_text | string | 0% | 1 | permanent crops: 13% (2023 est.) |
land_use_agricultural_land_permanent_crops_numeric |
land_use_agricultural_land_permanent_crops_numeric | float | 0% | 1 | 13.0 |
land_use_agricultural_land_permanent_pasture_text |
land_use_agricultural_land_permanent_pasture_text | string | 0% | 1 | permanent pasture: 14.8% (2023 est.) |
land_use_agricultural_land_permanent_pasture_numeric |
land_use_agricultural_land_permanent_pasture_numeric | float | 0% | 1 | 14.8 |
land_use_forest_text |
land_use_forest_text | string | 0% | 1 | 52.4% (2023 est.) |
land_use_other_text |
land_use_other_text | string | 0% | 1 | 18% (2023 est.) |
land_use_other_numeric |
land_use_other_numeric | float | 0% | 1 | 18.0 |
irrigated_land_text |
irrigated_land_text | string | 0% | 1 | 2 sq km (2012) |
| +5 more extension fields — download the CSV/Parquet to see them all. | |||||
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | GUM |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
country_name_conventional_long_form_text |
country_name_conventional_long_form_text | string | 0% | 1 | none |
country_name_conventional_short_form_text |
country_name_conventional_short_form_text | string | 0% | 1 | Guam |
country_name_local_long_form_text |
country_name_local_long_form_text | string | 0% | 1 | none |
country_name_local_short_form_text |
country_name_local_short_form_text | string | 0% | 1 | Guahan |
country_name_abbreviation_text |
country_name_abbreviation_text | string | 0% | 1 | GU |
country_name_etymology_text |
country_name_etymology_text | string | 0% | 1 | the native Chamorro name for the island, Guahan (meaning... |
country_name_etymology_numeric |
country_name_etymology_numeric | float | 0% | 1 | 1898.0 |
government_type_text |
government_type_text | string | 0% | 1 | unincorporated organized territory of the US with local... |
dependency_status_text |
dependency_status_text | string | 0% | 1 | unincorporated, organized territory of the US, with... |
capital_name_text |
capital_name_text | string | 0% | 1 | Hagatna (Agana) |
capital_geographic_coordinates_text |
capital_geographic_coordinates_text | string | 0% | 1 | 13 28 N, 144 44 E |
capital_geographic_coordinates_numeric |
capital_geographic_coordinates_numeric | float | 0% | 1 | 13.0 |
capital_time_difference_text |
capital_time_difference_text | string | 0% | 1 | UTC+10 (15 hours ahead of Washington, DC, during Standard Time) |
capital_time_difference_numeric |
capital_time_difference_numeric | float | 0% | 1 | 10.0 |
capital_etymology_text |
capital_etymology_text | string | 0% | 1 | the name Hagatna is derived from the Chamorro word haga,... |
legal_system_text |
legal_system_text | string | 0% | 1 | common law modeled on US system; US federal laws apply |
constitution_history_text |
constitution_history_text | string | 0% | 1 | effective 1 July 1950 (Guam Act of 1950 serves as a constitution) |
constitution_history_numeric |
constitution_history_numeric | float | 0% | 1 | 1.0 |
citizenship_text |
citizenship_text | string | 0% | 1 | see United States |
suffrage_text |
suffrage_text | string | 0% | 1 | 18 years of age; universal |
suffrage_numeric |
suffrage_numeric | float | 0% | 1 | 18.0 |
executive_branch_chief_of_state_text |
executive_branch_chief_of_state_text | string | 0% | 1 | President Donald J. TRUMP (since 20 January 2025) |
executive_branch_chief_of_state_numeric |
executive_branch_chief_of_state_numeric | float | 0% | 1 | 20.0 |
executive_branch_head_of_government_text |
executive_branch_head_of_government_text | string | 0% | 1 | Governor Lourdes LEON GUERRERO (since 7 January 2019) |
executive_branch_head_of_government_numeric |
executive_branch_head_of_government_numeric | float | 0% | 1 | 7.0 |
executive_branch_cabinet_text |
executive_branch_cabinet_text | string | 0% | 1 | Cabinet appointed by the governor with the consent of... |
executive_branch_election_appointment_process_text |
executive_branch_election_appointment_process_text | string | 0% | 1 | president and vice president indirectly elected on the... |
executive_branch_election_appointment_process_numeric |
executive_branch_election_appointment_process_numeric | float | 0% | 1 | 4.0 |
executive_branch_most_recent_election_date_text |
executive_branch_most_recent_election_date_text | string | 0% | 1 | gubernatorial: 8 November 2022 |
executive_branch_most_recent_election_date_numeric |
executive_branch_most_recent_election_date_numeric | float | 0% | 1 | 8.0 |
| +43 more extension fields — download the CSV/Parquet to see them all. | |||||
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | GUM |
country_name |
Country name | string | SEL | 0% | 1 | Guam |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
background_text |
background_text | string | 0% | 1 | Guam was settled by Austronesian people around 1500 B.C.... |
background_numeric |
background_numeric | float | 0% | 1 | 1500.0 |
source_section |
source_section | string | 0% | 1 | Introduction |
source_profile_path |
source_profile_path | string | 0% | 1 | australia-oceania/gq.json |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | GUM |
country_name |
Country name | string | SEL | 0% | 1 | Guam |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
languages_text |
languages_text | string | 0% | 1 | English 43.3%, Filipino 24.9%, Chamorro 16%, other... |
languages_numeric |
languages_numeric | float | 0% | 1 | 43.3 |
source_section |
source_section | string | 0% | 1 | People and Society:languages |
source_profile_path |
source_profile_path | string | 0% | 1 | australia-oceania/gq.json |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | GUM |
country_name |
Country name | string | SEL | 0% | 1 | Guam |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
military_and_security_forces_text |
military_and_security_forces_text | string | 0% | 1 | Guam Police Department (GPD); Guam (US) National Guard |
military_note_text |
military_note_text | string | 0% | 1 | the US military maintains thousands of active-duty... |
source_section |
source_section | string | 0% | 1 | Military and Security |
source_profile_path |
source_profile_path | string | 0% | 1 | australia-oceania/gq.json |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
population_total_numeric |
Population count | float | SEL | 0% | 1 | 169532.0 |
population_male_numeric |
Population male | float | SEL | 0% | 1 | 87345.0 |
population_female_numeric |
Population female | float | SEL | 0% | 1 | 82187.0 |
age_structure_0_14_years_numeric |
Population 0 14 percent | float | SEL | 0% | 1 | 26.4 |
age_structure_15_64_years_numeric |
Population 15 64 percent | float | SEL | 0% | 1 | 62.7 |
age_structure_65_years_and_over_numeric |
Population 65 plus percent | float | SEL | 0% | 1 | 10.9 |
dependency_ratios_total_dependency_ratio_numeric |
Total dependency ratio | float | SEL | 0% | 1 | 59.4 |
dependency_ratios_youth_dependency_ratio_numeric |
Youth dependency ratio | float | SEL | 0% | 1 | 42.1 |
dependency_ratios_elderly_dependency_ratio_numeric |
Elderly dependency ratio | float | SEL | 0% | 1 | 17.3 |
median_age_total_numeric |
Median age | float | SEL | 0% | 1 | 30.5 |
population_growth_rate_numeric |
Population growth rate percent | float | SEL | 0% | 1 | 0.08 |
birth_rate_numeric |
Birth rate per 1000 | float | SEL | 0% | 1 | 17.9 |
death_rate_numeric |
Death rate per 1000 | float | SEL | 0% | 1 | 6.18 |
net_migration_rate_numeric |
Net migration per 1000 | float | SEL | 0% | 1 | -10.92 |
urbanization_urban_population_numeric |
Urban population percent | float | SEL | 0% | 1 | 95.2 |
urbanization_rate_of_urbanization_numeric |
Urban growth rate percent | float | SEL | 0% | 1 | 0.84 |
sex_ratio_at_birth_numeric |
Sex ratio at birth | float | SEL | 0% | 1 | 1.07 |
sex_ratio_total_population_numeric |
Sex ratio overall | float | SEL | 0% | 1 | 1.06 |
infant_mortality_rate_total_numeric |
Infant mortality per 1000 | float | SEL | 0% | 1 | 10.7 |
life_expectancy_at_birth_total_population_numeric |
Life expectancy | float | SEL | 0% | 1 | 78.0 |
total_fertility_rate_numeric |
Fertility rate | float | SEL | 0% | 1 | 2.7 |
gross_reproduction_rate_numeric |
Gross reproduction rate | float | SEL | 0% | 1 | 1.31 |
country_code |
Country code | string | SEL | 0% | 1 | GUM |
country_name |
Country name | string | SEL | 0% | 1 | Guam |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
population_total_text |
population_total_text | string | 0% | 1 | 169,532 (2024 est.) |
population_male_text |
population_male_text | string | 0% | 1 | 87,345 |
population_female_text |
population_female_text | string | 0% | 1 | 82,187 |
age_structure_0_14_years_text |
age_structure_0_14_years_text | string | 0% | 1 | 26.4% (male 23,139/female 21,632) |
age_structure_15_64_years_text |
age_structure_15_64_years_text | string | 0% | 1 | 62.7% (male 55,591/female 50,741) |
age_structure_65_years_and_over_text |
age_structure_65_years_and_over_text | string | 0% | 1 | 10.9% (2024 est.) (male 8,615/female 9,814) |
dependency_ratios_total_dependency_ratio_text |
dependency_ratios_total_dependency_ratio_text | string | 0% | 1 | 59.4 (2024 est.) |
dependency_ratios_youth_dependency_ratio_text |
dependency_ratios_youth_dependency_ratio_text | string | 0% | 1 | 42.1 (2024 est.) |
dependency_ratios_elderly_dependency_ratio_text |
dependency_ratios_elderly_dependency_ratio_text | string | 0% | 1 | 17.3 (2024 est.) |
dependency_ratios_potential_support_ratio_text |
dependency_ratios_potential_support_ratio_text | string | 0% | 1 | 5.8 (2024 est.) |
dependency_ratios_potential_support_ratio_numeric |
dependency_ratios_potential_support_ratio_numeric | float | 0% | 1 | 5.8 |
median_age_total_text |
median_age_total_text | string | 0% | 1 | 30.5 years (2025 est.) |
median_age_male_text |
median_age_male_text | string | 0% | 1 | 29.6 years |
median_age_male_numeric |
median_age_male_numeric | float | 0% | 1 | 29.6 |
median_age_female_text |
median_age_female_text | string | 0% | 1 | 31.1 years |
median_age_female_numeric |
median_age_female_numeric | float | 0% | 1 | 31.1 |
population_growth_rate_text |
population_growth_rate_text | string | 0% | 1 | 0.08% (2025 est.) |
birth_rate_text |
birth_rate_text | string | 0% | 1 | 17.9 births/1,000 population (2025 est.) |
death_rate_text |
death_rate_text | string | 0% | 1 | 6.18 deaths/1,000 population (2025 est.) |
net_migration_rate_text |
net_migration_rate_text | string | 0% | 1 | -10.92 migrant(s)/1,000 population (2025 est.) |
population_distribution_text |
population_distribution_text | string | 0% | 1 | no large cities exist on the island; large villages... |
urbanization_urban_population_text |
urbanization_urban_population_text | string | 0% | 1 | 95.2% of total population (2022) |
urbanization_rate_of_urbanization_text |
urbanization_rate_of_urbanization_text | string | 0% | 1 | 0.84% annual rate of change (2020-25 est.) |
major_urban_areas_population_text |
major_urban_areas_population_text | string | 0% | 1 | 147,000 HAGATNA (capital) (2018) |
major_urban_areas_population_numeric |
major_urban_areas_population_numeric | float | 0% | 1 | 147000.0 |
sex_ratio_at_birth_text |
sex_ratio_at_birth_text | string | 0% | 1 | 1.07 male(s)/female |
sex_ratio_0_14_years_text |
sex_ratio_0_14_years_text | string | 0% | 1 | 1.07 male(s)/female |
sex_ratio_0_14_years_numeric |
sex_ratio_0_14_years_numeric | float | 0% | 1 | 1.07 |
sex_ratio_15_64_years_text |
sex_ratio_15_64_years_text | string | 0% | 1 | 1.1 male(s)/female |
sex_ratio_15_64_years_numeric |
sex_ratio_15_64_years_numeric | float | 0% | 1 | 1.1 |
| +27 more extension fields — download the CSV/Parquet to see them all. | |||||
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | GUM |
country_name |
Country name | string | SEL | 0% | 1 | Guam |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
composition_religion_buddhist_pct_synth |
Buddhist | numeric | CCL | 0% | - | 1.1 |
composition_religion_other_pct_synth |
other | numeric | CCL | 0% | - | 1.6 |
composition_ethnicity_primary_label_synth |
Native Hawaiian and other Pacific Islander | string | CCL | 0% | - | Native Hawaiian and other Pacific Islander |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
religions_text |
religions_text | string | 0% | 1 | Christian (predominantly Roman Catholic) 94.2%, folk... |
religions_numeric |
religions_numeric | float | 0% | 1 | 94.2 |
source_section |
source_section | string | 0% | 1 | People and Society:religions |
source_profile_path |
source_profile_path | string | 0% | 1 | australia-oceania/gq.json |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
composition_religion_christian_predominantly_roman_catholic_pct_synth |
Christian (predominantly Roman Catholic) | numeric | 0% | - | 94.2 |
composition_religion_folk_religions_pct_synth |
folk religions | numeric | 0% | - | 1.5 |
composition_religion_unaffiliated_pct_synth |
unaffiliated | numeric | 0% | - | 1.7 |
composition_ethnicity_native_hawaiian_and_other_pacific_islander_pct_synth |
Native Hawaiian and other Pacific Islander | numeric | 0% | - | 46.1 |
composition_ethnicity_native_hawaiian_and_other_pacific_islander__chamorro_pct_synth |
Chamorro | numeric | 0% | - | 32.8 |
composition_ethnicity_native_hawaiian_and_other_pacific_islander__chuukese_pct_synth |
Chuukese | numeric | 0% | - | 6.7 |
composition_ethnicity_native_hawaiian_and_other_pacific_islander__palauan_pct_synth |
Palauan | numeric | 0% | - | 1.4 |
composition_ethnicity_native_hawaiian_and_other_pacific_islander__pohnpeian_pct_synth |
Pohnpeian | numeric | 0% | - | 1.4 |
composition_ethnicity_native_hawaiian_and_other_pacific_islander__yapese_pct_synth |
Yapese | numeric | 0% | - | 1.0 |
composition_ethnicity_native_hawaiian_and_other_pacific_islander__other_native_hawaiian_and_other_pacific_islander_pct_synth |
other Native Hawaiian and other Pacific Islander | numeric | 0% | - | 2.8 |
composition_ethnicity_asian_pct_synth |
Asian | numeric | 0% | - | 35.5 |
composition_ethnicity_asian__filipino_pct_synth |
Filipino | numeric | 0% | - | 29.1 |
composition_ethnicity_asian__korean_pct_synth |
Korean | numeric | 0% | - | 2.2 |
composition_ethnicity_asian__japanese_pct_synth |
Japanese | numeric | 0% | - | 1.4 |
composition_ethnicity_asian__chinese_except_taiwanese_pct_synth |
Chinese (except Taiwanese) | numeric | 0% | - | 1.3 |
composition_ethnicity_asian__other_asian_pct_synth |
other Asian | numeric | 0% | - | 1.5 |
composition_ethnicity_white_pct_synth |
White | numeric | 0% | - | 6.8 |
composition_ethnicity_african_descent_or_african_american_pct_synth |
African descent or African-American | numeric | 0% | - | 0.9 |
composition_ethnicity_indigenous_pct_synth |
Indigenous | numeric | 0% | - | 0.1 |
composition_ethnicity_other_pct_synth |
other | numeric | 0% | - | 0.6 |
composition_ethnicity_mixed_pct_synth |
mixed | numeric | 0% | - | 10.0 |
composition_ethnicity_primary_share_pct_synth |
Native Hawaiian and other Pacific Islander | numeric | 0% | - | 46.1 |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
civil_aircraft_registration_country_code_prefix_text |
Civil aircraft registration country code prefix text | string | SEL+ | 0% | 1 | N |
airports_numeric |
Airports count | float | SEL | 0% | 1 | 3.0 |
country_code |
Country code | string | SEL | 0% | 1 | GUM |
country_name |
Country name | string | SEL | 0% | 1 | Guam |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
airports_text |
airports_text | string | 0% | 1 | 3 (2025) |
heliports_text |
heliports_text | string | 0% | 1 | 2 (2025) |
heliports_numeric |
heliports_numeric | float | 0% | 1 | 2.0 |
merchant_marine_total_text |
merchant_marine_total_text | string | 0% | 1 | 3 (2023) |
merchant_marine_total_numeric |
merchant_marine_total_numeric | float | 0% | 1 | 3.0 |
merchant_marine_by_type_text |
merchant_marine_by_type_text | string | 0% | 1 | other 3 |
merchant_marine_by_type_numeric |
merchant_marine_by_type_numeric | float | 0% | 1 | 3.0 |
ports_total_ports_text |
ports_total_ports_text | string | 0% | 1 | 1 (2024) |
ports_total_ports_numeric |
ports_total_ports_numeric | float | 0% | 1 | 1.0 |
ports_large_text |
ports_large_text | float | 0% | 1 | 0 |
ports_large_numeric |
ports_large_numeric | float | 0% | 1 | 0.0 |
ports_medium_text |
ports_medium_text | float | 0% | 1 | 1 |
ports_medium_numeric |
ports_medium_numeric | float | 0% | 1 | 1.0 |
ports_small_text |
ports_small_text | float | 0% | 1 | 0 |
ports_small_numeric |
ports_small_numeric | float | 0% | 1 | 0.0 |
ports_very_small_text |
ports_very_small_text | float | 0% | 1 | 0 |
ports_very_small_numeric |
ports_very_small_numeric | float | 0% | 1 | 0.0 |
ports_ports_with_oil_terminals_text |
Ports with oil terminals (text) | float | 0% | 1 | 1 |
ports_ports_with_oil_terminals_numeric |
Ports with oil terminals (numeric) | float | 0% | 1 | 1.0 |
ports_key_ports_text |
ports_key_ports_text | string | 0% | 1 | Apra Harbor |
source_section |
source_section | string | 0% | 1 | Transportation |
source_profile_path |
source_profile_path | string | 0% | 1 | australia-oceania/gq.json |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
glottocode |
Glottocode | string | CCL | 0% | 2 | cham1312, ping1243 |
name |
Name | string | CCL | 0% | 2 | Chamorro, Pingelapese |
iso639_3 |
Iso639 3 | string | CCL | 0% | 2 | cha, pif |
level |
Level | string | CCL | 0% | 1 | language, language |
family_name |
Family name | string | CCL | 100% | - | - |
family_glottocode |
Family glottocode | string | CCL | 0% | 1 | aust1307, aust1307 |
parent_name |
Parent name | string | CCL | 100% | - | - |
parent_glottocode |
Parent glottocode | string | CCL | 0% | 2 | mala1545, pona1248 |
endangerment_status |
Endangerment status | string | CCL | 100% | - | - |
country_codes |
Country codes | string | SEL+ | 0% | 2 | ['GU', 'MP'], ['FM', 'GU', 'US'] |
child_family_count |
Child family count | integer | CCL | 0% | 1 | 0, 0 |
child_language_count |
Child language count | integer | CCL | 0% | 1 | 0, 0 |
child_dialect_count |
Child dialect count | integer | CCL | 0% | 2 | 2, 0 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
latitude |
latitude | float | 0% | 2 | 13.438011, 6.20743 |
longitude |
longitude | float | 0% | 2 | 144.74474, 160.711 |
classification |
classification | string | 0% | 1 | [], [] |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | GUM |
admin_level |
Admin level | string | SEL | 0% | 1 | admin_0 |
admin_name |
Admin name | string | SEL | 0% | 1 | Guam |
admin_code |
Admin code | string | SEL | 0% | 1 | 54299874B37751202631168 |
area_sqkm |
Area sqkm | float | SEL | 0% | 1 | 540.2715 |
pop_2024 |
Population count | integer | SEL | 0% | 1 | 162420 |
pop_density_2024 |
Population density | float | SEL | 0% | 1 | 300.63 |
The data providers this country's datasets are sourced from — each links out to the provider.
| Source | Type | Access |
|---|---|---|
| U.S. Census Bureau | official_nso | api |
| Glottolog Language Catalog | academic | bulk_download |
| World Bank Open Data | international_organization | api |
| UNHCR Refugee Data Finder (UN High Commissioner for Refugees) | international_organization | api |
| LandScan Global (ORNL — Oak Ridge National Laboratory) | research_institution | earth_engine |
| OpenFactBook | community_compilation | bulk_download |
Pick datasets and admin level(s). You'll get a .zip with one CSV per dataset, each filtered to the levels you choose.