IoT/M2M Device Data Usage Records
This dataset provides detailed records of IoT and machine-to-machine device data sessions, including session identifiers, eSIM details, LPWAN technology types, transmission metrics, device sleep cycles, and fleet management attributes. It enables comprehensive analysis of device connectivity, operational efficiency, and fleet performance, supporting diagnostics, optimization, and predictive maintenance for large-scale IoT deployments.
Sample rows
preview · 8 of 900 rows · all 18 columns| session_idstring | technology_typestring | sleep_cycle_countinteger | session_statusstring | device_idstring | esim_idstring | fleet_idstring | session_start_timedatetime | session_end_timedatetime | data_transmitted_bytesinteger | data_received_bytesinteger | transmission_countinteger | average_sleep_duration_secondsfloat | device_location_latitudefloat | device_location_longitudefloat | firmware_versionstring | error_codestring | fleet_manager_idstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| NBIOT-1A8B3C2D | NB-IoT | 2 | completed | DEV-1001 | ESIM-4532A | FLEET-01 | 2024-05-30T07:12:13Z | 2024-05-30T07:52:15Z | 1123 | 1529 | 4 | 136.2 | 40.7128 | -74.006 | v2.1.3-beta | blank | FM-101 |
| LORA-7682E4AD | LoRaWAN | 13 | completed | DEV-1002 | ESIM-4532B | FLEET-02 | 2024-05-30T08:22:10Z | 2024-05-30T11:47:30Z | 630452 | 795103 | 105 | 1467.7 | 37.7749 | -122.4194 | v3.2.1 | blank | FM-102 |
| SIGFOX-INTERRUPTED-9FDB4E2A | Sigfox | 0 | interrupted | DEV-1003 | ESIM-4532C | blank | 2024-06-01T23:59:59Z | 2024-06-02T00:01:01Z | 0 | 0 | 0 | blank | 89.9999 | 179.9999 | v1.4.0 | E401 | blank |
| LTE-M-FAILED-1538DFB2 | LTE-M | 0 | failed | DEV-1004 | ESIM-4532D | FLEET-03 | 2024-06-02T13:05:44Z | 2024-06-02T13:07:44Z | 0 | 0 | 0 | blank | 34.0522 | -118.2437 | v4.0.2-rc | E502 | FM-103 |
| OTHER-56A9C82F | Other | 1 | completed | DEV-1005 | ESIM-4532E | blank | 2024-06-03T19:17:13Z | 2024-06-03T19:18:14Z | 234 | 180 | 3 | 211.6 | -89.999 | 0 | v0.5.1 | blank | blank |
| NBIOT-6BDAE820 | NB-IoT | 2 | completed | DEV-1006 | ESIM-4532F | FLEET-01 | 2024-06-04T09:22:08Z | 2024-06-04T09:53:08Z | 1876 | 2256 | 2 | 112.9 | 51.5074 | -0.1278 | v3.0.1 | blank | FM-101 |
| LORA-COMPLETED-C392DFA1 | LoRaWAN | 10 | completed | DEV-1007 | ESIM-4532G | FLEET-04 | 2024-06-04T15:23:42Z | 2024-06-04T17:02:12Z | 898432 | 1002321 | 82 | 800.3 | 48.8566 | 2.3522 | v4.1.0 | blank | FM-104 |
| SIGFOX-FAILED-8A13F62B | Sigfox | 0 | failed | DEV-1008 | ESIM-4532H | blank | 2024-06-04T03:21:01Z | 2024-06-04T03:21:30Z | 0 | 0 | 0 | blank | 89.5 | 0 | v2.0.1-alpha | E504 | blank |
| LTE-M-INTERRUPTED-1B2D4E7C | LTE-M | 0 | interrupted | DEV-1009 | ESIM-4532I | blank | 2024-06-05T06:45:12Z | 2024-06-05T06:45:35Z | 0 | 0 | 0 | blank | 35.6895 | 139.6917 | v5.1.2 | E400 | blank |
| OTHER-7C1A2B5D | Other | 0 | pending | DEV-1010 | ESIM-4532J | blank | 2024-06-05T10:27:40Z | 2024-06-05T10:29:10Z | 22 | 41 | 1 | 0 | 0 | -180 | v8.0.0 | blank | blank |
| NBIOT-2C2E8B9F | NB-IoT | 2 | completed | DEV-1011 | ESIM-4532K | FLEET-01 | 2024-06-05T14:00:00Z | 2024-06-05T14:37:41Z | 1789 | 2322 | 5 | 60.4 | 41.8781 | -87.6298 | v2.2.0 | blank | FM-101 |
| LORA-FA5B3C28 | LoRaWAN | 15 | completed | DEV-1012 | ESIM-4532L | FLEET-05 | 2024-06-06T18:41:57Z | 2024-06-06T21:05:47Z | 323101 | 612312 | 57 | 1300.5 | 55.7558 | 37.6173 | v3.3.5 | blank | FM-105 |
| SIGFOX-1B7E8F3D | Sigfox | 0 | completed | DEV-1013 | ESIM-4532M | blank | 2024-06-07T01:02:39Z | 2024-06-07T01:03:40Z | 1 | 1 | 1 | blank | 89.9999 | 179.9999 | v3.2.2 | blank | blank |
| LTE-M-1A2B3C4D | LTE-M | 1 | completed | DEV-1014 | ESIM-4532N | blank | 2024-06-07T22:00:00Z | 2024-06-07T22:10:10Z | 1342 | 2401 | 6 | 160.5 | 48.8566 | 2.3522 | v3.9.1 | blank | blank |
| OTHER-2AE4C5B1 | Other | 0 | completed | DEV-1015 | ESIM-4532O | blank | 2024-06-08T06:36:18Z | 2024-06-08T06:39:18Z | 0 | 0 | 0 | blank | 90 | -180 | v1.0.0 | blank | blank |
| NBIOT-2E1B7C6A | NB-IoT | 2 | completed | DEV-1016 | ESIM-4532P | FLEET-02 | 2024-06-08T19:13:53Z | 2024-06-08T19:33:53Z | 902 | 1012 | 3 | 88.7 | 34.0522 | -118.2437 | v1.2.4 | blank | FM-102 |
| LORA-8A4E2B1C | LoRaWAN | 20 | completed | DEV-1017 | ESIM-4532Q | FLEET-06 | 2024-06-09T13:12:00Z | 2024-06-09T14:44:13Z | 952037 | 980213 | 150 | 2200.6 | 52.52 | 13.405 | v2.4.0-rc | blank | FM-106 |
| SIGFOX-2B3A6E9D | Sigfox | 0 | completed | DEV-1018 | ESIM-4532R | blank | 2024-06-10T03:11:57Z | 2024-06-10T03:12:01Z | 999999 | 1000000 | 2500 | blank | -89.9999 | 179.9999 | v5.3.1-beta | blank | blank |
| LTE-M-INTERRUPTED-A3F8D2B1 | LTE-M | 0 | interrupted | DEV-1019 | ESIM-4532S | FLEET-03 | 2024-06-10T11:22:13Z | 2024-06-10T11:22:35Z | 0 | 0 | 0 | blank | 35.6895 | 139.6917 | v5.4.0 | E403 | FM-103 |
| OTHER-7C6A2B4F | Other | 2 | completed | DEV-1020 | ESIM-4532T | blank | 2024-06-11T07:17:34Z | 2024-06-11T07:18:44Z | 123456 | 654321 | 11 | 601.9 | 0 | -180 | v8.1.3-rc | blank | blank |
What the 900 rows show
from the 900-row sampleLoRaWAN (technology type) stands out: mean sleep_
- 1median sleep_
cycle_ count - 71fleets
- 102fleet managers
- 1,342median data_
transmitted_ bytes - 1,879median data_
received_ bytes - 3median transmission_
count
Median 1, from 0 to 30.
- string 9
- integer 4
- float 3
- datetime 2
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
session_id | string | Unique identifier for each device data sessionunique | NBIOT-1A8B3C2D |
device_id | string | Unique identifier for the IoT/M2M device | DEV-1001 |
esim_id | string | Embedded SIM (eSIM/eUICC) identifier associated with the device | ESIM-4532A |
fleet_id | string | Identifier for the fleet or group the device belongs tooptional | FLEET-01 |
technology_type | string | LPWAN technology used for the session (e.g., NB-IoT, LTE-M)NB-IoT · LTE-M · LoRaWAN · Sigfox · Other | NB-IoT |
firmware_version | string | Firmware version running on the device during the sessionoptional | v2.1.3-beta |
session_status | string | Status of the session (e.g., completed, interrupted, failed)completed · interrupted · failed · pending | completed |
error_code | string | Error code if the session failed or was interruptedoptional | E401 |
fleet_manager_id | string | Identifier for the fleet manager responsible for the deviceoptional | FM-101 |
| Numbers 7 columns | |||
data_transmitted_bytes | integer | Total amount of data transmitted during the session, in bytes0 or more | 1123 |
data_received_bytes | integer | Total amount of data received during the session, in bytes0 or more | 1529 |
transmission_count | integer | Number of discrete transmissions during the session0 or more · optional | 4 |
sleep_cycle_count | integer | Number of sleep cycles the device entered during the session0 or more · optional | 2 |
average_sleep_duration_seconds | float | Average duration of device sleep cycles in seconds0 or more · optional | 136.2 |
device_location_latitude | float | Latitude of the device during the session (if available)-90 to 90 · optional | 40.7128 |
device_location_longitude | float | Longitude of the device during the session (if available)-180 to 180 · optional | -74.006 |
| Dates and times 2 columns | |||
session_start_time | datetime | Timestamp when the data session started | 2024-05-30T07:12:13Z |
session_end_time | datetime | Timestamp when the data session ended | 2024-05-30T07:52:15Z |
Use it for
A telecommunications dashboard
Sleep_
cycle_ count by technology_ type and a breakdown of session_ status. Excel, Power BI or Tableau. Why do the 179 LoRaWAN rows have a mean sleep_
cycle_ count of 17.8? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Sessions900NBIOT-1A8B3C2D2NB-IoTLORA-7682E4AD13LoRaWANSIGFOX-INTERRUPTED-9FDB4E2A0Sigfox
A software demo
Believable sessions with device_
id, esim_ id and fleet_ id to fill a screen in front of a buyer.
blueprint · iotm2m-device-data-usage-records
Behind this dataset
Same schema. As many rows as you need.
These 900 rows came out of a blueprint — 18 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.
- Device IMEI and ICCID (eSIM identifier) for IoT devices
- Data session: typically small packets (<1KB) with infrequent transmissions
- RAT type: NB-IoT (Narrowband IoT), LTE-M (LTE for Machines), 2G fallback
- APN for IoT: segregated from consumer internet traffic
- PSM (Power Saving Mode) and eDRX (extended Discontinuous Reception) cycles
- Device location: cell ID or GPS coordinates for asset tracking
- Firmware Over-The-Air (FOTA) updates data volume
- Fleet management: device grouping, bulk provisioning, global SIM
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
- iotm2m-device-data-usage-records