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.
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.
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
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

• • •

Missing some Tweet in this thread? You can try to force a refresh

Keep Current with Peter Oleksy 🧙‍♂️

Peter Oleksy 🧙‍♂️ Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!


Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

Did Thread Reader help you today?

Support us! We are indie developers!

This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!


0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy


3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!