entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_MANICH_PORTER"

✎ View and edit SQL

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_PORTER_MANICH Porter ENT_MANICH_PORTER Manichaean Kephalaia SRC_MANICHAEAN_KEPHALAIA Manichaean Texts from the Roman Empire (Kephalaia) Manichaean Texts from the Roman Empire (Kephalaia) 30 upon the head of the Porter. His . . . from the . . . to the earth upon which the Porter stood firm. His shins and his feet are . . . and the entire zone that belongs . . . 91 His heart is mankind. His liver is the four-footed animals. His lung is the race of birds that fly in the air. His spleen is the race of fish that swim in the waters. His kidneys are the world of reptiles that creep 5 upon the earth. His outer skin is the wall that . . . 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

CSV options: 

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