Spectrum Utilization and Efficiency Metrics
This dataset provides granular, real-time measurements of spectrum utilization across cellular networks, including PRB usage, spectrum efficiency, traffic load, idle spectrum, and temporal patterns. It is designed to support network optimization, dynamic spectrum management, and regulatory compliance, making it invaluable for telecom operators and researchers seeking to maximize spectrum efficiency and identify underutilized resources.
Sample rows
preview · 8 of 500 rows · all 14 columns| measurement_idstring | temporal_pattern_labelstring | spectrum_efficiency_bps_per_hz_cellfloat | dynamic_spectrum_opportunityboolean | band_idstring | cell_idstring | measurement_datetimedatetime | prb_totalinteger | prb_usedinteger | traffic_load_mbpsfloat | idle_spectrum_hzfloat | utilization_percentagefloat | location_latitudefloat | location_longitudefloat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MEAS-001 | peak | 4.7 | false | BAND-700 | CELL-101 | 2024-06-01T08:05:00Z | 120 | 120 | 120.45 | 0 | 100 | 40.7128 | -74.006 |
| MEAS-002 | off-peak | 1.2 | true | BAND-2600 | CELL-102 | 2024-06-01T05:15:00Z | 100 | 20 | 15.9 | 150000000 | 20 | 34.0522 | -118.2437 |
| MEAS-003 | peak | 4.2 | false | BAND-1800 | CELL-103 | 2024-06-01T15:45:00Z | 150 | 150 | 135.8 | 0 | 100 | 51.5074 | -0.1278 |
| MEAS-004 | off-peak | 0 | true | BAND-3500 | CELL-104 | 2024-06-01T23:15:00Z | 80 | 0 | 0 | 850000000 | 0 | -33.8688 | 151.2093 |
| MEAS-005 | steady | 2.3 | true | BAND-700 | CELL-105 | 2024-06-01T11:25:00Z | 60 | 36 | 39.6 | 6700000 | 60 | 48.8566 | 2.3522 |
| MEAS-006 | peak | 4.6 | false | BAND-2100 | CELL-106 | 2024-06-01T18:00:00Z | 90 | 90 | 100.5 | 0 | 100 | 35.6895 | 139.6917 |
| MEAS-007 | off-peak | 1.1 | true | BAND-1800 | CELL-107 | 2024-06-01T03:30:00Z | 70 | 21 | 10.8 | 63000000 | 30 | -23.5505 | -46.6333 |
| MEAS-008 | steady | 2.7 | false | BAND-900 | CELL-108 | 2024-06-01T12:10:00Z | 110 | 77 | 62.5 | 4500000 | 70 | 19.076 | 72.8777 |
| MEAS-009 | peak | 3.6 | false | BAND-2600 | CELL-109 | 2024-06-01T19:45:00Z | 45 | 45 | 48.2 | 0 | 100 | 55.7558 | 37.6173 |
| MEAS-010 | other | 0 | true | BAND-3500 | CELL-110 | 2024-06-01T07:20:00Z | 50 | 0 | 0 | 990000000 | 0 | 90 | 180 |
| MEAS-011 | steady | 2.6 | true | BAND-2100 | CELL-111 | 2024-06-01T14:05:00Z | 200 | 120 | 80.1 | 3000000 | 60 | 52.52 | 13.405 |
| MEAS-012 | peak | 4.3 | false | BAND-700 | CELL-112 | 2024-06-01T22:40:00Z | 60 | 60 | 86.5 | 0 | 100 | 28.7041 | 77.1025 |
| MEAS-013 | off-peak | 0.6 | true | BAND-800 | CELL-101 | 2024-06-01T17:50:00Z | 30 | 9 | 4.2 | 40000000 | 30 | 39.9042 | 116.4074 |
| MEAS-014 | steady | 2.2 | true | BAND-900 | CELL-113 | 2024-06-01T16:25:00Z | 120 | 72 | 40.9 | 5400000 | 60 | 41.3851 | 2.1734 |
| MEAS-015 | peak | 3.4 | false | BAND-1800 | CELL-104 | 2024-06-01T13:45:00Z | 100 | 100 | 92.3 | 0 | 100 | -90 | -180 |
| MEAS-016 | other | 0 | true | BAND-2600 | CELL-114 | 2024-06-01T02:00:00Z | 80 | 0 | 0 | 800000000 | 0 | 37.7749 | -122.4194 |
| MEAS-017 | steady | 1.7 | true | BAND-3500 | CELL-115 | 2024-06-01T09:30:00Z | 110 | 44 | 19.7 | 16000000 | 40 | 59.3293 | 18.0686 |
| MEAS-018 | peak | 4.9 | false | BAND-2100 | CELL-116 | 2024-06-01T21:15:00Z | 140 | 140 | 140.1 | 0 | 100 | 13.7563 | 100.5018 |
| MEAS-019 | off-peak | 0.7 | true | BAND-1800 | CELL-117 | 2024-06-01T04:40:00Z | 120 | 12 | 5.8 | 300000000 | 10 | 60.1699 | 24.9384 |
| MEAS-020 | steady | 2.1 | false | BAND-700 | CELL-118 | 2024-06-01T10:55:00Z | 90 | 54 | 33.8 | 7800000 | 60 | 1.3521 | 103.8198 |
What the 500 rows show
from the 500-row samplePeak (temporal pattern label) stands out: mean spectrum_
- 56%dynamic_
spectrum_ opportunity = true - 1.8median spectrum_
efficiency_ bps_ per_ hz_ cell - 90median prb_
total - 38.5median prb_
used - 21.7median traffic_
load_ mbps - 6,970,000median idle_
spectrum_ hz
Median 1.8, from 0.0 to 5.0.
- string 4
- integer 2
- float 6
- datetime 1
- boolean 1
Columns
14 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 4 columns | |||
measurement_id | string | Unique identifier for each spectrum utilization measurement recordunique | MEAS-001 |
cell_id | string | Identifier for the cell where the measurement was taken | CELL-101 |
band_id | string | Identifier for the frequency band being measured7 bands | BAND-700 |
temporal_pattern_label | string | Categorical label describing the temporal utilization pattern (e.g., peak, off-peak, steady, bursty)peak · off-peak · steady · bursty · other | peak |
| Numbers 8 columns | |||
prb_total | integer | Total number of Physical Resource Blocks (PRBs) available in the band for the cell1 or more | 120 |
prb_used | integer | Number of PRBs currently in use during the measurement0 or more | 120 |
spectrum_efficiency_bps_per_hz_cell | float | Spectrum efficiency measured in bits per second per Hertz per cell0 or more | 4.7 |
traffic_load_mbps | float | Total traffic load on the band for the cell, measured in Megabits per second0 or more | 120.45 |
idle_spectrum_hz | float | Amount of spectrum (in Hertz) identified as idle during the measurement period0 or more | 0 |
utilization_percentage | float | Percentage of spectrum utilized during the measurement period (0-100)0 to 100 | 100 |
location_latitude | float | Latitude coordinate of the measurement location-90 to 90 | 40.7128 |
location_longitude | float | Longitude coordinate of the measurement location-180 to 180 | -74.006 |
| Dates and times 1 column | |||
measurement_datetime | datetime | Timestamp when the spectrum utilization measurement was recorded | 2024-06-01T08:05:00Z |
| True or false 1 column | |||
dynamic_spectrum_opportunity | boolean | Indicates if there is an opportunity for dynamic spectrum management at this time/location | false |
Use it for
A telecommunications dashboard
The dynamic_
spectrum_ opportunity rate, spectrum_ efficiency_ bps_ per_ hz_ cell by temporal_ pattern_ label and a breakdown of band_ id. Excel, Power BI or Tableau. Why do the 134 peak rows have a mean spectrum_
efficiency_ bps_ per_ hz_ cell of 4.2? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Measurements500MEAS-0014.7peakMEAS-0021.2off-peakMEAS-0040off-peak
A software demo
Believable measurements with cell_
id, band_ id and measurement_ datetime to fill a screen in front of a buyer.
blueprint · spectrum-utilization-and-efficiency-metrics
Behind this dataset
Same schema. As many rows as you need.
These 500 rows came out of a blueprint — 14 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.
- Cell ID and frequency band monitored
- Timestamp: typically 15-minute or hourly measurement intervals
- PRB utilization percentage: downlink and uplink separately
- Spectrum efficiency: bits per second per Hz per cell (bps/Hz/cell)
- Traffic load (Erlang) and busy hour identification
- Idle spectrum percentage: unutilized capacity opportunities
- Temporal patterns: weekday vs. weekend, business hours vs. overnight
- Interference levels and adjacent channel interference
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
- spectrum-utilization-and-efficiency-metrics