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

chatmasta · 08-29-2007, 11:51 PM

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 · 08-29-2007, 11:52 PM

(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 · 09-23-2007, 09:23 PM

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

emp · 09-24-2007, 04:48 AM

PM sent with some inquiries.
::emp::

chatmasta · 10-07-2007, 09:14 PM

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

tornado · 10-15-2007, 07:38 PM

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

08-29-2007, 11:52 PM	#2 (permalink)
chatmasta Senior Member Join Date: Jan 2007 Location: NH, Connecticut Posts: 2,358 iTrader: 18 / 100%	(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). Share Share this post on Digg Del.icio.us Technorati Twitter __________________ LOTS OF PROXIES AVAILABLE! New servers just added. Seriously, no bullshit. PM me with any questions.

09-23-2007, 09:23 PM	#3 (permalink)
bajan Junior Member Join Date: Jul 2007 Posts: 2 iTrader: 0 / 0%	Can i still get this if so send details also do you have anything new? Share Share this post on Digg Del.icio.us Technorati Twitter

09-24-2007, 04:48 AM	#4 (permalink)
emp Join Date: Jun 2006 Posts: 5,818 iTrader: 17 / 100%	PM sent with some inquiries. ::emp:: Share Share this post on Digg Del.icio.us Technorati Twitter __________________ Get your own Bot army! Use promo code blindape199 That's because all programmers are also ninjas.(but not all ninjas are programmers) - LogicFlux Blind Ape Seo

10-07-2007, 09:14 PM	#5 (permalink)
chatmasta Senior Member Join Date: Jan 2007 Location: NH, Connecticut Posts: 2,358 iTrader: 18 / 100%	This is still for sale, along with the others. Just FYI. Share Share this post on Digg Del.icio.us Technorati Twitter __________________ LOTS OF PROXIES AVAILABLE! New servers just added. Seriously, no bullshit. PM me with any questions.

10-15-2007, 07:38 PM	#6 (permalink)
tornado Member Join Date: Jun 2007 Posts: 41 iTrader: 1 / 100%	PM sent. Also, let me know what other databases are available. Share Share this post on Digg Del.icio.us Technorati Twitter __________________

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode