filing_id | 932006 | 947680 | 969626 | 990303 | 1014068 | 1032203 | 1059767 | 1183714 | 1166209 | 1259236 | 1231290 | 1281611 | 1213436 | 1294391 | 1308368 | 1374837 | 1349191 | 1327517 | 1451184 | 1421022 | 1392891 | 1436257 | 1456250 | 1637356 | 1709441 | 1679840 | 1656587 | 1740592 | 1800007 | 1783409 | 1766196 | 1817542 | 1867252 | 1843373 | 1933055 | 1911944 | 1962082 | 1977354 | 1996451 | 2062677 | 2037058 | 2007883 | 2100265 | 2171678 | 2156716 | 2126124 | 2191514 | 2206870 | 2271360 | 2240171 | 2397077 | 2321264 | 2350569 | 2382085 | 2417604 | 2441194 | 2471186 | 2487473 | 2552249 | 2531341 | 2603022 | 2624755 | 2581247 | 2707007 | 2676217 | 2643121 | 2748184 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sender_id | E24497 | E24497 | E24497 | E24497 | E24497 | E24497 | E24497 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1276403 | 1254233 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1402149 | 1402149 | 1402149 | 1402149 | 1402149 | 1402149 | 1402149 | 1402149 | 1402149 | 1402149 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | LBY | FRM | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | FRM | FRM | FRM | FRM | FRM | FRM | FRM | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_naml | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | Kessler | KESSLER | Alice L. Kessler | Alice L. Kessler | Kessler | Alice L. Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | KESSLER | KESSLER | Kessler | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_namf | Alice | Alice | Alice | Alice | Alice | Alice | Alice | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | Alice L. | ALICE L. | None | None | Alice L. | None | Alice L. | Alice L. | Alice L. | Alice L. | Alice L. | ALICE | ALICE | Alice L. | ALICE | ALICE | ALICE | ALICE | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE | ALICE | ALICE L. | ALICE | ALICE | ALICE | ALICE | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2003-04-30 00:00:00 | 2003-07-31 00:00:00 | 2003-10-31 00:00:00 | 2004-02-02 00:00:00 | 2004-04-30 00:00:00 | 2004-08-02 00:00:00 | 2004-11-02 00:00:00 | 2006-07-12 00:00:00 | 2006-04-28 00:00:00 | 2007-04-25 00:00:00 | 2007-01-24 00:00:00 | 2007-07-27 00:00:00 | 2006-10-27 00:00:00 | 2007-10-23 00:00:00 | 2008-01-29 00:00:00 | 2008-10-29 00:00:00 | 2008-07-30 00:00:00 | 2008-04-28 00:00:00 | 2009-10-29 00:00:00 | 2009-04-30 00:00:00 | 2009-01-27 00:00:00 | 2009-07-30 00:00:00 | 2009-12-29 00:00:00 | 2012-01-31 00:00:00 | 2012-10-31 00:00:00 | 2012-07-31 00:00:00 | 2012-04-29 00:00:00 | 2013-01-31 00:00:00 | 2013-10-30 00:00:00 | 2013-07-31 00:00:00 | 2013-04-30 00:00:00 | 2014-01-31 00:00:00 | 2014-07-28 00:00:00 | 2014-04-29 00:00:00 | 2015-01-29 00:00:00 | 2014-10-31 00:00:00 | 2015-04-25 00:00:00 | 2015-07-26 00:00:00 | 2015-10-29 00:00:00 | 2016-07-30 00:00:00 | 2016-05-01 00:00:00 | 2016-01-27 00:00:00 | 2016-10-29 00:00:00 | 2017-07-26 00:00:00 | 2017-04-30 00:00:00 | 2017-01-28 00:00:00 | 2017-10-29 00:00:00 | 2018-01-27 00:00:00 | 2018-07-28 00:00:00 | 2018-04-28 00:00:00 | 2019-07-31 00:00:00 | 2018-10-31 00:00:00 | 2019-01-31 00:00:00 | 2019-04-30 00:00:00 | 2019-10-11 00:00:00 | 2020-01-22 00:00:00 | 2020-04-30 00:00:00 | 2020-07-31 00:00:00 | 2021-01-31 00:00:00 | 2020-10-31 00:00:00 | 2021-08-02 00:00:00 | 2021-11-01 00:00:00 | 2021-04-30 00:00:00 | 2022-08-01 00:00:00 | 2022-05-02 00:00:00 | 2022-01-31 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
from_date | 2003-03-10 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2006-04-01 00:00:00 | 2006-01-01 00:00:00 | 2007-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-04-01 00:00:00 | 2006-07-01 00:00:00 | 2007-07-01 00:00:00 | 2007-10-01 00:00:00 | 2008-07-01 00:00:00 | 2008-04-01 00:00:00 | 2008-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-01-01 00:00:00 | 2008-10-01 00:00:00 | 2009-04-01 00:00:00 | 2009-10-01 00:00:00 | 2011-10-01 00:00:00 | 2012-07-01 00:00:00 | 2012-04-01 00:00:00 | 2012-01-01 00:00:00 | 2012-10-01 00:00:00 | 2013-07-01 00:00:00 | 2013-04-01 00:00:00 | 2013-01-01 00:00:00 | 2013-10-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-07-01 00:00:00 | 2015-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-07-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-07-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-07-01 00:00:00 | 2017-10-01 00:00:00 | 2018-04-01 00:00:00 | 2018-01-01 00:00:00 | 2019-04-01 00:00:00 | 2018-07-01 00:00:00 | 2018-10-01 00:00:00 | 2019-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-04-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
thru_date | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-07-23 00:00:00 | 2006-06-30 00:00:00 | 2006-03-31 00:00:00 | 2007-03-31 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 2006-09-30 00:00:00 | 2007-09-30 00:00:00 | 2007-12-31 00:00:00 | 2008-09-30 00:00:00 | 2008-06-30 00:00:00 | 2008-03-31 00:00:00 | 2009-09-30 00:00:00 | 2009-03-31 00:00:00 | 2008-12-31 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-09-30 00:00:00 | 2012-06-30 00:00:00 | 2012-03-31 00:00:00 | 2012-12-31 00:00:00 | 2013-09-30 00:00:00 | 2013-06-30 00:00:00 | 2013-03-31 00:00:00 | 2013-12-31 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2015-03-31 00:00:00 | 2015-06-30 00:00:00 | 2015-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-09-30 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 2017-09-30 00:00:00 | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 2018-03-31 00:00:00 | 2019-06-30 00:00:00 | 2018-09-30 00:00:00 | 2018-12-31 00:00:00 | 2019-03-31 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cum_beg_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | None | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_id | E24497 | E24497 | E24497 | E24497 | E24497 | E24497 | E24497 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1276403 | 1254233 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1402149 | 1402149 | 1402149 | 1402149 | 1402149 | 1402149 | 1402149 | 1402149 | 1402149 | 1402149 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_name | Protection and Advocacy | Protection and Advocacy | Protection and Advocacy | Protection and Advocacy | Protection and Advocacy | Protection and Advocacy | Protection and Advocacy | Equality California | Equality California | Equality California | Equality California | Equality California | Equality California | Equality California | Equality California | Equality California | Equality California | Equality California | Equality California | Equality California | Equality California | Equality California | Equality California | DiMare, Van Vleck & Brown, LLC | DiMare, Van Vleck & Brown, LLC | 01/01/2011 | DiMare, Van Vleck & Brown, LLC | DiMare, Van Vleck & Brown, LLC | DiMare, Van Vleck & Brown, LLC | DiMare, Van Vleck & Brown, LLC | DiMare, Van Vleck & Brown, LLC | DI MARE, BROWN, HICKS & KESSLER, LLC | DiMare, Brown. Hicks & Kessler, LLC | DiMare, Brown, Hicks & Kessler, LLC | DiMare, Brown. Hicks & Kessler, LLC | DiMare, Brown. Hicks & Kessler, LLC | DiMare, Brown. Hicks & Kessler, LLC | DiMare, Brown. Hicks & Kessler, LLC | DiMare, Brown. Hicks & Kessler, LLC | DiMare, Brown. Hicks & Kessler, LLC | DiMare, Brown. Hicks & Kessler, LLC | DiMare, Brown. Hicks & Kessler, LLC | DiMare, Brown. Hicks & Kessler, LLC | Dimare, Brown, Hicks & Kessler, LLC | DiMare, Brown, Hicks & Kessler, LLC | DiMare, Brown. Hicks & Kessler, LLC | Dimare, Brown, Hicks & Kessler, LLC | Dimare, Brown, Hicks & Kessler, LLC | Dimare, Brown, Hicks & Kessler, LLC | Dimare, Brown, Hicks & Kessler, LLC | LIGHTHOUSE PUBLIC AFFAIRS, LLC | LIGHTHOUSE PUBLIC AFFAIRS, LLC | LIGHTHOUSE PUBLIC AFFAIRS, LLC | LIGHTHOUSE PUBLIC AFFAIRS, LLC | LIGHTHOUSE PUBLIC AFFAIRS, LLC | LIGHTHOUSE PUBLIC AFFAIRS, LLC | LIGHTHOUSE PUBLIC AFFAIRS, LLC | LIGHTHOUSE PUBLIC AFFAIRS, LLC | LIGHTHOUSE PUBLIC AFFAIRS, LLC | LIGHTHOUSE PUBLIC AFFAIRS, LLC | GREENBERG TRAURIG, LLP | Greenberg Traurig, LLP | GREENBERG TRAURIG, LLP | Greenberg Traurig, LLP | GREENBERG TRAURIG, LLP | GREENBERG TRAURIG, LLP | GREENBERG TRAURIG, LLP | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_zip4 | 95825 | 95825 | 95825 | 95825 | 95825 | 95825 | 95825 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_phon | (916) 488-9955 | (916) 488-9955 | (916) 488-9955 | (916) 488-9955 | (916) 488-9955 | (916) 488-9955 | (916) 488-9955 | 9165547681 | 9165547681 | 9165547681 | 9165547681 | 9165547681 | 9165547681 | 9165547681 | 9165547681 | 9165547681 | 9165547681 | 9165547681 | 9165547681 | 9165547681 | 9165547681 | 9165547681 | 9165547681 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 916-341-0808 | 9163410808 | 916-341-0808 | 916-341-0808 | 916-341-0808 | 916-341-0808 | 916-341-0808 | 916-341-0808 | 916-341-0808 | 916-341-0808 | 916-341-0808 | 916/341-0808 | 916/341-0808 | 916-341-0808 | 916/341-0808 | 916/341-0808 | 916/341-0808 | 916/341-0808 | (916) 318-8866 | (916) 318-8866 | (916) 318-8866 | (916) 318-8866 | (916) 318-8866 | (916) 318-8866 | (916) 318-8866 | (916) 318-8866 | (916) 318-8866 | (916) 318-8866 | 9164421111 | 9164421111 | 9163188866 | 9164421111 | 9164421111 | 9164421111 | 9164421111 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_city | None | None | None | Sacramento | Sacramento | Sacramento | Sacramento | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_st | None | None | None | CA | CA | CA | CA | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_zip4 | None | None | None | 95814 | 95814 | 95814 | 95814 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_date | 2003-04-08 00:00:00 | 2003-04-30 00:00:00 | 2003-10-13 00:00:00 | 2004-01-27 00:00:00 | 2004-04-06 00:00:00 | 2004-07-01 00:00:00 | 2004-11-01 00:00:00 | 2006-07-12 00:00:00 | 2006-04-26 00:00:00 | 2007-04-25 00:00:00 | 2007-01-24 00:00:00 | 2007-07-27 00:00:00 | 2006-10-27 00:00:00 | 2007-10-23 00:00:00 | 2008-01-29 00:00:00 | 2008-10-29 00:00:00 | 2008-07-30 00:00:00 | 2008-04-28 00:00:00 | 2009-10-29 00:00:00 | 2009-04-30 00:00:00 | 2009-01-27 00:00:00 | 2009-07-30 00:00:00 | 2009-12-29 00:00:00 | 2012-01-31 00:00:00 | 2012-10-31 00:00:00 | 2012-07-31 00:00:00 | 2012-04-29 00:00:00 | 2013-01-31 00:00:00 | 2013-10-30 00:00:00 | 2013-07-31 00:00:00 | 2013-04-30 00:00:00 | 2014-01-31 00:00:00 | 2014-07-28 00:00:00 | 2014-04-29 00:00:00 | 2015-01-26 00:00:00 | 2014-10-27 00:00:00 | 2015-04-25 00:00:00 | 2015-07-26 00:00:00 | 2015-10-27 00:00:00 | 2016-07-30 00:00:00 | 2016-04-30 00:00:00 | 2016-01-25 00:00:00 | 2016-10-29 00:00:00 | 2017-07-26 00:00:00 | 2017-04-30 00:00:00 | 2017-01-28 00:00:00 | 2017-10-29 00:00:00 | 2018-01-27 00:00:00 | 2018-07-28 00:00:00 | 2018-04-28 00:00:00 | 2019-07-24 00:00:00 | 2018-10-31 00:00:00 | 2019-01-31 00:00:00 | 2019-04-30 00:00:00 | 2019-10-11 00:00:00 | 2020-01-22 00:00:00 | 2020-04-15 00:00:00 | 2020-07-14 00:00:00 | 2021-01-15 00:00:00 | 2020-10-19 00:00:00 | 2021-08-02 00:00:00 | 2021-10-31 00:00:00 | 2021-04-30 00:00:00 | 2022-08-01 00:00:00 | 2022-04-30 00:00:00 | 2022-01-31 00:00:00 | 2022-10-28 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_loc | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | San Francisco, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento CA | Sacramento, CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | SACRAMENTO, CA | SACRAMENTO, CA | Sacramento CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_naml | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | KESSLER | KESSLER | Kessler | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namf | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice L. | Alice | Alice L. | Alice L. | Alice L. | Alice L. | Alice L. | Alice L. | Alice L. | Alice L. | Alice L. | ALICE | ALICE | Alice L. | ALICE | ALICE | ALICE | ALICE | ALICE A. | ALICE L. | ALICE L. | ALICE A. | ALICE A. | ALICE A. | ALICE A. | ALICE A. | ALICE L. | ALICE A. | Alice | Alice | Alice | Alice | Alice | Alice | Alice | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Kessler | Kessler | None | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | None | Kessler | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | Kessler | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Alice | Alice | None | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | Alice | None | Alice | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ALICE A. | ALICE L. | ALICE L. | ALICE A. | ALICE A. | ALICE A. | ALICE A. | ALICE A. | ALICE L. | ALICE A. | Alice | Alice | Alice | Alice | Alice | Alice | Alice | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_title | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Government Affairs Director | Government Affairs Director | None | Government Affairs Director | Government Affairs Director | Government Affairs Director | Government Affairs Director | Government Affairs Director | Lobbyist | Legislative Advocate | Advocate | Lobbyist | Lobbyist | Legislative Advocate | Legislative Advocate | Legislative Advocate | Partner | None | Lobbyist | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Shareholder | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopart1_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopart2_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
part1_1_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
part1_2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_n_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lby_actvty | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lobby_n_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lobby_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rcpcmte_nm | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rcpcmte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_id | 926150 | 931266 | 1231398 | 1381270 | 1456257 | 1720333 | 1922320 | 1922320 | 2116827 | 2116827 | 2293047 | 2354956 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | ||||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||||||
form_type | F604 | F606 | F604 | F604 | F606 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | ||||||||||||
sender_id | E24497 | E24497 | C27623 | C27623 | C27623 | 1276403 | 1276403 | 1276403 | 1276403 | 1276403 | 1402149 | 1402149 | ||||||||||||
filer_id | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | ||||||||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | ||||||||||||
filer_naml | Kessler | Kessler | KESSLER | KESSLER | KESSLER | KESSLER | Alice L. Kessler | Alice L. Kessler | KESSLER | KESSLER | KESSLER | KESSLER | ||||||||||||
filer_namf | Alice | Alice | ALICE L. | ALICE L. | ALICE L. | ALICE L. | None | None | ALICE | ALICE | ALICE L. | ALICE L. | ||||||||||||
filer_namt | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
filer_nams | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 001 | 000 | 000 | ||||||||||||
rpt_date | 2003-04-01 00:00:00 | 2003-04-30 00:00:00 | 2007-01-24 00:00:00 | 2008-11-11 00:00:00 | 2009-12-29 00:00:00 | 2012-12-26 00:00:00 | 2014-12-31 00:00:00 | 2015-01-23 00:00:00 | 2017-01-03 00:00:00 | 2017-07-10 00:00:00 | 2018-09-18 00:00:00 | 2019-02-05 00:00:00 | ||||||||||||
ls_beg_yr | 2003 | 2003 | 2007 | 2009 | 2009 | 2013 | 2015 | 2015 | 2017 | 2017 | 2017 | 2019 | ||||||||||||
ls_end_yr | 2004 | 2004 | 2008 | 2010 | 2010 | 2014 | 2016 | 2016 | 2018 | 2018 | 2018 | 2020 | ||||||||||||
qual_date | 2003-03-10 00:00:00 | None | None | 2006-02-13 00:00:00 | None | 2013-01-01 00:00:00 | None | None | None | None | 2018-09-01 00:00:00 | 2019-01-01 00:00:00 | ||||||||||||
eff_date | None | 2003-04-25 00:00:00 | None | None | 2009-12-31 00:00:00 | None | None | None | None | None | None | None | ||||||||||||
bus_city | Sacramento | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | Sacramento | Sacramento | Sacramento | SACRAMENTO | SACRAMENTO | ||||||||||||
bus_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||
bus_zip4 | 95825 | 95825 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||
bus_phon | (916) 488-9955 | (916) 488-9955 | 9165547681 | 9165547681 | None | 9163410808 | 916-341-0808 | 9163410808 | 916/341-0808 | 9163410808 | (916) 318-8866 | (916) 318-8866 | ||||||||||||
bus_fax | (916) 488-2653 | (916) 488-2653 | 9164424616 | 9164424616 | None | 9163410849 | None | None | None | None | None | None | ||||||||||||
bus_email | None | None | [email protected] | [email protected] | None | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | ||||||||||||
mail_city | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
mail_st | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
mail_phon | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
sig_date | 2003-03-14 00:00:00 | 2003-04-11 00:00:00 | 2007-01-24 00:00:00 | 2008-11-11 00:00:00 | 2009-12-29 00:00:00 | 2012-12-26 00:00:00 | 2014-12-16 00:00:00 | 2015-01-22 00:00:00 | 2017-01-03 00:00:00 | 2017-07-10 00:00:00 | 2018-09-10 00:00:00 | 2019-01-15 00:00:00 | ||||||||||||
sig_loc | None | None | None | None | None | None | Sacramento CA | None | None | None | SACRAMENTO, CA | SACRAMENTO, CA | ||||||||||||
sig_naml | Kessler | Blakemore | KESSLER | KESSLER | Kessler | KESSLER | Kessler | Alice L. Kessler | KESSLER | KESSLER | KESSLER | KESSLER | ||||||||||||
sig_namf | Alice | Catherine | ALICE L. | ALICE L. | Alice | ALICE L. | Alice L. | None | ALICE | ALICE | ALICE | ALICE | ||||||||||||
sig_namt | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
sig_nams | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
prn_naml | None | Blakemore | KESSLER | KESSLER | Kessler | KESSLER | None | Alice L. Kessler | None | KESSLER | KESSLER | KESSLER | ||||||||||||
prn_namf | None | Catherine | ALICE L. | ALICE L. | Alice | ALICE L. | None | None | None | ALICE | ALICE | ALICE | ||||||||||||
prn_namt | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
prn_nams | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
sig_title | None | Executive Director | None | None | Government Affairs Director | None | None | None | None | None | DIRECTOR | DIRECTOR | ||||||||||||
stmt_firm | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
ind_cb | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
bus_cb | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
trade_cb | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
oth_cb | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
a_b_name | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
a_b_city | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
a_b_st | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
a_b_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
descrip_1 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
descrip_2 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
c_less50 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
c_more50 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
ind_class | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
ind_descr | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
bus_class | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
bus_descr | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
auth_name | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
auth_city | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
auth_st | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
auth_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
lobby_int | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
influen_yn | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
firm_name | Protection and Advocacy, Inc | Protection and Advocacy, Inc | Equality California | Equality California | Equality California | DiMare, Van Vleck & Brown, LLC | DiMare, Brown. Hicks & Kessler, LLC | DiMare, Brown. Hicks & Kessler, LLC | Dimare, Brown, Hicks & Kessler, LLC | Dimare, Brown, Hicks & Kessler, LLC | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | ||||||||||||
newcert_cb | X | None | None | None | None | None | None | None | X | None | None | None | ||||||||||||
rencert_cb | None | None | None | X | None | X | X | None | None | None | None | None | ||||||||||||
complet_dt | None | None | 2007-01-18 00:00:00 | None | None | None | None | 2015-01-22 00:00:00 | None | 2016-11-17 00:00:00 | 2016-11-17 00:00:00 | 2018-11-15 00:00:00 | ||||||||||||
lby_reg_cb | X | None | X | X | None | X | X | X | X | X | X | X | ||||||||||||
lby_604_cb | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
st_leg_yn | None | None | Y | Y | None | Y | Y | Y | Y | Y | N | N | ||||||||||||
st_agency | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
lobby_cb | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
l_firm_cb | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2049594 | 2098155 | 2113290 | 2160469 | 2224583 | 2505631 | 2410968 | 2470385 | 2276209 | 2461099 | 2547248 | 2478486 | 2343882 | 2382056 | ||||||||||||||
effect_dt | 2003-03-10 00:00:00 | 2006-02-13 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-12-12 00:00:00 | 2021-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2013-01-01 00:00:00 | 2018-09-01 00:00:00 | 2023-01-01 00:00:00 | 2019-03-01 00:00:00 | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | ||||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||||||
session_id | 2003 | 2005 | 2007 | 2009 | 2011 | 2021 | 2017 | 2019 | 2013 | 2017 | 2023 | 2019 | 2015 | 2015 |
filer_id | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2003 | 2007 | 2009 | 2011 | 2013 | 2015 | 2017 | 2019 | 2021 | |||||||||
ethics_date | 2003-11-13 00:00:00 | 2007-01-18 00:00:00 | 2009-04-24 00:00:00 | 2012-03-15 00:00:00 | 2013-04-11 00:00:00 | 2015-01-22 00:00:00 | 2016-11-17 00:00:00 | 2018-11-15 00:00:00 | 2021-01-28 00:00:00 |
filer_id | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 926150 | 925715 | 932006 | 928263 | 931266 | 947680 | 960465 | 969626 | 972599 | 990303 | 956757 | 973359 | 1001435 | 1033526 | 1032203 | 1014068 | 1029017 | 1018814 | 1059767 | 1063798 | 1152182 | 1166209 | 1183714 | 1231398 | 1231290 | 1213436 | 1229855 | 1233541 | 1281611 | 1259236 | 1308368 | 1294391 | 1783409 | 1962082 | 1977354 | 1867252 | 1800007 | 1922320 | 1947002 | 1911944 | 1349191 | 1327517 | 1374837 | 1392891 | 1381270 | 1405672 | 1421022 | 1425250 | 1451184 | 1456257 | 1456846 | 1456250 | 1436257 | 1630151 | 1637356 | 1646135 | 1656587 | 1679840 | 1817542 | 1930400 | 1933055 | 1922320 | 1709441 | 1740592 | 1720333 | 1843373 | 1766196 | 1758550 | 1752481 | 1996451 | 2365159 | 2397077 | 2293047 | 2321264 | 2350569 | 2382085 | 2441194 | 2007883 | 2037058 | 2062677 | 2100265 | 2126124 | 2116827 | 2139352 | 2171678 | 2116827 | 2156716 | 2166383 | 2191514 | 2417604 | 2471186 | 2292997 | 2206870 | 2354956 | 2531341 | 2271360 | 2487473 | 2240171 | 2552249 | 2624755 | 2581247 | 2643121 | 2582742 | 2630706 | 2603022 | 2707007 | 2676217 | 2748184 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 174 | None | 173 | None | 174 | 174 | None | 175 | None | 176 | None | None | None | None | 178 | 177 | 178 | None | 179 | None | None | 185 | 186 | 189 | 188 | 187 | None | None | 190 | 189 | 192 | 191 | 214 | 221 | 222 | 218 | 215 | 220 | None | 219 | 194 | 193 | 195 | 196 | 196 | None | 197 | None | 199 | 200 | None | 200 | 198 | None | 208 | None | 209 | 210 | 216 | None | 220 | 221 | 211 | 212 | 212 | 217 | 213 | None | None | 223 | None | 238 | 235 | 235 | 236 | 237 | 240 | 224 | 225 | 226 | 227 | 228 | 229 | None | 230 | 231 | 229 | None | 231 | 239 | 241 | None | 232 | 237 | 243 | 234 | 242 | 233 | 244 | 247 | 245 | 248 | None | None | 246 | 250 | 249 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F604 | F604 | F615 | F606 | F606 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F606 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F606 | F606 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | 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 | 1 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2003-04-01 00:00:00 | 2003-03-19 00:00:00 | 2003-04-30 00:00:00 | 2003-04-21 00:00:00 | 2003-04-30 00:00:00 | 2003-07-31 00:00:00 | 2003-09-24 00:00:00 | 2003-10-31 00:00:00 | 2003-11-13 00:00:00 | 2004-02-02 00:00:00 | 2003-07-28 00:00:00 | 2003-10-30 00:00:00 | 2004-01-29 00:00:00 | 2004-08-02 00:00:00 | 2004-08-02 00:00:00 | 2004-04-30 00:00:00 | 2004-07-29 00:00:00 | 2004-04-30 00:00:00 | 2004-11-02 00:00:00 | 2004-11-02 00:00:00 | 2006-02-15 00:00:00 | 2006-04-28 00:00:00 | 2006-07-12 00:00:00 | 2007-01-24 00:00:00 | 2007-01-24 00:00:00 | 2006-10-27 00:00:00 | 2006-12-13 00:00:00 | 2007-01-26 00:00:00 | 2007-07-27 00:00:00 | 2007-04-25 00:00:00 | 2008-01-29 00:00:00 | 2007-10-23 00:00:00 | 2013-07-31 00:00:00 | 2015-04-25 00:00:00 | 2015-07-26 00:00:00 | 2014-07-28 00:00:00 | 2013-10-30 00:00:00 | 2014-12-31 00:00:00 | 2014-12-30 00:00:00 | 2014-10-31 00:00:00 | 2008-07-30 00:00:00 | 2008-04-28 00:00:00 | 2008-10-29 00:00:00 | 2009-01-27 00:00:00 | 2008-11-11 00:00:00 | 2008-11-13 00:00:00 | 2009-04-30 00:00:00 | 2009-04-24 00:00:00 | 2009-10-29 00:00:00 | 2009-12-29 00:00:00 | 2010-01-05 00:00:00 | 2009-12-29 00:00:00 | 2009-07-30 00:00:00 | 2011-12-16 00:00:00 | 2012-01-31 00:00:00 | 2012-03-15 00:00:00 | 2012-04-29 00:00:00 | 2012-07-31 00:00:00 | 2014-01-31 00:00:00 | 2015-01-22 00:00:00 | 2015-01-29 00:00:00 | 2015-01-23 00:00:00 | 2012-10-31 00:00:00 | 2013-01-31 00:00:00 | 2012-12-26 00:00:00 | 2014-04-29 00:00:00 | 2013-04-30 00:00:00 | 2013-04-11 00:00:00 | 2012-12-28 00:00:00 | 2015-10-29 00:00:00 | 2019-02-06 00:00:00 | 2019-07-30 00:00:00 | 2018-09-18 00:00:00 | 2018-10-31 00:00:00 | 2019-01-31 00:00:00 | 2019-04-30 00:00:00 | 2020-01-30 00:00:00 | 2016-01-27 00:00:00 | 2016-05-01 00:00:00 | 2016-07-30 00:00:00 | 2016-10-29 00:00:00 | 2017-01-28 00:00:00 | 2017-01-03 00:00:00 | 2017-01-03 00:00:00 | 2017-07-26 00:00:00 | 2017-07-10 00:00:00 | 2017-04-30 00:00:00 | 2017-07-10 00:00:00 | 2017-10-29 00:00:00 | 2019-10-30 00:00:00 | 2020-04-30 00:00:00 | 2018-09-17 00:00:00 | 2018-01-27 00:00:00 | 2019-02-05 00:00:00 | 2020-11-02 00:00:00 | 2018-07-28 00:00:00 | 2020-07-31 00:00:00 | 2018-04-28 00:00:00 | 2021-01-31 00:00:00 | 2021-11-01 00:00:00 | 2021-04-30 00:00:00 | 2022-01-31 00:00:00 | 2021-01-04 00:00:00 | 2021-12-03 00:00:00 | 2021-08-02 00:00:00 | 2022-08-01 00:00:00 | 2022-05-02 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10006 | 10001 | 10001 | 10003 | 10001 | 10001 | 10005 | 10001 | 10006 | 10001 | 10001 | 10001 | 10006 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10006 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2007 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2015 | 2013 | 2013 | 2015 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2015 | 2013 | 2015 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2019 | 2019 | 2017 | 2017 | 2017 | 2019 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | COMPLETED | SARRIAGA | COMPLETED | CFLAGG | COMPLETED | COMPLETED | SARRIAGA | COMPLETED | GPEREZ | COMPLETED | LTHIBAUL | LTHIBAUL | EMCENTEE | CFLAGG | COMPLETED | COMPLETED | GPEREZ | LTHIBAUL | COMPLETED | EMCENTEE | CFLAGG | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | PBANFORD | PBANFORD | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | ASAETERN | JINGRAM | JINGRAM | ASAETERN | ASAETERN | YRODRIGU | YRODRIGU | ASAETERN | LTHIBAUL | LTHIBAUL | JINGRAM | JINGRAM | YRODRIGU | JVAZQUEZ | JINGRAM | YRODRIGU | JINGRAM | YRODRIGU | YRODRIGU | JINGRAM | JINGRAM | YRODRIGU | ASAETERN | MPACHECO | ASAETERN | AGLADNEY | ASAETERN | ASAETERN | AGLADNEY | YRODRIGU | ASAETERN | ASAETERN | YRODRIGU | AGLADNEY | ASAETERN | SMCCONNAN | YRODRIGU | JINGRAM | SARRIAGA | VUKSTINA | GPEREZ | JFRONEFIELD | AGLADNEY | VUKSTINA | VUKSTINA | AGLADNEY | AGLADNEY | AGLADNEY | JINGRAM | AGLADNEY | YRODRIGU | YRODRIGU | SMCCONNAN | PBANFORD | AGLADNEY | PBANFORD | SMCCONNAN | VUKSTINA | VUKSTINA | GPEREZ | AGLADNEY | SARRIAGA | MKIRKHAM | AGLADNEY | MMERCHANT | AGLADNEY | CHARTRIDGE | GTAYLOR | CHARTRIDGE | GTAYLOR | MKIRKHAM | MMERCHANT | CHATRIDGE | CAFILER | MKIRKHAM | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 2003-04-01 00:00:00 | 1900-01-01 00:00:00 | 2003-03-10 00:00:00 | 1900-01-01 00:00:00 | 2003-04-30 00:00:00 | 2003-04-01 00:00:00 | 1900-01-01 00:00:00 | 2003-07-01 00:00:00 | 1900-01-01 00:00:00 | 2003-10-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 1900-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2007-01-24 00:00:00 | 2006-10-01 00:00:00 | 2006-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-01-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-04-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2008-04-01 00:00:00 | 2008-01-01 00:00:00 | 2008-07-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-11 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-12-29 00:00:00 | 1900-01-01 00:00:00 | 2009-10-01 00:00:00 | 2009-04-01 00:00:00 | 1900-01-01 00:00:00 | 2011-10-01 00:00:00 | 1900-01-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2015-01-23 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 2012-12-26 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-07-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2018-09-18 00:00:00 | 2018-07-01 00:00:00 | 2018-10-01 00:00:00 | 2019-01-01 00:00:00 | 2019-10-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2017-01-03 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-07-10 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-07-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-10-01 00:00:00 | 2019-02-05 00:00:00 | 2020-07-01 00:00:00 | 2018-04-01 00:00:00 | 2020-04-01 00:00:00 | 2018-01-01 00:00:00 | 2020-10-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-10-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 | 2022-01-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 2003-04-01 00:00:00 | 1900-01-01 00:00:00 | 2003-03-31 00:00:00 | 1900-01-01 00:00:00 | 2003-04-30 00:00:00 | 2003-06-30 00:00:00 | 1900-01-01 00:00:00 | 2003-09-30 00:00:00 | 1900-01-01 00:00:00 | 2003-12-31 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 1900-01-01 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-07-23 00:00:00 | 2004-07-23 00:00:00 | 1900-01-01 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2007-01-24 00:00:00 | 2006-12-31 00:00:00 | 2006-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-06-30 00:00:00 | 2007-03-31 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2008-06-30 00:00:00 | 2008-03-31 00:00:00 | 2008-09-30 00:00:00 | 2008-12-31 00:00:00 | 2008-11-11 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 1900-01-01 00:00:00 | 2009-09-30 00:00:00 | 2009-12-29 00:00:00 | 1900-01-01 00:00:00 | 2009-12-31 00:00:00 | 2009-06-30 00:00:00 | 1900-01-01 00:00:00 | 2011-12-31 00:00:00 | 1900-01-01 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2015-01-23 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00 | 2012-12-26 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-09-30 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 2018-09-18 00:00:00 | 2018-09-30 00:00:00 | 2018-12-31 00:00:00 | 2019-03-31 00:00:00 | 2019-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2017-01-03 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2017-07-10 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-09-30 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-12-31 00:00:00 | 2019-02-05 00:00:00 | 2020-09-30 00:00:00 | 2018-06-30 00:00:00 | 2020-06-30 00:00:00 | 2018-03-31 00:00:00 | 2020-12-31 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-12-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 | 2022-03-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | 22001 | None | 22001 | None | 22001 | 22001 | None | 22001 | None | 22001 | None | None | None | None | 22001 | 22001 | None | None | 22001 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22001 | 22001 | 22006 | 22001 | None | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | None | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22006 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 |
filer_id | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||||||||||||
active | Y | T | T | Y | Y | Y | Y | Y | Y | T | Y | Y | Y | Y | R | N | Y | |||||||||||||||||
race | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||
session_id | 2003 | 2003 | 2003 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2009 | 2021 | 2015 | 2019 | 2017 | 2021 | 2023 | 2021 | |||||||||||||||||
category | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||
category_type | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||
sub_category | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||
effect_dt | 2003-03-10 00:00:00 | 2003-04-25 00:00:00 | 2004-07-23 00:00:00 | 2003-09-09 00:00:00 | 2006-02-13 00:00:00 | 2007-01-01 00:00:00 | 2011-12-12 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-12-31 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-07-01 00:00:00 | 2023-01-01 00:00:00 | 2021-12-03 00:00:00 | |||||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||
election_type | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||
nyq_dt | None | None | None | None | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||
party_cd | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||
county_cd | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||
district_cd | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1254233 | |
---|---|---|
xref_id | 1254233 | |
effect_dt | 2003-03-28 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | KESSLER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE L. | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ALICE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | 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 | 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 | 9164970331 | 9165547681 | 9165547681 | 9165547681 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163188866 | 9163188866 | 9163188866 | 9164421111 | 9164421111 | 9164970331 | 9165547681 | 9165547681 | 9165547681 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163188866 | 9163188866 | 9163188866 | 9164421111 | 9164421111 | 9164970331 | 9165547681 | 9165547681 | 9165547681 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163188866 | 9163188866 | 9163188866 | 9164421111 | 9164421111 | 9164970331 | 9165547681 | 9165547681 | 9165547681 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163188866 | 9163188866 | 9163188866 | 9164421111 | 9164421111 | 9164970331 | 9165547681 | 9165547681 | 9165547681 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163188866 | 9163188866 | 9163188866 | 9164421111 | 9164421111 | 9164970331 | 9165547681 | 9165547681 | 9165547681 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163188866 | 9163188866 | 9163188866 | 9164421111 | 9164421111 | 9164970331 | 9165547681 | 9165547681 | 9165547681 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163188866 | 9163188866 | 9163188866 | 9164421111 | 9164421111 | 9164970331 | 9165547681 | 9165547681 | 9165547681 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163188866 | 9163188866 | 9163188866 | 9164421111 | 9164421111 | 9164970331 | 9165547681 | 9165547681 | 9165547681 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163188866 | 9163188866 | 9163188866 | 9164421111 | 9164421111 | 9164970331 | 9165547681 | 9165547681 | 9165547681 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163188866 | 9163188866 | 9163188866 | 9164421111 | 9164421111 | 9164970331 | 9165547681 | 9165547681 | 9165547681 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163410808 | 9163188866 | 9163188866 | 9163188866 | 9164421111 | 9164421111 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164970813 | 9164424616 | 9164424616 | 9164424616 | 9163410849 | 9163410849 | 9164970813 | 9164424616 | 9164424616 | 9164424616 | 9163410849 | 9163410849 | 9164970813 | 9164424616 | 9164424616 | 9164424616 | 9163410849 | 9163410849 | 9164970813 | 9164424616 | 9164424616 | 9164424616 | 9163410849 | 9163410849 | 9164970813 | 9164424616 | 9164424616 | 9164424616 | 9163410849 | 9163410849 | 9164970813 | 9164424616 | 9164424616 | 9164424616 | 9163410849 | 9163410849 | 9164970813 | 9164424616 | 9164424616 | 9164424616 | 9163410849 | 9163410849 | 9164970813 | 9164424616 | 9164424616 | 9164424616 | 9163410849 | 9163410849 | 9164970813 | 9164424616 | 9164424616 | 9164424616 | 9163410849 | 9163410849 | 9164970813 | 9164424616 | 9164424616 | 9164424616 | 9163410849 | 9163410849 | 9164970813 | 9164424616 | 9164424616 | 9164424616 | 9163410849 | 9163410849 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1254233 |
---|
filer_id | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 9 | 10 | 8 | 11 | ||||||||||||
session_id | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2009 | 2011 | 2017 | 2017 | 2017 | 2017 | ||||||||||||
log_dt | 2003-03-19 00:00:00 | 2003-04-21 00:00:00 | 2003-09-24 00:00:00 | 2004-08-02 00:00:00 | 2004-08-02 00:00:00 | 2006-02-15 00:00:00 | 2010-01-05 00:00:00 | 2012-02-06 00:00:00 | 2018-09-12 00:00:00 | 2017-01-03 00:00:00 | 2017-01-03 00:00:00 | 2018-09-17 00:00:00 | ||||||||||||
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | ||||||||||||
correction_flg | Y | Y | Y | None | None | None | Y | Y | Y | None | None | Y | ||||||||||||
action | ADDED | TERMINATED | ADDED | DELETED | TERMINATED | SET ACTIVE | DELETED | ADDED | DELETED | None | REVOKE | ADDED | ||||||||||||
attribute_changed | None | None | None | EMPLOYER | EMPLOYER | FIRM | FIRM | ETHICS DATE | FIRM | |||||||||||||||
ethics_dt | None | None | None | None | None | None | None | None | None | 2016-11-17 00:00:00 | None | None | ||||||||||||
interests | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
filer_full_name | KESSLER, ALICE | KESSLER, ALICE L. | KESSLER, ALICE L. | ALICE L. KESSLER | KESSLER, ALICE L. | KESSLER, ALICE L. | KESSLER, ALICE L. | KESSLER, ALICE L. | KESSLER, ALICE L. | KESSLER, ALICE L. | KESSLER, ALICE L. | KESSLER, ALICE L. | ||||||||||||
filer_city | None | SACRAMENTO | SACRAMENTO | None | None | None | None | None | None | None | None | SACRAMENTO | ||||||||||||
filer_st | None | CA | CA | None | None | None | None | None | None | None | None | CA | ||||||||||||
filer_zip | None | 95814 | 95814 | None | None | None | None | None | None | None | None | 95814 | ||||||||||||
filer_phone | None | 9164970331 | 9164970331 | None | None | None | None | None | None | None | None | 9164970331 | ||||||||||||
entity_type | 2 | 4 | 2 | 2 | 4 | 4 | 2 | 3 | 3 | 4 | 4 | 3 | ||||||||||||
entity_name | PROTECTION & ADVOCACY INC. | PROTECTION AND ADVOCACY INC. | PROTECTION & ADVOCACY INC. | PROTECTION & ADVOCACY INC. | None | None | EQUALITY CALIFORNIA | DI MARE VAN VLECK & BROWN LLC | DI MARE, BROWN, HICKS & KESSLER, LLC | None | None | LIGHTHOUSE PUBLIC AFFAIRS, LLC | ||||||||||||
entity_city | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
entity_st | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
entity_zip | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
entity_phone | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
entity_id | 1146980 | None | None | 1146980 | 0 | 0 | 1146097 | 1276403 | 1276403 | 0 | 0 | None | ||||||||||||
responsible_officer | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
effect_dt | 2003-03-10 00:00:00 | 2003-04-25 00:00:00 | 2003-09-09 00:00:00 | 2004-07-23 00:00:00 | 2004-07-23 00:00:00 | 2006-02-13 00:00:00 | 2009-12-31 00:00:00 | 2011-12-12 00:00:00 | 2018-08-31 00:00:00 | 2016-11-17 00:00:00 | 2017-07-01 00:00:00 | 2017-09-01 00:00:00 |
filer_id | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | 1254233 | ||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 926150_0.cal | 932006_0.cal | 931266_0.cal | 947680_0.cal | 969626_0.cal | 990303_0.cal | 1032203_0.cal | 1014068_0.cal | 1059767_0.cal | 1231398_0.cal | 1381270_0.cal | 1720333_0.cal | 1867252_0.cal | 2126124_0.cal | 2007883_0.cal | 1996451_0.cal | 2116827_0.cal | 2100265_0.cal | 2062677_0.cal | 2037058_0.cal | 1962082_0.cal | 2171678_0.cal | 2156716_0.cal | 2116827_1.cal | 2321264_0.cal | 2350569_0.cal | 2293047_0.cal | 2441194_0.cal | 334736.cal | 2397077_0.cal | 2191514_0.cal | 2382085_0.cal | 2487473_0.cal | 2354956_0.cal | 334749.cal | 2206870_0.cal | 2417604_0.cal | 2471186_0.cal | 2271360_0.cal | 2240171_0.cal | 2552249_0.cal | 2531341_0.cal | ||||||||||||||||||||||||||||||||||||||||||
received_date | 2003-04-01 00:00:00 | 2003-04-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-31 00:00:00 | 2003-10-31 00:00:00 | 2004-02-02 00:00:00 | 2004-08-02 00:00:00 | 2004-04-30 00:00:00 | 2004-11-02 00:00:00 | 2007-01-24 00:00:00 | 2008-11-11 00:00:00 | 2012-12-26 00:00:00 | 2014-07-28 00:00:00 | 2017-01-28 00:00:00 | 2016-01-27 00:00:00 | 2015-10-29 00:00:00 | 2017-01-03 00:00:00 | 2016-10-29 00:00:00 | 2016-07-30 00:00:00 | 2016-05-01 00:00:00 | 2015-04-25 00:00:00 | 2017-07-26 00:00:00 | 2017-04-30 00:00:00 | 2017-07-10 00:00:00 | 2018-10-31 00:00:00 | 2019-01-31 00:00:00 | 2018-09-18 00:00:00 | 2020-01-30 00:00:00 | 2018-09-18 00:00:00 | 2019-07-30 00:00:00 | 2017-10-29 00:00:00 | 2019-04-30 00:00:00 | 2020-07-31 00:00:00 | 2019-02-05 00:00:00 | 2018-09-18 00:00:00 | 2018-01-27 00:00:00 | 2019-10-30 00:00:00 | 2020-04-30 00:00:00 | 2018-07-28 00:00:00 | 2018-04-28 00:00:00 | 2021-01-31 00:00:00 | 2020-11-02 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||
filing_directory | /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/temp | /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 | ||||||||||||||||||||||||||||||||||||||||||
filing_id | 926150 | 932006 | 931266 | 947680 | 969626 | 990303 | 1032203 | 1014068 | 1059767 | 1231398 | 1381270 | 1720333 | 1867252 | 2126124 | 2007883 | 1996451 | 2116827 | 2100265 | 2062677 | 2037058 | 1962082 | 2171678 | 2156716 | 2116827 | 2321264 | 2350569 | 2293047 | 2441194 | None | 2397077 | 2191514 | 2382085 | 2487473 | 2354956 | None | 2206870 | 2417604 | 2471186 | 2271360 | 2240171 | 2552249 | 2531341 | ||||||||||||||||||||||||||||||||||||||||||
form_id | F604 | F615 | F606 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | None | F615 | F615 | F615 | F615 | F604 | None | F615 | F615 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | 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 passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |