grace law ratios in the bible

 

Bible books where law is mentioned more than grace

select * from (select book, count (*) filter (where verse ~* '\ylaw\y') as law_count, count(*) filter (where verse ~* '\ygrace\y') as grace_count, count (*) filter (where verse ~* '\yworks\y') as works_count, count (*) filter (where verse ~* '\yjustification\y') as justification_count, count(*) filter (where verse ~* '\yjusti') as justi_count, count(*) filter (where verse ~* '\ysancti') as sancti_count, count(*) filter (where verse ~* 'perfect') as perfect_count, booknumber from bibles group by book, booknumber order by law_count desc) where law_count > grace_count order by law_count desc;40 rows

book	law_count	grace_count	works_count	justification_count	justi_count	sancti_count	perfect_count	booknumber
Rom	52	20	8	3	16	1	1	45
Psa	37	2	54	0	5	0	12	19
Gal	25	7	5	0	6	0	1	48
Deu	24	0	4	0	2	3	3	5
Acts	21	10	5	0	1	2	6	44
Neh	21	0	2	0	0	3	0	16
Lev	18	0	0	0	0	22	1	3
Exo	18	5	5	0	1	17	0	2
Ruth	17	2	0	0	0	0	0	8
2Chr	17	0	3	0	2	15	7	14
John	14	3	16	0	0	3	1	43
Prv	13	5	5	0	4	0	3	20
Jer	12	1	8	0	5	1	1	24
Heb	12	7	9	0	0	6	12	58
2Ki	11	0	1	0	0	0	1	12
1Cor	11	6	0	0	2	4	3	46
Isa	11	0	6	0	12	5	5	23
Luke	11	1	2	0	5	0	4	42
Mat	10	0	12	0	2	2	4	40
Num	10	1	1	0	0	6	0	4
1Sm	9	3	2	0	0	3	1	9
Ezra	8	1	0	0	0	0	1	15
Josh	8	0	1	0	0	2	0	6
Jas	7	2	10	0	3	0	5	59
Jdgs	7	1	2	0	0	0	0	7
Dan	6	0	2	0	0	0	0	27
Mal	5	0	0	0	0	0	0	39
Est	5	1	0	0	0	0	0	17
Eze	4	0	1	0	3	12	6	26
1Chr	4	0	4	0	1	3	4	13
Hos	3	0	0	0	0	0	0	28
Mic	2	0	1	0	0	0	0	33
Hab	1	0	0	0	0	0	0	35
Hag	1	0	0	0	0	0	0	37
1Ki	1	0	2	0	2	0	4	11
Lam	1	0	0	0	0	0	1	25
Zep	1	0	0	0	0	0	0	36
Job	1	0	3	0	10	1	13	18
Amos	1	0	1	0	0	0	0	30
1Jn	1	0	2	0	0	0	4	62

Bible books where grace is mentioned more than law

select * from (select book, count(*) filter (where verse ~* '\ygrace\y') as grace_count, count (*) filter (where verse ~* '\ylaw\y') as law_count, count (*) filter (where verse ~* '\yworks\y') as works_count, count (*) filter (where verse ~* '\yjustification\y') as justification_count, count(*) filter (where verse ~* '\yjusti') as justi_count, count(*) filter (where verse ~* '\ysancti') as sancti_count, count(*) filter (where verse ~* 'perfect') as perfect_count, booknumber from bibles group by book, booknumber order by law_count desc) where law_count <= grace_count order by law_count desc;26 rows

book	grace_count	law_count	works_count	justification_count	justi_count	sancti_count	perfect_count	booknumber
Gen	11	9	0	0	1	1	2	1
Phi	3	3	0	0	0	0	2	50
1Tim	3	3	4	0	1	1	0	54
Eph	12	1	3	0	0	1	2	49
Zec	2	1	0	0	0	0	0	38
Titus	4	1	6	0	1	0	0	56
Jonah	0	0	1	0	0	0	0	32
Mark	0	0	2	0	0	0	0	41
Rev	2	0	17	0	0	0	1	66
1Pet	8	0	1	0	0	2	1	60
1Th	2	0	0	0	0	3	2	52
SSol	0	0	0	0	0	0	0	22
Col	5	0	1	0	0	0	3	51
2Tim	4	0	3	0	0	1	1	55
2Pet	2	0	1	0	0	0	0	61
Eccl	0	0	7	0	1	0	0	21
2Jn	1	0	0	0	0	0	0	63
Joel	0	0	0	0	0	3	0	29
3Jn	0	0	0	0	0	0	0	64
2Cor	13	0	1	0	0	0	4	47
Obad	0	0	0	0	0	0	0	31
2Sm	2	0	0	0	2	0	2	10
Nahum	0	0	0	0	0	0	0	34
2Th	4	0	0	0	0	1	0	53
Phmn	2	0	0	0	0	0	0	57
Jude	1	0	0	0	0	1	0	65

Bible books where (grace|faith|believe|favor|gift|bless|kind|lov|goodwill|strength|power|trust|confidence|assurance|convict|depende|accept) are mentioned more than (law|command|shalt|do|statute|judgement|testimon|precept|word|way|ordinance|charge|decree|bid|behest|must|will|ought|hast|mayest|canst|dost|required|obligate|keep|observe|obey|hearken|walk\ in|submit|doers)

select * from (select book, count(*) filter (where verse ~* '(grace|faith|believe|favor|gift|bless|kind|lov|goodwill|strength|power|trust|confidence|assurance|convict|depende|accept)') as grace_count, count (*) filter (where verse ~* '(law|command|shalt|do|statute|judgement|testimon|precept|word|way|ordinance|charge|decree|bid|behest|must|will|ought|hast|mayest|canst|dost|required|obligate|keep|observe|obey|hearken|walk\ in|submit|doers)') as law_count, booknumber from bibles group by book, booknumber ) where law_count <= grace_count order by law_count desc;4 rows

book	grace_count	law_count	booknumber
SSol	55	46	22
Eph	45	43	49
Titus	15	15	56
Phmn	11	6	57

Bible books where (law|command|shalt|do|statute|judgement|testimon|precept|word|way|ordinance|charge|decree|bid|behest|must|will|ought|hast|mayest|canst|dost|required|obligate|keep|observe|obey|hearken|walk\ in|submit|doers) are mentioned more than (grace|faith|believe|favor|gift|bless|kind|lov|goodwill|strength|power|trust|confidence|assurance|convict|depende|accept)

select * from (select book, count(*) filter (where verse ~* '(grace|faith|believe|favor|gift|bless|kind|lov|goodwill|strength|power|trust|confidence|assurance|convict|depende|accept)') as grace_count, count (*) filter (where verse ~* '(law|command|shalt|do|statute|judgement|testimon|precept|word|way|ordinance|charge|decree|bid|behest|must|will|ought|hast|mayest|canst|dost|required|obligate|keep|observe|obey|hearken|walk\ in|submit|doers)') as law_count, booknumber from bibles group by book, booknumber ) where law_count >= grace_count order by law_count desc;63 rows

book	grace_count	law_count	booknumber
Psa	348	1038	19
Jer	69	844	24
Eze	48	746	26
Isa	109	660	23
Exo	37	613	2
Deu	94	597	5
Gen	133	584	1
Luke	105	482	42
Mat	77	452	40
Acts	93	432	44
Num	34	428	4
Job	71	424	18
1Sm	44	388	9
1Ki	19	377	11
2Chr	48	360	14
Prv	97	358	20
John	134	334	43
2Ki	21	332	12
Lev	34	326	3
2Sm	43	312	10
Mark	47	275	41
Jdgs	27	273	7
Josh	20	231	6
1Chr	25	215	13
Dan	43	192	27
Rom	119	162	45
1Cor	76	153	46
Rev	64	141	66
Neh	17	138	16
Heb	75	122	58
Hos	29	116	28
Eccl	19	101	21
Zec	12	95	38
Amos	8	87	30
2Cor	63	86	47
Est	12	85	17
Ezra	7	84	15
Mic	6	64	33
Lam	8	62	25
1Tim	38	52	54
Jas	27	52	59
Gal	33	49	48
Ruth	12	44	8
1Jn	36	42	62
2Tim	25	41	55
1Pet	29	40	60
Mal	8	38	39
Zep	3	37	36
Col	23	35	51
Joel	4	33	29
1Th	21	31	52
2Pet	15	30	61
Phi	23	30	50
Nahum	5	26	34
Jonah	2	25	32
2Th	19	22	53
Hag	2	22	37
Hab	7	21	35
Titus	15	15	56
Obad	1	12	31
Jude	8	9	65
3Jn	6	8	64
2Jn	5	7	63