citydata-mesaaz-gov/police-employee-staffing-sworn-and-civilian-bdtv-tbrq
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 3 months ago
Indexed 1 month ago

Police Employee Staffing Sworn and Civilian

Historical staffing counts of employees in police department by calendar year. Typically Full Time Equivalent (FTE) count is approved annually by City Council as part of the city's budget process.

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 \"citydata-mesaaz-gov/police-employee-staffing-sworn-and-civilian-bdtv-tbrq\".\"police_employee_staffing_sworn_and_civilian\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • police_employee_staffing_sworn_and_civilian
     
     
     
     
     
Upstream Metadata