| filing_id | 1765792 | 1783892 | 1801218 | 1873020 | 1845584 | 1819103 | 1912675 | 1983131 | 1966374 | 1937664 | 1998350 | 2064895 | 2038664 | 2013140 | 2102769 | 2157993 | 2131522 | 2177127 | 2277249 | 2212271 | 2194392 | 2242978 | 2321245 | 2381553 | 2350821 | 2443880 | 2400017 | 2420170 | 2471544 | 2555073 | 2487984 | 2532047 | 2625310 | 2580710 | 2603759 | 2580710 | 2625310 | 2645056 | 2678364 | 2603759 | 2708479 | 2645056 | 2749114 | |||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 1 | 1 | 1 | 0 | 1 | 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 | |||||||||||||||||||||||||||||||||||||||||||
| form_type | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | |||||||||||||||||||||||||||||||||||||||||||
| sender_id | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | |||||||||||||||||||||||||||||||||||||||||||
| filer_id | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | |||||||||||||||||||||||||||||||||||||||||||
| entity_cd | 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 | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | |||||||||||||||||||||||||||||||||||||||||||
| filer_naml | Churchwell White LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | |||||||||||||||||||||||||||||||||||||||||||
| filer_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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | 001 | 001 | 001 | 000 | 001 | 000 | 000 | 000 | |||||||||||||||||||||||||||||||||||||||||||
| rpt_date | 2013-04-30 00:00:00 | 2013-07-31 00:00:00 | 2013-10-31 00:00:00 | 2014-07-31 00:00:00 | 2014-04-30 00:00:00 | 2014-01-31 00:00:00 | 2014-10-31 00:00:00 | 2015-07-31 00:00:00 | 2015-04-30 00:00:00 | 2015-02-02 00:00:00 | 2015-11-02 00:00:00 | 2016-08-01 00:00:00 | 2016-05-02 00:00:00 | 2016-02-01 00:00:00 | 2016-10-31 00:00:00 | 2017-05-01 00:00:00 | 2017-01-31 00:00:00 | 2017-07-31 00:00:00 | 2018-07-31 00:00:00 | 2018-01-31 00:00:00 | 2017-10-31 00:00:00 | 2018-04-30 00:00:00 | 2018-10-31 00:00:00 | 2019-04-30 00:00:00 | 2019-01-31 00:00:00 | 2020-01-31 00:00:00 | 2019-07-31 00:00:00 | 2019-10-31 00:00:00 | 2020-04-30 00:00:00 | 2021-02-01 00:00:00 | 2020-07-31 00:00:00 | 2020-11-02 00:00:00 | 2021-11-01 00:00:00 | 2021-04-30 00:00:00 | 2021-08-02 00:00:00 | 2022-05-02 00:00:00 | 2022-05-02 00:00:00 | 2022-05-02 00:00:00 | 2022-05-02 00:00:00 | 2022-05-02 00:00:00 | 2022-08-01 00:00:00 | 2022-01-31 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||
| from_date | 2013-01-01 00:00:00 | 2013-04-01 00:00:00 | 2013-07-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2013-10-01 00:00:00 | 2014-07-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-10-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-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-04-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-10-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||
| thru_date | 2013-01-31 00:00:00 | 2013-06-30 00:00:00 | 2013-09-30 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2013-12-31 00:00:00 | 2014-09-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-12-31 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-03-31 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-06-30 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||
| cum_beg_dt | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||
| firm_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 | |||||||||||||||||||||||||||||||||||||||||||
| firm_name | Churchwell White LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | ChurchwellWhite LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner LLP | White Brenner 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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| firm_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 | |||||||||||||||||||||||||||||||||||||||||||
| firm_phon | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | 916 468-0950 | |||||||||||||||||||||||||||||||||||||||||||
| mail_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | |||||||||||||||||||||||||||||||||||||||||||
| sig_date | 2013-04-26 00:00:00 | 2013-07-26 00:00:00 | 2013-10-28 00:00:00 | 2014-07-25 00:00:00 | 2014-04-25 00:00:00 | 2014-01-24 00:00:00 | 2014-10-30 00:00:00 | 2015-07-24 00:00:00 | 2015-04-28 00:00:00 | 2015-01-27 00:00:00 | 2015-10-28 00:00:00 | 2016-07-29 00:00:00 | 2016-04-29 00:00:00 | 2016-01-26 00:00:00 | 2016-10-24 00:00:00 | 2017-04-24 00:00:00 | 2017-01-19 00:00:00 | 2017-07-25 00:00:00 | 2018-07-30 00:00:00 | 2018-01-26 00:00:00 | 2017-10-27 00:00:00 | 2018-04-30 00:00:00 | 2018-10-29 00:00:00 | 2019-04-26 00:00:00 | 2019-01-30 00:00:00 | 2020-01-29 00:00:00 | 2019-07-22 00:00:00 | 2019-10-31 00:00:00 | 2020-04-22 00:00:00 | 2021-01-28 00:00:00 | 2020-07-29 00:00:00 | 2020-10-31 00:00:00 | 2021-10-26 00:00:00 | 2021-04-27 00:00:00 | 2021-07-30 00:00:00 | 2022-04-29 00:00:00 | 2022-04-29 00:00:00 | 2022-04-29 00:00:00 | 2022-04-29 00:00:00 | 2022-04-29 00:00:00 | 2022-08-01 00:00:00 | 2022-01-26 00:00:00 | 2022-10-31 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 | 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 | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | |||||||||||||||||||||||||||||||||||||||||||
| sig_namf | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| prn_naml | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | White | |||||||||||||||||||||||||||||||||||||||||||
| prn_namf | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | Doug | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| sig_title | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | |||||||||||||||||||||||||||||||||||||||||||
| nopart1_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 | |||||||||||||||||||||||||||||||||||||||||||
| nopart2_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 | |||||||||||||||||||||||||||||||||||||||||||
| part1_1_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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| ctrib_n_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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| lobby_n_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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 |
| filing_id | 1922423 | 2329425 | 2541750 | |||
|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | |||
| rec_type | CVR | CVR | CVR | |||
| form_type | F601 | F601 | F601 | |||
| sender_id | 1357171 | 1357171 | 1357171 | |||
| filer_id | 1357171 | 1357171 | 1357171 | |||
| entity_cd | FRM | FRM | FRM | |||
| filer_naml | Churchwell White LLP | CHURCHWELL WHITE LLP | Churchwell White LLP | |||
| filer_namf | None | None | None | |||
| filer_namt | None | None | None | |||
| filer_nams | None | None | None | |||
| report_num | 000 | 000 | 000 | |||
| rpt_date | 2014-12-29 00:00:00 | 2018-12-21 00:00:00 | 2020-12-31 00:00:00 | |||
| ls_beg_yr | 2015 | 2019 | 2021 | |||
| ls_end_yr | 2016 | 2020 | 2022 | |||
| qual_date | 2015-01-01 00:00:00 | None | None | |||
| eff_date | None | None | None | |||
| bus_city | Sacramento | SACRAMENTO | Sacramento | |||
| bus_st | CA | CA | CA | |||
| bus_zip4 | 95814 | 95814 | 95814 | |||
| bus_phon | 916 - 468-0950 | 9164680950 | 916 - 468-0950 | |||
| bus_fax | None | None | None | |||
| bus_email | [email protected] | [email protected] | [email protected] | |||
| mail_city | None | Sacramento | None | |||
| mail_st | None | CA | None | |||
| mail_zip4 | None | 95814 | None | |||
| mail_phon | None | None | None | |||
| sig_date | 2014-12-26 00:00:00 | 2018-12-21 00:00:00 | 2020-12-23 00:00:00 | |||
| sig_loc | Sacramento, CA | None | Sacramento, CA | |||
| sig_naml | White | White | White | |||
| sig_namf | Douglas L. | Doug | Douglas L. | |||
| sig_namt | None | None | None | |||
| sig_nams | None | None | None | |||
| prn_naml | White | White | White | |||
| prn_namf | Douglas L. | Doug | Douglas L. | |||
| prn_namt | None | None | None | |||
| prn_nams | None | None | None | |||
| sig_title | Partner | Managing Partner | Managing Partner | |||
| stmt_firm | Churchwell White LLP | Churchwell White LLP | Churchwell White LLP | |||
| ind_cb | None | None | None | |||
| bus_cb | None | None | None | |||
| trade_cb | None | None | None | |||
| oth_cb | None | None | None | |||
| a_b_name | None | None | None | |||
| a_b_city | None | None | None | |||
| a_b_st | None | None | None | |||
| a_b_zip4 | None | None | None | |||
| descrip_1 | None | None | None | |||
| descrip_2 | None | None | None | |||
| c_less50 | None | None | None | |||
| c_more50 | None | None | None | |||
| ind_class | None | None | None | |||
| ind_descr | None | None | None | |||
| bus_class | None | None | None | |||
| bus_descr | None | None | None | |||
| auth_name | None | None | None | |||
| auth_city | None | None | None | |||
| auth_st | None | None | None | |||
| auth_zip4 | None | None | None | |||
| lobby_int | None | None | None | |||
| influen_yn | None | None | None | |||
| firm_name | None | None | None | |||
| newcert_cb | None | None | None | |||
| rencert_cb | None | None | None | |||
| complet_dt | None | None | None | |||
| lby_reg_cb | None | None | None | |||
| lby_604_cb | None | None | None | |||
| st_leg_yn | None | None | None | |||
| st_agency | None | None | None | |||
| lobby_cb | None | None | None | |||
| l_firm_cb | None | None | None |
| filer_id | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| adrid | 2412350 | 2544608 | 2465097 | 2286765 | 2337227 | 2504765 | 2361757 | |||||||
| effect_dt | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | 2019-01-01 00:00:00 | 2013-02-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-03-02 00:00:00 | |||||||
| add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||
| session_id | 2017 | 2023 | 2019 | 2013 | 2015 | 2021 | 2015 |
| filer_id | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 1783892 | 1967069 | 1970101 | 1974225 | 1859307 | 1806983 | 1806985 | 1806987 | 1801218 | 1958916 | 1937664 | 1922423 | 1912675 | 1873020 | 1845584 | 1819103 | 1765792 | 1761554 | 1970103 | 1998350 | 1983131 | 1966374 | 2404730 | 2404731 | 2404732 | 2321245 | 2228479 | 2244445 | 2277249 | 2194392 | 2381553 | 2212271 | 2443880 | 2017690 | 2017695 | 2026386 | 2013140 | 2038664 | 2039488 | 2052288 | 2054214 | 2064895 | 2067581 | 2054730 | 2102769 | 2108537 | 2145727 | 2131522 | 2142227 | 2142236 | 2153901 | 2177127 | 2157993 | 2161795 | 2166926 | 2350821 | 2532047 | 2329425 | 2555073 | 2181296 | 2360722 | 2223831 | 2471544 | 2400017 | 2487984 | 2242978 | 2420170 | 2580710 | 2603759 | 2580710 | 2625310 | 2645056 | 2678364 | 2488749 | 2708479 | 2541750 | 2660766 | 2625310 | 2630769 | 2603759 | 2695503 | 2570200 | 2645056 | 2749114 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| period_id | 214 | None | None | None | None | None | None | None | 215 | None | 220 | 220 | 219 | 218 | 217 | 216 | 213 | None | None | 223 | 222 | 221 | None | None | None | 235 | None | None | 234 | 231 | 237 | 232 | 240 | None | None | None | 224 | 225 | None | None | None | 226 | None | None | 227 | None | None | 228 | None | None | None | 230 | 229 | None | None | 236 | 243 | 236 | 244 | None | None | None | 241 | 238 | 242 | 233 | 239 | 245 | 246 | 245 | 247 | 248 | 249 | None | 250 | 244 | None | 247 | None | 246 | None | None | 248 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F625 | F605 | F605 | F605 | F605 | F605 | F605 | F605 | F625 | F601 | F625 | F601 | F625 | F625 | F625 | F625 | F625 | F601 | F605 | F625 | F625 | F625 | F605 | F605 | F605 | F625 | F605 | F605 | F625 | F625 | F625 | F625 | F625 | F605 | F605 | F605 | F625 | F625 | F605 | F605 | F605 | F625 | F605 | F605 | F625 | F605 | F605 | F625 | F601 | F605 | F605 | F625 | F625 | F605 | F605 | F625 | F625 | F601 | F625 | F605 | F601 | F605 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F605 | F625 | F601 | F605 | F625 | F605 | F625 | F605 | F601 | F625 | F625 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_date | 2013-07-31 00:00:00 | 2015-05-01 00:00:00 | 2015-05-14 00:00:00 | 2015-07-10 00:00:00 | 2014-06-03 00:00:00 | 2013-12-09 00:00:00 | 2013-12-09 00:00:00 | 2013-12-09 00:00:00 | 2013-10-31 00:00:00 | 2015-01-22 00:00:00 | 2015-02-02 00:00:00 | 2014-12-31 00:00:00 | 2014-10-31 00:00:00 | 2014-07-31 00:00:00 | 2014-04-30 00:00:00 | 2014-01-31 00:00:00 | 2013-04-30 00:00:00 | 2013-03-06 00:00:00 | 2015-04-09 00:00:00 | 2015-11-02 00:00:00 | 2015-07-31 00:00:00 | 2015-04-30 00:00:00 | 2019-07-08 00:00:00 | 2019-07-08 00:00:00 | 2019-07-08 00:00:00 | 2018-10-31 00:00:00 | 2018-04-04 00:00:00 | 2018-05-01 00:00:00 | 2018-07-31 00:00:00 | 2017-10-31 00:00:00 | 2019-04-30 00:00:00 | 2018-01-31 00:00:00 | 2020-01-31 00:00:00 | 2016-01-26 00:00:00 | 2016-01-26 00:00:00 | 2016-03-17 00:00:00 | 2016-02-01 00:00:00 | 2016-05-02 00:00:00 | 2016-05-03 00:00:00 | 2016-06-20 00:00:00 | 2016-07-07 00:00:00 | 2016-08-01 00:00:00 | 2016-08-10 00:00:00 | 2016-07-12 00:00:00 | 2016-10-31 00:00:00 | 2016-11-22 00:00:00 | 2017-03-03 00:00:00 | 2017-01-31 00:00:00 | 2016-12-30 00:00:00 | 2017-01-11 00:00:00 | 2017-03-16 00:00:00 | 2017-07-31 00:00:00 | 2017-05-01 00:00:00 | 2017-05-10 00:00:00 | 2017-07-12 00:00:00 | 2019-01-31 00:00:00 | 2020-11-02 00:00:00 | 2018-12-21 00:00:00 | 2021-02-01 00:00:00 | 2017-08-18 00:00:00 | 2018-12-28 00:00:00 | 2018-03-20 00:00:00 | 2020-04-30 00:00:00 | 2019-07-31 00:00:00 | 2020-07-31 00:00:00 | 2018-04-30 00:00:00 | 2019-10-31 00:00:00 | 2021-04-30 00:00:00 | 2021-08-02 00:00:00 | 2022-05-02 00:00:00 | 2022-05-02 00:00:00 | 2022-05-02 00:00:00 | 2022-05-02 00:00:00 | 2020-07-27 00:00:00 | 2022-08-01 00:00:00 | 2020-12-31 00:00:00 | 2022-03-17 00:00:00 | 2021-11-01 00:00:00 | 2021-11-23 00:00:00 | 2022-05-02 00:00:00 | 2022-06-08 00:00:00 | 2020-12-30 00:00:00 | 2022-01-31 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_type | 10001 | 10005 | 10006 | 10006 | 10006 | 10006 | 10006 | 10006 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10006 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10006 | 10001 | 10005 | 10006 | 10006 | 10001 | 10001 | 10006 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10002 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10002 | 10002 | 10005 | 10005 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| session_id | 2013 | 2015 | 2015 | 2015 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2013 | 2015 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2019 | 2019 | 2019 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| user_id | ASAETERN | SARRIAGA | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | ASAETERN | SARRIAGA | AGLADNEY | SARRIAGA | ASAETERN | ASAETERN | ASAETERN | ASAETERN | ASAETERN | SARRIAGA | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | GPEREZ | GPEREZ | AGLADNEY | GPEREZ | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | YRODRIGU | GPEREZ | AGLADNEY | AGLADNEY | GPEREZ | GPEREZ | GPEREZ | AGLADNEY | GPEREZ | GPEREZ | AGLADNEY | GPEREZ | YRODRIGU | AGLADNEY | YRODRIGU | YRODRIGU | YRODRIGU | AGLADNEY | AGLADNEY | YRODRIGU | GPEREZ | AGLADNEY | MKIRKHAM | GPEREZ | MKIRKHAM | GPEREZ | DMCCASTL | GPEREZ | MKIRKHAM | AGLADNEY | MKIRKHAM | AGLADNEY | AGLADNEY | MKIRKHAM | CHATRIDGE | CAFILER | CHATRIDGE | MKIRKHAM | CAFILER | GPEREZ | CAFILER | CVANLIEW | MMERCHANT | CHATRIDGE | CVANLIEW | CAFILER | CVANLIEW | CVANLIEW | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| fine_audit | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_start | 2013-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-07-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-29 00:00:00 | 2014-07-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2013-10-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 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-04-01 00:00:00 | 2017-07-01 00:00:00 | 2019-01-01 00:00:00 | 2017-10-01 00:00:00 | 2019-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-01 00:00:00 | 2020-07-01 00:00:00 | 2018-12-21 00:00:00 | 2020-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-01-01 00:00:00 | 2019-04-01 00:00:00 | 2020-04-01 00:00:00 | 2018-01-01 00:00:00 | 2019-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-04-01 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_end | 2013-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-09-30 00:00:00 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2014-12-29 00:00:00 | 2014-09-30 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2013-12-31 00:00:00 | 2013-01-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-09-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-06-30 00:00:00 | 2017-09-30 00:00:00 | 2019-03-31 00:00:00 | 2017-12-31 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2020-09-30 00:00:00 | 2018-12-21 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-03-31 00:00:00 | 2019-06-30 00:00:00 | 2020-06-30 00:00:00 | 2018-03-31 00:00:00 | 2019-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 1900-01-01 00:00:00 | 2022-06-30 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2021-09-30 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_type | 22001 | None | None | None | None | None | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | None | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | None | None | None | 22001 | None | None | 22001 | None | None | 22001 | None | None | None | 22001 | 22001 | None | None | 22001 | 22001 | 22006 | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | None | 22001 | None | None | 22001 | 22001 |
| filer_id | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_type | 3 | 3 | 3 | 3 | 3 | 3 | ||||||
| active | Y | Y | Y | Y | Y | N | ||||||
| race | 0 | None | None | None | None | None | ||||||
| session_id | 2013 | 2015 | 2021 | 2017 | 2019 | 2023 | ||||||
| category | 0 | None | None | None | None | None | ||||||
| category_type | 0 | None | None | None | None | None | ||||||
| sub_category | 0 | None | None | None | None | None | ||||||
| effect_dt | 2013-02-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||
| sub_category_type | 0 | None | None | None | None | None | ||||||
| election_type | 0 | None | None | None | None | None | ||||||
| sub_category_a | None | None | None | None | None | None | ||||||
| nyq_dt | None | None | None | None | None | None | ||||||
| party_cd | 0 | None | None | None | None | None | ||||||
| county_cd | 0 | None | None | None | None | None | ||||||
| district_cd | 0 | None | None | None | None | None |
| filer_id | 1357171 | |
|---|---|---|
| xref_id | 1357171 | |
| effect_dt | 2013-04-24 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | |||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | |||||||||||||||||||||||||||||||||||||||||||||||||
| filer_type | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| naml | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | WHITE BRENNER LLP | WHITE BRENNER LLP | WHITE BRENNER LLP | WHITE BRENNER LLP | WHITE BRENNER LLP | WHITE BRENNER LLP | WHITE BRENNER LLP | WHITE BRENNER LLP | WHITE BRENNER LLP | WHITE BRENNER LLP | WHITE BRENNER LLP | WHITE BRENNER LLP | WHITE BRENNER LLP | WHITE BRENNER LLP | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| phon | 9164680950 | 9164680950 | 9164680950 | 9164680621 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680621 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680621 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680621 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680621 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680621 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680621 | 9164680950 | 9164680950 | 9164680950 | |||||||||||||||||||||||||||||||||||||||||||||||||
| fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||
| [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] |
| filer_id | 1357171 |
|---|
| filer_id | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | ||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| change_no | 5 | 6 | 1 | 0 | 2 | 3 | 4 | 7 | 8 | 9 | 10 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 12 | 13 | 11 | 36 | 34 | 27 | 29 | 28 | 22 | 23 | 24 | 25 | 26 | 30 | 33 | 32 | 35 | 31 | 37 | 38 | 39 | 41 | 40 | 42 | 44 | 45 | 46 | 43 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||
| session_id | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2013 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | ||||||||||||||||||||||||||||||||||||||||||||||||
| log_dt | 2013-03-06 00:00:00 | 2013-03-06 00:00:00 | 2013-03-06 00:00:00 | 2013-03-06 00:00:00 | 2013-03-06 00:00:00 | 2013-03-06 00:00:00 | 2013-03-06 00:00:00 | 2013-03-06 00:00:00 | 2013-12-09 00:00:00 | 2013-12-09 00:00:00 | 2013-12-09 00:00:00 | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | 2014-06-03 00:00:00 | 2016-11-22 00:00:00 | 2016-08-10 00:00:00 | 2015-06-29 00:00:00 | 2015-07-10 00:00:00 | 2015-06-29 00:00:00 | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | 2016-01-26 00:00:00 | 2016-07-12 00:00:00 | 2016-03-17 00:00:00 | 2016-05-03 00:00:00 | 2016-01-26 00:00:00 | 2017-03-16 00:00:00 | 2017-07-12 00:00:00 | 2017-05-10 00:00:00 | 2018-04-04 00:00:00 | 2017-08-18 00:00:00 | 2018-05-01 00:00:00 | 2019-07-08 00:00:00 | 2019-07-08 00:00:00 | 2019-07-08 00:00:00 | 2018-03-20 00:00:00 | 2020-07-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| filer_type | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||
| correction_flg | None | None | None | None | None | None | None | None | None | None | None | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | None | None | None | Y | Y | Y | Y | Y | Y | Y | Y | Y | None | Y | Y | Y | Y | Y | Y | None | Y | Y | None | None | None | Y | None | ||||||||||||||||||||||||||||||||||||||||||||||||
| action | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | DELETED | DELETED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | DELETED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | DELETED | DELETED | DELETED | DELETED | DELETED | DELETED | ADDED | DELETED | ||||||||||||||||||||||||||||||||||||||||||||||||
| attribute_changed | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | LOBBYIST | CLIENT | LOBBYIST | LOBBYIST | EMPLOYER | EMPLOYER | EMPLOYER | LOBBYIST | LOBBYIST | LOBBYIST | EMPLOYER | EMPLOYER | LOBBYIST | CLIENT | EMPLOYER | / FIRM | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | CLIENT | EMPLOYER | EMPLOYER | CLIENT | CLIENT | LOBBYIST | EMPLOYER | CLIENT | ||||||||||||||||||||||||||||||||||||||||||||||||
| ethics_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 | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||
| interests | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_full_name | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | CHURCHWELL WHITE LLP | ||||||||||||||||||||||||||||||||||||||||||||||||
| filer_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | SACRAMENTO | None | None | None | None | None | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | None | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | None | SACRAMENTO | None | None | None | None | None | None | SACRAMENTO | None | ||||||||||||||||||||||||||||||||||||||||||||||||
| filer_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | CA | None | None | None | None | None | CA | CA | CA | CA | CA | CA | CA | CA | CA | None | CA | CA | CA | CA | None | CA | None | None | None | None | None | None | CA | None | ||||||||||||||||||||||||||||||||||||||||||||||||
| filer_zip | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 95814 | None | None | None | None | None | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | None | 95814 | 95814 | 95814 | 95814 | None | 95814 | None | None | None | None | None | None | 95814 | None | ||||||||||||||||||||||||||||||||||||||||||||||||
| filer_phone | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 9164680950 | None | None | None | None | None | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | 9164680950 | None | 9164680950 | 9164680950 | 9164680950 | 9164680950 | None | 9164680950 | None | None | None | None | None | None | 9164680621 | None | ||||||||||||||||||||||||||||||||||||||||||||||||
| entity_type | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 1 | 4 | 4 | 2 | 2 | 2 | 4 | 4 | 4 | 2 | 2 | 4 | 1 | 2 | 1 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 1 | 1 | 4 | 2 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||
| entity_name | INTERNATIONAL FRANCHISE ASSOCIATION | RECKITT BENCKISER, INC. | ALTICOR, INC. | AMERICAN CHEMISTRY COUNCIL | CALIFORNIA SELF STORAGE | CARPET & RUG INSTITUTE | DIRECT SELLING ASSOCIATION | TRANSUNION, LLC | ACXIOM CORPORATION | COUNCIL OF COLLEGES OF ACUPUNCTURE AND ORIENTAL MEDICINE | HERBALIFE INTERNATIONAL OF AMERICA, INC. | ALTICOR, INC. | ACXIOM CORPORATION | TRANSUNION, LLC | RECKITT BENCKISER, INC. | AMERICAN CHEMISTRY COUNCIL | CARPET & RUG INSTITUTE; THE | DIRECT SELLING ASSOCIATION | INTERNATIONAL FRANCHISE ASSOCIATION | CERES; CITY OF | GOLDSTEIN, NUBIA ISABEL | MASSAGE ENVY FRANCHISING, LLC | CELIA MATA | MUSTAFA HESSABI | JUVENILE PRODUCTS MANUFACTURERS ASSOCIATION | MICRO POWDERS, INC. | LIGHTER ASSOCIATION, INC. | HESSABI, MUSTAFA | POLLACK, RANDY | WHITE, ELISABETH | HOME INSTEAD, INC. | DIXON; CITY OF | MATA, CELIA | MICRO POWDERS, INC. | DURACELL COMPANY | CAL CONNECTED LLC | COUNCIL OF COLLEGES OF ACUPUNCTURE AND ORIENTAL MEDICINE | LIGHTER ASSOCIATION, INC. | SUNSHINE HEALTH FREEDOM FOUNDATION | CONSUMER DATA INDUSTRY ASSOCIATION | SUNSHINE HEALTH FREEDOM FOUNDATION | DIRECT SELLING ASSOCIATION | TRANSUNION, LLC | BIOENERGY ASSOCIATION OF CALIFORNIA | CALIFORNIA NATURAL GAS VEHICLE COALITION | JOSIAH M. YOUNG | CALIFORNIA GROUNDWATER ASSOCIATION | LIVERAMP | ||||||||||||||||||||||||||||||||||||||||||||||||
| entity_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||
| entity_id | 1143798 | 1144421 | 1338846 | 1142931 | 1316766 | 1257617 | 1144437 | 1144978 | 1146595 | 1243850 | 1358435 | 1338846 | 1146595 | 1144978 | 1144421 | 1142931 | 1257617 | 1144437 | 0 | 0 | 1357172 | 1367412 | 1383271 | 1376384 | None | None | None | None | None | None | None | None | None | 1378237 | None | None | None | None | 1397589 | None | 1397589 | 1144437 | 1144978 | 1417661 | 1147072 | 1386346 | None | 1414884 | ||||||||||||||||||||||||||||||||||||||||||||||||
| responsible_officer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||
| effect_dt | 2013-02-01 00:00:00 | 2013-02-01 00:00:00 | 2013-02-01 00:00:00 | 2013-02-01 00:00:00 | 2013-02-01 00:00:00 | 2013-02-01 00:00:00 | 2013-02-01 00:00:00 | 2013-02-01 00:00:00 | 2013-05-08 00:00:00 | 2013-05-08 00:00:00 | 2013-05-08 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2014-05-08 00:00:00 | 2016-10-07 00:00:00 | 2016-08-02 00:00:00 | 2015-05-07 00:00:00 | 2015-06-02 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-06-30 00:00:00 | 2016-03-01 00:00:00 | 2016-04-15 00:00:00 | 2016-01-11 00:00:00 | 2017-04-01 00:00:00 | 2017-07-02 00:00:00 | 2017-05-01 00:00:00 | 2018-03-31 00:00:00 | 2017-06-30 00:00:00 | 2018-03-31 00:00:00 | 2019-06-28 00:00:00 | 2019-06-28 00:00:00 | 2019-06-28 00:00:00 | 2018-03-01 00:00:00 | 2020-03-31 00:00:00 |
| filer_id | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | 1357171 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 350430.cal | 350761.cal | 351349.cal | 196943.cal | 197016.cal | 210652.cal | 2329425_0.cal | 196870.cal | 211172.cal | 108293.cal | 2541750_0.cal | |||||||||||
| received_date | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2018-12-26 00:00:00 | 2018-12-26 00:00:00 | 2018-12-27 00:00:00 | 2018-12-21 00:00:00 | 2018-12-26 00:00:00 | 2018-12-27 00:00:00 | 2021-04-30 00:00:00 | 2020-12-31 00:00:00 | |||||||||||
| filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | |||||||||||
| filing_id | None | None | None | None | None | None | 2329425 | None | None | None | 2541750 | |||||||||||
| form_id | None | None | None | None | None | None | F601 | None | None | None | F601 | |||||||||||
| receive_comment | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted |