vaers_flatfile_build.py run_all() ... validate_dirs_and_files() ... 1 drops in input to process First (oldest) input: ../Download/ALL_VAERS_DROPS/2020-12-18_VAERS_CSV.zip Last (newest) input: ../Download/ALL_VAERS_DROPS/2023-11-24_AllVAERSDataCSVS.zip Already processed files do appear in vaers_changes and the latest will be built upon: vaers_changes/2020-12-18_VAERS_CHANGES.csv vaers_changes/2020-12-25_VAERS_CHANGES.csv vaers_changes/2021-01-08_VAERS_CHANGES.csv vaers_changes/2021-01-15_VAERS_CHANGES.csv vaers_changes/2021-01-22_VAERS_CHANGES.csv ... 146 total = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = Next date 2023-11-24 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 2023-11-24 already consolidated, no need to copy input files to dir_working Creating in ./vaers_working/ date marker file 2023-11-24 Consolidation Consolidation already done: vaers_consolidated/2023-11-24_VAERS_CONSOLIDATED.csv Flattening Pulling vax records from previously consolidate file vaers_consolidated/2023-11-24_VAERS_CONSOLIDATED.csv open vaers_consolidated/2023-11-24_VAERS_CONSOLIDATED.csv ... Highest VAERS_ID 2717539 Aggregate/flatten VAX items. Grouping by VAERS_ID 1615017 rows in df_vax_flat Merging DATA into VAX flattened 1702258 rows in df_data_vax_flat 87241 duplicates dropped in df_data_vax_flat 1615017 rows in df_data_vax_flat Merging symptom_entries into df_data_vax_syms_flat 87241 duplicates dropped in df_data_vax_syms_flat Saving result into one file: vaers_flattened/2023-11-24_VAERS_FLATTENED.csv 1615017 rows in vaers_flattened/2023-11-24_VAERS_FLATTENED.csv Flattening of 2023-11-24 done open vaers_flattened/2023-10-27_VAERS_FLATTENED.csv ... Highest VAERS_ID 2703574 Using flat 2023-11-24 already in memory, 1615017 rows Previous changes file for changes, cell_edits and status columns open vaers_changes/2023-10-27_VAERS_CHANGES.csv ... Highest VAERS_ID 2703574 Comparing 2023-10-27 v. 2023-11-24 1615017 this drop total covid 1605759 previous total covid 1605426 identical set aside 9591 this drop to work with 333 previous to work with 9258 difference 9377 new in 2023-11-24 3 delayed this week 122 deleted this week kept 0 restored this week Column value changes AGE_YRS 1523235 [] <> 28.0 AGE_YRS 2404261 [] <> 30.0 CAGE_YR 1353885 76.0 <> 77.0 DATEDIED 1 cell of trivial non-letter differences ignored 1 duplicate dropped in df_three_columns 2 DIED [] <> Y [1071521, 1152373] HISTORY 1568423 on 26-Sep-2017 <> LAB_DATA 1837436 pissed <> ticked NUMDAYS 2660429 111.0 <> [] NUMDAYS 1353885 63.0 <> [] 28 duplicates dropped in df_three_columns 22 OTHER_MEDS [] <> HUMIRA [1299291, 1312884, 1514212, 1522294, 1613633, 1627191, 1773615, 1807502, 2057329, 2142821, 2183928, 2195926, 2237739, 2245440, 2297600, 2323772, 2371826, 2397522, 2410711, 2428425, 2457066, 2457804] OTHER_MEDS 1442634 [] <> JAKAFI OTHER_MEDS 1763425 [] <> NUCALA OTHER_MEDS 2284570 [] <> RINVOQ OTHER_MEDS 1162113 [] <> SUTENT OTHER_MEDS 1871076 [] <> ENTYVIO OTHER_MEDS 1304292 [] <> Eliquis OTHER_MEDS 1010686 [] <> LENVIMA OTHER_MEDS 1492774 [] <> SINEMET OTHER_MEDS 1835173 [] <> Trombyl 2 OTHER_MEDS [] <> Xeljanz [2056395, 2264363] OTHER_MEDS 1315079 [] <> DIANE-35 2 OTHER_MEDS [] <> DUPIXENT [1643835, 1962823] OTHER_MEDS 1381044 [] <> FIRDAPSE 2 OTHER_MEDS [] <> NOLVADEX [1475602, 1479308] OTHER_MEDS 1767502 [] <> PARAGARD OTHER_MEDS 2224627 [] <> SOLUPRED 3 OTHER_MEDS [] <> IMBRUVICA [1345838, 1453663, 1646817] OTHER_MEDS 2257613 [] <> RITUXIMAB OTHER_MEDS 2368721 [] <> TECFIDERA OTHER_MEDS 1488072 [] <> IXEKIZUMAB OTHER_MEDS 1356468 [] <> LOPRESOR R OTHER_MEDS 2360664 [] <> PERAMPANEL OTHER_MEDS 1859686 [] <> PREDNISONE OTHER_MEDS 1661165 [] <> XELJANZ XR OTHER_MEDS 2587658 [] <> MONTELUKAST OTHER_MEDS 2392081 [] <> Mepolizumab OTHER_MEDS 1561950 [] <> RISANKIZUMAB OTHER_MEDS 1140640 [] <> ACENOCOUMAROL 2 OTHER_MEDS ARAVA <> ARAVA; Inflectra [1972286, 1972287] OTHER_MEDS 1810970 <> LENVIMA OTHER_MEDS 1671215 <> OCREVUS OTHER_MEDS 2413055 <> IMBRUVICA OTHER_MEDS 1692473 <> BRILINTA OTHER_MEDS 1384191 <> LERGIGAN OTHER_MEDS 1820445 [] <> ALKS 4230; KEYTRUDA OTHER_MEDS 1597337 <> REMODULIN OTHER_MEDS 2522840 <> OCREVUS OTHER_MEDS 2109765 <> IBRANCE OTHER_MEDS 2457673 <> HUMIRA OTHER_MEDS 1447603 <> IMFINZI OTHER_MEDS 1839171 <> DUPIXENT OTHER_MEDS 2142811 <> PLEGRIDY OTHER_MEDS 2406781 [] <> SKYRIZI [RISANKIZUMAB] OTHER_MEDS 1426866 [] <> LEFLUNOMIDE; XELJANZ XR OTHER_MEDS 2038682 <> ABEMACICLIB OTHER_MEDS 1081381 <> YERVOY OPDIVO OTHER_MEDS 2555031 <> XELJANZ XR OTHER_MEDS 1724189 <> OCREVUS OTHER_MEDS 2156344 <> GAZYVARO OTHER_MEDS 2357348 <> TREPROSTINIL SODIUM OTHER_MEDS 1240821 <> FASLODEX CAELYX OTHER_MEDS 1345153 <> Eliquis OTHER_MEDS 1405287 <> DUPIXENT FOSAMAX OTHER_MEDS 1290505 [] <> Levonorgestrel, Ethinyl Estradiol OTHER_MEDS 1466360 <> DEPO-PROVERA OTHER_MEDS 1613987 <> VENETOCLAX IMBRUVICA OTHER_MEDS 1126487 <> KEYTRUDA OTHER_MEDS 1473013 [] <> PROGESTERONE; CERAZETTE [DESOGESTREL] OTHER_MEDS 1603417 <> TREPROSTINIL SODIUM OTHER_MEDS 1369900 <> XARELTO OTHER_MEDS 1584648 <> OCREVUS OTHER_MEDS 1447632 <> NPLATE OTHER_MEDS 1426066 [] <> VITAMIN C WITH ROSE HIPS; GARLIC EXTRACT OTHER_MEDS 1891537 <> OFEV OTHER_MEDS 2451517 <> OCREVUS OTHER_MEDS 1800119 <> Tafamidis Meglumine OTHER_MEDS 1767404 <> HUMIRA OTHER_MEDS 1882400 [] <> ORENCIA; PLAQUENIL [HYDROXYCHLOROQUINE SULFATE] OTHER_MEDS 2055201 <> OCREVUS OTHER_MEDS 1435903 <> IMBRUVICA OZEMPIC 2 OTHER_MEDS <> REMODULIN [1254721, 1603209] OTHER_MEDS 1949180 <> JANUVIA KARDEGIC OTHER_MEDS 2455128 <> OFATUMUMAB OCREVUS OTHER_MEDS 1508945 <> HUMIRA OTHER_MEDS 1249955 <> XULANE TRESIBA TYLENOL ARTHRITIS OTHER_MEDS 2171804 <> OCREVUS FENISTIL OTHER_MEDS 1285053 <> NEXAVAR OTHER_MEDS 1603369 <> ORENITRAM OTHER_MEDS 2456703 <> HUMIRA OTHER_MEDS 1161921 <> Apixaban OTHER_MEDS 1493116 <> IBRANCE OTHER_MEDS 1332975 <> HUMIRA OTHER_MEDS 2267961 <> OCREVUS OTHER_MEDS 2411414 <> OCREVUS OTHER_MEDS 1445767 <> HUMIRA OTHER_MEDS 2310824 <> OCREVUS OTHER_MEDS 1970832 <> Xeljanz XR OTHER_MEDS 2577582 <> OCREVUS OTHER_MEDS 1812463 <> XELJANZ OTHER_MEDS 2519038 <> OCREVUS OTHER_MEDS 2297615 <> DUOPA OTHER_MEDS 1478944 <> OCREVUS OTHER_MEDS 2304197 <> OCREVUS OTHER_MEDS 2236942 <> OCREVUS OTHER_MEDS 1614010 <> HUMIRA OTHER_MEDS 1453784 <> RINVOQ OTHER_MEDS 2291533 <> OCREVUS OTHER_MEDS 2230271 <> OCREVUS OTHER_MEDS 8/18 columns 100/112 rows OTHER_MEDS 2295165 <> OCREVUS BACLOFEN OTHER_MEDS 1301894 <> MYCOPHENOLIC ACID PREDNISOLONE TACROLIMUS OTHER_MEDS 2272629 <> ENALAPRIL AMLODIPINE RITUXIMAB OTHER_MEDS 1982497 <> ACETYLSALICYLIC ACID OFEV OTHER_MEDS 1757399 <> vit c D Vit E on 09/07/2021 received treatment for lymphoma--Rituximab 1400 mg subcutaneous OTHER_MEDS 1329522 <> CORTISONE IBUPROFEN JAKAFI OTHER_MEDS 1366866 <> DUOPA GOCOVRI OTHER_MEDS 1617889 <> HUMIRA OTHER_MEDS 1419546 <> ALXN2040 OTHER_MEDS 1902811 <> ARCOXIA OTHER_MEDS 1609766 <> HUMIRA OTHER_MEDS 1239489 <> BACTRIM OTHER_MEDS 1326414 <> MABTHERA; OCTAGAM; PRIVIGEN SYMPTOM_TEXT 2057437 Hispanic or Latino White US3622270 A Phase 3 Randomized Stratified Observer-Blind Placebo-Controlled Study to Evaluate Efficacy Safety Immunogenicity of SARS-CoV-2 Vaccine Adults Aged 18 Years Older mRNA-1273-P301 019745 <> study SYMPTOM_TEXT 2701883 <> AEFI-A-043909 SYMPTOM_TEXT 1812463 Accredo Xeljanz <> SYMPTOM_TEXT 2701702 <> NZ-Medsafe-152265 SYMPTOM_TEXT 2695685 925-313-4577 <> SYMPTOM_TEXT 2701882 number <> number:dAEFI-A-044195dd SYMPTOM_TEXT 2701881 <> AEFI-A-044190 SYMPTOM_TEXT 2701704 <> NZ-Medsafe-150362 SYMPTOM_TEXT 1872404 Hispanic or Latino White US3642334 A Phase 3 Randomized Stratified Observer-Blind Placebo-Controlled Study Evaluate Efficacy Safety Immunogenicity mRNA-1273 SARS-CoV-2 Vaccine Adults Aged 18 Years Older mRNA-1273-P301 <> SYMPTOM_TEXT 1970832 054550 <> SYMPTOM_TEXT 929473 Public Health Clinic/Veterans Administration <> SYMPTOM_TEXT 2042485 Canadian <> SYMPTOM_TEXT 1181264 Bridgeport <> SYMPTOM_TEXT 2371826 AbbVie <> SYMPTOM_TEXT 1269209 JCCT <> medical facility SYMPTOM_TEXT 1040736 Tom's <> Patient's SYMPTOM_TEXT 1568423 on 26-Sep-2017 <> SYMPTOM_TEXT 1327001 MUSC <> SYMPTOM_TEXT 2701884 <> AEFI-A-043911 SYMPTOM_TEXT 2701811 <> AEFI-A-039882 SYMPTOM_TEXT 2701909 <> AEFI-A-033506 SYMPTOM_TEXT 2701816 <> AEFI-A-039819 SYMPTOM_TEXT 2701823 <> AEFI-A-027944 SYMPTOM_TEXT 2701724 <> AEFI-A-032031 SYMPTOM_TEXT 2701718 <> AEFI-A-032206 SYMPTOM_TEXT 2701773 <> AEFI-A-039612 SYMPTOM_TEXT 2701854 <> AEFI-A-043697 SYMPTOM_TEXT 2701792 <> AEFI-A-013267 SYMPTOM_TEXT 2701822 <> AEFI-A-027924 SYMPTOM_TEXT 2701775 <> AEFI-A-039645 SYMPTOM_TEXT 2701880 <> AEFI-A-044149 SYMPTOM_TEXT 2701829 <> AEFI-A-028264 SYMPTOM_TEXT 2701858 <> AEFI-A-043890 SYMPTOM_TEXT 2701888 <> AEFI-A-044154 SYMPTOM_TEXT 2701830 <> AEFI-A-028270 SYMPTOM_TEXT 2701749 <> AEFI-A-027268 SYMPTOM_TEXT 2701932 <> AEFI-A-033420 SYMPTOM_TEXT 2701793 <> AEFI-A-013335 SYMPTOM_TEXT 2701807 <> AEFI-A-021078 SYMPTOM_TEXT 2701709 <> AEFI-A-012039 SYMPTOM_TEXT 2701945 <> AEFI-A-033990 SYMPTOM_TEXT 2701827 <> AEFI-A-027998 SYMPTOM_TEXT 2701787 <> AEFI-A-027754 SYMPTOM_TEXT 2701799 <> AEFI-A-013550 SYMPTOM_TEXT 2675516 from Australia <> SYMPTOM_TEXT 999162 Caucasian <> SYMPTOM_TEXT 1426066 <> This a spontaneous report from contactable consumer Patient reported for self A 68-year-old female patient received bnt162b2 PFIZER-BIONTECH COVID-19 mRNA VACCINE Formulation Solution injection Batch/Lot Number EL9261 first dose via intramuscular route of administration administered in right arm on 04Feb2021 at about 15:30 the age as single immunization ascorbic acid rosa canina VITAMIN C WITH ROSE HIPS ASCORBIC ACID;ROSA CANINA an unspecified Feb2020 number 1204BT017S Expiration Date Mar2023 and ongoing 1000 mg Vitamin with 25 Citrus Bioflavonoid Complex 1x/day immune enhancement therapy allium sativum oil petroselinum crispum GARLIC PARSLEY ALLIUM SATIVUM OIL;PETROSELINUM CRISPUM OIL 490131-05 Oct2022 1000mg equivalent capsule Patient's medical History family history relevant to adverse event was none tests were done Concomitant medications not Historical vaccine given previously include Flu shot 5 weeks ago Immunisation The did receive any other vaccines within 4 prior COVID events vaccination Pfizer considered suspect same date Suspect fine but wanted she had Vaccine Starting 20:30 onset light heart palpitations fast heartbeat that lasted 2 minutes She also slight dizzy feeling lay down 30-40 later maybe around 21:00-21:15 felt little bit 30 seconds-1.5 has anything since those no through night feels perfectly normal today noted have until after taken Rose Hips Garlic Second booster scheduled 25Feb2021 they advised her call 1 week before 3-week period verify appointment Adverse require visit emergency room or physician hospitalized Distributed by name provided address Lot Unknown 1204BT0175 certain if last letter S believes it outcome resolved SYMPTOM_TEXT 1329522 Incyte pharmacovigilance <> Regulatory Authority SYMPTOM_TEXT 2392081 Canadian Canada <> Authority SYMPTOM_TEXT 1618919 immunization Apr 27 2020 or <> was FEELING HEADACHE vaccination 27-Apr-2020 Unknown For provided SYMPTOM_TEXT 1561505 08-Nov-1950 <> Nov-1950 SYMPTOM_TEXT 1553200 27-Apr-1942 <> Apr-1942 SYMPTOM_TEXT 2652946 AZ <> SYMPTOM_TEXT 1426866 progra <> program SYMPTOM_TEXT 1466360 anaphylaktischen Schock <> SYMPTOM_TEXT 2264363 141003 <> SYMPTOM_TEXT 1756292 Accredo Inlyta Enhanced Patient Support Program MDO <> MD SYMPTOM_TEXT 1024996 A PHASE 1/2/3 PLACEBO-CONTROLLED RANDOMIZED OBSERVER-BLIND DOSE-FINDING STUDY TO EVALUATE THE SAFETY TOLERABILITY IMMUNOGENICITY AND EFFICACY OF SARS-COV-2 RNA VACCINE CANDIDATES AGAINST COVID-19 IN HEALTHY INDIVIDUALS <> SYMPTOM_TEXT 1051455 LP BUTANTAN-BRA GSP-PCP Pharmacovigilance Department Municipal Butantan Institute Organization-Uppsala Monitoring Centre WHO-UMC <> Regulatory Authority Organization WHO VAX_DATE 1 cell of trivial non-letter differences ignored VAX_DATE 1353885 11/14/2020 <> 11/14/2021 118 duplicates dropped in df_three_columns 2 VAX_DOSE_SERIES 1|1 <> 1 [1312884, 1613633] VAX_DOSE_SERIES 1366866 1|2|1 <> 1 41 VAX_DOSE_SERIES 1|UNK <> 1 [1081381, 1161921, 1254721, 1285053, 1332975, 1345838, 1445767, 1447603, 1466360, 1478944, 1479308, 1514212, 1522294, 1597337, 1603369, 1614010, 1617889, 1627191, 1643835, 1692473, 1773615, 1835173, 1859686, 1882400, 2057329, 2142811, 2142821, 2183928, 2195926, 2230271, 2237739, 2284570, 2323772, 2371826, 2406781, 2410711, 2428425, 2456703, 2457066, 2457673, 2457804] 4 VAX_DOSE_SERIES 1|UNK|UNK <> 1 [1329522, 1405287, 1613987, 1949180] VAX_DOSE_SERIES 1584648 2|1 <> 1 11 VAX_DOSE_SERIES UNK|1 <> 1 [1126487, 1239489, 1240821, 1384191, 1453784, 1473013, 1508945, 1603417, 1972286, 2224627, 2305641] 2 VAX_DOSE_SERIES UNK|1|UNK <> 1 [1902811, 2295165] VAX_DOSE_SERIES 1249955 UNK|1|UNK|UNK <> 1 VAX_DOSE_SERIES 1426066 UNK|UNK|1 <> 1 VAX_DOSE_SERIES 1447632 1|2 <> 2 17 VAX_DOSE_SERIES 2|UNK <> 2 [1315079, 1345153, 1419546, 1475602, 1561950, 1646817, 1724189, 1972287, 2055201, 2056395, 2245440, 2297600, 2304197, 2360664, 2411414, 2455128, 2519038] VAX_DOSE_SERIES 1426866 2|UNK|UNK <> 2 9 VAX_DOSE_SERIES UNK|2 <> 2 [1290505, 1369900, 1609766, 1763425, 1767404, 1990217, 2236942, 2272629, 2416742] VAX_DOSE_SERIES 1353094 UNK|2|UNK <> 2 VAX_DOSE_SERIES 1326414 UNK|UNK|2 <> 2 3 VAX_DOSE_SERIES 3|UNK <> 3 [1807502, 2109765, 2335564] 3 VAX_DOSE_SERIES 4|UNK <> 4 [2156344, 2257613, 2291533] VAX_DOSE_SERIES 2297615 3|UNK|2 <> 3|2 VAX_DOSE_SERIES 2522840 4|3|UNK <> 4|3 VAX_DOSE_SERIES 2038682 2|UNK <> UNK 33 VAX_DOSE_SERIES UNK|UNK <> UNK [1010686, 1140640, 1299291, 1301894, 1304292, 1316201, 1356468, 1381044, 1435903, 1442634, 1453663, 1488072, 1492774, 1493116, 1603209, 1661165, 1671215, 1767502, 1800119, 1810970, 1812463, 1820445, 1871076, 1891537, 1970832, 2264363, 2310824, 2357348, 2368721, 2397522, 2413055, 2451517, 2555031] 2 VAX_DOSE_SERIES UNK|UNK|UNK <> UNK [1982497, 2171804] 2 VAX_DOSE_SERIES 2|UNK|UNK <> 2|UNK [1962823, 2587658] VAX_DOSE_SERIES 2577582 4|UNK|UNK <> 4|UNK 2 VAX_DOSE_SERIES UNK|UNK|UNK <> UNK|UNK [2267961, 2392081] VAX_LOT 92 cells of trivial non-letter differences ignored 11 duplicates dropped in df_three_columns VAX_LOT 2195926 |1158135 <> [] VAX_LOT 2183928 |1158187 <> [] VAX_LOT 2428425 |1164842 <> [] VAX_LOT 1442634 |1232358 <> [] 2 VAX_LOT |2101734 <> [] [1254721, 1603209] VAX_LOT 2357348 |939656 <> [] VAX_LOT 1724189 |ASKED BUT UNKNO <> [] VAX_LOT 2109765 |ER4534 <> [] VAX_LOT 2555031 |FN4885 <> [] VAX_LOT 2230271 |H0020 <> [] VAX_LOT 2055201 |H0026B17 <> [] VAX_LOT 1356468 |LM9N66 <> [] VAX_LOT 1692473 |MNO148 <> [] 2 VAX_LOT |UNKNOWN <> [] [1478944, 2360664] 4 VAX_LOT |Unknown <> [] [2257613, 2291533, 2368721, 2519038] VAX_LOT 1405287 |Unknown|Unknown <> [] VAX_LOT 1613987 ||1134904 <> [] VAX_LOT 1329522 ||8235260 <> [] 2 VAX_LOT EJ6788|Unknown <> EJ6788 [1081381, 1315079] VAX_LOT 2397522 1161756|EL0142 <> EL0142 VAX_LOT 1426066 |490131-05|EL9261 <> EL9261 VAX_LOT 1249955 1391558|EN6201|KZFN101|PAA062 <> EN6201 VAX_LOT 1345153 EW6327|Unknown <> EW6327 VAX_LOT 1835173 EX8680|Unknown <> EX8680 VAX_LOT 1902811 |FA4598|Unknown <> FA4598 VAX_LOT 1617889 003A21A|1140749 <> 003A21A VAX_LOT 1353094 013M20A|1133816 <> 013M20A VAX_LOT 1332975 014M20A|1135269 <> 014M20A VAX_LOT 1445767 030LZ0A|1132361 <> 030LZ0A VAX_LOT 1614010 032L20A|1140750 <> 032L20A VAX_LOT 2156344 1F1009A|Unknown <> 1F1009A VAX_LOT 2245440 3005238|EFTERS K <> 3005238 VAX_LOT 1584648 ASKED BUT UNKNO|UNKNOWN <> UNKNOWN VAX_LOT 2392081 MB8G|UNK|UNK <> UNK|UNK VAX_LOT 2587658 UNK|UNK|UNK <> UNK|UNK VAX_LOT 2236942 UNKNOWN|Unknown <> Unknown 6 VAX_LOT Unknown|Unknown <> Unknown [1239489, 1369900, 1447632, 1479308, 2411414, 2455128] VAX_LOT 2295165 Unknown|Unknown <> Unknown VAX_LOT 2522840 UNKNOWN|UNKNOWN <> UNKNOWN VAX_LOT 2297615 030H21B|1158837|EL9269 <> 030H21B|EL9269 125 duplicates dropped in df_three_columns 38 VAX_MANU Moderna|Unknown <> Moderna [1285053, 1312884, 1332975, 1345838, 1435903, 1445767, 1466360, 1488072, 1561950, 1597337, 1603209, 1603369, 1613633, 1614010, 1617889, 1627191, 1643835, 1820445, 1882400, 1891537, 2109765, 2142811, 2142821, 2230271, 2245440, 2284570, 2297600, 2323772, 2335564, 2406781, 2410711, 2413055, 2428425, 2456703, 2457066, 2457673, 2457804, 2555031] 2 VAX_MANU Moderna|Unknown|Unknown <> Moderna [1405287, 1613987] 6 VAX_MANU Unknown|Moderna <> Moderna [1240821, 1301894, 1603417, 1609766, 1990217, 2038682] VAX_MANU 1353094 Unknown|Moderna|Unknown <> Moderna VAX_MANU 1366866 Unknown|Unknown|Moderna <> Moderna 54 VAX_MANU Pfizer-BionT|Unknown <> Pfizer-BionT [1010686, 1081381, 1140640, 1161921, 1254721, 1315079, 1316201, 1345153, 1356468, 1381044, 1419546, 1442634, 1447603, 1453663, 1475602, 1478944, 1479308, 1493116, 1514212, 1522294, 1646817, 1661165, 1671215, 1692473, 1724189, 1773615, 1800119, 1807502, 1810970, 1812463, 1835173, 1859686, 1970832, 1972287, 2055201, 2056395, 2057329, 2156344, 2183928, 2195926, 2237739, 2257613, 2264363, 2291533, 2304197, 2310824, 2357348, 2360664, 2368721, 2371826, 2411414, 2451517, 2455128, 2519038] 5 VAX_MANU Pfizer-BionT|Unknown|Unknown <> Pfizer-BionT [1329522, 1426866, 1949180, 1982497, 2171804] 24 VAX_MANU Unknown|Pfizer-BionT <> Pfizer-BionT [1126487, 1239489, 1290505, 1299291, 1304292, 1369900, 1384191, 1447632, 1453784, 1473013, 1492774, 1508945, 1584648, 1763425, 1767404, 1767502, 1871076, 1972286, 2224627, 2236942, 2272629, 2305641, 2397522, 2416742] 2 VAX_MANU Unknown|Pfizer-BionT|Unknown <> Pfizer-BionT [1902811, 2295165] VAX_MANU 1249955 Unknown|Pfizer-BionT|Unknown|Unknown <> Pfizer-BionT 2 VAX_MANU Unknown|Unknown|Pfizer-BionT <> Pfizer-BionT [1326414, 1426066] VAX_MANU 1962823 Moderna|Unknown|Unknown <> Moderna|Unknown VAX_MANU 2392081 Unknown|Unknown|Unknown <> Unknown|Unknown VAX_MANU 2587658 Glaxo|Pfizer-BionT|Unknown <> Glaxo|Pfizer-BionT VAX_MANU 2267961 Moderna|Pfizer-BionT|Unknown <> Moderna|Pfizer-BionT VAX_MANU 2297615 Moderna|Unknown|Pfizer-BionT <> Moderna|Pfizer-BionT VAX_MANU 2577582 Pfizer-BionT|Moderna|Unknown <> Pfizer-BionT|Moderna VAX_MANU 2522840 Pfizer-BionT|Unknown|Unknown <> Pfizer-BionT|Unknown 125 duplicates dropped in df_three_columns VAX_NAME 2267961 Pfizer-BionT|Not Specified NO BRAND NAME <> Pfizer-BionT VAX_NAME 1962823 NAME|Not Specified NO BRAND <> 38 VAX_NAME C19 Moderna|Not Specified NO BRAND NAME <> C19 Moderna [1285053, 1312884, 1332975, 1345838, 1435903, 1445767, 1466360, 1488072, 1561950, 1597337, 1603209, 1603369, 1613633, 1614010, 1617889, 1627191, 1643835, 1820445, 1882400, 1891537, 2109765, 2142811, 2142821, 2230271, 2245440, 2284570, 2297600, 2323772, 2335564, 2406781, 2410711, 2413055, 2428425, 2456703, 2457066, 2457673, 2457804, 2555031] VAX_NAME 2297615 C19 Moderna|Not Specified NO BRAND NAME|C19 Pfizer-BionT <> C19 Moderna|C19 Pfizer-BionT 2 VAX_NAME C19 Moderna|Not Specified NO BRAND NAME|Not Specified NO BRAND NAME <> C19 Moderna [1405287, 1613987] VAX_NAME 2577582 Moderna|Not Specified NO BRAND NAME <> Moderna VAX_NAME 2522840 UNKNOWN|Not Specified NO BRAND NAME <> UNKNOWN 54 VAX_NAME C19 Pfizer-BionT|Not Specified NO BRAND NAME <> C19 Pfizer-BionT [1010686, 1081381, 1140640, 1161921, 1254721, 1315079, 1316201, 1345153, 1356468, 1381044, 1419546, 1442634, 1447603, 1453663, 1475602, 1478944, 1479308, 1493116, 1514212, 1522294, 1646817, 1661165, 1671215, 1692473, 1724189, 1773615, 1800119, 1807502, 1810970, 1812463, 1835173, 1859686, 1970832, 1972287, 2055201, 2056395, 2057329, 2156344, 2183928, 2195926, 2237739, 2257613, 2264363, 2291533, 2304197, 2310824, 2357348, 2360664, 2368721, 2371826, 2411414, 2451517, 2455128, 2519038] 5 VAX_NAME C19 Pfizer-BionT|Not Specified NO BRAND NAME|Not Specified NO BRAND NAME <> C19 Pfizer-BionT [1329522, 1426866, 1949180, 1982497, 2171804] 6 VAX_NAME Not Specified NO BRAND NAME|C19 <> C19 [1240821, 1301894, 1603417, 1609766, 1990217, 2038682] VAX_NAME 1353094 Not Specified NO BRAND NAME|C19 Moderna|Not Specified NO BRAND NAME <> C19 Moderna 24 VAX_NAME Not Specified NO BRAND NAME|C19 <> C19 [1126487, 1239489, 1290505, 1299291, 1304292, 1369900, 1384191, 1447632, 1453784, 1473013, 1492774, 1508945, 1584648, 1763425, 1767404, 1767502, 1871076, 1972286, 2224627, 2236942, 2272629, 2305641, 2397522, 2416742] 2 VAX_NAME Not Specified NO BRAND NAME|C19 Pfizer-BionT|Not Specified NO BRAND NAME <> C19 Pfizer-BionT [1902811, 2295165] VAX_NAME 1249955 Not Specified NO BRAND NAME|C19 Pfizer-BionT|Not Specified NO BRAND NAME|Not Specified NO BRAND NAME <> C19 Pfizer-BionT VAX_NAME 2392081 Not Specified NO BRAND NAME|C19 <> C19 VAX_NAME 1366866 Not Specified NO BRAND NAME|Not NAME|C19 <> C19 2 VAX_NAME Not Specified NO BRAND NAME|Not NAME|C19 <> C19 [1326414, 1426066] VAX_NAME 2587658 Pfizer-BionT|Not Specified NO BRAND NAME <> Pfizer-BionT VAX_ROUTE 18 cells of trivial non-letter differences ignored 113 duplicates dropped in df_three_columns 3 VAX_ROUTE OT| <> [] [1384191, 1492774, 2305641] 19 VAX_ROUTE |OT <> [] [1161921, 1254721, 1316201, 1419546, 1442634, 1475602, 1479308, 1493116, 1661165, 1692473, 1800119, 1810970, 1812463, 1835173, 1970832, 2264363, 2291533, 2304197, 2357348] 4 VAX_ROUTE ||OT <> [] [1329522, 1426866, 1982497, 2171804] VAX_ROUTE 1249955 |||OT <> [] VAX_ROUTE 2392081 SC|IM| <> IM| VAX_ROUTE 2587658 IM|IM|PO <> IM|IM 84 VAX_ROUTE OT|OT <> OT [1081381, 1126487, 1239489, 1240821, 1285053, 1290505, 1299291, 1301894, 1304292, 1315079, 1332975, 1345153, 1345838, 1356468, 1369900, 1435903, 1445767, 1447603, 1447632, 1453784, 1466360, 1478944, 1488072, 1508945, 1514212, 1522294, 1561950, 1584648, 1597337, 1603209, 1603369, 1603417, 1609766, 1613633, 1614010, 1617889, 1627191, 1643835, 1646817, 1671215, 1724189, 1767404, 1807502, 1820445, 1871076, 1882400, 1891537, 1990217, 2038682, 2055201, 2057329, 2109765, 2142821, 2156344, 2183928, 2195926, 2224627, 2230271, 2236942, 2237739, 2245440, 2257613, 2272629, 2284570, 2297600, 2310824, 2323772, 2368721, 2371826, 2397522, 2406781, 2410711, 2411414, 2413055, 2416742, 2428425, 2451517, 2455128, 2456703, 2457066, 2457673, 2457804, 2519038, 2555031] 4 VAX_ROUTE OT|OT|OT <> OT [1353094, 1613987, 1902811, 2295165] 3 VAX_ROUTE OT||OT <> OT [1366866, 1405287, 1949180] VAX_ROUTE 1326414 |OT|OT <> OT 3 VAX_ROUTE OT|OT|OT <> OT|OT [1962823, 2267961, 2577582] VAX_ROUTE 2522840 ||OT <> | VAX_SITE 142 cells of trivial non-letter differences ignored VAX_SITE 2587658 ||MO <> | 132 duplicates dropped in df_three_columns 3 VAX_TYPE COVID19|COVID19|UNK <> COVID19|COVID19 [2267961, 2522840, 2577582] VAX_TYPE 1962823 COVID19|FLUX|UNK <> COVID19|FLUX 92 VAX_TYPE COVID19|UNK <> COVID19 [1010686, 1081381, 1140640, 1161921, 1254721, 1285053, 1312884, 1315079, 1316201, 1332975, 1345153, 1345838, 1356468, 1381044, 1419546, 1435903, 1442634, 1445767, 1447603, 1453663, 1466360, 1475602, 1478944, 1479308, 1488072, 1493116, 1514212, 1522294, 1561950, 1597337, 1603209, 1603369, 1613633, 1614010, 1617889, 1627191, 1643835, 1646817, 1661165, 1671215, 1692473, 1724189, 1773615, 1800119, 1807502, 1810970, 1812463, 1820445, 1835173, 1859686, 1882400, 1891537, 1970832, 1972287, 2055201, 2056395, 2057329, 2109765, 2142811, 2142821, 2156344, 2183928, 2195926, 2230271, 2237739, 2245440, 2257613, 2264363, 2284570, 2291533, 2297600, 2304197, 2310824, 2323772, 2335564, 2357348, 2360664, 2368721, 2371826, 2406781, 2410711, 2411414, 2413055, 2428425, 2451517, 2455128, 2456703, 2457066, 2457673, 2457804, 2519038, 2555031] VAX_TYPE 2297615 COVID19|UNK|COVID19 <> COVID19|COVID19 7 VAX_TYPE COVID19|UNK|UNK <> COVID19 [1329522, 1405287, 1426866, 1613987, 1949180, 1982497, 2171804] 30 VAX_TYPE UNK|COVID19 <> COVID19 [1126487, 1239489, 1240821, 1290505, 1299291, 1301894, 1304292, 1369900, 1384191, 1447632, 1453784, 1473013, 1492774, 1508945, 1584648, 1603417, 1609766, 1763425, 1767404, 1767502, 1871076, 1972286, 1990217, 2038682, 2224627, 2236942, 2272629, 2305641, 2397522, 2416742] 3 VAX_TYPE UNK|COVID19|UNK <> COVID19 [1353094, 1902811, 2295165] VAX_TYPE 2392081 UNK|COVID19|UNK <> COVID19|UNK VAX_TYPE 1249955 UNK|COVID19|UNK|UNK <> COVID19 3 VAX_TYPE UNK|UNK|COVID19 <> COVID19 [1326414, 1366866, 1426066] VAX_TYPE 2587658 VARZOS|COVID19|UNK <> VARZOS|COVID19 1 duplicate dropped in df_three_columns 2 symptom_entries _|_Unevaluable event_|_ <> _|_Incorrect dose administered_|_ [2701525, 2701596] symptom_entries 1499976 _|_Death_|_ <> symptom_entries 1606472 _|_SARS-CoV-2 test_|_ <> symptom_entries 1499939 _|_Dysarthria_|_ <> symptom_entries 1499934 _|_Vomiting_|_ <> symptom_entries 1609661 _|_Product dose omission issue_|_ <> symptom_entries 1521979 _|_Pyrexia_|_ <> 18 columns altered 31730 modified reports on 2023-11-24 Writing ... vaers_changes/2023-11-24_VAERS_CHANGES.csv 1 report with the most (18) records/lots/doses: 1900339 1 comparison done Doing stats open stats.csv ... ok column changes: {'VAX_NAME': 143, 'VAX_DOSE_SERIES': 143, 'VAX_TYPE': 143, 'VAX_MANU': 143, 'OTHER_MEDS': 140, 'VAX_ROUTE': 125, 'SYMPTOM_TEXT': 59, 'VAX_LOT': 51, 'symptom_entries': 8, 'NUMDAYS': 2, 'DIED': 2, 'AGE_YRS': 2, 'VAX_DATE': 1, 'VAX_SITE': 1, 'HISTORY': 1, 'LAB_DATA': 1, 'CAGE_YR': 1, 'CUR_ILL': 0, 'SEX': 0, 'ONSET_DATE': 0, 'BIRTH_DEFECT': 0, 'DISABLE': 0, 'ER_VISIT': 0, 'PRIOR_VAX': 0, 'SPLTTYPE': 0, 'ER_ED_VISIT': 0, 'RPT_DATE': 0, 'OFC_VISIT': 0, 'V_ADMINBY': 0, 'CAGE_MO': 0, 'L_THREAT': 0, 'HOSPITAL': 0, 'X_STAY': 0, 'DATEDIED': 0, 'FORM_VERS': 0, 'HOSPDAYS': 0, 'ALLERGIES': 0, 'V_FUNDBY': 0, 'STATE': 0, 'TODAYS_DATE': 0, 'RECVDATE': 0, 'RECOVD': 0} This week 3 delayed/late/gapfill 122 deleted 0 restored 254 cell edits trivial not printed 966 cell edits significant 52 cells emptied entirely 59 writeups changed All time 542239 delayed/late/gapfill 31657 deleted 16 restored 29372525 cell edits trivial not printed 31939 cell edits significant 1475777 cells emptied entirely 7651 writeups changed 32130 never published [896713, 896742, 896875, 896892, 896899, 897093, 897105, 897169 ... 2717423, 2717427, 2717428, 2717474, 2717475, 2717533, 2717534, 2717535] 20 reports cleared of duplicate sentences within them 0 hr 11.8 min This week None 0 hr 11.8 min Overall None Saving vaers_changes/2023-11-24_VAERS_CHANGES_A.csv, 1048575 rows and vaers_changes/2023-11-24_VAERS_CHANGES_B.csv, 598083 rows No more to do, last set 2023-11-24 >= 2023-11-24 done 0 hr 13.6 min Done with vaers_flatfile_build.py at line 2375, clock time 2023-12-06 12:26:31.586756 - - - - - - - - - - - - - - - - - - - - - - - -