entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_SAINT_CATHERINE_ALEX"
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_SAINT_CATHERINE_ALEX_GOLDEN | Catherine of Alexandria ENT_SAINT_CATHERINE_ALEX | Jacobus de Voragine, Golden Legend SRC_GOLDEN_LEGEND | The Golden Legend (Caxton) | The Golden Legend (Caxton) | Eugenia, the noble virgin, which was daughter to Philip, duke of Alexandria, which for the emperor of Rome governed all the land of Egypt. Eugenia issued privily out of her father's palace with two servants, and she went into an abbey in Digitized by Google The Life of S. Eugene 152 THE GOLDEN LEGEND The Life the habit and array of a man, in which abbey she S. Jed go holy a life that at the last she was made Stephen a hh 0 t of the same. | 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
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]);