<reponame>Schneidershades/SIT-Consulting-Bionic-HMO-Application<gh_stars>0
CREATE TABLE hmos(
  id VARCHAR(100), 
  hmo_code VARCHAR(100), 
  hmo_name VARCHAR(100), 
  hmo_address VARCHAR(100), 
  hmo_contact VARCHAR(100), 
  hmo_region VARCHAR(100)
);

INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '1', '1', 'HYGEIA HMO LIMITED', 'Bank of Industry Building (BOI)', 
    '8120910005', 'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '2', '2', 'TOTAL HEALTH TRUST LIMITED', 
    '2 Marconi Road', '014482105', 
    ' 014607560 07080687600'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '3', '3', 'CLEARLINE INTERNATIONAL LIMITED', 
    '16 Oyefeso Avenue', '8052408604', 
    'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '4', '4', 'HEALTHCARE INTERNATIONAL LIMITED', 
    'Lagos Office: 308A Murtala Mohammed Way', 
    ' Yaba', ' Lagos'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '5', '5', 'Medi Plan Health Care Limited', 
    'Plot 32b', ' Admiralty Way', ' Lekki Phase I'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '6', '6', 'MULTI SHIELD NIGERIA LIMITED', 
    '322', ' Ikorodu Road', '8053223090'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '7', '7', 'UNITED HEALTHCARE INTERNATIONAL LTD', 
    '7', ' Jaba Close. off Dunukofia street', 
    ' Opp. FCDA Minister?s Gate Area 11'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '8', '8', 'PREMIUM HEALTH LTD', '31B', 
    ' Itafaji Road', ' Dolphin Estate'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '9', '10', 'Ronsberger Nigeria Limited', 
    'No. 30 Ubiaja Street', ' Garki', 
    ' Abuja.'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '10', '11', 'INTERNATIONAL HEALTH MANAGEMENT SERVICES LIMITED', 
    '2', ' Joseph Street', ' Off Broad Street'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '11', '12', 'CAPEX EXPATCARE LIMITED', 
    'Emmanuel Plaza', ' 23B Fatai Atere Way', 
    '08055890010'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '12', '13', 'SONGHAI HEALTH TRUST LTD.', 
    'Ground Floor', ' Nigeria Re-Insurance Building Beside Unity Bank', 
    ' Plot 784A Herbert Macaulay Way'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '13', '14', 'INTEGRATED HEALTHCARE LTD.', 
    '12 Jos Street', ' Area 3', ' Garki'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '14', '15', 'PREMIER MEDICAid LTD.', 
    'UBN Building', 'Steve Auta', 'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '15', '16', 'MANAGED HEALTHCARE SERVICES LTD.', 
    'Lagos Office: 16 Obokun Street', 
    ' Off Coker Road', ' Oshodi Lagos.'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '16', '17', 'PRINCETON HEALTH GROUP', 
    '25', ' Mogaji-Are Road Opposite D-Rovans Hotel', 
    '8034306380'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '17', '18', 'MAAYOIT HEALTHCARE LTD.', 
    '1 Iloffa Road', ' G.R.A.', '8058026841'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '18', '19', 'Wise Health Services Limited', 
    '27 Addis Ababa Crescent', ' Wuse Zone 4', 
    ' Abuja.'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '19', '20', 'WETLANDS HEALTH SERVICES LTD.', 
    'Plot 280B Danjuma Drive', '8055026610', 
    'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '20', '21', 'VENUS�MEDICARE LTD.', 
    '11Lagtang Close', ' Area 3', 
    '08087339159'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '21', '22', 'DEFENCE HEALTH MAINTENANCE LTD.', 
    'Plot 1323', ' Adesoji Aderemi Street', 
    '08075801389'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '22', '23', 'UNITED COMPREHENSIVE HEALTH MANAGERS LTD.', 
    'Plot C1', ' Rumuogba', '8033419470'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '23', '24', 'HEALTHCARE SECURITY LTD.', 
    '3rd Floor', ' Unity Kapital Plc Building', 
    '8033148050'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '24', '26', 'ROYAL HEALTH MAINTENANCE SERVICES', 
    '12 Cause way/24 Wetheral road', 
    ' Owerri.', '8037956689'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '25', '28', 'ZUMA HEALTH TRUST', 'Block 6 Flat 7', 
    ' Abak Close', '7063650092'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '26', '29', 'MARKFEMA NIGERIA LIMITED', 
    '4A Gurara (Lumsar) Street', ' Ibrahim Abacha Estate', 
    ' Zone 4'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '27', '30', 'PREPAid MEDICARE SERVICES LTD.', 
    '1 Bangui Street', '7027861384', 
    'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '28', '33', 'KBL HEALTHCARE LIMITED', 
    '371', ' Borno Way', '01-7450657'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '29', '34', 'STERLING HEALTH MANAGED CARE SERVICES LIMITED', 
    'Valley View Plaza', '7069728007', 
    'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '30', '35', 'HEALTH PARTNERS LIMITED', 
    '23 Ribadu Road', '8066248822', 
    'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '31', '36', 'PRECIOUS HEALTHCARE LIMITED', 
    'No. 8 Lungi Street Off Cairo', 
    '8085556471', 'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '32', '39', 'OCEANIC HEALTH MANAGEMENT LIMITED', 
    'Oceanic Bank NAFCON House Branch', 
    ' 264', ' Murtala Muhammed Way'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '33', '41', 'WELLNESS HEALTH MANAGEMENT SERVICES LTD', 
    'Head quarters/Lagos hmo_regional Office', 
    '70093556377', 'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '34', '43', 'GREENBAY HEALTHCARE SERVICES LTD', 
    'Suite A1', ' Kuriftu Plaza', 
    '7042328818'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '35', '44', 'MEDEXIA Ltd', '221 Ikorodu Road', 
    '8057970069', 'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '36', '46', 'ROYAL EXCHANGE HEALTHCARE LTD', 
    '13 Oke Olowogbowo Street', '8053775743', 
    'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '37', '48', 'MARINA MEDICAL SERV. HMO LTD', 
    '24 Montgomery Road', '7023028780', 
    'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '38', '51', 'NONSUCH MEDICARE LTD', 
    'Wema Bank Plaza', '8034080055', 
    'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '39', '54', 'SALUS TRUST GTE LTD', 
    'Catholic Secretariat of Nigeria', 
    '01-2636670', 'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '40', '57', 'PROHEALTH HMO LTD', '62 Lobito Crescent', 
    '8062691967', 'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '41', '59', 'MANSARD HEALTH PLAN NIGERIA LTD', 
    '18A Dapo Solanke Close', '8025144905', 
    'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '42', '60', 'GNI HEALTHCARE NIGERIA LTD', 
    'Plot 32 Western Avenue', '8033524202', 
    'Zonal- SW'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '43', '61', 'ULTIMATE HEALTH MANAGEMENT SERVICES LTD', 
    'Wema Bank Building 4th Floor', 
    '8060665572', 'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '44', '63', 'AVON HEALTHCARE LIMITED', 
    '29 Rumens Road', '01-2779800', 
    'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '45', '64', 'REGENIX HEALTH SERVICES LIMITED', 
    'Kieni Plaza', '80374762540', 'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '46', '65', 'REDCARE HEALTH SERVICE LIMITED', 
    '22 Coker Road', '7098767034', 'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '47', '66', 'HARRY HEALTH INTEGRATED SERVICES LIMITED', 
    '10 Dutse Street', ' War College', 
    '8039113311'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '48', '67', 'WELL HEALTH NETWORK LIMITED', 
    '15 Ibusa Avenue', ' Independent Layout', 
    ' Enugu'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '49', '68', 'BUPAR HEALTHCARE LIMITED', 
    'Plot 102', ' Isheri Road', ' KOTCO House'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '50', '69', 'IVES MEDICARE', '4 Mojidi Street', 
    ' Off Toyin Street', '08056374823'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '51', '70', 'LIFECARE PARTNERS LIMITED', 
    '123A Bisi Obadina Street', 'Omole Phase1', 
    ' Ikeja.'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '52', '71', 'DOMA HEALTHCARE LTD', 
    'Suite 9-12', ' 2nd Floor', '8035053690'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '53', '72', 'Allied HMO Ltd', '1', 
    ' Alhaji Animashaun Street Ajeigbe Bus Stop', 
    '8081761429'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '54', '73', 'POLICE HEALTH MAINTENANCE LIMITED', 
    '21', ' Kainji Crescent', '7026305673'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '55', '74', 'NOVO HEALTH AFRICA LTD', 
    '1', ' Adekola Balogun Street', 
    '8174602236'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '56', '75', 'MH HEALTHCARE LTD', '6A Alegbe Close', 
    '8060426239', 'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '57', '76', 'ANCHOR HMO INTERNATIONAL COMPANY LTD', 
    'Goldcrest Mall Building', '07080601192', 
    ' 08031230306'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '58', '77', 'METROHEALTH HMO LIMITED', 
    '14th Floor', ' St. Nicholas House', 
    ' 26 Catholic Mission Street'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '59', '78', 'GREENFIELD HEALTH MANAGEMENT LTD.', 
    'Headquarters (Enugu)', '', 'NATIONAL'
  );
INSERT INTO hmos(
  id, hmo_code, hmo_name, hmo_address, 
  hmo_contact, hmo_region
) 
VALUES 
  (
    '60', '79', 'LIFE WORTH MEDICARE LTD.', 
    '', '', 'State-Lagos'
  );
