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-12-29_AllVAERSDataCSVS.zip Already processed files do appear in vaers_flatfile and the latest will be built upon: vaers_flatfile/2020-12-18_VAERS_CHANGES.csv vaers_flatfile/2020-12-25_VAERS_CHANGES.csv vaers_flatfile/2021-01-08_VAERS_CHANGES.csv vaers_flatfile/2021-01-15_VAERS_CHANGES.csv vaers_flatfile/2021-01-22_VAERS_CHANGES.csv ... 147 total = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = Next date 2023-12-29 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = unzip ../Download/ALL_VAERS_DROPS/2023-12-29_AllVAERSDataCSVS.zip Creating in ./vaers_working/ date marker file 2023-12-29 Consolidation Concatenating files, *VAERSDATA.csv, *VAERSVAX.csv, *VAERSSYMPTOMS.csv open vaers_working\2020VAERSDATA.csv ... Highest VAERS_ID 2710003 open vaers_working\2021VAERSDATA.csv ... Highest VAERS_ID 2681134 open vaers_working\2022VAERSDATA.csv ... Highest VAERS_ID 2719848 open vaers_working\2023VAERSDATA.csv ... Highest VAERS_ID 2728414 open vaers_working\NonDomesticVAERSDATA.csv ... Highest VAERS_ID 2728409 open vaers_working\2020VAERSVAX.csv ... Highest VAERS_ID 2710003 open vaers_working\2021VAERSVAX.csv ... Highest VAERS_ID 2681134 open vaers_working\2022VAERSVAX.csv ... Highest VAERS_ID 2719848 open vaers_working\2023VAERSVAX.csv ... Highest VAERS_ID 2728414 open vaers_working\NonDomesticVAERSVAX.csv ... Highest VAERS_ID 2728409 4903 exact duplicates dropped in concatenated files, now 2080171 rows open vaers_working\2020VAERSSYMPTOMS.csv ... Highest VAERS_ID 2710003 open vaers_working\2021VAERSSYMPTOMS.csv ... Highest VAERS_ID 2681134 open vaers_working\2022VAERSSYMPTOMS.csv ... Highest VAERS_ID 2719848 open vaers_working\2023VAERSSYMPTOMS.csv ... Highest VAERS_ID 2728414 open vaers_working\NonDomesticVAERSSYMPTOMS.csv ... Highest VAERS_ID 2728409 133355 records removed prior to the first covid report (covid_earliest_vaers_id 896636) 1766344 reports to work with (unique VAERS_IDs) lo_ever 896636 hi_all_never_published 2717535 hi_this_week 2728414 week_vids_present [2709998, 2709999, 2710000, 2710001, 2710002, 2710003, 2709997, 2679890 ... 2728287, 2728288, 2728289, 2728372, 2728373, 2728374, 2728408, 2728409] list_range_all_ever [896636, 896637, 896638, 896639, 896640, 896641, 896642, 896643 ... 2728407, 2728408, 2728409, 2728410, 2728411, 2728412, 2728413, 2728414] list_range_week_only [2717536, 2717537, 2717538, 2717539, 2717540, 2717541, 2717542, 2717543 ... 2728407, 2728408, 2728409, 2728410, 2728411, 2728412, 2728413, 2728414] gaps_filled [2714613, 2716015, 2716712, 2716714, 2716715, 2716716, 2716717, 2716718 ... 2717422, 2717423, 2717427, 2717428, 2717474, 2717475, 2717534, 2717535] week_gaps_new [2717618, 2717620, 2717713, 2717755, 2717807, 2717838, 2717864, 2717867 ... 2728266, 2728267, 2728268, 2728269, 2728293, 2728296, 2728404, 2728406] remedied_past_all_never_published [896713, 896742, 896875, 896892, 896899, 897093, 897105, 897169 ... 2716727, 2716728, 2716730, 2717006, 2717033, 2717039, 2717388, 2717533] all_never_published [896713, 896742, 896875, 896892, 896899, 897093, 897105, 897169 ... 2728266, 2728267, 2728268, 2728269, 2728293, 2728296, 2728404, 2728406] VAERS_IDs 896637 to 2728414 expected 1831779 all_ever 1799589 gaps 32222 2833 additional reports captured with Pfizer|Moderna|Janssen in SYMPTOM_TEXT although not officially type COVID 88153 duplicates dropped in df_data on VAERS_IDs 1623950 covid reports to work with Repeat sentence removal in SYMPTOM_TEXT, showing each next larger if any (takes time) 2860 SYMPTOM_TEXT field repeat sentences deduped in 556 reports, max difference 2238 bytes in VAERS_ID 2019140 Shortening some field values in VAX_NAME, VAX_MANU Merging DATA into VAX 1892902 rows in df_data_vax Aggregating symptoms into symptom_entries string, new column Combining symptoms column items. Grouping by VAERS_ID ... Appending each symptom in new column called symptom_entries Cleaning multiple delimiters due to empty columns Merging symptom_entries into df_data_vax 1892902 rows in df_data_vax_syms_consolidated Saving result into one file: vaers_consolidated/2023-12-29_VAERS_CONSOLIDATED.csv Consolidation of 2023-12-29 done 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-12-29_AllVAERSDataCSVS.zip Already processed files do appear in vaers_flatfile and the latest will be built upon: vaers_flatfile/2020-12-18_VAERS_CHANGES.csv vaers_flatfile/2020-12-25_VAERS_CHANGES.csv vaers_flatfile/2021-01-08_VAERS_CHANGES.csv vaers_flatfile/2021-01-15_VAERS_CHANGES.csv vaers_flatfile/2021-01-22_VAERS_CHANGES.csv ... 147 total = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = Next date 2023-12-29 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 2023-12-29 already consolidated, no need to copy input files to dir_working Creating in ./vaers_working/ date marker file 2023-12-29 Consolidation Consolidation already done: vaers_consolidated/2023-12-29_VAERS_CONSOLIDATED.csv Flattening Pulling vax records from previously consolidate file vaers_consolidated/2023-12-29_VAERS_CONSOLIDATED.csv open vaers_consolidated/2023-12-29_VAERS_CONSOLIDATED.csv ... Highest VAERS_ID 2728414 Aggregate/flatten VAX items. Grouping by VAERS_ID 1623950 rows in df_vax_flat Merging DATA into VAX flattened 1712606 rows in df_data_vax_flat 88656 duplicates dropped in df_data_vax_flat 1623950 rows in df_data_vax_flat Merging symptom_entries into df_data_vax_syms_flat 88656 duplicates dropped in df_data_vax_syms_flat Saving result into one file: vaers_flattened/2023-12-29_VAERS_FLATTENED.csv 1623950 rows in vaers_flattened/2023-12-29_VAERS_FLATTENED.csv Flattening of 2023-12-29 done open vaers_flattened/2023-11-24_VAERS_FLATTENED.csv ... Highest VAERS_ID 2717539 Using flat 2023-12-29 already in memory, 1623950 rows Previous changes file for changes, cell_edits and status columns open vaers_flatfile/2023-11-24_VAERS_FLATFILE.csv ... Highest VAERS_ID 2717539 Comparing 2023-11-24 v. 2023-12-29 1623950 this drop total covid 1615017 previous total covid 0 identical set aside 1623950 this drop to work with 1615017 previous to work with 8933 difference 6293 new in 2023-12-29 2907 delayed this week 267 deleted this week kept 0 restored this week Column value changes STOP HAVE TO FIX DATES, FORMATS FOR COMPARE SANITY; 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-12-29_AllVAERSDataCSVS.zip Already processed files do appear in vaers_flatfile and the latest will be built upon: vaers_flatfile/2020-12-18_VAERS_CHANGES.csv vaers_flatfile/2020-12-25_VAERS_CHANGES.csv vaers_flatfile/2021-01-08_VAERS_CHANGES.csv vaers_flatfile/2021-01-15_VAERS_CHANGES.csv vaers_flatfile/2021-01-22_VAERS_CHANGES.csv ... 147 total = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = Next date 2023-12-29 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 2023-12-29 already consolidated, no need to copy input files to dir_working Creating in ./vaers_working/ date marker file 2023-12-29 Consolidation Consolidation already done: vaers_consolidated/2023-12-29_VAERS_CONSOLIDATED.csv Flattening Flattening already done: vaers_flattened/2023-12-29_VAERS_FLATTENED.csv open vaers_flattened/2023-11-24_VAERS_FLATTENED.csv ... Highest VAERS_ID 2717539 open vaers_flattened/2023-12-29_VAERS_FLATTENED.csv ... Highest VAERS_ID 2728414 Previous changes file for changes, cell_edits and status columns open vaers_flatfile/2023-11-24_VAERS_FLATFILE.csv ... Highest VAERS_ID 2717539 Comparing 2023-11-24 v. 2023-12-29 1623950 this drop total covid 1615017 previous total covid 0 identical set aside 1623950 this drop to work with 1615017 previous to work with 8933 difference 6293 new in 2023-12-29 2907 delayed this week 267 deleted this week kept 0 restored this week Column value changes AGE_YRS 2286465 34.0 <> 33.0 DATEDIED 2519770 [] <> 2021-02-06 DATEDIED 2510468 [] <> 2021-06-26 DATEDIED 1704294 [] <> 2021-09-28 DATEDIED 2243468 [] <> 2021-11-13 DATEDIED 2119420 [] <> 2022-02-20 2 duplicates dropped in df_three_columns 3 DIED [] <> Y [1704294, 2119420, 2243468] DIED 1665441 Y <> [] HISTORY 1342666 pact <> past LAB_DATA 1205821 HH <> LAB_DATA 964415 Vidant Medical <> LAB_DATA 1342666 EIC <> EKG OTHER_MEDS 2 cells of trivial non-letter differences ignored 54 duplicates dropped in df_three_columns OTHER_MEDS 1802068 [] <> OFEV OTHER_MEDS 1577296 [] <> WARAN 4 OTHER_MEDS [] <> ENBREL [1992906, 2245679, 2578709, 2675509] OTHER_MEDS 1767785 [] <> Enbrel 2 OTHER_MEDS [] <> HALDOL [1717717, 1852926] 30 OTHER_MEDS [] <> HUMIRA [1269276, 1326177, 1483322, 1608828, 1609771, 1610763, 1612467, 1613625, 1632157, 1896399, 2057292, 2195930, 2286736, 2319969, 2319985, 2355969, 2362211, 2362213, 2399645, 2401159, 2419046, 2427361, 2448970, 2451706, 2456698, 2456702, 2456729, 2457080, 2457554, 2458347] OTHER_MEDS 2324651 [] <> JULUCA OTHER_MEDS 1812446 [] <> KEPPRA OTHER_MEDS 1664956 [] <> KIOVIG OTHER_MEDS 2129019 [] <> LUDEAL OTHER_MEDS 1012090 [] <> Lyrica 3 OTHER_MEDS [] <> MIRENA [1199751, 1369517, 1369756] OTHER_MEDS 2409135 [] <> NUCALA OTHER_MEDS 2652564 [] <> Nucala OTHER_MEDS 1915530 [] <> ORUDIS 2 OTHER_MEDS [] <> RINVOQ [1639537, 2284510] OTHER_MEDS 1809969 [] <> VIAGRA 3 OTHER_MEDS [] <> AUBAGIO [1514284, 1524932, 1593989] OTHER_MEDS 1283894 [] <> ELIGARD OTHER_MEDS 2214992 [] <> ELIQUIS OTHER_MEDS 1987557 [] <> Eliquis OTHER_MEDS 1980317 [] <> GILENYA OTHER_MEDS 1381306 [] <> IBRANCE 2 OTHER_MEDS [] <> Ibrance [1463292, 1800535] OTHER_MEDS 1908798 [] <> JAYDESS OTHER_MEDS 1497096 [] <> NOVOFEM OTHER_MEDS 2164220 [] <> OCREVUS OTHER_MEDS 1600035 [] <> OTREXUP OTHER_MEDS 1769099 [] <> REMSIMA OTHER_MEDS 1790871 [] <> TYLENOL OTHER_MEDS 2407469 [] <> TYSABRI 2 OTHER_MEDS [] <> XELJANZ [1958043, 2078878] 2 OTHER_MEDS [] <> CLOZARIL [1245944, 1466289] 2 OTHER_MEDS [] <> COPAXONE [980695, 2245065] OTHER_MEDS 1847717 [] <> Cosentyx OTHER_MEDS 1406029 [] <> DUPIXENT 2 OTHER_MEDS [] <> METOJECT [1671416, 1763596] OTHER_MEDS 1941302 [] <> PROPECIA OTHER_MEDS 1917661 [] <> BETAFERON OTHER_MEDS 1455203 [] <> DENOSUMAB OTHER_MEDS 1622519 [] <> DUPILUMAB OTHER_MEDS 2400725 [] <> NEXPLANON OTHER_MEDS 1567395 [] <> ORENITRAM OTHER_MEDS 1076752 [] <> RESTYLANE 3 OTHER_MEDS [] <> Rituximab [2310990, 2365535, 2367022] OTHER_MEDS 2327918 [] <> TECFIDERA OTHER_MEDS 2451528 [] <> COPPER IUD OTHER_MEDS 2136511 [] <> LINDYNETTE 6 OTHER_MEDS [] <> XELJANZ XR [1150879, 1173784, 1305635, 1373793, 1384502, 2268497] OTHER_MEDS 1792920 [] <> Xeljanz XR OTHER_MEDS 2024302 [] <> ALEMTUZUMAB OTHER_MEDS 2069735 [] <> OCRELIZUMAB OTHER_MEDS 2449835 [] <> ENZALUTAMIDE OTHER_MEDS 2476442 [] <> Methotrexate 2 OTHER_MEDS [] <> ACETILCISTEINA [2156004, 2163760] OTHER_MEDS 1437196 [] <> AVONEX; FAMPYRA OTHER_MEDS 2217785 <> TYVASO OTHER_MEDS 1517755 [] <> BACTRIM; TAFINLAR OTHER_MEDS 1352030 [] <> DOXORUBICINE TEVA OTHER_MEDS 1182758 <> REMODULIN OTHER_MEDS 2458317 [] <> RINVOQ; PREDNISONE OTHER_MEDS 1149882 [] <> Methotrexate Sodium OTHER_MEDS 1398351 <> PRADAXA OTHER_MEDS 1996794 [] <> TREPROSTINIL SODIUM OTHER_MEDS 1533153 <> MIRENA 2 OTHER_MEDS [] <> METOPROLOL; DUPIXENT [1626955, 1626961] 2 OTHER_MEDS <> TYSABRI [2172255, 2174542] OTHER_MEDS 1791045 <> ORENITRAM OTHER_MEDS 1375217 <> Palbociclib OTHER_MEDS 1045089 <> CERAZETTE OTHER_MEDS 2457601 [] <> SKYRIZI [RISANKIZUMAB] OTHER_MEDS 2286801 <> STELARA OTHER_MEDS 1459207 <> XELJANZ XR OTHER_MEDS 2016982 OMECAT <> OMECAT; AJOVY; TAMOXIFEN OTHER_MEDS 1173457 [] <> ATACAND; AMLODIPIN SANDOZ OTHER_MEDS 1969999 <> WARFARIN OTHER_MEDS 2266275 <> REBIF OTHER_MEDS 1584736 <> DROSURE DIARIO OTHER_MEDS 1472913 [] <> NAPROSYN [NAPROXEN SODIUM OTHER_MEDS 2003687 <> OCREVUS OTHER_MEDS 2125212 <> IMURAN OTHER_MEDS 2587994 [] <> METOCLOPRAMIDE; DEXAMETHASONE OTHER_MEDS 1547095 [] <> FLECAINIDE; PRADAXA; VERAPAMIL OTHER_MEDS 2500872 <> OCREVUS OTHER_MEDS 2518320 <> OCREVUS OTHER_MEDS 1510571 <> YASMIN OTHER_MEDS 1810278 <> TYVASO OTHER_MEDS 2069760 <> ABEMACICLIB OTHER_MEDS 1316368 <> HUMIRA OTHER_MEDS 1401708 [] <> UBLITUXIMAB; UMBRALISIB; VENETOCLAX OTHER_MEDS 1776011 <> OCALIVA OTHER_MEDS 1683228 <> Botox for migraine OTHER_MEDS 2408860 <> OCREVUS OTHER_MEDS 2334359 <> LEVETIRACETAM PUREN OTHER_MEDS 2150695 <> ORENITRAM OTHER_MEDS 2124841 <> CELLCEPT MYCOPHENOLATE MOFETIL OTHER_MEDS 1240799 <> TRUXIMA OTHER_MEDS 6/15 columns 100/177 rows OTHER_MEDS 1827443 <> DUPIXENT OTHER_MEDS 1609356 <> HUMIRA Methotrexate OTHER_MEDS 1707669 <> XELJANZ OTHER_MEDS 1315815 <> FIRDAPSE OTHER_MEDS 1480092 <> ACENOCOUMAROL OTHER_MEDS 1609783 <> HUMIRA OTHER_MEDS 2521768 <> Mepolizumab OTHER_MEDS 2003686 <> MABTHERA CORTISONE IBUPROFEN FENISTIL OTHER_MEDS 1539133 <> VOTUBIA OTHER_MEDS 1874214 <> SOFOSBUVIR;VELPATASVIR LEVOMETHADONE OTHER_MEDS 1113144 <> LEPTOPROL BICALUTAMIDE OTHER_MEDS 1206899 <> TREPROSTINIL DIOLAMIN ADEMPAS ORENITRAM OTHER_MEDS 1119955 <> KLOR-CON M10 OTHER_MEDS 2242264 [] <> CELLCEPT [MYCOPHENOLATE MOFETIL]; ADVAGRAF; CORTANCYL OTHER_MEDS 1378944 <> KARDEGIC PREVISCAN OTHER_MEDS 1465444 <> LIPTRUZET OTHER_MEDS 1841299 <> OMEPRAZOL 2 OTHER_MEDS <> AUBAGIO [2234743, 2236547] OTHER_MEDS 2104442 <> TREPROSTINIL SODIUM OTHER_MEDS 2454993 <> SOLARIS OTHER_MEDS 1603026 <> TREPROSTINIL SODIUM OTHER_MEDS 1135367 <> LENVIMA OTHER_MEDS 1957297 <> MERCAZOLE THIAMAZOLE OTHER_MEDS 1241518 <> LOVENOX ENOXAPARIN SODIUM OTHER_MEDS 2576717 <> PARIET OTHER_MEDS 1248619 <> ACENOCOUMAROL OTHER_MEDS 1455082 <> LORATADINA CINFA OTHER_MEDS 1902444 [] <> SERTRALINE; ESCITALOPRAM NEURAXPHARM; PROMETHAZIN NEURAXPHARM; ASA OTHER_MEDS 1276141 <> FIRMAGON OTHER_MEDS 1656744 <> Rituximab OTHER_MEDS 2186511 <> FENISTIL CORTISONE OCREVUS OTHER_MEDS 1490045 <> GOCOVRI OTHER_MEDS 2430499 <> OCREVUS OTHER_MEDS 2582078 <> OCREVUS SATIVEX OTHER_MEDS 1417640 <> OPDIVO OTHER_MEDS 1213664 <> QUETIAPINE AXURA OTHER_MEDS 1492772 <> MELATONIN PROPAVAN TRUXAL CHLORPROTHIXENE MIRTAZAPIN ACTAVIS OTHER_MEDS 1364332 <> MARCOUMAR OTHER_MEDS 2236943 <> OCREVUS OTHER_MEDS 1907373 <> ANASTROZOLE OTHER_MEDS 1711593 <> RINVOQ OTHER_MEDS 1926408 <> CORTANCYL TRUXIMA OTHER_MEDS 1618844 <> IMBRUVICA OTHER_MEDS 2040843 <> IMBRUVICA OTHER_MEDS 2412181 <> OCRELIZUMAB OTHER_MEDS 2319387 <> OCREVUS OTHER_MEDS 1516231 <> Solu-Medrol MABTHERA OTHER_MEDS 2178677 <> ELAPRASE OTHER_MEDS 2537096 <> SINTROM ADIRO OTHER_MEDS 1561953 <> HUMIRA OTHER_MEDS 1479286 <> Methotrexate Sodium PREDNISONE BENEPALI OTHER_MEDS 1515899 <> IMRALDI OTHER_MEDS 1893288 <> XELJANZ XR OTHER_MEDS 2448354 <> IMBRUVICA OTHER_MEDS 1037667 <> PLAVIX OTHER_MEDS 1338273 <> ZIRABEV OTHER_MEDS 2430478 <> OCREVUS OTHER_MEDS 1598737 <> HUMIRA OTHER_MEDS 1937233 <> SOLIRIS OTHER_MEDS 1606111 <> JAKAFI OTHER_MEDS 2274573 <> OXLUMO OTHER_MEDS 1612112 <> JAKAFI OTHER_MEDS 1319554 <> DOXAZOSIN MESILATE OTHER_MEDS 2468865 <> OCREVUS OTHER_MEDS 1260715 <> TACROLIMUS MONOHYDRATE OTHER_MEDS 2457193 <> DUPIXENT OTHER_MEDS 2468866 <> PREDNISOLONE OCREVUS OTHER_MEDS 2374183 <> OCREVUS OTHER_MEDS 1640002 <> HUMIRA OTHER_MEDS 1189319 <> ELIQUIS OTHER_MEDS 1106064 <> LEVODOPA/CARBIDOPA ROPINIROLE RIVASTIGMINE OTHER_MEDS 2439027 <> Quetiapine OTHER_MEDS 1245747 <> Eliquis LOVENOX ENOXAPARIN SODIUM OTHER_MEDS 2459251 <> HUMIRA OTHER_MEDS 2433240 <> APREMILAST OTHER_MEDS 1878172 <> RIVOTRIL ARTANE TRIHEXYPHENIDYL HYDROCHLORIDE SCOPODERM HYOSCINE MELATONINE PHOSPHONEUROS BACLOFENE PANTOPRAZOLE OTHER_MEDS 2521267 <> BRONCHO-VAXOM; RISPERDAL OTHER_MEDS 1388735 <> HUMIRA; PROPO SYMPTOM_TEXT 1342666 C/o Arrival <> Arrived SYMPTOM_TEXT 1237536 McDonald?s <> SYMPTOM_TEXT 1102403 09/04/1946 <> SYMPTOM_TEXT 1864375 Phase 3 Randomized Stratified Observer-Blind Placebo-Controlled <> SYMPTOM_TEXT 1987474 053501 <> SYMPTOM_TEXT 2334791 BIONTECHTR SE <> BIONTECH SYMPTOM_TEXT 1150879 Program <> SYMPTOM_TEXT 1970366 white <> SYMPTOM_TEXT 2361284 ST <> SYMPTOM_TEXT 2282517 PHIFDA <> Agency SYMPTOM_TEXT 2560506 Canadian Vista <> SYMPTOM_TEXT 1483322 USA <> SYMPTOM_TEXT 1100296 Pfizer First Connect <> SYMPTOM_TEXT 2498859 Veteran <> Patient SYMPTOM_TEXT 2590757 E2B Linked Report <> SYMPTOM_TEXT 2587171 E2B Linked Report Patient D-Y <> SYMPTOM_TEXT 2587172 E2B Linked Report Patient D-Y <> SYMPTOM_TEXT 2583891 E2B Linked Report <> SYMPTOM_TEXT 2571346 E2B Linked Report <> SYMPTOM_TEXT 2510978 of MD <> SYMPTOM_TEXT 1282561 1/25/21 <> 1/XX/21 SYMPTOM_TEXT 1893101 Solution COVAES <> sysytem SYMPTOM_TEXT 1628622 Dept/Mgr Transplant EE 52031 <> Patient patient DOH employer SYMPTOM_TEXT 1068154 Clinic/Veterans Administration <> Clinic/Administration SYMPTOM_TEXT 1919691 AbbVie <> SYMPTOM_TEXT 2422834 etc are administration 8-week <> were we into CDC Department Public Health is has by me week SYMPTOM_TEXT 2254066 non Hispanic or Latino old white male <> oldmale SYMPTOM_TEXT 964415 in Colorado North Carolina <> SYMPTOM_TEXT 2147886 PHIFDA <> Agency SYMPTOM_TEXT 1459207 Accredo Xeljanz Program <> SYMPTOM_TEXT 1992906 PSP00073 <> SYMPTOM_TEXT 1941302 5570 <> SYMPTOM_TEXT 1957297 for protocol C4591006 on 26Nov2021 <> SYMPTOM_TEXT 2078878 000544 ANMAT <> SYMPTOM_TEXT 2513667 Program ID 005570 <> SYMPTOM_TEXT 2527601 Nucala Vista <> SYMPTOM_TEXT 1646761 Giant Harris Teeter China <> store there SYMPTOM_TEXT 2161070 159558 <> 216 duplicates dropped in df_three_columns VAX_DOSE_SERIES 1609771 1|1 <> 1 56 VAX_DOSE_SERIES 1|UNK <> 1 [1106064, 1149882, 1150879, 1173784, 1182758, 1240799, 1248619, 1260715, 1276141, 1283894, 1305635, 1315815, 1319554, 1326177, 1338273, 1384502, 1401708, 1417640, 1437196, 1439584, 1450833, 1490045, 1514284, 1517755, 1547095, 1598737, 1603026, 1606111, 1608828, 1610763, 1612112, 1612467, 1711593, 1802068, 1896399, 2178677, 2236547, 2286801, 2319387, 2319969, 2319985, 2355969, 2362211, 2362213, 2401159, 2427361, 2430499, 2449835, 2456698, 2457554, 2457601, 2458347, 2459251, 2468865, 2518320, 2521267] 3 VAX_DOSE_SERIES 1|UNK|UNK <> 1 [1189319, 1626955, 1626961] VAX_DOSE_SERIES 1206899 1|UNK|UNK|UNK <> 1 VAX_DOSE_SERIES 1342666 UNK <> 1 25 VAX_DOSE_SERIES UNK|1 <> 1 [1037667, 1045089, 1241518, 1369517, 1455082, 1472913, 1480092, 1510571, 1533153, 1584736, 1609356, 1609783, 1640002, 1790871, 1809969, 1812446, 1841299, 1908798, 1915530, 1969999, 2016982, 2163760, 2174542, 2214992, 2448970] 2 VAX_DOSE_SERIES UNK|1|UNK <> 1 [1173457, 2310990] VAX_DOSE_SERIES 2419046 1|3|UNK <> 1|3 46 VAX_DOSE_SERIES 2|UNK <> 2 [1135367, 1213664, 1316368, 1375217, 1455203, 1459207, 1479286, 1483322, 1497096, 1515899, 1524932, 1577296, 1593989, 1613625, 1639537, 1671416, 1763596, 1776011, 1810278, 1852926, 1902444, 1941302, 1980317, 2003687, 2040843, 2057292, 2069735, 2164220, 2234743, 2236943, 2266275, 2274573, 2284510, 2324651, 2365535, 2367022, 2409135, 2412181, 2448354, 2451528, 2456702, 2456729, 2457080, 2457649, 2500872, 2587994] 2 VAX_DOSE_SERIES 2|UNK|UNK <> 2 [2458317, 2468866] 12 VAX_DOSE_SERIES UNK|2 <> 2 [980695, 1369756, 1381306, 1516231, 1561953, 1622519, 1907373, 1957297, 2125212, 2136511, 2268497, 2334359] VAX_DOSE_SERIES 1113144 UNK|UNK|2 <> 2 VAX_DOSE_SERIES 2186511 2|3|UNK|UNK <> 2|3 14 VAX_DOSE_SERIES 3|UNK <> 3 [1827443, 1926408, 1958043, 2078878, 2156004, 2172255, 2217785, 2245065, 2327918, 2399645, 2408860, 2451706, 2454993, 2458083] VAX_DOSE_SERIES 2096540 3|UNK|UNK <> 3 3 VAX_DOSE_SERIES UNK|3 <> 3 [1987557, 2124841, 2286736] 6 VAX_DOSE_SERIES 4|UNK <> 4 [2195930, 2230466, 2242264, 2439027, 2576717, 2675509] VAX_DOSE_SERIES 2521768 UNK|UNK|4|UNK|UNK <> 4|UNK 54 VAX_DOSE_SERIES UNK|UNK <> UNK [1012090, 1076752, 1119955, 1199751, 1245747, 1245944, 1269276, 1352030, 1364332, 1373793, 1378944, 1398351, 1406029, 1463292, 1465444, 1466289, 1539133, 1567395, 1575006, 1600035, 1618844, 1632157, 1656744, 1664956, 1707669, 1717717, 1767785, 1769099, 1791045, 1792920, 1800535, 1857062, 1874214, 1878172, 1893288, 1917661, 1992906, 1996794, 2003686, 2024302, 2069760, 2104442, 2129019, 2150695, 2245679, 2400725, 2407469, 2430478, 2433240, 2457193, 2458248, 2476442, 2582078, 2585817] VAX_DOSE_SERIES 1492772 UNK|UNK|UNK <> UNK VAX_DOSE_SERIES 1388735 UNK|UNK|UNK|UNK <> UNK VAX_DOSE_SERIES 2537096 UNK|4|UNK <> UNK|4 5 VAX_DOSE_SERIES UNK|UNK|UNK <> UNK|UNK [1847717, 1937233, 2374183, 2578709, 2652564] VAX_LOT 153 cells of trivial non-letter differences ignored 21 duplicates dropped in df_three_columns VAX_LOT 2454993 |1001315 <> [] VAX_LOT 1135367 |1080976 <> [] VAX_LOT 2195930 |1130421 <> [] VAX_LOT 1613625 |1137629 <> [] VAX_LOT 1618844 |1137951 <> [] VAX_LOT 2457080 |1151966 <> [] VAX_LOT 2458347 |1154004 <> [] VAX_LOT 2401159 |1160835 <> [] VAX_LOT 2427361 |1162590 <> [] VAX_LOT 2407469 |1427410 <> [] VAX_LOT 1603026 |2101734 <> [] VAX_LOT 1791045 |2101811 <> [] VAX_LOT 2150695 |2101844 <> [] VAX_LOT 2274573 |26014.4; 26014. <> [] VAX_LOT 1315815 |3182968 <> [] VAX_LOT 1417640 |ABW9975 <> [] VAX_LOT 1606111 |Ak0566F <> [] VAX_LOT 1707669 |EH9982 <> [] VAX_LOT 2078878 |EK0186 <> [] VAX_LOT 2409135 |F68F <> [] VAX_LOT 2675509 |SWO7469 <> [] VAX_LOT 2178677 |TETC03a07 <> [] VAX_LOT 2286801 |UNKNOWN <> [] 7 VAX_LOT |Unknown <> [] [1455203, 1577296, 1717717, 1792920, 2003686, 2245065, 2521267] VAX_LOT 2430478 |asked but unkno <> [] VAX_LOT 2319387 |unknown <> [] 2 VAX_LOT ||0L554A <> [] [1626955, 1626961] VAX_LOT 1206899 |||2101648 <> [] VAX_LOT 1316368 011A21A|1137629 <> 011A21A VAX_LOT 2129019 091F21A|UNK <> 091F21A VAX_LOT 2172255 ACB8491|Unknown <> ACB8491 VAX_LOT 2537096 E37|GJ2541|Unknown <> E37|GJ2541 VAX_LOT 1398351 EJ 6136|Unknown <> EJ 6136 VAX_LOT 1189319 EL0725|Unknown|Unknown <> EL0725 VAX_LOT 1515899 ER2659|GR26607 <> ER2659 VAX_LOT 1173457 |ER2659|Unknown <> ER2659 VAX_LOT 1248619 ER7812|Unknown <> ER7812 VAX_LOT 1213664 ET1831|Unknown <> ET1831 VAX_LOT 1283894 EW2246|Unknown <> EW2246 2 VAX_LOT EX7823|Unknown <> EX7823 [2365535, 2367022] VAX_LOT 2433240 EX8679|Unknown <> EX8679 VAX_LOT 1514284 EX8680|ONR9E <> EX8680 VAX_LOT 1492772 |FA4632|Unknown <> FA4632 VAX_LOT 2040843 FC1526|Unknown <> FC1526 VAX_LOT 2451528 FC2473|Unknown <> FC2473 VAX_LOT 1926408 FC3143|Unknown <> FC3143 VAX_LOT 2164220 FC3558|H0051B01 <> FC3558 VAX_LOT 2266275 FD0168|Unknown <> FD0168 VAX_LOT 1575006 FD8274|Unknown <> FD8274 VAX_LOT 2324651 FE1573|Unknown <> FE1573 VAX_LOT 2230466 FG7911|Unknown <> FG7911 VAX_LOT 2156004 FH6495|UNKNOWN <> FH6495 VAX_LOT 2242264 PCA0007|Unknown <> PCA0007 VAX_LOT 1388735 1135591|94469XH10,UNKNO|UNKNOWN|UNKNOWN <> UNKNOWN VAX_LOT 2327918 UNKNOWN|UNKNOWN <> UNKNOWN VAX_LOT 1517755 UNKNOWN|Unknown <> UNKNOWN VAX_LOT 2521768 GH8D|LK8K|UNK|UNK|YK7H <> UNK|UNK 2 VAX_LOT UNK|UNK|UNK <> UNK|UNK [1937233, 2652564] VAX_LOT 1199751 TU01D1D|Unknown <> Unknown 13 VAX_LOT Unknown|Unknown <> Unknown [1149882, 1319554, 1437196, 1455082, 1497096, 1539133, 1547095, 1763596, 1852926, 2399645, 2468865, 2476442, 2500872] VAX_LOT 2310990 Unknown|Unknown <> Unknown VAX_LOT 1874214 unknown|unknown <> unknown VAX_LOT 2374183 ||Unknown <> | VAX_LOT 2186511 |||M0031B28 <> | 218 duplicates dropped in df_three_columns VAX_MANU 2286801 Janssen|Unknown <> Janssen VAX_MANU 1269276 Unknown|Janssen <> Janssen 57 VAX_MANU Moderna|Unknown <> Moderna [1260715, 1315815, 1316368, 1352030, 1364332, 1401708, 1417640, 1439584, 1465444, 1490045, 1598737, 1600035, 1603026, 1606111, 1608828, 1609771, 1610763, 1612112, 1612467, 1613625, 1618844, 1639537, 1776011, 1810278, 1857062, 1917661, 1996794, 2024302, 2069760, 2104442, 2129019, 2150695, 2217785, 2274573, 2284510, 2319969, 2319985, 2355969, 2362211, 2362213, 2401159, 2427361, 2449835, 2454993, 2456698, 2456702, 2456729, 2457080, 2457193, 2457554, 2457601, 2457649, 2458083, 2458248, 2458347, 2459251, 2582078] 3 VAX_MANU Moderna|Unknown|Unknown <> Moderna [1626955, 1626961, 2458317] VAX_MANU 1206899 Moderna|Unknown|Unknown|Unknown <> Moderna 10 VAX_MANU Unknown|Moderna <> Moderna [1561953, 1567395, 1609356, 1609783, 1622519, 1640002, 1809969, 1908798, 2268497, 2400725] VAX_MANU 2419046 Moderna|Janssen|Unknown <> Moderna|Janssen VAX_MANU 2578709 Moderna|Pfizer-BionT|Unknown <> Moderna|Pfizer-BionT 112 VAX_MANU Pfizer-BionT|Unknown <> Pfizer-BionT [1012090, 1076752, 1106064, 1119955, 1135367, 1149882, 1150879, 1173784, 1182758, 1213664, 1240799, 1245944, 1248619, 1276141, 1283894, 1305635, 1319554, 1326177, 1338273, 1373793, 1375217, 1378944, 1384502, 1398351, 1406029, 1437196, 1450833, 1455203, 1459207, 1463292, 1466289, 1479286, 1483322, 1497096, 1514284, 1515899, 1517755, 1524932, 1539133, 1547095, 1575006, 1577296, 1593989, 1632157, 1656744, 1664956, 1671416, 1707669, 1711593, 1717717, 1763596, 1767785, 1791045, 1792920, 1800535, 1802068, 1827443, 1852926, 1874214, 1878172, 1893288, 1896399, 1902444, 1926408, 1941302, 1958043, 1980317, 1992906, 2003686, 2003687, 2040843, 2057292, 2069735, 2078878, 2156004, 2164220, 2172255, 2178677, 2195930, 2230466, 2234743, 2236547, 2236943, 2242264, 2245065, 2245679, 2266275, 2319387, 2324651, 2327918, 2365535, 2367022, 2399645, 2408860, 2409135, 2412181, 2430478, 2430499, 2433240, 2439027, 2448354, 2451528, 2451706, 2468865, 2476442, 2500872, 2518320, 2521267, 2576717, 2585817, 2587994, 2675509] 3 VAX_MANU Pfizer-BionT|Unknown|Unknown <> Pfizer-BionT [1189319, 2096540, 2468866] 35 VAX_MANU Unknown|Pfizer-BionT <> Pfizer-BionT [980695, 1037667, 1045089, 1199751, 1241518, 1245747, 1369517, 1369756, 1381306, 1455082, 1472913, 1480092, 1510571, 1516231, 1533153, 1584736, 1769099, 1790871, 1812446, 1841299, 1907373, 1915530, 1957297, 1969999, 1987557, 2016982, 2124841, 2125212, 2136511, 2163760, 2174542, 2214992, 2286736, 2334359, 2448970] 3 VAX_MANU Unknown|Pfizer-BionT|Unknown <> Pfizer-BionT [1173457, 1492772, 2310990] VAX_MANU 1113144 Unknown|Unknown|Pfizer-BionT <> Pfizer-BionT VAX_MANU 1388735 Unknown|Unknown|Pfizer-BionT|Unknown <> Pfizer-BionT VAX_MANU 2186511 Pfizer-BionT|Moderna|Unknown|Unknown <> Pfizer-BionT|Moderna VAX_MANU 2374183 Pfizer-BionT|Unknown|Unknown <> Pfizer-BionT|Unknown VAX_MANU 2407469 Unknown|Unknown <> Unknown VAX_MANU 2537096 Unknown|Pfizer-BionT|Unknown <> Unknown|Pfizer-BionT 3 VAX_MANU Unknown|Unknown|Unknown <> Unknown|Unknown [1847717, 1937233, 2652564] VAX_MANU 2521768 Unknown|Unknown|Unknown|Unknown|Unknown <> Unknown|Unknown 217 duplicates dropped in df_three_columns VAX_NAME 2286801 C19 Janssen|Not Specified NO BRAND NAME <> C19 Janssen VAX_NAME 2419046 Janssen|Not Specified NO BRAND NAME <> Janssen VAX_NAME 2578709 Pfizer-BionT|Not Specified NO BRAND NAME <> Pfizer-BionT 57 VAX_NAME C19 Moderna|Not Specified NO BRAND NAME <> C19 Moderna [1260715, 1315815, 1316368, 1352030, 1364332, 1401708, 1417640, 1439584, 1465444, 1490045, 1598737, 1600035, 1603026, 1606111, 1608828, 1609771, 1610763, 1612112, 1612467, 1613625, 1618844, 1639537, 1776011, 1810278, 1857062, 1917661, 1996794, 2024302, 2069760, 2104442, 2129019, 2150695, 2217785, 2274573, 2284510, 2319969, 2319985, 2355969, 2362211, 2362213, 2401159, 2427361, 2449835, 2454993, 2456698, 2456702, 2456729, 2457080, 2457193, 2457554, 2457601, 2457649, 2458083, 2458248, 2458347, 2459251, 2582078] 3 VAX_NAME C19 Moderna|Not Specified NO BRAND NAME|Not Specified NO BRAND NAME <> C19 Moderna [1626955, 1626961, 2458317] VAX_NAME 1206899 C19 Moderna|Not Specified NO BRAND NAME|Not Specified NO BRAND NAME|Not Specified NO BRAND NAME <> C19 Moderna VAX_NAME 2186511 Moderna|Not Specified NO BRAND NAME|Not NAME <> Moderna VAX_NAME 2374183 UNKNOWN|Not Specified NO BRAND NAME <> UNKNOWN 112 VAX_NAME C19 Pfizer-BionT|Not Specified NO BRAND NAME <> C19 Pfizer-BionT [1012090, 1076752, 1106064, 1119955, 1135367, 1149882, 1150879, 1173784, 1182758, 1213664, 1240799, 1245944, 1248619, 1276141, 1283894, 1305635, 1319554, 1326177, 1338273, 1373793, 1375217, 1378944, 1384502, 1398351, 1406029, 1437196, 1450833, 1455203, 1459207, 1463292, 1466289, 1479286, 1483322, 1497096, 1514284, 1515899, 1517755, 1524932, 1539133, 1547095, 1575006, 1577296, 1593989, 1632157, 1656744, 1664956, 1671416, 1707669, 1711593, 1717717, 1763596, 1767785, 1791045, 1792920, 1800535, 1802068, 1827443, 1852926, 1874214, 1878172, 1893288, 1896399, 1902444, 1926408, 1941302, 1958043, 1980317, 1992906, 2003686, 2003687, 2040843, 2057292, 2069735, 2078878, 2156004, 2164220, 2172255, 2178677, 2195930, 2230466, 2234743, 2236547, 2236943, 2242264, 2245065, 2245679, 2266275, 2319387, 2324651, 2327918, 2365535, 2367022, 2399645, 2408860, 2409135, 2412181, 2430478, 2430499, 2433240, 2439027, 2448354, 2451528, 2451706, 2468865, 2476442, 2500872, 2518320, 2521267, 2576717, 2585817, 2587994, 2675509] 3 VAX_NAME C19 Pfizer-BionT|Not Specified NO BRAND NAME|Not Specified NO BRAND NAME <> C19 Pfizer-BionT [1189319, 2096540, 2468866] 2 VAX_NAME NAME|Not Specified NO BRAND <> [1937233, 2652564] VAX_NAME 2407469 C19 UNKNOWN|Not Specified NO BRAND NAME <> C19 UNKNOWN VAX_NAME 2537096 Pfizer-BionT|Not Specified NO BRAND NAME <> Pfizer-BionT VAX_NAME 1269276 Not Specified NO BRAND NAME|C19 <> C19 10 VAX_NAME Not Specified NO BRAND NAME|C19 <> C19 [1561953, 1567395, 1609356, 1609783, 1622519, 1640002, 1809969, 1908798, 2268497, 2400725] 35 VAX_NAME Not Specified NO BRAND NAME|C19 <> C19 [980695, 1037667, 1045089, 1199751, 1241518, 1245747, 1369517, 1369756, 1381306, 1455082, 1472913, 1480092, 1510571, 1516231, 1533153, 1584736, 1769099, 1790871, 1812446, 1841299, 1907373, 1915530, 1957297, 1969999, 1987557, 2016982, 2124841, 2125212, 2136511, 2163760, 2174542, 2214992, 2286736, 2334359, 2448970] 3 VAX_NAME Not Specified NO BRAND NAME|C19 Pfizer-BionT|Not Specified NO BRAND NAME <> C19 Pfizer-BionT [1173457, 1492772, 2310990] VAX_NAME 1847717 Not Specified NO BRAND NAME|C19 <> C19 VAX_NAME 1113144 Not Specified NO BRAND NAME|Not NAME|C19 <> C19 VAX_NAME 1388735 Not Specified NO BRAND NAME|Not Specified NO BRAND NAME|C19 Pfizer-BionT|Not Specified NO BRAND NAME <> C19 Pfizer-BionT VAX_NAME 2521768 Not Specified NO BRAND NAME|Not NAME|C19 <> C19 VAX_ROUTE 55 cells of trivial non-letter differences ignored 169 duplicates dropped in df_three_columns 9 VAX_ROUTE OT| <> [] [1199751, 1269276, 1510571, 1812446, 1907373, 1915530, 2016982, 2174542, 2286736] 115 VAX_ROUTE OT|OT <> OT [1037667, 1213664, 1240799, 1241518, 1245747, 1260715, 1315815, 1316368, 1326177, 1338273, 1352030, 1364332, 1378944, 1401708, 1417640, 1437196, 1439584, 1465444, 1479286, 1490045, 1516231, 1561953, 1567395, 1575006, 1584736, 1598737, 1600035, 1603026, 1606111, 1609356, 1609771, 1609783, 1610763, 1612112, 1612467, 1613625, 1618844, 1622519, 1632157, 1640002, 1711593, 1769099, 1776011, 1809969, 1810278, 1857062, 1874214, 1878172, 1896399, 1902444, 1908798, 1917661, 1926408, 1957297, 1987557, 1992906, 1996794, 2003687, 2024302, 2040843, 2057292, 2069760, 2104442, 2124841, 2125212, 2129019, 2136511, 2150695, 2164220, 2172255, 2195930, 2217785, 2242264, 2266275, 2268497, 2274573, 2284510, 2286801, 2319387, 2319969, 2319985, 2324651, 2327918, 2355969, 2362211, 2362213, 2365535, 2367022, 2399645, 2400725, 2401159, 2427361, 2448970, 2449835, 2451528, 2451706, 2454993, 2456698, 2456702, 2456729, 2457080, 2457193, 2457554, 2457601, 2457649, 2458083, 2458248, 2458347, 2459251, 2468865, 2500872, 2521267, 2576717, 2582078, 2585817] 3 VAX_ROUTE OT|OT|OT <> OT [1173457, 1626955, 1626961] 4 VAX_ROUTE OT|OT|OT <> OT|OT [1847717, 2419046, 2537096, 2578709] VAX_ROUTE 1388735 OT|OT|OT|OT <> OT VAX_ROUTE 2186511 OT|OT|OT|OT <> OT|OT 2 VAX_ROUTE OT||OT <> OT [1189319, 2458317] VAX_ROUTE 2374183 OT||OT <> OT| VAX_ROUTE 1206899 OT||OT|OT <> OT VAX_ROUTE 2521768 SC|SC|||SC <> | 39 VAX_ROUTE |OT <> [] [1135367, 1173784, 1182758, 1245944, 1305635, 1373793, 1384502, 1398351, 1450833, 1459207, 1483322, 1497096, 1514284, 1515899, 1517755, 1524932, 1577296, 1593989, 1656744, 1717717, 1791045, 1792920, 1827443, 1893288, 1980317, 2003686, 2178677, 2234743, 2236547, 2236943, 2245065, 2407469, 2408860, 2412181, 2430478, 2430499, 2433240, 2439027, 2518320] 2 VAX_ROUTE |OT|OT <> OT [1113144, 2310990] 3 VAX_ROUTE ||OT <> [] [1492772, 2096540, 2468866] VAX_ROUTE 1937233 ||SYR <> | 206 VAX_SITE blanked out, noting in bulk, omitting their VAERS_IDs VAX_SITE 206 rows with 219 total bytes MADE BLANK <> [] VAX_SITE 32 cells of trivial non-letter differences ignored 225 duplicates dropped in df_three_columns 171 VAX_TYPE COVID19|UNK <> COVID19 [1012090, 1076752, 1106064, 1119955, 1135367, 1149882, 1150879, 1173784, 1182758, 1213664, 1240799, 1245944, 1248619, 1260715, 1276141, 1283894, 1305635, 1315815, 1316368, 1319554, 1326177, 1338273, 1352030, 1364332, 1373793, 1375217, 1378944, 1384502, 1398351, 1401708, 1406029, 1417640, 1437196, 1439584, 1450833, 1455203, 1459207, 1463292, 1465444, 1466289, 1479286, 1483322, 1490045, 1497096, 1514284, 1515899, 1517755, 1524932, 1539133, 1547095, 1575006, 1577296, 1593989, 1598737, 1600035, 1603026, 1606111, 1608828, 1609771, 1610763, 1612112, 1612467, 1613625, 1618844, 1632157, 1639537, 1656744, 1664956, 1671416, 1707669, 1711593, 1717717, 1763596, 1767785, 1776011, 1791045, 1792920, 1800535, 1802068, 1810278, 1827443, 1852926, 1857062, 1874214, 1878172, 1893288, 1896399, 1902444, 1917661, 1926408, 1941302, 1958043, 1980317, 1992906, 1996794, 2003686, 2003687, 2024302, 2040843, 2057292, 2069735, 2069760, 2078878, 2104442, 2129019, 2150695, 2156004, 2164220, 2172255, 2178677, 2195930, 2217785, 2230466, 2234743, 2236547, 2236943, 2242264, 2245065, 2245679, 2266275, 2274573, 2284510, 2286801, 2319387, 2319969, 2319985, 2324651, 2327918, 2355969, 2362211, 2362213, 2365535, 2367022, 2399645, 2401159, 2407469, 2408860, 2409135, 2412181, 2427361, 2430478, 2430499, 2433240, 2439027, 2448354, 2449835, 2451528, 2451706, 2454993, 2456698, 2456702, 2456729, 2457080, 2457193, 2457554, 2457601, 2457649, 2458083, 2458248, 2458347, 2459251, 2468865, 2476442, 2500872, 2518320, 2521267, 2576717, 2582078, 2585817, 2587994, 2675509] 6 VAX_TYPE COVID19|UNK|UNK <> COVID19 [1189319, 1626955, 1626961, 2096540, 2458317, 2468866] VAX_TYPE 1206899 COVID19|UNK|UNK|UNK <> COVID19 46 VAX_TYPE UNK|COVID19 <> COVID19 [980695, 1037667, 1045089, 1199751, 1241518, 1245747, 1269276, 1369517, 1369756, 1381306, 1455082, 1472913, 1480092, 1510571, 1516231, 1533153, 1561953, 1567395, 1584736, 1609356, 1609783, 1622519, 1640002, 1769099, 1790871, 1809969, 1812446, 1841299, 1907373, 1908798, 1915530, 1957297, 1969999, 1987557, 2016982, 2124841, 2125212, 2136511, 2163760, 2174542, 2214992, 2268497, 2286736, 2334359, 2400725, 2448970] 3 VAX_TYPE UNK|COVID19|UNK <> COVID19 [1173457, 1492772, 2310990] VAX_TYPE 1113144 UNK|UNK|COVID19 <> COVID19 VAX_TYPE 1388735 UNK|UNK|COVID19|UNK <> COVID19 3 VAX_TYPE COVID19|COVID19|UNK <> COVID19|COVID19 [2374183, 2419046, 2578709] VAX_TYPE 2186511 COVID19|COVID19|UNK|UNK <> COVID19|COVID19 2 VAX_TYPE COVID19|FLUX|UNK <> COVID19|FLUX [1937233, 2652564] VAX_TYPE 1847717 UNK|COVID19|FLUX <> COVID19|FLUX VAX_TYPE 2521768 UNK|UNK|COVID19|UNK|UNK <> COVID19|UNK VAX_TYPE 2537096 FLUX|COVID19|UNK <> FLUX|COVID19 9 duplicates dropped in df_three_columns symptom_entries 1507275 _|_Hyperpyrexia_|_ <> symptom_entries 1506312 _|_Maternal exposure during breast feeding_|_ <> 2 symptom_entries _|_Maternal exposure during pregnancy_|_ <> [1507040, 1516560] symptom_entries 1514161 _|_Maternal exposure during pregnancy_|_ <> symptom_entries 1644472 _|_Pyrexia_|_ <> symptom_entries 1631105 _|_Computerised tomogram head_|_Face and mouth X-ray_|_ <> symptom_entries 1621286 _|_SARS-CoV-2 test_|_ <> symptom_entries 1622839 _|_Blood test_|_Blood test abnormal_|_SARS-CoV-2 test_|_ <> symptom_entries 1511186 _|_Urticaria_|_ <> symptom_entries 1503336 _|_Heart rate_|_ <> symptom_entries 1618913 _|_Chest pain_|_ <> symptom_entries 1628011 _|_Migraine_|_ <> symptom_entries 1646832 _|_Anion gap increased_|_Blood chloride increased_|_Blood potassium decreased_|_Carbon dioxide decreased_|_ <> symptom_entries 1646910 _|_Blood thyroid stimulating hormone decreased_|_Thyroid function test abnormal_|_ <> symptom_entries 1615416 _|_Urine analysis_|_ <> symptom_entries 1630826 _|_SARS-CoV-2 test_|_ <> symptom_entries 1638943 _|_Blood test_|_ <> symptom_entries 1647184 _|_Hepatic enzyme increased_|_Liver function test increased_|_ <> symptom_entries 1635368 _|_Blood glucose_|_Blood glucose decreased_|_Blood test_|_ <> symptom_entries 1616545 _|_Blood test_|_Computerised tomogram_|_ <> symptom_entries 1622627 _|_Ultrasound Doppler_|_ <> symptom_entries 1635853 _|_Blood test_|_Bone scan_|_Magnetic resonance imaging_|_Magnetic resonance imaging head_|_ <> symptom_entries 1646837 _|_Blood chloride decreased_|_Blood sodium decreased_|_Blood urea increased_|_Glomerular filtration rate decreased_|_White blood cell count increased_|_ <> symptom_entries 1647101 _|_Blood creatinine increased_|_ <> symptom_entries 1626101 _|_Pregnancy test_|_Ultrasound foetal_|_ <> symptom_entries 1646621 _|_Blood potassium_|_ <> symptom_entries 1647013 _|_Condition aggravated_|_ <> symptom_entries 1511013 _|_Urticaria_|_ <> symptom_entries 1507320 _|_Paralysis_|_ <> symptom_entries 1507375 _|_Product administered to patient of inappropriate age_|_ <> symptom_entries 1622173 _|_SARS-CoV-2 test_|_ <> symptom_entries 1646580 _|_Electrocardiogram abnormal_|_ <> symptom_entries 1645285 _|_Death_|_Pyrexia_|_ <> symptom_entries 1503053 _|_Condition aggravated_|_ <> symptom_entries 1513297 _|_Drug ineffective_|_ <> symptom_entries 1507429 _|_Death_|_ <> symptom_entries 1639829 _|_Biopsy_|_Magnetic resonance imaging_|_Mammogram_|_Positron emission tomogram_|_ <> symptom_entries 1618878 _|_Mammogram_|_ <> symptom_entries 1627575 _|_Chest X-ray_|_Computerised tomogram_|_ <> symptom_entries 1618961 _|_SARS-CoV-2 test_|_ <> symptom_entries 1500398 _|_Incorrect route of product administration_|_SARS-CoV-2 test_|_ <> 3 symptom_entries _|_SARS-CoV-2 test_|_ <> [1646509, 1646513, 1646623] symptom_entries 1513305 _|_Vaccination failure_|_ <> symptom_entries 1512265 _|_Drug ineffective_|_ <> symptom_entries 1646845 _|_White blood cell count increased_|_ <> symptom_entries 1511057 _|_Hypertension_|_ <> symptom_entries 1621841 _|_COVID-19_|_ <> symptom_entries 1646606 _|_SARS-CoV-2 test_|_SARS-CoV-2 test positive_|_ <> symptom_entries 1614370 _|_Blood test_|_SARS-CoV-2 test_|_ <> symptom_entries 1638918 _|_Platelet count_|_Platelet count decreased_|_ <> symptom_entries 1622155 _|_Pruritus_|_ <> symptom_entries 1618019 _|_Pruritus_|_Urticaria_|_ <> symptom_entries 1622610 _|_Pain in extremity_|_ <> symptom_entries 1614869 _|_Laboratory test_|_ <> symptom_entries 1615255 _|_Computerised tomogram_|_ <> symptom_entries 1634862 _|_Blood test_|_ <> symptom_entries 1626366 _|_Blood immunoglobulin G_|_SARS-CoV-2 test_|_ <> symptom_entries 1622679 _|_Magnetic resonance imaging_|_ <> symptom_entries 1621140 _|_Vitamin B12_|_ <> symptom_entries 1646613 _|_International normalised ratio_|_International normalised ratio increased_|_ <> symptom_entries 1500033 _|_Pain in extremity_|_ <> symptom_entries 1504194 _|_Thrombocytopenia_|_Vaccination site pain_|_ <> symptom_entries 1648152 _|_Gait inability_|_ <> symptom_entries 1613879 _|_Blood test_|_Computerised tomogram_|_Electrocardiogram_|_Neurological examination_|_ <> symptom_entries 1614604 _|_COVID-19_|_ <> symptom_entries 1646350 _|_Asymptomatic COVID-19_|_ <> symptom_entries 1631956 _|_SARS-CoV-2 antibody test_|_ <> symptom_entries 1645092 _|_Extra dose administered_|_Immunodeficiency_|_ <> symptom_entries 1631960 _|_SARS-CoV-2 test_|_ <> symptom_entries 1510980 _|_Anaphylactic reaction_|_ <> symptom_entries 1625944 _|_SARS-CoV-2 test_|_ <> symptom_entries 1626104 _|_Pregnancy test_|_ <> symptom_entries 1646558 _|_Pneumothorax_|_ <> symptom_entries 1646066 _|_Pain in extremity_|_ <> symptom_entries 1622044 _|_Paraesthesia_|_ <> symptom_entries 1648361 _|_Rash erythematous_|_ <> symptom_entries 1631059 _|_Rhesus antibodies_|_ <> symptom_entries 1509124 _|_Vaccination failure_|_ <> symptom_entries 1646990 _|_SARS-CoV-2 test positive_|_ <> 6 symptom_entries _|_SARS-CoV-2 test_|_ <> [1625938, 1625940, 1634863, 1636138, 1636139, 1636143] 2 symptom_entries _|_Antibody test_|_ <> [1623044, 1631063] symptom_entries 1646503 _|_SARS-CoV-2 test positive_|_ <> symptom_entries 1621693 _|_White blood cell count_|_ <> 15 columns altered 1646391 modified reports on 2023-12-29 Writing ... vaers_flatfile/2023-12-29_VAERS_FLATFILE.csv 1 report with the most (18) records/lots/doses: 1900339 1 comparison done Doing stats open stats.csv ... ok column changes: {'VAX_DOSE_SERIES': 239, 'VAX_NAME': 238, 'VAX_MANU': 238, 'VAX_TYPE': 238, 'OTHER_MEDS': 231, 'VAX_ROUTE': 183, 'symptom_entries': 92, 'VAX_LOT': 85, 'SYMPTOM_TEXT': 38, 'DATEDIED': 5, 'DIED': 4, 'LAB_DATA': 3, 'AGE_YRS': 1, 'HISTORY': 1, 'V_FUNDBY': 0, 'L_THREAT': 0, 'V_ADMINBY': 0, 'CAGE_MO': 0, 'RECVDATE': 0, 'RECOVD': 0, 'OFC_VISIT': 0, 'CAGE_YR': 0, 'SEX': 0, 'NUMDAYS': 0, 'ALLERGIES': 0, 'FORM_VERS': 0, 'TODAYS_DATE': 0, 'STATE': 0, 'DISABLE': 0, 'PRIOR_VAX': 0, 'SPLTTYPE': 0, 'ONSET_DATE': 0, 'VAX_SITE': 0, 'VAX_DATE': 0, 'HOSPDAYS': 0, 'X_STAY': 0, 'HOSPITAL': 0, 'ER_ED_VISIT': 0, 'RPT_DATE': 0, 'ER_VISIT': 0, 'CUR_ILL': 0, 'BIRTH_DEFECT': 0} This week 2907 delayed/late/gapfill 267 deleted 0 restored 242 cell edits trivial not printed 1596 cell edits significant 293 cells emptied entirely 38 writeups changed All time 545146 delayed/late/gapfill 31924 deleted 16 restored 29372767 cell edits trivial not printed 33535 cell edits significant 1476070 cells emptied entirely 7689 writeups changed 32222 never published [896713, 896742, 896875, 896892, 896899, 897093, 897105, 897169 ... 2728266, 2728267, 2728268, 2728269, 2728293, 2728296, 2728404, 2728406] 20 reports cleared of duplicate sentences within them 0 hr 11.3 min This week None 0 hr 11.3 min Overall None Saving vaers_flatfile/2023-12-29_VAERS_FLATFILE_A.csv, 1048575 rows and vaers_flatfile/2023-12-29_VAERS_FLATFILE_B.csv, 607283 rows No more input files to process 0 hr 13.4 min Done with vaers_flatfile_build.py at line 748, clock time 2024-01-10 15:11:03.443832 - - - - - - - - - - - - - - - - - - - - - - - -