We strive to collect and present available environmental incident substance records, however, the availability of data available can vary from one state to another.
Substance Information
Fields describing the substance involved in the environmental incident:
- Cas Number: Chemical Abstracts Service (CAS) number - unique numeric identifier designated to a specific substance (Example: Natural gas condensates, petroleum (CAS No. 64741-47-5))
- Name: Description of the substance involved in the incident (e.g., crude oil, natural gas condensate, produced water)
- Trade Name: Commercial trade name of the substance spilled
Hazard Classifications
Fields indicating specific hazard characteristics:
- Is Extremely Hazardous Substance: Flag indicating if the substance is classified as extremely hazardous
- Is Radioactive: Flag indicating if the substance is radioactive
Volume Measurements
Fields tracking spill volumes and recovery amounts:
- Estimated Volume: Estimated spill volume in various units (bbl, mcf, gal)
- Estimated Volume Barrels: Estimated spill volume specifically in barrels
- Estimated Volume Pounds: Estimated spill volume in pounds
- Recovered Volume: Volume of substance recovered (bbl, mcf, gal)
- Recovered Volume Barrels: Recovered volume specifically in barrels
Identification and Tracking Fields
The following fields are used to uniquely identify and track environmental incident records:
- ID: Internal unique identifier
- Simple ID: Well identifier formatted as an integer for simple and quick querying
- Well ID: Unique well identifier that distinguishes the specific well involved
- Environmental Incident Record Id: Unique identifier specific to the environmental incident record
- Internal Id: Integer-based unique record identifier optimized for quick querying
Date Fields
These fields track important dates related to the incident record:
- Date Catalogued: Date and time when the record was catalogued into the export database
- Date Created: Date when the record was initially created in WellDatabase
- Date Last Modified: Date when the record was last modified in WellDatabase
Data Model
The schema in our data model provides a complete and detailed framework for capturing and analyzing the data available in WellDatabase.
Explore other articles by searching the topics on the left or if you have any questions feel free to email support@welldatabase.com