User : YULdigitalpreservation/SPARQL2019

, vehicle normally used (P3438)  

SELECT DISTINCT ?person ?personLabel ?vehicleLabel WHERE {
  ?item (wdt:P31/wdt:P279*) wd:Q43229.
  ?item wdt:P112 ?person.
  ?person wdt:P31 wd:Q5.
  ?person wdt:P3438 ?vehicle.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Bubble chart of free software licenses approved by the FSF ranked by the number of software titles developed by research institutes edit

The following query uses these:

Items: software (Q7397)   , research institute (Q31855)   , Free Software Foundation (Q48413)

Properties: instance of (P31)   , subclass of (P279)   , developer (P178)   , copyright license (P275)   , approved by (P790)

Features: BubbleChart (Q24515280)  

#defaultView:BubbleChart
SELECT DISTINCT ?license ?licenseLabel (COUNT(?item) AS ?count) WHERE {
  ?item (wdt:P31/wdt:P279*) wd:Q7397.
  ?item wdt:P178 ?dev.
  ?dev (wdt:P31/wdt:P279*) wd:Q31855.
  ?item wdt:P275 ?license.
  ?license wdt:P790 wd:Q48413.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?license ?licenseLabel
ORDER BY DESC(?count)

People who are computer scientists who have a child who is a computer scientist edit

The following query uses these:

Items: human (Q5)   , computer scientist (Q82594)

Properties: instance of (P31)  

, occupation (P106)  

, child (P40)  

SELECT ?item ?itemLabel ?child ?childLabel
WHERE 
{
  ?item wdt:P31 wd:Q5.
  ?item wdt:P106 wd:Q82594.
  ?item wdt:P40 ?child.
  ?child wdt:P106 wd:Q82594.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

People who are members of NAS who also have a child who is a member edit

The following query uses these:

Items: human (Q5)   , National Academy of Sciences (Q270794)

Properties: instance of (P31)  

, member of (P463)  

, child (P40)  

WHERE 
{
  ?item wdt:P31 wd:Q5.
  ?item wdt:P463 wd:Q270794.
  ?item wdt:P40 ?child.
  ?child wdt:P463 wd:Q270794.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

People who are employed by the company their parent founded edit

The following query uses these:

Items: business (Q4830453)   , software (Q7397)

Properties: instance of (P31)  

, product or material produced or service provided (P1056)  

, child (P40)  

, employer (P108)  

SELECT DISTINCT ?item ?itemLabel ?founder ?founderLabel WHERE {
  ?item (wdt:P31/wdt:P279*) wd:Q4830453.
  ?item wdt:P1056 wd:Q7397.
  ?item wdt:P112 ?founder.
  ?founder wdt:P40 ?child.
  ?child wdt:P108 ?item.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

File formats published before 1985 edit

The following query uses these:

Items: file format (Q235557)

Properties: instance of (P31)  

, inception (P571)  

SELECT DISTINCT ?format ?formatLabel ?date  ?pub 
WHERE {
  ?format wdt:P31/wdt:P279* wd:Q235557.
  ?app wdt:P1072 ?format.
  OPTIONAL {?format wdt:P571 ?date}.
  OPTIONAL {?format wdt:P577 ?pub}.
  BIND (?date AS ?time)
  BIND (?pub AS ?time)
  FILTER((?time) < "1985-01-01"^^xsd:dateTime)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  
}

File formats connected to software and dates edit

The following query uses these:

Items: file format (Q235557)

Properties: instance of (P31)  

, inception (P571)  

SELECT DISTINCT ?format ?formatLabel ?time 
WHERE {
  ?format wdt:P31/wdt:P279* wd:Q235557.
  ?app wdt:P1072 ?format.
  OPTIONAL {?format wdt:P571 ?date}.
  OPTIONAL {?format wdt:P577 ?pub}.
  BIND (?date AS ?time)
  BIND (?pub AS ?time)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  
}

File formats w PUID that have not yet been connected to any software by P1072 edit

The following query uses these:

Items: file format (Q235557)

Properties: instance of (P31)  

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

File formats with Wolfram Language entity id edit

The following query uses these:

Items: file format (Q235557)

Properties: instance of (P31)  

, Wolfram Language entity code (P4839)  

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

Members of Open Media Alliance edit

The following query uses these:

Items: Alliance for Open Media (Q20947086)

Properties: member of (P463)  

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

Map of HQ of OMA members edit

The following query uses these:

Items: Alliance for Open Media (Q20947086)

Properties: member of (P463)   , headquarters location (P159)   , coordinate location (P625)

Features: map (Q24515275)  

#defaultView:Map
SELECT ?item ?itemLabel ?location ?locationLabel ?coord
WHERE 
{
  ?item wdt:P463 wd:Q20947086.
   ?item wdt:P159 ?location.
  ?location wdt:P625 ?coord.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Fellows of the ACM who have passed who have a snac id but no archives at statement edit

The following query uses these:

Items: ACM Fellow (Q18748039)

Properties: award received (P166)  

, date of death (P570)  

, SNAC ARK ID (P3430)  

, archives at (P485)  

SELECT ?item ?itemLabel ?date ?snac ?inst ?instLabel
WHERE 
{
  ?item wdt:P166 wd:Q18748039.
  ?item wdt:P570 ?date.
  OPTIONAL {?item wdt:P3430 ?snac.}
  OPTIONAL {?item wdt:P485 ?inst}.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Nobel laureats who are also ACM Fellows edit

The following query uses these:

Items: ACM Fellow (Q18748039)   , Nobel Prize (Q7191)

Properties: award received (P166)  

SELECT ?item ?itemLabel ?date ?snac ?inst ?instLabel
WHERE 
{
  ?item wdt:P166 wd:Q18748039.
  ?item wdt:P166 ?award.
  ?award wdt:P31/wdt:P279* wd:Q7191.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Audio file formats and the software that can read them edit

The following query uses these:

Items: audio file format (Q682626)   , audio coding format (Q758871)

Properties: instance of (P31)  

NCT ?item ?itemLabel ?software ?softwareLabel ("00FFFF" AS ?rgb) WHERE {
  {?item wdt:P31 wd:Q682626.}
  UNION {?item wdt:P31 wd:Q758871}.
  ?software wdt:P1072 ?item.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software that has a one-oc-a-kind computer as platform edit

The following query uses these:

Items: one-of-a-kind computer (Q28542014)

Properties: instance of (P31)  

, image (P18)  

, platform (P400)  

SELECT ?computer ?computerLabel ?software ?softwareLabel WHERE {
  ?computer wdt:P31 wd:Q28542014.
  OPTIONAL {?computer wdt:P18 ?image}.
  ?software wdt:P400 ?computer.
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  }

Orgs w ACM classification code, w stock exchange, inception edit

The following query uses these:

Items: business (Q4830453)

Properties: ACM Classification Code (2012) (P2179)  

, inception (P571)  

, stock exchange (P414)  

SELECT ?item ?itemLabel ?value ?se ?seLabel ?date WHERE {
  ?item wdt:P2179 ?value.
  ?item (wdt:P31/wdt:P279*) wd:Q4830453.
  OPTIONAL { ?item wdt:P571 ?date. }
  OPTIONAL { ?item wdt:P414 ?se. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software named after people edit

The following query uses these:

Items: software (Q7397)   , human (Q5)

Properties: instance of (P31)  

SELECT DISTINCT ?software ?softwareLabel ?person ?personLabel  WHERE {
  ?software wdt:P31/wdt:P279* wd:Q7397.
  ?software wdt:P138 ?person.
  ?person wdt:P31 wd:Q5.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }

Software titles w wine app id edit

The following query uses these:

Properties: Wine AppDB ID (P600)  

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

Youtube channels with software as a main subject edit

The following query uses these:

Items: YouTube channel (Q17558136)   , software (Q7397)

Properties: instance of (P31)  

, main subject (P921)  

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

Software titles with a youtube channel id edit

The following query uses these:

Items: software (Q7397)

Properties: instance of (P31)  

, YouTube channel ID (P2397)  

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

Implementations edit

The following query uses these:

Properties: implementation of (P4428)  

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

File formats used for 3D and the software titles that can read the formats edit

The following query uses these:

Items: file format (Q235557)   , 3D computer graphics (Q189177)

Properties: instance of (P31)  

, has use (P366)  

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

RfC from IETF with P50 edit

The following query uses these:

Items: Request for Comments (Q212971)

Properties: instance of (P31)  

, author (P50)  

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

RfC with main subject edit

The following query uses these:

Items: Request for Comments (Q212971)

Properties: instance of (P31)  

, main subject (P921)  

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

Fellows of the ACM who have supervised female doctoral students edit

The following query uses these:

Items: list of fellows of the Association for Computing Machinery (Q24883503)   , female (Q6581072)

Properties: award received (P166)  

, sex or gender (P21)  

SELECT ?item ?itemLabel ("00FFFF" AS ?rgb) ?student ?studentLabel
WHERE 
{
  ?item wdt:P166 wd:Q24883503.
  ?student wdt:P184 ?item.
  ?student wdt:P21 wd:Q6581072.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Different version of the above edit

The following query uses these:

Items: list of fellows of the Association for Computing Machinery (Q24883503)   , female (Q6581072)

Properties: award received (P166)  

, sex or gender (P21)  

SELECT ?item ?itemLabel ("00FFFF" AS ?rgb) ?student ?studentLabel
WHERE 
{
  ?item wdt:P166 wd:Q24883503.
  ?item wdt:P184 ?student.
  ?student wdt:P21 wd:Q6581072.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Emulators with developers- minus developers that are companies edit

The following query uses these:

Items: emulator (Q202871)   , business (Q4830453)

Properties: instance of (P31)  

, developer (P178)  

SELECT ?item ?itemLabel ?dev ?devLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q202871.
  ?item wdt:P178 ?dev. 
  MINUS {?dev wdt:P31/wdt:P279* wd:Q4830453.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Emulators w id in LGDB by license edit

The following query uses these:

Properties: LGDB emulator ID (P5117)  

SELECT ?item ?itemLabel ?license ?licenseLabel ?lgdb WHERE {
  ?item wdt:P5117 ?lgdb.
  OPTIONAL { ?item wdt:P275 ?license. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

All described at URL statements that include the string"computerhistory" edit

The following query uses these:

Properties: described at URL (P973)  

SELECT ?item ?url
WHERE 
{
  ?item wdt:P973 ?url.
  FILTER regex(str(?url), "computerhistory").
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

All described at URL statements that include the string "archive" edit

The following query uses these:

Properties: described at URL (P973)  

SELECT ?item ?url
WHERE 
{
  ?item wdt:P973 ?url.
  FILTER regex(str(?url), "archive").
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

with format in the URL edit

The following query uses these:

Properties: described at URL (P973)  

SELECT ?item ?url
WHERE 
{
  ?item wdt:P973 ?url.
  FILTER regex(str(?url), "format").
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

People who have worked at PARC and the educational institutions they attended edit

The following query uses these:

Items: human (Q5)   , PARC (Q750428)

Properties: instance of (P31)  

, employer (P108)  

, image (P18)  

, educated at (P69)  

SELECT ?item ?itemLabel ?image ?school ?schoolLabel ("00FFFF" AS ?rgb) WHERE {
  ?item wdt:P31 wd:Q5.
  ?item wdt:P108 wd:Q750428.
  OPTIONAL { ?item wdt:P18 ?image. }
  ?item wdt:P69 ?school.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Items with a file format as a main subject edit

The following query uses these:

Items: file format (Q235557)

Properties: main subject (P921)  

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

Versions of Windows ranked by the number of software titles that run on them edit

The following query uses these:

Items: Microsoft Windows (Q1406)

Properties: subclass of (P279)   , operating system (P306)

Features: BubbleChart (Q24515280)  

#defaultView:BubbleChart
SELECT ?app ?appLabel  (count (?software) as ?count)
WHERE {
  ?app (wdt:P279*) wd:Q1406.
  ?software wdt:P306 ?app.
  MINUS {?software wdt:P306 wd:Q1406.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

GROUP BY ?app ?appLabel 


ORDER BY DESC(?count)

Items that have EULA as license edit

The following query uses these:

Items: end-user license agreement (Q725920)

Properties: copyright license (P275)  

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

Software that has DOS as OS and the (optional) file formats they are known to read edit

The following query uses these:

Items: DOS (Q170434)

Properties: operating system (P306)  

SELECT DISTINCT ?app ?appLabel ?ff ?ffLabel 
WHERE {
  ?app wdt:P306 wd:Q170434.
  OPTIONAL {?app wdt:P1072 ?ff.}
 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software with any subclass of windows as os and the ff they are known to read edit

The following query uses these:

Items: Microsoft Windows (Q1406)

Properties: operating system (P306)  

SELECT DISTINCT ?app ?appLabel ?ff ?ffLabel WHERE {
  ?app wdt:P306 ?os.
  ?os wdt:P279     wd:Q1406.
  OPTIONAL { ?app wdt:P1072 ?ff. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

removed optional for display edit

The following query uses these:

Items: Microsoft Windows (Q1406)

Properties: operating system (P306)  

SELECT DISTINCT ?app ?appLabel ?ff ?ffLabel WHERE {
  ?app wdt:P306 ?os.
  ?os wdt:P279 wd:Q1406.
  ?app wdt:P1072 ?ff.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

==

The following query uses these:

Items: file format (Q235557)   , VIAF component (Q26921380)

Properties: instance of (P31)  

, has characteristic (P1552)  

SELECT ?software ?propItem ?value WHERE {
  ?software wdt:P31/wdt:P279* wd:Q235557.
  ?software ?prop ?value.
  ?propItem wdt:P1552 wd:Q26921380.
  ?propItem wikibase:directClaim ?prop.
}

Software titles with a bibsys id and all other external ids used for them edit

The following query uses these:

Items: software (Q7397)

Properties: instance of (P31)  

, NORAF ID (P1015)  

SELECT ?propItem ?propItemLabel ?item ?itemLabel ("00FFFF" AS ?rgb) WHERE {
  ?item (wdt:P31/wdt:P279) wd:Q7397.
  ?item wdt:P1015 ?bibsys.
  ?item ?prop ?value.
  ?propItem wikibase:directClaim ?prop.
  ?propItem wikibase:propertyType wikibase:ExternalId.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software titles with a google+account edit

The following query uses these:

Items: software (Q7397)

Properties: instance of (P31)  

, Google+ ID (P2847)  

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

Based on RIFF edit

The following query uses these:

Items: Resource Interchange File Format (Q1196805)

Properties: based on (P144)  

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

Software Libraries by # of ff readable edit

The following query uses these:

Items: software library (Q188860)

Properties: instance of (P31)  

SELECT ?item ?itemLabel  (COUNT(?format) AS ?count)
WHERE 
{
  ?item wdt:P31 wd:Q188860.
  ?item wdt:P1072 ?format.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}



GROUP BY ?item ?itemLabel 
ORDER BY DESC(?count)

File formats for which there is a Synalysis grammar file edit

The following query uses these:

Items: Synalysis grammar file (Q27823203)

Properties: described at URL (P973)  

, file format (P2701)  

SELECT DISTINCT ?item ?itemLabel WHERE {
  ?item wdt:P973 ?url.
  ?item p:P973 _:b6.
  _:b6 pq:P2701 wd:Q27823203.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

One-of-a-kind computers w heritage designation edit

The following query uses these:

Items: one-of-a-kind computer (Q28542014)

Properties: instance of (P31)  

, heritage designation (P1435)  

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

Bitcoin Exchanges by country edit

The following query uses these:

Items: bitcoin exchange (Q20107444)

Properties: instance of (P31)  

, country (P17)  

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

Businesses where a child of one of the founders has been or is currently employed edit

The following query uses these:

Items: business (Q4830453)

Properties: instance of (P31)  

, child (P40)  

, employer (P108)  

SELECT DISTINCT ?item ?itemLabel ?founder ?founderLabel ?child ?childLabel WHERE {
  ?item (wdt:P31/wdt:P279*) wd:Q4830453.
  ?item wdt:P112 ?founder.
  ?founder wdt:P40 ?child.
  ?child wdt:P108 ?item.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Graph of graphics software and their readable file formats edit

The following query uses these:

Items: graphics software (Q868410)

Properties: instance of (P31)  

SELECT DISTINCT ?ff ?ffLabel ?app ?appLabel ("00FFFF" AS ?rgb) WHERE {
  ?app (wdt:P31/wdt:P279*) wd:Q868410.
  ?app wdt:P1072 ?ff.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Password cracking software edit

The following query uses these:

Items: password cracking software (Q26921397)

Properties: instance of (P31)  

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

Discontinued software titles developed by Avira edit

The following query uses these:

Items: Avira (Q468381)

Properties: developer (P178)  

, discontinued date (P2669)  

SELECT ?item ?itemLabel ?date WHERE {
  ?item wdt:P178 wd:Q468381.
  ?item wdt:P2669 ?date.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Scientific software and the file formats they read edit

The following query uses these:

Items: software (Q7397)   , science (Q336)

Properties: instance of (P31)  

, has use (P366)  

SELECT ?item ?itemLabel ("00FFFF" AS ?rgb) ?format ?formatLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q7397.
  ?item wdt:P366 wd:Q336.
  ?item wdt:P1072 ?format.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

File formats w PUID and software known to read them edit

The following query uses these:

Properties: readable file format (P1072)  

SELECT ?software ?softwareLabel ("00FFFF" AS ?rgb) ?format ?formatLabel WHERE {
  ?software wdt:P1072 ?format.
  ?format wdt:P2748 ?pronom.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Graph of file formats w PUID and software known to read them edit

The following query uses these:

Properties: readable file format (P1072)   , PRONOM file format ID (P2748)

Features: Graph (Q24515287)  

#defaultView:Graph
SELECT ?software ?softwareLabel ("00FFFF" AS ?rgb) ?format ?formatLabel WHERE {
  ?software wdt:P1072 ?format.
  ?format wdt:P2748 ?pronom.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software titles dev by libraries edit

The following query uses these:

Items: software (Q7397)   , library (Q7075)

Properties: instance of (P31)  

, developer (P178)  

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

Software titles dev by Archives edit

The following query uses these:

Items: software (Q7397)   , archive (Q166118)

Properties: instance of (P31)  

, developer (P178)  

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

Software titles dev by Museums edit

The following query uses these:

Items: software (Q7397)   , museum (Q33506)

Properties: instance of (P31)  

, developer (P178)  

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

Giving Pledge, companies, software titles edit

The following query uses these:

Items: The Giving Pledge (Q203807)   , business (Q4830453)   , software (Q7397)

Properties: signatory (P1891)   , founded by (P112)   , image (P18)   , instance of (P31)   , subclass of (P279)   , developer (P178)

Features: Graph (Q24515287)  

#defaultView:Graph
SELECT DISTINCT ?person ?personLabel ?image ?company ?companyLabel ("00FFFF" AS ?rgb) ?software ?softwareLabel
WHERE 
{
  
  wd:Q203807 wdt:P1891 ?person.
  ?company wdt:P112  ?person. 
  ?person wdt:P18 ?image.
  ?company wdt:P31/wdt:P279* wd:Q4830453.
  ?software wdt:P178 ?company.
  ?software wdt:P31/wdt:P279* wd:Q7397.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

File formats with a Elhuyar ZTH ID edit

The following query uses these:

Items: file format (Q235557)

Properties: instance of (P31)  

, Elhuyar ZTH ID (P4746)  

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

Cad software and readable file formats edit

The following query uses these:

Items: computer-aided design software (Q15548076)

Properties: instance of (P31)  

SELECT ?app ("00FFFF" AS ?rgb) ?appLabel  ?format ?formatLabel
WHERE 
{
  ?app wdt:P31/wdt:P279* wd:Q15548076.
 
  ?app wdt:P1072 ?format.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Bubble chart of formats sharing same extension edit

The following query uses these:

Items: file format (Q235557)

Properties: subclass of (P279)   , file extension (P1195)   , instance of (P31)

Features: BubbleChart (Q24515280)  

#defaultView:BubbleChart
SELECT DISTINCT ?extension ?extensionLabel (COUNT(?format) AS ?count) WHERE {
  ?format (p:P31/ps:P31/wdt:P279*) wd:Q235557.
  ?format wdt:P1195 ?extension.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?extension ?extensionLabel
HAVING ((COUNT(?format)) > 3)
ORDER BY DESC(?count)

Bubble chart of licenses used by academic institutions edit

The following query uses these:

Items: academic institution (Q4671277)   , software (Q7397)

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

Features: BubbleChart (Q24515280)  

#defaultView:BubbleChart
SELECT DISTINCT ?license ?licenseLabel (COUNT(?software) AS ?count)
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q4671277.
  ?software wdt:P31/wdt:P279* wd:Q7397.
  ?software wdt:P178 ?item.
  ?software wdt:P275 ?license.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

GROUP BY ?license ?licenseLabel 
ORDER BY DESC(?count)

Bubble chart viz of non-profit orgs and the software licenses they use edit

The following query uses these:

Items: nonprofit organization (Q163740)   , software (Q7397)

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

Features: BubbleChart (Q24515280)  

#defaultView:BubbleChart
SELECT DISTINCT  ?license ?licenseLabel (COUNT(?software) AS ?count)
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q163740.
  ?software wdt:P31/wdt:P279* wd:Q7397.
  ?software wdt:P178 ?item.
  ?software wdt:P275 ?license.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

GROUP BY ?license ?licenseLabel 
ORDER BY DESC(?count)

Taxa named after women scientists edit

The following query uses these:

Items: taxon (Q16521)   , female (Q6581072)   , scientist (Q901)

Properties: instance of (P31)   , named after (P138)   , sex or gender (P21)   , occupation (P106)   , subclass of (P279)   , image (P18)

Features: Graph (Q24515287)  

#defaultView:Graph
SELECT ?item ("00FFFF" AS ?rgb) ?itemLabel ?person ?personLabel ?image
WHERE 
{
  ?item wdt:P31 wd:Q16521.
  ?item wdt:P138 ?person.
  ?person wdt:P21 wd:Q6581072.
  ?person wdt:P106 ?occ.
  ?occ wdt:P279* wd:Q901.
  OPTIONAL {?person wdt:P18 ?image}.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Anything named after women scientists edit

The following query uses these:

Items: female (Q6581072)   , scientist (Q901)

Properties: named after (P138)   , sex or gender (P21)   , occupation (P106)   , subclass of (P279)   , image (P18)

Features: Graph (Q24515287)  

#defaultView:Graph
SELECT ?item ("00FFFF" AS ?rgb) ?itemLabel ?person ?personLabel ?image
WHERE 
{
  ?item wdt:P138 ?person.
  ?person wdt:P21 wd:Q6581072.
  ?person wdt:P106 ?occ.
  ?occ wdt:P279* wd:Q901.
  OPTIONAL {?person wdt:P18 ?image}.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Scholarly articles by people who worked at PARC at some point edit

The following query uses these:

Items: human (Q5)   , PARC (Q750428)   , scholarly article (Q13442814)

Properties: instance of (P31)  

, employer (P108)  

, author (P50)  

SELECT ?item ?itemLabel ?article ?articleLabel ?date
WHERE 
{
  ?item wdt:P31 wd:Q5.
  ?item wdt:P108 wd:Q750428.
  ?article wdt:P31 wd:Q13442814.
  ?article wdt:P50 ?item. 
  ?article wdt:P577 ?date.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software developed by people who have been employed by PARC edit

The following query uses these:

Items: human (Q5)   , PARC (Q750428)   , software (Q7397)

Properties: instance of (P31)  

, employer (P108)  

, developer (P178)  

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

Describes a project that uses X software edit

The following query uses these:

Items: software (Q7397)

Properties: describes a project that uses (P4510)  

SELECT ?item ?itemLabel ?value ?valueLabel
{
	?item wdt:P4510 ?value .
    ?value wdt:P31/wdt:P279* wd:Q7397.
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en,en"  }    
}

When Apple publishes software under a free license, which for the free licenses approved by the FSF do they use? edit

The following query uses these:

Items: software (Q7397)   , Apple (Q312)   , Free Software Foundation (Q48413)

Properties: instance of (P31)   , subclass of (P279)   , developer (P178)   , copyright license (P275)   , approved by (P790)

Features: BubbleChart (Q24515280)  

#defaultView:BubbleChart
SELECT DISTINCT ?license ?licenseLabel (COUNT(?item) AS ?count) WHERE {
  ?item (wdt:P31/wdt:P279*) wd:Q7397.
  ?item wdt:P178 wd:Q312.
  
  ?item wdt:P275 ?license.
  ?license wdt:P790 wd:Q48413.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?license ?licenseLabel
ORDER BY DESC(?count)

When Microsoft publishes software under a free license, which for the free licenses approved by the FSF do they use? edit

The following query uses these:

Items: software (Q7397)   , Microsoft (Q2283)   , Free Software Foundation (Q48413)

Properties: instance of (P31)   , subclass of (P279)   , developer (P178)   , copyright license (P275)   , approved by (P790)

Features: BubbleChart (Q24515280)  

#defaultView:BubbleChart
SELECT DISTINCT ?license ?licenseLabel (COUNT(?item) AS ?count) WHERE {
  ?item (wdt:P31/wdt:P279*) wd:Q7397.
  ?item wdt:P178 wd:Q2283.
  
  ?item wdt:P275 ?license.
  ?license wdt:P790 wd:Q48413.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?license ?licenseLabel
ORDER BY DESC(?count)

When Google publishes software under a free license, which for the free licenses approved by the FSF do they use? edit

The following query uses these:

Items: software (Q7397)   , Google (Q95)   , Free Software Foundation (Q48413)

Properties: instance of (P31)   , subclass of (P279)   , developer (P178)   , copyright license (P275)   , approved by (P790)

Features: BubbleChart (Q24515280)  

#defaultView:BubbleChart
SELECT DISTINCT ?license ?licenseLabel (COUNT(?item) AS ?count) WHERE {
  ?item (wdt:P31/wdt:P279*) wd:Q7397.
  ?item wdt:P178 wd:Q95.
  
  ?item wdt:P275 ?license.
  ?license wdt:P790 wd:Q48413.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?license ?licenseLabel
ORDER BY DESC(?count)

When Facebook publishes software under a free license, which for the free licenses approved by the FSF do they use? edit

The following query uses these:

Items: software (Q7397)   , Meta Platforms (Q380)   , Free Software Foundation (Q48413)

Properties: instance of (P31)   , subclass of (P279)   , developer (P178)   , copyright license (P275)   , approved by (P790)

Features: BubbleChart (Q24515280)  

#defaultView:BubbleChart
SELECT DISTINCT ?license ?licenseLabel (COUNT(?item) AS ?count) WHERE {
  ?item (wdt:P31/wdt:P279*) wd:Q7397.
  ?item wdt:P178 wd:Q380.
  
  ?item wdt:P275 ?license.
  ?license wdt:P790 wd:Q48413.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?license ?licenseLabel
ORDER BY DESC(?count)

Orgs with a crunchbase id by the stock exchanges they are traded on edit

The following query uses these:

Properties: Crunchbase organization ID (P2088)  

, stock exchange (P414)  

, ticker symbol (P249)  

SELECT ?item ?itemLabel ?se ?seLabel ?sym ("00FFFF" AS ?rgb)
WHERE 
{
  ?item wdt:P2088 ?crunchbase.
  ?item wdt:P414 ?se;
        p:P414 [pq:P249 ?sym].
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Timeline of digital container formats with logos edit

The following query uses these:

Items: digital container format (Q167772)

Properties: instance of (P31)  

, inception (P571)  

#defaultView:Timeline
SELECT ?item ?itemLabel ?date ?inception ?logo WHERE {
  ?item wdt:P31 wd:Q167772.
  OPTIONAL { ?item wdt:P577 ?date. }
  OPTIONAL { ?item wdt:P154 ?logo. }
  OPTIONAL { ?item wdt:P571 ?date. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Keyboard layouts with optional image edit

The following query uses these:

Items: keyboard layout (Q725744)

Properties: instance of (P31)  

, image (P18)  

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

File formats named after other things edit

The following query uses these:

Items: file format (Q235557)

Properties: instance of (P31)  

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

Data serialization formats edit

The following query uses these:

Items: data serialization format (Q24451526)

Properties: instance of (P31)  

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

Image grid of the musicians who have software named after them edit

The following query uses these:

Items: software (Q7397)   , musician (Q639669)

Properties: instance of (P31)   , subclass of (P279)   , named after (P138)   , occupation (P106)   , image (P18)

Features: ImageGrid (Q24515278)  

#defaultView:ImageGridimag
SELECT DISTINCT ?item ?itemLabel ?after ?image WHERE {
  ?item (wdt:P31/wdt:P279*) wd:Q7397.
  ?item wdt:P138 ?after.
  ?after wdt:P106 ?musician.
  ?musician wdt:P279* wd:Q639669.
  OPTIONAL { ?after wdt:P18 ?image. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Image grid of athletes that have software named after them edit

The following query uses these:

Items: software (Q7397)   , athlete (Q2066131)

Properties: instance of (P31)   , subclass of (P279)   , named after (P138)   , occupation (P106)   , image (P18)

Features: ImageGrid (Q24515278)  

#defaultView:ImageGrid
SELECT DISTINCT ?item ?itemLabel ?after ?image WHERE {
  ?item (wdt:P31/wdt:P279*) wd:Q7397.
  ?item wdt:P138 ?after.
  ?after wdt:P106 ?athlete.
  ?athlete wdt:P279 wd:Q2066131.
  OPTIONAL { ?after wdt:P18 ?image. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

File formats connect to more than 10 software titles edit

The following query uses these:

Items: software (Q7397)

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

Features: BubbleChart (Q24515280)  

#defaultView:BubbleChart
SELECT ?ff ?ffLabel (COUNT(?app) AS ?count) WHERE {
  ?app (wdt:P31/wdt:P279*) wd:Q7397.
  ?app wdt:P1072 ?ff.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?ff ?ffLabel
HAVING ((COUNT(?app)) > 10)
ORDER BY DESC(?count)

Developers of software that can read file format w PUID edit

The following query uses these:

Items: software (Q7397)

Properties: instance of (P31)  

, developer (P178)  

SELECT DISTINCT ?dev ?devLabel ?item ?itemLabel ?ff ?ffLabel ?puid
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q7397.
  ?item wdt:P178 ?dev.
  ?item wdt:P1072 ?ff.
  ?ff wdt:P2748 ?puid. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software titles with a category on Wikimedia Commons edit

The following query uses these:

Items: software (Q7397)

Properties: instance of (P31)  

, Commons category (P373)  

SELECT ?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". }
}

Data Serialization formats and the external ids used for them edit

The following query uses these:

Items: data serialization format (Q24451526)

Properties: instance of (P31)  

SELECT DISTINCT ?item ("00FFFF" AS ?rgb) ?itemLabel ?propItem ?propItemLabel  WHERE {
  ?item wdt:P31 wd:Q24451526.
  ?item ?prop ?value.
  ?propItem wikibase:directClaim ?prop.
  ?propItem wikibase:propertyType wikibase:ExternalId.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Office Suites with component parts edit

The following query uses these:

Items: office suite (Q207170)

Properties: instance of (P31)  

SELECT ?item ("00FFFF" AS ?rgb) ?itemLabel ?component ?componentLabel
WHERE 
{
  ?item wdt:P31 wd:Q207170.
  ?item wdt:P527 ?component. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Iana service name edit

The following query uses these:

Properties: IANA service name (P5814)  

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

Parts of the Internet Protocol Suite and the sources that describe them edit

The following query uses these:

Items: Internet protocol suite (Q81414)

Properties: part of (P361)   , described by source (P1343)

Features: Graph (Q24515287)  

#defaultView:Graph
SELECT ?item ("00FFFF" AS ?rgb) ?itemLabel ?source ?sourceLabel WHERE {
  ?item wdt:P361 wd:Q81414.
  ?item wdt:P1343 ?source.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software with JSTOR topic id edit

The following query uses these:

Items: software (Q7397)

Properties: instance of (P31)  

, JSTOR topic ID (P3827)  

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

reference manager software opt lic opt ff edit

The following query uses these:

Items: reference management software (Q1403556)

Properties: instance of (P31)  

SELECT ?item ?itemLabel ?format ?formatLabel ?lic ?licLabel
WHERE 
{
  ?item wdt:P31 wd:Q1403556.
  OPTIONAL {?item wdt:P1072 ?format.}
  OPTIONAL {?item wdt:P275 ?lic.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Protocols that have parts edit

The following query uses these:

Items: computer network protocol (Q15836568)

Properties: instance of (P31)  

, Uniform Resource Identifier Scheme (P4742)  

SELECT ?item ?itemLabel ?component ?componentLabel ?urischeme
WHERE 
{
  ?item wdt:P31 wd:Q15836568.
  ?item wdt:P527 ?component. 
  OPTIONAL {?item wdt:P4742 ?urischeme.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Distinct file extensions in Wikidata edit

The following query uses these:

Properties: file extension (P1195)  

SELECT DISTINCT ?extension
WHERE 
{
  ?item wdt:P1195 ?extension.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Instances of any of the types of software and their component parts edit

The following query uses these:

Items: software category (Q28530532)

Properties: instance of (P31)  

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

Software named after human biblical figure edit

The following query uses these:

Items: software (Q7397)   , human biblical figure (Q20643955)

Properties: instance of (P31)  

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

Software named after mythological Greek character edit

The following query uses these:

Items: software (Q7397)   , mythological Greek character (Q22988604)

Properties: instance of (P31)  

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

Image grid of software named after places edit

The following query uses these:

Items: software (Q7397)   , territory (Q1496967)

Properties: instance of (P31)   , subclass of (P279)   , named after (P138)   , image (P18)

Features: ImageGrid (Q24515278)  

#defaultView:ImageGrid
SELECT DISTINCT ?item ?itemLabel ?after ?afterLabel ?image WHERE {
  ?item (wdt:P31/wdt:P279*) wd:Q7397.
  ?item wdt:P138 ?after.
  ?after (wdt:P31/wdt:P279*) wd:Q1496967.
  OPTIONAL { ?after wdt:P18 ?image. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software titles related to 3d computer graphics and the file formats they read edit

The following query uses these:

Items: 3D computer graphics (Q189177)

Properties: has use (P366)   , readable file format (P1072)

Features: Graph (Q24515287)  

#defaultView:Graph
SELECT ?item ("00FFFF" AS ?rgb) ?itemLabel ?ff ?ffLabel WHERE {
  ?item wdt:P366 wd:Q189177.
  ?item wdt:P1072 ?ff.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Image grid of items with a Rosetta Code id edit

The following query uses these:

Properties: Rosetta Code page ID (P5047)   , image (P18)

Features: ImageGrid (Q24515278)  

#defaultView:ImageGrid
SELECT ?item ?itemLabel ?image ?code
WHERE 
{
  ?item wdt:P5047 ?code.
  OPTIONAL {?item wdt:P18 ?image.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software titles with ESCO skill id edit

The following query uses these:

Items: software (Q7397)

Properties: ESCO skill ID (P4644)  

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

Software titles with Canadiana id edit

The following query uses these:

Items: software (Q7397)

Properties: Canadiana Authorities ID (former scheme) (P1670)  

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

Women members of the ACM edit

The following query uses these:

Items: female (Q6581072)   , computer scientist (Q82594)   , Association for Computing Machinery (Q127992)   , scholarly article (Q13442814)

Properties: sex or gender (P21)  

, occupation (P106)  

, member of (P463)  

, image (P18)  

, author (P50)  

SELECT ?item ("00FFFF" AS ?rgb) ?itemLabel ?image  ?pub ?pubLabel
WHERE 
{
  ?item wdt:P21 wd:Q6581072.
  ?item wdt:P106 wd:Q82594.
  ?item wdt:P463 wd:Q127992.
  OPTIONAL {?item wdt:P18 ?image.}
  ?pub wdt:P31 wd:Q13442814.
  ?pub wdt:P50 ?item.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Bubble chart of file formats (identified by PUID) by the number of software titles they have been connected to via P1072 edit

The following query uses these:

Properties: PRONOM file format ID (P2748)  

SELECT DISTINCT ?puid (COUNT(?software) AS ?count)
WHERE {
  ?format wdt:P2748 ?puid .
  ?software wdt:P1072 ?format.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
GROUP BY ?puid

HAVING(COUNT(?software) > 9)

ORDER BY DESC(?count)

Dataset for the above edit

The following query uses these:

Properties: PRONOM file format ID (P2748)  

SELECT DISTINCT ?software ?softwareLabel ?format ?formatLabel ?puid 
WHERE {
  ?format wdt:P2748 ?puid .
  ?software wdt:P1072 ?format.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }

Bubble chart showing families edit

The following query uses these:

Items: file format family (Q26085352)

Properties: instance of (P31)   , has part(s) (P527)   , readable file format (P1072)

Features: BubbleChart (Q24515280)  

#defaultView:BubbleChart
SELECT DISTINCT   ?family ?familyLabel  (COUNT(?software) AS ?count)
WHERE {
  ?family wdt:P31 wd:Q26085352.
  ?family  wdt:P527 ?format.
  ?software wdt:P1072 ?format.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }

GROUP BY ?family ?familyLabel


HAVING(COUNT(?software) > 5)


ORDER BY DESC(?count)

Graph viz of devs of file format families and component formats edit

The following query uses these:

Items: file format family (Q26085352)

Properties: instance of (P31)   , has part(s) (P527)   , developer (P178)

Features: Graph (Q24515287)  

#defaultView:Graph
SELECT DISTINCT  ?dev ("00FFFF" AS ?rgb) ?devLabel ?family ?familyLabel ?format ?formatLabel
WHERE {
  ?family wdt:P31 wd:Q26085352.
  ?family  wdt:P527 ?format.
    ?format wdt:P178 ?dev.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }

Image grid of people who have offupation computer sci and have a snac id edit

The following query uses these:

Items: computer scientist (Q82594)

Properties: SNAC ARK ID (P3430)  

, occupation (P106)  

, image (P18)  

#Items for people with the occupation 'computer scientist' that have an ID from the Social Networks Archival Contex project
SELECT ?item ?itemLabel ?value ?image WHERE {
  ?item wdt:P3430 ?value.
  ?item wdt:P106 wd:Q82594.
  OPTIONAL { ?item wdt:P18 ?image. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software named after common names of animals edit

The following query uses these:

Items: organisms known by a particular common name (Q55983715)

Properties: instance of (P31)  

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

Software named after taxon or common name of animals edit

The following query uses these:

Items: software (Q7397)   , organisms known by a particular common name (Q55983715)   , taxon (Q16521)

Properties: instance of (P31)  

, image (P18)  

SELECT ?item ?itemLabel ?class ?classLabel ?taxon ?taxonLabel ?logo ?image
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q7397.
  ?item wdt:P138 ?class. 
  ?class wdt:P31 wd:Q55983715.
  ?item wdt:P138 ?taxon.
  ?taxon wdt:P31 wd:Q16521.
  OPTIONAL {?item wdt:P154 ?logo}.
  OPTIONAL {?taxon wdt:P18 ?image}.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Raster graphics editor software and the file formats they can open, optional PRONOM id for the format edit

The following query uses these:

Items: raster graphics editor (Q2351962)

Properties: instance of (P31)   , readable file format (P1072)   , PRONOM file format ID (P2748)   , has part(s) (P527)

Features: Graph (Q24515287)  

#defaultView:Graph
#Raster graphics editor software and the file formats they can open, optional PRONOM id for the format
SELECT ?item ("00FFFF" AS ?rgb) ?itemLabel ?format ?formatLabel ?puid 
WHERE 
{
  ?item wdt:P31 wd:Q2351962 ;
        wdt:P1072 ?format. 
 {?format wdt:P2748 ?puid}
  UNION
  {
    ?format wdt:P527 ?part.
    ?part wdt:P2748 ?puid.
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

using OPTIONAL edit

The following query uses these:

Items: raster graphics editor (Q2351962)

Properties: instance of (P31)  

#Raster graphics editor software and the file formats they can open, option PRONOM id for the format
SELECT DISTINCT ?item ?itemLabel ?format ?formatLabel ?puid 
WHERE 
{
  {?item wdt:P31 wd:Q2351962 ;
        wdt:P1072 ?format. 
  OPTIONAL {?format wdt:P2748 ?puid}.}
  UNION
  {?item wdt:P31 wd:Q2351962 ;
        wdt:P1072 ?format. 
  ?format wdt:P527 ?part.
  ?part wdt:P2748 ?puid.
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software titles dev by Autodesk and readable ff edit

The following query uses these:

Items: software (Q7397)   , Autodesk (Q628051)

Properties: instance of (P31)  

, developer (P178)  

SELECT ?item ?itemLabel ?format ?formatLabel WHERE {
  ?item (wdt:P31/wdt:P279*) wd:Q7397.
  ?item wdt:P178 wd:Q628051.
  ?item wdt:P1072 ?format.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software titles that have their own subreddits and optional logo image edit

The following query uses these:

Items: software (Q7397)

Properties: instance of (P31)  

, subreddit (P3984)  

SELECT DISTINCT ?software ?softwareLabel ?image ?subreddit WHERE {
  ?software (wdt:P31/wdt:P279*) wd:Q7397.
  ?software wdt:P3984 ?subreddit.
  OPTIONAL { ?software wdt:P154 ?image. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Digital container formats and that have component parts edit

The following query uses these:

Items: digital container format (Q167772)

Properties: instance of (P31)  

SELECT DISTINCT ?item ("00FFFF" AS ?rgb) ?itemLabel ?part ?partLabel WHERE {
  ?item (wdt:P31/wdt:P279*) wd:Q167772.
  ?item wdt:P527 ?part.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software titles named after entities from Tolkien edit

The following query uses these:

Items: software (Q7397)   , Tolkien's legendarium (Q81738)

Properties: instance of (P31)  

, from narrative universe (P1080)  

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

Companies that are named after entities from Tolkien edit

The following query uses these:

Items: business (Q4830453)   , Tolkien's legendarium (Q81738)

Properties: instance of (P31)  

, from narrative universe (P1080)  

SELECT DISTINCT ?company ?companyLabel  ?thing ?thingLabel
WHERE 
{ 
  ?company wdt:P31 wd:Q4830453.
  ?company wdt:P138 ?thing. 
  ?thing wdt:P1080 wd:Q81738.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

People who have won the Turing Award and their past doctoral students edit

The following query uses these:

Items: Turing Award (Q185667)

Properties: award received (P166)  

SELECT DISTINCT ?item ("00FFFF" AS ?rgb)?itemLabel ?student ?studentLabel
WHERE 
{
  ?item wdt:P166 wd:Q185667.
  ?student wdt:P184 ?item.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

People who have won the Turing Award (with image) and their past doctoral students edit

The following query uses these:

Items: Turing Award (Q185667)

Properties: award received (P166)  

, image (P18)  

SELECT DISTINCT ?item ("00FFFF" AS ?rgb) ?itemLabel  ?image  ?student ?studentLabel
WHERE 
{
  ?item wdt:P166 wd:Q185667.
  ?student wdt:P184 ?item.
  ?item wdt:P18 ?image.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Companies w LinkedIn company id by the number of software titles developed edit

The following query uses these:

Items: software (Q7397)

Properties: LinkedIn company or organization ID (P4264)   , developer (P178)   , instance of (P31)   , subclass of (P279)

Features: BubbleChart (Q24515280)  

#defaultView:BubbleChart
SELECT ?item ?itemLabel ?linkedin (COUNT(?software) AS ?count) WHERE {
  ?item wdt:P4264 ?linkedin.
  ?software wdt:P178 ?item;
    (wdt:P31/(wdt:P279*)) wd:Q7397.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?item ?itemLabel ?linkedin
ORDER BY DESC (?count)

Software titles that read DXF w optional logo edit

The following query uses these:

Items: software (Q7397)   , Drawing Interchange File Format Family (Q691652)

Properties: instance of (P31)  

SELECT DISTINCT ?app ?appLabel ?logo WHERE {
  ?app (wdt:P31/(wdt:P279*)) wd:Q7397;
    wdt:P1072 wd:Q691652.
  OPTIONAL { ?app wdt:P154 ?logo. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

RFCs authored by Steve Crocker edit

The following query uses these:

Items: Request for Comments (Q212971)   , Steve Crocker (Q3178997)

Properties: instance of (P31)  

, author (P50)  

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

Screen Readers edit

The following query uses these:

Items: screen reader (Q1328864)

Properties: instance of (P31)  

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

Genre "screencasting"software" edit

The following query uses these:

Items: screencasting software (Q60345396)

Properties: genre (P136)  

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

Timeline of cryptocurrencies edit

The following query uses these:

Items: cryptocurrency (Q13479982)

Properties: instance of (P31)  

, inception (P571)  

SELECT ?item ?itemLabel ?date ?logo WHERE {
  ?item wdt:P31 wd:Q13479982.
  OPTIONAL { ?item wdt:P154 ?logo. }
  ?item wdt:P571 ?date.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Genre "screencasting"software" optional license edit

The following query uses these:

Items: screencasting software (Q60345396)

Properties: genre (P136)  

SELECT ?item ?itemLabel ?license ?licenseLabel
WHERE 
{
  ?item wdt:P136 wd:Q60345396.
  OPTIONAL {?item wdt:P275 ?license}.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

use url shortening edit

The following query uses these:

Items: URL shortening (Q637342)

Properties: has use (P366)  

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

Companies founded by Fellows of the ACM edit

The following query uses these:

Items: ACM Fellow (Q18748039)

Properties: award received (P166)  

, image (P18)  

SELECT ?item ?itemLabel ?image ?company ?companyLabel ?logo
WHERE 
{
  ?item wdt:P166 wd:Q18748039.
  ?company wdt:P112 ?item. 
  OPTIONAL {?item wdt:P18 ?image. }
  OPTIONAL {?company wdt:P154 ?logo.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Companies founded by people who have received an award from the ACM with optional logos and images edit

The following query uses these:

Items: Association for Computing Machinery (Q127992)

Properties: award received (P166)  

, conferred by (P1027)  

, image (P18)  

SELECT ?item ?itemLabel ?image  ?company ?companyLabel ?logo
WHERE 
{
  ?item wdt:P166 ?award.
  ?award wdt:P1027 wd:Q127992.
  ?company wdt:P112 ?item. 
  OPTIONAL {?item wdt:P18 ?image. }
  OPTIONAL {?company wdt:P154 ?logo.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Accounting software edit

The following query uses these:

Items: accounting software (Q974828)

Properties: instance of (P31)  

, operating system (P306)  

SELECT ?item ?itemLabel ?licLabel WHERE {
  ?item (wdt:P31/(wdt:P279*)) wd:Q974828.
  OPTIONAL { ?item wdt:P306 ?lic. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Classes to which tos belog edit

The following query uses these:

Items: software category (Q28530532)

Properties: instance of (P31)  

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

Count of statements per item that have LOC fdd edit

The following query uses these:

Properties: Library of Congress Format Description Document ID (P3266)  

SELECT ?item ?itemLabel ?value ?statements WHERE {
  {
    SELECT * WHERE {
      ?item wdt:P3266 ?value.
      ?item wikibase:statements ?statements.
    }
    ORDER BY DESC(?st)
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?st) ?item

Documentation Generator by programming lang edit

The following query uses these:

Items: documentation generator (Q2164323)

Properties: instance of (P31)  

, programmed in (P277)  

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

Prolinux db ids edit

The following query uses these:

Properties: Pro-Linux.de DBApp ID (P6665)  

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

Count of statements for ff items edit

The following query uses these:

Items: file format (Q235557)

Properties: instance of (P31)  

SELECT ?item ?itemLabel ?statements WHERE {
  {
    SELECT * WHERE {
      ?item wdt:P31/wdt:P279* wd:Q235557;
        wikibase:statements ?statements.
    }
    ORDER BY DESC (?st)
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC (?st) (?item)

Founders of companies that provide launch services edit

The following query uses these:

Items: launch service provider (Q11753232)

Properties: instance of (P31)  

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

Emulators with an entry in the Pro-Linux.de database edit

The following query uses these:

Items: emulator (Q202871)

Properties: Pro-Linux.de DBApp ID (P6665)  

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

Software titles that have derivative works edit

The following query uses these:

Items: software (Q7397)

Properties: instance of (P31)  

, derivative work (P4969)  

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

File formats that have derivative works edit

The following query uses these:

Items: file format (Q235557)

Properties: instance of (P31)  

, derivative work (P4969)  

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

Members of European Committee for Interoperable Systems edit

The following query uses these:

Items: European Committee for Interoperable Systems (Q2985457)

Properties: member of (P463)  

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

Members of Linux Foundation edit

The following query uses these:

Items: Linux Foundation (Q858851)

Properties: member of (P463)  

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

Map of HQ locations of the member orgs of the OpenAPI Initiative edit

The following query uses these:

Items: OpenAPI Initiative (Q63256596)

Properties: member of (P463)  

, headquarters location (P159)  

, coordinate location (P625)  

SELECT ?item ?itemLabel ?coord WHERE {
  ?item wdt:P463 wd:Q63256596;
    wdt:P159 ?hq.
  ?hq wdt:P625 ?coord.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

File formats that were developed by a company that was acquired by another company edit

The following query uses these:

Items: business (Q4830453)   , file format (Q235557)

Properties: instance of (P31)  

, followed by (P156)  

, developer (P178)  

SELECT ?item ?itemLabel ?format ?formatLabel ?comp ?compLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q4830453.
  ?item wdt:P156 ?comp.
  ?format wdt:P178 ?item.
  ?format wdt:P31/wdt:P279* wd:Q235557.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software that depends on GDAL edit

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

Parent org Alphabet, Inc edit

The following query uses these:

Items: Alphabet Inc. (Q20800404)

Properties: parent organization (P749)  

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

Subsidiary of Alphabet edit

The following query uses these:

Items: Google (Q95)

Properties: has subsidiary (P355)  

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

Computer scientists who play the piano edit

The following query uses these:

Items: computer scientist (Q82594)   , piano (Q5994)

Properties: occupation (P106)  

, instrument (P1303)  

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

People employed by DEC edit

The following query uses these:

Items: Digital Equipment Corporation (Q690079)

Properties: employer (P108)  

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

People who have worked at Los Alamos edit

The following query uses these:

Items: Los Alamos National Laboratory (Q379848)

Properties: employer (P108)  

, image (P18)  

SELECT ?item ?itemLabel ?image
WHERE 
{
  ?item wdt:P108 wd:Q379848.
  OPTIONAL {?item wdt:P18 ?image.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Founding members of HSA Foundation and their subsidiaries edit

The following query uses these:

Items: HSA Foundation (Q17092068)

Properties: founded by (P112)  

, has subsidiary (P355)  

SELECT ?item ("00FFFF" AS ?rgb) ?itemLabel ?subsidiary ?subsidiaryLabel WHERE {
  wd:Q17092068 wdt:P112 ?item.
  OPTIONAL { ?item wdt:P355 ?subsidiary. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Timeline of versions of PDF edit

The following query uses these:

Items: Portable Document Format (Q42332)

Properties: has part(s) (P527)  

SELECT ?item ?itemLabel ?date
WHERE 
{
  wd:Q42332 wdt:P527 ?item.
  OPTIONAL {?item wdt:P577 ?date.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software titles developed by Fellows of the ACM edit

The following query uses these:

Items: ACM Fellow (Q18748039)

Properties: award received (P166)  

, developer (P178)  

SELECT ?item ?itemLabel ?software ?softwareLabel WHERE {
  ?item wdt:P166 wd:Q18748039.
  ?software wdt:P178 ?item.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software written in Ruby edit

The following query uses these:

Items: Ruby (Q161053)

Properties: programmed in (P277)  

SELECT DISTINCT ?software ?softwareLabel ?image WHERE {
  ?software wdt:P277 wd:Q161053.
  OPTIONAL { ?software wdt:P154 ?image. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Orgs founded by Marconi Fellows edit

The following query uses these:

Items: Marconi Prize (Q473292)

Properties: award received (P166)   , founded by (P112)

Features: Graph (Q24515287)  

#defaultView:Graph
SELECT ?item ("00FFFF" AS ?rgb) ?itemLabel ?org ?orgLabel
WHERE 
{
  ?item wdt:P166 wd:Q473292.
  ?org wdt:P112 ?item 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Where are Marconi Fellows educated? edit

The following query uses these:

Items: Marconi Prize (Q473292)

Properties: award received (P166)   , educated at (P69)

Features: Graph (Q24515287)  

#defaultView:Graph
SELECT ?item ("00FFFF" AS ?rgb) ?itemLabel ?school ?schoolLabel
WHERE 
{
  ?item wdt:P166 wd:Q473292.
  ?item wdt:P69 ?school.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Image Gallery of winners of the ACM software System Award edit

The following query uses these:

Items: ACM Software System Award (Q986509)

Properties: award received (P166)  

, image (P18)  

SELECT ?item ?itemLabel ?image
WHERE 
{
  ?item wdt:P166 wd:Q986509.
  ?item wdt:P18 ?image
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Seed Accelerators edit

The following query uses these:

Items: startup accelerator (Q4086495)

Properties: instance of (P31)  

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

Companies in which Y Combinator is an investor edit

The following query uses these:

Items: business (Q4830453)   , Y Combinator (Q2616400)

Properties: instance of (P31)  

, investor (P1951)  

, industry (P452)  

SELECT ?item ?itemLabel ?industryLabel
WHERE 
{
  ?item wdt:P31 wd:Q4830453.
  ?item wdt:P1951 wd:Q2616400.
  OPTIONAL {?item wdt:P452 ?industry.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Orgs founded by members of PPM edit

The following query uses these:

Items: PayPal Mafia (Q7156556)

Properties: part of (P361)  

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

Computer Museums and images edit

The following query uses these:

Items: computer museum (Q1093436)

Properties: instance of (P31)   , image (P18)

Features: ImageGrid (Q24515278)  

#defaultView:ImageGrid
SELECT ?item ?itemLabel ?image WHERE {
  ?item wdt:P31 wd:Q1093436.
  OPTIONAL { ?item wdt:P18 ?image. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Orgs founded by PPM graph w images edit

The following query uses these:

Items: PayPal Mafia (Q7156556)

Properties: part of (P361)   , image (P18)   , founded by (P112)

Features: Graph (Q24515287)  

#defaultView:Graph
SELECT ?item ("00FFFF" AS ?rgb) ?itemLabel ?image ?org ?orgLabel WHERE {
  ?item wdt:P361 wd:Q7156556.
  OPTIONAL { ?item wdt:P18 ?image. }
  ?org wdt:P112 ?item.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Members of Linux Foundation w MoMA id edit

The following query uses these:

Items: Linux Foundation (Q858851)

Properties: member of (P463)  

, Museum of Modern Art artist ID (P2174)  

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

Api endpoint edit

The following query uses these:

Properties: API endpoint URL (P6269)  

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

Video games ig noble edit

The following query uses these:

Items: video game (Q7889)   , Ig Nobel Prize (Q184253)

Properties: instance of (P31)  

, image (P18)  

, discoverer or inventor (P61)  

, award received (P166)  

SELECT ?item ?itemLabel ?image ?inventorLabel WHERE {
  ?item wdt:P31 wd:Q7889;
    wdt:P18 ?image;
    wdt:P61 ?inventor.
  ?inventor wdt:P166 wd:Q184253.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

People employed by Bell Labs edit

The following query uses these:

Items: Bell Labs (Q217365)

Properties: employer (P108)  

, image (P18)  

SELECT ?item ?itemLabel ?date ?image WHERE {
  ?item wdt:P108 wd:Q217365.
  OPTIONAL { ?item wdt:P18 ?image. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

CVE for MDS edit

The following query uses these:

Items: vulnerability (Q631425)   , Meltdown (Q47036859)   , Microarchitectural Data Sampling (Q63858759)

Properties: instance of (P31)  

, follows (P155)  

, Common Vulnerabilities and Exposures ID (P3587)  

SELECT ?item ?itemLabel ?CVE
WHERE 
{ 
  ?item wdt:P31 wd:Q631425.
  ?item wdt:P155 wd:Q47036859.
  wd:Q63858759 wdt:P3587 ?CVE.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

IM Pei buildings edit

The following query uses these:

Items: I. M. Pei (Q46868)

Properties: architect (P84)  

, image (P18)  

SELECT ?item ?itemLabel ?image WHERE {
  ?item wdt:P84 wd:Q46868.
  OPTIONAL { ?item wdt:P18 ?image. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Cray supercomputers edit

The following query uses these:

Items: supercomputer (Q121117)   , Cray (Q144060)

Properties: instance of (P31)  

, developer (P178)  

, manufacturer (P176)  

, image (P18)  

SELECT DISTINCT ?item ?itemLabel ?image WHERE {
  ?item (wdt:P31/(wdt:P279*)) wd:Q121117.
  { ?item wdt:P178 wd:Q144060. }
  UNION
  { ?item wdt:P176 wd:Q144060. }
  OPTIONAL { ?item wdt:P18 ?image. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software developed by the LIGO scientific collaboration edit

The following query uses these:

Items: software (Q7397)   , LIGO Scientific Collaboration (Q6458663)

Properties: instance of (P31)  

, developer (P178)  

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

Software plus license info dev by LIGO scientific collab edit

The following query uses these:

Items: LIGO Scientific Collaboration (Q6458663)

Properties: developer (P178)  

SELECT ?item ?itemLabel ?license ?licenseLabel
WHERE 
{
  ?item wdt:P178 wd:Q6458663.
  ?item wdt:P275 ?license. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

file formats based on XML edit

The following query uses these:

Items: Extensible Markup Language (Q2115)   , file format (Q235557)

Properties: based on (P144)  

, inception (P571)  

SELECT ?item ?itemLabel ?date ?inception
WHERE 
{
  ?item wdt:P144 wd:Q2115.
  ?item wdt:P31/wdt:P279* wd:Q235557.
  OPTIONAL {?item wdt:P577 ?date.}
  OPTIONAL {?item wdt:P571 ?inception.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

External ids for Pac-Man arcade game edit

The following query uses these:

Items: video game (Q7889)

Properties: instance of (P31)  

SELECT ?item ?itemLabel ?propItem ?propItemLabel ?value WHERE {
  ?item wdt:P31 wd:Q7889;
    wdt:P577 "+1980-05-22T00:00:00Z"^^xsd:dateTime;
    ?prop ?value.
  ?propItem wikibase:directClaim ?prop;
    wikibase:propertyType wikibase:ExternalId.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Orgs that are members of MyData Global edit

The following query uses these:

Items: MyData Global (Q59696014)

Properties: member of (P463)  

, located in the administrative territorial entity (P131)  

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

Map plotted with coords of universities that are members of the W3C edit

The following query uses these:

Items: university (Q3918)   , World Wide Web Consortium (Q37033)

Properties: instance of (P31)   , subclass of (P279)   , member of (P463)   , located in the administrative territorial entity (P131)   , coordinate location (P625)

Features: map (Q24515275)  

#defaultView:Map
SELECT DISTINCT ?item ?itemLabel ?loc ?locLabel ?coord WHERE {
  ?item (wdt:P31/(wdt:P279*)) wd:Q3918;
    wdt:P463 wd:Q37033;
    wdt:P131 ?loc.
  ?loc wdt:P625 ?coord.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Bubble chart of industries per org with crunchbase id edit

The following query uses these:

Properties: Crunchbase organization ID (P2088)   , industry (P452)

Features: BubbleChart (Q24515280)  

#defaultView:BubbleChart
SELECT ?industry ?industryLabel (COUNT(?item) AS ?count) WHERE {
  ?item wdt:P2088 ?crunchbase;
    wdt:P452 ?industry.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?industry ?industryLabel
ORDER BY DESC (?count)

network operator edit

The following query uses these:

Items: network operator (Q62058278)

Properties: instance of (P31)  

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

Operators of the W3C edit

The following query uses these:

Items: World Wide Web Consortium (Q37033)

Properties: operator (P137)  

SELECT  ?host ?hostLabel
WHERE 
{
  wd:Q37033 wdt:P137 ?host.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Software titles named after animals edit

The following query uses these:

Items: software (Q7397)   , taxon (Q16521)

Properties: instance of (P31)  

, image (P18)  

SELECT DISTINCT ?item ?itemLabel  ?taxon ?taxonLabel  ?image
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q7397.
  ?item wdt:P138 ?taxon.
  ?taxon wdt:P31 wd:Q16521.
  OPTIONAL {?taxon wdt:P18 ?image}.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}