Transit Carbon Offset Validation Log
This dataset provides detailed, trip-level records of carbon offsets applied to public transit operations, including emission estimates, offset purchases, and third-party validation results. It enables sustainability officers and smart city planners to verify, benchmark, and transparently report on environmental claims, supporting robust ESG disclosures and compliance. The dataset is ideal for auditing, benchmarking, and optimizing transit sustainability initiatives.
Sample rows
preview · 8 of 48 rows · all 28 columns| log_idstring | offset_project_namestring | passenger_countinteger | transit_operator_idstring | trip_idstring | route_idstring | vehicle_idstring | trip_start_datetimedatetime | trip_end_datetimedatetime | origin_stationstring | destination_stationstring | distance_kmfloat | emission_estimate_kgco2efloat | emission_estimate_methodstring | offset_purchase_idstring | offset_providerstring | offset_project_idstring | offset_amount_kgco2efloat | offset_purchase_datedate | offset_certificate_idstring | third_party_validatorstring | validation_statusstring | validation_datedate | esg_report_referencestring | notesstring | created_atdatetime | updated_atdatetime | validator_report_urlstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| c7f8a2b1-12e4-4e8a-9a72-1a5c1d2d8a31 | Wind Farm X | 32 | OP-NYC-001 | T20240101001 | R-7A | V-BUS-101 | 2024-01-01T07:15:00 | 2024-01-01T07:45:00 | Grand Central | Times Sq | 6.7 | 12.2 | GHG Protocol | OFF-1001 | GreenFuture | PRJ-WIND-14 | 13 | 2024-01-02 | CERT-1001-2024 | EcoCert | validated | 2024-01-10 | ESG-NYC-2024-Q1 | Full offset for peak hour trip. | 2024-01-02T09:31:00 | 2024-01-12T14:02:00 | https://reports.ecocert.com/2024/1001 |
| 0a6f1c7e-1d2c-4453-8e8f-1e2a4c5c6b21 | Reforestation Y | 27 | OP-NYC-001 | T20240101002 | R-7B | V-BUS-105 | 2024-01-01T08:01:00 | 2024-01-01T08:40:00 | Central Park S | Harlem W | 9.2 | 14.8 | ISO 14064 | OFF-1002 | EarthBalance | PRJ-FOREST-28 | 15.5 | 2024-01-02 | CERT-1002-2024 | GlobalCarbonTrust | pending | blank | ESG-NYC-2024-Q1 | Awaiting validation report. | 2024-01-02T10:40:00 | 2024-01-02T10:40:00 | blank |
| 4b9d2f8a-3c7e-4901-b6d2-2e3a5c6d7e41 | Solar Array Z | 18 | OP-NYC-002 | T20240101003 | R-8A | V-TRAM-204 | 2024-01-01T09:03:00 | 2024-01-01T09:27:00 | Flushing | Astoria | 4.3 | 9.1 | GHG Protocol | OFF-1003 | GreenFuture | PRJ-SOLAR-17 | 9.8 | 2024-01-03 | CERT-1003-2024 | EcoCert | validated | 2024-01-13 | ESG-NYC-2024-Q1 | Low emission tram route. | 2024-01-03T08:18:00 | 2024-01-13T15:05:00 | https://reports.ecocert.com/2024/1003 |
| e6c3f0a2-3b2d-4f6b-8c1e-4e2a6c7d8e51 | Hydro Plant Q | 25 | OP-NYC-002 | T20240101004 | R-8B | V-TRAM-207 | 2024-01-01T10:45:00 | 2024-01-01T11:18:00 | Jamaica | Queens Plaza | 7.8 | 13.7 | ISO 14064 | OFF-1004 | EarthBalance | PRJ-HYDRO-33 | 14 | 2024-01-03 | CERT-1004-2024 | GlobalCarbonTrust | validated | 2024-01-13 | ESG-NYC-2024-Q1 | blank | 2024-01-03T11:20:00 | 2024-01-13T15:05:00 | https://reports.globalcarbontrust.org/2024/1004 |
| bb5f3e7a-6d4c-449d-9b82-6e8a7c1d2b61 | Wind Farm X | 40 | OP-NYC-003 | T20240101005 | R-9A | V-TRAM-210 | 2024-01-01T11:55:00 | 2024-01-01T12:23:00 | Brooklyn Bridge | Coney Island | 12.9 | 23.2 | GHG Protocol | OFF-1005 | GreenFuture | PRJ-WIND-14 | 24 | 2024-01-04 | CERT-1005-2024 | EcoCert | pending | blank | ESG-NYC-2024-Q1 | High load trip. | 2024-01-04T09:10:00 | 2024-01-04T09:10:00 | blank |
| d8e6c3a2-1b4d-4c8b-8e1a-2e8a4c7d9e71 | Reforestation Y | 21 | OP-NYC-003 | T20240101006 | R-9B | V-BUS-113 | 2024-01-01T13:00:00 | 2024-01-01T13:46:00 | Williamsburg | Bushwick | 8.6 | 15.3 | ISO 14064 | OFF-1006 | EarthBalance | PRJ-FOREST-28 | 16.1 | 2024-01-05 | CERT-1006-2024 | GlobalCarbonTrust | rejected | 2024-01-15 | ESG-NYC-2024-Q1 | Offset documentation incomplete. | 2024-01-05T10:11:00 | 2024-01-15T14:55:00 | https://reports.globalcarbontrust.org/2024/1006 |
| 1b6e2a9c-4d3f-4e7b-9a12-3e2a4b6c8e81 | Solar Array Z | 17 | OP-NYC-004 | T20240101007 | R-10A | V-BUS-117 | 2024-01-01T14:15:00 | 2024-01-01T14:45:00 | Fulton St | Bedford Ave | 5.1 | 8.4 | GHG Protocol | OFF-1007 | GreenFuture | PRJ-SOLAR-17 | 8.5 | 2024-01-06 | CERT-1007-2024 | EcoCert | validated | 2024-01-16 | ESG-NYC-2024-Q1 | blank | 2024-01-06T09:23:00 | 2024-01-16T15:07:00 | https://reports.ecocert.com/2024/1007 |
| fa4b7e1d-3c2e-4a1b-8d8f-2a6c7e8a9f91 | Hydro Plant Q | 12 | OP-NYC-004 | T20240101008 | R-10B | V-BUS-119 | 2024-01-01T15:10:00 | 2024-01-01T15:34:00 | Atlantic Ave | Flatbush | 3.9 | 7.7 | ISO 14064 | OFF-1008 | EarthBalance | PRJ-HYDRO-33 | 8 | 2024-01-06 | CERT-1008-2024 | GlobalCarbonTrust | pending | blank | ESG-NYC-2024-Q1 | Low passenger count. | 2024-01-06T11:30:00 | 2024-01-06T11:30:00 | blank |
| eb7c2d6a-2b4d-4e8b-9c1e-3e1a2c5d7e01 | Wind Farm X | 30 | OP-LA-001 | T20240101009 | R-5A | V-BUS-201 | 2024-02-01T07:23:00 | 2024-02-01T07:54:00 | Union Station | Hollywood Blvd | 7.2 | 12.6 | GHG Protocol | OFF-1009 | GreenFuture | PRJ-WIND-14 | 13.2 | 2024-02-02 | CERT-1009-2024 | EcoCert | validated | 2024-02-10 | ESG-LA-2024-Q1 | blank | 2024-02-02T09:31:00 | 2024-02-12T14:02:00 | https://reports.ecocert.com/2024/1009 |
| a6e3b2c1-1d4c-4a9b-9e8a-4e2a5c6d8e11 | Reforestation Y | 35 | OP-LA-001 | T20240101010 | R-5B | V-BUS-203 | 2024-02-01T08:00:00 | 2024-02-01T08:45:00 | Santa Monica | Venice Beach | 10.1 | 17.3 | ISO 14064 | OFF-1010 | EarthBalance | PRJ-FOREST-28 | 18 | 2024-02-02 | CERT-1010-2024 | GlobalCarbonTrust | pending | blank | ESG-LA-2024-Q1 | Tourist route. | 2024-02-02T10:45:00 | 2024-02-02T10:45:00 | blank |
| 2f6e7a9c-3b2e-4d1b-8c1f-2a4c6e7a9b21 | Solar Array Z | 28 | OP-LA-002 | T20240101011 | R-6A | V-TRAM-305 | 2024-02-01T09:10:00 | 2024-02-01T09:37:00 | Long Beach | Compton | 8.7 | 16.2 | GHG Protocol | OFF-1011 | GreenFuture | PRJ-SOLAR-17 | 16.5 | 2024-02-03 | CERT-1011-2024 | EcoCert | validated | 2024-02-13 | ESG-LA-2024-Q1 | blank | 2024-02-03T08:18:00 | 2024-02-13T15:05:00 | https://reports.ecocert.com/2024/1011 |
| fb3d7c1e-4a2b-4e8d-9c1e-3e7a2c5d8e31 | Hydro Plant Q | 19 | OP-LA-002 | T20240101012 | R-6B | V-TRAM-307 | 2024-02-01T10:45:00 | 2024-02-01T11:19:00 | Norwalk | South Gate | 6.5 | 11.4 | ISO 14064 | OFF-1012 | EarthBalance | PRJ-HYDRO-33 | 12 | 2024-02-03 | CERT-1012-2024 | GlobalCarbonTrust | validated | 2024-02-13 | ESG-LA-2024-Q1 | blank | 2024-02-03T12:21:00 | 2024-02-13T15:05:00 | https://reports.globalcarbontrust.org/2024/1012 |
| d1c3a7e9-2b4d-4e8a-9c1e-3e1a2c5d8e41 | Wind Farm X | 41 | OP-LA-003 | T20240101013 | R-7A | V-TRAM-310 | 2024-02-01T11:55:00 | 2024-02-01T12:23:00 | El Monte | Pasadena | 13.1 | 25.1 | GHG Protocol | OFF-1013 | GreenFuture | PRJ-WIND-14 | 26 | 2024-02-04 | CERT-1013-2024 | EcoCert | pending | blank | ESG-LA-2024-Q1 | High ridership. | 2024-02-04T09:10:00 | 2024-02-04T09:10:00 | blank |
| e2d6c3a4-1b4d-4c8b-8e1a-2e8a4c7d9e51 | Reforestation Y | 20 | OP-LA-003 | T20240101014 | R-7B | V-BUS-213 | 2024-02-01T13:00:00 | 2024-02-01T13:46:00 | Burbank | Glendale | 9.1 | 15.1 | ISO 14064 | OFF-1014 | EarthBalance | PRJ-FOREST-28 | 15.7 | 2024-02-05 | CERT-1014-2024 | GlobalCarbonTrust | rejected | 2024-02-15 | ESG-LA-2024-Q1 | Rejected due to missing validator file. | 2024-02-05T10:11:00 | 2024-02-15T14:55:00 | https://reports.globalcarbontrust.org/2024/1014 |
| 1c7e2a9b-4d3f-4e7b-9a12-3e2a4b6c8e61 | Solar Array Z | 16 | OP-LA-004 | T20240101015 | R-8A | V-BUS-217 | 2024-02-01T14:15:00 | 2024-02-01T14:45:00 | Downtown LA | Koreatown | 5.9 | 9.1 | GHG Protocol | OFF-1015 | GreenFuture | PRJ-SOLAR-17 | 9.2 | 2024-02-06 | CERT-1015-2024 | EcoCert | validated | 2024-02-16 | ESG-LA-2024-Q1 | blank | 2024-02-06T09:23:00 | 2024-02-16T15:07:00 | https://reports.ecocert.com/2024/1015 |
| f4b7e1d3-3c2e-4a1b-8d8f-2a6c7e8a9f81 | Hydro Plant Q | 13 | OP-LA-004 | T20240101016 | R-8B | V-BUS-219 | 2024-02-01T15:10:00 | 2024-02-01T15:34:00 | Silver Lake | Echo Park | 4.1 | 7.9 | ISO 14064 | OFF-1016 | EarthBalance | PRJ-HYDRO-33 | 8.1 | 2024-02-06 | CERT-1016-2024 | GlobalCarbonTrust | pending | blank | ESG-LA-2024-Q1 | blank | 2024-02-06T11:30:00 | 2024-02-06T11:30:00 | blank |
| ec7c2d6a-2b4d-4e8b-9c1e-3e1a2c5d7e21 | Wind Farm X | 33 | OP-CHI-001 | T20240101017 | R-12A | V-BUS-301 | 2024-03-01T07:23:00 | 2024-03-01T07:54:00 | Ogilvie | Midway | 7.5 | 13 | GHG Protocol | OFF-1017 | GreenFuture | PRJ-WIND-14 | 13.3 | 2024-03-02 | CERT-1017-2024 | EcoCert | validated | 2024-03-10 | ESG-CHI-2024-Q1 | blank | 2024-03-02T09:31:00 | 2024-03-12T14:02:00 | https://reports.ecocert.com/2024/1017 |
| b6e3a2c1-2d4c-4a9b-9e8a-4e2a5c6d8e21 | Reforestation Y | 37 | OP-CHI-001 | T20240101018 | R-12B | V-BUS-303 | 2024-03-01T08:00:00 | 2024-03-01T08:45:00 | Millennium Park | Hyde Park | 10.4 | 17.8 | ISO 14064 | OFF-1018 | EarthBalance | PRJ-FOREST-28 | 18.2 | 2024-03-02 | CERT-1018-2024 | GlobalCarbonTrust | pending | blank | ESG-CHI-2024-Q1 | Special event shuttle. | 2024-03-02T10:45:00 | 2024-03-02T10:45:00 | blank |
| 2e6e7a9c-3b2e-4d1b-8c1f-2a4c6e7a9b31 | Solar Array Z | 26 | OP-CHI-002 | T20240101019 | R-13A | V-TRAM-405 | 2024-03-01T09:10:00 | 2024-03-01T09:37:00 | Logan Square | Wicker Park | 8.8 | 16.8 | GHG Protocol | OFF-1019 | GreenFuture | PRJ-SOLAR-17 | 17 | 2024-03-03 | CERT-1019-2024 | EcoCert | validated | 2024-03-13 | ESG-CHI-2024-Q1 | blank | 2024-03-03T08:18:00 | 2024-03-13T15:05:00 | https://reports.ecocert.com/2024/1019 |
| fb3d7c1e-4a2b-4e8d-9c1e-3e7a2c5d8e41 | Hydro Plant Q | 21 | OP-CHI-002 | T20240101020 | R-13B | V-TRAM-407 | 2024-03-01T10:45:00 | 2024-03-01T11:19:00 | Lincoln Park | Old Town | 6.3 | 12.2 | ISO 14064 | OFF-1020 | EarthBalance | PRJ-HYDRO-33 | 12.5 | 2024-03-03 | CERT-1020-2024 | GlobalCarbonTrust | validated | 2024-03-13 | ESG-CHI-2024-Q1 | blank | 2024-03-03T12:21:00 | 2024-03-13T15:05:00 | https://reports.globalcarbontrust.org/2024/1020 |
What the 48 rows show
from the 48-row sampleWind Farm X (offset project name) stands out: mean passenger_
- 25median passenger_
count - 2emission estimate methods
- 2offset providers
- 2third party validators
- 3validation statuses
- 4offset projects
Median 25, from 11 to 44.
- string 18
- integer 1
- float 3
- date 2
- datetime 4
Columns
28 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 18 columns | |||
log_id | string | Unique identifier for each carbon offset validation log entry.unique | c7f8a2b1-12e4-4e8a-9a72-1… |
trip_id | string | Unique identifier for the transit trip associated with this offset. | T20240101001 |
transit_operator_id | string | Unique identifier for the public transit operator. | OP-NYC-001 |
route_id | string | Identifier for the transit route taken during the trip.optional | R-7A |
vehicle_id | string | Identifier for the vehicle used in the trip.optional | V-BUS-101 |
origin_station | string | Name or code of the trip's origin station or stop.optional | Grand Central |
destination_station | string | Name or code of the trip's destination station or stop.optional | Times Sq |
emission_estimate_method | string | Methodology or standard used for emission estimation (e.g., GHG Protocol, ISO 14064).2 methods · optional | GHG Protocol |
offset_purchase_id | string | Identifier for the carbon offset purchase transaction. | OFF-1001 |
offset_provider | string | Name of the organization providing the carbon offset.2 providers | GreenFuture |
offset_project_name | string | Name of the offset project (e.g., 'Wind Farm X', 'Reforestation Y').4 names · optional | Wind Farm X |
offset_project_id | string | Unique identifier for the offset project.4 projects · optional | PRJ-WIND-14 |
offset_certificate_id | string | Certificate or serial number of the offset for traceability.optional | CERT-1001-2024 |
third_party_validator | string | Name of the third-party organization that validated the offset.2 validators · optional | EcoCert |
validation_status | string | Status of third-party validation (e.g., 'pending', 'validated', 'rejected').pending · validated · rejected | validated |
validator_report_url | string | URL to the third-party validation report or documentation.optional | https://reports.ecocert.c… |
esg_report_reference | string | Reference code or URL to the ESG report where this offset is claimed.6 references · optional | ESG-NYC-2024-Q1 |
notes | string | Additional notes or comments regarding the log entry.optional | Low emission tram route. |
| Numbers 4 columns | |||
distance_km | float | Distance covered during the trip, in kilometers.0 or more · optional | 6.7 |
passenger_count | integer | Number of passengers on the trip.0 or more · optional | 32 |
emission_estimate_kgco2e | float | Estimated greenhouse gas emissions for the trip, in kilograms CO2 equivalent.0 or more | 12.2 |
offset_amount_kgco2e | float | Amount of emissions offset, in kilograms CO2 equivalent.0 or more | 13 |
| Dates and times 6 columns | |||
trip_start_datetime | datetime | Date and time when the trip started. | 2024-01-01T07:15:00 |
trip_end_datetime | datetime | Date and time when the trip ended. | 2024-01-01T07:45:00 |
offset_purchase_date | date | Date when the carbon offset was purchased. | 2024-01-02 |
validation_date | date | Date when third-party validation was completed.optional | 2024-01-10 |
created_at | datetime | Timestamp when the log entry was created. | 2024-01-02T09:31:00 |
updated_at | datetime | Timestamp when the log entry was last updated. | 2024-01-12T14:02:00 |
Use it for
A transportation dashboard
Passenger_
count by offset_ project_ name and a breakdown of transit_ operator_ id. Excel, Power BI or Tableau. Why do the 12 Wind Farm X rows have a mean passenger_
count of 36.0? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs48c7f8a2b1-12e4-4e8a-9a72-1a5c1d2d8a3132Wind Far…0a6f1c7e-1d2c-4453-8e8f-1e2a4c5c6b2127Reforest…4b9d2f8a-3c7e-4901-b6d2-2e3a5c6d7e4118Solar Ar…
A software demo
Believable logs with trip_
id, transit_ operator_ id and route_ id to fill a screen in front of a buyer.
This dataset48 rows28 columns
Yours10,000 rows28 columns
blueprint · transit-carbon-offset-validation-log
Behind this dataset
Same schema. As many rows as you need.
These 48 rows came out of a blueprint — 28 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 transit route trip and its carbon emission estimate.
- Offset purchases must be matched with valid certificate IDs from verified offset providers.
- Third-party validation status must be recorded (Pending, Validated, or Rejected).
- Emission calculations must follow standardized methodologies (e.g., GHG Protocol).
- Only include trips with completed offset transactions.
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
- transit-carbon-offset-validation-log