Table 'Person.StateProvince', State and province lookup table.

Table 'Person.StateProvince', State and province lookup table.

Property NameProperty Value
Records181
Fields8
Record size (bytes) w/o BLOBs153

Field statistics for 'StateProvinceID' int identity

Field propertyProperty Value
Minimum value1
Maximum value181
Average value91.0
Values variance2745.1666666666665
Unique values181

Field statistics for 'StateProvinceCode' nchar(3)

Field propertyProperty Value
Minimum value01
Maximum valueYT
Unique values181

Field statistics for 'CountryRegionCode' nvarchar(3)

Field propertyProperty Value
Minimum valueAS
Maximum valueVI
Unique values12

Field statistics for 'IsOnlyStateProvinceFlag' Flag

Field propertyProperty Value
Unique values2

Field statistics for 'Name' Name

Field propertyProperty Value
Minimum valueAin
Maximum valueYveline
Unique values181

Field statistics for 'TerritoryID' int

Field propertyProperty Value
Minimum value1
Maximum value10
Average value5.8397790055248615
Values variance4.7130755064456729
Unique values10

Field statistics for 'rowguid' uniqueidentifier

Field propertyProperty Value
Unique values181

Field statistics for 'ModifiedDate' datetime

Field propertyProperty Value
Minimum value1998-06-01 00:00:00.000
Maximum value2004-03-11 10:17:21.587
Unique values2