Government
17 columns
38 rows
8 formats

Municipal Fleet Electrification Progress

This dataset provides detailed tracking of municipal vehicle fleet electrification progress across government departments, including vehicle specifications, transition status, bottlenecks, investment priorities, and sustainability metrics. It enables effective monitoring, benchmarking, and strategic planning for municipal decarbonization initiatives and supports data-driven decision-making for sustainability officers and civic technology teams.

last updated 2 Dec 2025
by GoMask

The brief that made it

Monitoring and reporting municipal fleet electrification progress

Sample rows

preview · 8 of 38 rows · all 17 columns

vehicle_idstring	transition_statusstring	co2_emissions_annualfloat	is_electricboolean	department_idstring	department_namestring	vehicle_typestring	vehicle_makestring	vehicle_modelstring	vehicle_yearinteger	license_platestring	transition_start_datedate	transition_completion_datedate	transition_bottleneck_reasonstring	investment_prioritystring	annual_mileagefloat	last_updateddatetime
V1001	not_started	6390.1	false	DP01	Public Works	truck	Ford	F-150	2018	PW-1847	blank	blank	blank	high	21000.4	2024-06-13T10:48:32
V1002	scheduled	4730.9	false	DP02	Parks & Recreation	van	Chevrolet	Express	2015	PR-6924	2024-07-15	blank	blank	medium	15012.7	2024-06-13T09:36:11
V1003	delayed	8274.6	false	DP03	Sanitation	truck	Mack	Granite	2020	SN-3812	2024-03-18	blank	Charging infrastructure unavailable	high	18500.2	2024-06-12T17:02:19
V1004	in_progress	6820.8	false	DP04	Police	SUV	Dodge	Durango	2019	PL-7741	2024-05-02	blank	blank	medium	23600	2024-06-13T12:24:36
V1005	not_started	4558.2	false	DP05	Fire Department	truck	Pierce	Enforcer	2017	FD-1048	blank	blank	blank	high	8100.5	2024-06-13T09:01:45
V1006	completed	0	true	DP06	Water Services	van	Nissan	NV200	2016	WS-2350	2023-11-01	2024-02-14	blank	blank	13400.8	2024-06-10T15:32:21
V1007	completed	0	true	DP02	Parks & Recreation	sedan	Toyota	Camry	2021	PR-8894	2023-09-04	2023-12-20	blank	blank	9900.5	2024-06-13T07:28:08
V1008	scheduled	5210.6	false	DP01	Public Works	SUV	Chevrolet	Tahoe	2014	PW-1423	2024-08-01	blank	blank	medium	16700.3	2024-06-13T11:05:22
V1009	delayed	7362.3	false	DP03	Sanitation	truck	Freightliner	M2 106	2022	SN-1985	2024-04-22	blank	Vehicle awaiting grant funding	high	15300	2024-06-11T13:48:41
V1010	in_progress	12090.2	false	DP07	Transportation	bus	New Flyer	Xcelsior	2018	TP-3560	2024-06-01	blank	blank	high	27800	2024-06-13T06:41:32
V1011	not_started	5087	false	DP04	Police	sedan	Ford	Interceptor	2019	PL-4131	blank	blank	blank	medium	16800.3	2024-06-13T13:10:57
V1012	delayed	9632.6	false	DP08	Waste Management	truck	Peterbilt	520	2017	WM-7628	2024-02-21	blank	Parts on backorder	high	19950.5	2024-06-13T12:54:21
V1013	completed	0	true	DP09	Fleet Services	sedan	Tesla	Model 3	2023	FS-9084	2024-01-12	2024-03-31	blank	blank	12400	2024-06-11T17:50:13
V1014	in_progress	4142.8	false	DP06	Water Services	van	Ram	ProMaster	2016	WS-7842	2024-05-18	blank	blank	medium	11300.9	2024-06-13T08:18:14
V1015	scheduled	2891	false	DP10	Building & Permits	SUV	Hyundai	Tucson	2015	BP-5501	2024-09-10	blank	blank	low	9300.7	2024-06-13T14:20:50
V1016	scheduled	2788.9	false	DP11	Animal Services	van	Ford	Transit	2022	AS-8039	2024-10-02	blank	blank	medium	7800.3	2024-06-13T08:50:36
V1017	delayed	14600.7	false	DP07	Transportation	bus	Gillig	Low Floor	2019	TP-6712	2024-01-26	blank	Staff training incomplete	high	32100	2024-06-13T07:59:44
V1018	completed	0	true	DP08	Waste Management	truck	Mack	LR	2020	WM-6513	2023-06-14	2023-10-02	blank	blank	15600.5	2024-06-13T13:33:57
V1019	not_started	3202.5	false	DP09	Fleet Services	sedan	Honda	Accord	2016	FS-4327	blank	blank	blank	high	8900.2	2024-06-13T15:45:02
V1020	completed	0	true	DP10	Building & Permits	SUV	Chevrolet	Equinox	2021	BP-9704	2023-11-23	2024-03-07	blank	blank	9200.1	2024-06-13T08:03:16

What the 38 rows show

from the 38-row sample

Completed (transition status) stands out: mean co2_emissions_annual is 0.0, against 5,099 for the rest.

32%is_electric = true
2,840median co2_emissions_annual
3investment priorities
7vehicle types
11department names
12,900median annual_mileage

Mean co2_emissions_annual by transition_status38 rows

co2_emissions_annual38 rows, in bands of 2,000

Median 2,840, from 0.0 to 14,601.

department_id38 rows · top 10 of 11 values

DP014
DP024
DP034
DP044
DP064
DP074
DP053
DP083
DP093
DP103

17 columns by typefrom the column list below

string 10
integer 1
float 2
date 2
datetime 1
boolean 1

Columns

17 columns in four groups

blueprint · 17 columns
column	type	description	example
Text 10 columns
`vehicle_id`	string	Unique identifier for each vehicle in the municipal fleetunique	V1001
`department_id`	string	Unique identifier for the municipal department responsible for the vehicle11 departments	DP01
`department_name`	string	Name of the municipal department11 names	Public Works
`vehicle_type`	string	Type or class of vehicle (e.g., sedan, truck, bus, van)7 values	truck
`vehicle_make`	string	Manufacturer of the vehicle	Ford
`vehicle_model`	string	Model name or number of the vehicle	F-150
`license_plate`	string	Official license plate number of the vehicleunique	PW-1847
`transition_status`	string	Current electrification status of the vehiclenot_started · in_progress · completed · scheduled · delayed	not_started
`transition_bottleneck_reason`	string	Reason for any delay or bottleneck in the electrification processoptional	Parts on backorder
`investment_priority`	string	Priority level for investment in electrification for this vehiclehigh · medium · low · optional	high
Numbers 3 columns
`vehicle_year`	integer	Year the vehicle was manufactured1,990 to 2,100	2018
`annual_mileage`	float	Estimated annual mileage for the vehicle0 or more · optional	21000.4
`co2_emissions_annual`	float	Estimated annual CO2 emissions (kg) for the vehicle0 or more · optional	6390.1
Dates and times 3 columns
`transition_start_date`	date	Date when electrification process started for the vehicleoptional	2024-07-15
`transition_completion_date`	date	Date when electrification was completed for the vehicleoptional	2024-02-14
`last_updated`	datetime	Timestamp of the last update to the vehicle record	2024-06-13T10:48:32
True or false 1 column
`is_electric`	boolean	Indicates if the vehicle is fully electric	false

Use it for

A government dashboard
The is_electric rate, co2_emissions_annual by transition_status and a breakdown of department_id. Excel, Power BI or Tableau.
Why do the 12 completed rows have a mean co2_emissions_annual of 0.0?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Vehicles38
V10016390.1not_star…
V10060completed
V10070completed
A software demo
Believable vehicles with department_id, department_name and vehicle_type to fill a screen in front of a buyer.

This dataset38 rows17 columns

Yours1,000 rows17 columns

blueprint · municipal-fleet-electrification-progress

Behind this dataset

Same schema. As many rows as you need.

These 38 rows came out of a blueprint — 17 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 government fleet department
For each fleet: include total vehicles, number electrified, % electrified
Document annual CO2 reduction estimates per department
Include key infrastructure readiness scores (charging stations/maintenance)
List latest challenges or delays in electrification process

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: municipal-fleet-electrification-progress

What should your data show?

No signup. No card.

Sample rows

What the 38 rows show

Columns

Use it for

A government dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Government

What should your data show?