query-b6d069d52355320ad1de521ad973621c

rq turtle/ttl

added before 2016-10 SELECT ?item ?dob WHERE { # place of birth = Scotland (Q22) { ?item wdt:P19 wd:Q22 } # OR place of birth within Scotland. UNION { ?item wdt:P19 ?pob . ?pob wdt:P131* wd:Q22 }

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

# get DOB for ordering.
OPTIONAL { ?item wdt:P569 ?dob  }

}

Order by date of birth, avoid overriding this in the template with sort=

ORDER BY ?dob

Listeria can only handle up to 5000

LIMIT 4000

start at the first item

OFFSET 0 #change to OFFSET 4000 to start at the 4001th item added before 2016-10 SELECT ?item ?dob WHERE { # place of birth = Scotland (Q22) { ?item wdt:P19 wd:Q22 } # OR place of birth within Scotland. UNION { ?item wdt:P19 ?pob . ?pob wdt:P131* wd:Q22 }

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

# get DOB for ordering.
OPTIONAL { ?item wdt:P569 ?dob  }

}

Order by date of birth, avoid overriding this in the template with sort=

ORDER BY ?dob

Listeria can only handle up to 5000

LIMIT 4000

start at the first item

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

# get DOB for ordering.
OPTIONAL { ?item wdt:P569 ?dob  }

}

Order by date of birth, avoid overriding this in the template with sort=

ORDER BY ?dob

Listeria can only handle up to 5000

LIMIT 4000

start at the first item

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

# get DOB for ordering.
OPTIONAL { ?item wdt:P569 ?dob  }

}

Order by date of birth, avoid overriding this in the template with sort=

ORDER BY ?dob

Listeria can only handle up to 5000

LIMIT 4000

start at the first item

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

# get DOB for ordering.
OPTIONAL { ?item wdt:P569 ?dob  }

}

Order by date of birth, avoid overriding this in the template with sort=

ORDER BY ?dob

Listeria can only handle up to 5000

LIMIT 4000

start at the first item

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

# get DOB for ordering.
OPTIONAL { ?item wdt:P569 ?dob  }

}

Order by date of birth, avoid overriding this in the template with sort=

ORDER BY ?dob

Listeria can only handle up to 5000

LIMIT 4000

start at the first item

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

# get DOB for ordering.
OPTIONAL { ?item wdt:P569 ?dob  }

}

Order by date of birth, avoid overriding this in the template with sort=

ORDER BY ?dob

Listeria can only handle up to 5000

LIMIT 4000

start at the first item

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

# get DOB for ordering.
OPTIONAL { ?item wdt:P569 ?dob  }

}

Order by date of birth, avoid overriding this in the template with sort=

ORDER BY ?dob

Listeria can only handle up to 5000

LIMIT 4000

start at the first item

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

# get DOB for ordering.
OPTIONAL { ?item wdt:P569 ?dob  }

}

Order by date of birth, avoid overriding this in the template with sort=

ORDER BY ?dob

Listeria can only handle up to 5000

LIMIT 4000

start at the first item

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

# get DOB for ordering.
OPTIONAL { ?item wdt:P569 ?dob  }

}

Order by date of birth, avoid overriding this in the template with sort=

ORDER BY ?dob

Listeria can only handle up to 5000

LIMIT 4000

start at the first item

OFFSET 0 #change to OFFSET 4000 to start at the 4001th item

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#added before 2016-10
SELECT ?item ?dob
WHERE
{
    # place of birth = Scotland (Q22)
    { ?item wdt:P19 wd:Q22 }
    # OR place of birth within Scotland.
    UNION  { ?item wdt:P19 ?pob . ?pob wdt:P131* wd:Q22 }

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

    # get DOB for ordering.
    OPTIONAL { ?item wdt:P569 ?dob  }
}
#Order by date of birth, avoid overriding this in the template with sort=
ORDER BY ?dob
#Listeria can only handle up to 5000
LIMIT 4000
#start at the first item
OFFSET 0 #change to OFFSET 4000 to start at the 4001th item

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?dob"):::projected v2("?item"):::projected v3("?pob") c5(["wd:Q5"]):::iri c2(["wd:Q22"]):::iri subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P19"--> v3 v3 --"wdt:P131"--> c2 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P19"--> c2 end union0r <== or ==> union0l end v2 --"wdt:P31"--> c5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P569".-> v1 end