Wikidata:WikiProject African Diaspora

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

Main queries

Items within scope

The following query uses these:

• Items: WikiProject African diaspora (Q15304953)   

• 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". }
  }
  

Try it!

Items within scope by type

The following query uses these:

• Items: WikiProject African diaspora (Q15304953)   

• 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)
  

Try it!

Timeline of creation of items within scope

The following query uses these:

• Items: WikiProject African diaspora (Q15304953)   , QID milestone (Q38074555)   

• 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
  }
  

Try it!

Other queries

Items for which at least one sitelink has a quality badge

The following query uses these:

• Items: WikiProject African diaspora (Q15304953)   

• 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
  

Try it!

Items without a picture but with at least one sitelink that has a quality badge

The following query uses these:

• Items: WikiProject African diaspora (Q15304953)   

• 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
  

Try it!

Subpages

• WikiProject African Diaspora/Participants

Participants

[+] Add yourself to the list

The participants listed below can be notified using the following template in discussions:
{{Ping project|African Diaspora}}

• --Daniel Mietchen (talk) 06:20, 20 October 2019 (UTC)
• --Dsp13 (talk) 13:37, 28 December 2022 (UTC)

Related projects

• Wikidata:WikiProject Africa