query-dcfc97ae12a1de091ab61a4eb3602f2a
by CamelCaseNick select ?stolperstein ?name ?person with { select distinct ?stolperstein ?name ?yr_of_birth { ?stolperstein wdt:P31 wd:Q26703203; wdt:P131+ wd:Q1055; wdt:P1684 ?inscription. minus { ?stolperstein wdt:P547/wdt:P31 wd:Q5. } optional { ?stolperstein p:P547 ?c. ?c pq:P1932 ?statedAs. optional { ?c rdfs:label ?cLabel. filter(lang(?label) = "de") } } optional { ?stolperstein rdfs:label ?label. filter(lang(?label) = "de") } bind(replace(coalesce(?statedAs, ?cLabel, replace(?label, "^Stolperstein für (?!den|die|das)", "")), "^(Dr|Prof)\. ?|geb\. .$|‚.+‘ ", "") as ?name) bind("(?:[^a]|a)(?: |/)(?:Jg|Jahrg|geboren|NATO|născută?|nascut|nat|ur|geb|nar|rođena|s|lětnik|n[ée]e?|dz|fødselsår|født|născuta|née? (?:le|en))(?:\.|,|\:)? ?(?:\d{1,2}\./)?(\d{4})(?:[^a]|a)*" as ?regex) filter(regex(?inscription, ?regex, "i")) bind(xsd:integer(replace(?inscription, ?regex, "$1", "i")) as ?yr_of_birth) } } as %stolpersteine with { select distinct ?person (strlang(concat("", ?n), "de") as ?name) (year(?date_of_birth) as ?yr_of_birth) { ?person wdt:P31 wd:Q5. { ?person wdt:P31|wdt:P2868 ?c. values ?c { wd:Q5883980 wd:Q2026714 wd:Q12409870 } } union { ?person wdt:P4130|wdt:P7624|wdt:P7571|wdt:P8821
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
#by CamelCaseNick
select ?stolperstein ?name ?person
with {
select distinct ?stolperstein ?name ?yr_of_birth {
?stolperstein wdt:P31 wd:Q26703203; wdt:P131+ wd:Q1055; wdt:P1684 ?inscription.
minus { ?stolperstein wdt:P547/wdt:P31 wd:Q5. }
optional { ?stolperstein p:P547 ?c. ?c pq:P1932 ?statedAs. optional { ?c rdfs:label ?cLabel. filter(lang(?label) = "de") } }
optional { ?stolperstein rdfs:label ?label. filter(lang(?label) = "de") }
bind(replace(coalesce(?statedAs, ?cLabel, replace(?label, "^Stolperstein für (?!den|die|das)", "")), "^(Dr|Prof)\\. ?|geb\\. .*$|‚.+‘ ", "") as ?name)
bind("(?:[^a]|a)*(?: |/)(?:Jg|Jahrg|geboren|NATO|născută?|nascut|nat|ur|geb|nar|rođena|s|lětnik|n[ée]e?|dz|fødselsår|født|născuta|née? (?:le|en))(?:\\.|,|\\:)? ?(?:\\d{1,2}[\\./](?:\\d{1,2}[\\./]| \\p{L}+\\.? ))?(\\d{4})(?:[^a]|a)*" as ?regex)
filter(regex(?inscription, ?regex, "i"))
bind(xsd:integer(replace(?inscription, ?regex, "$1", "i")) as ?yr_of_birth)
}
} as %stolpersteine
with {
select distinct ?person (strlang(concat("", ?n), "de") as ?name) (year(?date_of_birth) as ?yr_of_birth) {
?person wdt:P31 wd:Q5.
{ ?person wdt:P31|wdt:P2868 ?c. values ?c { wd:Q5883980 wd:Q2026714 wd:Q12409870 } } union { ?person wdt:P4130|wdt:P7624|wdt:P7571|wdt:P8821