{
  "fields": [{"type":"int","id":"_id"},{"info":{"notes":"","type_override":"","label":"Data is recorded for financial years (1st April to 31st March)"},"type":"text","id":"FinancialYear"},{"info":{"notes":"[Qualifier information](https://www.opendata.nhs.scot/dataset/statistical-qualifiers/resource/b80f9af0-b115-4245-b591-fb22775226c4)\r\n","type_override":"","label":"Qualifier for FinancialYear indicating provisional data"},"type":"text","id":"FinancialYearQF"},{"info":{"notes":"[Country labels](https://www.opendata.nhs.scot/dataset/geography-codes-and-labels/resource/9c6e6c56-2697-4184-92c6-60d69c2b6792)\r\n","type_override":"","label":"9-digit code for Scotland"},"type":"text","id":"Country"},{"info":{"notes":"","type_override":"","label":"The age group at the time of death; Ages 0-54 years old have been aggregated to one group due to small number of deaths"},"type":"text","id":"AgeGroup"},{"info":{"notes":"","type_override":"","label":"Sex as Female/Male"},"type":"text","id":"Sex"},{"info":{"notes":"","type_override":"","label":"Percentage of the last six months of life spent at home or in a community setting"},"type":"numeric","id":"PercentageSpentInHomeCommunity"},{"info":{"notes":"","type_override":"","label":"Percentage of the last six months of life spent at a hospital"},"type":"numeric","id":"PercentageSpentInHospital"},{"info":{"notes":"","type_override":"","label":"The total number of deaths in the reference period"},"type":"numeric","id":"NumberOfDeaths"},{"info":{"notes":"","type_override":"","label":"The total number of days in the last six months of life spent in hospital"},"type":"numeric","id":"TotalLengthOfStay"},{"info":{"notes":"","type_override":"","label":"The average number of days of the last six months of life spent in the community"},"type":"numeric","id":"AverageDaysInCommunity"},{"info":{"notes":"","type_override":"","label":"The average number of days of the last six months of life spent in a hospital"},"type":"numeric","id":"AverageDaysInHospital"}],
  "records": [
    [1,"2016/17","","S92000003","0-17 years","Female",92.81058101086442,7.18941898913557,116,1522,169,13],
    [2,"2016/17","","S92000003","0-17 years","Male",93.86844786595721,6.131552134042794,121,1354,171,11],
    [3,"2016/17","","S92000003","0-17 years","Missing",100,0,3,0,183,0],
    [4,"2016/17","","S92000003","18-44 years","Female",89.37081477956423,10.629185220435772,403,7817.5,163,19],
    [5,"2016/17","","S92000003","18-44 years","Male",90.99138539754271,9.00861460245728,582,9568.5,166,16],
    [6,"2016/17","","S92000003","45-54 years","Female",89.15791058256812,10.842089417431884,910,18006,163,20],
    [7,"2016/17","","S92000003","45-54 years","Male",92.1683421011511,7.831657898848898,1315,18795,168,14],
    [8,"2016/17","","S92000003","55-64 years","Female",89.48567562996787,10.514324370032133,2025,38857,163,19],
    [9,"2016/17","","S92000003","55-64 years","Male",90.73031706448165,9.269682935518347,2807,47486.5,166,17],
    [10,"2016/17","","S92000003","65-74 years","Female",88.07411468183042,11.92588531816958,4223,91912.5,161,22],
    [11,"2016/17","","S92000003","65-74 years","Male",88.79176606576326,11.20823393423674,5570,113934.5,162,20],
    [12,"2016/17","","S92000003","75-84 years","Female",86.80564933696772,13.194350663032278,8257,198826,158,24],
    [13,"2016/17","","S92000003","75-84 years","Male",86.6039507298339,13.396049270166104,8054,196902.5,158,24],
    [14,"2016/17","","S92000003","85 years and over","Female",88.2406643213161,11.759335678683899,11884,255040,161,21],
    [15,"2016/17","","S92000003","85 years and over","Male",86.236743750987,13.763256249012995,6766,169948,157,25],
    [16,"2017/18","","S92000003","0-17 years","Female",95.3574097135741,4.642590286425903,110,932,174,8],
    [17,"2017/18","","S92000003","0-17 years","Male",95.23374646662317,4.766253533376821,126,1096,174,9],
    [18,"2017/18","","S92000003","0-17 years","Missing",100,0,2,0,183,0],
    [19,"2017/18","","S92000003","18-44 years","Female",89.09010933769008,10.909890662309916,436,8681,163,20],
    [20,"2017/18","","S92000003","18-44 years","Male",91.76871263149928,8.231287368500718,543,8157,167,15],
    [21,"2017/18","","S92000003","45-54 years","Female",90.04719696097617,9.952803039023829,952,17292,164,18],
    [22,"2017/18","","S92000003","45-54 years","Male",91.63816795525756,8.36183204474244,1281,19548.5,167,15],
    [23,"2017/18","","S92000003","55-64 years","Female",89.3203770360204,10.679622963979597,2116,41241.5,163,19],
    [24,"2017/18","","S92000003","55-64 years","Male",90.64905302407709,9.35094697592291,2917,49780,165,17],
    [25,"2017/18","","S92000003","65-74 years","Female",88.54729260201461,11.452707397985389,4534,94766,162,21],
    [26,"2017/18","","S92000003","65-74 years","Male",89.03753658822151,10.96246341177848,5850,117038,162,20],
    [27,"2017/18","","S92000003","75-84 years","Female",87.32295994071143,12.677040059288569,8669,200562.5,159,23],
    [28,"2017/18","","S92000003","75-84 years","Male",87.02884127541662,12.97115872458338,8775,207725,159,24],
    [29,"2017/18","","S92000003","85 years and over","Female",89.49477210305203,10.50522789694797,12808,245555.5,163,19],
    [30,"2017/18","","S92000003","85 years and over","Male",87.21434966156104,12.785650338438948,7314,170663.5,159,23],
    [31,"2018/19","","S92000003","0-17 years","Female",95.66931026195626,4.3306897380437395,114,901,175,8],
    [32,"2018/19","","S92000003","0-17 years","Male",93.7355946944988,6.264405305501196,126,1440.5,171,11],
    [33,"2018/19","","S92000003","0-17 years","Missing",100,0,1,0,183,0],
    [34,"2018/19","","S92000003","18-44 years","Female",89.0761539959748,10.92384600402519,422,8413,163,20],
    [35,"2018/19","","S92000003","18-44 years","Male",92.46884334122979,7.531156658770214,532,7312,169,14],
    [36,"2018/19","","S92000003","45-54 years","Female",89.36805523088192,10.631944769118082,879,17055.5,163,19],
    [37,"2018/19","","S92000003","45-54 years","Male",91.91289915377062,8.08710084622937,1172,17297.5,168,15],
    [38,"2018/19","","S92000003","55-64 years","Female",89.06696739527015,10.93303260472984,2065,41202.5,163,20],
    [39,"2018/19","","S92000003","55-64 years","Male",91.12649477379172,8.873505226208286,2802,45376,166,16],
    [40,"2018/19","","S92000003","65-74 years","Female",88.20371032762637,11.796289672373625,4251,91516.5,161,22],
    [41,"2018/19","","S92000003","65-74 years","Male",89.5175236980011,10.482476301998906,5662,108317,163,19],
    [42,"2018/19","","S92000003","75-84 years","Female",87.50005575522599,12.499944244774019,7985,182157,160,23],
    [43,"2018/19","","S92000003","75-84 years","Male",86.92390132178593,13.076098678214072,8206,195827,159,24],
    [44,"2018/19","","S92000003","85 years and over","Female",89.40936958746654,10.590630412533459,11136,215235.5,163,19],
    [45,"2018/19","","S92000003","85 years and over","Male",87.14796618221378,12.852033817786216,6661,156233.5,159,23],
    [46,"2019/20","","S92000003","0-17 years","Female",91.7577505407354,8.2422494592646,95,1429,167,15],
    [47,"2019/20","","S92000003","0-17 years","Male",93.63491557820961,6.365084421790379,129,1498.5,171,12],
    [48,"2019/20","","S92000003","0-17 years","Missing",100,0,2,0,183,0],
    [49,"2019/20","","S92000003","18-44 years","Female",89.88805035945492,10.111949640545085,383,7068,164,18],
    [50,"2019/20","","S92000003","18-44 years","Male",91.40987255239659,8.590127447603402,517,8105,167,16],
    [51,"2019/20","","S92000003","45-54 years","Female",89.80722178066607,10.192778219333926,879,16351,164,19],
    [52,"2019/20","","S92000003","45-54 years","Male",91.59674657534246,8.403253424657533,1152,17667,167,15],
    [53,"2019/20","","S92000003","55-64 years","Female",89.03528984849859,10.964710151501407,2265,45324,162,20],
    [54,"2019/20","","S92000003","55-64 years","Male",90.93562353609198,9.064376463908014,2895,47890.5,166,17],
    [55,"2019/20","","S92000003","65-74 years","Female",88.39500941185864,11.604990588141366,4461,94480,161,21],
    [56,"2019/20","","S92000003","65-74 years","Male",89.73139239600845,10.268607603991558,5745,107662.5,164,19],
    [57,"2019/20","","S92000003","75-84 years","Female",87.51328062772771,12.486719372272288,8324,189689.5,160,23],
    [58,"2019/20","","S92000003","75-84 years","Male",87.79459411051657,12.20540588948343,8566,190806.5,160,22],
    [59,"2019/20","","S92000003","85 years and over","Female",89.66714771719657,10.332852282803424,12112,228401.5,164,19],
    [60,"2019/20","","S92000003","85 years and over","Male",87.4324187125619,12.567581287438099,7286,167110.5,160,23],
    [61,"2020/21","","S92000003","0-17 years","Female",92.04248114514391,7.9575188548560885,89,1292.5,168,15],
    [62,"2020/21","","S92000003","0-17 years","Male",95.67025440313111,4.329745596868884,112,885,175,8],
    [63,"2020/21","","S92000003","0-17 years","Missing",100,0,1,0,183,0],
    [64,"2020/21","","S92000003","18-44 years","Female",92.52856373751271,7.4714362624872885,458,6245,169,14],
    [65,"2020/21","","S92000003","18-44 years","Male",93.44446860428596,6.555531395714044,567,6783.5,171,12],
    [66,"2020/21","","S92000003","45-54 years","Female",91.82615752725034,8.17384247274966,979,14604,168,15],
    [67,"2020/21","","S92000003","45-54 years","Male",93.28411071341566,6.7158892865843365,1462,17919,170,12],
    [68,"2020/21","","S92000003","55-64 years","Female",91.06473043682756,8.935269563172438,2330,37995,166,16],
    [69,"2020/21","","S92000003","55-64 years","Male",92.23111511514732,7.768884884852676,3406,48291,168,14],
    [70,"2020/21","","S92000003","65-74 years","Female",90.37310107812505,9.626898921874954,4827,84806,165,18],
    [71,"2020/21","","S92000003","65-74 years","Male",90.81996476115074,9.180035238849255,6523,109283.5,166,17],
    [72,"2020/21","","S92000003","75-84 years","Female",89.72470378627104,10.275296213728968,9211,172728.5,164,19],
    [73,"2020/21","","S92000003","75-84 years","Male",89.60047316866988,10.39952683133012,9658,183300.5,164,19],
    [74,"2020/21","","S92000003","85 years and over","Female",91.43281771807762,8.567182281922388,13282,207665.5,167,16],
    [75,"2020/21","","S92000003","85 years and over","Male",89.40236174163577,10.597638258364226,8292,160373,163,19],
    [76,"2021/22","","S92000003","0-17 years","Female",94.64383561643835,5.356164383561644,120,1173,173,10],
    [77,"2021/22","","S92000003","0-17 years","Male",96.0138031998327,3.9861968001673116,131,953,175,7],
    [78,"2021/22","","S92000003","0-17 years","Missing",100,0,2,0,183,0],
    [79,"2021/22","","S92000003","18-44 years","Female",91.5550538487354,8.444946151264606,449,6920,167,15],
    [80,"2021/22","","S92000003","18-44 years","Male",93.54513105565505,6.454868944344954,589,6938.5,171,12],
    [81,"2021/22","","S92000003","45-54 years","Female",90.76216995256551,9.237830047434482,979,16505,166,17],
    [82,"2021/22","","S92000003","45-54 years","Male",93.23991933377219,6.760080666227809,1311,16174,170,12],
    [83,"2021/22","","S92000003","55-64 years","Female",90.80774280502399,9.192257194976007,2358,39557.5,166,17],
    [84,"2021/22","","S92000003","55-64 years","Male",92.11003899610039,7.889961003899611,3288,47344.5,168,14],
    [85,"2021/22","","S92000003","65-74 years","Female",89.73317076669296,10.266829233307037,4775,89469,164,19],
    [86,"2021/22","","S92000003","65-74 years","Male",90.76742349585909,9.232576504140914,6297,106101,166,17],
    [87,"2021/22","","S92000003","75-84 years","Female",88.96918042624212,11.030819573757887,8766,176470.5,162,20],
    [88,"2021/22","","S92000003","75-84 years","Male",89.29195270474037,10.708047295259629,9221,180198.5,163,20],
    [89,"2021/22","","S92000003","85 years and over","Female",90.55092388538567,9.449076114614325,12463,214919,165,17],
    [90,"2021/22","","S92000003","85 years and over","Male",88.88808571703267,11.111914282967335,7694,156028.5,162,20],
    [91,"2022/23","","S92000003","0-17 years","Female",92.7358121330724,7.264187866927593,105,1392,169,13],
    [92,"2022/23","","S92000003","0-17 years","Male",95.39131358182011,4.608686418179888,129,1085,174,8],
    [93,"2022/23","","S92000003","18-44 years","Female",90.86878154289835,9.131218457101658,456,7599,166,17],
    [94,"2022/23","","S92000003","18-44 years","Male",93.0746081806582,6.925391819341792,569,7191.5,170,13],
    [95,"2022/23","","S92000003","45-54 years","Female",89.88716144707618,10.112838552923813,919,16961,164,18],
    [96,"2022/23","","S92000003","45-54 years","Male",92.6487724604163,7.351227539583705,1232,16528.5,169,13],
    [97,"2022/23","","S92000003","55-64 years","Female",90.70756741989618,9.292432580103814,2457,41667.5,166,17],
    [98,"2022/23","","S92000003","55-64 years","Male",91.25159023941823,8.748409760581762,3338,53294,167,16],
    [99,"2022/23","","S92000003","65-74 years","Female",89.06940565975505,10.930594340244948,4984,99422.5,163,20],
    [100,"2022/23","","S92000003","65-74 years","Male",90.2876712328767,9.712328767123289,6220,110249.5,165,18],
    [101,"2022/23","","S92000003","75-84 years","Female",88.44651064822128,11.553489351778715,9105,191980,161,21],
    [102,"2022/23","","S92000003","75-84 years","Male",88.16449619169634,11.835503808303653,9730,210166,161,22],
    [103,"2022/23","","S92000003","85 years and over","Female",89.76753746797773,10.232462532022273,13395,250141.5,164,19],
    [104,"2022/23","","S92000003","85 years and over","Male",87.64566990594388,12.35433009405612,8424,189933,160,23],
    [105,"2023/24","","S92000003","0-17 years","Female",93.34127456819536,6.658725431804646,92,1118,170,12],
    [106,"2023/24","","S92000003","0-17 years","Male",96.02927378495028,3.9707262150497282,146,1058,175,7],
    [107,"2023/24","","S92000003","18-44 years","Female",89.45876041766452,10.541239582335473,429,8253,163,19],
    [108,"2023/24","","S92000003","18-44 years","Male",93.07287298481036,6.927127015189637,588,7433.5,170,13],
    [109,"2023/24","","S92000003","45-54 years","Female",89.81841350748647,10.181586492513539,903,16779,164,19],
    [110,"2023/24","","S92000003","45-54 years","Male",92.58973611640472,7.410263883595274,1222,16526,169,14],
    [111,"2023/24","","S92000003","55-64 years","Female",90.05466858245225,9.945331417547756,2393,43433.5,164,18],
    [112,"2023/24","","S92000003","55-64 years","Male",91.71136407486011,8.28863592513988,3195,48330,167,15],
    [113,"2023/24","","S92000003","65-74 years","Female",88.90831858195745,11.09168141804255,4589,92892,162,20],
    [114,"2023/24","","S92000003","65-74 years","Male",89.61461371521779,10.385386284782218,5946,112696.5,164,19],
    [115,"2023/24","","S92000003","75-84 years","Female",88.38289645054101,11.617103549458987,8814,186867.5,161,21],
    [116,"2023/24","","S92000003","75-84 years","Male",88.19885474044128,11.80114525955873,9423,202944,161,22],
    [117,"2023/24","","S92000003","85 years and over","Female",89.83643043917016,10.163569560829835,12285,227868.5,164,19],
    [118,"2023/24","","S92000003","85 years and over","Male",88.42392197924869,11.576078020751304,7915,167215,161,21],
    [119,"2024/25","","S92000003","0-17 years","Female",94.13285086585681,5.867149134143189,106,1135,172,11],
    [120,"2024/25","","S92000003","0-17 years","Male",93.21359715880264,6.786402841197361,135,1672,170,12],
    [121,"2024/25","","S92000003","0-17 years","Missing",100,0,3,0,183,0],
    [122,"2024/25","","S92000003","18-44 years","Female",90.9095086298498,9.090491370150197,477,7913.5,166,17],
    [123,"2024/25","","S92000003","18-44 years","Male",93.40995656531908,6.590043434680923,615,7396.5,170,12],
    [124,"2024/25","","S92000003","45-54 years","Female",90.87100189278496,9.12899810721504,854,14228,166,17],
    [125,"2024/25","","S92000003","45-54 years","Male",93.05010989986901,6.949890100130991,1234,15651.5,170,13],
    [126,"2024/25","","S92000003","55-64 years","Female",89.72154681609902,10.278453183900972,2293,43012.5,164,19],
    [127,"2024/25","","S92000003","55-64 years","Male",91.74865122183434,8.251348778165662,3151,47450,167,15],
    [128,"2024/25","","S92000003","65-74 years","Female",89.15457530587916,10.845424694120839,4493,88929.5,163,20],
    [129,"2024/25","","S92000003","65-74 years","Male",90.00313245126,9.996867548740006,5860,106911.5,164,18],
    [130,"2024/25","","S92000003","75-84 years","Female",88.50267061499663,11.497329385003365,8979,188403,162,21],
    [131,"2024/25","","S92000003","75-84 years","Male",88.38104750178658,11.61895249821341,9546,202419,161,21],
    [132,"2024/25","","S92000003","85 years and over","Female",90.14711451432886,9.852885485671132,12335,221802,165,18],
    [133,"2024/25","","S92000003","85 years and over","Male",88.26573727695992,11.734262723040073,8144,174404,161,21],
    [134,"2025/26","","S92000003","0-17 years","Female",95.47078203572048,4.529217964279521,79,653,174,8],
    [135,"2025/26","","S92000003","0-17 years","Male",95.78301369863014,4.216986301369863,125,962,175,8],
    [136,"2025/26","","S92000003","0-17 years","Missing",100,0,5,0,183,0],
    [137,"2025/26","","S92000003","18-44 years","Female",90.93139682015735,9.06860317984266,498,8242,166,17],
    [138,"2025/26","","S92000003","18-44 years","Male",94.64556803772035,5.354431962279652,767,7495,173,10],
    [139,"2025/26","","S92000003","45-54 years","Female",90.92264302981467,9.077356970185335,816,13518,166,17],
    [140,"2025/26","","S92000003","45-54 years","Male",94.22294259123706,5.777057408762941,1310,13811.5,172,11],
    [141,"2025/26","","S92000003","55-64 years","Female",89.64674463798181,10.353255362018194,2298,43420,164,19],
    [142,"2025/26","","S92000003","55-64 years","Male",91.38669042300923,8.613309576990776,3183,50034.5,167,16],
    [143,"2025/26","","S92000003","65-74 years","Female",88.96414209013108,11.035857909868927,4493,90491,162,20],
    [144,"2025/26","","S92000003","65-74 years","Male",90.32552504232184,9.674474957678154,5721,101009.5,165,18],
    [145,"2025/26","","S92000003","75-84 years","Female",88.95257349265074,11.047426507349265,8768,176776.5,162,20],
    [146,"2025/26","","S92000003","75-84 years","Male",88.7249670609822,11.275032939017802,9586,197250.5,162,21],
    [147,"2025/26","","S92000003","85 years and over","Female",90.69046765982573,9.309532340174277,12273,208517,166,17],
    [148,"2025/26","","S92000003","85 years and over","Male",88.33780468780803,11.662195312191969,7991,170076.5,161,21]
]}