Submissions for GESIS KG

Description

The GESIS Knowledge Graph (GESIS KG) is an integrated research knowledge graph that captures and interlinks metadata of scientific resources—such as datasets, publications, variables, and survey instruments—along with entities like authors and social science concepts, from GESIS Search.

Learn more about this knowledge graph
Access the SPARQL endpoint
Download metadata

29 of 29 submissions

#25

Natural Language Question

List all resources from a particular type

Source

https://data.gesis.org/gesiskg/site/#Access

SPARQL Query

Run Query

    SELECT ?id ?title
    WHERE {?id a <https://schema.org/ScholarlyArticle>.
        ?id <https://schema.org/name> ?title.
    } 
    LIMIT 10000

#26

Natural Language Question

List all information available for a particular resource

Source

https://data.gesis.org/gesiskg/site/#Access

SPARQL Query

Run Query

    SELECT *
    WHERE {<https://data.gesis.org/gesiskg/resource/ZA5282> ?p ?o}

#27

Natural Language Question

List all datasets and the publications that cite them for the topic "Migration".

Source

https://data.gesis.org/gesiskg/site/#Access

SPARQL Query

Run Query

    SELECT ?publication ?publication_title ?dataset ?dataset_title
    WHERE {?publication <https://schema.org/about> ?topic.  
        ?topic <https://schema.org/name> "Migration"@en.
        ?publication a <https://schema.org/ScholarlyArticle>.  
        ?publication <https://schema.org/citation> ?dataset.
        ?dataset a <https://schema.org/Dataset>.
        ?publication <https://schema.org/name> ?publication_title.
        ?dataset <https://schema.org/name> ?dataset_title.
    }Limit 100

#28

Natural Language Question

What is the number of publications per year that cite datasets focusing on the topic Migration?

SPARQL Query

Run Query

    SELECT ?year (COUNT(?publication) AS ?count)
    WHERE {?publication a <https://schema.org/ScholarlyArticle>.
        ?publication <https://schema.org/citation> ?dataset.
        ?dataset a <https://schema.org/Dataset>. 
        ?dataset <https://schema.org/about> ?topic.  
        ?topic <https://schema.org/name> "Migration"@en.
        ?publication <https://schema.org/datePublished> ?year .
    } 
    GROUP BY ?year
    ORDER BY ?year

#56

Natural Language Question

List publications which are citing a dataset which is using a survey instrument.

SPARQL Query

Run Query

SELECT ?publication ?dataset ?instrument
WHERE {?instrument ?i <http://rdf-vocabulary.ddialliance.org/lifecycle#Instrument>.
       ?instrument <https://data.gesis.org/gesiskg/schema/reference> ?s.
       ?s <https://data.gesis.org/gesiskg/schema/referenceMetadata> ?t.
       ?t <https://schema.org/mainEntity> ?dataset.
       ?instrument <https://data.gesis.org/gesiskg/schema/reference> ?d.
       ?d <https://data.gesis.org/gesiskg/schema/referenceMetadata> ?e.
       ?e <https://schema.org/mainEntity> ?publication.
       ?publication ?p <https://schema.org/ScholarlyArticle>.  
       ?publication <https://data.gesis.org/gesiskg/schema/reference> ?r.  
       ?r ?p1 <https://data.gesis.org/gesiskg/schema/DatasetReference>. 
       ?r <https://data.gesis.org/gesiskg/schema/referenceMetadata> ?m. 
       ?m ?p2 <https://data.gesis.org/gesiskg/schema/LinkMetadata>. 
       ?m <https://schema.org/mainEntity> ?dataset.
       ?dataset ?p3 <https://schema.org/Dataset>.
}

#57

Natural Language Question

Year wise count of datasets focusing on the topic Germany including dataset names and DOIs

#58

Natural Language Question

List all publications with their links to survey variables and datasets

#59

Natural Language Question

List all publications which cite a dataset from the years 2010 to 2020 including publication and dataset titles and DOIs

#60

Natural Language Question

Are there any datasets dealing with health or wellbeing related topics?

#61

Natural Language Question

What are the most recent publications citing datasets dealing with topics of political attitude or election behaviour?

#62

Natural Language Question

Which authors are publishing the most in the topic of migration?

#66

Natural Language Question

What are all the universities in Italy?

#69

Natural Language Question

What are the entities in this KG?

#71

Natural Language Question

What are the publications related to literary newspapers in France?

#75

Natural Language Question

How many social psychology research papers use interview methods?

#77

Natural Language Question

List all publications about gender studies

#79

Natural Language Question

what are the institutions in Europe investigating on political corruption?

#82

Natural Language Question

What are the datasets linked to feminism studies?

#92

Natural Language Question

What are the all the universities in Italy?

#95

Natural Language Question

List all the publications, their titles, and their mentioned variables from the study group ALLBUS

Source

https://data.gesis.org/gesiskg/site/#Access

SPARQL Query

Run Query

PREFIX schema: <https://schema.org/>
PREFIX gesiskg: <https://data.gesis.org/gesiskg/schema/>
PREFIX ddi: <http://rdf-vocabulary.ddialliance.org/lifecycle#>
SELECT *
WHERE {
    ?publication a schema:ScholarlyArticle.
    ?publication schema:name ?publication_title .
    ?variable a ddi:Variable.
    ?publication schema:citation ?variable.
    ?variable schema:name ?variable_title .
    ?variable gesiskg:studyGroup "ALLBUS"@en
}

#179

Natural Language Question

Is the number of publications and studies dealing with topics of migration increasing in the recent years?

#180

Natural Language Question

Are there trending topics in the social sciences in the last ten years?

#181

Natural Language Question

Which survey variables are used in datasets when political attitude is investigated?

#182

Natural Language Question

Are there datasets focusing on social media data?

#183

Natural Language Question

Are there publications about social online discourse and who are most cited authors?

#184

Natural Language Question

What are datasets from the last five years dealing with the topic migration and publications citing those datasets?

SPARQL Query

Run Query

SELECT ?publication_title ?dataset_title ?year 
WHERE {?publication a <https://schema.org/ScholarlyArticle>.
       ?publication <https://schema.org/citation> ?dataset.
       ?dataset a <https://schema.org/Dataset>. 
       ?dataset <https://schema.org/about> ?topic.  
       ?publication <https://schema.org/about> ?topic.  
       ?topic <https://schema.org/name> "Migration"@en.
       ?publication <https://schema.org/name> ?publication_title .
       ?dataset <https://schema.org/name> ?dataset_title .
       ?publication <https://schema.org/datePublished> ?year .
       FILTER (?year >= "2020"^^<http://www.w3.org/2001/XMLSchema#gyear>)
} 
GROUP BY ?year
ORDER BY ?year

#185

Natural Language Question

Which variables have been used in the study ZA5282?

SPARQL Query

Run Query

PREFIX schema: <https://schema.org/>

SELECT ?variable ?varName WHERE {

  ?variable a <http://rdf-vocabulary.ddialliance.org/lifecycle#Variable> .
  ?variable schema:name ?varName .
  ?variable <https://data.gesis.org/gesiskg/schema/relatedDataset> <https://data.gesis.org/gesiskg/resource/ZA5282> .
}
LIMIT 100

#186

Natural Language Question

Are there survey instruments measuring "Zufriedenheit"?

SPARQL Query

Run Query

PREFIX schema: <https://schema.org/>

SELECT ?instrument ?title WHERE {
  ?instrument a <http://rdf-vocabulary.ddialliance.org/lifecycle#Instrument> .
  ?instrument schema:name ?title .
  ?instrument schema:description ?desc .
  FILTER(CONTAINS(LCASE(?desc), "zufriedenheit") || CONTAINS(LCASE(?title), "satisfaction"))
}

#187

Natural Language Question

Which organizations have the most studies archived at GESIS?

SPARQL Query

Run Query

PREFIX schema: <https://schema.org/>

SELECT ?orgName (COUNT(DISTINCT ?dataset) AS ?datasetCount) WHERE {
  ?dataset a schema:Dataset .

  { ?dataset schema:publisher ?org . }
  UNION
  { ?dataset schema:creator ?org . }
  
  ?org a schema:Organization .
  ?org schema:name ?orgName .
}
GROUP BY ?orgName
HAVING (COUNT(DISTINCT ?dataset) > 1)
ORDER BY DESC(?datasetCount)
LIMIT 50

Quagga has been developed by Odoma ↗ for Graphia ↗

Funded by the European Union (grant ID: 101188018 ↗)

Contact Github FAQ