Wikidata:WikiProject African Diaspora

From Wikidata
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)  View with Reasonator View with SQID
    1 select ?item ?itemLabel
    2 where
    3 { 
    4   ?item wdt:P5008 wd:Q15304953 . # item is within scope of the project
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    


Items within scope by type[edit]

The following query uses these:

  • Properties: on focus list of Wikimedia project (P5008)  View with Reasonator View with SQID, instance of (P31)  View with Reasonator View with SQID
    1 select ?typeLabel (count(distinct ?item) as ?count)
    2 where
    3 { 
    4   ?item wdt:P5008 wd:Q15304953 . # item is within scope of the project
    5   ?item wdt:P31 ?type .          # type of item
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 } 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)  View with Reasonator View with SQID, quantity (P1114)  View with Reasonator View with SQID, point in time (P585)  View with Reasonator View with SQID
     1 #defaultView:AreaChart
     2 SELECT ?date ?cumulativecount 
     3 {
     4     hint:Query hint:optimizer "None".
     5     {   SELECT ?milestonep (COUNT(?item) as ?cumulativecount)              # cumulative count of items meeting the filtering criteria below
     6         WHERE
     7         {
     8           { SELECT ?item { ?item wdt:P5008 wd:Q15304953 .}  LIMIT 100000 } # items within scope of the project
     9           BIND( xsd:integer( substr(str(?item), 33)) as ?qid)              # get the QID of the item
    10           wd:Q38074555 p:P1114 ?milestonep .                               # get list of QID milestones
    11           ?milestonep ps:P1114 ?milestone .
    12           FILTER( ?milestone > ?qid )                                      # only consider milestones newer than the item
    13         }
    14         GROUP BY ?milestonep
    15     }          
    16     ?milestonep pq:P585 ?date                                              # get the date when the QID milestone was reached
    17 }
    

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)  View with Reasonator View with SQID
    1 SELECT ?sitelink ?itemLabel ?badge ?badgeLabel WHERE {
    2   ?item wdt:P5008 wd:Q15304953.    # item is within the focus of WikiProject Climate Change
    3   ?sitelink schema:about ?item;    # sitelinks about the item
    4      wikibase:badge ?badge .       # sitelink has a quality badge
    5     SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } .
    6 } 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)  View with Reasonator View with SQID, image (P18)  View with Reasonator View with SQID
    1 SELECT ?item ?sitelink ?itemLabel ?badge ?badgeLabel WHERE {
    2   ?item wdt:P5008 wd:Q15304953.
    3   ?sitelink schema:about ?item;
    4      wikibase:badge ?badge . # Sitelink is badged as a Featured Article
    5     SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } .
    6   MINUS {?item wdt:P18 ?image}
    7 } ORDER BY ?badgeLabel
    

Subpages[edit]

Participants[edit]

[+ Add yourself to the list]

The participants listed below can be notified using the following template in discussions:

{{Ping project|African Diaspora}}

Related projects[edit]