"lacity/lafd-response-metrics-raw-data-n44u-wxe4:latest"."lafd_response_metrics_raw_data"

SELECT
    ":id", -- Socrata column ID
    "on_scene_time_gmt", -- *CAD captures the time when LAFD resources arrive at the scene of the incident when the corresponding key is pressed at the resource’s MDC. *It must be noted that the recording of En Route Time and On-Scene Time is an event-driven process that requires first-responder interaction. The precision of those time stamps depends on the timeliness of when the user manually activates the respective function key on the MDC (Mobile Data Computer).  
    "en_route_time_gmt", -- *CAD captures the time when LAFD resources leave quarters by storing the time in which the corresponding key is pressed at the resource’s Mobile Data Computer (MDC). *It must be noted that the recording of En Route Time and On-Scene Time is an event-driven process that requires first-responder interaction. The precision of those time stamps depends on the timeliness of when the user manually activates the respective function key on the MDC (Mobile Data Computer). 
    "time_of_dispatch_gmt", -- CAD automatically captures the time a fire station is notified and provided dispatch instructions via the LAFD’s Fire Station Alerting System. Notification is simultaneously made via FAX, DATA, and AUDIO to the responding unit(s).
    "dispatch_status", -- The status of the responding unit at the time of dispatch. For example, status “QTR” means a unit responded from quarters, “RAD” means a unit responded from a radio call in and was not in quarters at the time, “AVI” means the unit is available, typically when released from an incident, and “ONS” means the unit is on-scene.
    "dispatch_sequence", -- The number assigned to each resource in the order in which it is dispatched to the incident.  There may be numbers that are skipped in the sequence.  This is due to the vehicle being assigned to the incident but then removed before it is dispatched.  The dynamic situation of an emergency call allows for additions or removal of resources as more information is gathered.  There may also be duplicate numbers in the sequence.  This is due to the merging of incidents, once it is discovered that there is more than one call received for the same incident.
    "first_in_district", -- The location where the incident occurred in terms of a Fire Station district.  The area where a particular fire station responds as well as where the incident occurred.
    "randomized_incident_number", -- This is the incident number for the call that has had to be re-identified for the purposes of medical patient protection.  LAFD is considered a medical service provider*.  This number is generated with the year and quarter indicator with a six digits randomized number attached, i.e. – 201301345785, this number means it is in the year 2013 in the first quarter.  *LAFD must therefore comply with the HIPAA law (Health Insurance Portability and Accountability Act of 1996).   We can only release data which contains no ‘individually identifiable health information’, (IIHI), and therefore no ‘protected health information’, (PHI).
    "incident_creation_time_gmt", -- The time when the call‐taker is presented with the call and takes charge of it, then creates an incident record in CAD. During this process, the call‐taker verifies the address information and interviews the caller to find out what the nature of the call.
    "emergency_dispatch_code", -- Indicates whether an incident was categorized as emergency or non-emergency. This dataset contains information related to emergency incidents only.  
    "ppe_level", -- EMS category includes incident types that require minimum PPE* and a Turnout Time of 60 seconds. The majority of these incidents are medical in nature and do not require fire suppression tools and equipment to mediate. The NON-EMS category includes incidents that require full PPE* and a Turnout Time of 80 seconds. The majority of these incidents require fire suppression tools and equipment to mediate and may result in patients that require medical evaluation and treatment.  *Personal Protective Equipment
    "unit_type" -- The type of responding unit.
FROM
    "lacity/lafd-response-metrics-raw-data-n44u-wxe4:latest"."lafd_response_metrics_raw_data"
LIMIT 100;

sgr mount socrata \
  "lacity/lafd-response-metrics-raw-data-n44u-wxe4" \
  --handler-options '{
    "domain": "data.lacity.org",
    "tables": {
        "lafd_response_metrics_raw_data": "n44u-wxe4"
    }
}'