filing_id | 1620731 | 1591794 | 1604246 | 1630616 | 1706993 | 1673634 | 1654264 | 1799508 | 1765380 | 1780862 | 1814269 | 1906990 | 1865694 | 1838807 | 1930399 | 1981994 | 1961532 | 2030439 | 1993465 | 2061485 | 2008055 | 2095247 | 2171415 | 2152339 | 2119267 | 2190961 | 2270179 | 2211232 | 2236555 | 2377805 | 2350172 | 2311915 | 2437919 | 2467956 | 2399520 | 2417960 | 2575607 | 2527353 | 2548219 | 2486109 | 2636304 | 2615482 | 2592780 | 2736377 | 2575607 | 2699798 | 2615482 | 2636304 | 2669070 | 2548219 | 2592780 | |||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||||||||||||||||||||||||||||||||||||||||||
form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||||||||||||||||||||||||||||||||||||||||||||
sender_id | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1394663 | 1394663 | 1334279 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | |||||||||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | |||||||||||||||||||||||||||||||||||||||||||||||||||
entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | LBY | LBY | FRM | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | |||||||||||||||||||||||||||||||||||||||||||||||||||
filer_naml | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | |||||||||||||||||||||||||||||||||||||||||||||||||||
filer_namf | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | |||||||||||||||||||||||||||||||||||||||||||||||||||
filer_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
filer_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 001 | 001 | 000 | 001 | 001 | |||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2011-10-28 00:00:00 | 2011-05-02 00:00:00 | 2011-07-27 00:00:00 | 2012-01-23 00:00:00 | 2012-10-29 00:00:00 | 2012-07-23 00:00:00 | 2012-04-24 00:00:00 | 2013-10-30 00:00:00 | 2013-04-30 00:00:00 | 2013-07-30 00:00:00 | 2014-01-28 00:00:00 | 2014-10-28 00:00:00 | 2014-07-23 00:00:00 | 2014-04-16 00:00:00 | 2015-01-27 00:00:00 | 2015-07-31 00:00:00 | 2015-04-24 00:00:00 | 2016-04-21 00:00:00 | 2015-10-22 00:00:00 | 2016-07-29 00:00:00 | 2016-01-27 00:00:00 | 2016-10-25 00:00:00 | 2017-07-25 00:00:00 | 2017-04-21 00:00:00 | 2017-01-12 00:00:00 | 2017-10-26 00:00:00 | 2018-07-26 00:00:00 | 2018-01-31 00:00:00 | 2018-04-25 00:00:00 | 2019-04-26 00:00:00 | 2019-01-31 00:00:00 | 2018-10-24 00:00:00 | 2020-01-29 00:00:00 | 2020-04-30 00:00:00 | 2019-07-31 00:00:00 | 2019-10-30 00:00:00 | 2021-04-20 00:00:00 | 2020-10-30 00:00:00 | 2021-01-27 00:00:00 | 2020-07-31 00:00:00 | 2022-01-21 00:00:00 | 2021-10-12 00:00:00 | 2021-07-13 00:00:00 | 2022-10-19 00:00:00 | 2022-02-10 00:00:00 | 2022-07-21 00:00:00 | 2022-07-28 00:00:00 | 2022-09-28 00:00:00 | 2022-04-22 00:00:00 | 2022-02-10 00:00:00 | 2022-04-12 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||
from_date | 2011-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2012-07-01 00:00:00 | 2012-04-01 00:00:00 | 2012-01-01 00:00:00 | 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-07-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2014-10-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | 2015-07-01 00:00:00 | 2016-04-01 00:00:00 | 2015-10-01 00:00:00 | 2016-07-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-07-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | 2021-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 2021-10-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2022-07-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2020-10-01 00:00:00 | 2021-04-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||
thru_date | 2011-09-30 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2012-09-30 00:00:00 | 2012-06-30 00:00:00 | 2012-03-31 00:00:00 | 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-09-30 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2014-12-31 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2016-03-31 00:00:00 | 2015-09-30 00:00:00 | 2016-06-30 00:00:00 | 2015-12-31 00:00:00 | 2016-09-30 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 2017-09-30 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2019-03-31 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2019-06-30 00:00:00 | 2019-09-30 00:00:00 | 2021-03-31 00:00:00 | 2020-09-30 00:00:00 | 2020-12-21 00:00:00 | 2020-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2022-09-30 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2020-12-31 00:00:00 | 2021-06-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 | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
firm_id | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1394663 | 1394663 | 1334279 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | |||||||||||||||||||||||||||||||||||||||||||||||||||
firm_name | Planning and Conservation League | Planning and Conservation League | Planning and Conservation League | Planning and Conservation League | Planning and Conservation League | Planning and Conservation League | Planning and Conservation League | California League of Conservation Voters | California League of Conservation Voters | California League of Conservation Voters | California League of Conservation Voters | California League of Conservation Voters | California League of Conservation Voters | California League of Conservation Voters | California League of Conservation Voters | California League of Conservation Voters | California League of Conservation Voters | California League of Conservation Voters | California League of Conservation Voters | California League of Conservation Voters | California League of Conservation Voters | California League of Conservation Voters | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | California League of Conservation Voters | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | |||||||||||||||||||||||||||||||||||||||||||||||||||
firm_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||||||||||||||||||||||||||||||||||||||||||||||||
firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||||||||||||||||||||||||||||||||||||||||||||
firm_phon | 9163134522 | 9163134522 | 9163134522 | 9163134522 | 9163134522 | 9163134522 | 9163134522 | 9167125781 | 9167125781 | 9167125781 | 9167125781 | 9167125781 | 9167125781 | 9167125781 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 916-834-6344 | 916-834-6344 | None | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | |||||||||||||||||||||||||||||||||||||||||||||||||||
mail_city | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | WEST SACRAMENTO | None | None | WEST SACRAMENTO | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
mail_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | None | None | CA | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
mail_zip4 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | 95691 | None | None | 95691 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
mail_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
sig_date | 2011-10-28 00:00:00 | 2011-05-02 00:00:00 | 2011-07-27 00:00:00 | 2012-01-23 00:00:00 | 2012-10-29 00:00:00 | 2012-07-23 00:00:00 | 2012-04-24 00:00:00 | 2013-10-30 00:00:00 | 2013-04-30 00:00:00 | 2013-07-30 00:00:00 | 2014-01-28 00:00:00 | 2014-10-28 00:00:00 | 2014-07-23 00:00:00 | 2014-04-16 00:00:00 | 2015-01-27 00:00:00 | 2015-07-31 00:00:00 | 2015-04-24 00:00:00 | 2016-04-21 00:00:00 | 2015-10-22 00:00:00 | 2016-07-29 00:00:00 | 2016-01-27 00:00:00 | 2016-10-25 00:00:00 | 2017-07-25 00:00:00 | 2017-04-21 00:00:00 | 2017-01-12 00:00:00 | 2017-10-26 00:00:00 | 2018-07-26 00:00:00 | 2018-01-31 00:00:00 | 2018-04-25 00:00:00 | 2019-04-26 00:00:00 | 2019-01-31 00:00:00 | 2018-10-24 00:00:00 | 2020-01-29 00:00:00 | 2020-04-30 00:00:00 | 2019-07-31 00:00:00 | 2019-10-30 00:00:00 | 2021-04-20 00:00:00 | 2020-10-30 00:00:00 | 0202-01-27 00:00:00 | 2020-07-31 00:00:00 | 2022-01-21 00:00:00 | 2021-10-12 00:00:00 | 2021-07-13 00:00:00 | 2022-10-19 00:00:00 | 2022-02-10 00:00:00 | 2022-07-21 00:00:00 | 2022-07-28 00:00:00 | 2022-09-28 00:00:00 | 2022-04-22 00:00:00 | 2022-02-10 00:00:00 | 2022-04-12 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||
sig_loc | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento | Sacramento, CA | Sacramento, CA | Oakland, CA | Oakland, CA | Oakland, CA | Oakland, CA | Oakland, CA | Oakland, CA | Oakland, CA | Oakland, CA | Oakland, CA | Oakland, CA | Oakland, CA | Oakland, CA | Oakland, CA | Oakland, CA | Oakland, CA | Sacramento CA | Sacramento CA | Oakland, CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento | Sacramento | SACRMENTO CA | Sacramento CA | Sacramento | Sacramento | Sacramento California | Sacramento | Sacramento CA | Sacramento | Sacramento | Sacramento | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | |||||||||||||||||||||||||||||||||||||||||||||||||||
sig_naml | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Taylor | Price | Price | Price | Price | Price | Price | Price | Price | Price | PRICE | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | |||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namf | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Heather | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | JENA | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | |||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
sig_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
prn_naml | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | None | None | Price | None | None | 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 | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | None | None | Jena | None | None | 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 | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
prn_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
sig_title | Legislative Director | Global Warming Coordinator | Legislative Advocate | Legislative Director | Lobbyist | Legislative Director | Legislative Director | Legislative Affairs Manager | Legislative Affairs Manager | Legislative Affairs Manager | Legislative Affairs Manager | Legislative Affairs Manager | Legislative Affairs Manager | Legislative Affairs Manager | Legislative Affairs Manager | Legislative Affairs Manager | Legislative Affairs Manager | Legislative Affairs Manager | Legislative Affairs Manager | Legislative Affairs Manager | Legislative Affairs Manager | Legislative Affairs Manager | None | None | Legislative Affairs Manager | None | None | 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 | X | X | X | X | X | X | X | |||||||||||||||||||||||||||||||||||||||||||||||||||
nopart2_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||||||||||||||||||||||||||||||||||||||||
part1_1_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
part1_2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_n_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
lby_actvty | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
lobby_n_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
lobby_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
major_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
major_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
major_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
major_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
rcpcmte_nm | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
rcpcmte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filing_id | 1914900 | 2110713 | 2147885 | 2329642 | 2329642 | 2537762 | 2537762 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||
form_type | F604 | F604 | F604 | F604 | F604 | F604 | F604 | |||||||
sender_id | C25840 | C25840 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | |||||||
filer_id | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | |||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | |||||||
filer_naml | PRICE | PRICE | PRICE | Consulting | PRICE | PRICE | PRICE | |||||||
filer_namf | JENA E. | JENA E. | JENA E. | TrattenPrice | JENA | JENA | JENA | |||||||
filer_namt | None | None | None | None | None | None | None | |||||||
filer_nams | None | None | None | None | None | None | None | |||||||
report_num | 000 | 000 | 000 | 000 | 001 | 000 | 001 | |||||||
rpt_date | 2014-11-13 00:00:00 | 2016-12-13 00:00:00 | 2017-03-23 00:00:00 | 2018-12-26 00:00:00 | 2020-03-16 00:00:00 | 2020-12-21 00:00:00 | 2021-06-14 00:00:00 | |||||||
ls_beg_yr | 2015 | 2017 | 2017 | 2019 | 2019 | 2021 | 2021 | |||||||
ls_end_yr | 2016 | 2018 | 2018 | 2020 | 2020 | 2022 | 2022 | |||||||
qual_date | None | None | None | None | None | None | None | |||||||
eff_date | None | None | None | None | None | None | None | |||||||
bus_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||||
bus_st | CA | CA | CA | CA | CA | CA | CA | |||||||
bus_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||
bus_phon | 9168346344 | 9168346344 | 916-834-6344 | 916-834-6344 | 9168346344 | 9168346344 | 9168346344 | |||||||
bus_fax | None | None | None | None | None | None | None | |||||||
bus_email | [email protected] | [email protected] | None | None | None | None | None | |||||||
mail_city | WEST SACRAMENTO | WEST SACRAMENTO | None | None | None | None | None | |||||||
mail_st | CA | CA | None | None | None | None | None | |||||||
mail_zip4 | 95691 | 95691 | None | None | None | None | None | |||||||
mail_phon | None | None | None | None | None | None | None | |||||||
sig_date | 2014-11-13 00:00:00 | 2016-12-13 00:00:00 | 2017-03-23 00:00:00 | 2018-12-26 00:00:00 | 2020-03-16 00:00:00 | 2020-12-21 00:00:00 | 2021-06-14 00:00:00 | |||||||
sig_loc | None | None | None | None | None | None | None | |||||||
sig_naml | PRICE | PRICE | Price | Price | PRICE | PRICE | PRICE | |||||||
sig_namf | JENA E. | JENA E. | Jena E. | Jena E. | JENA E. | JENA E. | JENA E. | |||||||
sig_namt | None | None | None | None | None | None | None | |||||||
sig_nams | None | None | None | None | None | None | None | |||||||
prn_naml | PRICE | PRICE | None | None | None | None | None | |||||||
prn_namf | JENA E. | JENA E. | None | None | None | None | None | |||||||
prn_namt | None | None | None | None | None | None | None | |||||||
prn_nams | None | None | None | None | None | None | None | |||||||
sig_title | None | None | None | None | None | None | None | |||||||
stmt_firm | None | None | None | None | None | None | None | |||||||
ind_cb | None | None | None | None | None | None | None | |||||||
bus_cb | None | None | None | None | None | None | None | |||||||
trade_cb | None | None | None | None | None | None | None | |||||||
oth_cb | None | None | None | None | None | None | None | |||||||
a_b_name | None | None | None | None | None | None | None | |||||||
a_b_city | None | None | None | None | None | None | None | |||||||
a_b_st | None | None | None | None | None | None | None | |||||||
a_b_zip4 | None | None | None | None | None | None | None | |||||||
descrip_1 | None | None | None | None | None | None | None | |||||||
descrip_2 | None | None | None | None | None | None | None | |||||||
c_less50 | None | None | None | None | None | None | None | |||||||
c_more50 | None | None | None | None | None | None | None | |||||||
ind_class | None | None | None | None | None | None | None | |||||||
ind_descr | None | None | None | None | None | None | None | |||||||
bus_class | None | None | None | None | None | None | None | |||||||
bus_descr | None | None | None | None | None | None | None | |||||||
auth_name | None | None | None | None | None | None | None | |||||||
auth_city | None | None | None | None | None | None | None | |||||||
auth_st | None | None | None | None | None | None | None | |||||||
auth_zip4 | None | None | None | None | None | None | None | |||||||
lobby_int | None | None | None | None | None | None | None | |||||||
influen_yn | None | None | None | None | None | None | None | |||||||
firm_name | California League of Conservation Voters | California League of Conservation Voters | TRATTENPRICE CONSULTING | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | |||||||
newcert_cb | None | None | None | None | None | None | None | |||||||
rencert_cb | X | X | None | X | None | X | None | |||||||
complet_dt | None | None | 2017-01-12 00:00:00 | None | 2019-04-11 00:00:00 | None | 2021-06-10 00:00:00 | |||||||
lby_reg_cb | X | X | X | X | X | X | X | |||||||
lby_604_cb | None | None | None | None | None | None | None | |||||||
st_leg_yn | Y | Y | Y | Y | Y | Y | Y | |||||||
st_agency | None | None | None | None | None | None | None | |||||||
lobby_cb | None | None | None | None | None | None | None | |||||||
l_firm_cb | None | None | None | None | None | None | None |
filer_id | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2208607 | 2209265 | 2411567 | 2411568 | 2440257 | 2471281 | 2471282 | 2510038 | 2286587 | 2457493 | 2339471 | 2551479 | 2551480 | |||||||||||||
effect_dt | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-09-26 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2013-03-11 00:00:00 | 2018-08-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||
add_type | 7051 | 7082 | 7051 | 7082 | 7051 | 7051 | 7082 | 7051 | 7051 | 7051 | 7051 | 7051 | 7082 | |||||||||||||
session_id | 2011 | 2011 | 2017 | 2017 | 2017 | 2019 | 2019 | 2021 | 2013 | 2017 | 2015 | 2023 | 2023 |
filer_id | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2011 | 2013 | 2017 | 2015 | 2019 | 2021 | ||||||
ethics_date | 2011-02-24 00:00:00 | 2013-04-11 00:00:00 | 2017-01-12 00:00:00 | 2015-04-09 00:00:00 | 2019-04-11 00:00:00 | 2021-06-10 00:00:00 |
filer_id | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1765380 | 1780862 | 1981994 | 1838807 | 1865694 | 1958884 | 1961532 | 1920711 | 1906990 | 1557834 | 1579344 | 1591794 | 1604246 | 1620731 | 1630616 | 1654264 | 1673634 | 1814269 | 1799508 | 1930399 | 1914900 | 1706993 | 1885702 | 1760592 | 1757324 | 2437919 | 2211232 | 2329642 | 2527353 | 2537762 | 2008055 | 1993465 | 2030439 | 2061485 | 2095247 | 2119267 | 2119962 | 2110713 | 2115184 | 2152339 | 2152083 | 2147885 | 2171415 | 2311915 | 2348133 | 2350172 | 2270179 | 2377805 | 2417960 | 2236555 | 2467956 | 2548219 | 2329642 | 2399520 | 2486109 | 2190961 | 2537762 | 2464737 | 2604474 | 2669070 | 2548219 | 2575607 | 2592780 | 2636304 | 2575607 | 2699798 | 2636304 | 2615482 | 2582114 | 2592780 | 2615482 | 2736377 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 213 | 214 | 222 | 217 | 218 | None | 221 | None | 219 | None | None | 205 | 206 | 207 | 208 | 209 | 210 | 216 | 215 | 220 | 220 | 211 | None | None | None | 240 | 232 | 241 | 243 | 244 | 224 | 223 | 225 | 226 | 227 | 228 | None | 228 | None | 229 | None | 229 | 230 | 235 | None | 236 | 234 | 237 | 239 | 233 | 241 | 244 | 236 | 238 | 242 | 231 | 246 | None | None | 249 | 244 | 245 | 246 | 248 | 245 | 250 | 248 | 247 | None | 246 | 247 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F888 | F604 | F604 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2013-04-30 00:00:00 | 2013-07-30 00:00:00 | 2015-07-31 00:00:00 | 2014-04-16 00:00:00 | 2014-07-23 00:00:00 | 2015-04-09 00:00:00 | 2015-04-24 00:00:00 | 2014-12-02 00:00:00 | 2014-10-28 00:00:00 | 2010-12-13 00:00:00 | 2011-02-24 00:00:00 | 2011-05-02 00:00:00 | 2011-07-27 00:00:00 | 2011-10-28 00:00:00 | 2012-01-23 00:00:00 | 2012-04-24 00:00:00 | 2012-07-23 00:00:00 | 2014-01-28 00:00:00 | 2013-10-30 00:00:00 | 2015-01-27 00:00:00 | 2014-11-13 00:00:00 | 2012-10-29 00:00:00 | 2014-07-17 00:00:00 | 2013-03-11 00:00:00 | 2013-04-11 00:00:00 | 2020-01-29 00:00:00 | 2018-01-31 00:00:00 | 2020-03-18 00:00:00 | 2020-10-30 00:00:00 | 2020-12-21 00:00:00 | 2016-01-27 00:00:00 | 2015-10-22 00:00:00 | 2016-04-21 00:00:00 | 2016-07-29 00:00:00 | 2016-10-25 00:00:00 | 2017-01-12 00:00:00 | 2017-01-12 00:00:00 | 2016-12-13 00:00:00 | 2016-12-21 00:00:00 | 2017-04-21 00:00:00 | 2017-03-16 00:00:00 | 2017-03-23 00:00:00 | 2017-07-25 00:00:00 | 2018-10-24 00:00:00 | 2018-12-28 00:00:00 | 2019-01-31 00:00:00 | 2018-07-26 00:00:00 | 2019-04-26 00:00:00 | 2019-10-30 00:00:00 | 2018-04-25 00:00:00 | 2020-04-27 00:00:00 | 2021-01-27 00:00:00 | 2018-12-26 00:00:00 | 2019-07-31 00:00:00 | 2020-07-31 00:00:00 | 2017-10-26 00:00:00 | 2021-06-14 00:00:00 | 2020-03-30 00:00:00 | 2021-07-06 00:00:00 | 2022-04-22 00:00:00 | 2022-02-10 00:00:00 | 2022-02-10 00:00:00 | 2021-07-13 00:00:00 | 2022-09-28 00:00:00 | 2021-04-20 00:00:00 | 2022-07-21 00:00:00 | 2022-01-21 00:00:00 | 2021-10-12 00:00:00 | 2021-01-04 00:00:00 | 2022-04-12 00:00:00 | 2022-07-28 00:00:00 | 2022-10-19 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10005 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10006 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10005 | 10001 | 10002 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10002 | 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 | 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 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2013 | 2013 | 2015 | 2013 | 2013 | 2015 | 2015 | 2015 | 2013 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2011 | 2011 | 2013 | 2013 | 2019 | 2017 | 2019 | 2019 | 2021 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2021 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | AGLADNEY | ASAETERN | JINGRAM | AGLADNEY | AGLADNEY | PBANFORD | JINGRAM | PBANFORD | AGLADNEY | YRODRIGU | SMCCONNAN | JINGRAM | ASAETERN | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | ASAETERN | SBROWN | YRODRIGU | SMCCONNAN | GTAYLOR | AGLADNEY | AROJAS | GTAYLOR | MMERCHANT | AGLADNEY | JINGRAM | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | YRODRIGU | YRODRIGU | SMCCONNAN | GPEREZ | GPEREZ | SMCCONNAN | JFRONEFIELD | SARRIAGA | AGLADNEY | AGLADNEY | SUSHAKOV | AROJAS | AGLADNEY | VUKSTINA | MKIRKHAM | SARRIAGA | VUKSTINA | CVANLIEW | SMCCONNAN | CVANLIEW | AROJAS | CVANLIEW | CAFILER | CAFILER | GTAYLOR | CHATRIDGE | CAFILER | GTAYLOR | CAFILER | RATTIYEH | GTAYLOR | MMERCHANT | GTAYLOR | 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 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 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 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 2013-01-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2014-01-01 00:00:00 | 2014-04-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-01 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 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2013-07-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-13 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-10-01 00:00:00 | 2017-10-01 00:00:00 | 2020-03-16 00:00:00 | 2020-07-01 00:00:00 | 2020-12-21 00:00:00 | 2015-10-01 00:00:00 | 2015-07-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | None | 2016-12-13 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-03-23 00:00:00 | 2017-04-01 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-04-01 00:00:00 | 2019-01-01 00:00:00 | 2019-07-01 00:00:00 | 2018-01-01 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 2018-12-26 00:00:00 | 2019-04-01 00:00:00 | 2020-04-01 00:00:00 | 2017-07-01 00:00:00 | 2021-06-14 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-01-01 00:00:00 | 2020-10-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-10-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2021-07-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 2013-03-31 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2014-03-31 00:00:00 | 2014-06-30 00:00:00 | 1900-01-01 00:00:00 | 2015-03-31 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 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2013-09-30 00:00:00 | 2014-12-31 00:00:00 | 2014-11-13 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-12-31 00:00:00 | 2017-12-31 00:00:00 | 2020-03-16 00:00:00 | 2020-09-30 00:00:00 | 2020-12-21 00:00:00 | 2015-12-31 00:00:00 | 2015-09-30 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | None | 2016-12-13 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-03-23 00:00:00 | 2017-06-30 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2018-06-30 00:00:00 | 2019-03-31 00:00:00 | 2019-09-30 00:00:00 | 2018-03-31 00:00:00 | 2020-03-31 00:00:00 | 2020-12-21 00:00:00 | 2018-12-26 00:00:00 | 2019-06-30 00:00:00 | 2020-06-30 00:00:00 | 2017-09-30 00:00:00 | 2021-06-14 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-03-31 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-09-30 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 |
filer_id | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||||
active | Y | Y | Y | R | Y | Y | Y | Y | N | |||||||||
race | 0 | 0 | None | None | None | None | None | None | None | |||||||||
session_id | 2013 | 2011 | 2019 | 2019 | 2015 | 2021 | 2019 | 2017 | 2023 | |||||||||
category | 0 | 0 | None | None | None | None | None | None | None | |||||||||
category_type | 0 | 0 | None | None | None | None | None | None | None | |||||||||
sub_category | 0 | 0 | None | None | None | None | None | None | None | |||||||||
effect_dt | 2013-03-11 00:00:00 | 2011-01-01 00:00:00 | 2020-03-30 00:00:00 | 2019-06-30 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 | 0 | 0 | None | None | None | None | None | None | None | |||||||||
election_type | 0 | 0 | None | None | None | None | None | None | None | |||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | |||||||||
nyq_dt | None | None | None | None | None | None | None | None | None | |||||||||
party_cd | 0 | 0 | None | None | None | None | None | None | None | |||||||||
county_cd | 0 | 0 | None | None | None | None | None | None | None | |||||||||
district_cd | 0 | 0 | None | None | None | None | None | None | None |
filer_id | 1334279 | |
---|---|---|
xref_id | 1334279 | |
effect_dt | 2010-12-15 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA E. | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 95691 | 95814 | 95814 | 95814 | 95691 | 95814 | 95814 | 95814 | 95691 | 95814 | 95814 | 95691 | 95814 | 95691 | 95814 | 95814 | 95814 | 95691 | 95814 | 95814 | 95814 | 95691 | 95814 | 95814 | 95691 | 95814 | 95691 | 95814 | 95814 | 95814 | 95691 | 95814 | 95814 | 95814 | 95691 | 95814 | 95814 | 95691 | 95814 | 95691 | 95814 | 95814 | 95814 | 95691 | 95814 | 95814 | 95814 | 95691 | 95814 | 95814 | 95691 | 95814 | 95691 | 95814 | 95814 | 95814 | 95691 | 95814 | 95814 | 95814 | 95691 | 95814 | 95814 | 95691 | 95814 | 95691 | 95814 | 95814 | 95814 | 95691 | 95814 | 95814 | 95814 | 95691 | 95814 | 95814 | 95691 | 95814 | 95691 | 95814 | 95814 | 95814 | 95691 | 95814 | 95814 | 95814 | 95691 | 95814 | 95814 | 95691 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9163134522 | 9167125781 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9163134522 | 9167125781 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9163134522 | 9167125781 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9163134522 | 9167125781 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9163134522 | 9167125781 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9163134522 | 9167125781 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9163134522 | 9167125781 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164481789 | 9164481789 | 9164481789 | 9164481789 | 9164481789 | 9164481789 | 9164481789 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[email protected] | None | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None | None | None | None | None |
filer_id | 1334279 |
---|
filer_id | 1334279 | 1334279 | 1334279 | |||
---|---|---|---|---|---|---|
change_no | 1 | 0 | 2 | |||
session_id | 2011 | 2013 | 2017 | |||
log_dt | 2013-04-25 00:00:00 | 2013-03-11 00:00:00 | 2017-04-04 00:00:00 | |||
filer_type | 4 | 4 | 4 | |||
correction_flg | None | Y | Y | |||
action | DELETED | ADDED | DELETED | |||
attribute_changed | EMPLOYER | EMPLOYER | EMPLOYER | |||
ethics_dt | None | None | None | |||
interests | None | None | None | |||
filer_full_name | JENA E. PRICE | PRICE, JENA E. | PRICE, JENA E. | |||
filer_city | None | None | SACRAMENTO | |||
filer_st | None | None | CA | |||
filer_zip | None | None | 95814 | |||
filer_phone | None | None | 9167125781 | |||
entity_type | 2 | 2 | 2 | |||
entity_name | PLANNING AND CONSERVATION LEAGUE | CALIFORNIA LEAGUE OF CONSERVATION VOTERS | CALIFORNIA LEAGUE OF CONSERVATION VOTERS | |||
entity_city | None | None | None | |||
entity_st | None | None | None | |||
entity_zip | None | None | None | |||
entity_phone | None | None | None | |||
entity_id | 1146778 | 1144446 | None | |||
responsible_officer | None | None | None | |||
effect_dt | 2012-10-01 00:00:00 | 2013-03-11 00:00:00 | 2017-04-04 00:00:00 |
filer_id | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | 1334279 | |||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 2147885_0.cal | 2152339_0.cal | 2110713_0.cal | 1914900_0.cal | 298251.cal | 298491.cal | 2171415_0.cal | 2211232_0.cal | 2329642_1.cal | 2467956_0.cal | 2311915_0.cal | 2399520_0.cal | 2486109_0.cal | 2417960_0.cal | 2437919_0.cal | 2270179_0.cal | 2350172_0.cal | 2236555_0.cal | 2329642_0.cal | 2377805_0.cal | 2190961_0.cal | 2527353_0.cal | 2537762_0.cal | 2548219_0.cal | 2669070_0.cal | 2548219_1.cal | 2736377_0.cal | 2575607_1.cal | 2537762_1.cal | 2575607_0.cal | 2592780_1.cal | 2615482_1.cal | 2592780_0.cal | 2699798_0.cal | 2636304_0.cal | 2636304_1.cal | 2615482_0.cal | |||||||||||||||||||||||||||||||||||||
received_date | 2017-03-23 00:00:00 | 2017-04-21 00:00:00 | 2016-12-13 00:00:00 | 2014-11-13 00:00:00 | 2017-05-24 00:00:00 | 2017-05-24 00:00:00 | 2017-07-25 00:00:00 | 2018-01-31 00:00:00 | 2020-03-18 00:00:00 | 2020-04-27 00:00:00 | 2018-10-24 00:00:00 | 2019-07-31 00:00:00 | 2020-07-31 00:00:00 | 2019-10-30 00:00:00 | 2020-01-29 00:00:00 | 2018-07-26 00:00:00 | 2019-01-31 00:00:00 | 2018-04-25 00:00:00 | 2018-12-26 00:00:00 | 2019-04-26 00:00:00 | 2017-10-26 00:00:00 | 2020-10-30 00:00:00 | 2020-12-21 00:00:00 | 2021-01-27 00:00:00 | 2022-04-22 00:00:00 | 2022-02-10 00:00:00 | 2022-10-19 00:00:00 | 2022-02-10 00:00:00 | 2021-06-14 00:00:00 | 2021-04-20 00:00:00 | 2022-04-12 00:00:00 | 2022-07-28 00:00:00 | 2021-07-13 00:00:00 | 2022-07-21 00:00:00 | 2022-01-21 00:00:00 | 2022-09-28 00:00:00 | 2021-10-12 00:00:00 | |||||||||||||||||||||||||||||||||||||
filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /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 | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||||||||||||||
filing_id | 2147885 | 2152339 | 2110713 | 1914900 | None | None | 2171415 | 2211232 | 2329642 | 2467956 | 2311915 | 2399520 | 2486109 | 2417960 | 2437919 | 2270179 | 2350172 | 2236555 | 2329642 | 2377805 | 2190961 | 2527353 | 2537762 | 2548219 | 2669070 | 2548219 | 2736377 | 2575607 | 2537762 | 2575607 | 2592780 | 2615482 | 2592780 | 2699798 | 2636304 | 2636304 | 2615482 | |||||||||||||||||||||||||||||||||||||
form_id | F604 | F615 | F604 | F604 | None | None | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | 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 | Filing accepted |