entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_ART_KAY"

✎ View and edit SQL

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_KAY_GEOFFR Kay ENT_ART_KAY Geoffrey of Monmouth, Historia Regum Britanniae, c. 1136 CE SRC_GEOFFREY_MONMOUTH Geoffrey of Monmouth, Historia Regum Britanniae Geoffrey of Monmouth, Historia Regum Britanniae The next night, therefore, at the second hour, Arthur, taking along with him Caius the sewer, and Bedver the butler, went out privately from the camp, and hastened towards the mountain. For being a man of undaunted courage, he did not care to lead his army against such monsters; both because he could in this manner animate his men by his own example, and also because he was alone sufficient to deal with them. 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

CSV options: 

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]);