Project:SPARQL/examples: Difference between revisions
From Beyond Notability
(add comment to regex) |
(add people in wiki query) |
||
Line 1: | Line 1: | ||
==Examples== | ==Examples== | ||
===People in the wiki, excluding the project team=== | |||
<sparql tryit="1"> | |||
PREFIX a: <http://beyond-notability.wiki.opencura.com/entity/> | |||
PREFIX b: <http://beyond-notability.wiki.opencura.com/prop/direct/> | |||
SELECT ?id ?name | |||
WHERE { | |||
?id rdfs:label ?name . | |||
?id b:P3 ?idGender . #this line assumes that items for people have a gender value | |||
FILTER NOT EXISTS {?id b:P4 a:Q12 .} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | |||
</sparql> | |||
===People whose elections were proposed by men=== | ===People whose elections were proposed by men=== |
Revision as of 10:27, 14 September 2021
Examples
People in the wiki, excluding the project team
PREFIX a: <http://beyond-notability.wiki.opencura.com/entity/>
PREFIX b: <http://beyond-notability.wiki.opencura.com/prop/direct/>
SELECT ?id ?name
WHERE {
?id rdfs:label ?name .
?id b:P3 ?idGender . #this line assumes that items for people have a gender value
FILTER NOT EXISTS {?id b:P4 a:Q12 .}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
}
People whose elections were proposed by men
PREFIX a: <http://beyond-notability.wiki.opencura.com/entity/>
PREFIX b: <http://beyond-notability.wiki.opencura.com/prop/direct/>
SELECT ?personLabel ?persongenderLabel ?electorLabel ?Date
WHERE {
?person b:P7 ?elector ;
b:P3 ?persongender .
?elector b:P3 a:Q10 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
}
People whose name in the records begin with 'Mrs'
SELECT ?id ?name
WHERE {
?id rdfs:label ?name .
FILTER regex(?name, "mrs *", "i") #this line uses regular expression syntax, described at https://regexper.com/#mrs%5Cs*
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
}
All triples in the wiki, limited to 1000
SELECT ?a ?aLabel ?b ?c WHERE {
?a ?b ?c
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
}
LIMIT 1000 #please don't make this number too big as it will slow down the site!