Urban Fleet Emissions Audit Log
This dataset provides detailed, audit-level records of emissions from urban vehicle fleets, including vehicle, route, operator, and fuel information for each audit event. It supports sustainability benchmarking, regulatory compliance, and operational optimization by enabling granular analysis of emissions by route, fleet, and year. Ideal for transit operators and city planners seeking to reduce environmental impact and improve fleet efficiency.
Sample rows
preview · 8 of 120 rows · all 18 columns| audit_idstring | vehicle_typestring | distance_kmfloat | countrystring | fleet_idstring | vehicle_idstring | route_idstring | audit_datedate | emissions_co2_kgfloat | emissions_nox_kgfloat | emissions_pm_kgfloat | fuel_typestring | fuel_consumed_litersfloat | operator_idstring | citystring | regionstring | yearinteger | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AUD-00001 | bus | 76.2 | Germany | FLEET-01 | VEH-0001 | RT-1001 | 2022-03-15 | 188.7 | 1.43 | 0.19 | diesel | 36.5 | OP-001 | Berlin | Berlin | 2022 | Routine audit, no issues. |
| AUD-00002 | car | 43.1 | USA | FLEET-02 | VEH-0002 | RT-1002 | 2021-07-08 | 0 | blank | blank | electric | blank | OP-002 | San Francisco | California | 2021 | All-electric car, no direct emissions. |
| AUD-00003 | taxi | 13.4 | France | FLEET-01 | VEH-0003 | RT-1003 | 2023-10-21 | 75.6 | 0.07 | 0.01 | gasoline | 5.8 | OP-003 | Paris | Île-de-France | 2023 | Short city route. |
| AUD-00004 | other | 99.3 | UAE | FLEET-03 | VEH-0004 | RT-1004 | 2025-11-12 | 0 | 0 | 0 | hydrogen | blank | OP-004 | Dubai | Dubai | 2025 | Test run for pilot hydrogen vehicle. |
| AUD-00005 | bus | 112.8 | Australia | FLEET-02 | VEH-0005 | RT-1005 | 2019-05-20 | 132.9 | 2.97 | 0.24 | cng | 48.1 | OP-001 | Sydney | New South Wales | 2019 | Routine audit, no issues. |
| AUD-00006 | truck | 168.1 | Mexico | FLEET-04 | VEH-0006 | RT-1006 | 2020-02-13 | 256.3 | 3.51 | 0.37 | lng | 67.2 | OP-005 | Mexico City | Mexico City | 2020 | Interstate LNG truck, high mileage. |
| AUD-00007 | car | 3.9 | Canada | FLEET-05 | VEH-0007 | RT-1007 | 2017-08-30 | 0.9 | 0.02 | 0.002 | hybrid | 0.7 | OP-006 | Toronto | Ontario | 2017 | Minimal distance, city commute. |
| AUD-00008 | bus | 65.3 | UK | FLEET-06 | VEH-0008 | RT-1008 | 2018-04-17 | 159.2 | 1.9 | 0.15 | diesel | 29.4 | OP-007 | London | Greater London | 2018 | Routine audit, no issues. |
| AUD-00009 | other | 999.9 | Japan | FLEET-07 | VEH-0009 | RT-1009 | 2100-06-01 | 999.9 | 9.99 | 9.99 | other | 999.9 | OP-008 | Tokyo | Tokyo | 2100 | Synthetic edge case for maximum year and emissions. |
| AUD-00010 | taxi | 7.6 | South Africa | FLEET-08 | VEH-0010 | RT-1010 | 2015-11-02 | 18.8 | 0.11 | 0.03 | gasoline | 2.7 | OP-009 | Johannesburg | Gauteng | 2015 | blank |
| AUD-00011 | car | 20.8 | Norway | FLEET-09 | VEH-0011 | RT-1011 | 2024-05-14 | 31.5 | 0.09 | 0.02 | hybrid | 2.9 | OP-010 | Oslo | Oslo | 2024 | Hybrid performance improved. |
| AUD-00012 | van | 60.4 | Germany | FLEET-10 | VEH-0012 | RT-1012 | 2025-02-18 | 0 | blank | blank | electric | blank | OP-011 | Hamburg | Hamburg | 2025 | All-electric van; emissions zero. |
| AUD-00013 | bus | 81.2 | USA | FLEET-03 | VEH-0013 | RT-1013 | 2023-09-06 | 191.3 | 1.91 | 0.21 | diesel | 41.3 | OP-004 | Houston | Texas | 2023 | Routine audit, no issues. |
| AUD-00014 | taxi | 4.2 | Australia | FLEET-11 | VEH-0014 | RT-1014 | 2010-06-29 | 8.7 | 0.03 | 0.005 | hybrid | 0.8 | OP-012 | Melbourne | Victoria | 2010 | blank |
| AUD-00015 | bus | 92.3 | USA | FLEET-04 | VEH-0015 | RT-1015 | 2018-12-09 | 146.6 | 2.18 | 0.17 | diesel | 38.9 | OP-005 | Chicago | Illinois | 2018 | Routine audit, no issues. |
| AUD-00016 | car | 57.9 | Sweden | FLEET-05 | VEH-0016 | RT-1016 | 2023-07-17 | 0 | blank | blank | electric | blank | OP-013 | Stockholm | Stockholm | 2023 | All-electric car, no direct emissions. |
| AUD-00017 | taxi | 5.6 | Brazil | FLEET-12 | VEH-0017 | RT-1017 | 2016-05-03 | 15.7 | 0.08 | 0.01 | gasoline | 2.3 | OP-014 | Rio de Janeiro | Rio de Janeiro | 2016 | blank |
| AUD-00018 | car | 24.1 | UK | FLEET-06 | VEH-0018 | RT-1018 | 2024-03-25 | 38.2 | 0.12 | 0.03 | hybrid | 3.3 | OP-007 | London | Greater London | 2024 | Hybrid performance improved. |
| AUD-00019 | bus | 70.6 | China | FLEET-07 | VEH-0019 | RT-1019 | 2022-06-13 | 134.2 | 2.13 | 0.22 | diesel | 32.5 | OP-008 | Beijing | Beijing | 2022 | blank |
| AUD-00020 | bus | 98.4 | South Africa | FLEET-08 | VEH-0020 | RT-1020 | 2018-09-29 | 217.8 | 2.98 | 0.28 | diesel | 43.2 | OP-009 | Cape Town | Western Cape | 2018 | Routine audit, no issues. |
What the 120 rows show
from the 120-row sampleOther (vehicle type) stands out: mean distance_
- 53.5median distance_
km - 8fuel types
- 19fleets
- 19operators
- 52.5median emissions_
co2_ kg - 1.4median emissions_
nox_ kg
Median 53.5, from 2.7 to 999.9.
- string 11
- integer 1
- float 5
- date 1
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
audit_id | string | Unique identifier for each audit log entryunique | AUD-00001 |
fleet_id | string | Unique identifier for the vehicle fleet being audited | FLEET-01 |
vehicle_id | string | Unique identifier for the individual vehicle within the fleet | VEH-0001 |
route_id | string | Unique identifier for the transit route serviced by the vehicle | RT-1001 |
fuel_type | string | Type of fuel used by the vehicle during the audit period8 values | diesel |
operator_id | string | Unique identifier for the transit operator responsible for the fleet | OP-001 |
city | string | City where the audit took place | Berlin |
region | string | Region or state/province where the audit took placeoptional | Berlin |
country | string | Country where the audit took place | Germany |
vehicle_type | string | Type of vehicle (e.g., bus, van, truck, taxi)6 values | bus |
notes | string | Additional notes or comments about the audit entryoptional | Short city route. |
| Numbers 6 columns | |||
emissions_co2_kg | float | Total CO2 emissions in kilograms for the vehicle on the audited route and date0 or more | 188.7 |
emissions_nox_kg | float | Total NOx emissions in kilograms for the vehicle on the audited route and date0 or more · optional | 1.43 |
emissions_pm_kg | float | Total particulate matter (PM) emissions in kilograms for the vehicle on the audited route and date0 or more · optional | 0.19 |
distance_km | float | Distance traveled by the vehicle on the audited route during the audit period, in kilometers0 or more | 76.2 |
fuel_consumed_liters | float | Amount of fuel consumed by the vehicle during the audit period, in liters (if applicable)0 or more · optional | 36.5 |
year | integer | Year the audit was performed (for year-over-year analysis)2,000 to 2,100 | 2022 |
| Dates and times 1 column | |||
audit_date | date | Date when the emissions audit was performed | 2022-03-15 |
Use it for
A transportation dashboard
Distance_
km by vehicle_ type and a breakdown of country. Excel, Power BI or Tableau. Why do the 14 other rows have a mean distance_
km of 350.5? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Audits120AUD-0000176.2busAUD-0000243.1carAUD-0000313.4taxi
A software demo
Believable audits with fleet_
id, vehicle_ id and route_ id to fill a screen in front of a buyer.
blueprint · urban-fleet-emissions-audit-log
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 18 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.
- Each row represents one fleet vehicle’s audit entry per month
- Emission output must be quantified in grams CO₂/km
- Vehicle type, age, and fuel type must be included
- Routes with above-threshold emissions flagged for review
- Complies with local urban emissions standards
- Missing data entries require reason codes
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-fleet-emissions-audit-log