Urban EV Charging Station Logs
This dataset provides granular logs of electric vehicle charging sessions across urban stations, including session timing, energy delivered, user types, and payment details. It enables analysis of charging patterns, infrastructure utilization, and user segmentation for effective urban mobility planning and energy management.
Sample rows
preview · 8 of 200 rows · all 20 columns| session_idstring | vehicle_typestring | energy_delivered_kwhfloat | is_successfulboolean | station_statestring | station_idstring | station_namestring | station_street_addressstring | station_citystring | station_postal_codestring | station_countrystring | connector_typestring | user_idstring | user_typestring | session_start_timedatetime | session_end_timedatetime | session_duration_minutesfloat | payment_methodstring | session_costfloat | error_codestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EVS00001 | car | 22.3 | true | CA | STN0021 | GreenLeaf Charging Plaza | 101 Oak Ave | San Francisco | 94102 | USA | CCS | USR000177 | resident | 2024-04-12T08:40:00 | 2024-04-12T09:10:00 | 30 | app | 8.45 | blank |
| EVS00002 | car | 18.1 | true | CA | STN0013 | Bayview Charge Center | 201 Maple St | Oakland | 94607 | USA | Type2 | USR000011 | visitor | 2024-04-13T13:15:00 | 2024-04-13T13:45:00 | 30 | credit_card | 7.9 | blank |
| EVS00003 | bus | 55.2 | true | CA | STN0009 | Mission EV Hub | 325 Mission St | San Jose | 95112 | USA | CHAdeMO | blank | visitor | 2024-04-14T10:00:00 | 2024-04-14T11:20:00 | 80 | free | 0 | blank |
| EVS00004 | truck | 36.7 | true | CA | STN0027 | Downtown EV Station | 400 Pine St | Berkeley | 94704 | USA | CCS | USR000089 | commercial | 2024-04-15T17:05:00 | 2024-04-15T17:50:00 | 45 | subscription | 10.25 | blank |
| EVS00005 | car | 15.6 | true | CA | STN0018 | Union Plaza Charging | 876 Union St | San Francisco | 94133 | USA | Type2 | USR000193 | resident | 2024-04-16T22:10:00 | 2024-04-16T22:35:00 | 25 | app | 6.75 | blank |
| EVS00006 | bus | 61 | true | CA | STN0035 | Embarcadero EV Park | 100 Embarcadero | San Francisco | 94105 | USA | CCS | USR000025 | fleet | 2024-04-17T09:00:00 | 2024-04-17T10:30:00 | 90 | subscription | 0 | blank |
| EVS00007 | motorcycle | 2.6 | true | CA | STN0016 | Alameda QuickCharge | 2200 Central Ave | Alameda | 94501 | USA | Other | USR000054 | other | 2024-04-17T07:45:00 | 2024-04-17T07:55:00 | 10 | credit_card | 2.3 | blank |
| EVS00008 | car | 14.2 | true | CA | STN0011 | East Bay EV | 1900 Ashby Ave | Berkeley | 94703 | USA | Type2 | USR000128 | resident | 2024-04-18T19:20:00 | 2024-04-18T19:45:00 | 25 | app | 5.9 | blank |
| EVS00009 | truck | 33.9 | true | CA | STN0023 | Golden Gate Charge | 555 Golden Gate Ave | San Francisco | 94102 | USA | CHAdeMO | USR000067 | commercial | 2024-04-19T14:55:00 | 2024-04-19T15:40:00 | 45 | credit_card | 9.8 | blank |
| EVS00010 | motorcycle | 4.8 | true | CA | STN0012 | Telegraph EV Point | 2500 Telegraph Ave | Oakland | 94612 | USA | CCS | blank | visitor | 2024-04-20T15:10:00 | 2024-04-20T15:30:00 | 20 | free | 0 | blank |
| EVS00011 | car | 16.7 | true | CA | STN0008 | College Ave EV | 1550 College Ave | Berkeley | 94704 | USA | Type2 | USR000218 | resident | 2024-04-20T21:00:00 | 2024-04-20T21:28:00 | 28 | app | 7.1 | blank |
| EVS00012 | car | 21.5 | true | CA | STN0032 | Civic Center EV | 350 Civic Center Pl | San Jose | 95110 | USA | CCS | USR000095 | fleet | 2024-04-21T07:35:00 | 2024-04-21T08:05:00 | 30 | subscription | 0 | blank |
| EVS00013 | car | 17.8 | true | CA | STN0025 | Market St FastCharge | 700 Market St | San Francisco | 94103 | USA | Type2 | USR000204 | resident | 2024-04-21T17:15:00 | 2024-04-21T17:45:00 | 30 | app | 6.85 | blank |
| EVS00014 | truck | 37.6 | true | CA | STN0031 | Parkside EV | 450 Parkside Dr | Oakland | 94619 | USA | CCS | USR000033 | fleet | 2024-04-22T12:00:00 | 2024-04-22T12:46:00 | 46 | subscription | 0 | blank |
| EVS00015 | car | 12.4 | true | CA | STN0034 | Westfield EV | 123 Westfield Mall | San Jose | 95128 | USA | Type2 | USR000142 | resident | 2024-04-23T19:35:00 | 2024-04-23T19:55:00 | 20 | app | 5.6 | blank |
| EVS00016 | bus | 41.2 | true | CA | STN0029 | Lake Merritt EV | 255 Lake Merritt Blvd | Oakland | 94610 | USA | CHAdeMO | USR000078 | commercial | 2024-04-24T10:15:00 | 2024-04-24T11:05:00 | 50 | credit_card | 12.4 | blank |
| EVS00017 | car | 16.3 | true | CA | STN0036 | SOMA QuickCharge | 888 Howard St | San Francisco | 94103 | USA | Type2 | blank | visitor | 2024-04-25T09:40:00 | 2024-04-25T10:10:00 | 30 | free | 0 | blank |
| EVS00018 | car | 9.7 | true | CA | STN0028 | Pier 39 EV | 2 Beach St | San Francisco | 94133 | USA | CCS | USR000060 | other | 2024-04-26T13:30:00 | 2024-04-26T13:50:00 | 20 | credit_card | 4.2 | blank |
| EVS00019 | car | 11.9 | true | CA | STN0022 | Castro EV Hub | 500 Castro St | San Francisco | 94114 | USA | Type2 | USR000173 | resident | 2024-04-27T20:05:00 | 2024-04-27T20:30:00 | 25 | app | 5.1 | blank |
| EVS00020 | truck | 29.6 | true | CA | STN0037 | Mountain View EV | 1600 Amphitheatre Pkwy | Mountain View | 94043 | USA | CHAdeMO | USR000110 | commercial | 2024-04-28T16:00:00 | 2024-04-28T16:40:00 | 40 | credit_card | 11.1 | blank |
What the 200 rows show
from the 200-row sampleBus (vehicle type) stands out: mean energy_
- 93%is_
successful = true - 13.2median energy_
delivered_ kwh - 4connector types
- 5user types
- 5payment methods
- 53station cities
Median 13.2, from 2.0 to 61.0.
- string 14
- float 3
- datetime 2
- boolean 1
Columns
20 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
session_id | string | Unique identifier for each charging sessionunique | EVS00001 |
station_id | string | Unique identifier for the charging station | STN0021 |
station_name | string | Human-readable name of the charging stationoptional | GreenLeaf Charging Plaza |
station_street_address | string | Street address of the charging stationoptional | 101 Oak Ave |
station_city | string | City where the charging station is locatedoptional | San Francisco |
station_state | string | State or region of the charging station5 states · optional | CA |
station_postal_code | string | Postal code of the charging stationoptional | 94102 |
station_country | string | Country where the charging station is locatedoptional | USA |
connector_type | string | Type of connector used for charging (e.g., CCS, CHAdeMO, Type2)CCS · CHAdeMO · Type2 · Other · optional | CCS |
user_id | string | Unique identifier for the user (anonymized if needed)optional | USR000177 |
user_type | string | Type of user (e.g., resident, commercial, fleet, visitor)resident · commercial · fleet · visitor · other | resident |
vehicle_type | string | Type of electric vehicle (e.g., car, bus, truck, motorcycle)car · bus · truck · motorcycle · other · optional | car |
payment_method | string | Payment method used for the session (e.g., credit_card, app, subscription, free)credit_card · app · subscription · free · other · optional | app |
error_code | string | Error code if the session failed or was interruptedoptional | EV-ERR-24 |
| Numbers 3 columns | |||
session_duration_minutes | float | Total duration of the charging session in minutes0 or more | 30 |
energy_delivered_kwh | float | Total energy delivered during the session in kilowatt-hours (kWh)0 or more | 22.3 |
session_cost | float | Total cost charged for the session (in local currency)0 or more · optional | 8.45 |
| Dates and times 2 columns | |||
session_start_time | datetime | Timestamp when the charging session started | 2024-04-12T08:40:00 |
session_end_time | datetime | Timestamp when the charging session ended | 2024-04-12T09:10:00 |
| True or false 1 column | |||
is_successful | boolean | Indicates if the charging session was completed successfully | true |
Use it for
An energy dashboard
The is_
successful rate, energy_ delivered_ kwh by vehicle_ type and a breakdown of station_ state. Excel, Power BI or Tableau. Why do the 21 bus rows have a mean energy_
delivered_ kwh of 39.4? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Sessions200EVS0000122.3carEVS0000218.1carEVS-B2-00164.2motorcyc…
A software demo
Believable sessions with station_
id, station_ name and station_ street_ address to fill a screen in front of a buyer.
blueprint · urban-ev-charging-station-logs
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 20 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.
- Charging station ID and location included
- Session start and end timestamps tracked
- Energy delivered per session recorded
- Vehicle type and user category logged
- Session outcome and payment status included
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
- urban-ev-charging-station-logs