Close
MIDAS Curated Archive
of Global Public Health Data
FAQ

Table of Contents

Why did we create the MIDAS Curated Archive of Global Public Health Data from Official Websites and what does it contain?

The 2019 coronavirus disease (COVID-19) pandemic saw the emergence of numerous websites compiling regional or global COVID-19 data. At the beginning of the pandemic, we observed a lack of centralized worldwide archive of official COVID-19 data from public health agencies, ministries of health, and other governmental websites. Our goal was to fill this gap.  

 

We created the MIDAS Curated Archive of Global Public Health Data by automatically downloading, scraping, or screenshotting data of different formats from official sources for multiple countries and territories, eight regions, and at the global level. The archive contains case, death, hospitalization, demographics, and vaccination information at country and, when possible, at lower administrative levels, collected daily or weekly for each disease of interest. We have since expanded the archive to include other diseases, including COVID-19, Mpox, Flu, and RSV.

 

The data are verified against the source by a combination of manual and automated processes, deduplicated, and are made publicly available with curated metadata. The archived public health data are organized by disease, geographic location, and source in “collections.” Each collection is associated with archived data that can be viewed and downloaded, with metadata information available in the MIDAS Catalog.

 

Definition of a collection

The archived data are organized by collection. A collection can be defined as scraped, downloaded, and/or screenshotted data associated with a disease, a geographical region, and an official source. For more information, please consult the FAQ section What is a collection? below.

Data formats​

The MIDAS Curated Archive of Global Public Health Data includes data extracted from official websites. As various sites use different formats and structures for data storage, collections contain a number of different formats. Most data are available in a “computable” format (HTML, JSON, CSV, etc.), but some data are only available in a “non-computable” format; for example, PNG or JPEG format.

 

The contents of each collection are described in the in collection metadata available in the MIDAS Catalog.

Rights & license information​

All data from the MIDAS Curated Archive of Global Public Health Data are issued from specific sources and might be available only under specific licenses and/or copyrights. When available, license and rights information were collected from each source and are included in the associated metadata.

 

If you believe that any material contained on the MIDAS Catalog and/or on the MIDAS Curated Archive of Global Public Health Data infringes your copyright or other intellectual property rights, or is otherwise incomplete or inaccurate, please notify the MIDAS Coordination Center via email at questions@midasnetwork.us.

Frequently Asked Questions

Process

What process is used to curate data in the MIDAS Curated Archive of Global Public Health Data?

The MIDAS Curated Archive of Global Public Health Data process follows 5 steps:

    1. Identify a data source and associated disease data to include in the archive
    2. Extract the data of interest
    3. Review the extracted data
      • if there are no problems with the extracted data, continue to step 4
      • if the extracted data has some issues follow additional steps depending on the issue:
        • update the data source information if the data source has evolved; for example, the web page has moved to another location 
        • update the extraction process if the format of the data changed 
        • stop the extraction process if the data has been removed from the page or is not updated anymore. 
    4. Deduplication of the files
    5. Publication
      • Once the data is published, the MIDAS Curated Archive of Global Public Health Data is updated monthly. 

 

Each step is associated with a specific question in this FAQ.

 

What is a collection?

The MIDAS Curated Archive of Global Public Health Data is organized by collection. A collection can be defined as scraped and/or downloaded and/or screenshotted data associated with a specific disease, a specific geographical region, and a specific source.

 

A specific geographical region can be a country or region of the world, and, for some countries, the first-order administrative division (e.g., state or province).

 

The most common types of specific sources include:

    • A dataset, often associated with metadata that can be downloaded; for example: Provisional COVID-19 Deaths by Week, Sex, and Age by the US National Center for Health Statistics web page available on the data.cdc.gov website.

    • A data hub website or web page containing multiple datasets, often with related metadata; for example: Tennessee Department of Health downloadable Datasets web page.

    • A web page containing text and/or table with disease information; for example: Wyoming Updates from the Wyoming Department of Health web page.

    • A dashboard containing multiple types of information about a disease with data accessible via an API or via download. Dashboards are often implemented through services provided by ArcGIS or other similar tools; for example: Pennsylvania COVID-19 Dashboard from the Pennsylvania Department of Health.

    • A particular tab in a Tableau or Microsoft Power BI dashboard; for example: Demographic Data from Oregon Health Authority Tableau Dashboard.

    • A web page containing multiple frequently updated press releases or situation reports about a disease; for example: DHHR Updates from West Virginia Department of Health and Human Resources.

 

As data storage and description practices have evolved since we began archiving data in the early days of the COVID-19 pandemic, the types of data and the formats included in various collections may differ over time. In some cases, data within a collection may be in different formats, even for a single time point. 

 

Additionally, as the collections were initially defined at the time of creation, and as we needed to adapt to the changes of the reporting of information from each source, the definition of collections and evolution of information in a collection might be slightly different between two geographical units or sources. 


For example, a collection for one specific location may contain scraping of a first source in the format of an HTML page for the beginning of the pandemic, then later contain JSON files downloaded from a dashboard (second source) as the dashboard might be embedded in the same web page that contains the information in HTML format previously; for example, Coronavirus Disease 2019 (COVID-19) web page from the Illinois Department of Public Health. For some other location, these two sources may be separated into two collections; for example, the COVID-19 Data for Pennsylvania web page from the Pennsylvania Department of Health and the Pennsylvania COVID-19 Dashboard from the Pennsylvania Department of Health. We first extract the HTML information from the COVID-19 Data for Pennsylvania web page and later on, the Pennsylvania COVID-19 dashboard was embedded in the web page. We separated these two sources into two collections to simplify the curation process as the web page continued to be scrapped after addition of the dashboard and the dashboard extraction contains multiple JSON files and screenshots. 

 

How is each source identified?

The identification and selection of data sources follow three steps:

    1. Data sources are identified through Google Searches for specific keywords: “Ministry of Health”, “Department of Health”, “Government”, or “Public health institute” of specific location. At each “official source” website we either navigated or searched for a page, dashboard, section, press release, bulletin, etc. about the disease of interest. We verified sources as “official” by either verifying the URL extension (“.gov”, “.gob”, “.gouv”, etc.) or by consulting the information on the websites directly (“about” section for example).

    2. If one or multiple pages are identified as containing case counts, deaths, hospitalizations, demographics, diagnostic tests, and/or vaccination data related to the disease of interest, the source is added as a source in the MIDAS Curated Archive of Global Public Health Data.

    3. If the website contains an archive of historical data that we believe to be persistent, the source is not added to the MIDAS Curated Global Public HealthData Archive. For example, the Institute for Healthcare Analyses (IZA) of the Ministry of Health of the Slovak Republic uses a GitHub repository to store and distribute COVID-19 information. The Slovak Republic has an official website containing some visualizations and tables of the data, and a link to the GitHub repository. In this case, we are not downloading the data from the Github repository and we are not scraping the website either. As GitHub keeps track of all the changes already and stores all the data, including it in the MIDAS Curated Archive of Global Public Health Data will be redundant. However, the GitHub Repository information will be added to the MIDAS Catalog.

 

How is the data extracted?

We use three processes to extract the data:

 

    • Scrape: we scrape the HTML source of the page if the data on the page is available in tables, graphs, and/or text contained in the HTML source. We might also scrape the HTML source of the page containing the metadata information associated with the data. For some collections that were previously updated daily or weekly on the COVID-19 Github repository (our original collection of COVID data), we transform the HTML or JSON output file to a CSV file and translate any necessary information (column name, location information, etc.) to English by using Google Translate.
 
    • Download: we directly download linked files such as CSV, PDF, XLSX, etc. files or request data from the source API, if provided. 
 
    • Screenshots: we take a screenshot of the page if the content of the page is not available in any format that can be extracted or if having a screenshot of the page in the collection might help for the comprehension and usage of the other data in the collection.
 

We regularly use these processes to extract updated data from each site. Depending on the frequency of update of the source, we scrape/download/screenshot data between 6 times per day and 1 time per week. For example, a weekly updated dataset will be extracted at least 3 times per week. At the beginning of the pandemic, all of the processes were run 6 times per day (every 4 hours) on all the sources to be assured to capture all the different sources’ updates. However, as multiple sources changed their frequency of update, we adapted our frequency of extraction.

 

As the data and the format of the data have evolved through time, it is possible to have different processes running in the same collection at the same and/or at different times. For example, we can have data that was scraped from a web page in an HTML format for a certain amount of time, and later, or at the same time, in a downloaded CSV file.  

 

How is the public health data archive reviewed?

We use two processes to review extracted data:


    • Automatic verification:
          • Before extracting data, we automatically check for any web page problems like an invalid web page, a redirect, the link of the page has been removed, etc.
          • For some JSON files, the extraction process programmatically checks within the file for dates, errors, or empty content.
  •  
    •  Manual verification:
          • Archived files are periodically checked against live websites to verify that they have captured the content required, and to verify that the content in the live link has not been removed or relocated and is still updated.
 

What happens if the source link is unavailable or does not contain data anymore?

Even “official” web sites undergo changes that lead data to be  deleted, moved, or otherwise become unavailable. When we are unable to access one of the links that we are using to retrieve data, we will look to see if the data is available on a new page on the same site. Subsequent steps depend upon what we find: 

 

    1. If the data have been moved to another page but are still available from the same source website for the same geographical locations, we check to see if only the link has changed, or if the format has also changed: 
        1. If the link has changed but the content is still the same, we update the link used for extracting the data and keep the extraction running for this collection.
        2. If the page has changed data format, we take one of two possible steps:
            1. For small changes, such as updating the format of the data without changing the link of the page, we will update the process used for extracting the data and keep the extraction running for this collection 
            2. For more substantial changes, such as moving from a web page containing an HTML table to a complex dashboard, we will update the link used for extracting the data and move the extraction into a new collection

    2. If a new page with the data of interest cannot be found from the same source for the same location, we stop the extraction of the data for this collection and keep the last link used for this extraction as the source link in the associated metadata.

 

As the collections were defined at the same time as we were creating them and as we needed to adapt to the change of the reporting of disease-specific information from each source, the definition of collections and evolution of information in a collection might be slightly different between two geographical units or sources. 

 

How is the data deduplicated?

As the data can be extracted up to 6 times per day, most collections initially contain significant redundancy. To remove the duplicates, we calculate checksums on all saved files and publish only the files identified as unique.

 

However, this process does not always identify all “unique” files. For example, some HTML files contain the same COVID-19 data, but as the text around the data might have changed, the files will not be noted as duplicates and both files will be published in the MIDAS Curated Archive of Public Health Data. Or, as another example, there are some screenshots where the pictures look the same, but the dimensions are slightly different.

 

In addition to true duplicate files identified by the checksums, we also limit the number of files containing individual case report (linelist) data since these files can become very large. These limits are applied when the files:

 

      1. do not also contain summary data,
      2. contain at least one month of historical individual case data within each file, and
      3. the set of files was archived for at least three months.

 

Files that meet these criteria are limited to the first unique file archived plus the last unique file each month.

 

How often is the MIDAS Curated Archive of Global Public Health Data updated?

The first publication of the MIDAS Curated Archive of Global Public Health Data contained COVID-19 data for the United States of America. Since then, other diseases and regions have been added. These collections will be updated monthly with data until the previous month. For example, if an update is planned in June, it will contain data until May.

 

New collections will be added to the Archive as they become available.

 

Public Health Archived Data

How can I access the data?

The archived data are accessible via the MIDAS Catalog. Each collection corresponds to one entry in the data catalog. Each of these entries contains a link to a file browser interface containing summary information about the collection (disease and pathogen information, geographical information, source, associated license and/or rights information, date, etc.) and links to individual files. 

 

All individual files in a collection are presented in a table that can be searched, filtered and/or sorted. Files can also be downloaded individually from this page. A zipped set of all files of a specific file type or all files from the collection can be made available upon request; information on how to submit the request is provided on each collection page in the file browser.

 

How often is the data extracted?

Data is extracted from the sites regularly, depending on the frequency of updates on the site. Update intervals range from 6 times per day to once weekly.

 

What file formats are available?

The MIDAS Curated Archive of Global Public Health Data contains data in multiple formats. As source data are provided in multiple formats and structures , a single collection may contain multiple formats.

Most of the files are:

    • HTML and/or PDF containing disease-specific data in text, tables, and/or graphs 
    • PNG screenshots 
    • JSON files downloaded from dashboards or directly from some websites
    • CSV or XLSX 
    • TWBX (Tableau workbook) files containing data from a Tableau dashboard (for more information, please consult the Tableau Public website)

 

Other less common formats include XML, TXT, and RDS (an R data file format readable using R – for more information, please consult the R project website), etc. Each collection will have the available file format information associated with the data listed in the metadata, available in the MIDAS Catalog.

 

A collection can also contain multiple file formats in the same time frame; for example, if a page contains data in CSV format and as a table in the HTML of the page, then the collection will contain both formats.

 

How can I know when the data was extracted?

The file browser interface for each collection contains a table with information associated with each file: the filename, the format of the file, the size of the file, and the date the file was created, which corresponds to the date the data was extracted.

 

For some files, the information is also available on the name of the file in the format: “filename_YYYY-MM-DD_HHMMSS”. Not all the files contain this information, as it is not always possible to rename the file or append the date in the filename.

 

Why does the collection contain a gap in the data?

A collection may contain a gap in the data as the downloading and/or scraping and/or screenshot of the web page was stopped for a certain amount of time before being restarted. It might happen, for example, in the case where the data were moved to a new page and we did not find the new page immediately; or, if another page had more detailed data than the original, we may have stopped the first one to avoid redundancy. However, if the detailed page disappears, then the original source is used again.

 

It is also possible that the source data was not updated during a certain period of time and all the redundant archived files were removed during the deduplication step.

 

Can I view the data before downloading it?

Yes, it is possible to view some of the data before downloading them. All browsers can be used to view HTML, PDF, JSON, etc. files. To view the data, click on the filename of the file and it will open in the browser if possible; otherwise, the file will be downloaded. 

 

Files in some collections use encodings that may not automatically render properly in the browser, so may need to be downloaded to view.

Why does current data appear in some past archived files, and why doesn't any data appear in some of the files, when they are viewed in the browser?

Viewing a file in the web browser is not always the best way to “see” the data. For example, the data can be hidden in the code of an HTML, or the HTML might contain a redirect link, or a link to embedded up-to-date content when viewed in the browser. We strongly advise the users to download the files to verify the data.

 

How do I locate the data in the file?

For some files, the data might be mixed with other information and might be difficult to find. For some frequent cases, we can provide some additional information:

  • For JSON files associated with an ArcGIS dashboard: the data is often located in the “features” section of the files
  • For JSON files associated with a PowerBI dashboard: the information is usually located in section following the path “results / 0 / result / data / dst”
  • For CSV files associated with a Tableau Dashboard: the name of the file often contains any filter options selected to extract the data

 

For some collections, a screenshot is available to provide more context about the data and might help with locating the data. Additional information might also be available in the metadata Description field for special cases. Please feel free to contact us for any additional information or help.

Why does a collection contain files without disease-specific data and/or duplicate files?

As the verification and deduplication steps are imperfect, some collections might contain files with an error and/or without data for a certain amount of time.

 

How can I download the data?

Individual files can be downloaded directly from the file browser interface.

 

A zipped set of all files from a collection, or all files of a specific file type from a collection, can be made available upon request. More information on how to request such a file set is available on each collection page in the file browser interface.

 

Are the archived data available in any format other than what is available in the Archive?

Some collections have been used to generate COVID-19 Project Tycho datasets. In August 2022, Project Tycho released COVID-19 datasets for 237 countries. These datasets conform to the updated Project Tycho 2.0 pre-compiled dataset format v1.1. For more information, please consult the Project Tycho website.

 

Are there any restrictions on the data?

All data from the MIDAS Curated Archive of Global Public Health Data are retrieved from specific sources and are subject to restrictions determined by those providers. The license and rights information were collected from each source, if available, and is provided for each collection in the associated metadata.

 

If you believe that any material contained in the MIDAS Catalog and/or in the MIDAS Curated Archive of Global Public Health Data infringes your copyright or other intellectual property rights, or is otherwise incomplete or inaccurate, please notify the MIDAS Coordination Center via email at questions@midasnetwork.us.

 

Metadata

What types of date information are available for each collection?

Several pieces of temporal information are recorded for each collection:

 

    • Collection Dates: The start and end dates corresponding to the dates we started (and stopped) extracting data from a specific source. Some collections might have no end date or “ongoing” as end date to indicate that the data are still frequently archived for this collection

 

    • Last Publication Update: This corresponds to the last date this collection was updated in the MIDAS Curated Archive of Global Public Health Data. That is, the last time we published, or added archive data to, the collection. 

 

    • Available Dates: As previously said, the data are first extracted multiple times a day or a week and then deduplicated to remove some redundancy. As the “Collection Dates” indicate the first and last extraction before the deduplication step, the extraction dates of the first and last files of the collection after deduplication (also called “Available Dates” in the FAQ) correspond to the dates in the Modified Date column in the file browser interface. For more information, please see the example below.    

 

    • Start Date / End Date: We currently don’t provide this information for the MIDAS Curated Archive of Global Public Health Data. These dates are both empty in the MIDAS Catalog entry of any MIDAS Curated Archive of Global Public Health Data collection. They correspond to the start and end date of the data inside the archived files of the collection. As the data inside these files are frequently updated, the information is currently not collected.

 

To illustrate these definitions, we can imagine an example of a collection that can contain multiple files about COVID-19 data. The collection started on 2020-04-01 (April 1, 2020) and stopped on 2022-02-01 (February 1, 2022), because the source page was not updated since 2022-01-01. In this case:

    • Collection Dates = 2020-04-01 to 2022-02-01
    • Last Publication Date = Date of Publication on the MIDAS website, for example 2022-06-01
    • Available Dates = files in the web interface will have a range from 2020-04-01 to 2022-01-01 (the last month was removed as it was “duplicate”) in the Modified Date column
    • Start Date / End Date = NA (not collected)

What geographical information is collected?

For each entry, we collect the “geographical resolution” and the “geographical scope”. 

    • Geographical Resolution: Name of the location in English at country or first-order administrative division level. The names are standardized by using Geonames information. 
    • Geographical Scope: Level of geographical details of the location available in the data, using either: first-order administrative division level; second-order administrative division level, etc. notation and/or country, state, region, etc. 

 

To illustrate these definitions, if we download the state, county and ZIP level data from the  Pennsylvania COVID-19 Dashboard from the Pennsylvania Department of Health, the collection geographical information will be: 

    • Geographical Resolution: Pennsylvania
    • Geographical Scope: State, County, Postal code

 

Whereas, if we download the Provisional COVID-19 Deaths by Week, Sex, and Age by the US National Center for Health Statistics web page available on the data.cdc.gov website, the collection geographical information will be:

    • Geographical Resolution: United States of America
    • Geographical Scope: Country

 

For some entries, the associated metadata indicates “special region” or “health region” as geographical scope:

    • Health Region: geographical scope indicating any geographical division unit dedicated to health; for example: Health district, Health Region, Health Care Coalition, etc.
    • Special Region: geographical scope indicating any geographical division unit not dedicated only to health, and which cannot be classified as any other geographical subdivision definition in Geonames: for example, a group of communes in Brittany, France, or Navajo Nation service areas in the United States.

 

Is it possible to have access to all links used for one collection?

Currently, only the last link used for extracting the data is available. We might publish the historical links later; if so, we will update the documentation accordingly.

 

Suggested Citation

If you are using the MIDAS Curated Archive of Global Public Health Data, please consider citing the interface by using:

 

For specific collection:

Source, Title, Retrieved from: MIDAS Curated Archive of Global Public Health Data from Official Websites, URL. Accessed date

 

Example: Kansas Department of Health and Environment, Kansas COVID-19 Vaccination Overview, Retrieved from: MIDAS Curated Archive of Global Public Health Data from Official Websites, https://catalog.midasnetwork.us/scrapecat/607. Accessed 7 Dec. 2022.

 

 

To cite the MIDAS Curated Archive of Global Public Health Data from Official Websites: 

MIDAS Curated Archive of Global Public Health Data from Official Websites, https://midasnetwork.us/midas-archive-faq. Accessed date



Contact Information

If you have any questions about the MIDAS Curated Archive of Global Public Health Data or MIDAS Catalog, please feel free to contact us at: questions@midasnetwork.us.

 

If you have any specific question about the archived data contained in a collection, depending on if the questions are about:

    • the archiving process: please feel free to contact us at: questions@midasnetwork.us.
    • the data itself: please contact the creator of the data. The metadata associated with the collection should help you identify the creator.