afcars19 <- read_dta("/Volumes/backupPlus/ndacan/data/afcars/DS239 FC2019v3/Data/Stata/FC2019v3.dta")
afcars16 <- read_dta("/Volumes/backupPlus/ndacan/data/afcars/DS215 FC2016v6/Data/Stata Files/FC2016v6.dta")
review 2016 data
## [1] "dimensions of 2016 original data:"
## [1] 689528 107
## # A tibble: 6 × 107
## fy version state st repdatyr repdatmo fipscode recnumbr sex
## <dbl> <dbl> <dbl+lbl> <chr> <dbl> <dbl> <dbl+lbl> <chr> <dbl+l>
## 1 2016 1 26 [Michig… MI 2017 3 26163 [Way… 9998301… 1 [Mal…
## 2 2016 1 26 [Michig… MI 2017 3 26125 [Oak… 9998301… 2 [Fem…
## 3 2016 1 26 [Michig… MI 2016 9 8 [Few… 9998301… 1 [Mal…
## 4 2016 1 26 [Michig… MI 2016 9 8 [Few… 9998301… 1 [Mal…
## 5 2016 1 26 [Michig… MI 2016 9 8 [Few… 9998301… 1 [Mal…
## 6 2016 1 26 [Michig… MI 2016 9 8 [Few… 9998301… 2 [Fem…
## # ℹ 98 more variables: amiakn <dbl+lbl>, asian <dbl+lbl>, blkafram <dbl+lbl>,
## # hawaiipi <dbl+lbl>, white <dbl+lbl>, untodetm <dbl+lbl>,
## # hisorgin <dbl+lbl>, clindis <dbl+lbl>, mr <dbl+lbl>, vishear <dbl+lbl>,
## # phydis <dbl+lbl>, emotdist <dbl+lbl>, othermed <dbl+lbl>,
## # everadpt <dbl+lbl>, ageadopt <dbl+lbl>, totalrem <dbl>, numplep <dbl>,
## # manrem <dbl+lbl>, phyabuse <dbl+lbl>, sexabuse <dbl+lbl>,
## # neglect <dbl+lbl>, aaparent <dbl+lbl>, daparent <dbl+lbl>, aachild <dbl>, …
review 2019 data
## [1] "dimensions of 2019 original data:"
## [1] 676019 107
## # A tibble: 6 × 107
## fy version state st repdatyr repdatmo fipscode recnumbr sex amiakn
## <dbl> <dbl> <dbl+l> <chr> <dbl> <dbl> <dbl+lb> <chr> <dbl+l> <dbl+>
## 1 2019 3 1 [Ala… AL 2019 9 8 [Fewe… 0000000… 1 [Mal… 0 [No]
## 2 2019 3 1 [Ala… AL 2020 3 8 [Fewe… 0000000… 1 [Mal… 0 [No]
## 3 2019 3 1 [Ala… AL 2019 9 8 [Fewe… 0000000… 2 [Fem… 0 [No]
## 4 2019 3 1 [Ala… AL 2019 9 8 [Fewe… 0000000… 2 [Fem… 0 [No]
## 5 2019 3 1 [Ala… AL 2019 9 8 [Fewe… 0000000… 2 [Fem… 0 [No]
## 6 2019 3 1 [Ala… AL 2019 9 8 [Fewe… 0000000… 1 [Mal… 0 [No]
## # ℹ 97 more variables: asian <dbl+lbl>, blkafram <dbl+lbl>, hawaiipi <dbl+lbl>,
## # white <dbl+lbl>, untodetm <dbl+lbl>, hisorgin <dbl+lbl>, clindis <dbl+lbl>,
## # mr <dbl+lbl>, vishear <dbl+lbl>, phydis <dbl+lbl>, emotdist <dbl+lbl>,
## # othermed <dbl+lbl>, everadpt <dbl+lbl>, ageadopt <dbl+lbl>, totalrem <dbl>,
## # numplep <dbl>, manrem <dbl+lbl>, phyabuse <dbl+lbl>, sexabuse <dbl+lbl>,
## # neglect <dbl+lbl>, aaparent <dbl+lbl>, daparent <dbl+lbl>,
## # aachild <dbl+lbl>, dachild <dbl+lbl>, childis <dbl+lbl>, …
2016: look at disreasns
##
## 1 2 3 4 5 6 7 8 99
## 126903 16425 56646 21784 24324 4380 869 322 437875
2016: keep only disreasn==1
## [1] "dimensions of 2016 disreasn==1 data:"
## [1] 126903 107
merge 2016-2019 by stfcid
view reunified-returned sample
## [1] "number of children who reunfied in 2016 and were back in FC in 2019:"
## [1] 12382 213
## [1] "note: 114,521 children reunified in 2016 and did not return to FC"
merge those who 1) reunfied in 2016 and did not return in 2019
(N=114521) with:
2) those who reunified in 2016 and returned in 2019 N=12382)
reorganize sample
## [1] "double check the number of kids who return in 2016"
##
## 2019
## 12382
write out final sample (N=126903)