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 Q3

@kaggle.amymantel_indiana_crime_analysis.n_2023_q3

761.93 KB
213844 rows
7 columns

age_group AGE GROUP	race RACE	sex SEX	month MONTH	county COUNTY	offense OFFENSE	charge CHARGE
25-34 Years	WHITE	FEMALE	9	MARION	organized theft	Property
35-44 Years	WHITE	MALE	8	PORTER	resisting law enforc	Procedural
25-34 Years	WHITE	FEMALE	8	ALLEN	neglect of dependent	Child
25-34 Years	WHITE	MALE	8	ALLEN	operating without license	Traffic
25-34 Years	WHITE	MALE	8	ALLEN	residential entry	Property
45-54 Years	WHITE	FEMALE	8	TIPPECANOE	wanted on warrant fta rearrest	Procedural
25-34 Years	WHITE	MALE	8	LAPORTE	operating vehicle while intox	Traffic
35-44 Years	WHITE	MALE	7	MONTGOMERY	operating vehicle while intox	Traffic
35-44 Years	WHITE	FEMALE	7	PORTER	lake co	Other
55-64 Years	WHITE	MALE	7	ALLEN	leaving the scene of a crash property damage	Property


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