Hospital Contact Details Research and Verification

Job ID: 38153148

Budget: $30 – $250 USD

Objective:
To research and fill in all the addresses, zip codes, phone numbers, site URLs, main email addresses, and the county for each hospital listed in the provided Excel spreadsheet for Arizona, California, Colorado, and Texas. The Excel spreadsheet currently contains the Hospital Names, Cities, and States they are located. There are approximately 860 facilities.

You may retrieve this information from the U.S. Department of Health & Human Services website, where they have an API function that allows the use of a Python script to cull the data.

Deliverables:
A fully completed Excel spreadsheet with the following columns accurately filled for each hospital in the specified states:

Address
Zip Code
Phone Number
Site URL
Main Email Address
County

Instructions:
Download the Provided Spreadsheet:
Open the provided Excel file named US Hospital Lists By State.xlsx.

Identify Target States:
Focus only on the hospitals listed in Arizona, California, Colorado, and Texas.

Research Information:
Gather the necessary information using reliable sources such as official hospital websites, healthcare directories, and other trusted online resources.

Fill in the Spreadsheet:
For each hospital, enter the following details in the respective columns:
Address: The full physical address of the hospital.
Zip Code: The zip code associated with the hospital's address.
Phone Number: The main contact number for the hospital.
Site URL: The URL of the hospital's official website.
Main Email Address: The primary email address for general inquiries (if available).
County: The county where the hospital is located.

Verification:
Ensure all the information entered is accurate and up-to-date. Double-check the details to avoid any errors.

Submission:
Once all the information is filled in, save the updated Excel file.
Submit the completed spreadsheet via the Freelancer.com platform.

Notes:
Prioritize official sources to ensure the accuracy of the information.
If certain information is unavailable (e.g., main email address), note it in the spreadsheet.
Attention to detail is crucial for this project.

Deadline:
The completed spreadsheet must be submitted by May 30th, 2024, at 5 pm Pacific Daylight Time.

Communication:
Please contact me via the Freelancer.com messaging system for any questions or clarifications.
Thank you for your attention to detail and hard work on this project.
Related categories: Python Data Entry Excel Web Scraping Data Mining