OpenCalAccess

Filer ID: 1219570

Table: cvr_campaign_disclosure
filing_id	785272	779949	804741	850035	869991	876355	902402	940874	959166	977988	1070415	1021708	1140879	1172185	1110950	1227360	1182389	1211958	1301973	1275887	1318670	1341934	1389480	1429022	1489362	1456996	1498905	1559897	1528057	1521163	1601200	1662317	1627201	1670998	1724441	1834515	1830496	1810007	1776272	1846948	1884664	1862865	1852473	1891081	1925193	1898110	1901472	1973681	1963575	2031062	2033791	2036235	2039640	2003681	2045144	2044572	2082329	2068391	2054564	2165559	2119642	2201328	2221502	2229336	2252770	2262962	2237551	2286254	2308363	2295291	2284817	2294505	2310880	2363624	2426925	2413167	2372613	2390479	2333908	2480511	2431464	2434460	2454330	2489072	2549108	2504505	2520086	2514268	2519563	2516892	2660836	2591555	2649980	2633475	2662282	2615696	2670032	2685591	2697364	2724893	2713552	2744891	2724893	2733309	2740216
amend_id	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	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
form_type	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	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	F497	F460	F460	F497	F497	F460	F460	F460	F460	F497	F460	F460	F497	F497	F460	F497	F497	F460	F460	F497	F460	F497	F460	F460	F460	F460	F497	F497	F497	F460	F460	F497	F497	F460	F497	F497	F460	F497	F497	F460	F460	F460	F460	F460	F460	F497	F460	F497	F460	F460	F460	F497	F497	F497	F497	F460	F497	F460	F497	F460	F460	F497	F460	F460	F497	F497	F460	F497	F460
filer_id	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570
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	None	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP
filer_naml	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry
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
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
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
report_num	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	000	000
rpt_date	2001-10-02 00:00:00	2001-07-11 00:00:00	2002-01-09 00:00:00	2002-07-10 00:00:00	2002-10-01 00:00:00	2002-10-21 00:00:00	2003-01-13 00:00:00	2003-07-01 00:00:00	2003-09-22 00:00:00	2004-01-02 00:00:00	2005-01-05 00:00:00	2004-07-06 00:00:00	2006-01-04 00:00:00	2006-05-22 00:00:00	2005-07-01 00:00:00	2007-01-08 00:00:00	2006-07-05 00:00:00	2006-10-26 00:00:00	2008-01-02 00:00:00	2007-07-02 00:00:00	2008-03-18 00:00:00	2008-07-01 00:00:00	2009-01-13 00:00:00	2009-07-01 00:00:00	2010-05-24 00:00:00	2010-01-04 00:00:00	2010-07-01 00:00:00	2011-01-03 00:00:00	2010-10-18 00:00:00	2010-10-01 00:00:00	2011-07-14 00:00:00	2012-05-21 00:00:00	2012-01-03 00:00:00	2012-07-11 00:00:00	2013-01-08 00:00:00	2014-03-28 00:00:00	2014-03-19 00:00:00	2014-01-10 00:00:00	2013-07-16 00:00:00	2014-05-02 00:00:00	2014-09-11 00:00:00	2014-07-09 00:00:00	2014-05-19 00:00:00	2014-10-01 00:00:00	2015-01-07 00:00:00	2014-10-14 00:00:00	2014-10-20 00:00:00	2015-07-08 00:00:00	2015-04-28 00:00:00	2016-04-21 00:00:00	2016-04-25 00:00:00	2016-04-29 00:00:00	2016-05-04 00:00:00	2016-01-08 00:00:00	2016-05-23 00:00:00	2016-05-20 00:00:00	2016-09-26 00:00:00	2016-08-15 00:00:00	2016-07-08 00:00:00	2017-07-05 00:00:00	2017-01-12 00:00:00	2018-01-09 00:00:00	2018-03-12 00:00:00	2018-04-09 00:00:00	2018-05-22 00:00:00	2018-07-03 00:00:00	2018-04-26 00:00:00	2018-08-24 00:00:00	2018-10-17 00:00:00	2018-09-24 00:00:00	2018-08-20 00:00:00	2018-09-21 00:00:00	2018-10-22 00:00:00	2019-02-27 00:00:00	2019-12-27 00:00:00	2019-10-01 00:00:00	2019-04-09 00:00:00	2019-07-03 00:00:00	2019-01-10 00:00:00	2020-07-08 00:00:00	2020-01-06 00:00:00	2020-01-23 00:00:00	2020-02-18 00:00:00	2020-08-07 00:00:00	2021-01-18 00:00:00	2020-09-20 00:00:00	2020-10-18 00:00:00	2020-10-13 00:00:00	2020-10-21 00:00:00	2020-10-16 00:00:00	2022-03-28 00:00:00	2021-07-08 00:00:00	2022-02-14 00:00:00	2022-01-04 00:00:00	2022-04-01 00:00:00	2021-10-13 00:00:00	2022-04-22 00:00:00	2022-05-24 00:00:00	2022-07-05 00:00:00	2022-09-28 00:00:00	2022-08-23 00:00:00	2022-10-28 00:00:00	2022-10-24 00:00:00	2022-10-14 00:00:00	2022-10-24 00:00:00
stmt_type	PE	SA	SA	SA	PE	PE	SA	SA	SE	SA	SA	SA	SA	PE	SA	SA	SA	PE	SA	SA	PE	SA	SA	SA	PE	SA	SA	SA	PE	PE	SA	PE	SA	SA	SA	None	None	SA	SA	None	None	SA	PE	PE	SA	None	PE	SA	None	None	PE	None	None	SA	PE	None	PE	None	SA	SA	SA	SA	None	None	None	SA	PE	None	None	PE	None	None	PE	None	None	SY	SY	SA	SA	SA	SA	None	PE	None	SA	PE	PE	None	None	None	None	SA	None	SA	None	SY	PE	None	SA	PE	None	None	PE	None	PE
late_rptno	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	20140328	20140319	None	None	20140502	20140911	None	None	None	None	20141014	None	None	20150428	PE16-1	None	PE16-2	PE16-3	None	None	PE16-4	None	GE16-1	None	None	None	None	SP-18-1	P18-2	P18-3	None	None	G18-2	G18-4	None	G18-1	G18-3	None	s2019-1	p2020-1	None	None	None	None	None	None	p2020-2	None	g2020-1	None	None	None	g2020-2	g2020-4	g2020-3	6/7/22-2	None	2/15/22-1	None	6/7/22-3	None	None	6/7/22-4	None	None	11/8/22-1	11/8/22-3	None	11/8/22-2	None
from_date	2001-07-01 00:00:00	2001-01-01 00:00:00	2001-10-01 00:00:00	2002-01-01 00:00:00	2002-07-01 00:00:00	2002-10-01 00:00:00	2002-10-20 00:00:00	2003-01-01 00:00:00	2003-07-01 00:00:00	2003-10-01 00:00:00	2004-07-01 00:00:00	2004-01-01 00:00:00	2005-07-01 00:00:00	2006-01-01 00:00:00	2005-01-01 00:00:00	2006-10-22 00:00:00	2006-05-21 00:00:00	2006-07-01 00:00:00	2007-07-01 00:00:00	2007-01-01 00:00:00	2008-01-01 00:00:00	2008-03-18 00:00:00	2008-07-01 00:00:00	2009-01-01 00:00:00	2010-01-01 00:00:00	2009-07-01 00:00:00	2010-05-23 00:00:00	2010-10-17 00:00:00	2010-10-01 00:00:00	2010-07-01 00:00:00	2011-01-01 00:00:00	2012-01-01 00:00:00	2011-07-01 00:00:00	2012-05-20 00:00:00	2012-07-01 00:00:00	None	None	2013-07-01 00:00:00	2013-01-01 00:00:00	None	None	2014-05-18 00:00:00	2014-01-01 00:00:00	2014-07-01 00:00:00	2014-10-19 00:00:00	None	2014-10-01 00:00:00	2015-01-01 00:00:00	None	None	2016-01-01 00:00:00	None	None	2015-07-01 00:00:00	2016-04-24 00:00:00	None	2016-07-01 00:00:00	None	2016-05-22 00:00:00	2017-01-01 00:00:00	2016-09-25 00:00:00	2017-07-01 00:00:00	None	None	None	2018-04-22 00:00:00	2018-01-01 00:00:00	None	None	2018-07-01 00:00:00	None	None	2018-09-23 00:00:00	None	None	2019-07-01 00:00:00	2019-01-01 00:00:00	2019-04-01 00:00:00	2018-10-21 00:00:00	2020-02-16 00:00:00	2019-10-01 00:00:00	None	2020-01-01 00:00:00	None	2020-10-18 00:00:00	2020-07-01 00:00:00	2020-09-20 00:00:00	None	None	None	None	2021-01-01 00:00:00	None	2021-10-01 00:00:00	None	2021-07-01 00:00:00	2022-01-01 00:00:00	None	2022-04-24 00:00:00	2022-07-01 00:00:00	None	None	2022-07-01 00:00:00	None	2022-09-25 00:00:00
thru_date	2001-09-30 00:00:00	2001-06-30 00:00:00	2001-12-31 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	2002-10-19 00:00:00	2002-12-31 00:00:00	2003-06-30 00:00:00	2003-09-20 00:00:00	2003-12-31 00:00:00	2004-12-31 00:00:00	2004-06-30 00:00:00	2005-12-31 00:00:00	2006-05-20 00:00:00	2005-06-30 00:00:00	2006-12-31 00:00:00	2006-06-30 00:00:00	2006-10-21 00:00:00	2007-12-31 00:00:00	2007-06-30 00:00:00	2008-03-17 00:00:00	2008-06-30 00:00:00	2008-12-31 00:00:00	2009-06-30 00:00:00	2010-05-22 00:00:00	2009-12-31 00:00:00	2010-06-30 00:00:00	2010-12-31 00:00:00	2010-10-16 00:00:00	2010-09-30 00:00:00	2011-06-30 00:00:00	2012-05-19 00:00:00	2011-12-31 00:00:00	2012-06-30 00:00:00	2012-12-31 00:00:00	None	None	2013-12-31 00:00:00	2013-06-30 00:00:00	None	None	2014-06-30 00:00:00	2014-05-17 00:00:00	2014-09-30 00:00:00	2014-12-31 00:00:00	None	2014-10-18 00:00:00	2015-06-30 00:00:00	None	None	2016-04-23 00:00:00	None	None	2015-12-31 00:00:00	2016-05-21 00:00:00	None	2016-09-24 00:00:00	None	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	None	None	2018-06-30 00:00:00	2018-04-21 00:00:00	None	None	2018-09-22 00:00:00	None	None	2018-10-20 00:00:00	None	None	2019-09-30 00:00:00	2019-03-31 00:00:00	2019-06-30 00:00:00	2018-12-31 00:00:00	2020-06-30 00:00:00	2019-12-31 00:00:00	None	2020-02-15 00:00:00	None	2020-12-31 00:00:00	2020-09-19 00:00:00	2020-10-17 00:00:00	None	None	None	None	2021-06-30 00:00:00	None	2021-12-31 00:00:00	None	2021-09-30 00:00:00	2022-04-23 00:00:00	None	2022-06-30 00:00:00	2022-09-02 00:00:00	None	None	2022-09-24 00:00:00	None	2022-10-22 00:00:00
elect_date	2002-03-05 00:00:00	None	None	None	2002-11-05 00:00:00	2002-11-05 00:00:00	None	None	2003-10-07 00:00:00	None	None	None	None	2006-06-06 00:00:00	None	None	None	2006-11-07 00:00:00	None	None	2008-06-03 00:00:00	None	None	None	2010-06-08 00:00:00	None	None	None	2010-11-02 00:00:00	2010-11-02 00:00:00	None	2012-06-05 00:00:00	None	None	None	None	None	None	None	None	None	None	2014-06-03 00:00:00	2014-11-04 00:00:00	None	None	2014-11-04 00:00:00	None	None	None	2016-06-07 00:00:00	None	None	None	2016-06-07 00:00:00	None	2016-11-08 00:00:00	None	None	None	None	None	None	None	None	None	2018-06-05 00:00:00	None	None	2018-11-06 00:00:00	None	None	2018-11-06 00:00:00	None	None	None	None	None	None	None	None	None	2020-03-03 00:00:00	None	None	2020-11-03 00:00:00	2020-11-03 00:00:00	None	None	None	None	None	None	None	2020-11-03 00:00:00	None	2022-06-07 00:00:00	2022-06-07 00:00:00	None	2022-11-08 00:00:00	2022-06-07 00:00:00	2022-11-08 00:00:00	2022-11-08 00:00:00	2022-11-08 00:00:00	2022-11-08 00:00:00
filer_city	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	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
filer_zip4	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	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	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	916-706-2677	916-706-2677	916-706-2677	916-706-2677	916-706-2677	916-706-2677	916-706-2677	916-706-2677	916-706-2677	916-706-2677	916-706-2677	916-706-2677	916-706-2677	916-706-2677	916-706-2677
filer_fax	None	None	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
file_email	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	344000jh	[email protected] 344000jh	344000jh	[email protected] 344000jh	[email protected] 344000jh	[email protected] 344000jh	[email protected] 344000jh	[email protected] 344000jh	[email protected] 344000jh	[email protected] 344000jh	[email protected] 344000jh	[email protected] 344000jh	[email protected] 344000jh	[email protected] 344000jh	[email protected] 344000jh	[email protected] 344000slm	[email protected] 344000slm	[email protected] 344000slm	[email protected] 344000slm	[email protected] 344000slm	[email protected] 344000slm	[email protected] 344000slm	[email protected] 344000slm	[email protected] 344000slm	[email protected] 344000slm	[email protected] 344000slm	[email protected] 344000slm	[email protected] 344000slm	[email protected] 344000slm	[email protected] 344000slm	[email protected] 344000slm	[email protected] 344000slm	[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	None	None	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	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_st	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	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	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
mail_zip4	None	None	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	95814	95814	95814	95814	95814	95814	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_naml	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Stephen	Stephen	Stephen	Stephen	None	Stephen	Stephen	None	Stephen	Stephen	None	None	Stephen	None	Stephen
tres_namf	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	Laura Ann	Laura Ann	Laura Ann	Laura Ann	None	Laura Ann	Laura Ann	None	Laura Ann	Laura Ann	None	None	Laura Ann	None	Laura Ann
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
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
tres_city	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	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	None	Sacramento	Sacramento	None	Sacramento	Sacramento	None	None	Sacramento	None	Sacramento
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	None	CA	CA	None	CA	CA	None	None	CA	None	CA
tres_zip4	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	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	None	95814	95814	None	95814	95814	None	None	95814	None	95814
tres_phon	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	916-706-2677	916-706-2677	916-706-2677	916-706-2677	None	916-706-2677	916-706-2677	None	916-706-2677	916-706-2677	None	None	916-706-2677	None	916-706-2677
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
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
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	G	G	G	G	G	G	G	G	G	G	None	None	G	G	None	None	G	G	G	G	None	G	G	None	None	G	None	None	G	G	None	G	None	G	G	G	G	None	None	None	G	G	None	None	G	None	None	G	None	None	G	G	G	G	G	G	None	G	None	G	G	G	None	None	None	None	G	None	G	None	G	G	None	G	G	None	None	G	None	G
control_yn	N	N	Y	Y	Y	Y	Y	Y	Y	Y	Y	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	None	Y	Y	None	None	Y	Y	Y	Y	None	Y	Y	None	None	Y	None	None	Y	Y	None	Y	None	Y	Y	Y	Y	None	None	None	Y	Y	None	None	Y	None	None	Y	None	None	Y	Y	Y	Y	Y	Y	None	Y	None	Y	Y	Y	None	None	None	None	Y	None	Y	None	Y	Y	None	Y	Y	None	None	Y	None	Y
sponsor_yn	Y	Y	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	N	N	N	N	N	N	N	N	None	None	N	N	None	None	N	N	N	N	None	N	N	None	None	N	None	None	N	N	None	N	None	N	N	N	N	None	None	None	N	N	None	None	N	None	None	N	None	None	N	N	N	N	N	N	None	N	None	N	N	N	None	None	None	None	N	None	N	None	N	N	None	N	N	None	None	N	None	N
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	N	N	N	N	N	N	N	N	N	N	None	None	N	N	None	None	N	N	N	N	None	N	N	None	None	N	None	None	N	N	None	N	None	N	N	N	N	None	None	None	N	N	None	None	N	None	None	N	None	None	N	N	N	N	N	N	None	N	None	N	N	N	None	None	None	None	N	None	N	None	N	N	None	N	N	None	None	N	None	N
brdbase_yn	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	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Amending 460	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
cand_naml	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
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
cand_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
cand_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
cand_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
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
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
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
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
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
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
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
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
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
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
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
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
sup_opp_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
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
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
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
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
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

Table: cvr_so
filing_id	1388566	1388566	1388566	1388566	1388566	1388566
amend_id	1	0	2	3	4	5
rec_type	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F410	F410	F410	F410	F410	F410
filer_id	1219570	1219570	1219570	1219570	1219570	1219570
entity_cd	RCP	RCP	RCP	RCP	RCP	RCP
filer_naml	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry	The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing Heating & Piping Industry
filer_namf	None	None	None	None	None	None
filer_namt	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None
report_num	001	000	002	003	004	005
rpt_date	2009-01-09 00:00:00	2000-02-07 00:00:00	2012-12-20 00:00:00	2018-01-09 00:00:00	2020-07-08 00:00:00	2021-06-03 00:00:00
qual_cb	None	None	None	X	X	X
qualfy_dt	2000-02-07 00:00:00	2000-02-07 00:00:00	2000-02-07 00:00:00	2000-02-07 00:00:00	2000-02-07 00:00:00	2000-02-07 00:00:00
term_date	None	None	None	None	None	None
city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
st	CA	CA	CA	CA	CA	CA
zip4	95814	95814	95814	95814	95814	95814
phone	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	(916) 442-2272	916-706-2677
county_res	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
county_act	None	None	None	None	None	Statewide
mail_city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	None
mail_st	CA	CA	CA	CA	CA	None
mail_zip4	95814	95814	95814	95814	95814	None
cmte_fax	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	(916) 442-1693	None
cmte_email	344000jh	344000jh	344000jh	[email protected] 344000jh	[email protected] 344000slm	[email protected]
tres_naml	Eichman	Eichman	Eichman	Eichman	Eichman	Stephen
tres_namf	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	Laura Ann
tres_namt	None	None	None	None	None	None
tres_nams	None	None	None	None	None	None
tres_city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
tres_st	CA	CA	CA	CA	CA	CA
tres_zip4	95814	95814	95814	95814	95814	95814
tres_phon	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	916-706-2677
actvty_lvl	None	None	ST	ST	ST	ST
com82013yn	None	None	None	None	None	None
com82013nm	None	None	None	None	None	None
com82013id	None	None	None	None	None	None
control_cb	None	None	None	None	None	None
bank_nam	None	None	Wells Fargo Bank, N.A.	Wells Fargo Bank, N.A.	F & M BANK	California Bank and Trust
bank_adr1	None	None	400 Capitol Mall	400 Capitol Mall	CAPITOL OFFICE, 1303 J STREET	550 South Hope Street, Suite 100
bank_adr2	None	None	None	None	None	None
bank_city	None	None	Sacramento	Sacramento	SACRAMENTO	Los Angeles
bank_st	None	None	CA	CA	CA	CA
bank_zip4	None	None	95814	95814	95814	90071
bank_phon	None	None	(916) 440-4331	(916) 440-4331	(800) 888-1498	(213) 228-1700
acct_opendt	None	None	None	None	None	None
surplusdsp	None	None	None	None	None	None
primfc_cb	None	None	None	None	None	None
genpurp_cb	None	None	None	None	None	None
gpc_descr	This committee expects to support numerous candidates for state and local candidates, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200	This committee expects to support numerous candidates for state and local candidates, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200	This committee expects to support numerous state and local candidates, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200	This committee expects to support numerous state and local candidates, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200	This committee expects to support numerous state and local candidates, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200	This committee expects to support numerous state and local candidates, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200
sponsor_cb	None	None	None	X	X	X
brdbase_cb	None	None	None	None	None	None
smcont_qualdt	None	None	None	None	None	None

Table: efs_filing_log
filing_date	2001-10-08 00:00:00	2001-10-08 00:00:00	2001-09-05 00:00:00	2001-09-05 00:00:00	2002-01-10 00:00:00	2002-01-10 00:00:00	2002-07-17 00:00:00	2002-07-17 00:00:00	2002-10-01 00:00:00	2002-10-01 00:00:00	2002-10-22 00:00:00	2002-10-22 00:00:00	2003-01-16 00:00:00	2003-01-16 00:00:00	2003-07-08 00:00:00	2003-07-08 00:00:00	2003-09-23 00:00:00	2003-09-23 00:00:00	2004-01-02 00:00:00	2004-01-02 00:00:00
filingstatus	1	0	1	0	1	0	1	0	1	0	1	0	1	0	1	0	1	0	1	0
vendor	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE
filer_id	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570
form_type	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460
error_no	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED

Table: filer_address
filer_id	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570
adrid	1129220	2157406	2157407	2503628	2503627	2519243	2445092	2445091
effect_dt	2000-01-10 00:00:00	2000-02-07 00:00:00	2000-02-07 00:00:00	2020-07-27 00:00:00	2020-07-27 00:00:00	2021-06-03 00:00:00	2018-01-11 00:00:00	2018-01-11 00:00:00
add_type	7051	7051	7082	7082	7051	7051	7082	7051
session_id	1999	1999	1999	2019	2019	2021	2017	2017

Table: filer_filings
filer_id	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570
filing_id	576941	592785	628607	641185	671896	717181	786314	775476	779949	785272	805848	804741	869991	851534	850035	870436	879081	876355	902402	903139	941598	940874	959166	983085	959494	977988	1021708	1022734	1063864	1070415	1077629	1110950	1115741	1141174	1140879	1182389	1172749	1172185	1184006	1211958	1219624	1230641	1227360	1276833	1275887	1302162	1301973	1776272	1778077	1963575	1943840	1973938	1973681	1858749	1862865	1864211	1810007	1810631	1909305	1898110	1319247	1318670	1342272	1341934	1388566	1389890	1388566	1389480	1403509	1429022	1430364	1456996	1490238	1498905	1457116	1499083	1489362	1521163	1529224	1523319	1528057	1559897	1562171	1601542	1627574	1627201	1601200	1665682	1662317	1671206	1830496	1670998	1901472	1925193	1388566	1891081	1893040	1884664	1742101	1724441	1846948	1852473	1834515	1728361	2004574	2003681	2238722	2262962	2489867	2480511	2286254	2203239	2295291	2390479	2264443	1388566	2201328	2237551	2374521	2395884	1388566	2221502	2315901	2308363	2039640	2045144	2036235	2031062	2033791	2039759	2044572	2054564	2051131	2068391	2054824	2082329	2095050	2119642	2125217	2165559	2372613	2298122	2414832	2167509	2333908	2426925	2413167	2486657	2363624	2549108	2533790	2520086	2202483	2252770	1388566	2434460	2294505	2355779	2593089	2454330	2504505	2455863	2534210	2229336	2516892	2431464	2519563	2489072	2440454	2284817	2310880	2568744	2514268	2672746	2634047	2685591	2660836	2587141	2724893	2633475	2713552	2649980	2697364	2615696	2662282	2626373	2591555	2670032	2724893	2744891	2741031	2727884	2740216	2733309
period_id	None	None	None	None	None	None	None	None	165	167	None	168	171	None	169	None	None	172	172	None	None	173	175	None	None	176	177	None	165	179	None	181	None	None	183	186	None	185	None	187	None	None	188	None	189	None	191	213	None	222	None	None	221	None	218	None	215	None	None	220	None	193	None	193	161	None	197	195	None	197	None	199	None	202	None	None	201	203	None	None	204	204	None	None	None	207	205	None	209	None	217	210	220	220	212	219	None	219	None	211	218	217	217	None	None	223	None	234	None	241	235	None	235	238	None	233	231	233	None	None	243	233	None	236	226	226	226	226	225	None	226	226	None	227	None	227	None	227	None	229	237	None	None	None	236	240	239	None	237	244	None	243	None	234	246	241	235	None	None	241	243	None	None	234	244	240	244	243	None	235	235	None	244	None	None	250	249	None	251	248	251	249	250	247	250	None	245	249	251	252	None	None	251	252
form_id	F410	F460	F410	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F666	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	F497	F460	F460	F460	F460	F410	F460	F410	F460	F410	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	F410	F460	F460	F497	F410	F460	F497	F460	F497	F460	F460	F460	F460	F460	F460	F460	F497	F410	F460	F460	F460	F410	F460	F460	F460	F460	F410	F497	F460	F497	F497	F460	F497	F497	F460	F460	F497	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F410	F497	F460	F460	F460	F460	F497	F410	F497	F497	F460	F460	F460	F460	F460	F460	F497	F497	F460	F497	F497	F460	F497	F460	F460	F497	F460	F460	F497	F497	F410	F460	F460	F497	F497	F460	F460	F497	F460	F460	F460	F460	F497	F460	F460	F460	F497
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	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	0	0	0	5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0
filing_date	2000-01-10 00:00:00	2000-02-22 00:00:00	2000-02-16 00:00:00	2000-07-18 00:00:00	2000-10-03 00:00:00	2001-01-26 00:00:00	2001-10-10 00:00:00	2001-07-16 00:00:00	2001-09-05 00:00:00	2001-10-08 00:00:00	2002-01-10 00:00:00	2002-01-10 00:00:00	2002-10-01 00:00:00	2002-07-19 00:00:00	2002-07-17 00:00:00	2002-10-01 00:00:00	2002-10-23 00:00:00	2002-10-22 00:00:00	2003-01-16 00:00:00	2003-01-16 00:00:00	2003-07-11 00:00:00	2003-07-08 00:00:00	2003-09-23 00:00:00	2004-01-07 00:00:00	2003-09-23 00:00:00	2004-01-02 00:00:00	2004-07-06 00:00:00	2004-07-09 00:00:00	2004-12-01 00:00:00	2005-01-06 00:00:00	2005-01-13 00:00:00	2005-07-05 00:00:00	2005-07-07 00:00:00	2006-01-09 00:00:00	2006-01-06 00:00:00	2006-07-05 00:00:00	2006-05-22 00:00:00	2006-05-21 00:00:00	2006-07-10 00:00:00	2006-10-26 00:00:00	2006-10-25 00:00:00	2007-01-10 00:00:00	2007-01-09 00:00:00	2007-07-05 00:00:00	2007-07-02 00:00:00	2008-01-03 00:00:00	2008-01-02 00:00:00	2013-07-18 00:00:00	2013-07-18 00:00:00	2015-04-28 00:00:00	2015-01-15 00:00:00	2015-07-10 00:00:00	2015-07-09 00:00:00	2014-05-22 00:00:00	2014-07-14 00:00:00	2014-07-15 00:00:00	2014-01-14 00:00:00	2014-01-14 00:00:00	2014-10-21 00:00:00	2014-10-14 00:00:00	2008-03-19 00:00:00	2008-03-18 00:00:00	2008-07-03 00:00:00	2008-07-02 00:00:00	2009-01-09 00:00:00	2009-01-15 00:00:00	2009-01-09 00:00:00	2009-01-14 00:00:00	2009-01-12 00:00:00	2009-07-06 00:00:00	2009-07-07 00:00:00	2010-01-07 00:00:00	2010-05-25 00:00:00	2010-07-01 00:00:00	2010-01-07 00:00:00	2010-07-01 00:00:00	2010-05-24 00:00:00	2010-10-01 00:00:00	2010-10-18 00:00:00	2010-10-01 00:00:00	2010-10-18 00:00:00	2011-01-13 00:00:00	2011-01-18 00:00:00	2011-07-19 00:00:00	2012-01-09 00:00:00	2012-01-09 00:00:00	2011-07-19 00:00:00	2012-05-24 00:00:00	2012-05-22 00:00:00	2012-07-12 00:00:00	2014-03-19 00:00:00	2012-07-12 00:00:00	2014-10-21 00:00:00	2015-01-13 00:00:00	2012-12-26 00:00:00	2014-10-02 00:00:00	2014-10-03 00:00:00	2014-09-11 00:00:00	2012-12-27 00:00:00	2013-01-11 00:00:00	2014-05-02 00:00:00	2014-05-21 00:00:00	2014-03-28 00:00:00	2013-01-11 00:00:00	2016-01-13 00:00:00	2016-01-13 00:00:00	2018-04-26 00:00:00	2018-07-06 00:00:00	2020-07-27 00:00:00	2020-07-23 00:00:00	2018-08-24 00:00:00	2018-01-11 00:00:00	2018-09-25 00:00:00	2019-07-16 00:00:00	2018-07-06 00:00:00	2018-01-11 00:00:00	2018-01-11 00:00:00	2018-04-26 00:00:00	2019-04-15 00:00:00	2019-07-18 00:00:00	2020-07-23 00:00:00	2018-03-12 00:00:00	2018-10-23 00:00:00	2018-10-18 00:00:00	2016-05-04 00:00:00	2016-05-23 00:00:00	2016-04-29 00:00:00	2016-04-21 00:00:00	2016-04-27 00:00:00	2016-04-28 00:00:00	2016-05-20 00:00:00	2016-07-12 00:00:00	2016-05-23 00:00:00	2016-08-15 00:00:00	2016-07-12 00:00:00	2016-09-28 00:00:00	2016-09-28 00:00:00	2017-01-13 00:00:00	2017-01-13 00:00:00	2017-07-05 00:00:00	2019-04-15 00:00:00	2018-09-25 00:00:00	2019-10-15 00:00:00	2017-07-06 00:00:00	2019-01-11 00:00:00	2019-12-27 00:00:00	2019-10-15 00:00:00	2020-07-27 00:00:00	2019-02-27 00:00:00	2021-01-28 00:00:00	2020-09-24 00:00:00	2020-10-21 00:00:00	2018-01-11 00:00:00	2018-05-23 00:00:00	2021-06-03 00:00:00	2020-01-23 00:00:00	2018-09-21 00:00:00	2019-01-11 00:00:00	2021-07-08 00:00:00	2020-02-19 00:00:00	2020-09-23 00:00:00	2020-02-19 00:00:00	2020-10-22 00:00:00	2018-04-09 00:00:00	2020-10-16 00:00:00	2020-01-17 00:00:00	2020-10-21 00:00:00	2020-08-07 00:00:00	2020-01-17 00:00:00	2018-08-20 00:00:00	2018-10-23 00:00:00	2021-01-29 00:00:00	2020-10-13 00:00:00	2022-04-25 00:00:00	2022-01-10 00:00:00	2022-05-24 00:00:00	2022-03-28 00:00:00	2021-06-04 00:00:00	2022-09-28 00:00:00	2022-01-10 00:00:00	2022-08-23 00:00:00	2022-02-14 00:00:00	2022-07-11 00:00:00	2021-10-13 00:00:00	2022-04-01 00:00:00	2021-10-13 00:00:00	2021-07-08 00:00:00	2022-04-25 00:00:00	2022-10-25 00:00:00	2022-10-28 00:00:00	2022-09-28 00:00:00	2022-07-11 00:00:00	2022-10-25 00:00:00	2022-10-14 00:00:00
stmnt_type	10005	10005	10002	10005	10005	10005	10005	10005	10001	10001	10005	10001	10001	10005	10001	10005	10005	10001	10001	10005	10005	10001	10001	10005	10005	10001	10001	10005	10005	10001	10005	10001	10005	10005	10001	10001	10005	10001	10005	10001	10005	10005	10001	10005	10001	10005	10001	10001	10005	10001	10005	10005	10001	10005	10001	10005	10001	10005	10005	10001	10005	10001	10005	10001	10001	10005	10002	10001	10006	10001	10005	10001	10005	10001	10005	10005	10001	10001	10005	10005	10001	10001	10005	10005	10005	10001	10001	10005	10001	10005	10001	10001	10001	10001	10002	10001	10005	10001	10006	10001	10001	10001	10001	10005	10005	10001	10005	10001	10005	10001	10001	10006	10001	10001	10005	10002	10001	10001	10005	10005	10002	10001	10005	10001	10001	10001	10001	10001	10001	10005	10001	10001	10005	10001	10005	10001	10005	10001	10005	10001	10001	10005	10005	10005	10001	10001	10001	10006	10001	10001	10005	10001	10005	10001	10002	10001	10001	10005	10005	10001	10001	10005	10005	10001	10001	10001	10001	10001	10005	10001	10001	10005	10001	10005	10005	10001	10001	10006	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10002	10001	10005	10005	10001	10001
stmnt_status	11001	11001	11001	11001	11003	11003	11001	11001	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11001	11003	11001	11001	11003	11003	11001	11003	11001	11003	11001	11001	11003	11001	11003	11001	11003	11003	11003	11001	11001	11001	11001	11001	11003	11003	11001	11003	11003	11001	11001	11003	11001	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11003	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11001	11001	11001	11001	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11003	11003	11001	11003	11003	11001	11003	11001	11001	11003	11001	11001	11003	11003	11001	11003	11001	11003	11003	11003	11001	11003	11001	11001	11001	11003	11003	11003	11003	11003	11003
session_id	1999	1999	1999	1999	1999	1999	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2003	2003	2003	2003	2003	2003	2003	2003	2001	2003	2003	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2007	2007	2007	2007	2013	2013	2015	2013	2015	2015	2013	2013	2013	2013	2013	2013	2013	2007	2007	2007	2007	1999	2009	2009	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2011	2011	2011	2011	2011	2013	2011	2013	2013	2011	2013	2013	2013	2011	2011	2013	2013	2013	2011	2015	2015	2017	2017	2019	2019	2017	2017	2017	2019	2017	2017	2017	2017	2019	2019	2019	2017	2017	2017	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2017	2019	2017	2019	2017	2017	2019	2019	2019	2019	2019	2019	2019	2017	2017	2021	2019	2017	2017	2021	2019	2019	2019	2019	2017	2019	2019	2019	2019	2019	2017	2017	2021	2019	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021
user_id	*	CFLAGG	YBONILLA	TTHAM	KCHAN	TWALLS	CFLAGG	SARRIAGA	DHORRELL	*	SARRIAGA	*	*	DBARRICK	*	DBARRICK	DBARRICK	*	COMPLETED	DBARRICK	KVOONG1	COMPLETED	COMPLETED	KLARRY	GGILMORE	COMPLETED	COMPLETED	EMCENTEE	PROBERTS	COMPLETED	CFLAGG	*	SARRIAGA	CFLAGG	*	*	GPEREZ	*	CFLAGG	*	SARRIAGA	GPEREZ	*	GPEREZ	*	SARRIAGA	*	CAFILER	MPACHECO	WBROWN	SARRIAGA	SARRIAGA	SARRIAGA	MDIGRAZIA	CAFILER	MPACHECO	MDIGRAZIA	MPACHECO	MPACHECO	WBROWN	SARRIAGA	*	SARRIAGA	*	*	JVAZQUEZ	*	*	RGEREMIA	CPON	CPON	CPON	MMORENO	MMORENO	CPON	MMORENO	MMORENO	CPON	SMCCONNAN	CPON	SMCCONNAN	SMCCONNAN	SMCCONNAN	CPON	MPACHECO	CAFILER	CPON	MDIGRAZIA	MDIGRAZIA	MDIGRAZIA	WBROWN	MDIGRAZIA	CAFILER	SARRIAGA	TRAMON	CAFILER	JINGRAM	WBROWN	TRAMON	CAFILER	WBROWN	MDIGRAZIA	WBROWN	MPACHECO	SARRIAGA	SARRIAGA	HSTOVALL	HSTOVALL	IMEDINA	IMEDINA	CAFILER	TRAMON	BSINGH	BCOLON	HSTOVALL	TRAMON	LBARTHOL	HSTOVALL	YMORA	BCOLON	TRAMON	CAFILER	HSTOVALL	CAFILER	KBANH	SMCCONNAN	KBANH	KBANH	MDIGRAZIA	MDIGRAZIA	KBANH	SARRIAGA	SMCCONNAN	PDEO	SARRIAGA	SARRIAGA	SARRIAGA	GPEREZ	GPEREZ	BSINGH	YMORA	BSINGH	SBROWN	BSINGH	LPHEAV	CAFILER	SBROWN	TRAMON	CAFILER	AXIONG	IMEDINA	IMEDINA	LBARTHOL	CAFILER	CAFILER	CAFILER	CAFILER	LPHEAV	BCOLON	VUKSTINA	IMEDINA	VUKSTINA	IMEDINA	CAFILER	CAFILER	VUKSTINA	CAFILER	CAFILER	VUKSTINA	CAFILER	HSTOVALL	AXIONG	CAFILER	KRUSSELL	KRUSSELL	CAFILER	CAFILER	IMEDINA	CAFILER	KRUSSELL	CAFILER	CAFILER	CAFILER	KRUSSELL	CAFILER	KRUSSELL	BCOLON	KRUSSELL	CAFILER	CAFILER	LPHEAV	JMAVES	CAFILER	CAFILER
special_audit	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	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	11003	11003	11001	11003	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	11001	11003	11003	11003	11001	11003	11003	11001	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11001	11003	11003	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	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	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	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	2000-01-01 00:00:00	None	2000-02-20 00:00:00	2000-07-01 00:00:00	2000-10-01 00:00:00	2001-07-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-07-01 00:00:00	2001-10-01 00:00:00	2001-10-01 00:00:00	2002-07-01 00:00:00	2002-01-01 00:00:00	2002-01-01 00:00:00	2002-07-01 00:00:00	2002-10-01 00:00:00	2002-10-01 00:00:00	2002-10-20 00:00:00	2002-10-20 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-07-01 00:00:00	2003-10-01 00:00:00	2003-07-01 00:00:00	2003-10-01 00:00:00	2004-01-01 00:00:00	2004-01-01 00:00:00	2001-01-01 00:00:00	2004-07-01 00:00:00	2004-07-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2005-07-01 00:00:00	2005-07-01 00:00:00	2006-05-21 00:00:00	2006-01-01 00:00:00	2006-01-01 00:00:00	2006-05-21 00:00:00	2006-07-01 00:00:00	2006-07-01 00:00:00	2006-10-22 00:00:00	2006-10-22 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2007-07-01 00:00:00	2007-07-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2015-04-28 00:00:00	2014-10-19 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2014-01-01 00:00:00	2014-05-18 00:00:00	2014-05-18 00:00:00	2013-07-01 00:00:00	2013-07-01 00:00:00	2014-10-01 00:00:00	2014-10-14 00:00:00	2008-01-01 00:00:00	2008-01-01 00:00:00	2008-03-18 00:00:00	2008-03-18 00:00:00	2000-02-07 00:00:00	2008-07-01 00:00:00	2009-01-09 00:00:00	2008-07-01 00:00:00	None	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-07-01 00:00:00	2010-01-01 00:00:00	2010-05-23 00:00:00	2009-07-01 00:00:00	2010-05-23 00:00:00	2010-01-01 00:00:00	2010-07-01 00:00:00	2010-10-01 00:00:00	2010-07-01 00:00:00	2010-10-01 00:00:00	2010-10-17 00:00:00	2010-10-17 00:00:00	2011-01-01 00:00:00	2011-07-01 00:00:00	2011-07-01 00:00:00	2011-01-01 00:00:00	2012-01-01 00:00:00	2012-01-01 00:00:00	2012-05-20 00:00:00	2014-03-19 00:00:00	2012-05-20 00:00:00	2014-10-01 00:00:00	2014-10-19 00:00:00	2012-12-20 00:00:00	2014-07-01 00:00:00	2014-07-01 00:00:00	2014-09-11 00:00:00	None	2012-07-01 00:00:00	2014-05-02 00:00:00	2014-01-01 00:00:00	2014-03-28 00:00:00	2012-07-01 00:00:00	2015-07-01 00:00:00	2015-07-01 00:00:00	2018-01-01 00:00:00	2018-04-22 00:00:00	2020-02-16 00:00:00	2020-02-16 00:00:00	2018-08-24 00:00:00	None	2018-07-01 00:00:00	2019-04-01 00:00:00	2018-04-22 00:00:00	2018-01-09 00:00:00	2017-07-01 00:00:00	2018-01-01 00:00:00	2019-01-01 00:00:00	2019-04-01 00:00:00	2020-07-08 00:00:00	2018-03-12 00:00:00	2018-09-23 00:00:00	2018-10-17 00:00:00	2016-05-04 00:00:00	2016-04-24 00:00:00	2016-04-29 00:00:00	2016-04-21 00:00:00	2016-01-01 00:00:00	2016-01-01 00:00:00	2016-05-20 00:00:00	2016-05-22 00:00:00	2016-04-24 00:00:00	2016-08-15 00:00:00	2016-05-22 00:00:00	2016-07-01 00:00:00	2016-07-01 00:00:00	2016-09-25 00:00:00	2016-09-25 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2018-07-01 00:00:00	2019-07-01 00:00:00	2017-01-01 00:00:00	2018-10-21 00:00:00	2019-12-27 00:00:00	2019-07-01 00:00:00	None	2019-02-27 00:00:00	2020-10-18 00:00:00	2020-07-01 00:00:00	2020-09-20 00:00:00	2017-07-01 00:00:00	2018-05-22 00:00:00	2021-06-03 00:00:00	2020-01-23 00:00:00	2018-09-21 00:00:00	2018-10-21 00:00:00	2021-01-01 00:00:00	2020-01-01 00:00:00	2020-07-01 00:00:00	2020-01-01 00:00:00	2020-09-20 00:00:00	2018-04-09 00:00:00	2020-10-16 00:00:00	2019-10-01 00:00:00	2020-10-21 00:00:00	2020-08-07 00:00:00	2019-10-01 00:00:00	2018-08-20 00:00:00	2018-09-23 00:00:00	2020-10-18 00:00:00	2020-10-13 00:00:00	2022-01-01 00:00:00	2021-10-01 00:00:00	2022-05-24 00:00:00	2022-03-28 00:00:00	None	2022-07-01 00:00:00	2021-10-01 00:00:00	2022-08-23 00:00:00	2022-02-14 00:00:00	2022-04-24 00:00:00	2021-07-01 00:00:00	2022-04-01 00:00:00	2021-07-01 00:00:00	2021-01-01 00:00:00	2022-01-01 00:00:00	2022-07-01 00:00:00	2022-10-28 00:00:00	2022-07-01 00:00:00	2022-04-24 00:00:00	2022-09-25 00:00:00	2022-10-14 00:00:00
rpt_end	None	2000-02-19 00:00:00	None	2000-06-30 00:00:00	2000-09-30 00:00:00	2000-12-31 00:00:00	2001-09-30 00:00:00	2001-06-30 00:00:00	2001-06-30 00:00:00	2001-09-30 00:00:00	2001-12-31 00:00:00	2001-12-31 00:00:00	2002-09-30 00:00:00	2002-06-30 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	2002-10-19 00:00:00	2002-10-19 00:00:00	2002-12-31 00:00:00	2002-12-31 00:00:00	2003-06-30 00:00:00	2003-06-30 00:00:00	2003-09-20 00:00:00	2003-12-31 00:00:00	2003-09-20 00:00:00	2003-12-31 00:00:00	2004-06-30 00:00:00	2004-06-30 00:00:00	2002-12-31 00:00:00	2004-12-31 00:00:00	2004-12-31 00:00:00	2005-06-30 00:00:00	2005-06-30 00:00:00	2005-12-31 00:00:00	2005-12-31 00:00:00	2006-06-30 00:00:00	2006-05-20 00:00:00	2006-05-20 00:00:00	2006-06-30 00:00:00	2006-10-21 00:00:00	2006-10-21 00:00:00	2006-12-31 00:00:00	2006-12-31 00:00:00	2007-06-30 00:00:00	2007-06-30 00:00:00	2007-12-31 00:00:00	2007-12-31 00:00:00	2013-06-30 00:00:00	2013-06-30 00:00:00	2015-04-28 00:00:00	2014-12-31 00:00:00	2015-06-30 00:00:00	2015-06-30 00:00:00	2014-05-17 00:00:00	2014-06-30 00:00:00	2014-06-30 00:00:00	2013-12-31 00:00:00	2013-12-31 00:00:00	2014-10-18 00:00:00	2014-10-14 00:00:00	2008-03-17 00:00:00	2008-03-17 00:00:00	2008-06-30 00:00:00	2008-06-30 00:00:00	2000-02-07 00:00:00	2008-12-31 00:00:00	2009-01-09 00:00:00	2008-12-31 00:00:00	None	2009-06-30 00:00:00	2009-06-30 00:00:00	2009-12-31 00:00:00	2010-05-22 00:00:00	2010-06-30 00:00:00	2009-12-31 00:00:00	2010-06-30 00:00:00	2010-05-22 00:00:00	2010-09-30 00:00:00	2010-10-16 00:00:00	2010-09-30 00:00:00	2010-10-16 00:00:00	2010-12-31 00:00:00	2010-12-31 00:00:00	2011-06-30 00:00:00	2011-12-31 00:00:00	2011-12-31 00:00:00	2011-06-30 00:00:00	2012-05-19 00:00:00	2012-05-19 00:00:00	2012-06-30 00:00:00	2014-03-19 00:00:00	2012-06-30 00:00:00	2014-10-18 00:00:00	2014-12-31 00:00:00	2012-12-20 00:00:00	2014-09-30 00:00:00	2014-09-30 00:00:00	2014-09-11 00:00:00	None	2012-12-31 00:00:00	2014-05-02 00:00:00	2014-05-17 00:00:00	2014-03-28 00:00:00	2012-12-31 00:00:00	2015-12-31 00:00:00	2015-12-31 00:00:00	2018-04-21 00:00:00	2018-06-30 00:00:00	2020-06-30 00:00:00	2020-06-30 00:00:00	2018-08-24 00:00:00	None	2018-09-22 00:00:00	2019-06-30 00:00:00	2018-06-30 00:00:00	2018-01-09 00:00:00	2017-12-31 00:00:00	2018-04-21 00:00:00	2019-03-31 00:00:00	2019-06-30 00:00:00	2020-07-08 00:00:00	2018-03-12 00:00:00	2018-10-20 00:00:00	2018-10-17 00:00:00	2016-05-04 00:00:00	2016-05-21 00:00:00	2016-04-29 00:00:00	2016-04-21 00:00:00	2016-04-23 00:00:00	2016-04-23 00:00:00	2016-05-20 00:00:00	2016-06-30 00:00:00	2016-05-21 00:00:00	2016-08-15 00:00:00	2016-06-30 00:00:00	2016-09-24 00:00:00	2016-09-24 00:00:00	2016-12-31 00:00:00	2016-12-31 00:00:00	2017-06-30 00:00:00	2019-03-31 00:00:00	2018-09-22 00:00:00	2019-09-30 00:00:00	2017-06-30 00:00:00	2018-12-31 00:00:00	2019-12-27 00:00:00	2019-09-30 00:00:00	None	2019-02-27 00:00:00	2020-12-31 00:00:00	2020-09-19 00:00:00	2020-10-17 00:00:00	2017-12-31 00:00:00	2018-05-22 00:00:00	2021-06-03 00:00:00	2020-01-23 00:00:00	2018-09-21 00:00:00	2018-12-31 00:00:00	2021-06-30 00:00:00	2020-02-15 00:00:00	2020-09-19 00:00:00	2020-02-15 00:00:00	2020-10-17 00:00:00	2018-04-09 00:00:00	2020-10-16 00:00:00	2019-12-31 00:00:00	2020-10-21 00:00:00	2020-08-07 00:00:00	2019-12-31 00:00:00	2018-08-20 00:00:00	2018-10-20 00:00:00	2020-12-31 00:00:00	2020-10-13 00:00:00	2022-04-23 00:00:00	2021-12-31 00:00:00	2022-05-24 00:00:00	2022-03-28 00:00:00	None	2022-09-02 00:00:00	2021-12-31 00:00:00	2022-08-23 00:00:00	2022-02-14 00:00:00	2022-06-30 00:00:00	2021-09-30 00:00:00	2022-04-01 00:00:00	2021-09-30 00:00:00	2021-06-30 00:00:00	2022-04-23 00:00:00	2022-09-24 00:00:00	2022-10-28 00:00:00	2022-09-02 00:00:00	2022-06-30 00:00:00	2022-10-22 00:00:00	2022-10-14 00:00:00
rpt_date	None	None	None	None	None	None	None	None	2001-07-11 00:00:00	2001-10-02 00:00:00	None	2002-01-09 00:00:00	2002-10-01 00:00:00	None	2002-07-10 00:00:00	None	None	2002-10-21 00:00:00	2003-01-13 00:00:00	None	None	2003-07-01 00:00:00	2003-09-22 00:00:00	None	None	2004-01-02 00:00:00	2004-07-06 00:00:00	None	None	2005-01-05 00:00:00	None	2005-07-01 00:00:00	None	None	2006-01-04 00:00:00	2006-07-05 00:00:00	None	2006-05-22 00:00:00	None	2006-10-26 00:00:00	None	None	2007-01-08 00:00:00	None	2007-07-02 00:00:00	None	2008-01-02 00:00:00	2013-07-16 00:00:00	None	2015-04-28 00:00:00	None	None	2015-07-08 00:00:00	None	2014-07-09 00:00:00	None	2014-01-10 00:00:00	None	None	2014-10-14 00:00:00	None	2008-03-18 00:00:00	None	2008-07-01 00:00:00	None	None	None	2009-01-13 00:00:00	None	2009-07-01 00:00:00	None	2010-01-04 00:00:00	None	2010-07-01 00:00:00	None	None	2010-05-24 00:00:00	2010-10-01 00:00:00	None	None	2010-10-18 00:00:00	2011-01-03 00:00:00	None	None	None	2012-01-03 00:00:00	2011-07-14 00:00:00	None	2012-05-21 00:00:00	None	2014-03-19 00:00:00	2012-07-11 00:00:00	2014-10-20 00:00:00	2015-01-07 00:00:00	None	2014-10-01 00:00:00	None	2014-09-11 00:00:00	None	2013-01-08 00:00:00	2014-05-02 00:00:00	2014-05-19 00:00:00	2014-03-28 00:00:00	None	None	2016-01-08 00:00:00	None	2018-07-03 00:00:00	None	2020-07-08 00:00:00	2018-08-24 00:00:00	None	2018-09-24 00:00:00	2019-07-03 00:00:00	None	None	2018-01-09 00:00:00	2018-04-26 00:00:00	None	None	None	2018-03-12 00:00:00	None	2018-10-17 00:00:00	2016-05-04 00:00:00	2016-05-23 00:00:00	2016-04-29 00:00:00	2016-04-21 00:00:00	2016-04-25 00:00:00	None	2016-05-20 00:00:00	2016-07-08 00:00:00	None	2016-08-15 00:00:00	None	2016-09-26 00:00:00	None	2017-01-12 00:00:00	None	2017-07-05 00:00:00	2019-04-09 00:00:00	None	None	None	2019-01-10 00:00:00	2019-12-27 00:00:00	2019-10-01 00:00:00	None	2019-02-27 00:00:00	2021-01-18 00:00:00	None	2020-10-18 00:00:00	None	2018-05-22 00:00:00	None	2020-01-23 00:00:00	2018-09-21 00:00:00	None	None	2020-02-18 00:00:00	2020-09-20 00:00:00	None	None	2018-04-09 00:00:00	2020-10-16 00:00:00	2020-01-06 00:00:00	2020-10-21 00:00:00	2020-08-07 00:00:00	None	2018-08-20 00:00:00	2018-10-22 00:00:00	None	2020-10-13 00:00:00	None	None	2022-05-24 00:00:00	2022-03-28 00:00:00	None	2022-09-28 00:00:00	2022-01-04 00:00:00	2022-08-23 00:00:00	2022-02-14 00:00:00	2022-07-05 00:00:00	2021-10-13 00:00:00	2022-04-01 00:00:00	None	2021-07-08 00:00:00	2022-04-22 00:00:00	2022-10-24 00:00:00	2022-10-28 00:00:00	None	None	2022-10-24 00:00:00	2022-10-14 00:00:00
filing_type	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	22001	None	None	22001	22001	None	None	22001	22001	None	None	22001	None	22001	None	None	22001	22001	None	22001	None	22001	None	None	22001	None	22001	None	22001	22001	None	22001	None	None	22001	None	22001	None	22001	None	None	22001	None	22001	None	22001	22001	None	22001	22001	None	22001	None	22001	None	22001	None	None	22001	22001	None	None	22001	22001	None	None	None	22001	22001	None	22001	None	22001	22001	22001	22001	22001	22001	None	22001	None	22001	22001	22001	22001	None	None	22001	None	22001	None	22001	22001	None	22001	22001	None	22001	22001	22001	None	None	22001	22001	None	22001	22001	22001	22001	22001	22001	None	22001	22001	None	22001	None	22001	None	22001	None	22001	22001	None	None	None	22001	22001	22001	None	22001	22001	None	22001	None	22001	22001	22001	22001	None	None	22001	22001	None	None	22001	22001	22001	22001	22001	None	22001	22001	None	22001	None	None	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	None	None	22001	22001

Table: filer_to_filer_type
filer_id		1219570
filer_type		16
active		Y
race		0
session_id		1999
category		0
category_type		40502
sub_category		40103
effect_dt		2000-01-10 00:00:00
sub_category_type		0
election_type		0
sub_category_a		S
nyq_dt		2000-02-07 00:00:00
party_cd		0
county_cd		18004
district_cd		0

Table: filer_xref
filer_id		1219570
xref_id		1219570
effect_dt		2000-01-11 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570
filer_id	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570
filer_type	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
effect_dt	2000-01-10 00:00:00	2000-01-10 00:00:00	2000-01-10 00:00:00	2000-01-10 00:00:00	2000-01-10 00:00:00	2000-01-10 00:00:00	2000-01-10 00:00:00	2000-01-10 00:00:00
naml	PLUMBING, PIPING AND MECHANICAL CONTRACTORS PAC, SPONSORED BY CALIFORNIA LEGISLATIVE CONFERENCE OF PLUMBING HEATING AND PIPING INDUSTRY, THE	PLUMBING, PIPING AND MECHANICAL CONTRACTORS PAC, SPONSORED BY CALIFORNIA LEGISLATIVE CONFERENCE OF PLUMBING HEATING AND PIPING INDUSTRY, THE	PLUMBING, PIPING AND MECHANICAL CONTRACTORS PAC, SPONSORED BY CALIFORNIA LEGISLATIVE CONFERENCE OF PLUMBING HEATING AND PIPING INDUSTRY, THE	PLUMBING, PIPING AND MECHANICAL CONTRACTORS PAC, SPONSORED BY CALIFORNIA LEGISLATIVE CONFERENCE OF PLUMBING HEATING AND PIPING INDUSTRY, THE	PLUMBING, PIPING AND MECHANICAL CONTRACTORS PAC, SPONSORED BY CALIFORNIA LEGISLATIVE CONFERENCE OF PLUMBING HEATING AND PIPING INDUSTRY, THE	PLUMBING, PIPING AND MECHANICAL CONTRACTORS PAC, SPONSORED BY CALIFORNIA LEGISLATIVE CONFERENCE OF PLUMBING HEATING AND PIPING INDUSTRY, THE	PLUMBING, PIPING AND MECHANICAL CONTRACTORS PAC, SPONSORED BY CALIFORNIA LEGISLATIVE CONFERENCE OF PLUMBING HEATING AND PIPING INDUSTRY, THE	PLUMBING, PIPING AND MECHANICAL CONTRACTORS PAC, SPONSORED BY CALIFORNIA LEGISLATIVE CONFERENCE OF PLUMBING HEATING AND PIPING INDUSTRY, THE
namf	None	None	None	None	None	None	None	None
namt	None	None	None	None	None	None	None	None
nams	None	None	None	None	None	None	None	None
adr1	None	None	None	None	None	None	None	None
adr2	None	None	None	None	None	None	None	None
city	SACRAMENTO	Sacramento	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
st	CA	CA	CA	CA	CA	CA	CA	CA
zip4	95814	95814	95814	95814	95814	95814	95814	95814
phon	9164422280	9164422272	(916) 442-2272	9164422272	9164422272	9164422272	9164422272	9167062677
fax	None		(916) 442-1693	9164421693	9164421693	9164421693	9164421693	9164421693
email	None	344000jh	344000jh	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]

Table: filers
filer_id		1219570

Table: received_filings
filer_id	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570	1219570
filing_file_name	779949_0.cal	785272_0.cal	804741_0.cal	850035_0.cal	876355_0.cal	869991_0.cal	902402_0.cal	940874_0.cal	959166_0.cal	977988_0.cal	27123.cal	27065.cal	517494.cal	517669.cal	517883.cal	27224.cal	1388566_0.cal	1846948_0.cal	1830496_0.cal	1834515_0.cal	2044572_0.cal	1898110_0.cal	1884664_0.cal	2068391_0.cal	2036235_0.cal	2031062_0.cal	2039640_0.cal	1963575_0.cal	2286254_0.cal	2221502_0.cal	2308363_0.cal	2426925_0.cal	2363624_0.cal	2252770_0.cal	230063.cal	2294505_0.cal	2489072_0.cal	2434460_0.cal	2229336_0.cal	2284817_0.cal	2733309_0.cal	2685591_0.cal	2660836_0.cal	2519563_0.cal	2516892_0.cal	2713552_0.cal	2649980_0.cal	2744891_0.cal	2514268_0.cal	2662282_0.cal
received_date	2001-09-05 00:00:00	2001-10-08 00:00:00	2002-01-10 00:00:00	2002-07-17 00:00:00	2002-10-22 00:00:00	2002-10-01 00:00:00	2003-01-16 00:00:00	2003-07-08 00:00:00	2003-09-23 00:00:00	2004-01-02 00:00:00	2006-10-25 00:00:00	2006-10-25 00:00:00	2006-10-24 00:00:00	2006-10-24 00:00:00	2006-10-24 00:00:00	2006-10-25 00:00:00	2009-01-09 00:00:00	2014-05-02 00:00:00	2014-03-19 00:00:00	2014-03-28 00:00:00	2016-05-20 00:00:00	2014-10-14 00:00:00	2014-09-11 00:00:00	2016-08-15 00:00:00	2016-04-29 00:00:00	2016-04-21 00:00:00	2016-05-04 00:00:00	2015-04-28 00:00:00	2018-08-24 00:00:00	2018-03-12 00:00:00	2018-10-18 00:00:00	2019-12-27 00:00:00	2019-02-27 00:00:00	2018-05-23 00:00:00	2018-05-23 00:00:00	2018-09-21 00:00:00	2020-08-07 00:00:00	2020-01-23 00:00:00	2018-04-09 00:00:00	2018-08-20 00:00:00	2022-10-14 00:00:00	2022-05-24 00:00:00	2022-03-28 00:00:00	2020-10-21 00:00:00	2020-10-16 00:00:00	2022-08-23 00:00:00	2022-02-14 00:00:00	2022-10-28 00:00:00	2020-10-13 00:00:00	2022-04-01 00:00:00
filing_directory	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/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	779949	785272	804741	850035	876355	869991	902402	940874	959166	977988	None	None	None	None	None	None	1388566	1846948	1830496	1834515	2044572	1898110	1884664	2068391	2036235	2031062	2039640	1963575	2286254	2221502	2308363	2426925	2363624	2252770	None	2294505	2489072	2434460	2229336	2284817	2733309	2685591	2660836	2519563	2516892	2713552	2649980	2744891	2514268	2662282
form_id	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	None	None	None	None	None	None	F410	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	None	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497
receive_comment	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted