#defaultView:MapSELECTDISTINCT?p?pLabel?affiliationType?affiliationTypeLabel?w?wLabel?geoLoc?geoHead# ?p:consortium, ?w:institutionWHERE{?pwdt:P31wd:Q98270496;p:P1416?statement.?statementps:P1416?w.# type of affiliationOPTIONAL{?statementpq:P3831?affiliationType}# location of institutionOPTIONAL{?wwdt:P625?geoLoc}# location of headquarters of institutionOPTIONAL{?wwdt:P159/wdt:P625?geoHead}# coalesce locations of institution and headquartersBIND(COALESCE(?geoLoc,?geoHead)AS?geoLoc)SERVICEwikibase:label{bd:serviceParamwikibase:language"en,[AUTO_LANGUAGE]"}}ORDER BYASC(?pLabel)ASC(?affiliationTypeLabel)ASC(?wLabel)
#defaultView:MapSELECTDISTINCT?p?pLabel?affiliationType?affiliationTypeLabel?w?wLabel?geoLoc?geoHead# ?p:NFDI4Ing, ?w:institutionWHERE{wd:Q98380344p:P1416?statement.?pp:P1416?statement.?statementps:P1416?w.# type of affiliationOPTIONAL{?statementpq:P3831?affiliationType}# location of institutionOPTIONAL{?wwdt:P625?geoLoc}# location of headquarters of institutionOPTIONAL{?wwdt:P159/wdt:P625?geoHead}# coalesce locations of institution and headquartersBIND(COALESCE(?geoLoc,?geoHead)AS?geoLoc)SERVICEwikibase:label{bd:serviceParamwikibase:language"en,[AUTO_LANGUAGE]"}}ORDER BYASC(?pLabel)ASC(?affiliationTypeLabel)ASC(?wLabel)
#defaultView:MapSELECTDISTINCT?p?pLabel?affiliationType?affiliationTypeLabel?w?wLabel?geoLoc?geoHead# ?p:consortium, ?w:institutionWHERE{?pwdt:P31wd:Q98270496;p:P1416?statement.?statementps:P1416?w.# check out NRW only map reading four layers# ?w (wdt:P131|wdt:P131/wdt:P131|wdt:P131/wdt:P131/wdt:P131|wdt:P131/wdt:P131/wdt:P131/wdt:P131) wd:Q1198# check out NRW only map reading three layers?w(wdt:P131|wdt:P131/wdt:P131|wdt:P131/wdt:P131/wdt:P131)wd:Q1198# check out NRW only map reading two layers (spoiler: Münster is still missing!)# ?w (wdt:P131|wdt:P131/wdt:P131) wd:Q1198 # check out NRW only map reading one layer (spoiler: Münster is missing!)#?w wdt:P131 wd:Q1198# type of affiliationOPTIONAL{?statementpq:P3831?affiliationType}# location of institutionOPTIONAL{?wwdt:P625?geoLoc}# location of headquarters of institutionOPTIONAL{?w(wdt:P159/wdt:P625)?geoHead}# coalesce locations of institution and headquartersBIND(COALESCE(?geoLoc,?geoHead)AS?geoLoc)SERVICEwikibase:label{bd:serviceParamwikibase:language"en,[AUTO_LANGUAGE]"}}ORDER BY(?pLabel)(?affiliationTypeLabel)(?wLabel)
#defaultView:GraphSELECT?consortium?consortiumLabel("EC0000"AS?rgb)?institution?institutionLabel# ("EC0000" AS ?rgb): consortium labels are shown in red WHERE{?consortiumwdt:P361wd:Q61658497.?consortiumwdt:P31wd:Q98270496.OPTIONAL{?consortiumwdt:P1416?institution.}SERVICEwikibase:label{bd:serviceParamwikibase:language"en,[AUTO_LANGUAGE]".}}ORDER BY(?consortiumLabel)(?institutionLabel)
#defaultView:GraphSELECT?consortium?consortiumLabel("EC0000"AS?rgb)?w?wLabel# ("EC0000" AS ?rgb):consortium label shown in red, ?w:institutionWHERE{wd:Q98380344p:P1416?statement.?consortiump:P1416?statement.?statementps:P1416?w.SERVICEwikibase:label{bd:serviceParamwikibase:language"en,[AUTO_LANGUAGE]".}}ORDER BY(?wLabel)
#defaultView:TableSELECTDISTINCT?p?pLabel?affiliationType?affiliationTypeLabel?w?wLabel?geoLoc?geoHead# ?p:consortium, ?w:institutionWHERE{?pwdt:P31wd:Q98270496;p:P1416?statement.?statementps:P1416?w.# type of affiliationOPTIONAL{?statementpq:P3831?affiliationType}# location of institutionOPTIONAL{?wwdt:P625?geoLoc}# location of headquarters of institutionOPTIONAL{?w(wdt:P159/wdt:P625)?geoHead}FILTERNOT EXISTS{?wwdt:P625?geoLoc}FILTERNOT EXISTS{?w(wdt:P159/wdt:P625)?geoHead}SERVICEwikibase:label{bd:serviceParamwikibase:language"en,[AUTO_LANGUAGE]"}}ORDER BY(?pLabel)(?affiliationTypeLabel)(?wLabel)
NFDI institutions (and persons) that are linked as people[edit]
#defaultView:TableSELECTDISTINCT?p?pLabel?role?roleLabel?w?wLabel# ?p:consortium, ?w:person or institutionWHERE{?pwdt:P31wd:Q98270496;p:P710?statement.?statementps:P710?w.# type of roleOPTIONAL{?statementpq:P2868?role}SERVICEwikibase:label{bd:serviceParamwikibase:language"en,[AUTO_LANGUAGE]"}}ORDER BY(?roleLabel)(?pLabel)(?wLabel)# listing first institutions, then persons
#defaultView:TableSELECTDISTINCT?p?pLabel?role?roleLabel?w?wLabel?ORCID# ?p:consortium, ?w:personWHERE{?pwdt:P31wd:Q98270496;p:P710?statement.?statementps:P710?w.# type of roleOPTIONAL{?statementpq:P2868?role}# ORCIDOPTIONAL{?wwdt:P496?ORCID}FILTEREXISTS{?statementpq:P2868?role}FILTERNOT EXISTS{?wwdt:P496?ORCID}SERVICEwikibase:label{bd:serviceParamwikibase:language"en,[AUTO_LANGUAGE]"}}ORDER BY(?pLabel)(?roleLabel)(?wLabel)