{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Front sheet","Charts","Rates","RAW","Lookup"],"not_rendered":{"charts":4,"images":8,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Front sheet","index":0,"n_rows":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":false,"merged":[[20,0,22,6],[0,0,1,6],[2,0,2,6],[4,0,6,6],[8,0,13,6],[15,0,19,6]]}
["Births and deaths"]
[]
["1981 - 2016"]
[]
["The data used in this publication comes the annual Office for National Statistics (ONS) registered births and deaths in England and Wales data releases."]
[]
[]
[]
["Chart breakdowns are available for the 12 Lancashire county authorities and the two neighbouring unitary authorities of Blackburn with Darwen and Blackpool.  As well total summary figures for the combined 14 authorities (Lancashire-14) and the combined Lancashire county districts (Lancashire-12)."]
[]
[]
[]
[]
[]
[]
["The trend line chart shows the total registered births and deaths between 1981 and 2016, as well as a  the difference between the two (Deaths-births).  Users should note that is not an accurate depiction of population change over time. As it excludes inward and outward migration.  "]
[]
[]
[]
[]
["The column chart also shows the total registered births and deaths between 1981 and 2016, but does not include the difference calculation."]
[]
[]
[]
[]
["Source : ONS annual births and deaths registrations, last published July 2017"]
[]
["Deaths registered in England and Wales"]
["Births registered in England and Wales"]

{"sheet":"Charts","index":1,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[[3,4,4,6],[0,0,1,26]]}
[{"$f":"\"Births and deaths 1981 - 2016 \" & \" : \" & B8","v":"Births and deaths 1981 - 2016  : Lancashire-14"}]
[]
[]
[null,null,null,null,"<< Select area "]
[]
[]
[]
[null,"Lancashire-14",null,"Total live births","Total registered deaths","Difference"]
[null,null,null,"live births","deaths","difference"]
[null,null,1981,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C10,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17597},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C10,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":18959},{"$f":"D10-E10","v":-1362}]
[null,null,1982,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C11,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17583},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C11,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":19275},-1692]
[null,null,1983,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C12,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17829},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C12,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":19086},-1257]
[null,null,1984,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C13,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":18021},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C13,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":18508},-487]
[null,null,1985,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C14,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":18308},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C14,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":19357},-1049]
[null,null,1986,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C15,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":18547},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C15,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":18691},-144]
[null,null,1987,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C16,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":18964},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C16,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":18188},776]
[null,null,1988,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C17,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":19183},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C17,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":18229},954]
[null,null,1989,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C18,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":19107},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C18,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":18302},805]
[null,null,1990,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C19,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":19795},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C19,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17924},1871]
[null,null,1991,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C20,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":19647},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C20,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17909},1738]
[null,null,1992,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C21,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":18642},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C21,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17380},1262]
[null,null,1993,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C22,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":18413},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C22,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":18174},239]
[null,null,1994,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C23,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17749},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C23,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17153},596]
[null,null,1995,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C24,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17260},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C24,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17382},-122]
[null,null,1996,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C25,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17424},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C25,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17074},350]
[null,null,1997,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C26,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":16894},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C26,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17391},-497]
[null,null,1998,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C27,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":16685},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C27,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":16795},-110]
[null,null,1999,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C28,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":16226},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C28,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":16878},{"$f":"D28-E28","v":-652}]
[null,null,2000,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C29,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":15749},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C29,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":16195},{"$f":"D29-E29","v":-446}]
[null,null,2001,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C30,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":15644},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C30,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":16126},-482]
[null,null,2002,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C31,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":15229},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C31,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":16229},-1000]
[null,null,2003,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C32,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":16155},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C32,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":16347},-192]
[null,null,2004,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C33,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":16952},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C33,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":15497},1455]
[null,null,2005,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C34,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17017},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C34,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":15672},1345]
[null,null,2006,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C35,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17219},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C35,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":15104},2115]
[null,null,2007,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C36,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17535},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C36,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":15367},2168]
[null,null,2008,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C37,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":18085},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C37,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":15483},2602]
[null,null,2009,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C38,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17868},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C38,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":15001},2867]
[null,null,2010,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C39,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17870},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C39,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":14623},3247]
[null,null,2011,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C40,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17873},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C40,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":14683},3190]
[null,null,2012,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C41,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17751},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C41,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":14950},2801]
[null,null,2013,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C42,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17288},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C42,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":15157},2131]
[null,null,2014,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C43,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17241},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C43,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":15020},2221]
[null,null,2015,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C44,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":16982},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C44,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":15510},1472]
[null,null,2016,{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C45,IF(RAW!$B$2:$B$73=Charts!$D$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":17039},{"$f":"SUM(IF(RAW!$A$2:$A$73=Charts!$C45,IF(RAW!$B$2:$B$73=Charts!$E$9,IF(RAW!$C$1:$R$1=Charts!$B$8,RAW!$C$2:$R$73))))","v":15544},{"$f":"D45-E45","v":1495}]
["Source : ONS annual births and deaths registrations, last published July 2017"]
["Deaths registered in England and Wales 2016"]
["Births registered in England and Wales 2016"]

{"sheet":"Rates","index":2,"n_rows":57,"n_cols":25,"rows_kept":57,"cut":false,"hidden":false,"merged":[[52,0,52,11],[54,0,54,11],[55,0,55,12],[56,0,56,12],[30,0,31,1],[30,23,30,25],[0,0,1,27],[4,0,5,1],[4,12,5,12],[26,0,26,11],[30,2,30,6],[30,13,30,17],[30,7,30,12],[4,2,4,6],[4,7,4,11]]}
["Births and deaths rates 2012 - 2016"]
[]
[]
[]
["Area of usual residence",null,"Total number of deaths",null,null,null,null,"Standardised mortality ratios (SMR)",null,null,null,null,"Direction"]
[null,null,2016,2015,2014,2013,2012,2016,2015,2014,2013,2012,null,"England"]
["E92000001           ","ENGLAND",490791,495309,468875,473552,466779,99,99,99,99,99,{"$f":"IF(H7>L7,\"p\",IF(H7<L7,\"q\",\"n\"))","v":"n"},99]
["E12000002           ","NORTH WEST",71315,71299,68318,69045,68262,111,110,111,110,110,{"$f":"IF(H8>L8,\"p\",IF(H8<L8,\"q\",\"n\"))","v":"p"},99]
["E06000008           ","Blackburn with Darwen",1349,1265,1234,1215,1225,133,120,119,124,121,"p",99]
["E06000009           ","Blackpool",1862,1986,1782,1816,1822,141,128,128,129,139,"p",99]
["E10000017           ","Lancashire-12",12333,12259,12004,12126,11903,106,104,108,108,107,"q",99]
["E07000117           ","Burnley",865,943,911,914,1000,113,121,123,121,133,"q",99]
["E07000118           ","Chorley",1087,1024,1044,986,980,108,102,110,104,105,"p",99]
["E07000119           ","Fylde",1055,1056,1019,1044,1015,102,101,103,104,103,"q",99]
["E07000120           ","Hyndburn",845,799,812,843,787,122,115,123,125,117,"p",99]
["E07000121           ","Lancaster",1530,1497,1481,1519,1458,111,107,111,111,108,"p",99]
["E07000122           ","Pendle",835,858,873,846,819,105,107,114,108,106,"q",99]
["E07000123           ","Preston",1177,1239,1205,1212,1222,111,115,117,115,116,"q",99]
["E07000124           ","Ribble Valley",611,550,608,552,550,93,84,99,89,92,"p",99]
["E07000125           ","Rossendale",621,670,650,646,611,105,112,115,113,108,"q",99]
["E07000126           ","South Ribble",1021,1006,939,989,965,94,93,92,97,96,"q",99]
["E07000127           ","West Lancashire",1210,1165,1075,1164,1036,106,102,101,109,99,"p",99]
["E07000128           ","Wyre",1476,1452,1387,1411,1460,102,100,101,102,107,"q",99]
[]
[null,"Significantly above England"]
[null,"Significantly below England"]
["The \"Direction\" column simply indicates whether or not the latest figures, represent an increase or decrease upon the 2012 figures. "]
[]
["1 SMRs are based on the latest mid-year population estimates at the time of publication. For more information on these rates please see the ONS guide to mortality statistics."]
[]
["Area of usual residence",null,"Total number of births",null,null,null,null,"General fertility rate (GFR) ",null,null,null,null,null," Total fertility rate (TFR) ",null,null,null,null,null,null,null,null,null,"<< Select area"]
[null,null,2016,2015,2014,2013,2012,2016,2015,2014,2013,2012,"Direction",2016,2015,2014,2013,2012,"Direction","Wyre",{"$f":"SUM(IF(TFR=$T$32,IF($N$32:$R$32=U33,$N$33:$R$49)))","v":1.83},{"$f":"SUM(IF(TFR=$T$32,IF($N$32:$R$32=V33,$N$33:$R$49)))","v":1.79},{"$f":"SUM(IF(TFR=$T$32,IF($N$32:$R$32=W33,$N$33:$R$49)))","v":1.88},{"$f":"SUM(IF(TFR=$T$32,IF($N$32:$R$32=X33,$N$33:$R$49)))","v":1.81},{"$f":"SUM(IF(TFR=$T$32,IF($N$32:$R$32=Y33,$N$33:$R$49)))","v":1.79}]
["E92000001           ","ENGLAND",663157,664399,661496,664517,694241,62.5,62.5,62.2,62.4,64.900000000000006,{"$f":"IF(H33>L33,\"p\",IF(H33<L33,\"q\",\"n\"))","v":"q"},1.81,1.82,1.83,1.85,1.94,{"$f":"IF(N33>R33,\"p\",IF(N33<R33,\"q\",\"n\"))","v":"q"},null,2012,2013,2014,2015,2016]
["E12000002           ","NORTH WEST",86069,85838,85606,86372,89211,63.4,62.9,62.5,62.6,64.099999999999994,{"$f":"IF(H34>L34,\"p\",IF(H34<L34,\"q\",\"n\"))","v":"q"},1.85,1.85,1.86,1.88,1.94,{"$f":"IF(N34>R34,\"p\",IF(N34<R34,\"q\",\"n\"))","v":"q"},"Replacement fertility",2.1,2.1,2.1,2.1,2.1]
["E06000008           ","Blackburn with Darwen",2156,2115,2212,2254,2300,75.7,73.2,75.8,75.599999999999994,75.907590759075916,"q",2.25,2.1800000000000002,2.25,2.25,2.2599999999999998,"q","England",{"$f":"R33","v":1.94},{"$f":"Q33","v":1.85},{"$f":"P33","v":1.83},{"$f":"O33","v":1.82},{"$f":"N33","v":1.81}]
["E06000009           ","Blackpool",1700,1665,1819,1717,1770,70.599999999999994,67.8,72.5,66.900000000000006,68.242279369240848,"p",2.09,2.0299999999999998,2.17,2.0299999999999998,2.09,"n",{"$f":"T32","v":"Wyre"},1.83,1.79,1.88,1.81,1.79]
["E10000017           ","Lancashire-12",13183,13202,13210,13317,13681,61.7,61.2,60.9,60.7,61.833910347383551,"q",1.85,1.85,1.86,1.87,1.93,"q"]
["E07000117           ","Burnley",1207,1197,1122,1210,1227,75.3,73.599999999999994,68,72.7,72.93586161802294,"p",2.19,2.13,1.98,2.14,2.17,"p"]
["E07000118           ","Chorley",1226,1269,1231,1182,1229,61.5,63.2,61.2,58.8,61.465366341585401,"p",1.83,1.91,1.88,1.83,1.93,"q"]
["E07000119           ","Fylde",629,633,600,645,682,57.3,57.4,53.1,56.3,58.395410565973116,"q",1.79,1.82,1.67,1.78,1.88,"q"]
["E07000120           ","Hyndburn",1057,1077,1085,1135,1121,71.2,71.599999999999994,71,74,72.136422136422141,"q",2.09,2.11,2.13,2.2400000000000002,2.2000000000000002,"q"]
["E07000121           ","Lancaster",1456,1447,1497,1482,1584,51.1,50.9,52.5,51.7,54.466680420878888,"q",1.62,1.62,1.7,1.68,1.78,"q"]
["E07000122           ","Pendle",1214,1261,1304,1278,1305,73.2,75.5,77.599999999999994,74.5,75.437886583039486,"q",2.12,2.1800000000000002,2.2599999999999998,2.1800000000000002,2.23,"q"]
["E07000123           ","Preston",1893,1879,1869,1918,1857,64,63,62.5,63.2,60.335304438235099,"p",1.9,1.88,1.86,1.87,1.81,"p"]
["E07000124           ","Ribble Valley",482,426,457,427,475,53.5,46.9,49.7,45.8,50.774986638161415,"p",1.75,1.57,1.67,1.56,1.75,"n"]
["E07000125           ","Rossendale",818,763,837,818,835,65.400000000000006,60,65.099999999999994,62.9,63.852565573143686,"p",1.97,1.85,2,1.97,2.0299999999999998,"q"]
["E07000126           ","South Ribble",1241,1208,1206,1138,1242,64.8,62.2,61.7,57.3,61.390934704166874,"p",1.95,1.91,1.89,1.78,1.93,"p"]
["E07000127           ","West Lancashire",1000,1076,1011,1142,1168,49.5,52.8,49.8,56,57.590848577486312,"q",1.65,1.79,1.68,1.9,1.92,"q"]
["E07000128           ","Wyre",960,966,991,942,956,58.3,58.1,59.1,55.5,55.860698843052468,"p",1.79,1.81,1.88,1.79,1.83,"q"]
[]
[null,"Significantly above England"]
[null,"Significantly below England"]
["The \"Direction\" column simply indicates whether or not the latest figures, represent an increase or decrease upon the 2012 figures. "]
[]
["Live births and stillbirths by area of usual residence of mother, numbers, General Fertility Rates and Total Fertility Rates"]
["2 The General Fertility Rate (GFR) is the number of live births per 1,000 women aged 15 to 44, calculated using the latest mid-year population estimates at the time of publication"]
["3 The Total Fertility Rate (TFR) is the average number of live children that a group of women would bear if they experienced the age-specific fertility rates of the calendar year in question throughout their childbearing lifespan.  "]

{"sheet":"RAW","index":3,"n_rows":73,"n_cols":18,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
["Year","BorD","Lancashire-14","Lancashire-12","Blackburn with Darwen","Blackpool","Burnley","Chorley","Fylde","Hyndburn","Lancaster","Pendle","Preston","Ribble Valley","Rossendale","South Ribble","West Lancashire","Wyre"]
[1981,"live births",17597,13839,2317,1441,1300,1220,634,1118,1376,1269,1729,520,949,1231,1469,1024]
[1982,"live births",17583,13759,2361,1463,1286,1225,654,1109,1443,1232,1691,514,918,1292,1414,981]
[1983,"live births",17829,14030,2258,1541,1362,1209,676,1115,1447,1280,1773,504,881,1347,1494,942]
[1984,"live births",18021,14191,2318,1512,1336,1166,648,1126,1546,1255,1807,532,890,1386,1460,1039]
[1985,"live births",18308,14352,2341,1615,1374,1203,696,1150,1534,1294,1836,517,913,1335,1490,1010]
[1986,"live births",18547,14425,2303,1819,1442,1205,729,1095,1565,1292,1805,541,905,1326,1467,1053]
[1987,"live births",18964,14688,2374,1902,1342,1283,725,1151,1567,1287,1908,558,903,1406,1469,1089]
[1988,"live births",19183,14899,2337,1947,1410,1285,768,1170,1600,1285,1926,609,968,1375,1393,1110]
[1989,"live births",19107,15037,2266,1804,1450,1317,775,1165,1558,1244,2009,593,968,1362,1426,1170]
[1990,"live births",19795,15442,2398,1955,1449,1384,738,1186,1548,1310,2139,578,973,1498,1496,1143]
[1991,"live births",19647,15324,2372,1951,1478,1323,729,1244,1625,1301,2029,536,991,1385,1494,1189]
[1992,"live births",18642,14510,2329,1803,1413,1217,722,1206,1541,1252,1936,516,961,1290,1349,1107]
[1993,"live births",18413,14213,2404,1796,1334,1222,720,1208,1515,1197,1897,558,946,1249,1338,1029]
[1994,"live births",17749,13637,2286,1826,1239,1149,679,1185,1429,1202,1862,502,892,1184,1312,1002]
[1995,"live births",17260,13215,2362,1683,1195,1183,704,1233,1397,1114,1684,463,874,1142,1245,981]
[1996,"live births",17424,13391,2263,1770,1227,1138,663,1174,1481,1137,1835,527,791,1129,1228,1061]
[1997,"live births",16894,12980,2192,1722,1132,1068,693,1045,1437,1095,1843,530,774,1120,1222,1021]
[1998,"live births",16685,12856,2204,1625,1168,1108,665,1068,1376,1130,1679,530,788,1142,1199,1003]
[1999,"live births",16226,12577,2121,1528,1132,1074,669,1046,1366,1077,1688,514,793,1078,1218,922]
[2000,"live births",15749,12132,2094,1523,1009,1041,592,1052,1338,1131,1593,546,757,1039,1073,961]
[2001,"live births",15644,12164,2083,1397,1056,1012,636,1019,1274,1083,1659,503,764,1118,1122,918]
[2002,"live births",15229,11716,2110,1403,1040,1035,573,1017,1216,1065,1562,484,715,1053,1067,889]
[2003,"live births",16155,12463,2143,1549,1092,1104,567,1132,1321,1114,1691,510,706,1100,1142,984]
[2004,"live births",16952,13082,2184,1686,1153,1241,600,1104,1328,1163,1758,522,817,1197,1179,1020]
[2005,"live births",17017,13084,2284,1649,1163,1177,655,1123,1401,1244,1801,475,803,1114,1193,935]
[2006,"live births",17219,13249,2315,1655,1173,1205,578,1119,1379,1224,1895,488,839,1186,1136,1027]
[2007,"live births",17535,13503,2338,1694,1273,1209,630,1088,1455,1266,1849,531,796,1178,1257,971]
[2008,"live births",18085,13963,2377,1745,1315,1238,642,1159,1487,1322,1943,505,876,1255,1244,977]
[2009,"live births",17868,13829,2312,1727,1213,1202,621,1231,1476,1345,1976,517,865,1236,1169,978]
[2010,"live births",17870,13797,2296,1777,1245,1193,679,1140,1518,1358,1992,478,849,1208,1198,939]
[2011,"live births",17873,13794,2344,1735,1172,1283,693,1164,1574,1303,1918,438,859,1285,1116,989]
[2012,"live births",17751,13681,2300,1770,1227,1229,682,1121,1584,1305,1857,475,835,1242,1168,956]
[2013,"live births",17288,13317,2254,1717,1210,1182,645,1135,1482,1278,1918,427,818,1138,1142,942]
[2014,"live births",17241,13210,2212,1819,1122,1231,600,1085,1497,1304,1869,457,837,1206,1011,991]
[2015,"live births",16982,13202,2115,1665,1197,1269,633,1077,1447,1261,1879,426,763,1208,1076,966]
[2016,"live births",17039,13183,2156,1700,1207,1226,629,1057,1456,1214,1893,482,818,1241,1000,960]
[1981,"deaths",18959,14458,1818,2683,1380,959,1106,1097,2026,1238,1657,649,802,949,1088,1507]
[1982,"deaths",19275,14654,1925,2696,1347,953,1200,1136,2019,1170,1650,644,840,988,1132,1575]
[1983,"deaths",19086,14577,1966,2543,1321,980,1257,1043,1923,1205,1696,705,804,940,1138,1565]
[1984,"deaths",18508,14248,1827,2433,1300,1039,1270,1043,1928,1166,1622,657,822,916,1066,1419]
[1985,"deaths",19357,14826,1910,2621,1344,1002,1275,1084,2046,1151,1761,630,780,1015,1145,1593]
[1986,"deaths",18691,14409,1829,2453,1187,990,1261,1131,1895,1177,1638,702,796,997,1112,1523]
[1987,"deaths",18188,13961,1834,2393,1215,1028,1245,994,1817,1077,1665,653,743,967,1071,1486]
[1988,"deaths",18229,14165,1704,2360,1227,1008,1206,1029,1786,1099,1598,647,815,1026,1141,1583]
[1989,"deaths",18302,14147,1770,2385,1203,1075,1248,996,1815,1009,1578,697,800,998,1154,1574]
[1990,"deaths",17924,13917,1639,2368,1204,953,1239,935,1919,970,1593,653,828,958,1061,1604]
[1991,"deaths",17909,13836,1677,2396,1198,1023,1170,968,1819,945,1657,634,808,996,1071,1547]
[1992,"deaths",17380,13566,1590,2224,1193,969,1174,974,1768,986,1590,608,784,982,1080,1458]
[1993,"deaths",18174,14094,1649,2431,1188,1102,1105,975,1795,1014,1604,669,837,1051,1188,1566]
[1994,"deaths",17153,13373,1506,2274,1129,1031,1115,901,1727,945,1508,623,768,1026,1118,1482]
[1995,"deaths",17382,13521,1509,2352,1087,944,1150,972,1737,956,1596,600,761,990,1176,1552]
[1996,"deaths",17074,13265,1566,2243,1093,1001,1083,956,1739,975,1465,614,728,1010,1164,1437]
[1997,"deaths",17391,13486,1654,2251,1151,1052,1142,1026,1645,963,1364,606,781,1063,1111,1582]
[1998,"deaths",16795,13072,1551,2172,1096,985,1080,946,1678,966,1431,582,693,980,1138,1497]
[1999,"deaths",16878,13235,1527,2116,1089,1013,1101,951,1667,918,1435,601,760,1029,1215,1456]
[2000,"deaths",16195,12664,1437,2094,981,1069,1033,914,1614,896,1316,561,683,1026,1179,1392]
[2001,"deaths",16126,12645,1342,2139,971,993,1035,910,1566,928,1382,594,695,1031,1192,1348]
[2002,"deaths",16229,12721,1439,2069,1033,1027,1045,913,1593,913,1332,571,667,992,1201,1434]
[2003,"deaths",16347,12823,1411,2113,1016,1030,1041,891,1573,959,1366,569,715,1058,1177,1428]
[2004,"deaths",15497,12230,1306,1961,1018,1000,1018,806,1504,871,1239,570,670,937,1147,1450]
[2005,"deaths",15672,12364,1320,1988,912,992,1027,836,1479,930,1349,554,686,927,1136,1536]
[2006,"deaths",15104,11898,1285,1921,988,900,985,864,1477,863,1240,549,626,1000,1092,1314]
[2007,"deaths",15367,12123,1368,1876,964,915,983,826,1530,837,1252,568,663,1052,1118,1415]
[2008,"deaths",15483,12306,1277,1900,944,1049,991,910,1560,818,1347,489,687,982,1141,1388]
[2009,"deaths",15001,11886,1312,1803,945,937,995,838,1412,853,1196,618,708,946,1083,1355]
[2010,"deaths",14623,11508,1235,1880,841,921,907,813,1450,814,1199,584,630,907,1116,1326]
[2011,"deaths",14683,11676,1189,1818,926,967,965,791,1433,812,1126,543,667,970,1068,1408]
[2012,"deaths",14950,11903,1225,1822,1000,980,1015,787,1458,819,1222,550,611,965,1036,1460]
[2013,"deaths",15157,12126,1215,1816,914,986,1044,843,1519,846,1212,552,646,989,1164,1411]
[2014,"deaths",15020,12004,1234,1782,911,1044,1019,812,1481,873,1205,608,650,939,1075,1387]
[2015,"deaths",15510,12259,1265,1986,943,1024,1056,799,1497,858,1239,550,670,1006,1165,1452]
[2016,"deaths",15544,12333,1349,1862,865,1087,1055,845,1530,835,1177,611,621,1021,1210,1476]

{"sheet":"Lookup","index":4,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Lancashire-12"]
[null,"Lancashire-14"]
[null,"Blackburn with Darwen"]
[null,"Blackpool"]
[null,"Burnley"]
[null,"Chorley"]
[null,"Fylde"]
[null,"Hyndburn"]
[null,"Lancaster"]
[null,"Pendle"]
[null,"Preston"]
[null,"Ribble Valley"]
[null,"Rossendale"]
[null,"South Ribble"]
[null,"West Lancashire"]
[null,"Wyre"]