CountySprawl2020.xlsx

	A	B	C	D	E	F	G	H	I
1	countyID	County	State	MSAName	Index Score	Density Score	MixedUse Score	Centering Score	Street Score
2	1001	Autauga County	Alabama	Montgomery, AL	98.25	96.51	103.79	79.98	82.21
3	1003	Baldwin County	Alabama	Daphne-Fairhope-Foley, AL	70.20	90.95	82.48	80.53	92.65
4	1007	Bibb County	Alabama	Birmingham-Hoover, AL	77.62	88.42	43.77	66.39	71.72
5	1009	Blount County	Alabama	Birmingham-Hoover, AL	62.02	89.04	27.55	81.75	71.98
6	1015	Calhoun County	Alabama	Anniston-Oxford, AL	102.94	90.22	82.55	125.04	104.33
7	1021	Chilton County	Alabama	Birmingham-Hoover, AL	78.22	88.73	67.73	82.69	61.92
8	1033	Colbert County	Alabama	Florence-Muscle Shoals, AL	117.48	94.79	117.24	77.47	120.72
9	1051	Elmore County	Alabama	Montgomery, AL	71.17	90.00	51.48	92.65	75.87
10	1055	Etowah County	Alabama	Gadsden, AL	100.52	91.53	88.05	112.19	98.98
11	1069	Houston County	Alabama	Dothan, AL	99.62	93.43	98.30	107.29	90.96
12	1073	Jefferson County	Alabama	Birmingham-Hoover, AL	100.33	98.61	104.81	133.20	130.30
13	1077	Lauderdale County	Alabama	Florence-Muscle Shoals, AL	101.57	93.15	87.39	124.78	84.62
14	1079	Lawrence County	Alabama	Decatur, AL	77.96	88.48	60.96	76.84	61.34
15	1081	Lee County	Alabama	Auburn-Opelika, AL	90.38	97.02	90.71	114.56	85.68
16	1083	Limestone County	Alabama	Huntsville, AL	72.14	90.58	62.51	87.15	78.81
17	1089	Madison County	Alabama	Huntsville, AL	83.44	96.79	88.58	118.67	97.30
18	1097	Mobile County	Alabama	Mobile, AL	82.50	97.14	99.82	104.36	100.08
19	1101	Montgomery County	Alabama	Montgomery, AL	108.45	100.72	113.68	121.95	107.25
20	1103	Morgan County	Alabama	Decatur, AL	98.54	95.31	93.27	104.42	100.32
21	1113	Russell County	Alabama	Columbus, GA-AL	97.43	93.31	86.85	82.80	95.88
22	1115	St. Clair County	Alabama	Birmingham-Hoover, AL	67.84	89.79	47.82	87.25	76.79
23	1117	Shelby County	Alabama	Birmingham-Hoover, AL	84.57	94.41	76.21	120.26	90.54
24	1125	Tuscaloosa County	Alabama	Tuscaloosa, AL	111.23	95.10	104.94	142.58	107.68
25	4003	Cochise County	Arizona	Sierra Vista-Douglas, AZ	97.29	95.91	109.72	82.37	102.81
26	4005	Coconino County	Arizona	Flagstaff, AZ	99.20	95.62	118.81	123.19	63.93
27	4013	Maricopa County	Arizona	Phoenix-Mesa-Chandler, AZ	77.20	111.77	113.59	134.39	124.22
28	4015	Mohave County	Arizona	Lake Havasu City-Kingman, AZ	84.65	96.14	94.41	96.69	91.43
29	4019	Pima County	Arizona	Tucson, AZ	89.29	102.97	107.32	132.36	113.60
30	4021	Pinal County	Arizona	Phoenix-Mesa-Chandler, AZ	67.88	99.71	71.61	93.82	100.34
31	4025	Yavapai County	Arizona	Prescott Valley-Prescott, AZ	78.90	95.30	94.46	92.80	87.12
32	4027	Yuma County	Arizona	Yuma, AZ	110.11	99.88	95.17	134.10	114.11
33	5007	Benton County	Arkansas	Fayetteville-Springdale-Rogers, AR	79.23	95.59	87.17	103.37	92.03
34	5031	Craighead County	Arkansas	Jonesboro, AR	94.96	95.27	93.15	112.09	79.53
35	5033	Crawford County	Arkansas	Fort Smith, AR-OK	94.08	92.38	80.63	96.55	83.89
36	5035	Crittenden County	Arkansas	Memphis, TN-MS-AR	108.58	98.51	115.73	76.03	90.48
37	5045	Faulkner County	Arkansas	Little Rock-North Little Rock-Conway, AR	87.49	94.05	87.31	104.54	79.43
38	5051	Garland County	Arkansas	Hot Springs, AR	104.26	91.05	101.01	110.94	96.59
39	5053	Grant County	Arkansas	Little Rock-North Little Rock-Conway, AR	110.10	88.75	109.62	74.69	71.89
40	5069	Jefferson County	Arkansas	Pine Bluff, AR	121.42	92.91	102.19	113.18	118.61
41	5085	Lonoke County	Arkansas	Little Rock-North Little Rock-Conway, AR	77.54	90.92	56.65	91.52	80.08
42	5091	Miller County	Arkansas	Texarkana, TX-AR	114.30	94.80	108.29	80.13	107.10
43	5111	Poinsett County	Arkansas	Jonesboro, AR	105.08	89.18	110.15	70.48	71.96
44	5119	Pulaski County	Arkansas	Little Rock-North Little Rock-Conway, AR	106.65	100.37	106.27	130.95	123.96
45	5125	Saline County	Arkansas	Little Rock-North Little Rock-Conway, AR	83.71	91.89	75.53	108.15	79.83
46	5131	Sebastian County	Arkansas	Fort Smith, AR-OK	104.75	97.28	111.37	88.44	113.21
47	5143	Washington County	Arkansas	Fayetteville-Springdale-Rogers, AR	94.62	99.01	104.33	115.16	92.57
48	6001	Alameda County	California	Oakland-Berkeley-Livermore, CA	126.09	142.54	143.27	133.56	149.82
49	6007	Butte County	California	Chico, CA	103.09	98.30	125.19	107.72	95.53
50	6013	Contra Costa County	California	Oakland-Berkeley-Livermore, CA	96.63	113.55	123.31	119.86	122.54
51	6017	El Dorado County	California	Sacramento-Roseville-Folsom, CA	80.20	94.20	87.80	98.92	83.91
52	6019	Fresno County	California	Fresno, CA	83.67	104.74	127.80	100.70	107.21
53	6025	Imperial County	California	El Centro, CA	110.48	102.09	138.63	101.43	96.59
54	6029	Kern County	California	Bakersfield, CA	81.01	103.58	125.83	99.17	101.05
55	6031	Kings County	California	Hanford-Corcoran, CA	107.01	100.51	119.52	99.54	103.84
56	6037	Los Angeles County	California	Los Angeles-Long Beach-Glendale, CA	104.48	150.98	146.37	147.98	141.17
57	6039	Madera County	California	Madera, CA	89.23	96.50	105.56	94.18	83.93
58	6041	Marin County	California	San Rafael, CA	114.27	108.49	139.43	105.79	110.11
59	6047	Merced County	California	Merced, CA	99.44	102.06	120.99	108.60	97.33
60	6053	Monterey County	California	Salinas, CA	103.50	112.79	130.71	105.53	107.97
61	6055	Napa County	California	Napa, CA	127.65	102.38	131.94	124.22	113.47
62	6059	Orange County	California	Anaheim-Santa Ana-Irvine, CA	99.07	134.19	138.51	113.38	140.17
63	6061	Placer County	California	Sacramento-Roseville-Folsom, CA	90.83	100.75	112.70	104.13	104.28
64	6065	Riverside County	California	Riverside-San Bernardino-Ontario, CA	61.77	106.09	113.07	96.81	104.00
65	6067	Sacramento County	California	Sacramento-Roseville-Folsom, CA	106.93	116.58	129.03	140.93	131.17
66	6069	San Benito County	California	San Jose-Sunnyvale-Santa Clara, CA	105.84	99.73	108.12	81.92	95.06
67	6071	San Bernardino County	California	Riverside-San Bernardino-Ontario, CA	65.91	107.94	116.76	102.06	100.32
68	6073	San Diego County	California	San Diego-Chula Vista-Carlsbad, CA	84.53	120.30	125.70	126.41	118.32
69	6075	San Francisco County	California	San Francisco-San Mateo-Redwood City, CA	252.58	255.35	155.41	242.25	210.45
70	6077	San Joaquin County	California	Stockton, CA	95.16	107.33	129.85	100.81	121.48
71	6079	San Luis Obispo County	California	San Luis Obispo-Paso Robles, CA	113.72	100.48	136.28	116.94	111.73
72	6081	San Mateo County	California	San Francisco-San Mateo-Redwood City, CA	109.47	132.58	137.68	90.45	133.67
73	6083	Santa Barbara County	California	Santa Maria-Santa Barbara, CA	119.56	118.91	139.02	115.73	124.43
74	6085	Santa Clara County	California	San Jose-Sunnyvale-Santa Clara, CA	102.58	134.88	134.06	112.81	133.47
75	6087	Santa Cruz County	California	Santa Cruz-Watsonville, CA	109.64	106.26	130.82	106.71	108.98
76	6089	Shasta County	California	Redding, CA	97.92	95.25	110.10	115.77	86.42
77	6095	Solano County	California	Vallejo, CA	94.56	107.00	119.34	94.69	115.41
78	6097	Sonoma County	California	Santa Rosa-Petaluma, CA	96.04	100.86	132.55	108.37	100.92
79	6099	Stanislaus County	California	Modesto, CA	98.58	109.64	138.16	90.65	115.76
80	6101	Sutter County	California	Yuba City, CA	115.33	99.67	126.95	107.80	93.24
81	6107	Tulare County	California	Visalia, CA	94.59	100.96	126.80	106.56	103.39
82	6111	Ventura County	California	Oxnard-Thousand Oaks-Ventura, CA	93.86	111.66	128.84	102.86	115.80
83	6113	Yolo County	California	Sacramento-Roseville-Folsom, CA	102.17	104.74	130.54	83.93	107.29
84	6115	Yuba County	California	Yuba City, CA	98.65	98.35	99.59	80.16	98.37
85	8001	Adams County	Colorado	Denver-Aurora-Lakewood, CO	97.72	111.53	116.80	89.60	132.11
86	8005	Arapahoe County	Colorado	Denver-Aurora-Lakewood, CO	103.63	113.62	116.84	112.85	130.48
87	8013	Boulder County	Colorado	Boulder, CO	117.56	108.39	123.09	132.33	117.53
88	8014	Broomfield County	Colorado	Boulder, CO	124.31	107.65	111.85	81.69	127.03
89	8031	Denver County	Colorado	Denver-Aurora-Lakewood, CO	169.91	135.58	142.34	182.18	186.38
90	8035	Douglas County	Colorado	Denver-Aurora-Lakewood, CO	81.32	101.58	95.72	90.49	104.87
91	8041	El Paso County	Colorado	Colorado Springs, CO	88.86	104.52	112.81	101.57	121.81
92	8059	Jefferson County	Colorado	Denver-Aurora-Lakewood, CO	89.57	106.64	121.15	88.34	118.05
93	8069	Larimer County	Colorado	Fort Collins, CO	95.50	99.93	111.50	111.48	105.92
94	8077	Mesa County	Colorado	Grand Junction, CO	112.57	100.34	106.27	115.68	116.14
95	8101	Pueblo County	Colorado	Pueblo, CO	114.48	100.15	114.62	102.24	129.38
96	8119	Teller County	Colorado	Colorado Springs, CO	119.24	90.69	118.34	71.82	99.99
97	8123	Weld County	Colorado	Greeley, CO	93.73	97.05	107.65	113.46	101.89
98	9001	Fairfield County	Connecticut	Bridgeport-Stamford-Norwalk, CT	97.94	110.92	128.76	134.08	100.93
99	9003	Hartford County	Connecticut	Hartford-East Hartford-Middletown, CT	90.89	106.81	117.92	134.22	95.63
100	9007	Middlesex County	Connecticut	Hartford-East Hartford-Middletown, CT	90.53	94.47	101.66	112.78	76.00