deitydb: entity_citations: 1 row where entity_id = "ENT

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_TROPHONIUS"

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_TROPHONIUS_PAUS	Trophonius ENT_TROPHONIUS	Pausanias, Description of Greece (c. 143-176 CE); trans. W.H.S. Jones (Loeb Classical Library, Harvard 1918-1935) SRC_PAUSANIAS_DESCRIPTION	Pausanias, Description of Greece	Book 9, ch. 39	The grove of Trophonius is at some distance from it. They say that Hercyna was playing there with Proserpine the daughter of Demeter, and unwittingly let a goose drop out of her hands, which flew into a hollow cave and hid under a stone, till Proserpine entered the cave and took it from under the stone: and water they say burst forth where Proserpine took up the stone, and the river was called for that reason Hercyna	A. R. Shilleto	1886	https://www.gutenberg.org/ebooks/68946	primary-verbatim		2026-06-17	book.chapter located + name-anchored in chapter + substring gate (Gutenberg #68946/#68680); section-level locus per attestation — audit pending	1	0

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