Data Gathering

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.