Home

Filer ID: 1145705

Table: filer_address
filer_id   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705
adrid   1113243   1111364   2012124   2045067   2078700   2118660   2163996   2206563   2465298   2413364   2549208   2269117   2338297   2505016
effect_dt   1997-01-01 00:00:00   1999-01-01 00:00:00   2001-01-01 00:00:00   2003-01-01 00:00:00   2005-01-01 00:00:00   2007-01-01 00:00:00   2009-01-01 00:00:00   2011-01-01 00:00:00   2019-01-01 00:00:00   2017-11-14 00:00:00   2023-01-01 00:00:00   2013-01-01 00:00:00   2015-01-01 00:00:00   2021-01-01 00:00:00
add_type   7050   7050   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051
session_id   1997   1999   2001   2003   2005   2007   2009   2011   2019   2017   2023   2013   2015   2021
Table: filer_filings
filer_id   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705
filing_id   679819   483552   468281   467096   479404   478022   494467   498062   472457   467096   473803   490821   472457   487170   490821   617772   630123   660243   690114   719356   715691   729615   752766   772904   745810   778686   792679   778073   794783   810935   842700   835103   820260   856739   863540   873876   909763   904100   898348   905936   885055   930773   944824   936279   954443   968323   974997   930773   905936   1007654   1007655   986020   1022037   1023119   1013584   997209   1018490   1053622   1074240   1053622   1064782   1101031   1092239   1083045   1128969   1144210   1128893   1113258   1161959   1184668   1161959   1229831   1216433   1258290   1245480   1279459   1764945   1978400   1865539   1800511   1782658   1959484   1928296   1295419   1328230   1309751   1356341   1379956   1417988   1391063   1409300   1429874   1457925   1447306   1503202   1480026   1530107   1556389   1530107   1564614   1561153   1588072   1602335   1629946   1622796   1642697   1643903   1653998   1678360   1814225   1905969   1915326   1923380   1706360   1712531   1706360   1888914   1712531   1738586   1731004   1725267   1842334   986020   1764945   1991916   1994471   1915326   2208121   2483484   2469102   2469102   2235143   2393788   2469102   2327932   2196202   2343922   2007867   2007867   2033167   2062696   2101296   2111921   2148495   2151709   2148495   2169602   2191468   2530312   2483484   2550162   2419124   2541131   2276701   2419124   2372740   2378023   2393788   2317173   2469102   2335741   2443768   2673672   2443768   2550162   2530312   2419124   2635212   2703427   2650654   2580342   2602390   2621731   2649766   2745936   2649766
period_id   163   152   157   149   159   151   155   156   150   149   158   154   150   153   154   160   None   162   163   164   None   164   165   166   165   None   167   None   None   168   None   169   None   170   None   171   None   None   172   172   None   173   174   None   None   175   None   173   172   None   None   176   178   None   177   None   None   179   180   179   None   181   None   None   None   184   183   182   185   186   185   188   187   189   None   190   213   222   218   215   214   221   220   191   193   192   194   195   197   196   None   198   200   199   202   201   203   204   203   None   204   205   206   208   207   None   209   209   210   216   219   220   None   211   212   210   None   219   212   None   None   217   176   213   None   223   223   232   242   241   241   233   238   241   236   None   236   224   224   225   226   227   228   228   229   228   230   231   243   242   244   239   None   234   239   None   237   238   235   241   None   240   249   240   244   243   239   249   250   None   245   246   247   248   251   248
form_id   F635   F635   F635   F635   F635   F635   F635   F635   F690   F690   F635   F690   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   F602   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F690   F690   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F690   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   F635   F635   F635   F635   F635   F602   F635   F602   F635   F635   F635   F635   F635   F605   F603   F635   F635   F635   F635   F603   F603   F635   F603   F635   F605   F603   F635   F603   F602   F635   F635   F635   F605   F635   F603   F635   F635   F635   F635   F635   F635   F635   F603   F603   F635   F635   F635   F635   F635   F635   F603   F635   F635   F635   F635   F635   F635   F635   F635   F635   F603   F635   F635   F605   F635   F635   F635   F635   F603   F635   F635   F635   F635   F635   F635   F602   F635   F602   F635   F635   F635   F635   F635   F635
filing_sequence   0   0   0   0   0   0   0   0   1   1   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   1   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   1   0   0   0   0   1   0   0   0   1   0   0   3   1   0   0   2   0   0   0   1   0   0   0   0   0   1   0   0   0   0   0   1   0   0   0   0   1   0   0   1   0   0   0   0   0   1   1   1   2   0   0   0   0   0   0   0   0   1
filing_date   2000-10-28 00:00:00   1998-01-29 00:00:00   1999-04-29 00:00:00   1997-11-05 00:00:00   1999-10-29 00:00:00   1997-11-05 00:00:00   1998-10-29 00:00:00   1999-01-27 00:00:00   1998-03-24 00:00:00   1998-03-24 00:00:00   1999-07-29 00:00:00   1998-11-23 00:00:00   1997-11-05 00:00:00   1998-04-29 00:00:00   1998-07-28 00:00:00   2000-01-31 00:00:00   2000-04-27 00:00:00   2000-07-31 00:00:00   2000-10-30 00:00:00   2001-01-31 00:00:00   2000-12-29 00:00:00   2001-01-31 00:00:00   2001-04-30 00:00:00   2001-07-31 00:00:00   2001-04-30 00:00:00   2001-07-31 00:00:00   2001-10-31 00:00:00   2001-07-31 00:00:00   2001-10-31 00:00:00   2002-01-27 00:00:00   2002-04-24 00:00:00   2002-04-12 00:00:00   2002-01-30 00:00:00   2002-07-31 00:00:00   2002-07-30 00:00:00   2002-10-14 00:00:00   2003-01-29 00:00:00   2002-12-30 00:00:00   2002-12-30 00:00:00   2003-01-24 00:00:00   2002-10-16 00:00:00   2003-04-29 00:00:00   2003-07-27 00:00:00   2003-04-30 00:00:00   2003-07-28 00:00:00   2003-10-28 00:00:00   2003-10-31 00:00:00   2004-01-24 00:00:00   2004-01-24 00:00:00   2004-01-26 00:00:00   2004-01-26 00:00:00   2004-01-24 00:00:00   2004-07-11 00:00:00   2004-07-12 00:00:00   2004-04-30 00:00:00   2004-01-26 00:00:00   2004-04-30 00:00:00   2004-10-25 00:00:00   2005-01-21 00:00:00   2005-01-21 00:00:00   2004-10-26 00:00:00   2005-04-19 00:00:00   2005-01-21 00:00:00   2004-12-31 00:00:00   2005-01-21 00:00:00   2006-01-25 00:00:00   2005-10-19 00:00:00   2005-07-21 00:00:00   2006-04-12 00:00:00   2006-07-17 00:00:00   2006-08-07 00:00:00   2007-01-22 00:00:00   2006-10-31 00:00:00   2007-04-20 00:00:00   2006-12-15 00:00:00   2007-07-24 00:00:00   2013-07-11 00:00:00   2015-07-28 00:00:00   2014-07-23 00:00:00   2013-10-31 00:00:00   2013-07-31 00:00:00   2015-04-20 00:00:00   2015-01-22 00:00:00   2007-10-26 00:00:00   2008-04-29 00:00:00   2008-01-30 00:00:00   2008-08-18 00:00:00   2008-11-04 00:00:00   2009-04-21 00:00:00   2009-01-22 00:00:00   2008-12-26 00:00:00   2009-07-09 00:00:00   2010-01-14 00:00:00   2009-10-09 00:00:00   2010-07-26 00:00:00   2010-04-15 00:00:00   2010-10-20 00:00:00   2010-12-31 00:00:00   2011-01-14 00:00:00   2010-12-30 00:00:00   2011-01-18 00:00:00   2011-04-25 00:00:00   2011-07-22 00:00:00   2012-01-20 00:00:00   2011-10-31 00:00:00   2012-01-06 00:00:00   2012-03-06 00:00:00   2012-04-24 00:00:00   2012-07-31 00:00:00   2014-01-28 00:00:00   2014-10-27 00:00:00   2014-11-18 00:00:00   2014-12-01 00:00:00   2012-11-28 00:00:00   2012-11-05 00:00:00   2012-10-29 00:00:00   2014-09-25 00:00:00   2014-09-23 00:00:00   2013-01-31 00:00:00   2013-01-15 00:00:00   2012-12-03 00:00:00   2014-04-28 00:00:00   2013-03-19 00:00:00   2013-04-30 00:00:00   2015-10-09 00:00:00   2015-10-26 00:00:00   2015-09-21 00:00:00   2018-01-29 00:00:00   2020-07-30 00:00:00   2020-07-30 00:00:00   2020-06-10 00:00:00   2018-04-24 00:00:00   2019-07-26 00:00:00   2020-07-20 00:00:00   2018-12-12 00:00:00   2017-11-14 00:00:00   2019-01-29 00:00:00   2016-03-04 00:00:00   2016-01-27 00:00:00   2016-04-27 00:00:00   2016-07-30 00:00:00   2016-10-31 00:00:00   2016-12-19 00:00:00   2017-04-18 00:00:00   2017-04-18 00:00:00   2017-03-28 00:00:00   2017-07-21 00:00:00   2017-10-27 00:00:00   2020-11-02 00:00:00   2020-08-04 00:00:00   2021-01-29 00:00:00   2019-10-31 00:00:00   2020-12-14 00:00:00   2018-07-31 00:00:00   2020-06-12 00:00:00   2019-03-04 00:00:00   2019-04-26 00:00:00   2020-07-20 00:00:00   2018-10-30 00:00:00   2020-04-29 00:00:00   2018-12-14 00:00:00   2020-01-31 00:00:00   2022-04-28 00:00:00   2020-07-20 00:00:00   2021-12-17 00:00:00   2021-11-23 00:00:00   2020-07-20 00:00:00   2022-01-18 00:00:00   2022-07-28 00:00:00   2022-01-06 00:00:00   2021-04-30 00:00:00   2021-08-02 00:00:00   2021-10-28 00:00:00   2022-02-14 00:00:00   2022-10-28 00:00:00   2022-11-04 00:00:00
stmnt_type   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10005   10005   10005   10001   10005   10005   10005   10001   10001   10005   10001   10005   10005   10001   10005   10001   10005   10001   10005   10001   10005   10005   10001   10001   10005   10001   10001   10005   10005   10001   10005   10002   10002   10006   10006   10001   10001   10005   10001   10005   10005   10001   10001   10002   10005   10001   10005   10005   10005   10001   10001   10001   10001   10001   10002   10001   10001   10001   10005   10001   10002   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10002   10005   10001   10001   10001   10001   10001   10006   10001   10001   10001   10001   10001   10001   10005   10002   10001   10001   10006   10002   10001   10005   10005   10001   10002   10001   10006   10001   10002   10001   10001   10002   10002   10001   10001   10002   10001   10005   10001   10002   10001   10001   10001   10001   10001   10002   10001   10001   10001   10001   10001   10002   10001   10001   10005   10001   10002   10005   10001   10002   10001   10001   10005   10001   10001   10002   10002   10002   10002   10001   10001   10005   10001   10001   10001   10001   10001   10002
stmnt_status   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11003   11003   11003   11003   11001   11001   11003   11001   11003   11001   11003   11001   11003   11001   11001   11003   11003   11001   11003   11003   11001   11001   11003   11001   11003   11003   11003   11003   11001   11003   11001   11003   11001   11001   11003   11003   11003   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   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11003   11003   11001   11001   11003   11001   11001   11001   11001   11001   11003   11003
session_id   1999   1997   1999   1997   1999   1997   1997   1997   1997   1997   1999   1997   1997   1997   1997   1999   1999   1999   1999   1999   2001   1999   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2003   2003   2001   2001   2003   2003   2003   2003   2003   2003   2003   2001   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   2007   2007   2013   2015   2013   2013   2013   2015   2013   2007   2007   2007   2007   2007   2009   2007   2009   2009   2009   2009   2009   2009   2009   2011   2009   2011   2009   2011   2011   2011   2011   2011   2011   2011   2011   2013   2013   2015   2015   2011   2013   2011   2013   2013   2011   2013   2013   2013   2003   2013   2015   2015   2015   2017   2019   2019   2019   2017   2019   2019   2019   2017   2017   2015   2015   2015   2015   2015   2017   2015   2017   2015   2017   2017   2019   2019   2019   2019   2021   2017   2019   2019   2019   2019   2017   2019   2019   2019   2021   2019   2019   2019   2019   2021   2021   2021   2021   2021   2021   2021   2021   2021
user_id   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   TTHAM   YBONILLA   YBONILLA   *   YBONILLA   YBONILLA   LTHIBAUL   *   *   LTHIBAUL   *   PROBERTS   LTHIBAUL   *   LTHIBAUL   *   LTHIBAUL   *   LTHIBAUL   *   LTHIBAUL   SARRIAGA   COMPLETED   COMPLETED   LTHIBAUL   COMPLETED   COMPLETED   LTHIBAUL   LTHIBAUL   COMPLETED   LTHIBAUL   COMPLETED   COMPLETED   EMCENTEE   DHORRELL   AGLADNEY   COMPLETED   LTHIBAUL   COMPLETED   LTHIBAUL   LTHIBAUL   COMPLETED   COMPLETED   COMPLETED   LTHIBAUL   LTHIBAUL   LTHIBAUL   GPEREZ   DWALKER   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   GPEREZ   LTHIBAUL   ASAETERN   AGLADNEY   AGLADNEY   ASAETERN   ASAETERN   AGLADNEY   MPACHECO   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   JINGRAM   MGUERRA   JINGRAM   DMCCASTL   MGUERRA   ASAETERN   MGUERRA   ASAETERN   ASAETERN   ASAETERN   PBANFORD   ASAETERN   PBANFORD   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   YRODRIGU   AGLADNEY   AGLADNEY   ASAETERN   ASAETERN   YRODRIGU   GKURIMOT   AGLADNEY   YRODRIGU   AGLADNEY   YRODRIGU   YRODRIGU   AGLADNEY   YRODRIGU   SARRIAGA   AGLADNEY   AGLADNEY   ASAETERN   YRODRIGU   JINGRAM   YRODRIGU   AGLADNEY   GTAYLOR   GTAYLOR   GTAYLOR   AGLADNEY   GTAYLOR   GTAYLOR   YRODRIGU   GPEREZ   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   CAFILER   AGLADNEY   AGLADNEY   KBANH   AGLADNEY   AGLADNEY   GTAYLOR   GTAYLOR   GTAYLOR   AGLADNEY   AROJAS   AGLADNEY   GTAYLOR   GPEREZ   AGLADNEY   GTAYLOR   AGLADNEY   GTAYLOR   DMCCASTL   GTAYLOR   CAFILER   GTAYLOR   CAFILER   CAFILER   GTAYLOR   CVANLIEW   CAFILER   CVANLIEW   GTAYLOR   CHATRIDGE   CHATRIDGE   CHATRIDGE   CAFILER   CAFILER
special_audit   11003   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   11002   11003   11002   11003   11002   11003   11002   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   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003
fine_audit   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   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   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11003   11001   11001   11001   11001   11001   11001   11003   11001   11003   11003   11001   11003   11003   11003   11001   11001   11001   11001   11003   11003
rpt_start   2000-07-01 00:00:00   1997-10-01 00:00:00   1999-01-01 00:00:00   1997-01-01 00:00:00   1999-07-01 00:00:00   1997-07-01 00:00:00   1998-07-01 00:00:00   1998-10-01 00:00:00   1997-04-01 00:00:00   1997-01-01 00:00:00   1999-04-01 00:00:00   1998-04-01 00:00:00   1997-04-01 00:00:00   1998-01-01 00:00:00   1998-04-01 00:00:00   1999-10-01 00:00:00   2000-01-01 00:00:00   2000-04-01 00:00:00   2000-07-01 00:00:00   2000-10-01 00:00:00   1900-01-01 00:00:00   2000-10-01 00:00:00   2001-01-01 00:00:00   2001-04-01 00:00:00   2001-01-01 00:00:00   2001-04-01 00:00:00   2001-07-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   2002-01-01 00:00:00   2001-10-01 00:00:00   2002-04-01 00:00:00   2002-04-01 00:00:00   2002-07-01 00:00:00   2002-10-01 00:00:00   1900-01-01 00:00:00   2002-12-30 00:00:00   2002-10-01 00:00:00   2002-07-01 00:00:00   2003-01-01 00:00:00   2003-04-01 00:00:00   2003-01-01 00:00:00   2003-04-01 00:00:00   2003-07-01 00:00:00   2003-07-01 00:00:00   2003-01-01 00:00:00   2002-10-01 00:00:00   2003-01-01 00:00:00   2002-10-01 00:00:00   2003-10-01 00:00:00   2004-04-01 00:00:00   2004-04-01 00:00:00   2004-01-01 00:00:00   2003-10-01 00:00:00   2004-01-01 00:00:00   2004-07-01 00:00:00   2004-10-01 00:00:00   2004-07-01 00:00:00   2004-07-01 00:00:00   2005-01-01 00:00:00   2004-10-01 00:00:00   1900-01-01 00:00:00   2004-07-01 00:00:00   2005-10-01 00:00:00   2005-07-01 00:00:00   2005-04-01 00:00:00   2006-01-01 00:00:00   2006-04-01 00:00:00   2006-01-01 00:00:00   2006-10-01 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   2013-01-01 00:00:00   2015-04-01 00:00:00   2014-04-01 00:00:00   2013-07-01 00:00:00   2013-04-01 00:00:00   2015-01-01 00:00:00   2014-10-01 00:00:00   2007-07-01 00:00:00   2008-01-01 00:00:00   2007-10-01 00:00:00   2008-04-01 00:00:00   2008-07-01 00:00:00   2009-01-01 00:00:00   2008-10-01 00:00:00   1900-01-01 00:00:00   2009-04-01 00:00:00   2009-10-01 00:00:00   2009-07-01 00:00:00   2010-04-01 00:00:00   2010-01-01 00:00:00   2010-07-01 00:00:00   2010-12-31 00:00:00   2010-07-01 00:00:00   1900-01-01 00:00:00   2010-10-01 00:00:00   2011-01-01 00:00:00   2011-04-01 00:00:00   2011-10-01 00:00:00   2011-07-01 00:00:00   1900-01-01 00:00:00   2012-03-06 00:00:00   2012-01-01 00:00:00   2012-04-01 00:00:00   2013-10-01 00:00:00   2014-07-01 00:00:00   2014-11-18 00:00:00   1900-01-01 00:00:00   2012-07-01 00:00:00   2012-11-05 00:00:00   2012-06-30 00:00:00   1900-01-01 00:00:00   2014-09-23 00:00:00   2012-10-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2014-01-01 00:00:00   2003-10-01 00:00:00   2013-01-01 00:00:00   1900-01-01 00:00:00   2015-07-01 00:00:00   2015-09-21 00:00:00   2017-10-01 00:00:00   2020-04-01 00:00:00   2020-01-01 00:00:00   2020-01-01 00:00:00   2018-01-01 00:00:00   2019-04-01 00:00:00   2020-01-01 00:00:00   2018-12-12 00:00:00   1900-01-01 00:00:00   2018-10-01 00:00:00   2015-10-01 00:00:00   2015-10-01 00:00:00   2016-01-01 00:00:00   2016-04-01 00:00:00   2016-07-01 00:00:00   2016-12-19 00:00:00   2016-10-01 00:00:00   2017-01-01 00:00:00   2016-10-01 00:00:00   2017-04-01 00:00:00   2017-07-01 00:00:00   2020-07-01 00:00:00   2020-04-01 00:00:00   2020-10-01 00:00:00   2019-07-01 00:00:00   1900-01-01 00:00:00   2018-04-01 00:00:00   2019-07-01 00:00:00   1900-01-01 00:00:00   2019-01-01 00:00:00   2019-04-01 00:00:00   2018-07-01 00:00:00   2020-01-01 00:00:00   1900-01-01 00:00:00   2019-10-01 00:00:00   2022-01-01 00:00:00   2019-10-01 00:00:00   2020-10-01 00:00:00   2020-07-01 00:00:00   2019-07-01 00:00:00   2022-01-18 00:00:00   2022-04-01 00:00:00   1900-01-01 00:00:00   2021-01-01 00:00:00   2021-04-01 00:00:00   2021-07-01 00:00:00   2021-10-01 00:00:00   2022-07-01 00:00:00   2021-10-01 00:00:00
rpt_end   2000-09-30 00:00:00   1997-12-31 00:00:00   1999-03-31 00:00:00   1997-03-31 00:00:00   1999-09-30 00:00:00   1997-09-30 00:00:00   1998-09-30 00:00:00   1998-12-31 00:00:00   1997-06-30 00:00:00   1997-03-31 00:00:00   1999-06-30 00:00:00   1998-06-30 00:00:00   1997-06-30 00:00:00   1998-03-31 00:00:00   1998-06-30 00:00:00   1999-12-31 00:00:00   2000-03-31 00:00:00   2000-06-30 00:00:00   2000-09-30 00:00:00   2000-12-31 00:00:00   1900-01-01 00:00:00   2000-12-31 00:00:00   2001-03-31 00:00:00   2001-06-30 00:00:00   2001-03-31 00:00:00   2001-06-30 00:00:00   2001-09-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   2002-03-31 00:00:00   2001-12-31 00:00:00   2002-06-30 00:00:00   2002-06-30 00:00:00   2002-09-30 00:00:00   2002-12-31 00:00:00   1900-01-01 00:00:00   2002-12-30 00:00:00   2002-12-31 00:00:00   2002-09-30 00:00:00   2003-03-31 00:00:00   2003-06-30 00:00:00   2003-03-31 00:00:00   2003-06-30 00:00:00   2003-09-30 00:00:00   2003-09-30 00:00:00   2003-03-31 00:00:00   2002-12-31 00:00:00   2003-03-31 00:00:00   2002-12-31 00:00:00   2003-12-31 00:00:00   2004-06-30 00:00:00   2004-06-30 00:00:00   2004-03-31 00:00:00   2003-12-31 00:00:00   2004-03-31 00:00:00   2004-09-30 00:00:00   2004-12-31 00:00:00   2004-09-30 00:00:00   2004-09-30 00:00:00   2005-03-31 00:00:00   2004-12-31 00:00:00   1900-01-01 00:00:00   2004-09-30 00:00:00   2005-12-31 00:00:00   2005-09-30 00:00:00   2005-06-30 00:00:00   2006-03-31 00:00:00   2006-06-30 00:00:00   2006-03-31 00:00:00   2006-12-31 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   2013-03-31 00:00:00   2015-06-30 00:00:00   2014-06-30 00:00:00   2013-09-30 00:00:00   2013-06-30 00:00:00   2015-03-31 00:00:00   2014-12-31 00:00:00   2007-09-30 00:00:00   2008-03-31 00:00:00   2007-12-31 00:00:00   2008-06-30 00:00:00   2008-09-30 00:00:00   2009-03-31 00:00:00   2008-12-31 00:00:00   1900-01-01 00:00:00   2009-06-30 00:00:00   2009-12-31 00:00:00   2009-09-30 00:00:00   2010-06-30 00:00:00   2010-03-31 00:00:00   2010-09-30 00:00:00   2010-12-31 00:00:00   2010-09-30 00:00:00   1900-01-01 00:00:00   2010-12-31 00:00:00   2011-03-31 00:00:00   2011-06-30 00:00:00   2011-12-31 00:00:00   2011-09-30 00:00:00   1900-01-01 00:00:00   2012-03-06 00:00:00   2012-03-31 00:00:00   2012-06-30 00:00:00   2013-12-31 00:00:00   2014-09-30 00:00:00   2014-11-18 00:00:00   1900-01-01 00:00:00   2012-09-30 00:00:00   2012-11-05 00:00:00   2012-09-30 00:00:00   1900-01-01 00:00:00   2014-09-23 00:00:00   2012-12-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2014-03-31 00:00:00   2003-12-31 00:00:00   2013-03-31 00:00:00   1900-01-01 00:00:00   2015-09-30 00:00:00   2015-09-21 00:00:00   2017-12-31 00:00:00   2020-06-30 00:00:00   2020-03-31 00:00:00   2020-03-31 00:00:00   2018-03-31 00:00:00   2019-06-30 00:00:00   2020-03-31 00:00:00   2018-12-12 00:00:00   1900-01-01 00:00:00   2018-12-31 00:00:00   2015-12-31 00:00:00   2015-12-31 00:00:00   2016-03-31 00:00:00   2016-06-30 00:00:00   2016-09-30 00:00:00   2016-12-19 00:00:00   2016-12-30 00:00:00   2017-03-31 00:00:00   2016-12-30 00:00:00   2017-06-30 00:00:00   2017-09-30 00:00:00   2020-09-30 00:00:00   2020-06-30 00:00:00   2020-12-31 00:00:00   2019-09-30 00:00:00   1900-01-01 00:00:00   2018-06-30 00:00:00   2019-09-30 00:00:00   1900-01-01 00:00:00   2019-03-31 00:00:00   2019-06-30 00:00:00   2018-09-30 00:00:00   2020-03-31 00:00:00   1900-01-01 00:00:00   2019-12-31 00:00:00   2022-03-31 00:00:00   2019-12-31 00:00:00   2020-12-31 00:00:00   2020-09-30 00:00:00   2019-09-30 00:00:00   2022-01-18 00:00:00   2022-06-30 00:00:00   1900-01-01 00:00:00   2021-03-31 00:00:00   2021-06-30 00:00:00   2021-09-30 00:00:00   2021-12-31 00:00:00   2022-09-30 00:00:00   2021-12-31 00:00:00
rpt_date   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   22001   None   22001   22006   None   None   22006   None   22006   22006   None   None   22006   22006   None   22006   None   None   22006   22006   22006   None   22006   None   None   None   22006   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   22006   22006   None   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   None   22006   22006   None   None   22006   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   None   22006   22006   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   22006   22006   22006
Table: filer_interests
filer_id   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705
session_id   1999   1997   2001   2003   2011   2005   2009   2007   2013   2019   2017   2021   2015   2023
interest_cd   40306   40306   40306   40306   40306   40306   40306   40306   40306   40306   40306   40306   40306   40306
effect_date   1999-01-01 00:00:00   1997-01-01 00:00:00   2001-01-01 00:00:00   2003-01-01 00:00:00   2011-01-01 00:00:00   2005-01-01 00:00:00   2009-01-01 00:00:00   2007-01-01 00:00:00   2013-01-01 00:00:00   2019-01-01 00:00:00   2017-11-14 00:00:00   2021-01-01 00:00:00   2015-01-01 00:00:00   2023-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705
filer_type   1   1   1   1   1   1   2   2   1   1   2   2   2   2   2
active   Y   Y   Y   Y   Y   Y   S   Y   Y   Y   Y   Y   Y   Y   N
race   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None
session_id   1997   1999   2001   2003   2005   2007   2011   2013   2011   2009   2019   2015   2017   2021   2023
category   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None
category_type   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None
sub_category   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None
effect_dt   1997-01-01 00:00:00   1999-01-01 00:00:00   2001-01-01 00:00:00   2003-01-01 00:00:00   2005-01-01 00:00:00   2007-01-01 00:00:00   2012-01-01 00:00:00   2013-01-01 00:00:00   2011-01-01 00:00:00   2009-01-01 00:00:00   2019-01-01 00:00:00   2015-01-01 00:00:00   2017-11-14 00:00:00   2021-01-01 00:00:00   2023-01-01 00:00:00
sub_category_type   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None
election_type   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None
sub_category_a   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
nyq_dt   None   None   None   None   2000-07-01 00:00:00   2000-07-01 00:00:00   None   None   None   None   None   None   None   None   None
party_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
county_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
district_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: filer_xref
filer_id   1145705
xref_id   C27217
effect_dt   1999-12-08 00:00:00
migration_source   MASTER
Table: filername
xref_filer_id   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217   C27217
filer_id   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705
filer_type   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER
status   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE
effect_dt   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00
naml   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICER'S ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA
namf   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
adr1   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
adr2   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
city   ELK GROVE   ELK GROVE   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   ELK GROVE   ELK GROVE   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   ELK GROVE   ELK GROVE   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   ELK GROVE   ELK GROVE   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   ELK GROVE   ELK GROVE   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   ELK GROVE   ELK GROVE   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   ELK GROVE   ELK GROVE   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   ELK GROVE   ELK GROVE   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   ELK GROVE   ELK GROVE   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   ELK GROVE   ELK GROVE   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   ELK GROVE   ELK GROVE   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   ELK GROVE   ELK GROVE   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   ELK GROVE   ELK GROVE   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO
st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
zip4   95708   95758   958143812   958143812   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95708   95758   958143812   958143812   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95708   95758   958143812   958143812   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95708   95758   958143812   958143812   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95708   95758   958143812   958143812   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95708   95758   958143812   958143812   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95708   95758   958143812   958143812   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95708   95758   958143812   958143812   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95708   95758   958143812   958143812   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95708   95758   958143812   958143812   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95708   95758   958143812   958143812   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95708   95758   958143812   958143812   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95708   95758   958143812   958143812   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814
phon   9164417405   9166843856   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9166843856   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9166843856   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9166843856   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9166843856   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9166843856   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9166843856   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9166843856   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9166843856   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9166843856   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9166843856   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9166843856   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9166843856   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405   9164417405
fax   None   None   9164851532   9164851532   9164851532      9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   None   None   9164851532   9164851532   9164851532      9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   None   None   9164851532   9164851532   9164851532      9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   None   None   9164851532   9164851532   9164851532      9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   None   None   9164851532   9164851532   9164851532      9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   None   None   9164851532   9164851532   9164851532      9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   None   None   9164851532   9164851532   9164851532      9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   None   None   9164851532   9164851532   9164851532      9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   None   None   9164851532   9164851532   9164851532      9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   None   None   9164851532   9164851532   9164851532      9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   None   None   9164851532   9164851532   9164851532      9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   None   None   9164851532   9164851532   9164851532      9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   None   None   9164851532   9164851532   9164851532      9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940   9164472940
email   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]
Table: filers
filer_id   1145705
Table: lobbying_chg_log
filer_id   1145705   1145705   1145705   1145705   1145705
change_no   0   1   2   3   4
session_id   2015   2017   2017   2017   2019
log_dt   2015-10-09 00:00:00   2017-11-14 00:00:00   2017-11-14 00:00:00   2017-11-14 00:00:00   2019-03-04 00:00:00
filer_type   2   2   2   2   2
correction_flg   Y   None   Y   Y   None
action   ADDED   SET ACTIVE   ADDED   ADDED   DELETED
attribute_changed   LOBBYIST      LOBBYIST   LOBBYIST   LOBBYIST
ethics_dt   None   None   None   None   None
interests   None   None   None   None   None
filer_full_name   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA   HEALTH OFFICERS ASSOCIATION OF CALIFORNIA
filer_city   None   None   None   None   None
filer_st   None   None   None   None   None
filer_zip   None   None   None   None   None
filer_phone   None   None   None   None   None
entity_type   4   2   4   4   4
entity_name   ROBERTS, BRANDON L.   None   ROBERTS, BRANDON   DE BURGH, KATHARINE   BRANDON ROBERTS
entity_city   None   None   None   None   None
entity_st   None   None   None   None   None
entity_zip   None   None   None   None   None
entity_phone   None   None   None   None   None
entity_id   1380134   0   1380134   1345096   1380134
responsible_officer   None   None   None   None   None
effect_dt   2015-09-21 00:00:00   2017-11-14 00:00:00   2017-11-14 00:00:00   2017-11-14 00:00:00   2019-02-11 00:00:00
Table: received_filings
filer_id   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705   1145705
filing_file_name   679819_0.cal   719356_0.cal   745810_0.cal   278843.cal   772904_0.cal   91828.cal   792679_0.cal   810935_0.cal   835103_0.cal   78717.cal   856739_0.cal   873876_0.cal   266569.cal   266578.cal   898348_0.cal   392938.cal   392966.cal   393006.cal   905936_0.cal   388830.cal   388936.cal   388940.cal   334536.cal   930773_0.cal   944824_0.cal   968323_0.cal
received_date   2000-10-28 00:00:00   2001-01-31 00:00:00   2001-04-30 00:00:00   2001-07-31 00:00:00   2001-07-31 00:00:00   2001-10-31 00:00:00   2001-10-31 00:00:00   2002-01-27 00:00:00   2002-04-12 00:00:00   2002-04-12 00:00:00   2002-07-31 00:00:00   2002-10-14 00:00:00   2002-12-30 00:00:00   2002-12-30 00:00:00   2002-12-30 00:00:00   2003-01-24 00:00:00   2003-01-24 00:00:00   2003-01-24 00:00:00   2003-01-24 00:00:00   2003-01-24 00:00:00   2003-01-24 00:00:00   2003-01-24 00:00:00   2003-04-29 00:00:00   2003-04-29 00:00:00   2003-07-27 00:00:00   2003-10-28 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/temp   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/temp   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal
filing_id   679819   719356   745810   None   772904   None   792679   810935   835103   None   856739   873876   None   None   898348   None   None   None   905936   None   None   None   None   930773   944824   968323
form_id   F635   F635   F635   None   F635   None   F635   F635   F635   None   F635   F635   None   None   F602   None   None   None   F635   None   None   None   None   F635   F635   F635
receive_comment   Filing accepted, but with warnings   Filing accepted   Filing accepted   Filing passed validation, but failed DB constraints   Filing accepted   Filing passed validation, but failed DB constraints   Filing accepted   Filing accepted   Filing accepted   Filing passed validation, but failed DB constraints   Filing accepted   Filing accepted   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing accepted   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing accepted, but with warnings   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing passed validation, but failed DB constraints   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing accepted, but with warnings