Loading component...
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:
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,adela@juanmolinaseguros.com,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,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,