MeridianMERIDIAN

ABA Routing Number

US ABA (American Bankers Association) routing transit number. 9-digit identifier for financial institutions in the US Federal Reserve system. First two digits are a valid Federal Reserve prefix (01-12, 21-32, 61-72, 80). The 9th digit is a weighted checksum (weights 3,7,1 repeating, sum mod 10 = 0).

ABA Routing Number

finance.banking.aba_routing

US ABA (American Bankers Association) routing transit number. 9-digit identifier for financial institutions in the US Federal Reserve system. First two digits are a valid Federal Reserve prefix (01-12, 21-32, 61-72, 80). The 9th digit is a weighted checksum (weights 3,7,1 repeating, sum mod 10 = 0).

Domain
finance
Category
banking
Casts to
VARCHAR
Scope
Locale-specific
Locales
EN_US

Try it

CLI
$ finetype infer -i "021000021"
→ finance.banking.aba_routing

DuckDB

Detect
SELECT finetype('021000021');
-- → 'finance.banking.aba_routing'
Cast expression
CAST({col} AS VARCHAR)
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'finance.banking.aba_routing';

Struct Expansion

Expression
check_digit: SUBSTRING({col}, 9, 1)
federal_reserve_district: SUBSTRING({col}, 1, 2)
institution_id: SUBSTRING({col}, 3, 4)

JSON Schema

finetype schema finance.banking.aba_routing
{
  "$id": "https://meridian.online/schemas/finance.banking.aba_routing",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "US ABA (American Bankers Association) routing transit number. 9-digit identifier for financial institutions in the US Federal Reserve system. First two digits are a valid Federal Reserve prefix (01-12, 21-32, 61-72, 80). The 9th digit is a weighted checksum (weights 3,7,1 repeating, sum mod 10 = 0).",
  "examples": [
    "021000021",
    "111000025",
    "021200025",
    "071000013",
    "011401533",
    "121000358"
  ],
  "pattern": "^(0[0-9]|1[0-2]|2[1-9]|3[0-2]|6[1-9]|7[0-2]|80)\\d{7}$",
  "title": "ABA Routing Number",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-pii": true,
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

021000021111000025021200025071000013011401533121000358

Aliases

routing_numberrouting_transit_numberaba_number

Type Registry