entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_NOR_SUTTUNGR"
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_SUTTUNGR_PROSE_ | Suttungr ENT_NOR_SUTTUNGR | Snorri Sturluson, Prose Edda SRC_PROSE_EDDA | Snorri Sturluson, Prose Edda (Faulkes) | Snorri Sturluson, Prose Edda (Faulkes) | When the giant Suttung, the son of Gilling, found this out he came and seized the dwarfs, took them out to sea and left them on a rocky island, which was flooded at high tide. They prayed Suttung to spare their lives, and offered him in atonement for their father's blood the precious mead, which he accepted. Suttung brought the mead home with him, and hid it in a place called Hnitbjorg. He set his daughter Gunlad to guard it. | Anthony Faulkes | 1987 | 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 section. |
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]);