Ethical Sourcing Impact Logs
This dataset provides detailed, auditable logs of the social and environmental impacts of supplier sourcing decisions in international e-commerce operations. It captures supplier and material details, audit outcomes, labor standard compliance, environmental certifications, and quantitative ESG metrics, enabling robust transparency, benchmarking, and compliance monitoring for sustainability initiatives.
Sample rows
preview · 8 of 65 rows · all 24 columns| impact_log_idstring | audit_resultstring | carbon_footprint_kgco2efloat | labor_standard_complianceboolean | audit_typestring | supplier_idstring | supplier_namestring | supplier_countrystring | material_idstring | material_namestring | material_origin_countrystring | sourcing_decision_datedate | audit_idstring | audit_datedate | labor_standard_detailsstring | environmental_certificationstring | certification_valid_fromdate | certification_valid_todate | esg_scorefloat | social_impact_scorefloat | environmental_impact_scorefloat | notesstring | created_atdatetime | updated_atdatetime |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| IL-00001 | pass | 1280.52 | true | environmental | SUP-001 | EcoSource Ltd. | Germany | MAT-001 | Organic Cotton | India | 2023-01-15 | AUD-1001 | 2023-01-20 | Compliant with EU labor standards | GOTS | 2022-07-01 | 2025-07-01 | 85.4 | 90.3 | 88.7 | Supplier consistently passes audits. | 2023-01-15T10:24:18 | 2023-01-16T12:19:44 |
| IL-00002 | corrective action required | 1710.89 | false | combined | SUP-002 | GreenMakers Inc. | USA | MAT-002 | Recycled Polyester | China | 2023-02-10 | AUD-1002 | 2023-02-16 | Minor wage violation; corrective action underway. | GRS | 2021-05-01 | 2024-05-01 | 68.2 | 62.1 | 74.5 | Recent audit found wage issue. | 2023-02-10T09:00:00 | 2023-02-16T16:21:34 |
| IL-00003 | blank | 1155.3 | true | blank | SUP-003 | FairTrade Textiles | Bangladesh | MAT-003 | Jute Fiber | Bangladesh | 2023-03-05 | blank | blank | No violations reported. | Fair Trade | 2022-10-01 | 2025-10-01 | 79.6 | 81.7 | 80.2 | Strong community engagement. | 2023-03-05T13:30:27 | 2023-03-05T15:10:01 |
| IL-00004 | pending | 1410.8 | true | social | SUP-004 | SustainPro S.A. | Brazil | MAT-004 | Bamboo Rayon | Vietnam | 2023-04-25 | AUD-1003 | 2023-05-01 | Awaiting final audit results. | blank | blank | blank | 73.9 | 75.3 | 69.6 | Audit results pending. | 2023-04-25T08:10:20 | 2023-05-01T17:45:11 |
| IL-00005 | blank | 1303.4 | true | blank | SUP-005 | Renewal Fabrics | Turkey | MAT-005 | Recycled Wool | Italy | 2023-05-19 | blank | blank | Compliant with Turkish labor laws. | OEKO-TEX | 2023-01-01 | 2026-01-01 | 81.2 | 79.1 | 85.6 | blank | 2023-05-19T11:16:00 | 2023-05-20T09:30:17 |
| IL-00006 | pass | 1580.75 | true | environmental | SUP-006 | BlueRiver Trading | South Africa | MAT-006 | Recycled PET Bottles | South Africa | 2023-06-12 | AUD-1004 | 2023-06-19 | No violations detected. | FSC | 2022-08-15 | 2025-08-15 | 78.6 | 76.2 | 81 | Excellent recycling rates. | 2023-06-12T12:22:40 | 2023-06-19T15:29:03 |
| IL-00007 | blank | 1960.12 | false | blank | SUP-007 | ClearPath Goods | Vietnam | MAT-007 | Natural Latex | Thailand | 2023-07-03 | blank | blank | Child labor incident reported; resolved. | blank | blank | blank | 54.6 | 49.3 | 60.1 | Recently resolved labor violation. | 2023-07-03T09:15:27 | 2023-07-04T16:42:11 |
| IL-00008 | pass | 1099.72 | true | social | SUP-008 | Northern Looms | Sweden | MAT-008 | Hemp Fiber | France | 2023-08-18 | AUD-1005 | 2023-08-21 | Strong union presence. | Fair Trade | 2023-02-01 | 2026-02-01 | 92.2 | 96.5 | 94.7 | blank | 2023-08-18T13:47:11 | 2023-08-21T10:31:45 |
| IL-00009 | blank | 1350 | true | blank | SUP-009 | Pacific Textiles | Australia | MAT-009 | Organic Wool | Australia | 2023-09-07 | blank | blank | No compliance issues. | OEKO-TEX | 2022-09-01 | 2025-09-01 | 87.5 | 89.4 | 86.6 | blank | 2023-09-07T08:35:40 | 2023-09-07T18:12:15 |
| IL-00010 | pass | 1525.6 | true | environmental | SUP-010 | Global Fiberworks | China | MAT-010 | Recycled Nylon | Japan | 2023-10-16 | AUD-1006 | 2023-10-21 | Strong management engagement. | GRS | 2021-12-01 | 2024-12-01 | 76 | 79.2 | 80 | Material sourced from Japan. | 2023-10-16T11:14:03 | 2023-10-21T13:26:19 |
| IL-00011 | blank | 1865.33 | false | blank | SUP-011 | EthicalWeave | India | MAT-011 | Linen | Belgium | 2023-11-03 | blank | blank | Unsafe working conditions reported. | blank | blank | blank | 48.9 | 45.6 | 56.2 | Labor standards improvement plan initiated. | 2023-11-03T10:57:34 | 2023-11-04T09:40:12 |
| IL-00012 | pass | 1205.44 | true | combined | SUP-012 | Green Thread LLC | Canada | MAT-012 | Tencel | Austria | 2023-12-01 | AUD-1007 | 2023-12-05 | Compliant, no violations. | FSC | 2023-03-01 | 2026-03-01 | 83.7 | 87.9 | 89.5 | blank | 2023-12-01T15:23:49 | 2023-12-05T18:34:55 |
| IL-00013 | blank | 1040.85 | true | blank | SUP-013 | Harvest Fair | Kenya | MAT-013 | Organic Sisal | Kenya | 2024-01-08 | blank | blank | No violations, supports local farmers. | Fair Trade | 2022-11-01 | 2025-11-01 | 90.8 | 92.3 | 93.6 | blank | 2024-01-08T08:09:00 | 2024-01-09T09:21:45 |
| IL-00014 | fail | 2045.13 | false | other | SUP-014 | PureWeave | Poland | MAT-014 | Organic Flax | Ukraine | 2024-02-19 | AUD-1008 | 2024-02-24 | Several safety violations found. | blank | blank | blank | 37.2 | 39.1 | 52.6 | Supplier placed on probation. | 2024-02-19T14:22:10 | 2024-02-24T13:31:17 |
| IL-00015 | blank | 1115.92 | true | blank | SUP-015 | EarthMakers | Netherlands | MAT-015 | Recycled Paper | Finland | 2024-03-11 | blank | blank | Compliant, no issues. | FSC | 2022-06-01 | 2025-06-01 | 88.5 | 90.1 | 91.7 | blank | 2024-03-11T09:38:22 | 2024-03-12T11:17:35 |
| IL-00016 | corrective action required | 2010.44 | false | social | SUP-016 | Sunrise Fibers | Vietnam | MAT-016 | Ramie Fiber | China | 2024-04-03 | AUD-1009 | 2024-04-10 | Forced overtime reported. | blank | blank | blank | 42.7 | 41.2 | 59.8 | Supplier implementing new policies. | 2024-04-03T10:55:12 | 2024-04-10T16:30:08 |
| IL-00017 | blank | 1278.12 | true | blank | SUP-017 | EcoLoom | Italy | MAT-017 | Alpaca Wool | Peru | 2024-05-27 | blank | blank | Compliant, supports animal welfare. | OEKO-TEX | 2023-01-01 | 2026-01-01 | 86.1 | 86.8 | 85.9 | Animal welfare programs in place. | 2024-05-27T08:21:07 | 2024-05-27T17:12:33 |
| IL-00018 | pass | 1090.57 | true | combined | SUP-018 | GoodRoots | Morocco | MAT-018 | Agave Fiber | Mexico | 2024-06-10 | AUD-1010 | 2024-06-15 | No violations, supports local community. | Fair Trade | 2022-10-01 | 2025-10-01 | 91.4 | 92.9 | 90.8 | Supplier highly rated by community. | 2024-06-10T10:53:25 | 2024-06-15T14:01:45 |
| IL-00019 | blank | 1130.21 | true | blank | SUP-019 | ForestEdge | Finland | MAT-019 | Birch Pulp | Finland | 2024-07-13 | blank | blank | Compliant, supports local forestry. | FSC | 2022-04-01 | 2025-04-01 | 89.9 | 88.6 | 90.4 | blank | 2024-07-13T12:00:00 | 2024-07-13T17:30:11 |
| IL-00020 | pass | 1320.45 | true | environmental | SUP-020 | WestPacific | USA | MAT-020 | Recycled Denim | Mexico | 2024-08-05 | AUD-1011 | 2024-08-10 | Compliant, strong recycling practices. | GRS | 2022-08-01 | 2025-08-01 | 82.7 | 83.2 | 87.8 | blank | 2024-08-05T11:33:42 | 2024-08-10T16:21:19 |
What the 65 rows show
from the 65-row sampleNot applicable (audit result) stands out: mean carbon_
- 85%labor_
standard_ compliance = true - 1,278median carbon_
footprint_ kgco2e - 12environmental certifications
- 81.9median esg_
score - 83.3median social_
impact_ score - 83.6median environmental_
impact_ score
Median 1,278, from 688.1 to 2,218.
- string 13
- float 4
- date 4
- datetime 2
- boolean 1
Columns
24 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
impact_log_id | string | Unique identifier for each impact log entryunique | IL-00001 |
supplier_id | string | Unique identifier for the supplier | SUP-001 |
supplier_name | string | Name of the supplier organization | EcoSource Ltd. |
supplier_country | string | Country where the supplier is based | Germany |
material_id | string | Unique identifier for the sourced material or product | MAT-001 |
material_name | string | Name or description of the sourced material or product | Organic Cotton |
material_origin_country | string | Country of origin for the material or product | India |
audit_id | string | Unique identifier for the supplier audit (if applicable)optional | AUD-1001 |
audit_type | string | Type of audit performed (e.g., social, environmental, combined)social · environmental · combined · other · optional | environmental |
audit_result | string | Result or summary of the audit (e.g., pass, fail, corrective action required)5 values · optional | pass |
labor_standard_details | string | Details on labor standards compliance, including any violations or corrective actionsoptional | No violations reported. |
environmental_certification | string | Name of any environmental certification held by the supplier or material (e.g., FSC, Fair Trade)12 certifications · optional | GOTS |
notes | string | Additional notes or comments regarding the sourcing decision or impact assessmentoptional | Audit results pending. |
| Numbers 4 columns | |||
esg_score | float | Quantitative ESG (Environmental, Social, Governance) score assigned to this sourcing decision or supplier (0-100)0 to 100 · optional | 85.4 |
carbon_footprint_kgco2e | float | Estimated carbon footprint in kilograms of CO2 equivalent for this sourcing decision0 or more · optional | 1280.52 |
social_impact_score | float | Quantitative score for social impact (e.g., labor, community, fair wages) (0-100)0 to 100 · optional | 90.3 |
environmental_impact_score | float | Quantitative score for environmental impact (e.g., resource use, pollution) (0-100)0 to 100 · optional | 88.7 |
| Dates and times 6 columns | |||
sourcing_decision_date | date | Date the sourcing decision was made or recorded | 2023-01-15 |
audit_date | date | Date the supplier audit was conductedoptional | 2023-01-20 |
certification_valid_from | date | Start date of the environmental certification validityoptional | 2022-07-01 |
certification_valid_to | date | End date of the environmental certification validityoptional | 2025-07-01 |
created_at | datetime | Timestamp when this log entry was created | 2023-01-15T10:24:18 |
updated_at | datetime | Timestamp when this log entry was last updated | 2023-01-16T12:19:44 |
| True or false 1 column | |||
labor_standard_compliance | boolean | Indicates if the supplier complies with labor standards | true |
Use it for
A logistics dashboard
The labor_
standard_ compliance rate, carbon_ footprint_ kgco2e by audit_ result and a breakdown of audit_ type. Excel, Power BI or Tableau. Why do the 18 not applicable rows have a mean carbon_
footprint_ kgco2e of 1,056? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Impact logs65IL-000011280.52passIL-000021710.89correcti…IL-000031155.3—
A software demo
Believable impact logs with supplier_
id, supplier_ name and supplier_ country to fill a screen in front of a buyer.
blueprint · ethical-sourcing-impact-logs
Behind this dataset
Same schema. As many rows as you need.
These 65 rows came out of a blueprint — 24 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 record represents a single supplier’s completed sourcing event.
- Include fields for third-party certification status, audit results, and associated product SKUs.
- Score social and environmental impact using standardized scales (e.g., 1–5).
- Capture noncompliance events and remedial actions taken.
- Record supplier country and material source for traceability.
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
- ethical-sourcing-impact-logs