Home

Filing ID: 2443618

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

Table: cvr3_verification_info

filing_id		2443618		2443618		2443618
amend_id		1		2		0
line_item		1		1		1
rec_type		CVR3		CVR3		CVR3
form_type		F461		F461		F461
tran_id		VER_1.1		VER_1.1		VER_1.1
entity_cd		OFF		OFF		OFF
sig_date		2020-03-04 00:00:00		2020-11-05 00:00:00		2020-01-31 00:00:00
sig_loc		None		None		None
sig_naml		JAMES W. CARSON		JAMES W. CARSON		JAMES W. CARSON
sig_namf		None		None		None
sig_namt		None		None		None
sig_nams		None		None		None

Table: cvr_campaign_disclosure

filing_id		2443618		2443618		2443618
amend_id		0		1		2
rec_type		CVR		CVR		CVR
form_type		F461		F461		F461
filer_id		490012		490012		490012
entity_cd		MDI		MDI		MDI
filer_naml		GENENTECH INC. A MEMBER OF THE ROCHE GROUP		GENENTECH INC. A MEMBER OF THE ROCHE GROUP		GENENTECH INC. A MEMBER OF THE ROCHE GROUP
filer_namf		None		None		None
filer_namt		None		None		None
filer_nams		None		None		None
report_num		000		001		002
rpt_date		2020-01-31 00:00:00		2020-03-04 00:00:00		2020-11-05 00:00:00
stmt_type		None		None		None
late_rptno		None		None		None
from_date		2019-10-01 00:00:00		2019-10-01 00:00:00		2019-10-01 00:00:00
thru_date		2019-12-31 00:00:00		2019-12-31 00:00:00		2019-12-31 00:00:00
elect_date		None		None		None
filer_city		SAN RAFAEL		SAN RAFAEL		SAN RAFAEL
filer_st		CA		CA		CA
filer_zip4		94901		94901		94901
filer_phon		(415) 389-6800		(415) 389-6800		(415) 389-6800
filer_fax		None		None		None
file_email		None		None		None
mail_city		None		None		None
mail_st		None		None		None
mail_zip4		None		None		None
tres_naml		CARSON, ATTY/AGENT FOR FILER		CARSON, ATTY/AGENT FOR FILER		CARSON, ATTY/AGENT FOR FILER
tres_namf		JAMES W.		JAMES W.		JAMES W.
tres_namt		None		None		None
tres_nams		None		None		None
tres_city		None		None		None
tres_st		None		None		None
tres_zip4		None		None		None
tres_phon		(415) 389-6800		(415) 389-6800		(415) 389-6800
tres_fax		None		None		None
tres_email		None		None		None
cmtte_type		None		None		None
control_yn		N		N		N
sponsor_yn		N		N		N
primfrm_yn		N		N		N
brdbase_yn		N		N		N
amendexp_1		None		AMENDMENT TO REMOVE CONTRIBUTION - NEVER NEGOTIATED		AMENDMENT TO REMOVE CONTRIBUTION
amendexp_2		None		None		None
amendexp_3		None		None		None
rpt_att_cb		None		None		None
cmtte_id		None		None		None
reportname		None		None		None
rptfromdt		None		None		None
rptthrudt		None		None		None
emplbus_cb		None		None		None
bus_name		None		None		None
bus_city		None		None		None
bus_st		None		None		None
bus_zip4		None		None		None
bus_inter		None		None		None
busact_cb		X		X		X
busactvity		WHOLESALER OF HUMAN PHARMACEUTICALS		WHOLESALER OF HUMAN PHARMACEUTICALS		WHOLESALER OF HUMAN PHARMACEUTICALS
assoc_cb		None		None		None
assoc_int		None		None		None
other_cb		None		None		None
other_int		None		None		None
cand_naml		None		None		None
cand_namf		None		None		None
cand_namt		None		None		None
cand_nams		None		None		None
cand_city		None		None		None
cand_st		None		None		None
cand_zip4		None		None		None
cand_phon		None		None		None
cand_fax		None		None		None
cand_email		None		None		None
bal_name		None		None		None
bal_num		None		None		None
bal_juris		None		None		None
office_cd		None		None		None
offic_dscr		None		None		None
juris_cd		None		None		None
juris_dscr		None		None		None
dist_no		None		None		None
off_s_h_cd		None		None		None
sup_opp_cd		None		None		None
employer		None		None		None
occupation		None		None		None
selfemp_cb		None		None		None
bal_id		None		None		None
cand_id		None		None		None

Table: expn

filing_id		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618
amend_id		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		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2
line_item		5		6		7		8		9		10		11		12		13		14		15		16		17		18		1		2		3		4		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16
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
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
tran_id		EXP730		EXP731		EXP732		EXP733		EXP734		EXP735		EXP736		EXP737		EXP738		EXP739		EXP740		EXP741		EXP743		EXP744		EXP727		EXP728		EXP745		EXP729		EXP727		EXP728		EXP745		EXP729		EXP731		EXP732		EXP733		EXP734		EXP735		EXP736		EXP737		EXP738		EXP739		EXP740		EXP741		EXP743		EXP744		EXP727		EXP728		EXP745		EXP729		EXP731		EXP732		EXP733		EXP734		EXP735		EXP736		EXP737		EXP738		EXP739		EXP740		EXP743		EXP744
entity_cd		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
payee_naml		HERTZBERG FOR SENATE 2018 OFFICEHOLDER ACCOUNT		MALIA COHEN FOR STATE BOARD OF EQUALIZATION 2022		RENDON FOR ASSEMBLY 2020		OCEANSIDE CHAMBER OF COMMERCE BUSINESS AND COMMUNITY POLITICAL ACTION COMMITTEE		BECERRA FOR ATTORNEY GENERAL 2022		CALIFORNIA LATINO CAUCUS LEADERSHIP PAC		GIPSON FOR ASSEMBLY 2020		LENA GONZALEZ FOR SENATE 2020		LORENA GONZALEZ FOR ASSEMBLY 2020		RODRIGUEZ FOR ASSEMBLY 2020		RUDY SALAS FOR ASSEMBLY 2020		SENATOR BEN HUESO OFFICEHOLDER ACCOUNT 2018		SKINNER FOR SENATE 2020		CALIFORNIA AFRICAN AMERICAN PAC		BAY AREA COUNCIL POLITICAL ACTION COMMITTEE		WALDRON FOR ASSEMBLY 2020		BUSINESS & COMMUNITY ACTION COMMITTEE OF VACAVILLE CHAMBER OF COMMERCE		BAY AREA LEGISLATIVE LEADERS PAC		BAY AREA COUNCIL POLITICAL ACTION COMMITTEE		WALDRON FOR ASSEMBLY 2020		BUSINESS & COMMUNITY ACTION COMMITTEE OF VACAVILLE CHAMBER OF COMMERCE		BAY AREA LEGISLATIVE LEADERS PAC		MALIA COHEN FOR STATE BOARD OF EQUALIZATION 2022		RENDON FOR ASSEMBLY 2020		OCEANSIDE CHAMBER OF COMMERCE BUSINESS AND COMMUNITY POLITICAL ACTION COMMITTEE		BECERRA FOR ATTORNEY GENERAL 2022		CALIFORNIA LATINO CAUCUS LEADERSHIP PAC		GIPSON FOR ASSEMBLY 2020		LENA GONZALEZ FOR SENATE 2020		LORENA GONZALEZ FOR ASSEMBLY 2020		RODRIGUEZ FOR ASSEMBLY 2020		RUDY SALAS FOR ASSEMBLY 2020		SENATOR BEN HUESO OFFICEHOLDER ACCOUNT 2018		SKINNER FOR SENATE 2020		CALIFORNIA AFRICAN AMERICAN PAC		BAY AREA COUNCIL POLITICAL ACTION COMMITTEE		WALDRON FOR ASSEMBLY 2020		BUSINESS & COMMUNITY ACTION COMMITTEE OF VACAVILLE CHAMBER OF COMMERCE		BAY AREA LEGISLATIVE LEADERS PAC		MALIA COHEN FOR STATE BOARD OF EQUALIZATION 2022		RENDON FOR ASSEMBLY 2020		OCEANSIDE CHAMBER OF COMMERCE ADVANCE OCEANSIDE POLITICAL ACTION COMMITTEE		BECERRA FOR ATTORNEY GENERAL 2022		CALIFORNIA LATINO CAUCUS LEADERSHIP PAC		GIPSON FOR ASSEMBLY 2020		LENA GONZALEZ FOR SENATE 2020		LORENA GONZALEZ FOR ASSEMBLY 2020		RODRIGUEZ FOR ASSEMBLY 2020		RUDY SALAS FOR ASSEMBLY 2020		SKINNER FOR SENATE 2020		CALIFORNIA AFRICAN AMERICAN PAC
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
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
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
payee_city		ENCINO		SACRAMENTO		SACRAMENTO		OCEANSIDE		LOS ANGELES		LOS ANGELES		INGLEWOOD		LONG BEACH		CHULA VISTA		POMONA		BAKERSFIELD		ENCINITAS		SACRAMENTO		LOS ANGELES		SAN FRANCISCO		SAN DIEGO		VACAVILLE		SACRAMENTO		SAN FRANCISCO		SAN DIEGO		VACAVILLE		SACRAMENTO		SACRAMENTO		SACRAMENTO		OCEANSIDE		LOS ANGELES		LOS ANGELES		INGLEWOOD		LONG BEACH		CHULA VISTA		POMONA		BAKERSFIELD		ENCINITAS		SACRAMENTO		LOS ANGELES		SAN FRANCISCO		SAN DIEGO		VACAVILLE		SACRAMENTO		SACRAMENTO		SACRAMENTO		OCEANSIDE		LOS ANGELES		LOS ANGELES		INGLEWOOD		LONG BEACH		CHULA VISTA		POMONA		BAKERSFIELD		SACRAMENTO		LOS ANGELES
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
payee_zip4		91436		95815		95814		92054		90017		90017		90301		90802		91911		91766		93314		92024		95815		90017		94111		92119		95688		95841		94111		92119		95688		95841		95815		95814		92054		90017		90017		90301		90802		91911		91766		93314		92024		95815		90017		94111		92119		95688		95841		95815		95814		92054		90017		90017		90301		90802		91911		91766		93314		95815		90017
expn_date		2019-11-21 00:00:00		2019-11-21 00:00:00		2019-11-21 00:00:00		2019-11-27 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-12 00:00:00		2019-10-07 00:00:00		2019-10-17 00:00:00		2019-11-18 00:00:00		2019-11-21 00:00:00		2019-10-07 00:00:00		2019-10-17 00:00:00		2019-11-18 00:00:00		2019-11-21 00:00:00		2019-11-21 00:00:00		2019-11-21 00:00:00		2019-11-27 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-12 00:00:00		2019-10-07 00:00:00		2019-10-17 00:00:00		2019-11-18 00:00:00		2019-11-21 00:00:00		2019-11-21 00:00:00		2019-11-21 00:00:00		2019-11-27 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-04 00:00:00		2019-12-12 00:00:00
amount		1000		1000		3700		2500		5000		10000		1500		1500		1500		1500		1500		1500		1000		10000		5000		2000		2500		10000		5000		2000		2500		10000		1000		3700		2500		5000		10000		1500		1500		1500		1500		1500		1500		1000		10000		5000		2000		2500		10000		1000		3700		2500		5000		10000		1500		1500		1500		1500		1500		1000		10000
cum_ytd		1000		1000		4700		2500		5000		10000		4000		1500		3500		3500		3500		3500		1000		10000		5000		2000		2500		20000		5000		2000		2500		20000		1000		4700		2500		5000		10000		4000		1500		3500		3500		3500		3500		1000		10000		5000		2000		2500		20000		1000		4700		2500		5000		10000		4000		1500		3500		3500		3500		1000		10000
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
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
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
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
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
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
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
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
cmte_id		1414093		1414911		1414788		1260474		1414167		1321501		1414387		1414677		1414350		1414249		1414982		1415418		1392539		1383298		1285523		1414619		982833		1377585		1285523		1414619		982833		1377585		1414911		1414788		1260474		1414167		1321501		1414387		1414677		1414350		1414249		1414982		1415418		1392539		1383298		1285523		1414619		982833		1377585		1414911		1414788		1260474		1414167		1321501		1414387		1414677		1414350		1414249		1414982		1392539		1383298
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
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
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
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
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
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
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
cand_naml		ROBERT HERTZBERG		MALIA COHEN		ANTHONY RENDON		GENERAL PURPOSE COMMITTEE		XAVIER BECERRA		GENERAL PURPOSE COMMITTEE		MIKE GIPSON		LENA GONZALEZ		LORENA GONZALEZ		FREDDIE RODRIGUEZ		RUDY SALAS		BEN HUESO		NANCY SKINNER		GENERAL PURPOSE COMMITTEE		GENERAL PURPOSE COMMITTEE		MARIE WALDRON		GENERAL PURPOSE COMMITTEE		GENERAL PURPOSE COMMITTEE		GENERAL PURPOSE COMMITTEE		MARIE WALDRON		GENERAL PURPOSE COMMITTEE		GENERAL PURPOSE COMMITTEE		MALIA COHEN		ANTHONY RENDON		GENERAL PURPOSE COMMITTEE		XAVIER BECERRA		GENERAL PURPOSE COMMITTEE		MIKE GIPSON		LENA GONZALEZ		LORENA GONZALEZ		FREDDIE RODRIGUEZ		RUDY SALAS		BEN HUESO		NANCY SKINNER		GENERAL PURPOSE COMMITTEE		GENERAL PURPOSE COMMITTEE		MARIE WALDRON		GENERAL PURPOSE COMMITTEE		GENERAL PURPOSE COMMITTEE		MALIA COHEN		ANTHONY RENDON		GENERAL PURPOSE COMMITTEE		XAVIER BECERRA		GENERAL PURPOSE COMMITTEE		MIKE GIPSON		LENA GONZALEZ		LORENA GONZALEZ		FREDDIE RODRIGUEZ		RUDY SALAS		NANCY SKINNER		GENERAL PURPOSE COMMITTEE
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
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
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
office_cd		SEN		BOE		ASM		None		ATT		None		ASM		SEN		ASM		ASM		ASM		SEN		SEN		None		None		ASM		None		None		None		ASM		None		None		BOE		ASM		None		ATT		None		ASM		SEN		ASM		ASM		ASM		SEN		SEN		None		None		ASM		None		None		BOE		ASM		None		ATT		None		ASM		SEN		ASM		ASM		ASM		SEN		None
offic_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		SEN		BOE		ASM		OTH		STW		None		ASM		SEN		ASM		ASM		ASM		SEN		SEN		None		None		ASM		OTH		None		None		ASM		OTH		None		BOE		ASM		OTH		STW		None		ASM		SEN		ASM		ASM		ASM		SEN		SEN		None		None		ASM		OTH		None		BOE		ASM		OTH		STW		None		ASM		SEN		ASM		ASM		ASM		SEN		None
juris_dscr		None		None		None		CITY OF OCEANSIDE		None		None		None		None		None		None		None		None		None		None		None		None		CITY OF VACAVILLE		None		None		None		CITY OF VACAVILLE		None		None		None		CITY OF OCEANSIDE		None		None		None		None		None		None		None		None		None		None		None		None		CITY OF VACAVILLE		None		None		None		CITY OF OCEANSIDE		None		None		None		None		None		None		None		None		None
dist_no		18		2		63		None		None		None		64		33		80		52		32		40		09		None		None		75		None		None		None		75		None		None		2		63		None		None		None		64		33		80		52		32		40		09		None		None		75		None		None		2		63		None		None		None		64		33		80		52		32		09		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
bal_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
bal_juris		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
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
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
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
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

Table: filer_filings

filer_id		1011783		1011783		1011783
filing_id		2443618		2443618		2443618
period_id		240		240		240
form_id		F461		F461		F461
filing_sequence		1		2		0
filing_date		2020-03-06 00:00:00		2020-11-06 00:00:00		2020-01-31 00:00:00
stmnt_type		10002		10002		10001
stmnt_status		11001		11001		11001
session_id		2019		2019		2019
user_id		GTAYLOR		GTAYLOR		GTAYLOR
special_audit		11003		11003		11003
fine_audit		11001		11001		11001
rpt_start		2019-10-01 00:00:00		2019-10-01 00:00:00		2019-10-01 00:00:00
rpt_end		2019-12-31 00:00:00		2019-12-31 00:00:00		2019-12-31 00:00:00
rpt_date		2020-03-04 00:00:00		2020-11-05 00:00:00		2020-01-31 00:00:00
filing_type		22001		22001		22001

Table: filings

filing_id		2443618
filing_type		22001

Table: hdr

filing_id		2443618		2443618		2443618
amend_id		0		1		2
rec_type		HDR		HDR		HDR
ef_type		CAL		CAL		CAL
state_cd		CA		CA		CA
cal_ver		2.01		2.01		2.01
soft_name		NETFILE		NETFILE		NETFILE
soft_ver		199272		199279		199284
hdrcomment		None		None		None

Table: smry

filing_id		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618		2443618
amend_id		1		1		1		1		1		0		0		0		0		0		2		2		2		2		2
line_item		1		2		3		4		5		1		2		3		4		5		1		2		3		4		5
rec_type		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY
form_type		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461
amount_a		61700		0		61700		195800		257500		62700		0		62700		195800		258500		60200		0		60200		195800		256000
amount_b		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amount_c		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
elec_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None