Entity Periods

Period assignments linking entities to the historical periods when they are attested. An entity may span multiple periods. All Greek entities are assigned; Egyptian tradition is fully covered; total coverage exceeds 70%.

Data license: MIT · Data source: jebboone/deitydb

confidence
{'description': 'high / medium / low — certainty of the period assignment'}
rationale
{'description': 'Justification with source citations'}

1 row where entity_id = "ENT_EGY_SOPDU"

✎ View and edit SQL

This data as json, CSV (advanced)

Link entity_id period_id confidence rationale source_id review_status
ENT_EGY_SOPDU,PER_EGY_OLD_KINGDOM Sopdu ENT_EGY_SOPDU Old Kingdom PER_EGY_OLD_KINGDOM high Sopdu (falcon deity of the eastern frontier, associated with the star Sirius in some traditions) is attested in the Pyramid Texts and in Old Kingdom inscriptions at the Sinai turquoise mines SRC_FAULKNER_PYRAMID_TEXTS reviewed

Advanced export

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

CSV options: 

CREATE TABLE "entity_periods" (
   [entity_id] TEXT REFERENCES [entities]([entity_id]),
   [period_id] TEXT REFERENCES [periods]([period_id]),
   [confidence] TEXT,
   [rationale] TEXT,
   [source_id] TEXT,
   [review_status] TEXT,
   PRIMARY KEY ([entity_id], [period_id])
);
CREATE INDEX [idx_entity_periods_period_id]
    ON [entity_periods] ([period_id]);
CREATE INDEX [idx_entity_periods_entity_id]
    ON [entity_periods] ([entity_id]);