OpenCalAccess

Filer ID: 1443381

Table: cvr_campaign_disclosure
filing_id	2660181	2656510	2662141	2636956	2665061	2670430	2666451	2673767	2665528	2669272	2663441	2668922	2664611	2673159	2659606	2662318	2657655	2658027	2658477	2659179	2691371	2685272	2707683	2679324	2713221	2686059	2711825	2730778	2730784	2710957	2730299	2678939	2687465	2712655	2728466	2728638	2691046	2726540	2677956	2692787	2681672	2717567	2680824	2678939	2711359	2681953	2719832	2692309	2726769	2726788	2684753	2714265	2692819	2712727	2714712	2713726	2678939	2673159	2717127	2715675	2707683	2718089	2687465	2726047	2722925	2689005	2689006	2722030	2720707	2689653	2724622	2725086	2723949	2752792	2744692	2749094	2751950	2732333	2735913	2740115	2739085	2741354	2731690	2736856	2734323	2752869	2739463	2739093	2741351	2740115	2739411	2750719	2734249	2726047	2743628	2752578	2752580	2738197
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	2	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	1	0	0	1	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	1	0	0	0	1	0	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F497	F497	F460	F497	F460	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F460	F497	F497	F497
filer_id	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381
entity_cd	CTL	CTL	None	CTL	CTL	CTL	CTL	CTL	CTL	CTL	None	CTL	CTL	CTL	CTL	None	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL
filer_naml	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022	Joe Patterson for Assembly 2022
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
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
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
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	002	000	000	000	000	000	000	000	000	000	000	000	001	000	000	000	000	000	000	000	000	000	000	000	000	000	001	000	000	001	000	001	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	000	000	000	001	000	000	000	000
rpt_date	2022-03-24 00:00:00	1900-01-01 00:00:00	2022-03-31 00:00:00	2022-01-24 00:00:00	2022-04-11 00:00:00	2022-04-25 00:00:00	2022-04-14 00:00:00	2022-04-28 00:00:00	2022-04-12 00:00:00	2022-04-22 00:00:00	2022-04-05 00:00:00	2022-04-21 00:00:00	2022-04-08 00:00:00	2022-04-28 00:00:00	2022-03-22 00:00:00	2022-04-01 00:00:00	2022-03-15 00:00:00	1900-01-01 00:00:00	2022-03-18 00:00:00	1900-01-01 00:00:00	2022-06-04 00:00:00	2022-05-23 00:00:00	2022-07-14 00:00:00	2022-05-04 00:00:00	2022-08-22 00:00:00	2022-05-25 00:00:00	2022-08-16 00:00:00	2022-10-10 00:00:00	2022-10-10 00:00:00	2022-08-12 00:00:00	2022-10-07 00:00:00	2022-05-17 00:00:00	2022-05-26 00:00:00	2022-08-18 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-06-03 00:00:00	2022-09-29 00:00:00	2022-05-02 00:00:00	2022-06-08 00:00:00	2022-05-11 00:00:00	2022-09-06 00:00:00	2022-05-09 00:00:00	2022-05-10 00:00:00	2022-08-15 00:00:00	2022-05-12 00:00:00	2022-09-13 00:00:00	2022-06-07 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-05-20 00:00:00	2022-08-24 00:00:00	2022-06-08 00:00:00	2022-08-18 00:00:00	2022-08-25 00:00:00	2022-08-23 00:00:00	2022-05-03 00:00:00	2022-05-24 00:00:00	2022-09-02 00:00:00	2022-08-29 00:00:00	2022-09-29 00:00:00	2022-09-07 00:00:00	2022-07-14 00:00:00	2022-09-29 00:00:00	2022-09-23 00:00:00	2022-05-31 00:00:00	2022-05-31 00:00:00	2022-09-20 00:00:00	2022-09-15 00:00:00	2022-06-01 00:00:00	2022-09-27 00:00:00	2022-09-28 00:00:00	2022-09-26 00:00:00	2022-11-05 00:00:00	2022-10-27 00:00:00	2022-10-31 00:00:00	2022-11-03 00:00:00	2022-10-12 00:00:00	2022-10-18 00:00:00	2022-10-24 00:00:00	2022-10-21 00:00:00	2022-10-25 00:00:00	2022-10-12 00:00:00	2022-10-19 00:00:00	2022-10-14 00:00:00	2022-11-06 00:00:00	2022-10-23 00:00:00	2022-10-21 00:00:00	2022-10-25 00:00:00	2022-11-11 00:00:00	2022-10-23 00:00:00	2022-11-01 00:00:00	2022-10-14 00:00:00	2022-10-23 00:00:00	2022-10-27 00:00:00	2022-11-04 00:00:00	2022-11-04 00:00:00	2022-10-20 00:00:00
stmt_type	None	None	None	None	None	None	None	None	None	None	None	None	None	PE	None	None	None	None	None	None	None	None	SA	None	None	None	None	None	None	None	None	None	PE	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	PE	None	None	SA	None	PE	PE	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	PE	PE	None	None	None
late_rptno	2022-8	2022-2	2022-9	2022-1	2022-13	2022-18	2022-15	2022-19	2022-14	2022-17	2022-11	2022-16	2022-12	None	2022-7	2022-10	2022-3	2022-4	2022-5	2022-6	2022-33	2022-27	None	2022-22	2022-42	2022-28	2022-39	2022-63	2022-64	2022-37	2022-62	2022-21	None	2022-40	2022-60	2022-61	2022-32	2022-57	2022-20	2022-35	2022-24	2022-48	2022-23	2022-21	2022-38	2022-25	2022-50	2022-34	2022-58	2022-59	2022-26	2022-44	2022-36	2022-41	2022-45	2022-43	2022-21	None	2022-47	2022-46	None	2022-49	None	None	2022-53	2022-29	2022-30	2022-52	2022-51	2022-31	2022-55	2022-56	2022-54	2022-85	2022-79	2022-80	2022-82	2022-66	2022-69	2022-76	2022-72	2022-78	2022-65	2022-70	2022-68	2022-86	2022-75	2022-73	2022-77	2022-76	2022-74	2022-81	2022-67	None	None	2022-83	2022-84	2022-71
from_date	None	None	None	None	None	None	None	None	None	None	None	None	None	2022-01-01 00:00:00	None	None	None	None	None	None	None	None	2022-05-22 00:00:00	None	None	None	None	None	None	None	None	None	2022-04-24 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	2022-01-01 00:00:00	None	None	2022-05-22 00:00:00	None	2022-04-24 00:00:00	2022-07-01 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	2022-07-01 00:00:00	2022-09-25 00:00:00	None	None	None
thru_date	None	None	None	None	None	None	None	None	None	None	None	None	None	2022-04-23 00:00:00	None	None	None	None	None	None	None	None	2022-06-30 00:00:00	None	None	None	None	None	None	None	None	None	2022-05-21 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	2022-04-23 00:00:00	None	None	2022-06-30 00:00:00	None	2022-05-21 00:00:00	2022-09-24 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	2022-09-24 00:00:00	2022-10-22 00:00:00	None	None	None
elect_date	None	None	2022-06-07 00:00:00	None	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	None	2022-06-07 00:00:00	None	None	None	None	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-11-08 00:00:00	2022-11-08 00:00:00	2022-06-07 00:00:00	2022-11-08 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-11-08 00:00:00	2022-11-08 00:00:00	2022-06-07 00:00:00	2022-11-08 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-11-08 00:00:00	2022-11-08 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-11-08 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-11-08 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 00:00:00	2022-06-07 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	2022-11-08 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	2022-11-08 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	2022-11-08 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	2022-11-08 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	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	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin	Rocklin
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
filer_zip4	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765	95765
filer_phon	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822	916-297-4822
filer_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
file_email	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]
mail_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_naml	Copp	Copp	None	Copp	None	None	None	None	None	None	None	None	None	Copp	Copp	None	Copp	Copp	Copp	Copp	None	None	Copp	None	None	None	None	None	None	None	None	None	Copp	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Copp	None	None	Copp	None	Copp	Copp	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Copp	Copp	None	None	None
tres_namf	Vona L.	Vona L.	None	Vona L.	None	None	None	None	None	None	None	None	None	Vona L.	Vona L.	None	Vona L.	Vona L.	Vona L.	Vona L.	None	None	Vona L.	None	None	None	None	None	None	None	None	None	Vona L.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Vona L.	None	None	Vona L.	None	Vona L.	Vona L.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Vona L.	Vona L.	None	None	None
tres_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
tres_city	Wilton	Wilton	None	Wilton	None	None	None	None	None	None	None	None	None	Wilton	Wilton	None	Wilton	Wilton	Wilton	Wilton	None	None	Wilton	None	None	None	None	None	None	None	None	None	Wilton	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Wilton	None	None	Wilton	None	Wilton	Wilton	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Wilton	Wilton	None	None	None
tres_st	CA	CA	None	CA	None	None	None	None	None	None	None	None	None	CA	CA	None	CA	CA	CA	CA	None	None	CA	None	None	None	None	None	None	None	None	None	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	CA	None	None	CA	None	CA	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	CA	CA	None	None	None
tres_zip4	95693	95693	None	95693	None	None	None	None	None	None	None	None	None	95693	95693	None	95693	95693	95693	95693	None	None	95693	None	None	None	None	None	None	None	None	None	95693	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	95693	None	None	95693	None	95693	95693	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	95693	95693	None	None	None
tres_phon	916-686-1815	916-686-1815	None	916-686-1815	None	None	None	None	None	None	None	None	None	916-686-1815	916-686-1815	None	916-686-1815	916-686-1815	916-686-1815	916-686-1815	None	None	916-686-1815	None	None	None	None	None	None	None	None	None	916-686-1815	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	916-686-1815	None	None	916-686-1815	None	916-686-1815	916-686-1815	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	916-686-1815	916-686-1815	None	None	None
tres_fax	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
cmtte_type	None	None	None	None	None	None	None	None	None	None	None	None	None	C	None	None	None	None	None	None	None	None	C	None	None	None	None	None	None	None	None	None	C	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	C	None	None	C	None	C	C	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	C	C	None	None	None
control_yn	None	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	None	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	N	None	None	N	None	N	N	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	N	N	None	None	None
sponsor_yn	None	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	None	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	N	None	None	N	None	N	N	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	N	N	None	None	None
primfrm_yn	None	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	None	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	N	None	None	N	None	N	N	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	N	N	None	None	None
brdbase_yn	None	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	None	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	N	None	None	N	None	N	N	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	N	N	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	Amendment to add additional information received after initial filing.	None	None	None	None	None	None	None	None	None	None	None	Amendment to report information received after initial filing.	None	None	None	None	None	None	None	None	None	None	None	None	None	Amendment to add additional information received after initial filing.	None	None	Amendment to add additional information received after initial filing.	None	Amendment to add additional information received after initial filing.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Amendment to correct amount of in-kind contribution.	None	None	None	Amendment to add additional information received after initial filing.	None	None	None	None
amendexp_2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
cand_naml	None	None	None	None	None	None	None	None	None	None	None	None	None	Patterson	None	None	None	None	None	None	None	None	Patterson	None	None	None	None	None	None	None	None	None	Patterson	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Patterson	None	None	Patterson	None	Patterson	Patterson	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Patterson	Patterson	None	None	None
cand_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	Joe	None	None	None	None	None	None	None	None	Joe	None	None	None	None	None	None	None	None	None	Joe	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Joe	None	None	Joe	None	Joe	Joe	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Joe	Joe	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
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
cand_city	None	None	None	None	None	None	None	None	None	None	None	None	None	Rocklin	None	None	None	None	None	None	None	None	Rocklin	None	None	None	None	None	None	None	None	None	Rocklin	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Rocklin	None	None	Rocklin	None	Rocklin	Rocklin	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Rocklin	Rocklin	None	None	None
cand_st	None	None	None	None	None	None	None	None	None	None	None	None	None	CA	None	None	None	None	None	None	None	None	CA	None	None	None	None	None	None	None	None	None	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	CA	None	None	CA	None	CA	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	CA	CA	None	None	None
cand_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	95765	None	None	None	None	None	None	None	None	95765	None	None	None	None	None	None	None	None	None	95765	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	95765	None	None	95765	None	95765	95765	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	95765	95765	None	None	None
cand_phon	None	None	None	None	None	None	None	None	None	None	None	None	None	916-297-4822	None	None	None	None	None	None	None	None	916-297-4822	None	None	None	None	None	None	None	None	None	916-297-4822	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	916-297-4822	None	None	916-297-4822	None	916-297-4822	916-297-4822	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	916-297-4822	916-297-4822	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
cand_email	None	None	None	None	None	None	None	None	None	None	None	None	None	[email protected]	None	None	None	None	None	None	None	None	[email protected]	None	None	None	None	None	None	None	None	None	[email protected]	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	[email protected]	None	None	[email protected]	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	[email protected]	[email protected]	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
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
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
office_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	ASM	None	None	None	None	None	None	None	None	ASM	None	None	None	None	None	None	None	None	None	ASM	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	ASM	None	None	ASM	None	ASM	ASM	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	ASM	ASM	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
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
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
dist_no	None	None	None	None	None	None	None	None	None	None	None	None	None	5	None	None	None	None	None	None	None	None	5	None	None	None	None	None	None	None	None	None	5	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	5	None	None	5	None	5	5	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	5	5	None	None	None
off_s_h_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	S	None	None	None	None	None	None	None	None	S	None	None	None	None	None	None	None	None	None	S	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	S	None	None	S	None	S	S	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	S	S	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
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
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
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
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
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

Table: cvr_so
filing_id		2637542
amend_id		0
rec_type		CVR
form_type		F410
filer_id		1443381
entity_cd		RCP
filer_naml		Joe Patterson for Assembly 2022
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-01-25 00:00:00
qual_cb		X
qualfy_dt		2022-01-06 00:00:00
term_date		None
city		Rocklin
st		CA
zip4		95765
phone		916-297-4822
county_res		Placer County
county_act		Statewide
mail_city		None
mail_st		None
mail_zip4		None
cmte_fax		None
cmte_email		[email protected]
tres_naml		Copp
tres_namf		Vona L.
tres_namt		None
tres_nams		None
tres_city		Wilton
tres_st		CA
tres_zip4		95693
tres_phon		916-686-1815
actvty_lvl		None
com82013yn		None
com82013nm		None
com82013id		None
control_cb		X
bank_nam		California Bank & Trust
bank_adr1		550 South Hope Street, Ste. 100
bank_adr2		None
bank_city		Los Angeles
bank_st		CA
bank_zip4		90071
bank_phon		231-228-1709
acct_opendt		None
surplusdsp		None
primfc_cb		None
genpurp_cb		None
gpc_descr		None
sponsor_cb		None
brdbase_cb		None
smcont_qualdt		None

Table: filer_address
filer_id		1443381
adrid		2527975
effect_dt		2022-01-06 00:00:00
add_type		7051
session_id		2021

Table: filer_filings
filer_id	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381
filing_id	2656510	2665061	2685272	2686059	2691371	2640619	2692787	2666451	2633317	2687465	2665528	2673159	2669272	2670430	2693053	2680824	2678939	2691046	2681672	2681953	2663441	2668922	2664611	2673767	2684753	2689005	2689006	2689653	2659179	2657655	2658027	2692819	2707683	2658477	2711825	2659606	2678939	2662318	2660181	2712727	2662141	2636956	2679324	2719832	2725086	2678939	2723949	2724622	2710957	2714265	2693053	2695199	2711359	2717567	2677956	2637542	2722925	2717127	2695199	2692309	2714712	2687465	2715675	2673159	2718089	2712655	2722030	2720707	2713221	2713726	2732333	2735913	2740115	2744692	2749094	2726769	2726788	2752869	2731690	2707683	2726047	2739093	2739411	2728638	2726047	2743628	2730784	2734249	2736856	2730299	2739085	2751950	2726540	2750719	2741351	2730778	2752792	2741354	2734323	2739463	2738826	2728466	2752578	2752580	2740115	2736400	2738197
period_id	0	250	250	250	250	None	250	250	None	250	250	249	250	250	None	250	250	250	250	250	250	250	250	250	250	250	250	250	0	249	0	250	250	249	251	249	250	250	249	251	249	249	250	251	251	250	251	251	251	251	None	None	251	251	250	249	251	251	None	250	251	250	251	249	251	251	251	251	251	251	252	252	252	252	252	251	251	252	252	250	251	252	252	252	251	251	252	252	252	252	252	252	251	252	252	252	252	252	252	252	None	252	252	252	252	None	252
form_id	F497	F497	F497	F497	F497	F410	F497	F497	F410	F460	F497	F460	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F460	F497	F497	F497	F410	F497	F497	F460	F497	F497	F460	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F460	F497	F497	F497	F460	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F460	F497
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0
filing_date	2022-03-10 00:00:00	2022-04-11 00:00:00	2022-05-23 00:00:00	2022-05-25 00:00:00	2022-06-04 00:00:00	2022-01-27 00:00:00	2022-06-08 00:00:00	2022-04-14 00:00:00	2022-01-06 00:00:00	2022-05-26 00:00:00	2022-04-12 00:00:00	2022-04-28 00:00:00	2022-04-22 00:00:00	2022-04-25 00:00:00	2022-04-29 00:00:00	2022-05-09 00:00:00	2022-05-10 00:00:00	2022-06-03 00:00:00	2022-05-11 00:00:00	2022-05-12 00:00:00	2022-04-05 00:00:00	2022-04-21 00:00:00	2022-04-08 00:00:00	2022-04-28 00:00:00	2022-05-20 00:00:00	2022-05-31 00:00:00	2022-05-31 00:00:00	2022-06-01 00:00:00	2022-03-21 00:00:00	2022-03-15 00:00:00	2022-03-16 00:00:00	2022-06-08 00:00:00	2022-08-01 00:00:00	2022-03-18 00:00:00	2022-08-16 00:00:00	2022-03-22 00:00:00	2022-05-03 00:00:00	2022-04-01 00:00:00	2022-03-24 00:00:00	2022-08-18 00:00:00	2022-03-31 00:00:00	2022-01-24 00:00:00	2022-05-04 00:00:00	2022-09-13 00:00:00	2022-09-28 00:00:00	2022-05-17 00:00:00	2022-09-26 00:00:00	2022-09-27 00:00:00	2022-08-12 00:00:00	2022-08-24 00:00:00	2022-05-27 00:00:00	2022-08-03 00:00:00	2022-08-15 00:00:00	2022-09-06 00:00:00	2022-05-02 00:00:00	2022-01-25 00:00:00	2022-09-23 00:00:00	2022-09-02 00:00:00	2022-05-27 00:00:00	2022-06-07 00:00:00	2022-08-25 00:00:00	2022-08-01 00:00:00	2022-08-31 00:00:00	2022-05-26 00:00:00	2022-09-07 00:00:00	2022-08-18 00:00:00	2022-09-20 00:00:00	2022-09-15 00:00:00	2022-08-22 00:00:00	2022-08-23 00:00:00	2022-10-12 00:00:00	2022-10-18 00:00:00	2022-10-24 00:00:00	2022-10-27 00:00:00	2022-10-31 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-11-06 00:00:00	2022-10-12 00:00:00	2022-09-29 00:00:00	2022-09-29 00:00:00	2022-10-21 00:00:00	2022-10-23 00:00:00	2022-10-04 00:00:00	2022-10-27 00:00:00	2022-10-27 00:00:00	2022-10-10 00:00:00	2022-10-14 00:00:00	2022-10-19 00:00:00	2022-10-07 00:00:00	2022-10-21 00:00:00	2022-11-03 00:00:00	2022-09-29 00:00:00	2022-11-01 00:00:00	2022-10-25 00:00:00	2022-10-10 00:00:00	2022-11-05 00:00:00	2022-10-25 00:00:00	2022-10-14 00:00:00	2022-10-23 00:00:00	2022-09-30 00:00:00	2022-10-04 00:00:00	2022-11-04 00:00:00	2022-11-04 00:00:00	2022-11-11 00:00:00	2022-08-03 00:00:00	2022-10-20 00:00:00
stmnt_type	10001	10001	10001	10001	10001	10006	10001	10001	10005	10001	10001	10001	10001	10001	10005	10001	10002	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10002	10001	10001	10001	10001	10006	10006	10001	10001	10001	10001	10001	10001	10005	10001	10001	10002	10001	10002	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10002	10001	10001	10001	10001	10002	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10002	10005	10001
stmnt_status	11003	11003	11003	11003	11003	11001	11003	11003	11001	11003	11003	11001	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
session_id	1899	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	1899	2021	1899	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021
user_id	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	IMEDINA	CAFILER	CAFILER	DCODY	CAFILER	CAFILER	KRUSSELL	CAFILER	CAFILER	KRUSSELL	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	RGEREMIA	RGEREMIA	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	RGEREMIA	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	JMAVES	JMAVES	CAFILER	CAFILER	CAFILER	IMEDINA	CAFILER	CAFILER	JMAVES	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	CAFILER	RGEREMIA	CAFILER	CAFILER	CAFILER	CAFILER	HCOURSEY	CAFILER
special_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	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	1900-01-01 00:00:00	2022-04-11 00:00:00	2022-05-23 00:00:00	2022-05-25 00:00:00	2022-06-04 00:00:00	None	2022-06-08 00:00:00	2022-04-14 00:00:00	None	2022-04-24 00:00:00	2022-04-12 00:00:00	2022-01-01 00:00:00	2022-04-22 00:00:00	2022-04-25 00:00:00	2022-01-01 00:00:00	2022-05-09 00:00:00	2022-05-10 00:00:00	2022-06-03 00:00:00	2022-05-11 00:00:00	2022-05-12 00:00:00	2022-04-05 00:00:00	2022-04-21 00:00:00	2022-04-08 00:00:00	2022-04-28 00:00:00	2022-05-20 00:00:00	2022-05-31 00:00:00	2022-05-31 00:00:00	2022-06-01 00:00:00	1900-01-01 00:00:00	2022-03-15 00:00:00	1900-01-01 00:00:00	2022-06-08 00:00:00	2022-05-22 00:00:00	2022-03-18 00:00:00	2022-08-16 00:00:00	2022-03-22 00:00:00	2022-05-03 00:00:00	2022-04-01 00:00:00	2022-03-24 00:00:00	2022-08-18 00:00:00	2022-03-31 00:00:00	2022-01-24 00:00:00	2022-05-04 00:00:00	2022-09-13 00:00:00	2022-09-28 00:00:00	2022-05-17 00:00:00	2022-09-26 00:00:00	2022-09-27 00:00:00	2022-08-12 00:00:00	2022-08-24 00:00:00	2022-01-01 00:00:00	2022-04-24 00:00:00	2022-08-15 00:00:00	2022-09-06 00:00:00	2022-05-02 00:00:00	2022-01-25 00:00:00	2022-09-23 00:00:00	2022-09-02 00:00:00	2022-04-24 00:00:00	2022-06-07 00:00:00	2022-08-25 00:00:00	2022-04-24 00:00:00	2022-08-29 00:00:00	2022-01-01 00:00:00	2022-09-07 00:00:00	2022-08-18 00:00:00	2022-09-20 00:00:00	2022-09-15 00:00:00	2022-08-22 00:00:00	2022-08-23 00:00:00	2022-10-12 00:00:00	2022-10-18 00:00:00	2022-10-24 00:00:00	2022-10-27 00:00:00	2022-10-31 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-11-06 00:00:00	2022-10-12 00:00:00	2022-05-22 00:00:00	2022-07-01 00:00:00	2022-10-21 00:00:00	2022-10-23 00:00:00	2022-10-04 00:00:00	2022-07-01 00:00:00	2022-09-25 00:00:00	2022-10-10 00:00:00	2022-10-14 00:00:00	2022-10-19 00:00:00	2022-10-07 00:00:00	2022-10-21 00:00:00	2022-11-03 00:00:00	2022-09-29 00:00:00	2022-11-01 00:00:00	2022-10-25 00:00:00	2022-10-10 00:00:00	2022-11-05 00:00:00	2022-10-25 00:00:00	2022-10-14 00:00:00	2022-10-23 00:00:00	2022-07-01 00:00:00	2022-10-04 00:00:00	2022-11-04 00:00:00	2022-11-04 00:00:00	2022-11-11 00:00:00	2022-05-22 00:00:00	2022-10-20 00:00:00
rpt_end	1900-01-01 00:00:00	2022-04-11 00:00:00	2022-05-23 00:00:00	2022-05-25 00:00:00	2022-06-04 00:00:00	None	2022-06-08 00:00:00	2022-04-14 00:00:00	None	2022-05-21 00:00:00	2022-04-12 00:00:00	2022-04-23 00:00:00	2022-04-22 00:00:00	2022-04-25 00:00:00	2022-04-23 00:00:00	2022-05-09 00:00:00	2022-05-10 00:00:00	2022-06-03 00:00:00	2022-05-11 00:00:00	2022-05-12 00:00:00	2022-04-05 00:00:00	2022-04-21 00:00:00	2022-04-08 00:00:00	2022-04-28 00:00:00	2022-05-20 00:00:00	2022-05-31 00:00:00	2022-05-31 00:00:00	2022-06-01 00:00:00	1900-01-01 00:00:00	2022-03-15 00:00:00	1900-01-01 00:00:00	2022-06-08 00:00:00	2022-06-30 00:00:00	2022-03-18 00:00:00	2022-08-16 00:00:00	2022-03-22 00:00:00	2022-05-03 00:00:00	2022-04-01 00:00:00	2022-03-24 00:00:00	2022-08-18 00:00:00	2022-03-31 00:00:00	2022-01-24 00:00:00	2022-05-04 00:00:00	2022-09-13 00:00:00	2022-09-28 00:00:00	2022-05-17 00:00:00	2022-09-26 00:00:00	2022-09-27 00:00:00	2022-08-12 00:00:00	2022-08-24 00:00:00	2022-04-23 00:00:00	2022-05-21 00:00:00	2022-08-15 00:00:00	2022-09-06 00:00:00	2022-05-02 00:00:00	2022-01-25 00:00:00	2022-09-23 00:00:00	2022-09-02 00:00:00	2022-05-21 00:00:00	2022-06-07 00:00:00	2022-08-25 00:00:00	2022-05-21 00:00:00	2022-08-29 00:00:00	2022-04-23 00:00:00	2022-09-07 00:00:00	2022-08-18 00:00:00	2022-09-20 00:00:00	2022-09-15 00:00:00	2022-08-22 00:00:00	2022-08-23 00:00:00	2022-10-12 00:00:00	2022-10-18 00:00:00	2022-10-24 00:00:00	2022-10-27 00:00:00	2022-10-31 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-11-06 00:00:00	2022-10-12 00:00:00	2022-06-30 00:00:00	2022-09-24 00:00:00	2022-10-21 00:00:00	2022-10-23 00:00:00	2022-10-04 00:00:00	2022-09-24 00:00:00	2022-10-22 00:00:00	2022-10-10 00:00:00	2022-10-14 00:00:00	2022-10-19 00:00:00	2022-10-07 00:00:00	2022-10-21 00:00:00	2022-11-03 00:00:00	2022-09-29 00:00:00	2022-11-01 00:00:00	2022-10-25 00:00:00	2022-10-10 00:00:00	2022-11-05 00:00:00	2022-10-25 00:00:00	2022-10-14 00:00:00	2022-10-23 00:00:00	2022-09-24 00:00:00	2022-10-04 00:00:00	2022-11-04 00:00:00	2022-11-04 00:00:00	2022-11-11 00:00:00	2022-06-30 00:00:00	2022-10-20 00:00:00
rpt_date	1900-01-01 00:00:00	2022-04-11 00:00:00	2022-05-23 00:00:00	2022-05-25 00:00:00	2022-06-04 00:00:00	None	2022-06-08 00:00:00	2022-04-14 00:00:00	None	2022-05-26 00:00:00	2022-04-12 00:00:00	2022-04-28 00:00:00	2022-04-22 00:00:00	2022-04-25 00:00:00	None	2022-05-09 00:00:00	2022-05-10 00:00:00	2022-06-03 00:00:00	2022-05-11 00:00:00	2022-05-12 00:00:00	2022-04-05 00:00:00	2022-04-21 00:00:00	2022-04-08 00:00:00	2022-04-28 00:00:00	2022-05-20 00:00:00	2022-05-31 00:00:00	2022-05-31 00:00:00	2022-06-01 00:00:00	1900-01-01 00:00:00	2022-03-15 00:00:00	1900-01-01 00:00:00	2022-06-08 00:00:00	2022-07-14 00:00:00	2022-03-18 00:00:00	2022-08-16 00:00:00	2022-03-22 00:00:00	2022-05-03 00:00:00	2022-04-01 00:00:00	2022-03-24 00:00:00	2022-08-18 00:00:00	2022-03-31 00:00:00	2022-01-24 00:00:00	2022-05-04 00:00:00	2022-09-13 00:00:00	2022-09-28 00:00:00	2022-05-17 00:00:00	2022-09-26 00:00:00	2022-09-27 00:00:00	2022-08-12 00:00:00	2022-08-24 00:00:00	None	None	2022-08-15 00:00:00	2022-09-06 00:00:00	2022-05-02 00:00:00	None	2022-09-23 00:00:00	2022-09-02 00:00:00	None	2022-06-07 00:00:00	2022-08-25 00:00:00	2022-07-14 00:00:00	2022-08-29 00:00:00	2022-05-24 00:00:00	2022-09-07 00:00:00	2022-08-18 00:00:00	2022-09-20 00:00:00	2022-09-15 00:00:00	2022-08-22 00:00:00	2022-08-23 00:00:00	2022-10-12 00:00:00	2022-10-18 00:00:00	2022-10-24 00:00:00	2022-10-27 00:00:00	2022-10-31 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-11-06 00:00:00	2022-10-12 00:00:00	2022-09-29 00:00:00	2022-09-29 00:00:00	2022-10-21 00:00:00	2022-10-23 00:00:00	2022-10-04 00:00:00	2022-10-23 00:00:00	2022-10-27 00:00:00	2022-10-10 00:00:00	2022-10-14 00:00:00	2022-10-19 00:00:00	2022-10-07 00:00:00	2022-10-21 00:00:00	2022-11-03 00:00:00	2022-09-29 00:00:00	2022-11-01 00:00:00	2022-10-25 00:00:00	2022-10-10 00:00:00	2022-11-05 00:00:00	2022-10-25 00:00:00	2022-10-14 00:00:00	2022-10-23 00:00:00	None	2022-10-04 00:00:00	2022-11-04 00:00:00	2022-11-04 00:00:00	2022-11-11 00:00:00	None	2022-10-20 00:00:00
filing_type	22001	22001	22001	22001	22001	None	22001	22001	None	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	None	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	None	22001

Table: filer_to_filer_type
filer_id	1443381	1443381
filer_type	16	16
active	Y	Y
race	0	0
session_id	2021	2021
category	40002	40002
category_type	40502	40502
sub_category	0	0
effect_dt	2022-01-06 00:00:00	2022-01-27 00:00:00
sub_category_type	0	0
election_type	0	0
sub_category_a	None	None
nyq_dt	None	2022-01-06 00:00:00
party_cd	16002	16002
county_cd	18037	18037
district_cd	0	0

Table: filer_xref
filer_id		1443381
xref_id		1443381
effect_dt		2022-01-07 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id		1443381
filer_id		1443381
filer_type		RECIPIENT COMMITTEE
status		ACTIVE
effect_dt		2022-01-27 00:00:00
naml		PATTERSON FOR ASSEMBLY 2022; JOE
namf		None
namt		None
nams		None
adr1		None
adr2		None
city		ROCKLIN
st		CA
zip4		95765
phon		9162974822
fax		None
email		[email protected]

Table: filers
filer_id		1443381

Table: received_filings
filer_id	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381	1443381
filing_file_name	2665061_0.cal	2691371_0.cal	2666451_0.cal	2734323_0.cal	123846.cal	2712655_0.cal	2663441_0.cal	2664611_0.cal	2719832_0.cal	307870.cal	2673767_0.cal	2741351_0.cal	2741354_0.cal	2680824_0.cal	2678939_1.cal	2684753_0.cal	2681953_0.cal	2714265_0.cal	2726788_0.cal	2738197_0.cal	139947.cal	2659179_0.cal	2728638_0.cal	2678939_0.cal	2689005_0.cal	2689006_0.cal	2739463_0.cal	2689653_0.cal	2692819_0.cal	2710957_0.cal	2662141_0.cal	2731690_0.cal	2735913_0.cal	2730784_0.cal	2739093_0.cal	2739411_0.cal	9275.cal	2677956_0.cal	2732333_0.cal	2717127_0.cal	2724622_0.cal	2752578_0.cal	2752580_0.cal	2752792_0.cal	2685272_0.cal	2686059_0.cal	2711825_0.cal	2656510_0.cal	2665528_0.cal	2750719_0.cal	2669272_0.cal	2670430_0.cal	2692787_0.cal	2717567_0.cal	2726540_0.cal	2736856_0.cal	2668922_0.cal	2752869_0.cal	2681672_0.cal	2740115_1.cal	2691046_0.cal	2718089_0.cal	2722030_0.cal	2740115_0.cal	2744692_0.cal	2730299_0.cal	2657655_0.cal	2658027_0.cal	2658477_0.cal	2659606_0.cal	2662318_0.cal	2714712_0.cal	2636956_0.cal	2713221_0.cal	2660181_0.cal	2739085_0.cal	2678939_2.cal	2692309_0.cal	2711359_0.cal	2712727_0.cal	2713726_0.cal	2715675_0.cal	2730778_0.cal	2725086_0.cal	2751950_0.cal	2720707_0.cal	2722925_0.cal	2723949_0.cal
received_date	2022-04-11 00:00:00	2022-06-04 00:00:00	2022-04-14 00:00:00	2022-10-14 00:00:00	2022-04-12 00:00:00	2022-08-18 00:00:00	2022-04-05 00:00:00	2022-04-08 00:00:00	2022-09-13 00:00:00	2022-09-13 00:00:00	2022-04-28 00:00:00	2022-10-25 00:00:00	2022-10-25 00:00:00	2022-05-09 00:00:00	2022-05-10 00:00:00	2022-05-20 00:00:00	2022-05-12 00:00:00	2022-08-24 00:00:00	2022-09-30 00:00:00	2022-10-20 00:00:00	2022-09-29 00:00:00	2022-03-21 00:00:00	2022-10-04 00:00:00	2022-05-03 00:00:00	2022-05-31 00:00:00	2022-05-31 00:00:00	2022-10-23 00:00:00	2022-06-01 00:00:00	2022-06-08 00:00:00	2022-08-12 00:00:00	2022-03-31 00:00:00	2022-10-12 00:00:00	2022-10-18 00:00:00	2022-10-10 00:00:00	2022-10-21 00:00:00	2022-10-23 00:00:00	2022-03-15 00:00:00	2022-05-02 00:00:00	2022-10-12 00:00:00	2022-09-02 00:00:00	2022-09-27 00:00:00	2022-11-04 00:00:00	2022-11-04 00:00:00	2022-11-05 00:00:00	2022-05-23 00:00:00	2022-05-25 00:00:00	2022-08-16 00:00:00	2022-03-10 00:00:00	2022-04-12 00:00:00	2022-11-01 00:00:00	2022-04-22 00:00:00	2022-04-25 00:00:00	2022-06-08 00:00:00	2022-09-06 00:00:00	2022-09-29 00:00:00	2022-10-19 00:00:00	2022-04-21 00:00:00	2022-11-06 00:00:00	2022-05-11 00:00:00	2022-11-11 00:00:00	2022-06-03 00:00:00	2022-09-07 00:00:00	2022-09-20 00:00:00	2022-10-24 00:00:00	2022-10-27 00:00:00	2022-10-07 00:00:00	2022-03-15 00:00:00	2022-03-16 00:00:00	2022-03-18 00:00:00	2022-03-22 00:00:00	2022-04-01 00:00:00	2022-08-25 00:00:00	2022-01-24 00:00:00	2022-08-22 00:00:00	2022-03-24 00:00:00	2022-10-21 00:00:00	2022-05-17 00:00:00	2022-06-07 00:00:00	2022-08-15 00:00:00	2022-08-18 00:00:00	2022-08-23 00:00:00	2022-08-31 00:00:00	2022-10-10 00:00:00	2022-09-28 00:00:00	2022-11-03 00:00:00	2022-09-15 00:00:00	2022-09-23 00:00:00	2022-09-26 00:00:00
filing_directory	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/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/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/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/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal
filing_id	2665061	2691371	2666451	2734323	None	2712655	2663441	2664611	2719832	None	2673767	2741351	2741354	2680824	2678939	2684753	2681953	2714265	2726788	2738197	None	2659179	2728638	2678939	2689005	2689006	2739463	2689653	2692819	2710957	2662141	2731690	2735913	2730784	2739093	2739411	None	2677956	2732333	2717127	2724622	2752578	2752580	2752792	2685272	2686059	2711825	2656510	2665528	2750719	2669272	2670430	2692787	2717567	2726540	2736856	2668922	2752869	2681672	2740115	2691046	2718089	2722030	2740115	2744692	2730299	2657655	2658027	2658477	2659606	2662318	2714712	2636956	2713221	2660181	2739085	2678939	2692309	2711359	2712727	2713726	2715675	2730778	2725086	2751950	2720707	2722925	2723949
form_id	F497	F497	F497	F497	None	F497	F497	F497	F497	None	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	None	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497
receive_comment	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	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 passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted