nanog mailing list archives
Re: ASN to IP Mapping
From: Hank Nussbacher <hank () efes iucc ac il>
Date: Sun, 08 Mar 2015 09:35:58 +0200
At 14:37 08/03/2015 +1100, Geoff Huston wrote:
> On 8 Mar 2015, at 1:39 pm, Randy Bush <randy () psg com> wrote: > >> If you want to know the registry assignments / allocations made to a >> single entity and be able group together these assignments of address >> prefixes and ASNs you should retrieve the combined extended stats file >> from the RIRs >> (https://www.nro.net/wp-content/uploads/apnic-uploads/delegated-extended) >> and group together all those entries with a common value in column 8 >> (except for the entries corresponding to assignments and allocations >> made by the RIPE NCC, where this information is, unfortunately, not >> published by them in such a convenient format.) > > care to give a decode for the fields in that file? :) sure, I'll try.
Or: https://www.nro.net/wp-content/uploads/nro-extended-stats-readme5.txt -Hank
for example: arin|US|asn|32|1|19840924|assigned|658cc9c515b51665f88b7fd1bc213d20|e-stats Col 1 - RIR name, or 'iana'Col 2 - The country where the entity 'resides' (or 'EU' in some cases), or 'ZZ' for reserved and unassigned blocksCol 3 - 'asn' or 'ipv4' or 'ipv6' Col 4 - The size of the allocation (asn or IPv4) or the prefix length (ipv6) Col 5 - The starting value of the blockCol 6 - A date. For some registries this is the date of the original allocation - for others (ARIN) its not so clear precisely what this date signifies (!)Col 7 - Status of the blockCol 8 - A hash field of the entity code (mu;ltiple allocations to the same entity have the same code) or null (RIPE NCC, IANA) Col 9 - The source of the record (either "e-stats' where the original source is an extended stats file published by an RIR, or 'iana' if the data is lifted from an IANA registry)
Current thread:
- Re: ASN to IP Mapping, (continued)
- Re: ASN to IP Mapping Christopher Morrow (Mar 07)
- Re: ASN to IP Mapping Mansoor Nathani (Mar 07)
- Re: ASN to IP Mapping Pedro Cavaca (Mar 07)
- Re: ASN to IP Mapping Rubens Kuhl (Mar 07)
- Re: ASN to IP Mapping Bob Evans (Mar 07)
- Re: ASN to IP Mapping Geoff Huston (Mar 07)
- Re: ASN to IP Mapping Randy Bush (Mar 07)
- Re: ASN to IP Mapping Geoff Huston (Mar 07)
- Re: ASN to IP Mapping Christopher Morrow (Mar 07)
- Re: ASN to IP Mapping Randy Bush (Mar 07)
- Re: ASN to IP Mapping Hank Nussbacher (Mar 07)
- Re: ASN to IP Mapping Geoff Huston (Mar 08)
- Re: ASN to IP Mapping Hank Nussbacher (Mar 08)
- Re: ASN to IP Mapping David Conrad (Mar 08)
- Re: ASN to IP Mapping John McCormac (Mar 08)