User:YULdigitalpreservation/SPARQL2020

This is a page of SPARQL queries

Cryptographic Hash Functions

The following query uses these:

• Items: cryptographic hash function (Q477202)   

• Properties: instance of (P31)   , subclass of (P279)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q477202.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Subclasses of cryptographic hash function

The following query uses these:

• Items: cryptographic hash function (Q477202)   

• Properties: subclass of (P279)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P279 wd:Q477202.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

ontologies

The following query uses these:

• Items: ontology (Q324254)   

• Properties: instance of (P31)   , subclass of (P279)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q324254.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Items that have "xml namespace" property values

The following query uses these:

• Properties: XML namespace URL (P7510)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P7510 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

ontologies w count of statements

The following query uses these:

• Items: ontology (Q324254)   

• Properties: instance of (P31)   , subclass of (P279)   

  SELECT ?item ?itemLabel ?statementscount
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q324254;
     wikibase:statements ?statementscount.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Influenced by Quentin Matsys

The following query uses these:

• Items: Quinten Metsys (Q314275)   

• Properties: influenced by (P737)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P737 wd:Q314275.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Members of Zigbee Alliance

The following query uses these:

• Items: Zigbee Alliance (Q79100838)   

• Properties: member of (P463)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P463 wd:Q79100838.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Businesses that are part of the CAC 40

The following query uses these:

• Items: CAC 40 (Q648828)   

• Properties: part of (P361)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P361 wd:Q648828.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

markup languages

The following query uses these:

• Items: markup language (Q37045)   

• Properties: instance of (P31)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31 wd:Q37045.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

orgs w id in Manuals library

The following query uses these:

• Properties: ManualsLib brand ID (P6422)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P6422 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

items w central index key

The following query uses these:

• Properties: Central Index Key (P5531)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P5531 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

members of fido alliance

The following query uses these:

• Items: FIDO Alliance (Q15731702)   

• Properties: member of (P463)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P463 wd:Q15731702.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

submarine communications cables

The following query uses these:

• Items: submarine communications cable (Q506572)   

• Properties: instance of (P31)   , subclass of (P279)   

  SELECT DISTINCT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q506572.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

uses of data size

The following query uses these:

• Properties: data size (P3575)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P3575 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

items that support programming languages

The following query uses these:

• Properties: supports programming language (P3985)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P3985 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

communications satellites

The following query uses these:

• Items: communications satellite (Q149918)   

• Properties: instance of (P31)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31 wd:Q149918.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

formats w puid described by source, source is avail online

The following query uses these:

• Properties: PRONOM file format ID (P2748)   , described by source (P1343)   , full work available at URL (P953)   

  SELECT ?item ?itemLabel ?puid ?sourceLabel ?url
  WHERE 
  {
    ?item wdt:P2748 ?puid.
    ?item wdt:P1343 ?source.
    ?source wdt:P953 ?url.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

standards that have a file format as a main subject

The following query uses these:

• Items: technical standard (Q317623)   , file format (Q235557)   

• Properties: instance of (P31)   , main subject (P921)   , subclass of (P279)   , file extension (P1195)   

  SELECT ?item ?itemLabel ?ext ?subjectLabel
  WHERE 
  {
    ?item wdt:P31 wd:Q317623.
    ?item wdt:P921 ?subject.
    ?subject wdt:P31/wdt:P279* wd:Q235557.
    ?subject wdt:P1195 ?ext.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

character encodings

The following query uses these:

• Items: character encoding (Q184759)   

• Properties: instance of (P31)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
     ?item wdt:P31 wd:Q184759.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

file formats that can be opened by a software title

The following query uses these:

• Items: file format (Q235557)   

• Properties: instance of (P31)   , subclass of (P279)   , readable file format (P1072)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q235557.
    ?software wdt:P1072 ?item.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

members of Jquery Foundation

The following query uses these:

• Items: jQuery Foundation (Q80656429)   

• Properties: member of (P463)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P463 wd:Q80656429.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

members of Business Software Alliance

The following query uses these:

• Items: BSA | The Software Alliance, Inc. (Q852297)   

• Properties: member of (P463)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P463 wd:Q852297.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

software titles named after a place that has a locator map image

The following query uses these:

• Items: software (Q7397)   

• Properties: instance of (P31)   , subclass of (P279)   , named after (P138)   , locator map image (P242)   

  SELECT ?item ?itemLabel ?placeLabel ?map
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q7397.
    ?item wdt:P138 ?place. 
    ?place wdt:P242 ?map.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

datapacks

The following query uses these:

• Items: data pack (Q5227330)   

• Properties: instance of (P31)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31 wd:Q5227330.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

standards approved by the OSAC Registry

The following query uses these:

• Items: OSAC Registry (Q84081043)   

• Properties: approved by (P790)   , title (P1476)   

  SELECT ?item ?itemLabel ?title
  WHERE 
  {
    ?item wdt:P790 wd:Q84081043.
    OPTIONAL {?item wdt:P1476 ?title}.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

software titles with Microsoft Academic ID

The following query uses these:

• Items: software (Q7397)   

• Properties: instance of (P31)   , subclass of (P279)   , Microsoft Academic ID (P6366)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q7397.
    ?item wdt:P6366 ?microsoftAcademic.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

software types by count of titles

The following query uses these:

• Items: software category (Q17155032)   

• Properties: instance of (P31)   

  SELECT ?item ?itemLabel (COUNT (?title) as ?count)
  WHERE 
  {
    ?item wdt:P31 wd:Q17155032.
    ?title wdt:P31 ?item.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  GROUP BY ?item ?itemLabel
  
  
  ORDER BY DESC(?count)
  

Try it!

Projects of the Linux Foundation

The following query uses these:

• Items: Linux Foundation Project (Q39998995)   

• Properties: instance of (P31)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31  wd:Q39998995.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Items with a Can You Run It? id

The following query uses these:

• Properties: Can You Run it ID (P7909)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P7909 ?value. 
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Software titles with a commons category link

The following query uses these:

• Items: software (Q7397)   

• Properties: instance of (P31)   , subclass of (P279)   , Commons category (P373)   

  SELECT DISTINCT ?item ?itemLabel ?commons
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q7397.
    ?item wdt:P373 ?commons.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Computer scientists whose last words have been recorded in WD

The following query uses these:

• Items: computer scientist (Q82594)   

• Properties: occupation (P106)   , last words (P3909)   

  SELECT ?item ?itemLabel ?lastwords
  WHERE 
  {
    ?item wdt:P106 wd:Q82594.
    ?item wdt:P3909 ?lastwords.
  
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

People credited with the development of one or more software titles who are vegans

The following query uses these:

• Items: veganism (Q181138)   

• Properties: developer (P178)   , lifestyle (P1576)   

  SELECT ?item ?itemLabel ?dev ?devLabel ?style ?styleLabel
  WHERE 
  {
    
    ?item wdt:P178 ?dev.
    ?dev wdt:P1576 wd:Q181138
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

File formats with FFID, encoding, offset and relative to info

The following query uses these:

• Properties: file format identification pattern (P4152)   , encoding (P3294)   , offset (P4153)   , relative to (P2210)   

  SELECT DISTINCT ?item ?itemLabel ?value ?valueLabel ?ofset ?to WHERE {
    ?item wdt:P4152 ?url.
    ?item p:P4152 _:b6.
    _:b6 pq:P3294 ?value.
    _:b6 pq:P4153 ?ofset.
    _:b6 pq:P2210 ?to.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Foundations in the US and their founders

The following query uses these:

• Items: foundation (Q157031)   , United States of America (Q30)   

• Properties: instance of (P31)   , country (P17)   , founded by (P112)   

  SELECT ?item ?itemLabel ?founder ?founderLabel
  WHERE 
  {
    ?item wdt:P31 wd:Q157031.
    ?item wdt:P17 wd:Q30.
    ?item wdt:P112 ?founder.
    
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Businesses in the software industry with a WorldCat Identifiers ID

The following query uses these:

• Items: business (Q4830453)   , software industry (Q880371)   

• Properties: instance of (P31)   , subclass of (P279)   , industry (P452)   , WorldCat Identities ID (superseded) (P7859)   

  SELECT ?item ?itemLabel ?worldCatIdentitiesID
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q4830453.
    ?item wdt:P452 wd:Q880371.
    ?item wdt:P7859 ?worldCatIdentitiesID.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Software titles whose developer has a worldcat identity id

The following query uses these:

• Items: software (Q7397)   

• Properties: instance of (P31)   , subclass of (P279)   , developer (P178)   , WorldCat Identities ID (superseded) (P7859)   

  SELECT ?item ?itemLabel ?worldCatIdentitiesID
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q7397.
    ?item wdt:P178 ?company.
    ?company wdt:P7859 ?worldCatIdentitiesID.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Members of the SD Association

The following query uses these:

• Items: SD Association (Q7389502)   

• Properties: member of (P463)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P463 wd:Q7389502.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

File formats based on OLE2

The following query uses these:

• Items: Compound File Binary File Format (Q5156830)   

• Properties: based on (P144)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P144 wd:Q5156830.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

File formats w LOC FDD but no pronom

The following query uses these:

• Items: file format (Q235557)   

• Properties: instance of (P31)   , subclass of (P279)   , Library of Congress Format Description Document ID (P3266)   , PRONOM file format ID (P2748)   

  SELECT ?item ?itemLabel ?fdd
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q235557.
    ?item wdt:P3266 ?fdd.
    FILTER(NOT EXISTS { ?item wdt:P2748 ?puid. })
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

de facto standards named after people

The following query uses these:

• Items: de facto standard (Q385853)   , human (Q5)   

• Properties: instance of (P31)   , named after (P138)   

  SELECT ?item ?itemLabel ?person ?personLabel
  WHERE 
  {
    ?item wdt:P31 wd:Q385853.
    ?item wdt:P138 ?person.
    ?person wdt:P31 wd:Q5.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Companies/brands with manuals library brand id

The following query uses these:

• Properties: ManualsLib brand ID (P6422)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P6422 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Companies that produce software with a catchphrase

The following query uses these:

• Items: business (Q4830453)   , software (Q7397)   

• Properties: instance of (P31)   , product or material produced or service provided (P1056)   , catchphrase (P6251)   

  SELECT ?item ?itemLabel ?phrase
  WHERE 
  {
    ?item wdt:P31 wd:Q4830453.
    ?item wdt:P1056 wd:Q7397.
    ?item wdt:P6251 ?phrase.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Items that are file formats and technical standards

The following query uses these:

• Items: technical standard (Q317623)   , file format (Q235557)   

• Properties: instance of (P31)   , subclass of (P279)   

  SELECT DISTINCT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q317623.
    ?item wdt:P31/wdt:P279* wd:Q235557.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Map with Layers by PUID of hq locations of format developer

The following query uses these:

• Properties: PRONOM file format ID (P2748)   , developer (P178)   , headquarters location (P159)   , coordinate location (P625)   

Features: map (Q24515275)   

#defaultView:Map{"layer": "?pro"}
SELECT ?dev ?devLabel ?location ?locationLabel ?hqLabel ?coord ?pro WHERE {
  ?item wdt:P2748 ?pro.
  ?item wdt:P178 ?dev.
  ?dev wdt:P159 ?hq.
  ?hq wdt:P625 ?coord.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

File formats + date modified

The following query uses these:

• Items: file format (Q235557)   

• Properties: instance of (P31)   , subclass of (P279)   

  SELECT ?item ?itemLabel ?date_modified
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q235557;
     schema:dateModified ?date_modified .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  

Try it!

File format families that do not have a pronom identifier

The following query uses these:

• Items: file format family (Q26085352)   

• Properties: instance of (P31)   , PRONOM file format ID (P2748)   , subclass of (P279)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31 wd:Q26085352.
    FILTER NOT EXISTS {?item wdt:P2748 ?pronom}.
    #?format wdt:P279 ?item.
    #?format wdt:P2748 ?pronom.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Software categories that are not subclasses of software 252 of these on 29 may 2020

The following query uses these:

• Items: software category (Q17155032)   , software (Q7397)   

• Properties: instance of (P31)   , subclass of (P279)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31 wd:Q17155032.
    FILTER NOT EXISTS {?item wdt:P279 wd:Q7397}.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Software categories that are subclasses of software

There are 46 on 29 may 2020

The following query uses these:

• Items: file format family (Q26085352)   

• Properties: instance of (P31)   , PRONOM file format ID (P2748)   , subclass of (P279)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31 wd:Q26085352.
    FILTER NOT EXISTS {?item wdt:P2748 ?pronom}.
    #?format wdt:P279 ?item.
    #?format wdt:P2748 ?pronom.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Software w maintainer

The following query uses these:

• Items: software (Q7397)   

• Properties: instance of (P31)   , subclass of (P279)   , maintained by (P126)   

  SELECT ?item ?itemLabel ?maintainerLabel
  WHERE 
  {
    ?item wdt:P31/wdt:P279* wd:Q7397.
    ?item wdt:P126 ?maintainer.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Expanded software with described at URL

The following query uses these:

• Items: software (Q7397)   , software category (Q17155032)   

• Properties: instance of (P31)   , subclass of (P279)   , described at URL (P973)   

  SELECT ?item ?itemLabel ?url
  WHERE 
  { {?item wdt:P31/wdt:P279 wd:Q7397}
   UNION
   { ?item wdt:P31 ?class.
    {?class wdt:P279* wd:Q7397}
    UNION
    {?class wdt:P31 wd:Q17155032}.}
   ?item wdt:P973 ?url.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!