deitydb: entity_citations: 2 rows where entity_id = "ENT_ISL

Data license: MIT · Data source: jebboone/deitydb

2 rows where entity_id = "ENT_ISL_FATIMA"

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_FATIMA_QUR	Fatima al-Zahra ENT_ISL_FATIMA	Qur’an SRC_QURAN	The Qur’an	Surah 33:33	And stay in your houses. Bedizen not yourselves with the bedizenment of the Time of Ignorance. Be regular in prayer, and pay the poor-due, and obey Allah and His messenger. Allah's wish is but to remove uncleanness far from you, O Folk of the Household, and cleanse you with a thorough cleansing.	Marmaduke Pickthall	1930	https://tanzil.net/#33:33	primary-verbatim	English (Pickthall); sura:ayah is translation-independent — consult the Arabic (linked).	2026-06-18	deterministic sura:ayah lookup, or name-anchored where no ayah given (Pickthall, Tanzil)	1	0		https://quran.com/33/33
CIT_ISL_FATIMA_QURAN	Fatima al-Zahra ENT_ISL_FATIMA	Qur’an SRC_QURAN	The Qur’an	Quran 33:33	leaving only Fatima. 26 This may refer to the charge of adultery said by the Rabbins to have been brought by Korah against Moses. Comp. Tr. Sanhedrin, fol. 110a. and Numbers xii. 1. The verse is said to have been revealed on account of aspersions thrown on Muhammad for unfairly dividing spoils, whereupon he said, "God be merciful to my brother Moses.	J. M. Rodwell	1861	https://www.gutenberg.org/ebooks/2800	primary-verbatim		2026-06-18	name-anchored (note-keyword scored) + substring gate; locus per attestation	1	1	English translation (Rodwell, chronological sura order) located by name; the cited sura:ayah is the standard reference — consult the Arabic (linked).	https://quran.com/

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