Annual Arrests in Colorado by Offense 1970-2022

This datasets provides annual counts of arrests made by offense for 243 Police Agencies in Colorado. Thirty one different offenses are tracked in this dataset, spanning 1970 to 2022.

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 \"colorado-gov/annual-arrests-in-colorado-by-offense-19702022-xi5f-mkzt\".\"annual_arrests_in_colorado_by_offense_19702022\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

Preview

annual_arrests_in_colorado_by_offense_19702022

Left sidebar is currently unimplemented

Right sidebar is currently unimplemented

Upstream Metadata

Data QualityExpected Update FrequencyAnnual, later in the next year

Data UpdatesUpdate TypeManualUpdate MethodManual

Data DescriptionSingle RowAnnual arrest data for the 31 crime types for the given Police Agency in ColoradoLong DescriptionThis datasets provides counts of arrests made by type of crime for 243 Police Agencies in Colorado. There are 31 different types of crime incidents tracked in this dataset, for the period 1970 thru 2022. This data is derived by the FBI from their Uniform Crime Reporting (UCR) Program. Agencies submit data using one of two reporting formats -- the Summary Reporting System (SRS), or the National Incident Based Reporting System (NIBRS). SRS data is the legacy format that provides aggregated counts of the reported crime offenses known to law enforcement by location.Collection MethodAgencies submit data using one of two reporting formats -- the Summary Reporting System (SRS), or the National Incident Based Reporting System (NIBRS)Newest Record in Dataset2022Oldest Record in Dataset1970Field Names, comma delimitedagency, ori, year, aggravatedAssault, allOtherOffensesExceptTraffic, arson, burglary, curfewLoiteringLawViolations, disorderlyConduct, drivingUnderTheInfluence, drugAbuseViolationsGrandTotal, drunkenness, embezzlement, forgeryAndCounterfeiting, fraud, gamblingTotal, humanTraffickingCommercialSexActs, humanTraffickingInvoluntaryServitude, larcenyTheft, liquorLaws, manslaughterByNegligence, motorVehicleTheft, murderAndNonnegligentManslaughter, offensesAgainstTheFamilyAndChildren, prostitutionAndCommercializedVice, rape, robbery, sexOffensesExceptRapeAndProstitutionAndCommercializedVice, simpleAssault, stolenPropertyBuyingReceivingPossessing, suspicion, vagrancy, vandalism, weaponsCarryingPossessingEtcDate of Initial Dataset Creation2023

Dataset CoverageGranularityAnnual

Contributing Agency InformationData SourceThe FBI Crime Data APIAgency Program Pagehttps://cde.ucr.cjis.gov/LATEST/webapp/#/pages/docApiAgency Data Series Pagehttps://cde.ucr.cjis.gov/LATEST/webapp/#/pages/docApi

About

Annual Arrests in Colorado by Offense 1970-2022

4 months ago (updated)

1 hour ago (indexed)

Topics