deitydb: entity_citations: 1 row where entity_id = "ENT

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_AEACUS"

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_AEACUS_HOMER	Aeacus ENT_AEACUS	Homer, Iliad and Odyssey (c. 750-675 BCE); trans. Richmond Lattimore (Iliad, Univ. of Chicago 1951) and trans. Emily Wilson (Odyssey, Norton 2017) SRC_HOMER_ILIAD_ODYSSEY	Iliad	Iliad XXI.189); he is mentioned as a son	My father is Peleus, son of Aeacus ruler over the many Myrmidons, and Aeacus was the son of Jove. Therefore as Jove is mightier than any river that flows into the sea, so are his children stronger than those of any river whatsoever.	Samuel Butler	1898	https://www.gutenberg.org/ebooks/2199	primary-verbatim		2026-06-17	quote is a verbatim substring of the PD text; located within the cited book by name-anchor + substring gate	1	1	English prose translation auto-located within the cited Book by name-match; the locus is the Greek line-numbering — consult the original (linked).	https://www.perseus.tufts.edu/hopper/text?doc=Perseus:text:1999.01.0133

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