16-03-25, 04:53 PM
10K sample file from the Turknet 2.8m database leak
this is only the 10k sample from the new Turknet leak
Id,ContactId,MUSTERI_ID,DONDURMA_ID,PlSegmentId,DEVREADRESID,ABONE_ADRES_TESIS_ADRESID,ABONE_ADRES_YERLESIM_ADRESID,AD,ENLEM,SOYAD,UNVAN,BOYLAM,HAT_NO,UPLOAD,DOWNLOAD,IsActive,Username,VERGI_NO,CreatedBy,HIZMET_NO,STATIK_IP,TC_KIMLIK,UpdatedBy,HIZMETTIPI,ABONE_BITIS,ABONE_UYRUK,CreatedDate,UpdatedDate,ABONE_TARIFE,MUSTERI_TURU,ABONE_ANA_ADI,KULLANICI_ADI,ABONE_BABA_ADI,ABONE_BASLANGIC,HIZMET_NUMARASI,ISS_POP_BILGISI,ABONE_DOGUM_YERI,MUSTERI_ALT_TURU,MUSTERI_NUMARASI,SEGMENT_ACIKLAMA,TC_TELEKOM_DURUM,ABONE_KIMLIK_TIPI,ABONE_PASAPORT_NO,ABONE_DOGUM_TARIHI,HIZMET_DURUM_DETAY,AKTIVASYON_BAYI_ADI,ABONE_ADRES_TESIS_IL,ABONE_KIMLIK_SERI_NO,AKTIVASYON_KULLANICI,MUSTERI_HAREKET_KODU,ABONE_ADRES_TESIS_BBK,ABONE_MERSIS_NUMARASI,ABONE_ADRES_TESIS_ILCE,AKTIVASYON_BAYI_ADRESI,MUSTERI_HAREKET_ZAMANI,ABONE_ADRES_TESIS_CADDE,ABONE_ADRES_YERLESIM_IL,ABONE_ADRES_YERLESIM_BBK,MUSTERI_HAREKET_ACIKLAMA,ABONE_ADRES_TESIS_MAHALLE,ABONE_ADRES_YERLESIM_ILCE,ABONE_ADRES_YERLESIM_CADDE,ABONE_ADRES_TESIS_ADRESTIPI,ABONE_ADRES_TESIS_ADRES_KODU,ABONE_ADRES_TESIS_IC_KAPI_NO,ABONE_ADRES_TESIS_POSTA_KODU,ABONE_ADRES_YERLESIM_MAHALLE,ABONE_ADRES_TESIS_DIS_KAPI_NO,ABONE_ADRES_YERLESIM_ADRESTIPI,ABONE_ADRES_YERLESIM_ADRES_KODU,ABONE_ADRES_YERLESIM_IC_KAPI_NO,ABONE_ADRES_YERLESIM_POSTA_KODU,ABONE_ADRES_YERLESIM_DIS_KAPI_NO
2825300,4492493,8860213907,NULL,4,10162960,10162960,10162959,OLCAY,40.216037,İÇÖZ,Olcay İçöz,28.359,8860213907,15360,51200,NULL,4378989data,<blank>,NULL,8866346,NULL,21646430792,NULL,XDSL,NULL,NULL,Mar 9 2025 12:03AM,NULL,(Bireysel)(Yalın) 50 Mbps e kadar,B,FATMA,4378989data@turk.net,FİKRET,Feb 14 2025 6:08PM,8866346,329-16KARACABEY,GÖNEN,B,4378989,Bireysel,A,TCKK,NULL,Dec 21 1991 12:00AM,A,NULL,BURSA,A48G57992,21646430792,1,71684587,<blank>,KARACABEY,NULL,Feb 14 2025 6:08PM,ŞÜKRÜ KESKİN SOKAGI,BURSA,71684587,YENI_ABONELIK_KAYDI,GAZİ,KARACABEY,ŞÜKRÜ KESKİN SOKAGI,L,5330936575,Ic Kapi(Daire) No :2,16700,GAZİ,NO :152_TEMUR APT,F,5330936575,Ic Kapi(Daire) No :2,16700,NO :152_TEMUR APT
2825299,4492492,1782076470,NULL,4,10162955,10162955,10162954,ÜMMÜGÜLSÜM,41.040967,ELMAS,Ümmügülsüm Elmas,28.671397,1782076470,20480,102400,NULL,4378988data,<blank>,NULL,8866343,NULL,30379862008,NULL,XDSL,NULL,NULL,Mar 9 2025 12:03AM,NULL,(Bireysel)(Yalın)(TT Fiber) 100 Mbps,B,MERAL,4378988data@turk.net,ERDOĞAN,Feb 12 2025 8:15PM,8866343,<blank>,FATİH,B,4378988,Bireysel,A,TCKK,NULL,Sep 16 2005 12:00AM,A,NULL,İSTANBUL,A13U75215,30379862008,1,49689270,<blank>,ESENYURT,NULL,Feb 12 2025 8:15PM,1396. SOKAGI,İSTANBUL,49689270,YENI_ABONELIK_KAYDI,ÇINAR,ESENYURT,1396. SOKAGI,L,2470350725,Ic Kapi(Daire) No :7,34517,ÇINAR,NO :16_,F,2470350725,Ic Kapi(Daire) No :7,34517,NO :16_
2825298,4492455,1797761968,NULL,4,10162871,10162871,10162870,BETÜL,40.017649,KILINÇ,BETÜL KILINÇ,32.53684,1797761968,20480,102400,NULL,4378951data,<blank>,NULL,8866260,NULL,12628218842,NULL,XDSL,NULL,NULL,Mar 9 2025 12:03AM,NULL,(Bireysel)(Yalın)(TT Fiber) 100 Mbps,B,FADİK,4378951data@turk.net,HAYDAR,Feb 13 2025 7:13PM,8866260,<blank>,YENİMAHALLE,B,4378951,Bireysel,A,TCKK,NULL,Jul 4 1991 12:00AM,A,NULL,ANKARA,A44G43477,12628218842,11,99223578,<blank>,SİNCAN,NULL,Feb 13 2025 7:13PM,751 SOKAGI,ANKARA,99223578,MUSTERI_BILGI_DEGISIKLIGI,29 EKİM,SİNCAN,751 SOKAGI,L,1968185387,Ic Kapi(Daire) No :2,6946,29 EKİM,NO :4_,F,1968185387,Ic Kapi(Daire) No :2,6946,NO :4_
2825297,4492426,8866200,NULL,4,NULL,10162813,10162812,ARSLAN,NULL,İNEL,ARSLAN İNEL,NULL,8866200,1024000,1024000,NULL,4378923data,<blank>,NULL,8866200,NULL,14362489366,NULL,XDSL,NULL,NULL,Mar 9 2025 12:03AM,NULL,(Bireysel)(TN Fiber) 1000 Mbps,B,KERİME,4378923data@turk.net,İSMAİL,Feb 14 2025 6:08PM,8866200,<blank>,MERZİFON,B,4378923,Bireysel,A,TCKK,NULL,Oct 21 1977 12:00AM,A,NULL,İZMİR,A16Z18472,14362489366,1,20242737,<blank>,BORNOVA,NULL,Feb 14 2025 6:08PM,4172 SOKAGI,İZMİR,20242737,YENI_ABONELIK_KAYDI,YEŞİLOVA,BORNOVA,4172 SOKAGI,L,2298720331,Ic Kapi(Daire) No :2,35080,YEŞİLOVA,NO :126_,F,2298720331,Ic Kapi(Daire) No :2,35080,NO :126_
this is only the 10k sample from the new Turknet leak
Id,ContactId,MUSTERI_ID,DONDURMA_ID,PlSegmentId,DEVREADRESID,ABONE_ADRES_TESIS_ADRESID,ABONE_ADRES_YERLESIM_ADRESID,AD,ENLEM,SOYAD,UNVAN,BOYLAM,HAT_NO,UPLOAD,DOWNLOAD,IsActive,Username,VERGI_NO,CreatedBy,HIZMET_NO,STATIK_IP,TC_KIMLIK,UpdatedBy,HIZMETTIPI,ABONE_BITIS,ABONE_UYRUK,CreatedDate,UpdatedDate,ABONE_TARIFE,MUSTERI_TURU,ABONE_ANA_ADI,KULLANICI_ADI,ABONE_BABA_ADI,ABONE_BASLANGIC,HIZMET_NUMARASI,ISS_POP_BILGISI,ABONE_DOGUM_YERI,MUSTERI_ALT_TURU,MUSTERI_NUMARASI,SEGMENT_ACIKLAMA,TC_TELEKOM_DURUM,ABONE_KIMLIK_TIPI,ABONE_PASAPORT_NO,ABONE_DOGUM_TARIHI,HIZMET_DURUM_DETAY,AKTIVASYON_BAYI_ADI,ABONE_ADRES_TESIS_IL,ABONE_KIMLIK_SERI_NO,AKTIVASYON_KULLANICI,MUSTERI_HAREKET_KODU,ABONE_ADRES_TESIS_BBK,ABONE_MERSIS_NUMARASI,ABONE_ADRES_TESIS_ILCE,AKTIVASYON_BAYI_ADRESI,MUSTERI_HAREKET_ZAMANI,ABONE_ADRES_TESIS_CADDE,ABONE_ADRES_YERLESIM_IL,ABONE_ADRES_YERLESIM_BBK,MUSTERI_HAREKET_ACIKLAMA,ABONE_ADRES_TESIS_MAHALLE,ABONE_ADRES_YERLESIM_ILCE,ABONE_ADRES_YERLESIM_CADDE,ABONE_ADRES_TESIS_ADRESTIPI,ABONE_ADRES_TESIS_ADRES_KODU,ABONE_ADRES_TESIS_IC_KAPI_NO,ABONE_ADRES_TESIS_POSTA_KODU,ABONE_ADRES_YERLESIM_MAHALLE,ABONE_ADRES_TESIS_DIS_KAPI_NO,ABONE_ADRES_YERLESIM_ADRESTIPI,ABONE_ADRES_YERLESIM_ADRES_KODU,ABONE_ADRES_YERLESIM_IC_KAPI_NO,ABONE_ADRES_YERLESIM_POSTA_KODU,ABONE_ADRES_YERLESIM_DIS_KAPI_NO
2825300,4492493,8860213907,NULL,4,10162960,10162960,10162959,OLCAY,40.216037,İÇÖZ,Olcay İçöz,28.359,8860213907,15360,51200,NULL,4378989data,<blank>,NULL,8866346,NULL,21646430792,NULL,XDSL,NULL,NULL,Mar 9 2025 12:03AM,NULL,(Bireysel)(Yalın) 50 Mbps e kadar,B,FATMA,4378989data@turk.net,FİKRET,Feb 14 2025 6:08PM,8866346,329-16KARACABEY,GÖNEN,B,4378989,Bireysel,A,TCKK,NULL,Dec 21 1991 12:00AM,A,NULL,BURSA,A48G57992,21646430792,1,71684587,<blank>,KARACABEY,NULL,Feb 14 2025 6:08PM,ŞÜKRÜ KESKİN SOKAGI,BURSA,71684587,YENI_ABONELIK_KAYDI,GAZİ,KARACABEY,ŞÜKRÜ KESKİN SOKAGI,L,5330936575,Ic Kapi(Daire) No :2,16700,GAZİ,NO :152_TEMUR APT,F,5330936575,Ic Kapi(Daire) No :2,16700,NO :152_TEMUR APT
2825299,4492492,1782076470,NULL,4,10162955,10162955,10162954,ÜMMÜGÜLSÜM,41.040967,ELMAS,Ümmügülsüm Elmas,28.671397,1782076470,20480,102400,NULL,4378988data,<blank>,NULL,8866343,NULL,30379862008,NULL,XDSL,NULL,NULL,Mar 9 2025 12:03AM,NULL,(Bireysel)(Yalın)(TT Fiber) 100 Mbps,B,MERAL,4378988data@turk.net,ERDOĞAN,Feb 12 2025 8:15PM,8866343,<blank>,FATİH,B,4378988,Bireysel,A,TCKK,NULL,Sep 16 2005 12:00AM,A,NULL,İSTANBUL,A13U75215,30379862008,1,49689270,<blank>,ESENYURT,NULL,Feb 12 2025 8:15PM,1396. SOKAGI,İSTANBUL,49689270,YENI_ABONELIK_KAYDI,ÇINAR,ESENYURT,1396. SOKAGI,L,2470350725,Ic Kapi(Daire) No :7,34517,ÇINAR,NO :16_,F,2470350725,Ic Kapi(Daire) No :7,34517,NO :16_
2825298,4492455,1797761968,NULL,4,10162871,10162871,10162870,BETÜL,40.017649,KILINÇ,BETÜL KILINÇ,32.53684,1797761968,20480,102400,NULL,4378951data,<blank>,NULL,8866260,NULL,12628218842,NULL,XDSL,NULL,NULL,Mar 9 2025 12:03AM,NULL,(Bireysel)(Yalın)(TT Fiber) 100 Mbps,B,FADİK,4378951data@turk.net,HAYDAR,Feb 13 2025 7:13PM,8866260,<blank>,YENİMAHALLE,B,4378951,Bireysel,A,TCKK,NULL,Jul 4 1991 12:00AM,A,NULL,ANKARA,A44G43477,12628218842,11,99223578,<blank>,SİNCAN,NULL,Feb 13 2025 7:13PM,751 SOKAGI,ANKARA,99223578,MUSTERI_BILGI_DEGISIKLIGI,29 EKİM,SİNCAN,751 SOKAGI,L,1968185387,Ic Kapi(Daire) No :2,6946,29 EKİM,NO :4_,F,1968185387,Ic Kapi(Daire) No :2,6946,NO :4_
2825297,4492426,8866200,NULL,4,NULL,10162813,10162812,ARSLAN,NULL,İNEL,ARSLAN İNEL,NULL,8866200,1024000,1024000,NULL,4378923data,<blank>,NULL,8866200,NULL,14362489366,NULL,XDSL,NULL,NULL,Mar 9 2025 12:03AM,NULL,(Bireysel)(TN Fiber) 1000 Mbps,B,KERİME,4378923data@turk.net,İSMAİL,Feb 14 2025 6:08PM,8866200,<blank>,MERZİFON,B,4378923,Bireysel,A,TCKK,NULL,Oct 21 1977 12:00AM,A,NULL,İZMİR,A16Z18472,14362489366,1,20242737,<blank>,BORNOVA,NULL,Feb 14 2025 6:08PM,4172 SOKAGI,İZMİR,20242737,YENI_ABONELIK_KAYDI,YEŞİLOVA,BORNOVA,4172 SOKAGI,L,2298720331,Ic Kapi(Daire) No :2,35080,YEŞİLOVA,NO :126_,F,2298720331,Ic Kapi(Daire) No :2,35080,NO :126_
