80,516
edits
Querying: Difference between revisions
→Duration, start and end dates
| Line 29: | Line 29: | ||
=== Duration, start and end dates === | === Duration, start and end dates === | ||
Duration between start and end date of every region with a start date, as well as region type. [https://tinyurl.com/2k8h75bz run] | Duration between start and end date of every region with a start date, as well as region type. [https://tinyurl.com/2k8h75bz run] | ||
SELECT ?regionLabel ?statusLabel (YEAR(?starttime) as ?start) (YEAR(?endtime) as ?end) ?duration | SELECT ?regionLabel ?statusLabel (YEAR(?starttime) as ?start) (YEAR(?endtime) as ?end) ?duration | ||
| Line 46: | Line 44: | ||
} | } | ||
ORDER BY desc(?duration) | ORDER BY desc(?duration) | ||
== Federated query with Wikidata == | == Federated query with Wikidata == | ||