Smart City IoT Device Compliance

This dataset offers a detailed inventory of IoT devices deployed across smart city infrastructure, tracking their operational status, compliance with regulations, security vulnerabilities, and remediation efforts. It empowers government teams to monitor risk, ensure regulatory adherence, and coordinate timely remediation, supporting safer and more resilient urban environments.

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

City-wide risk assessment and vulnerability tracking

Sample rows

preview · 8 of 60 rows · all 26 columns
device_idstringlocation_countrystringlocation_statestringdevice_typestringmanufacturerstringmodel_numberstringfirmware_versionstringinstallation_datedatelocation_street_addressstringlocation_citystringlocation_postal_codestringoperational_statusstringlast_compliance_check_datedatecompliance_statusstringsecurity_statusstringlast_security_scan_datedateremediation_statusstringremediation_due_datedateremediation_completed_datedateregulatory_frameworkstringasset_owner_departmentstringcontact_person_namestringcontact_person_emailstringcontact_person_phonestringcompliance_issue_descriptionstringsecurity_issue_descriptionstring
CAM-202401-001USACAcameraAxisAXIS-Q3517v7.4.22022-01-15123 Market StSan Francisco94103active2024-03-14compliantsecure2024-03-14not requiredblankblankNIST SP 800-53Public SafetyLisa Tranlisa.tran@sf.gov+1-415-555-0182blankblank
SNS-202307-012USACAsensorBoschENV-300v3.2.02023-07-09202 Pine AveSan Jose95112active2024-04-02compliantsecure2024-04-02not requiredblankblankISO/IEC 27001Environmental ServicesMiguel Ramirezmiguel.ramirez@sanjose.gov+1-408-555-0109blankblank
GAT-202212-005USACAgatewayCiscoIR829v15.8.32022-12-2175 Geary BlvdOakland94612active2024-02-26pendingunder investigation2024-02-25in progress2024-05-15blankCalifornia SB-327IT ServicesPriya Shahpriya.shah@oaklandca.gov+1-510-555-0178blankUnusual network traffic detected
ACT-202303-020USACAactuatorHoneywellACT-500Av1.9.02023-03-18410 Central AveSacramento95814maintenance2024-03-22non-compliantvulnerable2024-03-22in progress2024-04-30blankNIST SP 800-53Facilities ManagementSamuel Leesamuel.lee@sacgov.gov+1-916-555-0183Physical access control not functioningFirmware outdated, patch required
MET-202206-002USACAmeterItronOpenWay Rivav4.1.12022-06-12812 Elm StBerkeley94704active2024-03-11compliantsecure2024-03-11not requiredblankblankISO/IEC 27001UtilitiesJessica Parkjessica.park@berkeleyca.gov+1-510-555-0197blankblank
SNS-202303-013USACAsensorBoschAIR-100v2.4.02023-03-071501 Main StMountain View94043active2024-04-05compliantsecure2024-04-05not requiredblankblankCalifornia SB-327Environmental ServicesFatima Carterfatima.carter@mountainview.gov+1-650-555-0132blankblank
CAM-202402-007USACAcameraHikvisionDS-2CD2142FWDv5.5.02024-02-03500 Grove StSan Francisco94117active2024-04-01compliantsecure2024-04-01not requiredblankblankNIST SP 800-53Public SafetyRaymond Chenraymond.chen@sf.gov+1-415-555-0201blankblank
ACT-202208-010USACAactuatorHoneywellACT-700Bv2.1.02022-08-162200 BroadwayOakland94612maintenance2024-03-16pendingunder investigation2024-03-16in progress2024-04-20blankCalifornia SB-327Facilities ManagementJorge Alvarezjorge.alvarez@oaklandca.gov+1-510-555-0219blankPossible unauthorized firmware modification

What the 60 rows show

from the 60-row sample
  • 3compliance statuses
  • 3security statuses
  • 3remediation statuses
  • 4operational statuses
  • 5device types
  • 7regulatory frameworks
location_country60 rows by value
0306053USA88%7Canada12%
location_state60 rows · top 10 of 22 values
  1. CA31
  2. TX4
  3. ON3
  4. WA2
  5. MO2
  6. NY2
  7. CO1
  8. FL1
  9. MA1
  10. GA1
26 columns by typefrom the column list below
  • string 21
  • date 5

Columns

26 columns in two groups
blueprint · 26 columns
columntypedescriptionexample
Text 21 columns
device_idstringUnique identifier for the IoT deviceuniqueCAM-202401-001
device_typestringType or category of the IoT device (e.g., sensor, camera, actuator)6 valuescamera
manufacturerstringName of the device manufacturerAxis
model_numberstringManufacturer's model number for the deviceAXIS-Q3517
firmware_versionstringCurrent firmware version installed on the devicev7.4.2
location_street_addressstringStreet address where the device is physically installed123 Market St
location_citystringCity where the device is installedSan Francisco
location_statestringState or province where the device is installedCA
location_postal_codestringPostal code for the device's installation location94103
location_countrystringCountry where the device is installed2 countriesUSA
operational_statusstringCurrent operational status of the deviceactive · inactive · maintenance · decommissionedactive
compliance_statusstringIndicates if the device is compliant with city regulationscompliant · non-compliant · pendingcompliant
compliance_issue_descriptionstringDescription of any compliance issues identified during the last checkoptionalRemote update disabled
security_statusstringCurrent security status of the devicesecure · vulnerable · under investigationsecure
security_issue_descriptionstringDescription of any security vulnerabilities or issues foundoptionalUnusual network traffic d…
remediation_statusstringStatus of remediation efforts for compliance or security issuesnot required · in progress · completed · overduenot required
regulatory_frameworkstringName of the regulatory framework or standard the device is assessed against7 frameworksNIST SP 800-53
asset_owner_departmentstringCity department responsible for the device8 departmentsPublic Safety
contact_person_namestringName of the primary contact for the deviceLisa Tran
contact_person_emailstringEmail address of the primary contactlisa.tran@sf.gov
contact_person_phonestringPhone number of the primary contactoptional+1-415-555-0182
Dates and times 5 columns
installation_datedateDate the device was installed in the city infrastructure2022-01-15
last_compliance_check_datedateDate of the most recent compliance check for the device2024-03-14
last_security_scan_datedateDate of the most recent security scan2024-03-14
remediation_due_datedateDue date for remediation of identified issuesoptional2024-05-15
remediation_completed_datedateDate when remediation was completedoptional

Use it for

  • rows6026 columnsrows by location coun…53USA7Canada

    A government dashboard

    A breakdown of location_state. Excel, Power BI or Tableau.

  • What pattern can you find in 60 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 60 rows.

  • A software demo

    Believable devices with device_type, manufacturer and model_number to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 26 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 dataset60 rows26 columns
Yours1,000 rows26 columnslocation_street_address: UK only

blueprint · smart-city-iot-device-compliance

Behind this dataset

Same schema. As many rows as you need.

These 60 rows came out of a blueprint — 26 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 device record must have a unique identifier
  • Compliance status must be updated weekly
  • Security incident flag required for non-compliant devices
  • Location and device function must be specified
  • Remediation actions logged for each incident
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-city-iot-device-compliance

More in Government

Browse all
Also in GovernmentUrban Sensor Uptime MonitoringUrban Noise Pollution Sensor DataPublic Procurement Transparency LogsAll 1,958 datasets

What should your data show?

Preview 20 rows free
No signup. No card.