POL- Use Of Force Details
Montgomery County of Maryland
@usgov.montgomery_county_of_maryland_pol_use_of_force_details
Montgomery County of Maryland
@usgov.montgomery_county_of_maryland_pol_use_of_force_details
CREATE TABLE table_1 (
"reportguid" VARCHAR,
"officerguid" VARCHAR,
"event_date_time" TIMESTAMP,
"cr_or_event" VARCHAR,
"event_class" BIGINT,
"event_class_description" VARCHAR,
"district_of_occurrence" VARCHAR,
"bureau" VARCHAR,
"reason_counteract" BOOLEAN,
"reason_claim_injury" BOOLEAN,
"reason_protective_instrument" BOOLEAN,
"reason_firearm_discharge" BOOLEAN,
"reason_canine" BOOLEAN,
"reason_firearm_accidental_discharge" BOOLEAN,
"reason_officer_assaulted_ambushed" BOOLEAN,
"reason_pointing" BOOLEAN,
"reason_physical_efforts" BOOLEAN,
"reason_animal_involved" BOOLEAN,
"reason_animalinvolvedhumane" BOOLEAN,
"reason_animalinvolvedvicious" BOOLEAN,
"animal_type" VARCHAR,
"animaltypeother" VARCHAR,
"animal_force_used" VARCHAR,
"animal_force_used_other" VARCHAR,
"activity_arrest" BOOLEAN,
"activity_defend" BOOLEAN,
"activity_demo" BOOLEAN,
"activity_eep" BOOLEAN,
"activity_warrant" BOOLEAN,
"activity_transport" BOOLEAN,
"activity_stop" BOOLEAN,
"activity_investigative_detention" BOOLEAN,
"activity_swat_operation" BOOLEAN,
"activity_sert_operation" BOOLEAN,
"subj_race" VARCHAR,
"subj_gender" VARCHAR,
"subj_age" DOUBLE,
"subj_age_unknown" VARCHAR,
"subj_height" DOUBLE,
"subj_weight" DOUBLE,
"subj_alcohol" BOOLEAN,
"subj_drugs" BOOLEAN,
"subj_drug_type" VARCHAR,
"subj_drug_type_other" VARCHAR,
"subj_possible_mental_illness" BOOLEAN,
"subject_injury_bruise_soreness" VARCHAR,
"subject_injury_broken_bones" VARCHAR,
"subject_injury_laceration_abrasion" VARCHAR,
"subject_injury_bite" VARCHAR,
"subject_injury_gunshot" VARCHAR,
"subject_injury_taser_mark" VARCHAR,
"suspect_injury_unrelated_to_police" VARCHAR,
"subject_injury_none" VARCHAR,
"subject_treated_decon" VARCHAR,
"subject_treated_firstaid" VARCHAR,
"subject_treated_police_firstaid" VARCHAR,
"subject_treated_ems_firstaid" VARCHAR,
"subject_treated_hospital" VARCHAR,
"subject_treated_refused" VARCHAR,
"subject_treated_none" VARCHAR,
"subj_feet" VARCHAR,
"subj_hands_fists" VARCHAR,
"subj_strike" VARCHAR,
"subj_handgun_pointed" VARCHAR,
"subj_handgun_discharged" VARCHAR,
"subj_knife" VARCHAR,
"subj_oc_aerosol_pointed" VARCHAR,
"subj_oc_aerosol_discharged" VARCHAR,
"subj_shotgun_rifle_pointed" VARCHAR,
"subj_shotgun_rifle_discharged" VARCHAR,
"subj_vehicle" VARCHAR,
"subj_pepperball_pointed" VARCHAR,
"subj_pepperball_discharged" VARCHAR,
"ofc_race" VARCHAR,
"ofc_gender" VARCHAR,
"ofc_age" BIGINT,
"ofc_district_unit_of_assignment" VARCHAR,
"ofc_assaulted" BOOLEAN,
"ofc_ambushed" BOOLEAN,
"ofc_injury_bruise_soreness" VARCHAR,
"ofc_injury_broken_bones" VARCHAR,
"ofc_injury_laceration_abrasion" VARCHAR,
"ofc_injury_bite" VARCHAR,
"ofc_injury_gunshot" VARCHAR,
"ofc_injury_taser_mark" VARCHAR,
"ofc_injury_none" BOOLEAN,
"ofc_treated_decon" VARCHAR,
"ofc_treated_firstaid" VARCHAR,
"ofc_treated_police_firstaid" VARCHAR,
"ofc_treated_ems_firstaid" VARCHAR,
"ofc_treated_hospital" VARCHAR,
"ofc_treated_refused" VARCHAR,
"ofc_treated_none" BOOLEAN,
"ofc_asp" VARCHAR,
"ofc_canine" VARCHAR,
"ofc_cew_pointed" VARCHAR,
"ofc_cew_discharged" VARCHAR,
"ofc_flashlight" VARCHAR,
"ofc_feet" VARCHAR,
"ofc_hands_fists" VARCHAR
);
Anyone who has the link will be able to view this.