msusicky / ockovani-covid Goto Github PK

Zobrazeni ockovacich mist a volnych terminu
Zobrazeni specifickych mest

It is necessary to solve date handling - insert new dates and delete old one ?

• add weekday to dates
• use words like today/yesterday in last update info

Could you pls add summarizing line to the table of vaccines delivered on this page https://msusicky.github.io/ockovani-covid/statistiky and to the table of vaccinations according age as well? Thank you.

Put web link to About - edit available only to owner :-)

Overview of free slots in "mista" page should contain info about people in queue, ratio of successful reservations within last week, ...

How to include something similar in okres/kraj/misto pages?

• People in queue
• Ratio of new reservations in last week
• Number of vaccines that arrived in the last 7 days
• Vaccines needed for the 2nd round - #55

For covtest etc...

Store time of the source data update to the imports table and print this time instead of the time when fetcher started

Show time of the last web update and time of the last data update

Store min date and max date and compare them if they are all from the same day? - fail if new data are not present

Hi,
could you consider separating the numbers by thousands in the tables and elsewhere? tnx

To have better URL we'd decided to move under OpenDataLab (@msusicky is one of the leader)
It is already active, but now only redirecting to old repo.

• Prepare branch with working menu links etc
• Have a message on the intro page about move
• Change github pusher
• Have both working for 2 days - weekend
• Do a redirect from the old repo

Red - no free capacity
Green - free capacity

Maybe introduce yellow for centers with free capacity below 10/50/100? (this should be also in tables)

Add news section - what has changed / project timeline

Add "celkem_mista" to VolnaMistaDen and VolnaMistaCas, this info has to be fetched from different API endpoint (TODO)

It is necessary to check how big is the difference between consumption and vaccinated people - mista.
It looks that vaccination is better source, or consumption is D-2.

Bootstrap has better tooltips than plain HTML - https://getbootstrap.com/docs/4.0/components/tooltips/

We have more details in object OckovaciMisto than we actually use -> add them to the top of the vaccination center page

It will be great to have Leaflet map there.
New link on the top is expected with description Map.
All vaccination places should be there - fetched from opendata from UZIS.

Move links to CSV files to separate page and describe their structure there

In data there is a flag if registered person has reservation or not. But there is no date of the assignement. Makes sense to compute it from today and yesterday data and put it as a result. Maybe to realize it with trigger ?

Plus -> see how long does it take to obtain a reservation. -> powerful metric

• similar stats as for vaccination center can be computed for whole okres or kraj
• components should be created not to copy the code

depends on #102

Add to our DB official dataset from UZIS with off. vacc. places and link them to our ockovaci_mista

From the opendata add info about vacc. that should be available

Tool should process this file: https://onemocneni-aktualne.mzcr.cz/api/v2/covid-19/prehled-ockovacich-mist.json and insert missing places into the table or update existing ones.

Table contains also some manually filled columns (service_id, operation_id, ...), these have to remain unchanged

Colors can be confusing - we should somehow describe that they don't have any special meaning and they are just for the better orientation

• check if main and develop branches are in sync (merges from develop will not bring conflicts)
• check if main and develop are protected
• improve logging and exit code of used scripts
• implement pipeline for main update - deploy to prd environment and update static pages
• implement pipeline for develop update - deploy to test environment
• implement scheduled pipeline for data update

Depends on: #97

It is necessary to cache list of Mista and then just check them quickly and not to query each row...

On each vacc. place should be some amount (or need) of reserved vaccines for the second round of the vaccination. Compute it

Dotazovani API a zapis do databaze

We have more and more notes and warnings in tooltips which are hardly visible - clean and visible way could be exclamation mark next to the column name and tooltip with description.

I would appreciate a bit more information around the raw data presented, tooltips for columns, short description for each table.

https://msusicky.github.io/ockovani-covid/misto/c8e549b8-aafb-4b4c-ae3b-b1ccee70513f - what is the meaning of the third column in the second table (Stav registrací > Poměr)?

Is it possible to show how many people were vaccinated every day? If so, can it be broken down into groups too?

2021-01-18 00:00:00 - should be with seconds

Cilem je scrapovat pres hlidace volnych terminu subjekty, ktere na reservio jsou

Centers for which we don't have info about their free capacity should be marked gray

List of centers: https://cfa.uzis.cz/vaccination-centers/
Link to specific center: https://cfa.uzis.cz/vaccination-centers/586ab361-ba26-4429-b0f3-8ff9831f07b2/
Id is same as in open data

Update time is wrong

Pipeline should be automatically executed after update-data (doesn't work) and deploy-production (works)

• check data - count of used vaccines can be outdated for some vaccination centers - (it is but, warnign added)
• thousands separator in numbers
• add doses to model
• use doses instead of ampoules
• compute stats using pandas instead of SQL and plain python
• create reusable UI component
• hide overflows of category column - tooltip with whole description