query-3f40b135495fa96c050f046bed481680
Wikidata Query Service erroneously formats/fills partial dates into full dates. How can this be fixed?: 1830 instead of just 1 January 1830 (census). But when running the query, it displays 1830 point in time has a population of 1,624 with Ruinen (Q1007156)When querying some places with population having partial dates of point in time, the results display an erroneous full date instead of the exact partial date. For example,
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
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 ?place ?placeLabel ?populationLabel ?populationDate WHERE {
?place wdt:P131 wd:Q835108;
p:P1082 ?place_statement.
?place_statement ps:P1082 ?population;
pq:P585 ?populationDate.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY (?place) (?populationDate)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?place"):::projected
v3("?place_statement")
v4("?population")
v2("?populationDate"):::projected
c2(["wd:Q835108"]):::iri
c7(["bd:serviceParam"]):::iri
c9(["en"]):::literal
v1 --"p:direct/P131"--> c2
v1 --"p:P1082"--> v3
v3 --"p:statement/P1082"--> v4
v3 --"p:qualifier/P585"--> v2
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end