Fleet Route Carbon Impact Data

This dataset provides detailed, route-level records of municipal or nonprofit fleet operations, including vehicle and route identifiers, timing, locations, fuel and vehicle types, distance, and estimated carbon emissions. It is ideal for sustainability auditing, operational optimization, and regulatory reporting, empowering small-municipality transportation planners to track and reduce fleet carbon impact.

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

Sustainability and carbon emissions auditing for municipal fleets

Sample rows

preview · 8 of 64 rows · all 27 columns
route_idstringvehicle_typestringpassenger_countintegervehicle_idstringroute_namestringroute_datedatefuel_typestringdistance_kmfloatstart_timedatetimeend_timedatetimestart_location_namestringstart_location_streetstringstart_location_citystringstart_location_statestringstart_location_postal_codestringstart_location_countrystringend_location_namestringend_location_streetstringend_location_citystringend_location_statestringend_location_postal_codestringend_location_countrystringestimated_co2_kgfloatemission_factor_kg_per_kmfloatreporting_periodstringoperator_idstringnotesstring
R001van9VAN-117Downtown Loop2024-06-03diesel28.42024-06-03T08:10:002024-06-03T09:00:00Central Garage205 Main StHillsboroOR97123USADowntown Plaza320 Oak BlvdHillsboroOR97124USA48.281.7Q2-2024OP-021Routine service, light traffic
R002bus23BUS-202Eastside Shuttle2024-06-04CNG16.22024-06-04T07:45:002024-06-04T08:20:00East Garage807 Lincoln AveHillsboroOR97124USAEastside Park2412 Spruce StHillsboroOR97125USA13.770.85Q2-2024OP-015New CNG bus trial run
R003car1CAR-004Morning Express2024-06-05hybrid11.82024-06-05T07:15:002024-06-05T07:40:00City Hall100 Civic PlazaHillsboroOR97123USALibrary345 Elm StHillsboroOR97124USA4.250.36Q2-2024OP-027Hybrid vehicle used for sustainability
R004bus31BUS-108Westside School Route2024-06-01diesel22.92024-06-01T07:00:002024-06-01T07:50:00West Garage900 Willow DrCorneliusOR97113USAWestside Elementary533 Maple AveCorneliusOR97113USA39.931.744Q2-2024OP-002School bus, heavy passenger load
R005van6VAN-205Senior Center Pickup2024-06-02gasoline10.42024-06-02T09:30:002024-06-02T09:55:00Senior Center200 5th StForest GroveOR97116USAMedical Clinic1200 Johnson RdForest GroveOR97116USA14.041.352024-06OP-009Pickup for medical appointments
R006car2CAR-007Community Outreach2024-06-02electric8.22024-06-02T10:20:002024-06-02T10:45:00Community Center725 2nd AveHillsboroOR97123USAFood Bank330 Pine StHillsboroOR97124USA0.490.062024-06OP-014EV outreach route
R007truck0TRUCK-321Weekly Recycling2024-06-06diesel34.52024-06-06T06:30:002024-06-06T07:30:00Recycling Center1500 Grant RdCorneliusOR97113USATransfer Station2600 Industrial WayHillsboroOR97124USA6922024-06OP-030Truck loaded, regular route
R008bus14BUS-205Farmers Market Shuttle2024-06-08LPG15.72024-06-08T09:00:002024-06-08T09:40:00Market Square450 Market StForest GroveOR97116USACity Park890 Parkside AveForest GroveOR97116USA11.930.76Q2-2024OP-011Event shuttle

What the 64 rows show

from the 64-row sample

Bus (vehicle type) stands out: mean passenger_count is 28.7, against 3.3 for the rest.

  • 5median passenger_count
  • 3reporting periods
  • 5start location states
  • 5end location states
  • 6fuel types
  • 14start location cities
Mean passenger_count by vehicle_type64 rows
0204028.7bus19 rows7.2van14 rows1.0truck14 rows2.6car13 rows0.25other4 rows
passenger_count64 rows, in bands of 10
02550437643103060passenger_count →

Median 5, from 0 to 51.

vehicle_id64 rows · top 10 of 24 values
  1. V3018
  2. V4126
  3. V1515
  4. V2075
  5. V5214
  6. VAN-1173
  7. BUS-2023
  8. BUS-2053
  9. TRUCK-1123
  10. CAR-0042
27 columns by typefrom the column list below
  • string 20
  • integer 1
  • float 3
  • date 1
  • datetime 2

Columns

27 columns in three groups
blueprint · 27 columns
columntypedescriptionexample
Text 20 columns
route_idstringUnique identifier for the fleet routeuniqueR001
route_namestringDescriptive name for the fleet routeDowntown Loop
vehicle_idstringUnique identifier for the vehicle used on the routeVAN-117
vehicle_typestringType of vehicle (e.g., bus, van, truck)bus · van · truck · car · othervan
fuel_typestringType of fuel used by the vehicle7 valuesdiesel
start_location_namestringName of the route's starting locationCentral Garage
start_location_streetstringStreet address of the starting locationoptional205 Main St
start_location_citystringCity of the starting locationoptionalHillsboro
start_location_statestringState or province of the starting location5 states · optionalOR
start_location_postal_codestringPostal code of the starting locationoptional97123
start_location_countrystringCountry of the starting locationoptionalUSA
end_location_namestringName of the route's ending locationDowntown Plaza
end_location_streetstringStreet address of the ending locationoptional320 Oak Blvd
end_location_citystringCity of the ending locationoptionalHillsboro
end_location_statestringState or province of the ending location5 states · optionalOR
end_location_postal_codestringPostal code of the ending locationoptional97124
end_location_countrystringCountry of the ending locationoptionalUSA
reporting_periodstringReporting period for regulatory or auditing purposes (e.g., Q1-2024, 2024-06)3 periods · optionalQ2-2024
operator_idstringIdentifier for the operator or driver responsible for the routeoptionalOP-021
notesstringAdditional notes or comments about the route or emissions estimateoptionalNew CNG bus trial run
Numbers 4 columns
distance_kmfloatTotal distance covered on the route in kilometers0 or more28.4
passenger_countintegerNumber of passengers transported on the route0 or more · optional9
estimated_co2_kgfloatEstimated total carbon emissions for the route in kilograms of CO2 equivalent0 or more48.28
emission_factor_kg_per_kmfloatEmission factor used for calculation (kg CO2e per km for the vehicle/fuel type)0 or more · optional1.7
Dates and times 3 columns
route_datedateDate when the route was operated2024-06-03
start_timedatetimeDate and time when the route started2024-06-03T08:10:00
end_timedatetimeDate and time when the route ended2024-06-03T09:00:00

Use it for

  • median passeng…564 rowsmean passenger count …28.7bus7.2van1.0truck2.6car

    A transportation dashboard

    Passenger_count by vehicle_type and a breakdown of vehicle_id. Excel, Power BI or Tableau.

  • Why do the 19 bus rows have a mean passenger_count of 28.7?

    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 routes with route_name, route_date and vehicle_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset64 rows27 columns
Yours10,000 rows27 columnsstart_location_name: UK only

blueprint · fleet-route-carbon-impact-data

Behind this dataset

Same schema. As many rows as you need.

These 64 rows came out of a blueprint — 27 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 single fleet route completion for one vehicle.
  • Includes route distance (km), vehicle type, fuel type, and estimated CO2 emissions (kg).
  • Routes must occur within urban or semi-urban neighborhoods.
  • Contains weather conditions and average traffic congestion rating for the route.
  • Only non-personal/municipal or nonprofit vehicles are used.
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
fleet-route-carbon-impact-data

More in Transportation

Browse all
Also in TransportationRoute Carbon Impact Assessment LogsTransportation Demand Forecast DatasetConnected Vehicle Telemetry DatasetAll 1,947 datasets

What should your data show?

Preview 20 rows free
No signup. No card.