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.

  • last updated 13 Dec 2025
  • by GoMask
The brief that made it

Benchmarking and reporting of municipal procurement carbon impacts

Sample rows

preview · 8 of 95 rows · all 25 columns
procurement_idstringprocurement_typestringemission_amount_tonnesfloatesg_compliance_flagbooleanlocation_countrystringmunicipality_namestringdepartmentstringvendor_idstringvendor_namestringvendor_sectorstringcontract_valuefloatcontract_start_datedatecontract_end_datedateemission_scopestringemission_typestringemission_reporting_yearintegersupply_chain_partner_idstringsupply_chain_partner_namestringlocation_street_addressstringlocation_citystringlocation_statestringlocation_postal_codestringbenchmarking_referencestringdata_sourcestringnotesstring
PR20240001infrastructure156.24trueUSASpringfieldPublic WorksVEND1001GreenBuild Solutionsconstruction1250000.52023-04-012023-11-30Scope 1CO22023SCP3001EcoTransport Inc852 Lincoln AveSpringfieldIllinois62704GHG Protocolthird-party auditScope 1 emissions from construction vehicles
PR20240002goods2.93falseUSARiverviewTransportationVEND1023Mobility Supplies LLClogistics178002022-07-152022-12-15Scope 3N2O2022blankblank620 Main StRiverviewMissouri63055ISO 14064vendor self-reportDelivery emissions not fully offset
PR20240003IT25.81trueUSACedar GroveITVEND1008TechnoSysIT320000.752021-10-012022-03-31Scope 2CO22022SCP3014SecureNet Hosting400 Digital DrCedar GroveOhio45223GHG Protocolmunicipal estimateServer emissions calculated
PR20240004services1.21trueUSALakesideHealthVEND1015CleanCare Facilitiesservices590002024-01-082024-12-31Scope 3CH42024blankblank78 Wellness WayLakesideMinnesota55044GHG Protocolthird-party auditCH4 from waste decomposition
PR20240005goods3.11falseUSAEastvillePublic SafetyVEND1020SecureGear Ltdlogistics48500.252023-06-012023-09-01Scope 2CO22023blankblank2101 Safety PlEastvilleGeorgia30303ISO 14064vendor self-reportScope 2 from warehouse electricity
PR20240006services6.37trueUSABrookfieldSanitationVEND1012WasteAway Inclogistics1320002022-02-012023-01-31Scope 1CH42023SCP3008GreenFleet Partners990 Elm StBrookfieldConnecticut06804GHG Protocolmunicipal estimateWaste transport emissions
PR20240007goods1.08trueUSAWestfordEducationVEND1016EduSupply Coservices220002021-08-102021-09-20Scope 3CO22021blankblank340 Learning LnWestfordMassachusetts01886GHG Protocolmunicipal estimatePaper and supplies emissions
PR20240008infrastructure201.65trueUSAHillcrestTransportationVEND1013TransitWorksconstruction22000002023-05-012024-05-01Scope 1CO22024SCP3007Steelwise Ltd16 Rail RdHillcrestTexas77081ISO 14064third-party auditSteel and diesel emissions

What the 95 rows show

from the 95-row sample

Infrastructure (procurement type) stands out: mean emission_amount_tonnes is 136.6, against 11.6 for the rest.

  • 80%esg_compliance_flag = true
  • 8.0median emission_amount_tonnes
  • 3emission scopes
  • 3benchmarking references
  • 3data sources
  • 4emission types
Mean emission_amount_tonnes by procurement_type95 rows
010020016.8goods32 rows7.2servic…34 rows136.6infras…13 rows12.1IT13 rows2.0other3 rows
emission_amount_tonnes95 rows, in bands of 25
04080746332122110125250emission_amount_tonnes →

Median 8.0, from 0.36 to 241.6.

location_country95 rows · top 10 of 21 values
  1. USA64
  2. Canada5
  3. UK4
  4. Australia3
  5. Spain2
  6. Switzerland2
  7. Germany1
  8. Norway1
  9. Ireland1
  10. Portugal1
25 columns by typefrom the column list below
  • string 19
  • integer 1
  • float 2
  • date 2
  • boolean 1

Columns

25 columns in four groups
blueprint · 25 columns
columntypedescriptionexample
Text 19 columns
procurement_idstringUnique identifier for each procurement activity or contractuniquePR20240001
municipality_namestringName of the city or municipal authority conducting the procurementSpringfield
departmentstringMunicipal department responsible for the procurement (e.g., Transportation, Public Works)12 departmentsPublic Works
procurement_typestringType of procurement (e.g., goods, services, infrastructure, IT)goods · services · infrastructure · IT · otherinfrastructure
vendor_idstringUnique identifier for the vendor or supplierVEND1001
vendor_namestringName of the vendor or supplierGreenBuild Solutions
vendor_sectorstringEconomic sector of the vendor (e.g., construction, IT, logistics)5 sectors · optionalconstruction
emission_scopestringGHG emission scope according to GHG Protocol (Scope 1, Scope 2, Scope 3)Scope 1 · Scope 2 · Scope 3Scope 1
emission_typestringType of greenhouse gas emission (e.g., CO2, CH4, N2O)CO2 · CH4 · N2O · OtherCO2
supply_chain_partner_idstringUnique identifier for a supply chain partner involved in the procurement (if applicable)optionalSCP3001
supply_chain_partner_namestringName of the supply chain partner (if applicable)optionalEcoTransport Inc
location_street_addressstringStreet address where the procured goods/services are delivered or usedoptional852 Lincoln Ave
location_citystringCity where the procurement is delivered or usedoptionalSpringfield
location_statestringState or province of the procurement delivery locationoptionalIllinois
location_postal_codestringPostal code of the procurement delivery locationoptional62704
location_countrystringCountry of the procurement delivery locationoptionalUSA
benchmarking_referencestringReference to benchmarking standard or dataset used for emission calculation (e.g., GHG Protocol, ISO 14064)3 references · optionalGHG Protocol
data_sourcestringSource of emission data (e.g., vendor self-report, third-party audit, municipal estimate)4 valuesthird-party audit
notesstringAdditional notes or comments about the procurement or emission calculationoptionalDiesel truck emissions
Numbers 3 columns
contract_valuefloatTotal monetary value of the procurement contract in local currency0 or more1250000.5
emission_amount_tonnesfloatTotal amount of GHG emissions associated with the procurement, measured in metric tonnes CO2e0 or more156.24
emission_reporting_yearintegerYear in which the emissions are reported or occurred1,990 to 2,1002023
Dates and times 2 columns
contract_start_datedateStart date of the procurement contract2023-04-01
contract_end_datedateEnd date of the procurement contractoptional2023-11-30
True or false 1 column
esg_compliance_flagbooleanIndicates if the procurement meets municipal ESG or climate action compliance requirementstrue

Use it for

  • esg compliance…80%76 of 95 rowsmean emission amount …16.8goods7.2serv…136.6infr…12.1IT

    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.

  • A software demo

    Believable procurements with municipality_name, department and procurement_type to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 25 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset95 rows25 columns
Yours1,000 rows25 columnslocation_street_address: UK only

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.

Rules it was built with
  • 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.
Rows
Open the blueprint in Data Factory

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

What should your data show?

Preview 20 rows free
No signup. No card.