7,737
edits
(→People) |
|||
Line 804: | Line 804: | ||
GROUP BY ?organisation ?organisationLabel | GROUP BY ?organisation ?organisationLabel | ||
ORDER BY DESC(?organisation_count) | ORDER BY DESC(?organisation_count) | ||
</sparql> | |||
===Women educated at a tertiary educational institution located in Oxford or Cambridge=== | |||
<sparql tryit="1"> | |||
# Women educated at a tertiary educational institution located in Oxford or Cambridge | |||
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/> | |||
SELECT ?woman ?womanLabel ?educationalinstitution ?educationalinstitutionLabel ?location ?locationLabel | |||
WHERE { | |||
{?woman bnwdt:P3 bnwd:Q3 . #filter women | |||
?woman bnwdt:P94 ?educationalinstitution . #find 'educated at' statement | |||
?educationalinstitution bnwdt:P12 bnwd:Q2914 . #filter to tertiary educational institutions | |||
?educationalinstitution bnwdt:P2 ?location . #find location of educational institution | |||
?location rdfs:label ?locationLabel . | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
FILTER(LANG(?locationLabel) = "en") . | |||
FILTER(regex(?locationLabel, "oxford", "i")) .} | |||
UNION | |||
{?woman bnwdt:P3 bnwd:Q3 . #filter women | |||
?woman bnwdt:P94 ?educationalinstitution . #find 'educated at' statement | |||
?educationalinstitution bnwdt:P12 bnwd:Q2914 . #filter to tertiary educational institutions | |||
?educationalinstitution bnwdt:P2 ?location . #find location of educational institution | |||
?location rdfs:label ?locationLabel . | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
FILTER(LANG(?locationLabel) = "en") . | |||
FILTER(regex(?locationLabel, "Cambridge$", "i")) .} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | |||
ORDER BY ?womanLabel | |||
</sparql> | </sparql> | ||