| filing_id | 768938 | 770990 | 788419 | 813676 | 813676 | 788419 | 837909 | 854278 | 881740 | 906523 | 930021 | 943697 | 966813 | 984754 | 2312935 | 2374548 | 2335094 | 2390460 | 2467269 | 2412624 | 2430925 | 2478581 | 2547487 | 2574840 | 2523582 | 2597981 | 2620668 | 2636821 | 2739576 | 2668489 | 2699193 | |||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| sender_id | None | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | |||||||||||||||||||||||||||||||
| filer_id | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| filer_naml | VACAVILLE, CITY OF | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; 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 | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| report_num | None | 000 | 000 | 000 | 001 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||||||||||||||||||||
| rpt_date | 2001-04-27 00:00:00 | 2001-07-19 00:00:00 | 2001-10-18 00:00:00 | 2002-01-31 00:00:00 | 2002-04-25 00:00:00 | 2002-04-25 00:00:00 | 2002-04-24 00:00:00 | 2002-07-30 00:00:00 | 2002-10-22 00:00:00 | 2003-01-20 00:00:00 | 2003-04-28 00:00:00 | 2003-07-21 00:00:00 | 2003-10-23 00:00:00 | 2004-01-20 00:00:00 | 2018-10-25 00:00:00 | 2019-04-17 00:00:00 | 2019-01-17 00:00:00 | 2019-07-16 00:00:00 | 2020-04-24 00:00:00 | 2019-10-10 00:00:00 | 2020-01-15 00:00:00 | 2020-07-15 00:00:00 | 2021-01-26 00:00:00 | 2021-04-19 00:00:00 | 2020-10-27 00:00:00 | 2021-07-28 00:00:00 | 2021-10-27 00:00:00 | 2022-01-24 00:00:00 | 2022-10-24 00:00:00 | 2022-04-21 00:00:00 | 2022-07-19 00:00:00 | |||||||||||||||||||||||||||||||
| from_date | 2001-01-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2001-07-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-04-01 00:00:00 | 2020-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-04-01 00:00:00 | 2020-10-01 00:00:00 | 2021-01-01 00:00:00 | 2020-07-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | |||||||||||||||||||||||||||||||
| thru_date | 2001-03-31 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 2001-09-30 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | 2020-03-31 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2020-09-30 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-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 | 2001-01-01 00:00:00 | 2001-03-01 00:00:00 | 2001-03-01 00:00:00 | 2001-03-01 00:00:00 | 2001-03-01 00:00:00 | 2001-03-01 00:00:00 | 2001-03-01 00:00:00 | 2001-03-01 00:00:00 | 2001-03-01 00:00:00 | 2001-03-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-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 | 2021-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 | |||||||||||||||||||||||||||||||
| firm_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||
| firm_name | None | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | CITY OF VACAVILLE | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||
| firm_city | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| firm_zip4 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | |||||||||||||||||||||||||||||||
| firm_phon | 7074696400 | 707-469-6480 | 707-469-6480 | 707-469-6480 | 707-469-6480 | 707-469-6480 | 707-469-6480 | 707-469-6480 | 707-469-6480 | 707-469-6480 | 707-469-6400 | 707-469-6400 | 707-469-6400 | 707-469-6400 | 7074495100 | 7074696400 | 7074495100 | 7074696400 | 7074696400 | 7074696400 | 7074696400 | 7074696400 | 7074696400 | 7074495100 | 7074696400 | 7074495100 | 7074495100 | 7074495100 | 7074495100 | 7074495100 | 7074495100 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| sig_date | None | 2001-07-19 00:00:00 | 2001-10-18 00:00:00 | 2002-01-31 00:00:00 | 2002-04-25 00:00:00 | 2002-04-25 00:00:00 | 2002-04-24 00:00:00 | 2002-07-30 00:00:00 | 2002-10-22 00:00:00 | 2003-01-20 00:00:00 | 2003-04-28 00:00:00 | 2003-07-21 00:00:00 | 2003-10-23 00:00:00 | 2004-01-20 00:00:00 | 2018-10-25 00:00:00 | 2019-04-17 00:00:00 | 2019-01-17 00:00:00 | 2019-07-16 00:00:00 | 2020-04-24 00:00:00 | 2019-10-10 00:00:00 | 2020-01-15 00:00:00 | 2020-07-15 00:00:00 | 2021-01-26 00:00:00 | 2021-04-19 00:00:00 | 2020-10-27 00:00:00 | 2021-07-28 00:00:00 | 2021-10-27 00:00:00 | 2022-01-24 00:00:00 | 2022-10-24 00:00:00 | 2022-04-21 00:00:00 | 2022-07-19 00:00:00 | |||||||||||||||||||||||||||||||
| sig_loc | None | SACRAMENTO CA | SACRAMENTO CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | Vacaville, CA | Vacaville, CA | Vacaville, CA | Vacaville, CA | Vacaville, CA | Vacaville, CA | Vacaville, CA | Vacaville, CA | Vacaville, CA | Vacaville, CA | Vacaville, CA | Vacaville, CA | Vacaville, CA | Vacaville, CA | Vacaville, CA | Vacaville, CA | Vacaville, CA | |||||||||||||||||||||||||||||||
| sig_naml | None | EICHMAN AGENT | EICHMAN AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | Craig | Craig | Craig | Craig | Busch | Craig | Craig | Busch | Busch | Busch | Busch | Busch | Bucsh | Bucsh | Busch | Busch | Busch | |||||||||||||||||||||||||||||||
| sig_namf | None | J RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | Jeremy | Jeremy | Jeremy | Jeremy | Aaron | Jeremy | Jeremy | Aaron | Aaron | Aaron | Aaron | Aaron | Aaron | Aaron | Aaron | Aaron | Aaron | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| prn_naml | None | EICHMAN AGENT | EICHMAN AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | EICHMAN, AGENT | Craig | Craig | Craig | Craig | Busch | Craig | Craig | Busch | Busch | Busch | Busch | Busch | Bucsh | Bucsh | Busch | Busch | Busch | |||||||||||||||||||||||||||||||
| prn_namf | None | J RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | J. RICHARD | Jeremy | Jeremy | Jeremy | Jeremy | Aaron | Jeremy | Jeremy | Aaron | Aaron | Aaron | Aaron | Aaron | Aaron | Aaron | Aaron | Aaron | Aaron | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| sig_title | None | CERTIFIED PUBLIC ACCOUNTANT 4101 SB | CERTIFIED PUBLIC ACCOUNTANT 4101 SB | CERTIFIED PUBLIC ACCOUNTANT 4101 SB | CERTIFIED PUBLIC ACCOUNTANT 4101 SB | CERTIFIED PUBLIC ACCOUNTANT 4101 SB | CERTIFIED PUBLIC ACCOUNTANT 4101 SB | CERTIFIED PUBLIC ACCOUNTANT 4101 SB | CERTIFIED PUBLIC ACCOUNTANT 4101 SB | CERTIFIED PUBLIC ACCOUNTANT 4101 SB | CERTIFIED PUBLIC ACCOUNTANT 4101 SB | CERTIFIED PUBLIC ACCOUNTANT 4101 SB | CERTIFIED PUBLIC ACCOUNTANT 4101 SB | CERTIFIED PUBLIC ACCOUNTANT 4101 SB | 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 | 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| ctrib_n_cb | 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| lby_actvty | None | AB 95; SB 75; Legislature Governor's Office CA Regional Water Quality Control Board Cal/EPA & State Water Resources Control Board Re: NPDES & cease & desist orders proposed for the City's Easterly Wastewater Treatment Plant in Elmira | Legislature Governor's Office CA Regional Water Quality Control Board Cal/EPA & State Water Resources Control Board Re: water quality policies proposed for the City's Easterly Wastewater Treatment Plant in Elmira and other entities | State Water Resources Control Board Re: petitiion for review of Vacaville's permit to operate the City's Easterly Wastewater Treatment Plant in Elmira and other entities | State Water Resources Control Board Re: petitiion for review of Vacaville's permit to operate the City's Easterly Wastewater Treatment Plant in Elmira and other entities | Legislature, Governor's Office, CA Regional Water Quality Control Board, Cal/EPA & State Water Resources Control Board Re: water quality policies proposed for the City's Easterly Wastewater Treatment Plant in Elmira and other entities | State Water Resources Control Board Re: petitiion for review of Vacaville's permit to operate the City's Easterly Wastewater Treatment Plant in Elmira and other entities | State Water Resources Control Board Re: petitiion for review of Vacaville's permit to operate the City's Easterly Wastewater Treatment Plant in Elmira and other entities | State Water Resources Control Board Re: petition for review of Vacaville's permit to operate the City's Easterly Wastewater Treatment Plant in Elmira and other entities; Legislature Re: Budget '02 - '03 | None | None | None | None | None | No reportable activity this quarter. | Legislature & Administration Re: All matters related to Transportation and Housing . AB 190 SB 50, 72 | No reportable activity this quarter. | AB 74, 1356 | AB 1917 SB 808, 848 SB 50, 902 SB 795, 1179 | AB 139 SB 5, 744 | SB 5, 50 | AB 89, 90, 100, 899, 902 SB 74, 902, 995, 1085, 1120, 1385 Governor?s Office, Legislature, and Administration Re: 2020-21 Budget Funding, COVID-19 Response and Homeless Allocations. | Governor?s Office, Legislature, and Administration Re: COVID-19 Response, CARES Act Funding, Housing & Zoning Legislation, and Homeless Allocations. | COVID-19 Funding: Recovery & Relief i.e. small businesses, vaccine distribution, access to testing/contact tracing, funding for alternatives to provide services to the public. COVID-19: Workplace Health & Safety, EDD Claims, Telehealth, Emergency Relief vs. Standard Relief, Education/School Closures. Federal Relief Packages implementation for Cities. | AB 685 SB 902, 1120, 1383 Governor?s Office, Legislature, and Administration Re: COVID-19 Response, CARES Act Funding, Housing & Zoning Legislation, and Homeless Allocations. | Legislature & Administration Re: All matters pertaining to housing & community development. AB 128, 339 SB 9, 129 | No Place Like Home Program, Affordable Housing Sustainable Communities Program, Multi family Housing Program, Housing for a Healthy California Program, HCD, SGC, Homeless Coordinating and Financing Council, | Legislature & Administration Re: Housing & Community Development, Covid-19 Policies, and local funding. | Governor?s Office, Legislature, and Administration Re: 2022-23 Budget Funding, Housing & Community Development, and Local Funding. AB 179, 1886, 2011, 2752 SB 6 | Legislature & Administration Re: Housing & Community Development, Covid-19 Policies, and local funding. Governor Newsom?s Real Public Safety Plan Governor Newsom?s CARE Court. COVID-19 Supplemental Paid Sick Leave | Governor?s Office, Legislature, and Administration Re: 2022-23 Budget Funding, Vitality of Cities, Housing & Community Development, and Local Funding. AB 178, 180, 2186 SB 178, 180 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 |
| filing_id | 2305338 | 2329918 | 2540997 | |||
|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | |||
| rec_type | CVR | CVR | CVR | |||
| form_type | F602 | F602 | F602 | |||
| sender_id | F00462 | F00462 | F00462 | |||
| filer_id | 1234076 | 1234076 | 1234076 | |||
| entity_cd | LEM | LEM | LEM | |||
| filer_naml | VACAVILLE, CITY OF | VACAVILLE, CITY OF | VACAVILLE, CITY OF | |||
| filer_namf | None | None | None | |||
| filer_namt | None | None | None | |||
| filer_nams | None | None | None | |||
| report_num | 000 | 000 | 000 | |||
| rpt_date | 2018-10-11 00:00:00 | 2018-12-27 00:00:00 | 2020-12-30 00:00:00 | |||
| ls_beg_yr | 2017 | 2019 | 2021 | |||
| ls_end_yr | 2018 | 2020 | 2022 | |||
| qual_date | None | None | None | |||
| eff_date | 2018-09-28 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | |||
| bus_city | VACAVILLE | VACAVILLE | VACAVILLE | |||
| bus_st | CA | CA | CA | |||
| bus_zip4 | 95688 | 95688 | 95688 | |||
| bus_phon | 7074696400 | 7074696400 | 7074495100 | |||
| bus_fax | 7074696480 | 7074696480 | None | |||
| bus_email | None | None | None | |||
| mail_city | None | None | None | |||
| mail_st | None | None | None | |||
| mail_zip4 | None | None | None | |||
| mail_phon | None | None | None | |||
| sig_date | 2018-10-11 00:00:00 | 2018-12-27 00:00:00 | 2020-12-30 00:00:00 | |||
| sig_loc | Vacaville, CA | Vacaville, CA | Vacaville, CA | |||
| sig_naml | Craig | Craig | Busch | |||
| sig_namf | Jeremy | Jeremy | Aaron | |||
| sig_namt | None | None | None | |||
| sig_nams | None | None | None | |||
| prn_naml | Craig | Craig | Busch | |||
| prn_namf | Jeremy | Jeremy | Aaron | |||
| prn_namt | None | None | None | |||
| prn_nams | None | None | None | |||
| sig_title | City Manager | City Manager | City Manager | |||
| stmt_firm | None | None | None | |||
| ind_cb | None | None | None | |||
| bus_cb | None | None | None | |||
| trade_cb | None | None | None | |||
| oth_cb | X | X | X | |||
| a_b_name | None | None | None | |||
| a_b_city | None | None | None | |||
| a_b_st | None | None | None | |||
| a_b_zip4 | None | None | None | |||
| descrip_1 | Local Government-Serving the best interests of the citizens of the City of Vacaville. | Local Government-Serving the best interests of the citizens of the City of Vacaville. | Local Government-Serving the best interests of the citizens of the City of Vacaville. | |||
| descrip_2 | None | None | None | |||
| c_less50 | None | None | None | |||
| c_more50 | None | None | None | |||
| ind_class | GOV | GOV | GOV | |||
| ind_descr | None | None | None | |||
| bus_class | None | None | None | |||
| bus_descr | None | None | None | |||
| auth_name | GONSALVES & SON, JOE A. | GONSALVES & SON, JOE A. | GONSALVES & SON, JOE A. | |||
| auth_city | Sacramento | Sacramento | Sacramento, | |||
| auth_st | CA | CA | CA | |||
| auth_zip4 | 95814 | 95814 | 95814 | |||
| lobby_int | None | None | None | |||
| influen_yn | None | None | None | |||
| firm_name | None | None | None | |||
| newcert_cb | None | None | None | |||
| rencert_cb | None | None | None | |||
| complet_dt | None | None | None | |||
| lby_reg_cb | None | None | None | |||
| lby_604_cb | None | None | None | |||
| st_leg_yn | None | None | None | |||
| st_agency | None | None | None | |||
| lobby_cb | None | None | None | |||
| l_firm_cb | None | None | None |
| filing_date | 2001-07-27 00:00:00 | 2001-07-27 00:00:00 | 2001-10-23 00:00:00 | 2001-10-23 00:00:00 | 2002-01-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-26 00:00:00 | 2002-04-26 00:00:00 | 2002-04-26 00:00:00 | 2002-04-26 00:00:00 | 2002-04-26 00:00:00 | 2002-07-30 00:00:00 | 2002-07-30 00:00:00 | 2002-04-26 00:00:00 | 2002-04-26 00:00:00 | 2002-10-29 00:00:00 | 2002-10-29 00:00:00 | 2003-01-27 00:00:00 | 2003-01-27 00:00:00 | 2003-04-29 00:00:00 | 2003-04-29 00:00:00 | 2003-07-23 00:00:00 | 2003-07-23 00:00:00 | 2003-10-24 00:00:00 | 2003-10-24 00:00:00 | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filingstatus | 1 | 0 | 1 | 0 | 1 | 0 | 2 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | |||||||||||||||||||||||||
| vendor | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | NETFILE | |||||||||||||||||||||||||
| filer_id | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| error_no | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ERROR 301 | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED |
| filer_id | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| adrid | 2014452 | 2044199 | 2471622 | 2512774 | 2547089 | 2463260 | ||||||
| effect_dt | 2001-03-01 00:00:00 | 2003-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | 2018-09-28 00:00:00 | ||||||
| add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||
| session_id | 2001 | 2003 | 2019 | 2021 | 2023 | 2017 |
| filer_id | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 741066 | 741069 | 763907 | 753015 | 795295 | 788419 | 768938 | 770990 | 776345 | 776359 | 779230 | 813676 | 822677 | 788419 | 813676 | 837909 | 845973 | 845974 | 844618 | 862751 | 854278 | 908507 | 881740 | 902329 | 883674 | 906523 | 933755 | 943697 | 930021 | 966813 | 967510 | 953765 | 984754 | 995273 | 2390460 | 2335094 | 2307296 | 2363645 | 2412624 | 2374548 | 2467269 | 2329918 | 2305338 | 2478581 | 2540997 | 2430925 | 2556571 | 2312935 | 2620668 | 2597981 | 2523582 | 2699193 | 2547487 | 2574840 | 2636821 | 2668489 | 2739576 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| period_id | None | None | 165 | 165 | None | 167 | 165 | 166 | None | None | None | 168 | None | 167 | 168 | 169 | None | None | None | None | 170 | None | 171 | None | None | 172 | None | 174 | 173 | 175 | None | None | 176 | None | 238 | 236 | None | None | 239 | 237 | 241 | 236 | 236 | 242 | 244 | 240 | None | 235 | 247 | 246 | 243 | 250 | 244 | 245 | 248 | 249 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F602 | F999 | F690 | F635 | F635 | F635 | F635 | F635 | F605 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F690 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F602 | F602 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_date | 2001-03-19 00:00:00 | 2001-03-19 00:00:00 | 2001-05-08 00:00:00 | 2001-04-27 00:00:00 | 2001-10-24 00:00:00 | 2001-10-23 00:00:00 | 2001-04-27 00:00:00 | 2001-07-27 00:00:00 | 2001-08-02 00:00:00 | 2001-08-02 00:00:00 | 2001-07-31 00:00:00 | 2002-01-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-26 00:00:00 | 2002-04-26 00:00:00 | 2002-04-26 00:00:00 | 2002-04-29 00:00:00 | 2002-04-29 00:00:00 | 2002-04-29 00:00:00 | 2002-07-31 00:00:00 | 2002-07-30 00:00:00 | 2003-01-27 00:00:00 | 2002-10-29 00:00:00 | 2002-12-27 00:00:00 | 2002-10-29 00:00:00 | 2003-01-27 00:00:00 | 2003-04-29 00:00:00 | 2003-07-23 00:00:00 | 2003-04-29 00:00:00 | 2003-10-24 00:00:00 | 2003-10-24 00:00:00 | 2003-07-25 00:00:00 | 2004-01-22 00:00:00 | 2004-01-26 00:00:00 | 2019-07-16 00:00:00 | 2019-01-17 00:00:00 | 2018-10-11 00:00:00 | 2018-12-27 00:00:00 | 2019-10-10 00:00:00 | 2019-04-17 00:00:00 | 2020-04-24 00:00:00 | 2018-12-27 00:00:00 | 2018-10-11 00:00:00 | 2020-07-15 00:00:00 | 2020-12-30 00:00:00 | 2020-01-15 00:00:00 | 2020-12-31 00:00:00 | 2018-10-25 00:00:00 | 2021-10-27 00:00:00 | 2021-07-28 00:00:00 | 2020-10-27 00:00:00 | 2022-07-19 00:00:00 | 2021-01-26 00:00:00 | 2021-04-19 00:00:00 | 2022-01-24 00:00:00 | 2022-04-21 00:00:00 | 2022-10-24 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_type | 10005 | 10005 | 10006 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10002 | 10002 | 10001 | 10006 | 10006 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| session_id | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2019 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2019 | 2021 | 2019 | 2021 | 2017 | 2021 | 2021 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| user_id | GPEREZ | GPEREZ | YBONILLA | LTHIBAUL | LTHIBAUL | * | MHOANG | * | CFLAGG | CFLAGG | LTHIBAUL | * | LTHIBAUL | * | * | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | GGILMORE | * | LTHIBAUL | * | PBANFORD | MHOANG | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | VUKSTINA | AGLADNEY | YRODRIGU | GPEREZ | GTAYLOR | GTAYLOR | SUSHAKOV | GPEREZ | YRODRIGU | MMERCHANT | MMERCHANT | AGLADNEY | MMERCHANT | AGLADNEY | MKIRKHAM | MKIRKHAM | GTAYLOR | CAFILER | GTAYLOR | CHATRIDGE | CHATRIDGE | CAFILER | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11002 | 11003 | 11003 | 11003 | 11003 | 11002 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_start | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | None | 2001-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-04-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 2002-10-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-01-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-04-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 2019-04-01 00:00:00 | 2018-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 | 2018-12-27 00:00:00 | 2018-10-11 00:00:00 | 2020-04-01 00:00:00 | 2020-12-30 00:00:00 | 2019-10-01 00:00:00 | 1900-01-01 00:00:00 | 2018-07-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2020-07-01 00:00:00 | 2022-04-01 00:00:00 | 2020-10-01 00:00:00 | 2021-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_end | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-09-30 00:00:00 | 2001-09-30 00:00:00 | None | 2001-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-06-30 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-03-31 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-06-30 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2019-06-30 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2019-03-31 00:00:00 | 2020-03-31 00:00:00 | 2018-12-27 00:00:00 | 2018-10-11 00:00:00 | 2020-06-30 00:00:00 | 2020-12-30 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2020-09-30 00:00:00 | 2022-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | None | 22001 | 22001 | 22001 | None | None | 22001 | None | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22001 | 22001 | 22006 | 22001 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 |
| filer_id | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| session_id | 2003 | 2001 | 2017 | 2019 | 2021 | 2023 | ||||||
| interest_cd | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | ||||||
| effect_date | 2003-01-01 00:00:00 | 2001-03-01 00:00:00 | 2018-09-28 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 |
| filer_id | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||
| active | Y | Y | T | Y | Y | Y | N | |||||||
| race | 0 | None | None | None | None | None | None | |||||||
| session_id | 2001 | 2003 | 2003 | 2021 | 2019 | 2017 | 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 | 2001-03-01 00:00:00 | 2003-01-01 00:00:00 | 2003-12-31 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2018-09-28 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 | 2001-04-01 00:00:00 | None | None | 2001-04-01 00:00:00 | 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 | 1234076 | |
|---|---|---|
| xref_id | 1234076 | |
| effect_dt | 2001-04-03 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | ||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||
| naml | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | VACAVILLE, CITY OF | VACAVILLE, CITY OF | VACAVILLE, CITY OF | VACAVILLE, CITY OF | VACAVILLE, CITY OF | VACAVILLE, CITY OF | VACAVILLE, CITY OF | VACAVILLE, CITY OF | VACAVILLE, CITY OF | VACAVILLE, CITY OF | VACAVILLE, CITY OF | VACAVILLE, 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 | ||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||
| city | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | VACAVILLE | ||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||
| zip4 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | 95688 | ||||||||||||||||||||||||||||||||||||
| phon | 7074696400 | 7074696400 | 7074495100 | 7074696400 | 7074495100 | 7074495100 | 7074696400 | 7074696400 | 7074495100 | 7074696400 | 7074495100 | 7074495100 | 7074696400 | 7074696400 | 7074495100 | 7074696400 | 7074495100 | 7074495100 | 7074696400 | 7074696400 | 7074495100 | 7074696400 | 7074495100 | 7074495100 | 7074696400 | 7074696400 | 7074495100 | 7074696400 | 7074495100 | 7074495100 | 7074696400 | 7074696400 | 7074495100 | 7074696400 | 7074495100 | 7074495100 | ||||||||||||||||||||||||||||||||||||
| fax | 7074696480 | 7074696480 | 7074696480 | 7074696480 | 7074696480 | 7074696480 | 7074696480 | 7074696480 | 7074696480 | 7074696480 | 7074696480 | 7074696480 | 7074696480 | 7074696480 | 7074696480 | 7074696480 | 7074696480 | 7074696480 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1234076 |
|---|
| filer_id | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| change_no | 1 | 3 | 0 | 2 | 4 | 5 | 6 | |||||||
| session_id | 2001 | 2001 | 2001 | 2001 | 2003 | 2017 | 2021 | |||||||
| log_dt | 2001-03-19 00:00:00 | 2002-08-01 00:00:00 | 2001-08-02 00:00:00 | 2002-08-01 00:00:00 | 2003-12-24 00:00:00 | 2018-10-11 00:00:00 | 2020-12-31 00:00:00 | |||||||
| filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||
| correction_flg | Y | None | Y | None | Y | Y | None | |||||||
| action | NEW | DELETED | ADDED | DELETED | DELETED | ADDED | CHANGED | |||||||
| attribute_changed | EMPLOYER | FIRM | EMPLOYER | FIRM | None | FIRM | RESPONSIBLE OFFICER | |||||||
| ethics_dt | None | None | None | None | None | None | None | |||||||
| interests | GOVERNMENT | None | None | None | None | None | None | |||||||
| filer_full_name | VACAVILLE, CITY OF | VACAVILLE, CITY OF | VACAVILLE, CITY OF | VACAVILLE, CITY OF | VACAVILLE, CITY OF | VACAVILLE; CITY OF | VACAVILLE; CITY OF | |||||||
| filer_city | None | None | None | None | None | VACAVILLE | None | |||||||
| filer_st | None | None | None | None | None | CA | None | |||||||
| filer_zip | None | None | None | None | None | 95688 | None | |||||||
| filer_phone | None | None | None | None | None | 7074696400 | None | |||||||
| entity_type | 2 | 3 | 2 | 3 | 3 | 3 | 20 | |||||||
| entity_name | THE GUALCO GROUP | FERGUSON GROUP, L.L.C., THE | FERGUSON GROUP, L.L.C., THE | FERGUSON GROUP, L.L.C., THE | GUALCO GROUP, INC., THE | GONSALVES & SON; JOE A. | CITY MANAGER AARON BUSCH | |||||||
| entity_city | None | None | None | None | None | None | None | |||||||
| entity_st | None | None | None | None | None | None | None | |||||||
| entity_zip | None | None | None | None | None | None | None | |||||||
| entity_phone | None | None | None | None | None | None | None | |||||||
| entity_id | 0 | 1147613 | 1147613 | 1147613 | 1147392 | None | 1436019 | |||||||
| responsible_officer | None | None | None | None | None | None | None | |||||||
| effect_dt | 2001-03-01 00:00:00 | 2002-07-01 00:00:00 | 2001-07-18 00:00:00 | 2002-07-01 00:00:00 | 2003-12-31 00:00:00 | 2018-09-28 00:00:00 | 2021-01-01 00:00:00 |
| filer_id | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | 1234076 | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 770990_0.cal | 788419_0.cal | 813676_0.cal | 218147.cal | 788419_1.cal | 813676_1.cal | 837909_0.cal | 854278_0.cal | 881740_0.cal | 906523_0.cal | 943697_0.cal | 930021_0.cal | 966813_0.cal | |||||||||||||
| received_date | 2001-07-27 00:00:00 | 2001-10-23 00:00:00 | 2002-01-31 00:00:00 | 2002-04-26 00:00:00 | 2002-04-26 00:00:00 | 2002-04-26 00:00:00 | 2002-04-26 00:00:00 | 2002-07-30 00:00:00 | 2002-10-29 00:00:00 | 2003-01-27 00:00:00 | 2003-07-23 00:00:00 | 2003-04-29 00:00:00 | 2003-10-24 00:00:00 | |||||||||||||
| filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||
| filing_id | 770990 | 788419 | 813676 | None | 788419 | 813676 | 837909 | 854278 | 881740 | 906523 | 943697 | 930021 | 966813 | |||||||||||||
| form_id | F635 | F635 | F635 | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||
| receive_comment | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing passed validation, but failed DB constraints | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings |