Wikidata:WikiFactMine/Core SPARQL

From Wikidata
Jump to navigation Jump to search
WikiFactMine terrible logo.svg

This page is a repository of SPARQL queries used to construct ContentMine dictionaries, utilities, and illustrations of the graphical options in SPARQL. (Because section 2 became large, there is an extra page Wikidata:WikiFactMine/Core SPARQL/Hierarchical.)

Encyclopedic[edit]


(Encyclopedic)

WFM Dictionary No. 001

#Subset of "1000 key topics" with "medical specialty" 
SELECT DISTINCT ?item 
WHERE {
  ?item wdt:P972 wd:Q5460604 .
  ?item wdt:P1995 ?medspec  .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Baseline hits 29, on 2017-07-27


Hierarchical data[edit]


(Hierarchical)

WFM Dictionary No. 101

#Taxons with taxon rank "phylum"
SELECT DISTINCT ?item
WHERE {
  ?item wdt:P31 wd:Q16521 .
  ?item wdt:P105 wd:Q38348 .
  ?item wdt:P171 ?parent .
  ?parent wdt:P171 ?grandparent .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-10; Inception hits=177


(Hierarchical)

WFM Dictionary No. 102 (auxiliary)

#Instance of (instance of pharmaceutical drug)
SELECT ?item ?itemLabel ?dummy ?dummyLabel
WHERE {
  
  ?item wdt:P31 ?dummy .
  ?dummy wdt:P31 wd:Q12140 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-10; Inception hits=28


(Hierarchical)

WFM Dictionary No. 103 (auxiliary)

#Medical classifications
SELECT ?item ?itemLabel
  WHERE {
  ?item wdt:P31 wd:Q3518464
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
  }
Try it!

Inception date=2017-07-26; Inception hits=27


(Hierarchical)

WFM Dictionary No. 104 (auxiliary)

#Topics of classification schemes qualified by "of" (P642)
SELECT DISTINCT ?topicLabel
  WHERE {
  ?item wdt:P31 wd:Q5962346 .
  ?item p:P31 ?statement .
  ?statement pq:P642 ?topic .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
  }
Try it!

Inception date=2017-07-26; Inception hits=25


(Hierarchical)

WFM Dictionary No. 105 (auxiliary)

#Parent taxons for E. Coli, graph display
#defaultView:Graph
SELECT ?item ?itemLabel ?pic ?linkTo
WHERE
{
  wd:Q25419 wdt:P171* ?item
  OPTIONAL { ?item wdt:P171 ?linkTo }
  OPTIONAL { ?item wdt:P18 ?pic }
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}
Try it!

(Hierarchical)

WFM Dictionary No. 106

#Plant taxons contained in "Laurales".
SELECT ?item
WHERE {
  ?item wdt:P171* wd:Q21801.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-27; Inception hits=4524


(Hierarchical)

WFM Dictionary No. 107

#Plant taxons contained in "Asparagales".
SELECT ?item
WHERE {
  ?item wdt:P171* wd:Q26229.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-27; Inception hits=45323


(Hierarchical)

WFM Dictionary No. 108

#Plant taxons contained in "Alismatales".
SELECT ?item
WHERE {
  ?item wdt:P171* wd:Q27341.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-27; Inception hits=4823


(Hierarchical)

WFM Dictionary No. 109

#Plant taxons contained in "Liliales".
SELECT ?item
WHERE {
  ?item wdt:P171* wd:Q53478.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-27; Inception hits=2414


(Hierarchical)

WFM Dictionary No. 110

#Plant taxons contained in "Pandanales".
SELECT ?item
WHERE {
  ?item wdt:P171* wd:Q269303  .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-27; Inception hits=1816


(Hierarchical)

WFM Dictionary No. 111

#Plant taxons contained in "Dioscoreales".
SELECT ?item
WHERE {
  ?item wdt:P171* wd:Q747698.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-27; Inception hits=972


(Hierarchical)

WFM Dictionary No. 112

#Plant taxons contained in "Commelinids".
SELECT ?item
WHERE {
  ?item wdt:P171* wd:Q868546.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-27; Inception hits=38669


(Hierarchical)

WFM Dictionary No. 113

#Plant taxons contained in "Buxales".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21020.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-27; Inception hits=180


(Hierarchical)

WFM Dictionary No. 114

#Plant taxons contained in "Ranunculales".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21021.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-27; Inception hits=8912


(Hierarchical)

WFM Dictionary No. 115

#Plant taxons contained in "Proteales".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21838 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-27; Inception hits=2269


(Hierarchical)

WFM Dictionary No. 116

#Plant taxons contained in "Caryophyllales".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21808 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-27; Inception hits=21740


(Hierarchical)

WFM Dictionary No. 117

#Plant taxons contained in "Gunnerales".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21846 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-28; Inception hits=82


(Hierarchical)

WFM Dictionary No. 118

#Plant taxons contained in "Santalales".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21851 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-28; Inception hits=3028


(Hierarchical)

WFM Dictionary No. 119

#Plant taxons contained in "Saxifragales".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21855 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-28; Inception hits=4767


(Hierarchical)

WFM Dictionary No. 120

#Plant taxons contained in "Dilleniaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q756019 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-28; Inception hits=525


(Hierarchical)

WFM Dictionary No. 121

#Plant taxons contained in "Gunneraceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q2338324 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-28; Inception hits=75


(Hierarchical)

WFM Dictionary No. 122

#Plant taxons contained in "Vitales".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q2064321 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-28; Inception hits=1337


(Hierarchical)

WFM Dictionary No. 123

#Plant taxons contained in "Malvids".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q2133361 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-28; Inception hits=43397


(Hierarchical)

WFM Dictionary No. 124

#Plant taxons contained in "Fabids".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q2683213 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-28; Inception hits=80379


(Hierarchical)

WFM Dictionary No. 125

#Plant taxons contained in "Ericales".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21737 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-28; Inception hits=17828


(Hierarchical)

WFM Dictionary No. 126

#Plant taxons contained in "Cornales".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21769 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-28; Inception hits=1164


(Hierarchical)

WFM Dictionary No. 127

#Plant taxons contained in "Lamiids".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q2182368 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-28; Inception hits=73187


(Hierarchical)

WFM Dictionary No. 128

#Plant taxons contained in "Campanulids".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q2935471 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-28; Inception hits=54710


(Hierarchical)

WFM Dictionary No. 129

#Plant taxons contained in "Euasterids II".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q14405943 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-28; Inception hits=97


(Hierarchical)

WFM Dictionary No. 130 (auxiliary)

#Canidae mapped by genus and species.
#defaultView:TreeMap
SELECT ?family ?familyLabel  ?genus ?genusLabel ?species ?speciesLabel
WHERE 
{
  BIND(wd:Q25324 AS ?family) . 
        ?species wdt:P171 ?genus.
		?genus wdt:P171 ?family.
		
	
	SERVICE wikibase:label {  bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-28; Inception hits=130


(Hierarchical)

WFM Dictionary No. 131

#Plant taxons contained in "Orchidaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q25308 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits=33342


(Hierarchical)

WFM Dictionary No. 132

#Plant taxons contained in "Iridaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q155941 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits=2898


(Hierarchical)

WFM Dictionary No. 133

#Plant taxons contained in "Asparagaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q157167 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits=3734


(Hierarchical)

WFM Dictionary No. 134

#Plant taxons contained in "Amaryllidaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q155848 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits=2900


(Hierarchical)

WFM Dictionary No. 135

#Plant taxons contained in "Hypoxidaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q131282 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits=176


(Hierarchical)

WFM Dictionary No. 136

#Plant taxons contained in "Xanthorrhoeaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q749826 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits=2162


(Hierarchical)

WFM Dictionary No. 137

#Plant taxons contained in "Tecophilaeaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q331169 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits=38


(Hierarchical)

WFM Dictionary No. 138

#Plant taxons contained in "Alliaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q14554991 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits=7


(Hierarchical)

WFM Dictionary No. 139

#Plant taxons contained in "Dendrochilum:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q2720025 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits=289


(Hierarchical)

WFM Dictionary No. 140

#Plant taxons contained in "Polystachya:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q2333118 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits=257


(Hierarchical)

WFM Dictionary No. 141

#Plant taxons contained in "Cyrtochilum:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q8353041 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits=146


(Hierarchical)

WFM Dictionary No. 142

#Plant taxons contained in "Angraecum:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21139 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits= 248


(Hierarchical)

WFM Dictionary No. 143

#Plant taxons contained in "Appendicula:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q133794 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits=144


(Hierarchical)

WFM Dictionary No. 144

#Plant taxons contained in "Cynorkis:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q1318743 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits= 164


(Hierarchical)

WFM Dictionary No. 145

#Plant taxons contained in "Poales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q28502 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits= 31394


(Hierarchical)

WFM Dictionary No. 146

#Plant taxons contained in "Zingiberales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q203779 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits= 3036


(Hierarchical)

WFM Dictionary No. 147

#Plant taxons contained in "Commelinales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q290349 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits=1065


(Hierarchical)

WFM Dictionary No. 148

#Plant taxons contained in "Dasypogonaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q133221 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits= 30


(Hierarchical)

WFM Dictionary No. 149

#Plant taxons contained in "Arecales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q1096533 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-02; Inception hits=3149


(Hierarchical)

WFM Dictionary No. 150

#Plant taxons contained in "Malpighiales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21887 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits=23261


(Hierarchical)

WFM Dictionary No. 151

#Plant taxons contained in "Rosales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21895 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 15513


(Hierarchical)

WFM Dictionary No. 152

#Plant taxons contained in "Cucurbitales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21875 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits=3761


(Hierarchical)

WFM Dictionary No. 153

#Plant taxons contained in "Fagales".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21881 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 2242


(Hierarchical)

WFM Dictionary No. 154

#Plant taxons contained in "Oxalidales".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21891 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 2406


(Hierarchical)

WFM Dictionary No. 155

#Plant taxons contained in "Fabales".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21878 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 30944


(Hierarchical)

WFM Dictionary No. 156

#Plant taxons contained in "Celastrales".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21870 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 1924


(Hierarchical)

WFM Dictionary No. 157

#Plant taxons contained in "Zygophyllales".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21899 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 445


(Hierarchical)

WFM Dictionary No. 158

#Plant taxons contained in "Cactaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q14560 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 4900


(Hierarchical)

WFM Dictionary No. 159

#Plant taxons contained in "Caryophyllaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q25995 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 4382


(Hierarchical)

WFM Dictionary No. 160

#Plant taxons contained in "Aizoaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q156219 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 2687


(Hierarchical)

WFM Dictionary No. 161

#Plant taxons contained in "Amaranthaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q155931 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 3409


(Hierarchical)

WFM Dictionary No. 162

#Plant taxons contained in "Nyctaginaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q156227 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 484


(Hierarchical)

WFM Dictionary No. 163

#Plant taxons contained in "Polygonaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q156117 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 2507


(Hierarchical)

WFM Dictionary No. 164

#Plant taxons contained in "Plumbaginaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q156141 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 839


(Hierarchical)

WFM Dictionary No. 165

#Plant taxons contained in "Montiaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q1200455 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 293


(Hierarchical)

WFM Dictionary No. 166

#Plant taxons contained in "Chenopodiaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q157881 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 927


(Hierarchical)

WFM Dictionary No. 167

#Plant taxons contained in "Phytolaccaceae".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q156981 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 80


(Hierarchical)

WFM Dictionary No. 168

#Plant taxons contained in "Portulacaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q521874 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 279


(Hierarchical)

WFM Dictionary No. 169

#Plant taxons contained in "Droseraceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q156185 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 276


(Hierarchical)

WFM Dictionary No. 170

#Plant taxons contained in "Tamaricaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q161244. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 131


(Hierarchical)

WFM Dictionary No. 171

#Plant taxons contained in "Malvales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21908. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 9174


(Hierarchical)

WFM Dictionary No. 172

#Plant taxons contained in "Sapindales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q26316. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 9301


(Hierarchical)

WFM Dictionary No. 173

#Plant taxons contained in "Myrtales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21866. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 16258


(Hierarchical)

WFM Dictionary No. 174

#Plant taxons contained in "Brassicales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21904. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 7285

(Hierarchical)

WFM Dictionary No. 175

#Plant taxons contained in "Geraniales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q14272. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 1169


(Hierarchical)

WFM Dictionary No. 176

#Plant taxons contained in "Crossosomatales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21860. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 114


(Hierarchical)

WFM Dictionary No. 177

#Plant taxons contained in "Ericaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q975872. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 5865


(Hierarchical)

WFM Dictionary No. 178

#Plant taxons contained in "Sapotaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q158981 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 1508


(Hierarchical)

WFM Dictionary No. 179

#Plant taxons contained in "Primulaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q157115 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 4187


(Hierarchical)

WFM Dictionary No. 180

#Plant taxons contained in "Polemoniaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q157168 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 679


(Hierarchical)

WFM Dictionary No. 181

#Plant taxons contained in "Theaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q156574 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 1339


(Hierarchical)

WFM Dictionary No. 182

#Plant taxons contained in "Lecythidaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q161929 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits=383


(Hierarchical)

WFM Dictionary No. 183

#Plant taxons contained in "Pentaphylacaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q132719 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 605


(Hierarchical)

WFM Dictionary No. 184

#Plant taxons contained in "Styracaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q877464 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 216


(Hierarchical)

WFM Dictionary No. 185

#Plant taxons contained in "Marcgraviaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q132350 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 173


(Hierarchical)

WFM Dictionary No. 186

#Plant taxons contained in "Ebenaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q156669 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 988


(Hierarchical)

WFM Dictionary No. 187

#Plant taxons contained in "Actinidiaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q156666 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 511


(Hierarchical)

WFM Dictionary No. 188

#Plant taxons contained in "Boraginaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q26568 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 4786


(Hierarchical)

WFM Dictionary No. 189

#Plant taxons contained in "Icacinaceae:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q133316 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 278


(Hierarchical)

WFM Dictionary No. 190

#Plant taxons contained in "Lamiales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21742 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits=34934


(Hierarchical)

WFM Dictionary No. 191

#Plant taxons contained in "Solanales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21723 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 6056


(Hierarchical)

WFM Dictionary No. 192

#Plant taxons contained in "Gentianales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21754 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 27090


(Hierarchical)

WFM Dictionary No. 193

#Plant taxons contained in "Asterales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21730 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 40046


(Hierarchical)

WFM Dictionary No. 194

#Plant taxons contained in "Apiales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21138 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 12529


(Hierarchical)

WFM Dictionary No. 195

#Plant taxons contained in "Dipsacales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21774 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 1933


(Hierarchical)

WFM Dictionary No. 196

#Plant taxons contained in "Aquifoliales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q21779 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 958


(Hierarchical)

WFM Dictionary No. 197

#Plant taxons contained in "Bruniales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q132694 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 117


(Hierarchical)

WFM Dictionary No. 198

#Plant taxons contained in "Escalloniales:".
SELECT ?item 
WHERE {
  ?item wdt:P171* wd:Q2274399 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-08-03; Inception hits= 105


For overflow numbers 11xx see Wikidata:WikiFactMine/Core SPARQL/Hierarchical.

Metadata[edit]


(Metadata)

WFM Dictionary No. 201 (auxiliary)

#Scientific papers without "main subject"
SELECT ?item WHERE {
  ?item wdt:P31 wd:Q13442814 .
  OPTIONAL { ?item wdt:P921 ?dummy0 }
  FILTER(!bound(?dummy0))
}
Try it!

Inception date=2017-07-10; Inception hits=1071302


(Metadata)

WFM Dictionary No. 202 (auxiliary)

#Sample of the citation graph for papers with "sulphasalazine" in the title.
#defaultView:Graph
SELECT ?item ?itemLabel ?paper ?paperLabel
WHERE
{
  ?item wdt:P31 wd:Q13442814.
  ?item wdt:P1476 ?title
  OPTIONAL { ?item wdt:P2860 ?paper. }
  FILTER regex (?title, "sulphasalazine")
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }  
}
LIMIT 25
Try it!

Inception date=2017-07-10 Limited to 25 hits


(Metadata)

WFM Dictionary No. 203 (auxiliary)

#Described by source that is a part of the Victoria County History
SELECT ?item ?itemLabel ?ref ?refLabel WHERE {

  ?item wdt:P1343 ?ref .
  ?ref wdt:P361? wd:Q7926668
           
    SERVICE wikibase:label {
        bd:serviceParam wikibase:language "en" .
    }
}
Try it!

Inception date=2017-07-31 Inception hits=3


Life sciences and medical[edit]


(Life sciences)

WFM Dictionary No. 301 (auxiliary)

#Instance of disease, medical speciality endocrinology
SELECT ?item ?itemLabel
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 wd:Q162606 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-10; Inception hits=242


(Life sciences)

WFM Dictionary No. 302

#Diseases of medical genetics. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q1071953 .
 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-08-01; Inception hits=670


(Life sciences)

WFM Dictionary No. 303

#Infectious diseases. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q788926 .
 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=417


(Life sciences)

WFM Dictionary No. 304

#Diseases of endocrinology. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q162606 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-08-01; Inception hits=283


(Life sciences)

WFM Dictionary No. 305

#Diseases within oncology. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q162555 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=451


(Life sciences)

WFM Dictionary No. 306

#Diseases within neurology. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q83042 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=924


(Life sciences)

WFM Dictionary No. 307

#Diseases within psychiatry. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q7867 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=168


(Life sciences)

WFM Dictionary No. 308

#Diseases within dermatology. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q171171 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=163


(Life sciences)

WFM Dictionary No. 309

#Diseases within gastroenterology. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q120569 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=252


(Life sciences)

WFM Dictionary No. 310

#Diseases within rheumatology. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q327657 .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=163


(Life sciences)

WFM Dictionary No. 311

#Diseases within ophthalmology. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q161437 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=101


(Life sciences)

WFM Dictionary No. 312

#Diseases within hematology. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q103824 .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=123


(Life sciences)

WFM Dictionary No. 313

#Diseases within urology. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q105650 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=202


(Life sciences)

WFM Dictionary No. 314

#Diseases within cardiology. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q10379 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=246


(Life sciences)

WFM Dictionary No. 315

#Diseases within pulmonology. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q203337 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=131


(Life sciences)

WFM Dictionary No. 316

#Diseases within emergency medicine. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q2861470 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=54


(Life sciences)

WFM Dictionary No. 317

#Diseases within immunology. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q101929 .
 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=38


(Life sciences)

WFM Dictionary No. 318

#Diseases within pediatrics. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q123028 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=29


(Life sciences)

WFM Dictionary No. 319

#Diseases within obstetrics. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q5284418 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=27


(Life sciences)

WFM Dictionary No. 320

#Diseases within otolaryngology. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q189553 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=18


(Life sciences)

WFM Dictionary No. 321

#Diseases within nephrology. This is a simplified production version, for automated dictionary generation. See the page history for a version that handles aliases.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q177635 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=15


(Life sciences)

WFM Dictionary No. 322

#Drugs used as treatment in medical genetics
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q1071953.
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-14; Inception hits=145


(Life sciences)

WFM Dictionary No. 323

#Drugs used as treatment for infectious diseases
SELECT DISTINCT ?item 
WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q788926 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-07-14; Inception hits=1958


(Life sciences)

WFM Dictionary No. 324

#Drugs used as treatment in endocrinology
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q162606.
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-14; Inception hits=1597


(Life sciences)

WFM Dictionary No. 325

#Drugs used as treatment in oncology
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q162555 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-14; Inception hits=1119


(Life sciences)

WFM Dictionary No. 326

#Drugs used as treatment in neurology
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q83042 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-24; Inception hits=1005


(Life sciences)

WFM Dictionary No. 327

#Drugs used as treatment in psychiatry
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q7867 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-24; Inception hits=770


(Life sciences)

WFM Dictionary No. 328

#Drugs used as treatment in dermatology
SELECT DISTINCT ?item 
WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q171171 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-24; Inception hits=1349


(Life sciences)

WFM Dictionary No. 329

#Drugs used as treatment in gastroenterology
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q120569 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-24; Inception hits=799


(Life sciences)

WFM Dictionary No. 330

#Drugs used as treatment in rheumatology
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q327657 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-24; Inception hits=897


(Life sciences)

WFM Dictionary No. 331

#Drugs used as treatment in ophthalmology
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q161437 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-24; Inception hits=334


(Life sciences)

WFM Dictionary No. 332

#Drugs used as treatment in hematology
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q103824 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-24; Inception hits=700


(Life sciences)

WFM Dictionary No. 333

#Drugs used as treatment in urology
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q105650 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-24; Inception hits=1518


(Life sciences)

WFM Dictionary No. 334

#Drugs used as treatment in cardiology
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q10379 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-24; Inception hits=1206


(Life sciences)

WFM Dictionary No. 335

#Drugs used as treatment in pulmonology
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q203337 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-24; Inception hits=1282


(Life sciences)

WFM Dictionary No. 336

#Drugs used as treatment in emergency medicine
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q2861470 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-24; Inception hits=439


(Life sciences)

WFM Dictionary No. 337

#Drugs used as treatment in immunology
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q101929 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-24; Inception hits=180


(Life sciences)

WFM Dictionary No. 338

#Drugs used as treatment in pediatrics
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q123028 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-24; Inception hits=222


(Life sciences)

WFM Dictionary No. 339

#Drugs used as treatment in obstetrics
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q5284418 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-24; Inception hits=18


(Life sciences)

WFM Dictionary No. 340

#Drugs used as treatment in otolaryngology
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q189553 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-24; Inception hits=294


(Life sciences)

WFM Dictionary No. 341

#Drugs used as treatment in nephrology
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q177635 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-07-14; Inception hits=228


(Life sciences)

WFM Dictionary No. 342 (auxiliary)

#ICD9 handling, case of "infectious and parasite diseases". Output in three columns adapted to QuickStatement input.
SELECT DISTINCT ?item ?ms1 ?ms2
WHERE {
 ?item wdt:P31 wd:Q12136 .
  ?item wdt:P493 ?icd  .
  OPTIONAL { ?item wdt:P1995 ?dummy0 }
  FILTER(!bound(?dummy0))
  BIND(SUBSTR(?icd,1,3) AS ?icd1) #drop decimal point and anything after
  BIND(CONCAT("1",?icd1) AS ?icd2) #add initial digit 1 to preserve initial zeroes
  BIND(xsd:integer(?icd2) AS ?icd3) # casting function to turn string to integer
  FILTER(1000 < ?icd3 && ?icd3 <1140)
  BIND("P1995" AS ?ms1)
  BIND("Q788926" AS ?ms2)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
      }
Try it!

Run: This query's output was run through QuickStatements by CM, 1334 to 1336 (UTC) on 2017-07-14, adding 139 instances of health specialty (P1995). As a result, the hits for No. 303 increased from 1204 (baseline) to 1719. Also the hits for No. 323 increased from 1958 to 2052.


(Life sciences)

WFM Dictionary No. 343 (auxiliary)

#ICD10 handling, case of "oncology". Output consists of items without "medical specialty" and indicated class 2, initial C, or D followed by 0, ..., 4.
SELECT DISTINCT ?item ?itemLabel
WHERE {
 ?item wdt:P31 wd:Q12136 .
  ?item wdt:P494 ?icd  .
  OPTIONAL { ?item wdt:P1995 ?dummy0 }
  FILTER(!bound(?dummy0))
  BIND(SUBSTR(?icd,1,2) AS ?icd1)
  FILTER REGEX(?icd1,'C|D')
  BIND(SUBSTR(?icd,2,3) AS ?number)
  BIND(CONCAT("1",?number) AS ?number1)
  BIND(xsd:integer(?number1) AS ?number2)
  FILTER (STRSTARTS(?icd1, 'C')||(99 < ?number2 && ?number2 < 150))
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
      }
Try it!

Inception date=2017-07-14; Inception hits=191

Comment:w:ICD-10 Chapter II: Neoplasms: With a two-letter range, and the D range being divided numerically, this is the most complex case. See w:ICD-10 for details.


(Life sciences)

WFM Dictionary No. 344

#Insecticides
SELECT ?item 
WHERE {
  ?item wdt:P31 wd:Q181322 .
  
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-24; Inception hits=1132


(Life sciences)

WFM Dictionary No. 345

#Biocides and all subclasses 
SELECT ?item 
WHERE {
  ?item wdt:P31/wdt:P279* wd:Q864939 .
  
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-24; Inception hits=2639


(Life sciences)

WFM Dictionary No. 346

SELECT ?item
#Carcinogens and subclasses
WHERE {
  ?item wdt:P31/wdt:P279* wd:Q187661 .
 
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-24; Inception hits=1131


(Life sciences)

WFM Dictionary No. 347

SELECT DISTINCT ?item 
#Conditions for which any subclass of "unconsciousness" is a symptom
WHERE {
  ?item wdt:P780 ?symptom .
  ?symptom wdt:P31|wdt:P279* wd:Q18356391 .
  
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-24; Inception hits=42


(Life sciences)

WFM Dictionary No. 348 (auxiliary)

#ICD9 handling. This query does a case analysis with 16 cases. Output in columns is adapted to QuickStatements input.
SELECT DISTINCT ?item ?itemLabel ?ms1 ?ms2
WHERE {
 ?item wdt:P31 wd:Q12136 .
  ?item wdt:P493 ?icd  .
  OPTIONAL { ?item wdt:P1995 ?dummy0 }
  FILTER(!bound(?dummy0))
  
  BIND(xsd:integer(CONCAT("1",SUBSTR(?icd,1,3))) AS ?icd1)
  #One-line processing of ICD-9 code into integer. Currently fails in a few alphanumeric cases.
  BIND((IF (1000 < ?icd1 && ?icd1 <1140, "Q788926",1/0)) AS ?spec1) #infectious disease specialty
  #Dividing by zero, deliberate introduction of error in the "else" part of IF. This causes a desired fallback in COALESCE.
  BIND((IF (1139 < ?icd1 && ?icd1 <1240, "Q162555",1/0)) AS ?spec2) #oncology
  BIND((IF (1239 < ?icd1 && ?icd1 <1260, "Q162606",1/0)) AS ?spec3a) #endocrinology
  BIND((IF (1278 < ?icd1 && ?icd1 <1280, "Q101929",1/0)) AS ?spec3b) #immunology
  BIND((IF (1279 < ?icd1 && ?icd1 <1290, "Q103824",1/0)) AS ?spec4) #hematology
  BIND((IF (1289 < ?icd1 && ?icd1 <1320, "Q7867",1/0)) AS ?spec5) #psychiatry
  BIND((IF (1319 < ?icd1 && ?icd1 <1390, "Q83042",1/0)) AS ?spec6) #neurology
  BIND((IF (1389 < ?icd1 && ?icd1 <1460, "Q10379",1/0)) AS ?spec7) #cardiology
  BIND((IF (1459 < ?icd1 && ?icd1 <1520, "Q203337",1/0)) AS ?spec8) #pulmonology
  BIND((IF (1519 < ?icd1 && ?icd1 <1580, "Q120569",1/0)) AS ?spec9) #gastroenterology
  BIND((IF (1579 < ?icd1 && ?icd1 <1630, "Q105650",1/0)) AS ?spec10) #urology
  BIND((IF (1629 < ?icd1 && ?icd1 <1680, "Q5284418",1/0)) AS ?spec11) #obstetrics
  BIND((IF (1679 < ?icd1 && ?icd1 <1710, "Q171171",1/0)) AS ?spec12) #dermatology
  BIND((IF (1709 < ?icd1 && ?icd1 <1740, "Q327657",1/0)) AS ?spec13) #rheumatology
  BIND((IF (1739 < ?icd1 && ?icd1 <1760, "Q1071953",1/0)) AS ?spec14) #medical genetics
  BIND((IF (1799 < ?icd1 && ?icd1 <2000, "Q2861470",1/0)) AS ?spec15) #emergency medicine
  
  BIND(COALESCE(?spec1,?spec2,?spec3a,?spec3b,?spec4,?spec5,?spec6,?spec7,?spec8,?spec9,?spec10,?spec11,?spec12,?spec13,?spec14,?spec15,000000) AS ?ms2)

  VALUES ?ms1 { "P1995" }
  VALUES ?ms2 { "Q788926" "Q162555" "Q162606" "Q101929" "Q103824" "Q7867" "Q83042" "Q10379" "Q203337" "Q120569" "Q105650" "Q5284418" "Q171171" "Q327657" "Q1071953" "Q2861470"}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
      }
Try it!

Inception date=2017-07-25; Inception hits=1192 Initial run 2017-07-25 of the output with QuickStatements, 1192 health specialty (P1995) statements added to Wikidata.


(Life sciences)

WFM Dictionary No. 349 (auxiliary)

#ICD10 handling, case analysis for "infectious disease" and "oncology". Output consists of items without "medical specialty".
#Set out in columns for QuickStatements, though itemLabel is not for that. Q788926 means infectious disease, Q162555 oncology.
SELECT DISTINCT ?item ?itemLabel ?ms1 ?ms2
WHERE {
 ?item wdt:P31 wd:Q12136 .
  ?item wdt:P494 ?icd  .
  OPTIONAL { ?item wdt:P1995 ?dummy0 }
  FILTER(!bound(?dummy0))
  BIND(SUBSTR(?icd,1,2) AS ?icd1)
  BIND(xsd:integer(CONCAT("1", SUBSTR(?icd,2,3))) AS ?icd2)
  BIND((IF (REGEX(?icd1,'A|B'), "Q788926",1/0)) AS ?spec1) #infectious disease 
  BIND((IF (REGEX(?icd1,'C|D') &&  (STRSTARTS(?icd1, 'C')||(?icd2 < 49)), "Q162555",1/0)) AS ?spec2) #oncology
  BIND((IF (STRSTARTS(?icd1, 'D') && (49 < ?icd2 && ?icd2 < 90), "Q103824",1/0)) AS ?spec3)  #hematology
  BIND((IF (STRSTARTS(?icd1, 'E') && (?icd2 < 36), "Q162606",1/0)) AS ?spec4) #endocrinology
  BIND((IF (STRSTARTS(?icd1, 'F') && (?icd2 < 70), "Q7867",1/0)) AS ?spec5) #psychiatry
  BIND(IF (STRSTARTS(?icd1, 'G'), "Q83042",1/0) AS ?spec6) #neurology
  BIND((IF (STRSTARTS(?icd1, 'H') && (?icd2 < 60), "Q161437",1/0)) AS ?spec7) #ophthalmology
  BIND((IF (STRSTARTS(?icd1, 'H') && (59 < ?icd2 && ?icd2 < 96), "Q189553",1/0)) AS ?spec8) #otolaryngology
  BIND(IF (STRSTARTS(?icd1, 'I'), "Q10379",1/0) AS ?spec9) #cardiology
  BIND(IF (STRSTARTS(?icd1, 'J'), "Q203337",1/0) AS ?spec10) #pulmonology
  BIND(IF (STRSTARTS(?icd1, 'K'), "Q120569",1/0) AS ?spec11) #gastroenterology
  BIND(IF (STRSTARTS(?icd1, 'L'), "Q171171",1/0) AS ?spec12) #dermatology
  BIND(IF (STRSTARTS(?icd1, 'M'), "Q327657",1/0) AS ?spec13) #rheumatology
  BIND(IF (STRSTARTS(?icd1, 'N'), "Q105650",1/0) AS ?spec14) #urology
  BIND(IF (STRSTARTS(?icd1, 'O'), "Q5284418",1/0) AS ?spec15) #obstetrics
  BIND(IF (STRSTARTS(?icd1, 'Q'), "Q1071953",1/0) AS ?spec16) #medical genetics
  BIND((IF (REGEX(?icd1,'S|T'), "Q2861470",1/0)) AS ?spec17) #emergency medicine

  BIND(COALESCE(?spec1,?spec2,?spec3,?spec4,?spec5,?spec6,?spec7,?spec8,?spec9,?spec10,?spec11,?spec12,?spec13,?spec14,?spec15,?spec16,?spec17,000000) AS ?ms2)

  VALUES ?ms1 { "P1995" }
  VALUES ?ms2 { "Q788926" "Q162555" "Q103824" "Q162606" "Q7867" "Q83042" "Q161437" "Q189553" "Q10379" "Q203337" "Q120569" "Q171171" "Q327657" "Q105650" "Q5284418" "Q1071953"  "Q2861470" }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } 
}
Try it!

Inception date=2017-07-25; Inception hits=883 On 2017-07-26, 883 statements added with QuickStatements.


(Life sciences)

WFM Dictionary No. 350 (auxiliary)

#Sites of affliction for diseases.
#This query returns very mixed results.
SELECT DISTINCT ?siteLabel
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P689 ?site .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
  }
Try it!

Inception date=2017-07-26; Inception hits=144


(Life sciences)

WFM Dictionary No. 351

#Diseases within family medicine. This is a simplified production version, for automated dictionary generation. 
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q6451760 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=13


(Life sciences)

WFM Dictionary No. 352

#Diseases within gynaecology. This is a simplified production version, for automated dictionary generation.
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12136 .
  ?item wdt:P1995 ?medspec .
  ?medspec wdt:P361* wd:Q1221899 .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 10000
Try it!

Inception date=2017-08-01; Inception hits=13


(Life sciences)

WFM Dictionary No. 353

#Drugs used as treatment in family medicine
SELECT DISTINCT ?item 
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q6451760.
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-08-01; Inception hits=123


(Life sciences)

WFM Dictionary No. 354

#Drugs used as treatment in gynaecology
SELECT DISTINCT ?item
  WHERE {
  ?item wdt:P31 wd:Q12140 .
  ?item wdt:P2175 ?condition  .
  ?condition wdt:P1995 wd:Q1221899.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 5000
Try it!

Inception date=2017-08-01; Inception hits=17


(Life sciences)

WFM Dictionary No. 355 (auxiliary)

#Genes associated with at least two diseases
#defaultView:BubbleChart
SELECT ?gene ?geneLabel ?count
WHERE 
{
  {
    SELECT ?gene (COUNT(?disease) AS ?count)    
WHERE {
        ?gene wdt:P2293 ?disease .
        ?disease wdt:P31 wd:Q12136 .
       }
  GROUP BY ?gene 
  HAVING (?count > 1)        
  }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY DESC(?count)
LIMIT 500
Try it!

Inception date=2017-08-10; Inception hits=360


(Life sciences)

WFM Dictionary No. 356

#Vaccines and subclasses, excluding "immunologic adjuvant"
SELECT ?item
WHERE
  { ?item wdt:P31/wdt:P279* wd:Q134808  .
   MINUS {?item wdt:P31 wd:Q967453  .}
  }
Try it!

Inception date=2017-08-21; Inception hits=97


(Life sciences)

WFM Dictionary No. 357

#Cell lines: instance and subclasses
SELECT DISTINCT ?item 
WHERE 
 {
   ?item wdt:P31/wdt:279* wd:Q21014462 .
    SERVICE wikibase:label {bd:serviceParam wikibase:language "en" } 
  }
Try it!

Inception date=2017-08-25; Inception hits=159


Physical sciences and mathematics[edit]


(Physical sciences)

WFM Dictionary No. 401

#Chemical compounds with "found in taxon" P703, where the taxon is other than homo sapiens.
SELECT ?item 
WHERE {
  ?item wdt:P31 wd:Q11173 .
  ?item wdt:P703 ?taxon .
  MINUS {?item wdt:P703 wd:Q15978631 .}
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-27; Inception hits=23


(Physical sciences)

WFM Dictionary No. 402 (auxiliary)

#ImageGrid for compounds "-sterone".
#defaultView:ImageGrid
SELECT DISTINCT ?item ?itemLabel ?pic
WHERE
{
	?item wdt:P31 wd:Q11173;
       rdfs:label ?itemLabel; 
       FILTER (lang(?itemLabel) = "en")  
       FILTER regex (?itemLabel, "(sterone)$")
    
	OPTIONAL { ?item wdt:P18 ?pic }
	
}
Try it!

Inception date=2017-07-27; Inception hits=175


(Physical sciences)

WFM Dictionary No. 402 (auxiliary)

#Spiral galaxies, redshifts and distance from us.
#defaultView:Dimensions
SELECT ?itemLabel ?_redshift ?_distance_from_Earth
WHERE {
  ?item wdt:P31 wd:Q2488;
   wdt:P1090 ?_redshift;
   wdt:P2583 ?_distance_from_Earth;
 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 100
Try it!

Inception date=2017-07-28; Inception hits=10


(Physical sciences)

WFM Dictionary No. 403 (auxiliary)

#Minerals by type locality
#defaultView:BubbleChart
SELECT ?locality ?localityLabel ?count
WHERE 
{
  {
    SELECT ?locality (COUNT(?mineral ) AS ?count)    
WHERE {
    ?mineral wdt:P279* wd:Q7946 . 
    ?mineral wdt:P2695 ?locality .  
        }
  GROUP BY ?locality 
  }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY DESC(?count)
LIMIT 100
Try it!

Inception date=2017-07-31


(Physical sciences)

WFM Dictionary No. 405 (auxiliary)

#Yearly discovery figures for astronomical object types, from 1950.
#defaultView:LineChart
SELECT ?year (COUNT(?class) AS ?count) ?classLabel 
WHERE
{
    ?object wdt:P31 ?class .
    ?class wdt:P31/wdt:P279* wd:Q17444909.
    ?object wdt:P575 ?time
    BIND(str(YEAR(?time)) AS ?year)
    FILTER (?time >= "1950-00-00T00:00:00Z"^^xsd:dateTime)
    SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}
}
GROUP BY ?year ?classLabel
Try it!

Inception date=2017-07-31


(Physical sciences)

WFM Dictionary No. 406

#Alloys (does not include intermetallic compounds in general), "fictional material" excluded
SELECT DISTINCT ?item
WHERE
  {
    ?item wdt:P31/wdt:P279* wd:Q37756 .
    MINUS {?item wdt:P31/wdt:P279* wd:Q15053464 .}
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }  
   }
Try it!

Inception date=2017-08-23; Inception hits=348


Technology and engineering[edit]


(Technology)

WFM Dictionary No. 501 (auxiliary)

#Aviation accidents and incidents, since 1950, sorted by operator.
#defaultView:AreaChart
SELECT ?operator (str(SAMPLE(?year)) AS ?year ) (COUNT(*) AS ?count) ?operatorLabel
WHERE 
{   
  ?item wdt:P31 wd:Q744913 .
  ?item wdt:P137 ?operator .
  ?item wdt:P585 ?time.
  
  
  BIND ( YEAR(?time) AS ?year )
  FILTER( BOUND(?operator)  )
  FILTER( BOUND(?year)  )
  FILTER( ?year > 1950 )
 SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
        }
  GROUP BY ?operator ?operatorLabel ?year
Try it!

Inception date 2017-07-31


Social sciences, law, economics, politics, business, institutions[edit]


(Social sciences)

WFM Dictionary No. 601 (auxiliary)

#defaultView:Timeline of organizations by inception
SELECT ?item ?itemLabel ?inception (SAMPLE(?image) AS ?image)
WHERE
{
	?item wdt:P279+ wd:Q43229 .
    ?item wdt:P571 ?inception .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
    OPTIONAL { ?item wdt:P18 ?image }
}
GROUP BY ?item ?itemLabel ?inception
Try it!

Inception date=2017-07-28; Inception hits=129


Geographical[edit]


(Geographical)

WFM Dictionary No. 701

#Sovereign states, not "former country"
SELECT ?item 
WHERE {
  ?item wdt:P31 wd:Q3624078 .
  MINUS { ?item wdt:P31 wd:Q3024240 }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Inception date=2017-07-10; Inception hits=198

Comment: Congress Poland (Q221457) was on original list (removed)


(Geographical)

WFM Dictionary No. 702 (auxiliary)

#Swiss municipality populations, by date of Wikidata's information. Attribution to https://stackoverflow.com/questions/45210878/how-to-project-additional-variables-from-sparql-aggregates
#defaultView:ScatterChart
SELECT ?year ?popWD WHERE {
    ?item wdt:P31 wd:Q70208.
    ?item p:P1082 ?popWDStatement.
    ?popWDStatement ps:P1082 ?popWD;
                    pq:P585 ?timeWD.
    FILTER NOT EXISTS {
        ?item wdt:P31 wd:Q70208.  
        ?item p:P1082 ?popWDStatement_.
        ?popWDStatement_ ps:P1082 ?popWD_;
                         pq:P585 ?timeWD_.
        FILTER (?timeWD_ > ?timeWD)}
  BIND(YEAR(?timeWD) AS ?year)
} 
GROUP BY ?year ?popWD
Try it!

Inception date=2017-07-31; Inception hits=215


(Geographical)

WFM Dictionary No. 703

#Soil types
SELECT ?item
WHERE 
{
  ?item wdt:P31 wd:Q10926413 .
 
  SERVICE wikibase:label {  bd:serviceParam wikibase:language "en" }
  }
Try it!

Inception date=2017-08-10; Inception hits=241


Historical, biographical[edit]


(Historical)

WFM Dictionary No. 801 (auxiliary)

#Monarchs of England and their children.
#defaultView:Tree
SELECT ?item ?itemLabel ?child ?childLabel 
WHERE {
  ?item wdt:P39 wd:Q18810062 .
  ?item wdt:P40 ?child .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Try it!

Inception date=2017-07-28; Inception hits=140


Arts, sport, culture, language, humanities etc.[edit]


(Arts and humanities)

WFM Dictionary No. 901 (auxiliary)

#Art museums of the world
#defaultView:Map
SELECT ?item ?coord
WHERE {
  ?item wdt:P31/wdt:P279* wd:Q207694.
  ?item wdt:P625 ?coord
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!

Inception date=2017-07-31 Inception hits=2954


(Arts and humanities)

WFM Dictionary No. 902 (auxiliary)

#Book publication by place, early modern period.
#defaultView:BarChart
SELECT ?placeLabel (Count(?placeLabel) AS ?count)
WHERE
{
  ?book wdt:P31 wd:Q571 .
  ?book wdt:P291 ?place .
  ?book wdt:P577 ?date .
  BIND(YEAR(?date) AS ?year)
  FILTER (1450 < ?year && ?year < 1701)

 SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?placeLabel
ORDER BY ?count
Try it!

Inception date=2017-07-31 Inception hits=32 places