Entity Sources

2,936 links between entities and the sources that attest them, with evidence type and passage-level notes. The primary evidence layer: every entity classification traces to at least one record here.

Data license: MIT · Data source: jebboone/deitydb

evidence_type
{'description': 'e.g. Direct attestation, Secondary analysis, Epigraphic, Numismatic'}
source_note
{'description': 'Specific passage citations and notes on how this source attests the entity'}

1 row where entity_id = "ENT_FINN_PEKKO"

✎ View and edit SQL

This data as json, CSV (advanced)

Link entity_id source_id evidence_type source_note
ENT_FINN_PEKKO,SRC_AGRICOLA_PRIMER,primary text attestation Pellon Pekko (Pekko) ENT_FINN_PEKKO Mikael Agricola, Se Wsi Testamenti (The New Testament) and Psalttari (Finnish Psalter), 1548/1551; deity list in the Psalter introduction (Rucouskiria, 1544) SRC_AGRICOLA_PRIMER primary text attestation God of barley and the fields named in Agricola's list (Pellon Pekko), invoked for the growth of grain and the making of beer.

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "entity_sources" (
   [entity_id] TEXT REFERENCES [entities]([entity_id]),
   [source_id] TEXT REFERENCES [sources]([source_id]),
   [evidence_type] TEXT,
   [source_note] TEXT,
   PRIMARY KEY ([entity_id], [source_id], [evidence_type])
);
CREATE INDEX [idx_entity_sources_source_id]
    ON [entity_sources] ([source_id]);
CREATE INDEX [idx_entity_sources_entity_id]
    ON [entity_sources] ([entity_id]);