entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_FINN_LEMMINKAINEN"

✎ 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_FINN_LEMMINKAINEN_KALEVA Lemminkäinen ENT_FINN_LEMMINKAINEN Elias Lönnrot, The Kalevala (Kalevala taikka vanhoja Karjalan runoja Suomen kansan muinosista ajoista), expanded edition 1849; trans. Keith Bosley (Oxford World's Classics, Oxford University Press, 1989) SRC_KALEVALA The Kalevala The Kalevala "Yonder is thy golden infant, There thy holy babe lies sleeping, Hidden to his belt in water, Hidden in the reeds and rushes." Again when the devoted mother of the reckless hero, Lemminkainen, (chopped to pieces by the Sons Of Mana, as in the myth of Osiris) was raking together the fragments of his body from the river of Tuoni, and fearing that the sprites of the Death-stream might resent her intrusion, the Sun, in answer to h John Martin Crawford 1888 https://www.gutenberg.org/ebooks/5186 primary-verbatim   2026-06-18 name-anchored (note-keyword scored) + substring gate; locus per attestation 1 1 English translation located by name within the work (not exact rune); 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]);