* How should location-importer.in deal with RIR objects having multiple distinct "country" fields?
@ 2021-05-03 20:56 Peter Müller
2021-05-04 8:07 ` Michael Tremer
0 siblings, 1 reply; 5+ messages in thread
From: Peter Müller @ 2021-05-03 20:56 UTC (permalink / raw)
To: location
[-- Attachment #1: Type: text/plain, Size: 5777 bytes --]
Hello Michael,
hello location folks (CC'ed),
unfortunately, another problem surfaces when processing inetnum and inet6num feeds from RIRs
which provide that kind of more precise data: A decent amount of network objects have multiple
distinct "country" fields.
Here is an example:
> inetnum: 178.79.192.0 - 178.79.255.255
> netname: EU-LLNW-20100512
> country: EU
> country: SE
> country: DE
> country: NL
> country: GB
> country: ES
> country: FR
> country: IT
> org: ORG-LNI1-RIPE
> admin-c: GU2143-RIPE
> tech-c: GU2143-RIPE
> status: ALLOCATED PA
> remarks: ****************** ABUSE COMPLAINTS TO: abuse(a)limelightnetworks.com
> mnt-by: RIPE-NCC-HM-MNT
> mnt-by: LLNW-MNT
> mnt-domains: LLNW-MNT
> mnt-routes: LLNW-MNT
> created: 2010-05-12T16:20:38Z
> last-modified: 2017-09-01T17:39:08Z
> source: RIPE # Filtered
Currently, the last country item is made persistent via the SQL INSERT statement. Since these do
not appear to be sorted in any way, this makes things completely nondeterministic.
The network above would be, however, recoverable: If we do not interpret "EU" as the European Union,
but rather as the European country, all other country codes given here would be covered by it.
Alas, this is not helping in cases such as these two:
> Country of network [IPv4Network('77.74.172.0/23')] already set to 'CH', omitting 'FI' (multiple country lines in RIR data?)
> Country of network [IPv4Network('185.253.140.0/24')] already set to 'GB', omitting 'NL' (multiple country lines in RIR data?)
> Country of network [IPv4Network('185.253.140.0/24')] already set to 'GB', omitting 'US' (multiple country lines in RIR data?)
> Country of network [IPv4Network('213.230.255.0/24')] already set to 'GB', omitting 'US' (multiple country lines in RIR data?)
> Country of network [IPv4Network('213.230.255.0/24')] already set to 'GB', omitting 'JP' (multiple country lines in RIR data?)
> Country of network [IPv4Network('213.230.255.0/24')] already set to 'GB', omitting 'SG' (multiple country lines in RIR data?)
> Country of network [IPv4Network('213.230.255.0/24')] already set to 'GB', omitting 'AU' (multiple country lines in RIR data?)
> Country of network [IPv4Network('213.230.255.0/24')] already set to 'GB', omitting 'NL' (multiple country lines in RIR data?)
> Country of network [IPv4Network('213.230.255.0/24')] already set to 'GB', omitting 'FR' (multiple country lines in RIR data?)
> Country of network [IPv4Network('213.230.255.0/24')] already set to 'GB', omitting 'DE' (multiple country lines in RIR data?)
> Country of network [IPv4Network('193.109.168.0/22')] already set to 'GB', omitting 'US' (multiple country lines in RIR data?)
There are _plenty_ of such networks, I believe RIPE IPv4 only fills several screen pages. Nothing
in life is ever easy, and parsing RIR data definitely isn't... :-/
Delegating the task of handling such situations to the application using libloc does not make sense
to me, as people are _expecting_ precise answers from it - if we can use the term of preciseness here
at all -, otherwise, they could simply parse RIR data on their own. Therefore, we have to somehow make
do with this. Possible options would be as follows:
(a) We do not process such networks entirely. If a network operator wants to have his/her network
covered by libloc, he/she/it should kindly fix it's RIR data.
That would not prevent us from obtaining announcements for such networks, but we would not label
them with any country anymore.
(b) We try to automatically determine meaningful codes in each case.
This is tricky and not very deterministic. What about a network having "CY" and "TR" set? Would that
be covered by "EU"?
213.230.255.0/24 seems to be used worldwide, but in my point of view, this is not sufficient to
classify it as an anycast network. Worse, we have or should assign a country code to anycast networks
as well.
(c) We try to determine the jurisdiction of a networks' organisation handle.
Frankly, I have no idea what problems would arise in this case. If an organisation fails to provide
accurate and meaningful RIR data, what will their organisation handle possibly look like?
Trying to keep things deterministic, (a) is my current favorite - it is the most brutal, though.
Do you see a better way of dealing with such networks?
@All: Thoughts? Comments? Opinions?
Thanks, and best regards,
Peter Müller
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: How should location-importer.in deal with RIR objects having multiple distinct "country" fields?
2021-05-03 20:56 How should location-importer.in deal with RIR objects having multiple distinct "country" fields? Peter Müller
@ 2021-05-04 8:07 ` Michael Tremer
2021-05-06 21:06 ` List of IP networks having more than one country assigned to (was: Re: How should location-importer.in deal with RIR objects having multiple distinct "country" fields?) Peter Müller
0 siblings, 1 reply; 5+ messages in thread
From: Michael Tremer @ 2021-05-04 8:07 UTC (permalink / raw)
To: location
[-- Attachment #1: Type: text/plain, Size: 8780 bytes --]
Hey Peter,
> On 3 May 2021, at 21:56, Peter Müller <peter.mueller(a)ipfire.org> wrote:
>
> Hello Michael,
> hello location folks (CC'ed),
>
> unfortunately, another problem surfaces when processing inetnum and inet6num feeds from RIRs
> which provide that kind of more precise data: A decent amount of network objects have multiple
> distinct "country" fields.
First of all, don’t panic. We noticed this before and we decided to go with an easy solution for now.
It probably is now time to revisit this and see if we can improve. Although you might have seen many hits when checking for multiple countries, I am sure that there is only a small number of networks (relatively speaking).
> Here is an example:
>
>> inetnum: 178.79.192.0 - 178.79.255.255
>> netname: EU-LLNW-20100512
>> country: EU
>> country: SE
>> country: DE
>> country: NL
>> country: GB
>> country: ES
>> country: FR
>> country: IT
>> org: ORG-LNI1-RIPE
>> admin-c: GU2143-RIPE
>> tech-c: GU2143-RIPE
>> status: ALLOCATED PA
>> remarks: ****************** ABUSE COMPLAINTS TO: abuse(a)limelightnetworks.com
>> mnt-by: RIPE-NCC-HM-MNT
>> mnt-by: LLNW-MNT
>> mnt-domains: LLNW-MNT
>> mnt-routes: LLNW-MNT
>> created: 2010-05-12T16:20:38Z
>> last-modified: 2017-09-01T17:39:08Z
>> source: RIPE # Filtered
>
> Currently, the last country item is made persistent via the SQL INSERT statement. Since these do
> not appear to be sorted in any way, this makes things completely nondeterministic.
How do you know that they are not sorted?
Do you expect them to be sorted alphabetically? That wouldn’t make sense.
If the order in which they are being put in would be preserved, we can already change and use the first country code, hoping that they would have been put in in order of precedence. In this example, EU is probably the best way to say “SE, DE, NL, GB, ES, FR, IT”.
> The network above would be, however, recoverable: If we do not interpret "EU" as the European Union,
> but rather as the European country, all other country codes given here would be covered by it.
European country? Did you mean continent? Last time I checked a map, the borders were still there.
> Alas, this is not helping in cases such as these two:
>
>> Country of network [IPv4Network('77.74.172.0/23')] already set to 'CH', omitting 'FI' (multiple country lines in RIR data?)
>> Country of network [IPv4Network('185.253.140.0/24')] already set to 'GB', omitting 'NL' (multiple country lines in RIR data?)
>> Country of network [IPv4Network('185.253.140.0/24')] already set to 'GB', omitting 'US' (multiple country lines in RIR data?)
>> Country of network [IPv4Network('213.230.255.0/24')] already set to 'GB', omitting 'US' (multiple country lines in RIR data?)
>> Country of network [IPv4Network('213.230.255.0/24')] already set to 'GB', omitting 'JP' (multiple country lines in RIR data?)
>> Country of network [IPv4Network('213.230.255.0/24')] already set to 'GB', omitting 'SG' (multiple country lines in RIR data?)
>> Country of network [IPv4Network('213.230.255.0/24')] already set to 'GB', omitting 'AU' (multiple country lines in RIR data?)
>> Country of network [IPv4Network('213.230.255.0/24')] already set to 'GB', omitting 'NL' (multiple country lines in RIR data?)
>> Country of network [IPv4Network('213.230.255.0/24')] already set to 'GB', omitting 'FR' (multiple country lines in RIR data?)
>> Country of network [IPv4Network('213.230.255.0/24')] already set to 'GB', omitting 'DE' (multiple country lines in RIR data?)
>> Country of network [IPv4Network('193.109.168.0/22')] already set to 'GB', omitting 'US' (multiple country lines in RIR data?)
>
> There are _plenty_ of such networks, I believe RIPE IPv4 only fills several screen pages. Nothing
> in life is ever easy, and parsing RIR data definitely isn't... :-/
>
> Delegating the task of handling such situations to the application using libloc does not make sense
> to me, as people are _expecting_ precise answers from it - if we can use the term of preciseness here
> at all -, otherwise, they could simply parse RIR data on their own. Therefore, we have to somehow make
> do with this. Possible options would be as follows:
>
> (a) We do not process such networks entirely. If a network operator wants to have his/her network
> covered by libloc, he/she/it should kindly fix it's RIR data.
>
> That would not prevent us from obtaining announcements for such networks, but we would not label
> them with any country anymore.
This is a very bad proposal. Just because we do not have 100% confidence in the data doesn’t mean we have to drop it.
We generally can only trust the people who put the data in and that for me does not have 100% confidence. With that logic, the database would be empty.
I would also assume that someone tried to do a good job here and list all countries where infrastructure for this network is located in. That is sometimes difficult to say when you have a CDN because there are many POPs and they are probably all organised as anycasts - a very common method these days.
> (b) We try to automatically determine meaningful codes in each case.
>
> This is tricky and not very deterministic. What about a network having "CY" and "TR" set? Would that
> be covered by "EU"?
Good question. I would say yes. A continent is a good approximation.
Worse would be DE and JP. Or CN and CH. You simply cannot group them together with this logic. But I suppose there wouldn’t be too many examples like this. That there are networks spread over Europe is much more common because Europe is densely populated and because of a unified legal system and easy trade, putting servers into many countries isn’t an issue at all. We do this without even thinking about it. We just put them where our users are or where it is cheapest.
> 213.230.255.0/24 seems to be used worldwide, but in my point of view, this is not sufficient to
> classify it as an anycast network. Worse, we have or should assign a country code to anycast networks
> as well.
What is it, if not that? It technically could not be split into smaller networks. It is already /24.
> (c) We try to determine the jurisdiction of a networks' organisation handle.
>
> Frankly, I have no idea what problems would arise in this case. If an organisation fails to provide
> accurate and meaningful RIR data, what will their organisation handle possibly look like?
In the Limelight example from above, I would say US is what I would almost expect with the anycast bit set.
> Trying to keep things deterministic, (a) is my current favorite - it is the most brutal, though.
No, this is not acceptable at all.
I would be much happier with either deciding this with an override on a case by case basis, but that would be a lot of work.
> Do you see a better way of dealing with such networks?
Another automated way is to mark these networks with a “confidence” value - however that is being determined. We would then require applications to consider this value. The downside is that there cannot be much done apart from dropping the network when it is below a certain threshold or use it when confidence is high enough. That could be different for different applications and make it more difficult to implement libloc.
> @All: Thoughts? Comments? Opinions?
>
> Thanks, and best regards,
> Peter Müller
-Michael
^ permalink raw reply [flat|nested] 5+ messages in thread
* List of IP networks having more than one country assigned to (was: Re: How should location-importer.in deal with RIR objects having multiple distinct "country" fields?)
2021-05-04 8:07 ` Michael Tremer
@ 2021-05-06 21:06 ` Peter Müller
2021-05-07 10:48 ` Michael Tremer
0 siblings, 1 reply; 5+ messages in thread
From: Peter Müller @ 2021-05-06 21:06 UTC (permalink / raw)
To: location
[-- Attachment #1: Type: text/plain, Size: 30962 bytes --]
Hello Michael,
hello *,
after fiddling a bit on location02 - patch is to be followed shortly -, I thought it might be interesting
to have a complete list of IP networks having more than one country assigned to.
This is it:
> location=# SELECT network, country, original_country FROM networks WHERE array_length(original_country, 1) > 1;
>
> network | country | original_country
> ---------------------+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> 194.122.0.0/15 | DE | {DE,NL}
> 37.246.0.0/16 | TR | {TR,US,NL,DE,GB}
> 46.108.0.0/16 | DE | {DE,IE,GB}
> 62.132.0.0/16 | DE | {DE,NL}
> 81.85.0.0/16 | US | {US,NL}
> 85.205.0.0/16 | DE | {DE,IE,GB}
> 95.209.0.0/16 | DK | {DK,SE}
> 129.73.0.0/16 | CR | {CR,DO,GT,HN,MX,NI,SV,US}
> 129.214.0.0/16 | AR | {AR,BR,CL,CO,PE,UY,VE,US,DE}
> 131.176.0.0/16 | EU | {EU,AU,CA,KE,RU,US}
> 132.186.0.0/16 | AE | {AE,BH,DZ,EG,IN,KW,MA,QA,TN,ZA}
> 137.223.0.0/16 | GB | {GB,IE}
> 139.10.0.0/16 | BE | {BE,FR,NL}
> 141.11.0.0/16 | FR | {FR,GB}
> 141.29.0.0/16 | BA | {BA,GR,HR,IT,PT,SI}
> 146.253.0.0/16 | DE | {DE,SE}
> 146.254.0.0/16 | DE | {DE,SE}
> 155.190.0.0/16 | NL | {NL,GB,DE,FR,DK,CZ,PL,RO}
> 165.218.0.0/16 | DE | {DE,US}
> 193.220.0.0/16 | NO | {NO,US,FR}
> 195.73.0.0/16 | DE | {DE,NL}
> 37.25.128.0/17 | DE | {DE,IE,GB}
> 46.190.128.0/17 | DE | {DE,IE,GB}
> 77.67.0.0/17 | DE | {DE,SE,GR,NL,BE,AT,PL,IT,CH,NO,DK,CZ,US,CA,SK,ES,FR,GB,RO,HK,SG,IE}
> 77.70.128.0/17 | NO | {NO,US,FR}
> 85.131.128.0/17 | DE | {DE,NL}
> 87.98.0.0/17 | EE | {EE,EU}
> 131.228.0.0/17 | FI | {FI,US,DE,IN}
> 31.6.0.0/18 | GB | {GB,NL,DE,FR,IT,AE}
> 78.137.128.0/18 | IE | {IE,GB}
> 78.143.0.0/18 | DE | {DE,NL}
> 89.149.128.0/18 | DE | {DE,SE,GR,NL,BE,AT,PL,IT,CH,NO,DK,CZ,US,SK,ES,FR,GB,RO,HK,SG,IE}
> 93.183.0.0/18 | US | {US,BR,FI,DE,CN,IN,SG}
> 159.180.128.0/18 | US | {US,DE,SG,CN,JP,BR,IE,IT,PR}
> 178.79.192.0/18 | EU | {EU,SE,DE,NL,GB,ES,FR,IT}
> 193.219.192.0/18 | NO | {NO,US,FR}
> 194.93.192.0/18 | DE | {DE,IT}
> 212.111.128.0/18 | GB | {GB,FR}
> 213.200.64.0/18 | AT | {AT,BE,CA,CH,CZ,DE,DK,ES,FR,GB,GR,HK,IE,IT,NL,NO,PL,SE,SG,SK,US,RO}
> 213.254.192.0/18 | DE | {DE,SE,GR,NL,BE,AT,PL,IT,CH,NO,DK,CZ,US,SK,ES,FR,GB,RO,HK,SG,IE}
> 37.18.192.0/19 | SE | {SE,US,DE,DK}
> 46.33.64.0/19 | IE | {IE,NL,GB,HK,BE,AT,NO,DK,CA,DE,GR,SE,RO,SG,CH,IT,PL,CZ,US,ES,SK,FR}
> 62.32.32.0/19 | US | {US,NL}
> 62.128.96.0/19 | DE | {DE,EE,FI,GB,GE,LT,LV,NL,PL,RU,SE,UA,EU}
> 82.150.224.0/19 | DE | {DE,FR}
> 82.198.128.0/19 | IE | {IE,GB}
> 83.216.32.0/19 | AT | {AT,IT}
> 83.221.160.0/19 | RU | {RU,UZ}
> 87.248.192.0/19 | GB | {GB,NL,DE,FR,SE,ES,IT}
> 88.84.128.0/19 | DE | {DE,NL,GB}
> 89.21.160.0/19 | NL | {NL,US}
> 146.247.96.0/19 | AT | {AT,DE,CH,US,BR,RU,FR,IT}
> 158.255.96.0/19 | FR | {FR,DE,GB,NL,AT}
> 159.180.192.0/19 | FR | {FR,GB,ES,DE,US}
> 176.56.160.0/19 | GB | {GB,US,CY,NL}
> 193.17.96.0/19 | DE | {DE,US,SG}
> 193.202.128.0/19 | DE | {DE,US,SG}
> 193.202.160.0/19 | DE | {DE,US,SG}
> 194.34.64.0/19 | GB | {GB,US,JP,AU}
> 194.121.96.0/19 | DE | {DE,NL}
> 194.121.128.0/19 | DE | {DE,NL}
> 194.121.192.0/19 | DE | {DE,NL}
> 195.90.32.0/19 | EU | {EU,US}
> 195.222.0.0/19 | EE | {EE,EU}
> 212.27.224.0/19 | EE | {EE,EU}
> 212.47.192.0/19 | DE | {DE,EE,FI,GB,GE,LT,LV,NL,PL,RU,SE,UA,EU}
> 212.49.0.0/19 | EE | {EE,EU}
> 212.126.32.0/19 | IE | {IE,GB}
> 213.179.32.0/19 | NO | {NO,NL,ZA,DE,ES,IT,SE,DK,IS,FI,FR,GB}
> 217.76.128.0/19 | ES | {ES,FR,PT}
> 31.209.96.0/20 | CY | {CY,TR}
> 46.20.240.0/20 | CH | {CH,FR,GB,RU,DE}
> 77.70.144.0/20 | FR | {FR,LU,DE,NO}
> 80.75.208.0/20 | GB | {GB,DE,NO,IE,FR,IN}
> 80.83.176.0/20 | NL | {NL,DE}
> 80.95.144.0/20 | DE | {DE,NL}
> 81.92.224.0/20 | LU | {LU,DE,FR}
> 83.216.192.0/20 | AT | {AT,DE}
> 92.39.48.0/20 | RU | {RU,MD}
> 95.140.224.0/20 | GB | {GB,NL,DE,FR,SE,ES,IT}
> 109.236.192.0/20 | FR | {FR,GB,DE,IT,CH,ES}
> 141.136.96.0/20 | IE | {IE,NL,GB,HK,BE,AT,NO,DK,CA,DE,GR,SE,RO,SG,CH,IT,PL,CZ,US,ES,SK,FR}
> 153.92.48.0/20 | LU | {LU,NL,BE,DE,FR}
> 193.141.32.0/20 | DE | {DE,NL}
> 193.141.144.0/20 | DE | {DE,NL}
> 193.141.160.0/20 | DE | {DE,NL}
> 193.141.240.0/20 | DE | {DE,NL}
> 193.220.144.0/20 | FR | {FR,LU,DE,NO}
> 193.220.192.0/20 | FR | {FR,NL}
> 194.45.240.0/20 | DE | {DE,NL}
> 194.120.0.0/20 | DE | {DE,NL}
> 194.120.64.0/20 | DE | {DE,NL}
> 194.121.176.0/20 | DE | {DE,NL}
> 194.121.224.0/20 | DE | {DE,NL}
> 212.59.80.0/20 | US | {US,AU}
> 217.28.240.0/20 | DE | {DE,EE,FI,GB,GE,LT,LV,NL,PL,RU,SE,UA,EU}
> 217.68.192.0/20 | DE | {DE,FR,GB}
> 5.149.112.0/21 | LU | {LU,FR,NL,DE,BE}
> 5.149.248.0/21 | GB | {GB,NL}
> 5.150.144.0/21 | IE | {IE,GB}
> 5.187.0.0/21 | RU | {RU,ES,DE}
> 31.25.208.0/21 | ES | {ES,GB}
> 46.255.176.0/21 | FR | {FR,DE,GB,NL,AT}
> 77.73.192.0/21 | SA | {SA,KW,AE}
> 78.24.200.0/21 | CH | {CH,DE,FR,AR,AT,AU,BE,BG,BO,BR,CA,CL,CN,CO,CR,CZ,DK,ES,FI,GB,GR,HK,HU,ID,IE,IL,IN,IT,JP,LT,LU,LV,MA,MX,MY,NL,NO,NZ,PA,PE,PH,PL,PT,RO,RU,SE,SG,SK,TR,TW,UA,US,UY,VE,ZA}
> 78.40.72.0/21 | CH | {CH,FR}
> 85.119.16.0/21 | GB | {GB,NL}
> 87.237.144.0/21 | DE | {DE,FR,GB}
> 87.238.120.0/21 | DE | {DE,CH}
> 87.238.136.0/21 | CH | {CH,AT,DE}
> 87.239.184.0/21 | DE | {DE,FR,GB,NL}
> 89.31.128.0/21 | AT | {AT,DE,RU,EU}
> 89.219.136.0/21 | EE | {EE,EU}
> 89.219.144.0/21 | EE | {EE,EU}
> 93.94.112.0/21 | IE | {IE,GB}
> 94.142.200.0/21 | ES | {ES,PT,AD}
> 94.199.224.0/21 | IE | {IE,GB}
> 95.128.192.0/21 | IE | {IE,DE,NO,GB,FR,IN}
> 109.70.208.0/21 | IE | {IE,GB}
> 134.0.72.0/21 | EU | {EU,US}
> 145.255.128.0/21 | NL | {NL,GB,DE,CN,RO}
> 146.185.48.0/21 | BE | {BE,NL}
> 171.33.144.0/21 | GB | {GB,IE}
> 176.241.248.0/21 | FR | {FR,BE,DE,LU,NL,CH,GB}
> 178.22.8.0/21 | GB | {GB,US}
> 178.248.48.0/21 | US | {US,EU,NL,IT}
> 178.251.160.0/21 | LU | {LU,FR,DE,NL,BE}
> 193.110.48.0/21 | GB | {GB,NL}
> 193.141.8.0/21 | DE | {DE,NL}
> 193.141.72.0/21 | DE | {DE,NL}
> 193.141.80.0/21 | DE | {DE,NL}
> 193.141.112.0/21 | DE | {DE,NL}
> 193.141.128.0/21 | DE | {DE,NL}
> 193.141.232.0/21 | DE | {DE,NL}
> 193.220.80.0/21 | FR | {FR,LU,DE,NO}
> 193.220.88.0/21 | FR | {FR,GF}
> 194.45.8.0/21 | DE | {DE,NL}
> 194.45.80.0/21 | DE | {DE,NL}
> 194.45.112.0/21 | DE | {DE,NL}
> 194.120.32.0/21 | DE | {DE,NL}
> 194.120.56.0/21 | DE | {DE,NL}
> 194.120.136.0/21 | DE | {DE,NL}
> 194.120.152.0/21 | DE | {DE,NL}
> 194.120.240.0/21 | DE | {DE,NL}
> 194.121.16.0/21 | DE | {DE,NL}
> 194.121.32.0/21 | DE | {DE,NL}
> 194.121.72.0/21 | DE | {DE,NL}
> 194.121.80.0/21 | DE | {DE,NL}
> 194.121.160.0/21 | DE | {DE,NL}
> 194.121.240.0/21 | DE | {DE,NL}
> 2.59.52.0/22 | JO | {JO,SA}
> 5.57.16.0/22 | GB | {GB,NL}
> 45.84.144.0/22 | AT | {AT,DE}
> 45.140.4.0/22 | CN | {CN,AU}
> 45.152.136.0/22 | GB | {GB,AU}
> 62.80.92.0/22 | CZ | {CZ,HU,PL,SK}
> 77.70.160.0/22 | FR | {FR,LU}
> 77.70.168.0/22 | FR | {FR,LU}
> 82.116.132.0/22 | KW | {KW,EG,GB}
> 85.217.172.0/22 | CH | {CH,DE,AT,BG}
> 85.217.184.0/22 | CH | {CH,DE,AT,BG}
> 88.218.80.0/22 | DE | {DE,AU}
> 89.219.0.0/22 | EE | {EE,EU}
> 89.219.128.0/22 | EE | {EE,EU}
> 91.192.16.0/22 | DE | {DE,GB}
> 91.196.116.0/22 | DE | {DE,GB}
> 93.177.92.0/22 | RU | {RU,AU}
> 95.214.80.0/22 | DE | {DE,AU}
> 176.118.176.0/22 | BH | {BH,NL}
> 185.4.124.0/22 | LU | {LU,NL,BE,DE,FR}
> 185.5.184.0/22 | DE | {DE,CH}
> 185.7.100.0/22 | GB | {GB,FR}
> 185.13.128.0/22 | AM | {AM,HR,CZ,DK,FI,GE,DE,GR,GL,IE,IT,JO,NL,PL,PT,RO,ES,SE,CH,GB,IL,FR}
> 185.16.216.0/22 | EU | {EU,US}
> 185.18.220.0/22 | IE | {IE,DE,NO,GB,FR,IN}
> 185.21.212.0/22 | FR | {FR,MQ,GF,GP}
> 185.23.240.0/22 | GB | {GB,AE,IQ,DE}
> 185.26.0.0/22 | BG | {BG,FR}
> 185.27.116.0/22 | JO | {JO,IQ}
> 185.29.164.0/22 | GB | {GB,NL,DE,FR,IT}
> 185.31.180.0/22 | CH | {CH,DE}
> 185.32.192.0/22 | EU | {EU,US}
> 185.33.168.0/22 | PS | {PS,FR,GB,DE,US}
> 185.34.188.0/22 | GB | {GB,NL}
> 185.34.196.0/22 | AT | {AT,DE}
> 185.37.184.0/22 | CY | {CY,TR}
> 185.38.240.0/22 | GB | {GB,US,DE}
> 185.47.72.0/22 | IE | {IE,GB}
> 185.47.100.0/22 | US | {US,NL}
> 185.56.64.0/22 | NL | {NL,GB}
> 185.60.84.0/22 | NL | {NL,GB,DE,FR,DK,CZ,PL,RO}
> 185.64.8.0/22 | IL | {IL,US}
> 185.65.172.0/22 | ES | {ES,IT,BH,AE}
> 185.71.92.0/22 | GB | {GB,FR,DE}
> 185.74.32.0/22 | FR | {FR,CH}
> 185.75.240.0/22 | AT | {AT,GB}
> 185.80.52.0/22 | GB | {GB,NL}
> 185.81.112.0/22 | GB | {GB,NL}
> 185.91.8.0/22 | US | {US,SE,GB,NL}
> 185.94.64.0/22 | RU | {RU,EU}
> 185.96.40.0/22 | GB | {GB,NO}
> 185.97.244.0/22 | LU | {LU,NL,FR,DE,BE}
> 185.99.220.0/22 | LB | {LB,TR}
> 185.100.84.0/22 | IS | {IS,FI,RO}
> 185.110.152.0/22 | CH | {CH,DE}
> 185.114.16.0/22 | DE | {DE,IE}
> 185.124.160.0/22 | GB | {GB,US}
> 185.130.104.0/22 | NL | {NL,RU,US}
> 185.132.128.0/22 | CH | {CH,AT,DE}
> 185.136.44.0/22 | CH | {CH,IT,FR,SE,FI,NO,IL,DK,US}
> 185.138.192.0/22 | GB | {GB,NL}
> 185.142.28.0/22 | GB | {GB,IE}
> 185.145.252.0/22 | NL | {NL,IL}
> 185.149.68.0/22 | GB | {GB,US}
> 185.159.80.0/22 | NL | {NL,RU,US}
> 185.162.128.0/22 | NL | {NL,RU,US}
> 185.167.164.0/22 | US | {US,DK}
> 185.188.52.0/22 | AT | {AT,CH,DE}
> 185.194.184.0/22 | FR | {FR,BE,DE,LU,NL,CH,GB,ES,DK,FI,PT,SE,IT,AT,HR,IE}
> 185.206.28.0/22 | SA | {SA,GB}
> 185.228.92.0/22 | PK | {PK,BH}
> 185.239.76.0/22 | IE | {IE,GB}
> 185.250.12.0/22 | SK | {SK,CZ}
> 193.9.148.0/22 | GB | {GB,GR}
> 193.36.92.0/22 | IE | {IE,US}
> 193.37.36.0/22 | GB | {GB,IE,DE}
> 193.109.168.0/22 | GB | {GB,US}
> 193.141.4.0/22 | DE | {DE,NL}
> 193.141.16.0/22 | DE | {DE,NL}
> 193.141.28.0/22 | DE | {DE,NL}
> 193.141.48.0/22 | DE | {DE,NL}
> 193.141.68.0/22 | DE | {DE,NL}
> 193.141.184.0/22 | DE | {DE,NL}
> 193.219.228.0/22 | FR | {FR,LU,DE,NO}
> 194.45.16.0/22 | DE | {DE,NL}
> 194.45.28.0/22 | DE | {DE,NL}
> 194.45.40.0/22 | DE | {DE,NL}
> 194.45.60.0/22 | DE | {DE,NL}
> 194.45.64.0/22 | DE | {DE,NL}
> 194.45.72.0/22 | DE | {DE,NL}
> 194.45.88.0/22 | DE | {DE,NL}
> 194.45.108.0/22 | DE | {DE,NL}
> 194.45.120.0/22 | DE | {DE,NL}
> 194.45.128.0/22 | DE | {DE,NL}
> 194.45.136.0/22 | DE | {DE,NL}
> 194.45.156.0/22 | DE | {DE,NL}
> 194.45.160.0/22 | DE | {DE,NL}
> 194.45.172.0/22 | DE | {DE,NL}
> 194.45.176.0/22 | DE | {DE,NL}
> 194.45.188.0/22 | DE | {DE,NL}
> 194.45.192.0/22 | DE | {DE,NL}
> 194.45.204.0/22 | DE | {DE,NL}
> 194.45.220.0/22 | DE | {DE,NL}
> 194.45.228.0/22 | DE | {DE,NL}
> 194.61.32.0/22 | BG | {BG,DE}
> 194.120.28.0/22 | DE | {DE,NL}
> 194.120.44.0/22 | DE | {DE,NL}
> 194.120.48.0/22 | DE | {DE,NL}
> 194.120.112.0/22 | DE | {DE,NL}
> 194.120.120.0/22 | DE | {DE,NL}
> 194.120.128.0/22 | DE | {DE,NL}
> 194.120.160.0/22 | DE | {DE,NL}
> 194.120.176.0/22 | DE | {DE,NL}
> 194.120.224.0/22 | DE | {DE,NL}
> 194.120.236.0/22 | DE | {DE,NL}
> 194.120.252.0/22 | DE | {DE,NL}
> 194.121.4.0/22 | DE | {DE,NL}
> 194.121.12.0/22 | DE | {DE,NL}
> 194.121.28.0/22 | DE | {DE,NL}
> 194.121.40.0/22 | DE | {DE,NL}
> 194.121.52.0/22 | DE | {DE,NL}
> 194.121.68.0/22 | DE | {DE,NL}
> 194.121.92.0/22 | DE | {DE,NL}
> 194.121.168.0/22 | DE | {DE,NL}
> 194.121.248.0/22 | DE | {DE,NL}
> 194.147.36.0/22 | GB | {GB,NL}
> 212.104.212.0/22 | IL | {IL,DE}
> 213.232.72.0/22 | DK | {DK,MT}
> 5.57.20.0/23 | GB | {GB,NL}
> 45.11.172.0/23 | GB | {GB,EU}
> 45.11.174.0/23 | GB | {GB,EU}
> 46.183.104.0/23 | GB | {GB,IE}
> 87.254.206.0/23 | CN | {CN,IN}
> 89.219.134.0/23 | EE | {EE,EU}
> 89.219.152.0/23 | EE | {EE,EU}
> 91.201.212.0/23 | CH | {CH,AT,DE}
> 91.226.144.0/23 | SE | {SE,PT,ES,DK}
> 93.183.12.0/23 | DE | {DE,FI}
> 185.129.122.0/23 | US | {US,DE,SG}
> 185.175.206.0/23 | AE | {AE,BE}
> 193.103.236.0/23 | EU | {EU,US,CA}
> 193.141.62.0/23 | DE | {DE,NL}
> 193.141.88.0/23 | DE | {DE,NL}
> 193.141.102.0/23 | DE | {DE,NL}
> 193.141.122.0/23 | DE | {DE,NL}
> 193.141.124.0/23 | DE | {DE,NL}
> 193.141.136.0/23 | DE | {DE,NL}
> 193.141.178.0/23 | DE | {DE,NL}
> 193.141.190.0/23 | DE | {DE,NL}
> 193.141.228.0/23 | DE | {DE,NL}
> 193.219.218.0/23 | FR | {FR,LU}
> 193.219.236.0/23 | FR | {FR,LU}
> 193.220.126.0/23 | FR | {FR,LU,DE,NO}
> 194.45.4.0/23 | DE | {DE,NL}
> 194.45.24.0/23 | DE | {DE,NL}
> 194.45.38.0/23 | DE | {DE,NL}
> 194.45.50.0/23 | DE | {DE,NL}
> 194.45.58.0/23 | DE | {DE,NL}
> 194.45.68.0/23 | DE | {DE,NL}
> 194.45.92.0/23 | DE | {DE,NL}
> 194.45.98.0/23 | DE | {DE,NL}
> 194.45.124.0/23 | DE | {DE,NL}
> 194.45.132.0/23 | DE | {DE,NL}
> 194.45.140.0/23 | DE | {DE,NL}
> 194.45.170.0/23 | DE | {DE,NL}
> 194.45.182.0/23 | DE | {DE,NL}
> 194.45.186.0/23 | DE | {DE,NL}
> 194.45.198.0/23 | DE | {DE,NL}
> 194.45.202.0/23 | DE | {DE,NL}
> 194.45.218.0/23 | DE | {DE,NL}
> 194.45.224.0/23 | DE | {DE,NL}
> 194.45.234.0/23 | DE | {DE,NL}
> 194.45.238.0/23 | DE | {DE,NL}
> 194.88.142.0/23 | IE | {IE,EE}
> 194.93.76.0/23 | AT | {AT,DE}
> 194.120.18.0/23 | DE | {DE,NL}
> 194.120.20.0/23 | DE | {DE,NL}
> 194.120.26.0/23 | DE | {DE,NL}
> 194.120.42.0/23 | DE | {DE,NL}
> 194.120.52.0/23 | DE | {DE,NL}
> 194.120.106.0/23 | DE | {DE,NL}
> 194.120.124.0/23 | DE | {DE,NL}
> 194.120.134.0/23 | DE | {DE,NL}
> 194.120.146.0/23 | DE | {DE,NL}
> 194.120.148.0/23 | DE | {DE,NL}
> 194.120.166.0/23 | DE | {DE,NL}
> 194.120.168.0/23 | DE | {DE,NL}
> 194.120.174.0/23 | DE | {DE,NL}
> 194.120.180.0/23 | DE | {DE,NL}
> 194.120.186.0/23 | DE | {DE,NL}
> 194.120.190.0/23 | DE | {DE,NL}
> 194.120.228.0/23 | DE | {DE,NL}
> 194.120.232.0/23 | DE | {DE,NL}
> 194.120.250.0/23 | DE | {DE,NL}
> 194.121.8.0/23 | DE | {DE,NL}
> 194.121.24.0/23 | DE | {DE,NL}
> 194.121.44.0/23 | DE | {DE,NL}
> 194.121.60.0/23 | DE | {DE,NL}
> 194.121.64.0/23 | DE | {DE,NL}
> 194.121.88.0/23 | DE | {DE,NL}
> 194.121.252.0/23 | DE | {DE,NL}
> 194.150.168.0/23 | DE | {DE,IL,NL,BE,GB,CH,FR,CZ,SE,EU}
> 195.39.208.0/23 | AT | {AT,CZ,DE,HU,PL,SK,RO}
> 195.158.230.0/23 | CH | {CH,LI}
> 195.189.220.0/23 | GB | {GB,IE,FR}
> 31.133.47.0/24 | UA | {UA,RU}
> 37.10.7.0/24 | HK | {HK,SG}
> 45.91.19.0/24 | US | {US,GB}
> 46.102.239.0/24 | US | {US,NL}
> 46.255.120.0/24 | US | {US,GB}
> 77.70.163.0/24 | SK | {SK,FR}
> 78.41.187.0/24 | SG | {SG,CH}
> 78.41.188.0/24 | US | {US,CA}
> 79.143.48.0/24 | US | {US,GB,FR,NL,DE,SG,JP,AU}
> 84.33.33.0/24 | DE | {DE,IT,US,GB,NL,FR,SG,JP,AU,AT,BR}
> 86.106.23.0/24 | US | {US,NL}
> 89.39.147.0/24 | US | {US,NL}
> 89.185.155.0/24 | GB | {GB,IE}
> 89.219.154.0/24 | EE | {EE,EU}
> 89.219.161.0/24 | EE | {EE,EU}
> 89.219.162.0/24 | EE | {EE,EU}
> 89.219.168.0/24 | EE | {EE,EU}
> 91.198.188.0/24 | IL | {IL,DE}
> 91.205.43.0/24 | BE | {BE,FR}
> 91.232.229.0/24 | AT | {AT,CH,LI}
> 93.174.255.0/24 | SG | {SG,US,GB}
> 185.21.134.0/24 | BE | {BE,NL}
> 185.24.255.0/24 | EU | {EU,US,SG,BR,IR}
> 185.38.240.0/24 | US | {US,GB,DE}
> 185.42.188.0/24 | GB | {GB,FR}
> 185.65.142.0/24 | GB | {GB,EU}
> 185.73.223.0/24 | EU | {EU,US}
> 185.91.9.0/24 | NL | {NL,GB,US}
> 185.94.65.0/24 | LV | {LV,NL,RU}
> 185.94.67.0/24 | LV | {LV,NL,RU}
> 185.130.46.0/24 | NL | {NL,CA,US,DE,AU,JP}
> 185.143.232.0/24 | DE | {DE,NL,JP,IR,GB,US}
> 185.143.233.0/24 | NL | {NL,DE,JP,IR,GB,US}
> 185.143.234.0/24 | JP | {JP,NL,DE,IR,GB,US}
> 185.143.235.0/24 | GB | {GB,NL,DE,JP,IR,US}
> 185.144.91.0/24 | DE | {DE,US}
> 185.151.204.0/24 | NL | {NL,DE,US}
> 185.168.0.0/24 | SE | {SE,DK,DE,GB}
> 185.168.1.0/24 | SE | {SE,DK,DE,GB}
> 185.190.82.0/24 | US | {US,GB}
> 185.190.124.0/24 | CH | {CH,DE}
> 188.210.93.0/24 | US | {US,NL}
> 188.213.243.0/24 | US | {US,NL}
> 188.241.193.0/24 | US | {US,NL}
> 193.16.213.0/24 | GB | {GB,NL}
> 193.32.101.0/24 | GB | {GB,IE}
> 193.39.115.0/24 | DE | {DE,NL,GB,ES,FR,US}
> 193.41.248.0/24 | US | {US,DE,HK}
> 193.103.162.0/24 | EU | {EU,US,CA}
> 193.103.163.0/24 | EU | {EU,US,CA}
> 193.104.217.0/24 | SE | {SE,FI}
> 193.111.228.0/24 | NL | {NL,GE,BE}
> 193.141.21.0/24 | DE | {DE,NL}
> 193.141.22.0/24 | DE | {DE,NL}
> 193.141.25.0/24 | DE | {DE,NL}
> 193.141.26.0/24 | DE | {DE,NL}
> 193.141.52.0/24 | DE | {DE,NL}
> 193.141.54.0/24 | DE | {DE,NL}
> 193.141.56.0/24 | DE | {DE,NL}
> 193.141.59.0/24 | DE | {DE,NL}
> 193.141.66.0/24 | DE | {DE,NL}
> 193.141.90.0/24 | DE | {DE,NL}
> 193.141.93.0/24 | DE | {DE,NL}
> 193.141.100.0/24 | DE | {DE,NL}
> 193.141.105.0/24 | DE | {DE,NL}
> 193.141.106.0/24 | DE | {DE,NL}
> 193.141.108.0/24 | DE | {DE,NL}
> 193.141.111.0/24 | DE | {DE,NL}
> 193.141.120.0/24 | DE | {DE,NL}
> 193.141.138.0/24 | DE | {DE,NL}
> 193.141.142.0/24 | DE | {DE,NL}
> 193.141.189.0/24 | DE | {DE,NL}
> 193.218.114.0/24 | GP | {GP,MQ}
> 193.219.212.0/24 | GB | {GB,DE}
> 193.219.235.0/24 | FR | {FR,LU}
> 193.219.239.0/24 | FR | {FR,LU}
> 193.219.240.0/24 | FR | {FR,LU}
> 193.220.123.0/24 | FR | {FR,LU,DE,NO}
> 194.33.109.0/24 | GB | {GB,UA}
> 194.34.161.0/24 | DE | {DE,NL}
> 194.45.21.0/24 | DE | {DE,NL}
> 194.45.23.0/24 | DE | {DE,NL}
> 194.45.32.0/24 | DE | {DE,NL}
> 194.45.35.0/24 | DE | {DE,NL}
> 194.45.44.0/24 | DE | {DE,NL}
> 194.45.47.0/24 | DE | {DE,NL}
> 194.45.49.0/24 | DE | {DE,NL}
> 194.45.57.0/24 | DE | {DE,NL}
> 194.45.70.0/24 | DE | {DE,NL}
> 194.45.95.0/24 | DE | {DE,NL}
> 194.45.96.0/24 | DE | {DE,NL}
> 194.45.102.0/24 | DE | {DE,NL}
> 194.45.107.0/24 | DE | {DE,NL}
> 194.45.134.0/24 | DE | {DE,NL}
> 194.45.155.0/24 | DE | {DE,NL}
> 194.45.164.0/24 | DE | {DE,NL}
> 194.45.166.0/24 | DE | {DE,NL}
> 194.45.168.0/24 | DE | {DE,NL}
> 194.45.180.0/24 | DE | {DE,NL}
> 194.45.185.0/24 | DE | {DE,NL}
> 194.45.201.0/24 | DE | {DE,NL}
> 194.45.216.0/24 | DE | {DE,NL}
> 194.45.226.0/24 | DE | {DE,NL}
> 194.120.25.0/24 | DE | {DE,NL}
> 194.120.41.0/24 | DE | {DE,NL}
> 194.120.54.0/24 | DE | {DE,NL}
> 194.120.108.0/24 | DE | {DE,NL}
> 194.120.117.0/24 | DE | {DE,NL}
> 194.120.118.0/24 | DE | {DE,NL}
> 194.120.127.0/24 | DE | {DE,NL}
> 194.120.132.0/24 | DE | {DE,NL}
> 194.120.145.0/24 | DE | {DE,NL}
> 194.120.151.0/24 | DE | {DE,NL}
> 194.120.165.0/24 | DE | {DE,NL}
> 194.120.172.0/24 | DE | {DE,NL}
> 194.120.185.0/24 | DE | {DE,NL}
> 194.120.188.0/24 | DE | {DE,NL}
> 194.120.235.0/24 | DE | {DE,NL}
> 194.120.248.0/24 | DE | {DE,NL}
> 194.121.1.0/24 | DE | {DE,NL}
> 194.121.3.0/24 | DE | {DE,NL}
> 194.121.10.0/24 | DE | {DE,NL}
> 194.121.27.0/24 | DE | {DE,NL}
> 194.121.47.0/24 | DE | {DE,NL}
> 194.121.57.0/24 | DE | {DE,NL}
> 194.121.58.0/24 | DE | {DE,NL}
> 194.121.67.0/24 | DE | {DE,NL}
> 194.121.91.0/24 | DE | {DE,NL}
> 194.121.255.0/24 | DE | {DE,NL}
> 194.153.74.0/24 | NL | {NL,IE,SE,DK,DE,AT,CH,BE,FR,ES,GB}
> 195.14.23.0/24 | CH | {CH,GB}
> 195.22.222.0/24 | PE | {PE,US}
> 195.46.39.0/24 | DE | {DE,GB,NL,NZ,US}
> 195.85.254.0/24 | IL | {IL,IM,GG}
> 195.95.150.0/24 | NL | {NL,GB}
> 2a01:800::/24 | DE | {DE,NL}
> 2a01:ce80::/26 | NL | {NL,BE,LU,ZA,ZW,MG,MZ,NA,AU,BI,BW,AE,BH,EG,SA,KW,JO,YE,TR,IL,CY,LB,SY,GR,GB,IE,KE,ET,ER,UG,NG,GH,SL,GM,CI,BJ,SN,GA,TD,MA,DZ,TN,LY,ES,PT,FR,CH,IT,MT,DE,PL,CZ,AT,SK,HU,RS,SI,HR,BA,ME,MK,BG,RO,UA,GE,AZ,BY,KG,KZ,UZ,IS,DK,NO,FI,SE,EE,LT,LV,RU,CO,VE,EC,GY,PE,CL,AR,UY,PY,BO,BR,GT,CR,SV,NI,HN,PA,BZ,PR,DO,TT,CU,CA,US,MX,NZ,NC,TO,PK,AF,IN,BD,LK,SG,MY,TH,ID,KH,VN,PH,HK,TW,CN,KR,KP,JP}
> 2001:668::/29 | DE | {DE,SE,GR,NL,BE,AT,PL,IT,CH,NO,DK,CZ,US,CA,SK,ES,FR,GB,RO,HK,SG,IE}
> 2001:730::/29 | NL | {NL,AT,CH,IE,HU,DE,PL,CZ,SK,RO}
> 2001:4ce8::/29 | NL | {NL,DE}
> 2a00:8a00::/29 | FI | {FI,DE,IN,SG,CN,US,BR}
> 2a00:95c0::/29 | NL | {NL,DE}
> 2a00:cee0::/29 | PS | {PS,FR,GB,DE,US}
> 2a00:d120::/29 | NL | {NL,DE}
> 2a01:ce90::/29 | CO | {CO,VE,EC,GY,PE,CL,AR,UY,PY,BO,BR,GT,CR,SV,NI,HN,PA,BZ,PR,DO,TT,CU,CA,US,MX}
> 2a01:ce98::/29 | NZ | {NZ,NC,TO,AU,PK,AF,IN,BD,LK,SG,MY,TH,ID,KH,VN,PH,HK,TW,CN,KR,KP,JP}
> 2a02:aa0::/29 | SE | {SE,DK}
> 2a02:f180::/29 | FR | {FR,GB,RO,DE}
> 2a02:fe00::/29 | NL | {NL,BE}
> 2a03:f80::/29 | DE | {DE,CH,IT,GB,FR,US,HK,PL,CL,ES,IS,AT}
> 2a04:a80::/29 | AE | {AE,AR,AT,AU,BE,BF,BG,BH,BR,BS,CA,CH,CI,CN,CO,CZ,DE,DK,DZ,EG,ES,GA,GB,GF,GN,GP,GR,HK,HU,ID,IE,IL,IN,IT,JP,KM,KR,KW,LU,LY,MA,ML,MQ,MX,MY,NC,NL,NO,PH,PL,PT,QA,RE,RO,RU,SA,SE,SG,SN,TH,TN,TR,TW,UA,US,VN,ZA,PE,PA,VE,CL,FR}
> 2a04:11c0::/29 | FR | {FR,MQ,GP,GF}
> 2a04:2980::/29 | GB | {GB,AE,IQ,DE}
> 2a04:2ec0::/29 | JO | {JO,IQ,EG,BH,AE}
> 2a04:4800::/29 | NL | {NL,GB}
> 2a04:6e80::/29 | DK | {DK,SE,FI,NO,IR,NL,GB,US,CA,MX,BR,FR}
> 2a04:7f00::/29 | BE | {BE,NL,LU}
> 2a04:9200::/29 | US | {US,EU}
> 2a04:ac80::/29 | NL | {NL,US}
> 2a04:d200::/29 | AT | {AT,DE}
> 2a04:db00::/29 | DE | {DE,GB,NL,BE}
> 2a04:e4c0::/29 | NL | {NL,GB,DE,FR,DK,CZ,PL,RO}
> 2a05:e580::/29 | SE | {SE,US,GB}
> 2a06:1700::/29 | IS | {IS,RO,FI}
> 2a07:4dc0::/29 | NL | {NL,RU,US}
> 2a07:fcc0::/29 | IE | {IE,US}
> 2a0b:39c0::/29 | IE | {IE,DE}
> 2a0b:7e00::/29 | US | {US,DK}
> 2a0e:fa00::/29 | NL | {NL,CH}
> 2a01:ce84::/30 | GR | {GR,GB,IE,KE,ET,ER,UG,NG,GH,SL,GM}
> 2a0f:7780::/30 | DK | {DK,DE,RO}
> 2a0f:7784::/30 | DK | {DK,DE,RO}
> 2a01:ce88::/31 | CI | {CI,BJ,SN,GA,TD,MA,DZ,TN,LY,ES,PT,FR,CH,IT,MT}
> 2a01:ce8c::/31 | DE | {DE,PL,CZ,AT,SK,HU,RS,SI,HR,BA,ME,MK,BG,RO,UA,GE,AZ,BY,KG,KZ,UZ}
> 2a01:ce8e::/31 | IS | {IS,DK,NO,FI,SE,EE,LT,LV,RU}
> 2a01:ce94::/31 | GT | {GT,CR,SV,NI,HN,PA,BZ,PR,DO,TT,CU,CA,US,MX}
> 2a01:ce9c::/31 | PK | {PK,AF,IN,BD,LK,SG,MY,TH,ID,KH,VN,PH,HK,TW,CN,KR,KP,JP}
> 2a03:9d40::/31 | GB | {GB,NL,FR,DE,US,RU,CH}
> 2001:680::/32 | DE | {DE,NL}
> 2001:730::/32 | AT | {AT,CH,CZ,DE,HU,IE,NL,PL,RO,SK}
> 2001:ad0::/32 | EE | {EE,DE,SE,RU,LT,LV,PL}
> 2001:1ad0::/32 | AT | {AT,DE,NL}
> 2a00:1888::/32 | FR | {FR,GB,DE,IT,CH,ES}
> 2a00:80a0::/32 | AU | {AU,AT,BE,BR,CA,CL,CN,CZ,DK,FI,FR,DE,HK,HU,IN,IT,JP,MX,NL,NO,PL,SG,ZA,ES,SZ,SE,CH,TR,GB,AE,US}
> 2a00:96c0::/32 | SE | {SE,DE,NO,DK,FR,GB}
> 2a00:a2e0::/32 | DE | {DE,NL}
> 2a00:bf60::/32 | CH | {CH,DE}
> 2a00:e8a0::/32 | DE | {DE,US,IE,IN,IT,JP,PR,SG}
> 2a01:20::/32 | FR | {FR,BE,DE}
> 2a01:258::/32 | IE | {IE,GB}
> 2a01:6dc0::/32 | RU | {RU,MD}
> 2a01:8200::/32 | FR | {FR,GB}
> 2a01:a0a0::/32 | DE | {DE,US,RU}
> 2a01:ce82::/32 | ZA | {ZA,ZW,MG,MZ,NA,AU,BI,BW}
> 2a01:ce83::/32 | AE | {AE,BH,EG,SA,KW,JO,YE,TR,IL,CY,LB,SY}
> 2a01:ce85::/32 | GB | {GB,IE}
> 2a01:ce87::/32 | KE | {KE,ET,ER,UG,NG,GH,SL,GM}
> 2a01:ce89::/32 | ES | {ES,PT,FR,CH,IT,MT}
> 2a01:ce8d::/32 | RS | {RS,SI,HR,BA,ME,MK,BG,RO,UA,GE,AZ,BY,KG,KZ,UZ}
> 2a01:ce8f::/32 | EE | {EE,LT,LV,RU}
> 2a01:ce95::/32 | CA | {CA,US,MX}
> 2a01:ce9d::/32 | SG | {SG,MY,TH,ID,KH,VN,PH}
> 2a01:ce9e::/32 | HK | {HK,TW,CN}
> 2a01:ce9f::/32 | KR | {KR,KP,JP}
> 2a02:3d0::/32 | GB | {GB,IE,CH,NL,DE,SE,FR,IT,ES,AT}
> 2a02:9f8::/32 | GB | {GB,DE,FR}
> 2a02:1340::/32 | GB | {GB,IE}
> 2a02:23e0::/32 | FR | {FR,ES}
> 2a02:48c0::/32 | AM | {AM,HR,CZ,DE,GE,GR,GL,IE,IT,JO,NL,PL,PT,RO,ES,SE,CH,GB,IL,FR}
> 2a02:51e0::/32 | NL | {NL,GB}
> 2a02:70c0::/32 | LU | {LU,FR,BE,DE,NL}
> 2a02:7200::/32 | RU | {RU,LV,LT,ES,IR,LB,KZ,TJ,TM}
> 2a02:7c40::/32 | DE | {DE,CH}
> 2a03:35c0::/32 | DE | {DE,CN,GB,SG,BE,US}
> 2a03:a7a0::/32 | RU | {RU,US}
> 2a03:ae00::/32 | GB | {GB,NL}
> 2a03:bdc0::/32 | FR | {FR,DE,SE,GB,NL,AT,BE,CH,IT,DK,NO,IL,US,ES}
> 2a03:da80::/32 | AT | {AT,DE}
> 2a03:eec0::/32 | GB | {GB,NL,DE,CH,FR}
> 2a07:e00::/32 | BZ | {BZ,SE}
> 2a07:68c0::/32 | US | {US,EU}
> 2a0a:3980::/32 | US | {US,DE,HK,JP}
> 2a0c:8fc1::/32 | SG | {SG,JP}
> 2a0d:1a45::/32 | EU | {EU,SE,AQ,US}
> 2a0e:e42::/32 | US | {US,GB}
> 2a02:6600:2000::/36 | FR | {FR,NL,NO}
> 2a07:e02:1000::/36 | NL | {NL,CA,US,DE,JP,AU}
> 2a03:d5c0:1b00::/40 | GB | {GB,NL}
> 2a07:1c44:1400::/40 | NL | {NL,CA,US}
> 2a06:7a07::/43 | US | {US,GB,FR,NL,DE,SG,JP,AU}
> 2001:67c:1020::/47 | AT | {AT,RU}
> 2001:67c:268::/48 | CH | {CH,US}
> 2001:67c:3fc::/48 | CH | {CH,AT,DE}
> 2001:67c:2778::/48 | DE | {DE,GB,NL,NZ,US}
> 2001:7f8:66::/48 | AT | {AT,CH,LI}
> 2a00:fd80:aaaa::/48 | AU | {AU,GB}
> 2a02:6604:3::/48 | NL | {NL,FR}
> 2a06:7245::/48 | US | {US,DE}
> 2a07:e00:b::/48 | US | {US,CA,AU,JP,NL,DE}
> 2a09:be40:1170::/48 | EU | {EU,US}
> 2a0f:4400::/48 | IE | {IE,FR,GB}
> (596 rows)
I'll reply more detailled to your answer within the next days, Deo volente. :-)
Thanks, and best regards,
Peter Müller
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: List of IP networks having more than one country assigned to (was: Re: How should location-importer.in deal with RIR objects having multiple distinct "country" fields?)
2021-05-06 21:06 ` List of IP networks having more than one country assigned to (was: Re: How should location-importer.in deal with RIR objects having multiple distinct "country" fields?) Peter Müller
@ 2021-05-07 10:48 ` Michael Tremer
2021-05-14 15:59 ` List of IP networks having more than one country assigned to Peter Müller
0 siblings, 1 reply; 5+ messages in thread
From: Michael Tremer @ 2021-05-07 10:48 UTC (permalink / raw)
To: location
[-- Attachment #1: Type: text/plain, Size: 31349 bytes --]
Hello,
> On 6 May 2021, at 22:06, Peter Müller <peter.mueller(a)ipfire.org> wrote:
>
> Hello Michael,
> hello *,
>
> after fiddling a bit on location02 - patch is to be followed shortly -, I thought it might be interesting
> to have a complete list of IP networks having more than one country assigned to.
>
> This is it:
>
>> location=# SELECT network, country, original_country FROM networks WHERE array_length(original_country, 1) > 1;
I would recommend to name any field with an array in its plural name. In this case “original_countries”. That makes it easier to understand what the content is and writing loops where you could simply have “for original_country in original_countries: …"
>> network | country | original_country
>> ---------------------+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>> 194.122.0.0/15 | DE | {DE,NL}
>> 37.246.0.0/16 | TR | {TR,US,NL,DE,GB}
>> 46.108.0.0/16 | DE | {DE,IE,GB}
>> 62.132.0.0/16 | DE | {DE,NL}
>> 81.85.0.0/16 | US | {US,NL}
>> 85.205.0.0/16 | DE | {DE,IE,GB}
>> 95.209.0.0/16 | DK | {DK,SE}
>> 129.73.0.0/16 | CR | {CR,DO,GT,HN,MX,NI,SV,US}
>> 129.214.0.0/16 | AR | {AR,BR,CL,CO,PE,UY,VE,US,DE}
>> 131.176.0.0/16 | EU | {EU,AU,CA,KE,RU,US}
>> 132.186.0.0/16 | AE | {AE,BH,DZ,EG,IN,KW,MA,QA,TN,ZA}
>> 137.223.0.0/16 | GB | {GB,IE}
>> 139.10.0.0/16 | BE | {BE,FR,NL}
>> 141.11.0.0/16 | FR | {FR,GB}
>> 141.29.0.0/16 | BA | {BA,GR,HR,IT,PT,SI}
>> 146.253.0.0/16 | DE | {DE,SE}
>> 146.254.0.0/16 | DE | {DE,SE}
>> 155.190.0.0/16 | NL | {NL,GB,DE,FR,DK,CZ,PL,RO}
>> 165.218.0.0/16 | DE | {DE,US}
>> 193.220.0.0/16 | NO | {NO,US,FR}
>> 195.73.0.0/16 | DE | {DE,NL}
>> 37.25.128.0/17 | DE | {DE,IE,GB}
>> 46.190.128.0/17 | DE | {DE,IE,GB}
>> 77.67.0.0/17 | DE | {DE,SE,GR,NL,BE,AT,PL,IT,CH,NO,DK,CZ,US,CA,SK,ES,FR,GB,RO,HK,SG,IE}
>> 77.70.128.0/17 | NO | {NO,US,FR}
>> 85.131.128.0/17 | DE | {DE,NL}
>> 87.98.0.0/17 | EE | {EE,EU}
>> 131.228.0.0/17 | FI | {FI,US,DE,IN}
>> 31.6.0.0/18 | GB | {GB,NL,DE,FR,IT,AE}
>> 78.137.128.0/18 | IE | {IE,GB}
>> 78.143.0.0/18 | DE | {DE,NL}
>> 89.149.128.0/18 | DE | {DE,SE,GR,NL,BE,AT,PL,IT,CH,NO,DK,CZ,US,SK,ES,FR,GB,RO,HK,SG,IE}
>> 93.183.0.0/18 | US | {US,BR,FI,DE,CN,IN,SG}
>> 159.180.128.0/18 | US | {US,DE,SG,CN,JP,BR,IE,IT,PR}
>> 178.79.192.0/18 | EU | {EU,SE,DE,NL,GB,ES,FR,IT}
>> 193.219.192.0/18 | NO | {NO,US,FR}
>> 194.93.192.0/18 | DE | {DE,IT}
>> 212.111.128.0/18 | GB | {GB,FR}
>> 213.200.64.0/18 | AT | {AT,BE,CA,CH,CZ,DE,DK,ES,FR,GB,GR,HK,IE,IT,NL,NO,PL,SE,SG,SK,US,RO}
>> 213.254.192.0/18 | DE | {DE,SE,GR,NL,BE,AT,PL,IT,CH,NO,DK,CZ,US,SK,ES,FR,GB,RO,HK,SG,IE}
>> 37.18.192.0/19 | SE | {SE,US,DE,DK}
>> 46.33.64.0/19 | IE | {IE,NL,GB,HK,BE,AT,NO,DK,CA,DE,GR,SE,RO,SG,CH,IT,PL,CZ,US,ES,SK,FR}
>> 62.32.32.0/19 | US | {US,NL}
>> 62.128.96.0/19 | DE | {DE,EE,FI,GB,GE,LT,LV,NL,PL,RU,SE,UA,EU}
>> 82.150.224.0/19 | DE | {DE,FR}
>> 82.198.128.0/19 | IE | {IE,GB}
>> 83.216.32.0/19 | AT | {AT,IT}
>> 83.221.160.0/19 | RU | {RU,UZ}
>> 87.248.192.0/19 | GB | {GB,NL,DE,FR,SE,ES,IT}
>> 88.84.128.0/19 | DE | {DE,NL,GB}
>> 89.21.160.0/19 | NL | {NL,US}
>> 146.247.96.0/19 | AT | {AT,DE,CH,US,BR,RU,FR,IT}
>> 158.255.96.0/19 | FR | {FR,DE,GB,NL,AT}
>> 159.180.192.0/19 | FR | {FR,GB,ES,DE,US}
>> 176.56.160.0/19 | GB | {GB,US,CY,NL}
>> 193.17.96.0/19 | DE | {DE,US,SG}
>> 193.202.128.0/19 | DE | {DE,US,SG}
>> 193.202.160.0/19 | DE | {DE,US,SG}
>> 194.34.64.0/19 | GB | {GB,US,JP,AU}
>> 194.121.96.0/19 | DE | {DE,NL}
>> 194.121.128.0/19 | DE | {DE,NL}
>> 194.121.192.0/19 | DE | {DE,NL}
>> 195.90.32.0/19 | EU | {EU,US}
>> 195.222.0.0/19 | EE | {EE,EU}
>> 212.27.224.0/19 | EE | {EE,EU}
>> 212.47.192.0/19 | DE | {DE,EE,FI,GB,GE,LT,LV,NL,PL,RU,SE,UA,EU}
>> 212.49.0.0/19 | EE | {EE,EU}
>> 212.126.32.0/19 | IE | {IE,GB}
>> 213.179.32.0/19 | NO | {NO,NL,ZA,DE,ES,IT,SE,DK,IS,FI,FR,GB}
>> 217.76.128.0/19 | ES | {ES,FR,PT}
>> 31.209.96.0/20 | CY | {CY,TR}
>> 46.20.240.0/20 | CH | {CH,FR,GB,RU,DE}
>> 77.70.144.0/20 | FR | {FR,LU,DE,NO}
>> 80.75.208.0/20 | GB | {GB,DE,NO,IE,FR,IN}
>> 80.83.176.0/20 | NL | {NL,DE}
>> 80.95.144.0/20 | DE | {DE,NL}
>> 81.92.224.0/20 | LU | {LU,DE,FR}
>> 83.216.192.0/20 | AT | {AT,DE}
>> 92.39.48.0/20 | RU | {RU,MD}
>> 95.140.224.0/20 | GB | {GB,NL,DE,FR,SE,ES,IT}
>> 109.236.192.0/20 | FR | {FR,GB,DE,IT,CH,ES}
>> 141.136.96.0/20 | IE | {IE,NL,GB,HK,BE,AT,NO,DK,CA,DE,GR,SE,RO,SG,CH,IT,PL,CZ,US,ES,SK,FR}
>> 153.92.48.0/20 | LU | {LU,NL,BE,DE,FR}
>> 193.141.32.0/20 | DE | {DE,NL}
>> 193.141.144.0/20 | DE | {DE,NL}
>> 193.141.160.0/20 | DE | {DE,NL}
>> 193.141.240.0/20 | DE | {DE,NL}
>> 193.220.144.0/20 | FR | {FR,LU,DE,NO}
>> 193.220.192.0/20 | FR | {FR,NL}
>> 194.45.240.0/20 | DE | {DE,NL}
>> 194.120.0.0/20 | DE | {DE,NL}
>> 194.120.64.0/20 | DE | {DE,NL}
>> 194.121.176.0/20 | DE | {DE,NL}
>> 194.121.224.0/20 | DE | {DE,NL}
>> 212.59.80.0/20 | US | {US,AU}
>> 217.28.240.0/20 | DE | {DE,EE,FI,GB,GE,LT,LV,NL,PL,RU,SE,UA,EU}
>> 217.68.192.0/20 | DE | {DE,FR,GB}
>> 5.149.112.0/21 | LU | {LU,FR,NL,DE,BE}
>> 5.149.248.0/21 | GB | {GB,NL}
>> 5.150.144.0/21 | IE | {IE,GB}
>> 5.187.0.0/21 | RU | {RU,ES,DE}
>> 31.25.208.0/21 | ES | {ES,GB}
>> 46.255.176.0/21 | FR | {FR,DE,GB,NL,AT}
>> 77.73.192.0/21 | SA | {SA,KW,AE}
>> 78.24.200.0/21 | CH | {CH,DE,FR,AR,AT,AU,BE,BG,BO,BR,CA,CL,CN,CO,CR,CZ,DK,ES,FI,GB,GR,HK,HU,ID,IE,IL,IN,IT,JP,LT,LU,LV,MA,MX,MY,NL,NO,NZ,PA,PE,PH,PL,PT,RO,RU,SE,SG,SK,TR,TW,UA,US,UY,VE,ZA}
>> 78.40.72.0/21 | CH | {CH,FR}
>> 85.119.16.0/21 | GB | {GB,NL}
>> 87.237.144.0/21 | DE | {DE,FR,GB}
>> 87.238.120.0/21 | DE | {DE,CH}
>> 87.238.136.0/21 | CH | {CH,AT,DE}
>> 87.239.184.0/21 | DE | {DE,FR,GB,NL}
>> 89.31.128.0/21 | AT | {AT,DE,RU,EU}
>> 89.219.136.0/21 | EE | {EE,EU}
>> 89.219.144.0/21 | EE | {EE,EU}
>> 93.94.112.0/21 | IE | {IE,GB}
>> 94.142.200.0/21 | ES | {ES,PT,AD}
>> 94.199.224.0/21 | IE | {IE,GB}
>> 95.128.192.0/21 | IE | {IE,DE,NO,GB,FR,IN}
>> 109.70.208.0/21 | IE | {IE,GB}
>> 134.0.72.0/21 | EU | {EU,US}
>> 145.255.128.0/21 | NL | {NL,GB,DE,CN,RO}
>> 146.185.48.0/21 | BE | {BE,NL}
>> 171.33.144.0/21 | GB | {GB,IE}
>> 176.241.248.0/21 | FR | {FR,BE,DE,LU,NL,CH,GB}
>> 178.22.8.0/21 | GB | {GB,US}
>> 178.248.48.0/21 | US | {US,EU,NL,IT}
>> 178.251.160.0/21 | LU | {LU,FR,DE,NL,BE}
>> 193.110.48.0/21 | GB | {GB,NL}
>> 193.141.8.0/21 | DE | {DE,NL}
>> 193.141.72.0/21 | DE | {DE,NL}
>> 193.141.80.0/21 | DE | {DE,NL}
>> 193.141.112.0/21 | DE | {DE,NL}
>> 193.141.128.0/21 | DE | {DE,NL}
>> 193.141.232.0/21 | DE | {DE,NL}
>> 193.220.80.0/21 | FR | {FR,LU,DE,NO}
>> 193.220.88.0/21 | FR | {FR,GF}
>> 194.45.8.0/21 | DE | {DE,NL}
>> 194.45.80.0/21 | DE | {DE,NL}
>> 194.45.112.0/21 | DE | {DE,NL}
>> 194.120.32.0/21 | DE | {DE,NL}
>> 194.120.56.0/21 | DE | {DE,NL}
>> 194.120.136.0/21 | DE | {DE,NL}
>> 194.120.152.0/21 | DE | {DE,NL}
>> 194.120.240.0/21 | DE | {DE,NL}
>> 194.121.16.0/21 | DE | {DE,NL}
>> 194.121.32.0/21 | DE | {DE,NL}
>> 194.121.72.0/21 | DE | {DE,NL}
>> 194.121.80.0/21 | DE | {DE,NL}
>> 194.121.160.0/21 | DE | {DE,NL}
>> 194.121.240.0/21 | DE | {DE,NL}
>> 2.59.52.0/22 | JO | {JO,SA}
>> 5.57.16.0/22 | GB | {GB,NL}
>> 45.84.144.0/22 | AT | {AT,DE}
>> 45.140.4.0/22 | CN | {CN,AU}
>> 45.152.136.0/22 | GB | {GB,AU}
>> 62.80.92.0/22 | CZ | {CZ,HU,PL,SK}
>> 77.70.160.0/22 | FR | {FR,LU}
>> 77.70.168.0/22 | FR | {FR,LU}
>> 82.116.132.0/22 | KW | {KW,EG,GB}
>> 85.217.172.0/22 | CH | {CH,DE,AT,BG}
>> 85.217.184.0/22 | CH | {CH,DE,AT,BG}
>> 88.218.80.0/22 | DE | {DE,AU}
>> 89.219.0.0/22 | EE | {EE,EU}
>> 89.219.128.0/22 | EE | {EE,EU}
>> 91.192.16.0/22 | DE | {DE,GB}
>> 91.196.116.0/22 | DE | {DE,GB}
>> 93.177.92.0/22 | RU | {RU,AU}
>> 95.214.80.0/22 | DE | {DE,AU}
>> 176.118.176.0/22 | BH | {BH,NL}
>> 185.4.124.0/22 | LU | {LU,NL,BE,DE,FR}
>> 185.5.184.0/22 | DE | {DE,CH}
>> 185.7.100.0/22 | GB | {GB,FR}
>> 185.13.128.0/22 | AM | {AM,HR,CZ,DK,FI,GE,DE,GR,GL,IE,IT,JO,NL,PL,PT,RO,ES,SE,CH,GB,IL,FR}
>> 185.16.216.0/22 | EU | {EU,US}
>> 185.18.220.0/22 | IE | {IE,DE,NO,GB,FR,IN}
>> 185.21.212.0/22 | FR | {FR,MQ,GF,GP}
>> 185.23.240.0/22 | GB | {GB,AE,IQ,DE}
>> 185.26.0.0/22 | BG | {BG,FR}
>> 185.27.116.0/22 | JO | {JO,IQ}
>> 185.29.164.0/22 | GB | {GB,NL,DE,FR,IT}
>> 185.31.180.0/22 | CH | {CH,DE}
>> 185.32.192.0/22 | EU | {EU,US}
>> 185.33.168.0/22 | PS | {PS,FR,GB,DE,US}
>> 185.34.188.0/22 | GB | {GB,NL}
>> 185.34.196.0/22 | AT | {AT,DE}
>> 185.37.184.0/22 | CY | {CY,TR}
>> 185.38.240.0/22 | GB | {GB,US,DE}
>> 185.47.72.0/22 | IE | {IE,GB}
>> 185.47.100.0/22 | US | {US,NL}
>> 185.56.64.0/22 | NL | {NL,GB}
>> 185.60.84.0/22 | NL | {NL,GB,DE,FR,DK,CZ,PL,RO}
>> 185.64.8.0/22 | IL | {IL,US}
>> 185.65.172.0/22 | ES | {ES,IT,BH,AE}
>> 185.71.92.0/22 | GB | {GB,FR,DE}
>> 185.74.32.0/22 | FR | {FR,CH}
>> 185.75.240.0/22 | AT | {AT,GB}
>> 185.80.52.0/22 | GB | {GB,NL}
>> 185.81.112.0/22 | GB | {GB,NL}
>> 185.91.8.0/22 | US | {US,SE,GB,NL}
>> 185.94.64.0/22 | RU | {RU,EU}
>> 185.96.40.0/22 | GB | {GB,NO}
>> 185.97.244.0/22 | LU | {LU,NL,FR,DE,BE}
>> 185.99.220.0/22 | LB | {LB,TR}
>> 185.100.84.0/22 | IS | {IS,FI,RO}
>> 185.110.152.0/22 | CH | {CH,DE}
>> 185.114.16.0/22 | DE | {DE,IE}
>> 185.124.160.0/22 | GB | {GB,US}
>> 185.130.104.0/22 | NL | {NL,RU,US}
>> 185.132.128.0/22 | CH | {CH,AT,DE}
>> 185.136.44.0/22 | CH | {CH,IT,FR,SE,FI,NO,IL,DK,US}
>> 185.138.192.0/22 | GB | {GB,NL}
>> 185.142.28.0/22 | GB | {GB,IE}
>> 185.145.252.0/22 | NL | {NL,IL}
>> 185.149.68.0/22 | GB | {GB,US}
>> 185.159.80.0/22 | NL | {NL,RU,US}
>> 185.162.128.0/22 | NL | {NL,RU,US}
>> 185.167.164.0/22 | US | {US,DK}
>> 185.188.52.0/22 | AT | {AT,CH,DE}
>> 185.194.184.0/22 | FR | {FR,BE,DE,LU,NL,CH,GB,ES,DK,FI,PT,SE,IT,AT,HR,IE}
>> 185.206.28.0/22 | SA | {SA,GB}
>> 185.228.92.0/22 | PK | {PK,BH}
>> 185.239.76.0/22 | IE | {IE,GB}
>> 185.250.12.0/22 | SK | {SK,CZ}
>> 193.9.148.0/22 | GB | {GB,GR}
>> 193.36.92.0/22 | IE | {IE,US}
>> 193.37.36.0/22 | GB | {GB,IE,DE}
>> 193.109.168.0/22 | GB | {GB,US}
>> 193.141.4.0/22 | DE | {DE,NL}
>> 193.141.16.0/22 | DE | {DE,NL}
>> 193.141.28.0/22 | DE | {DE,NL}
>> 193.141.48.0/22 | DE | {DE,NL}
>> 193.141.68.0/22 | DE | {DE,NL}
>> 193.141.184.0/22 | DE | {DE,NL}
>> 193.219.228.0/22 | FR | {FR,LU,DE,NO}
>> 194.45.16.0/22 | DE | {DE,NL}
>> 194.45.28.0/22 | DE | {DE,NL}
>> 194.45.40.0/22 | DE | {DE,NL}
>> 194.45.60.0/22 | DE | {DE,NL}
>> 194.45.64.0/22 | DE | {DE,NL}
>> 194.45.72.0/22 | DE | {DE,NL}
>> 194.45.88.0/22 | DE | {DE,NL}
>> 194.45.108.0/22 | DE | {DE,NL}
>> 194.45.120.0/22 | DE | {DE,NL}
>> 194.45.128.0/22 | DE | {DE,NL}
>> 194.45.136.0/22 | DE | {DE,NL}
>> 194.45.156.0/22 | DE | {DE,NL}
>> 194.45.160.0/22 | DE | {DE,NL}
>> 194.45.172.0/22 | DE | {DE,NL}
>> 194.45.176.0/22 | DE | {DE,NL}
>> 194.45.188.0/22 | DE | {DE,NL}
>> 194.45.192.0/22 | DE | {DE,NL}
>> 194.45.204.0/22 | DE | {DE,NL}
>> 194.45.220.0/22 | DE | {DE,NL}
>> 194.45.228.0/22 | DE | {DE,NL}
>> 194.61.32.0/22 | BG | {BG,DE}
>> 194.120.28.0/22 | DE | {DE,NL}
>> 194.120.44.0/22 | DE | {DE,NL}
>> 194.120.48.0/22 | DE | {DE,NL}
>> 194.120.112.0/22 | DE | {DE,NL}
>> 194.120.120.0/22 | DE | {DE,NL}
>> 194.120.128.0/22 | DE | {DE,NL}
>> 194.120.160.0/22 | DE | {DE,NL}
>> 194.120.176.0/22 | DE | {DE,NL}
>> 194.120.224.0/22 | DE | {DE,NL}
>> 194.120.236.0/22 | DE | {DE,NL}
>> 194.120.252.0/22 | DE | {DE,NL}
>> 194.121.4.0/22 | DE | {DE,NL}
>> 194.121.12.0/22 | DE | {DE,NL}
>> 194.121.28.0/22 | DE | {DE,NL}
>> 194.121.40.0/22 | DE | {DE,NL}
>> 194.121.52.0/22 | DE | {DE,NL}
>> 194.121.68.0/22 | DE | {DE,NL}
>> 194.121.92.0/22 | DE | {DE,NL}
>> 194.121.168.0/22 | DE | {DE,NL}
>> 194.121.248.0/22 | DE | {DE,NL}
>> 194.147.36.0/22 | GB | {GB,NL}
>> 212.104.212.0/22 | IL | {IL,DE}
>> 213.232.72.0/22 | DK | {DK,MT}
>> 5.57.20.0/23 | GB | {GB,NL}
>> 45.11.172.0/23 | GB | {GB,EU}
>> 45.11.174.0/23 | GB | {GB,EU}
>> 46.183.104.0/23 | GB | {GB,IE}
>> 87.254.206.0/23 | CN | {CN,IN}
>> 89.219.134.0/23 | EE | {EE,EU}
>> 89.219.152.0/23 | EE | {EE,EU}
>> 91.201.212.0/23 | CH | {CH,AT,DE}
>> 91.226.144.0/23 | SE | {SE,PT,ES,DK}
>> 93.183.12.0/23 | DE | {DE,FI}
>> 185.129.122.0/23 | US | {US,DE,SG}
>> 185.175.206.0/23 | AE | {AE,BE}
>> 193.103.236.0/23 | EU | {EU,US,CA}
>> 193.141.62.0/23 | DE | {DE,NL}
>> 193.141.88.0/23 | DE | {DE,NL}
>> 193.141.102.0/23 | DE | {DE,NL}
>> 193.141.122.0/23 | DE | {DE,NL}
>> 193.141.124.0/23 | DE | {DE,NL}
>> 193.141.136.0/23 | DE | {DE,NL}
>> 193.141.178.0/23 | DE | {DE,NL}
>> 193.141.190.0/23 | DE | {DE,NL}
>> 193.141.228.0/23 | DE | {DE,NL}
>> 193.219.218.0/23 | FR | {FR,LU}
>> 193.219.236.0/23 | FR | {FR,LU}
>> 193.220.126.0/23 | FR | {FR,LU,DE,NO}
>> 194.45.4.0/23 | DE | {DE,NL}
>> 194.45.24.0/23 | DE | {DE,NL}
>> 194.45.38.0/23 | DE | {DE,NL}
>> 194.45.50.0/23 | DE | {DE,NL}
>> 194.45.58.0/23 | DE | {DE,NL}
>> 194.45.68.0/23 | DE | {DE,NL}
>> 194.45.92.0/23 | DE | {DE,NL}
>> 194.45.98.0/23 | DE | {DE,NL}
>> 194.45.124.0/23 | DE | {DE,NL}
>> 194.45.132.0/23 | DE | {DE,NL}
>> 194.45.140.0/23 | DE | {DE,NL}
>> 194.45.170.0/23 | DE | {DE,NL}
>> 194.45.182.0/23 | DE | {DE,NL}
>> 194.45.186.0/23 | DE | {DE,NL}
>> 194.45.198.0/23 | DE | {DE,NL}
>> 194.45.202.0/23 | DE | {DE,NL}
>> 194.45.218.0/23 | DE | {DE,NL}
>> 194.45.224.0/23 | DE | {DE,NL}
>> 194.45.234.0/23 | DE | {DE,NL}
>> 194.45.238.0/23 | DE | {DE,NL}
>> 194.88.142.0/23 | IE | {IE,EE}
>> 194.93.76.0/23 | AT | {AT,DE}
>> 194.120.18.0/23 | DE | {DE,NL}
>> 194.120.20.0/23 | DE | {DE,NL}
>> 194.120.26.0/23 | DE | {DE,NL}
>> 194.120.42.0/23 | DE | {DE,NL}
>> 194.120.52.0/23 | DE | {DE,NL}
>> 194.120.106.0/23 | DE | {DE,NL}
>> 194.120.124.0/23 | DE | {DE,NL}
>> 194.120.134.0/23 | DE | {DE,NL}
>> 194.120.146.0/23 | DE | {DE,NL}
>> 194.120.148.0/23 | DE | {DE,NL}
>> 194.120.166.0/23 | DE | {DE,NL}
>> 194.120.168.0/23 | DE | {DE,NL}
>> 194.120.174.0/23 | DE | {DE,NL}
>> 194.120.180.0/23 | DE | {DE,NL}
>> 194.120.186.0/23 | DE | {DE,NL}
>> 194.120.190.0/23 | DE | {DE,NL}
>> 194.120.228.0/23 | DE | {DE,NL}
>> 194.120.232.0/23 | DE | {DE,NL}
>> 194.120.250.0/23 | DE | {DE,NL}
>> 194.121.8.0/23 | DE | {DE,NL}
>> 194.121.24.0/23 | DE | {DE,NL}
>> 194.121.44.0/23 | DE | {DE,NL}
>> 194.121.60.0/23 | DE | {DE,NL}
>> 194.121.64.0/23 | DE | {DE,NL}
>> 194.121.88.0/23 | DE | {DE,NL}
>> 194.121.252.0/23 | DE | {DE,NL}
>> 194.150.168.0/23 | DE | {DE,IL,NL,BE,GB,CH,FR,CZ,SE,EU}
>> 195.39.208.0/23 | AT | {AT,CZ,DE,HU,PL,SK,RO}
>> 195.158.230.0/23 | CH | {CH,LI}
>> 195.189.220.0/23 | GB | {GB,IE,FR}
>> 31.133.47.0/24 | UA | {UA,RU}
>> 37.10.7.0/24 | HK | {HK,SG}
>> 45.91.19.0/24 | US | {US,GB}
>> 46.102.239.0/24 | US | {US,NL}
>> 46.255.120.0/24 | US | {US,GB}
>> 77.70.163.0/24 | SK | {SK,FR}
>> 78.41.187.0/24 | SG | {SG,CH}
>> 78.41.188.0/24 | US | {US,CA}
>> 79.143.48.0/24 | US | {US,GB,FR,NL,DE,SG,JP,AU}
>> 84.33.33.0/24 | DE | {DE,IT,US,GB,NL,FR,SG,JP,AU,AT,BR}
>> 86.106.23.0/24 | US | {US,NL}
>> 89.39.147.0/24 | US | {US,NL}
>> 89.185.155.0/24 | GB | {GB,IE}
>> 89.219.154.0/24 | EE | {EE,EU}
>> 89.219.161.0/24 | EE | {EE,EU}
>> 89.219.162.0/24 | EE | {EE,EU}
>> 89.219.168.0/24 | EE | {EE,EU}
>> 91.198.188.0/24 | IL | {IL,DE}
>> 91.205.43.0/24 | BE | {BE,FR}
>> 91.232.229.0/24 | AT | {AT,CH,LI}
>> 93.174.255.0/24 | SG | {SG,US,GB}
>> 185.21.134.0/24 | BE | {BE,NL}
>> 185.24.255.0/24 | EU | {EU,US,SG,BR,IR}
>> 185.38.240.0/24 | US | {US,GB,DE}
>> 185.42.188.0/24 | GB | {GB,FR}
>> 185.65.142.0/24 | GB | {GB,EU}
>> 185.73.223.0/24 | EU | {EU,US}
>> 185.91.9.0/24 | NL | {NL,GB,US}
>> 185.94.65.0/24 | LV | {LV,NL,RU}
>> 185.94.67.0/24 | LV | {LV,NL,RU}
>> 185.130.46.0/24 | NL | {NL,CA,US,DE,AU,JP}
>> 185.143.232.0/24 | DE | {DE,NL,JP,IR,GB,US}
>> 185.143.233.0/24 | NL | {NL,DE,JP,IR,GB,US}
>> 185.143.234.0/24 | JP | {JP,NL,DE,IR,GB,US}
>> 185.143.235.0/24 | GB | {GB,NL,DE,JP,IR,US}
>> 185.144.91.0/24 | DE | {DE,US}
>> 185.151.204.0/24 | NL | {NL,DE,US}
>> 185.168.0.0/24 | SE | {SE,DK,DE,GB}
>> 185.168.1.0/24 | SE | {SE,DK,DE,GB}
>> 185.190.82.0/24 | US | {US,GB}
>> 185.190.124.0/24 | CH | {CH,DE}
>> 188.210.93.0/24 | US | {US,NL}
>> 188.213.243.0/24 | US | {US,NL}
>> 188.241.193.0/24 | US | {US,NL}
>> 193.16.213.0/24 | GB | {GB,NL}
>> 193.32.101.0/24 | GB | {GB,IE}
>> 193.39.115.0/24 | DE | {DE,NL,GB,ES,FR,US}
>> 193.41.248.0/24 | US | {US,DE,HK}
>> 193.103.162.0/24 | EU | {EU,US,CA}
>> 193.103.163.0/24 | EU | {EU,US,CA}
>> 193.104.217.0/24 | SE | {SE,FI}
>> 193.111.228.0/24 | NL | {NL,GE,BE}
>> 193.141.21.0/24 | DE | {DE,NL}
>> 193.141.22.0/24 | DE | {DE,NL}
>> 193.141.25.0/24 | DE | {DE,NL}
>> 193.141.26.0/24 | DE | {DE,NL}
>> 193.141.52.0/24 | DE | {DE,NL}
>> 193.141.54.0/24 | DE | {DE,NL}
>> 193.141.56.0/24 | DE | {DE,NL}
>> 193.141.59.0/24 | DE | {DE,NL}
>> 193.141.66.0/24 | DE | {DE,NL}
>> 193.141.90.0/24 | DE | {DE,NL}
>> 193.141.93.0/24 | DE | {DE,NL}
>> 193.141.100.0/24 | DE | {DE,NL}
>> 193.141.105.0/24 | DE | {DE,NL}
>> 193.141.106.0/24 | DE | {DE,NL}
>> 193.141.108.0/24 | DE | {DE,NL}
>> 193.141.111.0/24 | DE | {DE,NL}
>> 193.141.120.0/24 | DE | {DE,NL}
>> 193.141.138.0/24 | DE | {DE,NL}
>> 193.141.142.0/24 | DE | {DE,NL}
>> 193.141.189.0/24 | DE | {DE,NL}
>> 193.218.114.0/24 | GP | {GP,MQ}
>> 193.219.212.0/24 | GB | {GB,DE}
>> 193.219.235.0/24 | FR | {FR,LU}
>> 193.219.239.0/24 | FR | {FR,LU}
>> 193.219.240.0/24 | FR | {FR,LU}
>> 193.220.123.0/24 | FR | {FR,LU,DE,NO}
>> 194.33.109.0/24 | GB | {GB,UA}
>> 194.34.161.0/24 | DE | {DE,NL}
>> 194.45.21.0/24 | DE | {DE,NL}
>> 194.45.23.0/24 | DE | {DE,NL}
>> 194.45.32.0/24 | DE | {DE,NL}
>> 194.45.35.0/24 | DE | {DE,NL}
>> 194.45.44.0/24 | DE | {DE,NL}
>> 194.45.47.0/24 | DE | {DE,NL}
>> 194.45.49.0/24 | DE | {DE,NL}
>> 194.45.57.0/24 | DE | {DE,NL}
>> 194.45.70.0/24 | DE | {DE,NL}
>> 194.45.95.0/24 | DE | {DE,NL}
>> 194.45.96.0/24 | DE | {DE,NL}
>> 194.45.102.0/24 | DE | {DE,NL}
>> 194.45.107.0/24 | DE | {DE,NL}
>> 194.45.134.0/24 | DE | {DE,NL}
>> 194.45.155.0/24 | DE | {DE,NL}
>> 194.45.164.0/24 | DE | {DE,NL}
>> 194.45.166.0/24 | DE | {DE,NL}
>> 194.45.168.0/24 | DE | {DE,NL}
>> 194.45.180.0/24 | DE | {DE,NL}
>> 194.45.185.0/24 | DE | {DE,NL}
>> 194.45.201.0/24 | DE | {DE,NL}
>> 194.45.216.0/24 | DE | {DE,NL}
>> 194.45.226.0/24 | DE | {DE,NL}
>> 194.120.25.0/24 | DE | {DE,NL}
>> 194.120.41.0/24 | DE | {DE,NL}
>> 194.120.54.0/24 | DE | {DE,NL}
>> 194.120.108.0/24 | DE | {DE,NL}
>> 194.120.117.0/24 | DE | {DE,NL}
>> 194.120.118.0/24 | DE | {DE,NL}
>> 194.120.127.0/24 | DE | {DE,NL}
>> 194.120.132.0/24 | DE | {DE,NL}
>> 194.120.145.0/24 | DE | {DE,NL}
>> 194.120.151.0/24 | DE | {DE,NL}
>> 194.120.165.0/24 | DE | {DE,NL}
>> 194.120.172.0/24 | DE | {DE,NL}
>> 194.120.185.0/24 | DE | {DE,NL}
>> 194.120.188.0/24 | DE | {DE,NL}
>> 194.120.235.0/24 | DE | {DE,NL}
>> 194.120.248.0/24 | DE | {DE,NL}
>> 194.121.1.0/24 | DE | {DE,NL}
>> 194.121.3.0/24 | DE | {DE,NL}
>> 194.121.10.0/24 | DE | {DE,NL}
>> 194.121.27.0/24 | DE | {DE,NL}
>> 194.121.47.0/24 | DE | {DE,NL}
>> 194.121.57.0/24 | DE | {DE,NL}
>> 194.121.58.0/24 | DE | {DE,NL}
>> 194.121.67.0/24 | DE | {DE,NL}
>> 194.121.91.0/24 | DE | {DE,NL}
>> 194.121.255.0/24 | DE | {DE,NL}
>> 194.153.74.0/24 | NL | {NL,IE,SE,DK,DE,AT,CH,BE,FR,ES,GB}
>> 195.14.23.0/24 | CH | {CH,GB}
>> 195.22.222.0/24 | PE | {PE,US}
>> 195.46.39.0/24 | DE | {DE,GB,NL,NZ,US}
>> 195.85.254.0/24 | IL | {IL,IM,GG}
>> 195.95.150.0/24 | NL | {NL,GB}
>> 2a01:800::/24 | DE | {DE,NL}
>> 2a01:ce80::/26 | NL | {NL,BE,LU,ZA,ZW,MG,MZ,NA,AU,BI,BW,AE,BH,EG,SA,KW,JO,YE,TR,IL,CY,LB,SY,GR,GB,IE,KE,ET,ER,UG,NG,GH,SL,GM,CI,BJ,SN,GA,TD,MA,DZ,TN,LY,ES,PT,FR,CH,IT,MT,DE,PL,CZ,AT,SK,HU,RS,SI,HR,BA,ME,MK,BG,RO,UA,GE,AZ,BY,KG,KZ,UZ,IS,DK,NO,FI,SE,EE,LT,LV,RU,CO,VE,EC,GY,PE,CL,AR,UY,PY,BO,BR,GT,CR,SV,NI,HN,PA,BZ,PR,DO,TT,CU,CA,US,MX,NZ,NC,TO,PK,AF,IN,BD,LK,SG,MY,TH,ID,KH,VN,PH,HK,TW,CN,KR,KP,JP}
>> 2001:668::/29 | DE | {DE,SE,GR,NL,BE,AT,PL,IT,CH,NO,DK,CZ,US,CA,SK,ES,FR,GB,RO,HK,SG,IE}
>> 2001:730::/29 | NL | {NL,AT,CH,IE,HU,DE,PL,CZ,SK,RO}
>> 2001:4ce8::/29 | NL | {NL,DE}
>> 2a00:8a00::/29 | FI | {FI,DE,IN,SG,CN,US,BR}
>> 2a00:95c0::/29 | NL | {NL,DE}
>> 2a00:cee0::/29 | PS | {PS,FR,GB,DE,US}
>> 2a00:d120::/29 | NL | {NL,DE}
>> 2a01:ce90::/29 | CO | {CO,VE,EC,GY,PE,CL,AR,UY,PY,BO,BR,GT,CR,SV,NI,HN,PA,BZ,PR,DO,TT,CU,CA,US,MX}
>> 2a01:ce98::/29 | NZ | {NZ,NC,TO,AU,PK,AF,IN,BD,LK,SG,MY,TH,ID,KH,VN,PH,HK,TW,CN,KR,KP,JP}
>> 2a02:aa0::/29 | SE | {SE,DK}
>> 2a02:f180::/29 | FR | {FR,GB,RO,DE}
>> 2a02:fe00::/29 | NL | {NL,BE}
>> 2a03:f80::/29 | DE | {DE,CH,IT,GB,FR,US,HK,PL,CL,ES,IS,AT}
>> 2a04:a80::/29 | AE | {AE,AR,AT,AU,BE,BF,BG,BH,BR,BS,CA,CH,CI,CN,CO,CZ,DE,DK,DZ,EG,ES,GA,GB,GF,GN,GP,GR,HK,HU,ID,IE,IL,IN,IT,JP,KM,KR,KW,LU,LY,MA,ML,MQ,MX,MY,NC,NL,NO,PH,PL,PT,QA,RE,RO,RU,SA,SE,SG,SN,TH,TN,TR,TW,UA,US,VN,ZA,PE,PA,VE,CL,FR}
>> 2a04:11c0::/29 | FR | {FR,MQ,GP,GF}
>> 2a04:2980::/29 | GB | {GB,AE,IQ,DE}
>> 2a04:2ec0::/29 | JO | {JO,IQ,EG,BH,AE}
>> 2a04:4800::/29 | NL | {NL,GB}
>> 2a04:6e80::/29 | DK | {DK,SE,FI,NO,IR,NL,GB,US,CA,MX,BR,FR}
>> 2a04:7f00::/29 | BE | {BE,NL,LU}
>> 2a04:9200::/29 | US | {US,EU}
>> 2a04:ac80::/29 | NL | {NL,US}
>> 2a04:d200::/29 | AT | {AT,DE}
>> 2a04:db00::/29 | DE | {DE,GB,NL,BE}
>> 2a04:e4c0::/29 | NL | {NL,GB,DE,FR,DK,CZ,PL,RO}
>> 2a05:e580::/29 | SE | {SE,US,GB}
>> 2a06:1700::/29 | IS | {IS,RO,FI}
>> 2a07:4dc0::/29 | NL | {NL,RU,US}
>> 2a07:fcc0::/29 | IE | {IE,US}
>> 2a0b:39c0::/29 | IE | {IE,DE}
>> 2a0b:7e00::/29 | US | {US,DK}
>> 2a0e:fa00::/29 | NL | {NL,CH}
>> 2a01:ce84::/30 | GR | {GR,GB,IE,KE,ET,ER,UG,NG,GH,SL,GM}
>> 2a0f:7780::/30 | DK | {DK,DE,RO}
>> 2a0f:7784::/30 | DK | {DK,DE,RO}
>> 2a01:ce88::/31 | CI | {CI,BJ,SN,GA,TD,MA,DZ,TN,LY,ES,PT,FR,CH,IT,MT}
>> 2a01:ce8c::/31 | DE | {DE,PL,CZ,AT,SK,HU,RS,SI,HR,BA,ME,MK,BG,RO,UA,GE,AZ,BY,KG,KZ,UZ}
>> 2a01:ce8e::/31 | IS | {IS,DK,NO,FI,SE,EE,LT,LV,RU}
>> 2a01:ce94::/31 | GT | {GT,CR,SV,NI,HN,PA,BZ,PR,DO,TT,CU,CA,US,MX}
>> 2a01:ce9c::/31 | PK | {PK,AF,IN,BD,LK,SG,MY,TH,ID,KH,VN,PH,HK,TW,CN,KR,KP,JP}
>> 2a03:9d40::/31 | GB | {GB,NL,FR,DE,US,RU,CH}
>> 2001:680::/32 | DE | {DE,NL}
>> 2001:730::/32 | AT | {AT,CH,CZ,DE,HU,IE,NL,PL,RO,SK}
>> 2001:ad0::/32 | EE | {EE,DE,SE,RU,LT,LV,PL}
>> 2001:1ad0::/32 | AT | {AT,DE,NL}
>> 2a00:1888::/32 | FR | {FR,GB,DE,IT,CH,ES}
>> 2a00:80a0::/32 | AU | {AU,AT,BE,BR,CA,CL,CN,CZ,DK,FI,FR,DE,HK,HU,IN,IT,JP,MX,NL,NO,PL,SG,ZA,ES,SZ,SE,CH,TR,GB,AE,US}
>> 2a00:96c0::/32 | SE | {SE,DE,NO,DK,FR,GB}
>> 2a00:a2e0::/32 | DE | {DE,NL}
>> 2a00:bf60::/32 | CH | {CH,DE}
>> 2a00:e8a0::/32 | DE | {DE,US,IE,IN,IT,JP,PR,SG}
>> 2a01:20::/32 | FR | {FR,BE,DE}
>> 2a01:258::/32 | IE | {IE,GB}
>> 2a01:6dc0::/32 | RU | {RU,MD}
>> 2a01:8200::/32 | FR | {FR,GB}
>> 2a01:a0a0::/32 | DE | {DE,US,RU}
>> 2a01:ce82::/32 | ZA | {ZA,ZW,MG,MZ,NA,AU,BI,BW}
>> 2a01:ce83::/32 | AE | {AE,BH,EG,SA,KW,JO,YE,TR,IL,CY,LB,SY}
>> 2a01:ce85::/32 | GB | {GB,IE}
>> 2a01:ce87::/32 | KE | {KE,ET,ER,UG,NG,GH,SL,GM}
>> 2a01:ce89::/32 | ES | {ES,PT,FR,CH,IT,MT}
>> 2a01:ce8d::/32 | RS | {RS,SI,HR,BA,ME,MK,BG,RO,UA,GE,AZ,BY,KG,KZ,UZ}
>> 2a01:ce8f::/32 | EE | {EE,LT,LV,RU}
>> 2a01:ce95::/32 | CA | {CA,US,MX}
>> 2a01:ce9d::/32 | SG | {SG,MY,TH,ID,KH,VN,PH}
>> 2a01:ce9e::/32 | HK | {HK,TW,CN}
>> 2a01:ce9f::/32 | KR | {KR,KP,JP}
>> 2a02:3d0::/32 | GB | {GB,IE,CH,NL,DE,SE,FR,IT,ES,AT}
>> 2a02:9f8::/32 | GB | {GB,DE,FR}
>> 2a02:1340::/32 | GB | {GB,IE}
>> 2a02:23e0::/32 | FR | {FR,ES}
>> 2a02:48c0::/32 | AM | {AM,HR,CZ,DE,GE,GR,GL,IE,IT,JO,NL,PL,PT,RO,ES,SE,CH,GB,IL,FR}
>> 2a02:51e0::/32 | NL | {NL,GB}
>> 2a02:70c0::/32 | LU | {LU,FR,BE,DE,NL}
>> 2a02:7200::/32 | RU | {RU,LV,LT,ES,IR,LB,KZ,TJ,TM}
>> 2a02:7c40::/32 | DE | {DE,CH}
>> 2a03:35c0::/32 | DE | {DE,CN,GB,SG,BE,US}
>> 2a03:a7a0::/32 | RU | {RU,US}
>> 2a03:ae00::/32 | GB | {GB,NL}
>> 2a03:bdc0::/32 | FR | {FR,DE,SE,GB,NL,AT,BE,CH,IT,DK,NO,IL,US,ES}
>> 2a03:da80::/32 | AT | {AT,DE}
>> 2a03:eec0::/32 | GB | {GB,NL,DE,CH,FR}
>> 2a07:e00::/32 | BZ | {BZ,SE}
>> 2a07:68c0::/32 | US | {US,EU}
>> 2a0a:3980::/32 | US | {US,DE,HK,JP}
>> 2a0c:8fc1::/32 | SG | {SG,JP}
>> 2a0d:1a45::/32 | EU | {EU,SE,AQ,US}
>> 2a0e:e42::/32 | US | {US,GB}
>> 2a02:6600:2000::/36 | FR | {FR,NL,NO}
>> 2a07:e02:1000::/36 | NL | {NL,CA,US,DE,JP,AU}
>> 2a03:d5c0:1b00::/40 | GB | {GB,NL}
>> 2a07:1c44:1400::/40 | NL | {NL,CA,US}
>> 2a06:7a07::/43 | US | {US,GB,FR,NL,DE,SG,JP,AU}
>> 2001:67c:1020::/47 | AT | {AT,RU}
>> 2001:67c:268::/48 | CH | {CH,US}
>> 2001:67c:3fc::/48 | CH | {CH,AT,DE}
>> 2001:67c:2778::/48 | DE | {DE,GB,NL,NZ,US}
>> 2001:7f8:66::/48 | AT | {AT,CH,LI}
>> 2a00:fd80:aaaa::/48 | AU | {AU,GB}
>> 2a02:6604:3::/48 | NL | {NL,FR}
>> 2a06:7245::/48 | US | {US,DE}
>> 2a07:e00:b::/48 | US | {US,CA,AU,JP,NL,DE}
>> 2a09:be40:1170::/48 | EU | {EU,US}
>> 2a0f:4400::/48 | IE | {IE,FR,GB}
>> (596 rows)
>
> I'll reply more detailled to your answer within the next days, Deo volente. :-)
>
> Thanks, and best regards,
> Peter Müller
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: List of IP networks having more than one country assigned to
2021-05-07 10:48 ` Michael Tremer
@ 2021-05-14 15:59 ` Peter Müller
0 siblings, 0 replies; 5+ messages in thread
From: Peter Müller @ 2021-05-14 15:59 UTC (permalink / raw)
To: location
[-- Attachment #1: Type: text/plain, Size: 736 bytes --]
Hello Michael, hello location folks,
thanks for your reply.
> I would recommend to name any field with an array in its plural name. In this case “original_countries”. That makes it easier to understand what the content is and writing loops where you could simply have “for original_country in original_countries: …"
This makes sense. Since I have not yet found an elegant solution to include source information to
the network table, I guess I'll start with a patch creating an additional row for the original countries,
so we get at least some data about this phenomenon without hacking on our scripts every time.
Better than nothing, but nothing more than that... :-)
Thanks, and best regards,
Peter Müller
^ permalink raw reply [flat|nested] 5+ messages in thread
end of thread, other threads:[~2021-05-14 15:59 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2021-05-03 20:56 How should location-importer.in deal with RIR objects having multiple distinct "country" fields? Peter Müller
2021-05-04 8:07 ` Michael Tremer
2021-05-06 21:06 ` List of IP networks having more than one country assigned to (was: Re: How should location-importer.in deal with RIR objects having multiple distinct "country" fields?) Peter Müller
2021-05-07 10:48 ` Michael Tremer
2021-05-14 15:59 ` List of IP networks having more than one country assigned to Peter Müller
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox