Failure to Comply Rate?
Locked
 
|
I am working with a large dataset that contains individual charges for jail
bookings over the last six years. I would appreciate some help with syntax to identify jail pre-trial releases and whether their next admission is because they âfailed to appearâ for court. As way of background, while some offenders are held at the jail until their trial and others are released from jail on various forms of release prior to their trial: 1) own recognizance, bond, and something we call supervised release (VAR Release Reason). What I am trying to determine is the âfailure to appearâ rate for those offenders released for the above noted reasons. I should also note that in some cases offenders may be admitted into the jail on new charges, and that this type of admission is not necessarily a âfailure to appearâ admission. However, in some cases, individuals may be admitted as a result of new charges along with a failure to appear offense. Also, in some cases, individuals may be admitted into the county jail for failure to appear; however, the failure to appear resulted from a court hearing (called an arraignment) rather than after being released from the jail. So, you can understand while I am not sure how to proceed. My variables include: Inmateid (unique identification for inmates that follow them over time) (numeric) Admission id (unique identification for admissions with the same date and time) (numeric) BookingDateTime (Adatetime22) ReleaseDateTime (Adatetime22) ChargeCode (this includes the âfailure to appearâ charge) (numeric) ReleaseReason (this includes the code for the types of release reasons I noted above) (numeric) The unit of analysis for the dataset is charge based, so that a unique inmateid and/or admissionid may contain one or multiple records. Any suggested syntax you can offer would be greatly appreciated. If you have any questions, please feel free to contact me directly. Cheers, Damir ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
Damir
This looks like a really interesting problem, but
we need to know more.
How many cases and how many variables? Is the
data really hierarchical? Is it already in *.sav format or just in raw
data? If you have it in *.sav form, can you send me a screenshot of the
data editor in variable view?
|
Automatic reply: Failure to Comply Rate?
|
|
Hello,
Thank you for your email. I will be out of the office beginning Monday, September 20th, returning on Wednesday, September 22nd and will respond to my message when i return. Thanks! Genevieve Odoom Policy and Program Analyst OANHSS Suite 700 - 7050 Weston Rd. Woodbridge, ON L4L 8G7 Tel: (905) 851-8821 x 241 Fax: (905) 851-0744 [hidden email] www.oanhss.org<https://mail.oanhss.org/ecp/Organize/www.oanhss.org> ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
|
In reply to this post by DKUKEC
Damir,
Please post either real or example data to illustrate the computations. The data should illustrate the basic computations as well as the complexity in the dataset. Every example case should include the result variable or variables. If you have begun to write code for the computation, post that as well. The data set structure sounds simple but the computation sounds quite complex--maybe. An additional difficulty may be that the terminology and the underlying generating is unfamiliar as I suspect that thhis data comes from some sort of court/jail transaction database. Your task may not be very hard but the dataset may make it so. Gene Maguin -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Damir Sent: Friday, September 17, 2010 2:17 PM To: [hidden email] Subject: Failure to Comply Rate? I am working with a large dataset that contains individual charges for jail bookings over the last six years. I would appreciate some help with syntax to identify jail pre-trial releases and whether their next admission is because they “failed to appear†for court. As way of background, while some offenders are held at the jail until their trial and others are released from jail on various forms of release prior to their trial: 1) own recognizance, bond, and something we call supervised release (VAR Release Reason). What I am trying to determine is the “failure to appear†rate for those offenders released for the above noted reasons. I should also note that in some cases offenders may be admitted into the jail on new charges, and that this type of admission is not necessarily a “failure to appear†admission. However, in some cases, individuals may be admitted as a result of new charges along with a failure to appear offense. Also, in some cases, individuals may be admitted into the county jail for failure to appear; however, the failure to appear resulted from a court hearing (called an arraignment) rather than after being released from the jail. So, you can understand while I am not sure how to proceed. My variables include: Inmateid (unique identification for inmates that follow them over time) (numeric) Admission id (unique identification for admissions with the same date and time) (numeric) BookingDateTime (Adatetime22) ReleaseDateTime (Adatetime22) ChargeCode (this includes the “failure to appear†charge) (numeric) ReleaseReason (this includes the code for the types of release reasons I noted above) (numeric) The unit of analysis for the dataset is charge based, so that a unique inmateid and/or admissionid may contain one or multiple records. Any suggested syntax you can offer would be greatly appreciated. If you have any questions, please feel free to contact me directly. Cheers, Damir ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
In reply to this post by DKUKEC
At 02:17 PM 9/17/2010, Damir wrote:
>I have a large dataset that contains individual charges for jail >bookings. I need to identify jail pre-trial releases and whether >their next admission is because they "failed to appear" for court. > >Some offenders are held at the jail until their trial and others are >released from jail on various forms of release prior to their trial: >1) own recognizance, bond, and something we call supervised >release (VAR Release Reason). What I am trying to determine is >the "failure to appear" rate for those offenders released for the >above noted reasons. > >In some cases offenders may be admitted into the jail on new >charges, and that this type of admission is not necessarily a >"failure to appear" admission. However individuals may also be >admitted as a result of new charges along with a failure to appear >offense. Also, in some cases, individuals may be admitted into the >county jail for failure to appear; however, the failure to appear >resulted from a court hearing (called an arraignment) rather than >after being released from the jail. > >My variables include: > >Inmateid (unique identification for inmates that follow them over >time) (numeric) >Admission id (unique identification for admissions with the same >date and time) (numeric) >BookingDateTime (Adatetime22) >ReleaseDateTime (Adatetime22) >ChargeCode (this includes the "failure to appear" charge) (numeric) >ReleaseReason (this includes the code for the types of release >reasons I noted above) (numeric) > >The unit of analysis for the dataset is charge based, so that a >unique inmateid and/or admissionid may contain one or multiple records. So you want to tabulate admissions that include a "failure to appear" (possibly with other charges) by the release codes from the previous admission. I'm not going to try code yet, but it wouldn't be hard to summarize to a single record per admission, with Inmateid BookingDateTime ReleaseDateTime ReleaseReason and whether the admission includes a "failure to appear" charge It would be nice to have a "LEAD" function (analogous to "LAG") to attach to each admission, whether the *following* admission includes a "failure to appear" charge, but it'll probably take a little juggling. Maybe it can be done with LEAD in CREATE -- anybody help with that? Then, you need to identify the releases that are NOT followed by a "failure to appear". I don't know how you do that. I suppose, if at the inmate's next admission there's no "failure to appear", then that settles it. What if there's no subsequent admission? Anyhow, there are some moderately tricky data-manipulation issues here; but the conceptual issue, how you determine whether an inmate failed to appear after a release, needs to be resolved first. ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
|
In reply to this post by DKUKEC
Damir,
I think that a key issue for me with respect to your question is no subject-level knowledge. To offer help at the code level, I think you have to educate me about subject. Somewhere along the line you struggled and struggled to understand the data dump and now you do. I (maybe we) don't and I need to offer help. So let's begin. Your question has two parts: a) ' ... to identify jail pre-trial releases ...' and b) 'whether their next admission is because they failed to appear for court.' In the example dataset you sent does kukec have or obtain or was given a jail pre-trial release? How do you know? Very, very specifically, what variables are you reading and what are the values that you are needing to see to know that? Since kukec has a number of booking-charge records, when did he obtain the pre-trial release? Why was it on that booking-charge and not on another? Point b) (next admission because of failure to appear [FTA, right?]). Did kukec have an instance where his next admission (booking record, right??) was because of a FTA? When was it, which booking-charge date? Kukec has a number of FTAs, as noted in the casetype and chargedescription variables. Why was it the booking-charge that you cited and not one of the other booking-charge records? Gene Maguin -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Damir Sent: Friday, September 17, 2010 2:17 PM To: [hidden email] Subject: Failure to Comply Rate? I am working with a large dataset that contains individual charges for jail bookings over the last six years. I would appreciate some help with syntax to identify jail pre-trial releases and whether their next admission is because they “failed to appear†for court. As way of background, while some offenders are held at the jail until their trial and others are released from jail on various forms of release prior to their trial: 1) own recognizance, bond, and something we call supervised release (VAR Release Reason). What I am trying to determine is the “failure to appear†rate for those offenders released for the above noted reasons. I should also note that in some cases offenders may be admitted into the jail on new charges, and that this type of admission is not necessarily a “failure to appear†admission. However, in some cases, individuals may be admitted as a result of new charges along with a failure to appear offense. Also, in some cases, individuals may be admitted into the county jail for failure to appear; however, the failure to appear resulted from a court hearing (called an arraignment) rather than after being released from the jail. So, you can understand while I am not sure how to proceed. My variables include: Inmateid (unique identification for inmates that follow them over time) (numeric) Admission id (unique identification for admissions with the same date and time) (numeric) BookingDateTime (Adatetime22) ReleaseDateTime (Adatetime22) ChargeCode (this includes the “failure to appear†charge) (numeric) ReleaseReason (this includes the code for the types of release reasons I noted above) (numeric) The unit of analysis for the dataset is charge based, so that a unique inmateid and/or admissionid may contain one or multiple records. Any suggested syntax you can offer would be greatly appreciated. If you have any questions, please feel free to contact me directly. Cheers, Damir ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |