Open main menu

User:YULdigitalpreservation/SPARQL2019

Contents

Queries 2019Edit

Vehicles used by people who have founded companiesEdit

The following query uses these:

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

The following query uses these:

Features: BubbleChart (Q24515280) View with Reasonator View with SQID

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

People who are computer scientists who have a child who is a computer scientistEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, occupation (P106) View with Reasonator View with SQID, child (P40) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?child ?childLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31 wd:Q5.
    5   ?item wdt:P106 wd:Q82594.
    6   ?item wdt:P40 ?child.
    7   ?child wdt:P106 wd:Q82594.
    8   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    9 }
    

People who are members of NAS who also have a child who is a memberEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, member of (P463) View with Reasonator View with SQID, child (P40) View with Reasonator View with SQID
    1 WHERE 
    2 {
    3   ?item wdt:P31 wd:Q5.
    4   ?item wdt:P463 wd:Q270794.
    5   ?item wdt:P40 ?child.
    6   ?child wdt:P463 wd:Q270794.
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

People who are employed by the company their parent foundedEdit

The following query uses these:

File formats published before 1985Edit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, readable file format (P1072) View with Reasonator View with SQID, inception (P571) View with Reasonator View with SQID, publication date (P577) View with Reasonator View with SQID
     1 SELECT DISTINCT ?format ?formatLabel ?date  ?pub 
     2 WHERE {
     3   ?format wdt:P31/wdt:P279* wd:Q235557.
     4   ?app wdt:P1072 ?format.
     5   OPTIONAL {?format wdt:P571 ?date}.
     6   OPTIONAL {?format wdt:P577 ?pub}.
     7   BIND (?date AS ?time)
     8   BIND (?pub AS ?time)
     9   FILTER((?time) < "1985-01-01"^^xsd:dateTime)
    10   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    11   
    12 }
    

File formats connected to software and datesEdit

The following query uses these:

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

The following query uses these:

File formats with Wolfram Language entity idEdit

The following query uses these:

Members of Open Media AllianceEdit

The following query uses these:

  • Properties: member of (P463) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P463 wd:Q20947086.
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Map of HQ of OMA membersEdit

The following query uses these:

Features: Map (Q24515275) View with Reasonator View with SQID

1 #defaultView:Map
2 SELECT ?item ?itemLabel ?location ?locationLabel ?coord
3 WHERE 
4 {
5   ?item wdt:P463 wd:Q20947086.
6    ?item wdt:P159 ?location.
7   ?location wdt:P625 ?coord.
8   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
9 }

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

The following query uses these:

  • Properties: award received (P166) View with Reasonator View with SQID, date of death (P570) View with Reasonator View with SQID, SNAC Ark ID (P3430) View with Reasonator View with SQID, archives at (P485) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?date ?snac ?inst ?instLabel
    2 WHERE 
    3 {
    4   ?item wdt:P166 wd:Q18748039.
    5   ?item wdt:P570 ?date.
    6   OPTIONAL {?item wdt:P3430 ?snac.}
    7   OPTIONAL {?item wdt:P485 ?inst}.
    8   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    9 }
    

Nobel laureats who are also ACM FellowsEdit

The following query uses these:

  • Properties: award received (P166) View with Reasonator View with SQID, instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?date ?snac ?inst ?instLabel
    2 WHERE 
    3 {
    4   ?item wdt:P166 wd:Q18748039.
    5   ?item wdt:P166 ?award.
    6   ?award wdt:P31/wdt:P279* wd:Q7191.
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

Audio file formats and the software that can read themEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, readable file format (P1072) View with Reasonator View with SQID
    1 NCT ?item ?itemLabel ?software ?softwareLabel ("00FFFF" AS ?rgb) WHERE {
    2   {?item wdt:P31 wd:Q682626.}
    3   UNION {?item wdt:P31 wd:Q758871}.
    4   ?software wdt:P1072 ?item.
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Software that has a one-oc-a-kind computer as platformEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, image (P18) View with Reasonator View with SQID, platform (P400) View with Reasonator View with SQID
    1 SELECT ?computer ?computerLabel ?software ?softwareLabel WHERE {
    2   ?computer wdt:P31 wd:Q28542014.
    3   OPTIONAL {?computer wdt:P18 ?image}.
    4   ?software wdt:P400 ?computer.
    5    SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
    6   }
    

Orgs w ACM classification code, w stock exchange, inceptionEdit

The following query uses these:

Software named after peopleEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, named after (P138) View with Reasonator View with SQID
    1 SELECT DISTINCT ?software ?softwareLabel ?person ?personLabel  WHERE {
    2   ?software wdt:P31/wdt:P279* wd:Q7397.
    3   ?software wdt:P138 ?person.
    4   ?person wdt:P31 wd:Q5.
    5 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6   }
    

Software titles w wine app idEdit

The following query uses these:

  • Properties: Wine AppDB-ID (P600) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?value
    2 WHERE 
    3 {
    4   ?item wdt:P600 ?value .
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Youtube channels with software as a main subjectEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, main subject (P921) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?subject ?subjectLabel WHERE {
    2   ?item wdt:P31 wd:Q17558136.
    3   ?item wdt:P921 ?subject.
    4   ?subject wdt:P31/wdt:P279* wd:Q7397.
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Software titles with a youtube channel idEdit

The following query uses these:

ImplementationsEdit

The following query uses these:

  • Properties: implementation of (P4428) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?thing ?thingLabel
    2 WHERE 
    3 {
    4   ?item wdt:P4428 ?thing.
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

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

The following query uses these:

RfC from IETF with P50Edit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, author (P50) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?author ?authorLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31 wd:Q212971.
    5   ?item wdt:P50 ?author.
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

RfC with main subjectEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, main subject (P921) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?subject ?subjectLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31 wd:Q212971.
    5   ?item wdt:P921 ?subject.
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

Fellows of the ACM who have supervised female doctoral studentsEdit

The following query uses these:

  • Properties: award received (P166) View with Reasonator View with SQID, doctoral advisor (P184) View with Reasonator View with SQID, sex or gender (P21) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ("00FFFF" AS ?rgb) ?student ?studentLabel
    2 WHERE 
    3 {
    4   ?item wdt:P166 wd:Q24883503.
    5   ?student wdt:P184 ?item.
    6   ?student wdt:P21 wd:Q6581072.
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

Different version of the aboveEdit

The following query uses these:

  • Properties: award received (P166) View with Reasonator View with SQID, doctoral advisor (P184) View with Reasonator View with SQID, sex or gender (P21) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ("00FFFF" AS ?rgb) ?student ?studentLabel
    2 WHERE 
    3 {
    4   ?item wdt:P166 wd:Q24883503.
    5   ?item wdt:P184 ?student.
    6   ?student wdt:P21 wd:Q6581072.
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

Emulators with developers- minus developers that are companiesEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, developer (P178) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?dev ?devLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31/wdt:P279* wd:Q202871.
    5   ?item wdt:P178 ?dev. 
    6   MINUS {?dev wdt:P31/wdt:P279* wd:Q4830453.}
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

Emulators w id in LGDB by licenseEdit

The following query uses these:

  • Properties: LGDB emulator ID (P5117) View with Reasonator View with SQID, license (P275) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?license ?licenseLabel ?lgdb WHERE {
    2   ?item wdt:P5117 ?lgdb.
    3   OPTIONAL { ?item wdt:P275 ?license. }
    4   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    5 }
    

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

The following query uses these:

  • Properties: described at URL (P973) View with Reasonator View with SQID
    1 SELECT ?item ?url
    2 WHERE 
    3 {
    4   ?item wdt:P973 ?url.
    5   FILTER regex(str(?url), "computerhistory").
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

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

The following query uses these:

  • Properties: described at URL (P973) View with Reasonator View with SQID
    1 SELECT ?item ?url
    2 WHERE 
    3 {
    4   ?item wdt:P973 ?url.
    5   FILTER regex(str(?url), "archive").
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

with format in the URLEdit

The following query uses these:

  • Properties: described at URL (P973) View with Reasonator View with SQID
    1 SELECT ?item ?url
    2 WHERE 
    3 {
    4   ?item wdt:P973 ?url.
    5   FILTER regex(str(?url), "format").
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

People who have worked at PARC and the educational institutions they attendedEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, employer (P108) View with Reasonator View with SQID, image (P18) View with Reasonator View with SQID, educated at (P69) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?image ?school ?schoolLabel ("00FFFF" AS ?rgb) WHERE {
    2   ?item wdt:P31 wd:Q5.
    3   ?item wdt:P108 wd:Q750428.
    4   OPTIONAL { ?item wdt:P18 ?image. }
    5   ?item wdt:P69 ?school.
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

Items with a file format as a main subjectEdit

The following query uses these:

  • Properties: main subject (P921) View with Reasonator View with SQID, instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel WHERE {
    2   ?item wdt:P921 ?format.
    3   ?format (wdt:P31/wdt:P279*) wd:Q235557.
    4   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    5 }
    

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

The following query uses these:

Features: BubbleChart (Q24515280) View with Reasonator View with SQID

 1 #defaultView:BubbleChart
 2 SELECT ?app ?appLabel  (count (?software) as ?count)
 3 WHERE {
 4   ?app (wdt:P279*) wd:Q1406.
 5   ?software wdt:P306 ?app.
 6   MINUS {?software wdt:P306 wd:Q1406.}
 7   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
 8 }
 9 
10 GROUP BY ?app ?appLabel 
11 
12 
13 ORDER BY DESC(?count)

Items that have EULA as licenseEdit

The following query uses these:

  • Properties: license (P275) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P275 wd:Q725920.
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

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

The following query uses these:

  • Properties: operating system (P306) View with Reasonator View with SQID, readable file format (P1072) View with Reasonator View with SQID
    1 SELECT DISTINCT ?app ?appLabel ?ff ?ffLabel 
    2 WHERE {
    3   ?app wdt:P306 wd:Q170434.
    4   OPTIONAL {?app wdt:P1072 ?ff.}
    5  
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

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

The following query uses these:

removed optional for displayEdit

The following query uses these:

==

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, has quality (P1552) View with Reasonator View with SQID
    1 SELECT ?software ?propItem ?value WHERE {
    2   ?software wdt:P31/wdt:P279* wd:Q235557.
    3   ?software ?prop ?value.
    4   ?propItem wdt:P1552 wd:Q26921380.
    5   ?propItem wikibase:directClaim ?prop.
    6 }
    

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

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, BIBSYS ID (P1015) View with Reasonator View with SQID
    1 SELECT ?propItem ?propItemLabel ?item ?itemLabel ("00FFFF" AS ?rgb) WHERE {
    2   ?item (wdt:P31/wdt:P279) wd:Q7397.
    3   ?item wdt:P1015 ?bibsys.
    4   ?item ?prop ?value.
    5   ?propItem wikibase:directClaim ?prop.
    6   ?propItem wikibase:propertyType wikibase:ExternalId.
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

Software titles with a google+accountEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, Google+ ID (P2847) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?GooglePlus WHERE {
    2   ?item (wdt:P31/wdt:P279*) wd:Q7397.
    3   ?item wdt:P2847 ?GooglePlus.
    4   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    5 }
    

Based on RIFFEdit

The following query uses these:

  • Properties: based on (P144) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P144 wd:Q1196805.
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Software Libraries by # of ff readableEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, readable file format (P1072) View with Reasonator View with SQID
     1 SELECT ?item ?itemLabel  (COUNT(?format) AS ?count)
     2 WHERE 
     3 {
     4   ?item wdt:P31 wd:Q188860.
     5   ?item wdt:P1072 ?format.
     6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
     7 }
     8 
     9 
    10 
    11 GROUP BY ?item ?itemLabel 
    12 ORDER BY DESC(?count)
    

File formats for which there is a Synalysis grammar fileEdit

The following query uses these:

  • Properties: described at URL (P973) View with Reasonator View with SQID, file format (P2701) View with Reasonator View with SQID
    1 SELECT DISTINCT ?item ?itemLabel WHERE {
    2   ?item wdt:P973 ?url.
    3   ?item p:P973 _:b6.
    4   _:b6 pq:P2701 wd:Q27823203.
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

One-of-a-kind computers w heritage designationEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, heritage designation (P1435) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?designation ?designationLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31/wdt:P279* wd:Q28542014.
    5   ?item wdt:P1435 ?designation.
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

Bitcoin Exchanges by countryEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, country (P17) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?country ?countryLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31/wdt:P279* wd:Q20107444.
    5   OPTIONAL {?item wdt:P17 ?country}.
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

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

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, founded by (P112) View with Reasonator View with SQID, child (P40) View with Reasonator View with SQID, employer (P108) View with Reasonator View with SQID
    1 SELECT DISTINCT ?item ?itemLabel ?founder ?founderLabel ?child ?childLabel WHERE {
    2   ?item (wdt:P31/wdt:P279*) wd:Q4830453.
    3   ?item wdt:P112 ?founder.
    4   ?founder wdt:P40 ?child.
    5   ?child wdt:P108 ?item.
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

Graph of graphics software and their readable file formatsEdit

The following query uses these:

Password cracking softwareEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P31 wd:Q26921397.
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Discontinued software titles developed by AviraEdit

The following query uses these:

  • Properties: developer (P178) View with Reasonator View with SQID, discontinued date (P2669) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?date WHERE {
    2   ?item wdt:P178 wd:Q468381.
    3   ?item wdt:P2669 ?date.
    4   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    5 }
    

Scientific software and the file formats they readEdit

The following query uses these:

File formats w PUID and software known to read themEdit

The following query uses these:

Graph of file formats w PUID and software known to read themEdit

The following query uses these:

Features: Graph (Q24515287) View with Reasonator View with SQID

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

Software titles dev by librariesEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, developer (P178) View with Reasonator View with SQID
    1 SELECT DISTINCT ?item ?itemLabel ?dev ?devLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31/wdt:P279* wd:Q7397.
    5   ?item wdt:P178 ?dev.
    6   ?dev wdt:P31/wdt:P279* wd:Q7075.
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

Software titles dev by ArchivesEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, developer (P178) View with Reasonator View with SQID
    1 SELECT DISTINCT ?item ?itemLabel ?dev ?devLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31/wdt:P279* wd:Q7397.
    5   ?item wdt:P178 ?dev.
    6   ?dev wdt:P31/wdt:P279* wd:Q166118.
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

Software titles dev by MuseumsEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, developer (P178) View with Reasonator View with SQID
    1 SELECT DISTINCT ?item ?itemLabel ?dev ?devLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31/wdt:P279* wd:Q7397.
    5   ?item wdt:P178 ?dev.
    6   ?dev wdt:P31/wdt:P279* wd:Q33506.
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

Giving Pledge, companies, software titlesEdit

The following query uses these:

Features: Graph (Q24515287) View with Reasonator View with SQID

 1 #defaultView:Graph
 2 SELECT DISTINCT ?person ?personLabel ?image ?company ?companyLabel ("00FFFF" AS ?rgb) ?software ?softwareLabel
 3 WHERE 
 4 {
 5   
 6   wd:Q203807 wdt:P1891 ?person.
 7   ?company wdt:P112  ?person. 
 8   ?person wdt:P18 ?image.
 9   ?company wdt:P31/wdt:P279* wd:Q4830453.
10   ?software wdt:P178 ?company.
11   ?software wdt:P31/wdt:P279* wd:Q7397.
12   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
13 }

File formats with a Elhuyar ZTH IDEdit

The following query uses these:

Cad software and readable file formatsEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, readable file format (P1072) View with Reasonator View with SQID
    1 SELECT ?app ("00FFFF" AS ?rgb) ?appLabel  ?format ?formatLabel
    2 WHERE 
    3 {
    4   ?app wdt:P31/wdt:P279* wd:Q15548076.
    5  
    6   ?app wdt:P1072 ?format.
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

Bubble chart of formats sharing same extensionEdit

The following query uses these:

Features: BubbleChart (Q24515280) View with Reasonator View with SQID

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

Bubble chart of licenses used by academic institutionsEdit

The following query uses these:

Features: BubbleChart (Q24515280) View with Reasonator View with SQID

 1 #defaultView:BubbleChart
 2 SELECT DISTINCT ?license ?licenseLabel (COUNT(?software) AS ?count)
 3 WHERE 
 4 {
 5   ?item wdt:P31/wdt:P279* wd:Q4671277.
 6   ?software wdt:P31/wdt:P279* wd:Q7397.
 7   ?software wdt:P178 ?item.
 8   ?software wdt:P275 ?license.
 9   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
10 }
11 
12 GROUP BY ?license ?licenseLabel 
13 ORDER BY DESC(?count)

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

The following query uses these:

Features: BubbleChart (Q24515280) View with Reasonator View with SQID

 1 #defaultView:BubbleChart
 2 SELECT DISTINCT  ?license ?licenseLabel (COUNT(?software) AS ?count)
 3 WHERE 
 4 {
 5   ?item wdt:P31/wdt:P279* wd:Q163740.
 6   ?software wdt:P31/wdt:P279* wd:Q7397.
 7   ?software wdt:P178 ?item.
 8   ?software wdt:P275 ?license.
 9   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
10 }
11 
12 GROUP BY ?license ?licenseLabel 
13 ORDER BY DESC(?count)

Taxa named after women scientistsEdit

The following query uses these:

Features: Graph (Q24515287) View with Reasonator View with SQID

 1 #defaultView:Graph
 2 SELECT ?item ("00FFFF" AS ?rgb) ?itemLabel ?person ?personLabel ?image
 3 WHERE 
 4 {
 5   ?item wdt:P31 wd:Q16521.
 6   ?item wdt:P138 ?person.
 7   ?person wdt:P21 wd:Q6581072.
 8   ?person wdt:P106 ?occ.
 9   ?occ wdt:P279* wd:Q901.
10   OPTIONAL {?person wdt:P18 ?image}.
11   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
12 }

Anything named after women scientistsEdit

The following query uses these:

Features: Graph (Q24515287) View with Reasonator View with SQID

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

Scholarly articles by people who worked at PARC at some pointEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, employer (P108) View with Reasonator View with SQID, author (P50) View with Reasonator View with SQID, publication date (P577) View with Reasonator View with SQID
     1 SELECT ?item ?itemLabel ?article ?articleLabel ?date
     2 WHERE 
     3 {
     4   ?item wdt:P31 wd:Q5.
     5   ?item wdt:P108 wd:Q750428.
     6   ?article wdt:P31 wd:Q13442814.
     7   ?article wdt:P50 ?item. 
     8   ?article wdt:P577 ?date.
     9   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    10 }
    

Software developed by people who have been employed by PARCEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, employer (P108) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, developer (P178) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?software ?softwareLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31 wd:Q5.
    5   ?item wdt:P108 wd:Q750428.
    6   ?software wdt:P31/wdt:P279* wd:Q7397.
    7   ?software wdt:P178 ?item.
    8   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    9 }
    

Describes a project that uses X softwareEdit

The following query uses these:

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:

Features: BubbleChart (Q24515280) View with Reasonator View with SQID

 1 #defaultView:BubbleChart
 2 SELECT DISTINCT ?license ?licenseLabel (COUNT(?item) AS ?count) WHERE {
 3   ?item (wdt:P31/wdt:P279*) wd:Q7397.
 4   ?item wdt:P178 wd:Q312.
 5   
 6   ?item wdt:P275 ?license.
 7   ?license wdt:P790 wd:Q48413.
 8   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 9 }
10 GROUP BY ?license ?licenseLabel
11 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:

Features: BubbleChart (Q24515280) View with Reasonator View with SQID

 1 #defaultView:BubbleChart
 2 SELECT DISTINCT ?license ?licenseLabel (COUNT(?item) AS ?count) WHERE {
 3   ?item (wdt:P31/wdt:P279*) wd:Q7397.
 4   ?item wdt:P178 wd:Q2283.
 5   
 6   ?item wdt:P275 ?license.
 7   ?license wdt:P790 wd:Q48413.
 8   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 9 }
10 GROUP BY ?license ?licenseLabel
11 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:

Features: BubbleChart (Q24515280) View with Reasonator View with SQID

 1 #defaultView:BubbleChart
 2 SELECT DISTINCT ?license ?licenseLabel (COUNT(?item) AS ?count) WHERE {
 3   ?item (wdt:P31/wdt:P279*) wd:Q7397.
 4   ?item wdt:P178 wd:Q95.
 5   
 6   ?item wdt:P275 ?license.
 7   ?license wdt:P790 wd:Q48413.
 8   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 9 }
10 GROUP BY ?license ?licenseLabel
11 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:

Features: BubbleChart (Q24515280) View with Reasonator View with SQID

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

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

The following query uses these:

Timeline of digital container formats with logosEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, publication date (P577) View with Reasonator View with SQID, logo image (P154) View with Reasonator View with SQID, inception (P571) View with Reasonator View with SQID
    1 #defaultView:Timeline
    2 SELECT ?item ?itemLabel ?date ?inception ?logo WHERE {
    3   ?item wdt:P31 wd:Q167772.
    4   OPTIONAL { ?item wdt:P577 ?date. }
    5   OPTIONAL { ?item wdt:P154 ?logo. }
    6   OPTIONAL { ?item wdt:P571 ?date. }
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

Keyboard layouts with optional imageEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, image (P18) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?image
    2 WHERE 
    3 {
    4   ?item wdt:P31 wd:Q725744.
    5   OPTIONAL {?item wdt:P18 ?image.}
    6  
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

File formats named after other thingsEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, named after (P138) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?thing ?thingLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31/wdt:P279* wd:Q235557.
    5   ?item wdt:P138 ?thing. 
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

Data serialization formatsEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID
    1 SELECT DISTINCT ?item ?itemLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P31 wd:Q24451526.
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Image grid of the musicians who have software named after themEdit

The following query uses these:

Features: ImageGrid (Q24515278) View with Reasonator View with SQID

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

Image grid of athletes that have software named after themEdit

The following query uses these:

Features: ImageGrid (Q24515278) View with Reasonator View with SQID

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

File formats connect to more than 10 software titlesEdit

The following query uses these:

Features: BubbleChart (Q24515280) View with Reasonator View with SQID

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

Developers of software that can read file format w PUIDEdit

The following query uses these:

Software titles with a category on Wikimedia CommonsEdit

The following query uses these:

Data Serialization formats and the external ids used for themEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID
    1 SELECT DISTINCT ?item ("00FFFF" AS ?rgb) ?itemLabel ?propItem ?propItemLabel  WHERE {
    2   ?item wdt:P31 wd:Q24451526.
    3   ?item ?prop ?value.
    4   ?propItem wikibase:directClaim ?prop.
    5   ?propItem wikibase:propertyType wikibase:ExternalId.
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

Office Suites with component partsEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, has part (P527) View with Reasonator View with SQID
    1 SELECT ?item ("00FFFF" AS ?rgb) ?itemLabel ?component ?componentLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31 wd:Q207170.
    5   ?item wdt:P527 ?component. 
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

Iana service nameEdit

The following query uses these:

  • Properties: IANA service name (P5814) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?value
    2 WHERE 
    3 {
    4   ?item wdt:P5814 ?value .
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Parts of the Internet Protocol Suite and the sources that describe themEdit

The following query uses these:

Features: Graph (Q24515287) View with Reasonator View with SQID

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

Software with JSTOR topic idEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, JSTOR topic ID (P3827) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?topic ?topicLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31/wdt:P279* wd:Q7397.
    5   ?item wdt:P3827 ?topic.
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

reference manager software opt lic opt ffEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, readable file format (P1072) View with Reasonator View with SQID, license (P275) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?format ?formatLabel ?lic ?licLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31 wd:Q1403556.
    5   OPTIONAL {?item wdt:P1072 ?format.}
    6   OPTIONAL {?item wdt:P275 ?lic.}
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

Protocols that have partsEdit

The following query uses these:

Distinct file extensions in WikidataEdit

The following query uses these:

  • Properties: file extension (P1195) View with Reasonator View with SQID
    1 SELECT DISTINCT ?extension
    2 WHERE 
    3 {
    4   ?item wdt:P1195 ?extension.
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Instances of any of the types of software and their component partsEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, has part (P527) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?component ?componentLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P31 ?type.
    5   ?type wdt:P31 wd:Q28530532.
    6   ?item wdt:P527 ?component. 
    7   
    8   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    9 }
    

Software named after human biblical figureEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, named after (P138) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P31/wdt:P279* wd:Q7397.
    5   ?item wdt:P138 ?person. 
    6   ?person wdt:P31 wd:Q20643955.
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

Software named after mythological Greek characterEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, named after (P138) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P31/wdt:P279* wd:Q7397.
    5   ?item wdt:P138 ?person. 
    6   ?person wdt:P31 wd:Q22988604.
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

Image grid of software named after placesEdit

The following query uses these:

Features: ImageGrid (Q24515278) View with Reasonator View with SQID

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

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

The following query uses these:

Features: Graph (Q24515287) View with Reasonator View with SQID

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

Image grid of items with a Rosetta Code idEdit

The following query uses these:

Features: ImageGrid (Q24515278) View with Reasonator View with SQID

1 #defaultView:ImageGrid
2 SELECT ?item ?itemLabel ?image ?code
3 WHERE 
4 {
5   ?item wdt:P5047 ?code.
6   OPTIONAL {?item wdt:P18 ?image.}
7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
8 }

Software titles with ESCO skill idEdit

The following query uses these:

  • Properties: ESCO skill ID (P4644) View with Reasonator View with SQID, instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID
    1 SELECT DISTINCT ?item ?itemLabel ?value WHERE {
    2   ?item wdt:P4644 ?value.
    3   ?item (wdt:P31/wdt:P279*) wd:Q7397.
    4   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    5 }
    

Software titles with Canadiana idEdit

The following query uses these:

Women members of the ACMEdit

The following query uses these:

  • Properties: sex or gender (P21) View with Reasonator View with SQID, occupation (P106) View with Reasonator View with SQID, member of (P463) View with Reasonator View with SQID, image (P18) View with Reasonator View with SQID, instance of (P31) View with Reasonator View with SQID, author (P50) View with Reasonator View with SQID
     1 SELECT ?item ("00FFFF" AS ?rgb) ?itemLabel ?image  ?pub ?pubLabel
     2 WHERE 
     3 {
     4   ?item wdt:P21 wd:Q6581072.
     5   ?item wdt:P106 wd:Q82594.
     6   ?item wdt:P463 wd:Q127992.
     7   OPTIONAL {?item wdt:P18 ?image.}
     8   ?pub wdt:P31 wd:Q13442814.
     9   ?pub wdt:P50 ?item.
    10   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    11 }
    

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

The following query uses these:

  • Properties: PRONOM file format identifier (P2748) View with Reasonator View with SQID, readable file format (P1072) View with Reasonator View with SQID
     1 SELECT DISTINCT ?puid (COUNT(?software) AS ?count)
     2 WHERE {
     3   ?format wdt:P2748 ?puid .
     4   ?software wdt:P1072 ?format.
     5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
     6   }
     7 GROUP BY ?puid
     8 
     9 HAVING(COUNT(?software) > 9)
    10 
    11 ORDER BY DESC(?count)
    

Dataset for the aboveEdit

The following query uses these:

Bubble chart showing familiesEdit

The following query uses these:

Features: BubbleChart (Q24515280) View with Reasonator View with SQID

 1 #defaultView:BubbleChart
 2 SELECT DISTINCT   ?family ?familyLabel  (COUNT(?software) AS ?count)
 3 WHERE {
 4   ?family wdt:P31 wd:Q26085352.
 5   ?family  wdt:P527 ?format.
 6   ?software wdt:P1072 ?format.
 7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 8   }
 9 
10 GROUP BY ?family ?familyLabel
11 
12 
13 HAVING(COUNT(?software) > 5)
14 
15 
16 ORDER BY DESC(?count)

Graph viz of devs of file format families and component formatsEdit

The following query uses these:

Features: Graph (Q24515287) View with Reasonator View with SQID

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

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

The following query uses these:

  • Properties: SNAC Ark ID (P3430) View with Reasonator View with SQID, occupation (P106) View with Reasonator View with SQID, image (P18) View with Reasonator View with SQID
    1 #Items for people with the occupation 'computer scientist' that have an ID from the Social Networks Archival Contex project
    2 SELECT ?item ?itemLabel ?value ?image WHERE {
    3   ?item wdt:P3430 ?value.
    4   ?item wdt:P106 wd:Q82594.
    5   OPTIONAL { ?item wdt:P18 ?image. }
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    7 }
    

Software named after common names of animalsEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, named after (P138) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel ?class ?classLabel
    2 WHERE 
    3 {
    4   ?item wdt:P31/wdt:P279* wd:7397.
    5   ?item wdt:P138 ?class. 
    6   ?class wdt:P31 wd:Q55983715.
    7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    8 }
    

Software named after taxon or common name of animalsEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, named after (P138) View with Reasonator View with SQID, logo image (P154) View with Reasonator View with SQID, image (P18) View with Reasonator View with SQID
     1 SELECT ?item ?itemLabel ?class ?classLabel ?taxon ?taxonLabel ?logo ?image
     2 WHERE 
     3 {
     4   ?item wdt:P31/wdt:P279* wd:Q7397.
     5   ?item wdt:P138 ?class. 
     6   ?class wdt:P31 wd:Q55983715.
     7   ?item wdt:P138 ?taxon.
     8   ?taxon wdt:P31 wd:Q16521.
     9   OPTIONAL {?item wdt:P154 ?logo}.
    10   OPTIONAL {?taxon wdt:P18 ?image}.
    11 
    12   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    13 }
    

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

The following query uses these:

Features: Graph (Q24515287) View with Reasonator View with SQID

 1 #defaultView:Graph
 2 #Raster graphics editor software and the file formats they can open, optional PRONOM id for the format
 3 SELECT ?item ("00FFFF" AS ?rgb) ?itemLabel ?format ?formatLabel ?puid 
 4 WHERE 
 5 {
 6   ?item wdt:P31 wd:Q2351962 ;
 7         wdt:P1072 ?format. 
 8  {?format wdt:P2748 ?puid}
 9   UNION
10   {
11     ?format wdt:P527 ?part.
12     ?part wdt:P2748 ?puid.
13   }
14   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
15 }

using OPTIONALEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, readable file format (P1072) View with Reasonator View with SQID, PRONOM file format identifier (P2748) View with Reasonator View with SQID, has part (P527) View with Reasonator View with SQID
     1 #Raster graphics editor software and the file formats they can open, option PRONOM id for the format
     2 SELECT DISTINCT ?item ?itemLabel ?format ?formatLabel ?puid 
     3 WHERE 
     4 {
     5   {?item wdt:P31 wd:Q2351962 ;
     6         wdt:P1072 ?format. 
     7   OPTIONAL {?format wdt:P2748 ?puid}.}
     8   UNION
     9   {?item wdt:P31 wd:Q2351962 ;
    10         wdt:P1072 ?format. 
    11   ?format wdt:P527 ?part.
    12   ?part wdt:P2748 ?puid.
    13   }
    14   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    15 }
    

Software titles dev by Autodesk and readable ffEdit

The following query uses these:

Software titles that have their own subreddits and optional logo imageEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, subreddit (P3984) View with Reasonator View with SQID, logo image (P154) View with Reasonator View with SQID
    1 SELECT DISTINCT ?software ?softwareLabel ?image ?subreddit WHERE {
    2   ?software (wdt:P31/wdt:P279*) wd:Q7397.
    3   ?software wdt:P3984 ?subreddit.
    4   OPTIONAL { ?software wdt:P154 ?image. }
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Digital container formats and that have component partsEdit

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, has part (P527) View with Reasonator View with SQID
    1 SELECT DISTINCT ?item ("00FFFF" AS ?rgb) ?itemLabel ?part ?partLabel WHERE {
    2   ?item (wdt:P31/wdt:P279*) wd:Q167772.
    3   ?item wdt:P527 ?part.
    4   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    5 }
    

Software titles named after entities from TolkienEdit

The following query uses these:

Companies that are named after entities from TolkienEdit

The following query uses these: