| filing_id | 1708108 | 1675545 | 1738078 | 1795933 | 1761356 | 1777790 | 1811869 | 1865630 | 1839454 | 1930999 | 1909337 | 1980748 | 1993058 | 1964164 | 2007171 | 2059207 | 2030822 | 2098738 | 2171997 | 2171998 | 2153998 | 2127461 | 2191570 | 2207042 | 2272907 | 2242213 | 2349198 | 2320130 | 2382006 | 2400102 | 2439133 | 2419478 | 2471722 | 2552502 | 2528886 | 2487013 | 2623040 | 2601240 | 2623040 | 2580549 | 2674889 | 2639126 | 2705199 | 2748330 | ||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 1 | 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| sender_id | 1347282 | 1347282 | 1347282 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | 1412920 | F24529 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | ||||||||||||||||||||||||||||||||||||||||||||
| filer_id | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | ||||||||||||||||||||||||||||||||||||||||||||
| entity_cd | FRM | FRM | 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 | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | ||||||||||||||||||||||||||||||||||||||||||||
| filer_naml | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | ||||||||||||||||||||||||||||||||||||||||||||
| filer_namf | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | 001 | 000 | 000 | 000 | 000 | 000 | ||||||||||||||||||||||||||||||||||||||||||||
| rpt_date | 2012-10-30 00:00:00 | 2012-07-27 00:00:00 | 2013-01-31 00:00:00 | 2013-10-21 00:00:00 | 2013-04-24 00:00:00 | 2013-07-31 00:00:00 | 2014-01-31 00:00:00 | 2014-07-31 00:00:00 | 2014-04-30 00:00:00 | 2015-01-25 00:00:00 | 2014-10-30 00:00:00 | 2015-07-30 00:00:00 | 2015-10-27 00:00:00 | 2015-04-27 00:00:00 | 2016-01-29 00:00:00 | 2016-07-29 00:00:00 | 2016-04-21 00:00:00 | 2016-10-28 00:00:00 | 2017-07-28 00:00:00 | 2017-07-28 00:00:00 | 2017-04-26 00:00:00 | 2017-01-31 00:00:00 | 2017-10-31 00:00:00 | 2018-01-28 00:00:00 | 2018-07-31 00:00:00 | 2018-04-30 00:00:00 | 2019-01-31 00:00:00 | 2018-10-31 00:00:00 | 2019-04-18 00:00:00 | 2019-07-31 00:00:00 | 2020-01-27 00:00:00 | 2019-10-21 00:00:00 | 2020-04-15 00:00:00 | 2021-01-21 00:00:00 | 2020-07-21 00:00:00 | 2020-07-21 00:00:00 | 2021-10-31 00:00:00 | 2021-07-30 00:00:00 | 2021-10-31 00:00:00 | 2021-04-30 00:00:00 | 2022-04-30 00:00:00 | 2022-01-30 00:00:00 | 2022-07-31 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||
| from_date | 2012-07-01 00:00:00 | 2012-04-01 00:00:00 | 2012-10-01 00:00:00 | 2013-07-01 00:00:00 | 2013-01-01 00:00:00 | 2013-04-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-04-01 00:00:00 | 2015-07-01 00:00:00 | 2015-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2016-07-01 00:00:00 | 2017-04-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 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2019-04-01 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||
| thru_date | 2012-09-30 00:00:00 | 2012-06-30 00:00:00 | 2012-12-31 00:00:00 | 2013-09-30 00:00:00 | 2013-03-31 00:00:00 | 2013-06-30 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-06-30 00:00:00 | 2015-09-30 00:00:00 | 2015-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2016-09-30 00:00:00 | 2017-06-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 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2019-06-30 00:00:00 | 2019-12-31 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2022-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 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 | None | ||||||||||||||||||||||||||||||||||||||||||||
| firm_id | 1347282 | 1347282 | 1347282 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | 1412920 | F24529 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | ||||||||||||||||||||||||||||||||||||||||||||
| firm_name | Conservation Strategy Group LLC | Conservation Strategy Group | Conservation Strategy Group | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | Pacific Policy Group | CONSERVATION STRATEGY GROUP LLC | Pacific Policy Group | Pacific Policy Group | Pacific Policy Group | Pacific Policy Group | Pacific Policy Group | Pacific Policy Group | Pacific Policy Group | Pacific Policy Group | Pacific Policy Group | Pacific Policy Group | Pacific Policy Group | Pacific Policy Group | Pacific Policy Group | Pacific Policy Group | Pacific Policy Group | Pacific Policy Group | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | 95822 | 95814 | 95822 | 95822 | 95822 | 95822 | 95822 | 95822 | 95822 | 95822 | 95822 | 95822 | 95814 | 95822 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||
| firm_phon | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9167988088 | 9165581516 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | 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 | 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||
| sig_date | 2012-10-30 00:00:00 | 2012-07-27 00:00:00 | 2013-01-27 00:00:00 | 2013-10-21 00:00:00 | 2013-04-24 00:00:00 | 2013-07-24 00:00:00 | 2014-01-31 00:00:00 | 2014-07-31 00:00:00 | 2014-04-18 00:00:00 | 2015-01-27 00:00:00 | 2014-10-30 00:00:00 | 2015-07-30 00:00:00 | 2015-10-21 00:00:00 | 2015-04-29 00:00:00 | 2016-01-26 00:00:00 | 2016-07-27 00:00:00 | 2016-04-21 00:00:00 | 2016-10-27 00:00:00 | 2017-07-26 00:00:00 | 2017-07-26 00:00:00 | 2017-04-26 00:00:00 | 2017-01-30 00:00:00 | 2017-10-29 00:00:00 | 2018-01-28 00:00:00 | 2018-07-30 00:00:00 | 2018-04-30 00:00:00 | 2019-01-30 00:00:00 | 2018-10-31 00:00:00 | 2019-04-30 00:00:00 | 2019-07-31 00:00:00 | 2020-01-29 00:00:00 | 2019-10-31 00:00:00 | 2020-04-30 00:00:00 | 2021-01-31 00:00:00 | 2020-10-31 00:00:00 | 2020-07-27 00:00:00 | 2021-10-29 00:00:00 | 2021-07-30 00:00:00 | 2021-10-29 00:00:00 | 2021-04-30 00:00:00 | 2022-04-29 00:00:00 | 2022-01-27 00:00:00 | 2022-07-30 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 | 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 | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | FENSTERMAKER | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | ||||||||||||||||||||||||||||||||||||||||||||
| sig_namf | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | MARK | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | ||||||||||||||||||||||||||||||||||||||||||||
| sig_namt | None | None | None | None | None | None | None | None | None | MR. | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | MR. | MR. | MR. | MR. | MR. | MR. | MR. | MR. | 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 | ||||||||||||||||||||||||||||||||||||||||||||
| prn_naml | Fenstermaker | Fenstermaker | Fenstermaker | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_namf | Mark | Mark | Mark | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| sig_title | Legislative Assistant | Legislative Assistant | Legislative Assistant | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 |
| filing_id | 1668838 | 1717915 | 1919383 | 1919383 | 2113090 | 2113090 | 2305296 | 2310680 | 2328235 | 2328235 | 2542945 | 2542945 | 2542945 | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 2 | |||||||||||||
| rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||||
| form_type | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | |||||||||||||
| sender_id | F24529 | F24529 | F24529 | F24529 | F24529 | F24529 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | 1412920 | |||||||||||||
| filer_id | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | |||||||||||||
| entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | |||||||||||||
| filer_naml | FENSTERMAKER | FENSTERMAKER | Fenstermaker | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | GROUP | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | FENSTERMAKER | |||||||||||||
| filer_namf | MARK | MARK | Mark | MARK | MARK | MARK | PACIFIC | Mark | Mark | Mark | Mark | Mark | MARK | |||||||||||||
| filer_namt | 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 | |||||||||||||
| report_num | 000 | 000 | 000 | 001 | 000 | 001 | 000 | 000 | 000 | 001 | 000 | 001 | 002 | |||||||||||||
| rpt_date | 2012-06-14 00:00:00 | 2012-12-18 00:00:00 | 2015-01-01 00:00:00 | 2015-04-20 00:00:00 | 2016-12-20 00:00:00 | 2017-02-03 00:00:00 | 2018-10-01 00:00:00 | 2018-10-01 00:00:00 | 2018-12-15 00:00:00 | 2018-12-15 00:00:00 | 2020-12-01 00:00:00 | 2020-12-01 00:00:00 | 2021-09-22 00:00:00 | |||||||||||||
| ls_beg_yr | 2011 | 2013 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2021 | 2021 | 2021 | |||||||||||||
| ls_end_yr | 2012 | 2014 | 2016 | 2016 | 2018 | 2018 | 2018 | 2018 | 2020 | 2020 | 2022 | 2022 | 2022 | |||||||||||||
| qual_date | 2012-06-01 00:00:00 | 2013-01-01 00:00:00 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
| eff_date | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
| bus_city | SACRAMENTO | 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 | CA | |||||||||||||
| bus_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95822 | 95822 | 95822 | 95822 | 95822 | 95822 | 95814 | |||||||||||||
| bus_phon | 9165581516 | 9165581516 | 916 558-1516 | 916-558-1516 | 916-558-1516 | 916-558-1516 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | |||||||||||||
| bus_fax | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
| bus_email | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | |||||||||||||
| mail_city | 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 | |||||||||||||
| mail_zip4 | 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 | |||||||||||||
| sig_date | 2012-06-14 00:00:00 | 2012-12-18 00:00:00 | 2014-12-19 00:00:00 | 2015-04-20 00:00:00 | 2016-12-20 00:00:00 | 2017-02-03 00:00:00 | 2018-10-01 00:00:00 | 2018-10-01 00:00:00 | 2018-12-15 00:00:00 | 2018-12-15 00:00:00 | 2021-01-08 00:00:00 | 2021-02-25 00:00:00 | 2021-09-22 00:00:00 | |||||||||||||
| sig_loc | None | None | Sacramento CA | None | None | None | None | None | None | None | None | None | None | |||||||||||||
| sig_naml | FENSTERMAKER | FENSTERMAKER | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | Fenstermaker | FENSTERMAKER | |||||||||||||
| sig_namf | MARK | MARK | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | MARK | |||||||||||||
| sig_namt | None | None | None | None | None | None | None | None | None | None | None | Mr. | MR. | |||||||||||||
| sig_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
| prn_naml | FENSTERMAKER | FENSTERMAKER | Fenstermaker | None | None | None | None | None | None | None | None | None | None | |||||||||||||
| prn_namf | MARK | MARK | Mark | None | None | None | None | None | None | None | None | None | None | |||||||||||||
| prn_namt | 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 | |||||||||||||
| sig_title | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
| stmt_firm | None | 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 | None | |||||||||||||
| bus_cb | None | 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 | None | |||||||||||||
| oth_cb | None | 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 | None | |||||||||||||
| a_b_city | None | 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 | None | |||||||||||||
| a_b_zip4 | None | 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 | None | |||||||||||||
| descrip_2 | None | 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 | None | |||||||||||||
| c_more50 | None | 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 | None | |||||||||||||
| ind_descr | None | 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 | None | |||||||||||||
| bus_descr | None | 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 | None | |||||||||||||
| auth_city | None | 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 | None | |||||||||||||
| auth_zip4 | None | 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 | None | |||||||||||||
| influen_yn | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
| firm_name | Conservation Strategy Group | Conservation Strategy Group | Conservation Strategy Group LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | CONSERVATION STRATEGY GROUP LLC | PACIFIC POLICY GROUP | PACIFIC POLICY GROUP | PACIFIC POLICY GROUP | PACIFIC POLICY GROUP | PACIFIC POLICY GROUP | PACIFIC POLICY GROUP | PACIFIC POLICY GROUP | |||||||||||||
| newcert_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
| rencert_cb | None | None | X | None | X | None | None | None | None | X | X | None | None | |||||||||||||
| complet_dt | 2012-06-07 00:00:00 | 2012-07-12 00:00:00 | None | 2015-01-22 00:00:00 | None | 2017-02-03 00:00:00 | 2017-02-03 00:00:00 | 2017-02-03 00:00:00 | None | None | None | 2021-02-12 00:00:00 | 2021-02-12 00:00:00 | |||||||||||||
| lby_reg_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||
| lby_604_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
| st_leg_yn | Y | Y | None | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | |||||||||||||
| st_agency | None | 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 | None | |||||||||||||
| l_firm_cb | None | None | None | None | None | None | None | None | None | None | None | None | None |
| filer_id | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| adrid | 2410496 | 2464247 | 2475007 | 2275951 | 2229810 | 2508873 | 2547800 | 2342836 | ||||||||
| effect_dt | 2017-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-01-01 00:00:00 | 2013-01-01 00:00:00 | 2012-06-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | 2015-01-01 00:00:00 | ||||||||
| add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||
| session_id | 2017 | 2017 | 2019 | 2013 | 2011 | 2021 | 2023 | 2015 |
| filer_id | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| session_id | 2011 | 2013 | 2015 | 2017 | 2017 | 2019 | 2021 | |||||||
| ethics_date | 2012-06-07 00:00:00 | 2012-07-12 00:00:00 | 2015-01-22 00:00:00 | 2017-02-02 00:00:00 | 2017-02-03 00:00:00 | 2019-06-27 00:00:00 | 2021-02-12 00:00:00 |
| filer_id | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 1777790 | 1968738 | 1964164 | 1865630 | 1795933 | 1919383 | 1950997 | 1909337 | 1668427 | 1672306 | 1675545 | 1668838 | 1811869 | 1930999 | 1919383 | 1930273 | 1717915 | 1708108 | 1726749 | 1738078 | 1839454 | 1761356 | 1980748 | 2207042 | 2305296 | 2349198 | 2242213 | 2542945 | 2358256 | 2528886 | 2272907 | 2487013 | 2400102 | 2310680 | 2007171 | 2030822 | 2059207 | 2098738 | 2113090 | 2127461 | 2153998 | 2142387 | 2113090 | 2136888 | 2133818 | 2171997 | 2171998 | 2320130 | 2321510 | 2328235 | 2419478 | 2471722 | 2400551 | 2191570 | 2328235 | 2439133 | 2382006 | 2552502 | 2674889 | 2567775 | 2623040 | 2626679 | 2580549 | 2601240 | 2623040 | 2639126 | 2542945 | 2542945 | 1993058 | 2705199 | 2748330 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| period_id | 214 | None | 221 | 218 | 215 | 222 | None | 219 | None | None | 210 | 210 | 216 | 220 | 221 | None | 212 | 211 | None | 212 | 217 | 213 | 222 | 232 | 236 | 236 | 233 | 244 | None | 243 | 234 | 242 | 238 | 236 | 224 | 225 | 226 | 227 | 228 | 228 | 229 | None | 229 | None | None | 230 | 230 | 235 | None | 236 | 239 | 241 | None | 231 | 236 | 240 | 237 | 244 | 249 | None | 247 | None | 245 | 246 | 247 | 248 | 244 | 247 | 223 | 250 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F615 | F604 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F604 | F604 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F604 | F604 | F604 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_date | 2013-07-24 00:00:00 | 2015-04-23 00:00:00 | 2015-04-29 00:00:00 | 2014-07-23 00:00:00 | 2013-10-21 00:00:00 | 2015-04-20 00:00:00 | 2014-12-19 00:00:00 | 2014-10-30 00:00:00 | 2012-06-07 00:00:00 | 2012-06-20 00:00:00 | 2012-07-27 00:00:00 | 2012-06-14 00:00:00 | 2014-01-22 00:00:00 | 2015-01-27 00:00:00 | 2014-12-19 00:00:00 | 2015-01-22 00:00:00 | 2012-12-18 00:00:00 | 2012-10-30 00:00:00 | 2012-12-21 00:00:00 | 2013-01-31 00:00:00 | 2014-04-18 00:00:00 | 2013-04-24 00:00:00 | 2015-07-30 00:00:00 | 2018-01-28 00:00:00 | 2018-10-11 00:00:00 | 2019-01-31 00:00:00 | 2018-04-30 00:00:00 | 2021-01-08 00:00:00 | 2018-12-20 00:00:00 | 2020-10-31 00:00:00 | 2018-07-30 00:00:00 | 2020-07-31 00:00:00 | 2019-07-31 00:00:00 | 2018-10-23 00:00:00 | 2016-01-26 00:00:00 | 2016-04-21 00:00:00 | 2016-07-27 00:00:00 | 2016-10-27 00:00:00 | 2016-12-21 00:00:00 | 2017-01-30 00:00:00 | 2017-04-26 00:00:00 | 2016-12-22 00:00:00 | 2017-02-03 00:00:00 | 2017-02-07 00:00:00 | 2017-02-02 00:00:00 | 2017-07-26 00:00:00 | 2017-07-26 00:00:00 | 2018-10-31 00:00:00 | 2018-10-30 00:00:00 | 2018-12-16 00:00:00 | 2019-10-31 00:00:00 | 2020-04-30 00:00:00 | 2019-07-05 00:00:00 | 2017-10-29 00:00:00 | 2018-12-16 00:00:00 | 2020-01-29 00:00:00 | 2019-04-30 00:00:00 | 2021-01-31 00:00:00 | 2022-04-29 00:00:00 | 2020-12-30 00:00:00 | 2021-10-29 00:00:00 | 2021-10-18 00:00:00 | 2021-04-30 00:00:00 | 2021-07-30 00:00:00 | 2021-10-29 00:00:00 | 2022-01-27 00:00:00 | 2021-02-25 00:00:00 | 2021-09-22 00:00:00 | 2015-10-21 00:00:00 | 2022-07-30 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_type | 10001 | 10006 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10006 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10006 | 10006 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| session_id | 2013 | 2015 | 2015 | 2013 | 2013 | 2015 | 2015 | 2013 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2015 | 2015 | 2013 | 2011 | 2013 | 2011 | 2013 | 2013 | 2015 | 2017 | 2017 | 2017 | 2017 | 2021 | 2019 | 2019 | 2017 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2015 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| user_id | ASAETERN | PBANFORD | JINGRAM | ASAETERN | ASAETERN | PBANFORD | GPEREZ | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | CAFILER | ASAETERN | AGLADNEY | CAFILER | ASAETERN | CAFILER | ASAETERN | GPEREZ | ASAETERN | ASAETERN | ASAETERN | JINGRAM | AGLADNEY | GPEREZ | VUKSTINA | AGLADNEY | MMERCHANT | PBANFORD | GTAYLOR | AGLADNEY | CVANLIEW | VUKSTINA | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | JINGRAM | YRODRIGU | AGLADNEY | JINGRAM | YRODRIGU | KBANH | KBANH | KBANH | SMCCONNAN | SMCCONNAN | AGLADNEY | GPEREZ | PBANFORD | VUKSTINA | SUSHAKOV | VUKSTINA | AGLADNEY | PBANFORD | VUKSTINA | SUSHAKOV | GTAYLOR | CAFILER | MMERCHANT | GTAYLOR | CVANLIEW | GTAYLOR | CHATRIDGE | GTAYLOR | RATTIYEH | CAFILER | CVANLIEW | JINGRAM | CAFILER | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_start | 2013-04-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 2015-04-20 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-06-14 00:00:00 | 2013-10-01 00:00:00 | 2014-10-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-12-18 00:00:00 | 2012-07-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-04-01 00:00:00 | 2017-10-01 00:00:00 | 2018-10-01 00:00:00 | 2018-10-01 00:00:00 | 2018-01-01 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 2020-07-01 00:00:00 | 2018-04-01 00:00:00 | 2020-04-01 00:00:00 | 2019-04-01 00:00:00 | 2018-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-12-20 00:00:00 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-02-03 00:00:00 | None | None | 2017-04-01 00:00:00 | 2017-04-01 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2018-12-15 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-07-01 00:00:00 | 2018-12-15 00:00:00 | 2019-10-01 00:00:00 | 2019-01-01 00:00:00 | 2020-10-01 00:00:00 | 2022-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2020-12-01 00:00:00 | 2021-09-22 00:00:00 | 2015-07-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_end | 2013-06-30 00:00:00 | 1900-01-01 00:00:00 | 2015-03-31 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 2015-04-20 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-06-30 00:00:00 | 2012-06-14 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-12-18 00:00:00 | 2012-09-30 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-10-01 00:00:00 | 2018-12-31 00:00:00 | 2018-03-31 00:00:00 | 2020-12-01 00:00:00 | 1900-01-01 00:00:00 | 2020-09-30 00:00:00 | 2018-06-30 00:00:00 | 2020-06-30 00:00:00 | 2019-06-30 00:00:00 | 2018-10-01 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-20 00:00:00 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-02-03 00:00:00 | None | None | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2018-12-15 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-09-30 00:00:00 | 2018-12-15 00:00:00 | 2019-12-31 00:00:00 | 2019-03-31 00:00:00 | 2020-12-31 00:00:00 | 2022-03-31 00:00:00 | 1900-01-01 00:00:00 | 2021-09-30 00:00:00 | 1900-01-01 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2020-12-01 00:00:00 | 2021-09-22 00:00:00 | 2015-09-30 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_type | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | None | 22006 | 22006 | 22001 | 22001 | 22001 | None | 22006 | 22006 | None | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
| filer_id | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||
| active | Y | Y | Y | Y | Y | Y | N | |||||||
| race | None | 0 | None | None | None | None | None | |||||||
| session_id | 2013 | 2011 | 2015 | 2021 | 2019 | 2017 | 2023 | |||||||
| category | None | 0 | None | None | None | None | None | |||||||
| category_type | None | 0 | None | None | None | None | None | |||||||
| sub_category | None | 0 | None | None | None | None | None | |||||||
| effect_dt | 2013-01-01 00:00:00 | 2012-06-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||
| sub_category_type | None | 0 | None | None | None | None | None | |||||||
| election_type | None | 0 | None | None | None | None | None | |||||||
| sub_category_a | None | None | None | None | None | None | None | |||||||
| nyq_dt | None | None | None | None | None | None | None | |||||||
| party_cd | None | 0 | None | None | None | None | None | |||||||
| county_cd | None | 0 | None | None | None | None | None | |||||||
| district_cd | None | 0 | None | None | None | None | None |
| filer_id | 1347282 | |
|---|---|---|
| xref_id | 1347282 | |
| effect_dt | 2012-04-30 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| naml | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | FENSTERMAKER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| namf | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | MARK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| zip4 | 95814 | 95814 | 95814 | 95814 | 95822 | 95822 | 95822 | 95822 | 95814 | 95814 | 95814 | 95814 | 95822 | 95822 | 95822 | 95822 | 95814 | 95814 | 95814 | 95814 | 95822 | 95822 | 95822 | 95822 | 95814 | 95814 | 95814 | 95814 | 95822 | 95822 | 95822 | 95822 | 95814 | 95814 | 95814 | 95814 | 95822 | 95822 | 95822 | 95822 | 95814 | 95814 | 95814 | 95814 | 95822 | 95822 | 95822 | 95822 | 95814 | 95814 | 95814 | 95814 | 95822 | 95822 | 95822 | 95822 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| phon | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | 9165581516 | 9165581516 | 9165581516 | 9165581516 | 9167988088 | 9167988088 | 9167988088 | 9167988088 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] |
| filer_id | 1347282 |
|---|
| filer_id | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| change_no | 1 | 2 | 3 | 0 | 4 | |||||
| session_id | 2011 | 2011 | 2011 | 2011 | 2017 | |||||
| log_dt | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2012-06-20 00:00:00 | 2018-10-30 00:00:00 | |||||
| filer_type | 4 | 4 | 4 | 4 | 4 | |||||
| correction_flg | None | None | None | Y | None | |||||
| action | SET ACTIVE | CHANGED | CHANGED | ADDED | SET ACTIVE | |||||
| attribute_changed | ADDRESS | NAME | FIRM | FIRM | ||||||
| ethics_dt | None | None | None | None | None | |||||
| interests | None | None | None | None | None | |||||
| filer_full_name | FENSTERMAKER, MARK | FENSTERMAKER, MARK | FENSTERMAKER, MARK | FENSTERMAKER, MARK | MARK FENSTERMAKER | |||||
| filer_city | None | SACRAMENTO | None | None | None | |||||
| filer_st | None | CA | None | None | None | |||||
| filer_zip | None | 95814 | None | None | None | |||||
| filer_phone | None | 9165581516 | None | None | None | |||||
| entity_type | 4 | 4 | 4 | 3 | 3 | |||||
| entity_name | None | None | FENSTERMAKER, MARK | CONSERVATION STRATEGY GROUP LLC | PACIFIC POLICY GROUP | |||||
| entity_city | None | None | None | None | None | |||||
| entity_st | None | None | None | None | None | |||||
| entity_zip | None | None | None | None | None | |||||
| entity_phone | None | None | None | None | None | |||||
| entity_id | 0 | 0 | 0 | 1147461 | 1412920 | |||||
| responsible_officer | None | None | None | None | None | |||||
| effect_dt | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 | 2018-10-01 00:00:00 |
| filer_id | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | 1347282 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 1668838_0.cal | 1839454_0.cal | 1795933_0.cal | 235025.cal | 1811869_0.cal | 1777790_0.cal | 1761356_0.cal | 1717915_0.cal | 1865630_0.cal | 1980748_0.cal | 2127461_0.cal | 2113090_1.cal | 2153998_0.cal | 2059207_0.cal | 2007171_0.cal | 1993058_0.cal | 2113090_0.cal | 2098738_0.cal | 1930999_0.cal | 1909337_0.cal | 1964164_0.cal | 1919383_1.cal | 1919383_0.cal | 2030822_0.cal | 169489.cal | 2171997_0.cal | 2171998_0.cal | 2207042_0.cal | 2305296_0.cal | 2349198_0.cal | 2242213_0.cal | 2471722_0.cal | 2272907_0.cal | 2382006_0.cal | 2310680_0.cal | 2320130_0.cal | 2419478_0.cal | 2487013_0.cal | 2439133_0.cal | 2400102_0.cal | 2191570_0.cal | 2328235_1.cal | 2542945_0.cal | 2552502_0.cal | 2528886_0.cal | 2542945_1.cal | 2705199_0.cal | 2601240_0.cal | 2674889_0.cal | 2623040_1.cal | 2580549_0.cal | 2623040_0.cal | 2639126_0.cal | 2748330_0.cal | 2542945_2.cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
| received_date | 2012-06-14 00:00:00 | 2014-04-18 00:00:00 | 2013-10-21 00:00:00 | 2013-10-21 00:00:00 | 2014-01-22 00:00:00 | 2013-07-24 00:00:00 | 2013-04-24 00:00:00 | 2012-12-18 00:00:00 | 2014-07-23 00:00:00 | 2015-07-30 00:00:00 | 2017-01-30 00:00:00 | 2017-02-03 00:00:00 | 2017-04-26 00:00:00 | 2016-07-27 00:00:00 | 2016-01-26 00:00:00 | 2015-10-21 00:00:00 | 2016-12-21 00:00:00 | 2016-10-27 00:00:00 | 2015-01-27 00:00:00 | 2014-10-30 00:00:00 | 2015-04-29 00:00:00 | 2015-04-20 00:00:00 | 2014-12-19 00:00:00 | 2016-04-21 00:00:00 | 2015-04-17 00:00:00 | 2017-07-26 00:00:00 | 2017-07-26 00:00:00 | 2018-01-28 00:00:00 | 2018-10-11 00:00:00 | 2019-01-31 00:00:00 | 2018-04-30 00:00:00 | 2020-04-30 00:00:00 | 2018-07-30 00:00:00 | 2019-04-30 00:00:00 | 2018-10-23 00:00:00 | 2018-10-31 00:00:00 | 2019-10-31 00:00:00 | 2020-07-31 00:00:00 | 2020-01-29 00:00:00 | 2019-07-31 00:00:00 | 2017-10-29 00:00:00 | 2018-12-16 00:00:00 | 2021-01-08 00:00:00 | 2021-01-31 00:00:00 | 2020-10-31 00:00:00 | 2021-02-25 00:00:00 | 2022-07-30 00:00:00 | 2021-07-30 00:00:00 | 2022-04-29 00:00:00 | 2021-10-29 00:00:00 | 2021-04-30 00:00:00 | 2021-10-29 00:00:00 | 2022-01-27 00:00:00 | 2022-10-31 00:00:00 | 2021-09-22 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_id | 1668838 | 1839454 | 1795933 | None | 1811869 | 1777790 | 1761356 | 1717915 | 1865630 | 1980748 | 2127461 | 2113090 | 2153998 | 2059207 | 2007171 | 1993058 | 2113090 | 2098738 | 1930999 | 1909337 | 1964164 | 1919383 | 1919383 | 2030822 | None | 2171997 | 2171998 | 2207042 | 2305296 | 2349198 | 2242213 | 2471722 | 2272907 | 2382006 | 2310680 | 2320130 | 2419478 | 2487013 | 2439133 | 2400102 | 2191570 | 2328235 | 2542945 | 2552502 | 2528886 | 2542945 | 2705199 | 2601240 | 2674889 | 2623040 | 2580549 | 2623040 | 2639126 | 2748330 | 2542945 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F604 | F615 | F615 | None | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | None | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
| receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |