| filing_id | 1259124 | 1279359 | 1371176 | 1294239 | 1325963 | 1344191 | 1307081 | 1432425 | 1450184 | 1421478 | 1396840 | 1459228 | 1532711 | 1504393 | 1483000 | 1570635 | 1622090 | 1634349 | 1605235 | 1590147 | 1707514 | 1674393 | 1655212 | 1738680 | 2210636 | 2242957 | 2273486 | 2379804 | 2348913 | 2319988 | 2393671 | 2415352 | 2441300 | 2471517 | 2554934 | 2529591 | 2484632 | 2603644 | 2625548 | 2638565 | 2581603 | 2739591 | 2678291 | 2707634 | ||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
| rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||||||||||||||||||||||||||||||||||||||
| form_type | 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 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | ||||||||||||||||||||||||||||||||||||||||||||
| filer_id | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| filer_naml | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, 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 | ||||||||||||||||||||||||||||||||||||||||||||
| filer_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| filer_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | ||||||||||||||||||||||||||||||||||||||||||||
| rpt_date | 2007-04-19 00:00:00 | 2007-07-16 00:00:00 | 2008-10-17 00:00:00 | 2007-10-15 00:00:00 | 2008-04-14 00:00:00 | 2008-07-11 00:00:00 | 2008-01-17 00:00:00 | 2009-07-14 00:00:00 | 2009-10-16 00:00:00 | 2009-04-20 00:00:00 | 2009-01-20 00:00:00 | 2010-01-14 00:00:00 | 2010-10-15 00:00:00 | 2010-07-16 00:00:00 | 2010-04-14 00:00:00 | 2011-01-14 00:00:00 | 2011-10-11 00:00:00 | 2012-01-17 00:00:00 | 2011-07-12 00:00:00 | 2011-04-13 00:00:00 | 2012-10-22 00:00:00 | 2012-07-18 00:00:00 | 2012-04-16 00:00:00 | 2013-01-17 00:00:00 | 2018-01-18 00:00:00 | 2018-04-11 00:00:00 | 2018-07-17 00:00:00 | 2019-04-15 00:00:00 | 2019-01-14 00:00:00 | 2018-10-23 00:00:00 | 2019-07-14 00:00:00 | 2019-10-16 00:00:00 | 2020-01-31 00:00:00 | 2020-04-30 00:00:00 | 2021-01-31 00:00:00 | 2020-10-31 00:00:00 | 2020-07-31 00:00:00 | 2021-07-31 00:00:00 | 2021-10-31 00:00:00 | 2022-01-31 00:00:00 | 2021-04-30 00:00:00 | 2022-10-31 00:00:00 | 2022-04-30 00:00:00 | 2022-07-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||
| from_date | 2007-01-01 00:00:00 | 2007-04-01 00:00:00 | 2008-07-01 00:00:00 | 2007-07-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2007-10-01 00:00:00 | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 | 2009-01-01 00:00:00 | 2008-10-01 00:00:00 | 2009-10-01 00:00:00 | 2010-07-01 00:00:00 | 2010-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-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 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2019-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2021-01-01 00:00:00 | 2022-07-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||
| thru_date | 2007-03-31 00:00:00 | 2007-06-30 00:00:00 | 2008-09-30 00:00:00 | 2007-09-30 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2007-12-31 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00 | 2009-03-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-09-30 00:00:00 | 2010-06-30 00:00:00 | 2010-03-31 00:00:00 | 2010-12-31 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-03-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 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2019-03-31 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2019-06-30 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2021-03-31 00:00:00 | 2022-09-30 00:00:00 | 2022-03-31 00:00:00 | 2022-06-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 | 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 | 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 | 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 | 2017-10-01 00:00:00 | 2017-10-01 00:00:00 | 2017-10-01 00:00:00 | 2019-01-01 00:00:00 | 2017-10-01 00:00:00 | 2017-10-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 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | ||||||||||||||||||||||||||||||||||||||||||||
| firm_name | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | ||||||||||||||||||||||||||||||||||||||||||||
| firm_city | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | ||||||||||||||||||||||||||||||||||||||||||||
| firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||
| firm_zip4 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | 95240 | 95240 | 95240 | 95240 | 95240 | 95240 | 95240 | 95240 | 95240 | 95240 | 95240 | 95240 | 95240 | ||||||||||||||||||||||||||||||||||||||||||||
| firm_phon | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 385-6834 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | (209) 388-7000 | ||||||||||||||||||||||||||||||||||||||||||||
| mail_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| mail_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| mail_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| sig_date | 2007-04-17 00:00:00 | 2007-07-16 00:00:00 | 2008-10-17 00:00:00 | 2007-10-15 00:00:00 | 2008-04-11 00:00:00 | 2008-07-11 00:00:00 | 2008-01-17 00:00:00 | 2009-07-14 00:00:00 | 2009-10-16 00:00:00 | 2009-04-20 00:00:00 | 2009-01-20 00:00:00 | 2010-01-14 00:00:00 | 2010-10-15 00:00:00 | 2010-07-16 00:00:00 | 2010-04-14 00:00:00 | 2011-01-14 00:00:00 | 2011-10-11 00:00:00 | 2012-01-17 00:00:00 | 2011-07-12 00:00:00 | 2011-04-13 00:00:00 | 2012-10-22 00:00:00 | 2012-07-18 00:00:00 | 2012-04-13 00:00:00 | 2013-01-17 00:00:00 | 2018-01-18 00:00:00 | 2018-04-11 00:00:00 | 2018-07-17 00:00:00 | 2019-04-15 00:00:00 | 2019-01-14 00:00:00 | 2018-10-23 00:00:00 | 2019-07-14 00:00:00 | 2019-10-16 00:00:00 | 2020-01-23 00:00:00 | 2020-04-17 00:00:00 | 2021-01-24 00:00:00 | 2020-10-22 00:00:00 | 2020-07-20 00:00:00 | 2021-07-25 00:00:00 | 2021-10-25 00:00:00 | 2022-01-25 00:00:00 | 2021-04-21 00:00:00 | 2022-10-17 00:00:00 | 2022-04-15 00:00:00 | 2022-07-18 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||
| sig_loc | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | ||||||||||||||||||||||||||||||||||||||||||||
| sig_naml | CAHILL | MARSHALL | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | BRAMBLE | BRAMBLE | BRAMBLE | BRAMBLE | BRAMBLE | BRAMBLE | BRAMBLE | BRAMBLE | BRAMBLE | CARRIGAN | CARRIGAN | CARRIGAN | CARRIGAN | CARRIGAN | CARRIGAN | CARRIGAN | CARRIGAN | CARRIGAN | CARRIGAN | DIETZ | DIETZ | CARRIGAN | DIETZ | DIETZ | DIETZ | DIETZ | DIETZ | DIETZ | DIETZ | ||||||||||||||||||||||||||||||||||||||||||||
| sig_namf | WILLIAM D. | JAMES G. | William D. | William D. | William D. | William D. | William D. | William D. | William D. | William D. | William D. | William D. | William D. | William D. | William D. | JOHN M. | JOHN M. | JOHN M. | JOHN M. | JOHN M. | JOHN M. | JOHN M. | JOHN M. | JOHN M. | STEVE | STEVE | STEVE | STEVE | STEVE | STEVE | STEVE | STEVE | STEVE | STEVE | STEPHANIE | STEPHANIE | STEVE | STEPHANIE | STEPHANIE | STEPHANIE | STEPHANIE | STEPHANIE | STEPHANIE | STEPHANIE | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| sig_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| prn_naml | CAHILL | MARSHALL | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | Cahill | BRAMBLE | BRAMBLE | BRAMBLE | BRAMBLE | BRAMBLE | BRAMBLE | BRAMBLE | BRAMBLE | BRAMBLE | CARRIGAN | CARRIGAN | CARRIGAN | CARRIGAN | CARRIGAN | CARRIGAN | CARRIGAN | CARRIGAN | CARRIGAN | CARRIGAN | DIETZ | DIETZ | CARRIGAN | DIETZ | DIETZ | DIETZ | DIETZ | DIETZ | DIETZ | DIETZ | ||||||||||||||||||||||||||||||||||||||||||||
| prn_namf | WILLIAM D. | JAMES G. | William D. | William D. | William D. | William D. | William D. | William D. | William D. | William D. | William D. | William D. | William D. | William D. | William D. | JOHN M. | JOHN M. | JOHN M. | JOHN M. | JOHN M. | JOHN M. | JOHN M. | JOHN M. | JOHN M. | STEVE | STEVE | STEVE | STEVE | STEVE | STEVE | STEVE | STEVE | STEVE | STEVE | STEPHANIE | STEPHANIE | STEVE | STEPHANIE | STEPHANIE | STEPHANIE | STEPHANIE | STEPHANIE | STEPHANIE | STEPHANIE | ||||||||||||||||||||||||||||||||||||||||||||
| prn_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| prn_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| sig_title | ASST. CITY MANAGER 425900SB | CITY MANAGER, 425900SB | Asst. City Manager 425900SB | Asst. City Manager 425900SB | Asst. City Manager 425900SB | Asst. City Manager 425900SB | Asst. City Manager 425900SB | Asst. City Manager 425900SB | Asst. City Manager 425900SB | Asst. City Manager 425900SB | Asst. City Manager 425900SB | Asst. City Manager 425900SB | Asst. City Manager 425900SB | Asst. City Manager 425900SB | Asst. City Manager 425900SB | CITY MANAGER 425900SB | CITY MANAGER 425900SB | CITY MANAGER 425900SB | CITY MANAGER 425900SB | CITY MANAGER 425900SB | CITY MANAGER 425900SB | CITY MANAGER 425900SB | CITY MANAGER 425900SB | CITY MANAGER 425900SB | CITY MANAGER 425900SSB | CITY MANAGER 425900SSB | CITY MANAGER 425900SSB | CITY MANAGER 425900SSB | CITY MANAGER 425900SSB | CITY MANAGER 425900SSB | CITY MANAGER 425900SSB | CITY MANAGER | CITY MANAGER | CITY MANAGER | CITY MANAGER | INTERIM CITY MANAGER | CITY MANAGER | 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 | ||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||
| part1_1_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| part1_2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| ctrib_n_cb | 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 | None | None | None | None | None | None | None | None | None | None | None | 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 | SEE ATTACHMENT A | SEE ATTACHMENT A | SEE ATTACHMENT A | SEE ATTACHMENT A | SEE ATTACHMENT A | SEE ATTACHMENT A | SEE ATTACHMENT A | Department of Parks and Recreation, California Cultural & Historical Endowment - grant funding; California Transportation Commission, Caltrans, California Public Utilities Commission, Office of Emergency Services - grant funding; State Legislature - Budget | Department of Parks and Recreation, California Cultural & Historical Endowment - grant funding; California Transportation Commission, Caltrans, California Public Utilities Commission, Office of Emergency Services - grant funding; State Legislature - Budget | Department of Parks and Recreation and California Cultural & Historical Endowment Re: grant funding; California Transportation Commission, Caltrans, California Public Utilities Commission, Office of Emergency Services Re: grant funding; State Legislature Re: Budget; ABx3 20 | SEE ATTACHMENT A | Department of Parks and Recreation, California Cultural & Historical Endowment - grant funding; California Transportation Commission, Caltrans, California Public Utilities Commission, Office of Emergency Services - grant funding; State Legislature - Budget | Department of Parks and Recreation - Parks Program. California Transportation Commission, Caltrans, California Public Utilities Commission - grant funding; State Legislature - Budget, SB 974. | Department of Parks and Recreation - Parks Program. California Transportation Commission, Caltrans, California Public Utilities Commission - grant funding; State Legislature - Budget, SB 974. | Department of Parks and Recreation, California Cultural & Historical Endowment - grant funding; California Transportation Commission, Caltrans, California Public Utilities Commission, Office of Emergency Services - grant funding; State Legislature - Budget, enterprise zone program. | Department of Parks and Recreation - Parks Program. California Transportation Commission, Caltrans, California Public Utilities Commission - grant funding. State Legislature - Budget. | Department of Parks and Recreation - Statewide Park Program. Natural Resources Agency, Strategic Growth Council - Urban Greening Program. | Department of Parks and Recreation - Statewide Park Program. Natural Resources Agency, Strategic Growth Council - Urban Greening Program. | California Transportation Commission, Caltrans, California Public Utilities Commission - grant funding. Natural Resources Agency, Strategic Growth Council - Urban Greening Program. Department of Parks and Recreation - Statewide Park Program. Legislature and Administration - Budget, Enterprise Zones, AB 98, AB 101, AB 103, AB 1250, AB 26x, AB 27x, SB 69, SB 77, SB 87, SB 89, SB 286. | California Transportation Commission, Caltrans, California Public Utilities Commission - grant funding. Legislature and Administration - Budget, Enterprise Zones, Redevelopment, AB 101, AB 103,AB 231, AB 232, SB 69, SB 77, SB 79. | SEE ATTACHMENT A | SEE ATTACHMENT A | SEE ATTACHMENT A | No activity for this period | Legislature RE: Budget | SEE ATTACHMENT A | SEE ATTACHMENT A | SEE ATTACHMENT A | Legislature RE: Budget and Opportunity Zones. Governor RE: Opportunity Zones. | SEE ATTACHMENT AC | SEE ATTACHMENT A | SEE ATTACHMENT A | SEE ATTACHMENT A | SEE ATTACHMENT A | SEE ATTACHMENT A | SEE ATTACHMENT A | SEE ATTACHMENT A | See Attachment A | See Attachment A | Legislature Re: Budget and Municipal Finance; Governors Office, California High Speed Rail Authority Re: High Speed Rail; California Natural Resources Agency Re: Water Programs | See Attachment A | None | Legislature Re: Budget and Municipal Finance | Legislature Re: Budget and Municipal Finance; California High-Speed Rail Authority Re: Merced station | ||||||||||||||||||||||||||||||||||||||||||||
| lobby_n_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| lobby_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| major_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| major_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| major_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| major_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| rcpcmte_nm | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
| rcpcmte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
| filing_id | 1249489 | 1386936 | 1556607 | 2213199 | 2340337 | 2544234 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
| rec_type | CVR | CVR | CVR | CVR | CVR | CVR | ||||||
| form_type | F602 | F602 | F602 | F602 | F602 | F602 | ||||||
| sender_id | F24882 | F24882 | F24882 | F24882 | F24882 | F24882 | ||||||
| filer_id | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | ||||||
| entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | ||||||
| filer_naml | MERCED, CITY OF | MERCED, CITY OF | MERCED, CITY OF | MERCED | MERCED | MERCED, CITY OF | ||||||
| filer_namf | CITY OF | CITY OF | CITY OF | CITY OF | CITY OF | None | ||||||
| filer_namt | None | None | None | None | None | None | ||||||
| filer_nams | None | None | None | None | None | None | ||||||
| report_num | 000 | 000 | 000 | 000 | 000 | 000 | ||||||
| rpt_date | 2007-02-28 00:00:00 | 2008-12-23 00:00:00 | 2010-12-28 00:00:00 | 2018-02-05 00:00:00 | 2018-11-08 00:00:00 | 2020-12-31 00:00:00 | ||||||
| ls_beg_yr | 2007 | 2009 | 2011 | 2017 | 2019 | 2021 | ||||||
| ls_end_yr | 2008 | 2010 | 2012 | 2018 | 2020 | 2022 | ||||||
| qual_date | None | None | None | None | None | None | ||||||
| eff_date | 2007-02-05 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-11-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | ||||||
| bus_city | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | ||||||
| bus_st | CA | CA | CA | CA | CA | CA | ||||||
| bus_zip4 | 95340 | 95340 | 95340 | 95340 | 95340 | 95340 | ||||||
| bus_phon | 209 385-6834 | 209 385-6834 | 209 385-6834 | 209 388-7000 | 209 388-7000 | 209 388-7000 | ||||||
| bus_fax | 209 723-1780 | None | 209 723-1780 | None | None | None | ||||||
| bus_email | None | None | None | None | None | None | ||||||
| mail_city | None | None | None | None | None | None | ||||||
| mail_st | None | None | None | None | None | None | ||||||
| mail_zip4 | None | None | None | None | None | None | ||||||
| mail_phon | None | None | None | None | None | None | ||||||
| sig_date | 2007-02-06 00:00:00 | 2008-12-05 00:00:00 | 2010-12-20 00:00:00 | 2018-02-05 00:00:00 | 2018-11-08 00:00:00 | 2020-11-25 00:00:00 | ||||||
| sig_loc | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | MERCED, CA | ||||||
| sig_naml | MARSHALL | BRAMBLE | BRAMBLE | CARRIGAN | CARRIGAN | DIETZ | ||||||
| sig_namf | JAMES G. | JOHN M. | JOHN M. | STEVE | STEVE | STEPHANIE | ||||||
| sig_namt | None | None | None | None | None | None | ||||||
| sig_nams | None | None | None | None | None | None | ||||||
| prn_naml | MARSHALL | BRAMBLE | BRAMBLE | CARRIGAN | CARRIGAN | DIETZ | ||||||
| prn_namf | JAMES G. | JOHN M. | JOHN M. | STEVE | STEVE | STEPHANIE | ||||||
| prn_namt | None | None | None | None | None | None | ||||||
| prn_nams | None | None | None | None | None | None | ||||||
| sig_title | CITY MANAGER 425900SB | CITY MANAGER 425900SB | CITY MANAGER 425900SB | CITY MANAGER, 425900SSB | CITY MANAGER, 425900SSB | CITY MANAGER | ||||||
| stmt_firm | None | None | None | None | None | None | ||||||
| ind_cb | None | None | None | None | None | None | ||||||
| bus_cb | None | None | None | None | None | None | ||||||
| trade_cb | None | None | None | None | None | None | ||||||
| oth_cb | X | X | X | X | X | X | ||||||
| a_b_name | None | None | None | None | None | None | ||||||
| a_b_city | None | None | None | None | None | None | ||||||
| a_b_st | None | None | None | None | None | None | ||||||
| a_b_zip4 | None | None | None | None | None | None | ||||||
| descrip_1 | PUBLIC AGENCY | PUBLIC AGENCY | PUBLIC AGENCY | MUNICIPAL GOVERNMENT | MUNICIPAL GOVERNMENT | MUNICIPAL GOVERNMENT | ||||||
| descrip_2 | None | None | None | None | None | MUNICIPAL GOVERNMENT | ||||||
| c_less50 | None | None | None | None | None | None | ||||||
| c_more50 | None | None | None | None | None | None | ||||||
| ind_class | OTH | OTH | OTH | GOV | GOV | GOV | ||||||
| ind_descr | PUBLIC AGENCY | TO SECURE PUBLIC FUNDING FOR CAPITAL IMPROVEMENTS | TO SECURE PUBLIC FUNDING FOR CAPITAL IMPROVEMENTS | None | None | None | ||||||
| bus_class | None | None | None | None | None | None | ||||||
| bus_descr | None | None | None | None | None | None | ||||||
| auth_name | TOWNSEND PUBLIC AFFAIRS, INC. | TOWNSEND PUBLIC AFFAIRS, INC. | TOWNSEND PUBLIC AFFAIRS, INC. | TOWNSEND PUBLIC AFFAIRS, INC. | TOWNSEND PUBLIC AFFAIRS, INC. | TOWNSEND PUBLIC AFFAIRS, INC. | ||||||
| auth_city | IRVINE | IRVINE | IRVINE | NEW PORT BEACH | NEW PORT BEACH | NEW PORT BEACH | ||||||
| auth_st | CA | CA | CA | CA | CA | CA | ||||||
| auth_zip4 | 92614 | 92614 | 92614 | 92660 | 92660 | 92660 | ||||||
| lobby_int | None | None | None | None | None | None | ||||||
| influen_yn | None | None | None | None | None | None | ||||||
| firm_name | None | None | None | None | None | None | ||||||
| newcert_cb | None | None | None | None | None | None | ||||||
| rencert_cb | None | None | None | None | None | None | ||||||
| complet_dt | None | None | None | None | None | None | ||||||
| lby_reg_cb | None | None | None | None | None | None | ||||||
| lby_604_cb | None | None | None | None | None | None | ||||||
| st_leg_yn | None | None | None | None | None | None | ||||||
| st_agency | None | None | None | None | None | None | ||||||
| lobby_cb | None | None | None | None | None | None | ||||||
| l_firm_cb | None | None | None | None | None | None |
| filer_id | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| adrid | 2119430 | 2164904 | 2207069 | 2445145 | 2509968 | 2468275 | 2551401 | |||||||
| effect_dt | 2007-02-05 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-11-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||
| add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||
| session_id | 2007 | 2009 | 2011 | 2017 | 2021 | 2019 | 2023 |
| filer_id | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 1259412 | 1249489 | 1279359 | 1259124 | 1307081 | 1294239 | 1325963 | 1344191 | 1371176 | 1386936 | 1412128 | 1396840 | 1421478 | 1432425 | 1450184 | 1459228 | 1483000 | 1504393 | 1556607 | 1560932 | 1570635 | 1532711 | 1605235 | 1622090 | 1590147 | 1634349 | 1655212 | 1674393 | 1707514 | 1738680 | 2415352 | 2554934 | 2340337 | 2379804 | 2319988 | 2273486 | 2366007 | 2348913 | 2210636 | 2393671 | 2471517 | 2213199 | 2529591 | 2213204 | 2242957 | 2484632 | 2441300 | 2585948 | 2581603 | 2544234 | 2603644 | 2625548 | 2678291 | 2638565 | 2707634 | 2739591 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| period_id | None | 189 | 190 | 189 | 192 | 191 | 193 | 194 | 195 | 196 | None | 196 | 197 | 198 | 199 | 200 | 201 | 202 | 204 | None | 204 | 203 | 206 | 207 | 205 | 208 | 209 | 210 | 211 | 212 | 239 | 244 | 236 | 237 | 235 | 234 | None | 236 | 232 | 238 | 241 | 233 | 243 | None | 233 | 242 | 240 | None | 245 | 244 | 246 | 247 | 249 | 248 | 250 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_date | 2007-02-28 00:00:00 | 2007-02-28 00:00:00 | 2007-07-24 00:00:00 | 2007-04-24 00:00:00 | 2008-01-28 00:00:00 | 2007-10-23 00:00:00 | 2008-04-22 00:00:00 | 2008-07-18 00:00:00 | 2008-10-24 00:00:00 | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-02-01 00:00:00 | 2009-04-30 00:00:00 | 2009-07-22 00:00:00 | 2009-10-27 00:00:00 | 2010-01-22 00:00:00 | 2010-04-27 00:00:00 | 2010-07-28 00:00:00 | 2011-01-04 00:00:00 | 2011-01-04 00:00:00 | 2011-01-31 00:00:00 | 2010-10-22 00:00:00 | 2011-07-28 00:00:00 | 2011-10-31 00:00:00 | 2011-04-29 00:00:00 | 2012-01-30 00:00:00 | 2012-04-26 00:00:00 | 2012-07-25 00:00:00 | 2012-10-30 00:00:00 | 2013-01-31 00:00:00 | 2019-10-24 00:00:00 | 2021-02-01 00:00:00 | 2019-01-25 00:00:00 | 2019-04-30 00:00:00 | 2018-10-31 00:00:00 | 2018-07-31 00:00:00 | 2019-01-25 00:00:00 | 2019-01-31 00:00:00 | 2018-01-31 00:00:00 | 2019-07-26 00:00:00 | 2020-04-30 00:00:00 | 2018-02-05 00:00:00 | 2020-11-01 00:00:00 | 2018-02-02 00:00:00 | 2018-04-30 00:00:00 | 2020-07-30 00:00:00 | 2020-01-30 00:00:00 | 2021-01-14 00:00:00 | 2021-04-30 00:00:00 | 2021-01-14 00:00:00 | 2021-08-02 00:00:00 | 2021-11-01 00:00:00 | 2022-05-02 00:00:00 | 2022-01-26 00:00:00 | 2022-08-01 00:00:00 | 2022-10-24 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_type | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 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 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| session_id | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2019 | 2019 | 2019 | 2019 | 2017 | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| user_id | SARRIAGA | GPEREZ | YRODRIGU | LTHIBAUL | LTHIBAUL | YRODRIGU | LTHIBAUL | LTHIBAUL | MGUERRA | GPEREZ | GPEREZ | MGUERRA | MGUERRA | MGUERRA | MGUERRA | MGUERRA | ASAETERN | ASAETERN | GPEREZ | GKURIMOT | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | SUSHAKOV | GTAYLOR | SARRIAGA | GTAYLOR | AGLADNEY | AGLADNEY | SARRIAGA | AGLADNEY | AGLADNEY | AGLADNEY | SUSHAKOV | GPEREZ | GTAYLOR | GPEREZ | AGLADNEY | GTAYLOR | AGLADNEY | CVANLIEW | MKIRKHAM | CVANLIEW | MKIRKHAM | GTAYLOR | CAFILER | CHATRIDGE | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| fine_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_start | 1900-01-01 00:00:00 | 2007-02-28 00:00:00 | 2007-04-01 00:00:00 | 2007-01-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-12-23 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 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-12-28 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2010-07-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 2019-07-01 00:00:00 | 2020-10-01 00:00:00 | 2018-11-08 00:00:00 | 2019-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-04-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-01 00:00:00 | 2017-10-01 00:00:00 | 2019-04-01 00:00:00 | 2020-01-01 00:00:00 | 2018-02-05 00:00:00 | 2020-07-01 00:00:00 | 1900-01-01 00:00:00 | 2018-01-01 00:00:00 | 2020-04-01 00:00:00 | 2019-10-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-01 00:00:00 | 2020-12-31 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_end | 1900-01-01 00:00:00 | 2007-02-28 00:00:00 | 2007-06-30 00:00:00 | 2007-03-31 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-23 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 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-12-28 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2010-09-30 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00 | 2019-09-30 00:00:00 | 2020-12-31 00:00:00 | 2018-11-08 00:00:00 | 2019-03-31 00:00:00 | 2018-09-30 00:00:00 | 2018-06-30 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2017-12-31 00:00:00 | 2019-06-30 00:00:00 | 2020-03-31 00:00:00 | 2018-02-05 00:00:00 | 2020-09-30 00:00:00 | 1900-01-01 00:00:00 | 2018-03-31 00:00:00 | 2020-06-30 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 2021-03-31 00:00:00 | 2020-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2022-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_type | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
| filer_id | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| session_id | 2011 | 2007 | 2009 | 2017 | 2021 | 2019 | 2023 | |||||||
| interest_cd | 40305 | 40312 | 40305 | 40305 | 40305 | 40305 | 40305 | |||||||
| effect_date | 2011-01-01 00:00:00 | 2007-02-05 00:00:00 | 2009-01-01 00:00:00 | 2017-11-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 |
| filer_id | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||
| active | Y | Y | Y | Y | Y | Y | N | |||||||
| race | 0 | None | None | None | None | None | None | |||||||
| session_id | 2007 | 2011 | 2009 | 2019 | 2017 | 2021 | 2023 | |||||||
| category | 0 | None | None | None | None | None | None | |||||||
| category_type | 0 | None | None | None | None | None | None | |||||||
| sub_category | 0 | None | None | None | None | None | None | |||||||
| effect_dt | 2007-02-05 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-11-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||
| sub_category_type | 0 | None | None | None | None | None | None | |||||||
| election_type | 0 | None | None | None | None | None | None | |||||||
| sub_category_a | None | None | None | None | None | None | None | |||||||
| nyq_dt | None | None | None | None | None | None | None | |||||||
| party_cd | 0 | None | None | None | None | None | None | |||||||
| county_cd | 0 | None | None | None | None | None | None | |||||||
| district_cd | 0 | None | None | None | None | None | None |
| filer_id | 1295645 | |
|---|---|---|
| xref_id | 1295645 | |
| effect_dt | 2007-02-23 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | |||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | |||||||||||||||||||||||||||||||||||||||||||||||||
| effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||
| naml | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | MERCED; 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
| namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||
| nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||
| adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||
| adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||
| city | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | MERCED | |||||||||||||||||||||||||||||||||||||||||||||||||
| st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||||||||||||||||||||||||||
| zip4 | 95340 | 95340 | 95340 | 95240 | 95240 | 95240 | 95240 | 95340 | 95340 | 95340 | 95240 | 95240 | 95240 | 95240 | 95340 | 95340 | 95340 | 95240 | 95240 | 95240 | 95240 | 95340 | 95340 | 95340 | 95240 | 95240 | 95240 | 95240 | 95340 | 95340 | 95340 | 95240 | 95240 | 95240 | 95240 | 95340 | 95340 | 95340 | 95240 | 95240 | 95240 | 95240 | 95340 | 95340 | 95340 | 95240 | 95240 | 95240 | 95240 | |||||||||||||||||||||||||||||||||||||||||||||||||
| phon | 2093856834 | 2093856834 | 2093856834 | 2093887000 | 2093887000 | 2093887000 | 2093887000 | 2093856834 | 2093856834 | 2093856834 | 2093887000 | 2093887000 | 2093887000 | 2093887000 | 2093856834 | 2093856834 | 2093856834 | 2093887000 | 2093887000 | 2093887000 | 2093887000 | 2093856834 | 2093856834 | 2093856834 | 2093887000 | 2093887000 | 2093887000 | 2093887000 | 2093856834 | 2093856834 | 2093856834 | 2093887000 | 2093887000 | 2093887000 | 2093887000 | 2093856834 | 2093856834 | 2093856834 | 2093887000 | 2093887000 | 2093887000 | 2093887000 | 2093856834 | 2093856834 | 2093856834 | 2093887000 | 2093887000 | 2093887000 | 2093887000 | |||||||||||||||||||||||||||||||||||||||||||||||||
| fax | 2097231780 | 2097231780 | 2097231780 | 2097231780 | 2097231780 | 2097231780 | 2097231780 | 2097231780 | 2097231780 | 2097231780 | 2097231780 | 2097231780 | 2097231780 | 2097231780 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1295645 |
|---|
| filer_id | 1295645 | 1295645 | 1295645 | |||
|---|---|---|---|---|---|---|
| change_no | 0 | 1 | 2 | |||
| session_id | 2007 | 2017 | 2021 | |||
| log_dt | 2007-02-28 00:00:00 | 2018-02-02 00:00:00 | 2021-01-14 00:00:00 | |||
| filer_type | 1 | 2 | 1 | |||
| correction_flg | Y | Y | None | |||
| action | ADDED | ADDED | CHANGED | |||
| attribute_changed | FIRM | FIRM | RESPONSIBLE OFFICER | |||
| ethics_dt | None | None | None | |||
| interests | None | None | None | |||
| filer_full_name | MERCED; CITY OF | MERCED; CITY OF | MERCED; CITY OF | |||
| filer_city | None | None | None | |||
| filer_st | None | None | None | |||
| filer_zip | None | None | None | |||
| filer_phone | None | None | None | |||
| entity_type | 3 | 3 | 20 | |||
| entity_name | TOWNSEND PUBLIC AFFAIRS, INC. | TOWNSEND PUBLIC AFFAIRS, INC. | CITY MANAGER STEPHANIE DIETZ | |||
| entity_city | None | None | None | |||
| entity_st | None | None | None | |||
| entity_zip | None | None | None | |||
| entity_phone | None | None | None | |||
| entity_id | 1147750 | 0 | 1438571 | |||
| responsible_officer | None | None | None | |||
| effect_dt | 2007-02-05 00:00:00 | 2017-11-01 00:00:00 | 2021-01-01 00:00:00 |
| filer_id | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | 1295645 | |||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 1396840_0.cal | 1371176_0.cal | 1344191_0.cal | 1504393_0.cal | 1459228_0.cal | 1279359_0.cal | 1483000_0.cal | 1259124_0.cal | 1432425_0.cal | 1450184_0.cal | 1421478_0.cal | 1294239_0.cal | 1325963_0.cal | 1307081_0.cal | 1738680_0.cal | 1570635_0.cal | 1532711_0.cal | 1605235_0.cal | 1590147_0.cal | 1622090_0.cal | 1634349_0.cal | 1707514_0.cal | 1674393_0.cal | 1655212_0.cal | 2319988_0.cal | 2415352_0.cal | 2379804_0.cal | 2393671_0.cal | 2273486_0.cal | 2348913_0.cal | 2484632_0.cal | 2210636_0.cal | 2471517_0.cal | 2242957_0.cal | 2441300_0.cal | 2603644_0.cal | 2581603_0.cal | 2707634_0.cal | 2529591_0.cal | 2554934_0.cal | 18174.cal | 2678291_0.cal | 2625548_0.cal | 2739591_0.cal | 2638565_0.cal | |||||||||||||||||||||||||||||||||||||||||||||
| received_date | 2009-02-01 00:00:00 | 2008-10-24 00:00:00 | 2008-07-18 00:00:00 | 2010-07-28 00:00:00 | 2010-01-22 00:00:00 | 2007-07-24 00:00:00 | 2010-04-27 00:00:00 | 2007-04-24 00:00:00 | 2009-07-22 00:00:00 | 2009-10-27 00:00:00 | 2009-04-30 00:00:00 | 2007-10-23 00:00:00 | 2008-04-22 00:00:00 | 2008-01-28 00:00:00 | 2013-01-31 00:00:00 | 2011-01-31 00:00:00 | 2010-10-22 00:00:00 | 2011-07-28 00:00:00 | 2011-04-29 00:00:00 | 2011-10-31 00:00:00 | 2012-01-30 00:00:00 | 2012-10-30 00:00:00 | 2012-07-25 00:00:00 | 2012-04-26 00:00:00 | 2018-10-31 00:00:00 | 2019-10-24 00:00:00 | 2019-04-30 00:00:00 | 2019-07-26 00:00:00 | 2018-07-31 00:00:00 | 2019-01-31 00:00:00 | 2020-07-30 00:00:00 | 2018-01-31 00:00:00 | 2020-04-30 00:00:00 | 2018-04-30 00:00:00 | 2020-01-30 00:00:00 | 2021-08-02 00:00:00 | 2021-04-30 00:00:00 | 2022-08-01 00:00:00 | 2020-11-01 00:00:00 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 2022-05-02 00:00:00 | 2021-11-01 00:00:00 | 2022-10-24 00:00:00 | 2022-01-26 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||
| filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||||||||||||||||||||||
| filing_id | 1396840 | 1371176 | 1344191 | 1504393 | 1459228 | 1279359 | 1483000 | 1259124 | 1432425 | 1450184 | 1421478 | 1294239 | 1325963 | 1307081 | 1738680 | 1570635 | 1532711 | 1605235 | 1590147 | 1622090 | 1634349 | 1707514 | 1674393 | 1655212 | 2319988 | 2415352 | 2379804 | 2393671 | 2273486 | 2348913 | 2484632 | 2210636 | 2471517 | 2242957 | 2441300 | 2603644 | 2581603 | 2707634 | 2529591 | 2554934 | None | 2678291 | 2625548 | 2739591 | 2638565 | |||||||||||||||||||||||||||||||||||||||||||||
| form_id | 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 | None | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||
| receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted |