entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_NOR_MOTSOGNIR"
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_MOTSOGNIR_POETIC | Mótsognir ENT_NOR_MOTSOGNIR | Poetic Edda SRC_POETIC_EDDA | The Poetic Edda | The Poetic Edda | Then was Motsognir created greatest of all the dwarfs, and Durin second; there in man's likeness they created many dwarfs from earth, as Durin said. 11. Nyi and Nidi, Nordri and Sudri, Austri and Vestri, Althiof, Dvalin Nar and Nain, Niping, Dain, Bivor, Bavor, Bombur, Nori, An and Anar, Ai, Miodvitnir, 12. Veig and Gandalf, Vindalf, Thrain, Thekk and Thorin, Thror, Vitr, and Litr, Nur and Nyrad, Regin and Radsvid. Now of the dwarfs I have rightly told. | 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]);