| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
pcode |
Admin code | string | SEL | 0% | 1 | BW |
region_name |
Region name | string | SEL | 0% | 1 | Botswana |
F_TL |
Female population | integer | SEL | 0% | 1 | 1258673 |
M_TL |
Male population | integer | SEL | 0% | 1 | 1159391 |
T_TL |
Total population | integer | SEL | 0% | 1 | 2418064 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
admin_level |
Admin level | string | 0% | 1 | admin_0 |
year |
Reference year | integer | 0% | 1 | 2023 |
year |
year | integer | 0% | 1 | 2023 |
F_00_04 |
Female population age 0-4 | integer | 0% | 1 | 116692 |
F_05_09 |
Female population age 5-9 | integer | 0% | 1 | 117266 |
F_10_14 |
Female population age 10-14 | integer | 0% | 1 | 115555 |
F_15_19 |
Female population age 15-19 | integer | 0% | 1 | 111531 |
F_20_24 |
Female population age 20-24 | integer | 0% | 1 | 107699 |
F_25_29 |
Female population age 25-29 | integer | 0% | 1 | 104939 |
F_30_34 |
Female population age 30-34 | integer | 0% | 1 | 100621 |
F_35_39 |
Female population age 35-39 | integer | 0% | 1 | 95439 |
F_40_44 |
Female population age 40-44 | integer | 0% | 1 | 90611 |
F_45_49 |
Female population age 45-49 | integer | 0% | 1 | 71419 |
F_50_54 |
Female population age 50-54 | integer | 0% | 1 | 55667 |
F_55_59 |
Female population age 55-59 | integer | 0% | 1 | 46408 |
F_60_64 |
Female population age 60-64 | integer | 0% | 1 | 38934 |
F_65_69 |
Female population age 65-69 | integer | 0% | 1 | 30187 |
F_70_74 |
Female population age 70-74 | integer | 0% | 1 | 22346 |
F_75_79 |
Female population age 75-79 | integer | 0% | 1 | 16299 |
F_80Plus |
F_80Plus | integer | 0% | 1 | 17060 |
M_00_04 |
Male population age 0-4 | integer | 0% | 1 | 119552 |
M_05_09 |
Male population age 5-9 | integer | 0% | 1 | 119827 |
M_10_14 |
Male population age 10-14 | integer | 0% | 1 | 116810 |
M_15_19 |
Male population age 15-19 | integer | 0% | 1 | 109139 |
M_20_24 |
Male population age 20-24 | integer | 0% | 1 | 102216 |
M_25_29 |
Male population age 25-29 | integer | 0% | 1 | 101464 |
M_30_34 |
Male population age 30-34 | integer | 0% | 1 | 96201 |
M_35_39 |
Male population age 35-39 | integer | 0% | 1 | 77893 |
M_40_44 |
Male population age 40-44 | integer | 0% | 1 | 73027 |
M_45_49 |
Male population age 45-49 | integer | 0% | 1 | 62501 |
| +24 more pending fields — download the CSV/Parquet to see them all. | |||||
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
pcode |
Admin code | string | SEL | 0% | 17 | BW12, BW15, BW02, BW01, BW16 |
region_name |
Region name | string | SEL | 0% | 17 | Central, Chobe, Francistown, Gaborone, Ghanzi |
F_TL |
Female population | integer | SEL | 0% | 17 | 347357, 15754, 57574, 140784, 28153 |
M_TL |
Male population | integer | SEL | 0% | 17 | 312587, 16116, 53032, 131813, 29116 |
T_TL |
Total population | integer | SEL | 0% | 17 | 659944, 31870, 110606, 272597, 57269 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
admin_level |
Admin level | string | 0% | 1 | admin_1, admin_1, admin_1, admin_1, admin_1 |
year |
Reference year | integer | 0% | 1 | 2023, 2023, 2023, 2023, 2023 |
year |
year | integer | 0% | 1 | 2023, 2023, 2023, 2023, 2023 |
F_00_04 |
Female population age 0-4 | integer | 0% | 17 | 35275, 1500, 4928, 8897, 2973 |
F_05_09 |
Female population age 5-9 | integer | 0% | 17 | 35883, 1434, 4761, 8875, 2985 |
F_10_14 |
Female population age 10-14 | integer | 0% | 17 | 36396, 1326, 4671, 8887, 2888 |
F_15_19 |
Female population age 15-19 | integer | 0% | 17 | 33786, 983, 4858, 11783, 2932 |
F_20_24 |
Female population age 20-24 | integer | 0% | 17 | 22998, 1484, 6292, 17936, 2295 |
F_25_29 |
Female population age 25-29 | integer | 0% | 17 | 22710, 1676, 6638, 16140, 2250 |
F_30_34 |
Female population age 30-34 | integer | 0% | 17 | 22008, 1619, 5749, 15919, 2115 |
F_35_39 |
Female population age 35-39 | integer | 0% | 17 | 21815, 1392, 5268, 14791, 2108 |
F_40_44 |
Female population age 40-44 | integer | 0% | 17 | 21875, 1203, 4656, 13004, 1944 |
F_45_49 |
Female population age 45-49 | integer | 0% | 17 | 19186, 936, 3113, 8770, 1509 |
F_50_54 |
Female population age 50-54 | integer | 0% | 17 | 16518, 640, 2203, 6039, 1032 |
F_55_59 |
Female population age 55-59 | integer | 0% | 17 | 15026, 451, 1611, 4055, 859 |
F_60_64 |
Female population age 60-64 | integer | 0% | 17 | 13478, 412, 1114, 2560, 581 |
F_65_69 |
Female population age 65-69 | integer | 0% | 17 | 10012, 275, 686, 1461, 520 |
F_70_74 |
Female population age 70-74 | integer | 0% | 17 | 7982, 183, 461, 766, 374 |
F_75_79 |
Female population age 75-79 | integer | 0% | 17 | 5942, 119, 292, 516, 344 |
F_80Plus |
F_80Plus | integer | 0% | 16 | 6467, 121, 273, 385, 444 |
M_00_04 |
Male population age 0-4 | integer | 0% | 17 | 36193, 1550, 4957, 8990, 3152 |
M_05_09 |
Male population age 5-9 | integer | 0% | 17 | 37196, 1451, 4706, 8886, 3058 |
M_10_14 |
Male population age 10-14 | integer | 0% | 17 | 36749, 1341, 4584, 8639, 2987 |
M_15_19 |
Male population age 15-19 | integer | 0% | 17 | 34374, 1020, 4472, 10353, 2828 |
M_20_24 |
Male population age 20-24 | integer | 0% | 17 | 22854, 1881, 5464, 16875, 2348 |
M_25_29 |
Male population age 25-29 | integer | 0% | 17 | 22046, 1798, 6098, 15732, 2550 |
M_30_34 |
Male population age 30-34 | integer | 0% | 17 | 20743, 1645, 5800, 14741, 2410 |
M_35_39 |
Male population age 35-39 | integer | 0% | 17 | 17199, 1328, 4245, 11968, 2019 |
M_40_44 |
Male population age 40-44 | integer | 0% | 17 | 16359, 1232, 3812, 11490, 1765 |
M_45_49 |
Male population age 45-49 | integer | 0% | 17 | 15163, 933, 3096, 8904, 1807 |
| +24 more pending fields — download the CSV/Parquet to see them all. | |||||
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
pcode |
Admin code | string | SEL | 0% | 100 | BW1203, BW1204, BW1202, BW1201, BW1205 |
region_name |
Region name | string | SEL | 0% | 97 | Bobonong, Boteti, Mahalapye, Serowe Palapye, Tutume |
F_TL |
Female population | integer | SEL | 0% | 100 | 39298, 34911, 63672, 110597, 98879 |
M_TL |
Male population | integer | SEL | 0% | 99 | 34233, 32615, 57173, 102577, 85989 |
T_TL |
Total population | integer | SEL | 0% | 100 | 73531, 67526, 120845, 213174, 184868 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
admin_level |
Admin level | string | 0% | 2 | admin_2, admin_2, admin_2, admin_2, admin_2 |
year |
Reference year | integer | 0% | 1 | 2023, 2023, 2023, 2023, 2023 |
year |
year | integer | 0% | 1 | 2023, 2023, 2023, 2023, 2023 |
F_00_04 |
Female population age 0-4 | integer | 0% | 94 | 4078, 3664, 6597, 10374, 10562 |
F_05_09 |
Female population age 5-9 | integer | 0% | 95 | 4020, 3808, 6781, 10643, 10631 |
F_10_14 |
Female population age 10-14 | integer | 0% | 90 | 4145, 3830, 6762, 10637, 11022 |
F_15_19 |
Female population age 15-19 | integer | 0% | 84 | 3609, 3504, 5045, 12494, 9134 |
F_20_24 |
Female population age 20-24 | integer | 0% | 90 | 2453, 2608, 3824, 7380, 6733 |
F_25_29 |
Female population age 25-29 | integer | 0% | 82 | 2320, 2730, 4038, 7345, 6277 |
F_30_34 |
Female population age 30-34 | integer | 0% | 83 | 2410, 2446, 3974, 7240, 5938 |
F_35_39 |
Female population age 35-39 | integer | 0% | 82 | 2459, 2273, 3755, 7245, 6083 |
F_40_44 |
Female population age 40-44 | integer | 0% | 79 | 2390, 2165, 4136, 7152, 6032 |
F_45_49 |
Female population age 45-49 | integer | 0% | 83 | 2261, 1964, 3788, 6049, 5124 |
F_50_54 |
Female population age 50-54 | integer | 0% | 83 | 1980, 1460, 3257, 5319, 4502 |
F_55_59 |
Female population age 55-59 | integer | 0% | 81 | 1783, 1053, 2990, 4938, 4262 |
F_60_64 |
Female population age 60-64 | integer | 0% | 75 | 1588, 973, 2638, 4481, 3798 |
F_65_69 |
Female population age 65-69 | integer | 0% | 73 | 1308, 727, 1990, 3152, 2835 |
F_70_74 |
Female population age 70-74 | integer | 0% | 69 | 998, 695, 1661, 2431, 2197 |
F_75_79 |
Female population age 75-79 | integer | 0% | 62 | 712, 444, 1197, 1799, 1790 |
F_80Plus |
F_80Plus | integer | 0% | 68 | 784, 567, 1239, 1918, 1959 |
M_00_04 |
Male population age 0-4 | integer | 0% | 94 | 4025, 3918, 6760, 10700, 10790 |
M_05_09 |
Male population age 5-9 | integer | 0% | 95 | 4101, 3904, 6885, 10965, 11341 |
M_10_14 |
Male population age 10-14 | integer | 0% | 94 | 4343, 3830, 6899, 10692, 10985 |
M_15_19 |
Male population age 15-19 | integer | 0% | 87 | 3793, 3395, 5477, 12592, 9117 |
M_20_24 |
Male population age 20-24 | integer | 0% | 85 | 2372, 2604, 3862, 7758, 6258 |
M_25_29 |
Male population age 25-29 | integer | 0% | 85 | 2314, 2633, 3675, 7645, 5779 |
M_30_34 |
Male population age 30-34 | integer | 0% | 82 | 2120, 2363, 3752, 7356, 5152 |
M_35_39 |
Male population age 35-39 | integer | 0% | 83 | 1861, 1811, 3020, 6135, 4372 |
M_40_44 |
Male population age 40-44 | integer | 0% | 78 | 1632, 1590, 3090, 5937, 4110 |
M_45_49 |
Male population age 45-49 | integer | 0% | 81 | 1581, 1551, 2887, 5167, 3977 |
| +24 more pending 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 | BWA, BWA, BWA, BWA, BWA |
region_code |
Admin code | string | SEL | 100% | - | - |
region_name |
Admin name | string | SEL | 0% | 11 | Total, Central, Chobe, Ghanzi, Kgalagadi |
human_development_index |
Human development index | float | SEL | 0% | 69 | 0.632, 0.601, 0.598, 0.636, 0.613 |
health_index |
Health index | float | SEL | 0% | 81 | 0.617, 0.595, 0.624, 0.623, 0.535 |
education_index |
Education index | float | SEL | 0% | 87 | 0.588, 0.546, 0.486, 0.561, 0.597 |
income_index |
Income index | float | SEL | 0% | 68 | 0.696, 0.669, 0.706, 0.734, 0.721 |
life_expectancy |
Life expectancy | float | SEL | 0% | 95 | 60.1, 58.67, 60.59, 60.52, 54.77 |
mean_years_schooling |
Mean years schooling | float | SEL | 0% | 99 | 8.827, 7.55, 12.98, 9.964, 9.557 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
year |
year | integer | 0% | 10 | 1990, 1990, 1990, 1990, 1990 |
level |
level | string | 0% | 2 | national, subnational, subnational, subnational, subnational |
| 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 | BW, BW, BW, BW, BW |
population_count |
Population count | float | SEL | 2% | 65 | 516165.0, 527942.0, 540186.0, 552966.0, 566266.0 |
life_expectancy |
Life expectancy | float | SEL | 3% | 64 | 51.22, 51.781, 52.313, 52.848, 53.358 |
gdp_per_capita_usd |
Gdp per capita usd | float | SEL | 2% | 65 | 58.9180081084204, 62.3224006926623, 65.9864503023827,... |
literacy_rate_pct |
Literacy rate percent | float | SEL | 97% | 2 | 68.5800018310547, 81.1900024414062 |
under5_mortality_per_1000 |
Under5 mortality per 1000 | float | SEL | 3% | 64 | 167.7, 162.6, 157.9, 153.4, 148.9 |
poverty_headcount_pct |
Poverty headcount percent | float | SEL | 92% | 5 | 59.0, 32.9, 30.6, 19.3, 16.1 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
country_name |
country_name | string | 0% | 1 | Botswana, Botswana, Botswana, Botswana, Botswana |
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 | BW, BW, BW, BW, BW |
life_expectancy |
Life expectancy | float | SEL | 3% | 64 | 51.22, 51.781, 52.313, 52.848, 53.358 |
infant_mortality_per_1000 |
Infant mortality per 1000 | float | SEL | 11% | 57 | 40.3, 39.4, 38.2, 37.1, 36.1 |
under5_mortality_per_1000 |
Under5 mortality per 1000 | float | SEL | 3% | 64 | 167.7, 162.6, 157.9, 153.4, 148.9 |
maternal_mortality_per_100k |
Maternal mortality per 100k | float | SEL | 41% | 39 | 313.0, 304.0, 302.0, 319.0, 300.0 |
fertility_rate |
Fertility rate | float | SEL | 3% | 63 | 6.595, 6.564, 6.536, 6.578, 6.613 |
birth_rate_per_1000 |
Birth rate per 1000 | float | SEL | 3% | 63 | 47.14, 46.593, 46.032, 45.934, 45.775 |
death_rate_per_1000 |
Death rate per 1000 | float | SEL | 3% | 64 | 16.412, 15.937, 15.473, 15.038, 14.633 |
physicians_per_1000 |
Physicians per 1000 | float | SEL | 50% | 29 | 0.042, 0.036, 0.064, 0.133, 0.123 |
hospital_beds_per_1000 |
Hospital beds per 1000 | float | SEL | 61% | 20 | 2.12291669845581, 2.36310005187988, 1.5751999617, 2.13, 2.16 |
vaccination_rate_pct |
Vaccination rate percent | float | SEL | 32% | 14 | 71.0, 75.0, 82.0, 82.0, 83.0 |
health_expenditure_pct_gdp |
Health expenditure percent gdp | float | SEL | 64% | 24 | 6.10838556, 6.3660779, 6.66529799, 6.40933847, 6.09125996 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
country_name |
country_name | string | 0% | 1 | Botswana, Botswana, Botswana, Botswana, Botswana |
year |
year | integer | 0% | 66 | 1960, 1961, 1962, 1963, 1964 |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
glottocode |
Glottocode | string | CCL | 0% | 37 | afri1274, anii1246, bemb1257, birw1238, diri1252 |
name |
Name | string | CCL | 0% | 37 | Afrikaans, //Ani, Bemba (Zambia), Birwa, Diriku-Shambyu |
iso639_3 |
Iso639 3 | string | CCL | 5% | 35 | afr, hnh, bem, brl, diu |
level |
Level | string | CCL | 0% | 1 | language, language, language, language, language |
family_name |
Family name | string | CCL | 100% | - | - |
family_glottocode |
Family glottocode | string | CCL | 0% | 5 | indo1319, khoe1240, atla1278, atla1278, atla1278 |
parent_name |
Parent name | string | CCL | 100% | - | - |
parent_glottocode |
Parent glottocode | string | CCL | 0% | 29 | afri1273, kxoe1242, bemb1256, nort3233, kwan1288 |
endangerment_status |
Endangerment status | string | CCL | 100% | - | - |
country_codes |
Country codes | string | SEL+ | 0% | 19 | ['BW', 'MZ', 'NA', 'ZA', 'ZM', 'ZW'], ['BW'], ['BW',... |
child_family_count |
Child family count | integer | CCL | 0% | 1 | 0, 0, 0, 0, 0 |
child_language_count |
Child language count | integer | CCL | 0% | 1 | 0, 0, 0, 0, 0 |
child_dialect_count |
Child dialect count | integer | CCL | 0% | 14 | 3, 0, 12, 0, 2 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
latitude |
latitude | float | 0% | 37 | -31.63272, -19.0966, -10.6122, -22.17, -18.1681 |
longitude |
longitude | float | 0% | 37 | 20.46356, 22.9088, 29.2993, 28.33, 20.6678 |
classification |
classification | string | 0% | 1 | [], [], [], [], [] |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | BWA |
admin_level |
Admin level | string | SEL | 0% | 1 | admin_0 |
admin_name |
Admin name | string | SEL | 0% | 1 | Botswana |
admin_code |
Admin code | string | SEL | 0% | 1 | 68990947B38995363734097 |
area_sqkm |
Area sqkm | float | SEL | 0% | 1 | 578131.4555 |
pop_2024 |
Population count | integer | SEL | 0% | 1 | 2450925 |
pop_density_2024 |
Population density | float | SEL | 0% | 1 | 4.24 |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | BWA, BWA, BWA, BWA, BWA |
admin_level |
Admin level | string | SEL | 0% | 1 | admin_1, admin_1, admin_1, admin_1, admin_1 |
admin_name |
Admin name | string | SEL | 0% | 10 | Central District, Kweneng District, South-East District,... |
admin_code |
Admin code | string | SEL | 0% | 10 | 57670837B77729612727439, 57670837B49806718353307,... |
area_sqkm |
Area sqkm | float | SEL | 0% | 10 | 146656.2183, 37012.5913, 1748.5696, 27367.7492, 111457.1584 |
pop_2024 |
Population count | integer | SEL | 0% | 10 | 734418, 415369, 377844, 250751, 204943 |
pop_density_2024 |
Population density | float | SEL | 0% | 10 | 5.01, 11.22, 216.09, 9.16, 1.84 |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | BWA, BWA, BWA, BWA, BWA |
admin_level |
Admin level | string | SEL | 0% | 1 | locality, locality, locality, locality, locality |
admin_name |
Admin name | string | SEL | 0% | 7 | Gaborone, Molepolole, Francistown, Kanye, Mahalapye |
admin_code |
Admin code | integer | SEL | 0% | 7 | 591, 289, 859, 114, 730 |
area_sqkm |
Area sqkm | float | SEL | 0% | 7 | 121.4653, 50.7746, 32.8359, 26.8834, 33.8426 |
pop_2024 |
Population count | integer | SEL | 0% | 7 | 239610, 70671, 39089, 32457, 28383 |
pop_density_2024 |
Population density | float | SEL | 0% | 7 | 1972.66, 1391.86, 1190.43, 1207.32, 838.68 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
ghs_pop_2025 |
ghs_pop_2025 | integer | 0% | 7 | 298993, 121562, 116209, 52206, 61469 |
landscan_vs_ghs_ratio |
landscan_vs_ghs_ratio | float | 0% | 7 | 0.801, 0.581, 0.336, 0.622, 0.462 |
| 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 | 3.0 |
telephones_mobile_cellular_subscriptions_per_100_inhabitants_numeric |
Mobile subscriptions per 100 | float | SEL | 0% | 1 | 164.0 |
internet_country_code_text |
Internet country code text | string | SEL+ | 0% | 1 | .bw |
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 | 3.0 |
country_code |
Country code | string | SEL | 0% | 1 | BWA |
country_name |
Country name | string | SEL | 0% | 1 | Botswana |
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 | 83,200 (2024 est.) |
telephones_fixed_lines_total_subscriptions_numeric |
telephones_fixed_lines_total_subscriptions_numeric | float | 0% | 1 | 83200.0 |
telephones_fixed_lines_subscriptions_per_100_inhabitants_text |
telephones_fixed_lines_subscriptions_per_100_inhabitants_text | string | 0% | 1 | 3 (2024 est.) |
telephones_mobile_cellular_total_subscriptions_text |
telephones_mobile_cellular_total_subscriptions_text | string | 0% | 1 | 4.13 million (2024 est.) |
telephones_mobile_cellular_total_subscriptions_numeric |
telephones_mobile_cellular_total_subscriptions_numeric | float | 0% | 1 | 4.13 |
telephones_mobile_cellular_subscriptions_per_100_inhabitants_text |
telephones_mobile_cellular_subscriptions_per_100_inhabitants_text | string | 0% | 1 | 164 (2024 est.) |
broadcast_media_text |
broadcast_media_text | string | 0% | 1 | 2 TV stations, 1 state-owned and 1 privately owned;... |
broadcast_media_numeric |
broadcast_media_numeric | float | 0% | 1 | 2.0 |
internet_users_percent_of_population_text |
internet_users_percent_of_population_text | string | 0% | 1 | 81% (2023 est.) |
broadband_fixed_subscriptions_total_text |
broadband_fixed_subscriptions_total_text | string | 0% | 1 | 85,000 (2023 est.) |
broadband_fixed_subscriptions_total_numeric |
broadband_fixed_subscriptions_total_numeric | float | 0% | 1 | 85000.0 |
broadband_fixed_subscriptions_subscriptions_per_100_inhabitants_text |
broadband_fixed_subscriptions_subscriptions_per_100_inhabitants_text | string | 0% | 1 | 3 (2023 est.) |
source_section |
source_section | string | 0% | 1 | Communications |
source_profile_path |
source_profile_path | string | 0% | 1 | africa/bc.json |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
real_gdp_per_capita_real_gdp_per_capita_2024_numeric |
Real gdp per capita 2024 (numeric) | float | SEL | 0% | 1 | 18100.0 |
gdp_official_exchange_rate_numeric |
Gdp total usd | float | SEL | 0% | 1 | 19.401 |
population_below_poverty_line_numeric |
Poverty headcount percent | float | SEL | 0% | 1 | 16.1 |
country_code |
Country code | string | SEL | 0% | 1 | BWA |
country_name |
Country name | string | SEL | 0% | 1 | Botswana |
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 | good economic governance and financial management;... |
economic_overview_numeric |
economic_overview_numeric | float | 0% | 1 | -19.0 |
real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2024_text |
Real gdp purchasing power parity 2024 (text) | string | 0% | 1 | $45.553 billion (2024 est.) |
real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2024_numeric |
Real gdp purchasing power parity 2024 (numeric) | float | 0% | 1 | 45.553 |
real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2023_text |
Real gdp purchasing power parity 2023 (text) | string | 0% | 1 | $46.957 billion (2023 est.) |
real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2023_numeric |
Real gdp purchasing power parity 2023 (numeric) | float | 0% | 1 | 46.957 |
real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2022_text |
Real gdp purchasing power parity 2022 (text) | string | 0% | 1 | $45.498 billion (2022 est.) |
real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2022_numeric |
Real gdp purchasing power parity 2022 (numeric) | float | 0% | 1 | 45.498 |
real_gdp_purchasing_power_parity_note |
real_gdp_purchasing_power_parity_note | string | 0% | 1 | note: data in 2021 dollars |
real_gdp_growth_rate_real_gdp_growth_rate_2024_text |
Real gdp growth rate 2024 (text) | string | 0% | 1 | -3% (2024 est.) |
real_gdp_growth_rate_real_gdp_growth_rate_2024_numeric |
Real gdp growth rate 2024 (numeric) | float | 0% | 1 | -3.0 |
real_gdp_growth_rate_real_gdp_growth_rate_2023_text |
Real gdp growth rate 2023 (text) | string | 0% | 1 | 3.2% (2023 est.) |
real_gdp_growth_rate_real_gdp_growth_rate_2023_numeric |
Real gdp growth rate 2023 (numeric) | float | 0% | 1 | 3.2 |
real_gdp_growth_rate_real_gdp_growth_rate_2022_text |
Real gdp growth rate 2022 (text) | string | 0% | 1 | 5.5% (2022 est.) |
real_gdp_growth_rate_real_gdp_growth_rate_2022_numeric |
Real gdp growth rate 2022 (numeric) | float | 0% | 1 | 5.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_2024_text |
Real gdp per capita 2024 (text) | string | 0% | 1 | $18,100 (2024 est.) |
real_gdp_per_capita_real_gdp_per_capita_2023_text |
Real gdp per capita 2023 (text) | string | 0% | 1 | $18,900 (2023 est.) |
real_gdp_per_capita_real_gdp_per_capita_2023_numeric |
Real gdp per capita 2023 (numeric) | float | 0% | 1 | 18900.0 |
real_gdp_per_capita_real_gdp_per_capita_2022_text |
Real gdp per capita 2022 (text) | string | 0% | 1 | $18,600 (2022 est.) |
real_gdp_per_capita_real_gdp_per_capita_2022_numeric |
Real gdp per capita 2022 (numeric) | float | 0% | 1 | 18600.0 |
real_gdp_per_capita_note |
real_gdp_per_capita_note | string | 0% | 1 | note: data in 2021 dollars |
gdp_official_exchange_rate_text |
gdp_official_exchange_rate_text | string | 0% | 1 | $19.401 billion (2024 est.) |
inflation_rate_consumer_prices_inflation_rate_consumer_prices_2024_text |
Inflation rate consumer prices 2024 (text) | string | 0% | 1 | 2.8% (2024 est.) |
inflation_rate_consumer_prices_inflation_rate_consumer_prices_2024_numeric |
Inflation rate consumer prices 2024 (numeric) | float | 0% | 1 | 2.8 |
inflation_rate_consumer_prices_inflation_rate_consumer_prices_2023_text |
Inflation rate consumer prices 2023 (text) | string | 0% | 1 | 5.1% (2023 est.) |
inflation_rate_consumer_prices_inflation_rate_consumer_prices_2023_numeric |
Inflation rate consumer prices 2023 (numeric) | float | 0% | 1 | 5.1 |
inflation_rate_consumer_prices_inflation_rate_consumer_prices_2022_text |
Inflation rate consumer prices 2022 (text) | string | 0% | 1 | 11.7% (2022 est.) |
inflation_rate_consumer_prices_inflation_rate_consumer_prices_2022_numeric |
Inflation rate consumer prices 2022 (numeric) | float | 0% | 1 | 11.7 |
inflation_rate_consumer_prices_note |
inflation_rate_consumer_prices_note | string | 0% | 1 | note: annual % change based on consumer prices |
| +119 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 | 75.9 |
country_code |
Country code | string | SEL | 0% | 1 | BWA |
country_name |
Country name | string | SEL | 0% | 1 | Botswana |
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 | 75.9% (2022 est.) |
electricity_access_electrification_urban_areas_text |
electricity_access_electrification_urban_areas_text | string | 0% | 1 | 95.5% |
electricity_access_electrification_urban_areas_numeric |
electricity_access_electrification_urban_areas_numeric | float | 0% | 1 | 95.5 |
electricity_access_electrification_rural_areas_text |
electricity_access_electrification_rural_areas_text | string | 0% | 1 | 25% |
electricity_access_electrification_rural_areas_numeric |
electricity_access_electrification_rural_areas_numeric | float | 0% | 1 | 25.0 |
electricity_installed_generating_capacity_text |
electricity_installed_generating_capacity_text | string | 0% | 1 | 758,000 kW (2023 est.) |
electricity_installed_generating_capacity_numeric |
electricity_installed_generating_capacity_numeric | float | 0% | 1 | 758000.0 |
electricity_consumption_text |
electricity_consumption_text | string | 0% | 1 | 3.879 billion kWh (2023 est.) |
electricity_consumption_numeric |
electricity_consumption_numeric | float | 0% | 1 | 3.879 |
electricity_exports_text |
electricity_exports_text | string | 0% | 1 | 2 million kWh (2023 est.) |
electricity_exports_numeric |
electricity_exports_numeric | float | 0% | 1 | 2.0 |
electricity_imports_text |
electricity_imports_text | string | 0% | 1 | 1.923 billion kWh (2023 est.) |
electricity_imports_numeric |
electricity_imports_numeric | float | 0% | 1 | 1.923 |
electricity_transmission_distribution_losses_text |
electricity_transmission_distribution_losses_text | string | 0% | 1 | 625.694 million kWh (2023 est.) |
electricity_transmission_distribution_losses_numeric |
electricity_transmission_distribution_losses_numeric | float | 0% | 1 | 625.694 |
electricity_generation_sources_fossil_fuels_text |
electricity_generation_sources_fossil_fuels_text | string | 0% | 1 | 99.8% of total installed capacity (2023 est.) |
electricity_generation_sources_fossil_fuels_numeric |
electricity_generation_sources_fossil_fuels_numeric | float | 0% | 1 | 99.8 |
electricity_generation_sources_solar_text |
electricity_generation_sources_solar_text | string | 0% | 1 | 0.2% of total installed capacity (2023 est.) |
electricity_generation_sources_solar_numeric |
electricity_generation_sources_solar_numeric | float | 0% | 1 | 0.2 |
coal_production_text |
coal_production_text | string | 0% | 1 | 2.242 million metric tons (2023 est.) |
coal_production_numeric |
coal_production_numeric | float | 0% | 1 | 2.242 |
coal_consumption_text |
coal_consumption_text | string | 0% | 1 | 1.351 million metric tons (2023 est.) |
coal_consumption_numeric |
coal_consumption_numeric | float | 0% | 1 | 1.351 |
coal_exports_text |
coal_exports_text | string | 0% | 1 | 891,000 metric tons (2023 est.) |
coal_exports_numeric |
coal_exports_numeric | float | 0% | 1 | 891000.0 |
coal_imports_text |
coal_imports_text | string | 0% | 1 | 300 metric tons (2023 est.) |
coal_imports_numeric |
coal_imports_numeric | float | 0% | 1 | 300.0 |
coal_proven_reserves_text |
coal_proven_reserves_text | string | 0% | 1 | 1.66 billion metric tons (2023 est.) |
coal_proven_reserves_numeric |
coal_proven_reserves_numeric | float | 0% | 1 | 1.66 |
petroleum_refined_petroleum_consumption_text |
petroleum_refined_petroleum_consumption_text | string | 0% | 1 | 22,000 bbl/day (2023 est.) |
| +5 more extension fields — download the CSV/Parquet to see them all. | |||||
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
land_use_agricultural_land_numeric |
Agricultural land percent | float | SEL | 0% | 1 | 45.6 |
land_use_forest_numeric |
Forest area percent | float | SEL | 0% | 1 | 27.8 |
urbanization_urban_population_numeric |
Urban population percent | float | SEL | 0% | 1 | 72.9 |
urbanization_rate_of_urbanization_numeric |
Urban growth rate percent | float | SEL | 0% | 1 | 2.47 |
waste_and_recycling_municipal_solid_waste_generated_annually_numeric |
Municipal waste kg per capita | float | SEL | 0% | 1 | 210900.0 |
country_code |
Country code | string | SEL | 0% | 1 | BWA |
country_name |
Country name | string | SEL | 0% | 1 | Botswana |
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 | overgrazing; desertification; limited freshwater... |
international_environmental_agreements_party_to_text |
international_environmental_agreements_party_to_text | string | 0% | 1 | Biodiversity, Climate Change, Climate Change-Kyoto... |
international_environmental_agreements_signed_but_not_ratified_text |
international_environmental_agreements_signed_but_not_ratified_text | string | 0% | 1 | none of the selected agreements |
climate_text |
climate_text | string | 0% | 1 | semiarid; warm winters and hot summers |
land_use_agricultural_land_text |
land_use_agricultural_land_text | string | 0% | 1 | 45.6% (2023 est.) |
land_use_agricultural_land_arable_land_text |
land_use_agricultural_land_arable_land_text | string | 0% | 1 | arable land: 0.5% (2023 est.) |
land_use_agricultural_land_arable_land_numeric |
land_use_agricultural_land_arable_land_numeric | float | 0% | 1 | 0.5 |
land_use_agricultural_land_permanent_crops_text |
land_use_agricultural_land_permanent_crops_text | string | 0% | 1 | permanent crops: 0% (2023 est.) |
land_use_agricultural_land_permanent_crops_numeric |
land_use_agricultural_land_permanent_crops_numeric | float | 0% | 1 | 0.0 |
land_use_agricultural_land_permanent_pasture_text |
land_use_agricultural_land_permanent_pasture_text | string | 0% | 1 | permanent pasture: 45.2% (2023 est.) |
land_use_agricultural_land_permanent_pasture_numeric |
land_use_agricultural_land_permanent_pasture_numeric | float | 0% | 1 | 45.2 |
land_use_forest_text |
land_use_forest_text | string | 0% | 1 | 27.8% (2023 est.) |
land_use_other_text |
land_use_other_text | string | 0% | 1 | 26.6% (2023 est.) |
land_use_other_numeric |
land_use_other_numeric | float | 0% | 1 | 26.6 |
urbanization_urban_population_text |
urbanization_urban_population_text | string | 0% | 1 | 72.9% of total population (2023) |
urbanization_rate_of_urbanization_text |
urbanization_rate_of_urbanization_text | string | 0% | 1 | 2.47% annual rate of change (2020-25 est.) |
carbon_dioxide_emissions_total_emissions_text |
carbon_dioxide_emissions_total_emissions_text | string | 0% | 1 | 5.897 million metric tonnes of CO2 (2023 est.) |
carbon_dioxide_emissions_total_emissions_numeric |
carbon_dioxide_emissions_total_emissions_numeric | float | 0% | 1 | 5.897 |
carbon_dioxide_emissions_from_coal_and_metallurgical_coke_text |
carbon_dioxide_emissions_from_coal_and_metallurgical_coke_text | string | 0% | 1 | 2.818 million metric tonnes of CO2 (2023 est.) |
carbon_dioxide_emissions_from_coal_and_metallurgical_coke_numeric |
carbon_dioxide_emissions_from_coal_and_metallurgical_coke_numeric | float | 0% | 1 | 2.818 |
carbon_dioxide_emissions_from_petroleum_and_other_liquids_text |
carbon_dioxide_emissions_from_petroleum_and_other_liquids_text | string | 0% | 1 | 3.079 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 | 3.079 |
particulate_matter_emissions_text |
particulate_matter_emissions_text | string | 0% | 1 | 12.5 micrograms per cubic meter (2019 est.) |
particulate_matter_emissions_numeric |
particulate_matter_emissions_numeric | float | 0% | 1 | 12.5 |
methane_emissions_energy_text |
methane_emissions_energy_text | string | 0% | 1 | 26 kt (2022-2024 est.) |
methane_emissions_energy_numeric |
methane_emissions_energy_numeric | float | 0% | 1 | 26.0 |
methane_emissions_agriculture_text |
methane_emissions_agriculture_text | string | 0% | 1 | 144 kt (2019-2021 est.) |
methane_emissions_agriculture_numeric |
methane_emissions_agriculture_numeric | float | 0% | 1 | 144.0 |
methane_emissions_waste_text |
methane_emissions_waste_text | string | 0% | 1 | 841.4 kt (2019-2021 est.) |
methane_emissions_waste_numeric |
methane_emissions_waste_numeric | float | 0% | 1 | 841.4 |
| +15 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 | BWA |
country_name |
Country name | string | SEL | 0% | 1 | Botswana |
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 | Motswana (singular), Batswana (plural) |
nationality_adjective_text |
nationality_adjective_text | string | 0% | 1 | Motswana (singular), Batswana (plural) |
ethnic_groups_text |
ethnic_groups_text | string | 0% | 1 | Tswana (or Setswana) 79%, Kalanga 11%, Basarwa 3%,... |
ethnic_groups_numeric |
ethnic_groups_numeric | float | 0% | 1 | 79.0 |
source_section |
source_section | string | 0% | 1 | People and Society:ethnic_groups |
source_profile_path |
source_profile_path | string | 0% | 1 | africa/bc.json |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
area_total_numeric |
Area sqkm | float | SEL | 0% | 1 | 581730.0 |
area_land_numeric |
Area land sqkm | float | SEL | 0% | 1 | 566730.0 |
area_water_numeric |
Area water sqkm | float | SEL | 0% | 1 | 15000.0 |
land_boundaries_total_numeric |
Land boundary km | float | SEL | 0% | 1 | 4347.15 |
coastline_numeric |
Coastline km | float | SEL | 0% | 1 | 0.0 |
elevation_highest_point_numeric |
Elevation max m | float | SEL | 0% | 1 | 1495.0 |
elevation_lowest_point_numeric |
Elevation min m | float | SEL | 0% | 1 | 513.0 |
land_use_agricultural_land_numeric |
Agricultural land percent | float | SEL | 0% | 1 | 45.6 |
land_use_forest_numeric |
Forest area percent | float | SEL | 0% | 1 | 27.8 |
irrigated_land_numeric |
Irrigated land sqkm | float | SEL | 0% | 1 | 25.0 |
country_code |
Country code | string | SEL | 0% | 1 | BWA |
country_name |
Country name | string | SEL | 0% | 1 | Botswana |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
location_text |
location_text | string | 0% | 1 | Southern Africa, north of South Africa |
geographic_coordinates_text |
geographic_coordinates_text | string | 0% | 1 | 22 00 S, 24 00 E |
geographic_coordinates_numeric |
geographic_coordinates_numeric | float | 0% | 1 | 22.0 |
map_references_text |
map_references_text | string | 0% | 1 | Africa |
area_total_text |
area_total_text | string | 0% | 1 | 581,730 sq km |
area_land_text |
area_land_text | string | 0% | 1 | 566,730 sq km |
area_water_text |
area_water_text | string | 0% | 1 | 15,000 sq km |
area_comparative_text |
area_comparative_text | string | 0% | 1 | slightly smaller than Texas; almost four times the size... |
land_boundaries_total_text |
land_boundaries_total_text | string | 0% | 1 | 4,347.15 km |
land_boundaries_border_countries_text |
land_boundaries_border_countries_text | string | 0% | 1 | Namibia 1,544 km; South Africa 1,969 km; Zambia 0.15 km;... |
land_boundaries_border_countries_numeric |
land_boundaries_border_countries_numeric | float | 0% | 1 | 1544.0 |
coastline_text |
coastline_text | string | 0% | 1 | 0 km (landlocked) |
maritime_claims_text |
maritime_claims_text | string | 0% | 1 | none (landlocked) |
climate_text |
climate_text | string | 0% | 1 | semiarid; warm winters and hot summers |
terrain_text |
terrain_text | string | 0% | 1 | predominantly flat to gently rolling tableland; Kalahari... |
elevation_highest_point_text |
elevation_highest_point_text | string | 0% | 1 | Manyelanong Hill 1,495 m |
elevation_lowest_point_text |
elevation_lowest_point_text | string | 0% | 1 | junction of the Limpopo and Shashe Rivers 513 m |
elevation_mean_elevation_text |
elevation_mean_elevation_text | string | 0% | 1 | 1,013 m |
elevation_mean_elevation_numeric |
elevation_mean_elevation_numeric | float | 0% | 1 | 1013.0 |
natural_resources_text |
natural_resources_text | string | 0% | 1 | diamonds, copper, nickel, salt, soda ash, potash, coal,... |
land_use_agricultural_land_text |
land_use_agricultural_land_text | string | 0% | 1 | 45.6% (2023 est.) |
land_use_agricultural_land_arable_land_text |
land_use_agricultural_land_arable_land_text | string | 0% | 1 | arable land: 0.5% (2023 est.) |
land_use_agricultural_land_arable_land_numeric |
land_use_agricultural_land_arable_land_numeric | float | 0% | 1 | 0.5 |
land_use_agricultural_land_permanent_crops_text |
land_use_agricultural_land_permanent_crops_text | string | 0% | 1 | permanent crops: 0% (2023 est.) |
land_use_agricultural_land_permanent_crops_numeric |
land_use_agricultural_land_permanent_crops_numeric | float | 0% | 1 | 0.0 |
land_use_agricultural_land_permanent_pasture_text |
land_use_agricultural_land_permanent_pasture_text | string | 0% | 1 | permanent pasture: 45.2% (2023 est.) |
land_use_agricultural_land_permanent_pasture_numeric |
land_use_agricultural_land_permanent_pasture_numeric | float | 0% | 1 | 45.2 |
land_use_forest_text |
land_use_forest_text | string | 0% | 1 | 27.8% (2023 est.) |
land_use_other_text |
land_use_other_text | string | 0% | 1 | 26.6% (2023 est.) |
land_use_other_numeric |
land_use_other_numeric | float | 0% | 1 | 26.6 |
| +16 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 | BWA |
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 | Republic of Botswana |
country_name_conventional_short_form_text |
country_name_conventional_short_form_text | string | 0% | 1 | Botswana |
country_name_local_long_form_text |
country_name_local_long_form_text | string | 0% | 1 | Republic of Botswana |
country_name_local_short_form_text |
country_name_local_short_form_text | string | 0% | 1 | Botswana |
country_name_former_text |
country_name_former_text | string | 0% | 1 | Bechuanaland |
country_name_etymology_text |
country_name_etymology_text | string | 0% | 1 | the name Botswana means "Land of the Tswana," referring... |
government_type_text |
government_type_text | string | 0% | 1 | parliamentary republic |
capital_name_text |
capital_name_text | string | 0% | 1 | Gaborone |
capital_geographic_coordinates_text |
capital_geographic_coordinates_text | string | 0% | 1 | 24 38 S, 25 54 E |
capital_geographic_coordinates_numeric |
capital_geographic_coordinates_numeric | float | 0% | 1 | 24.0 |
capital_time_difference_text |
capital_time_difference_text | string | 0% | 1 | UTC+2 (7 hours ahead of Washington, DC, during Standard Time) |
capital_time_difference_numeric |
capital_time_difference_numeric | float | 0% | 1 | 2.0 |
capital_etymology_text |
capital_etymology_text | string | 0% | 1 | named after GABORONE (ca. 1825-1931), a chief of the... |
capital_etymology_numeric |
capital_etymology_numeric | float | 0% | 1 | 1825.0 |
administrative_divisions_text |
administrative_divisions_text | string | 0% | 1 | 10 districts and 6 town councils*; Central, Chobe,... |
administrative_divisions_numeric |
administrative_divisions_numeric | float | 0% | 1 | 10.0 |
legal_system_text |
legal_system_text | string | 0% | 1 | mixed legal system of civil law influenced by the... |
constitution_history_text |
constitution_history_text | string | 0% | 1 | previous 1960 (pre-independence); latest adopted March... |
constitution_history_numeric |
constitution_history_numeric | float | 0% | 1 | 1960.0 |
constitution_amendment_process_text |
constitution_amendment_process_text | string | 0% | 1 | proposed by the National Assembly; passage requires... |
international_law_organization_participation_text |
international_law_organization_participation_text | string | 0% | 1 | accepts compulsory ICJ jurisdiction with reservations;... |
citizenship_citizenship_by_birth_text |
Citizenship by birth (text) | string | 0% | 1 | no |
citizenship_citizenship_by_descent_only_text |
Citizenship by descent only (text) | string | 0% | 1 | at least one parent must be a citizen of Botswana |
citizenship_dual_citizenship_recognized_text |
citizenship_dual_citizenship_recognized_text | string | 0% | 1 | no |
citizenship_residency_requirement_for_naturalization_text |
citizenship_residency_requirement_for_naturalization_text | string | 0% | 1 | 10 years |
citizenship_residency_requirement_for_naturalization_numeric |
citizenship_residency_requirement_for_naturalization_numeric | float | 0% | 1 | 10.0 |
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 Duma BOKO (since 1 November 2024) |
executive_branch_chief_of_state_numeric |
executive_branch_chief_of_state_numeric | float | 0% | 1 | 1.0 |
| +74 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 | BWA |
country_name |
Country name | string | SEL | 0% | 1 | Botswana |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
background_text |
background_text | string | 0% | 1 | In the early 1800s, multiple political entities in what... |
background_numeric |
background_numeric | float | 0% | 1 | 1800.0 |
source_section |
source_section | string | 0% | 1 | Introduction |
source_profile_path |
source_profile_path | string | 0% | 1 | africa/bc.json |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | BWA |
country_name |
Country name | string | SEL | 0% | 1 | Botswana |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
languages_text |
languages_text | string | 0% | 1 | Setswana 77.3%, Sekalanga 7.4%, Shekgalagadi 3.4%,... |
languages_numeric |
languages_numeric | float | 0% | 1 | 77.3 |
source_section |
source_section | string | 0% | 1 | People and Society:languages |
source_profile_path |
source_profile_path | string | 0% | 1 | africa/bc.json |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | BWA |
country_name |
Country name | string | SEL | 0% | 1 | Botswana |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
refugees_and_internally_displaced_persons_refugees_text |
refugees_and_internally_displaced_persons_refugees_text | string | 0% | 1 | 823 (2024 est.) |
refugees_and_internally_displaced_persons_refugees_numeric |
refugees_and_internally_displaced_persons_refugees_numeric | float | 0% | 1 | 823.0 |
refugees_and_internally_displaced_persons_idps_text |
refugees_and_internally_displaced_persons_idps_text | string | 0% | 1 | 99 (2023 est.) |
refugees_and_internally_displaced_persons_idps_numeric |
refugees_and_internally_displaced_persons_idps_numeric | float | 0% | 1 | 99.0 |
source_section |
source_section | string | 0% | 1 | Transnational Issues:migration |
source_profile_path |
source_profile_path | string | 0% | 1 | africa/bc.json |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | BWA |
country_name |
Country name | string | SEL | 0% | 1 | Botswana |
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 | Botswana Defense Force (BDF): Ground Forces Command, Air... |
military_and_security_forces_numeric |
military_and_security_forces_numeric | float | 0% | 1 | 2025.0 |
military_expenditures_military_expenditures_2024_text |
Military expenditures 2024 (text) | string | 0% | 1 | 3% of GDP (2024 est.) |
military_expenditures_military_expenditures_2024_numeric |
Military expenditures 2024 (numeric) | float | 0% | 1 | 3.0 |
military_expenditures_military_expenditures_2023_text |
Military expenditures 2023 (text) | string | 0% | 1 | 2.6% of GDP (2023 est.) |
military_expenditures_military_expenditures_2023_numeric |
Military expenditures 2023 (numeric) | float | 0% | 1 | 2.6 |
military_expenditures_military_expenditures_2022_text |
Military expenditures 2022 (text) | string | 0% | 1 | 2.8% of GDP (2022 est.) |
military_expenditures_military_expenditures_2022_numeric |
Military expenditures 2022 (numeric) | float | 0% | 1 | 2.8 |
military_expenditures_military_expenditures_2021_text |
Military expenditures 2021 (text) | string | 0% | 1 | 3% of GDP (2021 est.) |
military_expenditures_military_expenditures_2021_numeric |
Military expenditures 2021 (numeric) | float | 0% | 1 | 3.0 |
military_expenditures_military_expenditures_2020_text |
Military expenditures 2020 (text) | string | 0% | 1 | 3% of GDP (2020 est.) |
military_expenditures_military_expenditures_2020_numeric |
Military expenditures 2020 (numeric) | float | 0% | 1 | 3.0 |
military_and_security_service_personnel_strengths_text |
military_and_security_service_personnel_strengths_text | string | 0% | 1 | estimated 10,000 active Botswana Defense Force (2025) |
military_and_security_service_personnel_strengths_numeric |
military_and_security_service_personnel_strengths_numeric | float | 0% | 1 | 10000.0 |
military_equipment_inventories_and_acquisitions_text |
military_equipment_inventories_and_acquisitions_text | string | 0% | 1 | the BDF has a mix of mostly older weapons and equipment,... |
military_equipment_inventories_and_acquisitions_numeric |
military_equipment_inventories_and_acquisitions_numeric | float | 0% | 1 | 2025.0 |
military_service_age_and_obligation_text |
military_service_age_and_obligation_text | string | 0% | 1 | 18-24 years of age (men and women) for general recruits... |
military_service_age_and_obligation_numeric |
military_service_age_and_obligation_numeric | float | 0% | 1 | 18.0 |
military_note_text |
military_note_text | string | 0% | 1 | the key responsibilities of the Botswana Defense Force... |
military_note_numeric |
military_note_numeric | float | 0% | 1 | 1960.0 |
source_section |
source_section | string | 0% | 1 | Military and Security |
source_profile_path |
source_profile_path | string | 0% | 1 | africa/bc.json |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
population_total_numeric |
Population count | float | SEL | 0% | 1 | 2521534.0 |
population_male_numeric |
Population male | float | SEL | 0% | 1 | 1234898.0 |
population_female_numeric |
Population female | float | SEL | 0% | 1 | 1286636.0 |
age_structure_0_14_years_numeric |
Population 0 14 percent | float | SEL | 0% | 1 | 28.7 |
age_structure_15_64_years_numeric |
Population 15 64 percent | float | SEL | 0% | 1 | 65.2 |
age_structure_65_years_and_over_numeric |
Population 65 plus percent | float | SEL | 0% | 1 | 6.1 |
dependency_ratios_total_dependency_ratio_numeric |
Total dependency ratio | float | SEL | 0% | 1 | 60.9 |
dependency_ratios_youth_dependency_ratio_numeric |
Youth dependency ratio | float | SEL | 0% | 1 | 52.1 |
dependency_ratios_elderly_dependency_ratio_numeric |
Elderly dependency ratio | float | SEL | 0% | 1 | 8.8 |
median_age_total_numeric |
Median age | float | SEL | 0% | 1 | 25.8 |
population_growth_rate_numeric |
Population growth rate percent | float | SEL | 0% | 1 | 1.32 |
birth_rate_numeric |
Birth rate per 1000 | float | SEL | 0% | 1 | 21.16 |
death_rate_numeric |
Death rate per 1000 | float | SEL | 0% | 1 | 6.8 |
net_migration_rate_numeric |
Net migration per 1000 | float | SEL | 0% | 1 | -1.14 |
urbanization_urban_population_numeric |
Urban population percent | float | SEL | 0% | 1 | 72.9 |
urbanization_rate_of_urbanization_numeric |
Urban growth rate percent | float | SEL | 0% | 1 | 2.47 |
sex_ratio_at_birth_numeric |
Sex ratio at birth | float | SEL | 0% | 1 | 1.03 |
sex_ratio_total_population_numeric |
Sex ratio overall | float | SEL | 0% | 1 | 0.92 |
maternal_mortality_ratio_numeric |
Maternal mortality per 100k | float | SEL | 0% | 1 | 155.0 |
infant_mortality_rate_total_numeric |
Infant mortality per 1000 | float | SEL | 0% | 1 | 27.8 |
life_expectancy_at_birth_total_population_numeric |
Life expectancy | float | SEL | 0% | 1 | 66.4 |
total_fertility_rate_numeric |
Fertility rate | float | SEL | 0% | 1 | 2.73 |
gross_reproduction_rate_numeric |
Gross reproduction rate | float | SEL | 0% | 1 | 1.34 |
physician_density_numeric |
Physicians per 1000 | float | SEL | 0% | 1 | 0.38 |
hospital_bed_density_numeric |
Hospital beds per 1000 | float | SEL | 0% | 1 | 2.2 |
country_code |
Country code | string | SEL | 0% | 1 | BWA |
country_name |
Country name | string | SEL | 0% | 1 | Botswana |
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 | 2,521,534 (2025 est.) |
population_male_text |
population_male_text | string | 0% | 1 | 1,234,898 |
population_female_text |
population_female_text | string | 0% | 1 | 1,286,636 |
age_structure_0_14_years_text |
age_structure_0_14_years_text | string | 0% | 1 | 28.7% (male 355,583/female 348,863) |
age_structure_15_64_years_text |
age_structure_15_64_years_text | string | 0% | 1 | 65.2% (male 759,210/female 837,752) |
age_structure_65_years_and_over_text |
age_structure_65_years_and_over_text | string | 0% | 1 | 6.1% (2024 est.) (male 59,513/female 89,747) |
dependency_ratios_total_dependency_ratio_text |
dependency_ratios_total_dependency_ratio_text | string | 0% | 1 | 60.9 (2025 est.) |
dependency_ratios_youth_dependency_ratio_text |
dependency_ratios_youth_dependency_ratio_text | string | 0% | 1 | 52.1 (2025 est.) |
dependency_ratios_elderly_dependency_ratio_text |
dependency_ratios_elderly_dependency_ratio_text | string | 0% | 1 | 8.8 (2025 est.) |
dependency_ratios_potential_support_ratio_text |
dependency_ratios_potential_support_ratio_text | string | 0% | 1 | 11.4 (2025 est.) |
dependency_ratios_potential_support_ratio_numeric |
dependency_ratios_potential_support_ratio_numeric | float | 0% | 1 | 11.4 |
median_age_total_text |
median_age_total_text | string | 0% | 1 | 25.8 years (2025 est.) |
median_age_male_text |
median_age_male_text | string | 0% | 1 | 26 years |
median_age_male_numeric |
median_age_male_numeric | float | 0% | 1 | 26.0 |
median_age_female_text |
median_age_female_text | string | 0% | 1 | 28.3 years |
median_age_female_numeric |
median_age_female_numeric | float | 0% | 1 | 28.3 |
population_growth_rate_text |
population_growth_rate_text | string | 0% | 1 | 1.32% (2025 est.) |
birth_rate_text |
birth_rate_text | string | 0% | 1 | 21.16 births/1,000 population (2025 est.) |
death_rate_text |
death_rate_text | string | 0% | 1 | 6.8 deaths/1,000 population (2025 est.) |
net_migration_rate_text |
net_migration_rate_text | string | 0% | 1 | -1.14 migrant(s)/1,000 population (2025 est.) |
population_distribution_text |
population_distribution_text | string | 0% | 1 | the population is primarily concentrated in the east,... |
urbanization_urban_population_text |
urbanization_urban_population_text | string | 0% | 1 | 72.9% of total population (2023) |
urbanization_rate_of_urbanization_text |
urbanization_rate_of_urbanization_text | string | 0% | 1 | 2.47% annual rate of change (2020-25 est.) |
major_urban_areas_population_text |
major_urban_areas_population_text | string | 0% | 1 | 269,000 GABORONE (capital) (2018) |
major_urban_areas_population_numeric |
major_urban_areas_population_numeric | float | 0% | 1 | 269000.0 |
sex_ratio_at_birth_text |
sex_ratio_at_birth_text | string | 0% | 1 | 1.03 male(s)/female |
sex_ratio_0_14_years_text |
sex_ratio_0_14_years_text | string | 0% | 1 | 1.02 male(s)/female |
sex_ratio_0_14_years_numeric |
sex_ratio_0_14_years_numeric | float | 0% | 1 | 1.02 |
sex_ratio_15_64_years_text |
sex_ratio_15_64_years_text | string | 0% | 1 | 0.91 male(s)/female |
sex_ratio_15_64_years_numeric |
sex_ratio_15_64_years_numeric | float | 0% | 1 | 0.91 |
| +78 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 | BWA |
country_name |
Country name | string | SEL | 0% | 1 | Botswana |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
composition_religion_christian_pct_synth |
Christian | numeric | CCL | 0% | - | 79.1 |
composition_religion_other_pct_synth |
other | numeric | CCL | 0% | - | 1.4 |
composition_ethnicity_primary_label_synth |
Tswana (or Setswana) | string | CCL | 0% | - | Tswana (or Setswana) |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
religions_text |
religions_text | string | 0% | 1 | Christian 79.1%, Badimo 4.1%, other 1.4% (includes... |
religions_numeric |
religions_numeric | float | 0% | 1 | 79.1 |
source_section |
source_section | string | 0% | 1 | People and Society:religions |
source_profile_path |
source_profile_path | string | 0% | 1 | africa/bc.json |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
composition_religion_badimo_pct_synth |
Badimo | numeric | 0% | - | 4.1 |
composition_religion_none_pct_synth |
none | numeric | 0% | - | 15.2 |
composition_religion_unspecified_pct_synth |
unspecified | numeric | 0% | - | 0.3 |
composition_ethnicity_tswana_or_setswana_pct_synth |
Tswana (or Setswana) | numeric | 0% | - | 79.0 |
composition_ethnicity_kalanga_pct_synth |
Kalanga | numeric | 0% | - | 11.0 |
composition_ethnicity_basarwa_pct_synth |
Basarwa | numeric | 0% | - | 3.0 |
composition_ethnicity_other_pct_synth |
other | numeric | 0% | - | - |
composition_ethnicity_including_kgalagadi_and_people_of_european_ancestry_pct_synth |
including Kgalagadi and people of European ancestry | numeric | 0% | - | 7.0 |
composition_ethnicity_primary_share_pct_synth |
Tswana (or Setswana) | numeric | 0% | - | 79.0 |
| 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 | A2 |
airports_numeric |
Airports count | float | SEL | 0% | 1 | 122.0 |
country_code |
Country code | string | SEL | 0% | 1 | BWA |
country_name |
Country name | string | SEL | 0% | 1 | Botswana |
admin_level |
Admin level | string | SEL | 0% | 1 | national |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
civil_aircraft_registration_country_code_prefix_numeric |
civil_aircraft_registration_country_code_prefix_numeric | float | 0% | 1 | 2.0 |
airports_text |
airports_text | string | 0% | 1 | 122 (2025) |
railways_total_text |
railways_total_text | string | 0% | 1 | 888 km (2014) |
railways_total_numeric |
railways_total_numeric | float | 0% | 1 | 888.0 |
railways_narrow_gauge_text |
railways_narrow_gauge_text | string | 0% | 1 | 888 km (2014) 1.067-m gauge |
railways_narrow_gauge_numeric |
railways_narrow_gauge_numeric | float | 0% | 1 | 888.0 |
source_section |
source_section | string | 0% | 1 | Transportation |
source_profile_path |
source_profile_path | string | 0% | 1 | africa/bc.json |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | BWA, BWA, BWA, BWA, BWA |
ethnic_group_name |
Ethnic group name | string | CCL | 0% | 10 | Tswana, Kalanga, Kgalagadi, San, Herero/Mbanderu |
ethnic_power_status |
Ethnic power status | string | CCL | 0% | 3 | SENIOR PARTNER, JUNIOR PARTNER, POWERLESS, POWERLESS, POWERLESS |
ethnic_population_share |
Ethnic population share | float | CCL | 0% | 8 | 0.57, 0.08, 0.02, 0.02, 0.017 |
ethnic_group_id |
Ethnic group id | float | CCL | 0% | 10 | 57101000, 57102000, 57103000, 57111000, 57104000 |
regional_autonomy |
Regional autonomy | string | CCL | 0% | 1 | false, false, false, false, false |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
year |
year | integer | 0% | 1 | 2021, 2021, 2021, 2021, 2021 |
group_relevance |
group_relevance | string | 0% | 1 | , , , , |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | BW, BW, BW, BW, BW |
admin_level |
Admin level | integer | SEL | 0% | 1 | 1, 1, 1, 1, 1 |
iso3 |
Country code | string | SEL | 0% | 1 | BWA, BWA, BWA, BWA, BWA |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
retail |
retail | float | 0% | 3 | 0.0, -2.11, 16.07, 0.0, 0.0 |
grocery |
grocery | float | 0% | 3 | 0.0, 0.0, 57.54, 0.0, 0.0 |
parks |
parks | float | 0% | 5 | -0.62, 0.0, 63.67, 0.0, 45.9 |
transit |
transit | float | 0% | 4 | -32.73, 0.0, 17.28, 0.0, 0.0 |
workplaces |
workplaces | float | 0% | 9 | -9.16, 23.68, 1.13, -15.03, 10.4 |
residential |
residential | float | 0% | 3 | 0.0, 2.81, 7.92, 0.0, 0.0 |
region |
region | string | 0% | 9 | Chobe, Francistown, Gaborone, Jwaneng District, Kgatleng |
observation_count |
observation_count | integer | 0% | 9 | 836, 883, 974, 447, 949 |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
city_name |
Admin name | string | SEL | 0% | 7 | Gaborone, Molepolole, Francistown, Lobatse, Mahalapye |
country_code |
Country code | string | SEL | 0% | 1 | BWA, BWA, BWA, BWA, BWA |
population |
Population count | integer | SEL | 0% | 7 | 298993, 121562, 116209, 62160, 61469 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
city_id |
city_id | integer | 0% | 7 | 591, 289, 859, 445, 730 |
name_alternates |
name_alternates | string | 100% | - | - |
country_name |
country_name | string | 0% | 1 | Botswana, Botswana, Botswana, Botswana, Botswana |
population_year |
population_year | integer | 0% | 1 | 2025, 2025, 2025, 2025, 2025 |
latitude |
latitude | string | 100% | - | - |
longitude |
longitude | string | 100% | - | - |
region |
region | string | 100% | - | - |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | BWA |
economic_conditions |
Economic conditions | integer | CCL | 0% | 1 | 1 |
living_conditions |
Living conditions | integer | CCL | 0% | 1 | 1 |
employment_situation |
Employment situation | integer | CCL | 0% | 1 | 1 |
food_insecurity |
Food insecurity | integer | CCL | 0% | 1 | 1 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
round |
round | string | 0% | 1 | |
year |
year | string | 0% | 1 | |
region |
region | string | 0% | 1 | |
source |
source | string | 0% | 1 | Afrobarometer |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | BWA |
women_equal_rights |
Women equal rights | integer | CCL | 0% | 1 | 1 |
women_political_leaders |
Women political leaders | integer | CCL | 0% | 1 | 1 |
women_land_rights |
Women land rights | integer | CCL | 0% | 1 | 1 |
domestic_violence_justified |
Domestic violence justified | integer | CCL | 0% | 1 | 1 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
round |
round | string | 0% | 1 | |
year |
year | string | 0% | 1 | |
region |
region | string | 0% | 1 | |
source |
source | string | 0% | 1 | Afrobarometer |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | BWA |
trust_president |
Trust president | integer | CCL | 0% | 1 | 1 |
trust_parliament |
Trust parliament | integer | CCL | 0% | 1 | 1 |
trust_courts |
Trust courts | integer | CCL | 0% | 1 | 1 |
trust_police |
Trust police | integer | CCL | 0% | 1 | 1 |
trust_army |
Trust army | integer | CCL | 0% | 1 | 1 |
corruption_perception |
Corruption perception | integer | CCL | 0% | 1 | 1 |
democracy_satisfaction |
Democracy satisfaction | integer | CCL | 0% | 1 | 1 |
democracy_preference |
Democracy preference | integer | CCL | 0% | 1 | 1 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
round |
round | string | 0% | 1 | |
year |
year | string | 0% | 1 | |
region |
region | string | 0% | 1 | |
source |
source | string | 0% | 1 | Afrobarometer |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | BWA |
emigration_considered |
Emigration considered | integer | CCL | 0% | 1 | 1 |
immigration_attitude |
Immigration attitude | integer | CCL | 0% | 1 | 1 |
foreign_workers_attitude |
Foreign workers attitude | integer | CCL | 0% | 1 | 1 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
round |
round | string | 0% | 1 | |
year |
year | string | 0% | 1 | |
region |
region | string | 0% | 1 | |
source |
source | string | 0% | 1 | Afrobarometer |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | BWA |
trust_relatives |
Trust relatives | integer | CCL | 0% | 1 | 1 |
trust_neighbors |
Trust neighbors | integer | CCL | 0% | 1 | 1 |
trust_other_ethnic |
Trust other ethnic | integer | CCL | 0% | 1 | 1 |
trust_other_religion |
Trust other religion | integer | CCL | 0% | 1 | 1 |
national_identity_vs_ethnic |
National identity vs ethnic | integer | CCL | 0% | 1 | 1 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
round |
round | string | 0% | 1 | |
year |
year | string | 0% | 1 | |
region |
region | string | 0% | 1 | |
source |
source | string | 0% | 1 | Afrobarometer |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
country_code | string | SEL | 0% | 1 | BWA, BWA |
gns_language_code |
gns_language_code | string | CCL | 0% | 2 | eng, ara |
gns_language_name |
gns_language_name | string | CCL | 0% | 2 | English, Arabic |
gns_toponym_count |
gns_toponym_count | integer | CCL | 0% | 2 | 6, 1 |
gns_toponym_share_pct |
gns_toponym_share_pct | float | CCL | 0% | 2 | 85.7143, 14.2857 |
gns_non_roman_toponym_count |
gns_non_roman_toponym_count | integer | CCL | 0% | 1 | 0, 0 |
gns_dominant_script_code |
gns_dominant_script_code | string | CCL | 0% | 1 | , |
gns_dominant_script_name |
gns_dominant_script_name | string | CCL | 0% | 1 | , |
gns_script_count |
gns_script_count | integer | CCL | 0% | 1 | 0, 0 |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
country_code | string | SEL | 0% | 1 | BWA |
admin_level |
admin_level | integer | SEL | 0% | 1 | 0 |
gns_country_name |
gns_country_name | string | SEL | 0% | 1 | Botswana |
gns_language_count |
gns_language_count | integer | CCL | 0% | 1 | 2 |
gns_script_count |
gns_script_count | integer | CCL | 0% | 1 | 0 |
gns_endonym_share_pct |
gns_endonym_share_pct | float | CCL | 0% | 1 | 99.9323 |
gns_non_roman_name_count |
gns_non_roman_name_count | integer | CCL | 0% | 1 | 0 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
gns_name_count |
gns_name_count | integer | 0% | 1 | 4433 |
gns_feature_count |
gns_feature_count | integer | 0% | 1 | 3775 |
gns_endonym_count |
gns_endonym_count | integer | 0% | 1 | 4430 |
gns_exonym_count |
gns_exonym_count | integer | 0% | 1 | 3 |
gns_source_build_date |
gns_source_build_date | string | 0% | 1 | Wed, 05 Aug 2026 |
gns_source_change_date |
gns_source_change_date | string | 0% | 1 | 2026-08-05 |
gns_name_count_populated_places |
gns_name_count_populated_places | integer | 0% | 1 | 1890 |
gns_feature_count_populated_places |
gns_feature_count_populated_places | integer | 0% | 1 | 1710 |
gns_name_count_hydrographic |
gns_name_count_hydrographic | integer | 0% | 1 | 822 |
gns_feature_count_hydrographic |
gns_feature_count_hydrographic | integer | 0% | 1 | 650 |
gns_name_count_hypsographic |
gns_name_count_hypsographic | integer | 0% | 1 | 1019 |
gns_feature_count_hypsographic |
gns_feature_count_hypsographic | integer | 0% | 1 | 842 |
gns_name_count_spot_features |
gns_name_count_spot_features | integer | 0% | 1 | 326 |
gns_feature_count_spot_features |
gns_feature_count_spot_features | integer | 0% | 1 | 253 |
gns_name_count_administrative_regions |
gns_name_count_administrative_regions | integer | 0% | 1 | 55 |
gns_feature_count_administrative_regions |
gns_feature_count_administrative_regions | integer | 0% | 1 | 20 |
gns_name_count_areas_localities |
gns_name_count_areas_localities | integer | 0% | 1 | 321 |
gns_feature_count_areas_localities |
gns_feature_count_areas_localities | integer | 0% | 1 | 300 |
| Field Name | Label | Type | Schema | Nulls | Unique | Samples |
|---|---|---|---|---|---|---|
country_code |
Country code | string | SEL | 0% | 1 | BWA, BWA |
society_id |
Society id | string | CCL | 0% | 2 | Aa1, Aa7 |
society_name |
Society name | string | CCL | 0% | 2 | !Kung, Naron |
language_glottocode |
Language glottocode | string | CCL | 0% | 2 | juho1239, naro1249 |
language_name |
Language name | string | CCL | 0% | 1 | , |
kinship_system |
Kinship system | string | CCL | 0% | 2 | EA001:8; EA002:2; EA003:0; EA004:0; EA005:0, EA001:7;... |
marriage_pattern |
Marriage pattern | string | CCL | 0% | 2 | EA006:2; EA007:8; EA008:7; EA009:2; EA010:9, EA006:3;... |
subsistence_pattern |
Subsistence pattern | string | CCL | 0% | 2 | EA028:1; EA029:1; EA030:1; EA031:1; EA032:3, EA028:1;... |
political_complexity |
Political complexity | string | CCL | 0% | 2 | EA033:1; EA034:3; EA035:2, EA033:1; EA034:2; EA035:NA |
religion_importance |
Religion importance | string | CCL | 0% | 2 | EA034:3; EA112:1, EA034:2; EA112:NA |
residence_pattern |
Residence pattern | string | CCL | 0% | 2 | EA011:2; EA012:2; EA013:9, EA011:2; EA012:12; EA013:3 |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
country_name |
country_name | string | 0% | 1 | Botswana, Botswana |
dataset |
dataset | string | 0% | 1 | EA, EA |
region |
region | string | 0% | 1 | , |
latitude |
latitude | float | 0% | 1 | -20.0, -20.0 |
longitude |
longitude | float | 0% | 2 | 21.0, 24.0 |
assignment_method |
assignment_method | string | 0% | 1 | point_in_polygon, point_in_polygon |
assignment_confidence |
assignment_confidence | string | 0% | 1 | approximate, approximate |
| Field Name | Label | Type | Nulls | Unique | Samples |
|---|---|---|---|---|---|
oc_anti_money_laundering |
oc_anti_money_laundering | numeric | 0% | 1 | - |
oc_arms_trafficking |
oc_arms_trafficking | numeric | 0% | 1 | - |
oc_cannabis_trade |
oc_cannabis_trade | numeric | 0% | 1 | - |
oc_cocaine_trade |
oc_cocaine_trade | numeric | 0% | 1 | - |
oc_criminal_actors |
oc_criminal_actors | numeric | 0% | 1 | - |
oc_criminal_markets |
oc_criminal_markets | numeric | 0% | 1 | - |
oc_criminal_networks |
oc_criminal_networks | numeric | 0% | 1 | - |
oc_criminality |
oc_criminality | numeric | 0% | 1 | - |
oc_cyber_dependent_crimes |
oc_cyber_dependent_crimes | numeric | 0% | 1 | - |
oc_economic_regulatory_capacity |
oc_economic_regulatory_capacity | numeric | 0% | 1 | - |
oc_extortion_and_protection_racketeering |
oc_extortion_and_protection_racketeering | numeric | 0% | 1 | - |
oc_fauna_crimes |
oc_fauna_crimes | numeric | 0% | 1 | - |
oc_financial_crimes |
oc_financial_crimes | numeric | 0% | 1 | - |
oc_flora_crimes |
oc_flora_crimes | numeric | 0% | 1 | - |
oc_foreign_actors |
oc_foreign_actors | numeric | 0% | 1 | - |
oc_government_transparency_and_accountability |
oc_government_transparency_and_accountability | numeric | 0% | 1 | - |
oc_heroin_trade |
oc_heroin_trade | numeric | 0% | 1 | - |
oc_human_smuggling |
oc_human_smuggling | numeric | 0% | 1 | - |
oc_human_trafficking |
oc_human_trafficking | numeric | 0% | 1 | - |
oc_illicit_trade_in_excisable_goods |
oc_illicit_trade_in_excisable_goods | numeric | 0% | 1 | - |
oc_international_cooperation |
oc_international_cooperation | numeric | 0% | 1 | - |
oc_judicial_system_and_detention |
oc_judicial_system_and_detention | numeric | 0% | 1 | - |
oc_law_enforcement |
oc_law_enforcement | numeric | 0% | 1 | - |
oc_mafia_style_groups |
oc_mafia_style_groups | numeric | 0% | 1 | - |
oc_national_policies_and_laws |
oc_national_policies_and_laws | numeric | 0% | 1 | - |
oc_non_renewable_resource_crimes |
oc_non_renewable_resource_crimes | numeric | 0% | 1 | - |
oc_non_state_actors |
oc_non_state_actors | numeric | 0% | 1 | - |
oc_political_leadership_and_governance |
oc_political_leadership_and_governance | numeric | 0% | 1 | - |
oc_prevention |
oc_prevention | numeric | 0% | 1 | - |
oc_private_sector_actors |
oc_private_sector_actors | numeric | 0% | 1 | - |
| +5 more extension fields — download the CSV/Parquet to see them all. | |||||
Which languages name the landscape here, and in which writing systems. A language's toponymic footprint and its speaker population are different measures and often diverge.
| Language | Place names | Share | Script |
|---|---|---|---|
| English (eng) | 6 | 85.7% | — |
| Arabic (ara) | 1 | 14.3% | — |
3,775 distinct features ·
2 languages ·
0 scripts ·
3 conventional English names
Source: NGA GEOnet Names Server
(public domain) · rebuilt Wed, 05 Aug 2026.
Names follow the US/BGN convention.
The data providers this country's datasets are sourced from — each links out to the provider.
| Source | Type | Access |
|---|---|---|
| HDX COD — Population Statistics (OCHA/UNFPA) | international_organization | bulk_download |
| Global Data Lab | academic | api |
| commercial | bulk_download | |
| GI-TOC / ENACT (Global Initiative Against Transnational Organized Crime · ENACT) | academic | bulk_download |
| Afrobarometer | academic | api |
| World Bank Open Data | international_organization | api |
| Ethnic Power Relations Dataset | academic | bulk_download |
| D-PLACE (Database of Places, Language, Culture & Environment) | academic | bulk_download |
| NGA GEOnet Names Server (GNS) | official_government | bulk_download |
| UNHCR Refugee Data Finder (UN High Commissioner for Refugees) | international_organization | api |
| Glottolog Language Catalog | academic | bulk_download |
| GHS Urban Centre Database (Global Human Settlement · EU Joint Research Centre) | international_organization | bulk_download |
| 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.