entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_CHR_CECILIA"

✎ 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_CHR_CECILIA_GOLDEN Cecilia ENT_CHR_CECILIA Jacobus de Voragine, Golden Legend SRC_GOLDEN_LEGEND The Golden Legend (Caxton) The Golden Legend (Caxton) Cecilia, virgin and martyr, and first of her name. Cecilia is as much to say as the lily of heaven, or a way to blind men. Or she is said of celo and lia, or else cecilia, as lacking blindness. Or she is said of celo, that is heaven, and leos, that is people. William Caxton 1483 https://archive.org/details/TheGoldenLegendV1 primary-verbatim   2026-06-18 name-anchored (note-keyword scored) + substring gate; locus per attestation 1 1 OCR scan of Caxtons Golden Legend, located by name; verify the saint.  

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