family-covid-19

COGS Dataset Specification

Family Home

Family Transform Status


HO Statistics relating to Covid-19 and the immigration system

Landing Page

Transform Flowchart


Stage 1. Transform

Sheet: Air_01

	A - Date
	A4:E4 - Year (Not needed)
	B & F - Total air arrivals
	C & G - Of which British nationals

Table Structure

	Date, Total air arrivals, Of which British Nationals, Measure Type, Unit, Marker, Value

Stage 2. Harmonise

Sheet: Passengers arriving in the UK by air routes

	Format 'Date'column as a day. Number of air arrivals are for each day.

Table Structure

	Date, Total air arrivals, Of which British Nationals, Measure Type, Unit, Marker, Value

Footnotes
	Notes sheet - add point 2 as a footnote. 
	Points 1, 3 and 4 add as description of the trig file.
DM Notes