Collect data from twitter on COVID-19 since Jan 1, 2020 to May 12, 2020 in Python. Identify different sub-topics (i.e. "threat of an outbreak in US", "testing", "how virus is transmitted", "drugs to...

Collect data from twitter on COVID-19 since Jan 1, 2020 to May 12, 2020 in Python.

Identify different sub-topics (i.e. "threat of an outbreak in US", "testing", "how

virus is transmitted", "drugs to cure", "availability of vaccine", "trump performance" etc....other sub-topics to be

identified.

You can create a database called COVID-19. Then create a database table with the subtopics and all twitter user features.

We want to collect all the information relating to a tweet. For example,

1. who tweeted

2. date tweeted

3. followers

4. was tweet retweeted

5. etc.....

What to submit1. Python code2. SQL code to create the database and tables3. Sample output that shows the main sub-topics for COVID-19. Maybe a tag-cloud4. Simple interface that allows us to search content from the database5. All the data in the database