deitydb: entity_citations: 1 row where entity_id = "ENT_NOR

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_NOR_SKIRNIR"

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_SKIRNIR_POETIC	Skírnir ENT_NOR_SKIRNIR	Poetic Edda SRC_POETIC_EDDA	The Poetic Edda	The Poetic Edda	BINDING THE WOLF FENIR "After this, the gods despaired of ever being able to bind the wolf; wherefore All-father sent Skirnir, the messenger of Frey, into the country of the Dark Elves (Svartalfaheim) to engage certain dwarfs to make the fetter called Gleipnir. It was fashioned out of six things; to wit, the noise made by the footfall of a cat; the beards of women; the roots of stones; the sinews of bears; the breath of fish; and the spittle of birds.	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]);