filer_id | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1111612 | 2042847 | 2081318 | 2128048 | 2164319 | 2208054 | 2524530 | 2547095 | 2276108 | |||||||||
effect_dt | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-07-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2021-06-02 00:00:00 | 2023-01-01 00:00:00 | 2013-01-01 00:00:00 | |||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||
session_id | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2021 | 2023 | 2013 |
filer_id | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 467929 | 473427 | 490717 | 478978 | 494370 | 497974 | 626958 | 616312 | 664809 | 675164 | 708795 | 715346 | 695168 | 735910 | 744044 | 756327 | 788307 | 769834 | 779274 | 797217 | 808739 | 818946 | 841438 | 836426 | 850665 | 864468 | 893176 | 884298 | 899484 | 938804 | 911067 | 924346 | 929079 | 945160 | 949294 | 966692 | 975773 | 975974 | 987566 | 1000926 | 1017032 | 1032866 | 1012896 | 1028776 | 1064787 | 1057416 | 1091532 | 1080753 | 1084124 | 1100342 | 1141403 | 1115647 | 1130433 | 1290128 | 1299622 | 1299622 | 1757790 | 1783197 | 1800656 | 1937805 | 1912343 | 1316260 | 1322146 | 1333213 | 1341777 | 1372058 | 1391687 | 1420687 | 1433176 | 1452385 | 1453463 | 1433635 | 1482061 | 1463626 | 1503400 | 1577649 | 1577650 | 1603685 | 1620372 | 1594431 | 1588211 | 1633169 | 1603685 | 1656663 | 1818988 | 1682189 | 1706029 | 1873242 | 1735966 | 1844932 | 1841409 | 1763492 | 1966421 | 1966445 | 1983245 | 2641558 | 2588984 | 2668754 | 2622541 | 2668754 | 2614226 | 2641558 | 2601235 | 2704524 | 2622541 | 2742788 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 157 | 158 | 154 | 159 | 155 | 156 | 161 | 160 | 162 | 163 | None | 164 | 163 | 164 | 165 | 165 | 167 | 166 | None | None | 168 | None | None | 169 | 170 | None | None | 171 | None | None | 172 | None | 173 | 174 | 174 | 175 | None | None | 176 | None | None | None | 177 | 178 | None | 179 | None | 180 | None | 181 | 184 | 182 | 183 | None | 191 | 191 | 214 | 214 | 215 | 220 | 219 | 192 | 193 | None | 194 | 195 | 196 | 197 | 199 | 199 | None | 198 | 201 | 200 | 202 | 203 | 204 | 206 | 207 | None | 205 | 208 | 206 | 209 | 216 | 210 | 211 | 218 | 212 | 217 | None | 213 | 222 | 221 | 222 | 248 | 246 | 249 | 247 | 249 | None | 248 | 246 | 250 | 247 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | 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 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | 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 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-04-27 00:00:00 | 1999-07-29 00:00:00 | 1998-07-31 00:00:00 | 1999-10-25 00:00:00 | 1998-10-26 00:00:00 | 1999-01-28 00:00:00 | 2000-04-24 00:00:00 | 2000-01-27 00:00:00 | 2000-07-27 00:00:00 | 2000-10-24 00:00:00 | 2000-12-22 00:00:00 | 2001-01-26 00:00:00 | 2000-10-26 00:00:00 | 2001-01-31 00:00:00 | 2001-04-25 00:00:00 | 2001-04-30 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-01-31 00:00:00 | 2002-04-26 00:00:00 | 2002-04-22 00:00:00 | 2002-07-22 00:00:00 | 2002-07-30 00:00:00 | 2002-10-31 00:00:00 | 2002-10-30 00:00:00 | 2002-12-30 00:00:00 | 2003-04-29 00:00:00 | 2003-01-30 00:00:00 | 2003-01-31 00:00:00 | 2003-04-25 00:00:00 | 2003-07-28 00:00:00 | 2003-07-30 00:00:00 | 2003-10-24 00:00:00 | 2003-12-29 00:00:00 | 2003-10-29 00:00:00 | 2004-01-28 00:00:00 | 2004-01-29 00:00:00 | 2004-04-30 00:00:00 | 2004-07-30 00:00:00 | 2004-04-29 00:00:00 | 2004-07-29 00:00:00 | 2004-10-27 00:00:00 | 2004-10-29 00:00:00 | 2005-01-26 00:00:00 | 2005-01-31 00:00:00 | 2004-12-22 00:00:00 | 2005-04-14 00:00:00 | 2006-01-10 00:00:00 | 2005-07-27 00:00:00 | 2005-10-25 00:00:00 | 2007-03-01 00:00:00 | 2007-11-26 00:00:00 | 2008-01-17 00:00:00 | 2013-04-16 00:00:00 | 2013-07-31 00:00:00 | 2013-10-31 00:00:00 | 2015-02-02 00:00:00 | 2014-10-31 00:00:00 | 2008-02-22 00:00:00 | 2008-03-31 00:00:00 | 2008-05-02 00:00:00 | 2008-07-01 00:00:00 | 2008-10-24 00:00:00 | 2009-01-25 00:00:00 | 2009-04-29 00:00:00 | 2009-07-23 00:00:00 | 2009-10-30 00:00:00 | 2009-02-06 00:00:00 | 2009-07-25 00:00:00 | 2010-04-24 00:00:00 | 2010-01-29 00:00:00 | 2010-07-26 00:00:00 | 2011-02-17 00:00:00 | 2011-02-17 00:00:00 | 2011-07-26 00:00:00 | 2011-10-27 00:00:00 | 2011-03-29 00:00:00 | 2011-04-25 00:00:00 | 2012-01-27 00:00:00 | 2011-10-27 00:00:00 | 2012-04-29 00:00:00 | 2014-01-31 00:00:00 | 2012-08-03 00:00:00 | 2012-10-28 00:00:00 | 2014-07-31 00:00:00 | 2013-01-30 00:00:00 | 2014-04-30 00:00:00 | 2014-02-04 00:00:00 | 2013-04-29 00:00:00 | 2015-04-30 00:00:00 | 2015-04-30 00:00:00 | 2015-07-31 00:00:00 | 2022-06-27 00:00:00 | 2021-06-21 00:00:00 | 2022-04-21 00:00:00 | 2021-10-29 00:00:00 | 2022-06-27 00:00:00 | 2021-06-15 00:00:00 | 2022-01-28 00:00:00 | 2021-07-30 00:00:00 | 2022-07-29 00:00:00 | 2022-06-27 00:00:00 | 2022-10-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1997 | 1999 | 1997 | 1997 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2013 | 2013 | 2013 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2011 | 2013 | 2011 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | TTHAM | * | YBONILLA | * | GGILMORE | * | YBONILLA | YBONILLA | * | JBRANNAN | * | * | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | * | * | LTHIBAUL | LTHIBAUL | * | SARRIAGA | DWALKER | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | CFLAGG | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | PBANFORD | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | CFLAGG | YRODRIGU | LTHIBAUL | YRODRIGU | AGLADNEY | AGLADNEY | MPACHECO | AGLADNEY | LTHIBAUL | RGEREMIA | YRODRIGU | LTHIBAUL | ASAETERN | ASAETERN | WBROWN | YRODRIGU | WBROWN | YRODRIGU | WBROWN | ASAETERN | WBROWN | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | CAFILER | AGLADNEY | AGLADNEY | CHATRIDGE | MKIRKHAM | CAFILER | GTAYLOR | CAFILER | MKIRKHAM | CHATRIDGE | CHATRIDGE | CAFILER | CAFILER | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-01-01 00:00:00 | 1999-04-01 00:00:00 | 1998-04-01 00:00:00 | 1999-07-01 00:00:00 | 1998-07-01 00:00:00 | 1998-10-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2000-10-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 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 | 2001-10-01 00:00:00 | 2002-01-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 | 1900-01-01 00:00:00 | 2003-01-01 00:00:00 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-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 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2004-10-01 00:00:00 | 1900-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-10-01 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 1900-01-01 00:00:00 | 2007-07-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-16 00:00:00 | 2013-04-01 00:00:00 | 2013-07-01 00:00:00 | 2014-10-01 00:00:00 | 2014-07-01 00:00:00 | 2007-10-01 00:00:00 | 2008-01-01 00:00:00 | 1900-01-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 | 2009-07-23 00:00:00 | 2009-07-01 00:00:00 | 1900-01-01 00:00:00 | 2009-04-01 00:00:00 | 2010-01-01 00:00:00 | 2009-10-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 1900-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2011-04-01 00:00:00 | 2012-01-01 00:00:00 | 2013-10-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2014-04-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-04-30 00:00:00 | 2015-01-01 00:00:00 | 2015-04-01 00:00:00 | 2021-10-01 00:00:00 | 2021-06-21 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-04-01 00:00:00 | 2022-04-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-03-31 00:00:00 | 1999-06-30 00:00:00 | 1998-06-30 00:00:00 | 1999-09-30 00:00:00 | 1998-09-30 00:00:00 | 1998-12-31 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2000-12-31 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 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 | 2001-12-31 00:00:00 | 2002-03-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 | 1900-01-01 00:00:00 | 2003-03-31 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 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 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 1900-01-01 00:00:00 | 2005-03-31 00:00:00 | 2005-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 1900-01-01 00:00:00 | 2007-09-30 00:00:00 | 2007-09-30 00:00:00 | 2013-04-16 00:00:00 | 2013-06-30 00:00:00 | 2013-09-30 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2007-12-31 00:00:00 | 2008-03-31 00:00:00 | 1900-01-01 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 | 2009-07-23 00:00:00 | 2009-09-30 00:00:00 | 1900-01-01 00:00:00 | 2009-06-30 00:00:00 | 2010-03-31 00:00:00 | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 1900-01-01 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 2012-03-31 00:00:00 | 2013-12-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2014-06-30 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 2015-04-30 00:00:00 | 2015-03-31 00:00:00 | 2015-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-06-21 00:00:00 | 2022-03-31 00:00:00 | 2021-09-30 00:00:00 | 2022-03-31 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | 2021-09-30 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22001 | None | 22001 | 22001 | None | 22001 | None | None | 22001 | None | None | None | 22001 | 22001 | None | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 1999 | 1997 | 2003 | 2013 | 2007 | 2009 | 2011 | 2005 | 2023 | 2021 | |||||||||||
interest_cd | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | |||||||||||
effect_date | 2001-01-01 00:00:00 | 1999-01-01 00:00:00 | 1998-04-02 00:00:00 | 2003-01-01 00:00:00 | 2013-01-01 00:00:00 | 2007-07-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2005-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-06-02 00:00:00 |
filer_id | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||
active | Y | Y | Y | Y | Y | T | Y | Y | Y | Y | Y | N | ||||||||||||
race | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||
session_id | 1999 | 1997 | 2001 | 2003 | 2005 | 2005 | 2013 | 2007 | 2011 | 2009 | 2021 | 2023 | ||||||||||||
category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||
category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||
sub_category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||
effect_dt | 1999-01-01 00:00:00 | 1998-04-02 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-11-30 00:00:00 | 2013-01-01 00:00:00 | 2007-07-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2021-06-02 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||
sub_category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||
election_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
nyq_dt | None | None | None | None | None | 2000-07-01 00:00:00 | None | 2000-07-01 00:00:00 | None | None | None | None | ||||||||||||
party_cd | 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 | ||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1145859 | |
---|---|---|
xref_id | C27380 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | C27380 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | WHITTIER; CITY 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 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | WHITTIER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 906021772 | 906021772 | 906021772 | 90602 | 90602 | 90602 | 90602 | 90602 | 90602 | 906021772 | 906021772 | 906021772 | 90602 | 90602 | 90602 | 90602 | 90602 | 90602 | 906021772 | 906021772 | 906021772 | 90602 | 90602 | 90602 | 90602 | 90602 | 90602 | 906021772 | 906021772 | 906021772 | 90602 | 90602 | 90602 | 90602 | 90602 | 90602 | 906021772 | 906021772 | 906021772 | 90602 | 90602 | 90602 | 90602 | 90602 | 90602 | 906021772 | 906021772 | 906021772 | 90602 | 90602 | 90602 | 90602 | 90602 | 90602 | 906021772 | 906021772 | 906021772 | 90602 | 90602 | 90602 | 90602 | 90602 | 90602 | 906021772 | 906021772 | 906021772 | 90602 | 90602 | 90602 | 90602 | 90602 | 90602 | 906021772 | 906021772 | 906021772 | 90602 | 90602 | 90602 | 90602 | 90602 | 90602 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5625679302 | 5625679302 | 5625679999 | 5625679999 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5625679302 | 5625679302 | 5625679999 | 5625679999 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5625679302 | 5625679302 | 5625679999 | 5625679999 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5625679302 | 5625679302 | 5625679999 | 5625679999 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5625679302 | 5625679302 | 5625679999 | 5625679999 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5625679302 | 5625679302 | 5625679999 | 5625679999 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5625679302 | 5625679302 | 5625679999 | 5625679999 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5625679302 | 5625679302 | 5625679999 | 5625679999 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5624643301 | 5625679302 | 5625679302 | 5625679999 | 5625679999 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | 5624643570 | 5624643570 | 5625672871 | None | None | None | 5624643570 | 5624643570 | 5625672871 | None | None | None | 5624643570 | 5624643570 | 5625672871 | None | None | None | 5624643570 | 5624643570 | 5625672871 | None | None | None | 5624643570 | 5624643570 | 5625672871 | None | None | None | 5624643570 | 5624643570 | 5625672871 | None | None | None | 5624643570 | 5624643570 | 5625672871 | None | None | None | 5624643570 | 5624643570 | 5625672871 | None | None | None | 5624643570 | 5624643570 | 5625672871 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None |
filer_id | 1145859 |
---|
filer_id | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | |||||
---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 4 | 5 | 6 | 0 | |||||
session_id | 2001 | 2001 | 2005 | 2009 | 2011 | |||||
log_dt | 2001-03-20 00:00:00 | 2002-08-12 00:00:00 | 2005-12-02 00:00:00 | 2009-10-15 00:00:00 | 2011-04-26 00:00:00 | |||||
filer_type | 1 | 2 | 1 | 1 | 1 | |||||
correction_flg | None | Y | None | Y | Y | |||||
action | IN SUSPENSE | NEW | DELETED | ADDED | ADDED | |||||
attribute_changed | EMPLOYER | RESPONSIBLE OFFICER | FIRM | FIRM | FIRM | |||||
ethics_dt | None | None | None | None | None | |||||
interests | None | None | None | None | None | |||||
filer_full_name | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER, CITY OF | WHITTIER; CITY OF | WHITTIER; CITY OF | |||||
filer_city | SAN FRANCISCO | WHITTIER | None | None | None | |||||
filer_st | CA | CA | None | None | None | |||||
filer_zip | 94105 | 906021772 | None | None | None | |||||
filer_phone | 4158947700 | 5624643301 | None | None | None | |||||
entity_type | 3 | None | 3 | 3 | 3 | |||||
entity_name | MORSHED AND ASSOCIATES | NANCY MENDEZ | MORSHED AND ASSOCIATES | RICE/ENGLANDER & ASSOCIATES | RICE/ENGLANDER & ASSOCIATES | |||||
entity_city | None | None | None | None | None | |||||
entity_st | None | None | None | None | None | |||||
entity_zip | None | None | None | None | None | |||||
entity_phone | None | None | None | None | None | |||||
entity_id | 1147220 | None | 1147220 | 1285159 | 1285159 | |||||
responsible_officer | None | None | None | None | None | |||||
effect_dt | None | 2002-07-01 00:00:00 | 2005-11-30 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 |
filer_id | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | 1145859 | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 675164_0.cal | 715346_0.cal | 744044_0.cal | 769834_0.cal | 788307_0.cal | 808739_0.cal | 836426_0.cal | 850665_0.cal | 884298_0.cal | 911067_0.cal | 929079_0.cal | 945160_0.cal | 966692_0.cal | 987566_0.cal | 1012896_0.cal | 1028776_0.cal | 1057416_0.cal | 1080753_0.cal | 1100342_0.cal | 1115647_0.cal | 1141403_0.cal | 1130433_0.cal | ||||||||||||||||||||||
received_date | 2000-10-24 00:00:00 | 2001-01-26 00:00:00 | 2001-04-25 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-22 00:00:00 | 2002-10-30 00:00:00 | 2003-01-30 00:00:00 | 2003-04-25 00:00:00 | 2003-07-28 00:00:00 | 2003-10-24 00:00:00 | 2004-01-28 00:00:00 | 2004-04-29 00:00:00 | 2004-07-29 00:00:00 | 2004-10-29 00:00:00 | 2005-01-31 00:00:00 | 2005-04-14 00:00:00 | 2005-07-27 00:00:00 | 2006-01-10 00:00:00 | 2005-10-25 00:00:00 | ||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||
filing_id | 675164 | 715346 | 744044 | 769834 | 788307 | 808739 | 836426 | 850665 | 884298 | 911067 | 929079 | 945160 | 966692 | 987566 | 1012896 | 1028776 | 1057416 | 1080753 | 1100342 | 1115647 | 1141403 | 1130433 | ||||||||||||||||||||||
form_id | 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 | 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 |