Zillow Data Dictionary

Main

airconditioningtypeid

Type of cooling system present in the home (if any)


architecturalstyletypeid

Architectural style of the home (i.e. ranch, colonial, split-level, etc…)


basementsqft

Finished living area below or partially below ground level


bathroomcnt

Number of bathrooms in home including fractional bathrooms


bedroomcnt

Number of bedrooms in home


buildingqualitytypeid

Overall assessment of condition of the building from best (lowest) to worst (highest)


buildingclasstypeid

The building framing type (steel frame, wood frame, concrete/brick)


calculatedbathnbr

Number of bathrooms in home including fractional bathroom


decktypeid

Type of deck (if any) present on parcel


threequarterbathnbr

Number of 3/4 bathrooms in house (shower + sink + toilet)


finishedfloor1squarefeet

Size of the finished living area on the first (entry) floor of the home


calculatedfinishedsquarefeet

Calculated total finished living area of the home


finishedsquarefeet6

Base unfinished and finished area


finishedsquarefeet12

Finished living area


finishedsquarefeet13

Perimeter living area


finishedsquarefeet15

Total area


finishedsquarefeet50

Size of the finished living area on the first (entry) floor of the home


fips

Federal Information Processing Standard code - see https://en.wikipedia.org/wiki/FIPS_county_code for more details


fireplacecnt

Number of fireplaces in a home (if any)


fireplaceflag

Is a fireplace present in this home


fullbathcnt

Number of full bathrooms (sink, shower + bathtub, and toilet) present in home


garagecarcnt

Total number of garages on the lot including an attached garage


garagetotalsqft

Total number of square feet of all garages on lot including an attached garage


hashottuborspa

Does the home have a hot tub or spa


heatingorsystemtypeid

Type of home heating system


latitude

Latitude of the middle of the parcel multiplied by 10e6


longitude

Longitude of the middle of the parcel multiplied by 10e6


lotsizesquarefeet

Area of the lot in square feet


numberofstories

Number of stories or levels the home has


parcelid

Unique identifier for parcels (lots)


poolcnt

Number of pools on the lot (if any)


poolsizesum

Total square footage of all pools on property


pooltypeid10

Spa or Hot Tub


pooltypeid2

Pool with Spa/Hot Tub


pooltypeid7

Pool without hot tub


propertycountylandusecode

County land use code i.e. it s zoning at the county level


propertylandusetypeid

Type of land use the property is zoned for


propertyzoningdesc

Description of the allowed land uses (zoning) for that property


rawcensustractandblock

Census tract and block ID combined - also contains blockgroup assignment by extension


censustractandblock

Census tract and block ID combined - also contains blockgroup assignment by extension


regionidcounty

County in which the property is located


regionidcity

City in which the property is located (if any)


regionidzip

Zip code in which the property is located


regionidneighborhood

Neighborhood in which the property is located


roomcnt

number of rooms in the principal residence


storytypeid

Type of floors in a multi-story house (i.e. basement and main level, split-level, attic, etc.). See tab for details.


typeconstructiontypeid

What type of construction material was used to construct the home


unitcnt

Number of units the structure is built into (i.e. 2 = duplex, 3 = triplex, etc…)


yardbuildingsqft17

Patio in yard


yardbuildingsqft26

Storage shed/building in yard


yearbuilt

The Year the principal residence was built


taxvaluedollarcnt

The total tax assessed value of the parcel


structuretaxvaluedollarcnt

The assessed value of the built structure on the parcel


landtaxvaluedollarcnt

The assessed value of the land area of the parcel


taxamount

The total property tax assessed for that assessment year


assessmentyear

The year of the property tax assessment


taxdelinquencyflag

Property taxes for this parcel are past due as of 2015


taxdelinquencyyear

Year for which the unpaid propert taxes were due


Heating/Sys ID

Heating or sytem type ID - Description


1 - Baseboard

2 - Central

3 - Coal

4 - Convection

5 - Electric

6 - Forced air

7 - Floor/Wall

8 - Gas

9 - Geo Thermal

10 - Gravity

11 - Heat Pump

12 - Hot Water

13 - None

14 - Other

15 - Oil

16 - Partial

17 - Propane

18 - Radiant

19 - Steam

20 - Solar

21 - Space/Suspended

22 - Vent

23 - Wood Burning

24 - Yes

25 - Zone

Property ID

Poperty Land Use Type ID - Desc


31 - Commercial/Office/Residential Mixed Used

46 - Multi-Story Store

47 - Store/Office (Mixed Use)

246 - Duplex (2 Units, Any Combination)

247 - Triplex (3 Units, Any Combination)

248 - Quadruplex (4 Units, Any Combination)

260 - Residential General

261 - Single Family Residential

262 - Rural Residence

263 - Mobile Home

264 - Townhouse

265 - Cluster Home

266 - Condominium

267 - Cooperative

268 - Row House

269 - Planned Unit Development

270 - Residential Common Area

271 - Timeshare

273 - Bungalow

274 - Zero Lot Line

275 - Manufactured, Modular, Prefabricated Homes

276 - Patio Home

279 - Inferred Single Family Residential

290 - Vacant Land - General

291 - Residential Vacant Land

Story Type ID

Story Type ID - Desc


1 - Attic & Basement

2 - Attic

3 - Bi-Level with Attic & Basement

4 - Bi-Level

5 - Bi-Level with Attic

6 - Bi-Level with Basement

7 - Basement

8 - Split Entry with Attic & Basement

9 - Split Foyer with Attic & Basement

10 - Level with Attic & Basement

11 - Level with Attic

12 - Level with Basement

13 - Level

14 - Multi-Level with Attic & Basement

15 - Multi-Level

16 - Multi-Level with Attic

17 - Multi-Level with Basement

18 - Split Level with Attic & Basement

19 - Single Level with Attic & Basement

20 - Split Entry with Attic

21 - Split Entry with Basement

22 - Split Foyer with Attic

23 - Split Foyer with Basement

24 - Single Level with Attic

25 - Single Level with Basement

26 - Single Level

27 - Split Level with Attic

28 - Split Level with Basement

29 - Split Entry

30 - Split Foyer

31 - Split Level

32 - Tri-level with Attic & Basement

33 - Tri-level with Attic

34 - Tri-level with Basement

35 - Tri-level

AC Type ID

Air Conditioning Type ID - Desc

1 - Central

2 - Chilled Water

3 - Evaporative Cooler

4 - Geo Thermal

5 - None

6 - Other

7 - Packaged AC Unit

8 - Partial

9 - Refrigeration

10 - Ventilation

11 - Wall Unit

12 - Window Unit

13 - Yes

Arch Type ID

Architectual Style Type ID - Desc

1 - A-Frame

2 - Bungalow

3 - Cape Cod

4 - Cottage

5 - Colonial

6 - Custom

7 - Contemporary

8 - Conventional

9 - Dome

10 - French Provincial

11 - Georgian

12 - High Rise

13 - Historical

14 - Log Cabin/Rustic

15 - Mediterranean

16 - Modern

17 - Mansion

18 - English

19 - Other

20 - Prefab

21 - Ranch/Rambler

22 - Raised Ranch

23 - Spanish

24 - Traditional

25 - Tudor

26 - Unfinished/Under Construction

27 - Victorian

Constr Type ID

Construction Type ID - Desc

1 - Adobe

2 - Brick

3 - Concrete Block

4 - Concrete

5 - Dome

6 - Frame

7 - Heavy

8 - Log

9 - Light

10 - Metal

11 - Manufactured

12 - Mixed

13 - Masonry

14 - Other

15 - Steel

16 - Stone

17 - Tilt-Up

18 - Wood

Build Type

1

Buildings having fireproofed structural steel frames carrying all wall, floor and roof loads. Wall, floor and roof structures are built of non-combustible materials.

2

Buildings having fireproofed reinforced concrete frames carrying all wall floor and roof loads which are all non-combustible.

3

Buildings having exterior walls built of a non-combustible material such as brick, concrete, block or poured concrete. Interior partitions and roof structures are built of combustible materials. Floor may be concrete or wood frame.

4

Buildings having wood or wood and steel frames

5

Specialized buildings that do not fit in any of the above categories