entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_MANICH_THIRD_MESSENGER"
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_THIRD_MESSENGER_MANICH | Third Messenger ENT_MANICH_THIRD_MESSENGER | Manichaean Kephalaia SRC_MANICHAEAN_KEPHALAIA | Manichaean Texts from the Roman Empire (Kephalaia) | Manichaean Texts from the Roman Empire (Kephalaia) | the Third Messenger. Alexander is almost unique among Greek and Latin sources in identifying both demiurgic figures in the Manichaean system. Teachings 181 labour of separation. This labour is an obvious thing and, so it is said, even a blind man can see it. For in its waxing phase the moon collects the power which was separated from matter, and becomes filled with it during this time. (p. | 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]);