HK Vaccination Data Capture

A script that monitors for updates to government-provided data to prevent daily overwriting of updates from losing previous data.

Data Export

Helper script for pasting into the HK Vaccination spreadsheet.

./values.sh sinovac | pbcopy
./values.sh biontech | pbcopy

Spreadsheet Update Steps

Daily Data

This repository automatically collects the daily data. After the daily data is published, update it here:

1. Summary

• Update Date (B1)

2. Doses by Age

• Run ./age.sh | pbcopy and paste into Rows 3-10.

3. Doses by Gender

• Run ./gender.sh | pbcopy and paste into Rows 3-4.

4. Doses by Venue

• Run ./venue.sh | pbcopy and paste into Rows 3-6.

5. Sinovac CoronaVac

• Run ./values.sh sinovac | pbcopy and paste into cell E4.
• If new doses have arrived, update Doses Received.

6. BioNTech Comirnaty

• Run ./values.sh biontech | pbcopy and paste into cell E4.
• If new doses have arrived, update Doses Received.

Daily Press Release

After the daily press release is published, update it here:

1. First Dose Vaccination Sites

• Update BioNTech CVC Doses (Row 22)
• Update Sinovac CVC Doses (Row 30)
• Update Sinovac Clinic Doses (Row 50)

2. Second Dose Vaccination Sites

• Update BioNTech CVC Doses (Row 22)
• Update Sinovac CVC Doses (Row 30)
• Update Sinovac Clinic Doses (Row 49)

3. Appointments

• Update Sinovac Appointments Made (Row 4)
• Update BioNTech Appointments Made (Row 9)

4. Attendance

• Update Sinovac Received (Attendance Rate) (Row 5)
• Update BioNTech Received (Attendance Rate) (Row 12)

Models

There are two predictive models created. Updating the models is a bit more involved, but not complicated.

1. Lot 1B002A is about to be retired.

• Copy Row 17 GROWTH formula one cell to the right.
• Copy last column of grey block over one column.
• If there is a trend period change, adjust the trend period row (Row 5) and the GROWTH formula to refer to the correct periods.

2. Peak Vaccination model has been created, but isn't valid yet. For it to be valid, we need: general availability, unconstrained appointments, 7 days of data without program changes.

• GROWTH formulas in rows 12 & 15, trend periods in rows 11 & 14.

After Analysis

1. Sinovac CoronaVac by Program Change

• If there has been a program change, insert a new row and add a note.
• Migrate the formula for automatic population of values to the new row.
• Ensure that the corresponding chart contains all rows and an appropriate amount of lookahead.

2. BioNTech Comirnaty by Program Change

• If there has been a program change, insert a new row and add a note.
• Migrate the formula for automatic population of values to the new row.
• Ensure that the corresponding chart contains all rows and an appropriate amount of lookahead.