filer_id | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1112439 | 2097685 | 2116069 | 2164404 | 2207678 | 2526524 | 2276362 | 2551046 | ||||||||
effect_dt | 1999-01-01 00:00:00 | 2006-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2021-11-01 00:00:00 | 2013-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||
session_id | 1999 | 2005 | 2007 | 2009 | 2011 | 2021 | 2013 | 2023 |
filer_id | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 467548 | 478487 | 472920 | 624880 | 614760 | 675169 | 652340 | 708784 | 715347 | 695148 | 744194 | 754289 | 735956 | 788301 | 769842 | 779092 | 797187 | 808737 | 841436 | 820583 | 836427 | 851158 | 866208 | 893132 | 884297 | 1141039 | 1150436 | 1165341 | 1186839 | 1208475 | 1229186 | 1218850 | 1241608 | 1256314 | 1276159 | 1303021 | 1292206 | 1782944 | 1800909 | 1326760 | 1343547 | 1368025 | 1381771 | 1389916 | 1418634 | 1413472 | 1450253 | 1434262 | 1460228 | 1501784 | 1481856 | 1531091 | 1543741 | 1565872 | 1558209 | 1602852 | 1588977 | 1621551 | 1636798 | 1658053 | 1677862 | 1800909 | 1814252 | 1718375 | 1708063 | 1737181 | 1765918 | 1752617 | 2666755 | 2698961 | 2629393 | 2634753 | 2734231 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 157 | 159 | 158 | 161 | 160 | 163 | 162 | None | 164 | 163 | 165 | 165 | 164 | 167 | 166 | None | None | 168 | None | None | 169 | 170 | None | None | 171 | 185 | None | 185 | 186 | 187 | 188 | 188 | None | 189 | 190 | 192 | 191 | 214 | 215 | 193 | 194 | 195 | 196 | 196 | 197 | None | 199 | 198 | 200 | 202 | 201 | 203 | 204 | 204 | None | 206 | 205 | 207 | 208 | 209 | 210 | 215 | 216 | 212 | 211 | 212 | 213 | None | 249 | 250 | None | 248 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | 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 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-04-28 00:00:00 | 1999-10-20 00:00:00 | 1999-07-29 00:00:00 | 2000-04-20 00:00:00 | 2000-01-25 00:00:00 | 2000-10-24 00:00:00 | 2000-07-25 00:00:00 | 2000-12-22 00:00:00 | 2001-01-26 00:00:00 | 2000-10-26 00:00:00 | 2001-04-26 00:00:00 | 2001-04-30 00:00:00 | 2001-01-31 00:00:00 | 2001-10-22 00:00:00 | 2001-07-25 00:00:00 | 2001-07-31 00:00:00 | 2001-10-31 00:00:00 | 2002-01-22 00:00:00 | 2002-04-26 00:00:00 | 2002-01-31 00:00:00 | 2002-04-22 00:00:00 | 2002-07-23 00:00:00 | 2002-07-30 00:00:00 | 2002-10-31 00:00:00 | 2002-10-30 00:00:00 | 2006-01-09 00:00:00 | 2006-01-24 00:00:00 | 2006-04-26 00:00:00 | 2006-07-24 00:00:00 | 2006-10-17 00:00:00 | 2007-01-19 00:00:00 | 2006-11-02 00:00:00 | 2007-11-07 00:00:00 | 2007-04-11 00:00:00 | 2007-07-05 00:00:00 | 2008-01-10 00:00:00 | 2007-10-05 00:00:00 | 2013-07-31 00:00:00 | 2014-01-17 00:00:00 | 2008-04-24 00:00:00 | 2008-07-16 00:00:00 | 2008-10-21 00:00:00 | 2008-11-18 00:00:00 | 2009-01-16 00:00:00 | 2009-04-24 00:00:00 | 2008-12-23 00:00:00 | 2009-10-27 00:00:00 | 2009-07-28 00:00:00 | 2010-01-25 00:00:00 | 2010-07-21 00:00:00 | 2010-04-23 00:00:00 | 2010-10-21 00:00:00 | 2010-11-09 00:00:00 | 2011-01-25 00:00:00 | 2010-12-29 00:00:00 | 2011-07-25 00:00:00 | 2011-04-27 00:00:00 | 2011-10-29 00:00:00 | 2012-01-31 00:00:00 | 2012-04-30 00:00:00 | 2012-07-30 00:00:00 | 2013-10-31 00:00:00 | 2014-01-28 00:00:00 | 2012-12-19 00:00:00 | 2012-10-30 00:00:00 | 2013-01-30 00:00:00 | 2013-04-30 00:00:00 | 2012-12-28 00:00:00 | 2022-04-15 00:00:00 | 2022-07-18 00:00:00 | 2021-11-10 00:00:00 | 2022-01-16 00:00:00 | 2022-10-14 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2013 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2011 | 2011 | 2013 | 2013 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | TTHAM | * | * | YBONILLA | GGILMORE | * | YBONILLA | * | JBRANNAN | YBONILLA | * | * | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | * | * | LTHIBAUL | LTHIBAUL | * | * | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | SARRIAGA | LTHIBAUL | YRODRIGU | LTHIBAUL | YRODRIGU | AGLADNEY | CAFILER | RGEREMIA | LTHIBAUL | MGUERRA | * | MGUERRA | JINGRAM | PBANFORD | JINGRAM | JINGRAM | MGUERRA | ASAETERN | ASAETERN | ASAETERN | * | ASAETERN | SARRIAGA | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | CAFILER | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | CAFILER | CAFILER | MKIRKHAM | GTAYLOR | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11002 | 11003 | 11003 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 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 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-01-01 00:00:00 | 1999-07-01 00:00:00 | 1999-04-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-07-01 00:00:00 | 2000-04-01 00:00:00 | 1900-01-01 00:00:00 | 2000-10-01 00:00:00 | 2000-07-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 2006-01-09 00:00:00 | 1900-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 | 2006-11-02 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 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2013-07-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-11-18 00:00:00 | 2008-10-01 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-04-01 00:00:00 | 2009-10-01 00:00:00 | 2010-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-07-01 00:00:00 | 2010-11-09 00:00:00 | 2010-10-01 00:00:00 | 1900-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-07-01 00:00:00 | 2013-10-01 00:00:00 | 2012-12-19 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 2013-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-03-31 00:00:00 | 1999-09-30 00:00:00 | 1999-06-30 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-09-30 00:00:00 | 2000-06-30 00:00:00 | 1900-01-01 00:00:00 | 2000-12-31 00:00:00 | 2000-09-30 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 2006-01-09 00:00:00 | 1900-01-01 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 | 2006-11-02 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 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2013-09-30 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-11-18 00:00:00 | 2008-12-31 00:00:00 | 2009-03-31 00:00:00 | 1900-01-01 00:00:00 | 2009-09-30 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-03-31 00:00:00 | 2010-09-30 00:00:00 | 2010-11-09 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-09-30 00:00:00 | 2013-12-31 00:00:00 | 2012-12-19 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00 | 2013-03-31 00:00:00 | 1900-01-01 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-12-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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22001 | 22001 | None | 22001 | 22001 |
filer_id | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 1999 | 2007 | 2009 | 2013 | 2011 | 2005 | 2023 | 2021 | |||||||||
interest_cd | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | |||||||||
effect_date | 2001-01-01 00:00:00 | 1999-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2013-01-01 00:00:00 | 2011-01-01 00:00:00 | 2006-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-11-01 00:00:00 |
filer_id | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||
active | Y | Y | T | Y | Y | T | Y | Y | Y | Y | N | |||||||||||
race | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | |||||||||||
session_id | 1999 | 2001 | 2001 | 2005 | 2007 | 2013 | 2013 | 2011 | 2009 | 2021 | 2023 | |||||||||||
category | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | |||||||||||
category_type | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | |||||||||||
sub_category | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | |||||||||||
effect_dt | 1999-01-01 00:00:00 | 2001-01-01 00:00:00 | 2002-09-10 00:00:00 | 2006-01-01 00:00:00 | 2007-01-01 00:00:00 | 2013-06-30 00:00:00 | 2013-01-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2021-11-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||
sub_category_type | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | |||||||||||
election_type | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | |||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
nyq_dt | None | None | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | None | None | None | None | None | |||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1146116 | |
---|---|---|
xref_id | C27644 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | C27644 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER, COUNTY OF | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | YUBA CITY | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | 95993 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | 5308227100 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1146116 |
---|
filer_id | 1146116 | 1146116 | 1146116 | 1146116 | ||||
---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 3 | 0 | ||||
session_id | 2001 | 2001 | 2013 | 2021 | ||||
log_dt | 2001-03-20 00:00:00 | 2002-09-24 00:00:00 | 2013-07-15 00:00:00 | 2021-11-10 00:00:00 | ||||
filer_type | 1 | 2 | 1 | 1 | ||||
correction_flg | None | Y | Y | None | ||||
action | IN SUSPENSE | TERMINATED | DELETED | ADDED | ||||
attribute_changed | EMPLOYER | EMPLOYER | FIRM | FIRM | ||||
ethics_dt | None | None | None | None | ||||
interests | None | None | None | None | ||||
filer_full_name | SUTTER, COUNTY OF | SUTTER, COUNTY OF | SUTTER; COUNTY OF | SUTTER; COUNTY OF | ||||
filer_city | SAN FRANCISCO | None | None | None | ||||
filer_st | CA | None | None | None | ||||
filer_zip | 94105 | None | None | None | ||||
filer_phone | 4158947700 | None | None | None | ||||
entity_type | 3 | 2 | 3 | 3 | ||||
entity_name | MORSHED AND ASSOCIATES | None | DI MARE VAN VLECK & BROWN, LLC | SHAW YODER ANTWIH SCHMELZER & LANGE, INC. | ||||
entity_city | None | None | None | None | ||||
entity_st | None | None | None | None | ||||
entity_zip | None | None | None | None | ||||
entity_phone | None | None | None | None | ||||
entity_id | 1147220 | 1147220 | 1276403 | 1147267 | ||||
responsible_officer | None | None | None | None | ||||
effect_dt | None | 2002-09-10 00:00:00 | 2013-06-30 00:00:00 | 2021-11-01 00:00:00 |
filer_id | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | 1146116 | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 675169_0.cal | 715347_0.cal | 744194_0.cal | 769842_0.cal | 788301_0.cal | 808737_0.cal | 836427_0.cal | 851158_0.cal | 884297_0.cal | 112865.cal | 112996.cal | 112678.cal | 1381771_0.cal | 2666755_0.cal | 2734231_0.cal | 2698961_0.cal | 2634753_0.cal | |||||||||||||||||
received_date | 2000-10-24 00:00:00 | 2001-01-26 00:00:00 | 2001-04-26 00:00:00 | 2001-07-25 00:00:00 | 2001-10-22 00:00:00 | 2002-01-22 00:00:00 | 2002-04-22 00:00:00 | 2002-07-23 00:00:00 | 2002-10-30 00:00:00 | 2006-01-09 00:00:00 | 2006-01-09 00:00:00 | 2006-01-09 00:00:00 | 2008-11-18 00:00:00 | 2022-04-15 00:00:00 | 2022-10-14 00:00:00 | 2022-07-18 00:00:00 | 2022-01-16 00:00:00 | |||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||||||
filing_id | 675169 | 715347 | 744194 | 769842 | 788301 | 808737 | 836427 | 851158 | 884297 | None | None | None | 1381771 | 2666755 | 2734231 | 2698961 | 2634753 | |||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | None | None | F602 | F635 | F635 | F635 | F635 | |||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |