Law Enforcement Personnel by Agency: Beginning 2007

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.ny.gov
Id khn9-hhpq
Name Law Enforcement Personnel by Agency: Beginning 2007
Attribution New York State Division of Criminal Justice Services
Category Public Safety
Tags personnel, law enforcement, public safety, ucr
Created 2013-03-01T17:47:03Z
Publication Date 2017-07-19T22:02:47Z

Description

The Division of Criminal Justice Services (DCJS) collects personnel statistics from more than 500 New York State police and sheriffs’ departments. In New York State, law enforcement agencies use the Uniform Crime Reporting (UCR) system to report their annual personnel counts to DCJS.

Columns

| Included | Schema Type    | Field Name         | Name               | Data Type | Render Type |
| ======== | ============== | ================== | ================== | ========= | =========== |
| Yes      | series tag     | county             | County             | text      | text        |
| No       |                | pd                 | PD                 | text      | text        |
| Yes      | time           | year               | Year               | number    | number      |
| Yes      | numeric metric | sworn_full_time    | Sworn Full Time    | number    | number      |
| Yes      | numeric metric | sworn_part_time    | Sworn Part Time    | number    | number      |
| Yes      | numeric metric | sworn_total        | Sworn Total        | number    | number      |
| Yes      | numeric metric | civilian_full_time | Civilian Full Time | number    | number      |
| Yes      | numeric metric | civilian_park_time | Civilian Part Time | number    | number      |
| Yes      | numeric metric | civilian_total     | Civilian Total     | number    | number      |
| Yes      | numeric metric | full_time_total    | Full Time Total    | number    | number      |
| Yes      | numeric metric | part_time_total    | Part Time Total    | number    | number      |
| Yes      | numeric metric | grand_total        | Grand Total        | number    | number      |

Time Field

Value = year
Format & Zone = yyyy

Series Fields

Excluded Fields = pd

Data Commands

series e:khn9-hhpq d:2016-01-01T00:00:00.000Z t:county=Albany m:sworn_full_time=336 m:civilian_park_time=58 m:civilian_full_time=97 m:part_time_total=58 m:full_time_total=433 m:sworn_part_time=0 m:civilian_total=155 m:grand_total=491 m:sworn_total=336

series e:khn9-hhpq d:2015-01-01T00:00:00.000Z t:county=Albany m:sworn_full_time=335 m:civilian_park_time=54 m:civilian_full_time=98 m:part_time_total=54 m:full_time_total=433 m:sworn_part_time=0 m:civilian_total=152 m:grand_total=487 m:sworn_total=335

series e:khn9-hhpq d:2014-01-01T00:00:00.000Z t:county=Albany m:sworn_full_time=337 m:civilian_park_time=51 m:civilian_full_time=121 m:part_time_total=51 m:full_time_total=458 m:sworn_part_time=0 m:civilian_total=172 m:grand_total=509 m:sworn_total=337

Meta Commands

metric m:sworn_full_time p:integer l:"Sworn Full Time" d:"Counts of allsworn law enforcement officers with full arrest powers who were on the payroll as of October 31st Personnelthat work a normalfull‐time work week" t:dataTypeName=number

metric m:sworn_part_time p:integer l:"Sworn Part Time" d:"Counts of allsworn law enforcement officers with full arrest powers who were on the payroll as of October 31st Personnelthat work lessthan a normalfull‐time work week" t:dataTypeName=number

metric m:sworn_total p:integer l:"Sworn Total" t:dataTypeName=number

metric m:civilian_full_time p:integer l:"Civilian Full Time" d:"Counts of all non‐sworn support personnel who were on the payroll as ofOctober 31st Personnelthat work a normalfull‐time work week" t:dataTypeName=number

metric m:civilian_park_time p:integer l:"Civilian Part Time" d:"Counts of all non‐sworn support personnel who were on the payroll as ofOctober 31st Personnelthat work lessthan a normalfull‐time work week" t:dataTypeName=number

metric m:civilian_total p:integer l:"Civilian Total" d:"Counts of all non‐sworn support personnel who were on the payroll as ofOctober 31st" t:dataTypeName=number

metric m:full_time_total p:integer l:"Full Time Total" d:"Personnelthat work a normalfull‐time work week" t:dataTypeName=number

metric m:part_time_total p:integer l:"Part Time Total" d:"Personnelthat work lessthan a normalfull‐time work week" t:dataTypeName=number

metric m:grand_total p:integer l:"Grand Total" t:dataTypeName=number

entity e:khn9-hhpq l:"Law Enforcement Personnel by Agency:  Beginning 2007" t:attribution="New York State Division of Criminal Justice Services" t:url=https://data.ny.gov/api/views/khn9-hhpq

property e:khn9-hhpq t:meta.view d:2017-09-25T07:31:39.113Z v:averageRating=0 v:name="Law Enforcement Personnel by Agency:  Beginning 2007" v:attribution="New York State Division of Criminal Justice Services" v:attributionLink=http://www.criminaljustice.ny.gov/crimnet/ojsa/crimereporting/index.htm v:id=khn9-hhpq v:category="Public Safety"

property e:khn9-hhpq t:meta.view.owner d:2017-09-25T07:31:39.113Z v:displayName="NY Open Data" v:profileImageUrlLarge=/api/users/xzik-pf59/profile_images/LARGE v:profileImageUrlSmall=/api/users/xzik-pf59/profile_images/TINY v:id=xzik-pf59 v:screenName="NY Open Data" v:profileImageUrlMedium=/api/users/xzik-pf59/profile_images/THUMB

property e:khn9-hhpq t:meta.view.tableauthor d:2017-09-25T07:31:39.113Z v:displayName="NY Open Data" v:profileImageUrlLarge=/api/users/xzik-pf59/profile_images/LARGE v:roleName=publisher v:profileImageUrlSmall=/api/users/xzik-pf59/profile_images/TINY v:id=xzik-pf59 v:screenName="NY Open Data" v:profileImageUrlMedium=/api/users/xzik-pf59/profile_images/THUMB

property e:khn9-hhpq t:meta.view.metadata.custom_fields.common_core d:2017-09-25T07:31:39.113Z v:Contact_Email=opendata@its.ny.gov v:Contact_Name="Open Data NY" v:Publisher="State of New York"

Top Records

| county | pd             | year | sworn_full_time | sworn_part_time | sworn_total | civilian_full_time | civilian_park_time | civilian_total | full_time_total | part_time_total | grand_total | 
| ====== | ============== | ==== | =============== | =============== | =========== | ================== | ================== | ============== | =============== | =============== | =========== | 
| Albany | Albany City PD | 2016 | 336             | 0               | 336         | 97                 | 58                 | 155            | 433             | 58              | 491         | 
| Albany | Albany City PD | 2015 | 335             | 0               | 335         | 98                 | 54                 | 152            | 433             | 54              | 487         | 
| Albany | Albany City PD | 2014 | 337             | 0               | 337         | 121                | 51                 | 172            | 458             | 51              | 509         | 
| Albany | Albany City PD | 2013 | 332             | 0               | 332         | 104                | 52                 | 156            | 436             | 52              | 488         | 
| Albany | Albany City PD | 2012 | 322             | 0               | 322         | 123                | 54                 | 177            | 445             | 54              | 499         | 
| Albany | Albany City PD | 2011 | 312             | 0               | 312         | 132                | 59                 | 191            | 444             | 59              | 503         | 
| Albany | Albany City PD | 2010 | 327             | 0               | 327         | 138                | 66                 | 204            | 465             | 66              | 531         | 
| Albany | Albany City PD | 2009 | 327             | 0               | 327         | 136                | 58                 | 194            | 463             | 58              | 521         | 
| Albany | Albany City PD | 2008 | 332             | 0               | 332         | 124                | 9                  | 133            | 456             | 9               | 465         | 
| Albany | Albany City PD | 2007 | 334             | 0               | 334         | 123                | 71                 | 194            | 457             | 71              | 528         |