entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_ART_IGRAINE"
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_ART_IGRAINE_GEOFFR | Igraine ENT_ART_IGRAINE | Geoffrey of Monmouth, Historia Regum Britanniae, c. 1136 CE SRC_GEOFFREY_MONMOUTH | Geoffrey of Monmouth, Historia Regum Britanniae | Geoffrey of Monmouth, Historia Regum Britanniae | When he had a full relation made to him how matters had succeeded, he was sorry for the death of Gorlois, but rejoiced that Igerna was now at liberty to marry again. Then he returned to the town of Tintagel, which he took, and in it, what he impatiently wished for, Igerna herself. After this they continued to live together with much affection for each other, and had a son and daughter, whose names were Arthur and Anne. CHAP. | J. A. Giles | 1848 | https://www.gutenberg.org/ebooks/37848 | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | English translation (J. A. Giles, in Old English Chronicles, Gutenberg #37848) located by name; verify book.chapter. |
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]);