Difference between revisions of "Q0.6"
Jump to navigation
Jump to search
| (5 intermediate revisions by 2 users not shown) | |||
| Line 3: | Line 3: | ||
{{Query | {{Query | ||
|id=6 | |id=6 | ||
| + | |name=AllInstitutions | ||
|title=All [[Concept:Institution| institutions]] | |title=All [[Concept:Institution| institutions]] | ||
| − | |description=List all | + | |description=List all institutions from which at least one scholar has once (co-)authored a paper or proceeding that has been published through CEUR-WS. |
|sparql=# Q0.6 List all institutions | |sparql=# Q0.6 List all institutions | ||
SELECT DISTINCT ?institution ?institutionLabel | SELECT DISTINCT ?institution ?institutionLabel | ||
| Line 27: | Line 28: | ||
OPTIONAL{?institution rdfs:label ?institutionLabel. Filter(lang(?institutionLabel)="en")} | OPTIONAL{?institution rdfs:label ?institutionLabel. Filter(lang(?institutionLabel)="en")} | ||
OPTIONAL{?institution wdt:P154 ?_logoImage.} | OPTIONAL{?institution wdt:P154 ?_logoImage.} | ||
| − | OPTIONAL{?institution wdt: | + | OPTIONAL{?institution wdt:P1813 ?_shortName.} |
OPTIONAL{?institution wdt:P17 ?_country.} | OPTIONAL{?institution wdt:P17 ?_country.} | ||
OPTIONAL{?institution wdt:P625 ?_coordinateLocation.} | OPTIONAL{?institution wdt:P625 ?_coordinateLocation.} | ||
| Line 34: | Line 35: | ||
} | } | ||
GROUP BY ?institution ?institutionLabel | GROUP BY ?institution ?institutionLabel | ||
| − | |wdqsurl= | + | |tryiturl=z7hnKG |
| + | |wdqsurl=6UKK | ||
|relevance=1 | |relevance=1 | ||
|task=Task0 | |task=Task0 | ||
|storemode=property | |storemode=property | ||
}} | }} | ||
| − | = | + | = result LIMIT 7 = |
| + | {| class="wikitable" style="text-align: left;" | ||
| + | |+ <!-- caption --> | ||
| + | |- | ||
| + | ! institution !! institutionLabel !! logoImage !! country !! coordinateLocation !! officialWebsite !! gndId !! shortName | ||
| + | |- | ||
| + | | http://www.wikidata.org/entity/Q154561 || University of Jena || http://commons.wikimedia.org/wiki/Special:FilePath/Logo%20UniJena.svg || http://www.wikidata.org/entity/Q183 || Point(11.582222222 50.928333333) || https://www.uni-jena.de/ || 36164-1 || | ||
| + | |- | ||
| + | | http://www.wikidata.org/entity/Q1065414 || Free University of Amsterdam || http://commons.wikimedia.org/wiki/Special:FilePath/Maagd%20in%20de%20tuin.gif || http://www.wikidata.org/entity/Q55 || || http://www.vu.nl/ || 80108-2 || | ||
| + | |- | ||
| + | | http://www.wikidata.org/entity/Q793867 || Scripps Research || || http://www.wikidata.org/entity/Q30 || Point(-117.242457 32.896092) || https://www.scripps.edu/ || 1085823946 || | ||
| + | |- | ||
| + | | http://www.wikidata.org/entity/Q49108 || Massachusetts Institute of Technology || http://commons.wikimedia.org/wiki/Special:FilePath/MIT%20logo.svg || http://www.wikidata.org/entity/Q30 || Point(-71.091944444 42.359722222) || https://web.mit.edu/ || 2179-9 || MIT | ||
| + | |- | ||
| + | | http://www.wikidata.org/entity/Q278044 || Vienna University of Economics and Business || http://commons.wikimedia.org/wiki/Special:FilePath/Logo%20Wirtschaftsuniversit%C3%A4t%20Wien.svg || http://www.wikidata.org/entity/Q40 || Point(16.4082 48.2141) || https://www.wu.ac.at/ || 115001-7 || | ||
| + | |- | ||
| + | | http://www.wikidata.org/entity/Q7058064 || Khoury College of Computer Sciences || || http://www.wikidata.org/entity/Q30 || Point(-71.0903 42.3389) || http://www.ccis.northeastern.edu/ || || | ||
| + | |- | ||
| + | | http://www.wikidata.org/entity/Q214341 || University of Amsterdam || http://commons.wikimedia.org/wiki/Special:FilePath/Uva%C2%AEmerken%20ENG.png || http://www.wikidata.org/entity/Q55 || Point(4.890277777 52.368333333) || http://www.uva.nl/ || 1010694-7 || | ||
| + | |} | ||
Latest revision as of 16:23, 21 March 2023
Query
| Query | |
|---|---|
 edit
| |
| id | 6 |
| name | AllInstitutions |
| title | All institutions |
| description | List all institutions from which at least one scholar has once (co-)authored a paper or proceeding that has been published through CEUR-WS. |
| sparql | # Q0.6 List all institutions
SELECT DISTINCT ?institution ?institutionLabel
(SAMPLE(?_logoImage) as ?logoImage)
(SAMPLE(?_shortName) as ?shortName)
(SAMPLE(?_country) as ?country)
(SAMPLE(?_coordinateLocation) as ?coordinateLocation)
(SAMPLE(?_officialWebsite) as ?officialWebsite)
(SAMPLE(?_gndId) as ?gndId)
WHERE{
?proceeding wdt:P31 wd:Q1143604.
?proceeding wdt:P179 wd:Q27230297.
{
# authors
?paper wdt:P1433 ?proceeding.
?paper p:P50/pq:P1416 ?institution.
}UNION{
# editors
?proceeding p:P98/pq:P1416 ?institution.
}
OPTIONAL{?institution rdfs:label ?institutionLabel. Filter(lang(?institutionLabel)="en")}
OPTIONAL{?institution wdt:P154 ?_logoImage.}
OPTIONAL{?institution wdt:P1813 ?_shortName.}
OPTIONAL{?institution wdt:P17 ?_country.}
OPTIONAL{?institution wdt:P625 ?_coordinateLocation.}
OPTIONAL{?institution wdt:P856 ?_officialWebsite.}
OPTIONAL{?institution wdt:P227 ?_gndId.}
}
GROUP BY ?institution ?institutionLabel
|
| tryiturl | z7hnKG→z7hnKG |
| wdqsurl | 6UKK→6UKK |
| scholia | → |
| relevance | 1 |
| comment | |
| task | Task0→Task0 |
