Factory Waste Water Compliance Logs
This dataset provides detailed, real-time logs of factory waste water discharge compliance, including parameter measurements, regulatory thresholds, compliance status, triggered alerts, and corrective actions. It enables proactive environmental management, supports ESG reporting, and facilitates regulatory audits by capturing all relevant compliance events and responses in a structured, auditable format.
Sample rows
preview · 8 of 120 rows · all 26 columns| log_idstring | parameter_namestring | regulatory_limitfloat | alert_triggeredboolean | factory_citystring | factory_idstring | factory_namestring | factory_street_addressstring | factory_statestring | factory_postal_codestring | factory_countrystring | discharge_point_idstring | discharge_point_descriptionstring | sample_datetimedatetime | parameter_unitstring | measured_valuefloat | compliance_statusstring | alert_typestring | alert_datetimedatetime | corrective_action_requiredboolean | action_statusstring | action_completion_datetimedatetime | logged_by_user_idstring | log_created_datetimedatetime | corrective_action_descriptionstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CL000001 | COD | 120 | false | Springfield | FCT001 | Green Valley Textiles | 10 Willow Lane | Illinois | 62704 | USA | DP01 | North Outflow | 2024-01-15T09:15:00Z | mg/L | 110.5 | compliant | blank | blank | false | blank | blank | USR101 | 2024-01-15T09:16:12Z | blank | Routine check, no anomalies detected. |
| CL000002 | BOD | 50 | false | Greenville | FCT002 | Blue Ridge Chemicals | 22 Industrial Ave | South Carolina | 29607 | USA | DP02 | Main Effluent | 2024-01-15T10:05:00Z | mg/L | 40.2 | compliant | blank | blank | false | blank | blank | USR102 | 2024-01-15T10:06:12Z | blank | BOD levels within expected range. |
| CL000003 | pH | 6.5 | true | Raleigh | FCT003 | Sunrise Paper Mills | 501 Elm Street | North Carolina | 27601 | USA | DP03 | East Channel | 2024-01-15T11:20:00Z | pH units | 7.1 | non-compliant | regulatory breach | 2024-01-15T11:30:00Z | true | pending | blank | USR103 | 2024-01-15T11:25:45Z | Adjust neutralization process to reduce pH. | pH slightly above permitted limit; corrective action flagged. |
| CL000004 | TSS | 100 | false | Columbus | FCT004 | Urban Plastics Ltd | 45 Central Road | Ohio | 43215 | USA | DP04 | South Outfall | 2024-01-16T08:50:00Z | mg/L | 89.8 | compliant | blank | blank | false | blank | blank | USR104 | 2024-01-16T08:52:13Z | blank | TSS levels satisfactory. |
| CL000005 | Temperature | 30 | false | Buffalo | FCT005 | Northern Metal Works | 300 Foundry St | New York | 14203 | USA | DP05 | West Flow | 2024-01-16T09:35:00Z | °C | 29.5 | compliant | blank | blank | false | blank | blank | USR105 | 2024-01-16T09:36:15Z | blank | Temperature close to limit, monitoring advised. |
| CL000006 | Heavy Metals | 0.05 | false | Denver | FCT006 | Mountain AgroChem | 15 Pine Drive | Colorado | 80216 | USA | DP06 | Northwest Outlet | 2024-01-16T10:10:00Z | mg/L | 0.03 | compliant | blank | blank | false | blank | blank | USR106 | 2024-01-16T10:11:08Z | blank | Heavy metals well below threshold. |
| CL000007 | COD | 120 | true | Portland | FCT007 | Pacific Foods Processing | 88 Market St | Oregon | 97209 | USA | DP07 | Main Channel | 2024-01-16T11:55:00Z | mg/L | 130.2 | non-compliant | sustainability threshold exceeded | 2024-01-16T12:02:00Z | true | in progress | blank | USR107 | 2024-01-16T11:56:33Z | Increase aeration and review organic load. | COD exceeded by 10.2 mg/L; actions underway. |
| CL000008 | BOD | 50 | false | Springfield | FCT001 | Green Valley Textiles | 10 Willow Lane | Illinois | 62704 | USA | DP02 | East Outflow | 2024-01-16T14:30:00Z | mg/L | 35.7 | compliant | blank | blank | false | blank | blank | USR108 | 2024-01-16T14:31:05Z | blank | BOD reduced after last process change. |
| CL000009 | TSS | 100 | true | Austin | FCT008 | Riverbend Electronics | 200 Innovation Blvd | Texas | 78758 | USA | DP08 | South Discharge | 2024-01-17T08:40:00Z | mg/L | 102.5 | non-compliant | regulatory breach | 2024-01-17T08:45:00Z | true | pending | blank | USR109 | 2024-01-17T08:41:33Z | Check sedimentation tanks for blockage. | TSS exceeded by 2.5 mg/L; tank inspection scheduled. |
| CL000010 | Temperature | 30 | false | Kansas City | FCT009 | Central Beverages Inc | 700 Main St | Missouri | 64105 | USA | DP09 | West Outflow | 2024-01-17T09:30:00Z | °C | 28.1 | compliant | blank | blank | false | blank | blank | USR110 | 2024-01-17T09:31:22Z | blank | Temperature stable across recent samples. |
| CL000011 | Heavy Metals | 0.05 | true | Columbia | FCT010 | Silver Leaf Pharmaceuticals | 12 Maple Avenue | Maryland | 21044 | USA | DP10 | Central Egress | 2024-01-17T10:15:00Z | mg/L | 0.07 | non-compliant | regulatory breach | 2024-01-17T10:18:00Z | true | in progress | blank | USR111 | 2024-01-17T10:16:05Z | Install additional filtration for heavy metals. | Heavy metals exceeded; filtration upgrade initiated. |
| CL000012 | pH | 6.5 | true | Toledo | FCT011 | Eastern Dairy Group | 90 Dairy Road | Ohio | 43604 | USA | DP11 | Main Discharge | 2024-01-17T11:00:00Z | pH units | 6.8 | non-compliant | sustainability threshold exceeded | 2024-01-17T11:07:00Z | true | pending | blank | USR112 | 2024-01-17T11:03:33Z | Increase acid dosing in neutralization process. | pH above regulatory limit; dosing change scheduled. |
| CL000013 | COD | 120 | false | Cleveland | FCT012 | Bright Future Plastics | 1200 Polymer Pkwy | Ohio | 44114 | USA | DP12 | North Effluent | 2024-01-17T13:20:00Z | mg/L | 99.7 | compliant | blank | blank | false | blank | blank | USR113 | 2024-01-17T13:22:12Z | blank | COD levels normal for winter season. |
| CL000014 | BOD | 50 | false | Des Moines | FCT013 | Prairie Chemicals | 77 Prairie Rd | Iowa | 50309 | USA | DP13 | East Outlet | 2024-01-17T14:10:00Z | mg/L | 47.1 | compliant | blank | blank | false | blank | blank | USR114 | 2024-01-17T14:11:13Z | blank | BOD within regulatory range. |
| CL000015 | TSS | 100 | false | Omaha | FCT014 | Western Steel Foundry | 350 Steel Dr | Nebraska | 68102 | USA | DP14 | Main Outflow | 2024-01-17T15:25:00Z | mg/L | 95.2 | compliant | blank | blank | false | blank | blank | USR115 | 2024-01-17T15:26:05Z | blank | Routine discharge sample; all parameters within limits. |
| CL000016 | Temperature | 30 | false | Springfield | FCT001 | Green Valley Textiles | 10 Willow Lane | Illinois | 62704 | USA | DP01 | North Outflow | 2024-01-18T09:10:00Z | °C | 29.8 | compliant | blank | blank | false | blank | blank | USR101 | 2024-01-18T09:12:08Z | blank | Temperature checks normal for January. |
| CL000017 | COD | 120 | true | Columbia | FCT010 | Silver Leaf Pharmaceuticals | 12 Maple Avenue | Maryland | 21044 | USA | DP10 | Central Egress | 2024-01-18T10:25:00Z | mg/L | 123.1 | non-compliant | regulatory breach | 2024-01-18T10:29:00Z | true | pending | blank | USR111 | 2024-01-18T10:26:46Z | Review chemical dosing and process control. | COD exceeded; investigation initiated. |
| CL000018 | Heavy Metals | 0.05 | false | Orlando | FCT015 | Sunshine Bottling | 360 Orange Blvd | Florida | 32801 | USA | DP15 | East Channel | 2024-01-18T11:45:00Z | mg/L | 0.02 | compliant | blank | blank | false | blank | blank | USR116 | 2024-01-18T11:47:32Z | blank | Heavy metals below detection limit. |
| CL000019 | pH | 6.5 | false | Madison | FCT016 | Lakeview Dairy | 88 Milk Lane | Wisconsin | 53703 | USA | DP16 | South Outlet | 2024-01-18T12:30:00Z | pH units | 6.3 | compliant | blank | blank | false | blank | blank | USR117 | 2024-01-18T12:31:45Z | blank | pH within normal range. |
| CL000020 | TSS | 100 | true | St. Louis | FCT017 | Midwest Beverages | 44 Brewery Rd | Missouri | 63102 | USA | DP17 | Main Egress | 2024-01-18T13:10:00Z | mg/L | 101.1 | non-compliant | regulatory breach | 2024-01-18T13:15:00Z | true | in progress | blank | USR118 | 2024-01-18T13:11:59Z | Increase clarification and check filter media. | TSS slightly above limit; corrective actions started. |
What the 120 rows show
from the 120-row sampleCOD (parameter name) stands out: mean regulatory_
- 35%alert_
triggered = true - 50.0median regulatory_
limit - 2compliance statuses
- 2alert types
- 2action statuses
- 3parameter units
Median 50.0, from 0.05 to 200.0.
- string 18
- float 2
- datetime 4
- boolean 2
Columns
26 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 18 columns | |||
log_id | string | Unique identifier for each compliance log entryunique | CL000001 |
factory_id | string | Unique identifier for the factory where the waste water sample was taken | FCT001 |
factory_name | string | Name of the factory | Green Valley Textiles |
factory_street_address | string | Street address of the factory | 10 Willow Lane |
factory_city | string | City where the factory is located | Springfield |
factory_state | string | State or region where the factory is located | Illinois |
factory_postal_code | string | Postal code for the factory addressoptional | 62704 |
factory_country | string | Country where the factory is located8 countries | USA |
discharge_point_id | string | Unique identifier for the waste water discharge point | DP01 |
discharge_point_description | string | Description or label for the discharge point (e.g., 'North Outflow')optional | North Outflow |
parameter_name | string | Name of the measured parameter (e.g., pH, COD, BOD, TSS, temperature, heavy metals)8 names | COD |
parameter_unit | string | Unit of measurement for the parameter (e.g., mg/L, °C, pH units)3 units | mg/L |
compliance_status | string | Compliance status of the measured value against the regulatory limitcompliant · non-compliant | compliant |
alert_type | string | Type of alert triggered (e.g., 'regulatory breach', 'sustainability threshold exceeded')2 types · optional | regulatory breach |
corrective_action_description | string | Description of the corrective action to be takenoptional | Adjust neutralization pro… |
action_status | string | Status of the corrective action (e.g., 'pending', 'in progress', 'completed')pending · in progress · completed · optional | pending |
logged_by_user_id | string | Identifier for the user or system that logged the entry | USR101 |
notes | string | Additional notes or comments regarding the compliance eventoptional | TSS levels satisfactory. |
| Numbers 2 columns | |||
measured_value | float | Measured value of the parameter in the waste water sample | 110.5 |
regulatory_limit | float | Regulatory or sustainability threshold for the parameter | 120 |
| Dates and times 4 columns | |||
sample_datetime | datetime | Date and time when the waste water sample was collected | 2024-01-15T09:15:00Z |
alert_datetime | datetime | Date and time when the alert was triggeredoptional | 2024-01-15T11:30:00Z |
action_completion_datetime | datetime | Date and time when the corrective action was completedoptional | |
log_created_datetime | datetime | Timestamp when this compliance log entry was created | 2024-01-15T09:16:12Z |
| True or false 2 columns | |||
alert_triggered | boolean | Indicates if an alert was triggered due to non-compliance | false |
corrective_action_required | boolean | Indicates if corrective action is required due to non-compliance | false |
Use it for
A manufacturing dashboard
The alert_
triggered rate, regulatory_ limit by parameter_ name and a breakdown of factory_ city. Excel, Power BI or Tableau. Why do the 26 COD rows have a mean regulatory_
limit of 153.8? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs120CL000001120CODCL0000036.5pHCL000007120COD
A software demo
Believable logs with factory_
id, factory_ name and factory_ street_ address to fill a screen in front of a buyer.
blueprint · factory-waste-water-compliance-logs
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 26 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Each record represents a single waste water event with sensor timestamp.
- pH, temperature, and contaminant levels must be recorded for every event.
- Events flagged as 'non-compliant' if any parameter exceeds regulatory thresholds.
- Compliance status auto-calculated based on local regulations and factory policy.
- Location and responsible team member must be linked to each event.
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- factory-waste-water-compliance-logs