filer_id | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1105808 | 1104196 | 2011143 | 2012611 | 2518976 | 2410660 | 2469970 | 2469971 | 2547127 | 2547128 | 2289792 | 2342585 | ||||||||||||
effect_dt | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2021-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2013-05-01 00:00:00 | 2015-01-01 00:00:00 | ||||||||||||
add_type | 7050 | 7050 | 7051 | 7082 | 7051 | 7051 | 7051 | 7082 | 7051 | 7082 | 7051 | 7051 | ||||||||||||
session_id | 1997 | 1999 | 2001 | 2001 | 2021 | 2017 | 2019 | 2019 | 2023 | 2023 | 2013 | 2015 |
filer_id | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1999 | 1999 | 2001 | 1997 | 1995 | 2013 | 2015 | 2017 | 2019 | |||||||||
ethics_date | 2000-11-14 00:00:00 | 1999-01-08 00:00:00 | 2000-11-14 00:00:00 | 1999-01-08 00:00:00 | 1994-03-09 00:00:00 | 2013-08-08 00:00:00 | 2015-01-22 00:00:00 | 2017-01-12 00:00:00 | 2019-01-10 00:00:00 |
filer_id | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 521002 | 515921 | 524777 | 514783 | 528874 | 517907 | 519061 | 522689 | 525202 | 529272 | 511688 | 512766 | 523099 | 527286 | 526874 | 632238 | 623523 | 681818 | 660545 | 696874 | 715996 | 718039 | 737533 | 703734 | 730489 | 745031 | 750855 | 789969 | 770144 | 777463 | 815658 | 793137 | 814532 | 838962 | 846301 | 841813 | 854608 | 856264 | 1778802 | 1770808 | 1964203 | 1964206 | 1946773 | 1954035 | 1977350 | 1786565 | 1796728 | 1922367 | 1897224 | 1930732 | 1924879 | 1888373 | 1817921 | 1841592 | 1991857 | 2002058 | 2231644 | 2521897 | 2334295 | 2187981 | 2309082 | 2203701 | 2262361 | 2354940 | 2028581 | 2054450 | 2086617 | 2124990 | 2120150 | 2111281 | 2153474 | 2142866 | 2169279 | 2388872 | 2370150 | 2466561 | 2353915 | 2412090 | 2592597 | 2544011 | 2430162 | 2477755 | 2573093 | 2573093 | 2544011 | 2592597 | 2666928 | 2699303 | 2586780 | 2615346 | 2634855 | 2731314 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 152 | 158 | 146 | 150 | 148 | 151 | 159 | 145 | 154 | 156 | 149 | 157 | 153 | 155 | 147 | None | 160 | 163 | 162 | 163 | None | 164 | 164 | None | 164 | 165 | 165 | 167 | 166 | None | None | 167 | 168 | 169 | None | None | 170 | None | 214 | None | 220 | 221 | None | 221 | 222 | None | 215 | 220 | 219 | None | 221 | 218 | 216 | 217 | 223 | 224 | 233 | 243 | 236 | 231 | 235 | 232 | 234 | None | 225 | 226 | 227 | None | 228 | 228 | 229 | None | 230 | 238 | 237 | 241 | None | 239 | 246 | 244 | 240 | 242 | 245 | 245 | 244 | 246 | 249 | 250 | None | 247 | 248 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F606 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | 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 | 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 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1998-01-28 00:00:00 | 1999-07-28 00:00:00 | 1996-07-29 00:00:00 | 1997-07-25 00:00:00 | 1997-01-27 00:00:00 | 1997-10-30 00:00:00 | 1999-10-29 00:00:00 | 1996-04-26 00:00:00 | 1998-07-29 00:00:00 | 1999-01-22 00:00:00 | 1997-04-25 00:00:00 | 1999-04-20 00:00:00 | 1998-04-29 00:00:00 | 1998-10-28 00:00:00 | 1996-10-30 00:00:00 | 2000-04-24 00:00:00 | 2000-01-31 00:00:00 | 2000-10-31 00:00:00 | 2000-07-31 00:00:00 | 2000-10-31 00:00:00 | 2001-01-17 00:00:00 | 2001-01-31 00:00:00 | 2001-01-30 00:00:00 | 2000-12-28 00:00:00 | 2001-01-30 00:00:00 | 2001-04-27 00:00:00 | 2001-04-26 00:00:00 | 2001-10-29 00:00:00 | 2001-07-26 00:00:00 | 2001-07-23 00:00:00 | 2002-01-31 00:00:00 | 2001-10-29 00:00:00 | 2002-01-31 00:00:00 | 2002-04-29 00:00:00 | 2002-05-31 00:00:00 | 2002-04-30 00:00:00 | 2002-07-30 00:00:00 | 2002-07-30 00:00:00 | 2013-07-26 00:00:00 | 2013-05-09 00:00:00 | 2015-04-29 00:00:00 | 2015-04-29 00:00:00 | 2014-12-31 00:00:00 | 2015-03-19 00:00:00 | 2015-07-26 00:00:00 | 2013-08-08 00:00:00 | 2013-10-23 00:00:00 | 2014-12-31 00:00:00 | 2014-10-13 00:00:00 | 2015-01-22 00:00:00 | 2015-01-12 00:00:00 | 2014-09-25 00:00:00 | 2014-01-31 00:00:00 | 2014-04-25 00:00:00 | 2015-10-13 00:00:00 | 2015-12-30 00:00:00 | 2018-04-16 00:00:00 | 2020-10-23 00:00:00 | 2019-01-14 00:00:00 | 2017-10-16 00:00:00 | 2018-10-19 00:00:00 | 2018-01-21 00:00:00 | 2018-07-03 00:00:00 | 2018-12-20 00:00:00 | 2016-04-14 00:00:00 | 2016-07-11 00:00:00 | 2016-10-07 00:00:00 | 2017-01-12 00:00:00 | 2017-01-17 00:00:00 | 2016-12-15 00:00:00 | 2017-04-25 00:00:00 | 2016-12-28 00:00:00 | 2017-07-20 00:00:00 | 2019-07-05 00:00:00 | 2019-04-03 00:00:00 | 2020-04-20 00:00:00 | 2019-01-22 00:00:00 | 2019-10-08 00:00:00 | 2021-07-12 00:00:00 | 2021-01-13 00:00:00 | 2020-01-13 00:00:00 | 2020-07-10 00:00:00 | 2022-01-31 00:00:00 | 2021-04-08 00:00:00 | 2022-01-31 00:00:00 | 2022-04-17 00:00:00 | 2022-04-17 00:00:00 | 2022-07-19 00:00:00 | 2021-01-11 00:00:00 | 2021-10-11 00:00:00 | 2022-01-17 00:00:00 | 2022-10-11 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1999 | 1995 | 1997 | 1995 | 1997 | 1999 | 1995 | 1997 | 1997 | 1997 | 1999 | 1997 | 1997 | 1995 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2013 | 2013 | 2015 | 2013 | 2015 | 2015 | 2013 | 2013 | 2013 | 2015 | 2015 | 2017 | 2019 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2019 | 2019 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | GGILMORE | * | TTHAM | CFLAGG | DHULSE | * | YBONILLA | BSMITH | BSMITH | * | GPEREZ | * | * | LTHIBAUL | YBONILLA | LTHIBAUL | * | * | SARRIAGA | YBONILLA | * | YBONILLA | ASAETERN | SARRIAGA | RGEREMIA | JINGRAM | YRODRIGU | YRODRIGU | JINGRAM | PBANFORD | ASAETERN | YRODRIGU | ASAETERN | ASAETERN | JINGRAM | RGEREMIA | ASAETERN | ASAETERN | JINGRAM | AGLADNEY | AGLADNEY | GTAYLOR | JFRONEFIELD | AGLADNEY | JFRONEFIELD | AGLADNEY | JFRONEFIELD | GPEREZ | AGLADNEY | AGLADNEY | JINGRAM | PBANFORD | AGLADNEY | SARRIAGA | JINGRAM | SARRIAGA | SMCCONNAN | VUKSTINA | VUKSTINA | GTAYLOR | PBANFORD | GTAYLOR | CHATRIDGE | GTAYLOR | GTAYLOR | GTAYLOR | CAFILER | GTAYLOR | CAFILER | CAFILER | CAFILER | CAFILER | CVANLIEW | MKIRKHAM | RATTIYEH | 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 | 11002 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1997-10-01 00:00:00 | 1999-04-01 00:00:00 | 1996-04-01 00:00:00 | 1997-04-01 00:00:00 | 1996-10-01 00:00:00 | 1997-07-01 00:00:00 | 1999-07-01 00:00:00 | 1996-01-01 00:00:00 | 1998-04-01 00:00:00 | 1998-10-01 00:00:00 | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 1998-01-01 00:00:00 | 1998-07-01 00:00:00 | 1996-07-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-07-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2000-10-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 1900-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 2013-04-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-03-19 00:00:00 | 2015-04-01 00:00:00 | 1900-01-01 00:00:00 | 2013-07-01 00:00:00 | 2014-12-31 00:00:00 | 2014-07-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-01 00:00:00 | 2014-04-01 00:00:00 | 2013-10-01 00:00:00 | 2014-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-10-01 00:00:00 | 2018-01-01 00:00:00 | 2020-07-01 00:00:00 | 2018-10-01 00:00:00 | 2017-07-01 00:00:00 | 2018-07-01 00:00:00 | 2017-10-01 00:00:00 | 2018-04-01 00:00:00 | 1900-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | None | 2016-10-01 00:00:00 | 2016-12-15 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2019-04-01 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2021-04-01 00:00:00 | 2020-10-01 00:00:00 | 2019-10-01 00:00:00 | 2020-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2020-10-01 00:00:00 | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1997-12-31 00:00:00 | 1999-06-30 00:00:00 | 1996-06-30 00:00:00 | 1997-06-30 00:00:00 | 1996-12-31 00:00:00 | 1997-09-30 00:00:00 | 1999-09-30 00:00:00 | 1996-03-31 00:00:00 | 1998-06-30 00:00:00 | 1998-12-31 00:00:00 | 1997-03-31 00:00:00 | 1999-03-31 00:00:00 | 1998-03-31 00:00:00 | 1998-09-30 00:00:00 | 1996-09-30 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-09-30 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 1900-01-01 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2013-06-30 00:00:00 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 2015-03-19 00:00:00 | 2015-06-30 00:00:00 | 1900-01-01 00:00:00 | 2013-09-30 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2014-06-30 00:00:00 | 2013-12-31 00:00:00 | 2014-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 2018-03-31 00:00:00 | 2020-09-30 00:00:00 | 2018-12-31 00:00:00 | 2017-09-30 00:00:00 | 2018-09-30 00:00:00 | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 1900-01-01 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | None | 2016-12-31 00:00:00 | 2016-12-15 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2019-06-30 00:00:00 | 2019-03-31 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2021-06-30 00:00:00 | 2020-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-06-30 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | 2020-12-31 00:00:00 | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 |
filer_id | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||||||
active | Y | Y | Y | Y | T | Y | Y | Y | Y | Y | N | |||||||||||
race | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | |||||||||||
session_id | 2001 | 1997 | 1995 | 1999 | 2001 | 2013 | 2015 | 2019 | 2021 | 2017 | 2023 | |||||||||||
category | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | |||||||||||
category_type | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | |||||||||||
sub_category | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | |||||||||||
effect_dt | 2001-01-01 00:00:00 | 1997-01-01 00:00:00 | 1996-03-05 00:00:00 | 1999-01-01 00:00:00 | 2002-05-03 00:00:00 | 2013-05-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||
sub_category_type | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | |||||||||||
election_type | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | |||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
nyq_dt | None | None | None | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | None | None | None | None | |||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1149011 | |
---|---|---|
xref_id | L25208 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | L25208 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD-ARREGUIN | GOULD-ARREGUIN | GOULD-ARREGUIN | GOULD-ARREGUIN | GOULD-ARREGUIN | GOULD-ARREGUIN | GOULD-ARREGUIN | GOULD-ARREGUIN | GOULD-ARREGUIN | GOULD-ARREGUIN | GOULD-ARREGUIN | GOULD-ARREGUIN | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | GOULD | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE | ROXANNE | ROXANNE | ROXANNE | ROXANNE | ROXANNE | ROXANNE | ROXANNE | ROXANNE | ROXANNE | ROXANNE | ROXANNE | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ROXANNE L. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 95814 | 958143926 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 958143926 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 958143926 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 958143926 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 958143926 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 958143926 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 958143926 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 958143926 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9163212767 | 9163734525 | 9164417377 | 9164412430 | 9167150900 | 9167150900 | 9167150900 | 9167150900 | 9164412430 | 9167150900 | 9167150900 | 9164412430 | 9163212767 | 9163734525 | 9164417377 | 9164412430 | 9167150900 | 9167150900 | 9167150900 | 9167150900 | 9164412430 | 9167150900 | 9167150900 | 9164412430 | 9163212767 | 9163734525 | 9164417377 | 9164412430 | 9167150900 | 9167150900 | 9167150900 | 9167150900 | 9164412430 | 9167150900 | 9167150900 | 9164412430 | 9163212767 | 9163734525 | 9164417377 | 9164412430 | 9167150900 | 9167150900 | 9167150900 | 9167150900 | 9164412430 | 9167150900 | 9167150900 | 9164412430 | 9163212767 | 9163734525 | 9164417377 | 9164412430 | 9167150900 | 9167150900 | 9167150900 | 9167150900 | 9164412430 | 9167150900 | 9167150900 | 9164412430 | 9163212767 | 9163734525 | 9164417377 | 9164412430 | 9167150900 | 9167150900 | 9167150900 | 9167150900 | 9164412430 | 9167150900 | 9167150900 | 9164412430 | 9163212767 | 9163734525 | 9164417377 | 9164412430 | 9167150900 | 9167150900 | 9167150900 | 9167150900 | 9164412430 | 9167150900 | 9167150900 | 9164412430 | 9163212767 | 9163734525 | 9164417377 | 9164412430 | 9167150900 | 9167150900 | 9167150900 | 9167150900 | 9164412430 | 9167150900 | 9167150900 | 9164412430 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | 9164415756 | None | None | None | None | None | None | None | None | None | None | None | 9164415756 | None | None | None | None | None | None | None | None | None | None | None | 9164415756 | None | None | None | None | None | None | None | None | None | None | None | 9164415756 | None | None | None | None | None | None | None | None | None | None | None | 9164415756 | None | None | None | None | None | None | None | None | None | None | None | 9164415756 | None | None | None | None | None | None | None | None | None | None | None | 9164415756 | None | None | None | None | None | None | None | None | None | None | None | 9164415756 | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None |
filer_id | 1149011 |
---|
filer_id | 1149011 | 1149011 | 1149011 | 1149011 | ||||
---|---|---|---|---|---|---|---|---|
change_no | 3 | 4 | 5 | 0 | ||||
session_id | 1999 | 2001 | 2001 | 2013 | ||||
log_dt | 2001-05-05 00:00:00 | 2002-05-31 00:00:00 | 2002-05-31 00:00:00 | 2013-05-09 00:00:00 | ||||
filer_type | 4 | 4 | 4 | 4 | ||||
correction_flg | None | Y | None | Y | ||||
action | CHANGED | TERMINATED | DELETED | ADDED | ||||
attribute_changed | None | LOBBYIST | FIRM | FIRM | ||||
ethics_dt | None | None | None | None | ||||
interests | None | None | None | None | ||||
filer_full_name | ROXANNE GOULD-ARREGUIN | GOULD-ARREGUIN, ROXANNE | ROXANNE GOULD-ARREGUIN | GOULD, ROXANNE | ||||
filer_city | SACRAMENTO | SACRAMENTO | None | None | ||||
filer_st | CA | CA | None | None | ||||
filer_zip | 95814 | 95814 | None | None | ||||
filer_phone | 9163212767 | 9164412430 | None | None | ||||
entity_type | 4 | 4 | 3 | 3 | ||||
entity_name | None | None | WILKE, FLEURY, HOFFELT, GOULD & BIRNEY, LLP | GOULD GOVERNMENT RELATIONS; ROXANNE | ||||
entity_city | None | None | None | None | ||||
entity_st | None | None | None | None | ||||
entity_zip | None | None | None | None | ||||
entity_phone | None | None | None | None | ||||
entity_id | 0 | 0 | 1147240 | 1357619 | ||||
responsible_officer | None | None | None | None | ||||
effect_dt | None | 2002-05-03 00:00:00 | 2002-05-03 00:00:00 | 2013-05-01 00:00:00 |
filer_id | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | 1149011 | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 681818_0.cal | 30176.cal | 30297.cal | 718039_0.cal | 289037.cal | 290315.cal | 745031_0.cal | 268383.cal | 278025.cal | 235704.cal | 235698.cal | 279791.cal | 770144_0.cal | 297062.cal | 284256.cal | 789969_0.cal | 814532_0.cal | 838962_0.cal | 854608_0.cal | 2111281_0.cal | 1922367_0.cal | 1954035_0.cal | ||||||||||||||||||||||
received_date | 2000-10-31 00:00:00 | 2001-01-31 00:00:00 | 2001-01-31 00:00:00 | 2001-01-31 00:00:00 | 2001-05-09 00:00:00 | 2001-05-10 00:00:00 | 2001-04-27 00:00:00 | 2001-04-30 00:00:00 | 2001-05-01 00:00:00 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 | 2001-05-01 00:00:00 | 2001-07-26 00:00:00 | 2001-05-15 00:00:00 | 2001-05-04 00:00:00 | 2001-10-29 00:00:00 | 2002-01-31 00:00:00 | 2002-04-29 00:00:00 | 2002-07-30 00:00:00 | 2016-12-15 00:00:00 | 2014-12-31 00:00:00 | 2015-03-19 00:00:00 | ||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/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/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||
filing_id | 681818 | None | None | 718039 | None | None | 745031 | None | None | None | None | None | 770144 | None | None | 789969 | 814532 | 838962 | 854608 | 2111281 | 1922367 | 1954035 | ||||||||||||||||||||||
form_id | F615 | None | None | F615 | None | None | F615 | None | None | None | None | None | F615 | None | None | F615 | F615 | F615 | F615 | F604 | F604 | F604 | ||||||||||||||||||||||
receive_comment | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted, but with warnings | Filing accepted | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted |