deitydb: entity_citations: 2 rows where entity_id = "ENT

Data license: MIT · Data source: jebboone/deitydb

2 rows where entity_id = "ENT_PROTESILAUS"

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_PROTESILAUS_HOMER_	Protesilaus ENT_PROTESILAUS	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	Homer, Iliad	Homer, Iliad	Of these brave Protesilaus had been captain while he was yet alive, but he was now lying under the earth. He had left a wife behind him in Phylace to tear her cheeks in sorrow, and his house was only half finished, for he was slain by a Dardanian warrior while leaping foremost of the Achaeans upon the soil of Troy.	Samuel Butler	1898	https://www.gutenberg.org/ebooks/2199	primary-verbatim		2026-06-18	name-anchored (note-keyword scored) + substring gate; locus per attestation	1	1	English prose translation located by name; locus is the Greek line-numbering — consult the original.	https://www.perseus.tufts.edu/hopper/text?doc=Perseus:text:1999.01.0133
CIT_PROTESILAUS_PAUS	Protesilaus ENT_PROTESILAUS	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 1, ch. 34.2	I can mention others who were once men, who have honours paid to them as gods, and cities dedicated to them, as Eleus in the Chersonese to Protesilaus, and Lebadea in Bœotia to Trophonius: so Amphiaraus has a temple at Oropus, and a statue in white stone. And the altar has five divisions: one belongs to Hercules and Zeus and Paeonian Apollo, and another is dedicated to heroes and heroes' wives.	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]);