entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_ISR_ANAT_YAHU"
This data as json, CSV (advanced)
| citation_id ▼ | entity_id | source_id | work_title | locus | quote | translator | translation_year | source_url | evidence_grade | evidence_note | verified_on | verify_method | display_order | needs_review | review_reason | original_text_url |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CIT_ISR_ANAT_YAHU_DDD | Anat-Yahu ENT_ISR_ANAT_YAHU | Dictionary of Deities and Demons in the Bible SRC_DDD_BIBLE | Dictionary of Deities and Demons in the Bible (2nd ed., Brill 1999) | s.v. "Anat-Yahu" (K. van der Toorn); cf. s.v. "Anat" | secondary | Pointer citation: Anat-Yahu is attested in the Elephantine oath text Cowley 44 = TAD B7.3 (5th c. BCE); the DDD entry surveys the evidence and the debate (goddess vs. hypostasis of Yahu). | buildout v2.1.60: pointer to a named DDD entry; no quote reproduced (in-copyright reference work; owner copy not on hand for gating) | 1 | 1 | POINTER CITATION — secondary reference entry named but not quote-gated; verify against the owner's DDD copy. |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "entity_citations" (
[citation_id] TEXT PRIMARY KEY,
[entity_id] TEXT REFERENCES [entities]([entity_id]),
[source_id] TEXT REFERENCES [sources]([source_id]),
[work_title] TEXT,
[locus] TEXT,
[quote] TEXT,
[translator] TEXT,
[translation_year] INTEGER,
[source_url] TEXT,
[evidence_grade] TEXT,
[evidence_note] TEXT,
[verified_on] TEXT,
[verify_method] TEXT,
[display_order] INTEGER,
[needs_review] INTEGER,
[review_reason] TEXT,
[original_text_url] TEXT
);
CREATE INDEX [idx_entity_citations_source_id]
ON [entity_citations] ([source_id]);
CREATE INDEX [idx_entity_citations_entity_id]
ON [entity_citations] ([entity_id]);