IP Address Management (IPAM) and Allocation
This dataset provides detailed management records for IPv4 and IPv6 address space, covering global and regional allocations, service assignments, subnet planning, utilization metrics, and DHCP lease activity. It enables network teams to track address usage, plan for IPv6 deployment, and optimize resource allocation across mobile, broadband, and enterprise services.
Sample rows
preview · 8 of 500 rows · all 17 columns| ip_block_idstring | ip_versionstring | subnet_prefix_lengthinteger | dhcp_enabledboolean | subnet_maskstring | ip_blockstring | allocation_typestring | allocated_tostring | service_typestring | rirstring | allocation_datedate | parent_ip_block_idstring | utilization_percentagefloat | ipv6_deployment_statusstring | dhcp_lease_countinteger | dhcp_lease_expirydatetime | commentsstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ARIN-RIR-0001 | IPv4 | 16 | false | 255.255.0.0 | 23.45.0.0/16 | RIR | Telecom North America | enterprise | ARIN | 2002-03-15 | blank | 12.7 | planned | 0 | blank | Parent block for company-wide subnets |
| RIPE-RIR-0002 | IPv4 | 17 | false | 255.255.128.0 | 45.67.128.0/17 | RIR | EuroNet Solutions | enterprise | RIPE | 2011-07-22 | blank | 17.2 | completed | 0 | blank | Legacy enterprise allocation |
| APNIC-RIR-0003 | IPv6 | 32 | true | blank | 2400:cb00::/32 | RIR | Asia Broadband Group | broadband | APNIC | 2018-10-05 | blank | 9.4 | planned | 100 | 2024-08-04T15:20:00 | Initial allocation for IPv6 broadband rollout |
| LACNIC-RIR-0004 | IPv4 | 16 | false | 255.255.0.0 | 191.232.0.0/16 | RIR | LatinCom Enterprise | enterprise | LACNIC | 2015-06-18 | blank | 21.8 | planned | 0 | blank | Allocated for legacy services, low utilization |
| AFRINIC-RIR-0005 | IPv6 | 29 | true | blank | 2c0f:fea0::/29 | RIR | AfricaNet ISP | broadband | AFRINIC | 2019-03-12 | blank | 4.2 | in-progress | 50 | 2024-07-09T10:05:00 | IPv6 broadband edge deployment |
| ARIN-SERVICE-0006 | IPv4 | 24 | true | 255.255.255.0 | 23.45.4.0/24 | Service | Telecom North America - Mobile | mobile | ARIN | 2019-05-03 | blank | 87.5 | in-progress | 200 | 2024-07-17T17:55:00 | Mobile device allocation block |
| RIPE-SERVICE-0007 | IPv4 | 23 | true | 255.255.254.0 | 45.67.130.0/23 | Service | EuroNet Solutions - Broadband | broadband | RIPE | 2022-01-08 | blank | 72.1 | in-progress | 350 | 2024-07-11T12:30:00 | High utilization broadband service block |
| APNIC-SERVICE-0008 | IPv6 | 56 | true | blank | 2400:cb00:1000::/56 | Service | Asia Broadband - Fiber | broadband | APNIC | 2021-11-28 | blank | 71.2 | completed | 1200 | 2024-07-19T08:25:00 | Active fiber deployment for broadband customers |
| LACNIC-SERVICE-0009 | IPv4 | 20 | true | 255.255.240.0 | 191.232.128.0/20 | Service | LatinCom Mobile Division | mobile | LACNIC | 2023-04-14 | blank | 68.3 | in-progress | 650 | 2024-07-24T22:40:00 | Mobile access block, high lease activity |
| AFRINIC-SERVICE-0010 | IPv4 | 21 | false | 255.255.248.0 | 196.25.32.0/21 | Service | AfricaNet Enterprise | enterprise | AFRINIC | 2017-09-09 | blank | 53.9 | completed | 0 | blank | Enterprise office block, static IP usage |
| ARIN-SUBNET-0011 | IPv4 | 25 | true | 255.255.255.128 | 23.45.4.128/25 | Subnet | Telecom NA Subnet-A | mobile | ARIN | 2020-08-07 | ARIN-SERVICE-0006 | 98.5 | not-applicable | 120 | 2024-08-01T13:15:00 | Mobile subnet, nearly full utilization |
| RIPE-SUBNET-0012 | IPv4 | 26 | true | 255.255.255.192 | 45.67.130.128/26 | Subnet | EuroNet Test Subnet | other | RIPE | 2023-02-11 | RIPE-SERVICE-0007 | 100 | not-applicable | 62 | 2024-07-21T19:35:00 | Test subnet for edge case, full usage |
| APNIC-SUBNET-0013 | IPv6 | 120 | true | blank | 2400:cb00:1000:1::/120 | Subnet | Asia Broadband R&D | other | APNIC | 2022-09-30 | APNIC-SERVICE-0008 | 6.7 | completed | 20 | 2024-07-14T14:05:00 | Experimental IPv6 subnet, low usage |
| LACNIC-SUBNET-0014 | IPv4 | 29 | false | 255.255.255.248 | 191.232.128.240/29 | Subnet | LatinCom VIP Test | enterprise | LACNIC | 2024-03-02 | LACNIC-SERVICE-0009 | 100 | not-applicable | 0 | blank | Edge case: single customer test allocation |
| AFRINIC-SUBNET-0015 | IPv6 | 128 | true | blank | 2c0f:fea0:1::/128 | Subnet | AfricaNet IoT Device | other | AFRINIC | 2024-01-18 | AFRINIC-RIR-0005 | 100 | completed | 1 | 2024-08-02T11:45:00 | Edge case: IoT device single IPv6 address |
| ARIN-LEASE-0016 | IPv4 | 27 | true | 255.255.255.224 | 23.45.4.192/27 | Lease | Telecom NA Lease-B | mobile | ARIN | 2024-05-01 | blank | 95.2 | not-applicable | 30 | 2024-08-05T09:00:00 | Short-term mobile lease block |
| RIPE-LEASE-0017 | IPv6 | 120 | true | blank | 2a02:6b8:0:1::/120 | Lease | EuroNet IoT Lease | other | RIPE | 2024-06-03 | blank | 80.1 | completed | 60 | 2024-08-03T16:10:00 | Lease allocation for IoT deployment |
| APNIC-RIR-0018 | IPv4 | 24 | false | 255.255.255.0 | 203.0.113.0/24 | RIR | Asia Broadband National | enterprise | APNIC | 2006-02-27 | blank | 10.2 | planned | 0 | blank | Parent block for Asia regional office |
| LACNIC-RIR-0019 | IPv6 | 48 | false | blank | 2801:80:0:1::/48 | RIR | LatinCom IPv6 Expansion | enterprise | LACNIC | 2014-12-19 | blank | 3.9 | planned | 0 | blank | Corporate IPv6 expansion block |
| AFRINIC-RIR-0020 | IPv4 | 22 | false | 255.255.252.0 | 196.25.40.0/22 | RIR | AfricaNet Office | enterprise | AFRINIC | 2013-08-14 | blank | 14.8 | not-applicable | 0 | blank | Office allocation, static IP usage |
What the 500 rows show
from the 500-row sampleIPv4 (ip version) stands out: mean subnet_
- 60%dhcp_
enabled = true - 29median subnet_
prefix_ length - 4service types
- 4ipv6 deployment statuses
- 5allocation types
- 7rirs
Median 29, from 8 to 128.
- string 11
- integer 2
- float 1
- date 1
- datetime 1
- boolean 1
Columns
17 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
ip_block_id | string | Unique identifier for the IP address block recordunique | ARIN-RIR-0001 |
ip_version | string | IP version (IPv4 or IPv6)IPv4 · IPv6 | IPv4 |
ip_block | string | CIDR notation of the IP address block (e.g., 192.0.2.0/24, 2001:db8::/32)unique | 23.45.0.0/16 |
allocation_type | string | Type of allocation (IANA, RIR, Service, Subnet, Lease)IANA · RIR · Service · Subnet · Lease | RIR |
allocated_to | string | Organization, service, or customer to which the block is allocatedoptional | Telecom North America |
service_type | string | Type of service using the block (mobile, broadband, enterprise, etc.)mobile · broadband · enterprise · other · optional | enterprise |
rir | string | Regional Internet Registry responsible for the block (e.g., ARIN, RIPE, APNIC, LACNIC, AFRINIC)7 values · optional | ARIN |
subnet_mask | string | Subnet mask for IPv4 blocks (e.g., 255.255.255.0)optional | 255.255.0.0 |
parent_ip_block_id | string | Reference to the parent IP block if this is a subnetoptional | ARIN-SERVICE-0006 |
ipv6_deployment_status | string | Status of IPv6 deployment for this block (planned, in-progress, completed)planned · in-progress · completed · not-applicable · optional | planned |
comments | string | Additional notes or comments about the blockoptional | IoT deployment block |
| Numbers 3 columns | |||
subnet_prefix_length | integer | Prefix length for the subnet (e.g., 24 for /24)0 to 128 · optional | 16 |
utilization_percentage | float | Percentage of addresses in the block currently in use0 to 100 · optional | 12.7 |
dhcp_lease_count | integer | Number of active DHCP/DHCPv6 leases in this block0 or more · optional | 0 |
| Dates and times 2 columns | |||
allocation_date | date | Date when the block was allocatedoptional | 2002-03-15 |
dhcp_lease_expiry | datetime | Latest expiry date/time for active DHCP/DHCPv6 leases in this blockoptional | 2024-08-04T15:20:00 |
| True or false 1 column | |||
dhcp_enabled | boolean | Indicates if DHCP or DHCPv6 is enabled for this blockoptional | false |
Use it for
A telecommunications dashboard
The dhcp_
enabled rate, subnet_ prefix_ length by ip_ version and a breakdown of subnet_ mask. Excel, Power BI or Tableau. Why do the 306 IPv4 rows have a mean subnet_
prefix_ length of 23.6? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Ip blocks500ARIN-RIR-000116IPv4APNIC-RIR-000332IPv6AFRINIC-RIR-000529IPv6
A software demo
Believable ip blocks with ip_
version, ip_ block and allocation_ type to fill a screen in front of a buyer.
blueprint · ip-address-management-ipam-and-allocation
Behind this dataset
Same schema. As many rows as you need.
These 500 rows came out of a blueprint — 17 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.
- IP block: CIDR notation (e.g., 198.51.100.0/24 or 2001:db8::/32)
- Address family: IPv4 or IPv6
- Allocation source: IANA, RIR (ARIN, RIPE, APNIC, LACNIC, AFRINIC)
- Service assignment: mobile data (PGW pools), broadband (BRAS/BNG), enterprise
- Subnet planning: address space segmentation by geography, technology, service
- Utilization: percentage of addresses allocated/in-use vs. available
- IPv6 deployment: dual-stack, IPv6-only, DS-Lite, 464XLAT transition mechanisms
- DHCP lease: dynamic address assignment with lease duration
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
- ip-address-management-ipam-and-allocation