Banks and Bankers Database - Data Review Status

From Bank Note History
Jump to: navigation, search

The data in the Banks & Bankers Database is undergoing a 'Review' process to do the following:

  • Identify and fix data errors (this obviously won't find all of the errors, but will make a good first pass).
  • Review the Bank Officer Detail for each Bank in a State, to group the various name spellings and misspellings (OCC misreads) into one Bank Officer for that Bank.
  • Review the Bank Officer Names for a State, to group multi-bank Bank Officers into one Banker.

This data review is an on-going process. Reviewing can take as little as 1-2 minutes per Bank, or up to several minutes per Bank if multiple errors and discrepancies need to be researched. Listed below are the Fully Reviewed States, Partially Reviewed States (In Progress), and the States not yet Reviewed.

Important Note: If a State has not yet been Reviewed, all of the raw OCC bank officer data is still there and available for searching, but the various Bank Officer Name spellings/misspellings have not yet been grouped together, and the Banker records have not yet been created for Bankers that served in multiple Banks. So be sure to keep that in mind when you are searching data from Unreviewed States.

Data Review Status - By State

Fully Reviewed States

  • Alabama, Alaska, Arizona, Colorado, Connecticut, Delaware, District of Columbia, Florida, Hawaii, Idaho, Iowa, Maine, Maryland, Minnesota, Missouri, Montana, New Hampshire, New Mexico, Nevada, North Dakota, Puerto Rico, Rhode Island, South Carolina, South Dakota, Utah, Vermont, Wisconsin, Wyoming.

Partially Reviewed States

  • In Progress: Massachusetts, Ohio, Nebraska

States not yet Reviewed

  • Arkansas, California, Georgia, Illinois, Indiana, Kansas, Kentucky, Louisiana, Michigan, Mississippi, New Jersey, New York, North Carolina, Oklahoma, Oregon, Pennsylvania, Tennessee, Texas, Virginia, Washington, West Virginia

What does 'Reviewed' mean?

  • The Review process for each State includes 2 Parts:
    • Bank Review - This Reviews the Bank Officer Detail records for each Bank for possible errors, and groups the various spellings and misspellings (OCC misreads) into one Bank Officer for that Bank. To illustrate, shown below are screen shots (#1 & 2) of the Bank Officer search results Before and After a Bank has been Reviewed. In the Before screen shot, notice how Charles Mylius is listed several times in the search list, once under each different spelling and misspelling/misread of his name, with a fragmented Officer Summary for each. On the 'After' screen show, you can see the multiple listings for Mylius are now all grouped under one Bank Officer Name, with a unified Officer Summary. Also see screen shot (#3) of the 'Banker Info' page After the Review, showing the spellings/misspellings for that Bank Officer in the upper right hand corner of the screen.
    • Bank Officer/Banker Review - This Reviews the list of Bank Officer Names for a State to group multi-bank Bank Officers into one Banker. See screen shot (#3) below of the 'Banker Info' page After the Banker Review process, showing the multiple banks where this Banker served in the lower right hand corner.


Screen Shot #1: Bank Officer Search Results for Charles Mylius BEFORE Bank Review.


Screen Shot #2: Bank Officer Search Results for Charles Mylius AFTER Bank Review.


Screen Shot #3: Banker Information page for Charles Mylius AFTER Bank Review.