open-innovations / WNYCC-LSIP

West & North Yorkshire Chamber of Commerce Local Skills Improvement Plans
0 stars 0 forks source link

Create version of FE & Skills Geography excluding Army apprenticeships #32

Closed gilesdring closed 1 year ago

gilesdring commented 1 year ago

https://open-innovations.github.io/WNYCC-LSIP/metadata/fe/Further%20education%20and%20skills%20geography%20-%20detailed%20summary/

ChristianSpence commented 1 year ago

@gilesdring @luke-strange I can't see any army providers in the provider level data we have for FE. Will keep investigating but not sure yet that we can exclude these as we can't identify them.

ChristianSpence commented 1 year ago

Have found the separate listing of Army apprentices, but they're in a separate dataset solely for apprenticeships and traineeships. Know it's late in the day but feel we should probably include this. Happy to do the heavy lift on the data prep. We need 10 minutes to discuss, @gilesdring

ChristianSpence commented 1 year ago

@gilesdring @luke-strange Have added apprenticeships specific data into data/csv/apprenticeships at local authority, apprenticeship level (inc. total), SSA T1 (subject) (inc. total).

Lots of suppression in the data (low = >0 & <5), but may be useful to have for the local authority totals and where there is at least some data.

NB this is 2022/23 data (so year so far) - not comparable with the rest (which 21/22) but it's the only year we've got data that's at LA and subject level that I can manually build a table for. (We can get earlier years but, as it's preformatted and is cut by age, sex and ethnicity, >90% of data rows are suppressed. Useless!)

ChristianSpence commented 1 year ago

Moving back to "ready" for picking up for a page build

gilesdring commented 1 year ago

I’ll close this one and either create a new one or mention in the open apprentices ticket should one exist.

gilesdring commented 1 year ago

Aha - I see you’ve done this in #44

luke-strange commented 1 year ago

Need to discuss this off the back of LSIP meeting.