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 |
organisation | VARCHAR(128) | Name of the organisation owning the network or IP address. |
isp_name | VARCHAR(256) | Name of the Internet Service Provider through which the IP is connected. |
netspeed | VARCHAR(60) | An evaluation of the network link quality |
timezone | VARCHAR(10) | The UTC time zone of the IP address. |
zipcode | VARCHAR(128) | The Zip code or Postal code of the city in which the IP address is located. |
country_phone_code | VARCHAR(100) | The calling code of the country in which the IP address is located. |
currency_code | VARCHAR(3) | Currency code ( example: EUR/USD/GBP ) |
currency_num | VARCHAR(3) | Currency numberic code ( example: 978/840/826 ) |