The purpose is to list research topics and presentation material for the EU hackathon starting April 24th, 2020.
IDEA 0: Frustration related to the current indicators regarding COVID pandemia.
Exemple dashboard.covid19.data.gouv.fr :
- data per country doesn’t take care about the population - consequently no ratio (In France Occitanie region had about 350 death and PACA region about 550 however it seems that mortality is much higher in Occitanie region…)
- the population available is usually the French citizens. Should be relevant to have the data from other citizens (EU, non EU) residing in France in order to mitigate the ratios
- work in progress : KPI including / crossing other data : number of medical beds per citizen, density, poverty, humidity (weather), etc.
IDEA 1: similarity test density / population reached COVID
Example of a French demonstration by region before working either top-down (by French department) or macro (by European region then by country)
- Restate hospitalisations in cumulative figures by dpt / region / country
- Take the population of the region, by population we speak of residents.
- Derive a ratio of the number of people hospitalized per 1,000 population that we’ll call the serious infection rate and look at what it says.
- Take population density by region https://ec.europa.eu/eurostat/databrowser/view/tgs00024/default/map?lang=fr
- Compare density and rate of severe infection. If there is an obvious effect, then look for a homogenous “density/serious infection rate” ratio or an asymptotic or other effect, e clear is there a remedy that makes an area at risk?
- On the other hand, if there is a flagrant disparity between countries in areas of comparable density (we can measure the difference if we have the data), then look for other factors. List of possible factors: density, temperature, hygrometry, treatment policy, number of hospital beds per 1,000 inhabitants, etc.
IDEA 2: relative mortality
- Mortality in relation to the population
- Mortality in relation to the hospitalized population (defined in 1)
- Are there “alert” regions or is it homogeneous? If not homogeneous, look for other factors. List of possible factors: density, temperature, hygrometry, treatment policy, number of hospital beds per 1,000 inhabitants, etc.
- Tests of the different factors, crossovers
- Create a conceptual contextual indicator balancing existing data representations (e.g. comparing existing numbers / charts with different population ratios).
- Identify data sources to create this indicator
- Try to connect to them (Json, csv or Api’s)
- Create an ideal (visual mockup) visualisation in Gimp with these elements
- Create a functioning demo (embedded widget) of these data (POC)
Presentation of the project
Open Indicators for EU citizen to build their own data models (KPI’s) and visualisations during and after the crisis
It’s built with :
JSON, CSV and API connectors written in Svelte, Sapper & Js, Indicators & Visualisation with Svelte, Js, D3 and Vega, Backend in TailwindCSS, TypeScript, Babel, Rollup, ESLint, Prettier, Yarn
Here’s the whole story:
We are a team of former public agents & innovators passionated by open-data for citizen. We met around a simple idea: how can non-technical people very simply compose their own indicators at a local (company, city) or national (state, EU level), create their own story with their data model and debate them in a decentralized way. On our way we understood that actually, governements & companies are also very interested by new ways to evaluate in real-time the impact of their policies and actions. In this hackathon, we want to focus on indicators related to Health during the COVID crisis but also on post-crisis indicators linked with the re-start of many sectors such as Economy, Innovation and Research.
The core developer of our team created the technology behind the open-data platform of the French Government (https://Data.Gouv.Fr). Our inspiration comes from the vision that citizen and governments cannot understand public policies if they don’t have independant digital tools and personnalized indicators (KPI’s) to assess their impact.
What it does:
Indy.Cat is a platform that allows users to perform three things:
- Connect & filter, without technical knowledge, data sources in documents (CSV) and API’s
- Build & discuss very simply their own indicators and visualisations (tables & graphs)
- Export & integrate them instantly to spreadsheet, presentations or through API’s
How We built it:
We met in different Hackathons organised by the French National Assembly, the French Senate and the French Ministry of Economy & Finances and in different open-data and innovation events where we advanced our POC then our prototypes. The EU hackathon is a great opportunity to assemble a unique demonstration of our platform around the issue related to Health governance in a time of crisis, especially from a EU citizen our EU parliamentary perspective, but also, how, post-crisis, different institutions and governments will “reboot” their whole countries and infrastructures, from the perspectives of live, historicized and composable data-based indicators accessible and debatable by all.
Challenges We ran into:
Many relevant datasets that we would like to use for our scenarios and demonstrators for the hackathon might be inexistant or very difficult to access either because they are not publicly released by institutions or because of technological hurdles (formats). In addition, we are focused on providing the best level of user experience, especially for a diversity of audiences, so our UI and UX challenges are enormous if we want to include the broadest amount of citizen, parliamentaries or innovators from all ages and digital know-hows.
Accomplishments we are proud of:
We were mentionned by the Head of the French ministry of the Budget (Amélie Verdier) as one of the most promising project in a recent Hackathon organised at the French Senate. Following this mention, we were encouraged to apply for grants of BPI France (french bank of innovation) and we managed to wrap-up our application dossier in few weeks, thanks to very well coordinated teamwork, passion and energy. Being able to scale up our first steps up to the EU level thanks to this hackathon is something that we are proud of, since our project aims at providing citizen with the best tool to understand and reflect on the public policies of their institutions, which is at the core of the mission of the EU.
What We learned :
Technology is very hard. We spend most of our time to simplify and propose the minimal set of quality functions and tools for our users, not to multiply them. We believe in platforms that do one thing very good and only one thing. Our mission is to provide everyone with a simple way to access data and compose indicators, we learn every day that this is something non-trivial and that we should listen to our users as much as we can to reflect their perspective into our daily work while proposing renewed rich and pleasurable opportunities to them.
What’s next for indy.cat:
Our goal is to launch a beta of our platform at the end of the year, while developing our initial open community gathered around our pre-alpha version available at https://indy.cat, https://forum.indy.cat and https://git.en-root.org/indy.cat