Missing VAERS reports are duplicates

But I am not sure why they are still in the CSV file

Summary:

• I wrote this article to examine VAERS reports that appear in CSV files but are missing from the CDC VAERS search tool

  • My SQL analysis reveals all missing reports are duplicates that should have been deleted from the CSV file

  • There are only 9 unique missing reports for now, two were double counted

• I recommend using the History view rather than regular view for this analysis, especially for foreign reports

  • The CDC stopped publishing crucial information for EU reports in November 2022, making analysis more difficult

• The missing reports are duplicates intended to be followup reports to original entries

• I haven't found any original reports that incorporated followup information by adding extra rows (ORDER > 1)

• Two specific reports (rows 4 and 8) are missing their originals but actually refer to the same patient

  • These likely have a third report (ID < 1786978) as their original, now difficult to identify due to CDC's deletion of EU VAERS report information

  • Building full text search for historical data could help identify these original reports

Yesterday

Closed VAERS

wrote an article about some VAERS reports which appear in the CSV file but are actually missing on the CDC VAERS search tool.

VAERS Has No Parity (Part 2)

I did some SQL analysis and I think all the missing reports are actually duplicates which should have been deleted from the CSV file.

Note: there are only 9 unique missing reports till now, because Albert double counted two of them.

Also it is much easier to use the History view rather than the regular view while doing this analysis, especially for foreign reports. This is because the CDC stopped publishing a lot of important information for EU reports in November 2022.

The foreign data set was gutted this week in VAERS and the cancer signal was halved, the myocarditis dose 3 response signal was lost and 994 spontaneous abortions/still births were dropped

For example this is the regular view for 1884545

Link

And this is the History view:

Link

Here is the list of original reports - the missing reports are duplicates intended to be followup reports.

Click here to see the mapping between missing and original reports

I also checked to see if any of the original reports had incorporated the followup information by adding extra rows (that is, ORDER > 1). Till now, I haven’t seen any.

You will also notice that the original is missing for row 4 and row 8.

If you click into the reports, you can see that they both refer to the same patient.

This means there is a third report (with ID < 1786978) which is the original report which has these two as follow ups.

Since CDC has deleted all the information from EU VAERS reports, it could be quite hard now to go and look at the historical data and identify the original.

(Although it can probably be done if someone builds full text search for the historical data)