Difference between revisions of "Banks and Bankers Database - Data Review Status"

From Bank Note History
Jump to navigation Jump to search
m
 
(14 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The data in the Banks & Bankers Database is undergoing a 'Review' process to do  the following:
+
 
 +
'''''<big>NOTE: As of October 8, 2020, the data review process has been completed for all 14,348 National Banks in the Banks & Bankers Database.</big>'''''
 +
 
 +
 
 +
The National Bank data in the Banks & Bankers Database has undergone 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).
 
* 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 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''.
 
* 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.  
+
<!-- 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.
 
'''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.
 +
end of comment section -->
  
 
== Data Review Status - By State ==
 
== Data Review Status - By State ==
  
 
=== Fully Reviewed States ===
 
=== Fully Reviewed States ===
* Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, District of Columbia, Florida, Georgia, Hawaii, Idaho, Iowa, Louisiana, Maine, Maryland, Massachusetts, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Dakota, Oregon, Puerto Rico, Rhode Island, South Carolina, South Dakota, Tennessee, Utah, Vermont, Washington, Wisconsin, Wyoming.
+
* 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, Pennsylvania, Puerto Rico, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, Wyoming.
 
+
<!--
 
=== Partially Reviewed States ===
 
=== Partially Reviewed States ===
* ''In Progress:'' North Carolina, Ohio
+
* ''In Progress:'' Pennsylvania
 +
end of comment section -->
  
 
=== States not yet Reviewed ===
 
=== States not yet Reviewed ===
  
* Illinois, Indiana, Kansas, Kentucky, Michigan, Oklahoma, Pennsylvania, Texas, Virginia, West Virginia
+
* (None)
  
 
== What does 'Reviewed' mean? ==
 
== What does 'Reviewed' mean? ==

Latest revision as of 11:21, 16 December 2020

NOTE: As of October 8, 2020, the data review process has been completed for all 14,348 National Banks in the Banks & Bankers Database.


The National Bank data in the Banks & Bankers Database has undergone 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.


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, Pennsylvania, Puerto Rico, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, Wyoming.

States not yet Reviewed

  • (None)

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.