Home

Filer ID: 1143749

Table: filer_address
filer_id   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749
adrid   1109335   1108190   2043970   2078618   2114743   2163426   2208272   2416316   2553389   2279410   2339599   2512521   2472078
effect_dt   1994-12-05 00:00:00   1999-01-01 00:00:00   2003-01-01 00:00:00   2005-01-01 00:00:00   2007-01-01 00:00:00   2009-01-01 00:00:00   2011-01-01 00:00:00   2017-01-01 00:00:00   2023-01-01 00:00:00   2013-01-01 00:00:00   2015-02-01 00:00:00   2021-01-01 00:00:00   2019-01-01 00:00:00
add_type   7050   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051
session_id   1995   1999   2003   2005   2007   2009   2011   2017   2023   2013   2015   2021   2019
Table: filer_filings
filer_id   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749
filing_id   674761   470153   468778   482446   474317   464993   486033   476892   489720   488386   492088   479912   493433   495751   497044   475668   481233   492088   484774   486033   481233   466082   471335   484774   488386   625923   623747   615192   651603   662981   729112   709364   718329   694977   751562   745280   789419   770146   777944   794766   811169   838166   819864   842926   863430   890371   854003   882459   897651   901721   920538   931010   911991   947706   935236   989628   969501   973320   955471   1001122   1030245   1013567   1018683   1068258   1036040   1063853   1059172   1059172   1098386   1088701   1080248   1097290   1103377   1129043   1144327   1117932   1129491   1165034   1185877   1215328   1231857   1241435   1259163   1259163   1279103   1779089   1978552   1868343   1961289   1906556   1297025   1309889   1327395   1347973   1373164   1393547   1413876   1432861   1419089   1462448   1449868   1504917   1484147   1536970   1551269   1569880   1589973   1569880   1604491   1633436   1621547   1655951   1813228   1798367   1676617   1932523   1718525   1706047   1732973   1841969   1745891   1760349   1996370   1991274   2468479   2415935   2333684   2236193   2435801   2375754   2011236   2033666   2059637   2098981   2122853   2173375   2155777   2136408   2269354   2189369   2310855   2480916   2528340   2206137   2542467   2339781   2391911   2550977   2338817   2555846   2576976   2617016   2674706   2704176   2601163   2639175   2704176   2739375   2739375   2739375
period_id   163   142   157   152   158   141   153   151   154   146   147   159   155   148   156   143   144   147   145   153   144   149   150   145   146   161   None   160   161   162   164   None   164   163   165   165   167   166   None   None   168   169   None   None   None   None   170   171   172   None   None   173   172   174   None   176   175   None   None   None   178   177   None   180   None   None   179   179   None   None   180   None   181   None   184   182   183   185   186   187   188   None   189   189   190   214   222   218   221   219   191   192   193   194   195   196   None   198   197   200   199   202   201   203   None   204   205   204   206   208   207   209   216   215   210   220   212   211   212   217   None   213   223   None   241   239   237   233   240   237   224   225   226   227   228   230   229   None   234   231   235   242   243   232   245   None   238   244   236   None   245   247   249   250   246   248   250   251   251   251
form_id   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F690   F690   F690   F690   F635   F635   F635   F635   F690   F635   F690   F635   F690   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F602   F635   F602   F635   F690   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F602   F635   F635   F602   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F602   F602   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635
filing_sequence   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   1   1   1   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   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   1   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   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   1   2   0
filing_date   2000-10-24 00:00:00   1995-07-31 00:00:00   1999-04-30 00:00:00   1998-02-02 00:00:00   1999-08-02 00:00:00   1995-05-01 00:00:00   1998-04-30 00:00:00   1997-10-31 00:00:00   1998-07-31 00:00:00   1996-07-30 00:00:00   1996-10-30 00:00:00   1999-11-01 00:00:00   1998-11-02 00:00:00   1997-01-31 00:00:00   1999-02-01 00:00:00   1995-10-31 00:00:00   1996-07-01 00:00:00   1997-01-31 00:00:00   1997-01-31 00:00:00   1998-07-27 00:00:00   1996-02-01 00:00:00   1997-04-29 00:00:00   1997-08-01 00:00:00   1996-04-30 00:00:00   1997-01-31 00:00:00   2000-04-28 00:00:00   2000-02-25 00:00:00   2000-01-31 00:00:00   2000-06-20 00:00:00   2000-07-31 00:00:00   2001-01-31 00:00:00   2000-12-29 00:00:00   2001-01-31 00:00:00   2000-10-27 00:00:00   2001-04-30 00:00:00   2001-04-29 00:00:00   2001-10-25 00:00:00   2001-07-26 00:00:00   2001-07-31 00:00:00   2001-10-31 00:00:00   2002-01-28 00:00:00   2002-04-29 00:00:00   2002-01-31 00:00:00   2002-04-29 00:00:00   2002-07-31 00:00:00   2002-10-31 00:00:00   2002-07-30 00:00:00   2002-10-29 00:00:00   2002-12-23 00:00:00   2002-12-24 00:00:00   2003-01-31 00:00:00   2003-04-30 00:00:00   2003-01-31 00:00:00   2003-07-31 00:00:00   2003-04-30 00:00:00   2004-01-30 00:00:00   2003-10-31 00:00:00   2003-10-31 00:00:00   2003-07-31 00:00:00   2004-02-02 00:00:00   2004-07-30 00:00:00   2004-04-30 00:00:00   2004-04-30 00:00:00   2004-12-29 00:00:00   2004-08-02 00:00:00   2004-11-01 00:00:00   2004-11-01 00:00:00   2005-01-07 00:00:00   2005-01-31 00:00:00   2004-12-28 00:00:00   2005-01-31 00:00:00   2005-02-01 00:00:00   2005-04-27 00:00:00   2005-01-11 00:00:00   2006-01-25 00:00:00   2005-07-31 00:00:00   2005-10-21 00:00:00   2006-04-26 00:00:00   2006-07-21 00:00:00   2006-10-30 00:00:00   2007-01-26 00:00:00   2006-12-18 00:00:00   2007-04-24 00:00:00   2007-07-23 00:00:00   2007-07-23 00:00:00   2013-07-26 00:00:00   2015-07-28 00:00:00   2014-07-29 00:00:00   2015-04-23 00:00:00   2014-10-27 00:00:00   2007-10-31 00:00:00   2008-01-30 00:00:00   2008-04-26 00:00:00   2008-07-29 00:00:00   2008-10-28 00:00:00   2009-01-28 00:00:00   2008-12-31 00:00:00   2009-07-23 00:00:00   2009-04-27 00:00:00   2010-01-28 00:00:00   2009-10-26 00:00:00   2010-07-29 00:00:00   2010-04-29 00:00:00   2010-10-27 00:00:00   2010-12-03 00:00:00   2011-01-30 00:00:00   2011-04-29 00:00:00   2011-03-16 00:00:00   2011-07-27 00:00:00   2012-01-28 00:00:00   2011-10-29 00:00:00   2012-04-27 00:00:00   2014-01-25 00:00:00   2013-10-29 00:00:00   2012-07-30 00:00:00   2015-01-29 00:00:00   2012-12-19 00:00:00   2012-10-28 00:00:00   2013-01-26 00:00:00   2014-04-26 00:00:00   2013-01-02 00:00:00   2013-04-22 00:00:00   2015-10-29 00:00:00   2015-02-03 00:00:00   2020-04-28 00:00:00   2019-10-27 00:00:00   2019-01-10 00:00:00   2018-04-25 00:00:00   2020-01-25 00:00:00   2019-04-22 00:00:00   2016-01-30 00:00:00   2016-04-27 00:00:00   2016-07-27 00:00:00   2016-10-28 00:00:00   2017-01-24 00:00:00   2017-07-28 00:00:00   2017-04-28 00:00:00   2016-12-13 00:00:00   2018-07-25 00:00:00   2017-10-22 00:00:00   2018-10-23 00:00:00   2020-07-25 00:00:00   2020-10-30 00:00:00   2018-01-26 00:00:00   2021-01-05 00:00:00   2018-12-21 00:00:00   2019-07-22 00:00:00   2021-01-29 00:00:00   2019-01-23 00:00:00   2020-12-29 00:00:00   2021-04-26 00:00:00   2021-10-20 00:00:00   2022-04-29 00:00:00   2022-07-29 00:00:00   2021-07-30 00:00:00   2022-01-27 00:00:00   2022-08-04 00:00:00   2022-10-24 00:00:00   2022-10-24 00:00:00   2022-10-23 00:00:00
stmnt_type   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10005   10005   10005   10005   10005   10005   10001   10005   10005   10001   10001   10001   10005   10005   10001   10001   10005   10005   10005   10005   10001   10001   10001   10005   10005   10001   10001   10001   10005   10001   10001   10005   10005   10005   10001   10001   10005   10001   10005   10005   10001   10002   10005   10005   10001   10005   10001   10006   10001   10001   10001   10001   10001   10001   10001   10005   10001   10002   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10002   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10002   10002   10002   10001
stmnt_status   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   11003   11001   11001   11003   11003   11003   11001   11001   11003   11003   11001   11001   11001   11001   11003   11003   11003   11001   11001   11003   11003   11003   11001   11003   11003   11001   11001   11001   11003   11003   11001   11003   11001   11001   11003   11003   11001   11001   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   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   11003   11003   11003   11003
session_id   1999   1995   1999   1997   1999   1995   1997   1997   1997   1995   1995   1999   1997   1995   1997   1995   1995   1995   1995   1997   1995   1997   1997   1995   1995   1999   1999   1999   1999   1999   1999   2001   1999   1999   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2003   2003   2001   2003   2001   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2005   2003   2003   2003   2003   2005   2005   2003   2005   2005   2003   2005   2005   2005   2005   2005   2005   2005   2007   2007   2007   2007   2013   2015   2013   2015   2013   2007   2007   2007   2007   2007   2007   2009   2009   2009   2009   2009   2009   2009   2009   2009   2009   2011   2009   2011   2011   2011   2011   2013   2013   2011   2013   2013   2011   2011   2013   2013   2013   2015   2015   2019   2019   2019   2017   2019   2019   2015   2015   2015   2015   2015   2017   2017   2017   2017   2017   2017   2019   2019   2017   2021   2019   2019   2019   2017   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021
user_id   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   TTHAM   CFLAGG   CFLAGG   JLEHMAN   YBONILLA   YBONILLA   YBONILLA   *   YBONILLA   YBONILLA   *   *   *   LTHIBAUL   LTHIBAUL   *   *   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   *   *   *   SARRIAGA   LTHIBAUL   COMPLETED   COMPLETED   COMPLETED   LTHIBAUL   COMPLETED   COMPLETED   LTHIBAUL   LTHIBAUL   LTHIBAUL   COMPLETED   COMPLETED   LTHIBAUL   COMPLETED   YBONILLA   LTHIBAUL   COMPLETED   COMPLETED   LTHIBAUL   CFLAGG   COMPLETED   GPEREZ   LTHIBAUL   GGILMORE   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   GPEREZ   LTHIBAUL   LTHIBAUL   LTHIBAUL   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   JINGRAM   JINGRAM   SARRIAGA   MGUERRA   MGUERRA   JINGRAM   MGUERRA   ASAETERN   ASAETERN   ASAETERN   CFLAGG   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   MPACHECO   SMCCONNAN   AGLADNEY   ASAETERN   ASAETERN   SMCCONNAN   ASAETERN   AGLADNEY   PBANFORD   GTAYLOR   VUKSTINA   YRODRIGU   AGLADNEY   GTAYLOR   VUKSTINA   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   SARRIAGA   AGLADNEY   AGLADNEY   AGLADNEY   GTAYLOR   GTAYLOR   AGLADNEY   AROJAS   YRODRIGU   SUSHAKOV   GTAYLOR   AGLADNEY   AROJAS   GTAYLOR   GTAYLOR   CAFILER   CAFILER   CHATRIDGE   MKIRKHAM   CAFILER   CAFILER   CAFILER   CAFILER
special_audit   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   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11002   11002   11002   11002   11003   11003   11003   11003   11002   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003
fine_audit   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   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   11001   11001   11001   11001   11001   11003   11003   11003   11003   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11003   11003   11001   11001   11001   11003   11001   11001   11003   11003   11001   11001   11003   11003   11003   11003
rpt_start   2000-07-01 00:00:00   1995-04-01 00:00:00   1999-01-01 00:00:00   1997-10-01 00:00:00   1999-04-01 00:00:00   1995-01-01 00:00:00   1998-01-01 00:00:00   1997-07-01 00:00:00   1998-04-01 00:00:00   1996-04-01 00:00:00   1996-07-01 00:00:00   1999-07-01 00:00:00   1998-07-01 00:00:00   1996-10-01 00:00:00   1998-10-01 00:00:00   1995-07-01 00:00:00   1995-10-01 00:00:00   1996-07-01 00:00:00   1996-01-01 00:00:00   1998-01-01 00:00:00   1995-10-01 00:00:00   1997-01-01 00:00:00   1997-04-01 00:00:00   1996-01-01 00:00:00   1996-04-01 00:00:00   2000-01-01 00:00:00   1999-10-01 00:00:00   1999-10-01 00:00:00   2000-01-01 00:00:00   2000-04-01 00:00:00   2000-10-01 00:00:00   1900-01-01 00:00:00   2000-10-01 00:00:00   2000-07-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-07-01 00:00:00   2001-04-01 00:00:00   2001-04-01 00:00:00   2001-07-01 00:00:00   2001-10-01 00:00:00   2002-01-01 00:00:00   2001-10-01 00:00:00   2002-01-01 00:00:00   2002-04-01 00:00:00   2002-07-01 00:00:00   2002-04-01 00:00:00   2002-07-01 00:00:00   2002-12-24 00:00:00   1900-01-01 00:00:00   2002-10-01 00:00:00   2003-01-01 00:00:00   2002-10-01 00:00:00   2003-04-01 00:00:00   2003-01-01 00:00:00   2003-10-01 00:00:00   2003-07-01 00:00:00   2003-07-01 00:00:00   2003-04-01 00:00:00   2003-10-01 00:00:00   2004-04-01 00:00:00   2004-01-01 00:00:00   2004-01-01 00:00:00   2004-12-29 00:00:00   2004-04-01 00:00:00   2004-07-01 00:00:00   2004-07-01 00:00:00   2004-07-01 00:00:00   2004-10-01 00:00:00   1900-01-01 00:00:00   2004-10-01 00:00:00   1900-01-01 00:00:00   2005-01-01 00:00:00   2004-07-01 00:00:00   2005-10-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-10-01 00:00:00   1900-01-01 00:00:00   2007-01-01 00:00:00   2007-01-01 00:00:00   2007-04-01 00:00:00   2013-04-01 00:00:00   2015-04-01 00:00:00   2014-04-01 00:00:00   2015-01-01 00:00:00   2014-07-01 00:00:00   2007-07-01 00:00:00   2007-10-01 00:00:00   2008-01-01 00:00:00   2008-04-01 00:00:00   2008-07-01 00:00:00   2008-10-01 00:00:00   1900-01-01 00:00:00   2009-04-01 00:00:00   2009-01-01 00:00:00   2009-10-01 00:00:00   2009-07-01 00:00:00   2010-04-01 00:00:00   2010-01-01 00:00:00   2010-07-01 00:00:00   1900-01-01 00:00:00   2010-10-01 00:00:00   2011-01-01 00:00:00   2010-10-01 00:00:00   2011-04-01 00:00:00   2011-10-01 00:00:00   2011-07-01 00:00:00   2012-01-01 00:00:00   2013-10-01 00:00:00   2013-07-01 00:00:00   2012-04-01 00:00:00   2014-10-01 00:00:00   2012-12-19 00:00:00   2012-07-01 00:00:00   2012-10-01 00:00:00   2014-01-01 00:00:00   1900-01-01 00:00:00   2013-01-01 00:00:00   2015-07-01 00:00:00   1900-01-01 00:00:00   2020-01-01 00:00:00   2019-07-01 00:00:00   2019-01-10 00:00:00   2018-01-01 00:00:00   2019-10-01 00:00:00   2019-01-01 00:00:00   2015-10-01 00:00:00   2016-01-01 00:00:00   2016-04-01 00:00:00   2016-07-01 00:00:00   2016-10-01 00:00:00   2017-04-01 00:00:00   2017-01-01 00:00:00   1900-01-01 00:00:00   2018-04-01 00:00:00   2017-07-01 00:00:00   2018-07-01 00:00:00   2020-04-01 00:00:00   2020-07-01 00:00:00   2017-10-01 00:00:00   2021-01-05 00:00:00   1900-01-01 00:00:00   2019-04-01 00:00:00   2020-10-01 00:00:00   2018-10-01 00:00:00   1900-01-01 00:00:00   2021-01-01 00:00:00   2021-07-01 00:00:00   2022-01-01 00:00:00   2022-04-01 00:00:00   2021-04-01 00:00:00   2021-10-01 00:00:00   2022-04-01 00:00:00   2022-07-01 00:00:00   2022-07-01 00:00:00   2022-07-01 00:00:00
rpt_end   2000-09-30 00:00:00   1995-06-30 00:00:00   1999-03-31 00:00:00   1997-12-31 00:00:00   1999-06-30 00:00:00   1995-03-31 00:00:00   1998-03-31 00:00:00   1997-09-30 00:00:00   1998-06-30 00:00:00   1996-06-30 00:00:00   1996-09-30 00:00:00   1999-09-30 00:00:00   1998-09-30 00:00:00   1996-12-31 00:00:00   1998-12-31 00:00:00   1995-09-30 00:00:00   1995-12-31 00:00:00   1996-09-30 00:00:00   1996-03-31 00:00:00   1998-03-31 00:00:00   1995-12-31 00:00:00   1997-03-31 00:00:00   1997-06-30 00:00:00   1996-03-31 00:00:00   1996-06-30 00:00:00   2000-03-31 00:00:00   1999-12-31 00:00:00   1999-12-31 00:00:00   2000-03-31 00:00:00   2000-06-30 00:00:00   2000-12-31 00:00:00   1900-01-01 00:00:00   2000-12-31 00:00:00   2000-09-30 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-09-30 00:00:00   2001-06-30 00:00:00   2001-06-30 00:00:00   2001-09-30 00:00:00   2001-12-31 00:00:00   2002-03-31 00:00:00   2001-12-31 00:00:00   2002-03-31 00:00:00   2002-06-30 00:00:00   2002-09-30 00:00:00   2002-06-30 00:00:00   2002-09-30 00:00:00   2002-12-24 00:00:00   1900-01-01 00:00:00   2002-12-31 00:00:00   2003-03-31 00:00:00   2002-12-31 00:00:00   2003-06-30 00:00:00   2003-03-31 00:00:00   2003-12-31 00:00:00   2003-09-30 00:00:00   2003-09-30 00:00:00   2003-06-30 00:00:00   2003-12-31 00:00:00   2004-06-30 00:00:00   2004-03-31 00:00:00   2004-04-30 00:00:00   2004-12-29 00:00:00   2004-06-30 00:00:00   2004-09-30 00:00:00   2004-09-30 00:00:00   2004-09-30 00:00:00   2004-12-31 00:00:00   1900-01-01 00:00:00   2004-12-31 00:00:00   1900-01-01 00:00:00   2005-03-31 00:00:00   2004-09-30 00:00:00   2005-12-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-12-31 00:00:00   1900-01-01 00:00:00   2007-03-31 00:00:00   2007-03-31 00:00:00   2007-06-30 00:00:00   2013-06-30 00:00:00   2015-06-30 00:00:00   2014-06-30 00:00:00   2015-03-31 00:00:00   2014-09-30 00:00:00   2007-09-30 00:00:00   2007-12-31 00:00:00   2008-03-31 00:00:00   2008-06-30 00:00:00   2008-09-30 00:00:00   2008-12-31 00:00:00   1900-01-01 00:00:00   2009-06-30 00:00:00   2009-03-31 00:00:00   2009-12-31 00:00:00   2009-09-30 00:00:00   2010-06-30 00:00:00   2010-03-31 00:00:00   2010-09-30 00:00:00   1900-01-01 00:00:00   2010-12-31 00:00:00   2011-03-31 00:00:00   2010-12-31 00:00:00   2011-06-30 00:00:00   2011-12-31 00:00:00   2011-09-30 00:00:00   2012-03-31 00:00:00   2013-12-31 00:00:00   2013-09-30 00:00:00   2012-06-30 00:00:00   2014-12-31 00:00:00   2012-12-19 00:00:00   2012-09-30 00:00:00   2012-12-31 00:00:00   2014-03-31 00:00:00   1900-01-01 00:00:00   2013-03-31 00:00:00   2015-09-30 00:00:00   1900-01-01 00:00:00   2020-03-31 00:00:00   2019-09-30 00:00:00   2019-01-10 00:00:00   2018-03-31 00:00:00   2019-12-31 00:00:00   2019-03-31 00:00:00   2015-12-31 00:00:00   2016-03-31 00:00:00   2016-06-30 00:00:00   2016-09-30 00:00:00   2016-12-31 00:00:00   2017-06-30 00:00:00   2017-03-31 00:00:00   1900-01-01 00:00:00   2018-06-30 00:00:00   2017-09-30 00:00:00   2018-09-30 00:00:00   2020-06-30 00:00:00   2020-09-30 00:00:00   2017-12-31 00:00:00   2021-01-05 00:00:00   1900-01-01 00:00:00   2019-06-30 00:00:00   2020-12-31 00:00:00   2018-12-31 00:00:00   1900-01-01 00:00:00   2021-03-31 00:00:00   2021-09-30 00:00:00   2022-03-31 00:00:00   2022-06-30 00:00:00   2021-06-30 00:00:00   2021-12-31 00:00:00   2022-06-30 00:00:00   2022-09-30 00:00:00   2022-09-30 00:00:00   2022-09-30 00:00:00
rpt_date   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   22001   22001   22001   None   22001   22001   None   None   None   22001   22001   None   22001   None   None   22001   22001   None   None   22001   None   22001   None   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   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   22006   22001   22001   22001   None   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001
Table: filer_interests
filer_id   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749
session_id   2001   2005   2003   1999   1995   1997   2013   2007   2009   2011   2017   2015   2019   2023   2021
interest_cd   40304   40304   40304   40304   40304   40304   40304   40304   40304   40304   40304   40304   40304   40304   40304
effect_date   2001-01-01 00:00:00   2005-01-01 00:00:00   2003-01-01 00:00:00   1999-01-01 00:00:00   1994-12-05 00:00:00   1997-01-01 00:00:00   2013-01-01 00:00:00   2007-01-01 00:00:00   2009-01-01 00:00:00   2011-01-01 00:00:00   2017-01-01 00:00:00   2015-02-01 00:00:00   2019-01-01 00:00:00   2023-01-01 00:00:00   2021-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749
filer_type   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1
active   Y   Y   Y   Y   Y   Y   T   Y   Y   Y   Y   Y   Y   Y   N   Y   Y   N
race   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None   None   None
session_id   1997   1995   1999   2001   2003   2005   2005   2005   2007   2013   2011   2009   2017   2019   2015   2015   2021   2023
category   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None   None   None
category_type   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None   None   None
sub_category   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None   None   None
effect_dt   1997-01-01 00:00:00   1994-12-05 00:00:00   1999-01-01 00:00:00   2001-01-01 00:00:00   2003-01-01 00:00:00   2005-02-01 00:00:00   2005-01-10 00:00:00   2005-01-01 00:00:00   2007-01-01 00:00:00   2013-01-01 00:00:00   2011-01-01 00:00:00   2009-01-01 00:00:00   2017-01-01 00:00:00   2019-01-01 00:00:00   2015-01-01 00:00:00   2015-02-01 00:00:00   2021-01-01 00:00:00   2023-01-01 00:00:00
sub_category_type   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None   None   None
election_type   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None   None   None
sub_category_a   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
nyq_dt   None   None   None   None   None   2000-07-01 00:00:00   None   None   2000-07-01 00:00:00   None   None   None   None   None   None   None   None   None
party_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
county_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
district_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: filer_xref
filer_id   1143749
xref_id   C24446
effect_dt   1999-12-08 00:00:00
migration_source   MASTER
Table: filername
xref_filer_id   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446   C24446
filer_id   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749
filer_type   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT
status   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE
effect_dt   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00
naml   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL I.E.   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. - MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS   COOPERATIVE OF AMERICAN PHYSICIANS   COOPERATIVE OF AMERICAN PHYSICIANS   COOPERATIVE OF AMERICAN PHYSICIANS   COOPERATIVE OF AMERICAN PHYSICIANS   COOPERATIVE OF AMERICAN PHYSICIANS   COOPERATIVE OF AMERICAN PHYSICIANS   COOPERATIVE OF AMERICAN PHYSICIANS   COOPERATIVE OF AMERICAN PHYSICIANS   COOPERATIVE OF AMERICAN PHYSICIANS   COOPERATIVE OF AMERICAN PHYSICIANS   COOPERATIVE OF AMERICAN PHYSICIANS   COOPERATIVE OF AMERICAN PHYSICIANS   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. MUTUAL PROTECTIVE TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. MUTUAL PROTECTIVE TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. MUTUAL PROTECTIVE TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. MUTUAL PROTECTIVE TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. MUTUAL PROTECTIVE TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. MUTUAL PROTECTIVE TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. MUTUAL PROTECTIVE TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. MUTUAL PROTECTIVE TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. MUTUAL PROTECTIVE TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. MUTUAL PROTECTIVE TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. MUTUAL PROTECTIVE TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. MUTUAL PROTECTIVE TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. MUTUAL PROTECTIVE TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST
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
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
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
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
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
city   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES
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
zip4   900711409   900102419   900711409   90071   900711409   900711409   90071   90071   90071   900711409   900711409   900711409   900711409   900711409   900102419   900711409   90071   900711409   900711409   90071   90071   90071   900711409   900711409   900711409   900711409   900711409   900102419   900711409   90071   900711409   900711409   90071   90071   90071   900711409   900711409   900711409   900711409   900711409   900102419   900711409   90071   900711409   900711409   90071   90071   90071   900711409   900711409   900711409   900711409   900711409   900102419   900711409   90071   900711409   900711409   90071   90071   90071   900711409   900711409   900711409   900711409   900711409   900102419   900711409   90071   900711409   900711409   90071   90071   90071   900711409   900711409   900711409   900711409   900711409   900102419   900711409   90071   900711409   900711409   90071   90071   90071   900711409   900711409   900711409   900711409   900711409   900102419   900711409   90071   900711409   900711409   90071   90071   90071   900711409   900711409   900711409   900711409   900711409   900102419   900711409   90071   900711409   900711409   90071   90071   90071   900711409   900711409   900711409   900711409   900711409   900102419   900711409   90071   900711409   900711409   90071   90071   90071   900711409   900711409   900711409   900711409   900711409   900102419   900711409   90071   900711409   900711409   90071   90071   90071   900711409   900711409   900711409   900711409   900711409   900102419   900711409   90071   900711409   900711409   90071   90071   90071   900711409   900711409   900711409   900711409   900711409   900102419   900711409   90071   900711409   900711409   90071   90071   90071   900711409   900711409   900711409   900711409   900711409   900102419   900711409   90071   900711409   900711409   90071   90071   90071   900711409   900711409   900711409   900711409   900711409   900102419   900711409   90071   900711409   900711409   90071   90071   90071   900711409   900711409   900711409   900711409
phon   2134738600   2132510600   2134738600   2134738740   2134738740   2134738740   2134738740   2134738651   2134738651   2134738651   2134738651   2134738651   2134738651   2134738600   2132510600   2134738600   2134738740   2134738740   2134738740   2134738740   2134738651   2134738651   2134738651   2134738651   2134738651   2134738651   2134738600   2132510600   2134738600   2134738740   2134738740   2134738740   2134738740   2134738651   2134738651   2134738651   2134738651   2134738651   2134738651   2134738600   2132510600   2134738600   2134738740   2134738740   2134738740   2134738740   2134738651   2134738651   2134738651   2134738651   2134738651   2134738651   2134738600   2132510600   2134738600   2134738740   2134738740   2134738740   2134738740   2134738651   2134738651   2134738651   2134738651   2134738651   2134738651   2134738600   2132510600   2134738600   2134738740   2134738740   2134738740   2134738740   2134738651   2134738651   2134738651   2134738651   2134738651   2134738651   2134738600   2132510600   2134738600   2134738740   2134738740   2134738740   2134738740   2134738651   2134738651   2134738651   2134738651   2134738651   2134738651   2134738600   2132510600   2134738600   2134738740   2134738740   2134738740   2134738740   2134738651   2134738651   2134738651   2134738651   2134738651   2134738651   2134738600   2132510600   2134738600   2134738740   2134738740   2134738740   2134738740   2134738651   2134738651   2134738651   2134738651   2134738651   2134738651   2134738600   2132510600   2134738600   2134738740   2134738740   2134738740   2134738740   2134738651   2134738651   2134738651   2134738651   2134738651   2134738651   2134738600   2132510600   2134738600   2134738740   2134738740   2134738740   2134738740   2134738651   2134738651   2134738651   2134738651   2134738651   2134738651   2134738600   2132510600   2134738600   2134738740   2134738740   2134738740   2134738740   2134738651   2134738651   2134738651   2134738651   2134738651   2134738651   2134738600   2132510600   2134738600   2134738740   2134738740   2134738740   2134738740   2134738651   2134738651   2134738651   2134738651   2134738651   2134738651   2134738600   2132510600   2134738600   2134738740   2134738740   2134738740   2134738740   2134738651   2134738651   2134738651   2134738651   2134738651   2134738651   2134738600   2132510600   2134738600   2134738740   2134738740   2134738740   2134738740   2134738651   2134738651   2134738651   2134738651   2134738651   2134738651
fax   2134738774   None   2134738774   2134738774                              2134738774   None   2134738774   2134738774                              2134738774   None   2134738774   2134738774                              2134738774   None   2134738774   2134738774                              2134738774   None   2134738774   2134738774                              2134738774   None   2134738774   2134738774                              2134738774   None   2134738774   2134738774                              2134738774   None   2134738774   2134738774                              2134738774   None   2134738774   2134738774                              2134738774   None   2134738774   2134738774                              2134738774   None   2134738774   2134738774                              2134738774   None   2134738774   2134738774                              2134738774   None   2134738774   2134738774                              2134738774   None   2134738774   2134738774                              2134738774   None   2134738774   2134738774                           
email   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: filers
filer_id   1143749
Table: lobbying_chg_log
filer_id   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749
change_no   2   3   1   4   6   5   8   7   0   9   10   11   12
session_id   1999   1999   1999   1999   2001   2001   2001   2001   2005   2009   2009   2015   2021
log_dt   2000-08-08 00:00:00   2000-11-09 00:00:00   2000-08-08 00:00:00   2000-12-05 00:00:00   2001-03-20 00:00:00   2001-03-20 00:00:00   2001-04-05 00:00:00   2001-04-05 00:00:00   2005-02-01 00:00:00   2010-11-30 00:00:00   2010-11-16 00:00:00   2015-02-03 00:00:00   2020-12-29 00:00:00
filer_type   1   1   1   1   1   1   1   1   1   1   1   1   1
correction_flg   None   None   None   None   None   None   None   None   Y   Y   Y   Y   None
action   SET INACTIVE   SET INACTIVE   SET INACTIVE   SET ACTIVE   IN SUSPENSE   IN SUSPENSE   IN SUSPENSE   IN SUSPENSE   ADDED   DELETED   ADDED   ADDED   CHANGED
attribute_changed   None   CLIENT   None   CLIENT   CLIENT   CLIENT   EMPLOYER   CLIENT   None   FIRM   FIRM   FIRM   RESPONSIBLE OFFICER
ethics_dt   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
filer_full_name   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS/MUTUAL PROTECTION TRUST   COOPERATIVE OF AMERICAN PHYSICIANS, INC. MUTUAL PROTECTIVE TRUST   COOPERATIVE OF AMERICAN PHYSICIANS   COOPERATIVE OF AMERICAN PHYSICIANS   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL IE   COOPERATIVE OF AMERICAN PHYSICIANS, INCLUDING THE COOPERATIVE OF AMERICAN PHYSICIANS FEDERAL INDEPENDENT EXPENDITURE
filer_city   None   JEAN   None   Grand Terrace   VERNON   ISSAQUAH   SACRAMENTO   BOTHELL   None   None   LOS ANGELES   None   None
filer_st   None   NV   None   CA   CA   WA   CA   WA   None   None   CA   None   None
filer_zip   None   89019   None   92323   90058   98027   95814   98011   None   None   900102419   None   None
filer_phone   None   7023821212   None   9097838400   3235838811   4253138266   9164417991   4253987517   None   None   2132510600   None   None
entity_type   3   3   3   3   3   3   3   3   3   3   3   3   20
entity_name   NIELSEN, MERKSAMER, PARRINELLO, MUELLER & NAYLOR LLP   NIELSEN, MERKSAMER, PARRINELLO, MUELLER & NAYLOR LLP   NIELSEN, MERKSAMER, PARRINELLO, MUELLER & NAYLOR LLP   NIELSEN, MERKSAMER, PARRINELLO, MUELLER & NAYLOR LLP   NIELSEN, MERKSAMER, PARRINELLO, MUELLER & NAYLOR LLP   NIELSEN, MERKSAMER, PARRINELLO, MUELLER & NAYLOR LLP   NIELSEN, MERKSAMER, PARRINELLO, MUELLER & NAYLOR LLP   NIELSEN, MERKSAMER, PARRINELLO, MUELLER & NAYLOR LLP   ROBINSON & ASSOCIATES, INC., RICHARD   ROBINSON & ASSOCIATES, INC.; RICHARD   BROWN GOVERNMENTAL RELATIONS; CRAIG   CAPITOL ADVOCACY, LLC   GENERAL COUNSEL GORDON T. OWNBY
entity_city   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
entity_zip   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
entity_id   1147313   1147313   1147313   1147313   1147313   1147313   1147313   1147313   1147420   1147420   None   0   1355533
responsible_officer   None   None   None   None   None   None   None   None   None   None   None   None   None
effect_dt   None   None   None   None   None   None   None   None   2005-02-01 00:00:00   2010-11-30 00:00:00   2010-12-01 00:00:00   2015-02-01 00:00:00   2021-01-01 00:00:00
Table: lobbyist_contributions1
filer_id   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749
filing_period_start_dt   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00
filing_period_end_dt   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00
contribution_dt   None   None   None   None   None   None   None   None   None   None
recipient_name   ACKERMAN FOR SENATE COMMITTEE 2000   CITIZENS TO ELECT RUSS BOGH   EDWARD CHAVEZ FOR ASSEMBLY   FRIENDS OF BARBARA MATTHEWS   FRIENDS OF MARK WYLAND   LOU CORREA FOR ASSEMBLY   MALDONADO FOR ASSEMBLY   MARTIN GALLEGOS FOR STATE SENATE   NATION FOR ASSEMBLY   SIMITIAN FOR CALIFORNIA STATE ASSEMBLY
recipient_id   1075514   1230666   1075999   1232571   1076296   1065492   1072662   1076022   1075712   1231461
amount   200   1000   500   500   500   500   500   1500   500   1000
Table: lobbyist_contributions2
filer_id   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749
filing_period_start_dt   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00
filing_period_end_dt   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00
contribution_dt   None   None   None   None   None   None   None   None   None   None
recipient_name   ACKERMAN FOR SENATE COMMITTEE 2000   CITIZENS TO ELECT RUSS BOGH   EDWARD CHAVEZ FOR ASSEMBLY   FRIENDS OF BARBARA MATTHEWS   FRIENDS OF MARK WYLAND   LOU CORREA FOR ASSEMBLY   MALDONADO FOR ASSEMBLY   MARTIN GALLEGOS FOR STATE SENATE   NATION FOR ASSEMBLY   SIMITIAN FOR CALIFORNIA STATE ASSEMBLY
recipient_id   1075514   1230666   1075999   1232571   1076296   1065492   1072662   1076022   1075712   1231461
amount   200   1000   500   500   500   500   500   1500   500   1000
Table: received_filings
filer_id   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749   1143749
filing_file_name   674761_0.cal   718329_0.cal   745280_0.cal   770146_0.cal   789419_0.cal   433423.cal   811169_0.cal   838166_0.cal   854003_0.cal   897651_0.cal   882459_0.cal   911991_0.cal   931010_0.cal   947706_0.cal   969501_0.cal   373002.cal   373600.cal   1103377_0.cal   1117932_0.cal   1129491_0.cal   1144327_0.cal   1165034_0.cal   1185877_0.cal   1327395_0.cal   1504917_0.cal   1419089_0.cal   1393547_0.cal   1347973_0.cal   1484147_0.cal   1462448_0.cal   1449868_0.cal   1215328_0.cal   1259163_1.cal   1279103_0.cal   1231857_0.cal   1259163_0.cal   1432861_0.cal   1297025_0.cal   1373164_0.cal   1309889_0.cal   1732973_0.cal   1676617_0.cal   1841969_0.cal   1798367_0.cal   1536970_0.cal   1706047_0.cal   1569880_1.cal   1569880_0.cal   1813228_0.cal   1589973_0.cal   1604491_0.cal   1760349_0.cal   1779089_0.cal   1621547_0.cal   1633436_0.cal   1655951_0.cal   1868343_0.cal   1978552_0.cal   2122853_0.cal   2059637_0.cal   1996370_0.cal   2011236_0.cal   2155777_0.cal   2098981_0.cal   1906556_0.cal   1961289_0.cal   2033666_0.cal   1932523_0.cal   2173375_0.cal   2236193_0.cal   2269354_0.cal   2189369_0.cal   2310855_0.cal   2391911_0.cal   2415935_0.cal   2375754_0.cal   2435801_0.cal   2206137_0.cal   2480916_0.cal   2338817_0.cal   2468479_0.cal   2550977_0.cal   2617016_0.cal   2739375_0.cal   2601163_0.cal   373112.cal   2739375_1.cal   2674706_0.cal   2528340_0.cal   2704176_0.cal   2704176_1.cal   2639175_0.cal   2739375_2.cal   2576976_0.cal
received_date   2000-10-24 00:00:00   2001-01-31 00:00:00   2001-04-29 00:00:00   2001-07-26 00:00:00   2001-10-25 00:00:00   2002-01-28 00:00:00   2002-01-28 00:00:00   2002-04-29 00:00:00   2002-07-30 00:00:00   2002-12-23 00:00:00   2002-10-29 00:00:00   2003-01-31 00:00:00   2003-04-30 00:00:00   2003-07-31 00:00:00   2003-10-31 00:00:00   2005-01-31 00:00:00   2005-01-31 00:00:00   2005-04-27 00:00:00   2005-07-31 00:00:00   2005-10-21 00:00:00   2006-01-25 00:00:00   2006-04-26 00:00:00   2006-07-21 00:00:00   2008-04-26 00:00:00   2010-07-29 00:00:00   2009-04-27 00:00:00   2009-01-28 00:00:00   2008-07-29 00:00:00   2010-04-29 00:00:00   2010-01-28 00:00:00   2009-10-26 00:00:00   2006-10-30 00:00:00   2007-07-23 00:00:00   2007-07-23 00:00:00   2007-01-26 00:00:00   2007-04-24 00:00:00   2009-07-23 00:00:00   2007-10-31 00:00:00   2008-10-28 00:00:00   2008-01-30 00:00:00   2013-01-26 00:00:00   2012-07-30 00:00:00   2014-04-26 00:00:00   2013-10-29 00:00:00   2010-10-27 00:00:00   2012-10-28 00:00:00   2011-03-16 00:00:00   2011-01-30 00:00:00   2014-01-25 00:00:00   2011-04-29 00:00:00   2011-07-27 00:00:00   2013-04-22 00:00:00   2013-07-26 00:00:00   2011-10-29 00:00:00   2012-01-28 00:00:00   2012-04-27 00:00:00   2014-07-29 00:00:00   2015-07-28 00:00:00   2017-01-24 00:00:00   2016-07-27 00:00:00   2015-10-29 00:00:00   2016-01-30 00:00:00   2017-04-28 00:00:00   2016-10-28 00:00:00   2014-10-27 00:00:00   2015-04-23 00:00:00   2016-04-27 00:00:00   2015-01-29 00:00:00   2017-07-28 00:00:00   2018-04-25 00:00:00   2018-07-25 00:00:00   2017-10-22 00:00:00   2018-10-23 00:00:00   2019-07-22 00:00:00   2019-10-27 00:00:00   2019-04-22 00:00:00   2020-01-25 00:00:00   2018-01-26 00:00:00   2020-07-25 00:00:00   2019-01-23 00:00:00   2020-04-28 00:00:00   2021-01-29 00:00:00   2021-10-20 00:00:00   2022-10-23 00:00:00   2021-07-30 00:00:00   2022-10-24 00:00:00   2022-10-24 00:00:00   2022-04-29 00:00:00   2020-10-30 00:00:00   2022-07-29 00:00:00   2022-08-04 00:00:00   2022-01-27 00:00:00   2022-10-24 00:00:00   2021-04-26 00:00:00
filing_directory   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/temp   /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/cal   /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/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/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
filing_id   674761   718329   745280   770146   789419   None   811169   838166   854003   897651   882459   911991   931010   947706   969501   None   None   1103377   1117932   1129491   1144327   1165034   1185877   1327395   1504917   1419089   1393547   1347973   1484147   1462448   1449868   1215328   1259163   1279103   1231857   1259163   1432861   1297025   1373164   1309889   1732973   1676617   1841969   1798367   1536970   1706047   1569880   1569880   1813228   1589973   1604491   1760349   1779089   1621547   1633436   1655951   1868343   1978552   2122853   2059637   1996370   2011236   2155777   2098981   1906556   1961289   2033666   1932523   2173375   2236193   2269354   2189369   2310855   2391911   2415935   2375754   2435801   2206137   2480916   2338817   2468479   2550977   2617016   2739375   2601163   None   2739375   2674706   2528340   2704176   2704176   2639175   2739375   2576976
form_id   F635   F635   F635   F635   F635   None   F635   F635   F635   F602   F635   F635   F635   F635   F635   None   None   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   None   F635   F635   F635   F635   F635   F635   F635   F635
receive_comment   Filing accepted, but but with warnings   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing did not pass validation   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing accepted, but with warnings   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 accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing passed validation, but failed DB constraints   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted