646
edits
Project:SPARQL/examples: Difference between revisions
From Beyond Notability
→Position held item / free text
| Line 3,894: | Line 3,894: | ||
} | } | ||
order by ?byLabel ?personLabel ?date ?degreeLabel | order by ?byLabel ?personLabel ?date ?degreeLabel | ||
</sparql> | |||
=== Position held: item v free text === | |||
<sparql tryit="1"> | |||
# held position job titles item v held position free text | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | |||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | |||
PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/> | |||
PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/> | |||
PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/> | |||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | |||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | |||
PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/> | |||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | |||
SELECT | |||
?work_label ?positionLabel ?position (count(*) as ?count) | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 . # women | |||
# get work activities: held position / held position (free text) / employed as | |||
?person ( bnp:P17|bnp:P48 ) ?s . | |||
?person ?work_p ?s . # for work type label | |||
?work wikibase:claim ?work_p; | |||
rdfs:label ?work_label. filter(lang(?work_label)="en") . | |||
# more about the position | |||
?s ( bnps:P17|bnps:P48 ) ?position . | |||
FILTER( !isBLANK(?position) ) . # filter out <unknown value> | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | |||
group by ?work_label ?positionLabel ?position | |||
order by lcase(str(?positionLabel)) | |||
</sparql> | </sparql> | ||
