Home

Filer ID: 1143634

Table: filer_address
filer_id   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634
adrid   1109164   1108025   2044185   2080285   2085300   2119471   2162767   2205528   2523668   2415556   2492868   2470211   2514319   2278873   2297311   2343480   2548123
effect_dt   1995-01-01 00:00:00   1999-01-01 00:00:00   2003-01-01 00:00:00   2005-01-10 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   2020-02-01 00:00:00   2017-04-01 00:00:00   2020-04-01 00:00:00   2019-01-01 00:00:00   2021-01-01 00:00:00   2013-04-01 00:00:00   2013-01-01 00:00:00   2015-01-01 00:00:00   2023-01-01 00:00:00
add_type   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051
session_id   1995   1999   2003   2005   2005   2007   2009   2011   2019   2017   2019   2019   2021   2013   2013   2015   2023
Table: filer_filings
filer_id   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634
filing_id   465998   471249   481090   475523   482360   484637   488251   489639   485951   493352   476804   465998   479294   476804   489639   471249   468179   495626   496965   470006   473691   491959   464860   618352   631452   672429   661906   709262   696242   715578   754072   744200   739398   788991   770981   780419   780422   795944   811153   837904   828047   861521   841885   851902   908505   881760   902259   883669   906514   943434   933780   930016   966071   954307   967506   984738   1011706   995281   1024893   1026174   1014737   1075677   1068441   1055842   1093216   1061736   1082252   1113860   1103225   1132324   1143237   1163726   1184906   1229815   1222337   1213588   1259699   1248283   1280176   1305733   1293316   1776675   1962096   1976031   1865832   1811345   1794297   1902061   1327150   1344828   1387399   1412828   1393289   1374993   1419352   1433485   1450133   1462313   1481720   1502449   1419352   1534424   1563198   1555557   1563507   1602284   1588812   1632350   1620900   1653692   1673172   1931315   1920200   1709029   1722164   1731998   1738192   1840276   1761922   1991820   1939186   2268822   2268822   2395604   2189665   2354077   2524508   2481602   2004372   2031148   2059488   2120326   2097620   2150605   2171505   2206897   2415881   2467638   2344362   2239929   2481602   2378078   2598416   2310052   2268822   2436269   2467638   2611817   2598416   2671781   2640560   2547740   2598416   2576606   2563925   2619010   2703461   2746361
period_id   149   150   144   143   152   145   146   154   153   155   151   149   159   151   154   150   157   148   156   142   158   147   141   160   None   163   162   None   163   164   165   165   164   167   166   None   None   None   168   169   None   None   None   170   None   171   None   None   172   174   None   173   175   None   None   176   177   None   178   None   None   180   180   179   None   None   None   182   181   183   184   185   186   188   188   187   189   None   190   192   191   214   221   222   218   216   215   219   193   194   196   None   196   195   197   198   199   200   201   202   197   203   None   204   204   206   205   208   207   209   210   220   220   211   212   212   None   217   213   223   None   234   234   238   231   None   243   242   224   225   226   228   227   None   230   232   239   241   236   233   242   237   246   235   234   240   241   None   246   249   248   244   246   245   None   247   250   251
form_id   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F690   F635   F690   F690   F690   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F602   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F602   F635   F602   F635   F635   F635   F602   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F605   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635
filing_sequence   0   0   0   0   0   0   0   0   0   0   0   1   0   1   1   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   2   0   0   0   0   1   0   0   0   0   0   0   0   0   0   1   0   0   0   0   1   0   0   0   0   0   0   0   0   0   2   0   0   0   0   0
filing_date   1997-04-29 00:00:00   1997-07-29 00:00:00   1996-01-31 00:00:00   1996-01-11 00:00:00   1998-01-23 00:00:00   1996-04-26 00:00:00   1996-07-30 00:00:00   1998-07-29 00:00:00   1998-04-27 00:00:00   1998-10-29 00:00:00   1997-10-22 00:00:00   1998-02-20 00:00:00   1999-10-25 00:00:00   1998-02-20 00:00:00   1998-11-05 00:00:00   1998-02-20 00:00:00   1999-04-28 00:00:00   1997-01-31 00:00:00   1999-01-26 00:00:00   1995-07-31 00:00:00   1999-07-30 00:00:00   1996-10-31 00:00:00   1995-05-03 00:00:00   2000-01-26 00:00:00   2000-04-20 00:00:00   2000-10-19 00:00:00   2000-07-28 00:00:00   2000-12-22 00:00:00   2000-10-19 00:00:00   2001-01-27 00:00:00   2001-04-27 00:00:00   2001-04-26 00:00:00   2001-01-29 00:00:00   2001-10-24 00:00:00   2001-07-27 00:00:00   2001-07-31 00:00:00   2001-07-31 00:00:00   2001-10-25 00:00:00   2002-01-28 00:00:00   2002-04-26 00:00:00   2002-01-30 00:00:00   2002-07-29 00:00:00   2002-04-29 00:00:00   2002-07-25 00:00:00   2003-01-27 00:00:00   2002-10-29 00:00:00   2002-12-27 00:00:00   2002-10-29 00:00:00   2003-01-27 00:00:00   2003-07-22 00:00:00   2003-04-29 00:00:00   2003-04-29 00:00:00   2003-10-22 00:00:00   2003-07-23 00:00:00   2003-10-24 00:00:00   2004-01-22 00:00:00   2004-04-27 00:00:00   2004-01-26 00:00:00   2004-07-22 00:00:00   2004-07-26 00:00:00   2004-04-28 00:00:00   2005-01-26 00:00:00   2004-12-29 00:00:00   2004-10-28 00:00:00   2004-12-29 00:00:00   2004-10-28 00:00:00   2005-01-26 00:00:00   2005-07-25 00:00:00   2005-04-27 00:00:00   2005-10-28 00:00:00   2006-01-23 00:00:00   2006-04-21 00:00:00   2006-07-18 00:00:00   2007-01-22 00:00:00   2006-11-22 00:00:00   2006-10-27 00:00:00   2007-04-26 00:00:00   2007-01-02 00:00:00   2007-07-25 00:00:00   2008-01-24 00:00:00   2007-10-17 00:00:00   2013-07-19 00:00:00   2015-04-26 00:00:00   2015-07-22 00:00:00   2014-07-24 00:00:00   2014-01-20 00:00:00   2013-10-15 00:00:00   2014-10-22 00:00:00   2008-04-25 00:00:00   2008-07-22 00:00:00   2009-01-05 00:00:00   2009-01-06 00:00:00   2009-01-28 00:00:00   2008-10-29 00:00:00   2009-04-28 00:00:00   2009-07-24 00:00:00   2009-10-27 00:00:00   2010-01-28 00:00:00   2010-04-23 00:00:00   2010-07-22 00:00:00   2010-03-23 00:00:00   2010-10-25 00:00:00   2010-12-30 00:00:00   2010-12-30 00:00:00   2011-01-21 00:00:00   2011-07-22 00:00:00   2011-04-27 00:00:00   2012-01-26 00:00:00   2011-10-28 00:00:00   2012-04-23 00:00:00   2012-07-20 00:00:00   2015-01-28 00:00:00   2014-12-23 00:00:00   2012-10-31 00:00:00   2013-01-02 00:00:00   2013-01-25 00:00:00   2013-01-02 00:00:00   2014-04-22 00:00:00   2013-04-25 00:00:00   2015-10-13 00:00:00   2014-12-23 00:00:00   2018-08-17 00:00:00   2018-08-17 00:00:00   2019-07-29 00:00:00   2017-10-23 00:00:00   2018-12-17 00:00:00   2020-10-27 00:00:00   2020-07-29 00:00:00   2016-01-18 00:00:00   2016-04-22 00:00:00   2016-07-27 00:00:00   2017-01-18 00:00:00   2016-10-27 00:00:00   2017-04-10 00:00:00   2017-07-25 00:00:00   2018-01-27 00:00:00   2019-10-26 00:00:00   2020-04-28 00:00:00   2019-01-29 00:00:00   2018-04-27 00:00:00   2020-07-27 00:00:00   2019-04-27 00:00:00   2021-08-15 00:00:00   2018-10-22 00:00:00   2018-07-24 00:00:00   2020-01-27 00:00:00   2020-04-26 00:00:00   2021-05-05 00:00:00   2021-07-28 00:00:00   2022-04-27 00:00:00   2022-01-28 00:00:00   2021-01-26 00:00:00   2021-08-15 00:00:00   2021-04-25 00:00:00   2020-12-18 00:00:00   2021-10-25 00:00:00   2022-07-28 00:00:00   2022-10-29 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   10005   10005   10001   10005   10005   10005   10001   10005   10001   10005   10001   10001   10005   10005   10005   10001   10001   10005   10005   10005   10001   10005   10001   10005   10005   10001   10001   10005   10001   10001   10005   10005   10001   10001   10005   10001   10005   10005   10001   10001   10001   10005   10005   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10002   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10005   10002   10002   10001   10001   10001   10001   10002   10001   10001   10001   10001   10001   10005   10001   10001   10001   10002   10001   10001   10001   10001   10002   10001   10001   10001   10001   10002   10001   10001   10001   10001   10002   10001   10005   10001   10001   10001
stmnt_status   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11003   11001   11003   11001   11003   11003   11003   11001   11003   11003   11003   11001   11001   11001   11003   11001   11003   11001   11001   11003   11003   11001   11003   11003   11001   11001   11003   11003   11001   11003   11003   11001   11003   11003   11003   11001   11003   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   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11003   11003
session_id   1997   1997   1995   1995   1997   1995   1995   1997   1997   1997   1997   1997   1999   1997   1997   1997   1999   1995   1997   1995   1999   1995   1995   1999   1999   1999   1999   2001   1999   1999   2001   2001   1999   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2003   2001   2001   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2005   2003   2005   2003   2005   2005   2005   2005   2005   2005   2005   2005   2007   2005   2007   2007   2007   2007   2007   2013   2015   2015   2013   2013   2013   2013   2007   2007   2009   2009   2007   2007   2009   2009   2009   2009   2009   2009   2009   2009   2011   2011   2009   2011   2011   2011   2011   2011   2011   2013   2015   2011   2013   2011   2013   2013   2013   2015   2015   2017   2017   2019   2017   2019   2019   2019   2015   2015   2015   2015   2015   2017   2017   2017   2019   2019   2017   2017   2019   2019   2021   2017   2017   2019   2019   2019   2021   2021   2021   2019   2021   2021   2021   2021   2021   2021
user_id   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   GGILMORE   *   LTHIBAUL   SARRIAGA   LTHIBAUL   *   YBONILLA   *   LTHIBAUL   *   *   LTHIBAUL   LTHIBAUL   KLARRY   *   *   LTHIBAUL   LTHIBAUL   LTHIBAUL   *   LTHIBAUL   *   PBANFORD   LTHIBAUL   COMPLETED   COMPLETED   LTHIBAUL   COMPLETED   COMPLETED   LTHIBAUL   LTHIBAUL   COMPLETED   COMPLETED   LTHIBAUL   COMPLETED   EMCENTEE   LTHIBAUL   COMPLETED   COMPLETED   COMPLETED   BSMITH   EMCENTEE   KVANG   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   *   LTHIBAUL   LTHIBAUL   SARRIAGA   LTHIBAUL   LTHIBAUL   LTHIBAUL   AGLADNEY   MPACHECO   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   LTHIBAUL   YRODRIGU   YRODRIGU   YRODRIGU   JGRISSUM   JGRISSUM   JGRISSUM   JGRISSUM   MGUERRA   JINGRAM   ASAETERN   ASAETERN   JINGRAM   ASAETERN   MPACHECO   YRODRIGU   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   CAFILER   AGLADNEY   PBANFORD   ASAETERN   PBANFORD   AGLADNEY   AGLADNEY   MPACHECO   GKURIMOT   AGLADNEY   AGLADNEY   VUKSTINA   AGLADNEY   SARRIAGA   GTAYLOR   GTAYLOR   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   SARRIAGA   AGLADNEY   AGLADNEY   VUKSTINA   GTAYLOR   AGLADNEY   AGLADNEY   GTAYLOR   VUKSTINA   MKIRKHAM   AGLADNEY   AGLADNEY   GTAYLOR   GTAYLOR   MMERCHANT   MKIRKHAM   CAFILER   RATTIYEH   GTAYLOR   MKIRKHAM   GTAYLOR   MMERCHANT   GTAYLOR   CAFILER   CAFILER
special_audit   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   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   11003
fine_audit   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11001   11003   11003   11003   11003   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11003   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11003   11001   11001   11001   11001   11003   11001   11003   11003
rpt_start   1997-01-01 00:00:00   1997-04-01 00:00:00   1995-10-01 00:00:00   1995-07-01 00:00:00   1997-10-01 00:00:00   1996-01-01 00:00:00   1996-04-01 00:00:00   1998-04-01 00:00:00   1998-01-01 00:00:00   1998-07-01 00:00:00   1997-07-01 00:00:00   1997-01-01 00:00:00   1999-07-01 00:00:00   1997-07-01 00:00:00   1998-04-01 00:00:00   1997-04-01 00:00:00   1999-01-01 00:00:00   1996-10-01 00:00:00   1998-10-01 00:00:00   1995-04-01 00:00:00   1999-04-01 00:00:00   1996-07-01 00:00:00   1995-01-01 00:00:00   1999-10-01 00:00:00   2000-01-01 00:00:00   2000-07-01 00:00:00   2000-04-01 00:00:00   1900-01-01 00:00:00   2000-07-01 00:00:00   2000-10-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2000-10-01 00:00:00   2001-07-01 00:00:00   2001-04-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-04-01 00:00:00   2002-01-01 00:00:00   2002-04-01 00:00:00   2002-10-01 00:00:00   2002-07-01 00:00:00   1900-01-01 00:00:00   2002-07-01 00:00:00   2002-10-01 00:00:00   2003-04-01 00:00:00   2003-01-01 00:00:00   2003-01-01 00:00:00   2003-07-01 00:00:00   2003-04-01 00:00:00   2003-07-01 00:00:00   2003-10-01 00:00:00   2004-01-01 00:00:00   2003-10-01 00:00:00   2004-04-01 00:00:00   2004-04-01 00:00:00   2004-01-01 00:00:00   2004-10-01 00:00:00   2004-12-28 00:00:00   2004-07-01 00:00:00   1900-01-01 00:00:00   2004-07-01 00:00:00   2004-10-01 00:00:00   2005-04-01 00:00:00   2005-01-01 00:00:00   2005-07-01 00:00:00   2005-10-01 00:00:00   2006-01-01 00:00:00   2006-04-01 00:00:00   2006-10-01 00:00:00   2006-11-22 00:00:00   2006-07-01 00:00:00   2007-01-01 00:00:00   1900-01-01 00:00:00   2007-04-01 00:00:00   2007-10-01 00:00:00   2007-07-01 00:00:00   2013-04-01 00:00:00   2015-01-01 00:00:00   2015-04-01 00:00:00   2014-04-01 00:00:00   2013-10-01 00:00:00   2013-07-01 00:00:00   2014-07-01 00:00:00   2008-01-01 00:00:00   2008-04-01 00:00:00   2008-12-03 00:00:00   1900-01-01 00:00:00   2008-10-01 00:00:00   2008-07-01 00:00:00   2009-01-01 00:00:00   2009-04-01 00:00:00   2009-07-01 00:00:00   2009-10-01 00:00:00   2010-01-01 00:00:00   2010-04-01 00:00:00   2009-01-01 00:00:00   2010-07-01 00:00:00   None   2010-11-12 00:00:00   2010-10-01 00:00:00   2011-04-01 00:00:00   2011-01-01 00:00:00   2011-10-01 00:00:00   2011-07-01 00:00:00   2012-01-01 00:00:00   2012-04-01 00:00:00   2014-10-01 00:00:00   2014-11-11 00:00:00   2012-07-01 00:00:00   2012-11-08 00:00:00   2012-10-01 00:00:00   1900-01-01 00:00:00   2014-01-01 00:00:00   2013-01-01 00:00:00   2015-07-01 00:00:00   1900-01-01 00:00:00   2018-04-01 00:00:00   2018-04-01 00:00:00   2019-04-01 00:00:00   2017-07-01 00:00:00   1900-01-01 00:00:00   2020-07-01 00:00:00   2020-04-01 00:00:00   2015-10-01 00:00:00   2016-01-01 00:00:00   2016-04-01 00:00:00   2016-10-01 00:00:00   2016-07-01 00:00:00   1900-01-01 00:00:00   2017-04-01 00:00:00   2017-10-01 00:00:00   2019-07-01 00:00:00   2020-01-01 00:00:00   2018-10-01 00:00:00   2018-01-01 00:00:00   2020-04-01 00:00:00   2019-01-01 00:00:00   2021-04-01 00:00:00   2018-07-01 00:00:00   2018-04-01 00:00:00   2019-10-01 00:00:00   2020-01-01 00:00:00   1900-01-01 00:00:00   2021-04-01 00:00:00   2022-01-01 00:00:00   2021-10-01 00:00:00   2020-10-01 00:00:00   2021-04-01 00:00:00   2021-01-01 00:00:00   1900-01-01 00:00:00   2021-07-01 00:00:00   2022-04-01 00:00:00   2022-07-01 00:00:00
rpt_end   1997-03-31 00:00:00   1997-06-30 00:00:00   1995-12-31 00:00:00   1995-09-30 00:00:00   1997-12-31 00:00:00   1996-03-31 00:00:00   1996-06-30 00:00:00   1998-06-30 00:00:00   1998-03-31 00:00:00   1998-09-30 00:00:00   1997-09-30 00:00:00   1997-03-31 00:00:00   1999-09-30 00:00:00   1997-09-30 00:00:00   1998-06-30 00:00:00   1997-06-30 00:00:00   1999-03-31 00:00:00   1996-12-31 00:00:00   1998-12-31 00:00:00   1995-06-30 00:00:00   1999-06-30 00:00:00   1996-09-30 00:00:00   1995-03-31 00:00:00   1999-12-31 00:00:00   2000-03-31 00:00:00   2000-09-30 00:00:00   2000-06-30 00:00:00   1900-01-01 00:00:00   2000-09-30 00:00:00   2000-12-31 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2000-12-31 00:00:00   2001-09-30 00:00:00   2001-06-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-06-30 00:00:00   2002-03-31 00:00:00   2002-06-30 00:00:00   2002-12-31 00:00:00   2002-09-30 00:00:00   1900-01-01 00:00:00   2002-09-30 00:00:00   2002-12-31 00:00:00   2003-06-30 00:00:00   2003-03-31 00:00:00   2003-03-31 00:00:00   2003-09-30 00:00:00   2003-06-30 00:00:00   2003-09-30 00:00:00   2003-12-31 00:00:00   2004-03-31 00:00:00   2003-12-31 00:00:00   2004-06-30 00:00:00   2004-06-30 00:00:00   2004-03-31 00:00:00   2004-12-31 00:00:00   2004-12-28 00:00:00   2004-09-30 00:00:00   1900-01-01 00:00:00   2004-09-30 00:00:00   2004-12-31 00:00:00   2005-06-30 00:00:00   2005-03-31 00:00:00   2005-09-30 00:00:00   2005-12-31 00:00:00   2006-03-31 00:00:00   2006-06-30 00:00:00   2006-12-31 00:00:00   2006-11-22 00:00:00   2006-09-30 00:00:00   2007-03-31 00:00:00   1900-01-01 00:00:00   2007-06-30 00:00:00   2007-12-31 00:00:00   2007-09-30 00:00:00   2013-06-30 00:00:00   2015-03-31 00:00:00   2015-06-30 00:00:00   2014-06-30 00:00:00   2013-12-31 00:00:00   2013-09-30 00:00:00   2014-09-30 00:00:00   2008-03-31 00:00:00   2008-06-30 00:00:00   2008-12-03 00:00:00   1900-01-01 00:00:00   2008-12-31 00:00:00   2008-09-30 00:00:00   2009-03-31 00:00:00   2009-06-30 00:00:00   2009-09-30 00:00:00   2009-12-31 00:00:00   2010-03-31 00:00:00   2010-06-30 00:00:00   2009-03-31 00:00:00   2010-09-30 00:00:00   None   2010-11-12 00:00:00   2010-12-31 00:00:00   2011-06-30 00:00:00   2011-03-31 00:00:00   2011-12-31 00:00:00   2011-09-30 00:00:00   2012-03-31 00:00:00   2012-06-30 00:00:00   2014-12-31 00:00:00   2014-11-11 00:00:00   2012-09-30 00:00:00   2012-11-08 00:00:00   2012-12-31 00:00:00   1900-01-01 00:00:00   2014-03-31 00:00:00   2013-03-31 00:00:00   2015-09-30 00:00:00   1900-01-01 00:00:00   2018-06-30 00:00:00   2018-06-30 00:00:00   2019-06-30 00:00:00   2017-09-30 00:00:00   1900-01-01 00:00:00   2020-09-30 00:00:00   2020-06-30 00:00:00   2015-12-31 00:00:00   2016-03-31 00:00:00   2016-06-30 00:00:00   2016-12-31 00:00:00   2016-09-30 00:00:00   1900-01-01 00:00:00   2017-06-30 00:00:00   2017-12-31 00:00:00   2019-09-30 00:00:00   2020-03-31 00:00:00   2018-12-31 00:00:00   2018-03-31 00:00:00   2020-06-30 00:00:00   2019-03-31 00:00:00   2021-06-30 00:00:00   2018-09-30 00:00:00   2018-06-30 00:00:00   2019-12-31 00:00:00   2020-03-31 00:00:00   1900-01-01 00:00:00   2021-06-30 00:00:00   2022-03-31 00:00:00   2021-12-31 00:00:00   2020-12-31 00:00:00   2021-06-30 00:00:00   2021-03-31 00:00:00   1900-01-01 00:00:00   2021-09-30 00:00:00   2022-06-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
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   22001   22001   None   22001   22001   None   None   22001   22001   None   22001   None   None   22001   22001   22001   None   None   None   22001   22001   22001   22001   22001   22001   22001   22006   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   None   22001   22001   22001   22001   None   22001   22006   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   None   22001   22001   22001
Table: filer_interests
filer_id   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634
session_id   2001   2003   1999   1995   1997   2007   2005   2011   2013   2009   2017   2019   2015   2021   2023
interest_cd   40301   40301   40301   40301   40301   40301   40301   40301   40301   40301   40312   40312   40301   40312   40312
effect_date   2001-01-01 00:00:00   2003-01-01 00:00:00   1999-01-01 00:00:00   1995-01-01 00:00:00   1997-01-01 00:00:00   2007-01-01 00:00:00   2005-01-01 00:00:00   2011-01-01 00:00:00   2013-01-01 00:00:00   2009-01-01 00:00:00   2017-04-01 00:00:00   2019-01-01 00:00:00   2015-01-01 00:00:00   2021-01-01 00:00:00   2023-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634
filer_type   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1
active   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   N
race   0   0   0   0   None   0   0   None   None   None   None   None   None   None   None
session_id   1995   1999   1997   2001   2003   2005   2007   2011   2013   2009   2021   2015   2019   2017   2023
category   0   0   0   0   None   0   0   None   None   None   None   None   None   None   None
category_type   0   0   0   0   None   0   0   None   None   None   None   None   None   None   None
sub_category   0   0   0   0   None   0   0   None   None   None   None   None   None   None   None
effect_dt   1995-01-01 00:00:00   1999-01-01 00:00:00   1997-01-01 00:00:00   2001-01-01 00:00:00   2003-01-01 00:00:00   2005-01-01 00:00:00   2007-01-01 00:00:00   2011-01-01 00:00:00   2013-01-01 00:00:00   2009-01-01 00:00:00   2021-01-01 00:00:00   2015-01-01 00:00:00   2019-01-01 00:00:00   2017-04-01 00:00:00   2023-01-01 00:00:00
sub_category_type   0   0   0   0   None   0   0   None   None   None   None   None   None   None   None
election_type   0   0   0   0   None   0   0   None   None   None   None   None   None   None   None
sub_category_a   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
nyq_dt   None   None   None   None   None   2000-07-01 00:00:00   2000-07-01 00:00:00   None   None   None   None   None   None   None   None
party_cd   None   None   None   None   None   0   0   None   None   None   None   None   None   None   None
county_cd   None   None   None   None   None   0   0   None   None   None   None   None   None   None   None
district_cd   None   None   None   None   None   0   0   None   None   None   None   None   None   None   None
Table: filer_xref
filer_id   1143634
xref_id   C23579
effect_dt   1999-12-08 00:00:00
migration_source   MASTER
Table: filername
xref_filer_id   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579   C23579
filer_id   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634
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   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   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   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   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   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00
naml   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION (CAPCA)   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)
namf   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
adr1   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
adr2   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
city   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO
st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   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   95834   95814   95834   95834   95834   95834   95834   95834   95833   95834   95833   95833   95833   95833   95833   95825   95833   95834   95814   95834   95834   95834   95834   95834   95834   95833   95834   95833   95833   95833   95833   95833   95825   95833   95834   95814   95834   95834   95834   95834   95834   95834   95833   95834   95833   95833   95833   95833   95833   95825   95833   95834   95814   95834   95834   95834   95834   95834   95834   95833   95834   95833   95833   95833   95833   95833   95825   95833   95834   95814   95834   95834   95834   95834   95834   95834   95833   95834   95833   95833   95833   95833   95833   95825   95833   95834   95814   95834   95834   95834   95834   95834   95834   95833   95834   95833   95833   95833   95833   95833   95825   95833   95834   95814   95834   95834   95834   95834   95834   95834   95833   95834   95833   95833   95833   95833   95833   95825   95833   95834   95814   95834   95834   95834   95834   95834   95834   95833   95834   95833   95833   95833   95833   95833   95825   95833   95834   95814   95834   95834   95834   95834   95834   95834   95833   95834   95833   95833   95833   95833   95833   95825   95833   95834   95814   95834   95834   95834   95834   95834   95834   95833   95834   95833   95833   95833   95833   95833   95825   95833   95834   95814   95834   95834   95834   95834   95834   95834   95833   95834   95833   95833   95833   95833   95833   95825   95833   95834   95814   95834   95834   95834   95834   95834   95834   95833   95834   95833   95833   95833   95833   95833   95825   95833   95834   95814   95834   95834   95834   95834   95834   95834   95833   95834   95833   95833   95833   95833   95833   95825   95833   95834   95814   95834   95834   95834   95834   95834   95834   95833   95834   95833   95833   95833   95833   95833   95825   95833   95834   95814   95834   95834   95834   95834   95834   95834   95833   95834   95833   95833   95833   95833   95833   95825   95833
phon   9169281625   9164432476   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9164432476   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9164432476   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9164432476   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9164432476   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9164432476   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9164432476   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9164432476   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9164432476   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9164432476   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9164432476   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9164432476   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9164432476   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9164432476   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9164432476   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625   9169281625
fax   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   1143634
Table: lobbying_chg_log
filer_id   1143634   1143634   1143634   1143634
change_no   1   2   3   4
session_id   1999   1999   2017   2021
log_dt   2000-10-18 00:00:00   2000-10-18 00:00:00   2017-04-10 00:00:00   2020-12-18 00:00:00
filer_type   1   1   1   1
correction_flg   None   None   Y   None
action   SET ACTIVE   SET ACTIVE   ADDED   CHANGED
attribute_changed   CLIENT   CLIENT   FIRM   RESPONSIBLE OFFICER
ethics_dt   None   None   None   None
interests   None   None   None   None
filer_full_name   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA AGRICULTURAL PRODUCTION CONSULTANTS ASSOCIATION   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)   CALIFORNIA ASSOCIATION OF PEST CONTROL ADVISERS (CAPCA)
filer_city   Kingsburg   SOUTH PASADENA   SACRAMENTO   None
filer_st   CA   CA   CA   None
filer_zip   936319232   91030   95834   None
filer_phone   2098972362   6264413107   9169281625   None
entity_type   3   3   3   20
entity_name   GUALCO GROUP, THE   GUALCO GROUP, THE   KAHN, SOARES, & CONWAY, LLP.   CHIEF EXECUTIVE OFFICER/PRESIDENT RUTHANN ANDERSON
entity_city   None   None   None   None
entity_st   None   None   None   None
entity_zip   None   None   None   None
entity_phone   None   None   None   None
entity_id   1147392   1147392   None   1395789
responsible_officer   None   None   None   None
effect_dt   None   None   2017-04-01 00:00:00   2021-01-01 00:00:00
Table: lobbyist_contributions1
filer_id   1143634   1143634   1143634   1143634   1143634   1143634   1143634
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
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
contribution_dt   None   None   None   None   None   None   None
recipient_name   CAROLE MIGDEN LEADERSHIP COMMITTEE   GOVERNOR GRAY DAVIS COMMITTEE   PERATA FOR SENATE   COMMITTEE TO ELECT JIM BRULTE   POOCHIGIAN SENATE COMMITTEE   MACHADO FOR SENATE   ACKERMANN FOR SENATE COMMITTEE
recipient_id   1251896   1069390   1075392   1231483   1076065   1075516   1075514
amount   1000   1000   1000   1000   1000   1000   1000
Table: lobbyist_contributions2
filer_id   1143634   1143634   1143634   1143634   1143634   1143634   1143634
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
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
contribution_dt   None   None   None   None   None   None   None
recipient_name   CAROLE MIGDEN LEADERSHIP COMMITTEE   GOVERNOR GRAY DAVIS COMMITTEE   PERATA FOR SENATE   COMMITTEE TO ELECT JIM BRULTE   POOCHIGIAN SENATE COMMITTEE   MACHADO FOR SENATE   ACKERMANN FOR SENATE COMMITTEE
recipient_id   1251896   1069390   1075392   1231483   1076065   1075516   1075514
amount   1000   1000   1000   1000   1000   1000   1000
Table: received_filings
filer_id   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634   1143634
filing_file_name   672429_0.cal   715578_0.cal   744200_0.cal   770981_0.cal   788991_0.cal   811153_0.cal   837904_0.cal   851902_0.cal   881760_0.cal   906514_0.cal   930016_0.cal   943434_0.cal   966071_0.cal   984738_0.cal   1024893_0.cal   1055842_0.cal   1075677_0.cal   1103225_0.cal   1113860_0.cal   1143237_0.cal   1132324_0.cal   1163726_0.cal   1184906_0.cal   1502449_0.cal   1393289_0.cal   1344828_0.cal   1462313_0.cal   1450133_0.cal   1259699_0.cal   1229815_0.cal   1481720_0.cal   1419352_1.cal   1280176_0.cal   1419352_0.cal   1433485_0.cal   1293316_0.cal   1374993_0.cal   1327150_0.cal   509003.cal   508956.cal   509339.cal   1305733_0.cal   1213588_0.cal   1673172_0.cal   1731998_0.cal   1840276_0.cal   1794297_0.cal   1588812_0.cal   1534424_0.cal   1563507_0.cal   1620900_0.cal   1811345_0.cal   1602284_0.cal   1776675_0.cal   1632350_0.cal   1709029_0.cal   1653692_0.cal   1865832_0.cal   1976031_0.cal   2059488_0.cal   2004372_0.cal   2097620_0.cal   2120326_0.cal   1902061_0.cal   1931315_0.cal   2031148_0.cal   1962096_0.cal   1991820_0.cal   2171505_0.cal   2268822_2.cal   2268822_1.cal   2189665_0.cal   2436269_0.cal   2395604_0.cal   2206897_0.cal   2467638_1.cal   2239929_0.cal   2481602_0.cal   2344362_0.cal   2467638_0.cal   2310052_0.cal   2415881_0.cal   2268822_0.cal   2378078_0.cal   2576606_0.cal   2598416_2.cal   2671781_0.cal   2640560_0.cal   2524508_0.cal   2619010_0.cal   2598416_1.cal   2547740_0.cal   2703461_0.cal   2598416_0.cal   2746361_0.cal
received_date   2000-10-19 00:00:00   2001-01-27 00:00:00   2001-04-26 00:00:00   2001-07-27 00:00:00   2001-10-24 00:00:00   2002-01-28 00:00:00   2002-04-26 00:00:00   2002-07-25 00:00:00   2002-10-29 00:00:00   2003-01-27 00:00:00   2003-04-29 00:00:00   2003-07-22 00:00:00   2003-10-22 00:00:00   2004-01-22 00:00:00   2004-07-22 00:00:00   2004-10-28 00:00:00   2005-01-26 00:00:00   2005-04-27 00:00:00   2005-07-25 00:00:00   2006-01-23 00:00:00   2005-10-28 00:00:00   2006-04-21 00:00:00   2006-07-18 00:00:00   2010-07-22 00:00:00   2009-01-28 00:00:00   2008-07-22 00:00:00   2010-01-28 00:00:00   2009-10-27 00:00:00   2007-04-26 00:00:00   2007-01-22 00:00:00   2010-04-23 00:00:00   2010-03-23 00:00:00   2007-07-25 00:00:00   2009-04-28 00:00:00   2009-07-24 00:00:00   2007-10-17 00:00:00   2008-10-29 00:00:00   2008-04-25 00:00:00   2008-01-24 00:00:00   2008-01-24 00:00:00   2008-01-24 00:00:00   2008-01-24 00:00:00   2006-10-27 00:00:00   2012-07-20 00:00:00   2013-01-25 00:00:00   2014-04-22 00:00:00   2013-10-15 00:00:00   2011-04-27 00:00:00   2010-10-25 00:00:00   2011-01-21 00:00:00   2011-10-28 00:00:00   2014-01-20 00:00:00   2011-07-22 00:00:00   2013-07-19 00:00:00   2012-01-26 00:00:00   2012-10-31 00:00:00   2012-04-23 00:00:00   2014-07-24 00:00:00   2015-07-22 00:00:00   2016-07-27 00:00:00   2016-01-18 00:00:00   2016-10-27 00:00:00   2017-01-18 00:00:00   2014-10-22 00:00:00   2015-01-28 00:00:00   2016-04-22 00:00:00   2015-04-26 00:00:00   2015-10-13 00:00:00   2017-07-25 00:00:00   2018-08-17 00:00:00   2018-08-17 00:00:00   2017-10-23 00:00:00   2020-01-27 00:00:00   2019-07-29 00:00:00   2018-01-27 00:00:00   2020-04-28 00:00:00   2018-04-27 00:00:00   2020-07-27 00:00:00   2019-01-29 00:00:00   2020-04-26 00:00:00   2018-10-22 00:00:00   2019-10-26 00:00:00   2018-07-24 00:00:00   2019-04-27 00:00:00   2021-04-25 00:00:00   2021-08-15 00:00:00   2022-04-27 00:00:00   2022-01-28 00:00:00   2020-10-27 00:00:00   2021-10-25 00:00:00   2021-08-15 00:00:00   2021-01-26 00:00:00   2022-07-28 00:00:00   2021-07-28 00:00:00   2022-10-29 00:00:00
filing_directory   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /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/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
filing_id   672429   715578   744200   770981   788991   811153   837904   851902   881760   906514   930016   943434   966071   984738   1024893   1055842   1075677   1103225   1113860   1143237   1132324   1163726   1184906   1502449   1393289   1344828   1462313   1450133   1259699   1229815   1481720   1419352   1280176   1419352   1433485   1293316   1374993   1327150   None   None   None   1305733   1213588   1673172   1731998   1840276   1794297   1588812   1534424   1563507   1620900   1811345   1602284   1776675   1632350   1709029   1653692   1865832   1976031   2059488   2004372   2097620   2120326   1902061   1931315   2031148   1962096   1991820   2171505   2268822   2268822   2189665   2436269   2395604   2206897   2467638   2239929   2481602   2344362   2467638   2310052   2415881   2268822   2378078   2576606   2598416   2671781   2640560   2524508   2619010   2598416   2547740   2703461   2598416   2746361
form_id   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   None   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
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 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   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 did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted