COVID 19 supply audit

I have been attempting to reconcile the announced amount and timing of Pfizer vaccine to the TGA batch releases. This work is done with a view to encouraging some better public information about the Pfizer vaccine supply (and in general). If you want to take it further, please verify the source information yourself.

Spreadsheet

This work-in-progress Spreadsheet captures my current attempt at reconciliation of Pfizer batches (as per TGA) to supply announcements. It is available here: Pfizer Supply Audit (Australia).

This includes 3 more batches from the TGA Batch Release website updated 11 August 2021, and another 4 batches that were included on 12 August 2021.

Based on the limited information, we cannot confidently link the announced quantities to a specific batch tested by the TGA. The best we can do is line them up based on the time sequence (i.e. the announcement can only relate to batches completed prior to the date of the announcement).

Background notes (sources)

I have prepared a separate blog post, which will help you to follow the content and the relevant government announcements.

Please bear in mind:

  • The delivery numbers quoted by the government seem to be based on maximum possible doses you can get from the Pfizer vials (6 doses per vial). The accurate quantity should be the number of vials and trays, but that’s not disclosed.
  • The TGA ‘batch completion’ date seems to be the date that Pfizer’s overseas manufacturing process ready for delivery is completed. It should then be another few days at least before that delivery can arrive in Australia.

TGA Batch Release website and updates

Set out below is my summary of the Pfizer batch numbers processed by the TGA prior to testing and/or release. This is based on the information in the TGA batch releases web page, but I have filtered for Pfizer and resorted it into ascending batch date, so that the earliest batches appear first.

My general comments are:

  • The TGA batch release web page is not updated anywhere near as regularly as the weekly Pfizer deliveries. It was last updated on or about 5 July 2021, and then on 11, 12 and 19 August 2021.
  • The TGA website has had some ‘in progress’ batches for a couple of months now.
  • The manufacturing (completed) dates of the disclosed Pfizer batches cannot be reconciled to weekly deliveries except for a few weeks in May – otherwise, what has been disclosed is too infrequent.
  • As time progresses, there is even less information available to reconcile TGA batch numbers to delivered quantities.
  • On 11 August 2021 there were no new manufactured batches listed on the TGA website with manufactured dates between 29 June 2021 and 27 July 2021.

The TGA updated its batch release website on or about 11 August 2021 (batches 28 to 30 below) and again on 12 August (batches 24 to 27 below).

Batch ReferenceBatch completed dateStatus
1EP21639 Feb 2021Passed
2EP960512 Feb 2021Passed
3ER744927 Feb 2021Passed
4ER744922 March 2021Not tested
5ET304530 March 2021Passed
6EX24058 April 2021Passed
7EX656422 April 2021Passed
8EX65641 May 2021Not tested
9EX65647 May 2021Not tested
10FC355813 May 2021Passed
11FD092727 May 2021Passed
12FD09277 June 2021Not tested
13FA58339 June 2021In Progress
14FC23369 June 2021In Progress
15FD923410 June 2021In Progress
16FC355821 June 2021Not tested (Limited batch. Pfizer Employees)
17FA459822 June 2021Not tested (Limited batch. Pfizer Employees)
18FA733822 June 2021Not tested (Limited batch. Pfizer Employees)
19FA781222 June 2021Not tested (Limited batch. Pfizer Employees)
20FC873622 June 2021Not tested (Limited batch. Pfizer Employees)
21FE306423 June 2021Passed
22FE306425 June 2021Not tested
23FC502929 June 2021In Progress
24FF42226 July 2021Passed
25FE343014 July 2021Passed
26FF088415 July 2021In Progress
27FF887121 July 2021In Progress
28FG005027 July 2021In Progress
29FA459830 July 2021Not tested
30FE81633 August 2021In Progress
Pfizer batch numbers for delivered supply, as published by TGA to 12 August 2021

The status of FC5029 (in progress), a recent batch dated 29 June 2021, did not change in the 11 August 2021 TGA web page update.

The TGA information update on 11 August 2021 included a shipment from batch FA4598, which had previously been part of a Pfizer Employee delivery on or about 22 June 2021.

TGA Batch release update overnight 19 August 2021

The TGA updated its batch release web page overnight 19 August 2021, changing the status of all batches to ‘passed’. It also made several changes to the data, which are most easily seen by a comparison between the previous day’s list and the next day’s list:

TGA website 12 AugustTGA website 19 August
Pfizer Batch (AUS)Batch DatePfizer Batch (AUS)Batch Date
EP21639-Feb-21EP216309-Feb-21
EP960512-Feb-21EP960512-Feb-21
ER744927-Feb-21ER744927-Feb-21
ER744922-Mar-21ER744922-Mar-21
ET304530-Mar-21ET304530-Mar-21
EX24058-Apr-21EX240508-Apr-21
EX656422-Apr-21EX656422-Apr-21
EX65641-May-21EX656401-May-21
EX65647-May-21EX656407-May-21
FC355813-May-21FC355813-May-21
FD092727-May-21FD092727-May-21
FD09277-Jun-21FD092707-Jun-21
FA58339-Jun-21FA583309-Jun-21
FC23369-Jun-21FC233609-Jun-21
FD923410-Jun-21FD923410-Jun-21
  FE209017-Jun-21
FC355821-Jun-21FC355821-Jun-21
FA459822-Jun-21  
FA733822-Jun-21FA733822-Jun-21
FA781222-Jun-21FA781222-Jun-21
FC873622-Jun-21FC873622-Jun-21
FE306423-Jun-21FE306423-Jun-21
FE306425-Jun-21FE306425-Jun-21
FC502929-Jun-21FC502929-Jun-21
FF42226-Jul-21FF422206-Jul-21
FE343014-Jul-21FE343014-Jul-21
FF088415-Jul-21FF088415-Jul-21
FF887121-Jul-21  
FG005027-Jul-21FG005027-Jul-21
FA459830-Jul-21FA459830-Jul-21
FE81633-Aug-21FE816303-Aug-21
  FF420610-Aug-21
  FF088412-Aug-21
  FE705116-Aug-21
Changes to TGA Batch release information from its web page dated 12 August 2021 to the one dated 19 August 2021

This latest update has removed two of the previous batch entries (FA4598 and FF8871, the latter being included as recently as last week). FA4598 (22 June) was originally described as a Pfizer Employee batch but those details are no longer included on the TGA web page.

It also added FE2090 (with a June 2021 batch release date), and added three more entries in the two weeks since 3 August 2021. One the latest 3 batches is a repeat batch number (FF0884), the same as a batch release dated 15 July 2021 .

Which of these batches is visible in the doses being received into people’s arms and how long is it taking?

Currently, I have some anecdotal information about dose delivery.

BatchBatch dateUse Date (AUS)Notes
FE3064 23-25 June 202119 July 2021An image of a batch FE3064 single vaccine dose (0.3mL) with an expiry date of 19 July 2021 appeared in several online news articles on 20 July 2021 (SMH, TheWest, CanberraTimes ). It looks like it was taken at the Sunshine Hospital in St Albans, Victoria
FD0927May/June 20212 August 2021Used in Perth in the week commencing Monday, 2 August 2021. That is approximately two months after the original AUS delivery date, as best I can tell.
FF088415 July 202119 August 2021Used in Perth, WA. Approximately one month after batch completed date. One week after this batch being placed on TGA batch release website. The batch is still listed on TGA batch release testing site as ‘in progress’.
Example of batches

This information is for illustration only. The supply chain has not been analysed in detail.

.

Have you received a dose of Pfizer from a batch that doesn’t appear?

I have some other anecdotal evidence that people have received vaccines from Pfizer batches that are not listed on the TGA website (and therefore my master spreadsheet, as at 5 August 2021). If you want to let me know of a Pfizer-Comirnaty vaccine batch number actually being used in a particular Australian State, at a particular time, that does not appear in the master spreadsheet, you can email me at:

software[-at-]craigduncan.com.au.

I will add that batch number to a list of unaccounted for batches that I will include here at a future date.

Leave a comment

Your email address will not be published. Required fields are marked *