Graph Statistics: Difference between revisions
(added PropertyCount-query) |
m (→ItemCount: minus students) |
||
| Line 16: | Line 16: | ||
# items that have 0+ statements | # items that have 0+ statements | ||
?item wikibase:statements ?s. | ?item wikibase:statements ?s. | ||
MINUS{ ?item a wikibase:Property } # Filter out properties | MINUS{ ?item a wikibase:Property } # Filter out properties | ||
MINUS{ ?item wdt:P3 wd:Q167 } # Filter out students | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} LIMIT 25 | } LIMIT 25 | ||
Revision as of 12:35, 27 November 2023
A page to help show the structure of the graph using metrics and statistics. For similar pages reference:
Simple Metrics
ItemCount
Gives a count of all items in the Wikibase-instance. Items used: Student (Q167)
Properties used: instance of (P3)
#defaultView:Table
PREFIX wd: <https://graphit.ur.de/entity>
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
SELECT (COUNT(*) as ?items)
WHERE {
# items that have 0+ statements
?item wikibase:statements ?s.
MINUS{ ?item a wikibase:Property } # Filter out properties
MINUS{ ?item wdt:P3 wd:Q167 } # Filter out students
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} LIMIT 25
Make inline
PropertyCount
Gives a count of all properties in the Wikibase-instance
#defaultView:Table
PREFIX wd: <https://graphit.ur.de/entity>
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
SELECT (COUNT(*) as ?property)
WHERE {
?property a wikibase:Property.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} LIMIT 28
Make inline