ny-gov/law-enforcement-personnel-by-agency-beginning-2007-khn9-hhpq
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 11 months ago
Indexed 1 hour ago

Law Enforcement Personnel by Agency: Beginning 2007

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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"ny-gov/law-enforcement-personnel-by-agency-beginning-2007-khn9-hhpq\".\"law_enforcement_personnel_by_agency_beginning_2007\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • law_enforcement_personnel_by_agency_beginning_2007
     
     
     
     
     
Upstream Metadata