OpenCalAccess

Filing ID: 2743947

PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2743947&amendid=0

Table: cvr3_verification_info
filing_id		2743947
amend_id		0
line_item		1
rec_type		CVR3
form_type		F401
tran_id		VER_1.1
entity_cd		TRE
sig_date		2022-10-27 00:00:00
sig_loc		Sacramento, CA
sig_naml		Shawnda Deane
sig_namf		None
sig_namt		None
sig_nams		None

Table: cvr_campaign_disclosure
filing_id		2743947
amend_id		0
rec_type		CVR
form_type		F401
filer_id		599014
entity_cd		SMO
filer_naml		COPS VOTER GUIDE, Inc.
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-26 00:00:00
stmt_type		None
late_rptno		None
from_date		2022-09-25 00:00:00
thru_date		2022-10-22 00:00:00
elect_date		None
filer_city		Sacramento
filer_st		CA
filer_zip4		95815
filer_phon		9164855888
filer_fax		None
file_email		None
mail_city		Sacramento
mail_st		CA
mail_zip4		95821
tres_naml		Deane
tres_namf		Shawnda
tres_namt		None
tres_nams		None
tres_city		Sacramento
tres_st		CA
tres_zip4		95815
tres_phon		9162855733
tres_fax		None
tres_email		None
cmtte_type		None
control_yn		None
sponsor_yn		None
primfrm_yn		None
brdbase_yn		None
amendexp_1		None
amendexp_2		None
amendexp_3		None
rpt_att_cb		None
cmtte_id		None
reportname		None
rptfromdt		None
rptthrudt		None
emplbus_cb		None
bus_name		None
bus_city		None
bus_st		None
bus_zip4		None
bus_inter		None
busact_cb		None
busactvity		None
assoc_cb		None
assoc_int		None
other_cb		None
other_int		None
cand_naml		None
cand_namf		None
cand_namt		None
cand_nams		None
cand_city		None
cand_st		None
cand_zip4		None
cand_phon		None
cand_fax		None
cand_email		None
bal_name		None
bal_num		None
bal_juris		None
office_cd		None
offic_dscr		None
juris_cd		None
juris_dscr		None
dist_no		None
off_s_h_cd		None
sup_opp_cd		None
employer		None
occupation		None
selfemp_cb		None
bal_id		None
cand_id		None

Table: filer_filings
filer_id		1016559
filing_id		2743947
period_id		251
form_id		F401
filing_sequence		0
filing_date		2022-10-27 00:00:00
stmnt_type		10001
stmnt_status		11003
session_id		2021
user_id		CAFILER
special_audit		11003
fine_audit		11003
rpt_start		2022-09-25 00:00:00
rpt_end		2022-10-22 00:00:00
rpt_date		2022-10-26 00:00:00
filing_type		22001

Table: filings
filing_id		2743947
filing_type		22001

Table: hdr
filing_id		2743947
amend_id		0
rec_type		HDR
ef_type		CAL
state_cd		CA
cal_ver		2.01
soft_name		NETFILE
soft_ver		199332
hdrcomment		None

Table: rcpt
filing_id	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947
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	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
line_item	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60	61	62	63	64	65	66	67	68	69	70	71	72	73	74	75	76	77	78	79	80	81	82	83	84	85	86	87	88	89	90	91	92	93	94	95	96	97	98	99	100	101	102	103	104	105	106	107	108	109	110	111	112	113	114	115	116	117	118	119	120	121	122	123	124	125	126	127	128	129	130	131	132	133	134	135	136	137	138	139	140	141	142	143	144	145	146	147	148	149	150	151	152	153
rec_type	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT
form_type	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A	F401A
tran_id	INC8610	INC8632	INC8608	INC8587	INC8607	INC8643	INC8644	INC8645	INC8659	INC8641	INC8642	INC8660	INC8640	INC8661	INC8614	INC8620	IDT1570	IDT1569	INC8617	INC8594	INC8618	INC8621	IDT1558	INC8595	INC8615	INC8648	IDT1579	INC8619	INC8616	IDT1557	INC8646	INC8593	IDT1559	IDT1560	IDT1606	IDT1605	IDT1561	IDT1601	INC8711	INC8652	INC8686	INC8688	INC8692	INC8690	INC8680	INC8681	IDT1607	INC8682	IDT1580	INC8654	INC8685	INC8655	INC8656	INC8684	INC8650	INC8683	INC8649	INC8600	INC8687	IDT1603	IDT1602	INC8657	INC8658	INC8604	INC8606	INC8729	IDT1562	IDT1563	IDT1566	IDT1564	IDT1565	IDT1609	IDT1587	IDT1608	IDT1584	IDT1598	IDT1585	IDT1600	IDT1599	IDT1597	IDT1567	IDT1592	IDT1588	IDT1594	IDT1591	IDT1595	IDT1589	IDT1590	IDT1596	IDT1586	IDT1593	INC8623	INC8629	IDT1574	IDT1571	IDT1572	IDT1573	IDT1610	INC8627	INC8624	IDT1578	IDT1576	IDT1575	IDT1577	IDT1568	INC8730	INC8625	INC8626	INC8631	IDT1581	IDT1582	IDT1583	INC8666	INC8669	INC8670	INC8672	INC8671	INC8663	INC8674	INC8736	IDT1615	IDT1614	INC8662	INC8665	INC8668	INC8738	INC8673	INC8664	IDT1612	IDT1611	IDT1613	IDT1618	INC8734	INC8697	INC8704	INC8707	INC8745	INC8709	INC8705	INC8706	IDT1604	INC8703	INC8741	INC8742	INC8722	INC8744	INC8723	IDT1617	INC8746	IDT1620	IDT1621	IDT1619	INC8752
entity_cd	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	OTH	OTH	COM	COM	COM	COM	COM	COM	COM	COM	OTH	COM	COM	OTH	COM	COM	COM	COM	OTH	OTH	OTH	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	OTH	COM	COM	COM	COM	COM	COM	OTH	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	OTH	OTH	COM	COM	COM	COM	COM	COM	OTH	OTH	OTH	OTH	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	COM	OTH	COM	COM	OTH	COM	COM
ctrib_naml	Fred Sykes for City Council 2022	Leanne Linares for City Council 2022	Stephen Sham for City Council 2022	Steve Elie for Water Board 2022	Ancona for Mayor 2022	Dr. Thusu for Dinuba City Council Ward 4 2022	Elizabeth Wiktor for Council District 1 2022	McKeeman for School Board 2022	Alex Hirsch West Sacramento City Council 2022	Friends of Jayna Karpinski-Costa Citrus Heights City Council 2022	Gilbert Felix for State Center Community College District Trustee Area 5 2022	Janet Rivera for Delta Trustee, Area 3, 2022	Mary Rocha for Antioch School Board 2022	Moorlach for Mayor 2022	Art Chacon for Water Board 2022	Brenda Estada for Buena Park School District Board of Trustees, Area 4, 2022	California Homeowners Association	California Homeowners Association	Campbell for San Juan Capistrano District 3 2022	Diane Pearce for Clovis City Council 2022	Howell for City Council 2022	Kevin Kreowski Pismo Beach City Council 2022	Neighbors United to Re-Elect Councilmember Mitch O'Farrell 2022	Paula Villescaz for Senate 2022	Re-Elect Jan Harnik for Palm Desert City Council 2022	Sanford for City Council 2022	Uplift Plus Empower, LLC	Wanda Wiliams for Solano County Supervisor 2022	We Love La Quinta: Vote No on Measure A	Wheelhouse Strategies, LLC	Amrik Wander for Tracy City Council 2022	Cheryl Turner for Senate 2022	1962 PAC of the Lincoln Club of Orange County	1962 PAC of the Lincoln Club of Orange County	3AM Communications	3AM Communications	Chris Jones Consulting	Chris Mann for Water Board 2024	Chris Venable for Yucaipa City Council 2022	Christian Shaughnessy for Board of Trustees Area 4 2022	Committee to Re-Elect Elaine Holmes for Indio City Council 2022	Curtis Burton for Chino City Council, District 2, 2022	David VanGorden for City Council 2022	Floyd Clark for City Council 2022	Friends of Brakeman for KHSD	Friends of David Toro for Colton City Council District 1 2022	High Desert Jobs PAC	Ingle for School Board 2022	Inland Empire Taxpayers Association	Jack Zwald for Cordova Recreation and Park District 2022	Jeff Wang for Union City City Councilor District 3 2022	Jennifer Laret for Folsom Cordova School Board 2022	Jim Penman for Mayor, 2022, City of San Bernardino	Lena Tam for Alameda County Supervisor 2022	Londa Lamb for YCUSD Trustee Area 1, 2022	Mary Ann Reiss for City Council 2022	Mony Nop for Mayor 2022	Re-Elect Dan McAllister Treasurer 2022	Reynoso for Council 2022	Santa Monicans for Change	Santa Monicans for Change	Shaunna Elias for School Board 2022	Stephanie McKenzie for City Council 2022	Debora Allen for Supervisor 2022	Leonard Mendoza for Water Board District 3	Paul Marsh for Assembly 2022	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Riverside Sheriff's Association Public Education Fund	Bob Archuleta for Senate 2022	Carol Kwan for West Basin Water Board 2022	Coalition for L.A. Community College Reform, Sponsored by Los Angeles College Faculty Guild Local 1521	Coalition for L.A. Community College Reform, Sponsored by Los Angeles College Faculty Guild Local 1521	Coalition for L.A. Community College Reform, Sponsored by Los Angeles College Faculty Guild Local 1521	Coalition for L.A. Community College Reform, Sponsored by Los Angeles College Faculty Guild Local 1521	CrossCurrents, LLC	Janice Parvin for Supervisor 2022	Leticia Perez for Assembly 2022	Lincoln Club of Orange County	Lincoln Club of Orange County	Lincoln Club of Orange County	Lincoln Club of Orange County	Los Angeles/Orange Counties Building & Construction Trades Council	Michelle Kile for Elk Grove City Council 2022	Re-Elect Harold Williams to Water Board 2022	Sergio Calderon for Water Board Director 2022	Karen Brako for Superior Court Judge 2022	1962 PAC of the Lincoln Club of Orange County	1962 PAC of the Lincoln Club of Orange County	1962 PAC of the Lincoln Club of Orange County	Cetina for Supervisor 2022	Citizens for a Better Sutter County	Friends fo Tiffany Saathoff for Rocklin School Board 2022	Holman for Supervisor 2022	Marc Boomgaarden for Yuba City Council 2022	Melissa Hammond for Judge 2022	Mike Pasquale for Yuba City Council 2022	Nava for Chico City Council 2022	Para Bellum Strategies	Reilly Consulting	Renee Chang for Judge 2022	Rick Caruso for Mayor 2022 General	Simon Moon for Mayor 2022	South El Monte Action Committee to Elect Rudy Bojorquez to City Council 2022	Valerie Amezcua for Mayor 2022	Yes on Measure LA Committee for Quality Education & Student Success	CrossCurrents, LLC	CrossCurrents, LLC	Lewis and Company	Lewis and Company	Lizet Angulo for City Council 2022	Matt Basgall for Clovis City Council 2022	Damon Connolly for Assembly 2022	Dave Shaw for Yuba City Council 2022	Friends of Fred Docdocil for Carson City Council 2022	Juan Alanis for Assembly 2022	Stoker for Assembly 2022	Tennessen 4 Camarillo City Council District 1, 2022	The Community Leadership Coalition, Sponsored by the Lincoln Club of San Diego County	Thurston 'Smitty' Smith for Assembly 2022	Cindy Wu for School Board 2022	Daniel Langan for Cordova Recreation and Parks District 2022	No On 30	The Laguna Alliance, No on Measures Q and R; Committee Major Funding From Laguna Beach Company	Yes on 28 - Californians for Arts and Music in Schools	CrossCurrents, LLC	Friends of Fred Docdocil for Carson City Council 2022	Essential Workers in Support of Price, Cedillo, Good & Yaroslavsky for Council 2022	Gateway Media	Long Beach Police Officers Association IEC	Paul Seo for RPV City Council 2022
ctrib_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ctrib_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ctrib_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ctrib_city	West Covina	West Sacramento	Alhambra	Covina	El Monte	Dinuba	Stanton	Imperial Beach	West Sacramento	Citrus Heights	Fresno	Stockton	Antioch	Irvine	Long Beach	Buena Park	Hilmar	Hilmar	San Juan Capistrano	Fresno	Pismo Beach	Pismo Beach	San Francisco	Sacramento	Indian Wells	Hawthorne	Fontana	Suisun City	Riverside	Roseville	Tracy	Los Angeles	Irvine	Irvine	Manteca	Manteca	Newcastle	Yucaipa	Yucaipa	Redlands	Indio	Grand Terrace	Grand Terrace	Grand Terrace	Bakersfield	Colton	Santa Ana	Tustin	Riverside	Hilmar	Union City	Hilmar	San Bernardino	Alameda	Yuba City	Pismo Beach	Livermore	Encinitas	Hawthorne	Santa Monica	Santa Monica	Riverside	Marysville	Pittsburg	Commerce	Victorville	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Inglewood	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Morgan Hill	Moorpark	Sacramento	Irvine	Irvine	Irvine	Irvine	Los Angeles	Elk Grove	Inglewood	Inglewood	Long Beach	Irvine	Irvine	Irvine	Irvine	Yuba City	Rocklin	Stockton	Yuba City	Covina	Yuba City	Chico	Santa Ana	Sacramento	Norwalk	San Rafael	Riverside	South El Monte	Long Beach	Los Angeles	Morgan Hill	Morgan Hill	West Covina	West Covina	Victorville	Clovis	Oakland	Yuba City	Carson	Modesto	Sant Maria	Camarillo	San Diego	W. Sacramento	Norwalk	Hilmar	Sacramento	San Rafael	Sacramento	Morgan Hill	Carson	Los Angeles	Sacramento	Sacramento	Long Beach
ctrib_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
ctrib_zip4	91792	95691	91801	91722	91732	93618	90680	91932	95691	95610	93704	95207	94509	92618	90802	90621	95324	95324	92675	93710	93449	93449	94108	95815	92210	90250	92336	94585	92501	95661	95377	90071	92618	92618	95337	95337	95658	92399	92399	92373	92201	92313	92313	92313	93312	92324	92704	92780	92501	95324	94587	95324	92404	94501	95993	93449	94550	92024	90250	90405	90405	92501	95901	94565	90040	92392	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	90301	90071	90017	90017	90017	90017	95037	93021	95815	92618	92618	92618	92618	90026	95624	90301	90301	90802	92618	92618	92618	92618	95993	95765	95209	95993	91722	95991	95928	92705	95864	90650	94901	92501	91733	90802	90017	95037	95037	91791	91791	92392	93612	94607	95993	90749	95355	93455	93010	92119	95691	90650	95324	95814	94901	95814	95037	90749	90017	95814	95814	90802
ctrib_emp	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ctrib_occ	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ctrib_self	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tran_type	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rcpt_date	2022-09-27 00:00:00	2022-09-27 00:00:00	2022-09-27 00:00:00	2022-09-27 00:00:00	2022-09-28 00:00:00	2022-09-28 00:00:00	2022-09-28 00:00:00	2022-09-28 00:00:00	2022-09-29 00:00:00	2022-09-29 00:00:00	2022-09-29 00:00:00	2022-09-29 00:00:00	2022-09-29 00:00:00	2022-09-29 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-10-01 00:00:00	2022-10-01 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-03 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-04 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-06 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-07 00:00:00	2022-10-08 00:00:00	2022-10-08 00:00:00	2022-10-08 00:00:00	2022-10-08 00:00:00	2022-10-08 00:00:00	2022-10-10 00:00:00	2022-10-11 00:00:00	2022-10-11 00:00:00	2022-10-11 00:00:00	2022-10-11 00:00:00	2022-10-11 00:00:00	2022-10-11 00:00:00	2022-10-11 00:00:00	2022-10-11 00:00:00	2022-10-14 00:00:00	2022-10-14 00:00:00	2022-10-14 00:00:00	2022-10-14 00:00:00	2022-10-17 00:00:00	2022-10-18 00:00:00	2022-10-18 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00
date_thru	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
amount	445	308	367	2659	810	250	250	387	322	340	1337	1500	478	2559	934	300	1453	600	400	3732	440	440	6631	12671	1574	1228	350	1147	1176	4035	1284	3000	4051	4051	460	460	5000	322	300	1300	400	400	1023	1592	1400	300	526	850	400	458	325	422	1959	2063	375	440	2256	7612	1228	2275	2275	400	300	3496	3210	1000	9278	13418	11592	4226	10928	2036	608	717	538	513	662	793	225	6199	15615	226	123	179	545	300	342	2078	15615	744	358	9089	1920	14838	14838	14838	14838	477	3683	5899	1408	1408	1408	1408	15000	500	3072	5369	10000	8900	310	339	3840	1394	1265	1000	305	10000	300	400	1209	573	10000	51249	5064	400	2601	14838	1250	853	835	400	438	3732	3309	300	-580	500	2000	476	1500	4500	408	462	25000	650	15000	3468	580	4492	6000	7051	1021
cum_ytd	445	308	367	2659	1620	250	250	387	322	340	1337	1500	478	2559	934	300	1453	600	400	3732	440	440	6631	22112	1574	1228	350	1147	1176	4035	2568	5000	4051	4051	460	460	5000	322	300	1300	400	400	1023	1592	1400	300	526	850	400	458	325	422	1959	4239	375	440	2256	7612	1228	2275	2275	400	300	6120	3210	1000	16327	25235	17084	8452	20390	2036	964	717	538	513	662	1413	225	11693	34815	226	123	179	545	300	342	2078	23115	744	358	16089	1920	14838	14838	14838	14838	477	7471	5899	1408	1408	1408	1408	15000	500	3072	5369	10000	15701	310	339	14372	1394	1265	1000	305	18000	300	400	1209	573	18000	51249	5064	400	2601	14838	1250	853	835	400	438	3732	3309	300	580	500	2000	476	1500	12495	408	462	25000	650	15000	3468	580	7492	6000	12152	1021
cum_oth	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ctrib_dscr	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cmte_id	1448955	1451499	1450791	1444549	1440716	1453514	1454059	1449644	1450640	1449929	1441511	1454877	1408329	1451893	1445676	1452379	1302564	1302564	1453193	1451770	1442035	Pending	1445063	1443351	1322067	1445104	None	1444004	1447319	None	1447789	1416707	1443925	1443925	None	None	None	1389579	1453776	1450208	1326729	1446049	1453145	1453040	1407537	1453045	1394482	1453930	1285841	1446151	1441633	1452597	1440986	1443576	1453183	1448910	1447965	1415771	1447757	1434357	1434357	1448028	1454106	1442964	1455481	1450019	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1286381	1414156	1452345	1315215	1315215	1315215	1315215	None	1440233	1443584	970861	970861	970861	970861	None	1451820	1395290	1361817	1443130	1443925	1443925	1443925	1435881	1454343	1447189	1443080	1450592	1442474	1450726	1450173	None	None	1443154	1449192	1451073	1448856	1447710	1452899	None	None	None	None	1443488	1449851	1441976	1450553	1451710	1445119	1446083	1452780	1413079	1435453	143069	1452934	1450340	1455537	1442974	None	1451710	1446040	None	1264154	1445313
tres_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
intr_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
intr_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
intr_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
intr_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
intr_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
intr_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
intr_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
intr_emp	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
intr_occ	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
intr_self	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	Fred Sykes	Leanne Linares	Stephen Sham	Steve Elie	Jessica Ancona	Dr. Kuldip Thusu	Elizabeth Wiktor	Sharon McKeeman	Alex Hirsch	Jayna Karpinski-Costa	Gilbert Felix	Janet Rivera	Mary Rocha	John Morlach	Art Chacon	Brenda Estrada	Mark Murphy	Denis Bilodeau	John Campbell	Diane Pearce	Erik Howell	Kevin Kreowski	Mitch O'Farrell	Paula Villescaz	Jan Harnik	Dr. Donnisha Sanford	Kenneth Koperski	Wanda Williams	None	Tony Estremera	Amrik Wander	Cheryl Turner	John Park	Anthony Kuo	Tony Mannor	Bonnie Centers	Peggy Huang	Nyles O'Harra	Chris Venable	Christian Shaughnessy	Elaine Holmes	Curtis Burton	David VanGorden	Floyd Clark	Cynthia Brakeman	David Toro	James Blocker	Richard Ingle	Gabriel Reyes	Jack Zwald	Jeff Wang	Jennifer Laret	Jim Penman	Lena Tam	Londa Lamb	Mary Ann Reiss	Mony Nop	Daniel McAllister	Tony Reynoso	Lana Negrete	Armen Milkonians	Shaunna Elias	Stephanie McKenzie	Debora Allen	Leonardo Mendoza	Paul Marsh	Matt Rahn	Kelly Seyarto	Bill Essayli	Ian Weeks	Greg Wallis	None	Curtis Brown	Ed Delgado	Ben Diederich	Jim Steiner	Cheylynda Barnard	Wes Speake	Michael McMinn	Yxstian Gutierrez	Ben Benoit	Melinda Young	Cynthia Lemus	Julio Gonzalez	Kevin Bash	Jeff Cervantez	Denise Delgado	Jaime Hurtado	Natalie Lough	Chris Raahauge	Melissa Ragole	Bob Archuleta	Carol Kwan	Kelsey Iino	Steve Veres	Sara Hernandez	Gabriel Buelna	Wayne Zipser	Janice Parvin	Leticia Perez	Rick Ledesma	Angela Williams	Timothy Surridge	Madison Klovstad Miner	None	Michelle Kile	Harold Williams	Sergio Calderon	Karen Brako	Pat Bates	John Thomas Patton	Robert Dickson	Luis Cetina	None	Tiffany Saathoff	Elbert Holman	Marc Boomgaarden	Melissa Hammond	Mike Pasquale	Nichole Nava	Austin Lumbard	Karina Talamantes	Renee Chang	Rick Caruso	Simon Moon	Rudy Bojorquez	Valerie Amezcua	None	Nick Dokoozlian	Stu Gilman	None	None	Lizet Angulo	Matt Basgall	Damon Connolly	Dave Shaw	Fred Docdocil	Juan Alanis	Mike Stoker	David Tennessen	Tony Strickland	Thurston 'Smitty' Smith	Cindy Wu	Daniel Langan	None	None	None	None	Fred Docdocil	Katy Young Yaroslavsky	Suzette Martinez Valladares	Suzie Price	Paul Seo
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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	CCM	CCM	CCM	OTH	MAY	CCM	CCM	BED	CCM	CCM	BED	BED	BED	MAY	OTH	BED	MAY	CCM	CCM	CCM	CCM	CCM	CCM	SEN	CCM	CCM	CCM	CSU	None	OTH	CCM	SEN	CCM	CCM	BED	BED	SCJ	OTH	CCM	BED	CCM	CCM	CCM	CCM	BED	CCM	BED	BED	MAY	OTH	CCM	BED	MAY	CSU	BED	CCM	MAY	OTH	CCM	CCM	CCM	BED	CCM	CSU	OTH	ASM	ASM	SEN	ASM	ASM	ASM	None	CCM	CCM	CCM	CCM	CCM	CCM	CCM	CSU	OTH	BED	BED	BED	CCM	CCM	MAY	MAY	SCJ	BED	BED	SEN	OTH	BED	BED	BED	BED	OTH	CSU	ASM	BED	BED	BED	BED	None	CCM	OTH	OTH	SCJ	CSU	CCM	CCM	CSU	None	BED	CSU	CCM	SCJ	CCM	CCM	MAY	CCM	SCJ	MAY	MAY	CCM	MAY	None	OTH	OTH	None	None	CCM	CCM	ASM	CCM	CCM	ASM	ASM	CCM	CCM	ASM	BED	OTH	None	None	None	None	CCM	CCM	ASM	MAY	CCM
offic_dscr	None	None	None	Board Member	None	None	None	None	None	None	None	None	None	None	Board Member	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Water District Board Member	None	None	None	None	None	None	None	Board Member	None	None	None	None	None	None	None	None	None	None	None	Board Member	None	None	None	None	None	None	None	Treasurer	None	None	None	None	None	None	Board Member	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	County Auditor / Controller	None	None	None	None	None	None	None	None	None	None	None	Board Member	None	None	None	None	Board Member	None	None	None	None	None	None	None	None	Board Member	Board Director	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Board Director	Board Member	None	None	None	None	None	None	None	None	None	None	None	None	None	Board Member	None	None	None	None	None	None	None	None	None
juris_cd	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	SEN	OTH	OTH	OTH	OTH	None	OTH	OTH	SEN	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	ASM	ASM	SEN	ASM	ASM	ASM	None	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	SEN	OTH	OTH	OTH	OTH	OTH	OTH	OTH	ASM	OTH	OTH	OTH	OTH	None	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	None	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	None	OTH	OTH	None	None	OTH	OTH	ASM	OTH	OTH	ASM	ASM	OTH	OTH	ASM	OTH	OTH	None	None	None	None	OTH	OTH	ASM	OTH	OTH
juris_dscr	City of West Covina	City of West Sacramento	City of Alhambra	Inland Empire Utilities Agency	City of El Monte	City of Dinuba	City of Stanton	Carlsbad Unified School District	City of West Sacramento	City of Citrus Heights	State Center CCD TA 5	San Joaquin Delta CCD	Antioch Unified School District	City of Costa Mesa	West Basin Municipal Water	Buena Park School District	City of Orange	City of Orange Ward 4	City of San Juan Capistrano	City of Clovis	City of Pismo Beach	City of Pismo Beach	City of Los Angeles	None	City of Palm Desert	City of Hawthorne	City of Colton	Solano County	None	Santa Clara Valley Water District 6	City of Tracy	None	City of Irvine	City of Irvine	Lincoln Unified School District	Lincoln Unified School District	Orange County	Yucaipa Valley Water District 2	City of Yucaipa	San Bernardino CCD	City of Indio	City of Chino	City of Rancho Cucamonga	City of Rancho Cucamonga	Kern High School District	City of Colton	Hesperia Unified School District	Placentia-Yorba Linda USD	City of Adelanto	Cordova Recreation & Park District	City of Union City	Folsom Cordova Unified School District	City of San Bernardino	Alameda County	Yuba City Unified School District	City of Pismo Beach	City of Livermore	San Diego County	City of Hawthorne	City of Santa Monica	City of Santa Monica	Glendora Unified School District	City of Marysville	Contra Costa County	Central Basin Municipal Water	None	None	None	None	None	None	None	City of Temecula	City of Moreno Valley	City of Menifee Council	City of Corona	City of Moreno Valley	City of Corona	City of Eastvale	Riverside County	Riverside County	Val Verde Unified School District	Val Verde Unified School District	Val Verde Unified School District	City of Norco	City of Calimesa	City of Coachella	City of Moreno Valley	Riverside County, Office 4	Corona-Norco Unified School District	Jurupa Unified School District	None	West Basin Municipal Water	Los Angeles Community College District	Los Angeles Community College District	Los Angeles Community College District	Los Angeles Community College District	Turlock Irrigation District 2	Ventura County	None	Orange Unified School district	Orange Unified School district	Orange Unified School district	Orange Unified School district	None	City of Elk Grove	West Basin Municipal Water	Water Replenishment District	Los Angeles County	Orange County	City of Costa Mesa Ward 3	City of Costa Mesa Ward 5	San Bernardino County	None	Rocklin Unified School District	San Joaquin County	City of Yuba City	Los Angeles County, Office 118	City of Yuba City	City of Chico	City of Tustin	City of Sacramento	Los Angeles County, Office 70	City of Los Angeles	City of Irvine	City of South El Monte	City of Santa Ana	None	Modesto Irrigation District 3	Modesto Irrigation District 4	None	None	City of Victorville	City of Clovis	None	City of Yuba City	City of Carson	None	None	City of Camarillo	City of Huntington Beach	None	Mountain View School District	Cordova Recreation & Park District	None	None	None	None	City of Carson	City of Los Angeles	None	City of Long Beach	City of Rancho Palos Verdes
dist_no	5	None	1	3	None	4	None	None	None	4	None	None	None	None	3	4	None	None	3	None	None	None	13	6	2	None	2	3	None	None	None	28	None	None	None	None	None	None	2	None	3	2	2	1	None	1	None	None	None	2	None	None	None	3	None	None	None	None	None	None	None	None	None	4	3	39	71	32	63	36	47	None	1	2	2	4	4	5	5	5	None	None	None	None	None	None	None	None	None	None	None	30	1	None	None	None	None	None	4	35	None	None	None	None	None	2	1	4	None	5	None	None	2	None	None	2	None	None	None	4	None	3	None	None	None	None	None	None	None	None	None	None	None	None	12	None	4	22	37	1	None	34	None	5	None	None	None	None	4	5	40	None	None
off_s_h_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	Phase-out and ban of non-hosted Short-Term Vacation Rentals (STVRs) throughout the City of La Quinta, except those in exempt areas	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	To continue providing general governmental revenus which are used for pubic safety services, without increase to the existing, voter-approved one percent Hemet Transactions and Use Tax.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Funding affordable housing and tenant assistance programs through a property transfer tax.	None	None	None	None	None	None	None	None	o?=Sutter County Essential Services Measure,o?= to impose a Retail Transactions (Sales) and Use Tax of one cent on transactions in the incorporated and unincorporated areas of the County of Sutter.	None	None	None	None	None	None	None	None	None	None	None	None	None	Los Angeles Community College District Safety, Repair, Job Training Measure	None	None	To maintain and prevent cuts to City of Upland services establishing a $.01 sales tax to be adopted.	Permitting and regulating limited cannabis retail businesses, establishing a general tax and $25/sq. ft. of cultivation space	None	None	None	None	None	None	None	None	None	None	None	None	Provides funding for programs to reduce greenhouse gas emissions by increasing tax on personal income over $2 million	Amend the Laguna Municipal Code to create an overlay zoning district, establish special requirements for major developments and require voter approval for any major development project	Provides additional funding for arts and music education in public schools.	To fund general city services in the City of Modesto	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	A	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	H	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	ULA	None	None	None	None	None	None	None	None	A	None	None	None	None	None	None	None	None	None	None	None	None	None	LA	None	None	L	CM	None	None	None	None	None	None	None	None	None	None	None	None	30	Q	28	H	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	City of La Quinta	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Ciity of Hemet	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	City of Los Angeles	None	None	None	None	None	None	None	None	Sutter County	None	None	None	None	None	None	None	None	None	None	None	None	None	Los Angeles County	None	None	City of Upland	City of South El Monte	None	None	None	None	None	None	None	None	None	None	None	None	Statewide	City of Laguna	Statewide	City of Modesto	None	None	None	None	None
sup_opp_cd	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	O	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	S	O	O	S	S	S	S	S	S	S
memo_code	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
memo_refno	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bakref_tid	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
xref_schnm	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
xref_match	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
int_rate	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
intr_cmteid	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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: s401
filing_id	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947
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
line_item	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34
rec_type	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401	S401
form_type	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401B	F401C	F401C
tran_id	EXP8755	EXP8698	EXP8717	EXP8612	EXP8720	EXP8718	EXP8696	EXP8702	EXP8602	EXP8715	EXP8754	EXP8592	EXP8699	EXP8724	EXP8591	EXP8700	EXP8701	EXP8716	EXP8721	EXP8609	EXP8611	EXP8634	EXP8635	EXP8636	EXP8637	EXP8638	EXP8725	EXP8726	EXP8727	EXP8728	EXP8748	EXP8753	EXP8696	EXP8700
agent_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
agent_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
agent_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
agent_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
payee_naml	Art Chacon for Water Board 2022	Barry Wyatt Associates	Beaty for Council 2022	Brown for Temecula City Council D1 2022	Carol Kwan for West Basin Water Board 2022	David Yonan for Turlock Irrigation District Director 2022	Deane & Company	Employment Development Department	I/PRO Corporation	Ian Weeks for Assembly 2022	Jeff von Waldburg for City Council 2022	Oliver for City Council 2022	Ray	Real Estate Image, Inc. dba Advanced Image Direct	Sadowy	Shimpock	United States Treasury	Wanda Wiliams for Solano County Supervisor 2022	Wes Speake for Corona City Council 2022	eFundraising Connections	eFundraising Connections	eFundraising Connections	eFundraising Connections	eFundraising Connections	eFundraising Connections	eFundraising Connections	eFundraising Connections	eFundraising Connections	eFundraising Connections	eFundraising Connections	eFundraising Connections	eFundraising Connections	Deane & Company	Shimpock
payee_namf	None	None	None	None	None	None	None	None	None	None	None	None	Brian E.	None	Nicholas	Mike	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Mike
payee_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
payee_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
payee_city	Long Beach	South Pasadena	Vacaville	Temecula	Los Angeles	Ceres	Sacramento	Sacramento	Los Angeles	Hemet	Irvine	Rocklin	South Pasadena	Fullerton	Shingle Springs	South Pasadena	Washington	Suisun City	Corona	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	South Pasadena
payee_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	DC	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
payee_zip4	90802	91030	95688	92592	90071	95307	95815	95814	90025	92543	92618	95677	91030	92831	95682	91030	20220	94585	92881	95816	95816	95816	95816	95816	95816	95816	95816	95816	95816	95816	95816	95816	95815	91030
amount	934	5000	400	356	1920	477	3534	946	1950	4226	1800	1619	2147	652297	200	7423	3156	1147	620	54	20	14	139	198	265	485	168	495	289	190	183	128	3534	7423
aggregate	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	44796	66808
expn_dscr	Refund of Payment	September Retainer	Refund of Payment	Refund of Payment	Refund of Payment	Refund of Payment	Bookkeeping	Payroll Tax	Commission	Refund of Payment	Refund of Payment	Refund of Payment	Net Payroll	Print Production	Consulting	Net Payroll	Payroll Tax	Refund of Payment	Refund of Payment	Merchant Fee	Merchant Fee	Merchant Fee	Merchant Fee	Merchant Fee	Merchant Fee	Merchant Fee	Merchant Fee	Merchant Fee	Merchant Fee	Merchant Fee	Merchant Fee	Merchant Fee	Bookkeeping	Net Payroll
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
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
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
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
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
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
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
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
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
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
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
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
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
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
memo_code	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
memo_refno	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bakref_tid	None	None	None	None	None	None	None	None	None	None	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: smry
filing_id	2743947	2743947	2743947	2743947	2743947	2743947	2743947	2743947
amend_id	0	0	0	0	0	0	0	0
line_item	1	2	1	2	3	1	2	3
rec_type	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY
form_type	F401	F401	401A	401A	401A	401B	401B	401B
amount_a	521869	692779	521819	50	521869	692779	0	692779
amount_b	2886926	1569635	None	None	None	None	None	None
amount_c	None	None	None	None	None	None	None	None
elec_dt	None	None	None	None	None	None	None	None