Hi Tore,

I wanted to research all the details and wait for some developments to unfold before replying to the list. 

As Mirjam just posted, Daniel published a RIPE Labs article describing a way for members to look at registration history in RIPEstat:
https://labs.ripe.net/Members/dfk/registration-history-for-members-a-demo

An important point Daniel makes in the article is "We would like to demonstrate what we can make available if there is consensus among the membership that we should." 

The way the information in RIPEstat is presented, is that a member can only do a query on a single prefix at a time, with restrictions in place to prevent excessive resource usage. One of the implementation suggestions you do in your email, is to *publicly* present historic data in *aggregate form*, for example by publishing historic versions of alloclist.txt. 

This goes quite a bit further than what we are demoing in RIPEstat at the moment. We will definitely need more discussion on this topic to make sure there is consensus on what exactly we should offer. 

Cheers,

Alex

On 5 Sep 2012, at 09:44, Tore Anderson <tore.anderson@redpill-linpro.com> wrote:

* Alex Band

Could you give us some context how you would want to use this data,
and what you currently are not capable of doing using for example the
RIPE Database?

Hi,

Take a look at proposal 2012-05 in apwg. One of its goals is to ensure
that the origin and recipient of allocation transfers are public
information. I agree with this goal, and will likely find it very
interesting to follow transfers happening in the coming months.

Much of this information is already easily available on the FTP,
however. The name and reg-id of the holding LIR are available in
alloclist.txt, while the prefix and date of allocation is available in
both alloclist.txt and delegated-ripencc-extended-latest. The only thing
I cannot easily find, is the historic information of which LIR held an
allocation previously. (If I have simply missed it, please point me to
it and stop reading.)

It occurs to me that by adding a LIR/reg-id column in
delegated-ripencc-extended-latest, and/or to publish historic versions
of alloclist.txt, the information sought by 2012-05 (and as an added
bonus, information about the origin of returned resources) would be
easily obtainable from the FTP. To avoid any privacy issues, the
LIR/reg-id column in the delegated file could be left empty for assigned
resources - I believe that would mean that no previously unpublished
information would need to be made public. Is this doable, you think?

Best regards,
--
Tore Anderson
Redpill Linpro AS - http://www.redpill-linpro.com