Public Infrastructure Edge Deployment Log
This dataset tracks edge computing device deployments across public infrastructure, capturing detailed location, operational uptime, software compliance, and anomaly events. It enables urban planners and government teams to monitor IoT assets, ensure regulatory adherence, and respond quickly to incidents, supporting smart city digital transformation and efficient infrastructure management.
Sample rows
preview · 8 of 75 rows · all 22 columns| deployment_idstring | regulatory_compliance_statusstring | uptime_hoursfloat | software_compliantboolean | location_countrystring | device_idstring | device_typestring | deployment_datedate | location_latitudefloat | location_longitudefloat | location_street_addressstring | location_citystring | location_statestring | location_postal_codestring | last_maintenance_datedate | software_versionstring | anomaly_detectedboolean | anomaly_event_typestring | contact_person_namestring | contact_person_emailstring | notesstring | anomaly_event_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DEP0001 | compliant | 1456.3 | true | USA | DEV-001 | sensor | 2024-04-03 | 40.7128 | -74.006 | 123 Broadway | New York | NY | 10007 | 2024-05-27 | v2.3.1 | false | none | Laura Chen | laura.chen@ | Initial deployment in park area | blank |
| DEP0002 | compliant | 2200.8 | true | USA | DEV-002 | camera | 2023-11-14 | 34.0522 | -118.2437 | 456 Main St | Los Angeles | CA | 90012 | 2024-04-30 | v3.0.0 | false | none | Miguel Santos | m.santos@ | blank | blank |
| DEP0003 | compliant | 14.2 | true | USA | DEV-001 | sensor | 2024-06-01 | 40.7134 | -74.0075 | 125 Broadway | New York | NY | 10007 | blank | v2.3.2 | false | none | Laura Chen | laura.chen@ | Redeployment after scheduled upgrade | blank |
| DEP0004 | compliant | 893 | true | UK | DEV-003 | gateway | 2024-02-15 | 51.5074 | -0.1278 | 789 King St | London | London | WC2N 5DU | 2024-05-02 | v1.8.5 | false | none | Amir Patel | amir.patel@ | Upgraded to latest firmware last maintenance | blank |
| DEP0005 | compliant | 312.4 | true | Japan | DEV-004 | router | 2024-05-10 | 35.6895 | 139.6917 | 100 Shibuya | Tokyo | Tokyo | 150-0002 | blank | v2.1.9 | false | none | Keiko Tanaka | keiko.tanaka@ | blank | blank |
| DEP0006 | non-compliant | 59 | false | France | DEV-005 | camera | 2024-05-27 | 48.8566 | 2.3522 | 50 Rue de Rivoli | Paris | Île-de-France | 75001 | blank | v3.0.0 | true | network_issue | Luc Moreau | luc.moreau@ | Non-compliance due to outdated security patch | Intermittent connectivity observed during peak hours. |
| DEP0007 | compliant | 8.6 | true | Netherlands | DEV-006 | sensor | 2024-06-02 | 52.3702 | 4.8952 | 75 Damrak | Amsterdam | North Holland | 1012 | blank | v2.2.3 | false | none | Sven de Vries | sven.devries@ | New sensor for air quality monitoring | blank |
| DEP0008 | pending | 415.7 | false | USA | DEV-007 | gateway | 2024-04-22 | 41.8781 | -87.6298 | 200 W Adams St | Chicago | IL | 60606 | 2024-05-28 | v1.9.1 | true | hardware_failure | Janet Lee | janet.lee@ | Unit pending compliance review | Gateway lost power unexpectedly; replaced unit. |
| DEP0009 | pending | 1783.1 | false | USA | DEV-008 | other | 2023-12-20 | 37.7749 | -122.4194 | 101 Market St | San Francisco | CA | 94105 | 2024-03-11 | v0.9.4 | true | power_outage | Derek Wong | derek.wong@ | blank | Device reset after scheduled grid maintenance. |
| DEP0010 | compliant | 1234.5 | true | Russia | DEV-009 | router | 2024-01-08 | 55.7558 | 37.6176 | 5 Tverskaya St | Moscow | Moscow | 101000 | 2024-05-09 | v2.0.5 | false | none | Irina Volkov | i.volkov@ | Stable operation throughout winter | blank |
| DEP0011 | compliant | 218.6 | true | Mexico | DEV-010 | sensor | 2024-05-14 | 19.4326 | -99.1332 | 350 Reforma | Mexico City | CDMX | 06600 | blank | v2.4.7 | false | none | Carlos Rivera | c.rivera@ | Sensor added for traffic study | blank |
| DEP0012 | compliant | 1040.9 | true | India | DEV-011 | camera | 2024-03-18 | 28.7041 | 77.1025 | 88 Connaught Place | Delhi | Delhi | 110001 | 2024-04-02 | v3.1.2 | false | none | Priya Singh | priya.singh@ | blank | blank |
| DEP0013 | compliant | 35.7 | true | Japan | DEV-012 | gateway | 2024-05-29 | 35.6762 | 139.6503 | 212 Marunouchi | Tokyo | Tokyo | 100-0005 | blank | v1.9.0 | false | none | Keiko Tanaka | keiko.tanaka@ | First deployment for 2024 expansion | blank |
| DEP0014 | compliant | 987.3 | true | Germany | DEV-013 | sensor | 2024-03-12 | 52.52 | 13.405 | 300 Alexanderplatz | Berlin | Berlin | 10178 | 2024-05-04 | v2.4.1 | false | none | Jonas Becker | jonas.becker@ | Air quality sensor deployed in busy area | blank |
| DEP0015 | compliant | 411.2 | true | Spain | DEV-014 | camera | 2024-04-17 | 41.3851 | 2.1734 | 250 Gran Via | Barcelona | Catalonia | 08010 | blank | v3.0.8 | false | none | Marina Garcia | marina.garcia@ | blank | blank |
| DEP0016 | compliant | 509.9 | true | Ireland | DEV-015 | router | 2024-04-13 | 53.3498 | -6.2603 | 80 Dame St | Dublin | Leinster | D02 | 2024-05-20 | v2.2.7 | false | none | Declan Murphy | declan.murphy@ | blank | blank |
| DEP0017 | compliant | 3.1 | true | Sweden | DEV-016 | sensor | 2024-05-31 | 59.3293 | 18.0686 | 60 Kungsgatan | Stockholm | Stockholm | 11122 | blank | v2.5.0 | false | none | Anna Lindberg | anna.lindberg@ | Sensor deployed for pilot | blank |
| DEP0018 | compliant | 2206.6 | true | Singapore | DEV-017 | gateway | 2023-10-22 | 1.3521 | 103.8198 | 250 Orchard Rd | Singapore | Singapore | 238841 | 2024-02-14 | v1.9.6 | false | none | Wei Lin | wei.lin@ | Gateway supports traffic sensors | blank |
| DEP0019 | compliant | 465.2 | true | Italy | DEV-018 | camera | 2024-04-02 | 45.4642 | 9.19 | 10 Via Manzoni | Milan | Lombardy | 20121 | blank | v3.2.1 | false | none | Giulia Rossi | giulia.rossi@ | blank | blank |
| DEP0020 | compliant | 111.8 | true | China | DEV-019 | router | 2024-05-18 | 31.2304 | 121.4737 | 120 Nanjing Rd | Shanghai | Shanghai | 200001 | blank | v2.1.4 | false | none | Mei Zhang | mei.zhang@ | Router added for network redundancy | blank |
What the 75 rows show
from the 75-row sampleCompliant (regulatory compliance status) stands out: 63 of its 63 rows have software_
- 88%software_
compliant = true - 241.2median uptime_
hours - 5device types
- 5anomaly event types
Median 241.2, from 1.9 to 4,189.
- string 15
- float 3
- date 2
- boolean 2
Columns
22 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
deployment_id | string | Unique identifier for each edge device deployment eventunique | DEP0001 |
device_id | string | Unique identifier for the edge computing device | DEV-001 |
device_type | string | Type or model of the edge device (e.g., sensor, gateway, camera)sensor · gateway · camera · router · other | sensor |
location_street_address | string | Street address of the deployment locationoptional | 123 Broadway |
location_city | string | City of the deployment location | New York |
location_state | string | State or province of the deployment location | NY |
location_postal_code | string | Postal code of the deployment locationoptional | 10007 |
location_country | string | Country of the deployment location | USA |
software_version | string | Current software version running on the device | v2.3.1 |
anomaly_event_type | string | Type of anomaly event detected (if any)6 values · optional | none |
anomaly_event_description | string | Detailed description of the anomaly eventoptional | Intermittent connectivity… |
regulatory_compliance_status | string | Overall regulatory compliance status for the deploymentcompliant · non-compliant · pending · unknown | compliant |
contact_person_name | string | Name of the responsible contact person for the deploymentoptional | Laura Chen |
contact_person_email | string | Email address of the responsible contact personoptional | laura.chen@ |
notes | string | Additional notes or comments about the deploymentoptional | Sensor for pilot test |
| Numbers 3 columns | |||
location_latitude | float | Latitude coordinate of the deployment location-90 to 90 | 40.7128 |
location_longitude | float | Longitude coordinate of the deployment location-180 to 180 | -74.006 |
uptime_hours | float | Total hours the device has been operational since deployment0 or more | 1456.3 |
| Dates and times 2 columns | |||
deployment_date | date | Date when the device was deployed | 2024-04-03 |
last_maintenance_date | date | Date of the most recent maintenance performed on the deviceoptional | 2024-05-27 |
| True or false 2 columns | |||
software_compliant | boolean | Indicates if the device software is compliant with regulatory standards | true |
anomaly_detected | boolean | Indicates if any anomaly event has been detected for this deployment | false |
Use it for
A government dashboard
The software_
compliant rate, uptime_ hours by regulatory_ compliance_ status and a breakdown of location_ country. Excel, Power BI or Tableau. Why do 66 of 75 rows have software_
compliant = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Deployments75DEP00011456.3compliantDEP00022200.8compliantDEP000659non-comp…
A software demo
Believable deployments with device_
id, device_ type and deployment_ date to fill a screen in front of a buyer.
blueprint · public-infrastructure-edge-deployment-log
Behind this dataset
Same schema. As many rows as you need.
These 75 rows came out of a blueprint — 22 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 edge device deployment event.
- Device type must be one of: traffic sensor, environmental monitor, energy meter, surveillance camera.
- Status must be 'active', 'inactive', or 'maintenance'.
- Compliance field denotes adherence to current municipal IT regulations.
- Anomaly flag is set when unexpected downtime exceeds 1 hour.
- Software version must match approved city standards.
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
- public-infrastructure-edge-deployment-log