• Energy
  • 18 columns
  • 140 rows
  • 8 formats

Commercial & Industrial (C&I) Demand Profiles

This dataset provides granular 15-minute interval load profiles for commercial and industrial customers, including active demand (kW), reactive power (kVAR), power factor, and total harmonic distortion (THD) measurements. It enables detailed analysis of energy consumption patterns, power quality, and operational efficiency across diverse sectors, supporting grid management, energy optimization, and benchmarking.

  • opened 7 times
  • last updated 2 Nov 2025
  • by GoMask
The brief that made it

Grid load forecasting and demand response planning

Sample rows

preview · 8 of 140 rows · all 18 columns
profile_idstringcustomer_typestringthd_percentfloatdata_quality_flagbooleanindustry_sectorstringcustomer_idstringcustomer_namestringsite_address_streetstringsite_address_citystringsite_address_statestringsite_address_postal_codestringsite_address_countrystringmeter_idstringinterval_startdatetimeinterval_enddatetimedemand_kwfloatreactive_power_kvarfloatpower_factorfloat
DP-00001Industrial2.4trueManufacturingCUST-101Westfield Manufacturing232 Industrial AveHoustonTX77043USAMTR-7012024-06-01T08:00:002024-06-01T08:15:00715.6231.20.85
DP-00002Commercial1.7trueRetailCUST-103Central Mall500 Center StDallasTX75201USAMTR-7022024-06-01T08:00:002024-06-01T08:15:00254.862.30.93
DP-00003Industrial3.1trueManufacturingCUST-102Green Valley Plastics12 Polymer RdTulsaOK74146USAMTR-7032024-06-01T08:00:002024-06-01T08:15:00433.4122.80.78
DP-00004Commercial2trueRetailCUST-105Sunshine Supermarket180 Market DrSan AntonioTX78207USAMTR-7042024-06-01T08:00:002024-06-01T08:15:00162.345.70.95
DP-00005Commercial2.9trueHospitalityCUST-106Starlight Hotel90 Sunset BlvdAustinTX78701USAMTR-7052024-06-01T08:00:002024-06-01T08:15:00109.736.10.89
DP-00006Industrial4.7trueManufacturingCUST-107Pinecrest Foundry420 Metal DrBirminghamAL35203USAMTR-7062024-06-01T08:00:002024-06-01T08:15:00882.1268.50.82
DP-00007Commercial1.2trueHealthcareCUST-108Metro Medical Center330 Health DrOklahoma CityOK73104USAMTR-7072024-06-01T08:00:002024-06-01T08:15:00201.558.90.91
DP-00008Industrial2.1trueTechnologyCUST-109Elite Data Centers255 Server WayRichardsonTX75080USAMTR-7082024-06-01T08:00:002024-06-01T08:15:00610.2146.50.87

What the 140 rows show

from the 140-row sample

Commercial (customer type) stands out: mean thd_percent is 2.4, against 6.0 for the rest.

  • 88%data_quality_flag = true
  • 3.3median thd_percent
  • 18site address states
  • 134.6median demand_kw
  • 41.5median reactive_power_kvar
  • 0.89median power_factor
Mean thd_percent by customer_type140 rows
0482.4Commercial75 rows6.0Industrial65 rows
thd_percent140 rows, in bands of 2
03060295526195330814thd_percent →

Median 3.3, from 1.0 to 13.6.

industry_sector140 rows · top 10 of 22 values
  1. Manufacturing21
  2. Retail21
  3. Hospitality15
  4. Healthcare15
  5. Office11
  6. Technology9
  7. Paper5
  8. Residential4
  9. Textile4
  10. Utilities4
18 columns by typefrom the column list below
  • string 11
  • float 4
  • datetime 2
  • boolean 1

Columns

18 columns in four groups
blueprint · 18 columns
columntypedescriptionexample
Text 11 columns
profile_idstringUnique identifier for each demand profile recorduniqueDP-00001
customer_idstringUnique identifier for the commercial or industrial customerCUST-101
customer_namestringName of the commercial or industrial customeroptionalWestfield Manufacturing
customer_typestringType of customer: Commercial or IndustrialCommercial · IndustrialIndustrial
industry_sectorstringIndustry sector classification for the customer (e.g., Manufacturing, Retail, Hospitality)optionalManufacturing
site_address_streetstringStreet address of the customer siteoptional232 Industrial Ave
site_address_citystringCity of the customer siteoptionalHouston
site_address_statestringState or province of the customer siteoptionalTX
site_address_postal_codestringPostal code of the customer siteoptional77043
site_address_countrystringCountry of the customer siteoptionalUSA
meter_idstringUnique identifier for the meter recording the demand profileMTR-701
Numbers 4 columns
demand_kwfloatMeasured demand in kilowatts (kW) for the interval0 or more715.6
reactive_power_kvarfloatMeasured reactive power in kilovolt-amperes reactive (kVAR) for the interval231.2
power_factorfloatMeasured power factor for the interval (typically between 0 and 1)0 to 10.85
thd_percentfloatMeasured total harmonic distortion (THD) as a percentage for the interval0 to 1002.4
Dates and times 2 columns
interval_startdatetimeStart timestamp of the 15-minute interval2024-06-01T08:00:00
interval_enddatetimeEnd timestamp of the 15-minute interval2024-06-01T08:15:00
True or false 1 column
data_quality_flagbooleanIndicates if the interval data passed quality checks (true = valid, false = suspect)optionaltrue

Use it for

  • data quality f…88%123 of 140 rowsmean thd percent by c…2.4Commer…6.0Indust…

    An energy dashboard

    The data_quality_flag rate, thd_percent by customer_type and a breakdown of industry_sector. Excel, Power BI or Tableau.

  • Why do the 75 Commercial rows have a mean thd_percent of 2.4?

    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 profiles with customer_id, customer_name and customer_type to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset140 rows18 columns
Yours10,000 rows18 columnssite_address_street: UK only

blueprint · commercial-industrial-ci-demand-profiles

Behind this dataset

Same schema. As many rows as you need.

These 140 rows came out of a blueprint — 18 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
  • Account number for C&I customer with rate class
  • 15-minute kW demand and kVAR reactive power
  • Power factor calculated as cos(θ) from kW and kVA
  • Peak demand reset dates (monthly or billing cycle)
  • Voltage and current THD percentages for power quality
  • Load factor = average demand / peak demand
  • Demand charges triggered when exceeding contracted demand
  • Time-of-use periods aligned with tariff schedules
Rows
Open the blueprint in Data Factory

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
commercial-industrial-ci-demand-profiles

More in Energy

Browse all
Also in EnergyElectric Vehicle (EV) Charging Load ProfilesSmart Grid Fault Detection DatasetEnergy Market Price ForecastingAll 1,947 datasets

What should your data show?

Preview 20 rows free
No signup. No card.