citydata-mesaaz-gov/police-employee-demographics-community-profile-wfmq-6c7c
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 2 years ago
Indexed 2 hours ago

Police Employee Demographics & Community Profile Summary

Summary ethnicity and gender for Police employees compared with community profile. Employee totals as of January 1, 2022 (see source linked below). Community race/ethnicity is sourced from US Census 2019 American Community Survey (ACS) 5-Year Estimates and includes survey responses for race alone or in combination with one or more other races. To normalize comparison with employees, White in community profile is defined as White alone, not Hispanic or Latino and are individuals who responded "No, not Spanish/Hispanic/Latino" and who reported "White" as their only entry in the race question.

Percentages do not equal 100 because includes percentage of Hispanic or Latino (of any race). https://citydata.mesaaz.gov/Census/Age-and-Population-Demographics/4why-9h55

NOTE: The release of 2020 ACS estimates are delayed because of the COVID-19 pandemic.

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-demographics-community-profile-wfmq-6c7c\".\"police_employee_demographics_community_profile\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • police_employee_demographics_community_profile
     
     
     
     
     
Upstream Metadata