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 Q2

@kaggle.amymantel_indiana_crime_analysis.n_2023_q2

727.09 KB
203019 rows
7 columns

age_group AGE GROUP	race RACE	sex SEX	month MONTH	county COUNTY	offense OFFENSE	charge CHARGE
55-64 Years	WHITE	FEMALE	5	DUBOIS	false informing	Fraud
45-54 Years	WHITE	FEMALE	6	MONTGOMERY	operating vehicle while intox	Traffic
45-54 Years	WHITE	MALE	4	PORTER	laporte county hold	Procedural
35-44 Years	WHITE	FEMALE	5	LAPORTE	operating vehicle while intox	Traffic
15-24 Years	WHITE	MALE	5	LAPORTE	resisting law enforcement m	Procedural
35-44 Years	WHITE	MALE	5	VIGO	obstruction of justice	Procedural
55-64 Years	WHITE	FEMALE	5	LAPORTE	resisting law enforcement m	Procedural
15-24 Years	WHITE	FEMALE	5	LAPORTE	false informing ma	Fraud
25-34 Years	WHITE	MALE	6	PORTER	hold for pulaski co	Procedural
35-44 Years	WHITE	FEMALE	4	DAVIESS	refusal to identify self	Procedural


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