DAT-4313 - Data Viz in Model Development

Lab 6

Author

Sofia Santana

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

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")

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_flextable

Estimate

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.

END