Mobile Data Session Records (PGW-CDR/SGW-CDR)
This dataset provides granular records of mobile data sessions from 4G LTE and 5G networks, including session timing, data volume, subscriber identifiers, network quality, and detected application/service types. It is ideal for telecom analytics, network optimization, billing, and user behavior studies, offering deep insights into mobile data usage patterns and service performance.
Sample rows
preview · 8 of 800 rows · all 15 columns| session_idstring | network_typestring | downlink_bytesinteger | roamingboolean | application_typestring | subscriber_idstring | session_start_timedatetime | session_end_timedatetime | session_duration_secondsinteger | apnstring | qciinteger | ip_addressstring | uplink_bytesinteger | service_typestring | charging_idstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A1B2C3D4-24-batch1-001 | 4G LTE | 32768 | false | web | sub-100001 | 2024-01-03T08:00:00Z | 2024-01-03T08:30:00Z | 1800 | internet.mnc001.mcc310.gprs | 1 | 10.0.0.5 | 8192 | browsing | charge-0001 |
| F5G6H7J8-24-batch1-002 | 4G LTE | 0 | blank | blank | sub-100002 | 2024-01-03T09:00:00Z | 2024-01-03T09:00:01Z | 1 | edge.mnc005.mcc311.gprs | 9 | 0.0.0.0 | 0 | blank | blank |
| K2L3M4N5-24-batch1-003 | 4G LTE | 24576 | false | web | sub-100003 | 2024-01-05T12:15:00Z | 2024-01-05T12:45:00Z | 1800 | internet.mnc002.mcc310.gprs | 4 | 172.16.0.1 | 4096 | browsing | charge-0002 |
| Q8W9E0R1-24-batch1-004 | 5G | 2147483647 | false | video | sub-100004 | 2024-01-05T15:00:00Z | 2024-01-05T16:00:00Z | 3600 | video.mnc003.mcc312.gprs | 9 | 2001:db8:abcd:0012::1 | 1048576 | streaming | charge-0003 |
| T2Y3U4I5-24-batch1-005 | 4G LTE | 2048 | false | iot | sub-100005 | 2024-01-07T23:59:00Z | 2024-01-08T00:00:00Z | 60 | iot.mnc007.mcc310.gprs | 8 | fe80::1ff:fe23:4567:890a | 128 | device comm | blank |
| O6P7A8S9-24-batch1-006 | 4G LTE | 1024 | false | mms | sub-100006 | 2024-01-09T04:00:00Z | 2024-01-09T04:01:00Z | 60 | mms.mnc008.mcc311.gprs | 3 | fc00:: | 64 | messaging | blank |
| I4U5Y6T7-24-batch1-007 | 4G LTE | 81920 | false | web | sub-100007 | 2024-01-10T19:00:00Z | 2024-01-10T21:00:00Z | 7200 | internet.mnc009.mcc310.gprs | 1 | 192.168.1.10 | 20480 | browsing | charge-0004 |
| Z7X8C9V0-24-batch1-008 | 5G | 1048576 | true | vpn | sub-100008 | 2024-01-12T16:30:00Z | 2024-01-12T18:00:00Z | 5400 | work.mnc010.mcc313.gprs | 2 | 2001:db8:abcd:0012::8 | 65536 | business | charge-u001 |
| B1N2M3V4-24-batch1-009 | 4G LTE | 4194304 | true | vpn | sub-100009 | 2024-01-15T06:00:00Z | 2024-01-15T06:50:00Z | 3000 | specialapn.mnc011.mcc314.gprs | 3 | 2001:db8:abcd:0012::f | 327680 | confidential | charge-u002 |
| C4X5Z6V7-24-batch1-010 | 4G LTE | 1 | blank | blank | sub-100010 | 2024-01-18T10:00:00Z | 2024-01-18T10:01:00Z | 60 | internet.mnc012.mcc310.gprs | 1 | 255.255.255.255 | 1 | blank | blank |
| D2E3F4G5-24-batch1-011 | 4G LTE | 16384 | false | web | sub-100011 | 2024-01-20T14:00:00Z | 2024-01-20T14:30:00Z | 1800 | internet.mnc013.mcc310.gprs | 4 | 192.168.0.50 | 4096 | gaming | charge-0005 |
| H4J5K6L7-24-batch1-012 | 5G | 2596069104 | false | streaming | sub-100012 | 2024-01-21T20:00:00Z | 2024-01-21T21:30:00Z | 5400 | ultra.mnc014.mcc315.gprs | 7 | 203.0.113.1 | 52428800 | music | charge-0006 |
| M8N9O0P1-24-batch1-013 | 4G LTE | 0 | false | blank | sub-100013 | 2024-01-22T01:00:00Z | 2024-01-22T01:00:01Z | 1 | special.mnc015.mcc316.gprs | 9 | 127.0.0.1 | 0 | blank | blank |
| V2B3N4M5-24-batch1-014 | 4G LTE | 40960 | false | web | sub-100014 | 2024-01-23T06:00:00Z | 2024-01-23T08:00:00Z | 7200 | internet.mnc016.mcc310.gprs | 1 | 100.64.1.5 | 10240 | browsing | charge-0007 |
| C9D8E7F6-24-batch1-015 | 4G LTE | 32768 | false | web | sub-100015 | 2024-01-24T11:00:00Z | 2024-01-24T11:25:00Z | 1500 | internet.mnc017.mcc310.gprs | 4 | 198.51.100.14 | 8192 | browsing | charge-0008 |
| G2H3J4K5-24-batch1-016 | 5G | 2147483647 | true | video | sub-100016 | 2024-01-25T12:00:00Z | 2024-01-25T14:00:00Z | 7200 | video.mnc018.mcc317.gprs | 9 | 2001:db8:abcd:0012::16 | 305419896 | streaming | charge-0009 |
| T9R8E7W6-24-batch1-017 | 5G | 2596069104 | false | video | sub-100017 | 2024-01-26T20:00:00Z | 2024-01-27T20:00:00Z | 86400 | ultra.mnc019.mcc318.gprs | 7 | 203.0.113.89 | 104857600 | streaming | charge-0010 |
| W5Q4X3Z2-24-batch1-018 | 4G LTE | 8192 | false | web | sub-100018 | 2024-01-28T03:00:00Z | 2024-01-28T03:10:00Z | 600 | internet.mnc020.mcc310.gprs | 4 | 10.0.1.20 | 2048 | browsing | charge-0011 |
| E6D5C4B3-24-batch1-019 | 4G LTE | 0 | blank | blank | sub-100019 | 2024-01-29T14:00:00Z | 2024-01-29T14:00:01Z | 1 | edge.mnc021.mcc319.gprs | 9 | 0.0.0.0 | 0 | blank | blank |
| F4G5H6J7-24-batch1-020 | 4G LTE | 40960 | false | web | sub-100020 | 2024-01-30T20:00:00Z | 2024-01-30T22:00:00Z | 7200 | internet.mnc022.mcc310.gprs | 1 | 192.0.2.33 | 10240 | browsing | charge-0012 |
What the 800 rows show
from the 800-row sample4G LTE (network type) stands out: mean downlink_
- 21%roaming = true
- 65,536median downlink_
bytes - 13service types
- 128subscribers
- 3,600median session_
duration_ seconds - 4median qci
Median 65,536, from 0 to 4,294,967,295.
- string 8
- integer 4
- datetime 2
- boolean 1
Columns
15 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 8 columns | |||
session_id | string | Unique identifier for the mobile data session recordunique | A1B2C3D4-24-batch1-001 |
subscriber_id | string | Unique identifier for the mobile subscriber (e.g., IMSI or anonymized user ID) | sub-100001 |
apn | string | Access Point Name used for the session | edge.mnc005.mcc311.gprs |
ip_address | string | IP address assigned to the subscriber during the session | 10.0.0.5 |
network_type | string | Type of mobile network (e.g., 4G LTE, 5G)4G LTE · 5G | 4G LTE |
application_type | string | Detected application or service type used during the session (e.g., web, video, VoIP)10 types · optional | web |
service_type | string | Detected service category for the session (e.g., streaming, social media, gaming)optional | browsing |
charging_id | string | Identifier used for charging and billing purposesoptional | charge-0001 |
| Numbers 4 columns | |||
session_duration_seconds | integer | Total duration of the session in seconds0 or more | 1800 |
qci | integer | Quality of Service Class Identifier for the session1 to 9 | 1 |
uplink_bytes | integer | Total number of bytes sent from subscriber to network (uplink)0 or more | 8192 |
downlink_bytes | integer | Total number of bytes received by subscriber from network (downlink)0 or more | 32768 |
| Dates and times 2 columns | |||
session_start_time | datetime | Timestamp when the data session started | 2024-01-03T08:00:00Z |
session_end_time | datetime | Timestamp when the data session ended | 2024-01-03T08:30:00Z |
| True or false 1 column | |||
roaming | boolean | Indicates if the session occurred while the subscriber was roamingoptional | false |
Use it for
A telecommunications dashboard
The roaming rate, downlink_
bytes by network_ type and a breakdown of application_ type. Excel, Power BI or Tableau. Why do the 567 4G LTE rows have a mean downlink_
bytes of 35,900,620? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Sessions800A1B2C3D4-24-batch1-001327684G LTEZ7X8C9V0-24-batch1-00810485765GB1N2M3V4-24-batch1-00941943044G LTE
A software demo
Believable sessions with subscriber_
id, session_ start_ time and session_ end_ time to fill a screen in front of a buyer.
blueprint · mobile-data-session-records-pgw-cdrsgw-cdr
Behind this dataset
Same schema. As many rows as you need.
These 800 rows came out of a blueprint — 15 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.
- CDR ID and charging ID for correlation with PCRF policies
- IMSI, MSISDN, and IMEI for subscriber identification
- Session start and end timestamps with time zone
- Data volume: uplink bytes, downlink bytes, total bytes
- APN (Access Point Name): internet, MMS, IMS, enterprise VPN
- QCI (QoS Class Identifier): 1-9, with priority and packet delay budget
- Allocated IP address (IPv4 or IPv6) and serving gateway
- RAT type: LTE, 5G NR, 3G UMTS fallback
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
- mobile-data-session-records-pgw-cdrsgw-cdr