Home

Filer ID: 1143425

Table: filer_address
filer_id   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425
adrid   1131650   1107792   1132470   2045673   2080276   2116929   2162687   2205447   2504922   2415471   2276193   2343865   2551296   2472007
effect_dt   1999-12-31 00:00:00   2000-04-11 00:00:00   1999-12-31 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   2021-01-01 00:00:00   2017-01-01 00:00:00   2013-01-01 00:00:00   2015-01-01 00:00:00   2023-01-01 00:00:00   2019-01-01 00:00:00
add_type   7050   7051   7050   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051
session_id   1999   1999   1999   2003   2005   2007   2009   2011   2021   2017   2013   2015   2023   2019
Table: filer_filings
filer_id   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425
filing_id   467986   464650   484444   475309   471172   482279   465922   480883   491775   485877   493279   476723   488063   471172   479034   469785   495446   496894   489564   488063   476723   473485   614665   630869   663781   677936   693102   719215   705217   756952   746041   739408   768666   791795   777881   813396   794835   839422   818890   850914   844371   854832   893335   884332   905339   914375   906413   945445   930427   935742   967600   967602   964173   974578   956784   999081   1009296   985623   1009296   1031037   1023790   1018132   1023790   1045508   1072986   1073500   1065194   1069236   1092964   1065605   1102054   1113817   1129148   1142839   1161099   1161099   1187163   1214522   1233197   1240819   1264277   1285181   1308106   1781302   1962138   1980275   1839816   1800675   1947134   1906737   1327840   1296427   1327840   1347787   1347787   1377701   1390248   1417976   1409810   1434164   1459961   1434164   1482515   1449839   1503380   1567694   1534995   1559558   1571035   1604381   1588430   1588430   1633762   1617877   1633762   1655231   1674210   1813495   1934796   1713070   1718776   1707194   1714792   1867025   1739610   1739610   1752506   1765223   1996899   2191978   2357120   2554294   2470496   2419506   2007601   2037088   2037088   2062712   2101684   2126295   2139366   2174475   2156805   2401616   2341544   2401619   2529863   2401619   2207330   2401616   2487879   2240225   2401616   2271383   2440059   2315264   2583489   2581269   2707422   2584083   2599440   2642180   2618488   2577482   2677597   2748931
period_id   157   141   145   143   150   152   149   144   147   153   155   151   146   150   159   142   148   156   154   146   151   158   160   None   162   163   163   164   None   165   165   164   166   167   None   168   None   169   None   170   None   170   None   171   172   None   None   174   173   None   None   None   175   None   None   None   177   176   177   None   178   None   178   179   None   180   180   None   None   None   181   182   183   184   185   185   186   187   188   None   189   190   192   214   221   222   217   215   None   219   193   191   193   194   194   195   196   197   None   198   200   198   201   199   202   204   203   205   None   206   205   205   208   207   208   209   210   216   220   None   212   211   None   218   212   212   None   213   223   231   None   244   241   239   224   225   225   226   227   228   None   230   229   237   236   238   243   238   232   237   242   233   237   234   None   235   None   245   250   244   246   248   247   None   249   251
form_id   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F690   F635   F635   F635   F635   F635   F690   F690   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   F602   F635   F635   F635   F605   F605   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F602   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F605   F602   F635   F602   F635   F635   F635   F602   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F602   F635   F635   F602   F635   F635   F635   F602   F635   F635
filing_sequence   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   1   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   1   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   1   0   1   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   1   0   0   1   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   0   0   2   0   1   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
filing_date   1999-04-30 00:00:00   1995-05-01 00:00:00   1996-04-30 00:00:00   1995-10-17 00:00:00   1997-07-24 00:00:00   1998-01-30 00:00:00   1997-04-28 00:00:00   1996-01-31 00:00:00   1996-10-30 00:00:00   1998-04-29 00:00:00   1998-10-29 00:00:00   1997-10-29 00:00:00   1996-07-18 00:00:00   1998-07-27 00:00:00   1999-10-29 00:00:00   1995-07-31 00:00:00   1997-01-29 00:00:00   1999-01-29 00:00:00   1998-07-27 00:00:00   1997-01-29 00:00:00   1998-07-27 00:00:00   1999-08-02 00:00:00   2000-01-24 00:00:00   2000-05-01 00:00:00   2000-07-31 00:00:00   2000-10-26 00:00:00   2000-10-30 00:00:00   2001-01-31 00:00:00   2000-12-28 00:00:00   2001-04-30 00:00:00   2001-04-30 00:00:00   2001-01-29 00:00:00   2001-07-23 00:00:00   2001-10-31 00:00:00   2001-07-30 00:00:00   2002-01-31 00:00:00   2001-10-30 00:00:00   2002-04-30 00:00:00   2002-01-30 00:00:00   2002-07-23 00:00:00   2002-04-30 00:00:00   2002-07-26 00:00:00   2002-10-30 00:00:00   2002-10-31 00:00:00   2003-01-23 00:00:00   2003-01-31 00:00:00   2003-01-02 00:00:00   2003-07-29 00:00:00   2003-04-29 00:00:00   2003-04-30 00:00:00   2000-01-24 00:00:00   2000-05-01 00:00:00   2003-10-16 00:00:00   2003-10-24 00:00:00   2003-07-30 00:00:00   2004-01-30 00:00:00   2004-04-16 00:00:00   2004-01-23 00:00:00   2004-04-28 00:00:00   2004-07-29 00:00:00   2004-07-19 00:00:00   2004-04-30 00:00:00   2004-09-15 00:00:00   2004-10-06 00:00:00   2004-12-21 00:00:00   2005-01-20 00:00:00   2004-12-08 00:00:00   2004-09-27 00:00:00   2005-01-31 00:00:00   2004-10-29 00:00:00   2005-04-22 00:00:00   2005-07-25 00:00:00   2005-10-20 00:00:00   2006-01-20 00:00:00   2006-05-23 00:00:00   2006-04-07 00:00:00   2006-07-25 00:00:00   2006-10-30 00:00:00   2007-01-28 00:00:00   2007-01-23 00:00:00   2007-05-07 00:00:00   2007-07-31 00:00:00   2008-01-29 00:00:00   2013-07-30 00:00:00   2015-04-26 00:00:00   2015-07-30 00:00:00   2014-04-21 00:00:00   2013-10-31 00:00:00   2014-12-30 00:00:00   2014-10-28 00:00:00   2008-04-28 00:00:00   2007-10-30 00:00:00   2008-06-09 00:00:00   2008-07-29 00:00:00   2008-07-29 00:00:00   2008-10-31 00:00:00   2009-01-20 00:00:00   2009-04-21 00:00:00   2009-01-30 00:00:00   2009-08-31 00:00:00   2010-01-25 00:00:00   2009-07-28 00:00:00   2010-04-26 00:00:00   2009-10-26 00:00:00   2010-07-26 00:00:00   2011-01-27 00:00:00   2010-10-26 00:00:00   2011-01-13 00:00:00   2011-01-13 00:00:00   2011-07-27 00:00:00   2011-04-26 00:00:00   2011-05-24 00:00:00   2012-01-30 00:00:00   2011-10-18 00:00:00   2012-02-29 00:00:00   2012-04-26 00:00:00   2012-07-25 00:00:00   2014-01-27 00:00:00   2015-01-30 00:00:00   2012-10-30 00:00:00   2012-12-19 00:00:00   2012-10-30 00:00:00   2012-11-20 00:00:00   2014-07-26 00:00:00   2013-01-31 00:00:00   2013-01-31 00:00:00   2012-12-28 00:00:00   2013-04-30 00:00:00   2015-10-30 00:00:00   2017-10-30 00:00:00   2019-01-11 00:00:00   2021-02-01 00:00:00   2020-04-30 00:00:00   2019-10-31 00:00:00   2016-01-27 00:00:00   2016-05-01 00:00:00   2016-05-01 00:00:00   2016-07-30 00:00:00   2016-10-31 00:00:00   2017-01-29 00:00:00   2017-01-03 00:00:00   2017-07-29 00:00:00   2017-04-30 00:00:00   2019-08-29 00:00:00   2019-01-28 00:00:00   2019-08-29 00:00:00   2020-11-01 00:00:00   2019-08-02 00:00:00   2018-01-29 00:00:00   2019-08-02 00:00:00   2020-07-31 00:00:00   2018-04-28 00:00:00   2019-08-02 00:00:00   2018-07-28 00:00:00   2020-01-29 00:00:00   2018-10-29 00:00:00   2021-01-06 00:00:00   2021-04-30 00:00:00   2022-08-01 00:00:00   2021-05-14 00:00:00   2021-07-29 00:00:00   2022-01-29 00:00:00   2021-10-23 00:00:00   2021-01-06 00:00:00   2022-05-02 00:00:00   2022-10-31 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   10005   10005   10005   10001   10005   10001   10005   10005   10001   10005   10001   10001   10005   10001   10005   10001   10005   10001   10005   10005   10005   10001   10001   10005   10005   10001   10001   10005   10005   10005   10001   10005   10005   10005   10001   10001   10002   10005   10001   10005   10002   10001   10005   10001   10001   10006   10005   10005   10001   10001   10001   10001   10002   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10002   10001   10002   10001   10001   10001   10005   10002   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10002   10001   10001   10002   10001   10001   10001   10001   10006   10001   10001   10005   10001   10002   10001   10005   10001   10001   10001   10005   10001   10001   10001   10001   10002   10001   10001   10001   10001   10005   10001   10001   10002   10001   10002   10001   10001   10001   10002   10001   10001   10001   10001   10005   10001   10005   10001   10001   10001   10001   10001   10001   10005   10001   10001
stmnt_status   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11003   11001   11001   11003   11001   11003   11003   11001   11003   11001   11003   11001   11003   11001   11001   11001   11003   11003   11001   11001   11003   11003   11001   11001   11001   11003   11001   11001   11001   11003   11003   11003   11001   11003   11001   11003   11003   11001   11003   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11001   11001   11001   11003   11003
session_id   1999   1995   1995   1995   1997   1997   1997   1995   1995   1997   1997   1997   1995   1997   1999   1995   1995   1997   1997   1995   1997   1999   1999   1999   1999   1999   1999   1999   2001   2001   2001   1999   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2005   2003   2005   2005   2003   2003   2005   2005   2005   2005   2005   2005   2005   2005   2005   2007   2007   2007   2007   2013   2015   2015   2013   2013   2015   2013   2007   2007   2007   2007   2007   2007   2007   2009   2009   2009   2009   2009   2009   2009   2009   2009   2009   2011   2011   2011   2011   2011   2011   2011   2011   2011   2011   2013   2013   2011   2013   2011   2011   2013   2011   2011   2013   2013   2015   2017   2019   2019   2019   2019   2015   2015   2015   2015   2015   2015   2017   2017   2017   2019   2017   2019   2019   2019   2017   2019   2019   2017   2019   2017   2019   2017   2021   2021   2021   2021   2021   2021   2021   2019   2021   2021
user_id   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   TTHAM   YBONILLA   *   YBONILLA   *   GKURIMOT   LTHIBAUL   *   LTHIBAUL   *   *   JBRANNAN   *   TWALLS   *   LTHIBAUL   *   LTHIBAUL   LTHIBAUL   LTHIBAUL   *   COMPLETED   LTHIBAUL   GPEREZ   COMPLETED   COMPLETED   LTHIBAUL   CFLAGG   CFLAGG   COMPLETED   LTHIBAUL   LTHIBAUL   LTHIBAUL   COMPLETED   COMPLETED   COMPLETED   LTHIBAUL   COMPLETED   LTHIBAUL   COMPLETED   COMPLETED   CFLAGG   COMPLETED   COMPLETED   EMCENTEE   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   CFLAGG   LTHIBAUL   LTHIBAUL   LTHIBAUL   AGLADNEY   MPACHECO   MPACHECO   AGLADNEY   AGLADNEY   YRODRIGU   AGLADNEY   LTHIBAUL   LTHIBAUL   LTHIBAUL   YRODRIGU   YRODRIGU   JGRISSUM   JGRISSUM   JGRISSUM   SARRIAGA   MGUERRA   JINGRAM   JGRISSUM   ASAETERN   MGUERRA   ASAETERN   AGLADNEY   ASAETERN   PBANFORD   PBANFORD   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   YRODRIGU   AGLADNEY   YRODRIGU   AGLADNEY   ASAETERN   ASAETERN   YRODRIGU   AGLADNEY   MPACHECO   AGLADNEY   PBANFORD   GTAYLOR   VUKSTINA   VUKSTINA   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   AGLADNEY   AGLADNEY   GTAYLOR   AGLADNEY   SUSHAKOV   GTAYLOR   KBANH   AGLADNEY   KBANH   GTAYLOR   AGLADNEY   KBANH   AGLADNEY   GPEREZ   AGLADNEY   MKIRKHAM   GTAYLOR   CAFILER   CAFILER   CHATRIDGE   CHATRIDGE   CHATRIDGE   MKIRKHAM   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   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11002   11003   11002   11002   11002   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003
fine_audit   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11003   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11001   11003   11003   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11003   11001   11003   11003   11001   11001   11001   11003   11003   11003
rpt_start   1999-01-01 00:00:00   1995-01-01 00:00:00   1996-01-01 00:00:00   1995-07-01 00:00:00   1997-04-01 00:00:00   1997-10-01 00:00:00   1997-01-01 00:00:00   1995-10-01 00:00:00   1996-07-01 00:00:00   1998-01-01 00:00:00   1998-07-01 00:00:00   1997-07-01 00:00:00   1996-04-01 00:00:00   1997-04-01 00:00:00   1999-07-01 00:00:00   1995-04-01 00:00:00   1996-10-01 00:00:00   1998-10-01 00:00:00   1998-04-01 00:00:00   1996-04-01 00:00:00   1997-07-01 00:00:00   1999-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-07-01 00:00:00   2000-10-01 00:00:00   1900-01-01 00:00:00   2001-01-01 00:00:00   2001-01-01 00:00:00   2000-10-01 00:00:00   2001-04-01 00:00:00   2001-07-01 00:00:00   2001-04-01 00:00:00   2001-10-01 00:00:00   2001-07-01 00:00:00   2002-01-01 00:00:00   2001-10-01 00:00:00   2002-04-01 00:00:00   2002-01-01 00:00:00   2002-04-01 00:00:00   2002-07-01 00:00:00   2002-07-01 00:00:00   2002-10-01 00:00:00   2002-10-01 00:00:00   1900-01-01 00:00:00   2003-04-01 00:00:00   2003-01-01 00:00:00   2003-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2003-07-01 00:00:00   2003-07-01 00:00:00   2003-04-01 00:00:00   2003-10-01 00:00:00   2004-01-01 00:00:00   2003-10-01 00:00:00   2004-01-01 00:00:00   2004-04-01 00:00:00   2004-04-01 00:00:00   2004-01-01 00:00:00   2004-04-01 00:00:00   2004-07-01 00:00:00   1900-01-01 00:00:00   2004-10-01 00:00:00   2004-12-08 00:00:00   2004-04-01 00:00:00   2004-10-01 00:00:00   2004-07-01 00:00:00   2005-01-01 00:00:00   2005-04-01 00:00:00   2005-07-01 00:00:00   2005-10-01 00:00:00   2006-01-01 00:00:00   2006-01-01 00:00:00   2006-04-01 00:00:00   2006-07-01 00:00:00   2006-10-01 00:00:00   1900-01-01 00:00:00   2007-01-01 00:00:00   2007-04-01 00:00:00   2007-10-01 00:00:00   2013-04-01 00:00:00   2015-01-01 00:00:00   2015-04-01 00:00:00   2014-01-01 00:00:00   2013-07-01 00:00:00   1900-01-01 00:00:00   2014-07-01 00:00:00   2008-01-01 00:00:00   2007-07-01 00:00:00   2008-01-01 00:00:00   2008-04-01 00:00:00   2008-04-01 00:00:00   2008-07-01 00:00:00   2008-10-01 00:00:00   2009-01-01 00:00:00   1900-01-01 00:00:00   2009-04-01 00:00:00   2009-10-01 00:00:00   2009-04-01 00:00:00   2010-01-01 00:00:00   2009-07-01 00:00:00   2010-04-01 00:00:00   2010-10-01 00:00:00   2010-07-01 00:00:00   2011-01-13 00:00:00   1900-01-01 00:00:00   2011-04-01 00:00:00   2011-01-01 00:00:00   2011-01-01 00:00:00   2011-10-01 00:00:00   2011-07-01 00:00:00   2011-10-01 00:00:00   2012-01-01 00:00:00   2012-04-01 00:00:00   2013-10-01 00:00:00   2014-10-01 00:00:00   1900-01-01 00:00:00   2012-12-19 00:00:00   2012-07-01 00:00:00   1900-01-01 00:00:00   2014-04-01 00:00:00   2012-10-01 00:00:00   2012-10-01 00:00:00   1900-01-01 00:00:00   2013-01-01 00:00:00   2015-07-01 00:00:00   2017-07-01 00:00:00   1900-01-01 00:00:00   2020-10-01 00:00:00   2020-01-01 00:00:00   2019-07-01 00:00:00   2015-10-01 00:00:00   2016-01-01 00:00:00   2016-01-01 00:00:00   2016-04-01 00:00:00   2016-07-01 00:00:00   2016-10-01 00:00:00   1900-01-01 00:00:00   2017-04-01 00:00:00   2017-01-01 00:00:00   2019-01-01 00:00:00   2018-10-01 00:00:00   2019-04-01 00:00:00   2020-07-01 00:00:00   2019-04-01 00:00:00   2017-10-01 00:00:00   2019-01-01 00:00:00   2020-04-01 00:00:00   2018-01-01 00:00:00   2019-01-01 00:00:00   2018-04-01 00:00:00   1900-01-01 00:00:00   2018-07-01 00:00:00   1900-01-01 00:00:00   2021-01-01 00:00:00   2022-04-01 00:00:00   2020-12-31 00:00:00   2021-04-01 00:00:00   2021-10-01 00:00:00   2021-07-01 00:00:00   1900-01-01 00:00:00   2022-01-01 00:00:00   2022-07-01 00:00:00
rpt_end   1999-03-31 00:00:00   1995-03-31 00:00:00   1996-03-31 00:00:00   1995-09-30 00:00:00   1997-06-30 00:00:00   1997-12-31 00:00:00   1997-03-31 00:00:00   1995-12-31 00:00:00   1996-09-30 00:00:00   1998-03-31 00:00:00   1998-09-30 00:00:00   1997-09-30 00:00:00   1996-06-30 00:00:00   1997-06-30 00:00:00   1999-09-30 00:00:00   1995-06-30 00:00:00   1996-12-31 00:00:00   1998-12-31 00:00:00   1998-06-30 00:00:00   1996-06-30 00:00:00   1997-09-30 00:00:00   1999-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-09-30 00:00:00   2000-12-31 00:00:00   1900-01-01 00:00:00   2001-03-31 00:00:00   2001-03-31 00:00:00   2000-12-31 00:00:00   2001-06-30 00:00:00   2001-09-30 00:00:00   2001-06-30 00:00:00   2001-12-31 00:00:00   2001-09-30 00:00:00   2002-03-31 00:00:00   2001-12-31 00:00:00   2002-06-30 00:00:00   2002-03-31 00:00:00   2002-06-30 00:00:00   2002-09-30 00:00:00   2002-09-30 00:00:00   2002-12-31 00:00:00   2002-12-31 00:00:00   1900-01-01 00:00:00   2003-06-30 00:00:00   2003-03-31 00:00:00   2003-03-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2003-09-30 00:00:00   2003-09-30 00:00:00   2003-06-30 00:00:00   2003-12-31 00:00:00   2004-03-31 00:00:00   2003-12-31 00:00:00   2004-03-31 00:00:00   2004-06-30 00:00:00   2004-06-30 00:00:00   2004-03-31 00:00:00   2004-06-30 00:00:00   2004-09-30 00:00:00   1900-01-01 00:00:00   2004-12-31 00:00:00   2004-12-08 00:00:00   2004-06-30 00:00:00   2004-12-31 00:00:00   2004-09-30 00:00:00   2005-03-31 00:00:00   2005-06-30 00:00:00   2005-09-30 00:00:00   2005-12-31 00:00:00   2006-03-31 00:00:00   2006-03-31 00:00:00   2006-06-30 00:00:00   2006-09-30 00:00:00   2006-12-31 00:00:00   1900-01-01 00:00:00   2007-03-31 00:00:00   2007-06-30 00:00:00   2007-12-31 00:00:00   2013-06-30 00:00:00   2015-03-31 00:00:00   2015-06-30 00:00:00   2014-03-31 00:00:00   2013-09-30 00:00:00   1900-01-01 00:00:00   2014-09-30 00:00:00   2008-03-31 00:00:00   2007-09-30 00:00:00   2008-03-31 00:00:00   2008-06-30 00:00:00   2008-06-30 00:00:00   2008-09-30 00:00:00   2008-12-31 00:00:00   2009-03-31 00:00:00   1900-01-01 00:00:00   2009-06-30 00:00:00   2009-12-31 00:00:00   2009-06-30 00:00:00   2010-03-31 00:00:00   2009-09-30 00:00:00   2010-06-30 00:00:00   2010-12-31 00:00:00   2010-09-30 00:00:00   2011-01-13 00:00:00   1900-01-01 00:00:00   2011-06-30 00:00:00   2011-03-31 00:00:00   2011-03-31 00:00:00   2011-12-31 00:00:00   2011-09-30 00:00:00   2011-12-31 00:00:00   2012-03-31 00:00:00   2012-06-30 00:00:00   2013-12-31 00:00:00   2014-12-31 00:00:00   1900-01-01 00:00:00   2012-12-19 00:00:00   2012-09-30 00:00:00   1900-01-01 00:00:00   2014-06-30 00:00:00   2012-12-31 00:00:00   2012-12-31 00:00:00   1900-01-01 00:00:00   2013-03-31 00:00:00   2015-09-30 00:00:00   2017-09-30 00:00:00   1900-01-01 00:00:00   2020-12-31 00:00:00   2020-03-31 00:00:00   2019-09-30 00:00:00   2015-12-31 00:00:00   2016-03-31 00:00:00   2016-03-31 00:00:00   2016-06-30 00:00:00   2016-09-30 00:00:00   2016-12-31 00:00:00   1900-01-01 00:00:00   2017-06-30 00:00:00   2017-03-31 00:00:00   2019-03-31 00:00:00   2018-12-31 00:00:00   2019-06-30 00:00:00   2020-09-30 00:00:00   2019-06-30 00:00:00   2017-12-31 00:00:00   2019-03-31 00:00:00   2020-06-30 00:00:00   2018-03-31 00:00:00   2019-06-30 00:00:00   2018-06-30 00:00:00   1900-01-01 00:00:00   2018-09-30 00:00:00   1900-01-01 00:00:00   2021-03-31 00:00:00   2022-06-30 00:00:00   2020-12-31 00:00:00   2021-06-30 00:00:00   2021-12-31 00:00:00   2021-09-30 00:00:00   1900-01-01 00:00:00   2022-03-31 00:00:00   2022-09-30 00:00:00
rpt_date   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   22001   None   None   22001   22001   None   None   None   22001   None   None   None   22001   22001   22001   None   22001   None   22001   22001   None   22001   22001   None   None   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22006   22006   22006   22006   22001   22001   22006   22006   None   22001   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   22006   22001   None   22006   22006   None   22001   22006   22006   None   22006   22001   22001   None   22001   22001   22006   22001   22001   22001   22001   22001   22001   None   22001   22001   22006   22001   22006   22001   22006   22001   22006   22001   22001   22006   22001   None   22001   None   22001   22001   22001   22001   22001   22001   None   22001   22001
Table: filer_interests
filer_id   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425
session_id   2001   1995   1997   1999   2005   2003   2007   2011   2013   2009   2015   2019   2017   2021   2023
interest_cd   40306   40306   40306   40306   40306   40306   40306   40306   40306   40306   40306   40306   40306   40306   40306
effect_date   2001-01-01 00:00:00   1995-01-01 00:00:00   1997-01-01 00:00:00   1999-01-01 00:00:00   2005-01-01 00:00:00   2003-01-01 00:00:00   2007-01-01 00:00:00   2011-01-01 00:00:00   2013-01-01 00:00:00   2009-01-01 00:00:00   2015-01-01 00:00:00   2019-01-01 00:00:00   2017-01-01 00:00:00   2021-01-01 00:00:00   2023-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425
filer_type   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1
active   Y   Y   Y   Y   Y   Y   Y   Y   Y   T   Y   Y   Y   Y   T   Y   Y   Y   N
race   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
session_id   1995   1999   1997   2001   2003   2005   2007   2011   2013   2011   2011   2009   2021   2019   2019   2015   2019   2017   2023
category   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
category_type   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
sub_category   0   0   0   0   None   None   None   None   None   None   None   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   2012-10-01 00:00:00   2012-12-01 00:00:00   2009-01-01 00:00:00   2021-01-01 00:00:00   2019-01-01 00:00:00   2019-09-30 00:00:00   2015-01-01 00:00:00   2020-01-01 00:00:00   2017-01-01 00:00:00   2023-01-01 00:00:00
sub_category_type   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
election_type   0   0   0   0   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
sub_category_a   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None
party_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
county_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
district_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: filer_xref
filer_id   1143425
xref_id   C21877
effect_dt   1999-12-08 00:00:00
migration_source   MASTER
Table: filername
xref_filer_id   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877   C21877
filer_id   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425
filer_type   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT
status   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE
effect_dt   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00
naml   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS
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   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO   SAN FRANCISCO
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   94109   941052632   94104   94109   94109   94104   94109   94109   94109   94109   94109   94109   94109   94109   94109   941052632   94104   94109   94109   94104   94109   94109   94109   94109   94109   94109   94109   94109   94109   941052632   94104   94109   94109   94104   94109   94109   94109   94109   94109   94109   94109   94109   94109   941052632   94104   94109   94109   94104   94109   94109   94109   94109   94109   94109   94109   94109   94109   941052632   94104   94109   94109   94104   94109   94109   94109   94109   94109   94109   94109   94109   94109   941052632   94104   94109   94109   94104   94109   94109   94109   94109   94109   94109   94109   94109   94109   941052632   94104   94109   94109   94104   94109   94109   94109   94109   94109   94109   94109   94109   94109   941052632   94104   94109   94109   94104   94109   94109   94109   94109   94109   94109   94109   94109   94109   941052632   94104   94109   94109   94104   94109   94109   94109   94109   94109   94109   94109   94109   94109   941052632   94104   94109   94109   94104   94109   94109   94109   94109   94109   94109   94109   94109   94109   941052632   94104   94109   94109   94104   94109   94109   94109   94109   94109   94109   94109   94109   94109   941052632   94104   94109   94109   94104   94109   94109   94109   94109   94109   94109   94109   94109   94109   941052632   94104   94109   94109   94104   94109   94109   94109   94109   94109   94109   94109   94109
phon   4153458667   4158823381   4153949121   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4158823381   4153949121   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4158823381   4153949121   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4158823381   4153949121   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4158823381   4153949121   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4158823381   4153949121   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4158823381   4153949121   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4158823381   4153949121   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4158823381   4153949121   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4158823381   4153949121   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4158823381   4153949121   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4158823381   4153949121   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4158823381   4153949121   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667   4153458667
fax   None   None   None   None   None   4153458668   4153458668   4153458668   4153458668                  None   None   None   None   None   4153458668   4153458668   4153458668   4153458668                  None   None   None   None   None   4153458668   4153458668   4153458668   4153458668                  None   None   None   None   None   4153458668   4153458668   4153458668   4153458668                  None   None   None   None   None   4153458668   4153458668   4153458668   4153458668                  None   None   None   None   None   4153458668   4153458668   4153458668   4153458668                  None   None   None   None   None   4153458668   4153458668   4153458668   4153458668                  None   None   None   None   None   4153458668   4153458668   4153458668   4153458668                  None   None   None   None   None   4153458668   4153458668   4153458668   4153458668                  None   None   None   None   None   4153458668   4153458668   4153458668   4153458668                  None   None   None   None   None   4153458668   4153458668   4153458668   4153458668                  None   None   None   None   None   4153458668   4153458668   4153458668   4153458668                  None   None   None   None   None   4153458668   4153458668   4153458668   4153458668               
email   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None
Table: filers
filer_id   1143425
Table: lobbying_chg_log
filer_id   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425
change_no   3   1   2   4   5   0   7   6
session_id   2001   2001   2001   2001   2011   2011   2019   2017
log_dt   2001-04-05 00:00:00   2001-04-05 00:00:00   2001-04-05 00:00:00   2001-05-17 00:00:00   2012-10-30 00:00:00   2012-11-20 00:00:00   2020-01-29 00:00:00   2018-08-14 00:00:00
filer_type   1   1   1   1   1   1   1   1
correction_flg   None   None   None   None   None   None   None   Y
action   IN SUSPENSE   CHANGED   CHANGED   CHANGED   DELETED   ADDED   SET ACTIVE   DELETED
attribute_changed   CLIENT   ADDRESS   None   None   FIRM   FIRM      FIRM
ethics_dt   None   None   None   None   None   None   None   None
interests   None   None   None   None   None   None   None   None
filer_full_name   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS   CALIFORNIA ACADEMY OF FAMILY PHYSICIANS
filer_city   ALBANY   None   None   None   None   None   None   None
filer_st   CA   None   None   None   None   None   None   None
filer_zip   94706   None   None   None   None   None   None   None
filer_phone   5105598383   None   None   None   None   None   None   None
entity_type   3   3   3   3   3   3   1   3
entity_name   RILEY AND ASSOCIATES, TOM   RILEY AND ASSOCIATES, TOM   RILEY AND ASSOCIATES, TOM   RILEY AND ASSOCIATES, TOM   CAL CAPITOL GROUP   DI MARE VAN VLECK & BROWN LLC   None   DI MARE, BROWN, HICKS & KESSLER, LLC
entity_city   None   SACRAMENTO   SACRAMENTO   SACRAMENTO   None   None   None   None
entity_st   None   CA   CA   CA   None   None   None   None
entity_zip   None   95814   95814   95814   None   None   None   None
entity_phone   None   None   9164422840   9164422840   None   None   None   None
entity_id   1147388   1147388   1147388   1147388   1294222   1276403   0   1276403
responsible_officer   None   None   None   None   None   None   None   None
effect_dt   None   None   None   None   2012-10-01 00:00:00   2012-12-01 00:00:00   2020-01-01 00:00:00   2018-07-31 00:00:00
Table: received_filings
filer_id   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425   1143425
filing_file_name   677936_0.cal   18910.cal   19532.cal   24762.cal   2266.cal   2682.cal   3388.cal   4287.cal   719215_0.cal   746041_0.cal   13038.cal   13285.cal   13455.cal   13610.cal   14294.cal   14458.cal   768666_0.cal   791795_0.cal   813396_0.cal   839422_0.cal   850914_0.cal   884332_0.cal   905339_0.cal   930427_0.cal   945445_0.cal   964173_0.cal   1065194_0.cal   1867025_0.cal   2174475_0.cal   2126295_0.cal   2007601_0.cal   1996899_0.cal   2101684_0.cal   1906737_0.cal   2062712_0.cal   2037088_0.cal   2037088_1.cal   1934796_0.cal   1962138_0.cal   1980275_0.cal   2156805_0.cal   2191978_0.cal   2341544_0.cal   2207330_0.cal   2240225_0.cal   2271383_0.cal   2315264_0.cal   2599440_0.cal   2707422_0.cal   2748931_0.cal   2618488_0.cal   2642180_0.cal   2581269_0.cal   2677597_0.cal
received_date   2000-10-26 00:00:00   2001-01-31 00:00:00   2001-01-31 00:00:00   2001-01-31 00:00:00   2001-01-31 00:00:00   2001-01-31 00:00:00   2001-01-31 00:00:00   2001-01-31 00:00:00   2001-01-31 00:00:00   2001-04-30 00:00:00   2001-01-31 00:00:00   2001-01-31 00:00:00   2001-01-31 00:00:00   2001-01-31 00:00:00   2001-01-31 00:00:00   2001-01-31 00:00:00   2001-07-23 00:00:00   2001-10-31 00:00:00   2002-01-31 00:00:00   2002-04-30 00:00:00   2002-07-23 00:00:00   2002-10-31 00:00:00   2003-01-23 00:00:00   2003-04-29 00:00:00   2003-07-29 00:00:00   2003-10-16 00:00:00   2004-12-08 00:00:00   2014-07-26 00:00:00   2017-07-29 00:00:00   2017-01-29 00:00:00   2016-01-27 00:00:00   2015-10-30 00:00:00   2016-10-31 00:00:00   2014-10-28 00:00:00   2016-07-30 00:00:00   2016-05-01 00:00:00   2016-05-01 00:00:00   2015-01-30 00:00:00   2015-04-26 00:00:00   2015-07-30 00:00:00   2017-04-30 00:00:00   2017-10-30 00:00:00   2019-01-28 00:00:00   2018-01-29 00:00:00   2018-04-28 00:00:00   2018-07-28 00:00:00   2018-10-29 00:00:00   2021-07-29 00:00:00   2022-08-01 00:00:00   2022-10-31 00:00:00   2021-10-23 00:00:00   2022-01-29 00:00:00   2021-04-30 00:00:00   2022-05-02 00:00:00
filing_directory   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/temp   /usr/users/cafiler/disclose/ca99/temp   /usr/users/cafiler/disclose/ca99/temp   /usr/users/cafiler/disclose/ca99/temp   /usr/users/cafiler/disclose/ca99/temp   /usr/users/cafiler/disclose/ca99/temp   /usr/users/cafiler/disclose/ca99/temp   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/temp   /usr/users/cafiler/disclose/ca99/temp   /usr/users/cafiler/disclose/ca99/temp   /usr/users/cafiler/disclose/ca99/temp   /usr/users/cafiler/disclose/ca99/temp   /usr/users/cafiler/disclose/ca99/temp   /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/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal
filing_id   677936   None   None   None   None   None   None   None   719215   746041   None   None   None   None   None   None   768666   791795   813396   839422   850914   884332   905339   930427   945445   964173   1065194   1867025   2174475   2126295   2007601   1996899   2101684   1906737   2062712   2037088   2037088   1934796   1962138   1980275   2156805   2191978   2341544   2207330   2240225   2271383   2315264   2599440   2707422   2748931   2618488   2642180   2581269   2677597
form_id   F635   None   None   None   None   None   None   None   F635   F635   None   None   None   None   None   None   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   F635   F635   F635   F635   F635   F635   F635   F635   F635
receive_comment   Filing accepted, but but with warnings   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing accepted, 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, 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 accepted   Filing accepted   Filing accepted