Missing FOIA documents

[jayqi]

What we're missing:

• shootings-ipra-may2016 - FOIA request and/or response
• complaints-ipra-apr2016 - FOIA request (we have responses but they don't quote the requests in detail)
• cpdb_complaints-cpd - FOIA requests and/or responses for august 2015, march 2015, and september 2015

[chaclynhunt]

• shootings-cpd-february2016
  request: https://www.documentcloud.org/documents/2995716-FOIAU-FileCPD.html
  response: (will collect from Jamie Kalven, who is the filer & receiver on the request.)
• shootings-ipra-may2016
  request: https://www.documentcloud.org/documents/2995650-FOIAU-FileIRPA04072016.html
  response: https://www.documentcloud.org/documents/2995713-IPRA-U-Files-Response-Letter.html
  (includes three separate letters - an extension, an update, and a final)
• complaints-ipra-apr2016
  request: https://www.documentcloud.org/documents/2995647-DataUpdateIPRA04072016.html
  response: https://www.documentcloud.org/documents/2995715-IPRA-misconduct-april-response-letter.html
• cpdb_complaints-cpd march2015
  request: https://www.documentcloud.org/documents/2995647-DataUpdateIPRA04072016.html (this is an identical request, just updated with a date to send to IPRA later)
  response: (will collect from Jamie Kalven, who is the filer & receiver on the request.)
• category codes
  request: https://www.documentcloud.org/documents/2995653-FOIACategoryCodes-2.html
  response IPRA: https://www.documentcloud.org/documents/2642470-311-Response.html
  response CPD: https://www.documentcloud.org/documents/2642471-Scan-001.html
• TRR data request, no answer / no data set
  request: https://www.documentcloud.org/documents/2995649-TRRFOIA.html
• assignment data + officer demographics
  request: fully contained in the response, written in the body of an e-mail
  response: https://www.documentcloud.org/documents/2995717-Kalven-16-1105-Responsive-Letter.html

that's most of what i could find for now! will update here at some point.

[jayqi]

Questions:

• shootings-cpd-feb2016
  • You provided a request letter 10/30/2015. We already had a final response letter dated 1/29/2016. However, the contents of that letter reference a 11/17/2015 response letter from CPD to Jamie Kalven, and then a new request letter with narrowed constraints from Jamie Kalven to CPD of unknown date but labeled "FOIA FILE NO. 15-7058". Can we get those two missing letters?
• shootings-ipra-may2016
  • Reading into the three letters you've combined as the responses, it seems like there might be a data file that is missing from our repo. The second response letter ("update", 4/21/2016) says it accompanies a spreadsheet. The third response letter ("final", 5/20/2016) says that in addition to the one previous spreadsheet, it is accompanying 14 additional spreadsheets. Right now the Excel file we have in the repo has 14 worksheets (the fifteenth Sheet3 is blank), so I presume that file is what the third letter is talking about. What about the single spreadsheet that the second letter talks about?
• complaints-ipra-apr2016
  • the repo originally had two response letters. One is the same as the one you've linked to, and the other is actually the second response letter from the shootings-ipra-may2016 set above. Is it a mistake that this shootings response letter is in the April complaints folder? The response letter says there are five spreadsheets, but the folder has two extra ones: IPRA Investigators' Info.xls and Shootings Victim Data.xls. Is the victim spreadsheet the missing one from the May set that I asked about above? What about the investigator spreadsheet -- where did that come from?