BEGIN TRANSACTION;
CREATE TABLE actors (
    id              INTEGER PRIMARY KEY,
    full_name       TEXT NOT NULL,
    role_type       TEXT NOT NULL CHECK (role_type IN
                      ('exam_body_official','government_official','printing_press_staff',
                       'coaching_operator','solver','middleman','candidate','police_official',
                       'politician','other')),
    position_at_time TEXT,
    employer_at_time TEXT,
    current_known_position TEXT,
    current_position_as_of TEXT,
    naming_document_source_id INTEGER NOT NULL REFERENCES sources(id),
    created_at      TEXT NOT NULL DEFAULT (datetime('now'))
);
INSERT INTO "actors" VALUES(1,'Kamal Kishore','candidate','Candidate, MP Police Constable Recruitment Test 2013',NULL,NULL,NULL,80,'2026-06-11 05:20:35');
INSERT INTO "actors" VALUES(2,'Amar Singh','candidate','Candidate, MP Police Constable Recruitment Test 2013',NULL,NULL,NULL,80,'2026-06-11 05:20:35');
INSERT INTO "actors" VALUES(3,'Nagendra Singh','candidate','Candidate, MP Police Constable Recruitment Test 2013',NULL,NULL,NULL,80,'2026-06-11 05:20:35');
INSERT INTO "actors" VALUES(4,'Suresh Singh','candidate','Candidate, MP Police Constable Recruitment Test 2013',NULL,NULL,NULL,80,'2026-06-11 05:20:35');
INSERT INTO "actors" VALUES(5,'Ravi Kumar Rajput','solver','Impersonator (wrote the test for a candidate)',NULL,NULL,NULL,80,'2026-06-11 05:20:35');
CREATE TABLE claim_sources (
    id              INTEGER PRIMARY KEY,
    entity_table    TEXT NOT NULL CHECK (entity_table IN
                      ('incidents','legal_actions','actors','incident_actors','re_exams')),
    entity_id       INTEGER NOT NULL,
    source_id       INTEGER NOT NULL REFERENCES sources(id),
    claim_text      TEXT NOT NULL,
    UNIQUE (entity_table, entity_id, source_id, claim_text)
);
CREATE TABLE data_quality (
    incident_id     INTEGER PRIMARY KEY REFERENCES incidents(id),
    confidence      TEXT NOT NULL CHECK (confidence IN ('A','B','C')),
    verification_status TEXT NOT NULL CHECK (verification_status IN
                      ('draft','editor_verified','reviewer_approved','disputed','correction_issued')),
    last_reviewed   TEXT NOT NULL,
    last_docket_movement TEXT,
    review_notes    TEXT,
    open_disputes   INTEGER NOT NULL DEFAULT 0
);
INSERT INTO "data_quality" VALUES(1,'B','reviewer_approved','2026-06-11','2015-06-19',NULL,0);
INSERT INTO "data_quality" VALUES(2,'C','editor_verified','2026-06-11','2024-03-27',NULL,0);
INSERT INTO "data_quality" VALUES(3,'C','editor_verified','2026-06-11','2023-03-14',NULL,0);
INSERT INTO "data_quality" VALUES(4,'C','editor_verified','2026-06-11','2020-10-09',NULL,0);
INSERT INTO "data_quality" VALUES(5,'C','editor_verified','2026-06-11','2025-06-19',NULL,0);
INSERT INTO "data_quality" VALUES(6,'C','editor_verified','2026-06-11','2022-05-11',NULL,0);
INSERT INTO "data_quality" VALUES(7,'C','editor_verified','2026-06-11','2024-12-16',NULL,0);
INSERT INTO "data_quality" VALUES(8,'A','reviewer_approved','2026-06-11','2024-03-20',NULL,0);
INSERT INTO "data_quality" VALUES(9,'C','editor_verified','2026-06-11','2023-01-05',NULL,0);
INSERT INTO "data_quality" VALUES(10,'C','editor_verified','2026-06-11','2020-10-06',NULL,0);
INSERT INTO "data_quality" VALUES(11,'C','editor_verified','2026-06-11','2018-04-01',NULL,0);
INSERT INTO "data_quality" VALUES(12,'C','editor_verified','2026-06-11','2026-01-02',NULL,0);
INSERT INTO "data_quality" VALUES(13,'C','editor_verified','2026-06-11','2023-01-29',NULL,0);
INSERT INTO "data_quality" VALUES(14,'C','editor_verified','2026-06-11','2021-12-21',NULL,0);
INSERT INTO "data_quality" VALUES(15,'C','editor_verified','2026-06-11','2019-12-16',NULL,0);
INSERT INTO "data_quality" VALUES(16,'C','editor_verified','2026-06-11','2018-12-09',NULL,0);
INSERT INTO "data_quality" VALUES(17,'C','editor_verified','2026-06-11','2021-01-17',NULL,0);
INSERT INTO "data_quality" VALUES(18,'C','editor_verified','2026-06-11','2023-02-21',NULL,0);
INSERT INTO "data_quality" VALUES(19,'C','editor_verified','2026-06-11','2021-08-09',NULL,0);
INSERT INTO "data_quality" VALUES(20,'C','editor_verified','2026-06-11','2021-09-03',NULL,0);
INSERT INTO "data_quality" VALUES(21,'C','editor_verified','2026-06-11','2024-07-11',NULL,0);
INSERT INTO "data_quality" VALUES(22,'C','editor_verified','2026-06-11','2024-01-28',NULL,0);
INSERT INTO "data_quality" VALUES(23,'C','editor_verified','2026-06-11','2023-09-25',NULL,0);
INSERT INTO "data_quality" VALUES(24,'C','editor_verified','2026-06-11','2023-04-05',NULL,0);
INSERT INTO "data_quality" VALUES(25,'C','editor_verified','2026-06-11','2022-03-03',NULL,0);
INSERT INTO "data_quality" VALUES(26,'C','editor_verified','2026-06-11','2021-09-13',NULL,0);
INSERT INTO "data_quality" VALUES(27,'A','reviewer_approved','2026-06-11','2025-04-25',NULL,0);
INSERT INTO "data_quality" VALUES(28,'C','editor_verified','2026-06-11','2026-05-15',NULL,0);
INSERT INTO "data_quality" VALUES(29,'C','editor_verified','2026-06-11','2023-07-27',NULL,0);
INSERT INTO "data_quality" VALUES(30,'C','editor_verified','2026-06-11','2017-05-17',NULL,0);
INSERT INTO "data_quality" VALUES(31,'C','editor_verified','2026-06-11','2022-05-17',NULL,0);
INSERT INTO "data_quality" VALUES(32,'B','reviewer_approved','2026-06-11','2026-04-04',NULL,0);
INSERT INTO "data_quality" VALUES(33,'C','editor_verified','2026-06-11','2022-07-07',NULL,0);
INSERT INTO "data_quality" VALUES(34,'C','editor_verified','2026-06-11','2022-12-24',NULL,0);
INSERT INTO "data_quality" VALUES(35,'C','editor_verified','2026-06-11','2024-02-29',NULL,0);
INSERT INTO "data_quality" VALUES(36,'C','editor_verified','2026-06-11','2026-01-29',NULL,0);
INSERT INTO "data_quality" VALUES(37,'C','editor_verified','2026-06-11','2019-06-04',NULL,0);
INSERT INTO "data_quality" VALUES(38,'C','editor_verified','2026-06-11','2012-08-13',NULL,0);
INSERT INTO "data_quality" VALUES(39,'C','editor_verified','2026-06-11','2023-04-05',NULL,0);
INSERT INTO "data_quality" VALUES(40,'C','editor_verified','2026-06-11','2023-06-09',NULL,0);
INSERT INTO "data_quality" VALUES(41,'C','editor_verified','2026-06-11','2025-01-30',NULL,0);
INSERT INTO "data_quality" VALUES(42,'C','editor_verified','2026-06-11','2023-01-12',NULL,0);
INSERT INTO "data_quality" VALUES(43,'C','editor_verified','2026-06-11','2026-01-21',NULL,0);
INSERT INTO "data_quality" VALUES(44,'C','editor_verified','2026-06-11','2022-03-31',NULL,0);
INSERT INTO "data_quality" VALUES(45,'C','editor_verified','2026-06-11','2024-02-25',NULL,0);
INSERT INTO "data_quality" VALUES(46,'C','editor_verified','2026-06-11','2024-03-04',NULL,0);
INSERT INTO "data_quality" VALUES(47,'C','editor_verified','2026-06-11','2021-12-01',NULL,0);
INSERT INTO "data_quality" VALUES(48,'A','reviewer_approved','2026-06-11','2022-09-29',NULL,0);
CREATE TABLE exam_bodies (
    id              INTEGER PRIMARY KEY,
    name            TEXT NOT NULL UNIQUE,
    abbreviation    TEXT NOT NULL,
    level           TEXT NOT NULL CHECK (level IN ('central','state','university','other')),
    state           TEXT,
    parent_ministry TEXT,
    website         TEXT,
    created_at      TEXT NOT NULL DEFAULT (datetime('now'))
);
INSERT INTO "exam_bodies" VALUES(1,'Central Board of Secondary Education','CBSE','central',NULL,'Ministry of Education',NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(2,'Indian Army (Recruiting Organisation)','ARO','central',NULL,'Ministry of Defence',NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(3,'Board of Secondary Education, Assam','SEBA','state','Assam',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(4,'State Level Police Recruitment Board, Assam','SLPRB','state','Assam',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(5,'Central Selection Board of Constables','CSBC','state','Bihar',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(6,'Bihar Public Service Commission','BPSC','state','Bihar',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(7,'Bihar Staff Selection Commission','BSSC','state','Bihar',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(8,'Chhattisgarh Public Service Commission','CGPSC','state','Chhattisgarh',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(9,'Gujarat Panchayat Service Selection Board','GPSSB','state','Gujarat',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(10,'Gujarat Subordinate Service Selection Board','GSSSB','state','Gujarat',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(11,'Gujarat Govt. Recruitment (Bin Sachivalay)','GSEB-R','state','Gujarat',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(12,'Lokrakshak Recruitment Board, Gujarat','LRB','state','Gujarat',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(13,'Haryana Staff Selection Commission','HSSC','state','Haryana',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(14,'Himachal Pradesh Staff Selection Commission','HPSSC','state','Himachal Pradesh',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(15,'National Testing Agency','NTA','central',NULL,'Ministry of Education',NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(16,'J&K Services Selection Board','JKSSB','state','Jammu & Kashmir',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(17,'Jharkhand Staff Selection Commission','JSSC','state','Jharkhand',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(18,'Karnataka Police Recruitment Cell','KSP-RC','state','Karnataka',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(19,'Kerala Public Service Commission','KPSC','state','Kerala',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(20,'Maharashtra Housing & Area Development Authority','MHADA','state','Maharashtra',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(21,'Odisha Staff Selection Commission','OSSC','state','Odisha',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(22,'Punjab State Recruitment Bodies (multiple)','PB-REC','state','Punjab',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(23,'Rajasthan Police (Recruitment)','RAJPOL','state','Rajasthan',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(24,'Rajasthan Public Service Commission','RPSC','state','Rajasthan',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(25,'Board of Secondary Education, Rajasthan','BSER','state','Rajasthan',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(26,'Rajasthan Staff Selection Board','RSMSSB','state','Rajasthan',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(27,'Staff Selection Commission','SSC','central',NULL,'DoPT',NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(28,'Tamil Nadu Public Service Commission','TNPSC','state','Tamil Nadu',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(29,'Directorate of Govt. Examinations, Telangana','DGE-TS','state','Telangana',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(30,'Telangana State Public Service Commission','TSPSC','state','Telangana',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(31,'Uttarakhand Public Service Commission','UKPSC','state','Uttarakhand',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(32,'Uttarakhand Subordinate Service Selection Commission','UKSSSC','state','Uttarakhand',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(33,'U.P. Madhyamik Shiksha Parishad (UP Board)','UPMSP','state','Uttar Pradesh',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(34,'U.P. Police Recruitment & Promotion Board','UPPRPB','state','Uttar Pradesh',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(35,'U.P. Public Service Commission','UPPSC','state','Uttar Pradesh',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(36,'Examination Regulatory Authority, U.P.','ERA-UP','state','Uttar Pradesh',NULL,NULL,'2026-06-11 05:20:35');
INSERT INTO "exam_bodies" VALUES(37,'M.P. Professional Examination Board (Vyapam)','MPPEB','state','Madhya Pradesh',NULL,NULL,'2026-06-11 05:20:35');
CREATE TABLE exams (
    id              INTEGER PRIMARY KEY,
    exam_body_id    INTEGER NOT NULL REFERENCES exam_bodies(id),
    name            TEXT NOT NULL,
    purpose         TEXT NOT NULL CHECK (purpose IN
                      ('university_entrance','government_recruitment','school_board',
                       'professional_licence','scholarship','other')),
    cycle           TEXT NOT NULL CHECK (cycle IN ('annual','biannual','irregular','one_time')),
    typical_candidates INTEGER,
    UNIQUE (exam_body_id, name)
);
INSERT INTO "exams" VALUES(1,1,'AIPMT 2015 (pre-NEET medical entrance)','university_entrance','annual',630000);
INSERT INTO "exams" VALUES(2,2,'Common Entrance Exam, Soldier (GD) Feb 2021','government_recruitment','irregular',NULL);
INSERT INTO "exams" VALUES(3,3,'HSLC (Class 10) Examination 2023','school_board','annual',NULL);
INSERT INTO "exams" VALUES(4,4,'Sub-Inspector (UB) Recruitment 2020','government_recruitment','irregular',66000);
INSERT INTO "exams" VALUES(5,5,'Constable Recruitment 2023 (Advt. 01/2023)','government_recruitment','irregular',1800000);
INSERT INTO "exams" VALUES(6,6,'67th Combined (Preliminary) Competitive Exam','government_recruitment','annual',600000);
INSERT INTO "exams" VALUES(7,6,'70th Integrated CCE (Preliminary) 2024','government_recruitment','annual',NULL);
INSERT INTO "exams" VALUES(8,6,'Teacher Recruitment Exam TRE-3.0 (2024)','government_recruitment','irregular',NULL);
INSERT INTO "exams" VALUES(9,7,'CGL-3 (Sachivalaya Sahayak) 2022','government_recruitment','irregular',900000);
INSERT INTO "exams" VALUES(10,7,'Inter-Level Combined Competitive Exam 2014 (held 2017)','government_recruitment','irregular',NULL);
INSERT INTO "exams" VALUES(11,1,'Class 12 Economics / Class 10 Maths Board Exams 2018','school_board','annual',NULL);
INSERT INTO "exams" VALUES(12,8,'State Service (CCE) 2021','government_recruitment','annual',NULL);
INSERT INTO "exams" VALUES(13,9,'Junior Clerk Recruitment (Panchayat) 2023','government_recruitment','irregular',950000);
INSERT INTO "exams" VALUES(14,10,'Head Clerk Recruitment 2021','government_recruitment','irregular',88000);
INSERT INTO "exams" VALUES(15,11,'Bin Sachivalay Clerk & Office Asst (Gr-3) 2019','government_recruitment','irregular',NULL);
INSERT INTO "exams" VALUES(16,12,'Lokrakshak (Constable) Recruitment 2018','government_recruitment','irregular',875000);
INSERT INTO "exams" VALUES(17,13,'Gram Sachiv Recruitment Exam 2021','government_recruitment','irregular',800000);
INSERT INTO "exams" VALUES(18,14,'JOA (IT) Post Code 965 Exam 2022','government_recruitment','irregular',NULL);
INSERT INTO "exams" VALUES(19,13,'Male Constable (General Duty) Recruitment 2021','government_recruitment','irregular',NULL);
INSERT INTO "exams" VALUES(20,15,'JEE (Main) 2021','university_entrance','annual',700000);
INSERT INTO "exams" VALUES(21,16,'Sub-Inspector Recruitment 2022','government_recruitment','irregular',97000);
INSERT INTO "exams" VALUES(22,17,'JSSC-CGL (General Graduate Level) 2023','government_recruitment','irregular',NULL);
INSERT INTO "exams" VALUES(23,18,'Police Sub-Inspector Recruitment (Oct 2021)','government_recruitment','irregular',54287);
INSERT INTO "exams" VALUES(24,19,'Civil Police Officer Recruitment 2019','government_recruitment','irregular',NULL);
INSERT INTO "exams" VALUES(25,20,'MHADA Recruitment (Groups A-D) 2021','government_recruitment','one_time',NULL);
INSERT INTO "exams" VALUES(26,15,'NEET-UG 2021','university_entrance','annual',1600000);
INSERT INTO "exams" VALUES(27,15,'NEET-UG 2024','university_entrance','annual',2406000);
INSERT INTO "exams" VALUES(28,15,'NEET-UG 2026','university_entrance','annual',2270000);
INSERT INTO "exams" VALUES(29,21,'Junior Engineer (Civil) Exam 2023','government_recruitment','irregular',NULL);
INSERT INTO "exams" VALUES(30,22,'Teacher/JE/Patwari recruitment exams 2015-16','government_recruitment','irregular',NULL);
INSERT INTO "exams" VALUES(31,23,'Police Constable Recruitment 2021-22','government_recruitment','irregular',1150000);
INSERT INTO "exams" VALUES(32,24,'Sub-Inspector / Platoon Commander Recruitment 2021','government_recruitment','irregular',NULL);
INSERT INTO "exams" VALUES(33,25,'REET 2021 (Teacher Eligibility)','government_recruitment','irregular',1600000);
INSERT INTO "exams" VALUES(34,24,'Senior Teacher Grade-II Recruitment 2022','government_recruitment','irregular',400000);
INSERT INTO "exams" VALUES(35,26,'Junior Engineer (Civil, Degree) 2020','government_recruitment','irregular',NULL);
INSERT INTO "exams" VALUES(36,26,'Junior Engineer (Civil) 2020 — Sept 2021 retest','government_recruitment','irregular',NULL);
INSERT INTO "exams" VALUES(37,27,'Combined Graduate Level (CGL) 2017 — Tier II','government_recruitment','annual',3000000);
INSERT INTO "exams" VALUES(38,28,'Group II Services Exam 2012','government_recruitment','annual',NULL);
INSERT INTO "exams" VALUES(39,29,'SSC (Class 10) Examination 2023','school_board','annual',NULL);
INSERT INTO "exams" VALUES(40,30,'AE/AEE/DAO & other recruitment exams 2022-23','government_recruitment','irregular',NULL);
INSERT INTO "exams" VALUES(41,15,'UGC-NET June 2024','professional_licence','biannual',908000);
INSERT INTO "exams" VALUES(42,31,'Patwari/Lekhpal Exam 2022-23','government_recruitment','irregular',140000);
INSERT INTO "exams" VALUES(43,32,'Graduate-Level Recruitment Exam (Dec 2021)','government_recruitment','irregular',160000);
INSERT INTO "exams" VALUES(44,33,'Class 12 Board Exam (English) 2022','school_board','annual',NULL);
INSERT INTO "exams" VALUES(45,34,'Police Constable Recruitment 2023-24','government_recruitment','irregular',4800000);
INSERT INTO "exams" VALUES(46,35,'RO/ARO (Preliminary) Examination 2023','government_recruitment','irregular',1076000);
INSERT INTO "exams" VALUES(47,36,'UPTET 2021','government_recruitment','annual',2000000);
INSERT INTO "exams" VALUES(48,37,'Police Constable Recruitment Test 2013','government_recruitment','irregular',NULL);
CREATE TABLE incident_actors (
    incident_id     INTEGER NOT NULL REFERENCES incidents(id),
    actor_id        INTEGER NOT NULL REFERENCES actors(id),
    legal_status    TEXT NOT NULL CHECK (legal_status IN
                      ('NAMED_IN_FIR','ARRESTED','RELEASED_ON_BAIL','CHARGESHEETED',
                       'DISCHARGED','ON_TRIAL','CONVICTED','ACQUITTED','ABSCONDING',
                       'PROCEEDINGS_QUASHED','DECEASED')),
    status_date     TEXT NOT NULL,
    departmental_action TEXT CHECK (departmental_action IN
                      ('none_recorded','suspended','suspension_revoked','transferred',
                       'dismissed','retired_during_proceedings')),
    departmental_action_date TEXT,
    PRIMARY KEY (incident_id, actor_id)
);
INSERT INTO "incident_actors" VALUES(48,1,'CONVICTED','2022-09-29','none_recorded',NULL);
INSERT INTO "incident_actors" VALUES(48,2,'CONVICTED','2022-09-29','none_recorded',NULL);
INSERT INTO "incident_actors" VALUES(48,3,'CONVICTED','2022-09-29','none_recorded',NULL);
INSERT INTO "incident_actors" VALUES(48,4,'CONVICTED','2022-09-29','none_recorded',NULL);
INSERT INTO "incident_actors" VALUES(48,5,'CONVICTED','2022-09-29','none_recorded',NULL);
CREATE TABLE incidents (
    id              INTEGER PRIMARY KEY,
    slug            TEXT NOT NULL UNIQUE,
    title           TEXT NOT NULL,
    exam_id         INTEGER NOT NULL REFERENCES exams(id),
    exam_date       TEXT,
    leak_date       TEXT,
    surfaced_date   TEXT NOT NULL,
    states_affected TEXT NOT NULL,              -- JSON array
    candidates_affected INTEGER,
    summary         TEXT NOT NULL,
    leak_vector     TEXT CHECK (leak_vector IN
                      ('printing_press','transport','strongroom','exam_centre','insider_digital',
                       'coaching_nexus','solver_gang','unknown')),
    current_status  TEXT NOT NULL DEFAULT 'ALLEGED' CHECK (current_status IN
                      ('ALLEGED','FIR_REGISTERED','ARRESTS_MADE','CHARGESHEET_FILED',
                       'CLOSURE_REPORT','COGNIZANCE_TAKEN','TRIAL_ONGOING','CONVICTED',
                       'ACQUITTED','DISCHARGED','QUASHED','APPEAL_PENDING','STALLED')),
    is_published    INTEGER NOT NULL DEFAULT 0 CHECK (is_published IN (0,1)),
    created_at      TEXT NOT NULL DEFAULT (datetime('now')),
    CHECK (length(summary) <= 600)
);
INSERT INTO "incidents" VALUES(1,'aipmt-2015','AIPMT 2015: answer keys beamed to Bluetooth devices; SC scrapped the exam',1,'2015-05-03','2015-05-03','2015-05-03','["Haryana", "Pan-India"]',630000,'During AIPMT 2015, answer keys were transmitted to candidates through electronic devices, surfacing first in Rohtak, Haryana, where police registered a case the same day and arrested dozens including two dentists and an MBBS student. With the network''s reach across states unresolved and the alleged organiser absconding, the Supreme Court cancelled the entire exam on 15 June 2015 and ordered a re-test, held on 25 July 2015 for about 6.3 lakh candidates.','solver_gang','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(2,'army-cee-gd-2021','Army CEE leak (Secunderabad): officers booked; exam postponed',2,'2021-02-28','2021-02-27','2021-02-28','["Telangana", "Maharashtra", "Pan-India"]',NULL,'The Army''s common entrance exam for soldier (GD) scheduled for 28 February 2021 was postponed after the paper leaked the previous night; Pune police and military intelligence detained suspects, and the CBI registered a case that named serving officers, including the presiding officer of the Secunderabad board that printed the papers. In 2024 the Armed Forces Tribunal quashed a ''displeasure'' award against another board member, finding due process violations — while recording that the presiding officer was found to have leaked the paper.','printing_press','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(3,'assam-hslc-science-2023','Assam HSLC General Science paper cancelled night before exam',3,'2023-03-13','2023-03-12','2023-03-12','["Assam"]',400000,'A handwritten copy of the HSLC General Science (C3) paper went viral the night before the 13 March 2023 exam, forcing SEBA to cancel it. CID took over; 22 people were detained from Guwahati, North Lakhimpur, Dhemaji, Sadiya, Dibrugarh and Tinsukia within a day (arrests later rose), and two senior board officials were questioned. The paper was re-conducted on 30 March 2023.','exam_centre','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(4,'assam-police-si-2020','Assam SI exam halted mid-way; retired DIG among 37 arrested',4,'2020-09-20','2020-09-20','2020-09-20','["Assam"]',66000,'The written test for 597 unarmed SI posts in Assam was cancelled minutes after it began on 20 September 2020, when the paper was found circulating. Police arrested 37 people, including a retired DIG and an expelled political leader; the recruitment board disengaged the consortium conducting the exam after investigators flagged its personnel. The re-test was held on 22 November 2020.','insider_digital','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(5,'bihar-police-constable-2023','Bihar constable exam 2023: printing-press leak; cancelled in two days',5,'2023-10-01','2023-09-30','2023-10-01','["Bihar", "West Bengal", "Jharkhand", "Uttar Pradesh"]',1800000,'The written exam for 21,391 constable posts, held on 1 October 2023 at 529 centres for over 18 lakh aspirants, was cancelled by CSBC on 3 October after answers circulated before the test. EOU FIRs identified an inter-state gang — the same network later accused in the NEET-UG 2024 leak — and traced the leak to a Kolkata printing press through a vendor firm. Seven people including three from West Bengal were arrested; the ED opened a money-laundering case and raided four states in June 2025. The re-exam was held in August 2024.','printing_press','ARRESTS_MADE',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(6,'bpsc-67th-prelims-2022','BPSC 67th prelims cancelled within hours: paper on Telegram before exam',6,'2022-05-08','2022-05-08','2022-05-08','["Bihar"]',600000,'The 67th BPSC prelims of 8 May 2022 (1,083 centres) was cancelled the same day after the question paper circulated on Telegram and WhatsApp minutes before the exam — and matched the paper distributed at centres. Candidates at a centre in Ara had protested over irregularities. A three-member inquiry confirmed the leak within hours; the cyber cell and EOU probe led to arrests including a block development officer and an invigilator. The prelims were re-conducted in September 2022.','exam_centre','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(7,'bpsc-70th-cce-2024','BPSC 70th CCE prelims: leak alleged at Patna centre; one-centre re-test',7,'2024-12-13',NULL,'2024-12-13','["Bihar"]',NULL,'At Bapu Pariksha Bhavan in Patna, the 70th BPSC prelims of 13 December 2024 descended into disruption, with candidates alleging delayed distribution and a leak. BPSC attributed the disruption to a deliberate ruckus by ''miscreants'', identified 30–40 people for debarment, and ordered a re-test for that centre''s roughly 12,000 candidates, held on 4 January 2025. Two FIRs were registered. Statewide cancellation demands were declined; protests continued for weeks.','exam_centre','FIR_REGISTERED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(8,'bpsc-tre3-2024','BPSC TRE-3.0 leak: papers reached gangs before exam; both shifts cancelled',8,'2024-03-15','2024-03-14','2024-03-15','["Bihar", "Jharkhand"]',NULL,'Bihar''s Economic Offences Unit, acting on 13 March 2024 intelligence about a syndicate spanning Bihar, Jharkhand and Odisha, raided Hotel Kohinoor in Hazaribagh and found candidates being made to memorise answer keys before the 15 March TRE-3.0 exam, at a reported Rs 10 lakh per candidate. BPSC cancelled both shifts on 20 March on the SIT''s preliminary findings. 266 people including 88 women had been arrested by then. The exam was re-conducted in July 2024.','transport','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(9,'bssc-cgl3-2022','BSSC CGL-3: first-shift paper photographed and circulated; shift cancelled',9,'2022-12-23','2022-12-23','2022-12-24','["Bihar"]',900000,'BSSC''s graduate-level CGL-3 prelims were held in phases on 23-24 December 2022. A question paper from the first phase circulated on WhatsApp and matched the original, and on 27 December the commission cancelled the first-phase exam. The EOU probed the circulation and made arrests; aspirants protesting for full cancellation were lathi-charged in Patna in January 2023. The cancelled phase was re-conducted on 5 March 2023.','exam_centre','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(10,'bssc-inter-level-2017','BSSC inter-level leak: commission chairman, an IAS officer, arrested',10,'2017-02-05','2017-02-05','2017-02-08','["Bihar", "Jharkhand"]',NULL,'Question papers of BSSC''s inter-level exam (held 29 January and 5 February 2017) circulated on WhatsApp before the tests. An SIT arrested the commission''s secretary, and on 24 February 2017 arrested its chairman — a senior IAS officer — from Hazaribagh, along with family members; he was suspended and the exam cancelled. The Supreme Court granted him bail in October 2020 after nearly 3 years and 7 months in custody, noting the charge sheet had been filed and trial would take long.','insider_digital','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(11,'cbse-class12-economics-2018','CBSE 2018 leaks: nationwide Economics re-exam for lakhs of students',11,'2018-03-26','2018-03-26','2018-03-28','["Delhi", "Haryana", "Pan-India"]',NULL,'Handwritten copies of the CBSE Class 12 Economics and Class 10 Mathematics papers circulated on WhatsApp before the exams; the board itself received a copy of the maths paper by email nine hours before the test. Delhi Police''s crime branch registered cases and questioned dozens; teachers at a private school and a tutor were arrested for the Economics leak. The Economics paper was re-held nationwide on 25 April 2018; the Class 10 maths re-exam was ultimately dropped as the leak was found confined to Delhi and Haryana.','exam_centre','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(12,'cgpsc-cce-2021','CGPSC 2021 scam: CBI alleges prior access to papers for connected candidates',12,NULL,NULL,'2024-07-15','["Chhattisgarh"]',NULL,'The CBI''s probe into the CGPSC 2021 recruitment alleges systematic manipulation: a coaching operator with prior access to question papers ran targeted preparation sessions at a Mahasamund hotel days before the mains, helping relatives of senior officials and business families secure top ranks. The agency''s final charge sheet of about 400 pages, filed in January 2026, names 29 accused including a former commission chairman; 12 were in jail and one absconding at filing.','coaching_nexus','CHARGESHEET_FILED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(13,'gpssb-junior-clerk-2023','Gujarat junior clerk exam called off 4 hours before start',13,'2023-01-29','2023-01-28','2023-01-29','["Gujarat", "Odisha"]',950000,'Hours before 9.5 lakh candidates were to write the GPSSB junior clerk exam (1,181 posts, 2,995 centres) on 29 January 2023, the board called it off: Gujarat ATS had caught 15-16 people overnight with the question paper. The trail led to a worker at the Odisha printing press where papers were printed, plus coaching operators in Vadodara and Ahmedabad. It was the third cancellation for this recruitment since 2016. The exam was re-conducted within 100 days as promised, with free bus travel for candidates.','printing_press','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(14,'gsssb-head-clerk-2021','Gujarat head clerk exam scrapped: paper sold for Rs 6-12 lakh',14,'2021-12-12','2021-12-11','2021-12-13','["Gujarat"]',88000,'GSSSB''s head clerk exam of 12 December 2021 (186 posts, 88,000+ candidates) was cancelled on 21 December after evidence emerged that the paper had been leaked the previous night and sold for Rs 6–12 lakh. Police arrested eight people in Sabarkantha and a staffer of the Ahmedabad printing press contracted by the board. The re-exam was held in 2022; the state promised fast-track prosecution.','printing_press','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(15,'gujarat-bin-sachivalay-2019','Gujarat Bin Sachivalay clerk exam cancelled on SIT finding of leak',15,'2019-11-17','2019-11-17','2019-11-17','["Gujarat"]',NULL,'Applicants alleged the Bin Sachivalay clerk paper and answers circulated on WhatsApp before the 17 November 2019 exam. After protests, the state formed an SIT, which concluded within ten days — using seized phones, CCTV footage and FSL analysis — that the paper had leaked. The government cancelled the exam on 16 December 2019.','unknown','ALLEGED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(16,'gujarat-lrd-constable-2018','Gujarat Lokrakshak exam called off hours before start',16,'2018-12-02','2018-12-02','2018-12-02','["Gujarat"]',875000,'The Lokrakshak (police constable) recruitment exam, for which about 8.75 lakh candidates were registered, was cancelled hours before it was to begin on 2 December 2018 after the paper leaked. Thirteen people were arrested in the first week; the exam was re-scheduled for 6 January 2019.','unknown','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(17,'haryana-gram-sachiv-2021','Haryana Gram Sachiv exam nullified after answer-key racket bust',17,'2021-01-09','2021-01-09','2021-01-11','["Haryana"]',800000,'About eight lakh candidates wrote the Gram Sachiv exam on 9–10 January 2021. A Hisar SIT busted a racket digitally distributing answer keys: an exam observer allegedly photographed the paper at a school centre, sent it out for solving, and the key was relayed onward for money. Eighteen people had been arrested by 17 January, when HSSC nullified the examination.','exam_centre','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(18,'hpssc-joa-it-2022','HP JOA-IT leak: commission itself dissolved after vigilance probe',18,'2022-12-25','2022-12-23','2022-12-23','["Himachal Pradesh"]',NULL,'Himachal Pradesh vigilance caught an HPSSC insider''s network selling the JOA (IT) Post Code 965 question paper for about Rs 2.5 lakh in Hamirpur before the 25 December 2022 exam, which was stopped. Departmental and vigilance reports found papers had been leaked and sold selectively for roughly three years. The state suspended the commission''s functioning and dissolved HPSSC on 21 February 2023, transferring recruitment to HPPSC — the only case in this register where the leak ended the exam body itself.','insider_digital','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(19,'hssc-constable-2021','Haryana constable exam cancelled on day one; Kaithal coaching module busted',19,'2021-08-07','2021-08-07','2021-08-07','["Haryana"]',NULL,'HSSC cancelled the male constable written exam on 7 August 2021, its first day, after the paper leaked; the next day''s papers were cancelled too. Multiple FIRs were registered across districts and 14 people were arrested within two days, including a Kaithal coaching-centre operator alleged to have struck deals at about Rs 12 lakh per candidate, with the answer key recovered from the group. The opposition demanded a court-monitored CBI probe.','coaching_nexus','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(20,'jee-main-2021','JEE Main 2021: remote-access solving racket at a chosen centre',20,'2021-09-02',NULL,'2021-09-02','["Haryana", "Delhi", "Uttar Pradesh"]',NULL,'The CBI booked a private edtech firm and its directors for manipulating JEE (Main) 2021: solvers answered candidates'' papers via remote-access software from a chosen exam centre in Sonepat, in connivance with centre staff, for Rs 12–15 lakh per candidate, with mark sheets and post-dated cheques held as security. Searches ran at 20 locations and seven people were arrested in the first days. NTA withheld results of suspect candidates.','insider_digital','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(21,'jkssb-si-2022','JKSSB SI exam: selection list scrapped; CBI chargesheeted 33',21,'2022-03-27','2022-03-26','2022-06-10','["Jammu & Kashmir", "Haryana"]',97000,'After the J&K sub-inspector exam of 27 March 2022, aspirants alleged the paper had been sold for Rs 15–30 lakh by a Haryana-linked gang. The administration scrapped the select list of 1,200 SIs (along with JE and FAA lists) in July 2022 and handed the case to the CBI, which charge-sheeted 33 accused on 12 November 2022, including board insiders and touts. The ED later arrested alleged organisers in a linked money-laundering case (2024). The exam was re-conducted in December 2022.','unknown','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(22,'jssc-cgl-2024','JSSC CGL 2024: third-shift GK paper leaked; shift cancelled',22,'2024-01-28','2024-01-28','2024-01-28','["Jharkhand"]',NULL,'During the JSSC-CGL exam of 28 January 2024, candidates reported that much of the General Knowledge/General Studies paper — reportedly about 70 questions with answers — circulated hours before the third shift. After protests in Ranchi and other districts, JSSC cancelled the third-shift examination by a late-night notification; the exam was subsequently re-conducted in September 2024 amid continuing disputes over the process.','unknown','ALLEGED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(23,'karnataka-psi-2021','Karnataka PSI scam: ADGP heading recruitment arrested',23,'2021-10-03','2021-10-03','2022-04-09','["Karnataka"]',54287,'The October 2021 exam to select 545 Karnataka police sub-inspectors (54,287 candidates) was rigged through Bluetooth-aided answer relays and OMR tampering, surfacing in April 2022 after a Kalaburagi candidate''s marks didn''t match her sheet. The CID arrested more than 15 police personnel, and on 4 July 2022 arrested the ADGP who headed the recruitment cell — charge-sheeted with prosecution sanction under the PC Act, and bailed in September 2023. The government ordered a re-examination.','exam_centre','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(24,'kerala-psc-cpo-2019','Kerala PSC CPO exam fraud: student leaders and a police officer chargesheeted',24,'2019-02-09','2019-02-09','2019-07-15','["Kerala"]',NULL,'A probe that began with an unrelated 2019 campus incident found that activists from a Thiruvananthapuram college had topped the civil police officer exam through exam-hall fraud using smartwatches and earphones, aided by a serving civil police officer who relayed messages during the test. The Crime Branch charge-sheeted six people in April 2023 under forgery, breach-of-trust, conspiracy and cyber-law provisions; the rank-list placements were removed.','exam_centre','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(25,'mhada-recruitment-2021','MHADA exam scrapped: vendor''s director arrested with the paper',25,'2021-12-12','2021-12-10','2021-12-11','["Maharashtra"]',NULL,'Days before MHADA''s recruitment exams for 565 posts (12–20 December 2021), Pune cyber police arrested the director of the private firm contracted to conduct the exam, with the question paper allegedly in his possession. The exams were cancelled and the firm was blacklisted in March 2022. The same probe led investigators to the Maharashtra TET result-tampering case and the arrest and suspension of the state examination council''s commissioner.','insider_digital','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(26,'neet-ug-2021-jaipur','NEET-UG 2021: Jaipur centre invigilator sent paper out mid-exam',26,'2021-09-12','2021-09-12','2021-09-13','["Rajasthan"]',NULL,'At a Jaipur centre during NEET-UG 2021, an invigilator photographed the question paper and sent it out to be solved for a candidate, with Rs 35 lakh allegedly demanded. Jaipur police, acting on specific information, arrested eight people including the invigilator and the candidate, and seized Rs 10 lakh. The episode was localised; the national exam was not cancelled.','exam_centre','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(27,'neet-ug-2024','NEET-UG 2024 paper theft (Hazaribagh–Patna)',27,'2024-05-05','2024-05-05','2024-05-05','["Bihar", "Jharkhand", "Gujarat"]',2406000,'Hours before NEET-UG 2024, Patna police acted on a tip-off and arrested 13 people including four examinees who had allegedly paid Rs 30–50 lakh for the paper. CBI later traced burnt question-paper scraps to a school in Hazaribagh, where the paper was photographed inside the strongroom on exam morning and circulated to solver groups. The Supreme Court found 155 identified beneficiaries but declined a nationwide re-test. Three CBI charge sheets were filed against 40 accused by October 2024; about 49 persons were arrested.','strongroom','CHARGESHEET_FILED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(28,'neet-ug-2026','NEET-UG 2026 ''guess paper'' leak and nationwide cancellation',28,'2026-05-03',NULL,'2026-05-04','["Rajasthan", "Maharashtra", "Pan-India"]',2270000,'NEET-UG 2026, written by about 22.7 lakh aspirants on 3 May 2026, was cancelled by the NTA on 12 May after Rajasthan Police''s Special Operations Group found that 100+ biology and chemistry questions from a pre-circulated ''guess paper'' of 400+ questions matched the actual paper. A Sikar chemistry teacher reported the overlap. Arrests followed in Jaipur, and 45 people were detained in Latur and Nashik. The CBI took over on 12 May. A nationwide re-examination was scheduled for 21 June 2026.','coaching_nexus','ARRESTS_MADE',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(29,'ossc-je-2023','OSSC JE exam leak: printing-press helper was the source',29,'2023-07-16','2023-07-15','2023-07-16','["Odisha", "West Bengal", "Bihar"]',NULL,'Hours before the OSSC junior engineer (civil) exam on 16 July 2023, police arrested nine people at a Digha hotel with the paper. Balasore police later arrested eight more including the alleged organiser — a Bihar native working in the Accountant General''s office in Patna — and the source: a helper at the out-of-state press where papers were printed. OSSC cancelled the examination.','printing_press','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(30,'punjab-recruitment-cluster-2015','Punjab 2015-16: one printing-press module leaked a dozen exams',30,NULL,NULL,'2016-10-16','["Punjab", "Haryana", "Delhi", "Uttar Pradesh", "Bihar"]',NULL,'Punjab Vigilance Bureau investigations from 2015–17 unearthed a module that leaked question papers printed at a Delhi government press for a dozen recruitment exams across Punjab and neighbouring states — JBT/TGT/NTT teachers, junior engineers, patwaris and corporation engineers among them — with about 70 arrests including candidates and conduits. The patwari exam was scrapped on leak evidence. The alleged head of the module, a Lucknow resident, and a government press employee were arrested in May 2017.','printing_press','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(31,'rajasthan-constable-2022','Rajasthan constable exam: one shift cancelled after centre leak',31,'2022-05-14','2022-05-14','2022-05-15','["Rajasthan"]',250000,'During the Rajasthan Police constable recruitment exams of 13–16 May 2022 (around 11.5 lakh candidates), the paper for the 14 May second shift leaked from a private school centre in Jhotwara, Jaipur, where the centre superintendent allegedly opened the paper before time. The shift, affecting about 2.5 lakh candidates, was cancelled and re-conducted; police arrested the school operators and registered a case.','exam_centre','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(32,'rajasthan-si-2021','Rajasthan SI 2021: topper among trainee SIs held; HC scrapped the exam',32,'2021-09-13','2021-09-13','2024-03-04','["Rajasthan"]',NULL,'Rajasthan''s 2021 SI recruitment exam was leaked from a Jaipur centre, with the paper sold for about Rs 20 lakh. The fraud surfaced in March 2024 when the SOG detained 15 trainee sub-inspectors — including the exam topper — at the Rajasthan Police Academy; the probe estimated about 25 of 670 trainees had cleared the exam fraudulently. On 28 August 2025 the High Court cancelled the entire recruitment (''fraud vitiates everything''); a division bench upheld the cancellation on 4 April 2026 and directed a new legal framework for transparent recruitment.','exam_centre','ARRESTS_MADE',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(33,'reet-2021','REET 2021: paper stolen from Jaipur''s Shiksha Sankul; Level-II scrapped',33,'2021-09-26','2021-09-24','2021-09-26','["Rajasthan"]',1600000,'On REET exam day, Bikaner police caught candidates with Bluetooth devices in slippers. The SOG probe found the Level-II paper had been stolen on 24 September from Shiksha Sankul, the Jaipur education-department campus, by a man engaged for paper security through the district coordinator''s office. The state cancelled the Level-II exam on 7 February 2022; 71 people were arrested and 65 charge-sheeted per the SOG''s report to the High Court, which also ruled out the board chairman''s role. The chairman was nonetheless removed. Level-II was re-held in July 2022.','strongroom','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(34,'rpsc-senior-teacher-gk-2022','RPSC senior teacher exam: 40+ caught solving leaked paper in a moving bus',34,'2022-12-24','2022-12-23','2022-12-24','["Rajasthan"]',400000,'On the morning of 24 December 2022, Udaipur police stopped a bus and found about 40 people — including dummy candidates and several teachers — solving the leaked General Knowledge paper of RPSC''s senior teacher recruitment. Candidates had reportedly paid Rs 5–8 lakh each to a Jodhpur-based gang. RPSC cancelled that morning''s GK paper (nearly 4 lakh applicants); ATS and SOG took up the probe, which expanded through 2023 with further arrests. It was counted as the ninth leak-hit RPSC exam in recent years.','coaching_nexus','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(35,'rsmssb-jen-2020','Rajasthan JEn 2020 leak: exam scrapped; gang leader held in 2024',35,'2020-12-06','2020-12-06','2020-12-08','["Rajasthan"]',NULL,'The RSMSSB Junior Engineer (Civil) exam of 6 December 2020 was cancelled after the paper leaked; the SOG probe identified an organised network that profited candidates in this and later exams. The network''s leader was arrested on 29 February 2024 during the wider crackdown on Rajasthan leak gangs, and told police he had also supplied papers for the 2021 SI exam. The re-test of September 2021 was later found compromised as well (see separate entry).','exam_centre','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(36,'rsmssb-jen-2021-retest','Rajasthan JEn 2020 retest (Sept 2021) found compromised',36,NULL,NULL,'2026-01-19','["Rajasthan"]',NULL,'The Junior Engineer (Civil) 2020 recruitment exam was cancelled over a leak and re-conducted in September 2021. In January 2026, Rajasthan SOG disclosed that the retest itself had been compromised: an assistant engineer of the PWD, who secured the 12th rank in the retest and was later promoted, was arrested and is alleged to have used a leaked paper and played a role in the leak network. The SOG registered a fresh FIR on 19 January 2026.','unknown','ARRESTS_MADE',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(37,'ssc-cgl-2017','SSC CGL 2017 leak: SC called the system ''tainted''; CBI booked vendor staff',37,'2018-02-21','2018-02-21','2018-02-21','["Delhi", "Pan-India"]',3000000,'During the online CGL 2017 Tier-II exam in February 2018, a screenshot of the live paper circulated, sparking weeks of street protests by aspirants. The CBI registered an FIR against 17 people, including ten employees of the exam-technology vendor — among them the custodian of the question bank — and seven candidates. The Supreme Court stayed the results in August 2018, observing that the entire system seemed compromised, and allowed the re-examination''s results in April 2019. Three accused were arrested in June 2019.','insider_digital','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(38,'tnpsc-group2-2012','TNPSC Group II exam cancelled after Erode leak',38,'2012-08-12','2012-08-12','2012-08-12','["Tamil Nadu"]',NULL,'TNPSC cancelled its Group II services written test of 12 August 2012 after a question paper leak surfaced; a candidate was found outside an Erode exam hall with the leaked questions half an hour before the exam. Police arrested at least five people across Dharmapuri and Erode, including a couple, and an internal committee was formed. A re-exam was announced.','unknown','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(39,'ts-ssc-hindi-2023','Telangana SSC Hindi paper on WhatsApp minutes after start',39,'2023-04-04','2023-04-04','2023-04-04','["Telangana"]',NULL,'During the Telangana SSC Hindi exam on 4 April 2023, the paper circulated on WhatsApp groups within 30 minutes of the start — the second such episode on consecutive days. Police traced it to a centre in Kamalapur, Hanumakonda: a minor photographed the paper through a first-floor window after climbing a tree, and two others forwarded it. Three people were arrested under Section 5 of the Telangana Public Examinations Act. The exam was not cancelled.','exam_centre','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(40,'tspsc-multi-exam-2023','TSPSC insider leak: confidential-section computers accessed; exams cancelled',40,'2023-03-05',NULL,'2023-03-13','["Telangana"]',NULL,'Two TSPSC insiders — an assistant section officer and an outsourced network administrator — allegedly gained unauthorised access to the confidential section''s computers and copied question papers for several recruitment exams, selling them for about Rs 1.63 crore in total. The leak surfaced via a complaint by a TSPSC assistant secretary; a case was registered at Begum Bazar PS and an SIT formed. 49 people were arrested and a preliminary charge sheet was filed on 9 June 2023. Affected exams, including AE/AEE, were cancelled and re-held.','insider_digital','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(41,'ugc-net-2024','UGC-NET June 2024: cancelled on darknet alert; CBI found no leak',41,'2024-06-18',NULL,'2024-06-19','["Pan-India"]',908000,'The Education Ministry cancelled UGC-NET on 19 June 2024, a day after it was held, citing I4C inputs that the paper was on the darknet and being sold on Telegram. The CBI investigated and concluded the ''leaked'' image was a doctored screenshot with a manipulated timestamp, circulated by a student. A closure report recording no evidence of a leak was filed before a special court on 30 January 2025. The exam was re-conducted in August–September 2024. This entry stands as a documented false-alarm benchmark.','unknown','CLOSURE_REPORT',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(42,'ukpsc-patwari-2023','UKPSC Patwari exam leak: commission section officer arrested',42,'2023-01-08','2023-01-07','2023-01-09','["Uttarakhand"]',140000,'Uttarakhand''s Patwari/Lekhpal exam of 8 January 2023 was cancelled after the STF found the paper had been leaked to candidates before the exam. A section officer of the commission and three others, including his wife, were arrested and Rs 22.5 lakh was recovered. The re-exam was held on 12 February 2023 for about 1.4 lakh candidates. This was the state''s second leak episode in months, after the UKSSSC cases moved exams to UKPSC.','insider_digital','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(43,'uksssc-graduate-2021','UKSSSC graduate exam leak: Uttarakhand''s largest recruitment scandal',43,'2021-12-05','2021-12-04','2022-07-22','["Uttarakhand", "Uttar Pradesh"]',160000,'In July 2022, Uttarakhand STF established that the December 2021 UKSSSC graduate-level paper had been leaked through a chain involving an outsourced printing-press network, with candidates charged up to Rs 12–15 lakh. More than 40 people were arrested, including the alleged organiser, a resort owner from Uttarkashi, who spent 13 months in jail, was re-arrested in September 2025 on the eve of another exam, and got high-court bail in January 2026. The exam was scrapped; linked leaks hit the 2021 forest inspector and secretariat guard exams. Recruitment moved to UKPSC.','printing_press','ARRESTS_MADE',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(44,'up-board-class12-english-2022','UP Board English paper leak: exam cancelled in 24 districts; DIOS arrested',44,'2022-03-30','2022-03-30','2022-03-30','["Uttar Pradesh"]',NULL,'The UP Board Class 12 English paper leaked from Ballia before the 30 March 2022 exam, which was cancelled in 24 districts of eastern UP and went ahead in the remaining 51. The Ballia district inspector of schools and 16 others were arrested under FIRs; the DIOS was suspended, the STF took over, and the Chief Minister directed invocation of the NSA against those involved. The cancelled paper was re-held on 13 April 2022.','strongroom','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(45,'up-police-constable-2024','UP Police constable exam leak: 48 lakh candidates, exam scrapped',45,'2024-02-17','2024-02-17','2024-02-18','["Uttar Pradesh"]',4800000,'More than 48 lakh candidates wrote the UP Police constable recruitment exam on 17–18 February 2024 for 60,244 posts. After question papers circulated before the test, the state government cancelled the exam on 24 February, ordered an STF probe and FIRs, and promised a re-test within six months with free bus travel for candidates. Over 240 people had been arrested or detained across the state for using or planning unfair means. The re-exam was held in August 2024.','transport','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(46,'uppsc-ro-aro-2024','UPPSC RO/ARO 2024 prelims cancelled over leak',46,'2024-02-11','2024-02-11','2024-02-12','["Uttar Pradesh"]',1076000,'The UPPSC Review Officer / Assistant Review Officer preliminary exam of 11 February 2024 (411 posts, about 10.8 lakh candidates) was cancelled on 2 March 2024 after paper-leak allegations spread on social media and candidates protested. The Chief Minister ordered cancellation on the Commission''s report, a re-exam within six months, and an STF investigation to identify and prosecute those involved. The re-examination was eventually conducted in July 2025.','unknown','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(47,'uptet-2021','UPTET 2021 cancelled on exam morning; exam authority secretary arrested',47,'2021-11-28','2021-11-28','2021-11-28','["Uttar Pradesh"]',2000000,'UPTET 2021 was cancelled on the morning of 28 November 2021 — with about 20 lakh candidates en route — after the paper circulated on WhatsApp. UP STF arrested 23 people the same day; the probe pointed to the outsourced printing arrangement, and the director of the Examination Regulatory Authority''s office responsible (PNP secretary) was arrested and suspended in early December. The re-exam was held on 23 January 2022 with candidates travelling free.','printing_press','STALLED',1,'2026-06-11 05:20:35');
INSERT INTO "incidents" VALUES(48,'vyapam-constable-2013','Vyapam (terminal case): five convicted for 2013 constable test impersonation',48,'2013-04-07',NULL,'2013-07-07','["Madhya Pradesh"]',NULL,'In one of the few exam-fraud cases in this register to reach judgment, a special CBI court in Bhopal on 29 September 2022 sentenced five men to seven years'' rigorous imprisonment and Rs 10,000 fines each for rigging the 2013 MP police constable recruitment test: four had hired impersonators to write the exam, and one wrote it for another. 32 witnesses and 220 documents were examined. The case is part of the wider Vyapam scandal, exposed in July 2013, in which over 2,000 people had been arrested by mid-2015 and the Supreme Court moved all cases to the CBI in July 2015.','solver_gang','CONVICTED',1,'2026-06-11 05:20:35');
CREATE TABLE legal_actions (
    id              INTEGER PRIMARY KEY,
    incident_id     INTEGER NOT NULL REFERENCES incidents(id),
    action_type     TEXT NOT NULL CHECK (action_type IN
                      ('FIR_REGISTERED','ARREST','BAIL_GRANTED','BAIL_REJECTED',
                       'CHARGESHEET_FILED','CLOSURE_REPORT_FILED','COGNIZANCE_TAKEN',
                       'CHARGES_FRAMED','HEARING','WITNESS_EXAMINED','CONVICTED','ACQUITTED',
                       'DISCHARGED','FIR_QUASHED','CASE_TRANSFERRED','APPEAL_FILED',
                       'APPEAL_DECIDED','PROCEEDINGS_ABATED','EXAM_CANCELLED','RE_EXAM_ORDERED',
                       'OTHER_ORDER')),
    action_date     TEXT NOT NULL,
    court_or_agency TEXT NOT NULL,
    case_identifier TEXT,
    description     TEXT NOT NULL,
    document_source_id INTEGER REFERENCES sources(id),
    created_at      TEXT NOT NULL DEFAULT (datetime('now'))
);
INSERT INTO "legal_actions" VALUES(1,1,'FIR_REGISTERED','2015-05-03','PS PGIMS, Rohtak, Haryana','PS PGIMS Rohtak case (03.05.2015)','Case after answer keys were found transmitted to mobile devices before the exam ended.',1,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(2,1,'ARREST','2015-05-10','Haryana Police (CIA-2, Rohtak)','PS PGIMS Rohtak case (03.05.2015)','12 accused and 25 candidates arrested in the first weeks, incl. two dentists and an MBBS student.',1,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(3,1,'EXAM_CANCELLED','2015-06-15','Supreme Court of India','AIPMT W.P.(C), order dt. 15.06.2015','Exam cancelled; CBSE directed to hold a re-test within four weeks.',1,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(4,1,'ARREST','2015-06-19','Haryana Police, Rohtak','PS PGIMS Rohtak case (03.05.2015)','Alleged organiser of the answer-key network arrested after a Rs 1 lakh bounty.',2,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(5,2,'EXAM_CANCELLED','2021-02-28','Indian Army',NULL,'CEE postponed nationwide after the leak was detected.',4,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(6,2,'FIR_REGISTERED','2021-03-05','Central Bureau of Investigation',NULL,'CBI case naming serving officers of the question-paper board and civilian intermediaries.',4,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(7,2,'OTHER_ORDER','2024-03-27','Armed Forces Tribunal, Chandigarh',NULL,'''Displeasure'' against a board member quashed for procedural violations.',4,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(8,3,'EXAM_CANCELLED','2023-03-12','Board of Secondary Education, Assam',NULL,'General Science paper cancelled after a handwritten copy circulated on social media.',5,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(9,3,'ARREST','2023-03-14','Assam Police / CID',NULL,'22 persons detained across six towns; CID questioned two senior board officials.',5,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(10,4,'EXAM_CANCELLED','2020-09-20','State Level Police Recruitment Board, Assam',NULL,'Exam cancelled minutes after commencement.',6,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(11,4,'FIR_REGISTERED','2020-09-21','Assam Police',NULL,'Cases registered; probe covered the exam-conducting consortium.',6,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(12,4,'ARREST','2020-10-09','Assam Police',NULL,'37 arrested incl. a retired DIG and an expelled political leader.',6,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(13,5,'EXAM_CANCELLED','2023-10-03','Central Selection Board of Constables','CSBC notice dt. 03.10.2023','Written exam of 01.10.2023 cancelled; later shifts postponed.',7,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(14,5,'FIR_REGISTERED','2023-10-04','Economic Offences Unit, Bihar Police',NULL,'EOU FIRs against the leak syndicate; probe identified a Kolkata press and a vendor firm in the chain.',8,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(15,5,'ARREST','2023-10-31','EOU, Bihar Police',NULL,'Seven private persons arrested, including three from West Bengal; gang head in judicial custody.',8,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(16,5,'OTHER_ORDER','2025-06-19','Enforcement Directorate',NULL,'PMLA searches at a dozen locations in Bihar, Jharkhand, UP and West Bengal, covering the printing press.',8,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(17,6,'EXAM_CANCELLED','2022-05-08','Bihar Public Service Commission',NULL,'Exam cancelled same day on the inquiry committee''s findings.',9,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(18,6,'FIR_REGISTERED','2022-05-09','Cyber cell / EOU, Bihar Police',NULL,'Probe ordered by BPSC chairman; case registered into the Telegram/WhatsApp circulation.',9,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(19,6,'ARREST','2022-05-11','Economic Offences Unit, Bihar Police',NULL,'Four arrested, including a BDO and a college invigilator linked to the Ara centre.',10,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(20,7,'FIR_REGISTERED','2024-12-15','Patna District Police',NULL,'Two FIRs registered in connection with the disruption at the Bapu Pariksha Bhavan centre.',11,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(21,7,'EXAM_CANCELLED','2024-12-16','Bihar Public Service Commission',NULL,'Exam at the single Patna centre cancelled after CCTV review; re-test ordered for that centre only.',11,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(22,8,'ARREST','2024-03-15','EOU SIT, Bihar Police / Hazaribagh Police','EOU PS Case, Patna (March 2024)','Raids at Hotel Kohinoor, Barahi (Hazaribagh); 270+ candidates and operators questioned; question-paper sets and answer keys recovered. 266 arrests by 20 March.',13,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(23,8,'FIR_REGISTERED','2024-03-16','Economic Offences Unit, Patna','EOU PS Case, Patna (March 2024)','Case under IPC 420/467/468/471/120B, Bihar Examination Control Act and IT Act.',13,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(24,8,'EXAM_CANCELLED','2024-03-20','Bihar Public Service Commission','BPSC notice dt. 20.03.2024','Both shifts of TRE-3.0 cancelled on the EOU''s preliminary findings that papers reached an organised gang before the exam.',12,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(25,9,'FIR_REGISTERED','2022-12-24','Economic Offences Unit, Bihar Police',NULL,'Case into circulation of the first-shift paper during the exam.',15,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(26,9,'EXAM_CANCELLED','2022-12-27','Bihar Staff Selection Commission',NULL,'First shift of 23.12.2022 cancelled on EOU findings.',15,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(27,9,'ARREST','2023-01-05','EOU, Bihar Police',NULL,'Arrests in the circulation probe; protesting aspirants also detained separately.',15,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(28,10,'FIR_REGISTERED','2017-02-08','Agamkuan PS, Patna / SIT',NULL,'FIR after admit cards and documents were recovered from the commission secretary''s residence.',16,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(29,10,'ARREST','2017-02-24','SIT, Patna Police',NULL,'Commission chairman (IAS) arrested from Hazaribagh; secretary also arrested; chairman suspended.',17,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(30,10,'CHARGESHEET_FILED','2017-08-20','SIT, Patna Police',NULL,'Charge sheet filed (recorded in the Supreme Court''s 2020 bail order).',16,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(31,10,'BAIL_GRANTED','2020-10-06','Supreme Court of India',NULL,'Regular bail after ~3 years 7 months custody; conditions against influencing trial.',16,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(32,11,'FIR_REGISTERED','2018-03-28','Delhi Police (Crime Branch)',NULL,'Two FIRs over the Economics and Mathematics leaks; SIT questioning of students and tutors.',18,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(33,11,'ARREST','2018-04-01','Delhi Police',NULL,'Two schoolteachers and a private tutor arrested in the Economics leak.',18,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(34,11,'RE_EXAM_ORDERED','2018-03-30','CBSE',NULL,'Economics re-exam announced for 25 April nationwide; Class 10 maths re-exam later dropped.',18,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(35,12,'FIR_REGISTERED','2024-07-15','Central Bureau of Investigation',NULL,'CBI registered the case on the state government''s reference alleging manipulation of the 2021 recruitment.',19,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(36,12,'ARREST','2024-11-18','Central Bureau of Investigation',NULL,'Former commission chairman and a businessman among those arrested as the probe progressed.',19,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(37,12,'CHARGESHEET_FILED','2026-01-02','Special Court (CBI), Raipur',NULL,'Final charge sheet (~400 pages) naming 29 accused; 12 in custody, one absconding.',19,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(38,13,'ARREST','2023-01-28','Gujarat ATS',NULL,'15-16 persons caught with the paper, incl. coaching operators; printing-press worker from Odisha identified as the source.',20,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(39,13,'EXAM_CANCELLED','2023-01-29','GPSSB',NULL,'Exam ''postponed'' hours before start in the candidates'' broader interest.',21,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(40,13,'FIR_REGISTERED','2023-01-29','Gujarat ATS',NULL,'Case naming coaching operators and the press insider chain.',20,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(41,14,'ARREST','2021-12-14','Gujarat Police',NULL,'Eight sellers of the leaked paper arrested in Sabarkantha, plus a printing-press staffer.',22,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(42,14,'EXAM_CANCELLED','2021-12-21','GSSSB / Government of Gujarat',NULL,'Exam cancelled; re-exam announced.',22,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(43,14,'FIR_REGISTERED','2021-12-13','Gujarat Police',NULL,'Case registered after evidence the paper circulated the night before the exam.',22,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(44,15,'OTHER_ORDER','2019-12-06','SIT, Government of Gujarat',NULL,'SIT formed; phones and CCTV sent to FSL; primary conclusion: paper leaked.',23,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(45,15,'EXAM_CANCELLED','2019-12-16','Government of Gujarat',NULL,'Exam cancelled on the SIT''s primary report.',23,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(46,16,'EXAM_CANCELLED','2018-12-02','Lokrakshak Recruitment Board, Gujarat',NULL,'Exam cancelled hours before commencement due to the leak.',24,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(47,16,'ARREST','2018-12-09','Gujarat Police',NULL,'13 arrested in connection with the leak.',24,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(48,17,'FIR_REGISTERED','2021-01-11','Hisar Police (SIT)',NULL,'Case against the answer-key distribution racket.',25,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(49,17,'ARREST','2021-01-17','SIT, Hisar Police',NULL,'18 arrested, incl. the exam observer who photographed the paper.',25,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(50,17,'EXAM_CANCELLED','2021-01-17','Haryana Staff Selection Commission',NULL,'Examination nullified.',25,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(51,18,'FIR_REGISTERED','2022-12-23','State Vigilance & Anti-Corruption Bureau, Hamirpur',NULL,'Trap and case after the paper was offered for sale before the exam.',26,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(52,18,'ARREST','2022-12-24','Vigilance Bureau, HP',NULL,'A commission staffer and associates held; electronic devices sent to forensics.',26,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(53,18,'EXAM_CANCELLED','2022-12-24','HPSSC',NULL,'Exam withheld; commission''s functioning suspended pending inquiry.',26,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(54,18,'CHARGESHEET_FILED','2023-02-21','Vigilance Bureau, HP',NULL,'First charge sheet filed the day the state dissolved the commission.',26,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(55,18,'OTHER_ORDER','2023-02-21','Government of Himachal Pradesh',NULL,'HPSSC dissolved with immediate effect; recruitment transferred to HPPSC.',26,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(56,19,'EXAM_CANCELLED','2021-08-07','Haryana Staff Selection Commission',NULL,'Written exam cancelled on day one; remaining shifts also scrapped.',27,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(57,19,'FIR_REGISTERED','2021-08-07','Haryana Police (multiple districts)',NULL,'Multiple FIRs; HSSC chief sought a DGP-level probe.',27,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(58,19,'ARREST','2021-08-09','Haryana Police',NULL,'14 arrested incl. a coaching operator; answer key recovered.',27,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(59,20,'FIR_REGISTERED','2021-09-01','Central Bureau of Investigation',NULL,'FIR against the firm, its directors, touts and centre staff for remote-access manipulation.',28,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(60,20,'ARREST','2021-09-03','Central Bureau of Investigation',NULL,'Seven arrested, incl. directors and staff; searches at 20 locations.',28,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(61,21,'OTHER_ORDER','2022-07-08','J&K Administration',NULL,'Select lists of 1,200 SIs, 1,300 JEs and 1,000 FAAs cancelled over leak and malpractice allegations.',29,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(62,21,'CASE_TRANSFERRED','2022-08-03','Central Bureau of Investigation',NULL,'Probe handed to CBI.',29,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(63,21,'CHARGESHEET_FILED','2022-11-12','CBI court, Jammu',NULL,'Charge sheet against 33 accused.',29,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(64,21,'ARREST','2024-07-11','Enforcement Directorate',NULL,'ED arrests in the PMLA case built on the CBI FIR; payments routed to organisers'' accounts.',30,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(65,22,'EXAM_CANCELLED','2024-01-28','Jharkhand Staff Selection Commission',NULL,'Third-shift examination cancelled by notification after leak allegations and demonstrations.',31,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(66,23,'FIR_REGISTERED','2022-04-09','CID, Karnataka Police',NULL,'Cases registered after OMR mismatch complaints; exam-centre and recruitment-cell links probed.',33,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(67,23,'ARREST','2022-04-20','CID, Karnataka',NULL,'15+ police personnel and centre operators arrested over the following months.',33,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(68,23,'ARREST','2022-07-04','CID, Karnataka',NULL,'ADGP heading the recruitment cell arrested on corruption, cheating and conspiracy charges.',32,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(69,23,'CHARGESHEET_FILED','2022-12-15','CID, Karnataka',NULL,'Charge sheet filed; central prosecution sanction under the PC Act later obtained.',32,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(70,23,'BAIL_GRANTED','2023-09-25','Karnataka High Court',NULL,'Bail to the IPS officer with conditions against intimidating junior investigators.',32,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(71,24,'FIR_REGISTERED','2019-07-20','Crime Branch, Kerala Police',NULL,'Case after the exam fraud surfaced during another investigation.',34,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(72,24,'ARREST','2019-08-01','Crime Branch, Kerala Police',NULL,'Accused incl. student leaders and a civil police officer arrested over the probe.',34,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(73,24,'CHARGESHEET_FILED','2023-04-05','Court of the Chief Judicial Magistrate',NULL,'Charge sheet against six under IPC and cyber-law provisions carrying up to seven years.',34,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(74,25,'FIR_REGISTERED','2021-12-10','Pune Police (Cyber)',NULL,'FIR in the MHADA paper leak; vendor firm named.',35,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(75,25,'ARREST','2021-12-11','Pune Police',NULL,'Director of the exam-conducting firm arrested; exams cancelled.',35,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(76,25,'OTHER_ORDER','2022-03-03','Maharashtra Housing Department',NULL,'Vendor firm blacklisted by government resolution.',35,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(77,26,'FIR_REGISTERED','2021-09-12','Jaipur Police (West)',NULL,'Case after a raid on the exam centre near Bhankrota during the exam.',37,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(78,26,'ARREST','2021-09-13','Jaipur Police',NULL,'Eight arrested incl. the invigilator, the candidate, solvers and intermediaries; Rs 10 lakh seized.',37,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(79,27,'FIR_REGISTERED','2024-05-05','Shastri Nagar PS, Patna','Patna FIR No. 358/2024','FIR under IPC 407/408/409/120B on a whistle-blower tip-off hours before the exam.',38,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(80,27,'ARREST','2024-05-06','Patna Police','Patna FIR No. 358/2024','13 persons including four examinees arrested in the first days; candidates confirmed receiving the paper in advance.',38,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(81,27,'CASE_TRANSFERRED','2024-05-11','Economic Offences Unit, Bihar Police','Patna FIR No. 358/2024 (transferred)','EOU took over after organised inter-state gangs were identified.',38,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(82,27,'CASE_TRANSFERRED','2024-06-23','Central Bureau of Investigation','CBI RC, June 2024','CBI registered its own case on a Ministry of Education reference and took over the multi-state probe.',38,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(83,27,'OTHER_ORDER','2024-07-23','Supreme Court of India','W.P. (C) No. 335 of 2024','Court recorded that 155 students directly benefited but found no systemic failure; nationwide re-examination declined.',38,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(84,27,'CHARGESHEET_FILED','2024-08-01','Spl. Judge (CBI), Patna','CBI charge sheet no. 1 (13 accused)','First charge sheet against 13 accused, including the centre city-coordinator and centre superintendent, under IPC and PC Act provisions.',39,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(85,27,'CHARGESHEET_FILED','2024-10-07','Spl. Judge (CBI), Patna','CBI charge sheet no. 3 (21 accused)','Third charge sheet against 21 accused; 5,500+ pages, 298 witnesses, 290 documents; 49 arrests in total.',40,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(86,27,'ARREST','2025-04-25','EOU / CBI, Patna','EOU/CBI cases, Patna','Long-absconding prime organiser of the leak network arrested; in judicial custody as of June 2025.',41,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(87,28,'FIR_REGISTERED','2026-05-08','Special Operations Group, Rajasthan Police',NULL,'SOG registered a case after finding striking similarities between circulated material and the actual paper.',42,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(88,28,'ARREST','2026-05-10','SOG, Jaipur / Maharashtra Police, Latur-Nashik',NULL,'Arrests in Jaipur; 45 persons detained in Latur and Nashik in connection with the circulation trail.',44,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(89,28,'CASE_TRANSFERRED','2026-05-12','Central Bureau of Investigation',NULL,'Centre handed the multi-state probe to the CBI on the day of cancellation.',43,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(90,28,'EXAM_CANCELLED','2026-05-12','National Testing Agency',NULL,'NTA cancelled the 3 May examination citing evidence of significant overlap with pre-circulated material.',42,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(91,28,'RE_EXAM_ORDERED','2026-05-15','National Testing Agency',NULL,'Re-examination announced for 21 June 2026; application fees to be refunded.',44,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(92,29,'ARREST','2023-07-16','Balasore Police, Odisha',NULL,'Nine persons arrested from a hotel at Digha (WB) with question papers, hours before the exam.',45,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(93,29,'ARREST','2023-07-27','Balasore Police, Odisha',NULL,'Eight more arrests incl. the alleged organiser and the printing-press helper who sourced the paper.',45,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(94,29,'EXAM_CANCELLED','2023-07-20','OSSC',NULL,'Examination cancelled by the commission after the leak was established.',45,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(95,30,'FIR_REGISTERED','2016-10-16','Punjab Vigilance Bureau',NULL,'Module busted that leaked the irrigation SDE paper; linked exams identified.',46,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(96,30,'ARREST','2016-10-20','Punjab Vigilance Bureau',NULL,'About 70 arrests incl. ~60 candidates and conduits from Bihar, Haryana and UP.',46,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(97,30,'EXAM_CANCELLED','2016-10-21','Government of Punjab',NULL,'Patwari recruitment exam scrapped on leak evidence.',46,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(98,30,'ARREST','2017-05-17','Punjab Vigilance Bureau, Mohali',NULL,'Alleged head of the module and a Delhi government-press employee arrested.',47,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(99,31,'EXAM_CANCELLED','2022-05-16','Rajasthan Police HQ',NULL,'14 May second-shift exam cancelled after the leak from the Jhotwara centre.',48,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(100,31,'FIR_REGISTERED','2022-05-16','Jaipur Police',NULL,'Case registered; centre superintendent alleged to have opened the paper before exam time.',48,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(101,31,'ARREST','2022-05-17','Jaipur Police / SOG',NULL,'Centre operators and associates held as the probe progressed.',49,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(102,32,'FIR_REGISTERED','2024-02-29','Special Operations Group, Rajasthan Police','SOG FIR, Jaipur (2024)','FIR after verification that a gang leaked and solved the 2021 SI paper for candidates.',52,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(103,32,'ARREST','2024-03-04','SOG, Rajasthan Police','SOG FIR, Jaipur (2024)','15 trainee SIs including the topper detained at the Rajasthan Police Academy and a training school.',52,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(104,32,'OTHER_ORDER','2025-08-28','Rajasthan High Court','S.B. judgment dt. 28.08.2025','Single bench cancelled the entire 2021 SI recruitment: ''fraud vitiates everything''.',50,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(105,32,'APPEAL_DECIDED','2026-04-04','Rajasthan High Court (Division Bench)','D.B. judgment dt. 04.04.2026','Cancellation upheld; appeals by the state and selected candidates dismissed; suo motu action against commission members set aside.',51,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(106,33,'ARREST','2021-09-26','Bikaner Police / Rajasthan Police',NULL,'Exam-day arrests after Bluetooth devices were recovered from candidates'' slippers.',56,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(107,33,'FIR_REGISTERED','2021-10-02','Special Operations Group, Rajasthan Police',NULL,'SOG constituted; probe established the paper was stolen from Shiksha Sankul on 24 September.',56,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(108,33,'EXAM_CANCELLED','2022-02-07','Government of Rajasthan',NULL,'REET Level-II examination cancelled.',56,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(109,33,'CHARGESHEET_FILED','2022-07-07','SOG report to Rajasthan High Court',NULL,'Final report: 71 arrested, challans against 65; board chairman''s role ruled out.',55,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(110,34,'ARREST','2022-12-24','Udaipur Police / Rajasthan SOG',NULL,'About 40 occupants of a bus caught solving the paper before the exam; dummy candidates among them.',57,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(111,34,'EXAM_CANCELLED','2022-12-24','RPSC / Government of Rajasthan',NULL,'General Knowledge paper of 24.12.2022 (9-11 am) cancelled; other papers proceeded.',58,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(112,34,'FIR_REGISTERED','2022-12-24','ATS / SOG, Rajasthan Police',NULL,'Case against the gang; Rs 5-8 lakh per candidate reportedly charged.',57,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(113,35,'EXAM_CANCELLED','2020-12-08','RSMSSB',NULL,'Exam cancelled over the leak; re-test ordered.',60,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(114,35,'FIR_REGISTERED','2020-12-09','Special Operations Group, Rajasthan Police',NULL,'SOG case into the organised leak network.',60,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(115,35,'ARREST','2024-02-29','SOG, Rajasthan Police',NULL,'Alleged leader of the JEn 2020 leak network arrested.',59,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(116,36,'FIR_REGISTERED','2026-01-19','Special Operations Group, Rajasthan Police',NULL,'Fresh FIR after evidence emerged that the September 2021 retest was also compromised.',61,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(117,36,'ARREST','2026-01-29','SOG, Jaipur',NULL,'A PWD assistant engineer posted in Barmer arrested; alleged beneficiary and participant in the leak racket.',61,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(118,37,'FIR_REGISTERED','2018-05-22','Central Bureau of Investigation',NULL,'FIR against 17 incl. 10 vendor employees and 7 candidates; searches at 12 locations.',62,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(119,37,'OTHER_ORDER','2018-08-31','Supreme Court of India',NULL,'Results of CGL and CHSL 2017 stayed; court orally observed the whole system appeared compromised.',63,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(120,37,'OTHER_ORDER','2019-04-01','Supreme Court of India',NULL,'SSC allowed to declare the results of the re-examination held in 2018.',63,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(121,37,'ARREST','2019-06-04','Central Bureau of Investigation',NULL,'Three accused arrested in the leak case.',63,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(122,38,'ARREST','2012-08-12','Tamil Nadu Police (Erode/Dharmapuri)',NULL,'Arrests incl. a candidate found with leaked questions before the exam; remands by an Erode court.',64,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(123,38,'EXAM_CANCELLED','2012-08-13','TNPSC',NULL,'Written test cancelled; re-exam announced.',64,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(124,38,'FIR_REGISTERED','2012-08-12','Tamil Nadu Police',NULL,'Cases registered as teams traced the leak network across districts.',64,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(125,39,'FIR_REGISTERED','2023-04-04','Warangal Police Commissionerate',NULL,'Case under Section 5, Telangana Public Examinations (Prevention of Malpractices) Act.',65,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(126,39,'ARREST','2023-04-05','Warangal Police',NULL,'Three arrested, including a minor who photographed the paper and forwarders in WhatsApp groups.',65,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(127,40,'FIR_REGISTERED','2023-03-13','Begum Bazar PS, Hyderabad',NULL,'Case on a complaint by a TSPSC assistant secretary; later moved to the Central Crime Station and an SIT.',66,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(128,40,'ARREST','2023-03-15','SIT, Hyderabad Police',NULL,'49 persons arrested over the following weeks; one accused abroad.',66,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(129,40,'CHARGESHEET_FILED','2023-06-09','Jurisdictional court, Hyderabad',NULL,'Preliminary charge sheet after CFSL forensics; total transactions around Rs 1.63 crore.',66,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(130,41,'EXAM_CANCELLED','2024-06-19','Ministry of Education',NULL,'Exam cancelled on I4C inputs that integrity ''may have been compromised''.',68,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(131,41,'FIR_REGISTERED','2024-06-20','Central Bureau of Investigation',NULL,'Probe handed to CBI; forensic experts later found the screenshot was doctored.',69,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(132,41,'CLOSURE_REPORT_FILED','2025-01-30','Special CBI Court, Delhi',NULL,'Closure report: no evidence of paper leak; doctored screenshot circulated by a student to make money.',68,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(133,42,'FIR_REGISTERED','2023-01-09','STF, Uttarakhand Police',NULL,'Case registered after information that the paper was provided to candidates before the exam.',70,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(134,42,'ARREST','2023-01-12','STF, Uttarakhand Police',NULL,'Four arrested including a UKPSC section officer and his wife; Rs 22.5 lakh recovered.',70,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(135,42,'EXAM_CANCELLED','2023-01-12','UKPSC',NULL,'Exam cancelled; fresh date announced.',70,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(136,43,'FIR_REGISTERED','2022-07-22','Raipur PS, Dehradun / STF Uttarakhand',NULL,'FIR on UKSSSC''s complaint; STF probe into the December 2021 exam.',71,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(137,43,'ARREST','2022-07-24','STF, Uttarakhand',NULL,'40+ arrests over weeks, including the alleged organiser of the leak network.',71,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(138,43,'ARREST','2025-09-20','Dehradun Police / STF',NULL,'Alleged organiser re-arrested with an aide a day before the UKSSSC Patwari recruitment exam.',72,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(139,43,'BAIL_GRANTED','2026-01-21','Uttarakhand High Court',NULL,'Bail granted in the 2025 case; court noted lack of direct evidence of fresh facilitation.',71,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(140,44,'EXAM_CANCELLED','2022-03-30','UP Board / Government of UP',NULL,'English exam cancelled in 24 affected districts.',73,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(141,44,'FIR_REGISTERED','2022-03-30','Ballia Police / STF UP',NULL,'FIRs registered; STF directed to probe; NSA invocation ordered.',73,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(142,44,'ARREST','2022-03-31','Ballia Police',NULL,'17 arrested including the district inspector of schools, who was also suspended.',73,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(143,45,'ARREST','2024-02-23','UP Police (districts)',NULL,'240+ persons arrested or detained across districts for adopting or planning unfair means.',74,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(144,45,'EXAM_CANCELLED','2024-02-24','Government of Uttar Pradesh',NULL,'Exam cancelled; recruitment board directed to register FIRs at the level where laxity occurred; STF probe ordered.',74,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(145,45,'FIR_REGISTERED','2024-02-25','UPPRPB / district police',NULL,'FIRs registered on government direction; STF took up the leak investigation.',75,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(146,46,'EXAM_CANCELLED','2024-03-02','Government of Uttar Pradesh / UPPSC',NULL,'Exam cancelled on the Commission''s report; STF probe ordered.',76,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(147,46,'FIR_REGISTERED','2024-03-04','Special Task Force, UP Police',NULL,'STF investigation registered to identify and prosecute individuals involved in the leak.',77,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(148,47,'EXAM_CANCELLED','2021-11-28','Government of Uttar Pradesh',NULL,'Exam cancelled on the morning of the test after the paper circulated on WhatsApp.',78,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(149,47,'ARREST','2021-11-28','STF, UP Police',NULL,'23 arrested on day one across districts.',78,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(150,47,'ARREST','2021-12-01','STF, UP Police',NULL,'Senior exam-authority official responsible for printing arrangements arrested and suspended.',79,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(151,48,'FIR_REGISTERED','2013-07-08','Indore Police / STF Madhya Pradesh','STF Vyapam cases (2013)','Vyapam impersonation racket exposed via the July 2013 Indore arrests; STF constituted 26.08.2013.',82,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(152,48,'CASE_TRANSFERRED','2015-07-09','Supreme Court of India','W.P.(C) 372/2015','All Vyapam cases transferred to the CBI.',81,'2026-06-11 05:20:35');
INSERT INTO "legal_actions" VALUES(153,48,'CONVICTED','2022-09-29','Special Judge (CBI), Bhopal','Spl. Sessions (CBI) Bhopal, judgment dt. 29.09.2022','Five convicted under IPC 419/420/467/468/471 and the MP Recognized Examinations Act; 7 years RI and Rs 10,000 fine each.',80,'2026-06-11 05:20:35');
CREATE TABLE re_exams (
    id              INTEGER PRIMARY KEY,
    incident_id     INTEGER NOT NULL REFERENCES incidents(id),
    outcome         TEXT NOT NULL CHECK (outcome IN
                      ('exam_cancelled_full','exam_cancelled_partial','re_exam_ordered',
                       're_exam_held','result_withheld','result_released_unchanged',
                       'no_action_recorded','compensation_ordered','compensation_paid')),
    ordered_by      TEXT,
    order_date      TEXT,
    execution_date  TEXT,
    scope           TEXT,
    source_id       INTEGER REFERENCES sources(id)
);
INSERT INTO "re_exams" VALUES(1,1,'exam_cancelled_full','Supreme Court of India','2015-06-15',NULL,NULL,1);
INSERT INTO "re_exams" VALUES(2,1,'re_exam_held','Supreme Court of India','2015-06-15','2015-07-25','Re-test held nationwide on 25 July 2015.',1);
INSERT INTO "re_exams" VALUES(3,2,'re_exam_held','Indian Army',NULL,NULL,'Recruitment exam re-conducted later in 2021.',4);
INSERT INTO "re_exams" VALUES(4,3,'exam_cancelled_partial','SEBA','2023-03-12','2023-03-30','General Science paper re-conducted on 30 March 2023.',5);
INSERT INTO "re_exams" VALUES(5,4,'exam_cancelled_full','SLPRB','2020-09-20','2020-11-22','Re-test held on 22 November 2020.',6);
INSERT INTO "re_exams" VALUES(6,5,'exam_cancelled_full','CSBC','2023-10-03',NULL,NULL,7);
INSERT INTO "re_exams" VALUES(7,5,'re_exam_held','CSBC',NULL,NULL,'Re-examination conducted in August 2024.',8);
INSERT INTO "re_exams" VALUES(8,6,'exam_cancelled_full','BPSC','2022-05-08',NULL,NULL,9);
INSERT INTO "re_exams" VALUES(9,6,'re_exam_held','BPSC',NULL,'2022-09-30','Prelims re-conducted on 30 September 2022.',10);
INSERT INTO "re_exams" VALUES(10,7,'exam_cancelled_partial','BPSC','2024-12-16','2025-01-04','Re-test for the one affected centre held on 4 January 2025.',11);
INSERT INTO "re_exams" VALUES(11,8,'exam_cancelled_full','BPSC','2024-03-20',NULL,NULL,12);
INSERT INTO "re_exams" VALUES(12,8,'re_exam_held','BPSC','2024-03-20',NULL,'TRE-3.0 re-conducted in July 2024.',14);
INSERT INTO "re_exams" VALUES(13,9,'exam_cancelled_partial','BSSC','2022-12-27','2023-03-05','First shift re-conducted on 5 March 2023.',15);
INSERT INTO "re_exams" VALUES(14,10,'exam_cancelled_full','BSSC','2017-02-28',NULL,'Inter-level exam cancelled; re-conducted years later.',17);
INSERT INTO "re_exams" VALUES(15,11,'re_exam_held','CBSE','2018-03-30','2018-04-25','Class 12 Economics re-held nationwide; Class 10 Maths re-exam waived.',18);
INSERT INTO "re_exams" VALUES(16,13,'exam_cancelled_full','GPSSB','2023-01-29',NULL,NULL,21);
INSERT INTO "re_exams" VALUES(17,13,'re_exam_held','GPSSB','2023-01-29','2023-04-09','Re-exam held on 9 April 2023.',20);
INSERT INTO "re_exams" VALUES(18,14,'exam_cancelled_full','GSSSB','2021-12-21',NULL,'Re-exam conducted in 2022.',22);
INSERT INTO "re_exams" VALUES(19,15,'exam_cancelled_full','Government of Gujarat','2019-12-16',NULL,'Exam re-conducted later.',23);
INSERT INTO "re_exams" VALUES(20,16,'exam_cancelled_full','LRB','2018-12-02','2019-01-06','Re-test held on 6 January 2019.',24);
INSERT INTO "re_exams" VALUES(21,17,'exam_cancelled_full','HSSC','2021-01-17',NULL,NULL,25);
INSERT INTO "re_exams" VALUES(22,18,'exam_cancelled_full','Government of HP','2023-02-21',NULL,'Pending recruitment moved to HPPSC.',26);
INSERT INTO "re_exams" VALUES(23,19,'exam_cancelled_full','HSSC','2021-08-07',NULL,'Exam re-conducted later in 2021.',27);
INSERT INTO "re_exams" VALUES(24,20,'result_withheld','NTA','2021-09-10',NULL,'Results of suspect candidates withheld.',28);
INSERT INTO "re_exams" VALUES(25,21,'exam_cancelled_full','J&K Administration','2022-07-08',NULL,NULL,29);
INSERT INTO "re_exams" VALUES(26,21,'re_exam_held','JKSSB',NULL,NULL,'SI exam re-conducted in December 2022.',30);
INSERT INTO "re_exams" VALUES(27,22,'exam_cancelled_partial','JSSC','2024-01-28',NULL,'Third shift cancelled; exam re-conducted in September 2024.',31);
INSERT INTO "re_exams" VALUES(28,23,'exam_cancelled_full','Government of Karnataka','2022-04-29',NULL,'Re-examination ordered for the PSI recruitment.',33);
INSERT INTO "re_exams" VALUES(29,24,'result_withheld','Kerala PSC',NULL,NULL,'Fraudulent rank-list placements removed.',34);
INSERT INTO "re_exams" VALUES(30,25,'exam_cancelled_full','MHADA','2021-12-11',NULL,'Recruitment exams cancelled before conduct.',35);
INSERT INTO "re_exams" VALUES(31,26,'no_action_recorded',NULL,NULL,NULL,'Localised episode; national exam not cancelled.',37);
INSERT INTO "re_exams" VALUES(32,27,'re_exam_held','Supreme Court of India / NTA','2024-06-13','2024-06-23','Limited re-test for 1,563 grace-mark-affected candidates; nationwide re-exam declined by the Supreme Court on 23.07.2024.',38);
INSERT INTO "re_exams" VALUES(33,28,'exam_cancelled_full','National Testing Agency','2026-05-12',NULL,NULL,42);
INSERT INTO "re_exams" VALUES(34,28,'re_exam_ordered','National Testing Agency','2026-05-15','2026-06-21','Nationwide re-test scheduled for 21 June 2026.',44);
INSERT INTO "re_exams" VALUES(35,29,'exam_cancelled_full','OSSC','2023-07-20',NULL,NULL,45);
INSERT INTO "re_exams" VALUES(36,30,'exam_cancelled_full','Government of Punjab','2016-10-21',NULL,'Patwari exam scrapped; re-conduct followed.',46);
INSERT INTO "re_exams" VALUES(37,31,'exam_cancelled_partial','Rajasthan Police HQ','2022-05-16',NULL,'Cancelled shift re-conducted (July 2022).',48);
INSERT INTO "re_exams" VALUES(38,32,'exam_cancelled_full','Rajasthan High Court','2025-08-28',NULL,'Entire recruitment cancelled by court.',50);
INSERT INTO "re_exams" VALUES(39,33,'exam_cancelled_partial','Government of Rajasthan','2022-02-07',NULL,'Level-II cancelled; re-held in July 2022.',56);
INSERT INTO "re_exams" VALUES(40,34,'exam_cancelled_partial','RPSC','2022-12-24',NULL,'Cancelled GK paper re-conducted later (2023).',58);
INSERT INTO "re_exams" VALUES(41,35,'exam_cancelled_full','RSMSSB','2020-12-08',NULL,'Re-test held in September 2021 (itself later found compromised).',60);
INSERT INTO "re_exams" VALUES(42,37,'re_exam_held','SSC / Supreme Court of India','2018-08-31',NULL,'Tier-II re-examination held in 2018; results released April 2019.',63);
INSERT INTO "re_exams" VALUES(43,38,'exam_cancelled_full','TNPSC','2012-08-13',NULL,'Re-exam announced and held later.',64);
INSERT INTO "re_exams" VALUES(44,39,'no_action_recorded',NULL,NULL,NULL,'Exam not cancelled; circulation occurred after the start.',65);
INSERT INTO "re_exams" VALUES(45,40,'exam_cancelled_full','TSPSC','2023-03-22',NULL,'Affected exams (incl. AE/AEE) cancelled and re-conducted.',67);
INSERT INTO "re_exams" VALUES(46,41,'exam_cancelled_full','Ministry of Education','2024-06-19',NULL,NULL,68);
INSERT INTO "re_exams" VALUES(47,41,'re_exam_held','NTA',NULL,NULL,'Re-conducted in CBT mode in August–September 2024.',69);
INSERT INTO "re_exams" VALUES(48,42,'exam_cancelled_full','UKPSC','2023-01-12',NULL,NULL,70);
INSERT INTO "re_exams" VALUES(49,42,'re_exam_held','UKPSC','2023-01-12','2023-02-12','Re-exam held on 12 February 2023.',70);
INSERT INTO "re_exams" VALUES(50,43,'exam_cancelled_full','Government of Uttarakhand','2022-08-12',NULL,'Exam scrapped; affected recruitments shifted to UKPSC.',71);
INSERT INTO "re_exams" VALUES(51,44,'exam_cancelled_partial','UP Board','2022-03-30','2022-04-13','Re-exam in the 24 districts on 13 April 2022.',73);
INSERT INTO "re_exams" VALUES(52,45,'exam_cancelled_full','Government of Uttar Pradesh','2024-02-24',NULL,NULL,74);
INSERT INTO "re_exams" VALUES(53,45,'re_exam_held','Government of Uttar Pradesh','2024-02-24','2024-08-23','Re-examination conducted on 23–31 August 2024.',75);
INSERT INTO "re_exams" VALUES(54,46,'exam_cancelled_full','Government of Uttar Pradesh','2024-03-02',NULL,NULL,76);
INSERT INTO "re_exams" VALUES(55,46,'re_exam_held','UPPSC',NULL,NULL,'Re-examination conducted in July 2025.',77);
INSERT INTO "re_exams" VALUES(56,47,'exam_cancelled_full','Government of UP','2021-11-28',NULL,NULL,78);
INSERT INTO "re_exams" VALUES(57,47,'re_exam_held','Government of UP','2021-11-28','2022-01-23','Re-exam held on 23 January 2022.',79);
CREATE TABLE sources (
    id              INTEGER PRIMARY KEY,
    source_type     TEXT NOT NULL CHECK (source_type IN
                      ('court_order','fir_copy','chargesheet','gazette_notification',
                       'rti_reply','rti_no_reply','official_press_release','parliamentary_record',
                       'news_report','other_official_document')),
    title           TEXT NOT NULL,
    publisher       TEXT NOT NULL,
    document_number TEXT,
    document_date   TEXT,
    url             TEXT,
    archive_url     TEXT,
    local_file      TEXT,
    sha256          TEXT,
    tier            INTEGER NOT NULL CHECK (tier IN (1,2,3)),
    created_at      TEXT NOT NULL DEFAULT (datetime('now'))
);
INSERT INTO "sources" VALUES(1,'court_order','Record of proceedings, AIPMT 2015 answer-key leak matter','Supreme Court of India','W.P.(C) (2015), AIPMT leak ROP','2015-06-09','https://api.sci.gov.in/jonew/courtnic/rop/2015/15886/rop_293750.pdf',NULL,NULL,NULL,1,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(2,'news_report','AIPMT paper leak organiser held in Rohtak','The Tribune',NULL,'2015-06-20','https://www.tribuneindia.com/news/archive/crime/aipmt-paper-leak-mastermind-held-in-rohtak','https://web.archive.org/web/2/https://www.tribuneindia.com/news/archive/crime/aipmt-paper-leak-mastermind-held-in-rohtak',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(3,'news_report','AIPMT 2015 result delayed due to paper leak investigation','AskIITians (news)',NULL,'2015-06-10','https://www.askiitians.com/blog/aipmt-2015-result-june-12-delayed-due-paper-leak-investigation/','https://web.archive.org/web/2/https://www.askiitians.com/blog/aipmt-2015-result-june-12-delayed-due-paper-leak-investigation/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(4,'news_report','Army recruitment paper leak case: AFT quashes ''displeasure'' given to Lt Colonel','The Indian Express',NULL,'2024-03-30','https://indianexpress.com/article/cities/chandigarh/army-recruitment-paper-leak-case-aft-quashes-displeasure-lt-colonel-9241431/','https://web.archive.org/web/2/https://indianexpress.com/article/cities/chandigarh/army-recruitment-paper-leak-case-aft-quashes-displeasure-lt-colonel-9241431/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(5,'news_report','Assam HSLC exam 2023: police detain 22 persons in connection to question paper leak','The Times of India',NULL,'2023-03-14','https://timesofindia.indiatimes.com/education/news/assam-hslc-exam-2023-police-detain-22-persons-in-connection-to-question-paper-leak/articleshow/98624485.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/education/news/assam-hslc-exam-2023-police-detain-22-persons-in-connection-to-question-paper-leak/articleshow/98624485.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(6,'news_report','Assam police exam paper leak: services of consortium engaged in holding tests suspended','The Times of India',NULL,'2020-10-10','https://timesofindia.indiatimes.com/education/news/assam-police-exam-paper-leak-services-of-consortium-engaged-in-holding-tests-suspended/articleshow/78587167.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/education/news/assam-police-exam-paper-leak-services-of-consortium-engaged-in-holding-tests-suspended/articleshow/78587167.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(7,'official_press_release','CSBC notice dt. 03.10.2023: cancellation of written exam (Advt. 01/2023)','Central Selection Board of Constables',NULL,'2023-10-03','https://csbc.bihar.gov.in',NULL,NULL,NULL,1,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(8,'news_report','ED raids multiple states in 2023 Bihar constable recruitment scam probe','The Economic Times',NULL,'2025-06-19','https://economictimes.indiatimes.com/news/india/ed-raids-multiple-states-in-2023-bihar-constable-recruitment-scam-probe/printarticle/121950764.cms','https://web.archive.org/web/2/https://economictimes.indiatimes.com/news/india/ed-raids-multiple-states-in-2023-bihar-constable-recruitment-scam-probe/printarticle/121950764.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(9,'news_report','BPSC 67th paper leaked before exam, probe ordered','The Times of India',NULL,'2022-05-09','https://timesofindia.indiatimes.com/education/news/bpsc-67th-paper-leaked-before-exam-probe-ordered-by-bihar-public-service-commission/articleshow/91422914.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/education/news/bpsc-67th-paper-leaked-before-exam-probe-ordered-by-bihar-public-service-commission/articleshow/91422914.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(10,'news_report','BPSC question paper leak: BDO, invigilator among four arrested','Careers360',NULL,'2022-05-11','https://news.careers360.com/bpsc-67th-question-paper-leak-bdo-college-invigilator-four-arrested-in-exam-paper-leak-case','https://web.archive.org/web/2/https://news.careers360.com/bpsc-67th-question-paper-leak-bdo-college-invigilator-four-arrested-in-exam-paper-leak-case',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(11,'news_report','BPSC 70th CCE: exam in Patna''s centre cancelled, re-exam in January','The Indian Express',NULL,'2024-12-17','https://indianexpress.com/article/education/bpsc-70th-cce-exam-in-patnas-centre-cancelled-re-exam-in-january-second-week-9729266','https://web.archive.org/web/2/https://indianexpress.com/article/education/bpsc-70th-cce-exam-in-patnas-centre-cancelled-re-exam-in-january-second-week-9729266',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(12,'official_press_release','BPSC notice: cancellation of TRE-3.0 examination of 15.03.2024','Bihar Public Service Commission',NULL,'2024-03-20',NULL,NULL,NULL,NULL,1,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(13,'news_report','BPSC TRE 3.0 exam cancelled for both shifts due to paper leak','India Today',NULL,'2024-03-20','https://www.indiatoday.in/education-today/news/story/bpsc-tre-30-exam-cancelled-due-to-paper-leak-new-exam-dates-soon-2517287-2024-03-20','https://web.archive.org/web/2/https://www.indiatoday.in/education-today/news/story/bpsc-tre-30-exam-cancelled-due-to-paper-leak-new-exam-dates-soon-2517287-2024-03-20',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(14,'news_report','BPSC TRE 3.0 exam cancelled due to paper leak; re-exam dates announced soon','Careers360',NULL,'2024-03-20','https://news.careers360.com/bpsc-tre-30-exam-cancelled-due-paper-leak-re-exam-dates-announced-soon-latest-news','https://web.archive.org/web/2/https://news.careers360.com/bpsc-tre-30-exam-cancelled-due-paper-leak-re-exam-dates-announced-soon-latest-news',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(15,'news_report','BSSC cancels 1st phase exam after leaked paper matched original','The Times of India',NULL,'2022-12-27','https://timesofindia.indiatimes.com/city/patna/bssc-cancels-ist-phase-exam/articleshow/96531365.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/patna/bssc-cancels-ist-phase-exam/articleshow/96531365.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(16,'news_report','SC grants bail to IAS officer in BSSC job scam case','The Times of India',NULL,'2020-10-08','https://timesofindia.indiatimes.com/city/patna/sc-grants-bail-to-ias-officer-in-bssc-job-scam-case/articleshow/78540796.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/patna/sc-grants-bail-to-ias-officer-in-bssc-job-scam-case/articleshow/78540796.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(17,'news_report','Question leak: govt suspends former job panel chairman','The Times of India',NULL,'2017-02-26','https://timesofindia.indiatimes.com/city/patna/question-leak-govt-suspends-former-job-panel-chairman/articleshow/57339239.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/patna/question-leak-govt-suspends-former-job-panel-chairman/articleshow/57339239.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(18,'news_report','CBSE re-exam updates: 5 tutors, 18 students questioned by police','NDTV',NULL,'2018-03-30','https://www.ndtv.com/india-news/cbse-paper-leak-updates-5-tutors-18-students-questioned-by-police-1830522','https://web.archive.org/web/2/https://www.ndtv.com/india-news/cbse-paper-leak-updates-5-tutors-18-students-questioned-by-police-1830522',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(19,'news_report','Chhattisgarh civil services exam scam: CBI names 29 accused, final chargesheet filed','India Today',NULL,'2026-01-03','https://www.indiatoday.in/india/story/chhattisgarh-civil-services-exam-scam-cbi-names-29-accused-final-chargesheet-filed-cgpsc-2846038-2026-01-03','https://web.archive.org/web/2/https://www.indiatoday.in/india/story/chhattisgarh-civil-services-exam-scam-cbi-names-29-accused-final-chargesheet-filed-cgpsc-2846038-2026-01-03',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(20,'news_report','Junior clerk recruitment exam put off, 16 arrested in Gujarat','The Times of India',NULL,'2023-01-30','https://timesofindia.indiatimes.com/city/ahmedabad/junior-clerk-recruitment-exam-put-off-16-arrested-in-gujarat/articleshow/97428510.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/ahmedabad/junior-clerk-recruitment-exam-put-off-16-arrested-in-gujarat/articleshow/97428510.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(21,'news_report','Gujarat: another paper leaked, clerk recruitment exam cancelled','The New Indian Express',NULL,'2023-01-29','https://www.newindianexpress.com/india/2023/Jan/29/gujarat-another-paper-leaked-clerk-recruitment-exam-cancelled-2542443.html','https://web.archive.org/web/2/https://www.newindianexpress.com/india/2023/Jan/29/gujarat-another-paper-leaked-clerk-recruitment-exam-cancelled-2542443.html',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(22,'news_report','Gujarat head clerk exam cancelled after paper leak, re-exam next year','The Indian Express',NULL,'2021-12-21','https://indianexpress.com/article/cities/ahmedabad/gujarat-government-cancels-head-clerk-exam-after-paper-gets-leaked-7683520/','https://web.archive.org/web/2/https://indianexpress.com/article/cities/ahmedabad/gujarat-government-cancels-head-clerk-exam-after-paper-gets-leaked-7683520/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(23,'news_report','Gujarat govt cancels recruitment exam after ''paper leak'' protests','The Indian Express',NULL,'2019-12-17','https://indianexpress.com/article/education/gujarat-govt-cancels-recruitment-exam-after-paper-leak-protests-6170877/','https://web.archive.org/web/2/https://indianexpress.com/article/education/gujarat-govt-cancels-recruitment-exam-after-paper-leak-protests-6170877/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(24,'news_report','Gujarat govt puts off Dec 23 forest guard examination (recounts LRD cancellation)','Business Standard / PTI',NULL,'2018-12-10','https://www.business-standard.com/article/pti-stories/gujarat-govt-puts-off-dec-23-forest-guard-examination-118121001029_1.html','https://web.archive.org/web/2/https://www.business-standard.com/article/pti-stories/gujarat-govt-puts-off-dec-23-forest-guard-examination-118121001029_1.html',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(25,'news_report','Paper leak: HSSC cancels Gram Sachiv examination; two more arrested in Hisar','The Tribune',NULL,'2021-01-17','https://www.tribuneindia.com/news/haryana/paper-leak-hssc-cancels-gram-sachiv-examination-two-more-arrested-in-hisar-199422/','https://web.archive.org/web/2/https://www.tribuneindia.com/news/haryana/paper-leak-hssc-cancels-gram-sachiv-examination-two-more-arrested-in-hisar-199422/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(26,'news_report','Himachal government dissolves HPSSC after paper leak case','Hindustan Times',NULL,'2023-02-22','https://www.hindustantimes.com/education/news/himachal-government-dissolves-hpssc-after-paper-leak-case-101677055937638.html','https://web.archive.org/web/2/https://www.hindustantimes.com/education/news/himachal-government-dissolves-hpssc-after-paper-leak-case-101677055937638.html',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(27,'news_report','In paper that got leaked: Haryana Police arrest seven more, total 14','The Indian Express',NULL,'2021-08-10','https://indianexpress.com/article/cities/chandigarh/in-paper-that-got-leaked-constable-aspirants-asked-to-identify-cow-buffalo-families-fodder-quantity-7446541/','https://web.archive.org/web/2/https://indianexpress.com/article/cities/chandigarh/in-paper-that-got-leaked-constable-aspirants-asked-to-identify-cow-buffalo-families-fodder-quantity-7446541/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(28,'news_report','CBI files FIR against private education firm for manipulating JEE Mains exam','The Times of India',NULL,'2021-09-02','https://timesofindia.indiatimes.com/city/delhi/cbi-files-fir-against-private-education-firm-for-manipulating-jee-mains-exam-searches-on-at-20-locations/articleshow/85875486.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/delhi/cbi-files-fir-against-private-education-firm-for-manipulating-jee-mains-exam-searches-on-at-20-locations/articleshow/85875486.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(29,'news_report','ED gets 7-day remand of alleged organiser in 2022 JKSSB SI paper leak case','The Economic Times',NULL,'2024-06-25','https://economictimes.indiatimes.com/news/india/ed-gets-7-day-remand-of-kingpin-in-2022-jkssb-si-paper-leak-case/articleshow/111258034.cms','https://web.archive.org/web/2/https://economictimes.indiatimes.com/news/india/ed-gets-7-day-remand-of-kingpin-in-2022-jkssb-si-paper-leak-case/articleshow/111258034.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(30,'news_report','ED arrests Haryana man in J&K paper leak case','The Times of India',NULL,'2024-07-12','https://timesofindia.indiatimes.com/city/jammu/ed-arrests-haryana-man-in-jk-paper-leak-case/articleshow/111673810.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/jammu/ed-arrests-haryana-man-in-jk-paper-leak-case/articleshow/111673810.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(31,'news_report','JSSC CGL paper leak sparks controversy: third shift General Knowledge exam cancelled','The Times of India',NULL,'2024-01-29','https://timesofindia.indiatimes.com/education/news/jssc-cgl-paper-leak-sparks-controversy-third-shift-general-knowledge-exam-cancelled-new-dates-soon/articleshow/107267078.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/education/news/jssc-cgl-paper-leak-sparks-controversy-third-shift-general-knowledge-exam-cancelled-new-dates-soon/articleshow/107267078.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(32,'news_report','Karnataka High Court grants bail to IPS officer arrested in police recruitment scam','The Indian Express',NULL,'2023-09-25','https://indianexpress.com/article/cities/bangalore/karnataka-high-court-grants-bail-to-ips-officer-arrested-in-police-recruitment-scam-8955577/','https://web.archive.org/web/2/https://indianexpress.com/article/cities/bangalore/karnataka-high-court-grants-bail-to-ips-officer-arrested-in-police-recruitment-scam-8955577/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(33,'news_report','Karnataka PSI scam: ADGP arrest, explained','The Indian Express',NULL,'2022-07-06','https://indianexpress.com/article/explained/karnataka-psi-scam-adgp-arrest-explained-8010986/','https://web.archive.org/web/2/https://indianexpress.com/article/explained/karnataka-psi-scam-adgp-arrest-explained-8010986/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(34,'news_report','PSC question paper leak: chargesheet against 6, including SFI activists','Onmanorama',NULL,'2023-04-05','https://www.onmanorama.com/news/kerala/2023/04/05/psc-question-paper-leak-chargesheet-against-six-including-sfi-activists.html','https://web.archive.org/web/2/https://www.onmanorama.com/news/kerala/2023/04/05/psc-question-paper-leak-chargesheet-against-six-including-sfi-activists.html',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(35,'news_report','Housing dept blacklists software firm after MHADA question paper leak','The Indian Express',NULL,'2022-03-03','https://indianexpress.com/article/cities/mumbai/mhada-question-paper-leak-housing-dept-blacklists-software-firm-7799802/','https://web.archive.org/web/2/https://indianexpress.com/article/cities/mumbai/mhada-question-paper-leak-housing-dept-blacklists-software-firm-7799802/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(36,'news_report','MSCE commissioner suspended for TET 2020 results scam','EducationWorld',NULL,'2021-12-22','https://educationworld.in/msce-commissioner-suspended-for-tet-2020-results-scam/','https://web.archive.org/web/2/https://educationworld.in/msce-commissioner-suspended-for-tet-2020-results-scam/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(37,'news_report','Jaipur cops arrest 8 for leaking NEET exam paper','The Times of India',NULL,'2021-09-14','https://timesofindia.indiatimes.com/city/jaipur/city-cops-arrest-8-for-leaking-neet-exam-paper/articleshow/86183586.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/jaipur/city-cops-arrest-8-for-leaking-neet-exam-paper/articleshow/86183586.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(38,'court_order','Judgment, Vanshika Yadav v. Union of India & Ors. (NEET-UG 2024)','Supreme Court of India','W.P. (C) No. 335 of 2024','2024-08-02',NULL,NULL,NULL,NULL,1,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(39,'official_press_release','CBI press release: charge sheet filed in NEET (UG) 2024 paper leak case','Central Bureau of Investigation',NULL,'2024-08-01',NULL,NULL,NULL,NULL,1,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(40,'news_report','NEET UG-2024 paper leak case: CBI files third chargesheet against 21 accused','ANI',NULL,'2024-10-07','https://www.aninews.in/news/national/general-news/neet-ug-2024-paper-leak-case-cbi-files-third-chargesheet-against-21-accused20241007231215/','https://web.archive.org/web/2/https://www.aninews.in/news/national/general-news/neet-ug-2024-paper-leak-case-cbi-files-third-chargesheet-against-21-accused20241007231215/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(41,'news_report','ED raids multiple states in 2023 Bihar constable recruitment scam probe','The Economic Times',NULL,'2025-06-19','https://economictimes.indiatimes.com/news/india/ed-raids-multiple-states-in-2023-bihar-constable-recruitment-scam-probe/printarticle/121950764.cms','https://web.archive.org/web/2/https://economictimes.indiatimes.com/news/india/ed-raids-multiple-states-in-2023-bihar-constable-recruitment-scam-probe/printarticle/121950764.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(42,'news_report','''Over 100 matching questions'': Rajasthan ''guess paper'' clue blows open NEET-UG 2026 scandal','The Times of India',NULL,'2026-05-12','https://timesofindia.indiatimes.com/city/delhi/guess-paper-with-over-100-matching-questions-how-rajasthan-clue-led-to-cancellation-of-neet-ug-2026-exam-complete-timeline/amp_articleshow/131032763.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/delhi/guess-paper-with-over-100-matching-questions-how-rajasthan-clue-led-to-cancellation-of-neet-ug-2026-exam-complete-timeline/amp_articleshow/131032763.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(43,'news_report','NEET-UG 2026 cancelled, govt orders CBI inquiry into allegations','Hindustan Times',NULL,'2026-05-12','https://www.hindustantimes.com/education/news/neetug-2026-cancelled-govt-orders-cbi-inquiry-into-allegations-101778569755695.html','https://web.archive.org/web/2/https://www.hindustantimes.com/education/news/neetug-2026-cancelled-govt-orders-cbi-inquiry-into-allegations-101778569755695.html',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(44,'news_report','NEET-UG 2026: CBI probe, arrests, re-exam updates','India Today',NULL,'2026-05-18','https://www.indiatoday.in/education-today/news/story/neet-ug-2026-live-cbi-probe-arrests-re-exam-updates-and-all-latest-developments-2913323-2026-05-18','https://web.archive.org/web/2/https://www.indiatoday.in/education-today/news/story/neet-ug-2026-live-cbi-probe-arrests-re-exam-updates-and-all-latest-developments-2913323-2026-05-18',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(45,'news_report','OSSC exam paper leak: Odisha police arrest alleged organiser, 7 others','The Indian Express',NULL,'2023-07-27','https://indianexpress.com/article/india/ossc-exam-paper-leak-odisha-police-arrest-alleged-mastermind-8863749/','https://web.archive.org/web/2/https://indianexpress.com/article/india/ossc-exam-paper-leak-odisha-police-arrest-alleged-mastermind-8863749/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(46,'news_report','Trusted, tested. Failed — Punjab recruitment exam leaks','The Tribune',NULL,'2016-10-23','https://www.tribuneindia.com/news/archive/perspective/trusted-tested-failed-313409/','https://web.archive.org/web/2/https://www.tribuneindia.com/news/archive/perspective/trusted-tested-failed-313409/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(47,'news_report','2015 paper leak scam organiser in vigilance bureau of Punjab net','The Times of India',NULL,'2017-05-18','https://timesofindia.indiatimes.com/city/chandigarh/2015-paper-leak-scam-mastermind-in-vigilance-bureau-of-punjab-net/articleshow/58727398.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/chandigarh/2015-paper-leak-scam-mastermind-in-vigilance-bureau-of-punjab-net/articleshow/58727398.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(48,'news_report','Rajasthan constable exam cancelled due to paper leak, to be reconducted','BYJU''S Exam Prep (news)',NULL,'2022-05-18','https://byjus.com/govt-exams/rajasthan-constable-exam-canceled-due-to-paper-leak-likely-to-be-reconducted/','https://web.archive.org/web/2/https://byjus.com/govt-exams/rajasthan-constable-exam-canceled-due-to-paper-leak-likely-to-be-reconducted/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(49,'news_report','All papers of Rajasthan Police constable recruitment exam leaked: MP''s claim','ThePrint',NULL,'2022-05-17','https://theprint.in/india/all-papers-of-rajasthan-police-constable-recruitment-exam-leaked-bjp-mp-meena/961','https://web.archive.org/web/2/https://theprint.in/india/all-papers-of-rajasthan-police-constable-recruitment-exam-leaked-bjp-mp-meena/961',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(50,'court_order','Judgment cancelling SI Recruitment 2021 (single bench, Jain J.)','Rajasthan High Court','S.B. Civil Writs (SI Recruitment 2021), judgment dt. 28.08.2025','2025-08-28',NULL,NULL,NULL,NULL,1,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(51,'court_order','Division bench judgment upholding cancellation','Rajasthan High Court','D.B. Special Appeals (SI Recruitment 2021), judgment dt. 04.04.2026','2026-04-04',NULL,NULL,NULL,NULL,1,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(52,'news_report','15 trainee Rajasthan police sub-inspectors detained in recruitment exam scam','The Times of India',NULL,'2024-03-04','https://timesofindia.indiatimes.com/city/jaipur/15-trainee-rajasthan-sis-detained-in-recruitment-exam-scam/articleshow/108221625.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/jaipur/15-trainee-rajasthan-sis-detained-in-recruitment-exam-scam/articleshow/108221625.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(53,'news_report','Rajasthan HC cancels 2021 SI recruitment exam over paper leak — ''fraud vitiates everything''','The Indian Express',NULL,'2025-08-29','https://indianexpress.com/article/india/rajasthan-hc-2021-si-recruitment-exam-paper-leak-allegations-10216055/','https://web.archive.org/web/2/https://indianexpress.com/article/india/rajasthan-hc-2021-si-recruitment-exam-paper-leak-allegations-10216055/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(54,'news_report','Rajasthan High Court upholds cancellation of 2021 SI recruitment exam','The Times of India',NULL,'2026-04-04','https://timesofindia.indiatimes.com/legal/news/rajasthan-high-court-upholds-cancellation-of-2021-si-recruitment-exam/articleshow/130021701.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/legal/news/rajasthan-high-court-upholds-cancellation-of-2021-si-recruitment-exam/articleshow/130021701.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(55,'news_report','2021 REET leak case: final hearing in Rajasthan High Court','The Times of India',NULL,'2022-07-08','https://timesofindia.indiatimes.com/city/jaipur/2021-reet-leak-case-final-hearing-in-rajasthan-high-court-on-july-25/articleshow/92739405.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/jaipur/2021-reet-leak-case-final-hearing-in-rajasthan-high-court-on-july-25/articleshow/92739405.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(56,'news_report','REET 2021 paper leak row: all you need to know','The Indian Express',NULL,'2022-02-16','https://indianexpress.com/article/jobs/reet-2021-paper-leak-row-all-you-need-to-know-7775251/','https://web.archive.org/web/2/https://indianexpress.com/article/jobs/reet-2021-paper-leak-row-all-you-need-to-know-7775251/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(57,'news_report','Rajasthan PSC paper leak: 40 caught writing answers in bus before exam','The New Indian Express',NULL,'2022-12-24','https://www.newindianexpress.com/india/2022/Dec/24/rajasthan-psc-paper-leak-40-caught-writing-answers-in-bus-before-exam-2531401.html','https://web.archive.org/web/2/https://www.newindianexpress.com/india/2022/Dec/24/rajasthan-psc-paper-leak-40-caught-writing-answers-in-bus-before-exam-2531401.html',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(58,'news_report','Exam for teachers'' recruitment in Rajasthan cancelled after paper leak','India Today',NULL,'2022-12-24','https://www.indiatoday.in/india/story/rpsc-rajasthan-paper-leak-second-grade-teacher-exam-cancel-2313000-2022-12-24','https://web.archive.org/web/2/https://www.indiatoday.in/india/story/rpsc-rajasthan-paper-leak-second-grade-teacher-exam-cancel-2313000-2022-12-24',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(59,'news_report','15 trainee Rajasthan SIs detained; JEn 2020 gang leader''s arrest disclosed','The Times of India',NULL,'2024-03-04','https://timesofindia.indiatimes.com/city/jaipur/15-trainee-rajasthan-sis-detained-in-recruitment-exam-scam/articleshow/108221625.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/jaipur/15-trainee-rajasthan-sis-detained-in-recruitment-exam-scam/articleshow/108221625.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(60,'news_report','Jr engineer retest: paper leaked a 2nd time, SOG arrests PWD official','The Times of India',NULL,'2026-01-30','https://timesofindia.indiatimes.com/city/jaipur/jr-engineer-retest-paper-leaked-a2nd-time-sog-arrests-pwd-official/articleshow/127785028.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/jaipur/jr-engineer-retest-paper-leaked-a2nd-time-sog-arrests-pwd-official/articleshow/127785028.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(61,'news_report','Jr engineer retest: paper leaked a 2nd time, SOG arrests PWD official','The Times of India',NULL,'2026-01-30','https://timesofindia.indiatimes.com/city/jaipur/jr-engineer-retest-paper-leaked-a2nd-time-sog-arrests-pwd-official/articleshow/127785028.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/jaipur/jr-engineer-retest-paper-leaked-a2nd-time-sog-arrests-pwd-official/articleshow/127785028.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(62,'news_report','CBI books 17 including Sify employees in SSC paper leak case','The Economic Times',NULL,'2018-05-23','https://economictimes.indiatimes.com/news/politics-and-nation/cbi-books-17-including-sify-employees-in-ssc-paper-leak-case/articleshow/64291923.cms','https://web.archive.org/web/2/https://economictimes.indiatimes.com/news/politics-and-nation/cbi-books-17-including-sify-employees-in-ssc-paper-leak-case/articleshow/64291923.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(63,'news_report','SSC paper leak case: Supreme Court directs CBI to file status report','NDTV',NULL,'2019-04-09','https://www.ndtv.com/india-news/ssc-paper-leak-case-supreme-court-directs-cbi-to-file-status-report-2020207','https://web.archive.org/web/2/https://www.ndtv.com/india-news/ssc-paper-leak-case-supreme-court-directs-cbi-to-file-status-report-2020207',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(64,'news_report','Tamil Nadu cancels govt exam after leak','The Times of India',NULL,'2012-08-14','https://timesofindia.indiatimes.com/city/chennai/tamil-nadu-cancels-govt-exam-after-leak/articleshow/15485647.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/chennai/tamil-nadu-cancels-govt-exam-after-leak/articleshow/15485647.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(65,'news_report','Telangana: SSC paper ''leaked'' on WhatsApp second day in row','The Times of India',NULL,'2023-04-05','https://timesofindia.indiatimes.com/city/hyderabad/telangana-ssc-paper-leaked-on-whatsapp-second-day-in-row/articleshow/99252408.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/hyderabad/telangana-ssc-paper-leaked-on-whatsapp-second-day-in-row/articleshow/99252408.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(66,'news_report','SIT files charge sheet in Telangana paper leak case','Hindustan Times',NULL,'2023-06-10','https://www.hindustantimes.com/india-news/hyderabad-police-file-charge-sheet-for-tspsc-exam-paper-leak-case-49-arrested-1-63-crore-involved-in-sale-of-papers-101686338468697.html','https://web.archive.org/web/2/https://www.hindustantimes.com/india-news/hyderabad-police-file-charge-sheet-for-tspsc-exam-paper-leak-case-49-arrested-1-63-crore-involved-in-sale-of-papers-101686338468697.html',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(67,'news_report','TSPSC paper leak: 49 arrested, money trail traced','The Indian Express',NULL,'2023-06-10','https://indianexpress.com/article/cities/hyderabad/tspsc-paper-leak-hyderabad-police-49-arrested-transactions-8654664/','https://web.archive.org/web/2/https://indianexpress.com/article/cities/hyderabad/tspsc-paper-leak-hyderabad-police-49-arrested-transactions-8654664/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(68,'news_report','CBI files closure report in UGC-NET paper leak case','The Economic Times (ET Education)',NULL,'2025-01-31','https://education.economictimes.indiatimes.com/news/industry/cbi-files-closure-report-in-ugc-net-paper-leak-case/117779022','https://web.archive.org/web/2/https://education.economictimes.indiatimes.com/news/industry/cbi-files-closure-report-in-ugc-net-paper-leak-case/117779022',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(69,'news_report','CBI closes probe in UGC-NET suspected paper leak case','Hindustan Times',NULL,'2025-01-30','https://www.hindustantimes.com/india-news/cbi-closes-probe-in-ugc-net-suspected-paper-leak-case-101738227353730.html','https://web.archive.org/web/2/https://www.hindustantimes.com/india-news/cbi-closes-probe-in-ugc-net-suspected-paper-leak-case-101738227353730.html',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(70,'news_report','UKPSC Patwari Lekhpal exam cancelled due to paper leak, new exam Feb 12','Times Now',NULL,'2023-01-13','https://www.timesnownews.com/jobs/ukpsc-paper-leak-2023-ukpsc-patwari-lekhpal-exam-cancelled-due-to-paper-leak-new-exam-to-be-held-feb-12-article-96968719','https://web.archive.org/web/2/https://www.timesnownews.com/jobs/ukpsc-paper-leak-2023-ukpsc-patwari-lekhpal-exam-cancelled-due-to-paper-leak-new-exam-to-be-held-feb-12-article-96968719',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(71,'news_report','HC grants bail to alleged organiser behind 2022 UKSSSC paper leak case','The Times of India',NULL,'2026-01-22','https://timesofindia.indiatimes.com/city/dehradun/hc-grants-bail-to-mastermind-behind-2022-uksssc-paper-leak-case/articleshow/127027810.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/dehradun/hc-grants-bail-to-mastermind-behind-2022-uksssc-paper-leak-case/articleshow/127027810.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(72,'news_report','Uttarakhand SSSC exam: paper leak accused, aide held','The Indian Express',NULL,'2025-09-21','https://indianexpress.com/article/india/uttarakhand-sssc-exam-today-paper-leak-accused-aide-held-for-promising-success-in-govt-job-test-demanding-rs-15-lakh-10262040/','https://web.archive.org/web/2/https://indianexpress.com/article/india/uttarakhand-sssc-exam-today-paper-leak-accused-aide-held-for-promising-success-in-govt-job-test-demanding-rs-15-lakh-10262040/',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(73,'news_report','UP Board: Class 12 English exam cancelled in 24 districts after question paper leak','Hindustan Times',NULL,'2022-03-31','https://www.hindustantimes.com/cities/lucknow-news/up-board-class-12-english-exam-cancelled-in-24-districts-after-question-paper-leak-ballia-dios-among-17-arrested-101648657015527.html','https://web.archive.org/web/2/https://www.hindustantimes.com/cities/lucknow-news/up-board-class-12-english-exam-cancelled-in-24-districts-after-question-paper-leak-ballia-dios-among-17-arrested-101648657015527.html',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(74,'news_report','UP cancels police constable recruitment exam, orders re-test in 6 months','NDTV',NULL,'2024-02-24','https://www.ndtv.com/india-news/up-cancels-police-constable-recruitment-exam-after-paper-leak-allegations-5118905','https://web.archive.org/web/2/https://www.ndtv.com/india-news/up-cancels-police-constable-recruitment-exam-after-paper-leak-allegations-5118905',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(75,'news_report','UP Police constable recruitment exam cancelled days after paper leak','India Today',NULL,'2024-02-24','https://www.indiatoday.in/education/story/uttar-pradesh-police-constable-recruitment-exam-cancelled-after-paper-leak-re-examination-in-6-months-2506566-2024-02-24','https://web.archive.org/web/2/https://www.indiatoday.in/education/story/uttar-pradesh-police-constable-recruitment-exam-cancelled-after-paper-leak-re-examination-in-6-months-2506566-2024-02-24',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(76,'news_report','UPPSC RO, ARO exam cancelled amidst leaks, CM orders probe','The Times of India',NULL,'2024-03-02','https://timesofindia.indiatimes.com/education/news/uppsc-ro-aro-exam-cancelled-amidst-leaks-yogi-adityanath-orders-probe/articleshow/108172953.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/education/news/uppsc-ro-aro-exam-cancelled-amidst-leaks-yogi-adityanath-orders-probe/articleshow/108172953.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(77,'news_report','UPPSC RO, ARO exams cancelled over alleged paper leak','Republic World',NULL,'2024-03-03','https://www.republicworld.com/education/uppsc-ro-aro-exams-cancelled-over-alleged-paper-leak-re-exam-to-be-held-in-august','https://web.archive.org/web/2/https://www.republicworld.com/education/uppsc-ro-aro-exams-cancelled-over-alleged-paper-leak-re-exam-to-be-held-in-august',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(78,'news_report','23 held in connection with paper leak of UPTET 2021 exam','The Times of India',NULL,'2021-11-28','https://timesofindia.indiatimes.com/education/news/23-held-in-connection-with-paper-leak-of-uptet-2021-exam/articleshow/87962059.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/education/news/23-held-in-connection-with-paper-leak-of-uptet-2021-exam/articleshow/87962059.cms',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(79,'news_report','UP STF arrests exam controller in UPTET paper leak case','India Today',NULL,'2021-12-01','https://www.indiatoday.in/education-today/story/up-stf-examination-controller-uptet-paper-leak-case-1883048-2021-12-01','https://web.archive.org/web/2/https://www.indiatoday.in/education-today/story/up-stf-examination-controller-uptet-paper-leak-case-1883048-2021-12-01',NULL,NULL,2,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(80,'court_order','Judgment, MP Police Constable Recruitment Test 2013 impersonation case','Special Judge (CBI), Bhopal','Spl. Sessions (CBI) Bhopal, judgment dt. 29.09.2022','2022-09-29',NULL,NULL,NULL,NULL,1,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(81,'court_order','Order transferring Vyapam cases to CBI','Supreme Court of India','W.P.(C) 372/2015, order dt. 09.07.2015','2015-07-09',NULL,NULL,NULL,NULL,1,'2026-06-11 05:20:35');
INSERT INTO "sources" VALUES(82,'news_report','Vyapam case: five get 7 years rigorous imprisonment for irregularities in 2013 cop recruitment test','The Times of India',NULL,'2022-09-30','https://timesofindia.indiatimes.com/city/bhopal/vyapam-case-five-get-7-years-rigorous-imprisonment-for-irregularities-in-2013-cop-recruitment-test/articleshow/94561429.cms','https://web.archive.org/web/2/https://timesofindia.indiatimes.com/city/bhopal/vyapam-case-five-get-7-years-rigorous-imprisonment-for-irregularities-in-2013-cop-recruitment-test/articleshow/94561429.cms',NULL,NULL,2,'2026-06-11 05:20:35');
CREATE TABLE status_log (
    id              INTEGER PRIMARY KEY,
    incident_id     INTEGER NOT NULL REFERENCES incidents(id),
    old_status      TEXT,
    new_status      TEXT NOT NULL,
    changed_at      TEXT NOT NULL DEFAULT (datetime('now')),
    changed_by      TEXT NOT NULL,
    reason          TEXT NOT NULL,
    source_id       INTEGER REFERENCES sources(id)
);
INSERT INTO "status_log" VALUES(1,1,NULL,'ALLEGED','2015-05-03','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(2,1,'ALLEGED','FIR_REGISTERED','2015-05-03','seed-import','Case after answer keys were found transmitted to mobile devices before the exam ended.',1);
INSERT INTO "status_log" VALUES(3,1,'FIR_REGISTERED','ARRESTS_MADE','2015-05-10','seed-import','12 accused and 25 candidates arrested in the first weeks, incl. two dentists and an MBBS student.',1);
INSERT INTO "status_log" VALUES(4,2,NULL,'ALLEGED','2021-02-28','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(5,2,'ALLEGED','FIR_REGISTERED','2021-03-05','seed-import','CBI case naming serving officers of the question-paper board and civilian intermediaries.',4);
INSERT INTO "status_log" VALUES(6,3,NULL,'ALLEGED','2023-03-12','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(7,3,'ALLEGED','ARRESTS_MADE','2023-03-14','seed-import','22 persons detained across six towns; CID questioned two senior board officials.',5);
INSERT INTO "status_log" VALUES(8,4,NULL,'ALLEGED','2020-09-20','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(9,4,'ALLEGED','FIR_REGISTERED','2020-09-21','seed-import','Cases registered; probe covered the exam-conducting consortium.',6);
INSERT INTO "status_log" VALUES(10,4,'FIR_REGISTERED','ARRESTS_MADE','2020-10-09','seed-import','37 arrested incl. a retired DIG and an expelled political leader.',6);
INSERT INTO "status_log" VALUES(11,5,NULL,'ALLEGED','2023-10-01','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(12,5,'ALLEGED','FIR_REGISTERED','2023-10-04','seed-import','EOU FIRs against the leak syndicate; probe identified a Kolkata press and a vendor firm in the chain.',8);
INSERT INTO "status_log" VALUES(13,5,'FIR_REGISTERED','ARRESTS_MADE','2023-10-31','seed-import','Seven private persons arrested, including three from West Bengal; gang head in judicial custody.',8);
INSERT INTO "status_log" VALUES(14,6,NULL,'ALLEGED','2022-05-08','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(15,6,'ALLEGED','FIR_REGISTERED','2022-05-09','seed-import','Probe ordered by BPSC chairman; case registered into the Telegram/WhatsApp circulation.',9);
INSERT INTO "status_log" VALUES(16,6,'FIR_REGISTERED','ARRESTS_MADE','2022-05-11','seed-import','Four arrested, including a BDO and a college invigilator linked to the Ara centre.',10);
INSERT INTO "status_log" VALUES(17,7,NULL,'ALLEGED','2024-12-13','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(18,7,'ALLEGED','FIR_REGISTERED','2024-12-15','seed-import','Two FIRs registered in connection with the disruption at the Bapu Pariksha Bhavan centre.',11);
INSERT INTO "status_log" VALUES(19,8,NULL,'ALLEGED','2024-03-15','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(20,8,'ALLEGED','ARRESTS_MADE','2024-03-15','seed-import','Raids at Hotel Kohinoor, Barahi (Hazaribagh); 270+ candidates and operators questioned; question-paper sets and answer keys recovered. 266 arrests by 20 March.',13);
INSERT INTO "status_log" VALUES(21,9,NULL,'ALLEGED','2022-12-24','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(22,9,'ALLEGED','FIR_REGISTERED','2022-12-24','seed-import','Case into circulation of the first-shift paper during the exam.',15);
INSERT INTO "status_log" VALUES(23,9,'FIR_REGISTERED','ARRESTS_MADE','2023-01-05','seed-import','Arrests in the circulation probe; protesting aspirants also detained separately.',15);
INSERT INTO "status_log" VALUES(24,10,NULL,'ALLEGED','2017-02-08','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(25,10,'ALLEGED','FIR_REGISTERED','2017-02-08','seed-import','FIR after admit cards and documents were recovered from the commission secretary''s residence.',16);
INSERT INTO "status_log" VALUES(26,10,'FIR_REGISTERED','ARRESTS_MADE','2017-02-24','seed-import','Commission chairman (IAS) arrested from Hazaribagh; secretary also arrested; chairman suspended.',17);
INSERT INTO "status_log" VALUES(27,10,'ARRESTS_MADE','CHARGESHEET_FILED','2017-08-20','seed-import','Charge sheet filed (recorded in the Supreme Court''s 2020 bail order).',16);
INSERT INTO "status_log" VALUES(28,11,NULL,'ALLEGED','2018-03-28','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(29,11,'ALLEGED','FIR_REGISTERED','2018-03-28','seed-import','Two FIRs over the Economics and Mathematics leaks; SIT questioning of students and tutors.',18);
INSERT INTO "status_log" VALUES(30,11,'FIR_REGISTERED','ARRESTS_MADE','2018-04-01','seed-import','Two schoolteachers and a private tutor arrested in the Economics leak.',18);
INSERT INTO "status_log" VALUES(31,12,NULL,'ALLEGED','2024-07-15','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(32,12,'ALLEGED','FIR_REGISTERED','2024-07-15','seed-import','CBI registered the case on the state government''s reference alleging manipulation of the 2021 recruitment.',19);
INSERT INTO "status_log" VALUES(33,12,'FIR_REGISTERED','ARRESTS_MADE','2024-11-18','seed-import','Former commission chairman and a businessman among those arrested as the probe progressed.',19);
INSERT INTO "status_log" VALUES(34,12,'ARRESTS_MADE','CHARGESHEET_FILED','2026-01-02','seed-import','Final charge sheet (~400 pages) naming 29 accused; 12 in custody, one absconding.',19);
INSERT INTO "status_log" VALUES(35,13,NULL,'ALLEGED','2023-01-29','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(36,13,'ALLEGED','ARRESTS_MADE','2023-01-28','seed-import','15-16 persons caught with the paper, incl. coaching operators; printing-press worker from Odisha identified as the source.',20);
INSERT INTO "status_log" VALUES(37,14,NULL,'ALLEGED','2021-12-13','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(38,14,'ALLEGED','FIR_REGISTERED','2021-12-13','seed-import','Case registered after evidence the paper circulated the night before the exam.',22);
INSERT INTO "status_log" VALUES(39,14,'FIR_REGISTERED','ARRESTS_MADE','2021-12-14','seed-import','Eight sellers of the leaked paper arrested in Sabarkantha, plus a printing-press staffer.',22);
INSERT INTO "status_log" VALUES(40,15,NULL,'ALLEGED','2019-11-17','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(41,16,NULL,'ALLEGED','2018-12-02','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(42,16,'ALLEGED','ARRESTS_MADE','2018-12-09','seed-import','13 arrested in connection with the leak.',24);
INSERT INTO "status_log" VALUES(43,17,NULL,'ALLEGED','2021-01-11','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(44,17,'ALLEGED','FIR_REGISTERED','2021-01-11','seed-import','Case against the answer-key distribution racket.',25);
INSERT INTO "status_log" VALUES(45,17,'FIR_REGISTERED','ARRESTS_MADE','2021-01-17','seed-import','18 arrested, incl. the exam observer who photographed the paper.',25);
INSERT INTO "status_log" VALUES(46,18,NULL,'ALLEGED','2022-12-23','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(47,18,'ALLEGED','FIR_REGISTERED','2022-12-23','seed-import','Trap and case after the paper was offered for sale before the exam.',26);
INSERT INTO "status_log" VALUES(48,18,'FIR_REGISTERED','ARRESTS_MADE','2022-12-24','seed-import','A commission staffer and associates held; electronic devices sent to forensics.',26);
INSERT INTO "status_log" VALUES(49,18,'ARRESTS_MADE','CHARGESHEET_FILED','2023-02-21','seed-import','First charge sheet filed the day the state dissolved the commission.',26);
INSERT INTO "status_log" VALUES(50,19,NULL,'ALLEGED','2021-08-07','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(51,19,'ALLEGED','FIR_REGISTERED','2021-08-07','seed-import','Multiple FIRs; HSSC chief sought a DGP-level probe.',27);
INSERT INTO "status_log" VALUES(52,19,'FIR_REGISTERED','ARRESTS_MADE','2021-08-09','seed-import','14 arrested incl. a coaching operator; answer key recovered.',27);
INSERT INTO "status_log" VALUES(53,20,NULL,'ALLEGED','2021-09-02','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(54,20,'ALLEGED','FIR_REGISTERED','2021-09-01','seed-import','FIR against the firm, its directors, touts and centre staff for remote-access manipulation.',28);
INSERT INTO "status_log" VALUES(55,20,'FIR_REGISTERED','ARRESTS_MADE','2021-09-03','seed-import','Seven arrested, incl. directors and staff; searches at 20 locations.',28);
INSERT INTO "status_log" VALUES(56,21,NULL,'ALLEGED','2022-06-10','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(57,21,'ALLEGED','CHARGESHEET_FILED','2022-11-12','seed-import','Charge sheet against 33 accused.',29);
INSERT INTO "status_log" VALUES(58,22,NULL,'ALLEGED','2024-01-28','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(59,23,NULL,'ALLEGED','2022-04-09','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(60,23,'ALLEGED','FIR_REGISTERED','2022-04-09','seed-import','Cases registered after OMR mismatch complaints; exam-centre and recruitment-cell links probed.',33);
INSERT INTO "status_log" VALUES(61,23,'FIR_REGISTERED','ARRESTS_MADE','2022-04-20','seed-import','15+ police personnel and centre operators arrested over the following months.',33);
INSERT INTO "status_log" VALUES(62,23,'ARRESTS_MADE','CHARGESHEET_FILED','2022-12-15','seed-import','Charge sheet filed; central prosecution sanction under the PC Act later obtained.',32);
INSERT INTO "status_log" VALUES(63,24,NULL,'ALLEGED','2019-07-15','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(64,24,'ALLEGED','FIR_REGISTERED','2019-07-20','seed-import','Case after the exam fraud surfaced during another investigation.',34);
INSERT INTO "status_log" VALUES(65,24,'FIR_REGISTERED','ARRESTS_MADE','2019-08-01','seed-import','Accused incl. student leaders and a civil police officer arrested over the probe.',34);
INSERT INTO "status_log" VALUES(66,24,'ARRESTS_MADE','CHARGESHEET_FILED','2023-04-05','seed-import','Charge sheet against six under IPC and cyber-law provisions carrying up to seven years.',34);
INSERT INTO "status_log" VALUES(67,25,NULL,'ALLEGED','2021-12-11','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(68,25,'ALLEGED','FIR_REGISTERED','2021-12-10','seed-import','FIR in the MHADA paper leak; vendor firm named.',35);
INSERT INTO "status_log" VALUES(69,25,'FIR_REGISTERED','ARRESTS_MADE','2021-12-11','seed-import','Director of the exam-conducting firm arrested; exams cancelled.',35);
INSERT INTO "status_log" VALUES(70,26,NULL,'ALLEGED','2021-09-13','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(71,26,'ALLEGED','FIR_REGISTERED','2021-09-12','seed-import','Case after a raid on the exam centre near Bhankrota during the exam.',37);
INSERT INTO "status_log" VALUES(72,26,'FIR_REGISTERED','ARRESTS_MADE','2021-09-13','seed-import','Eight arrested incl. the invigilator, the candidate, solvers and intermediaries; Rs 10 lakh seized.',37);
INSERT INTO "status_log" VALUES(73,27,NULL,'ALLEGED','2024-05-05','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(74,27,'ALLEGED','FIR_REGISTERED','2024-05-05','seed-import','FIR under IPC 407/408/409/120B on a whistle-blower tip-off hours before the exam.',38);
INSERT INTO "status_log" VALUES(75,27,'FIR_REGISTERED','ARRESTS_MADE','2024-05-06','seed-import','13 persons including four examinees arrested in the first days; candidates confirmed receiving the paper in advance.',38);
INSERT INTO "status_log" VALUES(76,27,'ARRESTS_MADE','CHARGESHEET_FILED','2024-08-01','seed-import','First charge sheet against 13 accused, including the centre city-coordinator and centre superintendent, under IPC and PC Act provisions.',39);
INSERT INTO "status_log" VALUES(77,28,NULL,'ALLEGED','2026-05-04','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(78,28,'ALLEGED','FIR_REGISTERED','2026-05-08','seed-import','SOG registered a case after finding striking similarities between circulated material and the actual paper.',42);
INSERT INTO "status_log" VALUES(79,28,'FIR_REGISTERED','ARRESTS_MADE','2026-05-10','seed-import','Arrests in Jaipur; 45 persons detained in Latur and Nashik in connection with the circulation trail.',44);
INSERT INTO "status_log" VALUES(80,29,NULL,'ALLEGED','2023-07-16','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(81,29,'ALLEGED','ARRESTS_MADE','2023-07-16','seed-import','Nine persons arrested from a hotel at Digha (WB) with question papers, hours before the exam.',45);
INSERT INTO "status_log" VALUES(82,30,NULL,'ALLEGED','2016-10-16','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(83,30,'ALLEGED','FIR_REGISTERED','2016-10-16','seed-import','Module busted that leaked the irrigation SDE paper; linked exams identified.',46);
INSERT INTO "status_log" VALUES(84,30,'FIR_REGISTERED','ARRESTS_MADE','2016-10-20','seed-import','About 70 arrests incl. ~60 candidates and conduits from Bihar, Haryana and UP.',46);
INSERT INTO "status_log" VALUES(85,31,NULL,'ALLEGED','2022-05-15','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(86,31,'ALLEGED','FIR_REGISTERED','2022-05-16','seed-import','Case registered; centre superintendent alleged to have opened the paper before exam time.',48);
INSERT INTO "status_log" VALUES(87,31,'FIR_REGISTERED','ARRESTS_MADE','2022-05-17','seed-import','Centre operators and associates held as the probe progressed.',49);
INSERT INTO "status_log" VALUES(88,32,NULL,'ALLEGED','2024-03-04','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(89,32,'ALLEGED','FIR_REGISTERED','2024-02-29','seed-import','FIR after verification that a gang leaked and solved the 2021 SI paper for candidates.',52);
INSERT INTO "status_log" VALUES(90,32,'FIR_REGISTERED','ARRESTS_MADE','2024-03-04','seed-import','15 trainee SIs including the topper detained at the Rajasthan Police Academy and a training school.',52);
INSERT INTO "status_log" VALUES(91,33,NULL,'ALLEGED','2021-09-26','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(92,33,'ALLEGED','ARRESTS_MADE','2021-09-26','seed-import','Exam-day arrests after Bluetooth devices were recovered from candidates'' slippers.',56);
INSERT INTO "status_log" VALUES(93,33,'ARRESTS_MADE','CHARGESHEET_FILED','2022-07-07','seed-import','Final report: 71 arrested, challans against 65; board chairman''s role ruled out.',55);
INSERT INTO "status_log" VALUES(94,34,NULL,'ALLEGED','2022-12-24','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(95,34,'ALLEGED','ARRESTS_MADE','2022-12-24','seed-import','About 40 occupants of a bus caught solving the paper before the exam; dummy candidates among them.',57);
INSERT INTO "status_log" VALUES(96,35,NULL,'ALLEGED','2020-12-08','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(97,35,'ALLEGED','FIR_REGISTERED','2020-12-09','seed-import','SOG case into the organised leak network.',60);
INSERT INTO "status_log" VALUES(98,35,'FIR_REGISTERED','ARRESTS_MADE','2024-02-29','seed-import','Alleged leader of the JEn 2020 leak network arrested.',59);
INSERT INTO "status_log" VALUES(99,36,NULL,'ALLEGED','2026-01-19','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(100,36,'ALLEGED','FIR_REGISTERED','2026-01-19','seed-import','Fresh FIR after evidence emerged that the September 2021 retest was also compromised.',61);
INSERT INTO "status_log" VALUES(101,36,'FIR_REGISTERED','ARRESTS_MADE','2026-01-29','seed-import','A PWD assistant engineer posted in Barmer arrested; alleged beneficiary and participant in the leak racket.',61);
INSERT INTO "status_log" VALUES(102,37,NULL,'ALLEGED','2018-02-21','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(103,37,'ALLEGED','FIR_REGISTERED','2018-05-22','seed-import','FIR against 17 incl. 10 vendor employees and 7 candidates; searches at 12 locations.',62);
INSERT INTO "status_log" VALUES(104,37,'FIR_REGISTERED','ARRESTS_MADE','2019-06-04','seed-import','Three accused arrested in the leak case.',63);
INSERT INTO "status_log" VALUES(105,38,NULL,'ALLEGED','2012-08-12','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(106,38,'ALLEGED','ARRESTS_MADE','2012-08-12','seed-import','Arrests incl. a candidate found with leaked questions before the exam; remands by an Erode court.',64);
INSERT INTO "status_log" VALUES(107,39,NULL,'ALLEGED','2023-04-04','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(108,39,'ALLEGED','FIR_REGISTERED','2023-04-04','seed-import','Case under Section 5, Telangana Public Examinations (Prevention of Malpractices) Act.',65);
INSERT INTO "status_log" VALUES(109,39,'FIR_REGISTERED','ARRESTS_MADE','2023-04-05','seed-import','Three arrested, including a minor who photographed the paper and forwarders in WhatsApp groups.',65);
INSERT INTO "status_log" VALUES(110,40,NULL,'ALLEGED','2023-03-13','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(111,40,'ALLEGED','FIR_REGISTERED','2023-03-13','seed-import','Case on a complaint by a TSPSC assistant secretary; later moved to the Central Crime Station and an SIT.',66);
INSERT INTO "status_log" VALUES(112,40,'FIR_REGISTERED','ARRESTS_MADE','2023-03-15','seed-import','49 persons arrested over the following weeks; one accused abroad.',66);
INSERT INTO "status_log" VALUES(113,40,'ARRESTS_MADE','CHARGESHEET_FILED','2023-06-09','seed-import','Preliminary charge sheet after CFSL forensics; total transactions around Rs 1.63 crore.',66);
INSERT INTO "status_log" VALUES(114,41,NULL,'ALLEGED','2024-06-19','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(115,41,'ALLEGED','FIR_REGISTERED','2024-06-20','seed-import','Probe handed to CBI; forensic experts later found the screenshot was doctored.',69);
INSERT INTO "status_log" VALUES(116,41,'FIR_REGISTERED','CLOSURE_REPORT','2025-01-30','seed-import','Closure report: no evidence of paper leak; doctored screenshot circulated by a student to make money.',68);
INSERT INTO "status_log" VALUES(117,42,NULL,'ALLEGED','2023-01-09','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(118,42,'ALLEGED','FIR_REGISTERED','2023-01-09','seed-import','Case registered after information that the paper was provided to candidates before the exam.',70);
INSERT INTO "status_log" VALUES(119,42,'FIR_REGISTERED','ARRESTS_MADE','2023-01-12','seed-import','Four arrested including a UKPSC section officer and his wife; Rs 22.5 lakh recovered.',70);
INSERT INTO "status_log" VALUES(120,43,NULL,'ALLEGED','2022-07-22','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(121,43,'ALLEGED','FIR_REGISTERED','2022-07-22','seed-import','FIR on UKSSSC''s complaint; STF probe into the December 2021 exam.',71);
INSERT INTO "status_log" VALUES(122,43,'FIR_REGISTERED','ARRESTS_MADE','2022-07-24','seed-import','40+ arrests over weeks, including the alleged organiser of the leak network.',71);
INSERT INTO "status_log" VALUES(123,44,NULL,'ALLEGED','2022-03-30','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(124,44,'ALLEGED','FIR_REGISTERED','2022-03-30','seed-import','FIRs registered; STF directed to probe; NSA invocation ordered.',73);
INSERT INTO "status_log" VALUES(125,44,'FIR_REGISTERED','ARRESTS_MADE','2022-03-31','seed-import','17 arrested including the district inspector of schools, who was also suspended.',73);
INSERT INTO "status_log" VALUES(126,45,NULL,'ALLEGED','2024-02-18','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(127,45,'ALLEGED','ARRESTS_MADE','2024-02-23','seed-import','240+ persons arrested or detained across districts for adopting or planning unfair means.',74);
INSERT INTO "status_log" VALUES(128,46,NULL,'ALLEGED','2024-02-12','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(129,46,'ALLEGED','FIR_REGISTERED','2024-03-04','seed-import','STF investigation registered to identify and prosecute individuals involved in the leak.',77);
INSERT INTO "status_log" VALUES(130,47,NULL,'ALLEGED','2021-11-28','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(131,47,'ALLEGED','ARRESTS_MADE','2021-11-28','seed-import','23 arrested on day one across districts.',78);
INSERT INTO "status_log" VALUES(132,48,NULL,'ALLEGED','2013-07-07','seed-import','Allegations surfaced publicly.',NULL);
INSERT INTO "status_log" VALUES(133,48,'ALLEGED','FIR_REGISTERED','2013-07-08','seed-import','Vyapam impersonation racket exposed via the July 2013 Indore arrests; STF constituted 26.08.2013.',82);
INSERT INTO "status_log" VALUES(134,48,'FIR_REGISTERED','CONVICTED','2022-09-29','seed-import','Five convicted under IPC 419/420/467/468/471 and the MP Recognized Examinations Act; 7 years RI and Rs 10,000 fine each.',80);
CREATE INDEX idx_incidents_exam    ON incidents(exam_id);
CREATE INDEX idx_incidents_status  ON incidents(current_status);
CREATE INDEX idx_incidents_dates   ON incidents(surfaced_date);
CREATE INDEX idx_legal_incident ON legal_actions(incident_id, action_date);
CREATE INDEX idx_legal_type     ON legal_actions(action_type);
CREATE INDEX idx_sources_type ON sources(source_type);
CREATE TRIGGER status_log_no_update BEFORE UPDATE ON status_log
BEGIN SELECT RAISE(ABORT, 'status_log is append-only'); END;
CREATE TRIGGER status_log_no_delete BEFORE DELETE ON status_log
BEGIN SELECT RAISE(ABORT, 'status_log is append-only'); END;
CREATE INDEX idx_quality_review ON data_quality(last_reviewed);
COMMIT;
