query-74e4432feb7307d87dcb510d4b59141a
Member Organisations Show all members of the NFDI association - with additional data about them!
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
{
?w wdt:P463 wd:Q105757481 .
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
- https://www.wikidata.org/wiki/User:Wiljes/NFDI
- https://www.wikidata.org/wiki/Wikidata:WikiProject_NFDI/SPARQL-queries
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v18("?beschaeftigte"):::projected
v6("?budget")
v17("?bundesland")
v14("?email"):::projected
v18("?facebook"):::projected
v18("?gruendung"):::projected
v15("?leitung")
v18("?leitungname"):::projected
v3("?lobbyregister"):::projected
v13("?rechtsform")
v7("?rorid"):::projected
v10("?telefon"):::projected
v18("?twitter"):::projected
v2("?w"):::projected
v1("?wLabel"):::projected
v18("?website"):::projected
v8("?zenodoid")
a1((" "))
c2(["wd:Q105757481"]):::iri
c22(["bd:serviceParam"]):::iri
c20(["wd:Q1221156"]):::iri
c24(["#91;AUTO_LANGUAGE#93;,en,de"]):::literal
v2 --"wdt:P463"--> c2
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P10301".-> v3
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P856".-> v18
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P2002".-> v18
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P2769".-> v6
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P6782".-> v7
end
subgraph optional5["(optional)"]
style optional5 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P9934".-> v8
end
subgraph optional6["(optional)"]
style optional6 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P2013".-> v18
end
subgraph optional7["(optional)"]
style optional7 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P1329".-> v10
end
subgraph optional8["(optional)"]
style optional8 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P571".-> v18
end
subgraph optional9["(optional)"]
style optional9 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P1128".-> v18
end
subgraph optional10["(optional)"]
style optional10 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P1454".-> v13
end
subgraph optional11["(optional)"]
style optional11 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P968".-> v14
end
subgraph optional12["(optional)"]
style optional12 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P11647".-> a1
a1 --"wdt:P1037"--> v15
v15 --"rdfs:label"--> v18
end
subgraph optional13["(optional)"]
style optional13 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P131".-> v17
v17 --"wdt:P31"--> c20
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c22 --"wikibase:language"--> c24
end
bind6[/"sample(?leitungname)"/]
v18 --o bind6
bind6 --as--o v18
bind7[/"sample(?website)"/]
v18 --o bind7
bind7 --as--o v18
bind8[/"sample(?twitter)"/]
v18 --o bind8
bind8 --as--o v18
bind9[/"sample(?facebook)"/]
v18 --o bind9
bind9 --as--o v18
bind10[/"sample(?beschaeftigte)"/]
v18 --o bind10
bind10 --as--o v18
bind11[/"sample(?gruendung)"/]
v18 --o bind11
bind11 --as--o v18