About this Dataset

Hospital Diversions

A. SUMMARY This dataset includes hospital diversion events declared by San Francisco hospitals. B. HOW THE DATASET IS CREATED San Francisco hospitals can declare ambulance diversion status, which diverts all ambulance transports away from the hospital of interest except certain specialty calls. This dataset contains number of diversion hours for each hospital. Each record includes the hospital name, the date and time diversion status started, the date and time diversion status ended, and duration of diversion status. C. UPDATE PROCESS The data is updated monthly by San Francisco Emergency Medical Services Agency. D. HOW TO USE THIS DATASET Hospitals are allowed to go on diversion for a maximum of 2 hours before they must re-declare diversion. If 4 or more hospitals go on diversion at the same time, diversion is suspended across all hospitals which means that no hospitals can go on diversion for the next 4 hours. The exception is San Francisco General (SFG) hospital. SFG can declare Trauma Override (functionally identical to hospital diversion) while diversion is suspended since it is San Francisco’s only trauma center. Please refer to the Hospital Suspensions dataset for more information on diversion suspension.
Organization: City of San Francisco
Last updated: 2025-03-29T17:10:07.425502

Tables

Table 1

@usgov.city_of_san_francisco_hospital_diversions.table_1

295.49 kB
16,292 rows
8 columns

CREATE TABLE table_1 (
  "hospital_full" VARCHAR,
  "hospital_abbrev" VARCHAR,
  "diversion_category" VARCHAR,
  "started" VARCHAR,
  "ended" VARCHAR,
  "duration_in_minutes" BIGINT,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);