family-covid-19

COGS Dataset Specification

Home

Family Transform Status

Testing data for coronavirus (COVID-19)

Welsh Government

Landing Page

Transform Flowchart

Dataset One

Output Dataset Name:

WG Testing data for Coronavirus - COVID-19 

Sheet: tests_authroised

A - Date - Change name to Period and format as required

B - Number of authorised tests

Add Measure Type Column with value Tests

Add Unit column with value Cumulative Count

Table Structure

Period, Authorised Tests, Marker, Measure Type, Unit, Value

Sheet: Completed_tests

A - Date - Change name to Period and format as required

B:C - Test Outcome (Codelist)

	Cumulative individuals tested - Total
	Cumulative positive cases - Positive

Add Measure Type Column with value People

Add Unit column with value Cumulative Count

Table Structure

Period, Test Outcome, Marker, Measure Type, Unit, Value

Sheet: Critical_workers_category

B7:M7 - Date - Change name to Period and format as required

B8:M8 - Test Outcome (Codelist)

	Cumulative positive cases - Positive
	Cumulative negative cases - Negative
	Cumulative number of test - Total
	
A9:A17 - Critical Worker Category (Codelist)

Add Measure Type Column with value People

Add Unit column with value Cumulative Count

Table Structure

Period, Test Outcome, Critical Worker Category, Marker, Measure Type, Unit, Value

Sheet: Critical_workers_detail

C9:E9 - Date - Change name to Period and format as required

C10:E10 - Test Outcome (Codelist)

	Cumulative positive cases - Positive
	Cumulative negative cases - Negative
	Cumulative number of test - Total

A11:A30 - Critical Worker Category (Codelist)

B11:B30 - Emergency Services Worker (Codelist)

Add Unit column with value Cumulative Count

Table Structure

Period, Test Outcome, Critical Worker Category, Emergency Services Worker, Marker, Measure Type, Unit, Value

Sheet: Location_tests

B7:Q7 - Date - Change name to Period and format as required

B8:Q8 - Test Outcome (Codelist)

	Cumulative tests completed - Total
	% results within 1 day - Results within 1 Day
	% results within 3 days - Results within 3 Days


A9:A11 - Test Location (Codelist)
	Tested in hospital - Hospital
	Tested ar coronavirus testing unit - Coronavirus Testing Unit
	Testing as drive-through centres - Drive-through Centres

Add Measure Type Column with value Tests and Percentage where relevant

Add Unit column with value Count and Percent where relevant	

Table Structure

Period, Test Outcome, Test Location, Marker, Measure Type, Unit, Value

Footnotes

Add to Metadata:
	Data presented is the cumulative total correct at the date stated
	The column Emergency Services Worker is a legacy category. Numbers may decline over time as data entry improves