Logistics
26 columns
120 rows
8 formats

Fleet Energy Consumption Tracker

This dataset provides detailed trip-level energy consumption metrics for logistics fleet vehicles, including fuel and electricity usage, CO2 emissions, and route efficiency. It supports sustainability reporting, operational optimization, and route planning by offering comprehensive data on each trip's energy profile and performance. Ideal for organizations seeking to reduce costs and environmental impact across their fleet operations.

last updated 13 Jan 2026
by GoMask

The brief that made it

Fleet energy usage monitoring and cost analysis

Sample rows

preview · 8 of 120 rows · all 26 columns

trip_idstring	vehicle_typestring	average_speed_kphfloat	sustainability_flagboolean	start_location_countrystring	vehicle_idstring	fuel_typestring	driver_idstring	trip_start_datetimedatetime	trip_end_datetimedatetime	start_location_streetstring	start_location_citystring	start_location_statestring	start_location_postal_codestring	end_location_streetstring	end_location_citystring	end_location_statestring	end_location_postal_codestring	end_location_countrystring	distance_kmfloat	fuel_consumed_litersfloat	electricity_consumed_kwhfloat	co2_emissions_kgfloat	route_idstring	route_efficiency_scorefloat	notesstring
TRIP-0001	truck	48.8	false	US	VEH-1001	diesel	DRV-001	2024-04-02T06:30:00Z	2024-04-02T15:10:00Z	1255 Commerce Ave	Houston	TX	77002	389 Industrial Rd	Dallas	TX	75201	US	393.4	111.2	blank	360.1	TX-INT-4	62.3	Heavy traffic near Dallas
TRIP-0002	ev	13.2	true	CA	VEH-1002	electric	DRV-002	2024-04-03T08:22:00Z	2024-04-03T09:32:00Z	21 Queen St	Toronto	ON	M5H2M4	53 King St W	Toronto	ON	M5H1A1	CA	15.2	blank	4.7	2.5	EVCAN-TOR-1	90.5	Urban test run, light cargo
TRIP-0003	van	16.1	false	US	VEH-1003	gasoline	DRV-003	2024-04-03T11:10:00Z	2024-04-03T11:42:00Z	691 Market St	San Francisco	CA	94103	200 Pine St	San Francisco	CA	94111	US	8.6	1.7	blank	2.3	SF-VAN-2	65.9	Parcel delivery downtown
TRIP-0004	hybrid	13.1	true	FR	VEH-1004	hybrid	DRV-004	2024-04-04T07:05:00Z	2024-04-04T09:00:00Z	18 Rue de la Paix	Paris	IDF	75002	44 Avenue Montaigne	Paris	IDF	75008	FR	24.3	2.8	5.2	5.6	RTE-PARIS-1	87.3	Eco routing, low emissions
TRIP-0005	truck	72.6	false	US	VEH-1001	diesel	DRV-005	2024-04-05T13:30:00Z	2024-04-05T22:45:00Z	1228 W 1st Ave	Denver	CO	80223	1542 S 8th Rd	Phoenix	AZ	85007	US	1294.7	320.6	blank	1032.8	US-SW-TRK1	55.2	Desert cross, minor delays
TRIP-0006	ev	15.2	true	IN	VEH-1005	electric	DRV-006	2024-04-06T09:58:00Z	2024-04-06T10:24:00Z	108 MG Road	Mumbai	MH	400001	21 Marine Drive	Mumbai	MH	400002	IN	6.7	blank	2.1	0.8	IN-EV-MUM-2	94.8	Battery regen, light cargo
TRIP-0007	truck	73.6	false	US	VEH-1006	diesel	DRV-007	2024-04-07T04:15:00Z	2024-04-07T13:35:00Z	944 Main St	Chicago	IL	60601	2150 W 26th St	Minneapolis	MN	55404	US	660.9	209.7	blank	606.2	US-MW-TRK2	63.9	Weather delays, roadwork
TRIP-0008	van	10.9	false	UK	VEH-1007	gasoline	DRV-008	2024-04-07T15:20:00Z	2024-04-07T16:28:00Z	9 Baker St	London	ENG	NW1 6XE	22 Piccadilly	London	ENG	W1J 0DG	UK	12.8	2.2	blank	3.1	LDN-VAN-1	72.1	Bike lane closures
TRIP-0009	hybrid	9.5	true	SE	VEH-1008	hybrid	DRV-009	2024-04-08T06:40:00Z	2024-04-08T08:57:00Z	54 Karlavägen	Stockholm	STH	11449	23 Sveavägen	Stockholm	STH	11359	SE	18.4	1.1	3.8	2.2	SE-HYB-STK-3	89.7	Frequent stops, eco mode
TRIP-0010	truck	75.5	false	AU	VEH-1009	diesel	DRV-010	2024-04-09T02:00:00Z	2024-04-09T13:42:00Z	44 Cattle Dr	Brisbane	QLD	4000	88 Riverside Ave	Sydney	NSW	2000	AU	931.5	288.6	blank	815.8	AUS-EAST-TRK4	60.3	River crossing, fog
TRIP-0011	ev	12.9	true	BR	VEH-1010	electric	DRV-011	2024-04-10T14:15:00Z	2024-04-10T14:50:00Z	71 Avenida Paulista	São Paulo	SP	01311-000	19 Rua Augusta	São Paulo	SP	01305-000	BR	7.5	blank	2.9	1.3	BR-EV-PAU-2	96.4	Short run, full battery
TRIP-0012	truck	61.9	false	US	VEH-1011	diesel	DRV-012	2024-04-11T05:55:00Z	2024-04-11T18:30:00Z	15 North Rd	Seattle	WA	98101	500 S Main St	Portland	OR	97204	US	282.1	78.5	blank	215.6	US-NW-TRK5	69.7	Rainy conditions
TRIP-0013	hybrid	8.7	true	IT	VEH-1012	hybrid	DRV-013	2024-04-12T17:40:00Z	2024-04-12T18:45:00Z	31 Via Roma	Milan	MI	20121	17 Corso Magenta	Milan	MI	20123	IT	9.7	1.5	2.5	3.5	IT-HYB-MIL-1	92.8	Frequent stops, city traffic
TRIP-0014	other	13.6	true	AR	VEH-1013	other	DRV-014	2024-04-13T13:00:00Z	2024-04-13T13:15:00Z	blank	Cordoba	CB	5000	blank	Cordoba	CB	5000	AR	3.4	0.3	blank	0.4	AR-BIO-1	68.1	Biofuel test run
TRIP-0015	ev	16.9	true	FR	VEH-1014	electric	DRV-015	2024-04-14T07:10:00Z	2024-04-14T07:32:00Z	27 Place Bellecour	Lyon	ARA	69002	11 Rue de la République	Lyon	ARA	69001	FR	6.2	blank	1.6	0.6	FR-EV-LYO-1	97.1	No emission, city run
TRIP-0016	truck	63.7	false	US	VEH-1015	diesel	DRV-016	2024-04-15T23:45:00Z	2024-04-16T09:50:00Z	2200 Loop Rd	Omaha	NE	68102	400 S 10th St	Salt Lake City	UT	84101	US	1552.6	398.2	blank	1298.1	US-TRK-MTN1	44	Mountain pass, snow
TRIP-0017	van	13.7	false	SE	VEH-1016	diesel	DRV-017	2024-04-16T15:00:00Z	2024-04-16T15:32:00Z	8 Drottninggatan	Stockholm	STH	11151	21 Odenplan	Stockholm	STH	11322	SE	7.3	1.4	blank	1.9	SE-VAN-2	79.3	Short run, city traffic
TRIP-0018	hybrid	13.5	true	DE	VEH-1017	hybrid	DRV-018	2024-04-17T08:10:00Z	2024-04-17T09:05:00Z	77 Friedrichstr.	Berlin	BE	10117	15 Alexanderplatz	Berlin	BE	10178	DE	11.5	1	2.9	2.6	DE-HYB-BER-1	88.2	Eco mode, city center
TRIP-0019	truck	58.7	false	US	VEH-1018	diesel	DRV-019	2024-04-18T20:00:00Z	2024-04-19T06:30:00Z	1801 Highway 1	Los Angeles	CA	90001	37 Port Blvd	San Diego	CA	92101	US	193.6	54.9	blank	133.3	US-CA-TRK7	74.2	Port pickup
TRIP-0020	van	14.2	true	BR	VEH-1019	gasoline	DRV-020	2024-04-19T09:05:00Z	2024-04-19T09:32:00Z	10 Rua Botafogo	Rio de Janeiro	RJ	22250-040	12 Av. Copacabana	Rio de Janeiro	RJ	22041-001	BR	6.4	1.2	blank	1.7	BR-VAN-RIO-1	81.6	Beach delivery

What the 120 rows show

from the 120-row sample

Truck (vehicle type) stands out: mean average_speed_kph is 63.1, against 12.9 for the rest.

65%sustainability_flag = true
15.0median average_speed_kph
5fuel types
17end location countries
10.6median distance_km
1.6median fuel_consumed_liters

Mean average_speed_kph by vehicle_type120 rows

average_speed_kph120 rows, in bands of 10

Median 15.0, from 0.0 to 84.2.

start_location_country120 rows · top 10 of 17 values

US38
CA11
FR11
SE8
BR8
AU7
IT7
UK6
AR5
DE5

26 columns by typefrom the column list below

string 17
float 6
datetime 2
boolean 1

Columns

26 columns in four groups

blueprint · 26 columns
column	type	description	example
Text 17 columns
`trip_id`	string	Unique identifier for each recorded tripunique	TRIP-0001
`vehicle_id`	string	Unique identifier for the vehicle used in the trip	VEH-1001
`vehicle_type`	string	Type of vehicle (e.g., truck, van, EV, hybrid)truck · van · ev · hybrid · other	truck
`fuel_type`	string	Primary fuel or energy source used for the tripdiesel · gasoline · electric · hybrid · other	diesel
`driver_id`	string	Unique identifier for the driver assigned to the trip	DRV-001
`start_location_street`	string	Street address of trip starting pointoptional	1255 Commerce Ave
`start_location_city`	string	City of trip starting pointoptional	Houston
`start_location_state`	string	State or region of trip starting pointoptional	TX
`start_location_postal_code`	string	Postal code of trip starting pointoptional	77002
`start_location_country`	string	Country of trip starting pointoptional	US
`end_location_street`	string	Street address of trip ending pointoptional	389 Industrial Rd
`end_location_city`	string	City of trip ending pointoptional	Dallas
`end_location_state`	string	State or region of trip ending pointoptional	TX
`end_location_postal_code`	string	Postal code of trip ending pointoptional	75201
`end_location_country`	string	Country of trip ending pointoptional	US
`route_id`	string	Identifier for the planned or actual route takenoptional	TX-INT-4
`notes`	string	Additional comments or observations about the tripoptional	Parcel delivery downtown
Numbers 6 columns
`distance_km`	float	Total distance covered during the trip in kilometers0 or more	393.4
`fuel_consumed_liters`	float	Total fuel consumed during the trip in liters (if applicable)0 or more · optional	111.2
`electricity_consumed_kwh`	float	Total electricity consumed during the trip in kilowatt-hours (if applicable)0 or more · optional	4.7
`co2_emissions_kg`	float	Estimated CO2 emissions for the trip in kilograms0 or more · optional	360.1
`average_speed_kph`	float	Average speed during the trip in kilometers per hour0 or more · optional	48.8
`route_efficiency_score`	float	Calculated score representing route efficiency (higher is better)0 to 100 · optional	62.3
Dates and times 2 columns
`trip_start_datetime`	datetime	Timestamp when the trip began	2024-04-02T06:30:00Z
`trip_end_datetime`	datetime	Timestamp when the trip ended	2024-04-02T15:10:00Z
True or false 1 column
`sustainability_flag`	boolean	Indicates if the trip meets sustainability criteriaoptional	false

Use it for

A logistics dashboard
The sustainability_flag rate, average_speed_kph by vehicle_type and a breakdown of start_location_country. Excel, Power BI or Tableau.
Why do the 36 truck rows have a mean average_speed_kph of 63.1?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Trips120
TRIP-000148.8truck
TRIP-000213.2ev
TRIP-000413.1hybrid
A software demo
Believable trips with vehicle_id, vehicle_type and fuel_type to fill a screen in front of a buyer.

This dataset120 rows26 columns

Yours1,000 rows26 columnsstart_location_street: UK only

blueprint · fleet-energy-consumption-tracker

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 26 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 vehicle trip.
Include both fuel and electric energy metrics.
Record trip distance, duration, and route type.
Flag trips where energy intensity exceeds fleet average.
Timestamp all entries for temporal analysis.

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: fleet-energy-consumption-tracker

What should your data show?

No signup. No card.

Sample rows

What the 120 rows show

Columns

Use it for

A logistics dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Logistics

What should your data show?