Police Arrest From 2021-2023

Tracking Trends in Law Enforcement: Key Arrest Data from 2021-2023

@kaggle.shayanshahid997_police_arrest_from_2021_2023

Table List

1 table(412.23 KB)

Police Arrests 20240702

@kaggle.shayanshahid997_police_arrest_from_2021_2023.police_arrests_20240702

412.23 KB
23510 rows
10 columns

id_reference_number ID Reference Number	subject_s_race Subject\u0027s Race	subject_s_gender Subject\u0027s Gender	subject_s_age Subject\u0027s Age	ethnicity Ethnicity	district_of_occurrence District Of Occurrence	assigned_division Assigned Division	assigned_bureau Assigned Bureau	event_date_time Event Date/Time
1	Asian	Male	43	NON-HISPANIC	6	TOD	FSB	Fri Jan 01 2021 01:07:00 GMT+0000 (Coordinated Universal Time)
2	Black/African American	Male	23	NON-HISPANIC	1	RCPD	nan	Fri Jan 01 2021 00:52:00 GMT+0000 (Coordinated Universal Time)
3	Black/African American	Male	18	NON-HISPANIC	1	RCPD	nan	Fri Jan 01 2021 00:52:00 GMT+0000 (Coordinated Universal Time)
4	Black/African American	Male	21	NON-HISPANIC	1	RCPD	nan	Fri Jan 01 2021 00:52:00 GMT+0000 (Coordinated Universal Time)
5	White	Female	38	HISPANIC	4	TOD	FSB	Fri Jan 01 2021 03:00:00 GMT+0000 (Coordinated Universal Time)
6	White	Female	31	HISPANIC	3	TPPD	nan	Fri Jan 01 2021 02:47:00 GMT+0000 (Coordinated Universal Time)
7	White	Male	37	HISPANIC	6	GPD	nan	Fri Jan 01 2021 04:49:00 GMT+0000 (Coordinated Universal Time)
8	Black/African American	Male	40	NON-HISPANIC	4	4D	PSB	Fri Jan 01 2021 06:10:00 GMT+0000 (Coordinated Universal Time)
9	White	Male	34	HISPANIC	3	3D	PSB	Fri Jan 01 2021 08:55:00 GMT+0000 (Coordinated Universal Time)
10	Black/African American	Male	23	NON-HISPANIC	3	3D	PSB	Fri Jan 01 2021 13:54:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE police_arrests_20240702 (
  "id_reference_number" BIGINT,
  "subject_s_race" VARCHAR,
  "subject_s_gender" VARCHAR,
  "subject_s_age" BIGINT,
  "ethnicity" VARCHAR,
  "district_of_occurrence" DOUBLE,
  "adjacent_to_school" BIGINT,
  "assigned_division" VARCHAR,
  "assigned_bureau" VARCHAR,
  "event_date_time" TIMESTAMP
);