home / nhsadmin

Care Home Headquarters

Data source: OUseful Databeat

12,216 rows

View and edit SQL

This data as .json

Suggested facets: Amended Record Indicator, Country

Link rowid Organisation Code Name Address Line 1 Address Line 2 Address Line 3 Address Line 4 Address Line 5 Postcode Open Date Close Date Amended Record Indicator Country
1 A000 229 Mitcham Lane Ltd 99 Sunny Hill Road     London Greater London SW16 2UW 2008-11-25 00:00:00   0 1
2 A001 Abbey Healthcare 82-84 Calcutta Road     Tilbury Essex RM18 7QJ 2008-11-25 00:00:00   0 1
3 A002 Access for Living Catford     London Greater London SE6 2LW 2008-11-25 00:00:00 2010-09-01 00:00:00 0 1
4 A003 Acorn Lodge Ltd 15 Atherden Road Hackney   London Greater London E5 0QP 2008-11-25 00:00:00 2015-01-12 00:00:00 0 1
5 A004 A H Choudhry Hunningley Grange 327 Doncaster Road   Barnsley South Yorkshire S70 3PJ 2017-05-10 00:00:00   1 1
6 A005 Addaction Agar Road     Truro Cornwall TR1 1JU 2008-11-25 00:00:00 2014-11-13 00:00:00 0 1
7 A006 Admiral Healthcare Ltd 22 Thrale Road Wandsworth   London Greater London SW16 1PA 2008-11-25 00:00:00 2011-11-16 00:00:00 0 1
8 A007 Ancyra Health Ltd 3rd Floor 314 Regents Park Road Finchley Central London Greater London N3 2JX 2008-11-25 00:00:00 2012-08-28 00:00:00 0 1
9 A008 Pilgrims Friend Society Nasmith House 175 Tower Bridge Road   London Greater London SE1 2AL 2008-11-25 00:00:00   0 1
10 A009 T Agostini 74 Linthorpe Road     London Greater London N16 5RF 2008-11-25 00:00:00 2009-08-27 00:00:00 0 1
11 A00A Agudas Israel Housing Association Ltd 206 Lordship Road     London Greater London N16 5ES 2008-11-25 00:00:00   0 1
12 A00C Ahmad Mungul and Shemil Mungul 156 Shooters Hill Blackheath   London Greater London SE3 8RP 2008-11-25 00:00:00   0 1
13 A00D Approach Lodge Ltd 2 Approach Road     London Greater London E2 9LY 2008-11-25 00:00:00   0 1
14 A00E Ascham Community Care 2000 Ltd Ascham Street     London Greater London NW5 2PD 2008-11-25 00:00:00 2010-02-17 00:00:00 0 1
15 A00F Ashik Ltd 104 Gavestone Road Lee   London Greater London SE12 9BL 2008-11-25 00:00:00 2010-02-01 00:00:00 0 1
16 A00G ASRA Greater London Housing Association ASRA House 1 Long Lane   London Greater London SE1 4PG 2008-11-25 00:00:00 2012-08-28 00:00:00 0 1
17 A00H The Aurora Charity 114-116 Manor Avenue     London Greater London SE4 1TE 2008-11-25 00:00:00 2011-10-17 00:00:00 0 1
18 A00J Aurora Project 85 Jerningham Road     London Greater London SE14 5NH 2008-11-25 00:00:00 2010-07-13 00:00:00 0 1
19 A00K Avenue Trust 28 Vanbrugh Hill Greenwich   London Greater London SE3 7UF 2008-11-25 00:00:00 2010-09-21 00:00:00 0 1
20 A00L Barchester Healthcare Ltd Third Floor, The Aspect 12 Finsbury Square   London Greater London EC2A 1AS 2008-11-25 00:00:00   1 1
21 A00M Basdeo Kaydoo 25 Ambleside Avenue Streatham   London Greater London SW16 1QE 2008-11-25 00:00:00   0 1
22 A00N Ms C Bissessar 89 Barrow Road Streatham   London Greater London SW16 5PB 2008-11-25 00:00:00 2012-04-26 00:00:00 0 1
23 A00P Mr & Mrs E Blackwood 105 Wellmeadow Road Catford   London Greater London SE6 1HN 2008-11-25 00:00:00   0 1
24 A00Q Abbey Healthcare (Mill Hill) Limited Sutherland House 70-78 West Hendon Broadway   London Greater London NW9 7BT 2017-05-10 00:00:00   1 1
25 A00R British Red Cross Society 44 Moorfields     London Greater London EC2Y 9AL 2008-11-25 00:00:00 2010-01-10 00:00:00 0 1
26 A00T Brownhill Care Ltd 305-307 Brownhill Road Catford   London Greater London SE6 1AL 2008-11-25 00:00:00   0 1
27 A00V Acorn Care Providers Limited 17 Duckmoor Road Ashton   Bristol Avon BS3 2DD 2017-05-10 00:00:00   1 1
28 A00W Buxton Healthcare Ltd 50 Barrow Road Streatham   London Greater London SW16 5PG 2008-11-25 00:00:00 2012-04-25 00:00:00 0 1
29 A00X Alexander's Mental Health LTD 101 Alexandra Road     Farnborough Hampshire GU14 6BN 2017-05-10 00:00:00   1 1
30 A00Y Cambuslodge 151 Wandsworth Bridge Road     London Greater London SW6 2TT 2008-11-25 00:00:00   0 1
31 A010 The Camden Society 60 Holmes Road     London Greater London NW5 3AQ 2008-11-25 00:00:00   0 1
32 A011 Nonoy Capina 31 Sach Road     London Greater London E5 9LJ 2008-11-25 00:00:00   0 1
33 A012 Care Support Service Ltd T-A Pathways 11 Gloucester Drive Hackney   London Greater London N4 2LE 2008-11-25 00:00:00 2010-04-26 00:00:00 0 1
34 A013 Cascade Care Ltd 81 Rivington Street     London Greater London EC2A 3AY 2008-11-25 00:00:00 2015-09-14 00:00:00 0 1
35 A014 Iolenta Castelino 144 Gassiot Road     London Greater London SW17 8LE 2008-11-25 00:00:00   0 1
36 A015 Castlebar Healthcare Ltd 46 Sydenham Hill Sydenham   London Greater London SE26 6LU 2008-11-25 00:00:00 2009-10-22 00:00:00 0 1
37 A016 Jim Gopalla, Mr & Mrs Despo and Mrs D Caulfield 4 Newnton Close Stamford Hill   London Greater London N4 2RQ 2008-11-25 00:00:00   0 1
38 A017 Centre 404 128 Kiver Road     London Greater London N19 4PQ 2008-11-25 00:00:00 2013-07-14 00:00:00 0 1
39 A018 Chemical Dependency Centre Ltd 49 Saltram Crescent     London Greater London W9 3JS 2008-11-25 00:00:00 2009-10-27 00:00:00 0 1
40 A019 The Chemical Dependency Centre Ltd 52 Rectory Grove     London Greater London SW4 0EB 2008-11-25 00:00:00 2015-07-16 00:00:00 0 1
41 A01A Westminster Society - People with Learning Disabilities 16a Croxley Road     London Greater London W9 3HL 2008-11-25 00:00:00   0 1
42 A01C City & Hackney Mind 111 Clapton Common     London Greater London E5 9AB 2008-11-25 00:00:00 2010-08-17 00:00:00 0 1
43 A01D Clearwater Care The Stansted Centre Parsonage Road Takeley Bishop's Stortford Hertfordshire CM22 6PU 2008-11-25 00:00:00   0 1
44 A01E 229 Mitcham Lane Ltd 229 Mitcham Lane     London Greater London SW16 6PY 2008-11-25 00:00:00 2015-02-26 00:00:00 0 1
45 A01F Clifford Steven Oakley 140 Trevelyan Road Tooting   London Greater London SW17 9LW 2008-11-25 00:00:00 2012-01-12 00:00:00 0 1
46 A01G Cognithan Ltd 68 Little Heath     London Greater London SE7 8BH 2008-11-25 00:00:00   0 1
47 A01H Colin Ltd 19 Garlies Road     London Greater London SE23 2RU 2008-11-25 00:00:00   0 1
48 A01J Mr & Mrs H Cole 36-40 Penerley Road Catford   London Greater London SE6 2LQ 2008-11-25 00:00:00   0 1
49 A01K Community Housing Association 100 Chalk Farm Road     London Greater London NW1 8EH 2008-11-25 00:00:00 2013-09-16 00:00:00 0 1
50 A01L The Congregation of Daughters of the Cross of Leige 29 Tite Street Chelsea   London Greater London SW3 4JX 2008-11-25 00:00:00   0 1
51 A01M The Cranstoun Projects Ltd 136 West Hill     London Greater London SW15 2UF 2008-11-25 00:00:00 2010-12-15 00:00:00 0 1
52 A01N Crownwise Ltd 17 Streatham Common South South   London Greater London SW16 3BU 2008-11-25 00:00:00   0 1
53 A01P Morden College Morden College 19 St Germans Place Blackheath London Greater London SE3 0PW 2008-11-25 00:00:00   0 1
54 A01Q Dalecrest Ltd 27 Liskeard Gardens Blackheath   London Greater London SE3 0PE 2008-11-25 00:00:00 2010-09-23 00:00:00 0 1
55 A01R D S R E Services Ltd 334 Brownhill Road Catford   London Greater London SE6 1AY 2008-11-25 00:00:00   0 1
56 A01T Dhaneswar Dooraree 78-80 Arran Road Catford   London Greater London SE6 2NN 2008-11-25 00:00:00   0 1
57 A01V Elizabeth Finn Homes Ltd 2nd Floor Hythe House 200 Shepherds Bush Road London Greater London W6 7NL 2008-11-25 00:00:00   0 1
58 A01W East Living Ltd 29-35 West Ham Lane Stratford   London Greater London E15 4PH 2008-11-25 00:00:00   0 1
59 A01X Elgin Court Ltd 133 Bromley Road Catford   London Greater London SE6 2NZ 2008-11-25 00:00:00 2010-01-18 00:00:00 0 1
60 A01Y Elizabeth Peters Care Homes Ltd 22 Newquay Road Catford   London Greater London SE6 2NS 2008-11-25 00:00:00   0 1
61 A020 Equinox - Central Office 1 Waterloo Gardens Milner Square   London Greater London N1 1TY 2008-11-25 00:00:00   0 1
62 A021 Embrace Two Parklands Business Park Birmingham Great Park Rubery Birmingham West Midlands B45 9PZ 2008-11-25 00:00:00   0 1
63 A022 Bode Fadojutimi 110 Griffin Road Plumstead   London Greater London SE18 7QD 2008-11-25 00:00:00 2013-07-21 00:00:00 0 1
64 A023 Family Tree Trust 1 Queensdown Road     London Greater London E5 8NN 2008-11-25 00:00:00 2010-01-17 00:00:00 0 1
65 A024 Community Housing and Therapy 24 Suite 5 & 6 Coda Centre 189 Munster Road London Greater London SW6 6AW 2008-11-25 00:00:00   0 1
66 A025 Field Lane Foundation 2nd Floor Victoria Charity Centre 11 Belgrave Road London Greater London SW1V 1RB 2008-11-25 00:00:00   0 1
67 A026 Alyson House RCH Ltd Godavari Chorleywood Road   Rickmansworth Hertfordshire WD3 4EP 2017-05-10 00:00:00   1 1
68 A027 Florelda Willis-Barnes 97 Forburg Road     London Greater London N16 6HR 2008-11-25 00:00:00 2013-09-04 00:00:00 0 1
69 A028 Forest Healthcare Highgate Studios Studio 523 53-79 Highgate Road London Greater London NW5 1TL 2008-11-25 00:00:00   0 1
70 A029 Fieldside Care Ltd Fieldside 9 Canadian Avenue Catford London Greater London SE6 3AU 2008-11-25 00:00:00   0 1
71 A02A Mrs C Freeman 35-37 Pinfold Road     London Greater London SW16 2SL 2008-11-25 00:00:00 2010-10-06 00:00:00 0 1
72 A02C Friends of the Elderly 40-42 Ebury Street     London Greater London SW1W 0LZ 2008-11-25 00:00:00   0 1
73 A02D Ganymede Care Ltd 1 Battersea Square Ravenscourt Gardens   London Greater London SW11 3RZ 2008-11-25 00:00:00   0 1
74 A02E George Potter Care Home Ltd 130 Battersea High Street Battersea   London Greater London SW11 3JR 2008-11-25 00:00:00 2010-01-18 00:00:00 0 1
75 A02F Thomas Pocklington Trust Pier House 90 Stand on the Green   London Greater London W4 3NN 2008-11-25 00:00:00 2013-03-24 00:00:00 0 1
76 A02G Governors of Sutton's Hospital in Charterhouse Master's Lodge 17 Charterhouse Square   London Greater London EC1M 6AH 2008-11-25 00:00:00   0 1
77 A02H Hackney Independent Living Team 55 Dalston Lane Hackney   London Greater London E8 2NT 2008-11-25 00:00:00 2012-01-12 00:00:00 0 1
78 A02J Mrs Vicky Hall 40 Newick Road Lower Clapton Hackney London Greater London E5 0RR 2008-11-25 00:00:00 2010-01-18 00:00:00 0 1
79 A02K Hanover Heritage 40-42 Ebury Street     London Greater London SW1W 0LZ 2008-11-25 00:00:00 2009-01-27 00:00:00 0 1
80 A02L K A Harrison 58 Canadian Avenue Catford   London Greater London SE6 3BP 2008-11-25 00:00:00 2009-09-16 00:00:00 0 1
81 A02M Amicus Care Limited 7 Kenton Avenue     Harrow Middlesex HA1 2BN 2017-05-10 00:00:00   1 1
82 A02N The Healthcare Professionals Services Ltd 68 Tankerville Road Streatham   London Greater London SW16 5LP 2008-11-25 00:00:00 2017-05-09 00:00:00 1 1
83 A02P Antoine Care Ltd 31 Doversley Road     Birmingham West Midlands B14 6NN 2017-05-10 00:00:00   1 1
84 A02Q High View Care Services Ltd 154 Croydon Road Penge   London Greater London SE20 7YZ 2008-11-25 00:00:00   0 1
85 A02R High View Children's Services Ltd 84 Thurlow Park Road Dulwich   London Greater London SE21 8HY 2008-11-25 00:00:00 2013-06-04 00:00:00 0 1
86 A02T Highfield Healthcare Ltd 36-38 Bromley Road Catford   London Greater London SE6 2TP 2008-11-25 00:00:00 2009-10-22 00:00:00 0 1
87 A02V Hillgreen Care 70 Upper Street Islington   London Greater London N1 0NY 2008-11-25 00:00:00   0 1
88 A02W Healthcare Management Trust 14 Queen Anne's Gate     London Greater London SW1H 9AA 2008-11-25 00:00:00   0 1
89 A02X The Infirmary, Royal Hospital Chelsea Royal Hospital Chelsea Royal Hospital Road   London Greater London SW3 4SR 2008-11-25 00:00:00 2010-06-10 00:00:00 0 1
90 A02Y Janes's House Ltd 39 Stanthorpe Road     London Greater London SW16 2DZ 2008-11-25 00:00:00 2016-02-09 00:00:00 0 1
91 A030 Jehunita Baccuslyn Freeman Streatham     London Greater London SW2 4NR 2008-11-25 00:00:00 2011-11-15 00:00:00 0 1
92 A031 Jim Gopalla and Mr & Mrs Despo 337a Seven Sisters Road     London Greater London N4 1QR 2008-11-25 00:00:00 2017-05-09 00:00:00 1 1
93 A032 Joycare Home Services Ltd 86 Braxted Park     London Greater London SW16 3AU 2008-11-25 00:00:00   0 1
94 A033 Kairos Community Trust 59 Bethwin Road     London Greater London SE5 0XT 2008-11-25 00:00:00   0 1
95 A034 Kalbro Care UK Ltd 34 Elm Park     Stanmore Middlesex HA7 4BJ 2008-11-25 00:00:00 2013-07-25 00:00:00 0 1
96 A035 Mr & Mrs B Kanhye 20 Kashgar Road Plumstead   London Greater London SE18 1HW 2008-11-25 00:00:00 2014-06-08 00:00:00 0 1
97 A036 K U S H Housing Association Ltd 105-109 Foulden Road     London Greater London N16 7UH 2008-11-25 00:00:00 2013-07-15 00:00:00 0 1
98 A037 Mrs E Kerins-McManus 61 St George's Square     London Greater London SW1V 3QR 2008-11-25 00:00:00   0 1
99 A038 Keychange Care 5 St Georges Mews 43 Westminster Bridge Road   London Greater London SE1 7JB 2008-11-25 00:00:00   0 1
100 A039 Remi Konan 33 Disraeli Close     London Greater London SE28 8AP 2008-11-25 00:00:00   0 1

Next page

CREATE TABLE "ecarehomehq" (
"Organisation Code" TEXT,
  "Name" 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,
  "Amended Record Indicator" INTEGER,
  "Country" INTEGER
)
Powered by Datasette · Query took 21.1ms · Data source: OUseful Databeat