Name: Regional_Variables_Housing

Display Field: Jurisdiction

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Jurisdiction (type: esriFieldTypeString, alias: Jurisdiction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NH_2010 (type: esriFieldTypeInteger, alias: Number of households. 2010, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2010 (type: esriFieldTypeDouble, alias: Average household size, 2010, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NH_2011 (type: esriFieldTypeInteger, alias: Number of households, 2011, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2011 (type: esriFieldTypeDouble, alias: Average household size, 2011, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NH_2012 (type: esriFieldTypeInteger, alias: Number of households, 2012, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2012 (type: esriFieldTypeDouble, alias: Average household size, 2012, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NH_2013 (type: esriFieldTypeInteger, alias: Number of households, 2013, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2013 (type: esriFieldTypeDouble, alias: Average household size, 2013, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NH_2014 (type: esriFieldTypeInteger, alias: Number of households, 2014, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2014 (type: esriFieldTypeDouble, alias: Average household size, 2014, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NH_2015 (type: esriFieldTypeInteger, alias: Number of households, 2015, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2015 (type: esriFieldTypeDouble, alias: Average household size, 2015, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NH_2016 (type: esriFieldTypeInteger, alias: Number of households, 2016, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2016 (type: esriFieldTypeDouble, alias: Average household size, 2016, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NH_2017 (type: esriFieldTypeInteger, alias: Number of households, 2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2017 (type: esriFieldTypeDouble, alias: Average household size, 2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NH_2018 (type: esriFieldTypeInteger, alias: Number of households, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2018 (type: esriFieldTypeDouble, alias: Average household size, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NH_2019 (type: esriFieldTypeInteger, alias: Number of households, 2019, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2019 (type: esriFieldTypeDouble, alias: Average household size, 2019, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NH_2020 (type: esriFieldTypeInteger, alias: Number of households, 2020, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2020 (type: esriFieldTypeDouble, alias: Average household size, 2020, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NH_2021 (type: esriFieldTypeInteger, alias: Number of households, 2021, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2021 (type: esriFieldTypeDouble, alias: Average household size ,2021, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NH_2022 (type: esriFieldTypeInteger, alias: Number of households, 2022, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2022 (type: esriFieldTypeDouble, alias: Average household size, 2022, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NH_2023 (type: esriFieldTypeInteger, alias: Number of households, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2023 (type: esriFieldTypeDouble, alias: Average household size, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_2018 (type: esriFieldTypeDouble, alias: % of family households, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NF_2018 (type: esriFieldTypeDouble, alias: % of non-family households, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S_2018 (type: esriFieldTypeDouble, alias: % of single-person households, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_2023 (type: esriFieldTypeDouble, alias: % of family households, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NF_2023 (type: esriFieldTypeDouble, alias: % of non-family households, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S_2023 (type: esriFieldTypeDouble, alias: % of single-person households, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HR_2018 (type: esriFieldTypeDouble, alias: Homeownership rate, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HR_2023 (type: esriFieldTypeDouble, alias: Homeownership rate, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HU_2010 (type: esriFieldTypeInteger, alias: Number of housing units, 2010, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HU_2011 (type: esriFieldTypeInteger, alias: Number of housing units, 2011, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HU_2012 (type: esriFieldTypeInteger, alias: Number of housing units, 2012, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HU_2013 (type: esriFieldTypeInteger, alias: Number of housing units, 2013, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HU_2014 (type: esriFieldTypeInteger, alias: Number of housing units, 2014, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HU_2015 (type: esriFieldTypeInteger, alias: Number of housing units, 2015, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HU_2016 (type: esriFieldTypeInteger, alias: Number of housing units, 2016, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HU_2017 (type: esriFieldTypeInteger, alias: Number of housing units, 2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HU_2018 (type: esriFieldTypeInteger, alias: Number of housing units, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HU_2019 (type: esriFieldTypeInteger, alias: Number of housing units, 2019, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HU_2020 (type: esriFieldTypeInteger, alias: Number of housing units, 2020, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HU_2021 (type: esriFieldTypeInteger, alias: Number of housing units, 2021, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HU_2022 (type: esriFieldTypeInteger, alias: Number of housing units, 2022, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HU_2023 (type: esriFieldTypeInteger, alias: Number of housing units, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_1a (type: esriFieldTypeInteger, alias: No. of single-family detached units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_1b (type: esriFieldTypeDouble, alias: % of single-family detached units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2a (type: esriFieldTypeInteger, alias: No. of single family attached units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_2b (type: esriFieldTypeDouble, alias: % of single-family attached units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_3a (type: esriFieldTypeInteger, alias: No. of multi-family 2-4 units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_3b (type: esriFieldTypeDouble, alias: % of multi-family 2-4 units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_4a (type: esriFieldTypeInteger, alias: No. of multi-family 5-9 units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_4b (type: esriFieldTypeDouble, alias: % of multi-family 5-9 units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_5a (type: esriFieldTypeInteger, alias: No. of multi-family, 10+ units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_5b (type: esriFieldTypeDouble, alias: % of multi-family 10+ units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_6a (type: esriFieldTypeInteger, alias: No. of mobile home or other units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HS_6b (type: esriFieldTypeDouble, alias: % of mobile home or other units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SF_2018 (type: esriFieldTypeDouble, alias: Single-family detached homes as % of total housing stock, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SF_2023 (type: esriFieldTypeDouble, alias: Single-family detached homes as % of total housing stock, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MA_T (type: esriFieldTypeInteger, alias: Median year built, total occupied units, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MA_O (type: esriFieldTypeInteger, alias: Median year built of all owner-occupied units, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MA_R (type: esriFieldTypeInteger, alias: Median year built of all renter-occupied units, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_1a (type: esriFieldTypeInteger, alias: No. of housing units built pre-1970, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_1b (type: esriFieldTypeDouble, alias: % of housing units built pre-1970, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_2a (type: esriFieldTypeInteger, alias: No. of housing units built 1970s, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_2b (type: esriFieldTypeDouble, alias: % of housing units built 1970s, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_3a (type: esriFieldTypeInteger, alias: No. of housing units built 1980s , SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_3b (type: esriFieldTypeDouble, alias: % of housing units built 1980s, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_4a (type: esriFieldTypeInteger, alias: No. of housing units built 1990s, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_4b (type: esriFieldTypeString, alias: % of housing units built 1990s, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• A_5a (type: esriFieldTypeInteger, alias: No. of housing units built 2000s, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_5b (type: esriFieldTypeDouble, alias: % of housing units built 2000s, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_6a (type: esriFieldTypeInteger, alias: No. of housing units built 2010s , SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_6b (type: esriFieldTypeDouble, alias: % of housing units built 2010s, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_7a (type: esriFieldTypeInteger, alias: No. of housing units built 2020s, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_7b (type: esriFieldTypeDouble, alias: % of housing units built 2020s, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FSH_1a (type: esriFieldTypeInteger, alias: No. of units subsidized by Low-Income Housing Tax Credit (LIHTC), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FSH_1b (type: esriFieldTypeDouble, alias: % of units subsidized by LIHTC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FSH_2a (type: esriFieldTypeInteger, alias: No. of units subsidized by HUD Public Housing, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FSH_2b (type: esriFieldTypeDouble, alias: % of units subsidized by HUD Public Housing, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FSH_3a (type: esriFieldTypeInteger, alias: No. of units subsidized by HUD Multifamily , SQL Type: sqlTypeOther, nullable: true, editable: true)
• FSH_3b (type: esriFieldTypeDouble, alias: % of units subsidized by HUD Multifamily , SQL Type: sqlTypeOther, nullable: true, editable: true)
• FSH_4a (type: esriFieldTypeInteger, alias: No. of units subsidized by USA Rural Development, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FSH_4b (type: esriFieldTypeDouble, alias: % of units subsidized by USA Rural Development, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FSH_5a (type: esriFieldTypeInteger, alias: No. of units subsidized by two or more programs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FSH_5b (type: esriFieldTypeDouble, alias: % of units subsidized by two or more programs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SH_2023 (type: esriFieldTypeDouble, alias: % of renter households below 50% AMI that are subsidized , SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_2010 (type: esriFieldTypeDouble, alias: Vacancy rate, 2010, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_2011 (type: esriFieldTypeDouble, alias: Vacancy rate, 2011, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_2012 (type: esriFieldTypeDouble, alias: Vacancy rate, 2012, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_2013 (type: esriFieldTypeDouble, alias: Vacancy rate, 2013, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_2014 (type: esriFieldTypeDouble, alias: Vacancy rate, 2014, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_2015 (type: esriFieldTypeDouble, alias: Vacancy rate, 2015, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_2016 (type: esriFieldTypeDouble, alias: Vacancy rate, 2016, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_2017 (type: esriFieldTypeDouble, alias: Vacancy rate, 2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_2018 (type: esriFieldTypeDouble, alias: Vacancy rate, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_2019 (type: esriFieldTypeDouble, alias: Vacancy rate, 2019, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_2020 (type: esriFieldTypeDouble, alias: Vacancy rate, 2020, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_2021 (type: esriFieldTypeDouble, alias: Vacancy rate, 2021, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_2022 (type: esriFieldTypeDouble, alias: Vacancy rate, 2022, SQL Type: sqlTypeOther, nullable: true, editable: true)
• V_2023 (type: esriFieldTypeDouble, alias: Vacancy rate, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VT_1_2018 (type: esriFieldTypeDouble, alias: % of vacant units for rent, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VT_1_2023 (type: esriFieldTypeDouble, alias: % of vacant units for rent, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VT_2_2018 (type: esriFieldTypeDouble, alias: % of vacant units rented, not occupied, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VT_2_2023 (type: esriFieldTypeDouble, alias: % of vacant units rented, not occupied, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VT_3_2018 (type: esriFieldTypeDouble, alias: % of vacant units for sale, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VT_3_2023 (type: esriFieldTypeDouble, alias: % of vacant units for sale, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VT_4_2018 (type: esriFieldTypeDouble, alias: % of vacant units sold, not occupied, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VT_4_2023 (type: esriFieldTypeDouble, alias: % of vacant units sold, not occupied, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VT_5_2018 (type: esriFieldTypeDouble, alias: % of vacant units for seasonal, recreational, or occasional use, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VT_5_2023 (type: esriFieldTypeDouble, alias: % of vacant units for seasonal, recreational, or occasional use, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VT_6_2018 (type: esriFieldTypeDouble, alias: % of vacant units for migrant workers, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VT_6_2023 (type: esriFieldTypeInteger, alias: % of vacant units for migrant workers, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VT_7_2018 (type: esriFieldTypeDouble, alias: % of vacant units, other, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VT_7_2023 (type: esriFieldTypeDouble, alias: % of vacant units, other, 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• O_1_2018 (type: esriFieldTypeDouble, alias: % of households that are overcrowded (1-1.5 occupants per room), 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• O_1_2023 (type: esriFieldTypeDouble, alias: % of households that are overcrowded (1-1.5 occupants per room), 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• O_2_2018 (type: esriFieldTypeDouble, alias: % of households that are severely overcrowded (>1.5 occupants per room), 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• O_2_2023 (type: esriFieldTypeDouble, alias: % of households that are severely overcrowded (>1.5 occupants per room), 2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S_1 (type: esriFieldTypeDouble, alias: Incomplete plumbing rate per 1,000 units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S_2 (type: esriFieldTypeDouble, alias: Incomplete kitchen rate per 1,000 units , SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Regional_Variables_Housing
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/24/2025 10:38:32 PM

Schema Last Edit Date: 4/24/2025 10:38:32 PM

Data Last Edit Date: 4/24/2025 10:38:32 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat