• Energy
  • 19 columns
  • 50 rows
  • 8 formats

Small Business Energy Benchmarking

This dataset provides granular energy efficiency metrics for local small businesses, including consumption, cost, benchmarking percentiles, and upgrade recommendations. It enables owners, analysts, and policymakers to compare performance, identify savings opportunities, and support ESG reporting in small commercial operations.

  • last updated 5 Dec 2025
  • by GoMask
The brief that made it

Benchmarking energy performance across local SMEs

Sample rows

preview · 8 of 50 rows · all 19 columns
business_idstringindustry_sectorstringannual_energy_consumption_kwhfloatrecommended_upgradesstringbusiness_namestringaddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestringaddress_countrystringbuilding_size_sqftfloatnum_employeesintegerannual_energy_cost_usdfloatenergy_intensity_kwh_per_sqftfloatbenchmark_percentileintegerpeer_groupstringesg_reporting_readybooleanlast_data_updatedatepotential_annual_savings_usdfloat
SB-1001Retail31000LED lighting, window insulationGreen Leaf Market123 Elm StSpringfieldIL62704USA2500123400.512.468Retail-Midwest-2500-5000true2024-04-15450
SB-1002Hospitality21500HVAC upgradeJava Junction45 Maple AveEvanstonIL60201USA18008240011.9454Hospitality-Midwest-1000-3000true2024-03-12290
SB-1003Services29000blankBright Start Daycare88 Oak StAuroraIL60506USA36001531758.0683Services-Midwest-3000-5000true2024-05-08blank
SB-1004Healthcare26500Solar panelsSunshine Dental777 Lincoln BlvdNapervilleIL60540USA22009290012.0545Healthcare-Midwest-2000-3000true2024-04-28550
SB-1005Services24000Smart thermostatsTechFix Solutions1010 Main StDes MoinesIA50309USA32001927007.590Services-Midwest-3000-5000true2024-05-10320
SB-1006Fitness65000Insulation upgradeUrban Fitness22 River RdMadisonWI53703USA600020700010.8371Fitness-Midwest-5000-10000true2024-04-22850
SB-1007Retail42000LED lightingHome Comforts9 Pine StOmahaNE68102USA410013470010.2462Retail-Midwest-3000-5000true2024-05-01390
SB-1008Retail13500blankPetal & Stem56 Spruce AveColumbusOH43215USA1750715757.7189Retail-Midwest-1000-3000true2024-03-29blank

What the 50 rows show

from the 50-row sample

Services (industry sector) stands out: mean annual_energy_consumption_kwh is 20,250, against 31,787 for the rest.

  • 25,000median annual_energy_consumption_kwh
  • 10address states
  • 2,550median building_size_sqft
  • 10median num_employees
  • 2,750median annual_energy_cost_usd
  • 9.8median energy_intensity_kwh_per_sqft
Mean annual_energy_consumption_kwh by industry_sector50 rows
040k80k30,921Retail14 rows20,250Servic…12 rows25,750Health…10 rows25,313Hospit…8 rows52,500Fitness6 rows
annual_energy_consumption_kwh50 rows, in bands of 10k
08161616834310k40k70kannual_energy_consumption_kwh →

Median 25,000, from 11,000 to 65,000.

recommended_upgrades38 rows with a value · 12 left blank
  1. LED lighting9
  2. Insulation upgrade8
  3. Cooler door seals4
  4. HVAC upgrade3
  5. Smart thermostats3
  6. Water heater replacement3
  7. LED lighting, window insulation2
  8. Oven replacement2
  9. Solar panels1
  10. Kitchen appliance upgrade1
19 columns by typefrom the column list below
  • string 10
  • integer 2
  • float 5
  • date 1
  • boolean 1

Columns

19 columns in four groups
blueprint · 19 columns
columntypedescriptionexample
Text 10 columns
business_idstringUnique identifier for each small businessuniqueSB-1001
business_namestringRegistered name of the small businessGreen Leaf Market
industry_sectorstringIndustry sector classification (e.g., retail, hospitality, services)5 sectorsRetail
address_streetstringStreet address of the business location123 Elm St
address_citystringCity where the business is locatedSpringfield
address_statestringState or region of the business location10 statesIL
address_postal_codestringPostal code of the business location62704
address_countrystringCountry of the business locationUSA
peer_groupstringPeer group classification for benchmarking (e.g., similar size, sector, or region)Retail-Midwest-2500-5000
recommended_upgradesstringSummary of recommended energy efficiency upgrades for the business12 upgradeses · optionalHVAC upgrade
Numbers 7 columns
building_size_sqftfloatTotal size of the business premises in square feet1 or more2500
num_employeesintegerNumber of employees working at the business location1 or more12
annual_energy_consumption_kwhfloatTotal annual energy consumption in kilowatt-hours0 or more31000
annual_energy_cost_usdfloatTotal annual energy cost in US dollars0 or more3400.5
energy_intensity_kwh_per_sqftfloatAnnual energy consumption per square foot (kWh/sqft)0 or more12.4
benchmark_percentileintegerPercentile ranking of the business's energy efficiency compared to peers (0-100)0 to 10068
potential_annual_savings_usdfloatEstimated potential annual energy cost savings in US dollars if recommended upgrades are implemented0 or more · optional450
Dates and times 1 column
last_data_updatedateDate when the energy data was last updated2024-04-15
True or false 1 column
esg_reporting_readybooleanIndicates if the business's energy data is suitable for ESG reportingtrue

Use it for

  • median annual …25,00050 rowsmean annual energy co…30.9kReta…20.3kServ…25.8kHeal…25.3kHosp…

    An energy dashboard

    Annual_energy_consumption_kwh by industry_sector and a breakdown of recommended_upgrades. Excel, Power BI or Tableau.

  • Why do the 12 Services rows have a mean annual_energy_consumption_kwh of 20,250?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable businesses with business_name, industry_sector and address_street to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 19 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset50 rows19 columns
Yours1,000 rows19 columnsaddress_street: UK only

blueprint · small-business-energy-benchmarking

Behind this dataset

Same schema. As many rows as you need.

These 50 rows came out of a blueprint — 19 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.

Rules it was built with
  • Each row represents a unique SME with anonymized ID
  • Energy consumption reported in kWh per month
  • Include business sector and premises size
  • Benchmark against local averages and best-in-class
  • Flag sites exceeding efficiency targets
Rows
Open the blueprint in Data Factory

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
small-business-energy-benchmarking

More in Energy

Browse all
Also in EnergyCity Facility Energy BenchmarkingElectricity Demand Forecasting DatasetDynamic Load Modeling for Voltage Stability AnalysisAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.