Energy
22 columns
103 rows
8 formats

Distributed Energy Resource (DER) Management

This dataset provides detailed, real-time and static information on distributed energy resources (DERs) such as solar inverters, battery storage systems, EV charging stations, microgrids, and aggregated resources. It enables asset tracking, operational monitoring, and grid integration analytics, supporting energy management, optimization, and regulatory compliance for utilities and DER operators.

last updated 2 Nov 2025
by GoMask

The brief that made it

Real-time DER asset monitoring and control

Sample rows

preview · 8 of 103 rows · all 22 columns

der_idstring	der_typestring	rated_power_kwfloat	location_statestring	asset_namestring	manufacturerstring	modelstring	serial_numberstring	installation_datedate	statusstring	location_street_addressstring	location_citystring	location_postal_codestring	location_countrystring	grid_connection_point_idstring	current_power_output_kwfloat	energy_storage_capacity_kwhfloat	state_of_charge_percentfloat	last_communication_timedatetime	control_modestring	owner_organizationstring	aggregated_group_idstring
DER-00001-A	solar_inverter	4.2	CA	SolarInverter Redwood Ave A1	SunPower	SPV3.6-2022	SPV-3A1-00123	2023-04-15	active	782 Redwood Ave	San Mateo	94403	USA	GCP-USA-CA-001	3.8	blank	blank	2024-06-13T15:18:33	autonomous	Redwood Solar Group	blank
DER-00002-B	solar_inverter	6.5	CO	SolarInverter Oak St B2	Enphase	ENP-M215	ENP-OAK-00234	2022-10-09	active	150 Oak St	Denver	80220	USA	GCP-USA-CO-021	5.9	blank	blank	2024-06-13T13:43:11	remote	Oak Solar Installers	blank
DER-00003-C	solar_inverter	8	TX	SolarInverter Willow Lane C3	LG Electronics	LG-400S2W	LG-WIL-00345	2019-07-21	maintenance	302 Willow Lane	Austin	78752	USA	GCP-USA-TX-015	0	blank	blank	2024-06-12T09:57:22	autonomous	Texas Green Energy	blank
DER-00004-D	solar_inverter	5.5	NM	SolarInverter Pine Dr D4	SolarEdge	SE-5000H	SED-PIN-00456	2017-03-14	inactive	44 Pine Dr	Albuquerque	87111	USA	GCP-USA-NM-007	0	blank	blank	2024-06-03T10:41:05	remote	Southwest Solar LLC	blank
DER-00005-E	solar_inverter	7.2	ON	SolarInverter Maple St E5	Canadian Solar	CS6K-300MS	CS-MAPLE-00567	2021-09-22	active	82 Maple St	Toronto	M4C1N3	Canada	GCP-CAN-ON-014	6.4	blank	blank	2024-06-13T11:32:12	scheduled	Maple Solar Energy	blank
DER-00006-F	solar_inverter	10	VIC	SolarInverter Hawthorn Rd F6	Fronius	FRN-PRIMO-8.2	FRN-HAW-00678	2016-06-30	faulted	59 Hawthorn Rd	Melbourne	3122	Australia	GCP-AUS-VIC-002	0	blank	blank	2024-06-10T20:18:46	autonomous	Melbourne Solar Co	blank
DER-00007-G	solar_inverter	5	WA	SolarInverter Cedar Blvd G7	Q CELLS	QCELLS-Q.PEAK	QC-CED-00789	2024-02-28	active	230 Cedar Blvd	Seattle	98109	USA	GCP-USA-WA-008	4.6	blank	blank	2024-06-13T17:02:44	remote	Cedar Energy Services	blank
DER-00008-H	solar_inverter	3.6	OR	SolarInverter Spruce Dr H8	REC Group	REC-ALPHA-360	REC-SPRU-00890	2022-12-10	active	91 Spruce Dr	Portland	97213	USA	GCP-USA-OR-019	3	blank	blank	2024-06-13T08:41:20	scheduled	Spruce Solar Installers	blank
DER-00009-I	solar_inverter	4	MA	SolarInverter Birch St I9	SunPower	SPV4.0-2023	SPV-BIRCH-00901	2024-05-12	active	17 Birch St	Boston	02116	USA	GCP-USA-MA-010	3.8	blank	blank	2024-06-13T19:14:06	autonomous	Birch Renewables	blank
DER-00010-J	solar_inverter	8.5	AB	SolarInverter Aspen Pl J10	Enphase	ENP-M250	ENP-ASPN-01012	2015-04-27	inactive	3 Aspen Pl	Calgary	T2V1N4	Canada	GCP-CAN-AB-003	0	blank	blank	2024-05-29T16:24:32	remote	Aspen Solar Group	blank
DER-00011-K	battery_storage	13.5	CA	BatteryStorage Industrial Park K1	Tesla	Powerwall 2	TES-PWR2-01123	2021-08-18	active	1101 Industrial Park	Fremont	94538	USA	GCP-USA-CA-018	12.7	13.5	80.1	2024-06-13T14:16:07	remote	Fremont Energy Storage	blank
DER-00012-L	battery_storage	16	IL	BatteryStorage Tech Campus L2	LG Chem	RESU16H	LGCH-RESU-01234	2023-11-30	active	400 Tech Campus Rd	Chicago	60616	USA	GCP-USA-IL-022	14.9	16	67.5	2024-06-13T12:08:43	scheduled	Tech Energy Solutions	blank
DER-00013-M	battery_storage	60	BC	BatteryStorage Innovation Center M3	BYD	B-Box HV	BYD-BBOX-01345	2018-05-11	inactive	55 Innovation Center	Vancouver	V5K1Z5	Canada	GCP-CAN-BC-011	0	60	0	2024-05-20T08:44:18	remote	West Coast Power	blank
DER-00014-N	battery_storage	500	TX	BatteryStorage Central Plant N4	Panasonic	Evolta-500	PAN-EVO-01456	2016-09-04	maintenance	202 Central Plant	Houston	77018	USA	GCP-USA-TX-021	0	500	35.8	2024-06-11T15:07:59	scheduled	Houston Storage Group	blank
DER-00015-O	battery_storage	1000	CA	BatteryStorage East Campus O5	Tesla	Megapack	TES-MEG-01567	2020-03-29	active	160 East Campus Rd	San Jose	95125	USA	GCP-USA-CA-021	950.6	2000	93.2	2024-06-13T18:05:10	scheduled	East Campus Energy	blank
DER-00016-P	battery_storage	750	AZ	BatteryStorage West Industrial P6	Samsung SDI	SDI-ESS500	SAM-SDI-01678	2015-11-18	inactive	88 West Industrial Rd	Phoenix	85034	USA	GCP-USA-AZ-006	0	750	0	2024-05-31T07:29:51	remote	West Industrial Storage	blank
DER-00017-Q	battery_storage	10	ON	BatteryStorage Central Facility Q7	LG Chem	RESU10	LGCH-RESU-01789	2022-06-22	active	41 Central Facility	Ottawa	K1P5G4	Canada	GCP-CAN-ON-019	9.2	10	60.9	2024-06-13T16:14:29	scheduled	Central Facility Power	blank
DER-00018-R	battery_storage	500	NY	BatteryStorage North Campus R8	Tesla	Powerpack	TES-PACK-01890	2024-02-10	active	77 North Campus	New York	10027	USA	GCP-USA-NY-002	482.5	500	84.3	2024-06-13T13:23:51	autonomous	North Campus Energy Storage	blank
DER-00019-S	microgrid	100	GA	Microgrid Community Center S1	Schneider Electric	MG-100	SCH-MG-01912	2019-08-04	active	210 Community Center	Atlanta	30303	USA	GCP-USA-GA-010	92.6	200	56.5	2024-06-13T17:29:44	autonomous	Atlanta Microgrid Group	blank
DER-00020-T	microgrid	150	OH	Microgrid Industrial Park T2	Siemens	MG-150	SIE-MG-02023	2022-05-13	active	800 Industrial Park	Columbus	43215	USA	GCP-USA-OH-013	142.5	500	72.9	2024-06-13T19:34:18	scheduled	Columbus Microgrid LLC	blank

What the 103 rows show

from the 103-row sample

Aggregated_resource (der type) stands out: mean rated_power_kw is 3,821, against 108.9 for the rest.

75.0median rated_power_kw
3control modes
5statuses
7location countries
26manufacturers
9.1median current_power_output_kw

Mean rated_power_kw by der_type103 rows

rated_power_kw103 rows, in bands of 500

Median 75.0, from 3.6 to 5,000.

location_state103 rows · top 10 of 34 values

CA11
TX8
ON6
BE6
WA5
NSW5
CO4
MA4
IL4
FL4

22 columns by typefrom the column list below

string 16
float 4
date 1
datetime 1

Columns

22 columns in three groups

blueprint · 22 columns
column	type	description	example
Text 16 columns
`der_id`	string	Unique identifier for the Distributed Energy Resource (DER) assetunique	DER-00001-A
`der_type`	string	Type of DER asset (e.g., solar_inverter, battery_storage, ev_charger, microgrid, aggregated_resource)5 values	solar_inverter
`asset_name`	string	Human-readable name or label for the DER asset	SolarInverter Oak St B2
`manufacturer`	string	Manufacturer of the DER assetoptional	SunPower
`model`	string	Model number or name of the DER assetoptional	SPV3.6-2022
`serial_number`	string	Serial number of the DER assetunique · optional	SPV-3A1-00123
`status`	string	Operational status of the DER asset (e.g., active, inactive, maintenance, faulted)active · inactive · maintenance · faulted	active
`location_street_address`	string	Street address where the DER asset is installedoptional	782 Redwood Ave
`location_city`	string	City where the DER asset is installedoptional	San Mateo
`location_state`	string	State or province where the DER asset is installedoptional	CA
`location_postal_code`	string	Postal code for the DER asset locationoptional	94403
`location_country`	string	Country where the DER asset is installed7 countries · optional	USA
`grid_connection_point_id`	string	Identifier for the grid connection point associated with the DER assetoptional	GCP-USA-CA-001
`control_mode`	string	Current control mode of the DER asset (e.g., autonomous, remote, scheduled)autonomous · remote · scheduled · optional	autonomous
`owner_organization`	string	Organization or entity that owns the DER assetoptional	Redwood Solar Group
`aggregated_group_id`	string	Identifier for the aggregated resource group if the DER is part of a virtual power plant or aggregationoptional	AGG-GRP-001
Numbers 4 columns
`rated_power_kw`	float	Rated power capacity of the DER asset in kilowatts (kW)0 or more	4.2
`current_power_output_kw`	float	Current real-time power output of the DER asset in kilowatts (kW)0 or more · optional	3.8
`energy_storage_capacity_kwh`	float	Total energy storage capacity in kilowatt-hours (kWh); applicable for battery storage and microgrids0 or more · optional	13.5
`state_of_charge_percent`	float	Current state of charge as a percentage (0-100); applicable for battery storage and EV chargers0 to 100 · optional	80.1
Dates and times 2 columns
`installation_date`	date	Date when the DER asset was installedoptional	2023-04-15
`last_communication_time`	datetime	Timestamp of the last successful communication with the DER assetoptional	2024-06-13T15:18:33

Use it for

An energy dashboard
Rated_power_kw by der_type and a breakdown of location_state. Excel, Power BI or Tableau.
Why do the 12 aggregated_resource rows have a mean rated_power_kw of 3,821?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Ders103
DER-00001-A4.2solar_in…
DER-00002-B6.5solar_in…
DER-00003-C8solar_in…
A software demo
Believable ders with der_type, asset_name and manufacturer to fill a screen in front of a buyer.

This dataset103 rows22 columns

Yours1,000 rows22 columnslocation_street_address: UK only

blueprint · distributed-energy-resource-der-management

Behind this dataset

Same schema. As many rows as you need.

These 103 rows came out of a blueprint — 22 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

DER ID unique per resource
DER type: solar PV, battery storage, EV charger, microgrid, CHP
Installed capacity (kW or MW)
Real-time output (kW) and reactive power (kVAR)
Inverter status and health monitoring
Battery state of charge (SOC) and state of health (SOH)
Islanding detection and anti-islanding protection
Voltage ride-through and frequency ride-through capability

Rows1,000 rows10,000 rows100,000 rows1,000,000 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: distributed-energy-resource-der-management

What should your data show?

No signup. No card.

Sample rows

What the 103 rows show

Columns

Use it for

An energy dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Energy

What should your data show?