entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_ART_AVALON"

✎ 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_AVALON_GEOFFR Avalon ENT_ART_AVALON Geoffrey of Monmouth, Historia Regum Britanniae, c. 1136 CE SRC_GEOFFREY_MONMOUTH Geoffrey of Monmouth, Historia Regum Britanniae Geoffrey of Monmouth, Historia Regum Britanniae Near the Sabrina and below the Thamesis lived the Hedui, whose principal cities were Ischalis and Avalonia. The baths, which were also called Aquae Solis, were made the seat of a colony, and became the perpetual residence of the Romans who possessed this part of Britain. This was a celebrated city, situated upon the river Abona, remarkable for its hot springs, which were formed into baths at a great expense. 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]);