options(scipen=999)
library(socviz) # use for the round_df() function
#load("FIFA_viz.RData")
#load("Catholic_viz.RData")
#load("NBA_viz.RData")
load("Murders96_viz.RData")DAT-4313 - Data Viz in Model Development
Lab 6
FURTHER INSTRUCTIONS
Use the dataset assigned to you in the LAB Instructions.
Use the depvar indicated for your dataset.
Select 5-8 independent variables from your dataset as predictors, and estimate a linear regression model.
Note that not all variables in your dataset make sense as predictors. For example, categorical variables with many levels or all components of a derived variable are unreasonable.
Work through the EDA to identified good candidates. Your model should be linear in the parameters. Consider alternative functional forms for your depvar or continuous variables.
Include interpretations and comments after each chunk.
Conclude with a final assessment of the model and a reflection of the value of data visualization to aid model development.
Example Code for FIFA with depvar=Wage
DATA
Partition 60% Train / 40% Test
library(caret)
set.seed(1)
index <- createDataPartition(Murders96_viz$arrests, p=0.6, list=FALSE)
train <- Murders96_viz[index,]
test <- Murders96_viz[-index,]Training set number of observations: 1320
Test dataset number of observations: 877
EDA
Descriptive Statistics
library(psych)
library(tidyverse)
library(flextable)
psych::describe(train, fast=TRUE) # (class note --> remove flextable) vars n mean sd min max range se
arrests 1 1320 5.21 18.76 0.00 320.00 320.00 0.52
countyid 2 1320 32550.57 15488.80 1001.00 56043.00 55042.00 426.32
density 3 1320 265.34 1817.83 0.08 54058.77 54058.69 50.03
popul 4 1320 94031.70 223537.24 141.00 3126966.00 3126825.00 6152.66
perc1019 5 1320 15.11 1.88 7.60 24.54 16.94 0.05
perc2029 6 1320 12.05 3.19 5.62 34.75 29.14 0.09
percblack 7 1320 8.34 13.93 0.00 86.28 86.28 0.38
percmale 8 1320 49.33 1.63 44.83 61.64 16.82 0.04
rpcincmaint 9 1320 207.78 116.83 19.14 1281.10 1261.96 3.22
rpcpersinc 10 1320 12569.38 3031.90 5322.20 41094.22 35772.02 83.45
rpcunemins 11 1320 52.90 34.85 0.00 287.10 287.10 0.96
year 12 1320 1996.00 0.00 1996.00 1996.00 0.00 0.00
murders 13 1320 5.88 26.27 0.00 420.00 420.00 0.72
murdrate 14 1320 0.42 0.77 0.00 11.01 11.01 0.02
arrestrate 15 1320 0.48 0.94 0.00 13.99 13.99 0.03
statefips 16 1320 32.45 15.46 1.00 56.00 55.00 0.43
countyfips 17 1320 99.81 109.51 1.00 840.00 839.00 3.01
execs 18 1320 0.01 0.14 0.00 3.00 3.00 0.00
lpopul 19 1320 10.40 1.35 4.95 14.96 10.01 0.04
execrate 20 1320 0.00 0.04 0.00 1.18 1.18 0.00
statename 21 1320 NaN NA Inf -Inf -Inf NA
statecode 22 1320 NaN NA Inf -Inf -Inf NA
region 23 1320 NaN NA Inf -Inf -Inf NA
Boxplots – All Numeric
data_long <- train %>%
select(where(is.numeric)) %>%
pivot_longer(cols = everything(), names_to = "Variable", values_to = "Value")
ggplot(data_long, aes(x = Variable, y = Value)) +
geom_boxplot() +
coord_flip() +
facet_wrap(~ Variable, scales = "free", ncol=3) +
theme_minimal() +
theme(axis.text.x = element_blank()) +
labs(title = "Horizontal Boxplot for Each Numeric Variable")library(DataExplorer)
plot_boxplot(train, by="density") Histograms
plot_histogram(train)Scatterplots (depvar ~ all x)
Look at the shape of the relationship between the dependent variable and all of the continuous potential independent variables.
plot_scatterplot(test, by="arrests")Correlation Matrix
plot_correlation(train, type="continuous")MODEL
Linear Regression Model
From the above EDA, we chose the following variables to start. Note that, given the shape of the relationship between Wage and Age, we entered Age as a quadratic.
From experience and prior research, it is common to specify a dependent variable that is a currency variable (e.g., sales, revenue, wages) in log form.
Estimate the following model:
\(log(Wage.n) = Age + Age^2 + Potential + International.Reputation + Value.n + Special + Height + RightFoot + Skill.Moves\)
Estimate Coefficients and show coefficients table
model <- lm(arrests ~ statefips + countyfips, data = train)
model %>% as_flextableEstimate | Standard Error | t value | Pr(>|t|) | ||
|---|---|---|---|---|---|
(Intercept) | 6.543 | 1.221 | 5.356 | 0.0000 | *** |
statefips | -0.053 | 0.034 | -1.533 | 0.1254 |
|
countyfips | 0.004 | 0.005 | 0.778 | 0.4370 |
|
Signif. codes: 0 <= '***' < 0.001 < '**' < 0.01 < '*' < 0.05 | |||||
Residual standard error: 18.75 on 1317 degrees of freedom | |||||
Multiple R-squared: 0.001925, Adjusted R-squared: 0.0004097 | |||||
F-statistic: 1.27 on 1317 and 2 DF, p-value: 0.2811 | |||||
Coefficient Magnitude Plot
# note this simple code using coefplot package produces chart like Figure 6.6 in one short line.
library(coefplot)
coefplot(model, soft="magnitude", intercept=FALSE)Check for predictor independence
Using Variance Inflation Factors (VIF)
library(car)
vif(model) statefips countyfips
1.056521 1.056521
Residual Analysis
Residual Range
quantile(round(residuals(model, type = "deviance"),2)) 0% 25% 50% 75% 100%
-7.1300 -5.3825 -4.1400 -1.9400 315.2900
Residual Plots
We are looking for: - Random distribution of residuals vs fitted values - Normally distributed residuals : Normal Q-Q plot with values along line - Homoskedasticity with a Scale-Location line that is horizontal and no residual pattern - Minimal influential obs - that is, those outside the borders of Cook’s distance
plot(model)Plot Fitted Value by Actual Value
library(broom)
train2 <- augment(model, data=train) # this appends predicted to original dataset to build plots on your own
p <- ggplot(train2, mapping = aes(y=.fitted, x=arrests))
p + geom_point()Plot Residuals by Fitted Values
p <- ggplot(train2, mapping = aes(y=.resid, x=.fitted))
p + geom_point()Performance Evaluation
Use Model to Score test dataset (Display First 10 values - depvar and fitted values only)
pred <- predict(model, newdata = test, interval="predict") #score test dataset wtih model
test_w_predict <- cbind(test, pred) # append score to original test dataset
test_w_predict %>%
head(10) %>%
select(arrests, fit, lwr,upr) %>%
as_flextable(show_coltype = FALSE) arrests | fit | lwr | upr |
|---|---|---|---|
6 | 6.5 | -30.4 | 43.4 |
1 | 6.5 | -30.4 | 43.4 |
0 | 6.5 | -30.3 | 43.4 |
20 | 6.5 | -30.3 | 43.4 |
2 | 6.6 | -30.3 | 43.4 |
0 | 6.6 | -30.3 | 43.4 |
2 | 6.6 | -30.3 | 43.5 |
8 | 6.6 | -30.3 | 43.5 |
1 | 6.6 | -30.2 | 43.5 |
5 | 6.7 | -30.2 | 43.5 |
n: 10 | |||
Plot Actual vs Fitted (test)
plot(test_w_predict$arrests, test_w_predict$fit, pch=16, cex=1)Performance Metrics
library(Metrics)
metric_label <- c("MAE","RMSE", "MAPE")
metrics <- c(round(mae(test_w_predict$arrests, test_w_predict$fit),4),
round(rmse(test_w_predict$arrests, test_w_predict$fit),4),
round(mape(test_w_predict$arrests, test_w_predict$fit),4))
pmtable <- data.frame(Metric=metric_label, Value = metrics)
flextable(pmtable)Metric | Value |
|---|---|
MAE | 9.3102 |
RMSE | 54.9081 |
MAPE | Inf |
Model Fit by Continent
# Filter for a range of density values
subset(test_w_predict, density > 50 & density < 100) arrests countyid density popul perc1019 perc2029 percblack percmale
34 6 1003 77.05643 123023 13.93886 11.639290 13.4966600 48.83233
68 0 1009 67.20457 43392 14.17542 12.993180 1.4150070 48.97446
170 0 1021 50.89291 35323 14.80339 12.643320 11.9214100 48.60006
238 8 1031 61.70618 41910 14.32355 13.777140 18.1818200 49.00501
340 5 1043 99.22273 73274 13.82892 12.776700 0.8898109 48.70077
357 1 1045 87.62303 49167 14.24940 18.331400 18.7564800 49.71424
918 7 1115 93.40553 59218 14.20683 13.468880 9.7132630 50.46608
986 6 1123 55.44259 39810 14.60186 12.466720 27.4880700 47.11128
1020 4 1127 87.71572 69686 14.42471 12.579280 6.8693860 48.10148
1224 1 5005 65.62207 36382 11.04942 8.221098 0.0192403 47.86433
1258 3 5009 53.96624 31906 14.31392 11.718800 0.0156710 47.98470
1462 3 5033 82.40829 49074 16.27542 12.473000 0.9944166 49.07894
1479 13 5035 81.25172 49604 17.48851 14.424240 45.5931000 47.18168
1649 0 5055 60.66452 35037 14.65594 12.509630 0.0684990 48.44878
1955 5 5091 62.41259 38950 16.19255 13.278560 24.5237500 47.81001
2567 5 6017 88.63936 151706 13.42135 8.937023 0.5181074 50.19709
2669 48 6029 76.48705 622729 15.25158 13.669510 6.3671360 51.39089
2686 7 6031 81.57767 113351 14.99943 17.054110 8.7842190 53.75427
2822 10 6047 99.70036 192311 16.71615 13.383010 4.7906780 50.65857
3026 205 6071 79.67004 1598358 15.41864 13.954130 8.2457120 50.14746
3332 27 6107 72.53290 349922 16.98264 12.455630 1.6680860 50.37466
4148 7 8101 54.92992 131217 15.45836 10.964280 2.1742610 48.71396
5525 0 17027 74.57521 35368 15.12667 13.073970 3.9696900 51.62576
6069 0 17095 78.08818 55936 14.31994 11.300420 6.2768160 49.67641
6171 0 17107 50.95507 31499 13.89885 13.362330 5.7335150 51.00797
6256 0 17117 56.72736 48994 14.98143 10.515570 0.8796995 48.12018
6341 0 17127 64.15307 15336 13.92801 9.924361 6.5336460 47.33307
6392 0 17133 65.29935 25358 13.94037 11.101030 0.0985882 49.47157
6460 0 17141 66.02596 50107 15.01387 10.721060 0.1456882 49.22665
6732 0 17177 87.13268 49167 14.17618 10.832470 7.0596130 48.48781
6783 0 17183 94.82597 85260 14.74666 10.823360 10.1102500 49.14380
6953 0 17203 65.89968 34798 16.58716 9.675843 0.2241508 49.15512
7157 1 18023 81.15044 32876 14.70678 11.917510 0.1977126 48.57343
7191 0 18027 66.76791 28760 15.00348 11.728090 0.3755216 48.53964
7225 0 18031 67.37231 25105 16.03266 12.443740 0.1433977 49.59171
7276 0 18037 90.87888 39088 14.06314 14.052910 0.0869832 49.31181
7378 0 18049 54.87550 20223 14.00386 10.918260 0.8109578 48.70692
7395 0 18051 65.57787 32058 13.69705 11.837920 2.0494100 48.23757
7480 0 18061 68.72517 33349 15.44574 12.063330 0.4377942 49.80659
7548 0 18069 96.76775 37024 14.97677 12.902440 0.1944685 48.71975
7565 0 18071 79.44859 40467 14.82195 12.788200 0.4027973 48.65199
7701 0 18087 84.57568 32103 17.87995 12.917800 0.0996792 49.95483
7939 0 18115 63.29872 5490 14.49909 12.349730 0.7650273 48.88889
8228 0 18149 75.64604 23399 15.67161 12.333860 0.3376213 49.46365
8245 1 18151 99.86217 30831 14.63462 13.282090 0.1978528 50.10866
8313 0 18159 63.18210 16453 14.98207 10.988880 0.0607792 48.84216
8517 1 18183 89.00215 29863 15.21950 11.656560 0.1038074 49.31855
8789 0 20037 61.27874 36337 15.01500 15.235160 1.4448080 48.31989
9146 0 20079 58.02815 31302 15.61242 10.536070 1.8720850 48.65823
9690 0 20155 50.14013 62901 15.27003 11.414760 3.1128280 49.47616
10132 0 22001 87.88167 57590 17.32592 12.594200 19.7638500 47.61591
10302 1 22039 51.60361 34281 17.21653 12.432540 28.0184400 48.01785
10438 3 22057 80.90973 87772 16.91883 15.572160 13.5669700 48.89600
10455 3 22061 89.73625 42302 20.35128 21.956410 41.6528800 48.56981
10540 8 22079 95.48139 126290 16.20398 13.687540 29.8954800 47.64589
10574 19 22097 89.32382 82955 17.44078 12.323550 42.7581200 47.65234
10744 6 22119 71.63610 42690 15.49778 11.405480 33.5699200 47.30850
10897 1 23015 68.70703 31303 13.82296 8.928857 0.0926429 48.99211
11118 1 24011 91.17197 29189 13.94361 10.545070 20.1788300 48.77180
11356 3 24039 74.15685 24266 14.30809 16.685900 44.3789700 54.16632
11798 0 26015 95.55712 53145 15.59319 10.646350 0.2163891 50.23615
12155 1 26057 70.11695 39978 16.59663 12.962130 0.9905448 48.90940
12563 0 26105 55.98849 27725 14.70153 9.915239 0.8512173 49.17223
13005 1 26157 71.17574 57837 16.80412 11.238480 0.8299186 49.71558
13192 0 27013 72.03595 54199 17.39331 20.367530 0.5535157 49.78690
13379 0 27035 50.80187 50634 15.62784 9.246751 0.2843939 48.70640
13498 0 27049 55.84855 42366 15.61394 9.953736 0.2360383 49.41935
13804 0 27085 68.37464 33636 16.38423 11.038770 0.1516233 49.68784
13923 0 27099 52.21263 37151 15.07631 8.947269 0.2503297 48.77123
14297 3 27145 94.44562 126990 18.58414 16.665090 0.4590913 50.36381
14501 1 27169 77.29147 48411 17.94220 15.880690 0.4957551 49.05497
14654 2 28043 53.22181 22455 15.88510 13.422400 43.1574200 46.74237
14756 8 28067 91.43779 63447 15.56417 12.736620 26.3022700 47.76427
14773 3 28071 53.10131 33515 17.13860 25.138000 27.1192000 48.84380
14875 8 28089 94.93758 68273 15.13776 17.534020 46.1426900 47.56199
14943 0 28105 85.86016 39303 17.71112 26.102330 36.3712700 49.84098
15062 3 28151 91.31482 66115 18.21523 13.857670 59.3465900 46.84867
15215 1 29145 76.22501 47751 15.41538 11.423840 0.4397814 48.99374
15283 1 29159 53.67899 36767 14.70068 11.861180 3.8512800 48.38850
15368 0 29169 62.76694 34334 16.91035 19.415160 14.5133100 54.62515
16388 1 31043 70.19568 18528 16.62349 13.563260 0.4587651 49.88126
16473 0 31053 65.52789 35022 15.24470 11.258640 0.2912455 47.97841
18122 8 35061 56.40299 60214 16.62238 11.299700 1.5212410 50.34211
18275 1 36017 58.27472 52121 14.43372 10.886210 0.8326778 49.17020
19091 1 36113 70.70326 61490 13.95511 11.984060 0.5610669 48.39974
19159 1 36121 74.80685 44357 13.80165 13.673150 6.0080710 53.99148
19261 0 37009 55.82902 23792 12.73958 10.886010 0.6851043 48.60457
19533 0 37041 81.66936 14099 13.44067 10.277320 38.2509400 46.70544
19584 1 37047 55.48856 51975 15.29004 11.490140 31.2092400 47.65753
19924 5 37091 63.46914 22447 15.36954 11.418010 58.1770400 46.31799
20077 6 37111 86.16051 38057 14.02107 11.866410 4.2304960 48.87143
20094 2 37113 52.50487 27114 11.01645 8.807259 1.5379510 48.11905
20366 3 37149 68.23680 16226 10.37224 9.145815 7.4263530 47.01097
20842 1 38017 64.19382 113343 14.88579 18.897510 0.3493820 50.01015
21267 0 39027 94.07007 38645 15.66568 12.935700 2.2357350 48.82132
21352 1 39039 97.42048 40059 16.38583 12.379240 1.4728280 49.60184
21454 0 39053 70.01961 32820 15.39305 12.419260 3.1109080 49.07678
21505 3 39059 77.60230 40509 14.90286 11.350560 1.7082620 47.95231
21590 0 39073 67.22053 28413 14.94034 11.716470 1.0558550 50.29036
21692 1 39097 88.53834 41184 13.62908 16.023210 8.7776800 55.20105
21828 0 39127 82.53361 33834 16.07554 12.330790 0.1921144 49.03943
21845 0 39131 61.50769 27156 16.41626 12.122550 1.4840180 48.99102
22338 5 40017 92.62209 83342 17.16781 11.554800 2.5545340 50.32877
22508 5 40037 68.52483 65469 16.36958 11.356520 3.2946890 48.92086
23018 1 40097 55.72424 36565 15.66525 11.122660 0.2105839 49.34227
23137 0 40111 54.26195 37821 15.71349 10.779730 12.6173300 48.46778
23256 4 40125 78.29276 61682 17.31623 12.921110 2.3377970 48.11128
23307 3 40131 94.14087 63536 16.55125 11.173190 0.8750944 49.62698
23749 7 41029 60.53470 168609 14.49448 10.816740 0.2805307 49.14091
24242 0 42015 54.19184 62352 14.96504 11.048560 0.2614190 48.84045
24667 0 42065 71.12717 46624 14.58476 10.603980 0.1158202 48.53509
24803 2 42081 96.44308 119083 14.22369 12.014310 2.6712460 48.46704
25619 8 45033 73.05356 29574 17.25164 12.818690 44.2889000 46.49692
25704 12 45043 63.28315 51555 15.96547 11.760260 43.8851700 47.77228
25908 0 45067 71.34640 34895 17.38358 11.669290 55.2486000 45.49936
26078 0 45087 59.72315 30709 13.99915 12.341660 30.6848200 46.49451
26639 2 47029 72.50849 31495 14.22766 12.846480 2.2765520 48.29655
26673 2 47035 61.69342 42048 13.17542 11.617670 0.1022641 48.58733
26690 1 47045 70.89421 36193 14.09941 12.762140 12.6930600 47.51471
26809 2 47059 94.26121 58613 13.42535 12.579120 2.3527200 48.54213
26928 1 47079 52.94122 29736 12.83629 10.593220 10.7176500 48.18738
27030 1 47097 50.95403 23972 14.69631 13.711830 32.7590500 49.01134
27081 2 47103 50.42521 28756 13.50327 12.101820 9.1980800 48.31687
27115 1 47111 56.56326 17373 13.73396 13.146840 0.2647787 48.71928
27166 2 47123 52.40450 33289 15.14014 12.448560 2.8928480 48.73081
27455 0 47169 57.66935 6588 13.50941 11.672740 15.2398300 48.81603
27506 1 47177 82.18656 35556 14.03420 12.574530 3.7012040 48.37721
27557 0 47183 56.13117 32568 15.24195 16.095550 7.3507740 48.14849
27778 3 48021 52.69935 46819 14.91702 10.636710 12.4415300 50.68455
28067 0 48055 55.91175 30514 17.63125 13.328310 11.3226700 50.53090
29308 7 48203 66.41639 59685 17.01097 11.259110 29.7344400 48.10924
29393 4 48213 75.10256 65664 13.98635 9.449622 8.4551660 48.56390
29461 0 48221 82.95589 34976 13.29483 8.817474 0.2315874 49.71409
29954 7 48291 54.58014 63294 15.81983 12.729480 15.7187100 52.40465
30430 4 48347 59.71471 56533 16.50717 19.822050 17.8869000 48.51149
30583 3 48367 84.20045 76073 15.49696 10.564850 1.0463630 50.01775
31263 7 48449 60.67652 24909 15.26356 12.272670 14.1756000 48.82573
31348 3 48459 59.40493 34909 15.96436 10.318260 13.1885800 48.40013
31416 2 48467 50.17271 42579 14.55177 9.093685 4.0395500 48.92318
31433 1 48469 92.40481 81541 16.65910 11.813690 6.7990340 48.97168
32249 0 50027 56.82453 55190 11.81011 10.195690 0.3968110 49.22812
32385 3 51015 61.25327 59515 13.41511 11.681090 4.0325970 50.60909
32419 1 51019 69.90748 52768 12.79184 11.033200 8.8462710 49.90335
32555 0 51035 58.14487 27703 13.09605 11.085440 0.4187272 49.28347
32606 0 51043 71.01816 12543 11.77549 11.767520 9.9019370 49.79670
32640 3 51047 83.91115 31981 13.28914 14.136520 20.5090500 50.79578
32674 0 51051 52.25396 17381 16.77694 10.793400 0.4315057 48.99603
32742 0 51061 79.60300 51765 13.40095 12.068000 12.3075400 50.18449
32776 0 51065 58.75712 16887 12.99224 12.044770 24.6461800 49.16800
32793 2 51067 62.96048 43574 14.04507 12.417960 11.9291300 49.37577
32895 0 51079 82.82892 12972 13.32100 13.035770 7.3003390 49.59914
33014 2 51093 89.87953 28391 13.36691 12.306720 34.2045000 48.77602
33099 0 51103 85.76435 11418 10.77246 7.479418 32.0634100 46.82081
33286 1 51127 57.42209 12047 13.50544 10.973690 22.2960100 49.72192
33575 3 51165 73.34946 62432 13.46425 12.328610 1.6642110 49.32727
33592 0 51167 61.38463 29134 15.16784 11.354430 1.2253720 49.12473
33626 0 51171 65.62766 33612 11.76068 11.278710 1.2346780 48.40533
33796 1 51193 72.21889 16549 11.84362 10.496100 35.1078600 48.15397
33813 1 51195 97.93151 39494 16.36198 11.224490 2.0104320 48.37444
33830 4 51197 56.89904 26357 13.60170 11.568080 3.8737340 47.50920
34272 3 53005 78.89137 134359 16.49536 11.612920 1.1633010 49.80984
34697 0 53055 68.94852 12061 10.17329 5.654589 0.2653180 49.83832
34850 3 53073 71.95010 152512 15.36469 14.400180 0.5842163 49.52725
35054 1 54019 73.66776 48908 15.48826 12.376300 6.3445650 48.67711
35258 1 54043 50.63416 22150 16.31603 13.413090 0.0270880 49.24605
35275 0 54045 92.12583 41839 17.34984 12.717800 3.1740720 48.37831
35394 1 54059 78.05732 32986 17.59231 14.460680 2.5889770 48.95410
35513 0 54073 57.25253 7484 14.57777 12.814000 0.2137894 48.54356
35717 0 54097 66.63322 23640 15.85448 15.139590 0.6175973 49.14975
35768 2 54103 52.02410 18688 14.24444 12.291310 0.0856164 48.31443
35955 0 55017 53.78728 54348 15.95091 11.113560 0.0643998 49.47928
36176 0 55045 56.08955 32755 15.35338 10.752560 0.1038009 49.12532
36312 0 55061 57.38497 19661 16.25553 11.245610 0.1424139 50.45013
36584 0 55097 80.80849 65146 17.07089 17.253550 0.3315629 50.08443
36703 1 55111 62.27461 52164 15.08703 11.304730 0.1476114 49.48432
36958 4 55141 96.15549 76219 15.51713 11.755600 0.1416969 49.00484
rpcincmaint rpcpersinc rpcunemins year murders murdrate arrestrate
34 139.084 13583.020 28.710 1996 6 0.4877137 0.4877137
68 184.382 11094.820 21.692 1996 2 0.4609145 0.0000000
170 231.594 10819.840 40.194 1996 0 0.0000000 0.0000000
238 207.988 12356.780 37.004 1996 6 1.4316390 1.9088520
340 187.572 11594.370 33.176 1996 0 0.0000000 0.6823703
357 246.268 11117.150 29.986 1996 1 0.2033885 0.2033884
918 161.414 11296.430 21.054 1996 4 0.6754703 1.1820730
986 249.458 12065.220 45.298 1996 7 1.7583520 1.5071590
1020 242.440 11992.490 36.366 1996 1 0.1435008 0.5740034
1224 134.618 12125.190 45.298 1996 3 0.8245836 0.2748612
1258 186.934 11140.120 47.850 1996 1 0.3134207 0.9402620
1462 190.762 9857.100 58.058 1996 1 0.2037739 0.6113217
1479 390.456 11043.780 35.090 1996 16 3.2255460 2.6207560
1649 207.350 10392.380 61.886 1996 0 0.0000000 0.0000000
1955 297.946 10289.030 26.796 1996 4 1.0269580 1.2836970
2567 175.450 15665.450 60.610 1996 2 0.1318339 0.3295849
2669 443.410 11362.780 102.718 1996 52 0.8350342 0.7708008
2686 386.628 9284.814 88.682 1996 10 0.8822154 0.6175507
2822 565.268 10886.830 126.962 1996 8 0.4159929 0.5199910
3026 403.216 11692.630 57.420 1996 185 1.1574380 1.2825660
3332 523.798 10785.390 140.998 1996 22 0.6287115 0.7716005
4148 362.384 12271.930 29.348 1996 13 0.9907253 0.5334675
5525 95.700 13161.300 70.818 1996 0 0.0000000 0.0000000
6069 180.554 12675.780 77.198 1996 0 0.0000000 0.0000000
6171 123.134 11597.560 65.076 1996 0 0.0000000 0.0000000
6256 166.518 13130.680 74.008 1996 0 0.0000000 0.0000000
6341 252.010 10961.480 45.298 1996 0 0.0000000 0.0000000
6392 51.678 15011.500 33.814 1996 0 0.0000000 0.0000000
6460 83.578 13284.440 64.438 1996 0 0.0000000 0.0000000
6732 140.998 14932.390 58.696 1996 0 0.0000000 0.0000000
6783 280.720 12305.110 103.356 1996 0 0.0000000 0.0000000
6953 67.628 14602.540 44.022 1996 0 0.0000000 0.0000000
7157 102.718 13116.640 24.882 1996 0 0.0000000 0.3041733
7191 158.224 11667.740 33.176 1996 0 0.0000000 0.0000000
7225 109.736 13083.470 16.588 1996 0 0.0000000 0.0000000
7276 49.126 15672.470 28.710 1996 1 0.2558330 0.0000000
7378 94.424 12023.110 21.054 1996 0 0.0000000 0.0000000
7395 111.650 12664.300 29.986 1996 0 0.0000000 0.0000000
7480 110.374 12329.350 38.918 1996 0 0.0000000 0.0000000
7548 72.732 13531.980 27.434 1996 0 0.0000000 0.0000000
7565 122.496 12973.090 25.520 1996 0 0.0000000 0.0000000
7701 72.094 11252.410 38.918 1996 1 0.3114974 0.0000000
7939 100.166 12264.270 25.520 1996 0 0.0000000 0.0000000
8228 155.034 9466.006 38.280 1996 0 0.0000000 0.0000000
8245 81.026 13604.070 27.434 1996 1 0.3243489 0.3243489
8313 74.646 15187.590 33.814 1996 0 0.0000000 0.0000000
8517 49.764 13879.050 28.710 1996 0 0.0000000 0.3348625
8789 207.350 12340.200 47.212 1996 0 0.0000000 0.0000000
9146 106.546 15341.990 32.538 1996 0 0.0000000 0.0000000
9690 165.880 13747.620 38.918 1996 0 0.0000000 0.0000000
10132 357.918 9985.338 23.606 1996 0 0.0000000 0.0000000
10302 542.938 9268.864 12.760 1996 1 0.2917068 0.2917068
10438 232.870 11172.660 12.122 1996 7 0.7975209 0.3417947
10455 234.146 11620.530 15.950 1996 0 0.0000000 0.7091864
10540 311.344 12540.530 20.416 1996 11 0.8710111 0.6334627
10574 492.536 10557.620 24.882 1996 12 1.4465670 2.2903980
10744 294.756 10528.280 28.072 1996 7 1.6397280 1.4054810
10897 164.604 15083.600 44.660 1996 2 0.6389164 0.3194582
11118 180.554 10747.110 14.674 1996 2 0.6851896 0.3425948
11356 239.250 9570.000 95.062 1996 1 0.4120992 1.2362980
11798 103.356 13136.420 56.144 1996 2 0.3763289 0.0000000
12155 187.572 11733.460 85.492 1996 1 0.2501376 0.2501376
12563 193.952 11792.790 107.822 1996 0 0.0000000 0.0000000
13005 149.930 12174.320 80.388 1996 2 0.3457994 0.1728997
13192 143.550 14222.930 45.936 1996 0 0.0000000 0.0000000
13379 218.834 12617.090 66.352 1996 1 0.1974958 0.0000000
13498 82.302 14984.070 48.488 1996 0 0.0000000 0.0000000
13804 82.302 14748.650 51.040 1996 0 0.0000000 0.0000000
13923 165.880 14928.560 33.176 1996 0 0.0000000 0.0000000
14297 118.030 12640.690 64.438 1996 3 0.2362391 0.2362391
14501 121.220 13466.900 47.212 1996 1 0.2065646 0.2065646
14654 343.244 10688.410 38.280 1996 2 0.8906702 0.8906702
14756 269.874 11663.280 18.502 1996 0 0.0000000 1.2608950
14773 162.690 10259.040 22.968 1996 0 0.0000000 0.8951216
14875 265.408 13345.680 15.950 1996 6 0.8788247 1.1717660
14943 285.824 9719.292 24.882 1996 0 0.0000000 0.0000000
15062 553.784 10539.760 52.954 1996 13 1.9662710 0.4537548
15215 161.414 12005.880 33.176 1996 0 0.0000000 0.2094197
15283 192.676 12219.610 37.642 1996 0 0.0000000 0.2719830
15368 183.106 10838.340 26.158 1996 0 0.0000000 0.0000000
16388 123.134 12465.240 19.140 1996 1 0.5397236 0.5397236
16473 101.442 13456.060 15.950 1996 0 0.0000000 0.0000000
18122 276.254 10053.600 22.330 1996 2 0.3321487 1.3285950
18275 233.508 11354.490 69.542 1996 2 0.3837225 0.1918613
19091 179.278 14576.390 83.578 1996 2 0.3252561 0.1626281
19159 137.808 10478.510 72.732 1996 0 0.0000000 0.2254436
19261 292.842 11389.580 87.406 1996 1 0.4203093 0.0000000
19533 376.420 11776.840 29.986 1996 1 0.7092702 0.0000000
19584 461.274 11705.390 47.212 1996 6 1.1544010 0.1924002
19924 482.966 10602.920 24.882 1996 2 0.8909876 2.2274690
20077 192.038 11336.620 65.714 1996 2 0.5255275 1.5765820
20094 203.522 12000.140 38.280 1996 0 0.0000000 0.7376263
20366 133.980 16133.740 17.226 1996 0 0.0000000 1.8488850
20842 86.130 15396.850 19.140 1996 1 0.0882278 0.0882278
21267 139.722 13696.580 40.832 1996 0 0.0000000 0.0000000
21352 111.650 14124.680 42.108 1996 0 0.0000000 0.2496318
21454 366.212 10516.790 70.180 1996 0 0.0000000 0.0000000
21505 241.164 10093.800 74.008 1996 3 0.7405761 0.7405761
21590 202.246 10439.590 56.144 1996 0 0.0000000 0.0000000
21692 107.184 11477.620 23.606 1996 0 0.0000000 0.2428128
21828 252.010 9129.142 66.352 1996 0 0.0000000 0.0000000
21845 404.492 9864.756 89.958 1996 0 0.0000000 0.0000000
22338 80.388 12403.360 16.588 1996 6 0.7199251 0.5999376
22508 169.708 9978.958 28.072 1996 3 0.4582321 0.7637202
23018 215.644 10243.730 21.054 1996 1 0.2734856 0.2734856
23137 302.412 9243.982 39.556 1996 4 1.0576130 0.0000000
23256 225.852 10498.930 24.882 1996 3 0.4863656 0.6484874
23307 96.976 11670.930 24.244 1996 3 0.4721732 0.4721733
23749 181.830 13659.580 112.288 1996 11 0.6523970 0.4151617
24242 222.662 11665.830 49.764 1996 0 0.0000000 0.0000000
24667 206.074 12338.280 135.894 1996 0 0.0000000 0.0000000
24803 213.730 12465.240 130.152 1996 3 0.2519251 0.1679501
25619 479.776 9766.504 52.954 1996 4 1.3525390 2.7050790
25704 250.734 12438.450 55.506 1996 9 1.7457080 2.3276110
25908 373.868 9655.492 47.212 1996 0 0.0000000 0.0000000
26078 199.056 10218.850 56.782 1996 2 0.6512749 0.0000000
26639 393.646 9922.814 86.130 1996 0 0.0000000 0.6350214
26673 208.626 10509.140 41.470 1996 1 0.2378234 0.4756469
26690 267.322 12715.340 55.506 1996 0 0.0000000 0.2762965
26809 257.114 10911.080 72.094 1996 3 0.5118318 0.3412212
26928 213.092 12254.070 48.488 1996 0 0.0000000 0.3362927
27030 382.162 10272.440 54.230 1996 8 3.3372270 0.4171534
27081 202.884 11173.930 85.492 1996 1 0.3477535 0.6955070
27115 232.870 9606.366 106.546 1996 1 0.5756058 0.5756058
27166 285.824 10100.180 88.682 1996 1 0.3003995 0.6007991
27455 202.884 8579.186 61.886 1996 0 0.0000000 0.0000000
27506 234.784 11903.170 49.764 1996 2 0.5624930 0.2812465
27557 171.622 11377.450 58.696 1996 0 0.0000000 0.0000000
27778 167.156 10988.910 29.348 1996 7 1.4951190 0.6407655
28067 248.182 9823.924 29.986 1996 1 0.3277184 0.0000000
29308 252.010 11086.530 52.954 1996 9 1.5079170 1.1728240
29393 172.898 11018.260 35.090 1996 4 0.6091618 0.6091618
29461 93.148 15520.630 32.538 1996 0 0.0000000 0.0000000
29954 221.386 10862.590 45.936 1996 4 0.6319714 1.1059500
30430 227.766 11070.580 35.728 1996 4 0.7075514 0.7075514
30583 96.338 12639.420 24.882 1996 4 0.5258107 0.3943581
31263 179.916 12270.020 45.298 1996 2 0.8029227 2.8102290
31348 196.504 10638.650 37.004 1996 2 0.5729182 0.8593773
31416 169.708 10869.610 22.330 1996 2 0.4697151 0.4697151
31433 211.816 14077.470 29.348 1996 2 0.2452754 0.1226377
32249 187.572 15442.790 21.692 1996 1 0.1811922 0.0000000
32385 124.410 13242.970 19.140 1996 5 0.8401243 0.5040746
32419 101.442 13376.310 14.674 1996 1 0.1895088 0.1895088
32555 223.938 10316.460 39.556 1996 0 0.0000000 0.0000000
32606 87.406 16085.890 12.760 1996 0 0.0000000 0.0000000
32640 144.826 13939.660 20.416 1996 4 1.2507430 0.9380570
32674 416.614 9303.954 79.750 1996 0 0.0000000 0.0000000
32742 89.320 19398.390 6.380 1996 0 0.0000000 0.0000000
32776 108.460 13184.270 12.122 1996 0 0.0000000 0.0000000
32793 135.894 11217.320 27.434 1996 3 0.6884840 0.4589893
32895 115.478 10853.020 23.606 1996 0 0.0000000 0.0000000
33014 167.794 13695.310 22.330 1996 2 0.7044486 0.7044486
33099 196.504 18479.670 71.456 1996 1 0.8758101 0.0000000
33286 89.958 14557.250 8.932 1996 1 0.8300822 0.8300822
33575 103.994 12663.660 15.950 1996 2 0.3203485 0.4805228
33592 324.742 9640.180 55.506 1996 0 0.0000000 0.0000000
33626 116.754 12715.340 31.900 1996 1 0.2975128 0.0000000
33796 214.368 11740.480 44.022 1996 4 2.4170640 0.6042661
33813 411.510 10874.710 69.542 1996 1 0.2532030 0.2532030
33830 216.282 11464.220 52.316 1996 2 0.7588117 1.5176230
34272 139.722 14261.850 131.428 1996 4 0.2977099 0.2232824
34697 107.184 20188.230 109.098 1996 0 0.0000000 0.0000000
34850 184.382 13287.630 106.546 1996 4 0.2622744 0.1967058
35054 360.470 9815.630 60.610 1996 1 0.2044655 0.2044655
35258 540.386 7758.718 66.990 1996 2 0.9029346 0.4514673
35275 410.872 10121.230 70.180 1996 0 0.0000000 0.0000000
35394 557.612 10142.920 74.646 1996 2 0.6063178 0.3031589
35513 219.472 11829.800 65.714 1996 1 1.3361840 0.0000000
35717 319.638 9007.284 81.026 1996 0 0.0000000 0.0000000
35768 308.154 11063.560 63.800 1996 0 0.0000000 1.0702050
35955 124.410 12535.420 82.940 1996 0 0.0000000 0.0000000
36176 76.560 13140.250 46.574 1996 0 0.0000000 0.0000000
36312 68.266 11877.010 82.302 1996 0 0.0000000 0.0000000
36584 91.872 12365.720 77.836 1996 0 0.0000000 0.0000000
36703 89.320 13370.570 79.112 1996 1 0.1917031 0.1917031
36958 108.460 15176.740 72.094 1996 1 0.1312009 0.5248035
statefips countyfips execs lpopul execrate statename statecode
34 1 3 0 11.720130 0.0000000 Alabama AL
68 1 9 0 10.678030 0.0000000 Alabama AL
170 1 21 0 10.472290 0.0000000 Alabama AL
238 1 31 0 10.643280 0.0000000 Alabama AL
340 1 43 0 11.201960 0.0000000 Alabama AL
357 1 45 0 10.802980 0.0000000 Alabama AL
918 1 115 0 10.988980 0.0000000 Alabama AL
986 1 123 0 10.591870 0.0000000 Alabama AL
1020 1 127 0 11.151750 0.0000000 Alabama AL
1224 5 5 0 10.501830 0.0000000 Arkansas AR
1258 5 9 0 10.370550 0.0000000 Arkansas AR
1462 5 33 0 10.801080 0.0000000 Arkansas AR
1479 5 35 0 10.811830 0.0000000 Arkansas AR
1649 5 55 0 10.464160 0.0000000 Arkansas AR
1955 5 91 0 10.570030 0.0000000 Arkansas AR
2567 6 17 0 11.929700 0.0000000 California CA
2669 6 29 0 13.341870 0.0000000 California CA
2686 6 31 0 11.638240 0.0000000 California CA
2822 6 47 1 12.166870 0.0519991 California CA
3026 6 71 0 14.284490 0.0000000 California CA
3332 6 107 0 12.765470 0.0000000 California CA
4148 8 101 0 11.784610 0.0000000 Colorado CO
5525 17 27 0 10.473560 0.0000000 Illinois IL
6069 17 95 0 10.931960 0.0000000 Illinois IL
6171 17 107 0 10.357710 0.0000000 Illinois IL
6256 17 117 0 10.799450 0.0000000 Illinois IL
6341 17 127 0 9.637959 0.0000000 Illinois IL
6392 17 133 0 10.140850 0.0000000 Illinois IL
6460 17 141 0 10.821920 0.0000000 Illinois IL
6732 17 177 0 10.802980 0.0000000 Illinois IL
6783 17 183 0 11.353460 0.0000000 Illinois IL
6953 17 203 0 10.457320 0.0000000 Illinois IL
7157 18 23 0 10.400500 0.0000000 Indiana IN
7191 18 27 0 10.266740 0.0000000 Indiana IN
7225 18 31 0 10.130820 0.0000000 Indiana IN
7276 18 37 0 10.573570 0.0000000 Indiana IN
7378 18 49 0 9.914576 0.0000000 Indiana IN
7395 18 51 0 10.375300 0.0000000 Indiana IN
7480 18 61 0 10.414780 0.0000000 Indiana IN
7548 18 69 0 10.519320 0.0000000 Indiana IN
7565 18 71 0 10.608240 0.0000000 Indiana IN
7701 18 87 0 10.376710 0.0000000 Indiana IN
7939 18 115 0 8.610683 0.0000000 Indiana IN
8228 18 149 0 10.060450 0.0000000 Indiana IN
8245 18 151 0 10.336280 0.0000000 Indiana IN
8313 18 159 0 9.708263 0.0000000 Indiana IN
8517 18 183 0 10.304380 0.0000000 Indiana IN
8789 20 37 0 10.500590 0.0000000 Kansas KS
9146 20 79 0 10.351440 0.0000000 Kansas KS
9690 20 155 0 11.049320 0.0000000 Kansas KS
10132 22 1 0 10.961100 0.0000000 Louisiana LA
10302 22 39 0 10.442350 0.0000000 Louisiana LA
10438 22 57 0 11.382500 0.0000000 Louisiana LA
10455 22 61 0 10.652590 0.0000000 Louisiana LA
10540 22 79 0 11.746340 0.0000000 Louisiana LA
10574 22 97 0 11.326050 0.0000000 Louisiana LA
10744 22 119 0 10.661720 0.0000000 Louisiana LA
10897 23 15 0 10.351470 0.0000000 Maine ME
11118 24 11 0 10.281550 0.0000000 Maryland MD
11356 24 39 0 10.096830 0.0000000 Maryland MD
11798 26 15 0 10.880780 0.0000000 Michigan MI
12155 26 57 0 10.596080 0.0000000 Michigan MI
12563 26 105 0 10.230090 0.0000000 Michigan MI
13005 26 157 0 10.965380 0.0000000 Michigan MI
13192 27 13 0 10.900420 0.0000000 Minnesota MN
13379 27 35 0 10.832380 0.0000000 Minnesota MN
13498 27 49 0 10.654100 0.0000000 Minnesota MN
13804 27 85 0 10.423350 0.0000000 Minnesota MN
13923 27 99 0 10.522750 0.0000000 Minnesota MN
14297 27 145 0 11.751860 0.0000000 Minnesota MN
14501 27 169 0 10.787480 0.0000000 Minnesota MN
14654 28 43 0 10.019270 0.0000000 Mississippi MS
14756 28 67 0 11.057960 0.0000000 Mississippi MS
14773 28 71 0 10.419750 0.0000000 Mississippi MS
14875 28 89 0 11.131270 0.0000000 Mississippi MS
14943 28 105 0 10.579060 0.0000000 Mississippi MS
15062 28 151 0 11.099150 0.0000000 Mississippi MS
15215 29 145 0 10.773760 0.0000000 Missouri MO
15283 29 159 0 10.512360 0.0000000 Missouri MO
15368 29 169 0 10.443890 0.0000000 Missouri MO
16388 31 43 0 9.827039 0.0000000 Nebraska NE
16473 31 53 0 10.463730 0.0000000 Nebraska NE
18122 35 61 0 11.005660 0.0000000 New Mexico NM
18275 36 17 0 10.861320 0.0000000 New York NY
19091 36 113 0 11.026630 0.0000000 New York NY
19159 36 121 0 10.700030 0.0000000 New York NY
19261 37 9 0 10.077100 0.0000000 North Carolina NC
19533 37 41 0 9.553859 0.0000000 North Carolina NC
19584 37 47 0 10.858520 0.0000000 North Carolina NC
19924 37 91 0 10.018910 0.0000000 North Carolina NC
20077 37 111 0 10.546840 0.0000000 North Carolina NC
20094 37 113 0 10.207810 0.0000000 North Carolina NC
20366 37 149 0 9.694370 0.0000000 North Carolina NC
20842 38 17 0 11.638170 0.0000000 North Dakota ND
21267 39 27 0 10.562170 0.0000000 Ohio OH
21352 39 39 0 10.598110 0.0000000 Ohio OH
21454 39 53 0 10.398790 0.0000000 Ohio OH
21505 39 59 0 10.609280 0.0000000 Ohio OH
21590 39 73 0 10.254600 0.0000000 Ohio OH
21692 39 97 0 10.625800 0.0000000 Ohio OH
21828 39 127 0 10.429220 0.0000000 Ohio OH
21845 39 131 0 10.209350 0.0000000 Ohio OH
22338 40 17 1 11.330710 0.1199875 Oklahoma OK
22508 40 37 0 11.089330 0.0000000 Oklahoma OK
23018 40 97 0 10.506850 0.0000000 Oklahoma OK
23137 40 111 0 10.540620 0.0000000 Oklahoma OK
23256 40 125 0 11.029750 0.0000000 Oklahoma OK
23307 40 131 0 11.059360 0.0000000 Oklahoma OK
23749 41 29 0 12.035340 0.0000000 Oregon OR
24242 42 15 0 11.040550 0.0000000 Pennsylvania PA
24667 42 65 0 10.749870 0.0000000 Pennsylvania PA
24803 42 81 0 11.687580 0.0000000 Pennsylvania PA
25619 45 33 0 10.294650 0.0000000 South Carolina SC
25704 45 43 0 10.850400 0.0000000 South Carolina SC
25908 45 67 0 10.460100 0.0000000 South Carolina SC
26078 45 87 0 10.332310 0.0000000 South Carolina SC
26639 47 29 0 10.357580 0.0000000 Tennessee TN
26673 47 35 0 10.646570 0.0000000 Tennessee TN
26690 47 45 0 10.496620 0.0000000 Tennessee TN
26809 47 59 0 10.978710 0.0000000 Tennessee TN
26928 47 79 0 10.300110 0.0000000 Tennessee TN
27030 47 97 0 10.084640 0.0000000 Tennessee TN
27081 47 103 0 10.266600 0.0000000 Tennessee TN
27115 47 111 0 9.762672 0.0000000 Tennessee TN
27166 47 123 0 10.412980 0.0000000 Tennessee TN
27455 47 169 0 8.793005 0.0000000 Tennessee TN
27506 47 177 0 10.478860 0.0000000 Tennessee TN
27557 47 183 0 10.391090 0.0000000 Tennessee TN
27778 48 21 0 10.754040 0.0000000 Texas TX
28067 48 55 0 10.325940 0.0000000 Texas TX
29308 48 203 0 10.996840 0.0000000 Texas TX
29393 48 213 0 11.092310 0.0000000 Texas TX
29461 48 221 0 10.462420 0.0000000 Texas TX
29954 48 291 0 11.055550 0.0000000 Texas TX
30430 48 347 0 10.942580 0.0000000 Texas TX
30583 48 367 0 11.239450 0.0000000 Texas TX
31263 48 449 0 10.122980 0.0000000 Texas TX
31348 48 459 0 10.460500 0.0000000 Texas TX
31416 48 467 0 10.659120 0.0000000 Texas TX
31433 48 469 0 11.308860 0.0000000 Texas TX
32249 50 27 0 10.918540 0.0000000 Vermont VT
32385 51 15 0 10.993980 0.0000000 Virginia VA
32419 51 19 1 10.873660 0.1895088 Virginia VA
32555 51 35 0 10.229300 0.0000000 Virginia VA
32606 51 43 0 9.436918 0.0000000 Virginia VA
32640 51 47 0 10.372900 0.0000000 Virginia VA
32674 51 51 0 9.763133 0.0000000 Virginia VA
32742 51 61 0 10.854470 0.0000000 Virginia VA
32776 51 65 0 9.734300 0.0000000 Virginia VA
32793 51 67 1 10.682220 0.2294946 Virginia VA
32895 51 79 0 9.470549 0.0000000 Virginia VA
33014 51 93 0 10.253830 0.0000000 Virginia VA
33099 51 103 0 9.342946 0.0000000 Virginia VA
33286 51 127 0 9.396571 0.0000000 Virginia VA
33575 51 165 0 11.041830 0.0000000 Virginia VA
33592 51 167 0 10.279660 0.0000000 Virginia VA
33626 51 171 0 10.422640 0.0000000 Virginia VA
33796 51 193 0 9.714081 0.0000000 Virginia VA
33813 51 195 0 10.583900 0.0000000 Virginia VA
33830 51 197 0 10.179490 0.0000000 Virginia VA
34272 53 5 0 11.808270 0.0000000 Washington WA
34697 53 55 0 9.397733 0.0000000 Washington WA
34850 53 73 0 11.935000 0.0000000 Washington WA
35054 54 19 0 10.797700 0.0000000 West Virginia WV
35258 54 43 0 10.005590 0.0000000 West Virginia WV
35275 54 45 0 10.641580 0.0000000 West Virginia WV
35394 54 59 0 10.403840 0.0000000 West Virginia WV
35513 54 73 0 8.920523 0.0000000 West Virginia WV
35717 54 97 0 10.070700 0.0000000 West Virginia WV
35768 54 103 0 9.835637 0.0000000 West Virginia WV
35955 55 17 0 10.903160 0.0000000 Wisconsin WI
36176 55 45 0 10.396810 0.0000000 Wisconsin WI
36312 55 61 0 9.886393 0.0000000 Wisconsin WI
36584 55 97 0 11.084390 0.0000000 Wisconsin WI
36703 55 111 0 10.862150 0.0000000 Wisconsin WI
36958 55 141 0 11.241370 0.0000000 Wisconsin WI
region fit lwr upr
34 South 6.501271 -30.36444 43.36698
68 South 6.523884 -30.34120 43.38897
170 South 6.569110 -30.29500 43.43322
238 South 6.606798 -30.25676 43.47036
340 South 6.652024 -30.21120 43.51525
357 South 6.659561 -30.20365 43.52277
918 South 6.923377 -29.94527 43.79203
986 South 6.953528 -29.91651 43.82356
1020 South 6.968603 -29.90219 43.83939
1224 South 6.298254 -30.55427 43.15078
1258 South 6.313330 -30.53872 43.16538
1462 South 6.403781 -30.44628 43.25384
1479 South 6.411319 -30.43864 43.26128
1649 South 6.486695 -30.36278 43.33617
1955 South 6.622372 -30.22871 43.47345
2567 West 6.290841 -30.55741 43.13909
2669 West 6.336067 -30.51120 43.18333
2686 West 6.343605 -30.50353 43.19074
2822 West 6.403906 -30.44254 43.25035
3026 West 6.494357 -30.35224 43.34095
3332 West 6.630034 -30.21943 43.47950
4148 West 6.502144 -30.34035 43.34464
5525 Midwest 5.749504 -31.07275 42.57176
6069 Midwest 6.005783 -30.81421 42.82578
6171 Midwest 6.051009 -30.76977 42.87179
6256 Midwest 6.088697 -30.73300 42.91040
6341 Midwest 6.126385 -30.69648 42.94925
6392 Midwest 6.148997 -30.67468 42.97268
6460 Midwest 6.179148 -30.64576 43.00406
6732 Midwest 6.314825 -30.51755 43.14720
6783 Midwest 6.337438 -30.49649 43.17137
6953 Midwest 6.412814 -30.42693 43.25256
7157 Midwest 5.681790 -31.13941 42.50300
7191 Midwest 5.696866 -31.12384 42.51757
7225 Midwest 5.711941 -31.10830 42.53218
7276 Midwest 5.734554 -31.08507 42.55417
7378 Midwest 5.779779 -31.03886 42.59842
7395 Midwest 5.787317 -31.03120 42.60583
7480 Midwest 5.825005 -30.99301 42.64302
7548 Midwest 5.855155 -30.96265 42.67296
7565 Midwest 5.862693 -30.95508 42.68046
7701 Midwest 5.922994 -30.89489 42.74088
7939 Midwest 6.028520 -30.79107 42.84811
8228 Midwest 6.156660 -30.66760 42.98092
8245 Midwest 6.164197 -30.66042 42.98882
8313 Midwest 6.194348 -30.63182 43.02051
8517 Midwest 6.284799 -30.54696 43.11656
8789 Midwest 5.629276 -31.18753 42.44609
9146 Midwest 5.787566 -31.02704 42.60217
9690 Midwest 6.073995 -30.74762 42.89561
10132 South 5.388322 -31.43180 42.20845
10302 South 5.531537 -31.28274 42.34581
10438 South 5.599375 -31.21337 42.41212
10455 South 5.614450 -31.19806 42.42696
10540 South 5.682289 -31.12966 42.49424
10574 South 5.750127 -31.06206 42.56231
10744 South 5.833041 -30.98051 42.64659
10897 Northeast 5.388447 -31.42823 42.20512
11118 South 5.320733 -31.49590 42.13736
11356 South 5.426259 -31.38618 42.23870
11798 Midwest 5.230531 -31.58423 42.04529
12155 Midwest 5.388821 -31.42045 42.19809
12563 Midwest 5.569723 -31.23857 42.37802
13005 Midwest 5.765701 -31.04793 42.57933
13192 Midwest 5.170355 -31.64439 41.98510
13379 Midwest 5.253268 -31.55786 42.06440
13498 Midwest 5.306031 -31.50342 42.11548
13804 Midwest 5.441708 -31.36563 42.24905
13923 Midwest 5.494472 -31.31291 42.30185
14297 Midwest 5.667837 -31.14306 42.47873
14501 Midwest 5.758288 -31.05650 42.57308
14654 South 5.230780 -31.57895 42.04051
14756 South 5.321231 -31.48629 42.12875
14773 South 5.336306 -31.47098 42.14359
14875 South 5.404145 -31.40259 42.21088
14943 South 5.464446 -31.34247 42.27136
15062 South 5.637811 -31.17311 42.44873
15215 Midwest 5.562559 -31.24687 42.37199
15283 Midwest 5.615322 -31.19610 42.42674
15368 Midwest 5.653011 -31.16013 42.46615
16388 Midwest 5.072864 -31.73646 41.88219
16473 Midwest 5.110552 -31.69756 41.91866
18122 West 4.930148 -31.87807 41.73836
18275 Northeast 4.711682 -32.10426 41.52763
19091 Northeast 5.073487 -31.73288 41.87985
19159 Northeast 5.103637 -31.70295 41.91023
19261 South 4.628893 -32.18974 41.44752
19533 South 4.749494 -32.06267 41.56166
19584 South 4.772107 -32.03912 41.58334
19924 South 4.937935 -31.86916 41.74503
20077 South 5.013311 -31.79348 41.82010
20094 South 5.020848 -31.78596 41.82766
20366 South 5.156525 -31.65239 41.96544
20842 Midwest 4.606405 -32.21133 41.42414
21267 Midwest 4.591454 -32.22518 41.40809
21352 Midwest 4.636680 -32.17767 41.45103
21454 Midwest 4.689443 -32.12269 41.50157
21505 Midwest 4.712056 -32.09927 41.52338
21590 Midwest 4.764819 -32.04498 41.57461
21692 Midwest 4.855270 -31.95302 41.66356
21828 Midwest 4.968334 -31.84006 41.77673
21845 Midwest 4.983409 -31.82517 41.79199
22338 South 4.501127 -32.31888 41.32114
22508 South 4.576503 -32.23932 41.39233
23018 South 4.802631 -32.00654 41.61180
23137 South 4.855395 -31.95349 41.66428
23256 South 4.908158 -31.90093 41.71725
23307 South 4.930771 -31.87855 41.74009
23749 West 4.493714 -32.32494 41.31237
24242 Northeast 4.388312 -32.43496 41.21158
24667 Northeast 4.576752 -32.23725 41.39076
24803 Northeast 4.637053 -32.17529 41.44939
25619 South 4.298235 -32.52588 41.12235
25704 South 4.335923 -32.48617 41.15802
25908 South 4.426374 -32.39187 41.24462
26078 South 4.501750 -32.31436 41.31786
26639 South 4.177882 -32.65102 41.00678
26673 South 4.200495 -32.62706 41.02805
26690 South 4.238183 -32.58731 41.06368
26809 South 4.290946 -32.53209 41.11398
26928 South 4.366322 -32.45403 41.18667
27030 South 4.434161 -32.38462 41.25294
27081 South 4.456774 -32.36165 41.27520
27115 South 4.486924 -32.33118 41.30503
27166 South 4.532150 -32.28576 41.35006
27455 South 4.705515 -32.11492 41.52595
27506 South 4.735665 -32.08573 41.55707
27557 South 4.758278 -32.06395 41.58051
27778 South 4.095093 -32.73791 40.92810
28067 South 4.223233 -32.60249 41.04896
29308 South 4.781015 -32.04606 41.60809
29393 South 4.818703 -32.01040 41.64781
29461 South 4.848854 -31.98205 41.67976
29954 South 5.112670 -31.74069 41.96603
30430 South 5.323723 -31.55624 42.20369
30583 South 5.399099 -31.49222 42.29042
31263 South 5.708141 -31.23995 42.65623
31348 South 5.745829 -31.21031 42.70197
31416 South 5.775979 -31.18677 42.73873
31433 South 5.783517 -31.18090 42.74794
32249 Northeast 4.012429 -32.82375 40.84861
32385 South 3.914564 -32.92734 40.75647
32419 South 3.929640 -32.91116 40.77044
32555 South 3.989940 -32.84680 40.82668
32606 South 4.020091 -32.81486 40.85504
32640 South 4.035166 -32.79895 40.86928
32674 South 4.050241 -32.78308 40.88356
32742 South 4.087929 -32.74357 40.91943
32776 South 4.103005 -32.72783 40.93384
32793 South 4.110542 -32.71998 40.94107
32895 South 4.155768 -32.67307 40.98461
33014 South 4.208531 -32.61879 41.03585
33099 South 4.246219 -32.58031 41.07275
33286 South 4.336670 -32.48896 41.16230
33575 South 4.479885 -32.34722 41.30699
33592 South 4.487423 -32.33986 41.31471
33626 South 4.502498 -32.32517 41.33016
33796 South 4.585411 -32.24505 41.41587
33813 South 4.592949 -32.23783 41.42372
33830 South 4.600487 -32.23061 41.43159
34272 West 3.771599 -33.07883 40.62203
34697 West 3.960039 -32.87770 40.79777
34850 West 4.027878 -32.80679 40.86254
35054 South 3.771724 -33.07745 40.62090
35258 South 3.862175 -32.98087 40.70522
35275 South 3.869713 -32.97288 40.71231
35394 South 3.922476 -32.91726 40.76221
35513 South 3.975239 -32.86213 40.81260
35717 South 4.065690 -32.76872 40.90010
35768 South 4.088303 -32.74559 40.92220
35955 Midwest 3.711547 -33.14125 40.56434
36176 Midwest 3.817074 -33.02845 40.66260
36312 Midwest 3.877375 -32.96487 40.71962
36584 Midwest 4.013052 -32.82409 40.85019
36703 Midwest 4.065815 -32.77020 40.90183
36958 Midwest 4.178879 -32.65634 41.01410
# Filter by a categorical variable
subset(test_w_predict, region == "South") arrests countyid density popul perc1019 perc2029 percblack
34 6 1003 77.0564300 123023 13.938860 11.639290 13.4966600
51 1 1005 29.9154800 26475 15.063270 13.699720 46.1907500
68 0 1009 67.2045700 43392 14.175420 12.993180 1.4150070
119 20 1015 186.5397000 113511 14.711350 14.289360 19.0968300
153 2 1019 38.2702400 21170 14.133210 12.130370 7.0429850
170 0 1021 50.8929100 35323 14.803390 12.643320 11.9214100
221 2 1029 24.0002000 13445 14.280400 13.328370 4.9237630
238 8 1031 61.7061800 41910 14.323550 13.777140 18.1818200
323 1 1041 22.1678800 13514 14.762470 11.772980 27.1570200
340 5 1043 99.2227300 73274 13.828920 12.776700 0.8898109
357 1 1045 87.6230300 49167 14.249400 18.331400 18.7564800
459 2 1057 28.5817300 17944 14.812750 11.808960 12.8288000
476 1 1059 46.0182800 29253 13.629370 12.367960 4.7550680
544 1 1067 27.1054600 15232 15.191700 12.073270 36.5677500
595 98 1073 594.8950000 661927 13.015180 14.360950 36.5274400
629 1 1079 47.6418500 33037 15.173900 14.995310 16.3725500
646 11 1081 156.1096000 95038 16.370290 24.673290 25.1204800
680 4 1085 17.8425600 12811 18.772930 14.620250 75.4898100
748 2 1093 41.4287300 30718 13.695550 12.904490 3.5223650
782 4 1099 23.2697400 23874 17.010140 13.035100 40.4205400
816 8 1103 183.6714000 106942 13.739220 13.637300 10.6338000
850 1 1107 23.6698500 20864 15.231980 12.068630 42.9016500
918 7 1115 93.4055300 59218 14.206830 13.468880 9.7132630
952 3 1119 17.8720700 16174 19.240760 15.357980 71.3552600
986 6 1123 55.4425900 39810 14.601860 12.466720 27.4880700
1020 4 1127 87.7157200 69686 14.424710 12.579280 6.8693860
1037 3 1131 15.2067100 13515 19.067700 12.489830 69.8557100
1207 3 5003 26.6378800 24543 16.538320 12.349750 29.4462800
1224 1 5005 65.6220700 36382 11.049420 8.221098 0.0192403
1258 3 5009 53.9662400 31906 14.313920 11.718800 0.0156710
1377 2 5023 40.5845000 22447 12.429280 10.157260 0.0311846
1428 7 5029 35.7502100 19885 15.423690 11.928590 16.4697000
1462 3 5033 82.4082900 49074 16.275420 12.473000 0.9944166
1479 13 5035 81.2517200 49604 17.488510 14.424240 45.5931000
1496 5 5037 31.4388200 19363 17.445640 12.518720 27.2013600
1513 0 5039 13.9856700 9335 15.275840 11.312270 41.1140900
1530 0 5041 20.2774500 15513 17.623930 12.447620 45.1298900
1649 0 5055 60.6645200 35037 14.655940 12.509630 0.0684990
1802 1 5073 17.5313600 9231 16.607080 11.851370 41.2631300
1819 0 5075 29.7232000 17436 14.556090 11.694200 0.5849966
1836 5 5077 21.2764600 12802 19.793780 13.099520 60.8420600
1887 1 5083 29.8456400 21188 15.617330 11.393240 1.5055690
1921 0 5087 15.6448000 13094 14.762490 10.691920 0.0305483
1938 1 5089 23.9202500 14298 12.687090 8.616590 0.0419639
1955 5 5091 62.4125900 38950 16.192550 13.278560 24.5237500
2057 2 5105 16.9014500 9312 14.980670 11.597940 1.5356530
2091 0 5109 17.3863900 10485 15.097760 11.206490 4.1010970
2108 3 5111 32.6210700 24720 14.971680 12.419090 7.9085760
2329 2 5139 44.3083200 46036 15.009990 12.203490 32.5071700
2346 0 5141 21.5373700 15325 13.579120 8.502447 0.3262643
2414 1 5149 20.4764700 19000 14.336840 12.642110 2.3421050
4505 23 10003 1105.8380000 471417 13.047900 15.189100 18.3936900
4522 3 10005 139.9030000 131181 12.284550 11.563410 18.5072500
10132 0 22001 87.8816700 57590 17.325920 12.594200 19.7638500
10183 14 22009 48.5682800 40433 15.836070 12.791530 29.5427000
10200 0 22011 27.3849300 31771 16.483590 13.329770 16.0523700
10268 1 22029 29.9463100 20854 17.521820 11.633260 38.5010100
10302 1 22039 51.6036100 34281 17.216530 12.432540 28.0184400
10336 4 22045 124.6312000 71685 17.468090 13.532820 31.6216800
10370 1 22049 27.1805700 15492 16.660210 11.360700 31.0999200
10438 3 22057 80.9097300 87772 16.918830 15.572160 13.5669700
10455 3 22061 89.7362500 42302 20.351280 21.956410 41.6528800
10523 1 22075 30.6022300 25848 17.231510 14.790310 24.8994100
10540 8 22079 95.4813900 126290 16.203980 13.687540 29.8954800
10557 1 22089 165.8019000 47031 16.000090 13.716490 26.1933600
10574 19 22097 89.3238200 82955 17.440780 12.323550 42.7581200
10625 17 22103 208.8875000 178483 16.348340 10.995450 12.0168300
10693 4 22113 43.7009900 51299 16.386280 12.522660 15.0061400
10744 6 22119 71.6361000 42690 15.497780 11.405480 33.5699200
11118 1 24011 91.1719700 29189 13.943610 10.545070 20.1788300
11152 1 24015 228.2696000 79475 15.604910 11.323060 5.3954070
11220 0 24023 45.4297300 29445 15.802340 10.215660 0.3803702
11356 3 24039 74.1568500 24266 14.308090 16.685900 44.3789700
11390 1 24043 277.8024000 127278 12.725690 13.259950 7.1402750
14569 1 28021 23.6660800 11521 23.730580 18.297020 82.4494400
14586 3 28023 25.8346100 17860 15.951850 12.889140 36.1198200
14654 2 28043 53.2218100 22455 15.885100 13.422400 43.1574200
14688 27 28047 303.9696000 176613 14.675590 16.545780 20.6870400
14705 2 28057 39.5882300 21076 15.306510 13.403870 7.3116340
14756 8 28067 91.4377900 63447 15.564170 12.736620 26.3022700
14773 3 28071 53.1013100 33515 17.138600 25.138000 27.1192000
14807 8 28075 109.4244000 76987 15.368830 14.760930 36.4672000
14824 2 28081 163.1372000 73357 14.503050 14.955630 22.8553500
14858 9 28087 121.8440000 61203 15.708380 17.391300 38.9931900
14875 8 28089 94.9375800 68273 15.137760 17.534020 46.1426900
14892 3 28095 49.6212200 37922 15.748110 13.337900 31.9629800
14943 0 28105 85.8601600 39303 17.711120 26.102330 36.3712700
14977 7 28121 132.2153000 102414 15.142460 13.993200 17.8715800
14994 3 28123 41.3604800 25194 16.321350 13.836630 39.7753400
15011 0 28127 42.8363800 25221 16.264230 13.242930 34.0509900
15062 3 28151 91.3148200 66115 18.215230 13.857670 59.3465900
15079 4 28153 24.6834500 20003 16.672500 13.687950 37.4593800
19244 5 37007 45.7179500 24302 14.776560 12.994810 48.7696500
19261 0 37009 55.8290200 23792 12.739580 10.886010 0.6851043
19329 12 37017 34.6666800 30330 15.341250 11.078140 39.6999700
19431 0 37029 27.1017800 6523 13.429400 11.206500 25.4944000
19482 10 37035 322.8379000 129104 13.567360 13.270700 9.2042070
19533 0 37041 81.6693600 14099 13.440670 10.277320 38.2509400
19550 0 37043 37.8810800 8132 14.080180 8.349730 1.0452530
19567 16 37045 196.8206000 91381 13.984310 12.928290 21.3173400
19584 1 37047 55.4885600 51975 15.290040 11.490140 31.2092400
19618 20 37051 436.0816000 284800 14.898170 20.402040 31.9336400
19737 36 37067 693.7758000 284207 12.446560 14.636160 25.3069100
19907 0 37089 208.4840000 77940 11.404930 9.807545 3.4462410
19924 5 37091 63.4691400 22447 15.369540 11.418010 58.1770400
19958 1 37095 8.8340700 5413 15.388880 10.844260 33.4195400
20009 13 37101 124.1192000 98289 13.519320 13.195780 18.3967700
20026 2 37105 184.5868000 47483 13.630140 12.311780 23.1682900
20077 6 37111 86.1605100 38057 14.021070 11.866410 4.2304960
20094 2 37113 52.5048700 27114 11.016450 8.807259 1.5379510
20128 43 37119 1133.0570000 597589 12.621550 16.104880 26.6126000
20179 17 37127 162.8706000 87991 14.248050 13.062700 32.0578200
20247 7 37135 272.1845000 108795 14.510780 23.434900 16.3518500
20315 0 37143 44.1549200 10913 12.709610 10.189680 33.2722400
20366 3 37149 68.2368000 16226 10.372240 9.145815 7.4263530
20383 13 37151 149.1583000 117455 13.136950 13.112260 6.1930100
20417 14 37155 119.2707000 113169 17.267980 13.906640 24.5535400
20434 7 37157 158.1454000 89575 13.222440 12.149600 20.7435100
20468 5 37161 105.8563000 59723 13.706610 12.203000 11.6571500
20502 5 37165 110.9286000 35404 17.526270 12.430800 36.4083100
20570 1 37173 22.7386000 12008 14.482010 11.675550 1.4323780
20621 12 37179 160.6200000 102372 14.967960 13.330790 16.2134200
20655 34 37183 640.5438000 534075 12.860180 17.883440 21.0573400
20706 2 37189 129.1424000 40357 16.807490 22.558660 2.1879720
22219 0 40003 7.1024500 6155 12.445170 11.535340 3.5743300
22236 3 40005 13.5454900 13250 16.188680 12.075470 6.1433960
22253 0 40007 3.3142520 6013 16.530850 9.263263 0.1330451
22287 0 40011 11.5747700 10748 15.156310 10.439150 4.7264610
22321 11 40015 23.9858600 30663 16.179110 12.203630 3.0753680
22338 5 40017 92.6220900 83342 17.167810 11.554800 2.5545340
22389 1 40023 19.7044100 15250 16.504920 10.452460 13.2459000
22423 4 40027 363.1540000 194687 16.748420 18.052050 3.0592690
22440 0 40029 11.8901700 6162 16.812720 10.305100 0.8438818
22457 7 40031 103.9657000 111171 16.219160 17.988500 17.8508800
22474 0 40033 10.8044900 6879 14.929500 11.048120 2.2532340
22508 5 40037 68.5248300 65469 16.369580 11.356520 3.2946890
22678 0 40057 6.6785930 3592 16.230510 9.409800 8.8530060
22695 0 40059 3.6390900 3781 15.234070 7.590584 0.0793441
22763 0 40067 8.8615490 6724 15.110050 10.113030 0.6543724
22831 0 40075 10.7019800 10859 14.872460 10.139060 5.5622060
22882 2 40081 32.2850200 30945 16.606880 10.550980 2.8340600
22899 1 40083 41.5528100 30940 18.891400 14.124110 17.1008400
22916 0 40085 16.7595700 8637 15.572540 11.682300 4.3880980
22950 4 40089 18.7644100 34754 17.267080 12.024520 10.6779100
23018 1 40097 55.7242400 36565 15.665250 11.122660 0.2105839
23035 1 40099 29.6478200 12400 15.096770 9.870968 1.7983870
23103 1 40107 18.1812200 11358 15.451660 11.260790 12.1676300
23137 0 40111 54.2619500 37821 15.713490 10.779730 12.6173300
23256 4 40125 78.2927600 61682 17.316230 12.921110 2.3377970
23273 0 40127 8.2917210 11586 14.828240 10.098390 1.0184710
23307 3 40131 94.1408700 63536 16.551250 11.173190 0.8750944
23324 0 40133 39.4666700 24960 15.725160 10.853360 7.9126600
23358 2 40137 49.4123900 43336 15.335980 9.820934 2.3490860
23375 0 40139 8.5034070 17322 17.128510 12.440830 0.3694724
23409 35 40143 932.1826000 531596 14.284160 14.376330 10.2305100
23443 0 40147 113.7801000 47423 14.450790 9.915020 2.7560470
23494 3 40153 15.0264300 18667 16.135430 11.930140 0.8839128
25364 7 45003 124.0758000 133130 14.123040 13.386920 24.9049800
25398 20 45007 218.0614000 156558 13.725900 12.516130 17.1929900
25483 1 45017 36.0864600 13724 14.456430 12.547360 52.1130900
25517 6 45021 122.2495000 48003 14.590750 13.240840 21.1799300
25602 5 45031 116.2324000 65319 16.275510 12.437420 40.8977500
25619 8 45033 73.0535600 29574 17.251640 12.818690 44.2889000
25653 1 45037 37.9627500 19051 14.707890 12.844470 47.2626100
25670 5 45039 32.4915400 22305 16.225060 13.113650 58.8836600
25687 19 45041 154.3925000 123365 15.744340 13.316580 39.6246900
25704 12 45043 63.2831500 51555 15.965470 11.760260 43.8851700
25823 8 45057 104.1356000 57164 14.414670 12.847250 25.9569000
25874 10 45063 279.1292000 195606 13.868700 13.866650 11.3503700
25891 2 45065 26.2323600 9432 15.065730 16.433420 59.8282400
25908 0 45067 71.3464000 34895 17.383580 11.669290 55.2486000
26027 1 45081 37.3168300 16843 14.088940 12.444340 33.8360100
26044 21 45083 299.6531000 242962 13.499640 13.916990 21.2815200
26061 15 45085 161.0368000 107161 14.584600 17.537160 44.6001800
26078 0 45087 59.7231500 30709 13.999150 12.341660 30.6848200
26112 5 45091 215.8136000 147299 14.224130 14.856180 20.6763100
26469 4 47001 212.1096000 71587 13.125290 11.433640 4.3806830
26605 3 47021 109.6135000 33175 14.453660 13.380560 2.1371510
26639 2 47029 72.5084900 31495 14.227660 12.846480 2.2765520
26673 2 47035 61.6934200 42048 13.175420 11.617670 0.1022641
26690 1 47045 70.8942100 36193 14.099410 12.762140 12.6930600
26707 2 47047 40.1810200 28309 16.485920 11.974990 45.7769600
26809 2 47059 94.2612100 58613 13.425350 12.579120 2.3527200
26877 2 47071 42.5094000 24566 14.231050 11.560690 4.7301150
26911 1 47077 45.0997500 23451 13.995140 12.251080 8.9718990
26928 1 47079 52.9412200 29736 12.836290 10.593220 10.7176500
26979 1 47085 31.3298900 16675 14.140930 10.914540 3.7001500
26996 2 47089 147.0744000 40268 14.371210 13.685810 3.0495680
27013 35 47093 717.0883000 364566 12.822920 15.426840 9.4007670
27030 1 47097 50.9540300 23972 14.696310 13.711830 32.7590500
27081 2 47103 50.4252100 28756 13.503270 12.101820 9.1980800
27115 1 47111 56.5632600 17373 13.733960 13.146840 0.2647787
27166 2 47123 52.4045000 33289 15.140140 12.448560 2.8928480
27183 10 47125 224.3084000 120923 13.777360 19.878770 18.5862100
27302 2 47145 138.1306000 49859 13.837020 10.812490 3.3153490
27353 4 47155 103.5578000 61335 13.499630 12.627370 0.4418358
27370 116 47157 1149.1510000 867409 14.650990 15.020020 45.3423900
27387 1 47159 49.8138700 15663 13.100940 12.564640 3.4220770
27421 4 47163 362.7913000 149844 12.961480 12.178670 1.9313420
27455 0 47169 57.6693500 6588 13.509410 11.672740 15.2398300
27506 1 47177 82.1865600 35556 14.034200 12.574530 3.7012040
27523 9 47179 307.3666000 100265 13.198020 14.729970 3.7919510
27557 0 47183 56.1311700 32568 15.241950 16.095550 7.3507740
27608 2 48001 48.7220700 52174 13.464560 19.124470 25.7273700
27676 0 48009 9.0660990 8247 15.739060 9.530739 0.1940099
27778 3 48021 52.6993500 46819 14.917020 10.636710 12.4415300
27795 0 48023 4.7699650 4153 10.907780 8.596195 4.2138210
27812 3 48025 31.6242500 27833 14.913950 17.533140 3.1401570
27846 81 48029 1057.2700000 1318322 15.600210 14.845770 7.0617040
27880 0 48033 0.8978221 807 13.754650 8.550186 0.4956630
27931 7 48039 159.2461000 220854 16.008770 13.002250 8.9384840
27965 0 48043 1.4891130 9221 14.792320 15.963560 1.0085670
27982 0 48045 2.1295430 1917 15.336460 6.781429 3.7558680
28016 1 48049 38.9331700 36746 15.778590 11.242040 4.9447560
28033 1 48051 22.9708000 15288 14.455780 10.112510 18.8186800
28050 0 48053 29.8972900 29753 13.487720 8.775585 2.0166030
28067 0 48055 55.9117500 30514 17.631250 13.328310 11.3226700
28084 3 48057 40.4231300 20711 15.875620 11.665300 2.9163250
28101 0 48059 13.9988000 12580 14.165340 8.394277 0.0158983
28118 10 48061 347.9270000 315015 19.700330 13.170480 0.3968065
28152 0 48065 7.2727980 6714 16.904970 7.730116 0.1787310
28186 0 48069 9.5016770 8535 18.968950 10.966610 2.9642650
28220 10 48073 40.3718800 42484 14.549010 11.498450 18.3857500
28356 0 48089 19.4790000 18757 14.037430 9.079277 17.7480400
28407 0 48095 3.2132950 3186 12.868800 12.900190 0.5021971
28424 2 48097 36.9146500 32254 15.715880 10.122780 4.1018170
28458 0 48101 2.1916240 1975 14.379750 7.949367 9.0126580
28509 0 48107 8.1708140 7349 16.546470 10.953870 4.5176220
28560 114 48113 2273.6440000 2000192 13.834770 16.485920 20.6574700
28577 0 48115 16.8217000 15172 15.699970 13.076720 3.8821510
28611 0 48119 17.7615500 4923 13.751780 9.729839 8.6532600
28628 8 48121 392.2178000 348453 14.371230 18.427160 5.2646990
28730 1 48133 19.5062600 18064 14.492910 9.427590 2.2807790
28781 7 48139 103.2532000 97054 16.487730 12.178790 10.5085800
28798 42 48141 675.7062000 684446 17.798920 15.065030 3.6059820
28832 6 48145 23.0486600 17727 13.696620 13.403280 28.8091600
28934 19 48157 350.7038000 306832 16.607130 10.890980 21.1496800
28985 0 48163 13.9663200 15824 17.366030 13.207790 8.1900910
29002 1 48165 9.7975350 14719 18.146610 12.568790 2.9961270
29070 0 48175 7.7166890 6586 14.257520 9.489827 7.1211660
29138 11 48183 409.2109000 112138 15.329330 12.177850 20.0074900
29189 4 48189 36.3794500 36548 16.621980 13.776400 5.9592860
29308 7 48203 66.4163900 59685 17.010970 11.259110 29.7344400
29325 0 48205 3.5627460 5210 12.092130 29.731290 0.2303263
29342 1 48207 6.9188490 6247 13.350410 8.676165 4.4501360
29393 4 48213 75.1025600 65664 13.986350 9.449622 8.4551660
29461 0 48221 82.9558900 34976 13.294830 8.817474 0.2315874
29478 1 48223 38.8085900 30455 14.825150 11.377440 9.0855360
29495 1 48225 17.8424000 21962 13.969580 10.709410 30.7804400
29512 5 48227 36.3674300 32836 15.077960 11.597030 4.2544770
29614 2 48241 35.1527400 32954 15.976820 9.519330 19.8701200
29699 0 48255 16.7495300 12567 15.485000 9.962601 2.9919630
29733 1 48259 29.6459300 19639 13.967110 9.124701 0.4277203
29784 0 48269 0.3683555 336 18.452380 11.904760 0.0000000
29801 2 48273 34.8146100 30325 16.692500 17.586150 3.1788950
29835 1 48277 49.3517700 45255 14.623800 11.013150 15.2292600
29869 2 48281 24.1031200 17163 15.463500 9.893375 2.5520010
29920 1 48287 22.9759100 14442 17.601440 10.012460 15.0948600
29954 7 48291 54.5801400 63294 15.819830 12.729480 15.7187100
30022 0 48299 13.7587700 12861 8.856232 5.699401 0.1943861
30073 7 48305 7.3865460 6588 15.163930 11.536130 3.2331510
30090 0 48307 8.1305140 8694 14.837820 8.902692 2.0013800
30158 4 48315 27.3591100 10430 14.141900 8.686481 32.0038300
30209 0 48321 34.2689400 38192 16.163070 11.460520 14.0710100
30243 1 48325 26.6327900 35363 17.362780 12.337750 0.9982185
30260 0 48327 2.6177180 2361 11.647610 8.301567 0.3811944
30277 1 48329 128.8790000 116016 15.389260 11.968180 8.2833400
30294 1 48331 23.5805100 23972 15.910230 9.290005 13.3322200
30311 0 48333 6.3715810 4767 13.719320 7.216279 0.2517307
30328 0 48335 9.8918880 9002 14.763390 10.653190 5.4543430
30345 3 48337 19.3726200 18030 13.471990 8.779812 0.0776484
30362 37 48339 235.4367000 245845 16.128450 11.268070 4.5996460
30430 4 48347 59.7147100 56533 16.507170 19.822050 17.8869000
30464 2 48351 15.2890900 14259 16.607060 10.274210 23.6271800
30515 0 48359 1.5127490 2270 30.484580 6.872247 0.3524229
30549 3 48363 26.7217100 25463 14.271690 10.521150 3.3342500
30566 2 48365 28.5892500 22899 16.302020 9.799555 19.4025900
30583 3 48367 84.2004500 76073 15.496960 10.564850 1.0463630
30600 0 48369 11.7993300 10403 16.937420 11.737000 1.3746040
30617 0 48371 3.4319910 16349 17.046920 15.664570 1.2416660
30634 29 48373 42.4708900 44906 13.436960 10.686770 16.3385700
30651 9 48375 119.4765000 108636 14.562390 14.145400 9.8862260
30770 0 48389 5.6879840 14993 17.374770 13.006070 2.1143200
30804 0 48393 1.0691120 988 17.206480 6.983806 0.0000000
30821 6 48395 18.1662800 15522 15.120470 10.791130 28.0311800
30889 0 48403 21.3013300 10443 12.247440 7.651058 12.1708300
30923 0 48407 34.9720100 19957 14.791800 8.698702 16.3451400
30957 0 48411 5.3104700 6024 14.707840 12.217800 1.3114210
30974 0 48413 2.3561410 3088 17.227980 8.354922 1.2305700
31042 0 48421 3.0531770 2818 15.826830 10.361960 0.1419446
31076 0 48425 31.9829600 5986 17.474110 10.591380 0.2171734
31093 1 48427 44.1334400 53974 21.256530 14.160520 0.1074592
31127 0 48431 1.5281160 1411 15.733520 12.331680 0.0000000
31144 1 48433 1.9733850 1813 12.961940 9.156095 4.6883620
31178 0 48437 9.4348410 8495 15.232490 12.525010 5.8858150
31212 6 48441 133.3825000 122130 15.311550 15.482680 6.7870300
31229 5 48445 14.7150700 13093 17.727030 9.951882 3.9104860
31246 0 48447 1.9696280 1797 12.520870 8.458542 0.0000000
31263 7 48449 60.6765200 24909 15.263560 12.272670 14.1756000
31348 3 48459 59.4049300 34909 15.964360 10.318260 13.1885800
31416 2 48467 50.1727100 42579 14.551770 9.093685 4.0395500
31433 1 48469 92.4048100 81541 16.659100 11.813690 6.7990340
31501 2 48477 46.9581100 28610 15.802170 11.544910 21.7930800
31620 1 48491 176.3601000 198286 16.451990 13.301490 5.3639690
32283 0 51003 102.6577000 74189 15.293370 16.534800 11.2415600
32385 3 51015 61.2532700 59515 13.415110 11.681090 4.0325970
32419 1 51019 69.9074800 52768 12.791840 11.033200 8.8462710
32436 0 51021 19.0553700 6834 13.154810 11.428150 3.8045070
32538 0 51033 40.1837300 21399 13.963270 13.164170 40.6280700
32555 0 51035 58.1448700 27703 13.096050 11.085440 0.4187272
32606 0 51043 71.0181600 12543 11.775490 11.767520 9.9019370
32640 3 51047 83.9111500 31981 13.289140 14.136520 20.5090500
32657 1 51049 26.2810700 7845 14.608030 11.064370 41.4786500
32674 0 51051 52.2539600 17381 16.776940 10.793400 0.4315057
32725 9 51059 2281.5560000 902492 12.887650 14.432590 8.3178580
32742 0 51061 79.6030000 51765 13.400950 12.068000 12.3075400
32776 0 51065 58.7571200 16887 12.992240 12.044770 24.6461800
32793 2 51067 62.9604800 43574 14.045070 12.417960 11.9291300
32827 0 51071 45.6846000 16349 13.089490 11.046550 1.9573060
32844 0 51073 155.4300000 33659 14.034880 11.328320 12.4454100
32878 1 51077 37.1016800 16420 13.319120 10.779540 3.3130330
32895 0 51079 82.8289200 12972 13.321000 13.035770 7.3003390
32929 3 51083 46.1849600 37581 13.996430 10.420160 41.4571200
32980 1 51089 147.3207000 56326 13.286940 12.880370 25.3453100
33014 2 51093 89.8795300 28391 13.366910 12.306720 34.2045000
33031 2 51095 289.4922000 41370 12.562240 12.779790 19.6906000
33099 0 51103 85.7643500 11418 10.772460 7.479418 32.0634100
33133 0 51107 237.2317000 123333 12.838410 14.222470 7.9946160
33167 1 51111 25.7181900 11104 14.103030 9.347982 40.2467600
33218 3 51117 49.5978600 30946 13.261810 10.996570 41.1103200
33269 0 51125 28.6450900 13529 12.876040 9.934216 20.6223700
33286 1 51127 57.4220900 12047 13.505440 10.973690 22.2960100
33490 4 51155 106.9691000 34290 13.484980 12.158060 6.6695830
33575 3 51165 73.3494600 62432 13.464250 12.328610 1.6642110
33592 0 51167 61.3846300 29134 15.167840 11.354430 1.2253720
33609 0 51169 42.7687800 22949 13.599720 11.002660 0.6579807
33626 0 51171 65.6276600 33612 11.760680 11.278710 1.2346780
33677 2 51177 184.8635000 74106 15.511560 12.716920 12.0165700
33711 1 51181 22.9521600 6406 14.392760 11.551670 58.3671600
33728 1 51183 20.5569800 10088 13.669710 12.053930 60.6661400
33762 0 51187 139.8132000 29879 12.319690 12.985710 5.5825160
33796 1 51193 72.2188900 16549 11.843620 10.496100 35.1078600
33813 1 51195 97.9315100 39494 16.361980 11.224490 2.0104320
33830 4 51197 56.8990400 26357 13.601700 11.568080 3.8737340
33847 2 51199 520.9357000 55010 16.222510 10.932560 17.1314300
33864 4 51510 7700.9310000 117586 7.710952 21.062880 23.2918900
33881 0 51520 1548.8760000 17957 12.719270 11.488560 6.3874810
33915 9 51550 564.6537000 192342 14.759130 13.688640 30.1379800
33949 2 51600 3405.6550000 20990 10.909960 18.275370 5.2977610
33983 12 51650 2678.1980000 138757 13.790300 16.759510 41.6130400
34068 0 51730 1671.3260000 38234 12.331960 14.929120 74.1983600
34085 30 51740 3057.1300000 101308 13.789630 14.780670 50.1658300
34153 2 51790 1255.0290000 24800 12.342740 12.971770 13.9637100
34170 4 51800 147.2525000 58901 14.329130 12.067710 47.4134600
34969 0 54009 299.0725000 26573 14.465810 12.904080 0.7827494
34986 5 54011 341.5267000 96178 13.689200 15.433880 4.1298430
35037 0 54017 22.5800900 7235 14.554250 11.803730 0.0276434
35054 1 54019 73.6677600 48908 15.488260 12.376300 6.3445650
35071 1 54021 21.1258100 7184 15.297880 16.327950 0.4315145
35139 1 54029 417.9527000 34705 13.464920 11.805220 2.5961680
35224 9 54039 226.9633000 204968 12.723940 13.053750 6.7537370
35241 0 54041 45.3751500 17642 13.654910 13.122100 0.2324000
35258 1 54043 50.6341600 22150 16.316030 13.413090 0.0270880
35275 0 54045 92.1258300 41839 17.349840 12.717800 3.1740720
35309 1 54049 185.9213000 57571 13.803820 13.070820 3.3054840
35360 5 54055 153.4521000 64521 14.610750 13.101160 6.3731190
35394 1 54059 78.0573200 32986 17.592310 14.460680 2.5889770
35428 1 54063 27.4949800 13015 13.615060 12.178260 1.3215520
35496 0 54071 11.6222300 8112 12.191810 13.190340 2.1449700
35513 0 54073 57.2525300 7484 14.577770 12.814000 0.2137894
35615 1 54085 22.6826200 10286 13.513510 12.521870 0.0680537
35632 1 54087 31.8451100 15400 15.285710 11.363640 0.0324675
35717 0 54097 66.6332200 23640 15.854480 15.139590 0.6175973
35751 0 54101 18.7382800 10420 15.767750 12.360840 0.0287908
35768 2 54103 52.0241000 18688 14.244440 12.291310 0.0856164
35802 3 54107 238.9429000 87770 13.175340 13.173070 0.9353994
percmale rpcincmaint rpcpersinc rpcunemins year murders murdrate
34 48.83233 139.084 13583.020 28.710 1996 6 0.4877137
51 49.15203 405.768 10760.510 63.162 1996 1 0.3777148
68 48.97446 184.382 11094.820 21.692 1996 2 0.4609145
119 47.99447 248.820 11536.320 35.090 1996 14 1.2333610
153 49.22060 200.970 9806.698 26.796 1996 0 0.0000000
170 48.60006 231.594 10819.840 40.194 1996 0 0.0000000
221 49.37895 206.712 10740.730 30.624 1996 0 0.0000000
238 49.00501 207.988 12356.780 37.004 1996 6 1.4316390
323 47.35830 368.764 10669.270 55.506 1996 0 0.0000000
340 48.70077 187.572 11594.370 33.176 1996 0 0.0000000
357 49.71424 246.268 11117.150 29.986 1996 1 0.2033885
459 47.84886 273.064 10890.660 24.882 1996 2 1.1145790
476 47.88911 241.802 11241.560 72.094 1996 0 0.0000000
544 47.31487 313.896 10865.140 41.470 1996 2 1.3130250
595 46.83719 239.888 16048.890 26.158 1996 148 2.2358960
629 49.23268 237.336 10788.580 52.316 1996 1 0.3026909
646 49.68434 170.346 10996.570 26.158 1996 6 0.6313264
680 46.46007 602.910 8227.648 62.524 1996 0 0.0000000
748 49.06895 204.160 10766.890 49.764 1996 2 0.6510841
782 48.35805 324.104 10921.920 81.026 1996 4 1.6754630
816 48.79467 156.310 13956.890 31.262 1996 8 0.7480690
850 46.74559 419.166 9889.000 47.850 1996 0 0.0000000
918 50.46608 161.414 11296.430 21.054 1996 4 0.6754703
952 46.37072 540.386 8607.258 86.768 1996 2 1.2365520
986 47.11128 249.458 12065.220 45.298 1996 7 1.7583520
1020 48.10148 242.440 11992.490 36.366 1996 1 0.1435008
1037 46.80725 780.912 8046.456 48.488 1996 1 0.7399186
1207 48.00554 308.792 11690.070 54.230 1996 3 1.2223440
1224 47.86433 134.618 12125.190 45.298 1996 3 0.8245836
1258 47.98470 186.934 11140.120 47.850 1996 1 0.3134207
1377 48.63011 193.314 10632.270 48.488 1996 4 1.7819750
1428 47.94569 255.838 11713.680 54.230 1996 7 3.5202410
1462 49.07894 190.762 9857.100 58.058 1996 1 0.2037739
1479 47.18168 390.456 11043.780 35.090 1996 16 3.2255460
1496 48.06590 331.122 10296.680 45.298 1996 5 2.5822440
1513 48.09855 299.222 11163.090 42.746 1996 0 0.0000000
1530 46.82524 422.994 10109.110 77.836 1996 1 0.6446207
1649 48.44878 207.350 10392.380 61.886 1996 0 0.0000000
1802 47.70881 419.804 9352.442 43.384 1996 1 1.0833060
1819 48.15325 303.050 10009.580 76.560 1996 0 0.0000000
1836 50.43743 649.484 8421.600 79.750 1996 2 1.5622560
1887 49.47140 241.802 10900.870 45.298 1996 1 0.4719653
1921 49.25920 185.020 10315.180 52.316 1996 0 0.0000000
1938 48.84599 236.060 9501.734 44.660 1996 1 0.6993985
1955 47.81001 297.946 10289.030 26.796 1996 4 1.0269580
2057 49.26976 203.522 9136.798 60.610 1996 1 1.0738830
2091 48.99380 188.210 11092.910 70.818 1996 0 0.0000000
2108 48.15534 360.470 10664.810 56.144 1996 1 0.4045307
2329 47.36293 278.806 13806.960 70.818 1996 1 0.2172213
2346 49.23980 235.422 9642.094 45.936 1996 0 0.0000000
2414 48.81053 215.644 11029.110 36.366 1996 1 0.5263158
4505 48.69447 179.278 20153.780 93.148 1996 20 0.4242528
4522 48.79899 139.722 13408.210 53.592 1996 10 0.7623055
10132 47.61591 357.918 9985.338 23.606 1996 0 0.0000000
10183 48.84871 443.410 9090.862 22.330 1996 4 0.9892910
10200 50.29115 218.834 10500.840 21.692 1996 1 0.3147525
10268 47.36741 413.424 9966.198 31.262 1996 2 0.9590486
10302 48.01785 542.938 9268.864 12.760 1996 1 0.2917068
10336 48.27649 289.014 11355.760 15.950 1996 6 0.8369952
10370 47.76014 322.190 10484.250 18.502 1996 1 0.6454945
10438 48.89600 232.870 11172.660 12.122 1996 7 0.7975209
10455 48.56981 234.146 11620.530 15.950 1996 0 0.0000000
10523 50.64995 273.064 11845.750 17.226 1996 2 0.7737542
10540 47.64589 311.344 12540.530 20.416 1996 11 0.8710111
10557 48.92730 179.278 13188.740 24.244 1996 1 0.2126257
10574 47.65234 492.536 10557.620 24.882 1996 12 1.4465670
10625 49.34476 133.980 14677.830 17.226 1996 16 0.8964439
10693 48.57600 255.838 10488.080 18.502 1996 3 0.5848067
10744 47.30850 294.756 10528.280 28.072 1996 7 1.6397280
11118 48.77180 180.554 10747.110 14.674 1996 2 0.6851896
11152 50.23215 132.704 13584.300 63.162 1996 2 0.2516515
11220 49.23077 204.798 10609.940 89.958 1996 1 0.3396162
11356 54.16632 239.250 9570.000 95.062 1996 1 0.4120992
11390 51.09446 149.930 12707.050 69.542 1996 1 0.0785682
14569 46.46298 498.278 7961.602 51.040 1996 1 0.8679802
14586 47.52520 267.322 9113.192 65.714 1996 3 1.6797310
14654 46.74237 343.244 10688.410 38.280 1996 2 0.8906702
14688 49.41652 240.526 12532.870 24.244 1996 10 0.5662097
14705 49.00835 170.984 10629.080 94.424 1996 0 0.0000000
14756 47.76427 269.874 11663.280 18.502 1996 0 0.0000000
14773 48.84380 162.690 10259.040 22.968 1996 0 0.0000000
14807 47.33916 319.000 12678.340 31.262 1996 5 0.6494603
14824 47.84274 195.228 13397.360 70.818 1996 5 0.6815982
14858 47.62511 296.670 11604.580 22.330 1996 2 0.3267814
14875 47.56199 265.408 13345.680 15.950 1996 6 0.8788247
14892 47.21534 253.286 9679.098 50.402 1996 0 0.0000000
14943 49.84098 285.824 9719.292 24.882 1996 0 0.0000000
14977 48.89761 129.514 13609.820 15.950 1996 7 0.6835003
14994 47.95189 339.416 11931.880 44.660 1996 0 0.0000000
15011 48.93938 315.172 11862.330 32.538 1996 1 0.3964950
15062 46.84867 553.784 10539.760 52.954 1996 13 1.9662710
15079 47.90281 426.822 9983.424 29.986 1996 3 1.4997750
19244 48.94659 330.484 11670.300 33.814 1996 4 1.6459550
19261 48.60457 292.842 11389.580 87.406 1996 1 0.4203093
19329 47.15793 433.202 12441.000 47.212 1996 9 2.9673590
19431 50.26828 204.798 11484.000 25.520 1996 0 0.0000000
19482 48.75294 132.066 14980.240 43.384 1996 9 0.6971124
19533 46.70544 376.420 11776.840 29.986 1996 1 0.7092702
19550 49.20069 257.752 10823.030 27.434 1996 3 3.6891290
19567 48.05485 232.232 12153.900 77.198 1996 6 0.6565917
19584 47.65753 461.274 11705.390 47.212 1996 6 1.1544010
19618 50.86377 261.580 12476.730 26.158 1996 37 1.2991570
19737 47.24972 183.106 17866.550 30.624 1996 30 1.0555690
19907 48.06518 163.966 15033.830 24.882 1996 3 0.3849115
19924 46.31799 482.966 10602.920 24.882 1996 2 0.8909876
19958 49.34417 453.618 11459.760 62.524 1996 1 1.8474040
20009 48.73892 232.870 12910.570 22.330 1996 7 0.7121855
20026 48.42575 195.866 14275.890 37.004 1996 2 0.4212034
20077 48.87143 192.038 11336.620 65.714 1996 2 0.5255275
20094 48.11905 203.522 12000.140 38.280 1996 0 0.0000000
20128 48.22361 155.672 19485.160 28.710 1996 71 1.1881070
20179 47.94922 252.010 13222.550 38.280 1996 9 1.0228320
20247 47.71175 99.528 17383.590 16.588 1996 5 0.4595799
20315 48.12609 360.470 10229.690 27.434 1996 0 0.0000000
20366 47.01097 133.980 16133.740 17.226 1996 0 0.0000000
20383 49.02473 119.944 13121.110 38.280 1996 7 0.5959730
20417 47.64025 441.496 10155.680 58.696 1996 19 1.6789050
20434 47.75216 215.006 12259.170 48.488 1996 3 0.3349149
20468 48.20756 215.006 11700.920 60.610 1996 3 0.5023190
20502 46.79415 391.094 11346.190 38.280 1996 4 1.1298160
20570 49.84177 360.470 9109.364 123.772 1996 1 0.8327782
20621 49.16090 119.944 12572.430 20.416 1996 13 1.2698790
20655 49.04648 111.650 18411.400 22.330 1996 34 0.6366147
20706 48.98531 145.464 11247.300 26.796 1996 2 0.4955770
22219 53.01381 111.650 9698.876 16.588 1996 0 0.0000000
22236 52.64906 335.588 7756.166 17.226 1996 1 0.7547170
22253 50.27441 130.152 11385.750 9.570 1996 0 0.0000000
22287 48.43692 260.304 10653.320 20.416 1996 0 0.0000000
22321 49.66898 309.430 9165.508 17.864 1996 6 1.9567560
22338 50.32877 80.388 12403.360 16.588 1996 6 0.7199251
22389 47.58033 491.260 9010.474 36.366 1996 1 0.6557377
22423 50.53496 97.614 12329.350 15.312 1996 13 0.6677385
22440 48.36092 306.878 7400.162 39.556 1996 0 0.0000000
22457 50.84509 214.368 10903.420 17.864 1996 7 0.6296606
22474 47.59413 204.798 10158.870 23.606 1996 0 0.0000000
22508 48.92086 169.708 9978.958 28.072 1996 3 0.4582321
22678 47.91203 415.976 9783.092 23.606 1996 0 0.0000000
22695 49.59006 99.528 11960.590 18.502 1996 0 0.0000000
22763 47.96252 290.928 10597.820 19.778 1996 1 1.4872100
22831 47.61949 359.832 9319.266 18.502 1996 0 0.0000000
22882 49.33915 179.278 9901.760 24.244 1996 4 1.2926160
22899 49.46025 157.586 11210.300 14.674 1996 1 0.3232062
22916 51.27938 211.816 9277.158 18.502 1996 0 0.0000000
22950 48.21028 400.664 9834.770 39.556 1996 8 2.3018930
23018 49.34227 215.644 10243.730 21.054 1996 1 0.2734856
23035 49.00000 213.730 9573.190 37.642 1996 1 0.8064516
23103 50.86283 336.226 8482.210 26.158 1996 2 1.7608730
23137 48.46778 302.412 9243.982 39.556 1996 4 1.0576130
23256 48.11128 225.852 10498.930 24.882 1996 3 0.4863656
23273 49.31814 400.664 8388.424 27.434 1996 0 0.0000000
23307 49.62698 96.976 11670.930 24.244 1996 3 0.4721732
23324 47.99279 363.022 9545.756 39.556 1996 1 0.4006410
23358 48.05012 176.088 10927.030 26.158 1996 1 0.2307550
23375 50.01732 105.270 12252.150 10.846 1996 0 0.0000000
23409 48.41158 161.414 16556.740 22.968 1996 35 0.6583947
23443 48.20868 128.876 15530.830 28.710 1996 0 0.0000000
23494 50.44732 146.740 10771.350 24.882 1996 2 1.0714090
25364 48.58033 195.866 12920.780 38.280 1996 10 0.7511455
25398 47.93048 140.360 12370.820 37.004 1996 12 0.7664891
25483 47.34771 278.806 10688.410 51.678 1996 2 1.4573010
25517 47.91992 173.536 10532.100 39.556 1996 7 1.4582420
25602 47.10727 327.932 11644.140 45.936 1996 5 0.7654741
25619 46.49692 479.776 9766.504 52.954 1996 4 1.3525390
25653 48.48565 301.136 9789.472 33.814 1996 1 0.5249068
25670 48.22237 313.258 10670.550 43.384 1996 3 1.3449900
25687 47.14870 321.552 12637.500 43.384 1996 14 1.1348440
25704 47.77228 250.734 12438.450 55.506 1996 9 1.7457080
25823 47.90078 182.468 11552.900 49.126 1996 4 0.6997411
25874 48.82365 113.564 14016.860 35.090 1996 13 0.6646013
25891 53.77438 265.408 8849.060 273.702 1996 3 3.1806620
25908 45.49936 373.868 9655.492 47.212 1996 0 0.0000000
26027 48.88084 275.616 10652.050 37.642 1996 2 1.1874370
26044 48.21453 170.346 13082.830 36.366 1996 18 0.7408566
26061 49.62440 304.964 10398.120 26.796 1996 9 0.8398578
26078 46.49451 199.056 10218.850 56.782 1996 2 0.6512749
26112 48.17412 127.600 14014.310 40.832 1996 5 0.3394456
26469 47.85506 229.680 14222.300 39.556 1996 0 0.0000000
26605 50.23361 112.926 11691.990 23.606 1996 0 0.0000000
26639 48.29655 393.646 9922.814 86.130 1996 0 0.0000000
26673 48.58733 208.626 10509.140 41.470 1996 1 0.2378234
26690 47.51471 267.322 12715.340 55.506 1996 0 0.0000000
26707 48.83959 299.222 12345.940 28.710 1996 0 0.0000000
26809 48.54213 257.114 10911.080 72.094 1996 3 0.5118318
26877 48.49385 312.620 10403.230 70.818 1996 0 0.0000000
26911 48.27939 230.956 11355.120 104.632 1996 1 0.4264210
26928 48.18738 213.092 12254.070 48.488 1996 0 0.0000000
26979 49.21140 180.554 10654.600 79.750 1996 0 0.0000000
26996 49.07122 199.056 10338.790 44.660 1996 0 0.0000000
27013 47.87363 189.486 15281.380 29.348 1996 32 0.8777560
27030 49.01134 382.162 10272.440 54.230 1996 8 3.3372270
27081 48.31687 202.884 11173.930 85.492 1996 1 0.3477535
27115 48.71928 232.870 9606.366 106.546 1996 1 0.5756058
27166 48.73081 285.824 10100.180 88.682 1996 1 0.3003995
27183 50.40976 148.654 11787.050 28.710 1996 8 0.6615780
27302 48.34634 234.146 12505.440 39.556 1996 0 0.0000000
27353 48.77965 156.310 12802.110 75.284 1996 0 0.0000000
27370 47.71798 310.068 16764.730 28.710 1996 171 1.9713880
27387 48.50284 195.866 11429.130 69.542 1996 0 0.0000000
27421 48.13940 204.798 13787.180 22.330 1996 5 0.3336804
27455 48.81603 202.884 8579.186 61.886 1996 0 0.0000000
27506 48.37721 234.784 11903.170 49.764 1996 2 0.5624930
27523 48.51743 192.676 13526.240 27.434 1996 6 0.5984142
27557 48.14849 171.622 11377.450 58.696 1996 0 0.0000000
27608 59.20190 208.626 9366.478 33.814 1996 5 0.9583318
27676 49.95756 116.754 11478.260 17.864 1996 0 0.0000000
27778 50.68455 167.156 10988.910 29.348 1996 7 1.4951190
27795 46.95401 253.924 11884.030 33.814 1996 0 0.0000000
27812 53.77070 341.330 8905.204 30.624 1996 1 0.3592857
27846 48.46873 257.752 13642.990 29.348 1996 128 0.9709312
27880 51.30112 253.286 6455.922 54.230 1996 1 12.3915700
27931 52.06290 127.600 13018.390 40.194 1996 10 0.4527878
27965 50.87301 220.748 10215.660 16.588 1996 0 0.0000000
27982 50.07825 334.312 12987.770 6.380 1996 0 0.0000000
28016 49.14277 209.902 10737.540 37.004 1996 3 0.8164154
28033 48.90764 248.182 10285.200 24.882 1996 1 0.6541078
28050 49.22865 165.880 12314.680 24.244 1996 0 0.0000000
28067 50.53090 248.182 9823.924 29.986 1996 1 0.3277184
28084 49.60649 225.214 11179.670 35.728 1996 1 0.4828352
28101 48.33863 186.934 10286.470 28.710 1996 2 1.5898250
28118 48.12691 447.876 7950.118 37.004 1996 19 0.6031459
28152 48.55526 98.252 13368.010 35.090 1996 0 0.0000000
28186 49.75981 372.592 16851.490 14.674 1996 0 0.0000000
28220 50.24715 240.526 11548.440 31.900 1996 5 1.1769140
28356 48.13670 261.580 12808.490 17.226 1996 0 0.0000000
28407 53.98619 242.440 8914.136 12.122 1996 0 0.0000000
28424 49.05438 169.070 11992.490 24.882 1996 1 0.3100391
28458 48.91139 388.542 10319.010 31.900 1996 0 0.0000000
28509 48.71411 448.514 10413.440 31.900 1996 0 0.0000000
28560 49.22912 168.432 19194.870 39.556 1996 255 1.2748780
28577 53.04508 320.276 10473.410 33.176 1996 0 0.0000000
28611 47.36949 315.810 11385.750 27.434 1996 0 0.0000000
28628 49.49362 51.040 15229.700 26.796 1996 11 0.3156810
28730 48.06798 247.544 10373.880 33.814 1996 1 0.5535873
28781 49.44979 140.360 13025.410 269.236 1996 6 0.6182125
28798 48.54013 324.742 9238.240 12.760 1996 37 0.5405832
28832 51.43002 373.230 9521.512 17.226 1996 6 3.3846670
28934 50.23726 76.560 15198.440 21.692 1996 20 0.6518225
28985 53.64004 399.388 6910.178 34.452 1996 0 0.0000000
29002 50.32271 228.404 9568.724 19.140 1996 0 0.0000000
29070 48.43608 274.340 9744.174 19.778 1996 0 0.0000000
29138 47.98641 209.902 14245.900 48.488 1996 11 0.9809342
29189 49.67167 306.240 12425.690 28.710 1996 1 0.2736128
29308 48.10924 252.010 11086.530 52.954 1996 9 1.5079170
29325 61.20921 74.646 12141.140 10.208 1996 1 1.9193860
29342 48.59933 300.498 11490.380 22.330 1996 1 1.6007680
29393 48.56390 172.898 11018.260 35.090 1996 4 0.6091618
29461 49.71409 93.148 15520.630 32.538 1996 0 0.0000000
29478 49.12822 178.002 11288.770 37.642 1996 2 0.6567066
29495 51.19752 359.832 11165.000 15.950 1996 1 0.4553320
29512 50.52382 262.856 11862.330 24.882 1996 3 0.9136314
29614 47.78783 278.168 11463.580 75.284 1996 3 0.9103599
29699 48.02260 397.474 9869.222 28.072 1996 1 0.7957349
29733 48.83141 100.804 17019.290 11.484 1996 2 1.0183820
29784 52.08333 158.862 5179.284 17.226 1996 0 0.0000000
29801 49.58945 375.782 10053.600 35.728 1996 5 1.6488050
29835 47.26992 289.652 12291.710 3.828 1996 4 0.8838803
29869 48.77935 185.658 9615.936 19.140 1996 2 1.1652970
29920 50.87938 158.224 10599.090 24.244 1996 1 0.6924249
29954 52.40465 221.386 10862.590 45.936 1996 4 0.6319714
30022 47.68681 144.188 13248.070 16.588 1996 0 0.0000000
30073 49.36248 396.836 11200.730 12.122 1996 1 1.5179110
30090 47.82609 315.172 10507.860 36.366 1996 0 0.0000000
30158 49.36721 417.890 9522.788 62.524 1996 4 3.8350910
30209 49.51822 232.870 10889.380 81.664 1996 0 0.0000000
30243 52.44464 210.540 9883.258 15.312 1996 2 0.5655629
30260 49.93647 356.642 10812.820 24.244 1996 0 0.0000000
30277 48.62519 148.654 17910.570 33.814 1996 4 0.3447800
30294 48.60671 304.964 10331.770 25.520 1996 3 1.2514600
30311 49.10846 248.182 10443.420 19.778 1996 0 0.0000000
30328 55.56543 265.408 8824.178 34.452 1996 0 0.0000000
30345 47.84248 207.988 11422.750 31.900 1996 1 0.5546312
30362 49.64388 113.564 14733.330 26.158 1996 9 0.3660843
30430 48.51149 227.766 11070.580 35.728 1996 4 0.7075514
30464 48.69205 313.896 8851.612 54.868 1996 2 1.4026230
30515 57.22467 96.976 11418.290 8.294 1996 2 8.8105730
30549 48.26218 205.436 11090.990 41.470 1996 2 0.7854534
30566 47.87982 220.748 10667.360 43.384 1996 2 0.8734006
30583 50.01775 96.338 12639.420 24.882 1996 4 0.5258107
30600 50.97568 230.318 13411.400 10.846 1996 0 0.0000000
30617 55.35507 238.612 7389.316 24.882 1996 1 0.6116582
30634 52.15116 218.196 10096.350 26.158 1996 3 0.6680622
30651 49.07029 250.096 12863.360 41.470 1996 7 0.6443536
30770 52.15767 357.918 7513.088 56.144 1996 1 0.6669779
30804 48.68421 111.012 8935.190 10.208 1996 0 0.0000000
30821 47.99639 394.922 10190.140 33.176 1996 1 0.6442469
30889 48.30030 290.928 11094.820 48.488 1996 0 0.0000000
30923 50.16786 264.770 9823.924 21.054 1996 1 0.5010773
30957 53.23705 279.444 9809.888 30.624 1996 0 0.0000000
30974 49.22280 230.956 8671.696 42.746 1996 0 0.0000000
31042 50.10646 137.170 18253.820 3.828 1996 0 0.0000000
31076 51.36986 171.622 13329.730 35.728 1996 0 0.0000000
31093 49.60722 567.820 4614.654 24.882 1996 0 0.0000000
31127 49.53933 177.364 8152.364 39.556 1996 0 0.0000000
31144 48.59349 241.802 11239.010 41.470 1996 1 5.5157200
31178 52.76045 319.000 12592.210 18.502 1996 0 0.0000000
31212 48.39433 185.020 12886.320 35.090 1996 8 0.6550397
31229 50.53846 349.624 13656.390 25.520 1996 3 2.2913010
31246 48.13578 256.476 13652.560 29.348 1996 0 0.0000000
31263 48.82573 179.916 12270.020 45.298 1996 2 0.8029227
31348 48.40013 196.504 10638.650 37.004 1996 2 0.5729182
31416 48.92318 169.708 10869.610 22.330 1996 2 0.4697151
31433 48.97168 211.816 14077.470 29.348 1996 2 0.2452754
31501 48.38868 195.228 14398.380 17.226 1996 2 0.6990563
31620 49.36405 70.818 13990.700 21.692 1996 1 0.0504322
32283 48.90078 134.618 18108.990 11.484 1996 0 0.0000000
32385 50.60909 124.410 13242.970 19.140 1996 5 0.8401243
32419 49.90335 101.442 13376.310 14.674 1996 1 0.1895088
32436 53.59965 165.880 9128.504 30.624 1996 0 0.0000000
32538 49.49297 181.192 11513.350 23.606 1996 0 0.0000000
32555 49.28347 223.938 10316.460 39.556 1996 0 0.0000000
32606 49.79670 87.406 16085.890 12.760 1996 0 0.0000000
32640 50.79578 144.826 13939.660 20.416 1996 4 1.2507430
32657 48.48948 268.598 10554.430 12.122 1996 2 2.5493950
32674 48.99603 416.614 9303.954 79.750 1996 0 0.0000000
32725 49.68831 66.352 24617.870 7.656 1996 15 0.1662065
32742 50.18449 89.320 19398.390 6.380 1996 0 0.0000000
32776 49.16800 108.460 13184.270 12.122 1996 0 0.0000000
32793 49.37577 135.894 11217.320 27.434 1996 3 0.6884840
32827 48.79809 194.590 11366.610 32.538 1996 0 0.0000000
32844 49.40729 128.876 12705.130 14.036 1996 0 0.0000000
32878 48.85505 196.504 10391.110 48.488 1996 0 0.0000000
32895 49.59914 115.478 10853.020 23.606 1996 0 0.0000000
32929 47.60384 260.942 10532.100 65.076 1996 4 1.0643680
32980 48.67557 175.450 12893.980 68.904 1996 1 0.1775379
33014 48.77602 167.794 13695.310 22.330 1996 2 0.7044486
33031 48.78898 79.112 17109.880 12.760 1996 1 0.2417210
33099 46.82081 196.504 18479.670 71.456 1996 1 0.8758101
33133 49.78392 46.574 19654.870 6.380 1996 1 0.0810813
33167 48.58609 249.458 9240.792 30.624 1996 1 0.9005764
33218 48.39398 239.888 11468.690 44.022 1996 6 1.9388610
33269 49.05019 197.142 11549.710 22.968 1996 1 0.7391529
33286 49.72192 89.958 14557.250 8.932 1996 1 0.8300822
33490 48.65267 192.676 10979.340 52.954 1996 3 0.8748906
33575 49.32727 103.994 12663.660 15.950 1996 2 0.3203485
33592 49.12473 324.742 9640.180 55.506 1996 0 0.0000000
33609 48.31583 380.248 9911.330 20.416 1996 1 0.4357488
33626 48.40533 116.754 12715.340 31.900 1996 1 0.2975128
33677 49.74631 91.872 14469.840 11.484 1996 2 0.2698837
33711 48.23603 213.730 11922.940 36.366 1996 1 1.5610370
33728 47.73989 338.778 13019.670 21.692 1996 1 0.9912767
33762 49.18170 128.876 13062.410 28.710 1996 1 0.3346832
33796 48.15397 214.368 11740.480 44.022 1996 4 2.4170640
33813 48.37444 411.510 10874.710 69.542 1996 1 0.2532030
33830 47.50920 216.282 11464.220 52.316 1996 2 0.7588117
33847 49.70914 51.678 15342.620 9.570 1996 1 0.1817851
33864 47.58134 174.174 27261.100 15.950 1996 7 0.5953090
33881 44.50632 215.006 12213.870 33.814 1996 0 0.0000000
33915 49.13696 136.532 13292.730 19.140 1996 13 0.6758794
33949 48.80896 66.352 24617.870 7.656 1996 2 0.9528347
33983 48.39107 208.626 12132.210 18.502 1996 10 0.7206843
34068 45.61908 304.964 14145.740 17.864 1996 6 1.5692840
34085 47.49082 401.302 11769.820 31.900 1996 23 2.2703040
34153 47.17742 124.410 13242.970 19.140 1996 2 0.8064516
34170 47.51363 276.254 12897.170 25.520 1996 5 0.8488820
34969 48.10522 157.586 11228.800 38.918 1996 0 0.0000000
34986 46.96500 292.204 13276.780 47.212 1996 6 0.6238433
35037 49.73048 314.534 8295.276 51.040 1996 0 0.0000000
35054 48.67711 360.470 9815.630 60.610 1996 1 0.2044655
35071 49.76336 393.646 9495.992 73.370 1996 1 1.3919820
35139 48.11122 162.052 13322.080 45.936 1996 3 0.8644288
35224 47.32397 240.526 15208.640 52.954 1996 13 0.6342453
35241 48.61127 350.262 9570.000 69.542 1996 0 0.0000000
35258 49.24605 540.386 7758.718 66.990 1996 2 0.9029346
35275 48.37831 410.872 10121.230 70.180 1996 0 0.0000000
35309 46.83782 255.200 11504.420 77.198 1996 1 0.1736986
35360 47.09629 340.692 12000.780 37.642 1996 6 0.9299298
35394 48.95410 557.612 10142.920 74.646 1996 2 0.6063178
35428 48.65924 270.512 8871.390 30.624 1996 1 0.7683442
35496 50.22189 218.834 10743.280 40.194 1996 0 0.0000000
35513 48.54356 219.472 11829.800 65.714 1996 1 1.3361840
35615 48.79448 303.688 8873.304 95.700 1996 1 0.9721952
35632 49.42208 350.900 8606.620 86.130 1996 0 0.0000000
35717 49.14975 319.638 9007.284 81.026 1996 0 0.0000000
35751 48.79079 580.580 7372.090 58.696 1996 1 0.9596929
35768 48.31443 308.154 11063.560 63.800 1996 0 0.0000000
35802 47.69511 220.110 13760.380 52.954 1996 1 0.1139341
arrestrate statefips countyfips execs lpopul execrate statename
34 0.4877137 1 3 0 11.720130 0.0000000 Alabama
51 0.3777148 1 5 0 10.183960 0.0000000 Alabama
68 0.0000000 1 9 0 10.678030 0.0000000 Alabama
119 1.7619440 1 15 0 11.639660 0.0000000 Alabama
153 0.9447331 1 19 0 9.960340 0.0000000 Alabama
170 0.0000000 1 21 0 10.472290 0.0000000 Alabama
221 1.4875420 1 29 0 9.506363 0.0000000 Alabama
238 1.9088520 1 31 0 10.643280 0.0000000 Alabama
323 0.7399733 1 41 0 9.511481 0.0000000 Alabama
340 0.6823703 1 43 0 11.201960 0.0000000 Alabama
357 0.2033884 1 45 0 10.802980 0.0000000 Alabama
459 1.1145790 1 57 0 9.795012 0.0000000 Alabama
476 0.3418453 1 59 0 10.283740 0.0000000 Alabama
544 0.6565126 1 67 0 9.631154 0.0000000 Alabama
595 1.4805260 1 73 0 13.402910 0.0000000 Alabama
629 0.3026909 1 79 0 10.405380 0.0000000 Alabama
646 1.1574320 1 81 0 11.462030 0.0000000 Alabama
680 3.1223170 1 85 0 9.458059 0.0000000 Alabama
748 0.6510841 1 93 0 10.332600 0.0000000 Alabama
782 1.6754630 1 99 1 10.080550 0.4188657 Alabama
816 0.7480690 1 103 0 11.580040 0.0000000 Alabama
850 0.4792945 1 107 0 9.945781 0.0000000 Alabama
918 1.1820730 1 115 0 10.988980 0.0000000 Alabama
952 1.8548290 1 119 0 9.691160 0.0000000 Alabama
986 1.5071590 1 123 0 10.591870 0.0000000 Alabama
1020 0.5740034 1 127 0 11.151750 0.0000000 Alabama
1037 2.2197560 1 131 0 9.511556 0.0000000 Alabama
1207 1.2223440 5 3 0 10.108180 0.0000000 Arkansas
1224 0.2748612 5 5 0 10.501830 0.0000000 Arkansas
1258 0.9402620 5 9 0 10.370550 0.0000000 Arkansas
1377 0.8909876 5 23 0 10.018910 0.0000000 Arkansas
1428 3.5202410 5 29 0 9.897721 0.0000000 Arkansas
1462 0.6113217 5 33 0 10.801080 0.0000000 Arkansas
1479 2.6207560 5 35 0 10.811830 0.0000000 Arkansas
1496 2.5822440 5 37 0 9.871119 0.0000000 Arkansas
1513 0.0000000 5 39 0 9.141526 0.0000000 Arkansas
1530 0.0000000 5 41 0 9.649434 0.0000000 Arkansas
1649 0.0000000 5 55 0 10.464160 0.0000000 Arkansas
1802 1.0833060 5 73 0 9.130322 0.0000000 Arkansas
1819 0.0000000 5 75 0 9.766293 0.0000000 Arkansas
1836 3.9056400 5 77 0 9.457356 0.0000000 Arkansas
1887 0.4719653 5 83 0 9.961190 0.0000000 Arkansas
1921 0.0000000 5 87 0 9.479909 0.0000000 Arkansas
1938 0.6993985 5 89 0 9.567875 0.0000000 Arkansas
1955 1.2836970 5 91 0 10.570030 0.0000000 Arkansas
2057 2.1477660 5 105 0 9.139059 0.0000000 Arkansas
2091 0.0000000 5 109 0 9.257701 0.0000000 Arkansas
2108 1.2135920 5 111 0 10.115370 0.0000000 Arkansas
2329 0.4344426 5 139 0 10.737180 0.0000000 Arkansas
2346 0.0000000 5 141 0 9.637240 0.0000000 Arkansas
2414 0.5263158 5 149 0 9.852194 0.0000000 Arkansas
4505 0.4878908 10 3 1 13.063500 0.0212126 Delaware
4522 0.2286917 10 5 0 11.784330 0.0000000 Delaware
10132 0.0000000 22 1 0 10.961100 0.0000000 Louisiana
10183 3.4625180 22 9 0 10.607400 0.0000000 Louisiana
10200 0.0000000 22 11 0 10.366310 0.0000000 Louisiana
10268 0.4795243 22 29 0 9.945301 0.0000000 Louisiana
10302 0.2917068 22 39 0 10.442350 0.0000000 Louisiana
10336 0.5579968 22 45 0 11.180040 0.0000000 Louisiana
10370 0.6454945 22 49 0 9.648079 0.0000000 Louisiana
10438 0.3417947 22 57 0 11.382500 0.0000000 Louisiana
10455 0.7091864 22 61 0 10.652590 0.0000000 Louisiana
10523 0.3868771 22 75 0 10.159990 0.0000000 Louisiana
10540 0.6334627 22 79 0 11.746340 0.0000000 Louisiana
10557 0.2126257 22 89 0 10.758560 0.0000000 Louisiana
10574 2.2903980 22 97 0 11.326050 0.0000000 Louisiana
10625 0.9524717 22 103 0 12.092250 0.0000000 Louisiana
10693 0.7797424 22 113 0 10.845430 0.0000000 Louisiana
10744 1.4054810 22 119 0 10.661720 0.0000000 Louisiana
11118 0.3425948 24 11 0 10.281550 0.0000000 Maryland
11152 0.1258257 24 15 0 11.283200 0.0000000 Maryland
11220 0.0000000 24 23 0 10.290280 0.0000000 Maryland
11356 1.2362980 24 39 0 10.096830 0.0000000 Maryland
11390 0.0785682 24 43 0 11.754130 0.0000000 Maryland
14569 0.8679802 28 21 0 9.351927 0.0000000 Mississippi
14586 1.6797310 28 23 0 9.790318 0.0000000 Mississippi
14654 0.8906702 28 43 0 10.019270 0.0000000 Mississippi
14688 1.5287660 28 47 0 12.081720 0.0000000 Mississippi
14705 0.9489467 28 57 0 9.955891 0.0000000 Mississippi
14756 1.2608950 28 67 0 11.057960 0.0000000 Mississippi
14773 0.8951216 28 71 0 10.419750 0.0000000 Mississippi
14807 1.0391370 28 75 0 11.251390 0.0000000 Mississippi
14824 0.2726393 28 81 0 11.203090 0.0000000 Mississippi
14858 1.4705160 28 87 0 11.021950 0.0000000 Mississippi
14875 1.1717660 28 89 0 11.131270 0.0000000 Mississippi
14892 0.7910975 28 95 0 10.543290 0.0000000 Mississippi
14943 0.0000000 28 105 0 10.579060 0.0000000 Mississippi
14977 0.6835003 28 121 0 11.536780 0.0000000 Mississippi
14994 1.1907600 28 123 0 10.134360 0.0000000 Mississippi
15011 0.0000000 28 127 0 10.135430 0.0000000 Mississippi
15062 0.4537548 28 151 0 11.099150 0.0000000 Mississippi
15079 1.9997000 28 153 0 9.903638 0.0000000 Mississippi
19244 2.0574440 37 7 0 10.098310 0.0000000 North Carolina
19261 0.0000000 37 9 0 10.077100 0.0000000 North Carolina
19329 3.9564790 37 17 0 10.319890 0.0000000 North Carolina
19431 0.0000000 37 29 0 8.783090 0.0000000 North Carolina
19482 0.7745693 37 35 0 11.768370 0.0000000 North Carolina
19533 0.0000000 37 41 0 9.553859 0.0000000 North Carolina
19550 0.0000000 37 43 0 9.003562 0.0000000 North Carolina
19567 1.7509110 37 45 0 11.422790 0.0000000 North Carolina
19584 0.1924002 37 47 0 10.858520 0.0000000 North Carolina
19618 0.7022472 37 51 0 12.559540 0.0000000 North Carolina
19737 1.2666820 37 67 0 12.557460 0.0000000 North Carolina
19907 0.0000000 37 89 0 11.263690 0.0000000 North Carolina
19924 2.2274690 37 91 0 10.018910 0.0000000 North Carolina
19958 1.8474040 37 95 0 8.596559 0.0000000 North Carolina
20009 1.3226300 37 101 0 11.495670 0.0000000 North Carolina
20026 0.4212034 37 105 0 10.768130 0.0000000 North Carolina
20077 1.5765820 37 111 0 10.546840 0.0000000 North Carolina
20094 0.7376263 37 113 0 10.207810 0.0000000 North Carolina
20128 0.7195581 37 119 0 13.300660 0.0000000 North Carolina
20179 1.9320160 37 127 0 11.384990 0.0000000 North Carolina
20247 0.6434119 37 135 0 11.597220 0.0000000 North Carolina
20315 0.0000000 37 143 0 9.297710 0.0000000 North Carolina
20366 1.8488850 37 149 0 9.694370 0.0000000 North Carolina
20383 1.1068070 37 151 0 11.673810 0.0000000 North Carolina
20417 1.2370880 37 155 0 11.636640 0.0000000 North Carolina
20434 0.7814680 37 157 0 11.402830 0.0000000 North Carolina
20468 0.8371984 37 161 0 10.997470 0.0000000 North Carolina
20502 1.4122700 37 165 0 10.474580 0.0000000 North Carolina
20570 0.8327782 37 173 0 9.393329 0.0000000 North Carolina
20621 1.1721960 37 179 0 11.536370 0.0000000 North Carolina
20655 0.6366147 37 183 0 13.188290 0.0000000 North Carolina
20706 0.4955770 37 189 0 10.605520 0.0000000 North Carolina
22219 0.0000000 40 3 0 8.725020 0.0000000 Oklahoma
22236 2.2641510 40 5 0 9.491753 0.0000000 Oklahoma
22253 0.0000000 40 7 0 8.701679 0.0000000 Oklahoma
22287 0.0000000 40 11 0 9.282475 0.0000000 Oklahoma
22321 3.5873860 40 15 0 10.330810 0.0000000 Oklahoma
22338 0.5999376 40 17 1 11.330710 0.1199875 Oklahoma
22389 0.6557377 40 23 0 9.632335 0.0000000 Oklahoma
22423 0.2054580 40 27 0 12.179150 0.0000000 Oklahoma
22440 0.0000000 40 29 0 8.726156 0.0000000 Oklahoma
22457 0.6296607 40 31 0 11.618820 0.0000000 Oklahoma
22474 0.0000000 40 33 0 8.836228 0.0000000 Oklahoma
22508 0.7637202 40 37 0 11.089330 0.0000000 Oklahoma
22678 0.0000000 40 57 0 8.186464 0.0000000 Oklahoma
22695 0.0000000 40 59 0 8.237743 0.0000000 Oklahoma
22763 0.0000000 40 67 0 8.813438 0.0000000 Oklahoma
22831 0.0000000 40 75 0 9.292749 0.0000000 Oklahoma
22882 0.6463079 40 81 0 10.339970 0.0000000 Oklahoma
22899 0.3232062 40 83 0 10.339800 0.0000000 Oklahoma
22916 0.0000000 40 85 0 9.063810 0.0000000 Oklahoma
22950 1.1509470 40 89 0 10.456050 0.0000000 Oklahoma
23018 0.2734856 40 97 0 10.506850 0.0000000 Oklahoma
23035 0.8064516 40 99 0 9.425451 0.0000000 Oklahoma
23103 0.8804367 40 107 0 9.337678 0.0000000 Oklahoma
23137 0.0000000 40 111 0 10.540620 0.0000000 Oklahoma
23256 0.6484874 40 125 0 11.029750 0.0000000 Oklahoma
23273 0.0000000 40 127 0 9.357553 0.0000000 Oklahoma
23307 0.4721733 40 131 0 11.059360 0.0000000 Oklahoma
23324 0.0000000 40 133 0 10.125030 0.0000000 Oklahoma
23358 0.4615101 40 137 0 10.676740 0.0000000 Oklahoma
23375 0.0000000 40 139 0 9.759732 0.0000000 Oklahoma
23409 0.6583947 40 143 1 13.183640 0.0188113 Oklahoma
23443 0.0000000 40 147 0 10.766860 0.0000000 Oklahoma
23494 1.6071140 40 153 0 9.834513 0.0000000 Oklahoma
25364 0.5258018 45 3 0 11.799080 0.0000000 South Carolina
25398 1.2774820 45 7 0 11.961180 0.0000000 South Carolina
25483 0.7286506 45 17 0 9.526901 0.0000000 South Carolina
25517 1.2499220 45 21 0 10.779020 0.0000000 South Carolina
25602 0.7654740 45 31 0 11.087040 0.0000000 South Carolina
25619 2.7050790 45 33 0 10.294650 0.0000000 South Carolina
25653 0.5249068 45 37 0 9.854875 0.0000000 South Carolina
25670 2.2416500 45 39 0 10.012570 0.0000000 South Carolina
25687 1.5401450 45 41 0 11.722900 0.0000000 South Carolina
25704 2.3276110 45 43 0 10.850400 0.0000000 South Carolina
25823 1.3994820 45 57 0 10.953680 0.0000000 South Carolina
25874 0.5112318 45 63 2 12.183860 0.1022464 South Carolina
25891 2.1204410 45 65 0 9.151863 0.0000000 South Carolina
25908 0.0000000 45 67 0 10.460100 0.0000000 South Carolina
26027 0.5937185 45 81 0 9.731690 0.0000000 South Carolina
26044 0.8643327 45 83 0 12.400660 0.0000000 South Carolina
26061 1.3997630 45 85 0 11.582090 0.0000000 South Carolina
26078 0.0000000 45 87 0 10.332310 0.0000000 South Carolina
26112 0.3394456 45 91 1 11.900220 0.0678891 South Carolina
26469 0.5587606 47 1 0 11.178670 0.0000000 Tennessee
26605 0.9042954 47 21 0 10.409550 0.0000000 Tennessee
26639 0.6350214 47 29 0 10.357580 0.0000000 Tennessee
26673 0.4756469 47 35 0 10.646570 0.0000000 Tennessee
26690 0.2762965 47 45 0 10.496620 0.0000000 Tennessee
26707 0.7064891 47 47 0 10.250930 0.0000000 Tennessee
26809 0.3412212 47 59 0 10.978710 0.0000000 Tennessee
26877 0.8141334 47 71 0 10.109120 0.0000000 Tennessee
26911 0.4264211 47 77 0 10.062670 0.0000000 Tennessee
26928 0.3362927 47 79 0 10.300110 0.0000000 Tennessee
26979 0.5997002 47 85 0 9.721666 0.0000000 Tennessee
26996 0.4966723 47 89 0 10.603310 0.0000000 Tennessee
27013 0.9600456 47 93 0 12.806460 0.0000000 Tennessee
27030 0.4171534 47 97 0 10.084640 0.0000000 Tennessee
27081 0.6955070 47 103 0 10.266600 0.0000000 Tennessee
27115 0.5756058 47 111 0 9.762672 0.0000000 Tennessee
27166 0.6007991 47 123 0 10.412980 0.0000000 Tennessee
27183 0.8269725 47 125 0 11.702910 0.0000000 Tennessee
27302 0.4011312 47 145 0 10.816950 0.0000000 Tennessee
27353 0.6521562 47 155 0 11.024110 0.0000000 Tennessee
27370 1.3373160 47 157 0 13.673270 0.0000000 Tennessee
27387 0.6384473 47 159 0 9.659057 0.0000000 Tennessee
27421 0.2669443 47 163 0 11.917350 0.0000000 Tennessee
27455 0.0000000 47 169 0 8.793005 0.0000000 Tennessee
27506 0.2812465 47 177 0 10.478860 0.0000000 Tennessee
27523 0.8976213 47 179 0 11.515570 0.0000000 Tennessee
27557 0.0000000 47 183 0 10.391090 0.0000000 Tennessee
27608 0.3833327 48 1 0 10.862340 0.0000000 Texas
27676 0.0000000 48 9 0 9.017605 0.0000000 Texas
27778 0.6407655 48 21 0 10.754040 0.0000000 Texas
27795 0.0000000 48 23 0 8.331586 0.0000000 Texas
27812 1.0778570 48 25 0 10.233980 0.0000000 Texas
27846 0.6144174 48 29 0 14.091870 0.0000000 Texas
27880 0.0000000 48 33 0 6.693324 0.0000000 Texas
27931 0.3169515 48 39 0 12.305260 0.0000000 Texas
27965 0.0000000 48 43 0 9.129239 0.0000000 Texas
27982 0.0000000 48 45 0 7.558517 0.0000000 Texas
28016 0.2721384 48 49 0 10.511780 0.0000000 Texas
28033 0.6541078 48 51 0 9.634824 0.0000000 Texas
28050 0.0000000 48 53 0 10.300680 0.0000000 Texas
28067 0.0000000 48 55 0 10.325940 0.0000000 Texas
28084 1.4485060 48 57 0 9.938420 0.0000000 Texas
28101 0.0000000 48 59 0 9.439863 0.0000000 Texas
28118 0.3174452 48 61 0 12.660380 0.0000000 Texas
28152 0.0000000 48 65 0 8.811950 0.0000000 Texas
28186 0.0000000 48 69 0 9.051930 0.0000000 Texas
28220 2.3538270 48 73 0 10.656880 0.0000000 Texas
28356 0.0000000 48 89 0 9.839322 0.0000000 Texas
28407 0.0000000 48 95 0 8.066522 0.0000000 Texas
28424 0.6200781 48 97 0 10.381400 0.0000000 Texas
28458 0.0000000 48 101 0 7.588324 0.0000000 Texas
28509 0.0000000 48 107 0 8.902320 0.0000000 Texas
28560 0.5699453 48 113 0 14.508750 0.0000000 Texas
28577 0.0000000 48 115 0 9.627207 0.0000000 Texas
28611 0.0000000 48 119 0 8.501674 0.0000000 Texas
28628 0.2295862 48 121 0 12.761260 0.0000000 Texas
28730 0.5535873 48 133 0 9.801677 0.0000000 Texas
28781 0.7212480 48 139 0 11.483020 0.0000000 Texas
28798 0.6136350 48 141 0 13.436370 0.0000000 Texas
28832 3.3846670 48 145 0 9.782845 0.0000000 Texas
28934 0.6192313 48 157 0 12.634060 0.0000000 Texas
28985 0.0000000 48 163 0 9.669283 0.0000000 Texas
29002 0.6793940 48 165 0 9.596894 0.0000000 Texas
29070 0.0000000 48 175 0 8.792702 0.0000000 Texas
29138 0.9809342 48 183 0 11.627490 0.0000000 Texas
29189 1.0944510 48 189 0 10.506380 0.0000000 Texas
29308 1.1728240 48 203 0 10.996840 0.0000000 Texas
29325 0.0000000 48 205 0 8.558335 0.0000000 Texas
29342 1.6007680 48 207 0 8.739857 0.0000000 Texas
29393 0.6091618 48 213 0 11.092310 0.0000000 Texas
29461 0.0000000 48 221 0 10.462420 0.0000000 Texas
29478 0.3283533 48 223 0 10.324010 0.0000000 Texas
29495 0.4553320 48 225 0 9.997069 0.0000000 Texas
29512 1.5227190 48 227 0 10.399280 0.0000000 Texas
29614 0.6069066 48 241 0 10.402870 0.0000000 Texas
29699 0.0000000 48 255 0 9.438829 0.0000000 Texas
29733 0.5091909 48 259 0 9.885273 0.0000000 Texas
29784 0.0000000 48 269 0 5.817111 0.0000000 Texas
29801 0.6595218 48 273 0 10.319730 0.0000000 Texas
29835 0.2209700 48 277 0 10.720070 0.0000000 Texas
29869 1.1652970 48 281 0 9.750511 0.0000000 Texas
29920 0.6924249 48 287 0 9.577896 0.0000000 Texas
29954 1.1059500 48 291 0 11.055550 0.0000000 Texas
30022 0.0000000 48 299 0 9.461955 0.0000000 Texas
30073 10.6253800 48 305 0 8.793005 0.0000000 Texas
30090 0.0000000 48 307 0 9.070389 0.0000000 Texas
30158 3.8350910 48 315 0 9.252441 0.0000000 Texas
30209 0.0000000 48 321 0 10.550380 0.0000000 Texas
30243 0.2827815 48 325 0 10.473420 0.0000000 Texas
30260 0.0000000 48 327 0 7.766840 0.0000000 Texas
30277 0.0861950 48 329 0 11.661480 0.0000000 Texas
30294 0.4171534 48 331 0 10.084640 0.0000000 Texas
30311 0.0000000 48 333 0 8.469473 0.0000000 Texas
30328 0.0000000 48 335 0 9.105202 0.0000000 Texas
30345 1.6638930 48 337 0 9.799792 0.0000000 Texas
30362 1.5050130 48 339 0 12.412460 0.0000000 Texas
30430 0.7075514 48 347 0 10.942580 0.0000000 Texas
30464 1.4026230 48 351 0 9.565144 0.0000000 Texas
30515 0.0000000 48 359 0 7.727535 0.0000000 Texas
30549 1.1781800 48 363 0 10.144980 0.0000000 Texas
30566 0.8734006 48 365 0 10.038850 0.0000000 Texas
30583 0.3943581 48 367 0 11.239450 0.0000000 Texas
30600 0.0000000 48 369 0 9.249849 0.0000000 Texas
30617 0.0000000 48 371 0 9.701922 0.0000000 Texas
30634 6.4579340 48 373 0 10.712330 0.0000000 Texas
30651 0.8284547 48 375 1 11.595760 0.0920505 Texas
30770 0.0000000 48 389 0 9.615338 0.0000000 Texas
30804 0.0000000 48 393 0 6.895683 0.0000000 Texas
30821 3.8654810 48 395 0 9.650014 0.0000000 Texas
30889 0.0000000 48 403 0 9.253687 0.0000000 Texas
30923 0.0000000 48 407 0 9.901335 0.0000000 Texas
30957 0.0000000 48 411 0 8.703506 0.0000000 Texas
30974 0.0000000 48 413 0 8.035279 0.0000000 Texas
31042 0.0000000 48 421 0 7.943783 0.0000000 Texas
31076 0.0000000 48 425 0 8.697179 0.0000000 Texas
31093 0.1852744 48 427 0 10.896260 0.0000000 Texas
31127 0.0000000 48 431 0 7.252054 0.0000000 Texas
31144 5.5157190 48 433 0 7.502738 0.0000000 Texas
31178 0.0000000 48 437 0 9.047233 0.0000000 Texas
31212 0.4912798 48 441 0 11.712840 0.0000000 Texas
31229 3.8188340 48 445 0 9.479833 0.0000000 Texas
31246 0.0000000 48 447 0 7.493874 0.0000000 Texas
31263 2.8102290 48 449 0 10.122980 0.0000000 Texas
31348 0.8593773 48 459 0 10.460500 0.0000000 Texas
31416 0.4697151 48 467 0 10.659120 0.0000000 Texas
31433 0.1226377 48 469 0 11.308860 0.0000000 Texas
31501 0.6990563 48 477 0 10.261510 0.0000000 Texas
31620 0.0504322 48 491 0 12.197470 0.0000000 Texas
32283 0.0000000 51 3 0 11.214370 0.0000000 Virginia
32385 0.5040746 51 15 0 10.993980 0.0000000 Virginia
32419 0.1895088 51 19 1 10.873660 0.1895088 Virginia
32436 0.0000000 51 21 0 8.829665 0.0000000 Virginia
32538 0.0000000 51 33 0 9.971100 0.0000000 Virginia
32555 0.0000000 51 35 0 10.229300 0.0000000 Virginia
32606 0.0000000 51 43 0 9.436918 0.0000000 Virginia
32640 0.9380570 51 47 0 10.372900 0.0000000 Virginia
32657 1.2746970 51 49 0 8.967631 0.0000000 Virginia
32674 0.0000000 51 51 0 9.763133 0.0000000 Virginia
32725 0.0997239 51 59 0 13.712920 0.0000000 Virginia
32742 0.0000000 51 61 0 10.854470 0.0000000 Virginia
32776 0.0000000 51 65 0 9.734300 0.0000000 Virginia
32793 0.4589893 51 67 1 10.682220 0.2294946 Virginia
32827 0.0000000 51 71 0 9.701922 0.0000000 Virginia
32844 0.0000000 51 73 0 10.424040 0.0000000 Virginia
32878 0.6090134 51 77 0 9.706255 0.0000000 Virginia
32895 0.0000000 51 79 0 9.470549 0.0000000 Virginia
32929 0.7982757 51 83 0 10.534250 0.0000000 Virginia
32980 0.1775379 51 89 0 10.938910 0.0000000 Virginia
33014 0.7044486 51 93 0 10.253830 0.0000000 Virginia
33031 0.4834421 51 95 0 10.630310 0.0000000 Virginia
33099 0.0000000 51 103 0 9.342946 0.0000000 Virginia
33133 0.0000000 51 107 0 11.722640 0.0000000 Virginia
33167 0.9005764 51 111 0 9.315061 0.0000000 Virginia
33218 0.9694306 51 117 0 10.340000 0.0000000 Virginia
33269 0.0000000 51 125 0 9.512590 0.0000000 Virginia
33286 0.8300822 51 127 0 9.396571 0.0000000 Virginia
33490 1.1665210 51 155 0 10.442610 0.0000000 Virginia
33575 0.4805228 51 165 0 11.041830 0.0000000 Virginia
33592 0.0000000 51 167 0 10.279660 0.0000000 Virginia
33609 0.0000000 51 169 0 10.041030 0.0000000 Virginia
33626 0.0000000 51 171 0 10.422640 0.0000000 Virginia
33677 0.2698837 51 177 0 11.213250 0.0000000 Virginia
33711 1.5610360 51 181 0 8.764991 0.0000000 Virginia
33728 0.9912767 51 183 0 9.219102 0.0000000 Virginia
33762 0.0000000 51 187 0 10.304910 0.0000000 Virginia
33796 0.6042661 51 193 0 9.714081 0.0000000 Virginia
33813 0.2532030 51 195 0 10.583900 0.0000000 Virginia
33830 1.5176230 51 197 0 10.179490 0.0000000 Virginia
33847 0.3635702 51 199 0 10.915270 0.0000000 Virginia
33864 0.3401766 51 510 0 11.674920 0.0000000 Virginia
33881 0.0000000 51 520 0 9.795735 0.0000000 Virginia
33915 0.4679165 51 550 0 12.167030 0.0000000 Virginia
33949 0.9528347 51 600 0 9.951801 0.0000000 Virginia
33983 0.8648213 51 650 0 11.840480 0.0000000 Virginia
34068 0.0000000 51 730 1 10.551480 0.2615473 Virginia
34085 2.9612670 51 740 0 11.525920 0.0000000 Virginia
34153 0.8064516 51 790 1 10.118600 0.4032258 Virginia
34170 0.6791056 51 800 0 10.983610 0.0000000 Virginia
34969 0.0000000 54 9 0 10.187650 0.0000000 West Virginia
34986 0.5198694 54 11 0 11.473960 0.0000000 West Virginia
35037 0.0000000 54 17 0 8.886685 0.0000000 West Virginia
35054 0.2044655 54 19 0 10.797700 0.0000000 West Virginia
35071 1.3919820 54 21 0 8.879612 0.0000000 West Virginia
35139 0.2881429 54 29 0 10.454640 0.0000000 West Virginia
35224 0.4390929 54 39 0 12.230610 0.0000000 West Virginia
35241 0.0000000 54 41 0 9.778038 0.0000000 West Virginia
35258 0.4514673 54 43 0 10.005590 0.0000000 West Virginia
35275 0.0000000 54 45 0 10.641580 0.0000000 West Virginia
35309 0.1736986 54 49 0 10.960770 0.0000000 West Virginia
35360 0.7749415 54 55 0 11.074750 0.0000000 West Virginia
35394 0.3031589 54 59 0 10.403840 0.0000000 West Virginia
35428 0.7683442 54 63 0 9.473858 0.0000000 West Virginia
35496 0.0000000 54 71 0 9.001100 0.0000000 West Virginia
35513 0.0000000 54 73 0 8.920523 0.0000000 West Virginia
35615 0.9721952 54 85 0 9.238539 0.0000000 West Virginia
35632 0.6493506 54 87 0 9.642123 0.0000000 West Virginia
35717 0.0000000 54 97 0 10.070700 0.0000000 West Virginia
35751 0.0000000 54 101 0 9.251482 0.0000000 West Virginia
35768 1.0702050 54 103 0 9.835637 0.0000000 West Virginia
35802 0.3418024 54 107 0 11.382470 0.0000000 West Virginia
statecode region fit lwr upr
34 AL South 6.501271 -30.36444 43.36698
51 AL South 6.508809 -30.35668 43.37430
68 AL South 6.523884 -30.34120 43.38897
119 AL South 6.546497 -30.31806 43.41105
153 AL South 6.561572 -30.30267 43.42582
170 AL South 6.569110 -30.29500 43.43322
221 AL South 6.599260 -30.26439 43.46291
238 AL South 6.606798 -30.25676 43.47036
323 AL South 6.644486 -30.21877 43.50774
340 AL South 6.652024 -30.21120 43.51525
357 AL South 6.659561 -30.20365 43.52277
459 AL South 6.704787 -30.15850 43.56807
476 AL South 6.712324 -30.15101 43.57566
544 AL South 6.742475 -30.12115 43.60610
595 AL South 6.765088 -30.09885 43.62903
629 AL South 6.787701 -30.07665 43.65205
646 AL South 6.795238 -30.06927 43.65974
680 AL South 6.810313 -30.05453 43.67516
748 AL South 6.840464 -30.02518 43.70611
782 AL South 6.863077 -30.00327 43.72942
816 AL South 6.878152 -29.98871 43.74502
850 AL South 6.893227 -29.97419 43.76065
918 AL South 6.923377 -29.94527 43.79203
952 AL South 6.938453 -29.93087 43.80778
986 AL South 6.953528 -29.91651 43.82356
1020 AL South 6.968603 -29.90219 43.83939
1037 AL South 6.983678 -29.88790 43.85526
1207 AR South 6.290717 -30.56206 43.14349
1224 AR South 6.298254 -30.55427 43.15078
1258 AR South 6.313330 -30.53872 43.16538
1377 AR South 6.366093 -30.48463 43.21681
1428 AR South 6.388706 -30.46159 43.23900
1462 AR South 6.403781 -30.44628 43.25384
1479 AR South 6.411319 -30.43864 43.26128
1496 AR South 6.418856 -30.43101 43.26872
1513 AR South 6.426394 -30.42339 43.27618
1530 AR South 6.433931 -30.41578 43.28364
1649 AR South 6.486695 -30.36278 43.33617
1802 AR South 6.554533 -30.29535 43.40441
1819 AR South 6.562071 -30.28790 43.41204
1836 AR South 6.569608 -30.28047 43.41969
1887 AR South 6.592221 -30.25823 43.44267
1921 AR South 6.607296 -30.24345 43.45804
1938 AR South 6.614834 -30.23607 43.46574
1955 AR South 6.622372 -30.22871 43.47345
2057 AR South 6.675135 -30.17743 43.52770
2091 AR South 6.690210 -30.16286 43.54328
2108 AR South 6.697748 -30.15560 43.55109
2329 AR South 6.803274 -30.05489 43.66144
2346 AR South 6.810812 -30.04777 43.66939
2414 AR South 6.840962 -30.01939 43.70131
4505 DE South 6.027524 -30.81184 42.86689
4522 DE South 6.035061 -30.80401 42.87414
10132 LA South 5.388322 -31.43180 42.20845
10183 LA South 5.418473 -31.40013 42.23707
10200 LA South 5.426010 -31.39223 42.24425
10268 LA South 5.493849 -31.32162 42.30932
10302 LA South 5.531537 -31.28274 42.34581
10336 LA South 5.554149 -31.25953 42.36783
10370 LA South 5.569225 -31.24410 42.38255
10438 LA South 5.599375 -31.21337 42.41212
10455 LA South 5.614450 -31.19806 42.42696
10523 LA South 5.667214 -31.14479 42.47922
10540 LA South 5.682289 -31.12966 42.49424
10557 LA South 5.719977 -31.09200 42.53196
10574 LA South 5.750127 -31.06206 42.56231
10625 LA South 5.772740 -31.03970 42.58518
10693 LA South 5.810428 -31.00263 42.62349
10744 LA South 5.833041 -30.98051 42.64659
11118 MD South 5.320733 -31.49590 42.13736
11152 MD South 5.335808 -31.48010 42.15172
11220 MD South 5.365958 -31.44864 42.18056
11356 MD South 5.426259 -31.38618 42.23870
11390 MD South 5.441335 -31.37066 42.25333
14569 MS South 5.147866 -31.66513 41.96087
14586 MS South 5.155404 -31.65725 41.96806
14654 MS South 5.230780 -31.57895 42.04051
14688 MS South 5.245855 -31.56341 42.05512
14705 MS South 5.283543 -31.52473 42.09181
14756 MS South 5.321231 -31.48629 42.12875
14773 MS South 5.336306 -31.47098 42.14359
14807 MS South 5.351382 -31.45571 42.15848
14824 MS South 5.373994 -31.43289 42.18088
14858 MS South 5.396607 -31.41015 42.20336
14875 MS South 5.404145 -31.40259 42.21088
14892 MS South 5.426758 -31.37997 42.23348
14943 MS South 5.464446 -31.34247 42.27136
14977 MS South 5.524747 -31.28297 42.33246
14994 MS South 5.532284 -31.27558 42.34014
15011 MS South 5.547359 -31.26082 42.35554
15062 MS South 5.637811 -31.17311 42.44873
15079 MS South 5.645348 -31.16586 42.45656
19244 NC South 4.621355 -32.19776 41.44047
19261 NC South 4.628893 -32.18974 41.44752
19329 NC South 4.659043 -32.15773 41.47582
19431 NC South 4.704269 -32.11002 41.51856
19482 NC South 4.726882 -32.08630 41.54007
19533 NC South 4.749494 -32.06267 41.56166
19550 NC South 4.757032 -32.05481 41.56887
19567 NC South 4.764570 -32.04696 41.57610
19584 NC South 4.772107 -32.03912 41.58334
19618 NC South 4.787182 -32.02348 41.59784
19737 NC South 4.847483 -31.96128 41.65625
19907 NC South 4.930397 -31.87678 41.73758
19924 NC South 4.937935 -31.86916 41.74503
19958 NC South 4.953010 -31.85395 41.75997
20009 NC South 4.975623 -31.83120 41.78244
20026 NC South 4.990698 -31.81608 41.79748
20077 NC South 5.013311 -31.79348 41.82010
20094 NC South 5.020848 -31.78596 41.82766
20128 NC South 5.043461 -31.76348 41.85040
20179 NC South 5.073612 -31.73364 41.88086
20247 NC South 5.103762 -31.70395 41.91148
20315 NC South 5.133912 -31.67443 41.94225
20366 NC South 5.156525 -31.65239 41.96544
20383 NC South 5.164063 -31.64506 41.97318
20417 NC South 5.179138 -31.63043 41.98871
20434 NC South 5.186676 -31.62313 41.99648
20468 NC South 5.201751 -31.60857 42.01207
20502 NC South 5.216826 -31.59404 42.02769
20570 NC South 5.246976 -31.56510 42.05905
20621 NC South 5.269589 -31.54350 42.08268
20655 NC South 5.284665 -31.52915 42.09848
20706 NC South 5.307277 -31.50770 42.12225
22219 OK South 4.448364 -32.37516 41.27189
22236 OK South 4.455902 -32.36709 41.27889
22253 OK South 4.463439 -32.35903 41.28591
22287 OK South 4.478514 -32.34294 41.29997
22321 OK South 4.493590 -32.32689 41.31407
22338 OK South 4.501127 -32.31888 41.32114
22389 OK South 4.523740 -32.29491 41.34239
22423 OK South 4.538815 -32.27898 41.35661
22440 OK South 4.546353 -32.27103 41.36374
22457 OK South 4.553890 -32.26309 41.37087
22474 OK South 4.561428 -32.25516 41.37801
22508 OK South 4.576503 -32.23932 41.39233
22678 OK South 4.651879 -32.16075 41.46451
22695 OK South 4.659417 -32.15294 41.47178
22763 OK South 4.689567 -32.12183 41.50096
22831 OK South 4.719718 -32.09087 41.53030
22882 OK South 4.742331 -32.06775 41.55241
22899 OK South 4.749868 -32.06006 41.55980
22916 OK South 4.757406 -32.05239 41.56720
22950 OK South 4.772481 -32.03707 41.58203
23018 OK South 4.802631 -32.00654 41.61180
23035 OK South 4.810169 -31.99893 41.61927
23103 OK South 4.840320 -31.96860 41.64924
23137 OK South 4.855395 -31.95349 41.66428
23256 OK South 4.908158 -31.90093 41.71725
23273 OK South 4.915696 -31.89346 41.72485
23307 OK South 4.930771 -31.87855 41.74009
23324 OK South 4.938308 -31.87111 41.74773
23358 OK South 4.953384 -31.85626 41.76303
23375 OK South 4.960921 -31.84885 41.77069
23409 OK South 4.975996 -31.83406 41.78605
23443 OK South 4.991072 -31.81930 41.80145
23494 OK South 5.013684 -31.79725 41.82462
25364 SC South 4.185171 -32.64649 41.01683
25398 SC South 4.200246 -32.63028 41.03077
25483 SC South 4.237934 -32.58993 41.06580
25517 SC South 4.253009 -32.57386 41.07988
25602 SC South 4.290697 -32.53385 41.11525
25619 SC South 4.298235 -32.52588 41.12235
25653 SC South 4.313310 -32.50997 41.13659
25670 SC South 4.320848 -32.50203 41.14372
25687 SC South 4.328385 -32.49409 41.15086
25704 SC South 4.335923 -32.48617 41.15802
25823 SC South 4.388686 -32.43099 41.20836
25874 SC South 4.411299 -32.40749 41.23009
25891 SC South 4.418837 -32.39967 41.23735
25908 SC South 4.426374 -32.39187 41.24462
26027 SC South 4.479137 -32.33751 41.29579
26044 SC South 4.486675 -32.32979 41.30314
26061 SC South 4.494213 -32.32207 41.31049
26078 SC South 4.501750 -32.31436 41.31786
26112 SC South 4.516825 -32.29898 41.33263
26469 TN South 4.072356 -32.76401 40.90872
26605 TN South 4.147732 -32.68311 40.97857
26639 TN South 4.177882 -32.65102 41.00678
26673 TN South 4.200495 -32.62706 41.02805
26690 TN South 4.238183 -32.58731 41.06368
26707 TN South 4.245721 -32.57940 41.07084
26809 TN South 4.290946 -32.53209 41.11398
26877 TN South 4.336172 -32.48514 41.15748
26911 TN South 4.358785 -32.46179 41.17936
26928 TN South 4.366322 -32.45403 41.18667
26979 TN South 4.388935 -32.43080 41.20867
26996 TN South 4.404010 -32.41537 41.22339
27013 TN South 4.419086 -32.39997 41.23814
27030 TN South 4.434161 -32.38462 41.25294
27081 TN South 4.456774 -32.36165 41.27520
27115 TN South 4.486924 -32.33118 41.30503
27166 TN South 4.532150 -32.28576 41.35006
27183 TN South 4.539687 -32.27822 41.35759
27302 TN South 4.615063 -32.20340 41.43353
27353 TN South 4.652751 -32.16636 41.47186
27370 TN South 4.660289 -32.15898 41.47956
27387 TN South 4.667827 -32.15161 41.48727
27421 TN South 4.682902 -32.13690 41.50271
27455 TN South 4.705515 -32.11492 41.52595
27506 TN South 4.735665 -32.08573 41.55707
27523 TN South 4.743203 -32.07846 41.56487
27557 TN South 4.758278 -32.06395 41.58051
27608 TX South 4.019717 -32.81890 40.85833
27676 TX South 4.049868 -32.78639 40.88612
27778 TX South 4.095093 -32.73791 40.92810
27795 TX South 4.102631 -32.72987 40.93513
27812 TX South 4.110168 -32.72184 40.94217
27846 TX South 4.125244 -32.70579 40.95628
27880 TX South 4.140319 -32.68979 40.97043
27931 TX South 4.162932 -32.66587 40.99173
27965 TX South 4.178007 -32.64996 41.00598
27982 TX South 4.185544 -32.64203 41.01312
28016 TX South 4.200620 -32.62618 41.02742
28033 TX South 4.208157 -32.61828 41.03459
28050 TX South 4.215695 -32.61038 41.04177
28067 TX South 4.223233 -32.60249 41.04896
28084 TX South 4.230770 -32.59461 41.05615
28101 TX South 4.238308 -32.58674 41.06336
28118 TX South 4.245845 -32.57889 41.07058
28152 TX South 4.260921 -32.56320 41.08504
28186 TX South 4.275996 -32.54755 41.09954
28220 TX South 4.291071 -32.53194 41.11409
28356 TX South 4.351372 -32.46990 41.17265
28407 TX South 4.373985 -32.44680 41.19477
28424 TX South 4.381522 -32.43912 41.20216
28458 TX South 4.396597 -32.42379 41.21698
28509 TX South 4.419210 -32.40086 41.23928
28560 TX South 4.441823 -32.37802 41.26167
28577 TX South 4.449361 -32.37043 41.26915
28611 TX South 4.464436 -32.35527 41.28414
28628 TX South 4.471974 -32.34771 41.29166
28730 TX South 4.517199 -32.30253 41.33693
28781 TX South 4.539812 -32.28008 41.35970
28798 TX South 4.547350 -32.27261 41.36731
28832 TX South 4.562425 -32.25771 41.38256
28934 TX South 4.607650 -32.21324 41.42854
28985 TX South 4.630263 -32.19114 41.45167
29002 TX South 4.637801 -32.18380 41.45940
29070 TX South 4.675489 -32.14721 41.49818
29138 TX South 4.705639 -32.11811 41.52939
29189 TX South 4.728252 -32.09639 41.55290
29308 TX South 4.781015 -32.04606 41.60809
29325 TX South 4.788553 -32.03891 41.61601
29342 TX South 4.796091 -32.03177 41.62395
29393 TX South 4.818703 -32.01040 41.64781
29461 TX South 4.848854 -31.98205 41.67976
29478 TX South 4.856391 -31.97499 41.68777
29495 TX South 4.863929 -31.96794 41.69579
29512 TX South 4.871467 -31.96089 41.70383
29614 TX South 4.924230 -31.91187 41.76033
29699 TX South 4.976993 -31.86332 41.81731
29733 TX South 4.992068 -31.84954 41.83367
29784 TX South 5.029756 -31.81525 41.87477
29801 TX South 5.044832 -31.80161 41.89127
29835 TX South 5.059907 -31.78800 41.90782
29869 TX South 5.074982 -31.77444 41.92440
29920 TX South 5.097595 -31.75416 41.94935
29954 TX South 5.112670 -31.74069 41.96603
30022 TX South 5.142821 -31.71387 41.99951
30073 TX South 5.165433 -31.69386 42.02473
30090 TX South 5.172971 -31.68721 42.03315
30158 TX South 5.203121 -31.66070 42.06694
30209 TX South 5.225734 -31.64092 42.09239
30243 TX South 5.240809 -31.62779 42.10941
30260 TX South 5.248347 -31.62124 42.11793
30277 TX South 5.255885 -31.61469 42.12646
30294 TX South 5.263422 -31.60816 42.13500
30311 TX South 5.270960 -31.60163 42.14355
30328 TX South 5.278497 -31.59512 42.15212
30345 TX South 5.286035 -31.58862 42.16069
30362 TX South 5.293573 -31.58212 42.16927
30430 TX South 5.323723 -31.55624 42.20369
30464 TX South 5.338798 -31.54336 42.22096
30515 TX South 5.368949 -31.51771 42.25561
30549 TX South 5.384024 -31.50495 42.27300
30566 TX South 5.391562 -31.49858 42.28170
30583 TX South 5.399099 -31.49222 42.29042
30600 TX South 5.406637 -31.48588 42.29915
30617 TX South 5.414174 -31.47954 42.30789
30634 TX South 5.421712 -31.47321 42.31663
30651 TX South 5.429250 -31.46689 42.32539
30770 TX South 5.482013 -31.42293 42.38696
30804 TX South 5.497088 -31.41046 42.40464
30821 TX South 5.504626 -31.40424 42.41349
30889 TX South 5.534776 -31.37945 42.44901
30923 TX South 5.549851 -31.36712 42.46682
30957 TX South 5.564926 -31.35482 42.48468
30974 TX South 5.572464 -31.34869 42.49362
31042 TX South 5.602615 -31.32425 42.52948
31076 TX South 5.617690 -31.31209 42.54747
31093 TX South 5.625227 -31.30603 42.55648
31127 TX South 5.640303 -31.29393 42.57453
31144 TX South 5.647840 -31.28789 42.58357
31178 TX South 5.662915 -31.27585 42.60168
31212 TX South 5.677991 -31.26384 42.61983
31229 TX South 5.693066 -31.25188 42.63801
31246 TX South 5.700603 -31.24591 42.64712
31263 TX South 5.708141 -31.23995 42.65623
31348 TX South 5.745829 -31.21031 42.70197
31416 TX South 5.775979 -31.18677 42.73873
31433 TX South 5.783517 -31.18090 42.74794
31501 TX South 5.813667 -31.15756 42.78489
31620 TX South 5.866431 -31.11707 42.84993
32283 VA South 3.869339 -32.97614 40.71481
32385 VA South 3.914564 -32.92734 40.75647
32419 VA South 3.929640 -32.91116 40.77044
32436 VA South 3.937177 -32.90308 40.77743
32538 VA South 3.982403 -32.85481 40.81962
32555 VA South 3.989940 -32.84680 40.82668
32606 VA South 4.020091 -32.81486 40.85504
32640 VA South 4.035166 -32.79895 40.86928
32657 VA South 4.042704 -32.79101 40.87642
32674 VA South 4.050241 -32.78308 40.88356
32725 VA South 4.080392 -32.75145 40.91223
32742 VA South 4.087929 -32.74357 40.91943
32776 VA South 4.103005 -32.72783 40.93384
32793 VA South 4.110542 -32.71998 40.94107
32827 VA South 4.125617 -32.70430 40.95554
32844 VA South 4.133155 -32.69648 40.96279
32878 VA South 4.148230 -32.68086 40.97732
32895 VA South 4.155768 -32.67307 40.98461
32929 VA South 4.170843 -32.65751 40.99920
32980 VA South 4.193456 -32.63425 41.02116
33014 VA South 4.208531 -32.61879 41.03585
33031 VA South 4.216069 -32.61107 41.04321
33099 VA South 4.246219 -32.58031 41.07275
33133 VA South 4.261294 -32.56499 41.08758
33167 VA South 4.276370 -32.54970 41.10244
33218 VA South 4.298982 -32.52685 41.12482
33269 VA South 4.329133 -32.49652 41.15479
33286 VA South 4.336670 -32.48896 41.16230
33490 VA South 4.442197 -32.38418 41.26857
33575 VA South 4.479885 -32.34722 41.30699
33592 VA South 4.487423 -32.33986 41.31471
33609 VA South 4.494960 -32.33251 41.32243
33626 VA South 4.502498 -32.32517 41.33016
33677 VA South 4.525111 -32.30320 41.35342
33711 VA South 4.540186 -32.28860 41.36897
33728 VA South 4.547723 -32.28132 41.37677
33762 VA South 4.562799 -32.26678 41.39238
33796 VA South 4.585411 -32.24505 41.41587
33813 VA South 4.592949 -32.23783 41.42372
33830 VA South 4.600487 -32.23061 41.43159
33847 VA South 4.608024 -32.22341 41.43946
33864 VA South 5.780122 -31.22215 42.78239
33881 VA South 5.817810 -31.19386 42.82948
33915 VA South 5.930874 -31.11045 42.97220
33949 VA South 6.119314 -30.97625 43.21488
33983 VA South 6.307755 -30.84806 43.46357
34068 VA South 6.609259 -30.65537 43.87389
34085 VA South 6.646947 -30.63235 43.92625
34153 VA South 6.835387 -30.52081 44.19158
34170 VA South 6.873075 -30.49921 44.24536
34969 WV South 3.734036 -33.11811 40.58618
34986 WV South 3.741573 -33.10996 40.59310
35037 WV South 3.764186 -33.08556 40.61393
35054 WV South 3.771724 -33.07745 40.62090
35071 WV South 3.779261 -33.06935 40.62787
35139 WV South 3.809412 -33.03703 40.65586
35224 WV South 3.847100 -32.99687 40.69106
35241 WV South 3.854637 -32.98886 40.69814
35258 WV South 3.862175 -32.98087 40.70522
35275 WV South 3.869713 -32.97288 40.71231
35309 WV South 3.884788 -32.95694 40.72652
35360 WV South 3.907401 -32.93311 40.74791
35394 WV South 3.922476 -32.91726 40.76221
35428 WV South 3.937551 -32.90146 40.77656
35496 WV South 3.967701 -32.86997 40.80538
35513 WV South 3.975239 -32.86213 40.81260
35615 WV South 4.020465 -32.81525 40.85618
35632 WV South 4.028002 -32.80747 40.86347
35717 WV South 4.065690 -32.76872 40.90010
35751 WV South 4.080766 -32.75329 40.91482
35768 WV South 4.088303 -32.74559 40.92220
35802 WV South 4.103378 -32.73022 40.93698
# Random sample
set.seed(123)
subset(test_w_predict, runif(nrow(test_w_predict)) < 0.1) arrests countyid density popul perc1019 perc2029 percblack
170 0 1021 50.892910 35323 14.80339 12.643320 11.9214100
680 4 1085 17.842560 12811 18.77293 14.620250 75.4898100
1462 3 5033 82.408290 49074 16.27542 12.473000 0.9944166
2329 2 5139 44.308320 46036 15.00999 12.203490 32.5071700
2737 1105 6037 2248.231000 9127751 13.98491 16.162680 11.2478300
3213 2 6093 7.028981 44193 14.77610 7.349580 1.6948390
4318 12 8123 38.116120 152189 16.77454 14.197480 0.5355183
4981 0 16045 25.113730 14129 15.86100 10.729700 0.0990870
5525 0 17027 74.575210 35368 15.12667 13.073970 3.9696900
6205 0 17111 381.620800 230555 14.67242 11.545620 0.2103620
6358 0 17129 39.325880 12359 15.10640 9.482967 0.0890040
9724 0 20159 13.823050 10044 14.38670 8.582238 0.9060135
10064 0 20203 3.792261 2725 17.46789 9.357799 0.0366972
10438 3 22057 80.909730 87772 16.91883 15.572160 13.5669700
12410 0 26087 130.636100 85479 17.18434 11.878940 0.8341230
12512 13 26099 1529.152000 734625 13.47654 13.856460 1.6362090
12563 0 26105 55.988490 27725 14.70153 9.915239 0.8512173
12818 0 26135 15.530080 8775 12.02279 9.082621 0.0227920
13022 3 26159 123.252400 75308 15.84559 10.658890 7.4201950
13090 0 27001 7.538299 13715 13.68575 6.022603 0.1531170
13192 0 27013 72.035950 54199 17.39331 20.367530 0.5535157
13345 0 27031 3.231460 4688 13.28925 7.401877 0.1919795
13532 81 27053 1902.034000 1058746 12.68690 15.403790 7.5965340
13702 0 27073 10.756930 8228 14.93680 6.332037 0.1458435
14008 3 27109 173.315900 113182 14.73556 13.119580 0.9480306
14212 0 27135 9.753057 16215 16.23805 12.722790 0.0493370
14756 8 28067 91.437790 63447 15.56417 12.736620 26.3022700
14807 8 28075 109.424400 76987 15.36883 14.760930 36.4672000
16184 1 31013 12.074890 12984 17.59858 8.710721 0.4004929
16830 0 31129 9.344859 5376 14.69494 6.677827 0.0186012
17578 8 34009 384.981400 98252 11.67508 10.495460 6.4293860
18122 8 35061 56.402990 60214 16.62238 11.299700 1.5212410
19244 5 37007 45.717950 24302 14.77656 12.994810 48.7696500
20026 2 37105 184.586800 47483 13.63014 12.311780 23.1682900
20842 1 38017 64.193820 113343 14.88579 18.897510 0.3493820
21131 1 39009 120.693000 61162 18.61286 24.108110 3.0345640
21590 0 39073 67.220530 28413 14.94034 11.716470 1.0558550
21726 3 39103 329.619800 138943 15.84895 11.262890 0.7708197
21879 1 39135 100.358500 42633 15.41998 11.756150 0.3940609
22253 0 40007 3.314252 6013 16.53085 9.263263 0.1330451
22474 0 40033 10.804490 6879 14.92950 11.048120 2.2532340
22899 1 40083 41.552810 30940 18.89140 14.124110 17.1008400
23103 1 40107 18.181220 11358 15.45166 11.260790 12.1676300
23307 3 40131 94.140870 63536 16.55125 11.173190 0.8750944
23511 0 41001 5.348842 16410 14.21085 8.665448 0.1889092
23902 17 41047 220.195600 260919 14.92609 13.084140 1.1106900
24072 8 41067 530.025000 383603 14.25458 13.877630 0.8169905
24650 0 42063 108.607600 90073 16.84078 15.445250 1.4543760
24667 0 42065 71.127170 46624 14.58476 10.603980 0.1158202
25330 0 44009 355.021900 118175 14.17559 14.300830 1.1026020
25908 0 45067 71.346400 34895 17.38358 11.669290 55.2486000
26061 15 45085 161.036800 107161 14.58460 17.537160 44.6001800
26180 0 46015 6.766238 5541 18.48042 9.601155 0.1624255
26809 2 47059 94.261210 58613 13.42535 12.579120 2.3527200
26877 2 47071 42.509400 24566 14.23105 11.560690 4.7301150
27081 2 47103 50.425210 28756 13.50327 12.101820 9.1980800
27353 4 47155 103.557800 61335 13.49963 12.627370 0.4418358
28050 0 48053 29.897290 29753 13.48772 8.775585 2.0166030
28101 0 48059 13.998800 12580 14.16534 8.394277 0.0158983
28560 114 48113 2273.644000 2000192 13.83477 16.485920 20.6574700
28934 19 48157 350.703800 306832 16.60713 10.890980 21.1496800
29189 4 48189 36.379450 36548 16.62198 13.776400 5.9592860
29325 0 48205 3.562746 5210 12.09213 29.731290 0.2303263
30090 0 48307 8.130514 8694 14.83782 8.902692 2.0013800
30311 0 48333 6.371581 4767 13.71932 7.216279 0.2517307
30464 2 48351 15.289090 14259 16.60706 10.274210 23.6271800
30957 0 48411 5.310470 6024 14.70784 12.217800 1.3114210
30974 0 48413 2.356141 3088 17.22798 8.354922 1.2305700
31416 2 48467 50.172710 42579 14.55177 9.093685 4.0395500
31960 0 49025 1.440810 5751 19.75309 10.067810 0.0695531
32028 0 49037 1.690815 13221 22.07851 12.888590 0.1210196
32215 0 50019 36.045450 25117 14.73902 9.603058 0.3145280
32538 0 51033 40.183730 21399 13.96327 13.164170 40.6280700
32674 0 51051 52.253960 17381 16.77694 10.793400 0.4315057
33677 2 51177 184.863500 74106 15.51156 12.716920 12.0165700
33813 1 51195 97.931510 39494 16.36198 11.224490 2.0104320
34425 0 53023 3.245505 2306 14.57069 6.201214 0.0000000
34799 6 53067 271.116500 197109 15.59340 11.668670 2.0836190
35360 5 54055 153.452100 64521 14.61075 13.101160 6.3731190
35428 1 54063 27.494980 13015 13.61506 12.178260 1.3215520
35615 1 54085 22.682620 10286 13.51351 12.521870 0.0680537
35955 0 55017 53.787280 54348 15.95091 11.113560 0.0643998
36278 1 55057 30.941920 23753 15.42121 10.276600 0.1978697
36635 0 55103 30.634760 17958 15.89264 9.906448 0.1392137
36754 3 55117 213.595900 109705 15.25728 12.141650 0.6681555
37349 0 56045 2.733472 6554 16.90571 9.642966 0.0762893
percmale rpcincmaint rpcpersinc rpcunemins year murders murdrate
170 48.60006 231.594 10819.840 40.194 1996 0 0.0000000
680 46.46007 602.910 8227.648 62.524 1996 0 0.0000000
1462 49.07894 190.762 9857.100 58.058 1996 1 0.2037739
2329 47.36293 278.806 13806.960 70.818 1996 1 0.2172213
2737 49.98259 463.826 15914.910 55.506 1996 1403 1.5370710
3213 49.52594 518.694 11963.140 100.166 1996 2 0.4525604
4318 49.61791 167.794 12331.260 27.434 1996 8 0.5256622
4981 50.31496 162.690 10803.250 75.922 1996 0 0.0000000
5525 51.62576 95.700 13161.300 70.818 1996 0 0.0000000
6205 50.25785 38.918 17693.020 65.714 1996 0 0.0000000
6358 48.14305 119.306 13650.010 56.144 1996 0 0.0000000
9724 47.83951 163.328 11949.740 34.452 1996 0 0.0000000
10064 49.98165 132.066 22147.530 24.882 1996 0 0.0000000
10438 48.89600 232.870 11172.660 12.122 1996 7 0.7975209
12410 50.47322 80.388 13630.230 68.266 1996 0 0.0000000
12512 48.78489 79.750 16344.280 65.076 1996 16 0.2177982
12563 49.17223 193.952 11792.790 107.822 1996 0 0.0000000
12818 49.54986 204.798 8860.544 105.270 1996 0 0.0000000
13022 49.10899 214.368 11527.380 84.216 1996 2 0.2655760
13090 49.69012 251.372 10866.420 100.804 1996 0 0.0000000
13192 49.78690 143.550 14222.930 45.936 1996 0 0.0000000
13345 50.19198 101.442 14257.390 89.958 1996 0 0.0000000
13532 48.60986 235.422 22058.210 44.660 1996 89 0.8406171
13702 49.64754 156.310 13124.940 31.262 1996 0 0.0000000
14008 48.79663 135.256 16892.960 30.624 1996 5 0.4417664
14212 51.41536 95.700 13054.760 66.990 1996 0 0.0000000
14756 47.76427 269.874 11663.280 18.502 1996 0 0.0000000
14807 47.33916 319.000 12678.340 31.262 1996 5 0.6494603
16184 49.59180 114.840 13060.500 37.642 1996 1 0.7701787
16830 48.40030 107.822 12836.560 12.760 1996 0 0.0000000
17578 48.15373 140.360 16701.560 262.856 1996 4 0.4071164
18122 50.34211 276.254 10053.600 22.330 1996 2 0.3321487
19244 48.94659 330.484 11670.300 33.814 1996 4 1.6459550
20026 48.42575 195.866 14275.890 37.004 1996 2 0.4212034
20842 50.01015 86.130 15396.850 19.140 1996 1 0.0882278
21131 49.27896 278.806 9441.762 44.022 1996 0 0.0000000
21590 50.29036 202.246 10439.590 56.144 1996 0 0.0000000
21726 49.39579 60.610 15675.020 38.918 1996 0 0.0000000
21879 49.59538 101.442 12279.590 31.900 1996 2 0.4691202
22253 50.27441 130.152 11385.750 9.570 1996 0 0.0000000
22474 47.59413 204.798 10158.870 23.606 1996 0 0.0000000
22899 49.46025 157.586 11210.300 14.674 1996 1 0.3232062
23103 50.86283 336.226 8482.210 26.158 1996 2 1.7608730
23307 49.62698 96.976 11670.930 24.244 1996 3 0.4721732
23511 50.10360 225.214 10886.190 126.962 1996 0 0.0000000
23902 49.75605 191.400 13307.400 79.112 1996 8 0.3066086
24072 49.17376 79.112 17423.140 65.714 1996 7 0.1824803
24650 48.48401 232.870 11935.700 119.306 1996 0 0.0000000
24667 48.53509 206.074 12338.280 135.894 1996 0 0.0000000
25330 49.12291 118.668 16686.890 81.664 1996 1 0.0846203
25908 45.49936 373.868 9655.492 47.212 1996 0 0.0000000
26061 49.62440 304.964 10398.120 26.796 1996 9 0.8398578
26180 49.88269 146.740 11367.250 14.036 1996 0 0.0000000
26809 48.54213 257.114 10911.080 72.094 1996 3 0.5118318
26877 48.49385 312.620 10403.230 70.818 1996 0 0.0000000
27081 48.31687 202.884 11173.930 85.492 1996 1 0.3477535
27353 48.77965 156.310 12802.110 75.284 1996 0 0.0000000
28050 49.22865 165.880 12314.680 24.244 1996 0 0.0000000
28101 48.33863 186.934 10286.470 28.710 1996 2 1.5898250
28560 49.22912 168.432 19194.870 39.556 1996 255 1.2748780
28934 50.23726 76.560 15198.440 21.692 1996 20 0.6518225
29189 49.67167 306.240 12425.690 28.710 1996 1 0.2736128
29325 61.20921 74.646 12141.140 10.208 1996 1 1.9193860
30090 47.82609 315.172 10507.860 36.366 1996 0 0.0000000
30311 49.10846 248.182 10443.420 19.778 1996 0 0.0000000
30464 48.69205 313.896 8851.612 54.868 1996 2 1.4026230
30957 53.23705 279.444 9809.888 30.624 1996 0 0.0000000
30974 49.22280 230.956 8671.696 42.746 1996 0 0.0000000
31416 48.92318 169.708 10869.610 22.330 1996 2 0.4697151
31960 50.65206 148.016 11336.620 33.814 1996 0 0.0000000
32028 49.80713 458.722 7126.460 24.882 1996 0 0.0000000
32215 49.47247 326.656 11288.130 86.130 1996 0 0.0000000
32538 49.49297 181.192 11513.350 23.606 1996 0 0.0000000
32674 48.99603 416.614 9303.954 79.750 1996 0 0.0000000
33677 49.74631 91.872 14469.840 11.484 1996 2 0.2698837
33813 48.37444 411.510 10874.710 69.542 1996 1 0.2532030
34425 48.74241 209.902 13816.530 82.940 1996 0 0.0000000
34799 48.96276 184.382 14717.380 102.718 1996 8 0.4058668
35360 47.09629 340.692 12000.780 37.642 1996 6 0.9299298
35428 48.65924 270.512 8871.390 30.624 1996 1 0.7683442
35615 48.79448 303.688 8873.304 95.700 1996 1 0.9721952
35955 49.47928 124.410 12535.420 82.940 1996 0 0.0000000
36278 49.48849 139.084 10821.760 102.080 1996 0 0.0000000
36635 49.64361 128.876 10491.910 56.144 1996 0 0.0000000
36754 49.85279 71.456 15045.950 75.284 1996 1 0.0911535
37349 50.13732 116.116 13198.940 40.194 1996 0 0.0000000
arrestrate statefips countyfips execs lpopul execrate statename
170 0.0000000 1 21 0 10.472290 0.0000000 Alabama
680 3.1223170 1 85 0 9.458059 0.0000000 Alabama
1462 0.6113217 5 33 0 10.801080 0.0000000 Arkansas
2329 0.4344426 5 139 0 10.737180 0.0000000 Arkansas
2737 1.2105940 6 37 1 16.026830 0.0010956 California
3213 0.4525603 6 93 0 10.696320 0.0000000 California
4318 0.7884933 8 123 0 11.932880 0.0000000 Colorado
4981 0.0000000 16 45 0 9.555984 0.0000000 Idaho
5525 0.0000000 17 27 0 10.473560 0.0000000 Illinois
6205 0.0000000 17 111 0 12.348240 0.0000000 Illinois
6358 0.0000000 17 129 0 9.422140 0.0000000 Illinois
9724 0.0000000 20 159 0 9.214730 0.0000000 Kansas
10064 0.0000000 20 203 0 7.910223 0.0000000 Kansas
10438 0.3417947 22 57 0 11.382500 0.0000000 Louisiana
12410 0.0000000 26 87 0 11.356030 0.0000000 Michigan
12512 0.1769610 26 99 0 13.507120 0.0000000 Michigan
12563 0.0000000 26 105 0 10.230090 0.0000000 Michigan
12818 0.0000000 26 135 0 9.079662 0.0000000 Michigan
13022 0.3983641 26 159 0 11.229340 0.0000000 Michigan
13090 0.0000000 27 1 0 9.526245 0.0000000 Minnesota
13192 0.0000000 27 13 0 10.900420 0.0000000 Minnesota
13345 0.0000000 27 31 0 8.452762 0.0000000 Minnesota
13532 0.7650560 27 53 0 13.872600 0.0000000 Minnesota
13702 0.0000000 27 73 0 9.015298 0.0000000 Minnesota
14008 0.2650598 27 109 0 11.636750 0.0000000 Minnesota
14212 0.0000000 27 135 0 9.693692 0.0000000 Minnesota
14756 1.2608950 28 67 0 11.057960 0.0000000 Mississippi
14807 1.0391370 28 75 0 11.251390 0.0000000 Mississippi
16184 0.7701787 31 13 0 9.471473 0.0000000 Nebraska
16830 0.0000000 31 129 0 8.589700 0.0000000 Nebraska
17578 0.8142328 34 9 0 11.495290 0.0000000 New Jersey
18122 1.3285950 35 61 0 11.005660 0.0000000 New Mexico
19244 2.0574440 37 7 0 10.098310 0.0000000 North Carolina
20026 0.4212034 37 105 0 10.768130 0.0000000 North Carolina
20842 0.0882278 38 17 0 11.638170 0.0000000 North Dakota
21131 0.1635002 39 9 0 11.021280 0.0000000 Ohio
21590 0.0000000 39 73 0 10.254600 0.0000000 Ohio
21726 0.2159159 39 103 0 11.841820 0.0000000 Ohio
21879 0.2345601 39 135 0 10.660380 0.0000000 Ohio
22253 0.0000000 40 7 0 8.701679 0.0000000 Oklahoma
22474 0.0000000 40 33 0 8.836228 0.0000000 Oklahoma
22899 0.3232062 40 83 0 10.339800 0.0000000 Oklahoma
23103 0.8804367 40 107 0 9.337678 0.0000000 Oklahoma
23307 0.4721733 40 131 0 11.059360 0.0000000 Oklahoma
23511 0.0000000 41 1 0 9.705647 0.0000000 Oregon
23902 0.6515433 41 47 0 12.471960 0.0000000 Oregon
24072 0.2085489 41 67 0 12.857360 0.0000000 Oregon
24650 0.0000000 42 63 0 11.408380 0.0000000 Pennsylvania
24667 0.0000000 42 65 0 10.749870 0.0000000 Pennsylvania
25330 0.0000000 44 9 0 11.679920 0.0000000 Rhode Island
25908 0.0000000 45 67 0 10.460100 0.0000000 South Carolina
26061 1.3997630 45 85 0 11.582090 0.0000000 South Carolina
26180 0.0000000 46 15 0 8.619930 0.0000000 South Dakota
26809 0.3412212 47 59 0 10.978710 0.0000000 Tennessee
26877 0.8141334 47 71 0 10.109120 0.0000000 Tennessee
27081 0.6955070 47 103 0 10.266600 0.0000000 Tennessee
27353 0.6521562 47 155 0 11.024110 0.0000000 Tennessee
28050 0.0000000 48 53 0 10.300680 0.0000000 Texas
28101 0.0000000 48 59 0 9.439863 0.0000000 Texas
28560 0.5699453 48 113 0 14.508750 0.0000000 Texas
28934 0.6192313 48 157 0 12.634060 0.0000000 Texas
29189 1.0944510 48 189 0 10.506380 0.0000000 Texas
29325 0.0000000 48 205 0 8.558335 0.0000000 Texas
30090 0.0000000 48 307 0 9.070389 0.0000000 Texas
30311 0.0000000 48 333 0 8.469473 0.0000000 Texas
30464 1.4026230 48 351 0 9.565144 0.0000000 Texas
30957 0.0000000 48 411 0 8.703506 0.0000000 Texas
30974 0.0000000 48 413 0 8.035279 0.0000000 Texas
31416 0.4697151 48 467 0 10.659120 0.0000000 Texas
31960 0.0000000 49 25 0 8.657129 0.0000000 Utah
32028 0.0000000 49 37 0 9.489562 0.0000000 Utah
32215 0.0000000 50 19 0 10.131300 0.0000000 Vermont
32538 0.0000000 51 33 0 9.971100 0.0000000 Virginia
32674 0.0000000 51 51 0 9.763133 0.0000000 Virginia
33677 0.2698837 51 177 0 11.213250 0.0000000 Virginia
33813 0.2532030 51 195 0 10.583900 0.0000000 Virginia
34425 0.0000000 53 23 0 7.743270 0.0000000 Washington
34799 0.3044001 53 67 0 12.191510 0.0000000 Washington
35360 0.7749415 54 55 0 11.074750 0.0000000 West Virginia
35428 0.7683442 54 63 0 9.473858 0.0000000 West Virginia
35615 0.9721952 54 85 0 9.238539 0.0000000 West Virginia
35955 0.0000000 55 17 0 10.903160 0.0000000 Wisconsin
36278 0.4209995 55 57 0 10.075460 0.0000000 Wisconsin
36635 0.0000000 55 103 0 9.795791 0.0000000 Wisconsin
36754 0.2734607 55 117 0 11.605550 0.0000000 Wisconsin
37349 0.0000000 56 45 0 8.787830 0.0000000 Wyoming
statecode region fit lwr upr
170 AL South 6.569110 -30.29500 43.43322
680 AL South 6.810313 -30.05453 43.67516
1462 AR South 6.403781 -30.44628 43.25384
2329 AR South 6.803274 -30.05489 43.66144
2737 CA West 6.366218 -30.48058 43.21302
3213 CA West 6.577270 -30.27070 43.42524
4318 CO West 6.585057 -30.26026 43.43037
4981 ID West 5.869981 -30.95231 42.69228
5525 IL Midwest 5.749504 -31.07275 42.57176
6205 IL Midwest 6.066084 -30.75503 42.88720
6358 IL Midwest 6.133922 -30.68921 42.95705
9724 KS Midwest 6.089070 -30.73331 42.91145
10064 KS Midwest 6.254898 -30.57845 43.08825
10438 LA South 5.599375 -31.21337 42.41212
12410 MI Midwest 5.501885 -31.30611 42.30988
12512 MI Midwest 5.547110 -31.26100 42.35522
12563 MI Midwest 5.569723 -31.23857 42.37802
12818 MI Midwest 5.682787 -31.12777 42.49335
13022 MI Midwest 5.773238 -31.04073 42.58720
13090 MN Midwest 5.125129 -31.69209 41.94235
13192 MN Midwest 5.170355 -31.64439 41.98510
13345 MN Midwest 5.238193 -31.57351 42.04989
13532 MN Midwest 5.321107 -31.48795 42.13017
13702 MN Midwest 5.396483 -31.41121 42.20417
14008 MN Midwest 5.532160 -31.27554 42.33986
14212 MN Midwest 5.630149 -31.17954 42.43984
14756 MS South 5.321231 -31.48629 42.12875
14807 MS South 5.351382 -31.45571 42.15848
16184 NE Midwest 4.959800 -31.85464 41.77424
16830 NE Midwest 5.396981 -31.40993 42.20389
17578 NJ Northeast 4.786809 -32.02960 41.60321
18122 NM West 4.930148 -31.87807 41.73836
19244 NC South 4.621355 -32.19776 41.44047
20026 NC South 4.990698 -31.81608 41.79748
20842 ND Midwest 4.606405 -32.21133 41.42414
21131 OH Midwest 4.523615 -32.29711 41.34434
21590 OH Midwest 4.764819 -32.04498 41.57461
21726 OH Midwest 4.877883 -31.93025 41.68602
21879 OH Midwest 4.998485 -31.81032 41.80728
22253 OK South 4.463439 -32.35903 41.28591
22474 OK South 4.561428 -32.25516 41.37801
22899 OK South 4.749868 -32.06006 41.55980
23103 OK South 4.840320 -31.96860 41.64924
23307 OK South 4.930771 -31.87855 41.74009
23511 OR West 4.388188 -32.43726 41.21364
23902 OR West 4.561553 -32.25376 41.37686
24072 OR West 4.636929 -32.17559 41.44945
24650 PA Northeast 4.569215 -32.24504 41.38347
24667 PA Northeast 4.576752 -32.23725 41.39076
25330 RI Northeast 4.260422 -32.56770 41.08855
25908 SC South 4.426374 -32.39187 41.24462
26061 SC South 4.494213 -32.32207 41.31049
26180 SD Midwest 4.177758 -32.65257 41.00808
26809 TN South 4.290946 -32.53209 41.11398
26877 TN South 4.336172 -32.48514 41.15748
27081 TN South 4.456774 -32.36165 41.27520
27353 TN South 4.652751 -32.16636 41.47186
28050 TX South 4.215695 -32.61038 41.04177
28101 TX South 4.238308 -32.58674 41.06336
28560 TX South 4.441823 -32.37802 41.26167
28934 TX South 4.607650 -32.21324 41.42854
29189 TX South 4.728252 -32.09639 41.55290
29325 TX South 4.788553 -32.03891 41.61601
30090 TX South 5.172971 -31.68721 42.03315
30311 TX South 5.270960 -31.60163 42.14355
30464 TX South 5.338798 -31.54336 42.22096
30957 TX South 5.564926 -31.35482 42.48468
30974 TX South 5.572464 -31.34869 42.49362
31416 TX South 5.775979 -31.18677 42.73873
31960 UT West 4.057530 -32.77675 40.89181
32028 UT West 4.102755 -32.72870 40.93421
32215 VT Northeast 3.982278 -32.85597 40.82053
32538 VA South 3.982403 -32.85481 40.81962
32674 VA South 4.050241 -32.78308 40.88356
33677 VA South 4.525111 -32.30320 41.35342
33813 VA South 4.592949 -32.23783 41.42372
34425 WA West 3.839438 -33.00572 40.68459
34799 WA West 4.005265 -32.83034 40.84087
35360 WV South 3.907401 -32.93311 40.74791
35428 WV South 3.937551 -32.90146 40.77656
35615 WV South 4.020465 -32.81525 40.85618
35955 WI Midwest 3.711547 -33.14125 40.56434
36278 WI Midwest 3.862300 -32.98070 40.70530
36635 WI Midwest 4.035664 -32.80093 40.87226
36754 WI Midwest 4.088428 -32.74725 40.92411
37349 WY West 3.764435 -33.08415 40.61302
p <- ggplot(data = test_w_predict,
aes(x = arrests,
y = fit, ymin = lwr, ymax = upr))ggplot2 explore (Intro Section)
This is just replication of the first section within Chapter 6 (as FYI)
pip <- lm(arrests ~ density, data=train)
summary(pip)
Call:
lm(formula = arrests ~ density, data = train)
Residuals:
Min 1Q Median 3Q Max
-98.064 -3.913 -3.747 -1.635 255.688
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 3.7414458 0.4404669 8.494 <0.0000000000000002 ***
density 0.0055370 0.0002399 23.085 <0.0000000000000002 ***
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 15.84 on 1318 degrees of freedom
Multiple R-squared: 0.2879, Adjusted R-squared: 0.2874
F-statistic: 532.9 on 1 and 1318 DF, p-value: < 0.00000000000000022
# knitr does not like autoplot
#autoplot(lm(log(Wage.n) ~ Potential, data=train), data=train, colour = 'Nationality_Continent')
library(ggplot2)
p <- ggplot(data=train, mapping=aes(y=log(arrests), x=density))
p + geom_point(alpha = 0.2) +
geom_smooth(method = "lm", aes(color = "OLS", fill = "OLS"))p + geom_point(alpha=0.1) +
geom_smooth(color = "tomato", fill="tomato", method = MASS::rlm) +
geom_smooth(color = "steelblue", fill="steelblue", method = "lm")p + geom_point(alpha=0.1) +
geom_smooth(color = "tomato", method = "lm", linewidth = 1.2,
formula = y ~ splines::bs(x, 3), se = FALSE)p + geom_point(alpha=0.1) +
geom_quantile(color = "tomato", size = 1.2, method = "rqss",
lambda = 1, quantiles = c(0.20, 0.5, 0.85))SUMMARY ASSESSMENT AND EVALUATION OF THE MODEL
These visualizations are important at every step of model development. It made complex data and model behaviors understandable, guiding the model selection and evaluation process. As well, the visualization proved to be an effective communication tool, simplifying the presentation of findings to a broader audience.
The visualization transformed the model development process into a more intuitive, engaging, and accessible data.