Table Formula List - warwickfoster/qurantools GitHub Wiki
The formula-list table contains a comprehensive catalog of repeated phrases or formulae in the Qur'an. It captures patterns of words or phrases that recur throughout the text and provides details on their frequency, position, and context. This table is essential for identifying formulaic structures used in linguistic, thematic, and rhetorical analyses of the Qur'an.
Analysis of the formula-list Table
Below is the detailed description of each field in the formula-list table, including the table name as a left-hand column in every row.
| Table Name | Field Name | Description |
|---|---|---|
formula-list |
FORMID |
A unique identifier for each formula entry in the table, used as a primary key for indexing and referencing. |
formula-list |
FORMULA |
The original concatenated sequence of roots or elements that constitute the formula, separated by +. |
formula-list |
FORMULA LOWER |
A lowercase version of the FORMULA field, ensuring consistency for case-insensitive analysis and comparisons. |
formula-list |
FORMULA TRANSLITERATED |
The formula represented in Roman script for transliteration, aiding phonetic analysis and accessibility for non-Arabic readers. |
formula-list |
FORMULA ARABIC |
The Arabic script representation of the formula, providing the original textual form. |
formula-list |
START SURA |
The sura (chapter) number in the Quran where the formula begins. |
formula-list |
START VERSE |
The verse number in the starting sura where the formula begins. |
formula-list |
START WORD |
The position of the first word in the formula within the starting verse. |
formula-list |
END VERSE |
The verse number where the formula concludes. |
formula-list |
START-SURA-VERSE |
A compound identifier combining the sura and verse numbers (e.g., 2:3), marking the formula's starting location in the Quran. |
formula-list |
END-SURA-VERSE |
A compound identifier combining the sura and verse numbers (e.g., 2:4), marking the formula's ending location in the Quran. |
formula-list |
FORMULA PROVENANCE |
Specifies the historical or contextual classification of the formula, such as Meccan or Medinan, based on the sura's origin. |
formula-list |
LENGTH |
The number of root elements or words that make up the formula. |
formula-list |
TYPE |
The classification of the formula, often denoting the linguistic focus, such as ROOT (based on root patterns). |
formula-list |
START RECORD |
The record number in the database where the formula begins, used for indexing and referencing within the data. |
formula-list |
END RECORD |
The record number in the database where the formula ends. |
formula-list |
START GLOBAL WORD NUMBER |
A sequential number representing the starting word of the formula across the entire Quran. |
formula-list |
END GLOBAL WORD NUMBER |
A sequential number representing the ending word of the formula across the entire Quran. |
formula-list |
OCCURRENCES |
The total number of times the formula appears in the Quran. |
formula-list |
OCCURRENCES MECCAN |
The number of times the formula appears in Meccan suras. |
formula-list |
OCCURRENCES MEDINAN |
The number of times the formula appears in Medinan suras. |
formula-list |
Element1 |
The first root or element of the formula. |
formula-list |
Element2 |
The second root or element of the formula. |
formula-list |
Element3 |
The third root or element of the formula. |
formula-list |
Element4 |
The fourth root or element of the formula. |
formula-list |
Element5 |
The fifth root or element of the formula, if applicable. |
formula-list |
VERSE LIST |
A semicolon-separated list of sura-verse pairs (e.g., 1:1; 2:3) where the formula occurs. |
formula-list |
APPEARS IN HOW MANY SURAS |
The number of unique suras in which the formula appears. |
formula-list |
CONCAT OF FORMULA AND TYPE |
A concatenated string combining the formula and its type for quick identification and categorization (e.g., smw+Alh+rHm+rHm-ROOT). |
formula-list |
FORMULA ARCHETYPE ID |
Links the formula to a specific archetype or template ID, grouping formulas into broader linguistic or thematic categories. |
formula-list |
FORMULA FULL GLOSS |
A detailed explanation or interpretation of the formula, providing its semantic or contextual meaning. |
Key Insights
- Formula Structure:
- Fields like
FORMULA,FORMULA TRANSLITERATED, andFORMULA ARABICdefine the formula in its original, phonetic, and Arabic forms.
- Fields like
- Occurrences and Context:
OCCURRENCES,OCCURRENCES MECCAN, andOCCURRENCES MEDINANprovide quantitative context for the formulaโs usage in different Quranic periods.
- Element Decomposition:
Element1toElement5break down the formula into individual components for detailed linguistic analysis.
- Localization:
START-SURA-VERSEandEND-SURA-VERSElocalize the formula within the Quran, whileVERSE LISTmaps all its occurrences.
- Archetypes and Glosses:
FORMULA ARCHETYPE IDandFORMULA FULL GLOSSenrich the analysis by linking formulas to archetypes and providing their interpretive meanings.
First 10 Rows Example
| FORMID | FORMULA | FORMULA LOWER | FORMULA TRANSLITERATED | FORMULA ARABIC | START SURA | START VERSE | START WORD | END VERSE | START-SURA-VERSE | END-SURA-VERSE | FORMULA PROVENANCE | LENGTH | TYPE | START RECORD | END RECORD | START GLOBAL WORD NUMBER | END GLOBAL WORD NUMBER | OCCURRENCES | OCCURRENCES MECCAN | OCCURRENCES MEDINAN | Element1 | Element2 | Element3 | Element4 | Element5 | VERSE LIST | APPEARS IN HOW MANY SURAS | CONCAT OF FORMULA AND TYPE | FORMULA ARCHETYPE ID | FORMULA FULL GLOSS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | smw+Alh+rHm+rHm | smw+alh+rhm+rhm | smw + 'lh + r?m + r?m | ุณู ู + ุงูู + ุฑุญู + ุฑุญู | 1 | 1 | 1 | 1 | 1:1 | 1:1 | Meccan | 4 | ROOT | 2 | 7 | 1 | 4 | 2 | 2 | 0 | smw | Alh | rHm | rHm | nan | 1:1; 27:30 | 2 | smw+Alh+rHm+rHm-ROOT | 1 | nan |
| 2 | Hmd+Alh+rbb+Elm | hmd+alh+rbb+elm | ?md + 'lh + rbb + ?lm | ุญู ุฏ + ุงูู + ุฑุจุจ + ุนูู | 1 | 2 | 1 | 2 | 1:2 | 1:2 | Meccan | 4 | ROOT | 9 | 14 | 5 | 8 | 6 | 6 | 0 | Hmd | Alh | rbb | Elm | nan | 1:2; 6:45; 10:10; 37:182; 39:75; 40:65 | 6 | Hmd+Alh+rbb+Elm-ROOT | 2 | nan |
| 3 | hdy+SrT+qwm+SrT | hdy+srt+qwm+srt | hdy + ?r? + qwm + ?r? | ูุฏู + ุตุฑุท + ููู + ุตุฑุท | 1 | 6 | 1 | 7 | 1:6 | 1:7 | Meccan | 4 | ROOT | 28 | 34 | 18 | 21 | 2 | 2 | 0 | hdy | SrT | qwm | SrT | nan | 1:6; 42:52 | 2 | hdy+SrT+qwm+SrT-ROOT | 3 | nan |
| 4 | qwm+Slw+rzq+nfq | qwm+slw+rzq+nfq | qwm + ?lw + rzq + nfq | ููู + ุตูู + ุฑุฒู + ููู | 2 | 3 | 4 | 3 | 2:3 | 2:3 | Medinan | 4 | ROOT | 68 | 78 | 41 | 45 | 3 | 0 | 3 | qwm | Slw | rzq | nfq | nan | 2:3; 8:3; 22:35 | 3 | qwm+Slw+rzq+nfq-ROOT | 4 | nan |
| 5 | Slw+rzq+nfq+Amn | slw+rzq+nfq+amn | ?lw + rzq + nfq + 'mn | ุตูู + ุฑุฒู + ููู + ุงู ู | 2 | 3 | 5 | 4 | 2:3 | 2:4 | Medinan | 4 | ROOT | 71 | 82 | 42 | 47 | 2 | 0 | 2 | Slw | rzq | nfq | Amn | nan | 2:3; 8:3 | 2 | Slw+rzq+nfq+Amn-ROOT | 5 | nan |
| 6 | Amn+nzl+nzl+qbl | amn+nzl+nzl+qbl | 'mn + nzl + nzl + qbl | ุงู ู + ูุฒู + ูุฒู + ูุจู | 2 | 4 | 2 | 4 | 2:4 | 2:4 | Medinan | 4 | ROOT | 82 | 93 | 47 | 54 | 3 | 0 | 3 | Amn | nzl | nzl | qbl | nan | 2:4; 4:60; 4:162 | 2 | Amn+nzl+nzl+qbl-ROOT | 6 | nan |
| 7 | Axr+yqn+hdy+rbb | axr+yqn+hdy+rbb | 'xr + yqn + hdy + rbb | ุงุฎุฑ + ููู + ูุฏู + ุฑุจุจ | 2 | 4 | 10 | 5 | 2:4 | 2:5 | Medinan | 4 | ROOT | 98 | 106 | 55 | 62 | 2 | 1 | 1 | Axr | yqn | hdy | rbb | nan | 2:4; 31:4 | 2 | Axr+yqn+hdy+rbb-ROOT | 7 | nan |
| 8 | yqn+hdy+rbb+flH | yqn+hdy+rbb+flh | yqn + hdy + rbb + fl? | ููู + ูุฏู + ุฑุจุจ + ููุญ | 2 | 4 | 12 | 5 | 2:4 | 2:5 | Medinan | 4 | ROOT | 100 | 112 | 57 | 65 | 2 | 1 | 1 | yqn | hdy | rbb | flH | nan | 2:4; 31:4 | 2 | yqn+hdy+rbb+flH-ROOT | 8 | nan |
| 9 | swy+nr+nr+Amn | swy+nr+nr+amn | swy + ndhr + ndhr + 'mn | ุณูู + ูุฐุฑ + ูุฐุฑ + ุงู ู | 2 | 6 | 4 | 6 | 2:6 | 2:6 | Medinan | 4 | ROOT | 117 | 129 | 69 | 76 | 2 | 1 | 1 | swy | n*r | n*r | Amn | nan | 2:6; 36:10 | 2 | swy+nr+nr+Amn-ROOT | 9 | nan |
| 10 | Alh+qlb+smE+bSr | alh+qlb+sme+bsr | 'lh + qlb + sm? + b?r | ุงูู + ููุจ + ุณู ุน + ุจุตุฑ | 2 | 7 | 2 | 7 | 2:7 | 2:7 | Medinan | 4 | ROOT | 132 | 142 | 78 | 84 | 2 | 1 | 1 | Alh | qlb | smE | bSr | nan | 2:7; 16:108 | 2 | Alh+qlb+smE+bSr-ROOT | 10 | nan |