Fire Incidents In City Of Pittsburgh by US Government | Demographics and Population Studies

About this Dataset

Fire Incidents In City Of Pittsburgh

Incidents of fire responded to by the Pittsburgh Bureau of Fire.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T17:59:25.487141
Tags: _etl, emergency, fire, incident, pbf, pittsburgh, pittsburgh-fire, safety

Tables

Fire Incidents

@usgov.allegheny_county_city_of_pitts_fire_incidents_in_city__988df9cc.fire_incidents

606.48 KB
10604 rows
19 columns


CREATE TABLE fire_incidents (
  "n__id" BIGINT,
  "call_no" VARCHAR,
  "incident_type" DOUBLE,
  "type_description" VARCHAR,
  "address" VARCHAR,
  "alarms" BIGINT,
  "alarm_time" TIMESTAMP,
  "primary_unit" VARCHAR,
  "census_tract" VARCHAR,
  "neighborhood" VARCHAR,
  "council_district" DOUBLE,
  "ward" DOUBLE,
  "tract" DOUBLE,
  "public_works_division" DOUBLE,
  "pli_division" DOUBLE,
  "police_zone" DOUBLE,
  "fire_zone" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Fire Incidents Data Dictionary

@usgov.allegheny_county_city_of_pitts_fire_incidents_in_city__988df9cc.fire_incidents_data_dictionary

7.17 KB
18 rows
9 columns


CREATE TABLE fire_incidents_data_dictionary (
  "field_name" VARCHAR,
  "description" VARCHAR,
  "data_type" VARCHAR,
  "dataformat" VARCHAR,
  "length" VARCHAR,
  "uniqueid" VARCHAR,
  "permittedvalues" VARCHAR,
  "fieldpublicaccesslevel" VARCHAR,
  "fieldpublicaccesslevelcomment" VARCHAR
);