query-1a509cce87c5cc2703668cb181d5969a

rq turtle/ttl

added before 2016-10 #Definition for Occitania (Q104285) is the one defined by P527 on item Q104285 SELECT ?item ?yob ?yod WHERE { # items with property place of birth ?item wdt:P19 ?pob . #place of birth must be using P131 with one of the "?parts" (or -- note the "" -- a value that uses one of the parts in P131, etc.) ?pob wdt:P131 ?parts .

# ?parts are those listed on item Q104285 with property P527
wd:Q104285 wdt:P527 ?parts .

# humans only
?item wdt:P31 wd:Q5 .

#for display in the list, extract yob/yod. Could also be done by using P569 and P570 in "columns=" of Listeria's template
OPTIONAL { ?item wdt:P569 ?dob . BIND(YEAR(?dob) as ?yob) }
OPTIONAL { ?item wdt:P570 ?dod . BIND(YEAR(?dod) as ?yod) }

}

LIMIT to 2000 as Listeria can only handle up to 5000

LIMIT 2000 added before 2016-10 #Definition for Occitania (Q104285) is the one defined by P527 on item Q104285 SELECT ?item ?yob ?yod WHERE { # items with property place of birth ?item wdt:P19 ?pob . #place of birth must be using P131 with one of the "?parts" (or -- note the "" -- a value that uses one of the parts in P131, etc.) ?pob wdt:P131 ?parts .

# ?parts are those listed on item Q104285 with property P527
wd:Q104285 wdt:P527 ?parts .

# humans only
?item wdt:P31 wd:Q5 .

#for display in the list, extract yob/yod. Could also be done by using P569 and P570 in "columns=" of Listeria's template
OPTIONAL { ?item wdt:P569 ?dob . BIND(YEAR(?dob) as ?yob) }
OPTIONAL { ?item wdt:P570 ?dod . BIND(YEAR(?dod) as ?yod) }

}

LIMIT to 2000 as Listeria can only handle up to 5000

LIMIT 2000 added before 2016-10 #Definition for Occitania (Q104285) is the one defined by P527 on item Q104285 SELECT ?item ?yob ?yod WHERE { # items with property place of birth ?item wdt:P19 ?pob . #place of birth must be using P131 with one of the "?parts" (or -- note the "" -- a value that uses one of the parts in P131, etc.) ?pob wdt:P131 ?parts .

# ?parts are those listed on item Q104285 with property P527
wd:Q104285 wdt:P527 ?parts .

# humans only
?item wdt:P31 wd:Q5 .

#for display in the list, extract yob/yod. Could also be done by using P569 and P570 in "columns=" of Listeria's template
OPTIONAL { ?item wdt:P569 ?dob . BIND(YEAR(?dob) as ?yob) }
OPTIONAL { ?item wdt:P570 ?dod . BIND(YEAR(?dod) as ?yod) }

}

LIMIT to 2000 as Listeria can only handle up to 5000

LIMIT 2000 added before 2016-10 #Definition for Occitania (Q104285) is the one defined by P527 on item Q104285 SELECT ?item ?yob ?yod WHERE { # items with property place of birth ?item wdt:P19 ?pob . #place of birth must be using P131 with one of the "?parts" (or -- note the "" -- a value that uses one of the parts in P131, etc.) ?pob wdt:P131 ?parts .

# ?parts are those listed on item Q104285 with property P527
wd:Q104285 wdt:P527 ?parts .

# humans only
?item wdt:P31 wd:Q5 .

#for display in the list, extract yob/yod. Could also be done by using P569 and P570 in "columns=" of Listeria's template
OPTIONAL { ?item wdt:P569 ?dob . BIND(YEAR(?dob) as ?yob) }
OPTIONAL { ?item wdt:P570 ?dod . BIND(YEAR(?dod) as ?yod) }

}

LIMIT to 2000 as Listeria can only handle up to 5000

LIMIT 2000 added before 2016-10 #Definition for Occitania (Q104285) is the one defined by P527 on item Q104285 SELECT ?item ?yob ?yod WHERE { # items with property place of birth ?item wdt:P19 ?pob . #place of birth must be using P131 with one of the "?parts" (or -- note the "" -- a value that uses one of the parts in P131, etc.) ?pob wdt:P131 ?parts .

# ?parts are those listed on item Q104285 with property P527
wd:Q104285 wdt:P527 ?parts .

# humans only
?item wdt:P31 wd:Q5 .

#for display in the list, extract yob/yod. Could also be done by using P569 and P570 in "columns=" of Listeria's template
OPTIONAL { ?item wdt:P569 ?dob . BIND(YEAR(?dob) as ?yob) }
OPTIONAL { ?item wdt:P570 ?dod . BIND(YEAR(?dod) as ?yod) }

}

LIMIT to 2000 as Listeria can only handle up to 5000

LIMIT 2000 added before 2016-10 #Definition for Occitania (Q104285) is the one defined by P527 on item Q104285 SELECT ?item ?yob ?yod WHERE { # items with property place of birth ?item wdt:P19 ?pob . #place of birth must be using P131 with one of the "?parts" (or -- note the "" -- a value that uses one of the parts in P131, etc.) ?pob wdt:P131 ?parts .

# ?parts are those listed on item Q104285 with property P527
wd:Q104285 wdt:P527 ?parts .

# humans only
?item wdt:P31 wd:Q5 .

#for display in the list, extract yob/yod. Could also be done by using P569 and P570 in "columns=" of Listeria's template
OPTIONAL { ?item wdt:P569 ?dob . BIND(YEAR(?dob) as ?yob) }
OPTIONAL { ?item wdt:P570 ?dod . BIND(YEAR(?dod) as ?yod) }

}

LIMIT to 2000 as Listeria can only handle up to 5000

LIMIT 2000 added before 2016-10 #Definition for Occitania (Q104285) is the one defined by P527 on item Q104285 SELECT ?item ?yob ?yod WHERE { # items with property place of birth ?item wdt:P19 ?pob . #place of birth must be using P131 with one of the "?parts" (or -- note the "" -- a value that uses one of the parts in P131, etc.) ?pob wdt:P131 ?parts .

# ?parts are those listed on item Q104285 with property P527
wd:Q104285 wdt:P527 ?parts .

# humans only
?item wdt:P31 wd:Q5 .

#for display in the list, extract yob/yod. Could also be done by using P569 and P570 in "columns=" of Listeria's template
OPTIONAL { ?item wdt:P569 ?dob . BIND(YEAR(?dob) as ?yob) }
OPTIONAL { ?item wdt:P570 ?dod . BIND(YEAR(?dod) as ?yod) }

}

LIMIT to 2000 as Listeria can only handle up to 5000

LIMIT 2000 added before 2016-10 #Definition for Occitania (Q104285) is the one defined by P527 on item Q104285 SELECT ?item ?yob ?yod WHERE { # items with property place of birth ?item wdt:P19 ?pob . #place of birth must be using P131 with one of the "?parts" (or -- note the "" -- a value that uses one of the parts in P131, etc.) ?pob wdt:P131 ?parts .

# ?parts are those listed on item Q104285 with property P527
wd:Q104285 wdt:P527 ?parts .

# humans only
?item wdt:P31 wd:Q5 .

#for display in the list, extract yob/yod. Could also be done by using P569 and P570 in "columns=" of Listeria's template
OPTIONAL { ?item wdt:P569 ?dob . BIND(YEAR(?dob) as ?yob) }
OPTIONAL { ?item wdt:P570 ?dod . BIND(YEAR(?dod) as ?yod) }

}

LIMIT to 2000 as Listeria can only handle up to 5000

LIMIT 2000 added before 2016-10 #Definition for Occitania (Q104285) is the one defined by P527 on item Q104285 SELECT ?item ?yob ?yod WHERE { # items with property place of birth ?item wdt:P19 ?pob . #place of birth must be using P131 with one of the "?parts" (or -- note the "" -- a value that uses one of the parts in P131, etc.) ?pob wdt:P131 ?parts .

# ?parts are those listed on item Q104285 with property P527
wd:Q104285 wdt:P527 ?parts .

# humans only
?item wdt:P31 wd:Q5 .

#for display in the list, extract yob/yod. Could also be done by using P569 and P570 in "columns=" of Listeria's template
OPTIONAL { ?item wdt:P569 ?dob . BIND(YEAR(?dob) as ?yob) }
OPTIONAL { ?item wdt:P570 ?dod . BIND(YEAR(?dod) as ?yod) }

}

LIMIT to 2000 as Listeria can only handle up to 5000

LIMIT 2000 added before 2016-10 #Definition for Occitania (Q104285) is the one defined by P527 on item Q104285 SELECT ?item ?yob ?yod WHERE { # items with property place of birth ?item wdt:P19 ?pob . #place of birth must be using P131 with one of the "?parts" (or -- note the "" -- a value that uses one of the parts in P131, etc.) ?pob wdt:P131 ?parts .

# ?parts are those listed on item Q104285 with property P527
wd:Q104285 wdt:P527 ?parts .

# humans only
?item wdt:P31 wd:Q5 .

#for display in the list, extract yob/yod. Could also be done by using P569 and P570 in "columns=" of Listeria's template
OPTIONAL { ?item wdt:P569 ?dob . BIND(YEAR(?dob) as ?yob) }
OPTIONAL { ?item wdt:P570 ?dod . BIND(YEAR(?dod) as ?yod) }

}

LIMIT to 2000 as Listeria can only handle up to 5000

LIMIT 2000

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#added before 2016-10
 #Definition for Occitania (Q104285) is the one defined by P527 on item Q104285
SELECT ?item ?yob ?yod
WHERE
{
    # items with property place of birth
    ?item wdt:P19 ?pob .
    #place of birth must be using P131 with one of the "?parts" (or -- note the "*" -- a value that uses one of the parts in P131, etc.)
    ?pob wdt:P131* ?parts .

    # ?parts are those listed on item Q104285 with property P527
    wd:Q104285 wdt:P527 ?parts . 

    # humans only
    ?item wdt:P31 wd:Q5 .

    #for display in the list, extract yob/yod. Could also be done by using P569 and P570 in "columns=" of Listeria's template
    OPTIONAL { ?item wdt:P569 ?dob . BIND(YEAR(?dob) as ?yob) }
    OPTIONAL { ?item wdt:P570 ?dod . BIND(YEAR(?dod) as ?yod) }
}
#LIMIT to 2000 as Listeria can only handle up to 5000
LIMIT 2000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?dob") v6("?dod") v1("?item"):::projected v3("?parts") v2("?pob") v5("?yob"):::projected v7("?yod"):::projected c6(["wd:Q5"]):::iri c3(["wd:Q104285"]):::iri v1 --"wdt:P19"--> v2 v2 --"wdt:P131"--> v3 c3 --"wdt:P527"--> v3 v1 --"wdt:P31"--> c6 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P569".-> v4 bind0[/"year-from-dateTime(?dob)"/] v4 --o bind0 bind0 --as--o v5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P570".-> v6 bind1[/"year-from-dateTime(?dod)"/] v6 --o bind1 bind1 --as--o v7 end