TODO.R
hahsler
2023-04-25
High School Graduation in 4 Years
Introduction
This data contains US 4-year high school graduation rates by school district and socioeconomic data already imported in a relational database. We want to load and clean the data to analyze Texas graduation rates with the aim to inform the Texas Governor on taking actions to improve Texas’s workforce competitiveness and future tax revenue. Obviously this means the goal is to increase graduation rates and the question is:
How to increase graduation rates most effectively?
Here Example to read the data in R
library(RSQLite)
library(tidyverse)## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.2 ✔ readr 2.1.4
## ✔ forcats 1.0.0 ✔ stringr 1.5.0
## ✔ ggplot2 3.4.2 ✔ tibble 3.2.1
## ✔ lubridate 1.9.2 ✔ tidyr 1.3.0
## ✔ purrr 1.0.1
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errorsLoading the data
con <- dbConnect(RSQLite::SQLite(), "graduation.sqlite")
dbListTables(con)## [1] "Graduation_Rates"
## [2] "Max_Tract_Overlap_Census"
## [3] "schooldistricts_geocoding_TEXAS_done"Look at data in the tables
head(dbReadTable(con, name = "Graduation_Rates"))## STNAM FIPST leaid11 leanm11 ALL_COHORT_1112 ALL_RATE_1112
## 1 ALABAMA 1 100005 Albertville City 268 83
## 2 ALABAMA 1 100006 Marshall County 424 79
## 3 ALABAMA 1 100007 Hoover City 1042 91
## 4 ALABAMA 1 100008 Madison City 836 91
## 5 ALABAMA 1 100011 Leeds City 117 70-74
## 6 ALABAMA 1 100012 Boaz City 155 90-94
## MAM_COHORT_1112 MAM_RATE_1112 MAS_COHORT_1112 MAS_RATE_1112 MBL_COHORT_1112
## 1 NA <NA> <NA> <NA> 6
## 2 2 PS 1 PS 4
## 3 1 PS 71 85-89 224
## 4 4 PS 44 GE90 195
## 5 NA <NA> <NA> <NA> 44
## 6 NA <NA> 3 PS 2
## MBL_RATE_1112 MHI_COHORT_1112 MHI_RATE_1112 MTR_COHORT_1112 MTR_RATE_1112
## 1 GE50 49 60-69 <NA> <NA>
## 2 PS 26 60-79 <NA> <NA>
## 3 85-89 52 60-69 5 PS
## 4 85-89 23 60-79 2 PS
## 5 60-69 11 GE50 <NA> <NA>
## 6 PS 15 GE50 1 PS
## MWH_COHORT_1112 MWH_RATE_1112 CWD_COHORT_1112 CWD_RATE_1112 ECD_COHORT_1112
## 1 213 85-89 18 60-79 107
## 2 391 79 66 70-74 250
## 3 688 94 63 70-74 216
## 4 566 93 72 60-64 163
## 5 62 75-79 18 60-79 83
## 6 133 90-94 14 GE50 68
## ECD_RATE_1112 LEP_COHORT_1112 LEP_RATE_1112
## 1 70-74 9 LT50
## 2 70-74 9 LT50
## 3 75-79 21 21-39
## 4 80-84 7 GE50
## 5 65-69 3 PS
## 6 85-89 1 PShead(dbReadTable(con, name = "Max_Tract_Overlap_Census"))## Percentage State County Tract.Code School.District
## 1 99.84132773 1 45 20000 Fort Rucker School District
## 2 96.37643907 1 101 900 Maxwell AFB School District
## 3 89.91547447 1 95 30903 Albertville City School District
## 4 100 1 95 31000 Marshall County School District
## 5 99.90345714 1 73 14412 Hoover City School District
## 6 100 1 89 11021 Madison City School District
## District.ID Leaid GIDTR State2 State_name County2 County_name
## 1 1 100001 1045020000 1 Alabama 45 Dale County
## 2 3 100003 1101000900 1 Alabama 101 Montgomery County
## 3 5 100005 1095030903 1 Alabama 95 Marshall County
## 4 6 100006 1095031000 1 Alabama 95 Marshall County
## 5 7 100007 1073014412 1 Alabama 73 Jefferson County
## 6 8 100008 1089011021 1 Alabama 89 Madison County
## Tract Flag Num_BGs_in_Tract LAND_AREA AIAN_LAND URBANIZED_AREA_POP_CEN_2010
## 1 20000 <NA> 3 66.531 0 0
## 2 900 <NA> 2 3.32 0 2497
## 3 30903 <NA> 2 3.539 2 0
## 4 31000 <NA> 3 59.49 3 0
## 5 14412 <NA> 2 1.84 0 4162
## 6 11021 <NA> 2 4.376 0 3912
## URBAN_CLUSTER_POP_CEN_2010 RURAL_POP_CEN_2010 Tot_Population_CEN_2010
## 1 2849 1793 4642
## 2 0 18 2515
## 3 5401 91 5492
## 4 0 6028 6028
## 5 0 0 4162
## 6 0 0 3912
## Tot_Population_ACS_08_12 Tot_Population_ACSMOE_08_12 Males_CEN_2010
## 1 5254 476 2534
## 2 2052 227 1833
## 3 6348 562 2702
## 4 5779 543 3036
## 5 4510 406 2014
## 6 4281 300 1884
## Males_ACS_08_12 Males_ACSMOE_08_12 Females_CEN_2010 Females_ACS_08_12
## 1 3051 275 2108 2203
## 2 1507 197 682 545
## 3 3127 418 2790 3221
## 4 2924 329 2992 2855
## 5 2154 306 2148 2356
## 6 2014 216 2028 2267
## Females_ACSMOE_08_12 Pop_under_5_CEN_2010 Pop_under_5_ACS_08_12
## 1 286 780 800
## 2 79 113 176
## 3 319 501 685
## 4 297 444 306
## 5 247 315 494
## 6 252 227 243
## Pop_under_5_ACSMOE_08_12 Pop_5_17_CEN_2010 Pop_5_17_ACS_08_12
## 1 174 954 1233
## 2 47 261 198
## 3 205 1019 1346
## 4 104 1206 1152
## 5 197 741 970
## 6 118 646 707
## Pop_5_17_ACSMOE_08_12 Pop_18_24_CEN_2010 Pop_18_24_ACS_08_12
## 1 182 812 909
## 2 50 659 355
## 3 241 624 683
## 4 234 559 459
## 5 260 181 146
## 6 121 401 436
## Pop_18_24_ACSMOE_08_12 Pop_25_44_CEN_2010 Pop_25_44_ACS_08_12
## 1 160 1961 2191
## 2 95 1133 903
## 3 225 1548 1954
## 4 134 1564 1616
## 5 114 1183 1479
## 6 142 1287 1561
## Pop_25_44_ACSMOE_08_12 Pop_45_64_CEN_2010 Pop_45_64_ACS_08_12
## 1 249 120 120
## 2 136 341 404
## 3 349 1156 1060
## 4 261 1586 1599
## 5 319 1158 956
## 6 296 995 947
## Pop_45_64_ACSMOE_08_12 Pop_65plus_CEN_2010 Pop_65plus_ACS_08_12
## 1 48 15 1
## 2 79 8 16
## 3 176 644 620
## 4 192 669 647
## 5 128 584 465
## 6 121 356 387
## Pop_65plus_ACSMOE_08_12 Tot_GQ_CEN_2010 Inst_GQ_CEN_2010 Non_Inst_GQ_CEN_2010
## 1 3 551 0 551
## 2 23 1637 914 723
## 3 132 104 94 10
## 4 99 0 0 0
## 5 65 0 0 0
## 6 58 0 0 0
## Hispanic_CEN_2010 Hispanic_ACS_08_12 Hispanic_ACSMOE_08_12
## 1 614 917 359
## 2 130 206 72
## 3 1583 2191 673
## 4 793 848 316
## 5 94 283 347
## 6 170 278 187
## NH_White_alone_CEN_2010 NH_White_alone_ACS_08_12 NH_White_alone_ACSMOE_08_12
## 1 3233 3220 456
## 2 1333 1171 158
## 3 3626 3924 490
## 4 5058 4643 531
## 5 3704 3896 432
## 6 2258 2413 325
## NH_Blk_alone_CEN_2010 NH_Blk_alone_ACS_08_12 NH_Blk_alone_ACSMOE_08_12
## 1 523 750 271
## 2 951 595 129
## 3 99 169 167
## 4 41 27 40
## 5 129 64 107
## 6 1127 1053 277
## NH_AIAN_alone_CEN_2010 NH_AIAN_alone_ACS_08_12 NH_AIAN_alone_ACSMOE_08_12
## 1 32 8 12
## 2 2 17 24
## 3 41 1 11
## 4 55 129 114
## 5 11 42 70
## 6 26 32 42
## NH_Asian_alone_CEN_2010 NH_Asian_alone_ACS_08_12 NH_Asian_alone_ACSMOE_08_12
## 1 59 148 117
## 2 35 39 29
## 3 31 1 3
## 4 6 2 5
## 5 153 207 140
## 6 240 349 181
## NH_NHOPI_alone_CEN_2010 NH_NHOPI_alone_ACS_08_12 NH_NHOPI_alone_ACSMOE_08_12
## 1 11 74 92
## 2 7 0 12
## 3 2 0 17
## 4 1 0 17
## 5 0 0 12
## 6 10 0 12
## NH_SOR_alone_CEN_2010 NH_SOR_alone_ACS_08_12 NH_SOR_alone_ACSMOE_08_12
## 1 5 0 17
## 2 5 0 12
## 3 15 0 17
## 4 5 0 17
## 5 13 0 12
## 6 12 12 19
## Pop_5yrs_Over_ACS_08_12 Pop_5yrs_Over_ACSMOE_08_12 Othr_Lang_ACS_08_12
## 1 4454 394 769
## 2 1876 204 227
## 3 5663 488 1894
## 4 5473 526 617
## 5 4016 350 443
## 6 4038 273 459
## Othr_Lang_ACSMOE_08_12 Age5p_Only_English_ACS_08_12
## 1 242 3685
## 2 59 1649
## 3 551 3769
## 4 287 4856
## 5 373 3573
## 6 223 3579
## Age5p_Only_English_ACSMOE_08_12 Age5p_Spanish_ACS_08_12
## 1 388 76
## 2 192 74
## 3 456 1336
## 4 519 398
## 5 339 78
## 6 320 44
## Age5p_Spanish_ACSMOE_08_12 Age5p_French_ACS_08_12 Age5p_French_ACSMOE_08_12
## 1 59 0 17
## 2 49 0 12
## 3 457 0 17
## 4 207 0 17
## 5 117 0 12
## 6 41 0 12
## Age5p_FrCreole_ACS_08_12 Age5p_FrCreole_ACSMOE_08_12 Age5p_Italian_ACS_08_12
## 1 0 17 0
## 2 0 12 0
## 3 0 17 0
## 4 0 17 0
## 5 0 12 0
## 6 0 12 0
## Age5p_Italian_ACSMOE_08_12 Age5p_Portuguese_ACS_08_12
## 1 17 0
## 2 12 0
## 3 17 0
## 4 17 0
## 5 12 0
## 6 12 0
## Age5p_Portuguese_ACSMOE_08_12 Age5p_German_ACS_08_12
## 1 17 16
## 2 12 0
## 3 17 0
## 4 17 0
## 5 12 0
## 6 12 0
## Age5p_German_ACSMOE_08_12 Age5p_Yiddish_ACS_08_12 Age5p_Yiddish_ACSMOE_08_12
## 1 27 0 17
## 2 12 0 12
## 3 17 0 17
## 4 17 0 17
## 5 12 0 12
## 6 12 0 12
## Age5p_WGerman_ACS_08_12 Age5p_WGerman_ACSMOE_08_12
## 1 0 17
## 2 0 12
## 3 0 17
## 4 0 17
## 5 0 12
## 6 0 12
## Age5p_Scandinavian_ACS_08_12 Age5p_Scandinavian_ACSMOE_08_12
## 1 0 17
## 2 0 12
## 3 0 17
## 4 0 17
## 5 0 12
## 6 0 12
## Age5p_Greek_ACS_08_12 Age5p_Greek_ACSMOE_08_12 Age5p_Russian_ACS_08_12
## 1 0 17 0
## 2 0 12 0
## 3 0 17 0
## 4 0 17 0
## 5 0 12 0
## 6 0 12 0
## Age5p_Russian_ACSMOE_08_12 Age5p_Polish_ACS_08_12 Age5p_Polish_ACSMOE_08_12
## 1 17 0 17
## 2 12 0 12
## 3 17 0 17
## 4 17 0 17
## 5 12 0 12
## 6 12 0 12
## Age5p_SRBCroatian_ACS_08_12 Age5p_SRBCroatian_ACSMOE_08_12
## 1 0 17
## 2 0 12
## 3 0 17
## 4 0 17
## 5 0 12
## 6 0 12
## Age5p_OthSlavic_ACS_08_12 Age5p_OthSlavic_ACSMOE_08_12
## 1 0 17
## 2 0 12
## 3 0 17
## 4 0 17
## 5 0 12
## 6 0 12
## Age5p_Armenian_ACS_08_12 Age5p_Armenian_ACSMOE_08_12 Age5p_Persian_ACS_08_12
## 1 0 17 0
## 2 0 12 0
## 3 0 17 0
## 4 0 17 0
## 5 0 12 0
## 6 0 12 0
## Age5p_Persian_ACSMOE_08_12 Age5p_Gujarati_ACS_08_12
## 1 17 0
## 2 12 0
## 3 17 0
## 4 17 0
## 5 12 0
## 6 12 0
## Age5p_Gujarati_ACSMOE_08_12 Age5p_Hindi_ACS_08_12 Age5p_Hindi_ACSMOE_08_12
## 1 17 0 17
## 2 12 0 12
## 3 17 0 17
## 4 17 0 17
## 5 12 0 12
## 6 12 0 12
## Age5p_Urdu_ACS_08_12 Age5p_Urdu_ACSMOE_08_12 Age5p_OthIndic_ACS_08_12
## 1 0 17 0
## 2 0 12 0
## 3 0 17 0
## 4 0 17 0
## 5 0 12 0
## 6 0 12 52
## Age5p_OthIndic_ACSMOE_08_12 Age5p_OthEuro_ACS_08_12
## 1 17 0
## 2 12 0
## 3 17 0
## 4 17 0
## 5 12 0
## 6 71 0
## Age5p_OthEuro_ACSMOE_08_12 Age5p_Chinese_ACS_08_12 Age5p_Chinese_ACSMOE_08_12
## 1 17 0 17
## 2 12 0 12
## 3 17 0 17
## 4 17 0 17
## 5 12 143 127
## 6 12 35 53
## Age5p_Japanese_ACS_08_12 Age5p_Japanese_ACSMOE_08_12 Age5p_Korean_ACS_08_12
## 1 21 30 0
## 2 0 12 2
## 3 0 17 0
## 4 0 17 0
## 5 0 12 7
## 6 0 12 20
## Age5p_Korean_ACSMOE_08_12 Age5p_Cambodian_ACS_08_12
## 1 17 0
## 2 5 0
## 3 17 0
## 4 17 0
## 5 13 0
## 6 31 0
## Age5p_Cambodian_ACSMOE_08_12 Age5p_Hmong_ACS_08_12 Age5p_Hmong_ACSMOE_08_12
## 1 17 0 17
## 2 12 0 12
## 3 17 0 17
## 4 17 0 17
## 5 12 0 12
## 6 12 0 12
## Age5p_Thai_ACS_08_12 Age5p_Thai_ACSMOE_08_12 Age5p_Laotian_ACS_08_12
## 1 0 17 0
## 2 0 12 0
## 3 0 17 0
## 4 0 17 0
## 5 0 12 0
## 6 0 12 0
## Age5p_Laotian_ACSMOE_08_12 Age5p_Vietnamese_ACS_08_12
## 1 17 0
## 2 12 9
## 3 17 0
## 4 17 0
## 5 12 0
## 6 12 53
## Age5p_Vietnamese_ACSMOE_08_12 Age5p_OthAsian_ACS_08_12
## 1 17 0
## 2 18 0
## 3 17 0
## 4 17 0
## 5 12 0
## 6 77 24
## Age5p_OthAsian_ACSMOE_08_12 Age5p_Tagalog_ACS_08_12
## 1 17 0
## 2 12 0
## 3 17 0
## 4 17 0
## 5 12 0
## 6 36 0
## Age5p_Tagalog_ACSMOE_08_12 Age5p_OthPacIsl_ACS_08_12
## 1 17 0
## 2 12 0
## 3 17 0
## 4 17 0
## 5 12 0
## 6 12 0
## Age5p_OthPacIsl_ACSMOE_08_12 Age5p_Navajo_ACS_08_12 Age5p_Navajo_ACSMOE_08_12
## 1 17 0 17
## 2 12 0 12
## 3 17 0 17
## 4 17 0 17
## 5 12 0 12
## 6 12 0 12
## Age5p_NativeNAm_ACS_08_12 Age5p_NativeNAm_ACSMOE_08_12
## 1 0 17
## 2 0 12
## 3 0 17
## 4 0 17
## 5 0 12
## 6 0 12
## Age5p_Hungarian_ACS_08_12 Age5p_Hungarian_ACSMOE_08_12 Age5p_Arabic_ACS_08_12
## 1 0 17 0
## 2 0 12 0
## 3 0 17 0
## 4 0 17 0
## 5 0 12 0
## 6 0 12 0
## Age5p_Arabic_ACSMOE_08_12 Age5p_Hebrew_ACS_08_12 Age5p_Hebrew_ACSMOE_08_12
## 1 17 0 17
## 2 12 8 16
## 3 17 0 17
## 4 17 0 17
## 5 12 0 12
## 6 12 0 12
## Age5p_African_ACS_08_12 Age5p_African_ACSMOE_08_12 Age5p_OthUnSp_ACS_08_12
## 1 0 17 0
## 2 0 12 0
## 3 0 17 0
## 4 0 17 0
## 5 0 12 0
## 6 0 12 0
## Age5p_OthUnSp_ACSMOE_08_12 Pop_25yrs_Over_ACS_08_12
## 1 17 2312
## 2 12 1323
## 3 17 3634
## 4 17 3862
## 5 12 2900
## 6 12 2895
## Pop_25yrs_Over_ACSMOE_08_12 Not_HS_Grad_ACS_08_12 Not_HS_Grad_ACSMOE_08_12
## 1 253 64 47
## 2 172 147 53
## 3 393 1571 355
## 4 367 1311 283
## 5 213 96 75
## 6 234 260 119
## College_ACS_08_12 College_ACSMOE_08_12 Pov_Univ_ACS_08_12
## 1 720 167 4196
## 2 289 57 889
## 3 334 139 6251
## 4 298 90 5776
## 5 1841 247 4510
## 6 1154 210 4281
## Pov_Univ_ACSMOE_08_12 Prs_Blw_Pov_Lev_ACS_08_12 Prs_Blw_Pov_Lev_ACSMOE_08_12
## 1 446 451 321
## 2 112 29 26
## 3 555 1891 630
## 4 543 1188 279
## 5 406 136 130
## 6 300 488 203
## Civ_labor_16plus_ACS_08_12 Civ_labor_16plus_ACSMOE_08_12
## 1 791 156
## 2 179 48
## 3 2942 374
## 4 2409 339
## 5 2397 258
## 6 2677 237
## Civ_emp_16plus_ACS_08_12 Civ_emp_16plus_ACSMOE_08_12
## 1 643 151
## 2 149 45
## 3 2652 380
## 4 2151 305
## 5 2281 254
## 6 2516 251
## Civ_unemp_16plus_ACS_08_12 Civ_unemp_16plus_ACSMOE_08_12
## 1 148 60
## 2 30 25
## 3 290 123
## 4 258 109
## 5 116 82
## 6 161 81
## Civ_labor_16_24_ACS_08_12 Civ_labor_16_24_ACSMOE_08_12
## 1 144 79
## 2 25 21
## 3 663 194
## 4 333 100
## 5 141 88
## 6 425 137
## Civ_emp_16_24_ACS_08_12 Civ_emp_16_24_ACSMOE_08_12 Civ_unemp_16_24_ACS_08_12
## 1 124 74 20
## 2 14 15 11
## 3 528 174 135
## 4 229 90 104
## 5 106 73 35
## 6 329 114 96
## Civ_unemp_16_24_ACSMOE_08_12 Civ_labor_25_44_ACS_08_12
## 1 25 612
## 2 19 118
## 3 88 1564
## 4 51 1060
## 5 50 1402
## 6 71 1471
## Civ_labor_25_44_ACSMOE_08_12 Civ_emp_25_44_ACS_08_12
## 1 162 484
## 2 45 99
## 3 302 1446
## 4 188 983
## 5 259 1334
## 6 289 1423
## Civ_emp_25_44_ACSMOE_08_12 Civ_unemp_25_44_ACS_08_12
## 1 148 128
## 2 41 19
## 3 300 118
## 4 179 77
## 5 258 68
## 6 288 48
## Civ_unemp_25_44_ACSMOE_08_12 Civ_labor_45_64_ACS_08_12
## 1 67 35
## 2 23 36
## 3 86 580
## 4 61 904
## 5 64 778
## 6 35 752
## Civ_labor_45_64_ACSMOE_08_12 Civ_emp_45_64_ACS_08_12
## 1 31 35
## 2 19 36
## 3 171 563
## 4 161 827
## 5 184 765
## 6 146 735
## Civ_emp_45_64_ACSMOE_08_12 Civ_unemp_45_64_ACS_08_12
## 1 31 0
## 2 19 0
## 3 170 17
## 4 148 77
## 5 183 13
## 6 142 17
## Civ_unemp_45_64_ACSMOE_08_12 Civ_labor_65plus_ACS_08_12
## 1 17 0
## 2 12 0
## 3 29 135
## 4 63 112
## 5 25 76
## 6 23 29
## Civ_labor_65plus_ACSMOE_08_12 Civ_emp_65plus_ACS_08_12
## 1 17 0
## 2 12 0
## 3 85 115
## 4 63 112
## 5 57 76
## 6 26 29
## Civ_emp_65plus_ACSMOE_08_12 Civ_unemp_65plus_ACS_08_12
## 1 17 0
## 2 12 0
## 3 68 20
## 4 60 0
## 5 56 0
## 6 23 0
## Civ_unemp_65plus_ACSMOE_08_12 Pop_1yr_Over_ACS_08_12
## 1 17 5110
## 2 12 2016
## 3 34 6222
## 4 17 5735
## 5 12 4446
## 6 12 4258
## Pop_1yr_Over_ACSMOE_08_12 Diff_HU_1yr_Ago_ACS_08_12
## 1 457 3116
## 2 223 996
## 3 519 1358
## 4 534 773
## 5 409 1008
## 6 296 1297
## Diff_HU_1yr_Ago_ACSMOE_08_12 Born_US_ACS_08_12 Born_US_ACSMOE_08_12
## 1 0 4910 473
## 2 0 1998 220
## 3 0 4938 435
## 4 0 5456 530
## 5 0 4123 399
## 6 0 3886 314
## Born_foreign_ACS_08_12 Born_foreign_ACSMOE_08_12 US_Cit_Nat_ACS_08_12
## 1 344 220 270
## 2 54 35 45
## 3 1410 513 66
## 4 323 178 65
## 5 387 330 9
## 6 395 179 181
## US_Cit_Nat_ACSMOE_08_12 NON_US_Cit_ACS_08_12 NON_US_Cit_ACSMOE_08_12
## 1 216 74 42
## 2 32 9 12
## 3 100 1344 480
## 4 44 258 153
## 5 15 378 329
## 6 127 214 135
## ENG_VW_SPAN_ACS_08_12 ENG_VW_SPAN_ACSMOE_08_12 ENG_VW_INDO_EURO_ACS_08_12
## 1 0 17 0
## 2 0 12 0
## 3 342 146 0
## 4 6 6 0
## 5 0 12 0
## 6 11 16 25
## ENG_VW_INDO_EURO_ACSMOE_08_12 ENG_VW_API_ACS_08_12 ENG_VW_API_ACSMOE_08_12
## 1 17 0 17
## 2 12 0 12
## 3 17 0 17
## 4 17 0 17
## 5 12 76 80
## 6 32 40 41
## ENG_VW_OTHER_ACS_08_12 ENG_VW_OTHER_ACSMOE_08_12 ENG_VW_ACS_08_12
## 1 0 17 0
## 2 0 12 0
## 3 0 17 342
## 4 0 17 6
## 5 0 12 76
## 6 0 12 76
## ENG_VW_ACSMOE_08_12 Rel_Family_HHDS_CEN_2010 Rel_Family_HHD_ACS_08_12
## 1 17 1078 1030
## 2 12 237 246
## 3 147 1325 1588
## 4 18 1666 1555
## 5 81 1241 1175
## 6 56 937 944
## Rel_Family_HHD_ACSMOE_08_12 MrdCple_Fmly_HHD_CEN_2010
## 1 143 979
## 2 30 209
## 3 179 878
## 4 146 1266
## 5 106 1046
## 6 135 574
## MrdCple_Fmly_HHD_ACS_08_12 MrdCple_Fmly_HHD_ACSMOE_08_12
## 1 864 130
## 2 224 31
## 3 855 189
## 4 1235 157
## 5 1119 114
## 6 593 107
## Not_MrdCple_HHD_CEN_2010 Not_MrdCple_HHD_ACS_08_12
## 1 251 364
## 2 57 36
## 3 1116 1285
## 4 900 736
## 5 581 430
## 6 1385 1456
## Not_MrdCple_HHD_ACSMOE_08_12 Female_No_HB_CEN_2010 Female_No_HB_ACS_08_12
## 1 104 74 145
## 2 24 24 18
## 3 225 335 462
## 4 150 276 256
## 5 110 152 56
## 6 194 274 227
## Female_No_HB_ACSMOE_08_12 NonFamily_HHD_CEN_2010 NonFamily_HHD_ACS_08_12
## 1 65 152 198
## 2 13 29 14
## 3 139 669 552
## 4 79 500 416
## 5 38 386 374
## 6 115 1022 1105
## NonFamily_HHD_ACSMOE_08_12 Sngl_Prns_HHD_CEN_2010 Sngl_Prns_HHD_ACS_08_12
## 1 77 112 173
## 2 19 29 2
## 3 159 558 535
## 4 114 425 394
## 5 103 349 337
## 6 146 895 889
## Sngl_Prns_HHD_ACSMOE_08_12 HHD_PPL_Und_18_CEN_2010 HHD_PPL_Und_18_ACS_08_12
## 1 75 844 814
## 2 5 176 200
## 3 157 765 1053
## 4 114 867 762
## 5 93 585 640
## 6 133 524 584
## HHD_PPL_Und_18_ACSMOE_08_12 Tot_Prns_in_HHD_CEN_2010
## 1 123 4091
## 2 31 878
## 3 168 5388
## 4 108 6028
## 5 119 4162
## 6 114 3912
## Tot_Prns_in_HHD_ACS_08_12 Tot_Prns_in_HHD_ACSMOE_08_12
## 1 4196 446
## 2 889 112
## 3 6236 554
## 4 5779 543
## 5 4510 406
## 6 4281 300
## Rel_Child_Under_6_CEN_2010 Rel_Child_Under_6_ACS_08_12
## 1 623 595
## 2 99 137
## 3 384 516
## 4 375 372
## 5 282 372
## 6 211 215
## Rel_Child_Under_6_ACSMOE_08_12 HHD_Moved_in_ACS_08_12
## 1 146 490
## 2 39 115
## 3 179 309
## 4 121 188
## 5 164 159
## 6 104 442
## HHD_Moved_in_ACSMOE_08_12 PUB_ASST_INC_ACS_08_12 PUB_ASST_INC_ACSMOE_08_12
## 1 136 0 17
## 2 38 0 12
## 3 140 60 53
## 4 94 66 59
## 5 129 0 12
## 6 120 20 23
## Med_HHD_Inc_ACS_08_12 Med_HHD_Inc_ACSMOE_08_12 Aggregate_HH_INC_ACS_08_12
## 1 $51,081 $5,229 $69,435,200
## 2 $81,250 $10,032 $24,699,000
## 3 $30,670 $8,241 $85,728,300
## 4 $33,493 $3,483 $93,910,800
## 5 $80,245 $9,406 $138,540,100
## 6 $44,981 $6,761 $119,252,000
## Aggregate_HH_INC_ACSMOE_08_12 Tot_Housing_Units_CEN_2010
## 1 $8,843,471 1458
## 2 $3,708,390 397
## 3 $10,046,417 2171
## 4 $15,859,743 2446
## 5 $14,236,244 1692
## 6 $12,772,144 2136
## Tot_Housing_Units_ACS_08_12 Tot_Housing_Units_ACSMOE_08_12
## 1 1466 104
## 2 312 44
## 3 2230 177
## 4 2418 140
## 5 1588 79
## 6 2276 60
## Tot_Occp_Units_CEN_2010 Tot_Occp_Units_ACS_08_12 Tot_Occp_Units_ACSMOE_08_12
## 1 1230 1228 152
## 2 266 260 32
## 3 1994 2140 164
## 4 2166 1971 160
## 5 1627 1549 96
## 6 1959 2049 115
## Tot_Vacant_Units_CEN_2010 Tot_Vacant_Units_ACS_08_12
## 1 228 238
## 2 131 52
## 3 177 90
## 4 280 447
## 5 65 39
## 6 177 227
## Tot_Vacant_Units_ACSMOE_08_12 Renter_Occp_HU_CEN_2010
## 1 117 1215
## 2 31 258
## 3 79 972
## 4 143 535
## 5 60 151
## 6 108 1385
## Renter_Occp_HU_ACS_08_12 Renter_Occp_HU_ACSMOE_08_12 Owner_Occp_HU_CEN_2010
## 1 1228 152 15
## 2 260 32 8
## 3 1022 152 1022
## 4 517 128 1631
## 5 160 95 1476
## 6 1471 154 574
## Owner_Occp_HU_ACS_08_12 Owner_Occp_HU_ACSMOE_08_12 Single_Unit_ACS_08_12
## 1 0 17 1357
## 2 0 12 260
## 3 1118 156 1614
## 4 1454 175 1402
## 5 1389 117 1588
## 6 578 106 699
## Single_Unit_ACSMOE_08_12 MLT_U2_9_STRC_ACS_08_12 MLT_U2_9_STRC_ACSMOE_08_12
## 1 173 47 57
## 2 42 48 36
## 3 192 359 140
## 4 192 146 84
## 5 80 0 12
## 6 129 1043 173
## MLT_U10p_ACS_08_12 MLT_U10p_ACSMOE_08_12 Mobile_Homes_ACS_08_12
## 1 22 31 40
## 2 4 13 0
## 3 139 95 83
## 4 3 17 867
## 5 0 12 0
## 6 502 122 32
## Mobile_Homes_ACSMOE_08_12 Crowd_Occp_U_ACS_08_12 Crowd_Occp_U_ACSMOE_08_12
## 1 47 7 11
## 2 12 7 8
## 3 92 122 89
## 4 164 115 64
## 5 12 0 0
## 6 44 73 69
## Occp_U_NO_PH_SRVC_ACS_08_12 Occp_U_NO_PH_SRVC_ACSMOE_08_12 No_Plumb_ACS_08_12
## 1 21 26 24
## 2 0 12 0
## 3 70 60 0
## 4 32 34 56
## 5 10 21 13
## 6 30 26 6
## No_Plumb_ACSMOE_08_12 Recent_Built_HU_ACS_08_12 Recent_Built_HU_ACSMOE_08_12
## 1 40 85 59
## 2 12 0 12
## 3 17 0 17
## 4 70 47 74
## 5 20 0 12
## 6 11 12 19
## Med_House_value_ACS_08_12 Med_House_value_ACSMOE_08_12
## 1 <NA> <NA>
## 2 <NA> <NA>
## 3 $87,600 $9,432
## 4 $85,700 $8,404
## 5 $214,700 $8,501
## 6 $144,900 $11,864
## Aggr_House_Value_ACS_08_12 Aggr_House_Value_ACSMOE_08_12
## 1 <NA> <NA>
## 2 <NA> <NA>
## 3 $110,892,100 $17,990,640
## 4 $168,827,100 $32,061,310
## 5 $285,485,200 $24,235,418
## 6 $100,288,000 $24,508,696
## MailBack_Area_Count_CEN_2010 TEA_Mail_Out_Mail_Back_CEN_2010
## 1 1488 1488
## 2 426 426
## 3 2176 2176
## 4 2385 2385
## 5 1679 1679
## 6 2031 2031
## TEA_Update_Leave_CEN_2010 Census_Mail_Returns_CEN_2010 Vacants_CEN_2010
## 1 0 949 32
## 2 0 192 15
## 3 0 1374 54
## 4 0 1509 84
## 5 0 1373 33
## 6 0 1362 89
## Deletes_CEN_2010 Census_UAA_CEN_2010 Valid_Mailback_Count_CEN_2010
## 1 0 281 1175
## 2 0 182 229
## 3 0 226 1896
## 4 0 406 1895
## 5 0 50 1596
## 6 0 142 1800
## FRST_FRMS_CEN_2010 RPLCMNT_FRMS_CEN_2010 BILQ_Mailout_count_CEN_2010
## 1 827 122 0
## 2 161 31 0
## 3 1213 161 0
## 4 1343 166 0
## 5 1373 0 0
## 6 1191 171 0
## BILQ_Frms_CEN_2010 Mail_Return_Rate_CEN_2010 Low_Response_Score
## 1 0 80.8 27.4025963
## 2 0 83.8 27.61779519
## 3 0 72.5 23.00900346
## 4 0 79.6 20.96561243
## 5 0 86 10.60077608
## 6 0 75.7 24.61844532
## pct_URBANIZED_AREA_POP_CEN_2010 pct_URBAN_CLUSTER_POP_CEN_2010
## 1 0 61.37
## 2 99.28 0
## 3 0 98.34
## 4 0 0
## 5 100 0
## 6 100 0
## pct_RURAL_POP_CEN_2010 pct_Males_CEN_2010 pct_Males_ACS_08_12
## 1 38.63 54.59 58.07004187
## 2 0.72 72.88 73.44054581
## 3 1.66 49.2 49.25960933
## 4 100 50.36 50.5969891
## 5 0 48.39 47.76053215
## 6 0 48.16 47.04508293
## pct_Males_ACSMOE_08_12 pct_Females_CEN_2010 pct_Females_ACS_08_12
## 1 7.421192135 45.41 41.92995813
## 2 5.115047193 27.12 26.55945419
## 3 4.933584068 50.8 50.74039067
## 4 3.131887566 49.64 49.4030109
## 5 5.248753418 51.61 52.23946785
## 6 3.819529102 51.84 52.95491708
## pct_Females_ACSMOE_08_12 pct_Pop_Under_5_CEN_2010 pct_Pop_Under_5_ACS_08_12
## 1 3.89882573 16.8 15.2264941
## 2 2.487825404 4.49 8.576998051
## 3 2.252413971 9.12 10.79080025
## 4 2.205599491 7.37 5.295033743
## 5 2.806948392 7.57 10.95343681
## 6 4.569421846 5.8 5.676243868
## pct_Pop_Under_5_ACSMOE_08_12 pct_Pop_5_17_CEN_2010 pct_Pop_5_17_ACS_08_12
## 1 3.010779525 20.55 23.46783403
## 2 2.084680862 10.38 9.649122807
## 3 3.084823374 18.55 21.20352867
## 4 1.729478953 20.01 19.93424468
## 5 4.255319606 17.8 21.50776053
## 6 2.727512642 16.51 16.51483298
## pct_Pop_5_17_ACSMOE_08_12 pct_Pop_18_24_CEN_2010 pct_Pop_18_24_ACS_08_12
## 1 2.73478619 17.49 17.30110392
## 2 2.190401505 26.2 17.30019493
## 3 3.299903559 11.36 10.75929427
## 4 3.589886625 9.27 7.942550614
## 5 5.430107419 4.35 3.237250554
## 6 2.578644448 10.25 10.18453632
## pct_Pop_18_24_ACSMOE_08_12 pct_Pop_25_44_CEN_2010 pct_Pop_25_44_ACS_08_12
## 1 2.610934567 42.24 41.70156072
## 2 4.215541526 45.05 44.00584795
## 3 3.414030644 28.19 30.78134846
## 4 2.195360775 25.95 27.96331545
## 5 2.510860605 28.42 32.79379157
## 6 3.239289776 32.9 36.46344312
## pct_Pop_25_44_ACSMOE_08_12 pct_Pop_45_64_CEN_2010 pct_Pop_45_64_ACS_08_12
## 1 2.861240203 2.59 2.283974115
## 2 4.497534189 13.56 19.68810916
## 3 4.774873621 21.05 16.69817265
## 4 3.673404713 26.31 27.66914691
## 5 6.427631451 27.82 21.19733925
## 6 6.424784091 25.43 22.12099977
## pct_Pop_45_64_ACSMOE_08_12 pct_Pop_65plus_CEN_2010 pct_Pop_65plus_ACS_08_12
## 1 0.889847769 0.32 0.019033118
## 2 3.174615369 0.32 0.779727096
## 3 2.345522502 11.73 9.766855703
## 4 2.06860277 11.1 11.1957086
## 5 2.100876131 14.03 10.31042129
## 6 2.36341568 9.1 9.039943938
## pct_Pop_65plus_ACSMOE_08_12 pct_Tot_GQ_CEN_2010 pct_Inst_GQ_CEN_2010
## 1 0.05707331 11.87 0
## 2 1.117533813 65.09 36.34
## 3 1.891088762 1.89 1.71
## 4 1.352069317 0 0
## 5 1.102580832 0 0
## 6 1.197595014 0 0
## pct_Non_Inst_GQ_CEN_2010 pct_Hispanic_CEN_2010 pct_Hispanic_ACS_08_12
## 1 11.87 13.23 17.45336886
## 2 28.75 5.17 10.03898636
## 3 0.18 28.82 34.51480781
## 4 0 13.16 14.673819
## 5 0 2.26 6.274944568
## 6 0 4.35 6.493809858
## pct_Hispanic_ACSMOE_08_12 pct_NH_White_alone_CEN_2010
## 1 6.647411086 69.65
## 2 3.328386658 53
## 3 10.15186468 66.02
## 4 5.291393072 83.91
## 5 7.673248766 89
## 6 4.344369444 57.72
## pct_NH_White_alone_ACS_08_12 pct_NH_White_alone_ACSMOE_08_12
## 1 61.28663875 6.670635933
## 2 57.0662768 4.408452273
## 3 61.8147448 5.443657039
## 4 80.34261983 5.238232006
## 5 86.38580931 5.592464446
## 6 56.3653352 6.483194708
## pct_NH_Blk_alone_CEN_2010 pct_NH_Blk_alone_ACS_08_12
## 1 11.27 14.27483822
## 2 37.81 28.99610137
## 3 1.8 2.662255829
## 4 0.68 0.46720886
## 5 3.1 1.419068736
## 6 28.81 24.59705676
## pct_NH_Blk_alone_ACSMOE_08_12 pct_NH_AIAN_alone_CEN_2010
## 1 4.993212011 0.69
## 2 5.406628793 0.08
## 3 2.620170396 0.75
## 4 0.690767743 0.91
## 5 2.369063758 0.26
## 6 6.23663584 0.66
## pct_NH_AIAN_alone_ACS_08_12 pct_NH_AIAN_alone_ACSMOE_08_12
## 1 0.152264941 0.227980437
## 2 0.828460039 1.165994438
## 3 0.015752993 0.173277311
## 4 2.232220107 1.961477648
## 5 0.931263858 1.54984069
## 6 0.747488905 0.979679802
## pct_NH_Asian_alone_CEN_2010 pct_NH_Asian_alone_ACS_08_12
## 1 1.27 2.816901409
## 2 1.39 1.900584795
## 3 0.56 0.015752993
## 4 0.1 0.034608064
## 5 3.68 4.589800444
## 6 6.13 8.152300864
## pct_NH_Asian_alone_ACSMOE_08_12 pct_NH_NHOPI_alone_CEN_2010
## 1 2.212202931 0.24
## 2 1.397528427 0.28
## 3 0.047238396 0.04
## 4 0.086459029 0.02
## 5 3.076591722 0
## 6 4.189209713 0.26
## pct_NH_NHOPI_alone_ACS_08_12 pct_NH_NHOPI_alone_ACSMOE_08_12
## 1 1.408450704 1.746391314
## 2 0 0.584795322
## 3 0 0.267800882
## 4 0 0.294168541
## 5 0 0.266075388
## 6 0 0.280308339
## pct_NH_SOR_alone_CEN_2010 pct_NH_SOR_alone_ACS_08_12
## 1 0.11 0
## 2 0.2 0
## 3 0.27 0
## 4 0.08 0
## 5 0.31 0
## 6 0.31 0.280308339
## pct_NH_SOR_alone_ACSMOE_08_12 pct_Pop_5yrs_Over_ACS_08_12
## 1 0.323563 84.7735059
## 2 0.584795322 91.42300195
## 3 0.267800882 89.20919975
## 4 0.294168541 94.70496626
## 5 0.266075388 89.04656319
## 6 0.443386628 94.32375613
## pct_Pop_5yrs_Over_ACSMOE_08_12 pct_Othr_Lang_ACS_08_12
## 1 10.73417068 17.26537943
## 2 14.18160389 12.10021322
## 3 11.02148499 33.4451704
## 4 1.91325232 11.27352458
## 5 11.15727397 11.03087649
## 6 9.184636208 11.36701337
## pct_Othr_Lang_ACSMOE_08_12 pct_Age5p_Only_Eng_ACS_08_12
## 1 5.214242704 82.73462057
## 2 2.856505648 87.89978678
## 3 9.29317429 66.5548296
## 4 5.130772103 88.72647543
## 5 9.23796113 88.96912351
## 6 5.468803689 88.63298663
## pct_Age5p_Only_Eng_ACSMOE_08_12 pct_Age5p_Spanish_ACS_08_12
## 1 4.724725464 1.706331388
## 2 3.658257793 3.9445629
## 3 5.652067961 23.59173583
## 4 4.148516462 7.272062854
## 5 3.336659381 1.942231076
## 6 5.185918885 1.089648341
## pct_Age5p_Spanish_ACSMOE_08_12 pct_Age5p_French_ACS_08_12
## 1 1.316024127 0
## 2 2.576478775 0
## 3 7.809655743 0
## 4 3.717068195 0
## 5 2.908425138 0
## 6 1.012678109 0
## pct_Age5p_French_ACSMOE_08_12 pct_Age5p_FrCreole_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_FrCreole_ACSMOE_08_12 pct_Age5p_Italian_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Italian_ACSMOE_08_12 pct_Age5p_Portugues_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Portugues_ACSMOE_08_12 pct_Age5p_German_ACS_08_12
## 1 0.381679389 0.359227661
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_German_ACSMOE_08_12 pct_Age5p_Yiddish_ACS_08_12
## 1 0.605363214 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Yiddish_ACSMOE_08_12 pct_Age5p_WGerman_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_WGerman_ACSMOE_08_12 pct_Age5p_Scandinav_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Scandinav_ACSMOE_08_12 pct_Age5p_Greek_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Greek_ACSMOE_08_12 pct_Age5p_Russian_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Russian_ACSMOE_08_12 pct_Age5p_Polish_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Polish_ACSMOE_08_12 pct_Age5p_SRBCroati_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_SRBCroati_ACSMOE_08_12 pct_Age5p_OthSlavic_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_OthSlavic_ACSMOE_08_12 pct_Age5p_Armenian_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Armenian_ACSMOE_08_12 pct_Age5p_Persian_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Persian_ACSMOE_08_12 pct_Age5p_Gujarati_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Gujarati_ACSMOE_08_12 pct_Age5p_Hindi_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Hindi_ACSMOE_08_12 pct_Age5p_Urdu_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Urdu_ACSMOE_08_12 pct_Age5p_OthIndic_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 1.287766221
## pct_Age5p_OthIndic_ACSMOE_08_12 pct_Age5p_OthEuro_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 1.75613938 0
## pct_Age5p_OthEuro_ACSMOE_08_12 pct_Age5p_Chinese_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 3.560756972
## 6 0.29717682 0.866765726
## pct_Age5p_Chinese_ACSMOE_08_12 pct_Age5p_Japanese_ACS_08_12
## 1 0.381679389 0.471486304
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 3.147087501 0
## 6 1.311222156 0
## pct_Age5p_Japanese_ACSMOE_08_12 pct_Age5p_Korean_ACS_08_12
## 1 0.672259317 0
## 2 0.639658849 0.106609808
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0.174302789
## 6 0.29717682 0.4952947
## pct_Age5p_Korean_ACSMOE_08_12 pct_Age5p_Cambodian_ACS_08_12
## 1 0.381679389 0
## 2 0.266272273 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.32334855 0
## 6 0.766976149 0
## pct_Age5p_Cambodian_ACSMOE_08_12 pct_Age5p_Hmong_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Hmong_ACSMOE_08_12 pct_Age5p_Thai_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Thai_ACSMOE_08_12 pct_Age5p_Laotian_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Laotian_ACSMOE_08_12 pct_Age5p_Vietnames_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0.479744137
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 1.312530956
## pct_Age5p_Vietnames_ACSMOE_08_12 pct_Age5p_OthAsian_ACS_08_12
## 1 0.381679389 0
## 2 0.958069001 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 1.904818775 0.59435364
## pct_Age5p_OthAsian_ACSMOE_08_12 pct_Age5p_Tagalog_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.890624442 0
## pct_Age5p_Tagalog_ACSMOE_08_12 pct_Age5p_OthPacIsl_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_OthPacIsl_ACSMOE_08_12 pct_Age5p_Navajo_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Navajo_ACSMOE_08_12 pct_Age5p_NativeNAm_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_NativeNAm_ACSMOE_08_12 pct_Age5p_Hungarian_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Hungarian_ACSMOE_08_12 pct_Age5p_Arabic_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Arabic_ACSMOE_08_12 pct_Age5p_Hebrew_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0.426439232
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_Hebrew_ACSMOE_08_12 pct_Age5p_African_ACS_08_12
## 1 0.381679389 0
## 2 0.85161689 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_African_ACSMOE_08_12 pct_Age5p_OthUnSp_ACS_08_12
## 1 0.381679389 0
## 2 0.639658849 0
## 3 0.300194243 0
## 4 0.31061575 0
## 5 0.298804781 0
## 6 0.29717682 0
## pct_Age5p_OthUnSp_ACSMOE_08_12 pct_Pop_25yrs_Over_ACS_08_12
## 1 0.381679389 44.00456795
## 2 0.639658849 64.47368421
## 3 0.300194243 57.24637681
## 4 0.31061575 66.82817096
## 5 0.298804781 64.30155211
## 6 0.29717682 67.62438683
## pct_Pop_25yrs_Over_ACSMOE_08_12 pct_Not_HS_Grad_ACS_08_12
## 1 2.700743595 2.76816609
## 2 4.40329502 11.11111111
## 3 3.555512218 43.23059989
## 4 0.949249704 33.9461419
## 5 7.470789114 3.310344828
## 6 2.723955245 8.981001727
## pct_Not_HS_Grad_ACSMOE_08_12 pct_College_ACS_08_12 pct_College_ACSMOE_08_12
## 1 2.010176421 31.14186851 6.368759937
## 2 3.736542398 21.84429327 3.239916757
## 3 8.577474091 9.190974133 3.693583905
## 4 6.57956537 7.716209218 2.212032696
## 5 2.574752314 63.48275862 7.127596873
## 6 4.045928009 39.86183074 6.499048111
## pct_Pov_Univ_ACS_08_12 pct_Pov_Univ_ACSMOE_08_12
## 1 79.86296155 4.439399857
## 2 43.32358675 2.61180894
## 3 98.47195967 0.660818953
## 4 99.9480879 0.302719253
## 5 100 12.73105779
## 6 100 9.910396373
## pct_Prs_Blw_Pov_Lev_ACS_08_12 pct_Prs_Blw_Pov_Lev_ACSMOE_08_12
## 1 10.74833175 7.564355646
## 2 3.262092239 2.895615358
## 3 30.25115981 9.713906456
## 4 20.56786704 4.426441435
## 5 3.015521064 2.869672073
## 6 11.39920579 4.674113128
## pct_Civ_emp_16p_ACS_08_12 pct_Civ_emp_16p_ACSMOE_08_12
## 1 81.28950695 10.36339431
## 2 83.24022346 11.56537146
## 3 90.14276003 5.95956193
## 4 89.29016189 1.554061735
## 5 95.16061744 2.71611045
## 6 93.98580501 4.321771398
## pct_Civ_unemp_16p_ACS_08_12 pct_Civ_unemp_16p_ACSMOE_08_12
## 1 18.71049305 6.627274676
## 2 16.75977654 13.22362912
## 3 9.857239973 3.98861946
## 4 10.70983811 4.266323005
## 5 4.839382562 3.381054428
## 6 6.014194994 2.978559022
## pct_Civ_emp_16_24_ACS_08_12 pct_Civ_emp_16_24_ACSMOE_08_12
## 1 86.11111111 20.2251678
## 2 56 37.24564941
## 3 79.63800905 12.07244294
## 4 68.76876877 17.43515831
## 5 75.17730497 21.88698802
## 6 77.41176471 9.838907668
## pct_Civ_unemp_16_24_ACS_08_12 pct_Civ_unemp_16_24_ACSMOE_08_12
## 1 13.88888889 15.59967608
## 2 44 56
## 3 20.36199095 11.86058627
## 4 31.23123123 12.10776474
## 5 24.82269504 31.89787492
## 6 22.58823529 15.03555623
## pct_Civ_emp_25_44_ACS_08_12 pct_Civ_emp_25_44_ACSMOE_08_12
## 1 79.08496732 12.10680505
## 2 83.89830509 13.54919025
## 3 92.45524297 7.015519568
## 4 92.73584906 3.826725119
## 5 95.14978602 5.447200502
## 6 96.73691366 4.702393175
## pct_Civ_unemp_25_44_ACS_08_12 pct_Civ_unemp_25_44_ACSMOE_08_12
## 1 20.91503268 9.444651036
## 2 16.10169492 18.4990299
## 3 7.544757033 5.302218141
## 4 7.264150943 5.608645025
## 5 4.85021398 4.476108274
## 6 3.263086336 2.291340841
## pct_Civ_emp_45_64_ACS_08_12 pct_Civ_emp_45_64_ACSMOE_08_12
## 1 100 100
## 2 100 74.63904913
## 3 97.06896552 6.330208869
## 4 91.48230089 1.605643077
## 5 98.32904884 3.531738856
## 6 97.7393617 26.7704165
## pct_Civ_unemp_45_64_ACS_08_12 pct_Civ_unemp_45_64_ACSMOE_08_12
## 1 0 48.57142857
## 2 0 33.33333333
## 3 2.931034483 4.924758378
## 4 8.517699115 6.801919136
## 5 1.670951157 3.188974617
## 6 2.260638298 3.026855407
## pct_Civ_emp_65p_ACS_08_12 pct_Civ_emp_65p_ACSMOE_08_12
## 1 <NA> <NA>
## 2 <NA> <NA>
## 3 85.18518519 73.57920864
## 4 100 77.67857143
## 5 100 100
## 6 100 100
## pct_Civ_unemp_65p_ACS_08_12 pct_Civ_unemp_65p_ACSMOE_08_12
## 1 <NA> <NA>
## 2 <NA> <NA>
## 3 14.81481482 23.39411967
## 4 0 15.17857143
## 5 0 15.78947368
## 6 0 41.37931035
## pct_Pop_1yr_Over_ACS_08_12 pct_Pop_1yr_Over_ACSMOE_08_12
## 1 97.25923106 12.38141022
## 2 98.24561404 15.36949464
## 3 98.01512287 11.92233311
## 4 99.2386226 13.12750352
## 5 98.58093126 1.86702002
## 6 99.46274235 9.81778413
## pct_Diff_HU_1yr_Ago_ACS_08_12 pct_Diff_HU_1yr_Ago_ACSMOE_08_12
## 1 60.97847358 5.453456444
## 2 49.40476191 5.464911659
## 3 21.82577949 1.820568878
## 4 13.47863993 1.25502942
## 5 22.67206478 2.085666778
## 6 30.46031001 2.117485148
## pct_Born_US_ACS_08_12 pct_Born_US_ACSMOE_08_12 pct_Born_foreign_ACS_08_12
## 1 93.45260754 3.060211986 6.547392463
## 2 97.36842105 15.19754108 2.631578947
## 3 77.78827977 9.715175236 22.21172023
## 4 94.41079772 2.327333096 5.589202284
## 5 91.41906874 3.246668029 8.580931264
## 6 90.77318384 3.651641652 9.226816164
## pct_Born_foreign_ACSMOE_08_12 pct_US_Cit_Nat_ACS_08_12
## 1 4.145057601 5.138941759
## 2 1.680626122 2.192982456
## 3 7.838384545 1.039697543
## 4 3.035016484 1.12476207
## 5 7.276183312 0.199556541
## 6 4.130969538 4.227984116
## pct_US_Cit_Nat_ACSMOE_08_12 pct_NON_US_Cit_ACS_08_12
## 1 4.084705782 1.408450704
## 2 1.540468938 0.438596491
## 3 1.572607828 21.17202268
## 4 0.754006972 4.464440215
## 5 0.332108719 8.381374723
## 6 2.951763988 4.998832049
## pct_NON_US_Cit_ACSMOE_08_12 pct_ENG_VW_SPAN_ACS_08_12
## 1 0.789141005 0
## 2 0.582779079 0
## 3 7.325432256 15.98130841
## 4 2.614073407 0.304414003
## 5 7.255775945 0
## 6 3.133951655 0.536847243
## pct_ENG_VW_SPAN_ACSMOE_08_12 pct_ENG_VW_INDOEURO_ACS_08_12
## 1 1.384364821 0
## 2 4.615384615 0
## 3 6.711599816 0
## 4 0.303409344 0
## 5 0.774693351 0
## 6 0.780287193 1.220107369
## pct_ENG_VW_INDOEURO_ACSMOE_08_12 pct_ENG_VW_API_ACS_08_12
## 1 1.384364821 0
## 2 4.615384615 0
## 3 0.794392523 0
## 4 0.862506342 0
## 5 0.774693351 4.90639122
## 6 1.560235402 1.952171791
## pct_ENG_VW_API_ACSMOE_08_12 pct_ENG_VW_OTHER_ACS_08_12
## 1 1.384364821 0
## 2 4.615384615 0
## 3 0.794392523 0
## 4 0.862506342 0
## 5 5.155663074 0
## 6 1.997974147 0
## pct_ENG_VW_OTHER_ACSMOE_08_12 pct_ENG_VW_ACS_08_12 pct_ENG_VW_ACSMOE_08_12
## 1 1.384364821 0 1.384364821
## 2 4.615384615 0 4.615384615
## 3 0.794392523 15.98130841 6.759095055
## 4 0.862506342 0.304414003 0.912907614
## 5 0.774693351 4.90639122 5.22033165
## 6 0.585651537 3.709126403 2.725100695
## pct_Rel_Family_HHDS_CEN_2010 pct_Rel_Family_HHD_ACS_08_12
## 1 87.64 83.8762215
## 2 89.1 94.61538462
## 3 66.45 74.20560748
## 4 76.92 78.89396246
## 5 76.28 75.85539058
## 6 47.83 46.07125427
## pct_Rel_Family_HHD_ACSMOE_08_12 pct_MrdCple_HHD_CEN_2010
## 1 5.274224765 79.59
## 2 16.39333495 78.57
## 3 6.133930514 44.03
## 4 3.722041742 58.45
## 5 4.972657592 64.29
## 6 6.059975215 29.3
## pct_MrdCple_HHD_ACS_08_12 pct_MrdCple_HHD_ACSMOE_08_12
## 1 70.35830619 6.018817231
## 2 86.15384615 5.452016548
## 3 39.95327103 8.284044975
## 4 62.65854896 6.130036072
## 5 72.24015494 5.841141838
## 6 28.9409468 4.963015871
## pct_Not_MrdCple_HHD_CEN_2010 pct_Not_MrdCple_HHD_ACS_08_12
## 1 20.41 29.64169381
## 2 21.43 13.84615385
## 3 55.97 60.04672897
## 4 41.55 37.34145104
## 5 35.71 27.75984506
## 6 70.7 71.0590532
## pct_Not_MrdCple_HHD_ACSMOE_08_12 pct_Female_No_HB_CEN_2010
## 1 7.633040372 6.02
## 2 9.07210012 9.02
## 3 9.453509204 16.8
## 4 6.980604097 12.74
## 5 6.889802296 9.34
## 6 8.587085223 13.99
## pct_Female_No_HB_ACS_08_12 pct_Female_No_HB_ACSMOE_08_12
## 1 11.80781759 5.087376401
## 2 6.923076923 4.926862592
## 3 21.58878505 6.281083585
## 4 12.9883308 3.866955381
## 5 3.615235636 2.442942416
## 6 11.07857492 5.577945142
## pct_NonFamily_HHD_CEN_2010 pct_NonFamily_HHD_ACS_08_12
## 1 12.36 16.1237785
## 2 10.9 5.384615385
## 3 33.55 25.79439252
## 4 23.08 21.10603754
## 5 23.72 24.14460943
## 6 52.17 53.92874573
## pct_NonFamily_HHD_ACSMOE_08_12 pct_Sngl_Prns_HHD_CEN_2010
## 1 5.944263359 9.11
## 2 7.277579718 10.9
## 3 7.16211598 27.98
## 4 5.524275499 19.62
## 5 6.478894079 21.45
## 6 6.450620873 45.69
## pct_Sngl_Prns_HHD_ACS_08_12 pct_Sngl_Prns_HHD_ACSMOE_08_12
## 1 14.08794788 5.853261516
## 2 0.769230769 1.920745059
## 3 25 7.081867817
## 4 19.98985287 5.551566811
## 5 21.7559716 5.850511536
## 6 43.38701806 6.016895018
## pct_HHD_PPL_Und_18_CEN_2010 pct_HHD_PPL_Und_18_ACS_08_12
## 1 68.62 66.28664495
## 2 66.17 76.92307692
## 3 38.37 49.20560748
## 4 40.03 38.66057839
## 5 35.96 41.3169787
## 6 26.75 28.50170815
## pct_HHD_PPL_Und_18_ACSMOE_08_12 avg_Tot_Prns_in_HHD_CEN_2010
## 1 5.74510613 3.326
## 2 7.247554579 3.3008
## 3 6.885504507 2.7021
## 4 4.491674427 2.783
## 5 7.243067322 2.5581
## 6 5.328765399 1.9969
## avg_Tot_Prns_in_HHD_ACS_08_12 avg_Tot_Prns_in_HHD_ACSMOE_08_12
## 1 3.416938111 0.5574852
## 2 3.419230769 0.092008619
## 3 2.914018692 0.13094829
## 4 2.932014206 0.138735189
## 5 2.911555843 0.19010103
## 6 2.089311859 0.087671196
## pct_Rel_Under_6_CEN_2010 pct_Rel_Under_6_ACS_08_12
## 1 57.79 57.76699029
## 2 41.77 55.69105691
## 3 28.98 32.49370277
## 4 22.51 23.92282958
## 5 22.72 31.65957447
## 6 22.52 22.77542373
## pct_Rel_Under_6_ACSMOE_08_12 pct_HHD_Moved_in_ACS_08_12
## 1 11.68769029 39.90228013
## 2 14.32524914 44.23076923
## 3 10.66037041 14.43925234
## 4 7.450121647 9.538305429
## 5 13.66210185 10.2646869
## 6 10.5244766 21.57149829
## pct_HHD_Moved_in_ACSMOE_08_12 pct_PUB_ASST_INC_ACS_08_12
## 1 9.912601133 0
## 2 13.56372555 0
## 3 6.447792157 2.803738318
## 4 4.705878243 3.348554034
## 5 8.303620404 0
## 6 5.730006997 0.976085896
## pct_PUB_ASST_INC_ACSMOE_08_12 pct_Tot_Occp_Units_CEN_2010
## 1 1.384364821 84.36
## 2 4.615384615 67
## 3 2.467297328 91.85
## 4 2.981036803 88.55
## 5 0.774693351 96.16
## 6 1.121161166 91.71
## pct_Tot_Occp_Units_ACS_08_12 pct_Tot_Occp_Units_ACSMOE_08_12
## 1 83.76534789 8.496484104
## 2 83.33333333 15.5982906
## 3 95.96412556 10.58782583
## 4 81.51364764 4.637984468
## 5 97.54408061 3.605285312
## 6 90.02636204 4.460669239
## pct_Vacant_Units_CEN_2010 pct_Vacant_Units_ACS_08_12
## 1 15.64 16.23465212
## 2 33 16.66666667
## 3 8.15 4.03587444
## 4 11.45 18.48635236
## 5 3.84 2.455919396
## 6 8.29 9.973637961
## pct_Vacant_Units_ACSMOE_08_12 pct_Renter_Occp_HU_CEN_2010
## 1 7.897362863 98.78
## 2 9.653887773 96.99
## 3 3.528088125 48.75
## 4 5.816313913 24.7
## 5 3.776361635 9.28
## 6 4.737877129 70.7
## pct_Renter_Occp_HU_ACS_08_12 pct_Renter_Occp_HU_ACSMOE_08_12
## 1 100 17.50492357
## 2 100 17.40570538
## 3 47.75700935 6.087288203
## 4 26.23033993 6.135165597
## 5 10.32924467 6.099487671
## 6 71.79111762 6.344536145
## pct_Owner_Occp_HU_CEN_2010 pct_Owner_Occp_HU_ACS_08_12
## 1 1.22 0
## 2 3.01 0
## 3 51.25 52.24299065
## 4 75.3 73.76966007
## 5 90.72 89.67075533
## 6 29.3 28.20888238
## pct_Owner_Occp_HU_ACSMOE_08_12 pct_Single_Unit_ACS_08_12
## 1 1.384364821 92.56480218
## 2 4.615384615 83.33333333
## 3 6.091851215 72.37668161
## 4 6.555231852 57.98180314
## 5 5.115387429 100
## 6 4.925035895 30.71177504
## pct_Single_Unit_ACSMOE_08_12 pct_MLT_U2_9_STRC_ACS_08_12
## 1 9.805006519 3.206002729
## 2 6.565081836 15.38461539
## 3 6.413130934 16.09865471
## 4 7.195874877 6.038047974
## 5 0.794050391 0
## 6 5.609714654 45.82601055
## pct_MLT_U2_9_STRC_ACSMOE_08_12 pct_MLT_U10p_ACS_08_12
## 1 3.881473217 1.500682128
## 2 11.33264404 1.282051282
## 3 6.1466158 6.233183857
## 4 3.456309926 0.124069479
## 5 0.755667506 0
## 6 7.5044389 22.05623902
## pct_MLT_U10p_ACSMOE_08_12 pct_Mobile_Homes_ACS_08_12
## 1 2.111915945 2.72851296
## 2 4.16274209 0
## 3 4.231263994 3.721973094
## 4 0.703023681 35.8560794
## 5 0.755667506 0
## 6 5.328652117 1.405975395
## pct_Mobile_Homes_ACSMOE_08_12 pct_Crowd_Occp_U_ACS_08_12
## 1 3.200154111 0.570032573
## 2 3.846153846 2.692307692
## 3 4.114969754 5.700934579
## 4 6.45692734 5.834601725
## 5 0.755667506 0
## 6 1.93286083 3.562713519
## pct_Crowd_Occp_U_ACSMOE_08_12 pct_NO_PH_SRVC_ACS_08_12
## 1 0.892982296 1.71009772
## 2 3.05902853 0
## 3 4.135866778 3.271028037
## 4 3.212353519 1.62354135
## 5 0 0.645577792
## 6 3.361554516 1.464128843
## pct_NO_PH_SRVC_ACSMOE_08_12 pct_No_Plumb_ACS_08_12 pct_No_Plumb_ACSMOE_08_12
## 1 2.106656257 1.637107776 2.726040131
## 2 4.615384615 0 3.846153846
## 3 2.792509559 0 0.762331839
## 4 1.719970644 2.315963606 2.891847314
## 5 1.355122845 0.818639799 1.258787212
## 6 1.266248089 0.263620387 0.483254075
## pct_Recent_Built_HU_ACS_08_12 pct_Recent_Built_HU_ACSMOE_08_12
## 1 5.798090041 4.003482024
## 2 0 3.846153846
## 3 0 0.762331839
## 4 1.94375517 3.058310491
## 5 0 0.755667506
## 6 0.527240773 0.834682175
## pct_TEA_MailOutMailBack_CEN_2010 pct_TEA_Update_Leave_CEN_2010
## 1 100 0
## 2 100 0
## 3 100 0
## 4 100 0
## 5 100 0
## 6 100 0
## pct_Census_Mail_Returns_CEN_2010 pct_Vacant_CEN_2010 pct_Deletes_CEN_2010
## 1 63.78 2.15 0
## 2 45.07 3.52 0
## 3 63.14 2.48 0
## 4 63.27 3.52 0
## 5 81.77 1.97 0
## 6 67.06 4.38 0
## pct_Census_UAA_CEN_2010 pct_Mailback_Count_CEN_2010 pct_FRST_FRMS_CEN_2010
## 1 18.88 78.97 55.58
## 2 42.72 53.76 37.79
## 3 10.39 87.13 55.74
## 4 17.02 79.45 56.31
## 5 2.98 95.06 81.77
## 6 6.99 88.63 58.64
## pct_RPLCMNT_FRMS_CEN_2010 pct_BILQ_Mailout_count_CEN_2010
## 1 8.2 0
## 2 7.28 0
## 3 7.4 0
## 4 6.96 0
## 5 0 0
## 6 8.42 0head(dbReadTable(con, name = "schooldistricts_geocoding_TEXAS_done"))## leaid11 District State ADDRESS
## 1 4800003 ROCKSPRINGS ISD TEXAS ROCKSPRINGS ISD, TEXAS
## 2 4800001 CROSBYTON CISD TEXAS CROSBYTON CISD, TEXAS
## 3 4800002 SPUR ISD TEXAS SPUR ISD, TEXAS
## 4 4800004 POR VIDA ACADEMY TEXAS POR VIDA ACADEMY, TEXAS
## 5 4800006 ASPERMONT ISD TEXAS ASPERMONT ISD, TEXAS
## 6 4800005 BLACKWELL CISD TEXAS BLACKWELL CISD, TEXAS
## MATCH_ADDR MATCH_TYPE LATITUDE LONGITUDE
## 1 APPROXIMATE 31.25044 -99.25061
## 2 CROSBYTON CISD, TEXAS ROOFTOP 33.476216 -101.100685
## 3 APPROXIMATE 31.25044 -99.25061
## 4 POR VIDA ACADEMY, TEXAS ROOFTOP 33.653141 -95.559063
## 5 ASPERMONT ISD, TEXAS ROOFTOP 33.139647 -100.224966
## 6 APPROXIMATE 31.25044 -99.25061Execute a query and fetch the results
res <-
dbSendQuery(con, statement = "SELECT * FROM Graduation_Rates")
answer <- dbFetch(res)
answer <- as_tibble(answer)
answer## # A tibble: 11,325 × 24
## STNAM FIPST leaid11 leanm11 ALL_COHORT_1112 ALL_RATE_1112 MAM_COHORT_1112
## <chr> <chr> <chr> <chr> <int> <chr> <dbl>
## 1 ALABAMA 1 100005 Albertvi… 268 83 NA
## 2 ALABAMA 1 100006 Marshall… 424 79 2
## 3 ALABAMA 1 100007 Hoover C… 1042 91 1
## 4 ALABAMA 1 100008 Madison … 836 91 4
## 5 ALABAMA 1 100011 Leeds Ci… 117 70-74 NA
## 6 ALABAMA 1 100012 Boaz City 155 90-94 NA
## 7 ALABAMA 1 100013 Trussvil… 300 93 1
## 8 ALABAMA 1 100030 Alexande… 289 78 1
## 9 ALABAMA 1 100060 Andalusi… 109 75-79 NA
## 10 ALABAMA 1 100090 Anniston… 207 65 NA
## # ℹ 11,315 more rows
## # ℹ 17 more variables: MAM_RATE_1112 <chr>, MAS_COHORT_1112 <chr>,
## # MAS_RATE_1112 <chr>, MBL_COHORT_1112 <chr>, MBL_RATE_1112 <chr>,
## # MHI_COHORT_1112 <chr>, MHI_RATE_1112 <chr>, MTR_COHORT_1112 <chr>,
## # MTR_RATE_1112 <chr>, MWH_COHORT_1112 <chr>, MWH_RATE_1112 <chr>,
## # CWD_COHORT_1112 <chr>, CWD_RATE_1112 <chr>, ECD_COHORT_1112 <chr>,
## # ECD_RATE_1112 <chr>, LEP_COHORT_1112 <chr>, LEP_RATE_1112 <chr>The data needs to be cleaned (data types: factors, numbers, etc.)
str(answer)## tibble [11,325 × 24] (S3: tbl_df/tbl/data.frame)
## $ STNAM : chr [1:11325] "ALABAMA" "ALABAMA" "ALABAMA" "ALABAMA" ...
## $ FIPST : chr [1:11325] "1" "1" "1" "1" ...
## $ leaid11 : chr [1:11325] "100005" "100006" "100007" "100008" ...
## $ leanm11 : chr [1:11325] "Albertville City" "Marshall County" "Hoover City" "Madison City" ...
## $ ALL_COHORT_1112: int [1:11325] 268 424 1042 836 117 155 300 289 109 207 ...
## $ ALL_RATE_1112 : chr [1:11325] "83" "79" "91" "91" ...
## $ MAM_COHORT_1112: num [1:11325] NA 2 1 4 NA NA 1 1 NA NA ...
## $ MAM_RATE_1112 : chr [1:11325] NA "PS" "PS" "PS" ...
## $ MAS_COHORT_1112: chr [1:11325] NA "1" "71" "44" ...
## $ MAS_RATE_1112 : chr [1:11325] NA "PS" "85-89" "GE90" ...
## $ MBL_COHORT_1112: chr [1:11325] "6" "4" "224" "195" ...
## $ MBL_RATE_1112 : chr [1:11325] "GE50" "PS" "85-89" "85-89" ...
## $ MHI_COHORT_1112: chr [1:11325] "49" "26" "52" "23" ...
## $ MHI_RATE_1112 : chr [1:11325] "60-69" "60-79" "60-69" "60-79" ...
## $ MTR_COHORT_1112: chr [1:11325] NA NA "5" "2" ...
## $ MTR_RATE_1112 : chr [1:11325] NA NA "PS" "PS" ...
## $ MWH_COHORT_1112: chr [1:11325] "213" "391" "688" "566" ...
## $ MWH_RATE_1112 : chr [1:11325] "85-89" "79" "94" "93" ...
## $ CWD_COHORT_1112: chr [1:11325] "18" "66" "63" "72" ...
## $ CWD_RATE_1112 : chr [1:11325] "60-79" "70-74" "70-74" "60-64" ...
## $ ECD_COHORT_1112: chr [1:11325] "107" "250" "216" "163" ...
## $ ECD_RATE_1112 : chr [1:11325] "70-74" "70-74" "75-79" "80-84" ...
## $ LEP_COHORT_1112: chr [1:11325] "9" "9" "21" "7" ...
## $ LEP_RATE_1112 : chr [1:11325] "LT50" "LT50" "21-39" "GE50" ...grad_data <- answer %>% transmute(state = as.factor(STNAM),
grad_rate_all = as.numeric(ALL_RATE_1112),
cohort_size_all = as.numeric(ALL_COHORT_1112))## Warning: There was 1 warning in `transmute()`.
## ℹ In argument: `grad_rate_all = as.numeric(ALL_RATE_1112)`.
## Caused by warning:
## ! NAs introduced by coerciongrad_data## # A tibble: 11,325 × 3
## state grad_rate_all cohort_size_all
## <fct> <dbl> <dbl>
## 1 ALABAMA 83 268
## 2 ALABAMA 79 424
## 3 ALABAMA 91 1042
## 4 ALABAMA 91 836
## 5 ALABAMA NA 117
## 6 ALABAMA NA 155
## 7 ALABAMA 93 300
## 8 ALABAMA 78 289
## 9 ALABAMA NA 109
## 10 ALABAMA 65 207
## # ℹ 11,315 more rowsLook at a simple plot
ggplot(grad_data, aes(x = cohort_size_all, y = grad_rate_all)) +
geom_point() + geom_smooth()## `geom_smooth()` using method = 'gam' and formula = 'y ~ s(x, bs = "cs")'## Warning: Removed 7732 rows containing non-finite values (`stat_smooth()`).## Warning: Removed 7732 rows containing missing values (`geom_point()`).
Clean up result and disconnect from the database. The database will be destroyed since we have created a in-memory db.
dbClearResult(res)
dbDisconnect(con)TODO
- Create a well formatted R Markdown document.
- Identify keys in the database to be able to join the different tables.
- Identify up to 10 important variables.
- Design the SQL statement that joins the needed tables and selects the used variables.
- Clean the data (use good names, missing values, fix data types, …).
- Descriptive analytics: Calculate statistics (e.g., averages, correlations) and create visualizations to find patterns.
- Prescriptive analytics: Experiment with models (regression, classification, clustering).
- Formulate recommendations backed by the analyzed data.