Specialized reporting: State Grants

The reports below are used for reporting on our Access to Justice(A2J) grants. Intake by population/legal issue

Referrals by population/legal issue

Each report can be exported to CSV for advanced manipulation and can be filtered by date.

Warning

Reports expect dates to be formatted as yyyy-mm-dd hh:mm:ss. When a date like 3/1/2021 or 2021-03-01 is provided, it assumes a time of 00:00:00. When used as an end date, that means that no results for that day will be included (a date of 3/31/2021 will be interpreted as 3/31/2021 00:00:00; you’d want to use 4/01/2021 to include all of 3/31/2021)

Note

These reports do be further refined using the CSV export to filter on county, zip code, and/or organizations.

Referral reports

There are two referral reports per area: one based on special populations and one based on defined legal issues.

The referral report returns:

  • Triage ID, this is the unique ID associated with the user’s single interaction with Get Legal Help. We make multiple referrals per triage ID so there are multiple rows.

  • Referral ID. This is the unique ID associated with the specific referral made.

  • Created, date the referral was made

  • Triage status. This is almost always Referrals or Program Triage Completed.

  • Intake status. This is either empty (Triage status of Referrals) or Diverted (Intake status of Program triage completed)

  • Service

  • Organization

  • County

  • Zip code

  • Comma-delimited list of any special populations the user selected

  • Initial legal problem is USUALLY the starting point for the user in the taxonomy tree

  • Search term here is any text they may have provided; if they picked from the taxonomy on the main Get Legal Help page, this as the initial taxonomy term will match.

  • Problem history is their full drill down; this will be blank if the user jumped immediately to triage/referrals without drilling down.

  • Household size from the main Get Legal Help page

A referral is included in the population report when:

  • Intake status is not etransferred

  • Has a special population match based on:

    • Is an immigrant or is undocumented (immigration)

    • Is in jail or prison OR has a family member in jail or prison (incarceration)

  • Matches the date range, if provided, for population filter

  • Service language is English (this is required to prevent duplicate records when the organization has been translated)

Note

Because a user can match both on special population and on legal issue, the two reports should be combined in Excel and de-duplicated. Each user has a unique triage ID and each referral has a unique ID. To get unique users, de-duplicate on triage ID. To get unique referrals, de-duplicate on referral ID

Intake Reports

The report returns:

  • Triage ID, this is the unique ID associated with the user’s single interaction with Get Legal Help.

  • Created, date the intake was made

  • Service

  • Organization

  • County

  • Zip code

  • Comma-delimited list of any special populations the user selected

  • Initial legal problem is USUALLY the starting point for the user in the taxonomy tree

  • Search term here is any text they may have provided; if they picked from the taxonomy on the main Get Legal Help page, this as the initial taxonomy term will match.

  • Problem history is their full drill down; this will be blank if the user jumped immediately to triage/referrals without drilling down.

  • Ethnicity

  • Race

  • Gender

  • Primary language

  • Household size from the main Get Legal Help page

  • Adults

  • Children

A intake is included in the population report when:

  • Intake status is etransferred

  • Has a special population match based on:

    • Is an immigrant or is undocumented (immigration)

    • Is in jail or prison OR has a family member in jail or prison (incarceration)

  • Matches the date range, if provided, for population filter

  • Service language is English (this is required to prevent duplicate records when the organization has been translated)

Note

Because a user can match both on special population and on legal issue, the two reports should be combined in Excel and de-duplicated. Each user has a unique triage ID To get unique users, de-duplicate on triage ID.