Tables of USA COVID-19 Policy Orders

2020 RStudio Table Contest Submission

Background

Created for the 2020 Rstudio Table Contest. The table below takes advantage of the following features from the DT package:

• cell background coloring
• font colors
• bold font
• copy and download buttons
• number entries dropdown menu for user selection
• term search feature
• column filters
• column reordering
• responsive table to handle window resize

Data was downloaded from healthdata.gov on October 23, 2020.

• COVID-19 State and County Policy Orders Dataset

• COVID-19 State and County Policy Orders Data Dictionary

HHS states that is a manually curated dataset which provides a standardized view into state and county policy orders (executive orders, ordinances, etc.) from the following sources:

• BU COVID-19 State Policy Database - Raifman J, Nocka K, Jones D, Bor J, Lipson S, Jay J, and Chan P. (2020). “COVID-19 US state policy database.”
• wikidata - Stay At Home Policies Queried from WikiData
• Manual curation by a dedicated group of Virtual Student Federal Service Interns - Summer 2020: T Adler, J Bastian, L Beckett, M Cohen, K Honey, C Kennedy, E Nudell

Table created using DT, Tidyverse, and RColorBrewer packages. State maps sourced from Civil Services Github Repository.

Tables

State Policy Orders

County Policy Orders

Sources

The following sources were consulted in building this submission.

• https://rstudio.github.io/DT/
• https://www.youtube.com/watch?v=yott4quKN6s&ab_channel=LanderAnalytics
• https://stackoverflow.com/questions/53265769/dtdatatables-generated-html-table-shows-display-anomalies-missing-character
• https://data-se.netlify.app/2019/01/14/a-clean-sessioninfo-page/
• https://healthdata.gov/dataset/covid-19-state-and-county-policy-orders
• https://github.com/CivilServiceUSA/us-states

Source code

• Github repo here

Session Info

• OS: Windows 10 x64
• Version: R version 4.0.2 (2020-06-22)
• Date: 2020-10-24
• Packages: assertthat 0.2.1, backports 1.1.7, blob 1.2.1, broom 0.7.0, cellranger 1.1.0, cli 2.0.2, colorspace 1.4-1, crayon 1.3.4, crosstalk 1.1.0.1, curl 4.3, DBI 1.1.0, dbplyr 1.4.4, digest 0.6.25, dplyr 1.0.0, DT 0.15, ellipsis 0.3.1, evaluate 0.14, fansi 0.4.1, forcats 0.5.0, fs 1.4.2, generics 0.0.2, ggplot2 3.3.2, glue 1.4.1, gtable 0.3.0, haven 2.3.1, hms 0.5.3, htmltools 0.5.0, htmlwidgets 1.5.1, httr 1.4.2, jsonlite 1.7.0, knitr 1.29, lifecycle 0.2.0, lubridate 1.7.9, magrittr 1.5, modelr 0.1.8, munsell 0.5.0, pillar 1.4.6, pkgconfig 2.0.3, purrr 0.3.4, R6 2.4.1, RColorBrewer 1.1-2, Rcpp 1.0.5, readr 1.3.1, readxl 1.3.1, reprex 0.3.0, rlang 0.4.7, rmarkdown 2.3, rstudioapi 0.11, rvest 0.3.6, scales 1.1.1, sessioninfo 1.1.1, stringi 1.4.6, stringr 1.4.0, tibble 3.0.3, tidyr 1.1.0, tidyselect 1.1.0, tidyverse 1.3.0, vctrs 0.3.2, withr 2.2.0, xfun 0.15, xml2 1.3.2, yaml 2.2.1