Wikidata:WikiProject African Diaspora
Jump to navigation
Jump to search
This WikiProject is concerned with the coverage of African diaspora (Q385967) and related entities, both on Wikidata and across Wikimedia projects.
Similar WikiProject African diaspora (Q15304953) instances are available in various languages of Wikipedia.
Queries
[edit]Main queries
[edit]Items within scope
[edit]The following query uses these:
- Properties: on focus list of Wikimedia project (P5008)
select ?item ?itemLabel where { ?item wdt:P5008 wd:Q15304953 . # item is within scope of the project SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Items within scope by type
[edit]The following query uses these:
- Properties: on focus list of Wikimedia project (P5008) , instance of (P31)
select ?typeLabel (count(distinct ?item) as ?count) where { ?item wdt:P5008 wd:Q15304953 . # item is within scope of the project ?item wdt:P31 ?type . # type of item SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } group by ?typeLabel order by desc(?count)
Timeline of creation of items within scope
[edit]The following query uses these:
- Properties: on focus list of Wikimedia project (P5008) , quantity (P1114) , point in time (P585)
#defaultView:AreaChart SELECT ?date ?cumulativecount { hint:Query hint:optimizer "None". { SELECT ?milestonep (COUNT(?item) as ?cumulativecount) # cumulative count of items meeting the filtering criteria below WHERE { { SELECT ?item { ?item wdt:P5008 wd:Q15304953 .} LIMIT 100000 } # items within scope of the project BIND( xsd:integer( substr(str(?item), 33)) as ?qid) # get the QID of the item wd:Q38074555 p:P1114 ?milestonep . # get list of QID milestones ?milestonep ps:P1114 ?milestone . FILTER( ?milestone > ?qid ) # only consider milestones newer than the item } GROUP BY ?milestonep } ?milestonep pq:P585 ?date # get the date when the QID milestone was reached }
Other queries
[edit]Items for which at least one sitelink has a quality badge
[edit]The following query uses these:
- Properties: on focus list of Wikimedia project (P5008)
SELECT ?sitelink ?itemLabel ?badge ?badgeLabel WHERE { ?item wdt:P5008 wd:Q15304953. # item is within the focus of WikiProject Climate Change ?sitelink schema:about ?item; # sitelinks about the item wikibase:badge ?badge . # sitelink has a quality badge SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } . } ORDER BY ?badgeLabel
Items without a picture but with at least one sitelink that has a quality badge
[edit]The following query uses these:
- Properties: on focus list of Wikimedia project (P5008) , image (P18)
SELECT ?item ?sitelink ?itemLabel ?badge ?badgeLabel WHERE { ?item wdt:P5008 wd:Q15304953. ?sitelink schema:about ?item; wikibase:badge ?badge . # Sitelink is badged as a Featured Article SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } . MINUS {?item wdt:P18 ?image} } ORDER BY ?badgeLabel
Subpages
[edit]Participants
[edit]The participants listed below can be notified using the following template in discussions:{{Ping project|African Diaspora}}