New York makes complaint records of 83,000 police officers available to public
theguardian.com
theguardian.com
Contrast this dataset to Chicago's COPA's release: https://data.cityofchicago.org/Public-Safety/COPA-Cases-Summ.... This dataset is also missing information, but at the very least it gives context to complaints. What it's not missing is the underlying information that led to the complaint, the depth of investigation, a written summary of findings, etc. Happy to show anyone who's interested how to FOIA for that info, though.
Are these sorts of datasets useful? Sure, but at the non-trivial cost of an off balanced trust model where many folk who are just beginning in this work will think is the end-all, be-all and won't push for more. In a lot of ways, these releases don't feel like progress to me anymore. Particularly considering that a lot of these sorts of datasets are filtered, while implicitly hiding a significant amount of information, often without detailing what's missing, leading to biased analysis from the beginning. Keep in mind that these cities treat those who want access to data largely as adversarials, with things like this happening: https://www.chicagoreporter.com/chicago-police-department-ar...
Relatedly, Chicago had a huge win on this front with the Green v Chicago lawsuit, which resulted in about four years' worth of complaint PDFs, video and audio between 2012 and 2016. The lawsuit itself is supposed to yield about 40 years worth of complaints, but it's a slow process that the City's fighting back on -- last year they attempted a $500k buyout last year, but it failed after public outcry and it's hard to say what's coming next, or if the remaining ~35 years will be provided. I have sincere doubts.
One of the only ways that we, as a public, can get access to deep information that leads to real understanding is to get access to the underlying records used to build these datasets. That means submitting FOIA requests and pushing back on bogus rejections through litigation where needed. Sadly, not many folks do this.
Something like this to get a roster of new cops between 2019 and 2020 should work:
"Pursuant to $FOIA_LAW, please provide me with the following information for all cops hired between 2019 and 2020:
-Cop Name
-Cop Badge #
-Cop Race
-Hired date
-Age
-Direct Lead name/badge/age"
And done. In theory, two weeks later you should get back the records you're looking for. Try adding as much information as can for what you're interested in. The bullet points are just examples.(this is not legal advice and is just based on my own experiences with foia)