entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_NOR_RATATOSKR"

✎ 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_RATATOSKR_POETIC Ratatoskr ENT_NOR_RATATOSKR Poetic Edda SRC_POETIC_EDDA The Poetic Edda The Poetic Edda The squirrel Ratatoskr brings word from the eagle at the top of the tree to the dragon Niðhoggr below (32). Four stags gnaw the tree's shoots (33), and snakes lie beneath it, eating away (34). The tree suffers as a stag bites it from above and Niðhoggr from below, and its side rots (35). Grimnir asks some valkyries to bring him a drinking-horn (36). He then speaks of the sun, the moon and the terrestrial world. 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]);