deitydb: entity_citations: 1 row where entity_id = "ENT_ROM

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_ROM_BUBONA"

descending

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_ROM_BUBONA_AUG	Bubona ENT_ROM_BUBONA	Augustine of Hippo, De Civitate Dei (413–426 CE) SRC_AUGUSTINE_CITY_OF_GOD	Augustine, City of God	City of God	from standing corn, Segetia, not _seges_; from apples, Pomona, not _pomum_; from oxen, Bubona, not _bos_. Sometimes, again, with no alteration of the word, just as the things themselves are named, so that the goddess who gives money is called Pecunia, and money is not thought to be itself a goddess: so of Virtus, who gives virtue; Honor, who gives honour; Concordia, who gives concord;	Marcus Dods	1871	https://www.gutenberg.org/ebooks/45304	primary-verbatim		2026-06-26	name + substring gate against Dods City of God (Gutenberg #45304)	1	1	Named by Augustine (from Varro); verify the book/chapter. Hostile-witness attestation.

Advanced export

JSON shape: default, array, newline-delimited, object

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