Documenting and preserving programming languages and software in Wikidata
John Samuel, Katherine Thornton, Kenneth Seals-Nutt
CPE Lyon, EaaSI
SWIB 2018, Bonn, 27th November, 2018
http://histropedia.com/timeline/d98rtpg9bg0t/Programming-languages
SELECT ?paradigmLabel (count(?prog) as ?count)
{
?prog wdt:P31 wd:Q9143;
wdt:P3966 ?paradigm.
SERVICE wikibase:label { bd:serviceParam
wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP by ?paradigmLabel
HAVING (?count>1)
SELECT ?progLabel (count(?paradigm) as ?count)
{
?prog wdt:P31 wd:Q9143;
wdt:P3966 ?paradigm.
SERVICE wikibase:label { bd:serviceParam
wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP by ?progLabel
HAVING (?count>2)
SELECT ?languageLabel (count(?label) as ?count) {
{
SELECT DISTINCT ?languageLabel ?label (lang(?label) as ?langLabel) {
?language wdt:P31/wdt:P279* wd:Q9143;
rdfs:label ?label.
SERVICE wikibase:label { bd:serviceParam
wikibase:language "[AUTO_LANGUAGE],en". }
}
}
}
GROUP by ?languageLabel
HAVING (?count > 50)
ORDER by DESC(?count)
SELECT ?softwareLabel (count(?label) as ?count) {
{
SELECT DISTINCT ?softwareLabel ?label (lang(?label) as ?langLabel) {
?software wdt:P31/wdt:P279 wd:Q7397;
rdfs:label ?label.
SERVICE wikibase:label { bd:serviceParam
wikibase:language "[AUTO_LANGUAGE],en". }
}
}
}
GROUP by ?softwareLabel
HAVING (?count > 40)
ORDER by DESC(?count)
SELECT ?langLabel (count(?language) as ?count) {
{
SELECT DISTINCT (lang(?label) as ?langLabel) ?language {
?language wdt:P31/wdt:P279* wd:Q9143;
rdfs:label ?label.
}
}
}
GROUP by ?langLabel
ORDER by DESC(?count)
SELECT ?langLabel (count(?software) as ?count) {
{
SELECT DISTINCT (lang(?label) as ?langLabel) ?software {
?software wdt:P31/wdt:P279* wd:Q7397;
rdfs:label ?label.
}
}
}
GROUP by ?langLabel
ORDER by DESC(?count)
SELECT DISTINCT ?languageLabel ?sitelinks {
?language wdt:P31/wdt:P279* wd:Q9143;
wikibase:sitelinks ?sitelinks.
FILTER(?sitelinks > 20)
SERVICE wikibase:label { bd:serviceParam
wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER by DESC(?sitelinks)
SELECT DISTINCT ?softwareLabel ?sitelinks {
?software wdt:P31/wdt:P279* wd:Q7397;
wikibase:sitelinks ?sitelinks.
FILTER(?sitelinks > 100)
SERVICE wikibase:label { bd:serviceParam
wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER by DESC(?sitelinks)
SELECT ?lang (count(?progLanguage) as ?count) {
{
SELECT DISTINCT ?progLanguage ?lang {
?progLanguage wdt:P31/wdt:P279* wd:Q9143.
[] schema:about ?progLanguage;
schema:inLanguage ?lang.
}
}
}
GROUP BY ?lang
ORDER BY DESC(?count)
SELECT ?lang (count(?software) as ?count) {
{
SELECT DISTINCT ?software ?lang {
?software wdt:P31/wdt:P279* wd:Q7397.
[] schema:about ?software;
schema:inLanguage ?lang.
}
}
}
GROUP BY ?lang
ORDER BY DESC(?count)
SELECT ?item ?itemLabel (COUNT(DISTINCT ?software) AS ?count) WHERE {
?software (wdt:P31/wdt:P279*) wd:Q7397.
?software wdt:P275 ?item.
?item wdt:P790 wd:Q48413.
SERVICE wikibase:label { bd:serviceParam
wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?item ?itemLabel
ORDER BY DESC(?count)
SELECT ?item ?itemLabel ?LCNAF ?GND
WHERE
{
?item wdt:P31 wd:Q18343316.
OPTIONAL {?item wdt:P244 ?LCNAF}.
OPTIONAL {?item wdt:P227 ?GND}.
SERVICE wikibase:label { bd:serviceParam
wikibase:language "[AUTO_LANGUAGE],en". }
}
SELECT ?member ?memberLabel ?software ?softwareLabel WHERE {
?member wdt:P463 wd:Q2514863.
?software wdt:P178 ?member.
SERVICE wikibase:label { bd:serviceParam
wikibase:language "[AUTO_LANGUAGE],en". }
}