Datawrapper Map and Chart

I. Datawrapper Maps

  • Get an account at https://www.datawrapper.de/
  • Go to the NYC Department of Health COVID-19 Data Site.
  • Navigate to the GitHub data.
  • Select latest
  • Click on "hosp_death_last28days-by-modzcta.csv"
  • Click on Raw button in upper right hand corner
  • Save the browser window/file to your desktop as a CSV file.
  • Go to https://www.datawrapper.de/ and then Start Creating > New Map > Choropleth
  • Write New York City in the box that reads "What type of map do you want to create?"
  • Select NYC Zip Code
  • Click on Proceed
  • Click on the button in the lower left hand corner that says "Import Your Data"
  • Click on Alternatively, click here to upload a CSV-file. And upload your CSV file.
  • Confirm that Datawrapper matched the zip code accurately (It will be blue.) Next.
  • Please select which column in your dataset contains "Values". Select the third column, "hospitalization_28day_count" and Next
  • Click on Visualize
  • Make sure that the "Select column" has the correct column.
  • You can play around with the legend. You can try "steps" and you can also select different labels such as "range."
  • Go to Annotate. Give it a title. Add NYC Health Department to the "source" and the link to the data site.
  • Go to "Customize tooltips" and click in the header box. Delete the zip Code and instead click on {{ modzcta }}
  • Click in the second box and add the other items.
    {{ modzcta_name }}<br/>
    Hospitalizations: {{ hospitalization_count_28day }} <br/>
    Hospitalization rate: {{ hospitalization_rate_28day }}<br/>
    Deaths: {{ death_count_28day }}<br/>
    Death rate: {{ death_rate_28day }}
  • Add </br> after each line to add a line break. Next add the text labels before each.
  • Go to Publish and Embed. Click on Publish. Use the embed code in your blog post.

 

II. Datawrapper Chart

  • Go to the NYC Department of Health COVID-19 Data Site.
  • Navigate to the GitHub data.
  • Select latest
  • Click on "now-deaths-by-day.csv"
  • Click on Raw button in upper right hand corner
  • Save the browser window/file to your desktop as a CSV file.
  • Open the CSV file in Excel or Google
  • Clean data: remove everything except for All Deaths 7-Day Average for the City and Boroughs.
  • Delete everything before February. Save as a CSV file.
  • Go to https://www.datawrapper.de/ and then Start Creating > New Chart
  • Upload data
  • Check and describe
  • Visualize. Chart type. Column chart.
  • Annotate. Give it a title. Add NYC Health Department to the "source" and the link to the data site. Note: December 6 thru March 6
  • Go to Publish and Embed. Click on Publish. Use the embed code in your blog post.