How should location-importer.in deal with RIR objects having multiple distinct "country" fields?
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@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
Hey Peter,
On 3 May 2021, at 21:56, Peter Müller peter.mueller@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@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
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
Hello,
On 6 May 2021, at 22:06, Peter Müller peter.mueller@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
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
-
Michael Tremer -
Peter Müller