E-commerce Transaction Carbon Impact
This dataset provides detailed, transaction-level estimates of carbon emissions for e-commerce orders, including breakdowns by product, packaging, delivery method, and logistics route. It enables sustainability managers and analysts to track, report, and optimize carbon impact across operations, supporting ESG compliance and strategic decision-making for greener supply chains.
Sample rows
preview · 8 of 120 rows · all 25 columns| transaction_idstring | delivery_methodstring | carbon_breakdown_transport_kgfloat | is_offsetboolean | route_origin_countrystring | transaction_datetimedatetime | customer_idstring | product_idstring | product_categorystring | product_weight_kgfloat | packaging_typestring | packaging_weight_kgfloat | logistics_carrierstring | route_distance_kmfloat | route_origin_citystring | route_origin_statestring | route_destination_citystring | route_destination_statestring | route_destination_countrystring | transport_modestring | estimated_carbon_kgfloat | carbon_breakdown_packaging_kgfloat | carbon_breakdown_last_mile_kgfloat | offset_typestring | esg_reporting_periodstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TXN0001 | express | 96.5 | true | USA | 2024-01-15T11:23:47 | CST1001 | PRD-ELC-1001 | electronics | 2.8 | cardboard box | 0.45 | AirSwift | 4132 | San Jose | CA | London | England | UK | air | 98.2 | 0.45 | 1.25 | reforestation | Q1-2024 |
| TXN0002 | standard | 4.88 | false | USA | 2024-03-02T15:10:02 | CST1002 | PRD-HMG-1002 | home goods | 6.4 | cardboard box | 1.1 | FastShip | 279.7 | Dallas | TX | Houston | TX | USA | truck | 5.67 | 0.32 | 0.47 | none | Q1-2024 |
| TXN0003 | same-day | 0.18 | false | USA | 2024-04-18T13:51:29 | CST1003 | PRD-APP-1003 | apparel | 0.7 | biodegradable | 0.09 | HomeQuick | 12.8 | Seattle | WA | Seattle | WA | USA | electric-vehicle | 0.34 | 0.09 | 0.07 | none | Q2-2024 |
| TXN0004 | pickup | 0 | false | USA | 2024-05-05T16:40:55 | CST1004 | PRD-TOY-1004 | toys | 0.35 | plastic wrap | 0.04 | StoreSelf | 0 | Miami | FL | Miami | FL | USA | bike | 0.02 | 0.02 | 0 | none | Q2-2024 |
| TXN0005 | standard | 0.96 | false | USA | 2024-02-19T09:39:14 | CST1005 | PRD-BOK-1005 | books | 1.2 | biodegradable | 0.18 | KidsExpress | 82.3 | Denver | CO | Colorado Springs | CO | USA | truck | 1.21 | 0.18 | 0.07 | none | Q1-2024 |
| TXN0006 | express | 200.3 | true | Germany | 2024-03-28T10:17:06 | CST1006 | PRD-ELC-1006 | electronics | 3.6 | cardboard box | 0.7 | GlobalExpress | 7008.8 | Hamburg | Hamburg | Cape Town | Western Cape | South Africa | air | 202.8 | 0.7 | 1.8 | renewable-energy | Q1-2024 |
| TXN0007 | standard | 5.65 | false | USA | 2024-04-07T18:32:45 | CST1007 | PRD-HMG-1007 | home goods | 8.9 | cardboard box | 1.35 | SuperPack | 315.6 | Phoenix | AZ | Las Vegas | NV | USA | truck | 6.34 | 0.35 | 0.34 | none | Q2-2024 |
| TXN0008 | pickup | 0 | false | USA | 2024-04-12T09:16:24 | CST1008 | PRD-APP-1008 | apparel | 0.3 | plastic wrap | 0.06 | StoreSelf | 0 | San Diego | CA | San Diego | CA | USA | bike | 0.01 | 0.01 | 0 | none | Q2-2024 |
| TXN0009 | standard | 1.17 | false | USA | 2024-03-22T12:28:11 | CST1009 | PRD-TOY-1009 | toys | 1.5 | cardboard box | 0.23 | KidsExpress | 94 | Cleveland | OH | Columbus | OH | USA | truck | 1.44 | 0.23 | 0.04 | none | Q1-2024 |
| TXN0010 | standard | 1.66 | false | USA | 2024-05-15T20:09:38 | CST1010 | PRD-HMG-1010 | home goods | 2.2 | cardboard box | 0.33 | EcoFleet | 142.2 | Atlanta | GA | Savannah | GA | USA | truck | 2.08 | 0.33 | 0.09 | none | Q2-2024 |
| TXN0011 | express | 210.9 | true | USA | 2024-01-28T08:44:22 | CST1011 | PRD-ELC-1011 | electronics | 5.7 | cardboard box | 1.4 | GlobalExpress | 7232.5 | Chicago | IL | Berlin | Berlin | Germany | air | 213.3 | 1.4 | 1 | reforestation | Q1-2024 |
| TXN0012 | same-day | 0.06 | false | USA | 2024-02-11T13:02:05 | CST1012 | PRD-APP-1012 | apparel | 0.9 | biodegradable | 0.13 | LocalFleet | 7.2 | Portland | OR | Portland | OR | USA | bike | 0.23 | 0.13 | 0.04 | none | Q1-2024 |
| TXN0013 | standard | 4.41 | false | USA | 2024-03-19T17:31:45 | CST1013 | PRD-HMG-1013 | home goods | 4.1 | cardboard box | 0.51 | SuperPack | 410.9 | Austin | TX | Oklahoma City | OK | USA | truck | 5.08 | 0.51 | 0.16 | none | Q1-2024 |
| TXN0014 | same-day | 0.05 | false | USA | 2024-03-10T14:57:33 | CST1014 | PRD-ELC-1014 | electronics | 3.2 | plastic wrap | 0.38 | KidBike | 17.1 | Boston | MA | Boston | MA | USA | electric-vehicle | 0.43 | 0.38 | 0 | none | Q1-2024 |
| TXN0015 | pickup | 0 | false | USA | 2024-04-25T12:19:36 | CST1015 | PRD-BOK-1015 | books | 0.7 | biodegradable | 0.06 | StoreSelf | 0 | Los Angeles | CA | Los Angeles | CA | USA | bike | 0.03 | 0.03 | 0 | none | Q2-2024 |
| TXN0016 | standard | 1.18 | false | USA | 2024-02-26T11:25:41 | CST1016 | PRD-TOY-1016 | toys | 1.6 | plastic wrap | 0.28 | KidsExpress | 123.7 | Detroit | MI | Grand Rapids | MI | USA | truck | 1.6 | 0.28 | 0.14 | none | Q1-2024 |
| TXN0017 | standard | 24.95 | true | Canada | 2024-05-19T10:51:19 | CST1017 | PRD-HMG-1017 | home goods | 11.2 | cardboard box | 1.7 | MegaTransport | 1554.3 | Montreal | Quebec | Toronto | Ontario | Canada | rail | 25.62 | 0.6 | 0.07 | other | Q2-2024 |
| TXN0018 | express | 244.9 | true | Japan | 2024-01-31T15:57:23 | CST1018 | PRD-ELC-1018 | electronics | 9.6 | cardboard box | 2.15 | InternationalAir | 8192 | Tokyo | Tokyo | Sydney | NSW | Australia | air | 248.1 | 2.1 | 1.1 | renewable-energy | Q1-2024 |
| TXN0019 | standard | 2.88 | false | Canada | 2024-03-15T17:13:56 | CST1019 | PRD-HMG-1019 | home goods | 3.7 | cardboard box | 0.42 | EcoFleet | 232.5 | Vancouver | BC | Calgary | Alberta | Canada | truck | 3.43 | 0.42 | 0.13 | none | Q1-2024 |
| TXN0020 | same-day | 0.09 | false | USA | 2024-02-07T13:22:35 | CST1020 | PRD-APP-1020 | apparel | 1.3 | biodegradable | 0.16 | HomeQuick | 15.3 | Orlando | FL | Orlando | FL | USA | electric-vehicle | 0.31 | 0.16 | 0.06 | none | Q1-2024 |
What the 120 rows show
from the 120-row sampleExpress (delivery method) stands out: mean carbon_
- 37%is_
offset = true - 2.5median carbon_
breakdown_ transport_ kg - 3packaging types
- 4offset types
- 5product categories
- 6transport modes
Median 2.5, from 0.0 to 244.9.
- string 16
- float 7
- datetime 1
- boolean 1
Columns
25 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 16 columns | |||
transaction_id | string | Unique identifier for each e-commerce transactionunique | TXN0001 |
customer_id | string | Unique identifier for the customer making the purchase | CST1001 |
product_id | string | Unique identifier for the product purchased | PRD-ELC-1001 |
product_category | string | Category of the product (e.g., electronics, apparel, home goods)5 categories | electronics |
packaging_type | string | Type of packaging used (e.g., cardboard box, plastic wrap, biodegradable)3 types | cardboard box |
delivery_method | string | Method of delivery (e.g., standard, express, same-day, pickup)standard · express · same-day · pickup | express |
logistics_carrier | string | Name of the logistics provider or carrier | AirSwift |
route_origin_city | string | City where the shipment originated | San Jose |
route_origin_state | string | State or region where the shipment originated | CA |
route_origin_country | string | Country where the shipment originated | USA |
route_destination_city | string | City where the shipment was delivered | London |
route_destination_state | string | State or region where the shipment was delivered | England |
route_destination_country | string | Country where the shipment was delivered | UK |
transport_mode | string | Primary mode of transport used (e.g., truck, air, rail, ship)6 values | air |
offset_type | string | Type of offset applied (e.g., reforestation, renewable energy, none)reforestation · renewable-energy · none · other · optional | reforestation |
esg_reporting_period | string | ESG reporting period (e.g., Q1-2024, FY2023) associated with the transaction7 periods · optional | Q1-2024 |
| Numbers 7 columns | |||
product_weight_kg | float | Weight of the product in kilograms0 or more | 2.8 |
packaging_weight_kg | float | Weight of the packaging in kilograms0 or more | 0.45 |
route_distance_km | float | Total distance traveled for delivery in kilometers0 or more | 4132 |
estimated_carbon_kg | float | Estimated total carbon footprint of the transaction in kilograms CO2 equivalent0 or more | 98.2 |
carbon_breakdown_packaging_kg | float | Estimated carbon emissions from packaging in kilograms CO2 equivalent0 or more | 0.45 |
carbon_breakdown_transport_kg | float | Estimated carbon emissions from transport in kilograms CO2 equivalent0 or more | 96.5 |
carbon_breakdown_last_mile_kg | float | Estimated carbon emissions from last-mile delivery in kilograms CO2 equivalent0 or more | 1.25 |
| Dates and times 1 column | |||
transaction_datetime | datetime | Date and time when the transaction occurred | 2024-01-15T11:23:47 |
| True or false 1 column | |||
is_offset | boolean | Indicates whether the carbon footprint of this transaction was offset (e.g., via carbon credits) | true |
Use it for
An e-commerce dashboard
The is_
offset rate, carbon_ breakdown_ transport_ kg by delivery_ method and a breakdown of route_ origin_ country. Excel, Power BI or Tableau. Why do the 18 express rows have a mean carbon_
breakdown_ transport_ kg of 166.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Transactions120TXN000196.5expressTXN00024.88standardTXN0006200.3express
A software demo
Believable transactions with transaction_
datetime, customer_ id and product_ id to fill a screen in front of a buyer.
blueprint · e-commerce-transaction-carbon-impact
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 25 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 transaction includes product category, weight, packaging type, delivery method, logistics distance, and calculated CO2e emissions.
- Packaging types have distinct emission factors applied to overall footprint.
- Delivery methods (bike, van, drone, EV) influence logistics emissions.
- Orders with multiple products aggregate weights and adjust carbon calculation.
- Exclude any basic sales or financial metrics; focus exclusively on carbon-related features.
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
- e-commerce-transaction-carbon-impact