Tables¶
We can get information about the funded NFDI consortia from Wikidata using its SPARQL endpoint. Let’s get data about various identifiers for accepted NFDI consortia in tabular form:
SELECT ?i ?iLabel ?iDescription ?inception ?gepris ?affiliation ?affiliationLabel ?city ?cityLabel ?twitter ?github ?youtube ?url
WHERE
{
?i wdt:P31 wd:Q98270496.
OPTIONAL {?i wdt:P571 ?inception.}
OPTIONAL {?i wdt:P856 ?url.}
OPTIONAL {?i wdt:P4870 ?gepris.}
OPTIONAL {?i wdt:P2002 ?twitter.}
OPTIONAL {?i wdt:P2037 ?github.}
OPTIONAL {?i wdt:P2397 ?youtube.}
OPTIONAL {?i p:P1416 [ ps:P1416 ?affiliation; pq:P3831 wd:Q105906729 ].
OPTIONAL {?affiliation wdt:P159 ?city.}}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}