home / nhsadmin

Care Home Sites

Data source: OUseful Databeat

31,086 rows

View and edit SQL

This data as .json

Suggested facets: National Grouping, Amended Record Indicator, Country

Link rowid Organisation Code Name National Grouping High Level Health Geography Address Line 1 Address Line 2 Address Line 3 Address Line 4 Address Line 5 Postcode Open Date Close Date Parent Organisation Code Join Parent Date Left Parent Date Contact Telephone Number Amended Record Indicator Current Care Organisation Country
1 VL000 Admiral House Y53 Q36 Cliff Road Wandsworth   London Greater London SW16 1PA 2008-11-25 00:00:00 2011-11-16 00:00:00 A006 2008-11-25 00:00:00 2011-11-16 00:00:00 8081661420.0 0 5LG 1
2 VL001 Focus Project Y56 Q71 29 Akerman Road     London Greater London SW9 6SN 2008-11-25 00:00:00   A04V 2008-11-25 00:00:00   2075019586.0 0 08K 1
3 VL002 Alan Morkill House Y53 Q36 88 St Mark's Road     London Greater London W10 6BY 2008-11-25 00:00:00 2013-01-07 00:00:00 A061 2008-11-25 00:00:00 2013-01-07 00:00:00 2089641123.0 0 5LA 1
4 VL003 Albion House Y56 Q71 8-12 Albion Way Lewisham   London Greater London SE13 6BT 2008-11-25 00:00:00 2015-07-26 00:00:00 A055 2008-11-25 00:00:00 2015-07-26 00:00:00 2083183366.0 0 08L 1
5 VL004 Albany House Y56 Q71 75 Southwood Road New Eltham   London Greater London SE9 3QE 2008-11-25 00:00:00 2017-02-12 00:00:00 A0QX 2008-11-25 00:00:00 2017-02-12 00:00:00 2088501659.0 0 08A 1
6 VL005 Aldington House Y56 Q71 107a Blackheath Park Blackheath   London Greater London SE3 0EY 2008-11-25 00:00:00 2017-03-08 00:00:00 A2CP 2008-11-25 00:00:00 2017-03-08 00:00:00 2084630641.0 1 08A 1
7 VL006 Alver Bank Y56 Q71 17 West Road Clapham   London Greater London SW4 7DL 2008-11-25 00:00:00 2016-04-25 00:00:00 A05X 2008-11-25 00:00:00 2016-04-25 00:00:00 2076278061.0 0 08K 1
8 VL007 Ambleside Lodge Y56 Q71 25 Ambleside Avenue     London Greater London SW16 1QE 2008-11-25 00:00:00   A00M 2008-11-25 00:00:00   2086779175.0 0 08K 1
9 VL008 15 Ambleside Avenue Y56 Q71 Streatham     London Greater London SW16 1QE 2008-11-25 00:00:00   A067 2008-11-25 00:00:00   2086779811.0 0 08K 1
10 VL009 St Andrew's Home Y56 Q71 92 Drewstead Road     London Greater London SW16 1AG 2008-11-25 00:00:00   A01N 2008-11-25 00:00:00   2087690668.0 0 08K 1
11 VL00A Edgar Street Residential Care Home Y54 Q73 3 Edgar Street Huncoat   Accrington Lancashire BB5 6ND 2017-05-10 00:00:00   A0R7 2017-05-10 00:00:00   1254872119.0 1 01A 1
12 VL00C Annaly House Y56 Q71 Old Church 146A Bedford Hill Balham London Greater London SW12 9HW 2008-11-25 00:00:00 2013-07-28 00:00:00 A16X 2008-11-25 00:00:00 2013-07-28 00:00:00 2086735533.0 0 08X 1
13 VL00D Anvil Close Y56 Q71 21-22 & 23-24 Anvil Close     London Greater London SW16 6YA 2008-11-25 00:00:00   A16F 2008-11-25 00:00:00   2086774717.0 0 08X 1
14 VL00E Approach Lodge Y56 Q71 2 Approach Road     London Greater London E2 9LY 2008-11-25 00:00:00   A00D 2008-11-25 00:00:00   2089812210.0 0 08V 1
15 VL00F Ashley Cooper House Y56 Q71 25 Hillyard Street     London Greater London SW9 0NJ 2008-11-25 00:00:00 2014-10-30 00:00:00 A5YM 2008-11-25 00:00:00 2014-10-30 00:00:00 2075820194.0 0 08K 1
16 VL00G The Ashburnham Hostel Y56 Q71 75 Ashburnham Grove Greenwich   London Greater London SE10 8UJ 2008-11-25 00:00:00   703 2008-11-25 00:00:00   2086925032.0 0 08A 1
17 VL00H Ashleigh House Y53 Q36 133 Bromley Road Catford   London Greater London SE6 2NZ 2008-11-25 00:00:00 2010-01-18 00:00:00 A01X 2008-11-25 00:00:00 2010-01-18 00:00:00 2086984166.0 0 5LF 1
18 VL00J Aspinden Wood Centre Y56 Q71 1 Aspinden Road Bermondsey   London Greater London SE16 2DR 2008-11-25 00:00:00   A020 2008-11-25 00:00:00   2072370331.0 0 08Q 1
19 VL00K Athol House Y56 Q71 138 College Road     London Greater London SE19 1XE 2008-11-25 00:00:00   A03F 2008-11-25 00:00:00   2086703740.0 0 08Q 1
20 VL00L Rugby House Project Y53 Q36 8 St Augustines Road     London Greater London NW1 9RN 2008-11-25 00:00:00 2010-02-08 00:00:00 A05W 2008-11-25 00:00:00 2010-02-08 00:00:00 2079167633.0 0 5K7 1
21 VL00M Avalon House Y53 Q36 114-116 Manor Avenue     London Greater London SE4 1TE 2008-11-25 00:00:00 2011-10-17 00:00:00 A00H 2008-11-25 00:00:00 2011-10-17 00:00:00 2086942717.0 0 5LF 1
22 VL00N 104 Bargery Road Y53 Q36 Catford     London Greater London SE6 2LW 2008-11-25 00:00:00 2010-09-01 00:00:00 A002 2008-11-25 00:00:00 2010-09-01 00:00:00 2086955605.0 0 5LF 1
23 VL00P Aashna House Y53 Q36 2 Bates Crescent Streatham Vale   London Greater London SW16 5BP 2008-11-25 00:00:00 2012-08-28 00:00:00 A00G 2008-11-25 00:00:00 2012-08-28 00:00:00 2087650822.0 0 5LD 1
24 VL00Q Beaumont Y53 Q36 2 Church Rise Forest Hill   London Greater London SE23 2UD 2008-11-25 00:00:00 2011-12-06 00:00:00 A05D 2008-11-25 00:00:00 2011-12-06 00:00:00 2086992310.0 0 5LF 1
25 VL00R 161-163 Becklow Road Y56 Q71 161-163 Becklow Road     London Greater London W12 9HH 2008-11-25 00:00:00 2017-01-22 00:00:00 A079 2008-11-25 00:00:00 2017-01-22 00:00:00 2089323916.0 0 08C 1
26 VL00T Blossom Place Y56 Q71 24 Allenby Road West Thamesmead   London Greater London SE28 0BN 2008-11-25 00:00:00   A04L 2008-11-25 00:00:00   2088553322.0 0 08A 1
27 VL00V Bluegrove House Y56 Q71 325 Southwark Park Road Bermondsey   London Greater London SE16 2JN 2008-11-25 00:00:00   A8K7 2008-11-25 00:00:00   8081634680.0 0 08Q 1
28 VL00W 80 Bolingbroke Grove Y53 Q36 80 Bolingbroke Grove     London Greater London SW11 6HB 2008-11-25 00:00:00 2010-06-23 00:00:00 A06W 2008-11-25 00:00:00 2010-06-23 00:00:00 2072233200.0 0 5LG 1
29 VL00X Yarrow Housing Ltd - 37 Brackenbury Road Y56 Q71 37 Brackenbury Road     London Greater London W6 0BG 2008-11-25 00:00:00 2014-03-13 00:00:00 A079 2008-11-25 00:00:00 2014-03-13 00:00:00 2075632125.0 0 08C 1
30 VL00Y Branch Hill House Y56 Q71 Branch Hill     London Greater London NW3 7LS 2008-11-25 00:00:00 2015-11-09 00:00:00 702 2008-11-25 00:00:00 2015-11-09 00:00:00 2077948075.0 0 07R 1
31 VL010 Threshold Support Y53 Q36 19 Breakspears Road Brockley   London Greater London SE4 1XW 2008-11-25 00:00:00 2010-06-09 00:00:00 A06G 2008-11-25 00:00:00 2010-06-09 00:00:00 2086924655.0 0 5LF 1
32 VL011 M Power Ltd Y56 Q71 22a Bromley Road Catford   London Greater London SE6 2TP 2008-11-25 00:00:00   A03W 2008-11-25 00:00:00   2086906681.0 1 08L 1
33 VL012 Brownhill Care Y56 Q71 305-307 Brownhill Road Catford   London Greater London SE6 1AL 2008-11-25 00:00:00   A00T 2008-11-25 00:00:00   2072071705.0 0 08L 1
34 VL013 Brownhill Lodge Y56 Q71 334 Brownhill Road Catford   London Greater London SE6 1AY 2008-11-25 00:00:00   A01R 2008-11-25 00:00:00   2086984978.0 0 08L 1
35 VL014 94 Burnt Ash Hill Y53 Q36 94 Burnt Ash Hill     London Greater London SE12 0HT 2008-11-25 00:00:00 2012-09-04 00:00:00 A03M 2008-11-25 00:00:00 2012-09-04 00:00:00 2088513824.0 0 5LF 1
36 VL015 85 Jerningham Road Y53 Q36 85 Jerningham Road     London Greater London SE14 5NH 2008-11-25 00:00:00 2010-07-13 00:00:00 A00J 2008-11-25 00:00:00 2010-07-13 00:00:00 2072778717.0 0 5LF 1
37 VL016 16 Burghley Road Y53 Q36 16 Burghley Road     London Greater London NW5 1UE 2008-11-25 00:00:00 2010-03-07 00:00:00 A04J 2008-11-25 00:00:00 2010-03-07 00:00:00 2074823332.0 0 5K7 1
38 VL017 Buxton House Y53 Q36 50 Barrow Road Streatham   London Greater London SW16 5PG 2008-11-25 00:00:00 2012-04-25 00:00:00 A00W 2008-11-25 00:00:00 2012-04-25 00:00:00 2086792846.0 0 5LD 1
39 VL018 131-133 Buxton Street Y56 Q71 131-133 Buxton Street     London Greater London E1 5AR 2008-11-25 00:00:00 2014-01-26 00:00:00 A0PP 2008-11-25 00:00:00 2014-01-26 00:00:00 2072472004.0 0 08V 1
40 VL019 Residential Care Home Y53 Q36 22 Byrne Road     London Greater London SW12 8JD 2008-11-25 00:00:00 2009-03-26 00:00:00 A06W 2008-11-25 00:00:00 2009-03-26 00:00:00 2086753606.0 0 5LG 1
41 VL01A 471 Caledonian Road Y53 Q36 471 Caledonian Road     London Greater London N7 9RN 2008-11-25 00:00:00 2010-01-06 00:00:00 TAF 2008-11-25 00:00:00 2010-01-06 00:00:00 2077006399.0 0 5K8 1
42 VL01C Camden Park House Y53 Q36 57-59 Camden Park Road     London Greater London NW1 9BA 2008-11-25 00:00:00 2012-01-16 00:00:00 A06R 2008-11-25 00:00:00 2012-01-16 00:00:00 2072677503.0 0 5K7 1
43 VL01D 212A Camberwell Y53 Q36 New Road     London Greater London SE5 0RR 2008-11-25 00:00:00 2012-12-03 00:00:00 A067 2008-11-25 00:00:00 2012-12-03 00:00:00 2075821963.0 0 5LD 1
44 VL01E Cambuslodge Y56 Q71 151 Wandsworth Bridge Road     London Greater London SW6 2TT 2008-11-25 00:00:00   A00Y 2008-11-25 00:00:00   2077315814.0 0 08C 1
45 VL01F Canonbie Y53 Q36 118 Canonbie Road Forest Hill   London Greater London SE23 3AG 2008-11-25 00:00:00 2011-11-15 00:00:00 A046 2008-11-25 00:00:00 2011-11-15 00:00:00 2082911492.0 0 5LF 1
46 VL01G Carlton Bridge Y53 Q36 42 Woodfield Road     London Greater London W9 2BE 2008-11-25 00:00:00 2012-05-08 00:00:00 A01A 2008-11-25 00:00:00 2012-05-08 00:00:00 2072864032.0 0 5LC 1
47 VL01H Carlton Gate Y56 Q71 Admiral Lodge Harrow Road Flat 10 Florey Lodge London Greater London W9 3TF 2008-11-25 00:00:00   A01A 2008-11-25 00:00:00   2072892352.0 0 08Y 1
48 VL01J Carlton Dene Y56 Q71 45 Kilburn Park Road     London Greater London NW6 5XD 2008-11-25 00:00:00 2015-09-15 00:00:00 713 2008-11-25 00:00:00 2015-09-15 00:00:00 2076414890.0 0 09A 1
49 VL01K Cascade 1 Y56 Q71 16 Bergholt Crescent Stamford Hill   London Greater London N16 5JE 2008-11-25 00:00:00 2014-04-15 00:00:00 A013 2008-11-25 00:00:00 2014-04-15 00:00:00 2088027167.0 0 07T 1
50 VL01L Cascade III Y53 Q36 74 Linthorpe Road     London Greater London N16 5RF 2008-11-25 00:00:00 2009-08-27 00:00:00 A009 2008-11-25 00:00:00 2009-08-27 00:00:00 2088027167.0 0 5C3 1
51 VL01M Cascade IV Y53 Q36 40 Newick Road Lower Clapton Hackney London Greater London E5 0RR 2008-11-25 00:00:00 2010-01-18 00:00:00 A02J 2008-11-25 00:00:00 2010-01-18 00:00:00 2088027167.0 0 5C3 1
52 VL01N Cascade 5 Y56 Q71 42 Ickburgh Road Lower Clapton   London Greater London E5 8AD 2008-11-25 00:00:00 2015-09-14 00:00:00 A013 2008-11-25 00:00:00 2015-09-14 00:00:00 2088065650.0 0 07T 1
53 VL01P 38 Cato Street Y53 Q36 38 Cato Street     London Greater London W1H 5HS 2008-11-25 00:00:00 2010-08-04 00:00:00 A01A 2008-11-25 00:00:00 2010-08-04 00:00:00 2077234388.0 0 5LC 1
54 VL01Q Cavendish Y56 Q71 274a & b Cavendish Road     London Greater London SW12 0BS 2008-11-25 00:00:00   A06G 2008-11-25 00:00:00   2086759957.0 0 08K 1
55 VL01R 64 Charlton Lane Y53 Q36 Charlton     London Greater London SE7 8LA 2008-11-25 00:00:00 2010-03-07 00:00:00 703 2008-11-25 00:00:00 2010-03-07 00:00:00 2083051619.0 0 5A8 1
56 VL01T Charis Primary Programme Y56 Q71 31 Mile End Road     London Greater London E1 4TP 2008-11-25 00:00:00   A06J 2008-11-25 00:00:00   2077903040.0 0 08V 1
57 VL01V Lyle House Y56 Q71 207 Arabella Drive     London Greater London SW15 5LH 2008-11-25 00:00:00 2015-01-25 00:00:00 A0T1 2008-11-25 00:00:00 2015-01-25 00:00:00 2088783806.0 0 08X 1
58 VL01W 44 Chestnut Road Y53 Q36 West Norwood     London Greater London SE27 9LF 2008-11-25 00:00:00 2011-10-06 00:00:00 A1Y5 2008-11-25 00:00:00 2011-10-06 00:00:00 2087613689.0 0 5LD 1
59 VL01X Checaniah House Y53 Q36 26 Chailey Street     London Greater London E5 0RX 2008-11-25 00:00:00 2011-12-19 00:00:00 A06L 2008-11-25 00:00:00 2011-12-19 00:00:00 2085335400.0 0 5C3 1
60 VL01Y 21c Church Lane Y53 Q36 21c Church Lane     London Greater London SW17 9PW 2008-11-25 00:00:00 2010-06-23 00:00:00 A06W 2008-11-25 00:00:00 2010-06-23 00:00:00 2087678420.0 0 5LG 1
61 VL020 Clapton Common Y53 Q36 111 Clapton Common     London Greater London E5 9AB 2008-11-25 00:00:00 2010-08-17 00:00:00 A01C 2008-11-25 00:00:00 2010-08-17 00:00:00 2088025242.0 0 5C3 1
62 VL021 Clarence Road Y53 Q36 134-138 Clarence Road     London Greater London E5 8DY 2008-11-25 00:00:00 2010-08-19 00:00:00 A03L 2008-11-25 00:00:00 2010-08-19 00:00:00 2089852005.0 0 5C3 1
63 VL022 Clerkenwell Project Y53 Q36 7 Cumberland Gardens     London Greater London WC1X 9AG 2008-11-25 00:00:00 2012-04-25 00:00:00 TAF 2008-11-25 00:00:00 2012-04-25 00:00:00 2072784421.0 0 5K8 1
64 VL023 92 Cloudesley Road Y53 Q36 92 Cloudesley Road     London Greater London N1 0EB 2008-11-25 00:00:00 2012-01-19 00:00:00 A057 2008-11-25 00:00:00 2012-01-19 00:00:00 2078332326.0 0 5K8 1
65 VL024 1 Colyton Road Y53 Q36 1 Colyton Road     London Greater London SE22 0NE 2008-11-25 00:00:00 2010-06-09 00:00:00 A065 2008-11-25 00:00:00 2010-06-09 00:00:00 2086938831.0 0 5LE 1
66 VL025 Colin Care Home Y56 Q71 19 Garlies Road     London Greater London SE23 2RU 2008-11-25 00:00:00   A01H 2008-11-25 00:00:00   2086995151.0 0 08L 1
67 VL026 Compton Lodge Y56 Q71 7 Harley Road     London Greater London NW3 3BX 2008-11-25 00:00:00   A0AM 2008-11-25 00:00:00   2077221280.0 0 07R 1
68 VL027 Community Resettlement Project Y53 Q36 24-28 Argyle Street Kings Cross   London Greater London WC1H 8EN 2008-11-25 00:00:00 2012-08-23 00:00:00 A01K 2008-11-25 00:00:00 2012-08-23 00:00:00 2072783629.0 0 5K7 1
69 VL028 Conifers Lodge Y53 Q36 104 Gavestone Road Lee   London Greater London SE12 9BL 2008-11-25 00:00:00 2010-02-01 00:00:00 A00F 2008-11-25 00:00:00 2010-02-01 00:00:00 2088516511.0 0 5A8 1
70 VL029 Cornford Grove Y53 Q36 14 Cornford Grove     London Greater London SW12 9JF 2008-11-25 00:00:00 2009-03-26 00:00:00 A06W 2008-11-25 00:00:00 2009-03-26 00:00:00 2086755466.0 0 5LG 1
71 VL02A Coverdale Road Home Y56 Q71 2 Coverdale Road     London Greater London W12 8JL 2008-11-25 00:00:00   705 2008-11-25 00:00:00   2087499559.0 0 08C 1
72 VL02C Coxley House Y56 Q71 28 Bow Road Bow   London Greater London E3 4LN 2008-11-25 00:00:00   A01W 2008-11-25 00:00:00   2089801599.0 0 08V 1
73 VL02D Crebor Street Home Y53 Q36 2-2a Crebor Street     London Greater London SE22 0HF 2008-11-25 00:00:00 2011-12-08 00:00:00 A06W 2008-11-25 00:00:00 2011-12-08 00:00:00 2086934153.0 0 5LE 1
74 VL02E Cricklade House Y56 Q71 57 Cricklade Avenue Streatham Hill   London Greater London SW2 3HD 2008-11-25 00:00:00 2015-09-14 00:00:00 A03T 2008-11-25 00:00:00 2015-09-14 00:00:00 2086749408.0 0 08K 1
75 VL02F Culverley Care Home Y56 Q71 155 Culverley Road Catford   London Greater London SE6 2JZ 2008-11-25 00:00:00 2015-05-13 00:00:00 A05Y 2008-11-25 00:00:00 2015-05-13 00:00:00 2082656275.0 0 08L 1
76 VL02G The Davies Residential Service Y53 Q36 318-320 Queenstown Road     London Greater London SW8 4LT 2008-11-25 00:00:00 2010-07-13 00:00:00 A06N 2008-11-25 00:00:00 2010-07-13 00:00:00 2076271242.0 0 5LG 1
77 VL02H Dawes House Y53 Q36 6 Bramlands Close Battersea   London Greater London SW11 2NS 2008-11-25 00:00:00 2012-02-16 00:00:00 A061 2008-11-25 00:00:00 2012-02-16 00:00:00 2072235002.0 0 5LG 1
78 VL02J Deepdene House Y56 Q71 55-57 Stanthorpe Road Streatham   London Greater London SW16 2EA 2008-11-25 00:00:00   A2NC 2008-11-25 00:00:00   2087696297.0 0 08K 1
79 VL02K 5 De Lucy Street Y53 Q36 Abbey Wood     London Greater London SE2 9ER 2008-11-25 00:00:00 2011-12-01 00:00:00 703 2008-11-25 00:00:00 2011-12-01 00:00:00 2083111571.0 0 5A8 1
80 VL02L Dover Lodge Y56 Q71 41 Wood Vale     London Greater London SE23 3DS 2008-11-25 00:00:00 2013-08-13 00:00:00 A06W 2008-11-25 00:00:00 2013-08-13 00:00:00 2086935460.0 0 08Q 1
81 VL02M Dove, The Y56 Q71 36 South Croxted Road     London Greater London SE21 8BB 2008-11-25 00:00:00 2015-04-09 00:00:00 A3RE 2008-11-25 00:00:00 2015-04-09 00:00:00 2087614143.0 0 08Q 1
82 VL02N Drewstead Lodge Y56 Q71 93 Drewstead Road     London Greater London SW16 1AD 2008-11-25 00:00:00   A04P 2008-11-25 00:00:00   2087694912.0 0 08K 1
83 VL02P Duchesne House Y56 Q71 Aubyn Square Roehampton Lane   London Greater London SW15 5ND 2008-11-25 00:00:00   A064 2008-11-25 00:00:00   2088788282.0 0 08X 1
84 VL02Q 71-73 Dunton Road Y56 Q71 71-73 Dunton Road     London Greater London SE1 5TW 2008-11-25 00:00:00   A06H 2008-11-25 00:00:00   2072320016.0 0 08Q 1
85 VL02R Elizabeth Peters Residential Care Home Y56 Q71 22 Newquay Road Catford   London Greater London SE6 2NS 2008-11-25 00:00:00   A01Y 2008-11-25 00:00:00   2082440013.0 0 08L 1
86 VL02T The Elms Residential Care Home Y56 Q71 147 Barry Road East Dulwich   London Greater London SE22 0JR 2008-11-25 00:00:00   A066 2008-11-25 00:00:00   2086934622.0 0 08Q 1
87 VL02V Yarrow Housing Ltd 1-2 Elmfield Way Y56 Q71 Yarrow Housing Ltd 1-2 Elmfield Way     London Greater London W9 3TU 2008-11-25 00:00:00   A079 2008-11-25 00:00:00   2072661200.0 0 08Y 1
88 VL02W The Elmstone Y56 Q71 17 Norwood High Street West Norwood   London Greater London SE27 9JU 2008-11-25 00:00:00 2013-07-25 00:00:00 A3RE 2008-11-25 00:00:00 2013-07-25 00:00:00 2086559631.0 0 08K 1
89 VL02X Elwis House Y56 Q71 2-8 Bell Green Lane Sydenham   London Greater London SE26 5TP 2008-11-25 00:00:00   A051 2008-11-25 00:00:00   2087789485.0 0 08L 1
90 VL02Y Emmanuel Care Services Y56 Q71 33 Disraeli Close     London Greater London SE28 8AP 2008-11-25 00:00:00   A039 2008-11-25 00:00:00   2083109340.0 0 08A 1
91 VL030 58 Endlesham Road Y53 Q36 58 Endlesham Road     London Greater London SW12 8JL 2008-11-25 00:00:00 2010-01-18 00:00:00 A06W 2008-11-25 00:00:00 2010-01-18 00:00:00 2087726573.0 0 5LG 1
92 VL031 41 Evering Road Y53 Q36 41 Evering Road     London Greater London N16 7PU 2008-11-25 00:00:00 2011-11-14 00:00:00 A02H 2008-11-25 00:00:00 2011-11-14 00:00:00 2072412145.0 0 5C3 1
93 VL032 Evergreen Y53 Q36 55 Barrow Road     London Greater London SW16 5PE 2008-11-25 00:00:00 2012-04-26 00:00:00 A02Y 2008-11-25 00:00:00 2012-04-26 00:00:00 2086774273.0 0 5LD 1
94 VL033 1 Queensdown Road Y53 Q36 1 Queensdown Road     London Greater London E5 8NN 2008-11-25 00:00:00 2010-01-17 00:00:00 A023 2008-11-25 00:00:00 2010-01-17 00:00:00 2089856908.0 0 5C3 1
95 VL034 41 Felstead Street Y53 Q36 41 Felstead Street     London Greater London E9 5LG 2008-11-25 00:00:00 2010-08-19 00:00:00 A03L 2008-11-25 00:00:00 2010-08-19 00:00:00 2085259655.0 0 5C3 1
96 VL035 Fieldside Y56 Q71 9 Canadian Avenue Catford   London Greater London SE6 3AU 2008-11-25 00:00:00   A029 2008-11-25 00:00:00   2086901215.0 0 08L 1
97 VL036 Westport Care Centre Y56 Q71 14-26 Westport Street Lime House Wapping London Greater London E1 0RA 2008-11-25 00:00:00   A3ER 2008-11-25 00:00:00   2077901222.0 0 08V 1
98 VL037 Flat 4, 22-24 Great Western Road Y53 Q36 Flat 4, 22-24 Great Western Road     London Greater London W9 3NN 2008-11-25 00:00:00 2012-05-08 00:00:00 A01A 2008-11-25 00:00:00 2012-05-08 00:00:00 2072894752.0 0 5LC 1
99 VL038 Flat A, 65 Walterton Road Y53 Q36 Flat A, 65 Walterton Road     London Greater London W9 3SP 2008-11-25 00:00:00 2012-05-08 00:00:00 A01A 2008-11-25 00:00:00 2012-05-08 00:00:00 2072890533.0 0 5LC 1
100 VL039 Florfield Home Y56 Q71 1 Florfield Road Hackney   London Greater London E8 1DW 2008-11-25 00:00:00   A01D 2008-11-25 00:00:00   2085331022.0 0 07T 1

Next page

CREATE TABLE "ecarehomesite" (
"Organisation Code" TEXT,
  "Name" TEXT,
  "National Grouping" TEXT,
  "High Level Health Geography" TEXT,
  "Address Line 1" TEXT,
  "Address Line 2" TEXT,
  "Address Line 3" TEXT,
  "Address Line 4" TEXT,
  "Address Line 5" TEXT,
  "Postcode" TEXT,
  "Open Date" TIMESTAMP,
  "Close Date" TIMESTAMP,
  "Parent Organisation Code" TEXT,
  "Join Parent Date" TIMESTAMP,
  "Left Parent Date" TIMESTAMP,
  "Contact Telephone Number" REAL,
  "Amended Record Indicator" INTEGER,
  "Current Care Organisation" TEXT,
  "Country" INTEGER
)
Powered by Datasette · Query took 75.698ms · Data source: OUseful Databeat