Home

Filer ID: 1146912

Table: filer_acronyms
acronym   CAIB
filer_id   1146912
Table: filer_address
filer_id   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912
adrid   1109797   1108360   1109464   2001690   2051233   2079898   2113046   2159077   2159078   2203155   2417686   2419222   2507222   2507223   2265976   2265977   2465681   2338375   2338376
effect_dt   1997-01-01 00:00:00   2000-01-01 00:00:00   1995-01-01 00:00:00   1999-01-01 00:00:00   2003-05-15 00:00:00   2005-01-01 00:00:00   2007-01-01 00:00:00   2009-01-01 00:00:00   2009-01-01 00:00:00   2011-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2013-01-31 00:00:00   2013-01-31 00:00:00   2019-03-08 00:00:00   2015-02-02 00:00:00   2015-02-02 00:00:00
add_type   7051   7051   7051   7082   7051   7051   7051   7051   7082   7082   7051   7082   7051   7082   7051   7082   7051   7051   7082
session_id   1997   2001   1995   2001   2003   2005   2007   2009   2009   2011   2017   2017   2021   2021   2013   2013   2019   2015   2015
Table: filer_filings
filer_id   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912
filing_id   499185   498647   500352   500672   499499   500040   500888   501194   502654   502916   503228   501768   502081   503482   500672   502340   502340   503790   501768   501508   498976   501508   498976   502081   499826   502654   502916   499826   613899   633302   650355   700691   696208   755324   738927   768918   779791   792967   794775   821198   792942   792943   807717   836642   832449   860887   842479   893493   853345   903599   882887   931875   904730   936224   903599   937779   947828   937815   937818   968426   956583   938993   976225   986460   1001518   1014236   1025190   1028937   1064479   1018798   1075910   1057127   1072263   1092717   1117384   1104813   1146805   1104813   1117384   1132883   1165075   1186074   1210103   1186074   1228107   1228088   1256197   1306408   1281622   1294867   1777769   1978472   1978472   1964077   1964077   1867838   1799662   1956074   1922225   1922307   1906903   1322521   1344728   1389773   1368672   1405957   1424192   1428803   1458168   1449319   1442362   1482288   1442920   1500720   1538479   1566768   1566493   1575521   1589585   1616640   1627910   1653994   1612187   1673891   1814669   1737349   1706237   1737593   1837671   1753762   1758721   1706237   1990455   1990455   1990463   2187678   2187678   2442290   2357873   2403533   2403533   2304163   2213260   2375561   2169456   2187678   2275207   2380454   2275207   2007998   1999242   2028814   2053863   2053863   2099158   2099158   2109709   2117487   2111481   2109706   2117489   2151851   2151851   2169456   2151851   2213260   2228054   2442324   2187678   2332500   2228054   2304163   2228054   2213260   2187678
period_id   157   141   143   151   142   158   159   144   154   147   155   145   153   148   151   146   146   156   145   152   149   152   149   153   150   154   147   150   160   161   162   None   163   165   164   165   None   167   None   None   165   166   168   169   None   None   None   None   170   172   171   173   None   None   172   None   174   None   None   175   None   None   None   176   None   177   178   None   None   None   180   179   None   None   182   181   184   181   182   183   185   186   187   186   None   188   189   192   190   191   214   221   221   221   221   218   215   None   220   220   219   193   194   196   195   None   197   198   200   199   199   201   None   202   203   204   205   None   205   207   208   209   206   210   216   212   211   213   217   None   213   211   222   223   224   231   231   239   236   238   238   235   231   None   230   232   234   237   234   224   None   225   225   226   227   227   228   228   None   228   228   229   229   230   229   231   233   239   232   237   233   235   233   231   231
form_id   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F690   F690   F635   F635   F690   F690   F635   F635   F690   F690   F690   F690   F690   F635   F635   F635   F635   F603   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F690   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F603   F635   F605   F605   F635   F635   F603   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F603   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F603   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F603   F603   F635   F635   F635   F635   F635   F635   F603   F635   F635   F635   F635   F603   F635   F605   F635   F635   F635   F603   F603   F635   F635   F635   F635   F635   F635   F635   F635   F635   F603   F635   F603   F635   F635   F635   F635   F603   F635   F635   F635   F635   F635   F635   F635   F635   F603   F635   F635   F635   F635   F635   F635   F605   F635   F635   F635   F635   F635   F603   F635   F603   F603   F635   F635   F635   F635   F635   F635   F635   F635   F635   F603   F635   F635   F635   F635   F635
filing_sequence   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   1   0   0   1   1   0   0   1   1   1   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   1   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   1   0   0   0   0   0   0   0   0   1   0   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   1   0   1   0   3   4   0   0   0   1   1   2   0   1   2   1   0   0   0   0   0   0   1   0   1   0   0   0   0   0   0   1   0   2   0   0   0   1   0   1   0   2   1   0
filing_date   1999-04-29 00:00:00   1995-04-25 00:00:00   1995-10-30 00:00:00   1997-10-30 00:00:00   1995-07-31 00:00:00   1999-07-26 00:00:00   1999-10-28 00:00:00   1996-01-26 00:00:00   1998-07-31 00:00:00   1996-10-31 00:00:00   1998-10-31 00:00:00   1996-04-30 00:00:00   1998-04-16 00:00:00   1997-01-24 00:00:00   1998-11-03 00:00:00   1997-01-14 00:00:00   1996-07-29 00:00:00   1999-02-01 00:00:00   1997-01-14 00:00:00   1998-11-03 00:00:00   1997-04-30 00:00:00   1998-02-02 00:00:00   1998-11-03 00:00:00   1998-11-03 00:00:00   1998-11-03 00:00:00   1998-11-03 00:00:00   1997-01-14 00:00:00   1997-07-30 00:00:00   2000-01-26 00:00:00   2000-04-27 00:00:00   2000-07-31 00:00:00   2000-12-18 00:00:00   2000-10-16 00:00:00   2001-04-20 00:00:00   2001-01-24 00:00:00   2001-04-20 00:00:00   2001-07-19 00:00:00   2001-11-01 00:00:00   2001-10-31 00:00:00   2002-01-16 00:00:00   2001-11-01 00:00:00   2001-11-01 00:00:00   2002-01-17 00:00:00   2002-04-23 00:00:00   2002-01-18 00:00:00   2002-07-29 00:00:00   2002-04-25 00:00:00   2002-10-30 00:00:00   2002-07-29 00:00:00   2003-01-20 00:00:00   2002-10-30 00:00:00   2003-04-30 00:00:00   2003-01-21 00:00:00   2003-04-30 00:00:00   2003-04-30 00:00:00   2003-05-29 00:00:00   2003-07-31 00:00:00   2003-05-29 00:00:00   2003-05-29 00:00:00   2003-10-29 00:00:00   2003-07-31 00:00:00   2003-06-17 00:00:00   2003-10-31 00:00:00   2004-01-26 00:00:00   2004-02-02 00:00:00   2004-04-30 00:00:00   2004-07-23 00:00:00   2004-07-26 00:00:00   2004-10-29 00:00:00   2004-04-30 00:00:00   2005-01-26 00:00:00   2004-10-29 00:00:00   2005-01-04 00:00:00   2005-01-31 00:00:00   2005-07-29 00:00:00   2005-04-29 00:00:00   2006-01-30 00:00:00   2005-10-29 00:00:00   2005-10-29 00:00:00   2005-10-29 00:00:00   2006-04-26 00:00:00   2006-07-21 00:00:00   2006-10-23 00:00:00   2006-10-23 00:00:00   2007-01-03 00:00:00   2007-01-16 00:00:00   2007-04-11 00:00:00   2008-01-25 00:00:00   2007-07-27 00:00:00   2007-10-25 00:00:00   2013-07-24 00:00:00   2015-07-28 00:00:00   2015-07-31 00:00:00   2015-04-29 00:00:00   2015-07-28 00:00:00   2014-07-28 00:00:00   2013-10-30 00:00:00   2015-02-02 00:00:00   2014-12-31 00:00:00   2014-12-31 00:00:00   2014-10-28 00:00:00   2008-04-02 00:00:00   2008-07-22 00:00:00   2009-01-15 00:00:00   2008-10-22 00:00:00   2009-01-06 00:00:00   2009-05-19 00:00:00   2009-07-03 00:00:00   2010-01-18 00:00:00   2009-10-23 00:00:00   2009-08-12 00:00:00   2010-04-26 00:00:00   2009-08-17 00:00:00   2010-07-15 00:00:00   2010-10-29 00:00:00   2011-01-26 00:00:00   2011-01-26 00:00:00   2011-02-01 00:00:00   2011-04-28 00:00:00   2011-10-06 00:00:00   2012-01-11 00:00:00   2012-04-24 00:00:00   2011-08-11 00:00:00   2012-07-24 00:00:00   2014-01-28 00:00:00   2013-01-30 00:00:00   2012-10-29 00:00:00   2013-01-30 00:00:00   2014-04-10 00:00:00   2013-01-31 00:00:00   2013-04-17 00:00:00   2013-04-17 00:00:00   2015-10-02 00:00:00   2015-10-02 00:00:00   2015-10-02 00:00:00   2018-11-09 00:00:00   2018-11-09 00:00:00   2020-01-31 00:00:00   2019-02-12 00:00:00   2019-08-06 00:00:00   2019-08-13 00:00:00   2018-11-09 00:00:00   2018-11-09 00:00:00   2019-03-08 00:00:00   2018-11-09 00:00:00   2018-11-09 00:00:00   2018-11-09 00:00:00   2019-04-30 00:00:00   2018-07-31 00:00:00   2016-01-27 00:00:00   2015-11-02 00:00:00   2016-04-15 00:00:00   2016-07-07 00:00:00   2016-07-17 00:00:00   2016-10-28 00:00:00   2016-10-28 00:00:00   2016-12-06 00:00:00   2017-01-05 00:00:00   2016-12-12 00:00:00   2016-12-06 00:00:00   2017-01-05 00:00:00   2017-04-19 00:00:00   2017-04-26 00:00:00   2017-07-21 00:00:00   2017-07-18 00:00:00   2018-02-05 00:00:00   2018-04-04 00:00:00   2020-01-31 00:00:00   2018-03-01 00:00:00   2019-01-07 00:00:00   2018-11-09 00:00:00   2018-10-09 00:00:00   2018-11-09 00:00:00   2018-04-04 00:00:00   2017-10-13 00:00:00
stmnt_type   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10005   10005   10005   10005   10005   10005   10001   10005   10001   10005   10005   10001   10001   10001   10001   10005   10005   10005   10005   10001   10001   10001   10001   10005   10005   10002   10005   10001   10005   10005   10001   10005   10002   10005   10001   10005   10001   10001   10005   10005   10005   10001   10001   10005   10005   10001   10001   10001   10002   10002   10001   10001   10001   10001   10002   10005   10001   10001   10001   10001   10001   10001   10001   10002   10001   10002   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10006   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10002   10001   10002   10001   10002   10002   10001   10001   10001   10002   10002   10002   10005   10002   10002   10002   10001   10001   10001   10006   10001   10001   10002   10001   10002   10001   10001   10005   10001   10001   10001   10002   10001   10002   10001   10001   10001   10002   10001   10002   10001   10002   10002   10001
stmnt_status   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   11003   11001   11001   11003   11003   11003   11003   11001   11001   11001   11001   11003   11003   11003   11003   11001   11001   11003   11001   11003   11001   11001   11003   11003   11001   11003   11003   11001   11003   11003   11001   11001   11001   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   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   11003   11001   11001   11001   11001   11001   11003   11001   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001
session_id   1999   1995   1995   1997   1995   1999   1999   1995   1997   1995   1997   1995   1997   1995   1997   1995   1995   1997   1995   1997   1997   1997   1997   1997   1997   1997   1995   1997   1999   1999   1999   2001   1999   2001   1999   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2003   2001   2003   2001   2003   2003   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   2005   2005   2007   2005   2007   2007   2007   2007   2013   2015   2015   2015   2015   2013   2013   2015   2009   2013   2013   2007   2007   2007   2007   2009   2009   2009   2009   2009   2009   2009   2009   2009   2009   2009   2011   2011   2011   2011   2011   2011   2011   2011   2013   2011   2011   2013   2013   2013   2013   2011   2015   2015   2015   2017   2017   2019   2017   2019   2019   2017   2017   2019   2017   2017   2017   2019   2017   2015   2015   2015   2015   2015   2015   2015   2017   2015   2017   2017   2015   2017   2017   2017   2017   2017   2017   2019   2017   2019   2017   2017   2017   2017   2017
user_id   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   GGILMORE   YBONILLA   YBONILLA   YBONILLA   YBONILLA   YBONILLA   MKIENG   YBONILLA   *   LTHIBAUL   LTHIBAUL   *   DHORRELL   *   *   LTHIBAUL   CFLAGG   LTHIBAUL   LTHIBAUL   *   COMPLETED   *   COMPLETED   LTHIBAUL   LTHIBAUL   COMPLETED   GPEREZ   COMPLETED   GPEREZ   GPEREZ   COMPLETED   MHOANG   GPEREZ   KVOONG1   COMPLETED   LTHIBAUL   COMPLETED   COMPLETED   LTHIBAUL   LTHIBAUL   LTHIBAUL   COMPLETED   COMPLETED   SARRIAGA   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   SARRIAGA   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   AGLADNEY   AGLADNEY   AGLADNEY   MPACHECO   AGLADNEY   AGLADNEY   AGLADNEY   PBANFORD   PBANFORD   ASAETERN   ASAETERN   LTHIBAUL   LTHIBAUL   JINGRAM   JINGRAM   SARRIAGA   MGUERRA   MGUERRA   MGUERRA   MGUERRA   YRODRIGU   ASAETERN   YRODRIGU   ASAETERN   ASAETERN   AGLADNEY   YRODRIGU   PBANFORD   AGLADNEY   AGLADNEY   ASAETERN   AGLADNEY   TBOWMAN   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   PBANFORD   AGLADNEY   PBANFORD   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   CAFILER   CAFILER   GCLARA   AGLADNEY   KBANH   KBANH   AGLADNEY   CAFILER   YRODRIGU   CAFILER   CAFILER   AGLADNEY   VUKSTINA   AGLADNEY   AGLADNEY   YRODRIGU   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   CAFILER   AGLADNEY   GPEREZ   CAFILER   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   KBANH   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY
special_audit   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   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11002   11003   11003   11003   11003   11003   11002   11002   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   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   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11003   11003   11003   11003   11003   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   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   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   11001   11001   11001   11001   11003   11003   11001   11001   11001   11001   11001   11003   11003   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001
rpt_start   1999-01-01 00:00:00   1995-01-01 00:00:00   1995-07-01 00:00:00   1997-07-01 00:00:00   1995-04-01 00:00:00   1999-04-01 00:00:00   1999-07-01 00:00:00   1995-10-01 00:00:00   1998-04-01 00:00:00   1996-07-01 00:00:00   1998-07-01 00:00:00   1996-01-01 00:00:00   1998-01-01 00:00:00   1996-10-01 00:00:00   1997-07-01 00:00:00   1996-04-01 00:00:00   1996-04-01 00:00:00   1998-10-01 00:00:00   1996-01-01 00:00:00   1997-10-01 00:00:00   1997-01-01 00:00:00   1997-10-01 00:00:00   1997-01-01 00:00:00   1998-01-01 00:00:00   1997-04-01 00:00:00   1998-04-01 00:00:00   1996-07-01 00:00:00   1997-04-01 00:00:00   1999-10-01 00:00:00   2000-01-01 00:00:00   2000-04-01 00:00:00   1900-01-01 00:00:00   2000-07-01 00:00:00   2001-01-01 00:00:00   2000-10-01 00:00:00   None   2001-04-01 00:00:00   2001-07-01 00:00:00   2001-07-01 00:00:00   2001-10-01 00:00:00   2001-01-01 00:00:00   2001-04-01 00:00:00   2001-10-01 00:00:00   2002-01-01 00:00:00   2001-01-01 00:00:00   2002-04-01 00:00:00   2002-01-01 00:00:00   2002-07-01 00:00:00   2002-04-01 00:00:00   2002-10-01 00:00:00   2002-07-01 00:00:00   2003-01-01 00:00:00   2002-10-01 00:00:00   2003-01-01 00:00:00   2002-10-01 00:00:00   1900-01-01 00:00:00   2003-04-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2003-07-01 00:00:00   2003-04-01 00:00:00   1900-01-01 00:00:00   2003-07-01 00:00:00   2003-10-01 00:00:00   2003-10-01 00:00:00   2004-01-01 00:00:00   2004-04-01 00:00:00   2004-04-01 00:00:00   2004-07-01 00:00:00   2004-01-01 00:00:00   2004-10-01 00:00:00   2004-07-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-10-01 00:00:00   2005-01-01 00:00:00   2005-04-01 00:00:00   2005-07-01 00:00:00   2006-01-01 00:00:00   2006-04-01 00:00:00   2006-07-01 00:00:00   2006-04-01 00:00:00   1900-01-01 00:00:00   2006-10-01 00:00:00   2007-01-01 00:00:00   2007-10-01 00:00:00   2007-04-01 00:00:00   2007-07-01 00:00:00   2013-04-01 00:00:00   2015-03-01 00:00:00   2015-03-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2014-04-01 00:00:00   2013-07-01 00:00:00   1900-01-01 00:00:00   2014-12-31 00:00:00   2014-10-01 00:00:00   2014-07-01 00:00:00   2008-01-01 00:00:00   2008-04-01 00:00:00   2008-10-01 00:00:00   2008-07-01 00:00:00   1900-01-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   2009-08-12 00:00:00   2010-01-01 00:00:00   1900-01-01 00:00:00   2010-04-01 00:00:00   2010-07-01 00:00:00   2010-10-01 00:00:00   2011-01-26 00:00:00   1900-01-01 00:00:00   2011-01-01 00:00:00   2011-07-01 00:00:00   2011-10-01 00:00:00   2012-01-01 00:00:00   2011-04-01 00:00:00   2012-04-01 00:00:00   2013-10-01 00:00:00   2012-10-01 00:00:00   2012-07-01 00:00:00   2013-01-30 00:00:00   2014-01-01 00:00:00   1900-01-01 00:00:00   2013-01-01 00:00:00   2012-07-01 00:00:00   2015-06-01 00:00:00   2015-07-01 00:00:00   2015-10-02 00:00:00   2017-09-30 00:00:00   2017-07-01 00:00:00   2019-07-01 00:00:00   2018-10-01 00:00:00   2019-04-01 00:00:00   2019-04-01 00:00:00   2018-07-01 00:00:00   2017-09-01 00:00:00   1900-01-01 00:00:00   2017-04-01 00:00:00   2017-12-31 00:00:00   2018-04-01 00:00:00   2019-01-01 00:00:00   2018-04-01 00:00:00   2015-10-01 00:00:00   1900-01-01 00:00:00   2016-01-01 00:00:00   2016-03-01 00:00:00   2016-04-01 00:00:00   2016-07-01 00:00:00   2016-07-01 00:00:00   2016-12-06 00:00:00   2016-12-01 00:00:00   1900-01-01 00:00:00   2016-12-06 00:00:00   2016-10-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2017-04-01 00:00:00   2017-01-01 00:00:00   2017-09-01 00:00:00   2018-01-01 00:00:00   2019-09-01 00:00:00   2017-12-31 00:00:00   2019-01-07 00:00:00   2018-01-01 00:00:00   2018-07-01 00:00:00   2018-01-01 00:00:00   2017-09-01 00:00:00   2017-07-01 00:00:00
rpt_end   1999-03-31 00:00:00   1995-03-31 00:00:00   1995-09-30 00:00:00   1997-09-30 00:00:00   1995-06-30 00:00:00   1999-06-30 00:00:00   1999-09-30 00:00:00   1995-12-31 00:00:00   1998-06-30 00:00:00   1996-09-30 00:00:00   1998-09-30 00:00:00   1996-03-31 00:00:00   1998-03-31 00:00:00   1996-12-31 00:00:00   1997-09-30 00:00:00   1996-06-30 00:00:00   1996-06-30 00:00:00   1998-12-31 00:00:00   1996-03-31 00:00:00   1997-12-31 00:00:00   1997-03-31 00:00:00   1997-12-31 00:00:00   1997-03-31 00:00:00   1998-03-31 00:00:00   1997-06-30 00:00:00   1998-06-30 00:00:00   1996-09-30 00:00:00   1997-06-30 00:00:00   1999-12-31 00:00:00   2000-03-31 00:00:00   2000-06-30 00:00:00   1900-01-01 00:00:00   2000-09-30 00:00:00   2001-03-31 00:00:00   2000-12-31 00:00:00   None   2001-06-30 00:00:00   2001-09-30 00:00:00   2001-09-30 00:00:00   2001-12-31 00:00:00   2001-03-31 00:00:00   2001-06-30 00:00:00   2001-12-31 00:00:00   2002-03-31 00:00:00   2001-03-31 00:00:00   2002-06-30 00:00:00   2002-03-31 00:00:00   2002-09-30 00:00:00   2002-06-30 00:00:00   2002-12-31 00:00:00   2002-09-30 00:00:00   2003-03-31 00:00:00   2002-12-31 00:00:00   2003-03-31 00:00:00   2002-12-31 00:00:00   1900-01-01 00:00:00   2003-06-30 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2003-09-30 00:00:00   2003-06-30 00:00:00   1900-01-01 00:00:00   2003-09-30 00:00:00   2003-12-31 00:00:00   2003-12-31 00:00:00   2004-03-31 00:00:00   2004-06-30 00:00:00   2004-06-30 00:00:00   2004-09-30 00:00:00   2004-03-31 00:00:00   2004-12-31 00:00:00   2004-09-30 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-12-31 00:00:00   2005-03-31 00:00:00   2005-06-30 00:00:00   2005-09-30 00:00:00   2006-03-31 00:00:00   2006-06-30 00:00:00   2006-09-30 00:00:00   2006-06-30 00:00:00   1900-01-01 00:00:00   2006-12-31 00:00:00   2007-03-31 00:00:00   2007-12-31 00:00:00   2007-06-30 00:00:00   2007-09-30 00:00:00   2013-06-30 00:00:00   2015-06-30 00:00:00   2015-06-30 00:00:00   2015-03-31 00:00:00   2015-03-31 00:00:00   2014-06-30 00:00:00   2013-09-30 00:00:00   1900-01-01 00:00:00   2014-12-31 00:00:00   2014-12-31 00:00:00   2014-09-30 00:00:00   2008-03-31 00:00:00   2008-06-30 00:00:00   2008-12-31 00:00:00   2008-09-30 00:00:00   1900-01-01 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   2009-08-12 00:00:00   2010-03-31 00:00:00   1900-01-01 00:00:00   2010-06-30 00:00:00   2010-09-30 00:00:00   2010-12-31 00:00:00   2011-01-26 00:00:00   1900-01-01 00:00:00   2011-03-31 00:00:00   2011-09-30 00:00:00   2011-12-31 00:00:00   2012-03-31 00:00:00   2011-06-30 00:00:00   2012-06-30 00:00:00   2014-12-31 00:00:00   2012-12-31 00:00:00   2012-09-30 00:00:00   2013-01-30 00:00:00   2014-03-31 00:00:00   1900-01-01 00:00:00   2013-03-31 00:00:00   2012-09-30 00:00:00   2015-09-30 00:00:00   2015-09-30 00:00:00   2015-10-02 00:00:00   2017-12-31 00:00:00   2017-09-30 00:00:00   2019-09-30 00:00:00   2018-12-31 00:00:00   2019-06-30 00:00:00   2019-06-30 00:00:00   2018-09-30 00:00:00   2017-12-31 00:00:00   1900-01-01 00:00:00   2017-06-30 00:00:00   2017-09-30 00:00:00   2018-06-30 00:00:00   2019-03-31 00:00:00   2018-06-30 00:00:00   2015-12-31 00:00:00   1900-01-01 00:00:00   2016-03-31 00:00:00   2016-06-30 00:00:00   2016-06-30 00:00:00   2016-09-30 00:00:00   2016-09-30 00:00:00   2016-12-06 00:00:00   2016-12-31 00:00:00   1900-01-01 00:00:00   2016-12-06 00:00:00   2016-12-31 00:00:00   2017-03-31 00:00:00   2017-03-31 00:00:00   2017-06-30 00:00:00   2017-03-31 00:00:00   2017-12-31 00:00:00   2018-03-31 00:00:00   2019-12-31 00:00:00   2017-09-30 00:00:00   2019-01-07 00:00:00   2018-03-31 00:00:00   2018-09-30 00:00:00   2018-03-31 00:00:00   2017-12-31 00:00:00   2017-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   None   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   None   None   None   22001   None   22001   None   None   22001   None   22001   None   None   22001   None   None   None   22001   None   22001   22001   None   None   None   22001   22001   None   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22006   22006   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001
Table: filer_interests
filer_id   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912
session_id   1999   1995   1997   2001   2005   2003   2009   2007   2013   2011   2015   2017   2021   2019
interest_cd   40312   40312   40312   40315   40312   40312   40312   40312   40312   40312   40312   40312   40315   40315
effect_date   1999-01-01 00:00:00   1995-01-01 00:00:00   1997-01-01 00:00:00   2001-01-01 00:00:00   2005-01-01 00:00:00   2003-05-15 00:00:00   2009-01-01 00:00:00   2007-01-01 00:00:00   2013-01-31 00:00:00   2011-01-01 00:00:00   2015-02-02 00:00:00   2017-01-01 00:00:00   2021-01-01 00:00:00   2019-03-08 00:00:00
Table: filer_to_filer_type
filer_id   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912
filer_type   2   2   2   2   2   2   2   2   2   2   2   2   2   2
active   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   N   Y   Y
race   0   0   0   0   0   0   0   None   None   None   None   None   None   None
session_id   1997   1995   1999   2001   2003   2005   2007   2013   2011   2009   2017   2021   2015   2019
category   0   0   0   0   0   0   0   None   None   None   None   None   None   None
category_type   0   0   0   0   0   0   0   None   None   None   None   None   None   None
sub_category   0   0   0   0   0   0   0   None   None   None   None   None   None   None
effect_dt   1997-01-01 00:00:00   1995-01-01 00:00:00   1999-01-01 00:00:00   2001-01-01 00:00:00   2003-05-15 00:00:00   2005-01-01 00:00:00   2007-01-01 00:00:00   2013-01-31 00:00:00   2011-01-01 00:00:00   2009-01-01 00:00:00   2017-01-01 00:00:00   2021-01-01 00:00:00   2015-02-02 00:00:00   2019-03-08 00:00:00
sub_category_type   0   0   0   0   0   0   0   None   None   None   None   None   None   None
election_type   0   0   0   0   0   0   0   None   None   None   None   None   None   None
sub_category_a   None   None   None   None   None   None   None   None   None   None   None   None   None   None
nyq_dt   None   None   None   None   None   2001-01-01 00:00:00   2001-01-01 00:00:00   None   None   None   None   None   None   None
party_cd   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
district_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: filer_xref
filer_id   1146912
xref_id   E21585
effect_dt   1999-12-08 00:00:00
migration_source   MASTER
Table: filername
xref_filer_id   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585   E21585
filer_id   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912
filer_type   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER
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   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   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00
naml   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.
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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   CLAREMONT   Riverside   Claremont   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   Riverside   Claremont   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   Riverside   Claremont   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   Riverside   Claremont   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   Riverside   Claremont   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   Riverside   Claremont   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   Riverside   Claremont   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   Riverside   Claremont   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   Riverside   Claremont   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   Riverside   Claremont   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   Riverside   Claremont   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   Riverside   Claremont   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   Riverside   Claremont   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT   CLAREMONT
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   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   91711   92509   91711   917110100   91711   91711   91711   91711   917110100   917110100   91711   91711   91711   91711   917110100   917110100   917110100   917110100   917110100   91711   92509   91711   917110100   91711   91711   91711   91711   917110100   917110100   91711   91711   91711   91711   917110100   917110100   917110100   917110100   917110100   91711   92509   91711   917110100   91711   91711   91711   91711   917110100   917110100   91711   91711   91711   91711   917110100   917110100   917110100   917110100   917110100   91711   92509   91711   917110100   91711   91711   91711   91711   917110100   917110100   91711   91711   91711   91711   917110100   917110100   917110100   917110100   917110100   91711   92509   91711   917110100   91711   91711   91711   91711   917110100   917110100   91711   91711   91711   91711   917110100   917110100   917110100   917110100   917110100   91711   92509   91711   917110100   91711   91711   91711   91711   917110100   917110100   91711   91711   91711   91711   917110100   917110100   917110100   917110100   917110100   91711   92509   91711   917110100   91711   91711   91711   91711   917110100   917110100   91711   91711   91711   91711   917110100   917110100   917110100   917110100   917110100   91711   92509   91711   917110100   91711   91711   91711   91711   917110100   917110100   91711   91711   91711   91711   917110100   917110100   917110100   917110100   917110100   91711   92509   91711   917110100   91711   91711   91711   91711   917110100   917110100   91711   91711   91711   91711   917110100   917110100   917110100   917110100   917110100   91711   92509   91711   917110100   91711   91711   91711   91711   917110100   917110100   91711   91711   91711   91711   917110100   917110100   917110100   917110100   917110100   91711   92509   91711   917110100   91711   91711   91711   91711   917110100   917110100   91711   91711   91711   91711   917110100   917110100   917110100   917110100   917110100   91711   92509   91711   917110100   91711   91711   91711   91711   917110100   917110100   91711   91711   91711   91711   917110100   917110100   917110100   917110100   917110100   91711   92509   91711   917110100   91711   91711   91711   91711   917110100   917110100   91711   91711   91711   91711   917110100   917110100   917110100   917110100   917110100
phon   9094450020   9093601190   9094450020   None   9094450020   9094450020   9094450020   9094450020   None   9094450020   9094450020      9094450020      9094450020      9094450020   9094450020      9094450020   9093601190   9094450020   None   9094450020   9094450020   9094450020   9094450020   None   9094450020   9094450020      9094450020      9094450020      9094450020   9094450020      9094450020   9093601190   9094450020   None   9094450020   9094450020   9094450020   9094450020   None   9094450020   9094450020      9094450020      9094450020      9094450020   9094450020      9094450020   9093601190   9094450020   None   9094450020   9094450020   9094450020   9094450020   None   9094450020   9094450020      9094450020      9094450020      9094450020   9094450020      9094450020   9093601190   9094450020   None   9094450020   9094450020   9094450020   9094450020   None   9094450020   9094450020      9094450020      9094450020      9094450020   9094450020      9094450020   9093601190   9094450020   None   9094450020   9094450020   9094450020   9094450020   None   9094450020   9094450020      9094450020      9094450020      9094450020   9094450020      9094450020   9093601190   9094450020   None   9094450020   9094450020   9094450020   9094450020   None   9094450020   9094450020      9094450020      9094450020      9094450020   9094450020      9094450020   9093601190   9094450020   None   9094450020   9094450020   9094450020   9094450020   None   9094450020   9094450020      9094450020      9094450020      9094450020   9094450020      9094450020   9093601190   9094450020   None   9094450020   9094450020   9094450020   9094450020   None   9094450020   9094450020      9094450020      9094450020      9094450020   9094450020      9094450020   9093601190   9094450020   None   9094450020   9094450020   9094450020   9094450020   None   9094450020   9094450020      9094450020      9094450020      9094450020   9094450020      9094450020   9093601190   9094450020   None   9094450020   9094450020   9094450020   9094450020   None   9094450020   9094450020      9094450020      9094450020      9094450020   9094450020      9094450020   9093601190   9094450020   None   9094450020   9094450020   9094450020   9094450020   None   9094450020   9094450020      9094450020      9094450020      9094450020   9094450020      9094450020   9093601190   9094450020   None   9094450020   9094450020   9094450020   9094450020   None   9094450020   9094450020      9094450020      9094450020      9094450020   9094450020   
fax   9094450367   None   None   None   9094450367   9094450367   9094450367   9094450367   None   None   9094450367   None   9094450367   None   9094450367      9094450367   9094450367      9094450367   None   None   None   9094450367   9094450367   9094450367   9094450367   None   None   9094450367   None   9094450367   None   9094450367      9094450367   9094450367      9094450367   None   None   None   9094450367   9094450367   9094450367   9094450367   None   None   9094450367   None   9094450367   None   9094450367      9094450367   9094450367      9094450367   None   None   None   9094450367   9094450367   9094450367   9094450367   None   None   9094450367   None   9094450367   None   9094450367      9094450367   9094450367      9094450367   None   None   None   9094450367   9094450367   9094450367   9094450367   None   None   9094450367   None   9094450367   None   9094450367      9094450367   9094450367      9094450367   None   None   None   9094450367   9094450367   9094450367   9094450367   None   None   9094450367   None   9094450367   None   9094450367      9094450367   9094450367      9094450367   None   None   None   9094450367   9094450367   9094450367   9094450367   None   None   9094450367   None   9094450367   None   9094450367      9094450367   9094450367      9094450367   None   None   None   9094450367   9094450367   9094450367   9094450367   None   None   9094450367   None   9094450367   None   9094450367      9094450367   9094450367      9094450367   None   None   None   9094450367   9094450367   9094450367   9094450367   None   None   9094450367   None   9094450367   None   9094450367      9094450367   9094450367      9094450367   None   None   None   9094450367   9094450367   9094450367   9094450367   None   None   9094450367   None   9094450367   None   9094450367      9094450367   9094450367      9094450367   None   None   None   9094450367   9094450367   9094450367   9094450367   None   None   9094450367   None   9094450367   None   9094450367      9094450367   9094450367      9094450367   None   None   None   9094450367   9094450367   9094450367   9094450367   None   None   9094450367   None   9094450367   None   9094450367      9094450367   9094450367      9094450367   None   None   None   9094450367   9094450367   9094450367   9094450367   None   None   9094450367   None   9094450367   None   9094450367      9094450367   9094450367   
email   [email protected]   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   None   [email protected]   [email protected]   None   [email protected]   None   [email protected]   None   [email protected]   [email protected]   None
Table: filers
filer_id   1146912
Table: lobbying_chg_log
filer_id   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912
change_no   4   1   2   0   5   8   9   6   11   12   15   13   14   16
session_id   2003   2003   2003   2003   2003   2011   2011   2009   2013   2013   2015   2015   2015   2017
log_dt   2003-05-29 00:00:00   2003-05-29 00:00:00   2003-05-29 00:00:00   2003-05-29 00:00:00   2003-05-29 00:00:00   2011-02-01 00:00:00   2011-02-01 00:00:00   2009-08-17 00:00:00   2013-01-31 00:00:00   2013-01-31 00:00:00   2015-11-02 00:00:00   2015-02-02 00:00:00   2015-02-02 00:00:00   2016-12-12 00:00:00
filer_type   2   2   2   2   2   2   2   2   2   2   2   2   2   2
correction_flg   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   None   Y   Y   None
action   NEW   ADD   NEW   ADDED   ADDED   ADDED   ADDED   WITHDREW   ADDED   ADDED   DELETED   ADDED   ADDED   IN SUSPENSE
attribute_changed   LOBBYIST      None   None   None   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST
ethics_dt   None   None   None   None   None   None   None   None   None   None   None   None   None   None
interests   None   None   None   None   None   None   None   None   None   None   None   None   None   None
filer_full_name   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS
filer_city   None   None   None   None   Claremont   None   None   None   None   None   None   None   None   None
filer_st   None   None   None   None   CA   None   None   None   None   None   None   None   None   None
filer_zip   None   None   None   None   91711   None   None   None   None   None   None   None   None   None
filer_phone   None   None   None   None   9094450020   None   None   None   None   None   None   None   None   None
entity_type   4   2   4   4   4   4   4   4   4   4   4   4   4   4
entity_name   LLORO, ALICIA A.   CALIFORNIA ASSOCIATION OF INDEPENDENT BUSINESS, INC. (CAIB)   COUCH, SARAH M.   MITTINO, AMY   CONLEY, MADELEINE K.   CONLEY, MADELEINE K.   MITTINO, AMY   LLORO, ALICIA A.   CONLEY, MADELEINE K.   MITTINO, AMY   MADELEINE K. CONLEY   CONLEY, MADELEINE K.   MITTINO, AMY   MITTINO, AMY
entity_city   None   None   None   None   None   None   None   None   None   None   None   None   None   None
entity_st   None   None   None   None   None   None   None   None   None   None   None   None   None   None
entity_zip   None   None   None   None   None   None   None   None   None   None   None   None   None   None
entity_phone   None   None   None   None   None   None   None   None   None   None   None   None   None   None
entity_id   1255211   0   1255213   1148761   None   1148762   1148761   1255211   1148762   1148761   1148762   1148762   1148761   1148761
responsible_officer   None   None   None   None   None   None   None   None   None   None   None   None   None   None
effect_dt   2003-05-15 00:00:00   2003-05-15 00:00:00   2003-05-15 00:00:00   2003-05-15 00:00:00   2003-05-15 00:00:00   2011-01-01 00:00:00   2011-01-01 00:00:00   2009-01-01 00:00:00   2013-01-31 00:00:00   2013-01-31 00:00:00   2015-09-30 00:00:00   2015-02-02 00:00:00   2015-02-02 00:00:00   2017-07-01 00:00:00
Table: received_filings
filer_id   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912   1146912
filing_file_name   792942_0.cal   792943_0.cal   99905.cal   792967_0.cal   807717_0.cal   836642_0.cal   853345_0.cal   882887_0.cal   903599_0.cal   931875_0.cal   355580.cal   903599_1.cal   947828_0.cal   281216.cal   986460_0.cal   968426_0.cal   1014236_0.cal   1025190_0.cal   1057127_0.cal   1075910_0.cal   1104813_0.cal   1117384_0.cal   1104813_1.cal   1117384_1.cal   1132883_0.cal   1146805_0.cal   85122.cal   85022.cal   85056.cal   85094.cal   85194.cal   1165075_0.cal   1186074_0.cal   1210103_0.cal   1186074_1.cal   1500720_0.cal   1428803_0.cal   1389773_0.cal   1344728_0.cal   1458168_0.cal   1449319_0.cal   1442362_0.cal   1368672_0.cal   1228088_0.cal   1482288_0.cal   1256197_0.cal   1281622_0.cal   1424192_0.cal   1294867_0.cal   1322521_0.cal   13139.cal   13128.cal   13097.cal   1306408_0.cal   13187.cal   1673891_0.cal   1737349_0.cal   1837671_0.cal   1799662_0.cal   1538479_0.cal   1566768_0.cal   1612187_0.cal   1814669_0.cal   1589585_0.cal   1616640_0.cal   22205.cal   22440.cal   1706237_1.cal   21731.cal   21811.cal   24998.cal   1758721_0.cal   1777769_0.cal   21969.cal   22240.cal   1627910_0.cal   1706237_0.cal   212270.cal   212312.cal   212348.cal   212396.cal   1653994_0.cal   1867838_0.cal   1964077_1.cal   1978472_0.cal   1990455_0.cal   1978472_1.cal   1990455_1.cal   2053863_1.cal   2053863_0.cal   2007998_0.cal   2109706_0.cal   2109709_0.cal   2028814_0.cal   2099158_0.cal   2099158_1.cal   1906903_0.cal   1964077_0.cal   43953.cal   44224.cal   45113.cal   45748.cal   58010.cal   2151851_2.cal   2169456_0.cal   2187678_3.cal   2187678_4.cal   2357873_0.cal   2304163_1.cal   2169456_1.cal   2187678_2.cal   2275207_1.cal   2403533_0.cal   2187678_1.cal   2380454_0.cal   2228054_2.cal   2187678_0.cal
received_date   2001-11-01 00:00:00   2001-11-01 00:00:00   2001-11-01 00:00:00   2001-11-01 00:00:00   2002-01-17 00:00:00   2002-04-23 00:00:00   2002-07-29 00:00:00   2002-10-30 00:00:00   2003-01-20 00:00:00   2003-04-30 00:00:00   2003-04-30 00:00:00   2003-04-30 00:00:00   2003-07-31 00:00:00   2003-07-31 00:00:00   2004-01-26 00:00:00   2003-10-29 00:00:00   2004-04-30 00:00:00   2004-07-23 00:00:00   2004-10-29 00:00:00   2005-01-26 00:00:00   2005-04-29 00:00:00   2005-07-29 00:00:00   2005-10-29 00:00:00   2005-10-29 00:00:00   2005-10-29 00:00:00   2006-01-30 00:00:00   2006-04-26 00:00:00   2006-04-26 00:00:00   2006-04-26 00:00:00   2006-04-26 00:00:00   2006-04-26 00:00:00   2006-04-26 00:00:00   2006-07-21 00:00:00   2006-10-23 00:00:00   2006-10-23 00:00:00   2010-07-15 00:00:00   2009-07-03 00:00:00   2009-01-15 00:00:00   2008-07-22 00:00:00   2010-01-18 00:00:00   2009-10-23 00:00:00   2009-08-12 00:00:00   2008-10-22 00:00:00   2007-01-16 00:00:00   2010-04-26 00:00:00   2007-04-11 00:00:00   2007-07-27 00:00:00   2009-05-19 00:00:00   2007-10-25 00:00:00   2008-04-02 00:00:00   2008-01-25 00:00:00   2008-01-25 00:00:00   2008-01-25 00:00:00   2008-01-25 00:00:00   2008-01-25 00:00:00   2012-07-24 00:00:00   2013-01-30 00:00:00   2014-04-10 00:00:00   2013-10-30 00:00:00   2010-10-29 00:00:00   2011-01-26 00:00:00   2011-08-11 00:00:00   2014-01-28 00:00:00   2011-04-28 00:00:00   2011-10-06 00:00:00   2013-04-17 00:00:00   2013-04-17 00:00:00   2013-04-17 00:00:00   2013-04-17 00:00:00   2013-04-17 00:00:00   2013-04-17 00:00:00   2013-04-17 00:00:00   2013-07-24 00:00:00   2013-04-17 00:00:00   2013-04-17 00:00:00   2012-01-11 00:00:00   2012-10-29 00:00:00   2012-04-24 00:00:00   2012-04-24 00:00:00   2012-04-24 00:00:00   2012-04-24 00:00:00   2012-04-24 00:00:00   2014-07-28 00:00:00   2015-07-28 00:00:00   2015-07-28 00:00:00   2015-10-02 00:00:00   2015-07-31 00:00:00   2015-10-02 00:00:00   2016-07-17 00:00:00   2016-07-07 00:00:00   2016-01-27 00:00:00   2016-12-06 00:00:00   2016-12-06 00:00:00   2016-04-15 00:00:00   2016-10-28 00:00:00   2016-10-28 00:00:00   2014-10-28 00:00:00   2015-04-29 00:00:00   2015-01-30 00:00:00   2015-01-30 00:00:00   2015-01-30 00:00:00   2015-01-30 00:00:00   2015-01-30 00:00:00   2017-07-18 00:00:00   2017-07-21 00:00:00   2018-11-09 00:00:00   2018-11-09 00:00:00   2019-02-12 00:00:00   2018-11-09 00:00:00   2018-11-09 00:00:00   2018-11-09 00:00:00   2018-11-09 00:00:00   2019-08-06 00:00:00   2018-03-01 00:00:00   2019-04-30 00:00:00   2018-11-09 00:00:00   2017-10-13 00:00:00
filing_directory   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/temp   /usr/users/cafiler/disclose/ca99/cal   /usr/users/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/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /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/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /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/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /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/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /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/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /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
filing_id   792942   792943   None   792967   807717   836642   853345   882887   903599   931875   None   903599   947828   None   986460   968426   1014236   1025190   1057127   1075910   1104813   1117384   1104813   1117384   1132883   1146805   None   None   None   None   None   1165075   1186074   1210103   1186074   1500720   1428803   1389773   1344728   1458168   1449319   1442362   1368672   1228088   1482288   1256197   1281622   1424192   1294867   1322521   None   None   None   1306408   None   1673891   1737349   1837671   1799662   1538479   1566768   1612187   1814669   1589585   1616640   None   None   1706237   None   None   None   1758721   1777769   None   None   1627910   1706237   None   None   None   None   1653994   1867838   1964077   1978472   1990455   1978472   1990455   2053863   2053863   2007998   2109706   2109709   2028814   2099158   2099158   1906903   1964077   None   None   None   None   None   2151851   2169456   2187678   2187678   2357873   2304163   2169456   2187678   2275207   2403533   2187678   2380454   2228054   2187678
form_id   F635   F635   None   F635   F635   F635   F635   F635   F635   F635   None   F635   F635   None   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   None   None   None   None   None   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F603   F635   F635   F635   F635   F635   F635   F635   F635   None   None   None   F635   None   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   None   None   F635   None   None   None   F635   F635   None   None   F635   F635   None   None   None   None   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F603   F603   F635   F635   F635   F635   F635   None   None   None   None   None   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635
receive_comment   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing passed validation, but failed DB constraints   Filing accepted, but with warnings   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing did not pass validation   Filing accepted   Filing accepted   Filing passed validation, but failed DB constraints   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 passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   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 did not pass validation   Filing did not pass validation   Filing did not pass validation   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 passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing accepted   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing accepted   Filing accepted   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing accepted   Filing accepted   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   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 passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   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