[JumboJet]

Yo, team, @JumboJet is back in the game! This time I have a juicy SQL dump for you – students table, straight from some educational database from Ghana. NTC/GTLE in indexes, UCC/UEW as schools, regions like GA (Greater Accra), VR (Volta Region) – this looks like a list of students with teacher training or bachelor's degrees. Full package: 47k+ records

What's inside? Names, surnames, gender, dates of birth, telephones, e-mails, physical addresses, programs, results (e.g. "Second Class Upper"), schools, indexes, certificates. A lot of NULLs in fields like nationality or marital status, but the meat is there - e-mails and telephones alive

---

(7, NULL, 'AKAMAH-HLONGBE', 'LOLONYO', 'NTC/GTLE/00043/18', 'male', '0543890954', '01', '1', '1980-09-05', NULL, NULL, NULL, 'on', NULL, 'C/O AVOEME BASIC SCHOOL, P. O. BOX AF 13, AFLAO', 'Christianity', 'koffiaka484@gmail.com', NULL, 0, NULL, NULL, 'VR', NULL, '', 'none', NULL, 'F,F,P,', '2', NULL, NULL, NULL, 'VO01', 'Mr', 1, 1, '2013', '2011', '00516357', '1009091110001', 'KOFFI', '-1', 'REGULAR', '', '', '', 'VR')

(11, NULL, 'AMOAKO', '', 'NTC/GTLE/00047/18', 'female', '0240932408', '01', NULL, '1994-03-24', NULL, NULL, NULL, 'on', NULL, 'P. O. BOX 94, SEFWI WIAWSO', 'Christianity', 'kisslin500@gmail.com', NULL, 0, NULL, NULL, 'WE02', NULL, '1', 'none', NULL, 'F,P,P,', '1', NULL, NULL, NULL, 'WE02', 'Mrs', 1, 1, '2018', '2015', '', 'WACE/086/2018', 'PATRICIA', 'Second Class Upper', 'REGULAR', '', '', '', '')

(19, NULL, 'DENUEME', 'DZIDEFO', 'NTC/GTLE/00055/18', 'male', '0246578615', '01', '1', '1982-08-13', NULL, NULL, NULL, 'on', NULL, 'P.O.BOX 741', 'Christianity', 'francisdenueme@yahoo.com', NULL, 0, NULL, NULL, 'VR', NULL, '', 'none', NULL, 'F,F,F,', '3', NULL, NULL, NULL, 'UCC', 'Mr', 1, 1, '2013', '2008', '00519585', 'DBE/VO/08/0030', 'FRANCIS', '-1', 'REGULAR', '', '', '', 'VR')

(34, NULL, 'Nyaho', ' ', 'NTC/GTLE/00070/18', 'female', '0244616526', '15', '1', '1977-02-08', NULL, NULL, NULL, 'on', NULL, 'GN-0604-7349', 'Christianity', 'chrisboat35@yahoo.com', NULL, 0, NULL, NULL, 'ER', NULL, '', 'none', NULL, 'F,P,P,', '1', NULL, NULL, NULL, 'UEW', 'Miss', NULL, 1, '2018', '2016', '00119589', '4150361046', 'Christiana', '-1', 'REGULAR', '', '', '', 'ER')

(52, NULL, 'Denkyira', '', 'NTC/GTLE/00088/18', 'female', '0547057030', '01', NULL, '1995-12-12', NULL, NULL, NULL, 'on', NULL, 'G222/4 Regemanuel Street-Labadi', 'Christianity', 'hannahdenkyira42@gmail.com', NULL, 0, NULL, NULL, 'CE03', NULL, '1', 'none', NULL, 'F,P,P,', '1', NULL, NULL, NULL, 'EA07', 'Miss', NULL, 1, '2018', '2015', '', 'MCOE/0042/2018', 'Hannah', 'Second Class Upper', 'REGULAR', '', '', '', '')

(66, NULL, 'ADDO', 'SELORM', 'NTC/GTLE/00102/18', 'female', '0247619209', '01', NULL, '1993-02-08', NULL, NULL, NULL, 'on', NULL, 'P.O.BOX M680, ACCRA', 'Christianity', 'judithselormaddo@yahoo.com', NULL, 0, NULL, NULL, 'VO02', NULL, '1', 'none', NULL, 'F,P,P,', '1', NULL, NULL, NULL, 'VO02', 'Miss', 1, 1, '2018', '2015', '', 'STCE/0017/2018', 'JUDITH', '-1', 'REGULAR', '', '', '', '')

(4JUdGzvrMFDWrUUwY3toJATSeNwjn54LkCnKBPRzDuhzi5vSepHfUckJNxRL2gjkNrSqtCoRUrEDAgRwsQvVCjZbRyFTLRNyDmT1a1boZVNULL, NULL, 'on', NULL, 'P. O BOX KZ 4JUdGzvrMFDWrUUwY3toJATSeNwjn54LkCnKBPRzDuhzi5vSepHfUckJNxRL2gjkNrSqtCoRUrEDAgRwsQvVCjZbRyFTLRNyDmT1a1boZV, 'upper', 'none', NULL, NULL, NULL, NULL, NULL, NULL, 'UEW', 'Miss', NULL, NULL, '2018', '2014', NULL, 'GTLE/VR00619/19', 'VIVIAN', '', '', '06', '0209238355', 'regular', '')

(4JUdGzvrMFDWrUUwY3toJATSeNwjn54LkCnKBPRzDuhzi5vSepHfUckJNxRL2gjkNrSqtCoRUrEDAgRwsQvVCjZbRyFTLRNyDmT1a1boZVNULL, 'on', NULL, 'P. O. Box 4JUdGzvrMFDWrUUwY3toJATSeNwjn54LkCnKBPRzDuhzi5vSepHfUckJNxRL2gjkNrSqtCoRUrEDAgRwsQvVCjZbRyFTLRNyDmT1a1boZVNULL, 'first class', 'none', NULL, NULL, NULL, NULL, NULL, NULL, 'UEW', 'Mr', NULL, NULL, '2018', '2014', NULL, '5140040002', 'Ezekiel', '', '', '06', '0555035170', 'regular', '')

(4JUdGzvrMFDWrUUwY3toJATSeNwjn54LkCnKBPRzDuhzi5vSepHfUckJNxRL2gjkNrSqtCoRUrEDAgRwsQvVCjZbRyFTLRNyDmT1a1boZVNULL, 'on', NULL, 'AVEYIME-BATTOR SENIOR HIGH TECHNICAL SCHOOL, P. O. BOX SG 1, SOGAKOPE', 'Christianity', 'omariovincent@gmail.com', NULL, NULL, NULL, '2019-03-22 16:51:14', 'VR', NULL, 'lower', 'none', NULL, NULL, NULL, NULL, NULL, NULL, 'UCC', 'Mr', NULL, NULL, '2019', '2014', NULL, 'ED/BSS/14/0207', 'VINCENT', '', '', '07', '0205865849', 'regular', '')

(4JUdGzvrMFDWrUUwY3toJATSeNwjn54LkCnKBPRzDuhzi5vSepHfUckJNxRL2gjkNrSqtCoRUrEDAgRwsQvVCjZbRyFTLRNyDmT1a1boZVNULL, 'on', NULL, 'ESIAMA', 'Christianity', 'obedandfamily@gmail.com', NULL, NULL, NULL, '2019-03-24 15:36:27', 'WR', NULL, 'upper', 'none', NULL, NULL, NULL, NULL, NULL, NULL, 'UEW', 'Mr', NULL, NULL, '2016', '2013', NULL, '3130360027', 'OBED', '', '', '02', '0244949088', 'distance', '')

---

Download

Hidden Content

You must register or login to view this content.

[Addka72424]

The link in this thread is dead. Please reply to the PM you were sent to get your thread moved back to the Databases section.