Count data from Sworn CPD Members dashboard
| Submitted | June 15, 2023 |
| Est. Completion | None |
MuckRock users can file, duplicate, track, and share public records requests like this one. Learn more.
Communications
From: Forest Gregg
To Whom It May Concern:
Pursuant to the Illinois Freedom of Information Act., I hereby request the following records:
Please provide the underlying data for the graphs of sworn-officers by age presented on this webpage: https://informationportal.igchicago.org/chicago-police-department-active-sworn-officer-overview/
Please include the data for the whole time period from August, 2017 to present.
If available, I am requesting the individual-level data that is aggregated to the count data displayed. If individual level data is not held by your office, then please provide the aggregated count data that is displayed.
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 there are fees, 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, 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,
Forest Gregg
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Illinois Freedom of Information Act. request, copied below, and originally submitted on June 15, 2023. Please let me know when I can expect to receive a response.
Thanks for your help, and let me know if further clarification is needed.
From:
Please see the attached response to your recent request.
Sincerely,
Jaimie E. Grace
Associate Staff Attorney
City of Chicago | Office of Inspector General
740 N. Sedgwick, Suite 200 | Chicago, Illinois 60654
-
~WRD0000
From: Forest Gregg
Thank you for your response.
Could you please help me understand why the data would need to be reviewed and validated? This would be the same underlying data that you are currently displaying on your website.
Best,
Forest
From: Chicago Office Of The Inspector General
OIG validates data to confirm the integrity, accuracy, and structure of data before it’s produced. Once the requested data has been pulled, OIG must confirm that the extracted data matches the external information. This process is done through sampling. Other factors must be considered as well such as confirming that no mission sensitive units of the Chicago Police Department (“CPD”) are exposed. Additionally, CPD unit names and numbers that change over time must be checked to ensure they are accurately grouped.
Additionally, the underlying data used to create OIG’s public safety dashboard is extracted through sequel (SQL) queries. Validating the data allows us to confirm that the sequence is proper, which ensures the data matches the dashboard count, as you originally requested. Furthermore, the underlying data is not consolidated into one table for security reasons, which increases the time needed to validate the data.
Sincerely,
Jaimie E. Grace
Associate Staff Attorney
City of Chicago | Office of Inspector General
740 N. Sedgwick, Suite 200 | Chicago, Illinois 60654
-
~WRD0001
From: Forest Gregg
I would be happy to have the output of the SQL queries, with mission critical information redacted. The rest of the validation checks do not seem required under FOIA.
That should substantially decrease the effort of producing these records.
From: Chicago Office Of The Inspector General
We would like to set up a phone call to confer with you regarding your request. We have availability Friday afternoon (from 1:00pm-3:00pm), and Monday afternoon (from 1:30pm-3:00pm). Let us know what works best for you, or if you prefer another time.
Sincerely,
Jaimie E. Grace
Associate Staff Attorney
City of Chicago | Office of Inspector General
740 N. Sedgwick, Suite 200 | Chicago, Illinois 60654
-
~WRD0001
Files
pages