Violence Reduction - Victim Demographics - Aggregated

City of Chicago

@usgov.city_of_chicago_violence_reduction_victim_demographics_bfc672a8

Table List

1 table(351.97 KB)

Table 1

@usgov.city_of_chicago_violence_reduction_victim_demographics_bfc672a8.table_1

351.97 KB
56162 rows
11 columns

time_period TIME PERIOD	time_period_start TIME PERIOD START	time_period_end TIME PERIOD END	primary_type PRIMARY TYPE	age AGE	sex SEX	race RACE	juvenile_i JUVENILE I	domestic_i DOMESTIC I	gunshot_injury_i GUNSHOT INJURY I	number_of_victims NUMBER OF VICTIMS
2023 Q1	Sun Jan 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ASSAULT	30-39	UNKNOWN	UNKNOWN	false		NO	1
2022 Q2	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BATTERY	70-79	M	API	false		NO	3
2012 Q4	Mon Oct 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	BATTERY	20-29	UNKNOWN	UNKNOWN	false		NO	1
2003 Q2	Sat Mar 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 30 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	CRIMINAL SEXUAL ASSAULT	0-19	F	WWH	true		UNKNOWN	42
2008 Q3	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Sep 30 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BATTERY	30-39	M	WBH	false		UNKNOWN	1
2015 Q4	Thu Oct 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	ROBBERY	30-39	F	API	false		NO	9
2017 Q4	Sun Oct 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	ASSAULT	0-19	M	WWH	false	true	NO	2
2002 Q1	Tue Jan 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 31 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	ASSAULT	30-39	M	API	false		UNKNOWN	11
2023 Q3	Sat Jul 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Sep 30 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ASSAULT	0-19	M	WBH	false		NO	1
2023 Q1	Sun Jan 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	BATTERY	0-19	UNKNOWN	UNKNOWN	true	true	NO	1


CREATE TABLE table_1 (
  "time_period" VARCHAR,
  "time_period_start" TIMESTAMP,
  "time_period_end" TIMESTAMP,
  "primary_type" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "race" VARCHAR,
  "juvenile_i" VARCHAR,
  "domestic_i" BOOLEAN,
  "gunshot_injury_i" VARCHAR,
  "number_of_victims" BIGINT
);