From 11dd32142785be1e519c085084b061e3fa378f31 Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Wed, 5 Feb 2020 09:49:14 -0300 Subject: [PATCH] Bug 24584: Rewrite optional/sample_patrons to YAML YAML version of optional sample_patrons To test: 1) Same test plan of first patch, only check table borrowers Signed-off-by: Martin Renvoize --- .../data/mysql/en/optional/sample_patrons.sql | 51 - .../data/mysql/en/optional/sample_patrons.txt | 1 - .../data/mysql/en/optional/sample_patrons.yml | 2427 +++++++++++++++++ 3 files changed, 2427 insertions(+), 52 deletions(-) delete mode 100644 installer/data/mysql/en/optional/sample_patrons.sql delete mode 100644 installer/data/mysql/en/optional/sample_patrons.txt create mode 100644 installer/data/mysql/en/optional/sample_patrons.yml diff --git a/installer/data/mysql/en/optional/sample_patrons.sql b/installer/data/mysql/en/optional/sample_patrons.sql deleted file mode 100644 index d2f16a3650..0000000000 --- a/installer/data/mysql/en/optional/sample_patrons.sql +++ /dev/null @@ -1,51 +0,0 @@ -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`, `borrowernotes`, `relationship`, `sex`, `userid`, `opacnote`, `contactnote`, `password`, `flags`, `sort1`, `sort2`) VALUES -(1,'1','Admin','Koha',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), -(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,'M','23529000152273',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.43609457503641','0.38613959717205'), -(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,'F','23529000445172',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.62241429148467','0.95365269664084'), -(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,'F','23529000105040',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.90102063948384','0.64414513823031'), -(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,'F','23529001000463',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.72642678648832','0.6644830635418'), -(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,NULL,NULL,'M','23529000591678',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.1431349889777','0.72222578499673'), -(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,NULL,NULL,'M','23529000080862',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.18172398878422','0.74194261966454'), -(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,NULL,NULL,'F','23529000358268',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.16454116270369','0.59687798525847'), -(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,'F','23529000429697',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.49076646891494','0.66319841953292'), -(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,'F','23529000068917',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.84369272165344','0.22886838040209'), -(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,'F','23529000065863',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.61326376778378','0.37971372844625'), -(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,'F','23529000878885',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.058777369613552','0.15474569346266'), -(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,'F','23529000132291',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.59739638920631','0.5227448963772'), -(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,'F','23529000035726',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.82153534500071','0.53944206660561'), -(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,NULL,NULL,'F','23529001203323',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.23260432875958','0.54469547471469'), -(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,'F','23529000991266',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.025664418028355','0.49423569673135'), -(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,'F','23529000711078',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.39418526030535','0.48821924206635'), -(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,NULL,NULL,'M','23529000809559',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.25854046014933','0.82804460528125'), -(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,'F','23529000035676',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.36460167669188','0.33887459834933'), -(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,'F','23529000033739',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.60056799240463','0.98621619770882'), -(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,NULL,NULL,'F','23529000139858',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.12937704206386','0.68823664792649'), -(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,'F','23529000224510',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.053052144174513','0.20055080782673'), -(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,'F','23529000120056',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.84359763734378','0.61633579397233'), -(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,'F','23529000218553',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.55088608856395','0.90542309163643'), -(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,'M','23529000662701',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.87445722322395','0.65601687194409'), -(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,'M','23529000092040',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.65671272078223','0.31551301881253'), -(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,'F','23529000058017',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.60742696244961','0.090595786544118'), -(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,'F','23529000299603',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.6306980761054','0.88170305162827'), -(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,'F','23529000121682',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.5164210605588','0.93699617864284'), -(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,NULL,NULL,'F','23529000240482',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.13571774227146','0.86760020616241'), -(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,'M','23529000714163',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.93084783473131','0.051438585902973'), -(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,'M','23529000318858',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.46464945605458','0.16893155329761'), -(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,'F','23529000526047',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.45070942905798','0.74675251613069'), -(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,'M','23529000686353',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.38163432421315','0.66791410340733'), -(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,NULL,NULL,'F','23529000719519',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.19466757513086','0.96959559616595'), -(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,NULL,NULL,'M','23529000179433',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.26397528617082','0.41108967308988'), -(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,NULL,NULL,'M','23529000197047',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.26352253767058','0.084343699816934'), -(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,'F','23529000695412',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.63115091680656','0.90272351531566'), -(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,'F','23529000603242',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.62016485689223','0.39265376924784'), -(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,NULL,NULL,'M','23529000589458',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.10277430629616','0.33591025447092'), -(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,'M','23529000054503',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.37122838419976','0.84841118831971'), -(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,NULL,NULL,'F','23529000126806',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.12837081973289','0.096620564438981'), -(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,'F','23529000104159',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.097990393729872','0.20009030606606'), -(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,'M','23529000395609',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.70648037987433','0.93213101190713'), -(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,'M','23529000050113',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.54121395064631','0.90967674824379'), -(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,'F','23529000053836',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.92474192001367','0.89467938607063'), -(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,'F','23529000774373',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.69917120104578','0.81181787775067'), -(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,'M','23529000117565',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.96157581634966','0.37242547922994'), -(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,'F','23529000651225',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.97739997783434','0.76972348221552'), -(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,'F','23529001223636',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.91641750830823','0.27291712562825'); diff --git a/installer/data/mysql/en/optional/sample_patrons.txt b/installer/data/mysql/en/optional/sample_patrons.txt deleted file mode 100644 index 850d4e3afc..0000000000 --- a/installer/data/mysql/en/optional/sample_patrons.txt +++ /dev/null @@ -1 +0,0 @@ -Sample patrons diff --git a/installer/data/mysql/en/optional/sample_patrons.yml b/installer/data/mysql/en/optional/sample_patrons.yml new file mode 100644 index 0000000000..6cd018a0ef --- /dev/null +++ b/installer/data/mysql/en/optional/sample_patrons.yml @@ -0,0 +1,2427 @@ +--- +# +# Copyright 2020 Koha Development Team +# +# This file is part of Koha. +# +# Koha is free software you can redistribute it and/or modify it under the +# terms of the GNU General Public License as published by the Free Software +# Foundation either version 2 of the License, or (at your option) any later +# version. +# +# Koha is distributed in the hope that it will be useful, but WITHOUT ANY +# WARRANTY without even the implied warranty of MERCHANTABILITY or FITNESS FOR +# A PARTICULAR PURPOSE. See the GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License along +# with Koha if not, write to the Free Software Foundation, Inc., +# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. +# + +description: + - "Sample patrons" + +tables: + - borrowers: + translatable: [ ] + multiline: [] + rows: + - borrowernumber: 1 + cardnumber: 1 + surname: Admin + firstname: Koha + 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: MPL + categorycode: S + dateenrolled: ~ + dateexpiry: "2099-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: ~ + userid: ~ + opacnote: ~ + contactnote: ~ + password: ~ + flags: ~ + sort1: ~ + sort2: ~ + + - borrowernumber: 2 + cardnumber: 23529000152273 + surname: Welch + firstname: Marcus + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 5601 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: ~ + branchcode: FRL + categorycode: ST + dateenrolled: "1985-10-24" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000152273 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.43609457503641 + sort2: 0.38613959717205 + + - borrowernumber: 3 + cardnumber: 23529000445172 + surname: Daniels + firstname: Tanya + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 2035 Library Rd. + address2: ~ + city: Portland, ME + zipcode: 44236 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1966-10-14" + branchcode: MPL + categorycode: PT + dateenrolled: "1990-08-22" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000445172 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.62241429148467 + sort2: 0.95365269664084 + + - borrowernumber: 4 + cardnumber: 23529000105040 + surname: Dillon + firstname: Eva + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 8916 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1952-04-03" + branchcode: MPL + categorycode: PT + dateenrolled: "1987-07-01" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000105040 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.90102063948384 + sort2: 0.64414513823031 + + - borrowernumber: 5 + cardnumber: 23529001000463 + surname: Acosta + firstname: Edna + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 7896 Library Rd. + address2: ~ + city: Portland, OR + zipcode: 44240 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1980-04-24" + branchcode: MPL + categorycode: PT + dateenrolled: "1990-11-23" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529001000463 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.72642678648832 + sort2: 0.6644830635418 + + - borrowernumber: 6 + cardnumber: 23529000591678 + surname: Glass + firstname: Virgil + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 6250 Library Rd. + address2: ~ + city: Santa Cruz, CA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1974-06-19" + branchcode: SPL + categorycode: T + dateenrolled: "1985-02-13" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000591678 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.1431349889777 + sort2: 0.72222578499673 + + - borrowernumber: 7 + cardnumber: 23529000080862 + surname: Middleton + firstname: Bobbie + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 4619 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1953-07-24" + branchcode: SPL + categorycode: J + dateenrolled: "1991-03-13" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000080862 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.18172398878422 + sort2: 0.74194261966454 + + - borrowernumber: 8 + cardnumber: 23529000358268 + surname: Rivera + firstname: Olga + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 6058 Library Rd. + address2: ~ + city: Mayfield Heights, OH + zipcode: 21234 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1979-12-22" + branchcode: PVL + categorycode: T + dateenrolled: "1986-04-17" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000358268 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.16454116270369 + sort2: 0.59687798525847 + + - borrowernumber: 9 + cardnumber: 23529000429697 + surname: Waters + firstname: Annie + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 5444 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1932-10-27" + branchcode: FRL + categorycode: ST + dateenrolled: "1984-05-07" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000429697 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.49076646891494 + sort2: 0.66319841953292 + + - borrowernumber: 10 + cardnumber: 23529000068917 + surname: Herring + firstname: Frances + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 4024 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1953-02-13" + branchcode: SPL + categorycode: PT + dateenrolled: "1993-03-12" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000068917 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.84369272165344 + sort2: 0.22886838040209 + + - borrowernumber: 11 + cardnumber: 23529000065863 + surname: Hawkins + firstname: Sam + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 665 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1924-03-26" + branchcode: SPL + categorycode: PT + dateenrolled: "1984-05-09" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000065863 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.61326376778378 + sort2: 0.37971372844625 + + - borrowernumber: 12 + cardnumber: 23529000878885 + surname: Mcknight + firstname: Marie + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 4241 Library Rd. + address2: ~ + city: Centerville, CA + zipcode: 44262 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: ~ + branchcode: SPL + categorycode: YA + dateenrolled: "1990-08-06" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000878885 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.058777369613552 + sort2: 0.15474569346266 + + - borrowernumber: 13 + cardnumber: 23529000132291 + surname: Edwards + firstname: Roy + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 9929 Library Rd. + address2: ~ + city: Portland, OR + zipcode: 44240 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1928-09-09" + branchcode: MPL + categorycode: PT + dateenrolled: "1992-03-10" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000132291 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.59739638920631 + sort2: 0.5227448963772 + + - borrowernumber: 14 + cardnumber: 23529000035726 + surname: Mccullough + firstname: Phillip + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 410 Library Rd. + address2: ~ + city: Portland, ME + zipcode: 44236 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1943-11-23" + branchcode: SPL + categorycode: PT + dateenrolled: "1986-01-23" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000035726 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.82153534500071 + sort2: 0.53944206660561 + + - borrowernumber: 15 + cardnumber: 23529001203323 + surname: Peterson + firstname: Gordon + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 6285 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1963-10-01" + branchcode: SPL + categorycode: J + dateenrolled: "1984-09-11" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529001203323 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.23260432875958 + sort2: 0.54469547471469 + + - borrowernumber: 16 + cardnumber: 23529000991266 + surname: Walker + firstname: Andrea + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 4992 Library Rd. + address2: ~ + city: Portland, OR + zipcode: 44240 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1956-08-05" + branchcode: FRL + categorycode: IL + dateenrolled: "1993-06-23" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000991266 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.025664418028355 + sort2: 0.49423569673135 + + - borrowernumber: 17 + cardnumber: 23529000711078 + surname: King + firstname: Casey + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 3438 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1953-09-23" + branchcode: SPL + categorycode: S + dateenrolled: "1992-05-18" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000711078 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.39418526030535 + sort2: 0.48821924206635 + + - borrowernumber: 18 + cardnumber: 23529000809559 + surname: Delgado + firstname: Floyd + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 6661 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1968-02-01" + branchcode: MPL + categorycode: K + dateenrolled: "1988-08-05" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000809559 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.25854046014933 + sort2: 0.82804460528125 + + - borrowernumber: 19 + cardnumber: 23529000035676 + surname: Acevedo + firstname: Henry + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 4345 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1958-05-30" + branchcode: MPL + categorycode: S + dateenrolled: "1990-09-23" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000035676 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.36460167669188 + sort2: 0.33887459834933 + + - borrowernumber: 20 + cardnumber: 23529000033739 + surname: Frazier + firstname: Sonia + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 8165 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1945-09-16" + branchcode: MPL + categorycode: PT + dateenrolled: "1984-06-21" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000033739 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.60056799240463 + sort2: 0.98621619770882 + + - borrowernumber: 21 + cardnumber: 23529000139858 + surname: Ballard + firstname: Ronnie + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 5730 Library Rd. + address2: ~ + city: Centerville, CA + zipcode: 44262 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1956-02-23" + branchcode: MPL + categorycode: T + dateenrolled: "1989-06-01" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000139858 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.12937704206386 + sort2: 0.68823664792649 + + - borrowernumber: 22 + cardnumber: 23529000224510 + surname: Gaines + firstname: Joyce + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 6012 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1957-08-01" + branchcode: SPL + categorycode: YA + dateenrolled: "1992-09-16" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000224510 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.053052144174513 + sort2: 0.20055080782673 + + - borrowernumber: 23 + cardnumber: 23529000120056 + surname: Bryan + firstname: Johnny + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 8180 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1961-10-24" + branchcode: MPL + categorycode: PT + dateenrolled: "1990-08-22" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000120056 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.84359763734378 + sort2: 0.61633579397233 + + - borrowernumber: 24 + cardnumber: 23529000218553 + surname: Duffy + firstname: Joann + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 1555 Library Rd. + address2: ~ + city: Portland, OR + zipcode: 44240 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1942-02-17" + branchcode: MPL + categorycode: ST + dateenrolled: "1984-08-02" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000218553 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.55088608856395 + sort2: 0.90542309163643 + + - borrowernumber: 25 + cardnumber: 23529000662701 + surname: Mejia + firstname: Armando + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 8209 Library Rd. + address2: ~ + city: Portland, OR + zipcode: 44240 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1939-07-22" + branchcode: SPL + categorycode: PT + dateenrolled: "1990-09-26" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000662701 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.87445722322395 + sort2: 0.65601687194409 + + - borrowernumber: 26 + cardnumber: 23529000092040 + surname: Hendrix + firstname: Keith + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 6546 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1944-04-05" + branchcode: SPL + categorycode: PT + dateenrolled: "1987-12-12" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000092040 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.65671272078223 + sort2: 0.31551301881253 + + - borrowernumber: 27 + cardnumber: 23529000058017 + surname: Turner + firstname: Sherri + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 1731 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1964-11-21" + branchcode: FRL + categorycode: PT + dateenrolled: "1987-09-14" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000058017 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.60742696244961 + sort2: 0.090595786544118 + + - borrowernumber: 28 + cardnumber: 23529000299603 + surname: Cherry + firstname: Lillie + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 263 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1931-01-19" + branchcode: MPL + categorycode: PT + dateenrolled: "1993-03-19" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000299603 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.6306980761054 + sort2: 0.88170305162827 + + - borrowernumber: 29 + cardnumber: 23529000121682 + surname: Schneider + firstname: Nicole + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 1008 Library Rd. + address2: ~ + city: Centerville, CA + zipcode: 44306 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1954-01-12" + branchcode: FRL + categorycode: ST + dateenrolled: "1985-09-09" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000121682 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.5164210605588 + sort2: 0.93699617864284 + + - borrowernumber: 30 + cardnumber: 23529000240482 + surname: White + firstname: Jamie + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 937 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1950-04-22" + branchcode: FRL + categorycode: T + dateenrolled: "1990-02-03" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000240482 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.13571774227146 + sort2: 0.86760020616241 + + - borrowernumber: 31 + cardnumber: 23529000714163 + surname: Burgess + firstname: Dawn + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 7907 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: ~ + branchcode: MPL + categorycode: PT + dateenrolled: "1985-05-23" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000714163 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.93084783473131 + sort2: 0.051438585902973 + + - borrowernumber: 32 + cardnumber: 23529000318858 + surname: Bennett + firstname: Pamela + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 9898 Library Rd. + address2: ~ + city: Centerville, CA + zipcode: 44310 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1946-09-16" + branchcode: MPL + categorycode: ST + dateenrolled: "1984-05-08" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000318858 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.46464945605458 + sort2: 0.16893155329761 + + - borrowernumber: 33 + cardnumber: 23529000526047 + surname: Hatfield + firstname: Lester + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 393 Library Rd. + address2: ~ + city: Centerville, CA + zipcode: 44262 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1983-01-22" + branchcode: SPL + categorycode: ST + dateenrolled: "1988-07-30" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000526047 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.45070942905798 + sort2: 0.74675251613069 + + - borrowernumber: 34 + cardnumber: 23529000686353 + surname: Harper + firstname: Ruben + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 6963 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1917-09-24" + branchcode: SPL + categorycode: S + dateenrolled: "1991-02-19" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000686353 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.38163432421315 + sort2: 0.66791410340733 + + - borrowernumber: 35 + cardnumber: 23529000719519 + surname: Kinney + firstname: Mae + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 2114 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: ~ + branchcode: SPL + categorycode: J + dateenrolled: "1991-12-29" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000719519 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.19466757513086 + sort2: 0.96959559616595 + + - borrowernumber: 36 + cardnumber: 23529000179433 + surname: Williamson + firstname: Catherine + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 5879 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1930-12-18" + branchcode: FRL + categorycode: K + dateenrolled: "1985-01-23" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000179433 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.26397528617082 + sort2: 0.41108967308988 + + - borrowernumber: 37 + cardnumber: 23529000197047 + surname: Charles + firstname: Lisa + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 6813 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1982-10-14" + branchcode: MPL + categorycode: K + dateenrolled: "1988-11-14" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000197047 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.26352253767058 + sort2: 0.084343699816934 + + - borrowernumber: 38 + cardnumber: 23529000695412 + surname: Singleton + firstname: Bob + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 4554 Library Rd. + address2: ~ + city: Centerville, CA + zipcode: 44262 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1983-04-15" + branchcode: FRL + categorycode: PT + dateenrolled: "1991-07-01" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000695412 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.63115091680656 + sort2: 0.90272351531566 + + - borrowernumber: 39 + cardnumber: 23529000603242 + surname: Mcconnell + firstname: Terrence + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 7200 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1949-06-10" + branchcode: SPL + categorycode: PT + dateenrolled: "1984-05-31" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000603242 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.62016485689223 + sort2: 0.39265376924784 + + - borrowernumber: 40 + cardnumber: 23529000589458 + surname: Knight + firstname: Mabel + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 8997 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1952-12-22" + branchcode: SPL + categorycode: T + dateenrolled: "1985-04-17" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000589458 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.10277430629616 + sort2: 0.33591025447092 + + - borrowernumber: 41 + cardnumber: 23529000054503 + surname: Odom + firstname: Gloria + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 9156 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1952-04-05" + branchcode: SPL + categorycode: S + dateenrolled: "1992-07-21" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000054503 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.37122838419976 + sort2: 0.84841118831971 + + - borrowernumber: 42 + cardnumber: 23529000126806 + surname: Hopkins + firstname: Brent + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 6692 Library Rd. + address2: ~ + city: Santa Cruz, CA + zipcode: 21234 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1977-11-13" + branchcode: SPL + categorycode: T + dateenrolled: "1984-06-28" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000126806 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.12837081973289 + sort2: 0.096620564438981 + + - borrowernumber: 43 + cardnumber: 23529000104159 + surname: Benson + firstname: Clinton + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 4695 Library Rd. + address2: ~ + city: Atwater, OH + zipcode: 21234 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: ~ + branchcode: MPL + categorycode: YA + dateenrolled: "1985-10-28" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000104159 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.097990393729872 + sort2: 0.20009030606606 + + - borrowernumber: 44 + cardnumber: 23529000395609 + surname: Stuart + firstname: Shannon + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 5011 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1951-02-13" + branchcode: FRL + categorycode: PT + dateenrolled: "1986-01-16" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000395609 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.70648037987433 + sort2: 0.93213101190713 + + - borrowernumber: 45 + cardnumber: 23529000050113 + surname: Alford + firstname: Jordan + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 5129 Library Rd. + address2: ~ + city: Centerville, CA + zipcode: 44262 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1952-05-27" + branchcode: MPL + categorycode: ST + dateenrolled: "1985-09-09" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000050113 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.54121395064631 + sort2: 0.90967674824379 + + - borrowernumber: 46 + cardnumber: 23529000053836 + surname: Mcfarland + firstname: Marilyn + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 4600 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: ~ + branchcode: SPL + categorycode: PT + dateenrolled: "1984-05-09" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000053836 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.92474192001367 + sort2: 0.89467938607063 + + - borrowernumber: 47 + cardnumber: 23529000774373 + surname: Morris + firstname: Lauren + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 5436 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: ~ + branchcode: SPL + categorycode: PT + dateenrolled: "1986-03-20" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000774373 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.69917120104578 + sort2: 0.81181787775067 + + - borrowernumber: 48 + cardnumber: 23529000117565 + surname: Palmer + firstname: Bill + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 2761 Library Rd. + address2: ~ + city: Springfield, MA + zipcode: 44224 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1984-01-10" + branchcode: SPL + categorycode: PT + dateenrolled: "1991-10-07" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: M + userid: 23529000117565 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.96157581634966 + sort2: 0.37242547922994 + + - borrowernumber: 49 + cardnumber: 23529000651225 + surname: Burton + firstname: Mary + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 8131 Library Rd. + address2: ~ + city: Santa Cruz, CA + zipcode: 21234 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1977-12-25" + branchcode: MPL + categorycode: PT + dateenrolled: "1985-05-30" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529000651225 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.97739997783434 + sort2: 0.76972348221552 + + - borrowernumber: 50 + cardnumber: 23529001223636 + surname: Peters + firstname: Tommy + title: ~ + othernames: ~ + initials: "" + streetnumber: ~ + streettype: ~ + address: 5171 Library Rd. + address2: ~ + city: Portland, ME + zipcode: 44236 + email: ~ + phone: (212) 555-1212 + mobile: ~ + fax: ~ + emailpro: ~ + phonepro: ~ + B_streetnumber: ~ + B_streettype: ~ + B_address: ~ + B_city: ~ + B_zipcode: ~ + B_email: ~ + B_phone: ~ + dateofbirth: "1951-06-14" + branchcode: SPL + categorycode: PT + dateenrolled: "1984-05-09" + dateexpiry: "2020-12-31" + gonenoaddress: ~ + lost: ~ + debarred: ~ + contactname: "" + contactfirstname: ~ + contacttitle: ~ + borrowernotes: ~ + relationship: ~ + sex: F + userid: 23529001223636 + opacnote: ~ + contactnote: ~ + password: 42b29d0771f3b7ef + flags: ~ + sort1: 0.91641750830823 + sort2: 0.27291712562825 -- 2.20.1