Date of Breach:30 November 2023
Descrition of breach - In November 2023, the State-owned telecom operator Bharat Sanchar Nigam Ltd (BSNL) has allegedly suffered a data breach and exposed over 152k clients. The incident exposed over 232k unique email addresses, names, pincodes, phone numbers, physical addresses and orders info.The company was breached by @perell
Compromised data:Email addresses, Names, Phone numbers, Physical addresses, Purchases. 
Amount of records:232.244 unique emails,152.072 lines (working_lines_tcr.csv), 2.852.069 lines all
Page for checking relevant data - https://thecyberexpress.com/bsnl-data-breach/ and https://thecyberexpress.com/bsnl-data-breach-2/ https://telecom.economictimes.indiatimes.com/news/industry/bsnl-suffers-data-breach-sensitive-info-of-users-up-for-sale-on-dark-web/106197459 (Media confirmed leak)
Thread link - https://breachforums.st/Thread-DATABASE-Bharat-Sanchar-Nigam-Limited-2-9m-bsnl-co-in


SAMPLES:(working_lines_tcr.csv):BROW_ID,SROW_ID,EMAIL_ID,BILL_EMAIL_ID,CLR_SERVICE_ID,SSA,CITY,ADDR_1,ADDR_2,CIRCLE,BB_FLAG,CREATED,DQ_FLAG,REFRESH,UPDATED,CUST_CAT,DISTRICT,HOUSE_NO,PHONE_NO,PIN_CODE,MOBILE_NO,BB_PLAN_NO,BILL_CYCLE,BILL_MEDIA,LL_PLAN_NO,STD_STATUS,USAGE_CODE,BB_PART_NUM,BILLING_SSA,LL_PART_NUM,PCPR_STATUS,RURAL_URBAN,SWITCH_CODE,SWITCH_TYPE,VPN_PLAN_NO,SERVICE_TYPE,SUB_LOCALITY,UNBILLED_AMT,VILLAGE_NAME,BILL_ACCNT_NO,CUSTOMER_NAME,CUSTOMER_TYPE,CUST_ACCNT_NO,EXCHANGE_CODE,FTTH_EXCHANGE,MAIN_LOCALITY,IG_BARRED_DATE,MONTHLY_ANNUAL,OG_BARRED_DATE,SERVICE_STATUS,BB_INSTALL_DATE,BB_UNBILLED_AMT,BILL_ACCNT_TYPE,CONNECTION_CODE,LL_INSTALL_DATE,OUTSTANDING_AMT,VPN_ACTIVE_DATE,SERVICE_CATEGORY,SERVICE_SUB_TYPE,ADDITIONAL_DETAILS,CONCESSIONAL_GROUP,BB_PLAN_ACTIVE_DATE,BILL_ACCNT_SUB_TYPE,LL_PLAN_ACTIVE_DATE,SERVICE_OPER_STATUS,SERVICE_INSTALL_DATE
NULL,1-A7KNXEP,karayilrevy8@gmail.com,karayilrevy8@gmail.com,27520654,THRISSUR,VALAPAD,NULL,NULL,KL,NULL,2019-12-21 17:24:29,0,NULL,NULL,6,THRISSUR,KARAYIL HOUSE,0487-2962729,680567,9656377629,Super Star-1,Monthly,Email and Print Bill on Paper,NULL,LOCAL,Residential,800001,THRISSUR,NULL,NULL,Rural,TRCVLX,NULL,NULL,Bharat Fiber BB,ANAVIZHUNGI,0,EAST ANAVIZHUNGI NADA,9034853788,REVY K B,Normal,4020992127,TRCVLX,TRCVLX,VALAPAD,NULL,NULL,NULL,Active,NULL,NULL,Individual,Permanent,2019-12-21 13:33:56,918,NULL,NONOYT-GEN,Bharat Fiber BB,VALAPAD,NULL,2019-12-21 13:33:56,Others,NULL,Active,2019-12-21 13:33:56
NULL,1-E410LMX,rrajithavr@gmail.com,rrajithavr@gmail.com,34111472,THRISSUR,NULL,NULL,NULL,KL,NULL,2023-02-14 15:42:38,0,NULL,NULL,5,THRISSUR,Kizhakkut House,0480-2991969,680310,7907975258,Fibre Entry,Monthly,Email,NULL,LOCAL,Residential,704869,THRISSUR,NULL,NULL,Rural,TRCTPL,NULL,NULL,Bharat Fiber BB,RAPPAL PALLAM,0,Parappukkara,9041412303,Rejitha V R,Normal,4026309737,TRCTPL,NULL,PARAPPUKKARA,NULL,NULL,2023-07-03 09:22:46,Active,NULL,NULL,Individual,Permanent,2023-02-14 12:00:11,388,NULL,NONOYT-GEN,Bharat Fiber BB,Thrissur,NULL,2023-02-14 12:00:11,Others,NULL,Active,2023-02-14 12:00:11
NULL,1-E5ZOW7D,navaspsaleem@gmail.com,navaspsaleem@gmail.com,34240669,THRISSUR,NULL,NULL,NULL,KL,NULL,2023-03-16 19:10:56,0,NULL,NULL,5,THRISSUR,Palliparambil House,0480-2992199,680702,9946136366,HOME WiFi / GHAR KA WiFi - Rural,Monthly,Email,NULL,LOCAL,Residential,705005,THRISSUR,NULL,NULL,Rural,TRCKTT,NULL,NULL,Bharat Fiber BB,KIZHUPILLIKKARA,0,Kizhuppillikkara,9041466713,Navas ...,Normal,4026347916,TRCKTT,NULL,KIZHUPILLIKKARA,NULL,NULL,NULL,Active,NULL,NULL,Individual,Permanent,2023-03-16 18:54:33,0,NULL,NONOYT-GEN,Bharat Fiber BB,Thrissur,NULL,2023-03-16 18:54:33,Others,NULL,Active,2023-03-16 18:54:33
NULL,1-BK6PYA1,trcpvr@gmail.com,trcpvr@gmail.com,30067080,THRISSUR,THRISSUR,NULL,NULL,KL,NULL,2021-01-27 09:04:47,N,NULL,NULL,5,THRISSUR,276-A PONNENGADATH HOUSE,0487-2962368,680508,9446939869,1000GB CUL - Bharat Fiber CS358,Monthly,Email,NULL,LOCAL,Residential,704501,THRISSUR,NULL,NULL,Rural,TRCPVR,NULL,NULL,Bharat Fiber BB,-,0,THIRUNELLUR,9029921349,K.P.MOHAMED,Normal,4016070508,TRCPVR,NULL,-,NULL,NULL,NULL,Active,NULL,NULL,Individual,Permanent,2021-01-23 09:39:05,-1,NULL,NONOYT-GEN,Bharat Fiber BB,POOVATHUR,NULL,2022-11-17 15:02:23,Others,NULL,Active,2021-01-23 09:39:05
NULL,1-CMK5UCL,samadsamad008118@gmail.com,samadsamad008118@gmail.com,30285944,THRISSUR,VLX,NULL,NULL,KL,NULL,2021-08-14 00:21:43,0,NULL,NULL,5,THRISSUR,"XIX/ S/O LATE HYDERALI,",0487-2962118,680567,9497554282,Fibre 449 CS 378,Monthly,Email,NULL,LOCAL,Residential,704988,THRISSUR,NULL,NULL,Rural,TRCVLX,NULL,NULL,Bharat Fiber BB,ARAYAMPARAMPIL TEMPLE,0,"PUTHIAVEETTIL, P.VALAPPAD BEACH 680567",9039940419,Raphijan P H,Normal,4021750872,TRCVLX,NULL,VALAPAD,NULL,NULL,NULL,Active,NULL,NULL,Individual,Permanent,2021-08-13 19:15:33,0,NULL,NONOYT-GEN,Bharat Fiber BB,VLX,NULL,2022-11-01 00:00:00,Others,NULL,Active,2021-08-13 19:15:33
NULL,1-BN2Q3OX,rajanemgi@gmail.com,rajanemji@gmail.com,30371206,THRISSUR,THRISSUR,NULL,NULL,KL,NULL,2021-03-06 18:35:12,0,NULL,NULL,5,THRISSUR,702 MANJIPARAMBIL,0487-2960685,680614,8111855662,Fibre 449 CS 378,Monthly,Email,NULL,LOCAL,Residential,704988,THRISSUR,NULL,NULL,Rural,TRCVPY,NULL,NULL,Bharat Fiber BB,-,0,GANASAMANGALAM EAST VATANAPPILLT,9029747903,MANJIPARAMBIL GOPALAN RAJAN,Normal,4015897062,TRCVPY,NULL,-,NULL,NULL,2021-04-28 02:23:06,Active,NULL,NULL,Individual,Permanent,2021-03-06 11:54:34,-1,NULL,NONOYT-GEN,Bharat Fiber BB,NULL,NULL,2022-11-01 00:00:00,Others,NULL,Active,2021-03-06 11:54:34
NULL,1-CRNP1E7,musthafamadeena1@gmail.com,musthafamadeena1@gmail.com,31737493,THRISSUR,MUNDATHICODE.P.O,NULL,NULL,KL,NULL,2021-09-26 00:23:05,0,NULL,NULL,5,THRISSUR,IV/628 A,04885-287485,680601,9446235086,Fibre 449 CS 378,Monthly,Email,NULL,STD,Residential,704988,THRISSUR,NULL,NULL,Rural,TRCVLC,NULL,NULL,Bharat Fiber Voice,ARYAMPADAM,0,MADEENA PADIKKAPARAMBIL,9040509247,P M MUSTHAFA,Normal,4015876270,TRCVLC,NULL,VELUR,NULL,NULL,NULL,Active,NULL,NULL,Individual,Permanent,2021-09-25 14:00:29,-1,NULL,NULL,Bharat Fiber Voice,ARYAMPADAM,NULL,2022-11-01 00:00:00,Others,NULL,Active,2021-09-25 14:00:29
and(completed_orders.csv):Ssa,Circle,index,District,Channel,Exchange,House No,Order No,Phone No,Pin Code,Order Type,Rural Urban,Order Status,Service Type,Village Name,Bill Accnt No,Cust Accnt No,Customer Name,Order Sub Type,Bill Accnt Type,Franchisee Code,Order Comp Date,Service Sub Type,Additional Details,Order Created Date,Bill Accnt Sub Type,Franchisee Category
THRISSUR,KL,NULL,THRISSUR,Web,TRCKNM,1/866F,8005770736,0487-2972000,680503,Disconnect,Urban,Complete,Bharat Fiber BB,"VAISHNAVAM,FIRST FLOOR",9037420725,4023343147,SIBY.T.B,Disconnect Due to NP,Business,NULL,2021-08-02,Bharat Fiber BB,VADAKKANCHERY ROAD,2020-04-18,Others,NULL
THRISSUR,KL,NULL,THRISSUR,Web,TRCKNM,"1/211 Q,R,THARAKAN ARCADE",8005770784,0487-2972877,680503,Disconnect,Rural,Complete,Bharat Fiber Voice,ETEC EXTENDED TECHNOLOGIES,9038274046,4024073818,ANILKUMAR,Disconnect Due to NP,Business,NULL,2021-08-02,Bharat Fiber Voice,GURUVAYUR ROAD,2020-04-18,Others,NULL
THRISSUR,KL,NULL,THRISSUR,Web,TRCKNM,"1/211 Q,R,THARAKAN ARCADE",8005772863,0487-2972877,680503,Disconnect,Rural,Complete,Bharat Fiber BB,ETEC EXTENDED TECHNOLOGIES,9038274046,4024073818,ANILKUMAR,Disconnect Due to NP,Business,NULL,2021-08-02,Bharat Fiber BB,GURUVAYUR ROAD,2020-04-18,Others,NULL
THRISSUR,KL,NULL,THRISSUR,Web,TRCKNM,1/866F,8005770286,0487-2972000,680503,Disconnect,Urban,Complete,Bharat Fiber Voice,"VAISHNAVAM,FIRST FLOOR",9037420725,4023343147,SIBY.T.B,Disconnect Due to NP,Business,NULL,2021-08-03,Bharat Fiber Voice,VADAKKANCHERY ROAD,2020-04-18,Others,NULL
THRISSUR,KL,NULL,THRISSUR,Web,TRCKNM,XI/121,8005479915,0487-2977979,680503,Disconnect,Urban,Complete,Bharat Fiber BB,NEAR LOTUS PALACE,9038704259,4024303834,VIMAL WILSON,Disconnect Due to NP,Individual,NULL,2021-08-02,Bharat Fiber BB,VADAKKANCHERY ROAD,2020-01-08,Others,NULL
THRISSUR,KL,NULL,THRISSUR,Web,TRCPKM,"139, AISWARYA GARDENS",8005303771,0487-2973344,680013,Disconnect,Rural,Complete,Bharat Fiber BB,"VILLA NO.14, KUTTUR.",9037221537,4023162743,CHITRA CHANDRAN,Disconnect Due to NP,Individual,NULL,2021-08-07,Bharat Fiber BB,-,2019-12-13,Others,NULL
THRISSUR,KL,NULL,THRISSUR,Walk-In,TRCMNV,XII/109 NEA R C CHURCH,122722512067,0487-2959822,680581,New,Rural,Complete,Bharat Fiber Voice,POOMALA P.O.,9037989371,4023845851,SPINNER PLASTIC INDUSTRIES LIMITED .,Provision,Business,NULL,2021-07-04,Bharat Fiber Voice,NULL,2020-03-20,Others,NULL
THRISSUR,KL,NULL,THRISSUR,Walk-In,TRCCBU,THUSHARAM,123299811519,0487-2953667,680018,New,Urban,Complete,Bharat Fiber Voice,ASHIRYA GARDEN ROAD P 0 PERINGAVU,9029910466,4016059625,JAYASANKAR K,Provision,Individual,SKLTRC_NEXTGENCBU,2021-07-28,Bharat Fiber Voice,TRICHUR,2020-08-07,Others,D
and(enk_working_01022022.csv):BB_USER_ID,ONT_SERIAL_NO_MAC_ID,PHONE,OLT_IP,EMS_PORT,OLT_NAME,OLT_TYPE,PHONE_NO,OLT_OWNER,ONT_VENDOR,PRIVATE_IP,DOMAIN_NAME,OLT_CARD_NO,OLT_PORT_NO,BB_STATIC_IP,SERVICE_TYPE,SPLITTER_TYPE,UPS_SERIAL_NO,SPLITTER_NUMBER,WORK_FRANCHISEE,SPLITTER2_DETAILS,SPLITTER3_DETAILS,SPLITTER4_DETAILS,SPLITTER_LOCATION,ONT_ACQUISITION_TYPE,MAINTENANCE_FRANCHISEE
486429806055_sid,00000000GNXS01490BA8,04864-298041,10.211.232.33,1,ENKADM,EPON,04864-298041-BHARAT FIBER_BB,SKLENK_IVB_IDKVSN_BBNL,GENEXIS,NULL,ftth.bsnl.in,1,1,NULL,Bharat Fiber BB,1x8,GNXS01490BA8,1,SKLENK_IVB_IDKVSN_BBNL,NULL,NULL,NULL,Selliampara,OWNED,SKLENK_IVB_IDKVSN_BBNL
NULL,00000000GNXS01490BA8,04864-298041,10.211.232.33,1,ENKADM,EPON,04864-298041-BHARAT FIBER_VOICE,SKLENK_IVB_IDKVSN_BBNL,GENEXIS,NULL,NULL,1,1,NULL,Bharat Fiber Voice,1x8,GNXS01490BA8,1,SKLENK_IVB_IDKVSN_BBNL,NULL,NULL,NULL,Selliampara,OWNED,SKLENK_IVB_IDKVSN_BBNL
480287965013_sid,00000000080808080808,0480-2879646,10.211.183.43,1,TRCKTT,GPON,0480-2879646-BHARAT FIBER_BB,SKLTRC_SKYLINKKTT_BBNL,NETLINK,NULL,ftth.bsnl.in,1,1,NULL,Bharat Fiber BB,1x8,080808080808,1,SKLTRC_SKYLINKKTT_BBNL,NULL,NULL,NULL,KTT,OWNED,SKLTRC_SKYLINKKTT_BBNL
NULL,00000000080808080808,0480-2879646,10.211.183.43,1,TRCKTT,GPON,0480-2879646-BHARAT FIBER_VOICE,SKLTRC_SKYLINKKTT_BBNL,NETLINK,NULL,NULL,1,1,NULL,Bharat Fiber Voice,1x8,080808080808,1,SKLTRC_SKYLINKKTT_BBNL,NULL,NULL,NULL,KTT,OWNED,SKLTRC_SKYLINKKTT_BBNL
NULL,00000000000123456789,0484-2327773,10.215.49.96,1,ENKEDC,GPON,0484-2327773-BHARAT FIBER_VOICE,ENK_ACTIONCVSN_EDAKOCHI,NETLINK,NULL,NULL,1,1,NULL,Bharat Fiber Voice,2x4,0123456789,2,ENK_ACTIONCVSN_EDAKOCHI,NULL,NULL,NULL,CP,OWNED,ENK_ACTIONCVSN_EDAKOCHI
th2327773_sid,00000000000123456789,0484-2327773,10.215.49.96,1,ENKEDC,GPON,0484-2327773-BHARAT FIBER_BB,ENK_ACTIONCVSN_EDAKOCHI,NETLINK,NULL,ftth.bsnl.in,1,1,NULL,Bharat Fiber BB,2x4,0123456789,2,ENK_ACTIONCVSN_EDAKOCHI,NULL,NULL,NULL,CP,OWNED,ENK_ACTIONCVSN_EDAKOCHI
kseb2248899_sid,00000000A8E207665F33,0484-2248899,10.215.49.40,1,ENKKBY,GPON,0484-2248899-BHARAT FIBER_BB,SKLENK_AXXAINDIA,SYROTECH,NULL,ftth.bsnl.in,1,1,NULL,Bharat Fiber BB,Others,A8E207665F33,na,SKLENK_AXXAINDIA,NULL,kby,kby,kby,Bundled WIFI ONT by Franchisee,SKLENK_AXXAINDIA
NULL,00000000A8E207665F33,0484-2248899,10.215.49.40,1,ENKKBY,GPON,0484-2248899-BHARAT FIBER_VOICE,SKLENK_AXXAINDIA,SYROTECH,NULL,NULL,1,1,NULL,Bharat Fiber Voice,Others,A8E207665F33,na,SKLENK_AXXAINDIA,NULL,kby,kby,kby,Bundled WIFI ONT by Franchisee,SKLENK_AXXAINDIA
480273076528_sid,000GP-ON-00-DF-05-8D,0480-2730739,10.211.183.19,1,TRCKTY,GPON,0480-2730739-BHARAT FIBER_BB,SKLTRC_ANIOMAXCKD_BBNL,NETLINK,NULL,ftth.bsnl.in,1,1,NULL,Bharat Fiber BB,1x8,GP-ON-00-DF-05-8D,2,SKLTRC_ANIOMAXCKD_BBNL,NULL,NULL,NULL,Meloor,OWNED,SKLTRC_ANIOMAXCKD_BBNL
NULL,000GP-ON-00-DF-05-8D,0480-2730739,10.211.183.19,1,TRCKTY,GPON,0480-2730739-BHARAT FIBER_VOICE,SKLTRC_ANIOMAXCKD_BBNL,NETLINK,NULL,NULL,1,1,NULL,Bharat Fiber Voice,1x8,GP-ON-00-DF-05-8D,2,SKLTRC_ANIOMAXCKD_BBNL,NULL,NULL,NULL,MELOOR,OWNED,SKLTRC_ANIOMAXCKD_BBNL
NULL,NULL,04868-299766,10.215.232.101,1,ENKUBL,EPON,04868-299766-BHARAT FIBER_VOICE,SKLENK_ANJENAYACNET,NULL,NULL,NULL,1,1,NULL,Bharat Fiber Voice,1x16,abcd12345678,1,SKLENK_ANJENAYACNET,NULL,NULL,NULL,1,NULL,SKLENK_ANJENAYACNET
