About this Dataset

Ambulance Patient Offload Times

A. SUMMARY This dataset includes aggregated metrics of ambulance patient offload time for ambulance transports to San Francisco hospitals. B. HOW THE DATASET IS CREATED This dataset contains aggregated data by hospital and month for two metrics: 90th percentile of ambulance patient offload time (APOT) and number of patients by discrete APOT category. The dataset also includes systemwide data for both metrics. APOT is defined as the interval between the arrival of an ambulance patient at an emergency department and the time that the patient is transferred to an emergency department gurney, bed, chair, or other acceptable location and the emergency department assumes responsibility for care of the patient. C. UPDATE PROCESS The data is updated monthly by San Francisco Emergency Medical Services Agency. D. HOW TO USE THIS DATASET This dataset is based on EMS patient care reports received from a state database. Please note that you must first filter by Hospital_full and Metric_unit before aggregating the Value field.
Organization: City of San Francisco
Last updated: 2025-03-29T16:48:51.885876

Tables

Table 1

@usgov.city_of_san_francisco_ambulance_patient_offload_times.table_1

14.86 kB
1,397 rows
9 columns

CREATE TABLE table_1 (
  "month_year" VARCHAR,
  "month_start_date" TIMESTAMP,
  "hospital_full" VARCHAR,
  "hospital_abbrev" VARCHAR,
  "metric_unit" VARCHAR,
  "metric_definition" VARCHAR,
  "value" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);