OpenCalAccess

Filing ID: 2703621

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

Table: cvr3_verification_info
filing_id	2703621	2703621
amend_id	1	0
line_item	1	1
rec_type	CVR3	CVR3
form_type	F461	F461
tran_id	3	3
entity_cd	OFF	OFF
sig_date	2022-10-12 00:00:00	2022-07-29 00:00:00
sig_loc	None	None
sig_naml	Kiesling	Kiesling
sig_namf	Brad	Brad
sig_namt	None	None
sig_nams	None	None

Table: cvr_campaign_disclosure
filing_id	2703621	2703621
amend_id	0	1
rec_type	CVR	CVR
form_type	F461	F461
filer_id	482190	482190
entity_cd	MDI	MDI
filer_naml	Republic Services Inc., and Affiliated Entities	Republic Services Inc., and Affiliated Entities
filer_namf	None	None
filer_namt	None	None
filer_nams	None	None
report_num	000	001
rpt_date	2022-07-29 00:00:00	2022-10-11 00:00:00
stmt_type	None	None
late_rptno	None	None
from_date	2022-01-01 00:00:00	2022-01-01 00:00:00
thru_date	2022-06-30 00:00:00	2022-06-30 00:00:00
elect_date	None	None
filer_city	Phoenix	Phoenix
filer_st	AZ	AZ
filer_zip4	85054-0000	85054-0000
filer_phon	480-627-2700	480-627-2700
filer_fax	None	None
file_email	None	None
mail_city	None	None
mail_st	None	None
mail_zip4	None	None
tres_naml	None	None
tres_namf	None	None
tres_namt	None	None
tres_nams	None	None
tres_city	Phoenix	Phoenix
tres_st	AZ	AZ
tres_zip4	85054-0000	85054-0000
tres_phon	480-627-2700	480-627-2700
tres_fax	None	None
tres_email	None	None
cmtte_type	None	None
control_yn	None	None
sponsor_yn	None	None
primfrm_yn	None	None
brdbase_yn	None	None
amendexp_1	None	None
amendexp_2	None	None
amendexp_3	None	None
rpt_att_cb	None	None
cmtte_id	None	None
reportname	None	None
rptfromdt	None	None
rptthrudt	None	None
emplbus_cb	None	None
bus_name	None	None
bus_city	None	None
bus_st	None	None
bus_zip4	None	None
bus_inter	None	None
busact_cb	X	X
busactvity	Waste management Medical Waste & Recycling	Waste management Medical Waste & Recycling
assoc_cb	None	None
assoc_int	None	None
other_cb	None	None
other_int	None	None
cand_naml	None	None
cand_namf	None	None
cand_namt	None	None
cand_nams	None	None
cand_city	None	None
cand_st	None	None
cand_zip4	None	None
cand_phon	None	None
cand_fax	None	None
cand_email	None	None
bal_name	None	None
bal_num	None	None
bal_juris	None	None
office_cd	None	None
offic_dscr	None	None
juris_cd	None	None
juris_dscr	None	None
dist_no	None	None
off_s_h_cd	None	None
sup_opp_cd	None	None
employer	None	None
occupation	None	None
selfemp_cb	None	None
bal_id	None	None
cand_id	None	None

Table: expn
filing_id	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621
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	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
line_item	75	76	77	78	79	80	81	82	83	84	85	86	87	88	89	90	91	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	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
rec_type	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN
form_type	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5	F461P5
tran_id	813666	813870	813872	813873	813874	815091	816053	816054	816917	817153	818721	819862	819858	819860	820237	820341	820545	809346	817103	818023	809962	819237	810386	818022	816799	819954	809957	809956	808849	812866	819859	819238	808851	811331	816701	818020	808856	819855	817826	815090	808885	810349	819856	811329	820327	808858	808853	819853	818900	819852	818021	813668	816868	813264	811326	819851	819849	808847	816802	816806	810541	808843	810387	808859	819861	819847	808857	819848	810542	819845	818901	813871	821665	819857	819850	808840	808846	808855	808854	808852	808850	809960	809961	809963	809964	810384	810385	810540	811328	812868	819854	809346	817103	818023	809962	819237	810386	818022	816799	819954	809957	809956	808849	812866	819859	819238	808851	811331	816701	818020	808856	819855	817826	815090	808885	810349	819856	811329	820327	808858	808853	819853	818900	819852	818021	813668	816868	813264	811326	819851	819849	808847	816802	816806	810541	808843	810387	808859	819861	819847	808857	819848	810542	819845	818901	813871	821665	819857	819850	808840	808846	808855	808854	808852	808850	809960	809961	809963	809964	810384	810385	810540	811328	812868	819854	813666	813870	813872	813873	813874	815091	816053	816054	816917	817153	818721	819862	819858	819860	820237	820341	820545
entity_cd	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP
payee_naml	Ted Bui for State Assembly 2022	Steve Ding for Supervisor 2022	Ma'ae for City Council 2022	Sarmiento for Supervisor 2022	Friends of George Brietigam for Garden Grove City Council 2022	Angie Reyes English for Assembly 2022	Ramona Arellano-Snyder for San Jose City Council D1 2022	Rosemary Kamei for San Jose City Council District 1 2022	Kim Carr for State Senate 2022 #1443808	Laura Parmer-Lohan for San Mateo County Supervisor 2022	Cmte to Re-elect Margaret Clark to Rosemead City C	Catherine Blakespear for Senate 2022	Rick Chavez Zbur for Assembly 2022	Andrea Rosenthal for Assembly 2022	Yes on E Committee for Excellent Milpitas Schools	Safe Strong Torrance - Yes on SST	Octavio Martinez for Whittier City Council 2022	San Diego Regional Chamber of Commerce PAC	Tom Butt for Mayor 2018	Republican Party of Orange County	Cindy Chavez for Mayor 2022	League of California Cities CITIPAC	Stepper for Council 2022	Gus Kramer for Assessor 2022	Storer for Council 2022	Gipson for Assembly 2022	California Waste Haulers Council PAC	Solid Waste Association of Orange County PAC	Al Austin for City Council 2020	Pullen-Miles for Assembly 2022 Special	Pullen-Miles for Assembly 2022	Steven Ly for Rosemead City Council 2022	Roberto Uranga for City Council 2022	Monica Wilson for Antioch City Council 2022	Sandra Armenta for Rosemead City Cncl 2022	Quintana for Bell City Council 2022	Ivan Altamirano for City Council 2022	Janet Nguyen for Senate 2022	Santiago for Assembly 2022	Alex Padilla for City Council 2022	Robert Garcia Officeholder Account	Paul Canepa for San Joaquin Cnty Supv 2022	Phillip Chen for Assembly 2022	Re-Elect Maya Esparza for City Council 2022	Lori Ogorchock Antioch City Council 2020	Devon Mathis for Assembly 2022	Daryl Supernaw Officeholder Acct 2015	Blanca Rubio for Assembly 2022	Michael Blower for Stockton City Council Dist 3 20	Josh Newman for Senate 2024	Romero for City Council 2022	2018 Supervisor Ellenberg Officeholder Acct	Sol Jobrack for Stockton City Cncl 2022	Diana Becton for Dist Attorney 2022	Re-Elect Pam Foley 2022 San Jose City Cncl D9	Susan Rubio for Senate 2022	Bob Archuleta for Senate 2022	Trevor O'Neil for Anaheim City Council 2022	Trevor O'Neil for Anaheim City Council 2022	Harry Sidhu for Mayor 2022	Chris Ward for Assembly 2022	Rebecca Bauer-Kahan for Assembly 2022	Re-Elect Hudson for San Ramon Mayor 2022	Suzette Martinez Valladares for Assembly 2022	Dawn Addis for Assembly 2022	Skinner for Senate 2020 Officeholder Account	Toni Atkins for Lt. Governor 2026	Toni Atkins for Lt. Governor 2026	Irwin for Assembly 2022	Portantino for Supt. of Public Instruction 2026	Hume for Supervisor 2022	Ken Carlson for County Supervisor 2022	Johnny Khamis for Supervisor 2022	Hertzberg for Senate 2022	Bill Dodd for Lt. Governor 2026	Natalie Rubalcava for City Council 2022	Zahra for City Council 2022	Rex Richardson Officeholder Account 2014	Mary Zendejas for City Cncl Officeholder Acct 2019	Stacy Mungo City Cncl 2014 Officeholder Acct	Suely Saro for Long Beach City Cncl 2020 Officehol	Raul Peralez for Mayor 2022	Dev Davis for San Jose Mayor 2022	Rolando Bonilla for San Jose City Cncl Dist 5	Neighbors for Matt Mahan for Mayor 2022	Stop the #Karen Recall of Mayor Lamar Thorpe 2022	Kim Nguyen for Supervisor 2022	Soria for Assembly 2022	Sylvia Arenas for Supervisor 2022	Elizabeth Alcantar for Assembly 2022	Lori Wilson for Assembly 2022	San Diego Regional Chamber of Commerce PAC	Tom Butt for Mayor 2018	Republican Party of Orange County	Cindy Chavez for Mayor 2022	League of California Cities CITIPAC	Stepper for Council 2022	Gus Kramer for Assessor 2022	Storer for Council 2022	Gipson for Assembly 2022	California Waste Haulers Council PAC	Solid Waste Association of Orange County PAC	Al Austin for City Council 2020	Pullen-Miles for Assembly 2022 Special	Pullen-Miles for Assembly 2022	Steven Ly for Rosemead City Council 2022	Roberto Uranga for City Council 2022	Monica Wilson for Antioch City Council 2022	Sandra Armenta for Rosemead City Cncl 2022	Quintana for Bell City Council 2022	Ivan Altamirano for City Council 2022	Janet Nguyen for Senate 2022	Santiago for Assembly 2022	Alex Padilla for City Council 2022	Robert Garcia Officeholder Account	Paul Canepa for San Joaquin Cnty Supv 2022	Phillip Chen for Assembly 2022	Re-Elect Maya Esparza for City Council 2022	Lori Ogorchock Antioch City Council 2020	Devon Mathis for Assembly 2022	Daryl Supernaw Officeholder Acct 2015	Blanca Rubio for Assembly 2022	Michael Blower for Stockton City Council Dist 3 20	Josh Newman for Senate 2024	Romero for City Council 2022	2018 Supervisor Ellenberg Officeholder Acct	Sol Jobrack for Stockton City Cncl 2022	Diana Becton for Dist Attorney 2022	Re-Elect Pam Foley 2022 San Jose City Cncl D9	Susan Rubio for Senate 2022	Bob Archuleta for Senate 2022	Trevor O'Neil for Anaheim City Council 2022	Trevor O'Neil for Anaheim City Council 2022	Harry Sidhu for Mayor 2022	Chris Ward for Assembly 2022	Rebecca Bauer-Kahan for Assembly 2022	Re-Elect Hudson for San Ramon Mayor 2022	Suzette Martinez Valladares for Assembly 2022	Dawn Addis for Assembly 2022	Skinner for Senate 2020 Officeholder Account	Toni Atkins for Lt. Governor 2026	Toni Atkins for Lt. Governor 2026	Irwin for Assembly 2022	Portantino for Supt. of Public Instruction 2026	Hume for Supervisor 2022	Ken Carlson for County Supervisor 2022	Johnny Khamis for Supervisor 2022	Hertzberg for Senate 2022	Bill Dodd for Lt. Governor 2026	Natalie Rubalcava for City Council 2022	Zahra for City Council 2022	Rex Richardson Officeholder Account 2014	Mary Zendejas for City Cncl Officeholder Acct 2019	Stacy Mungo City Cncl 2014 Officeholder Acct	Suely Saro for Long Beach City Cncl 2020 Officehol	Raul Peralez for Mayor 2022	Dev Davis for San Jose Mayor 2022	Rolando Bonilla for San Jose City Cncl Dist 5	Neighbors for Matt Mahan for Mayor 2022	Stop the #Karen Recall of Mayor Lamar Thorpe 2022	Kim Nguyen for Supervisor 2022	Soria for Assembly 2022	Sylvia Arenas for Supervisor 2022	Elizabeth Alcantar for Assembly 2022	Lori Wilson for Assembly 2022	Ted Bui for State Assembly 2022	Steve Ding for Supervisor 2022	Ma'ae for City Council 2022	Sarmiento for Supervisor 2022	Friends of George Brietigam for Garden Grove City Council 2022	Angie Reyes English for Assembly 2022	Ramona Arellano-Snyder for San Jose City Council D1 2022	Rosemary Kamei for San Jose City Council District 1 2022	Kim Carr for State Senate 2022 #1443808	Laura Parmer-Lohan for San Mateo County Supervisor 2022	Cmte to Re-elect Margaret Clark to Rosemead City C	Catherine Blakespear for Senate 2022	Rick Chavez Zbur for Assembly 2022	Andrea Rosenthal for Assembly 2022	Yes on E Committee for Excellent Milpitas Schools	Safe Strong Torrance - Yes on SST	Octavio Martinez for Whittier City Council 2022
payee_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	None	None	None	None	None	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_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	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	Hilmar	Woodbridge	Anaheim	Santa Ana	Garden Grove	Norwalk	San Jose	San Jose	Irvine	San Carlos	Rosemead	Sacramento	Sacramento	Sacramento	San Jose	Long Beach	Wilton	San Diego	Richmond	Tustin	San Jose	Sacramento	Danville	Martinez	Danville	Sacramento	Sacramento	Sacramento	Long Beach	Sherman Oaks	Sacramento	Alhambra	Long Beach	Antioch	Rosemead	Bell	Commerce	Sacramento	Sherman Oaks	Inglewood	Long Beach	Stockton	Sacramento	San Jose	Antioch	Hilmar	Long Beach	Sacramento	Stockton	Fullerton	Bell	San Jose	San Jose	Pinole	San Jose	Sacramento	Sacramento	Irvine	Irvine	Anaheim	Encinitas	Sacramento	San Ramon	Hilmar	Sacramento	Sacramento	Encinitas	Encinitas	Sacramento	Sacramento	Elk Grove	Oakland	San Jose	Sacramento	Sacramento	Anaheim	Fullerton	Long Beach	Long Beach	Long Beach	Long Beach	San Jose	San Jose	San Jose	San Jose	Antioch	Santa Ana	Fresno	San Jose	Norwalk	Sacramento	San Diego	Richmond	Tustin	San Jose	Sacramento	Danville	Martinez	Danville	Sacramento	Sacramento	Sacramento	Long Beach	Sherman Oaks	Sacramento	Alhambra	Long Beach	Antioch	Rosemead	Bell	Commerce	Sacramento	Sherman Oaks	Inglewood	Long Beach	Stockton	Sacramento	San Jose	Antioch	Hilmar	Long Beach	Sacramento	Stockton	Fullerton	Bell	San Jose	San Jose	Pinole	San Jose	Sacramento	Sacramento	Irvine	Irvine	Anaheim	Encinitas	Sacramento	San Ramon	Hilmar	Sacramento	Sacramento	Encinitas	Encinitas	Sacramento	Sacramento	Elk Grove	Oakland	San Jose	Sacramento	Sacramento	Anaheim	Fullerton	Long Beach	Long Beach	Long Beach	Long Beach	San Jose	San Jose	San Jose	San Jose	Antioch	Santa Ana	Fresno	San Jose	Norwalk	Sacramento	Hilmar	Woodbridge	Anaheim	Santa Ana	Garden Grove	Norwalk	San Jose	San Jose	Irvine	San Carlos	Rosemead	Sacramento	Sacramento	Sacramento	San Jose	Long Beach	Wilton
payee_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	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
payee_zip4	95324	95258	92801	92701	92845	90650	95128	95130	92618	94070	91770	95815	95814	95815	95131	90501	90601	92101	94801	92780	95126	95814	94526	94553	94526	95814	95814	95814	90807	91423	95814	91803	90802	94509	91770	90201	90040	95814	91423	90302	90814	95207	95814	95122	94531	95324	90815	95814	95219	92835	90201	95126	95192	94564	95125	95814	95814	92618	92618	92807	92024	95814	94583	95324	95814	95814	92024	92024	94814	95814	95624	94607	95120	95814	95814	92805	92835	90802	90802	90808	90802	95125	95125	95126	95123	94531	92704	93721	95138	90650	95814	92101	94801	92780	95126	95814	94526	94553	94526	95814	95814	95814	90807	91423	95814	91803	90802	94509	91770	90201	90040	95814	91423	90302	90814	95207	95814	95122	94531	95324	90815	95814	95219	92835	90201	95126	95192	94564	95125	95814	95814	92618	92618	92807	92024	95814	94583	95324	95814	95814	92024	92024	94814	95814	95624	94607	95120	95814	95814	92805	92835	90802	90802	90808	90802	95125	95125	95126	95123	94531	92704	93721	95138	90650	95814	95324	95258	92801	92701	92845	90650	95128	95130	92618	94070	91770	95815	95814	95815	95131	90501	90601
expn_date	2022-03-21 00:00:00	2022-03-22 00:00:00	2022-03-28 00:00:00	2022-03-22 00:00:00	2022-03-28 00:00:00	2022-04-04 00:00:00	2022-04-26 00:00:00	2022-04-26 00:00:00	2022-04-25 00:00:00	2022-05-11 00:00:00	2022-05-18 00:00:00	2022-06-02 00:00:00	2022-06-02 00:00:00	2022-06-02 00:00:00	2022-06-08 00:00:00	2022-06-10 00:00:00	2022-06-10 00:00:00	2022-01-21 00:00:00	2022-04-27 00:00:00	2022-05-09 00:00:00	2022-02-07 00:00:00	2022-05-26 00:00:00	2022-02-18 00:00:00	2022-05-09 00:00:00	2022-04-26 00:00:00	2022-06-02 00:00:00	2022-02-07 00:00:00	2022-02-07 00:00:00	2022-01-14 00:00:00	2022-03-08 00:00:00	2022-06-02 00:00:00	2022-05-24 00:00:00	2022-01-14 00:00:00	2022-02-28 00:00:00	2022-05-20 00:00:00	2022-05-09 00:00:00	2022-01-14 00:00:00	2022-06-02 00:00:00	2022-05-11 00:00:00	2022-04-12 00:00:00	2022-01-14 00:00:00	2022-02-18 00:00:00	2022-06-02 00:00:00	2022-02-28 00:00:00	2022-06-08 00:00:00	2022-01-14 00:00:00	2022-01-14 00:00:00	2022-06-02 00:00:00	2022-05-19 00:00:00	2022-06-07 00:00:00	2022-05-09 00:00:00	2022-03-21 00:00:00	2022-04-26 00:00:00	2022-03-21 00:00:00	2022-02-28 00:00:00	2022-06-02 00:00:00	2022-06-02 00:00:00	2022-01-14 00:00:00	2022-04-26 00:00:00	2022-04-26 00:00:00	2022-02-18 00:00:00	2022-01-14 00:00:00	2022-02-18 00:00:00	2022-01-14 00:00:00	2022-06-02 00:00:00	2022-06-07 00:00:00	2022-01-14 00:00:00	2022-06-07 00:00:00	2022-02-18 00:00:00	2022-06-07 00:00:00	2022-05-19 00:00:00	2022-03-28 00:00:00	2022-06-29 00:00:00	2022-06-02 00:00:00	2022-06-07 00:00:00	2022-01-14 00:00:00	2022-01-14 00:00:00	2022-01-14 00:00:00	2022-01-14 00:00:00	2022-01-14 00:00:00	2022-01-14 00:00:00	2022-02-07 00:00:00	2022-02-07 00:00:00	2022-02-07 00:00:00	2022-02-07 00:00:00	2022-02-18 00:00:00	2022-02-18 00:00:00	2022-02-18 00:00:00	2022-02-28 00:00:00	2022-03-21 00:00:00	2022-06-02 00:00:00	2022-01-21 00:00:00	2022-04-27 00:00:00	2022-05-09 00:00:00	2022-02-07 00:00:00	2022-05-26 00:00:00	2022-02-18 00:00:00	2022-05-09 00:00:00	2022-04-26 00:00:00	2022-06-02 00:00:00	2022-02-07 00:00:00	2022-02-07 00:00:00	2022-01-14 00:00:00	2022-03-08 00:00:00	2022-06-02 00:00:00	2022-05-24 00:00:00	2022-01-14 00:00:00	2022-02-28 00:00:00	2022-05-20 00:00:00	2022-05-09 00:00:00	2022-01-14 00:00:00	2022-06-02 00:00:00	2022-05-11 00:00:00	2022-04-12 00:00:00	2022-01-14 00:00:00	2022-02-18 00:00:00	2022-06-02 00:00:00	2022-02-28 00:00:00	2022-06-08 00:00:00	2022-01-14 00:00:00	2022-01-14 00:00:00	2022-06-02 00:00:00	2022-05-19 00:00:00	2022-06-07 00:00:00	2022-05-09 00:00:00	2022-03-21 00:00:00	2022-04-26 00:00:00	2022-03-21 00:00:00	2022-02-28 00:00:00	2022-06-02 00:00:00	2022-06-02 00:00:00	2022-01-14 00:00:00	2022-04-26 00:00:00	2022-04-26 00:00:00	2022-02-18 00:00:00	2022-01-14 00:00:00	2022-02-18 00:00:00	2022-01-14 00:00:00	2022-06-02 00:00:00	2022-06-07 00:00:00	2022-01-14 00:00:00	2022-06-07 00:00:00	2022-02-18 00:00:00	2022-06-07 00:00:00	2022-05-19 00:00:00	2022-03-28 00:00:00	2022-06-29 00:00:00	2022-06-02 00:00:00	2022-06-07 00:00:00	2022-01-14 00:00:00	2022-01-14 00:00:00	2022-01-14 00:00:00	2022-01-14 00:00:00	2022-01-14 00:00:00	2022-01-14 00:00:00	2022-02-07 00:00:00	2022-02-07 00:00:00	2022-02-07 00:00:00	2022-02-07 00:00:00	2022-02-18 00:00:00	2022-02-18 00:00:00	2022-02-18 00:00:00	2022-02-28 00:00:00	2022-03-21 00:00:00	2022-06-02 00:00:00	2022-03-21 00:00:00	2022-03-22 00:00:00	2022-03-28 00:00:00	2022-03-22 00:00:00	2022-03-28 00:00:00	2022-04-04 00:00:00	2022-04-26 00:00:00	2022-04-26 00:00:00	2022-04-25 00:00:00	2022-05-11 00:00:00	2022-05-18 00:00:00	2022-06-02 00:00:00	2022-06-02 00:00:00	2022-06-02 00:00:00	2022-06-08 00:00:00	2022-06-10 00:00:00	2022-06-10 00:00:00
amount	1500	1500	1000	1000	1000	1500	400	400	1500	1000	1800	1500	2500	1500	2500	1500	2000	1200	2500	3000	1000	2500	500	2500	500	2000	1740	750	400	1500	2000	1500	400	2500	2700	1500	1500	2000	500	1500	500	1000	2000	700	2500	2000	500	2400	1000	1400	1500	1000	1000	825	700	2000	2000	500	1000	700	2400	2500	500	1300	1500	1760	2000	2500	2400	2000	1500	825	1000	2500	2000	500	500	750	300	500	500	1000	1000	700	1000	5000	1000	1000	1000	1500	3000	1200	2500	3000	1000	2500	500	2500	500	2000	1740	750	400	1500	2000	1500	400	2500	2700	1500	1500	2000	500	1500	500	1000	2000	700	2500	2000	500	2400	1000	1400	1500	1000	1000	825	700	2000	2000	500	1000	700	2400	2500	500	1300	1500	1760	2000	2500	2400	2000	1500	825	1000	2500	2000	500	500	750	300	500	500	1000	1000	700	1000	5000	1000	1000	1000	1500	3000	1500	1500	1000	1000	1000	1500	400	400	1500	1000	1800	1500	2500	1500	2500	1500	2000
cum_ytd	1500	1500	1000	1000	1000	1500	400	400	1500	1000	1800	1500	2500	1500	2500	1500	2000	1200	2500	3000	1000	2500	500	2500	500	2000	1740	750	400	1500	3500	1500	400	2500	2700	1500	1500	2000	500	1500	500	1000	2000	700	2500	2000	500	2400	1000	1400	1500	1000	1000	825	700	2000	2000	500	1500	700	2400	2500	500	1300	1500	1760	2000	4500	2400	2000	1500	825	1000	2500	2000	500	500	750	300	500	500	1000	1000	700	1000	5000	1000	1000	1000	1500	3000	1200	2500	3000	1000	2500	500	2500	500	2000	1740	750	400	1500	3500	1500	400	2500	2700	1500	1500	2000	500	1500	500	1000	2000	700	2500	2000	500	2400	1000	1400	1500	1000	1000	825	700	2000	2000	500	1500	700	2400	2500	500	1300	1500	1760	2000	4500	2400	2000	1500	825	1000	2500	2000	500	500	750	300	500	500	1000	1000	700	1000	5000	1000	1000	1000	1500	3000	1500	1500	1000	1000	1000	1500	400	400	1500	1000	1800	1500	2500	1500	2500	1500	2000
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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
expn_chkno	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
expn_code	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON	MON
expn_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	None	None	None	None	None	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_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	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	1444060	1439983	1442319	1442960	1410419	1444666	1439422	1443426	1443808	1435248	1443532	1436941	1437343	1439409	1447034	1446130	1439985	1335312	1235726	742088	1440871	1254399	1247916	1442677	1325812	1434878	761465	1255640	1418679	1444492	1444492	1445528	1439119	1344190	1443478	1334366	1353052	1443408	1435164	1349062	1359161	1439440	1434989	1441576	1408237	1435405	1374797	1435469	1437073	1435010	1355183	1422587	1399214	1435730	1441228	1415107	1414156	1395057	1395057	1397441	1434927	1434634	970655	1435635	1442437	1435465	1436346	1436346	1435250	1435623	1438939	1439757	1429245	1440456	1435087	1439463	1396977	1359540	1419572	1358238	1437829	1438267	1439170	1442717	1441269	1444264	1442910	1443835	1443416	1443873	1443496	1335312	1235726	742088	1440871	1254399	1247916	1442677	1325812	1434878	761465	1255640	1418679	1444492	1444492	1445528	1439119	1344190	1443478	1334366	1353052	1443408	1435164	1349062	1359161	1439440	1434989	1441576	1408237	1435405	1374797	1435469	1437073	1435010	1355183	1422587	1399214	1435730	1441228	1415107	1414156	1395057	1395057	1397441	1434927	1434634	970655	1435635	1442437	1435465	1436346	1436346	1435250	1435623	1438939	1439757	1429245	1440456	1435087	1439463	1396977	1359540	1419572	1358238	1437829	1438267	1439170	1442717	1441269	1444264	1442910	1443835	1443416	1443873	1443496	1444060	1439983	1442319	1442960	1410419	1444666	1439422	1443426	1443808	1435248	1443532	1436941	1437343	1439409	1447034	1446130	1439985
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	None	None	None	None	None	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	None	None	None	None	None	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	None	None	None	None	None	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	None	None	None	None	None	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	None	None	None	None	None	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	None	None	None	None	None	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	None	None	None	None	None	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	Bui	Ding	Ma'ae	Sarmiento	Brietigam	Reyes English	Arellano Snyder	Kamei	Carr	Parmer-Lohan	Clark	Blakespear	Zbur	Rosenthal	None	None	Martinez	San Diego Regional Chamber of Commerce PAC	Butt	Republican Party of Orange County	Chavez	League of California Cities CITIPAC	Stepper	Kramer	Storer	Gipson	California Waste Haulers Council PAC	Solid Waste Association of Orange County PAC	Austin	Pullen-Miles	Pullen-Miles	Ly	Uranga	Wilson	Armenta	Quintana	Altamirano	Nguyen	Santiago	Padilla	Garcia	Canepa	Chen	Esparza	Ogorchock	Mathis	Supernaw	Rubio	Blower	Newman	Romero	Ellenberg	Jobrack	Becton	Foley	Rubio	Archuleta	O'Neil	O'Neil	Sidhu	Ward	Bauer-Kahan	Hudson	Martinez Valladares	Addis	Skinner for Senate 2020 Officeholder Account	Atkins	Atkins	Irwin	Portantino	Hume	Carlson	Khamis	Hertzberg	Dodd	Rubalcava	Zahra	Richardson	Zendejas	Mungo	Saro	Peralez	Davis	Bonilla	Mahan	None	Nguyen	Soria	Arenas	Alcantar	Wilson	San Diego Regional Chamber of Commerce PAC	Butt	Republican Party of Orange County	Chavez	League of California Cities CITIPAC	Stepper	Kramer	Storer	Gipson	California Waste Haulers Council PAC	Solid Waste Association of Orange County PAC	Austin	Pullen-Miles	Pullen-Miles	Ly	Uranga	Wilson	Armenta	Quintana	Altamirano	Nguyen	Santiago	Padilla	Garcia	Canepa	Chen	Esparza	Ogorchock	Mathis	Supernaw	Rubio	Blower	Newman	Romero	Ellenberg	Jobrack	Becton	Foley	Rubio	Archuleta	O'Neil	O'Neil	Sidhu	Ward	Bauer-Kahan	Hudson	Martinez Valladares	Addis	Skinner for Senate 2020 Officeholder Account	Atkins	Atkins	Irwin	Portantino	Hume	Carlson	Khamis	Hertzberg	Dodd	Rubalcava	Zahra	Richardson	Zendejas	Mungo	Saro	Peralez	Davis	Bonilla	Mahan	None	Nguyen	Soria	Arenas	Alcantar	Wilson	Bui	Ding	Ma'ae	Sarmiento	Brietigam	Reyes English	Arellano Snyder	Kamei	Carr	Parmer-Lohan	Clark	Blakespear	Zbur	Rosenthal	None	None	Martinez
cand_namf	Ted	Steve	Gloria	Vicente	George	Angie	Ramona	Rosemary	Kim	Laura	Margaret	Catherine	Rick	Andrea	None	None	Octavio	None	Thomas	None	Cindy	None	Karen	Gus	Robert	Mike	None	None	Al	Robert	Robert	Steven	Roberto	Monica	Sandra	Ana Maria	Ivan	Janet	Miguel	Alex	Robert	Paul	Phillip	Maya	Lori	Devon	Daryl	Blanca	Michael	Josh	Alicia	Susan	Sol	Diana	Pam	Susan	Bob	Trevor	Trevor	Harry	Chris	Rebecca	Dave	Suzette	Dawn	None	Toni	Toni	Jacqui	Anthony	Pat	Ken	Johnny	Daniel	Bill	Natalie	Ahmad	Rex	Mary	Stacy	Suely	Raul	Dev	Rolando	Matt	None	Kim	Esmeralda	Sylvia	Elizabeth	Lori	None	Thomas	None	Cindy	None	Karen	Gus	Robert	Mike	None	None	Al	Robert	Robert	Steven	Roberto	Monica	Sandra	Ana Maria	Ivan	Janet	Miguel	Alex	Robert	Paul	Phillip	Maya	Lori	Devon	Daryl	Blanca	Michael	Josh	Alicia	Susan	Sol	Diana	Pam	Susan	Bob	Trevor	Trevor	Harry	Chris	Rebecca	Dave	Suzette	Dawn	None	Toni	Toni	Jacqui	Anthony	Pat	Ken	Johnny	Daniel	Bill	Natalie	Ahmad	Rex	Mary	Stacy	Suely	Raul	Dev	Rolando	Matt	None	Kim	Esmeralda	Sylvia	Elizabeth	Lori	Ted	Steve	Gloria	Vicente	George	Angie	Ramona	Rosemary	Kim	Laura	Margaret	Catherine	Rick	Andrea	None	None	Octavio
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	None	None	None	None	None	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	None	None	None	None	None	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	ASM	CSU	CCM	CSU	CCM	ASM	CCM	CCM	SEN	CSU	CCM	SEN	ASM	ASM	None	None	CCM	OTH	MAY	OTH	MAY	OTH	OTH	ASR	OTH	ASM	OTH	OTH	CCM	ASM	ASM	CCM	CCM	CCM	CCM	CCM	CCM	SEN	ASM	CCM	OTH	CSU	ASM	CCM	CCM	ASM	OTH	ASM	CCM	SEN	CCM	OTH	CCM	OTH	CCM	SEN	SEN	CCM	CCM	MAY	ASM	ASM	MAY	ASM	ASM	OTH	LTG	LTG	ASM	SUP	CSU	CSU	CSU	SEN	LTG	CCM	CCM	OTH	OTH	OTH	OTH	MAY	MAY	CCM	MAY	None	CSU	ASM	CSU	ASM	ASM	OTH	MAY	OTH	MAY	OTH	OTH	ASR	OTH	ASM	OTH	OTH	CCM	ASM	ASM	CCM	CCM	CCM	CCM	CCM	CCM	SEN	ASM	CCM	OTH	CSU	ASM	CCM	CCM	ASM	OTH	ASM	CCM	SEN	CCM	OTH	CCM	OTH	CCM	SEN	SEN	CCM	CCM	MAY	ASM	ASM	MAY	ASM	ASM	OTH	LTG	LTG	ASM	SUP	CSU	CSU	CSU	SEN	LTG	CCM	CCM	OTH	OTH	OTH	OTH	MAY	MAY	CCM	MAY	None	CSU	ASM	CSU	ASM	ASM	ASM	CSU	CCM	CSU	CCM	ASM	CCM	CCM	SEN	CSU	CCM	SEN	ASM	ASM	None	None	CCM
offic_dscr	State House	Co. Bd. of Supv.	City Council	Co. Bd. of Supv.	City Council	State House	City Council	City Council	State Senate	Co. Supv.	City Council	State Senate	State House	State House	None	None	City Council	Local PAC	Mayor	County Party Cmte	Mayor	State Multi-Issue Cmte	Town Council	Co. Assessor	Township Council	State House	State PAC	State PAC	City Council	State House	State House	City Council	City Council	City Council	City Council	City Council	City Council	State Senate	State House	City Council	Office Holder Account - Local	Co. Supv.	State House	City Council	City Council	State House	Office Holder Account - Local	State House	City Council	State Senate	City Council	Office Holder Account - Local	City Council	Other County Offices	City Council	State Senate	State Senate	City Council	City Council	Mayor	State House	State House	Mayor	State House	State House	Office Holder Account - State	Lt. Governor	Lt. Governor	State House	State Superint. Public Instruc	Co. Supv.	Co. Supv.	Co. Supv.	State Senate	Lt. Governor	City Council	City Council	Office Holder Account - Local	Office Holder Account - Local	Office Holder Account - Local	Office Holder Account - Local	Mayor	Mayor	City Council	Mayor	None	Co. Supv.	State House	Co. Bd. of Supv.	State House	State House	Local PAC	Mayor	County Party Cmte	Mayor	State Multi-Issue Cmte	Town Council	Co. Assessor	Township Council	State House	State PAC	State PAC	City Council	State House	State House	City Council	City Council	City Council	City Council	City Council	City Council	State Senate	State House	City Council	Office Holder Account - Local	Co. Supv.	State House	City Council	City Council	State House	Office Holder Account - Local	State House	City Council	State Senate	City Council	Office Holder Account - Local	City Council	Other County Offices	City Council	State Senate	State Senate	City Council	City Council	Mayor	State House	State House	Mayor	State House	State House	Office Holder Account - State	Lt. Governor	Lt. Governor	State House	State Superint. Public Instruc	Co. Supv.	Co. Supv.	Co. Supv.	State Senate	Lt. Governor	City Council	City Council	Office Holder Account - Local	Office Holder Account - Local	Office Holder Account - Local	Office Holder Account - Local	Mayor	Mayor	City Council	Mayor	None	Co. Supv.	State House	Co. Bd. of Supv.	State House	State House	State House	Co. Bd. of Supv.	City Council	Co. Bd. of Supv.	City Council	State House	City Council	City Council	State Senate	Co. Supv.	City Council	State Senate	State House	State House	None	None	City Council
juris_cd	ASM	CTY	CIT	CTY	CIT	ASM	CIT	CIT	SEN	CTY	CIT	SEN	ASM	ASM	None	None	CIT	OTH	CIT	OTH	CIT	OTH	OTH	CTY	OTH	ASM	OTH	OTH	CIT	ASM	ASM	CIT	CIT	CIT	CIT	CIT	CIT	SEN	ASM	CIT	OTH	CTY	ASM	CIT	CIT	ASM	OTH	ASM	CIT	SEN	CIT	OTH	CIT	OTH	CIT	SEN	SEN	CIT	CIT	CIT	ASM	ASM	CIT	ASM	ASM	OTH	STW	STW	ASM	STW	CTY	CTY	CTY	SEN	STW	CIT	CIT	OTH	OTH	OTH	OTH	CIT	CIT	CIT	CIT	None	CTY	ASM	CTY	ASM	ASM	OTH	CIT	OTH	CIT	OTH	OTH	CTY	OTH	ASM	OTH	OTH	CIT	ASM	ASM	CIT	CIT	CIT	CIT	CIT	CIT	SEN	ASM	CIT	OTH	CTY	ASM	CIT	CIT	ASM	OTH	ASM	CIT	SEN	CIT	OTH	CIT	OTH	CIT	SEN	SEN	CIT	CIT	CIT	ASM	ASM	CIT	ASM	ASM	OTH	STW	STW	ASM	STW	CTY	CTY	CTY	SEN	STW	CIT	CIT	OTH	OTH	OTH	OTH	CIT	CIT	CIT	CIT	None	CTY	ASM	CTY	ASM	ASM	ASM	CTY	CIT	CTY	CIT	ASM	CIT	CIT	SEN	CTY	CIT	SEN	ASM	ASM	None	None	CIT
juris_dscr	None	San Joaquin Dist 4	Anaheim - Dist 2	Orange - Dist 2	Garden Grove Dist 1	None	San Jose Dist 1	San Jose Dist 1	None	San Mateo - Dist 3	Rosemead	None	None	None	None	None	Whittier Dist 2	Local PAC	Richmond	Orange	San Jose	State Multi-Issue Cmte	Danville Town	Contra Costa	Danville	None	State PAC	State PAC	Long Beach 8	None	None	Rosemead City	Long Beach Dist. 7	Antioch City Dist 4	Rosemead City	Bell City	Commerce City	None	None	Inglewood 2	Long Beach	San Joaquin Dist 2	None	San Jose 7	Antioch Dist 4	None	Long Beach, Dist 4	None	Stockton Dist 3	None	Bell AL	Santa Clara 4	Stockton Dist 1	Contra Costa Cnty	San Jose 9	None	None	06	06	Anaheim City	None	None	San Ramon City	None	None	Office Holder Account - State	None	None	None	None	Sacramento Co.	Dist 04 - Contra Costa	Cnty Comm Dist 1	None	None	Anaheim - Dist 3	Fullerton City - Dist 5	Office Holder Account - Local	Office Holder Account - Local	Office Holder Account - Local	Long Beach - Dist 6	San Jose	San Jose	San Jose Dist 5	San Jose	None	Orange - Dist 2	None	Santa Clara Dist 1	None	None	Local PAC	Richmond	Orange	San Jose	State Multi-Issue Cmte	Danville Town	Contra Costa	Danville	None	State PAC	State PAC	Long Beach 8	None	None	Rosemead City	Long Beach Dist. 7	Antioch City Dist 4	Rosemead City	Bell City	Commerce City	None	None	Inglewood 2	Long Beach	San Joaquin Dist 2	None	San Jose 7	Antioch Dist 4	None	Long Beach, Dist 4	None	Stockton Dist 3	None	Bell AL	Santa Clara 4	Stockton Dist 1	Contra Costa Cnty	San Jose 9	None	None	06	06	Anaheim City	None	None	San Ramon City	None	None	Office Holder Account - State	None	None	None	None	Sacramento Co.	Dist 04 - Contra Costa	Cnty Comm Dist 1	None	None	Anaheim - Dist 3	Fullerton City - Dist 5	Office Holder Account - Local	Office Holder Account - Local	Office Holder Account - Local	Long Beach - Dist 6	San Jose	San Jose	San Jose Dist 5	San Jose	None	Orange - Dist 2	None	Santa Clara Dist 1	None	None	None	San Joaquin Dist 4	Anaheim - Dist 2	Orange - Dist 2	Garden Grove Dist 1	None	San Jose Dist 1	San Jose Dist 1	None	San Mateo - Dist 3	Rosemead	None	None	None	None	None	Whittier Dist 2
dist_no	70	None	None	None	None	62	None	None	36	None	None	38	51	39	None	None	None	None	None	None	None	None	None	None	None	65	None	None	None	62	61	None	None	None	None	None	None	36	54	None	None	None	59	None	None	26	None	48	None	29	None	None	None	None	None	22	30	None	None	None	78	16	None	38	30	None	None	None	44	None	None	None	None	20	None	None	None	None	None	None	None	None	None	None	None	None	None	27	None	64	11	None	None	None	None	None	None	None	None	65	None	None	None	62	61	None	None	None	None	None	None	36	54	None	None	None	59	None	None	26	None	48	None	29	None	None	None	None	None	22	30	None	None	None	78	16	None	38	30	None	None	None	44	None	None	None	None	20	None	None	None	None	None	None	None	None	None	None	None	None	None	27	None	64	11	70	None	None	None	None	62	None	None	36	None	None	38	51	39	None	None	None
off_s_h_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	Yes on E Committee for Excellent Milpitas Schools	Safe Strong Torrance - Yes on SST	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Stop the #Karen Recall of Mayor Lamar Thorpe 2022	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Stop the #Karen Recall of Mayor Lamar Thorpe 2022	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Yes on E Committee for Excellent Milpitas Schools	Safe Strong Torrance - Yes on SST	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	Antioch	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Antioch	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	Local	Local	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Local	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Local	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Local	Local	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	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	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
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	None	None	None	None	None	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	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
g_from_e_f	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	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	None	None	None	None	None	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: filer_filings
filer_id	1009302	1009302
filing_id	2703621	2703621
period_id	249	249
form_id	F461	F461
filing_sequence	0	1
filing_date	2022-07-29 00:00:00	2022-10-12 00:00:00
stmnt_type	10001	10002
stmnt_status	11001	11001
session_id	2021	2021
user_id	GTAYLOR	GTAYLOR
special_audit	11003	11003
fine_audit	11001	11001
rpt_start	2022-01-01 00:00:00	2022-01-01 00:00:00
rpt_end	2022-06-30 00:00:00	2022-06-30 00:00:00
rpt_date	2022-07-29 00:00:00	2022-10-11 00:00:00
filing_type	22001	22001

Table: filings
filing_id		2703621
filing_type		22001

Table: hdr
filing_id	2703621	2703621
amend_id	0	1
rec_type	HDR	HDR
ef_type	CAL	CAL
state_cd	CA	CA
cal_ver	2.01	2.01
soft_name	PASSCFS	PASSCFS
soft_ver	3.0	3.0
hdrcomment	None	None

Table: received_filings
filer_id		1009302
filing_file_name		2703621_1.cal
received_date		2022-10-12 00:00:00
filing_directory		/cafiler/disclose/ca99/cal
filing_id		2703621
form_id		F461
receive_comment		Filing accepted

Table: smry
filing_id	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621	2703621
amend_id	0	0	0	0	1	1	1	1	1
line_item	2	3	4	5	1	2	3	4	5
rec_type	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY
form_type	F461	F461	F461	F461	F461	F461	F461	F461	F461
amount_a	0	131450	0	131450	131450	0	131450	0	131450
amount_b	None	None	None	None	None	None	None	None	None
amount_c	None	None	None	None	None	None	None	None	None
elec_dt	None	None	None	None	None	None	None	None	None