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
-
DocumentationDocumentation
-
LanguageEnglish
-
Geographic AreaScotland
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.
-
PublisherHealth Informatics Centre - University of Dundee
-
Contacthicsupport@dundee.ac.uk
Synthetic data
Synthetic data is not yet available for this dataset.
Key Details
-
Formal release or publication date19/05/2022
-
Start time period of data covered by this dataset18/01/2019
-
End time period of data covered by this dataset10/09/2021
-
DocumentationECOSS is a database that holds surveillance data on various microorganisms (e.g. influenza virus, coronavirus) and infections reported from NHS diagnostic and reference laboratories and Pillar 2 facilities/Lighthouse laboratories [high-throughput facilities dedicated to COVID-19 viral Reverse Transcription-Polymerase Chain Reaction (RT-PCR) testing for the National Testing Programme]. Data on laboratory results for 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 AreaUnited Kingdom,Scotland
-
Landing page
-
LanguageEnglish
-
The dataset typePHYSICAL
-
Update frequencystatic