On 8 Mar 2015, at 6:35 pm, Hank Nussbacher <hank@efes.iucc.ac.il> wrote:
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
Users of this report should be aware that there are some subtle deviations from this spec in the published data: - the RIPE NCC uses the non-ISO 3166 2 letter code 'EU' for some allocations. I do not know exactly why; - the date field is not quite as described in that file for ARIN entries. Again, I do not know why. - the RIPE NCC does not provide the "opaque-id" in their records