query-1fd1f1c52a2ee3b10556acfb6f42eb27
List of Ps used for a particular QWhat I'm trying to do is get a list of P values used (with counts) for a particular Q. 22:51, 10 November 2019 (UTC)) talk (DcheneySo like for Q611644 (Catholic Bishop), I'm interesting in which P values are being used to refer to it (might be P31, P106, etc.). I'm mostly looking for what is the most common and then outliers that might need to be reviewed. --
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?property ?propertyLabel (COUNT(DISTINCT ?s) AS ?statements) WHERE {
?property wikibase:statementProperty ?ps .
?s ?ps wd:Q611644 .
SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
} GROUP BY ?property ?propertyLabel ORDER BY DESC(?statements)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?property"):::projected
v3("?ps")
v4("?s"):::projected
v5("?statements")
c4(["bd:serviceParam"]):::iri
c6(["en"]):::literal
c2(["wd:Q611644"]):::iri
v2 --"wikibase:statementProperty"--> v3
v4 -->v3--> c2
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c4 --"wikibase:language"--> c6
end
bind1[/"count(?s)"/]
v4 --o bind1
bind1 --as--o v5