Small discrepancies in displayed counts of scans vs counts derived from the imaging report

[psadil]

As of this morning, the report shows these scan counts

When I get the same numbers from the most recently generated imaging log, this is what I see

pd.read_csv("imaging-log-latest.csv", usecols=['site','subject_id','visit']).groupby(['site','visit']).count()
            subject_id
site visit            
NS   V1            237
     V3            138
RU   V1              1
SH   V1             51
     V3             37
UC   V1            130
     V3             76
UI   V1            314
     V3            217
UM   V1            269
     V3            184
WS   V1             51
     V3             31

So, not exactly the same (e.g., SH V1 shows 51, but the report shows 50).

I think these numbers should match.

Not sure whether the following is relevant, but I'm noticing that the report says that the data were loaded from the api at 00:52:07 (not sure about the time zone), but the imaging report is copied over at about 01:00:00

$ ls -lt /corral-secure/projects/A2CPS/community/reports/imaging/imaging-log-latest.csv
-rw-r----- 1 urrutia G-821866 275828 Mar  8 01:00 /corral-secure/projects/A2CPS/community/reports/imaging/imaging-log-latest.csv