Name: Oil Pipeline Accidents, 2010-Present
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Oil Pipeline Accidents, 2010-Present

Content

This database includes a record for each oil pipeline leak or spill reported to the Pipeline and Hazardous Materials Safety Administration since 2010. These records include the incident date and time, operator and pipeline, cause of incident, type of hazardous liquid and quantity lost, injuries and fatalities, and associated costs.

Acknowledgements

The oil pipeline accident reports were collected and published by the DOT's Pipeline and Hazardous Materials Safety Administration.

Tables

Database

@kaggle.usdot_pipeline_accidents.database

312.47 kB
2,795 rows
48 columns

CREATE TABLE database (
  "report_number" BIGINT,
  "supplemental_number" BIGINT,
  "accident_year" BIGINT,
  "accident_date_time" VARCHAR,
  "operator_id" BIGINT,
  "operator_name" VARCHAR,
  "pipeline_facility_name" VARCHAR,
  "pipeline_location" VARCHAR,
  "pipeline_type" VARCHAR,
  "liquid_type" VARCHAR,
  "liquid_subtype" VARCHAR,
  "liquid_name" VARCHAR,
  "accident_city" VARCHAR,
  "accident_county" VARCHAR,
  "accident_state" VARCHAR,
  "accident_latitude" DOUBLE,
  "accident_longitude" DOUBLE,
  "cause_category" VARCHAR,
  "cause_subcategory" VARCHAR,
  "unintentional_release_barrels" DOUBLE  -- Unintentional Release (Barrels),
  "intentional_release_barrels" DOUBLE  -- Intentional Release (Barrels),
  "liquid_recovery_barrels" DOUBLE  -- Liquid Recovery (Barrels),
  "net_loss_barrels" DOUBLE  -- Net Loss (Barrels),
  "liquid_ignition" VARCHAR,
  "liquid_explosion" VARCHAR,
  "pipeline_shutdown" VARCHAR,
  "shutdown_date_time" TIMESTAMP,
  "restart_date_time" TIMESTAMP,
  "public_evacuations" DOUBLE,
  "operator_employee_injuries" DOUBLE,
  "operator_contractor_injuries" DOUBLE,
  "emergency_responder_injuries" DOUBLE,
  "other_injuries" DOUBLE,
  "public_injuries" DOUBLE,
  "all_injuries" DOUBLE,
  "operator_employee_fatalities" DOUBLE,
  "operator_contractor_fatalities" DOUBLE,
  "emergency_responder_fatalities" DOUBLE,
  "other_fatalities" DOUBLE,
  "public_fatalities" DOUBLE,
  "all_fatalities" DOUBLE,
  "property_damage_costs" DOUBLE,
  "lost_commodity_costs" DOUBLE,
  "public_private_property_damage_costs" DOUBLE,
  "emergency_response_costs" DOUBLE,
  "environmental_remediation_costs" DOUBLE,
  "other_costs" DOUBLE,
  "all_costs" BIGINT
);