27-07-24, 02:18 PM
The full SQL dump database of the Spanish branch of the Zurich Insurance Company
The dump contains 4.246.656 lines with data from the company's insurance policies of the company.
date: 06/29/2021
data: Name/Surname, Polis number, address El. mail, phone, address, number and brand of car
Sample:
The dump contains 4.246.656 lines with data from the company's insurance policies of the company.
date: 06/29/2021
data: Name/Surname, Polis number, address El. mail, phone, address, number and brand of car
Sample:
Code:
59007,00000000157248,00021,0000000044,00001,0000000416,00250,00001,6300,INDIVIDUAL MEDIACION,ENRIQUE FERNANDO,RETUERTO,MARTINEZ,N,NIF,74333609R,CL,Calle,Maestro Mora ,0055,YECLA,30510,MURCIA,669856303,2017-01-04,2018-01-03,2008-02-13,NULL,A,A,,,,,,,,,0000000,000000,00000,00,,000,000,0,,,0000044046,YECLA-JOSE JUAN MOLINA SL,EST,BISBE CATALA,,,,0000,,,,0000,,,,0000,N,Sin asistencia especial,Z,Zurich,ES,ESPAÑOL,,,S,2017-01-04,L,Liquidado,S,,,,,0000000000000000,000,0000000000000000,000,,,NULL,0000000000000000,000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
59008,00000000157248,00022,0000000044,00001,0000000411,00250,00001,6300,INDIVIDUAL MEDIACION,ENRIQUE FERNANDO,RETUERTO,MARTINEZ,N,NIF,74333609R,CL,Calle,Maestro Mora ,0055,YECLA,30510,MURCIA,669856303,2018-01-04,2019-01-03,2001-01-04,NULL,B,A,,,,,,,,,0000000,000000,00000,00,,000,000,0,,,0000044046,YECLA-JOSE JUAN MOLINA SL,EST,BISBE CATALA,,,,0000,,,,0000,,,,0000,N,Sin asistencia especial,Z,Zurich,ES,ESPAÑOL,,,S,2018-01-04,L,Pendiente,S,,,,,0000000000000000,000,0000000000000000,000,,,NULL,0000000000000000,000,,,,,,,1,1 - Valor Top,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
59009,00000000157248,00022,0000000044,00001,0000000416,00250,00001,6300,INDIVIDUAL MEDIACION,ENRIQUE FERNANDO,RETUERTO,MARTINEZ,N,NIF,74333609R,CL,Calle,Maestro Mora ,0055,YECLA,30510,MURCIA,669856303,2018-01-04,2019-01-03,2008-02-13,NULL,A,A,,,,,,,,,0000000,000000,00000,00,,000,000,0,,,0000044046,YECLA-JOSE JUAN MOLINA SL,EST,BISBE CATALA,,,,0000,,,,0000,,,,0000,N,Sin asistencia especial,Z,Zurich,ES,ESPAÑOL,,,S,2018-01-04,L,Pendiente,S,,,,,0000000000000000,000,0000000000000000,000,,,NULL,0000000000000000,000,,,,,,,1,1 - Valor Top,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
59010,00000000157248,00023,0000000044,00001,0000000416,00250,00001,6300,INDIVIDUAL MEDIACION,ENRIQUE FERNANDO,RETUERTO,MARTINEZ,N,NIF,74333609R,CL,Calle,Maestro Mora ,0055,YECLA,30510,MURCIA,669856303,2019-01-04,2020-01-03,2008-02-13,NULL,B,A,,,,,,,,,0000000,000000,00000,00,,000,000,0,,,0000044046,YECLA-JOSE JUAN MOLINA SL,EST,,,,,0000,,,,0000,,,,0000,N,Sin asistencia especial,Z,Zurich,ES,ESPAÑOL,,,S,2020-04-03,A,Pendiente,S,,,,,0000000000000000,000,0000000000000000,000,,,NULL,0000000000000000,000,,,,,,,2,2 - Valor Alto,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
59011,00000000157248,00025,0000000044,00001,0000000416,00250,00001,6300,INDIVIDUAL MEDIACION,ENRIQUE FERNANDO,RETUERTO,MARTINEZ,N,NIF,74333609R,CL,Calle,Maestro Mora ,0055,YECLA,30510,MURCIA,669856303,2020-01-04,2021-01-03,2008-02-13,NULL,B,B,,,,,,,,,0000000,000000,00000,00,,000,000,0,,,0000044046,YECLA-JOSE JUAN MOLINA SL,EST,[email protected],TL,34,968795721,,,,,,,,,,,,Z,Zurich,ES,ESPAÑOL,,,S,2020-01-04,A,Anulado,S,,,,,0000000000000000,000,0000000000000000,000,,,NULL,0000000000000000,000,,,,,,,2,2 - Valor Alto,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
59012,00000000167494,00019,0000000044,00001,0000000411,00250,00001,6300,INDIVIDUAL MEDIACION,FRANCESCA,BLASCO,BARDAS,N,NIF,37726951M,PZ,Plaza,Sagrada Familia,0009,BARCELONA,08025,BARCELONA,,2017-01-01,2017-12-31,2001-01-01,NULL,A,A,,,,,,,,,0000000,000000,00000,00,,000,000,0,,,0000007112,BARCELONA-FERRER Y OJEDA,EST,TRAVESSERA DE GRACIA,TL,34,932578037,,TL,34,934578037,,MO,34,677446738,,N,Sin asistencia especial,Z,Zurich,ES,ESPAÑOL,,,S,2017-01-01,L,Liquidado,S,,,,,0000000000000000,000,0000000000000000,000,,,NULL,0000000000000000,000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
59013,00000000167494,00020,0000000044,00001,0000000411,00250,00001,6300,INDIVIDUAL MEDIACION,FRANCESCA,BLASCO,BARDAS,N,NIF,37726951M,PZ,Plaza,Sagrada Familia,0009,BARCELONA,08025,BARCELONA,,2018-01-01,2018-12-31,2001-01-01,NULL,B,A,,,,,,,,,0000000,000000,00000,00,,000,000,0,,,0000007112,BARCELONA-FERRER Y OJEDA,EST,TRAVESSERA DE GRACIA,TL,34,932578037,,TL,34,934578037,,MO,34,677446738,,N,Sin asistencia especial,Z,Zurich,ES,ESPAÑOL,,,S,2018-01-01,L,Pendiente,S,,,,,0000000000000000,000,0000000000000000,000,,,NULL,0000000000000000,000,,,,,,,3,3 - Valor Medio,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
59014,00000000374991,00019,0000000044,00001,0000000411,00250,00001,6300,INDIVIDUAL MEDIACION,JUANA,LOPEZ,SANCHEZ,N,NIF,74819585X,AV,Avenida,Santa Rosa de Lima,0022,MALAGA,29007,MALAGA,639729674,2017-01-24,2018-01-23,2001-01-24,NULL,A,A,,,,,,,,,0000000,000000,00000,00,,000,000,0,,,0000043011,MALAGA-PEREZ ROMERO DE LA CRUZ,ACT,Temple,MO,34,687565969,0000,,,,0000,,,,0000,N,Sin asistencia especial,Z,Zurich,ES,ESPAÑOL,,,S,2017-01-24,L,Liquidado,S,,,,,0000000000000000,000,0000000000000000,000,,,NULL,0000000000000000,000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
