[db-wg] Removing personal data from bulk output from the RIPE Database

On May 10, 2013, at 9:37 AM, Tore Anderson <tore at fud.no> wrote:

> «How many IPv4 PA Assignments have been made by RIPE NCC LIRs since the
> 14th of September 2012? (If possible, but less important: How many
> addresses did these assignments consist of, in total?)»

Hi Tore,

Under 20,549 Allocations provided by RIPE NCC (total of 594,469,888 addresses), there are 3,596,598 first level child assignment objects (total of 459,629,744 addresses) and out of those, 251,254 objects (total of 26,147,674 addresses) are created on or after 14th of September 2012.

Here is how I did generate the numbers using the standard whois:

a) I have downloaded latest version of RIPE NCC Delegated extended stats file (ftp://ftp.ripe.net/ripe/stats/delegated-ripencc-extended-latest)
b) For each IPv4 resource in the file with the status "allocated" I have queried the RIPE Database for one level more specific "inetnum" objects
c) For each of those objects, I have ran a "--list-versions" query, picked the first revision and compared the date with 14th of September 2012

Kind Regards,
Kaveh.

---
Kaveh Ranjbar,
RIPE NCC Database Group Manager

-------------- next part --------------
An HTML attachment was scrubbed...
URL: </ripe/mail/archives/db-wg/attachments/20130510/e9621209/attachment.html>