home / nhsadmin

Care Home Successors

Data source: OUseful Databeat

7,867 rows

View and edit SQL

This data as .json

Suggested facets: Succession Indicator

Link rowid Organisation Code Successor Organisation Code Successor Reason Code Succession Effective Date Succession Indicator
1 VL002 VM2T3 R 20130108  
2 VL003 VM682 R 20150727  
3 VL00F VM581 R 20141031 F
4 VL00H VLW9G R 20100119  
5 VL00L VLWPC R 20100209 X
6 VL00N VM0TL R 20120125  
7 VL00P VM2AL R 20120829  
8 VL010 VLXAT R 20100714 X
9 VL014 VM2D6 R 20120905 F
10 VL016 VLWTX R 20100308 F
11 VL01C VM0PC R 20120117 F
12 VL01J VM6EF R 20150916  
13 VL01L VLV6F R 20090828 X
14 VL01M VLWCV R 20100119 X
15 VL01V VM5K3 R 20150126  
16 VL021 VLXG7 R 20100820  
17 VL028 VM2ML R 20121128  
18 VL02L VM3LV R 20130814  
19 VL033 VLW6V R 20100118 X
20 VL034 VLXG9 R 20100820  
21 VL03E VLXGD R 20100820  
22 VL03L VM8GQ R 20170308  
23 VL03M VM23Q R 20120613 F
24 VL043 VM67T R 20150723  
25 VL048 VLWP9 R 20100209 X
26 VL04C VM395 R 20130605  
27 VL04J VM1RY R 20120508 X
28 VL04M VM21F R 20120521  
29 VL04P VM67V R 20150723  
30 VL055 VM502 R 20140724  
31 VL05C VM532 R 20140820  
32 VL05J VM3QX R 20130905 X
33 VL05N VM0EC R 20111128 X
34 VL05V VLWP8 R 20100209 X
35 VL06E VM2M3 R 20121120  
36 VL06F VM3LR R 20130814  
37 VL06N VM1TR R 20120509  
38 VL06X VLRYC R 20090120 X
39 VL06Y VLXVE R 20101216 X
40 VL07C VM4WN R 20140711  
41 VL07D VLX26 R 20100427 X
42 VL07J VLXMW R 20101007  
43 VL07R VM1DC R 20120214 X
44 VL07T VM2C8 R 20120830 F
45 VL07V VM5HY R 20150114 X
46 VL07W VLXG8 R 20100820 X
47 VL082 VM3NC R 20130816  
48 VL083 VM6GX R 20151001 F
49 VL08W VM0MW R 20120113 X
50 VL08X VM0MY R 20120113 X
51 VL094 VM3LQ R 20130814  
52 VL096 VM3LX R 20130814 X
53 VL09A VM5D5 R 20141119  
54 VL09Q VM3NA R 20130816  
55 VL09W VM5NH R 20150227  
56 VL0A2 VL4KG R 20170510  
57 VL0AJ VM71V R 20160210  
58 VL0AV VM17Q R 20120208 F
59 VL0AX VLT0V R 20090122 F
60 VL0C3 VM3LT R 20130814  
61 VL0C6 VM67K R 20150717  
62 VL0C9 VM0MN R 20120113  
63 VL0CA VLTNY R 20090615 X
64 VL0CD VM5C5 R 20141119  
65 VL0CL VLTW0 R 20090716 F
66 VL0CN VM49M R 20140128  
67 VL0CV VM66W R 20150709  
68 VL0D0 VM6EH R 20150916  
69 VL0D6 VM2Y8 R 20130315 X
70 VL0D7 VM4N2 R 20140403  
71 VL0D8 VLVL8 R 20091103 F
72 VL0DG VLVDH R 20090928 X
73 VL0DK VLW7J R 20100118 F
74 VL0DL VLYFW R 20111004  
75 VL0DX VLX72 R 20100611 X
76 VL0E0 VLV1H R 20090804 F
77 VL0E3 VM88M R 20170214  
78 VL0ED VLXE9 R 20100809 F
79 VL0EL VM6MD R 20151110  
80 VL0ER VM4HH R 20140207  
81 VL0EW VM68N R 20150807  
82 VL0EY VM2A3 R 20120829  
83 VL0F4 VLVGM R 20091023 F
84 VL0F8 VM1QF R 20120503  
85 VL0FC VM368 R 20130501  
86 VL0FG VLX2N R 20100517  
87 VL0FM VM3LH R 20130814 F
88 VL0G3 VLW2X R 20100105  
89 VL0G6 VLVGN R 20091023 X
90 VL0G7 VLV1L R 20090804 F
91 VL0G8 VM6AD R 20150813  
92 VL0GA VM4HJ R 20140207  
93 VL0GJ VM23A R 20120613  
94 VL0GV VLY9R R 20110721  
95 VL0GY VM48H R 20140115  
96 VL0H4 VLVCG R 20090924  
97 VL0H9 VLRWV R 20090119  
98 VL0HC VLW08 R 20091211 F
99 VL0HW VM7MC R 20160908  
100 VL0HY VLV1N R 20090804  

Next page

CREATE TABLE "ecarehomesucc" (
"Organisation Code" TEXT,
  "Successor Organisation Code" TEXT,
  "Successor Reason Code" TEXT,
  "Succession Effective Date" INTEGER,
  "Succession Indicator" TEXT
)
Powered by Datasette · Query took 22.952ms · Data source: OUseful Databeat