Real Estate ESG Audit Log
This dataset provides a comprehensive log of ESG (Environmental, Social, Governance) compliance events across mid-market real estate portfolios, including detailed event tracking, audit status, benchmarks, and regulatory reporting. It enables property managers and stakeholders to monitor sustainability performance, manage risks proactively, and ensure transparent communication with investors and regulators.
Sample rows
preview · 8 of 85 rows · all 24 columns| audit_log_idstring | audit_statusstring | benchmark_valuefloat | regulatory_reporting_requiredboolean | incident_severitystring | property_idstring | property_namestring | address_streetstring | address_citystring | address_statestring | address_postal_codestring | address_countrystring | event_typestring | event_descriptionstring | event_datetimedatetime | esg_categorystring | benchmark_metricstring | reported_bystring | assigned_tostring | resolution_notesstring | resolution_datedate | regulatory_reportedboolean | regulatory_report_datedate | investor_visibilityboolean |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AL0001 | closed | 74.2 | false | blank | PR101 | Greenwood Plaza | 123 Elm St | Denver | CO | 80203 | USA | benchmark | Annual energy efficiency benchmark reported. | 2024-05-15T10:23:00 | environmental | Energy Use Intensity | J. Maxwell | C. Nguyen | Benchmark reviewed and approved. | 2024-05-20 | blank | blank | true |
| AL0002 | resolved | blank | true | high | PR102 | Riverside Tower | 200 Market Ave | Portland | OR | 97201 | USA | incident | Water leak incident in mechanical room. | 2024-04-24T14:45:00 | environmental | blank | Facilities System | M. Patel | Leak contained, repairs completed. | 2024-04-25 | true | 2024-04-26 | true |
| AL0003 | open | blank | false | blank | PR103 | Willow Commons | 475 Willow Dr | Austin | TX | 78701 | USA | audit | Quarterly ESG audit initiated. | 2024-06-01T09:10:00 | governance | blank | R. Sandoval | A. Lee | blank | blank | blank | blank | false |
| AL0004 | closed | blank | true | blank | PR104 | Lakeside Heights | 980 Lakeview Rd | Minneapolis | MN | 55402 | USA | remediation | Remediation of hazardous material completed. | 2024-03-18T11:30:00 | environmental | blank | B. Jensen | Environmental Team | Material disposed per EPA guidelines. | 2024-03-19 | true | 2024-03-20 | true |
| AL0005 | resolved | blank | false | low | PR105 | Sunset Lofts | 812 Sunset Blvd | Los Angeles | CA | 90046 | USA | incident | Fire alarm false trigger. | 2024-04-12T18:42:00 | social | blank | Security | J. Davis | Alarm system recalibrated. | 2024-04-12 | blank | blank | false |
| AL0006 | resolved | 62.5 | false | blank | PR106 | Highland Center | 321 Highland Ave | Raleigh | NC | 27601 | USA | benchmark | Waste diversion rate benchmark. | 2024-05-10T15:15:00 | environmental | Waste Diversion Rate | Facilities System | Waste Mgmt | Benchmark improved by 5%. | 2024-05-12 | blank | blank | true |
| AL0007 | in_progress | blank | false | blank | PR107 | Central Market Offices | 590 Central St | Chicago | IL | 60603 | USA | audit | Annual governance audit started. | 2024-05-02T10:00:00 | governance | blank | M. Cohen | Audit Team | blank | blank | blank | blank | true |
| AL0008 | closed | blank | false | blank | PR108 | Maple Tech Park | 210 Maple St | Seattle | WA | 98101 | USA | other | Tenant sustainability training held. | 2024-02-28T13:00:00 | social | blank | Tenant Relations | L. Tran | Training completed and documented. | 2024-02-28 | blank | blank | true |
| AL0009 | in_progress | blank | true | medium | PR109 | Rivergate Mall | 110 River Rd | Nashville | TN | 37214 | USA | incident | Slip and fall reported in food court. | 2024-05-23T17:20:00 | social | blank | Security | Risk Mgmt | blank | blank | false | blank | false |
| AL0010 | open | 18.6 | false | blank | PR110 | Oakridge Plaza | 440 Oakridge Blvd | Orlando | FL | 32801 | USA | benchmark | Water consumption benchmark updated. | 2024-06-05T11:45:00 | environmental | Water Consumption | J. Maxwell | blank | blank | blank | blank | blank | true |
| AL0011 | resolved | blank | false | blank | PR111 | Parkside Offices | 77 Parkside Ln | Columbus | OH | 43215 | USA | remediation | Remediation of air quality issue. | 2024-03-05T09:00:00 | environmental | blank | Facilities System | Air Quality Team | HVAC filters replaced. | 2024-03-06 | blank | blank | false |
| AL0012 | open | blank | false | blank | PR112 | Stonebridge Center | 350 Stonebridge Rd | Phoenix | AZ | 85003 | USA | audit | ESG policy compliance audit. | 2024-06-07T08:52:00 | governance | blank | Governance Team | Compliance Officer | blank | blank | blank | blank | false |
| AL0013 | in_progress | blank | true | critical | PR113 | Summit Place | 124 Summit St | Salt Lake City | UT | 84101 | USA | incident | Elevator malfunction reported. | 2024-04-30T15:30:00 | governance | blank | Facilities System | Maintenance | blank | blank | false | blank | true |
| AL0014 | resolved | 21.3 | false | blank | PR114 | Cedar Grove | 890 Cedar Rd | Milwaukee | WI | 53202 | USA | benchmark | GHG emissions reduction benchmark. | 2024-05-20T14:00:00 | environmental | GHG Emissions | J. Maxwell | Sustainability Lead | Reduction target met. | 2024-05-21 | blank | blank | true |
| AL0015 | pending | blank | false | blank | PR115 | Vista Ridge | 765 Vista Dr | Las Vegas | NV | 89109 | USA | audit | Third-party audit scheduled. | 2024-06-11T16:00:00 | social | blank | Compliance Officer | blank | blank | blank | blank | blank | false |
| AL0016 | closed | blank | false | blank | PR116 | Hillside Square | 201 Hillside Ave | Kansas City | MO | 64108 | USA | remediation | Accessibility ramp installed. | 2024-03-10T12:00:00 | social | blank | Facilities System | Contractor | Ramp installed to code. | 2024-03-12 | blank | blank | true |
| AL0017 | open | blank | true | medium | PR117 | Pinecrest Buildings | 130 Pinecrest Dr | Charlotte | NC | 28202 | USA | incident | Security breach detected at entrance. | 2024-05-02T02:42:00 | governance | blank | Security | J. Davis | blank | blank | false | blank | false |
| AL0018 | open | 38.4 | false | blank | PR118 | Eastwood Tower | 550 Eastwood Ave | Boston | MA | 02116 | USA | benchmark | Renewable energy benchmark updated. | 2024-06-02T14:00:00 | environmental | Renewable Energy % | Sustainability Lead | blank | blank | blank | blank | blank | true |
| AL0019 | resolved | blank | false | low | PR119 | Liberty Square | 401 Liberty Sq | Philadelphia | PA | 19103 | USA | incident | Tenant complaint regarding noise. | 2024-05-19T09:30:00 | social | blank | Tenant Relations | Property Manager | Noise issue addressed. | 2024-05-20 | blank | blank | true |
| AL0020 | in_progress | blank | false | blank | PR120 | Oceanview Offices | 900 Oceanview Dr | San Francisco | CA | 94107 | USA | audit | ESG audit of tenant engagement. | 2024-06-06T13:30:00 | social | blank | Tenant Relations | Audit Team | blank | blank | blank | blank | false |
What the 85 rows show
from the 85-row sampleIn_
- 31%regulatory_
reporting_ required = true - 64.8median benchmark_
value - 2address countries
- 3esg categories
- 5event types
Median 64.8, from 0.34 to 99.1.
- string 17
- float 1
- date 2
- datetime 1
- boolean 3
Columns
24 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 17 columns | |||
audit_log_id | string | Unique identifier for each ESG audit log entryunique | AL0001 |
property_id | string | Unique identifier for the real estate property | PR101 |
property_name | string | Name of the property | Greenwood Plaza |
address_street | string | Street address of the property | 123 Elm St |
address_city | string | City where the property is located | Denver |
address_state | string | State or region of the property | CO |
address_postal_code | string | Postal code of the property | 80203 |
address_country | string | Country where the property is located2 countries | USA |
event_type | string | Type of ESG event (e.g., benchmark, incident, audit, remediation)benchmark · incident · audit · remediation · other | benchmark |
event_description | string | Detailed description of the ESG event | Recycling bins replaced. |
esg_category | string | ESG category associated with the eventenvironmental · social · governance | environmental |
benchmark_metric | string | Name of the ESG benchmark or metric (if applicable)optional | Energy Use Intensity |
incident_severity | string | Severity level of the incident (if event_type is 'incident')low · medium · high · critical · optional | high |
audit_status | string | Current status of the ESG audit or eventopen · in_progress · closed · resolved · pending | closed |
reported_by | string | Name or identifier of the person or system reporting the event | J. Maxwell |
assigned_to | string | Name or identifier of the person responsible for follow-up or resolutionoptional | C. Nguyen |
resolution_notes | string | Notes on resolution, corrective actions, or follow-up stepsoptional | HVAC filters replaced. |
| Numbers 1 column | |||
benchmark_value | float | Value of the ESG benchmark or metric (if applicable)optional | 74.2 |
| Dates and times 3 columns | |||
event_datetime | datetime | Date and time when the ESG event occurred or was logged | 2024-05-15T10:23:00 |
resolution_date | date | Date when the event was resolved or closed (if applicable)optional | 2024-05-20 |
regulatory_report_date | date | Date when the event was reported to regulators (if applicable)optional | 2024-04-26 |
| True or false 3 columns | |||
regulatory_reporting_required | boolean | Whether this event requires regulatory reporting | false |
regulatory_reported | boolean | Whether this event has been reported to regulatorsoptional | true |
investor_visibility | boolean | Whether this event is visible to investors | true |
Use it for
A real estate dashboard
The regulatory_
reporting_ required rate, benchmark_ value by audit_ status and a breakdown of incident_ severity. Excel, Power BI or Tableau. Why do 26 of 85 rows have regulatory_
reporting_ required = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Audit logs85AL000174.2closedAL0002resolvedAL0004closed
A software demo
Believable audit logs with property_
id, property_ name and address_ street to fill a screen in front of a buyer.
blueprint · real-estate-esg-audit-log
Behind this dataset
Same schema. As many rows as you need.
These 85 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 property must have a unique identifier.
- Audit events are timestamped and categorized by ESG area.
- Incidents require a follow-up action and responsible owner.
- Compliance status is updated after each event review.
- Portfolio-level summaries must be provided monthly.
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
- real-estate-esg-audit-log