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

agxfinanceira.com Brazil Finances 10 700 000

В этой теме можно использовать автоматический гарант!

Новая сделка
Отслеживать
Vespiary

Vespiary

data scientist
Premium
Регистрация
12.07.2020
Сообщения
745
Реакции
497
Гарант сделки
11
Цена
1500$
Контакты
https://t.me/sorblines - все виды контактов указаны в профиле
Всем привет

image.png


сайт https://agxfinanceira.com/ - основное направление выдача кредитов под залог жилья

данные представляют собой дамп сервера mysql состоящим из 78 таблиц csv общим объемом 8 гб +

общая статистика по данным (всем таблицам)

phone no duble - 10 772 000
CPF no duble 3 802 000
email no duble 1 200 000

примеры некоторых таблиц и статистика по ним

"cliente phone" - 31 425 000 строк , номеров телефонов без дубликатов 10 772 000 - - таблица представляет собой результаты валидатора номеров телефонов

пример данных ( кому сложно прочесть, создайте csv и вставте)

Код: 
"ID","FONE","VALIDADO","WHATSAPP","DISCADO","ID_CLIENTE"
"501840","15996508758","1","1","0","122138"
"501841","15996508758","1","1","0","122138"
"501842","15998456222","1","1","0","122138"
"501843","15998456222","1","1","0","122139"
"1191433","8232237894","0","0","0","226525"
"1191434","48984566122","0","0","0","226526"
"1191435","4833744291","0","0","0","226526"
"1191436","4830934821","0","0","0","226526"
"1191437","48999652280","0","0","0","226526"
"1191438","48996096571","0","0","0","226526"
"1191439","48996522800","0","0","0","226526"
"1191440","8433453544","0","0","0","226527"
"1191441","8436149832","0","0","0","226527"
"1191442","8433431436","0","0","0","226527"
"1191443","84987472129","0","0","0","226527"
"1191444","84987472066","0","0","0","226527"
"1191445","7528123050","0","0","0","226528"
"1191446","53994710976","0","0","0","226528"
"1191447","7532812105","0","0","0","226528"
"1191448","13964772539","0","0","0","226529"
"1191449","3832511147","0","0","0","226529"
"1191450","38997477557","0","0","0","226529"
"1191451","38999665465","0","0","0","226529"
"1191452","1434410811","0","0","0","226530"
"1191453","1435412385","0","0","0","226530"
"1191454","1435410088","0","0","0","226530"
"1191455","11967318378","0","0","0","226531"

2) таблица leads info - общее количество строк - 11 942 000, номеров телефонов без дубликатов - 7 782 000, cpf без дубликатов - 2 567 000

образец данных

Код: 
"FONE","NOME","CPF","ID_CLIENTE"
"1120283170","NAIR NAMIKO KANASHIRO","","0"
"1120314782","ODECI ALVES DOS SANTOS","04468016825","8291763"
"1120282193","SILVIA REGINA DOS SANTOS","01434094847","8188463"
"1120351650","NIVALDO DOS SANTOS","16322925806","8864058"
"1120354792","ANA MARIA DA ROCHA","81158386834","8241665"
"1120265437","RENATA APARECIDA THEODORO FERREIRA","15342233801","10662446"
"1120268763","RENATO VILLALOBOS MARTINS DA SILVA","05757179805","8155542"
"1120352386","GILDASIO JOSE DA SILVA","04193868826","11431259"
"1120311654","LUIZ CARLOS DE OLIVEIRA BERNARDO","01299526802","10594781"
"1120341212","MARINA CABRAL GULLO DE FIGUEIREDO","","0"
"1120331498","ALAIDE APARECIDA DE A D DE OLIVEIRA","08542610873","10657525"
"1120262082","EDMILSON DE JESUS","","0"
"1120312579","DANIELLA FABRICIA SANTOS DE OLIVEIRA","41629282820","8166605"
"1120325927","MANOEL CACIMIRO DE MORAIS","14619946400","8728558"
"1120345204","LUCIANA MEIRA VIEIRA ALVES","78236320120","11118563"
"1120288660","DANILO FRANCISCO DA SILVA","08017344872","10584404"
"1120280138","CRISTIAN APARECIDA ARAUJO ARNAUT","15172425845","8332983"
"1120357028","DEBORA DOS SANTOS BISPO","29779754890","8896786"
"1120350914","MARIA APARECIDA LUZIA","12482082854","10649293"
"1120345204","LUCIANA MEIRA VIEIRA ALVES","78236320120","10968181"
"1120352848","ARTENIZIA DORALICE DE LIMA","","0"
"1120355169","MARIA GORETI LEMOS CARDOSO","16888386864","11417104"
"1120345269","ALESSANDRA GONCALVES ARAUJO","02510339109","11119547"
"1120319358","JULIO ROSSI NETO","","0"
"1120324738","ALAIDE APARECIDA DE A D DE OLIVEIRA","08542610873","8895543"
"1120354298","JARILMA SILVA GONCALVES","","0"
"1120268610","JUAREZ DA SILVA","","0"
"1120265790","MARIA GORETE DE FATIMA CONCEICAO SILVA","05756152814","8262725"
"1120344219","LIGIA MARIA SANCHES BERNARDO","63445026815","11203299"

3) таблица clients - всего строк - 7 939 000 , cpf без дублей 3 314 000 ,

образец данных

Код: 
"ID","CPF","NOME","DATA_NASC","SEXO"
"6804154","40611188899","MARCELO HENRIQUE LOPES","12/7/1995","M"
"6804155","40611188899","MARCELO HENRIQUE LOPES","12/7/1995","M"
"6804156","22033399850","FERNANDA CRISTINA PROENCA DE BRITO","11/9/1979","F"
"6804157","22033399850","FERNANDA CRISTINA PROENCA DE BRITO","11/9/1979","F"
"6804158","33628410827","LEANDRO MALDONADO","25/10/1986","M"
"6804159","33628410827","LEANDRO MALDONADO","25/10/1986","M"
"6804160","11051993806","MARCIA APARECIDA LOPES CAMARGO","7/4/1971","F"
"6804161","11051993806","MARCIA APARECIDA LOPES CAMARGO","7/4/1971","F"
"6804162","46587981828","DANIEL WILLIAM SIQUEIRA DA SILVA","11/9/1997","M"
"6804163","46587981828","DANIEL WILLIAM SIQUEIRA DA SILVA","11/9/1997","M"
"6804164","17735982879","MARLI AUGUSTA SOARES","21/4/1972","F"
"6804165","17735982879","MARLI AUGUSTA SOARES","21/4/1972","F"
"6804166","30626360846","PRISCILA APARECIDA DA SILVA SOARES","29/12/1981","F"
"6804167","30626360846","PRISCILA APARECIDA DA SILVA SOARES","29/12/1981","F"
"6804168","92527795900","LILIANE SIONARA DA SILVA","4/5/1977","F"
"6804169","92527795900","LILIANE SIONARA DA SILVA","4/5/1977","F"
"6804170","40007653883","WESLLEY RICARDO NISHI MORAIS","2/11/1989","M"
"6804171","40007653883","WESLLEY RICARDO NISHI MORAIS","2/11/1989","M"
"6804172","35350045865","LUIZ ANTONIO COSTA DE OLIVEIRA","18/8/1989","M"
"6804173","35350045865","LUIZ ANTONIO COSTA DE OLIVEIRA","18/8/1989","M"
"6804174","29461792816","DIRCEU VILAS BOAS","5/6/1978","M"
"6804175","29461792816","DIRCEU VILAS BOAS","5/6/1978","M"
"6804176","45889795821","MIRIELLEN APARECIDA GONCALVES DA SILVA","7/8/1996","F"
"6804177","45889795821","MIRIELLEN APARECIDA GONCALVES DA SILVA","7/8/1996","F"
"6804178","29551324897","FERNANDA MAZZUCATTO","16/9/1981","F"
"6804179","29551324897","FERNANDA MAZZUCATTO","16/9/1981","F"
"6804180","14168930831","LUCIA APARECIDA DA COSTA ALEXANDRE","15/5/1972","F"
"6804181","14168930831","LUCIA APARECIDA DA COSTA ALEXANDRE","15/5/1972","F"
"6804182","37508958802","SUELEN PIRES DE CAMPOS","22/7/1987","F"
"6804183","37508958802","SUELEN PIRES DE CAMPOS","22/7/1987","F"
"6804184","43388408890","CAMILA MEDEIROS GONCALVES","1/11/1994","F"
"6804185","43388408890","CAMILA MEDEIROS GONCALVES","1/11/1994","F"
"6804186","43680375883","KARINE LETICIA QUEIROZ","4/12/1994","F"
"6804187","43680375883","KARINE LETICIA QUEIROZ","4/12/1994","F"

4) таблица email - всего строк - 2 947 000, email без дублей - 1200 000

пример данных

Код: 
"ID","EMAIL","VALIDADO","ID_CLIENTE"
"3758801","jgarrido@hotmail.com.br","1","11722496"
"3758802","jonildomendes@hotmail.com","1","11722497"
"3758803","wellingtoncjacinto@gmail.com","1","11722498"
"3758804","fabianosantos5367@me.com","1","11722499"
"3758805","fabianolaragomes@gmail.com","1","11722500"
"3758806","deyd999794161@gmail.com","1","11722501"
"3758807","joseclinharesf@gmail.com","1","11722502"
"3758808","icoandrade.2010@hotmail.com","1","11722503"
"3758809","vonbaader@terra.com.br","1","11722504"
"3758810","marquescezar@hotmail.com","1","11722505"
"3758811","weliomarbg@gmail.com","1","11722506"
"3758812","eroni.vosnes@hotmail.com","1","11722507"
"3758813","tarcistudiohair@gmail.com","1","11722508"
"3758814","leandrinhogoncalves123@gmail.com","1","11722509"
"3758815","joseeduardosilva972@gmail.com","1","11722510"
"3758816","domrodydefumados@gmail.com","1","11722511"
"3758817","marisvaldopaulino@gmail.com","1","11722512"
"3758818","pliniohortencio@hotmail.com","1","11722513"
"3758819","kelmanydelfino@outlook.com","1","11722514"
"3758820","diih.alves@hotmail.com","1","11722515"
"3758821","aurelio.contabil@hotmail.com","1","11722516"
"3758822","juninhogourd@gmail.com","1","11722517"
"3758823","edereugenio2@gmail.com","1","11722518"
"3758824","izacarvalho307@gmail.com","1","11722519"
"3758825","mariaangelica2017@outlook.com","1","11722520"
"3758826","taianacaldasof@gmail.com","1","11722521"
"3758827","marcelogomes_matos@hotmail.com","1","11722522"
"3758828","yaia.123@hotmail.com","1","11722523"
"3758829","adrianacostasantosj7@gmail.com","1","11722524"
"3758830","josemateusmottapereira@gmail.com","1","11722525"
"3758831","soniacnet@hotmail.com","1","11722526"
"3758832","alex@athacontabilidade.com.br","1","11722527"

а так же множество других таблиц...
 
admin


Напишите ответ...
Верх