{"summary":{"institutions":9041,"usa_institutions":8638,"canada_institutions":403,"locations":121509,"usa_locations":101011,"canada_locations":20498,"atms":17588,"aba_records":1,"usa_with_aba":1,"malformed_aba":0,"orphan_aba":0,"orphan_locations":0,"orphan_atms":0,"orphan_institution_sources":0,"orphan_location_sources":0,"unnamed_institutions":0,"missing_country":0,"locations_missing_address":0,"map_ready_locations":117577,"institutions_missing_address":0,"institution_source_records":8994,"location_source_records":20417,"canada_routing_locations":20417,"malformed_canadian_routing":0,"usa_without_aba":8637,"fairwinds_test":1,"fairwinds_relationship":1,"fairwinds_address":1,"duplicate_location_records":0,"potential_duplicate_institutions":0,"last_verified_refresh":"2026-07-25T05:38:41.193076+00:00","verified_sources":4,"routing_source_count":1,"routing_import_runs":1,"routing_blocked_import_runs":0,"routing_staged_records":0,"routing_history_records":0,"routing_active_source":"Sentinel verified ABA baseline","routing_active_source_kind":"single_record_verification","routing_active_source_version":"2026-07-20","routing_active_dataset_sha256":"724ac742fe8f0d5671199354fd725814be39eb229dfa4326559412a430b9fef9","routing_last_activation":"2026-07-21T00:34:28.899590+00:00","integrity":"ok","foreign_key_issues":0,"invalid_aba_checksum":0,"valid_aba_checksum":1,"database_bytes":164065280,"database_megabytes":156.5},"coverage":{"usa_aba_relationships":0.01,"canadian_routing_locations":99.6,"location_map_readiness":96.76,"institution_source_payloads":99.48,"location_source_payloads":16.8},"routing_foundation":{"schema_present":true,"schema_version":1,"source_count":1,"import_run_count":1,"blocked_import_runs":0,"staged_records":0,"staged_invalid_records":0,"staged_duplicate_records":0,"staged_conflict_records":0,"staged_unlinked_records":0,"staged_review_records":0,"history_records":0,"active_source_id":"sentinel-verified-baseline-2026-07-20","active_source_name":"Sentinel verified ABA baseline","active_source_kind":"single_record_verification","active_source_version":"2026-07-20","active_source_provider":"Bank Finder Pro verified routing evidence","active_license_reference":"Per-record official-institution verification retained from Sentinel; no complete ABA dataset license claimed.","active_artifact_sha256":"724ac742fe8f0d5671199354fd725814be39eb229dfa4326559412a430b9fef9","active_dataset_sha256":"724ac742fe8f0d5671199354fd725814be39eb229dfa4326559412a430b9fef9","computed_dataset_sha256":"724ac742fe8f0d5671199354fd725814be39eb229dfa4326559412a430b9fef9","active_record_count":1,"computed_record_count":1,"active_activation_id":1,"last_activation_at":"2026-07-21T00:34:28.899590+00:00","provenance_complete":true,"dataset_hash_matches":true,"record_count_matches":true},"checks":[{"key":"sqlite_integrity","name":"SQLite integrity","status":"pass","value":"ok","detail":"The complete live database must pass SQLite's structural integrity check.","gate":true},{"key":"database_scale","name":"Verified directory scale","status":"pass","value":"9,041 / 121,509","detail":"A release is blocked if institution or location counts collapse below the verified baseline.","gate":true},{"key":"routing_foundation_schema","name":"Routing data foundation schema","status":"pass","value":"v1","detail":"The canonical ABA table must be protected by the versioned staging, provenance, activation-history, and rollback schema.","gate":true},{"key":"routing_provenance","name":"Active routing dataset provenance","status":"pass","value":"Sentinel verified ABA baseline","detail":"The active ABA dataset requires a named provider, source type, version, license reference, artifact hash, and activation record.","gate":true},{"key":"routing_dataset_fingerprint","name":"Active routing dataset fingerprint","status":"pass","value":"724ac742fe8f","detail":"The live aba_routing rows must match the immutable dataset fingerprint and record count stored at activation.","gate":true},{"key":"routing_candidate_blockers","name":"Staged routing candidate blockers","status":"pass","value":0,"detail":"Candidate imports remain isolated from live search until every format, checksum, duplicate, conflict, linkage, provenance, and count gate passes.","gate":false},{"key":"routing_source_scope","name":"Active routing source scope","status":"advisory","value":"single_record_verification","detail":"The current single-record verification baseline is honest but incomplete; complete coverage requires an authorized complete dataset.","gate":false,"remediation":{"label":"Resolve ABA coverage","url":"/advisories#aba-coverage","mode":"authorized_dataset"}},{"key":"aba_loaded","name":"ABA routing dataset loaded","status":"pass","value":1,"detail":"U.S. routing-number search is blocked when this table is empty.","gate":true},{"key":"fairwinds_regression","name":"FAIRWINDS routing regression","status":"pass","value":1,"detail":"263181368 must exist exactly once and remain linked to NCUA institution 68417.","gate":true},{"key":"fairwinds_address","name":"Exact routing-address map input","status":"pass","value":"Verified","detail":"Google Maps must receive the routing record's exact 3087 N Alafaya Trail address.","gate":true},{"key":"relationships","name":"Orphan relationship protection","status":"pass","value":0,"detail":"Routing, location, ATM, and source records must retain valid parent relationships.","gate":true},{"key":"aba_format","name":"ABA format and checksum validation","status":"pass","value":0,"detail":"Every ABA record must contain nine digits and pass the routing checksum.","gate":true},{"key":"canadian_routing_format","name":"Canadian routing format","status":"pass","value":0,"detail":"Electronic routing identifiers should use the nine-digit 0YYYXXXXX representation.","gate":false},{"key":"routing_coverage","name":"U.S. ABA relationship coverage","status":"advisory","value":"0.01%","detail":"Coverage is reported honestly; incomplete licensed ABA data does not silently appear complete.","gate":false,"remediation":{"label":"Resolve ABA coverage","url":"/advisories#aba-coverage","mode":"authorized_dataset"}},{"key":"map_readiness","name":"Location map readiness","status":"pass","value":"96.76%","detail":"A location is map-ready when the official record contains a street address and city.","gate":false},{"key":"duplicates","name":"Unresolved exact duplicate records","status":"pass","value":0,"detail":"Exact duplicate locations are merged automatically only when every canonical field and source record agrees; any unresolved identity conflict remains in the evidence queue.","gate":false,"remediation":{"label":"Open duplicate review","url":"/advisories/duplicates","mode":"evidence_review"}},{"key":"canonical_identity","name":"Canonical institution identity","status":"pass","value":0,"detail":"Every canonical institution requires a name and country.","gate":true}],"status":"healthy","failures":0,"warnings":0,"advisories":2,"release_gate":{"passed":true,"status":"PASS","blocking_checks":[]},"fairwinds_map_url":"https://www.google.com/maps/search/?api=1&query=3087+N+Alafaya+Trail%2C+Orlando%2C+FL%2C+32826%2C+United+States","generated_at":"2026-09-09T06:57:08.400360+00:00"}