VI-SPDAT v2 Dataset
Data Wrangling Project
The dataset pulls data from the VI-SPDAT (Adult) version 2 and organizes it into a single view, listing overall data about the VI-SPDAT (i.e. caseworker, date and time) along with answers to individual questions stored in columns. It also calculates the number of VI-SPDATs the client has completed, and retrieves the trimorbidity score along with other section scores.
The dataset also includes foreign keys that can easily be linked with other client and service data.
As a bonus, we're throwing in a free sample report that'll work with this dataset. It's designed for you to play with and make your own, so it's not terribly fancy. Make something beautiful with it!
This view contains the following columns, pulling data from all Calls and Visits Logs:
-
IntakeID
-
IntakeDateTime
-
IntakeTypeID
-
IntakeType
-
ServiceID
-
ClientID
-
OrganizationID
-
OrganizationName
-
CaseworkerPersonID
-
CaseworkerUserID
-
CaseworkerName
-
PreScreenPeriod
-
ActualTriage Iteration (this calculates the number of previous VI-SPDATs have been done with this client, calculating PreScreenPeriod automatically)
-
Description
-
Score_Senior
-
Q1_SleepingPlace
-
Q2_MonthsHomeless
-
Q3_TimesHomeless
-
Score_HistoryHomelessness
-
Q4a_ERtimes
-
Q4b_AmbulanceTimes
-
Q4c_HospitalizedTimes
-
Q4d_Crisis
-
Q4e_Police
-
Q4f_Jail
-
Q5_BeenAttacked
-
Q6_InflictHarm
-
Q7_Legal
-
Q8_Coersion
-
Q9_RiskyBehaviour
-
Score_Risks
-
Q10_OweMoney
-
Q11_GetMoney
-
Q12_Meaningful Activities
-
Q13_BasicNeeds
-
Q14_RelationshipBreakdown
-
Score_Socialization
-
Q15_PhysicalHealth
-
Q16_ChronicIllness
-
Q17_PhysicalDisability
-
Q18_AvoidDoctors
-
Q19_Pregnant
-
Q20_SubstanceUseHousingLoss
-
Q21_SubstanceUseAffodability
-
Q22a_MentalHealth
-
Q22b_HeadInjury
-
Q22c_Development Disability
-
Q23_Independent
-
Score_Trimorbidity
-
Q24_MedicationNotTaking
-
Q25_MedicationSellAbuse
-
Q26_AbuseTrauma
-
Score_Wellness
-
TotalScore
-
Result