addresses.sql

-- DELETE FROM address_search;
DELETE FROM address;

INSERT INTO address (active, title, st_address, city, county, state, zip, type, country, createDate, modDate) VALUES 
(1,'Feltz Printing Service','639 Main St','Anchorage','Anchorage','AK','99501','work','US', 0, 0),
(1,'Printing Dimensions','34 Center St','Hamilton','Butler','OH','45011','work','US', 0, 0),
(1,'Morlong Associates','7 Eads St','Chicago','Cook','IL','60632','work','US', 0, 0),
(1,'Commercial Press','7 W Jackson Blvd','San Jose','Santa Clara','CA','95111','work','US', 0, 0),
(1,'Truhlar And Truhlar Attys','5 Boston Ave #88','Sioux Falls','Minnehaha','SD','57105','work','US', 0, 0),
(1,'Rangoni Of Florence','37275 St  Rt 17m M','Middle Island','Suffolk','NY','11953','work','US', 0, 0),
(1,'Feiner Bros','25 E 75th St #69','Los Angeles','Los Angeles','CA','90034','work','US', 0, 0),
(1,'Buckley Miller & Wright','98 Connecticut Ave Nw','Chagrin Falls','Geauga','OH','44023','work','US', 0, 0),
(1,'Century Communications','73 State Road 434 E','Phoenix','Maricopa','AZ','85013','work','US', 0, 0),
(1,'T M Byxbee Company Pc','322 New Horizon Blvd','Milwaukee','Milwaukee','WI','53207','work','US', 0, 0),
(1,'Farmers Insurance Group','1 State Route 27','Taylor','Wayne','MI','48180','work','US', 0, 0),
(1,'Post Box Services Plus','394 Manchester Blvd','Rockford','Winnebago','IL','61109','work','US', 0, 0),
(1,'Sport En Art','6 S 33rd St','Aston','Delaware','PA','19014','work','US', 0, 0),
(1,'C 4 Network Inc','6 Greenleaf Ave','San Jose','Santa Clara','CA','95111','work','US', 0, 0),
(1,'Wtlz Power 107 Fm','3273 State St','Middlesex','Middlesex','NJ','8846','work','US', 0, 0),
(1,'Professional Image Inc','86 Nw 66th St #8673','Shawnee','Johnson','KS','66218','work','US', 0, 0),
(1,'U Pull It','90991 Thorburn Ave','New York','New York','NY','10011','work','US', 0, 0),
(1,'Cascade Realty Advisors Inc','366 South Dr','Las Cruces','Dona Ana','NM','88011','work','US', 0, 0),
(1,'Knwz Newsradio','45 E Liberty St','Ridgefield Park','Bergen','NJ','7660','work','US', 0, 0),
(1,'Milford Enterprises Inc','2742 Distribution Way','New York','New York','NY','10025','work','US', 0, 0),
(1,'Tri State Refueler Co','128 Bransten Rd','New York','New York','NY','10011','work','US', 0, 0),
(1,'Parkway Company','17 Morena Blvd','Camarillo','Ventura','CA','93012','work','US', 0, 0),
(1,'Fbs Business Finance','775 W 17th St','San Antonio','Bexar','TX','78204','work','US', 0, 0),
(1,'Eder Assocs Consltng Engrs Pc','6980 Dorsett Rd','Abilene','Dickinson','KS','67410','work','US', 0, 0),
(1,'Tri M Tool Inc','2881 Lewis Rd','Prineville','Crook','OR','97754','work','US', 0, 0),
(1,'International Eyelets Inc','7219 Woodfield Rd','Overland Park','Johnson','KS','66204','work','US', 0, 0),
(1,'Rapid Trading Intl','1048 Main St','Fairbanks','Fairbanks North Star','AK','99708','work','US', 0, 0),
(1,'Abc Enterprises Inc','678 3rd Ave','Miami','Miami-Dade','FL','33196','work','US', 0, 0),
(1,'Cindy Turner Associates','20 S Babcock St','Fairbanks','Fairbanks North Star','AK','99712','work','US', 0, 0),
(1,'Grace Pastries Inc','38938 Park Blvd','Boston','Suffolk','MA','2128','work','US', 0, 0),
(1,'Knights Inn','762 S Main St','Madison','Dane','WI','53711','work','US', 0, 0),
(1,'Bollinger Mach Shp & Shipyard','209 Decker Dr','Philadelphia','Philadelphia','PA','19132','work','US', 0, 0),
(1,'Orinda News','4486 W O St #1','New York','New York','NY','10003','work','US', 0, 0),
(1,'Ballard Spahr Andrews','39 S 7th St','Tullahoma','Coffee','TN','37388','work','US', 0, 0),
(1,'Lowy Limousine Service','98839 Hawthorne Blvd #6101','Columbia','Richland','SC','29201','work','US', 0, 0),
(1,'Vicon Corporation','71 San Mateo Ave','Wayne','Delaware','PA','19087','work','US', 0, 0),
(1,'Northwest Publishing','4545 Courthouse Rd','Westbury','Nassau','NY','11590','work','US', 0, 0),
(1,'Branford Wire & Mfg Co','14288 Foster Ave #4121','Jenkintown','Montgomery','PA','19046','work','US', 0, 0),
(1,'East Coast Marketing','4 Otis St','Van Nuys','Los Angeles','CA','91405','work','US', 0, 0),
(1,'Wye Technologies Inc','65895 S 16th St','Providence','Providence','RI','2909','work','US', 0, 0),
(1,'Alpenlite Inc','201 Hawk Ct','Providence','Providence','RI','2904','work','US', 0, 0),
(1,'Arthur A Oliver & Son Inc','59 N Groesbeck Hwy','Austin','Travis','TX','78731','work','US', 0, 0),
(1,'George Jessop Carter Jewelers','2664 Lewis Rd','Littleton','Douglas','CO','80126','work','US', 0, 0),
(1,'H H H Enterprises Inc','3305 Nabell Ave #679','New York','New York','NY','10009','work','US', 0, 0),
(1,'Hawaiian King Hotel','18 Fountain St','Anchorage','Anchorage','AK','99515','work','US', 0, 0),
(1,'Killion Industries','7 W 32nd St','Erie','Erie','PA','16502','work','US', 0, 0),
(1,'Private Properties','74 W College St','Boise','Ada','ID','83707','work','US', 0, 0),
(1,'Rowley Schlimgen Inc','701 S Harrison Rd','San Francisco','San Francisco','CA','94104','work','US', 0, 0),
(1,'Forging Specialties','1088 Pinehurst St','Chapel Hill','Orange','NC','27514','work','US', 0, 0),
(1,'H Lee Leonard Attorney At Law','20932 Hedley St','Concord','Contra Costa','CA','94520','work','US', 0, 0),
(1,'A K Construction Co','2737 Pistorio Rd #9230','London','Madison','OH','43140','work','US', 0, 0),
(1,'Q A Service','6 Kains Ave','Baltimore','Baltimore City','MD','21215','work','US', 0, 0),
(1,'Wood & Whitacre Contractors','47565 W Grand Ave','Newark','Essex','NJ','7105','work','US', 0, 0),
(1,'Mark Iv Press Ltd','4284 Dorigo Ln','Chicago','Cook','IL','60647','work','US', 0, 0),
(1,'Museum Of Science & Industry','6794 Lake Dr E','Newark','Essex','NJ','7104','work','US', 0, 0),
(1,'Garrison Ind','31 Douglas Blvd #950','Clovis','Curry','NM','88101','work','US', 0, 0),
(1,'Saronix Nymph Products','44 W 4th St','Staten Island','Richmond','NY','10309','work','US', 0, 0),
(1,'Smc Inc','11279 Loytan St','Jacksonville','Duval','FL','32254','work','US', 0, 0),
(1,'E A I Electronic Assocs Inc','69 Marquette Ave','Hayward','Alameda','CA','94545','work','US', 0, 0),
(1,'Anker Law Office','461 Prospect Pl #316','Euless','Tarrant','TX','76040','work','US', 0, 0),
(1,'Beutelschies & Company','47154 Whipple Ave Nw','Gardena','Los Angeles','CA','90247','work','US', 0, 0),
(1,'Jewel My Shop Inc','4800 Black Horse Pike','Burlingame','San Mateo','CA','94010','work','US', 0, 0),
(1,'Chinese Translation Resources','83649 W Belmont Ave','San Gabriel','Los Angeles','CA','91776','work','US', 0, 0),
(1,'Tree Musketeers','99385 Charity St #840','San Jose','Santa Clara','CA','95110','work','US', 0, 0),
(1,'Springfield Div Oh Edison Co','68556 Central Hwy','San Leandro','Alameda','CA','94577','work','US', 0, 0),
(1,'Logan Memorial Hospital','55 Riverside Ave','Indianapolis','Marion','IN','46202','work','US', 0, 0),
(1,'Industrial Paper Shredders Inc','64 5th Ave #1153','Mc Lean','Fairfax','VA','22102','work','US', 0, 0),
(1,'Beck Horizon Builders','3 Secor Rd','New Orleans','Orleans','LA','70112','work','US', 0, 0),
(1,'Porto Cayo At Hawks Cay','4 Webbs Chapel Rd','Boulder','Boulder','CO','80303','work','US', 0, 0),
(1,'Pacific Grove Museum Ntrl Hist','524 Louisiana Ave Nw','San Leandro','Alameda','CA','94577','work','US', 0, 0),
(1,'Bender & Hatley Pc','185 Blackstone Bldge','Honolulu','Honolulu','HI','96817','work','US', 0, 0),
(1,'Di Cristina J & Son','170 Wyoming Ave','Burnsville','Dakota','MN','55337','work','US', 0, 0),
(1,'Green Goddess','4 10th St W','High Point','Guilford','NC','27263','work','US', 0, 0),
(1,'American Arts & Graphics','7 W Pinhook Rd','Lynbrook','Nassau','NY','11563','work','US', 0, 0),
(1,'Opryland Hotel','1 Commerce Way','Portland','Washington','OR','97224','work','US', 0, 0),
(1,'Marking Devices Pubg Co','64 Lakeview Ave','Beloit','Rock','WI','53511','work','US', 0, 0),
(1,'W Tc Industries Inc','3 Aspen St','Worcester','Worcester','MA','1602','work','US', 0, 0),
(1,'Whitehall Robbins Labs Divsn','32860 Sierra Rd','Miami','Miami-Dade','FL','33133','work','US', 0, 0),
(1,'Sampler','555 Main St','Erie','Erie','PA','16502','work','US', 0, 0),
(1,'Juno Chefs Incorporated','2 Se 3rd Ave','Mesquite','Dallas','TX','75149','work','US', 0, 0),
(1,'K Cs Cstm Mouldings Windows','5161 Dorsett Rd','Homestead','Miami-Dade','FL','33030','work','US', 0, 0),
(1,'Comfort Inn','55892 Jacksonville Rd','Owings Mills','Baltimore','MD','21117','work','US', 0, 0),
(1,'Jackson Shields Yeiser','7 Benton Dr','Honolulu','Honolulu','HI','96819','work','US', 0, 0),
(1,'Custom Engineering Inc','8 County Center Dr #647','Boston','Suffolk','MA','2210','work','US', 0, 0),
(1,'Bresler Eitel Framg Gllry Ltd','4646 Kaahumanu St','Hackensack','Bergen','NJ','7601','work','US', 0, 0),
(1,'Biltmore Investors Bank','52777 Leaders Heights Rd','Ontario','San Bernardino','CA','91761','work','US', 0, 0),
(1,'Desco Equipment Corp','72868 Blackington Ave','Oakland','Alameda','CA','94606','work','US', 0, 0),
(1,'Merlin Electric Co','9 Norristown Rd','Troy','Rensselaer','NY','12180','work','US', 0, 0),
(1,'Bailey Cntl Co Div Babcock','83 County Road 437 #8581','Clarks Summit','Lackawanna','PA','18411','work','US', 0, 0),
(1,'Ford Brothers Wholesale Inc','1 N Harlem Ave #9','Orange','Essex','NJ','7050','work','US', 0, 0),
(1,'Cambridge Inn','90131 J St','Pittstown','Hunterdon','NJ','8867','work','US', 0, 0),
(1,'Nelson Hawaiian Ltd','6 Gilson St','Bronx','Bronx','NY','10468','work','US', 0, 0),
(1,'Neland Travel Agency','65 W Maple Ave','Pearl City','Honolulu','HI','96782','work','US', 0, 0),
(1,'Honey Bee Breeding Genetics &','9387 Charcot Ave','Absecon','Atlantic','NJ','8201','work','US', 0, 0),
(1,'Wells Kravitz Schnitzer','30553 Washington Rd','Plainfield','Union','NJ','7062','work','US', 0, 0),
(1,'Prohab Rehabilitation Servs','481 W Lemon St','Middleboro','Plymouth','MA','2346','work','US', 0, 0),
(1,'Ninas Indian Grs & Videos','627 Walford Ave','Dallas','Dallas','TX','75227','work','US', 0, 0),
(1,'Moapa Valley Federal Credit Un','61 13 Stoneridge #835','Findlay','Hancock','OH','45840','work','US', 0, 0),
(1,'Kentucky Tennessee Clay Co','2409 Alabama Rd','Riverside','Riverside','CA','92501','work','US', 0, 0),
(1,'Admiral Party Rentals & Sales','8927 Vandever Ave','Waco','McLennan','TX','76707','work','US', 0, 0),
(1,'Panasystems','9 N College Ave #3','Milwaukee','Milwaukee','WI','53216','work','US', 0, 0),
(1,'Megibow & Edwards','4 Bloomfield Ave','Irving','Dallas','TX','75061','work','US', 0, 0),
(1,'Woodbridge Free Public Library','54169 N Main St','Massapequa','Nassau','NY','11758','work','US', 0, 0),
(1,'New York Life John Thune','92 Main St','Atlantic City','Atlantic','NJ','8401','work','US', 0, 0),
(1,'Alinabal Inc','72 Mannix Dr','Cincinnati','Hamilton','OH','45203','work','US', 0, 0),
(1,'Silver Bros Inc','8 Industry Ln','New York','New York','NY','10002','work','US', 0, 0),
(1,'Newtec Inc','1 Huntwood Ave','Phoenix','Maricopa','AZ','85017','work','US', 0, 0),
(1,'Creative Business Systems','55262 N French Rd','Indianapolis','Marion','IN','46240','work','US', 0, 0),
(1,'Dal Tile Corporation','422 E 21st St','Syracuse','Onondaga','NY','13214','work','US', 0, 0),
(1,'Edward S Katz','501 N 19th Ave','Cherry Hill','Camden','NJ','8002','work','US', 0, 0),
(1,'Oh My Goodknits Inc','455 N Main Ave','Garden City','Nassau','NY','11530','work','US', 0, 0),
(1,'Desert Sands Motel','2023 Greg St','Saint Paul','Ramsey','MN','55101','work','US', 0, 0),
(1,'Cummins Southern Plains Inc','63381 Jenks Ave','Philadelphia','Philadelphia','PA','19134','work','US', 0, 0),
(1,'Lehigh Furn Divsn Lehigh','6651 Municipal Rd','Houma','Terrebonne','LA','70360','work','US', 0, 0),
(1,'United Van Lines Agent','81 Norris Ave #525','Ronkonkoma','Suffolk','NY','11779','work','US', 0, 0),
(1,'Capitol Reporters','6916 W Main St','Sacramento','Sacramento','CA','95827','work','US', 0, 0),
(1,'Kwik Kopy Printing','9635 S Main St','Boise','Ada','ID','83704','work','US', 0, 0),
(1,'Centro Inc','17 Us Highway 111','Round Rock','Williamson','TX','78664','work','US', 0, 0),
(1,'Scat Enterprises','73 Saint Ann St #86','Reno','Washoe','NV','89502','work','US', 0, 0),
(1,'Serendiquity Bed & Breakfast','9745 W Main St','Randolph','Morris','NJ','7869','work','US', 0, 0),
(1,'Ray Carolyne Realty','84 Bloomfield Ave','Spartanburg','Spartanburg','SC','29301','work','US', 0, 0),
(1,'Chadds Ford Winery','229 N Forty Driv','New York','New York','NY','10011','work','US', 0, 0),
(1,'A R Packaging','2887 Knowlton St #5435','Berkeley','Alameda','CA','94710','work','US', 0, 0),
(1,'Corn Popper','523 Marquette Ave','Concord','Middlesex','MA','1742','work','US', 0, 0),
(1,'Birite Foodservice Distr','3717 Hamann Industrial Pky','San Francisco','San Francisco','CA','94104','work','US', 0, 0),
(1,'Anchorage Museum Of Hist & Art','3 State Route 35 S','Paramus','Bergen','NJ','7652','work','US', 0, 0),
(1,'Royal Pontiac Olds Inc','9 Murfreesboro Rd','Chicago','Cook','IL','60623','work','US', 0, 0),
(1,'Leonards Antiques Inc','6 S Broadway St','Cedar Grove','Essex','NJ','7009','work','US', 0, 0),
(1,'Meca','6 Harry L Dr #6327','Perrysburg','Wood','OH','43551','work','US', 0, 0),
(1,'Nercon Engineering & Mfg Inc','47939 Porter Ave','Gardena','Los Angeles','CA','90248','work','US', 0, 0),
(1,'Replica I','9 Wales Rd Ne #914','Homosassa','Citrus','FL','34448','work','US', 0, 0),
(1,'20 20 Printing Inc','195 13n N','Santa Clara','Santa Clara','CA','95054','work','US', 0, 0),
(1,'Publishers Group West','99 Tank Farm Rd','Hazleton','Luzerne','PA','18201','work','US', 0, 0),
(1,'Payne Blades & Wellborn Pa','98 University Dr','San Ramon','Contra Costa','CA','94583','work','US', 0, 0),
(1,'Coldwell Bnkr Wright Real Est','50 E Wacker Dr','Bridgewater','Somerset','NJ','8807','work','US', 0, 0),
(1,'Computer Repair Service','70 Euclid Ave #722','Bohemia','Suffolk','NY','11716','work','US', 0, 0),
(1,'Fleetwood Building Block Inc','326 E Main St #6496','Thousand Oaks','Ventura','CA','91362','work','US', 0, 0),
(1,'Colts Neck Medical Assocs Inc','406 Main St','Somerville','Somerset','NJ','8876','work','US', 0, 0),
(1,'New England Taxidermy','3 Elmwood Dr','Beaverton','Washington','OR','97005','work','US', 0, 0),
(1,'Eagle Software Inc','5384 Southwyck Blvd','Douglasville','Douglas','GA','30135','work','US', 0, 0),
(1,'Juvenile & Adult Super','97 Airport Loop Dr','Jacksonville','Duval','FL','32216','work','US', 0, 0),
(1,'Case Foundation Co','4252 N Washington Ave #9','Kennedale','Tarrant','TX','76060','work','US', 0, 0),
(1,'Eis Environmental Engrs Inc','42754 S Ash Ave','Buffalo','Erie','NY','14228','work','US', 0, 0),
(1,'Art Crafters','703 Beville Rd','Opa Locka','Miami-Dade','FL','33054','work','US', 0, 0),
(1,'Marriott Hotels Resorts Suites','5 Harrison Rd','New York','New York','NY','10038','work','US', 0, 0),
(1,'Remaco Inc','73 Southern Blvd','Philadelphia','Philadelphia','PA','19103','work','US', 0, 0),
(1,'Winship & Byrne','577 Parade St','South San Francisco','San Mateo','CA','94080','work','US', 0, 0),
(1,'Burton & Davis','70 Mechanic St','Northridge','Los Angeles','CA','91325','work','US', 0, 0),
(1,'Olympic Graphic Arts','4379 Highway 116','Philadelphia','Philadelphia','PA','19103','work','US', 0, 0),
(1,'Magnuson','55 Hawthorne Blvd','Lafayette','Lafayette','LA','70506','work','US', 0, 0),
(1,'A All American Travel Inc','7116 Western Ave','Dearborn','Wayne','MI','48126','work','US', 0, 0),
(1,'Polykote Inc','2026 N Plankinton Ave #3','Austin','Travis','TX','78754','work','US', 0, 0),
(1,'Jets Cybernetics','99586 Main St','Dallas','Dallas','TX','75207','work','US', 0, 0),
(1,'Metlab Testing Services','8739 Hudson St','Vashon','King','WA','98070','work','US', 0, 0),
(1,'Mcauley Mfg Co','2972 Lafayette Ave','Gardena','Los Angeles','CA','90248','work','US', 0, 0),
(1,'Defur Voran Hanley Radcliff','2140 Diamond Blvd','Rohnert Park','Sonoma','CA','94928','work','US', 0, 0),
(1,'Dill Dill Carr & Stonbraker Pc','93 Redmond Rd #492','Orlando','Orange','FL','32803','work','US', 0, 0),
(1,'Kleensteel','3989 Portage Tr','Escondido','San Diego','CA','92025','work','US', 0, 0),
(1,'Goulds Pumps Inc Slurry Pump','1 Midway Rd','Westborough','Worcester','MA','1581','work','US', 0, 0),
(1,'Kansas City Insurance Report','77132 Coon Rapids Blvd Nw','Conroe','Montgomery','TX','77301','work','US', 0, 0),
(1,'Berhanu International Foods','755 Harbor Way','Milwaukee','Milwaukee','WI','53226','work','US', 0, 0),
(1,'Roland Ashcroft','87 Sierra Rd','El Monte','Los Angeles','CA','91731','work','US', 0, 0),
(1,'Hispanic Magazine','7667 S Hulen St #42','Yonkers','Westchester','NY','10701','work','US', 0, 0),
(1,'Little Sheet Metal Co','75684 S Withlapopka Dr #32','Dallas','Dallas','TX','75227','work','US', 0, 0),
(1,'Evans Rule Company','38062 E Main St','New York','New York','NY','10048','work','US', 0, 0),
(1,'Tyee Productions Inc','3958 S Dupont Hwy #7','Ramsey','Bergen','NJ','7446','work','US', 0, 0),
(1,'Dunnells & Duvall','560 Civic Center Dr','Ann Arbor','Washtenaw','MI','48103','work','US', 0, 0),
(1,'Deltam Systems Inc','3270 Dequindre Rd','Deer Park','Suffolk','NY','11729','work','US', 0, 0),
(1,'Hammill Mfg Co','1 Garfield Ave #7','Canton','Stark','OH','44707','work','US', 0, 0),
(1,'Sams Corner Store','9122 Carpenter Ave','New Haven','New Haven','CT','6511','work','US', 0, 0),
(1,'Cape & Associates Real Estate','5 Little River Tpke','Wilmington','Middlesex','MA','1887','work','US', 0, 0),
(1,'Merrill Lynch','3 N Groesbeck Hwy','Toledo','Lucas','OH','43613','work','US', 0, 0),
(1,'Sentry Signs','433 Westminster Blvd #590','Roseville','Placer','CA','95661','work','US', 0, 0),
(1,'Professionals Unlimited','66697 Park Pl #3224','Riverton','Fremont','WY','82501','work','US', 0, 0),
(1,'Southern Steel Shelving Co','96263 Greenwood Pl','Warren','Knox','ME','4864','work','US', 0, 0),
(1,'Henry County Middle School','9 N 14th St','El Cajon','San Diego','CA','92020','work','US', 0, 0),
(1,'Edison Supply & Equipment Co','9 Vanowen St','College Station','Brazos','TX','77840','work','US', 0, 0),
(1,'Linguistic Systems Inc','506 S Hacienda Dr','Atlantic City','Atlantic','NJ','8401','work','US', 0, 0),
(1,'Peace Christian Center','3732 Sherman Ave','Bridgewater','Somerset','NJ','8807','work','US', 0, 0),
(1,'Double B Foods Inc','25657 Live Oak St','Brooklyn','Kings','NY','11226','work','US', 0, 0),
(1,'Alexander & Alexander Inc','4923 Carey Ave','Saint Louis','Saint Louis City','MO','63104','work','US', 0, 0),
(1,'Fairbanks Scales','3196 S Rider Trl','Stockton','San Joaquin','CA','95207','work','US', 0, 0),
(1,'Cali Sportswear Cutting Dept','3 Railway Ave #75','Little Falls','Passaic','NJ','7424','work','US', 0, 0),
(1,'Thompson Fabricating Co','67 E Chestnut Hill Rd','Seattle','King','WA','98133','work','US', 0, 0),
(1,'Century 21 Krall Real Estate','33 Lewis Rd #46','Burlington','Alamance','NC','27215','work','US', 0, 0),
(1,'Mid Contntl Rlty & Prop Mgmt','8100 Jacksonville Rd #7','Hays','Ellis','KS','67601','work','US', 0, 0),
(1,'Ace Signs Inc','7 W Wabansia Ave #227','Orlando','Orange','FL','32822','work','US', 0, 0),
(1,'Rodeway Inn','25 Minters Chapel Rd #9','Minneapolis','Hennepin','MN','55401','work','US', 0, 0),
(1,'Bonnet & Daughter','6882 Torresdale Ave','Columbia','Richland','SC','29201','work','US', 0, 0),
(1,'Oshins & Gibbons','985 E 6th Ave','Santa Rosa','Sonoma','CA','95407','work','US', 0, 0),
(1,'Price Business Services','7 West Ave #1','Palatine','Cook','IL','60067','work','US', 0, 0),
(1,'Super 8 Motel','669 Packerland Dr #1438','Denver','Denver','CO','80212','work','US', 0, 0),
(1,'John Wagner Associates','759 Eldora St','New Haven','New Haven','CT','6515','work','US', 0, 0),
(1,'Thrifty Oil Co','5 S Colorado Blvd #449','Bothell','Snohomish','WA','98021','work','US', 0, 0),
(1,'Larkfield Photo','944 Gaither Dr','Strongsville','Cuyahoga','OH','44136','work','US', 0, 0),
(1,'Silverman Planetarium','66552 Malone Rd','Plaistow','Rockingham','NH','3865','work','US', 0, 0),
(1,'J & F Lumber','77 Massillon Rd #822','Satellite Beach','Brevard','FL','32937','work','US', 0, 0),
(1,'Cleaning Station Inc','25346 New Rd','New York','New York','NY','10016','work','US', 0, 0),
(1,'Ames Stationers','60 Fillmore Ave','Huntington Beach','Orange','CA','92647','work','US', 0, 0),
(1,'Midas Muffler Shops','57 Haven Ave #90','Southfield','Oakland','MI','48075','work','US', 0, 0),
(1,'Seaboard Securities Inc','6538 E Pomona St #60','Indianapolis','Marion','IN','46222','work','US', 0, 0),
(1,'Development Authority','78112 Morris Ave','North Haven','New Haven','CT','6473','work','US', 0, 0),
(1,'Schott Fiber Optics Inc','96950 Hidden Ln','Aberdeen','Harford','MD','21001','work','US', 0, 0),
(1,'Stuart J Agins','3718 S Main St','New Orleans','Orleans','LA','70130','work','US', 0, 0),
(1,'Mitsumi Electronics Corp','9677 Commerce Dr','Richmond','Richmond City','VA','23219','work','US', 0, 0),
(1,'Italian Express Franchise Corp','5 Green Pond Rd #4','Southampton','Bucks','PA','18966','work','US', 0, 0),
(1,'American Council On Sci & Hlth','636 Commerce Dr #42','Shakopee','Scott','MN','55379','work','US', 0, 0),
(1,'Twiggs Abrams Blanchard','1950 5th Ave','Milwaukee','Milwaukee','WI','53209','work','US', 0, 0),
(1,'Maui Research & Technology Pk','61304 N French Rd','Somerset','Somerset','NJ','8873','work','US', 0, 0),
(1,'Bradley Nameplate Corp','87 Imperial Ct #79','Fargo','Cass','ND','58102','work','US', 0, 0),
(1,'Geonex Martel Inc','94 W Dodge Rd','Carson City','Carson City','NV','89701','work','US', 0, 0),
(1,'Sea Island Div Of Fstr Ind Inc','4 58th St #3519','Scottsdale','Maricopa','AZ','85254','work','US', 0, 0),
(1,'Lane Promotions','9648 S Main','Salisbury','Wicomico','MD','21801','work','US', 0, 0),
(1,'Stephen Kennerly Archts Inc Pc','7 S San Marcos Rd','New York','New York','NY','10004','work','US', 0, 0),
(1,'Business Systems Of Wis Inc','812 S Haven St','Amarillo','Randall','TX','79109','work','US', 0, 0),
(1,'Alabama Educational Tv Comm','45 2nd Ave #9759','Atlanta','Fulton','GA','30328','work','US', 0, 0),
(1,'Franz Inc','57254 Brickell Ave #372','Worcester','Worcester','MA','1602','work','US', 0, 0),
(1,'Plantation Restaurant','8977 Connecticut Ave Nw #3','Niles','Berrien','MI','49120','work','US', 0, 0),
(1,'Radio Communications Co','9 Waydell St','Fairfield','Essex','NJ','7004','work','US', 0, 0),
(1,'Dentalaw Divsn Hlth Care','43 Huey P Long Ave','Lafayette','Lafayette','LA','70508','work','US', 0, 0),
(1,'American Speedy Printing Ctrs','7563 Cornwall Rd #4462','Denver','Lancaster','PA','17517','work','US', 0, 0),
(1,'Jeanerette Middle School','70099 E North Ave','Arlington','Tarrant','TX','76013','work','US', 0, 0),
(1,'Wmmt Radio Station','26 Montgomery St','Atlanta','Fulton','GA','30328','work','US', 0, 0),
(1,'Colony Paints Sales Ofc & Plnt','13252 Lighthouse Ave','Cathedral City','Riverside','CA','92234','work','US', 0, 0),
(1,'Floral Expressions','206 Main St #2804','Lansing','Ingham','MI','48933','work','US', 0, 0),
(1,'Casco Services Inc','96541 W Central Blvd','Phoenix','Maricopa','AZ','85034','work','US', 0, 0),
(1,'Sidewinder Products Corp','8573 Lincoln Blvd','York','York','PA','17404','work','US', 0, 0),
(1,'General Foam Corporation','596 Santa Maria Ave #7913','Mesquite','Dallas','TX','75150','work','US', 0, 0),
(1,'Ikg Borden Divsn Harsco Corp','3829 Ventura Blvd','Butte','Silver Bow','MT','59701','work','US', 0, 0),
(1,'Anchor Computer Inc','13 S Hacienda Dr','Livingston','Essex','NJ','7039','work','US', 0, 0),
(1,'Sebring & Co','40 9th Ave Sw #91','Waterford','Oakland','MI','48329','work','US', 0, 0),
(1,'H A C Farm Lines Co Optv Assoc','2845 Boulder Crescent St','Cleveland','Cuyahoga','OH','44103','work','US', 0, 0),
(1,'Freehold Fence Co','2 S 15th St','Fort Worth','Tarrant','TX','76107','work','US', 0, 0),
(1,'Binswanger','4 Kohler Memorial Dr','Brooklyn','Kings','NY','11230','work','US', 0, 0),
(1,'Chilton Malting Co','1 Rancho Del Mar Shopping C','Providence','Providence','RI','2903','work','US', 0, 0),
(1,'In Travel Agency','64 Newman Springs Rd E','Brooklyn','Kings','NY','11219','work','US', 0, 0),
(1,'Newhart Foods Inc','48 Stratford Ave','Pomona','Los Angeles','CA','91768','work','US', 0, 0),
(1,'Courtyard By Marriott','80 Pittsford Victor Rd #9','Cleveland','Cuyahoga','OH','44103','work','US', 0, 0),
(1,'Seashore Supply Co Waretown','393 Lafayette Ave','Richmond','Richmond City','VA','23219','work','US', 0, 0),
(1,'Mayar Silk Inc','99 5th Ave #33','Trion','Chattooga','GA','30753','work','US', 0, 0),
(1,'National Medical Excess Corp','49 N Mays St','Broussard','Lafayette','LA','70518','work','US', 0, 0),
(1,'Stero Company','993 Washington Ave','Nutley','Essex','NJ','7110','work','US', 0, 0),
(1,'Insty Prints','3381 E 40th Ave','Passaic','Passaic','NJ','7055','work','US', 0, 0),
(1,'Glenridge Manor Mobile Home Pk','201 Ridgewood Rd','Moscow','Latah','ID','83843','work','US', 0, 0),
(1,'Circuit Solution Inc','39 Moccasin Dr','San Francisco','San Francisco','CA','94104','work','US', 0, 0),
(1,'Local Office','4 Carroll St','North Attleboro','Bristol','MA','2760','work','US', 0, 0),
(1,'Lee Kilkelly Paulson & Kabaker','9581 E Arapahoe Rd','Rochester','Oakland','MI','48307','work','US', 0, 0),
(1,'Black History Resource Center','8 Us Highway 22','Colorado Springs','El Paso','CO','80937','work','US', 0, 0),
(1,'Grant Family Health Center','94 Chase Rd','Hyattsville','Prince Georges','MD','20785','work','US', 0, 0),
(1,'Goeman Wood Products Inc','8139 I Hwy 10 #92','New Bedford','Bristol','MA','2745','work','US', 0, 0),
(1,'Earnhardt Printing','3387 Ryan Dr','Hanover','Anne Arundel','MD','21076','work','US', 0, 0),
(1,'H P G Industrys Inc','3125 Packer Ave #9851','Austin','Travis','TX','78753','work','US', 0, 0),
(1,'Bailey Transportation Prod Inc','347 Chestnut St','Peoria','Maricopa','AZ','85381','work','US', 0, 0),
(1,'Mcglynn Bliss Pc','8116 Mount Vernon Ave','Bucyrus','Crawford','OH','44820','work','US', 0, 0),
(1,'Mutual Fish Co','8772 Old County Rd #5410','Kent','King','WA','98032','work','US', 0, 0),
(1,'Advantage Martgage Company','73 W Barstow Ave','Arlington Heights','Cook','IL','60004','work','US', 0, 0),
(1,'Germer And Gertz Llp','61047 Mayfield Ave','Brooklyn','Kings','NY','11223','work','US', 0, 0),
(1,'Spence Law Offices','2139 Santa Rosa Ave','Orlando','Orange','FL','32801','work','US', 0, 0),
(1,'John Ortiz Nts Therapy Center','598 43rd St','Beverly Hills','Los Angeles','CA','90210','work','US', 0, 0),
(1,'Mike Uchrin Htg & Air Cond Inc','70295 Pioneer Ct','Brandon','Hillsborough','FL','33511','work','US', 0, 0),
(1,'Kbor 1600 Am','395 S 6th St #2','El Cajon','San Diego','CA','92020','work','US', 0, 0),
(1,'Quality Inn Northwest','9506 Edgemore Ave','Bladensburg','Prince Georges','MD','20710','work','US', 0, 0),
(1,'Wallace Church Assoc Inc','72119 S Walker Ave #63','Anaheim','Orange','CA','92801','work','US', 0, 0),
(1,'Can Tron','369 Latham St #500','Saint Louis','Saint Louis City','MO','63102','work','US', 0, 0),
(1,'Ravaal Enterprises Inc','3158 Runamuck Pl','Round Rock','Williamson','TX','78664','work','US', 0, 0),
(1,'Thompson Steel Company Inc','9 Plainsboro Rd #598','Greensboro','Guilford','NC','27409','work','US', 0, 0),
(1,'Womack & Galich','2215 Prosperity Dr','Lyndhurst','Bergen','NJ','7071','work','US', 0, 0),
(1,'Valerie & Company','1 S Pine St','Memphis','Shelby','TN','38112','work','US', 0, 0),
(1,'Gehring Pumps Inc','187 Market St','Atlanta','Fulton','GA','30342','work','US', 0, 0),
(1,'Spoor Behrins Campbell & Young','7061 N 2nd St','Burnsville','Dakota','MN','55337','work','US', 0, 0),
(1,'Ken Jeter Store Equipment Inc','10759 Main St','Scottsdale','Maricopa','AZ','85260','work','US', 0, 0),
(1,'Baird Kurtz & Dobson','82 Winsor St #54','Atlanta','Dekalb','GA','30340','work','US', 0, 0),
(1,'Mark Ii Imports Inc','7 S Beverly Dr','Fort Wayne','Allen','IN','46802','work','US', 0, 0),
(1,'White Sign Div Ctrl Equip Co','919 Wall Blvd','Meridian','Lauderdale','MS','39307','work','US', 0, 0),
(1,'M & M Store Fixtures Co Inc','89 20th St E #779','Sterling Heights','Macomb','MI','48310','work','US', 0, 0),
(1,'Judah Caster & Wheel Co','721 Interstate 45 S','Colorado Springs','El Paso','CO','80919','work','US', 0, 0),
(1,'Galaxy International Inc','3 Lawton St','New York','New York','NY','10013','work','US', 0, 0),
(1,'Sigma Corp Of America','38 Pleasant Hill Rd','Hayward','Alameda','CA','94545','work','US', 0, 0),
(1,'Students In Free Entrprs Natl','77 222 Dr','Oroville','Butte','CA','95965','work','US', 0, 0),
(1,'Del Charro Apartments','617 Nw 36th Ave','Brook Park','Cuyahoga','OH','44142','work','US', 0, 0),
(1,'Legal Search Inc','539 Coldwater Canyon Ave','Bloomfield','Essex','NJ','7003','work','US', 0, 0),
(1,'Service Supply Co Inc','735 Crawford Dr','Anchorage','Anchorage','AK','99501','work','US', 0, 0),
(1,'E T Balancing Co Inc','35433 Blake St #588','Gardena','Los Angeles','CA','90248','work','US', 0, 0),
(1,'Acqua Group','810 N La Brea Ave','King of Prussia','Montgomery','PA','19406','work','US', 0, 0),
(1,'Printing Images Corp','36 Enterprise St Se','Richland','Benton','WA','99352','work','US', 0, 0),
(1,'Roberts Supply Co Inc','8429 Miller Rd','Pelham','Westchester','NY','10803','work','US', 0, 0),
(1,'Vico Products Mfg Co','5 W 7th St','Parkville','Baltimore','MD','21234','work','US', 0, 0),
(1,'J M Custom Design Millwork','2 Flynn Rd','Hicksville','Nassau','NY','11801','work','US', 0, 0),
(1,'Farrell & Johnson Office Equip','2094 Ne 36th Ave','Worcester','Worcester','MA','1603','work','US', 0, 0),
(1,'Millers Market & Deli','649 Tulane Ave','Tulsa','Tulsa','OK','74105','work','US', 0, 0),
(1,'Holiday Inn Naperville','2094 Montour Blvd','Muskegon','Muskegon','MI','49442','work','US', 0, 0),
(1,'Dock Seal Specialty','8590 Lake Lizzie Dr','Bowling Green','Wood','OH','43402','work','US', 0, 0),
(1,'Five Star Limousines Of Tx Inc','87895 Concord Rd','La Mesa','San Diego','CA','91942','work','US', 0, 0),
(1,'Toledo Iv Care','2759 Livingston Ave','Memphis','Shelby','TN','38118','work','US', 0, 0),
(1,'Cangro Transmission Co','17 Jersey Ave','Englewood','Arapahoe','CO','80110','work','US', 0, 0),
(1,'Sat Poly Inc','2 W Grand Ave','Memphis','Shelby','TN','38112','work','US', 0, 0),
(1,'Midwest Contracting & Mfg Inc','18 Coronado Ave #563','Pasadena','Los Angeles','CA','91106','work','US', 0, 0),
(1,'Print Doctor','72 Beechwood Ter','Chicago','Cook','IL','60657','work','US', 0, 0),
(1,'Nordic Group Inc','92 Broadway','Astoria','Queens','NY','11103','work','US', 0, 0),
(1,'Jackson Millwork Co','39 Franklin Ave','Richland','Benton','WA','99352','work','US', 0, 0),
(1,'Harris Corporation','4 Iwaena St','Baltimore','Baltimore City','MD','21202','work','US', 0, 0),
(1,'United Cerebral Palsy Of Ne Pa','32820 Corkwood Rd','Newark','Essex','NJ','7104','work','US', 0, 0),
(1,'One Day Surgery Center Inc','34 Raritan Center Pky','Bellflower','Los Angeles','CA','90706','work','US', 0, 0),
(1,'Calaveras Prospect','6201 S Nevada Ave','Toms River','Ocean','NJ','8755','work','US', 0, 0),
(1,'Central Die Casting Mfg Co Inc','1610 14th St Nw','Newport News','Newport News City','VA','23608','work','US', 0, 0),
(1,'Centerline Engineering','86350 Roszel Rd','Phoenix','Maricopa','AZ','85012','work','US', 0, 0),
(1,'Targan & Kievit Pa','1644 Clove Rd','Miami','Miami-Dade','FL','33155','work','US', 0, 0),
(1,'Riley Riper Hollin & Colagreco','9 W Central Ave','Phoenix','Maricopa','AZ','85013','work','US', 0, 0),
(1,'Water Office','10276 Brooks St','San Francisco','San Francisco','CA','94105','work','US', 0, 0),
(1,'Armon Communications','9 State Highway 57 #22','Jersey City','Hudson','NJ','7306','work','US', 0, 0),
(1,'Jacobs & Gerber Inc','4 S Washington Ave','San Bernardino','San Bernardino','CA','92410','work','US', 0, 0),
(1,'Forest Fire Laboratory','25 Se 176th Pl','Cambridge','Middlesex','MA','2138','work','US', 0, 0),
(1,'Wheaton Plastic Products','22 Spruce St #595','Gardena','Los Angeles','CA','90248','work','US', 0, 0),
(1,'Reese Plastics','2 W Beverly Blvd','Harrisburg','Dauphin','PA','17110','work','US', 0, 0),
(1,'Nazette Marner Good Wendt','72 Southern Blvd','Mesa','Maricopa','AZ','85204','work','US', 0, 0),
(1,'Levinson Axelrod Wheaton','1 Washington St','Lake Worth','Palm Beach','FL','33461','work','US', 0, 0),
(1,'Portland Central Thriftlodge','9 Tower Ave','Burlington','Boone','KY','41005','work','US', 0, 0),
(1,'Ulbrich Trucking','278 Bayview Ave','Milan','Monroe','MI','48160','work','US', 0, 0),
(1,'Tipiak Inc','80312 W 32nd St','Conroe','Montgomery','TX','77301','work','US', 0, 0),
(1,'Saint George Well Drilling','82 Us Highway 46','Clifton','Passaic','NJ','7011','work','US', 0, 0),
(1,'Accurel Systems Intrntl Corp','19 Amboy Ave','Miami','Miami-Dade','FL','33142','work','US', 0, 0),
(1,'Santa Cruz Community Internet','63 Smith Ln #8343','Moss','Clay','TN','38575','work','US', 0, 0),
(1,'Gersh & Danielson','11360 S Halsted St','Santa Ana','Orange','CA','92705','work','US', 0, 0),
(1,'Wheatley Trucking Company','2500 Pringle Rd Se #508','Hatfield','Montgomery','PA','19440','work','US', 0, 0),
(1,'Systems Graph Inc Ab Dick Dlr','65 Mountain View Dr','Whippany','Morris','NJ','7981','work','US', 0, 0),
(1,'John Hancock Mutl Life Ins Co','1 N San Saba','Erie','Erie','PA','16501','work','US', 0, 0),
(1,'History Division Of State','51120 State Route 18','Salt Lake City','Salt Lake','UT','84115','work','US', 0, 0),
(1,'Intermed Inc','4119 Metropolitan Dr','Los Angeles','Los Angeles','CA','90021','work','US', 0, 0),
(1,'Bank Of New York','2167 Sierra Rd','East Lansing','Ingham','MI','48823','work','US', 0, 0),
(1,'Sportmaster Intrnatl','6 Sunrise Ave','Utica','Oneida','NY','13501','work','US', 0, 0),
(1,'W W John Holden Inc','55713 Lake City Hwy','South Bend','St Joseph','IN','46601','work','US', 0, 0),
(1,'Maccani & Delp','75698 N Fiesta Blvd','Orlando','Orange','FL','32806','work','US', 0, 0),
(1,'Amazonia Film Project','88 Sw 28th Ter','Harrison','Hudson','NJ','7029','work','US', 0, 0),
(1,'Water & Sewer Department','7 Flowers Rd #403','Trenton','Mercer','NJ','8611','work','US', 0, 0),
(1,'Switchcraft Inc','4 Nw 12th St #3849','Madison','Dane','WI','53717','work','US', 0, 0),
(1,'C W D C Metal Fabricators','2 A Kelley Dr','Katonah','Westchester','NY','10536','work','US', 0, 0),
(1,'Ceramic Tile Sales Inc','62260 Park Stre','Monroe Township','Middlesex','NJ','8831','work','US', 0, 0),
(1,'Maiden Craft Inc','3424 29th St Se','Kerrville','Kerr','TX','78028','work','US', 0, 0),
(1,'Carriage House Cllsn Rpr Inc','35 E Main St #43','Elk Grove Village','Cook','IL','60007','work','US', 0, 0),
(1,'Video Workshop','7163 W Clark Rd','Freehold','Monmouth','NJ','7728','work','US', 0, 0),
(1,'Fresno Tile Center Inc','21575 S Apple Creek Rd','Omaha','Douglas','NE','68124','work','US', 0, 0),
(1,'Versatile Sash & Woodwork','747 Leonis Blvd','Annandale','Fairfax','VA','22003','work','US', 0, 0),
(1,'Warner Electric Brk & Cltch Co','13 Gunnison St','Plano','Collin','TX','75075','work','US', 0, 0),
(1,'New York Public Library','18 3rd Ave','New York','New York','NY','10016','work','US', 0, 0),
(1,'United Oil Co Inc','177 S Rider Trl #52','Crystal River','Citrus','FL','34429','work','US', 0, 0),
(1,'Irving Foot Center','2 W Mount Royal Ave','Fortville','Hancock','IN','46040','work','US', 0, 0),
(1,'Acme Supply Co','1953 Telegraph Rd','Saint Joseph','Buchanan','MO','64504','work','US', 0, 0),
(1,'Mcgraths Seafood','5 E Truman Rd','Abilene','Taylor','TX','79602','work','US', 0, 0),
(1,'North Central Fl Sfty Cncl','2184 Worth St','Hayward','Alameda','CA','94545','work','US', 0, 0),
(1,'Fiorucci Foods Usa Inc','50126 N Plankinton Ave','Longwood','Seminole','FL','32750','work','US', 0, 0),
(1,'Sign All','38773 Gravois Ave','Cheyenne','Laramie','WY','82001','work','US', 0, 0),
(1,'Sammys Steak Den','16452 Greenwich St','Garden City','Nassau','NY','11530','work','US', 0, 0),
(1,'Morgan Custom Homes','20113 4th Ave E','Kearny','Hudson','NJ','7032','work','US', 0, 0),
(1,'Olsen Payne & Company','6 Ridgewood Center Dr','Old Forge','Lackawanna','PA','18518','work','US', 0, 0),
(1,'Cowan & Kelly','469 Outwater Ln','San Diego','San Diego','CA','92126','work','US', 0, 0),
(1,'Icn Pharmaceuticals Inc','3338 A Lockport Pl #6','Margate City','Atlantic','NJ','8402','work','US', 0, 0),
(1,'New England Sec Equip Co Inc','9 Hwy','Providence','Providence','RI','2906','work','US', 0, 0),
(1,'Atc Contracting','5 Washington St #1','Roseville','Placer','CA','95678','work','US', 0, 0),
(1,'Kwikprint','9 Front St','Washington','District of Columbia','DC','20001','work','US', 0, 0),
(1,'Buergi & Madden Scale','1933 Packer Ave #2','Novato','Marin','CA','94945','work','US', 0, 0),
(1,'Inner Label','67 Rv Cent','Boise','Ada','ID','83709','work','US', 0, 0),
(1,'Hermar Inc','2 Sw Nyberg Rd','Elkhart','Elkhart','IN','46514','work','US', 0, 0),
(1,'Simonton Howe & Schneider Pc','89992 E 15th St','Alliance','Box Butte','NE','69301','work','US', 0, 0),
(1,'Warehouse Office & Paper Prod','61556 W 20th Ave','Seattle','King','WA','98104','work','US', 0, 0),
(1,'Affiliated With Travelodge','63 E Aurora Dr','Orlando','Orange','FL','32804','work','US', 0, 0);

DELETE FROM CUSTOMER;
INSERT INTO customer (pkey, active, password, fname, lname, email, note, createDate, modDate) VALUES (1, 1, "hello pass", "hello name", "lname", "email", "note", 0,0);

-- Sample select
select address.* from (SELECT docid FROM address_search where address_search match "packer") LEFT JOIN address ON docid=pkey;
SELECT pkey, c.fname AS name, c.fname AS phone FROM (SELECT docid FROM customer_search WHERE customer_search MATCH "hello") LEFT JOIN customer AS c ON docid=c.pkey;


DELETE FROM address;
SELECT count(*) FROM address_search;

vacuum;