Smart Building Access Incident Logs
This dataset provides a detailed log of remote access incidents across commercial properties, capturing user, location, device, and event attributes to support advanced security analytics, compliance auditing, and operational optimization. It enables property managers and IT administrators to monitor access patterns, detect anomalies, and streamline incident response for hybrid and remote workforce environments.
Sample rows
preview · 8 of 65 rows · all 28 columns| incident_idstring | incident_severitystring | compliance_flagboolean | user_departmentstring | timestampdatetime | user_idstring | user_namestring | user_rolestring | property_idstring | property_namestring | property_street_addressstring | property_citystring | property_statestring | property_postal_codestring | property_countrystring | access_point_idstring | access_point_namestring | access_methodstring | incident_typestring | incident_statusstring | reviewed_bystring | reviewed_atdatetime | notesstring | device_idstring | device_typestring | ip_addressstring | geo_location_latfloat | geo_location_longfloat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| INC-9A4B7C12 | info | false | IT | 2024-05-20T08:21:05Z | USR-3572 | Dwayne Carter | employee | PROP-101 | Greenhill Business Center | 101 Greenhill Rd | San Diego | CA | 92121 | USA | AP-001 | Main Entrance Lobby | keycard | access_granted | resolved | SEC-102 | 2024-05-20T09:00:12Z | Routine access. | DEV-01A | controller | 192.168.1.15 | 32.899 | -117.237 |
| INC-1FD73E84 | warning | true | Facilities | 2024-05-20T09:14:45Z | USR-2214 | Emily Zhang | contractor | PROP-102 | Harbor View Tower | 212 Harbor St | San Francisco | CA | 94111 | USA | AP-008 | Loading Dock | pin | access_denied | new | blank | blank | Incorrect PIN entered. | DEV-02F | panel | 10.0.0.223 | 37.795 | -122.397 |
| INC-7E6F4B09 | info | false | Operations | 2024-05-20T10:07:32Z | USR-4521 | Juan Martinez | employee | PROP-103 | Sunset Plaza | 328 Sunset Ave | Los Angeles | CA | 90026 | USA | AP-012 | West Gate | keycard | access_granted | new | blank | blank | No issues reported. | DEV-05B | controller | 172.16.0.105 | 34.078 | -118.26 |
| INC-5B2D1C63 | info | false | Finance | 2024-05-20T11:33:11Z | USR-9876 | Priya Singh | employee | PROP-104 | Corporate Hub | 1500 Market St | Dallas | TX | 75201 | USA | AP-019 | Parking Garage Entry | mobile_app | access_granted | resolved | SEC-201 | 2024-05-20T12:10:55Z | Mobile access normal. | DEV-10C | sensor | 192.168.2.47 | 32.783 | -96.8 |
| INC-4A8E9B77 | info | false | blank | 2024-05-20T13:42:18Z | USR-3145 | Sharon Lee | visitor | PROP-105 | TechWorks Campus | 221 Innovation Blvd | Austin | TX | 78758 | USA | AP-025 | Reception | biometric | access_granted | new | blank | blank | Visitor fingerprint match. | DEV-16D | camera | 10.10.20.18 | 30.391 | -97.722 |
| INC-A5C1D2B0 | info | false | Security | 2024-05-20T14:15:02Z | USR-6543 | Robert Anderson | admin | PROP-101 | Greenhill Business Center | 101 Greenhill Rd | San Diego | CA | 92121 | USA | AP-003 | Server Room | biometric | access_granted | resolved | SEC-102 | 2024-05-20T14:45:00Z | Admin access approved. | DEV-01A | controller | 172.16.0.88 | 32.899 | -117.237 |
| INC-CCF35D1E | warning | true | Marketing | 2024-05-20T14:37:44Z | USR-7685 | Lisa Young | employee | PROP-104 | Corporate Hub | 1500 Market St | Dallas | TX | 75201 | USA | AP-020 | Side Entrance | keycard | access_denied | in_review | SEC-301 | 2024-05-20T15:05:12Z | Keycard expired. | DEV-10C | controller | 192.168.2.49 | 32.783 | -96.8 |
| INC-8D51A2C4 | critical | true | Maintenance | 2024-05-20T15:22:08Z | USR-1123 | Tommy Evans | contractor | PROP-102 | Harbor View Tower | 212 Harbor St | San Francisco | CA | 94111 | USA | AP-010 | Rooftop Access | keycard | forced_entry | escalated | SEC-102 | 2024-05-20T15:45:33Z | Card reader damaged. | DEV-02F | panel | 10.0.0.229 | 37.795 | -122.397 |
| INC-2B82D796 | info | false | HR | 2024-05-20T15:55:48Z | USR-3278 | Megan O'Brien | employee | PROP-105 | TechWorks Campus | 221 Innovation Blvd | Austin | TX | 78758 | USA | AP-027 | North Entrance | pin | access_granted | resolved | SEC-401 | 2024-05-20T16:20:10Z | PIN verified. | DEV-16D | panel | 10.10.20.22 | 30.391 | -97.722 |
| INC-8B3E2A01 | warning | true | Sales | 2024-05-20T16:12:37Z | USR-9654 | Jake Harrison | employee | PROP-101 | Greenhill Business Center | 101 Greenhill Rd | San Diego | CA | 92121 | USA | AP-004 | Back Entrance | mobile_app | tailgating | new | blank | blank | Tailgating detected. | DEV-01A | sensor | 192.168.1.19 | 32.9 | -117.238 |
| INC-3D7E5B20 | critical | true | IT | 2024-05-20T17:05:11Z | USR-7521 | Sara Wilson | employee | PROP-104 | Corporate Hub | 1500 Market St | Dallas | TX | 75201 | USA | AP-021 | IT Room | biometric | system_error | escalated | SEC-301 | 2024-05-20T17:17:29Z | Biometric system failure. | DEV-10C | panel | 192.168.2.53 | 32.784 | -96.801 |
| INC-7A9C2D13 | info | false | Security | 2024-05-20T17:34:00Z | USR-2021 | Alex Novak | admin | PROP-105 | TechWorks Campus | 221 Innovation Blvd | Austin | TX | 78758 | USA | AP-026 | Security Office | biometric | access_granted | resolved | SEC-401 | 2024-05-20T17:55:10Z | Routine admin access. | DEV-16D | controller | 10.10.20.24 | 30.392 | -97.723 |
| INC-6B8D1E34 | warning | true | Finance | 2024-05-20T18:12:27Z | USR-1098 | Gabriel Reyes | employee | PROP-101 | Greenhill Business Center | 101 Greenhill Rd | San Diego | CA | 92121 | USA | AP-005 | Garage Exit | keycard | anomaly_detected | in_review | SEC-102 | 2024-05-20T18:35:48Z | Unexpected access time. | DEV-01A | sensor | 192.168.1.21 | 32.899 | -117.237 |
| INC-5C7F2E89 | warning | true | Operations | 2024-05-20T18:49:54Z | USR-4812 | Brian Kim | employee | PROP-102 | Harbor View Tower | 212 Harbor St | San Francisco | CA | 94111 | USA | AP-011 | South Gate | mobile_app | tailgating | new | blank | blank | Multiple people entered. | DEV-02F | camera | 10.0.0.237 | 37.796 | -122.398 |
| INC-1B9D8E12 | info | false | Marketing | 2024-05-20T19:13:05Z | USR-7765 | Jessica Brown | employee | PROP-103 | Sunset Plaza | 328 Sunset Ave | Los Angeles | CA | 90026 | USA | AP-015 | Garage Entrance | keycard | access_granted | resolved | SEC-501 | 2024-05-20T19:23:51Z | blank | DEV-05B | controller | 172.16.0.108 | 34.079 | -118.261 |
| INC-7E2C9A13 | warning | true | IT | 2024-05-20T19:42:28Z | USR-1357 | Samuel Cook | employee | PROP-104 | Corporate Hub | 1500 Market St | Dallas | TX | 75201 | USA | AP-022 | East Entrance | pin | access_denied | in_review | SEC-301 | 2024-05-20T20:03:13Z | PIN expired. | DEV-10C | panel | 192.168.2.56 | 32.784 | -96.801 |
| INC-8F3A4B09 | info | false | HR | 2024-05-20T20:19:10Z | USR-3156 | Olivia Johnson | employee | PROP-101 | Greenhill Business Center | 101 Greenhill Rd | San Diego | CA | 92121 | USA | AP-006 | Conference Room | keycard | access_granted | resolved | SEC-102 | 2024-05-20T20:40:00Z | blank | DEV-01A | panel | 192.168.1.25 | 32.899 | -117.237 |
| INC-4C7D2E89 | critical | true | Facilities | 2024-05-20T21:05:21Z | USR-6352 | William Adams | contractor | PROP-102 | Harbor View Tower | 212 Harbor St | San Francisco | CA | 94111 | USA | AP-013 | Stairwell | keycard | forced_entry | escalated | SEC-102 | 2024-05-20T21:25:37Z | Physical damage to lock. | DEV-02F | controller | 10.0.0.241 | 37.796 | -122.398 |
| INC-9B1A2C34 | info | false | Finance | 2024-05-20T21:37:44Z | USR-5842 | Natalie Lewis | employee | PROP-105 | TechWorks Campus | 221 Innovation Blvd | Austin | TX | 78758 | USA | AP-028 | Main Entrance | mobile_app | access_granted | resolved | SEC-401 | 2024-05-20T22:02:19Z | blank | DEV-16D | panel | 10.10.20.27 | 30.391 | -97.722 |
| INC-4E9C8B20 | critical | true | IT | 2024-05-20T22:18:35Z | USR-2189 | Felicia Lee | employee | PROP-103 | Sunset Plaza | 328 Sunset Ave | Los Angeles | CA | 90026 | USA | AP-016 | Reception | biometric | system_error | escalated | SEC-501 | 2024-05-20T22:30:01Z | No biometric match. | DEV-05B | panel | 172.16.0.109 | 34.078 | -118.26 |
What the 65 rows show
from the 65-row sampleWarning (incident severity) stands out: 18 of its 18 rows have compliance_
- 40%compliance_
flag = true - 4incident statuses
- 4device types
- 5user roles
- 5property states
- 5access methods
- string 23
- float 2
- datetime 2
- boolean 1
Columns
28 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 23 columns | |||
incident_id | string | Unique identifier for each access incident log entry.unique | INC-9A4B7C12 |
user_id | string | Unique identifier for the user involved in the incident. | USR-3572 |
user_name | string | Full name of the user involved in the incident.optional | Dwayne Carter |
user_role | string | Role of the user (e.g., employee, contractor, visitor, admin).employee · contractor · visitor · admin · other · optional | employee |
user_department | string | Department or team of the user, if applicable.optional | IT |
property_id | string | Unique identifier for the property/building where the incident occurred. | PROP-101 |
property_name | string | Name of the property/building.optional | Harbor View Tower |
property_street_address | string | Street address of the property.optional | 101 Greenhill Rd |
property_city | string | City where the property is located.11 cities · optional | San Diego |
property_state | string | State or region where the property is located.5 states · optional | CA |
property_postal_code | string | Postal code of the property.optional | 92121 |
property_country | string | Country where the property is located.optional | USA |
access_point_id | string | Unique identifier for the access point (e.g., door, gate, turnstile). | AP-001 |
access_point_name | string | Descriptive name or location of the access point.optional | Main Entrance Lobby |
access_method | string | Method used for access (e.g., mobile app, keycard, biometric, PIN, remote override).6 values | keycard |
incident_type | string | Type of incident (e.g., access_granted, access_denied, forced_entry, tailgating, system_error, anomaly_detected).7 values | access_granted |
incident_severity | string | Severity level of the incident (e.g., info, warning, critical).info · warning · critical · optional | info |
incident_status | string | Current status of the incident (e.g., new, in_review, resolved, escalated).new · in_review · resolved · escalated · optional | resolved |
reviewed_by | string | User ID or name of the person who reviewed the incident, if applicable.optional | SEC-102 |
notes | string | Additional notes or comments regarding the incident.optional | Routine access. |
device_id | string | Unique identifier for the device or controller that logged the incident.optional | DEV-01A |
device_type | string | Type of device (e.g., controller, sensor, camera, panel).controller · sensor · camera · panel · other · optional | controller |
ip_address | string | IP address from which remote access was attempted, if applicable.optional | 192.168.1.15 |
| Numbers 2 columns | |||
geo_location_lat | float | Latitude of the access attempt (if available).-90 to 90 · optional | 32.899 |
geo_location_long | float | Longitude of the access attempt (if available).-180 to 180 · optional | -117.237 |
| Dates and times 2 columns | |||
timestamp | datetime | Date and time when the access incident occurred. | 2024-05-20T08:21:05Z |
reviewed_at | datetime | Timestamp when the incident was reviewed.optional | 2024-05-20T09:00:12Z |
| True or false 1 column | |||
compliance_flag | boolean | Indicates if the incident is a compliance concern (true/false).optional | false |
Use it for
A real estate dashboard
The compliance_
flag rate, compliance_ flag by incident_ severity and a breakdown of user_ department. Excel, Power BI or Tableau. Why do 26 of 65 rows have compliance_
flag = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Incidents65INC-9A4B7C12infoINC-1FD73E84warningINC-CCF35D1Ewarning
A software demo
Believable incidents with timestamp, user_
id and user_ name to fill a screen in front of a buyer.
blueprint · smart-building-access-incident-logs
Behind this dataset
Same schema. As many rows as you need.
These 65 rows came out of a blueprint — 28 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 incident log must include timestamp, access point ID, user role, and access method (e.g., mobile app, badge, PIN).
- Flag incidents as normal, suspicious, or unauthorized based on predefined security policies.
- Record incident resolution status and response time in minutes.
- Tag each entry with building occupancy level at time of incident.
- Include optional note for manual overrides or escalations.
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- smart-building-access-incident-logs