entity_citations
Data license: MIT · Data source: jebboone/deitydb
2 rows where entity_id = "ENT_NOR_ODIN"
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_ODIN_POETIC | Odin ENT_NOR_ODIN | Poetic Edda SRC_POETIC_EDDA | The Poetic Edda | The Poetic Edda | The most pertinent details of Saxo's account are as follows: Balderus (Baldr) is a despicable demigod, a son of the god Othinus (Oðinn). His body can be pierced only by a sword belonging to the satyr Mimmingus. Hotherus (Hoðr) is a fine, sighted warrior-king, unrelated to Balderus. The two clash over the love of Nanna, Hotherus' foster-sister, and over power. | 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. | ||
| CIT_ODIN_HAVAMAL139 | Odin ENT_NOR_ODIN | Poetic Edda SRC_POETIC_EDDA | Poetic Edda, Havamal (Runatal) | stanza 139 | I ween that I hung on the windy tree, / Hung there for nights full nine; / With the spear I was wounded, and offered I was / To Othin, myself to myself, / On the tree that none may ever know / What root beneath it runs. | Henry Adams Bellows | 1923 | https://en.wikisource.org/wiki/The_Poetic_Edda_(tr._Bellows)/Hovamol | primary-verbatim | Odin's self-sacrifice on the windy tree (Yggdrasil) to win the runes — the central myth of his wisdom-acquisition. | 2026-06-17 | verbatim web-retrieval from public-domain edition (Wikisource) | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);