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 Q1

@kaggle.amymantel_indiana_crime_analysis.n_2023_q1

728.78 KB
206600 rows
7 columns

age_group AGE GROUP	race RACE	sex SEX	month MONTH	county COUNTY	offense OFFENSE	charge CHARGE
15-24 Years	WHITE	FEMALE	2	MARION	theft	Property
35-44 Years	WHITE	FEMALE	2	MARION	theft	Property
35-44 Years	WHITE	FEMALE	2	MARION	theft	Property
45-54 Years	WHITE	MALE	2	MARION	theft	Property
45-54 Years	WHITE	MALE	2	MARION	battery	Violent
15-24 Years	WHITE	MALE	2	MARION	criminal recklessness	Violent
25-34 Years	WHITE	MALE	2	MARION	unlawful possession of a firearm by a domestic batterer	Violent
15-24 Years	WHITE	MALE	2	HOWARD	resisting law enforcement	Procedural
15-24 Years	WHITE	MALE	2	HOWARD	auto theft	Property
35-44 Years	WHITE	MALE	2	GIBSON	domestic battery	Violent


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