entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_ART_UTHER_PENDRAGON"

✎ 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_UTHER_PENDRAGON_GEOFFR Uther Pendragon ENT_ART_UTHER_PENDRAGON Geoffrey of Monmouth, Historia Regum Britanniae, c. 1136 CE SRC_GEOFFREY_MONMOUTH Geoffrey of Monmouth, Historia Regum Britanniae Geoffrey of Monmouth, Historia Regum Britanniae XVII.--_Uther Pendragon is made king of Britain._ But Uther his brother, having assembled the clergy of the kingdom, took the crown, and by universal consent was advanced to the kingdom. And remembering the explanation which Merlin had made of the star above-mentioned, he commanded two dragons to be made of gold, in likeness of the dragon which he had seen at the ray of the star. 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]);