Documentation

Schema reference

Field-level reference for the standard GeoIP Locations monthly release schema.

Scope

CSV and Parquet use the same flat schema for normal country, ALL, EDU, and GOV release scopes. MMDB carries comparable attribution fields but stores them as IP lookup records rather than a flat table.

Exception: BOG packages use a reduced schema because bogon ranges do not represent standard geolocation rows.

Field	Description	CSV type	Parquet type	MMDB representation	Notes
`network`	CIDR network for the /24 prefix or consolidated lookup network.	string	string	network key / record key	Primary network identifier.
`network_from`	Integer representation of the first IPv4 address in the /24.	integer	int64	not always exposed as a flat field	Useful for sorting and range joins.
`network_to`	Integer representation of the last IPv4 address in the /24.	integer	int64	not always exposed as a flat field	Normally network_from + 255 for /24 rows.
`prefix_length`	CIDR prefix length.	integer	int8	network prefix length	Usually 24 in flat exports.
`continent_code`	Two-letter continent code.	string	string	record field	Derived from country mapping.
`continent_name`	Continent name.	string	string	record field	Human-readable continent.
`is_in_european_union`	EU membership flag for the geolocation country.	boolean/text	bool	record field	True for EU member states.
`country_iso`	Geolocation country ISO code.	string	string	record field	Describes where the IP prefix is geolocated.
`country_name`	Geolocation country name.	string	string	record field	Human-readable country.
`registered_country_iso`	Registered country ISO code.	string	string	record field	Currently aligned with country-level metadata.
`registered_country_name`	Registered country name.	string	string	record field	Human-readable registered country.
`region_name`	Region or state name.	string	string	record field	May be empty.
`region_name_ascii`	ASCII-safe region name.	string	string	record field	Useful for systems requiring ASCII.
`city_name`	City name.	string	string	record field	May be empty.
`city_name_ascii`	ASCII-safe city name.	string	string	record field	Useful for systems requiring ASCII.
`latitude`	Latitude coordinate.	decimal	float64	record field	Precision depends on geolocation level.
`longitude`	Longitude coordinate.	decimal	float64	record field	Precision depends on geolocation level.
`timezone`	IANA timezone identifier.	string	string	record field	Usually derived from city geoname where available.
`accuracy_radius_km`	Estimated accuracy radius in kilometers.	integer	int16	record field	Typical values reflect city/region/country precision.
`geo_precision_level`	Precision level of the geolocation.	string	string	record field	city, region, country, or unknown.
`country_geonameid`	GeoNames ID for country.	integer	int32	record field	Reference identifier.
`region_geonameid`	GeoNames ID for region.	integer	int32	record field	May be null.
`city_geonameid`	GeoNames ID for city.	integer	int32	record field	May be null.
`admin1_code`	Administrative level 1 code.	string	string	record field	Useful for regional joins.
`feature_code`	GeoNames feature code.	string	string	record field	Indicates location feature type.
`asn`	Autonomous System Number.	integer	int32	record field	-1 means n/a; -2 means bogon.
`as_name`	Autonomous System name or description.	string	string	record field	Also used in reduced BOG schema.
`asn_type`	ASN type/classification.	string	string	record field	Business, Hosting, ISP, Government, etc.
`asn_country_iso`	ASN registry/owner country ISO code.	string	string	record field	Not the same as geolocation country.
`network_type`	Derived network classification.	string	string	record field	hosting, isp, business, education, government, etc.
`company_name`	Company alias or owner label where available.	string	string	record field	May be empty.
`rir`	Regional Internet Registry derived from ASN context.	string	string	record field	ASN-derived, not geolocation-derived.
`snapshot_month`	Monthly release identifier.	string	string	record field	Format YYYY-MM.