entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_ORTH_JOHN_KRONSTADT"

✎ 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_ORTH_JOHN_KRONSTADT_FARLEY John of Kronstadt ENT_ORTH_JOHN_KRONSTADT The Synaxarion (the Lives of the Saints of the Orthodox Church) SRC_SYNAXARION A Daily Calendar of Saints (Farley) A Daily Calendar of Saints (Farley) John of Kronstadt, the saint cried out, "Matrona, come here!" adding that she would be his heir and a pillar of Russia. Illness struck the young girl again at the age of seventeen, so that she was ever after unable to walk. She remained steadfast and patient throughout her life, quietly praying, receiving all the visitors who came to her, and foretelling the terrible fortunes which would befall her country at the hands of the Bolsheviks. Lawrence Farley 2018 None primary-verbatim   2026-06-18 name-anchored (note-keyword scored) + substring gate; locus per attestation 1 1 Located by name in an Orthodox synaxarion; brief flagged excerpt; verify the commemoration.  

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