entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_ART_ELAINE_ASTOLAT"

✎ 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_ELAINE_ASTOLAT_MALORY Elaine of Astolat ENT_ART_ELAINE_ASTOLAT Sir Thomas Malory, Le Morte d'Arthur, completed c. 1469-1470, printed by Caxton 1485 CE SRC_MALORY_MORTE Malory, Le Morte d'Arthur Malory, Le Morte d'Arthur Of the great lamentation of the Fair Maid of Astolat when Launcelot should depart, and how she died for his love. .........................................................................................657 20 CHAPTER XX. How the corpse of the Maid of Astolat arrived to-fore King Arthur, and of the burying, and how Sir Launcelot offered the mass-penny. ...........................................................659 CHAPTER XXI. Sir Thomas Malory 1485 None primary-verbatim   2026-06-18 name-anchored (note-keyword scored) + substring gate; locus per attestation 1 1 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]);