key: cord-0771371-0suc6pt6 authors: Riffe, T.; Acosta, E.; COVerAGE-DB team, T. title: COVeAGE-DB: A database of age-structured COVID-19 cases and deaths. date: 2020-09-23 journal: nan DOI: 10.1101/2020.09.18.20197228 sha: a97ada72ed0be64d435241ae7ea8f97fbf2b00a1 doc_id: 771371 cord_uid: 0suc6pt6 COVerAGE-DB is an open access database including cumulative counts of confirmed COVID-19 cases, deaths, and tests by age and sex. Original data and sources are provided alongside data and measures in age-harmonized formats. The database is still in development, and at this writing, it includes 87 countries, and 195 subnational areas. Cumulative counts of COVID-19 ases, deaths, and tests are recorded daily (when possible) since January 2020. Many time series thus fully capture the first pandemic wave and the beginning of later waves. An international team, composed of more than 60 researchers, contributed to the collection of data and metadata in COVerAGE-DB from governmental institutions, as well as to the design and implementation of the data processing and validation pipeline. We encourage researchers interested in supporting this project to send a message to the email: coverage-db@demogr.mpg.de Information about pandemic dynamics is critical to understand the potential impacts on populations, design mitigation strategies, and evaluate the efficacy of their implementation. Centralization, standardization, and harmonization of data is critical to enable comparisons of the demographic impact of COVID-19 vis-à-vis differences in the age-compositions of confirmed infections and deaths. The international data landscape must keep pace with the global march of the pandemic, and researchers must work to triangulate the available data to create comparable measures to monitor and predict its demographic impacts. The COVID Age Database (COVerAGE-DB) aims to provide global coverage of key demographic aspects of the COVID-19 pandemic as it unfolds in an up-to-date, transparent, and open-access format. COVerAGE-DB offers data with standardized count measures and harmonized age groups to allow comparisons between populations at national and subnational scales. The database is currently under expansion through both the increase in coverage of national and subnational populations and the inclusion of more recent periods as the pandemic continues to unfold. At this writing, the database contai ns daily counts of COVID-19 cases, deaths, and tests performed by age and sex for 87 national and 195 subnational populations around the world, depending on the available data for each source. The date range available for each country or subpopulation varies. In several country series, the database includes the earliest confirmed cases in January, 2020. For most populations the database includes daily time series, beginning from an initial starting date when the data were first released or collected by our team. Fig. 1 displays a map of countries included in the database, indicating at least one subnational population from 12 co untries. A detailed overview of data availability is given in a searchable table [external link]( https://bit.ly/3kVDrLD ) is the author/funder, who has granted medRxiv a license to display the preprint in (which was not certified by peer review) preprint Data Collected: Collection: Official counts of COVID-19 cases, deaths, and tests are extracted from reports published by official governmental institutions, such as health ministries and statistical offices. Depending on the source, data are collected in a variety of formats, including machine-readable files, pdf tables, html tables, interactive dashboards, press releases, official announcements via Twitter, and in a few instances, from digitized graphics. A full list of data sources is available in a dashboard view ( https://bit.ly/2Qg1MxL ). Generally, COVID-19 cases, deaths and tests are reported as counts in 10-year age groups, but some sources report data in other metrics (fractions, percents, ratios) or as summary indicators such as case fatality ratios by age. Reported age intervals vary by source, ranging from single ages to 30-year or greater age bands, and sometimes reported age intervals change over time within sources. Usually data are reported as cross-sectional snapshots of cumulative counts, but some sources give full time series of new cases or deaths, in which case we cumulate counts over time. We also collect standard metadata on each of the sources to capture various characteristics of the collected data, such as the primary collection channels, definitions used, and notes on major disruptions or events. An overview of key fields from this metadata is shared as a spreadsheet ( https://bit.ly/2FAmKFn ). is the author/funder, who has granted medRxiv a license to display the preprint in (which was not certified by peer review) preprint The copyright holder for this this version posted September 23, 2020. . All source data is entered into standard spreadsheet templates hosted in a central folder on Google Drive. Data entry into the templates is either manual or automatic depending on the source. R programs collect data from the source templates and compile the merged input database. The merged input file is then subject to a series of automatic validity checks. Initial checks are carried out by the individual responsible for data collection and entry using an interactive application ( https://mpidr.shinyapps.io/cleaning_tracker/ ). Data is then harmonized to standard metrics (counts), measures (cases, deaths, tests), and age bands (5and 10-year age intervals). Harmonization procedures include various kinds of rescaling to ensure coherence in marginal sums. Age group harmonization is done using the penalized composite link model, 1 which was designed for splitting histograms of count data. The complete details on all steps of production are available in the COVerAGE-DB Method Protocol, which is publicly available on the web ( https://osf.io/jcnw3/ ). A table listing which adjustments are applied to each population is available on the project website ( https://bit.ly/2E61BSV ). Both the merged input database and the harmonized output files are uploaded daily as zipped csv files to an Open Science Framework repository (OSF) ( https://osf.io/mpwjq/ ). A GitHub repository ( https://bit.ly/2YbtPCJ ), which is linked to OSF, contains all R scripts used in the complete production pipeline, including compilation, diagnostics, and harmonization. Since collection efforts began for COVerAGE-DB in late March 2020, we are aware o f 6 studies using the data, many of which provide R code online and are fully reproducible. These studies aim t o: (i) explore country differences in the age distribution of COVID-19 deaths, 2 (ii) assess the contributi on of infection case age-structure and age-specific fatality to between-and within-country differences in case fatality rates (CFR) associated with the COVID-19, 3 (iii) produce a standard age-specific case fatality rate pattern for an indirect demographic method to estimate COVID-19 total infections, 4 (iv) analyze the association between intergenerational relationships and COVID-19 fatality rates, 5 (v) estimate years of life lost due to Covid-19, 6 and (vi) calculate pooled sex ratios of age-specific CFRs of COVID-19 in Europe. 7 The database is also used to monitor COVID-19 impacts in particular age ranges, for instance, UNICEF uses the database for monitoring the burden of the pandemic on the infant, child, and juvenile mortality around the world. As an example of the analyses that COVerAGE-DB enables, Fig. 2 displays changes in the relation between age-specific deaths and cases in Colombia, . CC-BY 4.0 International license It is made available under a perpetuity. is the author/funder, who has granted medRxiv a license to display the preprint in (which was not certified by peer review) preprint The copyright holder for this this version posted September 23, 2020. . inspired by Fig. 1 of Dudel et al. 3 We divide both cases and deaths in each age band by the respective population sizes. Diagonal lines indicate implied age-specific case fatality rates. The graphic illustrates a sharp increase in CFR over age for each sex, and it also displays considerable sex differences. For instance, men aged 60-69 in Colombia have almost the same case fatality rates (approximately 12% risk of death after COVID-19 infection is diagnosed) as women aged 70-79. We repeat this exercise to compare Colombia with Mexico (see Fig. 3) , where standardizing by population size is more justified. Case fatality rates and death rates are much higher in Mexico than in Colombia in each age band -around 2-fold -, except for ages 80+, which show a substantial reduction in the case fatality rate difference, and much higher death rates for Colombia. While we cannot separate the reasons for this with precision, it is clear that Colombia has conducted about twice as many tests per positive case than has Mexico, and positivity trends have been on the rise in both countries. 8 However, we do not know the age pattern of positivity in these two countries. On the other hand, both countries have excellent open data practices, allowing for construction of detailed series taking into account retrospective corrections. This highlights challenges in making such comparisons, but also the need to produce data with sufficient detail to adjust for biases. It is our view that researchers should 4 . CC-BY 4.0 International license It is made available under a perpetuity. is the author/funder, who has granted medRxiv a license to display the preprint in (which was not certified by peer review) preprint The copyright holder for this this version posted September 23, 2020. . triangulate creatively from all available data rather than avoiding difficult comparisons. Relation between deaths and cases per 100,000 population by age group in Mexico and Colombia, until 22 August 2020. Diagonal lines indicate the case fatality rate. Since the beginning of the pandemic, it has been evident that population characteristics are key to understanding the prevalence, spread and fatality of COVID-19 across countries. However, data on cases, deaths, and tests disaggregated by age and sex are not easily comparable across countries, and sometimes not even accessible. The main strength of COVerAGE-DB is to provide a centralized, open-access, and fully reproducible repository of age-and sex-specific case, death, and test counts from COVID-19, collected from official sources, and harmonized to standard output formats. The data harmonization process is transparent, following a strict protocol. 9 The initial input data is provided alongside the harmonized counts, as well as the code used to harmonize the different input measures, metrics, and age groups into comparable granular output metrics. All scripts are written in the open-source R programming language. 10 The data sources and limitations are documented for each country in a standard metadata framework. is the author/funder, who has granted medRxiv a license to display the preprint in (which was not certified by peer review) preprint The copyright holder for this this version posted September 23, 2020. . https://doi.org/10.1101/2020.09.18.20197228 doi: medRxiv preprint A limitation of the COVerAGE-DB is the heterogeneous and difficult-to-evaluate quality of the underlying data. No single data source can currently claim accurate estimates of COVID-19 incidence or fatalities. Age-specific case counts are highly dependent upon the testing capacity, 11 testing strategy, 12 and differences in the definition of cases across sources and over time. Cases are underestimated everywhere, with underestimation expected to vary by age, given the relationship between age and case severity. 13 The accuracy of diagnostic RT-PCR tests used to confirm infections is also known to vary. 14 Furthermore, at any given date, cumulative counts are underestimated because of the lag between infection and a positive test result. 15 Death counts from COVID-19 are also likely underestimated for similar reasons, but also due to various kinds of delays in death registration. Media reports have circulated about intentional data manipulation in some of the official data covered in the database. 16 Excess all-cause mortality has been observed across many regions. [17] [18] [19] [20] Although some of these deaths are likely from postponing or foregoing treatment from non-COVID-19 related causes, the magnitude of this excess is suggestive that numerous COVID-19 related deaths are classified under different causes. Populations also differ in whether deaths to suspected COVID-19 cases are included in official statistics and in post-mortem practices when an infection is suspected. 21 Some populations only report deaths occurring in hospitals, neglecting a potentially sizable proportion of deaths occurring in institutional settings and at home. 22 While most populations currently report all deaths to confirmed COVID-19 infections as COVID-19 deaths for this database, the underlying cause of death eventually reported on death certificates may differ in patients with severe comorbidities. To mitigate biases and misinterpretations due to different practices and definitions, such information is constantly updated and documented in the metadata of the database, which is freely accessible to users. All of these issues compromise the comparability of the data contained within the COVerAGE-DB, both across populations at any given time and within populations over time. For these reasons, infection fatality ratios, which include in the numerator detected and undetected COVID-19 infections, should not be estimated from COVerAGE-DB data alone. Proper estimation of incidence and fatality will likely require triangulating data across numerous sources as these become available. To this end, the COVerAGE-DB was designed to be easily merged with other databases such as the Our World In Data database on COVID-19 testing, 8 the COVID-19 dashboard of Johns Hopkins, 23 the World Population Prospects database, 24 and th e Short Term Mortality Fluctuations database. 20 Moreover, given that we have near-complete time series capturing the whole pandemic curve in some places, careful modeling of the lag structures might allow some of these data-driven biases to be estimated. . CC-BY 4.0 International license It is made available under a perpetuity. is the author/funder, who has granted medRxiv a license to display the preprint in (which was not certified by peer review) preprint The copyright holder for this this version posted September 23, 2020. . https://doi.org/10.1101/2020.09.18.20197228 doi: medRxiv preprint Both merged input and harmonized output files can be downloaded directly from the OSF site ( https://osf.io/mpwjq , DOI: 10.17605/OSF.IO/MPWJQ), which contains a folder called Data with three files of primary data. Fi g 4 shows where to find the files in the OSF repository. Each of the main data files has a stable link (see Tab. 1), which always points to the most recent version. Each file is a zipped csv file by the same name. is the author/funder, who has granted medRxiv a license to display the preprint in (which was not certified by peer review) preprint The copyright holder for this this version posted September 23, 2020. . https://doi.org/10.1101/2020.09.18.20197228 doi: medRxiv preprint For stable links to download particular versions, click on the version number in the Version column seen in Fig. 4 . Users can note versions either by referring to timestamps provided in the headers of data files or by referring to OSF file version numbers, which increment with each daily update. A data dictionary is given in both the OSF wiki ( https://osf.io/mpwjq/wiki/home/ ) and the Method Protocol. Files are shared in csv format to be as universally accessible as possible. A guide to getting started using the data in R is also provided ( https://bit.ly/3g8nIVU ), and tips for other statistical packages may also be added. Users are encouraged to reach out for further information or advice on using the database, or to express interest in the project: coverage-db@demogr.mpg.de . . CC-BY 4.0 International license It is made available under a perpetuity. is the author/funder, who has granted medRxiv a license to display the preprint in (which was not certified by peer review) preprint The copyright holder for this this version posted September 23, 2020. . https://doi.org/10.1101/2020.09.18.20197228 doi: medRxiv preprint Efficient Estimation of Smooth Distributions From Coarsely Grouped Data Population age structure only partially explains the large number of COVID-19 deaths at the oldest ages. Demographic Research Monitoring trends and differences in COVID-19 case fatality rates using decomposition methods: Contributions of age structure and age-specific fatality. medRxiv A demographic scaling model for estimating the total number of COVID-19 infections. medRxiv No clear association emerges between intergenerational relationships and COVID-19 fatality rates from macro-level analyses Global years of life lost to COVID-19 COVID-19 in unequally ageing European regions. World Development [Internet]. forthcoming Coronavirus Pandemic (COVID-19) Method Protocol for the COVerAGE-DB R: A Language and Environment for Statistical Computing Austria: R Foundation for Statistical Computing Countries test tactics in 'war' against COVID-19 Epidemiology and transmission of COVID-19 in 391 cases and 1286 of their close contacts in Shenzhen, China: a retrospective cohort study. The Lancet Infectious Diseases Estimates of the severity of coronavirus disease 2019: a model-based analysis. The Lancet Infectious Diseases Laboratory Diagnosis of COVID-19: Current Issues and Challenges Incubation period of 2019 novel coronavirus (2019-nCoV) infections among travellers from Wuhan, China COVID-19: a need for real-time monitoring of weekly excess deaths. The Lancet 000 Missing Deaths: Tracking the True Toll of the Coronavirus Outbreak. The New York Times The Economist. Tracking covid-19 excess deaths across countries. The Economist European monitoring of excess mortality for public health action (EuroMOMO)Kåre Mølbak Short-term Mortality Fluctuations (STMF) data series The Human Mortality Database Demographics of COVID-19 Deaths Institut national d'études démographiques 2020 Comment la France compte-t-elle ses morts ? An interactive web-based dashboard to track COVID-19 in real time. The Lancet Infectious Diseases World Population Prospects -Population Division -United Nations We gratefully acknowledge the hard work of health ministries and statistical offices around the world in preparing and disseminating the data included in COVerAGE-DB. The COVerAGE-DB project team is composed of more than 60 researchers that share in the authorship of this manuscript according to the CRediT authorship system (see contributions by author under the following link: https://docs.google.com/spreadsheets/d/1SHygPJArbfInXlmFku6vR7LzLyG z00p1ZkBaPdanAIw/edit?usp=sharing ).