hello. so i think i got the database to work. i think i have all citations in the watchtower from about 1950 to around 2005, it run in at around 40'000 distinct bible citations which are cited a total of 600'000 times. which stats are we interested in exactly?
to answer DPLs question, for eg. matthew and genesis, this is what it looks like:
+---------+---------+------------+
| book | chapter | sum(count) |
+---------+---------+------------+
| genesis | 1 | 264 |
| genesis | 2 | 131 |
| genesis | 3 | 198 |
| genesis | 4 | 168 |
| genesis | 5 | 172 |
| genesis | 6 | 100 |
| genesis | 7 | 62 |
| genesis | 8 | 45 |
| genesis | 9 | 154 |
| genesis | 10 | 219 |
| genesis | 11 | 238 |
| genesis | 12 | 95 |
| genesis | 13 | 45 |
| genesis | 14 | 288 |
| genesis | 15 | 145 |
| genesis | 16 | 79 |
| genesis | 17 | 98 |
| genesis | 18 | 108 |
| genesis | 19 | 122 |
| genesis | 20 | 84 |
| genesis | 21 | 105 |
| genesis | 22 | 144 |
| genesis | 23 | 149 |
| genesis | 24 | 239 |
| genesis | 25 | 197 |
| genesis | 26 | 154 |
| genesis | 27 | 116 |
| genesis | 28 | 120 |
| genesis | 29 | 85 |
| genesis | 30 | 79 |
| genesis | 31 | 150 |
| genesis | 32 | 113 |
| genesis | 33 | 58 |
| genesis | 34 | 168 |
| genesis | 35 | 110 |
| genesis | 36 | 211 |
| genesis | 37 | 127 |
| genesis | 38 | 74 |
| genesis | 39 | 30 |
| genesis | 40 | 72 |
| genesis | 41 | 83 |
| genesis | 42 | 42 |
| genesis | 43 | 29 |
| genesis | 44 | 12 |
| genesis | 45 | 31 |
| genesis | 46 | 122 |
| genesis | 47 | 49 |
| genesis | 48 | 72 |
| genesis | 49 | 138 |
| genesis | 50 | 39 |
+---------+---------+------------+
while for matthew it is like this:
+---------+---------+------------+
| book | chapter | sum(count) |
+---------+---------+------------+
| matthew | 1 | 1297 |
| matthew | 2 | 1137 |
| matthew | 3 | 1090 |
| matthew | 4 | 2768 |
| matthew | 5 | 3453 |
| matthew | 6 | 4867 |
| matthew | 7 | 2209 |
| matthew | 8 | 579 |
| matthew | 9 | 1059 |
| matthew | 10 | 2785 |
| matthew | 11 | 1296 |
| matthew | 12 | 1526 |
| matthew | 13 | 3588 |
| matthew | 14 | 723 |
| matthew | 15 | 2024 |
| matthew | 16 | 1086 |
| matthew | 17 | 707 |
| matthew | 18 | 1580 |
| matthew | 19 | 1585 |
| matthew | 20 | 1101 |
| matthew | 21 | 1140 |
| matthew | 22 | 1932 |
| matthew | 23 | 3385 |
| matthew | 24 | 12765 |
| matthew | 25 | 5921 |
| matthew | 26 | 2311 |
| matthew | 27 | 995 |
| matthew | 28 | 2375 |
+---------+---------+------------+
notice that a lot of stuff hide between the numbers since i sum over verses -- for example, take matthew 28 in details: +---------+---------+------------+ | book | chapter | sum(count) | +---------+---------+------------+ | matthew | 28 | 26 | | matthew | 28 | 24 | | matthew | 28 | 24 | | matthew | 28 | 22 | | matthew | 28 | 20 | | matthew | 28 | 22 | | matthew | 28 | 20 | | matthew | 28 | 16 | | matthew | 28 | 27 | | matthew | 28 | 22 | | matthew | 28 | 10 | | matthew | 28 | 16 | | matthew | 28 | 16 | | matthew | 28 | 15 | | matthew | 28 | 15 | | matthew | 28 | 30 | | matthew | 28 | 27 | | matthew | 28 | 151 | | matthew | 28 | 1000 | | matthew | 28 | 872 | +---------+---------+------------+ what is seen here is basically 50 years of "lets read the entire bible" study articles and a lot of preaching!
