Wikidata:WikiProject UAE/Queries

From Wikidata
Jump to navigation Jump to search


Item and Property Specific[edit]

UAE-specific properties and usage count
The following query uses these:
  • Properties: country (P17)  View with Reasonator View with SQID
    #UAE-specific property usage count
SELECT ?prop ?propLabel ?propDescription (COUNT(?propclaim) AS ?count) WHERE {
  ?prop wdt:P17 wd:Q878 .
  ?prop wikibase:claim ?propclaim .
  ?item ?propclaim [] .
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}  
} GROUP BY ?prop ?propLabel ?propDescription ORDER BY DESC (?count)
LIMIT 200
Try it!
cumulative growth of UAE items
The following query uses these:
  • Properties: quantity (P1114)  View with Reasonator View with SQID, point in time (P585)  View with Reasonator View with SQID
    #cumulative growth of UAE items (stolen from 99of9)
#defaultView:LineChart
SELECT (SAMPLE(?date) AS ?date) (SUM(?count) AS ?cumulative_count) ?milestone WHERE {
  {
    SELECT ?qid_rounded (COUNT(?item) AS ?count) (SAMPLE(?item) AS ?exampleitem) WHERE {
      ?item ?property wd:Q878.
      BIND(xsd:integer(SUBSTR(STR(?item), 33 )) AS ?qid)
      BIND(xsd:integer(?qid / 20000 ) AS ?qid_cut)
      BIND(?qid_cut * 20000  AS ?qid_rounded)
    }
    GROUP BY ?qid_rounded
  }
  wd:Q38074555 p:P1114 ?milestonep.
  ?milestonep ps:P1114 ?milestone.
  FILTER(?milestone > ?qid_rounded)
  ?milestonep pq:P585 ?date.
}
GROUP BY ?milestone
Try it!
Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:WikiProject_UAE/Queries&oldid=1682238692"