Take stock of Releven data available for visualisations

[kevinstadler]

Stocktaking of RDF data in https://releven-graphdb.acdh-dev.oeaw.ac.at/, done via the rdfproxy endpoints at https://releven-backend-dev.acdh-dev.oeaw.ac.at/docs

Entity counts for primary entity types (people, places, texts) and "vocabularies" (languages, ethnic groups,...)

Result count for all top level model types for the default graph (rdfproxy live view):

{
  "/author_group": 67,
  "/authority_status": 0,
  "/authority_status_type": 0,
  "/bibliography": 2379,
  "/boulloterion": 5505,
  "/correspondence": 0,
  "/design": 5505,
  "/ethnic_group": 43,
  "/external_authority": 10,
  "/gender": 3,
  "/geopolitical_event": 0,
  "/geopolitical_event_type": 0,
  "/group": 120,
  "/journey": 0,
  "/language": 10,
  "/legal_status": 905,
  "/manifest_group": 0,
  "/manuscript": 0,
  "/manuscript_type": 0,
  "/material": 0,
  "/object_type": 2122,
  "/passage": 43252,
  "/people": 11153,
  "/people_with_assertions": 11156,
  "/place_type": 0,
  "/places": 1954,
  "/places_with_assertions": 675,
  "/population": 0,
  "/publication": 703,
  "/religious_affiliation": 11,
  "/seal_collection": 235,
  "/seals": 2017642,
  "/social_quality": 1072,
  "/social_relation_category": 0,
  "/social_relationship": 141,
  "/texts": 337,
  "/texts_with_assertions": 313,
  "/work": 0
}

people, place and text entities are mostly from PBW, here are the counts for all entities which were also ingested from the Releven project Excel sheet import (named graph https://r11.eu/rdf/resource/tables, rdfproxy live view):

{
  "/author_group": 0,
  "/authority_status": 0,
  "/authority_status_type": 0,
  "/bibliography": 0,
  "/boulloterion": 0,
  "/correspondence": 0,
  "/design": 0,
  "/ethnic_group": 0,
  "/external_authority": 6,
  "/gender": 0,
  "/geopolitical_event": 0,
  "/geopolitical_event_type": 0,
  "/group": 0,
  "/journey": 0,
  "/language": 0,
  "/legal_status": 0,
  "/manifest_group": 0,
  "/manuscript": 0,
  "/manuscript_type": 0,
  "/material": 0,
  "/object_type": 0,
  "/passage": 451,
  "/people": 11113,
  "/people_with_assertions": 11117,
  "/place_type": 0,
  "/places": 0,
  "/places_with_assertions": 0,
  "/population": 0,
  "/publication": 0,
  "/religious_affiliation": 0,
  "/seal_collection": 0,
  "/seals": 0,
  "/social_quality": 0,
  "/social_relation_category": 0,
  "/social_relationship": 0,
  "/texts": 0,
  "/texts_with_assertions": 0,
  "/work": 0
}

Person - historiography relations

All assertions have a _by attribute referring to the person making the assertion based on a specific passage in a specific source. Some of the assertions are also directly about a person.

• total number of assertions: 327109
• those assertions have been made by 11176 different people (actually less because duplicate labels with different IDs)
• 59271 of those assertions are made about 1080 different people (actually less because duplicate labels with different IDs)

Person - person relations

'Social relationship' types and their instances (aka 'social relationship categorisation assertions')

'Social relationship' vocabulary

• there are 182 different social relationship types in the triple store
• 41 of them are same-label duplicates with differing IDs, so really there are only 141 different social relationship type labels
• There are 794 "social relationship" assertions in total, using only the 41 social relatnship types generated from the spreadsheet data. Here are the counts for each type of social relationship

Social relationship assertions

There are a total of 1191 social relationship assertions connecting 226 different people.

• The "related person assertions" connecting people to people are currently not usable because of duplicates

Person - place relations

• 1954 places with their IDs ingested from PBW are in the triple store, no associated coordinates apparent
• spreadsheet ingest will add URIs with coordinate information to some of those places, particularly those that are referred to by assertions from the spreadsheets

The following assertions connect people and places:

• person:
  • place of birth assertion (part of birth-of-person triplet)
  • place of death assertion (part of death-of-person triplet)
• geopolitical_event:
  • places occur in geopolitical_event_attack_event_targeted_place_assertion, geopolitical_event_created_assertion, geopolitical_event_destroyed_assertion
  • people occur in geopolitical_event_active_party_assertion, geopolitical_event_attack_event.geopolitical_event_attack_event_combatant_assertion, geopolitical_event_attack_event.geopolitical_event_attack_event_challenged_authority_assertion geopolitical_event_involved_party_assertion
• written_text:
  • written_text_creation.written_text_creation_place_assertion
  • written_text_published_as_assertion.publication_creation.publication_creation_place_assertion