Skip to content
Contact us Researcher login

Lighthouse

Summary

Abstract

Lighthouse laboratories [high-throughput facilities dedicated to COVID-19]

Keywords

Lighthouse Covid-19 TESTING HIC SCOTLAND

Publisher

  • Name
    Health Informatics Centre - University of Dundee
  • Logo

    Not available

  • Description
    Not available
  • Contact point
    Not available

Documentation

Description

ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources

Coverage

Spatial

  • Spatial coverage

    United Kingdom, Scotland

  • Geographic levels
    Not available

Temporal

  • Start date
    18/01/2019
  • End date
    10/09/2021
  • Frequency
    Static
  • Distribution release date
    19/05/2022

Provenance

  • Purpose
    Disease registry
  • Source
    Other
  • Collection situation
    Other

Access and governance

  • Conditions of access
    General 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 use
    Disclosure control
  • Resource creator
    NHS Scotland
  • Is referenced by
    Not available

Access

  • Access rights
  • Access service
    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. 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
  • Jurisdiction
    GB-SCT
  • Data controller
    Local NHS boards
  • Data processor
    University of Dundee, Health Informatics Centre

Format and standards

  • Language
    English
  • Format
    Database

Enrichment and linkage

  • Related datasets
    • Not available
  • Linkage opportunity
    Not 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": "Lighthouse",
    "abstract": "Lighthouse laboratories [high-throughput facilities dedicated to COVID-19]",
    "keywords": "Lighthouse;,;Covid-19;,;TESTING;,;HIC;,;SCOTLAND",
    "publisher": {
      "name": "Health Informatics Centre - University of Dundee",
      "gatewayId": "5baa31c1-0280-4482-b8b7-a4953869f184"
    },
    "inPipeline": "Not available",
    "shortTitle": "Lighthouse",
    "datasetType": "Health and disease",
    "description": "ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources",
    "contactPoint": "hicsupport@dundee.ac.uk",
    "datasetSubType": "Not applicable",
    "populationSize": 110088
  },
  "coverage": {
    "pathway": "Secondary care records for Tayside and Fife",
    "spatial": "United Kingdom,Scotland",
    "followUp": "Unknown",
    "typicalAgeRange": "0-150"
  },
  "required": {
    "issued": "2024-10-08T11:28:32.851245Z",
    "version": "1.0.0",
    "modified": "2024-10-08T11:28:32.85126Z",
    "gatewayId": "125",
    "revisions": [
      {
        "url": "https://web.prod.hdruk.cloud//dataset/125?version=1.0.0",
        "version": "1.0.0"
      }
    ],
    "gatewayPid": "04a90ad3-d27a-4498-b33b-09d139d8d44e"
  },
  "provenance": {
    "origin": {
      "source": "Other",
      "purpose": "Disease registry",
      "imageContrast": "Not stated",
      "collectionSituation": "Other"
    },
    "temporal": {
      "endDate": "2021-09-10",
      "timeLag": "Not applicable",
      "startDate": "2019-01-18",
      "accrualPeriodicity": "Static",
      "distributionReleaseDate": "2022-05-19"
    }
  },
  "observations": [
    {
      "observedNode": "Persons",
      "measuredValue": 110088,
      "observationDate": "2022-05-19",
      "measuredProperty": "COUNT",
      "disambiguatingDescription": "11,008 persons in this dataset"
    },
    {
      "observedNode": "Events",
      "measuredValue": 112229,
      "observationDate": "2022-05-19",
      "measuredProperty": "count",
      "disambiguatingDescription": "112,229 events in this dataset"
    }
  ],
  "accessibility": {
    "usage": {
      "resourceCreator": {
        "name": "NHS Scotland"
      },
      "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": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_home_client_group",
          "dataType": "varchar(8)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_home_council_area",
          "dataType": "varchar(19)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_home_council_area_code",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_home_int_authority_name",
          "dataType": "varchar(29)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "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": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_home_nhs_board",
          "dataType": "varchar(25)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_home_nhs_board_code",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_home_num_of_staff",
          "dataType": "decimal(6,3)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_home_num_registered_places",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_home_role",
          "dataType": "varchar(8)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_home_service",
          "dataType": "varchar(23)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_home_service_name",
          "dataType": "varchar(68)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_home_service_postcode",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_home_service_provider",
          "dataType": "varchar(95)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_home_service_provider_number",
          "dataType": "varchar(12)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "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": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "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": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "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": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_home_total_beds",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "date_appointment",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "This field represents the appointment date."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "date_ecoss_specimen",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "date_of_positive_test",
          "dataType": "bit",
          "sensitive": false,
          "description": "This field represents the date tested positive."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "date_onset_of_symptoms",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "This field represents the date of first symptoms."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "date_record_created",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "This field represents the date the record was created."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "date_reporting",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "This field represents the date of reporting."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "date_sample_scanned_lims",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "This field represents the date if scanning."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "date_specimen_processed",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "This field represents the processing date."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "date_specimen_received_at_ecoss",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "date_specimen_received_at_lab",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "date_test_end",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "date_test_receieved_at_bi",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "date_test_start",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "date_test_updated_at_bi",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "This is a date field ."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "date_vaccination_administered",
          "dataType": "date",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "dental_location_id",
          "dataType": "varchar(25)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "duration_appointment_to_test_start_days",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "duration_processing_time_hours",
          "dataType": "decimal(11,9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "duration_specimen_processed_to_bi_received_hours",
          "dataType": "decimal(13,9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "duration_specimen_received_at_lab_to_specimen_processed_days",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "duration_test_start_to_bi_received_days",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "duration_test_start_to_specimen_processed_days",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "duration_test_start_to_specimen_received_days",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "ecoss_doctor",
          "dataType": "bit",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "ecoss_organism",
          "dataType": "varchar(11)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "ecoss_reporting_health_board",
          "dataType": "varchar(27)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "ecoss_reporting_health_board_code",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "ecoss_reporting_health_board_code_orig",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "ecoss_requesting_location",
          "dataType": "bit",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "ecoss_specimen_source_type",
          "dataType": "varchar(13)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "ecoss_specimen_type",
          "dataType": "varchar(32)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "ecoss_submitting_laboratory",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "ecoss_submitting_laboratory_name",
          "dataType": "bit",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_administration_method_included",
          "dataType": "int",
          "sensitive": false,
          "description": "This field represents the flag result and is represented with a 0 or 1."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_care_home_test",
          "dataType": "int",
          "sensitive": false,
          "description": "This field represents the flag for test. The data is defined by 0 or 1."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_care_provided_by_local_authority",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_chi_exception_correction",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_cohort_pool_test",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_covid_symptomatic",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "This field represents the flag for symptomatic. The data is defined by       0   1   false   true   ."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_covid_symptomatic_included",
          "dataType": "int",
          "sensitive": false,
          "description": "This field represents the flag for symptomatic.  The data is defined by:   0   1   ."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_deduplicated_cases",
          "dataType": "int",
          "sensitive": false,
          "description": "This field represents the flag for deduplication. The data is defined by 0 or 1."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_derived_chi",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_first_positive_case",
          "dataType": "int",
          "sensitive": false,
          "description": "This field flags the first positive case. The data is defined by 0 or 1."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_has_recently_travelled",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "This field represents whether they have recently travelled. The data is defined by     1   false   true   ."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_home_testing",
          "dataType": "int",
          "sensitive": false,
          "description": "This field represents home testing. the data is defined by 0 or 1."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_lighthouse_labs_testing",
          "dataType": "int",
          "sensitive": false,
          "description": "This field represents the flag for lab testing the data is defined by 0 or 1."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_received_by_ecoss",
          "dataType": "int",
          "sensitive": false,
          "description": "This field represents the flag of received,. The data is defined by a 0 or 1."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_research_consent",
          "dataType": "bit",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_subject_household_positive_tested",
          "dataType": "bit",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_subject_non_digital_user",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "This field represents the flag for a non digital user. The data is defined by 0 or 1."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_subject_positive_tested",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "This field represents whether the person has tested positive. The data is defined by     No   Yes   ."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "flag_submitted_ethnicity_included",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "home_test_sample_collection_location",
          "dataType": "varchar(13)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "id_subject_geography",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "id_subject_practice",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "id_submitted_subject_geography",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "key_worker_grouping",
          "dataType": "varchar(16)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "key_worker_id",
          "dataType": "bit",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "key_worker_mobile_number",
          "dataType": "bit",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "key_worker_organisation",
          "dataType": "varchar(29)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "key_worker_priority_code",
          "dataType": "bit",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "laboratory_code",
          "dataType": "varchar(25)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "laboratory_name",
          "dataType": "varchar(23)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "laboratory_type",
          "dataType": "varchar(18)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "lighthouse_source_file_name",
          "dataType": "varchar(34)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "organisation_country",
          "dataType": "varchar(16)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "organisation_name",
          "dataType": "varchar(68)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "organisation_reference_id",
          "dataType": "varchar(25)",
          "sensitive": false,
          "description": "This field is the organisation id and is anonymised on output."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "organisation_role",
          "dataType": "varchar(33)",
          "sensitive": false,
          "description": "This field represents the role within the organisation for example:     CARE HOME - VISITING PROFESSIONAL   CARE HOME - VISITOR   CARE HOME STAFF  ."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "specimen_id",
          "dataType": "varchar(32)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_chi_seeding_weight",
          "dataType": "decimal(5,3)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_date_of_birth",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_derived_age_years",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_ethnicity",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_first_name",
          "dataType": "varchar(15)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_landline",
          "dataType": "varchar(13)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_practice_location_code",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_practice_location_type",
          "dataType": "varchar(5)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_practice_nhs_board",
          "dataType": "varchar(27)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_practice_nhs_board_code",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_residence_council_area",
          "dataType": "varchar(21)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_residence_council_area_code_9",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_residence_datazone_deprivation_decile",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_residence_hscp_code",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_residence_hscp_name",
          "dataType": "varchar(30)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_residence_nhs_board",
          "dataType": "varchar(30)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_residence_nhs_board_code",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_residence_nhs_board_orig",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_residence_postcode",
          "dataType": "varchar(7)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_residence_postcode_datazone",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_residence_postcode_easting",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_residence_postcode_encrypted",
          "dataType": "varchar(32)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_residence_postcode_northing",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_sex",
          "dataType": "varchar(6)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_sex_code",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_surname",
          "dataType": "varchar(20)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "subject_upi",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_country_test_centre",
          "dataType": "varchar(25)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_key_worker_name",
          "dataType": "bit",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_address_line_1",
          "dataType": "varchar(150)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_address_line_2",
          "dataType": "varchar(150)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_age",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_city",
          "dataType": "varchar(150)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_commissioning_organisation",
          "dataType": "varchar(25)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_council_area",
          "dataType": "varchar(21)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_council_area_code_9",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_country",
          "dataType": "varchar(8)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_country_code",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_county",
          "dataType": "varchar(22)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_date_of_birth",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_easting",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_email_address",
          "dataType": "varchar(81)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_employer_name",
          "dataType": "varchar(150)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_ethnicity",
          "dataType": "varchar(52)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_first_name",
          "dataType": "varchar(50)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_hscp_code",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_hscp_name",
          "dataType": "varchar(30)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_id",
          "dataType": "varchar(36)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_industry_sector",
          "dataType": "varchar(33)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_llsoa",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_local_authority",
          "dataType": "varchar(25)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_lower_tier_authority",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_nhs_number",
          "dataType": "varchar(12)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_nhs_region",
          "dataType": "varchar(3)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_northing",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_occupation",
          "dataType": "varchar(66)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_occupation_title",
          "dataType": "varchar(65)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_parliamentary_constituency",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_phone_number",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_postcode",
          "dataType": "varchar(7)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_postcode_country",
          "dataType": "varchar(8)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_postcode_encrypted",
          "dataType": "varchar(32)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_practice_location_code",
          "dataType": "bit",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_residence_nhs_board",
          "dataType": "varchar(30)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_residence_nhs_board_code",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_residence_nhs_board_orig",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_sex",
          "dataType": "varchar(25)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_stp",
          "dataType": "varchar(9)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_study_grade",
          "dataType": "varchar(16)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_study_institution_name",
          "dataType": "varchar(150)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_study_institution_postcode",
          "dataType": "varchar(8)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_study_institution_town",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_surname",
          "dataType": "nvarchar(21)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_work_or_study_status",
          "dataType": "varchar(19)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_workstatus",
          "dataType": "varchar(52)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_administration_method",
          "dataType": "varchar(24)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_centre_associated_rts",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_centre_group",
          "dataType": "varchar(16)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_centre_id",
          "dataType": "varchar(4)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_centre_name",
          "dataType": "varchar(150)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_ch1_result_ct_value",
          "dataType": "varchar(15)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_ch1_target_gene",
          "dataType": "varchar(11)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_ch1_target_gene_result",
          "dataType": "varchar(12)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_ch2_result_ct_value",
          "dataType": "varchar(15)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_ch2_target_gene",
          "dataType": "varchar(6)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_ch2_target_gene_result",
          "dataType": "varchar(12)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_ch3_result_ct_value",
          "dataType": "varchar(15)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_ch3_target_gene",
          "dataType": "varchar(6)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_ch3_target_gene_result",
          "dataType": "varchar(12)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_ch4_result_ct_value",
          "dataType": "varchar(15)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_ch4_target_gene",
          "dataType": "varchar(3)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_ch4_target_gene_result",
          "dataType": "varchar(8)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_id",
          "dataType": "varchar(44)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_kit",
          "dataType": "varchar(6)",
          "sensitive": false,
          "description": "This field represents which test kit was used :     LFT   LUMIRA DX   ."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_location",
          "dataType": "varchar(16)",
          "sensitive": false,
          "description": "This field represents the location of the test:     NON-HOME ADDRESS   WALKIN   ."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_reason",
          "dataType": "varchar(33)",
          "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": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_referral_source",
          "dataType": "varchar(13)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_result",
          "dataType": "varchar(12)",
          "sensitive": false,
          "description": "This field represents the result of the test:   INCONCLUSIVE   INSUFFICIENT   NEGATIVE   POSITIVE   ."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_result_info",
          "dataType": "varchar(63)",
          "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": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "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": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_result_snomed_description",
          "dataType": "varchar(109)",
          "sensitive": false,
          "description": "This field represents the snomed description. The data is defined by:      SARS-CoV-2 (severe acute respiratory syndrome coronavirus 2) RNA (ribonucleic acid) detection result negative   SARS-CoV-2 (severe acute respiratory syndrome coronavirus 2) RNA (ribonucleic acid) detection result positive   SARS-CoV-2 (severe acute respiratory syndrome coronavirus 2) RNA (ribonucleic acid) detection result unknown   SARS-CoV-2 (severe acute respiratory syndrome coronavirus 2) antigen detection result negative   SARS-CoV-2 (severe acute respiratory syndrome coronavirus 2) antigen detection result positive   SARS-CoV-2 (severe acute respiratory syndrome coronavirus 2) antigen detection result unknown   ."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "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": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_type",
          "dataType": "varchar(7)",
          "sensitive": false,
          "description": "This field represents the type of test. The data is defined by:    ANTIGEN   PCR   ."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "timestamp_specimen_processed",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "This field represents the date time the specimen was processed."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "timestamp_specimen_received_at_lab",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "timestamp_test_end",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "timestamp_test_start",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "travel_destination_recent",
          "dataType": "varchar(150)",
          "sensitive": false,
          "description": "This field represents a rescent travel destination."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "vaccination_period_submitted",
          "dataType": "varchar(50)",
          "sensitive": false,
          "description": "This field represents the vacination period:      7-to-14-days   less-than-7-days   more-than-14-days   ."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "vaccination_status_submitted",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "This field represents the vaccine status:     none   type-a-one-dose   type-a-two-doses   ."
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "hic_dataLoadRunID",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "hic_validFrom",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "care_organisation_nhs_board_orig",
          "dataType": "varchar(200)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "organisation_nhs_board_orig",
          "dataType": "varchar(200)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "submitted_subject_study_institution_nhs_board_orig",
          "dataType": "varchar(200)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_centre_nhs_board_orig",
          "dataType": "varchar(200)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "test_survey_name",
          "dataType": "varchar(200)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "voc_area_name",
          "dataType": "varchar(200)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "voc_flag_sample_of_interest",
          "dataType": "varchar(200)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "voc_operation",
          "dataType": "varchar(200)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    },
    {
      "name": "lighthouseECOSSTesting",
      "columns": [
        {
          "name": "voc_sample_sequencing_priority",
          "dataType": "varchar(200)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "The view contains all Pillar 1, 2 & 3 test results along with the Antigen test results at moment.   ECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for all SARS-CoV-2 RT-PCR tests carried out in Scotland are being collated by ECOSS and can be linked to other data sources"
    }
  ]
}

Copied to clipboard

Back to the top