filing_id | 1326701 | 1346944 | 1372284 | 1419249 | 1449108 | 1393129 | 1431670 | 1533945 | 1500430 | 1460594 | 1482346 | 1564828 | 1619024 | 1588335 | 1602800 | 1632123 | 1702119 | 1673604 | 1654599 | 1733341 | 1794275 | 1780465 | 1780465 | 1761834 | 1902201 | 1928166 | 1974248 | 1963265 | 2005304 | 1995335 | 2057793 | 2088469 | 2030054 | 2168256 | 2150890 | 2120527 | 2189210 | 2277273 | 2202589 | 2240403 | 2321210 | 2381566 | 2350814 | 2399989 | 2443859 | 2420176 | 2471513 | 2487989 | 2532050 | 2555081 | 2625300 | 2603765 | 2580700 | 2645052 | 2708459 | 2678351 | 2749112 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_type | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sender_id | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_naml | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | California Ground Water Association | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | California Ground Water Association | California Ground Water Association | California Ground Water Association | California Ground Water Association | California Ground Water Association | California Ground Water Association | California Ground Water Association | California Ground Water Association | California Ground Water Association | California Ground Water Association | California Ground Water Association | California Ground Water Association | California Ground Water Association | California Ground Water Association | California Ground Water Association | California Ground Water Association | California Ground Water Association | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
report_num | 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 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2008-04-24 00:00:00 | 2008-07-28 00:00:00 | 2008-10-27 00:00:00 | 2009-04-28 00:00:00 | 2009-10-22 00:00:00 | 2009-01-28 00:00:00 | 2009-07-20 00:00:00 | 2010-10-25 00:00:00 | 2010-07-14 00:00:00 | 2010-01-26 00:00:00 | 2010-04-26 00:00:00 | 2011-01-24 00:00:00 | 2011-10-24 00:00:00 | 2011-04-26 00:00:00 | 2011-07-25 00:00:00 | 2012-01-26 00:00:00 | 2012-10-24 00:00:00 | 2012-07-23 00:00:00 | 2012-04-25 00:00:00 | 2013-01-28 00:00:00 | 2013-10-15 00:00:00 | 2013-10-29 00:00:00 | 2013-07-30 00:00:00 | 2013-04-25 00:00:00 | 2014-10-22 00:00:00 | 2015-01-22 00:00:00 | 2015-07-14 00:00:00 | 2015-04-28 00:00:00 | 2016-01-21 00:00:00 | 2015-10-28 00:00:00 | 2016-07-25 00:00:00 | 2016-10-13 00:00:00 | 2016-04-20 00:00:00 | 2017-07-18 00:00:00 | 2017-04-12 00:00:00 | 2017-01-18 00:00:00 | 2017-10-20 00:00:00 | 2018-07-31 00:00:00 | 2018-01-17 00:00:00 | 2018-04-29 00:00:00 | 2018-10-31 00:00:00 | 2019-04-30 00:00:00 | 2019-01-31 00:00:00 | 2019-07-31 00:00:00 | 2020-01-31 00:00:00 | 2019-10-31 00:00:00 | 2020-04-30 00:00:00 | 2020-07-31 00:00:00 | 2020-11-02 00:00:00 | 2021-02-01 00:00:00 | 2021-11-01 00:00:00 | 2021-08-02 00:00:00 | 2021-04-30 00:00:00 | 2022-01-31 00:00:00 | 2022-08-01 00:00:00 | 2022-05-02 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
from_date | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2009-01-01 00:00:00 | 2009-07-01 00:00:00 | 2008-10-01 00:00:00 | 2009-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-04-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2010-10-01 00:00:00 | 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 | 2012-10-01 00:00:00 | 2013-07-01 00:00:00 | 2013-04-01 00:00:00 | 2013-04-01 00:00:00 | 2013-01-01 00:00:00 | 2014-07-01 00:00:00 | 2014-10-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-10-01 00:00:00 | 2015-07-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-01-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 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2018-10-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-04-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
thru_date | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2009-03-31 00:00:00 | 2009-09-30 00:00:00 | 2008-12-31 00:00:00 | 2009-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-06-30 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2010-12-31 00:00:00 | 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 | 2012-12-31 00:00:00 | 2013-09-30 00:00:00 | 2013-06-30 00:00:00 | 2013-06-30 00:00:00 | 2013-03-31 00:00:00 | 2014-09-30 00:00:00 | 2014-12-31 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2015-12-31 00:00:00 | 2015-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-03-31 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 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2018-12-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-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cum_beg_dt | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 1261531 | None | None | 1261531 | 1261531 | 1261531 | 1261531 | 1261531 | 1261531 | 1261531 | 1261531 | 1261531 | 1261531 | 1261531 | 1261531 | 1261531 | 1261531 | 1261531 | 1261531 | 1261531 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Plasma Protein Therapeutics Association | None | None | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | Plasma Protein Therapeutics Association | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_city | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SACRAMENTO | SACRAMENTO | SANTA ROSA | SACRAMENTO | Sacramento | SACRAMENTO | SACRAMENTO | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_zip4 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 95811 | 95811 | 954026369 | 95811 | 95814 | 95811 | 95811 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_phon | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 9162312134 | 9162312134 | 7075784408 | 9162312134 | 916-231-2134 | 9162312134 | 9162312134 | 916-231-2134 | 916-231-2134 | 916-231-2134 | 916-231-2134 | 916-231-2134 | 916-231-2134 | 916-231-2134 | 916-231-2134 | 916-231-2134 | 916-231-2134 | 916-231-2134 | 916-231-2134 | 916-231-2134 | 916-231-2134 | 916-231-2134 | 916-231-2134 | 916-231-2134 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_date | 2008-04-14 00:00:00 | 2008-07-14 00:00:00 | 2008-10-09 00:00:00 | 2009-04-13 00:00:00 | 2009-10-20 00:00:00 | 2009-01-23 00:00:00 | 2009-07-13 00:00:00 | 2010-10-12 00:00:00 | 2010-07-09 00:00:00 | 2009-01-13 00:00:00 | 2010-04-20 00:00:00 | 2011-01-12 00:00:00 | 2011-10-11 00:00:00 | 2011-04-14 00:00:00 | 2011-07-12 00:00:00 | 2012-01-11 00:00:00 | 2012-10-09 00:00:00 | 2012-07-12 00:00:00 | 2012-04-17 00:00:00 | 2013-01-10 00:00:00 | 2013-10-09 00:00:00 | 2013-10-29 00:00:00 | 2017-07-11 00:00:00 | 2013-04-11 00:00:00 | 2014-10-09 00:00:00 | 2015-01-07 00:00:00 | 2015-07-10 00:00:00 | 2015-04-16 00:00:00 | 2016-01-14 00:00:00 | 2015-10-21 00:00:00 | 2016-07-19 00:00:00 | 2016-10-06 00:00:00 | 2016-04-11 00:00:00 | 2017-07-10 00:00:00 | 2017-04-06 00:00:00 | 2017-01-12 00:00:00 | 2017-10-12 00:00:00 | 2018-07-30 00:00:00 | 2017-01-16 00:00:00 | 2018-04-16 00:00:00 | 2018-10-29 00:00:00 | 2019-04-26 00:00:00 | 2019-01-28 00:00:00 | 2019-07-22 00:00:00 | 2020-01-28 00:00:00 | 2019-10-24 00:00:00 | 2020-04-22 00:00:00 | 2020-07-29 00:00:00 | 2020-10-31 00:00:00 | 2021-01-28 00:00:00 | 2021-10-26 00:00:00 | 2021-07-30 00:00:00 | 2021-04-27 00:00:00 | 2022-01-26 00:00:00 | 2022-07-28 00:00:00 | 2022-04-29 00:00:00 | 2022-10-29 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_loc | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Santa Rosa, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_naml | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Hofer | Hofer | Hofer | Hofer | Hofer | Hofer | Hofer | Hofer | Hofer | Cardwell | Cardwell | Cardwell | Cardwell | Cardwell | Cardwell | Cardwell | Cardwell | Schulenberg | Cardwell | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namf | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | j. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | John | John | John | John | John | John | John | John | John | Elizabeth | Elizabeth | Elizabeth | Elizabeth | Elizabeth | Elizabeth | Elizabeth | Elizabeth | David | Elizabeth | David | David | David | David | David | David | David | David | David | David | David | David | David | David | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_naml | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Mortensson | Hofer | Hofer | Hofer | Hofer | Hofer | Hofer | Hofer | Hofer | Hofer | Cardwell | Cardwell | Cardwell | Cardwell | Cardwell | Cardwell | Cardwell | Cardwell | Schulenberg | Cardwell | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | Schulenberg | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_namf | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | j. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | J. Michael | John | John | John | John | John | John | John | John | John | Elizabeth | Elizabeth | Elizabeth | Elizabeth | Elizabeth | Elizabeth | Elizabeth | Elizabeth | David | Elizabeth | David | David | David | David | David | David | David | David | David | David | David | David | David | David | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_title | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopart1_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopart2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
part1_1_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
part1_2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_n_cb | X | X | X | X | X | X | X | X | X | None | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_y_cb | None | None | None | None | None | None | None | None | None | X | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | No specifically lobbied legislations or actions. | AB2270 | AB2270, SB1338 | California Air Resources Board - diesel regulations State Water Resources Control Board - septic tank regulations SB133 | California Air Resources Board - diesel regulations AB1366, AB1416 | California Air Resources Board - diesel regulations | California Air Resources Board - diesel regulations AB356, AB1366 | AB2304, AB2515, SB918, SB1254, SB1402, budget - sales taxes on services | AB2304, SB918 | California Air Resources Board - diesel regulations, AB1416 | California Air Resources Board - diesel regulations | No actively lobbied legislation or actions. | SB263, AB720, AB780, AB228, AB1210 | SB263 | SB263 | No specifically lobbied legislation or actions | AB2339 | AB2339, SB962, SB1146 | AB2339, SB962, SB1146 | No specifically lobbied legislation or actions. | SB176, AB119 | SB176, AB119 | SB176, AB119 | No specifically lobbied legislation or actions | AB1739, SB757, SB1168 | No specifically lobbied legislation or actions. | No specifically lobbied legislation or actions. | No specifically lobbied legislation or actions. | No specifically lobbied legislation or actions. | No specifically lobbied legislation or actions. | AB2124, SB995, SB1317, Budget - Human Right to Water | SB995, SB1317 | SB995, SB1317 | SB252, SB640 | No specifically lobbied actions or legislation | No specifically lobbied actions or legislation | SB252 | Bills lobbied: AB 2940 AB 2365 | No specifically lobbied actions or legislation | No specifically lobbied actions or legislation | No reportable activity. | No reportable activity. | No reportable activity. | No reportable activity. | No reportable activity. | No reportable activity. | Lobbied: AB 2488, AB 2509, AB 2560, SB 1056 | No reportable activity. | No reportable activity. | No reportable activity. | No reportable activity. | No reportable activity. | No reportable activity. | No reportable activity. | Bills lobbied: AB 1642, AB 2201. | No reportable activity. | Bills lobbied: AB 1642, AB 2201. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lobby_n_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lobby_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rcpcmte_nm | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rcpcmte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filing_id | 1385921 | 1553325 | 1742325 | 1921033 | 2112935 | 2116033 | 2329736 | 2541754 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||
form_type | F602 | F602 | F602 | F602 | F602 | F602 | F602 | F602 | ||||||||
sender_id | F24715 | F24715 | F24715 | F24715 | F24715 | F24890 | 1357171 | 1357171 | ||||||||
filer_id | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | ||||||||
entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | ||||||||
filer_naml | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER COALITION | California Groundwater Association | California Groundwater Association | ||||||||
filer_namf | None | None | None | None | None | None | None | None | ||||||||
filer_namt | None | None | None | None | None | None | None | None | ||||||||
filer_nams | None | None | None | None | None | None | None | None | ||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | ||||||||
rpt_date | 2008-12-29 00:00:00 | 2010-12-22 00:00:00 | 2013-02-04 00:00:00 | 2014-12-29 00:00:00 | 2016-12-21 00:00:00 | 2016-12-30 00:00:00 | 2018-12-27 00:00:00 | 2020-12-31 00:00:00 | ||||||||
ls_beg_yr | 2009 | 2011 | 2013 | 2015 | 2017 | 2017 | 2019 | 2021 | ||||||||
ls_end_yr | 2010 | 2012 | 2014 | 2016 | 2018 | 2018 | 2020 | 2022 | ||||||||
qual_date | None | None | None | None | None | None | None | None | ||||||||
eff_date | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-02-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | ||||||||
bus_city | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | ||||||||
bus_st | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||
bus_zip4 | 954026369 | 954026369 | 954026369 | 954026369 | 95811 | 95814 | 95814 | 95814 | ||||||||
bus_phon | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 9162312134 | 9165949700 | 9162312134 | 916-231-2134 | ||||||||
bus_fax | None | None | None | None | None | None | None | None | ||||||||
bus_email | None | None | None | None | None | [email protected] | None | None | ||||||||
mail_city | None | None | None | None | None | None | None | None | ||||||||
mail_st | None | None | None | None | None | None | None | None | ||||||||
mail_zip4 | None | None | None | None | None | None | None | None | ||||||||
mail_phon | None | None | None | None | None | None | None | None | ||||||||
sig_date | 2008-11-10 00:00:00 | 2010-12-01 00:00:00 | 2013-01-28 00:00:00 | 2014-11-20 00:00:00 | 2016-12-01 00:00:00 | 2016-11-28 00:00:00 | 2018-12-19 00:00:00 | 2020-12-14 00:00:00 | ||||||||
sig_loc | None | None | None | None | None | None | None | Sacramento, CA | ||||||||
sig_naml | Mortensson | Mortensson | Mortensson | Hofer | Hofer | MANNING | Schulenberg | Schulenberg | ||||||||
sig_namf | J. Michael | J. Michael | J. Michael | John K. | John K. | KEN | David | David | ||||||||
sig_namt | None | None | None | None | None | None | None | None | ||||||||
sig_nams | None | None | None | None | None | None | None | None | ||||||||
prn_naml | Mortensson | Mortensson | Mortensson | Hofer | Hofer | MANNING | Schulenberg | Schulenberg | ||||||||
prn_namf | J. Michael | J. Michael | J. Michael | John K. | John K. | KEN | David | David | ||||||||
prn_namt | None | None | None | None | None | None | None | None | ||||||||
prn_nams | None | None | None | None | None | None | None | None | ||||||||
sig_title | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | PRESIDENT | Executive Director | Executive Director | ||||||||
stmt_firm | None | None | None | None | None | None | None | None | ||||||||
ind_cb | None | None | None | None | None | None | None | None | ||||||||
bus_cb | None | None | None | None | None | None | None | None | ||||||||
trade_cb | X | X | X | X | X | None | X | X | ||||||||
oth_cb | None | None | None | None | None | X | None | None | ||||||||
a_b_name | None | None | None | None | None | None | None | California Groundwater Association | ||||||||
a_b_city | None | None | None | None | None | None | None | Sacramento | ||||||||
a_b_st | None | None | None | None | None | None | None | CA | ||||||||
a_b_zip4 | None | None | None | None | None | None | None | 95814 | ||||||||
descrip_1 | groundwater professionals | groundwater professionals | groundwater professionals | groundwater professionals | groundwater professionals | COALITION TO EDUCATE POLICY MAKERS ABOUT CALIFORNIA GROUNDWATER AND ADVOCATE FOR FUNDING OF GROUNDWATER PROGRAMS. | Drilling | Drilling | ||||||||
descrip_2 | groundwater professionals, well drillers | groundwater professionals, well drillers | groundwater professionals, well drillers | groundwater professionals, well drillers | groundwater professionals, well drillers | WATER AGENCIES, UTILITIES, ASSOCIATIONS AND BUSINESSES | Groundwater well drilling | Groundwater well drilling | ||||||||
c_less50 | None | None | None | None | None | None | None | None | ||||||||
c_more50 | X | X | X | X | X | None | X | X | ||||||||
ind_class | OTH | OTH | OTH | OTH | OTH | GOV | OTH | OTH | ||||||||
ind_descr | groundwater | groundwater | groundwater | water | water | None | Water well drilling | Water well drilling | ||||||||
bus_class | None | None | None | None | None | None | None | None | ||||||||
bus_descr | None | None | None | None | None | None | None | None | ||||||||
auth_name | Pete Conaty & Associates | Pete Conaty & Associates | Pete Conaty & Associates | Pete Conaty & Associates | Pete Conaty & Associates | BROWNSTEIN HYATT FARBER SCHRECK, LLP | Churchwell White LLP | Churchwell White LLC | ||||||||
auth_city | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | SACRAMENTO | Sacramento | Sacramento | ||||||||
auth_st | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||
auth_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||
lobby_int | None | None | None | None | None | None | None | None | ||||||||
influen_yn | None | None | None | None | None | None | None | None | ||||||||
firm_name | None | None | None | None | None | None | None | None | ||||||||
newcert_cb | None | None | None | None | None | None | None | None | ||||||||
rencert_cb | None | None | None | None | None | None | None | None | ||||||||
complet_dt | None | None | None | None | None | None | None | None | ||||||||
lby_reg_cb | None | None | None | None | None | None | None | None | ||||||||
lby_604_cb | None | None | None | None | None | None | None | None | ||||||||
st_leg_yn | None | None | None | None | None | None | None | None | ||||||||
st_agency | None | None | None | None | None | None | None | None | ||||||||
lobby_cb | None | None | None | None | None | None | None | None | ||||||||
l_firm_cb | None | None | None | None | None | None | None | None |
filer_id | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2134570 | 2162931 | 2207492 | 2415714 | 2515898 | 2275860 | 2551746 | 2342645 | 2472380 | |||||||||
effect_dt | 2008-03-10 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2013-02-01 00:00:00 | 2023-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | |||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||
session_id | 2007 | 2009 | 2011 | 2017 | 2021 | 2013 | 2023 | 2015 | 2019 |
filer_id | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1780465 | 1760247 | 1963265 | 1974248 | 1780465 | 1794275 | 1928166 | 1921033 | 1950730 | 1878795 | 1902201 | 1318125 | 1326701 | 1346944 | 1318123 | 1372284 | 1385921 | 1393129 | 1411379 | 1431670 | 1419249 | 1449108 | 1460594 | 1482346 | 1500430 | 1533945 | 1557180 | 1564828 | 1588335 | 1553325 | 1602800 | 1632123 | 1619024 | 1654599 | 1673604 | 1702119 | 1742325 | 1733341 | 1761834 | 1995335 | 2487989 | 2189210 | 2240403 | 2399989 | 2005304 | 2030054 | 2057793 | 2088469 | 2120527 | 2112935 | 2116033 | 2131909 | 2150890 | 2168256 | 2202589 | 2204846 | 2350814 | 2277273 | 2360757 | 2532050 | 2443859 | 2555081 | 2420176 | 2223834 | 2471513 | 2381566 | 2321210 | 2541754 | 2329736 | 2603765 | 2580700 | 2625300 | 2708459 | 2645052 | 2570212 | 2678351 | 2749112 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 214 | None | 221 | 222 | 214 | 215 | 220 | 220 | None | None | 219 | None | 193 | 194 | None | 195 | 196 | 196 | None | 198 | 197 | 199 | 200 | 201 | 202 | 203 | None | 204 | 205 | 204 | 206 | 208 | 207 | 209 | 210 | 211 | 213 | 212 | 213 | 223 | 242 | 231 | 233 | 238 | 224 | 225 | 226 | 227 | 228 | 228 | 228 | None | 229 | 230 | 232 | None | 236 | 234 | None | 243 | 240 | 244 | 239 | None | 241 | 237 | 235 | 244 | 236 | 246 | 245 | 247 | 250 | 248 | None | 249 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F635 | F999 | F635 | F635 | F602 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 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 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2013-07-30 00:00:00 | 2013-02-04 00:00:00 | 2015-04-28 00:00:00 | 2015-07-14 00:00:00 | 2013-10-29 00:00:00 | 2013-10-15 00:00:00 | 2015-01-22 00:00:00 | 2014-12-29 00:00:00 | 2014-12-29 00:00:00 | 2014-07-23 00:00:00 | 2014-10-22 00:00:00 | 2008-03-14 00:00:00 | 2008-04-24 00:00:00 | 2008-07-28 00:00:00 | 2008-03-13 00:00:00 | 2008-10-27 00:00:00 | 2008-12-29 00:00:00 | 2009-01-28 00:00:00 | 2008-12-29 00:00:00 | 2009-07-20 00:00:00 | 2009-04-28 00:00:00 | 2009-10-22 00:00:00 | 2010-01-26 00:00:00 | 2010-04-26 00:00:00 | 2010-07-14 00:00:00 | 2010-10-25 00:00:00 | 2010-12-21 00:00:00 | 2011-01-24 00:00:00 | 2011-04-26 00:00:00 | 2010-12-22 00:00:00 | 2011-07-25 00:00:00 | 2012-01-26 00:00:00 | 2011-10-24 00:00:00 | 2012-04-25 00:00:00 | 2012-07-23 00:00:00 | 2012-10-24 00:00:00 | 2013-02-04 00:00:00 | 2013-01-28 00:00:00 | 2013-04-25 00:00:00 | 2015-10-28 00:00:00 | 2020-07-31 00:00:00 | 2017-10-20 00:00:00 | 2018-04-29 00:00:00 | 2019-07-31 00:00:00 | 2016-01-21 00:00:00 | 2016-04-20 00:00:00 | 2016-07-25 00:00:00 | 2016-10-13 00:00:00 | 2017-01-18 00:00:00 | 2016-12-21 00:00:00 | 2016-12-30 00:00:00 | 2016-12-21 00:00:00 | 2017-04-12 00:00:00 | 2017-07-18 00:00:00 | 2018-01-17 00:00:00 | 2018-01-22 00:00:00 | 2019-01-31 00:00:00 | 2018-07-31 00:00:00 | 2018-12-28 00:00:00 | 2020-11-02 00:00:00 | 2020-01-31 00:00:00 | 2021-02-01 00:00:00 | 2019-10-31 00:00:00 | 2018-03-20 00:00:00 | 2020-04-30 00:00:00 | 2019-04-30 00:00:00 | 2018-10-31 00:00:00 | 2020-12-31 00:00:00 | 2018-12-27 00:00:00 | 2021-08-02 00:00:00 | 2021-04-30 00:00:00 | 2021-11-01 00:00:00 | 2022-08-01 00:00:00 | 2022-01-31 00:00:00 | 2020-12-30 00:00:00 | 2022-05-02 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 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 | 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 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2013 | 2013 | 2015 | 2015 | 2013 | 2013 | 2013 | 2015 | 2015 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2013 | 2015 | 2019 | 2017 | 2017 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2017 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | AGLADNEY | SARRIAGA | AGLADNEY | AGLADNEY | ASAETERN | ASAETERN | AGLADNEY | GPEREZ | GPEREZ | PBANFORD | AGLADNEY | YRODRIGU | LTHIBAUL | YRODRIGU | YRODRIGU | JGRISSUM | * | JGRISSUM | SARRIAGA | JGRISSUM | JGRISSUM | MGUERRA | JINGRAM | ASAETERN | ASAETERN | ASAETERN | CREYNOLDS | AGLADNEY | AGLADNEY | * | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | SARRIAGA | ASAETERN | AGLADNEY | AGLADNEY | GTAYLOR | AGLADNEY | AGLADNEY | SUSHAKOV | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | GPEREZ | PBANFORD | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | DMCCASTL | GTAYLOR | AGLADNEY | GTAYLOR | SUSHAKOV | GPEREZ | SUSHAKOV | GTAYLOR | TRAMON | CVANLIEW | CAFILER | MKIRKHAM | GTAYLOR | CHATRIDGE | CAFILER | GTAYLOR | CVANLIEW | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 2013-04-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-04-01 00:00:00 | 2013-04-01 00:00:00 | 2013-07-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-29 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 1900-01-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 1900-01-01 00:00:00 | 2008-07-01 00:00:00 | 2008-12-29 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 2009-04-01 00:00:00 | 2009-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 2010-12-22 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2013-02-04 00:00:00 | 2012-10-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2020-04-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2019-04-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2016-12-21 00:00:00 | 2016-12-30 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-10-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-04-01 00:00:00 | 1900-01-01 00:00:00 | 2020-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-10-01 00:00:00 | 2019-07-01 00:00:00 | 1900-01-01 00:00:00 | 2020-01-01 00:00:00 | 2019-01-01 00:00:00 | 2018-07-01 00:00:00 | 2020-12-31 00:00:00 | 2018-12-27 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 1900-01-01 00:00:00 | 2022-01-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 | 2015-06-30 00:00:00 | 2013-06-30 00:00:00 | 2013-09-30 00:00:00 | 2014-12-31 00:00:00 | 2014-12-29 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 1900-01-01 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 1900-01-01 00:00:00 | 2008-09-30 00:00:00 | 2008-12-29 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 2009-06-30 00:00:00 | 2009-03-31 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2010-12-22 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2011-09-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2013-02-04 00:00:00 | 2012-12-31 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2020-06-30 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | 2019-06-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2016-12-21 00:00:00 | 2016-12-30 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2017-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2018-06-30 00:00:00 | 1900-01-01 00:00:00 | 2020-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2019-09-30 00:00:00 | 1900-01-01 00:00:00 | 2020-03-31 00:00:00 | 2019-03-31 00:00:00 | 2018-09-30 00:00:00 | 2020-12-31 00:00:00 | 2018-12-27 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2021-09-30 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 1900-01-01 00:00:00 | 2022-03-31 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 |
filer_id | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2007 | 2009 | 2013 | 2011 | 2019 | 2017 | 2017 | 2015 | 2021 | 2023 | ||||||||||
interest_cd | 40312 | 40312 | 40312 | 40312 | 40312 | 40315 | 40312 | 40312 | 40312 | 40312 | ||||||||||
effect_date | 2008-03-10 00:00:00 | 2009-01-01 00:00:00 | 2013-02-01 00:00:00 | 2011-01-01 00:00:00 | 2019-01-01 00:00:00 | 2018-01-03 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||
active | T | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | |||||||||||
race | None | None | None | 0 | None | None | None | None | None | None | None | |||||||||||
session_id | 2013 | 2013 | 2011 | 2007 | 2009 | 2013 | 2019 | 2021 | 2015 | 2017 | 2023 | |||||||||||
category | None | None | None | 0 | None | None | None | None | None | None | None | |||||||||||
category_type | None | None | None | 0 | None | None | None | None | None | None | None | |||||||||||
sub_category | None | None | None | 0 | None | None | None | None | None | None | None | |||||||||||
effect_dt | 2013-10-08 00:00:00 | 2013-02-01 00:00:00 | 2011-01-01 00:00:00 | 2008-03-10 00:00:00 | 2009-01-01 00:00:00 | 2014-07-16 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||
sub_category_type | None | None | None | 0 | None | None | None | None | None | None | None | |||||||||||
election_type | None | None | None | 0 | None | None | None | None | None | None | None | |||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
nyq_dt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
party_cd | None | None | None | 0 | None | None | None | None | None | None | None | |||||||||||
county_cd | None | None | None | 0 | None | None | None | None | None | None | None | |||||||||||
district_cd | None | None | None | 0 | None | None | None | None | None | None | None |
filer_id | 1304981 | |
---|---|---|
xref_id | 1304981 | |
effect_dt | 2008-03-14 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SANTA ROSA | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 95811 | 95814 | 95814 | 95814 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 95811 | 95814 | 95814 | 95814 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 95811 | 95814 | 95814 | 95814 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 95811 | 95814 | 95814 | 95814 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 95811 | 95814 | 95814 | 95814 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 95811 | 95814 | 95814 | 95814 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 95811 | 95814 | 95814 | 95814 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 95811 | 95814 | 95814 | 95814 | 954026369 | 954026369 | 954026369 | 954026369 | 954026369 | 95811 | 95814 | 95814 | 95814 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 9162312134 | 9162312134 | 9162312134 | 9162312134 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 9162312134 | 9162312134 | 9162312134 | 9162312134 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 9162312134 | 9162312134 | 9162312134 | 9162312134 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 9162312134 | 9162312134 | 9162312134 | 9162312134 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 9162312134 | 9162312134 | 9162312134 | 9162312134 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 9162312134 | 9162312134 | 9162312134 | 9162312134 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 9162312134 | 9162312134 | 9162312134 | 9162312134 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 9162312134 | 9162312134 | 9162312134 | 9162312134 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 7075784408 | 9162312134 | 9162312134 | 9162312134 | 9162312134 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | None | None | 9162312141 | None | None | None | None | None | 9162312141 | None | None | None | None | None | 9162312141 | None | None | None | None | None | 9162312141 | None | None | None | None | None | 9162312141 | None | None | None | None | None | 9162312141 | None | None | None | None | None | 9162312141 | None | None | None | None | None | 9162312141 | None | None | None | None | None | 9162312141 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | None | None | None |
filer_id | 1304981 |
---|
filer_id | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | 1304981 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 0 | 1 | 3 | 2 | 5 | 4 | 6 | 7 | ||||||||
session_id | 2007 | 2013 | 2013 | 2013 | 2017 | 2017 | 2017 | 2021 | ||||||||
log_dt | 2008-03-13 00:00:00 | 2013-10-08 00:00:00 | 2014-07-23 00:00:00 | 2013-02-04 00:00:00 | 2018-02-26 00:00:00 | 2018-01-22 00:00:00 | 2018-03-20 00:00:00 | 2020-12-30 00:00:00 | ||||||||
filer_type | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | ||||||||
correction_flg | Y | None | None | Y | None | Y | Y | None | ||||||||
action | ADDED | DELETED | SET ACTIVE | ADDED | DELETED | ADDED | ADDED | CHANGED | ||||||||
attribute_changed | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | RESPONSIBLE OFFICER | |||||||||
ethics_dt | None | None | None | None | None | None | None | None | ||||||||
interests | None | None | None | None | None | None | None | None | ||||||||
filer_full_name | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | CALIFORNIA GROUNDWATER ASSOCIATION | ||||||||
filer_city | None | None | None | SANTA ROSA | None | None | SANTA ROSA | None | ||||||||
filer_st | None | None | None | CA | None | None | CA | None | ||||||||
filer_zip | None | None | None | 954026369 | None | None | 954026369 | None | ||||||||
filer_phone | None | None | None | 7075784408 | None | None | 7075784408 | None | ||||||||
entity_type | 3 | 3 | 1 | 3 | 3 | 3 | 3 | 20 | ||||||||
entity_name | CONATY & ASSOCIATES; PETE | CONATY & ASSOCIATES; PETE | None | CONATY & ASSOCIATES; PETE | REEB GOVERNMENT RELATIONS, LLC | REEB GOVERNMENT RELATIONS, LLC | CHURCHWELL WHITE, LLC | EXECUTIVE DIRECTOR DAVID SCHULENBERG | ||||||||
entity_city | None | None | None | None | None | None | None | None | ||||||||
entity_st | None | None | None | None | None | None | None | None | ||||||||
entity_zip | None | None | None | None | None | None | None | None | ||||||||
entity_phone | None | None | None | None | None | None | None | None | ||||||||
entity_id | 1147595 | 1147595 | 0 | None | 1274075 | 1274075 | None | 1416033 | ||||||||
responsible_officer | None | None | None | None | None | None | None | None | ||||||||
effect_dt | 2008-03-10 00:00:00 | 2013-09-30 00:00:00 | 2014-07-16 00:00:00 | 2013-02-01 00:00:00 | 2018-02-28 00:00:00 | 2018-01-03 00:00:00 | 2018-03-01 00:00:00 | 2021-01-01 00:00:00 |
filer_id | 1304981 | 1304981 | 1304981 | 1304981 | ||||
---|---|---|---|---|---|---|---|---|
filing_file_name | 118505.cal | 118471.cal | 119149.cal | 325570.cal | ||||
received_date | 2018-04-30 00:00:00 | 2018-04-30 00:00:00 | 2018-04-30 00:00:00 | 2022-05-02 00:00:00 | ||||
filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | ||||
filing_id | None | None | None | None | ||||
form_id | None | None | None | None | ||||
receive_comment | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints |