[DB+Script] US Colleges Database + Script - 2k colleges, 101 fields each!

chatmasta · Aug 29, 2007

U.S. Colleges Database and Script

Hey,

I'm selling a massive database of US colleges and universities, information courtesy of US News. You also have the option of buying a script to go along with it. But before you read any further, why don't you check it out for yourself? It's the exact script that I'm selling here:

> ø default title - index page title ø <

The Database

Some key features of the database itself...

1,924 Colleges listed
101 fields for each college
Each college has 4 sections: overview, services and facilities, extracurriculars, and campus life

For more detailed information on the database, see here (way too many fields to put in a post): Colleges Database

The best place to see an example entry is on the example site.

And this is the structure of it:

Code:

-- phpMyAdmin SQL Dump
-- version 2.10.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Aug 29, 2007 at 08:24 PM
-- Server version: 4.1.22
-- PHP Version: 4.4.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `miles_colleges`
-- 

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

-- 
-- Table structure for table `campus_life`
-- 

CREATE TABLE `campus_life` (
  `college_id` int(11) NOT NULL default '0',
  `percent_undergrad_college_owned` varchar(10) NOT NULL default '',
  `percent_fraternity` varchar(10) NOT NULL default '',
  `percent_sorority` varchar(10) NOT NULL default '',
  `percent_campus_weekends` varchar(10) NOT NULL default '',
  `offer_housing` varchar(10) NOT NULL default '',
  `percent_students_college_housing` varchar(10) NOT NULL default '',
  `campus_housing` varchar(10) NOT NULL default '',
  `off_campus_assistance` varchar(10) NOT NULL default '',
  `types_available` text NOT NULL,
  `college_owned_singles` varchar(10) NOT NULL default '',
  `college_owned_doubles` varchar(10) NOT NULL default '',
  `college_owned_triples` varchar(10) NOT NULL default '',
  `college_owned_apartments` varchar(10) NOT NULL default '',
  `college_owned_other` varchar(10) NOT NULL default '',
  `num_college_owned` varchar(10) NOT NULL default '',
  `sprinkler_system` varchar(10) NOT NULL default '',
  `fire_alarms` varchar(10) NOT NULL default '',
  `high_speed_internet` varchar(10) NOT NULL default '',
  `campus_size` varchar(25) NOT NULL default '',
  `percent_weekends` varchar(50) NOT NULL default '',
  `nearest_airport` varchar(100) NOT NULL default '',
  `nearest_train` varchar(100) NOT NULL default '',
  `nearest_bus` varchar(100) NOT NULL default '',
  `public_transport` varchar(25) NOT NULL default '',
  `cars_permitted` varchar(10) NOT NULL default '',
  `percent_cars` varchar(10) NOT NULL default '',
  `school_employment` varchar(10) NOT NULL default '',
  `percent_undergrads_employed` varchar(10) NOT NULL default '',
  `average_undergrad_earnings` varchar(25) NOT NULL default '',
  `freshmen_discouraged_working` varchar(10) NOT NULL default '',
  `army_rotc` varchar(100) NOT NULL default '',
  `navy_rotc` varchar(100) NOT NULL default '',
  `airforce_rotc` varchar(100) NOT NULL default '',
  `alcohol_permitted` varchar(10) NOT NULL default '',
  `additional_policies` text NOT NULL,
  `popular_events` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `colleges`
-- 

CREATE TABLE `colleges` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `state_id` int(11) NOT NULL default '0',
  `address` varchar(255) NOT NULL default '',
  `website` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1925 ;

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

-- 
-- Table structure for table `extracurriculars`
-- 

CREATE TABLE `extracurriculars` (
  `college_id` int(11) NOT NULL default '0',
  `student_activities` text NOT NULL,
  `num_organizations` varchar(10) NOT NULL default '',
  `honor_societies` text NOT NULL,
  `religious_organizations` text NOT NULL,
  `international_organizations` text NOT NULL,
  `other_organizations` text NOT NULL,
  `student_papers` text NOT NULL,
  `num_frats` varchar(10) NOT NULL default '',
  `frats_chapter_houses` varchar(10) NOT NULL default '',
  `percent_frat_members` varchar(10) NOT NULL default '',
  `num_sororities` varchar(10) NOT NULL default '',
  `sororities_chapter_houses` varchar(10) NOT NULL default '',
  `percent_sorority_members` varchar(10) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `overview`
-- 

CREATE TABLE `overview` (
  `college_id` int(11) NOT NULL default '0',
  `type` varchar(50) NOT NULL default '',
  `year_founded` smallint(4) NOT NULL default '0',
  `religious_affiliation` varchar(50) NOT NULL default '',
  `academic_calendar` varchar(50) NOT NULL default '',
  `undergrad_body` varchar(15) NOT NULL default '',
  `setting` varchar(50) NOT NULL default '',
  `endowment` varchar(30) NOT NULL default '',
  `application_deadline` varchar(25) NOT NULL default '',
  `application_fee` varchar(4) NOT NULL default '',
  `selectivity` varchar(50) NOT NULL default '',
  `tuition` varchar(50) NOT NULL default '',
  `room_board` varchar(50) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `services`
-- 

CREATE TABLE `services` (
  `college_id` int(11) NOT NULL default '0',
  `basic` varchar(255) NOT NULL default '',
  `remedial` varchar(255) NOT NULL default '',
  `counseling` varchar(255) NOT NULL default '',
  `career` varchar(255) NOT NULL default '',
  `job_six_months` varchar(25) NOT NULL default '',
  `job_one_year` varchar(25) NOT NULL default '',
  `job_two_years` varchar(25) NOT NULL default '',
  `firms` varchar(255) NOT NULL default '',
  `library` varchar(10) NOT NULL default '',
  `library_consortia` varchar(10) NOT NULL default '',
  `num_books` varchar(25) NOT NULL default '',
  `num_subscriptions` varchar(25) NOT NULL default '',
  `num_microforms` varchar(25) NOT NULL default '',
  `num_audiovisual` varchar(25) NOT NULL default '',
  `num_ebooks` varchar(25) NOT NULL default '',
  `library_facilities` text NOT NULL,
  `museums` text NOT NULL,
  `computer_course` varchar(10) NOT NULL default '',
  `own_computer` varchar(10) NOT NULL default '',
  `computers_available` varchar(10) NOT NULL default '',
  `email_accounts` varchar(10) NOT NULL default '',
  `internet_access` varchar(50) NOT NULL default '',
  `computers_available_in` varchar(255) NOT NULL default '',
  `num_wired_library` varchar(10) NOT NULL default '',
  `num_wired_classrooms` varchar(10) NOT NULL default '',
  `num_wired_labs` varchar(10) NOT NULL default '',
  `num_wired_other` varchar(10) NOT NULL default '',
  `wireless_network` varchar(10) NOT NULL default '',
  `wireless_areas` text NOT NULL,
  `wireless_capacity` varchar(10) NOT NULL default '',
  `recommended_os` varchar(10) NOT NULL default '',
  `hosting_units` varchar(10) NOT NULL default '',
  `student_webpages` varchar(10) NOT NULL default '',
  `online_registration` varchar(10) NOT NULL default '',
  `campus_safety` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `states`
-- 

CREATE TABLE `states` (
  `id` int(11) NOT NULL auto_increment,
  `state` varchar(50) NOT NULL default '',
  `abb` char(2) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;

chatmasta · Aug 29, 2007

(exceeded character limit)

The Script

As I said above, you can see a demo of the script here: ø default title - index page title ø

It's one of the best database scripts you'll find, and I put a fair number of hours into it. Some key features:

Easily customizable template: the default included template is designed to be simple to edit. You can change it in style.css, and other than that just have to edit the header and footer files. The PSD for the logo is also included.
Search colleges, browse alphabetically, or by state. The user interface is superb, allowing them to find a college in three different ways. The state page includes a clickable map.
AdSense optimiazation. The pages are perfectly optimized for AdSense. There's a skyscraper on every page, and up to 3 of them when the page length requires it. Each college page and state/letter page also has a 336x280 block well-integrated into the content. You'll find you get a high CTR with this layout.

Perhaps the best feature of the script, though, is just how well optimized it is for the search engines. It employs the best SEO tactics you can find without stepping into Blackhat. More info...

Optimized URLs. mod_rewrite is used to make the URLs as search engine friendly as possible, both structure wise and keyword wise. Link structure is also optimized for maximum crawlability.
Sitemap. Although I can't provide you an XML sitemap without your domain, there is a PHP sitemap that will bring spiders to all the pages on your site. I also recommend you generate an XML sitemap and submit it to Google and Yahoo.
BIGGEST FEATURE. Every page has a unique title, keywords, meta description, and "hidden" header (text-indent:-1000px; - if you don't want this you can remove it) tailored specifically to that page. So MIT's page isn't "College Information," but rather "services and facilities at MIT (MA)." This has an unbelievable effect on SEO. Best of all, you can edit these values from one spot.

This script is so well optimized that all you really need to do is point some links to it and you'll begin to rank. I would also recommend buying the script simply because the database is very large and has some complicated database structure - take it from me, it's a pain to write out all 101 of those field names!

Pricing
Database: $29
Database and Script: $39

If you are interested in buying, please PM me or post here for payment details (paypal).

bajan · Sep 23, 2007

Can i still get this if so send details also do you have anything new?

emp · Sep 24, 2007

PM sent with some inquiries.
::emp::

chatmasta · Oct 7, 2007

This is still for sale, along with the others. Just FYI.

tornado · Oct 15, 2007

PM sent. Also, let me know what other databases are available.

Search

Search

[DB+Script] US Colleges Database + Script - 2k colleges, 101 fields each!

chatmasta

Well-known member

chatmasta

Well-known member

bajan

New member

emp

New member

chatmasta

Well-known member

tornado

New member