Load packages and CLEANED data

library(tidyverse) # package for data cleaning and plotting)
library(modelsummary)

cic_list <- read_csv("data/cic_full_list.csv")

Draw cross tab and print full list

datasummary(region + 1 ~ location_type + 1, data = cic_list, fmt = 0)
region Independent Healthcare Org Primary Medical Services Social Care Org All
East Midlands 1 3 4 8
East of England 2 1 6 9
London 4 5 9 18
North East 0 1 4 5
North West 1 5 10 16
South East 2 3 6 11
South West 2 1 6 9
West Midlands 0 0 6 6
Yorkshire and The Humber 2 4 8 14
All 14 23 59 96 
cic_list %>% 
  mutate(index = paste(index, " ")) %>% 
  kableExtra::kable()
index provider_name location_type primary_cat region
1 Achieving for Children Community Interest Company Social Care Org Community based adult social care services London
2 Acute Need CIC Social Care Org Community based adult social care services North West
3 All Seasons Community Support CIC Social Care Org Community based adult social care services South East
4 Angels Community Enterprises C.I.C. Social Care Org Community based adult social care services Yorkshire and The Humber
5 Annie’s Healthcare Services C.I.C. Social Care Org Community based adult social care services London
6 Arch Health Community Interest Company Primary Medical Services GP Practices South East
7 Aspire: for Intelligent Care and Support C.I.C Social Care Org Community based adult social care services North West
8 Barnet Federated GPs CIC Primary Medical Services GP Practices London
9 Barnsley Healthcare Federation CIC Primary Medical Services GP Practices Yorkshire and The Humber
10 Bevan Healthcare C.I.C. Primary Medical Services GP Practices Yorkshire and The Humber
11 Bexley Health Neighbourhood Care C.I.C. Primary Medical Services GP Practices London
12 Bolton Community Practice C.I.C. Primary Medical Services GP Practices North West
13 Bradford Care Alliance CIC Independent Healthcare Org Out of hours Yorkshire and The Humber
14 Bromley Healthcare Community Interest Company Independent Healthcare Org Community health - NHS & Independent London
15 Care Solution Bureau CIC Social Care Org Community based adult social care services London
16 Carers Break Community Interest Company Social Care Org Community based adult social care services South West
17 Carers Forward C.I.C. Social Care Org Community based adult social care services West Midlands
18 Carfax Health Enterprise Community Interest Company Primary Medical Services GP Practices South West
19 Catalyst Choices Community Interest Company Social Care Org Community based adult social care services North West
20 City Health Care Partnership CIC Social Care Org Residential social care Yorkshire and The Humber
21 Cornerstone Healthcare Community Interest Company Primary Medical Services GP Practices North West
22 CTRC Community Interest Company Social Care Org Community based adult social care services London
23 DHU 111 (East Midlands) CIC Independent Healthcare Org Remote clinical advice East Midlands
24 DHU Health Care C.I.C. Primary Medical Services Out of hours East Midlands
25 E2Inspire C.I.C. Social Care Org Community based adult social care services North West
26 EAM Lodge Community Interest Company Social Care Org Residential social care North West
27 East Of England Homecare C.I.C Social Care Org Community based adult social care services East of England
28 Eazy Innovations C.I.C. Social Care Org Community based adult social care services London
29 Empanda Care & Support Ltd CIC Social Care Org Residential social care East of England
30 Esteem Homecare Services CIC Social Care Org Community based adult social care services North East
31 Falcare Community Interest Company Social Care Org Community based adult social care services South West
32 Favoured Health Care CIC Social Care Org Community based adult social care services South East
33 Flexible Community Care CIC Social Care Org Community based adult social care services London
34 Flourish Enterprises Community Interest Company Social Care Org Community based adult social care services Yorkshire and The Humber
35 Future Directions CIC Social Care Org Residential social care North West
36 Future Health And Social Care Association C.I.C. Social Care Org Community based adult social care services West Midlands
37 Gannicox CIC Social Care Org Community based adult social care services South West
38 Gateway Primary Care C.I.C. Primary Medical Services GP Practices Yorkshire and The Humber
39 Harrow Health C.I.C Independent Healthcare Org Independent consulting doctors London
40 Hillside Care Services Community Interest Company Social Care Org Community based adult social care services London
41 Home Fairy CIC Social Care Org Community based adult social care services East Midlands
42 Homecare North East CIC Social Care Org Community based adult social care services North East
43 Homeless Health CIC Primary Medical Services GP Practices London
44 Hope Citadel Healthcare Community Interest Company Primary Medical Services GP Practices North West
45 Ideal Community Care Solutions C.I.C. Social Care Org Community based adult social care services Yorkshire and The Humber
46 Include ‘In’ Autism community interest company Social Care Org Community based adult social care services North East
47 Inclusion Healthcare Social Enterprise CIC Primary Medical Services GP Practices East Midlands
48 Independence Matters C.I.C. Social Care Org Community based adult social care services East of England
49 Invicta Health Community Interest Company Primary Medical Services GP Practices South East
50 Just Ask Domestic Services Community Interest Company Social Care Org Community based adult social care services Yorkshire and The Humber
51 Karrek Community CIC Social Care Org Community based adult social care services South West
52 Kidsgrove Care Solutions CIC Social Care Org Residential social care West Midlands
53 Locala Community Partnerships C.I.C. Primary Medical Services GP Practices Yorkshire and The Humber
54 Maids Care CIC Social Care Org Community based adult social care services South West
55 Medway Community Healthcare C.I.C Independent Healthcare Org Community health - NHS & Independent South East
56 MEEBBB Health CIC Primary Medical Services GP Practices London
57 My Personal Enablement Support Partnership Community Interest Company Social Care Org Community based adult social care services South East
58 National Centre for Integrative Medicine Community Interest Company Independent Healthcare Org Independent consulting doctors South West
59 Nottingham Citycare Partnership CIC Primary Medical Services Urgent care services & mobile doctors East Midlands
60 Out Of Hours West Lancashire C.I.C. Primary Medical Services Out of hours North West
61 Paul Clarke (Staffordshire) Community Interest Company Social Care Org Residential social care West Midlands
62 Peggy’s World CiC Social Care Org Community based adult social care services Yorkshire and The Humber
63 Positive Support for You CIC Social Care Org Community based adult social care services North East
64 PossAbilities C.I.C Social Care Org Community based adult social care services North West
65 Provide Community Interest Company Social Care Org Residential social care East of England
66 Quay Health Solutions CIC Independent Healthcare Org Independent consulting doctors London
67 Rani Care C.I.C. Social Care Org Community based adult social care services Yorkshire and The Humber
68 Reach Learning Disability Care C.I.C. Social Care Org Community based adult social care services East Midlands
69 Richmond House Social Care Services CIC Social Care Org Community based adult social care services Yorkshire and The Humber
70 Sahan Cares C.I.C. Social Care Org Community based adult social care services London
71 Salford Primary Care Together CIC Primary Medical Services GP Practices North West
72 Sentinel Healthcare South West CIC Independent Healthcare Org Independent consulting doctors South West
73 Silver Tree Home Support Community Interest Company Social Care Org Community based adult social care services West Midlands
74 Sisters Care Services CIC Social Care Org Community based adult social care services West Midlands
75 South Durham Health C.I.C Primary Medical Services Out of hours North East
76 SPDNS Nurse Care Community Interest Company Social Care Org Community based adult social care services East of England
77 Spectrum Community Health C.I.C. Independent Healthcare Org Community substance misuse Yorkshire and The Humber
78 Spectrum Continuing Care CIC Social Care Org Community based adult social care services South East
79 Springs Of Joy Care Solution (SOJ) C.I.C Social Care Org Community based adult social care services East Midlands
80 Suffolk GP Federation C.I.C. Independent Healthcare Org Out of hours East of England
81 Sunnyhill Healthcare C.I.C Primary Medical Services GP Practices East of England
82 Sunshine Care (Rochdale) C.I.C Social Care Org Community based adult social care services North West
83 Support Horizons Community Interest Company Social Care Org Community based adult social care services South East
84 Sussex Elderly Care Community Interest Company Social Care Org Community based adult social care services South East
85 Thanet Health Community Interest Company Independent Healthcare Org Independent consulting doctors South East
86 The Confederation, Hillingdon CIC Independent Healthcare Org Independent consulting doctors London
87 Thurrock Lifestyle Solutions CIC Social Care Org Community based adult social care services East of England
88 Tower Hamlets GP Care Group CIC Primary Medical Services Out of hours London
89 Training, Employment, Support Solutions CIC Social Care Org Community based adult social care services East Midlands
90 True Colours Inclusive CIC Social Care Org Community based adult social care services North West
91 Viaduct Care C.I.C. Independent Healthcare Org Out of hours North West
92 Vision Beyond Autism CIC Social Care Org Community based adult social care services North West
93 Wellsbourne Healthcare CIC Primary Medical Services GP Practices South East
94 West Cambs Federation CIC Independent Healthcare Org Independent consulting doctors East of England
95 You First Support Services CIC Social Care Org Community based adult social care services South West
96 Your Healthcare Community Interest Company Social Care Org Community based adult social care services London

Importing older list and Merge

# Add a column indicating Old/New
cic_list_socialcare <- read_csv("data/cic_cqc.csv") %>% 
  select(provider_name) %>% 
  mutate(mark = "old")

cic_list_full <- cic_list %>% 
  left_join(cic_list_socialcare, by = "provider_name") %>% 
  mutate(mark = ifelse(is.na(mark), "new", "old"))
cic_list_full %>% 
  mutate(index = paste(index, " ")) %>% 
  kableExtra::kable()
index provider_name location_type primary_cat region mark
1 Achieving for Children Community Interest Company Social Care Org Community based adult social care services London old
2 Acute Need CIC Social Care Org Community based adult social care services North West old
3 All Seasons Community Support CIC Social Care Org Community based adult social care services South East old
4 Angels Community Enterprises C.I.C. Social Care Org Community based adult social care services Yorkshire and The Humber old
5 Annie’s Healthcare Services C.I.C. Social Care Org Community based adult social care services London old
6 Arch Health Community Interest Company Primary Medical Services GP Practices South East new
7 Aspire: for Intelligent Care and Support C.I.C Social Care Org Community based adult social care services North West old
8 Barnet Federated GPs CIC Primary Medical Services GP Practices London new
9 Barnsley Healthcare Federation CIC Primary Medical Services GP Practices Yorkshire and The Humber new
10 Bevan Healthcare C.I.C. Primary Medical Services GP Practices Yorkshire and The Humber new
11 Bexley Health Neighbourhood Care C.I.C. Primary Medical Services GP Practices London new
12 Bolton Community Practice C.I.C. Primary Medical Services GP Practices North West new
13 Bradford Care Alliance CIC Independent Healthcare Org Out of hours Yorkshire and The Humber new
14 Bromley Healthcare Community Interest Company Independent Healthcare Org Community health - NHS & Independent London new
15 Care Solution Bureau CIC Social Care Org Community based adult social care services London old
16 Carers Break Community Interest Company Social Care Org Community based adult social care services South West old
17 Carers Forward C.I.C. Social Care Org Community based adult social care services West Midlands old
18 Carfax Health Enterprise Community Interest Company Primary Medical Services GP Practices South West new
19 Catalyst Choices Community Interest Company Social Care Org Community based adult social care services North West old
20 City Health Care Partnership CIC Social Care Org Residential social care Yorkshire and The Humber old
21 Cornerstone Healthcare Community Interest Company Primary Medical Services GP Practices North West new
22 CTRC Community Interest Company Social Care Org Community based adult social care services London old
23 DHU 111 (East Midlands) CIC Independent Healthcare Org Remote clinical advice East Midlands new
24 DHU Health Care C.I.C. Primary Medical Services Out of hours East Midlands new
25 E2Inspire C.I.C. Social Care Org Community based adult social care services North West old
26 EAM Lodge Community Interest Company Social Care Org Residential social care North West old
27 East Of England Homecare C.I.C Social Care Org Community based adult social care services East of England old
28 Eazy Innovations C.I.C. Social Care Org Community based adult social care services London old
29 Empanda Care & Support Ltd CIC Social Care Org Residential social care East of England old
30 Esteem Homecare Services CIC Social Care Org Community based adult social care services North East old
31 Falcare Community Interest Company Social Care Org Community based adult social care services South West old
32 Favoured Health Care CIC Social Care Org Community based adult social care services South East old
33 Flexible Community Care CIC Social Care Org Community based adult social care services London old
34 Flourish Enterprises Community Interest Company Social Care Org Community based adult social care services Yorkshire and The Humber old
35 Future Directions CIC Social Care Org Residential social care North West old
36 Future Health And Social Care Association C.I.C. Social Care Org Community based adult social care services West Midlands old
37 Gannicox CIC Social Care Org Community based adult social care services South West old
38 Gateway Primary Care C.I.C. Primary Medical Services GP Practices Yorkshire and The Humber new
39 Harrow Health C.I.C Independent Healthcare Org Independent consulting doctors London new
40 Hillside Care Services Community Interest Company Social Care Org Community based adult social care services London old
41 Home Fairy CIC Social Care Org Community based adult social care services East Midlands old
42 Homecare North East CIC Social Care Org Community based adult social care services North East old
43 Homeless Health CIC Primary Medical Services GP Practices London new
44 Hope Citadel Healthcare Community Interest Company Primary Medical Services GP Practices North West new
45 Ideal Community Care Solutions C.I.C. Social Care Org Community based adult social care services Yorkshire and The Humber old
46 Include ‘In’ Autism community interest company Social Care Org Community based adult social care services North East new
47 Inclusion Healthcare Social Enterprise CIC Primary Medical Services GP Practices East Midlands new
48 Independence Matters C.I.C. Social Care Org Community based adult social care services East of England old
49 Invicta Health Community Interest Company Primary Medical Services GP Practices South East new
50 Just Ask Domestic Services Community Interest Company Social Care Org Community based adult social care services Yorkshire and The Humber old
51 Karrek Community CIC Social Care Org Community based adult social care services South West old
52 Kidsgrove Care Solutions CIC Social Care Org Residential social care West Midlands old
53 Locala Community Partnerships C.I.C. Primary Medical Services GP Practices Yorkshire and The Humber new
54 Maids Care CIC Social Care Org Community based adult social care services South West old
55 Medway Community Healthcare C.I.C Independent Healthcare Org Community health - NHS & Independent South East new
56 MEEBBB Health CIC Primary Medical Services GP Practices London new
57 My Personal Enablement Support Partnership Community Interest Company Social Care Org Community based adult social care services South East old
58 National Centre for Integrative Medicine Community Interest Company Independent Healthcare Org Independent consulting doctors South West new
59 Nottingham Citycare Partnership CIC Primary Medical Services Urgent care services & mobile doctors East Midlands new
60 Out Of Hours West Lancashire C.I.C. Primary Medical Services Out of hours North West new
61 Paul Clarke (Staffordshire) Community Interest Company Social Care Org Residential social care West Midlands old
62 Peggy’s World CiC Social Care Org Community based adult social care services Yorkshire and The Humber new
63 Positive Support for You CIC Social Care Org Community based adult social care services North East old
64 PossAbilities C.I.C Social Care Org Community based adult social care services North West old
65 Provide Community Interest Company Social Care Org Residential social care East of England old
66 Quay Health Solutions CIC Independent Healthcare Org Independent consulting doctors London new
67 Rani Care C.I.C. Social Care Org Community based adult social care services Yorkshire and The Humber old
68 Reach Learning Disability Care C.I.C. Social Care Org Community based adult social care services East Midlands old
69 Richmond House Social Care Services CIC Social Care Org Community based adult social care services Yorkshire and The Humber old
70 Sahan Cares C.I.C. Social Care Org Community based adult social care services London old
71 Salford Primary Care Together CIC Primary Medical Services GP Practices North West new
72 Sentinel Healthcare South West CIC Independent Healthcare Org Independent consulting doctors South West new
73 Silver Tree Home Support Community Interest Company Social Care Org Community based adult social care services West Midlands old
74 Sisters Care Services CIC Social Care Org Community based adult social care services West Midlands old
75 South Durham Health C.I.C Primary Medical Services Out of hours North East new
76 SPDNS Nurse Care Community Interest Company Social Care Org Community based adult social care services East of England old
77 Spectrum Community Health C.I.C. Independent Healthcare Org Community substance misuse Yorkshire and The Humber new
78 Spectrum Continuing Care CIC Social Care Org Community based adult social care services South East old
79 Springs Of Joy Care Solution (SOJ) C.I.C Social Care Org Community based adult social care services East Midlands old
80 Suffolk GP Federation C.I.C. Independent Healthcare Org Out of hours East of England new
81 Sunnyhill Healthcare C.I.C Primary Medical Services GP Practices East of England new
82 Sunshine Care (Rochdale) C.I.C Social Care Org Community based adult social care services North West old
83 Support Horizons Community Interest Company Social Care Org Community based adult social care services South East old
84 Sussex Elderly Care Community Interest Company Social Care Org Community based adult social care services South East old
85 Thanet Health Community Interest Company Independent Healthcare Org Independent consulting doctors South East new
86 The Confederation, Hillingdon CIC Independent Healthcare Org Independent consulting doctors London new
87 Thurrock Lifestyle Solutions CIC Social Care Org Community based adult social care services East of England old
88 Tower Hamlets GP Care Group CIC Primary Medical Services Out of hours London new
89 Training, Employment, Support Solutions CIC Social Care Org Community based adult social care services East Midlands old
90 True Colours Inclusive CIC Social Care Org Community based adult social care services North West old
91 Viaduct Care C.I.C. Independent Healthcare Org Out of hours North West new
92 Vision Beyond Autism CIC Social Care Org Community based adult social care services North West old
93 Wellsbourne Healthcare CIC Primary Medical Services GP Practices South East new
94 West Cambs Federation CIC Independent Healthcare Org Independent consulting doctors East of England new
95 You First Support Services CIC Social Care Org Community based adult social care services South West old
96 Your Healthcare Community Interest Company Social Care Org Community based adult social care services London old

End of document 3/23/2023