phmsa_incidents_search
Which pipeline operators had a reported incident? Search PHMSA pipeline incidents (2010+, gas distribution / hazardous liquid / gas transmission) by operator, operator_id, mode, state, cause, commodity, minimum cost (min_cost), year, or incident date (since). Returns the incident, its entity-resolved operator, location, commodity released, casualties, cost, and cause — a remediation / integrity / claims trigger. Reported exactly as recorded, not a safety judgment. [price: $0.05/row]
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | No | Pipeline mode (gas_distribution | hazardous_liquid | gas_transmission), CSV. | |
| sort | No | incident_date | total_cost | fatalities :asc|:desc. Default incident_date:desc. | |
| year | No | Incident year. | |
| cause | No | Incident cause fragment. | |
| limit | No | Max rows (default 25, cap 100). | |
| since | No | Incident date on/after this date (YYYY-MM-DD). | |
| state | No | Incident state code(s), CSV. | |
| offset | No | Rows to skip. | |
| min_cost | No | Minimum total cost (USD). | |
| operator | No | Operator name — suffix/punctuation-insensitive. | |
| commodity | No | Commodity released fragment. | |
| entity_id | No | Resolved operator entity UUID. | |
| operator_id | No | PHMSA operator id(s), CSV. |