- Transform data (to visualize it)
- Visualize it —obviously
- Export data in multiple reusable formats
- Calculate expected dates based on the current progress of the rollout (implemented in the app)
- Correct Github Action to generate data daily (not working properly now)
- Sanitize names of regions
- Download
.odsfiles to repo in case they take them offline —see/spreadsheets - Add expected dates to data output instead of calculating in the browser
- Sanitize dates. Canarias and Baleares have wrong dates on a couple of places, and some regions have extra spaces.
- Separate latest data and historical data into two files —or maybe two objects in the same
JSON - Translate docs to Catalan and Spanish
- Combine it with population data by age groups
(We'll continue to add a detailed 'to do')
It has its own separate README.md
To generate the data simply install and run the node app.
npm install
node index.js
It outputs two fresh JSON and CSV files to app/public/. (It's good to know you have options.)
The data comes from the .ods files that the Health Alert and Emergency Coordination Centre (CCAES in Spanish) has published daily since January 4.
We are also backing up the spreadsheets in case they take them offline.
Important! A few dates in the Fecha de la última vacuna registrada column (renamed as hasta in our data) are wrong —for Baleares and Canarias. Until they fix it —or we write something to catch that— use fecha which is the date of the report.
We renamed the columns as:
| Dosis entregadas Pfizer (1) | Dosis entregadas Moderna (1) | Total Dosis entregadas (1) | Dosis administradas (2) | % sobre entregadas | Nº Personas vacunadas (pauta completada) | Fecha de la última vacuna registrada (2) | |
|---|---|---|---|---|---|---|---|
| ccaa | pfizer | moderna | entregadas | administradas | admin_entregadas | vacuna_completa | hasta |
| String | Integer | Integer | Integer | Integer | Integer | Integer | Date |
The columns have already changed three times. In the event they add new colums —for newly authorized vaccines, for example— we will add a new schema to the set (in index.js):
const schema = [
{
date: new Date('2021-01-04'),
headers: ['ccaa', 'entregadas', 'administradas', 'admin_entregadas', 'hasta']
},
{
date: new Date('2021-01-14'),
headers: ['ccaa', 'pfizer', 'moderna', 'entregadas', 'administradas', 'admin_entregadas', 'hasta']
},
{
date: new Date('2021-01-17'),
headers: ['ccaa', 'pfizer', 'moderna', 'entregadas', 'administradas', 'admin_entregadas', 'vacuna_completa', 'hasta']
}
];