National Vaccine
Information Center

Your Health. Your Family. Your Choice.
MedAlerts Home

Help Introduction
Expert Mode
Presentations
Presentations (Expert)
Choosing Cases
Choosing Cases (Expert)
Examples
Symptoms (Expert)

Presentations (Expert)

When in Expert Mode (the checkbox in the upper-right corner) there are many more choices for how search results can be presented.


Dose-adjusted Graphs and Tables

MedAlerts is able to show graphs and tables of the number of VAERS reports per dose of vaccine administered. This is done by selecting special "dose-adjusted" Graph and Table factors: Vaccines (dose-adjusted) and Year of Vaccination (dose-adjusted).

For example, if there are 1,000,000 doses given, and 500 VAERS reports, then the ratio is 500 / 1,000,000 = 0.0005 VAERS reports per vaccination.

Click Here to see the dosage numbers being used.


Reverse Vaccine Search

When choosing Vaccines in Section 3, it is possible to request that the listed vaccines not be selected. For example, if you want to see all vaccine products except for FLU, then select FLU and click on Excluded.


Case Detail Sorting

When Case Details are requested, there is a choice of how to order them. You can also check Reverse Ordering to reverse that order.


Adjusting Maps for Census

Maps can be adjusted for census data so that, instead of showing the total number of cases that occurred in each state, they show the number of cases per person in each state. This normalizes the data so that highly-populated states don't always appear bad.


CDC "Split Type" Country Codes

The CDC Split Type is a field that holds arbitrary text, probably from other databases. According to VAERS, it contains the "manufacturer number or immunization project number." Some of the Split Type fields also contain country codes.

You can examine these country codes by selecting the Graph or Table factor: CDC Split-type country code. This looks through the Split Type fields for those with country codes, then displays those countries. For each country code, the nature of that code is provided. Those with (phh) after them are from Split Types that start with the letters "PHH." Those with (waes) after them are from Split Types that start with the letters "WAES" (probably the Worldwide Aeromedical Evacuation System).


Precision

When Tables or Graphs are made, analysis values are computed. These values are shown with 2 digits of precision to the right of the decimal point (for example "26.12"). To change this precision value, a Precision choice appears in Section 1.


Custom Month Bar Colors

When making a monthly graph (for example, "Month of Vaccination" or "Month of Onset") it is possible to colorize the monthly bars so that they are more easily recognizable. Of course, this applies only to bar graphs, not line or pie graphs. Choosing Custom Month Bar Colors and a monthly graph makes the following section appear in the search form:

Enter color values for each month. Leave the month blank to use the default color (yellow).


Saving Case Details To Disk

In the "Case Details" part of Section 1, Expert Mode gives you a new checkbox: Save To File. This requests that the Case Details be saved to a disk file on your local computer. This file is a tab-separated text file that can be read into any spreadsheet program. If you choose this form, there will be no web output from a "Find", so no Table, Map, Graph, or Case Details will be shown.

The columns in the spreadsheet are:

  • VAERS_ID The ID number of the VAERS case.
  • VAX_DATE The date of vaccination.
  • AGE_YRS The age (in years) at the time of vaccination.
  • S_DATE The date the report appeared in VAERS.
  • SEX The gender.
  • RPT_DATE The date the report was submitted to VAERS.
  • V_ADMINBY Agency administering the vaccination.
  • STATE The location.
  • V_FUNDBY Agency funding the vaccination.
  • L_THREAT Whether the event was life-threatening.
  • DIED Whether the patient died.
  • DISABLE Whether the patient was left disabled.
  • RECOVD Whether the patient recovered.
  • ER_VISIT Whether the event involved a visit to an Emergency Room.
  • HOSPITAL Whether the patient was hospitalized.
  • HOSPDAYS Number of days spent in the hospital (if hospitalized).
  • X_STAY Whether the hospitalization was for an extended-stay.
  • CUR_ILL Any current illness at the time of vaccination.
  • LAB_DATA Diagnostic laboratory data associated with the event.
  • PRIOR_VAX Previous vaccinations given before the event.
  • OTHER_MEDS Other medications given with the vaccination.
  • HISTORY Preexisting conditions at the time of the vaccination.
  • VAX The vaccines given (separated by slashes).
  • VAXMAN The manufacturer of the vaccines given (separated by slashes).
  • VAXLOT The lot number of the vaccines given (separated by slashes).
  • VAXDOSE The dosage of the vaccines given (separated by slashes).
  • VAXROUTE The route of vaccines given (separated by slashes).
  • VAXSITE The site (on the body) where the vaccines were administered (separated by slashes).
  • VAXNAME The brand name of the vaccines given (separated by slashes).
  • ONSET_DATE The date symptom onset.
  • VAX2ONSET Number of days between vaccination and onset.
  • VAX2DIED Number of days between vaccination and death.
  • VAX2REPORT Number of days between vaccination and submission to VAERS.
  • VAX2ENTERED Number of days between vaccination and appearance in VAERS.
  • ONSET2DIED Number of days between onset and death.
  • ONSET2REPORT Number of days between onset and submission to VAERS.
  • ONSET2ENTERED Number of days between onset and appearance in VAERS.
  • DIED2REPORT Number of days between death and submission to VAERS.
  • DIED2ENTERED Number of days between death and appearance in VAERS.
  • REPORT2ENTERED Number of days between submission to VAERS and appearance in VAERS.
  • SYM Symptoms (separated by slashes).
  • SPLITTYPE CDC 'Split Type'.
  • SYMPTOM_TEXT The writeup (a multi-paragraph description of the event).


Copyright © 2017 National Vaccine Information Center. All rights reserved.
21525 Ridgetop Circle, Suite 100, Sterling, VA 20166