Download the data
Every table on this site is available as a CSV file, built from the DG Stats interconnection file current through Aug 31, 2026 and the CSLB License Master file pulled Nov 4, 2026. Free to reuse under CC BY 4.0 with a link back.
Files
- installers.csv: Every installer with its own page (34 or more interconnected installs), one row each. 2,400 rows.
- installer-licenses.csv: Each CSLB license number looked up for an installer, with the License Master facts when the number is in the file. 2,467 rows.
- installer-counties.csv: Interconnected installs for each installer in each county, all years. 23,966 rows.
- counties.csv: One row per county with installs in the data. 54 rows.
- cities.csv: The 150 cities with the most installs, one row each. 150 rows.
- months.csv: Statewide residential solar installs interconnected in each calendar month. 342 rows.
- report-2026-08.csv: Installs interconnected in 2026-08 by installer, with the prior month for comparison. Frozen 2026-11-04. 706 rows.
- installer-tariffs.csv: For each installer with a page: installs by net metering tariff, battery storage under NEM 2.0 and the Net Billing Tariff, third-party ownership types and how often its exact name appears as third-party owner. 2,400 rows.
- installer-years.csv: Installs and battery-paired installs for each installer with a page, every year from its first record. 29,902 rows.
- area-tariffs.csv: Net metering tariff, battery and ownership type counts for every county and every city with a page, plus the Bay Area region. 205 rows.
- tariff-by-year.csv: Residential solar installs by net metering tariff for each year from 2019. 8 rows.
- third-party-owners.csv: The 200 most common Third Party Name values on third-party-owned residential solar records, matched by exact key only. 200 rows.
- cslb-disciplinary-bonds.csv: Each looked-up license number whose CSLB License Master record (pulled 2026-11-04) lists a disciplinary bond, a pending suspension date or a pending classification removal date, with the installers it was recorded for. 26 rows.
- zips.csv: Every ZIP code with 25 or more residential solar installs (1249 in all), one row each, from the Service Zip recorded on each project through 2026-08-31. 1,249 rows.
- cec-equipment-makers.csv: Every equipment maker page, one row each, joined to the California Energy Commission's PV Module, Grid Support Inverter, Energy Storage System and Battery lists downloaded 2026-11-16. A model string not found is not on the current list as published; that is not a finding about the equipment. 74 rows.
- eia861-california-utilities.csv: Every California utility in EIA's 2025 Form EIA-861 net metering, non-net-metering distributed and service territory files (downloaded 2026-11-16), one row each. Values are as the utility reported them; blank means EIA printed a period or the utility has no row. 61 rows.
- solarapp-california.csv: Every California row of the SolarAPP+ "Where is SolarAPP+ Available?" table read 2026-11-16. The list gives no start dates; first_seen is the date this site first read the row. 293 rows.
Fields
installers.csv
| Field | Description |
|---|---|
slug | Page identifier: the page is /installer/<slug>/ |
name | Display name (the most common spelling, or a combined name for merged spellings) |
installs | Residential solar installs interconnected, all years |
installs_last_24_months | Installs interconnected 2024-09-01 through 2026-08-31 |
installs_2022 | Installs interconnected in 2022 |
installs_2023 | Installs interconnected in 2023 |
installs_2024 | Installs interconnected in 2024 |
installs_2025 | Installs interconnected in 2025 |
installs_2026 | Installs interconnected in 2026 (through 2026-08-31) |
kw_dc | Total system size, kW DC |
median_kw_dc | Median system size, kW DC |
battery_installs | Installs with battery storage |
battery_share_pct | Percent of installs with battery storage, counting SDG&E installs as no battery because SDG&E does not record storage on the solar record; installer-tariffs.csv has the PG&E and SCE based share |
third_party_owned_pct | Percent recorded as third-party owned (lease or PPA), where reported |
first_install | Earliest App Approved date |
latest_install | Latest App Approved date |
counties | Counties with at least one install |
top_county | County with the most installs |
license_number | CSLB license number the utilities recorded most often (blank when none was looked up) |
license_status | CSLB primary status for that number, or "not in License Master file" |
url | Page on this site |
installer-licenses.csv
| Field | Description |
|---|---|
installer_slug | Installer page identifier |
installer | Installer display name |
license_number | CSLB license number as recorded by the utilities |
installs_reported | Installs on which the utilities recorded this number |
in_license_master | "yes" when the number is in the CSLB License Master file pulled 2026-11-04, otherwise "no" |
cslb_business_name | Business name on the CSLB record; "Sole owner license (name not shown)" when CSLB lists the business type Sole Owner |
cslb_status | CSLB primary status |
cslb_secondary_status | CSLB secondary status, if any |
classifications | CSLB classifications, separated by semicolons |
issued | License issue date |
expires | License expiration date |
installer-counties.csv
| Field | Description |
|---|---|
installer_slug | Installer page identifier |
installer | Installer display name |
county | County |
installs | Interconnected installs |
counties.csv
| Field | Description |
|---|---|
county | County |
installs | Residential solar installs interconnected, all years in the data |
installs_last_24_months | Installs interconnected 2024-09-01 through 2026-08-31 |
kw_dc | Total system size, kW DC |
median_kw_dc | Median system size, kW DC |
battery_share_pct | Percent of installs with battery storage, all years. SDG&E solar records never carry storage (SDG&E files batteries as separate projects), so areas served by SDG&E read low; area-tariffs.csv has PG&E and SCE based shares |
battery_share_last_24_months_pct | Percent of installs with battery storage, last 24 months (same SDG&E caveat) |
third_party_owned_pct | Percent of installs recorded as third-party owned (lease or PPA), where reported |
installer_names | Installer names with at least one install, all years |
installer_names_last_24_months | Installer names with at least one install in the last 24 months |
top_installers_last_24_months | The three installers with the most interconnected installs in the last 24 months, with counts |
cities.csv
| Field | Description |
|---|---|
city | Service city as recorded by the utilities |
county | County with most of the city’s installs |
installs | Residential solar installs interconnected, all years in the data |
installs_last_24_months | Installs interconnected 2024-09-01 through 2026-08-31 |
kw_dc | Total system size, kW DC |
median_kw_dc | Median system size, kW DC |
battery_share_pct | Percent of installs with battery storage, all years. SDG&E solar records never carry storage (SDG&E files batteries as separate projects), so areas served by SDG&E read low; area-tariffs.csv has PG&E and SCE based shares |
battery_share_last_24_months_pct | Percent of installs with battery storage, last 24 months (same SDG&E caveat) |
third_party_owned_pct | Percent of installs recorded as third-party owned (lease or PPA), where reported |
installer_names | Installer names with at least one install, all years |
installer_names_last_24_months | Installer names with at least one install in the last 24 months |
top_installers_last_24_months | The three installers with the most interconnected installs in the last 24 months, with counts |
months.csv
| Field | Description |
|---|---|
month | Calendar month of the App Approved date (YYYY-MM) |
installs | Residential solar installs interconnected |
battery_installs | Installs with battery storage |
kw_dc | Total system size, kW DC |
self_or_not_reported | Installs that were self-installed or had no installer recorded |
installer_names | Installer names with at least one install that month |
report-2026-08.csv
| Field | Description |
|---|---|
installer | Installer display name |
installer_slug | Installer page identifier, blank when the installer has no page |
installs_2026-08 | Installs interconnected in 2026-08 |
installs_2026-07 | Installs interconnected in 2026-07 |
installer-tariffs.csv
| Field | Description |
|---|---|
installer_slug | Installer page identifier |
installer | Installer display name |
nem1_installs | Installs whose NEM Tariff field is 1.0 |
nem2_installs | Installs whose NEM Tariff field is 2.0 |
nbt_installs | Installs whose NEM Tariff field is NBT (Net Billing Tariff, often called NEM 3.0) |
tariff_not_recorded | Installs with the NEM Tariff field blank or another value |
nem2_battery_installs | NEM 2.0 installs with battery storage |
nbt_battery_installs | Net Billing Tariff installs with battery storage |
latest_nbt_install | Latest App Approved date of a Net Billing Tariff install |
tpo_ppa | Third-party-owned installs recorded as PPA |
tpo_lease | Third-party-owned installs recorded as Lease |
tpo_prepaid_lease | Third-party-owned installs recorded as Pre-paid Lease |
tpo_other | Third-party-owned installs recorded as Other |
median_storage_kwh | Median storage capacity (kWh) of battery-paired installs that list one |
pge_sce_installs | Installs from PG&E and SCE, the utilities that record storage on the solar record |
pge_sce_battery_installs | Of those, installs with battery storage |
pge_sce_battery_share_pct | Battery share of PG&E and SCE installs, all years |
named_as_owner | Residential systems anywhere in the file whose Third Party Name matches this installer’s key exactly |
installer-years.csv
| Field | Description |
|---|---|
installer_slug | Installer page identifier |
installer | Installer display name |
year | Year of the App Approved date |
installs | Installs interconnected |
battery_installs | Installs with battery storage |
area-tariffs.csv
| Field | Description |
|---|---|
area_type | county, city or region |
area | County name, city key or region key |
installs | Residential solar installs |
nem1_installs | Installs whose NEM Tariff field is 1.0 |
nem2_installs | Installs whose NEM Tariff field is 2.0 |
nbt_installs | Installs whose NEM Tariff field is NBT (Net Billing Tariff, often called NEM 3.0) |
tariff_not_recorded | Installs with the NEM Tariff field blank or another value |
nem2_battery_installs | NEM 2.0 installs with battery storage |
nbt_battery_installs | Net Billing Tariff installs with battery storage |
latest_nbt_install | Latest App Approved date of a Net Billing Tariff install |
tpo_ppa | Third-party-owned installs recorded as PPA |
tpo_lease | Third-party-owned installs recorded as Lease |
tpo_prepaid_lease | Third-party-owned installs recorded as Pre-paid Lease |
tpo_other | Third-party-owned installs recorded as Other |
median_storage_kwh | Median storage capacity (kWh) of battery-paired installs that list one |
pge_sce_installs | Installs from PG&E and SCE, the utilities that record storage on the solar record |
pge_sce_battery_installs | Of those, installs with battery storage |
pge_sce_battery_share_pct | Battery share of PG&E and SCE installs, all years |
tariff-by-year.csv
| Field | Description |
|---|---|
year | Year of the App Approved date |
installs | Residential solar installs |
nem1 | NEM 1.0 installs |
nem2 | NEM 2.0 installs |
nbt | Net Billing Tariff installs |
not_recorded | Tariff blank or other value |
nem2_battery | NEM 2.0 installs with battery storage |
nbt_battery | Net Billing Tariff installs with battery storage |
pge_sce_installs | PG&E and SCE installs |
pge_sce_battery | PG&E and SCE installs with battery storage |
pge_sce_nbt | PG&E and SCE Net Billing Tariff installs |
pge_sce_nem2 | PG&E and SCE NEM 2.0 installs |
tpo_yes | Installs recorded as third-party owned |
tpo_known | Installs with the Third Party Owned field filled in |
third-party-owners.csv
| Field | Description |
|---|---|
owner_key | Matching key (lowercase, punctuation and suffixes removed) |
owner_name | Most common spelling as recorded |
systems | Residential systems listing this owner |
cslb-disciplinary-bonds.csv
| Field | Description |
|---|---|
license_number | CSLB license number |
installers | Installer pages that recorded this number, separated by semicolons |
bond_required | Date CSLB required the disciplinary bond |
bond_effective | Bond effective date |
bond_cancelled | Bond cancellation date, if any |
bond_amount | Bond amount, dollars |
bond_reason | Bond reason as written by CSLB |
case_number | CSLB case number on the bond record |
pending_suspension | Pending suspension date |
pending_class_removal | Pending classification removal date |
zips.csv
| Field | Description |
|---|---|
zip | Five digit ZIP code as recorded; the page is /zip/<zip>/ |
city_recorded | Service City recorded on the most installs in the ZIP |
county_recorded | Service County recorded on the most installs in the ZIP |
installs | Residential solar installs interconnected, all years in the data |
installs_last_24_months | Installs interconnected 2024-09-01 through 2026-08-31 |
kw_dc | Total system size, kW DC |
pge_sce_installs | Installs on PG&E and SCE records, which carry battery storage on the solar record |
pge_sce_with_battery | Of those, installs with battery storage |
battery_share_last_24_months_pct | Percent of PG&E and SCE installs in the last 24 months with battery storage |
nem1 | Installs recorded under NEM 1.0 |
nem2 | Installs recorded under NEM 2.0 |
nbt | Installs recorded under the Net Billing Tariff (NEM 3.0) |
tariff_not_recorded | Installs with no net metering tariff recorded |
nbt_share_pct | Net Billing Tariff installs as a percent of installs with a tariff recorded |
third_party_owned_pct | Percent recorded as third-party owned (lease or PPA), where reported |
first_install | Earliest App Approved date in the ZIP |
latest_install | Latest App Approved date in the ZIP |
cec-equipment-makers.csv
| Field | Description |
|---|---|
maker | Maker as named on this site |
cec_manufacturer_names | CEC manufacturer names joined to the maker (exact name or the alias table), separated by "; " |
module_models | Distinct model numbers on the CEC PV Module List under the joined names (curly-bracket text removed) |
module_nameplate_pmax_min | Lowest Nameplate Pmax (W) on those rows, as published |
module_nameplate_pmax_max | Highest Nameplate Pmax (W) on those rows, as published |
module_ptc_min | Lowest PTC (W) on those rows, as published |
module_ptc_max | Highest PTC (W) on those rows, as published |
inverter_models | Distinct model numbers on the CEC Grid Support Inverter List under the joined names (curly-bracket text removed) |
inverter_weighted_efficiency_min | Lowest Weighted Efficiency (%) on those rows, as published |
inverter_weighted_efficiency_max | Highest Weighted Efficiency (%) on those rows, as published |
ess_models | Distinct model numbers on the CEC Energy Storage System List under the joined names (curly-bracket text removed) |
ess_nameplate_energy_capacity_min | Lowest Nameplate Energy Capacity (kWh) on those rows, as published |
ess_nameplate_energy_capacity_max | Highest Nameplate Energy Capacity (kWh) on those rows, as published |
battery_models | Distinct model numbers on the CEC Battery List under the joined names (curly-bracket text removed) |
battery_nameplate_energy_capacity_min | Lowest Nameplate Energy Capacity (kWh) on those rows, as published |
battery_nameplate_energy_capacity_max | Highest Nameplate Energy Capacity (kWh) on those rows, as published |
module_model_entries | Model entries for this maker in the module role on DG Stats records (one per install per distinct model string) |
module_model_entries_found | Of those, entries whose model string equals a model number on the current CEC list for the same maker |
inverter_model_entries | Model entries for this maker in the inverter role on DG Stats records (one per install per distinct model string) |
inverter_model_entries_found | Of those, entries whose model string equals a model number on the current CEC list for the same maker |
battery_model_entries | Model entries for this maker in the battery role on DG Stats records (one per install per distinct model string) |
battery_model_entries_found | Of those, entries whose model string equals a model number on the current CEC list for the same maker |
url | Maker page on this site |
eia861-california-utilities.csv
| Field | Description |
|---|---|
eia_utility_number | EIA utility number |
utility | Utility name as EIA prints it |
ownership | EIA ownership type |
short_form | Y when EIA marks the utility a short form (Form EIA-861S) filer |
counties | California counties EIA lists for the utility, separated by "; " |
unit | Capacity unit the utility reported for PV (AC or DC) |
pv_count_total | PV net metering installations, all sectors |
pv_count_residential | Residential |
pv_count_commercial | Commercial |
pv_count_industrial | Industrial |
pv_mw_total | PV net metering capacity MW, all sectors |
pv_mw_residential | Residential MW |
battery_pv_paired_count | PV-paired battery installations |
battery_pv_paired_mw | PV-paired battery capacity MW |
non_net_metered_generators | Distributed generators not net metered, number |
non_net_metered_mw | Their total capacity MW |
url | Utility page on this site, when it has one |
solarapp-california.csv
| Field | Description |
|---|---|
jurisdiction | Name as listed |
pv | Y when the table shows a check mark for PV (Photovoltaic) |
pvst | Y when the table shows a check mark for PV+ST (PV with Battery for Energy Storage) |
st | Y when the table shows a check mark for ST (Storage) |
mpu | Y when the table shows a check mark for MPU (Main Panel Upgrade) |
mbd | Y when the table shows a check mark for MBD (Main Breaker Derate) |
details | Details column, as listed |
first_seen | Date this site first read the row |
url | Matched city or county page on this site (exact name) |
Update schedule
The index checks for a new DG Stats file and a new CSLB License Master file every week. DG Stats publishes about six weeks after each month ends. When a month is complete in the data, its monthly report is frozen and does not change after that; the other files are rebuilt from each new pull. These files were built Nov 16, 2026.
License
Free to reuse under CC BY 4.0 with a link back. The underlying records are public records published by the sources below; see the methodology for how they are matched and what is excluded.
Sources
- California Distributed Generation Statistics: Interconnected Project Sites Data Set (PG&E, SCE, SDG&E)
- Contractors State License Board: Master List of California Licensed Contractors
- California Public Utilities Commission: NEM Revisit proceeding R.20-08-020 and Decision D.22-12-056
- California Energy Commission: Solar Equipment Lists (PV Module, Grid Support Inverter, Energy Storage System and Battery lists)
Records last pulled Nov 16, 2026. Every entry links to the original public record.