Hate Crime Incident (Open Data)

City of Tempe

@usgov.city_of_tempe_hate_crime_incident_open_data

Table List

1 table(24.87 KB)

Table 1

@usgov.city_of_tempe_hate_crime_incident_open_data.table_1

24.87 KB
71 rows
23 columns

objectid OBJECTID	x_coordinate_local_projection X Coordinate (Local Projection)	y_coordinate_local_projection Y Coordinate (Local Projection)	type_of_bias Type Of Bias	count_of_victims Count Of Victims	rms_id RMS ID	status_of_crime Status Of Crime	type_of_offense_crime Type Of Offense/Crime	notes_on_crime Notes On Crime	type_of_location Type Of Location	type_of_victim Type Of Victim	race_of_victims Race Of Victims	gender_of_victim_s Gender Of Victim(s)	date_of_crime Date Of Crime	obfuscated_address_of_crime Obfuscated Address Of Crime	created_on Created On	last_edited_on Last Edited On	latitude Latitude	longitude Longitude	type_of_bias_1 Type Of Bias.1	x X	y Y
1	684608	867365	Anti-Islamic (Muslim)	3	TE201012640	Active	Intimidation		Department/Discount Store	Individual			1/20/2010 7:00:00 AM	50XX S ARIZONA MILLS	5/25/2021 4:29:48 PM	10/15/2021 8:29:16 PM	33.384323	-111.967093	24	684608	867365
2	703527	878915	Anti-Gay (Male)	1	TE2010132348	Active	Non DV Assault		Residence/Home	Individual			8/28/2010 7:00:00 AM	19XX E APACHE BLVD	5/25/2021 4:29:48 PM	10/15/2021 8:30:31 PM	33.416077	-111.905108	41	703527	878915
3	698856	878435	Anti-Gay (Male)	1	TE201028029	Active	Non DV Assault		Highway/Road/Street	Individual			2/19/2010 7:00:00 AM	12XX E APACHE BLVD	5/25/2021 4:29:48 PM	10/15/2021 8:29:41 PM	33.414758	-111.920416	41	698856	878435
4	693898	882345	Anti-Black	2	TE201094607	Active	Intimidation		Residence/Home	Individual			6/15/2010 7:00:00 AM		5/25/2021 4:29:48 PM	10/15/2021 8:30:17 PM	33.425503	-111.936667	12	693898	882345
5	690272	878394	Anti-Islamic (Muslim)	1	TE2011111420	Inactive	Criminal Damage	Later found to not be bias crime	Residence/Home	Individual			6/30/2011 7:00:00 AM	13XX S JUDD ST	5/25/2021 4:29:48 PM	10/15/2021 8:31:03 PM	33.414641	-111.948548	24	690272	878394
6	704892	865011	Anti-Black	1	TE2011172980	Active	Criminal Damage		Residence/Home	Individual			11/4/2011 7:00:00 AM	20XX E RICE DR	5/25/2021 4:29:48 PM	10/15/2021 8:31:16 PM	33.377862	-111.900641	12	704892	865011
7	702279	867860	Anti-Black	1	TE201149273	Active	Non DV AGG Assault		Highway/Road/Street	Individual			4/1/2011 7:00:00 AM	US 60 / MCCLINTOCK DR	5/25/2021 4:29:48 PM	10/15/2021 8:30:45 PM	33.385693	-111.9092	12	702279	867860
8	689552	887490	Anti-Gay (Male)	1	TE2012116830	Active	Non DV Assault		Parking Lot/Garage	Individual			9/9/2012 7:00:00 AM	10XX N PARKSIDE DR	5/25/2021 4:29:48 PM	10/15/2021 8:32:03 PM	33.43964	-111.950917	41	689552	887490
9	690312	882620	Anti-Jewish	2	TE2012129208	Active	Criminal Damage		Residence/Home	Individual		Male	10/5/2012 7:00:00 AM	7XX W BROWN ST	5/25/2021 4:29:48 PM	10/15/2021 8:32:12 PM	33.426256	-111.948421	21	690312	882620
10	702304	878435	Anti-Black	1	TE2012159036	Active	Non DV AGG Assault		Air/Bus/Train/Terminal	Individual	African American		12/6/2012 7:00:00 AM	18XX E APACHE BLVD	5/25/2021 4:29:48 PM	10/15/2021 8:32:24 PM	33.414758	-111.909116	12	702304	878435


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "x_coordinate_local_projection" BIGINT,
  "y_coordinate_local_projection" BIGINT,
  "type_of_bias" VARCHAR,
  "count_of_victims" DOUBLE,
  "rms_id" VARCHAR,
  "status_of_crime" VARCHAR,
  "type_of_offense_crime" VARCHAR,
  "notes_on_crime" VARCHAR,
  "type_of_location" VARCHAR,
  "type_of_victim" VARCHAR,
  "race_of_victims" VARCHAR,
  "gender_of_victim_s" VARCHAR,
  "date_of_crime" VARCHAR,
  "obfuscated_address_of_crime" VARCHAR,
  "date_of_status_change" VARCHAR,
  "created_on" VARCHAR,
  "last_edited_on" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "type_of_bias_1" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE
);