NYPD Hate Crimes

City of New York

@usgov.city_of_new_york_nypd_hate_crimes

Table List

1 table(88 KB)

Table 1

@usgov.city_of_new_york_nypd_hate_crimes.table_1

88 KB
3575 rows
14 columns

full_complaint_id Full Complaint ID	complaint_year_number Complaint Year Number	month_number Month Number	record_create_date Record Create Date	complaint_precinct_code Complaint Precinct Code	patrol_borough_name Patrol Borough Name	county County	law_code_category_description Law Code Category Description	offense_description Offense Description	pd_code_description PD Code Description	bias_motive_description Bias Motive Description	offense_category Offense Category
201906012119317	2019	1	Wed Jan 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	60	PATROL BORO BKLYN SOUTH	KINGS	FELONY	MISCELLANEOUS PENAL LAW	AGGRAVATED HARASSMENT 1	ANTI-JEWISH	Religion/Religious Practice
201906012175717	2019	2	Mon Feb 25 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	60	PATROL BORO BKLYN SOUTH	KINGS	FELONY	MISCELLANEOUS PENAL LAW	AGGRAVATED HARASSMENT 1	ANTI-JEWISH	Religion/Religious Practice
201906012180117	2019	2	Wed Feb 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	60	PATROL BORO BKLYN SOUTH	KINGS	FELONY	MISCELLANEOUS PENAL LAW	AGGRAVATED HARASSMENT 1	ANTI-JEWISH	Religion/Religious Practice
201906012273417	2019	4	Tue Apr 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	60	PATROL BORO BKLYN SOUTH	KINGS	FELONY	MISCELLANEOUS PENAL LAW	AGGRAVATED HARASSMENT 1	ANTI-JEWISH	Religion/Religious Practice
201906012413717	2019	6	Thu Jun 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	60	PATROL BORO BKLYN SOUTH	KINGS	FELONY	MISCELLANEOUS PENAL LAW	AGGRAVATED HARASSMENT 1	ANTI-JEWISH	Religion/Religious Practice
201906012523617	2019	7	Wed Jul 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	60	PATROL BORO BKLYN SOUTH	KINGS	FELONY	MISCELLANEOUS PENAL LAW	AGGRAVATED HARASSMENT 1	ANTI-JEWISH	Religion/Religious Practice
201906012616917	2019	9	Wed Sep 11 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	60	PATROL BORO BKLYN SOUTH	KINGS	FELONY	MISCELLANEOUS PENAL LAW	AGGRAVATED HARASSMENT 1	ANTI-JEWISH	Religion/Religious Practice
201906012762517	2019	11	Thu Nov 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	60	PATROL BORO BKLYN SOUTH	KINGS	FELONY	MISCELLANEOUS PENAL LAW	AGGRAVATED HARASSMENT 1	ANTI-JEWISH	Religion/Religious Practice
201906112336617	2019	5	Sat May 18 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	61	PATROL BORO BKLYN SOUTH	KINGS	FELONY	MISCELLANEOUS PENAL LAW	AGGRAVATED HARASSMENT 1	ANTI-JEWISH	Religion/Religious Practice
201906112366917	2019	6	Sun Jun 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	61	PATROL BORO BKLYN SOUTH	KINGS	FELONY	MISCELLANEOUS PENAL LAW	AGGRAVATED HARASSMENT 1	ANTI-JEWISH	Religion/Religious Practice


CREATE TABLE table_1 (
  "full_complaint_id" BIGINT,
  "complaint_year_number" BIGINT,
  "month_number" BIGINT,
  "record_create_date" TIMESTAMP,
  "complaint_precinct_code" BIGINT,
  "patrol_borough_name" VARCHAR,
  "county" VARCHAR,
  "law_code_category_description" VARCHAR,
  "offense_description" VARCHAR,
  "pd_code_description" VARCHAR,
  "bias_motive_description" VARCHAR,
  "offense_category" VARCHAR,
  "arrest_date" TIMESTAMP,
  "arrest_id" VARCHAR
);