AppCovid
Publication date: 24-10-2023
URL to data source catalogue/s: https://datos.comunidad.madrid/catalogo/dataset, https://www.google.com/covid19/mobility/, https://opendata.emtmadrid.es/Datos-estaticos/, https://www.metromadrid.es/es/transparencia/proyectos-y-datos#panel1

Designed with data from the Community of Madrid, this initiative has made it possible to monitor the recovery process after COVID-19 in sectors such as transport, tourism and public safety.
The tool has been developed with the aim of understanding not only the impact, but also the degree of recovery that some services and activities have experienced after the pandemic in Madrid.
Thus, through open data portals, the application offers interactive visualizations with the following variables:
- Municipal police
- Citizen safety information
- Alcohol consumption on public roads
- Inspections and actions in premises
- Tourism
- Number of nights and average price at Airbnb
- Mobility and transportation
- Occupancy rate of parking lots in the city of Madrid
- Metro ridership
- BiciMAD movements
- Google mobility transportation stations
- COVID-19
- Cumulative incidence rate
In each panel, conclusions can be known based on data on the state of recovery of each parameter, a situation that varies depending on the sector. While on-street drinking and AirbnB tourism see higher activity, metro ridership is still lower than pre-pandemic data.
Open data sources are:
- Community of Madrid open data catalog for the cumulative rate of contagion in the community of Madrid: https://datos.comunidad.madrid/catalogo/dataset
- EMT Madrid open dataset for BICIMAD data: https://opendata.emtmadrid.es/Datos-estaticos/
- Madrid metro website data for Madrid metro ridership data: https://www.metromadrid.es/es/transparencia/proyectos-y-datos#panel1
- Google mobility local mobility reports for citizen mobility data: https://www.google.com/covid19/mobility/