United StatesFederal regulator recordsData Health & Coverage Center 2.1
Integrity failures, repairable warnings, and evidence-dependent advisories are reported separately. A limitation is never mislabeled as broken data.
Fix everything safely
Refreshes U.S. and Canadian official data, validates every relationship and release gate, and activates verified database generations immediately. No command window and no restart.
Licensed ABA coverage and unresolved exact duplicate review require authorized evidence. They remain advisories rather than pretending an unsafe automatic merge or unlicensed import is a repair.
Starting automatic repair of every safely actionable data issue…
U.S.: refreshing official regulator data silently…
U.S.: Starting complete U.S. regulator refresh…
U.S.: 1/6 Downloading newest official regulator packages
U.S.: Downloaded ncua-2026-03.zip (8,103,326 bytes)
U.S.: 2/6 Rebuilding FDIC institutions and every current office
U.S.: institutions: 4,255/4,255
U.S.: locations: 10,000/78,275
U.S.: locations: 20,000/78,275
U.S.: locations: 30,000/78,275
U.S.: locations: 40,000/78,275
U.S.: locations: 50,000/78,275
U.S.: locations: 60,000/78,275
U.S.: locations: 70,000/78,275
U.S.: locations: 78,275/78,275
U.S.: 3/6 Importing finalized NCUA credit unions, branches, and ATMs
U.S.: 4/6 Importing current OCC specialized institutions
U.S.: 5/6 Attaching complete official institution source records
U.S.: institutions: 4,255/4,255
U.S.: Reconciled stale U.S. current-source relationships: institutions=0, locations=0
U.S.: 6/6 Running integrity, orphan, and count-safety checks
U.S.: Sentinel gate: validating routing, maps, relationships, and canonical counts
U.S.: Sentinel gate PASS
U.S.: Checkpointing staged WAL into an isolated activation snapshot
U.S.: VERIFIED: refresh is ready for automatic live activation
U.S.: ACTIVATION READY: Bank Finder Pro will switch databases automatically
U.S.: {
U.S.: "status": "activation_ready",
U.S.: "completed_at": "2026-07-25T05:38:29.312658+00:00",
U.S.: "ncua_cycle": "2026-03",
U.S.: "occ_source": "downloaded",
U.S.: "relationship_cleanup": {
U.S.: "institution_source_records": 0,
U.S.: "location_source_records": 0
U.S.: },
U.S.: "before": {
U.S.: "integrity": "ok",
U.S.: "institutions": 9041,
U.S.: "locations": 121649,
U.S.: "atms": 17588,
U.S.: "orphan_locations": 0,
U.S.: "orphan_atms": 0,
U.S.: "orphan_aba": 0,
U.S.: "orphan_institution_sources": 0,
U.S.: "orphan_location_sources": 0
U.S.: },
U.S.: "after": {
U.S.: "integrity": "ok",
U.S.: "institutions": 9041,
U.S.: "locations": 121649,
U.S.: "atms": 17588,
U.S.: "orphan_locations": 0,
U.S.: "orphan_atms": 0,
U.S.: "orphan_aba": 0,
U.S.: "orphan_institution_sources": 0,
U.S.: "orphan_location_sources": 0
U.S.: },
U.S.: "activation_snapshot_verified": true,
U.S.: "pending_activation": {
U.S.: "status": "ready_for_live_activation",
U.S.: "created_at": "2026-07-25T05:38:29.194744+00:00",
U.S.: "country": "usa",
U.S.: "destination": "/var/lib/bank-finder-pro/data/generations/banks-20260725-053548-699944-canada-48ba12ecc7c9.db",
U.S.: "pending_database": "/var/lib/bank-finder-pro/data/generations/banks-20260725-053548-699944-canada-48ba12ecc7c9.db.pending",
U.S.: "pending_sha256": "091e7b19d673797b5834adcf090d1b097b42c173d58341413cd332bc1a0952e6",
U.S.: "counts": {
U.S.: "institutions": 9041,
U.S.: "locations": 121649,
U.S.: "atms": 17588,
U.S.: "aba_records": 1
U.S.: }
U.S.: }
U.S.: }
U.S.: Publishing the verified database as a new live generation…
U.S.: ACTIVATED: new searches now use the verified database. No restart required.
U.S.: verified data is active. No restart required.
Canada: refreshing official regulator data silently…
Canada: Starting complete Canadian regulator refresh…
Canada: 1/4 Downloading OSFI and Payments Canada releases
Canada: 2/4 Parsing every institution, routing branch, and official source record
Canada: 3/4 Confirming the U.S. database is byte-for-byte unchanged by count
Canada: 4/4 Running Sentinel release gate and activating verified Canadian data
Canada: Sentinel gate PASS
Canada: Checkpointing staged WAL into an isolated activation snapshot
Canada: VERIFIED: Canadian refresh is ready for automatic live activation
Canada: ACTIVATION READY: Bank Finder Pro will switch databases automatically
Canada: {
Canada: "status": "activation_ready",
Canada: "source_date": "2026-07-24",
Canada: "institutions": 403,
Canada: "locations": 20498,
Canada: "payments_records": 20417,
Canada: "osfi_deposit_takers": 131,
Canada: "osfi_matches": 50,
Canada: "orphan_locations": 0,
Canada: "cdic_members_matched": 43,
Canada: "payments_source": "downloaded",
Canada: "usa_counts_preserved": [
Canada: 8638,
Canada: 101151,
Canada: 17588
Canada: ],
Canada: "activation_snapshot_verified": true,
Canada: "pending_activation": {
Canada: "status": "ready_for_live_activation",
Canada: "created_at": "2026-07-25T05:38:47.406936+00:00",
Canada: "country": "canada",
Canada: "destination": "/var/lib/bank-finder-pro/data/generations/banks-20260725-053830-442214-usa-091e7b19d673.db",
Canada: "pending_database": "/var/lib/bank-finder-pro/data/generations/banks-20260725-053830-442214-usa-091e7b19d673.db.pending",
Canada: "pending_sha256": "a7110f0c7862bc7657291f89c4b6b77187d9f20b56f75f360d186669d7759546",
Canada: "counts": {
Canada: "institutions": 9041,
Canada: "locations": 121649,
Canada: "atms": 17588,
Canada: "aba_records": 1
Canada: }
Canada: }
Canada: }
Canada: Publishing the verified database as a new live generation…
Canada: ACTIVATED: new searches now use the verified database. No restart required.
Canada: verified data is active. No restart required.
Health: recalculating integrity, coverage, and release gates…
Repair complete: every safely actionable issue passed. Evidence- or license-dependent items remain clearly labeled as advisories.
PASS
All critical routing, map, scale, relationship, and database checks passed. Updates may activate.
Active ABA source and activation state
What the local datasets actually contain
SQLite integrity Release gate
The complete live database must pass SQLite's structural integrity check.
Verified directory scale Release gate
A release is blocked if institution or location counts collapse below the verified baseline.
Routing data foundation schema Release gate
The canonical ABA table must be protected by the versioned staging, provenance, activation-history, and rollback schema.
Active routing dataset provenance Release gate
The active ABA dataset requires a named provider, source type, version, license reference, artifact hash, and activation record.
Active routing dataset fingerprint Release gate
The live aba_routing rows must match the immutable dataset fingerprint and record count stored at activation.
Staged routing candidate blockers
Candidate imports remain isolated from live search until every format, checksum, duplicate, conflict, linkage, provenance, and count gate passes.
Active routing source scope Advisory
The current single-record verification baseline is honest but incomplete; complete coverage requires an authorized complete dataset.
Resolve ABA coverage →ABA routing dataset loaded Release gate
U.S. routing-number search is blocked when this table is empty.
FAIRWINDS routing regression Release gate
263181368 must exist exactly once and remain linked to NCUA institution 68417.
Exact routing-address map input Release gate
Google Maps must receive the routing record's exact 3087 N Alafaya Trail address.
Orphan relationship protection Release gate
Routing, location, ATM, and source records must retain valid parent relationships.
ABA format and checksum validation Release gate
Every ABA record must contain nine digits and pass the routing checksum.
Canadian routing format
Electronic routing identifiers should use the nine-digit 0YYYXXXXX representation.
U.S. ABA relationship coverage Advisory
Coverage is reported honestly; incomplete licensed ABA data does not silently appear complete.
Resolve ABA coverage →Location map readiness
A location is map-ready when the official record contains a street address and city.
Unresolved exact duplicate records
Exact duplicate locations are merged automatically only when every canonical field and source record agrees; any unresolved identity conflict remains in the evidence queue.
Canonical institution identity Release gate
Every canonical institution requires a name and country.
Open Advisory Resolution CenterOpen complete health report →
CanadaOfficial institution records