Dataset: Fire Department And Emergency Medical Services Dispatched Calls For Service

About this Dataset

Fire Department And Emergency Medical Services Dispatched Calls For Service

A. SUMMARY Fire Calls-For-Service includes all fire units' responses to 911 calls from the city's Computer-Aided Dispatch (“CAD”) system. This includes responses to Medical Incidents requiring EMS staff. Each record includes the call number, incident number, address, unit identifier, call type, and disposition. All relevant time intervals are also included. Because this dataset is based on responses, and since most calls involve multiple units, there are multiple records for each call number. Addresses are associated with an intersection or call box, not a specific address. B. HOW THE DATASET IS CREATED This dataset is an extract from the Department of Emergency Management’s computer-aided dispatch system. The dataset is enhanced with fire-department specific information before being uploaded to the open data portal. C. UPDATE PROCESS This dataset updates daily via automated data pipeline. D. HOW TO USE THIS DATASET This dataset is based on responses, and since most calls involve multiple units, there are multiple records for each call number. The most common call types are Medical Incidents, Alarms, Structure Fires, and Traffic Collisions. E. RELATED DATASETS Fire Incidents
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:47.651513
Tags: 911, calls, emergency-calls, fire, medical

Tables

Table 1

@usgov.city_of_san_francisco_fire_department_calls_for_service.table_1

580.23 MB
6952789 rows
37 columns


CREATE TABLE table_1 (
  "call_number" BIGINT,
  "unit_id" VARCHAR,
  "incident_number" BIGINT,
  "call_type" VARCHAR,
  "call_date" TIMESTAMP,
  "watch_date" TIMESTAMP,
  "received_dttm" VARCHAR,
  "entry_dttm" VARCHAR,
  "dispatch_dttm" VARCHAR,
  "response_dttm" VARCHAR,
  "on_scene_dttm" VARCHAR,
  "transport_dttm" VARCHAR,
  "hospital_dttm" VARCHAR,
  "call_final_disposition" VARCHAR,
  "available_dttm" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "zipcode_of_incident" DOUBLE,
  "battalion" VARCHAR,
  "station_area" VARCHAR,
  "box" VARCHAR,
  "original_priority" VARCHAR,
  "priority" VARCHAR,
  "final_priority" BIGINT,
  "als_unit" BOOLEAN,
  "call_type_group" VARCHAR,
  "number_of_alarms" BIGINT,
  "unit_type" VARCHAR,
  "unit_sequence_in_call_dispatch" DOUBLE,
  "fire_prevention_district" VARCHAR,
  "supervisor_district" VARCHAR,
  "neighborhooods_analysis_boundaries" VARCHAR,
  "rowid" VARCHAR,
  "case_location" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhoods" DOUBLE
);