User:YULdigitalpreservation/shex2020

Page of SPARQL queries related to a draft

Free software

The following query uses these:

• Items: free software (Q341)   

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

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

Try it!

Software published under a free software license

The following query uses these:

• Items: software (Q7397)   , free software license (Q3943414)   

• Properties: instance of (P31)   , subclass of (P279)   , copyright license (P275)   

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

Try it!

People who have developed a piece of software

The following query uses these:

• Items: human (Q5)   , software (Q7397)   

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

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

Try it!

People who have the occupation software developer

The following query uses these:

• Items: human (Q5)   , software developer (Q183888)   

• Properties: instance of (P31)   , occupation (P106)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31 wd:Q5.
    ?item wdt:P106 wd:Q183888.
    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!

Member of the NAS academic degree

The following query uses these:

• Properties: National Academy of Sciences member ID (P5380)   , academic degree (P512)   

  SELECT ?item ?itemLabel ?id ?degreeLabel
  WHERE 
  {
    ?item wdt:P5380 ?id.
    ?item wdt:P512 ?degree.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Member of the NAS educated at w academic degree as qual

The following query uses these:

• Items: Doctor of Philosophy (Q752297)   

• Properties: National Academy of Sciences member ID (P5380)   , educated at (P69)   , academic degree (P512)   

  SELECT ?item ?itemLabel ?id ?instLabel
  WHERE 
  {
    ?item wdt:P5380 ?id. 
    ?item p:P69 [
      ps:P69 ?inst;
      pq:P512 wd:Q752297].
  
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!