The fingertipsR library is useful tool developed by Public Health England to access Fingertips data within R directly. Fingertips is a major public repository of population and public health indicators for England. Unfortunately the site is sometimes very hard to navigate, especially if you want to download a specific dataset. Fortunately, this library makes this task much easier.
In the sections below I will show you briefly how to use the library in order to find and download data in R for further analysis.
Very briefly, libraries (also known as packages) are essentially a collection of functions that once loaded provide R with extra functionality, or just make your life easier - think of it as plugins, as you may have seen in other software. In order for them to work, you have to download them first. You only need to do this once.
Thankfully you can download and install libraries very easily within RStudio from the [Tools] menu, by going to Tools>Install Packages… and type in the search box “fingertipsR”. Select it and click [Install].
However, in order to use it in any given session who must tell R that we want to use the library each time. We can load the necessary library using the following code:
# Load library
library(fingertipsR)The main function that we will use is the fingertips_data() function. This will download a data frame directly from Fingertips, based on our specifications. Note, this function can take up to a few minutes to run (depending on internet connection speeds and parameter selection). Here is an example of getting data about Mortality rate from lung cancer in England:
# Get data
fingertips_data(IndicatorID = 1203, AreaTypeID = 15)## IndicatorID IndicatorName ParentCode ParentName AreaCode AreaName AreaType Sex Age CategoryType Category Timeperiod Value LowerCI95.0limit UpperCI95.0limit LowerCI99.8limit UpperCI99.8limit Count Denominator Valuenote RecentTrend ComparedtoEnglandvalueorpercentiles ComparedtoUKvalueorpercentiles TimeperiodSortable Newdata Comparedtogoal
## 1 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2001 - 03 93.44600 92.59659 94.30111 NA NA 49011 72886051 <NA> <NA> Not compared Not compared 20010000 <NA> <NA>
## 2 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2001 - 03 45.44466 44.94447 45.94900 NA NA 32044 76168479 <NA> <NA> Not compared Not compared 20010000 <NA> <NA>
## 3 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2001 - 03 65.13407 64.68491 65.58556 NA NA 81055 149054530 <NA> <NA> Not compared Not compared 20010000 <NA> <NA>
## 4 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2001 - 03 93.44600 92.59659 94.30111 NA NA 49011 72886051 <NA> <NA> Similar Not compared 20010000 <NA> <NA>
## 5 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2001 - 03 45.44466 44.94447 45.94900 NA NA 32044 76168479 <NA> <NA> Similar Not compared 20010000 <NA> <NA>
## 6 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2001 - 03 65.13407 64.68491 65.58556 NA NA 81055 149054530 <NA> <NA> Similar Not compared 20010000 <NA> <NA>
## 7 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2002 - 04 90.62906 89.79900 91.46471 NA NA 48192 73293998 <NA> <NA> Not compared Not compared 20020000 <NA> <NA>
## 8 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2002 - 04 45.52756 45.02800 46.03125 NA NA 32283 76505386 <NA> <NA> Not compared Not compared 20020000 <NA> <NA>
## 9 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2002 - 04 64.12936 63.68515 64.57590 NA NA 80475 149799384 <NA> <NA> Not compared Not compared 20020000 <NA> <NA>
## 10 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2002 - 04 90.62906 89.79900 91.46471 NA NA 48192 73293998 <NA> <NA> Similar Not compared 20020000 <NA> <NA>
## 11 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2002 - 04 45.52756 45.02800 46.03125 NA NA 32283 76505386 <NA> <NA> Similar Not compared 20020000 <NA> <NA>
## 12 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2002 - 04 64.12936 63.68515 64.57590 NA NA 80475 149799384 <NA> <NA> Similar Not compared 20020000 <NA> <NA>
## 13 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2003 - 05 88.29347 87.47945 89.11303 NA NA 47501 73787882 <NA> <NA> Not compared Not compared 20030000 <NA> <NA>
## 14 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2003 - 05 45.85225 45.35219 46.35640 NA NA 32703 76938269 <NA> <NA> Not compared Not compared 20030000 <NA> <NA>
## 15 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2003 - 05 63.37527 62.93536 63.81749 NA NA 80204 150726151 <NA> <NA> Not compared Not compared 20030000 <NA> <NA>
## 16 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2003 - 05 88.29347 87.47945 89.11303 NA NA 47501 73787882 <NA> <NA> Similar Not compared 20030000 <NA> <NA>
## 17 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2003 - 05 45.85225 45.35219 46.35640 NA NA 32703 76938269 <NA> <NA> Similar Not compared 20030000 <NA> <NA>
## 18 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2003 - 05 63.37527 62.93536 63.81749 NA NA 80204 150726151 <NA> <NA> Similar Not compared 20030000 <NA> <NA>
## 19 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2004 - 06 86.63105 85.83233 87.43521 NA NA 47278 74337867 <NA> <NA> Not compared Not compared 20040000 <NA> <NA>
## 20 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2004 - 06 46.49723 45.99495 47.00359 NA NA 33337 77427953 <NA> <NA> Not compared Not compared 20040000 <NA> <NA>
## 21 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2004 - 06 63.10890 62.67200 63.54808 NA NA 80615 151765820 <NA> <NA> Not compared Not compared 20040000 <NA> <NA>
## 22 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2004 - 06 86.63105 85.83233 87.43521 NA NA 47278 74337867 <NA> <NA> Similar Not compared 20040000 <NA> <NA>
## 23 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2004 - 06 46.49723 45.99495 47.00359 NA NA 33337 77427953 <NA> <NA> Similar Not compared 20040000 <NA> <NA>
## 24 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2004 - 06 63.10890 62.67200 63.54808 NA NA 80615 151765820 <NA> <NA> Similar Not compared 20040000 <NA> <NA>
## 25 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2005 - 07 85.41790 84.63209 86.20908 NA NA 47349 74964866 <NA> <NA> Not compared Not compared 20050000 <NA> <NA>
## 26 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2005 - 07 47.70092 47.19445 48.21143 NA NA 34528 77987447 <NA> <NA> Not compared Not compared 20050000 <NA> <NA>
## 27 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2005 - 07 63.36872 62.93344 63.80625 NA NA 81877 152952313 <NA> <NA> Not compared Not compared 20050000 <NA> <NA>
## 28 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2005 - 07 85.41790 84.63209 86.20908 NA NA 47349 74964866 <NA> <NA> Similar Not compared 20050000 <NA> <NA>
## 29 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2005 - 07 47.70092 47.19445 48.21143 NA NA 34528 77987447 <NA> <NA> Similar Not compared 20050000 <NA> <NA>
## 30 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2005 - 07 63.36872 62.93344 63.80625 NA NA 81877 152952313 <NA> <NA> Similar Not compared 20050000 <NA> <NA>
## 31 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2006 - 08 84.62799 83.85191 85.40933 NA NA 47676 75613149 <NA> <NA> Not compared Not compared 20060000 <NA> <NA>
## 32 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2006 - 08 48.69473 48.18542 49.20805 NA NA 35612 78548983 <NA> <NA> Not compared Not compared 20060000 <NA> <NA>
## 33 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2006 - 08 63.63496 63.20136 64.07078 NA NA 83288 154162132 <NA> <NA> Not compared Not compared 20060000 <NA> <NA>
## 34 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2006 - 08 84.62799 83.85191 85.40933 NA NA 47676 75613149 <NA> <NA> Similar Not compared 20060000 <NA> <NA>
## 35 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2006 - 08 48.69473 48.18542 49.20805 NA NA 35612 78548983 <NA> <NA> Similar Not compared 20060000 <NA> <NA>
## 36 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2006 - 08 63.63496 63.20136 64.07078 NA NA 83288 154162132 <NA> <NA> Similar Not compared 20060000 <NA> <NA>
## 37 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2007 - 09 83.30653 82.54328 84.07495 NA NA 47779 76269291 <NA> <NA> Not compared Not compared 20070000 <NA> <NA>
## 38 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2007 - 09 48.89613 48.38856 49.40766 NA NA 36183 79124036 <NA> <NA> Not compared Not compared 20070000 <NA> <NA>
## 39 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2007 - 09 63.27102 62.84145 63.70279 NA NA 83962 155393327 <NA> <NA> Not compared Not compared 20070000 <NA> <NA>
## 40 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2007 - 09 83.30653 82.54328 84.07495 NA NA 47779 76269291 <NA> <NA> Similar Not compared 20070000 <NA> <NA>
## 41 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2007 - 09 48.89613 48.38856 49.40766 NA NA 36183 79124036 <NA> <NA> Similar Not compared 20070000 <NA> <NA>
## 42 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2007 - 09 63.27102 62.84145 63.70279 NA NA 83962 155393327 <NA> <NA> Similar Not compared 20070000 <NA> <NA>
## 43 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2008 - 10 81.55000 80.80337 82.30169 NA NA 47716 76946002 <NA> <NA> Not compared Not compared 20080000 <NA> <NA>
## 44 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2008 - 10 48.93136 48.42652 49.44012 NA NA 36631 79708684 <NA> <NA> Not compared Not compared 20080000 <NA> <NA>
## 45 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2008 - 10 62.64111 62.21676 63.06761 NA NA 84347 156654686 <NA> <NA> Not compared Not compared 20080000 <NA> <NA>
## 46 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2008 - 10 81.55000 80.80337 82.30169 NA NA 47716 76946002 <NA> <NA> Similar Not compared 20080000 <NA> <NA>
## 47 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2008 - 10 48.93136 48.42652 49.44012 NA NA 36631 79708684 <NA> <NA> Similar Not compared 20080000 <NA> <NA>
## 48 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2008 - 10 62.64111 62.21676 63.06761 NA NA 84347 156654686 <NA> <NA> Similar Not compared 20080000 <NA> <NA>
## 49 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2009 - 11 79.41122 78.68370 80.14369 NA NA 47404 77644238 <NA> <NA> Not compared Not compared 20090000 <NA> <NA>
## 50 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2009 - 11 48.67070 48.17032 49.17494 NA NA 36887 80301764 <NA> <NA> Not compared Not compared 20090000 <NA> <NA>
## 51 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2009 - 11 61.69011 61.27219 62.11015 NA NA 84291 157946002 <NA> <NA> Not compared Not compared 20090000 <NA> <NA>
## 52 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2009 - 11 79.41122 78.68370 80.14369 NA NA 47404 77644238 <NA> <NA> Similar Not compared 20090000 <NA> <NA>
## 53 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2009 - 11 48.67070 48.17032 49.17494 NA NA 36887 80301764 <NA> <NA> Similar Not compared 20090000 <NA> <NA>
## 54 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2009 - 11 61.69011 61.27219 62.11015 NA NA 84291 157946002 <NA> <NA> Similar Not compared 20090000 <NA> <NA>
## 55 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2010 - 12 77.22458 76.51635 77.93766 NA NA 47073 78343854 <NA> <NA> Not compared Not compared 20100000 <NA> <NA>
## 56 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2010 - 12 48.74003 48.24300 49.24088 NA NA 37473 80899496 <NA> <NA> Not compared Not compared 20100000 <NA> <NA>
## 57 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2010 - 12 60.86961 60.45804 61.28328 NA NA 84546 159243350 <NA> <NA> Not compared Not compared 20100000 <NA> <NA>
## 58 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2010 - 12 77.22458 76.51635 77.93766 NA NA 47073 78343854 <NA> <NA> Similar Not compared 20100000 <NA> <NA>
## 59 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2010 - 12 48.74003 48.24300 49.24088 NA NA 37473 80899496 <NA> <NA> Similar Not compared 20100000 <NA> <NA>
## 60 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2010 - 12 60.86961 60.45804 61.28328 NA NA 84546 159243350 <NA> <NA> Similar Not compared 20100000 <NA> <NA>
## 61 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2011 - 13 75.72563 75.03245 76.42355 NA NA 47103 79000579 <NA> <NA> Not compared Not compared 20110000 <NA> <NA>
## 62 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2011 - 13 48.59709 48.10460 49.09332 NA NA 37921 81466136 <NA> <NA> Not compared Not compared 20110000 <NA> <NA>
## 63 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2011 - 13 60.19360 59.78784 60.60142 NA NA 85024 160466715 <NA> <NA> Not compared Not compared 20110000 <NA> <NA>
## 64 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2011 - 13 75.72563 75.03245 76.42355 NA NA 47103 79000579 <NA> <NA> Similar Not compared 20110000 <NA> <NA>
## 65 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2011 - 13 48.59709 48.10460 49.09332 NA NA 37921 81466136 <NA> <NA> Similar Not compared 20110000 <NA> <NA>
## 66 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2011 - 13 60.19360 59.78784 60.60142 NA NA 85024 160466715 <NA> <NA> Similar Not compared 20110000 <NA> <NA>
## 67 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2012 - 14 74.18933 73.51237 74.87090 NA NA 47251 79640613 <NA> <NA> Not compared Not compared 20120000 <NA> <NA>
## 68 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2012 - 14 48.49189 48.00407 48.98339 NA NA 38454 82035551 <NA> <NA> Not compared Not compared 20120000 <NA> <NA>
## 69 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2012 - 14 59.53638 59.13677 59.93801 NA NA 85705 161676164 <NA> <NA> Not compared Not compared 20120000 <NA> <NA>
## 70 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2012 - 14 74.18933 73.51237 74.87090 NA NA 47251 79640613 <NA> <NA> Similar Not compared 20120000 <NA> <NA>
## 71 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2012 - 14 48.49189 48.00407 48.98339 NA NA 38454 82035551 <NA> <NA> Similar Not compared 20120000 <NA> <NA>
## 72 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2012 - 14 59.53638 59.13677 59.93801 NA NA 85705 161676164 <NA> <NA> Similar Not compared 20120000 <NA> <NA>
## 73 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2013 - 15 72.43525 71.77429 73.10071 NA NA 47142 80336451 <NA> <NA> Not compared Not compared 20130000 <NA> <NA>
## 74 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2013 - 15 48.28404 47.80103 48.77068 NA NA 38834 82632311 <NA> <NA> Not compared Not compared 20130000 <NA> <NA>
## 75 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2013 - 15 58.68598 58.29288 59.08107 NA NA 85976 162968762 <NA> <NA> Not compared Not compared 20130000 <NA> <NA>
## 76 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2013 - 15 72.43525 71.77429 73.10071 NA NA 47142 80336451 <NA> <NA> Similar Not compared 20130000 <NA> <NA>
## 77 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2013 - 15 48.28404 47.80103 48.77068 NA NA 38834 82632311 <NA> <NA> Similar Not compared 20130000 <NA> <NA>
## 78 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2013 - 15 58.68598 58.29288 59.08107 NA NA 85976 162968762 <NA> <NA> Similar Not compared 20130000 <NA> <NA>
## 79 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2014 - 16 70.60534 69.96087 71.25423 NA NA 46978 81103402 <NA> <NA> Not compared Not compared 20140000 <NA> <NA>
## 80 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2014 - 16 47.84928 47.37203 48.33010 NA NA 39019 83267610 <NA> <NA> Not compared Not compared 20140000 <NA> <NA>
## 81 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2014 - 16 57.67632 57.29018 58.06441 NA NA 85997 164371012 <NA> <NA> Not compared Not compared 20140000 <NA> <NA>
## 82 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2014 - 16 70.60534 69.96087 71.25423 NA NA 46978 81103402 <NA> <NA> Similar Not compared 20140000 <NA> <NA>
## 83 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2014 - 16 47.84928 47.37203 48.33010 NA NA 39019 83267610 <NA> <NA> Similar Not compared 20140000 <NA> <NA>
## 84 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2014 - 16 57.67632 57.29018 58.06441 NA NA 85997 164371012 <NA> <NA> Similar Not compared 20140000 <NA> <NA>
## 85 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2015 - 17 68.21717 67.59104 68.84761 NA NA 46351 81811259 <NA> <NA> Not compared Not compared 20150000 <NA> <NA>
## 86 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2015 - 17 47.09304 46.62353 47.56608 NA NA 38985 83862565 <NA> <NA> Not compared Not compared 20150000 <NA> <NA>
## 87 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2015 - 17 56.26307 55.88513 56.64292 NA NA 85336 165673824 <NA> <NA> Not compared Not compared 20150000 <NA> <NA>
## 88 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2015 - 17 68.21717 67.59104 68.84761 NA NA 46351 81811259 <NA> <NA> Similar Not compared 20150000 <NA> <NA>
## 89 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2015 - 17 47.09304 46.62353 47.56608 NA NA 38985 83862565 <NA> <NA> Similar Not compared 20150000 <NA> <NA>
## 90 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2015 - 17 56.26307 55.88513 56.64292 NA NA 85336 165673824 <NA> <NA> Similar Not compared 20150000 <NA> <NA>
## 91 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Male All ages <NA> <NA> 2016 - 18 66.03922 65.43042 66.65225 65.08130 67.00690 45862 82449915 <NA> Cannot be calculated Not compared Not compared 20160000 <NA> <NA>
## 92 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Female All ages <NA> <NA> 2016 - 18 45.86020 45.40078 46.32309 45.13746 46.59097 38569 84414760 <NA> Cannot be calculated Not compared Not compared 20160000 <NA> <NA>
## 93 1203 Mortality rate from lung cancer <NA> <NA> E92000001 England England Persons All ages <NA> <NA> 2016 - 18 54.67348 54.30436 55.04448 54.09238 55.25894 84431 166864675 <NA> Cannot be calculated Not compared Not compared 20160000 <NA> <NA>
## 94 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Male All ages <NA> <NA> 2016 - 18 66.03922 65.43042 66.65225 65.08130 67.00690 45862 82449915 <NA> Cannot be calculated Similar Not compared 20160000 <NA> <NA>
## 95 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Female All ages <NA> <NA> 2016 - 18 45.86020 45.40078 46.32309 45.13746 46.59097 38569 84414760 <NA> Cannot be calculated Similar Not compared 20160000 <NA> <NA>
## 96 1203 Mortality rate from lung cancer K02000001 United Kingdom E92000001 England England Persons All ages <NA> <NA> 2016 - 18 54.67348 54.30436 55.04448 54.09238 55.25894 84431 166864675 <NA> Cannot be calculated Similar Not compared 20160000 <NA> <NA>In the example above the code 1203 indicates lung cancer mortality rate, and the area type code 15 indicates England (i.e. national data). If you are wondering how to find the necessary Fingertips codes for what you need, these two functions will help you:
# Available Indicators
indicators()## # A tibble: 3,740 x 6
## IndicatorID IndicatorName DomainID DomainName ProfileID ProfileName
## <int> <fct> <int> <chr> <int> <chr>
## 1 113 Smoking attributable mortality 1938132885 Key Indicators 18 Local Tobacco Control Profiles
## 2 1207 Smoking attributable hospital admissions 1938132885 Key Indicators 18 Local Tobacco Control Profiles
## 3 1210 Smokers that have successfully quit at 4 weeks 1938132885 Key Indicators 18 Local Tobacco Control Profiles
## 4 91183 Smoking prevalence age 15 years - regular smokers (SDD survey) 1938132885 Key Indicators 18 Local Tobacco Control Profiles
## 5 91184 Smoking prevalence age 15 years - occasional smokers (SDD survey) 1938132885 Key Indicators 18 Local Tobacco Control Profiles
## 6 92443 Smoking Prevalence in adults (18+) - current smokers (APS) 1938132885 Key Indicators 18 Local Tobacco Control Profiles
## 7 93085 Smoking status at time of delivery 1938132885 Key Indicators 18 Local Tobacco Control Profiles
## 8 93382 Smoking prevalence in adults (18-64) - socio-economic gap in current smokers (APS) 1938132885 Key Indicators 18 Local Tobacco Control Profiles
## 9 93553 Deprivation score (IMD 2019) 1938132885 Key Indicators 18 Local Tobacco Control Profiles
## 10 91547 Smoking prevalence in adults (15+) - current smokers (QOF) 1938132886 Smoking prevalence in adults 18 Local Tobacco Control Profiles
## # ... with 3,730 more rows# Available Area Types
area_types()## AreaTypeID AreaTypeName ParentAreaTypeID ParentAreaTypeName
## 1 3 Middle Super Output Area 101 Lower tier local authorities (pre 4/19)
## 2 6 Government Office Region 15 England
## 3 7 General Practice 166 CCGs unchanged minus old plus new
## 4 7 General Practice 165 CCGs unchanged plus new 2019
## 5 7 General Practice 154 CCG unchanged plus new 2018
## 6 7 General Practice 204 Primary Care Network (provisional)
## 7 8 Ward 101 Lower tier local authorities (pre 4/19)
## 8 8 Ward 201 Lower tier local authorities (4/19 - 3/20)
## 9 8 Ward 202 Upper tier local authorities (4/19 - 3/20)
## 10 8 Ward 102 Upper tier local authorities (pre 4/19)
## 11 15 England 159 United Kingdom
## 12 41 Ambulance Trust 15 England
## 13 46 E39, former sub-region, former Local area teams) 15 England
## 14 101 Lower tier local authorities (pre 4/19) 6 Government Office Region
## 15 101 Lower tier local authorities (pre 4/19) 104 PHEC 2015 new plus PHEC 2013 unchanged
## 16 101 Lower tier local authorities (pre 4/19) 156 ONS 2011 group (revised)
## 17 101 Lower tier local authorities (pre 4/19) 157 ONS 2011 subgroup (revised)
## 18 101 Lower tier local authorities (pre 4/19) 10040 Depriv. decile (IMD 2015, pre Apr2019 boundaries)
## 19 101 Lower tier local authorities (pre 4/19) 102 Upper tier local authorities (pre 4/19)
## 20 101 Lower tier local authorities (pre 4/19) 126 Combined authorities
## 21 102 Upper tier local authorities (pre 4/19) 6 Government Office Region
## 22 102 Upper tier local authorities (pre 4/19) 104 PHEC 2015 new plus PHEC 2013 unchanged
## 23 102 Upper tier local authorities (pre 4/19) 10039 Depriv. decile (IMD 2015, pre Apr2019 boundaries)
## 24 102 Upper tier local authorities (pre 4/19) 126 Combined authorities
## 25 103 PHEC 2013 only plus PHEC unchanged 42 2013 PHE Regions (4)
## 26 103 PHEC 2013 only plus PHEC unchanged 15 England
## 27 104 PHEC 2015 new plus PHEC 2013 unchanged 42 2013 PHE Regions (4)
## 28 104 PHEC 2015 new plus PHEC 2013 unchanged 15 England
## 29 112 Strategic Clinical Network 15 England
## 30 118 Acute Trusts (incl.combined MH+Acute) 15 England
## 31 118 Acute Trusts (incl.combined MH+Acute) 104 PHEC 2015 new plus PHEC 2013 unchanged
## 32 119 Mental Health Trusts (incl.combined MH+Acute) 15 England
## 33 119 Mental Health Trusts (incl.combined MH+Acute) 44 E40, former commissioning regions
## 34 121 Abdominal aortic aneurysm screening cohort 15 England
## 35 122 Bowel Cancer Screening Centres 15 England
## 36 124 Newborn Screening Sites 15 England
## 37 125 Maternity Services 15 England
## 38 126 Combined authorities 15 England
## 39 129 Laboratory 6 Government Office Region
## 40 130 Breast Screening Service 15 England
## 41 152 CCG unchanged plus new 2017 46 E39, former sub-region, former Local area teams)
## 42 152 CCG unchanged plus new 2017 44 E40, former commissioning regions
## 43 152 CCG unchanged plus new 2017 15 England
## 44 152 CCG unchanged plus new 2017 219 STP (120 +218)
## 45 154 CCG unchanged plus new 2018 44 E40, former commissioning regions
## 46 154 CCG unchanged plus new 2018 219 STP (120 +218)
## 47 154 CCG unchanged plus new 2018 46 E39, former sub-region, former Local area teams)
## 48 154 CCG unchanged plus new 2018 15 England
## 49 165 CCGs unchanged plus new 2019 46 E39, former sub-region, former Local area teams)
## 50 165 CCGs unchanged plus new 2019 15 England
## 51 165 CCGs unchanged plus new 2019 44 E40, former commissioning regions
## 52 165 CCGs unchanged plus new 2019 219 STP (120 +218)
## 53 165 CCGs unchanged plus new 2019 205 Local Maternity System
## 54 166 CCGs unchanged minus old plus new 15 England
## 55 166 CCGs unchanged minus old plus new 220 Sustainability and Transformation Footprints
## 56 166 CCGs unchanged minus old plus new 44 E40, former commissioning regions
## 57 166 CCGs unchanged minus old plus new 205 Local Maternity System
## 58 201 Lower tier local authorities (4/19 - 3/20) 6 Government Office Region
## 59 201 Lower tier local authorities (4/19 - 3/20) 104 PHEC 2015 new plus PHEC 2013 unchanged
## 60 201 Lower tier local authorities (4/19 - 3/20) 156 ONS 2011 group (revised)
## 61 201 Lower tier local authorities (4/19 - 3/20) 157 ONS 2011 subgroup (revised)
## 62 201 Lower tier local authorities (4/19 - 3/20) 10107 Depriv. decile (IMD2015, 4/19 boundaries)
## 63 201 Lower tier local authorities (4/19 - 3/20) 10114 Depriv. deciles (IMD2019)
## 64 201 Lower tier local authorities (4/19 - 3/20) 202 Upper tier local authorities (4/19 - 3/20)
## 65 201 Lower tier local authorities (4/19 - 3/20) 126 Combined authorities
## 66 202 Upper tier local authorities (4/19 - 3/20) 6 Government Office Region
## 67 202 Upper tier local authorities (4/19 - 3/20) 104 PHEC 2015 new plus PHEC 2013 unchanged
## 68 202 Upper tier local authorities (4/19 - 3/20) 10105 Depriv. decile (IMD2015, 4/19 boundaries)
## 69 202 Upper tier local authorities (4/19 - 3/20) 10113 Depriv. deciles (IMD2019)
## 70 202 Upper tier local authorities (4/19 - 3/20) 126 Combined authorities
## 71 203 IAPT services 44 E40, former commissioning regions
## 72 203 IAPT services 46 E39, former sub-region, former Local area teams)
## 73 204 Primary Care Network (provisional) 166 CCGs unchanged minus old plus new
## 74 204 Primary Care Network (provisional) 165 CCGs unchanged plus new 2019
## 75 204 Primary Care Network (provisional) 220 Sustainability and Transformation Footprints
## 76 205 Local Maternity System 15 England
## 77 219 STP (120 +218) 15 England
## 78 220 Sustainability and Transformation Footprints 44 E40, former commissioning regions
## 79 220 Sustainability and Transformation Footprints 15 England
## 80 301 Lower tier local authorities (post 4/20) 6 Government Office Region
## 81 301 Lower tier local authorities (post 4/20) 104 PHEC 2015 new plus PHEC 2013 unchanged
## 82 301 Lower tier local authorities (post 4/20) 156 ONS 2011 group (revised)
## 83 301 Lower tier local authorities (post 4/20) 157 ONS 2011 subgroup (revised)
## 84 301 Lower tier local authorities (post 4/20) 302 Upper tier local authorities (post 4/20)
## 85 301 Lower tier local authorities (post 4/20) 10135 Depriv. deciles (IMD2019, 4/20)
## 86 301 Lower tier local authorities (post 4/20) 126 Combined authorities
## 87 302 Upper tier local authorities (post 4/20) 6 Government Office Region
## 88 302 Upper tier local authorities (post 4/20) 104 PHEC 2015 new plus PHEC 2013 unchanged
## 89 302 Upper tier local authorities (post 4/20) 10105 Depriv. decile (IMD2015, 4/19 boundaries)
## 90 302 Upper tier local authorities (post 4/20) 126 Combined authorities
## 91 302 Upper tier local authorities (post 4/20) 10113 Depriv. deciles (IMD2019)You can find the necessary codes from these two tables. An easy way of “eyeballing” the data within RStudio is by viewing the file using View(indicators()). When the table opens, click filter button at the top left, and within the textbox that appears above each column, type e.g. “lung cancer” above the IndicatorName column in order to search for it. You can do the same for area_types(). In this instance IndicatorID=1203 returns data regarding Mortality rate from lung cancer and an AreaTypeID=15 returns data for England.
We can even download data for a specific place by adding the AreaCode within the function. That is the a code that the Office for National Statistics (ONS) uses when referring to a specific place. For instance, England has the code “E92000001” and Liverpool has the code “E08000012”.
Here is an example of how to use AreaCode to download data regarding Life expectancy at birth (indicator code 90366), by local authority (area code 101) and specifically for Liverpool (ONS code E08000012):
fingertips_data(IndicatorID = 90366, AreaTypeID = 101, AreaCode = "E08000012")## IndicatorID IndicatorName ParentCode ParentName AreaCode AreaName AreaType Sex Age CategoryType Category Timeperiod Value LowerCI95.0limit UpperCI95.0limit LowerCI99.8limit UpperCI99.8limit Count Denominator Valuenote RecentTrend ComparedtoEnglandvalueorpercentiles ComparedtoRegionvalueorpercentiles TimeperiodSortable Newdata Comparedtogoal
## 1 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2001 - 03 72.72840 72.39511 73.06168 NA NA NA NA <NA> <NA> Worse Worse 20010000 <NA> <NA>
## 2 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2001 - 03 77.71871 77.40407 78.03334 NA NA NA NA <NA> <NA> Worse Worse 20010000 <NA> <NA>
## 3 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2002 - 04 73.19265 72.86110 73.52419 NA NA NA NA <NA> <NA> Worse Worse 20020000 <NA> <NA>
## 4 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2002 - 04 77.98794 77.67732 78.29856 NA NA NA NA <NA> <NA> Worse Worse 20020000 <NA> <NA>
## 5 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2003 - 05 73.41441 73.07601 73.75280 NA NA NA NA <NA> <NA> Worse Worse 20030000 <NA> <NA>
## 6 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2003 - 05 78.14052 77.82264 78.45839 NA NA NA NA <NA> <NA> Worse Worse 20030000 <NA> <NA>
## 7 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2004 - 06 73.98314 73.64733 74.31895 NA NA NA NA <NA> <NA> Worse Worse 20040000 <NA> <NA>
## 8 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2004 - 06 78.42634 78.10348 78.74920 NA NA NA NA <NA> <NA> Worse Worse 20040000 <NA> <NA>
## 9 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2005 - 07 74.11649 73.78108 74.45191 NA NA NA NA <NA> <NA> Worse Worse 20050000 <NA> <NA>
## 10 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2005 - 07 78.82712 78.50329 79.15094 NA NA NA NA <NA> <NA> Worse Worse 20050000 <NA> <NA>
## 11 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2006 - 08 74.52433 74.19433 74.85434 NA NA NA NA <NA> <NA> Worse Worse 20060000 <NA> <NA>
## 12 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2006 - 08 78.98016 78.66066 79.29967 NA NA NA NA <NA> <NA> Worse Worse 20060000 <NA> <NA>
## 13 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2007 - 09 74.77991 74.44881 75.11102 NA NA NA NA <NA> <NA> Worse Worse 20070000 <NA> <NA>
## 14 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2007 - 09 79.40058 79.08314 79.71802 NA NA NA NA <NA> <NA> Worse Worse 20070000 <NA> <NA>
## 15 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2008 - 10 75.15365 74.82476 75.48254 NA NA NA NA <NA> <NA> Worse Worse 20080000 <NA> <NA>
## 16 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2008 - 10 79.46612 79.14591 79.78634 NA NA NA NA <NA> <NA> Worse Worse 20080000 <NA> <NA>
## 17 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2009 - 11 75.62378 75.29361 75.95395 NA NA NA NA <NA> <NA> Worse Worse 20090000 <NA> <NA>
## 18 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2009 - 11 79.99402 79.67800 80.31003 NA NA NA NA <NA> <NA> Worse Worse 20090000 <NA> <NA>
## 19 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2010 - 12 75.96265 75.63438 76.29091 NA NA NA NA <NA> <NA> Worse Worse 20100000 <NA> <NA>
## 20 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2010 - 12 80.11379 79.80076 80.42682 NA NA NA NA <NA> <NA> Worse Worse 20100000 <NA> <NA>
## 21 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2011 - 13 76.17623 75.84543 76.50703 NA NA NA NA <NA> <NA> Worse Worse 20110000 <NA> <NA>
## 22 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2011 - 13 80.38360 80.08106 80.68615 NA NA NA NA <NA> <NA> Worse Worse 20110000 <NA> <NA>
## 23 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2012 - 14 76.31483 75.98611 76.64354 NA NA NA NA <NA> <NA> Worse Worse 20120000 <NA> <NA>
## 24 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2012 - 14 80.44199 80.13096 80.75301 NA NA NA NA <NA> <NA> Worse Worse 20120000 <NA> <NA>
## 25 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2013 - 15 76.35925 76.03504 76.68346 NA NA NA NA <NA> <NA> Worse Worse 20130000 <NA> <NA>
## 26 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2013 - 15 80.40703 80.09443 80.71963 NA NA NA NA <NA> <NA> Worse Worse 20130000 <NA> <NA>
## 27 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2014 - 16 76.40889 76.08261 76.73516 NA NA NA NA <NA> <NA> Worse Worse 20140000 <NA> <NA>
## 28 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2014 - 16 80.29521 79.97453 80.61588 NA NA NA NA <NA> <NA> Worse Worse 20140000 <NA> <NA>
## 29 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2015 - 17 76.12592 75.79718 76.45466 NA NA NA NA <NA> <NA> Worse Worse 20150000 <NA> <NA>
## 30 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2015 - 17 80.22034 79.90472 80.53597 NA NA NA NA <NA> <NA> Worse Worse 20150000 <NA> <NA>
## 31 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Male All ages <NA> <NA> 2016 - 18 76.26315 75.93889 76.58742 NA NA NA NA <NA> Cannot be calculated Worse Worse 20160000 <NA> <NA>
## 32 90366 Life expectancy at birth E12000002 North West region E08000012 Liverpool District & UA (pre 4/19) Female All ages <NA> <NA> 2016 - 18 80.08263 79.76290 80.40236 NA NA NA NA <NA> Cannot be calculated Worse Worse 20160000 <NA> <NA>And voilà, we now have download life expectancy at birth data for Liverpool directly into R, without having to go the Fingertips site, find and data, download it and then import them into R.
On a final note, I should mention here that up until now we haven’t really saved any datasets in our working environment. We can easily do that by assigning the table with the data to a variable, such as my_liverpool_data, like so:
my_liverpool_data <- fingertips_data(IndicatorID = 90366, AreaTypeID = 101, AreaCode = "E08000012")But you shouldn’t worry about that at this point, you will get more experience using R during these sessions.