entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_SAINT_GEORGE"
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_GEORGE_GOLDEN | George ENT_SAINT_GEORGE | Jacobus de Voragine, Golden Legend SRC_GOLDEN_LEGEND | The Golden Legend (Caxton) | The Golden Legend (Caxton) | Thus the blessed George was high in de- Digitized by vjOOQIC 126 THE GOLDEN LEGEND The Life spising low things, and therefore he had verdure of S. in himself, he was attemperate by discretion, and ®eor®e therefore he had wine of gladness, and within he was plane of humility, and thereby put he forth wheat of good works. Or George may be said of gerar, that is holy, and of gyon, that is a wrestler, that is an holy wrestler, for he wrestled with the dragon. | 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]);