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.
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 =100 GROUP BY pf.title, n.name, n.lu_city, n.lu_postcode ORDER BY TeamSize DESC LIMIT 0,50