User:YULdigitalpreservation/SPARQL2020
This is a page of SPARQL queries
editCryptographic Hash Functions
editThe following query uses these:
- Properties: instance of (P31) , subclass of (P279)
SELECT ?item ?itemLabel WHERE { ?item wdt:P31/wdt:P279* wd:Q477202. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Subclasses of cryptographic hash function
editThe following query uses these:
- Properties: subclass of (P279)
SELECT ?item ?itemLabel WHERE { ?item wdt:P279 wd:Q477202. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
ontologies
editThe following query uses these:
- Items: ontology (Q324254)
- Properties: instance of (P31) , subclass of (P279)
SELECT ?item ?itemLabel WHERE { ?item wdt:P31/wdt:P279* wd:Q324254. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Items that have "xml namespace" property values
editThe following query uses these:
- Properties: XML namespace URL (P7510)
SELECT ?item ?itemLabel ?value WHERE { ?item wdt:P7510 ?value . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
ontologies w count of statements
editThe following query uses these:
- Items: ontology (Q324254)
- Properties: instance of (P31) , subclass of (P279)
SELECT ?item ?itemLabel ?statementscount WHERE { ?item wdt:P31/wdt:P279* wd:Q324254; wikibase:statements ?statementscount. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Influenced by Quentin Matsys
editThe following query uses these:
- Items: Quinten Metsys (Q314275)
- Properties: influenced by (P737)
SELECT ?item ?itemLabel WHERE { ?item wdt:P737 wd:Q314275. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Members of Zigbee Alliance
editThe following query uses these:
- Items: Zigbee Alliance (Q79100838)
- Properties: member of (P463)
SELECT ?item ?itemLabel WHERE { ?item wdt:P463 wd:Q79100838. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Businesses that are part of the CAC 40
editThe following query uses these:
- Items: CAC 40 (Q648828)
- Properties: part of (P361)
SELECT ?item ?itemLabel WHERE { ?item wdt:P361 wd:Q648828. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
markup languages
editThe following query uses these:
- Items: markup language (Q37045)
- Properties: instance of (P31)
SELECT ?item ?itemLabel WHERE { ?item wdt:P31 wd:Q37045. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
orgs w id in Manuals library
editThe following query uses these:
- Properties: ManualsLib brand ID (P6422)
SELECT ?item ?itemLabel ?value WHERE { ?item wdt:P6422 ?value . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
items w central index key
editThe following query uses these:
- Properties: Central Index Key (P5531)
SELECT ?item ?itemLabel ?value WHERE { ?item wdt:P5531 ?value . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
members of fido alliance
editThe following query uses these:
- Items: FIDO Alliance (Q15731702)
- Properties: member of (P463)
SELECT ?item ?itemLabel WHERE { ?item wdt:P463 wd:Q15731702. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
submarine communications cables
editThe following query uses these:
- Properties: instance of (P31) , subclass of (P279)
SELECT DISTINCT ?item ?itemLabel WHERE { ?item wdt:P31/wdt:P279* wd:Q506572. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
uses of data size
editThe following query uses these:
- Properties: data size (P3575)
SELECT ?item ?itemLabel ?value WHERE { ?item wdt:P3575 ?value . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
items that support programming languages
editThe following query uses these:
- Properties: supports programming language (P3985)
SELECT ?item ?itemLabel ?value WHERE { ?item wdt:P3985 ?value . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
communications satellites
editThe following query uses these:
- Properties: instance of (P31)
SELECT ?item ?itemLabel WHERE { ?item wdt:P31 wd:Q149918. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
formats w puid described by source, source is avail online
editThe following query uses these:
- Properties: PRONOM file format ID (P2748) , described by source (P1343) , full work available at URL (P953)
SELECT ?item ?itemLabel ?puid ?sourceLabel ?url WHERE { ?item wdt:P2748 ?puid. ?item wdt:P1343 ?source. ?source wdt:P953 ?url. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
standards that have a file format as a main subject
editThe following query uses these:
- Properties: instance of (P31) , main subject (P921) , subclass of (P279) , file extension (P1195)
SELECT ?item ?itemLabel ?ext ?subjectLabel WHERE { ?item wdt:P31 wd:Q317623. ?item wdt:P921 ?subject. ?subject wdt:P31/wdt:P279* wd:Q235557. ?subject wdt:P1195 ?ext. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
character encodings
editThe following query uses these:
- Items: character encoding (Q184759)
- Properties: instance of (P31)
SELECT ?item ?itemLabel WHERE { ?item wdt:P31 wd:Q184759. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
file formats that can be opened by a software title
editThe following query uses these:
- Items: file format (Q235557)
- Properties: instance of (P31) , subclass of (P279) , readable file format (P1072)
SELECT ?item ?itemLabel WHERE { ?item wdt:P31/wdt:P279* wd:Q235557. ?software wdt:P1072 ?item. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
members of Jquery Foundation
editThe following query uses these:
- Properties: member of (P463)
SELECT ?item ?itemLabel WHERE { ?item wdt:P463 wd:Q80656429. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
members of Business Software Alliance
editThe following query uses these:
- Properties: member of (P463)
SELECT ?item ?itemLabel WHERE { ?item wdt:P463 wd:Q852297. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
software titles named after a place that has a locator map image
editThe following query uses these:
- Items: software (Q7397)
- Properties: instance of (P31) , subclass of (P279) , named after (P138) , locator map image (P242)
SELECT ?item ?itemLabel ?placeLabel ?map WHERE { ?item wdt:P31/wdt:P279* wd:Q7397. ?item wdt:P138 ?place. ?place wdt:P242 ?map. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
datapacks
editThe following query uses these:
- Items: data pack (Q5227330)
- Properties: instance of (P31)
SELECT ?item ?itemLabel WHERE { ?item wdt:P31 wd:Q5227330. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
standards approved by the OSAC Registry
editThe following query uses these:
- Items: OSAC Registry (Q84081043)
- Properties: approved by (P790) , title (P1476)
SELECT ?item ?itemLabel ?title WHERE { ?item wdt:P790 wd:Q84081043. OPTIONAL {?item wdt:P1476 ?title}. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
software titles with Microsoft Academic ID
editThe following query uses these:
- Items: software (Q7397)
- Properties: instance of (P31) , subclass of (P279) , Microsoft Academic ID (P6366)
SELECT ?item ?itemLabel WHERE { ?item wdt:P31/wdt:P279* wd:Q7397. ?item wdt:P6366 ?microsoftAcademic. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
software types by count of titles
editThe following query uses these:
- Properties: instance of (P31)
SELECT ?item ?itemLabel (COUNT (?title) as ?count) WHERE { ?item wdt:P31 wd:Q17155032. ?title wdt:P31 ?item. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?item ?itemLabel ORDER BY DESC(?count)
Projects of the Linux Foundation
editThe following query uses these:
- Properties: instance of (P31)
SELECT ?item ?itemLabel WHERE { ?item wdt:P31 wd:Q39998995. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Items with a Can You Run It? id
editThe following query uses these:
- Properties: Can You Run it ID (P7909)
SELECT ?item ?itemLabel ?value WHERE { ?item wdt:P7909 ?value. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Software titles with a commons category link
editThe following query uses these:
- Items: software (Q7397)
- Properties: instance of (P31) , subclass of (P279) , Commons category (P373)
SELECT DISTINCT ?item ?itemLabel ?commons WHERE { ?item wdt:P31/wdt:P279* wd:Q7397. ?item wdt:P373 ?commons. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Computer scientists whose last words have been recorded in WD
editThe following query uses these:
- Items: computer scientist (Q82594)
- Properties: occupation (P106) , last words (P3909)
SELECT ?item ?itemLabel ?lastwords WHERE { ?item wdt:P106 wd:Q82594. ?item wdt:P3909 ?lastwords. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
People credited with the development of one or more software titles who are vegans
editThe following query uses these:
- Items: veganism (Q181138)
- Properties: developer (P178) , lifestyle (P1576)
SELECT ?item ?itemLabel ?dev ?devLabel ?style ?styleLabel WHERE { ?item wdt:P178 ?dev. ?dev wdt:P1576 wd:Q181138 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
File formats with FFID, encoding, offset and relative to info
editThe following query uses these:
- Properties: file format identification pattern (P4152) , encoding (P3294) , offset (P4153) , relative to (P2210)
SELECT DISTINCT ?item ?itemLabel ?value ?valueLabel ?ofset ?to WHERE { ?item wdt:P4152 ?url. ?item p:P4152 _:b6. _:b6 pq:P3294 ?value. _:b6 pq:P4153 ?ofset. _:b6 pq:P2210 ?to. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Foundations in the US and their founders
editThe following query uses these:
- Properties: instance of (P31) , country (P17) , founded by (P112)
SELECT ?item ?itemLabel ?founder ?founderLabel WHERE { ?item wdt:P31 wd:Q157031. ?item wdt:P17 wd:Q30. ?item wdt:P112 ?founder. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Businesses in the software industry with a WorldCat Identifiers ID
editThe following query uses these:
- Properties: instance of (P31) , subclass of (P279) , industry (P452) , P7859
SELECT ?item ?itemLabel ?worldCatIdentitiesID WHERE { ?item wdt:P31/wdt:P279* wd:Q4830453. ?item wdt:P452 wd:Q880371. ?item wdt:P7859 ?worldCatIdentitiesID. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Software titles whose developer has a worldcat identity id
editThe following query uses these:
- Items: software (Q7397)
- Properties: instance of (P31) , subclass of (P279) , developer (P178) , P7859
SELECT ?item ?itemLabel ?worldCatIdentitiesID WHERE { ?item wdt:P31/wdt:P279* wd:Q7397. ?item wdt:P178 ?company. ?company wdt:P7859 ?worldCatIdentitiesID. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Members of the SD Association
editThe following query uses these:
- Items: SD Association (Q7389502)
- Properties: member of (P463)
SELECT ?item ?itemLabel WHERE { ?item wdt:P463 wd:Q7389502. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
File formats based on OLE2
editThe following query uses these:
- Properties: based on (P144)
SELECT ?item ?itemLabel WHERE { ?item wdt:P144 wd:Q5156830. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
File formats w LOC FDD but no pronom
editThe following query uses these:
- Items: file format (Q235557)
- Properties: instance of (P31) , subclass of (P279) , Library of Congress Format Description Document ID (P3266) , PRONOM file format ID (P2748)
SELECT ?item ?itemLabel ?fdd WHERE { ?item wdt:P31/wdt:P279* wd:Q235557. ?item wdt:P3266 ?fdd. FILTER(NOT EXISTS { ?item wdt:P2748 ?puid. }) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
de facto standards named after people
editThe following query uses these:
- Items: de facto standard (Q385853) , human (Q5)
- Properties: instance of (P31) , named after (P138)
SELECT ?item ?itemLabel ?person ?personLabel WHERE { ?item wdt:P31 wd:Q385853. ?item wdt:P138 ?person. ?person wdt:P31 wd:Q5. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Companies/brands with manuals library brand id
editThe following query uses these:
- Properties: ManualsLib brand ID (P6422)
SELECT ?item ?itemLabel ?value WHERE { ?item wdt:P6422 ?value . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Companies that produce software with a catchphrase
editThe following query uses these:
- Items: business (Q4830453) , software (Q7397)
- Properties: instance of (P31) , product, material, or service produced or provided (P1056) , catchphrase (P6251)
SELECT ?item ?itemLabel ?phrase WHERE { ?item wdt:P31 wd:Q4830453. ?item wdt:P1056 wd:Q7397. ?item wdt:P6251 ?phrase. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Items that are file formats and technical standards
editThe following query uses these:
- Properties: instance of (P31) , subclass of (P279)
SELECT DISTINCT ?item ?itemLabel WHERE { ?item wdt:P31/wdt:P279* wd:Q317623. ?item wdt:P31/wdt:P279* wd:Q235557. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Map with Layers by PUID of hq locations of format developer
editThe following query uses these:
- Properties: PRONOM file format ID (P2748) , developer (P178) , headquarters location (P159) , coordinate location (P625)
Features: map (Q24515275)
#defaultView:Map{"layer": "?pro"}
SELECT ?dev ?devLabel ?location ?locationLabel ?hqLabel ?coord ?pro WHERE {
?item wdt:P2748 ?pro.
?item wdt:P178 ?dev.
?dev wdt:P159 ?hq.
?hq wdt:P625 ?coord.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
File formats + date modified
editThe following query uses these:
- Items: file format (Q235557)
- Properties: instance of (P31) , subclass of (P279)
SELECT ?item ?itemLabel ?date_modified WHERE { ?item wdt:P31/wdt:P279* wd:Q235557; schema:dateModified ?date_modified . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
File format families that do not have a pronom identifier
editThe following query uses these:
- Properties: instance of (P31) , PRONOM file format ID (P2748) , subclass of (P279)
SELECT ?item ?itemLabel WHERE { ?item wdt:P31 wd:Q26085352. FILTER NOT EXISTS {?item wdt:P2748 ?pronom}. #?format wdt:P279 ?item. #?format wdt:P2748 ?pronom. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Software categories that are not subclasses of software 252 of these on 29 may 2020
editThe following query uses these:
- Properties: instance of (P31) , subclass of (P279)
SELECT ?item ?itemLabel WHERE { ?item wdt:P31 wd:Q17155032. FILTER NOT EXISTS {?item wdt:P279 wd:Q7397}. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Software categories that are subclasses of software
editThere are 46 on 29 may 2020
The following query uses these:
- Properties: instance of (P31) , PRONOM file format ID (P2748) , subclass of (P279)
SELECT ?item ?itemLabel WHERE { ?item wdt:P31 wd:Q26085352. FILTER NOT EXISTS {?item wdt:P2748 ?pronom}. #?format wdt:P279 ?item. #?format wdt:P2748 ?pronom. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Software w maintainer
editThe following query uses these:
- Items: software (Q7397)
- Properties: instance of (P31) , subclass of (P279) , maintained by (P126)
SELECT ?item ?itemLabel ?maintainerLabel WHERE { ?item wdt:P31/wdt:P279* wd:Q7397. ?item wdt:P126 ?maintainer. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Expanded software with described at URL
editThe following query uses these:
- Properties: instance of (P31) , subclass of (P279) , described at URL (P973)
SELECT ?item ?itemLabel ?url WHERE { {?item wdt:P31/wdt:P279 wd:Q7397} UNION { ?item wdt:P31 ?class. {?class wdt:P279* wd:Q7397} UNION {?class wdt:P31 wd:Q17155032}.} ?item wdt:P973 ?url. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }