Document History
Original Publish Date: 26th April, 2021
Updated on: 28 September, 2021
LOK SABHA QUESTION ANALYSIS
It contains 276129 questions from ls13 to ls16
Main variables
## [1] "V1" "Unnamed: 0" "ID"
## [4] "all_members" "ls_term" "case"
## [7] "Constituency_Name" "State_Name" "Sex"
## [10] "Party" "Constituency_Type" "Q_No"
## [13] "Q_Link" "starred_unstarred" "date"
## [16] "ministry" "member" "subject"
## [19] "pg.no" "Question" "Answer"
## [22] "Year" "constituency_Present"
Breakdown of Questions by LS wise
## # A tibble: 4 x 2
## ls_term count
## <int> <int>
## 1 13 73456
## 2 14 66371
## 3 15 79401
## 4 16 56901
Year by year break-up of number of Questions
State Level Question Analysis
Breakup by State Number of Questions
MEAN NUMBER OF QUESTIONS ASKED STATE WISE
MINISTRY WISE QUESTIONS ASKED (TOP 5)
ALL TERMS
## # A tibble: 5 x 2
## ministry count
## <chr> <int>
## 1 FINANCE 18876
## 2 RAILWAYS 16649
## 3 AGRICULTURE 14842
## 4 HEALTH AND FAMILY WELFARE 14807
## 5 HUMAN RESOURCE DEVELOPMENT 14005
Loksabha13
## # A tibble: 5 x 3
## # Groups: ls_term [1]
## ls_term ministry count
## <int> <chr> <int>
## 1 13 FINANCE 5114
## 2 13 AGRICULTURE 4361
## 3 13 RAILWAYS 4073
## 4 13 HEALTH AND FAMILY WELFARE 3934
## 5 13 COMMUNICATIONS AND INFORMATION TECHNOLOGY 3670
LOKSABHA 14
## # A tibble: 5 x 3
## # Groups: ls_term [1]
## ls_term ministry count
## <int> <chr> <int>
## 1 14 FINANCE 4824
## 2 14 RAILWAYS 4574
## 3 14 HEALTH AND FAMILY WELFARE 3839
## 4 14 AGRICULTURE 3766
## 5 14 HOME AFFAIRS 2973
LOKSABHA 15
## # A tibble: 5 x 3
## # Groups: ls_term [1]
## ls_term ministry count
## <int> <chr> <int>
## 1 15 FINANCE 5391
## 2 15 RAILWAYS 4496
## 3 15 HUMAN RESOURCE DEVELOPMENT 4411
## 4 15 HOME AFFAIRS 4301
## 5 15 HEALTH AND FAMILY WELFARE 4283
LOKSABHA 16
## # A tibble: 5 x 3
## # Groups: ls_term [1]
## ls_term ministry count
## <int> <chr> <int>
## 1 16 HUMAN RESOURCE DEVELOPMENT 3568
## 2 16 FINANCE 3547
## 3 16 RAILWAYS 3506
## 4 16 HEALTH AND FAMILY WELFARE 2751
## 5 16 HOME AFFAIRS 2710
PARTY WISE QUESTIONS ASKED (TOP 5)
ALL TERMS
## Party Questions
## 1 BJP 84971
## 2 INC 66785
## 3 SHS 13333
## 4 CPM 11331
## 5 TDP 10780
Loksabha13
## # A tibble: 5 x 3
## # Groups: ls_term [1]
## ls_term Party Questions
## <int> <chr> <int>
## 1 13 BJP 19905
## 2 13 INC 18121
## 3 13 TDP 7000
## 4 13 CPM 3900
## 5 13 SHS 3788
LOKSABHA 14
## # A tibble: 5 x 3
## # Groups: ls_term [1]
## ls_term Party Questions
## <int> <chr> <int>
## 1 14 BJP 18703
## 2 14 INC 16182
## 3 14 CPM 3675
## 4 14 SHS 3531
## 5 14 SP 3424
LOKSABHA 15
## # A tibble: 5 x 3
## # Groups: ls_term [1]
## ls_term Party Questions
## <int> <chr> <int>
## 1 15 INC 27433
## 2 15 BJP 19714
## 3 15 BSP 3230
## 4 15 JD(U) 3211
## 5 15 SHS 3109
LOKSABHA 16
## # A tibble: 5 x 3
## # Groups: ls_term [1]
## ls_term Party Questions
## <int> <chr> <int>
## 1 16 BJP 26649
## 2 16 ADMK 6389
## 3 16 INC 5049
## 4 16 SHS 2905
## 5 16 BJD 1887
PARTY WISE QUESTIONS ASKED TO MINISTRY (TOP 5)
BJP
## # A tibble: 5 x 3
## # Groups: Party [1]
## Party ministry Questions
## <chr> <chr> <int>
## 1 BJP RAILWAYS 5676
## 2 BJP FINANCE 5256
## 3 BJP AGRICULTURE 4636
## 4 BJP HEALTH AND FAMILY WELFARE 4411
## 5 BJP HUMAN RESOURCE DEVELOPMENT 4312
INC QUESTIONS
## # A tibble: 5 x 3
## # Groups: Party [1]
## Party ministry Questions
## <chr> <chr> <int>
## 1 INC FINANCE 4836
## 2 INC AGRICULTURE 3607
## 3 INC HEALTH AND FAMILY WELFARE 3599
## 4 INC RAILWAYS 3472
## 5 INC HUMAN RESOURCE DEVELOPMENT 3426
CPM
## # A tibble: 5 x 3
## # Groups: Party [1]
## Party ministry Questions
## <chr> <chr> <int>
## 1 CPM RAILWAYS 802
## 2 CPM FINANCE 779
## 3 CPM AGRICULTURE 651
## 4 CPM HEALTH AND FAMILY WELFARE 621
## 5 CPM HUMAN RESOURCE DEVELOPMENT 459
SHS
## # A tibble: 5 x 3
## # Groups: Party [1]
## Party ministry Questions
## <chr> <chr> <int>
## 1 SHS FINANCE 932
## 2 SHS RAILWAYS 805
## 3 SHS HEALTH AND FAMILY WELFARE 781
## 4 SHS AGRICULTURE 741
## 5 SHS HUMAN RESOURCE DEVELOPMENT 740
JDU
## # A tibble: 5 x 3
## # Groups: Party [1]
## Party ministry Questions
## <chr> <chr> <int>
## 1 JD(U) FINANCE 646
## 2 JD(U) HOME AFFAIRS 422
## 3 JD(U) RAILWAYS 420
## 4 JD(U) AGRICULTURE 407
## 5 JD(U) HEALTH AND FAMILY WELFARE 407
TOP 5 MPS QUESTIONS ASKED (TOP 5)
ALL TERMS
## # A tibble: 5 x 3
## # Groups: all_members [5]
## all_members Party Total_Questions
## <chr> <chr> <int>
## 1 Owaisi Shri Asaduddin AIMIM 1384
## 2 Ahir Shri Hansraj Gangaram BJP 1179
## 3 UMMAREDDY VENKATESWARLU TDP 1117
## 4 Siddeswara Shri Gowdar Mallikarjunappa BJP 990
## 5 AMBATI BRAHMANAIAH TDP 891
Loksabha13
## # A tibble: 5 x 4
## # Groups: all_members, ls_term [5]
## all_members ls_term Party Total_Questions
## <chr> <int> <chr> <int>
## 1 UMMAREDDY VENKATESWARLU 13 TDP 1117
## 2 AMBATI BRAHMANAIAH 13 TDP 891
## 3 SULTAN SALAHUDDIN OWAISI 13 AIMIM 841
## 4 RAMDAS ATHAWALE 13 IND 831
## 5 RAJO SINGH 13 INC 727
LOKSABHA 14
## # A tibble: 5 x 4
## # Groups: all_members, ls_term [5]
## all_members ls_term Party Total_Questions
## <chr> <int> <chr> <int>
## 1 Kharventhan Shri Salarapatty Kuppusamy 14 INC 853
## 2 Athawale Shri Ramdas 14 RPI(A) 771
## 3 Reddy Shri Karunakara G. 14 BJP 700
## 4 Tripathy Shri Braja Kishore 14 BJD 629
## 5 Ahir Shri Hansraj Gangaram 14 BJP 610
LOKSABHA 15
## # A tibble: 5 x 4
## # Groups: all_members, ls_term [5]
## all_members ls_term Party Total_Questions
## <chr> <int> <chr> <int>
## 1 Ramasubbu Shri S. 15 INC 518
## 2 Owaisi Shri Asaduddin 15 AIMIM 511
## 3 Maadam Shri Vikrambhai Arjanbhai 15 INC 499
## 4 Ahir Shri Hansraj Gangaram 15 BJP 488
## 5 Sugavanam Shri E.G. 15 DMK 482
LOKSABHA 16
## # A tibble: 5 x 4
## # Groups: all_members, ls_term [5]
## all_members ls_term Party Total_Questions
## <chr> <int> <chr> <int>
## 1 Owaisi Shri Asaduddin 16 AIMIM 273
## 2 Kothapalli Smt. Geetha 16 YSRCP 269
## 3 Nayak Shri B.V. 16 INC 256
## 4 Patle Smt. Kamla Devi 16 BJP 256
## 5 Venugopal Dr. Ponnusamy 16 ADMK 256