query-a7816847a1adf7dec58579fcdc9f199a

rq turtle/ttl

added before 2016-10

SELECT ?person ?personLabel ?duration WHERE { ?person wdt:P31 wd:Q5; ?p [ pq:P580 ?start; pq:P582 ?end ]. BIND(ROUND((?end - ?start)/365.2425) AS ?duration). FILTER(?duration > 100). FILTER(?p != p:P119) . # "place of burial" can be an exception SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?duration) added before 2016-10

SELECT ?person ?personLabel ?duration WHERE { ?person wdt:P31 wd:Q5; ?p [ pq:P580 ?start; pq:P582 ?end ]. BIND(ROUND((?end - ?start)/365.2425) AS ?duration). FILTER(?duration > 100). FILTER(?p != p:P119) . # "place of burial" can be an exception SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?duration) added before 2016-10

SELECT ?person ?personLabel ?duration WHERE { ?person wdt:P31 wd:Q5; ?p [ pq:P580 ?start; pq:P582 ?end ]. BIND(ROUND((?end - ?start)/365.2425) AS ?duration). FILTER(?duration > 100). FILTER(?p != p:P119) . # "place of burial" can be an exception SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?duration) added before 2016-10

SELECT ?person ?personLabel ?duration WHERE { ?person wdt:P31 wd:Q5; ?p [ pq:P580 ?start; pq:P582 ?end ]. BIND(ROUND((?end - ?start)/365.2425) AS ?duration). FILTER(?duration > 100). FILTER(?p != p:P119) . # "place of burial" can be an exception SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?duration) added before 2016-10

SELECT ?person ?personLabel ?duration WHERE { ?person wdt:P31 wd:Q5; ?p [ pq:P580 ?start; pq:P582 ?end ]. BIND(ROUND((?end - ?start)/365.2425) AS ?duration). FILTER(?duration > 100). FILTER(?p != p:P119) . # "place of burial" can be an exception SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?duration) added before 2016-10

SELECT ?person ?personLabel ?duration WHERE { ?person wdt:P31 wd:Q5; ?p [ pq:P580 ?start; pq:P582 ?end ]. BIND(ROUND((?end - ?start)/365.2425) AS ?duration). FILTER(?duration > 100). FILTER(?p != p:P119) . # "place of burial" can be an exception SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?duration) added before 2016-10

SELECT ?person ?personLabel ?duration WHERE { ?person wdt:P31 wd:Q5; ?p [ pq:P580 ?start; pq:P582 ?end ]. BIND(ROUND((?end - ?start)/365.2425) AS ?duration). FILTER(?duration > 100). FILTER(?p != p:P119) . # "place of burial" can be an exception SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?duration) added before 2016-10

SELECT ?person ?personLabel ?duration WHERE { ?person wdt:P31 wd:Q5; ?p [ pq:P580 ?start; pq:P582 ?end ]. BIND(ROUND((?end - ?start)/365.2425) AS ?duration). FILTER(?duration > 100). FILTER(?p != p:P119) . # "place of burial" can be an exception SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?duration) added before 2016-10

SELECT ?person ?personLabel ?duration WHERE { ?person wdt:P31 wd:Q5; ?p [ pq:P580 ?start; pq:P582 ?end ]. BIND(ROUND((?end - ?start)/365.2425) AS ?duration). FILTER(?duration > 100). FILTER(?p != p:P119) . # "place of burial" can be an exception SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?duration) added before 2016-10

SELECT ?person ?personLabel ?duration WHERE { ?person wdt:P31 wd:Q5; ?p [ pq:P580 ?start; pq:P582 ?end ]. BIND(ROUND((?end - ?start)/365.2425) AS ?duration). FILTER(?duration > 100). FILTER(?p != p:P119) . # "place of burial" can be an exception SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?duration)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#added before 2016-10

SELECT ?person ?personLabel ?duration
WHERE
{
  ?person wdt:P31 wd:Q5;
          ?p [ pq:P580 ?start; pq:P582 ?end ].
  BIND(ROUND((?end - ?start)/365.2425) AS ?duration).
  FILTER(?duration > 100).
  FILTER(?p != p:P119) . # "place of burial" can be an exception
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC(?duration)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?duration"):::projected v5("?end") v2("?p") v3("?person"):::projected v4("?start") a1((" ")) c8(["bd:serviceParam"]):::iri c4(["wd:Q5"]):::iri c10(["en"]):::literal f0[["?p != 'p:P119'"]] f0 --> v2 f1[["?duration > '100^^xsd:integer'"]] f1 --> v6 v3 --"p:direct/P31"--> c4 a1 --"p:qualifier/P580"--> v4 a1 --"p:qualifier/P582"--> v5 v3 -->v2--> a1 bind2[/"numeric-round(?end - ?start / '365.2425^^xsd:decimal')"/] v5 --o bind2 v4 --o bind2 bind2 --as--o v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end