IPGeolocation.io: IP to Location

**Provider Overview**

IPGeolocation.io is a trusted provider of accurate, continuously updated IP address intelligence used by thousands of businesses worldwide. From startups to enterprises, our customers rely on us to power fraud detection, audience targeting, content localization, and compliance workflows with precise, structured location data.

Our database is built and maintained in-house using a rigorous multi-source validation process, combining routing data, ISP inputs, and geographic boundary updates to deliver the most accurate IP-to-location mapping available.

**Dataset Information**

This dataset maps every public IPv4 and IPv6 address to its precise geographic location, enriched with 27 attributes including timezone, currency, calling code, spoken languages, DMA code, and connection type. The data is structured and query-ready, allowing you to join it with your existing tables using standard SQL with no preprocessing required.<br/><br/>**Support Information**<br/>For assistance, custom data requirements or enterprise license inquiries, our team is ready to help. Reach us at [e-mail]

原始信息汇总

数据集概要

数据集名称: IPGeolocation.io: IP to Location
提供方: IPGeolocation.io

数据集描述

该数据集将每一个公共 IPv4 和 IPv6 地址映射到其精确的地理位置，并包含 27 个属性，如时区、货币、电话区号、使用语言、DMA 代码和连接类型。数据结构化，可直接查询，无需预处理，即可通过标准 SQL 与现有表进行连接。

业务用途

• IP 增强数据仓库：通过简单的 SQL 连接，为原始事件和交易数据补充精确的城市级地理位置属性，包括时区、连接类型、DMA 代码等。
• 欺诈与异常检测：将精确的地理位置信息叠加到流量和交易数据上，以标记可疑活动，检测不可能出现的出行模式，识别高风险区域。
• 超本地化受众定向：将 IP 地址解析到区、城市和邮政编码级别，构建精细的地理受众细分，用于定向营销活动、本地化定价和区域性内容分发。

数据字典

• 表名: IP_TO_CITY
• 主要字段:
  • JOIN_KEY: Varchar
  • START_IP: Varchar
  • END_IP: Varchar
  • CONTINENT_CODE: Varchar
  • CONTINENT_NAME: Varchar
  • COUNTRY_CODE2: Varchar
  • COUNTRY_CODE3: Varchar
  • COUNTRY_CODE_IOC: Varchar
  • COUNTRY_NAME: Varchar
  • COUNTRY_NAME_OFFICIAL: Varchar
  • COUNTRY_CAPITAL: Varchar
  • CURRENCY_CODE: Varchar
  • CURRENCY_NAME: Varchar
  • CURRENCY_SYMBOL: Varchar
  • CALLING_CODE: Varchar
  • TLD: Varchar
  • LANGUAGES: Varchar
  • STATE: Varchar
  • STATE_CODE: Varchar
  • DISTRICT: Varchar
  • CITY: Varchar
  • ACCURACY_RADIUS: Float
  • CONFIDENCE: Varchar
  • DMA_CODE: Number
  • ZIP_CODE: Varchar
  • LATITUDE: Float
  • LONGITUDE: Float
  • GEO_NAME_ID: Number
  • TIME_ZONE_NAME: Varchar
  • CONNECTION_TYPE: Varchar
  • START_IP_INT: Variant
  • END_IP_INT: Variant
• 字段总数: 33

使用示例

1. 查询单个 IPv4/IPv6 地址: sql SELECT * FROM TABLE(PUBLIC.LOOKUP_IP_TO_CITY(8.8.8.8));

2. 获取单个 IP 的关键位置字段: sql SELECT CITY, STATE, COUNTRY_NAME, COUNTRY_CODE2, ZIP_CODE, TIME_ZONE_NAME, CONNECTION_TYPE FROM TABLE(PUBLIC.LOOKUP_IP_TO_CITY(8.8.8.8));

3. 查询多个 IP 地址: sql WITH logs AS ( SELECT ip FROM (VALUES (203.171.127.212), (18.220.200.22), (59.174.177.230), (81.23.44.81), (130.235.105.168), (186.37.128.239)) AS v(ip) ) SELECT l.ip, g.* FROM logs l JOIN TABLE(PUBLIC.LOOKUP_IP_TO_CITY(l.ip)) g;

4. 按国家和连接类型筛选 IP: sql SELECT START_IP, END_IP, CITY, STATE, COUNTRY_NAME, CONNECTION_TYPE FROM PUBLIC.IP_TO_CITY WHERE COUNTRY_CODE2 = US AND CONNECTION_TYPE = Cable LIMIT 100;

数据交付与更新

• 交付方式: Secure share
• 更新频率: 月度 (Monthly)

试用与定价

• 试用: 限时 7 天免费试用 (Limited time trial: 7 days)
• 定价: 需要解锁查看 (Get Unlock New Insights)