ā1
|
āRecipient ID
|
ārecip_id
|
āUnique ID for this recipient. This can be the ID used by your system or a randomly assigned unique identifier. However, the ID must be consistent across reports to allow linking doses to the same recipient ID.
|
ān/a
|
ā2
|
āAdministration
date ā Dose 1
|
āds1_admin_date
|
āThe first recorded dose administration date for the recipient.
Ignores DOSE_NUM field in VW_ALL_IIS_LHJ for determination.
|
ān/a
|
ā3
|
āAdministration
date ā Dose 2
|
āds2_admin_date
|
āThe second recorded dose administration date for the recipient.
Ignores DOSE_NUM field in VW_ALL_IIS_LHJ for determination.
|
ān/a
|
ā4
|
āVaccine types
received
|
āvax_received
|
āThe manufacturer name (s) of all vaccines received, for up to 4 doses.
|
Locally Defined Value Set: Moderna Pfizer J&J
|
ā5
|
āVaccination
status
|
āfully_vaccinated
|
āRecipientās vaccination status.
A vaccine recipient is considered fully vaccinated if they meet at least one of the following criteria: 1) They received one dose of J&J 2) They received two Pfizer doses >= 17 days apart 3) They received two Moderna doses >= 24 days apart 4) They received a combination of Pfizer/Moderna doses >= 17 days apart.
The following criteria were removed on 2/22/2022:
- Three or more vaccination records
- Only dose in IRIS is labeled as dose number 2
|
āLocally Defined Value Set: FALSE (Partially vaccinated) TRUE (Fully vaccinated)
|
ā6
|
āRecipient
name: first
|
ārecip_first_name
|
Recipient's first name. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value
|
ān/a
|
ā7
|
Recipient
name: middle ā
|
ārecip_middle
_name
|
Recipient's middle name. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
|
ān/a
|
ā8
|
Recipient
name: last ā
|
ārecip_last_name
|
Recipient's last name. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
|
ān/a
|
ā9
|
Recipient
date of birth ā
|
ārecip_dob
|
Recipient's date of birth. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
|
ān/a
|
ā10
|
Recipient age ā
|
ārecip_age
|
Recipientās age in years. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value
|
ān/a
|
ā11
|
Recipient
age group ā
|
ārecip_age_group
|
Recipientās age group, in years. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
|
āLocally Defined Value Set:
Birthdates within 60 days of the vaccination date are categorized as āUnknownā
|
ā12
|
Recipient sex ā
|
ārecip_sex
|
Recipient sex. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
|
āHL7 User Defined Table 0001 M (Male) F (Female) U (Unknown/ undifferentiated)
|
ā13
|
Recipient race/ethnicity ā
|
ārecip_race_eth
|
Recipientās race/ethnicity. UPDATED 9/7/2022. Derived from value recorded for most recent dose. Previously derived from second dose value
|
āWhen ethnicity is marked āHispanic or Latinoā then āLatinoā, when more than one specified race code (1002-5, 2028-9, 2076-8, 2054-5, 2106-3) is noted then āMultiracialā, otherwise first race is noted.
Derived from original ethnicity and race codes:
HL7 User Defined Table 0189
2135-2 (Hispanic or Latino)
2186-5 (Not Hispanic or Latino)
POL (Unable to report to do policy/law)
HL7 User Defined Table 0005
1002-5 (American Indian or Alaska Native)
2076-8 (Native Hawaiian or Other Pacific Islander)
2054-5 (Black or African American)
POL (Unable to report due to policy/law)
|
ā14
|
Recipient
address: street ā
|
ārecip_address_street
|
āThe street component of the recipient's address.
UPDATED 4/5/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
|
ān/a
|
ā15
|
Recipient
address: street 2 ā
|
ārecip_address
_street_2
|
āThe street 2 component of the recipient's address.
UPDATED 4/5/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
Previous name: recip_recip_address _street_2.
|
ān/a
|
ā16
|
Recipient
address: city ā
|
ārecip_address_city
|
āThe city component of the recipient's address.
UPDATED 4/5/2022.
Derived from value recorded for most recent dose. Previously derived from second dose value.
|
ān/a
|
ā17
|
Recipient
address:
zip code ā
|
ārecip_address_zip
|
āThe zip code of the recipient's address (5 digit or 10 digits, with hyphen, are acceptable).
UPDATED 4/5/2022.
Derived from value recorded for most recent dose. Previously derived from second dose value.
|
ān/a
|
ā18
|
Recipient
county name ā
|
ārecip_county_label
|
āThe county name component of the recipient's address.
āOutside Californiaā category includes out-of-state residents and records where recipientās state of residence is blank.
UPDATED 4/5/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
|
āDerived from FIPs based on County_Code. When recip_address_county is null, derived from recip_address_zip.
See Recip_Address_
County_New.
|
ā19
|
Responsible organization ā
|
āresponsible_org
|
āThe name of the parent organization or health system that originated and is accountable for the content of the record. If an organization has several clinics or facilities, this would be the organization that represents all of the clinics/facilities. (The "Administered at location" field is the name of individual physical location.)
UPDATED 4/5/2022.
Derived from value recorded for most recent dose. Previously derived from second dose value.
|
ān/a
|
ā20
|
āAdministered
at location
|
āadmin_name
|
āThe name of the physical clinic or facility that reported the vaccination, refusal, or missed appointment. In a small practice setting, this could be the same as the responsible organization.
UPDATED 4/5/2022.
Derived from value recorded for most recent dose. Previously derived from second dose value.
|
ān/a
|
ā21
|
Administration
address: zip code ā
|
āadmin_address_zip
|
āThe zip code component of where the vaccine is being administered/ planned to be administered. Exception for mobile clinics.
UPDATED 4/5/2022.
Derived from value recorded for most recent dose. Previously derived from second dose value.
|
ān/a
|
ā22
|
Administration
address: county name ā
|
āadmin_county_label
|
āThe county component of where the vaccine is being administered/ planned to be administered. Exception for mobile clinics.
UPDATED 4/5/2022.
Derived from value recorded for most recent dose. Previously derived from second dose value.
|
āJoin with FIPS table based on County_Code to get the name/desc.
|
ā23
|
Mixed zip ā
|
āmixed_zip
|
UPDATED 7/26/2022. Derived from value recorded for most recent dose. Previously derived from second dose value
|
ā |
ā24
|
Mixed county ā
|
āmixed_county
|
If recip_address_county_new is NULL or unknown, populate this with admin_county_label.
UPDATED 7/26/2022. Derived from value recorded for most recent dose. Previously derived from second dose value
āOutside Californiaā category includes out-of-state residents and records where recipientās state of residence is blank.
UPDATED 4/5/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
|
ā |
ā25
|
āLocal health jurisdiction
|
āLHJ
|
āLocal health jurisdiction of recipientās residence; if zip code (mixed_zip) is in Berkeley, Long Beach, or Pasadena cities, LHJ = Berkeley, Long Beach and Pasadena, respectively, otherwise LHJ = mixed_county. UPDATED 7/26/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
āOutside Californiaā category includes out-of-state residents and records where recipientās state of residence is blank.
|
āwhen mixed_zip in
('94701', '94702', '94703', '94704', '94705', '94707', '94708', '94709', '94710', '94712', '94720') then 'Berkeley'
āÆwhen mixed_zip in
('90801', '90802', '90803', '90804', '90805', '90806', '90807', '90808', '90809', '90810', '90813', '90814', '90815', '90822', '90831', '90832',
āÆwhen mixed_zip in
('90833', '90834', '90835', '90840', '90842', '90844', '90845', '90846', '90847', '90848', '90853', '90888', '90899') then 'Long Beach'
when left(mixed_zip,5)
in ('91101', '91102',
'91103', '91104', '91105', '91106', '91107', '91109', '91110', '91114', '91115', '91116', '91117', '91121', '91123', '91124', '91125', '91126', '91129', '91131', '91182', '91184', '91185', '91188', '91189', '91191', '91199') then 'Pasadena'
|
ā26
|
VEM quartile ā
|
āhpiquartile
|
āVaccine Equity Metric (VEM) score quartiles based on mixed_zip.
Vaccine Equity Metric (VEM) score quartiles combine the Public Health Alliance of Southern Californiaās Healthy Places Index (HPI) measure with CDPH-derived scores to estimate factors that impact health, like income, education, and access to health care. Zip codes range from less healthy community conditions in Quartile 1 to more healthy community conditions in Quartile 4.
UPDATED 7/26/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
|
āLocally Defined Value Set:
Null (no VEM score assigned)
|
ā27
|
VEM quartile
based on
recipient
zip code ā
|
āhpiquartile_rcp_zip
|
āVaccine Equity Metric (VEM) score quartiles based on recipient zip code.
Vaccine Equity Metric (VEM) score quartiles combine the Public Health Alliance of Southern Californiaās Healthy Places Index (HPI) measure with CDPH-derived scores to estimate factors that impact health, like income, education, and access to health care. Zip codes range from less healthy community conditions in Quartile 1 to more healthy community conditions in Quartile 4.
UPDATED 7/26/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
|
āLocally Defined Value Set:
Null (no VEM score assigned)
|
ā28
|
Recipient
address:
county based
on zip code ā
|
āhpi_county_rcp_zip
|
āThe county name of the recipientās address, derived from the zip code of the recipientās address.
UPDATED 7/26/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
|
āCounty derived from recip_address_zip.
|
ā29
|
Administered
at location: type ā
|
āadmin_type_desc
|
āThe characteristic of the provider site that reported the vaccination, refusal, or missed appointment.
Derived from value recorded for second dose, unless null, then first dose value is used.
|
āLabels from Locally Defined Value Set:
1 (Commercial vaccination service provider) 2 (Corrections/ detention health services) 3 (Health center ā community) 4 (Health center ā migrant or refugee) 5 (Health center ā occupational) 6 (Health center ā
STD/HIV clinic) 7 (Health center ā student) 8 (Home health care provider) 9 (Hospital) 10 (Indian Health Service) 11 (Tribal health) 12 (Medical practice ā family medicine) 13 (Medical practice ā pediatrics) 14 (Medical practice ā internal medicine) 15 (Medical practice ā OB/GYN) 16 (Medical practice ā other specialty) 17 (Pharmacy ā chain) 18 (Pharmacy ā independent) 19 (Public health provider ā public health clinic) 20 (Public health provider ā Federally Qualified Health Center)
21 (Public health provider ā Rural Health Clinic) 22 (Long-term care ā nursing home, skilled nursing facility, federally certified) 23 (Long-term care ā nursing home, skilled nursing facility, non-federally certified) 24 (Long-term care ā assisted living) 25 (Long-term care ā intellectual or developmental disability) 26 (Long-term care ā combination) 27 (Urgent care) 28 (Other) UNK (Unknown)
|
ā30
|
MCEā
|
āMCE
|
āProvider affiliated with state agency multi-county entity, health system multi-county entity, or pharmacy entity participating in CDC Long Term Care or Retail Pharmacy Partnership programs.
Derived from value recorded for second dose, unless null, then first dose value is used.
|
Locally Defined Value Set:
CDCR (State Agency MCE - California Department of Corrections and Rehabilitation)
DHS (State Agency MCE - Department of State Hospitals)
AHMC Healthcare (Health System MCE)
Dignity Health (Health System MCE)
Kaiser Permanente (Health System MCE)
Providence (Health System MCE)
Sutter Health (Health System MCE)
UC Health (Health System MCE)
Albertson Companies, Inc. (Pharmacy)
Premier-Innovatix (Pharmacy)
|
ā31
|
āLot numbers
|
ālot_numbers
|
āThe lot numbers for all COVID vaccinations administered, concatenated.
|
ān/a
|
ā32
|
Original dose
number ā Dose 1 ā
|
āds1_orig_dose_num
|
āOriginal reported dose number in vaccination series for first dose.
|
āLocally Defined Value Set: 1 (Valid first dose) 2 (Valid second dose) INV (Invalid dose) UNK (Unknown validity)
|
ā33
|
Original dose
number ā Dose 2 ā
|
āds2_orig_dose_num
|
āOriginal reported dose number in vaccination series for second dose.
|
āLocally Defined Value Set: 1 (Valid first dose) 2 (Valid second dose) INV (Invalid dose) UNK (Unknown validity)
|
ā34
|
Dose 1
vaccination
event ID ā
|
āds1_vax_event_id
|
āThe vaccination eventās unique identifier within the system for first reported dose (based on vaccination date).
|
ān/a
|
ā35
|
āDose 2
vaccination
event ID
|
āds2_vax_event_id
|
āThe vaccination eventās unique identifier within the system for second reported dose (based on vaccination date).
|
ān/a
|
ā36
|
Dose 3
vaccination
event ID ā
|
āds3_vax_event_id
|
āThe vaccination eventās unique identifier within the system for third reported dose (based on vaccination date).
|
ān/a
|
ā37
|
āDose 4
vaccination
event ID
|
āds4_vax_event_id
|
āThe vaccination eventās unique identifier within the system for fourth reported dose (based on vaccination date).
|
ān/a
|
ā38
|
Snapshot time ā
|
āsnapshot_time
|
āData current as of this timestamp.
|
ān/a
|
ā39
|
Partially
vaccinated date ā
|
āpartially_vaccinated
_date
|
āDate recipient became partially vaccinated (i.e., received first dose of Pfizer or Moderna).
|
ān/a
|
ā40
|
Fully
vaccinated date ā
|
āfully_vaccinated_date
|
āDate recipient became fully vaccinated.
|
ān/a
|
ā41
|
Emailā
|
āEmail_Address
|
āRecipientās email.
Derived from value recorded for second dose, unless null, then first dose value is used.
|
ā |
ā42
|
Phone number ā
|
āPhone_Number
|
āRecipientās phone number
Derived from value recorded for second dose, unless null, then first dose value is used.
|
ā |
ā43
|
Administration
date ā Dose 3 ā
|
āds3_admin_date
|
āIf given, the third recorded dose administration date for the recipient.
Ignores DOSE_NUM field in VW_ALL_IIS_LHJ for determination.
|
ān/a
|
ā44
|
āAdministration
date ā Dose 4
|
āds4_admin_date
|
āIf given, the fourth recorded dose administration date for the recipient.
Ignores DOSE_NUM field in VW_ALL_IIS_LHJ for determination.
|
ān/a
|
ā45
|
Original dose
number ā Dose 3 ā
|
āds3_orig_dose_num
|
āOriginal reported dose number in vaccination series for third dose.
|
āLocally Defined Value Set: 1 (Valid first dose) 2 (Valid second dose) INV (Invalid dose) UNK (Unknown validity)
|
ā46
|
Original dose
number ā Dose 4 ā
|
āds4_orig_dose_num
|
āOriginal reported dose number in vaccination series for fourth dose.
|
āLocally Defined Value Set: 1 (Valid first dose) 2 (Valid second dose) INV (Invalid dose) UNK (Unknown validity)
|
ā47
|
Booster dose
flag ā Pfizer ā
|
āPfizer_Booster
|
āReceived at least 3 doses of Pfizer and 12+ years of age.
UPDATED 1/25/2022.
Previous names:
Is_Pfizer_3+_18+;
Is_Pfizer_3+_12+ (1/11/2022)
|
ā0 (FALSE)
|
ā48
|
āBooster dose flag - Pfizer with minimum interval
|
Pfizer_Booster _Interval
|
Received at least 3 doses of Pfizer, with minimum interval of 136 days between 2nd and 3rd dose, and 12+ years of age.
UPDATED 1/25/2022.
Previous names: Is_Pfizer_3+_18+_164+;
Is_Pfizer_3+_12+_136+
(1/11/2022)
|
ā0 (FALSE)
|
ā49
|
āAdditional dose flag
|
āHAS_ADDITIONAL
_DOSE_AND_24_DAYS
|
āReceived additional dose administered at least 24 days after series completion (Pfizer recipients 5+ years of age, Moderna and J&J recipients 18+ years of age).
Includes any dose that was administered at least 24 days after series completion (2 mRNA or 1 J&J). Includes both additional doses and booster doses.
UPDATED 8/24/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
|
0 (FALSE)
|
ā50
|
āBooster dose flag ā Moderna
|
āModerna_Booster
|
āAt least 3 doses of Moderna and 18+ years of age.
UPDATED 1/25/2022.
Previous name: Is_Moderna_3+_18+.
|
ā0 (FALSE)
|
ā51
|
āBooster dose flag ā Moderna with minimum interval
|
āModerna_Booster
_Interval
|
āAt least 3 doses of Moderna, with minimum interval of 136 days between 2nd and 3rd dose, and 18+ years of age.
UPDATED 1/25/2022.
Previous name: Is_Moderna_3+_18+_164+.
Changed minimum interval from 164 days to 136 days per updated CDC recommendations.
|
0 (FALSE)
|
ā52
|
Booster dose flag ā J&J ā
|
āJJ_Booster
|
āAt least 2 doses of J&J and 18+ years of age.
UPDATED 1/25/2022.
Previous name: Is_JJ_2+_18+.
|
ā0 (FALSE)
|
ā53
|
āBooster dose flag ā J&J with minimum interval
|
āJJ_Booster_Interval
|
āAt least 2 doses of J&J, with minimum interval of 52 days between 1st and 2nd dose, and 18+ years of age.
UPDATED 1/25/2022.
Previous name:
Is_JJ_2+_18+_52+.
|
ā0 (FALSE)
|
ā54
|
āBooster dose flag ā mixed mRNA
|
āPfizer_or_Moderna
_Booster
|
āAt least 3 doses of Pfizer or Moderna combined and 18+ years of age.
UPDATED 1/25/2022.
Previous name: Is_Pfizer_or_Moderna
_3+_18+.
|
ā0 (FALSE)
|
ā55
|
āBooster dose flag ā mixed mRNA with minimum interval
|
āPfizer_or_Moderna
_Booster_ Interval
|
āAt least 3 doses of Pfizer or Moderna combined, with a minimum interval of 136 days between 2nd and 3rd dose, and 18+ years of age.
UPDATED 1/25/2022.
Previous name: Is_Pfizer_or_Moderna
_3+_18+_164+.
Changed minimum interval from 164 days to 136 days per updated CDC recommendations.
|
ā0 (FALSE)
|
ā56
|
āAdditional dose flag ā 52 day interval
|
āHAS_ADDITIONAL
_DOSE_AND_52_DAYS
|
āAdditional dose administered at least 52 days after series completion.
UPDATED 8/24/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
|
ā0 (FALSE)
|
ā57
|
āRecipient address: state
|
āRECIP_ADDRESS
_STATE
|
āThe state component of the recipient's address.
UPDATED 4/5/2022.
Derived from value recorded for most recent dose. Previously derived from second dose value.
|
āUS Postal Service two-character state codes
|
ā58
|
Administration address: state ā
|
āADMIN_ADDRESS
_STATE
|
āThe state component of where the vaccine is administered/ planned to be administered. Exception for mobile clinics.
UPDATED 4/5/2022.
Derived from value recorded for most recent dose. Previously derived from second dose value.
|
āUS Postal Service two-character state codes
|
ā59
|
āPatient sharing indicator
|
āLOCKED_IND
|
āPatient sharing status.
If 1, patient has requested that their record not be shared with organizations other than their own provider or public health.
|
ā0 (FALSE)
|
ā60
|
āBooster eligibility flag
|
āIS_BOOSTER
_ELIGIBLE
|
A vaccine recipient is considered eligible for a booster if they meet at least one of the following criteria: Monovalent Booster Eligibility
Age 5-11 (Suppress on/after 10/13/2022): 3rd dose (original booster) - Pfizer Monovalent Booster at least 136 days after 2nd dose (Pfizer Pediatric)
Age 12+ (Suppress on/after 09/06/2022): 3rd dose (original booster) - Pfizer Monovalent Booster at least 136 days after 2nd dose (Pfizer/Moderna/Novavax)
Age 18+ (Suppress on/after 09/06/2022): 3rd dose (original booster) - Moderna Monovalent Booster at least 136 days after 2nd dose (Pfizer/Moderna/Novavax)
Age 18+ (Suppress on/after 09/06/2022): 2nd dose (original booster) - J&J at least 52 days after 1st dose (J&J)
Bivalent Booster Eligibility Age 5+: 3rd dose (updated booster) - Pfizer pediatric bivalent booster at least 52 days after 2nd dose (Pfizer Pediatric/Moderna Under 6) Age group 6-11: 3rd dose (updated booster) - Pfizer Pediatric/Moderna bivalent booster at least 52 days after 2nd dose (Pfizer Pediatric/Moderna)
Age 12+: 3rd dose (updated booster) - Pfizer/Moderna bivalent booster at least 52 days after 2nd dose (Pfizer/Moderna/Novavax) or last monovalent booster (Pfizer/Moderna)
Age 18+: 2nd dose (updated booster) - Pfizer/Moderna bivalent booster at least 52 days after 1st dose (J&J) or last monovalent booster (Pfizer/Moderna)
|
ā0 (FALSE)
|
ā61
|
Booster eligibility flag ā 2nd booster ā
|
āIS_SECOND
_BOOSTER_ELIGIBLE
|
āA vaccine recipient is considered eligible for a second booster if they meet at least one of the following criteria:
- Age 50+ and received first booster of any vaccine >= 108 days ago
- Age 18+ and received J&J vaccine for primary dose, and J&J vaccine for first booster >= 52 days ago
|
ā0 (FALSE)
|
ā62
|
āBooster dose flag ā 2nd Pfizer booster with minimum interval
|
āPfizer_Booster
_2_Interval
|
āAt least 4 doses of Pfizer, with minimum interval of 108 days between 3rd and 4th dose, and 12+ years of age.
|
ā0 (FALSE)
|
ā63
|
āBooster dose flag ā 2nd Moderna booster with minimum interval
|
āModerna_Booster
_2_Interval
|
āAt least 4 doses of Moderna, with minimum interval of 108 days between 3rd and 4th dose, and 18+ years of age.
|
ā0 (FALSE)
|
ā64
|
āBooster dose flag ā 2nd booster of mixed mRNA with minimum interval
|
āPfizer_or_Moderna
_Booster_2_Interval
|
āAt least 4 doses of Pfizer or Moderna combined, with a minimum interval of 108 days between 3rd and 4th dose, and 12+ years of age.
|
ā0 (FALSE)
|
ā65
|
Booster dose flag ā 2nd J&J booster with minimum interval ā
|
āJJ_Booster
_2_Interval
|
āAt least 3 doses of J&J, with minimum interval of 108 days between 2nd and 3rd dose, and 18+ years of age.
|
ā0 (FALSE)
|
ā66
| āBooster dose flag - bivalent
| āBIVALENT_BOOSTER
| āAge 5+: 3rd dose (updated booster) - Pfizer pediatric bivalent booster at least 52 days after 2nd dose (Pfizer Pediatric/Moderna Under 6) Age group 6-11: 3rd dose (updated booster) - Pfizer Pediatric/Moderna bivalent booster at least 52 days after 2nd dose (Pfizer Pediatric/Moderna)
Age 12+: 3rd dose (updated booster) - Pfizer/Moderna bivalent booster at least 52 days after 2nd dose (Pfizer/Moderna/Novavax) or last monovalent booster (Pfizer/Moderna)
Age 18+: 2nd dose (updated booster) - Pfizer/Moderna bivalent booster at least 52 days after 1st dose (J&J) or last monovalent booster (Pfizer/Moderna)
| ā 0 (FALSE) 1 (TRUE)
|
ā67
|
āAdditional dose flag ā 108 day interval
|
āhas_additional
_dose_and_108
_ days
|
āSecond additional dose after completion of primary series.
Additional dose that is 108 days after IS_ADDITIONAL_DOSE
_AND_24_DAYS flag is set for mRNA vaccine; OR
Additional dose that is 108 days after IS_ADDITIONAL_DOSE
_AND_52_DAYS flag is set for J&J vaccine.
UPDATED 8/24/2022. Derived from value recorded for most recent dose. Previously derived from second dose value.
|
ā0 (FALSE)
|
ā68
| āCensus tract ā recipient address (2020)
| āCENSUS_TRACT
| ā2020 census tract based on recipient address only.
| ā |
ā69
| āCensus tract ā recipient address (2010
| āCENSUS_TRACT_10
| ā2010 census tract based on recipient address only.
| ā |
70
| āCensus tract ā administration address
| āCENSUS_TRACT_ADMIN_10
| ā2010 census tract based on vaccinating providerās address only.
| ā |
ā71
| āHPI 3.0 - census tract
| āHPI_3_TRACT
| āHealthy Places Index 3.0 score based on the 2010 census tract from the recipientās address.
| āHealthy Places Index
|
ā72
| āHPI 3.0 ā zip
| āHPI_3_ZIP
| āHealthy PIaces Index 3.0 score based on the recipientās address zip (if null, uses the ZCTA zip from the zip-to-ZCTA crosswalk); if recipientās address zip is still null, uses the vaccinating providerās address zip (if providerās address zip is null, uses the ZCTA from the zip-to-ZCTA crosswalk).
| āHealthy Places Index
|
ā73
| āHPI 3.0 - mixed
| āHPI_3_MIXED
| āHPI_3_TRACT; if null, uses HPI_3_ZIP.
| āHealthy Places Index
|
ā74
| āRecipient address: concatenated
| āMIXED_ADDRESS
| āConcatenation of the recipient address street, city, state, and zip code.
| ā |
ā75
| āAdministration address: concatenated
| āMIXED_ADMIN_ADDRESS
| āConcatenation of the vaccinating providerās address street, city, state, and zip code.
| ā |