Thanks for the heads-up Sivasubramanian! I'm sorry I cannot help you further as I cannot reproduce your issue. I do see more than 5,000 rows in the file you attached.
Warm regards, Sofía On 13/5/20, 5:17 pm, "sivasubramanian muthusamy" <[email protected]> wrote: Dear Sofia, Replied as below, with an attachment, but the attachment did not go through. Must have reached your personal mail box. In any case please see below. It is most likely that it is NOT your mistake. Thank you On Wed, May 13, 2020 at 11:25 AM sivasubramanian muthusamy <[email protected]> wrote: 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 <[email protected]> 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, "[email protected] on behalf of sivasubramanian muthusamy" <[email protected] on behalf of [email protected]> wrote: Dear Tony Smith, On Wed, May 13, 2020 at 6:07 AM Tony Smith <[email protected]> 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 <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 <[email protected]> Date: Tuesday, 12 May 2020 at 4:41 pm To: Tony Smith <[email protected]> Cc: "[email protected]" <[email protected]> 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/ <https://www.linkedin.com/in/sivasubramanianmuthusamy/> mailto:[email protected] http://twitter.com/shivaindia On Tue, May 12, 2020 at 11:47 AM Tony Smith <mailto:[email protected]> 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> <https://directory.apnic.net/delegations/Southern> Asia/IN Thanks Tony From: <mailto:[email protected]> on behalf of sivasubramanian muthusamy <mailto:[email protected]> Date: Tuesday, 12 May 2020 at 4:09 pm To: "mailto:[email protected]"; <mailto:[email protected]> Subject: [apnic-talk] Fwd: Apnic fees for IPv4 / v6 ---------- Forwarded message --------- From: sivasubramanian muthusamy <mailto:[email protected]> Date: Thu, May 7, 2020, 19:25 Subject: Apnic fees for IPv4 / v6 To: <mailto:[email protected]> 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 _______________________________________________ apnic-talk mailing list [email protected] https://mailman.apnic.net/mailman/listinfo/apnic-talk
