In the ASN and IP to Company database, the domain field is the unique identifier of organizations.
We recommend users filter the ASN or the company database based on the domain field, as it is the most unique identifier for individual organizations in the database. The reason for that is organizations can operate under different names in different countries. However, their official website or domain remains the same.
Moreover, different organizations can share the same organization name keyword. For example, this is the result of looking up Amazon from the ASN database.
| Organization Name |
|---|
| Amazon.com, Inc. |
| Amazon Data Services Ireland Ltd |
| Amazon Corporate Services |
| CONECTA AMAZONIA TELECOM LTDA. - ME |
| AMAZONET TELECOMUNICACOES LTDA |
| AMAZON+ SERVICOS DE INTERNET LTDA |
| AMAZONTEL TELECOMUNICACOES LTDA |
| Amazon.com Services, LLC |
| PRODAM Processamento de Dados Amazonas S.A |
| AMAZONAS TRIBUNAL DE JUSTICA |
| MPAM - Procuradoria-Geral de Justica do Amazonas |
| AMAZONIA TELECOMUNICACOES LTDA |
| AMAZONET TELECOM LTDA |
| SODECAM - Soc de Desenv. Cultural do Amazonas S/A |
| AMAZONET DIGITAL |
| Amazon Robotics LLC |
| AMAZONFIBER SERVICOS DE COMUNICACAO LTDA |
| Banco da Amazonia S/A |
SQL Query
-- on Snowflake
SELECT DISTINCT Name as "Organization Name"
FROM ip_asn
WHERE name ilike '%amazon%'
As you can see, you can not reliably identify which organization represents Amazon.com, Inc.
To ensure reliability, use the domain field to look up organizational information. The amazon.com domain field is shared across these organizations, which are essentially Amazon.com, Inc. but has different registered names across different countries.
| NAME | DOMAIN |
|---|---|
| http://amazon.com/, Inc. | http://amazon.com/ |
| Amazon Data Services Ireland Ltd | http://amazon.com/ |
| Amazon Corporate Services | http://amazon.com/ |
| http://amazon.com/ Services, LLC | http://amazon.com/ |
However, we do recommend users to practice their judgment in assessing this information. For example, AS395343 represents the organization “Amazon Robotics LLC” with the domain “kivasystems.com”. Kiva Systems was acquired by Amazon and now they represent Amazon Robotics division. So there are some organizational complexities involved.