OpenCalAccess

Filer ID: 1263100

Table: cvr_campaign_disclosure
filing_id	1049088	1045526	1059197	1053524	1051895	1069970	1055014	1050477	1049758	1048654	1048652	1048656	1048654	1051938	1044212	1024284	1173779	1137139	1137139	1104069	1143699	1117233	1117233	1156779	1130490	1175421	1210766	1213713	1177421	1211578	1212022	1156779	1190730	1235013	1309750	1334584	1283831	1319813	1394518	1349516	1362560	1436697	1490906	1463782	1473991	1506044	1522056	1530904	1570338	1663310	1646855	1606212	1634626	1678511	1733259	1738044	1694234	1831741	1815887	1781731	1870824	1933345	1981099	2010437	2061616	2173755	2128629	2210208	2249519	2253180	2274891	2296573	2312289	2306650	2296573	2312289	2348770	2324233	2377719	2393422	2348770	2454887	2454906	2441895	2440930	2436185	2498878	2485278	2550155	2520644	2521890	2512497	2505012	2526715	2601010	2648901	2655130	2641369	2665924	2672553	2622462	2687781	2704106	2733414	2742431	2750803	2747847
amend_id	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F497	F496	F497	F497	F497	F460	F497	F497	F497	F497	F460	F496	F497	F497	F460	F460	F460	F497	F497	F460	F460	F460	F460	F460	F460	F497	F497	F497	F497	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F460	F497	F460	F460	F460	F497	F460	F460	F460	F497	F460	F497	F460	F497	F497	F460	F460	F460	F497	F497	F460	F497	F460	F497	F497	F460	F497	F460	F460	F497	F460	F497	F460	F497	F497
filer_id	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100
entity_cd	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP
filer_naml	CalPASC PAC	CalPASC PAC	CalPASC PAC	CalPASC PAC	CalPASC PAC	California Professional Association of Specialty Contractors PAC	CalPASC PAC	CalPASC PAC	CalPASC PAC	CalPASC PAC	CalPASC PAC	CalPASC PAC	CalPASC PAC	CalPASC PAC	CalPASC PAC	CalPASC PAC	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC	California Professional Association of Specialty Contractors PAC	California Professional Association of Specialty Contractors PAC	California Professional Association of Specialty Contractors PAC	California Professional Association of Specialty Contractors PAC	California Professional Association of Specialty Contractors PAC	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)
filer_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	001	000	000	000	000	000	000	000	000	001	000	000	000	001	000	000	000	000	000	000	000	000	001	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	001	000	000	000	000	001	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000
rpt_date	2004-10-19 00:00:00	2004-10-06 00:00:00	2004-11-01 00:00:00	2004-10-25 00:00:00	2004-10-22 00:00:00	2004-12-31 00:00:00	2004-10-27 00:00:00	2004-10-21 00:00:00	2004-10-20 00:00:00	2004-10-18 00:00:00	2004-10-16 00:00:00	2004-10-18 00:00:00	2004-10-18 00:00:00	2004-10-22 00:00:00	2004-09-30 00:00:00	2004-06-30 00:00:00	2006-05-22 00:00:00	2005-11-14 00:00:00	2005-11-17 00:00:00	2005-04-29 00:00:00	2006-01-24 00:00:00	2005-07-29 00:00:00	2005-08-01 00:00:00	2006-03-20 00:00:00	2005-10-25 00:00:00	2006-05-26 00:00:00	2006-10-24 00:00:00	2006-10-27 00:00:00	2006-05-31 00:00:00	2006-10-25 00:00:00	2006-10-21 00:00:00	2006-07-14 00:00:00	2006-07-14 00:00:00	2007-01-15 00:00:00	2008-01-18 00:00:00	2008-05-19 00:00:00	2007-07-13 00:00:00	2008-03-19 00:00:00	2009-01-15 00:00:00	2008-07-14 00:00:00	2008-10-04 00:00:00	2009-07-12 00:00:00	2010-05-23 00:00:00	2010-01-16 00:00:00	2010-03-19 00:00:00	2010-07-13 00:00:00	2010-10-02 00:00:00	2010-10-16 00:00:00	2011-01-12 00:00:00	2012-05-20 00:00:00	2012-03-17 00:00:00	2011-07-12 00:00:00	2012-01-23 00:00:00	2012-07-23 00:00:00	2013-01-28 00:00:00	2013-01-10 00:00:00	2012-09-30 00:00:00	2014-03-18 00:00:00	2014-01-21 00:00:00	2013-07-17 00:00:00	2014-07-19 00:00:00	2015-01-19 00:00:00	2015-07-31 00:00:00	2016-01-21 00:00:00	2016-07-14 00:00:00	2017-07-12 00:00:00	2017-01-17 00:00:00	2018-01-08 00:00:00	2018-05-15 00:00:00	2018-05-22 00:00:00	2018-07-25 00:00:00	2018-09-26 00:00:00	2018-10-20 00:00:00	2018-10-15 00:00:00	2019-04-10 00:00:00	2019-04-10 00:00:00	2019-01-31 00:00:00	2018-11-05 00:00:00	2019-04-10 00:00:00	2019-07-11 00:00:00	2019-04-10 00:00:00	2020-02-20 00:00:00	2020-02-19 00:00:00	2020-01-31 00:00:00	2020-01-28 00:00:00	2020-01-27 00:00:00	2020-09-04 00:00:00	2020-07-24 00:00:00	2021-01-28 00:00:00	2020-10-21 00:00:00	2020-10-23 00:00:00	2020-10-09 00:00:00	2020-09-23 00:00:00	2020-10-29 00:00:00	2021-07-27 00:00:00	2022-02-10 00:00:00	2022-03-04 00:00:00	2022-01-24 00:00:00	2022-04-13 00:00:00	2022-04-27 00:00:00	2021-10-28 00:00:00	2022-05-27 00:00:00	2022-07-28 00:00:00	2022-10-14 00:00:00	2022-10-27 00:00:00	2022-11-02 00:00:00	2022-10-31 00:00:00
stmt_type	None	None	None	None	None	SA	None	None	None	None	PE	None	None	None	QT	SA	PE	None	None	QT	NA	QT	QT	PE	QT	None	None	None	None	None	PE	PE	SA	SA	SA	PE	SA	PE	SA	SA	PE	SA	PE	SA	PE	SA	PE	PE	SA	PE	PE	SA	SA	SA	None	SA	PE	PE	SA	SA	SA	SA	SA	SA	SA	SA	SA	SA	None	PE	SA	PE	PE	None	PE	PE	SA	None	SY	SA	SA	None	PE	None	SA	None	None	SA	SA	PE	None	None	PE	None	SA	None	None	SA	None	PE	SY	None	SA	None	PE	None	None
late_rptno	000-20041019-13-48	000-182	000-20041101-14-24	000-20041025-15-20	000-20041022-15-15	None	000-20041027-11-06	000-20041021-11-50	000-20041020-13-52	001-20041018-16-01	None	000-189	000-20041018-14-43	000-20041022-15-39	None	None	None	000-20051114-07-54	001-20051117-16-16	None	None	None	None	None	None	179901-01	179901-03	179901-05	179901-02	179901-04	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	179901-06	None	None	None	None	None	None	None	None	None	None	None	None	None	179901-07	None	None	None	None	179901-08	None	None	None	179901-09	None	None	None	179901-11	None	179901-10	None	179901-10	179901-12	None	None	None	179901-14	179901-13	None	179901-15	None	179901-16	179901-17	None	179901-18	None	None	179901-19	None	179901-20	None	179901-22	179901-21
from_date	None	None	None	None	None	2004-10-01 00:00:00	None	None	None	None	2004-10-01 00:00:00	None	None	None	2004-07-01 00:00:00	2004-02-27 00:00:00	2006-03-18 00:00:00	None	None	2005-01-01 00:00:00	2005-10-01 00:00:00	2005-04-01 00:00:00	2005-04-01 00:00:00	2006-01-01 00:00:00	2005-07-01 00:00:00	None	None	None	None	None	2006-07-01 00:00:00	2006-01-01 00:00:00	2006-05-21 00:00:00	2006-10-22 00:00:00	2007-07-01 00:00:00	2008-03-18 00:00:00	2007-01-01 00:00:00	2008-01-01 00:00:00	2008-10-01 00:00:00	2008-05-18 00:00:00	2008-07-01 00:00:00	2009-01-01 00:00:00	2010-03-18 00:00:00	2009-07-01 00:00:00	2010-01-01 00:00:00	2010-05-23 00:00:00	2010-07-01 00:00:00	2010-10-01 00:00:00	2010-10-17 00:00:00	2012-03-18 00:00:00	2012-01-01 00:00:00	2011-01-01 00:00:00	2011-07-01 00:00:00	2012-05-20 00:00:00	None	2012-10-01 00:00:00	2012-07-01 00:00:00	2014-01-01 00:00:00	2013-07-01 00:00:00	2013-01-01 00:00:00	2014-03-18 00:00:00	2014-07-01 00:00:00	2015-01-01 00:00:00	2015-07-01 00:00:00	2016-01-01 00:00:00	2017-01-01 00:00:00	2016-07-01 00:00:00	2017-07-01 00:00:00	None	2018-01-01 00:00:00	2018-05-20 00:00:00	2018-07-01 00:00:00	2018-09-23 00:00:00	None	2018-07-01 00:00:00	2018-09-23 00:00:00	2018-10-21 00:00:00	None	2019-01-01 00:00:00	2019-04-01 00:00:00	2018-10-21 00:00:00	None	2020-01-01 00:00:00	None	2019-07-01 00:00:00	None	None	2020-02-16 00:00:00	2020-10-18 00:00:00	2020-09-20 00:00:00	None	None	2020-07-01 00:00:00	None	2021-01-01 00:00:00	None	None	2021-10-01 00:00:00	None	2022-01-01 00:00:00	2021-07-01 00:00:00	None	2022-04-24 00:00:00	None	2022-07-01 00:00:00	None	None
thru_date	None	None	None	None	None	2004-12-31 00:00:00	None	None	None	None	2004-10-16 00:00:00	None	None	None	2004-09-30 00:00:00	2004-06-30 00:00:00	2006-05-20 00:00:00	None	None	2005-03-31 00:00:00	2005-12-31 00:00:00	2005-06-30 00:00:00	2005-06-30 00:00:00	2006-03-17 00:00:00	2005-09-30 00:00:00	None	None	None	None	None	2006-10-21 00:00:00	2006-03-17 00:00:00	2006-06-30 00:00:00	2006-12-31 00:00:00	2007-12-31 00:00:00	2008-05-17 00:00:00	2007-06-30 00:00:00	2008-03-17 00:00:00	2008-12-31 00:00:00	2008-06-30 00:00:00	2008-09-30 00:00:00	2009-06-30 00:00:00	2010-05-22 00:00:00	2009-12-31 00:00:00	2010-03-17 00:00:00	2010-06-30 00:00:00	2010-09-30 00:00:00	2010-10-16 00:00:00	2010-12-31 00:00:00	2012-05-19 00:00:00	2012-03-17 00:00:00	2011-06-30 00:00:00	2011-12-31 00:00:00	2012-06-30 00:00:00	None	2012-12-31 00:00:00	2012-09-30 00:00:00	2014-03-17 00:00:00	2013-12-31 00:00:00	2013-06-30 00:00:00	2014-06-30 00:00:00	2014-12-31 00:00:00	2015-06-30 00:00:00	2015-12-31 00:00:00	2016-06-30 00:00:00	2017-06-30 00:00:00	2016-12-31 00:00:00	2017-12-31 00:00:00	None	2018-05-19 00:00:00	2018-06-30 00:00:00	2018-09-22 00:00:00	2018-10-20 00:00:00	None	2018-09-22 00:00:00	2018-10-20 00:00:00	2018-12-31 00:00:00	None	2019-03-31 00:00:00	2019-06-30 00:00:00	2018-12-31 00:00:00	None	2020-02-15 00:00:00	None	2019-12-31 00:00:00	None	None	2020-06-30 00:00:00	2020-12-31 00:00:00	2020-10-17 00:00:00	None	None	2020-09-19 00:00:00	None	2021-06-30 00:00:00	None	None	2021-12-31 00:00:00	None	2022-04-23 00:00:00	2021-09-30 00:00:00	None	2022-06-30 00:00:00	None	2022-10-22 00:00:00	None	None
elect_date	2004-11-02 00:00:00	None	2004-11-02 00:00:00	2004-11-02 00:00:00	2004-11-02 00:00:00	2006-03-07 00:00:00	2004-11-02 00:00:00	2004-11-02 00:00:00	2004-11-02 00:00:00	2004-11-02 00:00:00	2004-11-02 00:00:00	None	2004-11-02 00:00:00	2004-11-02 00:00:00	2004-11-02 00:00:00	2004-11-02 00:00:00	None	2006-03-07 00:00:00	2005-11-08 00:00:00	2006-03-07 00:00:00	2006-03-07 00:00:00	2006-03-07 00:00:00	2006-03-07 00:00:00	None	2006-03-07 00:00:00	None	None	None	None	None	None	None	None	None	None	2008-06-03 00:00:00	None	2008-06-03 00:00:00	None	None	2008-11-04 00:00:00	None	2010-06-08 00:00:00	None	2010-06-08 00:00:00	None	2010-11-02 00:00:00	2010-11-02 00:00:00	None	2012-06-05 00:00:00	2012-06-05 00:00:00	None	None	None	None	None	2012-11-06 00:00:00	2014-06-03 00:00:00	None	None	None	None	None	None	None	None	None	None	None	2018-06-05 00:00:00	None	2018-11-06 00:00:00	2018-11-06 00:00:00	None	2018-11-06 00:00:00	2018-11-06 00:00:00	None	None	None	None	None	None	2020-03-03 00:00:00	None	None	None	None	None	None	2020-11-03 00:00:00	None	None	2020-11-03 00:00:00	None	None	None	None	None	2020-11-03 00:00:00	2022-06-07 00:00:00	None	2022-06-07 00:00:00	None	2022-06-07 00:00:00	2022-11-08 00:00:00	2022-11-08 00:00:00	2022-11-08 00:00:00
filer_city	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Sacramento	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Sacramento	Fresno	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
filer_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	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
filer_zip4	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	95814	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	95814	93726-0517	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
filer_phon	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	916-442-7757	None	None	None	None	None	None	916-442-7757	None	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	(916) 442-7757	916-442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757
filer_fax	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	916-442-7759	None	None	None	None	None	None	916-442-7759	None	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	(916) 442-7759	916-442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759
file_email	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]
mail_city	Fresno	Fresno	Fresno	Fresno	Fresno	None	Fresno	Fresno	Fresno	Fresno	None	Fresno	Fresno	Fresno	None	None	Sacramento	Fresno	Fresno	None	Fresno	None	None	Sacramento	Fresno	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	CA	CA	CA	CA	CA	None	CA	CA	CA	CA	None	CA	CA	CA	None	None	CA	CA	CA	None	CA	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	None	93726-0517	93726-0517	93726-0517	93726-0517	None	93726-0517	93726-0517	93726-0517	None	None	95814	93726-0517	93726-0517	None	93726-0517	None	None	95814	93726-0517	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_naml	Downing	Downing	Downing	Downing	Downing	Downing	Downing	Downing	Downing	Downing	Downing	Downing	Downing	Downing	Downing	Downing	Hiltachk	Downing	Downing	Downing	Downing	Downing	Downing	Hiltachk	Downing	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	None	Hiltachk	Hiltachk	None	Hiltachk	None	Hiltachk	None	None
tres_namf	Cynthia	Cynthia	Cynthia	Cynthia	Cynthia	Cynthia	Cynthia	Cynthia	Cynthia	Cynthia	Cynthia	Cynthia	Cynthia	Cynthia	Cynthia	Cynthia	Thomas W.	Cynthia	Cynthia	Cynthia	Cynthia	Cynthia	Cynthia	Thomas W.	Cynthia	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	None	Thomas W.	Thomas W.	None	Thomas W.	None	Thomas W.	None	None
tres_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_city	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Sacramento	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Sacramento	Fresno	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	None	Sacramento	Sacramento	None	Sacramento	None	Sacramento	None	None
tres_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	None	CA	CA	None	CA	None	CA	None	None
tres_zip4	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	95814	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	93726-0517	95814	93726-0517	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	None	95814	95814	None	95814	None	95814	None	None
tres_phon	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	916-442-7757	None	None	None	None	None	None	916-442-7757	None	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	(916) 442-7757	916-442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757	None	(916) 442-7757	(916) 442-7757	None	(916) 442-7757	None	(916) 442-7757	None	None
tres_fax	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_email	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cmtte_type	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	None	None	None	None	None	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	None	G	G	G	G	G	G	G	G	G	G	G	G	G	None	G	G	G	G	None	G	G	G	None	G	G	G	None	G	None	G	None	None	G	G	G	None	None	G	None	G	None	None	G	None	G	G	None	G	None	G	None	None
control_yn	N	N	N	N	N	Y	N	N	N	N	Y	N	N	N	Y	Y	Y	N	N	Y	Y	Y	Y	Y	Y	None	None	None	None	None	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	None	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	None	Y	Y	Y	Y	None	Y	Y	Y	None	Y	Y	Y	None	Y	None	Y	None	None	Y	Y	Y	None	None	Y	None	Y	None	None	Y	None	Y	Y	None	Y	None	Y	None	None
sponsor_yn	Y	Y	Y	Y	Y	N	Y	Y	Y	Y	N	Y	Y	Y	N	N	N	Y	Y	N	N	N	N	N	N	None	None	None	None	None	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	None	N	N	N	N	N	N	N	N	N	N	N	N	N	None	N	N	N	N	None	N	N	N	None	N	N	N	None	N	None	N	None	None	N	N	N	None	None	N	None	N	None	None	N	None	N	N	None	N	None	N	None	None
primfrm_yn	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	None	None	None	None	None	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	None	N	N	N	N	N	N	N	N	N	N	N	N	N	None	N	N	N	N	None	N	N	N	None	N	N	N	None	N	None	N	None	None	N	N	N	None	None	N	None	N	None	None	N	None	N	N	None	N	None	N	None	None
brdbase_yn	N	N	N	N	N	None	N	N	N	N	None	N	N	N	None	None	None	N	N	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
amendexp_1	None	None	None	None	None	None	None	None	None	The system pulled in a contribution made as a contribution received.	None	None	None	None	None	None	None	None	Prior report 000-20051114-07-54 did not include contributions made.	None	None	None	Committees missing from original Schedule D report	None	None	None	None	None	None	None	None	Amend to add Expense Codes on Schedule E, omitted in error.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Adjustment to Schedule A and summary page.	Adjustment to summary page.	None	None	None	None	Adjustment to Schedule A and summary page.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
amendexp_2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
amendexp_3	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rpt_att_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cmtte_id	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
reportname	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rptfromdt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rptthrudt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
emplbus_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_inter	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
busact_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
busactvity	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
assoc_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
assoc_int	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
other_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
other_int	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_naml	None	California Republican Party	None	None	None	None	None	None	None	None	None	California Republican Party	None	None	None	None	None	None	None	N/A	N/A	N/A	N/A	None	N/A	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	N/A	N/A	N/A	N/A	None	N/A	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	N/A	N/A	N/A	N/A	None	N/A	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	CA	CA	CA	CA	None	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	00000	00000	00000	00000	None	00000	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_phon	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_fax	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_email	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bal_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bal_num	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bal_juris	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
office_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
offic_dscr	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
juris_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
juris_dscr	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
dist_no	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
off_s_h_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sup_opp_cd	None	S	None	None	None	None	None	None	None	None	None	S	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
employer	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
occupation	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
selfemp_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bal_id	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_id	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: cvr_so
filing_id	1385952	1385952	1385952	1385952	1385952	1385952	1385952	1385952	1385952
amend_id	0	1	2	3	4	5	6	7	8
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F410	F410	F410	F410	F410	F410	F410	F410	F410
filer_id	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100
entity_cd	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP
filer_naml	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (CALPASC PAC)	California Professional Association of Specialty Contractors PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)	Housing Contractors of California PAC (Trades-PAC)
filer_namf	None	None	None	None	None	None	None	None	None
filer_namt	None	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None	None
report_num	000	001	002	003	004	005	006	007	008
rpt_date	2008-12-29 00:00:00	2008-12-29 00:00:00	2011-03-03 00:00:00	2012-12-17 00:00:00	2014-04-08 00:00:00	2019-01-28 00:00:00	2021-01-04 00:00:00	2021-12-09 00:00:00	2022-07-28 00:00:00
qual_cb	None	None	None	None	X	X	X	X	X
qualfy_dt	2004-02-24 00:00:00	2004-02-24 00:00:00	2004-02-24 00:00:00	2004-02-24 00:00:00	2004-02-24 00:00:00	2004-02-24 00:00:00	2004-02-24 00:00:00	2004-02-24 00:00:00	2004-02-24 00:00:00
term_date	None	None	None	None	None	None	None	None	None
city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
st	CA	CA	CA	CA	CA	CA	CA	CA	CA
zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814
phone	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757
county_res	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
county_act	None	None	None	None	Statewide	Statewide	Statewide	Statewide	Statewide
mail_city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	None	None	None	None
mail_st	CA	CA	CA	CA	CA	None	None	None	None
mail_zip4	95814	95814	95814	95814	95814	None	None	None	None
cmte_fax	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	916-442-7759	(916) 442-7759	(916) 442-7759	(916) 442-7759
cmte_email	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]
tres_naml	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk	Hiltachk
tres_namf	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.	Thomas W.
tres_namt	None	None	None	None	None	None	None	None	None
tres_nams	None	None	None	None	None	None	None	None	None
tres_city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
tres_st	CA	CA	CA	CA	CA	CA	CA	CA	CA
tres_zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814
tres_phon	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	916-442-7757	(916) 442-7757	(916) 442-7757	(916) 442-7757
actvty_lvl	ST	ST	ST	ST	ST	ST	ST	ST	ST
com82013yn	None	None	None	None	None	None	None	None	None
com82013nm	None	None	None	None	None	None	None	None	None
com82013id	None	None	None	None	None	None	None	None	None
control_cb	None	None	None	None	None	None	None	None	None
bank_nam	None	None	None	California Bank & Trust	California Bank & Trust	California Bank & Trust	California Bank & Trust	California Bank & Trust	California Bank & Trust
bank_adr1	None	None	None	550 South Hope Street, Suite 100	550 South Hope Street, Suite 100	550 South Hope Street, Suite 100	550 South Hope Street, Suite 100	550 South Hope Street, Suite 100	550 South Hope Street, Suite 100
bank_adr2	None	None	None	None	None	None	None	None	None
bank_city	None	None	None	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles
bank_st	None	None	None	CA	CA	CA	CA	CA	CA
bank_zip4	None	None	None	90071	90071	90071	90071	90071	90071
bank_phon	None	None	None	213-228-1700	213-228-1700	213-228-1700	213-228-1700	213-228-1700	213-228-1700
acct_opendt	None	None	None	None	None	None	None	None	None
surplusdsp	None	None	None	None	None	None	None	None	None
primfc_cb	None	None	None	None	None	None	None	None	None
genpurp_cb	None	None	None	None	None	None	None	None	None
gpc_descr	To support candidates and measures that promote the public welfare and affordable housing by protecting trade contractors, suppliers and related businesses	To support candidates and measures that promote the public welfare and affordable housing by protecting trade contractors, suppliers and related businesses	To support candidates and measures that promote the public welfare and affordable housing by protecting trade contractors, suppliers and related businesses	To support candidates and measures that promote the public welfare and affordable housing by protecting trade contractors, suppliers and related businesses	To support candidates and measures that promote the public welfare and affordable housing by protecting trade contractors, suppliers and related businesses	To support candidates and measures that promote the public welfare and affordable housing by protecting trade contractors, suppliers and related businesses	To support candidates and measures that promote the public welfare and affordable housing by protecting trade contractors, suppliers and related businesses	To support candidates and measures that promote the public welfare and affordable housing by protecting trade contractors, suppliers and related businesses	To support candidates and measures that promote the public welfare and affordable housing by protecting trade contractors, suppliers and related businesses
sponsor_cb	None	None	None	None	None	X	X	X	X
brdbase_cb	None	None	None	None	None	None	None	None	None
smcont_qualdt	None	None	None	None	None	None	None	None	None

Table: filer_acronyms
acronym		CAL PASC PAC		CALPASC
filer_id		1263100		1263100

Table: filer_address
filer_id	1263100	1263100	1263100	1263100	1263100	1263100	1263100
adrid	2063579	2105065	2156748	2156749	2214397	2214396	2315539
effect_dt	2004-02-10 00:00:00	2006-02-08 00:00:00	2004-02-24 00:00:00	2004-02-24 00:00:00	2011-03-08 00:00:00	2011-03-08 00:00:00	2014-04-08 00:00:00
add_type	7051	7051	7051	7082	7082	7051	7051
session_id	2003	2005	2003	2003	2011	2011	2013

Table: filer_filings
filer_id	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100
filing_id	1010576	995634	1003147	1003148	1002897	1002898	1004712	1004729	1024284	1051938	1026707	1048656	1048654	1049758	1045526	1052879	1049088	1050477	1046963	1048654	1051895	1044212	1048652	1053359	1053524	1069425	1055014	1069970	1059197	1071457	1057911	1117233	1117233	1104069	1120888	1130490	1137139	1106442	1135310	1137139	1109924	1143699	1150900	1156779	1158737	1175414	1175421	1173779	1184305	1190730	1158737	1193974	1177421	1210766	1213713	1223234	1156779	1211578	1212022	1214664	1257462	1235013	1239473	1268943	1257500	1272740	1271497	1283831	1286061	1267800	1786058	1981099	1870824	1781731	1945033	1933345	1320093	1319813	1312604	1349516	1309750	1334584	1363230	1352304	1335262	1362560	1385952	1385952	1388183	1394518	1440191	1436697	1398989	1463782	1467887	1475028	1490906	1506044	1473991	1511087	1523791	1494961	1522056	1530904	1532419	1570338	1573146	1585385	1385952	1606944	1606212	1634626	1646855	1647154	1638549	1664501	1678511	1663310	1831741	1824402	1833326	1694234	1697431	1681335	1385952	1874908	1731567	1733259	1738044	1842421	1385952	1815887	1746828	2297775	2296573	2217426	2278004	2210208	2325764	2550155	2551531	2306650	2274891	2396301	2379182	2440930	2324233	2454887	2454906	2014349	2010437	1987723	2061616	2077758	2128629	2146234	2173755	2174417	2249519	2377719	2253695	2348770	2357292	2436185	2498878	2458176	2359772	2312289	2521890	2533866	2520644	2562282	2526715	2505012	2393422	2296573	1385952	2348770	2534254	2253180	2485278	2312289	2378648	2378664	2378682	2441895	2488435	1385952	2648901	2601010	2655130	2446041	2512497	2665924	1385952	2704106	2672553	2706371	2630924	2626658	2680303	1385952	2687781	2616940	2641369	2657000	2622462	2742431	2750803	2733414	2747847	2726891
period_id	None	None	None	None	None	None	None	None	177	180	None	180	180	180	180	None	180	180	None	180	180	179	180	None	180	None	180	180	180	None	None	182	182	181	None	183	184	None	None	184	None	184	None	185	None	None	186	185	None	186	None	None	186	188	188	None	185	188	187	None	None	188	None	None	None	None	None	189	None	None	None	221	217	213	None	219	None	193	None	194	191	193	None	None	None	195	196	196	None	196	None	197	None	199	None	None	201	202	201	None	None	None	203	204	None	204	None	None	205	None	205	207	209	None	None	None	210	209	217	None	None	211	None	None	212	None	None	213	212	None	218	215	None	None	235	None	None	231	None	244	None	236	234	None	None	239	236	241	241	None	223	None	225	None	227	None	229	None	234	237	None	236	None	241	243	None	None	235	244	None	243	None	244	243	238	235	245	236	None	233	241	235	None	None	None	241	None	237	249	245	249	None	244	250	251	250	249	None	None	None	None	248	250	None	248	None	247	251	252	252	252	None
form_id	F410	F410	F497	F497	F496	F496	F410	F497	F460	F497	F460	F496	F497	F497	F496	F497	F497	F497	F460	F497	F497	F460	F460	F460	F497	F410	F497	F460	F497	F460	F497	F460	F460	F460	F460	F460	F497	F460	F460	F497	F460	F460	F460	F460	F460	F460	F497	F460	F410	F460	F460	F460	F497	F497	F497	F666	F460	F497	F460	F460	F497	F460	F460	F497	F497	F497	F497	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F410	F410	F410	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F410	F410	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F410	F460	F410	F497	F460	F410	F410	F460	F460	F460	F460	F460	F460	F460	F460	F460	F410	F497	F460	F460	F460	F460	F497	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F410	F497	F497	F460	F460	F460	F497	F460	F460	F460	F497	F460	F460	F460	F410	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F410	F497	F460	F497	F460	F497	F497	F410	F460	F460	F410	F410	F460	F460	F410	F497	F460	F460	F460	F460	F460	F497	F497	F497	F460
filing_sequence	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	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	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	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	0	0	0	4	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	1	0	0	0	0	0	0	0	1	6	0	0	0	0	0	0	0	0	0	0	5	0	0	0	0	0	0	8	0	0	0	0	0	0	7	0	0	0	0	0	0	0	0	0	0
filing_date	2004-03-10 00:00:00	2004-02-10 00:00:00	2004-02-24 00:00:00	2004-02-24 00:00:00	2004-02-24 00:00:00	2004-02-24 00:00:00	2004-02-27 00:00:00	2004-02-27 00:00:00	2004-07-21 00:00:00	2004-10-22 00:00:00	2004-07-27 00:00:00	2004-10-18 00:00:00	2004-10-18 00:00:00	2004-10-20 00:00:00	2004-10-06 00:00:00	2004-10-21 00:00:00	2004-10-19 00:00:00	2004-10-21 00:00:00	2004-10-04 00:00:00	2004-10-18 00:00:00	2004-10-22 00:00:00	2004-10-04 00:00:00	2004-10-18 00:00:00	2004-10-21 00:00:00	2004-10-25 00:00:00	2004-12-27 00:00:00	2004-10-27 00:00:00	2005-01-04 00:00:00	2004-11-01 00:00:00	2005-01-10 00:00:00	2004-10-25 00:00:00	2005-08-02 00:00:00	2005-07-29 00:00:00	2005-04-29 00:00:00	2005-08-03 00:00:00	2005-10-25 00:00:00	2005-11-17 00:00:00	2005-04-29 00:00:00	2005-10-31 00:00:00	2005-11-14 00:00:00	2005-05-16 00:00:00	2006-01-24 00:00:00	2006-01-31 00:00:00	2006-03-21 00:00:00	2006-03-22 00:00:00	2006-05-25 00:00:00	2006-05-26 00:00:00	2006-05-25 00:00:00	2006-02-08 00:00:00	2006-07-31 00:00:00	2006-07-31 00:00:00	2006-07-31 00:00:00	2006-05-31 00:00:00	2006-10-24 00:00:00	2006-10-27 00:00:00	2006-12-11 00:00:00	2006-07-31 00:00:00	2006-10-25 00:00:00	2006-10-26 00:00:00	2006-10-26 00:00:00	2004-10-27 00:00:00	2007-01-30 00:00:00	2007-01-31 00:00:00	2006-10-24 00:00:00	2004-03-10 00:00:00	2006-05-31 00:00:00	2006-10-25 00:00:00	2007-07-31 00:00:00	2007-07-31 00:00:00	2006-10-27 00:00:00	2013-07-31 00:00:00	2015-07-30 00:00:00	2014-07-31 00:00:00	2013-07-31 00:00:00	2015-01-30 00:00:00	2015-01-30 00:00:00	2008-03-24 00:00:00	2008-03-24 00:00:00	2008-01-31 00:00:00	2008-07-30 00:00:00	2008-01-30 00:00:00	2008-05-22 00:00:00	2008-10-06 00:00:00	2008-07-31 00:00:00	2008-05-22 00:00:00	2008-10-06 00:00:00	2008-12-29 00:00:00	2008-12-29 00:00:00	2008-12-29 00:00:00	2009-01-29 00:00:00	2009-07-31 00:00:00	2009-07-30 00:00:00	2009-02-02 00:00:00	2010-01-30 00:00:00	2010-02-01 00:00:00	2010-03-22 00:00:00	2010-05-27 00:00:00	2010-07-30 00:00:00	2010-03-22 00:00:00	2010-07-30 00:00:00	2010-10-05 00:00:00	2010-05-27 00:00:00	2010-10-05 00:00:00	2010-10-21 00:00:00	2010-10-21 00:00:00	2011-01-31 00:00:00	2011-01-31 00:00:00	2011-03-08 00:00:00	2011-03-08 00:00:00	2011-07-29 00:00:00	2011-07-29 00:00:00	2012-01-30 00:00:00	2012-03-22 00:00:00	2012-03-22 00:00:00	2012-01-31 00:00:00	2012-05-24 00:00:00	2012-07-31 00:00:00	2012-05-24 00:00:00	2014-03-24 00:00:00	2014-01-31 00:00:00	2014-03-24 00:00:00	2012-10-05 00:00:00	2012-10-05 00:00:00	2012-07-31 00:00:00	2012-12-18 00:00:00	2014-07-31 00:00:00	2012-12-18 00:00:00	2013-01-28 00:00:00	2013-01-31 00:00:00	2014-04-08 00:00:00	2014-04-08 00:00:00	2014-01-30 00:00:00	2013-01-31 00:00:00	2018-09-27 00:00:00	2018-09-27 00:00:00	2018-01-31 00:00:00	2018-07-31 00:00:00	2018-01-31 00:00:00	2018-10-25 00:00:00	2021-01-29 00:00:00	2021-01-06 00:00:00	2018-10-15 00:00:00	2018-07-31 00:00:00	2019-07-26 00:00:00	2019-04-26 00:00:00	2020-01-30 00:00:00	2018-11-05 00:00:00	2020-02-20 00:00:00	2020-02-20 00:00:00	2016-01-29 00:00:00	2016-01-29 00:00:00	2015-07-31 00:00:00	2016-07-29 00:00:00	2016-07-29 00:00:00	2017-01-31 00:00:00	2017-01-31 00:00:00	2017-07-28 00:00:00	2017-07-28 00:00:00	2018-05-15 00:00:00	2019-04-26 00:00:00	2018-05-24 00:00:00	2019-04-26 00:00:00	2019-01-31 00:00:00	2020-01-27 00:00:00	2020-09-04 00:00:00	2020-02-20 00:00:00	2019-01-31 00:00:00	2019-04-26 00:00:00	2020-10-23 00:00:00	2020-09-24 00:00:00	2020-10-22 00:00:00	2021-01-29 00:00:00	2020-10-29 00:00:00	2020-09-24 00:00:00	2019-07-26 00:00:00	2019-04-26 00:00:00	2021-01-04 00:00:00	2019-01-31 00:00:00	2020-10-22 00:00:00	2018-05-24 00:00:00	2020-07-31 00:00:00	2018-10-25 00:00:00	2019-04-26 00:00:00	2019-04-26 00:00:00	2019-04-26 00:00:00	2020-01-31 00:00:00	2020-07-31 00:00:00	2019-01-31 00:00:00	2022-02-10 00:00:00	2021-07-30 00:00:00	2022-03-04 00:00:00	2020-01-30 00:00:00	2020-10-09 00:00:00	2022-04-13 00:00:00	2022-07-29 00:00:00	2022-07-29 00:00:00	2022-04-28 00:00:00	2022-07-29 00:00:00	2021-12-13 00:00:00	2021-10-29 00:00:00	2022-04-28 00:00:00	2021-12-09 00:00:00	2022-05-27 00:00:00	2021-07-30 00:00:00	2022-01-28 00:00:00	2022-01-28 00:00:00	2021-10-29 00:00:00	2022-10-27 00:00:00	2022-11-02 00:00:00	2022-10-14 00:00:00	2022-10-31 00:00:00	2022-07-29 00:00:00
stmnt_type	10002	10005	10005	10005	10005	10005	10002	10005	10001	10001	10005	10001	10002	10001	10001	10005	10001	10001	10005	10001	10001	10001	10001	10005	10001	10002	10001	10001	10001	10005	10005	10002	10001	10001	10005	10001	10002	10005	10005	10001	10006	10001	10005	10001	10005	10005	10001	10001	10006	10001	10006	10005	10001	10001	10001	10005	10002	10001	10001	10005	10005	10001	10005	10005	10005	10005	10005	10001	10005	10005	10005	10001	10001	10001	10005	10001	10005	10001	10005	10001	10001	10001	10005	10005	10005	10001	10001	10002	10006	10001	10005	10001	10005	10001	10005	10005	10001	10001	10001	10005	10005	10005	10001	10001	10005	10001	10005	10006	10002	10005	10001	10001	10001	10005	10005	10005	10001	10001	10001	10005	10005	10001	10005	10005	10002	10005	10006	10001	10001	10006	10002	10001	10005	10005	10001	10005	10005	10001	10005	10001	10006	10001	10001	10005	10005	10001	10001	10001	10001	10005	10001	10005	10001	10005	10001	10005	10001	10005	10001	10001	10005	10002	10006	10001	10001	10005	10005	10002	10001	10005	10001	10005	10001	10001	10001	10002	10002	10001	10005	10001	10001	10001	10006	10006	10006	10001	10005	10002	10001	10001	10001	10005	10001	10001	10002	10001	10001	10006	10006	10005	10005	10002	10001	10005	10001	10005	10001	10001	10001	10001	10001	10005
stmnt_status	11001	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11001	11001	11001	11003	11003	11003	11001	11003	11003	11003	11003	11001	11003	11001	11001	11001	11001	11003	11003	11001	11003	11001	11001	11003	11003	11001	11003	11003	11001	11001	11001	11001	11003	11003	11001	11003	11001	11003	11003	11003	11001	11003	11001	11001	11003	11001	11001	11001	11001	11003	11001	11003	11003	11001	11003	11001	11003	11003	11003	11003	11003	11001	11003	11003	11003	11001	11003	11001	11001	11003	11001	11001	11001	11001	11001	11003	11001	11003	11001	11003	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11003	11001	11001	11003	11001	11001	11003	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11003	11001	11003	11003	11001	11001	11003	11003	11001	11001	11001	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11001	11001	11003	11001	11003	11001	11003	11003	11001	11003	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11003	11003	11003	11003	11003
session_id	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2005	2003	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2003	2005	2005	2005	2003	2005	2005	2007	2007	2005	2013	2015	2013	2013	2013	2013	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2013	2013	2013	2011	2011	2011	2011	2013	2011	2013	2011	2013	2013	2013	2011	2017	2017	2017	2017	2017	2017	2019	2021	2017	2017	2019	2019	2019	2017	2019	2019	2015	2015	2015	2015	2015	2015	2015	2017	2017	2017	2019	2017	2017	2019	2019	2019	2019	2017	2017	2019	2019	2019	2019	2019	2019	2019	2017	2021	2017	2019	2017	2019	2017	2017	2017	2017	2019	2019	2019	2021	2021	2021	2019	2019	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021
user_id	TTHAM	TTHAM	GPEREZ	GPEREZ	GPEREZ	GPEREZ	TTHAM	GPEREZ	COMPLETED	COMPLETED	SARRIAGA	COMPLETED	COMPLETED	COMPLETED	COMPLETED	LLEONG	COMPLETED	COMPLETED	GPEREZ	COMPLETED	COMPLETED	COMPLETED	COMPLETED	CFLAGG	GKURIMOT	TTHAM	COMPLETED	COMPLETED	COMPLETED	GPEREZ	GPEREZ	*	*	*	GPEREZ	*	DJOHNSON	GPEREZ	CFLAGG	DJOHNSON	KLARRY	*	CFLAGG	*	CFLAGG	GPEREZ	*	*	TTHAM	*	KVANG	CFLAGG	DHORRELL	DHORRELL	DHORRELL	PROBERTS	*	DHORRELL	*	CFLAGG	LHOANG	*	LHOANG	DHORRELL	LHOANG	DHORRELL	DHORRELL	*	CFLAGG	CFLAGG	CPON	SARRIAGA	CAFILER	CPON	GCLARA	CAFILER	SARRIAGA	*	SARRIAGA	*	*	*	RGEREMIA	RGEREMIA	TMILLER	*	*	*	EMCENTEE	*	MMORENO	MMORENO	JVAZQUEZ	MMORENO	MMORENO	SARRIAGA	CPON	CPON	*	CPON	MPACHECO	CPON	*	SMCCONNAN	SMCCONNAN	CPON	CPON	RGEREMIA	*	MMORENO	MMORENO	MDIGRAZIA	CPON	CPON	MDIGRAZIA	MDIGRAZIA	CPON	MDIGRAZIA	SARRIAGA	GGILMORE	SARRIAGA	CAFILER	MPACHECO	CPON	TRAMON	MPACHECO	TRAMON	WBROWN	CAFILER	TRAMON	TRAMON	CAFILER	MPACHECO	LBARTHOL	LBARTHOL	HSTOVALL	LBARTHOL	HSTOVALL	CSAGABAEN	SARRIAGA	JINCE	CAFILER	LBARTHOL	YMORA	YMORA	LFEDOROV	CAFILER	CAFILER	LFEDOROV	SARRIAGA	SARRIAGA	SARRIAGA	CPON	CPON	CPON	AXIONG	LBARTHOL	LBARTHOL	CAFILER	CAFILER	LBARTHOL	CAFILER	JFRONEFIELD	CAFILER	CAFILER	LFEDOROV	LPHEAV	CAFILER	CAFILER	KRUSSELL	KRUSSELL	SARRIAGA	CAFILER	KRUSSELL	YMORA	CAFILER	IMEDINA	LPHEAV	KRUSSELL	LBARTHOL	KRUSSELL	CSAGABAEN	JFONSECA	JFONSECA	JFONSECA	CAFILER	KRUSSELL	JFRONEFIELD	CAFILER	DCODY	CAFILER	LFEDOROV	CAFILER	CAFILER	IMEDINA	CAFILER	KRUSSELL	IMEDINA	IMEDINA	KRUSSELL	KRUSSELL	IMEDINA	CAFILER	DCODY	KRUSSELL	KRUSSELL	KRUSSELL	CAFILER	CAFILER	CAFILER	CAFILER	JMAVES
special_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11001	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11001	11001	11001	11003	11003	11001	11003	11003	11003	11003	11003	11001	11003	11001	11001	11003	11003	11001	11001	11003	11003	11001	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11001	11003	11003	11003	11001	11003	11001	11001	11003	11001	11001	11003	11001	11001	11003	11001	11003	11001	11003	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11001	11003	11003	11003	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	11001	11001	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	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
rpt_start	None	None	None	None	None	None	None	None	2004-02-27 00:00:00	2004-10-22 00:00:00	2004-02-27 00:00:00	2004-10-18 00:00:00	2004-10-18 00:00:00	2004-10-20 00:00:00	2004-10-06 00:00:00	None	2004-10-19 00:00:00	2004-10-21 00:00:00	2004-07-01 00:00:00	2004-10-18 00:00:00	2004-10-22 00:00:00	2004-07-01 00:00:00	2004-10-01 00:00:00	2004-10-01 00:00:00	2004-10-25 00:00:00	None	2004-10-27 00:00:00	2004-10-01 00:00:00	2004-11-01 00:00:00	2004-10-01 00:00:00	None	2005-04-01 00:00:00	2005-04-01 00:00:00	2005-01-01 00:00:00	2005-04-01 00:00:00	2005-07-01 00:00:00	2005-11-17 00:00:00	2005-01-01 00:00:00	2005-07-01 00:00:00	2005-11-14 00:00:00	2004-01-01 00:00:00	2005-10-01 00:00:00	2005-10-01 00:00:00	2006-01-01 00:00:00	2006-01-01 00:00:00	2006-03-18 00:00:00	2006-05-26 00:00:00	2006-03-18 00:00:00	None	2006-05-21 00:00:00	2006-01-01 00:00:00	2006-05-21 00:00:00	2006-05-31 00:00:00	2006-10-24 00:00:00	2006-10-27 00:00:00	2004-01-01 00:00:00	2006-01-01 00:00:00	2006-10-25 00:00:00	2006-07-01 00:00:00	2006-07-01 00:00:00	None	2006-10-22 00:00:00	2006-10-22 00:00:00	None	None	None	None	2007-01-01 00:00:00	2007-01-01 00:00:00	None	2013-01-01 00:00:00	2015-01-01 00:00:00	2014-03-18 00:00:00	2013-01-01 00:00:00	2014-07-01 00:00:00	2014-07-01 00:00:00	2008-01-01 00:00:00	2008-01-01 00:00:00	2007-07-01 00:00:00	2008-05-18 00:00:00	2007-07-01 00:00:00	2008-03-18 00:00:00	2008-07-01 00:00:00	2008-05-18 00:00:00	2008-03-18 00:00:00	2008-07-01 00:00:00	2008-12-29 00:00:00	2008-12-29 00:00:00	None	2008-10-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2008-10-01 00:00:00	2009-07-01 00:00:00	2009-07-01 00:00:00	2010-01-01 00:00:00	2010-03-18 00:00:00	2010-05-23 00:00:00	2010-01-01 00:00:00	2010-05-23 00:00:00	2010-07-01 00:00:00	2010-03-18 00:00:00	2010-07-01 00:00:00	2010-10-01 00:00:00	2010-10-01 00:00:00	2010-10-17 00:00:00	2010-10-17 00:00:00	None	2011-03-03 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-07-01 00:00:00	2012-01-01 00:00:00	2012-01-01 00:00:00	2011-07-01 00:00:00	2012-03-18 00:00:00	2012-05-20 00:00:00	2012-03-18 00:00:00	2014-01-01 00:00:00	2013-07-01 00:00:00	2014-01-01 00:00:00	2012-07-01 00:00:00	2012-07-01 00:00:00	2012-05-20 00:00:00	2012-12-17 00:00:00	2014-03-18 00:00:00	None	2013-01-28 00:00:00	2012-10-01 00:00:00	None	2014-04-08 00:00:00	2013-07-01 00:00:00	2012-10-01 00:00:00	2018-07-01 00:00:00	2018-07-01 00:00:00	2017-07-01 00:00:00	2018-05-20 00:00:00	2017-07-01 00:00:00	2018-09-23 00:00:00	2020-10-18 00:00:00	None	2018-10-15 00:00:00	2018-05-20 00:00:00	2019-04-01 00:00:00	2019-01-01 00:00:00	2019-07-01 00:00:00	2018-11-05 00:00:00	2020-02-20 00:00:00	2020-01-01 00:00:00	2015-07-01 00:00:00	2015-07-01 00:00:00	2015-01-01 00:00:00	2016-01-01 00:00:00	2016-01-01 00:00:00	2016-07-01 00:00:00	2016-07-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2018-05-15 00:00:00	2019-01-01 00:00:00	2018-01-01 00:00:00	2018-10-21 00:00:00	None	2020-01-27 00:00:00	2020-09-04 00:00:00	2020-01-01 00:00:00	2018-10-21 00:00:00	2018-09-23 00:00:00	2020-10-23 00:00:00	2020-07-01 00:00:00	2020-09-20 00:00:00	2020-10-18 00:00:00	2020-10-29 00:00:00	2020-07-01 00:00:00	2019-04-01 00:00:00	2018-07-01 00:00:00	2021-01-04 00:00:00	2018-10-21 00:00:00	2020-09-20 00:00:00	2018-01-01 00:00:00	2020-02-16 00:00:00	2018-09-23 00:00:00	2018-07-01 00:00:00	2018-09-23 00:00:00	2018-10-21 00:00:00	2020-01-31 00:00:00	2020-02-16 00:00:00	2019-01-28 00:00:00	2022-02-10 00:00:00	2021-01-01 00:00:00	2022-03-04 00:00:00	2019-07-01 00:00:00	2020-10-09 00:00:00	2022-04-13 00:00:00	2022-07-28 00:00:00	2022-04-24 00:00:00	2022-01-01 00:00:00	None	None	2021-07-01 00:00:00	2022-01-01 00:00:00	2021-12-09 00:00:00	2022-05-27 00:00:00	2021-01-01 00:00:00	2021-10-01 00:00:00	2021-10-01 00:00:00	2021-07-01 00:00:00	2022-07-01 00:00:00	2022-11-02 00:00:00	2022-10-14 00:00:00	2022-10-31 00:00:00	2022-04-24 00:00:00
rpt_end	None	None	None	None	None	None	None	None	2004-06-30 00:00:00	2004-10-22 00:00:00	2004-06-30 00:00:00	2004-10-18 00:00:00	2004-10-18 00:00:00	2004-10-20 00:00:00	2004-10-06 00:00:00	None	2004-10-19 00:00:00	2004-10-21 00:00:00	2004-09-30 00:00:00	2004-10-18 00:00:00	2004-10-22 00:00:00	2004-09-30 00:00:00	2004-10-16 00:00:00	2004-10-16 00:00:00	2004-10-25 00:00:00	None	2004-10-27 00:00:00	2004-12-31 00:00:00	2004-11-01 00:00:00	2004-12-31 00:00:00	None	2005-06-30 00:00:00	2005-06-30 00:00:00	2005-03-31 00:00:00	2005-06-30 00:00:00	2005-09-30 00:00:00	2005-11-17 00:00:00	2005-03-31 00:00:00	2005-09-30 00:00:00	2005-11-14 00:00:00	2004-02-26 00:00:00	2005-12-31 00:00:00	2005-12-31 00:00:00	2006-03-17 00:00:00	2006-03-17 00:00:00	2006-05-20 00:00:00	2006-05-26 00:00:00	2006-05-20 00:00:00	None	2006-06-30 00:00:00	2006-03-17 00:00:00	2006-06-30 00:00:00	2006-05-31 00:00:00	2006-10-24 00:00:00	2006-10-27 00:00:00	2004-12-31 00:00:00	2006-03-17 00:00:00	2006-10-25 00:00:00	2006-10-21 00:00:00	2006-10-21 00:00:00	None	2006-12-31 00:00:00	2006-12-31 00:00:00	None	None	None	None	2007-06-30 00:00:00	2007-06-30 00:00:00	None	2013-06-30 00:00:00	2015-06-30 00:00:00	2014-06-30 00:00:00	2013-06-30 00:00:00	2014-12-31 00:00:00	2014-12-31 00:00:00	2008-03-17 00:00:00	2008-03-17 00:00:00	2007-12-31 00:00:00	2008-06-30 00:00:00	2007-12-31 00:00:00	2008-05-17 00:00:00	2008-09-30 00:00:00	2008-06-30 00:00:00	2008-05-17 00:00:00	2008-09-30 00:00:00	2008-12-29 00:00:00	2008-12-29 00:00:00	None	2008-12-31 00:00:00	2009-06-30 00:00:00	2009-06-30 00:00:00	2008-12-31 00:00:00	2009-12-31 00:00:00	2009-12-31 00:00:00	2010-03-17 00:00:00	2010-05-22 00:00:00	2010-06-30 00:00:00	2010-03-17 00:00:00	2010-06-30 00:00:00	2010-09-30 00:00:00	2010-05-22 00:00:00	2010-09-30 00:00:00	2010-10-16 00:00:00	2010-10-16 00:00:00	2010-12-31 00:00:00	2010-12-31 00:00:00	None	2011-03-03 00:00:00	2011-06-30 00:00:00	2011-06-30 00:00:00	2011-12-31 00:00:00	2012-03-17 00:00:00	2012-03-17 00:00:00	2011-12-31 00:00:00	2012-05-19 00:00:00	2012-06-30 00:00:00	2012-05-19 00:00:00	2014-03-17 00:00:00	2013-12-31 00:00:00	2014-03-17 00:00:00	2012-09-30 00:00:00	2012-09-30 00:00:00	2012-06-30 00:00:00	2012-12-17 00:00:00	2014-06-30 00:00:00	None	2013-01-28 00:00:00	2012-12-31 00:00:00	None	2014-04-08 00:00:00	2013-12-31 00:00:00	2012-12-31 00:00:00	2018-09-22 00:00:00	2018-09-22 00:00:00	2017-12-31 00:00:00	2018-06-30 00:00:00	2017-12-31 00:00:00	2018-10-20 00:00:00	2020-12-31 00:00:00	None	2018-10-15 00:00:00	2018-06-30 00:00:00	2019-06-30 00:00:00	2019-03-31 00:00:00	2019-12-31 00:00:00	2018-11-05 00:00:00	2020-02-20 00:00:00	2020-02-15 00:00:00	2015-12-31 00:00:00	2015-12-31 00:00:00	2015-06-30 00:00:00	2016-06-30 00:00:00	2016-06-30 00:00:00	2016-12-31 00:00:00	2016-12-31 00:00:00	2017-06-30 00:00:00	2017-06-30 00:00:00	2018-05-15 00:00:00	2019-03-31 00:00:00	2018-05-19 00:00:00	2018-12-31 00:00:00	None	2020-01-27 00:00:00	2020-09-04 00:00:00	2020-02-15 00:00:00	2018-12-31 00:00:00	2018-10-20 00:00:00	2020-10-23 00:00:00	2020-09-19 00:00:00	2020-10-17 00:00:00	2020-12-31 00:00:00	2020-10-29 00:00:00	2020-09-19 00:00:00	2019-06-30 00:00:00	2018-09-22 00:00:00	2021-01-04 00:00:00	2018-12-31 00:00:00	2020-10-17 00:00:00	2018-05-19 00:00:00	2020-06-30 00:00:00	2018-10-20 00:00:00	2018-09-22 00:00:00	2018-10-20 00:00:00	2018-12-31 00:00:00	2020-01-31 00:00:00	2020-06-30 00:00:00	2019-01-28 00:00:00	2022-02-10 00:00:00	2021-06-30 00:00:00	2022-03-04 00:00:00	2019-12-31 00:00:00	2020-10-09 00:00:00	2022-04-13 00:00:00	2022-07-28 00:00:00	2022-06-30 00:00:00	2022-04-23 00:00:00	None	None	2021-09-30 00:00:00	2022-04-23 00:00:00	2021-12-09 00:00:00	2022-05-27 00:00:00	2021-06-30 00:00:00	2021-12-31 00:00:00	2021-12-31 00:00:00	2021-09-30 00:00:00	2022-10-22 00:00:00	2022-11-02 00:00:00	2022-10-14 00:00:00	2022-10-31 00:00:00	2022-06-30 00:00:00
rpt_date	None	None	None	None	None	None	None	None	2004-06-30 00:00:00	2004-10-22 00:00:00	None	2004-10-18 00:00:00	2004-10-18 00:00:00	2004-10-20 00:00:00	2004-10-06 00:00:00	None	2004-10-19 00:00:00	2004-10-21 00:00:00	None	2004-10-18 00:00:00	2004-10-22 00:00:00	2004-09-30 00:00:00	2004-10-16 00:00:00	None	2004-10-25 00:00:00	None	2004-10-27 00:00:00	2004-12-31 00:00:00	2004-11-01 00:00:00	None	None	2005-08-01 00:00:00	2005-07-29 00:00:00	2005-04-29 00:00:00	None	2005-10-25 00:00:00	2005-11-17 00:00:00	None	None	2005-11-14 00:00:00	None	2006-01-24 00:00:00	None	2006-03-20 00:00:00	None	None	2006-05-26 00:00:00	2006-05-22 00:00:00	None	2006-07-14 00:00:00	None	None	2006-05-31 00:00:00	2006-10-24 00:00:00	2006-10-27 00:00:00	None	2006-07-14 00:00:00	2006-10-25 00:00:00	2006-10-21 00:00:00	None	None	2007-01-15 00:00:00	None	None	None	None	None	2007-07-13 00:00:00	None	None	None	2015-07-31 00:00:00	2014-07-19 00:00:00	2013-07-17 00:00:00	None	2015-01-19 00:00:00	None	2008-03-19 00:00:00	None	2008-07-14 00:00:00	2008-01-18 00:00:00	2008-05-19 00:00:00	None	None	None	2008-10-04 00:00:00	None	None	None	2009-01-15 00:00:00	None	2009-07-12 00:00:00	None	2010-01-16 00:00:00	None	None	2010-05-23 00:00:00	2010-07-13 00:00:00	2010-03-19 00:00:00	None	None	None	2010-10-02 00:00:00	2010-10-16 00:00:00	None	2011-01-12 00:00:00	None	None	None	None	2011-07-12 00:00:00	2012-01-23 00:00:00	2012-03-17 00:00:00	None	None	None	2012-07-23 00:00:00	2012-05-20 00:00:00	2014-03-18 00:00:00	None	None	2012-09-30 00:00:00	None	None	None	None	None	2013-01-28 00:00:00	2013-01-10 00:00:00	None	None	2014-01-21 00:00:00	None	None	2018-09-26 00:00:00	None	None	2018-01-08 00:00:00	None	2021-01-28 00:00:00	None	2018-10-15 00:00:00	2018-07-25 00:00:00	None	None	2020-01-28 00:00:00	2018-11-05 00:00:00	2020-02-20 00:00:00	2020-02-19 00:00:00	None	2016-01-21 00:00:00	None	2016-07-14 00:00:00	None	2017-01-17 00:00:00	None	2017-07-12 00:00:00	None	2018-05-15 00:00:00	2019-04-10 00:00:00	None	2019-04-10 00:00:00	None	2020-01-27 00:00:00	2020-09-04 00:00:00	None	None	2019-04-10 00:00:00	2020-10-23 00:00:00	None	2020-10-21 00:00:00	None	2020-10-29 00:00:00	2020-09-23 00:00:00	2019-07-11 00:00:00	2019-04-10 00:00:00	None	2019-01-31 00:00:00	None	2018-05-22 00:00:00	2020-07-24 00:00:00	2018-10-20 00:00:00	None	None	None	2020-01-31 00:00:00	None	None	2022-02-10 00:00:00	2021-07-27 00:00:00	2022-03-04 00:00:00	None	2020-10-09 00:00:00	2022-04-13 00:00:00	None	2022-07-28 00:00:00	2022-04-27 00:00:00	None	None	None	None	None	2022-05-27 00:00:00	None	2022-01-24 00:00:00	None	2021-10-28 00:00:00	2022-10-27 00:00:00	2022-11-02 00:00:00	2022-10-14 00:00:00	2022-10-31 00:00:00	None
filing_type	None	None	None	None	None	None	None	None	22001	22001	None	22001	22001	22001	22001	None	22001	22001	None	22001	22001	22001	22001	None	22001	None	22001	22001	22001	None	None	22001	22001	22001	None	22001	22001	None	None	22001	None	22001	None	22001	None	None	22001	22001	None	22001	None	None	22001	22001	22001	None	22001	22001	22001	None	None	22001	None	None	None	None	None	22001	None	None	None	22001	22001	22001	None	22001	None	22001	None	22001	22001	22001	None	None	None	22001	22001	22001	None	22001	None	22001	None	22001	None	None	22001	22001	22001	None	None	None	22001	22001	None	22001	None	None	22001	None	22001	22001	22001	None	None	None	22001	22001	22001	None	None	22001	None	None	22001	None	None	22001	22001	None	22001	22001	None	None	22001	None	None	22001	None	22001	None	22001	22001	None	None	22001	22001	22001	22001	None	22001	None	22001	None	22001	None	22001	None	22001	22001	None	22001	None	22001	22001	None	None	22001	22001	None	22001	None	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	None	None	None	22001	None	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	None	None	None	None	22001	22001	None	22001	None	22001	22001	22001	22001	22001	None

Table: filer_to_filer_type
filer_id	1263100	1263100	1263100
filer_type	16	16	16
active	Y	Y	Y
race	0	0	0
session_id	2003	2003	2005
category	0	0	0
category_type	40502	40502	40502
sub_category	40103	40103	40103
effect_dt	2004-02-10 00:00:00	2004-02-27 00:00:00	2006-02-08 00:00:00
sub_category_type	0	0	0
election_type	0	0	0
sub_category_a	S	S	S
nyq_dt	None	2004-02-24 00:00:00	2004-02-24 00:00:00
party_cd	0	0	0
county_cd	18018	18018	18004
district_cd	0	0	0

Table: filer_xref
filer_id		1263100
xref_id		1263100
effect_dt		2004-02-18 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100
filer_id	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100
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	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	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE
effect_dt	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00	2006-02-08 00:00:00
naml	HOUSING CONTRACTORS OF CALIFORNIA PAC (TRADES-PAC)	HOUSING CONTRACTORS OF CALIFORNIA PAC (TRADES-PAC)	HOUSING CONTRACTORS OF CALIFORNIA PAC (TRADES-PAC)	HOUSING CONTRACTORS OF CALIFORNIA PAC (TRADES-PAC)	HOUSING CONTRACTORS OF CALIFORNIA PAC (TRADES-PAC)	HOUSING CONTRACTORS OF CALIFORNIA PAC (TRADES-PAC)	HOUSING CONTRACTORS OF CALIFORNIA PAC (TRADES-PAC)	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS PAC (TRADES-PAC)	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS PAC (TRADES-PAC)	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS PAC (TRADES-PAC)	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS PAC (TRADES-PAC)	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS PAC (TRADES-PAC)	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS PAC (TRADES-PAC)	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS PAC (TRADES-PAC)	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS PAC (CALPASC PAC)	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS PAC (CALPASC PAC)	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS PAC (CALPASC PAC)	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS PAC (CALPASC PAC)	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS PAC (CALPASC PAC)	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS PAC (CALPASC PAC)	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS PAC (CALPASC PAC)	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS POLITICAL ACTION COMMITTEE	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS POLITICAL ACTION COMMITTEE	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS POLITICAL ACTION COMMITTEE	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS POLITICAL ACTION COMMITTEE	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS POLITICAL ACTION COMMITTEE	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS POLITICAL ACTION COMMITTEE	CALIFORNIA PROFESSIONAL ASSOCIATION OF SPECIALTY CONTRACTORS POLITICAL ACTION COMMITTEE	CALPASC POLITICAL ACTION COMMITTEE	CALPASC POLITICAL ACTION COMMITTEE	CALPASC POLITICAL ACTION COMMITTEE	CALPASC POLITICAL ACTION COMMITTEE	CALPASC POLITICAL ACTION COMMITTEE	CALPASC POLITICAL ACTION COMMITTEE	CALPASC POLITICAL ACTION COMMITTEE
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
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
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
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
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
city	FRESNO	SACRAMENTO	Sacramento	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	FRESNO	SACRAMENTO	Sacramento	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	FRESNO	SACRAMENTO	Sacramento	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	FRESNO	SACRAMENTO	Sacramento	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	FRESNO	SACRAMENTO	Sacramento	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO
st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
zip4	93726	95814	95814	95814	95814	95814	95814	93726	95814	95814	95814	95814	95814	95814	93726	95814	95814	95814	95814	95814	95814	93726	95814	95814	95814	95814	95814	95814	93726	95814	95814	95814	95814	95814	95814
phon	8006761510	9164427757	916-442-7757	916-442-7757	9164427757	9164427757	9164427757	8006761510	9164427757	916-442-7757	916-442-7757	9164427757	9164427757	9164427757	8006761510	9164427757	916-442-7757	916-442-7757	9164427757	9164427757	9164427757	8006761510	9164427757	916-442-7757	916-442-7757	9164427757	9164427757	9164427757	8006761510	9164427757	916-442-7757	916-442-7757	9164427757	9164427757	9164427757
fax	5592271463	9164427759	916-442-7759	916-442-7759	9164427759	9164427759	9164427759	5592271463	9164427759	916-442-7759	916-442-7759	9164427759	9164427759	9164427759	5592271463	9164427759	916-442-7759	916-442-7759	9164427759	9164427759	9164427759	5592271463	9164427759	916-442-7759	916-442-7759	9164427759	9164427759	9164427759	5592271463	9164427759	916-442-7759	916-442-7759	9164427759	9164427759	9164427759
email	None	None	None	None	None	None	[email protected]	None	None	None	None	None	None	[email protected]	None	None	None	None	None	None	[email protected]	None	None	None	None	None	None	[email protected]	None	None	None	None	None	None	[email protected]

Table: filers
filer_id		1263100

Table: received_filings
filer_id	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100	1263100
filing_file_name	1048654_0.cal	1049088_0.cal	68983.cal	69131.cal	69332.cal	1055014_0.cal	1051895_0.cal	1050477_0.cal	1059197_0.cal	1049758_0.cal	104389.cal	124055.cal	1137139_0.cal	114964.cal	2436185_0.cal	2306650_0.cal	2324233_0.cal	2249519_0.cal	2454887_0.cal	2498878_0.cal	2441895_0.cal	2648901_0.cal	2665924_0.cal	2521890_0.cal	2750803_0.cal	2747847_0.cal	2655130_0.cal	2687781_0.cal	2512497_0.cal	2733414_0.cal
received_date	2004-10-18 00:00:00	2004-10-19 00:00:00	2004-10-18 00:00:00	2004-10-18 00:00:00	2004-10-18 00:00:00	2004-10-27 00:00:00	2004-10-22 00:00:00	2004-10-21 00:00:00	2004-11-01 00:00:00	2004-10-20 00:00:00	2005-04-28 00:00:00	2005-04-29 00:00:00	2005-11-14 00:00:00	2005-11-14 00:00:00	2020-01-27 00:00:00	2018-10-15 00:00:00	2018-11-05 00:00:00	2018-05-15 00:00:00	2020-02-20 00:00:00	2020-09-04 00:00:00	2020-01-31 00:00:00	2022-02-10 00:00:00	2022-04-13 00:00:00	2020-10-23 00:00:00	2022-11-02 00:00:00	2022-10-31 00:00:00	2022-03-04 00:00:00	2022-05-27 00:00:00	2020-10-09 00:00:00	2022-10-14 00:00:00
filing_directory	/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/temp	/cafiler/disclose/ca99/temp	/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	/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	1048654	1049088	None	None	None	1055014	1051895	1050477	1059197	1049758	None	None	1137139	None	2436185	2306650	2324233	2249519	2454887	2498878	2441895	2648901	2665924	2521890	2750803	2747847	2655130	2687781	2512497	2733414
form_id	F497	F497	None	None	None	F497	F497	F497	F497	F497	None	None	F497	None	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497
receive_comment	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing did not pass validation	Filing did not pass validation	Filing accepted	Filing passed validation, but failed DB constraints	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