API tools faq
paste
Advertisement
doranchak

Untitled

doranchak
Mar 2nd, 2017
133
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.03 KB | None | 0 0
raw download clone embed print report
  1. select CaseDisposition, COUNT(*) from PD_CPCMS_DISPOSITION_EVENTS
  2. group by CaseDisposition
  3. order by CaseDisposition
  4.  
  5. 101 (Guilty Plea) 58
  6. Added by Information 94
  7. Administrative Closure 338
  8. ARD - County 1206
  9. ARD - County Open 16315
  10. ARD - State Open 4
  11. Case Dismissed - Defendant Deceased 37
  12. Charge Changed 7
  13. Charge Changed (Lower Court) 1
  14. Defendant Unavailable 12
  15. Demurrer Sustained 32
  16. Dismissed 245
  17. Dismissed (Lower Court) 1
  18. Dismissed - De Minimis 1
  19. Dismissed - Other 37
  20. Dismissed - Rule 586 (Satisfaction/Agreement) 1653
  21. Dismissed - Rule 600 (Speedy Trial) 96
  22. Dismissed by Information 1
  23. Disposition in Lieu of Trial 1
  24. Fugitive (Lower Court) 1
  25. Guilty 5650
  26. Guilty - Tobacco Sales (Lower Court) 1
  27. Guilty but Mentally Ill 5
  28. Guilty by Trial (Lower Court) 3
  29. Guilty of a Lesser Charge 45
  30. Guilty Plea 92578
  31. Guilty Plea (Lower Court) 15
  32. Guilty Plea - Mentally Ill 107
  33. Guilty Plea - Negotiated 39001
  34. Guilty Plea - Non-Negotiated 477
  35. Guilty Plea to a Lesser Charge 209
  36. Guilty Plea Withdrawn 53
  37. Guilty Plea Withdrawn (Lower Court) 1
  38. Guilty Plea/Probation Without Verdict 2923
  39. Guilty Plea/PWOV 230
  40. Held for Court 121
  41. Held for Court (Lower Court) 23309
  42. Information Filed 12
  43. Judgment of Acquittal 25
  44. Judgment of Acquittal (Prior to Disposition) 161
  45. Judgment of Acquittal (Rule 608-All Counts) 9
  46. Judgment of Acquittal (Rule 608-Remaining Counts) 1
  47. Lower Court Charge(s) Dismissed 4
  48. Lower Court Proceeding (generic) 86782
  49. Migrated - Case Closed 10
  50. Migrated Disposition 303092
  51. Mistrial 47
  52. Mistrial - Hung Jury 47
  53. Mistrial - Hung Jury (Lower Court) 3
  54. Mistrial - Miscellaneous 1
  55. Moved to Non-Traffic (Lower Court) 6
  56. Nolle Prossed 8308
  57. Nolle Prossed (Case Continues) 264
  58. Nolle Prossed (Case Dismissed) 3236
  59. Nolle Prossed (Post-Disposition) 342
  60. Nolle Prossed/Withdrawn 4
  61. Nolo Contendere 1733
  62. Nolo Contendere/Probation Without Verdict 14
  63. Non-Conviction Community Service 1
  64. Not Competent to Stand Trial 1
  65. Not Guilty 2197
  66. Other (Specify) 4
  67. Probation Without Verdict 4
  68. Proceed to Court 168450
  69. Proceed to Court (Amended Info/Arraignment Waived) 45
  70. Proceed to Court (Amended Information) 179
  71. Proceed to Court (ARD Revoked) 2197
  72. Proceed to Court (Arraignment Waived) 4
  73. Proceed to Court (Conviction Reversed) 87
  74. Proceed to Court (GP Withdrawn) 268
  75. Proceed to Court (Mistrial) 61
  76. Proceed to Court (Program Revoked) 27
  77. Proceed to Court (Remand from Appellate Court) 43
  78. Proceed to Court (Transfer Vacated) 2
  79. Quashed 7
  80. Remanded to Magisterial District Judge 258
  81. Replacement by Information 2
  82. Sent to Common Pleas (Lower Court) 62
  83. Severed 6
  84. Transfer Proceedings 5
  85. Transferred to Juvenile Division 310
  86. Waived for Court (Lower Court) 49355
  87. Withdrawn 948
  88. Withdrawn (Lower Court) 2
  89. Withdrawn Pursuant to Pa.R.Crim.P. 561(B) 61
  90.  
  91. select OffenseDisposition, COUNT(*) from PD_CPCMS_OFFENSE_DISPOSITIONS
  92. group by OffenseDisposition
  93. order by OffenseDisposition
  94.  
  95. NULL 109941
  96. Added by Information 35276
  97. Administrative Closure 1128
  98. ARD - County 50605
  99. ARD - County Open 6479
  100. ARD - State 1
  101. ARD - State Open 3
  102. Case Dismissed - Defendant Deceased 101
  103. Charge Changed 24148
  104. Charge Changed (Lower Court) 3361
  105. Defendant Unavailable 6088
  106. Demurrer Sustained 158
  107. Dismissed 8695
  108. Dismissed (Lower Court) 16447
  109. Dismissed - De Minimis 1
  110. Dismissed - Other 221
  111. Dismissed - Rule 586 (Satisfaction/Agreement) 3747
  112. Dismissed - Rule 600 (Speedy Trial) 1832
  113. Dismissed by ARD 12133
  114. Dismissed by ARD (Lower Court) 9
  115. Dismissed by Information 7
  116. Disposed at Lower Court 51341
  117. Guilty 41693
  118. Guilty - Tobacco Sales 33
  119. Guilty - Tobacco Sales (Lower Court) 1
  120. Guilty but Mentally Ill 26
  121. Guilty by Trial (Lower Court) 1
  122. Guilty of a Lesser Charge 716
  123. Guilty Plea 695763
  124. Guilty Plea (Lower Court) 153
  125. Guilty Plea - Mentally Ill 259
  126. Guilty Plea - Negotiated 79678
  127. Guilty Plea - Non-Negotiated 1412
  128. Guilty Plea to a Lesser Charge 12617
  129. Guilty Plea Withdrawn 132
  130. Guilty Plea/Probation Without Verdict 3765
  131. Guilty Plea/PWOV 335
  132. Held for Court 189781
  133. Held for Court (Lower Court) 288802
  134. Information Filed 31
  135. Judgment of Acquittal 168
  136. Judgment of Acquittal (Prior to Disposition) 1009
  137. Judgment of Acquittal (Rule 608-All Counts) 17
  138. Lower Court Charge(s) Dismissed 23
  139. Lower Court Proceeding (generic) 338
  140. Migrated Disposition 206518
  141. Mistrial 185
  142. Mistrial - Hung Jury 246
  143. Mistrial - Hung Jury (Lower Court) 1
  144. Mistrial - Miscellaneous 1
  145. Moved to Non-Traffic (Lower Court) 9
  146. Nolle Prossed 31416
  147. Nolle Prossed (Case Continues) 787
  148. Nolle Prossed (Case Dismissed) 10030
  149. Nolle Prossed (Post-Disposition) 855
  150. Nolle Prossed/Withdrawn 179542
  151. Nolo Contendere 12786
  152. Nolo Contendere/Probation Without Verdict 37
  153. Nolo Contendere/PWOV 2
  154. Not Competent to Stand Trial 4
  155. Not Guilty 28398
  156. Not Guilty - Tobacco Sales 5
  157. Not Guilty by Reason of Insanity 2
  158. Other (Specify) 1145
  159. Proceed to Court 259403
  160. Proceed to Court (Amended Info/Arraignment Waived) 138
  161. Proceed to Court (Amended Information) 221
  162. Proceed to Court (ARD Revoked) 10696
  163. Proceed to Court (Arraignment Waived) 17
  164. Proceed to Court (Conviction Reversed) 210
  165. Proceed to Court (GP Withdrawn) 957
  166. Proceed to Court (Mistrial) 190
  167. Proceed to Court (Program Revoked) 3
  168. Proceed to Court (Remand from Appellate Court) 222
  169. Quashed 531
  170. Quashed, Dismissed, Demurrer Sustained 73647
  171. Remanded to Magisterial District Judge 20904
  172. Replacement by Information 7944
  173. Sent to Common Pleas (Lower Court) 442
  174. Severed 317
  175. Transfer Proceedings 37
  176. Transferred to Juvenile Division 1484
  177. Waived for Court (Lower Court) 384503
  178. Withdrawn 368611
  179. Withdrawn (Lower Court) 32617
  180. Withdrawn Pursuant to Pa.R.Crim.P. 561(B) 7675
  181.  
  182. select CaseDisposition, COUNT(*) from PD_CPCMS_OFFENSE_DISPOSITIONS
  183. group by CaseDisposition
  184. order by CaseDisposition
  185.  
  186. NULL 36
  187. 101 (Guilty Plea) 161
  188. Added by Information 292
  189. Administrative Closure 1048
  190. ARD - County 4846
  191. ARD - County Open 72056
  192. ARD - State Open 39
  193. Case Dismissed - Defendant Deceased 133
  194. Charge Changed 35
  195. Charge Changed (Lower Court) 2
  196. Defendant Unavailable 99
  197. Demurrer Sustained 89
  198. Dismissed 882
  199. Dismissed (Lower Court) 1
  200. Dismissed - De Minimis 1
  201. Dismissed - Other 137
  202. Dismissed - Rule 586 (Satisfaction/Agreement) 4167
  203. Dismissed - Rule 600 (Speedy Trial) 441
  204. Dismissed by Information 6
  205. Disposition in Lieu of Trial 2
  206. Fugitive (Lower Court) 2
  207. Guilty 29424
  208. Guilty - Tobacco Sales (Lower Court) 3
  209. Guilty but Mentally Ill 41
  210. Guilty by Trial (Lower Court) 11
  211. Guilty of a Lesser Charge 230
  212. Guilty Plea 419219
  213. Guilty Plea (Lower Court) 70
  214. Guilty Plea - Mentally Ill 517
  215. Guilty Plea - Negotiated 180136
  216. Guilty Plea - Non-Negotiated 2326
  217. Guilty Plea to a Lesser Charge 662
  218. Guilty Plea Withdrawn 227
  219. Guilty Plea Withdrawn (Lower Court) 5
  220. Guilty Plea/Probation Without Verdict 9729
  221. Guilty Plea/PWOV 636
  222. Held for Court 594
  223. Held for Court (Lower Court) 108506
  224. Information Filed 57
  225. Judgment of Acquittal 120
  226. Judgment of Acquittal (Prior to Disposition) 661
  227. Judgment of Acquittal (Rule 608-All Counts) 34
  228. Judgment of Acquittal (Rule 608-Remaining Counts) 12
  229. Lower Court Charge(s) Dismissed 19
  230. Lower Court Proceeding (generic) 379281
  231. Migrated Disposition 1005859
  232. Mistrial 266
  233. Mistrial - Hung Jury 218
  234. Mistrial - Hung Jury (Lower Court) 23
  235. Mistrial - Miscellaneous 4
  236. Moved to Non-Traffic (Lower Court) 24
  237. Nolle Prossed 34248
  238. Nolle Prossed (Case Continues) 1819
  239. Nolle Prossed (Case Dismissed) 11304
  240. Nolle Prossed (Post-Disposition) 1089
  241. Nolle Prossed/Withdrawn 13
  242. Nolo Contendere 8550
  243. Nolo Contendere/Probation Without Verdict 72
  244. Non-Conviction Community Service 2
  245. Not Competent to Stand Trial 6
  246. Not Guilty 9438
  247. Other (Specify) 25
  248. Probation Without Verdict 10
  249. Proceed to Court 749532
  250. Proceed to Court (Amended Info/Arraignment Waived) 304
  251. Proceed to Court (Amended Information) 1263
  252. Proceed to Court (ARD Revoked) 9333
  253. Proceed to Court (Arraignment Waived) 22
  254. Proceed to Court (Conviction Reversed) 497
  255. Proceed to Court (GP Withdrawn) 1266
  256. Proceed to Court (Mistrial) 328
  257. Proceed to Court (Program Revoked) 84
  258. Proceed to Court (Remand from Appellate Court) 300
  259. Proceed to Court (Transfer Vacated) 4
  260. Quashed 37
  261. Remanded to Magisterial District Judge 902
  262. Replacement by Information 12
  263. Sent to Common Pleas (Lower Court) 322
  264. Severed 32
  265. Transfer Proceedings 36
  266. Transferred to Juvenile Division 1640
  267. Waived for Court (Lower Court) 231485
  268. Withdrawn 3518
  269. Withdrawn (Lower Court) 5
  270. Withdrawn Pursuant to Pa.R.Crim.P. 561(B) 326
  271.  
  272. select OffenseDisposition, COUNT(*) from PD_MDJS_DISPOSITION_DATA
  273. group by OffenseDisposition
  274. order by OffenseDisposition
  275.  
  276. Administrative Closure 980
  277. Case Dismissed - Defendant Deceased 1812
  278. Charge Changed 5109
  279. Defendant Unavailable 6112
  280. Dismissed 60827
  281. Fugitive 178
  282. Guilty Plea 1075
  283. Guilty Plea Withdrawn 3
  284. Held for Court 188879
  285. Move to Non-Traffic 108628
  286. Move to Traffic 21154
  287. Sent to Common Pleas 649
  288. Settled 15
  289. Waived Case Remanded to MDJ 12
  290. Waived for Court 398276
  291. Withdrawn 372175
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!