query-97320d429bc894d582b26e6ec6003766
updated 2019-09-27 SELECT ?h ?date WHERE { ?h wdt:P31 wd:Q5 . ?h wdt:P569 ?date . OPTIONAL {?h wdt:P570 ?d } FILTER (?date > "1601-01-01T00:00:00Z"^^xsd:dateTime) FILTER (?date < "1880-01-01T00:00:00Z"^^xsd:dateTime) FILTER (!bound(?d)) } LIMIT 100 updated 2019-09-27 SELECT ?h ?date WHERE { ?h wdt:P31 wd:Q5 . ?h wdt:P569 ?date . OPTIONAL {?h wdt:P570 ?d } FILTER (?date > "1601-01-01T00:00:00Z"^^xsd:dateTime) FILTER (?date < "1880-01-01T00:00:00Z"^^xsd:dateTime) FILTER (!bound(?d)) } LIMIT 100 updated 2019-09-27 SELECT ?h ?date WHERE { ?h wdt:P31 wd:Q5 . ?h wdt:P569 ?date . OPTIONAL {?h wdt:P570 ?d } FILTER (?date > "1601-01-01T00:00:00Z"^^xsd:dateTime) FILTER (?date < "1880-01-01T00:00:00Z"^^xsd:dateTime) FILTER (!bound(?d)) } LIMIT 100 updated 2019-09-27 SELECT ?h ?date WHERE { ?h wdt:P31 wd:Q5 . ?h wdt:P569 ?date . OPTIONAL {?h wdt:P570 ?d } FILTER (?date > "1601-01-01T00:00:00Z"^^xsd:dateTime) FILTER (?date < "1880-01-01T00:00:00Z"^^xsd:dateTime) FILTER (!bound(?d)) } LIMIT 100 updated 2019-09-27 SELECT ?h ?date WHERE { ?h wdt:P31 wd:Q5 . ?h wdt:P569 ?date . OPTIONAL {?h wdt:P570 ?d } FILTER (?date > "1601-01-01T00:00:00Z"^^xsd:dateTime) FILTER (?date < "1880-01-01T00:00:00Z"^^xsd:dateTime) FILTER (!bound(?d)) } LIMIT 100 updated 2019-09-27 SELECT ?h ?date WHERE { ?h wdt:P31 wd:Q5 . ?h wdt:P569 ?date . OPTIONAL {?h wdt:P570 ?d } FILTER (?date > "1601-01-01T00:00:00Z"^^xsd:dateTime) FILTER (?date < "1880-01-01T00:00:00Z"^^xsd:dateTime) FILTER (!bound(?d)) } LIMIT 100 updated 2019-09-27 SELECT ?h ?date WHERE { ?h wdt:P31 wd:Q5 . ?h wdt:P569 ?date . OPTIONAL {?h wdt:P570 ?d } FILTER (?date > "1601-01-01T00:00:00Z"^^xsd:dateTime) FILTER (?date < "1880-01-01T00:00:00Z"^^xsd:dateTime) FILTER (!bound(?d)) } LIMIT 100 updated 2019-09-27 SELECT ?h ?date WHERE { ?h wdt:P31 wd:Q5 . ?h wdt:P569 ?date . OPTIONAL {?h wdt:P570 ?d } FILTER (?date > "1601-01-01T00:00:00Z"^^xsd:dateTime) FILTER (?date < "1880-01-01T00:00:00Z"^^xsd:dateTime) FILTER (!bound(?d)) } LIMIT 100 updated 2019-09-27 SELECT ?h ?date WHERE { ?h wdt:P31 wd:Q5 . ?h wdt:P569 ?date . OPTIONAL {?h wdt:P570 ?d } FILTER (?date > "1601-01-01T00:00:00Z"^^xsd:dateTime) FILTER (?date < "1880-01-01T00:00:00Z"^^xsd:dateTime) FILTER (!bound(?d)) } LIMIT 100
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
# updated 2019-09-27
SELECT ?h ?date
WHERE
{
?h wdt:P31 wd:Q5 .
?h wdt:P569 ?date .
OPTIONAL {?h wdt:P570 ?d }
FILTER (?date > "1601-01-01T00:00:00Z"^^xsd:dateTime)
FILTER (?date < "1880-01-01T00:00:00Z"^^xsd:dateTime)
FILTER (!bound(?d))
}
LIMIT 100
Query found at
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/cs
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/en
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/es
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/fr
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/ja
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/nl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/pl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/sv
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/uk