UKcrimestats.com

The leading crime and postcode data research and analysis platform

Sign Up   Log In
UK Crime Stats
  • Home
    • About Us
    • Problems with Crime Data
    • Data Disclaimer
  • FAQ
  • In The Media
  • National Picture
    • At A Glance
    • August Riots
  • View Crime
    • By Police Forces
      • All Police Forces
      • Total Officers
      • By Rank
      • By Neighbourhood
      • Police Stations
    • By Constituency
    • By Neighbourhood
    • By Street
    • By Subdivision
    • By Postcode Area
    • By Postcode District
    • By Postcode Sector
    • By LSOA
    • By MSOA
    • By Northern Ireland SOA
    • By Scottish Datazone
    • By Workplace Zone
  • Members
    • Members Area
    • Crime Analysis
    • Crime Analysis 2
    • Crime Heat map
  • Reports
  • Blog
    • Blog
    • Forum
  • Contact Us
Property :
  • National Picture
  • View
    • By Constituency
    • By Subdivision
    • By Postcode Area
    • By Postcode District
    • By Postcode Sector
    • By LSOA
    • By MSOA
    • By Workplace Zone
  • Analysis
    • Increase/Decrease
    • Highest/Lowest
  • Fusion
  •  Energy
 Energy
 

Police Officers by Neighbourhood

The 5,000 plus neighbourhoods of England and Wales vary greatly in size and in policing requirements as displayed by this page. All Police Officers displayed here belong to a Neighbourhood Team. We are aware that there are a number (unknown to us from the public crime data) of other Police Officers who work for the various forces who are not members of Neighbourhood Teams and so we are not displaying the full numbers of Police Officers, for each of the 43 Police Forces. There are just over 23,000 Neighbourhood Team Officers on the database in England and Wales but not all of them are of the same rank, work full-time or have an evenly distributed quantity or seriousness of crime to deal with. Some are even shared between neighbourhoods. Here you can see some of the results - for all of them, you will need to join UKCrimeStats and login.

Unknown column 't.fk_yearid' in 'on clause'

SELECT pf.title AS policeforce ,n.name AS neighbourhoodname ,n.lu_city ,n.lu_postcode ,COUNT(DISTINCT(t.fullname)) AS TeamSize FROM import_team_n2 t INNER JOIN neighbourhood n ON (n.neighbourhoodid = t.fk_neighbourhoodid) INNER JOIN policeforce pf ON (pf.forceid = t.fk_policeforceid) INNER JOIN crimeyear cy ON (cy.ID = t.fk_yearid) WHERE cy.ID =99 GROUP BY pf.title, n.name, n.lu_city, n.lu_postcode ORDER BY TeamSize DESC LIMIT 0,50