Pull the City of Chicago "Crimes - 2001 to Present" feed
Source:R/ingest_chicago.R
morie_ingest_chicago_crime.RdReturns a data.frame with the documented Socrata schema (snake_case
column names preserved): id, case_number,
date, block, iucr, primary_type,
description, location_description, arrest,
domestic, beat, district, ward,
community_area, fbi_code, x_coordinate,
y_coordinate, year, updated_on,
latitude, longitude.
Usage
morie_ingest_chicago_crime(
year = NULL,
where = NULL,
max_features = NULL,
app_token = NULL,
user_agent = .MORIE_CHICAGO_DEFAULT_UA,
timeout = .MORIE_CHICAGO_DEFAULT_TIMEOUT
)Arguments
- year
Optional reporting year (e.g. 2024); when set, applies the server-side SoQL filter
year = <year>.- where
Optional raw SoQL
$whereclause (overridesyear).- max_features
Optional hard cap on returned rows.
- app_token
Optional Socrata X-App-Token for higher rate limits.
- user_agent, timeout
Standard request knobs.
See also
morie_ingest_chicago_socrata,
morie_ingest_bigquery_table for the BigQuery
public-data mirror (bigquery-public-data.chicago_crime).
Examples
# \donttest{
if (requireNamespace("httr2", quietly = TRUE)) withAutoprint({
df <- morie_ingest_chicago_crime(year = 2024, max_features = 10000L)
head(df)
})
#> > df <- morie_ingest_chicago_crime(year = 2024, max_features = 10000L)
#> > head(df)
#> id case_number date block iucr
#> 1 13773031 JJ178592 2024-02-20T00:00:00.000 069XX S VERNON AVE 1153
#> 2 13487512 JH295685 2024-05-27T08:42:00.000 001XX N STATE ST 1310
#> 3 28068 JH223840 2024-04-13T17:45:00.000 077XX S CARPENTER ST 0110
#> 4 13353244 JH134156 2024-01-28T21:00:00.000 069XX S PARNELL AVE 1752
#> 5 13712100 JJ104803 2024-01-01T00:00:00.000 033XX N LONG AVE 0910
#> 6 13434657 JH231872 2024-04-19T18:50:00.000 001XX E CHICAGO AVE 0860
#> primary_type description
#> 1 DECEPTIVE PRACTICE FINANCIAL IDENTITY THEFT OVER $ 300
#> 2 CRIMINAL DAMAGE TO PROPERTY
#> 3 HOMICIDE FIRST DEGREE MURDER
#> 4 OFFENSE INVOLVING CHILDREN AGGRAVATED CRIMINAL SEXUAL ABUSE BY FAMILY MEMBER
#> 5 MOTOR VEHICLE THEFT AUTOMOBILE
#> 6 THEFT RETAIL THEFT
#> location_description arrest domestic beat district ward community_area
#> 1 APARTMENT FALSE FALSE 0322 003 6 69
#> 2 OTHER (SPECIFY) FALSE FALSE 0111 001 42 32
#> 3 STREET FALSE FALSE 0612 006 17 71
#> 4 RESIDENCE FALSE FALSE 0732 007 6 68
#> 5 APARTMENT FALSE TRUE 1634 016 31 15
#> 6 DEPARTMENT STORE FALSE FALSE 1833 018 2 8
#> fbi_code year updated_on x_coordinate y_coordinate latitude
#> 1 11 2024 2025-03-13T15:41:13.000 <NA> <NA> <NA>
#> 2 14 2024 2024-06-08T15:41:06.000 <NA> <NA> <NA>
#> 3 01A 2024 2024-04-21T15:40:50.000 1170655 1853491 41.753457689
#> 4 17 2024 2024-04-20T15:40:43.000 <NA> <NA> <NA>
#> 5 07 2024 2025-01-06T15:41:41.000 <NA> <NA> <NA>
#> 6 06 2024 2024-04-27T15:41:11.000 <NA> <NA> <NA>
#> longitude
#> 1 <NA>
#> 2 <NA>
#> 3 -87.650181219
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> location
#> 1 <NA>
#> 2 <NA>
#> 3 41.753457689;-87.650181219;{"address": "", "city": "", "state": "", "zip": ""}
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
# }