12-14-2023, 04:41 AM
Institute of Chartered Accountants of India - ICAI.org - Breach 2018 [REPOST]
previous post:
http://breachddyfwvcp4kzccos5oxtdbssmfbp...org-Breach
http://breachforums.sb/Thread-Institute-...org-Breach
icai.org Data Breached
The Institute of Chartered Accountants of India is India's largest professional accounting body under the administrative control of Ministry of Corporate Affairs
The data contains ALL Members details with contacts. Approx 300k unique members data along with may other records.
Data was breached somewhere in mid 2018, not breached by me
Full Sql File Dumped
Format: .sql
size: 8.3G
date: 2018
SAMPLE
previous post:
http://breachddyfwvcp4kzccos5oxtdbssmfbp...org-Breach
http://breachforums.sb/Thread-Institute-...org-Breach
icai.org Data Breached
The Institute of Chartered Accountants of India is India's largest professional accounting body under the administrative control of Ministry of Corporate Affairs
The data contains ALL Members details with contacts. Approx 300k unique members data along with may other records.
Data was breached somewhere in mid 2018, not breached by me
Full Sql File Dumped
Format: .sql
size: 8.3G
date: 2018
SAMPLE
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02468','224860','19','05','1987','CA. SATEESH UNNAVA','Flat. 301, D.No. 11-4-646/B2','Trendset Hilltop Appts, , A C Guards','Hyderabad','0031','500004',NULL,'9959640740','sateeshandco@hotmail.com','38','BT0168',NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-28 16:11:40',1,1,'38080','icai/photo/1493276890.jpeg',NULL,NULL,NULL,NULL,'GST',NULL,0);
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02469','073571','20','12','1967','CA. SHASHI RANJAN','Flat No.101, Sai Vatika, Bank Colony, Mahmoorganj, Varanasi-221010','Flat No.101, Sai Vatika, Bank Colony, Mahmoorganj, Varanasi-221010, MAHMOORGANJ','VARANASI','0027','221010',NULL,'9935599251','srca2011@gmail.com','81','BT0157',NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-28 16:19:50',1,1,'81042','icai/photo/1493389444.jpg',NULL,NULL,NULL,NULL,'GST',NULL,0);
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02470','407292','05','07','1971','CA. BIRESHWAR KUMAR','C/O VIKRAM KUMAR & CO.','1ST FLOOR, JAGDISH BHAWAN , EXHIBITION ROAD','PATNA','0004','800001',NULL,'9835470400','bireshwarca@yahoo.co.in','65','BT0138','407292_840832REGOEC02470','65419079012',NULL,NULL,'2017-07-28 16:24:23',NULL,'2017-07-28 16:24:23',1,5,'65023','icai/photo/1496484862.jpg',NULL,1180,NULL,NULL,'GST','IDTC/AT/17/0419',1);
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02471','210965','31','07','1974','CA. ANIL KUMAR YELLANKI','FLAT NO. 303, MARUTHI RESIDENCY, MUKARAMPURA','MUKARAMPURA, KARIMNAGAR','KARIMNAGAR','0031','505001',NULL,'9885518600','ayellanki@gmail.com','49','BT0117',NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-28 16:29:35',1,1,'49026','icai/old_student_photo/OEC02471_photo.jpg',NULL,NULL,NULL,NULL,'GST',NULL,0);
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02472','408793','01','09','1975','CA. SINGH PRAVIND KUMAR','401, A- BLOCK, GAGAN APARTMENT','EXHIBITION ROAD, EXHIBITION ROAD','PATNA','0004','800001',NULL,'9431025500','ca.pravindsingh@gmail.com','65','BT0138','408793_545559REGOEC02472','65419105374',NULL,NULL,'2017-07-28 16:34:12',NULL,'2017-07-28 16:34:12',1,5,'65024','icai/photo/1496659958.JPG',NULL,1180,NULL,NULL,'GST','IDTC/AT/17/0420',1);
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02473','149873','01','04','1990','CA. PATEL VANDITABAHEN ASHOKBHAI','2ND FLOOR LEELA SADAN','OPP LAKDI POOL, DANDIA BAZAR','VADODARA','0008','390001',NULL,'9724939390','cavanditapatel@gmail.com','19','BT0083',NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-28 16:37:50',1,1,'19032','icai/photo/1496219427.jpg',NULL,NULL,NULL,NULL,'GST',NULL,0);
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02474','205064','22','03','1968','CA. SASIKUMAR V P','Annapoorna','APC Road, Malaparamba','Calicut','0013','673009',NULL,'9539998884','sasivp@yahoo.com','22','BT0088',NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-28 16:42:59',1,1,'22018','icai/photo/1497592005.JPG',NULL,NULL,NULL,NULL,'GST',NULL,0);
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02475','303630','26','06','1987','CA. JAIN JATIN','11a, janki path , behind jain temple, ganeshguri','dispur, guwahati','guwahati','0003','781006',NULL,'9864070846','jjain467@gmail.com','35','BT0101',NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-28 16:56:31',1,1,'35064','icai/photo/1493278106.jpg',NULL,NULL,NULL,NULL,'GST',NULL,0);
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02476','511395','10','05','1978','CA. SAJJAN KUMAR','VPO- BIKANER','DISTT. REWARI','REWARI','0009','123401',NULL,'9729878425','casajjankumar@rediffmail.com','70','BT0145',NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-28 17:00:50',1,1,'70033','icai/photo/1493462486.jpg',NULL,NULL,NULL,NULL,'GST',NULL,0);
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02477','071962','16','06','1953','CA. GUPTA RAJENDRA KUMAR','Gupta Rajendra & Co.','Chartered Accountants, Reti Ka Pul','Gorakhpur','0027','273001',NULL,'9415245672','guptarajendra47@rediffmail.com','32','BT0098','071962_883845REGOEC02477',NULL,NULL,NULL,NULL,NULL,'2017-07-28 17:02:01',0,0,'','icai/photo/1496574057.jpg',NULL,1180,NULL,NULL,'GST',NULL,0);
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02478','079621','02','02','1971','CA. LAHOTHY SHRIKANT','33 STC MOHINI GOLF LINKS II','GUFA MANDIR ROAD, LALGHATI','BHOPAL','0014','462032',NULL,'9425011610','shrikantlahoti@hotmail.com','20','BT0085',NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-28 17:03:09',1,1,'20030','icai/photo/1496987971.jpg',NULL,NULL,NULL,NULL,'GST',NULL,0);
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02479','079585','05','03','1965','CA. AGARWAL ANIL KUMAR','190','GIRLS SCHOOL ROAD, JUGSALAI','JAMSHEDPUR','0011','831006',NULL,'9431167096','ar49@rediffmail.com','42','BT0110','079585_144973REGOEC02479','65419191694',NULL,NULL,'2017-07-28 17:04:42',NULL,'2017-07-28 17:04:42',0,4,'','icai/photo/1496384167.JPG',NULL,1180,NULL,NULL,'GST',NULL,0);
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02480','129741','01','02','1962','CA. JAIN PRAMOD KUMAR','7/A3, Visava Park','D P Road, Aundh','Pune','0015','411007',NULL,'9766034562','pramod7jain@gmail.com','67','BT0141',NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-28 17:07:21',1,1,'67063','icai/photo/1494228109.jpg',NULL,NULL,NULL,NULL,'GST',NULL,0);
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02481','207645','21','04','1970','CA. JOSEKUTTY JACOB','2','Jacob and Jacob, Market Road, Padavans Shopping Mall, Second Floor','Pala','0013','686575',NULL,'9447114820','josekuttyfca@gmail.com','29','BT0095',NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-28 17:12:31',1,1,'29043','icai/photo/1495040997.jpg',NULL,NULL,NULL,NULL,'GST',NULL,0);
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02482','228780','16','05','1983','CA. JOSHY THARIAN','CHAKKIATH HOUSE','ELAVOOR PO, ANGAMALY','ERNAKULAM','0013','683572',NULL,'9400333749','joshychakkiath@yahoo.co.in','29','BT0095',NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-28 17:18:45',1,1,'29044','icai/photo/1495038443.jpg',NULL,NULL,NULL,NULL,'GST',NULL,0);
insert into `oldbatch_examform_22022018`(`EXAMCODE`,`MEMBERSHIP_NO`,`DOBDD`,`DOBMM`,`DOBYY`,`NAME`,`ADDRESSLINE1`,`ADDRESSLINE2`,`CITY`,`STATE`,`PIN`,`PHONE`,`MOBILE`,`EMAIL`,`VENUECODE`,`BATCHCODE`,`ORDER_NO`,`TRANSACTIONID`,`GSTIN`,`GSTIN_TR`,`ORDER_DATE`,`CHEQUENO`,`REGDATE`,`STATUS`,`TYPE`,`REGID`,`PHOTO`,`CHEQUEDATE`,`AMOUNT`,`BANK`,`BRANCH`,`Course`,`INVOICE_NO`,`INV_T`) values ('OEC02483','064228','10','07','1975','CA. RATH NIRJHARINI','PLOT NO. 1278/2256/4294','GOVIND PRASAD, BOMIKHAL','BHUBANESWAR','0020','751010',NULL,'9437406161','tejrajpalca@gmail.com','21','BT0087',NULL,NULL,NULL,NULL,NULL,NULL,'2017-07-28 17:19:03',1,1,'21052','icai/photo/1496056647.jpg',NULL,NULL,NULL,NULL,'GST',NULL,0);
