deitydb: entity_citations: 1 row where entity_id = "ENT

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_THALLO"

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_THALLO_PAUS	Thallo ENT_THALLO	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. 35.1	And another Season the Athenians honour equally with Pandrosus, the Goddess they call Thallo. But having learnt so to do from Eteocles of Orchomenus we are accustomed now to pray to three Graces: and Angelion and Tectaeus who made a statue of Apollo at Delos have placed three Graces in his hand; and at Athens at the entrance to the Acropolis there are also three Graces, and near them they celebrate the mysteries whic	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]);