Police Data
Analyse Data from a Police Check-post
@kaggle.rohitgrewal_police_data
Analyse Data from a Police Check-post
@kaggle.rohitgrewal_police_data
This dataset contains detailed records of police traffic stops. Each row represents a single stop, with information about the date, time, driver demographics, the reason for the stop, whether a search was conducted, and the outcome. It can be useful for analysing traffic stop patterns, demographic trends, law enforcement behaviour, and correlations with violations or arrests.
Q.1) Instruction ( For Data Cleaning ) - Remove the column that only contains missing values
Q.2) For Speeding , were Men or Women stopped more often ?
Q.3) Does gender affect who gets searched during a stop ?
Q.4) What is the mean stop_duration ?
Q.5) Compare the age distributions for each violation
stop_date – The date on which the traffic stop occurred.
stop_time – The exact time when the stop took place.
driver_gender – Gender of the driver (M for male, F for female).
driver_age_raw – Raw recorded birth year of the driver.
driver_age – Calculated or cleaned driver’s age at the time of the stop.
driver_race – Race or ethnicity of the driver (e.g., White, Black, Asian, Hispanic).
violation_raw – Original recorded reason for the stop.
violation – Categorized reason for the stop (e.g., Speeding, Other).
search_conducted – Boolean value indicating whether a search was performed (True/False).
search_type – Type of search conducted, if any (e.g., vehicle search, driver search).
stop_outcome – The result of the stop (e.g., Citation, Arrest, Warning).
is_arrested – Boolean value indicating if the driver was arrested (True/False).
stop_duration – Approximate length of the stop (e.g., 0-15 Min, 16-30 Min).
drugs_related_stop – Boolean value indicating if the stop was related to drugs (True/False).
CREATE TABLE police_data (
"stop_date" TIMESTAMP,
"stop_time" VARCHAR,
"country_name" VARCHAR,
"driver_gender" VARCHAR,
"driver_age_raw" DOUBLE,
"driver_age" DOUBLE,
"driver_race" VARCHAR,
"violation_raw" VARCHAR,
"violation" VARCHAR,
"search_conducted" BOOLEAN,
"search_type" VARCHAR,
"stop_outcome" VARCHAR,
"is_arrested" VARCHAR,
"stop_duration" VARCHAR,
"drugs_related_stop" BOOLEAN
);
Anyone who has the link will be able to view this.