Home

Filing ID: 1979902

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

Table: cvr3_verification_info

filing_id		1979902
amend_id		0
line_item		1
rec_type		CVR3
form_type		F461
tran_id		635736981968830015
entity_cd		OFF
sig_date		2015-07-28 00:00:00
sig_loc		None
sig_naml		Knight
sig_namf		J.
sig_namt		None
sig_nams		None

Table: cvr_campaign_disclosure

filing_id		1979902
amend_id		0
rec_type		CVR
form_type		F461
filer_id		488235
entity_cd		MDI
filer_naml		Sempra Energy Formerly Sempra Energy and its Affiliates San Diego Gas & Electric and So. Cal. Gas
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2015-07-28 00:00:00
stmt_type		None
late_rptno		None
from_date		2015-04-01 00:00:00
thru_date		2015-06-30 00:00:00
elect_date		None
filer_city		San Diego
filer_st		CA
filer_zip4		92101
filer_phon		(619) 696-4650
filer_fax		None
file_email		None
mail_city		San Diego
mail_st		CA
mail_zip4		92101
tres_naml		Knight
tres_namf		J.
tres_namt		None
tres_nams		None
tres_city		None
tres_st		None
tres_zip4		None
tres_phon		None
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		X
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: expn

filing_id		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902		1979902
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		0		0		0		0		0		0		0		0		0
line_item		1		5		6		7		8		12		16		17		18		19		20		21		22		23		24		26		32		35		37		40		44		45		47		49		50		57		58		61		52		53		54		55		56		59		60		62		63		64		119		120		121		122		123		124		125		126		127		2		3		4		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		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		154		155		156		157		158		159		160		9		10		11		13		14		15		25		27		28		29		30		31		33		34		36		38		39		41		42		43		46		48		51		97		98		99		100		101		102		103		104		105		106		107		108		109		110		111		112		113		114		115		116		117		118		161		162
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
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
tran_id		54fb911228d0009605f		291a92c406c966dd62e		1d7f012c44db9eb9af3		1f60a023b1163b33714		96f4742aac6f33c3a47		57b1fb4f81ca5e78d02		c02f59db2d3fd60b129		8bac7a25b7167941b6f		bbeef32002151b17b1a		031c40979f305c4cb44		72ebb3b87fc1fc6ee40		8ea8f187f0f177e7402		ff960655fae3eea2af7		8f0d76c4a8f7c585be4		8a1671581da07e15903		8ed6376d7eb700314b1		544dee8e9ab7864f8aa		57d071b0b122fd9101e		3218e8746ba663960a4		a9ea37d3f5700240900		58b0de81d32c978c118		b88424d21abde57117a		4b7ca53786edb9b1f90		1aa355f95af5b0113b7		8dedf1daa918a87a04d		8d1a478b73c08af59be		c9984b93e05f662fef3		fe4e64bde0dbaec78da		b6637946d911194fa6f		259cb76a87a714b6096		4e1ac0b9a6516e404d7		39974b433398eecd89c		b71991a03c9d3d82f54		4fe2492291caf0b0776		527280c66c5bb9c0b74		bec417e00ae1fef24e3		d8d1541d11c2e5cbcef		75eec49a48e42a55913		9b2124f40fb47e14df0		fc19fcdcaabe15594d5		2dc423193a4ea341b9f		bf218bdba74ca96865e		d2f17f38cd46c2cd800		43a915317169a94a17a		bc69ee24c479c438946		f7999979798b74a02a8		12e162324993a1b5a44		c370c2f5f19c93792eb		3ecca212528fabf71fd		b54a007155782a53262		eab81bb80e0b2454b44		c539a8138c3eac5598a		4294c458ca727e26f7c		f5b2409a2d305512b2b		2023bc9bf531e878a99		ad9bb34f55e6b16a2c2		8dde1669bf5009260e2		0406ea1324dbf65ce4f		04d78a0ad7b5f07c344		9cd56ff296cd3332e98		20572f3fa5810181bbe		df34f3eb94bb6710ad6		bff6a8dc5021712c051		3046f58438de4cf3670		2a6af6e561081ac6c87		e4cbd3ba447330b93e8		aecfa705658ba5630a5		4aa49e41ed81ed3156e		cc39353f77d602014ca		916aa279ddc37d1a00c		51899a7da616aea50d0		fb210572f8798584cbc		3d24af7e3c708c8039a		87ac341cfac4aa27f3f		2f4d5a3d840740248a7		866313dc0fc233ba7a2		4bc51e03c8c802b2c53		dc3360d689f214333cb		4cf7bde3e97c0e9325e		1b0c73694f618374e51		0b2c62b0acd3ae4250b		4348e18d6fc66935df1		350e08a19ccb5acce3f		bf2faddda56de6970c2		a60e049ce4307f1b3fa		ba26b273e2275ce2ce6		a710e259d1a4987f9a7		525ce004188259718a6		c640ba181301d3ce756		1f6ffcc2abade82f0f9		3429620be267c0d7405		4febbb6371728b8b8e3		d1dd1a1403cc46f9cba		62bdc82bce2275dc15f		2c3ba28714c4654f65f		32e91110f6d464ba4bb		99e3292f4f1c21feab8		82e0dadea17369db67d		12cbd85e2e2ff025775		3f897c868d631159333		4c2fd15800aa7aa684b		ee1bfaad4430f432350		81da539a324967f39cc		5794668085e1810d511		da6f2ab72c8ad74f0d1		4654a14794d07f8bc28		f1c546fb65c0db9b7ae		e4135b229e86d50d851		293fa680f20c5017347		82ead5eca2169253c86		185a918a6cd2cd5620c		b127d1cf1e9441cffd5		bffd9fd6e865858458a		281d015bfab571a2918		d59b11d6d1bb92e0585		f520a48508d4ba394e2		c2f7c8e395c1733c30a		f2a80a6aacda8e4efbd		123fc278fe4b2686500		288f678c87bb9c3c016		05e4d8ed9e4cea13a14		c4c07547763d9776832		b7d808f5052aa9a8c63		43aa29b3e7c3d500728		f2cca337632adb68b30		c3515da68c669fec04d		2aa4fe0f20f82c879d7		48b689028a45ac12e29		3bf67c4bfd9020bed30		9a1d0a5d7af313fe9e9		5a7ecbf9aaec8135a33		b27d0d5cc405922c523		e8f8644b98e75f4d1c6		b5b77dc2cc7f92f1956		4554d6faf7520e5aad9		663767b0d20f190a6fa		922f0ed07fe661de4e4		b3131cc9f588f1ecb04		3d57ff5deef6f09e71c		b0912fecf6ee96048c8		ff80b2d8e4807f276d3		12704501f6daccefbca		9c39366bc7b6c5cf251		ac39b74a15cd33e4c33		46863424d4d08d94f49		5f36458ab739b13ff77		998c9da0489aaca7ff8		34a2d77701f132e3b4a		a87d8e4fc91a2c1ce3b		df5cbb0315c7ff1177a		fdc9ec4ac9a5f0a500d		99afc1ee096bc8cc78b		5c6a0365eda32a5c622		497876e4621b436d02c		68b633983c5d78e4178		dafe361fec6977bd950		fb1c38e2dfbd43ba37a		187b3271976c0cf598c		d03c5b80b4163145adc		7f41dc337f910b937f2		48be105f6b6f67b9db5		7da5f789ebf4a36a33c
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
payee_naml		Adam Gray for Assembly 2016		Aja Brown Vision for Compton Fund 2017		Andrew Do for Supervisor 2015		Andy Vidak for Senate 2018		Anthony Rendon for Assembly 2016		Atkins for Senate 2020		Bill Dodd for Assembly 2016		Bill Quirk for Assembly 2012		Bob Huff Assembly 2016		Bradford for Senate 2016		Brian Dahle for Assembly 2016		Building Industry Association of Southern California		California Asian Chamber of Commerce Issues PAC		Californians for Jobs and a Strong Economy		Castro for Lynwood City Council 2015		Catharine Baker for Assembly 2016		Cheryl Brown for Assembly 2016		Coachella - Imperial Valley Strategies Political Action		Community Leaders of America		Dr. Jim Wood for Assembly 2016		Ed Chau for Assembly 2016		Ed Chau for Assembly 2016		EGGMAN FOR ASSEMBLY 2016		Evan Low for Assembly 2016		Evan Low for Assembly 2016		Garcia for Assembly 2016		Garcia for Assembly 2016		Gipson for Assembly 2016		Friends of Frank Bigelow for Assembly 2016		Friends of James Ramos for San Bernardino County Third District Supervisor - 2016		Friends of Jimmy Gomez for Assembly 2016		Gaines for Senate 2016		Gaines for Senate 2016		Getting CA Back to Work Ballot Measure Committee		Gipson for Assembly 2016		Hall for Senate 2016		Henry Nickel for City Council in San Bernardino 5th Ward		Ian Calderon for Assembly 2016		Pat Bates for Senate 2018		Patrick O'Donnell fr Assembly 2016		Patterson for Assembly 2016		Patterson for Assembly 2016		Perea Reviving Jobs and the Economy Ballot Measure Committee		Phil Ting for Assembly 2016		Phil Ting for Assembly 2016		Phil Ting for Assembly 2016		Phil Ting for Assembly 2016		Adam Gray for Assembly 2016		Adam Gray for Assembly 2016		African American & Union Voter Registration, Education, & Participation Project		Ian Calderon for Assembly 2016		Jack Hadjinian for Montebello City Council 2015		Jacqui Irwin for State Assembly 2016		James Gallagher for Assembly 2016		Janet Nguyen for Senate 2018		Jay Obernolte for Assembly		Jean Fuller for Assembly 2018		Jerry Hill for Senate 2016		Jerry Kern for Assembly		Jim Cooper for Assembly 2016		Jim Cooper for Assembly 2016		Jim Cooper for Assembly 2016		Jim Frazier for Assembly 2016		Joaquin Arambula for Assembly 2016		Jones for Senate 2018		Jones-Sawyer for Assebmly 2016		Jones-Sawyer for Assebmly 2016		Jose Medina for Assembly 2016		Josie Gonzales for Supervisor		Kansen Chu for Assembly 2016		Karina Cervantez Alejo for Assembly 2016		Karina Cervantez Alejo for Assembly 2016		Ken Cooley for Assembly 2016		Kevin de Leon for Lieutenant Governor 2018		Kevin de Leon for Lieutenant Governor 2018		Levine for Assembly		LGBT Caucus Leadership Fund		Ling-Ling Chang for Assembly 2014		Ling-Ling Chang for Assembly 2016		Lorena Gonzalez for Assembly 2016		Lorena Gonzalez for Assembly 2016		Lorena Gonzalez for Assembly 2016		Re-Elect Senator Wieckowski for Senate 2018		Re-Elect Senator Wieckowski for Senate 2018		Ricardo Lara for Senate 2016		Rob Bonta for Assembly 2016		Rob Bonta for Assembly 2016		Robert Hertzberg for Senate 2018		Rocky Chavez for Assembly 2012		Rodriguez for Assembly 2016		Roth USAF (Ret.) for Senate 2016		Roth USAF (Ret.) for Senate 2016		Roth USAF (Ret.) for Senate 2016		Rudy Salas for Assembly 2016		Rudy Salas for Assembly 2016		Rudy Salas for Assembly 2016		Rudy Salas for Assembly 2016		Sebastian Ridley-Thomas for Assembly 2016		Sharon Runner for Senate 2016		Stern for Senate 2016		Todd Gloria for Assembly 2016		Tom Daly for Assembly 2016		Tom Daly for Assembly 2016		Tom Daly for Assembly 2016		Tony Thurmond for Assembly 2016		Tony Thurmond for Assembly 2016		Travis Allen for Assembly		Travis Allen for Assembly		Victoria Martinez for Council 2015		Wagner for Senate 2015		Waldron for Assembly 2016		Waldron for Assembly 2016		Women in Power		Young Kim for Assembly 2016		Young Kim for Assembly 2016		Anthony Rendon for Assembly 2016		Anthony Rendon for Assembly 2016		Anthony Rendon for Assembly 2016		Autumn Burke for Assembly 2016		Bill Brough for State Assembly 2016		Bill Dodd for Assembly 2016		Catharine Baker for Assembly 2016		Central City Association PAC		Chad Mayes for Assembly		Cheryl Brown for Assembly 2016		Cheryl Brown for Assembly 2016		Cheryl Brown for Assembly 2016		Chris Holden for Assembly 2016		Christine Marick for City Council		Committee to Re-Elect Joh Valdivia City Council 2015		Connie Leyva for Senate 2018		David Hadley for Assembly 2014		Dr. Richard Pan for Senate 2014		Dr. Richard Pan for Senate 2014		Dr. Shirley Weber for Assembly 2016		EGGMAN FOR ASSEMBLY 2016		Eric Linder for Assembly 2016		FAIRPAC		Los Angeles Area Chamber of Commerce PAC		Maienschein for Assembly 2016		Maienschein for Assembly 2016		Marc Steinorth for Assembly 2016		Mark Stone for Assembly 2016		Matt Dababneh for Assembly 2016		Matthew Harper for Assembly 2016		McCarty for Assembly 2014		McCarty for Assembly 2016		Melissa Melendez for Assembly 2016		Melissa Melendez for Assembly 2016		Michael Gates for City Attorney		Miguel Santiago for Assembly		Miguel Santiago for Assembly		Mike Gatto for Senate 2016		Mike Morrell for Senate 2016		New Majority California PAC		Newsom for California Governor 2018		Olsen for Senate 2018		Olsen for Senate 2018		Olsen for Senate 2018		Orange County Business Council DBA Biz Pac		Young Kim for Assembly 2016		Young Kim for Assembly 2016
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
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
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
payee_city		Sacramento		Long Beach		Garden Grove		Willows		Sacramento		Encinitas		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Irvine		Sacramento		Sacramento		Los Angeles		Sacramento		Sacramento		Palm Desert		San Diego		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Oakdale		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		San Bernardino		Sacramento		Sacramento		Sacramento		Fresno		Fresno		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Los Angeles		Sacramento		Montebello		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		La Mesa		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		La Mesa		Sacramento		Sacramento		Sacramento		Oakdale		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		San Anselmo		Sacramento		Santa Ana		Santa Ana		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Los Angeles		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Encino		Sacramento		Sacramento		Encinitas		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Covina		Sacramento		San Diego		San Diego		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Los Angeles		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Brea		San Bernardino		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Los Angeles		La Mesa		La Mesa		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramentoq		Sacramentoq		Huntington Beach		Sacramento		Sacramento		Sacramento		Oakdale		San Diego		Sacramento		Sacramento		Sacramento		Sacramento		Irvine		Sacramento		Sacramento
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
payee_zip4		95814		90802		92840		95988		95814		92024		95814		95814		95814		95814		95814		92614		95811		95814		90010		95814		95814		92211		92101		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95631		95814		95814		95814		95814		95814		95814		92405		95814		95814		95814		93721		93721		95814		95814		95814		95814		95814		95814		95814		90043		95814		90640		95814		95814		95814		95814		95866		95814		91942		95814		95814		95814		95814		95814		91942		95814		95814		95814		95361		95814		95814		95814		95814		95814		95814		94960		95841		92705		92705		95814		95814		95814		95814		95814		90071		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		91436		95814		95814		92024		95814		95814		95814		95814		95814		95814		95814		91722		95833		92119		92119		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		90014		95814		95814		95814		95814		95814		92823		92410		95814		95814		95814		95814		95814		95814		95814		95814		90017		91942		91942		95814		95814		95814		95814		95814		95814		95814		95814		92649		95814		95814		95814		95361		92130		95814		95814		95814		95814		92614		95814		95814
expn_date		2015-05-11 00:00:00		2015-06-18 00:00:00		2015-06-09 00:00:00		2015-04-15 00:00:00		2015-04-03 00:00:00		2015-06-18 00:00:00		2015-05-01 00:00:00		2015-05-01 00:00:00		2015-05-01 00:00:00		2015-06-18 00:00:00		2015-05-11 00:00:00		2015-05-08 00:00:00		2015-05-28 00:00:00		2015-06-29 00:00:00		2015-04-14 00:00:00		2015-06-23 00:00:00		2015-06-09 00:00:00		2015-04-30 00:00:00		2015-05-08 00:00:00		2015-05-15 00:00:00		2015-04-14 00:00:00		2015-06-29 00:00:00		2015-06-24 00:00:00		2015-05-11 00:00:00		2015-06-18 00:00:00		2015-06-09 00:00:00		2015-06-24 00:00:00		2015-06-09 00:00:00		2015-04-30 00:00:00		2015-05-11 00:00:00		2015-04-14 00:00:00		2015-05-11 00:00:00		2015-05-11 00:00:00		2015-06-09 00:00:00		2015-05-01 00:00:00		2015-05-01 00:00:00		2015-06-09 00:00:00		2015-04-03 00:00:00		2015-06-24 00:00:00		2015-06-09 00:00:00		2015-05-11 00:00:00		2015-06-23 00:00:00		2015-06-29 00:00:00		2015-04-03 00:00:00		2015-04-03 00:00:00		2015-05-11 00:00:00		2015-05-13 00:00:00		2015-05-11 00:00:00		2015-06-09 00:00:00		2015-06-18 00:00:00		2015-05-13 00:00:00		2015-06-18 00:00:00		2015-04-15 00:00:00		2015-06-09 00:00:00		2015-05-11 00:00:00		2015-05-01 00:00:00		2015-06-29 00:00:00		2015-05-01 00:00:00		2015-06-18 00:00:00		2015-04-30 00:00:00		2015-06-23 00:00:00		2015-06-23 00:00:00		2015-04-03 00:00:00		2015-06-23 00:00:00		2015-05-11 00:00:00		2015-05-01 00:00:00		2015-06-24 00:00:00		2015-05-13 00:00:00		2015-05-13 00:00:00		2015-05-11 00:00:00		2015-06-23 00:00:00		2015-06-29 00:00:00		2015-05-11 00:00:00		2015-04-15 00:00:00		2015-06-23 00:00:00		2015-05-11 00:00:00		2015-06-23 00:00:00		2015-05-13 00:00:00		2015-06-23 00:00:00		2015-05-11 00:00:00		2015-06-19 00:00:00		2015-06-19 00:00:00		2015-04-15 00:00:00		2015-06-16 00:00:00		2015-04-15 00:00:00		2015-04-14 00:00:00		2015-06-09 00:00:00		2015-04-14 00:00:00		2015-05-08 00:00:00		2015-05-28 00:00:00		2015-06-18 00:00:00		2015-06-18 00:00:00		2015-06-29 00:00:00		2015-04-03 00:00:00		2015-06-09 00:00:00		2015-06-23 00:00:00		2015-06-23 00:00:00		2015-06-29 00:00:00		2015-06-19 00:00:00		2015-06-19 00:00:00		2015-06-19 00:00:00		2015-05-11 00:00:00		2015-06-09 00:00:00		2015-06-24 00:00:00		2015-04-03 00:00:00		2015-06-24 00:00:00		2015-05-08 00:00:00		2015-06-09 00:00:00		2015-06-09 00:00:00		2015-04-15 00:00:00		2015-05-01 00:00:00		2015-06-23 00:00:00		2015-06-29 00:00:00		2015-05-01 00:00:00		2015-05-01 00:00:00		2015-04-03 00:00:00		2015-04-15 00:00:00		2015-05-11 00:00:00		2015-04-30 00:00:00		2015-06-29 00:00:00		2015-04-30 00:00:00		2015-05-08 00:00:00		2015-06-18 00:00:00		2015-05-01 00:00:00		2015-04-14 00:00:00		2015-05-08 00:00:00		2015-06-09 00:00:00		2015-05-11 00:00:00		2015-05-22 00:00:00		2015-05-13 00:00:00		2015-05-01 00:00:00		2015-05-11 00:00:00		2015-05-01 00:00:00		2015-06-24 00:00:00		2015-06-23 00:00:00		2015-04-03 00:00:00		2015-05-11 00:00:00		2015-05-28 00:00:00		2015-06-18 00:00:00		2015-06-09 00:00:00		2015-06-18 00:00:00		2015-05-01 00:00:00		2015-05-01 00:00:00		2015-04-30 00:00:00		2015-06-09 00:00:00		2015-04-15 00:00:00		2015-06-23 00:00:00		2015-05-01 00:00:00		2015-05-01 00:00:00		2015-06-29 00:00:00		2015-04-15 00:00:00		2015-05-28 00:00:00		2015-06-24 00:00:00		2015-06-18 00:00:00		2015-05-22 00:00:00		2015-06-23 00:00:00		2015-05-08 00:00:00		2015-06-23 00:00:00		2015-06-24 00:00:00		2015-05-01 00:00:00		2015-06-09 00:00:00		2015-06-09 00:00:00
amount		400		250		400		2000		1300		4200		1000		1000		700		2000		1500		500		10000		25000		250		1500		700		1000		5000		1300		1000		1000		1500		1300		2000		1000		1500		1500		1500		150		1000		700		1300		5000		1500		1200		500		1300		400		1300		2000		2000		2000		2000		1300		900		400		900		1000		2500		1300		250		1000		1500		3000		1500		4200		1000		1000		3000		300		1200		2000		1300		2000		1500		1500		2000		500		1000		1000		1000		1300		1000		2000		1000		1000		1100		2000		1400		2000		600		1000		1000		600		1000		1300		1000		3000		100		800		200		1300		1300		1000		700		600		1000		1500		1500		4200		1300		1000		1300		1500		1500		1500		1500		250		2000		2000		2000		3000		1500		1500		2900		100		1300		2500		1500		2000		1500		2500		1500		1000		2500		800		1300		150		500		1000		2000		1000		1500		1300		1500		1500		5000		10000		1500		2000		1500		1000		1300		1500		1000		1300		1500		1500		300		1000		1000		1000		1500		10000		1000		2500		2300		200		1000		1200		300
cum_ytd		6100		250		400		2000		5600		4200		3000		1000		700		2000		1500		500		10000		25000		250		3000		5000		1000		5000		1300		1000		1000		3000		3300		3300		4000		4000		3000		1500		900		1000		2000		2000		5000		3000		2700		500		2600		400		1300		4000		4000		2000		4600		4600		4600		4600		6100		6100		2500		2600		250		1000		1500		3000		1500		4200		1000		1000		4500		4500		4500		2000		1300		2000		3000		3000		3300		500		1000		2000		2000		1300		3000		3000		1000		1000		1100		2000		5300		5300		5300		2000		2000		600		2300		2300		1000		3000		100		2300		2300		2300		4900		4900		4900		4900		1000		1500		1500		4200		3600		3600		3600		3000		3000		3000		3000		250		2000		4000		4000		3000		4500		4500		5600		5600		5600		4000		3000		3000		3000		2500		1500		5000		5000		5000		1300		150		500		1000		2000		2500		2500		2600		3000		1500		5000		10000		5600		5600		1500		1000		1300		1500		1000		1300		3000		3000		300		2000		2000		1000		1500		10000		1000		5000		5000		5000		1000		4500		4500
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
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
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
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
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
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
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
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
cmte_id		1373906		1355540		1373827		1373825		1373599		1373840		1373813		1336971		1355244		1354953		1373730		741733		1358790		1275549		1323626		1373797		1373992		1351123		46-314998		1373420		1373429		1373429		1373777		1373638		1373638		1373564		1373564		1373829		1373723		1353635		1373601		1355749		1355749		1373807		1373829		1354418		1361957		1373953		1374577		1373603		1374569		1374569		1344099		1373572		1373572		1373572		1373572		1373906		1373906		1226812		1373953		1340226		1373767		1373726		1373835		1374093		1376380		1353750		1376680		1373468		1373468		1373468		1373430		1376879		1374146		1373568		1373568		1373424		1260828		1374408		1375999		1375999		1373652		1375100		1375100		1373484		1339123		1357037		1374018		1373566		1373566		1373566		1374486		1374486		1354200		1373426		1373426		1373423		1339550		1373319		1353520		1353520		1353520		1373708		1373708		1373708		1373708		1373947		1376513		1374003		1376636		1373559		1373559		1373559		1373771		1373771		1373831		1373831		1337681		1374455		1374375		1374375		1326620		1373918		1373918		1373599		1373599		1373599		1373562		1373595		1373813		1373797		890198		1374095		1373992		1373992		1373992		1374277		1345974		13387003		1374052		1359992		1353471		1353471		1374060		1373777		1374752		1311499		990680		1374225		1374225		1373710		1373630		1374311		1374668		1357503		1373943		1373799		1373799		1359626		1373492		1373492		1373673		1365760		992074		1375287		1373374		1373374		1373374		802010		1373918		1373918
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
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
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
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
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
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
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
cand_naml		Gray		Brown		Do		Vidak		Rendon		Atkins		Dodd		Quirk		Huff		Bradford		Dahle		Building Industry Associa		None		None		Castro		Baker		Brown		None		None		Wood		Chau		Chau		Eggman		Low		Low		Garcia		Garcia		Gipson		Bigelow		Ramos		Gomez		Gaines		Gaines		Gomez		Gipson		Hall		Nickel		Calderon		Bates		O'Donnell		Patterson		Patterson		None		Ting		Ting		Ting		Ting		Gray		Gray		African American Voter Re		Calderon		Hadjinian		Irwin		Gallagher		Nguyen		Obernolte		Fuller		Hill		Kern		Cooper		Cooper		Cooper		Frazier		Arambula		Jones		Jones-Sawyer		Jones-Sawyer		Medina		Gonzales		Chu		Alejo		Alejo		Cooley		de Leon		de Leon		Levine		None		Chang		Chang		Gonzalez		Gonzalez		Gonzalez		Wieckowski		Wieckowski		Lara		Bonta		Bonta		Hertzberg		Chavez		Rodriguez		Roth		Roth		Roth		Salas		Salas		Salas		Salas		Ridley-Thomas		Runner		Stern		Gloria		Daly		Daly		Daly		Thurmond		Thurmond		Allen		Allen		Martinez		Wagner		Waldron		Waldron		None		Kim		Kim		Rendon		Rendon		Rendon		Burke		Brough		Dodd		Baker		Central City Association		Mayes		Brown		Brown		Brown		Holden		Marick		Valdivia		Leyva		Hadley		Pan		Pan		Weber		Eggman		Linder		None		Los Angeles Area Chamber		Maienschein		Maienschein		Steinorth		Stone		Dababneh		Harper		McCarty		McCarty		Melendez		Melendez		Gates		Santiago		Santiago		Gatto		Morrell		None		Newsom		Olsen		Olsen		Olsen		None		Kim		Kim
cand_namf		Adam		Aja		Andrew		Andy		Anthony		Toni		Bill		Bill		Robert		Steven		Brian		None		None		None		Aide		Catherine		Cheryl		None		None		Jim		Edwin		Edwin		Susan		Evan		Evan		Cristina		Cristina		Mike		Frank		James		Jimmy		Ted		Ted		Jimmy		Mike		Isadore		Henry		Ian		Patricia		Patrick		James		James		None		Phil		Phil		Phil		Phil		Adam		Adam		None		Ian		Jack		Jacqui		James		Janet		Jay		Jean		Jerry		Jerry		Jim		Jim		Jim		Jim		Joaquin		Brian		Reginald		Reginald		Jose		Josie		Kansen		Karina Cervantez		Karina Cervantez		Ken		Kevin		Kevin		Marc		None		Ling-Ling		Ling-Ling		Lorena		Lorena		Lorena		Bob		Bob		Ricardo		Rob		Rob		Robert		Rocky		Freddie		Richard		Richard		Richard		Rudy		Rudy		Rudy		Rudy		Sebastian		Sharon		Henry		Todd		Tom		Tom		Tom		Tony		Tony		Travis		Travis		Victoria		Donald		Marie		Marie		None		Young		Young		Anthony		Anthony		Anthony		Autumn		William		Bill		Catherine		None		Chad		Cheryl		Cheryl		Cheryl		Chris		Christine		John		Connie		David		Richard		Richard		Shirley		Susan		Eric		None		None		Brian		Brian		Marc		Mark		Matthew		Matthew		Kevin		Kevin		Melissa		Melissa		Michael		Miguel		Miguel		Mike		Michael		None		Gavin		Kristin		Kristin		Kristin		None		Young		Young
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
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
office_cd		ASM		MAY		COU		SEN		ASM		SEN		ASM		ASM		ASM		SEN		ASM		None		None		None		CCM		ASM		ASM		None		None		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		COU		ASM		SEN		SEN		ASM		ASM		SEN		CCM		ASM		SEN		ASM		ASM		ASM		None		ASM		ASM		ASM		ASM		ASM		ASM		OTH		ASM		MAY		ASM		ASM		SEN		ASM		ASM		SEN		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		COU		ASM		ASM		ASM		ASM		LTG		LTG		ASM		None		ASM		ASM		ASM		ASM		ASM		SEN		SEN		SEN		ASM		ASM		SEN		OTH		ASM		SEN		SEN		SEN		ASM		ASM		ASM		ASM		ASM		SEN		SEN		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		CCM		SEN		ASM		ASM		None		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		OTH		ASM		ASM		ASM		ASM		ASM		CCM		CCM		SEN		ASM		SEN		SEN		ASM		ASM		ASM		None		OTH		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		OTH		ASM		ASM		ASM		SEN		None		LTG		SEN		SEN		SEN		None		ASM		ASM
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		Other		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		United States Senate		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Other		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Other		None		None		None		None		None		None		None		None		None		None		Other		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		ASM		CIT		CTY		SEN		ASM		SEN		ASM		ASM		ASM		SEN		ASM		None		None		None		CIT		ASM		ASM		None		None		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		CTY		ASM		SEN		SEN		ASM		ASM		SEN		CIT		ASM		SEN		ASM		ASM		ASM		None		ASM		ASM		ASM		ASM		ASM		ASM		OTH		ASM		CIT		ASM		ASM		SEN		ASM		ASM		SEN		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		CTY		ASM		ASM		ASM		ASM		STW		STW		ASM		None		ASM		ASM		ASM		ASM		ASM		SEN		SEN		SEN		ASM		ASM		SEN		OTH		ASM		SEN		SEN		SEN		ASM		ASM		ASM		ASM		ASM		SEN		SEN		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		CIT		SEN		ASM		ASM		None		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		OTH		ASM		ASM		ASM		ASM		ASM		CIT		CIT		SEN		ASM		SEN		SEN		ASM		ASM		ASM		None		OTH		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		OTH		ASM		ASM		ASM		SEN		None		STW		SEN		SEN		SEN		None		ASM		ASM
juris_dscr		None		Mayor		County		None		None		None		None		None		None		None		None		None		None		None		City Council Member		None		None		None		None		None		None		None		None		None		None		None		None		None		None		County		None		None		None		None		None		None		City Council Member		None		None		None		None		None		None		None		None		None		None		None		None		Other		None		Mayor		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		County		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		United States Senate		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		City Council Member		None		None		None		None		None		None		None		None		None		None		None		None		None		Other		None		None		None		None		None		City Council Member		City Council Member		None		None		None		None		None		None		None		None		Other		None		None		None		None		None		None		None		None		None		None		Other		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		021		None		None		014		063		039		004		020		055		035		001		None		None		None		None		016		047		None		None		002		049		049		013		028		028		058		058		064		005		None		051		001		001		051		064		035		None		057		036		070		023		023		None		019		019		019		019		021		021		None		057		None		044		003		034		033		032		013		076		009		009		009		011		031		071		059		059		061		None		025		030		030		008		None		None		010		None		055		055		080		080		080		010		010		033		018		018		018		None		052		031		031		031		032		032		032		032		054		021		027		078		069		069		069		015		015		072		072		None		037		075		075		None		065		065		063		063		063		062		073		004		016		None		042		047		047		047		041		None		None		020		066		006		006		079		013		060		None		None		077		077		040		029		045		074		007		007		067		067		None		053		053		043		023		None		None		008		008		008		None		065		065
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
bal_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		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
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		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		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
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
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

Table: filer_filings

filer_id		1011327
filing_id		1979902
period_id		222
form_id		F461
filing_sequence		0
filing_date		2015-07-30 00:00:00
stmnt_type		10001
stmnt_status		11001
session_id		2015
user_id		JINGRAM
special_audit		11003
fine_audit		11001
rpt_start		2015-04-01 00:00:00
rpt_end		2015-06-30 00:00:00
rpt_date		2015-07-28 00:00:00
filing_type		22001

Table: filings

filing_id		1979902
filing_type		22001

Table: hdr

filing_id		1979902
amend_id		0
rec_type		HDR
ef_type		CAL
state_cd		CA
cal_ver		2.01
soft_name		DDC
soft_ver		1.00
hdrcomment		None

Table: received_filings

filer_id		1011327
filing_file_name		1979902_0.cal
received_date		2015-07-30 00:00:00
filing_directory		/cafiler/disclose/ca99/cal
filing_id		1979902
form_id		F461
receive_comment		Filing accepted

Table: smry

filing_id		1979902		1979902		1979902		1979902		1979902
amend_id		0		0		0		0		0
line_item		1		2		3		4		5
rec_type		SMRY		SMRY		SMRY		SMRY		SMRY
form_type		F461		F461		F461		F461		F461
amount_a		277300		99		277399		228297		505696
amount_b		None		None		None		None		None
amount_c		None		None		None		None		None
elec_dt		None		None		None		None		None