{"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":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[13,2,14,16],[17,2,18,16]]}
[]
[null,"GOV-024168 Appendix 1"]
[]
[null,null,"Response:"]
[null,null,"The data have been extracted based on the following criteria:"]
[null,null," - Accident date/payment date between 01 January 2018 and 31 December 2022 for new and active claims respectively. "]
[null,null," - Fund code is equal to 'Motor Vehicle Fund'."]
[null,null," - Age at the time of the accident is between 5 and 10. "]
[null,null," - Region is equal to Auckland region. "]
[]
[null,null,"Caveats:"]
[null,null," - New claims: the claims in these tables have been counted by the date that accident occurred. ACC may register the claim on a different date."]
[null,null," - Active claims: are claims that generated a payment in the relevant periods. These claims were not necessarily registered, or had the accident occur, in the same period."]
[null,null," - A claim can cover multiple years. A claim which lasts longer than one year is counted as ‘active’ once for each year covered. For example, a claim which lasted from 2016 to 2020 would be counted a total of five times, once for each year."]
[]
[null,null," - Costs provided are exclusive of GST."]
[null,null," - Costs are based on payment date. Payment date may be different to the date of service."]
[null,null," - Costs do not include Public Health Acute Services (PHAS) payments. Treatment for covered claims in public hospitals is provided by an annual service agreement between ACC and the Ministry of Health, and is funded by bulk payments from ACC to the Crown."]
[]
[null,null," - Age is based on client's age at the time of the accident. "]
[null,null," - Location is based on the client’s current location and may not be where the client was residing at the time of the accident"]
[null,null," - The data was extracted on 11 April 2023 and may differ if extracted again at a later date."]

{"sheet":"Data","index":1,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,1,3,7],[13,1,14,7]]}
[]
[]
[null,"Table 1. Number of new, active claims, and total costs (excluding GST) between 01 January 2018 and 31 December 2022 for road accident between children aged 5 - 10 years old in the Auckland region."]
[]
[]
[null,"Calendar Year","New Claims","Active Claims","Total Costs"]
[null,2018,267,1019,12060676.92]
[null,2019,308,1096,12136636.869999999]
[null,2020,245,1017,12022543.23]
[null,2021,238,973,11402982.060000001]
[null,2022,307,1039,13452279.09]
[]
[]
[null,"Table 2. Number of new claims between 01 January 2018 and 31 December 2022 for road accident between children aged 5 - 10 years old in the Auckland region, broken down by primary external agency.  "]
[]
[]
[null,"Primary External Agency",2018,2019,2020,2021,2022]
[null,"Driving/Passenger - Car",157,153,114,103,126]
[null,"Pedestrian",34,37,32,34,41]
[null,"Cycling",15,12,15,15,8]
[null,"Driving/Passenger - Motorcycle",9,19,17,6,13]
[null,"Driving/Passenger-Other Vehicle",13,14,"..",8,6]
[null,"Driving/Passenger - Bus",9,10,"<4","<4",5]
[null,"Driving/Passenger - Truck","<4",5,"<4","<4",5]
[null,"Other/Not Obtainable","..",58,55,68,103]
[null,"Grand Total",267,308,245,238,307]