Warehouse Energy Efficiency Audit Log
This dataset provides detailed logs of energy efficiency audits conducted across warehouse zones, including consumption metrics, carbon emissions, ESG compliance status, and actionable recommendations. It enables facilities managers to benchmark performance, identify savings opportunities, and support sustainability reporting for logistics operations.
Sample rows
preview · 8 of 68 rows · all 20 columns| audit_idstring | esg_compliance_statusstring | energy_consumption_kwhfloat | address_countrystring | warehouse_idstring | warehouse_namestring | address_streetstring | address_citystring | address_statestring | address_postal_codestring | zone_idstring | zone_namestring | audit_datedate | baseline_consumption_kwhfloat | energy_savings_kwhfloat | carbon_emissions_kgco2efloat | identified_opportunitiesstring | action_takenstring | auditor_namestring | audit_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AUD-001A | Compliant | 12085.6 | USA | WH-ATL-12 | Atlanta Distribution Center | 1245 Peachtree Industrial Blvd | Atlanta | GA | 30318 | Z-ATL-01 | Cold Storage | 2023-01-15 | 14200 | 2114.4 | 8715.8 | LED lighting retrofit, night shutoff automation | LED lights installed, automation scheduled Q2 | Sarah Lin | Significant improvement over last year |
| AUD-001B | Compliant | 6080 | USA | WH-ATL-12 | Atlanta Distribution Center | 1245 Peachtree Industrial Blvd | Atlanta | GA | 30318 | Z-ATL-02 | Loading Dock | 2023-01-19 | 6200 | 120 | 4498.5 | Dock door insulation, occupancy sensors | Sensors installed, insulation pending | Sarah Lin | Dock doors left open frequently |
| AUD-001C | Compliant | 9500.7 | USA | WH-ATL-12 | Atlanta Distribution Center | 1245 Peachtree Industrial Blvd | Atlanta | GA | 30318 | Z-ATL-03 | Packing Area | 2023-01-22 | 9800 | 299.3 | 6850.8 | Replace aging conveyor motors | Motors ordered | Sarah Lin | Packing line idle time observed |
| AUD-002A | Compliant | 15700 | USA | WH-CHI-03 | Chicago Logistics Hub | 880 W Roosevelt Rd | Chicago | IL | 60608 | Z-CHI-01 | Refrigerated Area | 2023-02-10 | 17000 | 1300 | 11293 | Upgrade chillers, install variable speed drives | VSDs installed Q1, chiller upgrade pending | Carlos Ramirez | Chiller efficiency below expected |
| AUD-002B | Compliant | 6380 | USA | WH-CHI-03 | Chicago Logistics Hub | 880 W Roosevelt Rd | Chicago | IL | 60608 | Z-CHI-02 | Shipping Zone | 2023-02-12 | 6700 | 320 | 4590.1 | Motion sensors for lights | Sensors installed | Carlos Ramirez | Lighting left on overnight |
| AUD-002C | Compliant | 1800.5 | USA | WH-CHI-03 | Chicago Logistics Hub | 880 W Roosevelt Rd | Chicago | IL | 60608 | Z-CHI-03 | Break Room | 2023-02-15 | 1850 | 49.5 | 1295.8 | Smart plugs for appliances | Plugs installed | Carlos Ramirez | Coffee makers left on after hours |
| AUD-003A | Compliant | 19480 | USA | WH-DEN-09 | Denver Fulfillment Center | 9900 E 40th Ave | Denver | CO | 80238 | Z-DEN-01 | Freezer Zone | 2023-03-02 | 20500 | 1020 | 13989.4 | Defrost cycle optimization | Defrost schedule adjusted | Priya Desai | Freezer doors found unsealed |
| AUD-003B | Compliant | 5000 | USA | WH-DEN-09 | Denver Fulfillment Center | 9900 E 40th Ave | Denver | CO | 80238 | Z-DEN-02 | Inbound Dock | 2023-03-05 | 5200 | 200 | 3580.3 | Roll-up doors auto-close | Auto-close feature installed | Priya Desai | Roll-up doors left open at times |
| AUD-003C | Compliant | 7900 | USA | WH-DEN-09 | Denver Fulfillment Center | 9900 E 40th Ave | Denver | CO | 80238 | Z-DEN-03 | Sortation Area | 2023-03-09 | 8200 | 300 | 5673.2 | Conveyor motor replacement | Motors replaced Q2 | Priya Desai | Conveyors running idle |
| AUD-004A | Compliant | 3400 | USA | WH-MIA-22 | Miami East Logistics | 5555 NW 36th St | Miami | FL | 33166 | Z-MIA-01 | Receiving | 2023-04-01 | 3500 | 100 | 2432.3 | High-efficiency dock fans | Fans installed | James Lee | Fans replaced, less noise |
| AUD-004B | Compliant | 7890 | USA | WH-MIA-22 | Miami East Logistics | 5555 NW 36th St | Miami | FL | 33166 | Z-MIA-02 | Storage | 2023-04-06 | 8000 | 110 | 5659.2 | HVAC night setback | Setback scheduled | James Lee | HVAC runs overnight |
| AUD-004C | Compliant | 2200 | USA | WH-MIA-22 | Miami East Logistics | 5555 NW 36th St | Miami | FL | 33166 | Z-MIA-03 | Offices | 2023-04-08 | 2400 | 200 | 1574.8 | Occupancy sensors | Sensors installed | James Lee | Office lights on weekends |
| AUD-005A | Compliant | 14600 | USA | WH-LAX-17 | LA Main Warehouse | 4000 S Alameda St | Los Angeles | CA | 90058 | Z-LAX-01 | Bulk Storage | 2023-05-10 | 15000 | 400 | 10529.1 | Lighting controls upgrade | Controls installed | Kim Nguyen | Lighting upgrade completed |
| AUD-005B | Compliant | 5100 | USA | WH-LAX-17 | LA Main Warehouse | 4000 S Alameda St | Los Angeles | CA | 90058 | Z-LAX-02 | Parcel Zone | 2023-05-15 | 5300 | 200 | 3680.8 | Variable speed fans | Fans installed | Kim Nguyen | Fan noise decreased |
| AUD-005C | Compliant | 4200 | USA | WH-LAX-17 | LA Main Warehouse | 4000 S Alameda St | Los Angeles | CA | 90058 | Z-LAX-03 | Receiving Dock | 2023-05-18 | 4300 | 100 | 3032.4 | Dock door insulation | Insulation installed | Kim Nguyen | Temperature improved |
| AUD-006A | Compliant | 8700 | USA | WH-NYC-05 | New York Metro Center | 2430 2nd Ave | New York | NY | 10035 | Z-NYC-01 | Sorting | 2023-06-01 | 9200 | 500 | 6271.7 | Efficient conveyor belts | Belts replaced | Alexis Jordan | Energy drop after upgrade |
| AUD-006B | Compliant | 3700 | USA | WH-NYC-05 | New York Metro Center | 2430 2nd Ave | New York | NY | 10035 | Z-NYC-02 | Receiving | 2023-06-05 | 3800 | 100 | 2667.6 | Motion sensor lights | Sensors installed | Alexis Jordan | Lights off after hours now |
| AUD-006C | Compliant | 2200 | USA | WH-NYC-05 | New York Metro Center | 2430 2nd Ave | New York | NY | 10035 | Z-NYC-03 | Office | 2023-06-09 | 2300 | 100 | 1574.8 | Power strips for computers | Strips installed | Alexis Jordan | Computers shut down nightly |
| AUD-007A | Compliant | 12000 | USA | WH-HOU-18 | Houston Express Center | 8800 Monroe Blvd | Houston | TX | 77061 | Z-HOU-01 | Dry Storage | 2023-07-02 | 12400 | 400 | 8652 | High-efficiency lighting | Lighting upgraded | Erika Chen | Lighting upgrade reduced energy use |
| AUD-007B | Compliant | 5650 | USA | WH-HOU-18 | Houston Express Center | 8800 Monroe Blvd | Houston | TX | 77061 | Z-HOU-02 | Shipping | 2023-07-07 | 5700 | 50 | 4070.6 | Dock door insulation | Insulation installed | Erika Chen | Temperature more stable |
What the 68 rows show
from the 68-row sample- 2,741median energy_
consumption_ kwh - 2,806median baseline_
consumption_ kwh - 100.0median energy_
savings_ kwh - 1,575median carbon_
emissions_ kgco2e
Median 2,741, from 985.2 to 19,480.
- string 15
- float 4
- date 1
Columns
20 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
audit_id | string | Unique identifier for each energy efficiency audit recordunique | AUD-001A |
warehouse_id | string | Unique identifier for the warehouse where the audit took place | WH-ATL-12 |
warehouse_name | string | Name of the warehouse | Chicago Logistics Hub |
address_street | string | Street address of the warehouse | 880 W Roosevelt Rd |
address_city | string | City where the warehouse is located | Atlanta |
address_state | string | State or province of the warehouse | GA |
address_postal_code | string | Postal or ZIP code of the warehouse | 30318 |
address_country | string | Country where the warehouse is located | USA |
zone_id | string | Unique identifier for the zone within the warehouse | Z-ATL-01 |
zone_name | string | Name or designation of the warehouse zone | Cold Storage |
esg_compliance_status | string | Status of ESG (Environmental, Social, Governance) compliance for the zone at the time of auditCompliant · Non-Compliant · Pending · Not Assessed · optional | Compliant |
identified_opportunities | string | Summary of identified energy savings opportunities or recommended upgradesoptional | Roll-up doors auto-close |
action_taken | string | Description of actions taken or planned based on audit findingsoptional | Motors ordered |
auditor_name | string | Name of the person or team conducting the auditoptional | Sarah Lin |
audit_notes | string | Additional notes or observations from the auditoptional | Conveyors running idle |
| Numbers 4 columns | |||
energy_consumption_kwh | float | Measured energy consumption in kilowatt-hours for the zone during the audit period0 or more | 12085.6 |
baseline_consumption_kwh | float | Historical or baseline energy consumption in kilowatt-hours for comparison0 or more · optional | 14200 |
energy_savings_kwh | float | Calculated energy savings in kilowatt-hours compared to baselineoptional | 2114.4 |
carbon_emissions_kgco2e | float | Estimated carbon emissions in kilograms CO2 equivalent for the zone during the audit period0 or more · optional | 8715.8 |
| Dates and times 1 column | |||
audit_date | date | Date when the energy audit was performed | 2023-01-15 |
Use it for
An energy dashboard
Energy_
consumption_ kwh by esg_ compliance_ status and a breakdown of address_ country. Excel, Power BI or Tableau. What pattern can you find in 68 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 68 rows.
- Audits68AUD-001A12085.6CompliantAUD-001B6080CompliantAUD-001C9500.7Compliant
A software demo
Believable audits with warehouse_
id, warehouse_ name and address_ street to fill a screen in front of a buyer.
blueprint · warehouse-energy-efficiency-audit-log
Behind this dataset
Same schema. As many rows as you need.
These 68 rows came out of a blueprint — 20 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 daily audit by zone with timestamped kWh usage
- Record deviations from baseline consumption flagging anomalies
- Log implemented energy-saving measures and resulting changes
- Include external factors such as weather or occupancy impacting use
- Categorize each entry by warehouse location and operational shift
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- warehouse-energy-efficiency-audit-log