Intensity of Care Packages - Amazon Simple Storage Service (S3)
ARG 04/02(A) Intensity of Care Packages – Analysis of sample data Introduction 1. At the last Adults Review Group meeting it was agreed that further work was needed to investigate what information should be collected to measure intensity of care packages before we can move to client based records. 2. It was agreed that one of the strands of work in the medium term should be the analysis of sample data from LAs on clients’ care packages, including different services and the intensity of those services. 3. Reading and Warrington have provided sample data covering a snapshot period of 1 week with the aim of comparing the intensity of clients’ care packages received in a typical week. This note sets out the initial analysis of intensive packages of care services received by Social Services clients in Reading and Warrington. Analysis of Intensive Packages of Care: Reading data 4. Reading provided snapshot data as at 31 January 2004. The dataset consisted of a total of 1,176 Social Services clients over the age of 65 who received a service at 31 January 2004. These services included home care, day care, meals on wheels, respite days per year, professional support, equipment and direct payments. 5. Figures 1a-1d demonstrate the number of clients receiving a key service namely home care, day care, meals on wheels and respite care per year. 6. Further analysis identified those clients who received a combination of at least two key services (figures 2a-2d). 7. One aim of the analysis was to try to capture the complexity of care packages. Information on clients who receive a combination of the three key services has been collated in tables 1a and 1b. 8. Below is a summary of the combinations of key services received by clients (home care, day care, meals on wheels): ¾ ¾ ¾ ¾ ¾ ¾ ¾ ¾
16% of the total clients did not receive one of the three key services 1.2% of the total clients received all 3 key services 55% of the total clients only received home care 6.9% of the total clients only received day care 5.6% of the total clients only received meals on wheels 6.1% of the total clients received home care and day care only 9.2% of the total clients received home care and meals only less than 5 clients (which is less than 0.4%) received day care and meals only
9. Of the people who received 5-10 hours of home care, only one third received another service.
10. Of the 184 (16%) clients who did not receive home care, day care or meals on wheels the majority of clients received only a single service. 4.3% received respite care, 1.6% received direct payments, 4.3% received equipment or adaptations and 90% of clients were recorded as having a miscellaneous service. Only one client received more than one service, this package consisted of a combination of respite care and equipment or adaptations. Analysis of Intensive Packages of Care: Warrington data 11. The Warrington dataset consisted of a total of 1,215 Social Services clients over the age of 65 who received a service between 1st December 2003 to 7th December 2003. These services included home care, day care, meals on wheels, respite days and some services were classed as miscellaneous or other non residential care services. 12. Figures 3a-3d demonstrate the number of clients receiving home care, day care, meals on wheels or respite care. 13. Further analysis identified those clients who received a combination of at least two key services (figures 4a-4d). 14. Similar to the analysis carried out on the Reading data, information on clients in Warrington who receive at least three key services has been collated in tables 2a and 2b. 15. Below is a summary of the combinations of key services received by clients (home care, day care, meals on wheels): ¾ ¾ ¾ ¾ ¾ ¾ ¾ ¾
12% of the total clients did not receive one of the three key services 1.2% of the total clients received all 3 key services 60% of the total clients only received home care 4.3% of the total clients only received day care 9.1% of the total clients only received meals on wheels 5.3% of the total clients received home care and day care only 7.4% of the total clients received home care and meals only less than 5 clients (which is less than 0.4% ) received day care and meals only
16. Of the people who received 5-10 hours of home care, only 22% received another service (i.e. day care or meals on wheels). 17. The 151 (12%) clients who did not receive home care, day care or meals on wheels received only a single service. 36% received respite care, 64% received other non-residential services. Summary 18. The analysis shows similar proportions of clients in Reading and Warrington receive the same combinations of care packages.
19. Overall, few clients receive a combination of more than one service in both Reading and Warrington (17% and 14% respectively). The majority of social services clients, in both LAs, receive only home care as a service. 20. This analysis has highlighted the difficulties involved in obtaining, and preparing sample data in a format that can be used to populate tables 1 and 2. Many LAs were not able to produce this data easily. Also it was necessary to remove some anomalies from both the data sets that were provided. 21. Discrepancies occurred between LAs in terms of the units used to record some services. For example, respite care in Reading was recorded as days per year as at the snapshot period of 31 January 2004. Whereas respite care for Warrington was recorded as respite days per 1 week snapshot period. This variation in the units used to record activity makes it difficult to produce comparable results for different LAs. 22. Also, the number of meals on wheels recorded in Warrington may not be easy to interpret based on a 1 week snapshot period. This is because clients are consulted on how best they would like to receive their meals and some prefer once a day, others once a week, some once every two weeks. Therefore it is possible that in any given week there will be some clients who receive more meals than there are days in a week.
23. Reading Data Table 1a: Total number of clients in receipt of key community based services in Reading as at 31 January 2004 Day care visits Meals (number) (days) 0 0 1 2 more than 2 1-3 0 1 2 more than 2 4-5 0 1 2 more than 2 6 or more 0 1 2 more than 2 Total
Home care (hours) 0 184 52 15 15 13 0 * 0 51 * 0 0 * 0 0 0 334
0-5 421 27 11 * 12 * * 0 43 * 0 0 0 0 0 0 523
5-10 152 13 10 * * * * 0 33 * 0 0 * 0 0 0 219
10+ 75 * * 0 * * 0 0 16 0 0 0 0 0 0 0 100
Total 832 96 38 20 28 6 * 0 143 7 0 0 * 0 0 0 1176
Table 1b: Percentage of clients in receipt of key community based services in Reading as at 31 January 2004 Meals Day care (number) visits (days) 0 0 1 2 more than 2 1-3 0 1 2 more than 2 4-5 0 1 2 more than 2 6 or more 0 1 2 more than 2 Total
Home care (hours) 0 15.6% 4.4% 1.3% 1.3% 1.1% 0.0% * 0.0% 4.3% * 0.0% 0.0% * 0.0% 0.0% 0.0% 28.4%
0-5 35.8% 2.3% 0.9% * 1.0% * * 0.0% 3.7% * 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 44.5%
5-10 12.9% 1.1% 0.9% * * * * 0.0% 2.8% * 0.0% 0.0% * 0.0% 0.0% 0.0% 18.6%
*Low numbers have been suppressed to maintain confidentiality.
10+ 6.4% * * 0.0% * * 0.0% 0.0% 1.4% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 8.5%
Total 70.7% 8.2% 3.2% 1.7% 2.4% 0.5% * 0.0% 12.2% 0.6% 0.0% 0.0% * 0.0% 0.0% 0.0% 100.0%
Warrington Data Table 2a: Total number of clients in receipt of key community based services in Warrington between 01/12/03 and 07/12/03 Day Care (visits)
Meals (number) 0
1-3
4-5
6 or more
0 1 2 more than 2 0 1 2 more than 2 0 1 2 more than 2 0 1 2 more than 2
Total
0 151 28 15 9 * 0 0 0 15 0 0 0 91 0 * * 315
Home Care (hours) 0-5 5-10 343 233 12 14 5 11 6 * * 0 0 0 0 0 0 0 * * 0 0 0 * 0 0 32 30 * * * * 0 0 407 300
10+ 155 6 7 0 0 0 0 0 * 0 0 0 21 * 0 0 193
Total 882 60 38 18 6 0 0 0 20 0 * 0 174 12 * * 1215
Table 2b: Percentage of clients in receipt of key community based services in Warrington between 01/12/03 and 07/12/03 Meals (number)
Day Care (visits) 0
1-3
4-5
6 or more
Total
0 1 2 more than 2 0 1 2 more than 2 0 1 2 more than 2 0 1 2 more than 2
0 12.4% 2.3% 1.2% 0.7% * 0.0% 0.0% 0.0% 1.2% 0.0% 0.0% 0.0% 7.5% 0.0% * * 25.9%
Home Care (hours) 0-5 5-10 28.2% 19.2% 1.0% 1.2% 0.4% 0.9% 0.5% * * 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% * * 0.0% 0.0% 0.0% * 0.0% 0.0% 2.6% 2.5% * * * * 0.0% 0.0% 33.5% 24.7%
*Low numbers have been suppressed to maintain confidentiality.
10+ 12.8% 0.5% 0.6% 0.0% 0.0% 0.0% 0.0% 0.0% * 0.0% 0.0% 0.0% 1.7% * 0.0% 0.0% 15.9%
Total 72.6% 4.9% 3.1% 1.5% 0.5% 0.0% 0.0% 0.0% 1.6% 0.0% * 0.0% 14.3% 1.0% * * 100.0%
Reading Intensive Packages of Care Charts show number of Social Serivces clients aged 65 or over receiving a level of service.
Figure 1a: Clients who receive home care
Figure 1b: Clients who receive day care 10
70
9 8 7
50 no. of days
Home care (hours)
60
40 30
6 5 4 3
20
2 10
1
0
0 Client ID
Figure 1a: a total of 334 (28%) clients do not receive home care as a service (not shown on graph).
Client ID
Figure 1b: a total of 1006 (85%) clients do not receive day care as a service (not shown on graph).
Figure 1c: Clients who receive meals on wheels
Figure 1d: Clients who receive respite days 40 no. of respite days per year (recorded at snapshot period)
7 6
no. of meals
5 4 3 2 1
30 25 20 15 10 5 0
0 Client ID
Figure 1c: a total of 986 (84%) clients do not receive meals as a service (not shown on graph).
Source: Reading snapshot data as at 31 January 2004
35
Client ID
Figure 1d: a total of 1135 (97%) clients do not respite care as a service (not shown on graph).
Reading Intensive Packages of Care Charts show Social Services clients who receive a combination of services either home care, day care, meals on wheels or respite care.
Figure 2a: Clients who receive home care and meals on wheels
Figure 2b: Clients who receive day care and meals on wheels 12
60.00
10
50.00
no. of day care days
no. of hours of home care per week
70.00
40.00 30.00 20.00
8 6 4 2
10.00 0.00
0 0
1
2
3
4
5
6
7
0
1
2
no. of meals per week
Figure 2c: Clients who receive home care and day care
4
5
6
7
Figure 2d: Clients who receive home care and respite days
200.00
180.00
180.00
160.00
no. of hours of home care per week
no. of hours of home care per week
3
no. of meals per week
160.00 140.00 120.00 100.00 80.00 60.00 40.00 20.00 0.00
140.00 120.00 100.00 80.00 60.00 40.00 20.00 0.00
0
1
2
3
4
no. of day care days per week
Source: Reading snapshot data as at 31 January 2004
5
6
7
0
5
10
15
20
25
30
no. of respite days per year (recorded at snapshot period)
35
40
Warrington Intensive Packages of Care Charts show number of Social Services clients aged 65 or over receiving a level of service.
Figure 3a: Clients who receive home care
Figure 3b: Clients who receive day care
50
5
45 4
35 no. of days
Home Care (hours)
40
30 25 20
3
2
15 10
1
5 0
0 Client ID
Figure 3a: a total of 315 (26%) clients do not receive home care as a service (not shown on graph)
Client ID
Figure 3b: a total of 1082 (89%) clients do not receive day care as a service (not shown on graph).
Figure 3d: Clients who receive respite days
30
7
25
6
no. of respite days per week
no. of meals
Figure 3c: Clients who receive meals on wheels
20 15 10 5 0
5 4 3 2 1 0
Client ID
Figure 3c: a total of 998 (82%) clients do not receive meals as a service (not shown on graph)
Source: Warrington snapshot data 1 week from 01/12/03 to 07/12/03
Client ID
Figure 3d: a total of 1129 (93%) of clients do not receive respite care as a service (not shown on graphs).
Warrington Intensive Packages of Care Charts show Social Services clients who receive a combination of services either home care, day carem meals on wheels or respite care.
Figure 4a: Clients who receive home care and meals on wheels
Figure 4b: Clients who receive day care and meals on wheels 5
45 40
4 no. of day care days
no. of hours of home care per week
50
35 30 25 20 15 10
3
2
1
5 0
0 0
5
10
15
20
25
30
0
5
10
no. of meals per week
Figure 4c: Clients who receive home care and day care
20
25
30
Figure 4d: Clients who receive home care and respite days
50
50
45
45
no. of hours of home care per week
no. of hours of home care per week
15 no. of meals per week
40 35 30 25 20 15 10 5 0
40 35 30 25 20 15 10 5 0
0
1
2
3
no. of day care days per week
Source: Warrington snapshot data 1 week from 01/12/03 to 07/12/03
4
5
0
1
2
3
4
no. of respite days per week
5
6
7
16% of the total clients did not receive one of the three key services 1.2% of the total clients received all 3 key services 55% of the total clients only received home care 6.9% of the total clients only received day care 5.6% of the total clients only received meals on wheels 6.1% of the total clients received home care and day care only 9.2% of the total clients received home care and meals only less than 5 clients (which is less than 0.4%) received day care and meals only
9. Of the people who received 5-10 hours of home care, only one third received another service.
10. Of the 184 (16%) clients who did not receive home care, day care or meals on wheels the majority of clients received only a single service. 4.3% received respite care, 1.6% received direct payments, 4.3% received equipment or adaptations and 90% of clients were recorded as having a miscellaneous service. Only one client received more than one service, this package consisted of a combination of respite care and equipment or adaptations. Analysis of Intensive Packages of Care: Warrington data 11. The Warrington dataset consisted of a total of 1,215 Social Services clients over the age of 65 who received a service between 1st December 2003 to 7th December 2003. These services included home care, day care, meals on wheels, respite days and some services were classed as miscellaneous or other non residential care services. 12. Figures 3a-3d demonstrate the number of clients receiving home care, day care, meals on wheels or respite care. 13. Further analysis identified those clients who received a combination of at least two key services (figures 4a-4d). 14. Similar to the analysis carried out on the Reading data, information on clients in Warrington who receive at least three key services has been collated in tables 2a and 2b. 15. Below is a summary of the combinations of key services received by clients (home care, day care, meals on wheels): ¾ ¾ ¾ ¾ ¾ ¾ ¾ ¾
12% of the total clients did not receive one of the three key services 1.2% of the total clients received all 3 key services 60% of the total clients only received home care 4.3% of the total clients only received day care 9.1% of the total clients only received meals on wheels 5.3% of the total clients received home care and day care only 7.4% of the total clients received home care and meals only less than 5 clients (which is less than 0.4% ) received day care and meals only
16. Of the people who received 5-10 hours of home care, only 22% received another service (i.e. day care or meals on wheels). 17. The 151 (12%) clients who did not receive home care, day care or meals on wheels received only a single service. 36% received respite care, 64% received other non-residential services. Summary 18. The analysis shows similar proportions of clients in Reading and Warrington receive the same combinations of care packages.
19. Overall, few clients receive a combination of more than one service in both Reading and Warrington (17% and 14% respectively). The majority of social services clients, in both LAs, receive only home care as a service. 20. This analysis has highlighted the difficulties involved in obtaining, and preparing sample data in a format that can be used to populate tables 1 and 2. Many LAs were not able to produce this data easily. Also it was necessary to remove some anomalies from both the data sets that were provided. 21. Discrepancies occurred between LAs in terms of the units used to record some services. For example, respite care in Reading was recorded as days per year as at the snapshot period of 31 January 2004. Whereas respite care for Warrington was recorded as respite days per 1 week snapshot period. This variation in the units used to record activity makes it difficult to produce comparable results for different LAs. 22. Also, the number of meals on wheels recorded in Warrington may not be easy to interpret based on a 1 week snapshot period. This is because clients are consulted on how best they would like to receive their meals and some prefer once a day, others once a week, some once every two weeks. Therefore it is possible that in any given week there will be some clients who receive more meals than there are days in a week.
23. Reading Data Table 1a: Total number of clients in receipt of key community based services in Reading as at 31 January 2004 Day care visits Meals (number) (days) 0 0 1 2 more than 2 1-3 0 1 2 more than 2 4-5 0 1 2 more than 2 6 or more 0 1 2 more than 2 Total
Home care (hours) 0 184 52 15 15 13 0 * 0 51 * 0 0 * 0 0 0 334
0-5 421 27 11 * 12 * * 0 43 * 0 0 0 0 0 0 523
5-10 152 13 10 * * * * 0 33 * 0 0 * 0 0 0 219
10+ 75 * * 0 * * 0 0 16 0 0 0 0 0 0 0 100
Total 832 96 38 20 28 6 * 0 143 7 0 0 * 0 0 0 1176
Table 1b: Percentage of clients in receipt of key community based services in Reading as at 31 January 2004 Meals Day care (number) visits (days) 0 0 1 2 more than 2 1-3 0 1 2 more than 2 4-5 0 1 2 more than 2 6 or more 0 1 2 more than 2 Total
Home care (hours) 0 15.6% 4.4% 1.3% 1.3% 1.1% 0.0% * 0.0% 4.3% * 0.0% 0.0% * 0.0% 0.0% 0.0% 28.4%
0-5 35.8% 2.3% 0.9% * 1.0% * * 0.0% 3.7% * 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 44.5%
5-10 12.9% 1.1% 0.9% * * * * 0.0% 2.8% * 0.0% 0.0% * 0.0% 0.0% 0.0% 18.6%
*Low numbers have been suppressed to maintain confidentiality.
10+ 6.4% * * 0.0% * * 0.0% 0.0% 1.4% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 8.5%
Total 70.7% 8.2% 3.2% 1.7% 2.4% 0.5% * 0.0% 12.2% 0.6% 0.0% 0.0% * 0.0% 0.0% 0.0% 100.0%
Warrington Data Table 2a: Total number of clients in receipt of key community based services in Warrington between 01/12/03 and 07/12/03 Day Care (visits)
Meals (number) 0
1-3
4-5
6 or more
0 1 2 more than 2 0 1 2 more than 2 0 1 2 more than 2 0 1 2 more than 2
Total
0 151 28 15 9 * 0 0 0 15 0 0 0 91 0 * * 315
Home Care (hours) 0-5 5-10 343 233 12 14 5 11 6 * * 0 0 0 0 0 0 0 * * 0 0 0 * 0 0 32 30 * * * * 0 0 407 300
10+ 155 6 7 0 0 0 0 0 * 0 0 0 21 * 0 0 193
Total 882 60 38 18 6 0 0 0 20 0 * 0 174 12 * * 1215
Table 2b: Percentage of clients in receipt of key community based services in Warrington between 01/12/03 and 07/12/03 Meals (number)
Day Care (visits) 0
1-3
4-5
6 or more
Total
0 1 2 more than 2 0 1 2 more than 2 0 1 2 more than 2 0 1 2 more than 2
0 12.4% 2.3% 1.2% 0.7% * 0.0% 0.0% 0.0% 1.2% 0.0% 0.0% 0.0% 7.5% 0.0% * * 25.9%
Home Care (hours) 0-5 5-10 28.2% 19.2% 1.0% 1.2% 0.4% 0.9% 0.5% * * 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% * * 0.0% 0.0% 0.0% * 0.0% 0.0% 2.6% 2.5% * * * * 0.0% 0.0% 33.5% 24.7%
*Low numbers have been suppressed to maintain confidentiality.
10+ 12.8% 0.5% 0.6% 0.0% 0.0% 0.0% 0.0% 0.0% * 0.0% 0.0% 0.0% 1.7% * 0.0% 0.0% 15.9%
Total 72.6% 4.9% 3.1% 1.5% 0.5% 0.0% 0.0% 0.0% 1.6% 0.0% * 0.0% 14.3% 1.0% * * 100.0%
Reading Intensive Packages of Care Charts show number of Social Serivces clients aged 65 or over receiving a level of service.
Figure 1a: Clients who receive home care
Figure 1b: Clients who receive day care 10
70
9 8 7
50 no. of days
Home care (hours)
60
40 30
6 5 4 3
20
2 10
1
0
0 Client ID
Figure 1a: a total of 334 (28%) clients do not receive home care as a service (not shown on graph).
Client ID
Figure 1b: a total of 1006 (85%) clients do not receive day care as a service (not shown on graph).
Figure 1c: Clients who receive meals on wheels
Figure 1d: Clients who receive respite days 40 no. of respite days per year (recorded at snapshot period)
7 6
no. of meals
5 4 3 2 1
30 25 20 15 10 5 0
0 Client ID
Figure 1c: a total of 986 (84%) clients do not receive meals as a service (not shown on graph).
Source: Reading snapshot data as at 31 January 2004
35
Client ID
Figure 1d: a total of 1135 (97%) clients do not respite care as a service (not shown on graph).
Reading Intensive Packages of Care Charts show Social Services clients who receive a combination of services either home care, day care, meals on wheels or respite care.
Figure 2a: Clients who receive home care and meals on wheels
Figure 2b: Clients who receive day care and meals on wheels 12
60.00
10
50.00
no. of day care days
no. of hours of home care per week
70.00
40.00 30.00 20.00
8 6 4 2
10.00 0.00
0 0
1
2
3
4
5
6
7
0
1
2
no. of meals per week
Figure 2c: Clients who receive home care and day care
4
5
6
7
Figure 2d: Clients who receive home care and respite days
200.00
180.00
180.00
160.00
no. of hours of home care per week
no. of hours of home care per week
3
no. of meals per week
160.00 140.00 120.00 100.00 80.00 60.00 40.00 20.00 0.00
140.00 120.00 100.00 80.00 60.00 40.00 20.00 0.00
0
1
2
3
4
no. of day care days per week
Source: Reading snapshot data as at 31 January 2004
5
6
7
0
5
10
15
20
25
30
no. of respite days per year (recorded at snapshot period)
35
40
Warrington Intensive Packages of Care Charts show number of Social Services clients aged 65 or over receiving a level of service.
Figure 3a: Clients who receive home care
Figure 3b: Clients who receive day care
50
5
45 4
35 no. of days
Home Care (hours)
40
30 25 20
3
2
15 10
1
5 0
0 Client ID
Figure 3a: a total of 315 (26%) clients do not receive home care as a service (not shown on graph)
Client ID
Figure 3b: a total of 1082 (89%) clients do not receive day care as a service (not shown on graph).
Figure 3d: Clients who receive respite days
30
7
25
6
no. of respite days per week
no. of meals
Figure 3c: Clients who receive meals on wheels
20 15 10 5 0
5 4 3 2 1 0
Client ID
Figure 3c: a total of 998 (82%) clients do not receive meals as a service (not shown on graph)
Source: Warrington snapshot data 1 week from 01/12/03 to 07/12/03
Client ID
Figure 3d: a total of 1129 (93%) of clients do not receive respite care as a service (not shown on graphs).
Warrington Intensive Packages of Care Charts show Social Services clients who receive a combination of services either home care, day carem meals on wheels or respite care.
Figure 4a: Clients who receive home care and meals on wheels
Figure 4b: Clients who receive day care and meals on wheels 5
45 40
4 no. of day care days
no. of hours of home care per week
50
35 30 25 20 15 10
3
2
1
5 0
0 0
5
10
15
20
25
30
0
5
10
no. of meals per week
Figure 4c: Clients who receive home care and day care
20
25
30
Figure 4d: Clients who receive home care and respite days
50
50
45
45
no. of hours of home care per week
no. of hours of home care per week
15 no. of meals per week
40 35 30 25 20 15 10 5 0
40 35 30 25 20 15 10 5 0
0
1
2
3
no. of day care days per week
Source: Warrington snapshot data 1 week from 01/12/03 to 07/12/03
4
5
0
1
2
3
4
no. of respite days per week
5
6
7
