entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_EMC_FRANCIS_BORGIA"

✎ 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_EMC_FRANCIS_BORGIA_SEC Francis Borgia ENT_EMC_FRANCIS_BORGIA Bibliotheca Sanctorum (Istituto Giovanni XXIII, Rome, 1961-1970) SRC_BIBLIOTHECA_SANCTORUM The Catholic Encyclopedia (Robert Appleton Co., 1913), s.v. Francis Borgia per cited source Francis Borgia, born 28 October, 1510, was the son of Juan Borgia, third Duke of Gandia.     https://en.wikisource.org/wiki/Catholic%20Encyclopedia%20%281913%29/St.%20Francis%20Borgia secondary   2026-06-26 secondary-scholarship excerpt; substring-gated against the 1913 Catholic Encyclopedia (Wikisource); figure verified against entry 2 1 Public-domain 1913 reference work (signed articles); dated perspective — brief attributed excerpt; verify against a current source.  

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