Home | How it works | Projects archive | Contact Us
Air Compressor Bot 		 
The Career Path of Freelance Programming Jobs 

   Data Gathering
Bidding Time:
06/04/2008 23:02 - 08/04/2008 00:00
Budget:
$30-250
Status:
 Closed

Job Type:
PHP, Data Entry, Web Promotion, Data Processing, Market Research
Description:
I am collecting data for foreigners who want to come to America and learn
English. I need someone to do extensive searches on Google and other search
engines and develop lists. Here is a summary of the types of lists I'm looking
for.

A) ESL Schools - ESL schools teach English to foreigners and immigrants. They
are private and public companies. I want 500 private companies contact
information. (quantity is negotiable depending on what is actually available in
the US, UK, AU, and NZ.

B) Immigration Lawyers - This is an easy one to find. Find 500 immigration
lawyer contacts in the US, UK, AU, and NZ. I need at least 15 for UK, AU and
NZ.

C) Home stay Agencies - Home stay is for students usually elementary schools
through high school want to stay in an English speaking country and go to
school. host families will bring them to school and provide housing and food.
Please find contact information for 500 companies in US, UK, AU and NZ.

This data must be formatted in a sql executable file for insertion. Below is
the table creation commands. You should collect the data and put it in this
format.

CREATE TABLE IF NOT EXISTS `agencies` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`contact` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`phone` varchar(15) NOT NULL,
`address` varchar(100) NOT NULL,
`city` varchar(100) NOT NULL,
`state` varchar(100) default NULL,
`zip` varchar(10) NOT NULL,
`country` varchar(100) default NULL,
`factsheet` text NOT NULL,
`url` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `lawyers` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`contact` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`phone` varchar(15) NOT NULL,
`address` varchar(100) NOT NULL,
`city` varchar(100) NOT NULL,
`state` varchar(100) default NULL,
`zip` varchar(10) NOT NULL,
`country` varchar(100) default NULL,
`factsheet` text NOT NULL,
`url` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `esl_schools` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`contact` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`phone` varchar(15) NOT NULL,
`address` varchar(100) NOT NULL,
`city` varchar(100) NOT NULL,
`state` varchar(100) default NULL,
`zip` varchar(10) NOT NULL,
`country` varchar(100) default NULL,
`factsheet` text NOT NULL,
`url` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
);

These are the tables that will need to be populated. If you do a good job on
the first project there will be two more. Your data must be accurate. I have
written programs to authenticate your work.




Get $20 Off Panda Internet Security 2008. Coupon Code: WOWPISUSD20.

Related Projects:
Manual Directory Submissions
Wp Age Verification Plugin
Css compressor clone
Joomla site Edit
Add 2 Payment Gateways

This project is the proprietary information of . Click here to remove this project from OUR database.
Operating System:
 Linux
Database System:
 MySQL
<<< back

Recent Projects Archive:

Friday - Thursday - Wednesday - Tuesday - Monday - Sunday - Saturday

View all freelance web projects
 
Home | Projects archive | RSS | Resources | Links | Contact Us © 2004-2009 ProjectsList.biz /0.067