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

ADR  > Lighthouse @ 125

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

Scottish Health Data

NHS Scotland

care_home_client_group

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

lighthouseECOSSTesting

care_home_council_area

care_home_council_area_code

care_home_int_authority_name

This field represents the main type of care within the carehome:   Acquired brain injury   Alcohol related brain injury   Autism spectrum disorders.

care_home_main_area_of_care

care_home_nhs_board

care_home_nhs_board_code

care_home_num_of_staff

care_home_num_registered_places

care_home_role

care_home_service

care_home_service_name

care_home_service_postcode

care_home_service_provider

care_home_service_provider_number

This field represents the status of the carehome:   Active   Inactive   Proposing to Cancel   .

care_home_service_status

This field represents  the type of carehome. The data is represented by:    Health Board   Local Authority   Private   Voluntary or Not for Profit   NULL.

care_home_service_type

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   .

care_home_sub_type

care_home_total_beds

This field represents the appointment date.

date_appointment

date_ecoss_specimen

This field represents the date tested positive.

date_of_positive_test

This field represents the date of first symptoms.

date_onset_of_symptoms

This field represents the date the record was created.

date_record_created

This field represents the date of reporting.

date_reporting

This field represents the date if scanning.

date_sample_scanned_lims

This field represents the processing date.

date_specimen_processed

date_specimen_received_at_ecoss

date_specimen_received_at_lab

date_test_end

date_test_receieved_at_bi

date_test_start

date_test_updated_at_bi

date_vaccination_administered

dental_location_id

duration_appointment_to_test_start_days

duration_processing_time_hours

duration_specimen_processed_to_bi_received_hours

duration_specimen_received_at_lab_to_specimen_processed_days

duration_test_start_to_bi_received_days

duration_test_start_to_specimen_processed_days

duration_test_start_to_specimen_received_days

ecoss_doctor

ecoss_organism

ecoss_reporting_health_board

ecoss_reporting_health_board_code

ecoss_reporting_health_board_code_orig

ecoss_requesting_location

ecoss_specimen_source_type

ecoss_specimen_type

ecoss_submitting_laboratory

ecoss_submitting_laboratory_name

This field represents the flag result and is represented with a 0 or 1.

flag_administration_method_included

This field represents the flag for test. The data is defined by 0 or 1.

flag_care_home_test

flag_care_provided_by_local_authority

flag_chi_exception_correction

flag_cohort_pool_test

This field represents the flag for symptomatic. The data is defined by       0   1   false   true   .

flag_covid_symptomatic

This field represents the flag for symptomatic.  The data is defined by:   0   1   .

flag_covid_symptomatic_included

This field represents the flag for deduplication. The data is defined by 0 or 1.

flag_deduplicated_cases

flag_derived_chi

This field flags the first positive case. The data is defined by 0 or 1.

flag_first_positive_case

This field represents whether they have recently travelled. The data is defined by     1   false   true   .

flag_has_recently_travelled

This field represents home testing. the data is defined by 0 or 1.

flag_home_testing

This field represents the flag for lab testing the data is defined by 0 or 1.

flag_lighthouse_labs_testing

This field represents the flag of received,. The data is defined by a 0 or 1.

flag_received_by_ecoss

flag_research_consent

flag_subject_household_positive_tested

This field represents the flag for a non digital user. The data is defined by 0 or 1.

flag_subject_non_digital_user

This field represents whether the person has tested positive. The data is defined by     No   Yes   .

flag_subject_positive_tested

flag_submitted_ethnicity_included

home_test_sample_collection_location

id_subject_geography

id_subject_practice

id_submitted_subject_geography

key_worker_grouping

key_worker_id

key_worker_mobile_number

key_worker_organisation

key_worker_priority_code

laboratory_code

laboratory_name

laboratory_type

lighthouse_source_file_name

organisation_country

organisation_name

This field is the organisation id and is anonymised on output.

organisation_reference_id

This field represents the role within the organisation for example:     CARE HOME - VISITING PROFESSIONAL   CARE HOME - VISITOR   CARE HOME STAFF  .

Lighthouse

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin