britishredcrosssociety / covid-19-vulnerability

COVID-19 Vulnerability Index for neighbourhoods and Local Authorities in the UK
https://britishredcrosssociety.github.io/covid-19-vulnerability/
Other
33 stars 15 forks source link

Food wales #24

Closed MikeJohnPage closed 4 years ago

MikeJohnPage commented 4 years ago
MikeJohnPage commented 4 years ago

Worth noting I aggregated down to LA for Wales only (after our discussion on Teams)

MikeJohnPage commented 4 years ago

I couldn't find any data on mobilisation for Wales, but haven't looked for Scotland/NI.

MikeJohnPage commented 4 years ago

For NI, in the original MSOA files the variable Service-weighted fastest travel time by private transport (Rank) is reversed ranked. This is the same variable used in this food index. The NI IMD states this variable is the 'road travel time in minutes'. Therefore, was it not already in the correct order in the original IMD. Has reverse ranking it not resulted in the longest travel times receiving the lowest score (which is the opposite of what the VI achieves - i.e., high = more vulnerable)?

MikeJohnPage commented 4 years ago

For Scotland, I used Income_count instead of Income_rate from the IMD like you did for England. Does this need changing (I assumed not)?

matthewgthomas commented 4 years ago

For NI, in the original MSOA files the variable Service-weighted fastest travel time by private transport (Rank) is reversed ranked. This is the same variable used in this food index. The NI IMD states this variable is the 'road travel time in minutes'. Therefore, was it not already in the correct order in the original IMD. Has reverse ranking it not resulted in the longest travel times receiving the lowest score (which is the opposite of what the VI achieves - i.e., high = more vulnerable)?

In the NI IMD (and the others), low ranks are the highest deprivation (in this case, low ranks = longer travel times) so we needed to reverse the ranks to align with the rest of the VI

matthewgthomas commented 4 years ago

For Scotland, I used Income_count instead of Income_rate from the IMD like you did for England. Does this need changing (I assumed not)?

Will check