Wikidata:WikiFactMine/Core SPARQL
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" }
}
Baseline hits 29, on 2017-07-27
Hierarchical data[edit]
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" }
}
Inception date=2017-07-10; Inception hits=177
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" }
}
Inception date=2017-07-10; Inception hits=28
WFM Dictionary No. 103 (auxiliary)
#Medical classifications
SELECT ?item ?itemLabel
WHERE {
?item wdt:P31 wd:Q3518464
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Inception date=2017-07-26; Inception hits=27
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" }
}
Inception date=2017-07-26; Inception hits=25
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" }
}
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" }
}
Inception date=2017-07-27; Inception hits=4524
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" }
}
Inception date=2017-07-27; Inception hits=45323
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" }
}
Inception date=2017-07-27; Inception hits=4823
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" }
}
Inception date=2017-07-27; Inception hits=2414
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" }
}
Inception date=2017-07-27; Inception hits=1816
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" }
}
Inception date=2017-07-27; Inception hits=972
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" }
}
Inception date=2017-07-27; Inception hits=38669
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" }
}
Inception date=2017-07-27; Inception hits=180
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" }
}
Inception date=2017-07-27; Inception hits=8912
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" }
}
Inception date=2017-07-27; Inception hits=2269
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" }
}
Inception date=2017-07-27; Inception hits=21740
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" }
}
Inception date=2017-07-28; Inception hits=82
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" }
}
Inception date=2017-07-28; Inception hits=3028
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" }
}
Inception date=2017-07-28; Inception hits=4767
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" }
}
Inception date=2017-07-28; Inception hits=525
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" }
}
Inception date=2017-07-28; Inception hits=75
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" }
}
Inception date=2017-07-28; Inception hits=1337
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" }
}
Inception date=2017-07-28; Inception hits=43397
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" }
}
Inception date=2017-07-28; Inception hits=80379
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" }
}
Inception date=2017-07-28; Inception hits=17828
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" }
}
Inception date=2017-07-28; Inception hits=1164
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" }
}
Inception date=2017-07-28; Inception hits=73187
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" }
}
Inception date=2017-07-28; Inception hits=54710
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" }
}
Inception date=2017-07-28; Inception hits=97
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" }
}
Inception date=2017-07-28; Inception hits=130
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" }
}
Inception date=2017-08-02; Inception hits=33342
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" }
}
Inception date=2017-08-02; Inception hits=2898
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" }
}
Inception date=2017-08-02; Inception hits=3734
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" }
}
Inception date=2017-08-02; Inception hits=2900
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" }
}
Inception date=2017-08-02; Inception hits=176
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" }
}
Inception date=2017-08-02; Inception hits=2162
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" }
}
Inception date=2017-08-02; Inception hits=38
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" }
}
Inception date=2017-08-02; Inception hits=7
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" }
}
Inception date=2017-08-02; Inception hits=289
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" }
}
Inception date=2017-08-02; Inception hits=257
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" }
}
Inception date=2017-08-02; Inception hits=146
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" }
}
Inception date=2017-08-02; Inception hits= 248
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" }
}
Inception date=2017-08-02; Inception hits=144
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" }
}
Inception date=2017-08-02; Inception hits= 164
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" }
}
Inception date=2017-08-02; Inception hits= 31394
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" }
}
Inception date=2017-08-02; Inception hits= 3036
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" }
}
Inception date=2017-08-02; Inception hits=1065
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" }
}
Inception date=2017-08-02; Inception hits= 30
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" }
}
Inception date=2017-08-02; Inception hits=3149
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" }
}
Inception date=2017-08-03; Inception hits=23261
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" }
}
Inception date=2017-08-03; Inception hits= 15513
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" }
}
Inception date=2017-08-03; Inception hits=3761
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" }
}
Inception date=2017-08-03; Inception hits= 2242
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" }
}
Inception date=2017-08-03; Inception hits= 2406
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" }
}
Inception date=2017-08-03; Inception hits= 30944
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" }
}
Inception date=2017-08-03; Inception hits= 1924
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" }
}
Inception date=2017-08-03; Inception hits= 445
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" }
}
Inception date=2017-08-03; Inception hits= 4900
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" }
}
Inception date=2017-08-03; Inception hits= 4382
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" }
}
Inception date=2017-08-03; Inception hits= 2687
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" }
}
Inception date=2017-08-03; Inception hits= 3409
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" }
}
Inception date=2017-08-03; Inception hits= 484
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" }
}
Inception date=2017-08-03; Inception hits= 2507
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" }
}
Inception date=2017-08-03; Inception hits= 839
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" }
}
Inception date=2017-08-03; Inception hits= 293
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" }
}
Inception date=2017-08-03; Inception hits= 927
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" }
}
Inception date=2017-08-03; Inception hits= 80
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" }
}
Inception date=2017-08-03; Inception hits= 279
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" }
}
Inception date=2017-08-03; Inception hits= 276
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" }
}
Inception date=2017-08-03; Inception hits= 131
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" }
}
Inception date=2017-08-03; Inception hits= 9174
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" }
}
Inception date=2017-08-03; Inception hits= 9301
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" }
}
Inception date=2017-08-03; Inception hits= 16258
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" }
}
Inception date=2017-08-03; Inception hits= 7285
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" }
}
Inception date=2017-08-03; Inception hits= 1169
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" }
}
Inception date=2017-08-03; Inception hits= 114
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" }
}
Inception date=2017-08-03; Inception hits= 5865
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" }
}
Inception date=2017-08-03; Inception hits= 1508
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" }
}
Inception date=2017-08-03; Inception hits= 4187
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" }
}
Inception date=2017-08-03; Inception hits= 679
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" }
}
Inception date=2017-08-03; Inception hits= 1339
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" }
}
Inception date=2017-08-03; Inception hits=383
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" }
}
Inception date=2017-08-03; Inception hits= 605
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" }
}
Inception date=2017-08-03; Inception hits= 216
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" }
}
Inception date=2017-08-03; Inception hits= 173
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" }
}
Inception date=2017-08-03; Inception hits= 988
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" }
}
Inception date=2017-08-03; Inception hits= 511
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" }
}
Inception date=2017-08-03; Inception hits= 4786
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" }
}
Inception date=2017-08-03; Inception hits= 278
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" }
}
Inception date=2017-08-03; Inception hits=34934
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" }
}
Inception date=2017-08-03; Inception hits= 6056
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" }
}
Inception date=2017-08-03; Inception hits= 27090
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" }
}
Inception date=2017-08-03; Inception hits= 40046
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" }
}
Inception date=2017-08-03; Inception hits= 12529
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" }
}
Inception date=2017-08-03; Inception hits= 1933
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" }
}
Inception date=2017-08-03; Inception hits= 958
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" }
}
Inception date=2017-08-03; Inception hits= 117
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" }
}
Inception date=2017-08-03; Inception hits= 105
For overflow numbers 11xx see Wikidata:WikiFactMine/Core SPARQL/Hierarchical.
Metadata[edit]
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))
}
Inception date=2017-07-10; Inception hits=1071302
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
Inception date=2017-07-10 Limited to 25 hits
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" .
}
}
Inception date=2017-07-31 Inception hits=3
Life sciences and medical[edit]
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" }
}
Inception date=2017-07-10; Inception hits=242
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
Inception date=2017-08-01; Inception hits=670
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
Inception date=2017-08-01; Inception hits=417
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
Inception date=2017-08-01; Inception hits=283
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
Inception date=2017-08-01; Inception hits=451
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
Inception date=2017-08-01; Inception hits=924
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
Inception date=2017-08-01; Inception hits=168
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
Inception date=2017-08-01; Inception hits=163
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
Inception date=2017-08-01; Inception hits=252
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
Inception date=2017-08-01; Inception hits=163
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
Inception date=2017-08-01; Inception hits=101
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
Inception date=2017-08-01; Inception hits=123
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
Inception date=2017-08-01; Inception hits=202
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
Inception date=2017-08-01; Inception hits=246
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
Inception date=2017-08-01; Inception hits=131
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
Inception date=2017-08-01; Inception hits=54
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
Inception date=2017-08-01; Inception hits=38
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
Inception date=2017-08-01; Inception hits=29
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
Inception date=2017-08-01; Inception hits=27
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
Inception date=2017-08-01; Inception hits=18
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
Inception date=2017-08-01; Inception hits=15
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
Inception date=2017-07-14; Inception hits=145
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
Inception date=2017-07-14; Inception hits=1958
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
Inception date=2017-07-14; Inception hits=1597
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
Inception date=2017-07-14; Inception hits=1119
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
Inception date=2017-07-24; Inception hits=1005
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
Inception date=2017-07-24; Inception hits=770
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
Inception date=2017-07-24; Inception hits=1349
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
Inception date=2017-07-24; Inception hits=799
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
Inception date=2017-07-24; Inception hits=897
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
Inception date=2017-07-24; Inception hits=334
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
Inception date=2017-07-24; Inception hits=700
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
Inception date=2017-07-24; Inception hits=1518
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
Inception date=2017-07-24; Inception hits=1206
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
Inception date=2017-07-24; Inception hits=1282
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
Inception date=2017-07-24; Inception hits=439
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
Inception date=2017-07-24; Inception hits=180
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
Inception date=2017-07-24; Inception hits=222
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
Inception date=2017-07-24; Inception hits=18
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
Inception date=2017-07-24; Inception hits=294
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
Inception date=2017-07-14; Inception hits=228
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" }
}
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.
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" }
}
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.
WFM Dictionary No. 344
#Insecticides
SELECT ?item
WHERE {
?item wdt:P31 wd:Q181322 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Inception date=2017-07-24; Inception hits=1132
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" }
}
Inception date=2017-07-24; Inception hits=2639
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" }
}
Inception date=2017-07-24; Inception hits=1131
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" }
}
Inception date=2017-07-24; Inception hits=42
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" }
}
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.
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" }
}
Inception date=2017-07-25; Inception hits=883 On 2017-07-26, 883 statements added with QuickStatements.
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" }
}
Inception date=2017-07-26; Inception hits=144
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
Inception date=2017-08-01; Inception hits=13
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
Inception date=2017-08-01; Inception hits=13
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
Inception date=2017-08-01; Inception hits=123
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
Inception date=2017-08-01; Inception hits=17
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
Inception date=2017-08-10; Inception hits=360
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 .}
}
Inception date=2017-08-21; Inception hits=97
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" }
}
Inception date=2017-08-25; Inception hits=159
Physical sciences and mathematics[edit]
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" }
}
Inception date=2017-07-27; Inception hits=23
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 }
}
Inception date=2017-07-27; Inception hits=175
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
Inception date=2017-07-28; Inception hits=10
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
Inception date=2017-07-31
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
Inception date=2017-07-31
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" }
}
Inception date=2017-08-23; Inception hits=348
Technology and engineering[edit]
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
Inception date 2017-07-31
Social sciences, law, economics, politics, business, institutions[edit]
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
Inception date=2017-07-28; Inception hits=129
Geographical[edit]
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" }
}
Inception date=2017-07-10; Inception hits=198
Comment: Congress Poland (Q221457) was on original list (removed)
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
Inception date=2017-07-31; Inception hits=215
WFM Dictionary No. 703
#Soil types
SELECT ?item
WHERE
{
?item wdt:P31 wd:Q10926413 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Inception date=2017-08-10; Inception hits=241
Historical, biographical[edit]
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". }
}
Inception date=2017-07-28; Inception hits=140
Arts, sport, culture, language, humanities etc.[edit]
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". }
}
Inception date=2017-07-31 Inception hits=2954
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
Inception date=2017-07-31 Inception hits=32 places