Skip to content

Define the data schema #3

Description

@loleg

Since starting this project we have debated a lot about what kind of information we need and don't need. It is clear that our starting point, the available Open Government Data, has both too much and too little information. We want to expand and improve this schema, and write a converter to stay compatible in case there are future updates.

We are working on a data dictionary that is complementary to the schema, and explains the fields in clearly accessible terms. Currently we are especially interested in these indicators, which need to be clearly explained and defined:

    N of hospitals in CH (with name and geolocation)
    N of beds by hospital
    N of ICU beds by hospital
    N of respirators by hospital
    average % bed availability pre-COVID-19 (“Bettenauslastung”) by hospital
    N ICU nurses by hospital (“IPS Pflege”)

A repository was also started yesterday with an example dataset which aims to simplify and standardize the requests we are making to regional health authorities: https://github.com/openZH/covid19_hospitalinfra

Our current data package has an automatically generated schema, which can be edited in the datapackage.json file, or loaded in the Frictionless Data Creator. The results of the data dictionary and schema proposal work can be merged in this way.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions