Wer Leitet? - User contributions [en]

SPARQL examples

2024-08-05T14:12:08Z

Admin:

==Persons==

===Persons ordered by city with additional information if available===
{{SPARQL|query=
SELECT ?city ?person ?personLabel ?birthDate ?birthPlace ?occupation ?mainInfo WHERE {
?person rdfs:label ?personLabel;
wdt:P3 wd:Q2;
OPTIONAL {?person wdt:P381 ?city.}
OPTIONAL {?person wdt:P626 ?birthDate.}
OPTIONAL {?person wdt:P349 ?birthPlace.}
OPTIONAL {?person wdt:P999 ?occupation.}
OPTIONAL {?person wdt:P253 ?mainInfo.}
FILTER((LANG(?personLabel)) = "de")
} ORDER BY ?city
}}

===Persons in advisory boards in a time range===

{{SPARQL|query=
SELECT DISTINCT ?person ?personLabel ?beirat WHERE {
?person rdfs:label ?personLabel;
wdt:P3 wd:Q2;
wdt:P463 ?surname;
p:P1012 [ps:P1012 ?beirat;
pq:P4 ?pubDate].
FILTER((LANG(?personLabel)) = "de")
FILTER("1940-01-01"^^xsd:dateTime <= ?pubDate && ?pubDate < "1941-01-01"^^xsd:dateTime).
} ORDER BY ?surname
}}

===Count of occupations===

{{SPARQL|query=
SELECT DISTINCT (COUNT (?person) as ?noPeople) ?occupation WHERE {
?person wdt:P3 wd:Q2;
wdt:P999 ?occupation.
}
GROUP BY ?occupation HAVING (?noPeople > 1)
ORDER BY DESC(?noPeople)
}}

Template:SPARQL

2024-08-05T12:54:52Z

Admin:

<noinclude>Template to show syntax-highlighted SPARQL query and a few links at the bottom</noinclude>{{#tag:syntaxhighlight|{{{query}}}|highlight="{{{highlight|}}}"|start="{{{start|1}}}"|{{{line|line}}}=line|lang="sparql"|style="margin:.5em; max-width: -moz-max-content;
min-width: 20em;"}}
<div class="displayonly">[https://query.wl.kgi.uni-mannheim.de/#{{urlencode: {{{query}}} | PATH }} Try it!]</div>

SPARQL examples

2024-08-05T12:51:52Z

Admin:

==Persons==

===Persons in advisory boards in a time range===

{{SPARQL|query=
SELECT DISTINCT ?person ?personLabel ?beirat WHERE {
?person rdfs:label ?personLabel;
wdt:P3 wd:Q2;
wdt:P463 ?surname;
p:P1012 [ps:P1012 ?beirat;
pq:P4 ?pubDate].
FILTER((LANG(?personLabel)) = "de")
FILTER("1940-01-01"^^xsd:dateTime <= ?pubDate && ?pubDate < "1941-01-01"^^xsd:dateTime).
} ORDER BY ?surname
}}

===Count of occupations===

{{SPARQL|query=
SELECT DISTINCT (COUNT (?person) as ?noPeople) ?occupation WHERE {
?person wdt:P3 wd:Q2;
wdt:P999 ?occupation.
}
GROUP BY ?occupation HAVING (?noPeople > 1)
ORDER BY DESC(?noPeople)
}}

SPARQL examples

2024-08-05T12:49:00Z

Admin: Created page with "==Persons== ===Persons in advisory boards in a time range=== {{SPARQL|query= SELECT DISTINCT ?person ?personLabel ?beirat WHERE { ?person rdfs:label ?personLabel; wdt:P3 wd:Q2; wdt:P463 ?surname; p:P1012 [ps:P1012 ?beirat; pq:P4 ?pubDate]. FILTER((LANG(?personLabel)) = "de") FILTER("1940-01-01"^^xsd:dateTime <= ?pubDate && ?pubDate < "1941-01-01"^^xsd:dateTime). } ORDER BY ?surname }}"

Template:SPARQL

2024-08-05T12:47:27Z

Admin: Created page with "<noinclude>Template to show syntax-highlighted SPARQL query and a few links at the bottom</noinclude>{{#tag:syntaxhighlight|{{{query}}}|highlight="{{{highlight|}}}"|start="{{{start|1}}}"|{{{line|line}}}=line|lang="sparql"|style="margin:.5em; max-width: -moz-max-content; min-width: 20em;"}} <div class="displayonly">[https://query.akf.kgi.uni-mannheim.de/#{{urlencode: {{{query}}} | PATH }} Try it!]</div>"

<noinclude>Template to show syntax-highlighted SPARQL query and a few links at the bottom</noinclude>{{#tag:syntaxhighlight|{{{query}}}|highlight="{{{highlight|}}}"|start="{{{start|1}}}"|{{{line|line}}}=line|lang="sparql"|style="margin:.5em; max-width: -moz-max-content;
min-width: 20em;"}}
<div class="displayonly">[https://query.akf.kgi.uni-mannheim.de/#{{urlencode: {{{query}}} | PATH }} Try it!]</div>

Item:Q10

2024-02-01T10:59:32Z

Admin: /* wbsetclaim-update:2||1 */ Property:P381: Brettorf/Oldenburg

Item:Q10

2024-02-01T10:58:38Z

Admin: /* wbsetclaim-update:2||1|2 */ Property:P381: Brettorf/Oldenburg

Item:Q10

2024-02-01T10:58:14Z

Admin: /* wbsetclaim-update:2||1|1 */ Property:P381: Brettorf/Oldenburg

Item:Q10

2024-02-01T10:57:12Z

Admin: /* wbsetclaim-update:2||1|1 */ Property:P381: Brettorf/Oldenburg

Item:Q10

2024-02-01T10:42:43Z

Admin: /* wbsetclaim-update:2||1|1 */ Property:P381: Brettorf/Oldenburg

Item:Q1622

2023-11-24T13:00:41Z

Admin: /* wbsetclaim-update:2||1 */ Property:P381: Nürnberg-A.

Item:Q1622

2023-11-24T13:00:34Z

Admin: /* wbsetclaim-update:2||1 */ Property:P381: Nürnberg-A.

Item:Q1622

2023-11-24T13:00:12Z

Admin: /* wbsetclaim-update:2||1 */ Property:P349: Altdorf, Ob. Amt Böblingen/Wttb.

Item:Q1622

2023-11-24T13:00:03Z

Admin: /* wbsetclaim-update:2||1 */ Property:P349: Altdorf, Ob. Amt Böblingen/ Wttb.

Item:Q1622

2023-11-24T12:59:31Z

Admin: /* wbsetclaim-create:2||1 */ Property:P206: Mauthalle

Item:Q1614

2023-11-24T12:58:52Z

Admin: /* wbsetclaim-create:2||1 */ Property:P349: Wien

Item:Q1614

2023-11-24T12:58:23Z

Admin: /* wbsetclaim-update:2||1 */ Property:P381: Leoben-Leitendorf/Steiermark

Item:Q1614

2023-11-24T12:58:13Z

Admin: /* wbsetclaim-update:2||1 */ Property:P808: Dipl.-Ing., Dr. jur.

Item:Q1599

2023-11-24T12:57:37Z

Admin: /* wbsetclaim-update:2||1 */ Property:P999: oProfessor für wirtschaftliche Staatswissenschaften an der Universität Köln

Item:Q1599

2023-11-24T12:57:30Z

Admin: /* wbsetclaim-update:2||1 */ Property:P808: Professor, Dr.

Item:Q1580

2023-11-24T12:56:23Z

Admin: /* wbsetclaim-update:2||1 */ Property:P349: St. Andreasberg

Item:Q1580

2023-11-24T12:56:19Z

Admin: /* wbsetclaim-update:2||1 */ Property:P349: St. Andreasberg

Item:Q1573

2023-11-24T12:55:39Z

Admin: /* wbsetclaim-update:2||1 */ Property:P381: Heidelberg

Item:Q1573

2023-11-24T12:55:25Z

Admin: /* wbsetclaim-update:2||1 */ Property:P206: Richard-Wagner-Straße 9

Item:Q1547

2023-11-24T12:54:53Z

Admin: /* wbsetclaim-create:2||1 */ Property:P349: Birnbaum

Item:Q1547

2023-11-24T12:54:20Z

Admin: /* wbsetclaim-create:2||1 */ Property:P381: Meseritz

Item:Q1547

2023-11-24T12:54:10Z

Admin: /* wbsetclaim-create:2||1 */ Property:P381: Meseritz

Item:Q1547

2023-11-24T12:53:40Z

Admin: /* wbremoveclaims-remove:1| */ Property:P999: Meseritz

Item:Q1547

2023-11-24T12:53:38Z

Admin: /* wbremoveclaims-remove:1| */ Property:P999: Meseritz

Item:Q1547

2023-11-24T12:53:13Z

Admin: /* wbsetclaim-update:2||1 */ Property:P206: Wilhelmstraße 1

Item:Q1522

2023-11-24T12:52:09Z

Admin: /* wbsetclaim-update:2||1 */ Property:P381: Berlin NW 40

Item:Q1522

2023-11-24T12:51:53Z

Admin: /* wbsetclaim-create:2||1 */ Property:P206: Helgoländer Ufer 6

Item:Q1506

2023-11-24T12:50:31Z

Admin: /* wbsetclaim-update:2||1 */ Property:P349: Stargard/Pommern

Item:Q1406

2023-11-24T11:11:43Z

Admin: /* wbsetclaim-update:2||1 */ Property:P999: Landwirt

Item:Q1405

2023-11-24T11:11:21Z

Admin: /* wbsetclaim-update:2||1 */ Property:P999: Direktor

Item:Q1406

2023-11-24T10:59:28Z

Admin: /* wbsetclaim-update:2||1 */ Property:P381: Gohren, Krs. Stolp/Pommern

Item:Q1400

2023-11-24T10:57:44Z

Admin: /* wbsetclaim-update:2||1 */ Property:P999: Direktor bei der Reichsbank, Zweiter Vorstandsbeamter der Reichsbankhauptstelle Königsberg/Preußen

Item:Q1400

2023-11-24T10:57:11Z

Admin: /* wbsetclaim-update:2||1 */ Property:P381: Königsberg/Preußen

Item:Q1400

2023-11-24T10:56:43Z

Admin: /* wbsetclaim-update:2||1 */ Property:P349: Neuruppin

Item:Q1400

2023-11-24T10:56:16Z

Admin: /* wbsetclaim-create:2||1 */ Property:P206: Schloßplatz 2/3

Item:Q1330

2023-11-23T14:57:01Z

Admin: /* wbsetclaim-update:2||1 */ Property:P381: Ahstedt Krs. Marienburg

Item:Q1330

2023-11-23T14:56:35Z

Admin: /* wbsetclaim-update:2||1 */ Property:P381: Ahstedt Krs. Marienburg

Item:Q1320

2023-11-23T14:55:11Z

Admin: /* wbsetclaim-update:2||1 */ Property:P999: Ingenieur

Item:Q1320

2023-11-23T14:55:07Z

Admin: /* wbsetclaim-update:2||1 */ Property:P999: Ingenieur

Item:Q1320

2023-11-23T14:54:48Z

Admin: /* wbsetclaim-update:2||1 */ Property:P349: Löningen in Oldenburg

Item:Q1320

2023-11-23T14:54:44Z

Admin: /* wbsetclaim-update:2||1 */ Property:P349: Löningen in Oldenburg

Item:Q1302

2023-11-23T14:54:05Z

Admin: /* wbsetclaim-create:2||1 */ Property:P206: Adolf-Hitler-Ring 41

Item:Q1302

2023-11-23T14:53:25Z

Admin: /* wbsetclaim-update:2||1 */ Property:P381: Eilenburg

Item:Q1243

2023-11-23T14:52:12Z

Admin: /* wbsetclaim-create:2||1 */ Property:P626: 8.0.1888

Item:Q1243

2023-11-23T14:51:50Z

Admin: /* wbsetclaim-update:2||1 */ Property:P596: 8.0.1888