Covid-19 Tests
Summary
Abstract
Covid 19 Test Results
-
Contact point
-
Digital object identifier (DOI)Not available
Keywords
Publisher
-
NameHealth Informatics Centre - University of Dundee
-
Logo
Not available
-
DescriptionNot available
-
Contact pointNot available
Documentation
Description
Health Protection Scotland (HPS), part of Public Health Scotland (PHS), is leading the Enhanced Surveillance of COVID-19 in Scotland (ESoCiS) programme on behalf of Scottish Government gathering a wide variety of data about COVID-19 from a range of sources, to learn more about the virus and gain an understanding of how it is spreading through the population in Scotland.
Data is via ECOSS (health protection system) and the Test and Protect datasets. NHS Digital have been providing a feed of the UK Gov data into NSS IT which then populates the systems for a full picture.
-
Associated media
- Not available
-
Is part of
- Not available
-
Landing page
Coverage
Spatial
-
Spatial coverage
United Kingdom, Scotland
-
Geographic levelsNot available
Temporal
-
Start date17/06/2021
-
End date09/09/2021
-
FrequencyStatic
-
Distribution release date18/05/2022
Provenance
-
PurposeDisease registry
-
SourceNot available
-
Collection situationOther
Access and governance
-
Conditions of accessGeneral research use
Requesting access to this data
This is a secure dataset that can only be accessed by researchers from approved organisations.
Find out how to apply to access this dataset
Usage
-
Conditions of useDisclosure control
-
Resource creatorNHS Fife & NHS Tayside
-
Is referenced byNot available
Access
-
Access rights
-
Access serviceHIC has implemented a remote-access Trusted Research Environment to protect data confidentiality, satisfy public concerns about data loss and reassure Data Controllers about HIC’s secure management and processing of their data. Data is not released externally to data users for analysis on their own computers but placed on a server at HIC, within a restricted, secure IT environment, where the data user is given secure remote access to carry out their analysis. Full details are available via the following link: https://www.dundee.ac.uk/hic/safe-haven
-
JurisdictionGB-SCT
-
Data controllerLocal NHS Boards
-
Data processorUniversity of Dundee, Health Informatics Centre
Format and standards
-
LanguageEnglish
-
FormatDatabase
Enrichment and linkage
-
Related datasets
- Not available
-
Linkage opportunityNot available
-
Tools
- Not available
Synthetic data
Synthetic data is not yet available for this dataset.
Technical information
A JSON file is available with further technical information. This can include details of variables and data classes contained in the dataset.
Preview of JSON file
{
"summary": {
"title": "Covid-19 Tests",
"abstract": "Covid 19 Test Results",
"keywords": "COVID-19;,;TESTING;,;Tayside;,;Fife;,;HIC;,;SCOTLAND",
"publisher": {
"name": "Health Informatics Centre - University of Dundee",
"gatewayId": "5baa31c1-0280-4482-b8b7-a4953869f184"
},
"inPipeline": "Not available",
"shortTitle": "Covid-19 Tests",
"datasetType": "Health and disease",
"description": "Health Protection Scotland (HPS), part of Public Health Scotland (PHS), is leading the Enhanced Surveillance of COVID-19 in Scotland (ESoCiS) programme on behalf of Scottish Government gathering a wide variety of data about COVID-19 from a range of sources, to learn more about the virus and gain an understanding of how it is spreading through the population in Scotland. \nData is via ECOSS (health protection system) and the Test and Protect datasets. NHS Digital have been providing a feed of the UK Gov data into NSS IT which then populates the systems for a full picture.",
"contactPoint": "hicsupport@dundee.ac.uk",
"datasetSubType": "Not applicable",
"populationSize": 20058
},
"coverage": {
"pathway": "Secondary care records for Tayside and Fife",
"spatial": "United Kingdom,Scotland",
"followUp": "Unknown",
"typicalAgeRange": "0-150"
},
"required": {
"issued": "2024-10-08T11:28:30.184627Z",
"version": "1.0.0",
"modified": "2024-10-08T11:28:30.18464Z",
"gatewayId": "112",
"revisions": [
{
"url": "https://web.prod.hdruk.cloud//dataset/112?version=1.0.0",
"version": "1.0.0"
}
],
"gatewayPid": "fbc03f7a-ff07-4263-bce7-fca30d493f0d"
},
"provenance": {
"origin": {
"purpose": "Disease registry",
"imageContrast": "Not stated",
"collectionSituation": "Other"
},
"temporal": {
"endDate": "2021-09-09",
"timeLag": "Not applicable",
"startDate": "2021-06-17",
"accrualPeriodicity": "Static",
"distributionReleaseDate": "2022-05-18"
}
},
"observations": [
{
"observedNode": "Persons",
"measuredValue": 20058,
"observationDate": "2022-05-18",
"measuredProperty": "COUNT",
"disambiguatingDescription": "20,058 persons in the dataset"
},
{
"observedNode": "Events",
"measuredValue": 72582,
"observationDate": "2022-05-18",
"measuredProperty": "count",
"disambiguatingDescription": "72,582 events in the dataset"
}
],
"accessibility": {
"usage": {
"resourceCreator": {
"name": "NHS Fife & NHS Tayside"
},
"dataUseLimitation": "General research use",
"dataUseRequirement": "Disclosure control"
},
"access": {
"accessRights": "https://www.dundee.ac.uk/hic/governance-service",
"jurisdiction": "GB-SCT",
"accessService": "HIC has implemented a remote-access Trusted Research Environment to protect data confidentiality, satisfy public concerns about data loss and reassure Data Controllers about HIC’s secure management and processing of their data.\n\nData is not released externally to data users for analysis on their own computers but placed on a server at HIC, within a restricted, secure IT environment, where the data user is given secure remote access to carry out their analysis.\n\nFull details are available via the following link:\nhttps://www.dundee.ac.uk/hic/safe-haven",
"dataProcessor": "University of Dundee, Health Informatics Centre",
"dataController": "Local NHS Boards",
"deliveryLeadTime": "2-4 weeks",
"accessRequestCost": "Quotation available on request",
"accessServiceCategory": "TRE/SDE"
},
"formatAndStandards": {
"formats": "Database",
"languages": "en",
"vocabularyEncodingSchemes": "LOCAL"
}
},
"structuralMetadata": [
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_client_group",
"dataType": "varchar(6)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_council_area",
"dataType": "varchar(19)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_council_area_code",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_int_authority_name",
"dataType": "varchar(29)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_location_id",
"dataType": "varchar(12)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_main_area_of_care",
"dataType": "varchar(44)",
"sensitive": false,
"description": "This field represents the main type of care within the carehome: Acquired brain injury Alcohol related brain injury Autism spectrum disorders."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_nhs_board",
"dataType": "varchar(25)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_nhs_board_code",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_num_of_staff",
"dataType": "decimal(5,2)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_num_registered_places",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_role",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_service",
"dataType": "varchar(23)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_service_name",
"dataType": "varchar(68)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_service_postcode",
"dataType": "varchar(8)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_service_provider",
"dataType": "varchar(95)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_service_provider_number",
"dataType": "varchar(12)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_service_status",
"dataType": "varchar(19)",
"sensitive": false,
"description": "This field represents the status of the carehome: Active Inactive Proposing to Cancel ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_service_type",
"dataType": "varchar(27)",
"sensitive": false,
"description": "This field represents the type of carehome. The data is represented by: Health Board Local Authority Private Voluntary or Not for Profit NULL."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_sub_type",
"dataType": "varchar(31)",
"sensitive": false,
"description": "This field represents the sub type of care home. The data is represented by: NULL Alcohol & Drug Misuse Care at Home Children & Young People Day Care of Children (over 3s) Day Care of Children (under 3s) Learning Disabilities Mental Health Problems Older People Physical and Sensory Impairment Respite Care and Short Breaks ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_home_total_beds",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "care_organisation_nhs_board_orig",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "date_appointment",
"dataType": "datetime2",
"sensitive": false,
"description": "This field represents the appointment date."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "date_ecoss_specimen",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "date_of_positive_test",
"dataType": "datetime2",
"sensitive": false,
"description": "This field represents the date tested positive."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "date_onset_of_symptoms",
"dataType": "datetime2",
"sensitive": false,
"description": "This field represents the date of first symptoms."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "date_record_created",
"dataType": "datetime2",
"sensitive": false,
"description": "This field represents the date the record was created."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "date_reporting",
"dataType": "datetime2",
"sensitive": false,
"description": "This field represents the date of reporting."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "date_sample_scanned_lims",
"dataType": "datetime2",
"sensitive": false,
"description": "This field represents the date if scanning."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "date_specimen_processed",
"dataType": "datetime2",
"sensitive": false,
"description": "This field represents the processing date."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "date_specimen_received_at_ecoss",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "date_specimen_received_at_lab",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "date_test_end",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "date_test_receieved_at_bi",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "date_test_start",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "date_test_updated_at_bi",
"dataType": "datetime2",
"sensitive": false,
"description": "This is a date field ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "date_vaccination_administered",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "dental_location_id",
"dataType": "varchar(14)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "duration_appointment_to_test_start_days",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "duration_processing_time_hours",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "duration_specimen_processed_to_bi_received_hours",
"dataType": "decimal(19,15)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "duration_specimen_received_at_lab_to_specimen_processed_days",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "duration_test_start_to_bi_received_days",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "duration_test_start_to_specimen_processed_days",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "duration_test_start_to_specimen_received_days",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "ecoss_doctor",
"dataType": "varchar(31)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "ecoss_organism",
"dataType": "varchar(11)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "ecoss_reporting_health_board",
"dataType": "varchar(27)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "ecoss_reporting_health_board_code",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "ecoss_reporting_health_board_code_orig",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "ecoss_requesting_location",
"dataType": "varchar(35)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "ecoss_specimen_source_type",
"dataType": "varchar(19)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "ecoss_specimen_type",
"dataType": "varchar(32)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "ecoss_submitting_laboratory",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "ecoss_submitting_laboratory_name",
"dataType": "varchar(43)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_administration_method_included",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the flag result and is represented with a 0 or 1."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_care_home_multisite_staff",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_care_home_resident_facing",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_care_home_test",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the flag for test. The data is defined by 0 or 1."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_care_provided_by_local_authority",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_chi_exception_correction",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_cohort_pool_test",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_covid_symptomatic",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the flag for symptomatic. The data is defined by 0 1 false true ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_covid_symptomatic_included",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the flag for symptomatic. The data is defined by: 0 1 ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_deduplicated_cases",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the flag for deduplication. The data is defined by 0 or 1."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_derived_chi",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_first_positive_case",
"dataType": "bit",
"sensitive": false,
"description": "This field flags the first positive case. The data is defined by 0 or 1."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_has_been_symptomatic",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_has_recently_travelled",
"dataType": "bit",
"sensitive": false,
"description": "This field represents whether they have recently travelled. The data is defined by 1 false true ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_home_testing",
"dataType": "bit",
"sensitive": false,
"description": "This field represents home testing. the data is defined by 0 or 1."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_lighthouse_labs_testing",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the flag for lab testing the data is defined by 0 or 1."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_received_by_ecoss",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the flag of received,. The data is defined by a 0 or 1."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_research_consent",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_subject_household_positive_tested",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_subject_immunosuppresant",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_subject_non_digital_user",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the flag for a non digital user. The data is defined by 0 or 1."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_subject_positive_tested",
"dataType": "bit",
"sensitive": false,
"description": "This field represents whether the person has tested positive. The data is defined by No Yes ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_submitted_ethnicity_included",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_test_centre_mobile",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_test_result_denotified",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "flag_test_result_transcribed",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "home_test_sample_collection_location",
"dataType": "varchar(13)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "id_subject_geography",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "id_subject_practice",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "id_submitted_subject_geography",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "key_worker_grouping",
"dataType": "varchar(16)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "key_worker_id",
"dataType": "varchar(36)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "key_worker_mobile_number",
"dataType": "decimal(13,0)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "key_worker_organisation",
"dataType": "varchar(29)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "key_worker_priority_code",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "laboratory_code",
"dataType": "varchar(18)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "laboratory_name",
"dataType": "varchar(39)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "laboratory_type",
"dataType": "varchar(39)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "lighthouse_source_file_name",
"dataType": "varchar(34)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "organisation_country",
"dataType": "varchar(8)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "organisation_name",
"dataType": "varchar(68)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "organisation_nhs_board_orig",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "organisation_reference_id",
"dataType": "nvarchar(20)",
"sensitive": false,
"description": "This field is the organisation id and is anonymised on output."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "organisation_role",
"dataType": "varchar(40)",
"sensitive": false,
"description": "This field represents the role within the organisation for example: CARE HOME - VISITING PROFESSIONAL CARE HOME - VISITOR CARE HOME STAFF ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "specimen_id",
"dataType": "varchar(32)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_chi_seeding_weight",
"dataType": "decimal(5,3)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_date_of_birth",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_derived_age_years",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_ethnicity",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_first_name",
"dataType": "varchar(15)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_landline",
"dataType": "varchar(16)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_practice_location_code",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_practice_location_type",
"dataType": "varchar(5)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_practice_nhs_board",
"dataType": "varchar(27)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_practice_nhs_board_code",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_residence_council_area",
"dataType": "varchar(21)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_residence_council_area_code_9",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_residence_datazone_deprivation_decile",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_residence_hscp_code",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_residence_hscp_name",
"dataType": "varchar(30)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_residence_nhs_board",
"dataType": "varchar(30)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_residence_nhs_board_code",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_residence_nhs_board_orig",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_residence_postcode",
"dataType": "varchar(7)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_residence_postcode_datazone",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_residence_postcode_easting",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_residence_postcode_encrypted",
"dataType": "varchar(32)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_residence_postcode_northing",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_sex",
"dataType": "varchar(6)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_sex_code",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_surname",
"dataType": "varchar(20)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_upi",
"dataType": "varchar(10)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "subject_upi_encrypted",
"dataType": "varchar(32)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_country_test_centre",
"dataType": "varchar(16)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_key_worker_name",
"dataType": "varchar(32)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_address_line_1",
"dataType": "nvarchar(100)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_address_line_2",
"dataType": "nvarchar(100)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_age",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_city",
"dataType": "varchar(56)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_commissioning_organisation",
"dataType": "varchar(5)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_council_area",
"dataType": "varchar(21)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_council_area_code_9",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_country",
"dataType": "varchar(8)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_country_code",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_county",
"dataType": "varchar(39)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_date_of_birth",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_easting",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_email_address",
"dataType": "varchar(42)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_employer_name",
"dataType": "nvarchar(64)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_ethnicity",
"dataType": "varchar(52)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_first_name",
"dataType": "varchar(25)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_hscp_code",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_hscp_name",
"dataType": "varchar(30)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_id",
"dataType": "varchar(36)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_industry_sector",
"dataType": "varchar(34)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_llsoa",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_local_authority",
"dataType": "varchar(5)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_lower_tier_authority",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_nhs_number",
"dataType": "varchar(11)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_nhs_region",
"dataType": "varchar(3)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_northing",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_occupation",
"dataType": "varchar(50)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_occupation_title",
"dataType": "varchar(68)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_parliamentary_constituency",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_phone_number",
"dataType": "varchar(36)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_postcode",
"dataType": "varchar(7)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_postcode_country",
"dataType": "varchar(16)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_postcode_encrypted",
"dataType": "varchar(32)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_practice_location_code",
"dataType": "varchar(6)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_residence_nhs_board",
"dataType": "varchar(30)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_residence_nhs_board_code",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_residence_nhs_board_orig",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_sex",
"dataType": "varchar(7)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_stp",
"dataType": "varchar(3)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_study_grade",
"dataType": "varchar(17)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_study_institution_name",
"dataType": "nvarchar(108)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_study_institution_nhs_board_orig",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_study_institution_postcode",
"dataType": "varchar(7)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_study_institution_town",
"dataType": "varchar(23)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_surname",
"dataType": "nvarchar(99)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_work_or_study_status",
"dataType": "varchar(19)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "submitted_subject_workstatus",
"dataType": "varchar(52)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_administration_method",
"dataType": "varchar(24)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_centre_associated_rts",
"dataType": "varchar(50)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_centre_group",
"dataType": "varchar(16)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_centre_id",
"dataType": "varchar(4)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_centre_name",
"dataType": "varchar(84)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_centre_nhs_board_orig",
"dataType": "varchar(9)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_ch1_result_ct_value",
"dataType": "decimal(14,12)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_ch1_target_gene",
"dataType": "varchar(6)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_ch1_target_gene_result",
"dataType": "varchar(12)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_ch2_result_ct_value",
"dataType": "decimal(14,12)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_ch2_target_gene",
"dataType": "varchar(6)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_ch2_target_gene_result",
"dataType": "varchar(12)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_ch3_result_ct_value",
"dataType": "decimal(14,12)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_ch3_target_gene",
"dataType": "varchar(6)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_ch3_target_gene_result",
"dataType": "varchar(12)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_ch4_result_ct_value",
"dataType": "decimal(14,12)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_ch4_target_gene",
"dataType": "varchar(3)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_ch4_target_gene_result",
"dataType": "varchar(8)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_id",
"dataType": "nvarchar(42)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_kit",
"dataType": "varchar(5)",
"sensitive": false,
"description": "This field represents which test kit was used : LFT LUMIRA DX ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_location",
"dataType": "varchar(16)",
"sensitive": false,
"description": "This field represents the location of the test: NON-HOME ADDRESS WALKIN ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_reason",
"dataType": "varchar(40)",
"sensitive": false,
"description": "This field represents the reason for the test, for example: PRIMARY CARE AND INDEPENDENT CONTRACTORS QUARANTINE HOTEL STAFF/SECURITY PERSONNE SOCIAL CARE attend-education-setting."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_referral_source",
"dataType": "varchar(17)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_result",
"dataType": "varchar(12)",
"sensitive": false,
"description": "This field represents the result of the test: INCONCLUSIVE INSUFFICIENT NEGATIVE POSITIVE ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_result_anlyser_platform",
"dataType": "varchar(5)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_result_covn",
"dataType": "varchar(8)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_result_covn_unit_of_measure",
"dataType": "varchar(3)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_result_covn_value",
"dataType": "decimal(6,3)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_result_covs",
"dataType": "varchar(8)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_result_covs_unit_of_measure",
"dataType": "varchar(4)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_result_covs_value",
"dataType": "decimal(6,1)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_result_info",
"dataType": "varchar(23)",
"sensitive": false,
"description": "This field represents the test result. Data is defined by: 2019-NCOV DETECTED. 2019-NCOV NOT DETECTED. ONE OR MORE CONTROLS ARE INVALID. REPEAT RUN. USE NEW REAGENTS. POSITIVE SARS-COV-2 SARS-COV-2 DETECTED SARS-COV-2 INCONCLUSIVE SARS-COV-2 NOT DETECTED VOID ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_result_record_source",
"dataType": "varchar(13)",
"sensitive": false,
"description": "This field represents the source of the result. Data is defined by: NHS DIGITAL SCOT SG LFT PORTAL ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_result_snomed_description",
"dataType": "varchar(109)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_result_snomed_id",
"dataType": "decimal(16,0)",
"sensitive": false,
"description": "This field represents the snomed id and is anonymised on release."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_result_value",
"dataType": "varchar(1)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_result_value_unit",
"dataType": "varchar(21)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_result_void_reason_code",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_survey_name",
"dataType": "varchar(21)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "test_type",
"dataType": "varchar(8)",
"sensitive": false,
"description": "This field represents the type of test. The data is defined by: ANTIGEN PCR ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "timestamp_specimen_processed",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "timestamp_specimen_received_at_lab",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "timestamp_test_end",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "timestamp_test_start",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "travel_destination_recent",
"dataType": "varchar(30)",
"sensitive": false,
"description": "This field represents a rescent travel destination."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "vaccination_period_submitted",
"dataType": "varchar(17)",
"sensitive": false,
"description": "This field represents the vacination period: 7-to-14-days less-than-7-days more-than-14-days ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "vaccination_status_submitted",
"dataType": "varchar(16)",
"sensitive": false,
"description": "This field represents the vaccine status: none type-a-one-dose type-a-two-doses ."
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "voc_area_name",
"dataType": "varchar(28)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "voc_flag_sample_of_interest",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "voc_operation",
"dataType": "varchar(20)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
},
{
"name": "covid_testing_reflex_assay_results",
"columns": [
{
"name": "voc_sample_sequencing_priority",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Covid 19 Test Results"
}
]
}
Copied to clipboard