Spreadsheet: 772321d1647199153-vlookup-on-a-different-worksheet-and-a-nested-if-function-cities-using-ssti
Sheet: Total City List

 | https://www.shotspotter.com/cities/ |  |  |  |  | 2021-06-28 00:00:00
 | 123 cities using ShotSpotter
 |  |  | Positive News | News |  |  |  |  |  | Article
1 | Birmingham | AL | Yes |  |  |  |  |  |  |  |  |  |  |  |  | Nassau | Bahamas
 | Montgomery | AL | NA |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | South Africa
 | Hot Spring | AR |  | New! |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Puerto Rico
 | Little Rock | AR | Yes | In February the City Board of Directors voted to extend the city’s contract with ShotSpotter for two years. So far the cost of the program has been covered by grants, but as of next year the program will cost taxpayers around $150,000. Mayor wants to expand; other councilmembers don't want it. |  |  |  |  |  | https://www.kark.com/news/working4you/little-rock-city-board-at-odds-over-shotspotter-cost-effectiveness/ |  |  |  |  |  | San Juan | Puerto Rico
 | Glendale | AZ | Yes | Contract since 2002 |  |  |  |  |  | https://www.12news.com/article/news/local/valley/glendale-police-department-shotspotter-technology/75-c2500e87-afa5-4a65-a183-434b45cc578c |  |  |  |  |  | [NAME] | Puerto Rico
 | Bakersfield | CA | Yes | Council unanimously agreed to renew and expand SSTI 3.19 miles in Nov. 2020 for three years |  |  |  |  |  | https://www.kget.com/news/local-news/bakersfield-city-council-approves-shotspotter-expansion/ |  |  |  |  |  | St. Croix | U.S. Virgin Islands
 | East Palo Alto | CA | Yes |  |  |  |  |  |  |  |  |  |  |  |  | St. Thomas | U.S. Virgin Islands
 | Fresno | CA | Yes
 | Oakland | CA | Yes | Articles mention ShotSpotter activations up significantly y/y
 | Redwood City | CA | Yes | This was ShotSpotter's FIRST city signed up.  Many articles about alerts. |  |  |  |  |  | [NAME]
 | Richmond | CA | No | June 2, 2021: Richmond police department facing what could be a 14% budget cut - including SSTI - defund police pressure. |  |  |  |  |  | https://sanfrancisco.cbslocal.com/2021/06/02/proposed-budget-cuts-could-cost-richmond-police-department-almost-2-dozen-officers/
 | Sacramento County | CA
 | Sacramento | CA
 | Salinas | CA | Yes | [NAME] led to victim
 | San Diego | CA | No | March 2021: the San Diego Police Department said it renewed its contract with ShotSpotter on a monthly rather than annual basis. |  |  |  |  |  | https://www.voiceofsandiego.org/topics/news/morning-report-shotspotters-uncertain-future/
 | San Francisco | CA
 | San Mateo County | CA
 | San Pablo | CA
 | Denver | CO
 | Bridgeport | CT | Yes | [NAME] led to victim and shell casings |  |  |  |  |  | https://www.ctpost.com/news/article/1-injured-in-Bridgeport-shooting-16224386.php
 | Hartford | CT
 | New Haven | CT
 | Washington DC | DC
 | [NAME] | DE
 | Broward County | FL
 | Fort Lauderdale | FL | Yes, but up for renewal in July 2021 | Miami was their reference. JULY 2020: City commissioners voted unanimously on contract in 2020: Four square miles. The first year of the program will be funded by a trust fund from the U.S. Department of Justice.  $595k. |  |  |  |  |  | https://www.wlrn.org/news/2020-07-08/fort-lauderdale-city-commissioners-approve-budget-changes-shotspotter-contract
 | [NAME] | FL | Yes | [NAME] Arrest and 10 year prison sentence |  |  |  |  |  | https://www.justice.gov/usao-mdfl/pr/fort-myers-felon-sentenced-ten-years-prison-discharging-firearm-apartment-complex
 | Gladeview | FL
 | Goulds | FL
 | Hallandale Beach | FL | NEW
 | Jacksonville | FL
 | Lake Park | FL
 | Miami | FL |  | Customer since 2014
 | Miami Gardens | FL
 | Miramar | FL
 | Palm Beach County | FL
 | Pompano Beach | FL
 | Riviera Beach | FL
 | Tampa | FL
 | West Palm Beach | FL
 | West Perrine | FL
 | Savannah | GA
 | Calumet City | IL
 | Chicago | IL
 | Freeport | IL
 | Kankakee | IL
 | North Chicago | IL
 | Peoria | IL
 | Rockford | IL
 | SpringfieldIL | IL
 | East Chicago | IN
 | South Bend | IN
 | Louisville | KY
 | Baton Rouge | LA | Yes | [NAME] for SSTI - East Baton Rouge Parish District Attorney [NAME] says some of those solutions can focus on fundraising for unmet needs within the law enforcement like ShotSpotter. |  |  |  |  |  | https://www.businessreport.com/business/justin-alfords-comments-on-crime-strike-chord-with-business-owners
 | Monroe | LA
 | Baltimore | MD
 | Boston | MA
 | Brockton | MA
 | Cambridge | MA
 | Chelsea | MA
 | [NAME] | MA
 | New Bedford | MA
 | Pittsfield | MA | Yes but was under attack
 | Revere | MA |  | 0
 | Somerville | MA |  | 0
 | Springfield | MA |  | 0
 | Worcester | MA |  | 0
 | Detroit | MI
 | Minneapolis | MN
 | Kansas City | MO
 | St. Louis | MO | No
 | STL County - Jennings | MO |  | 0
 | STL County - Moline Acres | MO
 | Goldsboro | NC
 | Greenville | NC
 | Rocky Mount | NC
 | [NAME] | NC
 | Winston-Salem | NC
 | Omaha | NE
 | Atlantic City | NJ
 | Camden | NJ
 | East Orange | NJ
 | [NAME] Park | NJ
 | [NAME] | NJ
 | Newark | NJ
 | Paterson | NJ
 | Plainfield | NJ
 | Pleasantville | NJ
 | Trenton | NJ
 | Albuquerque | NM | Yes
 | Las Vegas | NV
 | Nassau County - Elmont | NY
 | Nassau County - Freeport | NY
 | Nassau County - Roosevelt | NY
 | Nassau County - Uniondale | NY
 | Hempstead | NY
 | Long Beach | NY
 | Newburgh | NY | Yes | Field Report: Tried to eliminate to save police officers, but City Counsel would not allow.
 | New York City | NY | Yes | Expanding 8.8 miles with Federal Funds
 | Rochester | NY
 | Cincinnati | OH | Yes | 1) One possible version of ShotSpotter's future in Cleveland exists in Cincinnati. There, ShotSpotter operates hand-in-hand with perimeter searches of properties that have triggered alerts and conversations about the alert with residents and neighbors. Some say that's a model Cleveland ought to emulate. In that case, you are introducing a community component to your policing," Mares said. "[I]f you do that in a friendly way, rather than just pounding on people's doors, you create an understanding in the community…I think that could be effective." 2) Considering expansion: $250K for Winton Hills Shot Spotter |  |  |  |  |  | https://patch.com/ohio/cleveland/can-shotspotter-tech-be-solution
 | Cleveland | OH | Yes but one year left on test | Being tested: the service is now six months into a two-year pilot program in Cleveland's Fourth District. ShotSpotter appears to be working well. Fourth District Commander [NAME] said the system already has generated alerts in the test area that weren't otherwise reported and which saved the lives of four people and led to 27 gun-related arrests and 26 gun recoveries. |  |  |  |  |  | https://patch.com/ohio/cleveland/can-shotspotter-tech-be-solution
 | Columbus | OH
 | Dayton | OH | No | Some community members and local groups criticized police for deploying a ShotSpotter gunshot-alert system in northwest [NAME] and license plate readers in the Twin Towers area. By the end of each year, the Dayton Police Department will be required to present an annual surveillance report to the city commission describing how the technology and its generated data was used and its cost and effectiveness, |  |  |  |  |  | https://www.daytondailynews.com/local/just-in-dayton-imposes-regulations-on-police-surveillance-tech/A6V6CRMBEFHBVOJEOS6GHU7MVE/
 | Mansfield | OH | Yes | March 2021 started 1 year trial for 1 mile: Positive experience: Police chief said likely saved a life |  |  |  |  |  | https://www.richlandsource.com/news/mansfield-police-chief-says-shotspotter-may-have-helped-save-a-life/article_61ed3dc0-993b-11eb-8786-8bfb8020d1f5.html
 | Toledo | OH | Yes | Approved Expansion
 | Youngstown | OH | Yes | June 28, 2021: Members of the Youngstown City Council Safety Committee spoke recently about expanding SSTI, but cost was deemed too high. With rise in gun violence, the governor has said he will fund an expansion in Youngstown of SSTI.  Implies other cities but doesn't say: "is also proposing money for gunshot detection technologies and other local efforts to reduce gun violence, with $8 million in grants to establish and support law enforcement investigation centers that focus on cell phones and other evidence of firearm crimes." |  |  |  | https://www.dispatch.com/story/news/politics/state/2021/02/03/ohio-gov-mike-dewine-10-million-for-police-body-cameras-budget/[PHONE]/ |  | https://www.vindy.com/news/local-news/2021/06/mayor-says-dewine-will-help-youngstown-combat-violence/
 | McKeesport | PA | Yes - small city | Just started April 2021; announced by SSTI in december 2020 |  |  |  | https://pittsburgh.cbslocal.com/2021/04/19/city-of-mckeesport-begins-using-shotspotter-gunshot-detection-system/
 | Pittsburgh | PA
 | Columbia | SC | Yes | First SSTI user in state. Went live April 2018. The technology cost Columbia $1.18 million - six square miles. Columbia very focused on gun violence and just hired assistant U.S. attorney to focus on federal gun crimes. |  |  |  |  |  | https://www.thestate.com/news/local/article251897128.html |  |  |  |  |  |  | https://www.thestate.com/news/local/crime/article230253819.html
 | [NAME] | TN
 | Memphis | TN
 | Harris County | TX
 | Newport News | VA
 | Virginia Beach | VA
 | Milwaukee | WI