entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_FIN_KALEVATAR"

✎ 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_KALEVATAR_KAL Kalevatar ENT_FIN_KALEVATAR 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 Kalevala That the beer may foam and sparkle, May ferment and be delightful?’ “Kalevatar, magic maiden, Grace and beauty in her fingers, Swiftly moving, lightly stepping, In her trimly-buckled sandals, Steps upon the birch-wood bottom, Tu John Martin Crawford 1888 https://www.gutenberg.org/ebooks/5186 primary-verbatim   2026-06-26 name + substring gate against Crawford Kalevala verse (#5186) 1 1 Named in the Kalevala (Crawford); verify rune.  

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