Codebooks

  • The following data dictionary was received along with the data: Data Dictionary

Data Description for Virginia

The tables below show the overall description of the data tables for all of VA.

Year N Unit of Analysis
2009 2,672,132 All residential Property Type
2010 2,703,397 All residential Property Type
2011 2,533,515 All residential Property Type
2012 2,697,083 All residential Property Type
2013 2,893,098 All residential Property Type

Coverage in Virginia

     

Data Description for Arlington County

The tables below show the overall description of the data tables for all of Arlington County.

Year N Unit of Analysis
2009

60,855

All residential Property Type
2010 61,212 All residential Property Type
2011

61,304

All residential Property Type
2012

61,506

All residential Property Type
2013

61,591

All residential Property Type

Data Quality for Arlington County

Core Logic: Arlington County  
Duplications

2009: None

2010: None

2011: None

2012: None

2013: None

"UNFORMATTED.APN"   

2009: None

2010: None

2011: None

2012: None

2013: None

"ORIGINAL.APN”

2009: None

2010: None

2011: None

2012: None

2013: None

Variables Completeness Validity Uniqueness Consistency
PROPERTY
"SITUS.HOUSE.NUMBER"

2009: 351 missing

2010: 348 missing

2011: 364 missing

2012: 371 missing

2013: 372 missing

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

"SITUS.HOUSE.NUMBER.SUFFIX"

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: Levels "A" "B" "C" "D" "E" "F"

2010: Levels "A" "B" "C" "D" "E" "F"

2011: Levels "A" "B" "C" "D" "E" "F" "G" "H" "I" "J"

2012: Levels "A" "B" "C" "D" "E" "F" "G" "H" "I" "J" "K" "L"

2013: Levels "A" "B" "C" "D" "E" "F" "G" "H" "I" "J"

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

"SITUS.DIRECTION"

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

2009: Levels "E" "N" "S"

2010: Levels "E" "N" "S"

2011: Levels "N" "S"

2012: Levels "E" "N" "S"

2013: Levels "N" "S"

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

"SITUS.STREET.NAME"

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

2009: 410 levels

2010: 370 levels

2011:   292 levels

2012: 326 levels

2013: 315 levels

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

"SITUS.MODE"

2009: 161 missing

2010: 125 missing

2011: 26 missing

2012: 45 missing

2013: 34 missing

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

2009: Levels "AVE" "BLVD" "CIR" "CT" "DR" "HWY" "LN" "PARK" "PIKE" "PKWY" "PL" "RD" "ST" "TER"

2010: Levels "AVE" "BLVD" "CIR" "CT" "DR" "HWY" "LN" "PARK" "PIKE" "PKWY" "PL" "RD" "ST" "TER"

2011: Levels "AVE" "BLVD" "CIR" "CT" "DR" "HWY" "LN" "PARK" "PIKE" "PKWY" "PL" "RD" "ST" "TER"

2012: Levels "AVE" "BLVD" "CIR" "CT" "DR" "HWY" "LN" "PARK" "PIKE" "PKWY" "PL" "RD" "ST" "TER"

2013: Levels "AVE" "BLVD" "CIR" "CT" "DR" "HWY" "LN" "PARK" "PIKE" "PKWY" "PL" "RD" "ST" "TER"

2009:   100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

"SITUS.UNIT.NUMBER"

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

"SITUS.CITY"

2009: 2 missing

2010: 1 missing

2011: 18 missing

2012: 100%

2013: 3 missing

2009: 1 listed as a non-city: Rosslyn

2010: 100%

2011:   100%

2012:   100%

2013:   100%

2009: Levels "ALEXANDRIA" "ARLINGTON" "FALLS CHURCH" "MC LEAN" "MCLEAN" "ROSSLYN"

2010: Levels "ALEXANDRIA" "ARLINGTON" "FALLS CHURCH" "MC LEAN" "MCLEAN"

2011: Levels "ARLINGTON" "FALLS CHURCH" "MC LEAN"

2012: Levels "ARLINGTON" "FALLS CHURCH" "MC LEAN" "MCLEAN"

2013: Levels "ARLINGTON" "FALLS CHURCH" "MC LEAN" "MCLEAN"

2009: Two different McLean Spellings

2010: Two different McLean Spellings

2011: 100%

2012: Two different McLean Spellings

2013:

"SITUS.STATE"

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

2009: All listed as VA

2010: All listed as VA

2011: All listed as VA

2012: All listed as VA

2013: All listed as VA

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

"FIPS.CODE"

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

2009: All listed as 51013

2010: All listed as 51013

2011: All listed as 51013

2012: All listed as 51013

2013: All listed as 51013

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

"ABSENTEE.OWNER.STATUS"

2009: 3% missing

2010: 3% missing

2011: 3% missing

2012: 4 % missing

2013: 4 % missing

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: Levels "A" "O"

2010: Levels "A" "O"

2011: Levels "A" "O"

2012: Levels "A" "O"

2013: Levels "A" "O"

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

"LAND.USE"

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

2009: Levels "100" "102" "106" "111" "112" "115" "116" "117" "127" "163"

2010: Levels "100" "102" "106" "111" "112" "115" "116" "117" "127" "163"

2011: Levels "100" "102" "106" "111" "112" "115" "116" "117" "127" "163"

2012: Levels "100" "102" "106" "111" "112" "115" "116" "117" "127" "163"

2013: Levels "100" "102" "106" "111" "112" "115" "116" "117" "127" "163"

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

"COUNTY.USE.1"

2009: 80 missing

2010: 93 missing

2011: 93 missing

2012: 92 missing

2013: 17 missing

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

2009: Levels "200" "201" "311" "312" "313" "399" "411" "412" "413" "414" "510" "511" "512" "513" "514" "515" "520" "521" "530" "531" "540" "611" "612" "613" "614" "616" "640"

2010: Levels "200" "201" "311" "312" "313" "399" "411" "412" "413" "414" "510" "511" "512" "513" "514" "515" "520" "521" "530" "531" "540" "611" "612" "613" "614" "616" "640"

2011: Levels "200" "201" "311" "312" "313" "399" "411" "412" "413" "414" "510" "511" "512" "513" "514" "515" "520" "521" "530" "531" "540" "611" "612" "613" "614" "616" "640"

2012: Levels "200" "201" "311" "312" "313" "399" "411" "412" "413" "414" "510" "511" "512" "513" "514" "515" "520" "521" "530" "531" "540" "611" "612" "613" "614" "616" "640"

2013: Levels "200" "201" "311" "312" "313" "399" "411" "412" "413" "414" "510" "511" "512" "513" "514" "515" "520" "521" "530" "531" "540" "611" "612" "613" "614" "616" "640"

2009: 100%

2010:   100%

2011:   100%

2012:   100%

2013:   100%

"NUMBER.OF.BUILDING.UNITS"

2009: 100%

2010: 100%

2011: 9% missing

2012: 9% missing

2013: 9% missing

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

"CENSUS.TRACT"

2009: 2 missing

2010:3 missing

2011: 6 missing

2012: 8 missing

2013: 18 missing

2009: Most not in known AC tract/invalid geo ID

2010: Most not in known AC tract/invalid geo ID

2011: Most not in known AC tract/invalid geo ID

2012: Most not in known AC tract/invalid geo ID

2013: Most not in known AC tract/invalid geo ID

2009: 1579 levels

2010: 1576 levels

2011: 1600 levels

2012: 1606 levels

2013: 1601 levels

2009: 1 00%

2010: 1 00%

2011: 1 00%

2012: 1 00%

2013: 1 00%

"SITUS.LATITUDE..2.6."

2009: 323 missing

2010: 735 missing

2011: 836 missing

2012: 1,053 missing

2013: 800 missing

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

 

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"SITUS.LONGITUDE..3.6."

2009: 323 missing

2010: 735 missing

2011: 836 missing

2012: 1053 missing

2013: 800 missing

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

 

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

CHARACTERISTICS
"YEAR.BUILT"

2009: 7% missing

2010: 8% missing

2011: 7% missing

2012: 2% missing

2013: 2% missing

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

 

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"X.TOTAL.BATHS.CALCULATED"

2009: 4% missing

2010: 4% missing

2011: 3% missing

2012: 3% missing

2013: 3% missing

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

 

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"BEDROOMS

2009:

2010: 16% missing

2011: 14% missing

2012: 15% missing

2013: 14% missing

2009: 1 listed with 43 bedrooms yet 1188 sqft of living space

2010:1 listed with 43 bedrooms yet 1188 sqft of living space

2011: 100%

2012: 100%

2013: 100%

 

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"HEATING"

2009: 32% missing

2010: 32% missing

2011: 32% missing

2012: 32% missing

2013: 32% missing

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: Levels "000" "001" "BB0" "BBE" "FA0" "FAG" "GR0" "HP0" "HW0" "RC0" "RD0" "RDE" "WA0" "WS0" "WU0"

2010:   Levels "000" "001" "BB0" "BBE" "FA0" "FAG" "GR0" "HP0" "HW0" "RC0" "RD0" "RDE" "WA0" "WS0" "WU0"

2011:   Levels "000" "001" "BB0" "BBE" "FA0" "FAG" "GR0" "HP0" "HW0" "RC0" "RD0" "RDE" "WA0" "WS0" "WU0"

2012:   Levels "000" "001" "BB0" "BBE" "FA0" "FAG" "GR0" "HP0" "HW0" "RC0" "RD0" "RDE" "WA0" "WS0" "WU0"

2013:   Levels "000" "001" "BB0" "BBE" "FA0" "FAG" "GR0" "HP0" "HW0" "RC0" "RD0" "RDE" "WA0" "WS0" "WU0"

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"ACRES"

2009: 26% missing

2010: 26% missing

2011: 26% missing

2012: 26% missing

2013: 26% missing

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

 

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"LIVING.SQUARE.FEET"

2009: 3% missing

2010: 3% missing

2011: 3% missing

2012: 3% missing

2013: 3% missing

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

 

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"TOTAL.ROOMS"

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

ASSESSMENT

"TOTAL.VALUE.CALCULATED”

2009: 33 missing

2010: 69 missing

2011: 106 missing

2012: 52 missing

2013: 40 missing

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

 

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"LAND.VALUE.CALCULATED”

2009: 629 missing

2010 661 missing

2011: 697 missing

2012: 646 missing

2013: 656 missing

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

 

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"IMRPOVEMENT.VALUE.CALCULATED”

2009: 626 missing

2010: 621 missing

2011: 593 missing

2012: 648 missing

2013: 588 missing

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

 

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"TOTAL.VALUE.CALCULATED.IND”

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

2009:   1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

2009: All listed as A

2010: All listed as A

2011: All listed as A

2012: All listed as A

2013: All listed as A

2009:   1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"LAND.VALUE.CALCULATED.IND”

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

2009: All listed as A

2010: All listed as A

2011: All listed as A

2012: All listed as A

2013: All listed as A

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"IMRPOVEMENT.VALUE.CALCULATED.IND”

2009:   1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

2009:   1 00%

2010: 1 00%

2011: 1 00%

2012: 1 00%

2013: 1 00%

2009:   All listed as A

2010: All listed as A

2011: All listed as A

2012: All listed as A

2013: All listed as A

2009:   1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"ASSD.TOTAL.VALUE"

2009: 33 missing

2010: 69 missing

2011: 106 missing

2012: 52 missing

2013: 40 missing

2009: 1 00%

2010: 1 00%

2011: 1 00%

2012: 1 00%

2013: 1 00%

 

2009: 1 00%

2010:

2011:

2012:

2013:

"ASSD.LAND.VALUE"

2009: 629 missing

2010: 661 missing

2011: 697 missing

2012: 646 missing

2013: 656 missing

2009:   1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

 

2009:   1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"ASSD.IMPROVEMENT.VALUE"

2009: 626 Missing

2010: 621 missing

2011: 593 missing

2012: 648 missing

2013: 588 missing

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

 

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"MKT.TOTAL.VALUE"

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING  

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

"MKT.LAND. VALUE"

2009: ALL MISSING

  2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

"MKT.IMPROVEMENT.VALUE"

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

"APPR.LAND.VALUE"

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

"APPR.IMROVEMENT.VALUE"

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

"APPR.TOTAL.VALUE"

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

"TAX.AMOUNT"

2009:  422 missing

2010:  464 missing

2011: 509 missing

2012: 505 missing

2013: 1,324 missing

2009:   1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

 

2009:   1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

"TAX.YEAR"

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

2009: All listed as 2009

2010: All listed as 2010

2011: All listed as 2011

2012: All listed as 2012

2013: All listed as 2013

2009: 1 00%

2010:   1 00%

2011:   1 00%

2012:   1 00%

2013:   1 00%

Through random parcel checks while cleaning, a parking spot (APN 22003113) and a common area ( 16004221) were found  using Arlington Property Search. CoreLogic does have a land use code for parking lots, but this did not appear in the data received. 

Single Family Detached homes have a unit number other than 0/1/NA. (2009: 74, 2010: 71, 2011: 89, 2012: 40, 2013: 41)

Parcels with condo CoreLogic Land Use code but apartment County land Use (2009: 9 and 1 list in county as hotel; 2010: 10 and 1 list in county as hotel; 2011: 13, 2012: 14; 2013: 14).

Across the Years Checks

Address

  • 2,391 properties have at lest one different address in 2009, 2010, 2011, and 2013
  • 838 properties have at least one different reduced address (Street Name Only) in 2009, 2010, 2011, and 2013

Latitude

  • 4,717 (8%) properties have different latitudes and longitudes across the years.
  • NO properties have different latitudes and longitudes when excluding 2013

  • Average difference between 2012 and 2013 latitudes is 0.0000003, which is about 1 foot(0.0000001 = 4 inches)

    • 0 to 0.002723, which is about 980 feet ( .001 = 360 feet)

Tract

  • 91% of properties have at least one difference tract ID between 2009-2013

Unit Count

  • 30% of properties have at least one difference Number of Units between 2009-2013
  • Range of difference was 1-826 units.
  • Condo's listed with 0 unit count in 2009,2010 but then start having a unit count in 2011, 2012, 2013 (example APN 0771033)
    • There are 10 condo parcels that have a unit count in 2009/10: 27007299, 22014003, 20022004, 29014045, 20016001, 17007088, 20030005, 20030005, 17024022, 17026073.

Data Description for James City County

The tables below show the overall description of the data tables for all of James City County.

Year N Unit of Analysis
2009 29,300 All residential Property Type
2010

29,649

All residential Property Type
2011 29,748 All residential Property Type
2012

30,099

All residential Property Type
2013

30,529

All residential Property Type

Data Quality for James City County

Core Logic: Arlington County  
Duplications

2009: None

2010: None

2011: None

2012: None

2013: None

"UNFORMATTED.APN"   

2009: None

2010: None

2011: None

2012: None

2013: None

"ORIGINAL.APN”

2009: None

2010: None

2011: None

2012: None

2013: None

Variables Completeness Validity Uniqueness Consistency
PROPERTY
"SITUS.HOUSE.NUMBER"

2009: 511 missing

2010: 508 missing

2011: 505 missing

2012: 508 missing

2013: 515 missing

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: All house numbers are entered with quotes around them (even blank fields have "")

2013: 100%

"SITUS.HOUSE.NUMBER.SUFFIX"

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: "", "A", "B"

2010: "", "A", "B"

2011: "", "A", "B"

2012: "", "A", "B", "C"

2013: "", "A", "B"

2009: 100%

2010: 100%

2011: 100%

2012: Note that it seems this variable has the same quotes as detailed above

2013: 100%

"SITUS.DIRECTION"

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: "" "E" "N" "S" "W"

2010: "" "E" "N" "S" "W"

2011: "" "E" "N" "S" "W"

2012: "" "E" "N" "S" "W"

2013: "" "E" "N" "S" "W"

2009: 100%

2010: 100%

2011: 100%

2012: It is likely all variables will have quotes around them

2013: 100%

"SITUS.STREET.NAME"

2009: 504 missing

2010: 501 missing

2011: 498 missing

2012: 500 missing

2013: 505 missing

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: 1482 different street names

2010: 1493 different street names

2011: 1496 different street names

2012: 1508 different street names

2013: 1525 different street names

2009: 100%

2010: 100%

2011: 100%

2012: Quotes around each variable entry

2013: 100%

"SITUS.MODE"

2009: 6062 missing

2010: 6060 missing

2011: 6065 missing

2012: 6137 missing

2013: 6159 missing

2009:

2010:

2011:

2012:

2013:

2009:"" "AVE" "BCH" "BLFS" "BLVD" "BND" "BR" "BRG" "BRK" "CIR" "CMNS" "CRES" "CRK" "CRSE" "CT" "CV" "DL" "DR" "FLD" "FLDS" "FRST" "GLN" "GRN" "GRV" "HL" "HLS" "HOLW" "HWY" "ISLE" "KY" "LK" "LN" "LNDG" "LOOP" "MDWS" "MEWS" "ML" "MNR" "MT" "NCK" "PARK" "PASS" "PATH" "PKWY" "PL" "PNES" "PT" "RD" "RDG" "RIV" "RUN" "SQ" "ST" "TER" "TRCE" "TRL" "VLY" "VW" "WALK" "WAY" "XING"

2010: "" "AVE" "BCH" "BLFS" "BLVD" "BND" "BR" "BRG" "BRK" "CIR" "CMNS" "CRES" "CRK" "CRSE" "CT" "CV" "DL" "DR" "FLD" "FLDS" "FRST" "GLN" "GRN" "GRV" "HL" "HLS" "HOLW" "HWY" "ISLE" "KY" "LK" "LN" "LNDG" "LOOP" "MDWS" "MEWS" "ML" "MNR" "MT" "NCK" "PARK" "PASS" "PATH" "PKWY" "PL" "PNES" "PT" "RD" "RDG" "RIV" "RUN" "SQ" "ST" "TER" "TRCE" "TRL" "VLY" "VW" "WALK" "WAY" "XING"

2011: "" "AVE" "BCH" "BLFS" "BLVD" "BND" "BR" "BRG" "BRK" "CIR" "CMNS" "CRES" "CRK" "CRSE" "CT" "CV" "DL" "DR" "FLD" "FLDS" "FRST" "GLN" "GRN" "GRV" "HL" "HLS" "HOLW" "HWY" "ISLE" "KY" "LK" "LN" "LNDG" "LOOP" "MDWS" "MEWS" "ML" "MNR" "MT" "NCK" "PARK" "PASS" "PATH" "PKWY" "PL" "PNES" "PT" "RD" "RDG" "RIV" "RUN" "SQ" "ST" "TER" "TRCE" "TRL" "VLY" "VW" "WALK" "WAY" "XING"

2012:"" "AVE" "BCH" "BLFS" "BLVD" "BND" "BR" "BRG" "BRK" "CIR" "CMNS" "CRES" "CRK" "CRSE" "CT" "CV" "DL" "DR" "FLD" "FLDS" "FRST" "GLN" "GRN" "GRV" "HL" "HLS" "HOLW" "HWY" "ISLE" "KY" "LK" "LN" "LNDG" "LOOP" "MDWS" "MEWS" "ML" "MNR" "MT" "NCK" "PARK" "PASS" "PATH" "PKWY" "PL" "PNES" "PT" "RD" "RDG" "RIV" "RUN" "SQ" "ST" "TER" "TRCE" "TRL" "VLY" "VW" "WALK" "WAY" "XING"

2013: "" "AVE" "BCH" "BLFS" "BLVD" "BND" "BR" "BRG" "BRK" "CIR" "CMNS" "CRES" "CRK" "CRSE" "CT" "CV" "DL" "DR" "FLD" "FLDS" "FRST" "GLN" "GRN" "GRV" "HL" "HLS" "HOLW" "HWY" "ISLE" "KY" "LN" "LNDG" "LOOP" "MDWS" "MEWS" "ML" "MNR" "MT" "NCK" "PARK" "PASS" "PATH" "PKWY" "PL" "PNES" "PT" "RD" "RDG" "RIV" "RUN" "SQ" "ST" "TER" "TRCE" "TRL" "VLY" "VW" "WALK" "WAY" "XING"

2009: 100%

2010: 100%

2011: 100%

2012: Quotes around each variable entry

2013: 100%

"SITUS.UNIT.NUMBER"

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: Quotes around each variable entry

2013: 100%

"SITUS.CITY"

2009: 287 missing values

2010: 283 missing values

2011: 284 missing values

2012: 282 missing values

2013: 279 missing values

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: "" "BARHAMSVILLE" "LANEXA" "TOANO" "WILLIAMSBURG" "WMSBGURG"

2010:"" "BARHAMSVILLE" "LANEXA" "TOANO" "WILLIAMSBURG" "WMSBGURG" "WMSBURG"

2011: "" "BARHAMSVILLE" "LANEXA" "TOANO" "WILLIAMSBURG" "WMSBGURG" "WMSBURG"

2012: "" "BARHAMSVILLE" "LANEXA" "TOANO" "WILLIAMSBURG" "WMSBGURG" "WMSBURG"

2013:"" "BARHAMSVILLE" "LANEXA" "TOANO" "WILLIAMSBURG" "WMSBGURG" "WMSBURG"

2009: Williamsburg is mispelled as WMSBGURG once

2010: Williamsburg is mispelled as WMSBGURG once and WMSBURG 61 times

2011: Williamsburg is mispelled as WMSBGURG once and WMSBURG 62 times

2012: Williamsburg is mispelled as WMSBGURG once and WMSBURG 59 times and there are q uotes around each variable entry

2013: Williamsburg is mispelled as WMSBGURG once and WMSBURG 59 times

"SITUS.STATE"

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: All are VA

2010: All are VA

2011: All are VA

2012: All are VA

2013: All are VA

2009: 100%

2010: 100%

2011: 100%

2012: There are quotes around each variable entry

2013: 100%

"FIPS.CODE"

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: All are 51095 (valid FIPS)

2010: All are 51095 (valid FIPS)

2011: All are 51095 (valid FIPS)

2012: All are 51095 (valid FIPS)

2013: All are 51095 (valid FIPS)

2009: 100%

2010: 100%

2011: 100%

2012: There are quotes around each variable entry

2013: 100%

"ABSENTEE.OWNER.STATUS"

2009: 7.2% missing

2010: 7.7% missing

2011: 9.5% missing

2012: 9.9% missing

2013: 10.4% missing

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: "" "A" "O"

2010: "" "A" "O"

2011: "" "A" "O"

2012: "" "A" "O"

2013: "" "A" "O"

2009: 100%

2010: 100%

2011: 100%

2012: There are quotes around each variable entry

2013: 100%

"LAND.USE"

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: "100" "112" "114" "133" "137" "163"

2010: "100" "112" "133" "163"

2011: "100" "112" "114" "133" "137" "163"

2012: "100" "112" "114" "133" "137" "163"

2013: "100" "112" "114" "133" "137" "163"

2009: 100%

2010: 100%

2011: 100%

2012: There are quotes around each variable entry

2013: 100%

"COUNTY.USE.1"

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: 1 missing

2013: 100%

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: 100%

2013: 100%

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: "" "106" "502" "503"

2013: "106" "502" "503"

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: There are quotes around each variable entry

2013: 100%

"NUMBER.OF.BUILDING.UNITS"

2009: 100%

2010: 0.2% missing

2011: 0.2% missing

2012: 0.2% missing

2013: 0.2% missing

2009: All values are 0

2010: 100%

2011: 100%

2012: NAs are now coded as blank instead of NA

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: There are quotes around each variable entry

2013: 100%

"CENSUS.TRACT"

2009: 91 missing values

2010: 60 missing values

2011: 31 missing values

2012: 0 missing values

2013: 19 missing values

2009: Most values are not Census tracts/not in JCC

2010: Most values are not Census tracts/not in JCC

2011: Most values are not Census tracts/not in JCC

2012: Most values are not Census tracts/not in JCC

2013: Most values are not Census tracts/not in JCC

2009: 445 different values

2010: 445 different values

2011: 833 different values

2012: 823 different values

2013: 814 different values

2009: 100%

2010: 100%

2011: 100%

2012: There are quotes around each variable entry

2013: 100%

"SITUS.LATITUDE..2.6."

2009: 431 missing values

2010: 799 missing values

2011: 56 missing values

2012: 417 missing values

2013: 867 missing values

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: There are quotes around each variable entry

2013: 100%

" SITUS.LONGITUDE..3.6."

2009: 431 missing values

2010: 799 missing values

2011: 56 missing values

2012: 417 missing values

2013: 867 missing values

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: There are quotes around each variable entry

2013: 100%

CHARACTERISTICS
"YEAR.BUILT"

2009: 15.2% missing

2010: 14.8% missing

2011: 13.7% missing

2012: 13.0% missing

2013: 12.7% missing

2009: Minimum value is 1780, most likely not the case but there are historic areas of JCC

2010: Same as 2009

2011: Same as 2009

2012: Minimum value is 1790, most likely not the case but there are historic areas of JCC

2013: Same as 2012

 

2009: 100%

2010: 100%

2011: 100%

2012: All values are entered in quotes

2013: 100%

"X.TOTAL.BATHS.CALCULATED"

2009: 16.8% missing

2010: 16.4% missing

2011: 15.3% missing

2012: 14.5% missing

2013: 14.1% missing

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

"BEDROOMS

2009: 25.2% missing

2010: 24.6% missing

2011: 23.4% missing

2012: 22.2% missing

2013: 21.2% missing

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: All values are entered in quotes

2013: 100%

"HEATING"

2009: 15.4% missing

2010: 15.0% missing

2011: 13.9% missing

2012: 13.2% missing

2013: 12.9%

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: "" "001" "00S" "BB0" "FA0" "FAG" "HP0" "HS0" "HW0" "SP0" "WA0"

2010:"" "001" "00S" "BB0" "FA0" "FAG" "HP0" "HS0" "HW0" "SP0" "WA0"

2011:"" "001" "00S" "BB0" "FA0" "FAG" "HP0" "HS0" "HW0" "SP0" "WA0"

2012:"" "001" "00S" "BB0" "FA0" "FAG" "GRO" "HP0" "HS0" "HW0" "SP0" "WA0"

2013: "" "001" "00S" "BB0" "FA0" "FAG" "GRO" "HP0" "HS0" "HW0" "SP0" "WA0"

2009: 100%

2010: 100%

2011: 100%

2012: All values are entered in quotes

2013: 100%

"ACRES"

2009: 3.3% missing

2010: 3.4% missing

2011: <0.001% missing

2012: 100%

2013: 0.6% missing

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: All values are entered in quotes

2013: 100%

"LIVING.SQUARE.FEET"

2009: 15.7% missing

2010: 15.3% missing

2011: 14.2% missing

2012: 13.5% missing

2013: 13.1% missing

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: All variables have quotes around them

2013: 100%

"TOTAL.ROOMS"

2009: 17.2% missing

2010: 16.8% missing

2011: 15.7% missing

2012: 14.9% missing

2013: 14.4%

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: Quotes around each variable entry

2013: 100%

ASSESSMENT

"TOTAL.VALUE.CALCULATED”

2009: 540 missing values

2010: 591 missing values

2011: 607 missing values

2012: 627 missing values

2013: 648 missing values

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: All variables in quotes

2013: 100%

"LAND.VALUE.CALCULATED”

2009: 541 missing values

2010: 592 missing values

2011: 608 missing values

2012: 627 missing values

2013: 648 missing values

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: Variables in quotes

2013: 100%

"IMRPOVEMENT.VALUE.CALCULATED”

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

"TOTAL.VALUE.CALCULATED.IND”

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: All listed as M

2010: All listed as M

2011: All listed as M

2012: All listed as M

2013: All listed as M

2009: 100%

2010: 100%

2011: 100%

2012: All entries in quotes

2013: 100%

" LAND.VALUE.CALCULATED.IND”

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: All listed as M

2010: All listed as M

2011: All listed as M

2012: All listed as M

2013: All listed as M

2009: 100%

2010: 100%

2011: 100%

2012: All entries in quotes

2013: 100%

" IMRPOVEMENT.VALUE.CALCULATED.IND”

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: All listed as M

2010: All listed as M

2011: All listed as M

2012: All listed as M

2013: All listed as M

2009: 100%

2010: 100%

2011: 100%

2012: All entries in quotes

2013: 100%

"ASSD.TOTAL.VALUE"

2009: 540 missing values

2010: 591 missing values

2011: 607 missing values

2012: 627 missing values

2013: 648 missing values

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: All entries are in quotes

2013: 100%

"ASSD.LAND.VALUE"

2009: 541 missing values

2010: 592 missing values

2011: 608 missing values

2012: 627 missing values

2013: 648 missing values

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: All entries are in quotes

2013: 100%

"ASSD.IMPROVEMENT.VALUE"

2009: 4,436 missing values

2010: 4,331 missing values

2011: 4,089 missing values

2012: 3,970 missing values

2013: 3,939 missing values

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: All entries are in quotes

2013: 100%

"MKT.TOTAL.VALUE"

2009: 1.8% missing

2010: 2.0% missing

2011: 2.0% missing

2012: 2.1% missing

2013: 2.1% missing

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: All entries are in quotes

2013: 100%

"MKT.LAN. VALUE"

2009: 1.8% missing

2010: 2.0% missing

2011: 2.0% missing

2012: 2.1% missing

2013: 2.1%

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: All entries are in quotes

2013: 100%

"MKT.IMPROVEMENT.VALUE"

2009: 15.1% missing

2010: 14.6% missing

2011: 13.7% missing

2012: 13.2% missing

2013: 12.9% missing

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: All entries are in quotes

2013: 100%

"APPR.LAND.VALUE"

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

"APPR.IMPROVEMENT.VALUE"

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

"APPR.TOTAL.VALUE"

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

2009: ALL MISSING

2010: ALL MISSING

2011: ALL MISSING

2012: ALL MISSING

2013: ALL MISSING

"TAX.AMOUNT"

2009: 673 missing

2010: 729 missing

2011: 602 missing

2012: 1,509 missing

2013: 1,974 missing

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

 

2009: 100%

2010: 100%

2011: 100%

2012: All entries are in quotes

2013: 100%

"TAX.YEAR"

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: 100%

2010: 100%

2011: 100%

2012: 100%

2013: 100%

2009: All values are 2009

2010: All values are 2010

2011: All values are 2011

2012: All values are 2012

2013: All values are 2013

2009: 100%

2010: 100%

2011: 100%

2012: All entries are in quotes

2013: 100%

1 property ( 3830100034A) is classified single family home in both the county code and the land use code, but the value is valued at 75,025,700. Looking up this address on both the JCC property search and online, it would found that this parcel was a multi family.

Across the Years Checks

Address

  • 294 properties have at lest one different address in 2009, 2010, 2011, and 2013
  • 97 properties have at least one different reduced address (Street Name Only) in 2009, 2010, 2011, and 2013

Latitude

  • 1,529 (2.5%) properties have different latitudes and longitudes across the years.
  • 1,528 (2.5%) properties have different latitudes and longitudes across the years when excluding 2013.

  • Average difference between 2012 and 2013 latitudes is 0.

Tract

  • 48.6% of properties have at least one difference tract ID between 2009-2013

Attachments: