Dashboard for tracking the spread of Monkeypox. Check it out here.
Note: Daily batch load is currently suspended. Dashboard was last updated September 9, 2022.
The dashboard is designed to update daily with the latest reported monkeypox cases. The ETL is as follows.
The Lambda function executes a Python script containing all business logic. Amazon EventBridge provides a scheduled time as the trigger. This is effectively a serverless cron job.
The Python script executed by AWS Lambda does the following:
- Submits a GET request to a URL on this GitHub repo containing a JSON file (which is no longer being uploaded)
- Converts it into a Pandas dataframe and prepares it for loading
- Loads it into a PostgreSQL database hosted on Amazon RDS
Credits to Global.health for maintaining the source data.