Name | Type | Description |
start_ip | BIGINT | Starting IP address of network range. |
end_ip | BIGINT | Ending IP address of network range. |
region | VARCHAR(128) | Geographical region name such as a state or county |
city | VARCHAR(128) | The name of the city in which the IP address is located |
country_code | VARCHAR(2) | ISO alpha 2 country code ( example US/UK/CA ) |
country_numeric | VARCHAR(3) | ISO numberic country code ( example: 840/826/124 ) |
country_iso3 | VARCHAR(3) | ISO alpha 3 country code ( example: USA/GBR/CAN ) |
country_name | VARCHAR(128) | The name of the country ( example: United States/United Kingdom/Canada ) |
latitude | FLOAT | Geographical latitude coordinate |
longitude | FLOAT | Geographical longitude coordinate |
timezone | VARCHAR(10) | The UTC time zone of the IP address. |