entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_NOR_BERGELMIR"

✎ 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_NOR_BERGELMIR_EDDA Bergelmir ENT_NOR_BERGELMIR Poetic Edda SRC_POETIC_EDDA The Poetic Edda Vafthrudnismal 35 He is called by the giants Bergelmir. He escaped by going on board his bark, and with him went his wife, and from them are descended the Frost-giants." 8. Benjamin Thorpe 1866 https://www.gutenberg.org/ebooks/14726 primary-verbatim   2026-06-26 name + substring gate against the cited Edda 1 1 Named in the Edda; 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]);