Extracting data for Area Type of "combined authorities"

[catriggwalk]

Some Fingertips downloads contain combined authority level data for some indicators - for example the sickness absence indicators 90286 and 90287 – but I have been unable to extract this data using fingertipsR. Am I doing something wrong, or is this not supposed to be possible for some reason? Is this because of issue #51 ?

The following code outputs the data for these indicators at various geographies but not the combined authority grouping:

sick <- fingertips_data(c(90286, 90287), AreaTypeID = 102) %>%
  group_by(IndicatorID) %>%
  filter(TimeperiodSortable == max(TimeperiodSortable) &
           Sex == "Persons")
sick <- sick[order(sick$IndicatorID),]

The AreaTypeID for combined authorities is 126, but when I change the code as follows I get “No data available in table”.

sick <- fingertips_data(c(90286, 90287), AreaTypeID = 126) %>%
  group_by(IndicatorID) %>%
  filter(TimeperiodSortable == max(TimeperiodSortable) &
           Sex == "Persons")
sick <- sick[order(sick$IndicatorID),]

I tried specifying an area code (as below) but that does not return anything either.

sick <- fingertips_data(c(90286, 90287), AreaCode = 'E47000004', AreaTypeID = 126) %>%
  group_by(IndicatorID) %>%
  filter(TimeperiodSortable == max(TimeperiodSortable) &
           Sex == "Persons")
sick <- sick[order(sick$IndicatorID),]

I also tried specifying the ParentAreadTypeID for country (which is 15):

sick <- fingertips_data(c(90286, 90287), AreaTypeID = 126,
                        ParentAreaTypeID = 15) %>%
  group_by(IndicatorID) %>%
  filter(TimeperiodSortable == max(TimeperiodSortable) &
           Sex == "Persons")
sick <- sick[order(sick$IndicatorID),]

[sebastian-fox]

Thanks for reporting. This is an issue around terminology - I can't think of a better way of naming arguments. Essentially, the ParentAreaTypeID argument is equivalent to Areas grouped by on Fingertips. To extract combined authorities you need to run the following:

sick <- fingertips_data(c(90286, 90287), AreaTypeID = 102, ParentAreaTypeID = 126)

Is that what you're after?

[catriggwalk]

That's exactly what I needed to know. Thanks @sebastian-fox