Manufacturing Water Usage Audit
This dataset provides granular water usage audit records for manufacturing facilities, detailing consumption, recycling, discharge, and compliance metrics at the production line level. It enables sustainability analysis, regulatory reporting, and targeted water-saving investments by highlighting inefficiencies and benchmarking performance across locations and time periods.
Sample rows
preview · 8 of 120 rows · all 21 columns| audit_idstring | water_source_typestring | water_discharge_m3float | discharge_compliance_statusboolean | facility_address_countrystring | facility_idstring | facility_namestring | facility_address_streetstring | facility_address_citystring | facility_address_statestring | facility_address_postal_codestring | production_line_idstring | production_line_namestring | audit_datedate | total_water_consumed_m3float | water_consumed_per_unit_output_m3float | production_output_unitsinteger | water_recycled_m3float | audit_conducted_bystring | identified_inefficienciesstring | recommended_actionsstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AUD00001 | municipal | 9250 | true | USA | FAC0001 | GreenTech Plastics | 1200 Elmwood Ave | Chicago | IL | 60613 | PL001 | Injection Molding A | 2024-05-12 | 18500 | 0.37 | 50000 | 9250 | J. Miller | Excessive water during mold cooling cycles. | Install advanced cooling system; monitor cycles. |
| AUD00002 | municipal | 6000 | true | USA | FAC0002 | Sunrise Textiles | 88 Textile Park | Charlotte | NC | 28203 | PL002 | Dye Line 3 | 2023-09-27 | 9500 | 0.475 | 20000 | 3500 | Textile Audit Team | High rinse water in dye process, limited recycling. | Upgrade rinse system and expand recycling units. |
| AUD00003 | recycled | 90 | true | USA | FAC0003 | NorthBay Electronics | 540 Silicon Rd | San Jose | CA | 95134 | PL003 | PCB Line B | 2024-02-14 | 780 | 0.13 | 6000 | 690 | D. Tran | Minimal discharge, strong recycling protocols. | Continue recycling program; share practices. |
| AUD00004 | groundwater | 25000 | true | USA | FAC0004 | Eagle Metals | 2201 Steel Blvd | Pittsburgh | PA | 15233 | PL004 | Sheet Rolling X | 2022-11-05 | 31000 | 0.62 | 50000 | 6000 | S. Patel | High water discharge after cooling process. | Upgrade water reuse technology; staff training. |
| AUD00005 | surface | 6900 | true | USA | FAC0005 | Pacific Chemicals | 441 Harbor Lane | Tacoma | WA | 98402 | PL005 | Synthesis Reactor 2 | 2021-04-18 | 8200 | 0.41 | 20000 | 1300 | M. Li | Low recycling rate, excess discharge post-wash. | Install advanced filtration; review wash cycles. |
| AUD00006 | municipal | 4300 | true | India | FAC0006 | Sahara Extracts | blank | Mumbai | MH | 400001 | PL006 | Solvent Recovery | 2023-02-10 | 5000 | 0.5 | 10000 | 700 | N. Desai | High water discharge in cleaning tanks. | Automate tank cleaning; add recycling module. |
| AUD00007 | recycled | 20 | true | Taiwan | FAC0007 | Delta Foods | 220 Rice Drive | Taipei | TP | 11461 | PL007 | Rice Milling | 2020-07-22 | 230 | 0.115 | 2000 | 210 | C. Lin | Efficient recycling; minimal loss during wash. | Maintain current practices; periodic review. |
| AUD00008 | municipal | 11000 | true | Germany | FAC0008 | EuroSteel GmbH | 15 Eisenstrasse | Düsseldorf | NW | 40210 | PL008 | Casting Division | 2024-06-01 | 18000 | 0.36 | 50000 | 7000 | J. Schneider | Cooling tower water not fully recycled. | Upgrade tower; monitor recycling rate. |
| AUD00009 | municipal | 1200 | true | Belgium | FAC0009 | Belgium Textiles | 9 Rue du Coton | Ghent | VLG | 9000 | PL009 | Spinning Line 4 | 2022-05-03 | 1500 | 0.15 | 10000 | 300 | M. De Smet | Moderate water discharge after spinning. | Optimize spinning rinse cycles. |
| AUD00010 | recycled | 6 | true | Norway | FAC0010 | Sunwell Solar | blank | Oslo | OS | 0150 | PL010 | Panel Assembly | 2021-01-28 | 90 | 0.045 | 2000 | 84 | L. Nilsen | Minimal inefficiencies; high recycling. | Maintain recycling system. |
| AUD00011 | municipal | 16500 | true | USA | FAC0001 | GreenTech Plastics | 1200 Elmwood Ave | Chicago | IL | 60613 | PL011 | Extrusion Line B | 2023-10-04 | 25500 | 0.51 | 50000 | 9000 | A. Thompson | High water discharge during extrusion cooling. | Automate cooling; increase recycling. |
| AUD00012 | municipal | 5000 | true | USA | FAC0002 | Sunrise Textiles | 88 Textile Park | Charlotte | NC | 28203 | PL012 | Bleach Line 1 | 2024-04-09 | 7200 | 0.36 | 20000 | 2200 | Textile Audit Team | Bleaching process water not fully recycled. | Install new recycling unit; staff training. |
| AUD00013 | municipal | 8800 | true | USA | FAC0011 | American Foods | 4801 Wheat Rd | Kansas City | MO | 64108 | PL013 | Baking Division | 2023-07-18 | 12000 | 0.24 | 50000 | 3200 | B. Carter | Excess water in baking cleanup cycles. | Optimize cleanup and automate rinse. |
| AUD00014 | groundwater | 3600 | true | Canada | FAC0012 | Ontario Chemicals | 202 Bay St | Toronto | ON | M5J2N8 | PL014 | Distillation Line | 2022-12-02 | 4200 | 0.42 | 10000 | 600 | Y. Wu | Distillation discharge exceeds target. | Upgrade discharge treatment system. |
| AUD00015 | municipal | 5500 | true | USA | FAC0013 | Bright Metals | 601 Foundry Ave | Atlanta | GA | 30318 | PL015 | Forging Line Z | 2024-03-05 | 8500 | 0.17 | 50000 | 3000 | A. Lewis | High water loss in forging rinse. | Automate rinse process; increase recycling. |
| AUD00016 | surface | 3500 | true | India | FAC0006 | Sahara Extracts | blank | Mumbai | MH | 400001 | PL016 | Extraction Line | 2022-01-15 | 4100 | 0.41 | 10000 | 600 | N. Desai | High discharge due to extraction method. | Review extraction; add recycling step. |
| AUD00017 | recycled | 10 | true | Germany | FAC0014 | Vega Electronics | 17 Innovation Dr | Berlin | BE | 10115 | PL017 | Assembly Line 1 | 2023-04-11 | 120 | 0.06 | 2000 | 110 | T. Müller | Minimal inefficiencies; strong water reuse. | Continue recycling protocol. |
| AUD00018 | municipal | 7000 | false | China | FAC0015 | Shenzhen Circuits | 998 Circuit Way | Shenzhen | GD | 518000 | PL018 | PCB Wash Line | 2022-09-21 | 7500 | 0.75 | 10000 | 500 | L. Zhang | Discharge exceeds permitted TSS levels. | Install discharge filter; urgent review. |
| AUD00019 | municipal | 300 | true | Norway | FAC0016 | Nordic Textiles | 21 Silkegata | Oslo | OS | 0180 | PL019 | Weaving Division | 2020-12-14 | 600 | 0.06 | 10000 | 300 | E. Olsen | Moderate discharge; improvement possible. | Increase recycling in weaving stage. |
| AUD00020 | surface | 1300 | true | Taiwan | FAC0017 | Taiwan Chemicals | 5 Industrial Blvd | Kaohsiung | KH | 800 | PL020 | Mixing Reactor | 2024-02-23 | 1600 | 0.16 | 10000 | 300 | F. Chen | Mixing reactor discharge not recycled. | Add recycling module to mixing process. |
What the 120 rows show
from the 120-row sampleSurface (water source type) stands out: mean water_
- 92%discharge_
compliance_ status = true - 2,660median water_
discharge_ m3 - 4,100median total_
water_ consumed_ m3 - 0.26median water_
consumed_ per_ unit_ output_ m3 - 10,000median production_
output_ units - 817.5median water_
recycled_ m3
Median 2,660, from 0.0 to 29,500.
- string 14
- integer 1
- float 4
- date 1
- boolean 1
Columns
21 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
audit_id | string | Unique identifier for each water usage audit recordunique | AUD00001 |
facility_id | string | Unique identifier for the manufacturing facility | FAC0001 |
facility_name | string | Name of the manufacturing facility | GreenTech Plastics |
facility_address_street | string | Street address of the facilityoptional | 1200 Elmwood Ave |
facility_address_city | string | City where the facility is locatedoptional | Chicago |
facility_address_state | string | State or province of the facilityoptional | IL |
facility_address_postal_code | string | Postal code of the facilityoptional | 60613 |
facility_address_country | string | Country where the facility is locatedoptional | USA |
production_line_id | string | Unique identifier for the production line | PL001 |
production_line_name | string | Name or label of the production line | Injection Molding A |
water_source_type | string | Type of water source used (e.g., municipal, groundwater, recycled)municipal · groundwater · recycled · surface · other | municipal |
audit_conducted_by | string | Name or identifier of the person/team conducting the auditoptional | J. Miller |
identified_inefficiencies | string | Summary of inefficiencies or issues identified during the auditoptional | Line idle this period. |
recommended_actions | string | Recommended actions or investments for water-saving improvementsoptional | Install advanced cooling … |
| Numbers 5 columns | |||
total_water_consumed_m3 | float | Total water consumed by the production line during the audit period (in cubic meters)0 or more | 18500 |
water_consumed_per_unit_output_m3 | float | Water consumed per unit of output (in cubic meters per unit)0 or more · optional | 0.37 |
production_output_units | integer | Total number of units produced during the audit period0 or more | 50000 |
water_recycled_m3 | float | Volume of water recycled or reused during the audit period (in cubic meters)0 or more · optional | 9250 |
water_discharge_m3 | float | Volume of water discharged as waste during the audit period (in cubic meters)0 or more · optional | 9250 |
| Dates and times 1 column | |||
audit_date | date | Date when the water usage audit was conducted | 2024-05-12 |
| True or false 1 column | |||
discharge_compliance_status | boolean | Whether water discharge met regulatory compliance standards (true/false)optional | true |
Use it for
A manufacturing dashboard
The discharge_
compliance_ status rate, water_ discharge_ m3 by water_ source_ type and a breakdown of facility_ address_ country. Excel, Power BI or Tableau. Why do the 16 surface rows have a mean water_
discharge_ m3 of 13,332? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Audits120AUD000019250municipalAUD000026000municipalAUD000187000municipal
A software demo
Believable audits with facility_
id, facility_ name and facility_ address_ street to fill a screen in front of a buyer.
blueprint · manufacturing-water-usage-audit
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 21 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 row represents a unique production line and date
- Includes total water consumed (liters), waste water generated, and % recycled
- Links water usage to specific product batches
- Flags lines exceeding company water efficiency targets
- Records interventions, upgrades, or incidents affecting consumption
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
- manufacturing-water-usage-audit