Code
library(tidyverse)
library(httr2)
library(httr)
library(jsonlite)
library(WikipediR)
library(glue)
library(knitr)
source("src/wikipedia-tools.R")
source("R/get_wikidata_instances.R")Bolivia Municipality Wikipedia & Wikidata Cleanup Tracker
Overview
This document tracks the state of English Wikipedia pages and Wikidata items for Bolivia’s 340 municipalities. It checks:
- Wikidata completeness: Are all 339 municipalities represented as
instance of: municipality of Bolivia(Q1062710)? - Wikipedia category coverage: Which pages exist in the
Municipalities of Boliviacategory tree? - Expected page existence: For each of 336 expected municipality page titles, does the page exist?
- Wikidata item type: For existing pages not matched to Wikidata municipality items, is the linked Wikidata item actually a province, locality, or something else?
Re-render this document after editing Wikipedia/Wikidata to update all tables.
1. Expected municipality page names
The canonical list of 336 expected Wikipedia page titles was manually constructed from INE’s 340-municipality list (muni_id_lookup_table), applying Wikipedia disambiguation conventions (e.g. “Municipality, Department” for shared names). Four capital-city municipalities use their city page name instead.
This mapping is saved in data/page_dept_map.rds.
Code
page_dept_map <- readRDS("data/page_dept_map.rds")
muni_pages <- page_dept_map$page
message(length(muni_pages), " expected municipality page titles")336 expected municipality page titles2. Query Wikidata for municipality items
Retrieve all Wikidata items that are instance of: municipality of Bolivia (Q1062710), with their English Wikipedia sitelinks.
Code
wd_munis <- get_wikidata_instances(
"Q1062710",
property = c("P131"),
property_names = c("located_in"),
country = "Q750",
languages = c("en", "es"),
limit = 500
)Found 340 instances. Retrieving details in batches of 50... Batch 1/7 (50 items)... Batch 2/7 (50 items)... Batch 3/7 (50 items)... Batch 4/7 (50 items)... Batch 5/7 (50 items)... Batch 6/7 (50 items)... Batch 7/7 (40 items)...Successfully retrieved 340 itemsCode
# Extract English Wikipedia article title from sitelinks
wd_munis <- wd_munis |>
mutate(
en_wiki_title = map_chr(wikipedia_articles, function(arts) {
if (length(arts) == 0) return(NA_character_)
en_art <- arts[str_detect(arts, "^en:")]
if (length(en_art) == 0) return(NA_character_)
str_replace(en_art[1], "^en:\\s*", "")
})
)
message(nrow(wd_munis), " Wikidata items with instance_of = municipality of Bolivia")340 Wikidata items with instance_of = municipality of Bolivia3. Discover Wikipedia category pages
Scrape all article pages listed in the Category:Municipalities of Bolivia tree (top-level + per-department subcategories).
Code
top_cat <- "Category:Municipalities_of_Bolivia"
subcats <- get_subcategories(top_cat)
muni_subcats <- subcats |>
filter(str_detect(title, "^Category:Municipalities"))
# Pages directly in the top-level category
top_pages <- get_category_pages(top_cat)
# Pages in each department subcategory
subcat_pages <- map_dfr(muni_subcats$title, function(cat) {
Sys.sleep(0.3)
get_category_pages(cat) |>
mutate(source_category = cat)
})
all_muni_pages <- bind_rows(
top_pages |> mutate(source_category = top_cat),
subcat_pages
) |>
distinct(title, .keep_all = TRUE) |>
filter(ns == 0)
message(nrow(all_muni_pages), " unique pages in Wikipedia municipality categories")194 unique pages in Wikipedia municipality categoriesCategory page summary
Code
all_muni_pages |>
count(source_category, name = "n_pages") |>
arrange(source_category) |>
kable()| source_category | n_pages |
|---|---|
| Category:Municipalities of Beni Department | 18 |
| Category:Municipalities of Chuquisaca Department | 4 |
| Category:Municipalities of Cochabamba Department | 46 |
| Category:Municipalities of La Paz Department (Bolivia) | 84 |
| Category:Municipalities of Oruro Department | 4 |
| Category:Municipalities of Pando Department | 1 |
| Category:Municipalities of Potosí Department | 26 |
| Category:Municipalities of Santa Cruz Department | 9 |
| Category:Municipalities of Tarija Department | 1 |
| Category:Municipalities_of_Bolivia | 1 |
4. Fetch page metadata
Code
page_info <- get_page_info_batch(all_muni_pages$title)
muni_df <- all_muni_pages |>
select(-pageid) |>
left_join(page_info, by = "title")
message(nrow(muni_df), " pages with metadata")194 pages with metadata5. Compare Wikipedia categories with Wikidata
Code
wp_only <- muni_df |>
filter(!wikidata_qid %in% wd_munis$qid | is.na(wikidata_qid))
wd_only <- wd_munis |>
filter(!qid %in% muni_df$wikidata_qid)
in_both <- muni_df |>
filter(wikidata_qid %in% wd_munis$qid)
comparison_summary <- tribble(
~Category, ~Count,
"Wikipedia category pages", nrow(muni_df),
"Wikidata municipality items", nrow(wd_munis),
"In both", nrow(in_both),
"Wikipedia category only", nrow(wp_only),
"Wikidata only (no category page)", nrow(wd_only)
)
comparison_summary |> kable()| Category | Count |
|---|---|
| Wikipedia category pages | 194 |
| Wikidata municipality items | 340 |
| In both | 191 |
| Wikipedia category only | 3 |
| Wikidata only (no category page) | 149 |
Pages in Wikipedia category but not Wikidata
These are pages categorised as municipalities but whose Wikidata item is not typed as municipality of Bolivia:
Code
wp_only |>
select(title, wikidata_qid, page_length) |>
arrange(title) |>
kable()| title | wikidata_qid | page_length |
|---|---|---|
| Municipalities of Bolivia | Q1062710 | 16033 |
| San Pedro, Santistevan | Q2219897 | 5328 |
| Santa Cruz de la Sierra | Q170688 | 56104 |
Wikidata municipality items without a Wikipedia category page
Code
wd_only |>
select(qid, label_en, label_es, en_wiki_title) |>
arrange(label_en) |>
kable()| qid | label_en | label_es | en_wiki_title |
|---|---|---|---|
| Q1477964 | Acasio | Acasio | NA |
| Q647778 | Andamarca | NA | NA |
| Q647847 | Antequera | Antequera | NA |
| Q1477973 | Arampampa | Arampampa | NA |
| Q721682 | Ascencion de Guarayos Municipality | Ascención de Guarayos | NA |
| Q198360 | Bella Flor | Bella Flor | NA |
| Q647861 | Belén de Andamarca | Belén de Andamarca | NA |
| Q328294 | Bermejo | Bermejo | NA |
| Q198353 | Bolpebra Municipality | Municipio de Bolpebra | NA |
| Q515092 | Boyuibe | Boyuibe | NA |
| Q1001757 | Buena Vista | Buena Vista | NA |
| Q1024796 | Cabezas | Cabezas | NA |
| Q1141966 | Camargo Municipality | NA | NA |
| Q1029614 | Camiri | Camiri (municipio) | NA |
| Q647748 | Caracollo Municipality | NA | NA |
| Q647761 | Carangas | Carangas | NA |
| Q328289 | Caraparí | Caraparí | NA |
| Q1477999 | Caripuyo | Caripuyo | NA |
| Q647865 | Challapata Municipality | NA | NA |
| Q637599 | Chaqui | Chaquí | NA |
| Q598031 | Charagua Municipality | Charagua Pueblo | NA |
| Q647829 | Choquecota | Choquecota | NA |
| Q1952923 | Chua Cocani | Chua Cocani | NA |
| Q1147210 | Ckochas | Ckochas | NA |
| Q198367 | Cobija Municipality | Cobija | NA |
| Q1108206 | Colpa Bélgica | Colpa Bélgica | NA |
| Q1108148 | Comarapa | Comarapa | NA |
| Q285010 | Concepción Municipality | Concepción | NA |
| Q647881 | Corque | Corque | NA |
| Q637643 | Cotagaita Municipality | NA | NA |
| Q603654 | Cotoca | Cotoca | NA |
| Q647771 | Cruz De Machacamarca | NA | NA |
| Q1108252 | Cuatro Cañadas | Cuatro Cañadas | NA |
| Q1107950 | Cuevo Municipality | Municipio de Cuevo | NA |
| Q614715 | Curahuara de Carangas | Curahuara de Carangas | NA |
| Q647796 | El Choro | El Choro | NA |
| Q277520 | El Puente | El Puente | NA |
| Q1108311 | El Puente Municipality | El Puente | NA |
| Q1108171 | El Torno | El Torno | NA |
| Q1142208 | El Villar | El Villar | NA |
| Q647895 | Escara Municipality | Escara | NA |
| Q174806 | Esmeralda | Esmeralda | NA |
| Q1892759 | Eucaliptus Municipality | Municipio de Eucaliptus | NA |
| Q993949 | General Saavedra | General Saavedra | NA |
| Q1108247 | Gutiérrez Municipality | Gutiérrez | NA |
| Q1142195 | Huacareta | Huacareta | NA |
| Q1141996 | Huacaya | Huacaya | NA |
| Q647800 | Huachacalla | NA | NA |
| Q647811 | Huanuni Municipality | Municipio de Huanuni | NA |
| Q2303100 | Huari | Santiago de Huari | NA |
| Q1952982 | Huarina Municipality | Municipio de Huarina | NA |
| Q1952976 | Huatajata Municipality | NA | NA |
| Q2006663 | Huayllamarca | Huayllamarca | NA |
| Q1142203 | Icla | Icla | NA |
| Q1142260 | Incahuasi | Incahuasi | Incahuasi, Bolivia |
| Q1107940 | La Guardia | La Guardia | NA |
| Q647786 | La Rivera Municipality | NA | NA |
| Q1108235 | Lagunillas Municipality | Lagunillas | NA |
| Q647754 | Machacamarca | NA | NA |
| Q1142267 | Macharetí | Macharetí | NA |
| Q1108209 | Mairana | NA | NA |
| Q1153550 | Mineros Municipality | NA | NA |
| Q1142257 | Mojocoya | Mojocoya | NA |
| Q1531921 | Montero municipality | Municipio de Montero | NA |
| Q1107963 | Moro Moro | Moro Moro | NA |
| Q1142273 | Municipality of Las Carreras | Las Carreras | NA |
| Q1108271 | Municipio El Carmen Rivero Tórrez | NA | NA |
| Q198391 | Municipio de Filadelfia | Filadelfia | NA |
| Q198351 | Municipio de Ingavi | Ingavi | NA |
| Q198389 | Municipio de Nueva Esperanza | Nueva Esperanza | NA |
| Q198392 | Municipio de Puerto Gonzalo Moreno | Puerto Gonzalo Moreno | NA |
| Q198355 | Municipio de Puerto Rico | Puerto Rico | NA |
| Q198363 | Municipio de Santa Rosa del Abuná | Santa Rosa del Abuná | NA |
| Q198359 | Municipio de Santos Mercado | Santos Mercado | NA |
| Q198348 | Municipio de Sena | Sena | NA |
| Q198357 | Municipio de Villa Nueva | Villa Nueva | NA |
| Q1953059 | Oruro municipality | Oruro | NA |
| Q328276 | Padcaya | Padcaya | NA |
| Q1142006 | Padilla Municipality | Municipio de Padilla | NA |
| Q1108279 | Pailon Municipality | NA | NA |
| Q647728 | Pampa Aullagas | Pampa Aullagas | NA |
| Q1108240 | Pampa Grande Municipality | NA | NA |
| Q1477914 | Pocoata | Pocoata | NA |
| Q182203 | Poroma | Poroma | NA |
| Q1108169 | Porongo | Porongo (municipio) | NA |
| Q1476470 | Portachuelo Municipality | Municipio de Portachuelo | NA |
| Q918680 | Postrer Valle | Postrer Valle | NA |
| Q1585103 | Presto | Presto | NA |
| Q1108166 | Pucará | Pucará | NA |
| Q1108256 | Puerto Quijarro Municipality | Municipio Puerto Quijarro | NA |
| Q1108295 | Puerto Suarez Municipality | Municipio de Puerto Suarez | NA |
| Q637655 | Puna | Puna | NA |
| Q1108303 | Quirusillas | Quirusillas | NA |
| Q1108292 | Roboré Municipality | Municipio de Roboré | NA |
| Q1478043 | Sabaya | Sabaya | NA |
| Q1477919 | Sacaca Municipality | Municipio de Sacaca | NA |
| Q1108162 | Saipina | Saipina | NA |
| Q647899 | Salinas de Garcí Mendoza Municipality | Salinas de Garcí Mendoza | NA |
| Q1108155 | Samaipata Municipality | Municipio de Samaipata | NA |
| Q1953135 | San Agustín Municipality | Municipio San Agustín | NA |
| Q1108298 | San Antonio de Lomerío | San Antonio de Lomerío | NA |
| Q507108 | San Carlos Municipality | San Carlos | NA |
| Q1953160 | San Ignacio de Moxos Municipality | Municipio de San Ignacio de Moxos | NA |
| Q1531880 | San Javier Municipality | San Javier | NA |
| Q1108177 | San José de Chiquitos municipality | Municipio San José de Chiquitos | NA |
| Q1108226 | San Juan de Yapacaní Municipality | San Juan de Yapacaní | NA |
| Q195218 | San Lorenzo | San Lorenzo | NA |
| Q783480 | San Lucas | NA | NA |
| Q1107968 | San Matias Municipality | NA | NA |
| Q1486932 | San Miguel de Velasco | San Miguel de Velasco | NA |
| Q198394 | San Pablo Municipality | San Pablo | NA |
| Q624522 | San Pedro de Buena Vista | San Pedro de Buena Vista | NA |
| Q106409795 | San Pedro de Macha Municipality | NA | NA |
| Q1953183 | San Pedro de Totora Municipality | San Pedro de Totora | NA |
| Q1108183 | San Ramón | San Ramón | NA |
| Q1107974 | Santa Cruz de la Sierra Municipality | Santa Cruz de la Sierra (municipio) | NA |
| Q1108258 | Santa Rosa del Sara Municipality | Santa Rosa del Sara | NA |
| Q647890 | Santuario de Quillacas | Santuario de Quillacas | NA |
| Q684618 | Soracachi | Soracachi | NA |
| Q1304750 | Sucre Municipality | Sucre (municipio) | NA |
| Q1142253 | Supachuy | Sopachuy | Sopachuy |
| Q637620 | Tacobamba | Tacobamba | NA |
| Q1953206 | Tapacarí | Tapacarí | NA |
| Q1953215 | Tarija Municipality | Municipio de Tarija | NA |
| Q1142233 | Tarvita | Tarvita | NA |
| Q647838 | Todos Santos | Todos Santos | NA |
| Q523242 | Toledo Municipality | Toledo | NA |
| Q633697 | Tomina | Tomina | NA |
| Q624520 | Torotoro | NA | NA |
| Q542442 | Trigal | El Trigal | NA |
| Q328281 | Uriondo Municipality | Uriondo | NA |
| Q647818 | Uru Chipaya | Uru Chipaya | NA |
| Q1108192 | Urubichá | Urubichá | NA |
| Q955703 | Villa Alcalá | Villa Alcalá | NA |
| Q1146801 | Villa Charcas Municipality | NA | NA |
| Q328298 | Villa Montes | Villa Montes | NA |
| Q328285 | Villa San Lorenzo | Villa San Lorenzo | NA |
| Q1953257 | Villa Serrano | NA | NA |
| Q121543 | Villa Vaca Guzmán Municipality | Villa Vaca Guzmán | NA |
| Q1953261 | Warnes Municipality | Municipio de Warnes | NA |
| Q328303 | Yacuíba | Yacuíba | NA |
| Q920327 | Yamparáez | Yamparáez | NA |
| Q1108189 | Yapacani | NA | NA |
| Q1142025 | Yotala | Yotala | Yotala |
| Q328307 | Yunchará | Yunchará | NA |
| Q647918 | Yunguyo del Litoral | Yunguyo del Litoral | NA |
| Q1142243 | Zudáñez Municipality | NA | NA |
| Q586565 | NA | Culpina | NA |
| Q668846 | NA | San Pedro | NA |
6. Check expected page existence
For each of the 336 expected municipality page titles, check whether the page actually exists on English Wikipedia.
Code
check_pages_exist_batch <- function(titles, lang = "en") {
api_url <- paste0("https://", lang, ".wikipedia.org/w/api.php")
batches <- split(titles, ceiling(seq_along(titles) / 50))
results <- list()
for (batch in batches) {
Sys.sleep(0.2)
resp <- httr::GET(api_url, query = list(
action = "query",
titles = paste(batch, collapse = "|"),
format = "json",
redirects = 1
))
json <- fromJSON(content(resp, "text", encoding = "UTF-8"),
simplifyVector = FALSE)
found_titles <- map_chr(json$query$pages, ~ .x$title %||% NA_character_)
missing <- map_lgl(json$query$pages, ~ !is.null(.x$missing))
for (i in seq_along(json$query$pages)) {
results[[length(results) + 1]] <- tibble(
title = found_titles[i],
exists = !missing[i]
)
}
}
bind_rows(results)
}
# Query Wikipedia for all expected page names
existence_raw <- check_pages_exist_batch(muni_pages)
# Match back to original page names (redirects may change titles)
page_existence <- tibble(page = muni_pages) |>
left_join(existence_raw, by = c("page" = "title")) |>
mutate(exists = coalesce(exists, FALSE))Summary
Code
existence_counts <- page_existence |>
count(exists) |>
mutate(status = if_else(exists, "Page exists", "No page")) |>
select(status, n)
existence_counts |> kable()| status | n |
|---|---|
| No page | 152 |
| Page exists | 184 |
Pages that exist
Code
page_existence |>
filter(exists) |>
left_join(page_dept_map, by = "page") |>
select(page, department) |>
arrange(department, page) |>
kable()| page | department |
|---|---|
| Baures Municipality | Beni Department |
| Exaltación Municipality | Beni Department |
| Guayaramerín Municipality | Beni Department |
| Huacaraje Municipality | Beni Department |
| Loreto Municipality, Beni | Beni Department |
| Magdalena Municipality, Beni | Beni Department |
| Puerto Siles Municipality | Beni Department |
| Reyes Municipality | Beni Department |
| Riberalta Municipality | Beni Department |
| Rurrenabaque Municipality | Beni Department |
| San Andrés Municipality, Beni | Beni Department |
| San Borja Municipality | Beni Department |
| San Javier Municipality, Beni | Beni Department |
| San Joaquín Municipality, Beni | Beni Department |
| San Ramón Municipality, Beni | Beni Department |
| Santa Ana Municipality, Beni | Beni Department |
| Santa Rosa Municipality, Beni | Beni Department |
| Trinidad Municipality, Beni | Beni Department |
| Azurduy Municipality | Chuquisaca Department |
| Monteagudo Municipality | Chuquisaca Department |
| Tarabuco Municipality | Chuquisaca Department |
| Tarvita Municipality | Chuquisaca Department |
| Villa Abecia Municipality | Chuquisaca Department |
| Aiquile Municipality | Cochabamba Department |
| Alalay Municipality | Cochabamba Department |
| Anzaldo Municipality | Cochabamba Department |
| Arani Municipality | Cochabamba Department |
| Arbieto Municipality | Cochabamba Department |
| Arque Municipality | Cochabamba Department |
| Ayopaya Municipality | Cochabamba Department |
| Capinota Municipality | Cochabamba Department |
| Chimoré Municipality | Cochabamba Department |
| Cliza Municipality | Cochabamba Department |
| Cocapata Municipality | Cochabamba Department |
| Cochabamba Municipality | Cochabamba Department |
| Colcapirhua Municipality | Cochabamba Department |
| Colomi Municipality | Cochabamba Department |
| Cuchumuela Municipality | Cochabamba Department |
| Entre Ríos Municipality, Cochabamba | Cochabamba Department |
| Mizque Municipality | Cochabamba Department |
| Morochata Municipality | Cochabamba Department |
| Omereque Municipality | Cochabamba Department |
| Pasorapa Municipality | Cochabamba Department |
| Pocona Municipality | Cochabamba Department |
| Pojo Municipality | Cochabamba Department |
| Puerto Villarroel Municipality | Cochabamba Department |
| Punata Municipality | Cochabamba Department |
| Quillacollo Municipality | Cochabamba Department |
| Sacaba Municipality | Cochabamba Department |
| Sacabamba Municipality | Cochabamba Department |
| San Benito Municipality | Cochabamba Department |
| Shinahota Municipality | Cochabamba Department |
| Sicaya Municipality | Cochabamba Department |
| Sipe Sipe Municipality | Cochabamba Department |
| Tacachi Municipality | Cochabamba Department |
| Tacopaya Municipality | Cochabamba Department |
| Tarata Municipality | Cochabamba Department |
| Tiquipaya Municipality | Cochabamba Department |
| Tiraque Municipality | Cochabamba Department |
| Toco Municipality | Cochabamba Department |
| Tolata Municipality | Cochabamba Department |
| Totora Municipality | Cochabamba Department |
| Vacas Municipality | Cochabamba Department |
| Vila Vila Municipality | Cochabamba Department |
| Villa Rivero Municipality | Cochabamba Department |
| Villa Tunari Municipality | Cochabamba Department |
| Vinto Municipality | Cochabamba Department |
| Achacachi Municipality | La Paz Department, Bolivia |
| Achocalla Municipality | La Paz Department, Bolivia |
| Alto Beni Municipality | La Paz Department, Bolivia |
| Ancoraimes Municipality | La Paz Department, Bolivia |
| Apolo Municipality | La Paz Department, Bolivia |
| Aucapata Municipality | La Paz Department, Bolivia |
| Ayata Municipality | La Paz Department, Bolivia |
| Ayo Ayo Municipality | La Paz Department, Bolivia |
| Batallas Municipality | La Paz Department, Bolivia |
| Cairoma Municipality | La Paz Department, Bolivia |
| Cajuata Municipality | La Paz Department, Bolivia |
| Calacoto Municipality | La Paz Department, Bolivia |
| Calamarca Municipality | La Paz Department, Bolivia |
| Caquiaviri Municipality | La Paz Department, Bolivia |
| Caranavi Municipality | La Paz Department, Bolivia |
| Catacora Municipality | La Paz Department, Bolivia |
| Chacarilla Municipality | La Paz Department, Bolivia |
| Charaña Municipality | La Paz Department, Bolivia |
| Chulumani Municipality | La Paz Department, Bolivia |
| Chuma Municipality | La Paz Department, Bolivia |
| Collana Municipality | La Paz Department, Bolivia |
| Colquencha Municipality | La Paz Department, Bolivia |
| Colquiri Municipality | La Paz Department, Bolivia |
| Comanche Municipality | La Paz Department, Bolivia |
| Combaya Municipality | La Paz Department, Bolivia |
| Copacabana Municipality, La Paz | La Paz Department, Bolivia |
| Coripata Municipality | La Paz Department, Bolivia |
| Coro Coro Municipality | La Paz Department, Bolivia |
| Coroico Municipality | La Paz Department, Bolivia |
| Curva Municipality | La Paz Department, Bolivia |
| Desaguadero Municipality | La Paz Department, Bolivia |
| Escoma Municipality | La Paz Department, Bolivia |
| General Juan José Pérez Municipality | La Paz Department, Bolivia |
| Guanay Municipality | La Paz Department, Bolivia |
| Guaqui Municipality | La Paz Department, Bolivia |
| Ichoca Municipality | La Paz Department, Bolivia |
| Inquisivi Municipality | La Paz Department, Bolivia |
| Irupana Municipality | La Paz Department, Bolivia |
| Ixiamas Municipality | La Paz Department, Bolivia |
| Jesús de Machaca Municipality | La Paz Department, Bolivia |
| La Asunta Municipality | La Paz Department, Bolivia |
| La Paz Municipality, Bolivia | La Paz Department, Bolivia |
| Laja Municipality | La Paz Department, Bolivia |
| Licoma Pampa Municipality | La Paz Department, Bolivia |
| Luribay Municipality | La Paz Department, Bolivia |
| Malla Municipality | La Paz Department, Bolivia |
| Mecapaca Municipality | La Paz Department, Bolivia |
| Mocomoco Municipality | La Paz Department, Bolivia |
| Nazacara de Pacajes Municipality | La Paz Department, Bolivia |
| Palca Municipality | La Paz Department, Bolivia |
| Palos Blancos Municipality | La Paz Department, Bolivia |
| Papel Pampa Municipality | La Paz Department, Bolivia |
| Patacamaya Municipality | La Paz Department, Bolivia |
| Pelechuco Municipality | La Paz Department, Bolivia |
| Pucarani Municipality | La Paz Department, Bolivia |
| Puerto Acosta Municipality | La Paz Department, Bolivia |
| Puerto Carabuco Municipality | La Paz Department, Bolivia |
| Puerto Pérez Municipality | La Paz Department, Bolivia |
| Quiabaya Municipality | La Paz Department, Bolivia |
| Quime Municipality | La Paz Department, Bolivia |
| San Andrés de Machaca Municipality | La Paz Department, Bolivia |
| San Buenaventura Municipality, La Paz | La Paz Department, Bolivia |
| San Pedro de Curahuara Municipality | La Paz Department, Bolivia |
| San Pedro de Tiquina Municipality | La Paz Department, Bolivia |
| Santiago de Callapa Municipality | La Paz Department, Bolivia |
| Santiago de Huata Municipality | La Paz Department, Bolivia |
| Santiago de Machaca Municipality | La Paz Department, Bolivia |
| Sapahaqui Municipality | La Paz Department, Bolivia |
| Sica Sica Municipality | La Paz Department, Bolivia |
| Sorata Municipality | La Paz Department, Bolivia |
| Tacacoma Municipality | La Paz Department, Bolivia |
| Taraco Municipality | La Paz Department, Bolivia |
| Tipuani Municipality | La Paz Department, Bolivia |
| Tito Yupanqui Municipality | La Paz Department, Bolivia |
| Tiwanaku Municipality | La Paz Department, Bolivia |
| Umala Municipality | La Paz Department, Bolivia |
| Viacha Municipality | La Paz Department, Bolivia |
| Waldo Ballivián Municipality | La Paz Department, Bolivia |
| Yaco Municipality | La Paz Department, Bolivia |
| Yanacachi Municipality | La Paz Department, Bolivia |
| Coipasa Municipality | Oruro Department |
| Pazña Municipality | Oruro Department |
| Poopó Municipality | Oruro Department |
| Turco Municipality | Oruro Department |
| Porvenir Municipality | Pando Department |
| Atocha Municipality | Potosí Department |
| Betanzos Municipality | Potosí Department |
| Caiza “D” Municipality | Potosí Department |
| Chayanta Municipality | Potosí Department |
| Chuquihuta Municipality | Potosí Department |
| Colcha “K” Municipality | Potosí Department |
| Colquechaca Municipality | Potosí Department |
| Llallagua Municipality | Potosí Department |
| Llica Municipality | Potosí Department |
| Mojinete Municipality | Potosí Department |
| Ocurí Municipality | Potosí Department |
| Porco Municipality | Potosí Department |
| Potosí Municipality | Potosí Department |
| Ravelo Municipality | Potosí Department |
| San Antonio de Esmoruco Municipality | Potosí Department |
| San Pablo de Lípez Municipality | Potosí Department |
| San Pedro de Quemes Municipality | Potosí Department |
| Tahua Municipality | Potosí Department |
| Tinguipaya Municipality | Potosí Department |
| Tomave Municipality | Potosí Department |
| Tupiza Municipality | Potosí Department |
| Uncía Municipality | Potosí Department |
| Urmiri Municipality | Potosí Department |
| Uyuni Municipality | Potosí Department |
| Vitichi Municipality | Potosí Department |
| Yocalla Municipality | Potosí Department |
| El Puente Municipality, Santa Cruz | Santa Cruz Department (Bolivia) |
| San Julián Municipality, Santa Cruz | Santa Cruz Department (Bolivia) |
| San Pedro, Santistevan | Santa Cruz Department (Bolivia) |
| San Rafael Municipality, Santa Cruz | Santa Cruz Department (Bolivia) |
| Vallegrande Municipality | Santa Cruz Department (Bolivia) |
| Entre Ríos Municipality, Tarija | Tarija Department |
Pages that do NOT exist (need to be created)
Code
page_existence |>
filter(!exists) |>
left_join(page_dept_map, by = "page") |>
select(page, department) |>
arrange(department, page) |>
kable()| page | department |
|---|---|
| San Ignacio Municipality, Beni | Beni Department |
| Camargo Municipality, Chuquisaca | Chuquisaca Department |
| Camataqui Municipality | Chuquisaca Department |
| Culpina Municipality | Chuquisaca Department |
| El Villar Municipality | Chuquisaca Department |
| Huacareta Municipality | Chuquisaca Department |
| Huacaya Municipality | Chuquisaca Department |
| Icla Municipality | Chuquisaca Department |
| Incahuasi Municipality | Chuquisaca Department |
| Las Carreras Municipality | Chuquisaca Department |
| Macharetí Municipality | Chuquisaca Department |
| Mojocoya Municipality | Chuquisaca Department |
| Padilla Municipality, Chuquisaca | Chuquisaca Department |
| Poroma Municipality | Chuquisaca Department |
| Presto Municipality | Chuquisaca Department |
| San Lucas Municipality, Chuquisaca | Chuquisaca Department |
| Sopachuy Municipality | Chuquisaca Department |
| Sucre Municipality, Bolivia | Chuquisaca Department |
| Tomina Municipality | Chuquisaca Department |
| Villa Alcalá Municipality | Chuquisaca Department |
| Villa Charcas Municipality | Chuquisaca Department |
| Villa Serrano Municipality | Chuquisaca Department |
| Villa Vaca Guzmán Municipality | Chuquisaca Department |
| Villa Zudañez Municipality | Chuquisaca Department |
| Yamparáez Municipality | Chuquisaca Department |
| Yotala Municipality | Chuquisaca Department |
| Bolívar Municipality, Cochabamba | Cochabamba Department |
| Santivañez Municipality | Cochabamba Department |
| Tapacarí Municipality | Cochabamba Department |
| Chúa Cocani Municipality | La Paz Department, Bolivia |
| El Alto Municipality, La Paz | La Paz Department, Bolivia |
| Huarina Municipality | La Paz Department, Bolivia |
| Huatajata Municipality | La Paz Department, Bolivia |
| Humanata Municipality | La Paz Department, Bolivia |
| Andamarca Municipality | Oruro Department |
| Antequera Municipality | Oruro Department |
| Belén de Andamarca Municipality | Oruro Department |
| Caracollo Municipality | Oruro Department |
| Carangas Municipality | Oruro Department |
| Challapata Municipality | Oruro Department |
| Chipaya Municipality | Oruro Department |
| Choquecota Municipality | Oruro Department |
| Corque Municipality | Oruro Department |
| Cruz de Machacamarca Municipality | Oruro Department |
| Curahuara de Carangas Municipality | Oruro Department |
| El Choro Municipality | Oruro Department |
| Escara Municipality | Oruro Department |
| Esmeralda Municipality | Oruro Department |
| Eucaliptus Municipality | Oruro Department |
| Huachacalla Municipality | Oruro Department |
| Huanuni Municipality | Oruro Department |
| Huayllamarca Municipality | Oruro Department |
| La Rivera Municipality | Oruro Department |
| Machacamarca Municipality | Oruro Department |
| Oruro Municipality | Oruro Department |
| Pampa Aullagas Municipality | Oruro Department |
| Sabaya Municipality | Oruro Department |
| Salinas de Garci Mendoza Municipality | Oruro Department |
| Santiago de Huari Municipality | Oruro Department |
| Santuario de Quillacas Municipality | Oruro Department |
| Todos Santos Municipality | Oruro Department |
| Toledo Municipality, Oruro | Oruro Department |
| Totora Municipality, Oruro | Oruro Department |
| Yunguyo del Litoral Municipality | Oruro Department |
| Bella Flor Municipality | Pando Department |
| Bolpebra Municipality | Pando Department |
| Cobija Municipality | Pando Department |
| Filadelfia Municipality | Pando Department |
| Ingavi Municipality | Pando Department |
| Nueva Esperanza Municipality | Pando Department |
| Puerto Gonzalo Moreno Municipality | Pando Department |
| Puerto Rico Municipality | Pando Department |
| San Lorenzo Municipality, Pando | Pando Department |
| San Pedro Municipality, Pando | Pando Department |
| Santa Rosa del Abuná Municipality | Pando Department |
| Santos Mercado Municipality | Pando Department |
| Sena Municipality | Pando Department |
| Villa Nueva Municipality | Pando Department |
| Acasio Municipality | Potosí Department |
| Arampampa Municipality | Potosí Department |
| Caripuyo Municipality | Potosí Department |
| Chaquí Municipality | Potosí Department |
| Chochas Municipality | Potosí Department |
| Cotagaita Municipality | Potosí Department |
| Pocoata Municipality | Potosí Department |
| Puna Municipality | Potosí Department |
| Sacaca Municipality | Potosí Department |
| San Agustín Municipality | Potosí Department |
| San Pedro de Buena Vista Municipality | Potosí Department |
| Tacobamba Municipality | Potosí Department |
| Toro Toro Municipality | Potosí Department |
| Villazón Municipality | Potosí Department |
| Ascensión de Guarayos Municipality | Santa Cruz Department (Bolivia) |
| Ayacucho Municipality, Santa Cruz | Santa Cruz Department (Bolivia) |
| Boyuibe Municipality | Santa Cruz Department (Bolivia) |
| Buena Vista Municipality | Santa Cruz Department (Bolivia) |
| Cabezas Municipality | Santa Cruz Department (Bolivia) |
| Camiri Municipality | Santa Cruz Department (Bolivia) |
| Charagua Municipality | Santa Cruz Department (Bolivia) |
| Colpa Bélgica Municipality | Santa Cruz Department (Bolivia) |
| Comarapa Municipality | Santa Cruz Department (Bolivia) |
| Concepción Municipality | Santa Cruz Department (Bolivia) |
| Cotoca Municipality | Santa Cruz Department (Bolivia) |
| Cuatro Cañadas Municipality | Santa Cruz Department (Bolivia) |
| Cuevo Municipality | Santa Cruz Department (Bolivia) |
| El Carmen Rivero Tórrez Municipality | Santa Cruz Department (Bolivia) |
| El Torno Municipality | Santa Cruz Department (Bolivia) |
| Fernández Alonso Municipality | Santa Cruz Department (Bolivia) |
| General Saavedra Municipality | Santa Cruz Department (Bolivia) |
| Gutiérrez Municipality | Santa Cruz Department (Bolivia) |
| La Guardia Municipality | Santa Cruz Department (Bolivia) |
| Lagunillas Municipality, Santa Cruz | Santa Cruz Department (Bolivia) |
| Mairana Municipality | Santa Cruz Department (Bolivia) |
| Mineros Municipality | Santa Cruz Department (Bolivia) |
| Montero Municipality | Santa Cruz Department (Bolivia) |
| Moro Moro Municipality | Santa Cruz Department (Bolivia) |
| Okinawa Municipality | Santa Cruz Department (Bolivia) |
| Pailón Municipality | Santa Cruz Department (Bolivia) |
| Pampa Grande Municipality | Santa Cruz Department (Bolivia) |
| Portachuelo Municipality | Santa Cruz Department (Bolivia) |
| Postrer Valle Municipality | Santa Cruz Department (Bolivia) |
| Pucara Municipality | Santa Cruz Department (Bolivia) |
| Puerto Quijarro Municipality | Santa Cruz Department (Bolivia) |
| Puerto Suarez Municipality | Santa Cruz Department (Bolivia) |
| Quirusillas Municipality | Santa Cruz Department (Bolivia) |
| Roboré Municipality | Santa Cruz Department (Bolivia) |
| Saipina Municipality | Santa Cruz Department (Bolivia) |
| Samaipata Municipality | Santa Cruz Department (Bolivia) |
| San Antonio del Lomerío Municipality | Santa Cruz Department (Bolivia) |
| San Carlos Municipality, Santa Cruz | Santa Cruz Department (Bolivia) |
| San Ignacio Municipality, Santa Cruz | Santa Cruz Department (Bolivia) |
| San Javier Municipality, Santa Cruz | Santa Cruz Department (Bolivia) |
| San José Municipality, Santa Cruz | Santa Cruz Department (Bolivia) |
| San Matías Municipality | Santa Cruz Department (Bolivia) |
| San Miguel Municipality | Santa Cruz Department (Bolivia) |
| San Ramón Municipality, Santa Cruz | Santa Cruz Department (Bolivia) |
| Santa Rosa del Sara Municipality | Santa Cruz Department (Bolivia) |
| Santa_Cruz_de_la_Sierra | Santa Cruz Department (Bolivia) |
| Trigal Municipality | Santa Cruz Department (Bolivia) |
| Urubichá Municipality | Santa Cruz Department (Bolivia) |
| Warnes Municipality | Santa Cruz Department (Bolivia) |
| Yapacaní Municipality | Santa Cruz Department (Bolivia) |
| Bermejo Municipality | Tarija Department |
| Caraparí Municipality | Tarija Department |
| El Puente Municipality, Tarija | Tarija Department |
| Padcaya Municipality | Tarija Department |
| San Lorenzo Municipality, Tarija | Tarija Department |
| Tarija Municipality | Tarija Department |
| Uriondo Municipality | Tarija Department |
| Villamontes Municipality | Tarija Department |
| Yacuiba Municipality | Tarija Department |
| Yunchará Municipality | Tarija Department |
7. Classify existing pages by Wikidata item type
Some existing Wikipedia pages may be linked to a Wikidata item that represents a province or locality rather than a municipality. These need new dedicated municipality pages (or Wikidata corrections).
We check this for existing pages that were not matched to the Wikidata municipality of Bolivia query.
Code
existing_pages_df <- page_existence |> filter(exists)
# Pages already matched to a proper Wikidata municipality item
matched_to_wd <- existing_pages_df |>
inner_join(wd_munis, by = c("page" = "en_wiki_title"))
# Pages that exist but aren't matched
existing_not_in_wd <- existing_pages_df |>
anti_join(wd_munis, by = c("page" = "en_wiki_title"))
message(nrow(existing_not_in_wd),
" existing pages not matched to a Wikidata municipality item")2 existing pages not matched to a Wikidata municipality itemCode
# Get Wikidata QIDs for unmatched pages via Wikipedia API
get_wikidata_qids <- function(titles) {
resp <- request("https://en.wikipedia.org/w/api.php") |>
req_url_query(
action = "query",
titles = paste(titles, collapse = "|"),
prop = "pageprops",
ppprop = "wikibase_item",
format = "json",
redirects = 1
) |>
req_perform() |>
resp_body_json()
page_data <- resp$query$pages
tibble(
pageid = map_int(page_data, ~ as.integer(.x$pageid %||% NA)),
title = map_chr(page_data, ~ .x$title %||% NA_character_),
qid = map_chr(page_data, ~ .x$pageprops$wikibase_item %||% NA_character_)
)
}
qid_results <- get_wikidata_qids(existing_not_in_wd$page)Code
# Query Wikidata for instance_of (P31) for each QID
get_instance_of <- function(qids) {
qid_values <- paste(paste0("wd:", qids), collapse = " ")
query <- glue('
SELECT ?item ?itemLabel ?instanceOf ?instanceOfLabel WHERE {{
VALUES ?item {{ {qid_values} }}
?item wdt:P31 ?instanceOf .
SERVICE wikibase:label {{ bd:serviceParam wikibase:language "en". }}
}}
')
resp <- request("https://query.wikidata.org/sparql") |>
req_url_query(query = query, format = "json") |>
req_headers(`User-Agent` = "WikiGraph/1.0 (research project)") |>
req_perform() |>
resp_body_json()
bindings <- resp$results$bindings
tibble(
qid = map_chr(bindings, ~ sub("http://www.wikidata.org/entity/", "",
.x$item$value)),
item_label = map_chr(bindings, ~ .x$itemLabel$value),
instance_of_qid = map_chr(bindings, ~ sub("http://www.wikidata.org/entity/", "",
.x$instanceOf$value)),
instance_of_label = map_chr(bindings, ~ .x$instanceOfLabel$value)
)
}
valid_qids <- qid_results$qid[!is.na(qid_results$qid)]
instance_data <- get_instance_of(valid_qids)Code
page_categories <- qid_results |>
left_join(
instance_data |>
group_by(qid) |>
summarise(
all_types = paste(instance_of_label, collapse = "; "),
is_municipality = any(instance_of_qid == "Q1062710"),
is_province = any(instance_of_qid == "Q1062593"),
is_locality = any(instance_of_qid %in% c(
"Q515", "Q532", "Q486972", "Q3957",
"Q1549591", "Q200250", "Q51929311", "Q5712544"
)),
.groups = "drop"
),
by = "qid"
) |>
mutate(
category = case_when(
is_municipality ~ "municipality (OK)",
is_province ~ "province",
is_locality ~ "locality",
TRUE ~ "other/unknown"
)
)Summary by Wikidata item type
Code
page_categories |>
count(category, name = "n_pages") |>
arrange(desc(n_pages)) |>
kable()| category | n_pages |
|---|---|
| locality | 1 |
| other/unknown | 1 |
Province items (page redirects to province article)
These existing page titles redirect to a Wikidata item typed as province of Bolivia. A new municipality page and Wikidata item are needed.
Code
page_categories |>
filter(category == "province") |>
select(
`Expected page` = title,
`Redirects to QID` = qid,
`Wikidata types` = all_types
) |>
kable()| Expected page | Redirects to QID | Wikidata types |
|---|
Locality items (page is about the city/town, not the municipality)
These existing page titles link to a Wikidata item for the settlement rather than the municipality. A new municipality page is needed.
Code
page_categories |>
filter(category == "locality") |>
select(
`Expected page` = title,
`Current QID` = qid,
`Wikidata types` = all_types
) |>
kable()| Expected page | Current QID | Wikidata types |
|---|---|---|
| San Pedro, Santistevan | Q2219897 | town |
Title-mismatch municipalities (already correct in Wikidata)
These pages exist and are properly typed as municipalities in Wikidata but weren’t matched due to title differences between the expected page name and the actual Wikidata English label.
Code
page_categories |>
filter(category == "municipality (OK)") |>
left_join(existing_not_in_wd |> select(page),
by = c("title" = "page")) |>
select(
`Expected page name` = title,
QID = qid
) |>
kable()| Expected page name | QID |
|---|
8. Combined action list
Municipalities needing new Wikipedia pages
This combines (a) expected pages that don’t exist at all with (b) pages that exist but are linked to the wrong Wikidata item type.
Code
# Pages that don't exist
no_page <- page_existence |>
filter(!exists) |>
left_join(page_dept_map, by = "page") |>
mutate(reason = "No page exists")
# Pages that exist but redirect to province or locality
wrong_type <- page_categories |>
filter(category %in% c("province", "locality")) |>
left_join(
existing_not_in_wd |>
left_join(page_dept_map, by = "page"),
by = c("title" = "page")
) |>
transmute(
page = title,
department,
reason = glue("Existing page is {category} ({qid})")
)
action_list <- bind_rows(no_page |> select(page, department, reason),
wrong_type) |>
arrange(department, page)
message(nrow(action_list), " municipalities need new or corrected Wikipedia pages")153 municipalities need new or corrected Wikipedia pagesCode
action_list |>
select(Page = page, Department = department, Reason = reason) |>
kable()| Page | Department | Reason |
|---|---|---|
| San Ignacio Municipality, Beni | Beni Department | No page exists |
| Camargo Municipality, Chuquisaca | Chuquisaca Department | No page exists |
| Camataqui Municipality | Chuquisaca Department | No page exists |
| Culpina Municipality | Chuquisaca Department | No page exists |
| El Villar Municipality | Chuquisaca Department | No page exists |
| Huacareta Municipality | Chuquisaca Department | No page exists |
| Huacaya Municipality | Chuquisaca Department | No page exists |
| Icla Municipality | Chuquisaca Department | No page exists |
| Incahuasi Municipality | Chuquisaca Department | No page exists |
| Las Carreras Municipality | Chuquisaca Department | No page exists |
| Macharetí Municipality | Chuquisaca Department | No page exists |
| Mojocoya Municipality | Chuquisaca Department | No page exists |
| Padilla Municipality, Chuquisaca | Chuquisaca Department | No page exists |
| Poroma Municipality | Chuquisaca Department | No page exists |
| Presto Municipality | Chuquisaca Department | No page exists |
| San Lucas Municipality, Chuquisaca | Chuquisaca Department | No page exists |
| Sopachuy Municipality | Chuquisaca Department | No page exists |
| Sucre Municipality, Bolivia | Chuquisaca Department | No page exists |
| Tomina Municipality | Chuquisaca Department | No page exists |
| Villa Alcalá Municipality | Chuquisaca Department | No page exists |
| Villa Charcas Municipality | Chuquisaca Department | No page exists |
| Villa Serrano Municipality | Chuquisaca Department | No page exists |
| Villa Vaca Guzmán Municipality | Chuquisaca Department | No page exists |
| Villa Zudañez Municipality | Chuquisaca Department | No page exists |
| Yamparáez Municipality | Chuquisaca Department | No page exists |
| Yotala Municipality | Chuquisaca Department | No page exists |
| Bolívar Municipality, Cochabamba | Cochabamba Department | No page exists |
| Santivañez Municipality | Cochabamba Department | No page exists |
| Tapacarí Municipality | Cochabamba Department | No page exists |
| Chúa Cocani Municipality | La Paz Department, Bolivia | No page exists |
| El Alto Municipality, La Paz | La Paz Department, Bolivia | No page exists |
| Huarina Municipality | La Paz Department, Bolivia | No page exists |
| Huatajata Municipality | La Paz Department, Bolivia | No page exists |
| Humanata Municipality | La Paz Department, Bolivia | No page exists |
| Andamarca Municipality | Oruro Department | No page exists |
| Antequera Municipality | Oruro Department | No page exists |
| Belén de Andamarca Municipality | Oruro Department | No page exists |
| Caracollo Municipality | Oruro Department | No page exists |
| Carangas Municipality | Oruro Department | No page exists |
| Challapata Municipality | Oruro Department | No page exists |
| Chipaya Municipality | Oruro Department | No page exists |
| Choquecota Municipality | Oruro Department | No page exists |
| Corque Municipality | Oruro Department | No page exists |
| Cruz de Machacamarca Municipality | Oruro Department | No page exists |
| Curahuara de Carangas Municipality | Oruro Department | No page exists |
| El Choro Municipality | Oruro Department | No page exists |
| Escara Municipality | Oruro Department | No page exists |
| Esmeralda Municipality | Oruro Department | No page exists |
| Eucaliptus Municipality | Oruro Department | No page exists |
| Huachacalla Municipality | Oruro Department | No page exists |
| Huanuni Municipality | Oruro Department | No page exists |
| Huayllamarca Municipality | Oruro Department | No page exists |
| La Rivera Municipality | Oruro Department | No page exists |
| Machacamarca Municipality | Oruro Department | No page exists |
| Oruro Municipality | Oruro Department | No page exists |
| Pampa Aullagas Municipality | Oruro Department | No page exists |
| Sabaya Municipality | Oruro Department | No page exists |
| Salinas de Garci Mendoza Municipality | Oruro Department | No page exists |
| Santiago de Huari Municipality | Oruro Department | No page exists |
| Santuario de Quillacas Municipality | Oruro Department | No page exists |
| Todos Santos Municipality | Oruro Department | No page exists |
| Toledo Municipality, Oruro | Oruro Department | No page exists |
| Totora Municipality, Oruro | Oruro Department | No page exists |
| Yunguyo del Litoral Municipality | Oruro Department | No page exists |
| Bella Flor Municipality | Pando Department | No page exists |
| Bolpebra Municipality | Pando Department | No page exists |
| Cobija Municipality | Pando Department | No page exists |
| Filadelfia Municipality | Pando Department | No page exists |
| Ingavi Municipality | Pando Department | No page exists |
| Nueva Esperanza Municipality | Pando Department | No page exists |
| Puerto Gonzalo Moreno Municipality | Pando Department | No page exists |
| Puerto Rico Municipality | Pando Department | No page exists |
| San Lorenzo Municipality, Pando | Pando Department | No page exists |
| San Pedro Municipality, Pando | Pando Department | No page exists |
| Santa Rosa del Abuná Municipality | Pando Department | No page exists |
| Santos Mercado Municipality | Pando Department | No page exists |
| Sena Municipality | Pando Department | No page exists |
| Villa Nueva Municipality | Pando Department | No page exists |
| Acasio Municipality | Potosí Department | No page exists |
| Arampampa Municipality | Potosí Department | No page exists |
| Caripuyo Municipality | Potosí Department | No page exists |
| Chaquí Municipality | Potosí Department | No page exists |
| Chochas Municipality | Potosí Department | No page exists |
| Cotagaita Municipality | Potosí Department | No page exists |
| Pocoata Municipality | Potosí Department | No page exists |
| Puna Municipality | Potosí Department | No page exists |
| Sacaca Municipality | Potosí Department | No page exists |
| San Agustín Municipality | Potosí Department | No page exists |
| San Pedro de Buena Vista Municipality | Potosí Department | No page exists |
| Tacobamba Municipality | Potosí Department | No page exists |
| Toro Toro Municipality | Potosí Department | No page exists |
| Villazón Municipality | Potosí Department | No page exists |
| Ascensión de Guarayos Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Ayacucho Municipality, Santa Cruz | Santa Cruz Department (Bolivia) | No page exists |
| Boyuibe Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Buena Vista Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Cabezas Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Camiri Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Charagua Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Colpa Bélgica Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Comarapa Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Concepción Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Cotoca Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Cuatro Cañadas Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Cuevo Municipality | Santa Cruz Department (Bolivia) | No page exists |
| El Carmen Rivero Tórrez Municipality | Santa Cruz Department (Bolivia) | No page exists |
| El Torno Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Fernández Alonso Municipality | Santa Cruz Department (Bolivia) | No page exists |
| General Saavedra Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Gutiérrez Municipality | Santa Cruz Department (Bolivia) | No page exists |
| La Guardia Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Lagunillas Municipality, Santa Cruz | Santa Cruz Department (Bolivia) | No page exists |
| Mairana Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Mineros Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Montero Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Moro Moro Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Okinawa Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Pailón Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Pampa Grande Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Portachuelo Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Postrer Valle Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Pucara Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Puerto Quijarro Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Puerto Suarez Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Quirusillas Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Roboré Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Saipina Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Samaipata Municipality | Santa Cruz Department (Bolivia) | No page exists |
| San Antonio del Lomerío Municipality | Santa Cruz Department (Bolivia) | No page exists |
| San Carlos Municipality, Santa Cruz | Santa Cruz Department (Bolivia) | No page exists |
| San Ignacio Municipality, Santa Cruz | Santa Cruz Department (Bolivia) | No page exists |
| San Javier Municipality, Santa Cruz | Santa Cruz Department (Bolivia) | No page exists |
| San José Municipality, Santa Cruz | Santa Cruz Department (Bolivia) | No page exists |
| San Matías Municipality | Santa Cruz Department (Bolivia) | No page exists |
| San Miguel Municipality | Santa Cruz Department (Bolivia) | No page exists |
| San Pedro, Santistevan | Santa Cruz Department (Bolivia) | Existing page is locality (Q2219897) |
| San Ramón Municipality, Santa Cruz | Santa Cruz Department (Bolivia) | No page exists |
| Santa Rosa del Sara Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Santa_Cruz_de_la_Sierra | Santa Cruz Department (Bolivia) | No page exists |
| Trigal Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Urubichá Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Warnes Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Yapacaní Municipality | Santa Cruz Department (Bolivia) | No page exists |
| Bermejo Municipality | Tarija Department | No page exists |
| Caraparí Municipality | Tarija Department | No page exists |
| El Puente Municipality, Tarija | Tarija Department | No page exists |
| Padcaya Municipality | Tarija Department | No page exists |
| San Lorenzo Municipality, Tarija | Tarija Department | No page exists |
| Tarija Municipality | Tarija Department | No page exists |
| Uriondo Municipality | Tarija Department | No page exists |
| Villamontes Municipality | Tarija Department | No page exists |
| Yacuiba Municipality | Tarija Department | No page exists |
| Yunchará Municipality | Tarija Department | No page exists |
Summary by department
Code
dept_summary <- page_dept_map |>
left_join(page_existence, by = "page") |>
left_join(
page_categories |> select(title, category),
by = c("page" = "title")
) |>
mutate(
status = case_when(
!exists ~ "No page",
category == "province" ~ "Redirects to province",
category == "locality" ~ "Links to locality",
TRUE ~ "OK"
)
) |>
count(department, status) |>
pivot_wider(names_from = status, values_from = n, values_fill = 0)
dept_summary |> kable()| department | No page | OK | Links to locality |
|---|---|---|---|
| Beni Department | 1 | 18 | 0 |
| Chuquisaca Department | 25 | 5 | 0 |
| Cochabamba Department | 3 | 44 | 0 |
| La Paz Department, Bolivia | 5 | 80 | 0 |
| Oruro Department | 30 | 4 | 0 |
| Pando Department | 14 | 1 | 0 |
| Potosí Department | 14 | 26 | 0 |
| Santa Cruz Department (Bolivia) | 50 | 4 | 1 |
| Tarija Department | 10 | 1 | 0 |