Baselight
Sign In

Indiana Crime Analysis

Identifying arrests and potential areas for effective change

@kaggle.amymantel_indiana_crime_analysis

N 2023 Q4
@kaggle.amymantel_indiana_crime_analysis.n_2023_q4

  • 617.21 KB
  • 171480 rows
  • 7 columns
age_group

AGE GROUP

race

RACE

sex

SEX

month

MONTH

county

COUNTY

offense

OFFENSE

charge

CHARGE

25-34 YearsWHITEMALE11MARIONprobation violationProcedural
25-34 YearsWHITEMALE11MARIONprobation violationProcedural
45-54 YearsWHITEMALE10ALLENdomestic batteryViolent
35-44 YearsWHITEMALE10ST JOSEPHunlawful possession of firearm by serious violent felonViolent
25-34 YearsWHITEFEMALE10ALLENbatteryViolent
25-34 YearsWHITEMALE10TIPPECANOEtccc violation chargeOther
25-34 YearsWHITEMALE10TIPPECANOEwanted on warrant fta rearrestProcedural
35-44 YearsWHITEMALE11ALLENdomestic battery prior unrelated conviction for batteryViolent
25-34 YearsWHITEFEMALE10ALLENbattery to public safety official causing bodily injuryViolent
15-24 YearsWHITEMALE11ALLENtheftProperty

CREATE TABLE n_2023_q4 (
  "age_group" VARCHAR,
  "race" VARCHAR,
  "sex" VARCHAR,
  "month" BIGINT,
  "county" VARCHAR,
  "offense" VARCHAR,
  "charge" VARCHAR
);