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