Profiling

[ Codebooks ] [ Data Description ] [ Data Quality ]

Codebooks

BKFS dataset came with a codebook.
51095 is the code for James City.

Data Description

The tables below show the overall description of the various data tables used for this study.

STEP 1 - Take unique rows
STEP 2 - Remove rows for which V93 == "DR"
Multiple "Record Type"s (Field No. 93) for the same APN within the same year. "DR: Duplicate record"
Multiple "Building Area"s (Field No. 77) for the same APN within the same year.

"APN-A" (Field No. 3) is the Parcel Identification Number
Year	N-Orig	N-Step 1	N-Step 2	Unique APN
2009	31,877	31,866	31,349	31,341
2010	32,250	32,246	31,714	31,706
2011	32,480	32,475	31,939	31,931
2012	32,775	32,771	32,203	32,195
2013	33,227	33,223	32,645	32,637
2014	33,601	33,596	33,021	33,013
2009-2014	196,210	196,177	192,871	33,141

Why do the parcel counts vary so much across years?
The duplicates are multiple dwellings, we keep them!
APN # dwellings (Field No. 4)
"12-4 01-0-0062-A"
"32-1 01-0-0001-A"
"38-2 01-0-0002-A"
"47-2 15-0-0001-A"
"50-1 01-0-0009-L"
1,2
1,2,3
1,2,3
1,2
1,2,3

Data Quality

The tables below contain the results of the data profiling of key variables for the the following tables

	Year	N	NA	" "	Unique	min	max
3. apn_a_or_pin_number	2009	31,349	0	0	31,341
	2010	31,714	0	0	31,706
	2011	31,939	0	0	31,931
	2012	32,203	0	0	32,195
	2013	32,645	0	0	32,637
	2014	33,021	0	0	33,013
13. full_street_address_non_fielded	2009	31,349	0	643	30,194
	2010	31,714	0	638	30,556
	2011	31,939	0	631	30,808
	2012	32,203	0	633	31,066
	2013	32,645	0	635	31,511
	2014	33,021	0	632	31,876
117. property_address_latitude	2009	30,415	934	0	22,320	37.186745	37.450545
	2010	30,663	1,051	0	22,811	37.189883	37.45066
	2011	29,657	2,282	0	22,036	37.189883	37.45066
	2012	30,795	1,408	0	22,844	37.189786	37.45066
	2013	30,834	1,811	0	27,498	37.189786	37.45066
	2014	31,613	1,408	0	22,704	37.18972	37.45066
118. property_address_longitude	2009	30,415	934	0	17,011	-76.905693	-76.592226
	2010	30,663	1,051	0	17,807	-76.905693	-76.592226
	2011	29,657	2,282	0	17,192	-76.905693	-76.592227
	2012	30,795	1,408	0	17,785	-76.905693	-76.592224
	2013	30,834	1,811	0	26,900	-76.90563	-76.589186
	2014	31,613	1,408	0	16,469	-76.905632	-76.589188
119. property_address_census_tract_and_block	2009	31,349	0	9,34	489
	2010	31,714	0	1,051	494
	2011	31,939	0	2,282	488
	2012	32,203	0	1,408	915
	2013	32,645	0	1,811	914
	2014	33,021	0	1,408	925
71. county_land_use_description	2009	31,349	0	0	18
	2010	31,714	0	0	17
	2011	31,939	0	0	17
	2012	32,203	0	0	17
	2013	32,645	0	0	17
	2014	33,021	0	0	17
72. county_land_use_code	2009	31,349	0	0	16	60	808
	2010	31,714	0	0	15	60	808
	2011	31,939	0	0	15	60	808
	2012	32,203	0	0	15	60	808
	2013	32,645	0	0	15	60	808
	2014	33,021	0	0	15	60	808
73. standardized_land_use_code	2009	31,319	30	0	20	10	9213
	2010	31,684	30	0	19	10	9213
	2011	31,910	29	0	19	10	9213
	2012	32,174	29	0	18	1001	9213
	2013	32,616	29	0	19	10	9213
	2014	32,993	28	0	19	10	9213
78. year_built	2009	25,680	5,669	0	107	1810	2009
	2010	26,169	5,545	0	108	1810	2010
	2011	26,615	5,324	0	109	1810	2011
	2012	26,998	5,205	0	109	1810	2012
	2013	27,477	5,168	0	109	1810	2013
	2014	27,945	5,076	0	109	1810	2014
79. no_of_buildings	2009	395	30,954	0	11	2	35
	2010	402	31,312	0	11	2	35
	2011	404	31,535	0	11	2	35
	2012	412	31,791	0	12	2	35
	2013	418	32,227	0	10	2	35
	2014	406	32,615	0	10	2	35
80. no_of_stories	2009	31,349	0	5,709	11	1	5
	2010	31,714	0	5,584	16	1	5
	2011	31,939	0	5,364	16	1	5
	2012	32,203	0	5,242	15	1	5
	2013	32,645	0	5,207	15	1	5
	2014	33,021	0	5,119	15	1	5
81. no_of_units	all NA
82. total_no_rooms	2009	24,306	7,043	0	30	1	87
	2010	24,786	6,928	0	30	1	87
	2011	25,232	6,707	0	30	1	87
	2012	25,623	6,580	0	29	1	87
	2013	26,118	6,527	0	28	1	87
	2014	26,577	6,444	0	28	1	87
83. no_of_bedrooms	2009	21,870	9,479	0	9	1	9
	2010	22,374	9,340	0	9	1	9
	2011	22,840	9,099	0	9	1	9
	2012	23,341	8,862	0	9	1	9
	2013	23,921	8,724	0	9	1	9
	2014	24,452	8,569	0	9	1	9
84. no_of_baths	2009	24,323	7,026	0	9	100	1400
	2010	24,808	6,906	0	9	100	1400
	2011	25,250	6,689	0	9	100	1400
	2012	25,634	6,569	0	10	100	1400
	2013	26,117	6,528	0	10	100	1400
	2014	26,572	6,449	0	10	100	1400
85. no_of_partial_baths	2009	13,710	17,639	0	5	1	6
	2010	14,020	17,694	0	5	1	6
	2011	14,283	17,656	0	6	1	10
	2012	14,518	17,685	0	6	1	10
	2013	14,857	17,788	0	6	1	10
	2014	15,175	17,846	0	6	1	10
104. heating	2009	31,349	0		8
	2010	31,714	0		8
	2011	31,939	0		8
	2012	32,203	0		8
	2013	32,645	0		8
	2014	33,021	0		8
150. heating_fuel_type	2009	31,349	0		1
	2010	31,714	0		6
	2011	31,939	0		6
	2012	32,203	0		6
	2013	32,645	0		6
	2014	33,021	0		6
134. no_of_plumbing_fixtures	all NA
37. assessed_land_value	2009	31,349	0	0	2,630	0	38,206,400
	2010	31,714	0	0	2,629	0	38,206,400
	2011	31,939	0	0	2,629	0	38,206,400
	2012	32,203	0	0	2,633	0	38,206,400
	2013	32,645	0	0	2,631	0	38,206,400
	2014	33,021	0	0	2,634	0	38,206,400
38. assessed_improvement_value	2009	31,349	0	0	6,145	0	134,769,600
	2010	31,714	0	0	6,091	0	134,769,600
	2011	31,939	0	0	6,123	0	134,769,600
	2012	32,203	0	0	5,852	0	134,769,600
	2013	32,645	0	0	5,877	0	134,769,600
	2014	33,021	0	0	5,867	0	134,769,600
39. total_assessed_value	2009	31,349	0	0	7,797	0	139,019,500
	2010	31,714	0	0	7,726	0	139,019,500
	2011	31,939	0	0	7,755	0	139,019,500
	2012	32,203	0	0	7,454	0	139,019,500
	2013	32,645	0	0	7,482	0	139,019,500
	2014	33,021	0	0	7,447	0	139,019,500
94. market_value_land	2009	31,349	0	0	2,630	0	38,206,400
	2010	31,714	0	0	2,629	0	38,206,400
	2011	31,939	0	0	2,629	0	38,206,400
	2012	32,203	0	0	2,633	0	38,206,400
	2013	32,645	0	0	2,631	0	38,206,400
	2014	33,021	0	0	2,634	0	38,206,400
95. market_value_improvement	2009	31,349	0	0	6,145	0	134,769,600
	2010	31,714	0	0	6,091	0	134,769,600
	2011	31,939	0	0	6,123	0	134,769,600
	2012	32,203	0	0	5,852	0	134,769,600
	2013	32,645	0	0	5,877	0	134,769,600
	2014	33,021	0	0	5,867	0	134,769,600
96. total_market_value	2009	31,349	0	0	7,797	0	139,019,500
	2010	31,714	0	0	7,726	0	139,019,500
	2011	31,939	0	0	7,755	0	139,019,500
	2012	32,203	0	0	7,454	0	139,019,500
	2013	32,645	0	0	7,482	0	139,019,500
	2014	33,021	0	0	7,447	0	139,019,500
52. sales_price_whole_dollars_only	2009	31,349	0	0	5,438	0	76,696,055
	2010	31,714	0	0	5,509	0	76,696,055
	2011	31,939	0	0	5,549	0	76,696,055
	2012	32,203	0	0	5,593	0	76,696,055
	2013	32,645	0	0	5,779	0	76,696,055
	2014	33,021	0	0	5,841	0	76,696,055
55. prior_sales_price	2009	31,349	0	0	4,204	0	76,696,055
	2010	31,714	0	0	4,351	0	76,696,055
	2011	31,939	0	0	4,503	0	76,696,055
	2012	32,203	0	0	4,623	0	76,696,055
	2013	32,645	0	0	4,781	0	76,696,055
	2014	32,890	131	0	5,002	0	76,696,055
44. tax_amount	2009	31,349	0	0	1	0	0
	2010	31,714	0	0	1	0	0
	2011	31,939	0	0	1	0	0
	2012	32,203	0	0	1	0	0
	2013	32,645	0	0	1	0	0
	2014	33,021	0	0	1	0	0

Quality: 2009-2014

Duplications

No duplicated rows

Field No. 3 "APN-A"

Duplications due to multiple dwellings for 5 APNs, see above.

Variables

Completeness

Validity

Uniqueness

Consistency

Field No. 1 "State (Postal Code)"

100%

VA

100%

Field No. 2 "County Name"

100%

JAMES CITY

100%

Field No. 4 "Duplicate APN / Multiple Address ID"

2009: 10,212 NA

2010: 21,276 NA

2011: 10,504 NA

2012: 21,489 NA

2013: 10,917 NA

2014: 21,674 NA

Levels:

1 2 3
13 15 9

NA Coding: NA

Field No. 13 "Full Street Add."

(2009-2014) 1896 missing

2009: 174 missing

2010: 463 missing

2011: 171 missing

2012: 458 missing

2013: 177 missing

2014: 453 missing

Levels coded with spaces

(2009-2014) 32,705 levels

2009 Levels: 10,217

2010 Levels: 21,284

2011 Levels: 10,509

2012 Levels: 21,497

2013 Levels: 10,917

2014 Levels: 21,685

NA Coding: " "

Field No. 14 "City Name"

2009: 94 missing

2010: 303 missing

2011: 93 missing

2012: 300 missing

2013: 90 missing

2014: 294 missing

Levels coded with spaces

Levels: "BARHAMSVILLE" "LANEXA" "TOANO" "WILLIAMSBURG"

NA Coding: " "

Field No. 15 "State"

2009: 94 missing

2010: 303 missing

2011: 93 missing

2012: 300 missing

2013: 90 missing

2014: 294 missing

VA

NA Coding: " "

Field No. 16 "Property ZIP Code"

2009: 98 missing

2010: 303 missing

2011: 97 missing

2012: 314 missing

2013: 94 missing

2014: 295 missing

Levels: "23011" "23081" "23089" "23168" "23185" "23188"

NA Coding: NA

Field No. 117 "Property Address: Latitude"

2009: 283 missing

2010: 709 missing

2011: 569 missing

2012: 893 missing

2013: 600 missing

2014: 986 missing

Levels: ( 99.999999)

(2009-2014) 39,502 levels

2009 Levels: 8,622

2010 Levels: 14,407

2011 Levels: 8,611

2012 Levels: 14,432

2013 Levels: 9,531

2014 Levels: 14,135

NA Coding: NA

Field No. 118 "Property Address: Longitude"

2009: 283 missing

2010: 709 missing

2011: 569 missing

2012: 893 missing

2013: 600 missing

2014: 986 missing

Levels: ( -999.999999)

(2009-2014) 29,508 levels

2009 Levels: 7,437

2010 Levels: 12,633

2011 Levels: 7,513

2012 Levels: 12,626

2013 Levels: 9,462

2014 Levels: 12,101

NA Coding: NA

Field No. 119 "Property Address: Census Tract & Block"

2009: 283 missing

2010: 709 missing

2011: 569 missing

2012: 893 missing

2013: 600 missing

2014: 986 missing

1,347 Levels for all years: (999999999.99999C)

NA Coding: " "

Field No. 71 "County Land Use Description"

100%

Levels coded with spaces

17 Levels

NA Coding: " "

Field No. 72 "County Land Use Code"

100%

15 Levels (some codes have multiple descriptions in V71)

Field No. 73 "Standardized Land Use Code"

2009: 10 missing

2010: 20 missing

2011: 10 missing

2012: 19 missing

2013: 7 missing

2014: 20 missing

19 Levels: [char](4)

NA Coding: NA

Field No. 78 "Year Built”

2009: 2,627 missing

2010: 2,972 missing

2011: 2,409 missing

2012: 2,791 missing

2013: 2,435 missing

2014: 2,541 missing

113 Levels: 1810-2014

2009 Levels: 102

2010 Levels: 91

2011 Levels: 104

2012 Levels: 93

2013 Levels: 103

2014 Levels: 94

NA Coding: NA

Field No. 149 "Effective Year Built"

all NA

NA Coding: NA

Field No. 79 "No of Buildings”

2009: 10107 missing

2010: 21000 missing

2011: 10386 missing

2012: 21212 missing

2013: 10917 missing

2014: 21408 missing

NA Coding: NA

Field No. 80 "No of Stories”

2009: 2653 missing

2010: 2986 missing

2011: 2436 missing

2012: 2804 missing

2013: 2457 missing

2014: 2557 missing

15 Levels: "1" "1.25" "1.35" "1.5" "1.5+B" "1.75" "1+B"

"2" "2.5" "2.5+B" "2+B" "3" "5"

S/L	Split level	4/L	4 split levels	1+A	1 story with attic
B/L	Bi-level	3/L	3 split levels	1+B	1 story with basement
S/E	Split entry	S/F	split foyer	2+B	2 stories with basement

NA Coding: " "

Field No. 81 "No of Units”

all NA

NA Coding: NA

Field No. 82 "Total # Rooms”

2009: 3065 missing

2010: 3916 missing

2011: 2846 missing

2012: 3737 missing

2013: 2827 missing

2014: 3479 missing

30 Levels: min:1 max:87

NA Coding: NA

Field No. 83 "No of Bedrooms”

2009: 3924 missing

2010: 5475 missing

2011: 3696 missing

2012: 5185 missing

2013: 3631 missing

2014: 4798 missing

9 Levels: "1" "2" "3" "4" "5" "6" "7" "8" "9"

NA Coding: NA

Field No. 84 "No of Baths”

2009: 3091 missing

2010: 3871 missing

2011: 2873 missing

2012: 3692 missing

2013: 2849 missing

2014: 3453 missing

10 Levels: "100" "200" "300" "400" "500" "600" "700"

"800" "900" "1400"

NA Coding: NA

Field No. 85 "No of Partial Baths”

2009: 7090 missing

2010: 10583 missing

2011: 7039 missing

2012: 10563 missing

2013: 7144 missing

2014: 10449 missing

6 Levels: "1" "2" "3" "4" "6" "10"

NA Coding: NA

Field No. 104 "Heating"

2009: 4,406 missing

2010: 5,883 missing

2011: 4,724 missing

2012: 6,243 missing

2013: 5,188 missing

2014: 6,441 missing

7 Levels "A" "D" "F" "H" "O" "T" "W"

A: Baseboard (44); D: Forced air (49,434); F: Floor/wall (9);

H: Heat pump (13,116); O: Other (183); T: Solar (80); W: Wood burning (358)

NA Coding: " "

Field No. 150 "Heating Fuel Type"

2009: 10217 missing

2010: 19145 missing

2011: 8470 missing

2012: 18838 missing

2013: 8399 missing

2014: 18509 missing

5 Levels "E" "G" "N" "O" "S"

E: Electric (55); G: Gas (12,392); N: None (11);

O: Oil (8); S: Solar (65)

NA Coding: " "

Field No. 134 "of Plumbing Fixtures"

all NA

NA Coding: NA

VT Census Case Studies : James City - Profiling

Profiling

Codebooks

Data Description

Data Quality

Attachments: