Information for the AnalyticsSourceZipCode
Columns
ZipCode
(datatype: nvarchar(50)) Required Primary Key
GeoFence
(datatype: geography) Required Primary Key
State
(datatype: nvarchar(2)) Required Primary Key
City
(datatype: nvarchar(50)) Required Primary Key
SquareMiles
(datatype: decimal(18, 2)) Required Primary Key
HouseholdsTotal
(datatype: int) Required Primary Key
FamiliesTotal
(datatype: int) Required Primary Key
FamiliesUnder10kPercent
(datatype: decimal(18, 2)) Required Primary Key
Families10kTo14kPercent
(datatype: decimal(18, 2)) Required Primary Key
Families15kTo24kPercent
(datatype: decimal(18, 2)) Required Primary Key
Families25kTo34kPercent
(datatype: decimal(18, 2)) Required Primary Key
Families35kTo49kPercent
(datatype: decimal(18, 2)) Required Primary Key
Families50kTo74kPercent
(datatype: decimal(18, 2)) Required Primary Key
Families75kTo99kPercent
(datatype: decimal(18, 2)) Required Primary Key
Families100kTo149kPercent
(datatype: decimal(18, 2)) Required Primary Key
Families150kTo199kPercent
(datatype: decimal(18, 2)) Required Primary Key
FamiliesMore200kPercent
(datatype: decimal(18, 2)) Required Primary Key
FamiliesMedianIncome
(datatype: decimal(18, 2)) Required Primary Key
FamiliesMedianIncomeMarginOfError
(datatype: decimal(18, 2)) Required Primary Key
FamiliesMeanIncome
(datatype: decimal(18, 2)) Required Primary Key
FamiliesMeanIncomeMarginOfError
(datatype: decimal(18, 2)) Required Primary Key
MarriedCouplesTotal
(datatype: int) Required Primary Key
NonFamilyHouseholdsTotal
(datatype: int) Required Primary Key
LastUpdate
(datatype: int) Required Primary Key