rads.data

Purpose

RADS, APDE’s ‘R Automated Data System, is a suite of tools written in R and designed to make standard public health analyses faster, more standardized, and less prone to error. The rads.data package contains public health data that is either used by RADS or that might be useful for pre- or post-processing RADS data.

Installation

If you haven’t yet installed rads.data, follow these steps:

1. Make sure devtools is installed … install.packages("devtools").

2. Install rads.data … devtools::install_github("PHSKC-APDE/rads.data", auth_token = NULL)

3. Exit RStudio and start it again.

4. Confirm rads.data installed properly by typing library(rads.data) in the console.

Getting started

As of February 3, 2022, this package contains data.tables from the following thematic areas:

1. icd << reference tables of ICD 10 codes for causes of death and hospitalizations.

2. occupation << BLS Standard Occupational Classification (SOC) codes for the 2010 and 2018 systems.

3. population << mostly reference standard populations used for age adjustment.

4. spatial << crosswalk files between different levels of WA, King County, and Seattle geographies.

   • Note: this does not contain shape files.
   • Note: please view the spatial file README and or the help files if you are confused as to which files you should use.

All of the data.tables are prefixed by their thematic area, i.e., every table begins with spatial_, or population_, or occupation_, or icd_.

Once the package has been loaded, you can import the table of interest into memory by simply typing data(table.name). For example, typing data(spatial_zip_to_hra20_geog) will import the 'spatial_zip_to_hra20_geog' data.table. If you want to know which tables are available, it easiest to type rads.data:: and then the thematic area prefix (e.g., rads.data::icd_) into the console and scroll through the available options. If you scroll slowly, descriptions should pop up on in a small window. If you want to see the full documentation for a specific table, type ?table.name. For example, ?icd_nchs113causes.

Finally, if you need a CSV to share the data with non-R users, you can point them to inst/extdata. This folder contains CSV copies of the R data files. When updating this package, all updates should be performed using the copying code which can properly save .csv versions of .rda files and vice versa.

A quick reminder regarding Census geographies

Census GEOIDs have the following structure:

Area	GEOID Structure	Digits	Example Area	Example GEOID
State	STATE	2	WA	53
County	STATE+COUNTY	2+3=5	King County, WA	53 033
Census Tract	STATE+COUNTY+TRACT	2+3+6=11	Tract 11001 in King County	53 033 011001
Block Group	STATE+COUNTY+TRACT+BLOCK GROUP	2+3+6+1=12	Block Group 2 in Tract 11001	53 033 011001 2
Block	STATE+COUNTY+TRACT+BLOCK	2+3+6+4=15	Block 2006 in Tract 11001 in	53 033 011001 2006

Adding files and or thematic areas

If you want to add files or thematic areas, PLEASE create a new branch and then submit a pull request.

Problems & suggestions?

If you notice something that is incorrect, know a data source that you'd like to add, or have a suggestion for improvement, please let us know. Click on "Issues" at the top of this page and then click "New Issue" and provide the necessary details.