Community Services Data Set (CSDS)

Community Services Data Set (CSDS)#

1. Summary#

The CSDS dataset in the UK LLC TRE comprises nine separate datasets.

Dataset descriptor Dataset-specific information
Name of dataset in TRE CSDS
Other name None
Temporal coverage 01/04/2015 onwards
TRE temporal coverage 01/04/2015 onwards
Short description Dataset about children, young people and adults who are in contact with NHS funded organisations that provide community services in England. Settings include health centres, day care facilities, schools or community centres, mobile facilities or people’s homes. The dataset replaced the Children and Young People’s Health Services Data Set (CYPHS) which was restricted to those aged 18 years and under.
Owner NHS England
Keywords Community
Frequency of update Quarterly
Key link https://digital.nhs.uk/data-and-information/data-collections-and-data-sets/data-sets/community-services-data-set
Geographical coverage England
Data resolution None
Specific restrictions to data use None

2. Metrics#

The tables below summarise the nine datasets that make up the CSDS dataset in the UK LLC TRE.

2.1 CSDS Care Activities

Table 1 The number of participants from each LPS that are represented in the CSDS_Care_Activities dataset in the UK LLC TRE
(Note: numbers relate to the most recent extract of NHS England data)

LPS Participant count
ALSPAC 1855
BCS70 1536
BIB 15536
ELSA 3524
EPICN 9623
EXCEED 4263
FENLAND 3739
GLAD 27391
MCS 4788
NCDS58 2180
NEXTSTEP 1800
NIHRBIO_COPING 5596
NSHD46 1200
TEDS 1698
TRACKC19 4040
TWINSUK 4586
UKHLS 2320
TOTAL 95675

2.2 CSDS Care Plans

Table 2 The number of participants from each LPS that are represented in the CSDS_Care_Plans dataset in the UK LLC TRE
(Note: numbers relate to the most recent extract of NHS England data)

LPS Participant count
ALSPAC 21
BCS70 109
BIB 429
ELSA 552
EPICN 4587
EXCEED 30
FENLAND 301
GLAD 1982
MCS 347
NCDS58 203
NEXTSTEP 56
NIHRBIO_COPING 478
NSHD46 162
TEDS 55
TRACKC19 291
TWINSUK 533
UKHLS 208
TOTAL 10344

2.3 CSDS Coded Scored Assessments

Table 3 The number of participants from each LPS that are represented in the CSDS_Coded_Score_Assessments dataset in the UK LLC TRE
(Note: numbers relate to the most recent extract of NHS England data)

LPS Participant count
ALSPAC <10
BCS70 <10
BIB <10
ELSA 25
EPICN <10
EXCEED 113
FENLAND <10
GLAD 43
MCS <10
NCDS58 11
NEXTSTEP 0
NIHRBIO_COPING 21
NSHD46 <10
TEDS 0
TRACKC19 17
TWINSUK 18
UKHLS 10
TOTAL 258

2.4 CSDS Demographics and Referral

Table 4 The number of participants from each LPS that are represented in the CSDS_demographics_and_referral dataset in the UK LLC TRE
(Note: numbers relate to the most recent extract of NHS England data)

LPS Participant count
ALSPAC 2502
BCS70 2007
BIB 20900
ELSA 4024
EPICN 10483
EXCEED 4766
FENLAND 4490
GLAD 36833
MCS 8348
NCDS58 2610
NEXTSTEP 2321
NIHRBIO_COPING 6959
NSHD46 1381
TEDS 2412
TRACKC19 5168
TWINSUK 5815
UKHLS 2990
TOTAL 124009

2.5 CSDS diagnoses

Table 5 The number of participants from each LPS that are represented in the CSDS_diagnoses dataset in the UK LLC TRE
(Note: numbers relate to the most recent extract of NHS England data)

LPS Participant count
ALSPAC 29
BCS70 270
BIB 1340
ELSA 800
EPICN 2191
EXCEED 54
FENLAND 422
GLAD 4016
MCS 727
NCDS58 414
NEXTSTEP 154
NIHRBIO_COPING 904
NSHD46 266
TEDS 160
TRACKC19 712
TWINSUK 771
UKHLS 424
TOTAL 13654

2.6 CSDS Group Sessions

Table 6 The number of participants from each LPS that are represented in the CSDS_group_sessions dataset in the UK LLC TRE
(Note: numbers relate to the most recent extract of NHS England data)

---------------------------------------------------------------------------
KeyError                                  Traceback (most recent call last)
File ~/.local/share/mise/installs/python/3.13.5/lib/python3.13/site-packages/pandas/core/indexes/base.py:3812, in Index.get_loc(self, key)
   3811 try:
-> 3812     return self._engine.get_loc(casted_key)
   3813 except KeyError as err:

File pandas/_libs/index.pyx:167, in pandas._libs.index.IndexEngine.get_loc()

File pandas/_libs/index.pyx:196, in pandas._libs.index.IndexEngine.get_loc()

File pandas/_libs/hashtable_class_helper.pxi:7088, in pandas._libs.hashtable.PyObjectHashTable.get_item()

File pandas/_libs/hashtable_class_helper.pxi:7096, in pandas._libs.hashtable.PyObjectHashTable.get_item()

KeyError: 'cohort'

The above exception was the direct cause of the following exception:

KeyError                                  Traceback (most recent call last)
Cell In[8], line 1
----> 1 display(document6.style_table(document6.get_cohort_count()))

File /opt/build/repo/ukllc_book/docs/linked_health_data/NHS_England/Other datasets/CSDS/../../../../scripts/data_doc_helper.py:80, in DocHelper.get_cohort_count(self)
     78 # remove cohorts not included
     79 rm = ['GENSCOT', 'NICOLA', 'SABRE']
---> 80 df = df[~df['cohort'].isin(rm)]
     82 # strip down df and rename
     83 df = df[['cohort', 'count']].rename(columns={'cohort': 'LPS',
     84                         'count': 'Participant count'})

File ~/.local/share/mise/installs/python/3.13.5/lib/python3.13/site-packages/pandas/core/frame.py:4107, in DataFrame.__getitem__(self, key)
   4105 if self.columns.nlevels > 1:
   4106     return self._getitem_multilevel(key)
-> 4107 indexer = self.columns.get_loc(key)
   4108 if is_integer(indexer):
   4109     indexer = [indexer]

File ~/.local/share/mise/installs/python/3.13.5/lib/python3.13/site-packages/pandas/core/indexes/base.py:3819, in Index.get_loc(self, key)
   3814     if isinstance(casted_key, slice) or (
   3815         isinstance(casted_key, abc.Iterable)
   3816         and any(isinstance(x, slice) for x in casted_key)
   3817     ):
   3818         raise InvalidIndexError(key)
-> 3819     raise KeyError(key) from err
   3820 except TypeError:
   3821     # If we have a listlike key, _check_indexing_error will raise
   3822     #  InvalidIndexError. Otherwise we fall through and re-raise
   3823     #  the TypeError.
   3824     self._check_indexing_error(key)

KeyError: 'cohort'

2.7 CSDS Immunisations

Table 7 The number of participants from each LPS that are represented in the CSDS_immunisations dataset in the UK LLC TRE
(Note: numbers relate to the most recent extract of NHS England data)

LPS Participant count
ALSPAC <10
BCS70 <10
BIB 6392
ELSA <10
EPICN <10
EXCEED 11
FENLAND 0
GLAD 2707
MCS 1324
NCDS58 <10
NEXTSTEP 17
NIHRBIO_COPING 46
NSHD46 <10
TEDS 36
TRACKC19 <10
TWINSUK 87
UKHLS 64
TOTAL 10684

2.8 CSDS Onward Referrals

Table 8 The number of participants from each LPS that are represented in the CSDS_onward_referrals dataset in the UK LLC TRE
(Note: numbers relate to the most recent extract of NHS England data)

LPS Participant count
ALSPAC 14
BCS70 60
BIB 546
ELSA 218
EPICN 222
EXCEED 52
FENLAND 802
GLAD 1144
MCS 229
NCDS58 116
NEXTSTEP 50
NIHRBIO_COPING 400
NSHD46 56
TEDS 33
TRACKC19 203
TWINSUK 253
UKHLS 95
TOTAL 4493

2.9 CSDS Referral to Treatment

Table 9 The number of participants from each LPS that are represented in the CSDS_onward_referrals dataset in the UK LLC TRE
(Note: numbers relate to the most recent extract of NHS England data)

LPS Participant count
ALSPAC 183
BCS70 646
BIB 1382
ELSA 1563
EPICN 9007
EXCEED 3132
FENLAND 3425
GLAD 11358
MCS 1753
NCDS58 916
NEXTSTEP 456
NIHRBIO_COPING 2786
NSHD46 479
TEDS 525
TRACKC19 1735
TWINSUK 1830
UKHLS 1039
TOTAL 42215

3. Helpful syntax#

Below we will include syntax that may be helpful to other researchers in the UK LLC TRE. For longer scripts, we will include a snippet of the code plus a link to Git where you can find the full script.

Contents