Indiana Crime Analysis

Identifying arrests and potential areas for effective change

@kaggle.amymantel_indiana_crime_analysis

Table List

4 tables(2.77 MB)

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 Years	WHITE	MALE	11	MARION	probation violation	Procedural
25-34 Years	WHITE	MALE	11	MARION	probation violation	Procedural
45-54 Years	WHITE	MALE	10	ALLEN	domestic battery	Violent
35-44 Years	WHITE	MALE	10	ST JOSEPH	unlawful possession of firearm by serious violent felon	Violent
25-34 Years	WHITE	FEMALE	10	ALLEN	battery	Violent
25-34 Years	WHITE	MALE	10	TIPPECANOE	tccc violation charge	Other
25-34 Years	WHITE	MALE	10	TIPPECANOE	wanted on warrant fta rearrest	Procedural
35-44 Years	WHITE	MALE	11	ALLEN	domestic battery prior unrelated conviction for battery	Violent
25-34 Years	WHITE	FEMALE	10	ALLEN	battery to public safety official causing bodily injury	Violent
15-24 Years	WHITE	MALE	11	ALLEN	theft	Property


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