Fleet EV Adoption Readiness Dataset
This dataset provides a comprehensive view of transportation fleet readiness for electric vehicle (EV) adoption, including detailed asset profiles, operational metrics, route suitability, charging infrastructure, and cost/emissions analytics. It enables sustainability officers and fleet managers to identify transition challenges and opportunities, optimize fleet electrification strategies, and track progress toward decarbonization goals.
Sample rows
preview · 8 of 45 rows · all 23 columns| fleet_idstring | charging_station_typestring | charging_station_countinteger | charging_infrastructure_availableboolean | ev_replacement_modelstring | fleet_namestring | organizationstring | asset_idstring | vehicle_typestring | current_fuel_typestring | model_yearinteger | asset_statusstring | average_daily_mileagefloat | route_idstring | route_descriptionstring | route_suitability_for_evstring | annual_fuel_costfloat | annual_maintenance_costfloat | annual_co2_emissions_kgfloat | ev_replacement_costfloat | ev_transition_challengestring | ev_transition_opportunitystring | last_updateddatetime |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FLEET001 | Level 2 | 2 | true | Ford E-Transit | Metro Delivery | Urban Logistics Inc. | ASSET1001 | van | diesel | 2016 | active | 53.5 | ROUTE_A01 | city delivery | marginal | 3900 | 1050 | 4200 | 45500 | range | emissions reduction | 2024-04-24T15:32:44 |
| FLEET001 | None | 0 | false | blank | Metro Delivery | Urban Logistics Inc. | ASSET1002 | truck | diesel | 2019 | active | 68 | ROUTE_A03 | intercity | unsuitable | 6100 | 1300 | 7800 | blank | range | blank | 2024-03-11T18:44:28 |
| FLEET001 | Level 2 | 3 | true | Nissan e-NV200 | Metro Delivery | Urban Logistics Inc. | ASSET1003 | van | hybrid | 2021 | active | 35.2 | ROUTE_A02 | city delivery | suitable | 1800 | 900 | 2100 | 37000 | none | cost savings | 2024-05-02T12:10:16 |
| FLEET002 | DC Fast | 1 | true | Volvo FL Electric | Green Haulage | EcoFreight Solutions | ASSET2001 | truck | gasoline | 2015 | maintenance | 0 | ROUTE_B01 | intercity | marginal | 5200 | 1400 | 8200 | 82000 | payload | emissions reduction | 2024-05-03T09:12:44 |
| FLEET002 | Level 2 | 2 | true | N/A | Green Haulage | EcoFreight Solutions | ASSET2002 | sedan | electric | 2022 | active | 24.9 | ROUTE_B02 | city delivery | suitable | 520 | 550 | 0 | 0 | none | incentives | 2024-04-22T16:57:09 |
| FLEET002 | None | 0 | false | blank | Green Haulage | EcoFreight Solutions | ASSET2003 | bus | diesel | 2013 | retired | 0 | ROUTE_B03 | rural | unsuitable | 0 | 0 | 0 | blank | infrastructure | blank | 2024-02-15T10:31:55 |
| FLEET003 | DC Fast | 2 | true | BYD K9 | Suburban Shuttle | Regional Transport Ltd. | ASSET3001 | bus | hybrid | 2018 | active | 65.4 | ROUTE_C01 | suburban | suitable | 4100 | 2100 | 4300 | 67000 | none | emissions reduction | 2024-05-06T08:18:02 |
| FLEET003 | Level 1 | 1 | true | BYD K9 | Suburban Shuttle | Regional Transport Ltd. | ASSET3002 | bus | diesel | 2011 | maintenance | 0 | ROUTE_C01 | suburban | marginal | 6300 | 2400 | 8300 | 68000 | cost | cost savings | 2024-05-01T12:21:04 |
| FLEET003 | None | 0 | false | Nissan e-NV200 | Suburban Shuttle | Regional Transport Ltd. | ASSET3003 | van | gasoline | 2017 | active | 41.8 | ROUTE_C02 | suburban | marginal | 2300 | 1100 | 3600 | 35000 | infrastructure | incentives | 2024-04-27T07:15:32 |
| FLEET004 | None | 0 | false | blank | Rural Express | North Valley Holdings | ASSET4001 | truck | diesel | 2010 | active | 77.6 | ROUTE_D01 | rural | unsuitable | 9000 | 2200 | 10200 | blank | range | blank | 2024-01-19T13:01:58 |
| FLEET004 | None | 0 | false | blank | Rural Express | North Valley Holdings | ASSET4002 | truck | diesel | 2009 | retired | 0 | ROUTE_D02 | rural | unsuitable | 0 | 0 | 0 | blank | range | blank | 2024-03-02T16:56:18 |
| FLEET004 | None | 0 | false | Nissan e-NV200 | Rural Express | North Valley Holdings | ASSET4003 | van | gasoline | 2014 | active | 46.2 | ROUTE_D03 | rural | marginal | 2750 | 1200 | 4100 | 36000 | range | emissions reduction | 2024-04-14T14:32:42 |
| FLEET005 | Level 2 | 4 | true | Tesla Model 3 | Corporate Mobility | Business Transport Corp. | ASSET5001 | sedan | hybrid | 2020 | active | 32 | ROUTE_E01 | city delivery | suitable | 950 | 650 | 1200 | 42000 | none | cost savings | 2024-05-05T11:45:33 |
| FLEET005 | Level 1 | 1 | true | Chevy Bolt | Corporate Mobility | Business Transport Corp. | ASSET5002 | sedan | gasoline | 2015 | active | 29.3 | ROUTE_E01 | city delivery | marginal | 1400 | 800 | 1800 | 38000 | payload | incentives | 2024-04-29T09:34:21 |
| FLEET005 | DC Fast | 2 | true | N/A | Corporate Mobility | Business Transport Corp. | ASSET5003 | sedan | electric | 2023 | active | 31.6 | ROUTE_E02 | city delivery | suitable | 400 | 450 | 0 | 0 | none | emissions reduction | 2024-05-07T10:15:20 |
| FLEET006 | None | 0 | false | blank | Municipal Transit | City Services Authority | ASSET6001 | bus | diesel | 2008 | retired | 0 | ROUTE_F01 | urban | unsuitable | 0 | 0 | 0 | blank | payload | blank | 2024-03-18T14:28:09 |
| FLEET006 | DC Fast | 3 | true | BYD K9 | Municipal Transit | City Services Authority | ASSET6002 | bus | hybrid | 2019 | active | 59.1 | ROUTE_F02 | urban | suitable | 3200 | 1800 | 3300 | 69000 | none | emissions reduction | 2024-05-08T13:19:31 |
| FLEET006 | Level 2 | 2 | true | Ford E-Transit | Municipal Transit | City Services Authority | ASSET6003 | van | gasoline | 2018 | active | 38 | ROUTE_F03 | urban | marginal | 2100 | 800 | 2500 | 42000 | cost | cost savings | 2024-04-28T10:38:07 |
| FLEET007 | DC Fast | 2 | true | N/A | Clean Ride | Green Cities Mobility | ASSET7001 | sedan | electric | 2022 | active | 27.7 | ROUTE_G01 | city delivery | suitable | 380 | 430 | 0 | 0 | none | incentives | 2024-04-30T17:29:13 |
| FLEET007 | Level 1 | 1 | true | Chevy Bolt | Clean Ride | Green Cities Mobility | ASSET7002 | sedan | gasoline | 2017 | maintenance | 0 | ROUTE_G02 | city delivery | marginal | 1100 | 700 | 1600 | 37000 | infrastructure | cost savings | 2024-04-25T11:23:46 |
What the 45 rows show
from the 45-row sampleNone (charging station type) stands out: mean charging_
- 64%charging_
infrastructure_ available = true - 1median charging_
station_ count - 3asset statuses
- 3route suitability for evs
- 3ev transition opportunities
- 4vehicle types
Every row with charging_
- string 14
- integer 2
- float 5
- datetime 1
- boolean 1
Columns
23 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
fleet_id | string | Unique identifier for the transportation fleetunique | FLEET001 |
fleet_name | string | Name or designation of the fleet | Metro Delivery |
organization | string | Name of the organization or company operating the fleet | Urban Logistics Inc. |
asset_id | string | Unique identifier for the individual vehicle or assetunique | ASSET1001 |
vehicle_type | string | Type of vehicle (e.g., van, truck, sedan, bus)4 types | van |
current_fuel_type | string | Current fuel type used by the vehicle (e.g., diesel, gasoline, hybrid, electric)diesel · gasoline · hybrid · electric · other | diesel |
asset_status | string | Operational status of the vehicle (e.g., active, retired, maintenance)active · retired · maintenance | active |
route_id | string | Unique identifier for the route assigned to the vehicleoptional | ROUTE_A01 |
route_description | string | Brief description of the route (e.g., city delivery, intercity, rural)7 descriptions · optional | city delivery |
route_suitability_for_ev | string | Assessment of route suitability for EV adoption (e.g., suitable, marginal, unsuitable)suitable · marginal · unsuitable · optional | marginal |
charging_station_type | string | Type of available charging station (e.g., Level 1, Level 2, DC Fast, None)Level 1 · Level 2 · DC Fast · None · optional | Level 2 |
ev_replacement_model | string | Recommended EV model for replacement (if applicable)11 models · optional | Ford E-Transit |
ev_transition_challenge | string | Key challenge for EV transition (e.g., range, payload, infrastructure, cost, none)6 values · optional | range |
ev_transition_opportunity | string | Key opportunity for EV transition (e.g., cost savings, emissions reduction, incentives)3 opportunities · optional | emissions reduction |
| Numbers 7 columns | |||
model_year | integer | Model year of the vehicle1,980 to 2,100 | 2016 |
average_daily_mileage | float | Average number of miles the vehicle travels per day0 or more | 53.5 |
charging_station_count | integer | Number of charging stations available at the asset's primary location0 or more · optional | 2 |
annual_fuel_cost | float | Annual fuel cost for the asset in local currency0 or more · optional | 3900 |
annual_maintenance_cost | float | Annual maintenance cost for the asset in local currency0 or more · optional | 1050 |
annual_co2_emissions_kg | float | Estimated annual CO2 emissions for the asset in kilograms0 or more · optional | 4200 |
ev_replacement_cost | float | Estimated cost to replace the asset with an EV model0 or more · optional | 45500 |
| Dates and times 1 column | |||
last_updated | datetime | Timestamp of the last update to this record | 2024-04-24T15:32:44 |
| True or false 1 column | |||
charging_infrastructure_available | boolean | Indicates if EV charging infrastructure is available for this asset's location/route | true |
Use it for
A transportation dashboard
The charging_
infrastructure_ available rate, charging_ station_ count by charging_ station_ type and a breakdown of ev_ replacement_ model. Excel, Power BI or Tableau. Why do the 16 None rows have a mean charging_
station_ count 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.
- Fleets45FLEET0012Level 2FLEET0010NoneFLEET0013Level 2
A software demo
Believable fleets with fleet_
name, organization and asset_ id to fill a screen in front of a buyer.
blueprint · fleet-ev-adoption-readiness-dataset
Behind this dataset
Same schema. As many rows as you need.
These 45 rows came out of a blueprint — 23 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.
- Each row represents one fleet vehicle evaluated for EV transition
- Include columns for vehicle type, average daily route distance, current fuel type, age, scheduled replacement year, and maintenance cost
- Charging infrastructure availability must be mapped per depot/location
- Include 'emissions reduction estimate' calculated for feasible replacements
- Flag vehicles/routes requiring infrastructure upgrade before conversion
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
- fleet-ev-adoption-readiness-dataset