Zurich.ch spanish brand leak
by Tanaka - 27-07-24, 02:18 PM
#81
(27-07-24, 02:18 PM)Tanaka Wrote: 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:
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,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,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Thanks
Reply
#82
(27-07-24, 02:18 PM)Tanaka Wrote: 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:
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,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,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,


thank you
Reply
#83
thanks
Reply
#84
(27-07-24, 02:18 PM)Tanaka Wrote: 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:
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,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,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Reply
#85
(27-07-24, 02:18 PM)Tanaka Wrote: 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:
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,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,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
will useful
Reply
#86
(27-07-24, 02:18 PM)Tanaka Wrote: 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:
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,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,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,


thanks bro
Reply
#87
(27-07-24, 02:18 PM)Tanaka Wrote: Base de datos completa del volcado SQL de la sucursal española de la Compañía de Seguros Zurich
El volcado contiene 4.246.656 líneas con datos de las pólizas de seguros de la compañía.

fecha: 29/06/2021

datos: Nombre/Apellidos, Número de póliza, dirección El. mail, teléfono, dirección, número y marca del coche

Muestra:
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,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,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Reply
#88
Thank you tanaka
Reply
#89
(27-07-24, 02:18 PM)Tanaka Wrote: 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:
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,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,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

thanks

thanks
Reply
#90
(27-07-24, 02:18 PM)Tanaka Wrote: 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:
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,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,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Reply


Forum Jump:


 Users browsing this thread: 1 Guest(s)