Name: Baton Rouge Fire Incidents
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Baton Rouge Fire Incidents

Emergency calls responded to by the Baton Rouge Fire Department.
Organization: City of Baton Rouge
Last updated: 2020-11-12T14:59:57.577080
Tags: arson, baton-rouge-fire-department, fire

Tables

Table 1

@usgov.city_of_baton_rouge_baton_rouge_fire_incidents.table_1

17.27 MB
396,734 rows
45 columns

CREATE TABLE table_1 (
  "incident_number" VARCHAR,
  "exposure_number" BIGINT,
  "dispatch_date" TIMESTAMP,
  "dispatch_time" VARCHAR,
  "incident_type" DOUBLE,
  "incident_description" VARCHAR,
  "street_number" VARCHAR,
  "street_prefix" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "street_suffix" VARCHAR,
  "formatted_street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "apartment" VARCHAR,
  "cross_street_prefix" VARCHAR,
  "cross_street_name" VARCHAR,
  "cross_street_type" VARCHAR,
  "cross_street_suffix" VARCHAR,
  "rural" VARCHAR,
  "property_loss" BIGINT,
  "contents_loss" BIGINT,
  "fire_service_fatality" BIGINT,
  "fire_service_injury" BIGINT,
  "civilian_fatality" BIGINT,
  "civilian_injury" BIGINT,
  "property_value" BIGINT,
  "contents_value" BIGINT,
  "alarms" BIGINT,
  "suppression_apparatus" BIGINT,
  "suppression_personnel" BIGINT,
  "ems_apparatus" BIGINT,
  "ems_personnel" BIGINT,
  "rescue_apparatus" BIGINT,
  "rescue_personnel" BIGINT,
  "other_apparatus" BIGINT,
  "other_personnel" BIGINT,
  "control_date" TIMESTAMP,
  "control_time" VARCHAR,
  "clear_date" TIMESTAMP,
  "clear_time" VARCHAR,
  "cause_of_ignition" VARCHAR,
  "cause_of_ignition_description" VARCHAR,
  "geolocation" VARCHAR
);