Geospatial Telecommunications Outage Logs
This dataset provides detailed, spatially-tagged logs of telecommunications network outages, restoration actions, and impact zones, enabling advanced analytics for resilience, service restoration, and risk assessment. It includes precise geolocation, event timing, affected customers, and severity, making it invaluable for operational monitoring and strategic planning.
Sample rows
preview · 8 of 200 rows · all 19 columns| outage_idstring | outage_causestring | impact_zone_radius_kmfloat | service_typestring | network_segment_idstring | outage_start_datetimedatetime | outage_end_datetimedatetime | restoration_event_idstring | restoration_methodstring | restoration_datetimedatetime | impact_zone_idstring | impact_zone_namestring | impact_zone_latitudefloat | impact_zone_longitudefloat | affected_customers_countinteger | severity_levelstring | reported_bystring | outage_descriptionstring | restoration_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OTG001 | equipment failure | 2.4 | broadband | NSG-A1 | 2024-05-01T07:42:13Z | 2024-05-01T09:23:00Z | REST-01 | manual repair | 2024-05-01T11:10:34Z | ZONE-1001 | Downtown | 40.7128 | -74.006 | 740 | major | automated system | Broadband outage detected in downtown area, affecting multiple commercial and residential customers. | Technicians replaced a faulty switch and restored connectivity to all affected customers. |
| OTG002 | weather | 0.9 | mobile | NSG-B2 | 2024-05-01T13:18:41Z | 2024-05-01T15:02:19Z | REST-02 | automated reroute | 2024-05-01T15:15:56Z | ZONE-1002 | Plaza | 34.0522 | -118.2437 | 315 | major | automated system | Mobile service interruption due to heavy rainfall and localized flooding near Plaza. | Traffic rerouted automatically and service restored. |
| OTG003 | maintenance | 0.7 | voice | NSG-C3 | 2024-05-02T06:21:08Z | 2024-05-02T06:24:08Z | REST-03 | remote reset | 2024-05-02T06:25:50Z | ZONE-1053 | Estate | 51.5074 | -0.1278 | 12 | minor | technician | Scheduled maintenance led to brief voice service disruption in Estate neighborhood. | Routine restart completed, no customer action required. |
| OTG004 | unknown | 1.1 | fiber | NSG-D4 | 2024-05-02T09:50:00Z | blank | blank | blank | blank | ZONE-1200 | Central Point | 35.6895 | 139.6917 | 0 | blank | automated system | Unidentified outage detected at Central Point; investigation ongoing. | blank |
| OTG005 | weather | 35.8 | satellite | NSG-E5 | 2024-05-03T14:32:17Z | 2024-05-03T17:20:00Z | REST-04 | manual repair | 2024-05-03T19:09:17Z | ZONE-1111 | Valley | 37.7749 | -122.4194 | 8500 | critical | customer | Wide-area satellite outage reported by several customers in Valley region after severe thunderstorms. | Crews deployed to repair uplink infrastructure and restore service. |
| OTG006 | maintenance | 1.5 | fiber | NSG-F1 | 2024-05-03T21:04:13Z | 2024-05-03T21:04:14Z | REST-05 | remote reset | 2024-05-03T21:05:10Z | ZONE-1042 | District | 48.8566 | 2.3522 | 2 | minor | technician | Routine fiber maintenance in District caused a brief service interruption. | System restarted remotely, connectivity restored. |
| OTG007 | equipment failure | 3.9 | mobile | NSG-G2 | 2024-05-04T04:12:00Z | 2024-05-04T08:00:00Z | REST-06 | manual repair | 2024-05-04T10:15:02Z | ZONE-1007 | City Center | 41.8781 | -87.6298 | 654 | critical | automated system | Critical mobile outage affected hundreds of users in City Center after a major hardware failure. | Hardware replaced, full service restored. |
| OTG008 | weather | 0.8 | broadband | NSG-H3 | 2024-05-04T11:00:18Z | 2024-05-04T11:03:18Z | REST-07 | automated reroute | 2024-05-04T11:05:10Z | ZONE-1058 | Plaza | 29.7604 | -95.3698 | 100 | major | automated system | Short broadband interruption at Plaza due to lightning strike. | Traffic rerouted automatically. |
| OTG009 | unknown | 0.3 | voice | NSG-I4 | 2024-05-05T15:43:50Z | blank | blank | blank | blank | ZONE-1150 | Border | 55.7558 | 37.6173 | 0 | blank | technician | System detected possible anomaly in Border region; no customer impact confirmed. | blank |
| OTG010 | equipment failure | 2.8 | fiber | NSG-J5 | 2024-05-05T20:15:59Z | 2024-05-05T21:05:00Z | REST-08 | manual repair | 2024-05-05T23:19:22Z | ZONE-1004 | Downtown | 47.6062 | -122.3321 | 540 | major | automated system | Fiber outage in downtown region caused by aging equipment. | Faulty modules replaced, connectivity restored. |
| OTG011 | weather | 22.5 | satellite | NSG-K1 | 2024-05-06T01:10:10Z | 2024-05-06T02:30:10Z | REST-09 | manual repair | 2024-05-06T04:10:10Z | ZONE-2001 | Farms | 39.9526 | -75.1652 | 4300 | major | customer | Storm-related satellite outage over rural Farms zone. | Temporary reroute implemented; crews on site. |
| OTG012 | maintenance | 0.3 | broadband | NSG-L2 | 2024-05-06T08:45:00Z | 2024-05-06T08:47:34Z | REST-10 | remote reset | 2024-05-06T08:48:05Z | ZONE-1039 | Park | 40.4406 | -79.9959 | 8 | minor | technician | Brief broadband interruption during scheduled maintenance in Park district. | System reset remotely. |
| OTG013 | equipment failure | 2.3 | voice | NSG-M3 | 2024-05-07T11:05:42Z | 2024-05-07T13:00:00Z | REST-11 | manual repair | 2024-05-07T14:35:10Z | ZONE-1067 | Heights | 33.4484 | -112.074 | 210 | major | customer | Voice service interruption in Heights district reported by residents. | Technician replaced faulty hardware. |
| OTG014 | maintenance | 1.2 | fiber | NSG-N4 | 2024-05-07T17:15:00Z | 2024-05-07T17:17:00Z | REST-12 | remote reset | 2024-05-07T17:18:00Z | ZONE-1092 | District | 38.9072 | -77.0369 | 16 | minor | technician | Routine fiber restart in District, minor customer impact. | Routine restart completed. |
| OTG015 | weather | 65.9 | satellite | NSG-O5 | 2024-05-08T05:00:00Z | 2024-05-08T06:35:00Z | REST-13 | manual repair | 2024-05-08T09:15:00Z | ZONE-1100 | Rural Area | 36.7783 | -119.4179 | 12000 | critical | automated system | Critical outage in Rural Area after windstorm damaged satellite infrastructure. | Crews deployed; repairs ongoing. |
| OTG016 | equipment failure | 1.8 | broadband | NSG-P1 | 2024-05-08T13:14:00Z | 2024-05-08T13:14:00Z | REST-14 | automated reroute | 2024-05-08T13:15:12Z | ZONE-1003 | City Center | 39.7684 | -86.1581 | 348 | major | automated system | Instant broadband outage in City Center resolved by automated reroute. | Traffic rerouted, service restored. |
| OTG017 | weather | 28.7 | fiber | NSG-Q2 | 2024-05-09T00:00:00Z | 2024-05-09T03:15:00Z | REST-15 | manual repair | 2024-05-09T05:00:00Z | ZONE-1151 | Valley | 32.7157 | -117.1611 | 5600 | major | customer | Fiber outage in Valley due to lightning, reported by local businesses. | Temporary reroute and repairs completed. |
| OTG018 | equipment failure | 3.1 | voice | NSG-R3 | 2024-05-09T13:21:00Z | 2024-05-09T14:00:00Z | REST-16 | manual repair | 2024-05-09T16:00:00Z | ZONE-1068 | Heights | 25.7617 | -80.1918 | 340 | major | technician | Voice outage in Heights, resolved by manual repair. | Hardware replaced, monitoring ongoing. |
| OTG019 | maintenance | 0.9 | mobile | NSG-S4 | 2024-05-10T06:00:00Z | 2024-05-10T06:03:00Z | REST-17 | remote reset | 2024-05-10T06:04:00Z | ZONE-1012 | Park | 44.9778 | -93.265 | 14 | minor | technician | Brief mobile service interruption in Park due to maintenance. | System reset remotely. |
| OTG020 | unknown | blank | fiber | NSG-T5 | 2024-05-10T12:18:00Z | blank | blank | blank | blank | blank | blank | 42.3601 | -71.0589 | blank | blank | automated system | Fiber outage detected, but impact zone and affected customers not determined. | blank |
What the 200 rows show
from the 200-row sampleWeather (outage cause) stands out: mean impact_
- 2.0median impact_
zone_ radius_ km - 3restoration methods
- 3severity levels
- 3reported_
by values - 348median affected_
customers_ count
Median 2.0, from 0.0 to 80.0.
- string 12
- integer 1
- float 3
- datetime 3
Columns
19 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
outage_id | string | Unique identifier for each outage eventunique | OTG001 |
network_segment_id | string | Identifier for the affected network segment or asset | NSG-A1 |
restoration_event_id | string | Identifier for the restoration event associated with the outageoptional | REST-01 |
restoration_method | string | Method or process used to restore service (e.g., manual repair, automated reroute)4 values · optional | manual repair |
impact_zone_id | string | Identifier for the geographic impact zone affected by the outageoptional | ZONE-1001 |
impact_zone_name | string | Human-readable name of the impact zone (e.g., city, neighborhood)optional | Downtown |
outage_cause | string | Primary cause of the outage (e.g., weather, equipment failure, cyberattack)5 values · optional | equipment failure |
service_type | string | Type of telecommunications service affected (e.g., mobile, broadband, voice)mobile · broadband · voice · fiber · satellite | broadband |
severity_level | string | Severity level of the outage (e.g., minor, major, critical)minor · major · critical · optional | major |
reported_by | string | Source that reported the outage (e.g., automated system, customer, technician)3 values · optional | automated system |
outage_description | string | Detailed description of the outage eventoptional | Broadband outage detected… |
restoration_notes | string | Additional notes or comments about the restoration processoptional | System reset remotely. |
| Numbers 4 columns | |||
impact_zone_latitude | float | Latitude coordinate for the center of the impact zone-90 to 90 | 40.7128 |
impact_zone_longitude | float | Longitude coordinate for the center of the impact zone-180 to 180 | -74.006 |
impact_zone_radius_km | float | Radius of the impact zone in kilometers0 or more · optional | 2.4 |
affected_customers_count | integer | Number of customers affected by the outage0 or more · optional | 740 |
| Dates and times 3 columns | |||
outage_start_datetime | datetime | Timestamp when the outage began | 2024-05-01T07:42:13Z |
outage_end_datetime | datetime | Timestamp when the outage was resolvedoptional | 2024-05-01T09:23:00Z |
restoration_datetime | datetime | Timestamp when restoration actions were completedoptional | 2024-05-01T11:10:34Z |
Use it for
A telecommunications dashboard
Impact_
zone_ radius_ km by outage_ cause and a breakdown of service_ type. Excel, Power BI or Tableau. Why do the 53 weather rows have a mean impact_
zone_ radius_ km of 30.8? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Outages200OTG0012.4equipmen…OTG0020.9weatherOTG0030.7maintena…
A software demo
Believable outages with network_
segment_ id, outage_ start_ datetime and outage_ end_ datetime to fill a screen in front of a buyer.
This dataset200 rows19 columns
Yours1,000 rows19 columns
blueprint · geospatial-telecommunications-outage-logs
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 19 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
- Outage start and end time recorded
- Latitude and longitude of affected area
- Outage cause classified
- Number of users impacted estimated
- Restoration crew assignment included
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
- geospatial-telecommunications-outage-logs