Stop Data 2019 To 2022

District of Columbia

@usgov.district_of_columbia_stop_data_2019_to_2022

Table List

1 table(24.24 MB)

Table 1

@usgov.district_of_columbia_stop_data_2019_to_2022.table_1

24.24 MB
279936 rows
61 columns

ccn_anonymized CCN ANONYMIZED	stop_type STOP TYPE	datetime DATETIME	stop_location STOP LOCATION	stop_district STOP DISTRICT	stop_reason_nonticket STOP REASON NONTICKET	stop_reason_harbor STOP REASON HARBOR	stop_reason_ticket STOP REASON TICKET	person_search_pat_down PERSON SEARCH PAT DOWN	person_prot_pat_down PERSON PROT PAT DOWN	person_search_rea_consent PERSON SEARCH REA CONSENT	person_srch_prob_cause PERSON SRCH PROB CAUSE	person_pat_down_reason PERSON PAT DOWN REASON	person_srch_reason_warrant PERSON SRCH REASON WARRANT	prop_srch_reason_consent PROP SRCH REASON CONSENT	prop_srch_prob_cause PROP SRCH PROB CAUSE	prop_pat_down_reason PROP PAT DOWN REASON	prop_srch_reason_warrant PROP SRCH REASON WARRANT	property_srch_obj_consent PROPERTY SRCH OBJ CONSENT	prop_srch_obj_prob_cause PROP SRCH OBJ PROB CAUSE	prop_pat_down_obj PROP PAT DOWN OBJ	prop_srch_obj_warrant PROP SRCH OBJ WARRANT	person_srch_obj_seized_con PERSON SRCH OBJ SEIZED CON	person_srch_obj_prob_cause PERSON SRCH OBJ PROB CAUSE	per_pro_pat_down_obj_seize PER PRO PAT DOWN OBJ SEIZE	person_srch_obj_seized_war PERSON SRCH OBJ SEIZED WAR	prop_srch_obj_seize_con PROP SRCH OBJ SEIZE CON	prop_srch_obj_seize_cause PROP SRCH OBJ SEIZE CAUSE	prop_pat_down_obj_seized PROP PAT DOWN OBJ SEIZED	prop_search_obj_warrant PROP SEARCH OBJ WARRANT	tickets_issued TICKETS ISSUED	warnings_issued WARNINGS ISSUED	voided_tickets VOIDED TICKETS	arrest_charges ARREST CHARGES	gender GENDER	ethnicity ETHNICITY	age AGE	investigative INVESTIGATIVE	objectid OBJECTID	globalid GLOBALID
df8eab5aa9c8055c8ec149204d376beeb422e182bbbb710d2954722dd5231958	Non-ticket Stop	Wed Dec 29 2021 13:00:00 GMT+0000 (Coordinated Universal Time)	300 BLOCK OF 33RD DC, DC 20019 UNITED STATES	6	Call for service	NA	NA			NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NULL	NULL	NULL	NULL	Male	Black	Unknown	1	280321	{96FB2C7A-1B0A-45F2-9A65-0B900CD8E87A}
364201002193313ae4b99e8455517ec24ce28a63d5446dc5bb389b023d1e1c42	Non-ticket Stop	Wed Dec 29 2021 13:48:00 GMT+0000 (Coordinated Universal Time)	NA	4	Call for service	NA	NA			NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NULL	NULL	NULL	NULL	Male	Black	32	1	280322	{C0F1EC59-8B26-4618-86B0-3A0C480DB33E}
367f1304e9ac5c4bb5bbd42fc75091ec689f5a45cbc385a569b5157e73d6fc2a	Non-ticket Stop	Wed Dec 29 2021 15:07:00 GMT+0000 (Coordinated Universal Time)	3700 BLOCK OF MINNESOTA AVENUE NE WASHINGTON, DC 20019 UNITED STATES	6	Call for service	NA	NA			NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NULL	NULL	NULL	NULL	Male	Black	24	1	280323	{0BB100B4-A06A-467C-91FC-95558659796A}
c25fb89c2c556d230540a574de9b48e7ba2317f584a55d0b2a50126082ff3bc7	Non-ticket Stop	Wed Dec 29 2021 15:00:00 GMT+0000 (Coordinated Universal Time)	4100 BLOCK OF 1ST DC, WASHINGTON 20032 UNITED STATES	NA	Call for service	NA	NA	1	1	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NULL	NULL	NULL	NULL	Male	Black	Juvenile	1	280324	{570F50DD-47E4-4CF6-803E-AB82753B9CE1}
c25fb89c2c556d230540a574de9b48e7ba2317f584a55d0b2a50126082ff3bc7	Non-ticket Stop	Wed Dec 29 2021 15:00:00 GMT+0000 (Coordinated Universal Time)	4100 BLOCK OF 1ST DC, WASHINGTON 20032 UNITED STATES	NA	Call for service	NA	NA			NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NULL	NULL	NULL	NULL	Male	Black	21	1	280325	{EF316A0F-77C9-4710-923A-DFA41CDA546F}
c25fb89c2c556d230540a574de9b48e7ba2317f584a55d0b2a50126082ff3bc7	Non-ticket Stop	Wed Dec 29 2021 15:00:00 GMT+0000 (Coordinated Universal Time)	4400 BLOCK OF 3RD STREET SE WASHINGTON, DC 20032 UNITED STATES	7	Call for service	NA	NA			NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NULL	NULL	NULL	NULL	Male	Black	18	1	280326	{C0220DE1-F52C-4AEF-B795-2A18695D93E6}
c09cf80d23be21211e6c4f4c8a6ca4a7c8042873f700e9133e90b4c76b1e86f6	Non-ticket Stop	Wed Dec 29 2021 15:00:00 GMT+0000 (Coordinated Universal Time)	900 BLOCK OF I STREET NW WASHINGTON, DC 20001 UNITED STATES	NA	Observed a weapon	NA	NA			NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NULL	NULL	NULL	NULL	Male	American Indian/Alaska Native	52	1	280327	{B6B1D012-2894-4FF5-8E81-B8C571114324}
676b7f2542605665e82cdf37bc4dcf60bcbc45e9687a41adf1ada3edc5ade59e	Non-ticket Stop	Wed Dec 29 2021 15:25:00 GMT+0000 (Coordinated Universal Time)	4600 BLOCK OF 4TH STREET NW WASHINGTON, DC 20011 UNITED STATES	4	Call for service	NA	NA			NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NULL	NULL	NULL	NULL	Male	Black	51	1	280328	{37E78E8F-0961-4B70-800F-3B0C648CEB2C}
7e7942632f242a86db314ebab16943160c5bfb028f69ecd2eb5a16b8ea4da4ba	Non-ticket Stop	Wed Dec 29 2021 15:50:00 GMT+0000 (Coordinated Universal Time)	1000 BLOCK OF 3RD STREET SW WASHINGTON, DC 20024 UNITED STATES	1	Call for service	NA	NA			NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NULL	NULL	NULL	NULL	Male	Black	Juvenile	1	280329	{3C114AEB-18A7-49DF-B4D2-5CC96C71A4D4}
af6d02d6a1707bab5e2525370533c55e7c3a161bb6cf3013a0399bbf049e4fc9	Non-ticket Stop	Wed Dec 29 2021 17:45:00 GMT+0000 (Coordinated Universal Time)	300 BLOCK OF 56TH STREET NE WASHINGTON, DC 20019 UNITED STATES	6	Call for service	NA	NA			NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NULL	NULL	NULL	NULL	Male	Black	Unknown	1	280330	{18279B48-35BB-443C-A60F-2B3A9A0354CB}


CREATE TABLE table_1 (
  "ccn_anonymized" VARCHAR,
  "stop_type" VARCHAR,
  "datetime" TIMESTAMP,
  "stop_location" VARCHAR,
  "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" BIGINT,
  "warning_count" BIGINT,
  "void_count" BIGINT,
  "arrest_charges" VARCHAR,
  "gender" VARCHAR,
  "ethnicity" VARCHAR,
  "age" VARCHAR,
  "arrest_date" TIMESTAMP,
  "vehicle" BIGINT,
  "bicycle_pmd" BIGINT,
  "pedestrian" BIGINT,
  "harbor" BIGINT,
  "investigative" BIGINT,
  "traffic_involved" BIGINT,
  "gis_id" VARCHAR,
  "created" VARCHAR,
  "edited" VARCHAR,
  "objectid" BIGINT,
  "globalid" VARCHAR
);