Botswana

BWA HDX COD — Population Statistics (OCHA/UNFPA) BWA-COD_PS Census Derived Population

565 rows · 3 table(s) · 2023 HDX COD — Population Statistics (OCHA/UNFPA) 0 1 2 3 15 SEL ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

0 Admin 0 — 1 table(s)

BWA Cod Ps - Bwa Codps (admin_0) — 1 rows, 59 columns

Loading data…

Field details — 59 fields (type, nulls, unique, samples)

Standards-Aligned Fields (5)

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

Pending (54) — awaiting mapping

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.

1 Admin 1 — 1 table(s)

BWA Cod Ps - Bwa Codps (admin_1) — 17 rows, 59 columns

Loading data…

Field details — 59 fields (type, nulls, unique, samples)

Standards-Aligned Fields (5)

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

Pending (54) — awaiting mapping

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.

2 Admin 2 — 1 table(s)

BWA Cod Ps - Bwa Codps (admin_2) — 547 rows, 59 columns

Loading data…

Field details — 59 fields (type, nulls, unique, samples)

Standards-Aligned Fields (5)

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

Pending (54) — awaiting mapping

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.

BWA Global Data Lab BWA-GDL Development Indices

374 rows · 1 table(s) · 2023 Global Data Lab 0 1 2 3 9 SEL 2 ext ▶

ⓘ Global Data Lab publishes its own subnational regions, which match national admin units in some countries and group several together in others. The level shown is the nearest administrative tier, not a claim that these are that tier.

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

1 Admin 1 — 1 table(s)

BWA GDL - Subnational Indices — 374 rows, 11 columns

Loading data…

Field details — 11 fields (type, nulls, unique, samples)

Standards-Aligned Fields (9)

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

Extension Fields (2) — supplemental data preserved outside core SEL/CCL schema

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

BWA World Bank Open Data BWA-WORLD_BANK Development Indicators

132 rows · 2 table(s) · 2024 World Bank Open Data 0 1 2 3 19 SEL 4 ext ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

0 Admin 0 — 2 table(s)

BWA World Bank - Development Indicators — 66 rows, 9 columns

Loading data…

Field details — 9 fields (type, nulls, unique, samples)

Standards-Aligned Fields (7)

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

Extension Fields (2) — supplemental data preserved outside core SEL/CCL schema

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

BWA World Bank - Health Indicators — 66 rows, 14 columns

Loading data…

Field details — 14 fields (type, nulls, unique, samples)

Standards-Aligned Fields (12)

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

Extension Fields (2) — supplemental data preserved outside core SEL/CCL schema

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

BWA UNHCR Refugee Data Finder BWA-UNHCR Migration

95 rows · 2 table(s) · 2025 UNHCR Refugee Data Finder 0 1 2 3 12 CCL 36 ext ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

0 Admin 0 — 2 table(s)

BWA UNHCR - Hosted Populations — 58 rows, 24 columns

Loading data…

Field details — 24 fields (type, nulls, unique, samples)

Standards-Aligned Fields (6)

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%	-	-

Extension Fields (18) — supplemental data preserved outside core SEL/CCL schema

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%	-	-

BWA UNHCR - Origin Populations — 37 rows, 24 columns

Loading data…

Field details — 24 fields (type, nulls, unique, samples)

Standards-Aligned Fields (6)

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%	-	-

Extension Fields (18) — supplemental data preserved outside core SEL/CCL schema

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%	-	-

BWA Glottolog Language Catalog BWA-GLOTTOLOG Language

37 rows · 1 table(s) · 2024 Glottolog Language Catalog 0 1 2 3 1 SEL 12 CCL 3 ext ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

0 Admin 0 — 1 table(s)

BWA Glottolog - Languages — 37 rows, 16 columns

Loading data…

Field details — 16 fields (type, nulls, unique, samples)

Standards-Aligned Fields (13)

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

Extension Fields (3) — supplemental data preserved outside core SEL/CCL schema

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	[], [], [], [], []

BWA LandScan Global (ORNL) BWA-LANDSCAN Modeled Population

18 rows · 3 table(s) · 2024 LandScan Global (ORNL) 0 1 2 3 Locality 21 SEL 2 ext ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

0 Admin 0 — 1 table(s)

BWA LandScan - Population Admin0 (admin_0) — 1 rows, 7 columns

Loading data…

Field details — 7 fields (type, nulls, unique, samples)

Standards-Aligned Fields (7)

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

1 Admin 1 — 1 table(s)

BWA LandScan - Population Admin1 (admin_1) — 10 rows, 7 columns

Loading data…

Field details — 7 fields (type, nulls, unique, samples)

Standards-Aligned Fields (7)

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

Locality Locality — 1 table(s)

BWA LandScan - Cities (locality) — 7 rows, 9 columns

Loading data…

Field details — 9 fields (type, nulls, unique, samples)

Standards-Aligned Fields (7)

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

Extension Fields (2) — supplemental data preserved outside core SEL/CCL schema

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

BWA OpenFactBook BWA-OPENFACTBOOK Country Profile

14 rows · 14 table(s) · 2024 OpenFactBook 0 1 2 3 92 SEL 3 CCL 555 ext ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

0 Admin 0 — 14 table(s)

BWA OpenFactBook - Communications — 1 rows, 21 columns

Loading data…

Field details — 22 fields (type, nulls, unique, samples)

Standards-Aligned Fields (8)

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

Extension Fields (14) — supplemental data preserved outside core SEL/CCL schema

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

BWA OpenFactBook - Economy — 1 rows, 149 columns

Loading data…

Field details — 155 fields (type, nulls, unique, samples)

Standards-Aligned Fields (6)

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

Extension Fields (149) — supplemental data preserved outside core SEL/CCL schema

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.

BWA OpenFactBook - Energy — 1 rows, 39 columns

Loading data…

Field details — 39 fields (type, nulls, unique, samples)

Standards-Aligned Fields (4)

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

Extension Fields (35) — supplemental data preserved outside core SEL/CCL schema

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.

BWA OpenFactBook - Environment — 1 rows, 50 columns

Loading data…

Field details — 53 fields (type, nulls, unique, samples)

Standards-Aligned Fields (8)

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

Extension Fields (45) — supplemental data preserved outside core SEL/CCL schema

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.

BWA OpenFactBook - Ethnic Groups — 1 rows, 8 columns

Loading data…

Field details — 9 fields (type, nulls, unique, samples)

Standards-Aligned Fields (3)

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

Extension Fields (6) — supplemental data preserved outside core SEL/CCL schema

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

BWA OpenFactBook - Geography — 1 rows, 55 columns

Loading data…

Field details — 59 fields (type, nulls, unique, samples)

Standards-Aligned Fields (13)

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

Extension Fields (46) — supplemental data preserved outside core SEL/CCL schema

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.

BWA OpenFactBook - Government — 1 rows, 80 columns

Loading data…

Field details — 106 fields (type, nulls, unique, samples)

Standards-Aligned Fields (2)

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

Extension Fields (104) — supplemental data preserved outside core SEL/CCL schema

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.

BWA OpenFactBook - Introduction — 1 rows, 6 columns

Loading data…

Field details — 7 fields (type, nulls, unique, samples)

Standards-Aligned Fields (3)

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

Extension Fields (4) — supplemental data preserved outside core SEL/CCL schema

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

BWA OpenFactBook - Languages — 1 rows, 6 columns

Loading data…

Field details — 7 fields (type, nulls, unique, samples)

Standards-Aligned Fields (3)

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

Extension Fields (4) — supplemental data preserved outside core SEL/CCL schema

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

BWA OpenFactBook - Migration — 1 rows, 9 columns

Loading data…

Field details — 9 fields (type, nulls, unique, samples)

Standards-Aligned Fields (3)

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

Extension Fields (6) — supplemental data preserved outside core SEL/CCL schema

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

BWA OpenFactBook - Military And Security — 1 rows, 21 columns

Loading data…

Field details — 25 fields (type, nulls, unique, samples)

Standards-Aligned Fields (3)

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

Extension Fields (22) — supplemental data preserved outside core SEL/CCL schema

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

BWA OpenFactBook - People And Society — 1 rows, 124 columns

Loading data…

Field details — 136 fields (type, nulls, unique, samples)

Standards-Aligned Fields (28)

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

Extension Fields (108) — supplemental data preserved outside core SEL/CCL schema

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.

BWA OpenFactBook - Religions — 1 rows, 6 columns

Loading data…

Field details — 19 fields (type, nulls, unique, samples)

Standards-Aligned Fields (6)

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)

Extension Fields (4) — supplemental data preserved outside core SEL/CCL schema

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

Pending (9) — awaiting mapping

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

BWA OpenFactBook - Transportation — 1 rows, 12 columns

Loading data…

Field details — 13 fields (type, nulls, unique, samples)

Standards-Aligned Fields (5)

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

Extension Fields (8) — supplemental data preserved outside core SEL/CCL schema

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

BWA Ethnic Power Relations Dataset BWA-EPR Political Ethnicity

10 rows · 1 table(s) · 2021 Ethnic Power Relations Dataset 0 1 2 3 1 SEL 5 CCL 2 ext ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

0 Admin 0 — 1 table(s)

BWA EPR - Groups — 10 rows, 8 columns

Loading data…

Field details — 8 fields (type, nulls, unique, samples)

Standards-Aligned Fields (6)

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

Extension Fields (2) — supplemental data preserved outside core SEL/CCL schema

Field Name	Label	Type	Nulls	Unique	Samples
`year`	year	integer	0%	1	2021, 2021, 2021, 2021, 2021
`group_relevance`	group_relevance	string	0%	1	, , , ,

BWA Google Community Mobility (2020-2022) BWA-GOOGLE-MOBILITY Mobility

9 rows · 1 table(s) · 2022 Google 0 1 2 3 3 SEL 8 ext ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

1 Admin 1 — 1 table(s)

BWA Mobility by Region — 9 rows, 11 columns

Loading data…

Field details — 11 fields (type, nulls, unique, samples)

Standards-Aligned Fields (3)

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

Extension Fields (8) — supplemental data preserved outside core SEL/CCL schema

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

BWA GHS Urban Centre Database (EU JRC) BWA-GHSL_UCDB Modeled Population

7 rows · 1 table(s) · 2025 GHS Urban Centre Database (EU JRC) 0 1 2 3 Locality 3 SEL 7 ext ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

Locality Locality — 1 table(s)

BWA GHS-UCDB - Cities (locality) — 7 rows, 10 columns

Loading data…

Field details — 10 fields (type, nulls, unique, samples)

Standards-Aligned Fields (3)

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

Extension Fields (7) — supplemental data preserved outside core SEL/CCL schema

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%	-	-

BWA Afrobarometer BWA-AFROBAROMETER Attitudes Values

5 rows · 5 table(s) · 2023 Afrobarometer 0 1 2 3 5 SEL 24 CCL 20 ext ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

0 Admin 0 — 5 table(s)

BWA Afrobarometer - Economic Indicators — 1 rows, 9 columns

Loading data…

Field details — 9 fields (type, nulls, unique, samples)

Standards-Aligned Fields (5)

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

Extension Fields (4) — supplemental data preserved outside core SEL/CCL schema

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

BWA Afrobarometer - Gender Indicators — 1 rows, 9 columns

Loading data…

Field details — 9 fields (type, nulls, unique, samples)

Standards-Aligned Fields (5)

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

Extension Fields (4) — supplemental data preserved outside core SEL/CCL schema

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

BWA Afrobarometer - Governance Indicators — 1 rows, 13 columns

Loading data…

Field details — 13 fields (type, nulls, unique, samples)

Standards-Aligned Fields (9)

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

Extension Fields (4) — supplemental data preserved outside core SEL/CCL schema

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

BWA Afrobarometer - Migration Indicators — 1 rows, 8 columns

Loading data…

Field details — 8 fields (type, nulls, unique, samples)

Standards-Aligned Fields (4)

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

Extension Fields (4) — supplemental data preserved outside core SEL/CCL schema

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

BWA Afrobarometer - Social Trust Indicators — 1 rows, 10 columns

Loading data…

Field details — 10 fields (type, nulls, unique, samples)

Standards-Aligned Fields (6)

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

Extension Fields (4) — supplemental data preserved outside core SEL/CCL schema

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

BWA NGA GEOnet Names Server (GNS) BWA-NGA_GNS Language

3 rows · 2 table(s) · 2026 NGA GEOnet Names Server (GNS) 0 1 2 3 4 SEL 12 CCL 18 ext ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

0 Admin 0 — 2 table(s)

BWA Nga Gns - Language — 2 rows, 9 columns

Loading data…

Field details — 9 fields (type, nulls, unique, samples)

Standards-Aligned Fields (9)

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

BWA Nga Gns - Summary — 1 rows, 25 columns

Loading data…

Field details — 25 fields (type, nulls, unique, samples)

Standards-Aligned Fields (7)

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

Extension Fields (18) — supplemental data preserved outside core SEL/CCL schema

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

BWA D-PLACE BWA-DPLACE Ethnographic Societies

2 rows · 1 table(s) · 2024 D-PLACE 0 1 2 3 1 SEL 10 CCL 7 ext ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

0 Admin 0 — 1 table(s)

BWA D-PLACE - Dplace Ea Societies — 2 rows, 18 columns

Loading data…

Field details — 18 fields (type, nulls, unique, samples)

Standards-Aligned Fields (11)

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

Extension Fields (7) — supplemental data preserved outside core SEL/CCL schema

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

BWA Global Organized Crime Index BWA-OCINDEX Crime Index

1 rows · 1 table(s) · 2025 GI-TOC / ENACT 0 1 2 3 13 CCL 22 ext ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

0 Admin 0 — 1 table(s)

BWA Organized Crime Scores 2025 — 1 rows, 35 columns

Loading data…

Field details — 168 fields (type, nulls, unique, samples)

Standards-Aligned Fields (13)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`oc_anti_money_laundering`	oc_anti_money_laundering	numeric	CCL	0%	1	-
`oc_arms_trafficking`	oc_arms_trafficking	numeric	CCL	0%	1	-
`oc_criminal_actors`	oc_criminal_actors	numeric	CCL	0%	1	-
`oc_criminal_markets`	oc_criminal_markets	numeric	CCL	0%	1	-
`oc_criminality`	oc_criminality	numeric	CCL	0%	1	-
`oc_cyber_dependent_crimes`	oc_cyber_dependent_crimes	numeric	CCL	0%	1	-
`oc_financial_crimes`	oc_financial_crimes	numeric	CCL	0%	1	-
`oc_human_smuggling`	oc_human_smuggling	numeric	CCL	0%	1	-
`oc_human_trafficking`	oc_human_trafficking	numeric	CCL	0%	1	-
`oc_judicial_system_and_detention`	oc_judicial_system_and_detention	numeric	CCL	0%	1	-
`oc_law_enforcement`	oc_law_enforcement	numeric	CCL	0%	1	-
`oc_political_leadership_and_governance`	oc_political_leadership_and_governance	numeric	CCL	0%	1	-
`oc_resilience`	oc_resilience	numeric	CCL	0%	1	-

Extension Fields (22) — supplemental data preserved outside core SEL/CCL schema

Field Name	Label	Type	Nulls	Unique	Samples
`oc_cannabis_trade`	oc_cannabis_trade	numeric	0%	1	-
`oc_cocaine_trade`	oc_cocaine_trade	numeric	0%	1	-
`oc_criminal_networks`	oc_criminal_networks	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_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_illicit_trade_in_excisable_goods`	oc_illicit_trade_in_excisable_goods	numeric	0%	1	-
`oc_international_cooperation`	oc_international_cooperation	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_prevention`	oc_prevention	numeric	0%	1	-
`oc_private_sector_actors`	oc_private_sector_actors	numeric	0%	1	-
`oc_state_embedded_actors`	oc_state_embedded_actors	numeric	0%	1	-
`oc_synthetic_drug_trade`	oc_synthetic_drug_trade	numeric	0%	1	-
`oc_territorial_integrity`	oc_territorial_integrity	numeric	0%	1	-
`oc_trade_in_counterfeit_goods`	oc_trade_in_counterfeit_goods	numeric	0%	1	-

Pending (133) — awaiting mapping

Field Name	Label	Type	Nulls	Unique	Samples
`iso3`	iso3	string	0%	1	BWA
`source`	source	string	0%	1	Global Organized Crime Index
`source_url`	source_url	string	0%	1	https://ocindex.net/
`year`	year	integer	0%	1	2025
`license`	license	string	0%	1	Creative Commons (GI-TOC / ENACT)
`oc_anti_money_laundering_rank`	oc_anti_money_laundering_rank	integer	0%	1	47
`oc_anti_money_laundering_2023`	oc_anti_money_laundering_2023	integer	0%	1	5
`oc_anti_money_laundering_2021`	oc_anti_money_laundering_2021	float	0%	1	4.5
`oc_anti_money_laundering_2019`	oc_anti_money_laundering_2019	float	0%	1	5.5
`oc_arms_trafficking_rank`	oc_arms_trafficking_rank	integer	0%	1	148
`oc_arms_trafficking_2023`	oc_arms_trafficking_2023	integer	0%	1	4
`oc_arms_trafficking_2021`	oc_arms_trafficking_2021	integer	0%	1	3
`oc_arms_trafficking_2019`	oc_arms_trafficking_2019	float	0%	1	3.5
`oc_cannabis_trade_rank`	oc_cannabis_trade_rank	integer	0%	1	114
`oc_cannabis_trade_2023`	oc_cannabis_trade_2023	float	0%	1	4.5
`oc_cannabis_trade_2021`	oc_cannabis_trade_2021	integer	0%	1	4
`oc_cannabis_trade_2019`	oc_cannabis_trade_2019	integer	0%	1	4
`oc_cocaine_trade_rank`	oc_cocaine_trade_rank	integer	0%	1	126
`oc_cocaine_trade_2023`	oc_cocaine_trade_2023	float	0%	1	3.5
`oc_cocaine_trade_2021`	oc_cocaine_trade_2021	float	0%	1	3.5
`oc_cocaine_trade_2019`	oc_cocaine_trade_2019	float	0%	1	3.5
`oc_criminal_actors_rank`	oc_criminal_actors_rank	integer	0%	1	147
`oc_criminal_actors_2023`	oc_criminal_actors_2023	float	0%	1	4.3
`oc_criminal_actors_2021`	oc_criminal_actors_2021	float	0%	1	3.63
`oc_criminal_actors_2019`	oc_criminal_actors_2019	float	0%	1	3.38
`oc_criminal_markets_rank`	oc_criminal_markets_rank	integer	0%	1	135
`oc_criminal_markets_2023`	oc_criminal_markets_2023	float	0%	1	4.4
`oc_criminal_markets_2021`	oc_criminal_markets_2021	float	0%	1	3.8
`oc_criminal_markets_2019`	oc_criminal_markets_2019	float	0%	1	3.3
`oc_criminal_networks_rank`	oc_criminal_networks_rank	integer	0%	1	105
+103 more pending fields — download the CSV/Parquet to see them all.

HERA · Human Entity Reference Atlas by Masego Inc

Build a download

Source	Type	Access
HDX COD — Population Statistics (OCHA/UNFPA)	international_organization	bulk_download
Global Data Lab	academic	api
Google	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