entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_NORR_MIMISBRUNNR"

✎ 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_MIMISBRUNNR_POETIC Well of Mimir (Mímisbrunnr) ENT_NORR_MIMISBRUNNR Poetic Edda SRC_POETIC_EDDA The Poetic Edda The Poetic Edda The Deluding of Gylfi 256 Of the Primordial State of the Universe 259 Origin of the Frost-Giants 260 Of the Cow Audhumla, and Birth of Odin 262 The Making of Heaven and Earth 263 Creation of Man and Woman 265 Night and Day, Sun and Moon 266 Wolves that Pursue the Sun and Moon 267 The Way that Leads to Heaven 268 The Golden Age 269 Origin of the Dwarfs, and Norns of Destiny 270 The Ash Yggdrasill and Mimer's Well 271 The Norns trans. 0 None primary-verbatim   2026-06-18 name-anchored (note-keyword scored) + substring gate; locus per attestation 1 1 In-copyright translation — brief flagged excerpt located by name; verify the poem/stanza.  

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