Smart Government ESG Compliance Log

This dataset provides detailed, event-level tracking of government department compliance activities related to ESG initiatives, including activity types, resource allocation, responsible personnel, and compliance status. It is designed for smart city planners and public sector managers to monitor regulatory performance, identify bottlenecks, and optimize sustainability efforts. The flat structure supports robust analytics, reporting, and digital transformation benchmarking.

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

Monitoring and reporting ESG compliance across government departments

Sample rows

preview · 8 of 140 rows · all 23 columns
event_idstringactivity_typestringresource_allocated_amountfloataction_requiredbooleanlocation_statestringdepartment_idstringdepartment_namestringevent_datetimedatetimeesg_categorystringregulation_referencestringcompliance_statusstringaction_deadlinedateresponsible_person_idstringresponsible_person_namestringlocation_street_addressstringlocation_citystringlocation_postal_codestringlocation_countrystringresource_typestringdigital_transformation_flagbooleanbest_practice_flagbooleanactivity_descriptionstringnotesstring
EVT-ENV-0001Audit9500falseTXDEP-ENV-001Department of Environmental Affairs2022-04-12T09:21:00EnvironmentalEPA-2022-HWD-04CompliantblankPER-1001Linda Hayes1240 Main StAustin73301USABudgetfalsetrueAnnual audit of hazardous waste disposal procedures at the main facility.Routine audit completed with exemplary compliance noted throughout.
EVT-GOV-0002Remediation18000trueCADEP-JUST-002Justice Regulatory Board2023-01-17T14:58:00GovernanceGOV-2023-RET-17Non-Compliant2023-02-20PER-1002James Lin410 Justice BlvdSacramento94203USAPersonnelfalsefalseAddressing findings from previous audit regarding document retention policy.Remediation required for regulatory breach; urgent action in progress.
EVT-SOC-0003Training65falseCODEP-HUM-003Ministry of Human Services2024-03-08T10:12:00SocialSOC-2024-HAR-03In ProgressblankPER-1003Maria Chen900 Lincoln AveDenver80203USATechnologytruefalseDigital module rollout for harassment prevention training.Training in progress using new digital modules; in-person sessions pending.
EVT-ENV-0004Inspection3200falseWADEP-ENV-004Department of Environmental Affairs2022-12-28T15:45:00EnvironmentalEPA-2022-AIR-28CompliantblankPER-1004Sonya Patel598 Oak DrSeattle98101USAEquipmentfalsefalseFacility inspection for compliance with air quality standards.Inspection passed with no issues identified.
EVT-GOV-0005Reporting12000falseAZDEP-JUST-005Justice Regulatory Board2023-07-15T13:10:00GovernanceGOV-2023-WBP-15PendingblankPER-1005Alexei Novak1221 Justice BlvdPhoenix85003USABudgettruefalseQuarterly compliance report submission for whistleblower protection.Quarterly reporting completed, awaiting regulatory review.
EVT-ENV-0006Remediation7600trueOHDEP-ENV-006Department of Environmental Affairs2023-05-19T11:30:00EnvironmentalEPA-2023-CHEM-19Pending2023-06-30PER-1006Brandon Lee1555 River RdCleveland44114USAEquipmentfalsefalseRemediation of minor chemical spill reported during site audit.Remediation plan in place; action required for full compliance.
EVT-SOC-0007Policy Update0.1falseTXDEP-HUM-007Ministry of Human Services2022-09-03T09:00:00SocialSOC-2022-DIV-03Compliantblankblankblank800 Civic CenterDallas75201USAPersonneltruetrueUpdated internal policy to reflect new diversity and inclusion standards.Policy update recognized as a best practice for inclusivity.
EVT-ENV-0008Inspection560falseFLDEP-ENV-008Department of Environmental Affairs2024-02-11T16:05:00EnvironmentalEPA-2024-WTR-11CompliantblankPER-1007Shirley Black4507 Waterway DrMiami33101USAEquipmentfalsefalseRandom inspection of water treatment facility for compliance.Inspection successful with minor recommendations for improvement.

What the 140 rows show

from the 140-row sample

Remediation (activity type) stands out: 23 of its 23 rows have action_required = true, against 15 of 117 for the rest.

  • 27%action_required = true
  • 750.0median resource_allocated_amount
  • 3esg categories
  • 5compliance statuses
  • 5resource types
  • 11location countries
Action required rate by activity_typeaction_required = true
0%50%100%7%Audit2 of …9%Repo…3 of …31%Trai…4 of …100%Reme…23 of…10%Insp…2 of …27%Poli…4 of …0%Other0 of 8
resource_allocated_amount140 rows, in bands of 250k
07014013700000000301.3M2.5Mresource_allocated_amount →

Median 750.0, from 0.0 to 2,500,000.

location_state131 rows with a value · 9 left blank
  1. CA13
  2. ON10
  3. TX9
  4. VIC7
  5. TK7
  6. BE6
  7. NY6
  8. GA6
  9. CO5
  10. WA5
23 columns by typefrom the column list below
  • string 17
  • float 1
  • date 1
  • datetime 1
  • boolean 3

Columns

23 columns in four groups
blueprint · 23 columns
columntypedescriptionexample
Text 17 columns
event_idstringUnique identifier for each compliance eventuniqueEVT-ENV-0001
department_idstringUnique identifier for the government department involvedDEP-ENV-001
department_namestringName of the government departmentJustice Regulatory Board
esg_categorystringESG category relevant to the event (Environmental, Social, Governance)Environmental · Social · GovernanceEnvironmental
activity_typestringType of compliance activity (e.g., audit, reporting, training, remediation)7 valuesAudit
activity_descriptionstringDetailed description of the compliance activityoptionalAnnual audit of hazardous…
regulation_referencestringReference code or name of the relevant regulation or standardEPA-2022-HWD-04
compliance_statusstringStatus of compliance for the event (e.g., compliant, non-compliant, pending)5 valuesCompliant
responsible_person_idstringUnique identifier for the person responsible for this compliance eventoptionalPER-1001
responsible_person_namestringName of the person responsible for this compliance eventoptionalLinda Hayes
location_street_addressstringStreet address where the event took placeoptional1240 Main St
location_citystringCity where the event took placeoptionalAustin
location_statestringState or province where the event took placeoptionalTX
location_postal_codestringPostal code for the event locationoptional73301
location_countrystringCountry where the event took place11 countries · optionalUSA
resource_typestringType of resource allocated (e.g., budget, personnel, equipment)Budget · Personnel · Equipment · Technology · Other · optionalBudget
notesstringAdditional notes or comments about the eventoptionalRoutine audit completed w…
Numbers 1 column
resource_allocated_amountfloatAmount of resources (e.g., budget, hours) allocated for the compliance activity0 or more · optional9500
Dates and times 2 columns
event_datetimedatetimeDate and time when the compliance event occurred2022-04-12T09:21:00
action_deadlinedateDeadline for required action, if applicableoptional2023-02-20
True or false 3 columns
action_requiredbooleanIndicates if further action is required for this eventfalse
digital_transformation_flagbooleanIndicates if the event involved digital transformation initiativesoptionalfalse
best_practice_flagbooleanIndicates if the event is considered a best practice exampleoptionaltrue

Use it for

  • action required27%38 of 140 rowsmean resource allocat…9.2kAudit82.8kRepo…100.2Trai…245kReme…

    A government dashboard

    The action_required rate, resource_allocated_amount by activity_type and a breakdown of location_state. Excel, Power BI or Tableau.

  • Why do 38 of 140 rows have action_required = true?

    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 events with department_id, department_name and event_datetime to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 23 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 dataset140 rows23 columns
Yours1,000 rows23 columnslocation_street_address: UK only

blueprint · smart-government-esg-compliance-log

Behind this dataset

Same schema. As many rows as you need.

These 140 rows came out of a blueprint — 23 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 compliance event
  • Include department ID, event type, ESG category, timestamp, outcome status
  • Flag events with non-compliance for escalation
  • Attach responsible team and follow-up action required
  • Events missing outcome status must be reviewed weekly
  • Track digital enablement (manual vs. automated process)
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
smart-government-esg-compliance-log

What should your data show?

Preview 20 rows free
No signup. No card.