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_STJ_SARAH_OF_TOBIT"

✎ View and edit SQL

This data as json, CSV (advanced)

Link entity_id period_id confidence rationale source_id review_status
ENT_STJ_SARAH_OF_TOBIT,PER_ISR_SECOND_TEMPLE Sarah (of Tobit) ENT_STJ_SARAH_OF_TOBIT Second Temple Period PER_ISR_SECOND_TEMPLE high Daughter of Raguel, tormented by the demon Asmodeus until freed and married to Tobias through Raphael's aid (Book of Tobit, NRSV Apocrypha). Homonym distinct from the matriarch Sarah (ENT_ISR_SARAH). SRC_APOCRYPHA_NRSV 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]);