| Field |
Data Type |
Field Description |
| Country Code |
char(2) |
ISO 3166 Country Code,
with the addition of
|
| Country Name |
varchar(50) |
The name of the country |
| State/Region |
char(2) |
For US/Canada, ISO-3166-2 code for the state/province name, with the addition of AA, AE, and AP for Armed Forces America, Europe and Pacific. Outside of the US and Canada, FIPS 10-4 code. Region name lookups are available in selected APIs |
| State/Region Name |
varchar(255) |
The name of the region |
| City Name |
varchar(255) |
Name of city or town in ISO-8859-1 encoding. A list of cities contained in GeoIP City is available. A localized CSV file containing city names in various languages is available. |
| Latitude |
numeric (float) |
Latitude of city where IP is located |
| Longitude |
numeric (float) |
Longitude of city where IP is located |
| Metro Code |
unsigned int |
Metropolitan Area (US Only). |
| Area Code |
unsigned int |
Three digit telephone prefix (US Only). |
| Time zone |
varchar(255) |
Time zone possible values |
| Continent |
varchar(2) |
Continent code possible values. |
| Postal Code |
varchar(6) |
For US, Zipcodes, for Canada, postal codes.
More info.
|
| ISP Name |
varchar(50) |
Name of ISP that owns IP, including wireless carriers |
| Netblock End User |
varchar(50) |
Name of organization that IP is assigned to |
| Domain Name |
varchar(255) |
Top/Second Level Domain Name |
| AS Number |
varchar(1023) |
Autonomous system number |
| Netspeed |
varchar(255) |
Netspeed can have the following values:
- Dialup
- Cable/DSL
- Corporate
- Cellular
|
| User Type |
varchar(255) |
User type can have the following values:
- business
- cafe
- cellular
- college
- contentDeliveryNetwork
- government
- hosting
- library
- military
- residential
- router
- school
- searchEngineSpider
- traveler
|
| Accuracy Radius |
unsigned int |
The average distance between the actual location of the end user using the IP address and the location returned by the GeoIP City database, in kilometers |
| Country Confidence Factor |
unsigned int |
Value from 0-100 representing our confidence that the country location is correct |
| City Confidence Factor |
unsigned int |
Value from 0-100 representing our confidence that the city location is correct |
| Region Confidence Factor |
unsigned int |
Value from 0-100 representing our confidence that the region location is correct |
| Postal Code Confidence Factor |
unsigned int |
Value from 0-100 representing our confidence that the postal code is correct |
| Error |
varchar(255) |
Error message |