entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_MANICH_LAST_STATUE"
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_LAST_STATUE_MANICH | Last Statue ENT_MANICH_LAST_STATUE | Manichaean Kephalaia SRC_MANICHAEAN_KEPHALAIA | Manichaean Texts from the Roman Empire (Kephalaia) | Manichaean Texts from the Roman Empire (Kephalaia) | This Soul will gather up and rise as the Last Statue, a divinity that again (as with the Perfect Man) recapitulates the descent into the abyss of the First Man. Then the five sons of the Living Spirit will leave their tasks, and the dead husk of the universe will collapse in upon itself to sink to the depths. | 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]);