query-1b7862830ddb1904432b09300c6bc62f
, one might however need to review the list of such properties every now and then to ensure that no major online platform is missing. (Q105388954)Wikidata property to identify online accounts As demonstrated by the first query we can select the online accounts without knowing them thanks to their properties being instances of
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?prop ?propLabel (COUNT(DISTINCT ?value) AS ?usageCount) (SAMPLE(?item) AS ?sample) WHERE {
?prop wdt:P31 wd:Q105388954 ;
wikibase:directClaim ?propURI .
# Limit the query to Swedish government agencies:
# ?item wdt:P31/wdt:P279* wd:Q2659904 ; wdt:P17 wd:Q34 .
?item ?propURI ?value .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?prop ?propLabel ORDER BY DESC(?usageCount)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?item"):::projected
v2("?prop"):::projected
v3("?propURI")
v6("?sample")
v6("?usageCount")
v5("?value"):::projected
c2(["wd:Q105388954"]):::iri
c5(["bd:serviceParam"]):::iri
c7(["#91;AUTO_LANGUAGE#93;,en"]):::literal
v2 --"wdt:P31"--> c2
v2 --"wikibase:directClaim"--> v3
v4 -->v3--> v5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c5 --"wikibase:language"--> c7
end
bind2[/"count(?value)"/]
v5 --o bind2
bind2 --as--o v6
bind3[/"sample(?item)"/]
v4 --o bind3
bind3 --as--o v6