Reproduce the data needed for Wikidata:Statistics pie chart in an automated way
Closed, ResolvedPublic
Actions

Description

I don't want to start looking at the Lua that looks like it is generating this chart...

The chart shows the spread of P31/P279 throughout all wikidata items.

I believe this should be trivial to recreate using SPARQL.

SELECT (count(distinct(?s)) AS ?scount) WHERE {?s wdt:P31 wd:Q5}

etc.

Related Gerrit Patches:

analytics/limn-wikidata-data : master

Mentioned Here: P31 Fork of P29 (An Untitled Masterwork)
P279 404 and 500 error pages

Addshore raised the priority of this task from to Needs Triage.

Addshore updated the task description. (Show Details)

Addshore added a subscriber: Addshore.

@Lydia_Pintscher
The question is do we generally want to track the number of statements for each property or only for this specific use case?

We might even be able to do this from some links table rather than from SPARQL

It should be noted in the other dash we were tracking for all of them !

I am mostly interested in this particular usecase - so tracking how many items we have for the biggest categories of entities.

Addshore triaged this task as Normal priority.Nov 27 2015, 9:24 PM

Addshore set Security to None.

Change 255975 had a related patch set uploaded (by Addshore):
Add instanceof tracking script

Change 255975 merged by Addshore:
Add instanceof tracking script

Done, rough graph has been added to https://grafana.wikimedia.org/dashboard/db/wikidata-datamodel for now (although this dash needs cleaning up)