Mari kita buat dulu database di mysql dulu sebagai contoh.
Misal dengan nama eventdriven, kemudian create table customer, dengan syntax sebagai berikut:
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
`customer_id` int(11) NOT NULL default '0',
`lname` varchar(30) NOT NULL default '',
`fname` varchar(30) NOT NULL default '',
`address1` varchar(30) default NULL,
`address2` varchar(30) default NULL,
`address3` varchar(30) default NULL,
`address4` varchar(30) default NULL,
`city` varchar(30) default NULL,
`state_province` varchar(30) default NULL,
`postal_code` varchar(30) NOT NULL default '',
`country` varchar(30) NOT NULL default '',
`birthdate` date NOT NULL default '0000-00-00',
`date_accnt_opened` date NOT NULL default '0000-00-00',
UNIQUE KEY `i_customer_id` (`customer_id`),
KEY `i_customer_fname` (`fname`),
KEY `i_customer_lname` (`lname`),
KEY `i_cust_postal_code` (`postal_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Kemudian isi tabel dengan data sebagai berikut:
INSERT INTO `customer` VALUES (31,'Nickell','Paula','2144 San Rafael',NULL,NULL,NULL,'Concord','CA','63996','USA','1978-07-02','1991-02-06'),(43,'Sharp','Juanita','9833 Mt. Dias Blv.',NULL,NULL,NULL,'Burbank','CA','48042','USA','1977-05-16','1993-07-19'),(90,'Kouba','Geneva','7554 Lakeview Pl.',NULL,NULL,NULL,'Sooke','BC','78839','Canada','1976-10-05','1993-07-19'),(115,'Saxton','Gina','620 Woodside Ct.',NULL,NULL,NULL,'Altadena','CA','38565','USA','1977-06-09','1994-09-12'),(175,'Thumann','Meredith','2812 East Lake Court',NULL,NULL,NULL,'Metchosin','BC','99312','Canada','1976-03-14','1991-09-05'),(192,'Malik','Brittany','2598 La Vista Circle',NULL,NULL,NULL,'Spokane','WA','15462','USA','1977-06-24','1990-07-00'),(200,'Yates','Pamela','1397 Paraiso Ct.',NULL,NULL,NULL,'Los Angeles','CA','97953','USA','1977-06-13','1992-07-08'),(201,'Turner','Iwona','2893 Vera',NULL,NULL,NULL,'Santa Fe','DF','23798','Mexico','1976-07-11','1994-05-09'),(219,'Zeller','Sam','4912 La Vuelta',NULL,NULL,NULL,'Bellflower','CA','86331','USA','1977-09-10','1992-12-10'),(239,'Watkins','Lisa','3665 Oak Creek Ct.',NULL,NULL,NULL,'Concord','CA','92694','USA','1976-07-08','1992-07-06'),(259,'Jimenez','Sarah','6482 Colt Ct.',NULL,NULL,NULL,'Cliffside','BC','11498','Canada','1977-11-02','1993-07-18'),(265,'Bernal','Ruth','7647 Valencia Place',NULL,NULL,NULL,'Lake Oswego','OR','4753','USA','1976-11-05','1993-07-17'),(288,'Sincich','Joy','7861 Yosemite Dr.',NULL,NULL,NULL,'Downey','CA','79952','USA','1976-12-21','1993-07-24'),(301,'Vicknair','Caroline','1736 Windsor Drive',NULL,NULL,NULL,'Coronado','CA','83880','USA','1978-01-03','1990-07-00'),(312,'Mcdonald','Christinia','4259 Fenway',NULL,NULL,NULL,'Downey','CA','43282','USA','1976-05-04','1992-04-01'),(366,'Betsekas','Steven','1867 Seville',NULL,NULL,NULL,'National City','CA','80012','USA','1976-07-15','1992-07-22'),(370,'Brunner','June','1267 Scenic Drive',NULL,NULL,NULL,'Santa Monica','CA','54634','USA','1977-09-27','1992-01-02'),(414,'Tullao','Mary','3713 Rollingwood Dr.',NULL,NULL,NULL,'Vancouver','BC','69633','Canada','1977-08-18','1991-05-25'),(416,'Wilkie','Jay Saxema','8158 Ahwanee Lane',NULL,NULL,NULL,'Langford','BC','28112','Canada','1977-11-06','1992-03-02'),(418,'Fulton','Paul','3112 Gilardy Dr.',NULL,NULL,NULL,'Tlaxiaco','Oaxaca','80584','Mexico','1978-11-03','1992-10-06'),(430,'Dennis','Helen','3967 High Street',NULL,NULL,NULL,'Spokane','WA','55707','USA','1976-11-09','1993-07-17'),(447,'Contreras','Dorothy','3036 W. Cypress Road',NULL,NULL,NULL,'Altadena','CA','43124','USA','1976-11-23','1991-02-18'),(491,'Becker','Benjamin','9825 Mt. Dell Drive',NULL,NULL,NULL,'Acapulco','Guerrero','90392','Mexico','1976-05-22','1993-07-04'),(531,'Maes','Walter','4051 Athene Drive',NULL,NULL,NULL,'Tixapan','DF','31465','Mexico','1977-06-15','1991-05-15'),(534,'Strange','Charles','5373 Summerfield Dr',NULL,NULL,NULL,'Orizaba','Veracruz','88567','Mexico','1976-03-04','1992-06-15'),(599,'Ayers','Stephen','7468 Franklin Canyon Road',NULL,NULL,NULL,'Sedro Woolley','WA','88132','USA','1978-07-24','1992-10-28'),(638,'Bruner','Shirley','6111 Guadalajara',NULL,NULL,NULL,'Oregon City','OR','27206','USA','1976-05-11','1993-07-10'),(640,'Sandidge','Mary','557 Diver Way',NULL,NULL,NULL,'Royal Oak','BC','23869','Canada','1976-08-27','1991-11-24'),(642,'Beck','Christopher','8166 Starflower Dr',NULL,NULL,NULL,'Spring Valley','CA','76341','USA','1977-08-24','1994-07-01'),(667,'Glenn','Jeanie','1625 Buckingham Dr.',NULL,NULL,NULL,'San Jose','CA','73001','USA','1978-08-06','1994-12-13'),(681,'Whitney','Todd','8540 Donegal Road',NULL,NULL,NULL,'Chula Vista','CA','70360','USA','1976-11-20','1992-10-14'),(689,'Sotelo','William','6323 Benedict Court',NULL,NULL,NULL,'Lincoln Acres','CA','82248','USA','1976-12-03','1991-06-12'),(699,'Bates','Karel','3217 Elm St',NULL,NULL,NULL,'National City','CA','11866','USA','1976-03-19','1994-10-16'),(712,'Hurkett','Lawrence','4111 Vista Diablo',NULL,NULL,NULL,'San Gabriel','CA','19899','USA','1978-08-04','1993-07-13'),(713,'Pettengill','Sara','5607 Willow Creek Ct.',NULL,NULL,NULL,'Berkeley','CA','33902','USA','1978-09-02','1991-03-15'),(746,'Breer','Sara','5508 Trembath Court',NULL,NULL,NULL,'West Covina','CA','58231','USA','1976-11-14','1993-07-23'),(766,'Estes','Julie','1720 Medburn St',NULL,NULL,NULL,'Burien','WA','81017','USA','1978-01-17','1991-01-25'),(768,'Steele','Joan','6165 Silverwood Drive',NULL,NULL,NULL,'Kirkland','WA','31667','USA','1978-04-06','1992-10-02'),(774,'Browning','Dave','3175 Olivera Rd.',NULL,NULL,NULL,'Redmond','WA','30259','USA','1977-06-10','1990-07-00'),(783,'Brooks','Willie','9543 West I St.',NULL,NULL,NULL,'Beaverton','OR','49447','USA','1976-07-08','1992-08-13'),(797,'Krupka','Margaret','294 La Vuelta',NULL,NULL,NULL,'Arcadia','CA','97410','USA','1977-12-09','1992-05-22'),(812,'Faubert','Cheryl','5888 Salem St.',NULL,NULL,NULL,'Concord','CA','42074','USA','1978-11-05','1990-07-00'),(813,'Bonilla','Margurite','548 Stony Hill Circle',NULL,NULL,NULL,'Lake Oswego','OR','61108','USA','1976-04-21','1992-12-28'),(845,'Abo','Parker','893 Thornwood Drive',NULL,NULL,NULL,'Long Beach','CA','26971','USA','1978-01-02','1991-09-11'),(864,'Theriault','Karen','2215 La Corte Bonita',NULL,NULL,NULL,'Chula Vista','CA','14782','USA','1978-09-03','1992-05-25'),(878,'Potter','Margaret','4581 Coggins Drive',NULL,NULL,NULL,'Port Orchard','WA','99162','USA','1977-09-05','1994-02-08'),(882,'Witte','Leda','3981 Augustine Drive',NULL,NULL,NULL,'National City','CA','83536','USA','1978-12-18','1990-07-00'),(909,'Cappa','M.','9713 Amhurst Way',NULL,NULL,NULL,'Glendale','CA','80508','USA','1977-03-11','1993-07-21'),(940,'Wilson','John','5399 Red Maple Ct.',NULL,NULL,NULL,'Arcadia','CA','73046','USA','1977-06-08','1991-03-18'),(985,'Morrow','Mildred','8487 Amador',NULL,NULL,NULL,'El Cajon','CA','97753','USA','1978-09-07','1993-07-08'),(1040,'Usnick','Jason','3586 Everett Court',NULL,NULL,NULL,'Redwood City','CA','48149','USA','1976-04-26','1994-03-26'),(1041,'Brown','Mike','6790 Loma Linda',NULL,NULL,NULL,'Oregon City','OR','47748','USA','1977-12-12','1993-07-04'),(1076,'Chenault','Glenn','561 Park Glenn',NULL,NULL,NULL,'Sedro Woolley','WA','41568','USA','1978-02-11','1993-07-02'),(1081,'Putinas','Merced','5935 Isabel',NULL,NULL,NULL,'Berkeley','CA','83465','USA','1978-11-19','1991-05-12'),(1086,'Brandberry','Jade','2650 Hamlet',NULL,NULL,NULL,'Portland','OR','22922','USA','1978-06-20','1992-09-17'),(1099,'Grayson','Darlyn','3799 Hilton Way',NULL,NULL,NULL,'Lynnwood','WA','51026','USA','1977-09-25','1990-07-00'),(1105,'McNight','Clara','7644 Corte Segunda',NULL,NULL,NULL,'Langford','BC','46796','Canada','1978-04-02','1992-10-08'),(1137,'Geiermann','Heather','6742 Cleaveland Road',NULL,NULL,NULL,'West Covina','CA','83626','USA','1976-02-26','1993-07-22'),(1143,'Quick','Ana','3752 Hamilton Ct',NULL,NULL,NULL,'Burnaby','BC','11720','Canada','1978-05-09','1992-07-27'),(1150,'Detwiler','Foster','2257 Gibrix Drive',NULL,NULL,NULL,'Downey','CA','18740','USA','1976-08-17','1994-02-13'),(1169,'Lippman','Raymond','1153 Loma Linda',NULL,NULL,NULL,'Mexico City','Mexico','97518','Mexico','1976-06-27','1993-07-19'),(1187,'Surniak','Susan','4951 Coralie Drive',NULL,NULL,NULL,'Albany','OR','16014','USA','1977-04-05','1991-02-02'),(1304,'Pavicich','Scott','4619 Ricardo Drive','#233',NULL,NULL,'Salem','OR','56643','USA','1978-03-26','1993-07-18'),(1348,'Stilfield','Naida','1408 Bonifacio St.',NULL,NULL,NULL,'Guadalajara','Jalisco','60336','Mexico','1976-03-04','1990-07-00'),(1372,'Truitt','James','692 Nahua',NULL,NULL,NULL,'Tlaxiaco','Oaxaca','61925','Mexico','1978-03-26','1992-04-17'),(1387,'Wilson','Betty','2868 Fitzuren',NULL,NULL,NULL,'Beaverton','OR','67278','USA','1977-11-22','1991-06-25'),(1396,'Harrison','Kim','2007 Shannon Ln.',NULL,NULL,NULL,'La Cruz','Sinaloa','13579','Mexico','1976-04-19','1991-03-13'),(1402,'Nicholas','Betty','9270 Via Pablo Neruda',NULL,NULL,NULL,'Orizaba','Veracruz','68344','Mexico','1976-11-22','1990-07-00'),(1409,'Etter','Clifford','5558 Kaitlin Pl.',NULL,NULL,NULL,'La Mesa','CA','29686','USA','1976-04-08','1992-03-02'),(1446,'Duran','Adrienne','2342 Peachwillow',NULL,NULL,NULL,'National City','CA','99880','USA','1977-10-24','1992-02-19'),(1478,'Dale','Robert','9407 H Street',NULL,NULL,NULL,'Sooke','BC','87065','Canada','1976-02-15','1992-07-28'),(1506,'Dewitt','David','6959 Lakewood Court',NULL,NULL,NULL,'Daly City','CA','56920','USA','1978-05-20','1992-05-20'),(1519,'Pardee','John','1273 Silver Oak Pl.',NULL,NULL,NULL,'Richmond','BC','35855','Canada','1976-01-19','1993-07-14'),(1523,'Walsh','Wenona','7230 Shannon Ln.',NULL,NULL,NULL,'Acapulco','Guerrero','10477','Mexico','1977-05-08','1990-07-00'),(1558,'Clark','Julia','5203 Foothill Way',NULL,NULL,NULL,'Santa Cruz','CA','26459','USA','1976-06-03','1993-07-23'),(1613,'Underwood','Zennen','2598 Breck Court',NULL,NULL,NULL,'Downey','CA','64723','USA','1978-01-08','1992-10-16'),(1629,'Brumfield','Richard','2852 Magda Way',NULL,NULL,NULL,'Oak Bay','BC','34301','Canada','1977-05-02','1993-07-21'),(1676,'Neri','Michelle','4657 Roundhouse Place',NULL,NULL,NULL,'Bremerton','WA','45850','USA','1977-05-04','1992-02-21'),(1689,'Melomed','Edward','3127 Terrace',NULL,NULL,NULL,'Redmond','WA','71728','USA','1977-06-02','1992-03-06'),(1719,'Holland','Janet','7779 Marfargoa Drive',NULL,NULL,NULL,'Richmond','BC','38055','Canada','1976-01-22','1991-03-08'),(1748,'Tabor','Florence','1884 Scottsdale Road',NULL,NULL,NULL,'Lakewood','CA','38929','USA','1976-09-21','1992-06-10'),(1812,'Kinney','Monica','4147 Alamo Court',NULL,NULL,NULL,'Camacho','Zacatecas','87331','Mexico','1977-09-20','1992-10-04'),(1832,'Calleja','Susan','2899 Cimarron Drive',NULL,NULL,NULL,'Yakima','WA','16438','USA','1978-03-12','1992-02-15'),(1883,'Stohson','David','1887 Mt. Diablo St',NULL,NULL,NULL,'Seattle','WA','82038','USA','1976-01-11','1991-12-02'),(1914,'Acevedo','Stephen','6510 Hacienda Drive',NULL,NULL,NULL,'Imperial Beach','CA','17174','USA','1976-01-23','1993-07-07'),(1920,'Ashton','William','6937 E. 42nd Street',NULL,NULL,NULL,'Downey','CA','15460','USA','1976-12-11','1991-09-07'),(1929,'Novas','Ana','1597 Vista Del Sol',NULL,NULL,NULL,'Newton','BC','15561','Canada','1978-11-10','1993-07-02'),(1944,'Wintermute','Tiffany','8370 Birchwood Dr',NULL,NULL,NULL,'Imperial Beach','CA','42016','USA','1978-11-27','1991-02-23'),(1946,'Strongman','Joshua','3070 Sahara Drive',NULL,NULL,NULL,'Santa Anita','DF','29326','Mexico','1976-07-26','1991-12-21'),(1968,'Bellamy','Emily','310 Witherseed Lane',NULL,NULL,NULL,'San Jose','CA','49484','USA','1976-02-19','1990-07-00'),(1971,'Cabrera','Pamela','8467 Clifford Court',NULL,NULL,NULL,'Kirkland','WA','95386','USA','1977-07-18','1994-09-23'),(2012,'Carrillo','Tim','3197 Winterglenn Way',NULL,NULL,NULL,'Westminster','BC','26885','Canada','1977-11-27','1993-07-21'),(2022,'Childers','Maureen','598 Limeridge Drive',NULL,NULL,NULL,'Guadalajara','Jalisco','82382','Mexico','1978-11-25','1992-09-18'),(2045,'Duran','Ann','304 Diver Way',NULL,NULL,NULL,'Mill Valley','CA','90542','USA','1978-08-20','1994-10-19'),(2075,'Corsi','Danny','5972 Donegal Court',NULL,NULL,NULL,'Woodburn','OR','87380','USA','1978-10-25','1994-09-12'),(2078,'Silva','Anne','8979 Adams Dr.',NULL,NULL,NULL,'Grossmont','CA','28564','USA','1976-04-03','1992-09-08'),(2089,'Suleiman','Nicolas','5175 Reisling Court',NULL,NULL,NULL,'Novato','CA','77194','USA','1977-09-13','1992-08-12'),(2106,'Espinoza','Jeanni','4499 Valley Crest',NULL,NULL,NULL,'Bellflower','CA','96838','USA','1978-10-11','1994-04-23'),(2169,'Douglas','Bernice','1431 Rancho View Drive','#14',NULL,NULL,'Cliffside','BC','72111','Canada','1978-03-16','1992-03-11'),(2174,'Bressler','Andrea','5489 Patterson Blvd.',NULL,NULL,NULL,'Lynnwood','WA','65766','USA','1977-09-17','1990-07-00'),(2192,'Lopez','Marina','5870 Matheson Road',NULL,NULL,NULL,'Oakland','CA','35842','USA','1976-07-28','1991-04-02'),(2248,'Benton','Kathryn','350 Paso Nogal','#310',NULL,NULL,'Downey','CA','55753','USA','1976-04-27','1993-07-16'),(2269,'Vigil','Rita','5863 Sierra',NULL,NULL,NULL,'Portland','OR','19384','USA','1977-11-25','1992-05-07'),(2277,'West','Sophia','8564 Hickory Drive','#425',NULL,NULL,'Long Beach','CA','67626','USA','1978-02-18','1993-07-13'),(2283,'Rodriguez','Christine','9246 Westminster Pl',NULL,NULL,NULL,'Palo Alto','CA','30458','USA','1978-11-13','1991-07-24'),(2301,'Weaver','Joan','274 Diane Ct',NULL,NULL,NULL,'San Diego','CA','31536','USA','1976-05-19','1992-06-21'),(2333,'Arnold','Susan','7963 Elk Dr','#4',NULL,NULL,'Tlaxiaco','Oaxaca','96398','Mexico','1976-08-19','1993-07-02'),(2353,'Varney','Mark','6600 Chestnut Ave',NULL,NULL,NULL,'Richmond','BC','42443','Canada','1976-05-02','1991-10-22'),(2364,'Moore','Margaret','8267 Lavene Way',NULL,NULL,NULL,'Shawnee','BC','95184','Canada','1978-05-15','1991-08-18'),(2367,'Wan','Sandra','9589 Eastgate Avenue',NULL,NULL,NULL,'Palo Alto','CA','98377','USA','1977-02-04','1992-11-16'),(2372,'Hart','John','3395 Farm Bureau Rd',NULL,NULL,NULL,'Issaquah','WA','26871','USA','1977-11-22','1992-06-15'),(2450,'Wolfe','Paul','658 Contra Costa Blvd',NULL,NULL,NULL,'Mexico City','Mexico','54125','Mexico','1978-03-14','1993-07-14'),(2453,'Smith','Janet','4890 Heron Ct',NULL,NULL,NULL,'National City','CA','77388','USA','1976-04-15','1994-03-23'),(2454,'Branston','Sadie','9549 Roxbury Drive',NULL,NULL,NULL,'Imperial Beach','CA','96422','USA','1977-06-15','1992-07-05'),(2469,'Bade','Maria','5144 Via Bonita',NULL,NULL,NULL,'Ballard','WA','99550','USA','1978-07-20','1992-08-07'),(2482,'Sanok','Stephanie','8510 G St.',NULL,NULL,NULL,'Salem','OR','39405','USA','1977-06-05','1993-07-17'),(2501,'Archilla','Vivian','4243 Willow Creek Ct',NULL,NULL,NULL,'Guadalajara','Jalisco','12124','Mexico','1978-11-20','1991-05-23'),(2540,'Gertz','Carmen','2100 Linton Terr',NULL,NULL,NULL,'Langley','BC','79564','Canada','1978-11-05','1990-07-00'),(2553,'Kountz','Maria','9322 Sinaloa',NULL,NULL,NULL,'Spokane','WA','99273','USA','1977-06-12','1994-03-06'),(2555,'Walker','Casilda','4277 Benet Court',NULL,NULL,NULL,'Burien','WA','52746','USA','1976-12-28','1992-11-10'),(2575,'Pfotenhauer','Tara','7832 Landana Dr',NULL,NULL,NULL,'Langley','BC','49239','Canada','1978-03-07','1993-07-20'),(2630,'Williams','Darren','4510 Terry Lynn Lane',NULL,NULL,NULL,'Sedro Woolley','WA','80927','USA','1978-03-08','1991-03-12'),(2643,'Williams','Steve','5266 Tanager Cir',NULL,NULL,NULL,'Ladner','BC','74583','Canada','1977-07-08','1991-08-16'),(2669,'Aspinwall','Russ','5093 Greer Ave',NULL,NULL,NULL,'Concord','CA','97320','USA','1978-08-18','1994-07-12'),(2699,'Anderson','Rosalie','4041 Jennifer Way',NULL,NULL,NULL,'Lincoln Acres','CA','51971','USA','1976-07-12','1992-02-21'),(2705,'Soto','Eric','9919 MacArthur Avenue',NULL,NULL,NULL,'Coronado','CA','47741','USA','1978-03-16','1992-05-09'),(2724,'Abahamdeh','Catherine','9532 Clayton Rd',NULL,NULL,NULL,'Lincoln Acres','CA','23373','USA','1976-12-04','1992-07-10'),(2754,'Konig','Graciela','8734 Oxford Place',NULL,NULL,NULL,'Vancouver','BC','67861','Canada','1978-09-17','1992-10-14'),(2773,'Cobb','Frank','6500 Soto Street',NULL,NULL,NULL,'Milwaukie','OR','8119','USA','1976-07-26','1992-09-15'),(2813,'Zagar','Brenda','5021 Rio Grande Drive',NULL,NULL,NULL,'Kirkland','WA','41641','USA','1976-10-21','1991-08-05'),(2845,'Ard','Lela','1301 Northstar Drive',NULL,NULL,NULL,'Oak Bay','BC','61577','Canada','1976-03-21','1992-12-11'),(2849,'Herrera','Linda','7028 Stonedale',NULL,NULL,NULL,'San Andres','DF','91060','Mexico','1978-08-25','1993-07-25'),(2873,'Rowlez','Kathryn','4672 Euclid Ave',NULL,NULL,NULL,'Kirkland','WA','62175','USA','1978-11-09','1992-08-26'),(2884,'Thompson','Eric','5486 Maria Vega Court',NULL,NULL,NULL,'San Jose','CA','34655','USA','1977-05-24','1992-05-13'),(2940,'Carrillo','Mary','9965 Via Doble',NULL,NULL,NULL,'Langford','BC','82888','Canada','1978-08-26','1990-07-00'),(2958,'Cunningham','Nancy','1248 Tanager Cir',NULL,NULL,NULL,'El Cajon','CA','71576','USA','1978-03-25','1993-07-04'),(2966,'Jenning','Christine','277 South Royal Links',NULL,NULL,NULL,'Tacoma','WA','91426','USA','1976-07-02','1991-07-19'),(2975,'Owen','Peter','8354 Tice Valley Blv.',NULL,NULL,NULL,'National City','CA','28176','USA','1976-03-13','1990-07-00'),(2993,'Szynskie','Bonnie','9105 Jacobsen Street',NULL,NULL,NULL,'Imperial Beach','CA','39316','USA','1977-06-22','1994-10-21'),(3014,'Little','Marie','9746 Hillsborough Ct',NULL,NULL,NULL,'Tixapan','DF','35383','Mexico','1978-04-24','1992-01-20'),(3055,'Thornton','Mary','6759 Greenbrier Street',NULL,NULL,NULL,'Oak Bay','BC','66569','Canada','1977-04-28','1994-09-20'),(3059,'Sullivan','Gail','8815 Wildberry Court',NULL,NULL,NULL,'Oakland','CA','41190','USA','1978-08-17','1994-04-10'),(3091,'Babbitt','Dolores','570 Highridge Court',NULL,NULL,NULL,'Royal Oak','BC','28376','Canada','1978-09-04','1990-07-00'),(3131,'Williams','Christina','2370 Mac Court',NULL,NULL,NULL,'Seattle','WA','14158','USA','1976-06-03','1992-07-14'),(3166,'Mills','Alexis','6671 Santa Barbara',NULL,NULL,NULL,'Lemon Grove','CA','17884','USA','1977-02-16','1991-11-08'),(3176,'Vigil','Charles','5990 Curletto Drive',NULL,NULL,NULL,'Redwood City','CA','58467','USA','1977-05-13','1990-07-00'),(3204,'Yengich','Robert','7836 Roux Court',NULL,NULL,NULL,'El Cajon','CA','90967','USA','1978-10-12','1990-07-00'),(3256,'Butler','John','1000 Bidweld Street',NULL,NULL,NULL,'Haney','BC','55704','Canada','1977-10-28','1991-07-21'),(3270,'Chuakay','Linda','9717 Hiliday Hills Drive',NULL,NULL,NULL,'Santa Monica','CA','22879','USA','1976-12-23','1990-07-00'),(3295,'Carlson','Marie','1951 Detroit Avenue',NULL,NULL,NULL,'Tixapan','DF','75089','Mexico','1978-01-15','1993-07-12'),(3298,'Miller','Wendell','7892 Mitchelleanjen Ln.',NULL,NULL,NULL,'Downey','CA','83949','USA','1978-04-28','1992-09-03'),(3330,'Van Donkkenburg','Melissa','5581 Galveston Ct',NULL,NULL,NULL,'Santa Anita','DF','70844','Mexico','1976-04-20','1990-07-00'),(3366,'Gottier','Michelle','P .O. Box 2162',NULL,NULL,NULL,'Camacho','Zacatecas','32465','Mexico','1978-06-18','1994-05-17'),(3430,'Schubitzke','John','1769 Nicholas Drive',NULL,NULL,NULL,'Bellingham','WA','80867','USA','1978-10-12','1993-07-13'),(3441,'Lay','Dorothy','4292 Wellington Avenue',NULL,NULL,NULL,'Port Orchard','WA','22050','USA','1977-08-10','1992-11-26'),(3450,'Vallis','Surinder','4816 Condor Dr',NULL,NULL,NULL,'Royal Oak','BC','66450','Canada','1976-06-06','1992-09-26'),(3454,'Turnpaugh','Virginia','3708 Lenox Ct','Unit D-2',NULL,NULL,'Metchosin','BC','9749','Canada','1978-06-28','1993-07-17'),(3457,'Abramson','Cynthia','1104 O St.',NULL,NULL,NULL,'Coronado','CA','64335','USA','1976-09-19','1992-02-02'),(3480,'Shaw','Barbara','6559 Via Rerrari',NULL,NULL,NULL,'Woodland Hills','CA','66034','USA','1976-06-19','1993-07-04'),(3500,'Phillips','Robyn','9377 Lightwood Drive',NULL,NULL,NULL,'Burien','WA','41556','USA','1977-10-14','1992-11-04'),(3512,'Smith','Lee','3743 Grenadine Way',NULL,NULL,NULL,'La Jolla','CA','58064','USA','1978-04-01','1993-07-18'),(3514,'Pegg','David','8442 Euclid Avenue',NULL,NULL,NULL,'Port Hammond','BC','45375','Canada','1976-10-27','1990-07-00'),(3524,'Caldwell','Rick','1434 Boxwood Drive','#208',NULL,NULL,'Albany','OR','49604','USA','1976-01-15','1990-07-00'),(3542,'OGrady','Jennifer','3962 Clyde Street',NULL,NULL,NULL,'Santa Fe','DF','16970','Mexico','1978-11-14','1991-02-09'),(3589,'Topping','Belinda','9901 Sequoia Woods Pl',NULL,NULL,NULL,'Corvallis','OR','32250','USA','1977-06-02','1992-11-04'),(3603,'Stortstrom','Jessica','3284 Pheasant Court',NULL,NULL,NULL,'Lincoln Acres','CA','37155','USA','1976-07-13','1991-01-02'),(3631,'Brinton','Bonnie','2983 Yosemite Ct',NULL,NULL,NULL,'Spring Valley','CA','75721','USA','1976-03-10','1992-04-13'),(3638,'Bowling','Barbara','5160 Mt. Wilson Way',NULL,NULL,NULL,'Royal Oak','BC','27880','Canada','1976-02-17','1991-08-06'),(3653,'Shifflet','Linda','4657 Price Lane',NULL,NULL,NULL,'Acapulco','Guerrero','57300','Mexico','1977-01-20','1992-09-07'),(3658,'Williams','Joanne','5551 Orinda Court',NULL,NULL,NULL,'Redwood City','CA','19632','USA','1978-04-03','1993-07-05'),(3669,'Bonham','Beverly','4911 Peachwillow Lane',NULL,NULL,NULL,'Lincoln Acres','CA','20998','USA','1976-05-14','1992-06-27'),(3722,'Johnson','Jeanette','7814 Nephi Court',NULL,NULL,NULL,'Burlingame','CA','94326','USA','1978-08-24','1992-05-10'),(3728,'Smith','Nancy','8241 San Jose Drive',NULL,NULL,NULL,'Lebanon','OR','85118','USA','1978-06-09','1991-06-22'),(3759,'Puckett','Jane','6099 Esperanza Dr',NULL,NULL,NULL,'Lebanon','OR','50754','USA','1977-11-25','1991-02-10'),(3772,'Chatwin','Richard','9556 Nightingale Drive',NULL,NULL,NULL,'Ladner','BC','63843','Canada','1976-05-26','1994-08-22'),(3845,'Howard','Sumner','1905 Julpum Loop',NULL,NULL,NULL,'Lemon Grove','CA','56473','USA','1978-03-09','1991-07-23'),(3850,'Trueblood','Walter','5455 Grenola Dr',NULL,NULL,NULL,'Downey','CA','45097','USA','1978-06-20','1992-03-06'),(3919,'Ortega','Steve','806 San Jose Drive',NULL,NULL,NULL,'Santa Anita','DF','21171','Mexico','1976-04-26','1991-03-18'),(3920,'Rewinkel','Emily','9391 80th St',NULL,NULL,NULL,'Oakland','CA','42720','USA','1976-01-13','1993-07-27'),(4010,'Yeater','Ann','163 St. John Lane',NULL,NULL,NULL,'Lake Oswego','OR','11580','USA','1978-03-08','1992-11-14'),(4042,'Vance','Theodore','2035 Emmons Canyon Lane',NULL,NULL,NULL,'Arcadia','CA','98054','USA','1977-12-17','1993-07-17'),(4120,'Starr','Andrew','5786 St. George Drive',NULL,NULL,NULL,'Burien','WA','57631','USA','1977-01-24','1994-11-09'),(4140,'Schiel','Sheri','8603 Holiday Hill Dr',NULL,NULL,NULL,'Ballard','WA','26983','USA','1978-05-19','1991-04-13'),(4162,'Lamothe','Paul','24 San Vincente Drive',NULL,NULL,NULL,'Lakewood','CA','19699','USA','1978-05-15','1990-07-00'),(4198,'Marchman','Allan','5357 Willow Drive',NULL,NULL,NULL,'Orizaba','Veracruz','54026','Mexico','1976-04-28','1991-04-20'),(4215,'Enrico','Brian','6136 North 68th St',NULL,NULL,NULL,'Seattle','WA','67103','USA','1978-05-09','1993-07-06'),(4231,'Thomason','Katy','3571 N St.',NULL,NULL,NULL,'Puyallup','WA','62683','USA','1977-07-28','1991-05-04'),(4256,'Brett','Joan','6521 D Bel Air Dr',NULL,NULL,NULL,'Hidalgo','Zacatecas','74145','Mexico','1977-08-25','1991-05-26'),(4257,'Braunlich','Maryann','973 Broadway Street',NULL,NULL,NULL,'Port Orchard','WA','73744','USA','1976-02-26','1993-07-01'),(4296,'Rincon','Audie','1994 South Villa Way',NULL,NULL,NULL,'La Jolla','CA','96281','USA','1977-08-15','1992-11-06'),(4329,'Smock','Tuyet','5936 Second Ave',NULL,NULL,NULL,'Daly City','CA','20420','USA','1977-04-13','1992-02-10'),(4411,'Tieman','James','9341 Galloway Drive',NULL,NULL,NULL,'Bellingham','WA','12285','USA','1977-02-19','1991-04-21'),(4424,'Christensen','David','5109 C Northwood Dr',NULL,NULL,NULL,'San Jose','CA','45021','USA','1978-05-03','1992-08-05'),(4468,'Carzino','Valerie','1113 Ready Road',NULL,NULL,NULL,'Lake Oswego','OR','25777','USA','1978-11-26','1992-03-18'),(4496,'Meece','Mitch','6238 Monti Circle',NULL,NULL,NULL,'Woodland Hills','CA','58277','USA','1978-08-25','1992-04-15'),(4511,'Valdez','Margaret','7906 Star Tree Court',NULL,NULL,NULL,'Berkeley','CA','30983','USA','1976-02-02','1993-07-20'),(4514,'McGill','Maria','1192 Tosca Way',NULL,NULL,NULL,'Beaverton','OR','39843','USA','1976-05-15','1992-03-15'),(4522,'Kochis','Anita','2877 Bounty Way',NULL,NULL,NULL,'Tacoma','WA','51731','USA','1976-06-26','1991-10-05'),(4528,'Cook','Maryanne','3304 East Altarinda Drive','#103',NULL,NULL,'Redmond','WA','94527','USA','1976-03-10','1991-06-19'),(4531,'Sisk','Anatole','1463 Lincoln Dr',NULL,NULL,NULL,'Acapulco','Guerrero','47599','Mexico','1976-09-09','1994-04-06'),(4546,'Baker','Roger','8258 N. Broadway','#2015',NULL,NULL,'Edmonds','WA','77708','USA','1978-03-24','1993-07-04'),(4575,'Wilson','Sharlene','8877 Weatherly Drive',NULL,NULL,NULL,'Renton','WA','56323','USA','1976-06-23','1992-10-27'),(4578,'Jackson','Angela','8720 Orth Larwin Ave',NULL,NULL,NULL,'San Jose','CA','65183','USA','1976-09-09','1991-09-07'),(4602,'Bowers','Carmen','4101 Buckthorn Court',NULL,NULL,NULL,'Berkeley','CA','93064','USA','1976-04-22','1992-12-28'),(4609,'Robinson','Carl','2422 Brookview Drive',NULL,NULL,NULL,'Yakima','WA','89044','USA','1976-07-08','1992-04-16'),(4612,'Montes','Alex','1781 Camino Solano',NULL,NULL,NULL,'Mill Valley','CA','95389','USA','1976-06-11','1991-03-06'),(4631,'Lilley','Beatrice','9684 Rahn Court',NULL,NULL,NULL,'Newton','BC','13008','Canada','1977-03-12','1994-04-11'),(4635,'Broyles','Helen','2987 Wiget Lane',NULL,NULL,NULL,'La Jolla','CA','86628','USA','1978-05-25','1993-07-23'),(4638,'Lane','Mari','2092 Frayne Ct',NULL,NULL,NULL,'Pomona','CA','27812','USA','1977-11-02','1991-10-11'),(4652,'Gaines','Ann','1318 Pinehurst Court',NULL,NULL,NULL,'Richmond','BC','18816','Canada','1977-08-03','1992-05-19'),(4658,'Barrera','Edward','1237 Dubhe Court',NULL,NULL,NULL,'Olympia','WA','36748','USA','1976-08-06','1993-07-19'),(4693,'Tkachenko','Ronald','3159 Lime Ridge Drive',NULL,NULL,NULL,'Port Orchard','WA','71584','USA','1976-06-15','1993-07-05'),(4701,'Turrin','Jackie','4613 Pinon Drive',NULL,NULL,NULL,'Cliffside','BC','20827','Canada','1978-11-13','1993-07-16'),(4725,'Cabral','Doris','7568 W. Holly Drive',NULL,NULL,NULL,'Pomona','CA','85351','USA','1976-08-18','1994-05-13'),(4783,'Briar','Farrell','2151 Twincreek Ct',NULL,NULL,NULL,'Woodburn','OR','52690','USA','1976-12-26','1992-04-03'),(4796,'Chaney','Bo','1083 S. 48th Street',NULL,NULL,NULL,'Tixapan','DF','18040','Mexico','1976-06-27','1994-09-16'),(4810,'Tepper','Bruce','9407 Alvarado Ave',NULL,NULL,NULL,'Yakima','WA','88106','USA','1978-02-19','1990-07-00'),(4815,'Vaughn','Inge','1250 Sierra Ridge',NULL,NULL,NULL,'Marysville','WA','64843','USA','1977-03-17','1992-02-12'),(4816,'Davelis','Margaret','9834 Vista Del Rio','Unit A',NULL,NULL,'La Mesa','CA','86392','USA','1977-11-04','1991-09-04'),(4831,'Chace','Karen','1504 Conifer Court',NULL,NULL,NULL,'Haney','BC','86715','Canada','1976-06-08','1994-02-09'),(4858,'Wilcox','Bertha','4072 South Hampton Road',NULL,NULL,NULL,'Olympia','WA','72486','USA','1977-06-19','1994-07-16'),(4866,'Longstreet','Coletta','6543 Jacobsen Street',NULL,NULL,NULL,'Tlaxiaco','Oaxaca','82760','Mexico','1977-06-03','1993-07-22'),(4895,'Tellez','Lorraine','5013 Military E',NULL,NULL,NULL,'Westminster','BC','86052','Canada','1976-10-02','1991-08-04'),(4924,'Otto','Sandy','134 Peachwillow Street',NULL,NULL,NULL,'Port Hammond','BC','94722','Canada','1976-03-15','1992-06-13'),(4927,'Beasley','Dennis','1456 Lake Nadine Pl.',NULL,NULL,NULL,'Fremont','CA','23303','USA','1976-11-05','1992-05-12'),(4960,'Parr','Dianne','7107 Alhambra Valley Rd.',NULL,NULL,NULL,'Tixapan','DF','83297','Mexico','1976-09-28','1993-07-16'),(5005,'Thompson','Andre','5183 Hames Drive',NULL,NULL,NULL,'Palo Alto','CA','30009','USA','1978-08-07','1990-07-00'),(5017,'Schaeffer','Diane','3612 Vista Place',NULL,NULL,NULL,'Cliffside','BC','87611','Canada','1978-08-18','1991-06-25'),(5040,'Goudreau','James','8051 Roskelley Dr.',NULL,NULL,NULL,'Burien','WA','59706','USA','1977-10-27','1992-07-25'),(5043,'Bulman','Alfred','6209 Willow Drive',NULL,NULL,NULL,'Ballard','WA','31286','USA','1977-04-26','1994-03-02'),(5059,'Slankard','Elizabeth','9119 Nulty Drive',NULL,NULL,NULL,'Tlaxiaco','Oaxaca','29186','Mexico','1976-06-17','1990-07-00'),(5078,'Steen','Alice','1639 Wildcat Circle',NULL,NULL,NULL,'La Cruz','Sinaloa','47393','Mexico','1977-06-03','1993-07-11'),(5123,'Osborne','Chad','6968 Hobby Court',NULL,NULL,NULL,'Lake Oswego','OR','53201','USA','1976-11-11','1994-04-19'),(5151,'Terry','Ed','1979 Dianda Drive',NULL,NULL,NULL,'Vancouver','BC','65475','Canada','1977-04-10','1994-01-02'),(5167,'Adams','Deborah','8168 Lorie Lane',NULL,NULL,NULL,'Spring Valley','CA','14930','USA','1976-06-01','1991-02-26'),(5208,'Wolski','Richard (Chris)','8946 Tice',NULL,NULL,NULL,'Pomona','CA','60520','USA','1977-04-08','1990-07-00'),(5265,'Antonio','Sandra','9123 James Donlon Blvd','Unit C',NULL,NULL,'N. Vancouver','BC','96633','Canada','1978-10-26','1992-05-18'),(5280,'Barker','Siu Ping','9452 Mariposa Ct.',NULL,NULL,NULL,'Lakewood','CA','62057','USA','1976-02-07','1994-12-03'),(5303,'Vrins','Patricia','6478 Hastings Dr.',NULL,NULL,NULL,'Olympia','WA','84329','USA','1977-03-12','1992-03-17'),(5307,'Lloyd','William','5877 Ygnacio Valley Road',NULL,NULL,NULL,'Arcadia','CA','58951','USA','1978-05-25','1993-07-24'),(5356,'Abbott','Patrick','9405 Curletto Dr.',NULL,NULL,NULL,'Bellingham','WA','91702','USA','1976-10-06','1991-02-06'),(5357,'McCane','George','9445 Shannon Ln.',NULL,NULL,NULL,'Beaverton','OR','76445','USA','1977-02-16','1993-07-04'),(5407,'Lawson','Wesley','3983 Kiska Court',NULL,NULL,NULL,'Lincoln Acres','CA','23740','USA','1977-06-07','1991-02-27'),(5468,'Barnett','Luca','4760 Bryce Dr.',NULL,NULL,NULL,'Edmonds','WA','44272','USA','1978-11-09','1992-10-25'),(5508,'Calvert','Dorothy','232 K St.',NULL,NULL,NULL,'Glendale','CA','92990','USA','1977-10-16','1990-07-00'),(5532,'Beresford','Nicole','5613 Laverne Way',NULL,NULL,NULL,'Arcadia','CA','61827','USA','1977-02-17','1990-07-00'),(5553,'Sandblom','Kathy','5537 Baltic Sea Ct.',NULL,NULL,NULL,'Downey','CA','63241','USA','1977-11-13','1994-03-23'),(5625,'Boggs','Beatrice','2651 St. Francis Dr.','Unit A7',NULL,NULL,'Chula Vista','CA','59561','USA','1978-02-27','1990-07-00'),(5630,'Yandell','Scott','6710 Santa Monica Drive',NULL,NULL,NULL,'Lakewood','CA','53216','USA','1977-07-01','1990-07-00'),(5652,'Slavin','Joseph','4965 Bishop Court',NULL,NULL,NULL,'Acapulco','Guerrero','57433','Mexico','1976-08-13','1991-05-07'),(5677,'Bagley','Phyllis','224 Terrace Drive',NULL,NULL,NULL,'Walla Walla','WA','30372','USA','1976-03-25','1992-11-09'),(5807,'Alvarado','Grace','4621 Candelero Dr.',NULL,NULL,NULL,'La Mesa','CA','97451','USA','1976-05-25','1991-11-22'),(5826,'Miller','Sarah','4719 Delaware Drive',NULL,NULL,NULL,'Everett','WA','71334','USA','1976-05-20','1990-07-00'),(5827,'Sandoval','John','833 Sepueveda Court',NULL,NULL,NULL,'Beaverton','OR','10804','USA','1978-04-20','1992-10-24'),(5907,'Wright','Velma','1940 Meadow Glen Way',NULL,NULL,NULL,'Altadena','CA','56690','USA','1977-11-05','1993-07-22'),(5914,'Lewis','Louis','4855 Wawona Lane',NULL,NULL,NULL,'Coronado','CA','54788','USA','1977-07-13','1991-02-07'),(5932,'Skalka','Edward','2973 Steven Circle',NULL,NULL,NULL,'Lincoln Acres','CA','37120','USA','1976-02-12','1993-07-07'),(5943,'Wheeler','David','5587 Esperanza',NULL,NULL,NULL,'Sedro Woolley','WA','68141','USA','1978-04-27','1992-02-13'),(5972,'Remington','Tai','9691 Morengo Court','APT 98',NULL,NULL,'Redmond','WA','36193','USA','1976-12-19','1993-07-12'),(6015,'Stratton','Joshua','7895 Stanley Dollar Dr.',NULL,NULL,NULL,'Victoria','BC','45044','Canada','1976-10-28','1991-02-20'),(6030,'Mason','Gloria','6445 Heartwood Drive',NULL,NULL,NULL,'Haney','BC','32154','Canada','1978-12-16','1992-10-05'),(6058,'Atencio','Suzanne','8062 Oakgrove',NULL,NULL,NULL,'Metchosin','BC','14282','Canada','1977-07-06','1991-02-07'),(6064,'Tamichi','Vickie','8489 Seaview Ave.','#9',NULL,NULL,'San Jose','CA','98713','USA','1977-05-18','1994-09-23'),(6095,'Wall','Christopher','1658 Stonyhill Circle',NULL,NULL,NULL,'Glendale','CA','64639','USA','1978-06-13','1994-06-15'),(6111,'Ragulsky','Elizabeth','7847 Delta Fair Blvd.',NULL,NULL,NULL,'Camacho','Zacatecas','79252','Mexico','1977-08-04','1991-09-26'),(6114,'Kowalewski','Catherine','3788 Canyon Creek Drive',NULL,NULL,NULL,'Spokane','WA','16784','USA','1977-11-17','1990-07-00'),(6122,'Thompson','Jeannet','8915 Woodside Way',NULL,NULL,NULL,'Cliffside','BC','23812','Canada','1977-11-27','1993-07-05'),(6128,'Carpio','Jesse','9342 Temple Drive',NULL,NULL,NULL,'Cliffside','BC','25054','Canada','1977-09-12','1991-10-10'),(6131,'Cooper','Robert','157 Birch Bark Road',NULL,NULL,NULL,'Fremont','CA','50833','USA','1978-03-10','1994-05-11'),(6241,'Hunt','Pat','8018 Pinnacle Drive',NULL,NULL,NULL,'Altadena','CA','82692','USA','1978-07-13','1992-12-07'),(6251,'Kleinfelder','Ronald','4427 Langford Court',NULL,NULL,NULL,'Westminster','BC','58115','Canada','1976-05-03','1990-07-00'),(6263,'White','Lillian','6528 Paris Lane',NULL,NULL,NULL,'La Cruz','Sinaloa','73194','Mexico','1977-07-05','1991-09-20'),(6273,'Bustamante','Patricia','2429 Brown Street',NULL,NULL,NULL,'San Diego','CA','96585','USA','1978-09-16','1990-07-00'),(6284,'Abernathy','Christine','1604 Kenneth Ct.',NULL,NULL,NULL,'Arcadia','CA','88526','USA','1977-12-02','1993-07-07'),(6295,'Weger','Joseph','4380 Chestnut',NULL,NULL,NULL,'Imperial Beach','CA','12765','USA','1977-09-08','1993-07-26'),(6299,'Hartvickson','Gina','3780 Angi Lane',NULL,NULL,NULL,'West Covina','CA','86385','USA','1978-11-21','1994-09-22'),(6333,'Barbarino','Marcia','6308 Broadway Street',NULL,NULL,NULL,'Berkeley','CA','83333','USA','1977-10-04','1991-12-24'),(6349,'Trent','Jason','5153 Hackamore Lane',NULL,NULL,NULL,'Shawnee','BC','62062','Canada','1976-03-25','1991-11-15'),(6357,'Woodbury','Margo','3952 Morello Ave.',NULL,NULL,NULL,'Langford','BC','21986','Canada','1978-08-23','1992-05-05'),(6358,'Just','Talmadge','8611 Park Lane Circle',NULL,NULL,NULL,'Acapulco','Guerrero','41020','Mexico','1976-11-12','1991-08-14'),(6398,'Anderson','Erika','8148 W. Lake Dr.',NULL,NULL,NULL,'Beaverton','OR','44938','USA','1978-09-03','1991-05-19'),(6440,'Whitteker','Aaron','6403 Maureen Circle',NULL,NULL,NULL,'Merida','Yucatan','93864','Mexico','1976-08-13','1991-06-26'),(6445,'Voss','Gary','1663 Almond Drive',NULL,NULL,NULL,'Grossmont','CA','41793','USA','1977-05-27','1993-07-18'),(6494,'Clifton','Jill','593 Chatworth',NULL,NULL,NULL,'Downey','CA','32206','USA','1976-10-07','1992-10-25'),(6504,'Chang','Norma','9911 Northgate Road',NULL,NULL,NULL,'Fremont','CA','72789','USA','1977-03-04','1993-07-22'),(6509,'Crasky','Gary','2516 Bonifacio St.',NULL,NULL,NULL,'Metchosin','BC','67132','Canada','1977-11-18','1991-07-15'),(6522,'Burke','Mahtouz','6898 Holiday Hills',NULL,NULL,NULL,'Woodburn','OR','77707','USA','1976-08-21','1994-01-15'),(6526,'Filler','Jane','5790 Ponderosa Drive',NULL,NULL,NULL,'Lebanon','OR','19391','USA','1978-08-16','1992-03-20'),(6548,'Alvarado','Ronan','6701 Eagle Peak Ave.',NULL,NULL,NULL,'San Carlos','CA','37753','USA','1977-09-27','1991-09-26'),(6582,'Wagner','Suzanna','1516 Court Lane',NULL,NULL,NULL,'Haney','BC','72269','Canada','1976-05-20','1994-10-25'),(6605,'Gould','Rae','5123 Gumwood',NULL,NULL,NULL,'Concord','CA','43147','USA','1977-06-15','1990-07-00'),(6614,'Baltzer','Ernest','8581 Paris Lane',NULL,NULL,NULL,'Bellingham','WA','10099','USA','1978-02-02','1993-07-11'),(6659,'Bishop','Rachel','3748 Bellwood Dr.',NULL,NULL,NULL,'Ballard','WA','91582','USA','1976-04-25','1993-07-18'),(6670,'Young','Henry','3016 Arleda Lane',NULL,NULL,NULL,'Pomona','CA','97582','USA','1976-05-03','1992-09-17'),(6687,'Ehrens','Allison','8876 Wawona Lane',NULL,NULL,NULL,'Burbank','CA','15993','USA','1976-11-21','1992-10-17'),(6744,'Brashears','Ruth','5843 Mountaire Pkwy.',NULL,NULL,NULL,'Lebanon','OR','13247','USA','1977-11-19','1993-07-22'),(6758,'Campbell','Carol','6594 Bent Tree Lane',NULL,NULL,NULL,'Beaverton','OR','73542','USA','1976-11-17','1992-11-24'),(6822,'Bartles','Lance','104 Kaski Ln.',NULL,NULL,NULL,'Portland','OR','53791','USA','1976-06-08','1990-07-00'),(6842,'Hanson','William','495 Alameda Drive',NULL,NULL,NULL,'Coronado','CA','36435','USA','1977-08-21','1992-01-22'),(6855,'Parker','Susie','1136 Leland Way',NULL,NULL,NULL,'San Andres','DF','61413','Mexico','1977-09-08','1993-07-20'),(6857,'Kimball','Diana','5582 Ryan Court',NULL,NULL,NULL,'Downey','CA','82402','USA','1977-11-23','1992-06-04'),(6859,'Smith','Keith','536 Beech Ct.','Unit B',NULL,NULL,'Redwood City','CA','60712','USA','1978-11-20','1990-07-00'),(6883,'Serina','Nancy','9425 Village Road',NULL,NULL,NULL,'Edmonds','WA','74392','USA','1976-09-07','1994-11-07'),(6965,'Lair','Bonnie','5209 Janin Pl.',NULL,NULL,NULL,'San Diego','CA','76902','USA','1977-01-16','1992-02-19'),(6984,'Weinert','Carol','6346 Doyle',NULL,NULL,NULL,'Marysville','WA','96089','USA','1976-08-13','1993-07-13'),(7039,'Constuble','James','3487 Hill Dr.',NULL,NULL,NULL,'Langley','BC','94160','Canada','1978-02-26','1993-07-06'),(7060,'Arizaga','Keith','7546 Gonzalez Ct.','NO 138',NULL,NULL,'Santa Monica','CA','38647','USA','1978-08-11','1991-09-26'),(7082,'Anderson','Mitch','8965 Rheem Blvd.',NULL,NULL,NULL,'N. Vancouver','BC','17702','Canada','1977-07-25','1994-06-02'),(7088,'Bevis','Michael','9392 16th St.',NULL,NULL,NULL,'Redmond','WA','99054','USA','1977-05-10','1994-02-15'),(7091,'Vanover','Son','7551 Black Walnut Ct.',NULL,NULL,NULL,'Acapulco','Guerrero','96926','Mexico','1978-10-08','1993-07-14'),(7124,'Thompson','Barbara','6366 Dayton Court',NULL,NULL,NULL,'Bellflower','CA','17572','USA','1977-02-14','1991-05-17'),(7139,'Wright','Stanley','9396 Viera Avenue',NULL,NULL,NULL,'San Gabriel','CA','53702','USA','1977-05-27','1990-07-00'),(7155,'Bustamante','Geneva','6208 Prestwick Dr.',NULL,NULL,NULL,'Tixapan','DF','15292','Mexico','1978-05-27','1992-10-06'),(7192,'Stevens','Laurel','7081 Willow Pass Road',NULL,NULL,NULL,'Bellingham','WA','94361','USA','1978-10-17','1993-07-18'),(7246,'Breslin','Danielle','26 Leland Way','Unit A',NULL,NULL,'Torrance','CA','32993','USA','1976-06-05','1994-04-10'),(7260,'Francis','Vivien','1908 Stanford Street',NULL,NULL,NULL,'San Diego','CA','49083','USA','1978-08-15','1992-07-01'),(7349,'Jahn','Gene','1069 Ahwanee Lane',NULL,NULL,NULL,'Daly City','CA','34852','USA','1978-07-21','1994-03-16'),(7413,'Salazar','Vala','3168 Limewood Pl.',NULL,NULL,NULL,'Bremerton','WA','10547','USA','1977-08-03','1993-07-20'),(7464,'Lindenberg','Gladys','9961 Tice',NULL,NULL,NULL,'Beaverton','OR','19884','USA','1978-11-11','1991-02-09'),(7476,'Docktar','Sarah','1555 Running Springs Rd.',NULL,NULL,NULL,'San Andres','DF','52552','Mexico','1977-09-25','1992-03-11'),(7536,'Sample','Michael','8598 Sharon Dr.',NULL,NULL,NULL,'Newport Beach','CA','33140','USA','1977-06-13','1992-02-16'),(7539,'Butler','Lauri','9412 Alhambra Avenue',NULL,NULL,NULL,'Port Hammond','BC','58919','Canada','1977-12-11','1992-08-17'),(7554,'Augusts','Larry','6208 Hedaro Court',NULL,NULL,NULL,'Imperial Beach','CA','14706','USA','1978-06-26','1990-07-00'),(7566,'Driscole','Eula','3505 Bisca Y Court',NULL,NULL,NULL,'Langley','BC','14403','Canada','1977-06-05','1992-04-26'),(7583,'Kuntz','Todd','9365 G St.',NULL,NULL,NULL,'Santa Monica','CA','17418','USA','1977-11-23','1993-07-24'),(7586,'Voeltz','Cheri','2651 Ancona Ct.',NULL,NULL,NULL,'Sedro Woolley','WA','26278','USA','1977-03-09','1990-07-00'),(7608,'Howard','Jim','7234 Relief Valley Ct.',NULL,NULL,NULL,'Edmonds','WA','40846','USA','1976-04-11','1992-12-12'),(7640,'Moody','Blaise','7579 Roundtree Pl.',NULL,NULL,NULL,'San Jose','CA','80615','USA','1978-01-20','1993-07-20'),(7642,'Stearns','Susana','2279 Pineview Lane',NULL,NULL,NULL,'Woodland Hills','CA','66021','USA','1976-07-19','1990-07-00'),(7654,'Waldrop','Maisy','6920 Brook Hollow Ct.',NULL,NULL,NULL,'Kirkland','WA','93915','USA','1977-12-18','1992-12-10'),(7680,'Beatty','Paul','396 North Ridge Dr.',NULL,NULL,NULL,'Bellingham','WA','21382','USA','1976-07-07','1990-07-00'),(7687,'Moncrieff','Colleen','609 Power Ave.',NULL,NULL,NULL,'Oregon City','OR','28830','USA','1978-03-18','1993-07-17'),(7689,'Sanchez','Terry','5055 Quigley St.',NULL,NULL,NULL,'Ballard','WA','49979','USA','1978-06-06','1991-10-17'),(7705,'Carter','Jessamyn','9997 Montgomery Ave.',NULL,NULL,NULL,'Newport Beach','CA','45849','USA','1977-10-28','1991-06-12'),(7715,'Wardle','Lisa','6406 Golden Leaf Way',NULL,NULL,NULL,'Lebanon','OR','39489','USA','1976-04-17','1990-07-00'),(7751,'McDonald','Larry','2989 Pepperidge Way',NULL,NULL,NULL,'Metchosin','BC','12952','Canada','1978-07-12','1993-07-26'),(7769,'Allison','Dirk','968 W Lake Dr.',NULL,NULL,NULL,'Beaverton','OR','18604','USA','1976-11-09','1993-07-02'),(7788,'Gilliom','Ray','6908 Woodchuck Pl.',NULL,NULL,NULL,'La Cruz','Sinaloa','45882','Mexico','1978-08-20','1990-07-00'),(7794,'McBride','Elizabeth','8074 Corte Valencia',NULL,NULL,NULL,'Orizaba','Veracruz','97257','Mexico','1977-08-23','1991-08-12'),(7807,'Plaisance','Gene','5043 Minert Rd.',NULL,NULL,NULL,'Seattle','WA','59590','USA','1978-04-01','1990-07-00'),(7815,'Spencer','Lyle','3842 Algiers Dr.',NULL,NULL,NULL,'Daly City','CA','78310','USA','1977-09-21','1990-07-00'),(7829,'Bucker','Danetta','9995 Valley View Road',NULL,NULL,NULL,'El Cajon','CA','58352','USA','1977-06-05','1994-09-14'),(7939,'Suggett','Bryan','2084 Villageoaks Dr.',NULL,NULL,NULL,'Tixapan','DF','92442','Mexico','1978-07-23','1993-07-11'),(8004,'Shinn','Ashley','7342 Pueblo Dr.',NULL,NULL,NULL,'La Mesa','CA','84226','USA','1976-05-19','1994-08-15'),(8006,'Wilson','Frank','8369 Dutch Slough Rd.',NULL,NULL,NULL,'Cliffside','BC','35183','Canada','1978-01-06','1991-03-28'),(8025,'Hand','Myron','939 Vista Del Diablo',NULL,NULL,NULL,'Richmond','CA','42827','USA','1976-02-06','1991-10-11'),(8038,'Wagner','Joann','125 Keller Ridge',NULL,NULL,NULL,'San Diego','CA','22078','USA','1976-08-18','1990-07-00'),(8073,'Stith','Shawnda','1538 Golden Meadow','#309',NULL,NULL,'La Jolla','CA','52464','USA','1977-02-06','1992-04-25'),(8103,'Parker','Theresa','1502 Marion Ct.',NULL,NULL,NULL,'Oakland','CA','69885','USA','1977-01-21','1991-06-25'),(8105,'Turnbell','Kathi','5948 Seeno St.',NULL,NULL,NULL,'N. Vancouver','BC','91034','Canada','1977-04-09','1990-07-00'),(8107,'Caldwell','James','3557 Harvard Court',NULL,NULL,NULL,'Edmonds','WA','44506','USA','1978-04-06','1990-07-00'),(8117,'Tonti','Patricia','9064 Silverado Dr.',NULL,NULL,NULL,'Portland','OR','32222','USA','1977-10-05','1993-07-07'),(8133,'Pals','Robin','9318 Larch Ct.',NULL,NULL,NULL,'Pomona','CA','92211','USA','1976-03-27','1993-07-03'),(8141,'Manakoff','Mark','2020 Augustine Dr.',NULL,NULL,NULL,'Walla Walla','WA','41454','USA','1978-08-25','1992-10-27'),(8195,'Smith','Jennie','2055 Seawind Dr.',NULL,NULL,NULL,'Long Beach','CA','13344','USA','1978-09-20','1992-09-09'),(8211,'Svensson','Sharona','2309 Mt. Olivet Ct.',NULL,NULL,NULL,'Portland','OR','29626','USA','1977-12-11','1992-09-09'),(8216,'Wright','Jean','9277 Claycord Ave.',NULL,NULL,NULL,'Berkeley','CA','88443','USA','1978-09-07','1994-11-05'),(8228,'Martinez','Inez','2903 Marsh Dr.',NULL,NULL,NULL,'Orizaba','Veracruz','4046','Mexico','1977-07-22','1994-06-12'),(8292,'Jones','Biju','4496 Hurlstone Ct.',NULL,NULL,NULL,'Colma','CA','29386','USA','1977-11-16','1994-07-26'),(8333,'Estep','Sarah','7352 Mt. Wilson Pl.',NULL,NULL,NULL,'Sooke','BC','93831','Canada','1978-03-16','1990-07-00'),(8343,'Marshall','Janet','3992 C Kenwal Rd.',NULL,NULL,NULL,'Burien','WA','57577','USA','1977-07-17','1992-04-26'),(8347,'Bogaert','Margie','3391 Paso Del Rio Court',NULL,NULL,NULL,'Lemon Grove','CA','32198','USA','1978-10-03','1993-07-06'),(8381,'Bottarini','Mary','7952 El Verano',NULL,NULL,NULL,'Port Hammond','BC','53823','Canada','1977-09-13','1992-09-11'),(8411,'Goldblatt','Ann','6900 Bellord Ct.',NULL,NULL,NULL,'Redmond','WA','10213','USA','1978-03-24','1991-02-15'),(8414,'Kinnaird','Greg','3350 Kingswood Circle',NULL,NULL,NULL,'Tacoma','WA','50396','USA','1977-08-01','1993-07-13'),(8451,'Peters','Bette','896 Shannon Lane',NULL,NULL,NULL,'Grossmont','CA','45931','USA','1977-09-05','1990-07-00'),(8479,'Schuster','Karen','8562 Veale Ave.',NULL,NULL,NULL,'Berkeley','CA','82881','USA','1978-04-01','1993-07-01'),(8501,'Valenzuela','Marygael','2269 Bynum Way',NULL,NULL,NULL,'Fremont','CA','30384','USA','1977-06-05','1991-03-04'),(8541,'Wight','Steve','8133 Andrews Dr.',NULL,NULL,NULL,'Burien','WA','16166','USA','1977-10-28','1991-08-18'),(8623,'Testa','Makiko','5671 DiMaggio Way',NULL,NULL,NULL,'Lincoln Acres','CA','27202','USA','1978-08-16','1991-06-25'),(8627,'Merkley','Geoff','5071 Stonehedge Dr.',NULL,NULL,NULL,'Port Hammond','BC','18232','Canada','1977-06-19','1992-09-02'),(8671,'Vasilauskas','Robert','6270 Pinecreek Way',NULL,NULL,NULL,'San Diego','CA','61516','USA','1977-03-07','1993-07-10'),(8674,'Umali','Marie','2212 O St.',NULL,NULL,NULL,'Santa Fe','DF','16177','Mexico','1977-07-20','1991-07-06'),(8724,'Lawrence','Cheryl','9428 Mehaffey Way',NULL,NULL,NULL,'Glendale','CA','19896','USA','1977-11-21','1993-07-25'),(8740,'Waggoner','Anne Marie','9682 Concord',NULL,NULL,NULL,'Haney','BC','16056','Canada','1978-10-12','1991-06-08'),(8753,'Winter','Jeff','9167 Jennifer Way',NULL,NULL,NULL,'Beverly Hills','CA','71963','USA','1976-02-01','1993-07-15'),(8796,'Baviera','Ernie','8181 Landana Dr.',NULL,NULL,NULL,'Santa Monica','CA','53894','USA','1976-10-23','1992-05-07'),(8803,'Stanifer','Phillip','8903 Suzanne Dr.',NULL,NULL,NULL,'Daly City','CA','85618','USA','1977-09-26','1992-05-28'),(8846,'Woodside','Lillie','8398 Mt. Hood Circle',NULL,NULL,NULL,'Camacho','Zacatecas','38876','Mexico','1977-12-07','1992-09-05'),(8920,'Jones','Margaret','1227 Brannan Pl.',NULL,NULL,NULL,'San Jose','CA','77182','USA','1978-07-22','1994-08-11'),(8922,'Walters','Carolyn','615 Maria Vega Court',NULL,NULL,NULL,'Woodland Hills','CA','64493','USA','1976-02-21','1991-09-21'),(8932,'Mcintire','Amanda','3605 Gallagher Circle',NULL,NULL,NULL,'San Andres','DF','14233','Mexico','1976-04-10','1992-06-27'),(8937,'Winkley','Walter','5701 San Miguel Road',NULL,NULL,NULL,'Woodland Hills','CA','29838','USA','1978-10-06','1991-07-02'),(8965,'Virant','Stacey','1728 Woodside Ct.',NULL,NULL,NULL,'Burlingame','CA','31016','USA','1976-06-10','1991-10-03'),(8968,'Wren','Rory','579 Pinnacle Dr.',NULL,NULL,NULL,'Milwaukie','OR','32330','USA','1976-09-13','1990-07-00'),(8972,'Holland','Carl','3143 N. Main',NULL,NULL,NULL,'Mill Valley','CA','11982','USA','1976-03-17','1994-11-02'),(9002,'McClain','Richard','4378 Dover Way',NULL,NULL,NULL,'San Carlos','CA','68262','USA','1978-07-03','1992-06-19'),(9012,'Rollings','Richard','8614 Lagoon Court',NULL,NULL,NULL,'National City','CA','91908','USA','1977-04-09','1992-04-04'),(9038,'Colletti','Carol','9548 Jomar Drive',NULL,NULL,NULL,'Port Hammond','BC','24331','Canada','1977-07-25','1991-03-08'),(9058,'Bogott','Kevin','8694 Orangewood Ave.',NULL,NULL,NULL,'Lemon Grove','CA','33267','USA','1978-11-13','1992-04-27'),(9173,'Ulibarri','Luther','3132 Liana Lane',NULL,NULL,NULL,'Beaverton','OR','64635','USA','1977-07-26','1994-05-11'),(9206,'Sweet','Jennifer','4858 El Molino Dr.',NULL,NULL,NULL,'Olympia','WA','40008','USA','1977-08-23','1991-02-10'),(9231,'Bertelloti','Gloria','6468 Gatewood Court',NULL,NULL,NULL,'Lake Oswego','OR','54621','USA','1978-11-06','1991-09-11'),(9242,'Jones','Timothy','1439 N. Michell Canyon Rd.',NULL,NULL,NULL,'Everett','WA','69200','USA','1977-02-21','1990-07-00'),(9252,'Borg','Elizabeth','4429 Pine Creek Way',NULL,NULL,NULL,'Glendale','CA','73430','USA','1976-01-03','1992-11-15'),(9254,'Brooks','Shannon','5457 Woodcrest Dr.','APT F',NULL,NULL,'Marysville','WA','24387','USA','1978-08-17','1994-10-26'),(9284,'Black','Alisha','2119 Chisholm Way',NULL,NULL,NULL,'Santa Cruz','CA','65460','USA','1978-10-12','1993-07-04'),(9304,'Kentz','Johnny','8955 Tice Valley Blvd.',NULL,NULL,NULL,'Langley','BC','14690','Canada','1976-05-25','1992-02-16'),(9311,'Auguscik','James','2841 Georgia Dr.',NULL,NULL,NULL,'Mexico City','Mexico','78151','Mexico','1976-08-21','1992-10-03'),(9336,'Luks','Paul','5398 Shadow Falls Drive',NULL,NULL,NULL,'Berkeley','CA','53259','USA','1978-02-06','1991-07-06'),(9346,'Jones','Ryan','7880 Mission Drive',NULL,NULL,NULL,'Seattle','WA','24842','USA','1977-09-16','1994-01-17'),(9449,'Addington','Helen','7792 Woodruff Lane',NULL,NULL,NULL,'Burbank','CA','96282','USA','1976-06-05','1992-08-09'),(9467,'Trujillo','Ruth','3000 Wildcat Circle',NULL,NULL,NULL,'Milwaukie','OR','71627','USA','1977-09-20','1993-07-15'),(9479,'Velasco','Marie','5101 Camino Peral',NULL,NULL,NULL,'Downey','CA','38676','USA','1977-06-08','1993-07-19'),(9481,'Barnes','L. Troy','9546 Cardinal Ct.',NULL,NULL,NULL,'Lincoln Acres','CA','59825','USA','1977-09-23','1991-05-19'),(9483,'Blakely','Louella','7156 Rose Dr.',NULL,NULL,NULL,'Metchosin','BC','13298','Canada','1978-09-20','1994-10-02'),(9489,'Yunker','Cheryl','1002 N. Spoonwood Court',NULL,NULL,NULL,'Berkeley','CA','90682','USA','1977-08-12','1991-10-24'),(9504,'Miller','J.','5232 Black Point Pl.',NULL,NULL,NULL,'Salem','OR','56282','USA','1977-07-05','1993-07-09'),(9505,'Hall','Frederick','8436 L St.',NULL,NULL,NULL,'Lynnwood','WA','52282','USA','1976-02-07','1993-07-15'),(9527,'Stober','Bill','8356 Mori Court',NULL,NULL,NULL,'Burbank','CA','46408','USA','1976-01-26','1991-11-10'),(9531,'Fabec','Geraldine','9001 Esperanza',NULL,NULL,NULL,'Redmond','WA','21030','USA','1977-04-11','1990-07-00'),(9537,'Haug','Dawn','2847 Center Ave',NULL,NULL,NULL,'Daly City','CA','16800','USA','1976-03-09','1991-03-23'),(9578,'Underwood','Donovan','8568 Wellington Ct.',NULL,NULL,NULL,'Corvallis','OR','95090','USA','1976-04-24','1994-04-13'),(9586,'Sowa','Michael','7597 San Vincente Drive',NULL,NULL,NULL,'Acapulco','Guerrero','79792','Mexico','1976-04-07','1991-04-12'),(9604,'Walker','Lisa','8371 Shenandoah Drive',NULL,NULL,NULL,'El Cajon','CA','48774','USA','1977-07-06','1992-02-05'),(9625,'Houser','Vivian','2754 Stanbridge Ct.',NULL,NULL,NULL,'Merida','Yucatan','32758','Mexico','1978-03-20','1991-09-03'),(9642,'Clifton','Martha','831 Valley Crest Dr.',NULL,NULL,NULL,'Bremerton','WA','73105','USA','1976-08-18','1991-02-19'),(9648,'Vine','Cathy','5160 La Vista Circle',NULL,NULL,NULL,'Woodburn','OR','71391','USA','1976-05-02','1991-04-04'),(9710,'Paul','Glen','4478 W Lake Drive',NULL,NULL,NULL,'Newport Beach','CA','94037','USA','1977-09-21','1992-05-14'),(9715,'Doman','Bradley','6827 Seagull Court',NULL,NULL,NULL,'Puyallup','WA','30982','USA','1976-01-10','1992-08-10'),(9762,'Digennaro','Irene','2559 Altura Drive',NULL,NULL,NULL,'Langley','BC','17161','Canada','1978-02-09','1992-05-14'),(9769,'Schranz','Darleen','2518 Kirkwood Dr.',NULL,NULL,NULL,'Spring Valley','CA','77692','USA','1978-06-04','1994-01-05'),(9783,'Wong','William','983 St. Dunstan Ct.',NULL,NULL,NULL,'Langford','BC','26121','Canada','1977-06-07','1991-03-08'),(9798,'Gallagher','Dyana','5860 Alamo Way',NULL,NULL,NULL,'Burnaby','BC','97904','Canada','1977-04-07','1993-07-09'),(9847,'Wilkinson','William','3199 Frayne Ct.',NULL,NULL,NULL,'Tlaxiaco','Oaxaca','51461','Mexico','1977-10-01','1994-09-13'),(9851,'Bell','Marla','2599 Vine Hill Way',NULL,NULL,NULL,'Bremerton','WA','26082','USA','1978-02-14','1991-03-20'),(9900,'Sears','Arnold','8782 Jamie Way.',NULL,NULL,NULL,'Lynnwood','WA','75300','USA','1977-07-10','1991-10-16'),(9921,'Buensalido','Dennis','8706 Royal Arch Court',NULL,NULL,NULL,'Redwood City','CA','46283','USA','1976-11-09','1991-08-06'),(9927,'Hatton','Peter','5716 Weatherly Drive',NULL,NULL,NULL,'La Mesa','CA','25346','USA','1976-08-10','1993-07-19'),(9929,'Chamberlin','Kathryn','162 Courthouse Drive',NULL,NULL,NULL,'Albany','OR','46495','USA','1976-10-26','1992-09-04'),(9931,'Bastrana','Terrell','5115 Meadowbrook Court',NULL,NULL,NULL,'Torrance','CA','98966','USA','1977-10-23','1994-11-02'),(9938,'Wade','Angeline','6391 Arcadia Place',NULL,NULL,NULL,'N. Vancouver','BC','82448','Canada','1978-05-22','1991-02-02'),(9973,'Cattelona','Kimberlee','5033 Pine Hollow Rd.',NULL,NULL,NULL,'Long Beach','CA','20480','USA','1976-07-25','1990-07-00'),(9981,'Noonan','Colin','6488 Taylor Box #229',NULL,NULL,NULL,'Burien','WA','34645','USA','1978-12-23','1993-07-02'),(9997,'Spinks','John','3923 Dew Drop Circle',NULL,NULL,NULL,'Olympia','WA','30225','USA','1977-05-17','1991-06-04'),(10043,'Husk','Velma','470 Keller Ridge',NULL,NULL,NULL,'Walla Walla','WA','25545','USA','1976-07-11','1990-07-00'),(10057,'Phillips','Mary','1705 Gumwood',NULL,NULL,NULL,'Richmond','CA','67652','USA','1977-08-21','1994-02-01'),(10071,'Pesonen','Dieter','7513 Royal Links Ct.',NULL,NULL,NULL,'Haney','BC','43988','Canada','1976-08-24','1994-05-05'),(10075,'Walton','Nora','9568 Gold Crest Ct.',NULL,NULL,NULL,'Lynnwood','WA','38732','USA','1977-10-10','1992-07-26'),(10117,'Richberger','Mary','5584 Greenview Court',NULL,NULL,NULL,'Berkeley','CA','37507','USA','1978-03-17','1993-07-03'),(10167,'Vigil','Cheryl','121 Rotherham Dr.',NULL,NULL,NULL,'Olympia','WA','79575','USA','1976-03-21','1993-07-06'),(10217,'Kelly','Carroll','9231 Brook Hollow Ct.',NULL,NULL,NULL,'Woodland Hills','CA','38070','USA','1977-07-12','1992-03-24'),(10251,'Trahan','Tina','5776 Newton Way',NULL,NULL,NULL,'La Jolla','CA','50192','USA','1977-03-16','1990-07-00'),(10257,'Clayton','Brian','9621 Laurel Drive',NULL,NULL,NULL,'Renton','WA','92295','USA','1978-09-20','1992-06-13');
Create database connection di iReport ke database eventdriven (sesuai nama diatas), tekan test untuk meyakinkan apakah koneksi sudah benar atau belum.
Masukkan field customer_id, lname, fname, city, state, dan country ke detail band.
Kemudian add parameter dan beri nama opened.
dengan setting parameter class java.util.date default value: new Date(90,0,1)
Kemudian rubah filter query di report WHERE customer.`date_accnt_opened` BETWEEN $P{opened} AND NOW()
Buat satu parameter lagi dengan nama report_count yang berisi $V{REPORT_COUNT} + " new Customers since " + new SimpleDateFormat("dd/MM/yyyy").format($P{opened})
Kemudian publish seperti cara sebelumnya dengan klik kanan add report_unit, dan seterusnya
Tidak ada komentar:
Posting Komentar