Telecom Call Drop Diagnostics
This dataset provides granular call records with comprehensive diagnostics for both dropped and completed calls, including network, device, and quality-of-service metrics. It enables telecom operators and analysts to perform in-depth troubleshooting, root cause analysis, and QoS optimization across networks and geographies. The data is ideal for identifying patterns in call drops, evaluating network performance, and improving customer experience.
Sample rows
preview · 8 of 200 rows · all 24 columns| call_idstring | call_statusstring | latency_msfloat | roamingboolean | drop_reason_codestring | caller_numberstring | callee_numberstring | call_start_timedatetime | call_end_timedatetime | call_duration_secondsinteger | drop_reason_descriptionstring | network_typestring | signal_strength_dbmfloat | cell_idstring | location_latitudefloat | location_longitudefloat | device_manufacturerstring | device_modelstring | os_versionstring | qos_mosfloat | packet_loss_percentfloat | jitter_msfloat | handover_countinteger | sim_operatorstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| C00001 | completed | 18 | false | blank | +14155550101 | +442071234567 | 2023-10-12T14:11:23Z | 2023-10-12T14:21:53Z | 630 | blank | 5G | -48.3 | NYC_CELL_101 | 40.7128 | -74.006 | Apple | iPhone 14 Pro | iOS 16.4 | 4.92 | 0.1 | 2.3 | 2 | AT&T |
| C00002 | dropped | 131 | false | NW_TIMEOUT | +33123456789 | +4915123456789 | 2023-11-01T09:33:41Z | 2023-11-01T09:36:21Z | 160 | Network timeout during call | 4G | -81.6 | PAR_CELL_204 | 48.8566 | 2.3522 | Samsung | Galaxy S21 | Android 13 | 3.18 | 7.9 | 47.1 | 1 | Orange |
| C00003 | failed | 687 | true | blank | +81312345678 | +821012345678 | 2023-09-27T20:04:12Z | blank | 0 | blank | 3G | -122.7 | TYO_CELL_087 | 35.6895 | 139.6917 | Nokia | 3310 | S30+ | 1.06 | 32.2 | 142.8 | 0 | SK Telecom |
| C00004 | busy | 9 | false | blank | +61291234567 | +12025551234 | 2023-07-19T13:48:40Z | blank | 0 | blank | VoLTE | -58.4 | SYD_CELL_003 | -33.8688 | 151.2093 | Pixel 7 | Android 13 | 4.7 | 0 | 0.5 | 0 | Telstra | |
| C00005 | dropped | 309 | true | SIG_LOSS | +911123456789 | +8613812345678 | 2023-08-06T16:28:05Z | 2023-08-06T16:31:20Z | 195 | Signal lost during handover | 2G | -133.9 | DEL_CELL_021 | 28.6139 | 77.209 | Tecno | Spark 6 | Android 8 | 2.12 | 19.4 | 81.7 | 1 | China Mobile |
| C00006 | completed | 11 | false | blank | +5511998765432 | +34911234567 | 2023-04-23T18:49:19Z | 2023-04-23T18:59:30Z | 611 | blank | WiFi | -33.7 | SAO_CELL_034 | -23.5505 | -46.6333 | Sony | Xperia 5 IV | Android 12 | 4.88 | 0.2 | 1.8 | 2 | Claro |
| C00007 | completed | 15 | false | blank | +498912345678 | +33142345678 | 2023-12-03T22:13:15Z | 2023-12-03T22:23:43Z | 628 | blank | 5G | -52.5 | MUC_CELL_067 | 48.1351 | 11.582 | Samsung | Galaxy S23 | Android 14 | 4.97 | 0 | 1 | 3 | Vodafone DE |
| C00008 | failed | 1152 | true | blank | +8613800138000 | +81312345679 | 2023-09-15T08:41:12Z | blank | 0 | blank | 2G | -146.8 | BJS_CELL_119 | 39.9042 | 116.4074 | Alcatel | OneTouch | KaiOS 2.5 | 1.02 | 41.6 | 188.2 | 0 | NTT Docomo |
| C00009 | completed | 13 | false | blank | +61412345678 | +14155550102 | 2023-05-24T06:57:09Z | 2023-05-24T07:13:09Z | 960 | blank | WiFi | -25.1 | MEL_CELL_055 | -37.8136 | 144.9631 | Apple | iPhone 13 | iOS 15.6 | 4.85 | 0.1 | 1.9 | 1 | Optus |
| C00010 | dropped | 274 | true | CALL_FAIL | +49301234567 | +41221234567 | 2023-09-11T17:19:15Z | 2023-09-11T17:20:05Z | 50 | Call failed due to unknown error | 3G | -117.2 | BER_CELL_029 | 52.52 | 13.405 | Motorola | Moto G5 | Android 7 | 2.52 | 14.6 | 55.7 | 0 | Swisscom |
| C00011 | completed | 22 | false | blank | +5215512345678 | +12025551235 | 2023-06-13T11:04:55Z | 2023-06-13T11:25:10Z | 1275 | blank | VoLTE | -61.9 | MEX_CELL_022 | 19.4326 | -99.1332 | OnePlus | 9 Pro | Android 12 | 4.76 | 0.3 | 2.2 | 2 | Telcel |
| C00012 | busy | 52 | false | blank | +390612345678 | +447911123456 | 2023-11-27T16:40:05Z | blank | 0 | blank | 4G | -83.2 | ROM_CELL_013 | 41.9028 | 12.4964 | Huawei | P30 | Android 10 | 3.89 | 1.7 | 3.1 | 0 | TIM |
| C00013 | dropped | 417 | true | RADIO_INT | +27831234567 | +254712345678 | 2023-03-14T12:15:20Z | 2023-03-14T12:17:40Z | 140 | Radio interface failure | 3G | -124.6 | JNB_CELL_009 | -26.2041 | 28.0473 | Tecno | Camon 15 | Android 10 | 2.11 | 23.9 | 66.7 | 1 | Safaricom |
| C00014 | completed | 12 | false | blank | +447911234567 | +61129123456 | 2023-09-03T21:41:30Z | 2023-09-03T22:04:15Z | 1365 | blank | 5G | -44.1 | LON_CELL_116 | 51.5074 | -0.1278 | Samsung | Galaxy S22 | Android 13 | 4.95 | 0 | 0.7 | 2 | O2 |
| C00015 | failed | 2000 | true | blank | +12135550123 | +85312345678 | 2023-08-31T10:55:11Z | blank | 0 | blank | 2G | -150 | LAX_CELL_011 | 34.0522 | -118.2437 | Nokia | 105 | S30+ | 1 | 100 | 300 | 0 | China Unicom |
| C00016 | completed | 16 | false | blank | +821012345678 | +81312345680 | 2023-10-01T07:32:14Z | 2023-10-01T07:41:14Z | 540 | blank | VoLTE | -59.8 | SEL_CELL_077 | 37.5665 | 126.978 | Apple | iPhone 14 | iOS 16.0 | 4.81 | 0 | 1.2 | 1 | KT |
| C00017 | dropped | 221 | true | LOW_QOS | +393491234567 | +81312345681 | 2023-07-29T12:11:07Z | 2023-07-29T12:12:44Z | 97 | Low quality of service | 3G | -109.1 | ROM_CELL_015 | 41.9028 | 12.4964 | Motorola | G9 Power | Android 10 | 2.83 | 13.1 | 49.3 | 0 | NTT Docomo |
| C00018 | completed | 33 | false | blank | +447812345678 | +33142345679 | 2023-09-09T16:00:00Z | 2023-09-09T16:09:10Z | 550 | blank | 4G | -65.7 | LON_CELL_114 | 51.5074 | -0.1278 | Oppo | Reno7 | Android 12 | 4.23 | 0.6 | 5.9 | 1 | EE |
| C00019 | busy | 25 | false | blank | +5511987654321 | +5215512345679 | 2023-05-05T08:34:41Z | blank | 0 | blank | VoLTE | -69.3 | SAO_CELL_035 | -23.5505 | -46.6333 | Sony | Xperia 10 | Android 11 | 4.29 | 0.2 | 2.9 | 0 | Vivo |
| C00020 | completed | 10 | false | blank | +8613800138001 | +390612345679 | 2023-08-22T11:59:13Z | 2023-08-22T12:09:13Z | 600 | blank | 5G | -41 | BJS_CELL_120 | 39.9042 | 116.4074 | Huawei | P50 Pro | Android 13 | 4.91 | 0 | 1.5 | 2 | China Mobile |
What the 200 rows show
from the 200-row sampleFailed (call status) stands out: mean latency_
- 38%roaming = true
- 18.7median latency_
ms - 6network types
- 13device manufacturers
- 33os versions
- 267.5median call_
duration_ seconds
Median 18.7, from 5.2 to 2,000.
- string 12
- integer 2
- float 7
- datetime 2
- boolean 1
Columns
24 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
call_id | string | Unique identifier for each call record.unique | C00001 |
caller_number | string | Phone number of the caller (E.164 format). | +14155550101 |
callee_number | string | Phone number of the recipient (E.164 format). | +442071234567 |
call_status | string | Status of the call: completed, dropped, failed, or busy.completed · dropped · failed · busy | completed |
drop_reason_code | string | Standardized code indicating the reason for call drop (if applicable).optional | NW_TIMEOUT |
drop_reason_description | string | Human-readable description of the call drop reason.optional | Radio interface failure |
network_type | string | Type of network used for the call (e.g., 2G, 3G, 4G, 5G, VoLTE, WiFi).6 values | 5G |
cell_id | string | Identifier of the cell tower handling the call. | NYC_CELL_101 |
device_manufacturer | string | Manufacturer of the caller's device.optional | Apple |
device_model | string | Model of the caller's device.optional | iPhone 14 Pro |
os_version | string | Operating system version of the caller's device.optional | iOS 16.4 |
sim_operator | string | Mobile network operator of the caller's SIM card.optional | AT&T |
| Numbers 9 columns | |||
call_duration_seconds | integer | Duration of the call in seconds.0 or more | 630 |
signal_strength_dbm | float | Signal strength in dBm at the time of the call.-150 to 0 · optional | -48.3 |
location_latitude | float | Latitude of the caller's location at call start.-90 to 90 · optional | 40.7128 |
location_longitude | float | Longitude of the caller's location at call start.-180 to 180 · optional | -74.006 |
qos_mos | float | Mean Opinion Score (MOS) for call quality (1.0 to 5.0).1 to 5 · optional | 4.92 |
packet_loss_percent | float | Percentage of packet loss during the call.0 to 100 · optional | 0.1 |
jitter_ms | float | Jitter measured in milliseconds during the call.0 or more · optional | 2.3 |
latency_ms | float | Network latency in milliseconds during the call.0 or more · optional | 18 |
handover_count | integer | Number of network handovers during the call.0 or more · optional | 2 |
| Dates and times 2 columns | |||
call_start_time | datetime | Timestamp when the call started. | 2023-10-12T14:11:23Z |
call_end_time | datetime | Timestamp when the call ended.optional | 2023-10-12T14:21:53Z |
| True or false 1 column | |||
roaming | boolean | Indicates if the caller was roaming during the call.optional | false |
Use it for
A telecommunications dashboard
The roaming rate, latency_
ms by call_ status and a breakdown of drop_ reason_ code. Excel, Power BI or Tableau. Why do the 22 failed rows have a mean latency_
ms of 1,553? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Calls200C0000118completedC00003687failedC00005309dropped
A software demo
Believable calls with caller_
number, callee_ number and call_ start_ time to fill a screen in front of a buyer.
blueprint · telecom-call-drop-diagnostics
Behind this dataset
Same schema. As many rows as you need.
These 200 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 call logs duration, start/end location
- Diagnostics: signal strength, network type, handover events
- Dropped calls include reason codes
- User device anonymized
- Peak/off-peak time flagged
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
- telecom-call-drop-diagnostics