{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Index","Overview","Place of death calculator","Place of death","Place of death by practice","Annual trend lines","Trend Raw","Usual place of residence","Practice UPD","QOF palliative care","Sheet4"],"not_rendered":{"charts":5,"images":15,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":2},"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":"Index","index":0,"n_rows":24,"n_cols":18,"rows_kept":24,"cut":false,"hidden":false,"merged":[[20,1,21,2],[17,1,18,2],[23,1,24,2],[6,17,7,20],[14,17,15,20],[11,17,12,20],[17,17,18,20],[23,17,24,20],[14,3,14,16],[15,3,15,16],[20,17,21,20],[20,3,21,16],[17,3,18,16],[23,3,24,16],[14,1,15,2],[11,1,12,2],[6,1,7,2],[6,3,7,16],[11,3,12,16],[8,3,9,16],[8,17,9,20],[8,1,9,2],[2,0,3,20],[0,0,1,20]]}
["Place of death: rolling 12-month report"]
[]
["Index"]
[]
[]
["This tool contains the following worksheets:"]
[null,"Worksheet",null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,"Time frame"]
[]
[null,"Overview",null,"Overview, notes and further sources of data.",null,null,null,null,null,null,null,null,null,null,null,null,null,"2006 - 2017"]
[]
[]
[null,"Place of death calculator",null,"Interactive tool designed to help CCGs develop targets for reducing the number of deaths in a hospital setting.",null,null,null,null,null,null,null,null,null,null,null,null,null,"January 1st 2017 to December 31st 2017"]
[]
[]
[null,"Place of death",null,"CCG and practice breakdown of mortality by place of death settings. These are grouped by hospital, care home, home, hospice and 'other'.",null,null,null,null,null,null,null,null,null,null,null,null,null,"April 1st 2017 - March 31st 2018"]
[null,null,null,"The 'other' grouping  includes those deaths that have occurred in work places and public spaces."]
[]
[null,"Annual trend lines",null,"CCG-level trend lines show how the proportion of deaths across the grouped settings have changed over time.",null,null,null,null,null,null,null,null,null,null,null,null,null,"January 1st 2006 - December 31st 2017"]
[]
[]
[null,"Usual place of residence",null,"CCG and practice breakdown of mortality, showing the proportion of deaths recorded as having occurred in the individual's usual place of residence",null,null,null,null,null,null,null,null,null,null,null,null,null,"April 1st 2017 - March 31st 2018"]
[]
[]
[null,"QOF palliative care",null,"CCG and practice-level detailed analysis of the palliative care register",null,null,null,null,null,null,null,null,null,null,null,null,null,"2009/10 - 2017/18"]

{"sheet":"Overview","index":1,"n_rows":56,"n_cols":1,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,0,55,16376],[0,0,1,15],[2,0,3,15],[31,0,35,15],[4,0,6,15],[7,0,9,15],[48,0,49,15],[46,0,47,4],[50,0,54,15],[38,0,40,15]]}
["Place of death: rolling 12-month report - overview"]
[]
["1st April 2017 - 31st March 2018"]
[]
["Over the past 12 years Lancashire GPs and their partners from across the care spectrum have been successful in significantly reducing the number of deaths recorded in a hospital setting from 55% in 2006 to 44% in 2017. The large increase in the proportion of deaths recorded in either a home or a care home setting is the main driving factor behind this. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The National Survey of Bereaved People (VOICES) analysed by the Office for National Statistics, asks respondents about the end of life care their family member or friend received in their last three months. Findings from the 2015 VOICES survey (published  2016) support other research findings that dying at home is the most common preference. Respondents were asked if the patient had expressed a preference for where they would like to die and asked to state where this was (for instance, at home, in a hospice etc.). The majority believed the deceased had wanted to die at home (81%), 8% said they wanted to die in a hospice, 7% in a care home, 3% in hospital and 1% somewhere else."]
[]
[]
[]
[]
["Click here for further details"]
[]
["In 2016 the Royal College of Physicians (RCP) in conjunction with Marie Curie published the 'End of Life Care Audit - Dying in Hospital, national report for England'. The main findings highlighted improvements across a number of area, but some providers were failing to provide adequate 24/7 palliative care, with evening and weekend provision being of concern. "]
[]
[]
["Click here for further details"]
[]
["Please see Public Health England's  End of Life tool for further detailed analysis"]
["PHE: End of life tool"]
[]
["Produced by Public Health Intelligence"]
[]
["* Every effort is made to ensure that an accurate picture of home deaths is presented, this methodology is susceptible to coding practices and could result in some deaths being incorrectly coded as a home death.  "]
[]
["Between December 1st 2014 and November 30th 2015, fewer than 1% of deaths identified as having occurred in a home setting and 35% of those identified as having occurred in a care home setting had a usual place of residence address that did not exactly match the place of death address. It is without doubt that some of these deaths will not have occurred within a home setting, but it is felt that in the majority of cases there will simply be a slight difference in how the addresses were recorded.  For example: '2 North Street, Preston, Lancashire'  and '2 North Street, Preston, PR1 1AA'.  Whilst we will continue to work on improving our local reporting systems, until changes are made at a national level, we will not be able to attain 100% accuracy."]
[]
[]
[]
[]
["Source of data: August 2018 Primary Care Mortality Database (PCMD) from NHS Digital"]

{"sheet":"Place of death calculator","index":2,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,1,19],[3,0,5,19],[7,2,8,4],[54,1,56,4],[19,1,19,2],[20,1,20,2],[18,1,18,2],[19,4,20,4],[7,0,8,0]]}
["Place of death calculator (2017)"]
[]
[]
["This calculator has been developed to help CCGs develop targets for reducing the number of deaths in a hospital setting. To use the tool: (1) select the CCG you are interested in. (2) in the '% increase target' cells (marked yellow below) set a target for the chosen setting(s). This will adjust the corresponding cells to show the actual number of deaths required in the selected setting to meet the target. For example, if you enter 10% in the 'home' setting for NHS Chorley and South Ribble CCG, this would mean an additional 38 deaths need to have occurred at home to meet the target. We have also provided the actual increase required per practice, but please note, the size of each individual practice varies and it may not be appropriate to apply this figure to very large or very small practices. (3) the next table shows the predicted number of deaths in a hospital, based on the targets and the actual deaths in hospital (2017), it then works out the percentage reduction between the two values if the targets are achieved. (4) the predicted place of death table shows the values and percentage of total deaths by each setting, again, based on the targets set in table 2. The final table is the actual number of deaths by setting for each of the CCGs. "]
[]
[]
[]
[1,null,"<< Select CCG"]
[]
[]
[null,"NHS Chorley and South Ribble CCG"]
[2,"Place of death calculator"]
[null,"Setting","% increase target","Actual increase required","Actual increase per practice"]
[null,"Home",0.1,{"$f":"SUM(IF($B$26:$B$31=$B$11,C26:C31,\"\"))-SUM(IF($B$35:$B$40=$B$11,C35:C40,\"\"))","v":38.222222222222229},{"$f":"D14/(COUNTIF('Place of death by practice'!$B$2:$B$179,'Place of death calculator'!$B$11))","v":1.2329749103942655}]
[null,"Care home",0,{"$f":"SUM(IF($B$26:$B$31=$B$11,E26:E31,\"\"))-SUM(IF($B$35:$B$40=$B$11,D35:D40,\"\"))","v":0},{"$f":"D15/(COUNTIF('Place of death by practice'!$B$2:$B$179,'Place of death calculator'!$B$11))","v":0}]
[null,"Hospice",0,{"$f":"SUM(IF($B$26:$B$31=$B$11,G26:G31,\"\"))-SUM(IF($B$35:$B$40=$B$11,E35:E40,\"\"))","v":0},{"$f":"D16/(COUNTIF('Place of death by practice'!$B$2:$B$179,'Place of death calculator'!$B$11))","v":0}]
[]
[3,"Percentage reduction of hospital deaths if target achieved"]
[null,"Value",null,"Decrease","% reduction "]
[null,"Hospital (predicted)",null,{"$f":"D21-SUM(D14:D16)","v":775.77777777777783},{"$f":"(D20-D21)/ABS(D21)","v":-4.6956046956046896E-2}]
[null,"Hospital (actual value 2017)",null,{"$f":"SUM(IF(B35:B40=B11,F35:F40,\"\"))","v":814}]
[]
[]
[4,"Predicted place of death, by CCG"]
[null,"CCG","Home","% of total","Care home","% of total","Hospice","% of total","Hospital","% of total","Grand Total"]
[null,"NHS Chorley and South Ribble CCG",{"$f":"IF($B$11=B26,$C35/(1-$C$14),$C35)","v":382.22222222222223},{"$f":"C26/H35","v":0.22222222222222224},{"$f":"IF($B$11=B26,$D35/(1-$C$15),$D35)","v":398},{"$f":"E26/H35","v":0.2313953488372093},{"$f":"IF($B$11=B26,$E35/(1-$C$16),$E35)","v":139},{"$f":"G26/H35","v":8.0813953488372087E-2},{"$f":"IF($B26=$B$11,$D$20,$F35)","v":775.77777777777783},{"$f":"I26/H35","v":0.45103359173126617},{"$f":"I26+G26+E26+C26","v":1695}]
[null,"NHS East Lancashire CCG",864,{"$f":"C27/H36","v":0.23900414937759337},836,{"$f":"E27/H36","v":0.23125864453665285},172,{"$f":"G27/H36","v":4.7579529737206083E-2},{"$f":"IF($B27=$B$11,$D$20,$F36)","v":1679},{"$f":"I27/H36","v":0.46445366528354082},3551]
[null,"NHS Fylde & Wyre CCG",618,{"$f":"C28/H37","v":0.27176781002638523},507,{"$f":"E28/H37","v":0.22295514511873352},133,{"$f":"G28/H37","v":5.8487247141600703E-2},{"$f":"IF($B28=$B$11,$D$20,$F37)","v":983},{"$f":"I28/H37","v":0.43227792436235707},2241]
[null,"NHS Greater Preston CCG",363,{"$f":"C29/H38","v":0.20485327313769752},398,{"$f":"E29/H38","v":0.22460496613995484},132,{"$f":"G29/H38","v":7.4492099322799099E-2},{"$f":"IF($B29=$B$11,$D$20,$F38)","v":846},{"$f":"I29/H38","v":0.47742663656884876},1739]
[null,"NHS Morecambe Bay CCG",938,{"$f":"C30/H39","v":0.26907630522088355},893,{"$f":"E30/H39","v":0.25616752725186459},208,{"$f":"G30/H39","v":5.9667240390131958E-2},{"$f":"IF($B30=$B$11,$D$20,$F39)","v":1368},{"$f":"I30/H39","v":0.39242685025817559},3407]
[null,"NHS West Lancashire CCG",319,{"$f":"C31/H40","v":0.27264957264957262},297,{"$f":"E31/H40","v":0.25384615384615383},38,{"$f":"G31/H40","v":3.2478632478632481E-2},{"$f":"IF($B31=$B$11,$D$20,$F40)","v":498},{"$f":"I31/H40","v":0.42564102564102563},1152]
[]
[null,"Actual place of death by CCG, 2017"]
[null,"Registered CCG","Home","Care home","Hospice","Hospital","Elsewhere and other places","Grand total"]
[null,"NHS Chorley and South Ribble CCG",344,398,139,814,25,{"$f":"SUM(C35:G35)","v":1720}]
[null,"NHS East Lancashire CCG",864,836,172,1679,64,{"$f":"SUM(C36:G36)","v":3615}]
[null,"NHS Fylde & Wyre CCG",618,507,133,983,33,{"$f":"SUM(C37:G37)","v":2274}]
[null,"NHS Greater Preston CCG",363,398,132,846,33,{"$f":"SUM(C38:G38)","v":1772}]
[null,"NHS Morecambe Bay CCG",938,893,208,1368,79,{"$f":"SUM(C39:G39)","v":3486}]
[null,"NHS West Lancashire CCG",319,297,38,498,18,{"$f":"SUM(C40:G40)","v":1170}]
[null,"Grand total",3446,3329,822,6188,255,{"$f":"SUM(H35:H40)","v":14037}]
[]
[null,"Note: whilst this is based on historic data, the number of deaths recorded each year remains fairly consistent, for example across all six CCGs there were 11,400 deaths in 2014 and 11,382 in 2015."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Source of data: August 2018 PCMD received from NHS Digital"]

{"sheet":"Place of death","index":3,"n_rows":262,"n_cols":12,"rows_kept":262,"cut":false,"hidden":false,"merged":[[0,0,1,18],[30,1,30,4],[33,0,34,17],[6,0,6,17],[5,0,5,14],[24,11,25,16],[261,0,261,6],[258,0,258,12],[259,0,259,12],[7,0,8,13],[10,0,10,12],[260,0,260,7],[16,11,19,15],[9,0,9,17],[199,1,199,2]]}
["Place of death: clinical commissioning group rolling 12-month report, 1st April 2017 - 31st March 2018"]
[]
[]
[]
["During the 12-month period 1st April 2017 to 31st March 2018: "]
["● Patients registered to the six CCGs in the Lancashire county area were more likely to die in either a home (24%) or care home (25%) than a hospital setting (44%)."]
["● A statistically significantly larger proportion of patients in the NHS Chorley and South Ribble CCG area died in a hospital setting (48%) compared to the combined area average (44%). NHS Morecambe Bay CCG (39%) recorded a significantly smaller proportion of deaths in a hospital setting."]
["● NHS Morecambe Bay CCG recorded a significantly larger proportion of deaths in a care home setting  (27%) than the combined average (25%), while NHS Chorley and South Ribble CCG (21%) and NHS Greater Preston CCG (22%) recorded a significantly smaller proportion."]
[]
["● NHS Morecambe Bay CCG recorded a significantly larger proportion of deaths in a home setting (26%) than the combined average (24%)."]
["● NHS Chorley and South Ribble CCG (8%) and NHS Greater Preston CCG (8%) both recorded a significantly larger proportion of deaths in a hospice setting than the laverage (6%). NHS East Lancashire CCG (4%) and NHS West Lancashire CCG (3%) recorded a significantly smaller proportion."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Between 1st April 2017 and 31st March  2018  a total of 14,320 deaths were recorded amongst patients registered with one of the six Lancashire county CCGs; of these: "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"• 44% died in a hospital setting;"]
[null,null,null,null,null,null,null,null,null,null,null,"• 25% in a care home;"]
[null,null,null,null,null,null,null,null,null,null,null,"• 24% in a 'home' setting; and"]
[null,null,null,null,null,null,null,null,null,null,null,"• 6% in a hospice."]
[null,null,null,null,null,null,null,null,null,null,null,"The remainder of deaths were recorded as having occurred in 'other' settings."]
[]
[]
[]
[]
[]
[null,"Source of data:  August 2018 PCMD received from NHS Digital"]
[]
[]
["Place of death: practice breakdown rolling 12-month period, 1st April 2017 - 31st March 2017"]
[]
[]
[null,"Registered CCG:","NHS Chorley and South Ribble CCG","<< Select CCG"]
[]
[null,null,"Values"]
[null,"Registered Practice","Hospital ","Care home ","Home ","Hospice ","Other "]
[null,"P81180:CLAYTON BROOK SURGERY",0.24,0.42,0.24,0.06,4.0000000000000036E-2]
[null,"P81733:ECCLESTON HEALTH CENTRE",0.25,0.33333333333333331,0.25,0.16666666666666666,0]
[null,"P81689:EAVES LANE SURGERY",0.29411764705882354,0.11764705882352941,0.47058823529411764,0.11764705882352941,0]
[null,"P81127:THE SURGERY CHORLEY",0.37037037037037035,0.22222222222222221,0.29629629629629628,0.1111111111111111,0]
[null,"P81740:ADLINGTON MEDICAL CENTRE",0.375,0.4375,0.125,6.25E-2,0]
[null,"P81033:COPPULL MEDICAL PRACTICE",0.3902439024390244,0.30894308943089432,0.24390243902439024,5.6910569105691054E-2,0]
[null,"Y00347:DR R BAGHDJIAN SURGERY",0.39130434782608697,0.19565217391304349,0.34782608695652173,6.5217391304347824E-2,0]
[null,"P81655:THE VILLAGE SURGERIES CROSTON&ECCLESTON",0.40277777777777779,0.40277777777777779,0.19444444444444445,0,0]
[null,"P81062:REGENT HOUSE SURGERY",0.40476190476190477,0.17857142857142858,0.29761904761904762,0.10714285714285714,1.1904761904761973E-2]
[null,"P81038:THE CHORLEY SURGERY",0.43037974683544306,0.13924050632911392,0.32911392405063289,8.8607594936708861E-2,1.2658227848101222E-2]
[null,"P81154:GRANVILLE HOUSE MED CTRE",0.43137254901960786,0.26470588235294118,0.22549019607843138,6.8627450980392163E-2,9.8039215686275272E-3]
[null,"P81687:NEW LONGTON SURGERY",0.43478260869565216,0.30434782608695654,0.17391304347826086,4.3478260869565216E-2,4.3478260869565299E-2]
[null,"P81741:STATION SURGERY",0.4375,6.25E-2,0.375,0.125,0]
[null,"P81642:MEDICARE UNIT SURGERY",0.45454545454545453,4.5454545454545456E-2,0.27272727272727271,0.22727272727272727,0]
[null,"Y03656:LEYLAND SURGERY",0.46296296296296297,0.12962962962962962,0.24074074074074073,0.14814814814814814,1.8518518518518601E-2]
[null,"P81076:SANDY LANE SURGERY",0.46534653465346537,0.16831683168316833,0.22772277227722773,0.11881188118811881,1.980198019801982E-2]
[null,"P81044:LIBRARY HOUSE SURGERY",0.48514851485148514,0.26732673267326734,0.18811881188118812,3.9603960396039604E-2,1.980198019801982E-2]
[null,"P81701:PRESTON ROAD SURGERY",0.48571428571428571,0.2,0.17142857142857143,0.14285714285714285,0]
[null,"P81082:THE RYAN MEDICAL CENTRE",0.51041666666666663,0.20833333333333334,0.19791666666666666,6.25E-2,2.083333333333337E-2]
[null,"P81117:CENTRAL PARK SURGERY",0.51428571428571423,0.11428571428571428,0.2857142857142857,5.7142857142857141E-2,2.8571428571428581E-2]
[null,"Y02466:BUCKSHAW VILLAGE HEALTH CENTRE",0.51851851851851849,0.25925925925925924,9.2592592592592587E-2,0.12962962962962962,0]
[null,"P81143:WHITTLE SURGERY",0.51851851851851849,9.8765432098765427E-2,0.24691358024691357,0.1111111111111111,2.4691358024691468E-2]
[null,"P81083:ROSLEA SURGERY",0.52800000000000002,0.23200000000000001,0.184,0.04,1.6000000000000014E-2]
[null,"P81692:BEECHES MEDICAL CENTRE",0.53333333333333333,0.23333333333333334,0.13333333333333333,6.6666666666666666E-2,3.3333333333333437E-2]
[null,"P81181:KINGSFOLD MEDICAL CENTRE",0.56666666666666665,6.6666666666666666E-2,0.16666666666666666,0.16666666666666666,3.3333333333333437E-2]
[null,"P81057:WORDEN MEDICAL CENTRE",0.6,6.9565217391304349E-2,0.2608695652173913,5.2173913043478258E-2,1.7391304347826098E-2]
[null,"P81173:CROSTON MEDICAL CENTRE",0.61111111111111116,0.19444444444444445,0.19444444444444445,0,0]
[null,"P81171:THE EUXTON MEDICAL CENTRE",0.61538461538461542,0.11538461538461539,0.15384615384615385,0.11538461538461539,0]
[null,"P81186:MOSS SIDE MEDICAL CENTRE",0.63636363636363635,0.12121212121212122,0.12121212121212122,9.0909090909090912E-2,3.0303030303030276E-2]
[null,"P81769:LOSTOCK HALL VILLAGE SURGERY",0.66666666666666663,0,0.16666666666666666,0.16666666666666666,0]
[null,"P81010:WITHNELL HEALTH CENTRE",0.69565217391304346,0,0.21739130434782608,4.3478260869565216E-2,4.3478260869565299E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B37 & \" \" &C37","v":"Registered CCG: NHS Chorley and South Ribble CCG"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Please note that these are crude rate comparisons that do not take into account confounding factors such as population demographics (age/gender). Additionally these rates only take into account a small time frame. "]
["Total = total deaths relating to persons registered to one of the six Lancashire area CCGs."]
["Home deaths refer to those deaths which have occurred in a private dwelling."]
["Other deaths, refer to those deaths which have occurred outside of the four defined settings and include deaths in the work place and deaths in public places."]

{"sheet":"Place of death by practice","index":4,"n_rows":191,"n_cols":7,"rows_kept":191,"cut":false,"hidden":true,"merged":[]}
["Registered Practice","Registered CCG","Hospital","Care home","Home","Hospice","Other"]
["P81010:WITHNELL HEALTH CENTRE","NHS Chorley and South Ribble CCG",0.69565217391304346,0,0.21739130434782608,4.3478260869565216E-2,4.3478260869565299E-2]
["P81033:COPPULL MEDICAL PRACTICE","NHS Chorley and South Ribble CCG",0.3902439024390244,0.30894308943089432,0.24390243902439024,5.6910569105691054E-2,0]
["P81038:THE CHORLEY SURGERY","NHS Chorley and South Ribble CCG",0.43037974683544306,0.13924050632911392,0.32911392405063289,8.8607594936708861E-2,1.2658227848101222E-2]
["P81044:LIBRARY HOUSE SURGERY","NHS Chorley and South Ribble CCG",0.48514851485148514,0.26732673267326734,0.18811881188118812,3.9603960396039604E-2,1.980198019801982E-2]
["P81057:WORDEN MEDICAL CENTRE","NHS Chorley and South Ribble CCG",0.6,6.9565217391304349E-2,0.2608695652173913,5.2173913043478258E-2,1.7391304347826098E-2]
["P81062:REGENT HOUSE SURGERY","NHS Chorley and South Ribble CCG",0.40476190476190477,0.17857142857142858,0.29761904761904762,0.10714285714285714,1.1904761904761973E-2]
["P81076:SANDY LANE SURGERY","NHS Chorley and South Ribble CCG",0.46534653465346537,0.16831683168316833,0.22772277227722773,0.11881188118811881,1.980198019801982E-2]
["P81082:THE RYAN MEDICAL CENTRE","NHS Chorley and South Ribble CCG",0.51041666666666663,0.20833333333333334,0.19791666666666666,6.25E-2,2.083333333333337E-2]
["P81083:ROSLEA SURGERY","NHS Chorley and South Ribble CCG",0.52800000000000002,0.23200000000000001,0.184,0.04,1.6000000000000014E-2]
["P81117:CENTRAL PARK SURGERY","NHS Chorley and South Ribble CCG",0.51428571428571423,0.11428571428571428,0.2857142857142857,5.7142857142857141E-2,2.8571428571428581E-2]
["P81127:THE SURGERY CHORLEY","NHS Chorley and South Ribble CCG",0.37037037037037035,0.22222222222222221,0.29629629629629628,0.1111111111111111,0]
["P81143:WHITTLE SURGERY","NHS Chorley and South Ribble CCG",0.51851851851851849,9.8765432098765427E-2,0.24691358024691357,0.1111111111111111,2.4691358024691468E-2]
["P81154:GRANVILLE HOUSE MED CTRE","NHS Chorley and South Ribble CCG",0.43137254901960786,0.26470588235294118,0.22549019607843138,6.8627450980392163E-2,9.8039215686275272E-3]
["P81171:THE EUXTON MEDICAL CENTRE","NHS Chorley and South Ribble CCG",0.61538461538461542,0.11538461538461539,0.15384615384615385,0.11538461538461539,0]
["P81173:CROSTON MEDICAL CENTRE","NHS Chorley and South Ribble CCG",0.61111111111111116,0.19444444444444445,0.19444444444444445,0,0]
["P81180:CLAYTON BROOK SURGERY","NHS Chorley and South Ribble CCG",0.24,0.42,0.24,0.06,4.0000000000000036E-2]
["P81181:KINGSFOLD MEDICAL CENTRE","NHS Chorley and South Ribble CCG",0.56666666666666665,6.6666666666666666E-2,0.16666666666666666,0.16666666666666666,3.3333333333333437E-2]
["P81186:MOSS SIDE MEDICAL CENTRE","NHS Chorley and South Ribble CCG",0.63636363636363635,0.12121212121212122,0.12121212121212122,9.0909090909090912E-2,3.0303030303030276E-2]
["P81642:MEDICARE UNIT SURGERY","NHS Chorley and South Ribble CCG",0.45454545454545453,4.5454545454545456E-2,0.27272727272727271,0.22727272727272727,0]
["P81655:THE VILLAGE SURGERIES CROSTON&ECCLESTON","NHS Chorley and South Ribble CCG",0.40277777777777779,0.40277777777777779,0.19444444444444445,0,0]
["P81687:NEW LONGTON SURGERY","NHS Chorley and South Ribble CCG",0.43478260869565216,0.30434782608695654,0.17391304347826086,4.3478260869565216E-2,4.3478260869565299E-2]
["P81689:EAVES LANE SURGERY","NHS Chorley and South Ribble CCG",0.29411764705882354,0.11764705882352941,0.47058823529411764,0.11764705882352941,0]
["P81692:BEECHES MEDICAL CENTRE","NHS Chorley and South Ribble CCG",0.53333333333333333,0.23333333333333334,0.13333333333333333,6.6666666666666666E-2,3.3333333333333437E-2]
["P81701:PRESTON ROAD SURGERY","NHS Chorley and South Ribble CCG",0.48571428571428571,0.2,0.17142857142857143,0.14285714285714285,0]
["P81733:ECCLESTON HEALTH CENTRE","NHS Chorley and South Ribble CCG",0.25,0.33333333333333331,0.25,0.16666666666666666,0]
["P81740:ADLINGTON MEDICAL CENTRE","NHS Chorley and South Ribble CCG",0.375,0.4375,0.125,6.25E-2,0]
["P81741:STATION SURGERY","NHS Chorley and South Ribble CCG",0.4375,6.25E-2,0.375,0.125,0]
["P81769:LOSTOCK HALL VILLAGE SURGERY","NHS Chorley and South Ribble CCG",0.66666666666666663,0,0.16666666666666666,0.16666666666666666,0]
["Y00347:DR R BAGHDJIAN SURGERY","NHS Chorley and South Ribble CCG",0.39130434782608697,0.19565217391304349,0.34782608695652173,6.5217391304347824E-2,0]
["Y02466:BUCKSHAW VILLAGE HEALTH CENTRE","NHS Chorley and South Ribble CCG",0.51851851851851849,0.25925925925925924,9.2592592592592587E-2,0.12962962962962962,0]
["Y03656:LEYLAND SURGERY","NHS Chorley and South Ribble CCG",0.46296296296296297,0.12962962962962962,0.24074074074074073,0.14814814814814814,1.8518518518518601E-2]
["P81003:ST JAMES' MEDICAL CENTRE","NHS East Lancashire CCG",0.52380952380952384,0.2,0.23809523809523808,1.9047619047619049E-2,1.9047619047618869E-2]
["P81008:YORKSHIRE STREET MEDICAL CENTRE","NHS East Lancashire CCG",0.37735849056603776,0.22641509433962265,0.33962264150943394,3.7735849056603772E-2,1.8867924528301883E-2]
["P81017:WHALLEY MEDICAL CENTRE","NHS East Lancashire CCG",0.64367816091954022,8.0459770114942528E-2,0.22988505747126436,2.2988505747126436E-2,2.2988505747126409E-2]
["P81020:ST. NICHOLAS GROUP PRACTICE","NHS East Lancashire CCG",0.5368421052631579,0.14736842105263157,0.27368421052631581,4.2105263157894736E-2,0]
["P81025:THE RICHMOND HILL PRACTICE","NHS East Lancashire CCG",0.45614035087719296,0.23684210526315788,0.27192982456140352,1.7543859649122806E-2,1.7543859649122862E-2]
["P81027:IRWELL MEDICAL PRACTICE","NHS East Lancashire CCG",0.48461538461538461,0.16923076923076924,0.23076923076923078,0.1,1.5384615384615441E-2]
["P81028:MANCHESTER ROAD SURGERY","NHS East Lancashire CCG",0.46938775510204084,0.32653061224489793,0.16326530612244897,2.0408163265306121E-2,2.0408163265306145E-2]
["P81032:REEDYFORD HLTH CARE GROUP","NHS East Lancashire CCG",0.5,0.27777777777777779,0.17460317460317459,3.968253968253968E-2,7.9365079365080193E-3]
["P81035:COLNE ROAD SURGERY","NHS East Lancashire CCG",0.66666666666666663,0.1388888888888889,0.16666666666666666,0,2.777777777777779E-2]
["P81036:PEEL HOUSE MEDICAL PRACTICE","NHS East Lancashire CCG",0.34061135371179041,0.40174672489082969,0.19213973799126638,4.8034934497816595E-2,1.7467248908296984E-2]
["P81047:PARKSIDE SURGERY","NHS East Lancashire CCG",0.46511627906976744,0.32558139534883723,0.18604651162790697,1.5503875968992248E-2,7.7519379844960268E-3]
["P81053:BRIERCLIFFE SURGERY","NHS East Lancashire CCG",0.4606741573033708,0.2247191011235955,0.25842696629213485,5.6179775280898875E-2,0]
["P81065:THE PENDLE MEDICAL PARTNERSHIP","NHS East Lancashire CCG",0.31205673758865249,0.34042553191489361,0.27659574468085107,4.9645390070921988E-2,2.1276595744680771E-2]
["P81069:PENDLESIDE MEDICAL PRACT","NHS East Lancashire CCG",0.4453125,0.3359375,0.1875,1.5625E-2,1.5625E-2]
["P81070:PENDLE VIEW MEDICAL CTRE","NHS East Lancashire CCG",0.4329896907216495,0.30927835051546393,0.21649484536082475,2.0618556701030927E-2,2.0618556701030855E-2]
["P81078:BARNOLDSWICK MED CTR","NHS East Lancashire CCG",0.45945945945945948,0.13513513513513514,0.29729729729729731,7.2072072072072071E-2,3.6036036036036001E-2]
["P81088:WHITWORTH MEDICAL CENTRE","NHS East Lancashire CCG",0.47727272727272729,0.11363636363636363,0.31818181818181818,6.8181818181818177E-2,2.2727272727272707E-2]
["P81095:THURSBY SURGERY","NHS East Lancashire CCG",0.51515151515151514,0.27272727272727271,0.13636363636363635,4.5454545454545456E-2,3.0303030303030387E-2]
["P81099:DR THM MACKENZIE & PARTNERS","NHS East Lancashire CCG",0.46923076923076923,0.35384615384615387,0.12307692307692308,4.6153846153846156E-2,7.692307692307665E-3]
["P81100:THE CASTLE MEDICAL GROUP","NHS East Lancashire CCG",0.50375939849624063,0.17293233082706766,0.25563909774436089,5.2631578947368418E-2,1.5037593984962294E-2]
["P81104:OXFORD ROAD MEDICAL CTRE","NHS East Lancashire CCG",0.40476190476190477,0.2857142857142857,0.23809523809523808,7.1428571428571425E-2,0]
["P81118:ILEX VIEW MEDICAL PRACTICE","NHS East Lancashire CCG",0.38356164383561642,0.36986301369863012,0.16438356164383561,4.1095890410958902E-2,4.1095890410959068E-2]
["P81123:ELMS FEDERATED PRACTICE","NHS East Lancashire CCG",0.39860139860139859,0.27272727272727271,0.27272727272727271,3.4965034965034968E-2,2.0979020979021046E-2]
["P81130:PADIHAM GROUP PRACTICE","NHS East Lancashire CCG",0.54225352112676062,0.23943661971830985,0.1619718309859155,4.2253521126760563E-2,1.4084507042253502E-2]
["P81132:DR DM DOHERTY & PARTNERS","NHS East Lancashire CCG",0.40789473684210525,0.21052631578947367,0.32894736842105265,3.9473684210526314E-2,1.3157894736842035E-2]
["P81134:KIDDROW MEDICAL PRACTICE","NHS East Lancashire CCG",0.43243243243243246,0.13513513513513514,0.35135135135135137,0,8.1081081081081141E-2]
["P81137:BURNLEY WOOD MEDICAL CENTRE","NHS East Lancashire CCG",0.43859649122807015,0.21052631578947367,0.2807017543859649,5.2631578947368418E-2,1.7543859649122862E-2]
["P81146:MYRTLE HOUSE","NHS East Lancashire CCG",0.47058823529411764,0.35294117647058826,0.11764705882352941,3.9215686274509803E-2,1.9607843137254943E-2]
["P81147:BLACKBURN RD MEDICAL CENTRE","NHS East Lancashire CCG",0.42857142857142855,0.33333333333333331,0.21428571428571427,0,2.3809523809523836E-2]
["P81160:OSWALD MEDICAL CENTRE","NHS East Lancashire CCG",0.47619047619047616,0.19047619047619047,0.2857142857142857,2.3809523809523808E-2,2.3809523809523836E-2]
["P81165:IGHTENHILL MEDICAL CENTRE","NHS East Lancashire CCG",0.60869565217391308,0.17391304347826086,0.21739130434782608,0,0]
["P81166:DR BELLO'S SURGERY","NHS East Lancashire CCG",0.4375,0.25,0.3125,0,0]
["P81170:DR MALIK & PARTNER","NHS East Lancashire CCG",0.51724137931034486,0.10344827586206896,0.34482758620689657,3.4482758620689655E-2,0]
["P81182:RICHMOND MEDICAL CENTRE","NHS East Lancashire CCG",0.5714285714285714,9.5238095238095233E-2,0.33333333333333331,0,0]
["P81197:ROSEGROVE SURGERY","NHS East Lancashire CCG",0.47058823529411764,0.23529411764705882,0.20588235294117646,5.8823529411764705E-2,2.941176470588247E-2]
["P81212:DR MOUJAES","NHS East Lancashire CCG",0.51219512195121952,0.17073170731707318,0.24390243902439024,4.878048780487805E-2,2.4390243902438935E-2]
["P81215:ROSEHILL SURGERY","NHS East Lancashire CCG",0.609375,0.125,0.234375,3.125E-2,0]
["P81218:THE CLAYTON MEDICAL CTR.","NHS East Lancashire CCG",0.38834951456310679,0.39805825242718446,0.18446601941747573,2.9126213592233011E-2,0]
["P81620:SLAIDBURN HEALTH CENTRE","NHS East Lancashire CCG",1,0,0,0,0]
["P81659:THE ROYLE","NHS East Lancashire CCG",0.42857142857142855,0.17857142857142858,0.21428571428571427,0.17857142857142858,0]
["P81686:ROSSENDALE VALLEY MEDICAL PRACTICE","NHS East Lancashire CCG",0.52631578947368418,0.10526315789473684,0.26315789473684209,5.2631578947368418E-2,5.2631578947368585E-2]
["P81699:HIGHER HEYS SURGERY","NHS East Lancashire CCG",0.4,0.45,0.1,0.05,0]
["P81711:DILL HALL SURGERY","NHS East Lancashire CCG",0.3,0.45,0.15,0.05,4.9999999999999933E-2]
["P81726:KING STREET MEDICAL CTR","NHS East Lancashire CCG",0.66666666666666663,0,0.26666666666666666,6.6666666666666666E-2,0]
["P81730:GREAT HARWOOD MEDICAL GROUP","NHS East Lancashire CCG",0.4935064935064935,0.14285714285714285,0.25974025974025972,5.1948051948051951E-2,5.1948051948051965E-2]
["P81731:DR JEHANGIR (SH)","NHS East Lancashire CCG",0.45454545454545453,0.27272727272727271,0.18181818181818182,4.5454545454545456E-2,4.5454545454545414E-2]
["P81732:HARAMBEE SURGERY","NHS East Lancashire CCG",0.47058823529411764,0.3235294117647059,0.17647058823529413,2.9411764705882353E-2,0]
["P81736:WHITEFIELD HEALTHCARE","NHS East Lancashire CCG",0.76923076923076927,0,0.23076923076923078,0,0]
["P81738:RISHTON & GREAT HARWOOD SURGERY","NHS East Lancashire CCG",0.18181818181818182,0.18181818181818182,0.45454545454545453,9.0909090909090912E-2,9.0909090909090939E-2]
["P81749:ABBEY SURGERY","NHS East Lancashire CCG",0.36363636363636365,9.0909090909090912E-2,0.54545454545454541,0,0]
["P81755:CABIN SURGERY","NHS East Lancashire CCG",0.54545454545454541,6.8181818181818177E-2,0.29545454545454547,9.0909090909090912E-2,0]
["P81756:DANESHOUSE MEDICAL CENTRE","NHS East Lancashire CCG",0.625,0.125,0.25,0,0]
["P81757:BARROWFORD SURGERY","NHS East Lancashire CCG",0.4838709677419355,0.29032258064516131,0.19354838709677419,3.2258064516129031E-2,0]
["P81778:DR A K JHA (SH)","NHS East Lancashire CCG",0.44444444444444442,0.19444444444444445,0.30555555555555558,5.5555555555555552E-2,0]
["P81780:RIVERSIDE FAMILY PRACTICE","NHS East Lancashire CCG",0.4375,0.1875,0.3125,0,6.25E-2]
["Y02605:AVHAC REGISTERED PATIENTS","NHS East Lancashire CCG",0.5625,0.125,0.25,0,6.25E-2]
["Y02606:FAIRMORE MEDICAL PRACTICE","NHS East Lancashire CCG",0.42307692307692307,0.11538461538461539,0.30769230769230771,0.11538461538461539,3.8461538461538436E-2]
["P81006:GARSTANG MEDICAL PRACTICE","NHS Fylde & Wyre CCG",0.42857142857142855,0.30857142857142855,0.18857142857142858,0.04,3.4285714285714253E-2]
["P81031:POPLAR HOUSE SURGERY","NHS Fylde & Wyre CCG",0.44660194174757284,0.28155339805825241,0.20388349514563106,5.8252427184466021E-2,9.7087378640776656E-3]
["P81037:ANSDELL MEDICAL CENTRE","NHS Fylde & Wyre CCG",0.36220472440944884,0.37795275590551181,0.19685039370078741,4.7244094488188976E-2,1.5748031496062964E-2]
["P81059:GREAT ECCLESTON HLTH CTR","NHS Fylde & Wyre CCG",0.37349397590361444,0.24096385542168675,0.24096385542168675,0.10843373493975904,3.6144578313253017E-2]
["P81077:HOLLAND HOUSE SURGERY","NHS Fylde & Wyre CCG",0.54938271604938271,0.2839506172839506,0.12962962962962962,2.4691358024691357E-2,1.2345679012345734E-2]
["P81079:THE THORNTON PRACTICE","NHS Fylde & Wyre CCG",0.44262295081967212,0.18032786885245902,0.27049180327868855,9.8360655737704916E-2,8.1967213114754189E-3]
["P81086:BROADWAY MEDICAL CENTRE","NHS Fylde & Wyre CCG",0.54918032786885251,0.16393442622950818,0.25409836065573771,3.2786885245901641E-2,0]
["P81087:THE OVER-WYRE MED.CTR.","NHS Fylde & Wyre CCG",0.41255605381165922,0.35426008968609868,0.20179372197309417,2.6905829596412557E-2,4.484304932735439E-3]
["P81089:THE MOUNT VIEW PRACTICE","NHS Fylde & Wyre CCG",0.5,0.24675324675324675,0.19480519480519481,4.5454545454545456E-2,1.2987012987013102E-2]
["P81128:KIRKHAM HEALTH CENTRE","NHS Fylde & Wyre CCG",0.53191489361702127,8.5106382978723402E-2,0.31914893617021278,4.2553191489361701E-2,2.1276595744680882E-2]
["P81129:ASH TREE HOUSE SURGERY","NHS Fylde & Wyre CCG",0.4845360824742268,0.20618556701030927,0.20618556701030927,8.247422680412371E-2,2.0618556701030966E-2]
["P81133:THE VILLAGE PRACTICE","NHS Fylde & Wyre CCG",0.5,0.16250000000000001,0.23749999999999999,8.7499999999999994E-2,1.2500000000000067E-2]
["P81149:LOCKWOOD GP SURGERY","NHS Fylde & Wyre CCG",0.31578947368421051,0.48872180451127817,0.14285714285714285,4.5112781954887216E-2,7.5187969924813691E-3]
["P81150:CLIFTON MEDICAL PRACTICE","NHS Fylde & Wyre CCG",0.36290322580645162,0.34677419354838712,0.21774193548387097,5.6451612903225805E-2,1.6129032258064502E-2]
["P81157:FERNBANK SURGERY","NHS Fylde & Wyre CCG",0.38356164383561642,0.30136986301369861,0.22602739726027396,4.7945205479452052E-2,4.1095890410958957E-2]
["P81191:QUEENSWAY MEDICAL CENTRE","NHS Fylde & Wyre CCG",0.41732283464566927,0.2125984251968504,0.24409448818897639,0.11811023622047244,7.8740157480314821E-3]
["P81210:PARK MEDICAL PRACTICE","NHS Fylde & Wyre CCG",0.56565656565656564,0.22222222222222221,0.15151515151515152,5.0505050505050504E-2,1.0101010101010166E-2]
["P81668:FLEETWOOD SURGERY","NHS Fylde & Wyre CCG",0.48717948717948717,0.19230769230769232,0.23076923076923078,3.8461538461538464E-2,5.1282051282051211E-2]
["P81737:THE OLD LINKS SURGERY","NHS Fylde & Wyre CCG",0.34482758620689657,0.31034482758620691,0.31034482758620691,3.4482758620689655E-2,0]
["P81742:BEECHWOOD SURGERY","NHS Fylde & Wyre CCG",0.55000000000000004,0.05,0.25,0.1,4.9999999999999933E-2]
["P81015:LYTHAM ROAD SURGERY","NHS Greater Preston CCG",0.42857142857142855,0.30952380952380953,0.1984126984126984,6.3492063492063489E-2,0]
["P81018:ST FILLAN'S MEDICAL CTRE","NHS Greater Preston CCG",0.54022988505747127,0.14942528735632185,0.22988505747126436,6.8965517241379309E-2,1.1494252873563204E-2]
["P81040:LONGTON HEALTH CENTRE","NHS Greater Preston CCG",0.39316239316239315,0.25641025641025639,0.24786324786324787,9.4017094017094016E-2,8.5470085470086277E-3]
["P81046:PARK VIEW SURGERY","NHS Greater Preston CCG",0.625,0,0.27083333333333331,6.25E-2,4.1666666666666741E-2]
["P81055:BERRY LANE MEDICAL CENTRE","NHS Greater Preston CCG",0.36434108527131781,0.37209302325581395,0.18604651162790697,4.6511627906976744E-2,3.1007751937984551E-2]
["P81067:THE HEALTHCARE CENTRE","NHS Greater Preston CCG",0.42857142857142855,0.26623376623376621,0.18831168831168832,9.7402597402597407E-2,1.9480519480519543E-2]
["P81071:THE NEW HALL LANE PRACTICE","NHS Greater Preston CCG",0.54166666666666663,6.25E-2,0.3125,8.3333333333333329E-2,0]
["P81093:THE GEOFFREY STREET SURGERY","NHS Greater Preston CCG",0.5714285714285714,0.2857142857142857,7.1428571428571425E-2,7.1428571428571425E-2,0]
["P81103:NORTH PRESTON MEDICAL PRACTICE","NHS Greater Preston CCG",0.52941176470588236,0.19607843137254902,0.16666666666666666,9.8039215686274508E-2,9.8039215686275272E-3]
["P81107:STONEBRIDGE SURGERY","NHS Greater Preston CCG",0.3888888888888889,0.40277777777777779,0.15277777777777779,2.7777777777777776E-2,2.7777777777777679E-2]
["P81119:DOCLANDS MEDICAL CENTRE","NHS Greater Preston CCG",0.3728813559322034,0.32203389830508472,0.25423728813559321,3.3898305084745763E-2,1.6949152542372947E-2]
["P81152:THE SURGERY","NHS Greater Preston CCG",0.5,0.19565217391304349,0.17391304347826086,0.13043478260869565,0]
["P81169:FISHERGATE HILL SURGERY","NHS Greater Preston CCG",0.41666666666666669,0.15,0.28333333333333333,0.1,5.0000000000000044E-2]
["P81179:LOSTOCK HALL MEDICAL CTR.","NHS Greater Preston CCG",0.53125,0.15625,0.1875,0.125,0]
["P81184:RIBBLETON MEDICAL CENTRE","NHS Greater Preston CCG",0.46268656716417911,0.11940298507462686,0.37313432835820898,4.4776119402985072E-2,0]
["P81185:RIVERSIDE MEDICAL CENTRE","NHS Greater Preston CCG",0.39047619047619048,0.34285714285714286,0.18095238095238095,7.6190476190476197E-2,9.52380952380949E-3]
["P81196:ISSA MEDICAL CENTRE - PATEL","NHS Greater Preston CCG",0.44776119402985076,0.11940298507462686,0.34328358208955223,7.4626865671641784E-2,1.4925373134328401E-2]
["P81213:ST.MARY'S HEALTH CENTRE","NHS Greater Preston CCG",0.53260869565217395,0.11956521739130435,0.21739130434782608,9.7826086956521743E-2,3.2608695652173947E-2]
["P81647:DR JHA & DR YERRA SURGERY","NHS Greater Preston CCG",0.6470588235294118,0.11764705882352941,0.17647058823529413,5.8823529411764705E-2,0]
["P81664:THE PARK MEDICAL PRACTICE","NHS Greater Preston CCG",0.56521739130434778,7.8260869565217397E-2,0.2608695652173913,6.9565217391304349E-2,2.6086956521739202E-2]
["P81667:ST WALBURGE'S MEDICAL PRACTICE","NHS Greater Preston CCG",0.34285714285714286,0.5714285714285714,5.7142857142857141E-2,0,2.8571428571428581E-2]
["P81685:DR SZ SHAHID","NHS Greater Preston CCG",0.77777777777777779,5.5555555555555552E-2,0.16666666666666666,0,0]
["P81735:DR A HUSSAIN","NHS Greater Preston CCG",0.43478260869565216,0.21739130434782608,0.2608695652173913,4.3478260869565216E-2,4.3478260869565188E-2]
["P81748:BRIARWOOD MEDICAL CENTRE","NHS Greater Preston CCG",0.45454545454545453,0.23636363636363636,0.2,9.0909090909090912E-2,1.8181818181818188E-2]
["P81750:FRENCHWOOD SURGERY","NHS Greater Preston CCG",0.77272727272727271,0,0.18181818181818182,4.5454545454545456E-2,0]
["P81763:DR HP CHAKRABARTI","NHS Greater Preston CCG",0.25,0,0.5,0.25,0]
["P81770:AVENHAM LANE PRACTICE","NHS Greater Preston CCG",0.26666666666666666,6.6666666666666666E-2,0.46666666666666667,0.2,0]
["P81785:MEDICOM LTD","NHS Greater Preston CCG",0.48,0.04,0.36,0.08,4.0000000000000036E-2]
["A82003:ULVERSTON HEALTH CENTRE (MURRAY)","NHS Morecambe Bay CCG",0.45192307692307693,0.17307692307692307,0.28846153846153844,8.6538461538461536E-2,0]
["A82005:AMBLESIDE HEALTH CENTRE","NHS Morecambe Bay CCG",0.55555555555555558,4.4444444444444446E-2,0.28888888888888886,0.1111111111111111,0]
["A82007:DUKE STREET SURGERY","NHS Morecambe Bay CCG",0.38383838383838381,0.27272727272727271,0.26262626262626265,4.0404040404040407E-2,4.0404040404040331E-2]
["A82008:NORWOOD MEDICAL CENTRE","NHS Morecambe Bay CCG",0.53636363636363638,0.15454545454545454,0.24545454545454545,2.7272727272727271E-2,3.6363636363636376E-2]
["A82009:BRIDGEGATE MEDICAL CENTRE","NHS Morecambe Bay CCG",0.54639175257731953,0.17525773195876287,0.19587628865979381,4.1237113402061855E-2,4.1237113402062042E-2]
["A82010:ABBEY ROAD SURGERY","NHS Morecambe Bay CCG",0.546875,0.1875,0.140625,0.109375,1.5625E-2]
["A82025:CAPTAIN FRENCH SURGERY","NHS Morecambe Bay CCG",0.24489795918367346,0.40816326530612246,0.30612244897959184,3.0612244897959183E-2,1.0204081632652962E-2]
["A82026:THE JAMES COCHRANE PRACT.","NHS Morecambe Bay CCG",0.26627218934911245,0.40828402366863903,0.25443786982248523,6.5088757396449703E-2,5.9171597633135287E-3]
["A82027:STATION HOUSE SURGERY","NHS Morecambe Bay CCG",0.37614678899082571,0.22018348623853212,0.29357798165137616,4.5871559633027525E-2,6.4220183486238591E-2]
["A82030:LUNESDALE SURGERY","NHS Morecambe Bay CCG",0.34693877551020408,0.10204081632653061,0.46938775510204084,8.1632653061224483E-2,0]
["A82033:WATERLOO HOUSE SURGERY","NHS Morecambe Bay CCG",0.6,7.3684210526315783E-2,0.27368421052631581,2.1052631578947368E-2,3.157894736842104E-2]
["A82034:STONELEIGH SURGERY","NHS Morecambe Bay CCG",0.44761904761904764,0.2857142857142857,0.19047619047619047,4.7619047619047616E-2,2.857142857142847E-2]
["A82039:DALTON SURGERY","NHS Morecambe Bay CCG",0.25342465753424659,0.49315068493150682,0.21232876712328766,2.7397260273972601E-2,1.3698630136986356E-2]
["A82046:WINDERMERE HEALTH CENTRE","NHS Morecambe Bay CCG",0.47916666666666669,4.1666666666666664E-2,0.41666666666666669,2.0833333333333332E-2,4.166666666666663E-2]
["A82053:NUTWOOD MEDICAL PRACTICE","NHS Morecambe Bay CCG",0.323943661971831,0.40845070422535212,0.22535211267605634,4.2253521126760563E-2,0]
["A82062:ATKINSON HEALTH CENTRE","NHS Morecambe Bay CCG",0.4358974358974359,0.12820512820512819,0.28205128205128205,0.10256410256410256,5.1282051282051322E-2]
["A82065:PENINSULA MEDICAL PRACTICE","NHS Morecambe Bay CCG",0.29411764705882354,0.35294117647058826,0.23529411764705882,3.9215686274509803E-2,7.8431372549019662E-2]
["A82068:ULVERSTON COMMUNITY HEALTH CENTRE","NHS Morecambe Bay CCG",0.34146341463414637,0.24390243902439024,0.26829268292682928,9.7560975609756101E-2,4.8780487804877981E-2]
["A82070:ST.MARY'S SURGERY","NHS Morecambe Bay CCG",0.36,0.1,0.38,0.06,0.10000000000000009]
["A82071:BURNETT EDGAR MEDICAL CTR","NHS Morecambe Bay CCG",0.58536585365853655,7.3170731707317069E-2,0.21951219512195122,2.4390243902439025E-2,9.7560975609756184E-2]
["A82072:RISEDALE SURGERY","NHS Morecambe Bay CCG",0.32558139534883723,0.32558139534883723,0.29069767441860467,2.3255813953488372E-2,3.4883720930232398E-2]
["A82074:ARNSIDE SURGERY","NHS Morecambe Bay CCG",0.41509433962264153,0.30188679245283018,0.20754716981132076,7.5471698113207544E-2,0]
["A82077:LIVERPOOL HOUSE SURGERY","NHS Morecambe Bay CCG",0.57777777777777772,0.1111111111111111,0.22222222222222221,6.6666666666666666E-2,2.2222222222222254E-2]
["A82608:SEDBERGH MEDICAL PRACTICE","NHS Morecambe Bay CCG",0.5,0,0.41666666666666669,2.7777777777777776E-2,5.5555555555555469E-2]
["A82613:WRAYSDALE HOUSE SURGERY","NHS Morecambe Bay CCG",0.2,0.1,0.5,0.2,0]
["A82621:ASKAM SURGERY","NHS Morecambe Bay CCG",0.8,0,0.2,0,0]
["A82629:THE FAMILY PRACTICE","NHS Morecambe Bay CCG",0.48148148148148145,0.14814814814814814,0.35185185185185186,0,1.8518518518518601E-2]
["A82647:CARTMEL SURGERY","NHS Morecambe Bay CCG",0.21212121212121213,0.45454545454545453,0.24242424242424243,9.0909090909090912E-2,0]
["A82650:HAVERTHWAITE SURGERY","NHS Morecambe Bay CCG",0.2857142857142857,0.34693877551020408,0.34693877551020408,2.0408163265306121E-2,0]
["A82651:DUDDON VALLEY MEDICAL PRACTICE","NHS Morecambe Bay CCG",0.24,0.04,0.4,0.2,0.12000000000000011]
["B82061:BENTHAM MEDICAL PRACTICE","NHS Morecambe Bay CCG",0.36363636363636365,0.23376623376623376,0.29870129870129869,7.792207792207792E-2,2.5974025974025983E-2]
["P81002:LANCASTER MEDICAL PRACTICE","NHS Morecambe Bay CCG",0.42814371257485029,0.21257485029940121,0.27844311377245506,7.4850299401197598E-2,5.9880239520958556E-3]
["P81013:QUEEN SQUARE MEDICAL PRACTICE","NHS Morecambe Bay CCG",0.33064516129032256,0.33870967741935482,0.25,4.8387096774193547E-2,3.2258064516129115E-2]
["P81029:ASH TREES SURGERY","NHS Morecambe Bay CCG",0.28061224489795916,0.38775510204081631,0.24489795918367346,7.6530612244897961E-2,1.0204081632653073E-2]
["P81113:PARK VIEW SURGERY","NHS Morecambe Bay CCG",0.46774193548387094,0.19354838709677419,0.27419354838709675,6.4516129032258063E-2,0]
["Y01008:BAY MEDICAL GROUP","NHS Morecambe Bay CCG",0.35633802816901411,0.3352112676056338,0.2380281690140845,5.6338028169014086E-2,1.4084507042253502E-2]
["P81014:ORMSKIRK MEDICAL PRACTICE","NHS West Lancashire CCG",0.45925925925925926,0.34074074074074073,0.16296296296296298,3.7037037037037035E-2,0]
["P81039:MANOR PRIMARY CARE","NHS West Lancashire CCG",0.39534883720930231,0.18604651162790697,0.32558139534883723,6.9767441860465115E-2,2.3255813953488413E-2]
["P81041:PARKGATE SURGERY","NHS West Lancashire CCG",0.3888888888888889,0.34444444444444444,0.24444444444444444,2.2222222222222223E-2,0]
["P81045:THE ELMS PRACTICE","NHS West Lancashire CCG",0.62962962962962965,0.14814814814814814,0.18518518518518517,3.7037037037037035E-2,0]
["P81084:HALL GREEN SURGERY","NHS West Lancashire CCG",0.48936170212765956,0.30851063829787234,0.1702127659574468,3.1914893617021274E-2,0]
["P81096:PARBOLD SURGERY","NHS West Lancashire CCG",0.49275362318840582,0.21739130434782608,0.20289855072463769,4.3478260869565216E-2,4.3478260869565188E-2]
["P81112:BEACON PRIMARY CARE","NHS West Lancashire CCG",0.40677966101694918,0.3559322033898305,0.19774011299435029,3.3898305084745763E-2,5.6497175141242417E-3]
["P81136:DR A BISARYA","NHS West Lancashire CCG",0.5,9.0909090909090912E-2,0.40909090909090912,0,0]
["P81138:BURSCOUGH FAMILY PRACTICE","NHS West Lancashire CCG",0.45454545454545453,0.21212121212121213,0.27272727272727271,3.0303030303030304E-2,3.0303030303030387E-2]
["P81177:VIRAN MEDICAL CENTRE","NHS West Lancashire CCG",0.51851851851851849,0.14814814814814814,0.33333333333333331,0,0]
["P81201:ASHURST PRIMARY CARE","NHS West Lancashire CCG",0.35,0.2,0.42499999999999999,0,2.4999999999999911E-2]
["P81208:SKELMERSDALE PRACTICE","NHS West Lancashire CCG",0.54166666666666663,0.125,0.28333333333333333,2.5000000000000001E-2,2.5000000000000022E-2]
["P81646:LATHOM HOUSE SURGERY","NHS West Lancashire CCG",0.48648648648648651,0.21621621621621623,0.27027027027027029,2.7027027027027029E-2,0]
["P81674:STANLEY COURT SURGERY","NHS West Lancashire CCG",0.50943396226415094,0.16981132075471697,0.30188679245283018,1.8867924528301886E-2,0]
["P81695:AUGHTON SURGERY","NHS West Lancashire CCG",0.3048780487804878,0.43902439024390244,0.21951219512195122,1.2195121951219513E-2,2.4390243902439046E-2]
["P81710:TARLETON GROUP PRACTICE","NHS West Lancashire CCG",0.484375,0.171875,0.34375,0,0]
["P81727:COUNTY ROAD SURGERY","NHS West Lancashire CCG",0.31578947368421051,0.15789473684210525,0.42105263157894735,5.2631578947368418E-2,5.2631578947368585E-2]
["P81758:MATTHEW RYDER CLINIC","NHS West Lancashire CCG",0.41666666666666669,4.1666666666666664E-2,0.45833333333333331,4.1666666666666664E-2,4.166666666666663E-2]

{"sheet":"Annual trend lines","index":5,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,0,9,17],[4,0,4,15],[0,0,1,17],[6,6,6,10],[3,0,3,15],[43,1,44,7],[46,1,46,9]]}
["Annual trends: mortality by setting, 1st January 2006 - 31st December 2017"]
[]
[]
["Please note that these are crude rate comparisons that do not take into account confounding factors such as population demographics (age/gender)."]
["Total = total deaths relating to persons registered to one of the six Lancashire county CCGs"]
[]
[null,null,null,null,null,null,"<< Select CCG"]
[]
[{"$f":"\"Mortality by setting: January 1st 2006 - December 31st 2017, \"&'Trend Raw'!A28","v":"Mortality by setting: January 1st 2006 - December 31st 2017, NHS Chorley and South Ribble CCG"}]
[]
[]
[null,"Grouping",2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017]
[null,"Care home or home",{"$f":"'Trend Raw'!C31","v":0.36437246963562753},{"$f":"'Trend Raw'!D31","v":0.30125247198417932},{"$f":"'Trend Raw'!E31","v":0.34601226993865031},{"$f":"'Trend Raw'!F31","v":0.39239646978954512},{"$f":"'Trend Raw'!G31","v":0.35753424657534244},{"$f":"'Trend Raw'!H31","v":0.39429312581063553},{"$f":"'Trend Raw'!I31","v":0.40817610062893084},{"$f":"'Trend Raw'!J31","v":0.39251743817374762},{"$f":"'Trend Raw'!K31","v":0.40139505389980978},{"$f":"'Trend Raw'!L31","v":0.42254408060453402},{"$f":"'Trend Raw'!M31","v":0.41529051987767585},{"$f":"'Trend Raw'!N31","v":0.43140000000000001}]
[null,"Hospital setting",{"$f":"'Trend Raw'!C32","v":0.53778677462887992},{"$f":"'Trend Raw'!D32","v":0.55174686882003954},{"$f":"'Trend Raw'!E32","v":0.57116564417177917},{"$f":"'Trend Raw'!F32","v":0.53428377460964016},{"$f":"'Trend Raw'!G32","v":0.5547945205479452},{"$f":"'Trend Raw'!H32","v":0.51037613488975353},{"$f":"'Trend Raw'!I32","v":0.50628930817610063},{"$f":"'Trend Raw'!J32","v":0.5218769816106531},{"$f":"'Trend Raw'!K32","v":0.50856055802155997},{"$f":"'Trend Raw'!L32","v":0.50881612090680106},{"$f":"'Trend Raw'!M32","v":0.491131498470948},{"$f":"'Trend Raw'!N32","v":0.4733}]
[null,"Hospice setting",{"$f":"'Trend Raw'!C33","v":7.3549257759784076E-2},{"$f":"'Trend Raw'!D33","v":8.3717864205669082E-2},{"$f":"'Trend Raw'!E33","v":6.0122699386503067E-2},{"$f":"'Trend Raw'!F33","v":5.2953156822810592E-2},{"$f":"'Trend Raw'!G33","v":6.8493150684931503E-2},{"$f":"'Trend Raw'!H33","v":7.9118028534370943E-2},{"$f":"'Trend Raw'!I33","v":6.9182389937106917E-2},{"$f":"'Trend Raw'!J33","v":6.2777425491439443E-2},{"$f":"'Trend Raw'!K33","v":7.2923272035510467E-2},{"$f":"'Trend Raw'!L33","v":5.2267002518891686E-2},{"$f":"'Trend Raw'!M33","v":7.5840978593272171E-2},{"$f":"'Trend Raw'!N33","v":8.0799999999999997E-2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please note: NHS Morecambe Bay CCG figures recorded 2006-2015 are based on the old NHS Lancashire North CCG"]
[]
[]
[null,"Source of data: August 2018 PCMD received from NHS Digital"]

{"sheet":"Trend Raw","index":6,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Area","Grouping","2006 "," 2007"," 2008"," 2009"," 2010"," 2011"," 2012"," 2013"," 2014",2015,2016,2017]
["NHS Chorley and South Ribble CCG","Care home or home",0.36437246963562753,0.30125247198417932,0.34601226993865031,0.39239646978954512,0.35753424657534244,0.39429312581063553,0.40817610062893084,0.39251743817374762,0.40139505389980978,0.42254408060453402,0.41529051987767585,0.43140000000000001]
["NHS Chorley and South Ribble CCG","Hospital setting",0.53778677462887992,0.55174686882003954,0.57116564417177917,0.53428377460964016,0.5547945205479452,0.51037613488975353,0.50628930817610063,0.5218769816106531,0.50856055802155997,0.50881612090680106,0.491131498470948,0.4733]
["NHS Chorley and South Ribble CCG","Hospice setting",7.3549257759784076E-2,8.3717864205669082E-2,6.0122699386503067E-2,5.2953156822810592E-2,6.8493150684931503E-2,7.9118028534370943E-2,6.9182389937106917E-2,6.2777425491439443E-2,7.2923272035510467E-2,5.2267002518891686E-2,7.5840978593272171E-2,8.0799999999999997E-2]
["NHS East Lancashire CCG","Care home or home",0.37284841754580789,0.36218678815489752,0.39479574706211529,0.40033314825097166,0.39182333631751715,0.43519619500594531,0.43760683760683761,0.4401955146635998,0.44701240135287484,0.44513399153737659,0.46482836240855374,0.4703]
["NHS East Lancashire CCG","Hospital setting",0.56829539144919494,0.57687927107061499,0.5472859541130386,0.53997779011660185,0.54491196657714114,0.49762187871581448,0.51111111111111107,0.49482461184588844,0.48449830890642615,0.48377997179125531,0.47017445132245356,0.46450000000000002]
["NHS East Lancashire CCG","Hospice setting",3.720155469183787E-2,3.1036446469248292E-2,3.5534415221040852E-2,3.720155469183787E-2,3.7302297821545809E-2,4.7859690844233055E-2,3.6467236467236465E-2,4.6578493387004025E-2,4.7914317925591886E-2,4.9083215796897041E-2,4.5019696117051207E-2,4.7600000000000003E-2]
["NHS Fylde & Wyre CCG","Care home or home",0.37457434733257661,0.33405172413793105,0.38709677419354838,0.39158231220031964,0.41176470588235292,0.41035218783351118,0.45449871465295627,0.4675855028075549,0.48417721518987344,0.47016460905349794,0.46371769383697814,0.49469999999999997]
["NHS Fylde & Wyre CCG","Hospital setting",0.53575482406356412,0.51724137931034486,0.5370967741935484,0.51411827384123598,0.50700280112044815,0.49893276414087512,0.46992287917737791,0.46809596733027053,0.4530590717299578,0.46141975308641975,0.47067594433399601,0.43230000000000002]
["NHS Fylde & Wyre CCG","Hospice setting",7.3779795686719635E-2,7.5969827586206892E-2,6.2903225806451607E-2,7.7250932338838577E-2,6.6666666666666666E-2,7.8441835645677693E-2,6.4267352185089971E-2,5.3088310362429808E-2,4.7995780590717296E-2,5.1440329218106998E-2,5.1192842942345926E-2,5.8500000000000003E-2]
["NHS Greater Preston CCG","Care home or home",0.33372502937720327,0.34038901601830662,0.31540616246498598,0.35005973715651134,0.34051466187911428,0.37021276595744679,0.37309048178613397,0.3669724770642202,0.38169642857142855,0.42014882655981683,0.44357102751263333,0.42949999999999999]
["NHS Greater Preston CCG","Hospital setting",0.58813160987074031,0.5680778032036613,0.59943977591036413,0.58064516129032262,0.5888689407540395,0.54589665653495445,0.54112808460634543,0.55619266055045868,0.5463169642857143,0.50601030337721808,0.47557551937113979,0.47739999999999999]
["NHS Greater Preston CCG","Hospice setting",5.229142185663925E-2,6.4073226544622428E-2,6.4985994397759109E-2,5.197132616487455E-2,5.4458408138839016E-2,6.8085106382978725E-2,5.9929494712103411E-2,5.9633027522935783E-2,5.5245535714285712E-2,5.7240984544934176E-2,6.3447501403705781E-2,7.4499999999999997E-2]
["NHS Morecambe Bay CCG","Care home or home",0.33107274969173861,0.35017026106696936,0.37383177570093457,0.36748893105629349,0.39889705882352944,0.43234738829452485,0.47522935779816516,0.47477744807121663,0.46594333936106086,0.4932630345635618,0.49058605144523998,0.5252]
["NHS Morecambe Bay CCG","Hospital setting",0.56103575832305796,0.54086265607264472,0.53271028037383172,0.55471220746363059,0.51531862745098034,0.47451227186910006,0.43853211009174314,0.41602373887240357,0.42133815551537068,0.41359109548916229,0.4232299124900557,0.39240000000000003]
["NHS Morecambe Bay CCG","Hospice setting",8.9498806682577564E-2,8.83054892601432E-2,7.4582338902147965E-2,5.7875894988066827E-2,7.5178997613365162E-2,6.7422434367541764E-2,7.1599045346062054E-2,8.8902147971360382E-2,8.8902147971360382E-2,7.1002386634844872E-2,6.0196234420578094E-2,5.9700000000000003E-2]
["NHS West Lancashire CCG","Care home or home",0.3825503355704698,0.43323727185398653,0.41944444444444445,0.40621963070942663,0.39676498572787822,0.45251937984496127,0.46778989098116946,0.45257452574525747,0.49809885931558934,0.47982456140350876,0.48324958123953099,0.52649999999999997]
["NHS West Lancashire CCG","Hospital setting",0.50239693192713331,0.48895292987512007,0.51296296296296295,0.51117589893100102,0.53377735490009515,0.49127906976744184,0.47670961347869178,0.48148148148148145,0.44011406844106465,0.45614035087719296,0.45896147403685095,0.42559999999999998]
["NHS West Lancashire CCG","Hospice setting",9.2042186001917548E-2,6.7243035542747354E-2,4.7222222222222221E-2,6.1224489795918366E-2,4.8525214081826834E-2,3.7790697674418602E-2,3.6669970267591674E-2,4.6070460704607047E-2,4.08745247148289E-2,4.2982456140350879E-2,3.4338358458961472E-2,3.2500000000000001E-2]
[]
[]
[]
[]
[]
[]
[]
[]
["NHS Chorley and South Ribble CCG"]
[]
["Area","Grouping","2006 "," 2007"," 2008"," 2009"," 2010"," 2011"," 2012"," 2013"," 2014",2015,2016,2017]
[{"$f":"$A$28","v":"NHS Chorley and South Ribble CCG"},"Care home or home",{"$f":"SUM(IF($A$2:$A$19=$A31,IF($B$2:$B$19=$B31,IF($C$1:$M$1=C$30,$C$2:$M$19))))","v":0.36437246963562753},{"$f":"SUM(IF($A$2:$A$19=$A31,IF($B$2:$B$19=$B31,IF($C$1:$M$1=D$30,$C$2:$M$19))))","v":0.30125247198417932},{"$f":"SUM(IF($A$2:$A$19=$A31,IF($B$2:$B$19=$B31,IF($C$1:$M$1=E$30,$C$2:$M$19))))","v":0.34601226993865031},{"$f":"SUM(IF($A$2:$A$19=$A31,IF($B$2:$B$19=$B31,IF($C$1:$M$1=F$30,$C$2:$M$19))))","v":0.39239646978954512},{"$f":"SUM(IF($A$2:$A$19=$A31,IF($B$2:$B$19=$B31,IF($C$1:$M$1=G$30,$C$2:$M$19))))","v":0.35753424657534244},{"$f":"SUM(IF($A$2:$A$19=$A31,IF($B$2:$B$19=$B31,IF($C$1:$M$1=H$30,$C$2:$M$19))))","v":0.39429312581063553},{"$f":"SUM(IF($A$2:$A$19=$A31,IF($B$2:$B$19=$B31,IF($C$1:$M$1=I$30,$C$2:$M$19))))","v":0.40817610062893084},{"$f":"SUM(IF($A$2:$A$19=$A31,IF($B$2:$B$19=$B31,IF($C$1:$M$1=J$30,$C$2:$M$19))))","v":0.39251743817374762},{"$f":"SUM(IF($A$2:$A$19=$A31,IF($B$2:$B$19=$B31,IF($C$1:$M$1=K$30,$C$2:$M$19))))","v":0.40139505389980978},{"$f":"SUM(IF($A$2:$A$19=$A31,IF($B$2:$B$19=$B31,IF($C$1:$M$1=L$30,$C$2:$M$19))))","v":0.42254408060453402},{"$f":"SUM(IF($A$2:$A$19=$A31,IF($B$2:$B$19=$B31,IF($C$1:$M$1=M$30,$C$2:$M$19))))","v":0.41529051987767585},{"$f":"SUM(IF($A$2:$A$19=$A31,IF($B$2:$B$19=$B31,IF($C$1:$N$1=N$30,$C$2:$N$19))))","v":0.43140000000000001}]
[{"$f":"$A$28","v":"NHS Chorley and South Ribble CCG"},"Hospital setting",{"$f":"SUM(IF($A$2:$A$19=$A32,IF($B$2:$B$19=$B32,IF($C$1:$M$1=C$30,$C$2:$M$19))))","v":0.53778677462887992},{"$f":"SUM(IF($A$2:$A$19=$A32,IF($B$2:$B$19=$B32,IF($C$1:$M$1=D$30,$C$2:$M$19))))","v":0.55174686882003954},{"$f":"SUM(IF($A$2:$A$19=$A32,IF($B$2:$B$19=$B32,IF($C$1:$M$1=E$30,$C$2:$M$19))))","v":0.57116564417177917},{"$f":"SUM(IF($A$2:$A$19=$A32,IF($B$2:$B$19=$B32,IF($C$1:$M$1=F$30,$C$2:$M$19))))","v":0.53428377460964016},{"$f":"SUM(IF($A$2:$A$19=$A32,IF($B$2:$B$19=$B32,IF($C$1:$M$1=G$30,$C$2:$M$19))))","v":0.5547945205479452},{"$f":"SUM(IF($A$2:$A$19=$A32,IF($B$2:$B$19=$B32,IF($C$1:$M$1=H$30,$C$2:$M$19))))","v":0.51037613488975353},{"$f":"SUM(IF($A$2:$A$19=$A32,IF($B$2:$B$19=$B32,IF($C$1:$M$1=I$30,$C$2:$M$19))))","v":0.50628930817610063},{"$f":"SUM(IF($A$2:$A$19=$A32,IF($B$2:$B$19=$B32,IF($C$1:$M$1=J$30,$C$2:$M$19))))","v":0.5218769816106531},{"$f":"SUM(IF($A$2:$A$19=$A32,IF($B$2:$B$19=$B32,IF($C$1:$M$1=K$30,$C$2:$M$19))))","v":0.50856055802155997},{"$f":"SUM(IF($A$2:$A$19=$A32,IF($B$2:$B$19=$B32,IF($C$1:$M$1=L$30,$C$2:$M$19))))","v":0.50881612090680106},{"$f":"SUM(IF($A$2:$A$19=$A32,IF($B$2:$B$19=$B32,IF($C$1:$M$1=M$30,$C$2:$M$19))))","v":0.491131498470948},{"$f":"SUM(IF($A$2:$A$19=$A32,IF($B$2:$B$19=$B32,IF($C$1:$N$1=N$30,$C$2:$N$19))))","v":0.4733}]
["NHS Chorley and South Ribble CCG","Hospice setting",{"$f":"SUM(IF($A$2:$A$19=$A33,IF($B$2:$B$19=$B33,IF($C$1:$M$1=C$30,$C$2:$M$19))))","v":7.3549257759784076E-2},{"$f":"SUM(IF($A$2:$A$19=$A33,IF($B$2:$B$19=$B33,IF($C$1:$M$1=D$30,$C$2:$M$19))))","v":8.3717864205669082E-2},{"$f":"SUM(IF($A$2:$A$19=$A33,IF($B$2:$B$19=$B33,IF($C$1:$M$1=E$30,$C$2:$M$19))))","v":6.0122699386503067E-2},{"$f":"SUM(IF($A$2:$A$19=$A33,IF($B$2:$B$19=$B33,IF($C$1:$M$1=F$30,$C$2:$M$19))))","v":5.2953156822810592E-2},{"$f":"SUM(IF($A$2:$A$19=$A33,IF($B$2:$B$19=$B33,IF($C$1:$M$1=G$30,$C$2:$M$19))))","v":6.8493150684931503E-2},{"$f":"SUM(IF($A$2:$A$19=$A33,IF($B$2:$B$19=$B33,IF($C$1:$M$1=H$30,$C$2:$M$19))))","v":7.9118028534370943E-2},{"$f":"SUM(IF($A$2:$A$19=$A33,IF($B$2:$B$19=$B33,IF($C$1:$M$1=I$30,$C$2:$M$19))))","v":6.9182389937106917E-2},{"$f":"SUM(IF($A$2:$A$19=$A33,IF($B$2:$B$19=$B33,IF($C$1:$M$1=J$30,$C$2:$M$19))))","v":6.2777425491439443E-2},{"$f":"SUM(IF($A$2:$A$19=$A33,IF($B$2:$B$19=$B33,IF($C$1:$M$1=K$30,$C$2:$M$19))))","v":7.2923272035510467E-2},{"$f":"SUM(IF($A$2:$A$19=$A33,IF($B$2:$B$19=$B33,IF($C$1:$M$1=L$30,$C$2:$M$19))))","v":5.2267002518891686E-2},{"$f":"SUM(IF($A$2:$A$19=$A33,IF($B$2:$B$19=$B33,IF($C$1:$M$1=M$30,$C$2:$M$19))))","v":7.5840978593272171E-2},{"$f":"SUM(IF($A$2:$A$19=$A33,IF($B$2:$B$19=$B33,IF($C$1:$N$1=N$30,$C$2:$N$19))))","v":8.0799999999999997E-2}]

{"sheet":"Usual place of residence","index":7,"n_rows":284,"n_cols":4,"rows_kept":284,"cut":false,"hidden":false,"merged":[[244,1,244,8],[7,0,7,19],[32,0,34,1],[283,0,283,12],[281,0,282,12],[280,0,280,16],[0,0,1,21],[50,0,51,21],[8,0,8,15],[8,16,8,18],[6,0,6,15],[3,0,3,18],[10,0,10,14]]}
["Usual place of residence: rolling 12-month report, 1st April 2017 - 31st March 2018"]
[]
[]
["A death is recorded as 'usual place of residence' if the address the death occurred at matches the deceased individual's usual place of residence address."]
[]
["During the 12-month period 1st April 2017 to 31st March 2018: "]
["●  Females were more likely to die in their usual place of residence than males; this could be influenced by women tending to live longer than males."]
["●  Patients who died from COPD (33%), were significantly less likely to die in their usual place of residence compared to those who died from cancer (39%) or all circulatory disease (40%)."]
[]
[]
["The chart shows the usual place of residence deaths by CCG, gender, age group, condition, dementia and deprivation. Click on the grey boxes below to select the area you are interested in. For GP practice data, please scroll down the page. "]
[]
["Selection"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Data extracted from the PCMD 20/11/2018 by Lancashire county council"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Usual place of death - proportion of deaths recorded as occurring in an individual's usual place of residence, GP practice breakdown, rolling 12-month period, 1st April 2017 - 31st March 2018"]
[]
[]
[null,"Registered CCG","NHS Chorley and South Ribble CCG","<< Select CCG"]
[]
[null,"Sum of Yes"]
[null,"Practice","Total"]
[null,"P81689:EAVES LANE SURGERY",0.58823529411764708]
[null,"P81180:CLAYTON BROOK SURGERY",0.57999999999999996]
[null,"Y00347:DR R BAGHDJIAN SURGERY",0.52173913043478259]
[null,"P81127:THE SURGERY CHORLEY",0.48148148148148145]
[null,"P81033:COPPULL MEDICAL PRACTICE",0.47154471544715448]
[null,"P81741:STATION SURGERY",0.4375]
[null,"P81687:NEW LONGTON SURGERY",0.43478260869565216]
[null,"P81062:REGENT HOUSE SURGERY",0.41666666666666669]
[null,"P81733:ECCLESTON HEALTH CENTRE",0.41666666666666669]
[null,"P81038:THE CHORLEY SURGERY",0.4050632911392405]
[null,"P81655:THE VILLAGE SURGERIES CROSTON&ECCLESTON",0.40277777777777779]
[null,"P81044:LIBRARY HOUSE SURGERY",0.3910891089108911]
[null,"P81083:ROSLEA SURGERY",0.376]
[null,"P81154:GRANVILLE HOUSE MED CTRE",0.37254901960784315]
[null,"P81701:PRESTON ROAD SURGERY",0.37142857142857144]
[null,"P81692:BEECHES MEDICAL CENTRE",0.36666666666666664]
[null,"P81143:WHITTLE SURGERY",0.35802469135802467]
[null,"P81076:SANDY LANE SURGERY",0.34653465346534651]
[null,"P81117:CENTRAL PARK SURGERY",0.34285714285714286]
[null,"P81082:THE RYAN MEDICAL CENTRE",0.33333333333333331]
[null,"P81173:CROSTON MEDICAL CENTRE",0.33333333333333331]
[null,"P81642:MEDICARE UNIT SURGERY",0.31818181818181818]
[null,"Y03656:LEYLAND SURGERY",0.31481481481481483]
[null,"P81057:WORDEN MEDICAL CENTRE",0.31304347826086959]
[null,"Y02466:BUCKSHAW VILLAGE HEALTH CENTRE",0.27777777777777779]
[null,"P81740:ADLINGTON MEDICAL CENTRE",0.25]
[null,"P81181:KINGSFOLD MEDICAL CENTRE",0.23333333333333334]
[null,"P81010:WITHNELL HEALTH CENTRE",0.21739130434782608]
[null,"P81186:MOSS SIDE MEDICAL CENTRE",0.21212121212121213]
[null,"P81171:THE EUXTON MEDICAL CENTRE",0.19230769230769232]
[null,"P81769:LOSTOCK HALL VILLAGE SURGERY",0.16666666666666666]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B54 & \": \" &C54","v":"Registered CCG: NHS Chorley and South Ribble CCG"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Please note that these are crude rate comparisons that do not take into account confounding factors such as population demographics (age/gender). Additionally these rates only take into account a small time frame. "]
["Slight differences in how an address is recorded (for example '2 North Street, Preston, Lancashire' and '2 North Street, Preston, PR1 1AA') and system updates (a person is admitted into a care home and dies before their address details are updated) can affect this measure."]
[]
["Total = total deaths relating to persons registered to one of the six Lancashire county area CCGs"]

{"sheet":"Practice UPD","index":8,"n_rows":191,"n_cols":3,"rows_kept":191,"cut":false,"hidden":true,"merged":[]}
["Registered CCG","Practice","Yes"]
["NHS Chorley and South Ribble CCG","P81010:WITHNELL HEALTH CENTRE",0.21739130434782608]
["NHS Chorley and South Ribble CCG","P81033:COPPULL MEDICAL PRACTICE",0.47154471544715448]
["NHS Chorley and South Ribble CCG","P81038:THE CHORLEY SURGERY",0.4050632911392405]
["NHS Chorley and South Ribble CCG","P81044:LIBRARY HOUSE SURGERY",0.3910891089108911]
["NHS Chorley and South Ribble CCG","P81057:WORDEN MEDICAL CENTRE",0.31304347826086959]
["NHS Chorley and South Ribble CCG","P81062:REGENT HOUSE SURGERY",0.41666666666666669]
["NHS Chorley and South Ribble CCG","P81076:SANDY LANE SURGERY",0.34653465346534651]
["NHS Chorley and South Ribble CCG","P81082:THE RYAN MEDICAL CENTRE",0.33333333333333331]
["NHS Chorley and South Ribble CCG","P81083:ROSLEA SURGERY",0.376]
["NHS Chorley and South Ribble CCG","P81117:CENTRAL PARK SURGERY",0.34285714285714286]
["NHS Chorley and South Ribble CCG","P81127:THE SURGERY CHORLEY",0.48148148148148145]
["NHS Chorley and South Ribble CCG","P81143:WHITTLE SURGERY",0.35802469135802467]
["NHS Chorley and South Ribble CCG","P81154:GRANVILLE HOUSE MED CTRE",0.37254901960784315]
["NHS Chorley and South Ribble CCG","P81171:THE EUXTON MEDICAL CENTRE",0.19230769230769232]
["NHS Chorley and South Ribble CCG","P81173:CROSTON MEDICAL CENTRE",0.33333333333333331]
["NHS Chorley and South Ribble CCG","P81180:CLAYTON BROOK SURGERY",0.57999999999999996]
["NHS Chorley and South Ribble CCG","P81181:KINGSFOLD MEDICAL CENTRE",0.23333333333333334]
["NHS Chorley and South Ribble CCG","P81186:MOSS SIDE MEDICAL CENTRE",0.21212121212121213]
["NHS Chorley and South Ribble CCG","P81642:MEDICARE UNIT SURGERY",0.31818181818181818]
["NHS Chorley and South Ribble CCG","P81655:THE VILLAGE SURGERIES CROSTON&ECCLESTON",0.40277777777777779]
["NHS Chorley and South Ribble CCG","P81687:NEW LONGTON SURGERY",0.43478260869565216]
["NHS Chorley and South Ribble CCG","P81689:EAVES LANE SURGERY",0.58823529411764708]
["NHS Chorley and South Ribble CCG","P81692:BEECHES MEDICAL CENTRE",0.36666666666666664]
["NHS Chorley and South Ribble CCG","P81701:PRESTON ROAD SURGERY",0.37142857142857144]
["NHS Chorley and South Ribble CCG","P81733:ECCLESTON HEALTH CENTRE",0.41666666666666669]
["NHS Chorley and South Ribble CCG","P81740:ADLINGTON MEDICAL CENTRE",0.25]
["NHS Chorley and South Ribble CCG","P81741:STATION SURGERY",0.4375]
["NHS Chorley and South Ribble CCG","P81769:LOSTOCK HALL VILLAGE SURGERY",0.16666666666666666]
["NHS Chorley and South Ribble CCG","Y00347:DR R BAGHDJIAN SURGERY",0.52173913043478259]
["NHS Chorley and South Ribble CCG","Y02466:BUCKSHAW VILLAGE HEALTH CENTRE",0.27777777777777779]
["NHS Chorley and South Ribble CCG","Y03656:LEYLAND SURGERY",0.31481481481481483]
["NHS East Lancashire CCG","P81003:ST JAMES' MEDICAL CENTRE",0.39047619047619048]
["NHS East Lancashire CCG","P81008:YORKSHIRE STREET MEDICAL CENTRE",0.45283018867924529]
["NHS East Lancashire CCG","P81017:WHALLEY MEDICAL CENTRE",0.2988505747126437]
["NHS East Lancashire CCG","P81020:ST. NICHOLAS GROUP PRACTICE",0.36842105263157893]
["NHS East Lancashire CCG","P81025:THE RICHMOND HILL PRACTICE",0.43859649122807015]
["NHS East Lancashire CCG","P81027:IRWELL MEDICAL PRACTICE",0.33846153846153848]
["NHS East Lancashire CCG","P81028:MANCHESTER ROAD SURGERY",0.42857142857142855]
["NHS East Lancashire CCG","P81032:REEDYFORD HLTH CARE GROUP",0.35714285714285715]
["NHS East Lancashire CCG","P81035:COLNE ROAD SURGERY",0.30555555555555558]
["NHS East Lancashire CCG","P81036:PEEL HOUSE MEDICAL PRACTICE",0.40611353711790393]
["NHS East Lancashire CCG","P81047:PARKSIDE SURGERY",0.37984496124031009]
["NHS East Lancashire CCG","P81053:BRIERCLIFFE SURGERY",0.4606741573033708]
["NHS East Lancashire CCG","P81065:THE PENDLE MEDICAL PARTNERSHIP",0.48226950354609927]
["NHS East Lancashire CCG","P81069:PENDLESIDE MEDICAL PRACT",0.4453125]
["NHS East Lancashire CCG","P81070:PENDLE VIEW MEDICAL CTRE",0.45360824742268041]
["NHS East Lancashire CCG","P81078:BARNOLDSWICK MED CTR",0.3963963963963964]
["NHS East Lancashire CCG","P81088:WHITWORTH MEDICAL CENTRE",0.43181818181818182]
["NHS East Lancashire CCG","P81095:THURSBY SURGERY",0.2878787878787879]
["NHS East Lancashire CCG","P81099:DR THM MACKENZIE & PARTNERS",0.33076923076923076]
["NHS East Lancashire CCG","P81100:THE CASTLE MEDICAL GROUP",0.36842105263157893]
["NHS East Lancashire CCG","P81104:OXFORD ROAD MEDICAL CTRE",0.47619047619047616]
["NHS East Lancashire CCG","P81118:ILEX VIEW MEDICAL PRACTICE",0.46575342465753422]
["NHS East Lancashire CCG","P81123:ELMS FEDERATED PRACTICE",0.46853146853146854]
["NHS East Lancashire CCG","P81130:PADIHAM GROUP PRACTICE",0.3380281690140845]
["NHS East Lancashire CCG","P81132:DR DM DOHERTY & PARTNERS",0.42105263157894735]
["NHS East Lancashire CCG","P81134:KIDDROW MEDICAL PRACTICE",0.45945945945945948]
["NHS East Lancashire CCG","P81137:BURNLEY WOOD MEDICAL CENTRE",0.47368421052631576]
["NHS East Lancashire CCG","P81146:MYRTLE HOUSE",0.35294117647058826]
["NHS East Lancashire CCG","P81147:BLACKBURN RD MEDICAL CENTRE",0.38095238095238093]
["NHS East Lancashire CCG","P81160:OSWALD MEDICAL CENTRE",0.41666666666666669]
["NHS East Lancashire CCG","P81165:IGHTENHILL MEDICAL CENTRE",0.34782608695652173]
["NHS East Lancashire CCG","P81166:DR BELLO'S SURGERY",0.4375]
["NHS East Lancashire CCG","P81170:DR MALIK & PARTNER",0.37931034482758619]
["NHS East Lancashire CCG","P81182:RICHMOND MEDICAL CENTRE",0.33333333333333331]
["NHS East Lancashire CCG","P81197:ROSEGROVE SURGERY",0.41176470588235292]
["NHS East Lancashire CCG","P81212:DR MOUJAES",0.34146341463414637]
["NHS East Lancashire CCG","P81215:ROSEHILL SURGERY",0.34375]
["NHS East Lancashire CCG","P81218:THE CLAYTON MEDICAL CTR.",0.44660194174757284]
["NHS East Lancashire CCG","P81620:SLAIDBURN HEALTH CENTRE",0]
["NHS East Lancashire CCG","P81659:THE ROYLE",0.35714285714285715]
["NHS East Lancashire CCG","P81686:ROSSENDALE VALLEY MEDICAL PRACTICE",0.31578947368421051]
["NHS East Lancashire CCG","P81699:HIGHER HEYS SURGERY",0.45]
["NHS East Lancashire CCG","P81711:DILL HALL SURGERY",0.45]
["NHS East Lancashire CCG","P81726:KING STREET MEDICAL CTR",0.26666666666666666]
["NHS East Lancashire CCG","P81730:GREAT HARWOOD MEDICAL GROUP",0.36363636363636365]
["NHS East Lancashire CCG","P81731:DR JEHANGIR (SH)",0.31818181818181818]
["NHS East Lancashire CCG","P81732:HARAMBEE SURGERY",0.44117647058823528]
["NHS East Lancashire CCG","P81736:WHITEFIELD HEALTHCARE",0.23076923076923078]
["NHS East Lancashire CCG","P81738:RISHTON & GREAT HARWOOD SURGERY",0.54545454545454541]
["NHS East Lancashire CCG","P81749:ABBEY SURGERY",0.54545454545454541]
["NHS East Lancashire CCG","P81755:CABIN SURGERY",0.34090909090909088]
["NHS East Lancashire CCG","P81756:DANESHOUSE MEDICAL CENTRE",0.25]
["NHS East Lancashire CCG","P81757:BARROWFORD SURGERY",0.38709677419354838]
["NHS East Lancashire CCG","P81778:DR A K JHA (SH)",0.41666666666666669]
["NHS East Lancashire CCG","P81780:RIVERSIDE FAMILY PRACTICE",0.4375]
["NHS East Lancashire CCG","Y02605:AVHAC REGISTERED PATIENTS",0.375]
["NHS East Lancashire CCG","Y02606:FAIRMORE MEDICAL PRACTICE",0.34615384615384615]
["NHS Fylde & Wyre CCG","P81006:GARSTANG MEDICAL PRACTICE",0.32]
["NHS Fylde & Wyre CCG","P81031:POPLAR HOUSE SURGERY",0.34951456310679613]
["NHS Fylde & Wyre CCG","P81037:ANSDELL MEDICAL CENTRE",0.45669291338582679]
["NHS Fylde & Wyre CCG","P81059:GREAT ECCLESTON HLTH CTR",0.39759036144578314]
["NHS Fylde & Wyre CCG","P81077:HOLLAND HOUSE SURGERY",0.36419753086419754]
["NHS Fylde & Wyre CCG","P81079:THE THORNTON PRACTICE",0.36885245901639346]
["NHS Fylde & Wyre CCG","P81086:BROADWAY MEDICAL CENTRE",0.35245901639344263]
["NHS Fylde & Wyre CCG","P81087:THE OVER-WYRE MED.CTR.",0.37668161434977576]
["NHS Fylde & Wyre CCG","P81089:THE MOUNT VIEW PRACTICE",0.31818181818181818]
["NHS Fylde & Wyre CCG","P81128:KIRKHAM HEALTH CENTRE",0.36170212765957449]
["NHS Fylde & Wyre CCG","P81129:ASH TREE HOUSE SURGERY",0.35051546391752575]
["NHS Fylde & Wyre CCG","P81133:THE VILLAGE PRACTICE",0.32500000000000001]
["NHS Fylde & Wyre CCG","P81149:LOCKWOOD GP SURGERY",0.37593984962406013]
["NHS Fylde & Wyre CCG","P81150:CLIFTON MEDICAL PRACTICE",0.46774193548387094]
["NHS Fylde & Wyre CCG","P81157:FERNBANK SURGERY",0.4452054794520548]
["NHS Fylde & Wyre CCG","P81191:QUEENSWAY MEDICAL CENTRE",0.3543307086614173]
["NHS Fylde & Wyre CCG","P81210:PARK MEDICAL PRACTICE",0.34343434343434343]
["NHS Fylde & Wyre CCG","P81668:FLEETWOOD SURGERY",0.35897435897435898]
["NHS Fylde & Wyre CCG","P81737:THE OLD LINKS SURGERY",0.58620689655172409]
["NHS Fylde & Wyre CCG","P81742:BEECHWOOD SURGERY",0.27500000000000002]
["NHS Greater Preston CCG","P81015:LYTHAM ROAD SURGERY",0.46031746031746029]
["NHS Greater Preston CCG","P81018:ST FILLAN'S MEDICAL CTRE",0.34482758620689657]
["NHS Greater Preston CCG","P81040:LONGTON HEALTH CENTRE",0.47863247863247865]
["NHS Greater Preston CCG","P81046:PARK VIEW SURGERY",0.27083333333333331]
["NHS Greater Preston CCG","P81055:BERRY LANE MEDICAL CENTRE",0.41860465116279072]
["NHS Greater Preston CCG","P81067:THE HEALTHCARE CENTRE",0.37662337662337664]
["NHS Greater Preston CCG","P81071:THE NEW HALL LANE PRACTICE",0.35416666666666669]
["NHS Greater Preston CCG","P81093:THE GEOFFREY STREET SURGERY",0.2857142857142857]
["NHS Greater Preston CCG","P81103:NORTH PRESTON MEDICAL PRACTICE",0.34313725490196079]
["NHS Greater Preston CCG","P81107:STONEBRIDGE SURGERY",0.33333333333333331]
["NHS Greater Preston CCG","P81119:DOCLANDS MEDICAL CENTRE",0.50847457627118642]
["NHS Greater Preston CCG","P81152:THE SURGERY",0.31521739130434784]
["NHS Greater Preston CCG","P81169:FISHERGATE HILL SURGERY",0.4]
["NHS Greater Preston CCG","P81179:LOSTOCK HALL MEDICAL CTR.",0.28125]
["NHS Greater Preston CCG","P81184:RIBBLETON MEDICAL CENTRE",0.47761194029850745]
["NHS Greater Preston CCG","P81185:RIVERSIDE MEDICAL CENTRE",0.4]
["NHS Greater Preston CCG","P81196:ISSA MEDICAL CENTRE - PATEL",0.40298507462686567]
["NHS Greater Preston CCG","P81213:ST.MARY'S HEALTH CENTRE",0.31521739130434784]
["NHS Greater Preston CCG","P81647:DR JHA & DR YERRA SURGERY",0.23529411764705882]
["NHS Greater Preston CCG","P81664:THE PARK MEDICAL PRACTICE",0.32173913043478258]
["NHS Greater Preston CCG","P81667:ST WALBURGE'S MEDICAL PRACTICE",0.31428571428571428]
["NHS Greater Preston CCG","P81685:DR SZ SHAHID",0.22222222222222221]
["NHS Greater Preston CCG","P81735:DR A HUSSAIN",0.47826086956521741]
["NHS Greater Preston CCG","P81748:BRIARWOOD MEDICAL CENTRE",0.36363636363636365]
["NHS Greater Preston CCG","P81750:FRENCHWOOD SURGERY",0.18181818181818182]
["NHS Greater Preston CCG","P81763:DR HP CHAKRABARTI",0.5]
["NHS Greater Preston CCG","P81770:AVENHAM LANE PRACTICE",0.46666666666666667]
["NHS Greater Preston CCG","P81785:MEDICOM LTD",0.36]
["NHS Morecambe Bay CCG","A82003:ULVERSTON HEALTH CENTRE (MURRAY)",0.42307692307692307]
["NHS Morecambe Bay CCG","A82005:AMBLESIDE HEALTH CENTRE",0.33333333333333331]
["NHS Morecambe Bay CCG","A82007:DUKE STREET SURGERY",0.5252525252525253]
["NHS Morecambe Bay CCG","A82008:NORWOOD MEDICAL CENTRE",0.4]
["NHS Morecambe Bay CCG","A82009:BRIDGEGATE MEDICAL CENTRE",0.34020618556701032]
["NHS Morecambe Bay CCG","A82010:ABBEY ROAD SURGERY",0.296875]
["NHS Morecambe Bay CCG","A82025:CAPTAIN FRENCH SURGERY",0.66326530612244894]
["NHS Morecambe Bay CCG","A82026:THE JAMES COCHRANE PRACT.",0.56213017751479288]
["NHS Morecambe Bay CCG","A82027:STATION HOUSE SURGERY",0.44954128440366975]
["NHS Morecambe Bay CCG","A82030:LUNESDALE SURGERY",0.55102040816326525]
["NHS Morecambe Bay CCG","A82033:WATERLOO HOUSE SURGERY",0.35789473684210527]
["NHS Morecambe Bay CCG","A82034:STONELEIGH SURGERY",0.41904761904761906]
["NHS Morecambe Bay CCG","A82039:DALTON SURGERY",0.58904109589041098]
["NHS Morecambe Bay CCG","A82046:WINDERMERE HEALTH CENTRE",0.4375]
["NHS Morecambe Bay CCG","A82053:NUTWOOD MEDICAL PRACTICE",0.54929577464788737]
["NHS Morecambe Bay CCG","A82062:ATKINSON HEALTH CENTRE",0.38461538461538464]
["NHS Morecambe Bay CCG","A82065:PENINSULA MEDICAL PRACTICE",0.50980392156862742]
["NHS Morecambe Bay CCG","A82068:ULVERSTON COMMUNITY HEALTH CENTRE",0.48780487804878048]
["NHS Morecambe Bay CCG","A82070:ST.MARY'S SURGERY",0.48]
["NHS Morecambe Bay CCG","A82071:BURNETT EDGAR MEDICAL CTR",0.36585365853658536]
["NHS Morecambe Bay CCG","A82072:RISEDALE SURGERY",0.51162790697674421]
["NHS Morecambe Bay CCG","A82074:ARNSIDE SURGERY",0.43396226415094341]
["NHS Morecambe Bay CCG","A82077:LIVERPOOL HOUSE SURGERY",0.33333333333333331]
["NHS Morecambe Bay CCG","A82608:SEDBERGH MEDICAL PRACTICE",0.44444444444444442]
["NHS Morecambe Bay CCG","A82613:WRAYSDALE HOUSE SURGERY",0.5]
["NHS Morecambe Bay CCG","A82621:ASKAM SURGERY",0.2]
["NHS Morecambe Bay CCG","A82629:THE FAMILY PRACTICE",0.5]
["NHS Morecambe Bay CCG","A82647:CARTMEL SURGERY",0.63636363636363635]
["NHS Morecambe Bay CCG","A82650:HAVERTHWAITE SURGERY",0.59183673469387754]
["NHS Morecambe Bay CCG","A82651:DUDDON VALLEY MEDICAL PRACTICE",0.44]
["NHS Morecambe Bay CCG","B82061:BENTHAM MEDICAL PRACTICE",0.38961038961038963]
["NHS Morecambe Bay CCG","P81002:LANCASTER MEDICAL PRACTICE",0.3772455089820359]
["NHS Morecambe Bay CCG","P81013:QUEEN SQUARE MEDICAL PRACTICE",0.41935483870967744]
["NHS Morecambe Bay CCG","P81029:ASH TREES SURGERY",0.39285714285714285]
["NHS Morecambe Bay CCG","P81113:PARK VIEW SURGERY",0.40322580645161288]
["NHS Morecambe Bay CCG","Y01008:BAY MEDICAL GROUP",0.40845070422535212]
["NHS West Lancashire CCG","P81014:ORMSKIRK MEDICAL PRACTICE",0.44444444444444442]
["NHS West Lancashire CCG","P81039:MANOR PRIMARY CARE",0.46511627906976744]
["NHS West Lancashire CCG","P81041:PARKGATE SURGERY",0.4777777777777778]
["NHS West Lancashire CCG","P81045:THE ELMS PRACTICE",0.25925925925925924]
["NHS West Lancashire CCG","P81084:HALL GREEN SURGERY",0.37234042553191488]
["NHS West Lancashire CCG","P81096:PARBOLD SURGERY",0.36231884057971014]
["NHS West Lancashire CCG","P81112:BEACON PRIMARY CARE",0.41807909604519772]
["NHS West Lancashire CCG","P81136:DR A BISARYA",0.5]
["NHS West Lancashire CCG","P81138:BURSCOUGH FAMILY PRACTICE",0.42424242424242425]
["NHS West Lancashire CCG","P81177:VIRAN MEDICAL CENTRE",0.40740740740740738]
["NHS West Lancashire CCG","P81201:ASHURST PRIMARY CARE",0.52500000000000002]
["NHS West Lancashire CCG","P81208:SKELMERSDALE PRACTICE",0.34166666666666667]
["NHS West Lancashire CCG","P81646:LATHOM HOUSE SURGERY",0.43243243243243246]
["NHS West Lancashire CCG","P81674:STANLEY COURT SURGERY",0.43396226415094341]
["NHS West Lancashire CCG","P81695:AUGHTON SURGERY",0.56097560975609762]
["NHS West Lancashire CCG","P81710:TARLETON GROUP PRACTICE",0.4375]
["NHS West Lancashire CCG","P81727:COUNTY ROAD SURGERY",0.52631578947368418]
["NHS West Lancashire CCG","P81758:MATTHEW RYDER CLINIC",0.5]

{"sheet":"QOF palliative care","index":9,"n_rows":290,"n_cols":37,"rows_kept":290,"cut":false,"hidden":false,"merged":[[44,21,44,24],[44,25,44,28],[24,2,24,3],[55,1,55,6],[55,0,56,0],[56,8,61,15],[63,8,64,15],[93,0,95,10],[44,29,44,32],[44,33,44,36],[10,21,10,24],[10,25,10,28],[10,29,10,32],[10,33,10,36],[44,0,45,0],[44,1,44,4],[44,5,44,8],[44,9,44,12],[44,13,44,16],[44,17,44,20],[10,0,11,0],[10,1,10,4],[10,5,10,8],[10,9,10,12],[10,13,10,16],[10,17,10,20],[0,0,1,16],[3,0,4,16],[6,0,7,16]]}
["QOF palliative care registers: 2009/10 to 2017/18"]
[]
[]
["Palliative care is the active holistic care of patients with advanced progressive illness(es). Management of pain and other symptoms and provision of psychological, social and spiritual support is paramount. The goal of palliative care is to achieve the best quality of life for patients and their families."]
[]
[]
["The Quality and Outcomes Framework (QOF) register present a total count of all patients recorded as being in need of palliative care/support, irrespective of age, who are not expected to live beyond twelve months. This includes patients who have advanced or irreversible disease and clinical indicators of progressive deterioration and thereby a need for palliative care, and patients who are entitled to a DS 1500 form.*"]
[]
[]
["The table below shows the number of patients (by CCG) on the palliative care register from 2009/10 to 2017/18"]
["CCG Name","2009/10",null,null,null,"2010/11",null,null,null,"2011/12",null,null,null,"2012/13",null,null,null,"2013/14",null,null,null,"2014/15",null,null,null,"2015/16",null,null,null,"2016/17",null,null,null,"2017/18"]
[null,"List size","Register","Crude rate per 10,000","Significance to England","List size","Register","Crude rate per 10,000","Significance to England","List size","Register","Crude rate per 10,000","Significance to England","List size","Register","Crude rate per 10,000","Significance to England","List size","Register","Crude rate per 10,000","Significance to England","List size","Register","Crude rate per 10,000","Significance to England","List size","Register","Crude rate per 10,000","Significance to England","List size","Register","Crude rate per 10,000","Significance to England","List size","Register","Crude rate per 10,000","Significance to England"]
["Chorley and South Ribble CCG",168678,198,{"$f":"C13/B13*10000","v":11.738341692455448},"-",169439,235,{"$f":"G13/F13*10000","v":13.869298095479788},"Low",170588,255,{"$f":"K13/J13*10000","v":14.948296480408938},"Low",174608,302,{"$f":"O13/N13*10000","v":17.29588564097865},"Low",176023,331,{"$f":"S13/R13*10000","v":18.804360793759908},"Low",177605,455,{"$f":"W13/V13*10000","v":25.618648123645169},"Low",179785,517,{"$f":"AA13/Z13*10000","v":28.756570347915567},"Low",181931,858,{"$f":"AE13/AD13*10000","v":47.16073676283866},"High",188203,896,{"$f":"AI13/AH13*10000","v":47.608167776284112},"High"]
["East Lancashire CCG",351852,439,{"$f":"C14/B14*10000","v":12.476836851858168},"-",352041,500,{"$f":"G14/F14*10000","v":14.202891140520563},"Low",354429,686,{"$f":"K14/J14*10000","v":19.355075346543313},"-",367891,808,{"$f":"O14/N14*10000","v":21.96302709226374},"-",371608,933,{"$f":"S14/R14*10000","v":25.107102107597253},"-",373091,1039,{"$f":"W14/V14*10000","v":27.848433760128223},"Low",375488,1196,{"$f":"AA14/Z14*10000","v":31.851883415715019},"-",378849,1309,{"$f":"AE14/AD14*10000","v":34.552024685296786},"-",381783,1682,{"$f":"AI14/AH14*10000","v":44.056440438678514},"High"]
["Fylde & Wyre CCG",143979,240,16.669097576729939,"-",145647,314,21.558974781492235,"High",145282,526,36.205448713536434,"High",151104,816,54.002541296060997,"High",150650,1037,68.835048124792564,"High",150710,1030,68.343175635326119,"High",150877,1061,70.322182970234024,"High",151112,1155,76.433373921329874,"High",177376,1364,76.89879126826628,"High"]
["Greater Preston CCG",197357,238,12.05936450189251,"-",198737,259,13.032298967982811,"Low",201360,278,13.806118394914581,"Low",210949,260,12.325253971339045,"Low",207390,297,14.320844785187328,"Low",210337,321,15.261223655372094,"Low",211855,543,25.630738004767412,"Low",210130,724,34.45486127635273,"-",209377,754,36.011596307139754,"-"]
["Morecambe Bay CCG",102953,150,14.569755130982099,"-",104647,165,15.767293854577771,"-",104806,196,18.701219395836116,"-",111967,266,23.756999830307144,"-",111946,304,27.155950190270307,"-",112122,335,29.878168423681348,"-",112275,414,36.873747494989978,"-",113228,465,41.067580457130745,"-",113697,513,45.119924008549042,"High"]
["West Lancashire CCG",325986,470,14.417797083310326,null,325958,680,20.861583394179618,"High",334960,1035,30.899211846190589,"High",355732.19257151999,1163.663850592,32.71179485275416,"High",353174.77368857601,2039.205581536,{"$f":"S18/R18*10000","v":57.739276229681664},"High",351786.52385606401,2390.1143413760001,67.942180251166548,"High",353483.02556014399,2657.2904709280001,75.174485867239213,"High",360784,2718,75.335935074726152,"High",345853,2585,74.742737521432517,"High"]
["Lancashire total",{"$f":"SUM(B13:B18)","v":1290805},{"$f":"SUM(C13:C18)","v":1735},13.441224662129446,"-",{"$f":"SUM(F13:F18)","v":1296469},{"$f":"SUM(G13:G18)","v":2153},16.606644663312427,"-",{"$f":"SUM(J13:J18)","v":1311425},{"$f":"SUM(K13:K18)","v":2976},22.69287225727739,"High",{"$f":"SUM(N13:N18)","v":1372251.1925715199},{"$f":"SUM(O13:O18)","v":3615.663850592},26.348411064715155,"High",{"$f":"SUM(R13:R18)","v":1370791.773688576},{"$f":"SUM(S13:S18)","v":4941.205581536},36.046361499821565,"High",{"$f":"SUM(V13:V18)","v":1375651.5238560641},{"$f":"SUM(W13:W18)","v":5570.1143413760001},40.490736533061167,"High",{"$f":"SUM(Z13:Z18)","v":1383763.0255601439},{"$f":"SUM(AA13:AA18)","v":6388.2904709280001},46.166072896347522,"High",{"$f":"SUM(AD13:AD18)","v":1396034},{"$f":"SUM(AE13:AE18)","v":7229},51.782406445688288,"High",{"$f":"SUM(AH13:AH18)","v":1416289},{"$f":"SUM(AI13:AI18)","v":7794},55.031141243065505,"High"]
["England",54836561,74907,13.660046989452896,null,55169643,92870,16.83353289054272,null,55525732,113105,20.369835016312795,null,56012096,130233,23.250870669078335,null,56324887,152099,27.003871308254908,null,56817654,177329,31.210193930217532,null,57549410,195573,33.983493488464958,null,58029147,214861,37.026392960765044,null,58383266,225166,38.566872911837443]
["* a DS1500 form is completed by a GP, consultant, hospital doctor or specialist nurse, which enables someone who is terminally ill to claim Disability Living Allowance or Attendance Allowance under the Department for Work and Pensions 'special rules'"]
[]
["The chart shows the trend for the number of patients from the selected CCG on the palliative care register from 2009/10 to 2017/18. The chart for 2017/18 only can be found by scrolling further down"]
[]
[null,null,"<< Select CCG"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The table below shows the values for the "]
["CCG Name","2009/10",null,null,null,"2010/11",null,null,null,"2011/12",null,null,null,"2012/13",null,null,null,"2013/14",null,null,null,"2014/15",null,null,null,"2015/16",null,null,null,"2016/17",null,null,null,"2017/18"]
[null,"List size","Register","Crude Rate Per 10,000","Significance to England","List size","Register","Crude Rate Per 10,000","Significance to England","List size","Register","Crude Rate Per 10,000","Significance to England","List size","Register","Crude Rate Per 10,000","Significance","List size","Register","Crude Rate Per 10,000","Significance to England","List size","Register","Crude Rate Per 10,000","Significance to England","List size","Register","Crude Rate Per 10,000","Significance to England","List size","Register","Crude Rate Per 10,000","Significance to England","List size","Register","Crude Rate Per 10,000","Significance to England"]
[{"$f":"A54","v":"Morecambe Bay CCG"},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=B$46,$B$13:$B$18)))","v":102953},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=C$46,$C$13:$C$18)))","v":150},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=D$46,$D$13:$D$18)))","v":14.569755130982099},{"$f":"VLOOKUP($A47,A13:E18,5,FALSE)","v":"-"},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=F$46,$F$13:$F$18)))","v":104647},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=G$46,$G$13:$G$18)))","v":165},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=H$46,H$13:H$18)))","v":15.767293854577771},{"$f":"VLOOKUP($A47,$A13:I18,9,FALSE)","v":"-"},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=J$46,J$13:J$18)))","v":104806},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=K$46,K$13:K$18)))","v":196},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=L$46,L$13:L$18)))","v":18.701219395836116},{"$f":"VLOOKUP($A47,$A13:M18,13,FALSE)","v":"-"},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=N$46,N$13:N$18)))","v":111967},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=O$46,O$13:O$18)))","v":266},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=P$46,P$13:P$18)))","v":23.756999830307144},{"$f":"VLOOKUP($A47,$A13:Q18,17,FALSE)","v":"-"},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=R$46,R$13:R$18)))","v":111946},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=S$46,S$13:S$18)))","v":304},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=T$46,T$13:T$18)))","v":27.155950190270307},{"$f":"VLOOKUP($A47,$A13:U18,21,FALSE)","v":"-"},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=V$46,V$13:V$18)))","v":112122},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=W$46,W$13:W$18)))","v":335},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=X$46,X$13:X$18)))","v":29.878168423681348},{"$f":"VLOOKUP($A47,$A13:Y18,25,FALSE)","v":"-"},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=Z$46,Z$13:Z$18)))","v":112275},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=AA$46,AA$13:AA$18)))","v":414},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=AB$46,AB$13:AB$18)))","v":36.873747494989978},{"$f":"VLOOKUP($A47,$A13:AC18,29,FALSE)","v":"-"},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=AD$46,AD$13:AD$18)))","v":113228},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=AE$46,AE$13:AE$18)))","v":465},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=AF$46,AF$13:AF$18)))","v":41.067580457130745},{"$f":"VLOOKUP($A47,$A13:AG18,33,FALSE)","v":"-"},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=AH$46,AH$13:AH$18)))","v":113697},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=AI$46,AI$13:AI$18)))","v":513},{"$f":"SUM(IF($A$13:$A$18=$A47,IF($B$12:$E$12=AJ$46,AJ$13:AJ$18)))","v":45.119924008549042},{"$f":"VLOOKUP($A47,$A13:AK18,37,FALSE)","v":"High"}]
["All areas combined",1290805,1735,13.441224662129446,"-",1296469,2153,16.606644663312427,"-",1311425,2976,22.69287225727739,"High",1372251.1925715199,3615.663850592,26.348411064715155,"High",1370791.773688576,4941.205581536,36.046361499821565,"High",1375651.5238560641,5570.1143413760001,40.490736533061167,"High",1383763.0255601439,6388.2904709280001,46.166072896347522,"High",1396034,7229,51.782406445688288,"High",1416289,7794,55.031141243065505,"High"]
["England",54836561,74907,13.660046989452896,null,55169643,92870,16.83353289054272,null,55525732,113105,20.369835016312795,null,56012096,130233,23.250870669078335,null,56324887,152099,27.003871308254908,null,56817654,177329,31.210193930217532,null,57549410,195573,33.983493488464958,null,58029147,214861,37.026392960765044,null,58383266,225166,38.566872911837443]
[]
[]
[]
[]
["Morecambe Bay CCG",{"$f":"A54 & \" QOF pallative care prevalence \" & B56","v":"Morecambe Bay CCG QOF pallative care prevalence 2017/18"},null,null,null,null,null,{"$f":"A54 & \" \" & A1","v":"Morecambe Bay CCG QOF palliative care registers: 2009/10 to 2017/18"}]
["QOF palliative care prevalence for 2017/18"]
["CCG Name","2017/18"]
[null,"List size","Register","Crude rate per 10,000","Significance to England","Lower","Upper",null,"The significance columns refer to the difference between the CCG rate per 10,000 and the England national rate.  Areas with low significance were found to have a significantly smaller number of patients on the palliative care register (crude rate per 10,000) than the England national average, based on the size of registered population for the area and total palliative care register count. Those with high significance were found to have a significantly higher number of patients on the palliative care register. Users should note that CCGs and practices with higher elderly populations will likely have a greater need/demand for palliative care."]
["England",58383266,225166,38.566872911837443,"-",37.895592247531148,38.217599457059059]
["All areas combined",1416289,7794,55.031141243065505,"High",52.540559898736468,55.027212870061661]
["Chorley and South Ribble CCG",188203,896,47.608167776284112,"High",44.583353730221077,51.026820094659008]
["East Lancashire CCG",381783,1682,44.056440438678514,"High",33.30259504865252,37.141861492463498]
["Fylde & Wyre CCG",177376,1364,76.89879126826628,"High",73.835655401255394,82.934418001470448]
["Greater Preston CCG",209377,754,36.011596307139754,"-",33.00448719685599,38.233394297638959]
["Morecambe Bay CCG",345853,2585,74.739999999999995,"High",72.530059306946868,78.222552352344479,null,"Please note these are crude rate comparisons that do not take into account confounding factors such as population demographics (age/gender). "]
["West Lancashire CCG",113697,513,45.12,"High",39.955281848901784,48.023828370209586]
[]
[]
[null,"L2","U2","England","Sig"]
[null,{"$f":"D58-F58","v":0.67128066430629474},{"$f":"G58-D58","v":-0.34927345477838401},{"$f":"$D$58","v":38.566872911837443},"-"]
[null,2.490581344329037,-3.9283730038448539E-3,{"$f":"$D$58","v":38.566872911837443},{"$f":"IF(F59>$G$58,\"High\",IF(G59<$F$58,\"Low\",\"No diff\"))","v":"High"}]
[null,3.0248140460630353,3.418652318374896,38.566872911837443,"High"]
[null,10.753845390025994,-6.9145789462150162,38.566872911837443,"Low"]
[null,3.0631358670108852,6.0356267332041682,38.566872911837443,"High"]
[null,3.0071091102837642,2.2217979904992049,38.566872911837443,"No diff"]
[null,2.2099406930531273,3.4825523523444843,38.566872911837443,"High"]
[null,5.1647181510982136,2.9038283702095882,38.566872911837443,"High"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Practice level QOF palliative register crude rate per 1,000 2016/17 and 2017/18"]
[]
[]
[]
["Patients on the palliative care register, including crude rate per 1,000 and as a percentage of total GP practice list size, 2016/17 and 2017/18"]
["CCG name","Practice code","Practice name","2016/17 all ages on practice register","2017/18 all ages on practice register","No. on 2016/17 palliative care register","No. on 2017/18 palliative care register","2016/17 PC crude rate per 1,000","2017/18 PC crude rate per 1,000","2016/17 PC prevalence  (per cent)","2017/18 PC prevalence  (per cent)"]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81010","WITHNELL HEALTH CENTRE",5272,5321,5,14,0.94840667678300461,2.6310843826348433,9.4840667678300461E-2,{"$f":"G100/E100","v":2.6310843826348432E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81033","COPPULL MEDICAL PRACTICE",8005,8082,79,62,9.8688319800124926,7.6713684731502108,0.98688319800124924,{"$f":"G101/E101","v":7.6713684731502104E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81038","THE CHORLEY SURGERY",8680,8906,35,36,4.032258064516129,4.0422187289467777,0.40322580645161288,{"$f":"G102/E102","v":4.0422187289467773E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81044","LIBRARY HOUSE SURGERY",16492,16234,62,48,3.7593984962406015,2.956757422693113,0.37593984962406013,{"$f":"G103/E103","v":2.9567574226931131E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81057","WORDEN MEDICAL CENTRE",12514,12446,31,38,2.4772255074316765,3.0531897798489473,0.24772255074316765,{"$f":"G104/E104","v":3.0531897798489476E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81062","REGENT HOUSE SURGERY",8225,8124,6,17,0.72948328267477203,2.0925652387986213,7.29483282674772E-2,{"$f":"G105/E105","v":2.0925652387986213E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81076","SANDY LANE SURGERY",11577,11376,50,57,4.3189081800120928,5.0105485232067517,0.43189081800120926,{"$f":"G106/E106","v":5.0105485232067514E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81082","THE RYAN MEDICAL CENTRE",10422,10426,80,77,7.6760698522356554,7.3853826971033953,0.76760698522356552,{"$f":"G107/E107","v":7.3853826971033952E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81083","ROSLEA SURGERY",8490,8460,106,97,12.48527679623086,11.465721040189125,1.248527679623086,{"$f":"G108/E108","v":1.1465721040189124E-2}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81117","CENTRAL PARK SURGERY",4330,4404,22,20,5.0808314087759818,4.5413260672116262,0.5080831408775982,{"$f":"G109/E109","v":4.5413260672116261E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81127","THE SURGERY CHORLEY",3819,3845,16,6,4.1895784236711187,1.5604681404421328,0.41895784236711187,{"$f":"G110/E110","v":1.5604681404421327E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81143","WHITTLE SURGERY",9511,9768,61,69,6.4136263274103662,7.0638820638820645,0.64136263274103666,{"$f":"G111/E111","v":7.0638820638820642E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81154","GRANVILLE HOUSE MED CTRE",8302,8272,30,28,3.6135870874488076,3.3849129593810448,0.36135870874488074,{"$f":"G112/E112","v":3.3849129593810446E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81171","THE EUXTON MEDICAL CENTRE",4249,4262,2,13,0.4706989879971758,3.0502111684655091,4.7069898799717583E-2,{"$f":"G113/E113","v":3.0502111684655091E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81173","CROSTON MEDICAL CENTRE",3942,3908,15,18,3.8051750380517504,4.6059365404298873,0.38051750380517502,{"$f":"G114/E114","v":4.6059365404298872E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81180","CLAYTON BROOK SURGERY",3393,3322,19,13,5.599764220453876,3.9133052378085496,0.55997642204538756,{"$f":"G115/E115","v":3.9133052378085495E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81181","KINGSFOLD MEDICAL CENTRE",4164,4216,21,15,5.043227665706052,3.5578747628083489,0.50432276657060515,{"$f":"G116/E116","v":3.557874762808349E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81186","MOSS SIDE MEDICAL CENTRE",4420,4423,15,39,3.3936651583710407,8.8175446529504846,0.33936651583710409,{"$f":"G117/E117","v":8.8175446529504854E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81642","MEDICARE UNIT SURGERY",2689,2595,10,15,3.718854592785422,5.7803468208092479,0.37188545927854222,{"$f":"G118/E118","v":5.7803468208092483E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81655","THE VILLAGE SURGERIES CROSTON&ECCLESTON",3309,8182,33,63,9.9728014505893015,7.6998288926912739,0.99728014505893015,{"$f":"G119/E119","v":7.6998288926912739E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81687","NEW LONGTON SURGERY",1681,1681,6,14,3.569303985722784,8.3283759666864956,0.35693039857227837,{"$f":"G120/E120","v":8.3283759666864954E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81689","EAVES LANE SURGERY",2062,2066,9,6,4.3646944713870033,2.9041626331074539,0.43646944713870028,{"$f":"G121/E121","v":2.9041626331074541E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81692","BEECHES MEDICAL CENTRE",1810,1951,21,18,11.602209944751381,9.2260379292670436,1.1602209944751383,{"$f":"G122/E122","v":9.226037929267043E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81701","PRESTON ROAD SURGERY",3243,3348,19,24,5.8587727412889308,7.1684587813620073,0.58587727412889301,{"$f":"G123/E123","v":7.1684587813620072E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81733","ECCLESTON HEALTH CENTRE",4682,4771,12,0,2.5630072618539086,0,0.25630072618539085,{"$f":"G124/E124","v":0}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81740","ADLINGTON MEDICAL CENTRE",1799,1892,1,6,0.5558643690939411,3.1712473572938689,5.5586436909394105E-2,{"$f":"G125/E125","v":3.1712473572938688E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81741","STATION SURGERY",2669,2740,18,23,6.7440989134507303,8.3941605839416056,0.67440989134507301,{"$f":"G126/E126","v":8.3941605839416063E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","P81769","LOSTOCK HALL VILLAGE SURGERY",1435,1579,4,5,2.7874564459930316,3.1665611146295127,0.27874564459930312,{"$f":"G127/E127","v":3.1665611146295125E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","Y00347","DR R BAGHDJIAN SURGERY",5272,5308,25,20,4.7420333839150226,3.7678975131876413,0.47420333839150225,{"$f":"G128/E128","v":3.7678975131876413E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","Y02466","BUCKSHAW VILLAGE HEALTH CENTRE",10049,10738,29,27,2.8858592894815405,2.5144347178245483,0.28858592894815405,{"$f":"G129/E129","v":2.5144347178245484E-3}]
["NHS CHORLEY AND SOUTH RIBBLE CCG","Y03656","LEYLAND SURGERY",5424,5557,16,8,2.9498525073746311,1.4396256973186972,0.29498525073746312,{"$f":"G130/E130","v":1.4396256973186971E-3}]
["NHS EAST LANCASHIRE CCG","P81003","ST JAMES' MEDICAL CENTRE",10654,10444,34,41,3.1912896564670548,3.9256989659134431,0.31912896564670545,{"$f":"G131/E131","v":3.925698965913443E-3}]
["NHS EAST LANCASHIRE CCG","P81008","YORKSHIRE STREET MEDICAL CENTRE",5895,6014,29,31,4.9194232400339271,5.1546391752577323,0.49194232400339266,{"$f":"G132/E132","v":5.1546391752577319E-3}]
["NHS EAST LANCASHIRE CCG","P81017","WHALLEY MEDICAL CENTRE",12603,12804,19,28,1.5075775608981989,2.1868166198063106,0.15075775608981989,{"$f":"G133/E133","v":2.1868166198063107E-3}]
["NHS EAST LANCASHIRE CCG","P81020","ST. NICHOLAS GROUP PRACTICE",8989,9026,46,46,5.1173656691511846,5.0963882118324841,0.51173656691511848,{"$f":"G134/E134","v":5.0963882118324842E-3}]
["NHS EAST LANCASHIRE CCG","P81025","THE RICHMOND HILL PRACTICE",10466,11627,47,73,4.4907318937511942,6.2784897221983318,0.44907318937511942,{"$f":"G135/E135","v":6.2784897221983315E-3}]
["NHS EAST LANCASHIRE CCG","P81027","IRWELL MEDICAL PRACTICE",14234,14450,61,59,4.285513559083884,4.0830449826989623,0.42855135590838839,{"$f":"G136/E136","v":4.0830449826989622E-3}]
["NHS EAST LANCASHIRE CCG","P81028","MANCHESTER ROAD SURGERY",4720,4715,5,11,1.0593220338983051,2.3329798515376456,0.1059322033898305,{"$f":"G137/E137","v":2.3329798515376457E-3}]
["NHS EAST LANCASHIRE CCG","P81032","REEDYFORD HLTH CARE GROUP",11341,10880,55,48,4.8496605237633368,4.4117647058823533,0.48496605237633372,{"$f":"G138/E138","v":4.4117647058823529E-3}]
["NHS EAST LANCASHIRE CCG","P81035","COLNE ROAD SURGERY",4305,4179,10,15,2.3228803716608595,3.5893754486719307,0.23228803716608595,{"$f":"G139/E139","v":3.5893754486719309E-3}]
["NHS EAST LANCASHIRE CCG","P81036","PEEL HOUSE MEDICAL PRACTICE",14937,15003,83,92,5.5566713530160001,6.1321069119509426,0.55566713530160006,{"$f":"G140/E140","v":6.1321069119509427E-3}]
["NHS EAST LANCASHIRE CCG","P81047","PARKSIDE SURGERY",10092,10297,72,67,7.134363852556481,6.5067495387005918,0.71343638525564801,{"$f":"G141/E141","v":6.506749538700592E-3}]
["NHS EAST LANCASHIRE CCG","P81053","BRIERCLIFFE SURGERY",7630,7622,19,53,2.490170380078637,6.9535554972448175,0.24901703800786368,{"$f":"G142/E142","v":6.9535554972448175E-3}]
["NHS EAST LANCASHIRE CCG","P81065","THE PENDLE MEDICAL PARTNERSHIP",11660,11974,38,46,3.2590051457975986,3.8416569233338898,0.32590051457975988,{"$f":"G143/E143","v":3.84165692333389E-3}]
["NHS EAST LANCASHIRE CCG","P81069","PENDLESIDE MEDICAL PRACT",10190,10509,18,26,1.7664376840039253,2.4740698448948524,0.17664376840039253,{"$f":"G144/E144","v":2.4740698448948522E-3}]
["NHS EAST LANCASHIRE CCG","P81070","PENDLE VIEW MEDICAL CTRE",7249,7406,19,23,2.6210511794730307,3.1055900621118009,0.26210511794730307,{"$f":"G145/E145","v":3.105590062111801E-3}]
["NHS EAST LANCASHIRE CCG","P81078","BARNOLDSWICK MED CTR",11608,11623,40,41,3.4458993797381119,3.52748860018928,0.34458993797381116,{"$f":"G146/E146","v":3.5274886001892799E-3}]
["NHS EAST LANCASHIRE CCG","P81088","WHITWORTH MEDICAL CENTRE",7201,7264,19,24,2.6385224274406331,3.303964757709251,0.26385224274406333,{"$f":"G147/E147","v":3.3039647577092512E-3}]
["NHS EAST LANCASHIRE CCG","P81095","THURSBY SURGERY",7700,7826,12,10,1.5584415584415585,1.277791975466394,0.15584415584415584,{"$f":"G148/E148","v":1.277791975466394E-3}]
["NHS EAST LANCASHIRE CCG","P81099","DR THM MACKENZIE & PARTNERS",10214,10367,14,31,1.3706677109849228,2.9902575479888105,0.13706677109849227,{"$f":"G149/E149","v":2.9902575479888106E-3}]
["NHS EAST LANCASHIRE CCG","P81100","THE CASTLE MEDICAL GROUP",14524,14481,49,66,3.3737262462131645,4.5576962916925625,0.33737262462131645,{"$f":"G150/E150","v":4.5576962916925624E-3}]
["NHS EAST LANCASHIRE CCG","P81104","OXFORD ROAD MEDICAL CTRE",4515,4645,6,14,1.3289036544850499,3.0139935414424111,0.13289036544850499,{"$f":"G151/E151","v":3.0139935414424113E-3}]
["NHS EAST LANCASHIRE CCG","P81118","ILEX VIEW MEDICAL PRACTICE",7562,7903,24,24,3.173763554615181,3.0368214602049854,0.3173763554615181,{"$f":"G152/E152","v":3.0368214602049855E-3}]
["NHS EAST LANCASHIRE CCG","P81123","ELMS FEDERATED PRACTICE",19623,16557,70,167,3.5672425215308565,10.086368303436613,0.35672425215308567,{"$f":"G153/E153","v":1.0086368303436613E-2}]
["NHS EAST LANCASHIRE CCG","P81130","PADIHAM GROUP PRACTICE",12843,12858,25,47,1.9465856887020168,3.6553118680976824,0.19465856887020166,{"$f":"G154/E154","v":3.6553118680976823E-3}]
["NHS EAST LANCASHIRE CCG","P81132","DR DM DOHERTY & PARTNERS",9014,9062,42,61,4.659418682050144,6.731405870668727,0.46594186820501438,{"$f":"G155/E155","v":6.7314058706687266E-3}]
["NHS EAST LANCASHIRE CCG","P81134","KIDDROW MEDICAL PRACTICE",4080,4145,16,14,3.9215686274509802,3.3775633293124248,0.39215686274509803,{"$f":"G156/E156","v":3.3775633293124246E-3}]
["NHS EAST LANCASHIRE CCG","P81137","BURNLEY WOOD MEDICAL CENTRE",5878,5901,12,15,2.0415107179312688,2.5419420437214031,0.20415107179312689,{"$f":"G157/E157","v":2.541942043721403E-3}]
["NHS EAST LANCASHIRE CCG","P81146","MYRTLE HOUSE",4925,4829,25,26,5.0761421319796947,5.3841375025885281,0.50761421319796951,{"$f":"G158/E158","v":5.3841375025885279E-3}]
["NHS EAST LANCASHIRE CCG","P81147","BLACKBURN RD MEDICAL CENTRE",3741,3998,19,23,5.0788559208767712,5.7528764382191095,0.50788559208767703,{"$f":"G159/E159","v":5.75287643821911E-3}]
["NHS EAST LANCASHIRE CCG","P81160","OSWALD MEDICAL CENTRE",8976,9891,39,34,4.3449197860962565,3.4374684056212716,0.43449197860962568,{"$f":"G160/E160","v":3.4374684056212718E-3}]
["NHS EAST LANCASHIRE CCG","P81165","IGHTENHILL MEDICAL CENTRE",2239,2309,6,14,2.6797677534613666,6.0632308358596791,0.26797677534613668,{"$f":"G161/E161","v":6.0632308358596794E-3}]
["NHS EAST LANCASHIRE CCG","P81166","DR BELLO'S SURGERY",2475,2536,42,51,16.969696969696972,20.110410094637224,1.6969696969696972,{"$f":"G162/E162","v":2.0110410094637224E-2}]
["NHS EAST LANCASHIRE CCG","P81170","DR MALIK & PARTNER",5742,6390,7,5,1.2190874259839777,0.78247261345852892,0.12190874259839776,{"$f":"G163/E163","v":7.8247261345852897E-4}]
["NHS EAST LANCASHIRE CCG","P81182","RICHMOND MEDICAL CENTRE",6039,6006,11,33,1.8214936247723132,5.4945054945054945,0.18214936247723132,{"$f":"G164/E164","v":5.4945054945054949E-3}]
["NHS EAST LANCASHIRE CCG","P81197","ROSEGROVE SURGERY",4470,4489,13,14,2.9082774049217002,3.1187346847850299,0.29082774049217003,{"$f":"G165/E165","v":3.1187346847850301E-3}]
["NHS EAST LANCASHIRE CCG","P81212","DR MOUJAES",4994,4937,8,14,1.6019223067681216,2.8357302005266356,0.16019223067681218,{"$f":"G166/E166","v":2.8357302005266355E-3}]
["NHS EAST LANCASHIRE CCG","P81215","ROSEHILL SURGERY",6302,6547,51,48,8.0926689939701681,7.3316022605773643,0.80926689939701668,{"$f":"G167/E167","v":7.3316022605773639E-3}]
["NHS EAST LANCASHIRE CCG","P81218","THE CLAYTON MEDICAL CTR.",6600,6603,23,25,3.4848484848484849,3.786157807057398,0.34848484848484845,{"$f":"G168/E168","v":3.786157807057398E-3}]
["NHS EAST LANCASHIRE CCG","P81620","SLAIDBURN HEALTH CENTRE",1053,1101,2,3,1.8993352326685662,2.7247956403269753,0.18993352326685661,{"$f":"G169/E169","v":2.7247956403269754E-3}]
["NHS EAST LANCASHIRE CCG","P81659","THE ROYLE",3918,4044,7,5,1.7866258295048494,1.2363996043521266,0.17866258295048493,{"$f":"G170/E170","v":1.2363996043521265E-3}]
["NHS EAST LANCASHIRE CCG","P81686","ROSSENDALE VALLEY MEDICAL PRACTICE",2589,2612,4,3,1.5449980687524141,1.1485451761102605,0.1544998068752414,{"$f":"G171/E171","v":1.1485451761102604E-3}]
["NHS EAST LANCASHIRE CCG","P81699","HIGHER HEYS SURGERY",2292,2274,4,1,1.7452006980802792,0.43975373790677225,0.17452006980802792,{"$f":"G172/E172","v":4.3975373790677223E-4}]
["NHS EAST LANCASHIRE CCG","P81711","DILL HALL SURGERY",2578,2621,27,37,10.473235065942591,14.11674933231591,1.047323506594259,{"$f":"G173/E173","v":1.4116749332315911E-2}]
["NHS EAST LANCASHIRE CCG","P81726","KING STREET MEDICAL CTR",2081,1986,6,16,2.8832292167227291,8.0563947633434037,0.28832292167227291,{"$f":"G174/E174","v":8.0563947633434038E-3}]
["NHS EAST LANCASHIRE CCG","P81730","GREAT HARWOOD MEDICAL GROUP",8354,8452,22,31,2.6334689968877187,3.6677709417889259,0.26334689968877184,{"$f":"G175/E175","v":3.6677709417889258E-3}]
["NHS EAST LANCASHIRE CCG","P81731","DR JEHANGIR (SH)",2742,2781,6,4,2.1881838074398248,1.4383315354189139,0.21881838074398249,{"$f":"G176/E176","v":1.438331535418914E-3}]
["NHS EAST LANCASHIRE CCG","P81732","HARAMBEE SURGERY",4125,4146,13,12,3.1515151515151518,2.8943560057887119,0.31515151515151518,{"$f":"G177/E177","v":2.8943560057887118E-3}]
["NHS EAST LANCASHIRE CCG","P81736","WHITEFIELD HEALTHCARE",3700,3925,8,22,2.1621621621621623,5.6050955414012735,0.21621621621621623,{"$f":"G178/E178","v":5.6050955414012737E-3}]
["NHS EAST LANCASHIRE CCG","P81738","RISHTON & GREAT HARWOOD SURGERY",1080,1001,2,2,1.8518518518518519,1.9980019980019981,0.1851851851851852,{"$f":"G179/E179","v":1.998001998001998E-3}]
["NHS EAST LANCASHIRE CCG","P81749","ABBEY SURGERY",1494,1604,3,11,2.0080321285140559,6.8578553615960098,0.20080321285140559,{"$f":"G180/E180","v":6.8578553615960096E-3}]
["NHS EAST LANCASHIRE CCG","P81755","CABIN SURGERY",4489,4521,16,22,3.5642682111828918,4.8661800486618008,0.35642682111828916,{"$f":"G181/E181","v":4.8661800486618006E-3}]
["NHS EAST LANCASHIRE CCG","P81756","DANESHOUSE MEDICAL CENTRE",3293,3215,1,1,0.30367446097783179,0.31104199066874028,3.036744609778318E-2,{"$f":"G182/E182","v":3.1104199066874026E-4}]
["NHS EAST LANCASHIRE CCG","P81757","BARROWFORD SURGERY",3260,3315,18,10,5.5214723926380369,3.0165912518853695,0.55214723926380371,{"$f":"G183/E183","v":3.0165912518853697E-3}]
["NHS EAST LANCASHIRE CCG","P81778","DR A K JHA (SH)",2832,3071,8,9,2.8248587570621471,2.9306414848583522,0.2824858757062147,{"$f":"G184/E184","v":2.9306414848583521E-3}]
["NHS EAST LANCASHIRE CCG","P81780","RIVERSIDE FAMILY PRACTICE",4463,4552,24,24,5.3775487340354022,5.272407732864675,0.53775487340354022,{"$f":"G185/E185","v":5.272407732864675E-3}]
["NHS EAST LANCASHIRE CCG","Y02605","AVHAC REGISTERED PATIENTS",2564,2564,1,3,0.39001560062402496,1.1700468018720749,3.9001560062402497E-2,{"$f":"G186/E186","v":1.1700468018720749E-3}]
["NHS EAST LANCASHIRE CCG","Y02606","FAIRMORE MEDICAL PRACTICE",5712,5881,9,6,1.5756302521008403,1.0202346539704132,0.15756302521008403,{"$f":"G187/E187","v":1.0202346539704133E-3}]
["NHS GREATER PRESTON CCG","P81015","LYTHAM ROAD SURGERY",11110,11289,32,33,2.8802880288028803,2.9231995748073345,0.28802880288028804,{"$f":"G188/E188","v":2.9231995748073346E-3}]
["NHS GREATER PRESTON CCG","P81018","ST FILLAN'S MEDICAL CTRE",8895,8784,34,28,3.822372119168072,3.1876138433515484,0.38223721191680715,{"$f":"G189/E189","v":3.1876138433515485E-3}]
["NHS GREATER PRESTON CCG","P81040","LONGTON HEALTH CENTRE",10690,10516,37,57,3.4611786716557531,5.4203119056675542,0.3461178671655753,{"$f":"G190/E190","v":5.4203119056675545E-3}]
["NHS GREATER PRESTON CCG","P81046","PARK VIEW SURGERY",5835,6091,17,16,2.9134532990574118,2.6268264652766375,0.29134532990574119,{"$f":"G191/E191","v":2.6268264652766376E-3}]
["NHS GREATER PRESTON CCG","P81055","BERRY LANE MEDICAL CENTRE",10237,10640,41,40,4.0050796131679203,3.7593984962406015,0.400507961316792,{"$f":"G192/E192","v":3.7593984962406013E-3}]
["NHS GREATER PRESTON CCG","P81067","THE HEALTHCARE CENTRE",13414,13393,53,45,3.951095869986581,3.359964160382289,0.39510958699865811,{"$f":"G193/E193","v":3.3599641603822891E-3}]
["NHS GREATER PRESTON CCG","P81071","THE NEW HALL LANE PRACTICE",6896,6982,14,19,2.0301624129930396,2.7212832999140648,0.20301624129930393,{"$f":"G194/E194","v":2.7212832999140646E-3}]
["NHS GREATER PRESTON CCG","P81093","THE GEOFFREY STREET SURGERY",1782,1659,1,2,0.5611672278338945,1.2055455093429777,5.6116722783389458E-2,{"$f":"G195/E195","v":1.2055455093429777E-3}]
["NHS GREATER PRESTON CCG","P81103","NORTH PRESTON MEDICAL PRACTICE",9632,9841,36,39,3.7375415282392028,3.9630118890356671,0.37375415282392027,{"$f":"G196/E196","v":3.9630118890356669E-3}]
["NHS GREATER PRESTON CCG","P81107","STONEBRIDGE SURGERY",7564,7509,41,34,5.4204124801692224,4.5278998535091217,0.54204124801692222,{"$f":"G197/E197","v":4.527899853509122E-3}]
["NHS GREATER PRESTON CCG","P81119","DOCLANDS MEDICAL CENTRE",6810,6840,57,50,8.3700440528634363,7.3099415204678362,0.83700440528634357,{"$f":"G198/E198","v":7.3099415204678359E-3}]
["NHS GREATER PRESTON CCG","P81152","THE SURGERY",8703,12200,18,78,2.0682523267838677,6.3934426229508192,0.20682523267838679,{"$f":"G199/E199","v":6.3934426229508194E-3}]
["NHS GREATER PRESTON CCG","P81169","FISHERGATE HILL SURGERY",6255,6229,24,23,3.8369304556354917,3.692406485792262,0.38369304556354916,{"$f":"G200/E200","v":3.692406485792262E-3}]
["NHS GREATER PRESTON CCG","P81179","LOSTOCK HALL MEDICAL CTR.",3806,3814,10,12,2.627430373095113,3.146303093864709,0.26274303730951132,{"$f":"G201/E201","v":3.146303093864709E-3}]
["NHS GREATER PRESTON CCG","P81184","RIBBLETON MEDICAL CENTRE",8284,8330,14,11,1.6900048285852245,1.3205282112845138,0.16900048285852245,{"$f":"G202/E202","v":1.3205282112845138E-3}]
["NHS GREATER PRESTON CCG","P81185","RIVERSIDE MEDICAL CENTRE",11399,11304,77,72,6.7549785068865695,6.369426751592357,0.67549785068865686,{"$f":"G203/E203","v":6.369426751592357E-3}]
["NHS GREATER PRESTON CCG","P81196","ISSA MEDICAL CENTRE - PATEL",11693,12475,27,34,2.3090738048405028,2.7254509018036073,0.2309073804840503,{"$f":"G204/E204","v":2.7254509018036074E-3}]
["NHS GREATER PRESTON CCG","P81213","ST.MARY'S HEALTH CENTRE",17475,18904,29,22,1.659513590844063,1.1637748624629709,0.16595135908440631,{"$f":"G205/E205","v":1.1637748624629708E-3}]
["NHS GREATER PRESTON CCG","P81647","DR JHA & DR YERRA SURGERY",1955,2040,7,19,3.5805626598465476,9.3137254901960791,0.35805626598465473,{"$f":"G206/E206","v":9.3137254901960783E-3}]
["NHS GREATER PRESTON CCG","P81664","THE PARK MEDICAL PRACTICE",15719,15894,34,45,2.1629874673961447,2.8312570781426953,0.21629874673961447,{"$f":"G207/E207","v":2.8312570781426952E-3}]
["NHS GREATER PRESTON CCG","P81667","ST WALBURGE'S MEDICAL PRACTICE",1705,3392,21,20,12.316715542521996,5.8962264150943398,1.2316715542521994,{"$f":"G208/E208","v":5.89622641509434E-3}]
["NHS GREATER PRESTON CCG","P81685","DR SZ SHAHID",2465,2411,1,2,0.40567951318458417,0.82953131480713393,4.0567951318458417E-2,{"$f":"G209/E209","v":8.2953131480713392E-4}]
["NHS GREATER PRESTON CCG","P81735","DR A HUSSAIN",3053,3189,9,6,2.9479200786112019,1.8814675446848543,0.2947920078611202,{"$f":"G210/E210","v":1.8814675446848542E-3}]
["NHS GREATER PRESTON CCG","P81748","BRIARWOOD MEDICAL CENTRE",5925,6040,28,32,4.7257383966244717,5.298013245033113,0.4725738396624472,{"$f":"G211/E211","v":5.2980132450331126E-3}]
["NHS GREATER PRESTON CCG","P81750","FRENCHWOOD SURGERY",2006,2042,2,2,0.99700897308075764,0.97943192948090108,9.970089730807577E-2,{"$f":"G212/E212","v":9.7943192948090111E-4}]
["NHS GREATER PRESTON CCG","P81763","DR HP CHAKRABARTI",1921,1856,2,1,1.0411244143675169,0.5387931034482758,0.10411244143675169,{"$f":"G213/E213","v":5.3879310344827585E-4}]
["NHS GREATER PRESTON CCG","P81770","AVENHAM LANE PRACTICE",3356,3645,0,5,0,1.371742112482853,0,{"$f":"G214/E214","v":1.3717421124828531E-3}]
["NHS GREATER PRESTON CCG","P81785","MEDICOM LTD",2122,2068,8,7,3.7700282752120642,3.3849129593810448,0.3770028275212064,{"$f":"G215/E215","v":3.3849129593810446E-3}]
["NHS MORECAMBE BAY CCG","A82003","ULVERSTON HEALTH CENTRE (MURRAY)",11055,10884,43,34,3.8896426956128445,3.1238515251745684,0.38896426956128449,{"$f":"G216/E216","v":3.1238515251745683E-3}]
["NHS MORECAMBE BAY CCG","A82005","AMBLESIDE HEALTH CENTRE",6332,6363,68,51,10.739102969046115,8.015087223008015,1.0739102969046115,{"$f":"G217/E217","v":8.0150872230080154E-3}]
["NHS MORECAMBE BAY CCG","A82007","DUKE STREET SURGERY",9535,9532,37,40,3.8804404824331411,4.1963911036508605,0.38804404824331407,{"$f":"G218/E218","v":4.1963911036508603E-3}]
["NHS MORECAMBE BAY CCG","A82008","NORWOOD MEDICAL CENTRE",10954,10964,96,103,8.7639218550301266,9.3943816125501645,0.87639218550301257,{"$f":"G219/E219","v":9.3943816125501636E-3}]
["NHS MORECAMBE BAY CCG","A82009","BRIDGEGATE MEDICAL CENTRE",8947,8950,62,55,6.9296971051749185,6.1452513966480442,0.6929697105174919,{"$f":"G220/E220","v":6.1452513966480443E-3}]
["NHS MORECAMBE BAY CCG","A82010","ABBEY ROAD SURGERY",6665,6715,59,80,8.8522130532633145,11.913626209977663,0.88522130532633148,{"$f":"G221/E221","v":1.1913626209977662E-2}]
["NHS MORECAMBE BAY CCG","A82025","CAPTAIN FRENCH SURGERY",9760,9959,51,49,5.2254098360655741,4.9201727081032232,0.52254098360655743,{"$f":"G222/E222","v":4.9201727081032232E-3}]
["NHS MORECAMBE BAY CCG","A82026","THE JAMES COCHRANE PRACT.",17022,17318,119,116,6.9909528845024091,6.6982330523155102,0.69909528845024083,{"$f":"G223/E223","v":6.69823305231551E-3}]
["NHS MORECAMBE BAY CCG","A82027","STATION HOUSE SURGERY",10366,10256,109,101,10.515145668531739,9.8478939157566305,1.0515145668531738,{"$f":"G224/E224","v":9.8478939157566302E-3}]
["NHS MORECAMBE BAY CCG","A82030","LUNESDALE SURGERY",5981,6018,15,12,2.5079418157498745,1.9940179461615153,0.25079418157498745,{"$f":"G225/E225","v":1.9940179461615153E-3}]
["NHS MORECAMBE BAY CCG","A82033","WATERLOO HOUSE SURGERY",8365,8312,58,56,6.9336521219366407,6.7372473532242534,0.69336521219366409,{"$f":"G226/E226","v":6.7372473532242537E-3}]
["NHS MORECAMBE BAY CCG","A82034","STONELEIGH SURGERY",6593,6546,47,50,7.1287729409980276,7.6382523678582341,0.71287729409980283,{"$f":"G227/E227","v":7.6382523678582342E-3}]
["NHS MORECAMBE BAY CCG","A82039","DALTON SURGERY",8543,8628,50,67,5.8527449373756291,7.7654149281409364,0.58527449373756291,{"$f":"G228/E228","v":7.7654149281409365E-3}]
["NHS MORECAMBE BAY CCG","A82046","WINDERMERE HEALTH CENTRE",5783,5848,35,40,6.0522220300881893,6.8399452804377567,0.6052222030088189,{"$f":"G229/E229","v":6.8399452804377564E-3}]
["NHS MORECAMBE BAY CCG","A82053","NUTWOOD MEDICAL PRACTICE",4788,4839,44,68,9.1896407685881361,14.052490183922298,0.91896407685881365,{"$f":"G230/E230","v":1.4052490183922298E-2}]
["NHS MORECAMBE BAY CCG","A82062","ATKINSON HEALTH CENTRE",4721,4729,39,44,8.2609616606651137,9.3042926622964686,0.82609616606651137,{"$f":"G231/E231","v":9.3042926622964681E-3}]
["NHS MORECAMBE BAY CCG","A82065","PENINSULA MEDICAL PRACTICE",2945,2959,22,20,7.4702886247877753,6.7590402162892866,0.74702886247877753,{"$f":"G232/E232","v":6.7590402162892868E-3}]
["NHS MORECAMBE BAY CCG","A82068","ULVERSTON COMMUNITY HEALTH CENTRE",4258,4332,27,31,6.3410051667449503,7.1560480147737771,0.63410051667449507,{"$f":"G233/E233","v":7.1560480147737767E-3}]
["NHS MORECAMBE BAY CCG","A82070","ST.MARY'S SURGERY",6115,6127,45,31,7.3589533932951756,5.0595723845275007,0.73589533932951756,{"$f":"G234/E234","v":5.059572384527501E-3}]
["NHS MORECAMBE BAY CCG","A82071","BURNETT EDGAR MEDICAL CTR",4263,4272,53,40,12.432559230588787,9.3632958801498134,1.2432559230588787,{"$f":"G235/E235","v":9.3632958801498131E-3}]
["NHS MORECAMBE BAY CCG","A82072","RISEDALE SURGERY",6868,6837,51,57,7.4257425742574252,8.3369899078543224,0.74257425742574257,{"$f":"G236/E236","v":8.3369899078543225E-3}]
["NHS MORECAMBE BAY CCG","A82074","ARNSIDE SURGERY",2276,2274,18,21,7.9086115992970125,9.2348284960422173,0.7908611599297013,{"$f":"G237/E237","v":9.2348284960422165E-3}]
["NHS MORECAMBE BAY CCG","A82077","LIVERPOOL HOUSE SURGERY",5262,5228,70,89,13.30292664386165,17.023718439173681,1.330292664386165,{"$f":"G238/E238","v":1.702371843917368E-2}]
["NHS MORECAMBE BAY CCG","A82608","SEDBERGH MEDICAL PRACTICE",4170,4197,15,13,3.5971223021582737,3.0974505599237552,0.35971223021582738,{"$f":"G239/E239","v":3.0974505599237552E-3}]
["NHS MORECAMBE BAY CCG","A82613","WRAYSDALE HOUSE SURGERY",969,1002,2,1,2.0639834881320946,0.99800399201596801,0.20639834881320948,{"$f":"G240/E240","v":9.9800399201596798E-4}]
["NHS MORECAMBE BAY CCG","A82621","ASKAM SURGERY",1640,1617,1,3,0.6097560975609756,1.8552875695732838,6.097560975609756E-2,{"$f":"G241/E241","v":1.8552875695732839E-3}]
["NHS MORECAMBE BAY CCG","A82629","THE FAMILY PRACTICE",3586,3438,51,55,14.221974344673731,15.997673065735892,1.4221974344673731,{"$f":"G242/E242","v":1.5997673065735893E-2}]
["NHS MORECAMBE BAY CCG","A82647","CARTMEL SURGERY",2512,2601,41,40,16.321656050955415,15.378700499807767,1.6321656050955413,{"$f":"G243/E243","v":1.5378700499807767E-2}]
["NHS MORECAMBE BAY CCG","A82650","HAVERTHWAITE SURGERY",2745,2756,8,8,2.9143897996357011,2.9027576197387517,0.29143897996357016,{"$f":"G244/E244","v":2.9027576197387518E-3}]
["NHS MORECAMBE BAY CCG","A82651","DUDDON VALLEY MEDICAL PRACTICE",3353,3320,24,24,7.1577691619445281,7.2289156626506026,0.71577691619445272,{"$f":"G245/E245","v":7.2289156626506026E-3}]
["NHS MORECAMBE BAY CCG","B82061","BENTHAM MEDICAL PRACTICE",7211,7191,73,63,10.123422548883651,8.7609511889862333,1.0123422548883649,{"$f":"G246/E246","v":8.7609511889862324E-3}]
["NHS MORECAMBE BAY CCG","P81002","LANCASTER MEDICAL PRACTICE",13069,55505,127,366,9.7176524600198935,6.5940005404918471,0.97176524600198944,{"$f":"G247/E247","v":6.5940005404918475E-3}]
["NHS MORECAMBE BAY CCG","P81013","QUEEN SQUARE MEDICAL PRACTICE",14040,14314,72,68,5.1282051282051286,4.7505938242280283,0.51282051282051277,{"$f":"G248/E248","v":4.7505938242280287E-3}]
["NHS MORECAMBE BAY CCG","P81029","ASH TREES SURGERY",15061,14985,196,187,13.013744107296992,12.479145812479146,1.3013744107296992,{"$f":"G249/E249","v":1.2479145812479145E-2}]
["NHS MORECAMBE BAY CCG","P81113","PARK VIEW SURGERY",6055,6097,50,51,8.257638315441783,8.3647695587994093,0.82576383154417832,{"$f":"G250/E250","v":8.3647695587994089E-3}]
["NHS MORECAMBE BAY CCG","Y01008","BAY MEDICAL GROUP",54116,60940,415,451,7.6687116564417179,7.4007220216606502,0.76687116564417179,{"$f":"G251/E251","v":7.40072202166065E-3}]
["NHS WEST LANCASHIRE CCG","P81014","ORMSKIRK MEDICAL PRACTICE",8781,8728,44,60,5.0108188133469991,6.8744271310724105,0.50108188133469989,{"$f":"G252/E252","v":6.8744271310724105E-3}]
["NHS WEST LANCASHIRE CCG","P81039","MANOR PRIMARY CARE",5266,5300,14,12,2.658564375237372,2.2641509433962264,0.26585643752373722,{"$f":"G253/E253","v":2.2641509433962265E-3}]
["NHS WEST LANCASHIRE CCG","P81041","PARKGATE SURGERY",6558,6756,33,31,5.0320219579139982,4.5885139135583186,0.5032021957913998,{"$f":"G254/E254","v":4.5885139135583182E-3}]
["NHS WEST LANCASHIRE CCG","P81045","THE ELMS PRACTICE",6175,5648,22,25,3.5627530364372468,4.4263456090651561,0.35627530364372467,{"$f":"G255/E255","v":4.4263456090651559E-3}]
["NHS WEST LANCASHIRE CCG","P81084","HALL GREEN SURGERY",7102,7198,28,29,3.9425513939735288,4.0288969158099475,0.39425513939735291,{"$f":"G256/E256","v":4.0288969158099475E-3}]
["NHS WEST LANCASHIRE CCG","P81096","PARBOLD SURGERY",6943,6991,15,19,2.1604493734696817,2.7177800028608208,0.2160449373469682,{"$f":"G257/E257","v":2.7177800028608209E-3}]
["NHS WEST LANCASHIRE CCG","P81112","BEACON PRIMARY CARE",12463,16117,49,82,3.9316376474364119,5.0877954954395985,0.39316376474364118,{"$f":"G258/E258","v":5.0877954954395982E-3}]
["NHS WEST LANCASHIRE CCG","P81136","DR A BISARYA",2477,2468,16,10,6.4594267258780782,4.0518638573743919,0.6459426725878078,{"$f":"G259/E259","v":4.0518638573743921E-3}]
["NHS WEST LANCASHIRE CCG","P81138","BURSCOUGH FAMILY PRACTICE",2738,2784,10,14,3.652300949598247,5.0287356321839081,0.36523009495982472,{"$f":"G260/E260","v":5.028735632183908E-3}]
["NHS WEST LANCASHIRE CCG","P81177","VIRAN MEDICAL CENTRE",2337,2185,14,10,5.9905862216516903,4.5766590389016022,0.59905862216516903,{"$f":"G261/E261","v":4.5766590389016018E-3}]
["NHS WEST LANCASHIRE CCG","P81201","ASHURST PRIMARY CARE",5037,5184,36,39,7.1471113758189393,7.5231481481481479,0.71471113758189397,{"$f":"G262/E262","v":7.5231481481481477E-3}]
["NHS WEST LANCASHIRE CCG","P81208","SKELMERSDALE PRACTICE",15333,15194,33,38,2.1522207004500098,2.5009872318020272,0.21522207004500099,{"$f":"G263/E263","v":2.5009872318020273E-3}]
["NHS WEST LANCASHIRE CCG","P81646","LATHOM HOUSE SURGERY",4415,4381,16,17,3.62400906002265,3.8803926044282124,0.36240090600226499,{"$f":"G264/E264","v":3.8803926044282126E-3}]
["NHS WEST LANCASHIRE CCG","P81674","STANLEY COURT SURGERY",5404,5495,14,20,2.5906735751295336,3.6396724294813469,0.2590673575129534,{"$f":"G265/E265","v":3.6396724294813468E-3}]
["NHS WEST LANCASHIRE CCG","P81695","AUGHTON SURGERY",5919,5981,20,26,3.3789491468153403,4.3470991472997831,0.33789491468153404,{"$f":"G266/E266","v":4.3470991472997827E-3}]
["NHS WEST LANCASHIRE CCG","P81710","TARLETON GROUP PRACTICE",8250,8318,29,30,3.5151515151515151,3.6066362106275549,0.3515151515151515,{"$f":"G267/E267","v":3.6066362106275548E-3}]
["NHS WEST LANCASHIRE CCG","P81727","COUNTY ROAD SURGERY",2005,1948,6,5,2.9925187032418954,2.5667351129363447,0.29925187032418954,{"$f":"G268/E268","v":2.5667351129363448E-3}]
["NHS WEST LANCASHIRE CCG","P81758","MATTHEW RYDER CLINIC",2899,3021,38,46,13.107968264918936,15.226746110559416,1.3107968264918937,{"$f":"G269/E269","v":1.5226746110559417E-2}]
["NHS FYLDE AND WYRE CCG","P81006","GARSTANG MEDICAL PRACTICE",10976,18288,69,76,6.2864431486880461,4.1557305336832888,0.62864431486880468,{"$f":"G270/E270","v":4.1557305336832892E-3}]
["NHS FYLDE AND WYRE CCG","P81031","POPLAR HOUSE SURGERY",7426,7324,58,50,7.8103959062752484,6.8268705625341344,0.78103959062752493,{"$f":"G271/E271","v":6.8268705625341344E-3}]
["NHS FYLDE AND WYRE CCG","P81037","ANSDELL MEDICAL CENTRE",9145,8957,75,67,8.201202843083653,7.4801830970190908,0.82012028430836525,{"$f":"G272/E272","v":7.4801830970190912E-3}]
["NHS FYLDE AND WYRE CCG","P81059","GREAT ECCLESTON HLTH CTR",7431,7458,40,60,5.3828556048983982,8.0450522928399035,0.53828556048983989,{"$f":"G273/E273","v":8.0450522928399038E-3}]
["NHS FYLDE AND WYRE CCG","P81077","HOLLAND HOUSE SURGERY",10859,10909,38,58,3.4994014181784694,5.3167109725914381,0.34994014181784694,{"$f":"G274/E274","v":5.3167109725914385E-3}]
["NHS FYLDE AND WYRE CCG","P81079","THE THORNTON PRACTICE",12766,12584,58,93,4.5433181889393701,7.3903369357914812,0.45433181889393703,{"$f":"G275/E275","v":7.3903369357914816E-3}]
["NHS FYLDE AND WYRE CCG","P81086","BROADWAY MEDICAL CENTRE",10261,10329,136,100,13.254068804210116,9.6814793300416309,1.3254068804210115,{"$f":"G276/E276","v":9.681479330041631E-3}]
["NHS FYLDE AND WYRE CCG","P81087","THE OVER-WYRE MED.CTR.",11208,11199,151,160,13.472519628836546,14.286989909813375,1.3472519628836546,{"$f":"G277/E277","v":1.4286989909813376E-2}]
["NHS FYLDE AND WYRE CCG","P81089","THE MOUNT VIEW PRACTICE",11679,11856,46,58,3.9386933812826443,4.8920377867746287,0.39386933812826441,{"$f":"G278/E278","v":4.8920377867746291E-3}]
["NHS FYLDE AND WYRE CCG","P81128","KIRKHAM HEALTH CENTRE",8808,8998,12,10,1.3623978201634876,1.1113580795732385,0.13623978201634876,{"$f":"G279/E279","v":1.1113580795732384E-3}]
["NHS FYLDE AND WYRE CCG","P81129","ASH TREE HOUSE SURGERY",10699,10781,34,34,3.1778670903822785,3.1536963175957706,0.31778670903822787,{"$f":"G280/E280","v":3.1536963175957705E-3}]
["NHS FYLDE AND WYRE CCG","P81133","THE VILLAGE PRACTICE",8908,8869,40,65,4.4903457566232605,7.3288984101928065,0.44903457566232602,{"$f":"G281/E281","v":7.3288984101928063E-3}]
["NHS FYLDE AND WYRE CCG","P81149","LOCKWOOD GP SURGERY",6666,6975,74,71,11.101110111011101,10.179211469534051,1.1101110111011101,{"$f":"G282/E282","v":1.0179211469534051E-2}]
["NHS FYLDE AND WYRE CCG","P81150","CLIFTON MEDICAL PRACTICE",5856,5919,52,75,8.8797814207650276,12.671059300557527,0.88797814207650272,{"$f":"G283/E283","v":1.2671059300557527E-2}]
["NHS FYLDE AND WYRE CCG","P81157","FERNBANK SURGERY",10361,10713,28,29,2.7024418492423514,2.7069915056473444,0.27024418492423513,{"$f":"G284/E284","v":2.7069915056473445E-3}]
["NHS FYLDE AND WYRE CCG","P81191","QUEENSWAY MEDICAL CENTRE",9142,9096,72,96,7.875738350470356,10.554089709762533,0.7875738350470356,{"$f":"G285/E285","v":1.0554089709762533E-2}]
["NHS FYLDE AND WYRE CCG","P81210","PARK MEDICAL PRACTICE",6483,6540,121,148,18.664198673453647,22.629969418960243,1.8664198673453647,{"$f":"G286/E286","v":2.2629969418960245E-2}]
["NHS FYLDE AND WYRE CCG","P81668","FLEETWOOD SURGERY",4546,6207,97,77,21.337439507259131,12.405348799742228,2.1337439507259131,{"$f":"G287/E287","v":1.2405348799742227E-2}]
["NHS FYLDE AND WYRE CCG","P81737","THE OLD LINKS SURGERY",1974,1954,7,5,3.5460992907801416,2.5588536335721597,0.3546099290780142,{"$f":"G288/E288","v":2.5588536335721598E-3}]
["NHS FYLDE AND WYRE CCG","P81742","BEECHWOOD SURGERY",2428,2420,41,32,16.886326194398681,13.223140495867769,1.6886326194398682,{"$f":"G289/E289","v":1.3223140495867768E-2}]
["England","England","England",56236410,58383266,207512,225166,3.689993724706111,3.8566872911837442,0.3689993724706111,{"$f":"G290/E290","v":3.8566872911837444E-3}]

{"sheet":"Sheet4","index":10,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["NHS Chorley and South Ribble CCG"]
["NHS East Lancashire CCG"]
["NHS Fylde & Wyre CCG"]
["NHS Greater Preston CCG"]
["NHS Morecambe Bay CCG"]
["NHS West Lancashire CCG"]