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