entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_NOR_SIGYN"
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_SIGYN_PROSE_ | Sigyn ENT_NOR_SIGYN | Snorri Sturluson, Prose Edda SRC_PROSE_EDDA | Snorri Sturluson, Prose Edda | Snorri Sturluson, Prose Edda | But Sigyn, his wife, stands by him, and holds a dish under the venom-drops. Whenever the dish becomes full, she goes and pours away the venom, and meanwhile the venom drops onto Loke's face. Then he twists his body so violently that the whole earth shakes, and this you call earthquakes. There he will lie bound until Ragnarok. CHAPTER XVI. RAGNAROK. 55. Then said Ganglere: What tidings are to be told of Ragnarok? Of this I have never heard before. | 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]);