EMS Incident Dispatch Data
City of New York
@usgov.city_of_new_york_ems_incident_dispatch_data
City of New York
@usgov.city_of_new_york_ems_incident_dispatch_data
CREATE TABLE table_1 (
"cad_incident_id" BIGINT,
"incident_datetime" VARCHAR,
"initial_call_type" VARCHAR,
"initial_severity_level_code" BIGINT,
"final_call_type" VARCHAR,
"final_severity_level_code" BIGINT,
"first_assignment_datetime" VARCHAR,
"valid_dispatch_rspns_time_indc" VARCHAR,
"dispatch_response_seconds_qy" BIGINT,
"first_activation_datetime" VARCHAR,
"first_on_scene_datetime" VARCHAR,
"valid_incident_rspns_time_indc" VARCHAR,
"incident_response_seconds_qy" DOUBLE,
"incident_travel_tm_seconds_qy" DOUBLE,
"first_to_hosp_datetime" VARCHAR,
"first_hosp_arrival_datetime" VARCHAR,
"incident_close_datetime" VARCHAR,
"held_indicator" VARCHAR,
"incident_disposition_code" VARCHAR,
"borough" VARCHAR,
"incident_dispatch_area" VARCHAR,
"zipcode" DOUBLE,
"policeprecinct" DOUBLE,
"citycouncildistrict" DOUBLE,
"communitydistrict" DOUBLE,
"communityschooldistrict" DOUBLE,
"congressionaldistrict" DOUBLE,
"reopen_indicator" VARCHAR,
"special_event_indicator" VARCHAR,
"standby_indicator" VARCHAR,
"transfer_indicator" VARCHAR
);
Anyone who has the link will be able to view this.