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)