afcars19 <- read_dta("/Volumes/backupPlus/ndacan/data/afcars/DS239 FC2019v3/Data/Stata/FC2019v3.dta")
afcars16 <- read_dta("/Volumes/backupPlus/ndacan/data/afcars/DS215 FC2016v7/Data/Stata Files/FC2016v7.dta")
print("dimensions of 2016 original data:")
## [1] "dimensions of 2016 original data:"
dim(afcars16)
## [1] 684866    107
head(afcars16)
## # 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       7 1 [Alabama] AL        2016        9    8 [Fewe… 0000000… 1 [Mal…
## 2  2016       7 1 [Alabama] AL        2016        9    8 [Fewe… 0000000… 2 [Fem…
## 3  2016       7 1 [Alabama] AL        2016        3    8 [Fewe… 0000000… 1 [Mal…
## 4  2016       7 1 [Alabama] AL        2016        9    8 [Fewe… 0000000… 1 [Mal…
## 5  2016       7 1 [Alabama] AL        2016        9 1073 [Jeff… 0000000… 2 [Fem…
## 6  2016       7 1 [Alabama] AL        2016        9    8 [Fewe… 0000000… 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>, …

look at 2016 Texas

afcars_16_tx <- subset(afcars16,st=="TX")
head(afcars_16_tx)
## # 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       7 48 [Texas] TX        2016        9 48201 [Harr… ®©¬®¸´÷… 1 [Mal…
## 2  2016       7 48 [Texas] TX        2016        3     8 [Fewe… ®©¬®¸´÷… 2 [Fem…
## 3  2016       7 48 [Texas] TX        2016        3     8 [Fewe… ®©¬®¸´÷… 2 [Fem…
## 4  2016       7 48 [Texas] TX        2016        9     8 [Fewe… ®©¬®¸´÷… 1 [Mal…
## 5  2016       7 48 [Texas] TX        2016        9     8 [Fewe… ®©¬®¸´÷… 1 [Mal…
## 6  2016       7 48 [Texas] TX        2016        9     8 [Fewe… ®©¬®¸´÷… 1 [Mal…
## # ℹ 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>, …

review 2019 data

print("dimensions of 2019 original data:")
## [1] "dimensions of 2019 original data:"
dim(afcars19)
## [1] 676019    107
head(afcars19)
## # 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>, …

merge 2016-2019 by stfcid

afcars_16_19 <- merge(afcars16,afcars19,by="stfcid")

view merge

print("dimensions of 2016-2019 merged on stfcid only:")
## [1] "dimensions of 2016-2019 merged on stfcid only:"
dim(afcars_16_19)
## [1] 147003    213
head(afcars_16_19)
##           stfcid fy.x version.x state.x st.x repdatyr.x repdatmo.x fipscode.x
## 1 AK450200294105 2016         7       2   AK       2016          9          8
## 2 AK450527397376 2016         7       2   AK       2016          9       2020
## 3 AK450615498257 2016         7       2   AK       2016          9       2020
## 4 AK450617698279 2016         7       2   AK       2016          9          8
## 5 AK450880700910 2016         7       2   AK       2016          9          8
## 6 AK450939901502 2016         7       2   AK       2016          9          8
##     recnumbr.x sex.x amiakn.x asian.x blkafram.x hawaiipi.x white.x untodetm.x
## 1 450200294105     2        1       0          0          0       0          0
## 2 450527397376     1        1       0          0          0       0          0
## 3 450615498257     1        1       0          0          0       0          0
## 4 450617698279     1        1       0          0          0       0          0
## 5 450880700910     1        0       0          0          0       1          0
## 6 450939901502     1        0       0          0          0       1          0
##   hisorgin.x clindis.x mr.x vishear.x phydis.x emotdist.x othermed.x everadpt.x
## 1          2         2    0         0        0          0          0          2
## 2          2         2    0         0        0          0          0          2
## 3          2         1    0         0        0          1          1          2
## 4          2         2    0         0        0          0          0          2
## 5          2         2    0         0        0          0          0          2
## 6          2         1    0         0        0          0          1          2
##   ageadopt.x totalrem.x numplep.x manrem.x phyabuse.x sexabuse.x neglect.x
## 1          0          1        12        2          0          0         1
## 2          0          1         6        2          0          0         1
## 3          0          2        20        2          1          0         0
## 4          0          1         5        2          1          1         1
## 5          0          1         1        2          0          0         1
## 6          0          1         1        2          0          0         1
##   aaparent.x daparent.x aachild.x dachild.x childis.x chbehprb.x prtsdied.x
## 1          0          0         0         0         0          0          0
## 2          0          0         0         0         0          0          0
## 3          0          0         0         0         0          0          0
## 4          1          1         0         0         0          0          0
## 5          0          1         0         0         0          0          0
## 6          0          0         0         0         0          0          0
##   prtsjail.x nocope.x abandmnt.x relinqsh.x housing.x curplset.x placeout.x
## 1          1        0          0          0         0          3          2
## 2          0        0          0          0         0          3          2
## 3          0        0          0          0         0          5          1
## 4          1        0          0          0         0          3          2
## 5          0        0          0          0         1          3          2
## 6          0        0          0          0         1          8          2
##   casegoal.x ctkfamst.x ctk1yr.x ctk2yr.x fosfamst.x fcctk1yr.x fcctk2yr.x
## 1          1          3     1980     1970          3       1956       1980
## 2          3          3     1974       NA          1       1961       1951
## 3          3          4     1967       NA         NA         NA         NA
## 4          1          1     1962     1954          1       1977         NA
## 5         99          2     1984     1999          3       1962         NA
## 6          1          4     1966       NA          0         NA         NA
##   rf1amakn.x rf1asian.x rf1blkaa.x rf1nhopi.x rf1white.x rf1utod.x hofcctk1.x
## 1          0          0          0          0          1         0          2
## 2          0          0          1          0          0         0          2
## 3         NA         NA         NA         NA         NA        NA         NA
## 4          0          0          0          0          1         0          2
## 5          0          0          0          0          1         0          2
## 6          0         NA         NA         NA         NA        NA          0
##   rf2amakn.x rf2asian.x rf2blkaa.x rf2nhopi.x rf2white.x rf2utod.x hofcctk2.x
## 1          0         NA         NA         NA         NA        NA          0
## 2          0          0          1          0          0         0          2
## 3         NA         NA         NA         NA         NA        NA         NA
## 4         NA         NA         NA         NA         NA        NA         NA
## 5          0         NA         NA         NA         NA        NA          0
## 6          0         NA         NA         NA         NA        NA          0
##   disreasn.x ivefc.x iveaa.x ivaafdc.x ivdchsup.x xixmedcd.x ssiother.x noa.x
## 1         99       1       0         0          0          1          0     1
## 2         99       0       0         0          1          1          1     1
## 3         99       1       0         0          0          1          1     0
## 4         99       1       0         0          1          1          0     0
## 5         99       1       0         0          0          1          0     0
## 6          1       1       0         0          0          1          1     0
##   fcmntpay.x      dob.x pedrevdt.x   rem1dt.x remtrndt.x dlstfcdt.x latremdt.x
## 1        937 2001-09-15 2016-06-27 2015-02-05 2015-02-07            2015-02-05
## 2        937 2001-03-15 2016-07-16 2009-07-10 2009-07-18            2009-07-10
## 3        181 2001-10-15 2016-07-22 2003-10-23 2007-03-26 2006-04-10 2007-03-23
## 4        937 2001-07-15 2016-05-18 2013-02-15 2013-02-19            2013-02-15
## 5        893 2004-08-15            2016-06-30 2016-07-01            2016-06-30
## 6        641 2003-07-15 2016-03-30 2015-01-20 2015-01-20            2015-01-20
##   cursetdt.x  dodfcdt.x dodtrndt.x tprmomdt.x tprdaddt.x  tprdate.x latremlos.x
## 1 2016-08-15                                                                617
## 2 2012-02-17                       2016-01-15 2016-01-15 2016-01-15        2640
## 3 2016-09-04                       2016-01-25 2016-01-25 2016-01-25        3482
## 4 2014-07-06                       2016-08-08 2016-08-08 2016-08-08        1330
## 5 2016-06-30                                                                 87
## 6 2016-05-16 2016-08-04 2016-08-23 2009-03-10                               562
##   settinglos.x previouslos.x lifelos.x ageatstart.x ageatlatrem.x ageatend.x
## 1           60            NA       617           14            13         15
## 2         1688            NA      2640           14             8         15
## 3           29           900      4382           13             5         14
## 4          824            NA      1330           14            11         15
## 5           87            NA        87           11            11         12
## 6           80            NA       562           12            11         13
##   inatstart.x inatend.x entered.x exited.x served.x iswaiting.x istpr.x
## 1           1         1         0        0        1           0       0
## 2           1         1         0        0        1           1       1
## 3           1         1         0        0        1           1       1
## 4           1         1         0        0        1           1       1
## 5           0         1         1        0        1           0       0
## 6           1         0         0        1        1           0       0
##   agedout.x raceethn.x race.x ru13.x periodstart.x periodend.x fy.y version.y
## 1         0          3      3      7    2015-10-01  2016-09-30 2019         3
## 2         0          3      3      2    2015-10-01  2016-09-30 2019         3
## 3         0          3      3      2    2015-10-01  2016-09-30 2019         3
## 4         0          3      3      7    2015-10-01  2016-09-30 2019         3
## 5         0          1      1      2    2015-10-01  2016-09-30 2019         3
## 6         0          1      1      7    2015-10-01  2016-09-30 2019         3
##   state.y st.y repdatyr.y repdatmo.y fipscode.y   recnumbr.y sex.y amiakn.y
## 1       2   AK       2019          9          8 450200294105     2        1
## 2       2   AK       2019          9       2020 450527397376     1        1
## 3       2   AK       2019          9       2020 450615498257     1        1
## 4       2   AK       2019          9          8 450617698279     1        1
## 5       2   AK       2019          9          8 450880700910     1        0
## 6       2   AK       2019          9       2020 450939901502     1        0
##   asian.y blkafram.y hawaiipi.y white.y untodetm.y hisorgin.y clindis.y mr.y
## 1       0          0          0       0          0          2         2    0
## 2       0          0          0       0          0          2         2    0
## 3       0          0          0       0          0          2         1    0
## 4       0          0          0       0          0          2         2    0
## 5       0          0          0       1          0          2         2    0
## 6       0          0          0       1          0          2         1    0
##   vishear.y phydis.y emotdist.y othermed.y everadpt.y ageadopt.y totalrem.y
## 1         0        0          0          0          2          0          1
## 2         0        0          0          0          2          0          1
## 3         0        0          1          1          2          0          2
## 4         0        0          0          0          2          0          1
## 5         0        0          0          0          2          0          1
## 6         0        0          0          1          2          0          2
##   numplep.y manrem.y phyabuse.y sexabuse.y neglect.y aaparent.y daparent.y
## 1        15        2          0          0         1          0          0
## 2         7        2          0          0         1          0          0
## 3        24        2          1          0         0          0          0
## 4         5        2          1          1         1          1          1
## 5         2        2          0          0         1          0          1
## 6         3        2          0          0         1          0          1
##   aachild.y dachild.y childis.y chbehprb.y prtsdied.y prtsjail.y nocope.y
## 1         0         0         0          0          0          1        0
## 2         0         0         0          0          0          0        0
## 3         0         0         0          0          0          0        0
## 4         0         0         0          0          0          1        0
## 5         0         0         0          0          0          0        0
## 6         0         0         0          0          0          0        0
##   abandmnt.y relinqsh.y housing.y curplset.y placeout.y casegoal.y ctkfamst.y
## 1          0          0         0          3          2          2          3
## 2          0          0         0          5          2          6          3
## 3          0          0         0          4          2          3          4
## 4          0          0         0          3          2          3          1
## 5          0          0         1          1          2          3          2
## 6          0          0         0          1          2          1          4
##   ctk1yr.y ctk2yr.y fosfamst.y fcctk1yr.y fcctk2yr.y rf1amakn.y rf1asian.y
## 1     1980     1970          1       1970       1971          0          0
## 2     1974       NA          0         NA         NA          0         NA
## 3     1967       NA          0         NA         NA          0         NA
## 4     1962     1954          1       1977         NA          0          0
## 5     1984     1999          2       1960       1956          0          0
## 6     1966       NA          1       1965       1955          0          1
##   rf1blkaa.y rf1nhopi.y rf1white.y rf1utod.y hofcctk1.y rf2amakn.y rf2asian.y
## 1          0          0          1         0          2          0          0
## 2         NA         NA         NA        NA          0          0         NA
## 3         NA         NA         NA        NA          0          0         NA
## 4          0          0          1         0          2         NA         NA
## 5          0          0          1         0          2          0          0
## 6          0          0          0         0         NA          0          1
##   rf2blkaa.y rf2nhopi.y rf2white.y rf2utod.y hofcctk2.y disreasn.y ivefc.y
## 1          0          0          1         0          2          4       1
## 2         NA         NA         NA        NA          0          4       0
## 3         NA         NA         NA        NA          0         99       0
## 4         NA         NA         NA        NA         NA          4       1
## 5          0          0          1         0          2         99       1
## 6          0          0          0         0         NA         99       1
##   iveaa.y ivaafdc.y ivdchsup.y xixmedcd.y ssiother.y noa.y fcmntpay.y
## 1       0         0          1          1          0     0        975
## 2       0         0          0          1          0     1        975
## 3       0         0          0          1          1     1        535
## 4       0         0          1          1          0     1        975
## 5       0         0          0          1          0     0        975
## 6       0         0          0          1          1     0        975
##        dob.y pedrevdt.y   rem1dt.y remtrndt.y dlstfcdt.y latremdt.y cursetdt.y
## 1 2001-09-15 2019-08-01 2015-02-05 2015-02-07            2015-02-05 2017-11-06
## 2 2001-03-15 2019-07-13 2009-07-10 2009-07-18            2009-07-10 2019-09-17
## 3 2001-10-15 2019-07-05 2003-10-23 2007-03-26 2006-04-10 2007-03-23 2019-06-16
## 4 2001-07-15 2019-08-19 2013-02-15 2013-02-19            2013-02-15 2014-07-06
## 5 2004-08-15 2019-09-21 2016-06-30 2016-07-01            2016-06-30 2018-11-18
## 6 2003-07-15 2019-08-23 2015-01-20 2019-03-26 2016-08-04 2019-02-02 2019-08-18
##    dodfcdt.y dodtrndt.y tprmomdt.y tprdaddt.y  tprdate.y latremlos.y
## 1 2019-09-26 2019-09-26                                         1694
## 2 2019-04-02 2019-04-02 2014-01-09 2014-02-07 2014-02-07        3553
## 3                       2007-12-10 2007-12-10 2007-12-10        4577
## 4 2019-08-08 2019-08-08 2016-08-08 2016-08-08 2016-08-08        2365
## 5                       2019-05-09 2019-06-02 2019-06-02        1182
## 6                       2009-03-10                               234
##   settinglos.y previouslos.y lifelos.y ageatstart.y ageatlatrem.y ageatend.y
## 1          689            NA      1694           17            13         18
## 2           NA            NA      3553           17             8         18
## 3          109           900      5477           16             5         17
## 4         1859            NA      2365           17            11         18
## 5          311            NA      1182           14            11         15
## 6           37           562       796           15            15         16
##   inatstart.y inatend.y entered.y exited.y served.y iswaiting.y istpr.y
## 1           1         0         0        1        1           0       0
## 2           1         0         0        1        1           0       1
## 3           1         1         0        0        1           1       1
## 4           1         0         0        1        1           0       1
## 5           1         1         0        0        1           1       1
## 6           0         1         1        0        1           0       0
##   agedout.y raceethn.y race.y ru13.y periodstart.y periodend.y
## 1         1          3      3      7    2018-10-01  2019-09-30
## 2         1          3      3      2    2018-10-01  2019-09-30
## 3         0          3      3      2    2018-10-01  2019-09-30
## 4         1          3      3      7    2018-10-01  2019-09-30
## 5         0          1      1      2    2018-10-01  2019-09-30
## 6         0          1      1      2    2018-10-01  2019-09-30