entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_NOR_MIMIR"
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_MIMIR_POETIC | Mimir ENT_NOR_MIMIR | Poetic Edda SRC_POETIC_EDDA | The Poetic Edda | The Poetic Edda | Odin then rides to Mimir's well and consults Mimir how he and his warriors ought to enter into action. The ash Yggdrasill begins to shake, nor is there anything in heaven or earth exempt from fear at that terrible hour. The Aesir and all the heroes of Valhalla arm themselves and speed forth to the field, led on by Odin, with his golden helm and resplendent cuirass, and his spear called Gungnir. | Benjamin Thorpe | 1866 | https://www.gutenberg.org/ebooks/14726 | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | English translation (Benjamin Thorpe, in the Norroena ed. Gutenberg #14726) located by name within the work (not exact stanza); verify locus. |
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]);