entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_SAINT_JAMES_GREATER"

✎ 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_SAINT_JAMES_GREATER_GOLDEN James the Greater ENT_SAINT_JAMES_GREATER Jacobus de Voragine, Golden Legend SRC_GOLDEN_LEGEND The Golden Legend (Caxton) The Golden Legend (Caxton) he called James and John, which were in another Aodrew ship, and they followed him, and after went into their proper places. After this he called them from their fishing, and said : Come, follow me, I shall make you fishers of men. Then they left their ships and nets, and followed him, and sifter this they abode with him, and went no more to their own houses. William Caxton 1483 https://archive.org/details/TheGoldenLegendV1 primary-verbatim   2026-06-18 name-anchored (note-keyword scored) + substring gate; locus per attestation 1 1 OCR scan of Caxtons Golden Legend, located by name; verify the saint.  

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