title: Importing CSV table into SQL Server with Python pandas
body: <p>This is the largest help request I've ever written. My current process is to try to keep narrowing it down until I get the smallest code that can produce an error.</p>
  <p>I have downloaded the attributes_active csv table from <a href="https://www.ffiec.gov/npw/FinancialReport/DataDownload" rel="nofollow noreferrer">https://www.ffiec.gov/npw/FinancialReport/DataDownload</a> .</p>
  <p>I'm trying to load that into a table in SQL Server. It won't import directly (it eventually needs to be done automatically, so I need to figure out the python anyway). But it won't import directly.</p>
  <p>Interesting note: I can import this file directly into an MS Access database. It produces an error table. If I tell it that the double quote character is used for strings, then it imports with no errors.</p>
  <p>So I use it to produce the error table, and it tells me for example that row 53 is a problem (it's actually 54, if you include the header)</p>
  <p>The first few lines of the access import errors look like this:</p>
  <pre><code>Error   Field   Row
  Type Conversion Failure ORG_TYPE_CD 53
  Type Conversion Failure STATE_CD    53
  Type Conversion Failure ID_FDIC_CERT    53
  Type Conversion Failure SLHC_TYPE_IND   53
  Type Conversion Failure CNTRY_INC_CD    53
  Type Conversion Failure ORG_TYPE_CD 56
  Type Conversion Failure STATE_CD    56
  Type Conversion Failure ID_FDIC_CERT    56
  Type Conversion Failure SLHC_TYPE_IND   56
  Type Conversion Failure CNTRY_INC_CD    56
  Type Conversion Failure ORG_TYPE_CD 523
  Type Conversion Failure STATE_CD    523
  Type Conversion Failure ID_FDIC_CERT    523
  Type Conversion Failure SLHC_TYPE_IND   523
  Type Conversion Failure CNTRY_INC_CD    523
  Type Conversion Failure ID_FDIC_CERT    610
  Type Conversion Failure SLHC_TYPE_IND   610
  Type Conversion Failure CNTRY_INC_CD    610
  Type Conversion Failure ORG_TYPE_CD 714
  Type Conversion Failure STATE_CD    714
  Type Conversion Failure ID_FDIC_CERT    714
  Type Conversion Failure SLHC_TYPE_IND   714
  Type Conversion Failure CNTRY_INC_CD    714
  Type Conversion Failure ORG_TYPE_CD 759
  Type Conversion Failure STATE_CD    759
  Type Conversion Failure ID_FDIC_CERT    759
  Type Conversion Failure SLHC_TYPE_IND   759
  Type Conversion Failure CNTRY_INC_CD    759
  Type Conversion Failure ORG_TYPE_CD 796
  Type Conversion Failure STATE_CD    796
  Type Conversion Failure ID_FDIC_CERT    796
  Type Conversion Failure SLHC_TYPE_IND   796
  Type Conversion Failure CNTRY_INC_CD    796
  </code></pre>
  <p>The problem is I look at the raw text of those lines and those fields and there's nothing odd to distinguish them from the same fields in the adjacent lines. I do however think the fact that I get no import errors when I specifically tell access to use the double quote for strings is significant - but I'm doing the same thing for the pandas!</p>
  <p>I'm using the following code to try to read this into SQL Server:</p>
  <pre><code>def ingest_npw_attributes_active():
      filename = 'CSV_ATTRIBUTES_ACTIVE.CSV'
      full_filename = os.path.join(raw_data_dir, filename)
      print(full_filename)
      dt = {'AUTH_REG_DIST_FRS': int,
            'STREET_LINE2': &quot;string&quot;,
            'ID_THRIFT': &quot;string&quot;,
            'ID_TAX': int
            }
  
      init_connection()
      df = pd.read_csv(full_filename, dtype=dt, header=0, quotechar='&quot;')
  
      place_holder = &quot;?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,&quot;
      place_holder += &quot;?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?&quot;
      sql_str = &quot;exec dbo.save_attributes_active &quot; + place_holder
  
      # build assignment string for sql
      values = &quot;(&quot;
      for col_name in df.columns:
          values += &quot;row['&quot; + col_name + &quot;'], &quot;
      values = values[:-1] + &quot;)&quot;
  
      for index, row in df.iterrows():
        if index &lt; 2:
          print(row)
          values = (row['#ID_RSSD'], row['D_DT_START'], row['D_DT_END'], row['BHC_IND'], row['BROAD_REG_CD'],
                    row['CHTR_AUTH_CD'], row['CHTR_TYPE_CD'], row['FBO_4C9_IND'], row['FHC_IND'], row['FUNC_REG'],
                    row['INSUR_PRI_CD'], row['MBR_FHLBS_IND'], row['MBR_FRS_IND'], row['SEC_RPTG_STATUS'],
                    row['EST_TYPE_CD'], row['BANK_CNT'], row['BNK_TYPE_ANALYS_CD'], row['D_DT_EXIST_CMNC'],
                    row['D_DT_EXIST_TERM'], row['FISC_YREND_MMDD'], row['D_DT_INSUR'], row['D_DT_OPEN'],
                    row['FNCL_SUB_HOLDER'], row['FNCL_SUB_IND'], row['IBA_GRNDFTHR_IND'], row['IBF_IND'],
                    row['ID_RSSD_HD_OFF'], row['MJR_OWN_MNRTY'], row['NM_LGL'], row['NM_SHORT'], row['NM_SRCH_CD'],
                    row['ORG_TYPE_CD'], row['REASON_TERM_CD'], row['CNSRVTR_CD'], row['ENTITY_TYPE'],
                    row['AUTH_REG_DIST_FRS'], row['ACT_PRIM_CD'], row['CITY'], row['CNTRY_NM'], row['ID_CUSIP'],
                    row['STATE_ABBR_NM'], row['PLACE_CD'], row['STATE_CD'], row['STATE_HOME_CD'], row['STREET_LINE1'],
                    row['STREET_LINE2'], row['ZIP_CD'], row['ID_THRIFT'], row['ID_THRIFT_HC'], row['DOMESTIC_IND'],
                    row['ID_ABA_PRIM'], row['ID_FDIC_CERT'], row['ID_NCUA'], row['COUNTY_CD'], row['DIST_FRS'],
                    row['ID_OCC'], row['CNTRY_CD'], row['DT_END'], row['DT_EXIST_CMNC'], row['DT_EXIST_TERM'],
                    row['DT_INSUR'], row['DT_OPEN'], row['DT_START'], row['ID_TAX'], row['PROV_REGION'], row['URL'],
                    row['SLHC_IND'], row['SLHC_TYPE_IND'], row['PRIM_FED_REG'], row['STATE_INC_CD'], row['CNTRY_INC_CD'],
                    row['STATE_INC_ABBR_NM'], row['CNTRY_INC_NM'], row['ID_LEI'], row['IHC_IND'])
  
      # print(values)
      return_key = cursor.execute(sql_str, values).fetchval()
      print('return_key =', return_key)
  
      conn.close()
      return
  </code></pre>
  <p>I have the SQL Server table defined as follows:</p>
  <pre><code>SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  CREATE TABLE [dbo].[npwAttributesActive]
  (
      [id] [bigint] IDENTITY(1,1) NOT NULL,
      [ID_RSSD] [int] NOT NULL,
      [D_DT_START] [nvarchar](50) NULL,
      [D_DT_END] [nvarchar](50) NULL,
      [BHC_IND] [int] NULL,
      [BROAD_REG_CD] [int] NULL,
      [CHTR_AUTH_CD] [int] NULL,
      [CHTR_TYPE_CD] [int] NULL,
      [FBO_4C9_IND] [int] NULL,
      [FHC_IND] [int] NULL,
      [FUNC_REG] [int] NULL,
      [INSUR_PRI_CD] [int] NULL,
      [MBR_FHLBS_IND] [int] NULL,
      [MBR_FRS_IND] [int] NULL,
      [SEC_RPTG_STATUS] [int] NULL,
      [EST_TYPE_CD] [int] NULL,
      [BANK_CNT] [nvarchar](1) NULL,
      [BNK_TYPE_ANALYS_CD] [int] NULL,
      [D_DT_EXIST_CMNC] [nvarchar](50) NULL,
      [D_DT_EXIST_TERM] [nvarchar](50) NULL,
      [FISC_YREND_MMDD] [int] NULL,
      [D_DT_INSUR] [nvarchar](50) NULL,
      [D_DT_OPEN] [nvarchar](50) NULL,
      [FNCL_SUB_HOLDER] [int] NULL,
      [FNCL_SUB_IND] [int] NULL,
      [IBA_GRNDFTHR_IND] [int] NULL,
      [IBF_IND] [int] NULL,
      [ID_RSSD_HD_OFF] [int] NULL,
      [MJR_OWN_MNRTY] [int] NULL,
      [NM_LGL] [nvarchar](150) NULL,
      [NM_SHORT] [nvarchar](50) NULL,
      [NM_SRCH_CD] [int] NULL,
      [ORG_TYPE_CD] [int] NULL,
      [REASON_TERM_CD] [int] NULL,
      [CNSRVTR_CD] [int] NULL,
      [ENTITY_TYPE] [nvarchar](50) NULL,
      [AUTH_REG_DIST_FRS] [int] NULL,
      [ACT_PRIM_CD] [nvarchar](50) NULL,
      [CITY] [nvarchar](50) NULL,
      [CNTRY_NM] [nvarchar](50) NULL,
      [ID_CUSIP] [nvarchar](50) NULL,
      [STATE_ABBR_NM] [nvarchar](50) NULL,
      [PLACE_CD] [int] NULL,
      [STATE_CD] [int] NULL,
      [STATE_HOME_CD] [int] NULL,
      [STREET_LINE1] [nvarchar](50) NULL,
      [STREET_LINE2] [nvarchar](50) NULL,
      [ZIP_CD] [nvarchar](50) NULL,
      [ID_THRIFT] [int] NULL,
      [ID_THRIFT_HC] [nvarchar](50) NULL,
      [DOMESTIC_IND] [nvarchar](50) NULL,
      [ID_ABA_PRIM] [int] NULL,
      [ID_FDIC_CERT] [int] NULL,
      [ID_NCUA] [int] NULL,
      [COUNTY_CD] [int] NULL,
      [DIST_FRS] [int] NULL,
      [ID_OCC] [int] NULL,
      [CNTRY_CD] [int] NULL,
      [DT_END] [int] NULL,
      [DT_EXIST_CMNC] [int] NULL,
      [DT_EXIST_TERM] [int] NULL,
      [DT_INSUR] [int] NULL,
      [DT_OPEN] [int] NULL,
      [DT_START] [int] NULL,
      [ID_TAX] [int] NULL,
      [PROV_REGION] [nvarchar](50) NULL,
      [URL] [nvarchar](50) NULL,
      [SLHC_IND] [int] NULL,
      [SLHC_TYPE_IND] [int] NULL,
      [PRIM_FED_REG] [nvarchar](50) NULL,
      [STATE_INC_CD] [int] NULL,
      [CNTRY_INC_CD] [int] NULL,
      [STATE_INC_ABBR_NM] [nvarchar](50) NULL,
      [CNTRY_INC_NM] [nvarchar](50) NULL,
      [ID_LEI] [nvarchar](50) NULL,
      [IHC_IND] [int] NULL
  ) ON [PRIMARY]
  </code></pre>
  <p>The stored procedure is</p>
  <pre><code>SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  
  ALTER PROCEDURE [dbo].[save_attributes_active]
      @ID_RSSD       int,
      @D_DT_START    nvarchar(50),
      @D_DT_END      nvarchar(50),
      @BHC_IND       int,
      @BROAD_REG_CD  int,
      @CHTR_AUTH_CD  int,
      @CHTR_TYPE_CD  int,
      @FBO_4C9_IND   int,
      @FHC_IND       int,
      @FUNC_REG      int,
      @INSUR_PRI_CD  int,
      @MBR_FHLBS_IND      int,
      @MBR_FRS_IND        int,
      @SEC_RPTG_STATUS    int,
      @EST_TYPE_CD        int,
      @BANK_CNT           nvarchar(1),
      @BNK_TYPE_ANALYS_CD int,
      @D_DT_EXIST_CMNC    nvarchar(50),
      @D_DT_EXIST_TERM    nvarchar(50),
      @FISC_YREND_MMDD    int,
      @D_DT_INSUR         nvarchar(50),
      @D_DT_OPEN          nvarchar(50),
      @FNCL_SUB_HOLDER    int,
      @FNCL_SUB_IND       int,
      @IBA_GRNDFTHR_IND   int,
      @IBF_IND            int,
      @ID_RSSD_HD_OFF     int,
      @MJR_OWN_MNRTY      int,
      @NM_LGL             nvarchar(150),
      @NM_SHORT           nvarchar(50),
      @NM_SRCH_CD         int,
      @ORG_TYPE_CD        int,
      @REASON_TERM_CD     int,
      @CNSRVTR_CD         int,
      @ENTITY_TYPE        nvarchar(50),
      @AUTH_REG_DIST_FRS  int,
      @ACT_PRIM_CD        nvarchar(50),
      @CITY               nvarchar(50),
      @CNTRY_NM           nvarchar(50),
      @ID_CUSIP           nvarchar(50),
      @STATE_ABBR_NM      nvarchar(50),
      @PLACE_CD           int,
      @STATE_CD           int,
      @STATE_HOME_CD      int,
      @STREET_LINE1       nvarchar(50),
      @STREET_LINE2       nvarchar(50),
      @ZIP_CD             nvarchar(50),
      @ID_THRIFT          int,
      @ID_THRIFT_HC       nvarchar(50),
      @DOMESTIC_IND       nvarchar(50),
      @ID_ABA_PRIM        int,
      @ID_FDIC_CERT       int,
      @ID_NCUA            int,
      @COUNTY_CD          int,
      @DIST_FRS           int,
      @ID_OCC             int,
      @CNTRY_CD           int,
      @DT_END             int,
      @DT_EXIST_CMNC      int,
      @DT_EXIST_TERM      int,
      @DT_INSUR           int,
      @DT_OPEN            int,
      @DT_START           int,
      @ID_TAX             int,
      @PROV_REGION        nvarchar(50),
      @URL                nvarchar(50),
      @SLHC_IND           int,
      @SLHC_TYPE_IND      int,
      @PRIM_FED_REG       nvarchar(50),
      @STATE_INC_CD       int,
      @CNTRY_INC_CD       int,
      @STATE_INC_ABBR_NM  nvarchar(50),
      @CNTRY_INC_NM       nvarchar(50),
      @ID_LEI             nvarchar(50),
      @IHC_IND            int
  AS
  BEGIN
      SET NOCOUNT ON;
  
      INSERT INTO dbo.npwAttributesActive ([ID_RSSD], [D_DT_START], [D_DT_END], [BHC_IND], [BROAD_REG_CD], [CHTR_AUTH_CD], [CHTR_TYPE_CD], [FBO_4C9_IND], [FHC_IND], [FUNC_REG], [INSUR_PRI_CD],
           [MBR_FHLBS_IND], [MBR_FRS_IND], [SEC_RPTG_STATUS], [EST_TYPE_CD], [BANK_CNT], [BNK_TYPE_ANALYS_CD], [D_DT_EXIST_CMNC], [D_DT_EXIST_TERM], [FISC_YREND_MMDD], [D_DT_INSUR], [D_DT_OPEN], 
           [FNCL_SUB_HOLDER], [FNCL_SUB_IND], [IBA_GRNDFTHR_IND], [IBF_IND], [ID_RSSD_HD_OFF], [MJR_OWN_MNRTY], [NM_LGL], [NM_SHORT], [NM_SRCH_CD], [ORG_TYPE_CD], [REASON_TERM_CD], [CNSRVTR_CD], 
           [ENTITY_TYPE], [AUTH_REG_DIST_FRS], [ACT_PRIM_CD], [CITY], [CNTRY_NM], [ID_CUSIP], [STATE_ABBR_NM], [PLACE_CD], [STATE_CD], [STATE_HOME_CD], [STREET_LINE1], [STREET_LINE2], [ZIP_CD], 
           [ID_THRIFT], [ID_THRIFT_HC], [DOMESTIC_IND], [ID_ABA_PRIM], [ID_FDIC_CERT], [ID_NCUA], [COUNTY_CD], [DIST_FRS], [ID_OCC], [CNTRY_CD], [DT_END], [DT_EXIST_CMNC], [DT_EXIST_TERM], [DT_INSUR],
           [DT_OPEN], [DT_START], [ID_TAX], [PROV_REGION], [URL], [SLHC_IND], [SLHC_TYPE_IND], [PRIM_FED_REG], [STATE_INC_CD], [CNTRY_INC_CD],
           [STATE_INC_ABBR_NM], [CNTRY_INC_NM], [ID_LEI], [IHC_IND] ) 
      VALUES (@ID_RSSD, @D_DT_START, @D_DT_END, @BHC_IND, @BROAD_REG_CD, @CHTR_AUTH_CD, @CHTR_TYPE_CD, @FBO_4C9_IND, @FHC_IND, @FUNC_REG, @INSUR_PRI_CD,
          @MBR_FHLBS_IND, @MBR_FRS_IND, @SEC_RPTG_STATUS, @EST_TYPE_CD, @BANK_CNT, @BNK_TYPE_ANALYS_CD, @D_DT_EXIST_CMNC, @D_DT_EXIST_TERM, @FISC_YREND_MMDD,
          @D_DT_INSUR, @D_DT_OPEN, @FNCL_SUB_HOLDER, @FNCL_SUB_IND, @IBA_GRNDFTHR_IND, @IBF_IND, @ID_RSSD_HD_OFF, @MJR_OWN_MNRTY, @NM_LGL, @NM_SHORT, @NM_SRCH_CD, 
          @ORG_TYPE_CD, @REASON_TERM_CD, @CNSRVTR_CD, @ENTITY_TYPE, @AUTH_REG_DIST_FRS, @ACT_PRIM_CD, @CITY, @CNTRY_NM, @ID_CUSIP, @STATE_ABBR_NM, @PLACE_CD, @STATE_CD,
          @STATE_HOME_CD, @STREET_LINE1, @STREET_LINE2, @ZIP_CD, @ID_THRIFT, @ID_THRIFT_HC, @DOMESTIC_IND, @ID_ABA_PRIM, @ID_FDIC_CERT, @ID_NCUA, @COUNTY_CD, @DIST_FRS,
          @ID_OCC, @CNTRY_CD, @DT_END, @DT_EXIST_CMNC, @DT_EXIST_TERM, @DT_INSUR, @DT_OPEN, @DT_START, @ID_TAX, @PROV_REGION, @URL, @SLHC_IND, @SLHC_TYPE_IND,
          @PRIM_FED_REG, @STATE_INC_CD, @CNTRY_INC_CD, @STATE_INC_ABBR_NM, @CNTRY_INC_NM, @ID_LEI, @IHC_IND
      )
  
      SELECT 1
  END
  </code></pre>
  <p>However, I'm getting the following error:</p>
  <pre><code>Traceback (most recent call last):
    File &quot;C:/Users/kgreen/Source/Repos/MapTools/ingest_source.py&quot;, line 142, in &lt;module&gt;
      main()
    File &quot;C:/Users/kgreen/Source/Repos/MapTools/ingest_source.py&quot;, line 136, in main
      ingest_npw_data()
    File &quot;C:/Users/kgreen/Source/Repos/MapTools/ingest_source.py&quot;, line 130, in ingest_npw_data
      ingest_npw_attributes_active()
    File &quot;C:/Users/kgreen/Source/Repos/MapTools/ingest_source.py&quot;, line 122, in ingest_npw_attributes_active
      return_key = cursor.execute(sql_str, values).fetchval()
  pyodbc.ProgrammingError: ('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 19 (&quot;&quot;): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision. (8023) (SQLExecDirectW)')
  </code></pre>
  <p>Addendum
  First few lines of the CSV</p>
  <pre><code>#ID_RSSD,D_DT_START,D_DT_END,BHC_IND,BROAD_REG_CD,CHTR_AUTH_CD,CHTR_TYPE_CD,FBO_4C9_IND,FHC_IND,FUNC_REG,INSUR_PRI_CD,MBR_FHLBS_IND,MBR_FRS_IND,SEC_RPTG_STATUS,EST_TYPE_CD,BANK_CNT,BNK_TYPE_ANALYS_CD,D_DT_EXIST_CMNC,D_DT_EXIST_TERM,FISC_YREND_MMDD,D_DT_INSUR,D_DT_OPEN,FNCL_SUB_HOLDER,FNCL_SUB_IND,IBA_GRNDFTHR_IND,IBF_IND,ID_RSSD_HD_OFF,MJR_OWN_MNRTY,NM_LGL,NM_SHORT,NM_SRCH_CD,ORG_TYPE_CD,REASON_TERM_CD,CNSRVTR_CD,ENTITY_TYPE,AUTH_REG_DIST_FRS,ACT_PRIM_CD,CITY,CNTRY_NM,ID_CUSIP,STATE_ABBR_NM,PLACE_CD,STATE_CD,STATE_HOME_CD,STREET_LINE1,STREET_LINE2,ZIP_CD,ID_THRIFT,ID_THRIFT_HC,DOMESTIC_IND,ID_ABA_PRIM,ID_FDIC_CERT,ID_NCUA,COUNTY_CD,DIST_FRS,ID_OCC,CNTRY_CD,DT_END,DT_EXIST_CMNC,DT_EXIST_TERM,DT_INSUR,DT_OPEN,DT_START,ID_TAX,PROV_REGION,URL,SLHC_IND,SLHC_TYPE_IND,PRIM_FED_REG,STATE_INC_CD,CNTRY_INC_CD,STATE_INC_ABBR_NM,CNTRY_INC_NM,ID_LEI,IHC_IND
  37,&quot;04/15/2009 00:00:00&quot;,&quot;12/31/9999 00:00:00&quot;,0,1,2,200,0,0,0,7,1,0,0,1,,0,,&quot;12/31/9999 00:00:00&quot;,0,&quot;01/01/1934 00:00:00&quot;,&quot;09/01/1904 00:00:00&quot;,0,0,0,0,0,0,&quot;BANK OF HANCOCK COUNTY                                                                                                  &quot;,&quot;BANK OF HANCOCK CTY           &quot;,1072861144,1,0,0,&quot;NMB&quot;,6,&quot;52211 &quot;,&quot;SPARTA&quot;,&quot;UNITED STATES                           &quot;,&quot;0&quot;,&quot;GA&quot;,72584,13,0,&quot;12855 BROAD STREET&quot;,&quot;0&quot;,&quot;31087    &quot;,16553,&quot;0&quot;,&quot;Y&quot;,61107146,10057,0,141,6,0,1007,99991231,0,99991231,19340101,19040901,20090415,0,&quot;0&quot;,&quot;0&quot;,0,0,&quot;FDIC&quot;,0,0,&quot;0 &quot;,&quot;&quot;,&quot;0&quot;,0
  73,&quot;12/31/2008 00:00:00&quot;,&quot;12/31/9999 00:00:00&quot;,0,2,1,330,0,0,0,3,0,0,0,1,,0,,&quot;12/31/9999 00:00:00&quot;,0,&quot;01/04/1971 00:00:00&quot;,&quot;01/01/1936 00:00:00&quot;,0,0,0,0,0,0,&quot;UTILITY EMPLOYEES FEDERAL CREDIT UNION                                                                                  &quot;,&quot;UTILITY EMPL FCU              &quot;,788018087,6,0,0,&quot;FCU&quot;,12,&quot;52213 &quot;,&quot;HOQUIAM&quot;,&quot;UNITED STATES                           &quot;,&quot;0&quot;,&quot;WA&quot;,0,53,0,&quot;220 MYRTLE STREET&quot;,&quot;0&quot;,&quot;98550    &quot;,0,&quot;0&quot;,&quot;Y&quot;,325179988,0,1851,27,12,0,1007,99991231,0,99991231,19710104,19360101,20081231,910591861,&quot;0&quot;,&quot;0&quot;,0,0,&quot;NCUA&quot;,0,0,&quot;0 &quot;,&quot;&quot;,&quot;0&quot;,0
  242,&quot;01/01/2012 00:00:00&quot;,&quot;12/31/9999 00:00:00&quot;,0,1,2,200,0,0,0,7,1,1,0,1,,0,,&quot;12/31/9999 00:00:00&quot;,0,&quot;01/01/1934 00:00:00&quot;,&quot;01/01/1922 00:00:00&quot;,0,0,0,0,0,0,&quot;FIRST COMMUNITY BANK XENIA-FLORA                                                                                        &quot;,&quot;FIRST CMNTY BK XENIA FLORA    &quot;,574907456,1,0,0,&quot;SMB&quot;,8,&quot;52211 &quot;,&quot;XENIA&quot;,&quot;UNITED STATES                           &quot;,&quot;0&quot;,&quot;IL&quot;,83739,17,0,&quot;260 FRONT STREET&quot;,&quot;0&quot;,&quot;62899    &quot;,0,&quot;0&quot;,&quot;Y&quot;,81220537,3850,0,25,8,0,1007,99991231,0,99991231,19340101,19220101,20120101,370274860,&quot;0&quot;,&quot;WWW.FCBXENIAFLORA.COM/INDEX.HTML&quot;,0,0,&quot;FRS&quot;,17,0,&quot;IL&quot;,&quot;&quot;,&quot;0&quot;,0
  279,&quot;01/01/2012 00:00:00&quot;,&quot;12/31/9999 00:00:00&quot;,0,1,2,300,0,0,0,7,1,0,0,1,,0,,&quot;12/31/9999 00:00:00&quot;,0,&quot;01/01/1997 00:00:00&quot;,&quot;01/01/1934 00:00:00&quot;,0,0,0,0,0,0,&quot;MINEOLA COMMUNITY BANK, SSB                                                                                             &quot;,&quot;MINEOLA CMNTY BK SSB          &quot;,98889854,6,0,0,&quot;SSB&quot;,11,&quot;52211 &quot;,&quot;MINEOLA&quot;,&quot;UNITED STATES                           &quot;,&quot;0&quot;,&quot;TX&quot;,48648,48,0,&quot;215 W BROAD&quot;,&quot;0&quot;,&quot;75773    &quot;,2523,&quot;0&quot;,&quot;Y&quot;,311972526,28868,0,499,11,0,1007,99991231,0,99991231,19970101,19340101,20120101,750440734,&quot;0&quot;,&quot;0&quot;,0,0,&quot;FDIC&quot;,48,0,&quot;TX&quot;,&quot;&quot;,&quot;0&quot;,0
  354,&quot;12/04/2019 00:00:00&quot;,&quot;12/31/9999 00:00:00&quot;,0,1,2,200,0,0,0,7,0,0,0,1,,0,&quot;01/01/1901 00:00:00&quot;,&quot;12/31/9999 00:00:00&quot;,0,&quot;03/21/1934 00:00:00&quot;,&quot;01/01/1901 00:00:00&quot;,0,0,0,0,0,0,&quot;BISON STATE BANK                                                                                                        &quot;,&quot;BISON ST BK                   &quot;,715161421,1,0,0,&quot;NMB&quot;,10,&quot;52211 &quot;,&quot;BISON&quot;,&quot;UNITED STATES                           &quot;,&quot;0&quot;,&quot;KS&quot;,6950,20,0,&quot;223 MAIN STREET&quot;,&quot;0&quot;,&quot;67520    &quot;,0,&quot;0&quot;,&quot;Y&quot;,101107475,14083,0,165,10,0,1007,99991231,19010101,99991231,19340321,19010101,20191204,0,&quot;0&quot;,&quot;0&quot;,0,0,&quot;FDIC&quot;,0,0,&quot;0 &quot;,&quot;&quot;,&quot;0&quot;,0
  </code></pre>