Data Dictionary

ID
YEAR
Type
int4
Description

Year of reported personnel

ID
COMMAND_GROUP
Type
text
Description

Description of command group

ID
COMMAND_SUBUNIT
Type
text
Description

Breakdown of command subunits

ID
UNIT
Type
text
Description

Breakdown of command units

ID
CLASSIFICATION
Type
text
Description

Breakdown of rank

ID
COUNT_
Type
text
Description

Count of employed persons

Additional Information

Field Value
Data last updated June 30, 2025
Metadata last updated February 20, 2026
Created June 30, 2025
Format CSV
License License not specified
Datastore activeTrue
Datastore cache{'CSV': 'd857523d-9bc7-4450-8ae7-4044b21bb6ec', 'XML': '298a2d6d-ed96-44d7-8463-81b3b249f5d7', 'JSON': 'abda009f-8082-44b5-8091-b5a38fd30bdb'}
Datastore cache last update6 months ago
Extract jobAirflow - files_to_datastore.py - police-annual-statistical-report-personnel-by-rank-by-division
Has viewsFalse
Idc4743579-c837-47fb-821b-cf7ccae5ffef
Is previewTrue
Package idf1bf9a67-ba2e-4d68-a1e3-efc7af4519a2
Position0
Record count1,426
Stateactive
Url typedatastore
Extract Job Airflow - files_to_datastore.py - police-annual-statistical-report-personnel-by-rank-by-division
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID