6,317
edits
No edit summary |
|||
Line 292: | Line 292: | ||
} group by ?person ?personLabel ?statements order by desc(?residence_count) | } group by ?person ?personLabel ?statements order by desc(?residence_count) | ||
# Credit to @Tagishsimon for helping me figure out the counting logic here | # Credit to @Tagishsimon for helping me figure out the counting logic here | ||
</sparql> | |||
===People with IDs on wikidata, their date of birth on wikidata, and the source of that information=== | |||
<sparql tryit="1"> | |||
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 wdt: <http://www.wikidata.org/prop/direct/> | |||
PREFIX wd: <http://www.wikidata.org/entity/> | |||
PREFIX p: <http://www.wikidata.org/prop/> | |||
PREFIX pr: <http://www.wikidata.org/prop/reference/> | |||
PREFIX prov: <http://www.w3.org/ns/prov#> | |||
SELECT ?woman ?womanLabel ?WDitem ?WDdateOfBirth (GROUP_CONCAT(?BirthStatedInEnglish;separator=" | ") AS ?sources) | |||
WHERE { | |||
#Select all women | |||
?woman bnwdt:P3 bnwd:Q3 . | |||
#select all women that have a Wikidata link | |||
?woman bnwdt:P117 ?Qnumber . | |||
#create reference to Wikibase entity | |||
BIND(IRI(concat("http://www.wikidata.org/entity/", ?Qnumber)) as ?WDitem ) | |||
#on Wikibase do | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
#get the date of birth | |||
?WDitem wdt:P569 ?WDdateOfBirth . | |||
#get the statement of birth | |||
?WDitem p:P569 ?Birthstatement . | |||
#get its node | |||
?Birthstatement prov:wasDerivedFrom ?BirthRefnode. | |||
#get the value of 'Stated in' | |||
?BirthRefnode pr:P248 ?BirthStatedIn. | |||
#get the english label of the referece 'stated in' | |||
OPTIONAL {?BirthStatedIn rdfs:label ?BirthStatedInEnglish | |||
FILTER (LANG(?BirthStatedInEnglish) = "en")}. | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | |||
GROUP BY ?woman ?womanLabel ?WDitem ?WDdateOfBirth | |||
ORDER BY ?womanLabel | |||
# Credit to Maarten Zeinstra for developing this query | |||
</sparql> | </sparql> |
edits