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'}

3 rows where entity_id = "ENT_DIONYSUS"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: confidence, source_id, review_status

Link entity_id period_id confidence rationale source_id review_status
ENT_DIONYSUS,PER_GRK_ARCHAIC Dionysus ENT_DIONYSUS Archaic Period PER_GRK_ARCHAIC A Major god of wine, ecstasy, theater, and mystery cult. SRC_THEOI_GODS candidate_verified_name
ENT_DIONYSUS,PER_GRK_CLASSICAL Dionysus ENT_DIONYSUS Classical Period PER_GRK_CLASSICAL A Central to theater and civic festivals. SRC_THEOI_GODS candidate_verified_name
ENT_DIONYSUS,PER_GRK_MYCENAEAN Dionysus ENT_DIONYSUS Mycenaean Period PER_GRK_MYCENAEAN high di-wo-nu-so at Pylos (PY Xa 102) is one of the most significant Linear B finds: it demonstrates that Dionysus was a Mycenaean deity, overturning the long-held scholarly view (Nietzsche, Rohde, Wilamowitz) that Dionysus was a late foreign import into Greece SRC_VENTRIS_CHADWICK 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]);