IPinfo Core

## **Provider Overview**

**Enrich your data with IPinfo,** the trusted source for IP intelligence. We are the first choice data provider for customers who value accuracy. Behind every IP address data point there's an innovative multi-step validation process, an expert data team, and a commitment to continuous improvement.

1,300,000+ users trust our data, from non-profits to Fortune 500s companies. Click[ here](https://ipinfo.io/customers) to see why.

## **Dataset Information**

Lookup an IP address using IPinfo Core database and get:

- **Geolocation data:** City, Region (name and code), Continent (name and code), Country (name and code), Latitude and longitude, Timezone, Postal Code
- **Privacy detection:** Anonymous and Hosting IPs boolean flags
- **ASN data:** ASN Number, ASN Domain, ASN Name, ASN Type, ASN Country
- **Mobile detection**
- **Satellite detection**
- **Anycast detection**

IPinfo Core delivers complete city-level geolocation data combined with network and privacy insights, perfect for organizations requiring accurate IP data to define geolocation with certainty. This is IPinfo's most popular offering, providing the essential IP data fields needed for common use cases across cybersecurity, marketing, compliance, and analytics.

Need more? Upgrade to IPinfo Plus for extra context and higher resolution data, or IPinfo Custom for enterprise-grade data packages with advanced and personalized features.

Check out our Data Dictionary below to see a data preview and additional details about the IP data included in this dataset.

## **Documentation**

We encourage using our pre-built UDFs/UDTFs for seamless integration and optimal query performance. For the best results, please follow the detailed instructions in our documentation. If you need further assistance, our IPinfo community is here to help.

1. [IPinfo Snowflake Documentation](https://ipinfo.io/developers/snowflake_integration)
2. [IPinfo Community](https://community.ipinfo.io/docs?tags=snowflake)

## **Usage Conditions**

The data in this listing can only be used for your own internal business purposes, where the data is in no way referenced, ingested or integrated into any products, services or solutions that are delivered to and consumed by external end users.

## **Support and Contact Information**

If you need any assistance or wish to discuss customization, external license agreements or anything else, our data experts will be happy to help and can be contacted at [e-mail]

原始信息汇总

IPinfo Core 数据集概述

数据集基本信息

• 提供商: IPinfo Inc.
• 价格: $2,625/月
• 试用: 14天无限试用
• 数据刷新频率: 每周
• 地理覆盖范围: 全球（按邮政编码）

数据集内容

• 地理位置数据:
  • 城市、地区（名称和代码）、大陆（名称和代码）、国家（名称和代码）
  • 经纬度、时区、邮政编码
• 隐私检测:
  • 匿名和托管IP的布尔标志
• ASN数据:
  • ASN编号、ASN域名、ASN名称、ASN类型、ASN国家
• 其他检测:
  • 移动检测、卫星检测、Anycast检测

主要用途

• 受众细分: 按城市或地区划分用户，优化营销活动。
• 位置数据丰富化: 提供精确的城市、邮政编码和时区数据。
• 欺诈补救: 通过城市级检查识别可疑登录或位置变动。
• 个性化客户体验: 根据用户的城市或地区提供定制内容。
• 联系人数据丰富化: 结合ASN细节，用于CRM中的潜在客户评分。
• 风险分析: 根据城市级上下文和隐私标志调整风险模型。

使用示例

1. 丰富固定IP地址列表: sql WITH logs AS ( SELECT ip FROM (VALUES (21.146.22.125), (56.200.20.153), (124.25.156.143), (148.167.153.224), (64.10.101.135), (205.203.92.170), (36.20.73.115), (133.158.33.54) ) AS v(ip) ) SELECT * FROM logs l JOIN TABLE(public.GET_IP_CORE(l.ip));

2. 查询单个IP地址信息: sql SELECT * FROM TABLE(public.GET_IP_CORE(21.146.22.125));

3. 预览数据集: sql SELECT * FROM public.ip_core LIMIT 10;

4. 查找特定城市/地区的IP地址: sql SELECT flat_data.value as IP_RANGE FROM ( SELECT public.range_to_cidr(start_ip, end_ip) as ip_range FROM public.ip_core WHERE city = Chicago AND region = Illinois ) chicago_ips, TABLE(FLATTEN(chicago_ips.ip_range)) flat_data;

支持与联系

• 销售: [e-mail]
• 支持: https://ipinfo.io/support

文档

• IPinfo Snowflake 文档
• IPinfo 社区

搜集汇总

背景与挑战

背景概述

IPinfo Core是IPinfo提供的核心IP情报数据集，包含城市级地理位置、网络属性（如ASN、隐私检测）等关键字段，适用于网络安全、营销和合规等场景。该数据集仅限内部业务使用，不能集成到对外产品或服务中。