Banks and Bankers Database - Data Review Status

From Bank Note History
Revision as of 17:13, 20 July 2020 by Mdrengson (talk | contribs)
Jump to navigation Jump to 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, Arkansas, California, Colorado, Connecticut, Delaware, District of Columbia, Florida, Georgia, Hawaii, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, North Dakota, Ohio, Oklahoma, Oregon, Puerto Rico, Rhode Island, South Carolina, South Dakota, Tennessee, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, Wyoming.

Partially Reviewed States

  • In Progress: Texas

States not yet Reviewed

  • Pennsylvania

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 showing the Bank Officer Pairs and Bank Officer Search results Before and After a Bank has been Reviewed. In the Before list, notice how Vaughn and Bowersock are each listed several times, once under each different spelling and misspelling/misread of his name, with a fragmented Officer Summary for each. On the 'After' list, you can see the multiple entries for each banker are now 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 bank(s) where this Banker served in the lower right hand corner.

Screen Shot #1: Bank Officer Pairs BEFORE & AFTER Data Review.

Screen Shot #2: Bank Officer Search Results BEFORE & AFTER Data Review.

Screen Shot #3: Banker Information page for Hiram C. Vaughn AFTER Data Review showing Officer Name Variations and Bank(s) he served in.