Lines 1-52
Link Here
|
1 |
INSERT INTO `borrowers` (`borrowernumber`, `cardnumber`, `surname`, `firstname`, `title`, `othernames`, `initials`, `streetnumber`, `streettype`, `address`, `address2`, `city`, `zipcode`, `email`, `phone`, `mobile`, `fax`, `emailpro`, `phonepro`, `B_streetnumber`, `B_streettype`, `B_address`, `B_city`, `B_zipcode`, `B_email`, `B_phone`, `dateofbirth`, `branchcode`, `categorycode`, `dateenrolled`, `dateexpiry`, `gonenoaddress`, `lost`, `debarred`, `contactname`, `contactfirstname`, `contacttitle`, `guarantorid`, `borrowernotes`, `relationship`, `ethnicity`, `ethnotes`, `sex`, `userid`, `opacnote`, `contactnote`, `password`, `flags`, `sort1`, `sort2`) VALUES |
1 |
INSERT |
2 |
|
2 |
INTO borrowers (borrowernumber, cardnumber, surname, firstname, title, othernames, initials, streetnumber, streettype, address, address2, city, zipcode, email, phone, mobile, fax, emailpro, phonepro, B_streetnumber, B_streettype, B_address, B_city, B_zipcode, B_email, B_phone, dateofbirth, branchcode, categorycode, dateenrolled, dateexpiry, gonenoaddress, lost, debarred, contactname, contactfirstname, contacttitle, guarantorid, borrowernotes, relationship, ethnicity, ethnotes, sex, userid, opacnote, contactnote, password, flags, sort1, sort2) |
3 |
(1,'1','Admin','Koha',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MPL','S',NULL,'2099-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), |
3 |
VALUES |
4 |
(2,'23529000152273','Welch','Marcus',NULL,NULL,'',NULL,NULL,'5601 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRL','ST','1985-10-24','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000152273',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.43609457503641','0.38613959717205'), |
4 |
(1, '1', 'Admin', 'Koha', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MPL', 'S', NULL, '2099-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), |
5 |
(3,'23529000445172','Daniels','Tanya',NULL,NULL,'',NULL,NULL,'2035 Library Rd.',NULL,'Portland, ME','44236',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1966-10-14','MPL','PT','1990-08-22','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000445172',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.62241429148467','0.95365269664084'), |
5 |
(2, '23529000152273', 'Welch', 'Marcus', NULL, NULL, '', NULL, NULL, '5601 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FRL', 'ST', '1985-10-24', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000152273', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.43609457503641', '0.38613959717205'), |
6 |
(4,'23529000105040','Dillon','Eva',NULL,NULL,'',NULL,NULL,'8916 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-04-03','MPL','PT','1987-07-01','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000105040',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.90102063948384','0.64414513823031'), |
6 |
(3, '23529000445172', 'Daniels', 'Tanya', NULL, NULL, '', NULL, NULL, '2035 Library Rd.', NULL, 'Portland, ME', '44236', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1966-10-14', 'MPL', 'PT', '1990-08-22', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000445172', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.62241429148467', '0.95365269664084'), |
7 |
(5,'23529001000463','Acosta','Edna',NULL,NULL,'',NULL,NULL,'7896 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1980-04-24','MPL','PT','1990-11-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529001000463',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.72642678648832','0.6644830635418'), |
7 |
(4, '23529000105040', 'Dillon', 'Eva', NULL, NULL, '', NULL, NULL, '8916 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1952-04-03', 'MPL', 'PT', '1987-07-01', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000105040', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.90102063948384', '0.64414513823031'), |
8 |
(6,'23529000591678','Glass','Virgil',NULL,NULL,'',NULL,NULL,'6250 Library Rd.',NULL,'Santa Cruz, CA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1974-06-19','SPL','T','1985-02-13','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,102,NULL,NULL,NULL,NULL,'M','23529000591678',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.1431349889777','0.72222578499673'), |
8 |
(5, '23529001000463', 'Acosta', 'Edna', NULL, NULL, '', NULL, NULL, '7896 Library Rd.', NULL, 'Portland, OR', '44240', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1980-04-24', 'MPL', 'PT', '1990-11-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529001000463', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.72642678648832', '0.6644830635418'), |
9 |
(7,'23529000080862','Middleton','Bobbie',NULL,NULL,'',NULL,NULL,'4619 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1953-07-24','SPL','J','1991-03-13','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,104,NULL,NULL,NULL,NULL,'M','23529000080862',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.18172398878422','0.74194261966454'), |
9 |
(6, '23529000591678', 'Glass', 'Virgil', NULL, NULL, '', NULL, NULL, '6250 Library Rd.', NULL, 'Santa Cruz, CA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1974-06-19', 'SPL', 'T', '1985-02-13', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 102, NULL, NULL, NULL, NULL, 'M', '23529000591678', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.1431349889777', '0.72222578499673'), |
10 |
(8,'23529000358268','Rivera','Olga',NULL,NULL,'',NULL,NULL,'6058 Library Rd.',NULL,'Mayfield Heights, OH','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1979-12-22','PVL','T','1986-04-17','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,112,NULL,NULL,NULL,NULL,'F','23529000358268',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.16454116270369','0.59687798525847'), |
10 |
(7, '23529000080862', 'Middleton', 'Bobbie', NULL, NULL, '', NULL, NULL, '4619 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1953-07-24', 'SPL', 'J', '1991-03-13', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 104, NULL, NULL, NULL, NULL, 'M', '23529000080862', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.18172398878422', '0.74194261966454'), |
11 |
(9,'23529000429697','Waters','Annie',NULL,NULL,'',NULL,NULL,'5444 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1932-10-27','FRL','ST','1984-05-07','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000429697',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.49076646891494','0.66319841953292'), |
11 |
(8, '23529000358268', 'Rivera', 'Olga', NULL, NULL, '', NULL, NULL, '6058 Library Rd.', NULL, 'Mayfield Heights, OH', '21234', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1979-12-22', 'PVL', 'T', '1986-04-17', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 112, NULL, NULL, NULL, NULL, 'F', '23529000358268', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.16454116270369', '0.59687798525847'), |
12 |
(10,'23529000068917','Herring','Frances',NULL,NULL,'',NULL,NULL,'4024 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1953-02-13','SPL','PT','1993-03-12','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000068917',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.84369272165344','0.22886838040209'), |
12 |
(9, '23529000429697', 'Waters', 'Annie', NULL, NULL, '', NULL, NULL, '5444 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1932-10-27', 'FRL', 'ST', '1984-05-07', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000429697', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.49076646891494', '0.66319841953292'), |
13 |
(11,'23529000065863','Hawkins','Sam',NULL,NULL,'',NULL,NULL,'665 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1924-03-26','SPL','PT','1984-05-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000065863',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.61326376778378','0.37971372844625'), |
13 |
(10, '23529000068917', 'Herring', 'Frances', NULL, NULL, '', NULL, NULL, '4024 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1953-02-13', 'SPL', 'PT', '1993-03-12', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000068917', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.84369272165344', '0.22886838040209'), |
14 |
(12,'23529000878885','Mcknight','Marie',NULL,NULL,'',NULL,NULL,'4241 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','YA','1990-08-06','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000878885',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.058777369613552','0.15474569346266'), |
14 |
(11, '23529000065863', 'Hawkins', 'Sam', NULL, NULL, '', NULL, NULL, '665 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1924-03-26', 'SPL', 'PT', '1984-05-09', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000065863', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.61326376778378', '0.37971372844625'), |
15 |
(13,'23529000132291','Edwards','Roy',NULL,NULL,'',NULL,NULL,'9929 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1928-09-09','MPL','PT','1992-03-10','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000132291',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.59739638920631','0.5227448963772'), |
15 |
(12, '23529000878885', 'Mcknight', 'Marie', NULL, NULL, '', NULL, NULL, '4241 Library Rd.', NULL, 'Centerville, CA', '44262', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SPL', 'YA', '1990-08-06', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000878885', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.058777369613552', '0.15474569346266'), |
16 |
(14,'23529000035726','Mccullough','Phillip',NULL,NULL,'',NULL,NULL,'410 Library Rd.',NULL,'Portland, ME','44236',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1943-11-23','SPL','PT','1986-01-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000035726',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.82153534500071','0.53944206660561'), |
16 |
(13, '23529000132291', 'Edwards', 'Roy', NULL, NULL, '', NULL, NULL, '9929 Library Rd.', NULL, 'Portland, OR', '44240', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1928-09-09', 'MPL', 'PT', '1992-03-10', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000132291', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.59739638920631', '0.5227448963772'), |
17 |
(15,'23529001203323','Peterson','Gordon',NULL,NULL,'',NULL,NULL,'6285 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1963-10-01','SPL','J','1984-09-11','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,131,NULL,NULL,NULL,NULL,'F','23529001203323',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.23260432875958','0.54469547471469'), |
17 |
(14, '23529000035726', 'Mccullough', 'Phillip', NULL, NULL, '', NULL, NULL, '410 Library Rd.', NULL, 'Portland, ME', '44236', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1943-11-23', 'SPL', 'PT', '1986-01-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000035726', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.82153534500071', '0.53944206660561'), |
18 |
(16,'23529000991266','Walker','Andrea',NULL,NULL,'',NULL,NULL,'4992 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1956-08-05','FRL','IL','1993-06-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000991266',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.025664418028355','0.49423569673135'), |
18 |
(15, '23529001203323', 'Peterson', 'Gordon', NULL, NULL, '', NULL, NULL, '6285 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1963-10-01', 'SPL', 'J', '1984-09-11', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 131, NULL, NULL, NULL, NULL, 'F', '23529001203323', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.23260432875958', '0.54469547471469'), |
19 |
(17,'23529000711078','King','Casey',NULL,NULL,'',NULL,NULL,'3438 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1953-09-23','SPL','S','1992-05-18','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000711078',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.39418526030535','0.48821924206635'), |
19 |
(16, '23529000991266', 'Walker', 'Andrea', NULL, NULL, '', NULL, NULL, '4992 Library Rd.', NULL, 'Portland, OR', '44240', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1956-08-05', 'FRL', 'IL', '1993-06-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000991266', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.025664418028355', '0.49423569673135'), |
20 |
(18,'23529000809559','Delgado','Floyd',NULL,NULL,'',NULL,NULL,'6661 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1968-02-01','MPL','K','1988-08-05','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,160,NULL,NULL,NULL,NULL,'M','23529000809559',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.25854046014933','0.82804460528125'), |
20 |
(17, '23529000711078', 'King', 'Casey', NULL, NULL, '', NULL, NULL, '3438 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1953-09-23', 'SPL', 'S', '1992-05-18', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000711078', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.39418526030535', '0.48821924206635'), |
21 |
(19,'23529000035676','Acevedo','Henry',NULL,NULL,'',NULL,NULL,'4345 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1958-05-30','MPL','S','1990-09-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000035676',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.36460167669188','0.33887459834933'), |
21 |
(18, '23529000809559', 'Delgado', 'Floyd', NULL, NULL, '', NULL, NULL, '6661 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1968-02-01', 'MPL', 'K', '1988-08-05', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 160, NULL, NULL, NULL, NULL, 'M', '23529000809559', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.25854046014933', '0.82804460528125'), |
22 |
(20,'23529000033739','Frazier','Sonia',NULL,NULL,'',NULL,NULL,'8165 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1945-09-16','MPL','PT','1984-06-21','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000033739',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.60056799240463','0.98621619770882'), |
22 |
(19, '23529000035676', 'Acevedo', 'Henry', NULL, NULL, '', NULL, NULL, '4345 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1958-05-30', 'MPL', 'S', '1990-09-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000035676', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.36460167669188', '0.33887459834933'), |
23 |
(21,'23529000139858','Ballard','Ronnie',NULL,NULL,'',NULL,NULL,'5730 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1956-02-23','MPL','T','1989-06-01','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,177,NULL,NULL,NULL,NULL,'F','23529000139858',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.12937704206386','0.68823664792649'), |
23 |
(20, '23529000033739', 'Frazier', 'Sonia', NULL, NULL, '', NULL, NULL, '8165 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1945-09-16', 'MPL', 'PT', '1984-06-21', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000033739', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.60056799240463', '0.98621619770882'), |
24 |
(22,'23529000224510','Gaines','Joyce',NULL,NULL,'',NULL,NULL,'6012 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1957-08-01','SPL','YA','1992-09-16','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000224510',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.053052144174513','0.20055080782673'), |
24 |
(21, '23529000139858', 'Ballard', 'Ronnie', NULL, NULL, '', NULL, NULL, '5730 Library Rd.', NULL, 'Centerville, CA', '44262', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1956-02-23', 'MPL', 'T', '1989-06-01', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 177, NULL, NULL, NULL, NULL, 'F', '23529000139858', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.12937704206386', '0.68823664792649'), |
25 |
(23,'23529000120056','Bryan','Johnny',NULL,NULL,'',NULL,NULL,'8180 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1961-10-24','MPL','PT','1990-08-22','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000120056',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.84359763734378','0.61633579397233'), |
25 |
(22, '23529000224510', 'Gaines', 'Joyce', NULL, NULL, '', NULL, NULL, '6012 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1957-08-01', 'SPL', 'YA', '1992-09-16', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000224510', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.053052144174513', '0.20055080782673'), |
26 |
(24,'23529000218553','Duffy','Joann',NULL,NULL,'',NULL,NULL,'1555 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1942-02-17','MPL','ST','1984-08-02','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000218553',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.55088608856395','0.90542309163643'), |
26 |
(23, '23529000120056', 'Bryan', 'Johnny', NULL, NULL, '', NULL, NULL, '8180 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1961-10-24', 'MPL', 'PT', '1990-08-22', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000120056', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.84359763734378', '0.61633579397233'), |
27 |
(25,'23529000662701','Mejia','Armando',NULL,NULL,'',NULL,NULL,'8209 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1939-07-22','SPL','PT','1990-09-26','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000662701',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.87445722322395','0.65601687194409'), |
27 |
(24, '23529000218553', 'Duffy', 'Joann', NULL, NULL, '', NULL, NULL, '1555 Library Rd.', NULL, 'Portland, OR', '44240', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1942-02-17', 'MPL', 'ST', '1984-08-02', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000218553', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.55088608856395', '0.90542309163643'), |
28 |
(26,'23529000092040','Hendrix','Keith',NULL,NULL,'',NULL,NULL,'6546 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1944-04-05','SPL','PT','1987-12-12','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000092040',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.65671272078223','0.31551301881253'), |
28 |
(25, '23529000662701', 'Mejia', 'Armando', NULL, NULL, '', NULL, NULL, '8209 Library Rd.', NULL, 'Portland, OR', '44240', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1939-07-22', 'SPL', 'PT', '1990-09-26', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000662701', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.87445722322395', '0.65601687194409'), |
29 |
(27,'23529000058017','Turner','Sherri',NULL,NULL,'',NULL,NULL,'1731 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1964-11-21','FRL','PT','1987-09-14','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000058017',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.60742696244961','0.090595786544118'), |
29 |
(26, '23529000092040', 'Hendrix', 'Keith', NULL, NULL, '', NULL, NULL, '6546 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1944-04-05', 'SPL', 'PT', '1987-12-12', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000092040', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.65671272078223', '0.31551301881253'), |
30 |
(28,'23529000299603','Cherry','Lillie',NULL,NULL,'',NULL,NULL,'263 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1931-01-19','MPL','PT','1993-03-19','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000299603',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.6306980761054','0.88170305162827'), |
30 |
(27, '23529000058017', 'Turner', 'Sherri', NULL, NULL, '', NULL, NULL, '1731 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1964-11-21', 'FRL', 'PT', '1987-09-14', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000058017', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.60742696244961', '0.090595786544118'), |
31 |
(29,'23529000121682','Schneider','Nicole',NULL,NULL,'',NULL,NULL,'1008 Library Rd.',NULL,'Centerville, CA','44306',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1954-01-12','FRL','ST','1985-09-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000121682',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.5164210605588','0.93699617864284'), |
31 |
(28, '23529000299603', 'Cherry', 'Lillie', NULL, NULL, '', NULL, NULL, '263 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1931-01-19', 'MPL', 'PT', '1993-03-19', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000299603', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.6306980761054', '0.88170305162827'), |
32 |
(30,'23529000240482','White','Jamie',NULL,NULL,'',NULL,NULL,'937 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1950-04-22','FRL','T','1990-02-03','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,254,NULL,NULL,NULL,NULL,'F','23529000240482',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.13571774227146','0.86760020616241'), |
32 |
(29, '23529000121682', 'Schneider', 'Nicole', NULL, NULL, '', NULL, NULL, '1008 Library Rd.', NULL, 'Centerville, CA', '44306', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1954-01-12', 'FRL', 'ST', '1985-09-09', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000121682', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.5164210605588', '0.93699617864284'), |
33 |
(31,'23529000714163','Burgess','Dawn',NULL,NULL,'',NULL,NULL,'7907 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MPL','PT','1985-05-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000714163',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.93084783473131','0.051438585902973'), |
33 |
(30, '23529000240482', 'White', 'Jamie', NULL, NULL, '', NULL, NULL, '937 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1950-04-22', 'FRL', 'T', '1990-02-03', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 254, NULL, NULL, NULL, NULL, 'F', '23529000240482', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.13571774227146', '0.86760020616241'), |
34 |
(32,'23529000318858','Bennett','Pamela',NULL,NULL,'',NULL,NULL,'9898 Library Rd.',NULL,'Centerville, CA','44310',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1946-09-16','MPL','ST','1984-05-08','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000318858',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.46464945605458','0.16893155329761'), |
34 |
(31, '23529000714163', 'Burgess', 'Dawn', NULL, NULL, '', NULL, NULL, '7907 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MPL', 'PT', '1985-05-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000714163', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.93084783473131', '0.051438585902973'), |
35 |
(33,'23529000526047','Hatfield','Lester',NULL,NULL,'',NULL,NULL,'393 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1983-01-22','SPL','ST','1988-07-30','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000526047',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.45070942905798','0.74675251613069'), |
35 |
(32, '23529000318858', 'Bennett', 'Pamela', NULL, NULL, '', NULL, NULL, '9898 Library Rd.', NULL, 'Centerville, CA', '44310', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1946-09-16', 'MPL', 'ST', '1984-05-08', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000318858', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.46464945605458', '0.16893155329761'), |
36 |
(34,'23529000686353','Harper','Ruben',NULL,NULL,'',NULL,NULL,'6963 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1917-09-24','SPL','S','1991-02-19','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000686353',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.38163432421315','0.66791410340733'), |
36 |
(33, '23529000526047', 'Hatfield', 'Lester', NULL, NULL, '', NULL, NULL, '393 Library Rd.', NULL, 'Centerville, CA', '44262', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1983-01-22', 'SPL', 'ST', '1988-07-30', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000526047', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.45070942905798', '0.74675251613069'), |
37 |
(35,'23529000719519','Kinney','Mae',NULL,NULL,'',NULL,NULL,'2114 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','J','1991-12-29','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,287,NULL,NULL,NULL,NULL,'F','23529000719519',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.19466757513086','0.96959559616595'), |
37 |
(34, '23529000686353', 'Harper', 'Ruben', NULL, NULL, '', NULL, NULL, '6963 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1917-09-24', 'SPL', 'S', '1991-02-19', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000686353', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.38163432421315', '0.66791410340733'), |
38 |
(36,'23529000179433','Williamson','Catherine',NULL,NULL,'',NULL,NULL,'5879 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1930-12-18','FRL','K','1985-01-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,288,NULL,NULL,NULL,NULL,'M','23529000179433',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.26397528617082','0.41108967308988'), |
38 |
(35, '23529000719519', 'Kinney', 'Mae', NULL, NULL, '', NULL, NULL, '2114 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SPL', 'J', '1991-12-29', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 287, NULL, NULL, NULL, NULL, 'F', '23529000719519', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.19466757513086', '0.96959559616595'), |
39 |
(37,'23529000197047','Charles','Lisa',NULL,NULL,'',NULL,NULL,'6813 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1982-10-14','MPL','K','1988-11-14','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,289,NULL,NULL,NULL,NULL,'M','23529000197047',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.26352253767058','0.084343699816934'), |
39 |
(36, '23529000179433', 'Williamson', 'Catherine', NULL, NULL, '', NULL, NULL, '5879 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1930-12-18', 'FRL', 'K', '1985-01-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 288, NULL, NULL, NULL, NULL, 'M', '23529000179433', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.26397528617082', '0.41108967308988'), |
40 |
(38,'23529000695412','Singleton','Bob',NULL,NULL,'',NULL,NULL,'4554 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1983-04-15','FRL','PT','1991-07-01','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000695412',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.63115091680656','0.90272351531566'), |
40 |
(37, '23529000197047', 'Charles', 'Lisa', NULL, NULL, '', NULL, NULL, '6813 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1982-10-14', 'MPL', 'K', '1988-11-14', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 289, NULL, NULL, NULL, NULL, 'M', '23529000197047', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.26352253767058', '0.084343699816934'), |
41 |
(39,'23529000603242','Mcconnell','Terrence',NULL,NULL,'',NULL,NULL,'7200 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1949-06-10','SPL','PT','1984-05-31','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000603242',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.62016485689223','0.39265376924784'), |
41 |
(38, '23529000695412', 'Singleton', 'Bob', NULL, NULL, '', NULL, NULL, '4554 Library Rd.', NULL, 'Centerville, CA', '44262', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1983-04-15', 'FRL', 'PT', '1991-07-01', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000695412', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.63115091680656', '0.90272351531566'), |
42 |
(40,'23529000589458','Knight','Mabel',NULL,NULL,'',NULL,NULL,'8997 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-12-22','SPL','T','1985-04-17','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,320,NULL,NULL,NULL,NULL,'M','23529000589458',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.10277430629616','0.33591025447092'), |
42 |
(39, '23529000603242', 'Mcconnell', 'Terrence', NULL, NULL, '', NULL, NULL, '7200 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1949-06-10', 'SPL', 'PT', '1984-05-31', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000603242', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.62016485689223', '0.39265376924784'), |
43 |
(41,'23529000054503','Odom','Gloria',NULL,NULL,'',NULL,NULL,'9156 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-04-05','SPL','S','1992-07-21','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000054503',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.37122838419976','0.84841118831971'), |
43 |
(40, '23529000589458', 'Knight', 'Mabel', NULL, NULL, '', NULL, NULL, '8997 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1952-12-22', 'SPL', 'T', '1985-04-17', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 320, NULL, NULL, NULL, NULL, 'M', '23529000589458', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.10277430629616', '0.33591025447092'), |
44 |
(42,'23529000126806','Hopkins','Brent',NULL,NULL,'',NULL,NULL,'6692 Library Rd.',NULL,'Santa Cruz, CA','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1977-11-13','SPL','T','1984-06-28','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,337,NULL,NULL,NULL,NULL,'F','23529000126806',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.12837081973289','0.096620564438981'), |
44 |
(41, '23529000054503', 'Odom', 'Gloria', NULL, NULL, '', NULL, NULL, '9156 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1952-04-05', 'SPL', 'S', '1992-07-21', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000054503', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.37122838419976', '0.84841118831971'), |
45 |
(43,'23529000104159','Benson','Clinton',NULL,NULL,'',NULL,NULL,'4695 Library Rd.',NULL,'Atwater, OH','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MPL','YA','1985-10-28','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000104159',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.097990393729872','0.20009030606606'), |
45 |
(42, '23529000126806', 'Hopkins', 'Brent', NULL, NULL, '', NULL, NULL, '6692 Library Rd.', NULL, 'Santa Cruz, CA', '21234', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1977-11-13', 'SPL', 'T', '1984-06-28', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 337, NULL, NULL, NULL, NULL, 'F', '23529000126806', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.12837081973289', '0.096620564438981'), |
46 |
(44,'23529000395609','Stuart','Shannon',NULL,NULL,'',NULL,NULL,'5011 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1951-02-13','FRL','PT','1986-01-16','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000395609',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.70648037987433','0.93213101190713'), |
46 |
(43, '23529000104159', 'Benson', 'Clinton', NULL, NULL, '', NULL, NULL, '4695 Library Rd.', NULL, 'Atwater, OH', '21234', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MPL', 'YA', '1985-10-28', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000104159', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.097990393729872', '0.20009030606606'), |
47 |
(45,'23529000050113','Alford','Jordan',NULL,NULL,'',NULL,NULL,'5129 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-05-27','MPL','ST','1985-09-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000050113',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.54121395064631','0.90967674824379'), |
47 |
(44, '23529000395609', 'Stuart', 'Shannon', NULL, NULL, '', NULL, NULL, '5011 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1951-02-13', 'FRL', 'PT', '1986-01-16', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000395609', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.70648037987433', '0.93213101190713'), |
48 |
(46,'23529000053836','Mcfarland','Marilyn',NULL,NULL,'',NULL,NULL,'4600 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','PT','1984-05-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000053836',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.92474192001367','0.89467938607063'), |
48 |
(45, '23529000050113', 'Alford', 'Jordan', NULL, NULL, '', NULL, NULL, '5129 Library Rd.', NULL, 'Centerville, CA', '44262', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1952-05-27', 'MPL', 'ST', '1985-09-09', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000050113', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.54121395064631', '0.90967674824379'), |
49 |
(47,'23529000774373','Morris','Lauren',NULL,NULL,'',NULL,NULL,'5436 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','PT','1986-03-20','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000774373',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.69917120104578','0.81181787775067'), |
49 |
(46, '23529000053836', 'Mcfarland', 'Marilyn', NULL, NULL, '', NULL, NULL, '4600 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SPL', 'PT', '1984-05-09', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000053836', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.92474192001367', '0.89467938607063'), |
50 |
(48,'23529000117565','Palmer','Bill',NULL,NULL,'',NULL,NULL,'2761 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1984-01-10','SPL','PT','1991-10-07','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000117565',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.96157581634966','0.37242547922994'), |
50 |
(47, '23529000774373', 'Morris', 'Lauren', NULL, NULL, '', NULL, NULL, '5436 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SPL', 'PT', '1986-03-20', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000774373', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.69917120104578', '0.81181787775067'), |
51 |
(49,'23529000651225','Burton','Mary',NULL,NULL,'',NULL,NULL,'8131 Library Rd.',NULL,'Santa Cruz, CA','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1977-12-25','MPL','PT','1985-05-30','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000651225',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.97739997783434','0.76972348221552'), |
51 |
(48, '23529000117565', 'Palmer', 'Bill', NULL, NULL, '', NULL, NULL, '2761 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1984-01-10', 'SPL', 'PT', '1991-10-07', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000117565', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.96157581634966', '0.37242547922994'), |
52 |
(50,'23529001223636','Peters','Tommy',NULL,NULL,'',NULL,NULL,'5171 Library Rd.',NULL,'Portland, ME','44236',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1951-06-14','SPL','PT','1984-05-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529001223636',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.91641750830823','0.27291712562825'); |
52 |
(49, '23529000651225', 'Burton', 'Mary', NULL, NULL, '', NULL, NULL, '8131 Library Rd.', NULL, 'Santa Cruz, CA', '21234', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1977-12-25', 'MPL', 'PT', '1985-05-30', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000651225', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.97739997783434', '0.76972348221552'), |
|
|
53 |
(50, '23529001223636', 'Peters', 'Tommy', NULL, NULL, '', NULL, NULL, '5171 Library Rd.', NULL, 'Portland, ME', '44236', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1951-06-14', 'SPL', 'PT', '1984-05-09', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529001223636', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.91641750830823', '0.27291712562825'); |