search

lucyparsons / OpenOversight

Police oversight and accountability through public data đź‘®
https://openoversight.com
GNU General Public License v3.0
240 stars 79 forks source link

Update CPD roster #66

Closed redshiftzero closed 4 years ago

redshiftzero commented 8 years ago

The most recent "Date of Employment" in our current roster is "2015-12-14 00:00:00". Time to update! More broadly, this is something that we will need to do periodically to keep data fresh. Also, we might want to consider adding photographs and A&A sheets to the list of things to FOIA for this project (so that we have information about where an officer is assigned in the city - this is necessary for #12).

b-meson commented 7 years ago

https://www.muckrock.com/foi/chicago-169/cpd-badge-numbers-29489/

redshiftzero commented 7 years ago

As discussed at the dev meeting, here is my original FOIA for the roster (cc @JoshuaOpolko):

To whom it may concern:

Pursuant to the Illinois Freedom of Information Act (5 ILCS 140/1 to 11), I hereby request the following records:

The current roster of sworn officers in the Chicago Police Department. These documents should be sufficient to show:

  • Names of each sworn police officer. There should be at least 13976 rows in this dataset.
  • Current badge number
  • Current rank
  • Gender
  • Race
  • Date of employment

The requested documents will be made available to the general public, and this request is not being made for commercial purposes.

In the event that fees cannot be waived, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically in Excel or plaintext format if available, and by e-mail attachment if available or CD-ROM if not.

Thank you in advance for your anticipated cooperation in this matter. I look forward to receiving your response to this request within 5 business days, as the statute requires.

Sincerely,

Jennifer Helsby

b-meson commented 7 years ago

Current star numbers here. However we definitely need to have these automated or send this request every 6 months. We can use the MuckRock API to query CPD using agency code 503 every 6 months.

redshiftzero commented 6 years ago

This was marked in progress but hasn't been addressed since the initial launch of OpenOversight so we should get to this soon - marking as high priority. Note that now the ability to update the officers assignments as well as add new officers is now available to all admins via the web application, so this does not require any special technical skills to take on.

rajivsinclair commented 4 years ago

hey hey! We recently received data from CPD for all officers’ badge numbers over time. Haven’t fully reviewed and processed it yet, but I wanted to share it with y’all in case you’re working on an update for OpenOversight: InvisibleInstitute_DataInfoforallswornCPDofficers-UPDATEv2.xlsx

Also, if you’d like to see the FOIA response letter, here it is: Response.doc

abandoned-prototype commented 4 years ago

Updating here to say that this task has finally been completed. An updated roster has been imported to production. Thanks to @rajivsinclair for providing very recent assignment data. The work on merging is documented here: https://github.com/abandoned-prototype/OpenOversight_data/tree/main/CPD_August_2020. The files starting with "4_outselect" are those that have been imported via the advanced_csv_import command. Still an open question is how to keep the roster up to date. I will open an issue on that.