Sheet1
Race | Gender | Orientation | Problem | Service | Housing | Pre-FC | Post-FC | Pre-Acad | Post-Acad | JJ | ST | Pre-MH | Post-MH | SA |
1 | 2 | 1 | 1 | 1 | 1 | 91 | 47 | 2 | 1 | 0 | 2 | 86 | 38 | 1 |
3 | 1 | 1 | 3 | 3 | 2 | 79 | 86 | 2 | 2 | 1 | 0 | 88 | 84 | 2 |
1 | 1 | 1 | 1 | 1 | 1 | 82 | 39 | 2 | 1 | 0 | 0 | 91 | 56 | 1 |
4 | 1 | 1 | 5 | 2 | 1 | 91 | 65 | 2 | 1 | 0 | 0 | 79 | 61 | 1 |
2 | 2 | 1 | 4 | 2 | 3 | 92 | 74 | 2 | 2 | 0 | 1 | 86 | 71 | 1 |
3 | 2 | 1 | 1 | 1 | 1 | 81 | 34 | 2 | 1 | 0 | 2 | 88 | 56 | 1 |
1 | 2 | 1 | 1 | 1 | 1 | 76 | 43 | 2 | 1 | 0 | 0 | 74 | 39 | 1 |
4 | 2 | 1 | 1 | 1 | 2 | 79 | 73 | 2 | 1 | 0 | 0 | 81 | 87 | 2 |
5 | 2 | 1 | 6 | 2 | 1 | 71 | 44 | 2 | 1 | 1 | 0 | 79 | 32 | 1 |
1 | 2 | 1 | 5 | 2 | 2 | 74 | 77 | 2 | 1 | 0 | 1 | 94 | 81 | 2 |
2 | 4 | 1 | 4 | 2 | 3 | 96 | 96 | 2 | 2 | 2 | 1 | 89 | 79 | 1 |
4 | 2 | 3 | 4 | 2 | 2 | 92 | 94 | 2 | 2 | 2 | 1 | 83 | 84 | 2 |
3 | 2 | 1 | 1 | 1 | 3 | 97 | 92 | 2 | 2 | 0 | 1 | 91 | 84 | 2 |
3 | 3 | 2 | 1 | 1 | 2 | 89 | 71 | 2 | 1 | 0 | 1 | 82 | 82 | 2 |
1 | 2 | 2 | 1 | 1 | 1 | 76 | 64 | 1 | 1 | 0 | 0 | 86 | 69 | 1 |
4 | 2 | 1 | 2 | 2 | 1 | 32 | 30 | 2 | 1 | 0 | 0 | 94 | 72 | 1 |
1 | 1 | 3 | 4 | 2 | 2 | 98 | 89 | 2 | 1 | 0 | 1 | 92 | 79 | 2 |
2 | 1 | 3 | 1 | 1 | 3 | 92 | 79 | 2 | 2 | 0 | 0 | 96 | 95 | 2 |
1 | 2 | 1 | 1 | 1 | 1 | 79 | 32 | 1 | 1 | 0 | 0 | 79 | 36 | 1 |
1 | 2 | 3 | 1 | 1 | 2 | 83 | 64 | 2 | 1 | 1 | 2 | 94 | 71 | 1 |
1 | 2 | 3 | 1 | 1 | 2 | 94 | 88 | 2 | 2 | 0 | 1 | 91 | 83 | 2 |
1 | 2 | 3 | 4 | 2 | 2 | 87 | 93 | 2 | 2 | 1 | 1 | 96 | 78 | 1 |
1 | 2 | 2 | 1 | 1 | 1 | 79 | 51 | 2 | 1 | 0 | 0 | 84 | 61 | 1 |
1 | 2 | 2 | 1 | 1 | 2 | 88 | 69 | 2 | 1 | 0 | 0 | 81 | 49 | 1 |
1 | 2 | 3 | 4 | 1 | 3 | 96 | 96 | 2 | 2 | 2 | 1 | 87 | 81 | 2 |
1 | 2 | 3 | 4 | 2 | 1 | 93 | 71 | 2 | 1 | 1 | 2 | 69 | 37 | 1 |
1 | 1 | 1 | 1 | 1 | 1 | 77 | 32 | 2 | 1 | 0 | 0 | 79 | 29 | 1 |
1 | 1 | 2 | 1 | 1 | 2 | 84 | 76 | 1 | 1 | 0 | 0 | 76 | 34 | 1 |
1 | 1 | 1 | 3 | 3 | 1 | 89 | 61 | 1 | 1 | 1 | 0 | 51 | 47 | 1 |
1 | 1 | 1 | 1 | 1 | 1 | 82 | 41 | 2 | 1 | 0 | 0 | 81 | 56 | 1 |
1 | 1 | 1 | 3 | 3 | 1 | 81 | 47 | 2 | 1 | 1 | 0 | 76 | 59 | 1 |
1 | 1 | 3 | 4 | 2 | 2 | 79 | 72 | 2 | 2 | 0 | 1 | 92 | 86 | 1 |
1 | 3 | 3 | 4 | 2 | 1 | 86 | 51 | 2 | 1 | 0 | 2 | 96 | 79 | 1 |
1 | 4 | 2 | 1 | 1 | 2 | 90 | 84 | 2 | 2 | 0 | 0 | 93 | 89 | 2 |
1 | 3 | 3 | 4 | 2 | 3 | 96 | 94 | 2 | 2 | 2 | 1 | 98 | 99 | 2 |
1 | 4 | 1 | 1 | 1 | 3 | 91 | 93 | 2 | 2 | 0 | 0 | 92 | 97 | 2 |
1 | 1 | 1 | 3 | 3 | 2 | 86 | 76 | 2 | 2 | 2 | 0 | 74 | 68 | 1 |
1 | 1 | 3 | 1 | 1 | 2 | 89 | 78 | 2 | 1 | 0 | 0 | 82 | 69 | 1 |
1 | 1 | 3 | 3 | 3 | 2 | 93 | 90 | 2 | 2 | 1 | 0 | 91 | 87 | 2 |
1 | 2 | 2 | 1 | 1 | 2 | 79 | 82 | 2 | 1 | 0 | 0 | 86 | 74 | 1 |
1 | 2 | 2 | 1 | 1 | 1 | 81 | 52 | 2 | 1 | 0 | 0 | 86 | 64 | 1 |
1 | 2 | 3 | 1 | 1 | 1 | 79 | 53 | 2 | 1 | 0 | 0 | 79 | 38 | 1 |
2 | 2 | 3 | 4 | 3 | 2 | 82 | 80 | 2 | 1 | 1 | 2 | 87 | 84 | 2 |
2 | 2 | 3 | 4 | 2 | 3 | 91 | 91 | 2 | 2 | 2 | 1 | 92 | 97 | 2 |
2 | 2 | 1 | 1 | 1 | 2 | 87 | 71 | 1 | 1 | 0 | 0 | 83 | 76 | 1 |
2 | 2 | 1 | 1 | 1 | 2 | 79 | 74 | 1 | 1 | 0 | 0 | 76 | 75 | 1 |
2 | 2 | 1 | 1 | 1 | 1 | 71 | 33 | 1 | 1 | 0 | 0 | 69 | 43 | 1 |
2 | 2 | 1 | 1 | 1 | 3 | 89 | 96 | 2 | 2 | 0 | 0 | 94 | 94 | 2 |
2 | 1 | 2 | 3 | 3 | 1 | 84 | 39 | 2 | 1 | 1 | 0 | 91 | 52 | 1 |
2 | 1 | 1 | 3 | 3 | 1 | 79 | 34 | 1 | 1 | 1 | 0 | 81 | 56 | 1 |
2 | 1 | 3 | 4 | 2 | 2 | 74 | 61 | 2 | 1 | 2 | 1 | 87 | 68 | 2 |
2 | 1 | 1 | 3 | 3 | 1 | 76 | 42 | 2 | 1 | 1 | 0 | 79 | 51 | 2 |
2 | 1 | 1 | 3 | 3 | 1 | 82 | 46 | 2 | 1 | 1 | 0 | 76 | 58 | 1 |
2 | 1 | 3 | 4 | 2 | 2 | 86 | 72 | 1 | 1 | 2 | 1 | 89 | 78 | 2 |
3 | 1 | 1 | 3 | 3 | 1 | 83 | 59 | 2 | 1 | 0 | 0 | 79 | 49 | 1 |
3 | 1 | 1 | 1 | 1 | 1 | 87 | 51 | 2 | 1 | 0 | 0 | 76 | 44 | 1 |
3 | 1 | 3 | 1 | 1 | 3 | 92 | 89 | 2 | 2 | 2 | 0 | 81 | 93 | 1 |
3 | 1 | 3 | 1 | 1 | 3 | 86 | 86 | 2 | 2 | 0 | 0 | 84 | 87 | 2 |
3 | 1 | 3 | 4 | 2 | 2 | 72 | 61 | 1 | 1 | 0 | 2 | 89 | 77 | 2 |
3 | 1 | 2 | 1 | 1 | 2 | 91 | 83 | 1 | 1 | 0 | 0 | 93 | 89 | 2 |
3 | 2 | 3 | 4 | 2 | 2 | 71 | 71 | 1 | 1 | 1 | 0 | 81 | 86 | 1 |
3 | 2 | 3 | 1 | 1 | 3 | 96 | 94 | 2 | 1 | 0 | 0 | 92 | 97 | 2 |
3 | 2 | 2 | 1 | 1 | 1 | 91 | 73 | 2 | 1 | 0 | 0 | 84 | 63 | 1 |
3 | 2 | 3 | 3 | 3 | 2 | 63 | 63 | 2 | 2 | 1 | 0 | 67 | 42 | 1 |
3 | 2 | 3 | 1 | 1 | 2 | 84 | 74 | 1 | 1 | 0 | 0 | 86 | 79 | 1 |
3 | 2 | 3 | 4 | 2 | 1 | 89 | 68 | 2 | 1 | 1 | 2 | 82 | 54 | 1 |
3 | 2 | 1 | 1 | 1 | 2 | 84 | 76 | 1 | 1 | 0 | 0 | 88 | 80 | 1 |
3 | 2 | 1 | 1 | 1 | 1 | 93 | 69 | 2 | 1 | 0 | 0 | 94 | 76 | 1 |
3 | 2 | 3 | 3 | 3 | 2 | 72 | 84 | 1 | 1 | 2 | 0 | 83 | 83 | 2 |
3 | 2 | 3 | 4 | 2 | 2 | 81 | 86 | 1 | 1 | 0 | 1 | 79 | 77 | 2 |
3 | 2 | 2 | 1 | 1 | 1 | 87 | 62 | 2 | 1 | 0 | 0 | 84 | 56 | 1 |
3 | 2 | 1 | 1 | 1 | 1 | 91 | 69 | 2 | 1 | 0 | 0 | 94 | 77 | 1 |
3 | 2 | 2 | 1 | 2 | 2 | 99 | 94 | 2 | 2 | 0 | 0 | 93 | 96 | 2 |
3 | 2 | 3 | 1 | 2 | 1 | 97 | 76 | 2 | 1 | 0 | 0 | 91 | 83 | 2 |
3 | 3 | 1 | 5 | 2 | 3 | 79 | 86 | 2 | 2 | 0 | 0 | 93 | 98 | 2 |
3 | 3 | 3 | 5 | 2 | 3 | 86 | 82 | 2 | 2 | 0 | 0 | 84 | 89 | 1 |
3 | 3 | 2 | 1 | 1 | 3 | 96 | 98 | 2 | 2 | 0 | 0 | 92 | 92 | 2 |
3 | 3 | 1 | 5 | 2 | 2 | 74 | 72 | 2 | 1 | 0 | 0 | 81 | 48 | 1 |
3 | 4 | 1 | 4 | 2 | 3 | 79 | 83 | 2 | 2 | 2 | 1 | 87 | 84 | 1 |
3 | 4 | 2 | 6 | 2 | 2 | 82 | 76 | 1 | 1 | 0 | 0 | 91 | 80 | 1 |
4 | 2 | 2 | 6 | 2 | 1 | 71 | 67 | 1 | 1 | 0 | 0 | 79 | 58 | 1 |
4 | 2 | 3 | 6 | 2 | 1 | 48 | 46 | 1 | 1 | 0 | 0 | 83 | 79 | 1 |
4 | 2 | 3 | 5 | 2 | 2 | 83 | 79 | 2 | 1 | 0 | 0 | 89 | 84 | 1 |
4 | 2 | 2 | 1 | 1 | 3 | 89 | 93 | 2 | 2 | 0 | 0 | 94 | 92 | 2 |
4 | 2 | 1 | 1 | 1 | 3 | 96 | 98 | 1 | 1 | 0 | 0 | 89 | 93 | 2 |
4 | 2 | 3 | 1 | 1 | 3 | 92 | 95 | 2 | 1 | 0 | 0 | 96 | 96 | 1 |
4 | 1 | 3 | 5 | 2 | 2 | 76 | 75 | 1 | 1 | 0 | 0 | 83 | 70 | 1 |
4 | 1 | 2 | 5 | 2 | 1 | 37 | 37 | 1 | 1 | 0 | 0 | 86 | 79 | 2 |
4 | 1 | 1 | 3 | 3 | 1 | 58 | 39 | 2 | 1 | 1 | 0 | 44 | 40 | 1 |
4 | 1 | 1 | 6 | 2 | 1 | 68 | 49 | 2 | 1 | 0 | 0 | 53 | 78 | 2 |
4 | 1 | 3 | 5 | 2 | 2 | 81 | 77 | 1 | 1 | 0 | 0 | 85 | 76 | 1 |
4 | 1 | 2 | 6 | 2 | 1 | 62 | 44 | 1 | 1 | 0 | 0 | 81 | 69 | 2 |
4 | 1 | 3 | 1 | 1 | 2 | 89 | 82 | 2 | 1 | 0 | 0 | 84 | 80 | 1 |
4 | 1 | 3 | 4 | 2 | 2 | 83 | 74 | 1 | 1 | 0 | 1 | 91 | 81 | 2 |
4 | 1 | 3 | 4 | 2 | 1 | 74 | 59 | 1 | 1 | 1 | 2 | 89 | 78 | 1 |
4 | 1 | 3 | 5 | 2 | 2 | 78 | 69 | 1 | 1 | 0 | 0 | 79 | 73 | 1 |
4 | 1 | 1 | 6 | 2 | 1 | 83 | 69 | 2 | 1 | 0 | 0 | 81 | 69 | 1 |
4 | 4 | 2 | 1 | 1 | 3 | 92 | 99 | 2 | 2 | 0 | 0 | 96 | 92 | 2 |
4 | 3 | 3 | 6 | 2 | 2 | 54 | 41 | 2 | 1 | 0 | 0 | 73 | 59 | 1 |
4 | 4 | 1 | 1 | 1 | 1 | 88 | 63 | 1 | 1 | 0 | 0 | 82 | 60 | 1 |
Sheet2
Variable Definition | Values | |
Race | Client’s race/ethnicity | 1 = African American; 2 = Asian American; 3 = Caucasian; 4 = Hispanic/Latino; 5 = Native American Indian |
Gender | Client’s identified gender | 1 = Male; 2 = Female; 3 = Transgender Male; 4 = Transgender Female |
Orientation | Client’s identified sexual orientation | 1 = Heterosexual; 2 = Bisexual; 3 = Gay Male/ Lesbian Female |
Problem | Client’s primary identified problem | 1 = Family Conflict; 2 = Academic Problem; 3 = Juvenile Justice Involvement; 4 = Sex Trafficking; 5 = Mental Health; 6 = Substance Abuse |
Service | Service Client received for 6 months | 1 = Family Counseling; 2 = Individual Counseling; 3 = Legal Support |
Housing | Type of housing at 6 months | 1 = Stable housing with family; 2 = Stable housing with child welfare services; 3 = Homeless |
Pre-FC | Rated levels of family conflict before intervention | Scores range 50 – 100 (0 = low conflict; 100 = extremely high conflict); 0 = N/A |
Post-FC | Rated levels of family conflict after intervention | Scores range 50 – 100 (0 = low conflict; 100 = extremely high conflict); 0 = N/A |
Pre-Acad | Academic Performance before receiving services | 1 = Passing grades; 2 = Danger of failing grade |
Post-Acad | Academic Performance after receiving services | 1 = Passing grades; 2 = Danger of failing grade |
JJ | Juvenile Justice: In compliance with court orders after 6 months | 0 = N/A; 1 = Yes; 2 =No |
ST | Sex trafficking involvement after receiving services | 0 = N/A; 1 = Yes; 2 =No |
Pre-MH | Mental Health scores before receiving services | Scores range 25 – 100 (25 = no mental health problems; 100 = significant mental health problems); 0 = N/A |
Post-MH | Mental Health scores after receiving services | Scores range 25 – 100 (25 = no mental health problems; 100 = significant mental health problems); 0 = N/A |
SA | Substance abuse; clean drug screen after 6 months | 1 = Yes; 2 = No |