BIA-CVR Join Report

San Francisco, California, 2024 General Election

Audit Engine version:'v2.32.X'

Run Date: 2026-10-27 15:49:13.154355 Copyright (c) Citizens' Oversight


Return to Master Report Index


Ballot images and CVR records that found no partner when combine_bifs joined them on ballot_id. It runs before the gen_fullbif image scan, so a gap can be fixed before that cost. Report only: a FAIL does not stop the pipeline, but explain every FAIL before gen_fullbif.

Caveats: it counts every card, before profiling. BMD status of images is still the file-size guess. Imaged precincts are those where some CVR record matched an image. Official ballots cast are compared after gen_profiled_bif.

2 of 4 checks failed.

Checks

check result detail
every image has a CVR record FAIL 477 images without a CVR record
every CVR record in the imaged precincts has an image FAIL 2 CVR records without an image in 510 imaged precincts
one image per ballot_id PASS 0 repeated ballot_ids
join residue matches CVR records without an image PASS residue 5, CVR records without image 5, 0 in only one

Counts

item count
images 1,604,380
CVR records 1,603,908
matched 1,603,903
images without a CVR record 477
CVR records without an image, imaged precincts 2
CVR records without an image, other precincts 3
imaged precincts (CVR numbering) 510

CVR records without an image, imaged precincts

Look for the images in other archives of the election folder, listed below, and for ballot_id forms the join cannot match. Full list: 'reports/CA_SanFrancisco_20241105_sheet1_cvr_without_image.csv'.

By batch

'batch_images_found' counts images of the same batch that did match. 0 means the whole batch is missing.

batchid records card_1 batch_images_found precincts
00014_01410 1 0 77 98
00021_00554 1 0 124 70

By precinct

precinct records card_1
70 1 0
98 1 0

Images without a CVR record

Often a ballot_id form the CVR does not use. Full list: 'reports/CA_SanFrancisco_20241105_sheet1_images_without_cvr.csv'.

archive_basename batchid images
D01.zip 00033_00349 6
D02.zip 00014_01677 8
D04.zip 00014_01677 4
D04.zip 00035_00169 185
D04.zip 00035_00170 203
D06.zip 00014_01677 3
D07.zip 00014_01677 4
D08.zip 00014_01677 64

Election folder files the job does not read

Check each one for ballots in scope, such as a supplemental archive.

filename size
CVR_Export_20241202143051.zip 296,395,166
dsov.xlsx 1,245,065
sov.xlsx 6,583,157