entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_GSAGA_SIGMUND"

✎ 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_GSAGA_SIGMUND_VOLSUN Sigmund ENT_GSAGA_SIGMUND Byock, Jesse L. (trans.), The Saga of the Volsungs: The Norse Epic of Sigurd the Dragon Slayer (Penguin Classics) SRC_BYOCK_VOLSUNGS The Saga of the Volsungs (Crawford) The Saga of the Volsungs (Crawford) Jackson Crawford Atlantic City, Wyoming June 2, 2017 Ođin Sigi Rerir Volsung Hljođ Sigmund Signy Siggeir Hjordis Alf Hjalprek Sinfotli Buđli (Guđrun) Jonakr (Brynhild) Gunnar Glaumvor Hogni Kostbera Guttorm (Brynhild) Oddrun Bekkhild Heimir Atli (Guđrun) Hamđir Sorli Erp Niflung Erp Eitil Sigurđ Ring Herruđ Aslaug Ragnar Tora Eirek Agnar ♂ ♀ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ ♂ Ivar the Boneless ♂ Hvitserk♂ Bjorn Ironside ♂ Rognvald♂ ♂ ♂ ♂ ♀ Svanh Jackson Crawford 2017 None primary-verbatim   2026-06-18 name-anchored (note-keyword scored) + substring gate; locus per attestation 1 1 In-copyright translation — brief flagged excerpt; verify.  

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