Municipal Fleet EV Charging Logs

This dataset provides detailed logs of electric vehicle charging sessions for municipal fleets, including vehicle and station identifiers, session timing, energy delivered, costs, and operational notes. It enables cities and transit agencies to analyze EV usage patterns, optimize infrastructure, and support sustainability initiatives through data-driven decision-making.

  • last updated 18 Jan 2026
  • by GoMask
The brief that made it

Fleet operational efficiency analysis

Sample rows

preview · 8 of 75 rows · all 21 columns
log_idstringvehicle_typestringenergy_kwhfloatvehicle_modelstringvehicle_idstringvehicle_makestringvehicle_yearintegercharging_station_idstringstation_location_namestringstation_street_addressstringstation_citystringstation_statestringstation_postal_codestringstation_countrystringsession_start_datetimedatetimesession_end_datetimedatetimeduration_minutesintegercharging_costfloatpayment_methodstringsession_statusstringoperator_notesstring
LOG-0001bus88.5K9VEH-101BYD2019STN-001ADowntown Depot123 Main StSpringfieldIL62701USA2024-06-05T07:15:002024-06-05T09:05:0011022.12accountcompletedblank
LOG-0002van32.8Transit EVVEH-102Ford2021STN-002BNorthside Garage215 Oak AveSpringfieldIL62702USA2024-06-05T07:30:002024-06-05T08:15:00458.22debit_cardcompletedRoutine morning charge
LOG-0003sedan16.5LeafVEH-103Nissan2020STN-003CCity Hall Lot1 Civic PlazaSpringfieldIL62703USA2024-06-05T08:40:002024-06-05T09:20:00404.95credit_cardcompletedblank
LOG-0004truck45.7RT1VEH-104Rivian2022STN-004DPublic Works HQ500 Industrial RdSpringfieldIL62704USA2024-06-05T10:10:002024-06-05T11:00:005011.56accountcompletedSlight delay at start
LOG-0005bus96.3Catalyst E2VEH-105Proterra2018STN-005EEast Transit Center900 Lincoln HwyLincolnNE68501USA2024-06-05T06:00:002024-06-05T08:15:0013524.53accountcompletedblank
LOG-0006van27.4eSprinterVEH-106Mercedes-Benz2021STN-006FWest Service Lot455 Elm StLincolnNE68502USA2024-06-05T09:05:002024-06-05T09:55:00507.39credit_cardcompletedblank
LOG-0007sedan21.9Bolt EVVEH-107Chevrolet2017STN-007GSouth End Lot123 South StLincolnNE68503USA2024-06-05T11:10:002024-06-05T11:55:00456.58cashcompletedblank
LOG-0008truck39.3F-150 LightningVEH-108Ford2023STN-008HFleet Maintenance Yard789 Fleet DrLincolnNE68504USA2024-06-05T12:15:002024-06-05T13:10:005510.03accountcompletedChecked connector before start

What the 75 rows show

from the 75-row sample

Bus (vehicle type) stands out: mean energy_kwh is 84.0, against 25.1 for the rest.

  • 28.4median energy_kwh
  • 2session statuses
  • 4payment methods
  • 11station states
  • 17station cities
  • 18vehicle makes
Mean energy_kwh by vehicle_type75 rows
05010084.0bus17 rows26.1van18 rows19.0sedan15 rows36.9truck15 rows14.6other10 rows
energy_kwh75 rows, in bands of 20
02040223156101060120energy_kwh →

Median 28.4, from 6.7 to 103.2.

vehicle_model75 rows · top 10 of 27 values
  1. Transit EV7
  2. eSprinter6
  3. Catalyst E25
  4. Bolt EV5
  5. F-150 Lightning5
  6. Leaf4
  7. RT14
  8. GEM eL4
  9. K93
  10. W-153
21 columns by typefrom the column list below
  • string 15
  • integer 2
  • float 2
  • datetime 2

Columns

21 columns in three groups
blueprint · 21 columns
columntypedescriptionexample
Text 15 columns
log_idstringUnique identifier for each charging session log entryuniqueLOG-0001
vehicle_idstringUnique identifier for the municipal fleet vehicleVEH-101
vehicle_typestringType or category of the vehicle (e.g., bus, van, sedan)bus · van · sedan · truck · otherbus
vehicle_makestringManufacturer of the vehicleoptionalBYD
vehicle_modelstringModel of the vehicleoptionalK9
charging_station_idstringUnique identifier for the charging stationSTN-001A
station_location_namestringName or description of the charging station locationoptionalDowntown Depot
station_street_addressstringStreet address of the charging stationoptional123 Main St
station_citystringCity where the charging station is locatedoptionalSpringfield
station_statestringState or province of the charging station11 states · optionalIL
station_postal_codestringPostal code of the charging stationoptional62701
station_countrystringCountry where the charging station is locatedoptionalUSA
payment_methodstringPayment method used for the charging sessionaccount · credit_card · debit_card · cash · other · optionalaccount
session_statusstringStatus of the charging session (e.g., completed, interrupted, failed)completed · interrupted · failed · cancelledcompleted
operator_notesstringAdditional notes or comments from the operator regarding the sessionoptionalRoutine morning charge
Numbers 4 columns
vehicle_yearintegerYear the vehicle was manufactured2,000 to 2,100 · optional2019
energy_kwhfloatTotal energy delivered during the charging session (in kWh)0 or more88.5
duration_minutesintegerDuration of the charging session in minutes1 or more110
charging_costfloatTotal cost of the charging session (in local currency)0 or more · optional22.12
Dates and times 2 columns
session_start_datetimedatetimeTimestamp when the charging session started2024-06-05T07:15:00
session_end_datetimedatetimeTimestamp when the charging session ended2024-06-05T09:05:00

Use it for

  • median energy …28.475 rowsmean energy kwh by ve…84.0bus26.1van19.0sedan36.9truck

    A government dashboard

    Energy_kwh by vehicle_type and a breakdown of vehicle_model. Excel, Power BI or Tableau.

  • Why do the 17 bus rows have a mean energy_kwh of 84.0?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable logs with vehicle_id, vehicle_type and vehicle_make to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 21 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset75 rows21 columns
Yours1,000 rows21 columnsstation_location_name: UK only

blueprint · municipal-fleet-ev-charging-logs

Behind this dataset

Same schema. As many rows as you need.

These 75 rows came out of a blueprint — 21 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 charging session for a municipal EV.
  • Include timestamps, duration, energy consumed (kWh), and charging station ID.
  • Associate each session with vehicle type and operating department.
  • Flag sessions occurring during peak and off-peak hours.
  • Log any session interruptions or hardware errors.
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
municipal-fleet-ev-charging-logs

More in Government

Browse all
Also in GovernmentMunicipal IoT Device Health LogsCivic Participation Event AttendancePublic Procurement Transparency LogsAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.