{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Notes","Data"],"not_rendered":{"charts":0,"images":0,"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":"Notes","index":0,"n_rows":54,"n_cols":19,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Title:",null,"Child motor vehicle injuries and fatalities"]
[null,"Reference number:",null,"AR-1284"]
[]
[null,"Author:",null,"Analytics & Reporting, ACC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAS"]
[null,"Date:",null,"2021-06-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In Fact"]
[null,"Purpose:",null,"Official Information Act (OIA) Response"]
[]
[null,"Period:",null,"1 January 2012 to 31 May 2021"]
[null,"Basis for tracking:",null,"Registration date, payment date, cover decision, fund, road agency, age at registration, fatal indicator, primary diagnosis"]
[null,"Analysis tool:",null,"SAS"]
[null,"DWH load date:",null,"2021-06-06"]
[]
[]
[]
[]
[null,null,null,"Please note that our road agency fields do not differentiate between drivers and passengers, but as 14 is under the legal driving age it is likely that these claims"]
[null,null,null,"are primarily for passengers."]
[]
[null,null,null,"Response:"]
[null,null,null,"The data have been extracted based on the following criteria:"]
[null,null,null,"The claim registration / payment date is between 1 January 2012 and 31 May 2021."]
[null,null,null,"The claim cover decision is equal to 'Accept' unless otherwise specified."]
[null,null,null,"The fund is in the road account."]
[null,null,null,"The road agency is equal to:"]
[null,null,null,"Driving / Passenger - Car"]
[null,null,null,"Driving / Passenger - Bus"]
[null,null,null,"Driving / Passenger - Motorcycle"]
[null,null,null,"Driving / Passenger - Truck"]
[null,null,null,"Driving / Passenger - Other Vehicle"]
[null,null,null,"The client's age at claim registration is between 0 and 14 years."]
[null,null,null,"If the fatal indicator is equal to 'Y' / yes, the diagnosis has been listed as 'Fatal'."]
[]
[null,null,null,"Caveats:"]
[null,null,null,"A calendar year is 1 January to 31 December."]
[null,null,null,"Accredited employer claims have been excluded."]
[null,null,null,"New claims - the claims in these tables have been counted by the date that the claim was registered with ACC. This can be immediately after the injury"]
[null,null,null,"occurred or at any later stage."]
[null,null,null,"Active claims - are claims that generated a payment in the relevant calendar years. These claims were not necessarily registered, or had the accident occur,"]
[null,null,null,"in the same calendar year."]
[null,null,null,"Costs provided are exclusive of GST."]
[null,null,null,"Costs are based on payment date. Payment date may be different to the date of service."]
[null,null,null,"Costs do not include Public Health Acute Services (PHAS) payments. Acute treatment for covered claims in public hospitals is provided by an annual service"]
[null,null,null,"agreement between ACC and the Ministry of Health, and is funded by bulk payments from ACC to the Crown."]
[null,null,null,"The calendar year in which the service was paid may differ to the calendar year in which the service was provided."]
[null,null,null,"A claim can be active in multiple calendar years. In tables 1 and 4, a claim which has payments in more than one year is counted as 'active' once in each calendar year there is a payment."]
[null,null,null,"For example, a claim which has payments in 2018 to 2020 would be counted a total of three times, once in each calendar year."]
[null,null,null,"Age is based on the client's age at claim registration and may differ to their age at the time of an accident."]
[null,null,null,"Diagnosis is based on the client's primary injury. Claims may have multiple injuries; however, these secondary injuries will not show within this data extract."]
[null,null,null,"ACC is not able to confirm its fatality statistics reflect the actual number of deaths as a result of an accident for the following reasons:"]
[null,null,null,"- Many people are not aware that they can make a claim related to an accidental death of a family member and therefore ACC only receives claims for a subset of accidental deaths"]
[null,null,null,"- If a person who has an accepted claim with ACC dies of their injuries, or other causes, ACC is not necessarily notified of this."]
[null,null,null,"The data was extracted on 18 June 2021 and may differ if rerun at a later date."]

{"sheet":"Data","index":1,"n_rows":107,"n_cols":12,"rows_kept":107,"cut":false,"hidden":false,"merged":[[64,2,64,11],[4,6,7,8],[80,5,85,8],[96,5,103,8],[21,2,21,11],[31,2,31,11],[48,2,48,11]]}
[]
[null,"Table 1: Number of new claims, number of active claims, and active claim costs (excluding GST) for"]
[null,"motor vehicle related injuries to clients aged 0 to 14 between 1 January 2012 and 31 May 2021."]
[]
[null,"Calendar Year","New Claims","Active Claims","Active Costs",null,"Please note that the total active costs in tables 1 and 5 may differ slightly due to rounding when summing amounts manually vs in SAS."]
[null,2012,1551,1867,10634117]
[null,2013,1623,1870,11202788]
[null,2014,1584,1822,11941062]
[null,2015,1584,1502,12567606]
[null,2016,1804,1657,14136220]
[null,2017,1806,1669,14768781]
[null,2018,1814,1699,15491530]
[null,2019,1757,1618,16570548]
[null,2020,1376,1391,16783145]
[null,"2021 (YTD)",643,871,7227915]
[]
[]
[null,"Table 2: Number of new accepted and declined claims for motor vehicle related injuries to clients aged 0 to 14 registered between 1 January 2012 and 31 May 2021, broken"]
[null,"down by cover decision."]
[null,"Please note that there were no declined fatal claims in this cohort."]
[]
[null,null,"Registration Calendar Year"]
[null,"Cover Decision",2012,2013,2014,2015,2016,2017,2018,2019,2020,"2021 (YTD)"]
[null,"Accept",1551,1623,1584,1584,1804,1806,1814,1757,1376,643]
[null,"Decline",59,69,64,68,83,64,54,49,36,15]
[null,"Total",1610,1692,1648,1652,1887,1870,1868,1806,1412,658]
[]
[]
[null,"Table 3: Number of new claims for motor vehicle related injuries to clients aged 0 to 14 registered between 1 January 2012 and 31 May 2021, broken down by fatal claims"]
[null,"and top 5 most common primary diagnoses."]
[]
[null,null,"Registration Calendar Year"]
[null,"Primary Diagnosis",2012,2013,2014,2015,2016,2017,2018,2019,2020,"2021 (YTD)"]
[null,"Fatal",8,7,14,6,11,11,13,11,9,2]
[null,"Soft Tissue Injury",1021,1045,1025,1051,1177,1152,1118,1058,754,350]
[null,"Laceration / Puncture / Sting",289,338,279,269,310,308,311,324,256,128]
[null,"Fracture / Dislocation",83,109,99,117,112,123,136,145,123,64]
[null,"Concussion / Brain Injury",70,56,66,62,61,74,69,58,63,21]
[null,"Dental Injury",14,6,14,10,20,15,19,25,15,10]
[]
[null,"Other / Unknown",66,62,87,69,113,123,148,136,156,68]
[null,"Total",1551,1623,1584,1584,1804,1806,1814,1757,1376,643]
[]
[null," We would usually suppress claim numbers < 4, but have not in these tables as the deaths are likely to have been reported in the media."]
[]
[null,"Table 4: Number of active claims for motor vehicle related injuries to clients aged 0 to 14 with a payment made between 1 January 2012 and 31 May 2021, broken down by"]
[null,"fatal claims and top 5 most common primary diagnoses."]
[]
[null,null,"Payment Calendar Year"]
[null,"Primary Diagnosis",2012,2013,2014,2015,2016,2017,2018,2019,2020,"2021 (YTD)"]
[null,"Fatal",14,15,14,11,11,13,15,13,9,5]
[null,"Soft Tissue Injury",1033,1055,994,810,932,882,902,837,650,363]
[null,"Fracture / Dislocation",205,220,225,221,237,229,241,253,244,187]
[null,"Laceration / Puncture / Sting",301,318,279,211,199,229,216,206,183,111]
[null,"Concussion / Brain Injury",107,79,91,82,70,81,84,76,80,51]
[null,"Dental Injury",58,49,61,44,47,48,64,74,60,30]
[]
[null,"Other / Unknown",149,134,158,123,161,187,177,159,165,124]
[null,"Total",1867,1870,1822,1502,1657,1669,1699,1618,1391,871]
[]
[]
[null,"Table 5: Active claim costs (excluding GST) for motor vehicle related injuries to clients aged 0 to 14 with a payment made between 1 January 2012 and 31 May 2021, broken down"]
[null,"by fatal claims and top 5 most common primary diagnoses."]
[]
[null,null,"Payment Year"]
[null,"Primary Diagnosis",2012,2013,2014,2015,2016,2017,2018,2019,2020,"2021 (YTD)"]
[null,"Fatal",274840,92752,112436,131526,255180,147265,79770,57991,42071,23138]
[null,"Soft Tissue Injury",3410547,3761801,4002220,4546932,4634004,4636409,4943297,5399023,5538174,2527236]
[null,"Fracture / Dislocation",2581972,2436067,2571778,2879446,3406251,3407662,4112563,4159488,4417708,1804527]
[null,"Concussion / Brain Injury",1402211,1403930,1526300,1338096,1520352,1973163,1540466,1497144,1502324,666870]
[null,"Laceration / Puncture / Sting",362365,340525,287917,237888,299976,314828,355949,683304,302949,133021]
[null,"Amputation / Enucleation",35497,85957,106012,33833,96732,280694,215155,99832,376542,120233]
[]
[null,"Other / Unknown",2566682,3081754,3334401,3399885,3923724,4008759,4244330,4673765,4603378,1952890]
[null,"Total",10634114,11202786,11941064,12567606,14136219,14768780,15491530,16570547,16783146,7227915]
[]
[]
[]
[null,"Table 6: Lifetime costs to 31 May 2021 for fatal motor vehicle related injuries to clients aged 0 to 14 by year claim was registered "]
[]
[null,"Claim Registration Year","No. of fatal claims","All costs for these claims",null,"Please note that these are the total lifetime costs for fatal motor vehicle related injuries for clients aged 0 to 14 broken down by the year of registration. For example, the total lifetime cost of all 8 fatal claims registered in 2012 is $47,483. Not all payments were necessarily made in 2012. See also table 7."]
[null,2012,8,47483]
[null,2013,7,29589]
[null,2014,14,86153]
[null,2015,6,54918]
[null,2016,11,138322]
[null,2017,11,48509]
[null,2018,13,73948]
[null,2019,11,62796]
[null,2020,9,48182]
[null,"2021 (YTD)",2,11254]
[]
[]
[null,"Table 7: For fatal motor vehicle related injuries to clients aged 0 to 14 registered between"]
[null,"1 January 2012 and 31 May 2021 payments made in the year of claim registration."]
[]
[null,"Claim Registration Year","No. of fatal claims","Registration year costs",null,"Please note that these are the costs of fatal motor vehicle related injuries for clients aged 0 to 14 where payments were made in the same year as registration. For example, the costs of all 8 fatal claims registered in 2012 which were paid in 2012 is $44,834. This means that even if a claim was registered on 30 December 2012, only payments up until 31 December 2012 are included in this table."]
[null,2012,8,44834]
[null,2013,7,29589]
[null,2014,14,70487]
[null,2015,6,54918]
[null,2016,11,133086]
[null,2017,11,46990]
[null,2018,13,72947]
[null,2019,11,57023]
[null,2020,9,37361]
[null,"2021 (YTD)",2,11254]