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

4 rows where source_id = "SRC_VALIENTE_WFT"

✎ View and edit SQL

This data as json, CSV (advanced)

Link entity_id source_id evidence_type source_note
ENT_WIC_DRYGHTYN,SRC_VALIENTE_WFT,primary text attestation The Dryghtyn (the One) ENT_WIC_DRYGHTYN Doreen Valiente, Witchcraft for Tomorrow (London: Robert Hale, 1978) SRC_VALIENTE_WFT primary text attestation attestation
ENT_WIC_HORNED_GOD,SRC_VALIENTE_WFT,primary text attestation The Horned God ENT_WIC_HORNED_GOD Doreen Valiente, Witchcraft for Tomorrow (London: Robert Hale, 1978) SRC_VALIENTE_WFT primary text attestation attestation
ENT_WIC_TRIPLE_GODDESS,SRC_VALIENTE_WFT,primary text attestation The Triple Goddess (Maiden, Mother, Crone) ENT_WIC_TRIPLE_GODDESS Doreen Valiente, Witchcraft for Tomorrow (London: Robert Hale, 1978) SRC_VALIENTE_WFT primary text attestation attestation
ENT_WIC_WATCHTOWER_GUARDIANS,SRC_VALIENTE_WFT,primary text attestation The Guardians of the Watchtowers ENT_WIC_WATCHTOWER_GUARDIANS Doreen Valiente, Witchcraft for Tomorrow (London: Robert Hale, 1978) SRC_VALIENTE_WFT primary text attestation attestation

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]);