deitydb: entity_citations: 1 row where entity_id = "ENT_EGY

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_EGY_WEPWAWET"

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_EGY_WEPWAWET_PYRAMI	Wepwawet ENT_EGY_WEPWAWET	R. O. Faulkner, The Ancient Egyptian Pyramid Texts (Oxford University Press, 1969; repr. Aris & Phillips, 1998) SRC_FAULKNER_PYRAMID_TEXTS	The Ancient Egyptian Pyramid Texts (Faulkner)	Utterance 468	The Egyptian name is usually vocalized as Wepwawet. Pavilion-director (arp-zœ). Official in charge of the dining hall. Pe. See Buto. Pe's Seal-ring. See Seal-ring. Peace-Commander (wy-œtp). An epithet of Khnum. Pebble Mountain (enw, enwt). Mountain region in which the sun rises. Pelusium (snw). Town at the end of the easternmost Delta branch of the Nile in ancient times. Perception (sjae).	R. O. Faulkner	1969	None	primary-verbatim		2026-06-18	name-anchored (note-keyword scored) + substring gate; locus per attestation	1	1	In-copyright modern translation — brief excerpt for identification, located by name; verify Utterance against the edition.

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