NHS Potential COVID-19 Symptoms reported through NHS Pathways and 111 Online
Period, Site Type, Sex, Age, ONS Geography Code, Measure Type, Unit, Marker, Value
A - SiteType - change to Site Type (Codelist) (111, 999)
B - CallDate - Change to Period and format as required
C - Gender - change to Sex (Male = M, Female = F, Unknown = U)
D - AgeBand - Change to Age (Codelist)
E - CCGCode - Change to ONS Geography Code
F - CCGName - Ignore as we have the Geography codes
G - April20 mappedCCGCode - Ignore as some of these geographies are not available on the portal
H - April20 mappedCCGName - Ignore
I - TriageCount - These are the Observations (Obvs)
Add Measure Type column with value Triage
Add Unit column with value Count
A - JourneyDate - Change to Period and format as required
B - Gender - change to Sex (Male = M, Female = F, Unknown = U)
C - AgeBand - Change to Age (Codelist)
D - CCGCode - Change to ONS Geography Code
E - CCGName - Ignore as we have the Geography codes
F - April20 mappedCCGCode - Ignore as some of these geographies are not available on the portal
G - April20 mappedCCGName - Ignore
H - Total - These are the Observations (Obvs)
Add Site Type column with value 111 Online
Add Measure Type column with value Online Assessments
Add Unit column with value Count
Extra files have been created with lots of Metadata, need to decide how we can handle this.
Some of the mapped Geography codes are missing from the portal, they appear to be aggregated, merged or renamed NHS Trusts. Emailed Matt Jinman on 20/05/2020 with a list of 75 codes asking if they can be added.