Municipal Procurement Carbon Impact Log
This dataset provides detailed records of municipal procurement activities, including associated greenhouse gas emissions, vendor and supply chain information, contract details, and ESG compliance flags. It enables city planners and sustainability officers to benchmark procurement-related emissions, identify high-impact vendors, and support climate action reporting and operational improvements.
Sample rows
preview · 8 of 95 rows · all 25 columns| procurement_idstring | procurement_typestring | emission_amount_tonnesfloat | esg_compliance_flagboolean | location_countrystring | municipality_namestring | departmentstring | vendor_idstring | vendor_namestring | vendor_sectorstring | contract_valuefloat | contract_start_datedate | contract_end_datedate | emission_scopestring | emission_typestring | emission_reporting_yearinteger | supply_chain_partner_idstring | supply_chain_partner_namestring | location_street_addressstring | location_citystring | location_statestring | location_postal_codestring | benchmarking_referencestring | data_sourcestring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PR20240001 | infrastructure | 156.24 | true | USA | Springfield | Public Works | VEND1001 | GreenBuild Solutions | construction | 1250000.5 | 2023-04-01 | 2023-11-30 | Scope 1 | CO2 | 2023 | SCP3001 | EcoTransport Inc | 852 Lincoln Ave | Springfield | Illinois | 62704 | GHG Protocol | third-party audit | Scope 1 emissions from construction vehicles |
| PR20240002 | goods | 2.93 | false | USA | Riverview | Transportation | VEND1023 | Mobility Supplies LLC | logistics | 17800 | 2022-07-15 | 2022-12-15 | Scope 3 | N2O | 2022 | blank | blank | 620 Main St | Riverview | Missouri | 63055 | ISO 14064 | vendor self-report | Delivery emissions not fully offset |
| PR20240003 | IT | 25.81 | true | USA | Cedar Grove | IT | VEND1008 | TechnoSys | IT | 320000.75 | 2021-10-01 | 2022-03-31 | Scope 2 | CO2 | 2022 | SCP3014 | SecureNet Hosting | 400 Digital Dr | Cedar Grove | Ohio | 45223 | GHG Protocol | municipal estimate | Server emissions calculated |
| PR20240004 | services | 1.21 | true | USA | Lakeside | Health | VEND1015 | CleanCare Facilities | services | 59000 | 2024-01-08 | 2024-12-31 | Scope 3 | CH4 | 2024 | blank | blank | 78 Wellness Way | Lakeside | Minnesota | 55044 | GHG Protocol | third-party audit | CH4 from waste decomposition |
| PR20240005 | goods | 3.11 | false | USA | Eastville | Public Safety | VEND1020 | SecureGear Ltd | logistics | 48500.25 | 2023-06-01 | 2023-09-01 | Scope 2 | CO2 | 2023 | blank | blank | 2101 Safety Pl | Eastville | Georgia | 30303 | ISO 14064 | vendor self-report | Scope 2 from warehouse electricity |
| PR20240006 | services | 6.37 | true | USA | Brookfield | Sanitation | VEND1012 | WasteAway Inc | logistics | 132000 | 2022-02-01 | 2023-01-31 | Scope 1 | CH4 | 2023 | SCP3008 | GreenFleet Partners | 990 Elm St | Brookfield | Connecticut | 06804 | GHG Protocol | municipal estimate | Waste transport emissions |
| PR20240007 | goods | 1.08 | true | USA | Westford | Education | VEND1016 | EduSupply Co | services | 22000 | 2021-08-10 | 2021-09-20 | Scope 3 | CO2 | 2021 | blank | blank | 340 Learning Ln | Westford | Massachusetts | 01886 | GHG Protocol | municipal estimate | Paper and supplies emissions |
| PR20240008 | infrastructure | 201.65 | true | USA | Hillcrest | Transportation | VEND1013 | TransitWorks | construction | 2200000 | 2023-05-01 | 2024-05-01 | Scope 1 | CO2 | 2024 | SCP3007 | Steelwise Ltd | 16 Rail Rd | Hillcrest | Texas | 77081 | ISO 14064 | third-party audit | Steel and diesel emissions |
| PR20240009 | IT | 0.36 | true | USA | Mapleton | IT | VEND1009 | DigitalFirst | IT | 157500 | 2023-02-15 | 2023-06-30 | Scope 2 | N2O | 2023 | blank | blank | 5 Silicon Blvd | Mapleton | California | 90210 | GHG Protocol | vendor self-report | Data center N2O emissions |
| PR20240010 | goods | 7.52 | false | USA | Riverdale | Public Works | VEND1022 | UrbanMaterials | construction | 135000 | 2022-03-01 | 2022-09-01 | Scope 3 | CH4 | 2022 | SCP3010 | BulkLogistics | 98 Timber St | Riverdale | Florida | 32099 | ISO 14064 | third-party audit | CH4 from material processing |
| PR20240011 | services | 20.12 | true | USA | Northport | Sanitation | VEND1012 | WasteAway Inc | logistics | 118500 | 2022-09-01 | 2023-08-31 | Scope 1 | CO2 | 2023 | SCP3008 | GreenFleet Partners | 432 Oak Ave | Northport | Alabama | 35476 | GHG Protocol | municipal estimate | Diesel truck emissions |
| PR20240012 | other | 1.98 | true | USA | Evergreen | Public Safety | VEND1018 | SafeTech Group | IT | 43000 | 2023-08-05 | 2024-02-28 | Scope 2 | Other | 2023 | blank | blank | 120 Safety Dr | Evergreen | Washington | 98004 | ISO 14064 | vendor self-report | Minor F-gas emissions |
| PR20240013 | goods | 3.55 | true | USA | Redwood | Health | VEND1011 | BioSupply | services | 72000 | 2022-05-20 | 2023-05-19 | Scope 3 | CO2 | 2023 | blank | blank | 204 Health St | Redwood | California | 94061 | GHG Protocol | municipal estimate | CO2 from packaging |
| PR20240014 | infrastructure | 142.19 | false | USA | Brookfield | Transportation | VEND1013 | TransitWorks | construction | 1750000 | 2021-05-01 | 2022-05-01 | Scope 1 | CO2 | 2022 | SCP3007 | Steelwise Ltd | 1 Transit Blvd | Brookfield | Connecticut | 06804 | GHG Protocol | third-party audit | Scope 1 from machinery emissions |
| PR20240015 | services | 0.97 | true | USA | Cedar Grove | Public Works | VEND1014 | EcoCleaners | services | 54500 | 2023-03-01 | 2023-12-31 | Scope 3 | N2O | 2023 | SCP3011 | FreshLogix | 100 Green St | Cedar Grove | Ohio | 45223 | ISO 14064 | municipal estimate | N2O from cleaning chemicals |
| PR20240016 | IT | 24.03 | true | USA | Springfield | IT | VEND1008 | TechnoSys | IT | 289000 | 2022-06-01 | 2022-12-01 | Scope 2 | CO2 | 2022 | SCP3014 | SecureNet Hosting | 400 Digital Dr | Springfield | Illinois | 62704 | GHG Protocol | third-party audit | Data center CO2 emissions |
| PR20240017 | other | 2.13 | false | USA | Riverview | Public Safety | VEND1018 | SafeTech Group | IT | 51000 | 2023-01-15 | 2023-06-30 | Scope 2 | Other | 2023 | blank | blank | 120 Safety Dr | Riverview | Missouri | 63055 | ISO 14064 | vendor self-report | Other refrigerant losses |
| PR20240018 | services | 5.22 | true | USA | Lakeside | Sanitation | VEND1012 | WasteAway Inc | logistics | 111700 | 2021-02-01 | 2022-01-31 | Scope 1 | CH4 | 2022 | SCP3008 | GreenFleet Partners | 510 Lake Rd | Lakeside | Minnesota | 55044 | GHG Protocol | municipal estimate | CH4 from landfill operations |
| PR20240019 | goods | 0.95 | false | USA | Eastville | Education | VEND1016 | EduSupply Co | services | 18000 | 2023-09-01 | 2023-10-15 | Scope 3 | CO2 | 2023 | blank | blank | 98 Learning Ln | Eastville | Georgia | 30303 | GHG Protocol | municipal estimate | Books and paper emissions |
| PR20240020 | services | 1.15 | true | USA | Westford | Health | VEND1015 | CleanCare Facilities | services | 62000 | 2022-10-01 | 2023-09-30 | Scope 3 | CH4 | 2023 | blank | blank | 12 Wellness Way | Westford | Massachusetts | 01886 | GHG Protocol | third-party audit | CH4 from composting |
What the 95 rows show
from the 95-row sampleInfrastructure (procurement type) stands out: mean emission_
- 80%esg_
compliance_ flag = true - 8.0median emission_
amount_ tonnes - 3emission scopes
- 3benchmarking references
- 3data sources
- 4emission types
Median 8.0, from 0.36 to 241.6.
- string 19
- integer 1
- float 2
- date 2
- boolean 1
Columns
25 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 19 columns | |||
procurement_id | string | Unique identifier for each procurement activity or contractunique | PR20240001 |
municipality_name | string | Name of the city or municipal authority conducting the procurement | Springfield |
department | string | Municipal department responsible for the procurement (e.g., Transportation, Public Works)12 departments | Public Works |
procurement_type | string | Type of procurement (e.g., goods, services, infrastructure, IT)goods · services · infrastructure · IT · other | infrastructure |
vendor_id | string | Unique identifier for the vendor or supplier | VEND1001 |
vendor_name | string | Name of the vendor or supplier | GreenBuild Solutions |
vendor_sector | string | Economic sector of the vendor (e.g., construction, IT, logistics)5 sectors · optional | construction |
emission_scope | string | GHG emission scope according to GHG Protocol (Scope 1, Scope 2, Scope 3)Scope 1 · Scope 2 · Scope 3 | Scope 1 |
emission_type | string | Type of greenhouse gas emission (e.g., CO2, CH4, N2O)CO2 · CH4 · N2O · Other | CO2 |
supply_chain_partner_id | string | Unique identifier for a supply chain partner involved in the procurement (if applicable)optional | SCP3001 |
supply_chain_partner_name | string | Name of the supply chain partner (if applicable)optional | EcoTransport Inc |
location_street_address | string | Street address where the procured goods/services are delivered or usedoptional | 852 Lincoln Ave |
location_city | string | City where the procurement is delivered or usedoptional | Springfield |
location_state | string | State or province of the procurement delivery locationoptional | Illinois |
location_postal_code | string | Postal code of the procurement delivery locationoptional | 62704 |
location_country | string | Country of the procurement delivery locationoptional | USA |
benchmarking_reference | string | Reference to benchmarking standard or dataset used for emission calculation (e.g., GHG Protocol, ISO 14064)3 references · optional | GHG Protocol |
data_source | string | Source of emission data (e.g., vendor self-report, third-party audit, municipal estimate)4 values | third-party audit |
notes | string | Additional notes or comments about the procurement or emission calculationoptional | Diesel truck emissions |
| Numbers 3 columns | |||
contract_value | float | Total monetary value of the procurement contract in local currency0 or more | 1250000.5 |
emission_amount_tonnes | float | Total amount of GHG emissions associated with the procurement, measured in metric tonnes CO2e0 or more | 156.24 |
emission_reporting_year | integer | Year in which the emissions are reported or occurred1,990 to 2,100 | 2023 |
| Dates and times 2 columns | |||
contract_start_date | date | Start date of the procurement contract | 2023-04-01 |
contract_end_date | date | End date of the procurement contractoptional | 2023-11-30 |
| True or false 1 column | |||
esg_compliance_flag | boolean | Indicates if the procurement meets municipal ESG or climate action compliance requirements | true |
Use it for
A government dashboard
The esg_
compliance_ flag rate, emission_ amount_ tonnes by procurement_ type and a breakdown of location_ country. Excel, Power BI or Tableau. Why do the 13 infrastructure rows have a mean emission_
amount_ tonnes of 136.6? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Procurements95PR20240001156.24infrastr…PR202400022.93goodsPR2024000325.81IT
A software demo
Believable procurements with municipality_
name, department and procurement_ type to fill a screen in front of a buyer.
blueprint · municipal-procurement-carbon-impact-log
Behind this dataset
Same schema. As many rows as you need.
These 95 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 row represents a unique procurement event or contract.
- Emission values calculated based on vendor-supplied data and standardized emission factors.
- Procurement types span office supplies, construction, technology, and services.
- Events flagged for high emission intensity trigger an automated compliance review.
- Vendor sustainability certifications are validated annually.
- Contracts over $100k require additional environmental impact disclosure.
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
- municipal-procurement-carbon-impact-log