User:Owenpatel/sandbox/countries/Mexico/Cities/cities outline data

List of Municipalities

Manually update list

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images | Recent changes | Query: SELECT ?item ?headofgov (GROUP_CONCAT(?headofgovinstanceof; SEPARATOR = "<br />") AS ?hoginstancelist) ?council ?member (GROUP_CONCAT(?memberinstanceof; SEPARATOR = "<br />") AS ?memberinstancelist) ?numberconstituencies (COUNT(?constituency) AS ?countconstituencies) (GROUP_CONCAT(?constituencyLab; SEPARATOR = "<br />") AS ?constituencyList) ?constype WHERE { VALUES ?item {wd:Q12348369 wd:Q9022143 wd:Q2557122 wd:Q2143868 wd:Q3313478 wd:Q6905368 wd:Q7258412 wd:Q2360428 wd:Q15121208} OPTIONAL {?item wdt:P1313 ?headofgov . ?headofgov wdt:P31 ?headofgovinstanceof MINUS { ?headofgov wdt:P576 [] } } OPTIONAL {?item wdt:P194 ?council OPTIONAL { ?council wdt:P4253 ?numberconstituencies } OPTIONAL {?member wdt:P361 ?council . ?member wdt:P279 wd:Q708492 . ?member wdt:P31 ?memberinstanceof MINUS {?member wdt:P576 [] } } OPTIONAL { ?statement ps:P279 wd:Q192611 ; pq:P642 ?council. ?constype p:P279 ?statement . ?constituency wdt:P31/wdt:P279* ?constype ; rdfs:label ?constituencyLab . FILTER(lang(?constituencyLab) = 'en') MINUS { ?constituency wdt:P576 [] } } MINUS { ?council wdt:P576 [] } } MINUS { ?item wdt:P576 [] } MINUS { ?item wdt:P31/wdt:P279* wd:Q10864048 } } GROUP BY ?item ?headofgov ?headofgovinstanceof ?council ?member ?memberinstanceof ?numberconstituencies ?constype ORDER BY ?item ?constituency

?item	label/en	label/es	Population	Head of Government position	Head of Gov position is instance of	Head of Government (preferred value from WD)	?council	?member	Member position is instance of	?numberconstituencies	?countconstituencies	?constituencyList	?constype
Ecatepec de Morelos	Ecatepec de Morelos	Ecatepec de Morelos	1929926	Municipal President of Ecatepec de Morelos	http://www.wikidata.org/entity/Q294414		Town Hall of Ecatepec	alderman of the Honorable Town Hall of Ecatepec de Morelos	http://www.wikidata.org/entity/Q4164871	0	0
Guadalajara Municipality	Guadalajara Municipality	Guadalajara Municipality		Municipal President of Guadalajara	http://www.wikidata.org/entity/Q294414		Town Hall of Guadalajara	alderman of the Honorable City Council of Guadalajara	http://www.wikidata.org/entity/Q4164871	0	0
Juárez Municipality	Juárez Municipality	Municipio de Juárez	1391180	Municipal president of Juárez	http://www.wikidata.org/entity/Q294414		Town Hall of Ciudad Juarez	alderman of the Honorable City Council of Ciudad Juarez	http://www.wikidata.org/entity/Q4164871	0	0
León Municipality	León Municipality	León	1436480	Municipal President of León de los Aldama	http://www.wikidata.org/entity/Q294414		Leon City Council	alderman of the Honorable City Council of Leon	http://www.wikidata.org/entity/Q4164871	0	0
Monterrey Municipality	Monterrey Municipality	Monterrey Municipality	4520329	Municipal president of Monterrey	http://www.wikidata.org/entity/Q294414	Adrián de la Garza	Town Hall of Monterrey	alderman of the Honorable City Council of Monterrey	http://www.wikidata.org/entity/Q4164871	0	0
Nezahualcóyotl Municipality	Nezahualcóyotl Municipality	Nezahualcóyotl	1110565	Municipal President of Nezahualcóyotl	http://www.wikidata.org/entity/Q294414		Town Hall of the City of Nezahualcóyotl	alderman of the Honorable City Council of Nezahualcoyotl	http://www.wikidata.org/entity/Q4164871	0	0
Puebla	Puebla	Puebla (municipio)	1576259	Municipal president of Puebla	http://www.wikidata.org/entity/Q294414	Claudia Rivera Vivanco GM	Town Hall of Puebla	alderman of the Honorable City Council of Puebla	http://www.wikidata.org/entity/Q4164871	0	0
Tijuana	Tijuana	municipio de Tijuana	1922523	Municipal President of Tijuana	http://www.wikidata.org/entity/Q294414		Town Hall of Tijuana	alderman of the city council of Tijuana Baja California	http://www.wikidata.org/entity/Q4164871	0	0
Zapopan Municipality	Zapopan Municipality	Municipio de Zapopan		Municipal President of Zapopan	http://www.wikidata.org/entity/Q294414		Town Hall of Zapopan	alderman of the Honorable City Council of Zapopan	http://www.wikidata.org/entity/Q4164871	0	0

End of automatically generated list.