Police Arrest From 2021-2023
Tracking Trends in Law Enforcement: Key Arrest Data from 2021-2023
@kaggle.shayanshahid997_police_arrest_from_2021_2023
Tracking Trends in Law Enforcement: Key Arrest Data from 2021-2023
@kaggle.shayanshahid997_police_arrest_from_2021_2023
This data set contains data from individuals arrested by a police officer in Montgomery County, including whether the arrest location is within 500 feet of a school.
The County has been an early adopter of technology and promoter of a transparent and efficient government. This represents the County’s commitment to being an inclusive, innovative and transparent government that is accountable and responsive and maintains a strong and vibrant economy. The County has been a leader in open government since the launch of its e-Government website initiative in 1992. Since then, the County has sustained a strong commitment to digitizing its information and services.
| Column Name | Description | Field Name | Data Type |
|---|---|---|---|
| ID Reference Number | Row number/ID Reference Number | id | Text |
| Subject's race | Subject's race | race | Text |
| Subject's gender | Subject's gender | gender | Text |
| Subject's age | Subject's age | age | Text |
| Ethnicity | Subject's ethnicity | ethnicity | Text |
| District of occurrence | District of occurrence | district | Text |
| Adjacent to School | Arrest occurred within 500 ft. of a school (1/0) | adjacent_to_school | Text |
| Assigned Division | District/division of officer's assignment | division | Text |
| Assigned Bureau | Bureau of officer's assignment | bureau | Text |
| Event Date/Time | Event Date/Time | event_date_time | Floating Timestamp |
CREATE TABLE police_arrests_20240702 (
"id_reference_number" BIGINT,
"subject_s_race" VARCHAR -- Subject\u0027s Race,
"subject_s_gender" VARCHAR -- Subject\u0027s Gender,
"subject_s_age" BIGINT -- Subject\u0027s Age,
"ethnicity" VARCHAR,
"district_of_occurrence" DOUBLE,
"adjacent_to_school" BIGINT,
"assigned_division" VARCHAR,
"assigned_bureau" VARCHAR,
"event_date_time" TIMESTAMP
);Anyone who has the link will be able to view this.