Searches for race-bias messages (Chicago Police Department)

Dear Brnadon Smith,

Thank you for registering with the City of Chicago Request Center.  Please log in to the Records Center to update any contact or password information and to track the progress of your request.
Login: requests@muckrock.com

If you have never used this system or cannot remember your password, please request a Temporary Password using the Forgot Password option on the login screen.
This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.

Dear Brnadon:
Thank you for your interest in information from the Chicago Police Department. Your FOIA request has been received and is being processed. Your FOIA Center reference number for tracking purposes is: P483059-041519
You have requested the following records: Pursuant to the Illinois Freedom of Information Act., I hereby request the following records:1. Documents that show what kind of a database your agency's email is stored in (such as Microsoft Access; Oracle; Microsoft Sharepoint; SQL; or Microsoft Exchange).2a. Documents sufficient to show any FOIA management software or email search software (not including the client one uses to read and reply to email) in use by your agency. These documents could include purchase orders, contracts for use of a service, or—if and only if neither of those are available—some departmental communication portraying the name of the system.2b. Any vendor-provided manuals or instructions or software documentation for software used by the agency to search emails2c. Complete copies of any rules, guidelines, instructions, or best practices in use by your agency for searching emails and texts in response to FOIA requests3. Documents that show all of, and represent the entirety of each of, your agency’s contracts with cell/mobile service providers (sometimes called carriers). Also we request any documents that describe a deletion schedule for text messages sent to/from the devices on your agency's provider contract. For this purpose, "deletion schedule" means a number of days before messages are regularly deleted from the carrier's data repositories. Such a schedule would also specify whether that date is a rolling daily deletion after that many days, or rather periodical, where the number of days represents the period.4a. Keyword searches of all SMS ("text") records sent to and received by all sworn officers on agency-issued mobile devices4b. Keyword searches of all emails sent to and received by sworn officers on agency email accounts.- For the keywords on 4a and 4b, please refer to the list at the bottom of this request. Date range is four months prior to the date of the request until the date of the request. Please provide the requesters evidence that your search was agnostic toward capital and lowercase letters throughout each searched character string.- For each returned *email or SMS* result, please include the following metadata: unique sender identification; unique recipient identification; date and time of transmission; and document(s) sufficient to show the full name of the officer associated with the unique identifier. (An example of unique sender/recipient identification would be an email address or a phone number, depending on the type of record.)5a. Documents that show what, if any, text-based messaging clients or platforms (you might call them software-based “systems” for messaging, or “instant messaging”) are available for use on computers in your patrol cars. Also we request documents that show what public body maintains or is responsible for each of those clients/platforms. For instance, sometimes a messaging system is maintained and offered by a state agency like highway patrol; other systems are built or contracted-for locally, by your jurisdiction itself. We request the above-described documents on any and all messaging systems deployed on a computer in a police vehicle in your jurisdiction.If your jurisdiction maintains/provides its own software on in-car computers for "instant messaging”—and therefore is the keeper of records associated with the system, including historic message logs—I request:5b. Documents sufficient to show what kind of a database that messages crossing the in-car messaging system are stored in. (Examples might be Microsoft Access; Oracle; SQL or similar). The file extension of the message logs will suffice.5d. Keyword searches of databases containing messages sent and received over the in-car computers' instant messaging system. For the keywords that requester(s) would like searched, please refer to the list at the bottom of this request. Date range is four months prior to the date of the request until the date of the request. Please provide the requesters evidence that your search was agnostic toward capital and lowercase letters throughout each searched character string.- For each returned *in-car IM* result, please include the following metadata: unique sender identification; unique recipient identification; date and time of transmission; and document(s) sufficient to show the full name of the officer associated with the unique identification. An example of unique sender/recipient identification would, in the case of a car-to-car instant message, be some kind of username corresponding to an officer, or, if and only if an officer identifier is not extant, an identifier for a particular computer or patrol car.6. Documents that provide evidence of any search your jurisdiction that either the department itself or the public body of which it’s a part has undertaken, in the five years prior to the date of this request, for racist, race-biased, or white supremacist terminology. This would include any searches undertaken of text messages, emails, or instant messages, for example, those IMs to and from in-car computers. It need not include an internal investigation of any single officer. Rather, we seek documents that show a search of communications to/from groups of officers, ranging up to the entire department. We seek documents that show the date of the search; the rationale or reason for the search; the search terms used; the name of the public official who requested the search; the total number of officers whose communications were searched (and if a subset of a department, the reason for choosing that subset); the type of communications searched; and any summary of the result(s) of any search. If no document exists that can be construed as a summary of search results, we request the full results of any search.Please take under advisement:Communications that contain these terms, if in use by a law enforcement officer, are public and not personal records. Police officers interact directly with a diverse public and any expressions of potentially prejudicial or biased sentiments relate directly to an officer’s job responsibilities and performance. They are undoubtedly subject to disclosure. In the event you cite an ongoing investigation as a reason for withholding a particular record, we ask, as a part of this records request, for a document that shows the date (nothing more) of the last internal communication in the investigation.Nearly every state, yours included, defines a public record as any record that a public body is in “control” of, not just in the “possession” of. This provides for situations where records are stored in the care of a third-party storage facility, or some kind of technology vendor that provides data storage or communications services to the public body in question. To the extent a technology vendor is in possession of the records sought herein, this request, barring justified exemption, compels the public body to seek the requested documents from its technology vendor.Should a FOIA officer have one or more questions about the request, please contact Brandon Smith via phone (740-505-0038) or the email address this request was sent from. Mr. Smith would be happy to hear from you.It is not Mr. Smith’s wish to overburden your office. An email or phone call is probably in order soon to discuss your office’s standard for how much estimated time—say, for review toward redaction—constitutes an unduly burdensome request. That said, we believe the list of search terms contained herein is sufficiently culled to produce only a reasonably number of responsive records.Rarely does caselaw on what is and is not overly burdensome specify which type of employee is required for processing; the only relevant factor is estimated time by *a* staff member. In other words, if a search would be impossible or overly burdensome for a FOIA staffer, but an IT staffer can do it in ten minutes, then the law requires the public body to request an IT staffer complete the job. This is our purpose in asking for documents showing what type of database each record is stored in: the type of file determines what type of search is possible by a qualified IT staffer.This request is being made on behalf of Brandon Smith and on behalf of ProPublica.Search terms list:nigger spic coon monkey white power white genocide 1488 14/88 14 words fourteen words mud people boot party Curb job hammerskin hammer skin Vinlanders Blood & Honour Blood & Honor Blood and honor Gab mein heil Reich Muslim problem White genocide White civil rights Knights Filthy jew Aryan Confederate flag Dixie Diversity is a code word Globalist fashy Chimp out Chimpout Goy Kek shekels Kike TRS Shills Identitarian Stormfront Daily Stormer Identity Evropa Identity Europa Cultural marxist Anti-white White identity Jewish Question JQ ZOG Klansman White pride WPWW Rahowa Ghost skinThe 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,Brandon SmithFiled via MuckRock.com E-mail (Preferred): requests@muckrock.com Upload documents directly: https://www.muckrock.comhttps://www.muckrock.com/ Is this email coming to the wrong contact? Something else wrong? Use the above link to let us know.For mailed responses, please address (see note): MuckRock News DEPT MR 71027 411A Highland Ave Somerville, MA 02144-2516PLEASE NOTE: This request is not filed by a MuckRock staff member, but is being sent through MuckRock by the above in order to better track, share, and manage public records requests. Also note that improperly addressed (i.e., with the requester's name rather than "MuckRock News" and the department number) requests might be returned as undeliverable.
Chicago Police Department (CPD) responds to all public records requests in accordance with the Illinois Freedom of Information Act (FOIA), 5 ILCS 140/1 et seq.  If further time is needed to assemble and copy all documents responsive to your FOIA request, we will contact you with a time estimate and a request to extend. You can monitor the progress of your request at the link below and you’ll receive an email when your request has been completed. Thank you for using the Chicago FOIA Center.
To monitor the progress or update this request please log into the Chicago Public Safety Record System. (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVulVO5zgaUYhAxXpmsXAhNKLIDBByxt-2BcapQSrFnKhQuogBHGvLRy8X00WcQGJOPxxt1FR5IcdMLOJ6m9mQ7KGZ7fAYanKuFjeyqE6-2BAbAprv_OPLp48-2FBw5PP-2FPp2TL2uyo-2BWKKgJ8StTP0gy7nOXG1soEo6IGAhJAN95NfksgzuKN2K1lCpcOQX-2BJb7zGVcUIf-2Bco03r7SONyz08ck8YRiyGwZIKchYFucwr4u8d2uwcpOuzxcYPldqhMHSQoY58-2BpOe2xB4jnZRRpsvIDZKRTQ7yfz1IQECYBoAW5xBgAGqoeW6odw6TG-2BKJso8gIrogzadiYzAlg-2FPkhIY18-2F8oR-2FZin05Prbbmq0RjUTG1GpisObU5mIw3WbWgn8X5-2BHfAzgNd-2Fta5e6vWunWd5b9gqVZ3cq-2B903RhUTF8C8HLpgNSK4opyMaY2OI-2F6fJYM3T7AcgjBk9PgicprdwB00lmHTBjsqDJhFqmRT2nDg45-2BlNDjLAHvsnPHehPXgn1lINpg-3D-3D)

Dear Brnadon:
Thank you for your interest in information from the Chicago Police Department. Your FOIA request has been received and is being processed. Your FOIA Center reference number for tracking purposes is: P483059-041519
You have requested the following records: Pursuant to the Illinois Freedom of Information Act., I hereby request the following records:1. Documents that show what kind of a database your agency's email is stored in (such as Microsoft Access; Oracle; Microsoft Sharepoint; SQL; or Microsoft Exchange).2a. Documents sufficient to show any FOIA management software or email search software (not including the client one uses to read and reply to email) in use by your agency. These documents could include purchase orders, contracts for use of a service, or—if and only if neither of those are available—some departmental communication portraying the name of the system.2b. Any vendor-provided manuals or instructions or software documentation for software used by the agency to search emails2c. Complete copies of any rules, guidelines, instructions, or best practices in use by your agency for searching emails and texts in response to FOIA requests3. Documents that show all of, and represent the entirety of each of, your agency’s contracts with cell/mobile service providers (sometimes called carriers). Also we request any documents that describe a deletion schedule for text messages sent to/from the devices on your agency's provider contract. For this purpose, "deletion schedule" means a number of days before messages are regularly deleted from the carrier's data repositories. Such a schedule would also specify whether that date is a rolling daily deletion after that many days, or rather periodical, where the number of days represents the period.4a. Keyword searches of all SMS ("text") records sent to and received by all sworn officers on agency-issued mobile devices4b. Keyword searches of all emails sent to and received by sworn officers on agency email accounts.- For the keywords on 4a and 4b, please refer to the list at the bottom of this request. Date range is four months prior to the date of the request until the date of the request. Please provide the requesters evidence that your search was agnostic toward capital and lowercase letters throughout each searched character string.- For each returned *email or SMS* result, please include the following metadata: unique sender identification; unique recipient identification; date and time of transmission; and document(s) sufficient to show the full name of the officer associated with the unique identifier. (An example of unique sender/recipient identification would be an email address or a phone number, depending on the type of record.)5a. Documents that show what, if any, text-based messaging clients or platforms (you might call them software-based “systems” for messaging, or “instant messaging”) are available for use on computers in your patrol cars. Also we request documents that show what public body maintains or is responsible for each of those clients/platforms. For instance, sometimes a messaging system is maintained and offered by a state agency like highway patrol; other systems are built or contracted-for locally, by your jurisdiction itself. We request the above-described documents on any and all messaging systems deployed on a computer in a police vehicle in your jurisdiction.If your jurisdiction maintains/provides its own software on in-car computers for "instant messaging”—and therefore is the keeper of records associated with the system, including historic message logs—I request:5b. Documents sufficient to show what kind of a database that messages crossing the in-car messaging system are stored in. (Examples might be Microsoft Access; Oracle; SQL or similar). The file extension of the message logs will suffice.5d. Keyword searches of databases containing messages sent and received over the in-car computers' instant messaging system. For the keywords that requester(s) would like searched, please refer to the list at the bottom of this request. Date range is four months prior to the date of the request until the date of the request. Please provide the requesters evidence that your search was agnostic toward capital and lowercase letters throughout each searched character string.- For each returned *in-car IM* result, please include the following metadata: unique sender identification; unique recipient identification; date and time of transmission; and document(s) sufficient to show the full name of the officer associated with the unique identification. An example of unique sender/recipient identification would, in the case of a car-to-car instant message, be some kind of username corresponding to an officer, or, if and only if an officer identifier is not extant, an identifier for a particular computer or patrol car.6. Documents that provide evidence of any search your jurisdiction that either the department itself or the public body of which it’s a part has undertaken, in the five years prior to the date of this request, for racist, race-biased, or white supremacist terminology. This would include any searches undertaken of text messages, emails, or instant messages, for example, those IMs to and from in-car computers. It need not include an internal investigation of any single officer. Rather, we seek documents that show a search of communications to/from groups of officers, ranging up to the entire department. We seek documents that show the date of the search; the rationale or reason for the search; the search terms used; the name of the public official who requested the search; the total number of officers whose communications were searched (and if a subset of a department, the reason for choosing that subset); the type of communications searched; and any summary of the result(s) of any search. If no document exists that can be construed as a summary of search results, we request the full results of any search.Please take under advisement:Communications that contain these terms, if in use by a law enforcement officer, are public and not personal records. Police officers interact directly with a diverse public and any expressions of potentially prejudicial or biased sentiments relate directly to an officer’s job responsibilities and performance. They are undoubtedly subject to disclosure. In the event you cite an ongoing investigation as a reason for withholding a particular record, we ask, as a part of this records request, for a document that shows the date (nothing more) of the last internal communication in the investigation.Nearly every state, yours included, defines a public record as any record that a public body is in “control” of, not just in the “possession” of. This provides for situations where records are stored in the care of a third-party storage facility, or some kind of technology vendor that provides data storage or communications services to the public body in question. To the extent a technology vendor is in possession of the records sought herein, this request, barring justified exemption, compels the public body to seek the requested documents from its technology vendor.Should a FOIA officer have one or more questions about the request, please contact Brandon Smith via phone (740-505-0038) or the email address this request was sent from. Mr. Smith would be happy to hear from you.It is not Mr. Smith’s wish to overburden your office. An email or phone call is probably in order soon to discuss your office’s standard for how much estimated time—say, for review toward redaction—constitutes an unduly burdensome request. That said, we believe the list of search terms contained herein is sufficiently culled to produce only a reasonably number of responsive records.Rarely does caselaw on what is and is not overly burdensome specify which type of employee is required for processing; the only relevant factor is estimated time by *a* staff member. In other words, if a search would be impossible or overly burdensome for a FOIA staffer, but an IT staffer can do it in ten minutes, then the law requires the public body to request an IT staffer complete the job. This is our purpose in asking for documents showing what type of database each record is stored in: the type of file determines what type of search is possible by a qualified IT staffer.This request is being made on behalf of Brandon Smith and on behalf of ProPublica.Search terms list:nigger spic coon monkey white power white genocide 1488 14/88 14 words fourteen words mud people boot party Curb job hammerskin hammer skin Vinlanders Blood & Honour Blood & Honor Blood and honor Gab mein heil Reich Muslim problem White genocide White civil rights Knights Filthy jew Aryan Confederate flag Dixie Diversity is a code word Globalist fashy Chimp out Chimpout Goy Kek shekels Kike TRS Shills Identitarian Stormfront Daily Stormer Identity Evropa Identity Europa Cultural marxist Anti-white White identity Jewish Question JQ ZOG Klansman White pride WPWW Rahowa Ghost skinThe 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,Brandon SmithFiled via MuckRock.com E-mail (Preferred): requests@muckrock.com Upload documents directly: https://www.muckrock.comhttps://www.muckrock.com/ Is this email coming to the wrong contact? Something else wrong? Use the above link to let us know.For mailed responses, please address (see note): MuckRock News DEPT MR 71027 411A Highland Ave Somerville, MA 02144-2516PLEASE NOTE: This request is not filed by a MuckRock staff member, but is being sent through MuckRock by the above in order to better track, share, and manage public records requests. Also note that improperly addressed (i.e., with the requester's name rather than "MuckRock News" and the department number) requests might be returned as undeliverable.
Chicago Police Department (CPD) responds to all public records requests in accordance with the Illinois Freedom of Information Act (FOIA), 5 ILCS 140/1 et seq.  If further time is needed to assemble and copy all documents responsive to your FOIA request, we will contact you with a time estimate and a request to extend. You can monitor the progress of your request at the link below and you’ll receive an email when your request has been completed. Thank you for using the Chicago FOIA Center.
To monitor the progress or update this request please log into the Chicago Public Safety Record System. (https://u8387778.ct.sendgrid.net/wf/click?upn=xSfKPyHO1-2F4Mny2NCLJVulVO5zgaUYhAxXpmsXAhNKLIDBByxt-2BcapQSrFnKhQuogBHGvLRy8X00WcQGJOPxxt1FR5IcdMLOJ6m9mQ7KGZ7fAYanKuFjeyqE6-2BAbAprv_OPLp48-2FBw5PP-2FPp2TL2uyo-2BWKKgJ8StTP0gy7nOXG1soEo6IGAhJAN95NfksgzuKN2K1lCpcOQX-2BJb7zGVcUIf-2Bco03r7SONyz08ck8YRiyGwZIKchYFucwr4u8d2uwcpOuzxcYPldqhMHSQoY58-2BpOe2xB4jnZRRpsvIDZKRTQ7yfz1IQECYBoAW5xBgAGqoeW6odw6TG-2BKJso8gIrogzadiYzAlg-2FPkhIY18-2F8oR-2FZin05Prbbmq0RjUTG1GpisObU5mIw3WbWgn8X5-2BHfAzgNd-2Fta5e6vWunWd5b9gqVZ3cq-2B903RhUTF8C8HLpgNSK4opyMaY2OI-2F6fJYM3T7AcgjBk9PgicprdwB00lmHTBjsqDJhFqmRT2nDg45-2BlNDjLAHvsnPHehPXgn1lINpg-3D-3D)

--- Please respond above this line ---

04/15/2019
HICAGO OLICE EPARTMENT
CITY OF CHICAGO
Brnadon Smith
Chicago IL 606
RE: FOIA REQUEST of April 15, 2019, Reference # P483059-041519
Dear Brnadon:
The Chicago Police Department is in receipt of your Freedom of Information Act (FOIA) request. On April 15, 2019, the following request was received. Pursuant to the Illinois Freedom of Information Act., I hereby request the following records:

1. Documents that show what kind of a database your agency's email is stored in (such as Microsoft Access; Oracle; Microsoft Sharepoint; SQL; or Microsoft Exchange).

2a. Documents sufficient to show any FOIA management software or email search software (not including the client one uses to read and reply to email) in use by your agency. These documents could include purchase orders, contracts for use of a service, or—if and only if neither of those are available—some departmental communication portraying the name of the system.

2b. Any vendor-provided manuals or instructions or software documentation for software used by the agency to search emails

2c. Complete copies of any rules, guidelines, instructions, or best practices in use by your agency for searching emails and texts in response to FOIA requests

3. Documents that show all of, and represent the entirety of each of, your agency’s contracts with cell/mobile service providers (sometimes called carriers). Also we request any documents that describe a deletion schedule for text messages sent to/from the devices on your agency's provider contract. For this purpose, "deletion schedule" means a number of days before messages are regularly deleted from the carrier's data repositories. Such a schedule would also specify whether that date is a rolling daily deletion after that many days, or rather periodical, where the number of days represents the period.

4a. Keyword searches of all SMS ("text") records sent to and received by all sworn officers on agency-issued mobile devices

4b. Keyword searches of all emails sent to and received by sworn officers on agency email accounts.

- For the keywords on 4a and 4b, please refer to the list at the bottom of this request. Date range is four months prior to the date of the request until the date of the request. Please provide the requesters evidence that your search was agnostic toward capital and lowercase letters throughout each searched character string.

- For each returned *email or SMS* result, please include the following metadata: unique sender identification; unique recipient identification; date and time of transmission; and document(s) sufficient to show the full name of the officer associated with the unique identifier. (An example of unique sender/recipient identification would be an email address or a phone number, depending on the type of record.)

5a. Documents that show what, if any, text-based messaging clients or platforms (you might call them software-based “systems” for messaging, or “instant messaging”) are available for use on computers in your patrol cars. Also we request documents that show what public body maintains or is responsible for each of those clients/platforms. For instance, sometimes a messaging system is maintained and offered by a state agency like highway patrol; other systems are built or contracted-for locally, by your jurisdiction itself. We request the above-described documents on any and all messaging systems deployed on a computer in a police vehicle in your jurisdiction.

If your jurisdiction maintains/provides its own software on in-car computers for "instant messaging”—and therefore is the keeper of records associated with the system, including historic message logs—I request:

5b. Documents sufficient to show what kind of a database that messages crossing the in-car messaging system are stored in. (Examples might be Microsoft Access; Oracle; SQL or similar). The file extension of the message logs will suffice.

5d. Keyword searches of databases containing messages sent and received over the in-car computers' instant messaging system. For the keywords that requester(s) would like searched, please refer to the list at the bottom of this request. Date range is four months prior to the date of the request until the date of the request. Please provide the requesters evidence that your search was agnostic toward capital and lowercase letters throughout each searched character string.

- For each returned *in-car IM* result, please include the following metadata: unique sender identification; unique recipient identification; date and time of transmission; and document(s) sufficient to show the full name of the officer associated with the unique identification. An example of unique sender/recipient identification would, in the case of a car-to-car instant message, be some kind of username corresponding to an officer, or, if and only if an officer identifier is not extant, an identifier for a particular computer or patrol car.

6. Documents that provide evidence of any search your jurisdiction that either the department itself or the public body of which it’s a part has undertaken, in the five years prior to the date of this request, for racist, race-biased, or white supremacist terminology. This would include any searches undertaken of text messages, emails, or instant messages, for example, those IMs to and from in-car computers. It need not include an internal investigation of any single officer. Rather, we seek documents that show a search of communications to/from groups of officers, ranging up to the entire department. We seek documents that show the date of the search; the rationale or reason for the search; the search terms used; the name of the public official who requested the search; the total number of officers whose communications were searched (and if a subset of a department, the reason for choosing that subset); the type of communications searched; and any summary of the result(s) of any search. If no document exists that can be construed as a summary of search results, we request the full results of any search.

Please take under advisement:

Communications that contain these terms, if in use by a law enforcement officer, are public and not personal records. Police officers interact directly with a diverse public and any expressions of potentially prejudicial or biased sentiments relate directly to an officer’s job responsibilities and performance. They are undoubtedly subject to disclosure. In the event you cite an ongoing investigation as a reason for withholding a particular record, we ask, as a part of this records request, for a document that shows the date (nothing more) of the last internal communication in the investigation.

Nearly every state, yours included, defines a public record as any record that a public body is in “control” of, not just in the “possession” of. This provides for situations where records are stored in the care of a third-party storage facility, or some kind of technology vendor that provides data storage or communications services to the public body in question. To the extent a technology vendor is in possession of the records sought herein, this request, barring justified exemption, compels the public body to seek the requested documents from its technology vendor.

Should a FOIA officer have one or more questions about the request, please contact Brandon Smith via phone (740-505-0038) or the email address this request was sent from. Mr. Smith would be happy to hear from you.

It is not Mr. Smith’s wish to overburden your office. An email or phone call is probably in order soon to discuss your office’s standard for how much estimated time—say, for review toward redaction—constitutes an unduly burdensome request. That said, we believe the list of search terms contained herein is sufficiently culled to produce only a reasonably number of responsive records.

Rarely does caselaw on what is and is not overly burdensome specify which type of employee is required for processing; the only relevant factor is estimated time by *a* staff member. In other words, if a search would be impossible or overly burdensome for a FOIA staffer, but an IT staffer can do it in ten minutes, then the law requires the public body to request an IT staffer complete the job. This is our purpose in asking for documents showing what type of database each record is stored in: the type of file determines what type of search is possible by a qualified IT staffer.

This request is being made on behalf of Brandon Smith and on behalf of ProPublica.

Search terms list:

nigger
spic
coon
monkey
white power
white genocide
1488
14/88
14 words
fourteen words
mud people
boot party
Curb job
hammerskin
hammer skin
Vinlanders
Blood & Honour
Blood & Honor
Blood and honor
Gab
mein
heil
Reich
Muslim problem
White genocide
White civil rights
Knights
Filthy jew
Aryan
Confederate flag
Dixie
Diversity is a code word
Globalist
fashy
Chimp out
Chimpout
Goy
Kek
shekels
Kike
TRS
Shills
Identitarian
Stormfront
Daily Stormer
Identity Evropa
Identity Europa
Cultural marxist
Anti-white
White identity
Jewish Question
JQ
ZOG
Klansman
White pride
WPWW
Rahowa
Ghost skin

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,

Brandon Smith

Filed via MuckRock.com
E-mail (Preferred): requests@muckrock.com
Upload documents directly: https://www.muckrock.comhttps://www.muckrock.com/
Is this email coming to the wrong contact? Something else wrong? Use the above link to let us know.

For mailed responses, please address (see note):
MuckRock News
DEPT MR 71027
411A Highland Ave
Somerville, MA 02144-2516

PLEASE NOTE: This request is not filed by a MuckRock staff member, but is being sent through MuckRock by the above in order to better track, share, and manage public records requests. Also note that improperly addressed (i.e., with the requester's name rather than "MuckRock News" and the department number) requests might be returned as undeliverable.
Under the Freedom of Information Act, a public body may extend the time to respond to a FOIA request by up to 5 business days for a limited number of reasons. 5 ILCS 140/3(e). We are extending the time to respond to your request by 5 business days for the following reason(s):
The requested records are stored in whole or in part at other locations than the office having charge of the requested records;
There is need for consultation, which shall be concluded with all practicable speed, with another public body or among two or more components of a public body having a substantial interest in the determination or in the subject matter of the request.
If you have any questions, please contact our office at 312-745-5308 or at the following address: Chicago Police Department Attention: Freedom of Information Officer Office of Legal Affairs, Unit 114 3510 S. Michigan Ave. Chicago, IL 60653
Sincerely, AUDREY SHULRUFF
Freedom of Information Officer
Chicago Police Department

--- Please respond above this line ---

04/15/2019
HICAGO OLICE EPARTMENT
CITY OF CHICAGO
Brnadon Smith
Chicago IL 606
RE: FOIA REQUEST of April 15, 2019, Reference # P483059-041519
Dear Brnadon:
The Chicago Police Department is in receipt of your Freedom of Information Act (FOIA) request. On April 15, 2019, the following request was received. Pursuant to the Illinois Freedom of Information Act., I hereby request the following records:

1. Documents that show what kind of a database your agency's email is stored in (such as Microsoft Access; Oracle; Microsoft Sharepoint; SQL; or Microsoft Exchange).

2a. Documents sufficient to show any FOIA management software or email search software (not including the client one uses to read and reply to email) in use by your agency. These documents could include purchase orders, contracts for use of a service, or—if and only if neither of those are available—some departmental communication portraying the name of the system.

2b. Any vendor-provided manuals or instructions or software documentation for software used by the agency to search emails

2c. Complete copies of any rules, guidelines, instructions, or best practices in use by your agency for searching emails and texts in response to FOIA requests

3. Documents that show all of, and represent the entirety of each of, your agency’s contracts with cell/mobile service providers (sometimes called carriers). Also we request any documents that describe a deletion schedule for text messages sent to/from the devices on your agency's provider contract. For this purpose, "deletion schedule" means a number of days before messages are regularly deleted from the carrier's data repositories. Such a schedule would also specify whether that date is a rolling daily deletion after that many days, or rather periodical, where the number of days represents the period.

4a. Keyword searches of all SMS ("text") records sent to and received by all sworn officers on agency-issued mobile devices

4b. Keyword searches of all emails sent to and received by sworn officers on agency email accounts.

- For the keywords on 4a and 4b, please refer to the list at the bottom of this request. Date range is four months prior to the date of the request until the date of the request. Please provide the requesters evidence that your search was agnostic toward capital and lowercase letters throughout each searched character string.

- For each returned *email or SMS* result, please include the following metadata: unique sender identification; unique recipient identification; date and time of transmission; and document(s) sufficient to show the full name of the officer associated with the unique identifier. (An example of unique sender/recipient identification would be an email address or a phone number, depending on the type of record.)

5a. Documents that show what, if any, text-based messaging clients or platforms (you might call them software-based “systems” for messaging, or “instant messaging”) are available for use on computers in your patrol cars. Also we request documents that show what public body maintains or is responsible for each of those clients/platforms. For instance, sometimes a messaging system is maintained and offered by a state agency like highway patrol; other systems are built or contracted-for locally, by your jurisdiction itself. We request the above-described documents on any and all messaging systems deployed on a computer in a police vehicle in your jurisdiction.

If your jurisdiction maintains/provides its own software on in-car computers for "instant messaging”—and therefore is the keeper of records associated with the system, including historic message logs—I request:

5b. Documents sufficient to show what kind of a database that messages crossing the in-car messaging system are stored in. (Examples might be Microsoft Access; Oracle; SQL or similar). The file extension of the message logs will suffice.

5d. Keyword searches of databases containing messages sent and received over the in-car computers' instant messaging system. For the keywords that requester(s) would like searched, please refer to the list at the bottom of this request. Date range is four months prior to the date of the request until the date of the request. Please provide the requesters evidence that your search was agnostic toward capital and lowercase letters throughout each searched character string.

- For each returned *in-car IM* result, please include the following metadata: unique sender identification; unique recipient identification; date and time of transmission; and document(s) sufficient to show the full name of the officer associated with the unique identification. An example of unique sender/recipient identification would, in the case of a car-to-car instant message, be some kind of username corresponding to an officer, or, if and only if an officer identifier is not extant, an identifier for a particular computer or patrol car.

6. Documents that provide evidence of any search your jurisdiction that either the department itself or the public body of which it’s a part has undertaken, in the five years prior to the date of this request, for racist, race-biased, or white supremacist terminology. This would include any searches undertaken of text messages, emails, or instant messages, for example, those IMs to and from in-car computers. It need not include an internal investigation of any single officer. Rather, we seek documents that show a search of communications to/from groups of officers, ranging up to the entire department. We seek documents that show the date of the search; the rationale or reason for the search; the search terms used; the name of the public official who requested the search; the total number of officers whose communications were searched (and if a subset of a department, the reason for choosing that subset); the type of communications searched; and any summary of the result(s) of any search. If no document exists that can be construed as a summary of search results, we request the full results of any search.

Please take under advisement:

Communications that contain these terms, if in use by a law enforcement officer, are public and not personal records. Police officers interact directly with a diverse public and any expressions of potentially prejudicial or biased sentiments relate directly to an officer’s job responsibilities and performance. They are undoubtedly subject to disclosure. In the event you cite an ongoing investigation as a reason for withholding a particular record, we ask, as a part of this records request, for a document that shows the date (nothing more) of the last internal communication in the investigation.

Nearly every state, yours included, defines a public record as any record that a public body is in “control” of, not just in the “possession” of. This provides for situations where records are stored in the care of a third-party storage facility, or some kind of technology vendor that provides data storage or communications services to the public body in question. To the extent a technology vendor is in possession of the records sought herein, this request, barring justified exemption, compels the public body to seek the requested documents from its technology vendor.

Should a FOIA officer have one or more questions about the request, please contact Brandon Smith via phone (740-505-0038) or the email address this request was sent from. Mr. Smith would be happy to hear from you.

It is not Mr. Smith’s wish to overburden your office. An email or phone call is probably in order soon to discuss your office’s standard for how much estimated time—say, for review toward redaction—constitutes an unduly burdensome request. That said, we believe the list of search terms contained herein is sufficiently culled to produce only a reasonably number of responsive records.

Rarely does caselaw on what is and is not overly burdensome specify which type of employee is required for processing; the only relevant factor is estimated time by *a* staff member. In other words, if a search would be impossible or overly burdensome for a FOIA staffer, but an IT staffer can do it in ten minutes, then the law requires the public body to request an IT staffer complete the job. This is our purpose in asking for documents showing what type of database each record is stored in: the type of file determines what type of search is possible by a qualified IT staffer.

This request is being made on behalf of Brandon Smith and on behalf of ProPublica.

Search terms list:

nigger
spic
coon
monkey
white power
white genocide
1488
14/88
14 words
fourteen words
mud people
boot party
Curb job
hammerskin
hammer skin
Vinlanders
Blood & Honour
Blood & Honor
Blood and honor
Gab
mein
heil
Reich
Muslim problem
White genocide
White civil rights
Knights
Filthy jew
Aryan
Confederate flag
Dixie
Diversity is a code word
Globalist
fashy
Chimp out
Chimpout
Goy
Kek
shekels
Kike
TRS
Shills
Identitarian
Stormfront
Daily Stormer
Identity Evropa
Identity Europa
Cultural marxist
Anti-white
White identity
Jewish Question
JQ
ZOG
Klansman
White pride
WPWW
Rahowa
Ghost skin

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,

Brandon Smith

Filed via MuckRock.com
E-mail (Preferred): requests@muckrock.com
Upload documents directly: https://www.muckrock.comhttps://www.muckrock.com/
Is this email coming to the wrong contact? Something else wrong? Use the above link to let us know.

For mailed responses, please address (see note):
MuckRock News
DEPT MR 71027
411A Highland Ave
Somerville, MA 02144-2516

PLEASE NOTE: This request is not filed by a MuckRock staff member, but is being sent through MuckRock by the above in order to better track, share, and manage public records requests. Also note that improperly addressed (i.e., with the requester's name rather than "MuckRock News" and the department number) requests might be returned as undeliverable.
Under the Freedom of Information Act, a public body may extend the time to respond to a FOIA request by up to 5 business days for a limited number of reasons. 5 ILCS 140/3(e). We are extending the time to respond to your request by 5 business days for the following reason(s):
The requested records are stored in whole or in part at other locations than the office having charge of the requested records;
There is need for consultation, which shall be concluded with all practicable speed, with another public body or among two or more components of a public body having a substantial interest in the determination or in the subject matter of the request.
If you have any questions, please contact our office at 312-745-5308 or at the following address: Chicago Police Department Attention: Freedom of Information Officer Office of Legal Affairs, Unit 114 3510 S. Michigan Ave. Chicago, IL 60653
Sincerely, AUDREY SHULRUFF
Freedom of Information Officer
Chicago Police Department

Please be advised that for this FOIA request the date of receipt is April 15, 2019 (email received Sunday, April 14, 2019 at 9:59p.m.) and is being processed under FOIA # P483059. Attached is a copy of your emailed original request submitted on April 14, 2019 ( Not March 27, 2019.)

CPD FOIA Section.

This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering that message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this document is strictly prohibited.

Here is the attachment.

Please be advised that for this FOIA request the date of receipt is April 15, 2019 (email received Sunday, April 14, 2019 at 9:59p.m.) and is being processed under FOIA # P483059. Attached is a copy of your emailed original request submitted on April 14, 2019 ( Not March 27, 2019.)

CPD FOIA Section.

This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering that message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this document is strictly prohibited.

Dear Mr. Smith,

Please see attached for the response to your FOIA request.

Thank you,

Audrey Shulruff, FOIA Officer

Chicago Police Department

Office of Legal Affairs, Unit 114

3510 S. Michigan Ave.

Chicago, IL 60653

312-745-5308

________________________________
This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail (or the person responsible for delivering this document to the intended recipient), you are hereby notified that any dissemination, distribution, printing or copying of this e-mail, and any attachment thereto, is strictly prohibited. If you have received this e-mail in error, please respond to the individual sending the message, and permanently delete the original and any copy of any e-mail and printout thereof.

Dear Mr. Smith,

I am still waiting for one unit to get back to me with whether or not there are records responsive to your request. I will be in touch on or before May 20, 2019.

Thank you,

Audrey

Good Afternoon Mr. Smith,

I have not yet received a response regarding responsive records to your request. I will be in touch either way on or before May 28, 2019.

Thank you,

Audrey

Good Afternoon Mr. Smith,

I am waiting to hear about one more part of your request and will be in touch with you on or before June 4, 2019.

Thank you,

Audrey

Hello,

I have followed up with the unit that I have been waiting for the rest of the responsive records and they will be getting back to me. I will be in touch with you either way on or before June 11, 2019.

Thank you,

Audrey

My apologies for the delay. I have followed up, but am still waiting for one additional record. I will be in touch either way on or before June 18, 2019.

Thank you,

Audrey

Dear Mr. Smith,

Please see attached for the final response to your FOIA request.

Thank you,

Audrey Shulruff, FOIA Officer

Chicago Police Department

Office of Legal Affairs, Unit 114

3510 S. Michigan Ave.

Chicago, IL 60653

312-745-5308

________________________________
This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail (or the person responsible for delivering this document to the intended recipient), you are hereby notified that any dissemination, distribution, printing or copying of this e-mail, and any attachment thereto, is strictly prohibited. If you have received this e-mail in error, please respond to the individual sending the message, and permanently delete the original and any copy of any e-mail and printout thereof.

Attachments:
14837-P561009-IndividualsShotByCPD.xlsx (https://u8387778.ct.sendgrid.net/ls/click?upn=6HtRfOYLt5fXvpttM-2FU1HQBImk7-2Bynhw89FmPm6yuaXuCPDmqJYvRk2B47aEBbNS7w8Zw1ahmZAaRtJcdkbt0qKx4xRxKUvq3uu5Q1tWoqm4TPfsUsIg9mB7wGKGjFrIdc8BSpSqtbRqwMRPL8yo-2Bjyo-2F66u4-2BRDpHpb0B9i6QXwFYTbngImGh2mDU-2FB-2B79I8REx8HArwd-2FNuBhO3ykz7Q-3D-3DGkuq_NO3OA1B73rBLKHiQbMMm94uM5bb7JKOiDvieLMgqWaIxxrF8cM3EZu5dDTYkNY-2B2dwQLFjbl01-2F-2Ft9i3DhyfbQPd3yk27eTBHqKbS6-2BgDITwbmvr4R9rJhKKyRA14TZEfdKtZTWzrYKP9Ld8Kw8lDsLQn-2BNldiBPRohKQtrmCxqZg5sEjTVJQIha-2FfdlgE-2FS5FaySm-2BrDQNP2uG3NPFTjT-2F1rsHKMY-2FDupPC3zdIKR9t3Ls22F3TwQZE-2Byxi65UjLG01hIH0QV0odLrYAmo2loT0h7Ku9ZNmdqN98zPJm4A-2FL7HUscZzB2PeO826q-2BjrfDgpy1e0dTlV3-2FTRtc0B4SGbBIDwNAWpWd1pcM9VI9285WaV8Z935GWgtUyY241wddSjVXIlQbUVsM71nTAnCofcMQntU4LxH2Q6P7zCWKg-3D)
P561009_Response_Letter.pdf (https://u8387778.ct.sendgrid.net/ls/click?upn=6HtRfOYLt5fXvpttM-2FU1HQBImk7-2Bynhw89FmPm6yuaXuCPDmqJYvRk2B47aEBbNS7w8Zw1ahmZAaRtJcdkbt0qKx4xRxKUvq3uu5Q1tWoqm4TPfsUsIg9mB7wGKGjFrIdc8BSpSqtbRqwMRPL8yo-2Bq29qwH0Lyia5MjfmYVbzA4VJaPwdEv339AVFO9eUw7n6Xkpd7LNUDM1bhcK70PeJg-3D-3Dhtrd_NO3OA1B73rBLKHiQbMMm94uM5bb7JKOiDvieLMgqWaIxxrF8cM3EZu5dDTYkNY-2B2dwQLFjbl01-2F-2Ft9i3DhyfbQPd3yk27eTBHqKbS6-2BgDITwbmvr4R9rJhKKyRA14TZEfdKtZTWzrYKP9Ld8Kw8lDsLQn-2BNldiBPRohKQtrmCxqZg5sEjTVJQIha-2FfdlgE-2FS5FaySm-2BrDQNP2uG3NPFTjT-2F1rsHKMY-2FDupPC3zdIKR9t3Ls22F3TwQZE-2Byxi65Uj8XJvpfP1lhZz2lXZDW-2BRaNH7HizP67IdYddwuF21sZl0JQm7yRBmZaAFuS4Rf-2Fk34im88NLSqUMMDsjO2zM7NTuV-2B0FXzgCk03rlb0XKdh3MJmKbuuBeHdZyVEZccbsi9fKmiu4NmhnoBAJvXxChONitJAGdwWsfpxnM2nC5H5I-3D)

--- ---

Good afternoon, attached is a record and letter pertaining to your FOIA request.