Thread by @lonegreyhat

I heard you like spreadsheets.
A complete listing of 19,308 sealed indictment case numbers (only partial March data ATM - will update when available).
Filters are your friend.
docs.google.com/spreadsheets/d…

UPDATE: All March data has been included. Current, complete listing of 24,411 unique case numbers.
27 cases unsealed to date.
3 unlisted due to court clerical errors.
@KingsbroGodsson @damartin32 @almostjingo @littlecarrotq

UPDATE: Partial April data has been included (everything currently available).
The score ⤵️
25,280 unique case numbers.
2,414 known unsealed to date.
5 unlisted due to court clerical errors.
Thank you @Avonsalez!

For those of you that like to read documents... instructions on how to filter cases with publicly available docs.
(Looking at you @almostjingo)

UPDATE: Full April data has been loaded.
Current score ⤵️
30,234 unique case numbers.
2,848 known unsealed to date.
6 unlisted due to court clerical errors.
Thank you @AvonSalez & @Avery1776!

I heard you like maps. I heard you like mapped data even more.

UPDATE: All unsealed case filings have been loaded.

Current score ⤵️
30,247 unique SEALED cases.
3,228 have since been unsealed.
6 unlisted due to clerical errors.
37,038 cases filed UNSEALED (never sealed).
Sealed cases represent ~45% of total case load.
#DueDiligence

UPDATE: Partial May data loaded (56/93 districts)
+3,250 sealed indictments
Current score ⤵️
33,494 TOTAL sealed indictments
3,263 known unsealed to date
6 clerical errors
41,625 TOTAL cases filed unsealed
75,122 TOTAL criminal cases

UPDATE: Full May data loaded
+5,425 sealed indictments
Current score ⤵️
35,669 TOTAL sealed indictments
3,197 known unsealed
7 unlisted (clerical errors?)
45,903 TOTAL cases filed unsealed
81,581 TOTAL criminal cases

UPDATE: Full June data loaded
+5,458 sealed indictments (ex SW/GJ filings, etc)
Current score ⤵️
40,103 TOTAL sealed indictments
3,410 known unsealed (4,070 estimated)
10 unlisted
54,082 TOTAL cases filed unsealed
95,400 TOTAL criminal cases
docs.google.com/spreadsheets/d…

UPDATE: Full July data loaded
+5,008 Sealed cases

Current score ⤵️
46,359 TOTAL Sealed cases
3,758 known unsealed (4,489 estimated)
269 unsealed as warrants (7.16%)
10 unlisted
61,485 TOTAL cases filed unsealed
107,844 TOTAL criminal cases
docs.google.com/spreadsheets/d…