Timezones
Jump to navigation
Jump to search
Wikidata Query
# truly tabular naive query for
# Q12143:time zone
# generated by trulytabular.py version 0.4.11 on 2023-12-04T08:20:24.181324
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX schema: <http://schema.org/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?time_zoneItem ?time_zone
?UTC_timezone_offset
?IANA_timezone_ID
?short_name
WHERE {
# instanceof Q12143:time zone
?time_zoneItem wdt:P31/wdt:P279* wd:Q12143.
# label
?time_zoneItem rdfs:label ?time_zone.
FILTER (LANG(?time_zone) = "en").
# UTC timezone offset (P2907)
OPTIONAL {
?time_zoneItem wdt:P2907 ?UTC_timezone_offset.
}
# IANA timezone ID (P6687)
OPTIONAL {
?time_zoneItem wdt:P6687 ?IANA_timezone_ID.
}
OPTIONAL {
?time_zoneItem wdt:P1813 ?short_name .
FILTER (LANG(?short_name) = "en").
}
} ORDER BY ?short_name