This page provides basic descriptions of the key variables used in this study after they were prepared.

Datasets for Residential Properties with an Improvement (Building)

PROPERTY: Information on location and general characteristics of the property

IMPROVEMENT DWELLING: Information on the dwelling

INTERIOR IMPROVEMENT DWELLING:  Information on the interior of the dwelling

ASSESSMENTS:  Information on the assessment per a property

REAL ESTATE ASSESSMENT PAYMENT HISTORY:   Information on the annual taxes per a property

SELLING: Information on when a property changed ownership with some value attached.

Property:

Improvement Dwelling:

Improvement Interior Dwelling:

Assessment (Data CDs):

Assessment (API):

Real Estate Assessment Payment History:

** 2015 not included as there are payments have not been made for the levies.

Selling:

AC Real Estate and PUMS data

Is the PUMS data different than the AC Real Estate data?

Note: The Null hypothesis with these chi-square tests is that the observed (PUMS) values are not different than the expected (AC).

Result: The PUMS do appear to be different than the AC Real Estate Data .

Bedrooms

Year Built

AC Real Estate and ACS data

Is the the ACS data different than the ACS Real Estate?

Note: The Null hypothesis with these chi-square tests is that the observed (ACS) values are not different than the expected (AC).

Result: The AC and the ACS data do seem to come from the same population

Bedrooms

Year Built

Data Elements (Click or Scroll Down to see Description)

• Property Type
• Number of Units in Building
  
• Year Built
• Number of Bedrooms
• Presence of a Bathroom
• Heating Fuel
• Assessment Amount (Data CDs)
• Assessment Amount in Constant 2013 Dollars (Data CDs)
• Assessment Amount (API)
• Assessment Amount in Constant 2013 Dollars (API)
• Taxes Paid
• Taxes Paid in Constant 2013 Dollars
  
• Taxes Levied
• Taxes Levied in Constant 2013 Dollars
• Selling Amount
• Selling Amount in Constant 2013 Dollars

Note:

The variables mentioned in the data description below that have a suffix of ACS are those data that were recoded to match the categorization that ACS uses.

The box plots presented below have outliers hidden. A  box plot  is a graphical rendition of statistical data based on the minimum, first quartile, median, third quartile, and maximum.

Property Type

Data Set: Property

Variable: PropertyTypeACS

Population: Residential properties with a building

Weights: Values were weighted base on number of units

Class: Factor

Frequency Table:

Number of Units in Building

Data Set: Property

Variable: NumberofUnitsACS

Population: Residential properties with a building

Weights: Values were weighted base on number of units

Class: Factor

Frequency Table:

Year Built

Dataset: Property

Variable: YearBuiltACS (Combination of property and dwelling year built)

Population: Residential properties with a building

Weights: Values were weighted base on number of units

Class: Factor

Frequency Table:

Number of Bedrooms

Dataset: InteriorDwellingImrpovement

Variable: BedCountACS

Population: Residential Dwellings with a building

Weights: Values were weighted base on number of units

Class: Factor

Frequency Table:

Weighted N

Presence of a Bathroom

Dataset: InteriorDwellingImrpovement

Variable: BathACS

Population: Residential Dwellings with a building

Weights: Values were weighted base on number of units

Class: Factor

Frequency Table:

Heating Fuel

Dataset: DwellingImrpovement

Variable: HeatingACS

Population: Residential Dwellings with a building

Weights: Values were weighted base on number of units

Class: Factor

Frequency Table:

Assessment Amount (DATA CD)

Dataset: Data CD Assessments

Variable: Totl

Years: 2009-2013

Population: Residential properties with a building that had an assessment conducted

Exclusion: Removed those classified as multifamily and unknown affordable dwelling. (Renters do not get asked real estate tax questions)

N: See Assessment (CD) Table above

Number missing: 0

Class: Numeric

Range: 9,700  —  33,886,900

Standard Deviation:  346,078

Assessment Amount in Constant 2013 Dollars (DATA CD)

Dataset: Data CD Assessments

Variable: Totl2013

Years: 2009-2013

Population: Residential properties with a building that had an assessment conducted

Exclusion: Removed those classified as multifamily and unknown affordable dwelling. (Renters do not get asked real estate tax questions)

N: See Assessment (CD) Table   above

Number missing: 0

Class: Numeric

Range: 9,700  —  35,215,593

Standard Deviation:  358,405.7

Assessment Amount

Dataset: API Assessments

Variable: Total.Value.Amount

Years: 2009-2015

Population: Residential properties with a building that had an assessment conducted

Exclusion: Removed those classified as multifamily and unknown affordable dwelling. (Renters do not get asked real estate tax questions)

N: See Assessment (API) Table    above

Number missing: 0

Class: Numeric

Range: 9,700  —  33,886,900

Standard Deviation:  341,747.5

There were 538 Assessments classified under "New Construction." Of these, 546 have no land value associated with them (Even if there were land values in the previous and following years. " I n 2012 the procedure changed so anything before you will see the new construction amount posted with no land value. Technically, land can not change in the middle of the year only at reassessment so previous they chose not to post the land value." At the same time, the improvement value for these observations are significantly lower than the improvement value the following year. Cannot remove as unsure if these are occupied housing. Instead, the  land value for the following year was brought back to replace the 0 Land Value and a new total created.

Assessment Amount in Constant 2013 Dollars

Dataset: API Assessments

Variable: Total.Value.Amount.Constant2013

Years: 2009-2015

Population: Residential properties with a building that had an assessment conducted

Exclusion: Removed those classified as multifamily and unknown affordable dwelling. (Renters do not get asked real estate tax questions)

N: See Assessment (API) Table      above

Number missing: 0

Class: Numeric

Range: 6700  —  34,491,474

Standard Deviation: 357,555.6

Taxes Paid

Dataset: Payment History

Variable: TaxesPaidACS

Years: 2009-2014

Population: Residential properties with a building that had an assessment conducted during the year

Exclusion: Removed those classified as multifamily and unknown affordable dwelling. (Renters do not get asked real estate tax questions)

N: See Real Estate Assessment Payment History Table  above

Number missing: 2,983

Class: Numeric

Range: --309,015.32  —  -97.58

Standard Deviation: 3107.71

Taxes Paid in Constant 2013 dollars

Dataset: Payment History

Variable: TaxesPaidACS.Constant2013

Years: 2009-2014

Population: Residential properties with a building that had an assessment conducted during the year

Exclusion: Removed those classified as multifamily and unknown affordable dwelling. (Renters do not get asked real estate tax questions)

N: See Real Estate Assessment Payment History Table           above

Number missing: 2,983

Class: Numeric

Range:   -326,473.81  —  -97358

Standard Deviation: 3,190.20

Taxes Levied

Dataset: Payment History

Variable: TaxesLeviedACS

Years: 2009-2014

Population: Residential properties with a building that had an assessment conducted during the year

Exclusion: Removed those classified as multifamily and unknown affordable dwelling. (Renters do not get asked real estate tax questions)

N: See Real Estate Assessment Payment History Table           above

Number missing: 64

Class: Numeric

Range:  97.58 –  329,041.78

Standard Deviation: 3,135.57

** 2% of payments do no not mach the amount levied

Taxes Levied in Constant 2013 Dollars

Dataset: Payment History

Variable: TaxesLeviedACS.Constant2013

Years: 2009-2014

Population: Residential properties with a building that had an assessment conducted during the year

Exclusion: Removed those classified as multifamily and unknown affordable dwelling. (Renters do not get asked real estate tax questions)

N: See Real Estate Assessment Payment History Table           above

Number missing: 64

Class: Numeric

Range:  97.58 – 334,912.20

Standard Deviation: 37,785.96

Selling Amount  

Dataset: Sale

Variable: saleAmt

Year: 2009-2015

Population: Residential properties with a building that had an assessment conducted during the year

Exclusion:

• Removed those classified as multifamily and unknown affordable dwelling. (Renters do not get asked value question);

• Removed those that were not market value

N: See Real Estate Assessment Payment History Table           above

Number missing: 0

Class: Numeric

Range:  10,000   —  16,000,000

Standard Deviation: 382,123.8