This work displays US unemployment data from 2019 through the present day and COVID-19 case data for all of 2020 in a responsive browser dashboard. Its primary feature is a map that can toggle between these two data sets, broken down by state and visualized using a color-coded gradient system. Each state's total number of unemployment claims, COVID cases, or COVID deaths for a user-selected period of time will display as an aggregate - that is, the entirety of any given state will be represented as a single color.

Code for the COVID-19 map layers was adapted from our collaborator Jesse Caldwell's personal repository: https://github.com/CollectionOfAtoms/covid_visualization.

Data may be filtered by custom date ranges and a custom multi-select state menu (rendering data for any single state or possible combination of multiple states). This dashboard also contains line graph visualizations for both total claim numbers and unemployment rates, responsive to the same combinations of filters above. All dashboard interfaces update in unison in response to user input.

Linked on the navigation bar, there is an additional data table allowing the user to browse our raw numerical data.

https://oui.doleta.gov/unemploy/claims.asp

The above link provided us with our raw US unemployment data as a .csv. As this source is updated, we will download new data packets and store them in our SQLite database, represented in JSON format. Our Python Flask app queries this database with values tethered to dashboard user input.

Our COVID data is pulled from a publically hosted RapidAPI: https://rapidapi.com/axisbits-axisbits-default/api/covid-19-statistics

Here you can find the Flask app public repo: https://github.com/rose-gonoud/COVID-Unemployment-HerokuAPI, and our Heroku-hosted interface: https://unemployment-during-covid19.herokuapp.com/

• Download the data sets from the the unemployment database for every state's data from
• Create a Mongo or SQL database with a single entry per line
• Create a Logo for the page

• Get data set from Christian
• Convert SQL database to SQLlite using SQLAlchemy
• Create a Python flask app that reads from the database.
• Set up API routes with optional query parameters that execute the corresponding SQL query, and return only that subset of results.

• Create a dashboard layout that visualizes the unemployment data in whatever ways seem good.
  • Create a mock-up of the main dashboard.
  • Create Index.js with places for each chart that we want
  • Create start date and end date selectors in the HTML (Two tick slider maybe?)
  • Create state selector in HTML (consider a multiselect field)
  • Display statistics section (max applications in range, min applications in range)
  • Doubling Rate?
  • "Data" page with filters that shows table of visualized data

• Work on creating a map visualization that can change the color value of each state according to a numeric value
• Line Chart

• Check up on our .gitignore, and the security vulnerabilities identified by GitHub
• Project Ops. Help with any questions from any team member.
• Handle Git Merges, etc
• Collect other data that we may wish to correlate (Covid, Stock market)

• Use onChange listeners in D3 to send out queries to Rose's API based on the values of those filters using the d3.json() function
• Page CSS
• "Sources" page that reveals all sources of information
• "About" page that credits the creators