deitydb: entity_citations: 1 row where entity_id = "ENT_NORR_NINE

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_NORR_NINE_WORLDS"

descending

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_NINE_WORLDS_POETIC	The Nine Worlds (Níu Heimar) ENT_NORR_NINE_WORLDS	Poetic Edda SRC_POETIC_EDDA	The Poetic Edda	The Poetic Edda	Nine feet will go Fiörgyn's son, bowed by the serpent, who feared no foe. All men will their homes forsake. 56. The sun darkens, earth in ocean sinks, fall from heaven the bright stars, fire's breath assails the all-nourishing tree, towering fire plays against heaven itself. 57. She sees arise, a second time, earth from ocean, beauteously green, waterfalls descending; the eagle flying over, which in the fell captures fish.	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

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