deitydb: entity_citations: 1 row where entity_id = "ENT_ISL

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_ISL_HAFSA"

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_ISL_HAFSA_IBNISH	Hafsa bint Umar ENT_ISL_HAFSA	Ibn Ishaq, Sirat Rasul Allah (the Life of the Messenger of God), c. 760 CE (recension of Ibn Hisham) SRC_IBN_ISHAQ_SIRA	Ibn Ishaq, The Life of Muhammad (Guillaume)	Ibn Ishaq, The Life of Muhammad (Guillaume)	Then he wed Hafsa; and Umm Habiba, as a compliment to Abyssinia; and Juwayriya from among the captives of the Banu Mustaliq; and Safiya from among the captives at Khaybar; and Maymuna, and Zaynab b. Khuzayma, who was called 'Mother of the Poor' because of her compassion and kindliness. With these eleven wives the apostle consummated his marriages. Two died before him, namely Khadija and Zaynab, but nine survived him.	A. Guillaume	1955	None	primary-verbatim		2026-06-18	name-anchored (note-keyword scored) + substring gate; locus per attestation	1	1	In-copyright translation — brief flagged excerpt; verify.

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