entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_MANICH_KING_GLORY"
This data as json, CSV (advanced)
Suggested facets: verified_on (date)
| 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_MANICH_KING_GLORY_MANICH | King of Glory ENT_MANICH_KING_GLORY | Manichaean Kephalaia SRC_MANICHAEAN_KEPHALAIA | Manichaean Texts from the Roman Empire (Kephalaia) | Manichaean Texts from the Roman Empire (Kephalaia) | To hold the whole elaborate structure in place he evokes his own five sons: the Adamant of Light, the Keeper of Splendour, the King of Glory, the King of Honour, and the Porter or Atlas. Each of these five has his own domain of authority. | Gardner & Lieu | 2004 | None | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | In-copyright translation — brief flagged excerpt; verify. |
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]);