Spreadsheet: 772321d1647199153-vlookup-on-a-different-worksheet-and-a-nested-if-function-cities-using-ssti
Sheet: ShotSpotter Alerts 

Date | Source | City | Positive | Negative | Size of Force | Contract Size | New | Expansion | Funding | [NAME] | Commentary
 | News Article | Toledo, Ohio | Yes |  |  |  | No | Yes | Toledo Police Foundation grant | 0.97 | 102 arrests and 77 firearms confiscations so far
 | News Article | Oakland, CA | Yes |  |  |  | No |  |  |  | Article mentioned it led to body
 |  | Oakland, CA | Yes |  |  |  |  |  |  |  | Shotspotter activations are up 119% over last year, with two-thirds of the 3,924 activations occurring in East Oakland.
 | News Article | East Oakland, CA | Yes |  |  |  |  |  |  |  | ShotSpotter alerts recorded more than 20 shots being fired and numerous shell casings were recovered at the scene.
2021-06-13 00:00:00 | Eas | East Oakland, CA | Yes |  |  |  |  |  |  |  | More than 20 shots were fired, according to ShotSpotter alerts, authorities said.
 | News Article | Pittsburgh, PA | Yes |  |  |  | No |  |  |  | Article mentioned led to [NAME]
 |  | Pittsburgh, PA | Yes |  |  |  |  |  |  |  | Article mentioned it led to body
2021-06-19 00:00:00 |  | Pittsburgh, PA | Yes |  |  |  |  |  |  |  | Article mentioned it led to bodies
2021-06-19 00:00:00 |  | Pittsburgh, PA | Yes |  |  |  |  |  |  |  | Article mentioned it led to two women shot
2021-06-17 00:00:00 |  | Pittsburgh, PA | Yes |  |  |  |  |  |  |  | Article mentioned SSTI led to figuring out gun fight in dispute
 | News Article | Sacramento, CA | Yes |  |  |  | No |  |  |  | Article mentioned it led to body
 | News Article | Birmingham, AL | Yes |  |  |  | No |  |  |  | Article mentioned will use SSTI to crackdown on July 4th -shooting in air
 | News Article | St. Louis, MO |  | Yes |  |  | No |  |  |  | Article mentions they use SSTI + cameras BUT new bill may derail any expansion because of privacy concerns
 | News Article | Baltimore, MD | Yes |  |  |  | No |  |  |  | Using SSTI to track where guns are coming from
2021-06-19 00:00:00 | News Article | Baltimore, MD | Yes |  |  |  | No |  |  |  | So far this year, 158 people have been killed in Baltimore, and 320 others have been shot and injured, according to police data.
 | News Article | Columbus, OH | Yes |  |  |  | No |  |  |  | Used SSTI for gunshot detection
 | News Article | Fort Lauderdale, FL | Yes |  |  |  | No |  |  |  | Used SSTI for gunshot detection - city hall windows blown out
 | News Article | Brooklyn, NY | Yes |  |  |  | No |  |  |  | Article mentioned it led to body
 | News Article | Springfield, MA | Yes |  |  |  | No |  |  |  | Article mentioned Mayor against gun violence; SSTI + cameras
 | News Article | Hartford, CT | Yes |  |  |  | No |  |  |  | Article mentioned it led to body
2021-06-10 00:00:00 | News Article | East Hartford, CT | Yes |  |  |  | No |  |  |  | the gunfire registered on the city’s ShotSpotter gunshot detection system. Detectives scoured the scene for evidence and served
 | News Article | Boston, MA | Yes |  |  |  | No |  |  |  | SSTI gunshot detection BUT also was called in
2021-06-19 00:00:00 | News Article | West Palm Beach, FL | Yes |  |  |  | No |  |  |  | Led to victim
2021-06-17 00:00:00 | News Article | Fresno, CA | Yes |  |  |  | No |  |  |  | Lt . [NAME] said the department's ShotSpotter system recorded several gunshots in the area, and located a gunshot victi
2021-06-16 00:00:00 | News Article | Chicago, IL | Yes |  |  |  | No |  |  |  | SSTI used by prosecutors in court
2021-06-15 00:00:00 | News Article | Chicago, IL | Yes |  |  |  | No |  |  |  | Police responded to second round of shots heard by SSTI
2021-06-11 00:00:00 | News Article | Chicago, IL | Yes |  |  |  | No |  |  |  | About 1:45 p.m., officers responded to an alert from ShotSpotter, the city’s gunshot detection system, of 10 rounds
2021-06-11 00:00:00 | News Article | Chicago, IL | Yes |  |  |  | No |  |  |  | r, and after officers responded to an alert from ShotSpotter, the city’s gunshot detection system, they found three shell casings and began looking for the shooter, who, according to the video
2021-06-14 00:00:00 | News Article | Bridgeport, CT |  |  |  |  |  |  |  |  | Someone called in shots+ SSTI alert
2021-06-14 00:00:00 | News Article | Salinas, CA | Yes |  |  |  | No |  |  |  | SSTI alert - found victim |  |  |  |  |  |  |  | https://www.ksbw.com/article/salinas-police-investigating-early-morning-attempted-murder/36718912#
6/13/2021 but for may 7 | News Article | Worcester, [NAME] | Yes |  |  |  |  |  |  |  | On May 7, officers responding to an activation of the city's ShotSpotter gunfire detection system found a 16-year-old with a gunshot wound.
2021-06-09 00:00:00 | News Article | Syracuse, NY | Yes |  |  |  | No |  |  |  | SSTI alert But also someone called in
2021-06-08 00:00:00 | News Article | Miami Dade, FL | Yes |  |  |  | No |  |  |  | Miami-Dade officers responded after receiving a ShotSpotter alert, which tells police when there's gunfire in an area
2021-06-08 00:00:00 | News Article | Oakland, CA | Yes |  |  |  | No |  |  |  | Two different SSTI alerts lead to two different arrests. Second activiation with video. |  |  |  |  |  |  |  | https://www.oaklandca.gov/news/2021/shotspotter-activations-lead-to-arrests-and-recovered-firearm
2021-06-20 00:00:00 | News Article | East Palo Alto | Yes |  |  |  | No |  |  |  | ShotSpotter activiations up y/y |  |  |  |  |  |  |  | https://www.mercurynews.com/2021/06/20/mass-shootings-are-on-the-rise-in-oakland-with-five-so-far-in-2021/
2021-05-23 00:00:00 | News Article | East Palo Alto | Yes |  |  |  |  |  |  |  | [NAME] led to victim |  |  |  |  |  |  |  | https://sanfrancisco.cbslocal.com/2021/05/24/man-shot-dead-in-east-palo-alto/
2021-05-25 00:00:00 | News Article | [NAME], TN | Yes |  |  |  | No |  |  |  | Alert but also call |  |  |  |  |  |  |  | https://www.wbbjtv.com/2021/05/25/police-investigating-shooting-at-local-apartment-complex/
2021-06-01 00:00:00 | News Article | Richmond, CA | No | Yes |  |  |  |  |  |  | Chopping 14% or $10.3m from police budget would include eliminating SSTI
 |  | Richmond, CA | Yes |  |  |  | No |  |  |  | [NAME] led to victim |  |  |  |  |  |  |  | https://climaterwc.com/2021/06/01/24254/
2021-04-01 00:00:00 |  | Fort Lauderdale, FL | Yes | No |  |  | No |  |  |  | Alert let do arrests |  |  |  |  |  |  |  | [NAME]