entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_NOR_FJALAR_DWARF"

✎ 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_FJALAR_DWARF_PROSE_ Fjalar ENT_NOR_FJALAR_DWARF Snorri Sturluson, Prose Edda SRC_PROSE_EDDA Snorri Sturluson, Prose Edda Snorri Sturluson, Prose Edda Once he came to the home of the dwarfs Fjalar and Galar. They called him aside, saying they wished to speak with him alone, slew him and let his blood run into two jars called Son and Bodn, and into a kettle called Odrarer. They mixed honey with the blood, and thus was produced such mead that whoever drinks from it becomes a skald and sage. 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

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