{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["National & Regional Team","Provider - Site","Provider - All","Provider - By Type","Commissioner","Notes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":28,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"National & Regional Team","index":0,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[36,1,38,5],[29,1,29,5],[31,1,31,5],[27,1,27,5],[33,1,33,7]]}
[]
[null,"Title:","Mixed-Sex Accommodation"]
[null,"Summary:","The total occurrences of unjustified mixing in relation to sleeping accommodation."]
[]
[null,"Period:","October 2019"]
[null,"Sources:","MSA, collected via SDCS, NHS England and NHS Improvement (MSA breaches)"]
[null,null,"Hospital Episode Statistics (HES), NHS Digital (FCE data)"]
[null,"Basis:","Provider"]
[null,"Published:","13th December 2019"]
[null,"Revised:","-"]
[null,"Status:","Published"]
[null,"Contact:","Katie Tither - england.nhsdata@nhs.net"]
[]
[null,"National & Regional Level Data"]
[null,"Region Code","Region Name","MSA Breaches1","Finished Consultant Episodes2\n(from previous year)","Breach Rate3"]
[null,"-","England",1840,1831029,{"$f":"ROUND(D16/E16*1000,1)","v":1}]
[]
[null,"Y56","London Commissioning Region",295,288210,{"$f":"ROUND((D18/E18)*1000,1)","v":1}]
[null,"Y58","South West Commissioning Region",201,183290,{"$f":"ROUND((D19/E19)*1000,1)","v":1.1000000000000001}]
[null,"Y59","South East Commissioning Region",766,247720,3.1]
[null,"Y60","Midlands Commissioning Region",215,321810,0.7]
[null,"Y61","East of England Commissioning Region",100,212120,0.5]
[null,"Y62","North West Commissioning Region",259,250340,1]
[null,"Y63","North East and Yorkshire Commissioning Region",4,290560,0]
[]
[]
[null,"Notes:"]
[null,"1. In September 2019 a revised policy, \"Delivering same-sex accommodation\" was published. Data providers were asked to ensure reporting of MSA breaches for the purposes of this collection were in line with the revised policy by January 2020. This transition period allows providers to make appropriate changes to enable them to report on this basis. As such this may impact on data quality for September - December 2019 data. Providers should all be reporting consistently and as per the updated guidance by January 2020. "]
[]
[null,"2. Finished Consultant Episode (FCE) data from Hospital Episode Statistics (HES) are used to calculate the MSA breach rate (for further details on methodology of this calculation see footnote 2). The FCE data presented here are a snapshot of latest HES data available at the time of the MSA publication for the relevant data period (due to timings of HES publication in some months this will represent \"final\" HES data, however for some months this is \"provisional\" HES data). These are used solely for the purposes of calculating an MSA breach rate to allow comparisons across providers and of change over time.\n\nFrom 2017/18 onwards, at the point of publication of MSA revisions (every 6 months), the FCE denominator is updated to reflect final HES data where available so is subject to change and may not match always the published HES timeseries (where provisional data is updated on a monthly basis).  The official and most recent timeseries of HES data is available on the NHS Digital website which will reflect any more recent updates to the provisional HES FCE data. https://digital.nhs.uk/data-and-information/publications/statistical/hospital-episode-statistics-for-admitted-patient-care-outpatient-and-accident-and-emergency-data\n\nRegional level FCE data is displayed accordance with HES disclosure control methodology. \nhttps://digital.nhs.uk/binaries/content/assets/website-assets/data-and-information/data-tools-and-services/data-services/hospital-episode-statistics/hes_analysis_guide_september_2018-v1.1.pdf\n\nHES Disclosure Control\nIn order to protect patient confidentiality '*' appears in the table above for all sub-national breakdowns, where it is possible to calculate a value between 1 and 7 from the data presented. All other sub-national data has been rounded to the nearest 5.\n\nIf the national total is between 1 and 7 (inclusive), no sub-national breakdown will be displayed. \n\nIf the national total is greater than or equal to 8;\na. Sub-national counts between 1 and 7 (inclusive) will be displayed as ’*’.\nb. Zeroes will be unchanged.\nc. All other counts will be rounded to the nearest 5."]
[]
[null,"3. The MSA breach rate is the number of MSA breaches, per 1,000 finished consultant episodes. Due to timeliness of HES data, there is one year’s lag in the denominator data, compared to the MSA breaches. For example, the breach rate for June 2019 is calculated by dividing the total MSA breaches in June 2019 (numerator) by the number of Finished Consultant Episodes in June 2018 (denominator). As such, it is only an estimation. Please see Breach Rate methodology paper for further information via: http://www.england.nhs.uk/statistics/mixed-sex-accommodation/\n\nWhen calculating rates or percentages at regional level using HES data;\n1) Where the numerator or denominator is between 1 and 7 (inclusive), no percentage or rate is calculated, and a ’*’ will be displayed.\n2) Where the numerator is zero, the percentage will be 0%.\n3) Where the unrounded numerator and denominator are greater than or equal to 8, a percentage or rate is calculated using the rounded numerator or denominator.\n4).Where no denominator data is available, no percentage or rate is calculated, and ’N/A’ will be displayed."]
[]
[null,"4. Sandwell and West Birmingham Hospitals NHS Trust (RXK) did not submit data for October 2019 due to data quality issues. "]

{"sheet":"Provider - Site","index":1,"n_rows":104,"n_cols":8,"rows_kept":104,"cut":false,"hidden":false,"merged":[[97,1,97,7],[99,1,99,7],[101,1,101,7],[95,1,95,7],[103,1,103,7]]}
[]
[null,"Title:","Mixed-Sex Accommodation"]
[null,"Summary:","The total occurrences of unjustified mixing in relation to sleeping accommodation."]
[]
[null,"Period:",{"$f":"Publicationmonth","v":"October 2019"}]
[null,"Sources:",{"$f":"'National & Regional Team'!C6","v":"MSA, collected via SDCS, NHS England and NHS Improvement (MSA breaches)"}]
[null,null,{"$f":"'National & Regional Team'!C7","v":"Hospital Episode Statistics (HES), NHS Digital (FCE data)"}]
[null,"Basis:","Provider"]
[null,"Published:",{"$f":"Publicationdate","v":"13th December 2019"}]
[null,"Revised:","-"]
[null,"Status:","Published"]
[null,"Contact:","Katie Tither - england.nhsdata@nhs.net"]
[]
[null,"Provider by Site Data"]
[null,"Region Code","Region Name","Organisation Code","Organisation Name","Hospital Code","Hospital Site Name","MSA Breaches1,2,3,4"]
[null,"-","-","-","England","-","-",{"$f":"SUM(H18:H93)","v":1840}]
[]
[null,"Y56","London Commissioning Region","RF4","Barking, Havering and Redbridge University Hospitals NHS Trust","RF4DG","King George Hospital - RF4DG",2]
[null,"Y56","London Commissioning Region","RF4","Barking, Havering and Redbridge University Hospitals NHS Trust","RF4QH","Queen's Hospital - RF4QH",27]
[null,"Y56","London Commissioning Region","R1H","Barts Health NHS Trust","R1HNH","Newham General Hospital - R1HNH",10]
[null,"Y56","London Commissioning Region","R1H","Barts Health NHS Trust","R1H12","The Royal London Hospital - R1H12",1]
[null,"Y56","London Commissioning Region","R1H","Barts Health NHS Trust","R1HKH","Whipps Cross University Hospital - R1HKH",18]
[null,"Y56","London Commissioning Region","RVR","Epsom and St Helier University Hospitals NHS Trust","RVR50","Epsom Hospital - RVR50",13]
[null,"Y56","London Commissioning Region","RVR","Epsom and St Helier University Hospitals NHS Trust","RVR05","St Helier Hospital - RVR05",6]
[null,"Y56","London Commissioning Region","RJ1","Guy's and St Thomas' NHS Foundation Trust","RJ121","Guy's Hospital - RJ121",4]
[null,"Y56","London Commissioning Region","RJ1","Guy's and St Thomas' NHS Foundation Trust","RJ122","St Thomas' Hospital - RJ122",22]
[null,"Y56","London Commissioning Region","RYJ","Imperial College Healthcare NHS Trust","RYJ02","Charing Cross Hospital - RYJ02",13]
[null,"Y56","London Commissioning Region","RYJ","Imperial College Healthcare NHS Trust","RYJ03","Hammersmith Hospital - RYJ03",3]
[null,"Y56","London Commissioning Region","RYJ","Imperial College Healthcare NHS Trust","RYJ01","St Mary's Hospital (HQ) - RYJ01",29]
[null,"Y56","London Commissioning Region","R1K","London North West University Healthcare NHS Trust","R1K01","Northwick Park Hospital - R1K01",25]
[null,"Y56","London Commissioning Region","RAL","Royal Free London NHS Foundation Trust","RAL26","Barnet Hospital - RAL26",36]
[null,"Y56","London Commissioning Region","RAL","Royal Free London NHS Foundation Trust","RAL01","Royal Free Hospital - RAL01",15]
[null,"Y56","London Commissioning Region","RAN","Royal National Orthopaedic Hospital NHS Trust","RAN01","The Royal National Orthopaedic Hospital (Stanmore) - RAN01",21]
[null,"Y56","London Commissioning Region","RAS","The Hillingdon Hospitals NHS Foundation Trust","RAS01","Hillingdon Hospital - RAS01",24]
[null,"Y56","London Commissioning Region","RRV","University College London Hospitals NHS Foundation Trust","RRV03","University College Hospital - RRV03",21]
[null,"Y56","London Commissioning Region","RKE","Whittington Health NHS Trust","RKEQ4","The Whittington Hospital - RKEQ4",5]
[null,"Y58","South West Commissioning Region","RBD","Dorset County Hospital NHS Foundation Trust","RBD01","Dorset County Hospital - RBD01",11]
[null,"Y58","South West Commissioning Region","RN3","Great Western Hospitals NHS Foundation Trust","RN325","The Great Western Hospital - RN325",158]
[null,"Y58","South West Commissioning Region","RNZ","Salisbury NHS Foundation Trust","RNZ02","Salisbury District Hospital - RNZ02",28]
[null,"Y58","South West Commissioning Region","RDZ","The Royal Bournemouth and Christchurch Hospitals NHS Foundation Trust","RDZ20","Royal Bournemouth General Hospital - RDZ20",4]
[null,"Y59","South East Commissioning Region","RTK","Ashford and St Peter's Hospitals NHS Foundation Trust","RTK01","St Peter's Hospital - RTK01",28]
[null,"Y59","South East Commissioning Region","RXH","Brighton and Sussex University Hospitals NHS Trust","RXH01","Royal Sussex County Hospital - RXH01",42]
[null,"Y59","South East Commissioning Region","RN7","Dartford and Gravesham NHS Trust","RN707","Darent Valley Hospital - RN707",14]
[null,"Y59","South East Commissioning Region","RVV","East Kent Hospitals University NHS Foundation Trust","RVVKC","Kent and Canterbury Hospital - RVVKC",24]
[null,"Y59","South East Commissioning Region","RVV","East Kent Hospitals University NHS Foundation Trust","RVV09","Queen Elizabeth The Queen Mother Hospital - RVV09",80]
[null,"Y59","South East Commissioning Region","RVV","East Kent Hospitals University NHS Foundation Trust","RVV01","William Harvey Hospital (Ashford) - RVV01",79]
[null,"Y59","South East Commissioning Region","RXC","East Sussex Healthcare NHS Trust","RXC01","Conquest Hospital - RXC01",64]
[null,"Y59","South East Commissioning Region","RXC","East Sussex Healthcare NHS Trust","RXC02","Eastbourne District General Hospital - RXC02",55]
[null,"Y59","South East Commissioning Region","RDU","Frimley Health NHS Foundation Trust","RDU01","Frimley Park Hospital - RDU01",15]
[null,"Y59","South East Commissioning Region","RDU","Frimley Health NHS Foundation Trust","RDU50","Wexham Park Hospital - RDU50",15]
[null,"Y59","South East Commissioning Region","R1F","Isle of Wight NHS Trust","R1F01","St Mary's Hospital - R1F01",16]
[null,"Y59","South East Commissioning Region","RPA","Medway NHS Foundation Trust","RPA02","Medway Maritime Hospital - RPA02",80]
[null,"Y59","South East Commissioning Region","RTH","Oxford University Hospitals NHS Foundation Trust","RTH02","Churchill Hospital - RTH02",18]
[null,"Y59","South East Commissioning Region","RTH","Oxford University Hospitals NHS Foundation Trust","RTH05","Horton General Hospital - RTH05",13]
[null,"Y59","South East Commissioning Region","RTH","Oxford University Hospitals NHS Foundation Trust","RTH08","John Radcliffe Hospital - RTH08",43]
[null,"Y59","South East Commissioning Region","RHW","Royal Berkshire NHS Foundation Trust","RHW01","Royal Berkshire Hospital - RHW01",125]
[null,"Y59","South East Commissioning Region","RHM","University Hospital Southampton NHS Foundation Trust","RHM01","Southampton General Hospital - RHM01",1]
[null,"Y59","South East Commissioning Region","RYR","Western Sussex Hospitals NHS Foundation Trust","RYR16","St Richard's Hospital - RYR16",34]
[null,"Y59","South East Commissioning Region","RYR","Western Sussex Hospitals NHS Foundation Trust","RYR18","Worthing Hospital - RYR18",20]
[null,"Y60","Midlands Commissioning Region","RFS","Chesterfield Royal Hospital NHS Foundation Trust","RFSDA","Chesterfield Royal Hospital - RFSDA",4]
[null,"Y60","Midlands Commissioning Region","RNQ","Kettering General Hospital NHS Foundation Trust","RNQ51","Kettering General Hospital - RNQ51",32]
[null,"Y60","Midlands Commissioning Region","RXW","Shrewsbury and Telford Hospital NHS Trust","RXWAS","Royal Shrewsbury Hospital - RXWAS",26]
[null,"Y60","Midlands Commissioning Region","RXW","Shrewsbury and Telford Hospital NHS Trust","RXWAT","The Princess Royal Hospital - RXWAT",13]
[null,"Y60","Midlands Commissioning Region","RNA","The Dudley Group NHS Foundation Trust","RNA01","Russells Hall Hospital - RNA01",26]
[null,"Y60","Midlands Commissioning Region","RRK","University Hospitals Birmingham NHS Foundation Trust","RRK98","Good Hope Hospital - RRK98",10]
[null,"Y60","Midlands Commissioning Region","RTG","University Hospitals of Derby and Burton NHS Foundation Trust","RTG02","Burton Hospital - RTG02",6]
[null,"Y60","Midlands Commissioning Region","RTG","University Hospitals of Derby and Burton NHS Foundation Trust","RTGFG","Royal Derby Hospital - RTGFG",9]
[null,"Y60","Midlands Commissioning Region","RWE","University Hospitals of Leicester NHS Trust","RWEAA","Leicester Royal Infirmary - RWEAA",3]
[null,"Y60","Midlands Commissioning Region","RWP","Worcestershire Acute Hospitals NHS Trust","RWP01","Alexandra Hospital - RWP01",15]
[null,"Y60","Midlands Commissioning Region","RWP","Worcestershire Acute Hospitals NHS Trust","RWP50","Worcestershire Royal Hospital - RWP50",53]
[null,"Y60","Midlands Commissioning Region","RLQ","Wye Valley NHS Trust","RLQ01","Hereford County Hospital - RLQ01",18]
[null,"Y61","East of England Commissioning Region","RC1","Bedford Hospital NHS Trust","RC110","Bedford Hospital South Wing - RC110",36]
[null,"Y61","East of England Commissioning Region","RDE","East Suffolk and North Essex NHS Foundation Trust","RDEE4","Colchester General Hospital - RDEE4",14]
[null,"Y61","East of England Commissioning Region","RAJ","Southend University Hospital NHS Foundation Trust","RAJ01","Southend Hospital - RAJ01",8]
[null,"Y61","East of England Commissioning Region","RQW","The Princess Alexandra Hospital NHS Trust","RQWG0","Princess Alexandra Hospital - RQWG0",24]
[null,"Y61","East of England Commissioning Region","RCX","The Queen Elizabeth Hospital, King's Lynn, NHS Foundation Trust","RCX70","The Queen Elizabeth Hospital - RCX70",18]
[null,"Y62","North West Commissioning Region","RMC","Bolton NHS Foundation Trust","RMC01","Royal Bolton Hospital - RMC01",22]
[null,"Y62","North West Commissioning Region","RJR","Countess of Chester Hospital NHS Foundation Trust","RJR05","Countess of Chester Hospital - RJR05",7]
[null,"Y62","North West Commissioning Region","RJN","East Cheshire NHS Trust","RJN71","Macclesfield District General Hospital - RJN71",31]
[null,"Y62","North West Commissioning Region","RXN","Lancashire Teaching Hospitals NHS Foundation Trust","RXN02","Royal Preston Hospital - RXN02",64]
[null,"Y62","North West Commissioning Region","R0A","Manchester University NHS Foundation Trust","R0A02","Manchester Royal Infirmary - R0A02",1]
[null,"Y62","North West Commissioning Region","RW6","Pennine Acute Hospitals NHS Trust","RW602","North Manchester General Hospital - RW602",15]
[null,"Y62","North West Commissioning Region","RW6","Pennine Acute Hospitals NHS Trust","RW603","Royal Oldham Hospital - RW603",47]
[null,"Y62","North West Commissioning Region","RT2","Pennine Care NHS Foundation Trust","RT203","Royal Oldham Hospital Mental Health Services - RT203",3]
[null,"Y62","North West Commissioning Region","RT2","Pennine Care NHS Foundation Trust","RT205","Stepping Hill Hospital Mental Health Services - RT205",3]
[null,"Y62","North West Commissioning Region","RVY","Southport and Ormskirk Hospital NHS Trust","RVY01","Southport and Formby District General Hospital - RVY01",14]
[null,"Y62","North West Commissioning Region","RBN","St Helens and Knowsley Teaching Hospitals NHS Trust","RBN01","Whiston Hospital - RBN01",2]
[null,"Y62","North West Commissioning Region","RTX","University Hospitals of Morecambe Bay NHS Foundation Trust","RTXBU","Furness General Hospital - RTXBU",11]
[null,"Y62","North West Commissioning Region","RTX","University Hospitals of Morecambe Bay NHS Foundation Trust","RTX02","Royal Lancaster Infirmary - RTX02",16]
[null,"Y62","North West Commissioning Region","RWW","Warrington and Halton Hospitals NHS Foundation Trust","RWWWH","Warrington Hospital - RWWWH",6]
[null,"Y62","North West Commissioning Region","RBL","Wirral University Teaching Hospital NHS Foundation Trust","RBL14","Arrowe Park Hospital - RBL14",17]
[null,"Y63","North East and Yorkshire Commissioning Region","RR8","Leeds Teaching Hospitals NHS Trust","RR801","Leeds General Infirmary - RR801",3]
[null,"Y63","North East and Yorkshire Commissioning Region","RTR","South Tees Hospitals NHS Foundation Trust","RTRAT","The James Cook University Hospital - RTRAT",1]
[]
[null,"Notes:"]
[null,"1. In September 2019 a revised policy, \"Delivering same-sex accommodation\" was published. Data providers were asked to ensure reporting of MSA breaches for the purposes of this collection were in line with the revised policy by January 2020. This transition period allows providers to make appropriate changes to enable them to report on this basis. As such this may impact on data quality for September - December 2019 data. Providers should all be reporting consistently and as per the updated guidance by January 2020. "]
[]
[null,"2. MSA breach data was collected by provider organisations for the first time in December 2010. Figures published during the early months of the collection from December 2010 to March 2011 should be treated with a degree of caution as providers were implementing and embedding new data collection procedures.\n\nFrom April 2011 MSA data are mandatory for all NHS providers and flat-rate fines for MSA breaches have been built into organisations’ contracts. Therefore it is expected that MSA data collection processes are now fully embedded in the NHS and that the data submitted from April 2011 onwards is of a higher quality than in previous months."]
[]
[null,"3. Only those provider sites for which one or more breaches were reported are displayed.  Those sites with zero breaches and for organisations where data was not returned are excluded."]
[]
[null,"4. A breach rate is not calculated for the site-level data, as reliable activity data for the denominator in the breach rate calculation is not available at site level."]
[]
[null,"5. Sandwell and West Birmingham Hospitals NHS Trust (RXK) did not submit data for October 2019 due to data quality issues. "]

{"sheet":"Provider - All","index":2,"n_rows":254,"n_cols":8,"rows_kept":254,"cut":false,"hidden":false,"merged":[[245,1,245,7],[255,1,256,7],[253,1,253,7],[247,1,247,7],[249,1,249,7],[251,1,251,7]]}
[]
[null,"Title:","Mixed-Sex Accommodation"]
[null,"Summary:","The total occurrences of unjustified mixing in relation to sleeping accommodation."]
[]
[null,"Period:","October 2019"]
[null,"Sources:","MSA, collected via SDCS, NHS England and NHS Improvement (MSA breaches)"]
[null,null,"Hospital Episode Statistics (HES), NHS Digital (FCE data)"]
[null,"Basis:","Provider"]
[null,"Published:","13th December 2019"]
[null,"Revised:","-"]
[null,"Status:","Published"]
[null,"Contact:","Katie Tither - england.nhsdata@nhs.net"]
[]
[null,"Provider Level Data"]
[null,"Region Code","Region Name","Organisation Code","Organisation Name","MSA Breaches1","Finished Consultant Episodes2\n(from previous year)","Breach Rate3,4"]
[null,"-","-","-","England",1840,1831029,{"$f":"F16/G16*1000","v":1.0048994308664692}]
[]
[null,"Y56","London Commissioning Region","NT2","Nuffield Health",0,3220,{"$f":"(IF(G18=\"*\",\"*\",IF(ISERROR(F18/G18*1000),\"N/A\",ROUND(F18/G18*1000,1))))","v":0}]
[null,"Y56","London Commissioning Region","NT3","Spire Healthcare",0,7070,{"$f":"(IF(G19=\"*\",\"*\",IF(ISERROR(F19/G19*1000),\"N/A\",ROUND(F19/G19*1000,1))))","v":0}]
[null,"Y56","London Commissioning Region","NV3","Circle",0,3550,0]
[null,"Y56","London Commissioning Region","R1H","Barts Health NHS Trust",29,28135,1]
[null,"Y56","London Commissioning Region","R1K","London North West University Healthcare NHS Trust",25,20540,1.2]
[null,"Y56","London Commissioning Region","RAL","Royal Free London NHS Foundation Trust",51,17625,2.9]
[null,"Y56","London Commissioning Region","RAN","Royal National Orthopaedic Hospital NHS Trust",21,1560,13.5]
[null,"Y56","London Commissioning Region","RAP","North Middlesex University Hospital NHS Trust",0,8405,0]
[null,"Y56","London Commissioning Region","RAS","The Hillingdon Hospitals NHS Foundation Trust",24,6275,3.8]
[null,"Y56","London Commissioning Region","RAT","North East London NHS Foundation Trust",0,260,{"$f":"(IF(G27=\"*\",\"*\",IF(ISERROR(F27/G27*1000),\"N/A\",ROUND(F27/G27*1000,1))))","v":0}]
[null,"Y56","London Commissioning Region","RAX","Kingston Hospital NHS Foundation Trust",0,8055,0]
[null,"Y56","London Commissioning Region","RF4","Barking, Havering and Redbridge University Hospitals NHS Trust",29,14230,2]
[null,"Y56","London Commissioning Region","RJ1","Guy's and St Thomas' NHS Foundation Trust",26,16985,1.5]
[null,"Y56","London Commissioning Region","RJ2","Lewisham and Greenwich NHS Trust",0,15065,0]
[null,"Y56","London Commissioning Region","RJ6","Croydon Health Services NHS Trust",0,7615,0]
[null,"Y56","London Commissioning Region","RJ7","St George's University Hospitals NHS Foundation Trust",0,15030,0]
[null,"Y56","London Commissioning Region","RJZ","King's College Hospital NHS Foundation Trust",0,24310,0]
[null,"Y56","London Commissioning Region","RKE","Whittington Health NHS Trust",5,4970,1]
[null,"Y56","London Commissioning Region","RKL","West London NHS Trust",0,"N/A","N/A"]
[null,"Y56","London Commissioning Region","RP4","Great Ormond Street Hospital For Children NHS Foundation Trust",0,4815,0]
[null,"Y56","London Commissioning Region","RPG","Oxleas NHS Foundation Trust",0,300,0]
[null,"Y56","London Commissioning Region","RPY","The Royal Marsden NHS Foundation Trust",0,2155,0]
[null,"Y56","London Commissioning Region","RQM","Chelsea and Westminster Hospital NHS Foundation Trust",0,14155,0]
[null,"Y56","London Commissioning Region","RQX","Homerton University Hospital NHS Foundation Trust",0,7435,0]
[null,"Y56","London Commissioning Region","RQY","South West London and St George's Mental Health NHS Trust",0,300,0]
[null,"Y56","London Commissioning Region","RRP","Barnet, Enfield and Haringey Mental Health NHS Trust",0,"N/A","N/A"]
[null,"Y56","London Commissioning Region","RRV","University College London Hospitals NHS Foundation Trust",21,16835,1.2]
[null,"Y56","London Commissioning Region","RT3","Royal Brompton & Harefield NHS Foundation Trust",0,4150,0]
[null,"Y56","London Commissioning Region","RV3","Central and North West London NHS Foundation Trust",0,465,0]
[null,"Y56","London Commissioning Region","RV5","South London and Maudsley NHS Foundation Trust",0,390,0]
[null,"Y56","London Commissioning Region","RVR","Epsom and St Helier University Hospitals NHS Trust",19,10470,1.8]
[null,"Y56","London Commissioning Region","RWK","East London NHS Foundation Trust",0,765,0]
[null,"Y56","London Commissioning Region","RY9","Hounslow and Richmond Community Healthcare NHS Trust",0,30,0]
[null,"Y56","London Commissioning Region","RYJ","Imperial College Healthcare NHS Trust",45,23030,2]
[null,"Y56","London Commissioning Region","RYX","Central London Community Healthcare NHS Trust",0,"N/A","N/A"]
[null,"Y56","London Commissioning Region","TAF","Camden and Islington NHS Foundation Trust",0,"N/A","N/A"]
[null,"Y58","South West Commissioning Region","AXG","Wiltshire Health & Care",0,90,0]
[null,"Y58","South West Commissioning Region","NLT","North Somerset Community Partnership Community Interest Company",0,"N/A","N/A"]
[null,"Y58","South West Commissioning Region","NR5","Livewell Southwest",0,140,0]
[null,"Y58","South West Commissioning Region","RA3","Weston Area Health NHS Trust",0,3715,0]
[null,"Y58","South West Commissioning Region","RA4","Yeovil District Hospital NHS Foundation Trust",0,4725,0]
[null,"Y58","South West Commissioning Region","RA7","University Hospitals Bristol NHS Foundation Trust",0,15010,0]
[null,"Y58","South West Commissioning Region","RA9","Torbay and South Devon NHS Foundation Trust",0,9620,0]
[null,"Y58","South West Commissioning Region","RBA","Taunton and Somerset NHS Foundation Trust",0,10685,0]
[null,"Y58","South West Commissioning Region","RBD","Dorset County Hospital NHS Foundation Trust",11,5715,1.9]
[null,"Y58","South West Commissioning Region","RBZ","Northern Devon Healthcare NHS Trust",0,5165,0]
[null,"Y58","South West Commissioning Region","RD1","Royal United Hospitals Bath NHS Foundation Trust",0,11385,0]
[null,"Y58","South West Commissioning Region","RD3","Poole Hospital NHS Foundation Trust",0,8640,0]
[null,"Y58","South West Commissioning Region","RDY","Dorset Healthcare University NHS Foundation Trust",0,625,0]
[null,"Y58","South West Commissioning Region","RDZ","The Royal Bournemouth and Christchurch Hospitals NHS Foundation Trust",4,11400,0.4]
[null,"Y58","South West Commissioning Region","REF","Royal Cornwall Hospitals NHS Trust",0,17060,0]
[null,"Y58","South West Commissioning Region","RH5","Somerset Partnership NHS Foundation Trust",0,370,0]
[null,"Y58","South West Commissioning Region","RH8","Royal Devon and Exeter NHS Foundation Trust",0,14235,0]
[null,"Y58","South West Commissioning Region","RJ8","Cornwall Partnership NHS Foundation Trust",0,530,0]
[null,"Y58","South West Commissioning Region","RK9","University Hospitals Plymouth NHS Trust",0,14535,0]
[null,"Y58","South West Commissioning Region","RN3","Great Western Hospitals NHS Foundation Trust",158,10320,15.3]
[null,"Y58","South West Commissioning Region","RNZ","Salisbury NHS Foundation Trust",28,6310,4.4000000000000004]
[null,"Y58","South West Commissioning Region","RTE","Gloucestershire Hospitals NHS Foundation Trust",0,17090,0]
[null,"Y58","South West Commissioning Region","RTQ","Gloucestershire Health and Care NHS Foundation Trust",0,475,0]
[null,"Y58","South West Commissioning Region","RVJ","North Bristol NHS Trust",0,15105,0]
[null,"Y58","South West Commissioning Region","RVN","Avon and Wiltshire Mental Health Partnership NHS Trust",0,340,0]
[null,"Y58","South West Commissioning Region","RWV","Devon Partnership NHS Trust",0,"N/A","N/A"]
[null,"Y59","South East Commissioning Region","ADP","Kims Hospital",0,495,0]
[null,"Y59","South East Commissioning Region","NTP","Care UK",0,6355,0]
[null,"Y59","South East Commissioning Region","NTV","CSH Surrey",0,70,{"$f":"(IF(G82=\"*\",\"*\",IF(ISERROR(F82/G82*1000),\"N/A\",ROUND(F82/G82*1000,1))))","v":0}]
[null,"Y59","South East Commissioning Region","NVM","Epsomedical Group",0,550,0]
[null,"Y59","South East Commissioning Region","R1C","Solent NHS Trust",0,80,0]
[null,"Y59","South East Commissioning Region","R1F","Isle of Wight NHS Trust",16,3455,4.5999999999999996]
[null,"Y59","South East Commissioning Region","RA2","Royal Surrey County Hospital NHS Foundation Trust",0,8370,0]
[null,"Y59","South East Commissioning Region","RDR","Sussex Community NHS Foundation Trust",0,380,0]
[null,"Y59","South East Commissioning Region","RDU","Frimley Health NHS Foundation Trust",30,22120,1.4]
[null,"Y59","South East Commissioning Region","RHM","University Hospital Southampton NHS Foundation Trust",1,18060,0.1]
[null,"Y59","South East Commissioning Region","RHU","Portsmouth Hospitals NHS Trust",0,15830,0]
[null,"Y59","South East Commissioning Region","RHW","Royal Berkshire NHS Foundation Trust",125,15800,7.9]
[null,"Y59","South East Commissioning Region","RN5","Hampshire Hospitals NHS Foundation Trust",0,11310,0]
[null,"Y59","South East Commissioning Region","RN7","Dartford and Gravesham NHS Trust",14,8810,1.6]
[null,"Y59","South East Commissioning Region","RNU","Oxford Health NHS Foundation Trust",0,310,0]
[null,"Y59","South East Commissioning Region","RPA","Medway NHS Foundation Trust",80,9545,8.4]
[null,"Y59","South East Commissioning Region","RPC","Queen Victoria Hospital NHS Foundation Trust",0,1820,0]
[null,"Y59","South East Commissioning Region","RTH","Oxford University Hospitals NHS Foundation Trust",74,20480,3.6]
[null,"Y59","South East Commissioning Region","RTK","Ashford and St Peter's Hospitals NHS Foundation Trust",28,7325,3.8]
[null,"Y59","South East Commissioning Region","RTP","Surrey and Sussex Healthcare NHS Trust",0,13390,0]
[null,"Y59","South East Commissioning Region","RVV","East Kent Hospitals University NHS Foundation Trust",183,19005,9.6]
[null,"Y59","South East Commissioning Region","RW1","Southern Health NHS Foundation Trust",0,1025,0]
[null,"Y59","South East Commissioning Region","RWF","Maidstone and Tunbridge Wells NHS Trust",0,12040,0]
[null,"Y59","South East Commissioning Region","RWX","Berkshire Healthcare NHS Foundation Trust",0,280,0]
[null,"Y59","South East Commissioning Region","RX2","Sussex Partnership NHS Foundation Trust",0,320,0]
[null,"Y59","South East Commissioning Region","RXC","East Sussex Healthcare NHS Trust",119,11070,10.7]
[null,"Y59","South East Commissioning Region","RXH","Brighton and Sussex University Hospitals NHS Trust",42,12605,3.3]
[null,"Y59","South East Commissioning Region","RXQ","Buckinghamshire Healthcare NHS Trust",0,10905,0]
[null,"Y59","South East Commissioning Region","RXX","Surrey and Borders Partnership NHS Foundation Trust",0,250,0]
[null,"Y59","South East Commissioning Region","RXY","Kent and Medway NHS and Social Care Partnership Trust",0,350,0]
[null,"Y59","South East Commissioning Region","RYR","Western Sussex Hospitals NHS Foundation Trust",54,15110,3.6]
[null,"Y59","South East Commissioning Region","RYY","Kent Community Health NHS Foundation Trust",0,210,0]
[null,"Y60","Midlands Commissioning Region","R1A","Worcestershire Health and Care NHS Trust",0,675,0]
[null,"Y60","Midlands Commissioning Region","R1D","Shropshire Community Health NHS Trust",0,270,0]
[null,"Y60","Midlands Commissioning Region","RBK","Walsall Healthcare NHS Trust",0,7480,0]
[null,"Y60","Midlands Commissioning Region","RFS","Chesterfield Royal Hospital NHS Foundation Trust",4,8930,0.4]
[null,"Y60","Midlands Commissioning Region","RHA","Nottinghamshire Healthcare NHS Foundation Trust",0,385,0]
[null,"Y60","Midlands Commissioning Region","RJC","South Warwickshire NHS Foundation Trust",0,8090,0]
[null,"Y60","Midlands Commissioning Region","RJE","University Hospitals of North Midlands NHS Trust",0,27175,0]
[null,"Y60","Midlands Commissioning Region","RK5","Sherwood Forest Hospitals NHS Foundation Trust",0,9880,0]
[null,"Y60","Midlands Commissioning Region","RKB","University Hospitals Coventry and Warwickshire NHS Trust",0,18205,0]
[null,"Y60","Midlands Commissioning Region","RL1","The Robert Jones and Agnes Hunt Orthopaedic Hospital NHS Foundation Trust",0,1345,0]
[null,"Y60","Midlands Commissioning Region","RL4","The Royal Wolverhampton NHS Trust",0,13245,0]
[null,"Y60","Midlands Commissioning Region","RLQ","Wye Valley NHS Trust",18,6835,2.6]
[null,"Y60","Midlands Commissioning Region","RLT","George Eliot Hospital NHS Trust",0,4365,0]
[null,"Y60","Midlands Commissioning Region","RLY","North Staffordshire Combined Healthcare NHS Trust",0,250,0]
[null,"Y60","Midlands Commissioning Region","RNA","The Dudley Group NHS Foundation Trust",26,10970,2.4]
[null,"Y60","Midlands Commissioning Region","RNQ","Kettering General Hospital NHS Foundation Trust",32,9790,3.3]
[null,"Y60","Midlands Commissioning Region","RNS","Northampton General Hospital NHS Trust",0,11595,0]
[null,"Y60","Midlands Commissioning Region","RP1","Northamptonshire Healthcare NHS Foundation Trust",0,280,0]
[null,"Y60","Midlands Commissioning Region","RP7","Lincolnshire Partnership NHS Foundation Trust",0,125,0]
[null,"Y60","Midlands Commissioning Region","RQ3","Birmingham Women's and Children's NHS Foundation Trust",0,6400,0]
[null,"Y60","Midlands Commissioning Region","RRE","Midlands Partnership NHS Foundation Trust",0,710,0]
[null,"Y60","Midlands Commissioning Region","RRJ","The Royal Orthopaedic Hospital NHS Foundation Trust",0,1400,0]
[null,"Y60","Midlands Commissioning Region","RRK","University Hospitals Birmingham NHS Foundation Trust",10,41830,0.2]
[null,"Y60","Midlands Commissioning Region","RT5","Leicestershire Partnership NHS Trust",0,860,0]
[null,"Y60","Midlands Commissioning Region","RTG","University Hospitals of Derby and Burton NHS Foundation Trust",15,27210,0.6]
[null,"Y60","Midlands Commissioning Region","RWD","United Lincolnshire Hospitals NHS Trust",0,15245,0]
[null,"Y60","Midlands Commissioning Region","RWE","University Hospitals of Leicester NHS Trust",3,28395,0.1]
[null,"Y60","Midlands Commissioning Region","RWP","Worcestershire Acute Hospitals NHS Trust",68,16445,4.0999999999999996]
[null,"Y60","Midlands Commissioning Region","RX1","Nottingham University Hospitals NHS Trust",0,25665,0]
[null,"Y60","Midlands Commissioning Region","RXM","Derbyshire Healthcare NHS Foundation Trust",0,160,0]
[null,"Y60","Midlands Commissioning Region","RXT","Birmingham and Solihull Mental Health NHS Foundation Trust",0,305,0]
[null,"Y60","Midlands Commissioning Region","RXW","Shrewsbury and Telford Hospital NHS Trust",39,15745,2.5]
[null,"Y60","Midlands Commissioning Region","RY5","Lincolnshire Community Health Services NHS Trust",0,60,0]
[null,"Y60","Midlands Commissioning Region","RY8","Derbyshire Community Health Services NHS Foundation Trust",0,695,{"$f":"(IF(G145=\"*\",\"*\",IF(ISERROR(F145/G145*1000),\"N/A\",ROUND(F145/G145*1000,1))))","v":0}]
[null,"Y60","Midlands Commissioning Region","RYG","Coventry and Warwickshire Partnership NHS Trust",0,265,0]
[null,"Y60","Midlands Commissioning Region","RYK","Dudley and Walsall Mental Health Partnership NHS Trust",0,"N/A","N/A"]
[null,"Y60","Midlands Commissioning Region","RYW","Birmingham Community Healthcare NHS Foundation Trust",0,445,0]
[null,"Y60","Midlands Commissioning Region","TAJ","Black Country Partnership NHS Foundation Trust",0,100,0]
[null,"Y61","East of England Commissioning Region","NQ1","Anglian Community Enterprise Community Interest Company (ACE CIC)",0,90,0]
[null,"Y61","East of England Commissioning Region","NQA","Provide",0,"N/A","N/A"]
[null,"Y61","East of England Commissioning Region","NVC","Ramsay Healthcare UK Operations Limited",0,13700,0]
[null,"Y61","East of England Commissioning Region","R1L","Essex Partnership University NHS Foundation Trust",0,525,0]
[null,"Y61","East of England Commissioning Region","RAJ","Southend University Hospital NHS Foundation Trust",8,11270,0.7]
[null,"Y61","East of England Commissioning Region","RC1","Bedford Hospital NHS Trust",36,7480,4.8]
[null,"Y61","East of England Commissioning Region","RC9","Luton and Dunstable University Hospital NHS Foundation Trust",0,12475,0]
[null,"Y61","East of England Commissioning Region","RCX","The Queen Elizabeth Hospital, King's Lynn, NHS Foundation Trust",18,8920,2]
[null,"Y61","East of England Commissioning Region","RD8","Milton Keynes University Hospital NHS Foundation Trust",0,9215,0]
[null,"Y61","East of England Commissioning Region","RDD","Basildon and Thurrock University Hospitals NHS Foundation Trust",0,12785,0]
[null,"Y61","East of England Commissioning Region","RDE","East Suffolk and North Essex NHS Foundation Trust",14,21730,0.6]
[null,"Y61","East of England Commissioning Region","RGM","Royal Papworth Hospital NHS Foundation Trust",0,2075,0]
[null,"Y61","East of England Commissioning Region","RGN","North West Anglia NHS Foundation Trust",0,14540,0]
[null,"Y61","East of England Commissioning Region","RGP","James Paget University Hospitals NHS Foundation Trust",0,7065,0]
[null,"Y61","East of England Commissioning Region","RGR","West Suffolk NHS Foundation Trust",0,8120,0]
[null,"Y61","East of England Commissioning Region","RGT","Cambridge University Hospitals NHS Foundation Trust",0,17740,0]
[null,"Y61","East of England Commissioning Region","RM1","Norfolk and Norwich University Hospitals NHS Foundation Trust",0,20465,0]
[null,"Y61","East of England Commissioning Region","RMY","Norfolk and Suffolk NHS Foundation Trust",0,315,0]
[null,"Y61","East of England Commissioning Region","RQ8","Mid Essex Hospital Services NHS Trust",0,10215,0]
[null,"Y61","East of England Commissioning Region","RQW","The Princess Alexandra Hospital NHS Trust",24,7950,3]
[null,"Y61","East of England Commissioning Region","RT1","Cambridgeshire and Peterborough NHS Foundation Trust",0,200,0]
[null,"Y61","East of England Commissioning Region","RWG","West Hertfordshire Hospitals NHS Trust",0,11230,0]
[null,"Y61","East of England Commissioning Region","RWH","East and North Hertfordshire NHS Trust",0,13165,0]
[null,"Y61","East of England Commissioning Region","RWR","Hertfordshire Partnership University NHS Foundation Trust",0,300,0]
[null,"Y61","East of England Commissioning Region","RY3","Norfolk Community Health and Care NHS Trust",0,355,0]
[null,"Y61","East of England Commissioning Region","RY4","Hertfordshire Community NHS Trust",0,200,0]
[null,"Y62","North West Commissioning Region","NDA","Virgin Care Services Ltd",0,110,0]
[null,"Y62","North West Commissioning Region","NQT","Virgin Care Ltd",0,45,0]
[null,"Y62","North West Commissioning Region","NVG","Fairfield Hospital",0,340,0]
[null,"Y62","North West Commissioning Region","R0A","Manchester University NHS Foundation Trust",1,33395,0]
[null,"Y62","North West Commissioning Region","RBL","Wirral University Teaching Hospital NHS Foundation Trust",17,13180,1.3]
[null,"Y62","North West Commissioning Region","RBN","St Helens and Knowsley Teaching Hospitals NHS Trust",2,14900,0.1]
[null,"Y62","North West Commissioning Region","RBQ","Liverpool Heart and Chest Hospital NHS Foundation Trust",0,1285,0]
[null,"Y62","North West Commissioning Region","RBS","Alder Hey Children's NHS Foundation Trust",0,4400,0]
[null,"Y62","North West Commissioning Region","RBT","Mid Cheshire Hospitals NHS Foundation Trust",0,8580,0]
[null,"Y62","North West Commissioning Region","RBV","The Christie NHS Foundation Trust",0,1980,0]
[null,"Y62","North West Commissioning Region","REM","Liverpool University Hospitals NHS Foundation Trust",0,23180,0]
[null,"Y62","North West Commissioning Region","REN","The Clatterbridge Cancer Centre NHS Foundation Trust",0,625,0]
[null,"Y62","North West Commissioning Region","REP","Liverpool Women's NHS Foundation Trust",0,3745,0]
[null,"Y62","North West Commissioning Region","RET","The Walton Centre NHS Foundation Trust",0,1050,0]
[null,"Y62","North West Commissioning Region","RJN","East Cheshire NHS Trust",31,3715,8.3000000000000007]
[null,"Y62","North West Commissioning Region","RJR","Countess of Chester Hospital NHS Foundation Trust",7,9125,0.8]
[null,"Y62","North West Commissioning Region","RM3","Salford Royal NHS Foundation Trust",0,12005,0]
[null,"Y62","North West Commissioning Region","RMC","Bolton NHS Foundation Trust",22,8595,2.6]
[null,"Y62","North West Commissioning Region","RMP","Tameside and Glossop Integrated Care NHS Foundation Trust",0,6010,0]
[null,"Y62","North West Commissioning Region","RRF","Wrightington, Wigan and Leigh NHS Foundation Trust",0,8720,0]
[null,"Y62","North West Commissioning Region","RT2","Pennine Care NHS Foundation Trust",6,"N/A","N/A"]
[null,"Y62","North West Commissioning Region","RTV","North West Boroughs Healthcare NHS Foundation Trust",0,260,0]
[null,"Y62","North West Commissioning Region","RTX","University Hospitals of Morecambe Bay NHS Foundation Trust",27,9825,2.7]
[null,"Y62","North West Commissioning Region","RVY","Southport and Ormskirk Hospital NHS Trust",14,6360,2.2000000000000002]
[null,"Y62","North West Commissioning Region","RW4","Mersey Care NHS Foundation Trust",0,295,0]
[null,"Y62","North West Commissioning Region","RW5","Lancashire Care NHS Foundation Trust",0,310,0]
[null,"Y62","North West Commissioning Region","RW6","Pennine Acute Hospitals NHS Trust",62,21880,2.8]
[null,"Y62","North West Commissioning Region","RWJ","Stockport NHS Foundation Trust",0,8755,0]
[null,"Y62","North West Commissioning Region","RWW","Warrington and Halton Hospitals NHS Foundation Trust",6,7715,0.8]
[null,"Y62","North West Commissioning Region","RXA","Cheshire and Wirral Partnership NHS Foundation Trust",0,230,0]
[null,"Y62","North West Commissioning Region","RXL","Blackpool Teaching Hospitals NHS Foundation Trust",0,11775,0]
[null,"Y62","North West Commissioning Region","RXN","Lancashire Teaching Hospitals NHS Foundation Trust",64,13820,4.5999999999999996]
[null,"Y62","North West Commissioning Region","RXR","East Lancashire Hospitals NHS Trust",0,14135,{"$f":"(IF(G208=\"*\",\"*\",IF(ISERROR(F208/G208*1000),\"N/A\",ROUND(F208/G208*1000,1))))","v":0}]
[null,"Y62","North West Commissioning Region","RXV","Greater Manchester Mental Health NHS Foundation Trust",0,"N/A","N/A"]
[null,"Y63","North East and Yorkshire Commissioning Region","NL3","Care Plus Group",0,"N/A","N/A"]
[null,"Y63","North East and Yorkshire Commissioning Region","NL8","Locala Community Partnerships CIC",0,"N/A","N/A"]
[null,"Y63","North East and Yorkshire Commissioning Region","NQL","Navigo Health and Social Care CIC",0,"N/A","N/A"]
[null,"Y63","North East and Yorkshire Commissioning Region","R0B","South Tyneside and Sunderland NHS Foundation Trust",0,15515,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RAE","Bradford Teaching Hospitals NHS Foundation Trust",0,14910,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RCB","York Teaching Hospital NHS Foundation Trust",0,18965,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RCD","Harrogate and District NHS Foundation Trust",0,5645,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RCF","Airedale NHS Foundation Trust",0,6445,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RCU","Sheffield Children's NHS Foundation Trust",0,2335,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RFF","Barnsley Hospital NHS Foundation Trust",0,7615,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RFR","The Rotherham NHS Foundation Trust",0,7000,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RGD","Leeds and York Partnership NHS Foundation Trust",0,175,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RHQ","Sheffield Teaching Hospitals NHS Foundation Trust",0,25455,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RJL","Northern Lincolnshire and Goole NHS Foundation Trust",0,10950,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RNN","North Cumbria Integrated Care NHS Foundation Trust",0,8260,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RP5","Doncaster and Bassetlaw Teaching Hospitals NHS Foundation Trust",0,13580,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RR7","Gateshead Health NHS Foundation Trust",0,7400,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RR8","Leeds Teaching Hospitals NHS Trust",3,20845,0.1]
[null,"Y63","North East and Yorkshire Commissioning Region","RTD","The Newcastle Upon Tyne Hospitals NHS Foundation Trust",0,23335,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RTF","Northumbria Healthcare NHS Foundation Trust",0,13740,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RTR","South Tees Hospitals NHS Foundation Trust",1,16240,0.1]
[null,"Y63","North East and Yorkshire Commissioning Region","RV9","Humber Teaching NHS Foundation Trust",0,225,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RVW","North Tees and Hartlepool NHS Foundation Trust",0,10835,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RWA","Hull University Teaching Hospitals NHS Trust",0,17080,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RWY","Calderdale and Huddersfield NHS Foundation Trust",0,12165,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RX3","Tees, Esk and Wear Valleys NHS Foundation Trust",0,780,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RX4","Cumbria, Northumberland, Tyne and Wear NHS Foundation Trust",0,310,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RXE","Rotherham Doncaster and South Humber NHS Foundation Trust",0,235,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RXF","Mid Yorkshire Hospitals NHS Trust",0,17330,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RXG","South West Yorkshire Partnership NHS Foundation Trust",0,260,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RXP","County Durham and Darlington NHS Foundation Trust",0,12795,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RY6","Leeds Community Healthcare NHS Trust",0,10,0]
[null,"Y63","North East and Yorkshire Commissioning Region","TAD","Bradford District Care NHS Foundation Trust",0,115,0]
[null,"Y63","North East and Yorkshire Commissioning Region","TAH","Sheffield Health & Social Care NHS Foundation Trust",0,"N/A","N/A"]
[]
[null,"Notes:"]
[null,"1. In September 2019 a revised policy, \"Delivering same-sex accommodation\" was published. Data providers were asked to ensure reporting of MSA breaches for the purposes of this collection were in line with the revised policy by January 2020. This transition period allows providers to make appropriate changes to enable them to report on this basis. As such this may impact on data quality for September - December 2019 data. Providers should all be reporting consistently and as per the updated guidance by January 2020. "]
[]
[null,"2. Finished Consultant Episode (FCE) data from Hospital Episode Statistics (HES) are used to calculate the MSA breach rate (for further details on methodology of this calculation see footnote 2). The FCE data presented here are a snapshot of latest HES data available at the time of the MSA publication for the relevant data period (due to timings of HES publication in some months this will represent \"final\" HES data, however for some months this is \"provisional\" HES data). These are used solely for the purposes of calculating an MSA breach rate to allow comparisons across providers and of change over time.\n\nFrom 2017/18 onwards, at the point of publication of MSA revisions (every 6 months), the FCE denominator is updated to reflect final HES data where available so is subject to change and may not always match the published HES timeseries (where provisional data is updated on a monthly basis).  The official and most recent timeseries of HES data is available on the NHS Digital website which will reflect any more recent updates to the provisional HES FCE data. https://digital.nhs.uk/data-and-information/publications/statistical/hospital-episode-statistics-for-admitted-patient-care-outpatient-and-accident-and-emergency-data\n\nProvider level HES FCE data is suppressed in accordance with HES disclosure control methodology.\nhttps://digital.nhs.uk/binaries/content/assets/website-assets/data-and-information/data-tools-and-services/data-services/hospital-episode-statistics/hes_analysis_guide_september_2018-v1.1.pdf\n\nHES Disclosure Control\nIn order to protect patient confidentiality '*' appears in the table above for all sub-national breakdowns, where it is possible to calculate a value between 1 and 7 from the data presented. All other sub-national data has been rounded to the nearest 5.\n\nIf the national total is between 1 and 7 (inclusive), no sub-national breakdown will be displayed. \n\nIf the national total is greater than or equal to 8;\na. Sub-national counts between 1 and 7 (inclusive) will be displayed as ’*’.\nb. Zeroes will be unchanged.\nc. All other counts will be rounded to the nearest 5."]
[]
[null,"3. The MSA breach rate is the number of MSA breaches, per 1,000 finished consultant episodes. Due to timeliness of HES data, there is one year’s lag in the denominator data, compared to the MSA breaches. For example, the breach rate for June 2019 is calculated by dividing the total MSA breaches in June 2019 (numerator) by the number of Finished Consultant Episodes in June 2018 (denominator). As such, it is only an estimation. Please see Breach Rate methodology paper for further information via: http://www.england.nhs.uk/statistics/mixed-sex-accommodation/\n\nWhen calculating rates or percentages at regional level using HES data;\n1) Where the numerator or denominator is between 1 and 7 (inclusive), no percentage or rate is calculated, and a ’*’ will be displayed.\n2) Where the numerator is zero, the percentage will be 0%.\n3) Where the unrounded numerator and denominator are greater than or equal to 8, a percentage or rate is calculated using the rounded numerator or denominator.\n4).Where no denominator data is available, no percentage or rate is calculated, and ’N/A’ will be displayed."]
[]
[null,"4. The Breach Rate for some organisations - particularly Care Trusts, Community Trusts or Mental Health Providers - may be artificially high due to their reporting of episodes of care. Activity for these organisations may be led by multi-disciplinary teams, which would not necessarily be captured as Finished Consultant Episodes and would therefore potentially be excluded from the denominator, leading to an inflated breach rate estimate."]
[]
[null,"5. Sandwell and West Birmingham Hospitals NHS Trust (RXK) did not submit data for October 2019 due to data quality issues. "]

{"sheet":"Provider - By Type","index":3,"n_rows":265,"n_cols":8,"rows_kept":265,"cut":false,"hidden":false,"merged":[[264,1,264,7],[258,1,258,7],[260,1,260,7],[262,1,262,7],[256,1,256,7]]}
[]
[null,"Title:","Mixed-Sex Accommodation"]
[null,"Summary:","The total occurrences of unjustified mixing in relation to sleeping accommodation."]
[]
[null,"Period:","October 2019"]
[null,"Sources:","MSA, collected via SDCS, NHS England and NHS Improvement (MSA breaches)"]
[null,null,"Hospital Episode Statistics (HES), NHS Digital (FCE data)"]
[null,"Basis:","Provider"]
[null,"Published:","13th December 2019"]
[null,"Revised:","-"]
[null,"Status:","Published"]
[null,"Contact:","Katie Tither - england.nhsdata@nhs.net"]
[]
[null,"Acute Provider Level Data"]
[null,"Region Code","Region Name","Organisation Code","Organisation Name","MSA Breaches1","Finished Consultant Episodes2\n(from previous year)","Breach Rate3,4"]
[null,"-","-","-","All Acute Providers",1834,1731230,{"$f":"ROUND(F16/G16*1000,1)","v":1.1000000000000001}]
[]
[null,"Y56","London Commissioning Region","RF4","Barking, Havering And Redbridge University Hospitals NHS Trust",29,14230,{"$f":"IF(G18=\"*\",\"*\",IF(ISERROR(F18/G18*1000),\"N/A\",(ROUND(F18/G18*1000,1))))","v":2}]
[null,"Y56","London Commissioning Region","R1H","Barts Health NHS Trust",29,28135,{"$f":"IF(G19=\"*\",\"*\",IF(ISERROR(F19/G19*1000),\"N/A\",(ROUND(F19/G19*1000,1))))","v":1}]
[null,"Y56","London Commissioning Region","RQM","Chelsea And Westminster Hospital NHS Foundation Trust",0,14155,0]
[null,"Y56","London Commissioning Region","RJ6","Croydon Health Services NHS Trust",0,7615,0]
[null,"Y56","London Commissioning Region","RVR","Epsom And St Helier University Hospitals NHS Trust",19,10470,1.8]
[null,"Y56","London Commissioning Region","RP4","Great Ormond Street Hospital For Children NHS Foundation Trust",0,4815,0]
[null,"Y56","London Commissioning Region","RJ1","Guy's And St Thomas' NHS Foundation Trust",26,16985,1.5]
[null,"Y56","London Commissioning Region","RQX","Homerton University Hospital NHS Foundation Trust",0,7435,0]
[null,"Y56","London Commissioning Region","RYJ","Imperial College Healthcare NHS Trust",45,23030,2]
[null,"Y56","London Commissioning Region","RJZ","King's College Hospital NHS Foundation Trust",0,24310,0]
[null,"Y56","London Commissioning Region","RAX","Kingston Hospital NHS Foundation Trust",0,8055,0]
[null,"Y56","London Commissioning Region","RJ2","Lewisham And Greenwich NHS Trust",0,15065,0]
[null,"Y56","London Commissioning Region","R1K","London North West University Healthcare NHS Trust",25,20540,1.2]
[null,"Y56","London Commissioning Region","RAP","North Middlesex University Hospital NHS Trust",0,8405,0]
[null,"Y56","London Commissioning Region","RT3","Royal Brompton & Harefield NHS Foundation Trust",0,4150,0]
[null,"Y56","London Commissioning Region","RAL","Royal Free London NHS Foundation Trust",51,17625,2.9]
[null,"Y56","London Commissioning Region","RAN","Royal National Orthopaedic Hospital NHS Trust",21,1560,13.5]
[null,"Y56","London Commissioning Region","RJ7","St George's University Hospitals NHS Foundation Trust",0,15030,0]
[null,"Y56","London Commissioning Region","RAS","The Hillingdon Hospitals NHS Foundation Trust",24,6275,3.8]
[null,"Y56","London Commissioning Region","RPY","The Royal Marsden NHS Foundation Trust",0,2155,0]
[null,"Y56","London Commissioning Region","RRV","University College London Hospitals NHS Foundation Trust",21,16835,1.2]
[null,"Y56","London Commissioning Region","RKE","Whittington Health NHS Trust",5,4970,1]
[null,"Y58","South West Commissioning Region","RBD","Dorset County Hospital NHS Foundation Trust",11,5715,1.9]
[null,"Y58","South West Commissioning Region","RTE","Gloucestershire Hospitals NHS Foundation Trust",0,17090,0]
[null,"Y58","South West Commissioning Region","RN3","Great Western Hospitals NHS Foundation Trust",158,10320,15.3]
[null,"Y58","South West Commissioning Region","RVJ","North Bristol NHS Trust",0,15105,0]
[null,"Y58","South West Commissioning Region","RBZ","Northern Devon Healthcare NHS Trust",0,5165,0]
[null,"Y58","South West Commissioning Region","RD3","Poole Hospital NHS Foundation Trust",0,8640,0]
[null,"Y58","South West Commissioning Region","REF","Royal Cornwall Hospitals NHS Trust",0,17060,0]
[null,"Y58","South West Commissioning Region","RH8","Royal Devon And Exeter NHS Foundation Trust",0,14235,0]
[null,"Y58","South West Commissioning Region","RD1","Royal United Hospitals Bath NHS Foundation Trust",0,11385,0]
[null,"Y58","South West Commissioning Region","RNZ","Salisbury NHS Foundation Trust",28,6310,4.4000000000000004]
[null,"Y58","South West Commissioning Region","RBA","Taunton And Somerset NHS Foundation Trust",0,10685,0]
[null,"Y58","South West Commissioning Region","RDZ","The Royal Bournemouth And Christchurch Hospitals NHS Foundation Trust",4,11400,0.4]
[null,"Y58","South West Commissioning Region","RA9","Torbay And South Devon NHS Foundation Trust",0,9620,0]
[null,"Y58","South West Commissioning Region","RA7","University Hospitals Bristol NHS Foundation Trust",0,15010,0]
[null,"Y58","South West Commissioning Region","RK9","University Hospitals Plymouth NHS Trust",0,14535,0]
[null,"Y58","South West Commissioning Region","RA3","Weston Area Health NHS Trust",0,3715,0]
[null,"Y58","South West Commissioning Region","RA4","Yeovil District Hospital NHS Foundation Trust",0,4725,0]
[null,"Y59","South East Commissioning Region","RTK","Ashford And St Peter's Hospitals NHS Foundation Trust",28,7325,3.8]
[null,"Y59","South East Commissioning Region","RXH","Brighton And Sussex University Hospitals NHS Trust",42,12605,3.3]
[null,"Y59","South East Commissioning Region","RXQ","Buckinghamshire Healthcare NHS Trust",0,10905,0]
[null,"Y59","South East Commissioning Region","RN7","Dartford And Gravesham NHS Trust",14,8810,1.6]
[null,"Y59","South East Commissioning Region","RVV","East Kent Hospitals University NHS Foundation Trust",183,19005,9.6]
[null,"Y59","South East Commissioning Region","RXC","East Sussex Healthcare NHS Trust",119,11070,10.7]
[null,"Y59","South East Commissioning Region","RDU","Frimley Health NHS Foundation Trust",30,22120,1.4]
[null,"Y59","South East Commissioning Region","RN5","Hampshire Hospitals NHS Foundation Trust",0,11310,0]
[null,"Y59","South East Commissioning Region","R1F","Isle Of Wight NHS Trust",16,3455,4.5999999999999996]
[null,"Y59","South East Commissioning Region","RWF","Maidstone And Tunbridge Wells NHS Trust",0,12040,0]
[null,"Y59","South East Commissioning Region","RPA","Medway NHS Foundation Trust",80,9545,8.4]
[null,"Y59","South East Commissioning Region","RTH","Oxford University Hospitals NHS Foundation Trust",74,20480,3.6]
[null,"Y59","South East Commissioning Region","RHU","Portsmouth Hospitals NHS Trust",0,15830,0]
[null,"Y59","South East Commissioning Region","RPC","Queen Victoria Hospital NHS Foundation Trust",0,1820,0]
[null,"Y59","South East Commissioning Region","RHW","Royal Berkshire NHS Foundation Trust",125,15800,7.9]
[null,"Y59","South East Commissioning Region","RA2","Royal Surrey County Hospital NHS Foundation Trust",0,8370,0]
[null,"Y59","South East Commissioning Region","RTP","Surrey And Sussex Healthcare NHS Trust",0,13390,0]
[null,"Y59","South East Commissioning Region","RHM","University Hospital Southampton NHS Foundation Trust",1,18060,0.1]
[null,"Y59","South East Commissioning Region","RYR","Western Sussex Hospitals NHS Foundation Trust",54,15110,3.6]
[null,"Y60","Midlands Commissioning Region","RQ3","Birmingham Women's And Children's NHS Foundation Trust",0,6400,0]
[null,"Y60","Midlands Commissioning Region","RFS","Chesterfield Royal Hospital NHS Foundation Trust",4,8930,0.4]
[null,"Y60","Midlands Commissioning Region","RLT","George Eliot Hospital NHS Trust",0,4365,0]
[null,"Y60","Midlands Commissioning Region","RNQ","Kettering General Hospital NHS Foundation Trust",32,9790,3.3]
[null,"Y60","Midlands Commissioning Region","RNS","Northampton General Hospital NHS Trust",0,11595,0]
[null,"Y60","Midlands Commissioning Region","RX1","Nottingham University Hospitals NHS Trust",0,25665,0]
[null,"Y60","Midlands Commissioning Region","RK5","Sherwood Forest Hospitals NHS Foundation Trust",0,9880,{"$f":"IF(G82=\"*\",\"*\",IF(ISERROR(F82/G82*1000),\"N/A\",(ROUND(F82/G82*1000,1))))","v":0}]
[null,"Y60","Midlands Commissioning Region","RXW","Shrewsbury And Telford Hospital NHS Trust",39,15745,2.5]
[null,"Y60","Midlands Commissioning Region","RJC","South Warwickshire NHS Foundation Trust",0,8090,0]
[null,"Y60","Midlands Commissioning Region","RNA","The Dudley Group NHS Foundation Trust",26,10970,2.4]
[null,"Y60","Midlands Commissioning Region","RL1","The Robert Jones And Agnes Hunt Orthopaedic Hospital NHS Foundation Trust",0,1345,0]
[null,"Y60","Midlands Commissioning Region","RRJ","The Royal Orthopaedic Hospital NHS Foundation Trust",0,1400,0]
[null,"Y60","Midlands Commissioning Region","RL4","The Royal Wolverhampton NHS Trust",0,13245,0]
[null,"Y60","Midlands Commissioning Region","RWD","United Lincolnshire Hospitals NHS Trust",0,15245,0]
[null,"Y60","Midlands Commissioning Region","RRK","University Hospitals Birmingham NHS Foundation Trust",10,41830,0.2]
[null,"Y60","Midlands Commissioning Region","RKB","University Hospitals Coventry And Warwickshire NHS Trust",0,18205,0]
[null,"Y60","Midlands Commissioning Region","RTG","University Hospitals Of Derby And Burton NHS Foundation Trust",15,27210,0.6]
[null,"Y60","Midlands Commissioning Region","RWE","University Hospitals Of Leicester NHS Trust",3,28395,0.1]
[null,"Y60","Midlands Commissioning Region","RJE","University Hospitals Of North Midlands NHS Trust",0,27175,0]
[null,"Y60","Midlands Commissioning Region","RBK","Walsall Healthcare NHS Trust",0,7480,0]
[null,"Y60","Midlands Commissioning Region","RWP","Worcestershire Acute Hospitals NHS Trust",68,16445,4.0999999999999996]
[null,"Y60","Midlands Commissioning Region","RLQ","Wye Valley NHS Trust",18,6835,2.6]
[null,"Y61","East of England Commissioning Region","RDD","Basildon And Thurrock University Hospitals NHS Foundation Trust",0,12785,0]
[null,"Y61","East of England Commissioning Region","RC1","Bedford Hospital NHS Trust",36,7480,4.8]
[null,"Y61","East of England Commissioning Region","RGT","Cambridge University Hospitals NHS Foundation Trust",0,17740,0]
[null,"Y61","East of England Commissioning Region","RWH","East And North Hertfordshire NHS Trust",0,13165,0]
[null,"Y61","East of England Commissioning Region","RDE","East Suffolk And North Essex NHS Foundation Trust",14,21730,0.6]
[null,"Y61","East of England Commissioning Region","RGP","James Paget University Hospitals NHS Foundation Trust",0,7065,0]
[null,"Y61","East of England Commissioning Region","RC9","Luton And Dunstable University Hospital NHS Foundation Trust",0,12475,0]
[null,"Y61","East of England Commissioning Region","RQ8","Mid Essex Hospital Services NHS Trust",0,10215,0]
[null,"Y61","East of England Commissioning Region","RD8","Milton Keynes University Hospital NHS Foundation Trust",0,9215,0]
[null,"Y61","East of England Commissioning Region","RM1","Norfolk And Norwich University Hospitals NHS Foundation Trust",0,20465,0]
[null,"Y61","East of England Commissioning Region","RGN","North West Anglia NHS Foundation Trust",0,14540,0]
[null,"Y61","East of England Commissioning Region","RGM","Royal Papworth Hospital NHS Foundation Trust",0,2075,0]
[null,"Y61","East of England Commissioning Region","RAJ","Southend University Hospital NHS Foundation Trust",8,11270,0.7]
[null,"Y61","East of England Commissioning Region","RQW","The Princess Alexandra Hospital NHS Trust",24,7950,3]
[null,"Y61","East of England Commissioning Region","RCX","The Queen Elizabeth Hospital, King's Lynn, NHS Foundation Trust",18,8920,2]
[null,"Y61","East of England Commissioning Region","RWG","West Hertfordshire Hospitals NHS Trust",0,11230,0]
[null,"Y61","East of England Commissioning Region","RGR","West Suffolk NHS Foundation Trust",0,8120,0]
[null,"Y62","North West Commissioning Region","REM","Liverpool University Hospitals NHS Foundation Trust",0,23180,0]
[null,"Y62","North West Commissioning Region","RBS","Alder Hey Children's NHS Foundation Trust",0,4400,0]
[null,"Y62","North West Commissioning Region","RXL","Blackpool Teaching Hospitals NHS Foundation Trust",0,11775,0]
[null,"Y62","North West Commissioning Region","RMC","Bolton NHS Foundation Trust",22,8595,2.6]
[null,"Y62","North West Commissioning Region","RJR","Countess Of Chester Hospital NHS Foundation Trust",7,9125,0.8]
[null,"Y62","North West Commissioning Region","RJN","East Cheshire NHS Trust",31,3715,8.3000000000000007]
[null,"Y62","North West Commissioning Region","RXR","East Lancashire Hospitals NHS Trust",0,14135,0]
[null,"Y62","North West Commissioning Region","RXN","Lancashire Teaching Hospitals NHS Foundation Trust",64,13820,4.5999999999999996]
[null,"Y62","North West Commissioning Region","RBQ","Liverpool Heart And Chest Hospital NHS Foundation Trust",0,1285,0]
[null,"Y62","North West Commissioning Region","REP","Liverpool Women's NHS Foundation Trust",0,3745,0]
[null,"Y62","North West Commissioning Region","R0A","Manchester University NHS Foundation Trust",1,33395,0]
[null,"Y62","North West Commissioning Region","RBT","Mid Cheshire Hospitals NHS Foundation Trust",0,8580,0]
[null,"Y62","North West Commissioning Region","RW6","Pennine Acute Hospitals NHS Trust",62,21880,2.8]
[null,"Y62","North West Commissioning Region","RM3","Salford Royal NHS Foundation Trust",0,12005,0]
[null,"Y62","North West Commissioning Region","RVY","Southport And Ormskirk Hospital NHS Trust",14,6360,2.2000000000000002]
[null,"Y62","North West Commissioning Region","RBN","St Helens And Knowsley Teaching Hospitals NHS Trust",2,14900,0.1]
[null,"Y62","North West Commissioning Region","RWJ","Stockport NHS Foundation Trust",0,8755,0]
[null,"Y62","North West Commissioning Region","RMP","Tameside And Glossop Integrated Care NHS Foundation Trust",0,6010,0]
[null,"Y62","North West Commissioning Region","RBV","The Christie NHS Foundation Trust",0,1980,0]
[null,"Y62","North West Commissioning Region","REN","The Clatterbridge Cancer Centre NHS Foundation Trust",0,625,0]
[null,"Y62","North West Commissioning Region","RET","The Walton Centre NHS Foundation Trust",0,1050,0]
[null,"Y62","North West Commissioning Region","RTX","University Hospitals Of Morecambe Bay NHS Foundation Trust",27,9825,2.7]
[null,"Y62","North West Commissioning Region","RWW","Warrington And Halton Hospitals NHS Foundation Trust",6,7715,0.8]
[null,"Y62","North West Commissioning Region","RBL","Wirral University Teaching Hospital NHS Foundation Trust",17,13180,1.3]
[null,"Y62","North West Commissioning Region","RRF","Wrightington, Wigan And Leigh NHS Foundation Trust",0,8720,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RCF","Airedale NHS Foundation Trust",0,6445,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RFF","Barnsley Hospital NHS Foundation Trust",0,7615,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RAE","Bradford Teaching Hospitals NHS Foundation Trust",0,14910,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RWY","Calderdale And Huddersfield NHS Foundation Trust",0,12165,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RXP","County Durham And Darlington NHS Foundation Trust",0,12795,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RP5","Doncaster And Bassetlaw Teaching Hospitals NHS Foundation Trust",0,13580,{"$f":"IF(G145=\"*\",\"*\",IF(ISERROR(F145/G145*1000),\"N/A\",(ROUND(F145/G145*1000,1))))","v":0}]
[null,"Y63","North East and Yorkshire Commissioning Region","RR7","Gateshead Health NHS Foundation Trust",0,7400,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RCD","Harrogate And District NHS Foundation Trust",0,5645,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RWA","Hull University Teaching Hospitals NHS Trust",0,17080,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RR8","Leeds Teaching Hospitals NHS Trust",3,20845,0.1]
[null,"Y63","North East and Yorkshire Commissioning Region","RXF","Mid Yorkshire Hospitals NHS Trust",0,17330,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RNN","North Cumbria Integrated Care NHS Foundation Trust",0,8260,{"$f":"IF(G151=\"*\",\"*\",IF(ISERROR(F151/G151*1000),\"N/A\",(ROUND(F151/G151*1000,1))))","v":0}]
[null,"Y63","North East and Yorkshire Commissioning Region","RVW","North Tees And Hartlepool NHS Foundation Trust",0,10835,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RJL","Northern Lincolnshire And Goole NHS Foundation Trust",0,10950,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RTF","Northumbria Healthcare NHS Foundation Trust",0,13740,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RCU","Sheffield Children's NHS Foundation Trust",0,2335,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RHQ","Sheffield Teaching Hospitals NHS Foundation Trust",0,25455,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RTR","South Tees Hospitals NHS Foundation Trust",1,16240,0.1]
[null,"Y63","North East and Yorkshire Commissioning Region","R0B","South Tyneside And Sunderland NHS Foundation Trust",0,15515,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RTD","The Newcastle Upon Tyne Hospitals NHS Foundation Trust",0,23335,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RFR","The Rotherham NHS Foundation Trust",0,7000,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RCB","York Teaching Hospital NHS Foundation Trust",0,18965,0]
[]
[]
[null,"Care Trust, Community Trust and Mental Health Provider Level Data"]
[null,"Region Code","Region Name","Organisation Code","Organisation Name","MSA Breaches1","Finished Consultant Episodes2\n(from previous year)","Breach Rate3,4"]
[null,null,null,"-","All Care Trusts, Community Trusts and Mental Health Providers",6,26990,{"$f":"(F166/G166)*1000","v":0.22230455724342349}]
[]
[null,"Y56","London Commissioning Region","RRP","Barnet, Enfield And Haringey Mental Health NHS Trust",0,"N/A",{"$f":"IF(G168=\"*\",\"*\",IF(ISERROR(F168/G168*1000),\"N/A\",(ROUND(F168/G168*1000,1))))","v":"N/A"}]
[null,"Y56","London Commissioning Region","TAF","Camden And Islington NHS Foundation Trust",0,"N/A",{"$f":"IF(G169=\"*\",\"*\",IF(ISERROR(F169/G169*1000),\"N/A\",(ROUND(F169/G169*1000,1))))","v":"N/A"}]
[null,"Y56","London Commissioning Region","RV3","Central And North West London NHS Foundation Trust",0,465,0]
[null,"Y56","London Commissioning Region","RYX","Central London Community Healthcare NHS Trust",0,"N/A","N/A"]
[null,"Y56","London Commissioning Region","RWK","East London NHS Foundation Trust",0,765,0]
[null,"Y56","London Commissioning Region","RY9","Hounslow And Richmond Community Healthcare NHS Trust",0,30,0]
[null,"Y56","London Commissioning Region","RAT","North East London NHS Foundation Trust",0,260,0]
[null,"Y56","London Commissioning Region","RPG","Oxleas NHS Foundation Trust",0,300,0]
[null,"Y56","London Commissioning Region","RV5","South London And Maudsley NHS Foundation Trust",0,390,0]
[null,"Y56","London Commissioning Region","RQY","South West London And St George's Mental Health NHS Trust",0,300,0]
[null,"Y56","London Commissioning Region","RKL","West London NHS Trust",0,"N/A","N/A"]
[null,"Y58","South West Commissioning Region","RTQ","Gloucestershire Health And Care NHS Foundation Trust",0,475,0]
[null,"Y58","South West Commissioning Region","RVN","Avon And Wiltshire Mental Health Partnership NHS Trust",0,340,0]
[null,"Y58","South West Commissioning Region","RJ8","Cornwall Partnership NHS Foundation Trust",0,530,0]
[null,"Y58","South West Commissioning Region","RWV","Devon Partnership NHS Trust",0,"N/A","N/A"]
[null,"Y58","South West Commissioning Region","RDY","Dorset Healthcare University NHS Foundation Trust",0,625,0]
[null,"Y58","South West Commissioning Region","RH5","Somerset Partnership NHS Foundation Trust",0,370,0]
[null,"Y59","South East Commissioning Region","RWX","Berkshire Healthcare NHS Foundation Trust",0,280,0]
[null,"Y59","South East Commissioning Region","RXY","Kent And Medway NHS And Social Care Partnership Trust",0,350,0]
[null,"Y59","South East Commissioning Region","RYY","Kent Community Health NHS Foundation Trust",0,210,0]
[null,"Y59","South East Commissioning Region","RNU","Oxford Health NHS Foundation Trust",0,310,0]
[null,"Y59","South East Commissioning Region","R1C","Solent NHS Trust",0,80,0]
[null,"Y59","South East Commissioning Region","RW1","Southern Health NHS Foundation Trust",0,1025,0]
[null,"Y59","South East Commissioning Region","RXX","Surrey And Borders Partnership NHS Foundation Trust",0,250,0]
[null,"Y59","South East Commissioning Region","RDR","Sussex Community NHS Foundation Trust",0,380,0]
[null,"Y59","South East Commissioning Region","RX2","Sussex Partnership NHS Foundation Trust",0,320,0]
[null,"Y60","Midlands Commissioning Region","RXT","Birmingham And Solihull Mental Health NHS Foundation Trust",0,305,0]
[null,"Y60","Midlands Commissioning Region","RYW","Birmingham Community Healthcare NHS Foundation Trust",0,445,0]
[null,"Y60","Midlands Commissioning Region","TAJ","Black Country Partnership NHS Foundation Trust",0,100,0]
[null,"Y60","Midlands Commissioning Region","RYG","Coventry And Warwickshire Partnership NHS Trust",0,265,0]
[null,"Y60","Midlands Commissioning Region","RY8","Derbyshire Community Health Services NHS Foundation Trust",0,695,0]
[null,"Y60","Midlands Commissioning Region","RXM","Derbyshire Healthcare NHS Foundation Trust",0,160,0]
[null,"Y60","Midlands Commissioning Region","RYK","Dudley And Walsall Mental Health Partnership NHS Trust",0,"N/A","N/A"]
[null,"Y60","Midlands Commissioning Region","RT5","Leicestershire Partnership NHS Trust",0,860,0]
[null,"Y60","Midlands Commissioning Region","RY5","Lincolnshire Community Health Services NHS Trust",0,60,0]
[null,"Y60","Midlands Commissioning Region","RP7","Lincolnshire Partnership NHS Foundation Trust",0,125,0]
[null,"Y60","Midlands Commissioning Region","RRE","Midlands Partnership NHS Foundation Trust",0,710,0]
[null,"Y60","Midlands Commissioning Region","RLY","North Staffordshire Combined Healthcare NHS Trust",0,250,0]
[null,"Y60","Midlands Commissioning Region","RP1","Northamptonshire Healthcare NHS Foundation Trust",0,280,0]
[null,"Y60","Midlands Commissioning Region","RHA","Nottinghamshire Healthcare NHS Foundation Trust",0,385,0]
[null,"Y60","Midlands Commissioning Region","R1D","Shropshire Community Health NHS Trust",0,270,{"$f":"IF(G208=\"*\",\"*\",IF(ISERROR(F208/G208*1000),\"N/A\",(ROUND(F208/G208*1000,1))))","v":0}]
[null,"Y60","Midlands Commissioning Region","R1A","Worcestershire Health And Care NHS Trust",0,675,0]
[null,"Y61","East of England Commissioning Region","RT1","Cambridgeshire And Peterborough NHS Foundation Trust",0,200,0]
[null,"Y61","East of England Commissioning Region","R1L","Essex Partnership University NHS Foundation Trust",0,525,0]
[null,"Y61","East of England Commissioning Region","RY4","Hertfordshire Community NHS Trust",0,200,0]
[null,"Y61","East of England Commissioning Region","RWR","Hertfordshire Partnership University NHS Foundation Trust",0,300,0]
[null,"Y61","East of England Commissioning Region","RMY","Norfolk And Suffolk NHS Foundation Trust",0,315,0]
[null,"Y61","East of England Commissioning Region","RY3","Norfolk Community Health And Care NHS Trust",0,355,0]
[null,"Y62","North West Commissioning Region","RXA","Cheshire And Wirral Partnership NHS Foundation Trust",0,230,0]
[null,"Y62","North West Commissioning Region","RXV","Greater Manchester Mental Health NHS Foundation Trust",0,"N/A","N/A"]
[null,"Y62","North West Commissioning Region","RW5","Lancashire Care NHS Foundation Trust",0,310,0]
[null,"Y62","North West Commissioning Region","RW4","Mersey Care NHS Foundation Trust",0,295,0]
[null,"Y62","North West Commissioning Region","RTV","North West Boroughs Healthcare NHS Foundation Trust",0,260,0]
[null,"Y62","North West Commissioning Region","RT2","Pennine Care NHS Foundation Trust",6,"N/A","N/A"]
[null,"Y63","North East and Yorkshire Commissioning Region","TAD","Bradford District Care NHS Foundation Trust",0,115,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RV9","Humber Teaching NHS Foundation Trust",0,225,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RGD","Leeds And York Partnership NHS Foundation Trust",0,175,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RY6","Leeds Community Healthcare NHS Trust",0,10,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RX4","Cumbria, Northumberland, Tyne And Wear NHS Foundation Trust",0,310,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RXE","Rotherham Doncaster And South Humber NHS Foundation Trust",0,235,0]
[null,"Y63","North East and Yorkshire Commissioning Region","TAH","Sheffield Health & Social Care NHS Foundation Trust",0,"N/A","N/A"]
[null,"Y63","North East and Yorkshire Commissioning Region","RXG","South West Yorkshire Partnership NHS Foundation Trust",0,260,0]
[null,"Y63","North East and Yorkshire Commissioning Region","RX3","Tees, Esk And Wear Valleys NHS Foundation Trust",0,780,0]
[]
[null,"Independent Sector Level Data"]
[null,"Region Code","Region Name","Organisation Code","Organisation Name","MSA Breaches1","Finished Consultant Episodes2\n(from previous year)","Breach Rate3,4"]
[null,null,null,"-","All Independent Providers",0,35825,{"$f":"F234/G234*1000","v":0}]
[]
[null,"Y56","London Commissioning Region","NV3","Circle",0,3550,{"$f":"IF(G236=\"*\",\"*\",IF(ISERROR(F236/G236*1000),\"N/A\",(ROUND(F236/G236*1000,1))))","v":0}]
[null,"Y56","London Commissioning Region","NT2","Nuffield Health",0,3220,{"$f":"IF(G237=\"*\",\"*\",IF(ISERROR(F237/G237*1000),\"N/A\",(ROUND(F237/G237*1000,1))))","v":0}]
[null,"Y56","London Commissioning Region","NT3","Spire Healthcare",0,7070,0]
[null,"Y58","South West Commissioning Region","NR5","Livewell Southwest",0,140,0]
[null,"Y58","South West Commissioning Region","NLT","North Somerset Community Partnership Community Interest Company",0,"N/A","N/A"]
[null,"Y58","South West Commissioning Region","AXG","Wiltshire Health & Care",0,90,0]
[null,"Y59","South East Commissioning Region","NTP","Care UK",0,6355,0]
[null,"Y59","South East Commissioning Region","NTV","CSH Surrey",0,70,0]
[null,"Y59","South East Commissioning Region","NVM","Epsomedical Group",0,550,0]
[null,"Y59","South East Commissioning Region","ADP","Kims Hospital",0,495,0]
[null,"Y61","East of England Commissioning Region","NQ1","Anglian Community Enterprise Community Interest Company (ACE CIC)",0,90,0]
[null,"Y61","East of England Commissioning Region","NQA","Provide",0,"N/A","N/A"]
[null,"Y61","East of England Commissioning Region","NVC","Ramsay Healthcare UK Operations Limited",0,13700,0]
[null,"Y62","North West Commissioning Region","NDA","Virgin Care Services Ltd",0,110,0]
[null,"Y62","North West Commissioning Region","NVG","Fairfield Hospital",0,340,0]
[null,"Y62","North West Commissioning Region","NQT","Virgin Care Ltd",0,45,0]
[null,"Y63","North East and Yorkshire Commissioning Region","NL3","Care Plus Group",0,"N/A","N/A"]
[null,"Y63","North East and Yorkshire Commissioning Region","NL8","Locala Community Partnerships CIC",0,"N/A","N/A"]
[null,"Y63","North East and Yorkshire Commissioning Region","NQL","Navigo Health And Social Care CIC",0,"N/A","N/A"]
[]
[null,"Notes:"]
[null,"1. In September 2019 a revised policy, \"Delivering same-sex accommodation\" was published. Data providers were asked to ensure reporting of MSA breaches for the purposes of this collection were in line with the revised policy by January 2020. This transition period allows providers to make appropriate changes to enable them to report on this basis. As such this may impact on data quality for September - December 2019 data. Providers should all be reporting consistently and as per the updated guidance by January 2020. "]
[]
[null,"2. Finished Consultant Episode (FCE) data from Hospital Episode Statistics (HES) are used to calculate the MSA breach rate (for further details on methodology of this calculation see footnote 2). The FCE data presented here are a snapshot of latest HES data available at the time of the MSA publication for the relevant data period (due to timings of HES publication in some months this will represent \"final\" HES data, however for some months this is \"provisional\" HES data). These are used solely for the purposes of calculating an MSA breach rate to allow comparisons across providers and of change over time.\n\nFrom 2017/18 onwards, at the point of publication of MSA revisions (every 6 months), the FCE denominator is updated to reflect final HES data where available so is subject to change and may not always match the published HES timeseries (where provisional data is updated on a monthly basis).  The official and most recent timeseries of HES data is available on the NHS Digital website which will reflect any more recent updates to the provisional HES FCE data. https://digital.nhs.uk/data-and-information/publications/statistical/hospital-episode-statistics-for-admitted-patient-care-outpatient-and-accident-and-emergency-data\n\nProvider level HES FCE data is suppressed in accordance with HES disclosure control methodology.\nhttps://digital.nhs.uk/binaries/content/assets/website-assets/data-and-information/data-tools-and-services/data-services/hospital-episode-statistics/hes_analysis_guide_september_2018-v1.1.pdf\n\nHES Disclosure Control\nIn order to protect patient confidentiality '*' appears in the table above for all sub-national breakdowns, where it is possible to calculate a value between 1 and 7 from the data presented. All other sub-national data has been rounded to the nearest 5.\n\nIf the national total is between 1 and 7 (inclusive), no sub-national breakdown will be displayed. \n\nIf the national total is greater than or equal to 8;\na. Sub-national counts between 1 and 7 (inclusive) will be displayed as ’*’.\nb. Zeroes will be unchanged.\nc. All other counts will be rounded to the nearest 5."]
[]
[null,"3. The MSA breach rate is the number of MSA breaches, per 1,000 finished consultant episodes. Due to timeliness of HES data, there is one year’s lag in the denominator data, compared to the MSA breaches. For example, the breach rate for June 2019 is calculated by dividing the total MSA breaches in June 2019 (numerator) by the number of Finished Consultant Episodes in June 2018 (denominator). As such, it is only an estimation. Please see Breach Rate methodology paper for further information via: http://www.england.nhs.uk/statistics/mixed-sex-accommodation/\n\nWhen calculating rates or percentages at regional level using HES data;\n1) Where the numerator or denominator is between 1 and 7 (inclusive), no percentage or rate is calculated, and a ’*’ will be displayed.\n2) Where the numerator is zero, the percentage will be 0%.\n3) Where the unrounded numerator and denominator are greater than or equal to 8, a percentage or rate is calculated using the rounded numerator or denominator.\n4).Where no denominator data is available, no percentage or rate is calculated, and ’N/A’ will be displayed."]
[]
[null,"4. The Breach Rate for some organisations - particularly Care Trusts, Community Trusts or Mental Health Providers - may be artificially high due to their reporting of episodes of care. Activity for these organisations may be led by multi-disciplinary teams, which would not necessarily be captured as Finished Consultant Episodes and would therefore potentially be excluded from the denominator, leading to an inflated breach rate estimate."]
[]
[null,"5. Sandwell and West Birmingham Hospitals NHS Trust (RXK) did not submit data for October 2019 due to data quality issues. "]

{"sheet":"Commissioner","index":4,"n_rows":219,"n_cols":8,"rows_kept":219,"cut":false,"hidden":false,"merged":[[220,1,221,7],[214,1,214,7],[216,1,216,7],[218,1,218,7],[212,1,212,7]]}
[]
[null,"Title:","Mixed-Sex Accommodation"]
[null,"Summary:","The total occurrences of unjustified mixing in relation to sleeping accommodation."]
[]
[null,"Period:",{"$f":"Publicationmonth","v":"October 2019"}]
[null,"Sources:",{"$f":"'National & Regional Team'!C6","v":"MSA, collected via SDCS, NHS England and NHS Improvement (MSA breaches)"}]
[null,null,{"$f":"'National & Regional Team'!C7","v":"Hospital Episode Statistics (HES), NHS Digital (FCE data)"}]
[null,"Basis:","Commissioner"]
[null,"Published:",{"$f":"Publicationdate","v":"13th December 2019"}]
[null,"Revised:","-"]
[null,"Status:","Published"]
[null,"Contact:","Katie Tither - england.nhsdata@nhs.net"]
[]
[null,"Commissioner Level Data"]
[null,"Region Code","Region Name","Organisation Code","Organisation Name","MSA Breaches1","Finished Consultant Episodes2\n(from previous year)","Breach Rate3"]
[null,"-","-","-","England",1840,1831029,{"$f":"ROUND(F16/G16*1000,1)","v":1}]
[]
[null,"-","-","X24","NHS England",8,"N/A",{"$f":"IF(G18=\"*\",\"*\",IF(ISERROR(F18/G18*1000),\"N/A\",(ROUND(F18/G18*1000,1))))","v":"N/A"}]
[null,null,null,"NONC","Non English Commissioner",7,"N/A",{"$f":"IF(G19=\"*\",\"*\",IF(ISERROR(F19/G19*1000),\"N/A\",(ROUND(F19/G19*1000,1))))","v":"N/A"}]
[null,"Y56","London Commissioning Region","07L","NHS Barking And Dagenham CCG",6,5285,{"$f":"IF(G20=\"*\",\"*\",IF(ISERROR(F20/G20*1000),\"N/A\",(ROUND(F20/G20*1000,1))))","v":1.1000000000000001}]
[null,"Y56","London Commissioning Region","07M","NHS Barnet CCG",23,10040,2.2999999999999998]
[null,"Y56","London Commissioning Region","07N","NHS Bexley CCG",7,7610,0.9]
[null,"Y56","London Commissioning Region","07P","NHS Brent CCG",13,11455,1.1000000000000001]
[null,"Y56","London Commissioning Region","07Q","NHS Bromley CCG",2,10445,0.2]
[null,"Y56","London Commissioning Region","07R","NHS Camden CCG",15,6075,2.5]
[null,"Y56","London Commissioning Region","09A","NHS Central London (Westminster) CCG",5,4660,1.1000000000000001]
[null,"Y56","London Commissioning Region","07T","NHS City And Hackney CCG",1,8085,0.1]
[null,"Y56","London Commissioning Region","07V","NHS Croydon CCG",1,11145,0.1]
[null,"Y56","London Commissioning Region","07W","NHS Ealing CCG",15,11915,1.3]
[null,"Y56","London Commissioning Region","07X","NHS Enfield CCG",5,9210,0.5]
[null,"Y56","London Commissioning Region","08A","NHS Greenwich CCG",2,8730,0.2]
[null,"Y56","London Commissioning Region","08C","NHS Hammersmith And Fulham CCG",4,5950,0.7]
[null,"Y56","London Commissioning Region","08D","NHS Haringey CCG",7,7885,0.9]
[null,"Y56","London Commissioning Region","08E","NHS Harrow CCG",8,8865,0.9]
[null,"Y56","London Commissioning Region","08F","NHS Havering CCG",16,7860,2]
[null,"Y56","London Commissioning Region","08G","NHS Hillingdon CCG",18,8420,2.1]
[null,"Y56","London Commissioning Region","07Y","NHS Hounslow CCG",8,7655,1]
[null,"Y56","London Commissioning Region","08H","NHS Islington CCG",5,6285,0.8]
[null,"Y56","London Commissioning Region","08J","NHS Kingston CCG",0,4910,0]
[null,"Y56","London Commissioning Region","08K","NHS Lambeth CCG",3,9450,0.3]
[null,"Y56","London Commissioning Region","08L","NHS Lewisham CCG",7,8190,0.9]
[null,"Y56","London Commissioning Region","08R","NHS Merton CCG",2,5705,0.4]
[null,"Y56","London Commissioning Region","08M","NHS Newham CCG",10,8405,1.2]
[null,"Y56","London Commissioning Region","08N","NHS Redbridge CCG",10,7770,1.3]
[null,"Y56","London Commissioning Region","08P","NHS Richmond CCG",1,5085,0.2]
[null,"Y56","London Commissioning Region","08Q","NHS Southwark CCG",3,8080,0.4]
[null,"Y56","London Commissioning Region","08T","NHS Sutton CCG",6,6090,1]
[null,"Y56","London Commissioning Region","08V","NHS Tower Hamlets CCG",1,7280,0.1]
[null,"Y56","London Commissioning Region","08W","NHS Waltham Forest CCG",12,8090,1.5]
[null,"Y56","London Commissioning Region","08X","NHS Wandsworth CCG",1,8920,0.1]
[null,"Y56","London Commissioning Region","08Y","NHS West London CCG",6,5960,1]
[null,"Y58","South West Commissioning Region","11E","NHS Bath And North East Somerset CCG",0,5660,0]
[null,"Y58","South West Commissioning Region","15C","NHS Bristol, North Somerset And South Gloucestershire CCG",1,31830,0]
[null,"Y58","South West Commissioning Region","15N","NHS Devon CCG",1,40682,0]
[null,"Y58","South West Commissioning Region","11J","NHS Dorset CCG",17,27300,0.6]
[null,"Y58","South West Commissioning Region","11M","NHS Gloucestershire CCG",11,18530,0.6]
[null,"Y58","South West Commissioning Region","11N","NHS Kernow CCG",0,22685,0]
[null,"Y58","South West Commissioning Region","11X","NHS Somerset CCG",1,18930,0.1]
[null,"Y58","South West Commissioning Region","12D","NHS Swindon CCG",116,7075,16.399999999999999]
[null,"Y58","South West Commissioning Region","99N","NHS Wiltshire CCG",55,14635,3.8]
[null,"Y59","South East Commissioning Region","09C","NHS Ashford CCG",81,3795,21.3]
[null,"Y59","South East Commissioning Region","15A","NHS Berkshire West CCG",114,16070,7.1]
[null,"Y59","South East Commissioning Region","09D","NHS Brighton And Hove CCG",20,6855,2.9]
[null,"Y59","South East Commissioning Region","14Y","NHS Buckinghamshire CCG",17,15515,1.1000000000000001]
[null,"Y59","South East Commissioning Region","09E","NHS Canterbury And Coastal CCG",26,5880,4.4000000000000004]
[null,"Y59","South East Commissioning Region","09G","NHS Coastal West Sussex CCG",61,16965,3.6]
[null,"Y59","South East Commissioning Region","09H","NHS Crawley CCG",0,4075,0]
[null,"Y59","South East Commissioning Region","09J","NHS Dartford, Gravesham And Swanley CCG",16,8215,1.9]
[null,"Y59","South East Commissioning Region","15D","NHS East Berkshire CCG",24,12450,1.9]
[null,"Y59","South East Commissioning Region","09L","NHS East Surrey CCG",0,6605,0]
[null,"Y59","South East Commissioning Region","09F","NHS Eastbourne, Hailsham And Seaford CCG",53,6250,8.5]
[null,"Y59","South East Commissioning Region","10K","NHS Fareham And Gosport CCG",0,6090,0]
[null,"Y59","South East Commissioning Region","09N","NHS Guildford And Waverley CCG",1,6095,0.2]
[null,"Y59","South East Commissioning Region","09P","NHS Hastings And Rother CCG",63,6195,10.199999999999999]
[null,"Y59","South East Commissioning Region","99K","NHS High Weald Lewes Havens CCG",10,4440,2.2999999999999998]
[null,"Y59","South East Commissioning Region","09X","NHS Horsham And Mid Sussex CCG",9,7130,1.3]
[null,"Y59","South East Commissioning Region","10L","NHS Isle Of Wight CCG",16,4080,3.9]
[null,"Y59","South East Commissioning Region","09W","NHS Medway CCG",61,8745,7]
[null,"Y59","South East Commissioning Region","99M","NHS North East Hampshire And Farnham CCG",5,6535,0.8]
[null,"Y59","South East Commissioning Region","10J","NHS North Hampshire CCG",1,5940,0.2]
[null,"Y59","South East Commissioning Region","09Y","NHS North West Surrey CCG",24,9040,2.7]
[null,"Y59","South East Commissioning Region","10Q","NHS Oxfordshire CCG",52,17980,2.9]
[null,"Y59","South East Commissioning Region","10R","NHS Portsmouth CCG",0,5845,{"$f":"IF(G83=\"*\",\"*\",IF(ISERROR(F83/G83*1000),\"N/A\",(ROUND(F83/G83*1000,1))))","v":0}]
[null,"Y59","South East Commissioning Region","10V","NHS South Eastern Hampshire CCG",1,6645,0.2]
[null,"Y59","South East Commissioning Region","10A","NHS South Kent Coast CCG",80,6590,12.1]
[null,"Y59","South East Commissioning Region","10X","NHS Southampton CCG",0,8410,0]
[null,"Y59","South East Commissioning Region","99H","NHS Surrey Downs CCG",10,8345,1.2]
[null,"Y59","South East Commissioning Region","10C","NHS Surrey Heath CCG",4,2795,1.4]
[null,"Y59","South East Commissioning Region","10D","NHS Swale CCG",15,3260,4.5999999999999996]
[null,"Y59","South East Commissioning Region","10E","NHS Thanet CCG",0,4740,0]
[null,"Y59","South East Commissioning Region","11A","NHS West Hampshire CCG",4,17325,0.2]
[null,"Y59","South East Commissioning Region","99J","NHS West Kent CCG",4,13140,0.3]
[null,"Y60","Midlands Commissioning Region","15E","NHS Birmingham And Solihull CCG",9,42540,0.2]
[null,"Y60","Midlands Commissioning Region","04Y","NHS Cannock Chase CCG",2,4640,0.4]
[null,"Y60","Midlands Commissioning Region","03V","NHS Corby CCG",7,2590,2.7]
[null,"Y60","Midlands Commissioning Region","05A","NHS Coventry And Rugby CCG",0,15890,0]
[null,"Y60","Midlands Commissioning Region","15M","NHS Derby and Derbyshire CCG",11,35316,0.3]
[null,"Y60","Midlands Commissioning Region","05C","NHS Dudley CCG",18,9830,1.8]
[null,"Y60","Midlands Commissioning Region","03W","NHS East Leicestershire And Rutland CCG",6,10550,0.6]
[null,"Y60","Midlands Commissioning Region","05D","NHS East Staffordshire CCG",6,5615,1.1000000000000001]
[null,"Y60","Midlands Commissioning Region","05F","NHS Herefordshire CCG",17,6695,2.5]
[null,"Y60","Midlands Commissioning Region","04C","NHS Leicester City CCG",0,11080,0]
[null,"Y60","Midlands Commissioning Region","03T","NHS Lincolnshire East CCG",0,8295,0]
[null,"Y60","Midlands Commissioning Region","04D","NHS Lincolnshire West CCG",0,6655,0]
[null,"Y60","Midlands Commissioning Region","04E","NHS Mansfield And Ashfield CCG",0,6670,0]
[null,"Y60","Midlands Commissioning Region","04G","NHS Nene CCG",27,22220,1.2]
[null,"Y60","Midlands Commissioning Region","04H","NHS Newark And Sherwood CCG",0,4440,0]
[null,"Y60","Midlands Commissioning Region","05G","NHS North Staffordshire CCG",0,8915,0]
[null,"Y60","Midlands Commissioning Region","04K","NHS Nottingham City CCG",0,10535,0]
[null,"Y60","Midlands Commissioning Region","04L","NHS Nottingham North And East CCG",0,5155,0]
[null,"Y60","Midlands Commissioning Region","04M","NHS Nottingham West CCG",0,3400,0]
[null,"Y60","Midlands Commissioning Region","05J","NHS Redditch And Bromsgrove CCG",10,5825,1.7]
[null,"Y60","Midlands Commissioning Region","04N","NHS Rushcliffe CCG",0,3965,0]
[null,"Y60","Midlands Commissioning Region","05L","NHS Sandwell And West Birmingham CCG",4,15415,0.3]
[null,"Y60","Midlands Commissioning Region","05N","NHS Shropshire CCG",29,10785,2.7]
[null,"Y60","Midlands Commissioning Region","05Q","NHS South East Staffordshire And Seisdon Peninsula CCG",5,7450,0.7]
[null,"Y60","Midlands Commissioning Region","99D","NHS South Lincolnshire CCG",1,4825,0.2]
[null,"Y60","Midlands Commissioning Region","05R","NHS South Warwickshire CCG",3,9480,0.3]
[null,"Y60","Midlands Commissioning Region","04Q","NHS South West Lincolnshire CCG",0,3940,0]
[null,"Y60","Midlands Commissioning Region","05T","NHS South Worcestershire CCG",37,9780,3.8]
[null,"Y60","Midlands Commissioning Region","05V","NHS Stafford And Surrounds CCG",0,5605,0]
[null,"Y60","Midlands Commissioning Region","05W","NHS Stoke On Trent CCG",0,12380,0]
[null,"Y60","Midlands Commissioning Region","05X","NHS Telford And Wrekin CCG",13,6150,2.1]
[null,"Y60","Midlands Commissioning Region","05Y","NHS Walsall CCG",1,8855,0.1]
[null,"Y60","Midlands Commissioning Region","05H","NHS Warwickshire North CCG",0,5890,0]
[null,"Y60","Midlands Commissioning Region","04V","NHS West Leicestershire CCG",1,11620,0.1]
[null,"Y60","Midlands Commissioning Region","06A","NHS Wolverhampton CCG",0,8240,0]
[null,"Y60","Midlands Commissioning Region","06D","NHS Wyre Forest CCG",15,3800,3.9]
[null,"Y61","East of England Commissioning Region","99E","NHS Basildon And Brentwood CCG",5,9605,0.5]
[null,"Y61","East of England Commissioning Region","06F","NHS Bedfordshire CCG",31,15405,2]
[null,"Y61","East of England Commissioning Region","06H","NHS Cambridgeshire And Peterborough CCG",4,26665,0.2]
[null,"Y61","East of England Commissioning Region","99F","NHS Castle Point And Rochford CCG",7,6340,1.1000000000000001]
[null,"Y61","East of England Commissioning Region","06K","NHS East And North Hertfordshire CCG",14,17470,0.8]
[null,"Y61","East of England Commissioning Region","06M","NHS Great Yarmouth And Waveney CCG",0,8240,0]
[null,"Y61","East of England Commissioning Region","06N","NHS Herts Valleys CCG",22,18635,1.2]
[null,"Y61","East of England Commissioning Region","06L","NHS Ipswich And East Suffolk CCG",0,13020,0]
[null,"Y61","East of England Commissioning Region","06P","NHS Luton CCG",4,7630,0.5]
[null,"Y61","East of England Commissioning Region","06Q","NHS Mid Essex CCG",1,10580,0.1]
[null,"Y61","East of England Commissioning Region","04F","NHS Milton Keynes CCG",0,9010,0]
[null,"Y61","East of England Commissioning Region","06T","NHS North East Essex CCG",14,10535,1.3]
[null,"Y61","East of England Commissioning Region","06V","NHS North Norfolk CCG",1,6355,0.2]
[null,"Y61","East of England Commissioning Region","06W","NHS Norwich CCG",2,6905,0.3]
[null,"Y61","East of England Commissioning Region","06Y","NHS South Norfolk CCG",0,7530,0]
[null,"Y61","East of England Commissioning Region","99G","NHS Southend CCG",3,6385,0.5]
[null,"Y61","East of England Commissioning Region","07G","NHS Thurrock CCG",2,5750,0.3]
[null,"Y61","East of England Commissioning Region","07H","NHS West Essex CCG",19,9550,2]
[null,"Y61","East of England Commissioning Region","07J","NHS West Norfolk CCG",13,7275,{"$f":"IF(G147=\"*\",\"*\",IF(ISERROR(F147/G147*1000),\"N/A\",(ROUND(F147/G147*1000,1))))","v":1.8}]
[null,"Y61","East of England Commissioning Region","07K","NHS West Suffolk CCG",0,8465,0]
[null,"Y62","North West Commissioning Region","00Q","NHS Blackburn With Darwen CCG",3,5400,0.6]
[null,"Y62","North West Commissioning Region","00R","NHS Blackpool CCG",7,6895,1]
[null,"Y62","North West Commissioning Region","00T","NHS Bolton CCG",19,8725,2.2000000000000002]
[null,"Y62","North West Commissioning Region","00V","NHS Bury CCG",11,6910,1.6]
[null,"Y62","North West Commissioning Region","00X","NHS Chorley And South Ribble CCG",17,6535,2.6]
[null,"Y62","North West Commissioning Region","01A","NHS East Lancashire CCG",5,12575,0.4]
[null,"Y62","North West Commissioning Region","01C","NHS Eastern Cheshire CCG",29,5750,5]
[null,"Y62","North West Commissioning Region","02M","NHS Fylde And Wyre CCG",9,6910,1.3]
[null,"Y62","North West Commissioning Region","01E","NHS Greater Preston CCG",18,6925,2.6]
[null,"Y62","North West Commissioning Region","01F","NHS Halton CCG",1,5080,0.2]
[null,"Y62","North West Commissioning Region","01D","NHS Heywood, Middleton And Rochdale CCG",16,7915,2]
[null,"Y62","North West Commissioning Region","01J","NHS Knowsley CCG",1,7110,0.1]
[null,"Y62","North West Commissioning Region","99A","NHS Liverpool CCG",0,19105,0]
[null,"Y62","North West Commissioning Region","14L","NHS Manchester CCG",4,18910,0.2]
[null,"Y62","North West Commissioning Region","01K","NHS Morecambe Bay CCG",32,10695,3]
[null,"Y62","North West Commissioning Region","00Y","NHS Oldham CCG",27,8330,3.2]
[null,"Y62","North West Commissioning Region","01G","NHS Salford CCG",4,10060,0.4]
[null,"Y62","North West Commissioning Region","01R","NHS South Cheshire CCG",0,6350,0]
[null,"Y62","North West Commissioning Region","01T","NHS South Sefton CCG",1,6780,0.1]
[null,"Y62","North West Commissioning Region","01V","NHS Southport And Formby CCG",7,4770,1.5]
[null,"Y62","North West Commissioning Region","01X","NHS St Helens CCG",0,8000,0]
[null,"Y62","North West Commissioning Region","01W","NHS Stockport CCG",5,10670,0.5]
[null,"Y62","North West Commissioning Region","01Y","NHS Tameside And Glossop CCG",1,8210,0.1]
[null,"Y62","North West Commissioning Region","02A","NHS Trafford CCG",0,8315,0]
[null,"Y62","North West Commissioning Region","02D","NHS Vale Royal CCG",1,3570,0.3]
[null,"Y62","North West Commissioning Region","02E","NHS Warrington CCG",4,6905,0.6]
[null,"Y62","North West Commissioning Region","02F","NHS West Cheshire CCG",7,9605,0.7]
[null,"Y62","North West Commissioning Region","02G","NHS West Lancashire CCG",6,3835,1.6]
[null,"Y62","North West Commissioning Region","02H","NHS Wigan Borough CCG",4,10560,0.4]
[null,"Y62","North West Commissioning Region","12F","NHS Wirral CCG",17,14230,1.2]
[null,"Y63","North East and Yorkshire Commissioning Region","02N","NHS Airedale, Wharfedale And Craven CCG",1,5815,0.2]
[null,"Y63","North East and Yorkshire Commissioning Region","02P","NHS Barnsley CCG",0,9445,0]
[null,"Y63","North East and Yorkshire Commissioning Region","02Q","NHS Bassetlaw CCG",0,4065,0]
[null,"Y63","North East and Yorkshire Commissioning Region","02W","NHS Bradford City CCG",0,4325,0]
[null,"Y63","North East and Yorkshire Commissioning Region","02R","NHS Bradford Districts CCG",0,12675,0]
[null,"Y63","North East and Yorkshire Commissioning Region","02T","NHS Calderdale CCG",0,6755,0]
[null,"Y63","North East and Yorkshire Commissioning Region","00C","NHS Darlington CCG",0,3355,0]
[null,"Y63","North East and Yorkshire Commissioning Region","02X","NHS Doncaster CCG",0,11125,0]
[null,"Y63","North East and Yorkshire Commissioning Region","00D","NHS Durham Dales, Easington And Sedgefield CCG",0,9595,0]
[null,"Y63","North East and Yorkshire Commissioning Region","02Y","NHS East Riding Of Yorkshire CCG",0,10260,0]
[null,"Y63","North East and Yorkshire Commissioning Region","03A","NHS Greater Huddersfield CCG",0,7245,0]
[null,"Y63","North East and Yorkshire Commissioning Region","03D","NHS Hambleton, Richmondshire And Whitby CCG",1,4585,0.2]
[null,"Y63","North East and Yorkshire Commissioning Region","03E","NHS Harrogate And Rural District CCG",0,5275,0]
[null,"Y63","North East and Yorkshire Commissioning Region","00K","NHS Hartlepool And Stockton-On-Tees CCG",0,11805,0]
[null,"Y63","North East and Yorkshire Commissioning Region","03F","NHS Hull CCG",0,9340,0]
[null,"Y63","North East and Yorkshire Commissioning Region","15F","NHS Leeds CCG",3,20420,0.1]
[null,"Y63","North East and Yorkshire Commissioning Region","13T","NHS Newcastle Gateshead CCG",0,18315,0]
[null,"Y63","North East and Yorkshire Commissioning Region","01H","NHS North Cumbria CCG",3,9495,0.3]
[null,"Y63","North East and Yorkshire Commissioning Region","00J","NHS North Durham CCG",0,7825,0]
[null,"Y63","North East and Yorkshire Commissioning Region","03H","NHS North East Lincolnshire CCG",0,5445,0]
[null,"Y63","North East and Yorkshire Commissioning Region","03J","NHS North Kirklees CCG",0,5775,0]
[null,"Y63","North East and Yorkshire Commissioning Region","03K","NHS North Lincolnshire CCG",0,5745,0]
[null,"Y63","North East and Yorkshire Commissioning Region","99C","NHS North Tyneside CCG",0,8370,0]
[null,"Y63","North East and Yorkshire Commissioning Region","00L","NHS Northumberland CCG",0,12045,0]
[null,"Y63","North East and Yorkshire Commissioning Region","03L","NHS Rotherham CCG",0,8870,0]
[null,"Y63","North East and Yorkshire Commissioning Region","03M","NHS Scarborough And Ryedale CCG",0,4670,0]
[null,"Y63","North East and Yorkshire Commissioning Region","03N","NHS Sheffield CCG",0,19870,0]
[null,"Y63","North East and Yorkshire Commissioning Region","00M","NHS South Tees CCG",0,10330,0]
[null,"Y63","North East and Yorkshire Commissioning Region","00N","NHS South Tyneside CCG",0,6045,0]
[null,"Y63","North East and Yorkshire Commissioning Region","00P","NHS Sunderland CCG",0,9890,0]
[null,"Y63","North East and Yorkshire Commissioning Region","03Q","NHS Vale Of York CCG",0,12520,0]
[null,"Y63","North East and Yorkshire Commissioning Region","03R","NHS Wakefield CCG",0,13270,0]
[]
[null,"Notes:"]
[null,"1. In September 2019 a revised policy, \"Delivering same-sex accommodation\" was published. Data providers were asked to ensure reporting of MSA breaches for the purposes of this collection were in line with the revised policy by January 2020. This transition period allows providers to make appropriate changes to enable them to report on this basis. As such this may impact on data quality for September - December 2019 data. Providers should all be reporting consistently and as per the updated guidance by January 2020. "]
[]
[null,"2. Finished Consultant Episode (FCE) data from Hospital Episode Statistics (HES) are used to calculate the MSA breach rate (for further details on methodology of this calculation see footnote 2). The FCE data presented here are a snapshot of latest HES data available at the time of the MSA publication for the relevant data period (due to timings of HES publication in some months this will represent \"final\" HES data, however for some months this is \"provisional\" HES data). These are used solely for the purposes of calculating an MSA breach rate to allow comparisons across providers and of change over time.\n\nFrom 2017/18 onwards, at the point of publication of MSA revisions (every 6 months), the FCE denominator is updated to reflect final HES data where available so is subject to change and may not always match the published HES timeseries (where provisional data is updated on a monthly basis).  The official and most recent timeseries of HES data is available on the NHS Digital website which will reflect any more recent updates to the provisional HES FCE data. https://digital.nhs.uk/data-and-information/publications/statistical/hospital-episode-statistics-for-admitted-patient-care-outpatient-and-accident-and-emergency-data\n\nProvider level HES FCE data is suppressed in accordance with HES disclosure control methodology.\nhttps://digital.nhs.uk/binaries/content/assets/website-assets/data-and-information/data-tools-and-services/data-services/hospital-episode-statistics/hes_analysis_guide_september_2018-v1.1.pdf\n\nHES Disclosure Control\nIn order to protect patient confidentiality '*' appears in the table above for all sub-national breakdowns, where it is possible to calculate a value between 1 and 7 from the data presented. All other sub-national data has been rounded to the nearest 5.\n\nIf the national total is between 1 and 7 (inclusive), no sub-national breakdown will be displayed. \n\nIf the national total is greater than or equal to 8;\na. Sub-national counts between 1 and 7 (inclusive) will be displayed as ’*’.\nb. Zeroes will be unchanged.\nc. All other counts will be rounded to the nearest 5."]
[]
[null,"3. The MSA breach rate is the number of MSA breaches, per 1,000 finished consultant episodes. Due to timeliness of HES data, there is one year’s lag in the denominator data, compared to the MSA breaches. For example, the breach rate for June 2019 is calculated by dividing the total MSA breaches in June 2019 (numerator) by the number of Finished Consultant Episodes in June 2018 (denominator). As such, it is only an estimation. Please see Breach Rate methodology paper for further information via: http://www.england.nhs.uk/statistics/mixed-sex-accommodation/\n\nWhen calculating rates or percentages at regional level using HES data;\n1) Where the numerator or denominator is between 1 and 7 (inclusive), no percentage or rate is calculated, and a ’*’ will be displayed.\n2) Where the numerator is zero, the percentage will be 0%.\n3) Where the unrounded numerator and denominator are greater than or equal to 8, a percentage or rate is calculated using the rounded numerator or denominator.\n4).Where no denominator data is available, no percentage or rate is calculated, and ’N/A’ will be displayed."]
[]
[null,"4. Sandwell and West Birmingham Hospitals NHS Trust (RXK) did not submit data for October 2019 due to data quality issues. "]

{"sheet":"Notes","index":5,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,"https://improvement.nhs.uk/documents/6005/Delivering_same_sex_accommodation_sep2019.pdf"]
[2,"https://www.england.nhs.uk/statistics/wp-content/uploads/sites/2/2019/10/MSA-Guidance-v1.5.pdf"]