entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_FINN_ILMATAR"

✎ 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_ILMATAR_KALEVA Ilmatar ENT_FINN_ILMATAR 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 Runo 1 Often we find him, in the runes, refusing to heed the call of his people for help, as when Ilmatar, the daughter of the air, vainly invoked him to her aid, that Wainamoinen, already seven hundred years unborn, might be delivered. So also Wainamoinen beseeches Ukko in vain to check the crimson streamlet flowing from his knee wounded by an axe in the hands of Hisi. 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]);