entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_CHR_AGNES"
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_AGNES_GOLDEN | Agnes ENT_CHR_AGNES | Jacobus de Voragine, Golden Legend SRC_GOLDEN_LEGEND | The Golden Legend (Caxton) | The Golden Legend (Caxton) | Agnes. The blessed virgin S. Agnes was much wise, and well taught, as S. Ambrose witnesseth, and wrote her passion. She was fair of visage, but much fairer in the Christian faith, she was young of age, and aged in wit, for in the thirteenth year of her age she lost the death that the world giveth, and found life in Jesu Christ, which when she came from school the son of the prefect of Rome, for the emperor, loved her, and when his father and mother knew it | 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]);