• XSS.stack #1 – первый литературный журнал от юзеров форума

CSV База данных Испании

N9XDZ

(L1) cache
Пользователь
Регистрация
19.08.2020
Сообщения
680
Решения
1
Реакции
846
Гарант сделки
2
Депозит
0.0002
Поля:
SCV_ID,"LEGAL_IDENTIFIER","TYPE","SCV_MARKETING_FLAG","SCV_EMAIL_ADDRESS","VALID_EMAIL_ADDRESS_FLAG","SCV_PHONE1","VALID_PHONE1_FLAG","SCV_PHONE2","VALID_PHONE2_FLAG","SCV_PHONE3","VALID_PHONE3_FLAG","CUSTOMER_GENDER","CUSTOMER_TITLE","CUSTOMER_FORENAME","CUSTOMER_SURNAME","BIRTH_DATE","ROAD_TYPE","STREET","NUM","FLOOR","CITY","PROVINCE","POSTAL_CODE","DTR_SOURCE","DTR_SOURCE_DETAILS","DECEASED","PROSPECT_FLAG","CONTROL_GROUP","CONTROL_GROUP_DATE","CREATED_DATE","CREATED_BY","UPDATED_DATE","UPDATED_BY","DWH_CREATED_DATE","DWH_CREATED_DATE_KEY","DWH_UPDATED_DATE","DWH_UPDATED_DATE_KEY","DWH_DELETED","DWH_UNSUBSCRIBED","DTR_BEST_BRANCH_NUMBER","DTR_BEST_BRANCH_NAME","DTR_OB_LAST_CALL_DATE","DTR_OB_LAST_CALL_CAMPAIGN","NATIONALITY_CODE","NATIONALITY_NAME","NPS_FLAG","NPS_UPDATED_DATE","NPS_CONTACT_DATE","NPS_CONTACT_DATE_KEY","NPS_CONTACT_TYPE","NPS_SCORE","NPS_PHONE","SH_FLAG","SH_PRODUCT_FLAG","BCN","VALID_BCN","DFL_CUS_SMS_PERMISSION","DFL_CUS_OB_PERMISSION","DFL_CUS_EMAIL_PERMISSION","DFL_OB_PERM_DATE","DFL_SMS_PERM_DATE","DFL_EMAIL_PERM_DATE","COMUNICACION_TERCEROS","PERFIL_COMERCIAL","COMUNICACION_PH","GDPR_DATE"

Внутри архива 2 файла:
SEGUROSPH.POLICY_RECEIPTS_2.7m.csv - 2.672.025 строк
DWH_CUSTOMER_DATA_202104160010_13_million.csv - 12 миллионов строк

UPD + 3 файла:
POS.CUSTOMER_GDPR_46k.csv - 46.113 строк
POS.FINANCING_CUSTOMER_178k.csv - 181.843 строк
SMARTHOUSE.TRANSACTION_CUSTOMER_776k.csv - 790.281 строк


"446","11920380D","ROBERTO","ALONSO","CASTELLANOS","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES7600814356740001007306"
"447","43438065N","LIDIA","ARCAS","LOPEZ","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES8021005400130200033306"
"449","13161703E","MARGARITA","HERNANDO","PEREZ","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES6520170022980000068200"
"450","50899223Q","SERGIO","MARTINEZ","MORENO","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES1920858297010330140732"
"452","50958816Q","MARIA DE LOS ANGELES","SARO","FERNANDEZ","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES8414650100981716026242"
"453","26764061L","MIRIAM","DESCALZO","TARRAGA","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES5621004485960100233418"
"455","28771670G","SABINO","RUIZ","DIAZ","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES4300815493840001268429"
"456","72985577E","RUBEN","GRACIA","ORIOL","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES3220850103990332256379"
"458","22459677Q","JOSE MANUEL","NICOLAS","FERNANDEZ","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES6914650320011717208030"
"459","78162460L","OLEH","VOZNYUK","VOZNYUK","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES3400304149870391978273"
"461","20061673S","JAVIER","MARTINEZ","LUQUE","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES7014650100911722793848"
"462","02592240W","HECTOR RENE","RAMIREZ","GUAMAN","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES9320381125183002812348"
"464","48400936N","IRENE","GARCIA","PEREZ","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES6500496829612410005829"
"465","48400936N","IRENE","GARCIA","PEREZ","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES6500496829612410005829"
"467","54041528S","LAURA SILVIA","RODRIGUEZ","SANTOS","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES6521002168300100267271"
"468","46726538Z","JOAN MARC","PASCUAL","CLARAMUNT","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES7621001805180200031008"
"470","44826264T","LUIS","VEREA","VAZQUEZ","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES5820910336313000046078"
"471","20206386N","BEATRIZ","HIERRO","REVUELTA","AVIVA VIDA Y PENSIONES S.A. DE SEGUROS","ES5100307044750389083273"

3146180,X6281690E,R,1,no@hotmail.com,N,"976456123",N,"693470243",Y,"693470243",Y,M,,EL HASSAN,MGAAD ,1977-05-03 00:00:00,Calle,DON BLASCO,4,"4A",ALAGON,Zaragoza,"50630",PIE,Cliente sistema PIE,0,N,N,2013-06-02 00:00:00,2013-06-01 00:00:00,MIG_UNICA_SCV,2021-01-28 12:05:02,WS_POS_BACKOFFICE,2016-12-15 13:33:03,"20161215",2021-01-28 12:30:04,"20210128",0,0,796,CC Alcampo Utebo,,,MA,Marruecos,0,,,,,,,0,0,"693470243",Y,0,1,0,2018-04-19 22:11:02,2018-04-19 22:11:02,2018-04-19 22:11:02,0,0,0,
3146703,X6288073B,R,1,milano1999@hotmail.es,Y,"693532703",Y,"985745874",N,,N,M,SR,MOHAMED,EL ABDLAOUI ,1991-07-04 00:00:00,Calle,aa,,,aa,Asturias,"33870",SMARTHOUSE,Cliente plataforma SMARTHOUSE,0,N,N,2010-09-11 00:00:00,2010-09-10 00:00:00,MIG_UNICA_SCV,2019-07-04 19:19:48,WS_POS_BACKOFFICE,2016-12-15 13:33:03,"20161215",2019-07-04 19:30:10,"20190704",0,0,,,,,ES,España,0,,,,,,,0,0,"693532703",Y,1,1,0,2018-04-19 22:11:02,2018-04-19 22:11:02,2018-04-19 22:11:02,0,0,0,
1628619,X6291714H,R,1,notiene@notiene.com,N,"625820984",Y,"977415288",N,,N,M,SR,ADRIAN IOAN,MORAR ,1971-03-23 00:00:00,,AIRES,10,,ALCANAR,Tarragona,"43530",PIE,Cliente sistema PIE,0,N,N,2006-10-03 00:00:00,2006-09-30 00:00:00,MIG_UNICA_SCV,2016-04-16 19:35:20,,2016-12-15 01:54:51,"20161215",2018-05-28 02:53:35,"20180528",0,0,235,CC Vinaroz (Castellón)WUL,,,RO,Rumanía,0,,,,,,,0,0,"627030629",Y,1,1,0,2018-04-19 22:11:02,2018-04-19 22:11:02,2018-04-19 22:11:02,0,0,1,2018-05-17 00:00:00
3147210,X6293429P,R,1,doini_pop@yahoo.com,N,"666241580",Y,"666241580",Y,,N,M,,GRIGORE,MARIN POP,1992-04-04 00:00:00,Camino,MURILLO,26,,FUENTEALAMO,Albacete,"02651",PIE,Cliente sistema PIE,0,N,N,2011-02-16 00:00:00,2011-02-15 00:00:00,MIG_UNICA_SCV,2020-01-21 17:23:15,WS_POS_BACKOFFICE,2016-12-15 13:33:03,"20161215",2020-01-23 00:30:13,"20200123",0,0,355,CC Imaginalia (Albacete),,,RO,Rumanía,0,,,,,,,0,0,"666241580",Y,1,1,0,2018-04-19 22:11:02,2018-04-19 22:11:02,2018-04-19 22:11:02,0,0,1,2018-05-24 22:44:21

"GDPR000000277","4330256","07964274H","JESUS","MARTIN","BARRIOS","JESUS.MARTIN@FRANQUICIASPHONEHOUSE.ES","652550801","685459105","1974-05-02 00:00:00","2018-05-26 09:56:30"
"GDPR000000278","11823363","44290160A","ANTONIO","NIEVAS","REJON","A.A@GMAIL.COM","924555555",\N,"1976-04-10 00:00:00","2018-05-26 09:58:43"
"GDPR000000287","11823389","09333231S","ALVARO","GRANDOSO","MAYORDOMO","a@a.es","609850314",\N,"1971-09-26 00:00:00","2018-05-26 10:19:48"
"GDPR000000293","11823411","70723284D","MERCEDES","MARTIN VIVERO","LOPEZ","javier_ram_mustang@hotmail.c","661323253",\N,"1955-08-06 00:00:00","2018-05-26 10:41:16"
"GDPR000000298","11823436","12105285V","MIGUEL","TREVEJO","HOLGADO","a.es@a.es","983000000",\N,"2033-04-02 00:00:00","2018-05-26 10:54:07"
"GDPR000000304","11823412","26180741W","RAFAEL","LOZANO","MARTINEZ","rabamar1955@gmail.com","600463263",\N,"1955-02-23 00:00:00","2018-05-26 11:02:22"
"GDPR000000309","11823467","19993710V","MARIA DOLORES","GREGORI","PEIRO","mgregor4@xtec.cat","690137023",\N,"1962-06-09 00:00:00","2018-05-26 11:15:10"
"GDPR000000310","11823475","Y3696550G","FELICIA","CONSTANTIN",\N,"a@a.es","642194465",\N,"1994-01-27 00:00:00","2018-05-26 11:16:30"
"GDPR000000316","11823483","03590769D","ISIDRO","VALENCIA","VERDUGO",\N,"918582454",\N,"2032-01-21 00:00:00","2018-05-26 11:24:39"

"2","50953037X","1967-12-17 00:00:00","FERNANDO","FUERTES","SIERRA","lobovk8@hotmail.com","2","ES","634009246",\N,"MADRID","28053","MEMBEZAR","219","2017-09-27 11:37:48"
"4","13939678E","1971-01-04 00:00:00","ANDRES","PRIETO","PARDO","andres.plasticos@hotmail.com","2","ES","638779841",\N,"RENEDO D EPIELAGOS","39470","SAN ANTONIO","11","2017-09-27 12:20:15"
"114","78012594K","1986-03-17 00:00:00","DENNIS FABIAN","CAICEDO","LARA","dennisfabian27@gmail.com","2","ES","618678722",\N,"ELCHE","03203","JULIO HERVAS SAINZ","5","2017-10-02 14:44:06"
"117","47966784P","1992-06-14 00:00:00","ERIC","MATHEU","PINEDA","epinedamatheu@gmail.com","2","ES","610951972",\N,"LLORET BLAU","17310","LA SELVA","66","2017-10-02 17:12:55"
"125","X8329839K","1990-08-17 00:00:00","BOHDAN","LYPKA",\N,"a@a.es","2","UA","609380329",\N,"LOS ALCAZARES","30710","SAN EUGENIO","3","2017-10-02 20:01:09"
"666","39365081Y","1974-09-23 00:00:00","MONTSERRAT","RUIZ","PEON","criera450@gmail.com","1","ES","660870833",\N,"CASTELLVELL I EL VILAR","08296","JOAQUIM BORRAS","96","2017-10-24 11:43:42"
"668","46593045J","1971-09-10 00:00:00","LUIS MANUEL","MUÑOZ","RAYO","luisjoana2010@gmail.com","2","ES","657126524",\N,"GAVA","08850","RIUS I TAULET","6","2017-10-24 11:45:50"

"1264812","25534450B","1942-02-19 00:00:00","Jose Antonio","Barea","Alberto","jose.bareabocanegra@gmail.com","2",\N,"951151568","636456147",\N,\N,\N,\N,\N,\N,\N,\N,"2015-10-15 09:50:11"
"1264813","44355182G","1976-01-14 00:00:00","SONIA","BOLEA","ALCAIDE","sboleaalcaide@hotmail.com","1",\N,"626263636",\N,\N,\N,\N,\N,\N,\N,\N,\N,"2015-10-15 09:50:13"
"1264814","30446773V","1959-12-24 00:00:00","FRANCISCO","RAMIREZ","ZURITA","yoxmi22@gmail.com","2",\N,"695500098",\N,\N,\N,\N,\N,\N,\N,\N,\N,"2015-10-15 09:50:15"
"1264815","50423530D","1962-12-03 00:00:00","MARIA SOL","ALMENDRO","SANCHEZ","sol.46@hotmail.es","1",\N,"615174911",\N,\N,\N,\N,\N,\N,\N,\N,\N,"2015-10-15 09:50:17"
"1264816","23052776Z","1985-02-16 00:00:00","Maria Soledad","Cegarra","Cavezos","copisteriacopyon@gmail.com","1",\N,"619526087","630112185",\N,\N,\N,\N,\N,\N,\N,\N,"2015-10-15 09:50:19"
"1213312","52772921L",\N,"maria de gracia","delgado","moreno","damadel1984@gmail.com","1",\N,"669993657","669993657","virgen del puig","19","3 3b","alicante","Alicante","03","03009",\N,"2015-10-08 14:51:39"
"1213318","52772921L",\N,"maria de gracia","delgado","moreno","damadel1984@gmail.com","1",\N,"669993657","669993657","virgen del puig","19","3 3b","alicante","Alicante","03","03009",\N,"2015-10-08 14:52:28"

 
Последнее редактирование:
Добрый день. Спасибо за файлы. В оригинальной раздаче автор добавил ещё 3 файла, можете их тоже слить сюда? Заранее благодарен.

  • ADDED 23/04/2021
    • POS.CUSTOMER_GDPR_46K.CSV [6.54 MiB]
    • POS.FINANCING_CUSTOMER_178K.CSV [30.94 MiB]
    • SMARTHOUSE.TRANSACTION_CUSTOMER_776K.CSV [154.46 MiB]
 
Добрый день. Спасибо за файлы. В оригинальной раздаче автор добавил ещё 3 файла, можете их тоже слить сюда? Заранее благодарен.

  • ADDED 23/04/2021
    • POS.CUSTOMER_GDPR_46K.CSV [6.54 MiB]
    • POS.FINANCING_CUSTOMER_178K.CSV [30.94 MiB]
    • SMARTHOUSE.TRANSACTION_CUSTOMER_776K.CSV [154.46 MiB]
Обновил )
 
When I first tried to download it, it was downloading at a rate of 20 Kbps. It was annoying...
I wonder where the Babuk servers are located.
Если у тебя vpn из Бабука, то это Болгария. Скорость загрузки с этого фо отличная)
 


Напишите ответ...
  • Вставить:
Прикрепить файлы
Верх