Wikidata:WikiProject Climate Change/Queries

 HomeAboutModelsQueriesMembersDiscuss

Main queries

Items within scope

The following query uses these:

• Items: WikiProject Climate change (Q15305047)   

• Properties: on focus list of Wikimedia project (P5008)   

  select ?item ?itemLabel
  where
  {
    ?item wdt:P5008 wd:Q15305047 . # 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 Climate change (Q15305047)   

• Properties: on focus list of Wikimedia project (P5008)   , instance of (P31)   

  select ?typeLabel (count(distinct ?item) as ?count)
  where
  {
    ?item wdt:P5008 wd:Q15305047 . # 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!

Table of objects in scope

Manually update

all entities | count | all groupings | without grouping property | below threshold (5) | Querying about WikiProject Climate change (Q15305047)   Grouping by instance of (P31)

Top groupings (Minimum 5 items)		Top Properties (used at least 3 times per grouping)
Name	Count	field of work (P101)	country (P17)	location (P276)	located in the administrative territorial entity (P131)
human (Q5)	977	25.9% (253) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
organization (Q43229)	160	9.38% (15) 🔍	44.38% (71) 🔍	0% (0) 🔍	13.12% (21) 🔍
aspect in a geographic region (Q74817647)	96	0% (0) 🔍	88.54% (85) 🔍	19.79% (19) 🔍	0% (0) 🔍
climate change by country or territory (Q71875404)	85	0% (0) 🔍	85.88% (73) 🔍	7.06% (6) 🔍	0% (0) 🔍
nonprofit organization (Q163740)	72	13.89% (10) 🔍	88.89% (64) 🔍	0% (0) 🔍	29.17% (21) 🔍
climate change by subnational entity (Q95000087)	67	0% (0) 🔍	100.0% (67) 🔍	0% (0) 🔍	34.33% (23) 🔍
literary work (Q7725634)	62	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
Wikimedia category (Q4167836)	61	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
climate of geographic location (Q46997958)	55	0% (0) 🔍	85.45% (47) 🔍	7.27% (4) 🔍	47.27% (26) 🔍
environmental organization (Q1785733)	49	8.16% (4) 🔍	87.76% (43) 🔍	0% (0) 🔍	20.41% (10) 🔍
Wikimedia list article (Q13406463)	41	0% (0) 🔍	9.76% (4) 🔍	0% (0) 🔍	0% (0) 🔍
film (Q11424)	40	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
business (Q4830453)	40	0% (0) 🔍	62.5% (25) 🔍	0% (0) 🔍	0% (0) 🔍
research institute (Q31855)	35	14.29% (5) 🔍	97.14% (34) 🔍	0% (0) 🔍	71.43% (25) 🔍
written work (Q47461344)	31	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
United Nations Climate Change conference (Q7888355)	24	0% (0) 🔍	95.83% (23) 🔍	95.83% (23) 🔍	12.5% (3) 🔍
report (Q10870555)	24	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
government agency (Q327333)	23	21.74% (5) 🔍	91.3% (21) 🔍	0% (0) 🔍	17.39% (4) 🔍
environmental effects (Q2022868)	22	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
academic discipline (Q11862829)	19	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
website (Q35127)	17	0% (0) 🔍	35.29% (6) 🔍	0% (0) 🔍	0% (0) 🔍
heat wave (Q215864)	17	0% (0) 🔍	70.59% (12) 🔍	41.18% (7) 🔍	0% (0) 🔍
non-governmental organization (Q79913)	16	18.75% (3) 🔍	81.25% (13) 🔍	0% (0) 🔍	18.75% (3) 🔍
concept (Q151885)	16	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
project (Q170584)	16	0% (0) 🔍	37.5% (6) 🔍	0% (0) 🔍	0% (0) 🔍
think tank (Q155271)	15	26.67% (4) 🔍	93.33% (14) 🔍	0% (0) 🔍	26.67% (4) 🔍
wildfire (Q169950)	15	0% (0) 🔍	100.0% (15) 🔍	60.0% (9) 🔍	66.67% (10) 🔍
Scope 3 category (Q124883403)	15	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
legal case (Q2334719)	14	0% (0) 🔍	50.0% (7) 🔍	0% (0) 🔍	0% (0) 🔍
occurrence (Q1190554)	14	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
Wikimedia disambiguation page (Q4167410)	14	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
convention (Q625994)	13	0% (0) 🔍	30.77% (4) 🔍	30.77% (4) 🔍	0% (0) 🔍
international organization (Q484652)	12	0% (0) 🔍	25.0% (3) 🔍	0% (0) 🔍	0% (0) 🔍
treaty (Q131569)	12	0% (0) 🔍	0% (0) 🔍	33.33% (4) 🔍	0% (0) 🔍
social movement (Q49773)	12	25.0% (3) 🔍	33.33% (4) 🔍	0% (0) 🔍	0% (0) 🔍
coal-fired power station (Q6558431)	12	0% (0) 🔍	100.0% (12) 🔍	0% (0) 🔍	75.0% (9) 🔍
software (Q7397)	12	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
research center (Q7315155)	12	25.0% (3) 🔍	100.0% (12) 🔍	0% (0) 🔍	0% (0) 🔍
drought (Q43059)	12	0% (0) 🔍	66.67% (8) 🔍	41.67% (5) 🔍	0% (0) 🔍
effects of global warming and climate change (Q1430548)	12	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
scientific model (Q193946)	12	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
industry (Q268592)	11	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
process (Q3249551)	11	0% (0) 🔍	27.27% (3) 🔍	0% (0) 🔍	0% (0) 🔍
climate change mitigation (Q898653)	11	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
government program (Q22222786)	11	0% (0) 🔍	54.55% (6) 🔍	0% (0) 🔍	0% (0) 🔍
charitable organization (Q708676)	10	0% (0) 🔍	90.0% (9) 🔍	0% (0) 🔍	0% (0) 🔍
enterprise (Q6881511)	10	0% (0) 🔍	90.0% (9) 🔍	0% (0) 🔍	0% (0) 🔍
research project (Q1298668)	10	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
position (Q4164871)	10	0% (0) 🔍	70.0% (7) 🔍	0% (0) 🔍	0% (0) 🔍
Wikipedia overview article (Q20136634)	10	0% (0) 🔍	60.0% (6) 🔍	0% (0) 🔍	0% (0) 🔍
Energy policy by country or territory (Q75880299)	9	0% (0) 🔍	77.78% (7) 🔍	0% (0) 🔍	0% (0) 🔍
public company (Q891723)	9	0% (0) 🔍	88.89% (8) 🔍	0% (0) 🔍	0% (0) 🔍
environmental issue (Q2144359)	9	0% (0) 🔍	33.33% (3) 🔍	0% (0) 🔍	0% (0) 🔍
meteorological phenomenon (Q16332653)	9	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
activist group (Q1887898)	9	0% (0) 🔍	44.44% (4) 🔍	0% (0) 🔍	0% (0) 🔍
public policy (Q546113)	9	0% (0) 🔍	44.44% (4) 🔍	0% (0) 🔍	0% (0) 🔍
environment ministry (Q917441)	9	77.78% (7) 🔍	100.0% (9) 🔍	0% (0) 🔍	44.44% (4) 🔍
Sustainable Development Goal Indicator (Q56726345)	9	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
taxon (Q16521)	8	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
laboratory (Q483242)	8	0% (0) 🔍	100.0% (8) 🔍	0% (0) 🔍	75.0% (6) 🔍
climate change (Q125928)	8	0% (0) 🔍	75.0% (6) 🔍	50.0% (4) 🔍	0% (0) 🔍
company (Q783794)	8	0% (0) 🔍	37.5% (3) 🔍	0% (0) 🔍	0% (0) 🔍
aspect of history (Q17524420)	8	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
agreement (Q321839)	7	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
scientific journal (Q5633421)	7	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
declaration (Q62662439)	7	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
atmospheric phenomenon (Q4072190)	7	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
phenomenon (Q483247)	7	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
branch of science (Q2465832)	7	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
technical standard (Q317623)	7	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
political initiative (Q15275192)	7	0% (0) 🔍	42.86% (3) 🔍	0% (0) 🔍	0% (0) 🔍
statute (Q820655)	7	0% (0) 🔍	57.14% (4) 🔍	0% (0) 🔍	0% (0) 🔍
research program (Q7315176)	7	0% (0) 🔍	42.86% (3) 🔍	0% (0) 🔍	0% (0) 🔍
events in a specific year or time period (Q18340514)	7	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
flood (Q8068)	7	0% (0) 🔍	71.43% (5) 🔍	0% (0) 🔍	0% (0) 🔍
type of chemical entity (Q113145171)	6	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
coalition (Q124964)	6	0% (0) 🔍	66.67% (4) 🔍	0% (0) 🔍	0% (0) 🔍
energy industry (Q2151621)	6	0% (0) 🔍	100.0% (6) 🔍	0% (0) 🔍	0% (0) 🔍
glacier (Q35666)	6	0% (0) 🔍	100.0% (6) 🔍	0% (0) 🔍	100.0% (6) 🔍
bill (Q686822)	6	0% (0) 🔍	83.33% (5) 🔍	0% (0) 🔍	0% (0) 🔍
advocacy group (Q431603)	6	0% (0) 🔍	100.0% (6) 🔍	0% (0) 🔍	0% (0) 🔍
scholarly article (Q13442814)	6	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
natural disaster (Q8065)	6	0% (0) 🔍	83.33% (5) 🔍	66.67% (4) 🔍	0% (0) 🔍
book (Q571)	6	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
historical period (Q11514315)	5	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
type of meteorological phenomenon (Q118733587)	5	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
world day (Q2558684)	5	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
island (Q23442)	5	0% (0) 🔍	100.0% (5) 🔍	0% (0) 🔍	80.0% (4) 🔍
controversy (Q1255828)	5	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
method (Q1799072)	5	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
technology (Q11016)	5	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
hypothesis (Q41719)	5	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
type of policy (Q96251375)	5	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
specialty (Q1047113)	5	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
pressure group (Q1666019)	5	0% (0) 🔍	60.0% (3) 🔍	0% (0) 🔍	0% (0) 🔍
United States federal agency (Q20857065)	5	60.0% (3) 🔍	100.0% (5) 🔍	0% (0) 🔍	0% (0) 🔍
Wikimedia template (Q11266439)	5	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
demonstration (Q175331)	5	0% (0) 🔍	100.0% (5) 🔍	80.0% (4) 🔍	0% (0) 🔍
Climate Action Plan (Q109767835)	5	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
protest (Q273120)	5	0% (0) 🔍	60.0% (3) 🔍	0% (0) 🔍	0% (0) 🔍
Sustainable Development Goal Target (Q56724848)	5	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
recurrent event edition (Q27968055)	5	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍	0% (0) 🔍
No grouping	1079	0.28% (3) 🔍	5.93% (64) 🔍	0.56% (6) 🔍	0.28% (3) 🔍
Totals (all items)	4410	7.51% (331) 🔍	23.58% (1040) 🔍	3.13% (138) 🔍	5.74% (253) 🔍

Timeline of creation of items within scope

The following query uses these:

• Items: WikiProject Climate change (Q15305047)   , 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:Q15305047 .}  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 Climate change (Q15305047)   

• Properties: on focus list of Wikimedia project (P5008)   

  SELECT ?sitelink ?itemLabel ?badge ?badgeLabel WHERE {
    ?item wdt:P5008 wd:Q15305047.    # 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 Climate change (Q15305047)   

• Properties: on focus list of Wikimedia project (P5008)   , image (P18)   

  SELECT ?item ?sitelink ?itemLabel ?badge ?badgeLabel WHERE {
    ?item wdt:P5008 wd:Q15305047.
    ?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!

Lexemes within scope

The following query uses these:

• Items: WikiProject Climate change (Q15305047)   

• Properties: on focus list of Wikimedia project (P5008)   , item for this sense (P5137)   

  select DISTINCT ?item ?itemLabel ?lexeme ?lemma
  where
  {
    ?item wdt:P5008 wd:Q15305047 . # item is within scope of the project
    ?item rdfs:label ?itemLabel .
    FILTER (LANG(?itemLabel) = "[AUTO_LANGUAGE]")
    ?lexeme wikibase:lemma ?lemma;
              ontolex:sense ?sense.
    ?sense wdt:P5137 ?item .
  }
  

Try it!