Entity Sources

2,936 links between entities and the sources that attest them, with evidence type and passage-level notes. The primary evidence layer: every entity classification traces to at least one record here.

Data license: MIT · Data source: jebboone/deitydb

evidence_type
{'description': 'e.g. Direct attestation, Secondary analysis, Epigraphic, Numismatic'}
source_note
{'description': 'Specific passage citations and notes on how this source attests the entity'}

15 rows where source_id = "SRC_MALORY_MORTE"

✎ View and edit SQL

This data as json, CSV (advanced)

Link entity_id source_id evidence_type source_note
ENT_ART_AGRAVAIN,SRC_MALORY_MORTE,primary text attestation Agravain ENT_ART_AGRAVAIN Sir Thomas Malory, Le Morte d'Arthur, completed c. 1469-1470, printed by Caxton 1485 CE SRC_MALORY_MORTE primary text attestation Brother of Gawain who with Mordred exposes the affair, triggering the collapse.
ENT_ART_ELAINE_ASTOLAT,SRC_MALORY_MORTE,primary text attestation 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 primary text attestation The lily maid of Astolat who dies of unrequited love for Lancelot.
ENT_ART_EXCALIBUR,SRC_MALORY_MORTE,primary text attestation Excalibur ENT_ART_EXCALIBUR Sir Thomas Malory, Le Morte d'Arthur, completed c. 1469-1470, printed by Caxton 1485 CE SRC_MALORY_MORTE primary text attestation Arthur's sword (Geoffrey's Caliburn), given by the Lady of the Lake and returned to her at his death.
ENT_ART_GAHERIS,SRC_MALORY_MORTE,primary text attestation Gaheris ENT_ART_GAHERIS Sir Thomas Malory, Le Morte d'Arthur, completed c. 1469-1470, printed by Caxton 1485 CE SRC_MALORY_MORTE primary text attestation Brother of Gawain who slays Morgause; later killed by Lancelot.
ENT_ART_GARETH,SRC_MALORY_MORTE,primary text attestation Gareth ENT_ART_GARETH Sir Thomas Malory, Le Morte d'Arthur, completed c. 1469-1470, printed by Caxton 1485 CE SRC_MALORY_MORTE primary text attestation Brother of Gawain who proves his knighthood; slain inadvertently by Lancelot.
ENT_ART_GREEN_KNIGHT,SRC_MALORY_MORTE,primary text attestation The Green Knight ENT_ART_GREEN_KNIGHT Sir Thomas Malory, Le Morte d'Arthur, completed c. 1469-1470, printed by Caxton 1485 CE SRC_MALORY_MORTE primary text attestation Green otherworldly challenger (Bertilak enchanted) who tests Gawain's honor in the beheading game.
ENT_ART_GUINEVERE,SRC_MALORY_MORTE,primary text attestation Guinevere ENT_ART_GUINEVERE Sir Thomas Malory, Le Morte d'Arthur, completed c. 1469-1470, printed by Caxton 1485 CE SRC_MALORY_MORTE primary text attestation Wife of Arthur whose love for Lancelot precipitates the fall of the realm.
ENT_ART_ISOLDE,SRC_MALORY_MORTE,primary text attestation Isolde ENT_ART_ISOLDE Sir Thomas Malory, Le Morte d'Arthur, completed c. 1469-1470, printed by Caxton 1485 CE SRC_MALORY_MORTE primary text attestation Irish princess and queen of Cornwall, fated lover of Tristan.
ENT_ART_KING_LOT,SRC_MALORY_MORTE,primary text attestation King Lot ENT_ART_KING_LOT Sir Thomas Malory, Le Morte d'Arthur, completed c. 1469-1470, printed by Caxton 1485 CE SRC_MALORY_MORTE primary text attestation King of Orkney, husband of Morgause and father of Gawain and his brothers.
ENT_ART_LAMORAK,SRC_MALORY_MORTE,primary text attestation Lamorak ENT_ART_LAMORAK Sir Thomas Malory, Le Morte d'Arthur, completed c. 1469-1470, printed by Caxton 1485 CE SRC_MALORY_MORTE primary text attestation Son of Pellinore; his affair with Morgause leads to murder by the Orkney brothers.
ENT_ART_MORDRED,SRC_MALORY_MORTE,primary text attestation Mordred ENT_ART_MORDRED Sir Thomas Malory, Le Morte d'Arthur, completed c. 1469-1470, printed by Caxton 1485 CE SRC_MALORY_MORTE primary text attestation Begotten by Arthur upon Morgause; slays and is slain by Arthur at Camlann.
ENT_ART_MORGAUSE,SRC_MALORY_MORTE,primary text attestation Morgause ENT_ART_MORGAUSE Sir Thomas Malory, Le Morte d'Arthur, completed c. 1469-1470, printed by Caxton 1485 CE SRC_MALORY_MORTE primary text attestation Half-sister of Arthur, wife of Lot, mother of the Orkney knights and of Mordred.
ENT_ART_PELLINORE,SRC_MALORY_MORTE,primary text attestation Pellinore ENT_ART_PELLINORE Sir Thomas Malory, Le Morte d'Arthur, completed c. 1469-1470, printed by Caxton 1485 CE SRC_MALORY_MORTE primary text attestation King who pursues the Questing Beast, slays Lot, and fathers Lamorak.
ENT_ART_ROUND_TABLE,SRC_MALORY_MORTE,primary text attestation The Knights of the Round Table ENT_ART_ROUND_TABLE Sir Thomas Malory, Le Morte d'Arthur, completed c. 1469-1470, printed by Caxton 1485 CE SRC_MALORY_MORTE primary text attestation The fellowship of knights sworn to Arthur, gathered about the Round Table at Camelot.
ENT_ART_TRISTAN,SRC_MALORY_MORTE,primary text attestation Tristan ENT_ART_TRISTAN Sir Thomas Malory, Le Morte d'Arthur, completed c. 1469-1470, printed by Caxton 1485 CE SRC_MALORY_MORTE primary text attestation Cornish knight whose love for Isolde parallels the Lancelot-Guinevere affair.

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "entity_sources" (
   [entity_id] TEXT REFERENCES [entities]([entity_id]),
   [source_id] TEXT REFERENCES [sources]([source_id]),
   [evidence_type] TEXT,
   [source_note] TEXT,
   PRIMARY KEY ([entity_id], [source_id], [evidence_type])
);
CREATE INDEX [idx_entity_sources_source_id]
    ON [entity_sources] ([source_id]);
CREATE INDEX [idx_entity_sources_entity_id]
    ON [entity_sources] ([entity_id]);