DROP TABLE IF EXISTS `ma_Bank`;

CREATE TABLE IF NOT EXISTS `ma_Bank` (
  `routingNumber` varchar(32) NOT NULL,
  `name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` char(2) NOT NULL,
  `zip` varchar(10) NOT NULL,
  `phone` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `ma_Bank` ADD PRIMARY KEY (`routingNumber`);

--
-- data source is http://www.checkcomposer.com/frmbanksearch.aspx
--

INSERT IGNORE INTO `ma_Bank` (`name`, `address`, `city`, `state`, `zip`, `phone`, `routingNumber`) VALUES
('FEDERAL RESERVE BANK', '1000 PEACHTREE ST N.E.', 'ATLANTA', 'GA', '30309', '(866)234-5681', '011000015'),
('STATE STREET BANK AND TRUST COMPANY', 'JAB2NW', 'N. QUINCY', 'MA', '02171', '(617)664-2400', '011000028'),
('BANK OF AMERICA, N.A.', '8001 VILLA PARK DRIVE', 'HENRICO', 'VA', '23228', '(800)446-0135', '011000138'),
('BANK OF AMERICA N.A', 'PO BOX 27025', 'RICHMOND', 'VA', '23261', '(800)446-0135', '011000206'),
('BANK OF AMERICA N.A', 'PO BOX 27025', 'RICHMOND', 'VA', '23261', '(800)446-0135', '011000390'),
('FEDERAL HOME LOAN BK BOST', '9TH FLOOR', 'BOSTON', 'MA', '02199', '(617)292-9790', '011000536'),
('BANK OF NEW YORK MELLON', '500 ROSS ST., 154-0960', 'PITTSBURGH', 'PA', '15262', '(412)236-3338', '011001234'),
('ONEUNITED BANK', 'SUITE 600', 'BOSTON', 'MA', '02110', '(877)663-8648', '011001276'),
('RBS CITIZENS, NATIONAL ASSOCIATION', '1 CITIZENS DRIVE', 'RIVERSIDE', 'RI', '02915', '(800)883-4224', '011001331'),
('THE FIRST NATIONAL BANK OF IPSWICH', '625 GEORGE WASHINGTON HWY', 'LINCOLN', 'RI', '02865', '(401)574-1920', '011001726'),
('BANK OF AMERICA, N.A.', 'PO BOX 27025', 'RICHMOND', 'VA', '23261', '(800)446-0135', '011001742'),
('FIDUCIARY TRUST CO', 'CASH MGMT', 'BOSTON', 'MA', '02205', '(617)292-6747', '011001881'),
('CATHAY BANK', 'RS-14', 'ROSEMEAD', 'CA', '91770', '(626)582-7338', '122203950'),
('BOSTON PRIVATE BK + TR CO', 'ATTN: ACH ORPERATIONS', 'BOSTON', 'MA', '02109', '(617)912-4231', '011002343'),
('EASTERN BANK', '195 MARKET STREET', 'LYNN', 'MA', '01901', '(800)327-8376', '011002550'),
('COMMERCE BANK & TRUST CO', '386 MAIN ST', 'WORCESTER', 'MA', '01615', '(508)797-6923', '011002725'),
('EAST WEST BANK', '9300 FLAIR DRIVE, 4TH FLOOR', 'EL MONTE', 'CA', '91731', '(626)371-8561', '011002877'),
('SANTANDER', 'MAIL CODE 10-6438-AH5', 'READING', 'PA', '19612', '(610)463-9182', '011075150'),
('SANTANDER BANK, N.A.', '601 PENN STREET', 'READING', 'PA', '19601', '(877)768-2265', '011075202'),
('FRB BOSTON HUMAN RESOURCES', '1000 PEACHTREE STREET NE', 'ATLANTA', 'GA', '30309', '(866)234-5681', '011099071'),
('FRB BOSTON ACCOUNTING DEPT.', '1000 PEACHTREE STREET NE', 'ATLANTA', 'GA', '30309', '(866)234-5681', '011099660'),
('BANK OF AMERICA N.A.', 'PO BOX 27025', 'RICHMOND', 'VA', '23261', '(800)446-0135', '011100012'),
('WELLS FARGO BANK', 'MAC N9301-041', 'MINNEAPOLIS', 'MN', '55479', '(800)745-2426', '011100106'),
('BANK OF AMERICA N.A', 'P.O. BOX 27025', 'RICHMOND', 'VA', '23261', '(800)446-0135', '011100805'),
('BANK OF AMERICA N.A.', 'P.O. BOX 27025', 'RICHMOND', 'VA', '23261', '(800)446-0135', '011100892'),
('BANK OF AMERICA N.A.', 'P.O. BOX 27025', 'RICHMOND', 'VA', '23261', '(800)446-0135', '011100915'),
('BANK OF AMERICA N.A.', 'P.O. BOX 27025', 'RICHMOND', 'VA', '23261', '(800)446-0135', '011101529'),
('WEBSTER BANK', '436 SLATER RD', 'NEW BRITAIN', 'CT', '06053', '(860)612-6522', '011101613'),
('BANK OF AMERICA N.A.', 'PO BOX 27025', 'RICHMOND', 'VA', '23261', '(800)446-0135', '011101752'),
('CITIZENS NATIONAL BANK', '182 MAIN ST', 'PUTMAN', 'CT', '06260', '(860)928-7921', '011102133'),
('FIRST NAT BANK OF SUFFIELD', '30 BRIDGE STREET', 'SUFFIELD', 'CT', '06078', '(860)668-3950', '011102353'),
('UNION SAVINGS BANK', '225 MAIN ST', 'DANBURY', 'CT', '06810', '(203)830-4200', '011102502'),
('SALISBURY BANK & TRUST CO', '100 MAIN STREET', 'CANAAN', 'CT', '06018', '(860)435-9801', '011102612'),
('NATIONAL IRON BANK', 'PO BOX 565', 'SALISBURY', 'CT', '06068', '(860)435-2581', '011102638'),
('SALISBURY BANK & TRUST CO.', '100 MAIN STREET', 'CANAAN', 'CT', '06018', '(860)435-9801', '011102612'),
('BANK OF AMERICA N.A.', 'PO BOX 27025', 'RICHMOND', 'VA', '23261', '(800)446-0135', '011103080'),
('TD BANK NA', 'P.O. BOX 1377', 'LEWISTON', 'ME', '04240', '(877)898-7821', '011103093'),
('JEWETT CITY SAVINGS BANK', '135 DARLING DR', 'AVON', 'CT', '06001', '(860)376-4444', '011103129'),
('BANK OF AMERICA N.A.', 'PO BOX 27025', 'RICHMOND', 'VA', '23261', '(800)446-0135', '011104047'),
('WEBSTER BANK', '436 SLATER RD', 'NEW BRITAIN', 'CT', '06053', '(860)612-6522', '011104050'),
('PEOPLES BANK', '850 MAIN STREET', 'BRIDGEPORT', 'CT', '06601', '(203)338-7171', '011104131'),
('FIRST NIAGARA BANK, NA', 'P.O. BOX 886', 'LOCKPORT', 'NY', '14095', '(800)421-0004', '011104173'),
('PEOPLES BANK', '850 MAIN STREET', 'BRIDGEPORT', 'CT', '06601', '(203)338-7171', '011104199'),
('WEBSTER BANK', '436 SLATER RD', 'NEW BRITAIN', 'CT', '06053', '(860)612-6522', '011104209'),
('SAVINGS INSTITUTE', '803 MAIN ST', 'WILLIMANTIC', 'CT', '06226', '(860)456-6565', '211174181'),
('WEBSTER BANK N.A', '436 SLATER ROAD', 'NEW BRITAIN', 'CT', '06053', '(860)612-6522', '211170101'),
('PRIME BANK', '7 OLD TAVERN ROAD', 'ORANGE', 'CT', '06477', '(203)799-1299', '011104335'),
('SIMSBURY BANK & TRUST', '86 HOPEMEADOW ST', 'WEATOGUE', 'CT', '06089', '(860)651-2097', '011104351'),
('RBS CITIZENS, NATIONAL ASSOCIATION', '1 CITIZENS DRIVE', 'RIVERSIDE', 'RI', '02915', '(800)883-4224', '011110552'),
('BANKERS'' BANK NORTHEAST', '43 WESTERN BOULEVARD', 'GLASTONBURY', 'CT', '06033', '(860)266-2359', '011110617');

