deitydb: entity_citations: 1 row where entity_id = "ENT_DAC

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_DAC_DERZELAS"

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_DAC_DERZELAS_HDT	Derzelas ENT_DAC_DERZELAS	Herodotus, Histories (c. 430 BCE) SRC_HERODOTUS_HISTORIES	Herodotus, Histories	Book 4.93	But before he came to the Ister he conquered first the Getai, who believe in immortality: for the Thracians who occupy Salmydessos and are settled above the cities of Apollonian and Mesambria, called the Kyrmianai 90 and the Nipsaioi, delivered themselves over to Dareios without fighting; but the Getai, who are the bravest and the most upright in their dealings of all the Thracians, having betaken themselves to obstinacy were forthwith subdued.	G. C. Macaulay	1890	https://www.gutenberg.org/ebooks/2707	primary-verbatim	Herodotus reports foreign cults via Greek interpretatio (a Greek observer, not an insider source).	2026-06-17	deterministic verbatim extraction by book.chapter + substring gate (Gutenberg #2707/#2456)	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]);