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{
df <- morie_ingest_chicago_crime(year = 2024, max_features = 10000L)
head(df)
#> id case_number date block iucr
#> 1 13487512 JH295685 2024-05-27T08:42:00.000 001XX N STATE ST 1310
#> 2 28068 JH223840 2024-04-13T17:45:00.000 077XX S CARPENTER ST 0110
#> 3 13353244 JH134156 2024-01-28T21:00:00.000 069XX S PARNELL AVE 1752
#> 4 13434657 JH231872 2024-04-19T18:50:00.000 001XX E CHICAGO AVE 0860
#> 5 13712100 JJ104803 2024-01-01T00:00:00.000 033XX N LONG AVE 0910
#> 6 13712884 JJ105838 2024-01-05T23:43:00.000 019XX N MILWAUKEE AVE 2826
#> primary_type description
#> 1 CRIMINAL DAMAGE TO PROPERTY
#> 2 HOMICIDE FIRST DEGREE MURDER
#> 3 OFFENSE INVOLVING CHILDREN AGGRAVATED CRIMINAL SEXUAL ABUSE BY FAMILY MEMBER
#> 4 THEFT RETAIL THEFT
#> 5 MOTOR VEHICLE THEFT AUTOMOBILE
#> 6 OTHER OFFENSE HARASSMENT BY ELECTRONIC MEANS
#> location_description arrest domestic beat district ward community_area
#> 1 OTHER (SPECIFY) FALSE FALSE 0111 001 42 32
#> 2 STREET FALSE FALSE 0612 006 17 71
#> 3 RESIDENCE FALSE FALSE 0732 007 6 68
#> 4 DEPARTMENT STORE FALSE FALSE 1833 018 2 8
#> 5 APARTMENT FALSE TRUE 1634 016 31 15
#> 6 APARTMENT FALSE FALSE 1434 014 1 22
#> fbi_code year updated_on x_coordinate y_coordinate latitude
#> 1 14 2024 2024-06-08T15:41:06.000 <NA> <NA> <NA>
#> 2 01A 2024 2024-04-21T15:40:50.000 1170655 1853491 41.753457689
#> 3 17 2024 2024-04-20T15:40:43.000 <NA> <NA> <NA>
#> 4 06 2024 2024-04-27T15:41:11.000 <NA> <NA> <NA>
#> 5 07 2024 2025-01-06T15:41:41.000 <NA> <NA> <NA>
#> 6 26 2024 2025-01-07T15:42:52.000 <NA> <NA> <NA>
#> longitude
#> 1 <NA>
#> 2 -87.650181219
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> location
#> 1 <NA>
#> 2 41.753457689;-87.650181219;{"address": "", "city": "", "state": "", "zip": ""}
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
# }