EV Charging Station Utilization
This dataset provides detailed, synthetic logs of electric vehicle charging station usage across a smart city network, including session times, energy delivered, station locations, user types, and payment methods. It enables comprehensive analysis of EV infrastructure utilization, supports sustainability initiatives, and informs urban planning and energy management strategies.
Sample rows
preview · 8 of 200 rows · all 22 columns| log_idstring | station_typestring | energy_kwhfloat | renewable_energyboolean | user_typestring | station_idstring | station_namestring | location_street_addressstring | location_citystring | location_statestring | location_postal_codestring | location_countrystring | latitudefloat | longitudefloat | session_idstring | vehicle_idstring | session_start_timedatetime | session_end_timedatetime | session_duration_minutesinteger | cost_usdfloat | payment_methodstring | station_statusstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LOG000001 | Level 2 | 14.2 | true | public | ST-US-001 | LA Downtown Central | 123 Main St | Los Angeles | CA | 90012 | USA | 34.0522 | -118.2437 | SES10001 | VEH-US4567 | 2024-05-01T09:15:00 | 2024-05-01T10:45:00 | 90 | 12.35 | credit_card | available |
| LOG000002 | DC Fast | 35.1 | false | fleet | ST-US-002 | NYC Midtown Garage | 456 7th Ave | New York | NY | 10018 | USA | 40.7536 | -73.9832 | SES10002 | VEH-US9821 | 2024-05-02T11:20:00 | 2024-05-02T11:50:00 | 30 | 24.8 | rfid_card | in_use |
| LOG000003 | Level 1 | 6.7 | true | employee | ST-US-003 | blank | 789 Oak Dr | Seattle | WA | 98101 | USA | 47.6062 | -122.3321 | SES10003 | VEH-US3210 | 2024-05-03T08:00:00 | 2024-05-03T10:30:00 | 150 | 0 | free | available |
| LOG000004 | Level 2 | 15.8 | false | public | ST-CA-001 | Toronto Union Station | 65 Front St W | Toronto | ON | M5J1E6 | Canada | 43.6456 | -79.3807 | SES10004 | VEH-CA8776 | 2024-05-04T14:10:00 | 2024-05-04T15:40:00 | 90 | 11.8 | mobile_app | available |
| LOG000005 | Level 2 | 12.4 | true | employee | ST-US-004 | Denver Tech Center | 1021 Park Ave | Denver | CO | 80205 | USA | 39.7392 | -104.9903 | SES10005 | VEH-US6543 | 2024-05-05T07:45:00 | 2024-05-05T10:15:00 | 150 | 0 | free | maintenance |
| LOG000006 | Other | 22.9 | false | other | ST-AU-001 | Sydney CBD Station | 10 George St | Sydney | NSW | 2000 | Australia | -33.8688 | 151.2093 | SES10006 | VEH-AU4422 | 2024-05-06T16:25:00 | 2024-05-06T17:35:00 | 70 | 19.99 | mobile_app | in_use |
| LOG000007 | DC Fast | 39.4 | false | fleet | ST-US-005 | Chicago Loop Garage | 112 State St | Chicago | IL | 60601 | USA | 41.8781 | -87.6298 | SES10007 | VEH-US5777 | 2024-05-07T13:35:00 | 2024-05-07T13:55:00 | 20 | 26.1 | mobile_app | in_use |
| LOG000008 | Level 2 | 16.6 | false | public | ST-US-006 | San Francisco Civic | 200 Market St | San Francisco | CA | 94105 | USA | 37.7749 | -122.4194 | SES10008 | VEH-US9999 | 2024-05-08T15:50:00 | 2024-05-08T17:30:00 | 100 | 13.1 | credit_card | available |
| LOG000009 | Other | 27.5 | false | public | ST-CN-001 | Shanghai Pudong | 8 Lujiazui Rd | Shanghai | SH | 200120 | China | 31.2304 | 121.4737 | SES10009 | VEH-CN8531 | 2024-05-09T09:05:00 | 2024-05-09T10:05:00 | 60 | 18.6 | mobile_app | in_use |
| LOG000010 | Level 2 | 17.1 | true | public | ST-US-007 | Houston Energy Plaza | 501 Texas Ave | Houston | TX | 77002 | USA | 29.7604 | -95.3698 | SES10010 | VEH-US2323 | 2024-05-10T10:00:00 | 2024-05-10T11:50:00 | 110 | 14.25 | credit_card | available |
| LOG000011 | Level 2 | 13.2 | true | employee | ST-US-004 | Denver Tech Center | 1021 Park Ave | Denver | CO | 80205 | USA | 39.7392 | -104.9903 | SES10011 | VEH-US7654 | 2024-05-11T08:15:00 | 2024-05-11T11:15:00 | 180 | 0 | free | available |
| LOG000012 | Other | 8.4 | false | blank | ST-MX-001 | Mexico City Centro | Calle Reforma 100 | Mexico City | CDMX | 01000 | Mexico | 19.4326 | -99.1332 | SES10012 | VEH-MX5432 | 2024-05-12T12:05:00 | 2024-05-12T12:25:00 | 20 | 5.5 | other | maintenance |
| LOG000013 | DC Fast | 33.7 | false | fleet | ST-US-008 | Las Vegas Strip | 3500 Las Vegas Blvd | Las Vegas | NV | 89109 | USA | 36.1699 | -115.1398 | SES10013 | VEH-US1123 | 2024-05-13T19:00:00 | 2024-05-13T19:25:00 | 25 | 22.9 | rfid_card | in_use |
| LOG000014 | Level 2 | 14.7 | true | public | ST-US-001 | LA Downtown Central | 123 Main St | Los Angeles | CA | 90012 | USA | 34.0522 | -118.2437 | SES10014 | VEH-US5673 | 2024-05-14T12:30:00 | 2024-05-14T14:00:00 | 90 | 13.8 | mobile_app | available |
| LOG000015 | Level 1 | 8.1 | false | employee | ST-US-009 | blank | blank | Reno | NV | blank | USA | 39.5296 | -119.8138 | SES10015 | VEH-US8912 | 2024-05-15T07:05:00 | 2024-05-15T09:25:00 | 140 | 0 | free | available |
| LOG000016 | Level 2 | 18.2 | true | public | ST-US-010 | Miami Beach Center | 500 Ocean Dr | Miami Beach | FL | 33139 | USA | 25.7907 | -80.13 | SES10016 | VEH-US1452 | 2024-05-16T09:35:00 | 2024-05-16T11:35:00 | 120 | 14.95 | credit_card | available |
| LOG000017 | DC Fast | 34.2 | false | fleet | ST-CA-002 | Vancouver Waterfront | 88 Canada Pl | Vancouver | BC | V6C3E1 | Canada | 49.2827 | -123.1207 | SES10017 | VEH-CA1222 | 2024-05-17T14:25:00 | 2024-05-17T14:55:00 | 30 | 24.3 | mobile_app | in_use |
| LOG000018 | Level 2 | 13.8 | false | public | ST-US-011 | Boston Innovation District | 200 Seaport Blvd | Boston | MA | 02210 | USA | 42.3487 | -71.0427 | SES10018 | VEH-US3421 | 2024-05-18T13:15:00 | 2024-05-18T14:45:00 | 90 | 12.7 | credit_card | available |
| LOG000019 | Level 2 | 12.9 | false | employee | ST-US-012 | Austin UT Campus | 2400 Guadalupe St | Austin | TX | 78705 | USA | 30.2849 | -97.7341 | SES10019 | VEH-US5332 | 2024-05-19T07:45:00 | 2024-05-19T10:15:00 | 150 | 0 | free | available |
| LOG000020 | Other | 15.2 | true | public | ST-CA-003 | blank | 500 King St W | Toronto | ON | M5V1M3 | Canada | 43.6441 | -79.3967 | SES10020 | VEH-CA7654 | 2024-05-20T12:00:00 | 2024-05-20T13:20:00 | 80 | 13.7 | mobile_app | in_use |
What the 200 rows show
from the 200-row sampleDC Fast (station type) stands out: mean energy_
- 39%renewable_
energy = true - 15.2median energy_
kwh - 4station statuses
- 5location countries
- 5payment methods
- 33location states
Median 15.2, from 0.10 to 51.6.
- string 14
- integer 1
- float 4
- datetime 2
- boolean 1
Columns
22 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
log_id | string | Unique identifier for each station usage log entryunique | LOG000001 |
station_id | string | Unique identifier for the charging station | ST-US-001 |
station_name | string | Human-readable name of the charging stationoptional | LA Downtown Central |
station_type | string | Type of charging station (e.g., Level 2, DC Fast)Level 1 · Level 2 · DC Fast · Other | Level 2 |
location_street_address | string | Street address of the charging stationoptional | 123 Main St |
location_city | string | City where the charging station is located | Los Angeles |
location_state | string | State or region where the charging station is located | CA |
location_postal_code | string | Postal code of the charging station locationoptional | 90012 |
location_country | string | Country of the charging station5 countries | USA |
session_id | string | Unique identifier for the charging sessionunique | SES10001 |
vehicle_id | string | Unique identifier for the vehicle using the station (anonymized) | VEH-US4567 |
user_type | string | Type of user (e.g., public, fleet, employee)public · fleet · employee · other · optional | public |
payment_method | string | Payment method used for the sessioncredit_card · mobile_app · rfid_card · free · other · optional | credit_card |
station_status | string | Operational status of the station during the sessionavailable · in_use · maintenance · offline · optional | available |
| Numbers 5 columns | |||
latitude | float | Latitude coordinate of the charging station-90 to 90 | 34.0522 |
longitude | float | Longitude coordinate of the charging station-180 to 180 | -118.2437 |
energy_kwh | float | Total energy delivered during the session in kilowatt-hours0 or more | 14.2 |
session_duration_minutes | integer | Duration of the charging session in minutes1 or more | 90 |
cost_usd | float | Total cost of the charging session in US dollars0 or more · optional | 12.35 |
| Dates and times 2 columns | |||
session_start_time | datetime | Timestamp when the charging session started | 2024-05-01T09:15:00 |
session_end_time | datetime | Timestamp when the charging session ended | 2024-05-01T10:45:00 |
| True or false 1 column | |||
renewable_energy | boolean | Indicates if the session was powered by renewable energy sourcesoptional | true |
Use it for
An energy dashboard
The renewable_
energy rate, energy_ kwh by station_ type and a breakdown of user_ type. Excel, Power BI or Tableau. Why do the 45 DC Fast rows have a mean energy_
kwh of 35.7? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs200LOG00000114.2Level 2LOG00000235.1DC FastLOG0000036.7Level 1
A software demo
Believable logs with station_
id, station_ name and station_ type to fill a screen in front of a buyer.
blueprint · ev-charging-station-utilization
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 22 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.
- Station ID and location per record
- Session duration 5-240 minutes
- Energy dispensed 1-90 kWh
- Charging time and peak/offpeak flag
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
- ev-charging-station-utilization