In Progress

Insurance Data from Website

Brief Instructions for data collection: (Two companies’ results are shown as examples in the attached spreadsheet. Company codes are 10017 and 25178.)

1. Go to website: [url removed, login to view]

2. In the attached spreadsheet find the 5-digit “company code” from the third column for the first company, which is labeled as “CODE”. Input the company code in the starred input slot on the right hand side of the page. Click on the button “Find a Company”.

3. Double check if the company name is consistent with the column “CONAME” corresponding to the “code” chosen at the step 2. (If you cannot find the company, leave the whole row blank and move to the next row.)

4. On the middle-left hand side of this page, click on the link under Available Information that is labeled as “Closed Complaints”. On the new page, we need information from three different links. The three links are: “Closed Complaint Counts By State”; “Closed Complaint Counts By Code”; and “Closed Complaint Ratio Report”. Please input them in the attached Excel table Column E to MO. More specifically:

a) Click the “Closed Complaint Counts By State” link and go to the “Closed Complaint Counts By State Report:” page. Choose the year 2008 and then click the button labeled as “Create Report”. Input all the number in the “the Complaint Counts By State Report” into the attached Excel Table Spreadsheet “year2008” Column “E-BI”. This will be repeated for years 2009, 2010, and 2011. There is a separate page in the excel worksheet for each year of data.

b) Go back to the “Closed Consumer Complaint Reports:” page. Click the link “Closed Complaint Counts by Code”. In the third box, for which year would you like to see complaints” choose 2008. Input all the numbers in the “Number of Complaints by Coverage Type”, Reasons why Complaints were Submitted, and Final Decisions regarding complaints into the attached Excel Table Spreadsheet “year2008*” Column “BK-MC”. (Table “NUMBER OF COMPLAINTS BY COVERAGE TYPE” in Column “BK- HS”; Table “REASONS WHY COMPLAINTS WERE SUBMITTED” in Column “HU- LL”; Table “FINAL DECISIONS REGARDING COMPLAINTS” in Column “LN- MC”). Repeat this step for years 2009, 2010, 2011. Note that several columns are designed to having no number at all, i.e., BK, BL, CM, DC, DZ, ES, GM, GZ, HT, HU, HV, IO, JM, KM, LM and LN.

c) Go back to the closed consumer complaint reports. Click the link “Closed Complaint Ratio Report”. At the “Closed Complaint Ratio Report” page, choose all categories one by one “For which insurance type would you like to see complaints?” First choose commercial auto (if available). For which year - choose 2008. Click - create report. On the new page there will be box with a single red number in it. Put that number in the attached Excel table Column ME. Go back and repeat this process for each type of insurance (commercial liability, commercial property, etc.). Put this data in the subsequent columns after MF, MG, etc. Also, many firms will have missing values for some of these variables (e.g., if “commercial auto” is missing, please leave column ME of that row blank.). Repeat this process for years 2009 and 2010. Note that this data is not available for year 2011.

5. The database used to contain the same information for years 2005-2007. If that data becomes available please pull it as well. This additional work would be compensated as the same rate.

Skills: Data Entry, Excel, Web Scraping, Web Search

See more: insurance data excel, insurance data website, state auto insurance, pull data website excel, firms website, double data entry excel, double data entry, data entry worksheet, data entry process available, data entry insurance company, commercial rate, final data, row b, mf, ln, jm, io, insurance data, insurance company work, ht, gz, gm, create excel worksheet, complaints, bl

About the Employer:
( 35 reviews ) Singapore, Singapore

Project ID: #1304917

Awarded to:

aleolive

Please check your inbox.

$480 USD in 3 days
(14 Reviews)
6.0

38 freelancers are bidding on average $398 for this job

weblazer

Please check PMB for details

$400 USD in 10 days
(64 Reviews)
7.3
Dhruvika111

Dear DMREEB, Highly Experienced data entry team here...Please check your PM For Details. Thanks Dhruvika

$250 USD in 0 days
(132 Reviews)
7.0
NishantBamb

Hello, I am an expert data extractor. Please refer your Inbox for my experiences and more details. Thank you.

$500 USD in 7 days
(123 Reviews)
6.9
lafor

I've already written a scraping script for that and sent you sample data for first 150 companies.

$275 USD in 2 days
(117 Reviews)
6.6
greggfletcher

Hello, the project will be completed fast and efficiently. Regards.

$300 USD in 2 days
(61 Reviews)
6.5
srinichal

I am an expert in automation and look forward to deliver the same

$380 USD in 5 days
(31 Reviews)
6.1
ehsankayani

HI, i am an expert in automation and scrapping work , and here you require both skills.Ans have many samples to show. Kindly see PMB in details

$300 USD in 3 days
(31 Reviews)
5.8
panfreelancer

Hello, I understand it. Please check my sample in PMB. Is that good? Thanks in advance.

$450 USD in 15 days
(45 Reviews)
5.3
DataSOS

Hello Sir, We provide excellent web scraping and data services and applications. Please check private message for our proposal. - DataSOS

$415 USD in 10 days
(14 Reviews)
5.1
jyothi009

Please View PM

$285 USD in 2 days
(20 Reviews)
5.0
Johir08

Ready for start now.

$750 USD in 25 days
(13 Reviews)
5.0
ashok7925

Hi, Please check your PM for details.

$350 USD in 7 days
(18 Reviews)
4.8
stacross

We'd like to bid on your "Insurance Data from Website" project. Have a look at PM.

$750 USD in 0 days
(29 Reviews)
4.7
Game256

Hello, please check PMB

$380 USD in 2 days
(4 Reviews)
4.7
ganesharena

Dear, Ready to work. Check PMB. Thanks

$400 USD in 7 days
(1 Review)
4.6
freelance4hire80

Hi I've go thru your project description and did a quick study on the website for the data source. I can write a script to crawl and deliver the 2008-2011 data to you in ~4days.

$400 USD in 4 days
(13 Reviews)
4.6
Engineer85

Hi I am interested in doing this project. I have read through all your instructions and i can certainly do this work. Please check PM. Thanks

$600 USD in 6 days
(14 Reviews)
4.5
soner

I can offer my high quality web scraping services to you. Please contact if interested. I am expert.

$650 USD in 0 days
(4 Reviews)
4.2
meljackson72

November 22, 2011 DMREEB: Thank you for the opportunity to submit my proposal for your project "Insurance Data from Website". I have thoroughly reviewed your job description and believe that I possess the necessa More

$500 USD in 7 days
(4 Reviews)
3.9
jkumarsanson

Please refer my inbox

$250 USD in 4 days
(13 Reviews)
3.3