The goal is to extract the data from social media using python codes for web scrapping and create a SQL database to store and manage the data gathered. Work with sentiment analysis team to locate potential scraping targets for sentiment analysis and also Work with Dashboards team to locate potential targets for insight (news site scraping, headlines, trending hashtags, trending topics). This is required to build an ecosystem analysis.

1. Design and creation of the database schema, including the establishment of tables, relationships, and indexes.
2. How sentiments and concerns related to climate change impacts vary across regions.
3. Identify relevant sources for data and information

Deliverables:

1. Data extraction code.
2. The data used to carry out the analysis.
3. Documentation on the process followed.
4. Loading the data into SQL database.
5. A comprehensive report for the approach taken for the project, the observations, and conclusions.

The collaborator has the following responsibilities within the project:

• Provide dataset to faculty and students
• Communicate with students regarding projects in a timely manner. This may be in the form of in-person, email, telephone or video conference
• Attend kick-off meeting with students, review proposal and attend the final presentation (accommodations can be made if in-person is not possible, example: video conference)