filing_id | 1145952 | 1167280 | 1134172 | 1105305 | 1118648 | 1283359 | 1262503 | 1236122 | 1191175 | 1215907 | 1311471 | 1350520 | 1297506 | 1329654 | 1452721 | 1377411 | 1421572 | 1437187 | 1394976 | 1980676 | 2007083 | 1995298 | 2059235 | 2036118 | 2007083 | 2101311 | 2175363 | 2157394 | 2126832 | 2273537 | 2273537 | 2210164 | 2242559 | 2193668 | 2315068 | 2379498 | 2340548 | 2441794 | 2470211 | 2398959 | 2419114 | 2483106 | 2550414 | 2527702 | 2603017 | 2622458 | 2579836 | 2707024 | 2642987 | 2675318 | 2746222 | |||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | 1 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | |||||||||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||
filer_naml | City of Selma | City of Selma | City of Selma | City of Selma | City of Selma | SELMA; CITY OF | SELMA; CITY OF | City of Selma | City of Selma | City of Selma | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA, CITY OF | SELMA; CITY OF | SELMA, CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 001 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2006-01-29 00:00:00 | 2006-04-30 00:00:00 | 2005-10-31 00:00:00 | 2005-05-02 00:00:00 | 2005-08-01 00:00:00 | 2007-07-30 00:00:00 | 2007-04-30 00:00:00 | 2007-01-30 00:00:00 | 2006-07-31 00:00:00 | 2006-10-30 00:00:00 | 2008-01-31 00:00:00 | 2008-07-31 00:00:00 | 2007-10-31 00:00:00 | 2008-04-30 00:00:00 | 2009-11-02 00:00:00 | 2008-10-30 00:00:00 | 2009-04-30 00:00:00 | 2009-07-30 00:00:00 | 2009-01-30 00:00:00 | 2015-07-14 00:00:00 | 2016-01-12 00:00:00 | 2015-10-14 00:00:00 | 2016-07-21 00:00:00 | 2016-04-19 00:00:00 | 2016-02-01 00:00:00 | 2016-10-21 00:00:00 | 2017-07-31 00:00:00 | 2017-05-01 00:00:00 | 2017-01-17 00:00:00 | 2018-07-31 00:00:00 | 2018-07-30 00:00:00 | 2018-01-31 00:00:00 | 2018-04-30 00:00:00 | 2017-10-31 00:00:00 | 2018-10-29 00:00:00 | 2019-04-29 00:00:00 | 2019-01-25 00:00:00 | 2020-01-31 00:00:00 | 2020-04-30 00:00:00 | 2019-07-31 00:00:00 | 2019-10-31 00:00:00 | 2020-07-29 00:00:00 | 2021-01-29 00:00:00 | 2020-10-30 00:00:00 | 2021-08-02 00:00:00 | 2021-10-29 00:00:00 | 2021-04-29 00:00:00 | 2022-08-01 00:00:00 | 2022-01-31 00:00:00 | 2022-04-29 00:00:00 | 2022-10-29 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||
from_date | 2005-10-01 00:00:00 | 2006-01-01 00:00:00 | 2005-07-01 00:00:00 | 2005-01-01 00:00:00 | 2005-04-01 00:00:00 | 2007-04-01 00:00:00 | 2007-01-01 00:00:00 | 2006-10-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-01 00:00:00 | 2007-07-01 00:00:00 | 2008-01-01 00:00:00 | 2009-07-01 00:00:00 | 2008-07-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 2008-10-01 00:00:00 | 2015-04-01 00:00:00 | 2015-10-01 00:00:00 | 2015-07-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-07-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 2018-04-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2017-07-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | 2020-04-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||
thru_date | 2005-12-31 00:00:00 | 2006-03-31 00:00:00 | 2005-09-30 00:00:00 | 2005-03-31 00:00:00 | 2005-06-30 00:00:00 | 2007-06-30 00:00:00 | 2007-03-31 00:00:00 | 2006-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2007-09-30 00:00:00 | 2008-03-31 00:00:00 | 2009-09-30 00:00:00 | 2008-09-30 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 2008-12-31 00:00:00 | 2015-06-30 00:00:00 | 2015-12-31 00:00:00 | 2015-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-09-30 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 2018-06-30 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2017-09-30 00:00:00 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2019-06-30 00:00:00 | 2019-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||
cum_beg_dt | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-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 | 2007-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-04-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-04-01 00:00:00 | 2017-01-01 00:00:00 | 2018-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 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | None | None | 1276423 | 1276423 | 1276423 | None | None | None | None | None | None | None | None | None | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | None | None | 1276423 | None | 1276423 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
firm_name | City of Selma | City of Selma | City of Selma | City of Selma | City of Selma | None | None | City of Selma | City of Selma | City of Selma | None | None | None | None | None | None | None | None | None | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | None | None | SELMA, CITY OF | None | SELMA, CITY OF | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||
firm_city | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | SELMA | SELMA | Selma, CA | Selma, CA | Selma, CA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | |||||||||||||||||||||||||||||||||||||||||||||||||||
firm_st | 9 | 9 | 9 | 9 | 9 | CA | CA | 9 | 9 | 9 | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | 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 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | |||||||||||||||||||||||||||||||||||||||||||||||||||
firm_phon | (559) 999-3651 | (559) 999-3651 | (559) 999-3651 | (559) 999-3651 | (559) 999-3651 | 5598912200 | 5598912200 | (559) 999-3651 | (559) 999-3651 | (559) 999-3651 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5599993651 | 5598912200 | 5599993651 | 5599993651 | 5598912200 | (559) 891-2200 | (559) 891-2200 | (559) 891-2200 | (559) 891-2200 | (559) 891-2200 | (559) 891-2200 | (559) 891-2200 | 5598912200 | 5598912200 | (559) 891-2200 | 5598912200 | (559) 891-2200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 2006-01-26 00:00:00 | 2006-04-26 00:00:00 | 2005-10-31 00:00:00 | 2005-04-28 00:00:00 | 2005-07-26 00:00:00 | 2007-07-23 00:00:00 | 2007-04-26 00:00:00 | 2007-01-25 00:00:00 | 2006-07-26 00:00:00 | 2006-10-25 00:00:00 | 2008-01-24 00:00:00 | 2008-07-25 00:00:00 | 2007-10-26 00:00:00 | 2008-04-24 00:00:00 | 2009-10-22 00:00:00 | 2008-10-27 00:00:00 | 2009-04-22 00:00:00 | 2009-07-23 00:00:00 | 2009-01-26 00:00:00 | 2015-07-14 00:00:00 | 2016-01-12 00:00:00 | 2015-10-14 00:00:00 | 2016-07-21 00:00:00 | 2016-04-19 00:00:00 | 2016-02-01 00:00:00 | 2016-10-21 00:00:00 | 2017-07-31 00:00:00 | 2017-04-27 00:00:00 | 2017-01-17 00:00:00 | 2018-07-31 00:00:00 | 2018-07-30 00:00:00 | 2018-01-31 00:00:00 | 2018-04-30 00:00:00 | 2017-10-31 00:00:00 | 2018-10-29 00:00:00 | 2019-04-29 00:00:00 | 2019-01-25 00:00:00 | 2019-01-31 00:00:00 | 2020-04-30 00:00:00 | 2019-07-31 00:00:00 | 2019-10-31 00:00:00 | 2020-07-31 00:00:00 | 2021-01-31 00:00:00 | 2020-10-30 00:00:00 | 2021-08-02 00:00:00 | 2021-10-29 00:00:00 | 2021-04-30 00:00:00 | 2022-08-01 00:00:00 | 2022-01-31 00:00:00 | 2022-04-29 00:00:00 | 2022-10-29 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||
sig_loc | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | SELMA, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | SELMA, CA | SELMA, CA | Selma, CA | SELMA, CA | SELMA, CA | SELMA, CA | SELMA, CA | SELMA, CA | SELMA, CA | SELMA, CA | Selma, CA | SELMA, CA | SELMA, CA | SELMA, CA | SELMA, CA | SELMA, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | SELMA, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | Selma, CA | |||||||||||||||||||||||||||||||||||||||||||||||||||
sig_naml | Heusser | Heusser | Heusser | Heusser | Heusser | Heusser | HEUSSER | Heusser | Heusser | Heusser | Heusser | Heusser | Heusser | Heusser | Heusser | Heusser | HEUSSER | HEUSSER | Heusser | GREY | GREY | GREY | GARNER | GREY | GREY | GARNER | Elias | ELIAS | GARNER | PEREA | PEREA | PEREA | Perea | Elias | Gallavan | Gallavan | Gallavan | GALLAVAN | Gallavan | Gallavan | Gallavan | Gallavan | Gallavan | Gallavan | Jimenez | Jimenez | Gallavan | Santillan | Santillan | Santillan | Santillan | |||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namf | B. | B. | B. | B. | B. | D.B. | D.B. | B. | B. | B. | D.B. | D.B. | D. B. | D.B. | D. B. | D. B. | D.B. | D.B. | D. B. | KENNETH | KENNETH | KENNETH | GREG | KENNETH | KENNETH | GREG | David | DAVID | GREG | HENRY | HENRY | HENRY | Henry | David | Teresa | Teresa | Teresa | TERESA | Teresa | Teresa | Teresa | Teresa | Teresa | Teresa | Ralph | Ralph | Teresa | Fernando | Fernando | Fernando | Fernando | |||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namt | D. | D. | D. | D. | D. | None | None | D. | D. | D. | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | Heusser | Heusser | Heusser | Heusser | Heusser | Heusser | HEUSSER | Heusser | Heusser | Heusser | Heusser | Heusser | Heusser | Heusser | Heusser | Heusser | HEUSSER | HEUSSER | Heusser | GREY | GREY | GREY | GARNER | GREY | GREY | GARNER | Elias | ELIAS | GARNER | PEREA | PEREA | PEREA | Perea | Elias | Gallavan | Gallavan | Gallavan | GALLAVAN | Gallavan | Gallavan | Gallavan | Gallavan | Gallavan | Gallavan | Jimenez | Jimenez | Gallavan | Santillan | Santillan | Santillan | Santillan | |||||||||||||||||||||||||||||||||||||||||||||||||||
prn_namf | B. | B. | B. | B. | B. | D.B. | D.B. | B. | B. | B. | D.B. | D.B. | D. B. | D.B. | D. B. | D. B. | D.B. | D.B. | D. B. | KENNETH | KENNETH | KENNETH | GREG | KENNETH | KENNETH | GREG | David | DAVID | GREG | HENRY | HENRY | HENRY | Henry | David | Teresa | Teresa | Teresa | TERESA | Teresa | Teresa | Teresa | Teresa | Teresa | Teresa | Ralph | Ralph | Teresa | Fernando | Fernando | Fernando | Fernando | |||||||||||||||||||||||||||||||||||||||||||||||||||
prn_namt | D. | D. | D. | D. | D. | None | None | D. | D. | D. | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | City Manager | City Manager | City Manager | City Manager | City Manager | City Manager | CITY MANAGER | City Manager | City Manager | City Manager | City Manager | City Manager | City Manager | City Manager | City Manager | City Manager | CITY MANAGER | CITY MANAGER | City Manager | CITY MANAGER 425900SSB | CITY MANAGER 425900SSB | CITY MANAGER 425900SSB | INTERIM CITY MANAGER 425900SSB | CITY MANAGER 425900SSB | CITY MANAGER 425900SSB | INTERIM CITY MANAGER 425900SSB | City Manager | CITY MANAGER | INTERIM CITY MANAGER 425900SSB | Int. CITY MANAGER | INTERIM MANAGER 4259SSB | CITY MANAGER | City Manager | CITY MANAGER | City Manager | City Manager | City Manager | CITY MANAGER | City Manager | City Manager | City Manager | City Manager | City Manager | City Manager | Interim City Manager | City Manager | City Manager | City Manager | City Manager | City Manager | City Manager | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | X | None | X | X | None | None | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_y_cb | X | X | X | None | X | None | None | X | X | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||
lby_actvty | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None. | None | None | California State Legislature and Governors Office regarding: Gas Tax cut, Prop 1A cut and Prop 42 cut. | None | California Transportation Commission Re: Active Transportation Program. | California Transportation Commission RE: Active Transportation Program. | California Transportation Commission Re: Active Transportation Program. AB 113. | SEE ATTACHMENT A | State Legislature & Governors Office RE: Public Safety Infrastructure funding; State Water Resources Control Board RE: Storm Water Grant Program. | California Transportation Commission RE: Active Transportation Program. Legislature, Governors Office RE: Public safety infrastructure funding. | STATE LEGISLATURE, GOVERNORS OFFICE RE: PUBLIC SAFETY INFRASTRUCTURE FUNDING | Police Department infrastructure funding | Police Department infrastructure funding | Public safety infrastructure funding; state legislature and Governor's office | Department of Parks, Department of Transportation Public safety infrastructure funding | Department of Parks, Department of Transportation | Public safety and infrastructure funding | Public safety infrastructure funding opportunities; Department of parks | Public safety and infrastructure funding | Public safety infrastructure funding, Department of Finance, Department of Parks and Recreation, California Transportation Commission, and California Natural Resources Agency | Public safety infrastructure and municipal infrastructure funding. California Transportation Commission?Active Transportation Program; California Natural Resources Agency?Proposition 68; California Department of Parks and Recreation?Proposition 68; Department of Alcoholic Beverage Control?Law Enforcement Funding. | Public safety infrastructure funding, Department of Finance, Department of Parks and Recreation, California Transportation Commission, and California Natural Resources Agency | EIFD legislation; High Speed Rail Training Center; Municipal infrastructure funding; California Natural Resources Agency, Proposition 68; California Department of Parks and Recreation, Proposition 68; Department of Alcoholic Beverage Control, Law Enforcement Funding; Department of Justice,Tobacco Funding. | EIFD legislation SB1300; Infrastructure funding for Dinuba sewer main, Valley View Basin, Selma Fire Station and Selma Police Station; High Speed Rail Training Center; California Natural Resources Agency?Proposition 68; California Department of Parks and Recreation?Proposition 68; Department of Alcoholic Beverage Control?Law Enforcement Funding; Department of Justice?Tobacco Funding. | California Natural Resources Agency?Proposition 68; California Department of Parks and Recreation?Proposition 68; Department of Alcoholic Beverage Control?Law Enforcement Funding. // Police department infrastructure, water and sewer infrastructure funding opportunities. AB-74 Budget Act of 2019. | EIFD legislation; High Speed Rail Training Center; California Natural Resources Agency?Proposition 68; California Department of Parks and Recreation?Proposition 68; Department of Alcoholic Beverage Control?Law Enforcement Funding; Department of Justice?Tobacco Funding. | SB 808 - State Budget Act of 2020; EIFD legislation SB1300; Infrastructure funding for Dinuba sewer main, Valley View Basin, Selma Fire Station and Selma Police Station; High Speed Rail Training Center; Department of Housing and Community Development - Local Early Action Planning Grant Program. | AB 89 - State Budget Act of 2020; EIFD legislation SB1300; Municipal infrastructure funding opportunities; CalOES-Community Power Resiliency Allocation to Cities Program, CalRecycle Beverage Container Recycling Payment Program | AB 89 - State Budget Act of 2020; EIFD legislation SB1300; Municipal infrastructure funding opportunities State Water Resources Control Board - Storm Water Grant Program | Budget item(s) for sewer infrastructure, storm-water catchment, ponding basin and new fire station. Enhanced Infrastructure Financing District eligibility. SB 128; SB 129 | Budget item(s) for sewer infrastructure, storm-water catchment, ponding basin and new fire station. Enhanced Infrastructure Financing District eligibility. SB 128; SB 129 | Budget item(s) for sewer infrastructure, storm-water catchment, ponding basin and new fire station. Enhanced Infrastructure Financing District eligibility. Office of Traffic Safety - OTS Grant Program, Department of Parks and Recreation - Statewide Park Program, California Arts Council - General Operating Relief Program. | AB2780 Dissolution of redevelopment agencies: enhanced infrastructure financing districts: City of Selma; 2022-2023 State budget funding: Sewer infrastructure, Fire Department Infrastructure | Budget item(s) for sewer infrastructure, storm-water catchment, ponding basin and new fire station. Enhanced Infrastructure Financing District eligibility. SB 128; SB 129 | AB2780 Dissolution of redevelopment agencies: enhanced infrastructure financing districts: City of Selma; 2022-2023 State budget funding: Sewer infrastructure, Fire Department Infrastructure | AB2780 Dissolution of redevelopment agencies: enhanced infrastructure financing districts: City of Selma; 2022-2023 State budget funding: Sewer infrastructure, Fire Department Infrastructure | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | N/A | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1225870 | 1389322 | 1970006 | 2000459 | 2117818 | 2117817 | 2117819 | 2117820 | 2117821 | 2244346 | 2330485 | 2340357 | 2542741 | 2544267 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 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 | ||||||||||||||
form_type | F602 | F602 | F602 | F602 | F602 | F602 | F602 | F602 | F602 | F602 | F602 | F602 | F602 | F602 | ||||||||||||||
sender_id | 1275430 | 1275430 | F24882 | 1279189 | 1279189 | 1279189 | 1279189 | 1279189 | 1279189 | F24882 | 1279189 | F24882 | 1279189 | F24882 | ||||||||||||||
filer_id | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | ||||||||||||||
entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | ||||||||||||||
filer_naml | City of Selma | CITY OF SELMA | SELMA, CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA, CITY OF | SELMA; CITY OF | SELMA, CITY OF | SELMA; CITY OF | SELMA, CITY OF | ||||||||||||||
filer_namf | 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 | ||||||||||||||
filer_nams | 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 | ||||||||||||||
rpt_date | 2007-01-02 00:00:00 | 2009-01-14 00:00:00 | 2015-06-02 00:00:00 | 2015-12-02 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2018-05-01 00:00:00 | 2018-12-28 00:00:00 | 2018-11-09 00:00:00 | 2021-01-07 00:00:00 | 2020-12-31 00:00:00 | ||||||||||||||
ls_beg_yr | 2007 | 2009 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2021 | 2021 | ||||||||||||||
ls_end_yr | 2008 | 2010 | 2016 | 2016 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2020 | 2020 | 2022 | 2022 | ||||||||||||||
qual_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
eff_date | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2015-05-12 00:00:00 | 2015-12-02 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2018-03-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 | ||||||||||||||
bus_city | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | ||||||||||||||
bus_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||
bus_zip4 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | ||||||||||||||
bus_phon | 5598912200 | 5598912200 | (559) 891-2200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | (559) 891-2200 | 5598912200 | (559) 891-2200 | 5598912200 | (559) 891-2200 | ||||||||||||||
bus_fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
bus_email | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
mail_city | 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 | ||||||||||||||
mail_zip4 | 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 | ||||||||||||||
sig_date | 2006-12-12 00:00:00 | 2009-01-06 00:00:00 | 2015-05-14 00:00:00 | 2015-12-02 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2018-04-20 00:00:00 | 2018-12-28 00:00:00 | 2018-11-09 00:00:00 | 2021-01-07 00:00:00 | 2020-12-01 00:00:00 | ||||||||||||||
sig_loc | None | None | SELMA, CA | None | None | None | None | None | None | SELMA, CA | None | SELMA, CA | None | SELMA, CA | ||||||||||||||
sig_naml | Heusser | HEUSSER | GRAY | Grey | Garner | Garner | Garner | Garner | Garner | PEREA | Galavan | PEREA | GALLAVAN | GALLAVAN | ||||||||||||||
sig_namf | D. B. | D.B. | KENNETH | Ken | Greg | Greg | Greg | Greg | Greg | HENRY | Teresa | HENRY | TERESA | TERESA | ||||||||||||||
sig_namt | 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 | ||||||||||||||
prn_naml | Heusser | HEUSSER | GRAY | Grey | Garner | Garner | Garner | Garner | Garner | PEREA | Galavan | PEREA | GALLAVAN | GALLAVAN | ||||||||||||||
prn_namf | D. B. | D.B. | KENNETH | Ken | Greg | Greg | Greg | Greg | Greg | HENRY | Teresa | HENRY | TERESA | TERESA | ||||||||||||||
prn_namt | 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 | ||||||||||||||
sig_title | City Manager | CITY MANAGER | SELMA CITY MANAGER 425900SSB | City Manager | Interim City Manager | Interim City Manager | Interim City Manager | Interim City Manager | Interim City Manager | INTERIM CITY MANAGER 4259SSB | City Manager | INTERIM CITY MANAGER 4259SSB | CITY MANAGER | CITY MANAGER | ||||||||||||||
stmt_firm | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
ind_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
bus_cb | None | None | None | None | None | None | None | None | None | X | X | X | None | None | ||||||||||||||
trade_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
oth_cb | X | X | X | X | X | X | X | X | X | None | None | None | X | X | ||||||||||||||
a_b_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
a_b_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
a_b_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
a_b_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
descrip_1 | City Governance | CITY GOVERNANCE | MUNICIPAL GOVERNMENT | Municipal Government | Municipal Government | Municipal Government | Municipal Government | Municipal Government | Municipal Government | MUNICIPAL GOVERNMENT/CALIFORNIA HIGH SCHOOL DISTRICT | Municipal government | MUNICIPAL GOVERNMENT/CALIFORNIA HIGH SCHOOL DISTRICT | MUNICIPAL GOVERNMENT | MUNICIPAL GOVERNMENT | ||||||||||||||
descrip_2 | City Governnace | CITY OF GOVERNANCE | None | Municipal Government | Municipal Government | Municipal Government | Municipal Government | Municipal Government | Municipal Government | None | None | None | MUNICIPAL GOVERNMENT | MUNICIPAL GOVERNMENT | ||||||||||||||
c_less50 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
c_more50 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
ind_class | OTH | OTH | GOV | GOV | GOV | GOV | GOV | GOV | GOV | GOV | GOV | GOV | GOV | GOV | ||||||||||||||
ind_descr | City of Selma, City Governnace | CITY OF SELMA, CITY GOVERNANCE | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
bus_class | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
bus_descr | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
auth_name | California Consulting, LLC | CALIFORNIA CONSULTING, LLC | TOWNSEND PUBLIC AFFAIRS, INC. | The CrisCom Company | The CrisCom Company | The CrisCom Company | The CrisCom Company | The CrisCom Company | The CrisCom Company | TOWNSEND PUBLIC AFFAIRS, INC. | The CrisCom Company | TOWNSEND PUBLIC AFFAIRS, INC. | THE CRISCOM COMPANY | TOWNSEND PUBLIC AFFAIRS, INC. | ||||||||||||||
auth_city | Fresno | FRESNO | NEWPORT BEACH | Chatsworth | Chatsworth | Chatsworth | Chatsworth | Chatsworth | Chatsworth | NEWPORT BEACH | Chatsworth | NEWPORT BEACH | CHATSWORTH | NEWPORT BEACH | ||||||||||||||
auth_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||
auth_zip4 | 93710 | 93710 | 92660 | 91311 | 91311 | 91311 | 91311 | 91311 | 91311 | 92660 | 91311 | 92660 | 91311 | 92660 | ||||||||||||||
lobby_int | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
influen_yn | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
firm_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
newcert_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
rencert_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
complet_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
lby_reg_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
lby_604_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
st_leg_yn | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
st_agency | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
lobby_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
l_firm_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2087606 | 2116408 | 2163759 | 2418485 | 2469273 | 2510006 | 2551439 | 2363294 | ||||||||
effect_dt | 2005-02-15 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2017-01-06 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | 2015-05-12 00:00:00 | ||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||
session_id | 2005 | 2007 | 2009 | 2017 | 2019 | 2021 | 2023 | 2015 |
filer_id | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1101727 | 1105305 | 1101719 | 1118648 | 1134172 | 1145952 | 1167280 | 1191175 | 1225870 | 1245916 | 1215907 | 1236122 | 1283359 | 1297506 | 1262503 | 1980676 | 1972231 | 1311471 | 1329654 | 1350520 | 1389322 | 1377411 | 1407891 | 1394976 | 1421572 | 1437187 | 1452721 | 1970006 | 1995298 | 2000459 | 2273537 | 2483106 | 2210164 | 2340357 | 2470211 | 2242559 | 2244346 | 2246905 | 2007083 | 2008773 | 2007083 | 2036118 | 2059235 | 2101311 | 2117817 | 2117818 | 2117819 | 2117820 | 2117821 | 2126832 | 2175363 | 2157394 | 2379498 | 2163707 | 2330485 | 2365958 | 2359049 | 2527702 | 2550414 | 2340548 | 2542741 | 2315068 | 2579836 | 2273537 | 2441794 | 2193668 | 2398959 | 2603017 | 2585113 | 2419114 | 2544267 | 2586359 | 2642987 | 2707024 | 2675318 | 2622458 | 2746222 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | None | 181 | None | 182 | 183 | 184 | 185 | 186 | 189 | None | 187 | 188 | 190 | 191 | 189 | 222 | None | 192 | 193 | 194 | 197 | 195 | None | 196 | 197 | 198 | 199 | 222 | 223 | 224 | 234 | 242 | 232 | 236 | 241 | 233 | 234 | None | 224 | None | 224 | 225 | 226 | 227 | 229 | 229 | 229 | 229 | 229 | 228 | 230 | 229 | 237 | None | 236 | None | None | 243 | 244 | 236 | 245 | 235 | 245 | 234 | 240 | 231 | 238 | 246 | None | 239 | 244 | None | 248 | 250 | 249 | 247 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F999 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2005-04-21 00:00:00 | 2005-05-02 00:00:00 | 2005-03-15 00:00:00 | 2005-08-01 00:00:00 | 2005-10-31 00:00:00 | 2006-01-29 00:00:00 | 2006-04-30 00:00:00 | 2006-07-31 00:00:00 | 2007-01-02 00:00:00 | 2006-12-29 00:00:00 | 2006-10-30 00:00:00 | 2007-01-30 00:00:00 | 2007-07-30 00:00:00 | 2007-10-31 00:00:00 | 2007-04-30 00:00:00 | 2015-07-30 00:00:00 | 2015-06-02 00:00:00 | 2008-01-31 00:00:00 | 2008-04-30 00:00:00 | 2008-07-31 00:00:00 | 2009-01-14 00:00:00 | 2008-10-30 00:00:00 | 2009-01-09 00:00:00 | 2009-01-30 00:00:00 | 2009-04-30 00:00:00 | 2009-07-30 00:00:00 | 2009-11-02 00:00:00 | 2015-06-03 00:00:00 | 2015-10-28 00:00:00 | 2015-12-02 00:00:00 | 2018-07-31 00:00:00 | 2020-07-29 00:00:00 | 2018-01-31 00:00:00 | 2019-01-25 00:00:00 | 2020-04-30 00:00:00 | 2018-04-30 00:00:00 | 2018-05-02 00:00:00 | 2018-05-01 00:00:00 | 2016-01-26 00:00:00 | 2016-01-04 00:00:00 | 2016-02-05 00:00:00 | 2016-04-29 00:00:00 | 2016-07-27 00:00:00 | 2016-10-31 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-30 00:00:00 | 2017-07-31 00:00:00 | 2017-05-01 00:00:00 | 2019-04-29 00:00:00 | 2017-06-19 00:00:00 | 2018-12-28 00:00:00 | 2019-01-25 00:00:00 | 2019-01-08 00:00:00 | 2020-10-30 00:00:00 | 2021-01-29 00:00:00 | 2019-01-25 00:00:00 | 2021-01-07 00:00:00 | 2018-10-29 00:00:00 | 2021-04-29 00:00:00 | 2018-07-31 00:00:00 | 2020-01-31 00:00:00 | 2017-10-31 00:00:00 | 2019-07-31 00:00:00 | 2021-08-02 00:00:00 | 2021-01-05 00:00:00 | 2019-10-31 00:00:00 | 2021-01-14 00:00:00 | 2021-01-14 00:00:00 | 2022-01-31 00:00:00 | 2022-08-01 00:00:00 | 2022-04-29 00:00:00 | 2021-10-29 00:00:00 | 2022-10-29 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2005 | 2005 | 2007 | 2007 | 2007 | 2015 | 2015 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2015 | 2015 | 2015 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2015 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2021 | 2017 | 2021 | 2017 | 2019 | 2017 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | GPEREZ | LTHIBAUL | GPEREZ | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | CFLAGG | LTHIBAUL | LTHIBAUL | YRODRIGU | YRODRIGU | LTHIBAUL | AGLADNEY | YRODRIGU | LTHIBAUL | RGEREMIA | LTHIBAUL | * | ASAETERN | PBANFORD | ASAETERN | ASAETERN | ASAETERN | ASAETERN | YRODRIGU | AGLADNEY | CAFILER | AGLADNEY | MMERCHANT | AGLADNEY | SARRIAGA | GTAYLOR | AGLADNEY | YRODRIGU | YRODRIGU | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | AGLADNEY | AGLADNEY | AGLADNEY | GTAYLOR | YRODRIGU | SARRIAGA | SARRIAGA | DMCCASTL | GTAYLOR | GTAYLOR | AGLADNEY | CVANLIEW | AGLADNEY | GTAYLOR | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GTAYLOR | CVANLIEW | AGLADNEY | CVANLIEW | CVANLIEW | CHATRIDGE | CAFILER | CAFILER | GTAYLOR | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1900-01-01 00:00:00 | 2005-01-01 00:00:00 | 1900-01-01 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2007-01-02 00:00:00 | 1900-01-01 00:00:00 | 2006-07-01 00:00:00 | 2006-10-01 00:00:00 | 2007-04-01 00:00:00 | 2007-07-01 00:00:00 | 2007-01-01 00:00:00 | 2015-04-01 00:00:00 | 1900-01-01 00:00:00 | 2007-10-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2009-01-14 00:00:00 | 2008-07-01 00:00:00 | 1900-01-01 00:00:00 | 2008-10-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 | 2015-06-02 00:00:00 | 2015-07-01 00:00:00 | 2015-12-02 00:00:00 | 2018-04-01 00:00:00 | 2020-04-01 00:00:00 | 2017-10-01 00:00:00 | 2018-11-09 00:00:00 | 2020-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-05-01 00:00:00 | 1900-01-01 00:00:00 | 2015-10-01 00:00:00 | 1900-01-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 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2016-10-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-12-28 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2018-10-01 00:00:00 | 2021-01-07 00:00:00 | 2018-07-01 00:00:00 | 2021-01-01 00:00:00 | 2018-04-01 00:00:00 | 2019-10-01 00:00:00 | 2017-07-01 00:00:00 | 2019-04-01 00:00:00 | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1900-01-01 00:00:00 | 2005-03-31 00:00:00 | 1900-01-01 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2007-01-02 00:00:00 | 1900-01-01 00:00:00 | 2006-09-30 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 2007-09-30 00:00:00 | 2007-03-31 00:00:00 | 2015-06-30 00:00:00 | 1900-01-01 00:00:00 | 2007-12-31 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2009-01-14 00:00:00 | 2008-09-30 00:00:00 | 1900-01-01 00:00:00 | 2008-12-31 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00 | 2015-06-02 00:00:00 | 2015-09-30 00:00:00 | 2015-12-02 00:00:00 | 2018-06-30 00:00:00 | 2020-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-11-09 00:00:00 | 2020-03-31 00:00:00 | 2018-03-31 00:00:00 | 2018-05-01 00:00:00 | 1900-01-01 00:00:00 | 2015-12-31 00:00:00 | 1900-01-01 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2017-01-06 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2018-12-28 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2018-12-31 00:00:00 | 2021-01-07 00:00:00 | 2018-09-30 00:00:00 | 2021-03-31 00:00:00 | 2018-06-30 00:00:00 | 2019-12-31 00:00:00 | 2017-09-30 00:00:00 | 2019-06-30 00:00:00 | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 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 | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | None | 22001 | 22001 | 22006 | 22006 | 22006 | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22001 | 22001 | 22006 | 22001 | 22006 | 22006 | 22001 | 22006 | 22006 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | None | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2007 | 2017 | 2005 | 2009 | 2021 | 2019 | 2015 | 2023 | ||||||||
interest_cd | 40312 | 40305 | 40312 | 40305 | 40305 | 40305 | 40305 | 40305 | ||||||||
effect_date | 2007-01-01 00:00:00 | 2017-01-06 00:00:00 | 2005-02-15 00:00:00 | 2009-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-05-12 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||
active | Y | Y | Y | T | Y | Y | Y | Y | N | |||||||||
race | 0 | 0 | None | None | None | None | None | None | None | |||||||||
session_id | 2005 | 2007 | 2009 | 2009 | 2017 | 2021 | 2015 | 2019 | 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 | 2005-02-15 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-07-30 00:00:00 | 2017-01-06 00:00:00 | 2021-01-01 00:00:00 | 2015-05-12 00:00:00 | 2019-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 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 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 | 1276423 | |
---|---|---|
xref_id | 1276423 | |
effect_dt | 2005-04-21 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | SELMA, CITY OF | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | SELMA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | 93662 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 5599993651 | 5598912200 | 5599993651 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5599993651 | 5598912200 | 5599993651 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5599993651 | 5598912200 | 5599993651 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5599993651 | 5598912200 | 5599993651 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5599993651 | 5598912200 | 5599993651 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5599993651 | 5598912200 | 5599993651 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5599993651 | 5598912200 | 5599993651 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5599993651 | 5598912200 | 5599993651 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | 5598912200 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_id | 1276423 |
---|
filer_id | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | |||||
---|---|---|---|---|---|---|---|---|---|---|
change_no | 0 | 1 | 2 | 3 | 4 | |||||
session_id | 2005 | 2009 | 2015 | 2015 | 2017 | |||||
log_dt | 2005-03-15 00:00:00 | 2009-08-17 00:00:00 | 2015-06-02 00:00:00 | 2016-01-04 00:00:00 | 2018-05-01 00:00:00 | |||||
filer_type | 1 | 1 | 1 | 1 | 2 | |||||
correction_flg | Y | Y | Y | Y | Y | |||||
action | ADDED | DELETED | ADDED | ADDED | ADDED | |||||
attribute_changed | None | FIRM | FIRM | FIRM | FIRM | |||||
ethics_dt | None | None | None | None | None | |||||
interests | None | None | None | None | None | |||||
filer_full_name | SELMA, CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | SELMA; CITY OF | |||||
filer_city | None | None | SELMA | SELMA | SELMA | |||||
filer_st | None | None | CA | CA | CA | |||||
filer_zip | None | None | 93662 | 93662 | 93662 | |||||
filer_phone | None | None | 5599993651 | 5599993651 | 5599993651 | |||||
entity_type | 3 | 3 | 3 | 3 | 3 | |||||
entity_name | CALIFORNIA CONSULTING, LLC | CALIFORNIA CONSULTING, LLC | TOWNSEND PUBLIC AFFAIRS, INC. | CRISCOM COMPANY; THE | TOWNSEND PUBLIC AFFAIRS, INC. | |||||
entity_city | None | None | None | None | None | |||||
entity_st | None | None | None | None | None | |||||
entity_zip | None | None | None | None | None | |||||
entity_phone | None | None | None | None | None | |||||
entity_id | 1275430 | 1275430 | None | None | None | |||||
responsible_officer | None | None | None | None | None | |||||
effect_dt | 2005-02-15 00:00:00 | 2009-07-30 00:00:00 | 2015-05-12 00:00:00 | 2015-12-02 00:00:00 | 2018-03-01 00:00:00 |
filer_id | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | 1276423 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 286279.cal | 339954.cal | 1980676_0.cal | 2007083_0.cal | 1995298_0.cal | 2273537_0.cal | 284258.cal | 187695.cal | 187282.cal | 187426.cal | 187798.cal | |||||||||||
received_date | 2005-05-02 00:00:00 | 2006-07-31 00:00:00 | 2015-07-30 00:00:00 | 2016-01-26 00:00:00 | 2015-10-28 00:00:00 | 2018-07-31 00:00:00 | 2018-05-01 00:00:00 | 2018-07-31 00:00:00 | 2018-07-31 00:00:00 | 2018-07-31 00:00:00 | 2018-07-31 00:00:00 | |||||||||||
filing_directory | /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/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | |||||||||||
filing_id | None | None | 1980676 | 2007083 | 1995298 | 2273537 | None | None | None | None | None | |||||||||||
form_id | None | None | F635 | F635 | F635 | F635 | None | None | None | None | None | |||||||||||
receive_comment | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | 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 | Filing passed validation, but failed DB constraints |