Analysis of ‘COVID-19 State Data’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/nightranger77/covid19-state-data on 28 January 2022.

--- Dataset description provided by original source is as follows ---

This dataset is a per-state amalgamation of demographic, public health and other relevant predictors for COVID-19.

Deaths, Infections and Tests by State

The COVID Tracking Project: https://covidtracking.com/data/api

Used positive, death and totalTestResults from the API for, respectively, Infected, Deaths and Tested in this dataset. Please read the documentation of the API for more context on those columns

Predictor Data and Sources

Population (2020)

Density is people per meter squared https://worldpopulationreview.com/states/

ICU Beds and Age 60+

https://khn.org/news/as-coronavirus-spreads-widely-millions-of-older-americans-live-in-counties-with-no-icu-beds/

GDP

https://worldpopulationreview.com/states/gdp-by-state/

Income per capita (2018)

https://worldpopulationreview.com/states/per-capita-income-by-state/

Gini

https://en.wikipedia.org/wiki/List_of_U.S._states_by_Gini_coefficient

Unemployment (2020)

Rates from Feb 2020 and are percentage of labor force
https://www.bls.gov/web/laus/laumstrk.htm

Sex (2017)

Ratio is Male / Female
https://www.kff.org/other/state-indicator/distribution-by-gender/

Smoking Percentage (2020)

https://worldpopulationreview.com/states/smoking-rates-by-state/

Influenza and Pneumonia Death Rate (2018)

Death rate per 100,000 people
https://www.cdc.gov/nchs/pressroom/sosmap/flu_pneumonia_mortality/flu_pneumonia.htm

Chronic Lower Respiratory Disease Death Rate (2018)

Death rate per 100,000 people
https://www.cdc.gov/nchs/pressroom/sosmap/lung_disease_mortality/lung_disease.htm

Active Physicians (2019)

https://www.kff.org/other/state-indicator/total-active-physicians/

Hospitals (2018)

https://www.kff.org/other/state-indicator/total-hospitals

Health spending per capita

Includes spending for all health care services and products by state of residence. Hospital spending is included and reflects the total net revenue. Costs such as insurance, administration, research, and construction expenses are not included.
https://www.kff.org/other/state-indicator/avg-annual-growth-per-capita/

Pollution (2019)

Pollution: Average exposure of the general public to particulate matter of 2.5 microns or less (PM2.5) measured in micrograms per cubic meter (3-year estimate)
https://www.americashealthrankings.org/explore/annual/measure/air/state/ALL

Medium and Large Airports

For each state, number of medium and large airports https://en.wikipedia.org/wiki/List_of_the_busiest_airports_in_the_United_States

Temperature (2019)

Note that FL was incorrect in the table, but is corrected in the Hottest States paragraph
https://worldpopulationreview.com/states/average-temperatures-by-state/
District of Columbia temperature computed as the average of Maryland and Virginia

Urbanization (2010)

Urbanization as a percentage of the population https://www.icip.iastate.edu/tables/population/urban-pct-states

Age Groups (2018)

https://www.kff.org/other/state-indicator/distribution-by-age/

School Closure Dates

Schools that haven't closed are marked NaN https://www.edweek.org/ew/section/multimedia/map-coronavirus-and-school-closures.html

Note that some datasets above did not contain data for District of Columbia, this missing data was found via Google searches manually entered.

--- Original source retains full ownership of the source dataset ---

Context

Amidst the COVID-19 outbreak, the world is facing great crisis in every way. The value and things we built as a human race are going through tremendous challenges. It is a very small effort to bring curated data set on Novel Corona Virus to accelerate the forecasting and analytical experiments to cope up with this critical situation. It will help to visualize the country level out break and to keep track on regularly added new incidents.

COVID-19 Country Level Timeseries Dataset

This Dataset contains country wise public domain time series information on COVID-19 outbreak. The Data is sorted alphabetically on Country name and Date of Observation.

Column Descriptions

The data set contains the following columns:
ObservationDate: The date on which the incidents are observed country: Country of the Outbreak Confirmed: Number of confirmed cases till observation date Deaths: Number of death cases till observation date Recovered: Number of recovered cases till observation date New Confirmed: Number of new confirmed cases on observation date New Deaths: Number of New death cases on observation date New Recovered: Number of New recovered cases on observation date latitude: Latitude of the affected country longitude: Longitude of the affected country

Acknowledgements

This data set is a cleaner version of the https://www.kaggle.com/sudalairajkumar/novel-corona-virus-2019-dataset data set with added geo location information and regularly added incident counts. I would like to thank this great effort by SRK.

Original Data Source

Johns Hopkins University MoBS lab - https://www.mobs-lab.org/2019ncov.html World Health Organization (WHO): https://www.who.int/ DXY.cn. Pneumonia. 2020. http://3g.dxy.cn/newh5/view/pneumonia. BNO News: https://bnonews.com/index.php/2020/02/the-latest-coronavirus-cases/ National Health Commission of the People’s Republic of China (NHC): http://www.nhc.gov.cn/xcs/yqtb/list_gzbd.shtml China CDC (CCDC): http://weekly.chinacdc.cn/news/TrackingtheEpidemic.htm Hong Kong Department of Health: https://www.chp.gov.hk/en/features/102465.html Macau Government: https://www.ssm.gov.mo/portal/ Taiwan CDC: https://sites.google.com/cdc.gov.tw/2019ncov/taiwan?authuser=0 US CDC: https://www.cdc.gov/coronavirus/2019-ncov/index.html Government of Canada: https://www.canada.ca/en/public-health/services/diseases/coronavirus.html Australia Government Department of Health: https://www.health.gov.au/news/coronavirus-update-at-a-glance European Centre for Disease Prevention and Control (ECDC): https://www.ecdc.europa.eu/en/geographical-distribution-2019-ncov-cases Ministry of Health Singapore (MOH): https://www.moh.gov.sg/covid-19 Italy Ministry of Health: http://www.salute.gov.it/nuovocoronavirus

This dataset is a per-state amalgamation of demographic, public health and other relevant predictors for COVID-19.

Deaths, Infections and Tests by State

The COVID Tracking Project: https://covidtracking.com/data/api

Used positive, death and totalTestResults from the API for, respectively, Infected, Deaths and Tested in this dataset. Please read the documentation of the API for more context on those columns

Predictor Data and Sources

Population (2020)

Density is people per meter squared https://worldpopulationreview.com/states/

ICU Beds and Age 60+

https://khn.org/news/as-coronavirus-spreads-widely-millions-of-older-americans-live-in-counties-with-no-icu-beds/

GDP

https://worldpopulationreview.com/states/gdp-by-state/

Income per capita (2018)

https://worldpopulationreview.com/states/per-capita-income-by-state/

Gini

https://en.wikipedia.org/wiki/List_of_U.S._states_by_Gini_coefficient

Unemployment (2020)

Rates from Feb 2020 and are percentage of labor force
https://www.bls.gov/web/laus/laumstrk.htm

Sex (2017)

Ratio is Male / Female
https://www.kff.org/other/state-indicator/distribution-by-gender/

Smoking Percentage (2020)

https://worldpopulationreview.com/states/smoking-rates-by-state/

Influenza and Pneumonia Death Rate (2018)

Death rate per 100,000 people
https://www.cdc.gov/nchs/pressroom/sosmap/flu_pneumonia_mortality/flu_pneumonia.htm

Chronic Lower Respiratory Disease Death Rate (2018)

Death rate per 100,000 people
https://www.cdc.gov/nchs/pressroom/sosmap/lung_disease_mortality/lung_disease.htm

Active Physicians (2019)

https://www.kff.org/other/state-indicator/total-active-physicians/

Hospitals (2018)

https://www.kff.org/other/state-indicator/total-hospitals

Health spending per capita

Includes spending for all health care services and products by state of residence. Hospital spending is included and reflects the total net revenue. Costs such as insurance, administration, research, and construction expenses are not included.
https://www.kff.org/other/state-indicator/avg-annual-growth-per-capita/

Pollution (2019)

Pollution: Average exposure of the general public to particulate matter of 2.5 microns or less (PM2.5) measured in micrograms per cubic meter (3-year estimate)
https://www.americashealthrankings.org/explore/annual/measure/air/state/ALL

Medium and Large Airports

For each state, number of medium and large airports https://en.wikipedia.org/wiki/List_of_the_busiest_airports_in_the_United_States

Temperature (2019)

Note that FL was incorrect in the table, but is corrected in the Hottest States paragraph
https://worldpopulationreview.com/states/average-temperatures-by-state/
District of Columbia temperature computed as the average of Maryland and Virginia

Urbanization (2010)

Urbanization as a percentage of the population https://www.icip.iastate.edu/tables/population/urban-pct-states

Age Groups (2018)

https://www.kff.org/other/state-indicator/distribution-by-age/

School Closure Dates

Schools that haven't closed are marked NaN https://www.edweek.org/ew/section/multimedia/map-coronavirus-and-school-closures.html

Note that some datasets above did not contain data for District of Columbia, this missing data was found via Google searches manually entered.

OMOP dataset: Hospital COVID patients: severity, acuity, therapies, outcomes Dataset number 2.0

Coronavirus disease 2019 (COVID-19) was identified in January 2020. Currently, there have been more than 6 million cases & more than 1.5 million deaths worldwide. Some individuals experience severe manifestations of infection, including viral pneumonia, adult respiratory distress syndrome (ARDS) & death. There is a pressing need for tools to stratify patients, to identify those at greatest risk. Acuity scores are composite scores which help identify patients who are more unwell to support & prioritise clinical care. There are no validated acuity scores for COVID-19 & it is unclear whether standard tools are accurate enough to provide this support. This secondary care COVID OMOP dataset contains granular demographic, morbidity, serial acuity and outcome data to inform risk prediction tools in COVID-19.

PIONEER geography The West Midlands (WM) has a population of 5.9 million & includes a diverse ethnic & socio-economic mix. There is a higher than average percentage of minority ethnic groups. WM has a large number of elderly residents but is the youngest population in the UK. Each day >100,000 people are treated in hospital, see their GP or are cared for by the NHS. The West Midlands was one of the hardest hit regions for COVID admissions in both wave 1 & 2.

EHR. University Hospitals Birmingham NHS Foundation Trust (UHB) is one of the largest NHS Trusts in England, providing direct acute services & specialist care across four hospital sites, with 2.2 million patient episodes per year, 2750 beds & 100 ITU beds. UHB runs a fully electronic healthcare record (EHR) (PICS; Birmingham Systems), a shared primary & secondary care record (Your Care Connected) & a patient portal “My Health”. UHB has cared for >5000 COVID admissions to date. This is a subset of data in OMOP format.

Scope: All COVID swab confirmed hospitalised patients to UHB from January – August 2020. The dataset includes highly granular patient demographics & co-morbidities taken from ICD-10 & SNOMED-CT codes. Serial, structured data pertaining to care process (timings, staff grades, specialty review, wards), presenting complaint, acuity, all physiology readings (pulse, blood pressure, respiratory rate, oxygen saturations), all blood results, microbiology, all prescribed & administered treatments (fluids, antibiotics, inotropes, vasopressors, organ support), all outcomes.

Available supplementary data: Health data preceding & following admission event. Matched “non-COVID” controls; ambulance, 111, 999 data, synthetic data. Further OMOP data available as an additional service.

Available supplementary support: Analytics, Model build, validation & refinement; A.I.; Data partner support for ETL (extract, transform & load) process, Clinical expertise, Patient & end-user access, Purchaser access, Regulatory requirements, Data-driven trials, “fast screen” services.

Rank, number of deaths, percentage of deaths, and age-specific mortality rates for the leading causes of death, by age group and sex, 2000 to most recent year.

Context - Covid data falsification discussion:

An active discussion about the mortality data in Moscow has erupted in the days. The Moscow Times newspaper drew attention to a significant increase in official mortality rates in April 2020: "Moscow recorded 20% more fatalities in April 2020 compared to its average April mortality total over the past decade, according to newly published preliminary data from Moscow’s civil registry office. The data comes as Russia sees the fastest growth in coronavirus infections in Europe, while its mortality rate remains much lower than in many countries. Moscow, the epicenter of Russia’s coronavirus outbreak, has continued to see daily spikes in new cases despite being under lockdown since March 30. According to the official data, 11,846 people died in Russia’s capital in April of this year, roughly a 20% increase from the 10-year average for April deaths, which is 9,866. The numbers suggest that the city’s statistics of coronavirus deaths may be higher in reality than official numbers indicate. Russia boasts a relatively low coronavirus mortality rate of 0.9%, which experts believe is linked to the way coronavirus-related deaths are counted."

After this publication have been realesed The Moscow Department of Health has denied the statement of the inaccuracy of counting.:

First, Moscow is a region that openly publishes mortality data on its websites. Moscow on an initiative basis published data for April before the federal structures did it. Secondly, the comparison of mortality rates in the monthly dynamics is incorrect and is not a clear evidence of any trends. In April 2020, indeed, according to the Civil Registry Office in Moscow, 11,846 death certificates were issued. So, the increase compared to April 2019 amounted to 1841 people, and compared to the same month of 2018 - 985 people, i.e. 2 times less. Thirdly, the diagnosis of coronavirus-infected deaths in Moscow is established after a mandatory autopsy is performed in strict accordance with the Provisional Guidelines of the Russian Ministry of Health.Of the total number of deaths in April 2020, 639 are people whose cause of death is coronavirus infection and its complications, most often pneumonia.It should be emphasized that the pathological autopsy of the dead with suspected CoV-19 in Russia and Moscow is carried out in 100% of cases, unlike most other countries.It is impossible to name the cause of death of COVID-19 in other cases. For example, over 60% of deaths occurred from obvious alternative causes, such as vascular accidents (myocardial infarction and stroke), stage 4 malignant diseases (essentially palliative patients), leukemia, systemic diseases with the development of organ failure (e.g. amyloidosis and terminal renal insufficiency) and other non-curable deadly diseases. Fourth, any seasonal increase in the incidence of SARS, not to mention the pandemic caused by the spread of the new coronavirus, is always accompanied by an increase in mortality. This is due to the appearance of the dead directly from an infectious disease, but to an even greater extent from other diseases, the exacerbation of which and the decompensation of the condition of patients suffering from these diseases also leads to death. In these cases, the infectious onset is a catalyst for the rapid progression of chronic diseases and the manifestation of new diseases. Fifthly, a similar situation with statistics is observed in other countries - mortality from COVID-19 is lower than the overall increase in mortality. According to the official sites of cities:In New York, mortality from coronavirus in April amounted to 11,861 people. At the same time, the total increase in mortality compared to the same period in 2019 is 15709.In London, in April, 3,589 people died with a diagnosis of coronavirus, while the total increase was 5531 Sixth, even if all the additional mortality for April in Moscow is attributed to coronavirus, the mortality from COVID will be slightly more than 3%, which is lower than the official mortality in New York and London (10% and 23%, respectively). Moreover, if you make such a recount in these cities, the mortality rate in them will be 13% and 32%, respectively. Seventh, Moscow is open for discussion and is ready to share experience with both Russian and foreign experts.

Content

I think community members would be interested in studying the data on mortality in the Russian capital themselves and conducting a competent statistical check.

This may be of particular interest in connection with that he [US announced a grant of $ 250 thousand to "expose the disinformation of health care" in Russia](https://www....

PIONEER: The impact of ethnicity and multi-morbidity on COVID-related outcomes; a primary care supplemented hospitalised dataset Dataset number 3.0

Coronavirus disease 2019 (COVID-19) was identified in January 2020. Currently, there have been more than 65million cases and more than 1.5 million deaths worldwide. Some individuals experience severe manifestations of infection, including viral pneumonia, adult respiratory distress syndrome (ARDS) and death. Evidence suggests that older patients, those from some ethnic minority groups and those with multiple long-term health conditions have worse outcomes. This secondary care COVID dataset contains granular demographic and morbidity data, supplemented from primary care records, to add to the understanding of patient factors on disease outcomes.

PIONEER geography The West Midlands (WM) has a population of 5.9 million & includes a diverse ethnic & socio-economic mix. There is a higher than average percentage of minority ethnic groups. WM has a large number of elderly residents but is the youngest population in the UK. Each day >100,000 people are treated in hospital, see their GP or are cared for by the NHS. The West Midlands was one of the hardest hit regions for COVID admissions in both wave 1 and 2.

EHR. University Hospitals Birmingham NHS Foundation Trust (UHB) is one of the largest NHS Trusts in England, providing direct acute services & specialist care across four hospital sites, with 2.2 million patient episodes per year, 2750 beds & 100 ITU beds. UHB runs a fully electronic healthcare record (EHR) (PICS; Birmingham Systems), a shared primary & secondary care record (Your Care Connected) & a patient portal “My Health”. UHB has cared for >5000 COVID admissions to date.

Scope: All COVID swab confirmed hospitalised patients to UHB from January – May 2020. The dataset includes highly granular patient demographics & co-morbidities taken from ICD-10 & SNOMED-CT codes but also primary care records and clinic letters. Serial, structured data pertaining to care process (timings, staff grades, specialty review, wards), presenting complaint, acuity, all physiology readings (pulse, blood pressure, respiratory rate, oxygen saturations), all blood results, microbiology, all prescribed & administered treatments (fluids, antibiotics, inotropes, vasopressors, organ support), all outcomes. Linked images available (radiographs, CT, MRI, ultrasound).

Available supplementary data: Health data preceding and following admission event. Matched “non-COVID” controls; ambulance, 111, 999 data, synthetic data.

Available supplementary support: Analytics, Model build, validation & refinement; A.I.; Data partner support for ETL (extract, transform & load) process, Clinical expertise, Patient & end-user access, Purchaser access, Regulatory requirements, Data-driven trials, “fast screen” services.

Effective September 27, 2023, this dataset will no longer be updated. Similar data are accessible from wonder.cdc.gov.

Deaths involving COVID-19, pneumonia, and influenza reported to NCHS by sex, age group, and jurisdiction of occurrence.

This record contains raw data related to article "High mortality in COVID-19 patients with mild respiratory disease"

Introduction: Severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2) has infected 189 000 people in Italy, with more than 25 000 deaths. Several predictive factors of mortality have been identified; however, none has been validated in patients presenting with mild disease.

Methods: Patients with a diagnosis of interstitial pneumonia caused by SARS-CoV-2, presenting with mild symptoms, and requiring hospitalization in a non-intensive care unit with known discharge status were prospectively collected and retrospectively analysed. Demographical, clinical and biochemical parameters were recorded, as need for non-invasive mechanical ventilation and admission in intensive care unit. Univariate and multivariate logistic regression analyses were used to identify independent predictors of death.

Results: Between 28 February and 10 April 2020, 229 consecutive patients were included in the study cohort; the majority were males with a mean age of 60 years. 54% of patients had at least one comorbidity, with hypertension being the most commonly represented, followed by diabetes mellitus. 196 patients were discharged after a mean of 9 days, while 14.4% died during hospitalization because of respiratory failure. Age higher than 75 years, low platelet count (<150 × 103 /mm3 ) and higher ferritin levels (>750 ng/mL) were independent predictors of death. Comorbidities were not independently associated with in-hospital mortality.

Conclusions: In-hospital mortality of patients with COVID-19 presenting with mild symptoms is high and is associated with older age, platelet count and ferritin levels. Identifying early predictors of outcome can be useful in the clinical practice to better stratify and manage patients with COVID-19.

PIONEER: Deeply-phenotyped hospital COVID patients: severity, acuity, therapies, outcomes Dataset number 4.0

Coronavirus disease 2019 (COVID-19) was identified in January 2020. Currently, there have been more than 6 million cases& more than 1.5 million deaths worldwide. Some individuals experience severe manifestations of infection, including viral pneumonia, adult respiratory distress syndrome (ARDS)& death. There is a pressing need for tools to stratify patients, to identify those at greatest risk. Acuity scores are composite scores which help identify patients who are more unwell to support & prioritise clinical care. There are no validated acuity scores for COVID-19 & it is unclear whether standard tools are accurate enough to provide this support. This secondary care COVID dataset contains granular demographic, morbidity, serial acuity and outcome data to inform risk prediction tools in COVID-19.

PIONEER geography The West Midlands (WM) has a population of 5.9 million & includes a diverse ethnic & socio-economic mix. There is a higher than average percentage of minority ethnic groups. WM has a large number of elderly residents but is the youngest population in the UK. Each day >100,000 people are treated in hospital, see their GP or are cared for by the NHS. The West Midlands was one of the hardest hit regions for COVID admissions in both wave 1 & 2.

EHR. University Hospitals Birmingham NHS Foundation Trust (UHB) is one of the largest NHS Trusts in England, providing direct acute services & specialist care across four hospital sites, with 2.2 million patient episodes per year, 2750 beds & 100 ITU beds. UHB runs a fully electronic healthcare record (EHR) (PICS; Birmingham Systems), a shared primary & secondary care record (Your Care Connected) & a patient portal “My Health”. UHB has cared for >5000 COVID admissions to date.

Scope: All COVID swab confirmed hospitalised patients to UHB from January – May 2020. The dataset includes highly granular patient demographics & co-morbidities taken from ICD-10 & SNOMED-CT codes but also primary care records& clinic letters. Serial, structured data pertaining to care process (timings, staff grades, specialty review, wards), presenting complaint, acuity, all physiology readings (pulse, blood pressure, respiratory rate, oxygen saturations), all blood results, microbiology, all prescribed & administered treatments (fluids, antibiotics, inotropes, vasopressors, organ support), all outcomes. Linked images available (radiographs, CT, MRI, ultrasound).

Available supplementary data: Health data preceding & following admission event. Matched “non-COVID” controls; ambulance, 111, 999 data, synthetic data.

Available supplementary support: Analytics, Model build, validation & refinement; A.I.; Data partner support for ETL (extract, transform & load) process, Clinical expertise, Patient & end-user access, Purchaser access, Regulatory requirements, Data-driven trials, “fast screen” services.

Context

• A new coronavirus designated 2019-nCoV was first identified in Wuhan, the capital of China's Hubei province
• People developed pneumonia without a clear cause and for which existing vaccines or treatments were not effective.
• The virus has shown evidence of human-to-human transmission
• Transmission rate (rate of infection) appeared to escalate in mid-January 2020
• As of 16 March 2020, approximately 170,237 cases have been confirmed
• In India, 110 cases have been confirmed until 15th March, 2020.

Content

Each row represent the daily confirmed cases in India.

Acknowledgements

Ministry of Health and Family Welfare.

Inspiration

To create awareness among Indians regarding the spread of Covid-19.

Background: Coronavirus disease 2019 (COVID-19) was identified in January 2020. Currently, there have been more than 125 million cases, and more than 2.7 million deaths worldwide. Some individuals experience severe manifestations of infection, including viral pneumonitis, adult respiratory distress syndrome (ARDS) and death. Many patients required ventilatory support including high flow oxygen, continuous positive airway pressure and intubated with or without tracheotomy. There was considerable learning on how to manage COVID-19 during the pandemic and new drugs became available during the different waves. This secondary care COVID dataset contains granular ventilatory, demographic, morbidity, serial acuity, medications and outcome data in COVID-19 across all waves and will be continuously refreshed.

PIONEER geography: The West Midlands (WM) has a population of 5.9 million and includes a diverse ethnic and socio-economic mix. There is a higher than average percentage of minority ethnic groups. WM has a large number of elderly residents but is the youngest population in the UK. Each day, more than 100,000 people are treated in hospital, see their GP or are cared for by the NHS. The West Midlands was one of the hardest hit regions for COVID admissions across all waves.

Electronic Health Records (EHR): University Hospitals Birmingham NHS Foundation Trust (UHB) is one of the largest NHS Trusts in England, providing direct acute services and specialist care across four hospital sites, with 2.2 million patient episodes per year, 2750 beds and 100 ITU beds. ITU capacity increased to 250 beds during the COVID pandemic. UHB runs a fully electronic healthcare record (EHR) (PICS; Birmingham Systems), a shared primary and secondary care record (Your Care Connected) and a patient portal “My Health”. UHB has cared for more than 10,000 COVID admissions to date.

Scope: All COVID swab confirmed hospitalised patients to UHB from January 2020 to the current date. The dataset includes highly granular patient demographics and co-morbidities taken from ICD-10 and SNOMED-CT codes. Serial, structured data pertaining to care process (timings, staff grades, specialty review, wards), severity, ventilatory requirements, acuity, all physiology readings (pulse, blood pressure, respiratory rate, oxygen saturations), all blood results, microbiology, all prescribed and administered treatments (fluids, antibiotics, inotropes, vasopressors, organ support, dexamethasone, remdesivir, tocilizumab), all outcomes.

Available supplementary data: Ambulance, 111, 999 data, synthetic data.

Available supplementary support: Analytics, Model build, validation and refinement; A.I.; Data partner support for ETL (extract, transform and load) process, Clinical expertise, Patient and end-user access, Purchaser access, Regulatory requirements, Data-driven trials, “fast screen” services.

Context

• A new coronavirus designated 2019-nCoV was first identified in Wuhan, the capital of China's Hubei province
• People developed pneumonia without a clear cause and for which existing vaccines or treatments were not effective.
• The virus has shown evidence of human-to-human transmission
• Transmission rate (rate of infection) appeared to escalate in mid-January 2020
• As of 30 January 2020, approximately 8,243 cases have been confirmed

Content

• covid_19_clean_complete_2022.csv - Day to day country wise no. of cases (Doesn't have County/State/Province level data)

Acknowledgements

Data Source and Reference: - https://github.com/CSSEGISandData/COVID-19 - https://www.worldometers.info/ - https://www.kaggle.com/imdevskp/corona-virus-report - https://github.com/imdevskp/covid_19_jhu_data_web_scrap_and_cleaning

Cover Photo Photo from media.istockphoto.com - https://media.istockphoto.com/photos/coronavirus-new-strain-wide-dark-background-picture-id1308624310

Adjusted odds ratios with 95% confidence interval from multivariable logistic regression model with GEE for the outcome COVID-19 mortality.

This publication was archived on 12 October 2023. Please see the Viral Respiratory Diseases (Including Influenza and COVID-19) in Scotland publication for the latest data. This dataset provides information on number of new daily confirmed cases, negative cases, deaths, testing by NHS Labs (Pillar 1) and UK Government (Pillar 2), new hospital admissions, new ICU admissions, hospital and ICU bed occupancy from novel coronavirus (COVID-19) in Scotland, including cumulative totals and population rates at Scotland, NHS Board and Council Area levels (where possible). Seven day positive cases and population rates are also presented by Neighbourhood Area (Intermediate Zone 2011). Information on how PHS publish small are COVID figures is available on the PHS website. Information on demographic characteristics (age, sex, deprivation) of confirmed novel coronavirus (COVID-19) cases, as well as trend data regarding the wider impact of the virus on the healthcare system is provided in this publication. Data includes information on primary care out of hours consultations, respiratory calls made to NHS24, contact with COVID-19 Hubs and Assessment Centres, incidents received by Scottish Ambulance Services (SAS), as well as COVID-19 related hospital admissions and admissions to ICU (Intensive Care Unit). Further data on the wider impact of the COVID-19 response, focusing on hospital admissions, unscheduled care and volume of calls to NHS24, is available on the COVID-19 Wider Impact Dashboard. Novel coronavirus (COVID-19) is a new strain of coronavirus first identified in Wuhan, China. Clinical presentation may range from mild-to-moderate illness to pneumonia or severe acute respiratory infection. COVID-19 was declared a pandemic by the World Health Organisation on 12 March 2020. We now have spread of COVID-19 within communities in the UK. Public Health Scotland no longer reports the number of COVID-19 deaths within 28 days of a first positive test from 2nd June 2022. Please refer to NRS death certificate data as the single source for COVID-19 deaths data in Scotland. In the process of updating the hospital admissions reporting to include reinfections, we have had to review existing methodology. In order to provide the best possible linkage of COVID-19 cases to hospital admissions, each admission record is required to have a discharge date, to allow us to better match the most appropriate COVID positive episode details to an admission. This means that in cases where the discharge date is missing (either due to the patient still being treated, delays in discharge information being submitted or data quality issues), it has to be estimated. Estimating a discharge date for historic records means that the average stay for those with missing dates is reduced, and fewer stays overlap with records of positive tests. The result of these changes has meant that approximately 1,200 historic COVID admissions have been removed due to improvements in methodology to handle missing discharge dates, while approximately 820 have been added to the cumulative total with the inclusion of reinfections. COVID-19 hospital admissions are now identified as the following: A patient's first positive PCR or LFD test of the episode of infection (including reinfections at 90 days or more) for COVID-19 up to 14 days prior to admission to hospital, on the day of their admission or during their stay in hospital. If a patient's first positive PCR or LFD test of the episode of infection is after their date of discharge from hospital, they are not included in the analysis. Information on COVID-19, including stay at home advice for people who are self-isolating and their households, can be found on NHS Inform. Data visualisation of Scottish COVID-19 cases is available on the Public Health Scotland - Covid 19 Scotland dashboard. Further information on coronavirus in Scotland is available on the Scottish Government - Coronavirus in Scotland page, where further breakdown of past coronavirus data has also been published.