Where are the missing 1,290 lots/batches in the Pfizer FOIA request response?

Doses and destinations

Finally getting around to asking this question after the Freedom of Information Act (FOIA) request to Pfizer resulted in their release of these files published in July 25, 2022 with an update on September 16, 2022:

https://icandecide.org/article/pfizer-lot-dose-documents/ ICAN (Informed Consent Action Network) formed by Del Bigtree and FOIA’s by Aaron Siri.

Three documents (spreadsheets) with 1,601,521 rows total.

But those 1.6 million rows are covering only 156 lot codes.

Our file below has 1,343 Pfizer known lot codes (as of Aug 2023, plus other manufacturers of the covid vaccines) with their expiration dates (plus 103 Pfizer with expiry not yet known for a total of 1,446). Note expirations are often adjusted ahead 60 days and thus subject to change. The Pfizer lots can be verified at https://lotexpiry.cvdvaccine.com/ although in our experience when accessed from within the United States it just sits there spinning.

Some of the missing lots, here showing month/year often but we need the specific day also.

Our file, lots/batches with expiration dates

https://univaers.com/download/expiration_dates.csv … Best, most comprehesive list of covid vaccine lot codes with their expiration dates in the world by far.

I’m also including in that file … Pfizer lots with 50+ reports in VAERS although we don’t have their expiration dates yet. It’s a pretty safe and effective assumption they are valid lots with 19,659 reports of harm and destroyed lives against them in VAERS.

So that means 1,290 were missing in the Pfizer release. Why?

What do the ICAN Pfizer documents contain?

Number of doses shipped to which zip/city/state (USA only), the name of the destination like Lillian Pharmacy etc, and control/billing codes, date.

The first document (starting with 22-01271) has nonsense lots listed like literally just the number 0 as the supposed lot and 15,565 doses of it shipped (but with no other details in that file), or 2,328 doses shipped for a lot code called “LOT”, 14 doses shipped to a lot supposedly made up of two dashes, or how about the single dose with lot code … ----!]!![};, that’s a funny one. It goes on and on like that. In other words, not valid info from Pfizer. I can’t convey how ridiculous it is, you would have to look through it yourself. There are even entries under lot_number that are email addresses and phone numbers for example in that file, as supposedly Pfizer vaccine lot codes.

In the second file, they are valid but again only 156 lot codes across 425,351 rows.

The third file is the one with better content. It is called Amended-22-01962-Pfizer-2022-0426-pulled-2022-0823.xlsx, but only 156 lots. Expected 1,343.

Codes Present

These are those 156 FOIA lot codes: 30125BA 30130BA 30135BA 30145BA 30155BA 32030BD 33025BD 33026BD 33030BD 33036BD 33130BA EH9899 EJ1685 EJ1686 EK4176 EK5730 EK9231 EL0140 EL0142 EL1283 EL1284 EL3246 EL3247 EL3248 EL3249 EL3302 EL8982 EL9261 EL9262 EL9263 EL9264 EL9265 EL9266 EL9267 EL9269 EM9809 EM9810 EN5318 EN6198 EN6199 EN6200 EN6201 EN6202 EN6203 EN6204 EN6205 EN6206 EN6207 EN6208 EN9581 EP6955 EP7533 EP7534 ER2613 ER8727 ER8729 ER8730 ER8731 ER8732 ER8733 ER8734 ER8735 ER8736 ER8737 EW0150 EW0151 EW0153 EW0158 EW0161 EW0162 EW0164 EW0165 EW0167 EW0168 EW0169 EW0170 EW0171 EW0172 EW0173 EW0175 EW0176 EW0177 EW0178 EW0179 EW0180 EW0181 EW0182 EW0183 EW0185 EW0186 EW0187 EW0191 EW0196 EW0198 EW0202 EW0217 EY0584 FA6780 FA7484 FA7485 FC3180 FC3181 FC3182 FC3183 FC3184 FD0809 FD0810 FD7218 FD7220 FD8448 FE3590 FE3592 FE3594 FF2587 FF2588 FF2589 FF2590 FF2593 FF8839 FF8841 FG3527 FH8020 FH8027 FH8028 FH8030 FJ1611 FJ1614 FJ1620 FJ4989 FJ4991 FJ5682 FJ5683 FJ6369 FJ8757 FJ8762 FJ9943 FK5127 FK5618 FK9729 FK9893 FK9894 FK9895 FK9896 FL0007 FL3197 FL3198 FL3209 FL4211 FL8094 FL8095 FM0173 FM0698 FM7553 FM9992 FP4554 P0001332

Codes missing

Expected these 1,187 also: 1C005A 1E022A 1F038A 1F1003A 1F1004A 1F1005A 1F1006A 1F1007A 1F1008A 1F1009A 1F1012A 1F1013A 1F1014A 1F1015A 1F1016A 1F1017A 1F1018A 1F1019A 1F1020A 1F1025A 1F1026A 1F1028A 1F1030A 1F1031A 1F1032A 1F1033A 1F1034A 1F1035A 1F1036A 1F1037A 1F1038A 1F1039A 1F1040A 1F1043A 1F1044A 1F1045A 1F1046A 1F1047A 1F1048A 1F1051A 1F1053A 1F1054A 1F1055A 1F1056A 1F1057A 1F1058A 1F1059A 1F1060A 1F1062A 1G042A 1G043A 1G044A 1G047A 1H049A 1H050A 1H054A 1H055A 1H056A 1H058A 1H059A 1I064A 1I069A 1I070A 1I071A 1J072A 1J073A 1K078A 1K079A 1K081A 1K083A 28230BD 28231BD 28235BD 29125BA 30140BA 30150BA 30966TB 31020BD 31025BD 31035BA 31045BD 31050BD 31051BD 31055BD 31056BA 31060BD 31065BD 31075BD 31076BD 31100TB 31125BA 31130BA 31134TB 32006BA 32010BD 32016BD 32021BA 32021BD 32025BD 32125BA 32131BD 32136BA 32155BA 33006BD 33010BD 33020BD 33040BD 33193TB 33194TB 33284TB 33295TB 33360TB 33361TB 34005BD 34010BD 34015BD 34020BD 34025BD 34030BD 34300BD 34305BD 34310BD 34511TB 34513TB 34525TB 35020BD 35025BD 35035BD 35040BD 35045BD 35050BD 35065BD 35066BD 35559TB ACB2638 ACB3152 ACB3999 ACB8491 ACB8497 ACB8965 ACB8966 ACB9330 EE8492 EE8493 EH9978 EJ0553 EJ0724 EJ1284 EJ1484 EJ1688 EJ3002 EJ3007 EJ5002 EJ6134 EJ6136 EJ6788 EJ6789 EJ6790 EJ6795 EJ6796 EJ6797 EJ7489 EK1768 EK3730 EK4175 EK4237 EK4238 EK4240 EK4241 EK4242 EK4243 EK4244 EK4245 EK9788 EL0141 EL0200 EL0203 EL0725 EL0739 EL1404 EL1406 EL1424 EL1460 EL1484 EL1491 EL6136 EL6797 EL7834 EL8713 EL8723 EM0477 EM4965 EM6950 EN1185 EN1194 EN1195 EN1196 EN1198 EN1201 EN1484 EN3318 EN3924 EN8203 EP2163 EP2166 EP2173 EP2659 EP6017 EP6775 EP9065 EP9480 EP9505 EP9598 EP9605 ER0641 ER0866 ER1173 ER1741 ER1742 ER1749 ER2659 ER3674 ER6166 ER7449 ER7499 ER7812 ER7934 ER9449 ER9470 ER9480 ET0384 ET1831 ET2838 ET3033 ET3045 ET3620 ET3674 ET6924 ET6956 ET7205 ET8885 ET9096 EW0193 EW0195 EW0199 EW0201 EW0203 EW0206 EW0207 EW0216 EW0221 EW1072 EW2215 EW2239 EW2243 EW2245 EW2246 EW2544 EW3143 EW3344 EW4109 EW4758 EW4811 EW4815 EW5279 EW6126 EW6326 EW6327 EW8904 EW9127 EWD162 EWD175 EX0438 EX0893 EX0904 EX2294 EX2405 EX3510 EX3546 EX3599 EX3617 EX6537 EX6564 EX7389 EX7823 EX8679 EX8680 EY0572 EY0573 EY0574 EY0575 EY0578 EY0579 EY0580 EY0581 EY0582 EY0583 EY0585 EY0586 EY0779 EY2172 EY2173 EY3014 EY3860 EY4825 EY4834 EY4837 EY5420 EY5422 EY5423 EY5456 EY7015 EY7065 FA1027 FA2453 FA4597 FA4598 FA4632 FA5715 FA5742 FA5765 FA5829 FA5831 FA5833 FA5843 FA7082 FA7083 FA7209 FA7338 FA7478 FA7483 FA7812 FA7842 FA8016 FA8142 FA8721 FA9090 FA9091 FA9093 FA9094 FA9095 FA9096 FA9099 FA9100 FB5613 FC0007 FC0681 FC1131 FC1426 FC1433 FC1435 FC1436 FC1439 FC1440 FC1526 FC2090 FC2229 FC2336 FC2396 FC2473 FC2495 FC2752 FC3095 FC3098 FC3143 FC3558 FC3661 FC5029 FC5089 FC5295 FC5435 FC5436 FC5947 FC6984 FC6997 FC8273 FC8289 FC8736 FC8889 FC9000 FC9001 FC9873 FC9880 FC9909 FD0168 FD0348 FD0349 FD0350 FD0785 FD0889 FD0927 FD0932 FD1921 FD1945 FD4342 FD4500 FD4555 FD5580 FD5613 FD5996 FD6840 FD7204 FD7206 FD7207 FD7208 FD7209 FD7210 FD7219 FD7221 FD7222 FD7958 FD7959 FD8274 FD8813 FD8831 FD9234 FD9235 FD9309 FE1207 FE1248 FE1510 FE1573 FE2083 FE2090 FE2296 FE2625 FE2707 FE3064 FE3065 FE3184 FE3380 FE3430 FE3591 FE3593 FE3690 FE3954 FE4394 FE4721 FE4728 FE6014 FE6029 FE6208 FE6975 FE7010 FE7011 FE7051 FE7053 FE8087 FE8162 FE8163 FE8206 FE8235 FE8236 FE8244 FE8405 FE9174 FF0680 FF0688 FF0843 FF0884 FF0900 FF2018 FF2153 FF2154 FF2382 FF2591 FF2592 FF2594 FF2595 FF2744 FF2752 FF2782 FF2832 FF2834 FF3318 FF3319 FF3341 FF3620 FF3622 FF4202 FF4204 FF4206 FF4213 FF4222 FF5106 FF5107 FF5108 FF5109 FF5110 FF5111 FF5357 FF7416 FF7481 FF8111 FF8199 FF8222 FF8279 FF8287 FF8288 FF8838 FF8840 FF8842 FF8843 FF8844 FF8845 FF8846 FF8847 FF8848 FF8849 FF8871 FF9942 FF9944 FG0050 FG0978 FG1248 FG1599 FG1657 FG1807 FG2872 FG2943 FG2944 FG2975 FG3035 FG3523 FG3524 FG3525 FG3526 FG3528 FG3529 FG3530 FG3531 FG3532 FG3533 FG3534 FG3535 FG3536 FG3712 FG3716 FG3739 FG4421 FG4442 FG4493 FG4509 FG4592 FG4658 FG4686 FG6270 FG6272 FG6273 FG6431 FG7369 FG7372 FG7387 FG7898 FG7900 FG7911 FG8643 FG9019 FG9428 FG9984 FH0114 FH0151 FH0160 FH0161 FH2496 FH2528 FH2584 FH2596 FH2597 FH3023 FH3219 FH3220 FH3221 FH3226 FH3253 FH4092 FH4750 FH4751 FH4752 FH4763 FH4829 FH6371 FH6387 FH6408 FH6495 FH8021 FH8022 FH8023 FH8024 FH8025 FH8026 FH8029 FH8469 FH8773 FH9678 FH9951 FJ1612 FJ1613 FJ1615 FJ1617 FJ1618 FJ1619 FJ1763 FJ1926 FJ1964 FJ1966 FJ2594 FJ3438 FJ4184 FJ4187 FJ4188 FJ5782 FJ5790 FJ5929 FJ5973 FJ7489 FJ8041 FJ8198 FJ8354 FJ8372 FJ8756 FJ8758 FJ8759 FJ8760 FJ8761 FJ8763 FJ8764 FJ8765 FJ8766 FK0108 FK0112 FK0115 FK0592 FK0594 FK0595 FK0596 FK0723 FK0738 FK0739 FK0888 FK0892 FK1754 FK5132 FK5475 FK6268 FK6302 FK6303 FK6304 FK6858 FK7441 FK8562 FK8888 FK8892 FK8911 FK8917 FK9412 FK9413 FK9414 FK9706 FK9707 FK9712 FL1072 FL1839 FL1937 FL1939 FL1940 FL2757 FL3196 FL3201 FL3202 FL3203 FL3204 FL3205 FL3206 FL3207 FL3208 FL3210 FL3211 FL3560 FL4209 FL4210 FL4213 FL4222 FL4574 FL4789 FL5324 FL5333 FL5729 FL7309 FL7476 FL7645 FL7646 FL7649 FL9994 FM2948 FM2951 FM2952 FM2953 FM2954 FM2955 FM2956 FM2957 FM2958 FM2959 FM2960 FM2962 FM2963 FM2964 FM2965 FM2966 FM2967 FM2968 FM3289 FM3292 FM3355 FM3444 FM3453 FM3457 FM3468 FM3496 FM3802 FM3809 FM3884 FM4289 FM5450 FM7374 FM7375 FM7376 FM7377 FM7378 FM7379 FM7380 FM7381 FM7382 FM7383 FM7384 FM7531 FM7532 FM7533 FM7534 FM7783 FM7785 FM9088 FM9090 FM9091 FM9092 FM9282 FM9360 FN0087 FN0565 FN0987 FN1430 FN1431 FN1448 FN1455 FN1664 FN1665 FN1671 FN1672 FN1673 FN2034 FN2716 FN2717 FN2724 FN2726 FN2727 FN2898 FN2908 FN3543 FN3731 FN3758 FN3815 FN4071 FN4072 FN4073 FN4074 FN4075 FN4207 FN4365 FN4817 FN5254 FN5430 FN5436 FN5496 FN5519 FN6201 FN6611 FN6618 FN7874 FN7934 FN9501 FN9509 FN9605 FN9606 FN9607 FP0265 FP1176 FP1430 FP1972 FP5671 FP7070 FP7082 FP7135 FP7136 FP7137 FP7138 FP7139 FP7140 FP7141 FP7150 FP7498 FP8073 FP8190 FP8191 FP8233 FP8234 FP8290 FP8544 FP8545 FP8795 FP9359 FP9604 FP9632 FP9643 FP9647 FP9654 FP9681 FR0012 FR1790 FR1791 FR1796 FR2447 FR2448 FR2449 FR2450 FR2451 FR2452 FR2453 FR2454 FR2455 FR2456 FR2457 FR2458 FR2459 FR2460 FR2461 FR2583 FR2587 FR4768 FR4798 FR4875 FR4876 FR4877 FR4878 FR4879 FR5496 FR5497 FR8225 FR8226 FR8392 FT0066 FT0067 FT0366 FT0875 FT1551 FT1586 FT1587 FT3002 FT5172 FT5177 FT5330 FT5331 FT5332 FT5333 FT5334 FT5335 FT5336 FT5337 FT5338 FT5339 FT5341 FT5342 FT5343 FT5344 FT7276 FT7280 FT7737 FT7738 FT8471 FT8584 FT9319 FT9321 FT9366 FT9426 FT9427 FT9429 FW0547 FW1329 FW1330 FW1331 FW1333 FW1334 FW1336 FW2672 FW2673 FW2674 FW2897 FW2899 FW3563 FW6014 FW7277 FW7278 FW7946 FW8612 FX1188 FX1189 FX2761 FX2762 FX2944 FX4435 FX5424 FX5740 FX5823 FX8161 FX8946 FX8970 FY1298 FY1305 FY1317 FY1323 FY1331 FY1793 FY1803 FY7065 FY7381 FY8211 GA2988 GA6773 GA6774 GC3185 GC3889 GC3898 GD6676 GD6677 GD6678 GD6793 GD6794 GD6795 GD6796 GD6797 GD6798 GD6799 GD6800 GD6802 GD6803 GE0154 GE1641 GE1643 GE3042 GE3043 GE3044 GE8242 GE8297 GE8310 GE8382 GF4594 GF7975 GF8452 GF8460 GF8742 GF9669 GF9670 GF9672 GF9673 GF9674 GH9431 GH9434 GH9436 GH9437 GH9448 GH9545 GH9693 GH9694 GH9697 GH9702 GH9703 GH9715 GH9722 GH9741 GH9851 GH9852 GJ1987 GJ1988 GJ2524 GJ2541 GJ2542 GJ2543 GJ2544 GJ2546 GJ2548 GJ2552 GJ2553 GJ2554 GJ2556 GJ2558 GJ2631 GJ2636 GJ2637 GJ2638 GJ2639 GJ2640 GJ3268 GJ3270 GJ3274 GJ3275 GJ3277 GJ4535 GJ5083 GJ5106 GJ5342 GJ6665 GJ6738 GJ6739 GJ6742 GJ6743 GJ6796 GJ7179 GJ7181 GJ7182 GJ7184 GJ7186 GJ7187 GJ7890 GJ7892 GJ8003 GJ9231 GJ9236 GJ9238 GJ9239 GJ9250 GJ9252 GJ9254 GK0280 GK0876 GK0923 GK0924 GK0925 GK0926 GK0927 GK0928 GK0929 GK0930 GK0931 GK0932 GK0933 GK0936 GK0950 GK1316 GK1334 GK1337 GK1338 GK1657 GK1667 GK1700 GK1703 GK1704 GK1705 GK1706 GK3907 GK3908 GK4367 GK7826 GK8026 GK9272 GK9273 GK9274 GK9275 GK9276 GL0087 GL0088 GL0089 GL0172 GL0214 GL0446 GL0447 GL1990 GL2042 GL3978 GL3979 GL3980 GL6108 GL7685 GL7686 GL7687 GL7688 GL7689 GL7930 GL8839 GM1766 GM1767 GM2021 GM2023 GM2890 GM3740 GM6301 GM6322 GM6327 GM6331 GM6332 GM6333 GM6337 GM6363 GM6457 GM7770 GM7779 GM8341 GN3274 GP4342 GP4343 GP4344 GP4345 GW8170 GW8176 GY5673 GY5686 GY5687 PCA0002 PCA0003 PCA0004 PCA0005 PCA0006 PCA0007 PCA0008 PCA0009 PCA0010 PCA0012 PCA0013 PCA0014 PCA0015 PCA0016 PCA0017 PCA0019 PCA0020 PCA0021 PCA0022 PCA0023 PCA0024 PCA0025 PCA0026 PCA0027 PCA0028 PCA0029 PCA0030 PCA0031 PCA0032 PCA0033 PCA0034 PCA0035 PCA0036 PCA0037 PCA0038 PCA0039 PCA0057 PCA0068 PCB0001 PCB0002 PCB0003 PCB0004 PCB0005 PCB0006 PCB0008 PCB0009 PCB0010 PCB0011 PCB0012 PCB0014 PCB0015 PCB0016 PCB0017 PCB0018 PCB0019 PCB0020 PCB0021 SCUD8 SCWF7 SDCC8 SDCH8

Additional codes missing

Also these 103 (mentioned above) which all have at least 50 reports in VAERS against them (with the grand prize going to 1,169 reaction reports in the case of FT9142) but for which we don’t yet have expiration dates: 1B002A 1B003A 1C006A 1C007A 1C008A 1C009A 1C010A 1C011A 1D012A 1D013A 1D014A 1D015A 1D016A 1D017A 1D018A 1D020A 1E021A 1E024A 1E025A 1E026A 1E027A 1E028A 1E029A 1F030A 1F034A 1F036A 1F1010A 1F1021A 1F1022A 1F1023A 1F1024A 1F1027A 1F1042A 1F1052A 1G040A 1H048A 30011TB 30025TB 30891TB 31043TB 31045BA 31101TB 33233TB 34397TB ACB3738 ACB4447 ACB4692 ACB4694 ACB5038 ACB5317 ACB5318 ACB7737 ACB8967 ACB9148 ACB9929 ACC0681 ACC1336 EL9268 EN6955 EW0810 F63527 FD6208 FM3092 FN2723 FN5988 FP1965 FP1971 FT9142 FX5095 GD1857 GJ1842 GJ1852 GJ1857 GJ7139 SCDD2 SCDN1 SCEL5 SCJU6 SCKT8 SCKX7 SCPT7 SCRM8 SCRP9 SCRW2 SCTD6 SCTJ2 SCTN4 SCUE1 SCUL2 SCVC6 SCVD1 SCVK4 SCVT5 SCVW7 SCVY8 SCWF3 SDCN1 SDCN3 SDDN7 SDEH4 SDEJ8 SDEW9 SDHP9

Total

On Pfizer’s release of information regarding lots/batches:

Expected 1,446

Got 156 (11%)

Missing 1,290

---

Appreciation to Jon Findley for help on the Pfizer lot codes.

More info

… on lot code typographical error fixing:

---

Do you want to help with lot cleaning? Join the VAERS Cleaning Telegram group

https://t.me/+kxnEaEW5v5hjMjQx