filer_id | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1104377 | 2042135 | 2082118 | 2113336 | 2440260 | 2427895 | 2471283 | 2510040 | 2457494 | 2551482 | ||||||||||
effect_dt | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2017-09-26 00:00:00 | 2017-02-02 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2018-08-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||
session_id | 1999 | 2003 | 2005 | 2007 | 2017 | 2017 | 2019 | 2021 | 2017 | 2023 |
filer_id | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1999 | 1997 | 1995 | 2001 | 2003 | 2005 | 2007 | 2017 | 2019 | 2021 | ||||||||||
ethics_date | 1999-01-08 00:00:00 | 1999-01-08 00:00:00 | 1997-06-20 00:00:00 | 2001-01-25 00:00:00 | 2002-11-13 00:00:00 | 2005-02-09 00:00:00 | 2007-02-08 00:00:00 | 2017-11-02 00:00:00 | 2019-04-11 00:00:00 | 2021-06-10 00:00:00 |
filer_id | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 513206 | 515029 | 516358 | 523305 | 511911 | 521760 | 525976 | 527475 | 542839 | 528013 | 519489 | 521232 | 525404 | 518154 | 523857 | 617273 | 632120 | 678031 | 645840 | 662942 | 691962 | 717091 | 704116 | 704116 | 752119 | 744606 | 736729 | 790747 | 770449 | 782087 | 796772 | 811921 | 824612 | 838123 | 862537 | 841364 | 853806 | 892414 | 897431 | 898140 | 881756 | 914224 | 909389 | 928897 | 933997 | 946515 | 966179 | 987345 | 971403 | 955384 | 994002 | 1011058 | 1012690 | 1027781 | 1035497 | 1076270 | 1061476 | 1054871 | 1067675 | 1072296 | 1114536 | 1108228 | 1103584 | 1067675 | 1131365 | 1144562 | 1165495 | 1185186 | 1230071 | 1228121 | 1216071 | 1282952 | 1264481 | 1269079 | 1295023 | 1311237 | 1329999 | 1349421 | 1361496 | 1372883 | 2195030 | 2437944 | 2537763 | 2210856 | 2329643 | 2527357 | 2152344 | 2171420 | 2140613 | 2399510 | 2236561 | 2348127 | 2208915 | 2417963 | 2350161 | 2311916 | 2537763 | 2548220 | 2329643 | 2212511 | 2190962 | 2486115 | 2270177 | 2377810 | 2592786 | 2468793 | 2464793 | 2604480 | 2592786 | 2699800 | 2636307 | 2669074 | 2575614 | 2636307 | 2615483 | 2582120 | 2615483 | 2736382 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 157 | 150 | 158 | 153 | 149 | 145 | 147 | 155 | 156 | 148 | 159 | 152 | 154 | 151 | 146 | 160 | None | 163 | 162 | 162 | 163 | 164 | None | None | 165 | 165 | 164 | 167 | 166 | None | None | 168 | None | 169 | None | None | 170 | None | 172 | None | 171 | None | 172 | 173 | None | 174 | 175 | 176 | None | None | None | 177 | None | 178 | None | 180 | None | 179 | 180 | None | 182 | None | 181 | 182 | 183 | 184 | 185 | 186 | None | 188 | 187 | 190 | None | 189 | 191 | 192 | 193 | 194 | None | 195 | None | 240 | 244 | 232 | 241 | 243 | 229 | 230 | None | 238 | 233 | None | 233 | 239 | 236 | 235 | 246 | 244 | 236 | None | 231 | 242 | 234 | 237 | 246 | 241 | None | None | 246 | 250 | 248 | 249 | 245 | 248 | 247 | None | 247 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F606 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-04-30 00:00:00 | 1997-07-30 00:00:00 | 1999-07-30 00:00:00 | 1998-04-29 00:00:00 | 1997-04-30 00:00:00 | 1996-04-29 00:00:00 | 1996-10-31 00:00:00 | 1998-10-29 00:00:00 | 1999-01-28 00:00:00 | 1997-01-31 00:00:00 | 1999-10-27 00:00:00 | 1998-01-30 00:00:00 | 1998-07-29 00:00:00 | 1997-10-30 00:00:00 | 1996-07-31 00:00:00 | 2000-01-31 00:00:00 | 2000-04-26 00:00:00 | 2000-10-27 00:00:00 | 2000-08-01 00:00:00 | 2000-07-31 00:00:00 | 2000-10-30 00:00:00 | 2001-01-30 00:00:00 | 2000-12-28 00:00:00 | 2001-01-25 00:00:00 | 2001-04-30 00:00:00 | 2001-04-27 00:00:00 | 2001-01-30 00:00:00 | 2001-10-30 00:00:00 | 2001-07-26 00:00:00 | 2001-07-31 00:00:00 | 2001-10-30 00:00:00 | 2002-01-29 00:00:00 | 2002-01-30 00:00:00 | 2002-04-29 00:00:00 | 2002-07-31 00:00:00 | 2002-04-29 00:00:00 | 2002-07-30 00:00:00 | 2002-10-29 00:00:00 | 2002-12-23 00:00:00 | 2002-12-23 00:00:00 | 2002-10-29 00:00:00 | 2003-01-31 00:00:00 | 2003-01-30 00:00:00 | 2003-04-25 00:00:00 | 2003-04-28 00:00:00 | 2003-07-30 00:00:00 | 2003-10-23 00:00:00 | 2004-01-28 00:00:00 | 2003-10-27 00:00:00 | 2003-07-31 00:00:00 | 2004-01-29 00:00:00 | 2004-04-26 00:00:00 | 2004-04-27 00:00:00 | 2004-07-29 00:00:00 | 2004-08-02 00:00:00 | 2005-01-27 00:00:00 | 2004-10-27 00:00:00 | 2004-10-27 00:00:00 | 2004-12-23 00:00:00 | 2004-12-29 00:00:00 | 2005-07-26 00:00:00 | 2005-05-25 00:00:00 | 2005-04-28 00:00:00 | 2005-05-24 00:00:00 | 2005-10-27 00:00:00 | 2006-01-26 00:00:00 | 2006-04-27 00:00:00 | 2006-07-19 00:00:00 | 2006-12-22 00:00:00 | 2007-01-16 00:00:00 | 2006-10-31 00:00:00 | 2007-07-30 00:00:00 | 2007-04-24 00:00:00 | 2007-05-24 00:00:00 | 2007-10-25 00:00:00 | 2008-01-31 00:00:00 | 2008-04-30 00:00:00 | 2008-07-30 00:00:00 | 2008-10-01 00:00:00 | 2008-10-27 00:00:00 | 2017-11-02 00:00:00 | 2020-01-29 00:00:00 | 2020-12-21 00:00:00 | 2018-01-31 00:00:00 | 2020-03-18 00:00:00 | 2020-10-30 00:00:00 | 2017-04-21 00:00:00 | 2017-07-25 00:00:00 | 2017-02-10 00:00:00 | 2019-07-31 00:00:00 | 2018-04-25 00:00:00 | 2018-12-28 00:00:00 | 2018-01-30 00:00:00 | 2019-10-30 00:00:00 | 2019-01-31 00:00:00 | 2018-10-24 00:00:00 | 2021-06-14 00:00:00 | 2021-01-27 00:00:00 | 2018-12-26 00:00:00 | 2018-01-31 00:00:00 | 2017-10-26 00:00:00 | 2020-07-31 00:00:00 | 2018-07-26 00:00:00 | 2019-04-26 00:00:00 | 2021-07-13 00:00:00 | 2020-04-29 00:00:00 | 2020-03-30 00:00:00 | 2021-07-06 00:00:00 | 2022-04-14 00:00:00 | 2022-07-21 00:00:00 | 2022-09-28 00:00:00 | 2022-04-22 00:00:00 | 2021-04-20 00:00:00 | 2022-01-21 00:00:00 | 2021-10-12 00:00:00 | 2021-01-04 00:00:00 | 2022-07-28 00:00:00 | 2022-10-19 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10006 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10006 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10006 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 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 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1997 | 1999 | 1997 | 1997 | 1995 | 1995 | 1997 | 1997 | 1995 | 1999 | 1997 | 1997 | 1997 | 1995 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2017 | 2019 | 2021 | 2017 | 2019 | 2019 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2017 | 2019 | 2017 | 2017 | 2021 | 2019 | 2019 | 2017 | 2017 | 2019 | 2017 | 2019 | 2021 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | CFLAGG | TTHAM | * | * | YBONILLA | YBONILLA | * | GKURIMOT | BSMITH | YBONILLA | * | YBONILLA | * | * | LTHIBAUL | GGILMORE | * | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | BSMITH | GPEREZ | * | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | KVANG | COMPLETED | EMCENTEE | COMPLETED | YBONILLA | COMPLETED | LTHIBAUL | COMPLETED | GPEREZ | SARRIAGA | LTHIBAUL | SARRIAGA | LTHIBAUL | GPEREZ | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | GPEREZ | LTHIBAUL | LTHIBAUL | LTHIBAUL | CFLAGG | LTHIBAUL | LTHIBAUL | YRODRIGU | LTHIBAUL | YRODRIGU | YRODRIGU | SMCCONNAN | PBANFORD | GTAYLOR | MMERCHANT | AGLADNEY | AROJAS | GTAYLOR | SMCCONNAN | SMCCONNAN | PBANFORD | VUKSTINA | AGLADNEY | SARRIAGA | GPEREZ | VUKSTINA | JFRONEFIELD | JFRONEFIELD | CVANLIEW | CHARTRIDGE | SARRIAGA | GPEREZ | AGLADNEY | CVANLIEW | JFRONEFIELD | VUKSTINA | CHATRIDGE | VUKSTINA | AROJAS | CVANLIEW | GTAYLOR | CAFILER | CAFILER | CAFILER | CHARTRIDGE | RATTIYEH | GTAYLOR | MMERCHANT | CAFILER | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 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 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-01-01 00:00:00 | 1997-04-01 00:00:00 | 1999-04-01 00:00:00 | 1998-01-01 00:00:00 | 1997-01-01 00:00:00 | 1996-01-01 00:00:00 | 1996-07-01 00:00:00 | 1998-07-01 00:00:00 | 1998-10-01 00:00:00 | 1996-10-01 00:00:00 | 1999-07-01 00:00:00 | 1997-10-01 00:00:00 | 1998-04-01 00:00:00 | 1997-07-01 00:00:00 | 1996-04-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 2000-07-01 00:00:00 | 2000-04-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-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-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-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-12-18 00:00:00 | 1900-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-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 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2004-12-23 00:00:00 | 1900-01-01 00:00:00 | 2005-04-01 00:00:00 | 1900-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-05-24 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 1900-01-01 00:00:00 | 2006-10-01 00:00:00 | 2006-07-01 00:00:00 | 2007-04-01 00:00:00 | 1900-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-07-01 00:00:00 | 2007-10-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 1900-01-01 00:00:00 | 2008-07-01 00:00:00 | 1900-01-01 00:00:00 | 2019-10-01 00:00:00 | 2020-12-21 00:00:00 | 2017-10-01 00:00:00 | 2020-03-16 00:00:00 | 2020-07-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2018-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-01-30 00:00:00 | 2019-07-01 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2021-06-14 00:00:00 | 2020-10-01 00:00:00 | 2018-12-26 00:00:00 | 1900-01-01 00:00:00 | 2017-07-01 00:00:00 | 2020-04-01 00:00:00 | 2018-04-01 00:00:00 | 2019-01-01 00:00:00 | 2021-04-01 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-07-01 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-03-31 00:00:00 | 1997-06-30 00:00:00 | 1999-06-30 00:00:00 | 1998-03-31 00:00:00 | 1997-03-31 00:00:00 | 1996-03-31 00:00:00 | 1996-09-30 00:00:00 | 1998-09-30 00:00:00 | 1998-12-31 00:00:00 | 1996-12-31 00:00:00 | 1999-09-30 00:00:00 | 1997-12-31 00:00:00 | 1998-06-30 00:00:00 | 1997-09-30 00:00:00 | 1996-06-30 00:00:00 | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 2000-09-30 00:00:00 | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 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-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-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-18 00:00:00 | 1900-01-01 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 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 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-23 00:00:00 | 1900-01-01 00:00:00 | 2005-06-30 00:00:00 | 1900-01-01 00:00:00 | 2005-03-31 00:00:00 | 2005-05-24 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 1900-01-01 00:00:00 | 2006-12-31 00:00:00 | 2006-09-30 00:00:00 | 2007-06-30 00:00:00 | 1900-01-01 00:00:00 | 2007-03-31 00:00:00 | 2007-09-30 00:00:00 | 2007-12-31 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 1900-01-01 00:00:00 | 2008-09-30 00:00:00 | 1900-01-01 00:00:00 | 2019-12-31 00:00:00 | 2020-12-21 00:00:00 | 2017-12-31 00:00:00 | 2020-03-16 00:00:00 | 2020-09-30 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 2018-03-31 00:00:00 | 1900-01-01 00:00:00 | 2018-01-30 00:00:00 | 2019-09-30 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2021-06-14 00:00:00 | 2020-12-31 00:00:00 | 2018-12-26 00:00:00 | 1900-01-01 00:00:00 | 2017-09-30 00:00:00 | 2020-06-30 00:00:00 | 2018-06-30 00:00:00 | 2019-03-31 00:00:00 | 2021-06-30 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2021-03-31 00:00:00 | 2021-12-31 00:00:00 | 2021-09-30 00:00:00 | 1900-01-01 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 | 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 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | None | None | 22001 | None | 22001 | None | 22001 | None | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 |
filer_id | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | ||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | T | Y | Y | R | Y | Y | N | ||||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
session_id | 2001 | 1997 | 1995 | 1999 | 2003 | 2005 | 2007 | 2007 | 2017 | 2019 | 2019 | 2021 | 2019 | 2023 | ||||||||||||||
category | 0 | 0 | 0 | 0 | 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 | ||||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
effect_dt | 2001-01-01 00:00:00 | 1997-01-01 00:00:00 | 1996-03-28 00:00:00 | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2008-09-30 00:00:00 | 2017-02-02 00:00:00 | 2020-03-30 00:00:00 | 2019-06-30 00:00:00 | 2021-01-01 00:00:00 | 2019-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 | ||||||||||||||
election_type | 0 | 0 | 0 | 0 | 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 | ||||||||||||||
nyq_dt | None | None | None | None | None | 2000-04-01 00:00:00 | 2000-04-01 00:00:00 | 2000-04-01 00:00:00 | 2000-04-01 00:00:00 | None | None | None | None | None | ||||||||||||||
party_cd | 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 | ||||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1149037 | |
---|---|---|
xref_id | L25234 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | L25234 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | TRATTEN | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | LEA-ANN | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164426902 | 9164426902 | 9164426902 | 9164426902 | 9167696820 | 9167696820 | 9167696820 | 9167696820 | 9168346344 | 9168346344 | 9164426902 | 9164426902 | 9164426902 | 9164426902 | 9167696820 | 9167696820 | 9167696820 | 9167696820 | 9168346344 | 9168346344 | 9164426902 | 9164426902 | 9164426902 | 9164426902 | 9167696820 | 9167696820 | 9167696820 | 9167696820 | 9168346344 | 9168346344 | 9164426902 | 9164426902 | 9164426902 | 9164426902 | 9167696820 | 9167696820 | 9167696820 | 9167696820 | 9168346344 | 9168346344 | 9164426902 | 9164426902 | 9164426902 | 9164426902 | 9167696820 | 9167696820 | 9167696820 | 9167696820 | 9168346344 | 9168346344 | 9164426902 | 9164426902 | 9164426902 | 9164426902 | 9167696820 | 9167696820 | 9167696820 | 9167696820 | 9168346344 | 9168346344 | 9164426902 | 9164426902 | 9164426902 | 9164426902 | 9167696820 | 9167696820 | 9167696820 | 9167696820 | 9168346344 | 9168346344 | 9164426902 | 9164426902 | 9164426902 | 9164426902 | 9167696820 | 9167696820 | 9167696820 | 9167696820 | 9168346344 | 9168346344 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | 9164427734 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None |
filer_id | 1149037 |
---|
filer_id | 1149037 | 1149037 | 1149037 | |||
---|---|---|---|---|---|---|
change_no | 2 | 3 | 4 | |||
session_id | 2007 | 2017 | 2017 | |||
log_dt | 2008-10-01 00:00:00 | 2017-02-10 00:00:00 | 2017-02-10 00:00:00 | |||
filer_type | 4 | 4 | 4 | |||
correction_flg | Y | None | None | |||
action | DELETED | SET ACTIVE | SET ACTIVE | |||
attribute_changed | EMPLOYER | FIRM | ||||
ethics_dt | None | None | None | |||
interests | None | None | None | |||
filer_full_name | TRATTEN, LEA ANN | TRATTEN, LEA-ANN | TRATTEN, LEA-ANN | |||
filer_city | None | None | None | |||
filer_st | None | None | None | |||
filer_zip | None | None | None | |||
filer_phone | None | None | None | |||
entity_type | 2 | 4 | 3 | |||
entity_name | CONSUMER ATTORNEYS OF CALIFORNIA | None | TRATTENPRICE | |||
entity_city | None | None | None | |||
entity_st | None | None | None | |||
entity_zip | None | None | None | |||
entity_phone | None | None | None | |||
entity_id | 1146762 | 0 | 1394663 | |||
responsible_officer | None | None | None | |||
effect_dt | 2008-09-30 00:00:00 | 2017-02-02 00:00:00 | 2017-02-02 00:00:00 |
filer_id | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | 1149037 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 20158.cal | 16714.cal | 645840_0.cal | 678031_0.cal | 717091_0.cal | 218804.cal | 744606_0.cal | 770449_0.cal | 54609.cal | 54896.cal | 790747_0.cal | 486416.cal | 811921_0.cal | 838123_0.cal | 853806_0.cal | 881756_0.cal | 897431_0.cal | 928897_0.cal | 909389_0.cal | 946515_0.cal | 966179_0.cal | 987345_0.cal | 1011058_0.cal | 1027781_0.cal | 1054871_0.cal | 1076270_0.cal | 1103584_0.cal | 1067675_1.cal | 1114536_0.cal | 1131365_0.cal | 1144562_0.cal | 1165495_0.cal | 1185186_0.cal | 2152344_0.cal | 298285.cal | 2171420_0.cal | 2417963_0.cal | 2329643_1.cal | 2210856_0.cal | 2468793_0.cal | 2377810_0.cal | 2236561_0.cal | 2486115_0.cal | 2350161_0.cal | 2208915_0.cal | 2399510_0.cal | 2437944_0.cal | 2311916_0.cal | 2329643_0.cal | 2190962_0.cal | 2270177_0.cal | 2537763_0.cal | 2548220_0.cal | 2636307_1.cal | 2527357_0.cal | 2575614_0.cal | 2699800_0.cal | 2615483_1.cal | 2592786_1.cal | 2736382_0.cal | 2636307_0.cal | 2592786_0.cal | 2669074_0.cal | 2537763_1.cal | 2615483_0.cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-07-28 00:00:00 | 2000-07-28 00:00:00 | 2000-08-01 00:00:00 | 2000-10-27 00:00:00 | 2001-01-30 00:00:00 | 2001-04-27 00:00:00 | 2001-04-27 00:00:00 | 2001-07-26 00:00:00 | 2001-10-30 00:00:00 | 2001-10-30 00:00:00 | 2001-10-30 00:00:00 | 2002-01-29 00:00:00 | 2002-01-29 00:00:00 | 2002-04-29 00:00:00 | 2002-07-30 00:00:00 | 2002-10-29 00:00:00 | 2002-12-23 00:00:00 | 2003-04-25 00:00:00 | 2003-01-30 00:00:00 | 2003-07-30 00:00:00 | 2003-10-23 00:00:00 | 2004-01-28 00:00:00 | 2004-04-26 00:00:00 | 2004-07-29 00:00:00 | 2004-10-27 00:00:00 | 2005-01-27 00:00:00 | 2005-04-28 00:00:00 | 2005-05-24 00:00:00 | 2005-07-26 00:00:00 | 2005-10-27 00:00:00 | 2006-01-26 00:00:00 | 2006-04-27 00:00:00 | 2006-07-19 00:00:00 | 2017-04-21 00:00:00 | 2017-05-24 00:00:00 | 2017-07-25 00:00:00 | 2019-10-30 00:00:00 | 2020-03-18 00:00:00 | 2018-01-31 00:00:00 | 2020-04-29 00:00:00 | 2019-04-26 00:00:00 | 2018-04-25 00:00:00 | 2020-07-31 00:00:00 | 2019-01-31 00:00:00 | 2018-01-30 00:00:00 | 2019-07-31 00:00:00 | 2020-01-29 00:00:00 | 2018-10-24 00:00:00 | 2018-12-26 00:00:00 | 2017-10-26 00:00:00 | 2018-07-26 00:00:00 | 2020-12-21 00:00:00 | 2021-01-27 00:00:00 | 2022-09-28 00:00:00 | 2020-10-30 00:00:00 | 2021-04-20 00:00:00 | 2022-07-21 00:00:00 | 2022-07-28 00:00:00 | 2022-04-14 00:00:00 | 2022-10-19 00:00:00 | 2022-01-21 00:00:00 | 2021-07-13 00:00:00 | 2022-04-22 00:00:00 | 2021-06-14 00:00:00 | 2021-10-12 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_directory | /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 | /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/cal | /usr/users/cafiler/disclose/ca99/temp | /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/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | None | None | 645840 | 678031 | 717091 | None | 744606 | 770449 | None | None | 790747 | None | 811921 | 838123 | 853806 | 881756 | 897431 | 928897 | 909389 | 946515 | 966179 | 987345 | 1011058 | 1027781 | 1054871 | 1076270 | 1103584 | 1067675 | 1114536 | 1131365 | 1144562 | 1165495 | 1185186 | 2152344 | None | 2171420 | 2417963 | 2329643 | 2210856 | 2468793 | 2377810 | 2236561 | 2486115 | 2350161 | 2208915 | 2399510 | 2437944 | 2311916 | 2329643 | 2190962 | 2270177 | 2537763 | 2548220 | 2636307 | 2527357 | 2575614 | 2699800 | 2615483 | 2592786 | 2736382 | 2636307 | 2592786 | 2669074 | 2537763 | 2615483 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | None | None | F615 | F615 | F615 | None | F615 | F615 | None | None | F615 | None | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | None | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing did not pass validation | Filing did not pass validation | Filing accepted, but but with warnings | Filing accepted, but but with warnings | Filing accepted, but with warnings | Filing did not pass validation | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | 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 passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |