Home

Filer ID: 1063721

Table: filer_address

filer_id		1063721		1063721		1063721		1063721		1063721
adrid		1071027		2065984		2440219		2320647		2310667
effect_dt		1994-09-27 00:00:00		2004-02-09 00:00:00		2017-09-06 00:00:00		2014-05-15 00:00:00		2014-01-15 00:00:00
add_type		7051		7051		7051		7051		7051
session_id		1993		2003		2017		2013		2013

Table: filer_filings

filer_id		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721
filing_id		377687		440879		817156		994561		1850971		1822513		1836897		2000414		1999972		2184211		2252508		2433182		2582222		2295412		2433265		2521047		2245072		2234901		2454204		2267055		2394354		2176076		2176077		2178373		2179950		2508709		2453619		2205217		2479412		2390433		2445550		2445604		2334265		2176077		2355717		2298416		2251884		2237900		2287724		2214949		2455937		2268527		2630270		2504495		2649224		2666109		2544287		2480154		2689575		2646500		2565586		2595327		2700724		2670821		2636886		2594875		2671604		2610941		2743578		2742916		2725912		2729124		2750098		2731665
period_id		159		139		None		None		None		None		None		None		None		None		None		239		246		235		241		244		234		233		241		234		None		229		231		None		None		None		241		231		241		237		None		None		235		231		None		None		234		None		235		None		None		None		248		243		249		250		243		None		250		None		None		245		250		249		247		247		None		None		None		251		251		252		None		252
form_id		F405		F410		F410		F410		F410		F410		F410		F410		F410		F410		F460		F460		F497		F460		F460		F497		F497		F460		F460		F460		F460		F460		F410		F460		F410		F460		F497		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F497		F460		F460		F460		F497		F460		F497		F497		F460		F460		F497		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F497		F460		F497
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		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
filing_date		1999-07-28 00:00:00		1994-09-19 00:00:00		2002-01-24 00:00:00		2004-02-09 00:00:00		2014-05-15 00:00:00		2014-01-15 00:00:00		2014-03-27 00:00:00		2015-11-30 00:00:00		2015-11-18 00:00:00		2017-09-06 00:00:00		2018-05-22 00:00:00		2020-01-22 00:00:00		2021-05-03 00:00:00		2018-09-25 00:00:00		2020-01-22 00:00:00		2020-10-22 00:00:00		2018-05-02 00:00:00		2018-04-24 00:00:00		2020-02-19 00:00:00		2018-07-20 00:00:00		2019-07-17 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2020-09-23 00:00:00		2020-02-18 00:00:00		2018-01-25 00:00:00		2020-07-20 00:00:00		2019-07-16 00:00:00		2020-01-22 00:00:00		2020-01-22 00:00:00		2019-01-14 00:00:00		2017-09-06 00:00:00		2019-01-15 00:00:00		2018-09-25 00:00:00		2018-05-22 00:00:00		2018-04-25 00:00:00		2018-08-30 00:00:00		2018-01-26 00:00:00		2020-02-19 00:00:00		2018-07-20 00:00:00		2021-12-06 00:00:00		2020-09-23 00:00:00		2022-02-11 00:00:00		2022-04-13 00:00:00		2021-01-14 00:00:00		2020-07-20 00:00:00		2022-06-01 00:00:00		2022-01-24 00:00:00		2021-01-14 00:00:00		2021-07-21 00:00:00		2022-07-25 00:00:00		2022-04-26 00:00:00		2022-01-24 00:00:00		2021-07-20 00:00:00		2022-04-26 00:00:00		2021-07-21 00:00:00		2022-09-29 00:00:00		2022-10-27 00:00:00		2022-09-29 00:00:00		2022-10-05 00:00:00		2022-07-25 00:00:00		2022-10-12 00:00:00
stmnt_type		10001		10001		10002		10002		10006		10006		10006		10006		10006		10006		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10005		10006		10005		10001		10001		10001		10001		10005		10005		10001		10002		10005		10005		10001		10005		10001		10005		10005		10005		10001		10001		10001		10001		10001		10005		10001		10005		10005		10001		10001		10001		10001		10001		10005		10005		10005		10001		10001		10001		10005		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003
session_id		1999		1993		2001		2003		2013		2013		2013		2015		2015		2017		2017		2019		2021		2017		2019		2019		2017		2017		2019		2017		2019		2017		2017		2017		2017		2019		2019		2017		2019		2019		2019		2019		2017		2017		2017		2017		2017		2017		2017		2017		2019		2017		2021		2019		2021		2021		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		TTHAM		TTHAM		TRAMON		TRAMON		TRAMON		LPALMER		TRAMON		TRAMON		HSTOVALL		LFEDOROV		CAFILER		HSTOVALL		LFEDOROV		CAFILER		CAFILER		HSTOVALL		LFEDOROV		CSAGABAEN		SBROWN		CAFILER		RSAGARIO		SMCCONNAN		RSAGARIO		KRUSSELL		CAFILER		BSINGH		VUKSTINA		SBROWN		LFEDOROV		LFEDOROV		LPHEAV		TRAMON		LPHEAV		HSTOVALL		HSTOVALL		HSTOVALL		CAFILER		BSINGH		LFEDOROV		CSAGABAEN		CAFILER		KRUSSELL		KRUSSELL		CAFILER		SUSHAKOV		VUKSTINA		CAFILER		KRUSSELL		SUSHAKOV		KRUSSELL		CAFILER		KRUSSELL		KRUSSELL		CAFILER		KRUSSELL		KRUSSELL		LPHEAV		CAFILER		CAFILER		CAFILER		AXIONG		CAFILER
special_audit		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		None		None		None		None		None		None		None		None		None		None		2018-04-22 00:00:00		2019-07-01 00:00:00		2021-05-03 00:00:00		2018-07-01 00:00:00		2020-01-01 00:00:00		2020-10-22 00:00:00		2018-05-02 00:00:00		2018-01-01 00:00:00		2020-01-19 00:00:00		2018-05-20 00:00:00		2019-01-01 00:00:00		2017-01-01 00:00:00		2017-07-31 00:00:00		2017-01-01 00:00:00		None		2020-07-01 00:00:00		2020-02-18 00:00:00		2017-07-01 00:00:00		2020-02-16 00:00:00		2019-01-01 00:00:00		2020-01-01 00:00:00		2019-07-01 00:00:00		2018-09-23 00:00:00		2017-09-05 00:00:00		2018-09-23 00:00:00		2018-07-01 00:00:00		2018-04-22 00:00:00		2018-01-01 00:00:00		2018-08-30 00:00:00		2017-07-01 00:00:00		2020-01-19 00:00:00		2018-05-20 00:00:00		2021-12-06 00:00:00		2020-07-01 00:00:00		2022-02-11 00:00:00		2022-04-13 00:00:00		2020-09-20 00:00:00		2020-02-16 00:00:00		2022-06-01 00:00:00		2021-07-01 00:00:00		2020-09-20 00:00:00		2021-01-01 00:00:00		2022-04-24 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		2021-07-20 00:00:00		2022-01-01 00:00:00		2021-01-01 00:00:00		2022-07-01 00:00:00		2022-09-25 00:00:00		2022-07-01 00:00:00		2022-10-05 00:00:00		2022-04-24 00:00:00		2022-10-12 00:00:00
rpt_end		None		None		None		None		None		None		None		None		None		None		2018-05-19 00:00:00		2019-12-31 00:00:00		2021-05-03 00:00:00		2018-09-22 00:00:00		2020-01-18 00:00:00		2020-10-22 00:00:00		2018-05-02 00:00:00		2018-04-21 00:00:00		2020-02-15 00:00:00		2018-06-30 00:00:00		2019-06-30 00:00:00		2017-06-30 00:00:00		2017-07-31 00:00:00		2017-06-30 00:00:00		None		2020-09-19 00:00:00		2020-02-18 00:00:00		2017-12-31 00:00:00		2020-06-30 00:00:00		2019-06-30 00:00:00		2020-01-18 00:00:00		2019-12-31 00:00:00		2018-12-31 00:00:00		2017-09-05 00:00:00		2018-12-31 00:00:00		2018-09-22 00:00:00		2018-05-19 00:00:00		2018-04-21 00:00:00		2018-08-30 00:00:00		2017-12-31 00:00:00		2020-02-15 00:00:00		2018-06-30 00:00:00		2021-12-06 00:00:00		2020-09-19 00:00:00		2022-02-11 00:00:00		2022-04-13 00:00:00		2020-12-31 00:00:00		2020-06-30 00:00:00		2022-06-01 00:00:00		2021-12-31 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00		2022-04-23 00:00:00		2021-12-31 00:00:00		2021-07-20 00:00:00		2022-04-23 00:00:00		2021-06-30 00:00:00		2022-09-24 00:00:00		2022-10-22 00:00:00		2022-09-24 00:00:00		2022-10-05 00:00:00		2022-06-30 00:00:00		2022-10-12 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		2020-01-20 00:00:00		2021-05-03 00:00:00		2018-09-24 00:00:00		2020-01-22 00:00:00		2020-10-22 00:00:00		2018-05-02 00:00:00		2018-04-23 00:00:00		2020-02-18 00:00:00		2018-07-16 00:00:00		None		2017-07-31 00:00:00		None		None		None		None		2020-02-18 00:00:00		2018-01-14 00:00:00		2020-07-14 00:00:00		2019-07-13 00:00:00		None		None		2019-01-10 00:00:00		None		None		None		2018-05-17 00:00:00		None		2018-08-30 00:00:00		None		None		None		2021-12-06 00:00:00		2020-09-23 00:00:00		2022-02-11 00:00:00		2022-04-13 00:00:00		2021-01-12 00:00:00		None		2022-06-01 00:00:00		None		None		2021-07-16 00:00:00		2022-07-13 00:00:00		2022-04-25 00:00:00		2022-01-19 00:00:00		2021-07-20 00:00:00		None		None		None		2022-10-26 00:00:00		2022-09-29 00:00:00		2022-10-05 00:00:00		None		2022-10-12 00:00:00
filing_type		None		None		None		None		None		None		None		None		None		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		None		None		None		22001		22001		22001		22001		None		None		22001		22001		None		None		22001		None		22001		None		None		None		22001		22001		22001		22001		22001		None		22001		None		None		22001		22001		22001		22001		22001		None		None		None		22001		22001		22001		None		22001

Table: filer_to_filer_type

filer_id		1063721		1063721		1063721		1063721		1063721
filer_type		16		16		16		16		16
active		Y		Y		Y		Y		Y
race		0		0		0		0		0
session_id		1993		2013		2013		2017		2015
category		0		0		0		0		0
category_type		40503		40503		40503		40502		40503
sub_category		40103		40103		40103		40103		40103
effect_dt		1994-09-27 00:00:00		2014-03-27 00:00:00		2014-01-15 00:00:00		2017-07-31 00:00:00		2015-11-30 00:00:00
sub_category_type		0		0		0		0		0
election_type		0		0		0		0		0
sub_category_a		S		None		S		S		S
nyq_dt		None		1994-10-01 00:00:00		1994-10-01 00:00:00		1994-10-01 00:00:00		1994-10-01 00:00:00
party_cd		None		None		None		None		None
county_cd		18030		18004		18004		18004		18004
district_cd		None		None		None		None		None

Table: filer_xref

filer_id		1063721
xref_id		943044
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		943044		943044		943044		943044		943044		943044		943044		943044		943044		943044		943044		943044		943044		943044		943044		943044		943044		943044		943044		943044
filer_id		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00
naml		TEAMSTERS LOCAL 856 PAC		TEAMSTERS LOCAL 856 PAC		TEAMSTERS LOCAL 856 PAC		TEAMSTERS LOCAL 856 PAC		TEAMSTERS LOCAL 856 PAC		MERCED COUNTY TEAMSTER CORRECTIONAL OFFICERS PAC		MERCED COUNTY TEAMSTER CORRECTIONAL OFFICERS PAC		MERCED COUNTY TEAMSTER CORRECTIONAL OFFICERS PAC		MERCED COUNTY TEAMSTER CORRECTIONAL OFFICERS PAC		MERCED COUNTY TEAMSTER CORRECTIONAL OFFICERS PAC		MERCED COUNTY SHERIFF'S EMPLOYEE ASSOCIATION POLITICAL ACTION COMMITTEE		MERCED COUNTY SHERIFF'S EMPLOYEE ASSOCIATION POLITICAL ACTION COMMITTEE		MERCED COUNTY SHERIFF'S EMPLOYEE ASSOCIATION POLITICAL ACTION COMMITTEE		MERCED COUNTY SHERIFF'S EMPLOYEE ASSOCIATION POLITICAL ACTION COMMITTEE		MERCED COUNTY SHERIFF'S EMPLOYEE ASSOCIATION POLITICAL ACTION COMMITTEE		MERCED COUNTY SHERIFF'S EMPLOYEE ASSOCIATION		MERCED COUNTY SHERIFF'S EMPLOYEE ASSOCIATION		MERCED COUNTY SHERIFF'S EMPLOYEE ASSOCIATION		MERCED COUNTY SHERIFF'S EMPLOYEE ASSOCIATION		MERCED COUNTY SHERIFF'S EMPLOYEE ASSOCIATION
namf		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
nams		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
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		MERCED		MERCED		SACRAMENTO		SACRAMENTO		SACRAMENTO		MERCED		MERCED		SACRAMENTO		SACRAMENTO		SACRAMENTO		MERCED		MERCED		SACRAMENTO		SACRAMENTO		SACRAMENTO		MERCED		MERCED		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		953400000		953400000		95814		95814		95814		953400000		953400000		95814		95814		95814		953400000		953400000		95814		95814		95814		953400000		953400000		95814		95814		95814
phon		2097265162		2093853031		9164460291		9164460291		9164460291		2097265162		2093853031		9164460291		9164460291		9164460291		2097265162		2093853031		9164460291		9164460291		9164460291		2097265162		2093853031		9164460291		9164460291		9164460291
fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
email		None		None		None		[email protected]		[email protected]		None		None		None		[email protected]		[email protected]		None		None		None		[email protected]		[email protected]		None		None		None		[email protected]		[email protected]

Table: filers

filer_id		1063721

Table: received_filings

filer_id		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721		1063721
filing_file_name		95598.cal		2453619_0.cal		2245072_0.cal		2287724_0.cal		2731665_0.cal		2666109_0.cal		2521047_0.cal		50427.cal		118698.cal		323877.cal		2582222_0.cal		2630270_0.cal		2649224_0.cal		2729124_0.cal		2689575_0.cal		2594875_0.cal
received_date		2017-07-31 00:00:00		2020-02-18 00:00:00		2018-05-02 00:00:00		2018-08-30 00:00:00		2022-10-12 00:00:00		2022-04-13 00:00:00		2020-10-22 00:00:00		2022-10-12 00:00:00		2021-07-20 00:00:00		2021-05-03 00:00:00		2021-05-03 00:00:00		2021-12-06 00:00:00		2022-02-11 00:00:00		2022-10-05 00:00:00		2022-06-01 00:00:00		2021-07-20 00:00:00
filing_directory		/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/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		None		2453619		2245072		2287724		2731665		2666109		2521047		None		None		None		2582222		2630270		2649224		2729124		2689575		2594875
form_id		None		F497		F497		F497		F497		F497		F497		None		None		None		F497		F497		F497		F497		F497		F497
receive_comment		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted