Table view 1:

  • All the information is in a table
  • Table can be made to be sortable (ex: sort by date or county)

History
Date Type Status County Worker People and Roles
10/26/2016 Screening In progress Sacramento John Watts Arthur Smith , Edna Jensen (Reporter) , John Smith , Rachel Beth Smith II
10/5/2016 Referral In progress Sutter Crystal Fox John Smith (Alleged victim - Neglect) , Edna Jensen (Reporter) , Arthur Smith (Alleged perpertrator - Neglect) , Rachel Beth Smith II (Alleged perpertrator - Neglect)
12/10/2015 - 4/8/2016 Case Closed Sutter Katrina Coleman John Smith (Focus Child)
9/13/2015 Referral
(10days - Substantiated)
 Closed Yolo Colleen Newman John Smith (Victim - Neglect) , Herman Peters (Reporter) , Arthur Smith (Perpertrator - Neglect) , Rachel Beth Smith II (Perpertrator - Neglect)

Table view 2:

  • The worker and people column were collapsed, roles are aggregated to reduce the amount of redundant text

History
Date Type Status County People and Roles
10/26/2016 Screening In progress Sacramento Arthur Smith , John Smith , Rachel Beth Smith II , Reporter: Edna Jensen , Worker: John Watts
10/5/2016 Referral In progress Sutter Alleged victim: John Smith (Neglect) , Alleged perpetrator: Arthur Smith (Neglect) , Rachel Beth Smith II (Neglect) , Reporter: Edna Jensen , Worker: Crystal Fox
12/10/2015 - 4/8/2016 Case Closed Sutter Focus Child: John Smith , Worker: Katrina Coleman
9/13/2015 Referral
(10days - Substantiated)
 Closed Yolo Victim: John Smith (Neglect) , Perpetrator: Arthur Smith (Neglect) , Rachel Beth Smith II (Neglect) , Reporter: Herman Peters , Worker: Colleen Newman

Table view 3:

  • Same as above with some bolding to highlight some of the datapoints and improve scannability of

History
Date Type Status County People and Roles
10/26/2016 Screening In progress Sacramento Arthur Smith , John Smith , Rachel Beth Smith II , Reporter: Edna Jensen , Worker: John Watts
10/5/2016 Referral In progress Sutter Alleged victim: John Smith (Neglect) , Alleged perpetrator: Arthur Smith (Neglect) , Rachel Beth Smith II (Neglect)
Reporter: Edna Jensen , Worker: Crystal Fox
12/10/2015 - 4/8/2016 Case Closed Sutter Focus Child: John Smith , Worker: Katrina Coleman
9/13/2015 Referral
(10days - Substantiated)
 Closed Yolo Victim: John Smith (Neglect) , Perpetrator: Arthur Smith (Neglect) , Rachel Beth Smith II (Neglect)
Reporter: Herman Peters , Worker: Colleen Newman

Organized view 1:

  • This view has the information organized differently to maximize visibility and screen space

History
Screening (In progress)
10/26/2016
John Watts
Sacramento County
Arthur Smith , John Smith , Rachel Beth Smith II
Reporter: Edna Jensen
Referral (In progress)
10/5/2016
Crystal Fox
Sutter County
Alleged victim: John Smith (Neglect) , Alleged perpetrator: Arthur Smith (Neglect) , Rachel Beth Smith II (Neglect)
Reporter: Edna Jensen
Case (Closed)
12/10/2015 - 4/8/2016
Katrina Coleman
Sutter County
Focus Child: John Smith
Substantiated Referral (10days - Closed)
10/5/2016
Colleen Newman
Yolo County
Victim: John Smith (Neglect) , Perpetrator: Arthur Smith (Neglect) , Rachel Beth Smith II (Neglect)
Reporter: Herman Peters

Organized view 2:

  • Information is organized a bit differently for better readability

History
Screening (In progress)
10/26/2016
John Watts
Sacramento County
Arthur Smith , John Smith , Rachel Beth Smith II
Reporter: Edna Jensen
Referral (In progress)
10/5/2016
Crystal Fox
Sutter County
Alleged victim: John Smith (Neglect)
Alleged perpetrator: Arthur Smith (Neglect) , Rachel Beth Smith II (Neglect)
Reporter: Edna Jensen
Case (Closed)
12/10/2015 - 4/8/2016
Katrina Coleman
Sutter County
Focus Child: John Smith
Substantiated Referral (10days - Closed)
10/5/2016
Colleen Newman
Yolo County
Victim: John Smith (Neglect)
Perpetrator: Arthur Smith (Neglect) , Rachel Beth Smith II (Neglect)
Reporter: Herman Peters

Organized view 3:

  • Same as above but pre-filtered by in progress/closed

History
IN PROGRESS
Screening
10/26/2016
John Watts
Sacramento County
Arthur Smith , John Smith , Rachel Beth Smith II
Reporter: Edna Jensen
Referral
10/5/2016
Crystal Fox
Sutter County
Alleged victim: John Smith (Neglect)
Alleged perpetrator: Arthur Smith (Neglect) , Rachel Beth Smith II (Neglect)
Reporter: Edna Jensen
CLOSED
Case
12/10/2015 - 4/8/2016
Katrina Coleman
Sutter County
Focus Child: John Smith
Substantiated Referral (10days)
10/5/2016
Colleen Newman
Yolo County
Victim: John Smith (Neglect)
Perpetrator: Arthur Smith (Neglect) , Rachel Beth Smith II (Neglect)
Reporter: Herman Peters

Organized view 4:

  • Same as above but with a line dividers instead of the tabs

History
IN PROGRESS
Screening
10/26/2016
John Watts
Sacramento County
Arthur Smith , John Smith , Rachel Beth Smith II
Reporter: Edna Jensen
Referral
10/5/2016
Crystal Fox
Sutter County
Alleged victim: John Smith (Neglect)
Alleged perpetrator: Arthur Smith (Neglect) , Rachel Beth Smith II (Neglect)
Reporter: Edna Jensen
CLOSED
Case
12/10/2015 - 4/8/2016
Katrina Coleman
Sutter County
Focus Child: John Smith
Substantiated Referral (10days)
10/5/2016
Colleen Newman
Yolo County
Victim: John Smith (Neglect)
Perpetrator: Arthur Smith (Neglect) , Rachel Beth Smith II (Neglect)
Reporter: Herman Peters

Organized view 5:

  • Same as above with collapsable panels

History
IN PROGRESS (2)
Screening
10/26/2016
John Watts
Sacramento County
Arthur Smith , John Smith , Rachel Beth Smith II
Reporter: Edna Jensen
Referral
10/5/2016
Crystal Fox
Sutter County
Alleged victim: John Smith (Neglect)
Alleged perpetrator: Arthur Smith (Neglect) , Rachel Beth Smith II (Neglect)
Reporter: Edna Jensen
CLOSED (2)
Case
12/10/2015 - 4/8/2016
Katrina Coleman
Sutter County
Focus Child: John Smith
Substantiated Referral (10days)
10/5/2016
Colleen Newman
Yolo County
Victim: John Smith (Neglect)
Perpetrator: Arthur Smith (Neglect) , Rachel Beth Smith II (Neglect)
Reporter: Herman Peters