deitydb: entity_citations: 1 row where entity_id = "ENT

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_ADIKIA"

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_ADIKIA_PAUSAN	Adikia ENT_ADIKIA	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	Pausanias, Description of Greece	And there is a comely woman dragging along an ugly one, with one hand holding her fast, and with the other beating her with a rod, this is Justice punishing Injustice. And there are two women pounding with pestles into mortars, apparently compounding drugs, but there is no inscription in reference to them.	A. R. Shilleto	1886	https://www.gutenberg.org/ebooks/68946	primary-verbatim		2026-06-18	name-anchored (note-keyword scored) + substring gate; locus per attestation	1	1	English translation (A. R. Shilleto, Bohn ed., Gutenberg #68946/#68680) located by name; verify book.chapter.	https://www.perseus.tufts.edu/hopper/text?doc=Perseus:text:1999.01.0159

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