User:Bluerasberry/sandbox

count of properties for all instances of an item

SELECT DISTINCT ?property ?propertyLabel ?count
WITH {
  SELECT DISTINCT ?item WHERE {
    ?item wdt:P31*/wdt:P279* wd:Q20820271 .
  }
  LIMIT 200000
  } AS %items 
WITH {
  SELECT DISTINCT ?property (COUNT(*) AS ?count) WHERE {
  INCLUDE %items.
    ?item ?p [ ] .
    ?property a wikibase:Property;
                wikibase:claim ?p.
  }
  GROUP BY ?property 
  LIMIT 100
  } AS %results 
WHERE {
  INCLUDE %results.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC(?count)
LIMIT 100

Try it!

• animals + gestation

• medical terms

• main subject tags for academic articles, ranked, from a random sample of 10,000

• doi to Q

• add main subject = hamster to articles

• book of COVID-19 queries

• find n grams

• How_does_one_convert_a_big_list
• Wikidata property for arbitrary lists?
• Wikidata:Request_a_query/Archive/2020/10#list_of_Wikidata_items_-->_Wikipedia_language_versions_for_each

• notes
  • Wikidata:Property proposal/expected responses