APD Computer Aided Dispatch Incidents

City of Austin

@usgov.city_of_austin_apd_computer_aided_dispatch_incidents

Table List

1 table(290.95 MB)

Table 1

@usgov.city_of_austin_apd_computer_aided_dispatch_incidents.table_1

290.95 MB
5202566 rows
27 columns

incident_number Incident Number	incident_type Incident Type	council_district Council District	mental_health_flag Mental Health Flag	priority_level Priority Level	response_datetime Response Datetime	response_year Response Year	response_month Response Month	response_day_of_week Response Day Of Week	response_hour Response Hour	first_unit_arrived_datetime First Unit Arrived Datetime	call_closed_datetime Call Closed Datetime	sector Sector	initial_problem_description Initial Problem Description	initial_problem_category Initial Problem Category	final_problem_description Final Problem Description	final_problem_category Final Problem Category	unit_time_on_scene Unit Time On Scene	call_disposition_description Call Disposition Description	report_written_flag Report Written Flag	response_time Response Time	geo_id Geo ID	census_block_group Census Block Group
232491149	Officer-Initiated Incident	7	Not Mental Health Incident	Priority 3	09/06/2023 05:46:10 PM	2023	Sep	Wed	17	09/06/2023 05:46:10 PM	09/06/2023 06:06:34 PM	Edward	Stalled Vehicle	Traffic Stop/Hazard	Stalled Vehicle	Traffic Stop/Hazard	1409	No Report	No		484530412002	4530412002
232671039	Dispatched Incident	7	Not Mental Health Incident	Priority 2	09/24/2023 03:53:03 PM	2023	Sep	Sun	15	09/24/2023 05:59:14 PM	09/24/2023 06:23:30 PM	Edward	Found/Abandoned Hazardous	Drugs	Found/Abandoned Hazardous	Drugs	1456	No Report	No	7718	484530440002	4530440002
231671034	Dispatched Incident	7	Not Mental Health Incident	Priority 2	06/16/2023 04:44:39 PM	2023	Jun	Fri	16	06/16/2023 04:49:12 PM	06/16/2023 04:58:25 PM	Edward	Trespass Urgent	Trespassing	Trespass Urgent	Trespassing	553	Unable To Locate	No	323	484530412001	4530412001
231780120	Dispatched Incident	10	Not Mental Health Incident	Priority 2	06/27/2023 02:51:02 AM	2023	Jun	Tue	2	06/27/2023 03:16:24 AM	06/27/2023 03:26:32 AM	Adam	Traffic Hazard	Traffic Stop/Hazard	Traffic Hazard	Traffic Stop/Hazard	762	Unable To Locate	No	1563	484530329003	4530329003
231910266	Officer-Initiated Incident	2	Not Mental Health Incident	Priority 3	07/10/2023 06:11:07 AM	2023	Jul	Mon	6	07/10/2023 06:11:07 AM	07/10/2023 11:23:27 AM	Airport	Security Checkpoint Assign	Administrative	Security Checkpoint Assign	Administrative	18740	10/8 From Traffic	No		484539800001	4539800001
231171574	Officer-Initiated Incident	9	Not Mental Health Incident	Priority 3	04/27/2023 11:26:05 PM	2023	Apr	Thu	23	04/27/2023 11:26:05 PM	04/28/2023 02:27:37 AM	George	Directed Patrol	Administrative	Directed Patrol	Administrative	3894	No Report	No		484530011031	4530011031
231290814	Dispatched Incident	7	Not Mental Health Incident	Priority 2	05/09/2023 02:46:13 PM	2023	May	Tue	14	05/09/2023 02:57:22 PM	05/09/2023 03:05:37 PM	Edward	Traffic Hazard	Traffic Stop/Hazard	Traffic Hazard	Traffic Stop/Hazard	495	Unable To Locate	No	718	484530429002	4530429002
161630367	Officer-Initiated Incident		Not Mental Health Incident	Priority 3	06/11/2016 04:17:53 AM	2016	Jun	Sat	4	06/11/2016 04:18:16 AM	06/11/2016 06:29:15 AM	Edward	Criminal Trespass	Trespassing	Criminal Trespass	Trespassing	7859	Report Written	Yes		484530410001	4530410001
171531573	Dispatched Incident	9	Not Mental Health Incident	Priority 3	06/02/2017 07:28:13 PM	2017	Jun	Fri	19	06/02/2017 07:39:43 PM	06/02/2017 07:53:00 PM	George	Check Welfare Urgent	Welfare Check	Check Welfare Service	Welfare Check	797	Non-Police Matter	No	776	484530011031	4530011031
162990965	Officer-Initiated Incident		Not Mental Health Incident	Priority 3	10/25/2016 02:41:31 PM	2016	Oct	Tue	14	10/25/2016 02:41:32 PM	10/25/2016 03:08:03 PM	Edward	Traffic Stop	Traffic Stop/Hazard	Traffic Stop	Traffic Stop/Hazard	1591	10/8 From Traffic	No		484530429002	4530429002


CREATE TABLE table_1 (
  "incident_number" BIGINT,
  "incident_type" VARCHAR,
  "council_district" BIGINT,
  "mental_health_flag" VARCHAR,
  "priority_level" VARCHAR,
  "response_datetime" VARCHAR,
  "response_year" BIGINT,
  "response_month" VARCHAR,
  "response_day_of_week" VARCHAR,
  "response_hour" BIGINT,
  "first_unit_arrived_datetime" VARCHAR,
  "call_closed_datetime" VARCHAR,
  "sector" VARCHAR,
  "initial_problem_description" VARCHAR,
  "initial_problem_category" VARCHAR,
  "final_problem_description" VARCHAR,
  "final_problem_category" VARCHAR,
  "number_of_units_arrived" DOUBLE,
  "unit_time_on_scene" DOUBLE,
  "call_disposition_description" VARCHAR,
  "report_written_flag" VARCHAR,
  "response_time" DOUBLE,
  "officer_injured_killed_count" BIGINT,
  "subject_injured_killed_count" BIGINT,
  "other_injured_killed_count" BIGINT,
  "geo_id" DOUBLE,
  "census_block_group" DOUBLE
);