Facility Accidents View
Data license: ODbL · Data source: EDGI Cloud Portal
6 rows where facility_address = "2150 East 37th Street" and facility_name = "Lone Star Beef Processors, Inc."
This data as json, CSV (advanced)
facility_name 1
- Lone Star Beef Processors, Inc. · 6 ✖
facility_address 1
- 2150 East 37th Street · 6 ✖
city 1
| id ▼ | facility_accident_id | accident_id | facility_id | facility_name | facility_address | city | state | county | date_of_accident | time_accident_began | release_duration | naics_code | chemical_names | latitude | longitude | popup |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1360 | 100000189529_1 | Accident 1 | 100000189529 | Lone Star Beef Processors, Inc. | 2150 East 37th Street | San Angelo | TX | Tom Green | April 2020 | 02:00 | 008 Hours 30 Minutes | 31161 | Ammonia (anhydrous) | 31.497778 | -100.403333 | {"title":"Lone Star Beef Processors, Inc.","description":"2150 East 37th Street, San Angelo, TX Tom Green","link":"/risk-management-plans/facility_accidents_view/1360"} |
| 1361 | 100000189529_2 | Accident 2 | 100000189529 | Lone Star Beef Processors, Inc. | 2150 East 37th Street | San Angelo | TX | Tom Green | April 2019 | 01:30 | 000 Hours 50 Minutes | 31161 | Ammonia (anhydrous) | 31.497778 | -100.403333 | {"title":"Lone Star Beef Processors, Inc.","description":"2150 East 37th Street, San Angelo, TX Tom Green","link":"/risk-management-plans/facility_accidents_view/1361"} |
| 1362 | 100000189529_3 | Accident 3 | 100000189529 | Lone Star Beef Processors, Inc. | 2150 East 37th Street | San Angelo | TX | Tom Green | January 2019 | 11:00 | 000 Hours 09 Minutes | 31161 | Ammonia (anhydrous) | 31.497778 | -100.403333 | {"title":"Lone Star Beef Processors, Inc.","description":"2150 East 37th Street, San Angelo, TX Tom Green","link":"/risk-management-plans/facility_accidents_view/1362"} |
| 1363 | 100000189529_4 | Accident 4 | 100000189529 | Lone Star Beef Processors, Inc. | 2150 East 37th Street | San Angelo | TX | Tom Green | April 2017 | 13:00 | 003 Hours 00 Minutes | 31161 | Ammonia (anhydrous) | 31.497778 | -100.403333 | {"title":"Lone Star Beef Processors, Inc.","description":"2150 East 37th Street, San Angelo, TX Tom Green","link":"/risk-management-plans/facility_accidents_view/1363"} |
| 1364 | 100000189529_5 | Accident 5 | 100000189529 | Lone Star Beef Processors, Inc. | 2150 East 37th Street | San Angelo | TX | Tom Green | February 2015 | 11:45 | 006 Hours 15 Minutes | 31161 | Ammonia (anhydrous) | 31.497778 | -100.403333 | {"title":"Lone Star Beef Processors, Inc.","description":"2150 East 37th Street, San Angelo, TX Tom Green","link":"/risk-management-plans/facility_accidents_view/1364"} |
| 1365 | 100000189529_6 | Accident 6 | 100000189529 | Lone Star Beef Processors, Inc. | 2150 East 37th Street | San Angelo | TX | Tom Green | October 2014 | 04:00 | 000 Hours 45 Minutes | 31161 | Ammonia (anhydrous) | 31.497778 | -100.403333 | {"title":"Lone Star Beef Processors, Inc.","description":"2150 East 37th Street, San Angelo, TX Tom Green","link":"/risk-management-plans/facility_accidents_view/1365"} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE facility_accidents_view (
id INTEGER PRIMARY KEY AUTOINCREMENT,
facility_accident_id TEXT,
accident_id TEXT,
facility_id TEXT,
facility_name TEXT,
facility_address TEXT,
city TEXT,
state TEXT,
county TEXT,
date_of_accident TEXT,
time_accident_began TEXT,
release_duration TEXT,
naics_code TEXT,
chemical_names TEXT,
latitude REAL,
longitude REAL
, popup TEXT);
CREATE INDEX idx_accident_id ON facility_accidents_view(facility_accident_id);