entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_NOR_SJOFN"

✎ 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_NOR_SJOFN_EDDA Sjöfn ENT_NOR_SJOFN Snorri Sturluson, Prose Edda SRC_PROSE_EDDA Snorri Sturluson, Prose Edda (Gylfaginning) Gylfaginning The goddess is Sjofn, who is fond of turning men’s and women’s hearts to love, and it is from her name that love is called Sjafne. Rasmus B. Anderson 1880 https://www.gutenberg.org/ebooks/18947 primary-verbatim   2026-06-26 name + substring gate against Snorri Sturluson, Prose Edda (Gylfaginning) 1 1 Named in Snorri Sturluson, Prose Edda (Gylfaginning); verify.  

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