deitydb: entity_citations: 1 row where entity_id = "ENT_NORR

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_NORR_ASGARD"

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_ASGARD_PROSE_	Asgard (Ásgarðr) ENT_NORR_ASGARD	Snorri Sturluson, Prose Edda SRC_PROSE_EDDA	Snorri Sturluson, Prose Edda	Snorri Sturluson, Prose Edda	In the next place, the sons of Bor made for themselves in the middle of the world a burg, which is called Asgard, and which we call Troy. There dwelt the gods and their race, and thence were wrought many tidings and adventures, both on earth and in the sky. In Asgard is a place called Hlidskjalf, and when Odin seated himself there in the high-seat, he saw over the whole world, and what every man was doing, and he knew all things that he saw.	Rasmus B. Anderson	1880	https://www.gutenberg.org/ebooks/18947	primary-verbatim		2026-06-18	name-anchored (note-keyword scored) + substring gate; locus per attestation	1	1	English translation (Anderson, The Younger Edda) located by name within the work (not exact chapter); 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]);