- Count grouped by Number of statements per item
This could be done through page_props using wb-claims key!
We need to ensure we count how many items have 0 claims here!
We could also count this for properties
This could be done through page_props using wb-claims key!
We need to ensure we count how many items have 0 claims here!
We could also count this for properties
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | Addshore | T119182 Track Wikidata data completeness | |||
Resolved | Addshore | T119621 Track Count grouped by Number of statements per item on Wikidata |
SELECT count(*) as count, pp_value as claims
FROM wikidatawiki.page_props
WHERE pp_propname = 'wb-claims'
GROUP BY pp_value
~6 min execution
I am going to close this as resolved as we are now tracking this!
Graphing this in grafana will probably be put off until I can use the natural sort and sortByName functions from graphite (once it gets updated)