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:





