579
edits
Project:SPARQL/examples: Difference between revisions
→Regions in which women resided, sorted by how many residences all women had in that region
| Line 717: | Line 717: | ||
GROUP BY ?region ?regionLabel | GROUP BY ?region ?regionLabel | ||
ORDER BY DESC(?region_count) | ORDER BY DESC(?region_count) | ||
</sparql> | |||
=== Women living in London during the 1890s === | |||
<sparql tryit="1"> | |||
# Query for women living in (greater) london in the 1890s | |||
# 1 row per person per date, can be made 1 row per person if preferred. | |||
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 distinct ?personLabel ?residenceLabel ?date_label ?date ?person ?residence | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 . # women | |||
?person bnp:P29 ?s . # resided at | |||
?s bnps:P29 ?residence . | |||
?residence bnwdt:P33+ bnwd:Q322 . # in Q322 greater london. | |||
# dates. About 30? not dated. | |||
#optional { | |||
?s ?pq ?date . | |||
# ?date wikibase:timeValue ?date_value. # if you don't want date label this should work instead | |||
?qual_prop wikibase:qualifier ?pq; | |||
wikibase:propertyType wikibase:Time ; # nb excludes edtf dates | |||
rdfs:label ?date_label . filter(lang(?date_label)="en-gb") . # what kind of date is it. | |||
# } # /dates | |||
# filter 1890-1899 | |||
FILTER("1890-01-01"^^xsd:dateTime <= ?date && ?date < "1899-12-31"^^xsd:dateTime). | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | |||
ORDER BY ?person ?date | |||
</sparql> | </sparql> | ||