query-44a82f6ab41f51a83801bf3e4714722a
Query dates with instance of statement with Gregorian date earlier than 1584 ).contribs • [[User talk:|talk]] ([[User:|?]] comment was added byunsignedThe preceding – What's the best way to query date of birth (P569) that are instances of statement with Gregorian date earlier than 1584 (Q26961029)? Try: 10 LIMIT } } ."[AUTO_LANGUAGE],en" language:wikibase serviceParam:bd { label:wikibase SERVICE ] ?dob P569:ps ; Q26961029:wd P31:pq [ P569:p ?item { WHERE ?dob ?itemLabel ?item SELECT 17:42, 14 June 2019 (UTC) JuraCurrently gives 50412 items. --- 18:26, 14 June 2019 (UTC)) talk (Clifford Anderson: Thanks so much for the quick response! This query is exactly what I was looking for. May I ask another quick follow up question? Is it possible to filter these by certain inexact date ranges, e.g. '14. century BCE'. Jura@
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?dob ?a ?b ?precision
WHERE
{
?item p:P569 [ pq:P31 wd:Q26961029 ; ps:P569 ?dob ]
FILTER ( YEAR( ?dob) > -1400 && YEAR( ?dob) < -100 )
?item p:P569 ?st .
?st ps:P569 ?dob ; psv:P569/wikibase:timePrecision ?precision .
FILTER( ?precision = 11)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
LIMIT 10