Dear Sofia,If it is working for you, the limitations I have experienced were because of the steps I had to follow in opening the file. I was on India specific view, though the URL didn't say India ( https://stats.apnic.net/holders/Southern%20Asia/IN ), the file did not open in my Android phone, downloaded it on a Chrome Book from that India specific page with the page title "Summary Holder Information for India", the file downloaded with the name "summary_holder-info-for-southern asia" without the filetype in the file name, I renamed it summary_holder-info-for-southern asia.csv, opened it with Google Sheets, which shows 132755 in Column Q as the last entry. The file as I downloaded and renamed is attached, I downloaded it once again now, followed the same process by giving the file extension .xls, Google Docs still shows the 5000th row as the last row, so this must be a limitation on the cloud.On Wed, May 13, 2020 at 9:26 AM Sofia Silva Berenguer <sofia@apnic.net> wrote:Dear Sivasubramanian,
My name is Sofía. I'm the Product Manager for the Internet Directory.
There is no max limit for the number of entries in the spreadsheet. If you are interested in the Holders list for IPv4 resources in India, I would recommend selecting India in the left side menu (either by clicking on India in the hierarchical menu or by entering India in the search field) and then selecting the IPv4 tab in the grey area on the top of the screen. This will show a table with 416 pages. I have just downloaded it and I got 6,233 rows in the spreadsheet. I do see Bharti Airtel in the spreadsheet, so I'm wondering whether you had some other filter applied to the Holders table you were visualizing?
I hope this helps.
Warm regards,
Sofía
On 13/5/20, 11:59 am, "apnic-talk-bounces@lists.apnic.net on behalf of sivasubramanian muthusamy" <apnic-talk-bounces@lists.apnic.net on behalf of 6.internet@gmail.com> wrote:
Dear Tony Smith,
On Wed, May 13, 2020 at 6:07 AM Tony Smith <tony@apnic.net> wrote:
Hi Sivasubramanian,
Logging in with an APNIC Login to the Internet Directory link will allow you to see the Holders view which offers a table with more information about entities that hold space in an economy and what space they hold. An APNIC login is free and easy to set up.
https://beta-login.apnic.net/auth/realms/apnic/login-actions/registration?client_id=internet-directory&tab_id=Za5Rf2MDDr0
However APNIC does not have data about how the IP addresses are used, especially in terms of NAT and dynamic addresses.
Thank you :) It worked. APNIC maintains good transparency. Downloaded a holder's view spread sheet with 5000 entries (Spreadsheet max limit ?) with 5000 entries, of which I could see none that said Airtel or Bharti Airtel, which is strange, and of the
remaining out of the 5000 entries in this possibly truncated sheet, 3707 entries were that of NIXI, mostly /22s, less than a hundred or so entries showed Jio, about a hundred for Tatas, and others were mostly business enterprises, about seventy or eighty of
them. As the table showed a combined view of v4, v6 and ASNs, and showed /24 - 16s all in one column, there is no way of totalling the allocation, especially due to the possibility that this is truncated data. And, as you have observed, there is no indication
of how the IP addresses were reassigned and to how many different networks / nodes (the total number of unique networks with static IP addresses in India). Probably the same level of data in all RIRs.
I got into some detail here, but the purpose is not to focus on a few ISPs / Exchanges, but rather to see if there is a general tendency (everywhere) to retain IP addresses by the holders within their network rather than to reallot a fair number of the
addresses.
Thank you.
Thanks
Tony
From: sivasubramanian muthusamy <6.internet@gmail.com>
Date: Tuesday, 12 May 2020 at 4:41 pm
To: Tony Smith <tony@apnic.net>
Cc: "apnic-talk@lists.apnic.net" <apnic-talk@lists.apnic.net>
Subject: Re: [apnic-talk] Fwd: Apnic fees for IPv4 / v6
Thank you. The link pointed me to the information I was looking for, and I could get to the spreadsheet attached. But the data does not contain any information about what happens after the IPv4 addresses are assigned by APNIC (or other RIRs). Is there any data
available, or some form of assessment about how many unique / static assignees are in India, and what portion of these allocations are retained by the large networks and used by NAT and other means as dynamic addresses?
https://www.linkedin.com/in/sivasubramanianmuthusamy/
mailto:6.Internet@gmail.com
http://twitter.com/shivaindia
On Tue, May 12, 2020 at 11:47 AM Tony Smith <mailto:tony@apnic.net> wrote:
Hi Sivasubramanian,
You may find the delegation statistics available here useful. There’s several data visualisation tools and the data is downloadable:
https://directory.apnic.net/delegations/Southern <https://directory.apnic.net/delegations/Southern> Asia/IN
Thanks
Tony
From: <mailto:apnic-talk-bounces@lists.apnic.net> on behalf of sivasubramanian muthusamy <mailto:6.internet@gmail.com>
Date: Tuesday, 12 May 2020 at 4:09 pm
To: "mailto:apnic-talk@lists.apnic.net" <mailto:apnic-talk@lists.apnic.net>
Subject: [apnic-talk] Fwd: Apnic fees for IPv4 / v6
---------- Forwarded message ---------
From: sivasubramanian muthusamy <mailto:6.internet@gmail.com>
Date: Thu, May 7, 2020, 19:25
Subject: Apnic fees for IPv4 / v6
To: <mailto:apnic-talk@lists.apnic.net>
Is there any published data on the total size of IP addresses allotted, for instance, to networks in India and the number of 'unique assignees' in India?
Thank you.
Sivasubramanian M