-
Notifications
You must be signed in to change notification settings - Fork 1
/
recruitment_associate.sql
5800 lines (5694 loc) · 814 KB
/
recruitment_associate.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- phpMyAdmin SQL Dump
-- version 4.7.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Mar 29, 2018 at 11:31 AM
-- Server version: 5.5.56-MariaDB
-- PHP Version: 5.6.32
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `recruitment_associate`
--
-- --------------------------------------------------------
--
-- Table structure for table `department`
--
CREATE TABLE `department` (
`user_id` varchar(500) NOT NULL,
`dept` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `department`
--
INSERT INTO `department` (`user_id`, `dept`) VALUES
('2017AP00001', 'Computer Science Engineering'),
('2017AP00004', 'Mathematics'),
('2017AP00003', 'Civil Engineering'),
('2017AP00005', 'Mathematics'),
('2017AP00007', 'Applied Mechanics'),
('2017AP00022', 'Electronics & Comm Engineering'),
('2017AP00014', 'Chemistry'),
('2017AP00019', 'Mechanical Engineering'),
('2017AP00024', 'Applied Mechanics'),
('2017AP00009', 'Electrical Engineering'),
('2017AP00033', 'School of Management Sciences '),
('2017AP00036', 'Mechanical Engineering'),
('2017AP00037', 'Electrical Engineering'),
('2017AP00040', 'Electronics & Comm Engineering'),
('2017AP00041', 'Computer Science Engineering'),
('2017AP00045', 'Computer Science Engineering'),
('2017AP00039', 'Chemical Engineering'),
('2017AP00051', 'Applied Mechanics'),
('2017AP00052', 'Mathematics'),
('2017AP00053', 'Mechanical Engineering'),
('2017AP00023', 'Civil Engineering'),
('2017AP00011', 'Electronics & Comm Engineering'),
('2017AP00055', 'Electronics & Comm Engineering'),
('2017AP00058', 'Computer Science Engineering'),
('2017AP00059', 'Computer Science Engineering'),
('2017AP00063', 'Electrical Engineering'),
('2017AP00065', 'Mechanical Engineering'),
('2017AP00002', 'Computer Science Engineering'),
('2017AP00073', 'Mechanical Engineering'),
('2017AS03221', 'Civil Engineering'),
('2017AP00080', 'Humanities and Social Sciences'),
('2017AP00094', 'School of Management Sciences '),
('2017AP00042', 'Computer Science Engineering'),
('2017AP00098', 'School of Management Sciences '),
('2017AP00100', 'Computer Science Engineering'),
('2017AP00100', 'School of Management Sciences '),
('2017AP00107', 'Electrical Engineering'),
('2017AP00106', 'Chemical Engineering'),
('2017AP00108', 'Computer Science Engineering'),
('2017AP00109', 'Computer Science Engineering'),
('2017AP00111', 'Mathematics'),
('2017AP00112', 'Humanities and Social Sciences'),
('2017AP00129', 'Electrical Engineering'),
('2017AP00068', 'Computer Science Engineering'),
('2017AP00147', 'Electrical Engineering'),
('2017AP00128', 'Chemical Engineering'),
('2017AP00149', 'School of Management Sciences '),
('2017AP00070', 'Mechanical Engineering'),
('2017AS02222', 'Mechanical Engineering'),
('2017AP00156', 'Civil Engineering'),
('2017AP00159', 'Civil Engineering'),
('2017AP00150', 'Mechanical Engineering'),
('2017AP00165', 'Computer Science Engineering'),
('2017AP00166', 'Electrical Engineering'),
('2017AP00167', 'Chemistry'),
('2017AP00142', 'Humanities and Social Sciences'),
('2017AP00178', 'Civil Engineering'),
('2017AP00046', 'Mechanical Engineering'),
('2017AS03443', 'Computer Science Engineering'),
('', 'Electrical Engineering'),
('2017AP00190', 'Mechanical Engineering'),
('2017AP00195', 'Computer Science Engineering'),
('2017AP00196', 'Civil Engineering'),
('2017AS00671', 'Electronics & Comm Engineering'),
('2017AP00198', 'School of Management Sciences '),
('2017AP00202', 'Applied Mechanics'),
('2017AP00152', 'Electronics & Comm Engineering'),
('2017AP00169', 'Humanities and Social Sciences'),
('2017AP00131', 'Mechanical Engineering'),
('2017AP00211', 'Electronics & Comm Engineering'),
('2017AP00126', 'Computer Science Engineering'),
('2017AP00218', 'Electronics & Comm Engineering'),
('2017AP00218', 'Electrical Engineering'),
('2017AP00219', 'Electronics & Comm Engineering'),
('2017AP00049', 'Computer Science Engineering'),
('2017AP00221', 'Mechanical Engineering'),
('2017AP00054', 'School of Management Sciences '),
('2017AP00236', 'Biotechnology'),
('2017AP00237', 'School of Management Sciences '),
('2017AP00207', 'Computer Science Engineering'),
('2017AP00239', 'Civil Engineering'),
('2017AP00117', 'School of Management Sciences '),
('2017AP00235', 'Computer Science Engineering'),
('2017AP00077', 'Civil Engineering'),
('2017AP00177', 'Electrical Engineering'),
('2017AP00238', 'Chemical Engineering'),
('2017AP00247', 'Civil Engineering'),
('2017AP00226', 'Chemical Engineering'),
('2017AP00250', 'Computer Science Engineering'),
('2017AP00099', 'Electrical Engineering'),
('2017AP00254', 'Mechanical Engineering'),
('2017AP00025', 'Civil Engineering'),
('2017AP00260', 'Electronics & Comm Engineering'),
('2017AP00261', 'Mechanical Engineering'),
('2017AP00262', 'School of Management Sciences '),
('2017AP00208', 'Applied Mechanics'),
('2017AP00208', 'Civil Engineering'),
('2017AP00026', 'Electronics & Comm Engineering'),
('2017AP00199', 'School of Management Sciences '),
('2017AP00234', 'School of Management Sciences '),
('2017AP00265', 'Electronics & Comm Engineering'),
('2017AP00072', 'Mathematics'),
('2017AP00275', 'School of Management Sciences '),
('2017AP00273', 'Chemical Engineering'),
('2017AP00248', 'Electronics & Comm Engineering'),
('2017AP00278', 'Mechanical Engineering'),
('2017AP00251', 'Computer Science Engineering'),
('2017AP00233', 'School of Management Sciences '),
('2017AP00197', 'Biotechnology'),
('2017AP00268', 'Chemical Engineering'),
('2017AP00066', 'Computer Science Engineering'),
('2017AP00287', 'Mechanical Engineering'),
('2017AP00288', 'Biotechnology'),
('2017AP00290', 'Computer Science Engineering'),
('2017AP00289', 'Biotechnology'),
('2017AP00223', 'Civil Engineering'),
('2017AP00293', 'School of Management Sciences '),
('2017AP00292', 'Computer Science Engineering'),
('2017AP00231', 'Biotechnology'),
('2017AP00253', 'Mechanical Engineering'),
('2017AP00295', 'Mechanical Engineering'),
('2017AP00252', 'Chemical Engineering'),
('2017AP00297', 'Biotechnology'),
('2017AP00185', 'Biotechnology'),
('2017AP00304', 'Computer Science Engineering'),
('2017AP00302', 'School of Management Sciences '),
('2017AP00187', 'Humanities and Social Sciences'),
('2017AP00090', 'Biotechnology'),
('2017AP00308', 'Biotechnology'),
('2017AP00110', 'Civil Engineering'),
('2017AP00306', 'Chemical Engineering'),
('2017AP00225', 'Computer Science Engineering'),
('2017AP00144', 'Electronics & Comm Engineering'),
('2017AP00318', 'Mechanical Engineering'),
('2017AP00277', 'Biotechnology'),
('2017AP00325', 'Chemical Engineering'),
('2017AP00327', 'Computer Science Engineering'),
('2017AP00210', 'Computer Science Engineering'),
('2017AP00329', 'Electronics & Comm Engineering'),
('2017AP00164', 'Biotechnology'),
('2017AP00012', 'Physics'),
('2017AP00335', 'Electronics & Comm Engineering'),
('2017AP00316', 'Humanities and Social Sciences'),
('2017AP00123', 'Biotechnology'),
('2017AP00146', 'Electrical Engineering'),
('2017AP00222', 'Mechanical Engineering'),
('2017AP00125', 'Electronics & Comm Engineering'),
('2017AS04302', 'Mathematics'),
('2017AP00212', 'Mathematics'),
('2017AP00056', 'School of Management Sciences '),
('2017AP00344', 'School of Management Sciences '),
('2017AP00291', 'Civil Engineering'),
('2017AP00345', 'Chemical Engineering'),
('2017AP00346', 'Mechanical Engineering'),
('2017AP00347', 'Mechanical Engineering'),
('2017AP00074', 'Electronics & Comm Engineering'),
('2017AP00230', 'Biotechnology'),
('2017AP00349', 'Electronics & Comm Engineering'),
('2017AP00350', 'Applied Mechanics'),
('2017AP00350', 'Mechanical Engineering'),
('2017AP00348', 'Mechanical Engineering'),
('2017AP00337', 'Computer Science Engineering'),
('2017AP00356', 'School of Management Sciences '),
('2017AP00358', 'Mechanical Engineering'),
('2017AP00334', 'Mechanical Engineering'),
('2017AP00091', 'Electronics & Comm Engineering'),
('2017AP00201', 'Mathematics'),
('2017AP00360', 'Biotechnology'),
('2017AP00361', 'Electronics & Comm Engineering'),
('2017AP00294', 'School of Management Sciences '),
('2017AP00364', 'Civil Engineering'),
('2017AP00367', 'School of Management Sciences '),
('2017AP00369', 'Biotechnology'),
('2017AP00371', 'School of Management Sciences '),
('2017AP00372', 'Biotechnology'),
('2017AP00373', 'Civil Engineering'),
('2017AP00180', 'Electronics & Comm Engineering'),
('2017AP00375', 'Electrical Engineering'),
('2017AP00377', 'Electrical Engineering'),
('2017AP00217', 'School of Management Sciences '),
('2017AP00102', 'Electronics & Comm Engineering'),
('2017AP00383', 'Computer Science Engineering'),
('2017AP00382', 'School of Management Sciences '),
('2017AP00386', 'Mechanical Engineering'),
('2017AP00069', 'Humanities and Social Sciences'),
('2017AP00391', 'Chemical Engineering'),
('2017AP00284', 'Civil Engineering'),
('2017AP00394', 'Humanities and Social Sciences'),
('2017AP00374', 'Computer Science Engineering'),
('2017AP00374', 'Electronics & Comm Engineering'),
('2017AP00354', 'Chemical Engineering'),
('2017AP00184', 'Electrical Engineering'),
('2017AP00378', 'Computer Science Engineering'),
('2017AP00341', 'Biotechnology'),
('2017AP00403', 'Applied Mechanics'),
('2017AP00403', 'Civil Engineering'),
('2017AP00396', 'Electrical Engineering'),
('2017AP00173', 'Computer Science Engineering'),
('2017AP00405', 'Electronics & Comm Engineering'),
('2017AP00406', 'Applied Mechanics'),
('2017AP00406', 'Civil Engineering'),
('2017AP00331', 'Biotechnology'),
('2017AP00411', 'Computer Science Engineering'),
('2017AP00384', 'School of Management Sciences '),
('2017AP00387', 'Applied Mechanics'),
('2017AP00332', 'Computer Science Engineering'),
('2017AP00311', 'Applied Mechanics'),
('2017AP00311', 'Mechanical Engineering'),
('2017AP00143', 'Mathematics'),
('2017AP00410', 'Humanities and Social Sciences'),
('2017AP00407', 'Computer Science Engineering'),
('2017AP00008', 'Electronics & Comm Engineering'),
('2017AP00145', 'Applied Mechanics'),
('2017AP00145', 'Mechanical Engineering'),
('2017AP00263', 'Electronics & Comm Engineering'),
('2017AP00414', 'Mechanical Engineering'),
('2017AP00415', 'Computer Science Engineering'),
('2017AP00415', 'Electronics & Comm Engineering'),
('2017AP00400', 'Computer Science Engineering'),
('2017AP00047', 'Mechanical Engineering'),
('2017AP00272', 'Civil Engineering'),
('2017AP00296', 'Electrical Engineering'),
('2017AP00420', 'Mechanical Engineering'),
('2017AP00353', 'Electronics & Comm Engineering'),
('2017AP00424', 'Biotechnology'),
('2017AP00021', 'Electronics & Comm Engineering'),
('2017AP00305', 'Computer Science Engineering'),
('2017AP00216', 'Civil Engineering'),
('2017AP00426', 'Electrical Engineering'),
('2017AP00425', 'Mechanical Engineering'),
('2017AP00060', 'Applied Mechanics'),
('2017AP00060', 'Civil Engineering'),
('2017AP00359', 'Computer Science Engineering'),
('2017AP00376', 'School of Management Sciences '),
('2017AP00340', 'Biotechnology'),
('2017AP00067', 'Applied Mechanics'),
('2017AP00313', 'Humanities and Social Sciences'),
('2017AP00323', 'Electrical Engineering'),
('2017AP00430', 'School of Management Sciences '),
('2017AP00013', 'Chemical Engineering'),
('2017AP00439', 'Biotechnology'),
('2017AP00402', 'Applied Mechanics'),
('2017AP00438', 'Electronics & Comm Engineering'),
('2017AP00436', 'Electronics & Comm Engineering'),
('2017AP00093', 'Computer Science Engineering'),
('2017AP00274', 'Computer Science Engineering'),
('2017AP00270', 'Electronics & Comm Engineering'),
('2017AP00401', 'Mechanical Engineering'),
('2017AP00441', 'Electrical Engineering'),
('2017AP00440', 'Biotechnology'),
('2017AP00368', 'Chemical Engineering'),
('2017AP00444', 'Electronics & Comm Engineering'),
('2017AP00446', 'Mechanical Engineering'),
('2017AP00203', 'Physics'),
('2017AP00448', 'Computer Science Engineering'),
('2017AP00027', 'Chemical Engineering'),
('2017AP00366', 'Civil Engineering'),
('2017AP00366', 'GIS [Geographic Information System] Cell'),
('2017AP00449', 'Humanities and Social Sciences'),
('2017AP00200', 'School of Management Sciences '),
('2017AP00450', 'School of Management Sciences '),
('2017AP00437', 'Electronics & Comm Engineering'),
('2017AP00300', 'Civil Engineering'),
('2017AP00388', 'Civil Engineering'),
('2017AP00413', 'Chemical Engineering'),
('2017AP00452', 'Electronics & Comm Engineering'),
('2017AP00453', 'Electronics & Comm Engineering'),
('2017AP00451', 'Humanities and Social Sciences'),
('2017AP00006', 'Mechanical Engineering'),
('2017AP00454', 'School of Management Sciences '),
('2017AP00456', 'School of Management Sciences '),
('2017AP00455', 'Mechanical Engineering'),
('2017AP00447', 'Civil Engineering'),
('2017AP00459', 'Electronics & Comm Engineering'),
('2017AP00460', 'Humanities and Social Sciences'),
('2017AP00416', 'Mechanical Engineering'),
('2017AP00139', 'Applied Mechanics'),
('2017AP00139', 'Mechanical Engineering'),
('2017AP00279', 'Electronics & Comm Engineering'),
('2017AP00421', 'Biotechnology'),
('2017AP00158', 'Applied Mechanics'),
('2017AP00461', 'Electrical Engineering'),
('2017AP00462', 'Electronics & Comm Engineering'),
('2017AP00463', 'School of Management Sciences '),
('2017AP00071', 'Electronics & Comm Engineering'),
('2017AP00246', 'Computer Science Engineering'),
('2017AP00465', 'Computer Science Engineering'),
('2017AP00466', 'Electronics & Comm Engineering'),
('2017AP00427', 'School of Management Sciences '),
('2017AP00458', 'Applied Mechanics'),
('2017AP00458', 'Mechanical Engineering'),
('2017AP00468', 'School of Management Sciences '),
('2017AP00469', 'Computer Science Engineering');
-- --------------------------------------------------------
--
-- Table structure for table `education`
--
CREATE TABLE `education` (
`user_id` varchar(500) NOT NULL,
`id` int(11) NOT NULL,
`degree` varchar(500) NOT NULL,
`subject` varchar(500) NOT NULL,
`inst_name` varchar(500) NOT NULL,
`entry_date` varchar(500) NOT NULL,
`complete_date` varchar(500) NOT NULL,
`marks` varchar(500) NOT NULL,
`max_marks` varchar(500) NOT NULL,
`perc_marks` varchar(500) NOT NULL,
`division` varchar(500) NOT NULL,
`qualification` varchar(500) NOT NULL,
`board` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `education`
--
INSERT INTO `education` (`user_id`, `id`, `degree`, `subject`, `inst_name`, `entry_date`, `complete_date`, `marks`, `max_marks`, `perc_marks`, `division`, `qualification`, `board`) VALUES
('2017AP00001', 21, 'asd', 'asd', 'asd', '2015-06-15', '2015-06-16', '30', '60', '40', 'NA', 'pg', 'sad'),
('2017AP00004', 23, 'M.Sc.', 'Mathematics', 'Govt. Science College Raipur', '1999-07-01', '2001-06-30', '685', '800', '85.6', '1', 'pg', 'Pt. RavishankarShukla Univ. Raipur'),
('2017AP00004', 24, 'B.Sc.', 'Physics, Chemistry, Mathematics', 'Govt. Phuljhar College, Saraipali (C.G.)', '1996-07-01', '1999-06-30', '1228', '1750', '70', '1', 'ug', 'Pt. RavishankarShukla Univ. Raipur'),
('2017AP00004', 25, 'Higher Sec. School', 'Mathematics, Physics, Chemistry, English, Hindi', 'Govt. High. Sec. School Sankara', '1995-07--', '1996-03---', '316', '450', '70', '1', 'hssc', 'M.P. Board (Bhopal)'),
('2017AP00004', 26, 'High School', 'Mathematics, Physics, Chemistry, Hindi, English, Sanskrit', 'Govt. High. Sec. School Sankara', '1993-07--', '1994-05--', '484', '650', '74', '1', 'ssc', 'M.P. Board (Bhopal)'),
('2017AP00003', 27, 'Masters in Structural Engineering', 'Structural Engineering', 'Shri G S Institute of Technology and Sciences', '2001-08-08', '2003-08-19', '1616', '2000', '80.8', '1', 'pg', 'RGPV Bhopal'),
('2017AP00003', 28, 'B.E. in Civil Engineering', 'Civil Engineering', 'Kavikulguru Institute of Technology and Sciences', '1997-07-01', '2001-07-19', '935', '1250', '74.8', '1', 'ug', 'Nagpur University'),
('2017AP00003', 29, 'HSSC', 'Maths, Physics, Chemistry, Hindi, English', 'M.G Inter College, Gorakhpur, U.P.', '1993-07-01', '1995-08-03', '338', '500', '67.6', '1', 'hssc', 'U.P. Board'),
('2017AP00003', 30, 'SSC', 'Maths, Science, Biology, Hindi, English, Social Science', 'M.G Inter College, Gorakhpur, U.P.', '1991-07-01', '1993-07-01', '416', '600', '67.6', '1', 'ssc', 'U.P. Board'),
('2017AP00005', 32, 'M.Phil.', 'Mathematics', 'IIT Roorkee', '1998-07-01', '1999-06-01', '1153', '1500', '76.87', '1', 'pg', 'IIT Roorkee'),
('2017AP00007', 36, 'Masters in Structural Engineering', 'Structural Engineering', 'Shri G S Institute of Technology and Sciences', '2001-08-08', '2003-08-19', '1616', '2000', '80.8', '1', 'pg', 'RGPV Bhopal'),
('2017AP00005', 37, 'M. Sc.', 'Mathematics', 'IIT Roorkee', '1995-07-01', '1998-06-01', '2092', '3000', '69.73', '1', 'pg', 'IIT Roorkee'),
('2017AP00007', 38, 'B.E. in Civil Engineering', 'Civil Engineering', 'Kavikulguru Institute of Technology and Sciences', '1997-07-01', '2001-07-19', '935', '1250', '74.8', '1', 'ug', 'Nagpur University'),
('2017AP00007', 39, 'HSSC', 'Maths, Physics, Chemistry, Hindi, English', 'M.G Inter College, Gorakhpur, U.P.', '1993-07-01', '1995-08-03', '338', '500', '67.6', 'NA', 'hssc', 'U.P. Board'),
('2017AP00007', 40, 'SSC', 'Maths, Science, Biology, Hindi, English, Social Science', 'M.G Inter College, Gorakhpur, U.P.', '1991-07-01', '1993-07-01', '416', '600', '69.33', '1', 'ssc', 'U.P. Board'),
('2017AP00012', 42, 'M.Sc.', 'Physics', 'Meerut College Meerut', '1997-07-01', '1999-07-31', '637', '900', '70.78', '1', 'pg', 'Chaudhary Charan Singh University, Meerut'),
('2017AP00012', 43, 'B.Sc.', 'Physics, Chemistry and Mathematics', 'D. N. College Meerut', '1994-07-01', '1997-07-24', '991', '1450', '68.34', '1', 'ug', 'Chaudhary Charan Singh University, Meerut'),
('2017AP00012', 44, 'Intermediate', 'General Hindi, English, Mathematics, Physics, Chemistry,', 'SSD Boys Int College Lal Kurti Meerut', '1992-07-01', '1994-07-11', '304', '500', '60.8', '1', 'hssc', 'Board of High School and Intermediate Education U.P. Allahabad'),
('2017AP00012', 45, 'High School', 'Hindi, English, Mathematics Two, Science Two, Social Science, Biology', 'S. D. Inter College Kanker Khera Meerut', '1990-07-01', '1992-07-24', '368', '600', '61.33', '1', 'ssc', 'Board of High School and Intermediate Education U.P. Allahabad'),
('2017AP00005', 46, 'B.Sc.', 'Physics, Chemistry and Mathematics', 'Sahu Jain College Najibabad (Bijnor)', '1992-07-01', '1995-06-01', '996', '1350', '73.78', '1', 'ug', 'Rohilkhand University Bareilly'),
('2017AP00005', 48, 'Intermediate', 'Physics, Chemistry, Mathematics, Hindi, English', 'Hindu Inter College Nagina (Bijnor)', '1989-07-01', '1991-06-01', '320', '500', '64', '1', 'hssc', 'UP Board Allahabad'),
('2017AP00005', 49, 'High School', 'Hindi, English, Maths-2, Science-2, Social Science, Biology', 'Hindu Inter College Nagina (Bijnor)', '1987-07-01', '1989-06-01', '376', '600', '62.67', '1', 'ssc', 'UP Board Allahabad'),
('2017AP00024', 66, 'Master of Engineering', 'Structural Engineering', 'Bengal Engineering College', '2000-07-17', '2002-01-18', '1435', '1800', '79.7', '1', 'pg', 'Bengal Engineering College (D.U)'),
('2017AP00024', 67, 'Bachelor of Engineering', 'Civil Engineering', 'Bengal Engineering College', '1996-07-15', '2000-05-05', '3458', '4500', '76.8', '1', 'ug', 'Bengal Engineering College (D.U)'),
('2017AP00024', 68, 'Higher Secondary', 'Science', 'Garhbeta College', '1993-06-07', '1995-04-14', '683', '1000', '68.3', '1', 'hssc', 'W.B.C.H.S.E'),
('2017AP00026', 70, 'B E', 'Electronics and Instrumentation', 'BBDIT&RC, Bulandshahr', '1998-07-01', '2002-09-09', '3682', '4800', '76.7', '1', 'ug', 'CCS University, Meerut'),
('2017AP00023', 71, 'M.Tech', 'Water Resource Management', 'Motilal Nehru National Institute of Technology, Allahabad', '2002-07-01', '2004-07-23', '7.84', '10', '78.4', '1', 'pg', 'Motilal Nehru National Institute of Technology, Allahabad'),
('2017AP00023', 72, 'BE', 'Civil Engineering', 'North Maharashtra Univerity, Jalgaon', '1997-07-01', '2001-05-30', '963', '1500', '64.2', '1', 'ug', 'North Maharashtra Univerity, Jalgaon'),
('2017AP00023', 73, 'Higher Secondary', 'Physics, Chemistry, Mathematics', 'KV', '1994-06-01', '1995-05-30', '282', '500', '56.4', '2', 'hssc', 'CBSE'),
('2017AP00023', 74, 'Secondary School', 'Science', 'KV', '1992-06-01', '1993-06-05', '286', '500', '57.2', '2', 'ssc', 'CBSE'),
('2017AP00026', 75, 'Inter', 'Hindi, English, Math, Physics, Chemistry', 'S D Inter college, Orai', '1991-06-30', '1992-07-15', '231', '500', '46.2', '2', 'hssc', 'UP Board, Allahabad'),
('2017AP00026', 76, 'Highschool', 'Hindi, English, Mathematics Two, Science Two, Social Science, Biology', 'SRP Inter college, Konch', '1989-07-01', '1990-07-07', '393', '600', '65.5', '1', 'ssc', 'UP Board, Allahabad'),
('2017AP00033', 77, 'MBA', 'HR & MARKETING', 'MAHATMA GANDHI PG COLLEGE', '2006-06-02', '2008-08-14', '2224', '3300', '67', '1', 'pg', 'ACHARYA NAGARJUNA UNIVERSITY'),
('2017AP00033', 78, 'B.SC', 'MATHEMATICS,PHYSICS,CHEMISTRY', 'VIKAS DEGREE COLLEGE', '2002-06-01', '2005-06-01', '1581', '2200', '72', '1', 'ug', 'OSMANIA UNIVERSITY'),
('2017AP00033', 79, 'INTER MEDIATE(12 TH)', 'MATHEMATICS,PHYSICS,CHEMISTRY', 'GOVT.Jr.COLLEGE', '2000-06-01', '2002-05-10', '786', '1000', '78.6', '1', 'hssc', 'BOARD OF INTERMEDIATE ,ANDHRA PRADESH'),
('2017AP00033', 80, '10th Standard', 'MATHEMATICS,PHYSICS,CHEMISTRY', 'S A S R Z P H SCHOOL', '1999-06-01', '2000-03-03', '454', '600', '75', '1', 'ssc', 'BOARD OF SECONDARY EDUCATION ,ANDHRA PRADESH'),
('2017AP00014', 82, 'Master of Science ( M.Sc.)', 'Chemistry', 'Gorakhpur University', '', '1993-10-24', '847', '1200', '70.5', '1', 'pg', 'Gorakhpur University'),
('2017AP00014', 83, 'Bachelor of Science (B. Sc.)', 'Physics, Chemistry , Mathematics', 'Gorakhpur University', '', '1991-10-17', '985', '1800', '54.7', '2', 'ug', 'Gorakhpur University'),
('2017AP00014', 84, 'Intermediate', 'Physics, Chemistry , Mathematics, General Hindi, English', 'M. G. Inter College, Gorakhpur', '', '1986-06-06', '335', '500', '67', '1', 'hssc', 'U. P. Board'),
('2017AP00014', 85, 'High School', 'Mathematics,Hindi, English, Science, Social Science, Biology', 'M. P. Inter College, Gorakhpur', '', '1984-07-15', '393', '600', '65.5', '1', 'ssc', 'U. P. Board'),
('2017AP00039', 86, 'M.Tech', 'Biotechnology/Chemical Engineering', 'University College of Science & Technology, Calcutta University', '1996-05-15', '1998-04-14', '1015', '1500', '67', '1', 'pg', 'Calcutta University'),
('2017AP00039', 87, 'B.Tech', 'Chemical Engineering', 'University College of Science & Technology, Calcutta University', '1990-08-01', '1994-04-15', '1650', '3000', '55', '2', 'ug', 'Calcutta University'),
('2017AP00039', 88, 'B.Sc(hons) B.Ed', 'Chemistry', 'Regional College of Education Bhubaneswar', '1986-07-07', '1990-04-18', '560', '800', '70', '1', 'ug', 'Utkal Univ'),
('2017AP00039', 89, 'H S', 'Sci', 'Nachinda J K High', '1978-07-03', '1980-04-15', '595', '1000', '59.5', '2', 'hssc', 'WBCHSE'),
('2017AP00039', 90, 'madhyamik', 'all', 'bajkul j k high', '1976-01-01', '1978-03-17', '631', '1000', '63.1', '1', 'ssc', 'WBBSE'),
('2017AP00040', 91, 'M.Tech', 'Industrial Electronics', 'NITK Surathkal, Karnataka', '1993-08-15', '1995-06-06', '1794', '2300', '78', '1', 'pg', 'Mangalore University'),
('2017AP00040', 94, 'B.E', 'Electrical and Electronics Engineering', 'Dr. P.G. Halkatti College of Engineering and Technology, Bijapur', '1988-06-15', '1992-08-18', '941', '1200', '78', '1', 'ug', 'Karnatak University, Dharwad'),
('2017AP00040', 95, 'All India Senior School Certificate Examination', 'PCMB', 'Kendriya Vidyalaya No. 1, Kalpakkam', '1986-05-15', '1988-05-18', '419', '500', '83', '1', 'hssc', 'CBSE'),
('2017AP00040', 96, 'All India Secondary School Examination', 'Mathematics, Science, Social Studies, Hindi, English', 'Kendriya Vidyalaya ASC (S), Bangalore', '1974-05-15', '1984-05-15', '335', '500', '67', '1', 'ssc', 'CBSE'),
('2017AP00041', 97, 'M.E', 'Computer Science and Engineering', 'MEPCO SCHLENK ENGINEERING COLLEGE SIVAKASI', '2006-06-15', '2008-04-26', '79', '100', '79', '1', 'pg', 'ANNA UNIVERSITY CHENNAI'),
('2017AP00041', 98, 'B.E', 'Computer Science and Engineering', 'SNCET', '2002-07-13', '2006-05-16', '77', '100', '77', 'NA', 'ug', 'ANNA UNIVERSITY CHENNAI'),
('2017AP00041', 99, 'PlusTwo', 'Maths,Physics,Chemistry,Biology', 'kalaimagal Kalvi Nilayam', '2001-06-12', '2002-04-12', '88.2', '100', '88.2', 'NA', 'hssc', 'State Board Tamilnadu'),
('2017AP00042', 100, 'M.Tech.,', 'Computer Science and Engineering', 'Pondicherry Engineering College', '2003-06-10', '2005-07-18', '8.58', '10', '8.58', '1', 'pg', 'Pondicherry University'),
('2017AP00041', 101, 'SSLC', 'Maths,Physics,Chemistry,Biology,Social Science', 'kalaimagal Kalvi Nilayam', '1998-04-10', '1999-04-14', '90.2', '100', '90.2', 'NA', 'ssc', 'State Board Tamilnadu'),
('2017AP00042', 105, 'B.E.,', 'Computer Science and Engineering', 'Periyar Maniammai College of Technology for women', '1989-06-07', '1993-06-12', '3067', '4300', '71.32', '1', 'ug', 'Bharathidasan University'),
('2017AP00042', 106, 'D.E.C.E.,', 'Electronice and Communication Engineering', 'Periyar Centenary Girls Polytechnic', '1986-06-06', '1989-07-07', '1124', '1200', '94', '1', 'hssc', 'State Board of Technical Education - Tamil Nadu'),
('2017AP00042', 107, 'SSLC', 'Maths, Physics , Chemistry', 'Department of Governent Examination', '1985-06-06', '1986-07-07', '366', '500', '73', '1', 'ssc', 'Tamil Nadu'),
('2017AP00051', 109, 'Master in Mechanical Engineering (M.M.E.)', 'Fluid Mechanics & Hydraulics (Mechanical Engineering)', 'Department of Mechanical Engineering', '2000-09-02', '2002-03-31', '1145', '1400', '81.66', '1', 'pg', 'Jadavpur University, Kolkata.'),
('2017AP00051', 110, 'Bachelor of Engineering', 'Mechanical Engineering', 'Sardar Vallabhbhai Regional College of Engineering & Technology (SVRCET), Surat', '1996-08-26', '2000-07-02', '1346', '1800', '74.78', '1', 'ug', 'South Gujarat University, Surat'),
('2017AP00051', 111, 'Higher Secondary Examination', 'Physics, Maths, Chemistry, English, Bengali, Geography.', 'Shivaji Road Durgapur Steels Plant Boys\' High School, Durgapur.', '1994-07-31', '1996-03-31', '784', '1000', '78.40', '1', 'hssc', 'West Bengal Council of Higher Secondary Education'),
('2017AP00051', 112, 'Madhyamik Pariksha (Secondary Examination)', 'Physical Science, Life Science, Maths, English, Bengali, History, Geography, Biology.', 'Durgapur Steel Plan A-Zone High School.', '1992-07-31', '1994-03-31', '735', '900', '81.33', '1', 'ssc', 'West Bengal Board of Secondary Education.'),
('2017AP00052', 113, 'MSc', 'Mathematics', 'BHU Varanasi', '2000-08-11', '2002-05-26', '668', '1000', '66.8', '1', 'pg', 'BHU Varanasi'),
('2017AP00052', 114, 'BSc', 'Mathematics, Physics, Chemistry', 'Shibli national College, Azamgarh', '1997-09-01', '2000-07-01', '1170', '1800', '65', '1', 'ug', 'Purvanchal University, UP'),
('2017AP00052', 116, 'Highschool', 'Math, Scince, Biology, Social Science, Hindi, English', 'SSSAHS Maltari, Azamgarh, UP', '1993-07-01', '1995-08-01', '396', '600', '66', '1', 'ssc', 'UP'),
('2017AP00052', 117, 'Intermidiate', 'Math, Physics, Chemistry, Hindi, English', 'Gandhi Inter College, Maltari, Azamgarh, UP', '1995-08-11', '1997-06-03', '319', '500', '63.8', 'NA', 'hssc', 'UP'),
('2017AP00053', 118, 'Master of Production Technology and Management Engineering', 'Production Technology and Management', 'Prof. Ram Meghe Institute of Technology & Research, Badnera, Amravati , Maharashtra', '2001-07-15', '2003-09-23', '880', '1300', '67.69', '1', 'pg', 'Amaravti University, Amravati'),
('2017AP00053', 119, 'Bachelor Of Mechanical Engineering', 'Mechanical Engineering', 'Babasaheb Naik College of Engineering, Pusad', '1993-09-30', '1996-07-05', '1033', '1375', '75.13', '1', 'ug', 'Amaravti University, Amravati'),
('2017AP00053', 120, 'Diploma in Mechanical Engg', 'Mechanical Engineering', 'Government Polytechnic Yavatmal, Maharashtra', '1990-08-14', '1993-08-27', '722', '1100', '65.63', '1', 'hssc', 'Board of Technical Examinations, Maharashtra State'),
('2017AP00053', 121, 'S.S.C.', 'S.S.C.', 'Loknayak Bapuji Aney Vidyalaya, Yavatmal, Maharashtra', '', '1990-03-30', '500', '700', '71.42', '1', 'ssc', 'Maharashtra State Board of Secondary and Higher Secondary Education, Pune/ Divisional Board-Nagpur'),
('2017AP00022', 122, 'M. E.', 'Control & Instrumentation', 'MNNIT Allahabad (Formarly MNREC Allahabad)', '', '1999-08-06', '4484', '5600', '80%', '1', 'pg', 'University of Allahabad'),
('2017AP00022', 123, 'B. Tech.', 'Electronics & Telecommuication Engineering', 'J K Institute of Applied Physics & Technology, Allahabd', '', '1996-09-01', '2258', '3200', '70.05', '1', 'ug', 'University of Allahabad'),
('2017AP00022', 124, 'B. Sc.', 'Physics, Chemistry, Mathematics', 'G. F. (P. G.) College Shahjahanpur', '', '1992-08-17', '1033', '1350', '76.6', '1', 'ug', 'MJP Rohilkhand University (formerly Rohilkhand University) Bareilly, UP'),
('2017AP00011', 125, 'Master of Engineering', 'Digital Systems', 'MNREC Allahabad', '2000-07-21', '2002-01-27', '4239', '5600', '75.7', '1', 'pg', 'UP Technical University'),
('2017AP00011', 126, 'Bachelor of Engineering', 'Electronics Engineering', 'Govt. Engineering College Raipur', '1992-07-25', '1997-06-30', '1775', '2700', '65.74', '1', 'ug', 'Pt. Ravishankar Shukla University, Raipur ( M.P)'),
('2017AP00011', 127, 'Higher Secondary', 'Maths, science,english,hindi', 'Christ Church Boys Higher Secondary School, Jabalpur', '1989-07-01', '1990-04-30', '489', '800', '61.12', '1', 'hssc', 'Bhopal Board'),
('2017AP00011', 128, 'High School', 'Maths, science,english,hindi, social science', 'Christ Church Boys Higher Secondary School, Jabalpur', '1987', '1988', '461', '650', '70.92', '1', 'ssc', 'Bhopal Board'),
('2017AP00022', 129, 'Intermediate', 'Science Subjects', 'LBJP Inter College Tilhar, Shahjahanpur, UP', '', '1989-06-20', '278', '500', '55.6', '2', 'hssc', 'U P Board, Allahabad'),
('2017AP00022', 131, '10th', 'Science Subjects', 'LBJP Inter College Tilhar, Shahjahanpur, UP', '', '1985-07-22', '300', '600', '50', '2', 'ssc', 'U P Board, Allahabad'),
('2017AP00055', 132, 'Bachelor of Technology', 'Electronics Engineering', 'Kamla Nehru Institute of Technology Sultanpur', '1997-07-15', '2001-07-15', '3983', '5000', '79.66', '1', 'ug', 'Dr. RML Awadh University, Faizabad'),
('2017AP00055', 133, 'Indian School Certificate', 'English, Hindi, Maths, Physics, chemistry', 'Boys High School and College, Allahabad', '1994-04-15', '1996-04-15', '306', '500', '61.2%', 'NA', 'hssc', 'ISCE, New Delhi'),
('2017AP00055', 134, 'Indian Certificate for Secondary Education', 'English, Hindi, History Civics and Geography, Science, Accounts', 'Boys High School and College, Allahabad', '1993-04-15', '1994-04-15', '500', '600', '83.33%', 'NA', 'ssc', 'ISCE, New Delhi'),
('2017AP00058', 135, 'MASTER IN COMPUTER APPLICATION', 'COMPUTER APPLICATION', 'ACADEMY OF BUSINESS AND ENGINEERING SCIENCES(ABES), GHAZIABAD', '2002-08-01', '2005-07-27', '4140', '6000', '69.00', '1', 'pg', 'DR. APJ ABDUL KALAM TECHNICAL UNIVERSITY LUCKNOW'),
('2017AP00058', 136, 'BACHELOR IN SCIENCE', 'SCIENCE', 'DBS COLLEGE', '1997-08-25', '2000-07-02', '806', '1350', '59.70', '2', 'ug', 'CHHATRPATI SHASHUJI MAHARAJ UNIVERSITY KANPUR NAGAR'),
('2017AP00058', 137, 'INTERMEDIATE', 'SCIENCE', 'MOHAN VIDYA MANDIR INTER COLLEGE', '1996-06-13', '1997-06-03', '319', '500', '63.80', '1', 'hssc', 'UP BOARD, ALLAHABAD'),
('2017AP00058', 138, 'HIGH SCHOOL', 'SCIENCE', 'MOHAN VIDYA MANDIR INTER COLLEGE', '1994-08-09', '1995-08-09', '429', '600', '71.50', '1', 'ssc', 'UP BOARD, ALLAHABAD'),
('2017AP00059', 139, 'M.Tech', 'Computer Science & Engineering', 'JNTUCE Kakinada', '2005-05-11', '2008-02-12', '1014', '1400', '72.43', '1', 'pg', 'JNTU Hyderabad'),
('2017AP00059', 140, 'B.E', 'COMPUTER TECHNOLOGY', 'RCERT, CHANDRAPUR', '1999-09-06', '2002-05-20', '843', '1250', '67.44', '1', 'ug', 'Nagpur University'),
('2017AP00059', 141, 'Intermediate', 'MPC', 'LDG Jr. College', '1993-07-01', '1995-03-30', '612', '1000', '61.2', '1', 'hssc', 'BIE'),
('2017AP00059', 142, 'Diploma', 'Computer Engineering', 'VMR Polytechnic', '1995-07-01', '1998-05-31', '1563', '2000', '78.15', '1', 'hssc', 'SBTET'),
('2017AP00059', 143, 'SSC', 'Maths, Science, Social', 'Visvodaya High School', '1992-06-12', '1993-03-31', '352', '500', '70.4', '1', 'ssc', 'BSE'),
('2017AP00060', 145, 'M.E.', 'Structural Engineerting', 'MNREC Allahabad', '1997-07-01', '1999-05-25', '4440', '5600', '79.29', '1', 'pg', 'University of Allahabad'),
('2017AP00060', 146, 'B.E.', 'Civil Engineering', 'MNREC Allahabad', '1988-07-01', '1992-05-25', '2098', '2500', '70.06', '1', 'ug', 'University of Allahabad'),
('2017AP00060', 147, 'Intermediate', 'Science- Math Group', 'I B S N V Inter College Lucknow', '1984-07-01', '1986-05-25', '333', '500', '66.67', '1', 'hssc', 'U P Board Allahabad'),
('2017AP00060', 148, 'High School', 'Science Group', 'Lucknow Montessori Inter College Lucknow', '1982-07-01', '1984-05-25', '346', '600', '57.67', '2', 'ssc', 'U P Board Allahabad'),
('2017AP00056', 149, 'Master of Business Administration', 'Human Resource Management', 'Motilal Nehru Institute of Research and Business Administration', '1997-09-06', '1999-03-31', '1520', '2200', '69.09', '1', 'pg', 'University of Allahabad'),
('2017AP00056', 150, 'Bachelor of Science', 'Botony Chemistry', 'Ewing Christian College', '1994-08-26', '1996-09-26', '855', '1350', '63.3', '1', 'ug', 'University of Allahabad'),
('2017AP00056', 151, 'Intermediate', 'Hindi, English, Physics, Chemistry, Biology', 'D P Girls Inter College Allahabad', '1990-07-01 (approximate)', '1992-07-15', '307', '500', '61.4', '1', 'hssc', 'Madhyamik Siksha Parishad Uttar Pradesh'),
('2017AP00056', 152, 'ICSE', 'English, Hindi , History civics Geography, Mathematics, Science,Economics', 'St Marys Convent Inter college Allahabad', '1988-04-', '1990-03-', '435', '600', '72.5', '1', 'ssc', 'Council For the Indian School Certificate Examination New Delhi'),
('2017AP00056', 153, 'ICSE', 'English, Hindi , History civics Geography, Mathematics, Science,Economics', 'St Marys Convent Inter college Allahabad', '1988-04-', '1990-03-', '435', '600', '72.5', '1', 'ssc', 'Council For the Indian School Certificate Examination New Delhi'),
('2017AP00049', 154, 'M.TECH', 'COMPUTER SCIENCE &ENGINEERING', 'SRIJAYA CHAMA RAJENDRA COLLEGE OF ENGINEERING', '1998-09-01', '2000-11-01', '1487', '2000', '74', '1', 'pg', 'VISWESWARAIAH TECHNOLOGICLA UNIVERSITY'),
('2017AP00049', 155, 'B.TECH', 'ELECTRONICS AND COMMUNICATION', 'BAPATLA ENGINEERING COLLEGE', '1984-07-01', '1988-06-01', '3529', '5850', '61', '1', 'ug', 'ACHARYA NAGARJUNA UNIVERSITY'),
('2017AP00049', 156, 'INTERMEDIATE', 'MPC', 'AC COLELGE', '1982-06-01', '1984-03-01', '585', '1000', '59', '2', 'hssc', 'BIE'),
('2017AP00049', 157, 'SSC', 'COMPOSITE MATHEMATICS', 'PRIVATE', '1981-06-01', '1982-03-01', '317', '600', '53', '2', 'ssc', 'BSE'),
('2017AP00063', 158, 'M.Tech.', 'Power Systems', 'IIT Roorkee', '1999-07-01', '2001-07-30', '6.01', '10', '6.01', 'NA', 'pg', 'IIT Roorkee'),
('2017AP00063', 159, 'B.E.', 'Electrical Engg.', 'MMMEC, GORAKHPUR, UP, INDIA', '1995-07-01', '1999-07-30', '74.05', '100', '74.05', '1', 'ug', 'DDU UNIVERSITY OF GORAKHPUR'),
('2017AP00063', 160, 'Intermediate', 'Hindi, Maths, Physics, Chemistry, English', 'Govt. Jublee Inter College, Gorakhpur', '1989-07-30', '1992-07-02', '58.50', '100', '58.50', '2', 'hssc', 'UP BOARD ALLAHABAD'),
('2017AP00063', 161, 'High School', 'Hindi, Maths-2, Sience-2, English, Biology, Social Science', 'H.S. S. SAHAWA DEORIA', '1987-07-01', '1989-07-025', '44.33', '100', '44.33', 'NA', 'ssc', 'UP BOARD ALLAHABAD'),
('', 162, 'M.Tech.', 'Materials Science and Engineering', 'Motilal Nehru National Institute of Technology Allahabad', '2002-07-21', '2004-07-19', '9.4', '10', '9.4', '1', 'pg', 'Motilal Nehru National Institute of Technology Allahabad'),
('2017AP00067', 163, 'M.Tech.', 'Materials Science and Engineering', 'Motilal Nehru National Institute of Technology Allahabad', '2002-07-20', '2004-07-19', '9.4', '10', '9.4', '1', 'pg', 'Motilal Nehru National Institute of Technology Allahabad'),
('2017AP00067', 164, 'B.Tech.', 'Industrial and Production Engineering', 'Meerut Institute of Engineering and Technology, Meerut', '1997-07-21', '2001-09-24', '4213.25', '5462.5', '77.13', '1', 'ug', 'VBS Purvanchal University'),
('2017AP00067', 165, 'Intermediate', 'Physics-Chemistry-Mathematics', 'Government Inter Collage Meerut', '1993-07-24', '1995-07-27', '355', '500', '71', '1', 'hssc', 'U P Board Allahabad'),
('2017AP00067', 166, 'High School', 'Science II, Mathematics II, Biology', 'Government Inter Collage Meerut', '1991-07-25', '1993-06-26', '430', '600', '71.67', '1', 'ssc', 'U P Board Allahabad'),
('2017AP00069', 167, 'Masters of Arts', 'English Literature', 'Allahabad University', '1980-07-07', '1982-06-01', '750', '1200', '62.5', '1', 'pg', 'Allahabad University'),
('2017AP00073', 169, 'M TECH', 'INDUSTRIAL ENGINEERING AND MANAGEMENT', 'Indian Institute of Technology, Kharagpur', '2006-07-01', '2008-06-23', '7.12', '10', '7.12', '1', 'pg', 'IIT KHARAGPUR'),
('2017AP00073', 170, 'B.E.', 'MECHANICAL ENGINEERING', 'GOVT. ENGINEERING COLLEGE, BILASPUR', '2000-07-01', '2005-01-29', '1963', '3000', '65.43', '1', 'ug', 'GURU GHASIDAS UNIVERSITY, BILASPUR'),
('2017AP00073', 171, '12', 'SCIENCE (MATHS)', 'PUSHPARAJ ENGILISH MEDIUM SCHOOL, BILASPUR', '1992-07-01', '1993-03-01', '475', '800', '59.37', '2', 'hssc', 'MADHYAMIK SHIKSHA MANDAL, BHOPAL'),
('2017AP00073', 172, '10', 'ALL SUBJECTS', 'PUSHPARAJ ENGILISH MEDIUM SCHOOL, BILASPUR', '1990-07-01', '1991-04-01', '282', '650', '43.4', 'NA', 'ssc', 'MADHYAMIK SHIKSHA MANDAL, BHOPAL'),
('2017AS03221', 175, 'M.TECH', 'Construction Technology and Management', 'National Institute of Technology Karnataka', '2004-06-23', '2011-06-24', '8.22', '10.00', '8.22', 'NA', 'pg', 'National Institute of Technology Karnataka'),
('2017AS03221', 176, 'B.TECH', 'CIVIL ENGINEERING', 'National Institute of Technology Karnataka', '2004-08-02', '2008-05-29', '5.67', '10.00', '5.67', 'NA', 'pg', 'National Institute of Technology Karnataka'),
('2017AS03221', 177, 'P.U.C 1 & 2', 'PHYSICS, CHEMISTRY, SCIENCE, BIOLOGY', 'National Institute of Technology Karnataka', '2001-07-01', '2003-06-03', '50.83', '100.00', '50.83', '2', 'hssc', 'National Institute of Technology Karnataka'),
('2017AS03221', 178, 'S.S.L.C', 'KANNADA, ENGLISH, HINDI, SCIENCE, MATHEMATICS, SOCIAL SCIENCE', 'National Institute of Technology Karnataka', '2000-06-01', '2001-05-10', '77.76', '100.00', '77.76', '1', 'ssc', 'National Institute of Technology Karnataka'),
('2017AP00072', 180, 'M.Phil.', 'Mathematics', 'Department of Mathematics, CCS University Campus, Meerut', '2002-07-15', '2005-12-31', '344', '600', '57.33', '2', 'pg', 'Chaudhary Charan Singh University Meerut, UP, India'),
('2017AP00072', 181, 'M.Sc.', 'Mathematics', 'Department of Mathematics, CCS University Campus, Meerut', '2000-07-01', '2002-06-30', '911', '1600', '56.94', '2', 'pg', 'Chaudhary Charan Singh University Meerut, UP, India'),
('2017AP00072', 182, 'B.Sc.', 'Mathematics', 'D.N.P.G. College, Gulaothi', '1994-07-15', '1997-06-30', '783', '1450', '54', '2', 'ug', 'Chaudhary Charan Singh University Meerut, UP, India'),
('2017AP00072', 184, 'Intermediate', 'Science', 'M.H.M. Inter College Saidpur, Bulandshahr', '1993-07-01', '1994-06-30', '254', '500', '50.80', '2', 'hssc', 'Board of Highschool and Intermediate education, UP'),
('2017AP00072', 185, 'Highschool', 'Science', 'M.H.M. Inter College Saidpur, Bulandshahr', '1991-07-01', '1992-06-30', '274', '600', '45.67', '2', 'ssc', 'Board of Highschool and Intermediate education, UP'),
('2017AP00074', 186, 'M.Tech.', 'Digital Communication', 'Dr. A.P.J. Abdul Kalam Technical University, Uttar Prades, Lucknow', '', '2006-03-25', '8.0', '10', '80', '1', 'pg', 'Dr. A.P.J. Abdul Kalam Technical University, Uttar Prades, Lucknow'),
('2017AP00074', 187, 'B.E.', 'Electronics and Communication Engineering', 'Moradabad Institute of Technology, Moradabad', '', '2001-03-18', '3231', '4825', '66.9%', '1', 'ug', 'M.J.P. Rohilkhand University, Bareilly'),
('2017AP00074', 188, 'XII', 'Physics, Chemistry, Maths, Hindi, English', 'G.I.C. Barabanki', '', '1996-06-01', '331', '500', '66.2', '1', 'ug', 'U.P.'),
('2017AP00074', 189, 'X', 'Science, Maths, Biology, Hindi, English, Social Science', 'S.V.P.H.S.S. Barabanki', '', '1994-06-01', '395', '600', '65.8', '1', 'ssc', 'U.P.'),
('2017AP00080', 190, 'M.PHIL', 'ANTHROPOLOGY', 'UNIVERSITY OF DELHI', '', '2005-07-26', '417', '600', '69', '1', 'pg', 'UNIVERSITY OF DELHI'),
('2017AP00080', 191, 'M.A.', 'SOCIOLOGY', 'JAWAHARLALNEHRU UNIVERSITY, NEW DELHI', '', '2003-07-21', '5.87', '9', '64', '1', 'pg', 'JNU NEW DELHI'),
('2017AP00080', 192, 'B.A.', 'ANTHROPOLOGY (HONOURS) & ECONOMICS (PASS)', 'KHALLIKOTE AUTONOMOUS COLLEGE, BERHAMPUR, ODISHA', '', '2001-04-17', '1115', '1800', '61', '1', 'ug', 'BERHAMPUR UNIVERSITY, ODISHA'),
('2017AP00080', 193, 'INTERMEDIATE', 'PCM (B)', 'AGARPARA COLLEGE, BHADRAK, ODISHA', '', '1996-06-24', '450', '900', '50', '2', 'hssc', 'CHSE, ODISHA'),
('2017AP00080', 194, 'HIGH SCHOOL', 'MATH, SCIENCE, HIST, GEO, ENG, SANSKRIT, ODIYA', 'KADBARANG HIGH SCHOOL, BHADRAK, ODISHA', '', '1994-07-04', '498', '750', '68', '1', 'ssc', 'BSE, ODISHA'),
('2017AP00093', 195, 'M Tech CS', 'Computer Science', 'D A V V, Indore', '21-06-2004', '21-06-2006', '9.31', '10', '9.31', '1', 'pg', 'D A V V, Indore'),
('2017AP00090', 196, 'M.Sc. Biotechnology', 'Biotechnology', 'Himachal Pradesh University Shimla', '2002-07-01', '2004-06-30', '1383', '2200', '62.8', '1', 'pg', 'Himachal Pradesh University Shimla'),
('2017AP00090', 197, 'B.Sc.', 'Biology', 'University of Allahabad', '1998-07-01', '2001-06-30', '848', '1350', '62.8', '1', 'ug', 'University of Allahabad'),
('2017AP00090', 199, 'High School', 'Science', 'Government Inter College Allahabad', '1993-07-01', '1995-06-30', '448', '600', '74.66', '1', 'ssc', 'U P Board'),
('2017AP00098', 200, 'MBA', 'MANAGEMENT', 'Depatment of Management Studies', '', '1994-05-05', '1101', '1700', '64', '1', 'pg', 'JAI NARAIN VYAS UNIVERSITY, JODHPUR'),
('2017AP00006', 201, 'M. Tech.', 'Ferro Alloy Technology and Alloy Steel Making / Metallurgical & Materials Engineering Department', 'Visvesvaraya National Institute of Technology, Nagpur', '2000-07-30', '2002-04-24', '1201', '1800', '66.72', '1', 'pg', 'Nagpur University/ Visvesvaraya National Institute of Technology, Nagpur'),
('2017AP00006', 204, 'B.E.', 'Production Engineering', 'S.G.G.S. College of Engineering & Technology, Nanded', '1994', '1998', '927', '1500', '61.80', '1', 'ug', 'Dr. B.A.M.U. Aurangabad'),
('2017AP00102', 205, 'M.E.', 'Computer Science and Engineering', 'MNREC, MNNIT Allahabad', '2000-08-20', '2002-02-10', '3707', '5500', '67.4', '1', 'pg', 'UPTU, Lucknow'),
('2017AP00102', 206, 'B.E.', 'Electronics & Communication Engineering', 'MMMEC Gorakhpur', '1995-08-09', '1999-07-20', '4004', '6000', '66.73', '1', 'ug', 'DDU Gorakhpur University'),
('2017AP00102', 207, 'Intermediate', 'Math, Physics and Chemistry', 'Gandhi Inter College Sikander Pur Ballia', '1993-07-10', '1995-06-26', '370', '500', '74', '1', 'hssc', 'UP Board Allahabad'),
('2017AP00102', 208, 'High School', 'Math, Science, Biology, English, Hindi', 'Gandhi Inter College Sikander Pur Ballia', '1991-07-20', '1993-06-12', '384', '600', '64', '1', 'ssc', 'UP Board Allahabad'),
('2017AP00107', 209, 'B.TECH', 'ELECTRICAL AND ELECTRONICS ENGINEERING', 'SUNDERDEEP ENGINEERING COLLEGE GHAZIABAD', '2008-07-01', '2012-06-30', '3516', '5000', '70.32', '1', 'ug', 'GBTU LUCKNOW'),
('2017AP00106', 210, 'M. Tech.', 'Farm Machinery and Power Engineering', 'College of Technology', '2001-07-30', '2003-07-31', '7.831', '10.00', '78.31', '1', 'pg', 'G.B. Pant University of Agriculture and Technology Pantnagar, Uttarakhand'),
('2017AP00106', 211, 'B. Tech.', 'Agricultural Engineering', 'College of Technology', '1996-09-30', '2001-01-30', '4.026', '5.00', '75.39', '1', 'ug', 'G.B. Pant University of Agriculture and Technology Pantnagar, Uttarakhand'),
('2017AP00106', 212, 'Intermediate', 'Agricultural Sciences', 'Hobert Triloknath Inter College, Tanda, Faizabad', '1993-07-30', '1996-04-30', '714', '1000', '71.40', '1', 'hssc', 'Uttar Pradesh Board of Secondary Education'),
('2017AP00106', 213, 'High School', 'General Sciences', 'Hobert Triloknath Inter College, Tanda, Faizabad', '1991-07-30', '1993-04-30', '350', '600', '58.33', '2', 'ssc', 'Uttar Pradesh Board of Secondary Education'),
('2017AP00110', 214, 'Masters in Technology (M.Tech)', 'Transportation Engineering', 'Indian Institute of Technology, Roorkee, Roorkee, Uttarakhand', '2002-07-25', '2004-09-30', '9.14', '10', '9.14', '1', 'pg', 'Indian Institute of Technology, Roorkee, Roorkee, Uttarakhand'),
('2017AP00112', 219, 'MA', 'English', 'Bundelkhand University, Jhansi', '', '2006-10-13', '492', '800', '61.5', '1', 'pg', 'Bundelkhand University'),
('2017AP00112', 220, 'B.Sc.', 'English, Biology', 'DV (PG), College, Orai', '', '1996-06-27', '870', '1350', '64', '1', 'ug', 'Bundelkhand University'),
('2017AP00112', 221, 'Intermediate', 'English, Hindi, Physics, Chemistry, Biology', 'SGIC, Orai', '', '1993-06-24', '272', '500', '54', '2', 'hssc', 'UP Board, Allahabad'),
('2017AP00112', 222, 'High School', 'English, Hindi, Science, Maths, Social Science', 'SGIC, Orai', '', '1990-06-26', '320', '600', '53', '2', 'ssc', 'UP Board, Allahabad'),
('2017AP00111', 225, 'M.Sc.', 'Mathematics', 'University of Allahabad', '2001-07-09', '2003-06-29', '723', '1000', '72.3', '1', 'pg', 'University of Allahabad'),
('2017AP00111', 226, 'B.Sc.', 'Mathematics, Physics, Chemistry', 'D.A.V. Post Graduate College (Azamgarh)', '1998-07-14', '2001-07-11', '1235', '1800', '68.6', '1', 'ug', 'V.B.S. Purvanchal University, Jaunpur'),
('2017AP00111', 228, 'Intermediate', 'General Hindi, English, Physics, Chemistry, Mathematics', 'Town Inter College Mohammadabad Gohana Mau', '1996-07-02', '1998-06-14', '288', '500', '57.6', '2', 'hssc', 'Board of High School and Intermediate Education U.P. Allahabad'),
('2017AP00111', 229, 'High School', 'Hindi, English, Mathematics Two, Science Two, Social Science, Biology', 'National Inter College Mohammadabad Gohana Mau', '1994-07-05', '1996-06-13', '422', '600', '70.33', '1', 'ssc', 'Board of High School and Intermediate Education U.P. Allahabad'),
('2017AP00098', 234, 'B.Sc.', 'Science', 'Lachoo College', '', '1990-07-29', '1073', '1650', '65', '1', 'ug', 'JAI NARAIN VYAS UNIVERSITY, JODHPUR'),
('2017AP00098', 235, 'Higher Secondary', 'Science', 'Mahesh School', '', '1986-05-31', '288', '400', '72', '1', 'hssc', 'Board of Sec Edu Rajasthan'),
('2017AP00098', 236, 'Secondary', 'Science', 'Mahesh School', '', '1985-06-19', '547', '750', '72', '1', 'ssc', 'Board of Sec Edu, Rajasthan'),
('2017AP00125', 237, 'MTECH', 'INFORMATION TECHNOLOGY', 'ALLAHABAD A UNIV', '2003-03-20', '2005-07-10', '678', '800', '71', '1', 'pg', 'ALLAHABAD A UNIV'),
('2017AP00066', 238, 'M.TECH', 'Computer Science & Engineering', 'University College of Science, Technology & Agriculture', '2002-07-01', '2004-06-30', '1521', '2000', '76.04', '1', 'pg', 'University of Calcutta'),
('2017AP00125', 239, 'BE', 'ELECTRONICS & COMMUNICATION', 'DR. BHIMRAO AMBEDKAR UNIV', '1998-04-01', '2002-07-10', '789', '1000', '75.86', '1', 'ug', 'DR. BHIMRAO AMBEDKAR UNIV'),
('2017AP00066', 240, 'M.Sc', 'Computer & Information Science', 'University College of Science, Technology & Agriculture', '2000-07-01', '2002-06-30', '712', '1000', '71.2', '1', 'ug', 'University of Calcutta'),
('2017AP00066', 241, 'Higher Secondary', 'English, Bengali, Physics, Chemistry, Mathematics, Biology', 'Baruipur High School', '1995-07-01', '1997-04-30', '725', '1000', '72.5', '1', 'hssc', 'West Bengal Council of Higher Secondary Examination'),
('2017AP00066', 242, 'Madhyamik', 'General: Bengali, English, Mathematics, Physical Sc., Life Sc., History, Geography, Work Education, Physical Education, Mechanics', 'Baruipur High School', '1993-06-30', '1995-03-31', '739', '900', '82.1', '1', 'ssc', 'West Bengal Board of Secondary Examination'),
('2017AP00068', 243, 'M.Tech', 'Computer Science Application', 'Indian School of Mines, Dhanbad', '1995-07-15', '1997-06-15', '4.58', '5', '91.6', '1', 'pg', 'Indian School of Mines, Dhanbad'),
('2017AP00068', 244, 'M.Phil', 'Mathematics', 'Delhi University, Delhi', '1986-07-19', '1988-06-15', '379', '500', '75.8', '1', 'pg', 'Delhi University, Delhi'),
('2017AP00068', 245, 'M.Sc', 'Mathematics', 'Patna University', '1980-06-18', '1982-06-14', '584', '800', '73', '1', 'pg', 'Patna University'),
('2017AP00068', 255, 'B.Sc.(Honours)', 'Mathematics (Honours), Phy, Chem', 'Patna University', '1978-07-18', '1980-06-16', '457', '600', '76.1', '1', 'ug', 'Patna University'),
('2017AP00068', 256, 'Intermediate of Science', 'Phy, Chem, Math, Eng, Hindi, Bengali', 'Patna University', '1976-07-10', '1978-06-20', '651', '800', '72.3', '1', 'hssc', 'Patna University'),
('2017AP00068', 257, 'XI Class', 'Phy, Chem, Math, Adv Math, Eng, Hindi, S. Science, Bengali', 'Bihar School Examination Board', '1974-07-18', '1976-12-02', '671', '900', '74.5', '1', 'ssc', 'Bihar School Examination Board'),
('2017AP00025', 258, 'Master of Engineering', 'Structural Engineering', 'Bengal Engineering College', '2000-07-17', '2002-01-18', '1435', '1800', '79.7', '1', 'pg', 'Bengal Engineering College (D.U)'),
('2017AP00025', 259, 'Bachelor of Engineering', 'Civil Engineering', 'Bengal Engineering College', '1996-06-15', '2000-05-05', '3458', '4500', '76.8', '1', 'ug', 'Bengal Engineering College (D.U)'),
('2017AP00147', 260, 'M.Tech', 'Instrumentation and Control Engineering', 'Apeejay College of Engineering, Sohna, Gurgaon', '', '2007-11-28', '9.75', '10', '90', '1', 'pg', 'MD University, Rohtak, Haryana'),
('2017AP00147', 261, 'AMIE', 'Electronics and Communication Engineering', 'The Institution of Engineers(India)', '', '2001-09-26', '873', '1500', '58.2', 'NA', 'ug', 'The Institution of Engineers(India)'),
('2017AP00147', 262, 'Intermediate', 'Maths, Physics, Chemistry, English, Hindi', 'Govt Inter College, Shaktifarm, Nainital', '', '1992-07-10', '323', '500', '64.6', '1', 'hssc', 'UP Board(The Then)'),
('2017AP00147', 263, 'High School', 'Hindi, English, Maths-2, Science-2, Biology, Social Science', 'Dr K P Jaiswal Inter College, Allahabad', '', '1990-06-23', '391', '600', '65.16', '1', 'ssc', 'UP Board'),
('2017AP00128', 264, 'MSc', 'Phycology, Biochemistry, Microbiology, Physiology, Mycology, Ecology', 'Centre of Advanced Study in Botany', '1988-07-01', '1990-04-30', '665', '1000', '66.5', '1', 'pg', 'Banaras Hindu University'),
('2017AP00128', 265, 'BSc (Hons)', 'Botany, Zoology, Chemistry', 'Women\'s College (MMV)', '1985-07-01', '1988-04-30', '1031', '1800', '57', '2', 'ug', 'Banaras Hindu University'),
('2017AP00128', 266, 'AISSCE', 'Physics, Chemistry, Biology, Eng', 'KV Ishapore (WB)', '1984-07-01', '1985-04-30', '270', '400', '67.5', '1', 'hssc', 'CBSE'),
('2017AP00128', 267, 'AISSE', 'Maths, Sci, Soc stud, Eng, Hindi', 'KV Ishapore (WB)', '1982-07-01', '1983-04-30', '511', '750', '68', 'NA', 'ssc', 'CBSE'),
('2017AP00149', 271, 'Master of Business Administration', 'Organisational Theory and Behaviour ,MIS and Computer,Managerial Economics,Public Enterprise Management,Entrepreneurship and Small Business Management,Personnel Management,Production Management,Financial Management,Marketing Management,Management Accounting,Business PolicyBusiness Taxation and Tax Planning,Quantitative Techniques,Investment and Project Management,Financial Markets and Institutions.', 'MONIRBA (Motilal Nehru Institute of Research and Business Administration', '1994-07-01', '1996-07-01', '1499', '2200', '68.1%', '1', 'pg', 'University of Allahabad'),
('2017AP00149', 272, 'Bachelor of Commerce', 'Accountancy,Business Law,Business Economics and Public Finance,Indian Economy,Business Organisation,Currency Banking and Foreign Exchange,Taxation,Cost Accounting,,Auditing,Business Finance,Economic Development,Principles of Management,Statistics,Functional Management,Company Law and Labour Law,Public Enterprise and Government Business.', 'MONIRBA (Motilal Nehru Institute of Research and Business Administration', '1991-07-01', '1994-07-01', '1206', '1900', '63.5%', '1', 'ug', 'University of Allahabad'),
('2017AP00149', 274, 'HSSC', 'English, Hindi,Histoy,Structure of Modern Governments,,Economics.', 'St. Mary\'s Convent High School , Allahabad.', '1990-07-01', '1991-07-01', '310', '500', '62%', '1', 'hssc', 'ISE (Indian School Certificate)'),
('2017AP00149', 275, 'SSC', 'English, Hindi,Mathematics,Science,Economics,History Civic and Geography', 'St. Mary\'s Convent High School , Allahabad.', '1987-07-01', '1988-07-01', '320', '600', '53.3%', '2', 'ssc', 'ICSE ( Indian Certificate of Secondary Education)'),
('2017AP00158', 276, 'MASTER OF TECHNOLOGY', 'MATERIAL SCIENCE', 'MOTILAL NEHRU NATIONAL INSTITUTE OF TECHNOLOGY ALLAHABAD', '2002-07-31', '2004-08-30', '6.61', '10.0', '6.61', '1', 'pg', 'MOTILAL NEHRU NATIONAL INSTITUTE OF TECHNOLOGY ALLAHABAD'),
('2017AP00158', 278, 'BACHELOR OF TECHNOLOGY', 'MECHANICAL ENGINEERING', 'KAMLA NEHRU NATIONAL INSTITUTE OF TECHNOLOGY SULTANPUR', '1998-07-01', '2001-06-30', '2995', '4500', '66.5', '1', 'ug', 'DR. RAM MANOHAR LOHIA AVADH UNIVERSITY FAIZABAD'),
('2017AP00158', 279, 'INTERMEDIATE EXAMINATION', 'PCM GROUP', 'GOVERNMENT INTER COLLEGE BARABANKI', '1994-07-01', '1995-06-30', '281', '500', '56.2', '2', 'hssc', 'BOARD OF HIGH SCHOOL AND INTERMEDIATE EDUCATION U.P.'),
('2017AP00158', 280, 'HIGH SCHOOL EXAM', 'SCIENCE GROUP', 'GOVERNMENT INTER COLLEGE BARABANKI', '1990-01-01', '1991-07-30', '322', '600', '53.6', '2', 'ssc', 'BOARD OF HIGH SCHOOL AND INTERMEDIATE EDUCATION U.P.'),
('2017AP00159', 281, 'Masters of Science', 'Water Resources Engineering', 'University of Guelph', '2001-09-11', '2003-11-27', '490', '600', '81.66', '1', 'pg', 'University of Guelph'),
('2017AP00159', 282, 'Bachelors of Technology', 'Agricultural Engineering', 'Sam Higginbottom University of Agriculture, Technology and Sciences', '1997-08-20', '2001-06-30', '1012', '1200', '84.33%', '1', 'ug', 'Sam Higginbottom University of Agriculture, Technology and Sciences'),
('2017AP00159', 283, 'NA', 'Maths, Physics, Chemistry, English, Hindi', 'Crosthwaite Girls Inter College', '', '1997-06-30', '278', '500', '55.6', '2', 'hssc', 'U.P. Board'),
('2017AP00159', 284, 'NA', 'Maths, Science, Social Science, English, Hindi', 'Bethany Convent School and College', '', '1995-06-30', '350', '500', '70', '1', 'ssc', 'CBSE'),
('2017AP00167', 285, 'MASTER OF SCIENCE', 'CHEMISTRY', 'INDIAN INSTITUTE OF TECHNOLOGY, KANPUR', '1995-07-20', '1997-05-25', '7.8', '10', '7.8', 'NA', 'pg', 'INDIAN INSTITUTE OF TECHNOLOGY, KANPUR'),
('2017AP00167', 286, 'BACHELOR OF SCIENCE WITH HONOURS', 'CHEMISTRY', 'ST. XAVIER\'S COLLEGE, KOLKATA', '1992-07-31', '1995-07-15', '487', '800', '60.875', '1', 'ug', 'UNIVERSITY OF CALCUTTA'),
('2017AP00167', 287, 'HIGHER SECONDARY EXAMINATION', 'BENGALI, ENGLISH, PHYSICS, CHEMISTRY, MATHEMATICS, STATISTICS.', 'RAMAKRISHNA MISSION RESIDENTIAL COLLEGE, NARENDRAPUR.', '1990-07-28', '1992-07-22', '695', '1000', '69.5', '1', 'hssc', 'WEST BENGAL COUNCIL OF HIGHER SECONDARY EDUCATION'),
('2017AP00167', 288, 'SECONDARY EXAMINATION', 'BENGALI, ENGLISH, MATHEMATICS, PHYSICAL SCIENCE, LIFE SCIENCE, HISTORY, GEOGRAPHY, PHYSICAL EDUCATION, ADDITIONAL MATHEMATICS.', 'NARENDRAPUR R K MISSION VIDYALAYA', '1988-01-10', '1990-07-25', '688', '900', '76.44', '1', 'ssc', 'WEST BENGAL BOARD OF SECONDARY EDUCATION'),
('2017AP00169', 289, 'M.Com', 'Commerce', 'University of Allahabad', '1998', '2000', '707', '1000', '70.7', '1', 'pg', 'University of Allahabad'),
('2017AS03443', 290, 'M. Tech', 'COMPUTER SCIENCE & ENGINEERING', 'FACULTY OF CS & IT', '2005-01-10', '2007-01-10', '1399', '2200', '63.5', '1', 'pg', 'JRN RAJASTHAN VIDYAPEETH UNIVERSITY UDAIPUR'),
('2017AS03443', 291, 'MCA', 'COMPUTER APPLICATIONS', 'SIT MATHURA', '2001-08-10', '2004-06-30', '4852', '6000', '80.8', '1', 'pg', 'U P TECHNICAL UNIVERSITY LUCKNOW'),
('2017AS03443', 292, 'B.Sc.', 'PCM', 'VSSD COLLEGE KANPUR', '1997-07-10', '2000-06-30', '829', '1350', '61.4', '1', 'ug', 'CSJM KANPUR UNIVERSITY KANPUR'),
('2017AS03443', 293, '12th', 'PCM', 'SNS INTER COLLEGE SAMAN, MAINPURI', '1995-07-10', '1997-06-30', '350', '500', '70', '1', 'hssc', 'UP BOARD'),
('2017AS03443', 294, '10th', 'PCM', 'MKD INTER COLLEGE KUSHMARA, MAINPURI', '1993-07-10', '1995-06-30', '409', '600', '68.16', '1', 'ssc', 'UP BOARD'),
('2017AP00190', 295, 'Master of Engineering', 'Automated Manufacturing Systems', 'Birla Institute of Technology, Mesra, Ranchi', '2005-07-10', '2007-06-26', '8.35', '10', '83.50', '1', 'pg', 'Birla Institute of Technology, Mesra, Ranchi'),
('2017AP00190', 296, 'Bachelor of Technology', 'Mechanical Engineering', 'United College of Engineering and Research Allahabad', '2000-07-10', '2004-06-26', '3121', '5000', '62.42', '1', 'ug', 'Uttar Pradesh Technical University'),
('2017AP00190', 297, 'Intermediate', 'Mathematics', 'Government Inter College Sultanpur', '1997-07-10', '1998-06-14', '300', '500', '60', '1', 'hssc', 'Uttar Pradesh Board'),
('2017AP00190', 298, 'High School', 'Science', 'Government Inter College Sultanpur', '1995-07-10', '1996-06-15', '424', '600', '70.67', '1', 'ssc', 'Uttar Pradesh Board'),
('2017AP00046', 299, 'M. Tech.', 'Mechanical Engineering (Computer Aided Design and Manufacturing)', 'MNNIT Allahabad', '2001-07-25', '2005-07-16', '4039', '6000', '67.32', '1', 'pg', 'MNNIT Allahabad'),
('2017AP00046', 300, 'B.E.', 'Prooduction and Industrial Engineering', 'MNREC Allahabad', '1993-07-00', '1997-10-00', '3189', '5000', '63.78', '1', 'ug', 'University of Allahabad'),
('2017AP00046', 301, 'Intermediate', 'General Hindi, English, Physics, Chemistry, Mathematics', 'J. L. Nehru I. College Nyaipur Allahabad', '1989-07-00', '1991-07-00', '351', '500', '70.20', '1', 'hssc', 'U. P. Board'),
('2017AP00046', 302, 'High School', 'Hindi, English, Mathematics Two, Science Two, Biology, Social Science', 'J.L.N.I.C. Chaubara Nyaipur Allahabad', '1987-00-00', '1988-00-00', '375', '600', '62.50', '1', 'ssc', 'U. P. Board'),
('2017AP00196', 303, 'M.E.', 'Geotechnical Engineering', 'Annamalai University, Chadambaram', '1993-12-05', '1995-07-05', '1100', '1500', '73.33', '1', 'pg', 'Annamalai University, Chadambaram'),
('2017AP00196', 304, 'B.E.', 'Civil Engineering', 'Mohamed Sathak Engineering College, Kilakkarai', '1986-10-25', '1990-06-05', '4426', '5800', '76.33', '1', 'ug', 'Madurai Kamaraj University, Madurai'),
('2017AP00196', 306, 'HSC', 'Maths', 'Govt. Hr. Sec. School, Keeramangalam', '', '1986-04-25', '766', '1200', '63.83', '1', 'hssc', 'Board of Higher Secondary examinations, Tamilnadu'),
('2017AP00196', 307, 'SSLC', 'Maths', 'Govt. High School, Keeramangalam', '', '1984-04-30', '336', '500', '67.20', '1', 'ssc', 'Board of Secondary Education, Tamilnadu'),
('2017AS00671', 308, 'MTech', 'Communication Engineering', 'Indian Institute of Technology Bombay', '2000-07-17', '2002-01-24', '860', '1100', '7.82', '1', 'pg', 'Indian Institute of Technology Bombay'),
('2017AS00671', 309, 'Bachelor of Engieering', 'Electronics and Communication Engineering', 'Govind Ballabh Pant Engineering Coleege Pauri (Garhwal), Uttarakhand', '1996-07-15', '2000-05-15', '3662', '5000', '73.24', '1', 'ug', 'Hemwati Nandan Bahuguna Garhwal University, Uttarakhand'),
('2017AS00671', 310, 'Intermediate', 'Hindi, English, Maths, Physics, Chemistry', 'Maulana Azad Inter College Qadirabad, Siddharth Nagar, Uttar Pradesh', '1993-07-15', '1995-06-26', '391', '500', '78.2', '1', 'hssc', 'U.P. Board Allahabad'),
('2017AS00671', 311, 'High School', 'Hindi, English, Maths, Science, Biology, Social Science', 'Maulana Azad Inter College Qadirabad, Siddharth Nagar, Uttar Pradesh', '1991-07-15', '1993-07-13', '468', '600', '78.0', '1', 'ssc', 'U.P. Board Allahabad'),
('2017AP00202', 312, 'M.Tech', 'Water Resource Management', 'Motilal Nehru National Institute of Technology, Allahabad', '2002-07-01', '2004-07-23', '7.84', '10', '78.4', '1', 'pg', 'Motilal Nehru National Institute of Technology, Allahabad'),
('2017AP00202', 313, 'BE', 'Civil Engineering', 'North Maharashtra Univerity, Jalgaon', '1997-07-01', '2001-05-30', '963', '1500', '64.2', '1', 'ug', 'North Maharashtra Univerity, Jalgaon'),
('2017AP00202', 314, 'Higher Secondary', 'Physics, Chemistry, Mathematics', 'KV', '1994-06-01', '1995-05-30', '282', '500', '56.4', '2', 'hssc', 'CBSE'),
('2017AP00202', 315, 'Secondary School', 'Science', 'KV', '1992-06-01', '1993-06-05', '286', '500', '57.2', '2', 'ssc', 'CBSE'),
('2017AP00187', 316, 'M.B.A', 'HUMAN RESOURCE MANAGEMENT', 'HNB GARHWAL UNIVERSITY', '1998-07-01', '2000-08-04', '2027', '3200', '63.34', '1', 'pg', 'HNB GARHWAL UNIVERSITY'),
('2017AP00187', 317, 'B.A.(Honours)', 'Psychology', 'BANARAS HINDU UNIVERSITY', '1994-07-15', '1998-05-14', '574', '1000', '57.4', '2', 'ug', 'BANARAS HINDU UNIVERSITY'),
('2017AP00187', 318, 'INTERMEDIATE', 'GENERAL HINDI, ENGLISH,PHYSICS,CHEMISTRY,BIOLOGY', 'P N GOVT INTER COLLEGE', '1992-07-01', '1994-07-04', '260', '500', '52', '2', 'hssc', 'UP BOARD'),
('2017AP00152', 319, 'M.Tech', 'Electronics', 'Department of Electronics', '1996-09-15', '1998-07-18', '879', '1400', '62.78', '1', 'pg', 'Cochin University of Science and Technology,Kochi'),
('2017AP00152', 320, 'B.Tech', 'Electronics and Communication Engineering', 'JNTU College of Engineering, Anantapur', '1992-09-15', '1996-06-15', '2457', '4550', '54', '2', 'ug', 'Jawaharlal Nehru Technological University,Hydearabad'),
('2017AP00187', 321, 'HIGH SCHOOL', 'HINDI, ENGLISH, MATHEMATICS,SCIENCE,SOCIAL SCIENCE,BIOLOGY', 'P N GOVT INTER COLLEGE', '1990-07-01', '1992-07-27', '318', '600', '53', '2', 'ssc', 'UP BOARD'),
('2017AP00152', 322, 'Intermediate', 'Maths,Physics,Chemistry', 'Government Junior College,Tadepalligudem', '1989-06-15', '1991-04-30', '520', '1000', '52', '2', 'hssc', 'Board of Intermediate Education,Hyderabad'),
('2017AP00152', 323, 'SSC', 'Maths,General Science,Social Studies,English,Hindi,Telugu', 'Parishad High School,Tadepalli gudem,WG Dt,AP', '1988-06-15', '1989-03-31', '359', '600', '59.9', '2', 'ssc', 'Board of Secondary Education,Hyderabad'),
('2017AP00169', 324, 'B.Com', 'Commerce', 'University of Allahabad', '1995', '1998', '1191', '1900', '62.7', '1', 'ug', 'University of Allahabad'),
('2017AP00169', 327, 'Intermediate', 'Science (Maths group)', 'Goverenment Inter College, Allahabad', '1992', '1994', '221', '500', '44.2', '2', 'hssc', 'U.P. Board'),
('2017AP00169', 328, 'High School', 'Science Discipline', 'Goverenment Inter College, Allahabad', '1990', '1992', '294', '600', '49', '2', 'ssc', 'U.P. Board'),
('2017AP00206', 329, 'MSc', 'Applied Microbiology', 'Cancer Hospital & Research Institute', '2000-07-01', '2002-06-04', '802', '1200', '66.83', '1', 'pg', 'Jiwaji University, Gwalior'),
('2017AP00206', 330, 'BSc', 'Biology', 'Govt. Autonomous Model Science Colege', '1997-07-01', '2000-05-01', '1091', '1800', '60.61', '1', 'ug', 'Jiwaji University, Gwalior'),
('2017AP00206', 331, 'Higher Secondary', 'Physics, Chemistry, Biology', 'P.G.V. Higher Secondary School', '1996-07-01', '1997-03-01', '255', '450', '56.66', '2', 'hssc', 'M.P. Board, Bhopal'),
('2017AP00206', 332, 'High School', 'All mandatory', 'G.S. High School, Gwalior', '1994-07-01', '1995-03-01', '323', '500', '64.6', '1', 'ssc', 'M.P. Board, Bhopal'),
('2017AP00131', 333, 'M Tech', 'Engineering Materials', 'Maulana Azad National Institute of Technology Bhopal', '1999-09-20', '2002-10-22', '1618', '2000', '80.8', '1', 'pg', 'Maulana Azad National Institute of Technology Bhopal'),
('2017AP00131', 334, 'BE', 'Mechanical', 'Oriental Institute of Science and Technology Bhopal', '1995-09-07', '1999-07-30', '2112', '2600', '81.23', '1', 'ug', 'Barkat Ullah Vishvidhyalaya Bhopal'),
('2017AP00212', 335, 'M.Sc', 'Mathematics', 'Sri Venkateswara University, Tirupati', '', '2003-04-15', '685', '1000', '68.5%', '1', 'pg', 'Sri Venkateswara University, Tirupati'),
('2017AP00216', 336, 'Master of Engineering', 'Structural Engineering', 'University of Rooree (now IIT Roorkee)', '1995-08-01', '1997-03-26', '1408', '2000', '70.4', '1', 'pg', 'University of Rooree (now IIT Roorkee)');
INSERT INTO `education` (`user_id`, `id`, `degree`, `subject`, `inst_name`, `entry_date`, `complete_date`, `marks`, `max_marks`, `perc_marks`, `division`, `qualification`, `board`) VALUES
('2017AP00216', 338, 'Bachelor of Engineering', 'Civil Engineering', 'University of Roorkee (now IIT Roorkee)', '1990-08-01', '1994-05-31', '3241', '4800', '67.5%', '1', 'ug', 'University of Roorkee (now IIT Roorkee)'),
('2017AP00216', 339, 'Bachelor of Science', 'Physics, Chemistry, Maths', 'S. M. College, Chandausi', '1986-07-01', '1988-05-31', '520', '900', '57.8', '2', 'ug', 'Rohilkhand University, Bareilly'),
('2017AP00216', 340, 'Intermediate', 'Physics, Chemistry, Maths, English, Hindi', 'Chandausi Inter College, Chandausi', '1982-07-01', '1984-05-31', '232', '500', '46.4', '2', 'hssc', 'U. P. Board'),
('2017AP00216', 341, 'High School', 'Science, Maths, English, Hindi, Sanskrit', 'Chandausi Inter College, Chandausi', '1980-07-01', '1982-05-31', '278', '500', '55.6', '2', 'ssc', 'U. P. Board'),
('2017AP00126', 342, 'Master of Technology', 'Computer Science & Engineering', 'Guru Jambheshwar University of Science & Technology, Hisaar, Haryana', '2005-07-01', '2007-06-30', '1015', '1400', '72.5', '1', 'pg', 'Guru Jambheshwar University of Science & Technology, Hisaar, Haryana'),
('2017AP00126', 343, 'Bachelor of Technology', 'Information Technology', 'Haryana College of Technology and Management Kaithal', '2000-07-01', '2004-06-30', '3078', '5000', '61.5', '1', 'ug', 'Kurukshetra University Kurukshetra'),
('2017AP00126', 344, 'Ten Plus Two', 'Non Medical', 'DAV Sr. Sec. School Karnal Haryana', '1998-03-01', '1999-06-14', '256', '400', '64', '1', 'hssc', 'Board of School Education Haryana Bhiwani'),
('2017AP00126', 345, 'Tenth', 'General Subjects', 'Manas Model High School Karnal Haryana', '1996-03-01', '1997-06-30', '420', '600', '70', '1', 'ssc', 'Board of School Education Haryana Bhiwani'),
('2017AP00217', 346, 'Master of Business Administration', 'Management (Marketing)', 'Prestige Institute of Management & Research', '', '1997-07-16', '1603', '2600', '62%', '1', 'pg', 'Devi Ahilya Vishwavidyalaya, Indore'),
('2017AP00217', 347, 'Bachelor of Arts', 'English Literature, History, Political Science', 'Dr. Hari Singh Gour University, Sagar, MP', '', '1994-09-03', '1155', '1800', '64%', '1', 'ug', 'Dr. Hari Singh Gour University, Sagar, MP'),
('2017AP00217', 348, 'Senior School Certificate Examination', 'English, Computer Science, History, Political Science, Physical Education', 'Scindia Kanya Vidyalaya Gwalior', '', '1991-06-05', '326', '500', '65%', '1', 'hssc', 'CBSE'),
('2017AP00217', 349, 'Secondary School Examination', 'English, Sanskrit, Maths, Science, Social Science', 'Scindia Kanya Vidyalaya Gwalior', '', '1989-06-23', '324', '500', '65%', '1', 'ssc', 'CBSE'),
('2017AP00218', 350, 'Master of Technology', 'Integrated Electronics and Circuits', 'Indian Institute of Technology Delhi', '2002-07-21', '2005-08-13', '7.9', '10', '79', 'NA', 'pg', 'Indian Institute of Technology Delhi'),
('2017AP00218', 351, 'Bachelor of Engineering', 'Electrical Engineering', 'Indian Institute of Technology Roorkee', '1994-07-21', '1998-05-29', '80', '100', '80', '1', 'ug', 'Indian Institute of Technology Roorkee'),
('2017AP00218', 352, 'Indian School Certificate Exam', 'English, Hindi, Science', 'Boys High School and Intermediate College', '1991-04-01', '1993-03-31', '75', '100', '75', '1', 'hssc', 'ICSE New Delhi'),
('2017AP00218', 354, 'Indian Certificate of Secondary Education Examination', 'English, Hindi, Science', 'Boys High School, Allahabad', '1989-04-01', '1991-03-31', '70', '100', '70', '1', 'ssc', 'ICSE New Delhi'),
('2017AP00221', 357, 'M.E.', 'Mechanical (Thermal Engineering)', 'University of Roorkee', '1998-07-29', '2000-03-31', '1355', '2000', '67.8', '1', 'pg', 'University of Roorkee'),
('2017AP00221', 358, 'B.E.', 'Mechanical Engineering', 'T.I.E.T., Patiala', '1993-07-16', '1997-07-29', '5.17', '10', '5.17', '2', 'ug', 'T.I.E.T., Patiala'),
('2017AP00221', 359, '10+2', 'Non Medical', 'Govt. College for Men, Chandigarh', '1991-08-01', '1993-06-30', '227', '450', '50.4', '2', 'hssc', 'PSEB'),
('2017AP00221', 360, 'Matric', 'General', 'Govt. Model High School, Sec-19, Chandigarh', '1989-04-01', '1990-03-31', '288', '500', '57.6', '2', 'ssc', 'CBSE'),
('2017AP00222', 361, 'Master in Engineering (M.E)', 'Design of Process Machines', 'Motilal Nehru Regional Engineering College Allahabad', '1994-07-01', '1999-04-07', '3775', '5600', '67.4', '1', 'pg', 'U.P.'),
('2017AP00222', 362, 'B.E.', 'Mechanical Engineering', 'Madan Mohan Malviya Engineering College Gorakhpur', '1990-07-01', '1994-06-30', '4342', '6000', '72.4', '1', 'ug', 'Gorakhpur University'),
('2017AP00222', 363, 'Intermediate', 'SCIENCE (PCM)', 'Queens College Varanasi', '1987-07-01', '1989-06-03', '336', '500', '67.2', '1', 'hssc', 'U.P.'),
('2017AP00222', 364, 'High School', 'SCIENCEs', 'LBS Higher SEcondary School, Hazara, Pilibhit', '1985-07-01', '1987-06-02', '437', '600', '67.4', '1', 'ssc', 'U.P.'),
('2017AP00211', 365, 'M.Tech', 'Electronics System and Communication', 'National Institute of Technology, Rourkela', '2002-08-18', '2004-06-25', '1828', '2500', '73%', 'NA', 'pg', 'National Institute of Technology, Rourkela'),
('2017AP00211', 369, 'BE', 'Electronics and Telecommunication Engineering', 'Odisha Engineeering College', '', '1990-05-24', '1921', '2800', '68%', '1', 'ug', 'Utkal University, Odisha'),
('2017AP00211', 370, '+2', 'Science (Physics, Chemistry, Math)', 'College of Basic science and Humanities, Bhubaneswar', '', '1990-03-19', '563', '900', '62%', '1', 'hssc', 'Council of Higher Secondary Education, Odisha'),
('2017AP00211', 371, '10th', 'All Subjects', 'Utkal University High School, Bhubaneswar', '', '1988-04-06', '521', '700', '72%', '1', 'ssc', 'Board of Secondary Education, Odisha'),
('2017AP00226', 372, 'ME', 'Chemical Engineering', 'IISc Bangalore', '2001-07-27', '2003-01-31', '5.6/8.0', '7.0/8.0', '5.6/8.0', '2', 'pg', 'IISc Bangalore'),
('2017AP00226', 374, 'B.Tech.', 'Chemical Engineering', 'HBTI Kanpur', '1997-07-21', '2001-05-31', '6943/10000', '85/100', '69.43', '1', 'ug', 'CSJMU, Kanpur'),
('2017AP00226', 375, 'Intermediate', 'Hindi, English, Physics, Chemistry, Mathematics', 'Govt City Inter College Ghazipur', '1995-07-01', '1996-05-31', '321/500', '71', '64.2', '1', 'hssc', 'U.P. Board'),
('2017AP00226', 376, 'High School', 'Hindi, English, Science two, Biology, Mathematics two, Social Science', 'Govt City Inter College Ghazipur', '1993-07-01', '1994-05-31', '377/600', '67', '62.83', '1', 'ssc', 'U.P. Board'),
('2017AP00219', 377, 'M.Tech.', 'Instrumentation and control Engineering', 'APEEJAY, Gurgoan', '2006-07-04', '2008-09-03', '70', '75', '72.5', '1', 'pg', 'M.D. University, Rohtak'),
('2017AP00219', 378, 'B.E.', 'Electronics Engineering', 'B.D.C.O.E., Sewagram', '1993-06-05', '1998-01-12', '772', '1250', '61.76', '1', 'ug', 'Nagpur University'),
('2017AP00219', 379, '12th', 'Phy Che Maths', 'Govt. H S S Soorwari', '1988-05-04', '1990-06-05', '473', '800', '59.12', '2', 'hssc', 'M.P. Board, Bhopal'),
('2017AP00219', 380, '10th', 'Phy Che Maths', 'Govt. H S S Soorwari', '1986-04-02', '1988-06-01', '387', '650', '59.53', '2', 'ssc', 'M.P. Board, Bhopal'),
('2017AP00207', 385, 'M.E(CSE)', 'COMPUTER SCIENCE AND ENGINEERING', 'REGIONAL ENGINEERING COLLEGE,ROURKELA', '2000-08-07', '2002-01-31', '1219', '2000', '60.95', 'NA', 'pg', 'SAMBALPUR UNIVERSITY'),
('2017AP00207', 386, 'B.E(CSE)', 'COMPUTER SCIENCE AND ENGINEERING', 'OSMANIA UNIVERSITY ENGINEERING COLLEGE', '1993-07-19', '1997-07-28', '2512', '3250', '77.29', '1', 'ug', 'OSMANIA UNIVERSITY'),
('2017AP00207', 387, 'INTERMEDIATE', 'MATHS, PHYSICS, CHEMISTRY', 'S V JUNIOR COLLEGE', '1988-07-18', '1990-12-24', '737', '1000', '73.7', 'NA', 'hssc', 'BOARD OF INTERMEDIATE EDUCATION'),
('2017AP00207', 388, 'SSC', 'MATHS, SCIENCE , SOCIAL, TELUGU, ENGLISH, HINDI', 'A.B.M.H.SCHOOL', '1987-07-06', '1988-05-30', '341', '600', '56.83', '2', 'ssc', 'SECONDARY SCHOOL BOARD'),
('2017AP00235', 389, 'M. Tech', 'COMPUTER SCIENCE & ENGINEERING', 'FACULTY OF CS & IT', '2005-01-10', '2007-01-10', '1399', '2200', '63.5', '1', 'pg', 'JRN RAJASTHAN VIDYAPEETH UNIVERSITY UDAIPUR'),
('2017AP00235', 390, 'MCA', 'COMPUTER APPLICATIONS', 'SIT MATHURA', '2001-08-10', '2004-06-30', '4852', '6000', '80.8', '1', 'pg', 'U P TECHNICAL UNIVERSITY LUCKNOW'),
('2017AP00117', 391, 'MBA', 'Marketing', 'Dayand academy of management studies, kanpur', '1999-07-01', '2001-10-04', '2716', '3800', '71.4', '1', 'pg', 'Kanpur University'),
('2017AP00235', 392, 'B.Sc.', 'PCM', 'VSSD COLLEGE KANPUR', '1997-08-10', '2000-06-30', '829', '1350', '61.4', '1', 'ug', 'CSJM KANPUR UNIVERSITY KANPUR'),
('2017AP00235', 393, '12th', 'PCM', 'SNS INTER COLLEGE SAMAN, MAINPURI', '1995-08-10', '1997-06-30', '350', '500', '70', '1', 'hssc', 'UP BOARD'),
('2017AP00235', 394, '10th', 'PCM', 'MKD INTER COLLEGE KUSHMARA, MAINPURI', '1993-08-10', '1995-06-30', '409', '600', '68.16', '1', 'ssc', 'UP BOARD'),
('2017AP00117', 395, 'B.Sc', 'Physics, Maths', 'V.S.S.D college Kanpur', '1994-07-01', '1997-06-14', '866', '1350', '64.18', '1', 'ug', 'Kanpur University'),
('2017AP00117', 396, '12', 'Physics, Maths,chem,biology,english', 'KV I.I.T Kanpur', '1992-07-01', '1993-05-31', '308', '600', '61.6', '1', 'hssc', 'CBSE'),
('2017AP00117', 397, '10', 'Eng, Hindi, science, social science,maths', 'KV I.I.T Kanpur', '1990-07-01', '1991-06-12', '370', '500', '74', '1', 'ssc', 'CBSE'),
('', 398, 'MASTERS of CIVIL ENGINE ERING.', 'ENVIRONMENTAL ENGG', 'IIT, ROORKEE( FORMERLY (UOR)', '1979-08-01', '1981-10-30', '3.25', '4.00', '78.16', '1', 'pg', 'UNIVERSITY of ROOKEE, ROORKEE'),
('2017AP00239', 399, 'MASTERS of CIVIL ENGINE ERING.', 'ENVIRONMENTAL ENGG', 'IIT, ROORKEE( FORMERLY (UOR)', '1979-08-01', '1981-10-30', '3.25', '4.00', '78.16', '1', 'pg', 'UNIVERSITY of ROOKEE, ROORKEE'),
('2017AP00239', 400, 'Graduation', 'Civil Engineering', 'MADAN MOHAN MALAVIYA UNIVERSITY of TECHNOLOGY', '1975-07-30', '1979-07-11', '3781.00', '4863.00', '77.75', '1', 'ug', 'FORMERLY M.M.M. ENGINEERING COLLEGE, UNIVERSITY of GORAKHPUR, GORAKHPUR'),
('2017AP00239', 403, 'HSSC (12th)- Higher Second ary School Examination', 'PHYSICS, CHEMISTRY, MATHS', 'RAJKIYA HIGHER SECONDARY SCHOOL', '1972-07-15', '1974-06-30', '323', '500', '64.60', '1', 'hssc', 'U.P. EDUCATION BOARD'),
('2017AP00239', 404, 'SSC (10th)- High School', 'Science', 'RAJKIYA SECONDARY SCHOOL', '1969-09-30', '1972-06-30', '323', '500', '64.60', '1', 'ssc', 'U.P. EDUCATION BOARD'),
('2017AP00027', 405, 'M. Tech.', 'Chemical Engineering', 'IIT Roorkee', '2001-07-01', '2003-01-01', '7', '10', '70%', '1', 'pg', 'IIT Roorkee'),
('2017AP00027', 408, 'B.Tech.', 'Chemical Engineering', 'BIET Jhansi', '1996-07-01', '2000-06-01', '3734', '5000', '74.68%', '1', 'ug', 'Bundelkhand University'),
('2017AP00077', 412, 'Master of Engineering', 'Structural Engineering', 'Bengal Engineering College', '1999 July', '2001 January', '1494', '1800', '83', '1', 'pg', 'Bengal Engineering College'),
('2017AP00077', 413, 'Bachelor of Engineering', 'Civil Engineering', 'Bengal Engineering College', '1995 July', '1999 May', '3253', '4500', '72.3', '1', 'ug', 'Bengal Engineering College'),
('2017AP00077', 414, 'Higher Secondary', 'Science Stream', 'Nayabasat Parbatimoyee Sikshaniketan', '1993 July', '1995 April', '699', '1000', '69.9', '1', 'hssc', 'West Bengal Council of Higher Secondary Education'),
('2017AP00077', 415, 'Secondary', 'General Stream', 'Baital Gopeswar Pal Vidyapith', '', '1993 March', '657', '900', '73', '1', 'ssc', 'West Bengal Board of Secondary Education'),
('2017AP00177', 416, 'M.Tech', 'Power System', 'N.I.T. Kurukshetra (Formmer REC), Kurukshetra', '1990-01-10', '1995-09-20', '1206', '2000', '60.3', '1', 'pg', 'Kurukshetra University'),
('2017AP00177', 420, 'B.E.', 'Electrical Engineering', 'M M M Engineering College, Gorakhpur (MMM University & Technology), U P', '1984-07-15', '1988-07-17', '4115', '6000', '68.58', '1', 'ug', 'Gorakhpur University'),
('2017AP00177', 422, 'Intermediate Examination', 'Physics, Chemistry, Maths, English, Hindi', 'Nationnal Inter College, Barahalganj, Gorakhpur', '1980-07-01', '1982-06-14', '286', '500', '57.2', '2', 'hssc', 'U.P. Board, Allahabad'),
('2017AP00177', 423, 'High School Examination', 'Science, Maths, English, Hindi, Sanskrit', 'Nationnal Inter College, Barahalganj, Gorakhpur', '1978-07-01', '1980-07-1980', '326', '500', '65.2', '1', 'ssc', 'U.P. Board, Allahabad'),
('2017AP00238', 424, 'M. Tech.', 'CHEMICAL ENGINEERING', 'IIT DELHI', '2001-07-21', '2002-12-31', '6.846', '10', '6.846', 'NA', 'pg', 'IIT DELHI'),
('2017AP00238', 425, 'B. TECH.', 'CHEMICAL ENGINEERING', 'H.B.T.I.Kanpur', '1997-09-08', '2001-05-31', '6673', '10000', '66.73', '1', 'ug', 'C.S.J.M. UNIVERSITY, KANPUR'),
('2017AP00238', 426, 'INTERMEDIATE', 'HINDI, ENGLISH, MATHEMATICS, PHYSICS, CHEMISTRY', 'LAKHORI INTER COLLEGE LAKHORI MORADABAD', '1996-07-01', '1997-05-31', '318', '500', '63.60', '1', 'hssc', 'U.P. BOARD, ALLAHABAD'),
('2017AP00238', 428, 'HIGH SCHOOL', 'HINDI, ENGLISH, MATHEMATICS -2, SCIENCE -2, BIOLOGY, SOCIAL SCIENCE', 'LAKHORI INTER COLLEGE LAKHORI MORADABAD', '1994-07-01', '1995-05-31', '432', '600', '72.00', '1', 'ssc', 'U.P. BOARD, ALLAHABAD'),
('2017AP00247', 429, 'M.Sc.', 'Geology', 'Department of Geology', '1990-08-01', '1992-09-10', '1710', '2250', '76', '1', 'pg', 'Banaras Hindu University, Varanasi'),
('2017AP00247', 431, 'B.Sc.', 'Geology', 'Department of Geology', '1987-08-01', '1990-07-02', '1142', '1800', '63.44', '1', 'ug', 'Banaras Hindu University, Varanasi'),
('2017AP00247', 434, 'Intermediate', 'General Hindi, English, Biology, Physics, Chemistry', 'PN Govt. Inter College Ramnagar, Varanasi', '1985-08-01', '1987-06-20', '281', '500', '56.2', '2', 'hssc', 'U.P.Board'),
('2017AP00247', 435, 'High School', 'Hindi', 'SBBPHS Jafarpura, Mirzapur', '1983-07-01', '1985-06-20', '301', '600', '50.06', '2', 'ssc', 'U.P.Board'),
('2017AP00252', 445, 'M.Tech.', 'CHEMICAL ENGINEERING', 'HBTI KANPUR', '2003-07-01', '2005-07-31', '3.5', '4.0', '87.5', '1', 'pg', 'UPTU LUCKNOW'),
('2017AP00236', 447, 'M.Sc.', 'Biochemistry', 'Gobind Ballabh Pant University of Agriculture and Technology', '1987-08-01', '1990-08-01', '4.064', '5.0', '75.96', '1', 'pg', 'University'),
('2017AP00024', 448, 'Secondary', 'General', 'Garhbeta High School', '1991-06-03', '1993-03-26', '540', '900', '60.0', '1', 'ssc', 'W.B.B.S.E'),
('2017AP00236', 449, 'B.Sc.', 'Zoology, Botany and Chemistry', 'Almora Constituent College, Kumaun University', '1985-07-08', '1987-06-29', '545.0', '900.0', '60.555', '1', 'ug', 'Kumaun University, Nainital, UK'),
('2017AP00236', 450, 'Intermediate', 'English, Hindi, Chemistry, Physics, Biology', 'G.G.I.C Almora', '1983-08-08', '1985-06-28', '288', '500', '57.6', '2', 'hssc', 'U.P. Board'),
('2017AP00236', 451, 'High School', 'Hindi, English, Maths, Science, Biology', 'G.G.I.C Almora', '1982-07-08', '1983-06-16', '303', '500', '60.6', '1', 'ssc', 'U.P. Board'),
('2017AP00025', 452, 'Higher Secondary', 'Science', 'Garhbeta College', '1993-06-07', '1995-04-14', '683', '1000', '68.3', '1', 'hssc', 'W.B.C.H.S.E'),
('2017AP00025', 453, 'Secondary', 'General', 'Garhbeta High School', '1991-06-03', '1993-03-26', '540', '900', '60.0', '1', 'ssc', 'W.B.B.S.E'),
('2017AP00069', 454, 'Masters of Arts', 'Psychology', 'Allahabad University', '1978-07-07', '1980-05-30', '586', '1000', '58.6', '2', 'pg', 'Allahabad University'),
('2017AP00069', 455, 'Bachelors of Arts', 'English Literature, Psychology, Ancient History', 'Allahabad University', '1976-07-07', '1978-05-30', '571', '900', '63.4', '1', 'ug', 'Allahabad University'),
('2017AP00069', 456, 'Intermediate', 'Hindi, English, History, Psychology, Civics', 'St. Mary\'s Convent Inter College', '1974-07-07', '1976-05-30', '295', '500', '59', '2', 'hssc', 'Board of High School and Intermediate Education UP'),
('2017AP00260', 458, 'M.Tech', 'Communication Engg.', 'IIT Kanpur', '2002-07-15', '2004-07-15', '7.75', '10', '7.75', 'NA', 'pg', 'IIT Kanpur'),
('2017AP00260', 459, 'B.E', 'Electronics Engineering', 'Madam Mohan Malviya Engineering College, Gorakhpur', '1993-06-30', '1997-07-01', '4128', '6000', '68.8', '1', 'ug', 'Gorakhpur University'),
('2017AP00260', 460, 'Intermediate', 'Physics,Chemistry,Math', 'G.T.D.Inter College, Padrauna', '1990-07-03', '1992-07-17', '340', '500', '68', '1', 'hssc', 'U.P Board'),
('2017AP00260', 461, 'High School', 'Math, Science, English', 'G.T.D.Inter College, Padrauna', '1988-07-01', '1990-07-02', '407', '600', '67.7', '1', 'ssc', 'U.P Board'),
('2017AP00250', 462, 'M.Tech', 'Computer Science and Engineering', 'MNNIT Allahabad', '2006-07-25', '2009-07-10', '9.25', '10', '9.25', '1', 'pg', 'MNNIT Allahabad'),
('2017AP00250', 463, 'B.Tech', 'Computer Science and Engineering', 'BIET Jhansi', '1997-08-08', '2001-06-25', '3485', '5000', '69.7', '1', 'ug', 'Bundelkhand University'),
('2017AP00250', 464, 'Intermediate', 'PCM', 'Radha Valabh Inter College', '1996-06-10', '1997-06-10', '336', '500', '67.2', '1', 'hssc', 'UP Board'),
('2017AP00250', 465, 'High School', 'Science', 'Radha Valabh Inter College', '1994-06-20', '1995-06-10', '443', '600', '73.8', '1', 'ssc', 'UP Board'),
('2017AP00261', 466, 'M.Tech.', 'Production Engineering', 'MNNIT Allahabad', '2001-07-16', '2003-05-15', '4889', '6000', '81.48', '1', 'pg', 'MNNIT Allahabad'),
('2017AP00261', 467, 'B.Tech.', 'Mechanical Engineering', 'BIET Jhansi', '1996-07-22', '2000-05-19', '3331', '5000', '66.62', '1', 'ug', 'Bundelkhand University'),
('2017AP00261', 468, 'Intermediate', 'PCM', 'MBIC Lucknow', '1993-07-08', '1995-05-20', '383', '500', '76.6', '1', 'hssc', 'UP Board'),
('2017AP00261', 469, 'Highschool', 'PCM', 'MBIC Lucknow', '1991-04-05', '1993-05-12', '494', '600', '82.3', '1', 'ssc', 'UP Board'),
('2017AP00201', 474, 'M.Sc.', 'Mathematics', 'DDU Gorakhpur University, Gorakhpur', '', '1999-10-19', '1030', '1300', '79.23', '1', 'pg', 'DDU Gorakhpur University, Gorakhpur'),
('2017AP00201', 476, 'B.Sc.', 'Chemistry, Physics, Mathematics', 'SPDC Shohratgarh Siddharthnagar', '', '1997-10-11', '1294', '1800', '71.89', '1', 'ug', 'DDU Gorakhpur University, Gorakhpur'),
('2017AP00201', 477, 'Intermediate', 'G.Hindi, English, Maths, Physics, Chemistry', 'S A J I C Anand Nagar Maharajganj', '', '1994-07-05', '317', '500', '63.40', '1', 'hssc', 'UP Board Allahabad'),
('2017AP00201', 479, 'High School', 'Hindi English, Maths-2, Science-2, Biology, Social Science', 'Govt. Inter College Paniara Maharajganj', '', '1992-07-15', '398', '600', '66.33', '1', 'ssc', 'UP Board Allahabad'),
('2017AP00262', 480, 'M.Com', 'Financial accounting , Direct Taxes , Management Of Public Enterprises , Dissertation , Viva', 'Hindu College , Moradabad', '', '2000-09-13', '666', '900', '74 %', '1', 'pg', 'M. J. P Rohilkhand University , Bareilly'),
('2017AP00262', 481, 'B.Com', 'Quantitative Analysis , Business Adminis tration', 'Hindu College , Moradabad', '', '1998-07-01', '515', '900', '57.2 %', '2', 'ug', 'M. J. P Rohilkhand University , Bareilly'),
('2017AP00253', 483, 'ME', 'THERMAL ENGG', 'NIT SURAT', '2002-07-01', '2004-06-30', '7.10', '10', '71', '1', 'pg', 'NIT SURAT'),
('2017AP00262', 484, 'XII', 'English Core , Accountancy , Economics , Business Studies , Home', 'K.C.M. School , Civil Lines Moradabad', '', '1995-05-30', '360', '500', '72 %', '1', 'hssc', 'Central Board Of Secondary Education'),
('2017AP00253', 486, 'INTERMEDIATE', 'SCIENCE -MATH', 'JANTA JANARDAN COLLEGE BHURKURA MIRZAPUR', '1995-07-01', '1997-05-30', '301', '500', '60', '1', 'hssc', 'UPB ALLAHABAD'),
('2017AP00262', 487, 'X', 'English Course -A , Hindi Course - A , Maths, Science with Practical , Social Science ,', 'St, Mary\'s Sr. Secondary School , Moradabad', '', '1993-06-05', '260', '500', '52 %', '2', 'ssc', 'Central Board Of Secondary Education'),
('2017AP00253', 488, 'BE', 'MECHANICAL ENGG', 'NIT SURAT', '1998-07-10', '2002-05-30', '1219', '1800', '67.60', '1', 'ug', 'SOUTH GUJARAT UNIVERSITY'),
('2017AP00253', 489, 'HIGH SCHOOL', 'SCIENCE', 'JANTA JANARDAN COLLEGE BHURKURA MIRZAPUR', '1993-07-01', '1995-05-30', '394', '600', '66.00', '1', 'ssc', 'UPB ALLAHABAD'),
('2017AP00185', 490, 'M.Phil.', 'Botany', 'University of Delhi', '1998-07-01', '1999-06-30', '470', '600', '78.3', '1', 'pg', 'University of Delhi'),
('2017AP00185', 491, 'M.Sc.', 'Botany', 'JV College Baraut', '1996-07-01', '1998-06-30', '627', '900', '69.3', '1', 'pg', 'CCS University Meerut'),
('2017AP00185', 492, 'B.Sc.', 'Zoology, Botany, Chemistry', 'JV College Baraut', '1993-07-01', '1996-06-30', '1161', '1450', '80.1', '1', 'ug', 'CCS University Meerut'),
('2017AP00185', 493, 'Intermediate', 'Biology', 'JV Inter College', '1991-07-01', '1993-06-30', '369', '500', '73.8', '1', 'hssc', 'U.P. Board Allahabad'),
('2017AP00185', 495, 'High School', 'Biology', 'JV Inter College Baraut', '1989-07-01', '1991-06-30', '438', '600', '73', '1', 'ssc', 'U.P. Board Allahabad'),
('2017AP00199', 496, 'MBA', 'MARKETING', 'DEPARTMENT OF BUSINESS ADMINISTRATION UNIVERSITY OF LUCKNOW', '1996-09-01', '1999-10-22', '1718', '2600', '66', '1', 'pg', 'UNIVERSITY OF LUCKNOW'),
('2017AP00199', 497, 'BSc', 'SCIENCE', 'KKC', '1982-09-01', '1984-09-01', '481', '900', '53', '2', 'ug', 'UNIVERSITY OF LUCKNOW'),
('2017AP00199', 498, 'INTERMEDIATE', 'SCIENCE', 'KKV', '1979-07-01', '1981-07-01', '256', '500', '51', '2', 'hssc', 'UP BOARD'),
('2017AP00199', 499, 'HIGH SCHOOL', 'SCIENCE', 'GIC', '1978-07-01', '1979-07-01', '293', '500', '58', '2', 'ssc', 'UP BOARD'),
('2017AP00265', 503, 'M.Tech', 'Digital Systems', 'MNNIT,Allahabad', '2004-07-12', '2006-08-08', '10 CPI', '7.12 CPI', '67.46%', '1', 'pg', 'MNNIT,Allahabad'),
('2017AP00265', 504, 'BE', 'Electronics & Telecommunication Engineering', 'JTM College of Engineering,Faizpur, Jalgaon', '1993-07-22', '1999-06-04', '961', '1500', '64.06', '1', 'ug', 'NMU,Jalgaon(MS)'),
('2017AP00265', 505, '12', 'PCM', 'GOVT.RAZA I C ,RAMPUR', '1991-07-22', '1992-07-06', '300', '500', '60', '1', 'hssc', 'UP Board ,Allahabad'),
('2017AP00265', 506, '10', 'Science', 'GOVT. BAQAR H. S. School, Rampur', '1988-07-08', '1989-06-15', '268', '600', '44.6%', 'NA', 'ssc', 'UP Board ,Allahabad'),
('2017AP00270', 507, 'Master of Engineering', 'Digital System', 'Motilal Nehru regional Engineering College, Allahabad', '1999-07-16', '2001-02-16', '3986', '5600', '71.18', '1', 'pg', 'Allahabad University'),
('2017AP00270', 508, 'B. E.', 'Electronics', 'Motilal Nehru regional Engineering College, Allahabad', '1989-07-20', '1994-06-17', '5560', '10000', '55.6', '2', 'ug', 'Allahabad University'),
('2017AP00270', 509, 'hssc', 'Mathematics, Physics, chemistry', 'DHSK College, Dibrugarh, Assam', '1987-04-22', '1988-05-25', '544', '1000', '54.4', '2', 'hssc', 'Assam Higher secondary education council'),
('2017AP00270', 510, 'SSC', 'Mathematics, Science', 'Marwari Hindi High School, Dibrugarh, Assam', '1985-04-25', '1986-08-04', '600', '750', '80.0', '1', 'ssc', 'Board of secondary education, Assam'),
('2017AP00065', 511, 'M.Tech.', 'Computer Aided Design and Manufacturing', 'Motilal Nehru National Institute of Technology Allahabad', '2002-07-22', '2004-06-24', '10', '10', '100', '1', 'pg', 'Motilal Nehru National Institute of Technology Allahabad'),
('2017AP00065', 512, 'B.E.', 'Mechanical Engineering', 'Motilal Nehru Regional Engineering College, Allahabad', '1998-07-20', '2002-05-10', '4437', '5000', '88.74', '1', 'ug', 'University of Allahabad'),
('2017AP00065', 513, 'Intermediate', 'Mathematics', 'Colonelganj Intermediate College, Allahabad', '1995-07-24', '1997-04-28', '348', '500', '69.6', '1', 'hssc', 'U. P. Board'),
('2017AP00065', 514, 'High School', 'Science', 'Colonelganj Intermediate College, Allahabad', '1993-07-26', '1995-04-24', '466', '600', '77.67', '1', 'ssc', 'U. P. Board'),
('', 517, 'Class 12th', 'Physics, Chemistry, Maths, English, Hindi', 'A.M.I. Shishu Mandir, Gwalior', '', '1995-03-31', '310', '450', '68.88', '1', 'hssc', 'Madhya Pradesh Board'),
('2017AP00275', 518, 'MASTER OF BUSINESS ADMINISTRATION', 'General Management', 'Indian Institute of Information Technology & Management, Gwalior, India', '', '2002-05-11', '8.57', '10', '85.7', 'NA', 'pg', 'Indian Institute of Information Technology & Management, Gwalior, India'),
('2017AP00275', 519, 'BACHELOR OF ENGINEERING', 'Mechanical', 'Madhav Institute of Technology & Science, Gwalior', '', '2000-06-30', '1780', '2400', '74.16', '1', 'ug', 'Jiwaji University, Gwalior'),
('2017AP00275', 520, 'Class 12th', 'Physics, Chemistry, Maths, English, Hindi', 'A.M.I. Shishu Mandir, Gwalior', '', '1995-03-31', '310', '450', '68.88', '1', 'hssc', 'Madhya Pradesh Board'),
('2017AP00275', 521, 'Class 10th', 'Science, Maths, English, Hindi, Social Science, Sanskrit', 'A.M.I. Shishu Mandir, Gwalior', '', '1993-03-31', '474', '650', '72.92', '1', 'ssc', 'Madhya Pradesh Board'),
('2017AP00278', 522, 'M.E.', 'Production Technology', 'Jadavpur University', '2001-07-01', '2003-06-30', '1212', '1400', '86.66', '1', 'pg', 'Jadavpur University'),
('2017AP00278', 523, 'B.Tech.', 'Mechanical Engineering', 'Kalyani Engineering College (Govt.)', '1995-07-01', '1999-06-30', '3749', '4950', '75.73', '1', 'ug', 'Kalyani University'),
('2017AP00248', 524, 'M.Tech', 'Electronic Circuits and Systems/ Electronics and Communication Engineering', 'Integral University Lucknow', '2006-08-01', '2009-06-19', '1784', '2250', '79.28%', '1', 'pg', 'Integral University Lucknow'),
('2017AP00248', 526, 'M.Sc', 'Electronics', 'DAV College, Kanpur', '2000-06-12', '2002-09-11', '786', '1200', '65.5%', '1', 'pg', 'CSJM University, Kanpur'),
('2017AP00278', 527, 'Higher Secondary', 'Science', 'Ramsagar High School', '1992-04-01', '1994-03-31', '738', '1000', '73.80', '1', 'hssc', 'West Bengal Council of Higher Secondary Education'),
('2017AP00248', 528, 'B.Sc', 'Physics', 'DAV College, Kanpur', '1995-08-21', '1998-07-19', '723', '1350', '53.5%', '2', 'ug', 'CSJM University, Kanpur'),
('2017AP00278', 529, 'Madhyamik', 'BENGALI, ENGLISH, PHY SC., BIOLOGY, MATHEMATICS, HISTORY, GEOGRAPHY, PHY EDU., PHYSICS', 'Ramsagar High School', '1990-04-01', '1992-03-31', '689', '900', '76.54', 'NA', 'ssc', 'West Bengal Board of Secondary Education'),
('2017AP00110', 531, 'Bachelor of Engineering', 'Civil Engineering', 'Rewa Engineering College, Rewa', '1996-07-31', '2001-12-04', '1984', '2450', '81', '1', 'ug', 'A.P.S University, Rewa'),
('2017AP00110', 532, 'XII [10+2]', 'Higher Mathematics, Physics, Chemistry, English, Hindi', 'Jyoti School Rewa, (M.P)', '', '1996-05-25', '390', '450', '86.67', '1', 'hssc', 'M.P. Board'),
('2017AP00110', 533, 'X [10]', 'Maths, Science, So. Studies, English, Hindi, Sanskrit', 'Jyoti School Rewa, (M.P)', '', '1994-07-08', '491', '650', '75.5', '1', 'ssc', 'M.P. Board'),
('2017AP00251', 534, 'M.Sc.', 'Computer Science', 'University of Allahabad', '', '2003-03-25', '1920', '2800', '68.6', '1', 'pg', 'University of Allahabad'),
('2017AP00251', 535, 'B.Sc', 'Physics, Math, Comp Maint', 'University of Allahabad', '', '2000-09-10', '785', '1350', '58.1', '2', 'ug', 'University of Allahabad'),
('2017AP00251', 536, 'Indian School Certificate', 'Phy, Chem, Math, Eng, Hindi', 'St. Joseph\'s College, Allahabad', '', '1996-03-01', '367', '500', '73.4', '1', 'hssc', 'ICSE'),
('2017AP00251', 537, 'Indian Certificate of Secondary Education', 'Phy, Math, Science, Comp Sc., Social Science', 'St. Joseph\'s College, Allahabad', '', '1994-03-01', '385', '500', '77', '1', 'ssc', 'ICSE'),
('2017AP00233', 538, 'MASTER IN BUSINESS ADMINISTRATION', 'MANAGEMENT CONCEPTS, MANAGERIAL ECONOMICS AND TOTAL 24 SUBJECTS IN FOUR SEMESTERS.', 'SOS IN COMMERCE AND MANAGEMENT GWALIOR ,M.P.', '1992-07-01', '1994-08-23', '1780', '2600', '68.4', '1', 'pg', 'JIWAJI UNIVERSITY, GWALIOR,M.P.'),
('2017AP00233', 539, 'BACHELOR OF SCIENCE', 'PHYSICS, CHEMISTRY, MATHEMATICS', 'SARASWATI DEGREE COLLEGE ,HATHRAS', '1988-07-01', '1991-06-26', '1221', '1400', '87.2', '1', 'ug', 'AGRA UNIVERSITY AGRA'),
('2017AP00233', 540, 'INTERMEDIATE', 'GENERAL HINDI, ENGLISH,MATHEMATICS,PHYSICS,CHEMISTRY', 'SARASWATI INTER COLLEGE HATHRAS', '1987-07-01', '1988-06-27', '276', '500', '55.2', '2', 'hssc', 'U.P. BOARD'),
('2017AP00233', 541, 'HIGHSCHOOL', 'HINDI, ENGLISH,MATHEMATICS,SCIENCE-TWO, SOCIAL SCIENCE-TWO, BIOLOGY', 'C.L.R.N.M HR. SEC. SCHOOL HATHRAS', '1985-07-01', '1986-07-19', '311', '600', '51.8', '2', 'ssc', 'U.P. BOARD'),
('2017AP00199', 542, 'HIGH SCHOOL', 'SCIENCE', 'GIC', '1978-01-07', '1979-01-07', '293', '500', '58', '2', 'ssc', 'UP BOARD'),
('2017AP00199', 543, 'INTERMEDIATE', 'SCIENCE', 'KKV', '1979-01-07', '1981-01-07', '256', '500', '51', '2', 'hssc', 'UP BOARD'),
('2017AP00199', 545, 'BSc', 'SCIENCE', 'KKC', '1982-01-09', '1984-01-09', '481', '900', '53', '2', 'ug', 'UNIVERSITY OF LUCKNOW'),
('', 546, 'MBA', 'Human Resource', 'MONIRBA', '1998-07-15', '2000-01-20', '744', '1000', '74.4', '1', 'pg', 'University of Allahabad'),
('2017AP00199', 547, 'MBA', 'MARKETING', 'DEPARTMENT OF BUSINESS ADMINISTRATION UNIVERSITY OF LUCKNOW', '1996-01-09', '1999-01-09', '1718', '2600', '66', '1', 'pg', 'UNIVERSITY OF LUCKNOW'),
('2017AP00284', 548, 'M.Tech', 'Environmental Engineering', 'MNNIT, Allahabad', '2001-07-20', '2003-07-11', '3847', '5600', '68.7%', '1', 'pg', 'MNNIT, Allahabad'),
('2017AP00284', 550, '12th', 'P.C.M.', 'R.K.V.M., Gwalior', '1995-07-03', '1996-04-30', '250', '450', '55.55%', '2', 'hssc', 'MP Board, Bhopal'),
('2017AP00284', 551, '10th', 'all', 'Model School, Gwalior', '1993-07-05', '1994-04-30', '408', '650', '62.7', '1', 'ssc', 'MP Board, Bhopal'),
('', 552, 'BACHELOR OF ENGINEERING', 'CHEMICAL ENGINEERING', 'DEENBANDHU CHHOTU RAM COLLEGE OF ENGINEERING', '2001-07-01', '2005-07-01', '4343', '5870', '73.9', '1', 'ug', 'MAHARISHI DAYANAND UNIVERSITY-ROHTAK'),
('2017AP00197', 553, 'M. Tech', 'Biochemical Engineering', 'Indian Institute of Technology, BHU, Varanasi', '1996-08-01', '1998-07-21', '10', '10', '10', '1', 'pg', 'Banaras Hindu University'),
('2017AP00197', 554, 'M.Sc.', 'Biochemistry', 'Faculty of Science, BHU', '1994-07-01', '1996-07-02', '1150', '1500', '76.7', '1', 'pg', 'Banaras Hindu University'),
('2017AP00197', 555, 'B.Sc.', 'Chemistry (Hons)', 'Mahila Maha Vidyalaya', '1991-07-01', '1994-06-30', '734', '1000', '73.4', '1', 'ug', 'Banaras Hindu University'),
('2017AP00197', 558, 'AISSCE', 'physics, Math, Chemistry, English, Hindi', 'Kendriya Vidyalaya, HFC Urvaraknagar Barauni', '1989-07-01', '1990-09-10', '315', '500', '63', '1', 'hssc', 'CBSE'),
('2017AP00268', 559, 'M.Tech', 'Chemical Engineering', 'HBTI Kanpur', '', '2003-06-08', '3.50', '4', '3.50', '1', 'pg', 'U.P.T.U'),
('2017AP00197', 560, 'AISSE', 'English, Hindi, Math, Science, Social science', 'Kendriya Vidyalaya, HFC Urvaraknagar Barauni', '1987-07-01', '1988-08-22', '350', '500', '70', '1', 'ssc', 'CBSE'),
('2017AP00268', 561, 'B.E', 'Chemical Engineering', 'PREC,Loni', '', '1999-10-10', '913', '1500', '60.8', '1', 'ug', 'Pune University'),
('2017AP00273', 562, 'BACHELOR OF ENGINEERING', 'CHEMICAL ENGINEERING', 'DEENBANDHU CHHOTU RAM STATE COLLEGE OF ENGINEERING', '2001-07-01', '2005-07-01', '4343', '5870', '73.9', '1', 'ug', 'CBSE'),
('', 563, 'M. Tech.', 'Power Systems', 'Malaviya National Institute of Technology, Jaipur', '2004-07-17', '2007-06-28', '9.58', '10', '9.58', '1', 'pg', 'Malaviya National Institute of Technology, Jaipur'),
('2017AP00166', 564, 'M. Tech.', 'Power Systems', 'Malaviya National Institute of Technology, Jaipur', '2004-07-17', '2007-06-28', '9.58', '10', '9.58', '1', 'pg', 'Malaviya National Institute of Technology, Jaipur'),
('2017AP00273', 565, 'SENIOR SECONDARY', 'Physics, Chemistry, Mathematics, Computer Science, English', 'BLUE BELLS MODEL SCHOOL', '2000-03-01', '2001-03-30', '371', '500', '74.2', '1', 'hssc', 'CBSE'),
('2017AP00273', 566, 'SECONDARY', 'English, Mathematics, Hindi, Science, Social Science', 'BLUE BELLS MODEL SCHOOL', '1998-03-01', '1999-03-30', '365', '500', '73', '1', 'ssc', 'CBSE'),
('2017AP00166', 567, 'B. E.', 'Electrical Engineering', 'M. B. M. Engineering College, Jodhpur', '1996-07-01', '2000-06-29', '3016', '4475', '67.4', '1', 'ug', 'Jai Narayan Vyas University, Jodhpur'),
('2017AP00166', 568, 'Senior Secondary', 'Physics, Chem., Maths', 'Govt. Sr. Secondary School, Chittorgarh', '1995-07-01', '1996-05-23', '459', '650', '70.62', '1', 'hssc', 'Rajasthan Board of Secondary Education, Ajmer'),
('2017AP00166', 569, 'Secondary', 'ALL', 'Govt. Sr. Secondary School, Chittorgarh', '1993-07-01', '1994-06-30', '391', '550', '71.09', '1', 'ssc', 'Rajasthan Board of Secondary Education, Ajmer'),
('2017AP00288', 571, 'B.Tech-M.Tech Dual Degree', 'Biotechnology', 'Integral University', '2014-08-04', '2015-08-04', '1932', '2200', '87.81', '1', 'pg', 'Integral University'),
('2017AP00288', 572, 'B.Tech', 'Biotechnology', 'Integral University', '2010-08-04', '2014-08-04', '7012', '8800', '79.68', '1', 'ug', 'Integral University'),
('2017AP00288', 573, 'INTERMEDIATE', 'Biology', 'CMS', '2006-05-01', '2007-05-01', '375', '500', '75', '1', 'hssc', 'ISC'),
('2017AP00288', 574, 'High School', 'Science', 'CMS', '2004-05-01', '2005-05-01', '418', '500', '83.6%', '1', 'ssc', 'ICSE'),
('2017AP00293', 575, 'MASTER OF MARKETING ECONOMICS AND MANAGEMENT', 'MARKETING', 'UNIVERSITY OF LUCKNOW', '1998-08-18', '2000-06-30', '1642', '2500', '65.68', '1', 'pg', 'UNIVERSITY OF LUCKNOW'),
('2017AP00293', 576, 'BACHLOR OF ARTS', 'SOCIOLOGY HISTORY', 'UNIVERSITY OF LUCKNOW', '1995-08-27', '1998-06-20', '441', '900', '49', '2', 'ug', 'UNIVERSITY OF LUCKNOW'),
('2017AP00293', 577, 'INTERMEDIATE', 'GENERAL HINDI, MATHS, PHYSICS, CHEMISTRY ENGLISH', 'GOVT INTER COLLEGE BALLIA', '1993-07-01', '1995-06-15', '331', '500', '66.20', '1', 'hssc', 'U P BOARD ALLAHABAD'),
('2017AP00293', 578, 'HIGH SCHOOL', 'HINDI, ENGLISH, MATHS-2, SCIENCE-2, BIOLOGY, SOCIAL SCIENCE', 'GOVT INTER COLLEGE BALLIA', '1991-07-05', '1993-05-27', '388', '600', '64.66', '1', 'ssc', 'U P BOARD ALLAHABAD'),
('2017AP00223', 579, 'MS', 'Agricultural & Biological Engineering', 'College of Engineering', '2003-01-06', '2005-04-20', '3.52', '4.00', '3.52', 'NA', 'pg', 'University of Arkansas, USA'),
('2017AP00292', 580, 'MCA', 'Computer Science and Allied Fields', 'HIMT Greater Noida', '2001-07-01', '2004-07-25', '4133', '6000', '68.8', '1', 'pg', 'UP Technical University'),
('2017AP00292', 581, 'B.Sc.', 'Computer Science & Mathematics & Physics', 'University of Lucknow', '1997-07-01', '2000-07-22', '1087', '1800', '60.38', '1', 'ug', 'University of Lucknow'),
('2017AP00292', 582, 'Intermediate', 'Hindi, English, Mathematics, Physics, Chemistry', 'LMIC Lucknow', '1994-08-01', '1996-06-15', '319', '500', '63.8', '1', 'hssc', 'UP Board'),
('2017AP00292', 583, 'High School', 'Hindi, English, Mathematics-2, Science-2, Social Science, Biology', 'LPS Lucknow', '1992-07-01', '1994-07-20', '451', '600', '75.1', '1', 'ssc', 'UP Board'),
('2017AP00002', 584, 'High School', 'Sci, Maths, Bio, Hindi, English, S.Sci', 'SS Inter Collg Kanpur', '1990-07-02', '1992-07-01', '438', '600', '73', '1', 'ssc', 'UP Board'),
('2017AP00231', 586, 'M.Phil', 'Biotechnology', 'PR College', '2006-07-16', '2006-08-31', '400', '500', '80', '1', 'pg', 'Bharathidasan University'),
('2017AP00231', 587, 'M.Sc', 'Microbiology', 'Jamal Mohamed College', '2000-06-15', '2002-05-28', '1082', '1500', '73', '1', 'pg', 'Bharathidasan University'),
('2017AP00002', 588, 'Intermediate', 'Physics, Chemistry, Maths, Hindi, English', 'SS Inter Collg Kanpur', '1992-07-02', '1994-07-01', '383', '500', '76.6', '1', 'hssc', 'UP Board'),
('2017AP00002', 589, 'Bachelor of Engineering (BE)', 'Computer Science', 'GB Pant Engineering College Pauri Garhwal', '1996-06-01', '2000-06-01', '3951', '5000', '79.02', '1', 'ug', 'HNB Garhwal University'),
('2017AP00231', 590, 'B.Sc', 'Microbiology', 'Mazharul Uloom College', '1997-06-14', '2000-04-30', '906', '1600', '56', '2', 'ug', 'Madras University'),
('2017AP00231', 591, '12', 'Maths, Physics, Chemistry, Biology', 'Mazharul Uloom School', '1996-06-01', '1997-04-30', '938', '1200', '78', '1', 'hssc', 'Tamil Nadu State Board'),
('2017AP00231', 592, '10', 'Maths, Science, Social Science', 'Hindu Higher Secondary School', '1995-06-01', '1996-04-30', '362', '500', '73', '1', 'ssc', 'Tamil Nadu State Board'),
('2017AP00002', 593, 'MTech', 'Computer and Information Technology', 'Indian Institute of Technology Kaharagpur', '2000-07-26', '2002-01-25', '8.3', '10', '8.3', '1', 'pg', 'Indian Institute of Technology Kaharagpur'),
('2017PF00049', 594, 'ME', 'Analysis And Design of Process Equipment', 'MLNR Engineering College, Allahabad.', '1976 Aug10', '1979 April 20', '2220', '3000', '74', '1', 'pg', 'Allahabad University, Allahabad'),
('2017AP00295', 595, 'ME', 'Analysis And Design of Process Equipment', 'MLNR Engineering College, Allahabad.', '1976 Aug10', '1979 April 20', '2220', '3000', '74', '1', 'pg', 'Allahabad University, Allahabad'),
('2017AP00295', 596, 'BE', 'Mechanical', 'MLNR Engineering College, Allahabad.', '1970-JULY-10', '1975-09-01', '4019', '5000', '80', '1', 'ug', 'Allahabad University, Allahabad'),
('2017AP00252', 597, 'B. Tech.', 'CHEMICAL ENGINEERING', 'INSTITUTE OF ENGINEERING & TECHNOLOGY, SITAPUR ROAD, LUCKNOW', '1996-08-01', '2000-07-17', '2557', '3750', '68.2%', '1', 'ug', 'LUCKNOW UNIVERSITY'),
('2017AP00252', 598, 'INTERMEDIATE', 'PHYSICS, CHEMISTRY, MATHS', 'GIC JHANSI', '1991-08-19', '1993-06-28', '202', '500', '40.4%', 'NA', 'hssc', 'UP BOARD ALLAHABAD'),
('2017AP00252', 599, 'HIGH SCHOOL', 'SCIENCE', 'Sri G.N.K. HIGH SCHOOL JHANSI', '1989-07-01', '1991-08-13', '364', '600', '60.6%', 'NA', 'ssc', 'UP BOARD ALLAHABAD'),
('2017AP00008', 600, 'Master of Technology', 'Communication Engineering', 'Indian Institute of Technology Bombay', '2000-07-15', '2002-02-16', '860', '1100', '7.818', '1', 'pg', 'Indian Institute of Technology Bombay'),
('2017AP00297', 601, 'M.Sc.', 'Biotechnology', 'Jawaharlal Nehru University', '2003-08-01', '2005-05-31', '6.9', '9', '6.9', '1', 'pg', 'Jawaharlal Nehru University'),
('2017AP00008', 603, 'Bacheloar of Engineering', 'Electronics and Communication Engineering', 'Govind Ballabh Pant Engineering College Pauri (Garhwal) Uttarakhand', '1996-07-15', '2000-05-15', '3662', '5000', '73.24', '1', 'ug', 'Hemwati Nandan Bahuguna University Srinagar (Garhwal) Uttarakhand'),
('2017AP00297', 604, 'B.Sc.', 'Analytical Methods in Chemistry and Biochemistry', 'Kirrori Mal College', '1999-08-01', '2002-05-31', '898', '1350', '66.51', '1', 'ug', 'Delhi University'),
('2017AP00008', 606, 'Intermediate', 'Hindi, English, Maths, Physics, Chemistry', 'Maulana Azad Inter College Qadirabad, Siddharth Nagar, Uttar Pradesh', '1993-07-15', '1995-08-11', '391', '500', '78.2', '1', 'hssc', 'Uttar Pradesh Board Allahabad'),
('2017AP00008', 608, 'High School', 'Hindi, English, Maths, Science, Biology, Social Science', 'Maulana Azad Inter College Qadirabad, Siddharth Nagar, Uttar Pradesh', '1991-07-15', '1993-07-13', '468', '600', '78.0', '1', 'ssc', 'Uttar Pradesh Board Allahabad'),
('2017AP00297', 609, 'DSSSCE-97', 'Maths, English, Science, Hindi, S.St.', 'Delhi Secondary Sschool Examination-97', '1996-03-01', '1997-03-31', '342', '500', '68.4', '1', 'ssc', 'C.B.S.E.'),
('2017AP00297', 610, 'DSSCE-99', 'Science (Biology, Maths, English, Chemistry, Physics)', 'Delhi Senior School Certificate Examination -99', '1998-03-01', '1999-03-31', '331', '500', '66.2', '1', 'hssc', 'C.B.S.E.'),
('2017AP00184', 612, 'M. Tech.', 'Power systems', 'Indian Institute of Technology, Kanpur', '1991-07-01', '1993-06-09', '8.57', '10', '8.57', 'NA', 'pg', 'Indian Institute of Technology, Kanpur'),
('2017AP00304', 613, 'M.C.A.', 'COMPUTER APPLICATIONS', 'AURORA\'S P.G. COLLEGE', '1997-01-29', '2000-09-15', '2913', '3600', '81%', '1', 'pg', 'OSMANIA UNIVERSITY, HYDERABAD'),
('2017AS03921', 618, 'M.Sc.', 'BIOTECHNOLOGY', 'SCHOOL OF BIOTECHNOLOGY', '2001-07-15', '2003-06-11', '1337', '1800', '74.27', '1', 'pg', 'BANARAS HINDU UNIVERSITY VARANASI'),
('2017AP00308', 624, 'M.Sc.', 'BIOTECHNOLOGY', 'SCHOOL OF BIOTECHNOLOGY', '2001-07-15', '2003-06-11', '1337', '1800', '74.27', '1', 'pg', 'BANARAS HINDU UNIVERSITY VARANASI'),
('2017AP00308', 625, 'B.Sc.', 'BOTANY, CHEMISTRY, ZOOLOGY', 'ST. ANDREW\'S COLLEGE, GORAKHPUR', '1997-08-01', '2000-07-04', '1168', '1800', '64.88', '1', 'ug', 'D.D.U. GORAKHPUR UNIVERSITY, GORAKHPUR'),
('2017AP00308', 626, 'INTERMEDIATE', 'GENERAL HINDI, ENGLISH, PHYSICS, CHEMISTRY, BIOLOGY', 'BAPU INTER COLLEGE, PEPPEGANJ', '1995-07-01', '1997-07-03', '369', '500', '73.8', '1', 'hssc', 'U.P. BOARD ALLAHABAD'),
('2017AP00308', 627, 'HIGH SCHOOL', 'HINDI, ENGLISH, MATHEMATICS-2, SCIENCE-2, SOCIAL SCIENCE, BIOLOGY', 'BAPU INTER COLLEGE, PEPPEGANJ, GORAKHPUR', '1993-07-01', '1995-07-30', '411', '600', '68.5', '1', 'ssc', 'U.P. BOARD ALLAHABAD'),
('2017AP00225', 628, 'B.E.', 'CSE', 'KEC ,DWARAHAT (ALMORA) UTTRAKHAND,INDIA', '1995-07-27', '1999-07-23', '8.295', '8.295', '8.295', '1', 'ug', 'KUMAON UNIVERSITY ,NAINITAL (INDIA)'),
('2017AP00225', 630, 'INTERMEDIATE', 'PCM', 'GIC ,DAKPATHER ,DEHRADUN ,UTTRAKHAND (INDIA)', '1994-04-15', '1995-08-03', '295', '500', '59', '2', 'hssc', 'U.P.BOARD'),
('2017AS02694', 639, 'Intermediate', 'Physics,Chemistry,Mathematics, Hindi, English', 'J R V B S Inter College Nausanda Faizabad', '1992-07-15', '1994-06-25', '330', '500', '66 %', '1', 'hssc', 'U P Board'),
('2017AP00318', 642, 'M. Tech.', 'Production Engineering', 'Institute of Technology BHU', '2000-07-12', '2002-03-23', '8.63', '10', '8.63', '1', 'pg', 'Banaras Hindu University'),
('2017AP00318', 643, 'B. E.', 'Mechanical Engineering', 'University of Roorkee', '1996-07-15', '2000-06-19', '3204', '4500', '71.2 %', '1', 'ug', 'University of Roorkee'),
('2017AP00318', 644, 'Intermediate', 'Physics,Chemistry,Mathematics, Hindi, English', 'J R V B S Inter College Nausanda Faizabad', '1992-07-15', '1994-06-25', '330', '500', '66 %', '1', 'hssc', 'U P Board'),
('2017AP00318', 645, 'High School', 'Hindi, English, Mathematics Two, Science Two, Social Science, Biology', 'B S Inter College Nausanda Faizabad', '1990-07-15', '1992-06-25', '392', '600', '65.3 %', '1', 'ssc', 'U P Board'),
('2017AP00144', 646, 'Master of Technology (M Tech)', 'Electrical Engg (Signal and Image Proc)', 'IIT Kanpur', '1989-07-01', '1991-06-30', '9.5', '10', '9.5/10', '1', 'pg', 'IIT Kanpur'),
('2017AP00144', 647, 'Bachelor of Engg', 'Electronics and Telecommunications Engg', 'Jadavpur University Main Campus, Calcutta', '1985-07-01', '1989-06-30', '83', '100', '83%', '1', 'ug', 'Jadavpur University, Calcutta'),
('2017AP00144', 648, 'Higher Secondary', 'Physics, Math, Chem, Statistics, English, Bengali', 'Narendrapur Ramakrishna Mission, Calcuta', '1983-07-01', '1985-06-30', '85.4', '100', '85.4%', '1', 'hssc', 'West Bengal Board of Higher Secondary Education'),
('2017AP00144', 649, 'Secondary Examination', 'Humanities, Science, Languages', 'St Patricks School Asansol West Bengal,', '1981-07-01', '1983-06-30', '89.8', '100', '89.8%', '1', 'ssc', 'ICSE Board'),
('2017AP00009', 650, 'M.Tech.', 'Power Systems', 'IIT Delhi', '1998-07-01', '1999-12-30', '6.396', '10', '63.96', 'NA', 'pg', 'IIT Delhi'),
('2017AP00009', 651, 'B.E.', 'Electrical Engineering', 'Madan Mohan Malaviya Engineering College Gorakhpur', '1994-07-01', '1998-06-30', '4412', '6000', '73.53', '1', 'ug', 'DDU Garakhpur University, Gorakhpur'),
('2017AP00009', 652, 'Intermediate', 'Hindi, English, Physics, Chemistry, Maths', 'Rashtriya Inter College Tenduai Kalan Faizabad', '1990-07-01', '1992-06-30', '248', '500', '49.60', '2', 'hssc', 'U. P. Board'),
('2017AP00009', 653, 'High School', 'Hindi, English, Maths Two, Science two, Social Science, Biology', 'Rashtriya Inter College Tenduai Kalan Faizabad', '1988-07-01', '1990-06-30', '328', '600', '54.67', '2', 'ssc', 'U. P. Board'),
('2017AP00316', 654, 'MA in English Literature', 'English Literature', 'University of Allahabad', '', '2006-06-25', '747', '1200', '62.25', '1', 'pg', 'University of Allahabad'),
('2017AP00316', 655, 'BA(HONS)', 'English Literature', 'BHU VARANASI', '', '2003-06-26', '1130', '1800', '62.78', '1', 'ug', 'BHU VARANASI'),
('2017AP00316', 656, 'INTERMEDIATE', 'ENG, HIN, PHY, CHEM, BIO,', 'KV MAU', '', '2000-05-31', '303', '500', '60.60', '1', 'hssc', 'CBSE'),
('2017AP00316', 657, 'MATRICULATION', 'ENG,HIN, MATHS, SC, SO. SC.', 'KV MAU', '', '1998-06-15', '324', '500', '64.80', '1', 'ssc', 'CBSE'),
('2017AP00325', 660, 'M.Tech.', 'Chemical Engineering', 'Indian Institute of Technology Delhi', '2006-07-25', '2008-06-13', '7.46', '10', '74.6', 'NA', 'pg', 'Indian Institute of Technology'),
('2017AP00325', 661, 'B.Tech.', 'Chemical Engineering', 'Meerut Institute of Engineering and Technology', '2000-11-01', '2004-06-10', '5656', '8000', '73%', '1', 'ug', 'U P Technical University'),
('2017AP00325', 662, 'Intermediate', 'PCM', 'St. Thomas Girls Inter College, Meerut', '1997-07-01', '1999-04-30', '327', '500', '65.4', '1', 'hssc', 'U.P.Board'),
('2017AP00325', 663, 'High School', 'PCMB', 'St. Thomas Girls Inter College, Meerut', '1995-07-01', '1997-04-30', '371', '600', '61.8%', '1', 'ssc', 'U.P.Board'),
('2017AP00327', 664, 'M.tech', 'Computer Science', 'Allahabad University', '2015-08-26', '2017-07-07', '1483', '2400', '61.6', 'NA', 'pg', 'Allahabad University'),
('2017AP00327', 665, 'B.Tech', 'Computer Science', 'BBSCET,Allahabad', '2011-07-25', '2015-06-30', '3711', '5000', '74.22', '1', 'ug', 'AKTU'),
('2017AP00327', 667, '12', 'PCM', 'Bal Vikas Intermediate College', '2009-07-12', '2010-05-30', '313', '500', '62.6', '1', 'hssc', 'UP Board'),
('2017AP00327', 668, '10', 'English,Math,Science', 'Bal Vikas Intermediate College', '2007-07-20', '2008-05-30', '364', '600', '61.6', '1', 'ssc', 'UP Board'),
('2017AP00210', 669, 'B.Tech', 'Computer Science Engineering', 'Indian Institute of Technology Roorkee', '2001-07-01', '2005-04-20', '9.05', '10.0', '9.05', '1', 'ug', 'Indian Institute of Technology Roorkee'),
('2017AP00210', 670, 'ISC', 'Physics, chemistry, maths, english, hindi', 'seth M R Jaipuria', '1999-06-01', '2000-04-20', '471', '500', '94.25', '1', 'hssc', 'ISC'),
('2017AP00143', 673, 'MSc', 'Mathematics', 'University of Allahabad', '', '2005-07-21', '790', '1200', '65.8', '1', 'pg', 'University of Allahabad'),
('2017AP00143', 674, 'BSc', 'Mathematics, Physics, Chemistry', 'University of Allahabad', '', '2003-06-11', '1154', '1800', '64.1', '1', 'ug', 'University of Allahabad'),
('2017AP00143', 675, 'Indian School Certificate (YEAR-12)', 'English, Hindi, Physics, Chemistry, Mathematics', 'Girls\' High CShool & College', '', '2000-05-15', '393', '500', '78.6', '1', 'hssc', 'ISCE'),
('2017AP00143', 676, 'Indian Certificate of Secondary Education', 'English, Hindi, Science, Mathematics, Social Science, Computer', 'Girls\' High CShool & College', '', '1998-05-11', '494', '600', '82.3', '1', 'ssc', 'ISCE'),
('2017AP00329', 677, 'M.E.', 'Electronics & Controls', 'BITS Pilani', '', '2000- 01-03', '7.76', '10', '7.76', 'NA', 'pg', 'BITS Pilani'),
('2017AP00329', 678, 'B.E.', 'Electronics', 'Moharashtra Engineering College Nilanga', '', '1997- 03-09', '1023', '1500', '68.2', '1', 'ug', 'Dr. BAMU Aurangabad'),
('2017AP00173', 679, 'M.Tech', 'Software Engineering', 'MNNIT Allahabad', '', '2003-06-24', '4328', '5600', '77.28', '1', 'pg', 'MNNIT Allahabad'),
('2017AP00173', 680, 'AMIE', 'Computer Engineering', 'IE(India)', '', '1999-09-30', '1215', '2000', '60.75', 'NA', 'ug', 'IE(India)'),
('2017AP00173', 681, 'Intermediate', 'Science', 'St. Columba\'s College, Hazaribagh', '', '1992-06-01', '561', '900', '62.33', '1', 'hssc', 'BIEC Patna'),
('2017AP00173', 682, 'Matriculation', 'Phy+Che+Math+HIN+Eng+SAN', 'P T P S High School', '', '1990-08-29', '666', '900', '74', '1', 'ssc', 'BSEB, Patna'),
('2017AP00164', 683, 'M.Sc', 'Biotechnology', 'Maharishi Dayanand University Rohtak', '', '2004-08-30', '1567', '2000', '78.3', '1', 'pg', 'MDU Rohtak'),
('2017AP00332', 686, 'MCA', 'Computer Applications', 'Aligarh Muslim University', '2008-12-08', '2011-09-15', '2741', '3600', '76.12', '1', 'pg', 'Aligarh Muslim University'),
('2017AP00332', 687, 'B. Sc (Hons.)', 'Physics (Main), Chemistry, Mathematics, English', 'Aligarh Muslim University', '2003-08-14', '2007-06-15', '1041', '1500', '69.4', '1', 'ug', 'Aligarh Muslim University'),
('2017AP00331', 688, 'M.Sc', 'LifeSciences', 'Faculty of LifeSciences, CSJM University, Kanpur', '', '2000-01-22', '1606', '2000', '80.3%', '1', 'pg', 'CSJM University, Kanpur'),
('2017AP00164', 689, 'B.Sc', 'Botany, chemistry, Zoology, Sanskrit/Hindi', 'Govt. college of women, Rohtak, Haryana', '', '2002-06-10', '1030', '1450', '71.0', '1', 'ug', 'MDU Rohtak'),
('2017AP00332', 690, 'Intermediate', 'Mathematics, Physics, Chemistry, English, Hindi', 'F.A.A. Government Inter College, U.P Board , Gonda, Uttar Pradesh', '2001-07-15', '2003-06-15', '326', '500', '65.2', '1', 'hssc', 'U.P Board'),
('2017AP00332', 691, 'High school', 'Mathematics, Science, Hindi, English, Social Science, Urdu', 'F.A.A. Government Inter College, U.P Board , Gonda, Uttar Pradesh', '1999-07-15', '2001-06-15', '357', '600', '59.5', '2', 'ssc', 'U.P Board'),
('2017AP00164', 692, '10+2', 'English, Physics, Biology, Chemistry, Computer science', 'D.A.V. Centenary Public School, Rohtak', '', '1997-05-29', '372', '500', '74.4', '1', 'hssc', 'C.B.S.E.'),
('2017AP00331', 693, 'B.Sc', 'Botany, Zoology and Chemistry', 'P.P.N. College Kanpur', '', '1997-06-14', '976', '1350', '72.3', '1', 'ug', 'CSJM University, Kanpur'),
('2017AP00331', 694, 'Intermediate', 'Physics, Chemistry, Hindi, English, Biology', 'R.S.G.U. Inter college, Pukhrayan, Kanpur', '', '1993-06-19', '350', '500', '70%', '1', 'hssc', 'U. P. Board'),
('2017AP00164', 695, '10th', 'English, Hindi, Maths, Science, Social science', 'D.A.V. Centenary Public School, Rohtak', '', '1995-06-03', '364', '500', '72.8', '1', 'ssc', 'C.B.S.E.'),
('2017AP00331', 696, 'Highschool', 'Mathematics II, Science II, Hindi, English, Biology, Social Science', 'R.S.G.U. Inter college, Pukhrayan, Kanpur', '', '1991-07-30', '449', '600', '74.8%', '1', 'ssc', 'U. P. Board');
INSERT INTO `education` (`user_id`, `id`, `degree`, `subject`, `inst_name`, `entry_date`, `complete_date`, `marks`, `max_marks`, `perc_marks`, `division`, `qualification`, `board`) VALUES
('2017AP00335', 697, 'M.TECH.', 'INSTRUMENTATION', 'INDIAN INSTITUTE OF TECHNOLOGY DELHI', '2005-07-20', '2007-06-15', '7.84', '10.00', '7.84', '1', 'pg', 'INDIAN INSTITUTE OF TECHNOLOGY DELHI'),
('2017AP00335', 698, 'B.TECH', 'ELECTRONICS AND COMMUNICATION ENGINEERING', 'UIET KANPUR', '2001-07-15', '2005-06-15', '9.75', '10.00', '9.75', '1', 'ug', 'C.S.J.M. UNIVERSITY KANPUR'),
('2017AP00335', 700, 'INTERMEDIATE', 'Hindi, Eng, Maths, Physics, Chemistry', 'GJIC Gorakhpur', '1997-06-15', '1998-06-15', '360', '500', '72', '1', 'hssc', 'UP Borad, Allahabad'),
('2017AP00335', 701, 'HIGH SCHOOL', 'Hindi, Eng, Maths, Social Science, Biology, Science', 'GJIC Gorakhpur', '1995-06-15', '1996-06-15', '432', '600', '72', '1', 'ssc', 'UP Borad, Allahabad'),
('2017AP00200', 703, 'MA', 'Economics', 'CSJM University, Kanpur', '2001-07-15', '2003-08-02', '511', '850', '60.11', '1', 'pg', 'CSJM University, Kanpur'),
('2017AP00200', 704, 'BA', 'Economics Honours, Mathematics Pass', 'Jadavpur University', '1993-07-15', '1996-08-10', '552', '900', '61.33', '1', 'ug', 'Jadavpur University'),
('2017AP00200', 705, 'Higher Secondary', 'Bio. Science', 'South Point High School', '1991-04-20', '1993-05-20', '679', '1000', '67.9', '1', 'hssc', 'West Bengal Council of Higher Secondary Education'),
('2017AP00200', 706, 'Secondary', 'Science', 'South Point High School', '1989-07-15', '1991-04-10', '705', '900', '78.3', '1', 'ssc', 'West Bengal Board of Secondary Education'),
('2017AP00337', 707, 'M.Tech.', 'Computer Science and Engineering', 'Calcutta University', '1999-06-29', '2002-05-24', '986', '1200', '82.2', '1', 'pg', 'Calcutta University'),
('2017AP00337', 708, 'B.Tech.', 'Computer Science and Engineering', 'Clacutta University', '1996-06-15', '1999-05-30', '1899', '3000', '63.4', '2', 'ug', 'Calcutta University'),
('2017AP00337', 709, 'B.Sc. [Hons]', 'Physics Honours', 'Surendranath College', '1992-06-18', '1996-05-30', '440', '800', '55', '2', 'ug', 'Calcutta University'),
('2017AP00337', 710, 'Higher Secondary', 'Science', 'Debnagar M D H S School', '1990-06-17', '1992-06-15', '610', '1000', '61.0', '1', 'hssc', 'WBCHSE'),
('2017AP00337', 711, 'Secondary', 'Math, Physics, Geo, Hist, Bengali etc.', 'R.K.Missoin', '1988-06-15', '1990-06-19', '640', '800', '71.1', '1', 'ssc', 'WBBSE'),
('2017AP00340', 713, 'Master of Science', 'Biotechnology (Marine)', 'Faculty of Life Science and Environment', '2001-07-15', '2003-08-09', '1003', '1600', '62.69', 'NA', 'pg', 'Goa University'),
('2017AP00340', 714, 'Bachelor of Science', 'Chemistry (Honors)', 'Faculty of Science', '', '2001-05-31', '1219', '1800', '67.7', '1', 'ug', 'Banaras Hindu University'),
('2017AP00340', 715, 'Intermediate', 'Physics Chemistry Biology', 'Jyoti Niketan School Azamgarh', '', '1996-05-06', '361', '500', '72.2', 'NA', 'hssc', 'Indian School Certificate Examination/ISC Board'),
('2017AP00340', 716, 'High School', 'English, Hindi, Commerce, Social Studies, Maths, Science', 'Jyoti Niketan School Azamgarh', '', '1994-05-02', '482', '600', '80.33', 'NA', 'ssc', 'Indian School Certificate Examination/ICSE Board'),
('2017AP00316', 717, 'BJMC', 'MASS COMMUNICATION', 'MGKV VARANASI', '', '2004-06-21', '497', '800', '61.25', '1', 'ug', 'MGKV VARANASI'),
('2017AP00123', 718, 'Master of Science (M.Sc.)', 'Biochemistry', 'Institute of Bio-sciences and Bio-technology (I.B.S.B.T) (Campus)', '2004-07-01', '2006-06-30', '1470', '2000', '73.5', '1', 'pg', ', Chhatrapati Shahu Ji Maharaj University, Kanpur, Uttar Pradesh (U.P.), India.'),
('2017AP00123', 719, 'Bachelor of Science (B. Sc.)', 'Chemistry, Zoology, and Botany', 'University of Lucknow (Campus)', '2000-07-01', '2004-06-30', '1143', '1800', '63.5', '1', 'ug', 'University of Lucknow (Campus), Uttar Pradesh (U.P.), India'),
('2017AP00123', 720, 'Intermediate (XII)', 'Hindi, English, Physics, Chemistry, Biology', 'Colvin Taluqdar’s College, Lucknow, Uttar Pradesh (U.P.), India', '1998-07-01', '2000-06-30', '363', '500', '72.6', '1', 'hssc', 'Uttar Pradesh'),
('2017AP00123', 721, 'High School (X)', 'Hindi, English, Mathematics, Science, Social Science, Biology', 'Colvin Taluqdar’s College, Lucknow, Uttar Pradesh (U.P.), India', '1996-07-01', '1998-06-30', '434', '600', '72.3', '1', 'ssc', 'Uttar Pradesh'),
('2017AP00277', 722, 'Master of Science', 'Biochemistry', 'University of Allahabad', '2001-07-16', '2003-05-12', '686', '1000', '68.6', '1', 'pg', 'University of Allahabad'),
('2017AP00277', 723, 'Bachelor of Science', 'Chemistry, Zoology, Botany', 'CMP Degree College', '1998-07-19', '2001-05-21', '961', '1350', '71.1', '1', 'ug', 'University of Allahabad'),
('2017AP00277', 724, 'Intermediate', 'English, Hindi, Physics, Chemistry, Biology', 'Jawahar Navodaya Vidyalaya, RaeBareli', '1996-04-01', '1997-09-29', '360', '500', '72', '1', 'hssc', 'C.B.S.E.'),
('2017AP00277', 725, 'High School', 'English, Hindi, Science, Maths, Social Science', 'Jawahar Navodaya Vidyalaya, RaeBareli', '1994-04-01', '1995-06-05', '354', '500', '70.8', '1', 'ssc', 'C.B.S.E.'),
('2017AP00210', 726, 'ICSE', 'all courses', 'seth M R Jaipuria', '1997-06-01', '1998-04-30', '435', '500', '87.0', '1', 'ssc', 'ICSE'),
('2017AP00212', 728, 'B.Sc', 'Mathematics, Physics, Chemistry', 'PVKN Govt Degree College', '', '2001-04-20', '1121', '1800', '62.28', '1', 'ug', 'Sri Venkateswara University, Tirupati'),
('2017AP00212', 729, 'Intermediate', 'Mathematics, Physics, Chemistry', 'Govt Junior College, Bangarupalyam', '', '1998-04-20', '585', '1000', '58.5', '2', 'hssc', 'Board of Intermediate Education, Andhra Pradesh'),
('2017AP00212', 730, 'SSC', 'Basic Sciences', 'Z P High School, Mogili Mittoor', '', '1996-05-23', '457', '600', '76.17', '1', 'ssc', 'Board of Secondary Education, Andhra Pradesh'),
('2017AP00329', 731, 'Intermediate', 'Maths, Physics, Chemistry, English, General Hindi', 'Govt. Jubilee Inter College Lucknow', '', '1991- 07-24', '312', '500', '62.4', '1', 'hssc', 'U.P. Board'),
('2017AP00329', 732, 'High School', 'Maths, Science, Biology, Social Science, English, Hindi', 'Shri Ram Janki Uchttar Madhyamik Vidyalay Bithoor Kanpur', '', '1989- 06-15', '353', '600', '58.83%', '2', 'ssc', 'U.P. Board'),
('2017AP00291', 733, 'M Tech', 'Struuctures', 'MNNIT Allahabad', '2002-08-26', '2005-07-16', '7.97', '10', '7.97', '1', 'pg', 'MNNIT Allahabad'),
('2017AP00291', 734, 'AMIE Section A and B', 'Civil Engineering', 'The Institution of Engineers (India)', '1995-05-05', '2001-03-26', '797', '1500', '53.13', 'NA', 'ug', 'The Institution of Engineers (India)'),
('2017AP00291', 736, 'Intermediate', 'Physics, Chemistry, Maths, Hindi, English', 'G I C Kanpur', '1987-07-08', '1989-06-15', '392', '600', '65.33', '1', 'hssc', 'U.P. Board Allahabad'),
('2017AP00291', 737, 'High School', 'Hindi, English, Maths, Science, E.G. Engg.', 'G I C Kanpur', '1989-07-08', '1991-07-24', '291', '500', '58.2', '2', 'ssc', 'U.P. Board Allahabad'),
('2017AP00346', 739, 'Master of Engineering', 'Thermal Engineering', 'Mohamed Sathak Engineering College', '2004-08-16', '2007-06-29', '1718.00', '2300', '75', '1', 'pg', 'Anna University'),
('2017AP00346', 742, 'Bachelor of Engineering', 'Mechanical Engineering', 'Mohamed Sathak Engineering College', '', '1995-04-30', '2978.00', '4800', '62', '1', 'ug', 'Madurai kamaraj university'),
('2017AP00346', 743, 'Board Examination', 'Science Group', 'Syed Ammal Higher secondary School', '', '1991-04-30', '757', '1200', '63', 'NA', 'hssc', 'Tamil Board Examination'),
('2017AP00346', 744, 'Board Examination', 'Secondary School Leaving Certificate', 'Syed Ammal Higher secondary School', '0001-01-01', '1889-04-30', '336', '500', '67.2', 'NA', 'ssc', 'Tamil Board Examination'),
('2017AP00347', 747, 'M. Tech.', 'Mechanical Engineering (Machine Design and Analysis)', 'National Institute of Technology Rourkela', '2002-07-18', '2004-07-12', '1952', '2500', '78.08', '1', 'pg', 'National Institute of Technology Rourkela'),
('2017AP00203', 748, 'M. Sc.', 'Physics', 'Department of Physics', '', '2000-08-16', '982', '1500', '65.46', '1', 'pg', 'Banaras Hindu University'),
('2017AP00347', 749, 'B. Tech.', 'Mechanical Engineering', 'The Institution of Engineers (India), Kolkata.', '1996-09-19', '2001-09-26', '907', '1500', '60.46', '1', 'ug', 'The Institution of Engineers (India), Kolkata.'),
('2017AP00203', 750, 'B. Sc.', 'Physics, Chemistry, Math', 'Satish Chandra Degree College Ballia', '', '1996-11-30', '1313', '1800', '72.94', '1', 'ug', 'Purvanchal University Jaunpur'),
('2017AP00203', 751, '12th', 'Physics, Chemistry, Math, Hindi, English', 'L R D Inter College Ballia', '', '1993-06-03', '200', '500', '40', 'NA', 'hssc', 'U P Board'),
('2017AP00203', 752, '10th', 'Math, Hindi, English, Science, Biology, Social Science', 'L R D Inter College Ballia', '', '1991-08-12', '379', '600', '63.16', '1', 'ssc', 'U P Board'),
('2017AP00345', 753, 'M Tech', 'Chemical Engineering', 'Dr. Babasaheb Ambedkar Technological University, Lonere', '2003-01-28', '2005-06-07', '1113', '1600', '69056', '1', 'pg', 'Dr. Babasaheb Ambedkar Technological University, Lonere'),
('2017AP00345', 754, 'BE', 'Chemical Engineering', 'Jawaharlal Nehru Engineering College, Aurangabad', '1998-08-17', '2002-02-27', '976', '1500', '65.06', '1', 'ug', 'Dr. Babasaheb Ambedkar Marathwada University, Aurangabad'),
('2017AP00345', 755, 'SSC', 'English, Mathematics, Science', 'Mudhoji Highschool, Phaltan', '', '1994-03-01', '409', '700', '58.42', '2', 'ssc', 'Maharashtra State Board, Kolhapur'),
('2017AP00070', 756, 'Masters in Engineering', 'Computer Aided Design and Manufacturing', 'MNREC', '1998-07-20', '2000-03-15', '4691', '6000', '78.18', '1', 'pg', 'Allahabad University'),
('2017AP00070', 757, 'Bachelor in Engineering', 'Mechanical', 'MNREC', '1991-07-01', '1995-06-15', '75.48', '100', '75.48%', '1', 'ug', 'Allahabad University'),
('2017AP00345', 758, 'Diploma', 'Chemical Engineering', 'Satara Polytechnic Satara', '1994-07', '1998-08-01', '705', '1025', '68.78', '1', 'hssc', 'MSBTE, Mumbai'),
('2017AP00070', 759, 'Intermediate', 'Physics, Chemistry, Maths, Hindi, English', 'St. Anthony\'s Convent Girls\' Inter College', '1989-07-05', '1991-05-15', '363', '500', '72.6%', '1', 'hssc', 'U. P. Board'),
('2017AP00348', 760, 'M. Tech.', 'Industrial Design', 'MANIT, Bhopal', '1998-09-01', '2001-03-31', '1377.00', '2000.00', '68.85', '1', 'pg', 'RGPV, Bhopal'),
('2017AP00070', 761, 'High School', 'Hindi, English, Maths, Science, Social Science', 'St. Anthony\'s Convent Girls\' Inter College', '1987-01-07', '1989-05-15', '441', '600', '73.5%', '1', 'ssc', 'U. P. Board'),
('2017AP00348', 763, 'B.E.', 'Mechanical', 'SATI, Vidisha', '1993-09-01', '1997-08-31', '1622.00', '2600.00', '62.38', '1', 'ug', 'Barkatullah University, Bhopal'),
('2017AP00348', 764, '12th', 'PCM and Hindi, Eng.', 'Govt High School Station Area, Bhopal', '1992-07-01', '1993-05-31', '481', '800', '60.12', '1', 'hssc', 'MP Higher Education Board, Bhopal'),
('2017AP00348', 765, '10th', 'PCM and Hindi, Eng, Sanskrit', 'Govt High School Station Area, Bhopal', '1990-07-02', '1991-04-30', '395', '650', '60.76', '1', 'ssc', 'MP Higher Education Board, Bhopal'),
('2017AP00344', 766, 'MA', 'Psychology/Organization Behaviour', 'Center for Advanced Studies, Department of Psychology, University of Allahabad', '', '1995-08-31', '611', '1000', '61.1', '1', 'pg', 'University of Allahabad'),
('2017AP00344', 768, 'BA', 'Psychology, Philosophy, Political Science', 'University of Allahabad', '', '1992-10-06', '760', '1350', '56.29', '2', 'ug', 'University of Allahabad'),
('2017AP00313', 769, 'M.A.', 'English', 'CSJM University', '1999-08-07', '2002-07-08', '471', '850', '55.41', '2', 'pg', 'CSJM University, Kanpur'),
('2017AP00344', 770, 'ISC', 'Maths, Physics, Chemistry, English, Hindi', 'St. Joseph\'s College, Allahabad', '', '1989-03-31', '256', '500', '51.2', '2', 'hssc', 'Indian Council for Secondary Education, Delhi'),
('2017AP00313', 771, 'B.A.', 'English, Sociology, Political Science', 'CSJM University', '1993-07-05', '1996-07-28', '457', '900', '50.77', '2', 'ug', 'CSJM University, Kanpur'),
('2017AP00344', 772, 'ICSE', 'English, Hindi, Science, Maths, Social Studies, Commerce', 'St. Joseph\'s College, Allahabad', '', '1987-03-31', '368', '600', '61.3', '1', 'ssc', 'Indian Council for Secondary Education, Delhi'),
('2017AP00313', 773, 'Intermediate', 'Physics, Chemistry, Maths, Hindi, English', 'GGIC, Fatehpur', '1992-06-07', '1993-06-04', '235', '500', '47', '2', 'hssc', 'U.P. Board'),
('2017AP00313', 774, 'High School', 'English, Hindi, Maths-II, Science-II, Biology, Social Science', 'GGIC, Fatehpur', '1990-07-06', '1991-06-02', '365', '600', '60.83', '1', 'ssc', 'U.P. Board'),
('2017AP00230', 775, 'M.Sc.', 'Agricultural Botany - Genetics and Plant Breeding', 'Department of Genetics and Plant Breeding, Ch. Charan Singh University Meerut UP India', '1995-07-15', '1997-06-30', '732', '1200', '61 %', '1', 'pg', 'Ch. Charan Singh University Meerut UP India'),
('2017AP00230', 776, 'B.Sc', 'Agriculture', 'Kisan Degree College Shamli UP', '1990-08-16', '1994-07-30', '1281', '1950', '65.7', '1', 'ug', 'Ch. Charan Singh University Meerut UP India'),
('2017AP00230', 777, 'Intermediate', 'Agriculture', 'Amar Veer Inter College Dhanapur UP Varansi', '1988-07-16', '1990-06-15', '723', '1100', '65.72', '1', 'hssc', 'UP Board Allahabad'),
('2017AP00349', 778, 'M.Tech', 'Digital Communication', 'BBDNITM, Lucknow', '2003-06-01', '2006-07-26', '9.33', '10', '93.3', '1', 'pg', 'UPTU, Lucknow'),
('2017AP00349', 779, 'B.E.', 'Electronics Engineering', 'Dr. JJMCOE, Kolhapur', '1996-05-01', '1999-04-07', '988', '1500', '66', '1', 'ug', 'Shivaji University'),
('2017AP00230', 780, 'High School', 'Science', 'High School Basudevpur Banhara', '1987-01-01', '1987-06-26', '488', '900', '54.2', '2', 'ssc', 'Bihar School Examination Board Patna'),
('2017AP00349', 781, 'Senior School Certificate Examination', 'PCM', 'KCM School Moradabad', '1993-06-01', '1994-05-30', '328', '500', '65.6', '1', 'hssc', 'CBSE'),
('2017AP00349', 782, 'Secondary School Examination', 'Hindi, English, Science, Social Studies, Maths', 'KCM School Moradabad', '1991-07-07', '1992-08-10', '449', '600', '74.83', '1', 'ssc', 'CBSE'),
('2017AP00354', 783, 'M. Tech.', 'Chemical Engineering', 'Dr. Babasaheb Ambedkar Technological University Lonere Raigad', '2001-07-02', '2003-06-21', '907', '1300', '69.76', '1', 'pg', 'Dr. Babasaheb Ambedkar Technological University Lonere Raigad'),
('2017AP00354', 784, 'B.E.', 'Chemical Engineering', 'Anuradha College of Engineering Chikhali', '1996-08-01', '2000-07-06', '663', '1000', '66.3', '1', 'ug', 'Amravati'),
('2017AP00354', 785, 'HSC', 'Science', 'A K National High School and Junior College Khamgaon Buldana MS', '1995-07-01', '1996-06-07', '418', '600', '69.67', '1', 'hssc', 'Pune'),
('2017AP00354', 786, 'SSC', 'General', 'A K National High School and Junior College Khamgaon Buldana MS', '1993-07-01', '1994-06-24', '469', '700', '67.00', '1', 'ssc', 'Pune'),
('2017AP00356', 787, 'MBA', 'HRM/Management', 'TITSc', '2002-05-09', '2004-05-26', '2332', '3800', '61.36', '1', 'pg', 'MDU, Rohtak'),
('2017AP00356', 788, 'BA', 'Arts', 'CRK college Jind', '1999-06-06', '2002-04-02', '601', '1200', '50', '2', 'ug', 'Kurukshetra University, Kurukshetra'),
('2017AP00356', 789, '10+2', 'Commerce', 'CRK college Jind', '1997-04-01', '2001-03-31', '253', '500', '50.6', '2', 'hssc', 'HBSE, Bhiwani'),
('2017AP00356', 790, 'Matriculation', 'NA', 'Govt. High School, Jajawan, Jind', '1995-04-01', '1997-03-31', '338', '600', '56.33', '2', 'ssc', 'HBSE, Bhiwani'),
('2017AP00358', 791, 'M.E', 'Energy/Mechanical', 'PSG College of Technology, Coimbatore', '', '2004-05-31', '9.21', '10', '9.21', '1', 'pg', 'Anna University, Chennai'),
('2017AP00358', 792, 'B.E', 'Mechanical', 'National Engineering College, Kovilpatti', '', '2000-05-31', '3452.00', '4700', '73.45', '1', 'ug', 'Manonmaniam Sundaranar, Tirunelveli'),
('2017AP00358', 793, 'Higher Secondary', 'Maths and Science', 'Nadar Higher Secondary School, Kovilpa􀆫', '', '1996-04-30', '1062', '1200', '88.50', '1', 'hssc', 'Tamilnadu State board'),
('2017AP00358', 794, 'Secondary School', 'Maths and Science', 'Nadar Higher Secondary School, Kovilpa􀆫', '', '1994-04-30', '429', '500', '85.80', '1', 'ssc', 'Tamilnadu State board'),
('2017AS04615', 795, 'MTech', 'Computer Science & Engineering', 'ABES EC Ghaziabad', '', '2008-05-05', '9.67', '10', '9.67', '1', 'pg', 'UPTU Lucknow'),
('2017AP00359', 796, 'MTech', 'Computer Science & Engineering', 'ABES EC Ghaziabad', '', '2008-05-05', '9.67', '10', '9.67', '1', 'pg', 'UPTU Lucknow'),
('2017AP00359', 797, 'BE', 'Computer Science & Engineering', 'BSACET Mathura', '', '2002-08-28', '2774', '3400', '81.58', '1', 'ug', '`Dr BRA University Agra'),
('2017AP00359', 798, 'Intermediate', 'PHYSIC S, CHEMISTRY, MATHEMATICS, ENGLISH AND GENERAL HINDI', 'GIC MATHURA', '', '1995-08-02', '357', '500', '71.4', '1', 'hssc', 'U.P. Board Allahabad'),
('2017AP00359', 799, 'High School', 'SCIENCE-II, MATHEMATICS-II, BIOLOGY, ENGLISH, HINDI AND SOCIAL SCIENCE', 'GIC MATHURA', '', '1993-07-07', '450', '600', '75%', '1', 'ssc', 'U.P. Board Allahabad'),
('2017AP00334', 800, 'MTech', 'Production and Industrial Systems Engineering', 'Indian Institute of Technology, Roorkee', '2001-07-25', '2003-04-01', '8.36', '10', '8.36', '1', 'pg', 'Indian Institute of Technology, Roorkee'),
('2017AP00334', 801, 'BTech', 'Mechanical Engineering', 'Koneru Lakshmaiah College of Engineering', '1998-07-15', '2001-05-28', '2621', '3175', '82.55', '1', 'ug', 'Nagarjuna University, Andhra Pradesh'),
('2017AP00334', 802, 'Diploma in Mechanical Engineering', 'Mechanical Engineering', 'MBTS Govt Polytechnic, Guntur', '1995-06-13', '1998-07-02', '1592', '2000', '79.6', '1', 'hssc', 'State Board of Technical Education & Training, A.P., Hyderabad'),
('2017AP00334', 803, 'SSC', 'Mathematics, General Science, Social Studies, English, Telugu, Hindi', 'St. Pauls High School, Phirangipuram', '1993-06-13', '1994-05-31', '428', '600', '71.33', '1', 'ssc', 'Board of Secondary Education, Andhra Pradesh'),
('2017AP00360', 804, 'M.Sc.', 'Biotechnology', 'Institute of Science', '1996-08-01', '1998-05-31', '1230', '1800', '68.3', '1', 'pg', 'Banaras Hindu University, Varanasi, India'),
('2017AP00360', 805, 'B.Sc.', 'Math, Physics, Chemistry', 'MLK(PG) College, Balrampur, India', '1992-08-01', '1995-05-31', '1255', '1800', '69.7', '1', 'ug', 'RML Avadh University, Faizabad, India'),
('2017AP00361', 807, 'b tech', 'ece', 'mnnit', '2010-07-17', '2015-07-31', '6.19', '10', '61', '1', 'ug', 'mnnit allahabad'),
('2017AP00360', 808, 'Intermediate', 'Hindi, English, Physics, Chemistry, Math', 'MPP Inter College, Balrampur, India', '1989-08-01', '1991-05-31', '351', '500', '70.2', '1', 'hssc', 'UP Board, Allahabad,India'),
('2017AP00294', 809, 'MBA', 'Marketing', 'Deptt. of Management, Tilak Maharashtra University, Pune', '2008-07-15', '2010-08-10', '1425', '2200', '64.77', '1', 'pg', 'Tilak Maharashtra University, Pune'),
('2017AP00360', 810, 'High School', 'Hindi, English, Math2, Science2, Biology, S. Science', 'MPP Inter College, Balrampur, India', '1987-08-01', '1989-05-31', '425', '600', '70.8', '1', 'ssc', 'UP Board, Allahabad,India'),
('2017AP00294', 811, 'BSc', 'PCM', 'AGRA COLLEGE AGRA', '1991-07-15', '1994-09-05', '834', '1400', '59.68', 'NA', 'ug', 'AGRA UNIVERSITY, AGRA'),
('2017AP00294', 812, 'INTERMEDIATE', 'SCIENCE', 'SRM INTER COLLEGE, BISALPUR, PILIBHIT', '1989-06-03', '1991-05-04', '305', '500', '61', '1', 'hssc', 'UP BOARD'),
('2017AP00294', 813, 'HIGH SCHOOL', 'SCIENCE', 'SRM INTER COLLEGE, BISALPUR, PILIBHIT', '1987-06-03', '1989-06-08', '360', '600', '60', '1', 'ssc', 'UP BOARD'),
('2017AP00294', 814, 'PGDM', 'INTERNATIONAL BUSINESS', 'AIMA, NEW DELHI', '1995-08-09', '1998-06-12', '3.04', '4.00', '76', '1', 'pg', 'AIMA, NEW DELHI'),
('2017AP00364', 815, 'Master of Technology in Civil Engineering (Environmental Engineering)', 'Civil Engineering (Environmental Engineering)', 'Motilal Nehru National Institute of Technology Allahabad', '', '2005-06-30', '9.4', '10', '9.4', 'NA', 'pg', 'Motilal Nehru National Institute of Technology Allahabad'),
('2017AP00364', 816, 'B.E. Civil Engineering', 'Civil Engineering', 'Amravati University', '', '2002-05-30', '674', '1000', '67.4%', '1', 'ug', 'Amravati University'),
('2017AP00364', 817, 'Indian School Certificate Examination', 'Science', 'Carmel School Dhanbad', '', '1998-03-31', '404', '500', '80.8%', 'NA', 'hssc', 'COUNCIL FOR THE INDIAN SCHOOL CERTIFICATE EXAMINATION , NEW DELHI'),
('2017AP00364', 818, 'Indian Certificate of Secondary Education Examination', 'All Subjects', 'Carmel School Dhanbad', '', '1996-03-30', '460', '600', '76.7%', 'NA', 'ssc', 'COUNCIL FOR THE INDIAN SCHOOL CERTIFICATE EXAMINATION , NEW DELHI'),
('2017AP00367', 819, 'MS', 'Software Systems', 'Birla Institute of Technology & Science Pilani', '2005-05-01', '2008-05-29', '7.54', '10', '7.54', '1', 'pg', 'Birla Institute of Technology & Science Pilani'),
('2017AP00367', 820, 'MCA', 'Computer Applications', 'VIT Pune', '2000-06-30', '2002-03-27', '1230', '1800', '68.33', '1', 'pg', 'IGNOU'),
('2017AP00367', 821, 'BCA', 'Computer Applications', 'VIT Pune', '1997-05-01', '2000-06-29', '827', '1200', '68.92', '1', 'ug', 'IGNOU'),
('2017AP00367', 822, 'HSC Science Stream', 'Science Stream', 'GSSS School Baberpur', '1994-06-01', '1995-05-28', '340', '500', '68', '1', 'hssc', 'CBSE'),
('2017AP00367', 823, 'SSC', 'Gen Stream', 'GBSS School Baberpur', '1991-06-01', '1992-05-31', '365', '500', '73', '1', 'ssc', 'CBSE'),
('2017AP00368', 824, 'M.Tech (Master of Technology)', 'Process Engineering and Design/Chemical Engineering', 'Indian Institute of Technology, Delhi (IIT Delhi)', '', '2002-12-31', '7.192', '10', '7.192', '1', 'pg', 'Indian Institute of Technology, Delhi (IIT Delhi)'),
('2017AP00368', 825, 'Bachelor of Engineering (B.E.)', 'Chemical Engineering', 'Thapar Institute of Engineering and Technology, Patiala (Now Thapar University)', '', '2001-05-31', '7.58', '10', '68.2/7.58', '1', 'ug', 'Thapar Institute of Engineering and Technology, Patiala (Now Thapar University)'),
('2017AP00369', 826, 'M. Tech', 'Biochemical Engineering', 'Indian Institute of Technology, BHU, Varanasi', '1996-07-01', '1998-07-21', '10', '10', 'CGPA 10', '1', 'pg', 'Banaras Hindu University'),
('2017AP00369', 828, 'M.Sc.', 'Biochemistry', 'Faculty of Science, BHU', '1994-07-01', '1996-07-02', '1150', '1500', '76.7', '1', 'pg', 'Banaras Hindu University'),
('2017AP00369', 829, 'B.Sc.', 'Chemistry (Hons), botany, zoology', 'Mahila Maha Vidyalaya', '1991-07-01', '1994-08-06', '734', '1000', '73.4', '1', 'ug', 'Banaras Hindu University'),
('2017AP00369', 831, 'AISSCE', 'physics, Math, Chemistry, English, Hindi', 'Kendriya Vidyalaya, HFC Urvaraknagar Barauni', '1989-07-01', '1990-06-04', '315', '500', '63', '1', 'hssc', 'CBSE'),
('2017AP00369', 832, 'AISSE', 'English, Hindi, Math, Science, Social science', 'Kendriya Vidyalaya, HFC Urvaraknagar Barauni', '1987-07-01', '1988-06-03', '350', '500', '70', '1', 'ssc', 'CBSE'),
('2017AP00372', 835, 'M. Tech', 'Biochemical Engineering', 'Indian Institute of Technology, BHU, Varanasi', '1996-07-01', '1998-07-21', '10', '10', 'CGPA 10', '1', 'pg', 'Banaras Hindu University'),