query-4c3cdefeed2a81bb3fda69f9b2817bbe

rq turtle/ttl

Onestop ID type statistics SELECT ?type (COUNT(?type) AS ?count) (IRI(CONCAT("https://query.wikidata.org/#%23%20Onestop%20ID%20type%20",?type,"%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fid%0AWHERE%0A{%0A%09%3Fitem%20wdt%3AP11109%20%3Fid%20.%0A%20%20%20%20FILTER(SUBSTR(%3Fid%2C%201%2C%201)%20%3D%20%22",?type,"%22)%20.%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20{%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20}%20%20%20%20%0A}%0AORDER%20BY%20%3FitemLabel")) as ?instances) WHERE { ?s wdt:P11109 ?id . BIND (SUBSTR(?id, 1, 1) AS ?type) . } GROUP BY ?type Onestop ID type statistics SELECT ?type (COUNT(?type) AS ?count) (IRI(CONCAT("https://query.wikidata.org/#%23%20Onestop%20ID%20type%20",?type,"%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fid%0AWHERE%0A{%0A%09%3Fitem%20wdt%3AP11109%20%3Fid%20.%0A%20%20%20%20FILTER(SUBSTR(%3Fid%2C%201%2C%201)%20%3D%20%22",?type,"%22)%20.%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20{%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20}%20%20%20%20%0A}%0AORDER%20BY%20%3FitemLabel")) as ?instances) WHERE { ?s wdt:P11109 ?id . BIND (SUBSTR(?id, 1, 1) AS ?type) . } GROUP BY ?type Onestop ID type statistics SELECT ?type (COUNT(?type) AS ?count) (IRI(CONCAT("https://query.wikidata.org/#%23%20Onestop%20ID%20type%20",?type,"%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fid%0AWHERE%0A{%0A%09%3Fitem%20wdt%3AP11109%20%3Fid%20.%0A%20%20%20%20FILTER(SUBSTR(%3Fid%2C%201%2C%201)%20%3D%20%22",?type,"%22)%20.%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20{%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20}%20%20%20%20%0A}%0AORDER%20BY%20%3FitemLabel")) as ?instances) WHERE { ?s wdt:P11109 ?id . BIND (SUBSTR(?id, 1, 1) AS ?type) . } GROUP BY ?type Onestop ID type statistics SELECT ?type (COUNT(?type) AS ?count) (IRI(CONCAT("https://query.wikidata.org/#%23%20Onestop%20ID%20type%20",?type,"%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fid%0AWHERE%0A{%0A%09%3Fitem%20wdt%3AP11109%20%3Fid%20.%0A%20%20%20%20FILTER(SUBSTR(%3Fid%2C%201%2C%201)%20%3D%20%22",?type,"%22)%20.%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20{%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20}%20%20%20%20%0A}%0AORDER%20BY%20%3FitemLabel")) as ?instances) WHERE { ?s wdt:P11109 ?id . BIND (SUBSTR(?id, 1, 1) AS ?type) . } GROUP BY ?type Onestop ID type statistics SELECT ?type (COUNT(?type) AS ?count) (IRI(CONCAT("https://query.wikidata.org/#%23%20Onestop%20ID%20type%20",?type,"%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fid%0AWHERE%0A{%0A%09%3Fitem%20wdt%3AP11109%20%3Fid%20.%0A%20%20%20%20FILTER(SUBSTR(%3Fid%2C%201%2C%201)%20%3D%20%22",?type,"%22)%20.%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20{%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20}%20%20%20%20%0A}%0AORDER%20BY%20%3FitemLabel")) as ?instances) WHERE { ?s wdt:P11109 ?id . BIND (SUBSTR(?id, 1, 1) AS ?type) . } GROUP BY ?type

Use at

• https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
#Onestop ID type statistics
SELECT ?type (COUNT(?type) AS ?count)
(IRI(CONCAT("https://query.wikidata.org/#%23%20Onestop%20ID%20type%20",?type,"%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fid%0AWHERE%0A{%0A%09%3Fitem%20wdt%3AP11109%20%3Fid%20.%0A%20%20%20%20FILTER(SUBSTR(%3Fid%2C%201%2C%201)%20%3D%20%22",?type,"%22)%20.%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20{%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20}%20%20%20%20%0A}%0AORDER%20BY%20%3FitemLabel")) as ?instances)
WHERE {
  ?s wdt:P11109 ?id .
  BIND (SUBSTR(?id, 1, 1) AS ?type) .
 }
GROUP BY ?type

Query found at

• https://www.wikidata.org/wiki/Help:P11109
• https://www.wikidata.org/wiki/Help:P11109/da
• https://www.wikidata.org/wiki/Help:P11109/en
• https://www.wikidata.org/wiki/Help:P11109/fr
• https://www.wikidata.org/wiki/Help:P11109/nl
• https://www.wikidata.org/wiki/Help:P11109/pl
• https://www.wikidata.org/wiki/Property_talk:P11109