Skip to content
Return to search

Lighthouse

Description

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

Related tags

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": "Not applicable",
      "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

Additional information

  • Documentation
    Documentation
  • Language
    English
  • Geographic Area
    Scotland

Related resources

No information available

Requesting access to this data

This is a secure dataset that can only be accessed by researchers from approved organisations.

  • Publisher
    Health Informatics Centre - University of Dundee
  • Contact
    hicsupport@dundee.ac.uk

Find out how to apply to access this dataset

Synthetic data

Synthetic data is not yet available for this dataset. 

Key Details

  • Formal release or publication date
    19/05/2022
  • Start time period of data covered by this dataset
    18/01/2019
  • End time period of data covered by this dataset
    10/09/2021
  • Documentation
    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
  • Geographic Area
    United Kingdom,Scotland
  • Landing page
  • Language
    English
  • The dataset type
    PHYSICAL
  • Update frequency
    static