deitydb: entity_citations: 1 row where entity_id = "ENT_NOR

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_NOR_VAFTHRUDNIR"

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_NOR_VAFTHRUDNIR_POETIC	Vafþrúðnir ENT_NOR_VAFTHRUDNIR	Poetic Edda SRC_POETIC_EDDA	The Poetic Edda	The Poetic Edda	Odin visits the Giant (Jotun) Vafthrudnir, for the purpose of proving his knowledge. They propose questions relative to the Cosmogony of the Northern creed, on the conditions that the baffled party forfeit his head. The Jotun incurs the penalty. _Odin_. 1. Counsel thou me now, Frigg! as I long to go Vafthrudnir to visit; great desire, I say, I have, in ancient lore with that all-wise Jotun to contend. _Frigg_. 2.	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]);