Wikidata:ScienceSource project/Sparse items

From Wikidata
Jump to navigation Jump to search

This is a ScienceSource page for finding items that have nothing much on them besides a given identifier. The properties list here all apply to instance of (P31) human (Q5)

The idea is to clear the sparse items at the lowest level of hits, by adding further statements, or merging.

1 to 999[edit]

#Lone "award received" statements
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P166 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 1
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P31 wd:Q5;
             wdt:P271 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4
          )
     
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P31 wd:Q5;
             wdt:P396 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
     
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
#Lone botanical abbreviation statements
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P428 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
     
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
#Lone ORCID ID statements
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P496 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
     
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }

LIMIT 20
Try it!
#Mathematics Genealogy Project ID statements
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P549 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
#Czech National Library Authority statements
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P691 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 1
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P864 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
#ResearcherID statements
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P902 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!

1000 to 1999[edit]

SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P1007 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 3
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P1026 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
#ResearcherID statements
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P1053 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
#ResearcherID statements
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P1416 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!

2000 to 2999[edit]

#Zoobank author ID
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P2006 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P2080 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 3
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P2381 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
#DBLP author ID
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P2456 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
           
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P2861 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 5
           
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!

3000 to 3999[edit]

#Polish scientist ID statements
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P3124 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P3159 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P3226 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 10
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P3762 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 3
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P3885 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 3
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!

4000 to 4999[edit]

#Lone Semantic Scholar statements
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P4012 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
#BHL Creator ID statements
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P4081 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P31 wd:Q5.
        ?thesis wdt:P50 ?item;
               wdt:P4536 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!

5000 to 5999[edit]

SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P31 wd:Q5;

            wdt:P5034 ?subject.
    ?item wikibase:statements ?statementcount.
  FILTER ( ?statementcount = 4
         )
 
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 }
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P5068 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P5375 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P5415 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 5
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P5463 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P5715 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 3
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P5739 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!

6000 to 6999[edit]

SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P6023 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P6100 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P6231 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P6282 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 9
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P6465 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2
          )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
#Lone IEEE Xplore statements
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P6479 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 3 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P6556 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 7 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P6594 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P6734 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P6815 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 5 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!

7000 to 7999[edit]

SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P31 wd:Q5;
          wdt:P7305 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 5 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P31 wd:Q5;
          wdt:P7502 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 5 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P31 wd:Q5;
          wdt:P7758 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 3 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P31 wd:Q5;
          wdt:P7783 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 5 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P31 wd:Q5;
          wdt:P7842 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 5 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!

8000 to 8999[edit]

SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P8130 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 3 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P8446 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 3 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P8613 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P8914 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!

9000 to 9999[edit]

SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P9037 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P9097 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 6 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P9776 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 3 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P9913 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P9985 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!

10000 to 10999[edit]

SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P10055 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!

11000 to 11999[edit]

SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P11003 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P11249 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 3 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P11303 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P11496 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 2 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P11597 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P31 wd:Q5;
             wdt:P11686 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P31 wd:Q5;
             wdt:P11720 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  }
Try it!
SELECT DISTINCT ?item ?subject ?itemLabel

WHERE {?item wdt:P31 wd:Q5;
             wdt:P11730 ?subject.
     ?item wikibase:statements ?statementcount.
   FILTER ( ?statementcount = 4 )
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  }
Try it!