Fingertips API - retrieving resulst based on search terms

1 Efforts at using purrr and understanding lists.

This note uses the purrr package and listviewer to help understand the structure of and extract data from the Fingertips API. The purrr package helps to unpack and operate on lists. listviewer helps to visualise and understand them.

1.1 Install packages

if(!require(repurrrsive))install_github("jennybc/repurrrsive")

Loading required package: repurrrsive
there is no package called ‘repurrrsive’Downloading GitHub repo jennybc/repurrrsive@master
from URL https://api.github.com/repos/jennybc/repurrrsive/zipball/master
Installing repurrrsive
'/Library/Frameworks/R.framework/Resources/bin/R' --no-site-file --no-environ --no-save  \
  --no-restore --quiet CMD INSTALL  \
  '/private/var/folders/gs/3y755_ds3r5gw5n1l_bcnxfw0000gn/T/RtmpDY6tB2/devtools7fb5ee01f1/jennybc-repurrrsive-eb4504c'  \
  --library='/Users/julianflowers/Library/R/3.3/library' --install-tests 

* installing *source* package ‘repurrrsive’ ...
** R
** data
*** moving datasets to lazyload DB
** inst
** tests
** preparing package for lazy loading
** help
*** installing help indices
** building package indices
** testing if installed package can be loaded
* DONE (repurrrsive)

1.2 View it with listview

The wesanderson package is a list of colour palettes used in Wes Anderson’s movies.

str(wesanderson)

List of 15
 $ GrandBudapest : chr [1:4] "#F1BB7B" "#FD6467" "#5B1A18" "#D67236"
 $ Moonrise1     : chr [1:4] "#F3DF6C" "#CEAB07" "#D5D5D3" "#24281A"
 $ Royal1        : chr [1:4] "#899DA4" "#C93312" "#FAEFD1" "#DC863B"
 $ Moonrise2     : chr [1:4] "#798E87" "#C27D38" "#CCC591" "#29211F"
 $ Cavalcanti    : chr [1:5] "#D8B70A" "#02401B" "#A2A475" "#81A88D" ...
 $ Royal2        : chr [1:5] "#9A8822" "#F5CDB4" "#F8AFA8" "#FDDDA0" ...
 $ GrandBudapest2: chr [1:4] "#E6A0C4" "#C6CDF7" "#D8A499" "#7294D4"
 $ Moonrise3     : chr [1:5] "#85D4E3" "#F4B5BD" "#9C964A" "#CDC08C" ...
 $ Chevalier     : chr [1:4] "#446455" "#FDD262" "#D3DDDC" "#C7B19C"
 $ Zissou        : chr [1:5] "#3B9AB2" "#78B7C5" "#EBCC2A" "#E1AF00" ...
 $ FantasticFox  : chr [1:5] "#DD8D29" "#E2D200" "#46ACC8" "#E58601" ...
 $ Darjeeling    : chr [1:5] "#FF0000" "#00A08A" "#F2AD00" "#F98400" ...
 $ Rushmore      : chr [1:5] "#E1BD6D" "#EABE94" "#0B775E" "#35274A" ...
 $ BottleRocket  : chr [1:7] "#A42820" "#5F5647" "#9B110E" "#3F5151" ...
 $ Darjeeling2   : chr [1:5] "#ECCBAE" "#046C9A" "#D69C4E" "#ABDDDE" ...

We can see for example the 5 colours in Cavalcanti.

1.3 Extracting all the colours for Wes Anderson movies

1.4 Trying list viewer with the Fingertips API

• Starting simple with the area types

This tells us that the result is a JSON object. There are 51 area types. We can search the view and easily obtain the ID for any given area so:

• areatype 6 is ‘GO Region’,
• areatype 19 is’CCG’ and so on.

1.5 Using search terms in the Fingersips API.

Using this for a search term retrieves a list of indicator IDs for area types. So for the term ‘obesity’:

1.6 Extracting indicator IDs and area types to a data frame

Using the purrr::map_df function and magrittr::extract

We can see that 59 indicators for areatype 102 (Counties and Unitary Authorities), 46 for 101 (LAD and UA), 41 for GO Regions and 12 for CCGs.