water-crisis-dash
Reporting on Twitter trending data related to the Cape Town water crisis or Corona
Water Dashboard
Reporting on Twitter trending data related to the Cape Town water crisis (Python3 Flask web server)
There is only one web page currently on this server. It is viewable at michaelcurrin.pythonanywhere.com. On a request, web server queries a SQLite database that contains trending topic data retrieved from the Twitter API. That data is added on a daily schedule using my twitterverse repo, which runs as a separate application and can be used to fetch either high-level trending topics or individual tweet data.
The data which is shown on the server is a filtered view of all the trending data which has been stored in my database over a few months. Therefore it is easy to broaden or narrow the query to displaying relevant data around the Cape Town water crisis, or to focus the query on a different topic in South Africa. It is also easy to broaden the query to other English-speaking locations for which I have daily data, since I retrieve data for many countries and cities in areas like United States and Europe.
Documentation
Resources
- Flask website or Flask read-the-docs site. This is the web server.
- Flask caching. This reduces queries to the database by caching the view. Built on Flask-Cache.
Future development
I have plans to expand the visualizations on the server using something like one of these: