Sure -- here are some things I've done with public records:

https://southsideweekly.com/cpd-routinely-denies-foia-reques...

https://mchap.io/using-foia-data-and-unix-to-halve-major-sou...

https://mchap.io/that-time-the-city-of-seattle-accidentally-...

https://www.chicagoreporter.com/chicago-police-arrested-more...

https://chicagoreader.com/news-politics/news/shotspotters-de...

https://chicagoreader.com/news-politics/news/false-alarms/

https://thetriibe.com/2020/12/hundreds-of-chicago-police-mad...

It's hard to talk about the FOIA litigation online, but [1] is some litigation I've been plaintiff for, for the database schema of Chicago's parking ticket database. The idea is to figure out what can be requested prior to submitting requests, but the city argues that its release would compromise network security. Even though we won the appellate case, it got raised and accepted by the IL Supreme court, so it'll be another long while until we know how it pans out.

[1] https://ilcourtsaudio.blob.core.windows.net/antilles-resourc...