S.No. | Focus category | List of cities |
---|---|---|
1. | Main cities of Colombia | Bogotá (Q2841), Medellín (Q48278), Cali (Q51103), Barranquilla (Q62823), Cartagena (Q657461), Soledad (Q767071), Cúcuta (Q216847), Soacha (Q1011151), Ibagué (Q222755), Bucaramanga (Q243766), Villavicencio (Q749224), Santa Marta (Q209016), Bello (Q816024), Valledupar (Q376903), Pereira (Q51111), Buenaventura (Q996581), San Juan de Pasto (Q320015), Manizales (Q235190), Montería (Q852725), Neiva (Q638260) |
2. | Important departmental capitals | Bogotá (Q2841), Barranquilla (Q62823), Cali (Q51103), Bucaramanga (Q243766), Medellín (Q48278) |
S.No. | Focus category | List of cities |
---|---|---|
3. | Intermediary capitals | Armenia (Q328518), Manizales (Q235190) and Montería (Q852725) |
4. | Touristic cities | Cartagena (Q657461), San Andrés (Q134678), Providencia (Q681111), Leticia (Q214913), Puerto Nariño (Q767738), Santa Marta (Q209016) and El Cocuy (Q1655984) |
S.No. | Focus category | List of cities |
---|---|---|
5. | Villages | Villa de Leyva (Q1409503), San Gil (Q1294128), Barichara (Q1576773) and Zipaquira (Q205429) |
6. | Small towns | Mocoa (Q579803), Villavicencio (Q749224), Soledad (Q767071), Pasto (Q320015) and Neiva (Q638260) |
7. | Towns in Conflict | Cúcuta (Q216847), Medellín, Arauca (Q626543), Paraguachón (Q6060938), Corinto (Q2236398), Piendamó (Q2433349), Santander de Quilichao (Q1093175), Caldono (Q1391900), Jambaló (Q1525285), Puerto Tejada (Q1256377), Toribío (Q1870972) |
Measure | Labels | Description | Alias |
---|---|---|---|
count | 40 | 40 | 40 |
mean | 54.70000 | 11.500000 | 9.375000 |
std | 38.87996 | 5.223222 | 11.331118 |
minimum | 1 | 0 | 1 |
maximum | 223 | 32 | 54 |
Measure | Statements | References | Inbound Links | Wikimedia articles |
---|---|---|---|---|
count | 40.000000 | 40.000000 | 40.000000 | 40.000000 |
mean | 154.775000 | 43.450000 | 480.625000 | 45.375000 |
std | 102.644142 | 44.839857 | 1195.322158 | 39.173963 |
min | 13.000000 | 1.000000 | 1.000000 | 1.000000 |
max | 584.000000 | 188.000000 | 7048.000000 | 235.000000 |
SELECT ?cityLabel (count(?label) as ?count) { { SELECT DISTINCT ?cityLabel ?label (lang(?label) as ?langLabel) { VALUES ?city { #main cities wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260 #departmental captials wd:Q2841 wd:Q62823 wd:Q51103 wd:Q243766 wd:Q48278 #intermediary capitals wd:Q328518 wd:Q235190 wd:Q852725 #touristic cities wd:Q657461 wd:Q134678 wd:Q681111 wd:Q214913 wd:Q767738 wd:Q209016 wd:Q1655984 #villages wd:Q1409503 wd:Q1294128 wd:Q1576773 wd:Q205429 #small towns wd:Q579803 wd:Q749224 wd:Q767071 wd:Q320015 wd:Q638260 #towns in conflict wd:Q216847 wd:Q626543 wd:Q6060938 wd:Q2236398 wd:Q2433349 wd:Q1093175 wd:Q1391900 wd:Q1525285 wd:Q1256377 wd:Q1870972}. ?city rdfs:label ?label. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } } } GROUP by ?cityLabel HAVING (?count > 10) ORDER by DESC(?count)
SELECT DISTINCT ?property { VALUES ?city { #main cities wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260 #departmental captials wd:Q2841 wd:Q62823 wd:Q51103 wd:Q243766 wd:Q48278 #intermediary capitals wd:Q328518 wd:Q235190 wd:Q852725 #touristic cities wd:Q657461 wd:Q134678 wd:Q681111 wd:Q214913 wd:Q767738 wd:Q209016 wd:Q1655984 #villages wd:Q1409503 wd:Q1294128 wd:Q1576773 wd:Q205429 #small towns wd:Q579803 wd:Q749224 wd:Q767071 wd:Q320015 wd:Q638260 #towns in conflict wd:Q216847 wd:Q626543 wd:Q6060938 wd:Q2236398 wd:Q2433349 wd:Q1093175 wd:Q1391900 wd:Q1525285 wd:Q1256377 wd:Q1870972}. ?city ?prop []. FILTER(REGEX(STR(?prop), "http://www.wikidata.org/prop/direct/")) BIND(REPLACE(STR(?prop),"http://www.wikidata.org/prop/direct/","") AS ?property) . }
SELECT ?typeLabel ?propertyLabel ?property{ VALUES ?property { wd:P6 wd:P17 wd:P18 wd:P31 wd:P37 wd:P41 wd:P47 wd:P94 wd:P112 wd:P150 wd:P163 wd:P190 wd:P194 wd:P208 wd:P213 wd:P214 wd:P227 wd:P237 wd:P242 wd:P244 wd:P268 wd:P269 wd:P281 wd:P300 wd:P373 wd:P395 wd:P402 wd:P421 wd:P473 wd:P571 wd:P625 wd:P646 wd:P856 wd:P901 wd:P906 wd:P910 wd:P935 wd:P948 wd:P950 wd:P982 wd:P989 wd:P1017 wd:P1082 wd:P1151 wd:P1225 wd:P1296 wd:P1313 wd:P1376 wd:P1417 wd:P1441 wd:P1448 wd:P1464 wd:P1465 wd:P1549 wd:P1566 wd:P1667 wd:P1705 wd:P1791 wd:P1792 wd:P1830 wd:P1842 wd:P1997 wd:P2044 wd:P2046 wd:P2924 wd:P3219 wd:P3222 wd:P3417 wd:P3451 wd:P3722 wd:P5008 wd:P5573 wd:P6404 wd:P6766 wd:P7325 wd:P131 wd:P2427 wd:P6782 wd:P691 wd:P998 wd:P1343 wd:P206 wd:P443 wd:P1813 wd:P2184 wd:P2716 wd:P361 wd:P2043 wd:P2049 wd:P1281 wd:P1889 wd:P1014 wd:P461 wd:P460 wd:P158 wd:P5760 } ?property wikibase:propertyType ?type. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER by ?typeLabel
SELECT ?cityLabel (count(DISTINCT ?property) as ?count){ VALUES ?city { #main cities wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260 #departmental captials wd:Q2841 wd:Q62823 wd:Q51103 wd:Q243766 wd:Q48278 #intermediary capitals wd:Q328518 wd:Q235190 wd:Q852725 #touristic cities wd:Q657461 wd:Q134678 wd:Q681111 wd:Q214913 wd:Q767738 wd:Q209016 wd:Q1655984 #villages wd:Q1409503 wd:Q1294128 wd:Q1576773 wd:Q205429 #small towns wd:Q579803 wd:Q749224 wd:Q767071 wd:Q320015 wd:Q638260 #towns in conflict wd:Q216847 wd:Q626543 wd:Q6060938 wd:Q2236398 wd:Q2433349 wd:Q1093175 wd:Q1391900 wd:Q1525285 wd:Q1256377 wd:Q1870972}. ?city ?prop []. FILTER(REGEX(STR(?prop), "http://www.wikidata.org/prop/direct/")) BIND(REPLACE(STR(?prop),"http://www.wikidata.org/prop/direct/","") AS ?property) . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,es". } } GROUP by ?cityLabel ORDER by ?cityLabel
SELECT ?cityLabel (count(?label) as ?count){ { SELECT DISTINCT ?city ?label{ VALUES ?city { #main cities wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260 #departmental captials wd:Q2841 wd:Q62823 wd:Q51103 wd:Q243766 wd:Q48278 #intermediary capitals wd:Q328518 wd:Q235190 wd:Q852725 #touristic cities wd:Q657461 wd:Q134678 wd:Q681111 wd:Q214913 wd:Q767738 wd:Q209016 wd:Q1655984 #villages wd:Q1409503 wd:Q1294128 wd:Q1576773 wd:Q205429 #small towns wd:Q579803 wd:Q749224 wd:Q767071 wd:Q320015 wd:Q638260 #towns in conflict wd:Q216847 wd:Q626543 wd:Q6060938 wd:Q2236398 wd:Q2433349 wd:Q1093175 wd:Q1391900 wd:Q1525285 wd:Q1256377 wd:Q1870972}. ?city rdfs:label ?label. } } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP by ?cityLabel ORDER by ?cityLabel
SELECT ?cityLabel (count(?description) as ?count){ { SELECT DISTINCT ?city ?description{ VALUES ?city { #main cities wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260 #departmental captials wd:Q2841 wd:Q62823 wd:Q51103 wd:Q243766 wd:Q48278 #intermediary capitals wd:Q328518 wd:Q235190 wd:Q852725 #touristic cities wd:Q657461 wd:Q134678 wd:Q681111 wd:Q214913 wd:Q767738 wd:Q209016 wd:Q1655984 #villages wd:Q1409503 wd:Q1294128 wd:Q1576773 wd:Q205429 #small towns wd:Q579803 wd:Q749224 wd:Q767071 wd:Q320015 wd:Q638260 #towns in conflict wd:Q216847 wd:Q626543 wd:Q6060938 wd:Q2236398 wd:Q2433349 wd:Q1093175 wd:Q1391900 wd:Q1525285 wd:Q1256377 wd:Q1870972}. ?city schema:description ?description. } } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP by ?cityLabel ORDER by ?cityLabel
SELECT ?cityLabel (count(?alias) as ?count){ { SELECT DISTINCT ?city ?alias{ VALUES ?city { #main cities wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260 #departmental captials wd:Q2841 wd:Q62823 wd:Q51103 wd:Q243766 wd:Q48278 #intermediary capitals wd:Q328518 wd:Q235190 wd:Q852725 #touristic cities wd:Q657461 wd:Q134678 wd:Q681111 wd:Q214913 wd:Q767738 wd:Q209016 wd:Q1655984 #villages wd:Q1409503 wd:Q1294128 wd:Q1576773 wd:Q205429 #small towns wd:Q579803 wd:Q749224 wd:Q767071 wd:Q320015 wd:Q638260 #towns in conflict wd:Q216847 wd:Q626543 wd:Q6060938 wd:Q2236398 wd:Q2433349 wd:Q1093175 wd:Q1391900 wd:Q1525285 wd:Q1256377 wd:Q1870972}. ?city skos:altLabel ?alias. } } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP by ?cityLabel ORDER by ?cityLabel
SELECT ?cityLabel (count(?subject) as ?count){ { SELECT DISTINCT ?subject ?prop ?city { VALUES ?city { #main cities wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260 #departmental captials wd:Q2841 wd:Q62823 wd:Q51103 wd:Q243766 wd:Q48278 #intermediary capitals wd:Q328518 wd:Q235190 wd:Q852725 #touristic cities wd:Q657461 wd:Q134678 wd:Q681111 wd:Q214913 wd:Q767738 wd:Q209016 wd:Q1655984 #villages wd:Q1409503 wd:Q1294128 wd:Q1576773 wd:Q205429 #small towns wd:Q579803 wd:Q749224 wd:Q767071 wd:Q320015 wd:Q638260 #towns in conflict wd:Q216847 wd:Q626543 wd:Q6060938 wd:Q2236398 wd:Q2433349 wd:Q1093175 wd:Q1391900 wd:Q1525285 wd:Q1256377 wd:Q1870972}. ?subject ?prop ?city. } } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP by ?cityLabel ORDER by ?cityLabel
SELECT DISTINCT ?cityLabel ?sitelinks { VALUES ?city {wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260}. ?city wikibase:sitelinks ?sitelinks. FILTER(?sitelinks > 10) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER by DESC(?sitelinks)
SELECT ?lang (count(?city) as ?count) { { SELECT DISTINCT ?city ?lang { hint:Query hint:optimizer "None" VALUES ?city {wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260}. [] schema:about ?city; schema:inLanguage ?lang. } } } GROUP BY ?lang ORDER BY DESC(?count)
SELECT DISTINCT ?cityLabel ?sitelinks { VALUES ?city { #main cities wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260 #departmental captials wd:Q2841 wd:Q62823 wd:Q51103 wd:Q243766 wd:Q48278 #intermediary capitals wd:Q328518 wd:Q235190 wd:Q852725 #touristic cities wd:Q657461 wd:Q134678 wd:Q681111 wd:Q214913 wd:Q767738 wd:Q209016 wd:Q1655984 #villages wd:Q1409503 wd:Q1294128 wd:Q1576773 wd:Q205429 #small towns wd:Q579803 wd:Q749224 wd:Q767071 wd:Q320015 wd:Q638260 #towns in conflict wd:Q216847 wd:Q626543 wd:Q6060938 wd:Q2236398 wd:Q2433349 wd:Q1093175 wd:Q1391900 wd:Q1525285 wd:Q1256377 wd:Q1870972}. ?city wikibase:sitelinks ?sitelinks. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,es". } } ORDER by ?cityLabel
SELECT ?cityLabel (count(?article) as ?count) { { SELECT DISTINCT ?city ?article { hint:Query hint:optimizer "None" VALUES ?city { #main cities wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260 #departmental captials wd:Q2841 wd:Q62823 wd:Q51103 wd:Q243766 wd:Q48278 #intermediary capitals wd:Q328518 wd:Q235190 wd:Q852725 #touristic cities wd:Q657461 wd:Q134678 wd:Q681111 wd:Q214913 wd:Q767738 wd:Q209016 wd:Q1655984 #villages wd:Q1409503 wd:Q1294128 wd:Q1576773 wd:Q205429 #small towns wd:Q579803 wd:Q749224 wd:Q767071 wd:Q320015 wd:Q638260 #towns in conflict wd:Q216847 wd:Q626543 wd:Q6060938 wd:Q2236398 wd:Q2433349 wd:Q1093175 wd:Q1391900 wd:Q1525285 wd:Q1256377 wd:Q1870972}. ?article schema:about ?city. } } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,es". } } GROUP BY ?cityLabel ORDER BY ?cityLabel
SELECT ?lang (count(?city) as ?count) { { SELECT DISTINCT ?city ?article ?lang { hint:Query hint:optimizer "None" VALUES ?city { #main cities wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260 #departmental captials wd:Q2841 wd:Q62823 wd:Q51103 wd:Q243766 wd:Q48278 #intermediary capitals wd:Q328518 wd:Q235190 wd:Q852725 #touristic cities wd:Q657461 wd:Q134678 wd:Q681111 wd:Q214913 wd:Q767738 wd:Q209016 wd:Q1655984 #villages wd:Q1409503 wd:Q1294128 wd:Q1576773 wd:Q205429 #small towns wd:Q579803 wd:Q749224 wd:Q767071 wd:Q320015 wd:Q638260 #towns in conflict wd:Q216847 wd:Q626543 wd:Q6060938 wd:Q2236398 wd:Q2433349 wd:Q1093175 wd:Q1391900 wd:Q1525285 wd:Q1256377 wd:Q1870972}. ?article schema:about ?city; schema:inLanguage ?lang. } } } GROUP BY ?lang ORDER BY DESC(?count)
SELECT DISTINCT ?city ?lang ?group { hint:Query hint:optimizer "None" VALUES ?city { #main cities wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260 #departmental captials wd:Q2841 wd:Q62823 wd:Q51103 wd:Q243766 wd:Q48278 #intermediary capitals wd:Q328518 wd:Q235190 wd:Q852725 #touristic cities wd:Q657461 wd:Q134678 wd:Q681111 wd:Q214913 wd:Q767738 wd:Q209016 wd:Q1655984 #villages wd:Q1409503 wd:Q1294128 wd:Q1576773 wd:Q205429 #small towns wd:Q579803 wd:Q749224 wd:Q767071 wd:Q320015 wd:Q638260 #towns in conflict wd:Q216847 wd:Q626543 wd:Q6060938 wd:Q2236398 wd:Q2433349 wd:Q1093175 wd:Q1391900 wd:Q1525285 wd:Q1256377 wd:Q1870972}. [] schema:about ?city; schema:inLanguage ?lang; schema:isPartOf [wikibase:wikiGroup ?group]. }
SELECT ?cityLabel (count(?lang) as ?count){ { SELECT DISTINCT ?city ?lang ?group { hint:Query hint:optimizer "None" VALUES ?city { #main cities wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260 #departmental captials wd:Q2841 wd:Q62823 wd:Q51103 wd:Q243766 wd:Q48278 #intermediary capitals wd:Q328518 wd:Q235190 wd:Q852725 #touristic cities wd:Q657461 wd:Q134678 wd:Q681111 wd:Q214913 wd:Q767738 wd:Q209016 wd:Q1655984 #villages wd:Q1409503 wd:Q1294128 wd:Q1576773 wd:Q205429 #small towns wd:Q579803 wd:Q749224 wd:Q767071 wd:Q320015 wd:Q638260 #towns in conflict wd:Q216847 wd:Q626543 wd:Q6060938 wd:Q2236398 wd:Q2433349 wd:Q1093175 wd:Q1391900 wd:Q1525285 wd:Q1256377 wd:Q1870972}. [] schema:about ?city; schema:inLanguage ?lang; schema:isPartOf [wikibase:wikiGroup ?group]. } } FILTER(str(?group)="wikipedia") SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,es". } } GROUP by ?cityLabel ORDER by ?cityLabel
SELECT ?cityLabel ?group (count(?lang) as ?count){ { SELECT DISTINCT ?city ?lang ?group { hint:Query hint:optimizer "None" VALUES ?city { #main cities wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260 #departmental captials wd:Q2841 wd:Q62823 wd:Q51103 wd:Q243766 wd:Q48278 #intermediary capitals wd:Q328518 wd:Q235190 wd:Q852725 #touristic cities wd:Q657461 wd:Q134678 wd:Q681111 wd:Q214913 wd:Q767738 wd:Q209016 wd:Q1655984 #villages wd:Q1409503 wd:Q1294128 wd:Q1576773 wd:Q205429 #small towns wd:Q579803 wd:Q749224 wd:Q767071 wd:Q320015 wd:Q638260 #towns in conflict wd:Q216847 wd:Q626543 wd:Q6060938 wd:Q2236398 wd:Q2433349 wd:Q1093175 wd:Q1391900 wd:Q1525285 wd:Q1256377 wd:Q1870972}. [] schema:about ?city; schema:inLanguage ?lang; schema:isPartOf [wikibase:wikiGroup ?group]. } } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,es". } } GROUP by ?cityLabel ?group ORDER by ?cityLabel
SELECT ?cityLabel (count(?reference) as ?count){ { SELECT ?city ?statement ?reference { VALUES ?city { #main cities wd:Q2841 wd:Q48278 wd:Q51103 wd:Q62823 wd:Q657461 wd:Q767071 wd:Q216847 wd:Q1011151 wd:Q222755 wd:Q243766 wd:Q749224 wd:Q209016 wd:Q816024 wd:Q376903 wd:Q51111 wd:Q996581 wd:Q320015 wd:Q235190 wd:Q852725 wd:Q638260 #departmental captials wd:Q2841 wd:Q62823 wd:Q51103 wd:Q243766 wd:Q48278 #intermediary capitals wd:Q328518 wd:Q235190 wd:Q852725 #touristic cities wd:Q657461 wd:Q134678 wd:Q681111 wd:Q214913 wd:Q767738 wd:Q209016 wd:Q1655984 #villages wd:Q1409503 wd:Q1294128 wd:Q1576773 wd:Q205429 #small towns wd:Q579803 wd:Q749224 wd:Q767071 wd:Q320015 wd:Q638260 #towns in conflict wd:Q216847 wd:Q626543 wd:Q6060938 wd:Q2236398 wd:Q2433349 wd:Q1093175 wd:Q1391900 wd:Q1525285 wd:Q1256377 wd:Q1870972}. ?city ?prop ?statement. OPTIONAL{?statement prov:wasDerivedFrom ?reference} FILTER(REGEX(STR(?statement), "http://www.wikidata.org/entity/statement/")) } } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,es". } } GROUP by ?cityLabel ORDER by ?cityLabel