This is an R package to interact with Public Health England’s Fingertips data tool. Fingertips is a major public repository of population and public health indicators for England. The site presents the information in many ways to improve accessibility for a wide range of audiences ranging from public health professionals and researchers to the general public. The information presented is a mixture of data available from other public sources, and those that are available through user access agreements with other organisations. The source of each indicator presented is available using the indicator_metadata()
function.
This package can be used to load data from the Fingertips API into R for further use.
Get the latest released, stable version from CRAN:
You can install the latest development version from github using devtools:
# install.packages("devtools")
devtools::install_github("rOpenSci/fingertipsR",
build_vignettes = TRUE,
dependencies = "suggests")
Download this repository from GitHub and either build from source or do the following, that also requires devtools:
To install the package without the use of CRAN or devtools, download the .tar.gz
file and then run:
Where path_to_file
would represent the full path and file name.
This is an example of a workflow for downloading data for the indicator on Healthy Life Expectancy at Birth from the Public Health Outcomes Framework profile.
The profiles()
function presents all of the available profiles:
library(fingertipsR)
profs <- profiles()
profs <- profs[grepl("Public Health Outcomes Framework", profs$ProfileName),]
head(profs)
#> # A tibble: 6 x 4
#> ProfileID ProfileName DomainID DomainName
#> <int> <chr> <int> <chr>
#> 1 19 Public Health Outcomes Framework 1000049 Overarching indic~
#> 2 19 Public Health Outcomes Framework 1000041 Wider determinant~
#> 3 19 Public Health Outcomes Framework 1000042 Health improvement
#> 4 19 Public Health Outcomes Framework 1000043 Health protection
#> 5 19 Public Health Outcomes Framework 1000044 Healthcare and pr~
#> 6 19 Public Health Outcomes Framework 1938132983 Supporting inform~
This table shows that the ProfileID
for the Public Health Outcomes Framework is 19. This can be used as an input for the indicators()
function:
profid <- 19
inds <- indicators(ProfileID = profid)
print(inds[grepl("Healthy", inds$IndicatorName), c("IndicatorID", "IndicatorName")])
#> # A tibble: 2 x 2
#> IndicatorID IndicatorName
#> <int> <fct>
#> 1 90362 0.1i - Healthy life expectancy at birth: the average number~
#> 2 92543 2.05ii - Proportion of children aged 2-2½yrs offered ASQ-3 ~
Healthy Life Expectancy at Birth has the IndicatorID
equal to 90362.
Finally, the data can be extracted using the fingertips_data()
function using that IndicatorID
:
indid <- 90362
df <- fingertips_data(IndicatorID = indid)
head(df)
#> # A tibble: 6 x 24
#> IndicatorID IndicatorName ParentCode ParentName AreaCode AreaName
#> <int> <chr> <chr> <chr> <chr> <chr>
#> 1 90362 0.1i - Healthy l~ <NA> <NA> E920000~ England
#> 2 90362 0.1i - Healthy l~ <NA> <NA> E920000~ England
#> 3 90362 0.1i - Healthy l~ E92000001 England E120000~ North East~
#> 4 90362 0.1i - Healthy l~ E92000001 England E120000~ North West~
#> 5 90362 0.1i - Healthy l~ E92000001 England E120000~ Yorkshire ~
#> 6 90362 0.1i - Healthy l~ E92000001 England E120000~ East Midla~
#> # ... with 18 more variables: AreaType <chr>, Sex <chr>, Age <chr>,
#> # CategoryType <chr>, Category <chr>, Timeperiod <chr>, Value <dbl>,
#> # LowerCI95.0limit <dbl>, UpperCI95.0limit <dbl>,
#> # LowerCI99.8limit <dbl>, UpperCI99.8limit <dbl>, Count <dbl>,
#> # Denominator <dbl>, Valuenote <chr>, RecentTrend <chr>,
#> # ComparedtoEnglandvalueorpercentiles <chr>,
#> # Comparedtosubnationalparentvalueorpercentiles <chr>,
#> # TimeperiodSortable <int>
Please see the vignettes for information on use.