[db-wg] Whois Inverse Query by "sponsoring-org:" Attribute

For anyone else curious of this, it's relatively easy to compile such
data, here are the top (by ASN) sponsor org's in RIPE, with their ORG
object ID and org-name:, who have more than 10 sponsored ASNs:

484  ORG-IRMS1-RIPE | Internet Resources Management SRL
390  ORG-Vs35-RIPE | Vissado s.r.o.
369  ORG-ATS13-RIPE | ALFA TELECOM s.r.o.
351  ORG-RRIf1-RIPE | Autonomous Nonprofit Organisation "Russian
Scientific-Research Institute for Public Networks"
305  ORG-IL432-RIPE | i7 LLC
303  ORG-ZHL2-RIPE | Zappie Host LLC
274  ORG-SA4302-RIPE | Securebit AG
271  ORG-LL38-RIPE | LeaderTelecom Ltd.
229  ORG-CS216-RIPE | "Telecommunication Company "New Systems" Ltd
211  ORG-NTS2-RIPE | Netia SA
184  ORG-OG36-RIPE | Openfactory GmbH
159  ORG-ICL64-RIPE | Inferno Communications Ltd
154  ORG-NGs2-RIPE | NetArt Group s.r.o.
153  ORG-ML410-RIPE | Merezha LLC
138  ORG-CI9-RIPE | COLT Technology Services Group Limited
135  ORG-AS25-RIPE | Atman Sp. z o.o.
133  ORG-CR158-RIPE | Sarah Rossius
126  ORG-IML25-RIPE | IP MARKET LLC
122  ORG-RESI1-RIPE | Resilans AB
122  ORG-IG165-RIPE | iFog GmbH
118  ORG-AIL60-RIPE | August Internet Limited
106  ORG-SL1164-RIPE | Scaleblade, Ltd.
106  ORG-ITP1-RIPE | T-Mobile Polska S.A.
105  ORG-TS16-RIPE | Exatel S.A.
104  ORG-DL9-RIPE | PRIVATE JOINT STOCK COMPANY "DATAGROUP"
102  ORG-DS535-RIPE | Dyjix SAS
96  ORG-TL860-RIPE | BGP Technologies LTD
91  ORG-MN1-RIPE | A1 Bulgaria EAD
91  ORG-KL272-RIPE | Kirino LLC
86  ORG-NL5-RIPE | Cellcom Fixed Line Communication L.P
81  ORG-PMTA6-RIPE | Pascal Mathis trading as SnapServ Mathis
80  ORG-ASzo12-RIPE | ART-COM Sp. z o.o.
77  ORG-ES15-RIPE | PJSC "Vimpelcom"
76  ORG-RA21-RIPE | JSC "ER-Telecom Holding"
74  ORG-SI1-RIPE | Swisscom (Schweiz) AG
74  ORG-GATI1-RIPE | Cogent Communications Group, Inc.
72  ORG-OM1-RIPE | PJSC MegaFon
69  ORG-LA16-RIPE | SIA Tet
68  ORG-SId2-RIPE | Telekom Slovenije, d.d.
67  ORG-NL38-RIPE | Neterra Ltd.
66  ORG-LW50-RIPE | LLC WEBBER
64  ORG-PL375-RIPE | Proweb LLC
64  ORG-DNL17-RIPE | DIVERGENT NETWORKS LTD
62  ORG-TAA1-RIPE | A1 Telekom Austria AG
61  ORG-BTCP1-RIPE | Vivacom Bulgaria EAD
60  ORG-NRaA1-RIPE | NAUKOWA I AKADEMICKA SIEC KOMPUTEROWA - PANSTWOWY
INSTYTUT BADAWCZY
59  ORG-JR8-RIPE | PJSC Rostelecom
59  ORG-ICL63-RIPE | IPACCT CABLE Ltd
57  ORG-PSZO7-RIPE | P4 Sp. z o.o.
56  ORG-MSL1-RIPE | Netland ODO
55  ORG-SIOI1-RIPE | Superonline Iletisim Hizmetleri A.S.
55  ORG-RHL16-RIPE | Relcom HOST LLC
55  ORG-NLTU1-RIPE | Next Layer Telekommunikationsdienstleistungs- und
Beratungs GmbH
53  ORG-TCI1-RIPE | TANGRAM CANADA INC
52  ORG-HB116-RIPE | Hilko Boecker
51  ORG-SSN2-RIPE | SIA "BITE Latvija"
51  ORG-RBTA6-RIPE | Rick Bakker trading as Bakker IT
51  ORG-LE44-RIPE | Lir.bg EOOD
48  ORG-JCE1-RIPE | Join-stock company "Internet Exchange"MSK-IX"
48  ORG-CTIV2-RIPE | Ciklet Tasarim Iletisim ve Org. Tic. Ltd. Sti.
47  ORG-PT1-RIPE | Orange Polska Spolka Akcyjna
47  ORG-GORC1-RIPE | LLC Orange Business Services
46  ORG-VSS29-RIPE | VIRTUA SYSTEMS SAS
46  ORG-ELL9-RIPE | EURO LIR LLC
45  ORG-MCSC2-RIPE | MIHAN COMMUNICATION SYSTEMS CO.,LTD
44  ORG-SL18-RIPE | JSC "Severen-Telecom"
44  ORG-LLCD3-RIPE | Limited Liability Company DZHISIIKS
44  ORG-FRCL3-RIPE | Free Range Cloud Ltd.
43  ORG-RNB1-RIPE | Respina Networks & Beyond PJSC
43  ORG-NS275-RIPE | NETPROTECT SRL
43  ORG-LU47-RIPE | LLC "LIR UKRAINE"
43  ORG-DTA2-RIPE | Deutsche Telekom AG
42  ORG-ZM1-RIPE | MTS PJSC
40  ORG-SA59-RIPE | SOFTNET d.o.o.
39  ORG-WUL8-RIPE | Wnet Ukraine LLC
39  ORG-NL535-RIPE | Netex Limited
39  ORG-LSzo6-RIPE | Leon Sp. z o.o.
38  ORG-CL253-RIPE | Comfortel Ltd.
37  ORG-TSTA7-RIPE | Tomasz SLASKI trading as SKONET ISP
37  ORG-Td6-RIPE | T-2, d.o.o.
37  ORG-NAL1-RIPE | Evolink AD
37  ORG-AI97-RIPE | Asociatia Interlan
36  ORG-IL9-RIPE | Bezeq International Ltd.
35  ORG-ZNL7-RIPE | UPSTREAM NETWORK LTD
35  ORG-TMHB2-RIPE | The Mastermind Holding B.V.
35  ORG-HTM1-RIPE | Magyar Telekom plc.
35  ORG-bIHA1-RIPE | Vodafone Net Iletisim Hizmetler AS
34  ORG-CR1-RIPE | Federal State Institution "Federal Scientific
Research Institute for System Analysis of the Russian Academy of
Sciences"
33  ORG-MSN7-RIPE | Marco Sandro Naef
33  ORG-CTP1-RIPE | Sunrise GmbH
33  ORG-ACP10-RIPE | AS207960 Cyfyngedig
32  ORG-KNET2-RIPE | Kyiv Optic Networks ltd
31  ORG-SESa1-RIPE | State Enterprise Scientific and Telecommunication
Centre "Ukrainian Academic and Research Network" of the Institute for
Condensed Matter Physics of the National Academy of Science of Ukraine
(UARNet)
31  ORG-NI9-RIPE | Virgin Media Limited
30  ORG-MBC3-RIPE | Moe BGP Co.
30  ORG-KL211-RIPE | K-Link LLC
30  ORG-DL91-RIPE | Dataline LLC
29  ORG-LDC1-RIPE | Scientific -Industrial Firm "Volz" Ltd
29  ORG-LA684-RIPE | Pitline Ltd
29  ORG-ICL2-RIPE | EXA Infrastructure UK Limited
28  ORG-VGd1-RIPE | A1 Hrvatska d.o.o.
28  ORG-OPB1-RIPE | Broadband Hosting B.V.
28  ORG-NO3-RIPE | NAVIGATOR - ONLINE TOV
28  ORG-HTI1-RIPE | Horyzont Technologie Internetowe sp.z.o.o.
28  ORG-CS384-RIPE | CELYA SAS
27  ORG-TDE1-RIPE | TELEFONICA DE ESPANA S.A.U.
27  ORG-SA58-RIPE | Vetenskapsradet / SUNET
27  ORG-HSL55-RIPE | HostUS Solutions LLC
27  ORG-GRaT1-RIPE | National Infrastructures for Research and Technology S.A.
27  ORG-DNJ1-RIPE | LLC Digital Network
26  ORG-ZDL18-RIPE | Zero Distance LLC
26  ORG-SI241-RIPE | Staclar, Inc.
26  ORG-RA19-RIPE | Institutul National de Cercetare-Dezvoltare in
informatica - ICI Bucuresti
26  ORG-FS5-RIPE | Nova Telecommunications & Media Single Member S.A
25  ORG-TKSz1-RIPE | TK Telekom sp. z o.o.
25  ORG-SPA43-RIPE | SWAN, a.s.
25  ORG-NANa1-RIPE | National Academic Network and Information Center
25  ORG-LL377-RIPE | LIR LLC
25  ORG-GA85-RIPE | GlobalConnect A/S
25  ORG-dszo13-RIPE | dcenter.pl sp. z o.o.
24  ORG-WA48-RIPE | WEBDISCOUNT GmbH & Co. KG
24  ORG-TA44-RIPE | Tele2 Sverige AB
24  ORG-NA41-RIPE | LLC "Nauka-Svyaz"
24  ORG-LSMS1-RIPE | LNK SYSTEMS MUNTENIA SRL
24  ORG-DC2-RIPE | Invitech ICT Services Kft.
24  ORG-CSL28-RIPE | CrimeaCom South LLC
24  ORG-CAGf1-RIPE | Hutchison Drei Austria GmbH
23  ORG-UTKS1-RIPE | P4 Sp. z o.o.
23  ORG-TTL21-RIPE | Transit Telecom LLC
23  ORG-MA1574-RIPE | MilkyWan Association
23  ORG-KG4-RIPE | 1&1 Versatel Deutschland GmbH
23  ORG-ITB6-RIPE | Internetten Teknoloji Bilisim Sanayi ve Ticaret Ltd. Sti.
23  ORG-FL14-RIPE | Filanco LLC
23  ORG-AL909-RIPE | DAOport Internet Infrastructure Holdings Limited
22  ORG-VI4-RIPE | Limited Liability Company "KYIVSKI
TELEKOMUNIKATSIYNI MEREZHI"
22  ORG-TUoG1-RIPE | Technical University of Gdansk, Academic Computer
Center TASK
22  ORG-Sd13-RIPE | Stelkom d.o.o.
22  ORG-PINl1-RIPE | Petersburg Internet Network ltd.
21  ORG-RSzo5-RIPE | Rybnet Sp. z o.o. Sp. k.
21  ORG-PS3-RIPE | VODAFONE-PANAFON HELLENIC TELECOMMUNICATIONS COMPANY SA
21  ORG-FA14-RIPE | PRIVATE JOINT-STOCK COMPANY "FARLEP-INVEST"
21  ORG-BPIS1-RIPE | British Telecommunications PLC
21  ORG-ANN1-RIPE | Science Production Company "Trifle" Ltd.
20  ORG-VNS2-RIPE | Prime Telecom srl
20  ORG-TA45-RIPE | Telia Company AB
20  ORG-NA318-RIPE | "NOVATEL" EOOD
20  ORG-LIGC3-RIPE | meerfarbig GmbH & Co. KG
20  ORG-KL71-RIPE | KIEVLINE LLC
20  ORG-GVNG1-RIPE | euNetworks GmbH
20  ORG-CA1293-RIPE | JSC "RetnNet"
19  ORG-YN2-RIPE | BeotelNet-ISP d.o.o
19  ORG-VF1-RIPE | Societe Francaise Du Radiotelephone - SFR SA
19  ORG-TTHL1-RIPE | TELNET TELEKOM HIZMETLERI ANONIM SIRKETI
19  ORG-SIS76-RIPE | SC ITNS.NET SRL
19  ORG-SF2-RIPE | LLC "FTICOM"
19  ORG-PMAV1-RIPE | Aleksandr Valerevich Mokhonko
19  ORG-MM631-RIPE | Mike Marchal
19  ORG-LT1-RIPE | Telia Lietuva, AB
19  ORG-ICG9-RIPE | ip-it consult GmbH
19  ORG-FTC1-RIPE | Fast Communication Company Ltd
19  ORG-DM262-RIPE | Daniel Mishayev
19  ORG-DL1-RIPE | Deninet KFT
19  ORG-AGB11-RIPE | Access2.IT Group B.V.
18  ORG-sTSA1-RIPE | Sunrise GmbH
18  ORG-SA28-RIPE | Telia Finland Oyj
18  ORG-Ra2-RIPE | T-Mobile Czech Republic a.s.
18  ORG-Qacl1-RIPE | Internet Binat Ltd
18  ORG-PCL2-RIPE | Partner Communications Ltd.
18  ORG-MS110-RIPE | OPDOP SCIC
18  ORG-GTS2-RIPE | GTS Telecom SRL
18  ORG-CA35-RIPE | JSC Comcor
17  ORG-Ks27-RIPE | Connected sp. z o. o.
17  ORG-KOVN1-RIPE | KPN B.V.
17  ORG-IA34-RIPE | Telecom Italia S.p.A.
17  ORG-ETS1-RIPE | TENNET TELECOM SRL
17  ORG-ABL21-RIPE | ANT BM Limited
16  ORG-STL120-RIPE | Syntegra Telecom LLC
16  ORG-MNI3-RIPE | Misaka Network, Inc.
16  ORG-LB21-RIPE | LeaderTelecom B.V.
16  ORG-JA30-RIPE | Free Pro SAS
16  ORG-IA28-RIPE | Hrvatski Telekom d.d.
16  ORG-EUL9-RIPE | EUROLINE UKRAINE LLC
15  ORG-UA24-RIPE | Verizon UK Limited
15  ORG-TD1-RIPE | TDC Holding A/S
15  ORG-SdTS10-RIPE | Serviciul de Telecomunicatii Speciale
15  ORG-RA159-RIPE | LLC Renome-Service
15  ORG-PBB4-RIPE | Prefix Broker BV
15  ORG-LUL21-RIPE | Lamis Ukraine LLC
15  ORG-LT104-RIPE | LLC "Internet Tehnologii"
15  ORG-LNS13-RIPE | LIR NETSERV S.R.L.
15  ORG-GSZO38-RIPE | INET GROUP Sp. z o.o.
15  ORG-GCN3-RIPE | Global Communication Net Plc
15  ORG-GCI2-RIPE | GTT Communications Inc.
15  ORG-FISS1-RIPE | France IX Services SASU
15  ORG-CTTA1-RIPE | Cinzia Tocci trading as C1V
15  ORG-CJSC19-RIPE | Joint Stock Company TransTeleCom
15  ORG-CA932-RIPE | TOSE'EH ERTEBATAT NOVIN ARIA CO PJS
14  ORG-TL254-RIPE | Telecom-Birzha, LLC
14  ORG-SKmS1-RIPE | Serbia BroadBand-Srpske Kablovske mreze d.o.o.
14  ORG-LNL2-RIPE | Lucky Net Ltd
14  ORG-LI85-RIPE | LLC IT-service
14  ORG-KC7-RIPE | Viva Armenia CJSC
14  ORG-HUBS1-RIPE | High-Speed Universal Broadband Services C.I.C.
14  ORG-FG2-RIPE | OOO FREEnet Group
14  ORG-CTA2-RIPE | Cyprus Telecommunications Authority
14  ORG-CJcA1-RIPE | JSC Avantel
14  ORG-BA18-RIPE | UAB "Baltnetos komunikacijos"
14  ORG-AA1-RIPE | ACONET
13  ORG-UL225-RIPE | "GIGATRANS UKRAINE", LLC
13  ORG-STC2-RIPE | Smart Telecom Limited
13  ORG-RO57-RIPE | Remzi Ozkarabulut
13  ORG-RA18-RIPE | RCS & RDS SA
13  ORG-PDI1-RIPE | Data Internet Ltd
13  ORG-NTG3-RIPE | Zayo Infrastructure France SA
13  ORG-IS39-RIPE | Inrete s.r.l
13  ORG-IL687-RIPE | IPXO LIMITED
13  ORG-HA7-RIPE | Hrvatski Telekom d.d.
13  ORG-GTA36-RIPE | GEO TEKNOLOJI A.S
13  ORG-GS42-RIPE | ARTOS a.s.
13  ORG-FACL1-RIPE | Farhang Azma Communications Company LTD
13  ORG-ERS6-RIPE | Euroweb Romania S.R.L.
13  ORG-AGL35-RIPE | Alex Group LLC
12  ORG-VS282-RIPE | Vedege SAS
12  ORG-TLTA1-RIPE | Tomasz Ludwiczak trading as WITRYNA.PL
12  ORG-Tc5-RIPE | Siberian Telecommunications Ltd.
12  ORG-SN10-RIPE | TurkNet Iletisim Hizmetleri A.S.
12  ORG-SGMI1-RIPE | Sileman Sp. z o.o.
12  ORG-RA25-RIPE | JSC RTComm.RU
12  ORG-NBvT1-RIPE | Netinternet Bilisim Teknolojileri AS
12  ORG-MW1-RIPE | Drustvo za telekomunikacije Orion telekom doo Beograd-Zemun
12  ORG-MAT1-RIPE | Vodafone GmbH
12  ORG-KNKP1-RIPE | Kavoshgaran Novin Karamad Co. Ltd
12  ORG-JM2-RIPE | JSC Mastertel
12  ORG-GISA2-RIPE | GleSYS AB
12  ORG-CNS3-RIPE | British Telecommunications PLC
12  ORG-CJ2-RIPE | CRELCOM LLC
11  ORG-VCL9-RIPE | VeloxServ Communications Ltd
11  ORG-UTGL1-RIPE | Ukrainian Telecommunication Group LLC
11  ORG-UFW1-RIPE | Verizon France SAS
11  ORG-UA23-RIPE | Jisc Services Limited
11  ORG-SNTL8-RIPE | Sindad Network Technology Ltd.
11  ORG-SA635-RIPE | S-NET Sp. z o.o.
11  ORG-RSL38-RIPE | Redcentric Solutions Ltd
11  ORG-RL19-RIPE | RETN Limited
11  ORG-PP3-RIPE | MEO - SERVICOS DE COMUNICACOES E MULTIMEDIA S.A.
11  ORG-PICL3-RIPE | PS Internet Company LLP
11  ORG-OTL24-RIPE | Osbil Technology Ltd.
11  ORG-NSA120-RIPE | NASK Spolka Akcyjna
11  ORG-nrRL1-RIPE | "Domain names registrar REG.RU", Ltd
11  ORG-MMIA3-RIPE | myLoc managed IT AG
11  ORG-LOIT4-RIPE | Laboratory of Information Technologies LLC
11  ORG-KG8-RIPE | "Kyivstar" PJSC
11  ORG-JTSG1-RIPE | JMP Technology Services GmbH
11  ORG-JR5-RIPE | RISE LTD
11  ORG-ITS10-RIPE |
11  ORG-ISZO9-RIPE | INSITE Sp. z o.o.
11  ORG-INS1-RIPE | Cooolbox AD
11  ORG-IJ3-RIPE | Joint Ukrainan-German Enterprise "INFOCOM" LLC
11  ORG-IA30-RIPE | Institute for Research in Fundamental Sciences
11  ORG-GI12-RIPE | UAB Porenta
11  ORG-eszo2-RIPE | eTOP sp. z o.o.
11  ORG-EO1-RIPE | Elisa Oyj
11  ORG-DIE3-RIPE | Dolphin IT-Systeme e.K.
11  ORG-DE13-RIPE | OPTICCOM- BULGARIA Ltd.
11  ORG-BIA1-RIPE | Bahnhof AB
11  ORG-ATS4-RIPE | Vodafone Romania S.A.
11  ORG-AL319-RIPE | ATOMOHOST LLC
11  ORG-AAL2-RIPE | Andrews & Arnold Ltd
11  ORG-AA45-RIPE | ORANGE ROMANIA COMMUNICATION S.A
10  ORG-UD1-RIPE | Verizon Deutschland GmbH
10  ORG-TZ1-RIPE | Telediscount AO
10  ORG-TTS68-RIPE | Teen Telecom SRL
10  ORG-TTG2-RIPE | TelemaxX Telekommunikation GmbH
10  ORG-STaN1-RIPE | O2 Czech Republic, a.s.
10  ORG-SG364-RIPE | Sebastian-Wilhelm Graf
10  ORG-Sd2-RIPE | A1 Slovenija telekomunikacijske storitve,d.d.
10  ORG-RL441-RIPE | RECONN LLC
10  ORG-RI9-RIPE | ADISTA SAS
10  ORG-PSG2-RIPE | Plus.line AG
10  ORG-PNSP1-RIPE | Parsun Network Solutions PTY LTD
10  ORG-NRC2-RIPE | NetOne Rus JSC
10  ORG-NG11-RIPE | NetCologne Gesellschaft fur Telekommunikation mbH
10  ORG-NCS28-RIPE |
10  ORG-ML153-RIPE | MOBICOM Ltd.
10  ORG-FSZO2-RIPE | Hawe Telekom S.A. in Restructuring
10  ORG-EG4-RIPE | T-Mobile Polska S.A.
10  ORG-DF111-RIPE | David Froehlich
10  ORG-BTHA1-RIPE | Superonline Iletisim Hizmetleri A.S.
10  ORG-AL433-RIPE | Alliance LLC


On Fri, 5 Apr 2024 at 17:08, Sergey Myasoedov via db-wg <db-wg at ripe.net> wrote:
>
> Hi,
>
> Good idea, thank you. It will be easier to find the "most supportive" LIRs and understand how did they manage to get the biggest amount of customers.
>
>
> --
> Sergey
>
> > On Apr 5, 2024, at 08:08, Edward Shryane via db-wg <db-wg at ripe.net> wrote:
> >
> > Dear colleagues,
> >
> > Currently, Whois query does not support the "sponsoring-org:" attribute in an inverse query, i.e. to find all resources sponsored by an organisation.
> >
> > The "sponsoring-org:' attribute was added to the RIPE database in these policies, but there's no mention of support for inverse queries:
> >
> > 2012-08: https://www.ripe.net/membership/policies/proposals/2012-08/
> > 2014-06: https://www.ripe.net/membership/policies/proposals/2014-06/
> >
> > If there is no objection, I propose for consistency to also add "sponsoring-org:" to the list of inverse query attributes.
> >
> > Regards
> > Ed Shryane
> > RIPE NCC
> >
> >
> > --
> >
> > To unsubscribe from this mailing list, get a password reminder, or change your subscription options, please visit: https://mailman.ripe.net/
>
>
> --
>
> To unsubscribe from this mailing list, get a password reminder, or change your subscription options, please visit: https://mailman.ripe.net/