jcrow/schema.sql

## schema.sql
-- phpMyAdmin SQL Dump
-- version 4.6.5.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 12, 2017 at 06:39 AM
-- Server version: 10.1.21-MariaDB
-- PHP Version: 5.6.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `kongfinger`
--

-- --------------------------------------------------------

--
-- Table structure for table `doc`
--

CREATE TABLE `doc` (
  `id` int(11) NOT NULL,
  `url` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `doc_2_term`
--

CREATE TABLE `doc_2_term` (
  `docid` int(11) NOT NULL,
  `termid` int(11) NOT NULL,
  `freq` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `email`
--

CREATE TABLE `email` (
  `id` int(11) NOT NULL,
  `email` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `email_2_terms`
--

CREATE TABLE `email_2_terms` (
  `email_id` int(11) NOT NULL,
  `term_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `schools`
--

CREATE TABLE `schools` (
  `id` int(11) NOT NULL,
  `school` varchar(50) NOT NULL,
  `url` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `schools`
--

INSERT INTO `schools` (`id`, `school`, `url`) VALUES
(1, 'Wayne State College', 'www.wsc.edu\r'),
(2, 'Appalachian School of Law', 'www.asl.edu\r'),
(3, 'Bucknell University', 'www.bucknell.edu\r'),
(4, 'South Texas Vocational Technical Institute - McAll', 'www.stvt.edu\r'),
(5, 'Career College of Northern Nevada', 'www.ccnn.edu\r'),
(6, 'Capitol Technology University', 'www.CapTechU.edu\r'),
(7, 'Specs Howard School of Media Arts', 'specshoward.edu\r'),
(8, 'Western Pennsylvania Hospital', 'www.wphs.org/westpenhospital.htm\r'),
(9, 'Vatterott College - Berkeley', 'www.vatterott-college.edu\r'),
(10, 'Great Lakes Institute of Technology', 'www.glit.edu\r'),
(11, '\"DLP Conemaugh Memorial Medical Center', '211802\r'),
(12, 'Keystone Technical Institute', 'www.Acadcampus.com\r'),
(13, 'The University of Tennessee - Martin', 'www.utm.edu\r'),
(14, 'American Trade School', 'www.stltrades.com\r'),
(15, 'Oakbridge Academy of Arts', 'oaa.edu\r'),
(16, 'Albertus Magnus College', 'www.albertus.edu\r'),
(17, 'Pittsburgh Institute of Mortuary Science Inc', 'www.pims.edu\r'),
(18, 'Houston Graduate School of Theology', 'www.hgst.edu\r'),
(19, 'Panache Academy of Beauty', '475413\r'),
(20, 'International Business School - Denton', 'www.ibsdenton.com\r'),
(21, 'Lancaster Bible College', 'www.lbc.edu\r'),
(22, 'Bishop State Community College', 'www.bishop.edu\r'),
(23, 'Rider University', 'www.rider.edu\r'),
(24, 'Tulane University', 'www.tulane.edu\r'),
(25, 'Paul Mitchell the School - East Bay', '459231\r'),
(26, 'Cloud County Community College', 'www.cloud.edu\r'),
(27, 'Villanova University', 'www.villanova.edu\r'),
(28, 'New York Career Institute', 'www.nyci.edu\r'),
(29, 'Antonelli College - Jackson', 'www.antonellicollege.edu\r'),
(30, 'Azure College', 'www.azurecollege.com\r'),
(31, 'Chaminade University of Honolulu', 'www.chaminade.edu\r'),
(32, 'California State University - East Bay', 'www.csueastbay.edu\r'),
(33, 'Dominican House of Studies', 'WWW.DHS.EDU\r'),
(34, 'University of North Florida', 'www.unf.edu\r'),
(35, 'Northshore Technical Community College - Sullivan', 'www.ltc.edu\r'),
(36, 'Colby-Sawyer College', 'www.colby-sawyer.edu\r'),
(37, 'Franciscan University of Steubenville', 'www.franciscan.edu\r'),
(38, 'Dade Medical College - Miami', 'www.dademedicalinstitute.com\r'),
(39, 'Washtenaw Community College', 'www.wccnet.edu\r'),
(40, 'Hobart Institute of Welding Technology', 'www.welding.org\r'),
(41, 'Tri-County Technical College', 'www.tctc.edu\r'),
(42, 'Tiffin University', 'www.tiffin.edu\r'),
(43, 'Mid-Cities Barber College', '423412\r'),
(44, 'Salter College', 'www.salterschool.com\r'),
(45, 'Drake University', 'www.drake.edu\r'),
(46, 'Academy of Hair Design #6', 'www.academyofhair.com\r'),
(47, 'Khalsa Montessori Teacher Education Program', 'www.khalsamontessorischool.com\r'),
(48, 'Hawaii Business College', '141583\r'),
(49, 'Gretna Career College', 'gretnacareercollege.edu\r'),
(50, 'Skidmore College', 'www.skidmore.edu\r'),
(51, 'Madison Adult Career Center', 'madison-richland.k12.oh.us/adulted\r'),
(52, 'Millersville University of Pennsylvania', 'www.millersville.edu\r'),
(53, '\"International School of Skin', '404-843-1005\r'),
(54, 'Technical Education Center-Osceola', 'www.teco.osceola.k12.fl.us\r'),
(55, 'Omnitech Institute', 'omnitechinc.com\r'),
(56, 'Henry Ford College', 'www.hfcc.edu\r'),
(57, 'Tramy Beauty School', '461397\r'),
(58, 'Sojourner-Douglass College', 'www.sdc.edu\r'),
(59, 'Vermont College of Fine Arts', 'www.vermontcollege.edu\r'),
(60, 'Spring Valley Montessori Teacher Education Program', 'www.springvalley.org/EarlyChildhoodTraining\r'),
(61, 'Cascadia Community College', 'www.cascadia.edu\r'),
(62, 'University of Cincinnati', 'www.uc.edu\r'),
(63, 'Harrison Career Institute - Allentown', 'hci.edu\r'),
(64, 'Aviation Institute of Maintenance - Orlando', 'www.aviationmaintenance.edu\r'),
(65, 'Jefferson Community College', 'www.sunyjefferson.edu\r'),
(66, 'Dale Carnegie Training of Long Island', 'www.dalecarnegie.com\r'),
(67, 'Slippery Rock University of Pennsylvania', 'www.sru.edu\r'),
(68, 'Monongalia County Technical Education Center', 'boe.mono.k12.wv.us/montec\r'),
(69, 'Northwest Iowa Community College', 'www.nwicc.edu\r'),
(70, 'University of North Alabama', 'www.una.edu\r'),
(71, 'Black River Technical College', 'www.blackrivertech.edu\r'),
(72, 'Francis Marion University', 'www.fmarion.edu\r'),
(73, 'Seattle Vocational Institute', 'www.sccd.ctc.edu\r'),
(74, 'Newbury College', 'www.newbury.edu\r'),
(75, 'Macomb Community College', 'www.macomb.edu\r'),
(76, 'San Diego Miramar College', 'www.miramarcollege.net/\r'),
(77, 'Ralph H. Johnson VA Medical Center', 'www.charleston.va.gov\r'),
(78, 'SUNY at Fredonia', 'www.fredonia.edu\r'),
(79, 'Palomar Institute of Cosmetology', 'www.pic.edu\r'),
(80, 'Midstate College', 'www.midstate.edu\r'),
(81, 'Mid-State Technical College', 'www.mstc.edu\r'),
(82, 'LIM College', 'www.limcollege.edu\r'),
(83, 'San Francisco State University', 'www.sfsu.edu\r'),
(84, 'Northwest Technical Institute', 'www.nti.tec.ar.us\r'),
(85, 'Antonelli Institute', 'www.antonelli.edu\r'),
(86, 'Florida Career College - Miami', '133997\r'),
(87, 'Indiana University South Bend', 'www.iu.edu\r'),
(88, 'First Coast Technical College', 'www.fcti.org\r'),
(89, 'Simmons College', 'www.simmons.edu\r'),
(90, 'Career Quest Learning Center', 'www.careerquest1.com\r'),
(91, 'Stratford University', 'www.stratford.edu\r'),
(92, 'Alvernia University', 'www.alvernia.edu\r'),
(93, 'Georgia Institute of Technology - Main Campus', '139755\r'),
(94, 'Occupational Training Services Inc', 'WWW.OTS-SDCHC.ORG\r'),
(95, 'Brewster Technical Center', 'brewstertech.org\r'),
(96, 'Moberly Area Community College', 'www.macc.edu\r'),
(97, 'Alderson Broaddus University', 'blue.ab.edu/\r'),
(98, 'Elmhurst College', 'www.elmhurst.edu\r'),
(99, 'Brown University', 'www.brown.edu\r'),
(100, 'Franciscan School of Theology', 'www.fst.edu\r'),
(101, 'Gwinnett College', 'www.gwinnettcollege.com\r'),
(102, 'Hesston College', 'www.hesston.edu\r'),
(103, 'Fox College Inc', 'www.foxcollege.edu\r'),
(104, 'Little Priest Tribal College', '434016\r'),
(105, 'Medical Allied Career Center', '04185600\r'),
(106, 'Lawrence University', 'www.Lawrence.edu\r'),
(107, 'Community Care College', 'www.communitycarecollege.edu\r'),
(108, 'Colby College', 'www.colby.edu\r'),
(109, 'Remington College - Tampa Campus', '135939\r'),
(110, 'Eldon Career Center', 'www.eldoncareercenter.org\r'),
(111, 'Minneapolis Business College', 'minneapolisbusinesscollege.edu\r'),
(112, 'Hope Montessori Educational Institute', 'www.hopemontessoritraining.com\r'),
(113, 'Malone University', 'www.malone.edu\r'),
(114, 'Big Bend Community College', 'www.bigbend.edu\r'),
(115, 'Augusta Technical College', 'www.augustatech.edu\r'),
(116, 'Virginia Commonwealth University', 'www.vcu.edu/\r'),
(117, 'Temple University', 'www.temple.edu\r'),
(118, 'Southern Adventist University', 'www.southern.edu\r'),
(119, 'International Schools', 'www.internationalschools.com\r'),
(120, 'Goodwin College', 'www.GOODWIN.EDU\r'),
(121, 'Missouri Western State University', 'www.missouriwestern.edu\r'),
(122, 'Maplewood Career Center', 'www.mwood.cc\r'),
(123, 'Radford University', 'www.radford.edu\r'),
(124, 'Yeshiva University', 'www.yu.edu\r'),
(125, 'New York College of Podiatric Medicine', 'www.nycpm.edu\r'),
(126, 'Jamestown Business College', 'www.jamestownbusinesscollege.edu\r'),
(127, 'Pioneer Career and Technology Center', 'www.pctc.k12.oh.us\r'),
(128, 'Dixie State university', 'www.dixie.edu\r'),
(129, '\"The Artisan College of Cosmetology', '459480\r'),
(130, '\"Concordia University', '173328\r'),
(131, 'New York Medical Career Training Center', '457800\r'),
(132, 'Phillips Community College of the University of Ar', 'www.pccua.edu\r'),
(133, 'University of Bridgeport', 'www.bridgeport.edu\r'),
(134, 'Rosedale Bible College', 'www.rosedale.edu\r'),
(135, 'Belhaven University', 'www.belhaven.edu\r'),
(136, 'Modern Hairstyling Institute - Carolina', '438337\r'),
(137, '\"Lower Columbia Enterprises', '236744\r'),
(138, 'Mundus Institute', '105242\r'),
(139, 'University of Minnesota - Twin Cities', '174066\r'),
(140, 'California State University - Fresno', 'www.fresnostate.edu\r'),
(141, 'North Florida Community College', 'www.nfcc.edu\r'),
(142, 'Lyndon State College', '230931\r'),
(143, 'Jersey College', 'www.cannj.com\r'),
(144, 'Fordham University', 'www.fordham.edu\r'),
(145, 'Regis University', 'www.regis.edu/\r'),
(146, 'Salon Success Academy - San Bernardino', '115357\r'),
(147, 'SUNY College of Environmental Science and Forestry', 'www.esf.edu\r'),
(148, 'Delgado Community College', 'www.dcc.edu\r'),
(149, 'Valley College - Princeton', 'valleycollege.com\r'),
(150, 'Sage School of Massage', '459499\r'),
(151, 'Northern Oklahoma College', 'www.north-ok.edu\r'),
(152, 'Phoenix Therapeutic Massage College', 'ptmcaz.edu\r'),
(153, 'North-West College - Pasadena', 'www.north-westcollege.com\r'),
(154, 'University of Northwestern - St. Paul', 'www.nwc.edu\r'),
(155, 'Southern Polytechnic State University', 'www.spsu.edu\r'),
(156, 'Metro Business College of Cape Girardeau', 'WWW.METROBUSINESSCOLLEGE.EDU\r'),
(157, '\"Graduate School and University Center of the City', '190576\r'),
(158, 'Schenectady County Community College', 'www.sunysccc.edu\r'),
(159, 'College of the Canyons', 'www.canyons.edu\r'),
(160, 'Hebrew College', 'www.hebrewcollege.edu\r'),
(161, 'Shaw University', 'www.shawuniversity.edu\r'),
(162, 'Institute of Taoist Education & Acupuncture', '454838\r'),
(163, 'Salve Regina University', 'www.salve.edu\r'),
(164, 'Columbia College of Nursing', '-1\r'),
(165, 'Trinity School for Ministry', 'www.tsm.edu/\r'),
(166, 'Sistema Universitario Ana G Mendez - Universidad D', 'www.suagm.edu\r'),
(167, 'Montessori Center for Teacher Education - Washingt', 'www.montessoriteachereducation.org\r'),
(168, 'Centre College', 'www.centre.edu\r'),
(169, 'Northwest College School of Beauty', 'www.nwchd.com\r'),
(170, 'Phillips Theological Seminary', 'www.ptstulsa.edu\r'),
(171, 'United States Sports Academy', 'www.ussa.edu\r'),
(172, 'Harrison Center for Career Education', 'www.ywcanca.org\r'),
(173, 'Marietta College', 'www.marietta.edu\r'),
(174, 'Academy for Five Element Acupuncture', 'www.acupuncturist.edu\r'),
(175, 'Lutheran Theological Seminary', 'www.ltsg.edu\r'),
(176, 'Michael E. DeBakey VA Medical Center', 'www.houston.va.gov\r'),
(177, 'Sanford-Brown College - Grand Rapids', '458618\r'),
(178, 'Garnet Career Center', 'kcs.kana.k12.wv.us/garnet/\r'),
(179, 'Dawn Career Institute', 'WWW.DAWNTRAININGCENTRE.EDU\r'),
(180, 'Roane State Community College', 'www.roanestate.edu\r'),
(181, 'Professionals Choice Hair Design Academy', 'www.pchairdesign.com\r'),
(182, 'University of Hawaii at Manoa', '141574\r'),
(183, 'Seattle Central Community College', 'www.seattlecentral.org\r'),
(184, 'New York International Beauty School Ltd', 'www.nyibs.com\r'),
(185, 'Brightwood College - Las Vegas', 'heritagecollege.com\r'),
(186, 'Dwight D. Eisenhower Army Medical Center', 'www.ddeamc.amedd.army.mil/about.aspx\r'),
(187, 'The Reading Hospital and Medical Center', 'www.readinghospital.org\r'),
(188, 'John Tracy Clinic', 'www.jtc.org\r'),
(189, 'University of Alaska Fairbanks', 'www.uaf.edu\r'),
(190, 'Shelton Montessori Teacher Education Center', 'www.shelton.org/page.cfm?p=435\r'),
(191, 'Cooper Union for the Advancement of Science and Ar', 'www.cooper.edu\r'),
(192, 'Griffin Technical College', 'www.griffintech.edu\r'),
(193, 'Chesapeake College', 'www.chesapeake.edu\r'),
(194, 'Research Medical Center School of Radiologic Techn', 'www.RESEARCHMEDICALCENTER.COM\r'),
(195, 'West Central Technical College', 'www.westcentraltech.edu\r'),
(196, 'Institute of American Indian and Alaska Native Cul', 'www.iaia.edu\r'),
(197, 'Northeast Technology Center - Kansas', '432074\r'),
(198, 'College of Lake County', 'WWW.CLCILLINOIS.EDU\r'),
(199, 'MyComputerCareer.com / TechSkills', 'www.techskills.com\r'),
(200, 'Pacific International Academy', 'www.piaschools.edu\r'),
(201, 'Virginia Tech Carilon School of Medicine', '459082\r'),
(202, 'Montessori Academy Training Institute', 'http://www.montessori-academy.org/mati\r'),
(203, 'Houghton College', 'www.houghton.edu\r'),
(204, 'Lincoln Technical Institute - Fern Park', 'www.americareschools.com\r'),
(205, 'Florida College of Integrative Medicine', 'www.fcim.edu\r'),
(206, 'Alvin Community College', 'www.alvincollege.edu\r'),
(207, 'Assumption College for Sisters', 'www.acs350.org\r'),
(208, '\"Five Branches University:  Graduate School of Tra', '114585\r'),
(209, 'Covenant School of Nursing and Allied Health', '226675\r'),
(210, 'Central Christian College of Kansas', 'www.centralchristian.edu\r'),
(211, 'Lester E. Cox Medical Center - School of Medical T', 'www.coxhealth.com\r'),
(212, 'South Dakota School of Mines and Technology', 'www.sdsmt.edu\r'),
(213, 'Vatterott College - Des Moines', 'www.vatterott-college.edu\r'),
(214, 'Won Institute of Graduate Studies', 'www.woninstitute.org\r'),
(215, 'Montana State University - Great Falls College of ', 'www.msugf.edu\r'),
(216, 'Everest Institute - Eagan', '445382\r'),
(217, '\"Princess Beauty School', '04231800\r'),
(218, 'Athenaeum of Ohio', 'www.athenaeum.edu\r'),
(219, 'Manchester University', 'www.manchester.edu\r'),
(220, 'PCI Health Training Center', 'www.pcihealth.net\r'),
(221, 'Johnson County Community College', 'www.jccc.net\r'),
(222, 'American International  College', 'www.aic.edu\r'),
(223, 'Kiamichi Technology Center - McAlester', 'www.ktc.edu\r'),
(224, 'South Louisiana Beauty College', 'SLBC-HOUMA.COM\r'),
(225, 'Williamson College', 'www.williamsoncc.edu\r'),
(226, 'Pickens Technical College', 'www.pickenstech.org\r'),
(227, 'University of the Virgin Islands', 'www.uvi.edu\r'),
(228, 'Mountain State University', 'www.mountainstate.edu\r'),
(229, 'Terra State Community College', 'www.terra.edu\r'),
(230, 'Stillman College', 'www.stillman.edu\r'),
(231, 'Rolf Institute', '262466\r'),
(232, 'Brillare Hairdressing Academy - Scottsdale', '02561900\r'),
(233, 'Spa Tech Institute - Plymouth', 'HeadhunterInstitute.com\r'),
(234, 'Salem College of Hairstyling', '179195\r'),
(235, 'National Court Reporters Association', 'www.ncraonline.org\r'),
(236, 'Maryville University of Saint Louis', 'www.maryville.edu\r'),
(237, 'Carl D. Perkins Job Corps Center', 'itiseasy.com/perkins\r'),
(238, 'Saint Basil College', 'www.stbasilcollege.com\r'),
(239, 'Connors State College', 'www.connors.cc.ok.us\r'),
(240, 'Abilene Christian University', 'www.acu.edu\r'),
(241, 'Everest College - Colorado Springs', 'www.cci.edu\r'),
(242, 'Rend Lake College', 'www.rlc.cc.il.us\r'),
(243, 'Cochise College', 'www.cochise.edu\r'),
(244, 'Delta College of Arts & Technology', 'www.deltacollege.com\r'),
(245, 'The Art Institute of Houston', 'www.artinstitutes.edu/houston/\r'),
(246, 'University of Arkansas for Medical Sciences', 'www.uams.edu\r'),
(247, 'Southwestern Assemblies of God University', 'www.sagu.edu\r'),
(248, 'Mid-America Christian University', 'www.macu.edu\r'),
(249, 'Reinhardt University', 'www.reinhardt.edu\r'),
(250, 'North-West College - Glendale', 'www.north-westcollege.com\r'),
(251, 'Motlow State Community College', 'www.mscc.edu\r'),
(252, 'Clinton Community College', 'www.clinton.edu\r'),
(253, 'Medical College of Wisconsin', 'www.mcw.edu\r'),
(254, 'South Dakota State University', '219356\r'),
(255, 'North Lake College', 'www.northlakecollege.edu\r'),
(256, 'SUNY College at Oswego', 'www.oswego.edu/\r'),
(257, 'New Britain School of Nurse Anesthesia', 'www.nbsna.org\r'),
(258, 'National University of Health Sciences', 'www.nuhs.edu\r'),
(259, 'California State University - Monterey Bay', 'www.csumb.edu\r'),
(260, 'SOUTHERN NEW JERSEY TECHNICAL SCHOOL - WOODBURY', 'www.snjts.com\r'),
(261, 'Elmira College', 'www.elmira.edu\r'),
(262, 'University of North Carolina at Asheville', 'www.unca.edu\r'),
(263, 'Morehead State University', 'www.moreheadstate.edu\r'),
(264, 'Vermilion Community College', 'www.vcc.edu\r'),
(265, 'College of Staten Island of the City University of', 'www.csi.cuny.edu\r'),
(266, 'Valparaiso University', 'www.valpo.edu\r'),
(267, 'SUNY College of Agriculture & Technology at Morris', 'www.morrisville.edu\r'),
(268, 'Central State University', 'www.centralstate.edu\r'),
(269, 'Scot Lewis Schools', 'www.scotlewis.com\r'),
(270, 'Amridge University', 'www.amridgeuniversity.edu\r'),
(271, 'Bellus Academy', 'www.sandiegobeautyacademy.com\r'),
(272, 'Kishwaukee College', 'www.kishwaukeecollege.edu\r'),
(273, 'Ogle School of Hair Skin Nails - Hurst', 'www.ogleschool.com\r'),
(274, 'Cortiva Institute - Seattle', '419411\r'),
(275, 'Vatterott Education Center', '450553\r'),
(276, 'Cabrillo College', 'www.cabrillo.edu\r'),
(277, 'Cortiva Institute - Chicago', '244561\r'),
(278, 'Southeastern Community College', 'www.scciowa.edu\r'),
(279, 'Tri-State Semi Driver Training - Palmer', 'www.learn2drive.com\r'),
(280, 'Southeastern Illinois College', 'www.sic.edu\r'),
(281, 'Virginia Beach Theological Seminary', 'www.vbts.edu\r'),
(282, 'City of Hope', 'www.cityofhope.org\r'),
(283, 'Hair Professionals Career College Inc', 'www.beautyschool.com/hairpros/\r'),
(284, 'The SANS Technology Institute', 'www.sans.edu\r'),
(285, 'Bay Mills Community College', 'www.bmcc.edu\r'),
(286, 'Rob Roy Academy - New Bedford', 'www.rob-roy.com\r'),
(287, 'Gwynedd Mercy University', '212832\r'),
(288, 'California Institute of Advanced Management', '487649\r'),
(289, 'Wake Technical Community College', 'www.waketech.edu\r'),
(290, 'Rainy River Community College', 'www.rrcc.mnscu.edu\r'),
(291, 'California Baptist University', 'www.calbaptist.edu\r'),
(292, 'Crowder College', 'www.crowder.edu\r'),
(293, 'Phoenix East Aviation', 'www.pea.com\r'),
(294, 'Northwest Baptist Seminary', 'www.nbs.edu\r'),
(295, 'University of Nevada - Reno', 'www.unr.edu\r'),
(296, 'Sheldon Jackson College', 'www.sj-alaska.edu\r'),
(297, 'Williamsburg Technical College', 'www.wiltech.edu\r'),
(298, 'Huertas College', 'www.huertas.edu\r'),
(299, 'Utah College of Massage Therapy Inc-Utah Valley', 'www.ucmt.com\r'),
(300, 'Fairfield-Suisun Adult School', 'www.fsadultschool.com\r'),
(301, 'Quinebaug Valley Community College', 'www.qvctc.commnet.edu\r'),
(302, 'Webber International University', 'www.webber.edu\r'),
(303, 'Paul Mitchell the School Boise', 'www.scotlewis.com\r'),
(304, 'California Miramar University', '480781\r'),
(305, 'Remington College', 'www.remingtoncollege.com\r'),
(306, 'Maryville College', 'www.maryvillecollege.edu\r'),
(307, 'Ashworth College', 'www.ashworthcollege.edu\r'),
(308, 'Tri-State College of Acupuncture', 'www.TSCA.edu\r'),
(309, 'JFK Medical Center Muhlenberg Harold B. and Doroth', 'WWW.SOLARISHS.ORG\r'),
(310, 'University of Western States', 'wschiro.edu\r'),
(311, 'University of Arkansas Community College-Morrilton', 'www.uaccm.edu\r'),
(312, 'Boston University', '164988\r'),
(313, 'Salem International University', 'www.salemu.edu\r'),
(314, 'Palladium Technical Academy', 'www.palladiumta.com\r'),
(315, '\"The Cactus Academy', '04212500\r'),
(316, 'VA Maryland Health Care System (Baltimore/Perry Po', 'www.maryland.va.gov\r'),
(317, 'Annenberg School of Nursing', 'www.jha.org\r'),
(318, 'Ecclesia College', 'www.ecollege.edu\r'),
(319, 'Kenrick-Glennon Seminary', 'kenrick.edu\r'),
(320, 'Livingstone College', 'www.livingstone.edu\r'),
(321, 'University of Maryland - Baltimore County', 'www.umbc.edu\r'),
(322, 'Focus:  HOPE Machinist Training Institute', 'www.focushope.edu\r'),
(323, 'College of Southern Nevada', 'www.csn.edu\r'),
(324, 'Southwestern Baptist Theological Seminary', 'www.swbts.edu\r'),
(325, 'Fresno Adult School', 'www.fresnoadultschool.org\r'),
(326, 'Southern Wesleyan University', 'www.swu.edu\r'),
(327, 'Holmes Community College', 'www.holmescc.edu\r'),
(328, 'Dutchess Community College', 'www.sunydutchess.edu\r'),
(329, 'Phoenix Institute of Herbal Medicine and Acupunctu', '447698\r'),
(330, 'Paul Mitchell the School Spokane', '462071\r'),
(331, 'Kanawha Valley Community and Technical College', 'www.wvsctc.edu\r'),
(332, 'Becker College', 'www.beckercollege.edu\r'),
(333, 'Albany Technical College', 'www.albanytech.edu\r'),
(334, 'Kansas City Ks Area Technical School', 'www.kckats.com\r'),
(335, 'Kentucky Christian University', 'www.kcc.edu\r'),
(336, 'Augustana College', 'www.augustana.edu\r'),
(337, 'Gordon State College', 'www.gdn.edu\r'),
(338, 'Allen School - Jamaica', 'www.allenschool.edu\r'),
(339, 'Carolina College of Hair Design', '460765\r'),
(340, 'Baylor University', 'www.baylor.edu\r'),
(341, 'Jones International University', 'www.international.edu\r'),
(342, 'Brite Divinity School of Texas Christian Universit', 'www.brite.tcu.edu\r'),
(343, 'High Tech High Graduate School of Education', 'http://gse.hightechhigh.org/\r'),
(344, 'Lyles Fresno College of Beauty', '118143\r'),
(345, 'Inter American University of Puerto Rico Guayama', 'www.guayama.inter.edu\r'),
(346, 'Empire Beauty School - Portland', 'www.pierresschool.com\r'),
(347, 'Flagler College', 'www.flagler.edu\r'),
(348, 'Louisiana Technical College - Jefferson Campus', 'www.ltc.edu\r'),
(349, 'Mitchell-Hamline School of Law', 'www.wmitchell.edu\r'),
(350, 'Everest Institute - San Jose', 'CCI.EDU\r'),
(351, 'Tidewater Community College', 'www.tcc.edu\r'),
(352, 'Genesee Community College', 'www.genesee.edu\r'),
(353, 'FlightSafety Academy', '133739\r'),
(354, 'Stetson University', 'www.stetson.edu\r'),
(355, 'University of the Rockies', '441308\r'),
(356, 'Arkansas Tech University', '106467\r'),
(357, 'Bevill State Community College', 'www.bscc.edu\r'),
(358, 'ICPR Junior College', 'www.icprjc.edu\r'),
(359, 'Oklahoma State University', 'pio.okstate.edu\r'),
(360, 'American Broadcasting School', 'www.radioschool.com\r'),
(361, 'Carondelet Health', 'www.carondelethealth.org\r'),
(362, 'Rogue Community College', 'www.roguecc.edu\r'),
(363, 'West Virginia Business College - Wheeling', 'www.wvbc.edu\r'),
(364, 'Harrison Career Institute - Reading', '376109\r'),
(365, 'Maysville Community and Technical College', 'www.maysville.kctcs.edu\r'),
(366, 'Catholic Distance University', 'www.cdu.edu\r'),
(367, 'Pyramid Career Institute', 'www.pyramid-pci.com\r'),
(368, 'Apex Technical School', 'www.apextechnical.com.\r'),
(369, 'Brescia University', 'www.brescia.edu\r'),
(370, 'Franklin Pierce College-Graduate and Professional ', 'www.fpc.edu\r'),
(371, 'Jefferson Community and Technical College', 'www.jefferson.kctcs.edu\r'),
(372, 'PITC Institute', 'www.pitc.edu\r'),
(373, 'Aveda Institute - Covington', 'www.avedainstitutes.com\r'),
(374, 'Withlacoochee Technical Institute', 'www.wtionline.cc\r'),
(375, 'Grand River Technical School', 'www.grts.org\r'),
(376, 'Polaris Career Center', 'www.polaris.edu\r'),
(377, 'Fortis College - Salt Lake City', '456454\r'),
(378, 'Center for Information Dominance (CID)', 'www.nko.navy.mil\r'),
(379, 'National Holistic Institute', 'www.nhimassage.com\r'),
(380, 'The Creative Center', 'www.thecreativecenter.com\r'),
(381, 'College of International Esthetics', '476586\r'),
(382, 'South Seattle Community College', 'www.southseattle.edu\r'),
(383, 'University of Dallas', 'www.udallas.edu\r'),
(384, 'County College of Morris', 'www.ccm.edu\r'),
(385, 'Fortis College - Centerville', 'www.retstechcenter.com\r'),
(386, 'Lakewood College', 'www.lakewoodcollege.edu\r'),
(387, '\"Palmetto Beauty School', '04192600\r'),
(388, 'Oikos University', 'www.oikosuniversity.org\r'),
(389, 'Moore Career College', '444662\r'),
(390, 'Trinity Christian College', 'www.trnty.edu\r'),
(391, 'Notter School of Pastry Arts', '461519\r'),
(392, 'Saint Anselm College', 'www.anselm.edu\r'),
(393, 'Central Georgia Technical College', 'www.cgtcollege.org\r'),
(394, 'Keweenaw Bay Ojibwa Community College', '461315\r'),
(395, 'Ross College', 'www.rosseducation.edu\r'),
(396, 'Center for Employment Training - Riverside', '111744\r'),
(397, 'Studio Jewelers', 'www.studiojewelersltd.com\r'),
(398, 'The College of Office Technology', 'www.cotedu.com\r'),
(399, 'Cazenovia College', 'www.cazenovia.edu\r'),
(400, 'University of Wisconsin - Eau Claire', 'www.uwec.edu\r'),
(401, 'Lincoln College of Technology - Denver', 'www.DADC.com\r'),
(402, 'Puritan Reformed Theological Seminary', 'prts.edu/\r'),
(403, 'SUNY Maritime College', 'www.sunymaritime.edu\r'),
(404, 'Creations College of Cosmetology', 'www.creationscosmetology.com\r'),
(405, 'American Institute for Paralegal', 'www.americanparalegal.edu\r'),
(406, 'Harrison Career Institute - Deptford', 'www.hci.edu\r'),
(407, 'Misericordia University', 'www.misericordia.edu\r'),
(408, 'Walla Walla University', 'www.wallawalla.edu\r'),
(409, 'Wake Forest University', 'www.wfu.edu\r'),
(410, 'Bluegrass Community and Technical College', 'www.bluegrass.kctcs.edu\r'),
(411, 'Med Tech College - Indianapolis', '448415\r'),
(412, 'Training Solutions Inc', '444918\r'),
(413, 'Academy Di Capelli', '449463\r'),
(414, 'Francis Tuttle Technology Center - Reno', 'www.francistuttle.edu\r'),
(415, 'Sierra Valley College of Court Reporting', 'sierravalleycollege.com\r'),
(416, 'Suncoast II the Tampa Bay School of Massage Therap', 'suncoastii.com\r'),
(417, 'Epic Bible College and Graduate School', 'www.epic.edu\r'),
(418, 'South Georgia State College', 'www.sgsc.edu\r'),
(419, 'Johnston Community College', 'www.johnstoncc.edu\r'),
(420, 'International Institute for Restorative Practices', 'www.iirp.org\r'),
(421, 'Fortis College - Tampa', '136075\r'),
(422, 'Montessori Teacher Education Center - San Francisc', 'www.montessoritrainingusa.com/\r'),
(423, 'Middlesex Community College - Middletown', 'www.mxcc.commnet.edu\r'),
(424, 'College of Coastal Georgia', 'www.ccga.edu\r'),
(425, 'Portland Actors Conservatory', 'www.actorsconservatory.com\r'),
(426, 'University of Saint Mary', 'www.stmary.edu\r'),
(427, 'VA Long Beach Healthcare System', 'www.longbeach.gov\r'),
(428, 'Central Pennsylvania Institute of Science and Tech', 'www.cpi.edu\r'),
(429, 'Applewood Centers', 'www.applewoodcenters.org\r'),
(430, 'Columbia Southern University', 'www.columbiasouthern.edu\r'),
(431, 'Lincoln Land Community College', 'www.llcc.edu\r'),
(432, 'Northeast State Community College', 'www.northeaststate.edu\r'),
(433, 'Holy Cross College', 'www.hcc-nd.edu\r'),
(434, 'Presbyterian College', 'www.presby.edu\r'),
(435, 'College of the Albemarle', 'www.albemarle.edu\r'),
(436, 'La Belle Beauty School', 'www.BeautyAcademy.com\r'),
(437, 'Corcoran College of Art and Design', 'www.corcoran.edu\r'),
(438, 'Institute of Technology', 'www.it-colleges.com\r'),
(439, 'West Hills College - Coalinga', 'www.westhillscollege.com\r'),
(440, 'Kaplan Career Institute - Charlestown', 'www.retstech.com\r'),
(441, 'Avila University', 'www.Avila.edu\r'),
(442, '\"DiGrigoli School of Cosmetology', '451255\r'),
(443, 'Everest Institute - Atlanta Downtown', '139898\r'),
(444, 'Nashville State Community College', 'www.nscc.edu\r'),
(445, 'Ohio State College of Barber Styling', 'www.ohiobarbercollege.com\r'),
(446, 'American Institute of Allied Health', 'www.aioah.com\r'),
(447, 'Platt College-Newport Beach', 'www.plattcollege.edu\r'),
(448, 'Santa Monica Montessori Institute', 'www.montessorischoollosangeles.com\r'),
(449, 'Independence University', '465812\r'),
(450, 'House of Heavilin Beauty College - Blue Springs', 'kc-hair.com\r'),
(451, 'Huntington Park - Bell Community Adult School', 'www.hpbell.com\r'),
(452, 'Galiano Career Academy', '446279\r'),
(453, 'Delaware Technical Community College', 'www.dtcc.edu\r'),
(454, 'Amherst College', 'www.amherst.edu\r'),
(455, 'California University of Pennsylvania', 'www.calu.edu\r'),
(456, 'Sullivan University', 'www.sullivan.edu\r'),
(457, 'Xavier University', 'www.xavier.edu\r'),
(458, 'University of Puerto Rico - Medical Sciences Campu', 'www.rcm.upr.edu\r'),
(459, 'Calumet College of St. Joseph', 'www.ccsj.edu\r'),
(460, 'Southern Vermont College', 'www.svc.edu\r'),
(461, 'Missouri Tech', 'www.motech.edu\r'),
(462, 'Saginaw Chippewa Tribal College', 'www.sagchip.edu/\r'),
(463, 'Nexcare Health Care Training Institute', 'www.nexcarehealth.com\r'),
(464, 'Cannon Institute of Higher Learning', '458025\r'),
(465, 'Lewis University', 'www.lewisu.edu\r'),
(466, 'Brownson Technical School', 'brownsontechnicalschool.com\r'),
(467, 'Colorado Christian University', 'WWW.CCU.EDU\r'),
(468, 'Seguin Beauty School', 'www.seguinbeautyschool.com\r'),
(469, 'Music City Barber College LLC', '1wcu.com\r'),
(470, 'Pikes Peak Community College', 'www.ppcc.edu\r'),
(471, 'MedCentral College of Nursing', 'www.medcentral.edu\r'),
(472, 'Southern Methodist College', 'www.smcollege.edu\r'),
(473, 'York College of the City University of New York', 'www.york.cuny.edu\r'),
(474, 'Oklahoma Health Academy', 'www.oklahomahealthacademy.org\r'),
(475, 'Renasci Academy of Hair Inc', 'www.RenasciAcademy.com\r'),
(476, 'Reid Hospital and Health Care Services', 'www.reidhospital.org\r'),
(477, 'Divine Crown Academy of Cosmetology', '483346\r'),
(478, 'Teterboro School of Aeronautics', 'www.teterboroschool.com\r'),
(479, 'University of Maryland - College Park', 'www.umd.edu\r'),
(480, 'Union College', 'www.unionky.edu\r'),
(481, 'Mauna Loa Helicopters', 'maunaloahelicopters.com\r'),
(482, 'Aviation and Electronic Schools of America - Colfa', 'aesa.com\r'),
(483, 'Tabor College', 'www.tabor.edu\r'),
(484, 'Vanguard-Sentinel Career & Technology Center', '421717\r'),
(485, 'National Institute of Technology', 'nationalinstituteoftechnology.edu\r'),
(486, 'Software Education of America', '443243\r'),
(487, 'Cottey College', 'www.cottey.edu\r'),
(488, 'UPR - Ponce', '243212\r'),
(489, 'Orange Technical College - Orlando Campus', 'www.orlandotech.ocps.net\r'),
(490, 'Caldwell University', 'www.caldwell.edu\r'),
(491, 'Vincennes University', 'www.vinu.edu\r'),
(492, 'DVS College', '395733\r'),
(493, 'Monmouth County Post-Secondary Adult School', 'www.mcvsd.org\r'),
(494, 'College of the Desert', 'www.collegeofthedesert.edu\r'),
(495, 'Southern Methodist University', 'www.smu.edu\r'),
(496, 'University of Valley Forge', 'www.vfcc.edu\r'),
(497, 'Birthwise Midwifery School', 'www.birthwisemidwifery.edu\r'),
(498, 'NorthShore University HealthSystem - Evanston Hosp', 'enh.org/academicprograms\r'),
(499, 'North Central University', 'www.northcentral.edu\r'),
(500, 'Los Angeles Mission College', 'www.lamission.edu\r'),
(501, 'Ozarks Technical Community College', 'www.otc.edu\r'),
(502, 'Rochester College', 'www.rc.edu\r'),
(503, 'Capital Community College', 'www.ccc.commnet.edu\r'),
(504, 'Intercoast Colleges', '366289\r'),
(505, 'VA NY Harbor Healthcare System - Brooklyn', 'www.nyharbor.va.gov\r'),
(506, 'New College of Florida', 'www.ncf.edu\r'),
(507, 'Caribbean Forensic and Technical College', 'www.cafotech.com\r'),
(508, 'West Coast University', 'www.westcoastuniversity.com\r'),
(509, 'University of Michigan - Ann Arbor', 'www.umich.edu\r'),
(510, 'Santa Clara University', 'www.scu.edu\r'),
(511, 'Roger Williams University', 'www.rwu.edu\r'),
(512, 'Northern New Mexico College', 'nnmcc.edu\r'),
(513, 'Westfield State University', 'www.wsc.ma.edu/\r'),
(514, 'College of Our Lady of the Elms', 'www.elms.edu\r'),
(515, 'Remington College - Shreveport Campus', 'www.remingtoncollege.edu\r'),
(516, 'George T Baker Aviation School', 'www.bakeraviation.dadeschools.net\r'),
(517, 'VA NY Harbor Healthcare System - Manhattan', 'www.nyharbor.va.gov\r'),
(518, 'Northern Career Institute', '418223\r'),
(519, 'Bank Street College of Education', 'www.bankstreet.edu\r'),
(520, 'Sitting Bull College', 'www.sittingbull.edu\r'),
(521, 'Owensboro Community and Technical College', 'www.owensboro.kctcs.edu\r'),
(522, 'Meridian College', '244279\r'),
(523, 'City Colleges of Chicago-Kennedy-King College', 'kennedyking.ccc.edu/\r'),
(524, 'Laurus Technical Institute', 'WWW.ETIMEDICAL.COM\r'),
(525, 'SUNY College at Brockport', 'www.brockport.edu\r'),
(526, 'Esthetics Institute at Concord Academy', 'www.estheticsinstitute.net\r'),
(527, 'Rockefeller University', 'www.rockefeller.edu\r'),
(528, 'Emmaus Bible College', 'www.emmaus.edu\r'),
(529, 'Ball Memorial Hospital', 'www.cardinalhealthsystem.org/BMH/bmh.html\r'),
(530, 'University of Massachusetts - Lowell', 'WWW.UML.EDU\r'),
(531, 'Lubbock Christian University', 'www.lcu.edu\r'),
(532, 'Los Angeles Harbor College', 'www.lahc.edu\r'),
(533, 'Concordia University Wisconsin', 'www.cuw.edu\r'),
(534, 'Shorter University', 'www.shorter.edu\r'),
(535, '\"Renaissance Academy', '458104\r'),
(536, 'Jordan-Locke Community Adult School', 'www.jordanlockecas.yahoo.com\r'),
(537, '\"Bay Medical Center', '132523\r'),
(538, 'Webb Institute', 'www.webb.edu\r'),
(539, 'Middle Bucks Institute of Technology', 'www.mbit.org\r'),
(540, 'University of Texas Southwestern Medical Center', 'www.utsouthwestern.edu\r'),
(541, 'New Horizons Medical Institute', '483638\r'),
(542, 'Westwood College - Los Angeles', '122843\r'),
(543, 'Curtis Institute of Music', 'www.curtis.edu\r'),
(544, 'Mayville State University', 'www.mayvillestate.edu\r'),
(545, 'Oxnard Adult School', 'www.ouhsd.k12.ca.us\r'),
(546, 'College of the Marshall Islands', 'www.cmiedu.net\r'),
(547, 'College of Marin', 'www.marin.cc.ca.us\r'),
(548, 'Victor Valley College', 'www.vvc.edu\r'),
(549, 'University of Minnesota - Crookston', 'www.crk.umn.edu/\r'),
(550, '\"Rivertown School of Beauty', '31904\r'),
(551, 'Southern University at New Orleans', 'www.suno.edu\r'),
(552, 'Charles of Italy Beauty College', '104391\r'),
(553, '\"Select Education Group', '441663\r'),
(554, 'Montessori Western Teacher Training Program', 'www.montessoriwesttraining.com/Montessori_Western_'),
(555, 'Indian River State College', 'www.irsc.edu\r'),
(556, 'Cowley County Community College and Area Vocationa', '154952\r'),
(557, 'California State University - Northridge', 'www.csun.edu\r'),
(558, 'Hendrix College', 'www.hendrix.edu\r'),
(559, 'San Joaquin Delta College', 'www.deltacollege.edu\r'),
(560, 'Harrison Career Institute - Ewing', '437255\r'),
(561, '\"Frederick School of Cosmetology', '455017\r'),
(562, 'Western Connecticut State University', 'www.wcsu.edu\r'),
(563, 'Capri Institute of Hair Design-Succasunna', '436854\r'),
(564, 'Maric College - Los Angeles', '432311\r'),
(565, 'The English Center - Miami-Dade County Public Scho', 'www.tecmiami.com\r'),
(566, 'Asbury Theological Seminary', 'www.asburyseminary.edu\r'),
(567, 'Pasadena City College', 'www.pasadena.edu\r'),
(568, 'Christ the King Seminary', 'www.cks.edu\r'),
(569, 'Montessori Center for Teacher Development', 'www.montessoricenterforteacherdevelopment.com\r'),
(570, 'VA Hudson Valley Health Care System - Montrose', 'www.hudsonvalley.va.gov\r'),
(571, 'Seminole State College of Florida', 'www.seminolestate.edu\r'),
(572, 'Capri Beauty College - Chicago', 'WWW.CAPRIBEAUTYSCHOOL.COM\r'),
(573, 'Chaffey College', 'WWW.CHAFFEY.EDU\r'),
(574, 'University of South Dakota', 'WWW.USD.EDU\r'),
(575, 'Bluffton University', 'www.bluffton.edu\r'),
(576, 'Air Force Institute of Technology', '200697\r'),
(577, '\"Corinth Academy of Cosmetology', '451343\r'),
(578, 'Everest College - Everett', '363590\r'),
(579, 'University Health Care Systen', 'universityhealth.org\r'),
(580, 'Word of Life Bible Institute', 'www.worldoflife.edu\r'),
(581, 'Charlotte Christian College and Theological Semina', 'www.charlottechristian.edu\r'),
(582, 'Allied American University', '460729\r'),
(583, 'Colgate Rochester Crozer Divinity School', 'www.crcds.edu\r'),
(584, 'Bates Technical College', 'www.bates.ctc.edu/\r'),
(585, 'Lutheran Brethren Seminary', 'www.lbs.edu\r'),
(586, 'Gavilan College', 'www.gavilan.edu\r'),
(587, 'Northern Arizona University', 'www.nau.edu\r'),
(588, 'North Central Texas College', 'www.nctc.edu\r'),
(589, 'Pacific Oaks College', 'www.pacificoaks.edu\r'),
(590, 'Manhattanville College', 'www.mville.edu\r'),
(591, 'Cuyahoga Valley Career Center', 'www.cvcc.k12.oh.us\r'),
(592, 'Theda Clark Medical Center', '239965\r'),
(593, 'Tap This Valley Works CET', '444884\r'),
(594, 'Indiana University Kokomo', 'www.iu.edu\r'),
(595, 'Southwestern Christian University', 'www.swcu.edu\r'),
(596, 'Interior Designers Institute', 'idi.edu\r'),
(597, 'Vatterott College - Oklahoma City', 'vatterott-college.edu\r'),
(598, 'The Citadel', 'www.citadel.edu\r'),
(599, 'Seattle University', 'www.seattleu.edu\r'),
(600, 'Learning Institute for Beauty Sciences - Brooklyn', 'www.LIBSBEAUTYSCHOOL.com\r'),
(601, 'Arlington Baptist College', 'www.arlingtonbaptistcollege.edu\r'),
(602, 'Mississippi University for Women', 'www.muw.edu\r'),
(603, 'Graduate Theological Union', 'www.gtu.edu\r'),
(604, 'Bauder College', '139074\r'),
(605, 'Western Technical College', 'www.wti-ep.com\r'),
(606, 'Stark State College', 'www.starkstate.edu\r'),
(607, 'University of Massachusetts - Dartmouth', 'www.umassd.edu\r'),
(608, 'Blessing Hospital', '143303\r'),
(609, 'Ascension College', 'www.ascensioncollege.org\r'),
(610, 'Shippensburg University of Pennsylvania', 'www.ship.edu\r'),
(611, 'Center for Employment Training', 'www.cet2000.org\r'),
(612, 'St. Elizabeth Medical Center', 'www.stemc.org\r'),
(613, 'Avera Sacred Heart Hospital', 'www.avera.org\r'),
(614, 'Renaissance College', '446507\r'),
(615, 'Austin Graduate School of Theology', 'www.austingrad.edu\r'),
(616, 'College of the Siskiyous', 'www.siskiyous.edu\r'),
(617, 'Luther College', 'www.luther.edu\r'),
(618, 'Touro University Worldwide', '459727\r'),
(619, 'Douglas Education Center', 'www.douglas-school.com\r'),
(620, 'Salem City Schools', '202985\r'),
(621, 'York County Community College', 'www.yccc.edu\r'),
(622, 'Southeast Louisiana Veterans Health Care System', 'www.neworleans.va.gov\r'),
(623, 'Copiah-Lincoln Community College', 'www.colin.edu\r'),
(624, 'Riverland Community College', 'www.riverland.edu\r'),
(625, 'Clackamas Community College', 'www.clackamas.edu\r'),
(626, 'Preferred College of Nursing', '459152\r'),
(627, 'Palomar College', 'WWW.PALOMAR.EDU\r'),
(628, 'University of Holy Cross', 'www.olhcc.edu\r'),
(629, 'University of Hawaii Maui College', 'www.mauicc.hawaii.edu\r'),
(630, 'Georgia Institute of Cosmetology', 'GICSCHOOL.COM\r'),
(631, 'The University of Texas at Arlington', 'www.uta.edu\r'),
(632, 'Atlantic University College', 'www.atlanticcollege-pr.com\r'),
(633, 'Southeastern Oklahoma State University', 'www.se.edu\r'),
(634, 'South College', 'www.southcollegetn.edu\r'),
(635, 'Chowan University', 'www.chowan.edu/\r'),
(636, 'Ladera Career Paths Training Center', '446358\r'),
(637, 'Thiel College', 'www.thiel.edu\r'),
(638, 'Indiana University of Pennsylvania', 'www.iup.edu\r'),
(639, 'Cortiva Institute - Boston', 'www.mtiweb.edu\r'),
(640, 'Ohio Mid-Western College', 'www.ohiomidwestern.org\r'),
(641, 'Meredith College', 'www.meredith.edu\r'),
(642, 'Army Logistics University', 'www.almc.army.mil\r'),
(643, 'Bassett Adult School', 'www.bassett.k12.ca.us\r'),
(644, 'Middlebury College', 'www.middlebury.edu\r'),
(645, 'Viterbo University', 'www.viterbo.edu\r'),
(646, 'Harrison Career Institute - South Orange', 'hci.edu\r'),
(647, 'School for Allied Health Professionals', '483683\r'),
(648, 'Lorain County Community College', 'www.lorainccc.edu\r'),
(649, 'Everest Institute - Hayward', 'cci.edu\r'),
(650, 'United States Merchant Marine Academy', 'WWW.USMMA.EDU\r'),
(651, 'Langston University', 'www.lunet.edu\r'),
(652, 'Northern Illinois University', '147703\r'),
(653, 'Niagara County Community College', 'www.niagaracc.suny.edu\r'),
(654, 'Knox County Career Center', 'www.Kccc.K12.oh.us\r'),
(655, 'Southern New Hampshire University', 'www.snhu.edu\r'),
(656, 'Longwood University', 'www.longwood.edu\r'),
(657, 'Southern California Institute of Architecture', 'www.sciarc.edu\r'),
(658, 'New York College of Traditional Chinese Medicine', '439783\r'),
(659, 'International Sports Science Association', 'www.issaonline.edu\r'),
(660, 'West Tennessee Business College', 'www.wtbc.com\r'),
(661, 'Nevada Regional Technical Center', 'www.50states.com/cc/detail/mo/417673.htm\r'),
(662, 'Brooks College', 'www.brookscollege.edu\r'),
(663, 'Delaware College of Art and Design', 'www.dcad.edu\r'),
(664, 'Arkansas Northeastern College', 'www.anc.edu\r'),
(665, 'Pentecostal Theological Seminary', 'www.ptseminary.edu\r'),
(666, 'Thunderbird School of Global Management', 'www.t-bird.edu\r'),
(667, 'Academy of Massage & Bodywork', '451051\r'),
(668, 'Colorado Northwestern Community College', 'www.cncc.edu\r'),
(669, 'Coahoma Community College', 'www.coahomacc.edu\r'),
(670, 'Brandman University', 'www.brandman.edu\r'),
(671, 'Morrison Institute of Technology', 'www.morrison.tec.il.us\r'),
(672, 'Piedmont Virginia Community College', 'www.pvcc.edu\r'),
(673, 'Empire Beauty School - Pottstown', 'www.empire.edu\r'),
(674, 'Louisiana State University at Shreveport', 'www.lsus.edu/\r'),
(675, 'Shear Excellence Hair Academy', '451167\r'),
(676, '\"Xenon International Academy II', '407355\r'),
(677, 'Texas Health and Science University', '430704\r'),
(678, 'Sandusky Adult Education', 'www.sandusky-city.k12.oh.us\r'),
(679, 'Youngstown State University', 'www.ysu.edu\r'),
(680, 'Shawnee State University', 'WWW.SHAWNEE.EDU\r'),
(681, 'Ocean County College', 'www.ocean.edu/\r'),
(682, 'Gallipolis Career College', '205513\r'),
(683, 'Gould?s Academy', '486530\r'),
(684, 'Fisk University', 'www.fisk.edu\r'),
(685, 'Liberty University', 'www.liberty.edu\r'),
(686, 'Drexel University', 'www.drexel.edu\r'),
(687, 'Berks Career and Technolgy Center', 'www.berkscareer.com\r'),
(688, 'Medical Institute of Palm Beach', 'www.mipb.com\r'),
(689, 'International Beauty Academy', 'csbeautyschools.com\r'),
(690, 'Rich Mountain Community College', 'www.rmcc.edu\r'),
(691, 'Arnot Ogden Medical Center', 'www.aomc.org\r'),
(692, '\"Image Works Academy of Hair Design', '449825\r'),
(693, 'Aurora Health Care Southern Lakes CPE', 'www.aurora.org/cpe\r'),
(694, 'Orleans Technical Institute-Center City Campus', 'www.jevs.org/\r'),
(695, 'Waldorf College', 'www.waldorf.edu\r'),
(696, 'Philadelphia Child and Family Trng', 'www.philafamily.com\r'),
(697, 'Hamline University', 'www.hamline.edu\r'),
(698, 'Western Oregon University', 'www.wou.edu\r'),
(699, 'Southwest School of Business and Technical Careers', '228282\r'),
(700, 'Whitman College', 'www.whitman.edu\r'),
(701, 'Fairmont State University', 'www.fairmontstate.edu\r'),
(702, 'Lamar State College - Orange', 'www.lsco.edu\r'),
(703, 'Ancilla College', 'www.ancilla.edu\r'),
(704, 'Virginia School of Massage', 'www.vasom.com\r'),
(705, 'Angley College', '441399\r'),
(706, 'Healing Hands School of Holistic Health', '454795\r'),
(707, 'Deep Muscle Therapy School', 'www.dmtsmassage.com\r'),
(708, 'Central Wyoming College', 'www.cwc.edu\r'),
(709, 'Spring Hill College', 'www.shc.edu\r'),
(710, 'Gros Bonnet Culinary Academy', 'WWW.TIPHAWAII.COM\r'),
(711, 'New Hampshire Career Institute', 'www.nhcareerinstitute.org\r'),
(712, 'Colorado School of Trades', 'schooloftrades.com\r'),
(713, 'California Department of State Hospitals - Vacavil', 'www.dsh.ca.gov/vacaville/PsychologyInternshipProgr'),
(714, 'Randolph Community College', 'www.randolph.edu\r'),
(715, 'Hood College', 'www.hood.edu\r'),
(716, 'B.H. Carroll Theological Institute', 'www.bhcarroll.edu/\r'),
(717, '\"New Dimensions Beauty Academy', '04202600\r'),
(718, 'Westchester School of Beauty Culture', 'WSOBC\r'),
(719, 'Judson College', 'www.judson.edu\r'),
(720, 'Star Career Academy - Egg Harbor', 'starinstitute.com\r'),
(721, 'Asian American International Beauty College', 'www.aabeautycollege.com\r'),
(722, 'John Leland Center for Theological Studies', 'www.leland.edu/\r'),
(723, 'Massage Institute of Maryland', 'www.massageinstituteMD.com\r'),
(724, 'University of Pittsburgh - Main Campus', 'www.pitt.edu\r'),
(725, 'Tennessee College of Applied Technology - McKenzie', 'www.mckenzie.tec.tn.us\r'),
(726, 'Bluefield College', 'www.bluefield.edu\r'),
(727, 'Briar Cliff University', 'www.briarcliff.edu\r'),
(728, 'Sage College of Albany', 'www.sage.edu\r'),
(729, 'University of Oklahoma', '207500\r'),
(730, 'College of the Mainland', 'www.com.edu\r'),
(731, 'Art Instruction Schools', '173018\r'),
(732, 'Newbridge College-Stanton', 'www.mpcollege.com\r'),
(733, 'Robert E. Webber Institute for Worship Studies', 'www.iws.edu\r'),
(734, 'Nyack College', 'www.nyack.edu\r'),
(735, 'Harris School of Business - Cherry Hill', '184870\r'),
(736, 'Weber State University', 'www.weber.edu\r'),
(737, 'Lakeview College of Nursing', 'www.lakeviewcol.edu\r'),
(738, 'Rockford University', 'www.rockford.edu\r'),
(739, 'The Seattle School of Theology and Psychology', 'www.theseattleschool.edu\r'),
(740, 'Salem Community College', 'www.salemcc.edu\r'),
(741, 'University of the Incarnate Word', 'www.uiw.edu\r'),
(742, 'Absolute Safety Training Paramedic Program', 'www.absolutesafetytraining.org\r'),
(743, 'Baptist Health System School of Health Professions', 'www.bshp.edu\r'),
(744, 'University of Portland', 'www.up.edu\r'),
(745, 'Southeastern Baptist Theological Seminary', 'www.sebts.edu\r'),
(746, 'Casa Loma College', 'www.casalomacollege.com\r'),
(747, 'Washington University of Virginia', 'www.wuv.edu\r'),
(748, 'Midwestern Career College', '457536\r'),
(749, 'Fort Scott Community College', 'www.fortscott.edu\r'),
(750, 'Maryland Institute College of Art', 'www.mica.edu\r'),
(751, 'Eastwick College', 'www.hohokushackensack.com\r'),
(752, 'Earle C. Clements Job Corps Academy', 'www.jobcorps.org\r'),
(753, 'Barton College', 'www.barton.edu\r'),
(754, 'Vatterott College - Quincy', 'www.vatterott-college.edu\r'),
(755, 'Marymount Manhattan College', 'www.mmm.edu\r'),
(756, 'Norwich University', 'www.norwich.edu\r'),
(757, 'Seabury-Western Theological Seminary', 'www.seabury.edu/\r'),
(758, 'University of San Francisco', 'www.usfca.edu\r'),
(759, '\"In Session', '03815300\r'),
(760, 'Centenary University', 'www.centenarycollege.edu\r'),
(761, 'Ithaca College', 'www.ithaca.edu\r'),
(762, 'Nash Community College', 'www.nashcc.edu\r'),
(763, 'Tyler Junior College', 'www.tjc.edu\r'),
(764, 'University of Mount Olive', 'www.moc.edu\r'),
(765, 'W. G. Hefner VA Medical Center', 'www.salisbury.va.gov\r'),
(766, 'Toccoa Falls College', 'www.tfc.edu\r'),
(767, 'Saint Anthony College of Nursing', 'sacn.edu\r'),
(768, 'Cochran School of Nursing', 'WWW.RIVERSIDEHEALTH.ORG\r');

-- --------------------------------------------------------

--
-- Table structure for table `terms`
--

CREATE TABLE `terms` (
  `id` int(11) NOT NULL,
  `term` varchar(50) NOT NULL,
  `document_freq` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `doc`
--
ALTER TABLE `doc`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `email`
--
ALTER TABLE `email`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `schools`
--
ALTER TABLE `schools`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `terms`
--
ALTER TABLE `terms`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `schools`
--
ALTER TABLE `schools`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=769;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;