Stop Data
District of Columbia
@usgov.district_of_columbia_stop_data_b6fdf
District of Columbia
@usgov.district_of_columbia_stop_data_b6fdf
CREATE TABLE table_1 (
"ccn_anonymized" VARCHAR,
"stop_type" VARCHAR,
"stop_location_block" VARCHAR,
"datetime" TIMESTAMP,
"stop_district" VARCHAR,
"stop_duration_mins" DOUBLE,
"stop_reason_nonticket" VARCHAR,
"stop_reason_harbor" VARCHAR,
"stop_reason_ticket" VARCHAR,
"person_search_pat_down" BIGINT,
"property_search_pat_down" BIGINT,
"person_search_consent" BIGINT,
"person_search_prob_cause" BIGINT,
"person_prot_pat_down" BIGINT,
"person_search_warrant" BIGINT,
"property_search_consent" BIGINT,
"property_search_prob_cause" BIGINT,
"property_prot_pat_down" BIGINT,
"property_search_warrant" BIGINT,
"person_search_rea_consent" VARCHAR,
"person_srch_prob_cause" VARCHAR,
"person_pat_down_reason" VARCHAR,
"person_srch_reason_warrant" VARCHAR,
"prop_srch_reason_consent" VARCHAR,
"prop_srch_prob_cause" VARCHAR,
"prop_pat_down_reason" VARCHAR,
"prop_srch_reason_warrant" VARCHAR,
"property_srch_obj_consent" VARCHAR,
"prop_srch_obj_prob_cause" VARCHAR,
"prop_pat_down_obj" VARCHAR,
"prop_srch_obj_warrant" VARCHAR,
"person_srch_obj_seized_con" VARCHAR,
"person_srch_obj_prob_cause" VARCHAR,
"per_pro_pat_down_obj_seize" VARCHAR,
"person_srch_obj_seized_war" VARCHAR,
"prop_srch_obj_seize_con" VARCHAR,
"prop_srch_obj_seize_cause" VARCHAR,
"prop_pat_down_obj_seized" VARCHAR,
"prop_search_obj_warrant" VARCHAR,
"tickets_issued" VARCHAR,
"warnings_issued" VARCHAR,
"voided_tickets" VARCHAR,
"ticket_count" VARCHAR,
"warning_count" VARCHAR,
"void_count" VARCHAR,
"arrest_charges" VARCHAR,
"arrest_charges_category" VARCHAR,
"arrest_date" VARCHAR,
"gender" VARCHAR,
"ethnicity" VARCHAR,
"age" VARCHAR,
"vehicle" BIGINT,
"bicycle_pmd" BIGINT,
"pedestrian" BIGINT,
"harbor" BIGINT,
"investigative" BIGINT,
"traffic_involved" BIGINT,
"traffic_arrest" BIGINT,
"noi_report_type" VARCHAR,
"noi_officer_bureaus_tma" VARCHAR,
"noi_officer_divisions_tma" VARCHAR,
"noi_officer_units_tma" VARCHAR,
"noi_officer_psas_tma" VARCHAR,
"rms_officer_bureaus_tma" VARCHAR,
"rms_officer_divisons_tma" VARCHAR,
"rms_officer_units_tma" VARCHAR,
"rms_officer_psas_tma" VARCHAR,
"gis_id" VARCHAR,
"objectid" BIGINT,
"globalid" VARCHAR,
"created_date" TIMESTAMP,
"last_edited_date" TIMESTAMP
);
Anyone who has the link will be able to view this.