Home

Filer ID: 1144328

Table: filer_address
filer_id   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328
adrid   1110262   2011957   2041417   2079180   2114472   2162785   2205547   2415578   2471329   2275973   2510122   2551653   2338776
effect_dt   1999-01-01 00:00:00   2001-01-01 00:00:00   2003-01-01 00:00:00   2005-01-01 00:00:00   2007-01-01 00:00:00   2009-01-01 00:00:00   2011-01-01 00:00:00   2017-01-01 00:00:00   2019-01-16 00:00:00   2013-01-01 00:00:00   2021-01-01 00:00:00   2023-01-01 00:00:00   2015-01-01 00:00:00
add_type   7050   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051
session_id   1999   2001   2003   2005   2007   2009   2011   2017   2019   2013   2021   2023   2015
Table: filer_filings
filer_id   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328
filing_id   470710   471519   482618   481795   465468   466265   477069   488937   492628   485325   497209   496263   493590   486200   489883   480085   468961   474494   476239   627035   616428   681290   652990   718571   693106   709001   730696   756702   745210   740037   781718   792052   784559   773511   813918   797310   845191   819256   835520   850749   862511   840725   881379   891703   914338   896568   910336   929728   932685   946568   968344   988305   974817   956917   999641   1032833   1029672   1012332   1017385   1064215   1057519   1081090   1090972   1092804   1117524   1104308   1131804   1146849   1164175   1188281   1212296   1234273   1284202   1232321   1260908   1783972   1982029   1966148   1800930   1951550   1935502   1912223   1297353   1328274   1284202   1297353   1311036   1350487   1376764   1409509   1395859   1420512   1436998   1463429   1451607   1484254   1504789   1538237   1570221   1559191   1590815   1605921   1620579   1634706   1656454   1675398   1819171   1708057   1872854   1737891   1743831   1846085   1765097   2004020   2239732   2391283   2191627   2204320   2547127   2318956   2430338   2271771   1997601   2037527   2062513   2067540   2101021   2101021   2125277   2117888   2153638   2137994   2170410   2531019   2375050   2479652   2345167   2537797   2387416   2372070   2470034   2415464   2574987   2702506   2621795   2676175   2596839   2559273   2637725   2739349
period_id   142   150   152   144   141   149   151   146   147   145   156   148   155   153   154   159   157   158   143   161   160   163   162   164   163   None   162   165   165   164   None   167   None   166   168   None   None   None   169   170   None   None   171   None   None   None   172   173   None   174   175   176   None   None   None   None   178   177   None   None   179   180   None   None   182   181   183   184   185   186   187   188   190   None   189   214   222   221   215   None   220   219   191   193   190   191   192   194   195   None   196   197   198   200   199   201   202   203   204   None   205   206   207   208   209   210   216   211   218   212   None   217   213   224   233   238   231   232   244   235   240   234   223   225   226   None   227   227   228   229   229   None   230   243   237   242   236   245   None   None   241   239   245   250   247   249   246   None   248   251
form_id   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F690   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F690   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F602   F635   F602   F635   F635   F635   F635   F635   F602   F602   F602   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635
filing_sequence   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
filing_date   1995-07-21 00:00:00   1997-07-16 00:00:00   1998-01-23 00:00:00   1996-01-29 00:00:00   1995-04-28 00:00:00   1997-04-11 00:00:00   1997-10-20 00:00:00   1996-07-17 00:00:00   1996-10-23 00:00:00   1996-04-12 00:00:00   1999-01-29 00:00:00   1997-01-27 00:00:00   1998-10-19 00:00:00   1998-04-17 00:00:00   1998-07-22 00:00:00   1999-11-01 00:00:00   1999-04-30 00:00:00   1999-08-02 00:00:00   1995-10-25 00:00:00   2000-05-01 00:00:00   2000-01-31 00:00:00   2000-10-30 00:00:00   2000-07-31 00:00:00   2001-01-31 00:00:00   2000-10-30 00:00:00   2001-01-03 00:00:00   2000-08-08 00:00:00   2001-04-30 00:00:00   2001-04-28 00:00:00   2001-01-31 00:00:00   2001-07-31 00:00:00   2001-10-31 00:00:00   2001-10-01 00:00:00   2001-07-31 00:00:00   2002-01-31 00:00:00   2001-10-31 00:00:00   2002-04-30 00:00:00   2002-01-31 00:00:00   2002-04-16 00:00:00   2002-07-22 00:00:00   2002-07-30 00:00:00   2002-04-22 00:00:00   2002-10-28 00:00:00   2002-10-31 00:00:00   2003-01-31 00:00:00   2002-12-09 00:00:00   2003-01-30 00:00:00   2003-04-28 00:00:00   2003-04-29 00:00:00   2003-07-30 00:00:00   2003-10-29 00:00:00   2004-01-29 00:00:00   2003-10-30 00:00:00   2003-07-31 00:00:00   2004-01-29 00:00:00   2004-07-30 00:00:00   2004-07-30 00:00:00   2004-04-28 00:00:00   2004-04-29 00:00:00   2004-10-29 00:00:00   2004-10-29 00:00:00   2005-01-31 00:00:00   2004-12-07 00:00:00   2005-01-31 00:00:00   2005-07-29 00:00:00   2005-04-29 00:00:00   2005-10-27 00:00:00   2006-01-30 00:00:00   2006-04-24 00:00:00   2006-07-27 00:00:00   2006-10-26 00:00:00   2007-01-29 00:00:00   2007-07-31 00:00:00   2006-12-01 00:00:00   2007-04-27 00:00:00   2013-07-31 00:00:00   2015-07-31 00:00:00   2015-04-30 00:00:00   2013-10-31 00:00:00   2015-01-05 00:00:00   2015-01-31 00:00:00   2014-10-31 00:00:00   2007-10-31 00:00:00   2008-04-29 00:00:00   2008-01-31 00:00:00   2008-01-31 00:00:00   2008-01-31 00:00:00   2008-07-31 00:00:00   2008-10-30 00:00:00   2008-12-15 00:00:00   2009-01-30 00:00:00   2009-04-29 00:00:00   2009-07-30 00:00:00   2010-01-29 00:00:00   2009-10-29 00:00:00   2010-04-29 00:00:00   2010-07-28 00:00:00   2010-10-28 00:00:00   2011-01-31 00:00:00   2010-12-22 00:00:00   2011-04-29 00:00:00   2011-07-28 00:00:00   2011-10-27 00:00:00   2012-01-30 00:00:00   2012-04-28 00:00:00   2012-07-26 00:00:00   2014-01-31 00:00:00   2012-10-30 00:00:00   2014-07-31 00:00:00   2013-01-30 00:00:00   2012-12-07 00:00:00   2014-04-30 00:00:00   2013-04-30 00:00:00   2016-01-15 00:00:00   2018-04-27 00:00:00   2019-07-19 00:00:00   2017-10-30 00:00:00   2018-01-23 00:00:00   2021-01-25 00:00:00   2018-10-31 00:00:00   2020-01-14 00:00:00   2018-07-30 00:00:00   2015-10-31 00:00:00   2016-05-02 00:00:00   2016-07-29 00:00:00   2016-08-08 00:00:00   2016-10-31 00:00:00   2017-01-13 00:00:00   2017-01-27 00:00:00   2017-01-09 00:00:00   2017-04-26 00:00:00   2017-01-09 00:00:00   2017-07-24 00:00:00   2020-11-02 00:00:00   2019-04-19 00:00:00   2020-07-21 00:00:00   2019-01-30 00:00:00   2020-12-21 00:00:00   2019-05-10 00:00:00   2019-01-23 00:00:00   2020-04-30 00:00:00   2019-10-25 00:00:00   2021-04-19 00:00:00   2022-07-27 00:00:00   2021-10-28 00:00:00   2022-05-02 00:00:00   2021-07-26 00:00:00   2020-12-21 00:00:00   2022-01-25 00:00:00   2022-10-23 00:00:00
stmnt_type   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10005   10001   10005   10001   10005   10005   10005   10005   10001   10005   10005   10001   10005   10001   10001   10005   10005   10005   10001   10001   10005   10006   10001   10005   10005   10005   10001   10001   10005   10001   10001   10001   10005   10005   10005   10005   10001   10001   10005   10005   10001   10001   10005   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10002   10002   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10002   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10006   10005   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001
stmnt_status   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11003   11001   11001   11001   11001   11003   11001   11001   11003   11001   11003   11003   11001   11001   11001   11003   11003   11001   11001   11003   11001   11001   11001   11003   11003   11001   11003   11003   11003   11001   11001   11001   11001   11003   11003   11001   11001   11003   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11003   11001   11001   11001   11003
session_id   1995   1997   1997   1995   1995   1997   1997   1995   1995   1995   1997   1995   1997   1997   1997   1999   1999   1999   1995   1999   1999   1999   1999   1999   1999   2001   1999   2001   2001   1999   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2003   2001   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2005   2003   2005   2005   2005   2005   2005   2005   2005   2005   2007   2007   2007   2013   2015   2015   2013   2015   2013   2013   2007   2007   2007   2007   2007   2007   2007   2009   2007   2009   2009   2009   2009   2009   2009   2009   2009   2011   2011   2011   2011   2011   2011   2011   2013   2011   2013   2011   2013   2013   2013   2015   2017   2019   2017   2017   2019   2017   2019   2017   2015   2015   2015   2015   2015   2015   2015   2017   2017   2017   2017   2019   2019   2019   2017   2021   2019   2019   2019   2019   2021   2021   2021   2021   2021   2021   2021   2021
user_id   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   FWALKER   *   *   JLEHMAN   *   YBONILLA   CFLAGG   GPEREZ   YBONILLA   *   GPEREZ   YBONILLA   *   CFLAGG   *   *   LTHIBAUL   LTHIBAUL   LTHIBAUL   *   *   LTHIBAUL   LTHIBAUL   *   LTHIBAUL   LTHIBAUL   SARRIAGA   COMPLETED   COMPLETED   LTHIBAUL   COMPLETED   COMPLETED   COMPLETED   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   COMPLETED   COMPLETED   LTHIBAUL   LTHIBAUL   COMPLETED   COMPLETED   EMCENTEE   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   GPEREZ   LTHIBAUL   AGLADNEY   AGLADNEY   MPACHECO   AGLADNEY   ASAETERN   AGLADNEY   AGLADNEY   LTHIBAUL   LTHIBAUL   YRODRIGU   YRODRIGU   LTHIBAUL   YRODRIGU   JGRISSUM   CFLAGG   JGRISSUM   JGRISSUM   JGRISSUM   JINGRAM   MGUERRA   ASAETERN   ASAETERN   ASAETERN   AGLADNEY   GKURIMOT   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   ASAETERN   PBANFORD   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   SUSHAKOV   AGLADNEY   AGLADNEY   GTAYLOR   AGLADNEY   VUKSTINA   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   GPEREZ   AGLADNEY   AGLADNEY   AGLADNEY   PBANFORD   AGLADNEY   PBANFORD   AGLADNEY   GTAYLOR   SUSHAKOV   GTAYLOR   AGLADNEY   MKIRKHAM   SARRIAGA   GPEREZ   VUKSTINA   VUKSTINA   GTAYLOR   CAFILER   GTAYLOR   CAFILER   GTAYLOR   MKIRKHAM   CHATRIDGE   CAFILER
special_audit   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11002   11002   11003   11003   11002   11003   11003   11002   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003
fine_audit   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11003   11003   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11001   11001   11001   11003   11001   11003   11001   11003   11001   11003
rpt_start   1995-04-01 00:00:00   1997-04-01 00:00:00   1997-10-01 00:00:00   1995-10-01 00:00:00   1995-01-01 00:00:00   1997-01-01 00:00:00   1997-07-01 00:00:00   1996-04-01 00:00:00   1996-07-01 00:00:00   1996-01-01 00:00:00   1998-10-01 00:00:00   1996-10-01 00:00:00   1998-07-01 00:00:00   1998-01-01 00:00:00   1998-04-01 00:00:00   1999-07-01 00:00:00   1999-01-01 00:00:00   1999-04-01 00:00:00   1995-07-01 00:00:00   2000-01-01 00:00:00   1999-10-01 00:00:00   2000-07-01 00:00:00   2000-04-01 00:00:00   2000-10-01 00:00:00   2000-07-01 00:00:00   1900-01-01 00:00:00   2000-04-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2000-10-01 00:00:00   2001-04-01 00:00:00   2001-07-01 00:00:00   1900-01-01 00:00:00   2001-04-01 00:00:00   2001-10-01 00:00:00   2001-07-01 00:00:00   2002-01-01 00:00:00   2001-10-01 00:00:00   2002-01-01 00:00:00   2002-04-01 00:00:00   2002-04-01 00:00:00   2001-10-01 00:00:00   2002-07-01 00:00:00   2002-07-01 00:00:00   2002-10-01 00:00:00   1900-01-01 00:00:00   2002-10-01 00:00:00   2003-01-01 00:00:00   2003-01-01 00:00:00   2003-04-01 00:00:00   2003-07-01 00:00:00   2003-10-01 00:00:00   2003-07-01 00:00:00   2003-04-01 00:00:00   2003-10-01 00:00:00   2004-04-01 00:00:00   2004-04-01 00:00:00   2004-01-01 00:00:00   2004-01-01 00:00:00   2004-07-01 00:00:00   2004-07-01 00:00:00   2004-10-01 00:00:00   1900-01-01 00:00:00   2004-10-01 00:00:00   2005-04-01 00:00:00   2005-01-01 00:00:00   2005-07-01 00:00:00   2005-10-01 00:00:00   2006-01-01 00:00:00   2006-04-01 00:00:00   2006-07-01 00:00:00   2006-10-01 00:00:00   2007-04-01 00:00:00   1900-01-01 00:00:00   2007-01-01 00:00:00   2013-04-01 00:00:00   2015-04-01 00:00:00   2015-01-01 00:00:00   2013-07-01 00:00:00   1900-01-01 00:00:00   2014-10-01 00:00:00   2014-07-01 00:00:00   2007-07-01 00:00:00   2008-01-01 00:00:00   2007-04-01 00:00:00   2007-07-01 00:00:00   2007-10-01 00:00:00   2008-04-01 00:00:00   2008-07-01 00:00:00   1900-01-01 00:00:00   2008-10-01 00:00:00   2009-01-01 00:00:00   2009-04-01 00:00:00   2009-10-01 00:00:00   2009-07-01 00:00:00   2010-01-01 00:00:00   2010-04-01 00:00:00   2010-07-01 00:00:00   2010-10-01 00:00:00   1900-01-01 00:00:00   2011-01-01 00:00:00   2011-04-01 00:00:00   2011-07-01 00:00:00   2011-10-01 00:00:00   2012-01-01 00:00:00   2012-04-01 00:00:00   2013-10-01 00:00:00   2012-07-01 00:00:00   2014-04-01 00:00:00   2012-10-01 00:00:00   1900-01-01 00:00:00   2014-01-01 00:00:00   2013-01-01 00:00:00   2015-10-01 00:00:00   2018-01-01 00:00:00   2019-04-01 00:00:00   2017-07-01 00:00:00   2017-10-01 00:00:00   2020-10-01 00:00:00   2018-07-01 00:00:00   2019-10-01 00:00:00   2018-04-01 00:00:00   2015-07-01 00:00:00   2016-01-01 00:00:00   2016-04-01 00:00:00   1900-01-01 00:00:00   2016-07-01 00:00:00   2016-07-01 00:00:00   2016-10-01 00:00:00   2017-01-09 00:00:00   2017-01-01 00:00:00   1900-01-01 00:00:00   2017-04-01 00:00:00   2020-07-01 00:00:00   2019-01-01 00:00:00   2020-04-01 00:00:00   2018-10-01 00:00:00   2021-02-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2020-01-01 00:00:00   2019-07-01 00:00:00   2021-01-01 00:00:00   2022-04-01 00:00:00   2021-07-01 00:00:00   2022-01-01 00:00:00   2021-04-01 00:00:00   1900-01-01 00:00:00   2021-10-01 00:00:00   2022-07-01 00:00:00
rpt_end   1995-06-30 00:00:00   1997-06-30 00:00:00   1997-12-31 00:00:00   1995-12-31 00:00:00   1995-03-31 00:00:00   1997-03-31 00:00:00   1997-09-30 00:00:00   1996-06-30 00:00:00   1996-09-30 00:00:00   1996-03-31 00:00:00   1998-12-31 00:00:00   1996-12-31 00:00:00   1998-09-30 00:00:00   1998-03-31 00:00:00   1998-06-30 00:00:00   1999-09-30 00:00:00   1999-03-31 00:00:00   1999-06-30 00:00:00   1995-09-30 00:00:00   2000-03-31 00:00:00   1999-12-31 00:00:00   2000-09-30 00:00:00   2000-06-30 00:00:00   2000-12-31 00:00:00   2000-09-30 00:00:00   1900-01-01 00:00:00   2000-06-30 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2000-12-31 00:00:00   2001-06-30 00:00:00   2001-09-30 00:00:00   1900-01-01 00:00:00   2001-06-30 00:00:00   2001-12-31 00:00:00   2001-09-30 00:00:00   2002-03-31 00:00:00   2001-12-31 00:00:00   2002-03-31 00:00:00   2002-06-30 00:00:00   2002-06-30 00:00:00   2001-12-31 00:00:00   2002-09-30 00:00:00   2002-09-30 00:00:00   2002-12-31 00:00:00   1900-01-01 00:00:00   2002-12-31 00:00:00   2003-03-31 00:00:00   2003-03-31 00:00:00   2003-06-30 00:00:00   2003-09-30 00:00:00   2003-12-31 00:00:00   2003-09-30 00:00:00   2003-06-30 00:00:00   2003-12-31 00:00:00   2004-06-30 00:00:00   2004-06-30 00:00:00   2004-03-31 00:00:00   2004-03-31 00:00:00   2004-09-30 00:00:00   2004-09-30 00:00:00   2004-12-31 00:00:00   1900-01-01 00:00:00   2004-12-31 00:00:00   2005-06-30 00:00:00   2005-03-31 00:00:00   2005-09-30 00:00:00   2005-12-31 00:00:00   2006-03-31 00:00:00   2006-06-30 00:00:00   2006-09-30 00:00:00   2006-12-31 00:00:00   2007-06-30 00:00:00   1900-01-01 00:00:00   2007-03-31 00:00:00   2013-06-30 00:00:00   2015-06-30 00:00:00   2015-03-31 00:00:00   2013-09-30 00:00:00   1900-01-01 00:00:00   2014-12-31 00:00:00   2014-09-30 00:00:00   2007-09-30 00:00:00   2008-03-31 00:00:00   2007-06-30 00:00:00   2007-09-30 00:00:00   2007-12-31 00:00:00   2008-06-30 00:00:00   2008-09-30 00:00:00   1900-01-01 00:00:00   2008-12-31 00:00:00   2009-03-31 00:00:00   2009-06-30 00:00:00   2009-12-31 00:00:00   2009-09-30 00:00:00   2010-03-31 00:00:00   2010-06-30 00:00:00   2010-09-30 00:00:00   2010-12-31 00:00:00   1900-01-01 00:00:00   2011-03-31 00:00:00   2011-06-30 00:00:00   2011-09-30 00:00:00   2011-12-31 00:00:00   2012-03-31 00:00:00   2012-06-30 00:00:00   2013-12-31 00:00:00   2012-09-30 00:00:00   2014-06-30 00:00:00   2012-12-31 00:00:00   1900-01-01 00:00:00   2014-03-31 00:00:00   2013-03-31 00:00:00   2015-12-31 00:00:00   2018-03-31 00:00:00   2019-06-30 00:00:00   2017-09-30 00:00:00   2017-12-31 00:00:00   2020-12-31 00:00:00   2018-09-30 00:00:00   2019-12-31 00:00:00   2018-06-30 00:00:00   2015-09-30 00:00:00   2016-03-31 00:00:00   2016-06-30 00:00:00   1900-01-01 00:00:00   2016-09-30 00:00:00   2016-09-30 00:00:00   2016-12-31 00:00:00   2017-01-09 00:00:00   2017-03-31 00:00:00   1900-01-01 00:00:00   2017-06-30 00:00:00   2020-09-30 00:00:00   2019-03-31 00:00:00   2020-06-30 00:00:00   2018-12-31 00:00:00   2021-02-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2020-03-31 00:00:00   2019-09-30 00:00:00   2021-03-31 00:00:00   2022-06-30 00:00:00   2021-09-30 00:00:00   2022-03-31 00:00:00   2021-06-30 00:00:00   1900-01-01 00:00:00   2021-12-31 00:00:00   2022-09-30 00:00:00
rpt_date   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
filing_type   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   22001   22001   None   22001   22001   22001   None   None   None   None   22001   22001   None   None   22001   22001   None   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22006   22001   22006   22001   None   22001   22001   22001   22001   22001   22001   None   None   22001   22001   22001   22001   22001   22001   22001   None   22001   22001
Table: filer_interests
filer_id   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328
session_id   2001   2003   1997   1995   1999   2007   2013   2011   2005   2009   2017   2019   2015   2021   2023
interest_cd   40315   40315   40315   40315   40315   40315   40315   40315   40315   40315   40312   40310   40315   40312   40312
effect_date   2001-01-01 00:00:00   2003-01-01 00:00:00   1997-01-01 00:00:00   1995-01-01 00:00:00   1999-01-01 00:00:00   2007-01-01 00:00:00   2013-01-01 00:00:00   2011-01-01 00:00:00   2005-01-01 00:00:00   2009-01-01 00:00:00   2017-01-01 00:00:00   2019-01-16 00:00:00   2015-01-01 00:00:00   2021-01-01 00:00:00   2023-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328
filer_type   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1
active   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   N
race   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None
session_id   1999   1995   1997   2001   2003   2005   2007   2011   2013   2009   2015   2021   2019   2017   2023
category   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None
category_type   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None
sub_category   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None
effect_dt   1999-01-01 00:00:00   1995-01-01 00:00:00   1997-01-01 00:00:00   2001-01-01 00:00:00   2003-01-01 00:00:00   2005-01-01 00:00:00   2007-01-01 00:00:00   2011-01-01 00:00:00   2013-01-01 00:00:00   2009-01-01 00:00:00   2015-01-01 00:00:00   2021-01-01 00:00:00   2019-01-16 00:00:00   2017-01-01 00:00:00   2023-01-01 00:00:00
sub_category_type   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None
election_type   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None
sub_category_a   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
nyq_dt   None   None   None   None   None   2000-07-01 00:00:00   2000-07-01 00:00:00   None   None   None   None   None   None   None   None
party_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
county_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
district_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: filer_xref
filer_id   1144328
xref_id   C25715
effect_dt   1999-12-08 00:00:00
migration_source   MASTER
Table: filername
xref_filer_id   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715   C25715
filer_id   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328
filer_type   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT
status   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE
effect_dt   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00
naml   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS' NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS' NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS' NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS' NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS' NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS' NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS' NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS' NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS' NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS' NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS' NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS' NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS' NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION
namf   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
adr1   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
adr2   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
city   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO
st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
zip4   95814   95826   95826   95826   95826   95826   95826   95814   95814   95826   95814   95814   95814   95814   95826   95826   95826   95826   95826   95826   95814   95814   95826   95814   95814   95814   95814   95826   95826   95826   95826   95826   95826   95814   95814   95826   95814   95814   95814   95814   95826   95826   95826   95826   95826   95826   95814   95814   95826   95814   95814   95814   95814   95826   95826   95826   95826   95826   95826   95814   95814   95826   95814   95814   95814   95814   95826   95826   95826   95826   95826   95826   95814   95814   95826   95814   95814   95814   95814   95826   95826   95826   95826   95826   95826   95814   95814   95826   95814   95814   95814   95814   95826   95826   95826   95826   95826   95826   95814   95814   95826   95814   95814   95814   95814   95826   95826   95826   95826   95826   95826   95814   95814   95826   95814   95814   95814   95814   95826   95826   95826   95826   95826   95826   95814   95814   95826   95814   95814   95814   95814   95826   95826   95826   95826   95826   95826   95814   95814   95826   95814   95814   95814   95814   95826   95826   95826   95826   95826   95826   95814   95814   95826   95814   95814   95814   95814   95826   95826   95826   95826   95826   95826   95814   95814   95826   95814   95814   95814   95814   95826   95826   95826   95826   95826   95826   95814   95814   95826   95814   95814   95814
phon   9164423807   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9164423807   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9164423807   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9164423807   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9164423807   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9164423807   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9164423807   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9164423807   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9164423807   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9164423807   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9164423807   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9164423807   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9164423807   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9164423807   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460   9163637460
fax   None   9163637544                        9163637544            None   9163637544                        9163637544            None   9163637544                        9163637544            None   9163637544                        9163637544            None   9163637544                        9163637544            None   9163637544                        9163637544            None   9163637544                        9163637544            None   9163637544                        9163637544            None   9163637544                        9163637544            None   9163637544                        9163637544            None   9163637544                        9163637544            None   9163637544                        9163637544            None   9163637544                        9163637544            None   9163637544                        9163637544         
email   None   None   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]
Table: filers
filer_id   1144328
Table: lobbying_chg_log
filer_id   1144328   1144328   1144328
change_no   0   1   2
session_id   2001   2001   2015
log_dt   2001-10-01 00:00:00   2001-11-01 00:00:00   2016-07-06 00:00:00
filer_type   1   1   1
correction_flg   Y   Y   None
action   ADDED   DELETED   DELETED
attribute_changed   EMPLOYER   EMPLOYER   FIRM
ethics_dt   None   None   None
interests   None   None   None
filer_full_name   CALIFORNIA ASSOCIATION SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION SHEET METAL AND AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION   CALIFORNIA ASSOCIATION OF SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION
filer_city   None   None   None
filer_st   None   None   None
filer_zip   None   None   None
filer_phone   None   None   None
entity_type   2   2   3
entity_name   NOSSAMAN, GUTHNER, KNOX & ELLIOTT, LLP   POLITICO GROUP   NOSSAMAN LLP
entity_city   None   None   None
entity_st   None   None   None
entity_zip   None   None   None
entity_phone   None   None   None
entity_id   1147226   1147370   1147226
responsible_officer   None   None   None
effect_dt   2001-10-01 00:00:00   2001-10-16 00:00:00   2016-06-30 00:00:00
Table: lobbyist_contributions1
filer_id   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328
filing_period_start_dt   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2001-01-01 00:00:00
filing_period_end_dt   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2001-03-31 00:00:00
contribution_dt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
recipient_name   PACHECO FOR ASSEMBLY 2000 BOB   ZETTEL FOR ASSEMBLY CHARLENE   ALPERT FOR SENATE DEDE   FIGUEROA FOR SENATE   KEELEY FOR ASSEMBLY FRED   MALDONADO FRIENDS OF ABEL   ALQUIST FRIENDS OF ELAINE   POLANCO FRIENDS OF   GLORIA ROMERO FOR SENATE   DUTRA FOR ASSEMBLY   JV FOR SENATE   CORREA FOR STATE ASSEMBLY LOU   MC PHERSON FOR SENATE BRUCE   PERATA FOR SENATE 2000   POOCHIGIAN SENATE COMMITTEE   PACHECO FOR ASSEMBLY-2000 ROD   ASHBURN STATE ASSEMBLY COMMITTEE ROY   RUNNER FRIENDS OF GEORGE   SENATE DEMOCRATIC LEADERSHIP FUND   COX-ASSEMBLY 2000 TAXPAYERS FOR DAVE   CALDERON FOR STATE ASSEMBLY COMMITTEE TO RE-ELECT TOM   TORLAKSON FOR SENATE   CARDENAS 2000 TONY   REYES FRIENDS OF SARAH
recipient_id   1071691   1071353   1065754   1072096   1064740   1072662   1053563   1064478   1224066   1072383   1064805   1065492   1065803   1075392   1076065   1072148   1073057   1072110   1064947   1069205   1071970   1076239   1069524   1072108
amount   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000
Table: lobbyist_contributions2
filer_id   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328
filing_period_start_dt   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2000-10-01 00:00:00   2001-01-01 00:00:00
filing_period_end_dt   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2001-03-31 00:00:00
contribution_dt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
recipient_name   PACHECO FOR ASSEMBLY 2000 BOB   ZETTEL FOR ASSEMBLY CHARLENE   ALPERT FOR SENATE DEDE   FIGUEROA FOR SENATE   KEELEY FOR ASSEMBLY FRED   MALDONADO FRIENDS OF ABEL   ALQUIST FRIENDS OF ELAINE   POLANCO FRIENDS OF   GLORIA ROMERO FOR SENATE   DUTRA FOR ASSEMBLY   JV FOR SENATE   CORREA FOR STATE ASSEMBLY LOU   MC PHERSON FOR SENATE BRUCE   PERATA FOR SENATE 2000   POOCHIGIAN SENATE COMMITTEE   PACHECO FOR ASSEMBLY-2000 ROD   ASHBURN STATE ASSEMBLY COMMITTEE ROY   RUNNER FRIENDS OF GEORGE   SENATE DEMOCRATIC LEADERSHIP FUND   COX-ASSEMBLY 2000 TAXPAYERS FOR DAVE   CALDERON FOR STATE ASSEMBLY COMMITTEE TO RE-ELECT TOM   TORLAKSON FOR SENATE   CARDENAS 2000 TONY   REYES FRIENDS OF SARAH
recipient_id   1071691   1071353   1065754   1072096   1064740   1072662   1053563   1064478   1224066   1072383   1064805   1065492   1065803   1075392   1076065   1072148   1073057   1072110   1064947   1069205   1071970   1076239   1069524   1072108
amount   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000   1000
Table: received_filings
filer_id   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328   1144328
filing_file_name   681290_0.cal   718571_0.cal   745210_0.cal   773511_0.cal   792052_0.cal   813918_0.cal   87295.cal   835520_0.cal   850749_0.cal   881379_0.cal   910336_0.cal   929728_0.cal   946568_0.cal   968344_0.cal   988305_0.cal   1012332_0.cal   1057519_0.cal   1081090_0.cal   1104308_0.cal   1117524_0.cal   1131804_0.cal   1146849_0.cal   1164175_0.cal   1188281_0.cal   1212296_0.cal   1328274_0.cal   1504789_0.cal   1395859_0.cal   1350487_0.cal   1484254_0.cal   1451607_0.cal   1234273_0.cal   1260908_0.cal   1284202_0.cal   1420512_0.cal   1436998_0.cal   1463429_0.cal   1297353_0.cal   1376764_0.cal   1284202_1.cal   1297353_1.cal   1311036_0.cal   1846085_0.cal   1872854_0.cal   1737891_0.cal   1675398_0.cal   1783972_0.cal   1800930_0.cal   1538237_0.cal   1570221_0.cal   1819171_0.cal   1590815_0.cal   1605921_0.cal   1765097_0.cal   1620579_0.cal   1634706_0.cal   1656454_0.cal   1708057_0.cal   1982029_0.cal   1966148_0.cal   2004020_0.cal   1997601_0.cal   2101021_0.cal   2062513_0.cal   1912223_0.cal   2037527_0.cal   1935502_0.cal   2479652_0.cal   2470034_0.cal   2596839_0.cal   2574987_0.cal   2702506_0.cal   2676175_0.cal   2531019_0.cal   2637725_0.cal   2621795_0.cal   2547127_0.cal   2739349_0.cal
received_date   2000-10-30 00:00:00   2001-01-31 00:00:00   2001-04-28 00:00:00   2001-07-31 00:00:00   2001-10-31 00:00:00   2002-01-31 00:00:00   2002-01-31 00:00:00   2002-04-16 00:00:00   2002-07-22 00:00:00   2002-10-28 00:00:00   2003-01-30 00:00:00   2003-04-28 00:00:00   2003-07-30 00:00:00   2003-10-29 00:00:00   2004-01-29 00:00:00   2004-04-28 00:00:00   2004-10-29 00:00:00   2005-01-31 00:00:00   2005-04-29 00:00:00   2005-07-29 00:00:00   2005-10-27 00:00:00   2006-01-30 00:00:00   2006-04-24 00:00:00   2006-07-27 00:00:00   2006-10-26 00:00:00   2008-04-29 00:00:00   2010-07-28 00:00:00   2009-01-30 00:00:00   2008-07-31 00:00:00   2010-04-29 00:00:00   2009-10-29 00:00:00   2007-01-29 00:00:00   2007-04-27 00:00:00   2007-07-31 00:00:00   2009-04-29 00:00:00   2009-07-30 00:00:00   2010-01-29 00:00:00   2007-10-31 00:00:00   2008-10-30 00:00:00   2008-01-31 00:00:00   2008-01-31 00:00:00   2008-01-31 00:00:00   2014-04-30 00:00:00   2014-07-31 00:00:00   2013-01-30 00:00:00   2012-07-26 00:00:00   2013-07-31 00:00:00   2013-10-31 00:00:00   2010-10-28 00:00:00   2011-01-31 00:00:00   2014-01-31 00:00:00   2011-04-29 00:00:00   2011-07-28 00:00:00   2013-04-30 00:00:00   2011-10-27 00:00:00   2012-01-30 00:00:00   2012-04-28 00:00:00   2012-10-30 00:00:00   2015-07-31 00:00:00   2015-04-30 00:00:00   2016-01-15 00:00:00   2015-10-31 00:00:00   2016-10-31 00:00:00   2016-07-29 00:00:00   2014-10-31 00:00:00   2016-05-02 00:00:00   2015-01-31 00:00:00   2020-07-21 00:00:00   2020-04-30 00:00:00   2021-07-26 00:00:00   2021-04-19 00:00:00   2022-07-27 00:00:00   2022-05-02 00:00:00   2020-11-02 00:00:00   2022-01-25 00:00:00   2021-10-28 00:00:00   2021-01-25 00:00:00   2022-10-23 00:00:00
filing_directory   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal
filing_id   681290   718571   745210   773511   792052   813918   None   835520   850749   881379   910336   929728   946568   968344   988305   1012332   1057519   1081090   1104308   1117524   1131804   1146849   1164175   1188281   1212296   1328274   1504789   1395859   1350487   1484254   1451607   1234273   1260908   1284202   1420512   1436998   1463429   1297353   1376764   1284202   1297353   1311036   1846085   1872854   1737891   1675398   1783972   1800930   1538237   1570221   1819171   1590815   1605921   1765097   1620579   1634706   1656454   1708057   1982029   1966148   2004020   1997601   2101021   2062513   1912223   2037527   1935502   2479652   2470034   2596839   2574987   2702506   2676175   2531019   2637725   2621795   2547127   2739349
form_id   F635   F635   F635   F635   F635   F635   None   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635
receive_comment   Filing accepted, but with warnings   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing did not pass validation   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted