# FDIC-insured bank offices in Ohio: full CSV and office counts by bank (FDIC BankFind)

Observation only; public sources only; no contact with anyone.

## Results

- Source total (FDIC BankFind `/banks/locations`, `filters=STALP:OH`): **3038** offices, as `"total": 3038` in the `meta` block of S1 (also S2, S3, S4).
- CSV row count (header excluded) of `fdic-offices-oh.csv`: **3038**.
- Distinct UNINUM values in the CSV: 3038 (no UNINUM appears twice). Distinct banks (CERT): 188.
- CSV columns, in order: `UNINUM,CERT,NAME,OFFNAME,ADDRESS,CITY,COUNTY,STALP,ZIP,ESTYMD`.
- Every row has STALP = OH; no empty cells in any column.

## Data file (attached under Rule 25)

`fdic-offices-oh.csv`: 361394 bytes, 3038 data rows + 1 header row, UTF-8, comma-separated. Values are exactly as the source returned them (ESTYMD kept in the source's MM/DD/YYYY form). Rows are in ascending UNINUM order (the `sort_by=UNINUM&sort_order=ASC` used for stable paging).

```sha256
d1611b9c055087d59af586de3a3b0fbdbcb94ee42e8356b13e2fb836f115abba fdic-offices-oh.csv
```

## Top 10 banks by number of Ohio offices

A bank is one CERT; its office count is its number of rows in `fdic-offices-oh.csv` (not OFFNUM).

| Rank | CERT | Bank (NAME) | Ohio offices (CSV rows) | Source check: meta total for STALP:OH AND CERT |
|---|---|---|---|---|
| 1 | 6560 | The Huntington National Bank | 339 | 339 (S5) |
| 2 | 6672 | Fifth Third Bank, National Association | 245 | 245 (S6) |
| 3 | 628 | JPMorgan Chase Bank, National Association | 234 | 234 (S7) |
| 4 | 6384 | PNC Bank, National Association | 219 | 219 (S8) |
| 5 | 17534 | KeyBank National Association | 172 | 172 (S9) |
| 6 | 6548 | U.S. Bank National Association | 160 | 160 (S10) |
| 7 | 803 | WesBanco Bank, Inc. | 97 | 97 (S11) |
| 8 | 6653 | The Park National Bank | 76 | 76 (S12) |
| 9 | 23220 | Woodforest National Bank | 72 | 72 (S13) |
| 10 | 57957 | Citizens Bank, National Association | 69 | 69 (S14) |

Ties for 10th: none. 10th place is CERT 57957 with 69 offices; the next bank, CERT 6600 (First Financial Bank), has 67 offices (source check S15: 67).

## Method

1. Paged `https://api.fdic.gov/banks/locations` with `filters=STALP:OH`, `fields=UNINUM,CERT,NAME,OFFNAME,ADDRESS,CITY,COUNTY,STALP,ZIP,ESTYMD`, `sort_by=UNINUM`, `sort_order=ASC`, `limit=1000` and `offset` = 0, 1000, 2000, 3000 until the rows fetched reached the `meta.total` of 3038 (pages returned 1000, 1000, 1000, 38 rows = 3038). No API key.
2. Wrote one CSV row per returned record, columns in the order the job lists, values unchanged (the API's extra `ID` key was not written).
3. Counted CSV rows per CERT; ranked descending. As an independent check, queried the source once per listed bank with `filters=STALP:OH AND CERT:<cert>` (`limit=1`) and read `meta.total` (S5 onward); each equals the CSV count.

## Sources

Every request was an HTTP GET to host `api.fdic.gov`, endpoint `/banks/locations`, with the parameters shown. Excerpts are the first lines of each JSON response, pretty-printed with 2-space indentation, unchanged otherwise.

**S1. FDIC BankFind locations, Ohio, page offset 0** | Query: https://api.fdic.gov/banks/locations?filters=STALP:OH&fields=UNINUM,CERT,NAME,OFFNAME,ADDRESS,CITY,COUNTY,STALP,ZIP,ESTYMD&sort_by=UNINUM&sort_order=ASC&limit=1000&offset=0 | Parameters: filters=STALP:OH, fields=UNINUM,CERT,NAME,OFFNAME,ADDRESS,CITY,COUNTY,STALP,ZIP,ESTYMD, sort_by=UNINUM, sort_order=ASC, limit=1000, offset=0 | Retrieved: 2026-10-31T10:06:18Z | Rows returned: 1000

```json
{
  "meta": {
    "total": 3038,
    "parameters": {
      "filters": "STALP:OH",
      "fields": "UNINUM,CERT,NAME,OFFNAME,ADDRESS,CITY,COUNTY,STALP,ZIP,ESTYMD",
      "limit": "1000",
      "offset": "0"
    },
    "index": {
      "name": "locations_20261030090007",
      "createTimestamp": "2026-10-30T11:47:43Z"
    }
  },
  "data": [
    {
      "data": {
        "ZIP": "45631",
        "OFFNAME": "The Ohio Valley Bank Company",
        "CITY": "Gallipolis",
        "ADDRESS": "420 3rd Ave",
        "CERT": "384",
```

**S2. FDIC BankFind locations, Ohio, page offset 1000** | Query: https://api.fdic.gov/banks/locations?filters=STALP:OH&fields=UNINUM,CERT,NAME,OFFNAME,ADDRESS,CITY,COUNTY,STALP,ZIP,ESTYMD&sort_by=UNINUM&sort_order=ASC&limit=1000&offset=1000 | Parameters: filters=STALP:OH, fields=UNINUM,CERT,NAME,OFFNAME,ADDRESS,CITY,COUNTY,STALP,ZIP,ESTYMD, sort_by=UNINUM, sort_order=ASC, limit=1000, offset=1000 | Retrieved: 2026-10-31T10:06:19Z | Rows returned: 1000

```json
{
  "meta": {
    "total": 3038,
    "parameters": {
      "filters": "STALP:OH",
      "fields": "UNINUM,CERT,NAME,OFFNAME,ADDRESS,CITY,COUNTY,STALP,ZIP,ESTYMD",
      "limit": "1000",
      "offset": "1000"
    },
    "index": {
      "name": "locations_20261030090007",
      "createTimestamp": "2026-10-30T11:47:43Z"
    }
  },
  "data": [
    {
      "data": {
        "ZIP": "44202",
        "OFFNAME": "AURORA BRANCH",
        "CITY": "Aurora",
        "ADDRESS": "250 W Garfield Rd",
        "CERT": "628",
```

**S3. FDIC BankFind locations, Ohio, page offset 2000** | Query: https://api.fdic.gov/banks/locations?filters=STALP:OH&fields=UNINUM,CERT,NAME,OFFNAME,ADDRESS,CITY,COUNTY,STALP,ZIP,ESTYMD&sort_by=UNINUM&sort_order=ASC&limit=1000&offset=2000 | Parameters: filters=STALP:OH, fields=UNINUM,CERT,NAME,OFFNAME,ADDRESS,CITY,COUNTY,STALP,ZIP,ESTYMD, sort_by=UNINUM, sort_order=ASC, limit=1000, offset=2000 | Retrieved: 2026-10-31T10:06:20Z | Rows returned: 1000

```json
{
  "meta": {
    "total": 3038,
    "parameters": {
      "filters": "STALP:OH",
      "fields": "UNINUM,CERT,NAME,OFFNAME,ADDRESS,CITY,COUNTY,STALP,ZIP,ESTYMD",
      "limit": "1000",
      "offset": "2000"
    },
    "index": {
      "name": "locations_20261030090007",
      "createTimestamp": "2026-10-30T11:47:43Z"
    }
  },
  "data": [
    {
      "data": {
        "ZIP": "45459",
        "OFFNAME": "W. ALEX BELL ROAD BRANCH",
        "CITY": "Dayton",
        "ADDRESS": "2891 W Alex Bell Rd",
        "CERT": "6600",
```

**S4. FDIC BankFind locations, Ohio, page offset 3000** | Query: https://api.fdic.gov/banks/locations?filters=STALP:OH&fields=UNINUM,CERT,NAME,OFFNAME,ADDRESS,CITY,COUNTY,STALP,ZIP,ESTYMD&sort_by=UNINUM&sort_order=ASC&limit=1000&offset=3000 | Parameters: filters=STALP:OH, fields=UNINUM,CERT,NAME,OFFNAME,ADDRESS,CITY,COUNTY,STALP,ZIP,ESTYMD, sort_by=UNINUM, sort_order=ASC, limit=1000, offset=3000 | Retrieved: 2026-10-31T10:06:22Z | Rows returned: 38

```json
{
  "meta": {
    "total": 3038,
    "parameters": {
      "filters": "STALP:OH",
      "fields": "UNINUM,CERT,NAME,OFFNAME,ADDRESS,CITY,COUNTY,STALP,ZIP,ESTYMD",
      "limit": "1000",
      "offset": "3000"
    },
    "index": {
      "name": "locations_20261030090007",
      "createTimestamp": "2026-10-30T11:47:43Z"
    }
  },
  "data": [
    {
      "data": {
        "ZIP": "44106",
        "OFFNAME": "UNIVERSITY CIRCLE BRANCH",
        "CITY": "Cleveland",
        "ADDRESS": "11457 Mayfield Rd",
        "CERT": "7888",
```

**S5. FDIC BankFind locations, Ohio offices of CERT 6560** | Query: https://api.fdic.gov/banks/locations?filters=STALP:OH%20AND%20CERT:6560&fields=CERT,NAME&limit=1&offset=0 | Parameters: filters=STALP:OH AND CERT:6560, fields=CERT,NAME, limit=1, offset=0 | Retrieved: 2026-10-31T10:06:37Z | Response quoted whole

```json
{
  "meta": {
    "total": 339,
    "parameters": {
      "filters": "STALP:OH AND CERT:6560",
      "fields": "CERT,NAME",
      "limit": "1",
      "offset": "0"
    },
    "index": {
      "name": "locations_20261030090007",
      "createTimestamp": "2026-10-30T11:47:43Z"
    }
  },
  "data": [
    {
      "data": {
        "CERT": "6560",
        "NAME": "The Huntington National Bank",
        "ID": "11130"
      },
      "score": 0
    }
  ],
  "totals": {
    "count": 339
  }
}
```

**S6. FDIC BankFind locations, Ohio offices of CERT 6672** | Query: https://api.fdic.gov/banks/locations?filters=STALP:OH%20AND%20CERT:6672&fields=CERT,NAME&limit=1&offset=0 | Parameters: filters=STALP:OH AND CERT:6672, fields=CERT,NAME, limit=1, offset=0 | Retrieved: 2026-10-31T10:06:38Z | Response quoted whole

```json
{
  "meta": {
    "total": 245,
    "parameters": {
      "filters": "STALP:OH AND CERT:6672",
      "fields": "CERT,NAME",
      "limit": "1",
      "offset": "0"
    },
    "index": {
      "name": "locations_20261030090007",
      "createTimestamp": "2026-10-30T11:47:43Z"
    }
  },
  "data": [
    {
      "data": {
        "CERT": "6672",
        "NAME": "Fifth Third Bank, National Association",
        "ID": "13677"
      },
      "score": 0
    }
  ],
  "totals": {
    "count": 245
  }
}
```

**S7. FDIC BankFind locations, Ohio offices of CERT 628** | Query: https://api.fdic.gov/banks/locations?filters=STALP:OH%20AND%20CERT:628&fields=CERT,NAME&limit=1&offset=0 | Parameters: filters=STALP:OH AND CERT:628, fields=CERT,NAME, limit=1, offset=0 | Retrieved: 2026-10-31T10:06:39Z | Response quoted whole

```json
{
  "meta": {
    "total": 234,
    "parameters": {
      "filters": "STALP:OH AND CERT:628",
      "fields": "CERT,NAME",
      "limit": "1",
      "offset": "0"
    },
    "index": {
      "name": "locations_20261030090007",
      "createTimestamp": "2026-10-30T11:47:43Z"
    }
  },
  "data": [
    {
      "data": {
        "CERT": "628",
        "NAME": "JPMorgan Chase Bank, National Association",
        "ID": "1370"
      },
      "score": 0
    }
  ],
  "totals": {
    "count": 234
  }
}
```

**S8. FDIC BankFind locations, Ohio offices of CERT 6384** | Query: https://api.fdic.gov/banks/locations?filters=STALP:OH%20AND%20CERT:6384&fields=CERT,NAME&limit=1&offset=0 | Parameters: filters=STALP:OH AND CERT:6384, fields=CERT,NAME, limit=1, offset=0 | Retrieved: 2026-10-31T10:06:39Z | Response quoted whole

```json
{
  "meta": {
    "total": 219,
    "parameters": {
      "filters": "STALP:OH AND CERT:6384",
      "fields": "CERT,NAME",
      "limit": "1",
      "offset": "0"
    },
    "index": {
      "name": "locations_20261030090007",
      "createTimestamp": "2026-10-30T11:47:43Z"
    }
  },
  "data": [
    {
      "data": {
        "CERT": "6384",
        "NAME": "PNC Bank, National Association",
        "ID": "12054"
      },
      "score": 0
    }
  ],
  "totals": {
    "count": 219
  }
}
```

**S9. FDIC BankFind locations, Ohio offices of CERT 17534** | Query: https://api.fdic.gov/banks/locations?filters=STALP:OH%20AND%20CERT:17534&fields=CERT,NAME&limit=1&offset=0 | Parameters: filters=STALP:OH AND CERT:17534, fields=CERT,NAME, limit=1, offset=0 | Retrieved: 2026-10-31T10:06:40Z | Response quoted whole

```json
{
  "meta": {
    "total": 172,
    "parameters": {
      "filters": "STALP:OH AND CERT:17534",
      "fields": "CERT,NAME",
      "limit": "1",
      "offset": "0"
    },
    "index": {
      "name": "locations_20261030090007",
      "createTimestamp": "2026-10-30T11:47:43Z"
    }
  },
  "data": [
    {
      "data": {
        "CERT": "17534",
        "NAME": "KeyBank National Association",
        "ID": "11001"
      },
      "score": 0
    }
  ],
  "totals": {
    "count": 172
  }
}
```

**S10. FDIC BankFind locations, Ohio offices of CERT 6548** | Query: https://api.fdic.gov/banks/locations?filters=STALP:OH%20AND%20CERT:6548&fields=CERT,NAME&limit=1&offset=0 | Parameters: filters=STALP:OH AND CERT:6548, fields=CERT,NAME, limit=1, offset=0 | Retrieved: 2026-10-31T10:06:41Z | Response quoted whole

```json
{
  "meta": {
    "total": 160,
    "parameters": {
      "filters": "STALP:OH AND CERT:6548",
      "fields": "CERT,NAME",
      "limit": "1",
      "offset": "0"
    },
    "index": {
      "name": "locations_20261030090007",
      "createTimestamp": "2026-10-30T11:47:43Z"
    }
  },
  "data": [
    {
      "data": {
        "CERT": "6548",
        "NAME": "U.S. Bank National Association",
        "ID": "15374"
      },
      "score": 0
    }
  ],
  "totals": {
    "count": 160
  }
}
```

**S11. FDIC BankFind locations, Ohio offices of CERT 803** | Query: https://api.fdic.gov/banks/locations?filters=STALP:OH%20AND%20CERT:803&fields=CERT,NAME&limit=1&offset=0 | Parameters: filters=STALP:OH AND CERT:803, fields=CERT,NAME, limit=1, offset=0 | Retrieved: 2026-10-31T10:06:42Z | Response quoted whole

```json
{
  "meta": {
    "total": 97,
    "parameters": {
      "filters": "STALP:OH AND CERT:803",
      "fields": "CERT,NAME",
      "limit": "1",
      "offset": "0"
    },
    "index": {
      "name": "locations_20261030090007",
      "createTimestamp": "2026-10-30T11:47:43Z"
    }
  },
  "data": [
    {
      "data": {
        "CERT": "803",
        "NAME": "WesBanco Bank, Inc.",
        "ID": "13526"
      },
      "score": 0
    }
  ],
  "totals": {
    "count": 97
  }
}
```

**S12. FDIC BankFind locations, Ohio offices of CERT 6653** | Query: https://api.fdic.gov/banks/locations?filters=STALP:OH%20AND%20CERT:6653&fields=CERT,NAME&limit=1&offset=0 | Parameters: filters=STALP:OH AND CERT:6653, fields=CERT,NAME, limit=1, offset=0 | Retrieved: 2026-10-31T10:06:43Z | Response quoted whole

```json
{
  "meta": {
    "total": 76,
    "parameters": {
      "filters": "STALP:OH AND CERT:6653",
      "fields": "CERT,NAME",
      "limit": "1",
      "offset": "0"
    },
    "index": {
      "name": "locations_20261030090007",
      "createTimestamp": "2026-10-30T11:47:43Z"
    }
  },
  "data": [
    {
      "data": {
        "CERT": "6653",
        "NAME": "The Park National Bank",
        "ID": "1364"
      },
      "score": 0
    }
  ],
  "totals": {
    "count": 76
  }
}
```

**S13. FDIC BankFind locations, Ohio offices of CERT 23220** | Query: https://api.fdic.gov/banks/locations?filters=STALP:OH%20AND%20CERT:23220&fields=CERT,NAME&limit=1&offset=0 | Parameters: filters=STALP:OH AND CERT:23220, fields=CERT,NAME, limit=1, offset=0 | Retrieved: 2026-10-31T10:06:43Z | Response quoted whole

```json
{
  "meta": {
    "total": 72,
    "parameters": {
      "filters": "STALP:OH AND CERT:23220",
      "fields": "CERT,NAME",
      "limit": "1",
      "offset": "0"
    },
    "index": {
      "name": "locations_20261030090007",
      "createTimestamp": "2026-10-30T11:47:43Z"
    }
  },
  "data": [
    {
      "data": {
        "CERT": "23220",
        "NAME": "Woodforest National Bank",
        "ID": "457506"
      },
      "score": 0
    }
  ],
  "totals": {
    "count": 72
  }
}
```

**S14. FDIC BankFind locations, Ohio offices of CERT 57957** | Query: https://api.fdic.gov/banks/locations?filters=STALP:OH%20AND%20CERT:57957&fields=CERT,NAME&limit=1&offset=0 | Parameters: filters=STALP:OH AND CERT:57957, fields=CERT,NAME, limit=1, offset=0 | Retrieved: 2026-10-31T10:06:43Z | Response quoted whole

```json
{
  "meta": {
    "total": 69,
    "parameters": {
      "filters": "STALP:OH AND CERT:57957",
      "fields": "CERT,NAME",
      "limit": "1",
      "offset": "0"
    },
    "index": {
      "name": "locations_20261030090007",
      "createTimestamp": "2026-10-30T11:47:43Z"
    }
  },
  "data": [
    {
      "data": {
        "CERT": "57957",
        "NAME": "Citizens Bank, National Association",
        "ID": "267905"
      },
      "score": 0
    }
  ],
  "totals": {
    "count": 69
  }
}
```

**S15. FDIC BankFind locations, Ohio offices of CERT 6600** | Query: https://api.fdic.gov/banks/locations?filters=STALP:OH%20AND%20CERT:6600&fields=CERT,NAME&limit=1&offset=0 | Parameters: filters=STALP:OH AND CERT:6600, fields=CERT,NAME, limit=1, offset=0 | Retrieved: 2026-10-31T10:06:44Z | Response quoted whole

```json
{
  "meta": {
    "total": 67,
    "parameters": {
      "filters": "STALP:OH AND CERT:6600",
      "fields": "CERT,NAME",
      "limit": "1",
      "offset": "0"
    },
    "index": {
      "name": "locations_20261030090007",
      "createTimestamp": "2026-10-30T11:47:43Z"
    }
  },
  "data": [
    {
      "data": {
        "CERT": "6600",
        "NAME": "First Financial Bank",
        "ID": "185408"
      },
      "score": 0
    }
  ],
  "totals": {
    "count": 67
  }
}
```

## Data checks (computed over every row of fdic-offices-oh.csv)

- Header: `UNINUM,CERT,NAME,OFFNAME,ADDRESS,CITY,COUNTY,STALP,ZIP,ESTYMD` (10 columns).
- Data rows: 3038; source meta total: 3038.
- Duplicate UNINUM values: 0.
- Office counts per CERT for the banks listed above: 6560=339; 6672=245; 628=234; 6384=219; 17534=172; 6548=160; 803=97; 6653=76; 23220=72; 57957=69.