query-98a6f98d0c1116bfb6df7f410d56dd28
(Co-)Applicans and Participants of Consortia
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
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 bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?w ?wLabel ?bundeslandLabel ?rechtsformLabel (SAMPLE(?leitungname) AS ?leitungname) (SAMPLE(?website) AS ?website) ?email ?telefon (SAMPLE(?twitter) AS ?twitter) (SAMPLE(?facebook) AS ?facebook) ?rorid ?lobbyregister (SAMPLE(?beschaeftigte) AS ?beschaeftigte) (SAMPLE(?gruendung) AS ?gruendung)
WHERE
{
?p wdt:P31 wd:Q98270496 .
?p wdt:P1416 ?w .
OPTIONAL {?w wdt:P10301 ?lobbyregister }
OPTIONAL {?w wdt:P856 ?website .}
OPTIONAL {?w wdt:P2002 ?twitter .}
OPTIONAL {?w wdt:P2769 ?budget .}
OPTIONAL {?w wdt:P6782 ?rorid .}
OPTIONAL {?w wdt:P9934 ?zenodoid }
OPTIONAL {?w wdt:P2013 ?facebook }
OPTIONAL {?w wdt:P1329 ?telefon }
OPTIONAL {?w wdt:P571 ?gruendung }
OPTIONAL {?w wdt:P1128 ?beschaeftigte }
OPTIONAL {?w wdt:P1454 ?rechtsform}
OPTIONAL {?w wdt:P968 ?email}
OPTIONAL {?w wdt:P11647*/wdt:P1037 ?leitung . ?leitung rdfs:label ?leitungname .}
OPTIONAL {
?w wdt:P131+ ?bundesland .
?bundesland wdt:P31 wd:Q1221156 .
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de" . }
} GROUP BY ?w ?wLabel ?wAltLabel ?wDescription ?bundeslandLabel ?rechtsformLabel ?telefon ?rorid ?lobbyregister ?email
ORDER BY ASC(?wLabel)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v19("?beschaeftigte"):::projected
v7("?budget")
v18("?bundesland")
v15("?email"):::projected
v19("?facebook"):::projected
v19("?gruendung"):::projected
v16("?leitung")
v19("?leitungname"):::projected
v4("?lobbyregister"):::projected
v2("?p")
v14("?rechtsform")
v8("?rorid"):::projected
v11("?telefon"):::projected
v19("?twitter"):::projected
v3("?w"):::projected
v1("?wLabel"):::projected
v19("?website"):::projected
v9("?zenodoid")
a1((" "))
c22(["bd:serviceParam"]):::iri
c20(["wd:Q1221156"]):::iri
c24(["#91;AUTO_LANGUAGE#93;,en,de"]):::literal
c2(["wd:Q98270496"]):::iri
v2 --"wdt:P31"--> c2
v2 --"wdt:P1416"--> v3
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P10301".-> v4
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P856".-> v19
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P2002".-> v19
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P2769".-> v7
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P6782".-> v8
end
subgraph optional5["(optional)"]
style optional5 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P9934".-> v9
end
subgraph optional6["(optional)"]
style optional6 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P2013".-> v19
end
subgraph optional7["(optional)"]
style optional7 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P1329".-> v11
end
subgraph optional8["(optional)"]
style optional8 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P571".-> v19
end
subgraph optional9["(optional)"]
style optional9 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P1128".-> v19
end
subgraph optional10["(optional)"]
style optional10 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P1454".-> v14
end
subgraph optional11["(optional)"]
style optional11 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P968".-> v15
end
subgraph optional12["(optional)"]
style optional12 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P11647".-> a1
a1 --"wdt:P1037"--> v16
v16 --"rdfs:label"--> v19
end
subgraph optional13["(optional)"]
style optional13 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P131".-> v18
v18 --"wdt:P31"--> c20
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c22 --"wikibase:language"--> c24
end
bind6[/"sample(?leitungname)"/]
v19 --o bind6
bind6 --as--o v19
bind7[/"sample(?website)"/]
v19 --o bind7
bind7 --as--o v19
bind8[/"sample(?twitter)"/]
v19 --o bind8
bind8 --as--o v19
bind9[/"sample(?facebook)"/]
v19 --o bind9
bind9 --as--o v19
bind10[/"sample(?beschaeftigte)"/]
v19 --o bind10
bind10 --as--o v19
bind11[/"sample(?gruendung)"/]
v19 --o bind11
bind11 --as--o v19