IPinfo Core: M 1k

## **Dataset Information**

**Enrich your data with IPinfo,** the trusted source for IP intelligence. 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**

**This listing provides monthly data refresh and 1,000 queries included in the price (overages are $0.10 per query thereafter).**

## **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)
3. Email: [e-mail]

## **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.

原始信息汇总

IPinfo Core: M 1k 数据集概述

数据集基本信息

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

数据集内容

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

主要用途

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

数据字典

• 核心函数: GET_IP_CORE(VARCHAR(16777216))
• 主要字段:
  • START_IP_INT, END_IP_INT, JOIN_KEY, START_IP, END_IP
  • CITY, REGION, REGION_CODE, COUNTRY, COUNTRY_CODE
  • CONTINENT, CONTINENT_CODE, LATITUDE, LONGITUDE, TIMEZONE, POSTAL_CODE
  • ASN, AS_NAME, AS_DOMAIN, AS_TYPE
  • IS_ANONYMOUS, IS_ANYCAST, IS_HOSTING, IS_MOBILE, IS_SATELLITE

使用示例

1. 丰富固定IP地址列表的元数据: sql WITH logs AS ( SELECT ip FROM (VALUES (21.146.22.125), (56.200.20.153)) 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. 预览IPinfo核心数据库: 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;

相关数据集

• IPinfo Geolocation IP Address Data
• IPinfo: IP Geolocation Training/Education Sample
• IPinfo Company IP Address Data
• IPinfo IP Address Data for Privacy Detection
• Comprehensive IP WHOIS Data
• IPinfo Custom

联系方式

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