deitydb: entity_citations: 1 row where entity_id = "ENT_MES

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_MES_NINKASI"

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_MES_NINKASI_ETCSL	Ninkasi ENT_MES_NINKASI	Electronic Text Corpus of Sumerian Literature SRC_ETCSL	Electronic Text Corpus of Sumerian Literature (ETCSL)	ETCSL 4.23.1	the beer dough has been carefully prepared in the oven, and the mash tended in the oven, Ninkasi the goddess of beer mixes them for me while your big billy-goats and rams are despatched for my banquets. On their thick legs they are made to stand separate from my produce. Your shepherd on the high plain eyes my produce enviously; when I am standing in stalks in the field, my farmer chases away your herdsman with his cudgel.	Black, Cunningham, Robson, Zólyomi et al.	2006	https://etcsl.orinst.ox.ac.uk/	primary-verbatim		2026-06-18	name-anchored (note-keyword scored) + substring gate; locus per attestation	1	1	Located by name in the ETCSL translations; verify the composition (c.x.x) reference.

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