Mecklenburg County Linked Database. Possible Analyses with the Longitudinal Database


  • Changing size of Work First caseload over time.
  • Comparisons of rates of exit and recidivism among various subgroups (e.g. rates of exit and recidivism for whites versus non-whites, men versus women)
  • Comparisons of quarterly earnings among various subgroups (e.g. earnings of TANF recipients who participated in Employment Services versus those who did not)
  • Comparisons of long-term "core" TANF recipients to "successful customers" who leave TANF and do not return.
  • Evaluation of the number of former TANF recipients who are currently working.
  • Evaluation of consistency of employment after leaving TANF (i.e. how many quarters did customers work when they left WF?)
  • Number of present and former TANF recipients who also receive food stamps.
  • Number of TANF recipients who have used all months against the state 24- or federal 60-month time limits.
  • Number of TANF recipients who are likely to use all of their 24-month time limits in the next 6 months.
  • Descriptive profile of child-only cases.
  • Changes in the average duration in Work First after the implementation of 24-month time limits.  (i.e. was the average duration longer before time limits?)
  • Factors explaining variation in duration in Work First.
  • Factors explaining variation in post-TANF employment earnings.
  • Comparison of scheduled hours of employment services activities to completed hours of employment services activities.
  • Analysis of industries that hire TANF recipients and earnings within these industries.
  • Effects of sanctions on duration in Work First.
  • Differences in duration in Work First for two-parent cases versus single-parent cases.
  • Geographic concentrations of Work First customers in the county.