entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_NORR_SVARTALFHEIM"

✎ View and edit SQL

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_NORR_SVARTALFHEIM_PROSE_ Svartalfheim (Svartálfaheimr) / Nidavellir ENT_NORR_SVARTALFHEIM Snorri Sturluson, Prose Edda SRC_PROSE_EDDA Snorri Sturluson, Prose Edda (Faulkes) Snorri Sturluson, Prose Edda (Faulkes) So Alfather sent the youth, who is called Skirner, and is Frey's messenger, to some dwarfs in Svartalfheim, and had them make the fetter which is called Gleipner. It was made of six things: of the footfalls of cats, of the beard of women, of the roots of the mountain, of the sinews of the bear, of the breath of the fish, and of the spittle of the birds. 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

CSV options: 

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]);