City Renewable Adoption Metrics
This dataset provides annual, city-level metrics on renewable energy adoption, including detailed breakdowns of solar, wind, and battery storage implementation. It supports benchmarking, regulatory compliance tracking, and progress monitoring toward municipal climate goals, making it an essential resource for sustainability managers and smart city planners.
Sample rows
preview · 8 of 80 rows · all 19 columns| city_idstring | regulatory_compliance_statusstring | renewable_energy_percentagefloat | municipal_climate_goalstring | city_namestring | state_provincestring | countrystring | populationinteger | yearinteger | total_energy_consumption_mwhfloat | renewable_energy_consumption_mwhfloat | solar_capacity_installed_mwfloat | wind_capacity_installed_mwfloat | battery_storage_capacity_mwhfloat | number_of_solar_installationsinteger | number_of_wind_installationsinteger | number_of_battery_storage_installationsinteger | last_updateddatetime | data_sourcestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| C1-2020 | Compliant | 54 | 60% renewable by 2025 | Greenfield | California | USA | 156000 | 2020 | 930000.5 | 502000.3 | 120.5 | 42 | 15 | 4000 | 12 | 7 | 2020-09-10T15:24:12 | State Energy Report |
| C2-2019 | In Progress | 25.9 | 50% renewable by 2030 | Sunridge | Texas | USA | 89000 | 2019 | 510000 | 132000 | 55 | 28.2 | 9.3 | 1700 | 7 | 5 | 2019-11-18T10:11:05 | City Annual Report |
| C3-2021 | Compliant | 64.8 | 80% renewable by 2035 | Lakehaven | Ontario | Canada | 211000 | 2021 | 1208000.7 | 783000 | 150 | 35 | 23 | 5200 | 10 | 9 | 2021-08-22T09:00:00 | National Database |
| C4-2022 | Compliant | 69 | 100% renewable by 2040 | Windmere | Bavaria | Germany | 138500 | 2022 | 790000 | 545000 | 98 | 54 | 20.5 | 3600 | 15 | 11 | 2022-06-14T17:35:43 | Municipal Dashboard |
| C5-2018 | In Progress | 55 | 60% renewable by 2025 | Solara | Queensland | Australia | 63000 | 2018 | 320000 | 176000 | 40 | 12 | 5 | 800 | 3 | 2 | 2018-05-09T12:05:23 | City Report |
| C6-2021 | In Progress | 46 | 100% renewable by 2030 | Brighton | East Sussex | UK | 225000 | 2021 | 1070000 | 492000 | 69 | 25 | 13 | 4100 | 9 | 7 | 2021-10-28T14:16:05 | Regional Energy Board |
| C7-2020 | Compliant | 47.7 | 50% renewable by 2025 | Sunnybrook | Florida | USA | 147000 | 2020 | 860000 | 410000 | 80 | 0 | 17 | 3200 | 0 | 5 | 2020-12-03T11:42:18 | State Energy Report |
| C8-2022 | In Progress | 57.6 | 80% renewable by 2035 | Riverstone | New South Wales | Australia | 94000 | 2022 | 490000 | 282000 | 51 | 9 | 7.5 | 1800 | 2 | 6 | 2022-07-15T08:47:33 | Municipal Dashboard |
| C9-2017 | Compliant | 58.6 | 100% renewable by 2035 | Nordstadt | Lower Saxony | Germany | 52000 | 2017 | 210000 | 123000 | 18 | 6.5 | 2.5 | 420 | 2 | 1 | 2017-04-21T16:18:02 | City Report |
| C10-2021 | Compliant | 60.5 | 100% renewable by 2030 | Oceanside | California | USA | 175000 | 2021 | 1045000 | 632000 | 123 | 18.5 | 25 | 3900 | 4 | 10 | 2021-05-12T13:55:13 | National Database |
| C11-2019 | In Progress | 34.2 | 40% renewable by 2025 | Eastfield | Illinois | USA | 120000 | 2019 | 650000 | 222000 | 49 | 6 | 6.5 | 2100 | 2 | 3 | 2019-03-31T15:02:58 | State Energy Report |
| C12-2022 | Compliant | 69.4 | 70% renewable by 2030 | Forest City | Ontario | Canada | 102000 | 2022 | 530000 | 368000 | 65 | 16.5 | 7 | 1700 | 6 | 4 | 2022-10-21T11:29:41 | Municipal Dashboard |
| C13-2020 | Compliant | 52.7 | 60% renewable by 2025 | Redwood | Oregon | USA | 87000 | 2020 | 450000 | 237000 | 37.5 | 8 | 4.2 | 1200 | 2 | 3 | 2020-06-08T12:15:00 | City Report |
| C14-2021 | Compliant | 71.3 | 90% renewable by 2030 | Harborview | British Columbia | Canada | 159000 | 2021 | 820000 | 585000 | 97 | 22 | 19 | 3100 | 7 | 8 | 2021-12-19T10:34:27 | Provincial Energy Board |
| C15-2018 | In Progress | 54.1 | 60% renewable by 2025 | Silverlake | Colorado | USA | 69000 | 2018 | 290000 | 157000 | 23 | 11 | 3 | 600 | 2 | 2 | 2018-09-15T13:04:17 | State Energy Report |
| C16-2019 | Compliant | 59 | 70% renewable by 2030 | Eagleport | Alberta | Canada | 51000 | 2019 | 210000 | 124000 | 16 | 5 | 1.5 | 400 | 1 | 1 | 2019-08-05T09:45:32 | Municipal Dashboard |
| C17-2020 | In Progress | 55.3 | 80% renewable by 2035 | Stonehill | Scotland | UK | 98000 | 2020 | 470000 | 260000 | 21 | 34 | 6.8 | 850 | 5 | 3 | 2020-03-27T17:21:06 | National Database |
| C18-2021 | Compliant | 54.6 | 100% renewable by 2035 | Metroville | New York | USA | 312000 | 2021 | 1580000 | 863000 | 172 | 41 | 31 | 6700 | 13 | 15 | 2021-09-02T16:55:44 | City Annual Report |
| C19-2022 | Compliant | 57.1 | 70% renewable by 2030 | Hillcrest | Victoria | Australia | 77000 | 2022 | 420000 | 240000 | 37 | 9 | 6 | 1300 | 2 | 3 | 2022-11-17T15:35:12 | Municipal Dashboard |
| C20-2020 | In Progress | 50.5 | 60% renewable by 2025 | Sunrise City | Arizona | USA | 142000 | 2020 | 820000 | 414000 | 78 | 5 | 12 | 2900 | 2 | 5 | 2020-07-08T14:25:21 | State Energy Report |
What the 80 rows show
from the 80-row sampleCompliant (regulatory compliance status) stands out: mean renewable_
- 52.8median renewable_
energy_ percentage - 158,590median population
- 492,500median total_
energy_ consumption_ mwh - 249,190median renewable_
energy_ consumption_ mwh - 32.0median solar_
capacity_ installed_ mw - 12.8median wind_
capacity_ installed_ mw
Median 52.8, from 24.1 to 96.0.
- string 7
- integer 5
- float 6
- datetime 1
Columns
19 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 7 columns | |||
city_id | string | Unique identifier for the city (could be a standardized code or UUID).unique | C1-2020 |
city_name | string | Official name of the city. | Greenfield |
state_province | string | State or province where the city is located. | California |
country | string | Country where the city is located. | USA |
municipal_climate_goal | string | Stated municipal climate or renewable energy goal (e.g., '100% renewable by 2030').optional | 60% renewable by 2025 |
regulatory_compliance_status | string | Current status of the city's compliance with relevant renewable energy regulations.Compliant · Non-Compliant · In Progress · Unknown · optional | Compliant |
data_source | string | Primary source of the data (e.g., city report, national database).optional | State Energy Report |
| Numbers 11 columns | |||
population | integer | Estimated population of the city.0 or more · optional | 156000 |
year | integer | Calendar year for the recorded metrics.1,990 to 2,100 | 2020 |
total_energy_consumption_mwh | float | Total annual energy consumption in megawatt-hours (MWh) for the city.0 or more | 930000.5 |
renewable_energy_consumption_mwh | float | Total annual renewable energy consumption in MWh for the city.0 or more | 502000.3 |
renewable_energy_percentage | float | Percentage of total energy consumption sourced from renewables (0-100).0 to 100 | 54 |
solar_capacity_installed_mw | float | Total installed solar capacity in megawatts (MW) in the city.0 or more · optional | 120.5 |
wind_capacity_installed_mw | float | Total installed wind capacity in megawatts (MW) in the city.0 or more · optional | 42 |
battery_storage_capacity_mwh | float | Total installed battery storage capacity in megawatt-hours (MWh) in the city.0 or more · optional | 15 |
number_of_solar_installations | integer | Number of solar energy installations in the city.0 or more · optional | 4000 |
number_of_wind_installations | integer | Number of wind energy installations in the city.0 or more · optional | 12 |
number_of_battery_storage_installations | integer | Number of battery storage installations in the city.0 or more · optional | 7 |
| Dates and times 1 column | |||
last_updated | datetime | Timestamp when the record was last updated. | 2020-09-10T15:24:12 |
Use it for
An energy dashboard
Renewable_
energy_ percentage by regulatory_ compliance_ status and a breakdown of municipal_ climate_ goal. Excel, Power BI or Tableau. Why do the 46 Compliant rows have a mean renewable_
energy_ percentage of 58.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Cities80C1-202054CompliantC2-201925.9In Progr…C3-202164.8Compliant
A software demo
Believable cities with city_
name, state_ province and country to fill a screen in front of a buyer.
This dataset80 rows19 columns
Yours1,000 rows19 columnscity_id: UK only
blueprint · city-renewable-adoption-metrics
Behind this dataset
Same schema. As many rows as you need.
These 80 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 one city’s monthly summary.
- Renewable sources tracked: solar, wind, battery storage.
- Include percentage increase from previous month.
- Flag cities below minimum adoption targets.
- Show correlation with carbon reduction progress.
- Include notes on major infrastructure change events.
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
- city-renewable-adoption-metrics