CREATE TABLE IF NOT EXISTS hospitals (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255) NOT NULL UNIQUE,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT IGNORE INTO hospitals (name) VALUES
('Johns Hopkins Hospital'),
('Massachusetts General Hospital'),
('Cleveland Clinic'),
('Mayo Clinic'),
('UCLA Medical Center'),
('NewYork-Presbyterian Hospital'),
('Brigham and Women''s Hospital'),
('UCSF Medical Center'),
('Mount Sinai Hospital'),
('Cedars-Sinai Medical Center'),
('Houston Methodist Hospital'),
('Northwestern Memorial Hospital'),
('Stanford Health Care'),
('University of Washington Medical Center'),
('Duke University Hospital'),
('University of Michigan Hospitals'),
('NYU Langone Health'),
('Beth Israel Deaconess Medical Center'),
('Rush University Medical Center'),
('Yale New Haven Hospital'),
('Keck Hospital of USC'),
('Emory University Hospital'),
('Barnes-Jewish Hospital'),
('Vanderbilt University Medical Center'),
('Thomas Jefferson University Hospital'),
('Penn Presbyterian Medical Center'),
('Ochsner Medical Center'),
('Froedtert Hospital'),
('Baylor University Medical Center'),
('Intermountain Medical Center');
