entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_NORR_GINNUNGAGAP"

✎ 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_NORR_GINNUNGAGAP_PROSE_ Ginnungagap ENT_NORR_GINNUNGAGAP Snorri Sturluson, Prose Edda SRC_PROSE_EDDA Snorri Sturluson, Prose Edda Snorri Sturluson, Prose Edda Added Thride: As cold and all things grim proceeded from Niflheim, so that which bordered on Muspelheim was hot and bright, and Ginungagap was as warm and mild as windless air. And when the heated blasts from Muspelheim met the rime, so that it melted into drops, then, by the might of him who sent the heat, the drops quickened into life and took the likeness of a man, who got the name Ymer. But the Frost giants call him Aurgelmer. Rasmus B. Anderson 1880 https://www.gutenberg.org/ebooks/18947 primary-verbatim   2026-06-18 name-anchored (note-keyword scored) + substring gate; locus per attestation 1 1 English translation (Anderson, The Younger Edda) located by name within the work (not exact chapter); verify locus.  

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