deitydb: entity_citations: 2 rows where entity_id = "ENT

Data license: MIT · Data source: jebboone/deitydb

2 rows where entity_id = "ENT_CERBERUS"

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_CERBERUS_GRIMAL	Cerberus ENT_CERBERUS	Pierre Grimal, The Concise Dictionary of Classical Mythology, ed. Stephen Kershaw, trans. A. R. Maxwell-Hyslop (Oxford: Blackwell, 1990) SRC_GRIMAL_CONCISE	Pierre Grimal, The Concise Dictionary of Classical Mythology, ed. Stephen Kershaw, trans. A. R. Maxwell-Hyslop (Oxford: Blackwell, 1990)	s.v. "Cerberus"	Cerberus (Κέρβερος) The dog of Hades. He watched over the realm of the dead and forbade living people to enter it, and prevented the dead from leaving it.				secondary	Grimal's entry on Cerberus.	2026-09-18	full-text extraction (pdftotext, two-column scan); headword entry located at line start and read to confirm the referent is THIS figure; brief attributed excerpt of the entry's opening definition (in-copyright dictionary); spans containing soft-hyphen line breaks, column bleed or inline page numbers were rejected; contiguous-substring gate passed	3	1	secondary dictionary entry; confirm the entry in the printed Grimal
CIT_CERBERUS_SEC	Cerberus ENT_CERBERUS	Homer, Iliad and Odyssey (c. 750-675 BCE); trans. Samuel Butler (Iliad 1898; Odyssey 1900; Project Gutenberg #2199/#1727) SRC_HOMER_ILIAD_ODYSSEY	Homer, Iliad and Odyssey (c. 750-675 BCE); trans. Richmond Lattimore (Iliad, Univ. of Chicago 1951) and trans. Emily Wilson (Odyssey, Norton 2017)	per cited source					primary-uncited			Track-2 formalization of the entity's existing source attestation (no verbatim quote — pointer + grade + flag)	2	1	Primary source identified but not yet quoted verbatim; the on-page summary is an editorial paraphrase pending verification against this text.

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