Care Homes In York

City of York Council

@ukgov.care_homes

Table List

1 table(8.48 KB)

Care Homes In York

@ukgov.care_homes.care_homes_in_york

8.48 KB
41 rows
7 columns

id Id	type Type	name Name	address Address	postcode Postcode	telephone Telephone	specialism_or_servicesoffered Specialism Or ServicesOffered
2	CYC Residential Homes	Haxby Hall	Haxby, York	YO32 3DX	01904 768944	Care Home for older people
3	CYC Residential Homes	Morrell House	388 Burton Stone Lane, York	YO30 6EZ	01904 658998	Care Home for older people with dementia
4	CYC Residential Homes	Oakhaven	144 Acomb Road, York	YO24 4HA	01904 791599	Care Home for older people
5	CYC Residential Homes	Willow House	Long Close Lane, Walmgate, York	YO10 4UP	01904 630437	Care Home for older people
6	CYC Residential Homes	Windsor House	22 Ascot Way, Acomb, York	YO24 4QZ	01904 798004	Care Home for older people with dementia
7	CYC Residential Homes	Woolnough House	52 Woolnough Avenue, Tang Hall, York	YO10 3RE	01904 413656	Care Home for older people
8	Independent Residential Care Homes	Broadway Lodge	151 Fulford Rd. York	YO10 4HG	01904 621884	Care Home for older people
9	Independent Residential Care Homes	Christmas Lodge	196 Mount Vale, York	YO24 2DL	01904 647442	Learning Disability or Autism and Mental Health
10	Independent Residential Care Homes	The Dexters	21 Penleys Grove Street	YO31 7PW	01904 644675	Learning Disability or Autism, Mental Health Younger Adults and Older People
11	Independent Residential Care Homes	Galtres	Ox Carr Lane, Strensall	YO32 5TD	01904 491300	Care Home for Older people with dementia


CREATE TABLE care_homes_in_york (
  "id" BIGINT,
  "type" VARCHAR,
  "name" VARCHAR,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "telephone" VARCHAR,
  "specialism_or_servicesoffered" VARCHAR
);