entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_SAINT_GILES"
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_GILES_GOLDEN | Giles ENT_SAINT_GILES | Jacobus de Voragine, Golden Legend SRC_GOLDEN_LEGEND | The Golden Legend (Caxton) | The Golden Legend (Caxton) | Digitized by Google 92 THE GOLDEN LEGEND The Life of a Giles Of S. Giles. S. Giles was born in Athens, and was of noble lineage and royal kindred. And in his childhood he was informed in holy lettrure. And on a day as he went to the church, he found a sick man which lay all sick in the way and demanded alms of S. Giles, which gave him his coat. And as soon as he clad him withal he received full and entire health. | 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]);