COVID-19 Vaccination Database

A patient registry with every COVID-19 dose given: vaccine, lot, site and adverse events, plus each person’s status and next due date.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Healthcare

Tables

Patients, Doses

Fields

26

Views

grid, dashboard, calendar

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Patients

15 fields · 4 sample rows

  • Registry (Grid)
  • By priority group (Grid)
  • Coverage (Dashboard)
NameTextDate of BirthDateAgeFormulaGenderSingle selectPhonePhoneEmailEmailID TypeSingle selectID Number (last 4)TextPriority GroupSingle selectComorbiditiesMultiple selectDosesLink to another tableDoses ReceivedCountLast DoseRollupStatusFormulaNext DueFormula
Lakshmi Narayanan10 Feb 195274Female+91 94440 12345Aadhaar482160+HypertensionLakshmi Narayanan – Dose 1, Lakshmi Narayanan – Dose 221776384000000Fully vaccinated17 Jan 2027
Dr. Amit Saxena25 Jun 198046Male+91 98110 99887[email protected]Aadhaar0937Healthcare workerDr. Amit Saxena – Dose 1, Dr. Amit Saxena – Dose 2, Dr. Amit Saxena – Booster31786406400000Boosted
Olivia Brown8 Dec 199332Female[email protected]Passport7710GeneralOlivia Brown – Dose 111789862400000Partially vaccinated13 Dec 2026
Gurpreet Singh17 Sep 197452Male+91 98140 55566Driving licence330245+ with comorbidityDiabetes, Kidney disease0Not vaccinated
Field details
Name · Text
Date of Birth · Date
Age · Formula
IF({Date of Birth}, DATETIME_DIFF(TODAY(), {Date of Birth}, 'years'), BLANK())
Gender · Single select
Female, Male, Other
Phone · Phone
Email · Email
ID Type · Single select
Aadhaar, Passport, Driving licence, Voter ID
ID Number (last 4) · Text
Priority Group · Single select
Healthcare worker, Frontline worker, 60+, 45+ with comorbidity, General
Comorbidities · Multiple select
Diabetes, Hypertension, Heart disease, Chronic lung disease, Kidney disease, Cancer
Doses · Link to another table
Links to Doses
Doses Received · Count
Last Dose · Rollup
max of Date Given via Doses
Status · Formula
SWITCH({Doses Received}, 0, 'Not vaccinated', 1, 'Partially vaccinated', 2, 'Fully vaccinated', 'Boosted')
Next Due · Formula
IF({Doses Received} = 1, DATEADD({Last Dose}, 84, 'days'), IF({Doses Received} = 2, DATEADD({Last Dose}, 9, 'months'), BLANK()))

Doses

11 fields · 6 sample rows

  • All doses (Grid)
  • By vaccine (Grid)
  • Calendar (Calendar)
Dose RecordFormulaPatientLink to another tableDoseSingle selectVaccineSingle selectLot NumberTextDate GivenDateSiteSingle selectVaccinatorTextLocationTextAdverse EventSingle selectCertificateAttachment
Lakshmi Narayanan – Dose 1Lakshmi NarayananDose 1Covishield4121Z02523 Jan 2026Left deltoidANM RevathiPHC AdyarNone
Lakshmi Narayanan – Dose 2Lakshmi NarayananDose 2Covishield4121Z08817 Apr 2026Left deltoidANM RevathiPHC AdyarMild (sore arm, fever)
Dr. Amit Saxena – Dose 1Dr. Amit SaxenaDose 1CovaxinBB21-33915 Oct 2025Right deltoidSr. MaryAIIMS staff clinicNone
Dr. Amit Saxena – Dose 2Dr. Amit SaxenaDose 2CovaxinBB21-37212 Nov 2025Right deltoidSr. MaryAIIMS staff clinicNone
Dr. Amit Saxena – BoosterDr. Amit SaxenaBoosterCorbevaxCB-092111 Aug 2026Right deltoidSr. MaryAIIMS staff clinicNone
Olivia Brown – Dose 1Olivia BrownDose 1Pfizer-BioNTechFK889120 Sep 2026Left deltoidNurse KimCity Travel ClinicMild (sore arm, fever)
Field details
Dose Record · Formula
CONCAT(ARRAYJOIN({Patient}), ' – ', {Dose})
Patient · Link to another table
Links to Patients
Dose · Single select
Dose 1, Dose 2, Booster
Vaccine · Single select
Covishield, Covaxin, Corbevax, Pfizer-BioNTech, Moderna, Novavax
Lot Number · Text
Date Given · Date
Site · Single select
Left deltoid, Right deltoid
Vaccinator · Text
Location · Text
Adverse Event · Single select
None, Mild (sore arm, fever), Moderate, Severe – reported
Certificate · Attachment

COVID-19 Vaccination Database: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates