- Participants are way incomplete
- No linked topics
- publications?
- events?
- data?
Online, e.g. https://www.wikidata.org/wiki/Q113500855
- click “edit” next to any statement
- what’s a statement?
- RDF triple:
?subject ?predicate ?object .or
?subject ?property_name ?property_value . - Adopted from the Wikidata introduction)
<http://example.org/DouglasAdams> <http://example.org/educated_at> "St. John's College" .
- Wikidata subjects (
item): has a label, a description and any number of aliases. URI pattern: https://www.wikidata.org/entity/Q123456789 - Wikidata
statement=property+value
| Item | Property | Value |
|---|---|---|
| wd:Q42 | rdfs:label | “Douglas Adams”^^xsd:string |
| wd:Q42 | schema:description | “A British writer”^^xsd:string@en |
| wd:Q42 | schema:description | “Ein britischer Autor”^^xsd:string@de |
| wd:Q42 | schema:description | “Un écrivain français”^^xsd:string@fr |
| wd:Q42 | wdp:P69 | Q691283 |
| wp:P69 | rdfs:label | “educated at”^^xsd:string@en |
| wd:Q691283 | label | “St. John’s College”^^xsd:string |
- Each property-value pair (
statement) can have additional annotations, such as references, validity dates, …
Example:NFDI4BIOIMAGE’s chairperson
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
select * where {
wd:Q113500855 ?property ?value .
}
limit 30PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
select * where {
wd:Q113500855 wdt:P31 ?instance_of .
?instance_of ?iprop ?ival .
}
limit 30- OpenRefine (“reconciliation”)
- QuickStatements -> https://quickstatements.toolforge.org/
- See more at https://www.wikidata.org/wiki/Wikidata:Tools
-
- Yourself
- Name
- Affiliation
- ORCID
- other IDs
- Degree
- Field of work
- Website
- Social media, github handles
- Publications -> https://orcid-scraper.toolforge.org
- …
- ROR ID
- Website
SELECT ?graph (count(?subject) as ?number_of_triples)
WHERE {
graph ?graph { ?subject ?predicate ?object }
}
group by ?graph| graph | number_of_triples |
|---|---|
| https://kg.nfdi4bioimage.de/n4bikg/core | 8 |
| https://kg.nfdi4bioimage.de/n4bikg/n4bi_zenodo_community | 3482 |
| https://kg.nfdi4bioimage.de/n4bikg/owl | 3993 |
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix dcite: <https://schema.datacite.org/meta/kernel-4.6/metadata.xsd#>
select ?s ?p ?plabel ?o ?olabel where
{
?s ?p ?o
optional {
?p rdfs:label ?plabel.
}
optional {
?o rdfs:label ?olabel .
}
}
limit 10PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix dcite: <https://schema.datacite.org/meta/kernel-4.6/metadata.xsd#>
prefix nfdicore: <https://nfdi.fiz-karlsruhe.de/ontology/>
select *
where
{
<https://doi.org/10.5281/zenodo.14013026> dcite:creator ?creator .
?creator dcite:givenName ?creator_given_name ;
dcite:familyName ?creator_family_name .
?creator dcite:affiliation ?affiliation .
filter(isiri(?affiliation))
?affiliation rdfs:label ?affiliation_name .
}
limit 40| creator | creator_given_name | creator_family_name | affiliation | affiliation_name |
|---|---|---|---|---|
| https://orcid.org/0000-0001-9568-895X | Christian | Schmidt | https://ror.org/0546hnb39 | University of Konstanz |
| https://orcid.org/0000-0001-9568-895X | Christian | Schmidt | https://ror.org/04cdgtt98 | German Cancer Research Center |
| https://orcid.org/0000-0001-9568-895X | Christian | Christian Schmidt | https://ror.org/0546hnb39 | University of Konstanz |
| https://orcid.org/0000-0001-9568-895X | Christian | Christian Schmidt | https://ror.org/04cdgtt98 | German Cancer Research Center |
| https://orcid.org/0000-0001-7734-3771 | Stefanie | Stefanie Weidtkamp-Peters | https://ror.org/01vnkaz16 | NFDI4BIOIMAGE |
| https://orcid.org/0000-0001-7734-3771 | Stefanie | Stefanie Weidtkamp-Peters | https://ror.org/024z2rq82 | Heinrich Heine University Düsseldorf |
| https://orcid.org/0000-0001-7734-3771 | Stefanie | Weidtkamp-Peters | https://ror.org/01vnkaz16 | NFDI4BIOIMAGE |
| https://orcid.org/0000-0001-7734-3771 | Stefanie | Weidtkamp-Peters | https://ror.org/024z2rq82 | Heinrich Heine University Düsseldorf |
| https://orcid.org/0000-0001-6523-7496 | Susanne | Kunis | https://ror.org/04qmmjx98 | Osnabrück University |
| b0 | Tom | Boissonnet | https://ror.org/024z2rq82 | Heinrich Heine University Düsseldorf |
| b1 | Bettina | Hagen | https://ror.org/04xx1tc24 | Max Planck Institute for Biology of Ageing |
Some records must have the full name set as ‘family name’.
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix dcite: <https://schema.datacite.org/meta/kernel-4.6/metadata.xsd#>
prefix nfdicore: <https://nfdi.fiz-karlsruhe.de/ontology/>
select *
where
{
<https://orcid.org/0000-0001-7734-3771> dcite:givenName ?first;
dcite:familyName ?last .
}| first | last |
|---|---|
| Stefanie | Stefanie Weidtkamp-Peters |
| Stefanie | Weidtkamp-Peters |
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix dcite: <https://schema.datacite.org/meta/kernel-4.6/metadata.xsd#>
prefix nfdicore: <https://nfdi.fiz-karlsruhe.de/ontology/>
select ?record (count(distinct ?creator) as ?ncreators) (count(distinct ?contributor) as ?ncontributor)
where
{
?record dcite:contributor ?contributor ;
dcite:creator ?creator .
}
group by ?recordPREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix dcite: <https://schema.datacite.org/meta/kernel-4.6/metadata.xsd#>
prefix nfdicore: <https://nfdi.fiz-karlsruhe.de/ontology/>
select ?institution (count(distinct ?record) as ?nrecords)
where
{
?record dcite:creator ?creator .
?creator dcite:affiliation ?institution .
filter(isiri(?institution))
}
group by ?institution
order by desc(?nrecords)PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix dcite: <https://schema.datacite.org/meta/kernel-4.6/metadata.xsd#>
prefix nfdicore: <https://nfdi.fiz-karlsruhe.de/ontology/>
select ?creator (count(distinct ?record) as ?nrecords)
where
{
?record dcite:creator ?creator .
?creator dcite:familyName ?name .
}
group by ?creator
order by desc(?nrecords)