# IP Geolocation adds an accuracy radius, last change and DMA

IP Geolocation now carries four more columns on every range: an accuracy radius, the date its location last changed, the city's GeoNames id and a US DMA code.

[IP Geolocation](https://internetdata.io/databases/ip-geolocation) has four more columns on every range: an accuracy radius, the date the range's location last changed, the city's GeoNames id and, in the US, its media market. They're in the same CSV and MMDB, rebuilt daily.

## Four more columns

| Column | What it holds |
|---|---|
| `accuracy_radius` | The radius in kilometers around the coordinates that holds the true location with 67% confidence; 20000 for an anycast range, which answers from many places |
| `last_changed` | The date the range's location (its country, region, city or coordinates) last changed |
| `geoname_id` | The city's id in the [GeoNames](https://www.geonames.org/) gazetteer |
| `dma_code` | A US city's TV market (DMA, designated market area) as its 3-digit code: 501 is New York, 803 Los Angeles |

Five rows from the database's sample, by the first address of each range:

| Range start | City | `accuracy_radius` | `last_changed` | `geoname_id` | `dma_code` |
|---|---|---|---|---|---|
| `74.42.24.170` | Ashburn, US | 2000 | 2026-10-02 | 4744870 | 511 |
| `2600:141b:e800:30::` | Piscataway, US | 10 | 2026-10-01 | 5102713 | 501 |
| `206.172.98.37` | Toronto, CA | 10 | 2026-10-07 | 6167865 | |
| `129.148.12.0` | São Paulo, BR | 500 | 2026-10-01 | 3448439 | |
| `1.0.0.0` | Sydney, AU | 20000 | 2026-10-07 | 2147714 | |

## What the columns are for

`accuracy_radius` says how far to trust a row's city: a 10 km row can be acted on at the city, and a 2000 km one is closer to a country answer. `1.0.0.0` is anycast, answered from many places, so its radius covers the planet.

`last_changed` says which ranges moved since your last pull, so a system that keys anything on location reprocesses only the rows whose date is newer. The earliest date in the file, October 1, means on or before that day.

`geoname_id` joins a row to GeoNames' own records for the city, its population and its alternate names among them, and `dma_code` puts a US address in its media market, for ad targeting and reporting.

## What's in it

The October 16 build holds 11,282,055 ranges in 58,230 cities, each with its GeoNames id. Every one of the 1,524,987,251 US IPv4 addresses carries a DMA code, across all 210 markets.

## Getting access

IP Geolocation ships as CSV and MMDB, rebuilt daily, and its [docs page](https://docs.internetdata.io/database/ip-geolocation) has the schema. [Sign up](https://app.internetdata.io/auth/signup) to evaluate it from its sample. A license is per database and never metered: see [licensing](https://internetdata.io/pricing), or [talk to us](https://internetdata.io/contact) about what you need. With a license, it's in [BigQuery](https://docs.internetdata.io/integrations/bigquery) too. A range's continent, country and timezone are free in [IP Country](https://internetdata.io/databases/ip-country).