The Quran Dataset

Entire Quran with English Translation. All the Ayats in Arabic and English.

@kaggle.imrankhan197_the_quran_dataset

Table List

1 table(1.67 MB)

The Quran Dataset

@kaggle.imrankhan197_the_quran_dataset.the_quran_dataset

1.67 MB
6236 rows
19 columns

surah_no Surah No	surah_name_en Surah Name En	surah_name_ar Surah Name Ar	surah_name_roman Surah Name Roman	ayah_no_surah Ayah No Surah	ayah_no_quran Ayah No Quran	ayah_ar Ayah Ar	ayah_en Ayah En	ruko_no Ruko No	juz_no Juz No	manzil_no Manzil No	hizb_quarter Hizb Quarter	total_ayah_surah Total Ayah Surah	total_ayah_quran Total Ayah Quran	place_of_revelation Place Of Revelation	no_of_word_ayah No Of Word Ayah	list_of_words List Of Words
1	The Opener	الفاتحة	Al-Fatihah	1	1	بِسْمِ ٱللَّهِ ٱلرَّحْمَٰنِ ٱلرَّحِيمِ	In the Name of Allah—the Most Compassionate, Most Merciful.	1	1	1	1	7	6236	Meccan	4	[بِسْمِ,ٱللَّهِ,ٱلرَّحْمَٰنِ,ٱلرَّحِيمِ]
1	The Opener	الفاتحة	Al-Fatihah	2	2	ٱلْحَمْدُ لِلَّهِ رَبِّ ٱلْعَٰلَمِينَ	All praise is for Allah—Lord of all worlds,	1	1	1	1	7	6236	Meccan	4	[ٱلْحَمْدُ,لِلَّهِ,رَبِّ,ٱلْعَٰلَمِينَ]
1	The Opener	الفاتحة	Al-Fatihah	3	3	ٱلرَّحْمَٰنِ ٱلرَّحِيمِ	the Most Compassionate, Most Merciful,	1	1	1	1	7	6236	Meccan	2	[ٱلرَّحْمَٰنِ,ٱلرَّحِيمِ]
1	The Opener	الفاتحة	Al-Fatihah	4	4	مَٰلِكِ يَوْمِ ٱلدِّينِ	Master of the Day of Judgment.	1	1	1	1	7	6236	Meccan	3	[مَٰلِكِ,يَوْمِ,ٱلدِّينِ]
1	The Opener	الفاتحة	Al-Fatihah	5	5	إِيَّاكَ نَعْبُدُ وَإِيَّاكَ نَسْتَعِينُ	You ˹alone˺ we worship and You ˹alone˺ we ask for help.	1	1	1	1	7	6236	Meccan	4	[إِيَّاكَ,نَعْبُدُ,وَإِيَّاكَ,نَسْتَعِينُ]
1	The Opener	الفاتحة	Al-Fatihah	6	6	ٱهْدِنَا ٱلصِّرَٰطَ ٱلْمُسْتَقِيمَ	Guide us along the Straight Path,	1	1	1	1	7	6236	Meccan	3	[ٱهْدِنَا,ٱلصِّرَٰطَ,ٱلْمُسْتَقِيمَ]
1	The Opener	الفاتحة	Al-Fatihah	7	7	صِرَٰطَ ٱلَّذِينَ أَنْعَمْتَ عَلَيْهِمْ غَيْرِ ٱلْمَغْضُوبِ عَلَيْهِمْ وَلَا ٱلضَّآلِّينَ	the Path of those You have blessed—not those You are displeased with, or those who are astray.	1	1	1	1	7	6236	Meccan	9	[صِرَٰطَ,ٱلَّذِينَ,أَنْعَمْتَ,عَلَيْهِمْ,غَيْرِ,ٱلْمَغْضُوبِ,عَلَيْهِمْ,وَلَا,ٱلضَّآلِّينَ]
2	The Cow	البقرة	Al-Baqarah	1	8	الٓمٓ	Alif-Lãm-Mĩm.	2	1	1	1	286	6236	Medinan	1	[الٓمٓ]
2	The Cow	البقرة	Al-Baqarah	2	9	ذَٰلِكَ ٱلْكِتَٰبُ لَا رَيْبَ ۛ فِيهِ ۛ هُدًۭى لِّلْمُتَّقِينَ	This is the Book! There is no doubt about it	2	1	1	1	286	6236	Medinan	9	[ذَٰلِكَ,ٱلْكِتَٰبُ,لَا,رَيْبَ,ۛ,فِيهِ,ۛ,هُدًۭى,لِّلْمُتَّقِينَ]
2	The Cow	البقرة	Al-Baqarah	3	10	ٱلَّذِينَ يُؤْمِنُونَ بِٱلْغَيْبِ وَيُقِيمُونَ ٱلصَّلَوٰةَ وَمِمَّا رَزَقْنَٰهُمْ يُنفِقُونَ	who believe in the unseen, establish prayer, and donate from what We have provided for them,	2	1	1	1	286	6236	Medinan	8	[ٱلَّذِينَ,يُؤْمِنُونَ,بِٱلْغَيْبِ,وَيُقِيمُونَ,ٱلصَّلَوٰةَ,وَمِمَّا,رَزَقْنَٰهُمْ,يُنفِقُونَ]


CREATE TABLE the_quran_dataset (
  "surah_no" BIGINT,
  "surah_name_en" VARCHAR,
  "surah_name_ar" VARCHAR,
  "surah_name_roman" VARCHAR,
  "ayah_no_surah" BIGINT,
  "ayah_no_quran" BIGINT,
  "ayah_ar" VARCHAR,
  "ayah_en" VARCHAR,
  "ruko_no" BIGINT,
  "juz_no" BIGINT,
  "manzil_no" BIGINT,
  "hizb_quarter" BIGINT,
  "total_ayah_surah" BIGINT,
  "total_ayah_quran" BIGINT,
  "place_of_revelation" VARCHAR,
  "sajah_ayah" BOOLEAN,
  "sajdah_no" DOUBLE,
  "no_of_word_ayah" BIGINT,
  "list_of_words" VARCHAR
);