entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_CHRR_NEW_JERUSALEM"

✎ 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_CHRR_NEW_JERUSALEM_AUGUST The New Jerusalem ENT_CHRR_NEW_JERUSALEM Augustine of Hippo, De Civitate Dei (413–426 CE) SRC_AUGUSTINE_CITY_OF_GOD Augustine, City of God Augustine, City of God nified, composed of holy angels and blessed spirits, the city of which the apostle says, "Jerusalem which is above is our eternal mother in heaven;" and in another place, "For ye are all the children of the light, and the children of the day; we are not of the night, nor of darkness." Yet in some respects we may appropriately speak of a morning and evening of this day also. Marcus Dods 1871 https://www.gutenberg.org/ebooks/45304 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; verify book.chapter 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]);