DOC20230417192115SINIESTRALIDAD.xlsx

{# full_text keeps real newlines; whitespace-pre-wrap renders them (so no |linebreaks filter, which would double the spacing). #}

## relacion | Estado al Cierre | Código de Expediente | Fecha de Ocurrencia | Fecha de Declaracion | Pagos | Unnamed: 5 | | --- | --- | --- | --- | --- | --- | | Pendiente | 1859 | 2019-08-08 00:00:00 | 2020-03-04 00:00:00 | 2000 | NaN | | Pendiente | 1857 | 2019-12-17 00:00:00 | 2020-03-03 00:00:00 | 1000 | NaN | | NaN | NaN | NaN | NaN | NaN | 3000.0 | | Estado al Cierre | Código de Expediente | Fecha de Ocurrencia | Fecha de Declaracion | Pagos | NaN | | Pendiente | 274 | 2020-01-20 00:00:00 | 2021-01-14 00:00:00 | 1500 | NaN | | Pendiente | 1711 | 2020-10-12 00:00:00 | 2021-03-15 00:00:00 | 1000 | NaN | | Pendiente | 202 | 2020-12-08 00:00:00 | 2021-01-12 00:00:00 | 1500 | NaN | | Terminado | 5030 | 2020-07-02 00:00:00 | 2020-08-07 00:00:00 | 1171 | NaN | | Terminado | 4964 | 2020-07-10 00:00:00 | 2020-08-04 00:00:00 | 0 | NaN | | Terminado | 680 | 2020-11-13 00:00:00 | 2021-01-30 00:00:00 | 3976 | NaN | | NaN | NaN | NaN | NaN | NaN | 9147.0 | | Estado al Cierre | Código de Expediente | Fecha de Ocurrencia | Fecha de Declaracion | Pagos | NaN | | Pendiente | 1422 | 2021-01-19 00:00:00 | 2021-03-03 00:00:00 | 1000 | NaN | | Pendiente | 2089 | 2021-02-19 00:00:00 | 2021-04-02 00:00:00 | 1000 | NaN | | Pendiente | 1622 | 2021-02-26 00:00:00 | 2021-03-11 00:00:00 | 1000 | NaN | | Pendiente | 6510 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 1500 | NaN | | Pendiente | 7945 | 2021-12-10 00:00:00 | 2021-12-20 00:00:00 | 1000 | NaN | | Pendiente | 57 | 2021-12-21 00:00:00 | 2022-01-05 00:00:00 | 1000 | NaN | | Terminado | 479 | 2021-01-18 00:00:00 | 2021-01-22 00:00:00 | 360 | NaN | | NaN | NaN | NaN | NaN | 19008 | 6860.0 | ## siniestralidad | SINIESTRALIDAD POLIZA RESPONSABILIDAD CIVIL AYUNTAMIENTO DE AYER | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | | --- | --- | --- | --- | --- | --- | --- | --- | | Año | Pagos | Reservas | Pagos + Reservas | Nº Siniestros | NaN | Terminados | Pendientes | | 2019 | 0 | 300 | 300 | 2 | NaN | 0 | 2 | | 2020 | 4000 | 5147 | 9147 | 6 | NaN | 3 | 3 | | 2021 | 6500 | 3060 | 9560 | 7 | NaN | 1 | 6 | | 2022 hasta febrero | 446.33 | 3060 | 3506.33 | 2 | NaN | 0 | 2 |