Home

Filer ID: 1305799

Table: cvr_campaign_disclosure

filing_id		1433999		1490514		1474219		1461270		1504709		1567152		1523112		1538180		1532969		1523112		1532087		1530447		1530445		1604776		1663601		1664803		1647114		1633185		1675299		1710114		1523112		1695010		1740663		1827701		1834281		1829403		1838353		1831102		1813110		1796856		1777257		1849220		1834774		1835099		1839756		1883561		1867684		1853547		1855321		1892630		1889155		1931117		1908940		1896538		1904023		1977959		1953140		2048984		2033493		2012726		2025484		1995562		2047044		2028966		2082760		2070349		2071507		2050081		2058680		2097358		2088874		2167452		2130006		2190813		2208025		2236567		2226032		2253772		2248120		2284338		2296680		2288695		2269017		2281958		2320759		2392984		2418492		2346197		2427567		2484586		2438933		2551864		2596706		2644092		2705384
amend_id		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		2		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F460		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F497		F497		F460		F460		F497		F460		F460		F460		F497		F460		F460		F460		F497		F497		F497		F497		F460		F460		F460		F460		F497		F497		F497		F497		F497		F460		F460		F497		F460		F497		F460		F497		F497		F460		F460		F497		F497		F460		F460		F497		F460		F497		F497		F460		F497		F497		F497		F460		F460		F497		F460		F460		F460		F460		F460		F497		F460		F497		F497		F460		F497		F460		F497		F497		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460
filer_id		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799
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
filer_naml		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC
filer_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
report_num		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		002		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2009-07-27 00:00:00		2010-05-26 00:00:00		2010-03-22 00:00:00		2010-01-27 00:00:00		2010-07-28 00:00:00		2011-01-26 00:00:00		2010-10-22 00:00:00		2010-10-28 00:00:00		2010-10-22 00:00:00		2010-10-05 00:00:00		2010-10-21 00:00:00		2010-10-20 00:00:00		2010-10-20 00:00:00		2011-07-27 00:00:00		2012-05-24 00:00:00		2012-05-25 00:00:00		2012-03-22 00:00:00		2012-01-27 00:00:00		2012-07-26 00:00:00		2012-10-31 00:00:00		2012-10-05 00:00:00		2012-10-05 00:00:00		2013-01-31 00:00:00		2014-03-12 00:00:00		2014-03-27 00:00:00		2014-03-17 00:00:00		2014-04-14 00:00:00		2014-03-21 00:00:00		2014-01-24 00:00:00		2013-10-24 00:00:00		2013-07-22 00:00:00		2014-05-12 00:00:00		2014-04-01 00:00:00		2014-04-01 00:00:00		2014-04-21 00:00:00		2014-09-09 00:00:00		2014-07-28 00:00:00		2014-05-22 00:00:00		2014-05-27 00:00:00		2014-10-06 00:00:00		2014-09-29 00:00:00		2015-01-27 00:00:00		2014-10-29 00:00:00		2014-10-10 00:00:00		2014-10-23 00:00:00		2015-07-27 00:00:00		2015-03-11 00:00:00		2016-06-02 00:00:00		2016-04-27 00:00:00		2016-02-01 00:00:00		2016-04-01 00:00:00		2015-10-27 00:00:00		2016-05-26 00:00:00		2016-04-15 00:00:00		2016-09-28 00:00:00		2016-08-19 00:00:00		2016-08-24 00:00:00		2016-06-07 00:00:00		2016-07-26 00:00:00		2016-10-26 00:00:00		2016-10-13 00:00:00		2017-07-13 00:00:00		2017-01-31 00:00:00		2017-10-23 00:00:00		2018-01-29 00:00:00		2018-04-25 00:00:00		2018-03-28 00:00:00		2018-05-24 00:00:00		2018-05-10 00:00:00		2018-08-17 00:00:00		2018-09-26 00:00:00		2018-09-04 00:00:00		2018-07-24 00:00:00		2018-08-09 00:00:00		2018-10-31 00:00:00		2019-07-23 00:00:00		2019-10-21 00:00:00		2019-01-29 00:00:00		2019-12-31 00:00:00		2020-07-30 00:00:00		2020-01-29 00:00:00		2021-01-29 00:00:00		2021-07-14 00:00:00		2022-01-26 00:00:00		2022-07-15 00:00:00
stmt_type		SA		PE		PE		SA		SA		SA		PE		None		None		PE		PE		None		None		SA		PE		None		PE		SA		SA		None		PE		PE		PE		None		None		None		None		PE		SA		SY		SA		None		None		None		None		None		SA		PE		None		PE		None		SA		None		None		PE		SA		None		None		PE		SA		None		SY		None		None		PE		None		None		None		SA		PE		None		SA		SA		SY		SA		PE		None		PE		None		None		PE		None		SA		None		None		SA		SY		SA		None		SA		SA		SA		SA		SA		SA
late_rptno		None		None		None		None		None		None		None		4694		4272		None		None		4080		4079		None		None		6039		None		None		None		7677		None		None		None		9802		10018		9886		10211		None		None		None		None		10786		10051		10068		10324		12066		None		None		11290		None		12531		None		14014		12996		None		None		14516		17337		None		None		15903		None		17131		16135		None		17760		17835		17474		None		None		19667		None		None		None		None		None		23751		None		24679		26058		None		26382		None		25919		28875		None		None		None		30605		None		None		None		None		None		None
from_date		2009-01-01 00:00:00		2010-03-18 00:00:00		2010-01-01 00:00:00		2009-07-01 00:00:00		2010-05-23 00:00:00		2010-10-17 00:00:00		2010-07-01 00:00:00		None		None		2010-07-01 00:00:00		2010-10-01 00:00:00		None		None		2011-01-01 00:00:00		2012-03-18 00:00:00		None		2012-01-01 00:00:00		2011-07-01 00:00:00		2012-05-20 00:00:00		None		2010-07-01 00:00:00		2012-07-01 00:00:00		2012-10-01 00:00:00		None		None		None		None		2014-01-01 00:00:00		2013-10-01 00:00:00		2013-07-01 00:00:00		2013-01-01 00:00:00		None		None		None		None		None		2014-05-18 00:00:00		2014-03-18 00:00:00		None		2014-07-01 00:00:00		None		2014-10-19 00:00:00		None		None		2014-10-01 00:00:00		2015-01-01 00:00:00		None		None		2016-01-01 00:00:00		2015-10-01 00:00:00		None		2015-07-01 00:00:00		None		None		2016-07-01 00:00:00		None		None		None		2016-04-24 00:00:00		2016-09-25 00:00:00		None		2017-01-01 00:00:00		2016-10-23 00:00:00		2017-07-01 00:00:00		2017-10-01 00:00:00		2018-01-01 00:00:00		None		2018-04-22 00:00:00		None		None		2018-07-01 00:00:00		None		2018-05-20 00:00:00		None		None		2019-01-01 00:00:00		2019-07-01 00:00:00		2018-09-23 00:00:00		None		2020-01-01 00:00:00		2019-10-01 00:00:00		2020-07-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00
thru_date		2009-06-30 00:00:00		2010-05-22 00:00:00		2010-03-17 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-12-31 00:00:00		2010-09-30 00:00:00		None		None		2010-09-30 00:00:00		2010-10-16 00:00:00		None		None		2011-06-30 00:00:00		2012-05-19 00:00:00		None		2012-03-17 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		None		2010-09-30 00:00:00		2012-09-30 00:00:00		2012-12-31 00:00:00		None		None		None		None		2014-03-17 00:00:00		2013-12-31 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		None		None		None		None		None		2014-06-30 00:00:00		2014-05-17 00:00:00		None		2014-09-30 00:00:00		None		2014-12-31 00:00:00		None		None		2014-10-18 00:00:00		2015-06-30 00:00:00		None		None		2016-04-23 00:00:00		2015-12-31 00:00:00		None		2015-09-30 00:00:00		None		None		2016-09-24 00:00:00		None		None		None		2016-06-30 00:00:00		2016-10-22 00:00:00		None		2017-06-30 00:00:00		2016-12-31 00:00:00		2017-09-30 00:00:00		2017-12-31 00:00:00		2018-04-21 00:00:00		None		2018-05-19 00:00:00		None		None		2018-09-22 00:00:00		None		2018-06-30 00:00:00		None		None		2019-06-30 00:00:00		2019-09-30 00:00:00		2018-12-31 00:00:00		None		2020-06-30 00:00:00		2019-12-31 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00
elect_date		None		2010-06-08 00:00:00		2010-06-08 00:00:00		None		None		None		2010-11-02 00:00:00		None		None		2010-11-02 00:00:00		2010-11-02 00:00:00		None		None		None		2012-06-05 00:00:00		None		2012-06-05 00:00:00		None		None		None		2010-11-02 00:00:00		2012-11-06 00:00:00		2012-11-06 00:00:00		None		None		None		None		2014-06-03 00:00:00		None		None		None		None		None		None		None		None		None		2014-06-03 00:00:00		None		2014-11-04 00:00:00		None		None		None		None		2014-11-04 00:00:00		None		None		None		2016-06-07 00:00:00		None		None		None		None		None		2016-11-08 00:00:00		None		None		None		None		2016-11-08 00:00:00		None		None		None		None		None		2018-06-05 00:00:00		None		2018-06-05 00:00:00		None		None		2018-11-06 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
filer_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
filer_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
filer_phon		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952
filer_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
file_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
mail_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
mail_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
mail_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
tres_naml		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Augustine		Godlewski		Godlewski		Godlewski		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine		Augustine
tres_namf		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Curt		Matthew		Matthew		Matthew		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt		Curt
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
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
tres_city		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Washington		Sacramento		Washington		Washington		Washington		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
tres_st		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		CA		DC		DC		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
tres_zip4		20005		20005		20005		20005		20005		20005		20005		20005		20005		20005		20005		20005		20005		20005		20005		20005		20005		20005		20005		20005		20005		20005		20005		20001		20001		20001		20001		20001		20001		20001		20005		20001		20001		20001		20001		20001		20001		20001		20001		20001		20001		95814		20001		20001		20001		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
tres_phon		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(916)447-7315		(202)326-5500		(202)326-5500		(202)326-5500		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315
tres_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmtte_type		G		G		G		G		G		G		G		None		None		G		G		None		None		G		G		None		G		G		G		None		G		G		G		None		None		None		None		G		G		G		G		None		None		None		None		None		G		G		None		G		None		G		None		None		G		G		None		None		G		G		None		G		None		None		G		None		None		None		G		G		None		G		G		G		G		G		None		G		None		None		G		None		G		None		None		G		G		G		None		G		G		G		G		G		G
control_yn		Y		Y		Y		Y		Y		Y		Y		None		None		Y		Y		None		None		Y		Y		None		Y		Y		Y		None		Y		Y		Y		None		None		None		None		Y		Y		Y		Y		None		None		None		None		None		Y		Y		None		Y		None		Y		None		None		Y		Y		None		None		Y		Y		None		Y		None		None		Y		None		None		None		Y		Y		None		Y		Y		Y		Y		Y		None		Y		None		None		Y		None		Y		None		None		Y		Y		Y		None		Y		Y		Y		Y		Y		Y
sponsor_yn		N		N		N		N		N		N		N		None		None		N		N		None		None		N		N		None		N		N		N		None		N		N		N		None		None		None		None		N		N		N		N		None		None		None		None		None		N		N		None		N		None		N		None		None		N		N		None		None		N		N		None		N		None		None		N		None		None		None		N		N		None		N		N		N		N		N		None		N		None		None		N		None		N		None		None		N		N		N		None		N		N		N		N		N		N
primfrm_yn		N		N		N		N		N		N		N		None		None		N		N		None		None		N		N		None		N		N		N		None		N		N		N		None		None		None		None		N		N		N		N		None		None		None		None		None		N		N		None		N		None		N		None		None		N		N		None		None		N		N		None		N		None		None		N		None		None		None		N		N		None		N		N		N		N		N		None		N		None		None		N		None		N		None		None		N		N		N		None		N		N		N		N		N		N
brdbase_yn		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amendexp_1		None		None		None		None		None		None		To Update Summary page and Schedules A, D & E		None		None		None		None		None		None		None		None		None		None		None		None		None		Update Summary Page and Schedule A and I		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amendexp_2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amendexp_3		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rpt_att_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmtte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
reportname		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rptfromdt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rptthrudt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
emplbus_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_inter		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
busact_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
busactvity		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
assoc_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
assoc_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
other_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
other_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
cand_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
cand_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
cand_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
cand_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
office_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
offic_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
off_s_h_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
employer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
occupation		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
selfemp_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: cvr_so

filing_id		1478826		1478826		1478826		1478826		1478826		1478826		1478826		1478826		1478826		1478826		1478826
amend_id		0		1		2		3		4		5		6		7		8		9		10
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F410		F410		F410		F410		F410		F410		F410		F410		F410		F410		F410
filer_id		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799
entity_cd		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP
filer_naml		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC		Alliance of Automobile Manufacturers California PAC
filer_namf		None		None		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None		None
report_num		000		001		002		003		004		005		006		007		008		009		010
rpt_date		2010-04-09 00:00:00		2010-04-09 00:00:00		2010-04-09 00:00:00		2010-04-09 00:00:00		2013-01-31 00:00:00		2013-10-23 00:00:00		2014-11-06 00:00:00		2015-02-11 00:00:00		2016-10-19 00:00:00		2018-04-12 00:00:00		2021-09-20 00:00:00
qual_cb		None		None		None		None		X		X		X		X		X		X		X
qualfy_dt		2010-06-08 00:00:00		2010-06-08 00:00:00		2010-06-08 00:00:00		2010-06-08 00:00:00		2008-06-11 00:00:00		2008-06-11 00:00:00		2008-06-11 00:00:00		2008-06-11 00:00:00		2008-06-11 00:00:00		2008-06-11 00:00:00		2008-06-11 00:00:00
term_date		None		None		None		None		None		None		None		None		None		None		None
city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
phone		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952		(916)442-2952
county_res		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
county_act		None		None		None		None		Statewide		Statewide		Statewide		Statewide		Statewide		Statewide		Statewide
mail_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
mail_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
mail_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
cmte_fax		None		None		None		None		None		None		None		None		None		None		None
cmte_email		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
tres_naml		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Godlewski		Augustine		Augustine		Augustine		Augustine		Augustine
tres_namf		Matthew		Matthew		Matthew		Matthew		Matthew		Matthew		Curt		Curt		Curt		Curt		Curt
tres_namt		None		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None		None
tres_city		Washington		Washington		Washington		Washington		Washington		Washington		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
tres_st		DC		DC		DC		DC		DC		DC		CA		CA		CA		CA		CA
tres_zip4		20005		20005		20005		20005		20005		20001		95814		95814		95814		95814		95814
tres_phon		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(202)326-5500		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315		(916)447-7315
actvty_lvl		ST		ST		ST		ST		ST		ST		ST		ST		ST		ST		ST
com82013yn		None		None		None		None		None		None		None		None		None		None		None
com82013nm		None		None		None		None		None		None		None		None		None		None		None
com82013id		None		None		None		None		None		None		None		None		None		None		None
control_cb		None		None		None		None		None		None		None		None		None		None		None
bank_nam		None		None		None		None		Wells Fargo Bank		Wells Fargo Bank		Wells Fargo Bank		Wells Fargo Bank		Wells Fargo Bank		Wells Fargo Bank		Wells Fargo Bank
bank_adr1		None		None		None		None		400 Capitol Mall		400 Capitol Mall		400 Capitol Mall		400 Capitol Mall		400 Capitol Mall		400 Capitol Mall		400 Capitol Mall
bank_adr2		None		None		None		None		None		None		None		None		None		None		None
bank_city		None		None		None		None		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
bank_st		None		None		None		None		CA		CA		CA		CA		CA		CA		CA
bank_zip4		None		None		None		None		95814		95814		95814		95814		95814		95814		95814
bank_phon		None		None		None		None		(916)440-4205		(916)440-4205		(916)440-4205		(916)440-4205		(916)440-4205		(916)440-4205		(916)440-4205
acct_opendt		None		None		None		None		None		None		None		None		None		None		None
surplusdsp		None		None		None		None		None		None		None		None		None		None		None
primfc_cb		None		None		None		None		None		None		None		None		None		None		None
genpurp_cb		None		None		None		None		None		None		None		None		None		None		None
gpc_descr		To support or oppose state and local candidates.		To support or oppose state and local candidates.		To support or oppose state and local candidates.		To support or oppose state and local candidates.		To support or oppose state and local candidates.		To support or oppose state and local candidates.		To support or oppose state and local candidates.		To support or oppose state and local candidates.		To support or oppose state and local candidates.		To support or oppose state and local candidates.		To support or oppose state and local candidates.
sponsor_cb		None		None		None		None		None		None		None		None		X		X		X
brdbase_cb		None		None		None		None		None		None		None		None		None		None		None
smcont_qualdt		None		None		None		None		None		None		None		None		None		None		None

Table: filer_address

filer_id		1305799		1305799		1305799		1305799		1305799		1305799		1305799
adrid		2135931		2525066		2525067		2287649		2287648		2452676		2452675
effect_dt		2008-04-04 00:00:00		2021-10-14 00:00:00		2021-10-14 00:00:00		2013-01-31 00:00:00		2013-01-31 00:00:00		2018-04-13 00:00:00		2018-04-13 00:00:00
add_type		7051		7051		7082		7082		7051		7082		7051
session_id		2007		2021		2021		2013		2013		2017		2017

Table: filer_filings

filer_id		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799
filing_id		1769859		1528987		1784497		1977959		1980179		1478826		1953140		1870012		1858700		1849220		1853547		1855321		1838353		1867684		1796856		1478826		1777257		1806182		1799111		1944255		1947333		1908940		1894510		1896538		1904023		1323191		1323191		1351053		1363609		1371411		1363609		1388229		1376491		1395212		1434468		1433999		1464400		1478826		1480164		1478826		1478826		1478826		1461270		1474219		1490514		1504709		1474375		1493308		1542709		1528987		1530445		1530447		1509027		1535842		1532087		1528987		1532969		1538180		1541708		1523112		1523112		1567152		1570313		1604776		1605664		1634112		1633185		1647867		1647114		1664803		1663601		1675299		1677107		1665570		1829403		1819910		1813110		1827701		1833718		1695010		1523112		1696823		1931117		1478826		1914797		1915657		1710114		1889155		1892630		1883561		1740663		1478826		1839756		1831102		1834774		1834281		1835099		1757037		1746815		1995562		1997377		2236567		2346197		2253772		2217625		2248120		2190813		2190880		2392984		2427567		2260104		2418492		2284338		2023874		2025484		2033493		2028966		2036318		2012726		2048984		2047044		2050081		2058680		2071507		2070349		2082760		2072675		2088874		2096146		2097358		1478826		2096683		2110096		2130006		2143182		2167452		2167988		2438933		2403820		2494097		1478826		2231718		2269831		2226032		2237100		2298086		2574125		2281958		2320759		2356172		2288695		2296680		2208025		2445983		2269017		2551864		2421777		2484586		2616339		2648457		2705384		2612586		2644092		1478826		2596706		2737556
period_id		None		None		None		221		None		221		221		None		None		218		217		218		218		218		215		216		213		None		None		None		None		220		None		220		220		None		None		None		None		None		None		None		None		None		None		197		None		202		None		202		202		202		199		201		201		202		None		None		None		None		204		204		None		None		204		None		204		204		None		203		203		204		None		205		None		None		207		None		209		210		209		210		None		None		217		None		216		217		None		211		203		None		220		220		None		None		212		219		219		219		212		213		218		217		218		217		218		None		None		223		None		233		235		234		None		234		231		None		237		240		None		239		235		None		226		225		226		None		224		226		226		226		226		227		227		227		None		228		None		227		228		None		None		228		None		229		None		240		None		None		234		None		None		233		None		None		None		235		236		None		235		235		232		None		234		243		None		241		None		None		249		None		247		247		245		None
form_id		F666		F460		F460		F460		F460		F410		F497		F460		F460		F497		F460		F497		F497		F460		F460		F410		F460		F410		F460		F460		F410		F497		F460		F497		F460		F410		F410		F460		F460		F460		F460		F410		F497		F460		F460		F460		F460		F410		F410		F410		F410		F410		F460		F460		F460		F460		F460		F460		F497		F460		F497		F497		F460		F460		F460		F460		F497		F497		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F497		F460		F460		F497		F460		F460		F460		F460		F460		F410		F410		F460		F497		F497		F460		F497		F460		F410		F497		F460		F497		F497		F497		F410		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F497		F460		F460		F497		F460		F497		F460		F497		F460		F460		F497		F497		F497		F460		F497		F497		F460		F460		F497		F460		F460		F410		F410		F460		F460		F460		F460		F460		F460		F460		F460		F410		F410		F460		F497		F460		F460		F460		F497		F497		F460		F497		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F410		F460		F460
filing_sequence		0		2		0		0		0		7		0		0		0		0		0		0		0		0		0		5		0		0		0		0		0		0		0		0		0		0		1		0		0		0		1		0		0		0		0		0		0		2		0		0		1		3		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		2		0		0		6		0		0		0		0		0		0		0		4		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		8		0		0		0		0		0		0		0		0		0		9		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		10		0		0
filing_date		2013-05-31 00:00:00		2012-10-05 00:00:00		2013-07-22 00:00:00		2015-07-27 00:00:00		2015-07-27 00:00:00		2015-02-11 00:00:00		2015-03-11 00:00:00		2014-07-28 00:00:00		2014-05-22 00:00:00		2014-05-12 00:00:00		2014-05-22 00:00:00		2014-05-27 00:00:00		2014-04-14 00:00:00		2014-07-28 00:00:00		2013-10-24 00:00:00		2013-10-23 00:00:00		2013-07-22 00:00:00		2013-10-23 00:00:00		2013-10-24 00:00:00		2015-01-27 00:00:00		2015-02-11 00:00:00		2014-10-29 00:00:00		2014-10-06 00:00:00		2014-10-10 00:00:00		2014-10-23 00:00:00		2008-04-04 00:00:00		2008-06-20 00:00:00		2008-07-31 00:00:00		2008-10-06 00:00:00		2008-10-23 00:00:00		2008-10-17 00:00:00		2008-12-30 00:00:00		2008-10-28 00:00:00		2009-01-29 00:00:00		2009-07-27 00:00:00		2009-07-27 00:00:00		2010-01-27 00:00:00		2010-04-09 00:00:00		2010-04-09 00:00:00		2010-04-09 00:00:00		2010-04-09 00:00:00		2010-04-09 00:00:00		2010-01-27 00:00:00		2010-03-22 00:00:00		2010-05-26 00:00:00		2010-07-28 00:00:00		2010-03-22 00:00:00		2010-05-26 00:00:00		2010-10-28 00:00:00		2010-10-05 00:00:00		2010-10-20 00:00:00		2010-10-20 00:00:00		2010-07-28 00:00:00		2010-10-21 00:00:00		2010-10-21 00:00:00		2010-10-22 00:00:00		2010-10-22 00:00:00		2010-10-28 00:00:00		2010-10-22 00:00:00		2010-10-22 00:00:00		2010-10-05 00:00:00		2011-01-26 00:00:00		2011-01-26 00:00:00		2011-07-27 00:00:00		2011-07-27 00:00:00		2012-01-27 00:00:00		2012-01-27 00:00:00		2012-03-22 00:00:00		2012-03-22 00:00:00		2012-05-25 00:00:00		2012-05-24 00:00:00		2012-07-26 00:00:00		2012-07-26 00:00:00		2012-05-24 00:00:00		2014-03-17 00:00:00		2014-01-24 00:00:00		2014-01-24 00:00:00		2014-03-12 00:00:00		2014-03-21 00:00:00		2012-10-05 00:00:00		2012-10-05 00:00:00		2012-10-05 00:00:00		2015-01-27 00:00:00		2014-11-06 00:00:00		2014-11-06 00:00:00		2014-10-23 00:00:00		2012-10-31 00:00:00		2014-09-29 00:00:00		2014-10-06 00:00:00		2014-09-09 00:00:00		2013-01-31 00:00:00		2013-01-31 00:00:00		2014-04-21 00:00:00		2014-03-21 00:00:00		2014-04-01 00:00:00		2014-03-27 00:00:00		2014-04-01 00:00:00		2013-01-31 00:00:00		2013-01-31 00:00:00		2015-10-28 00:00:00		2015-10-28 00:00:00		2018-04-25 00:00:00		2019-01-30 00:00:00		2018-05-24 00:00:00		2018-01-29 00:00:00		2018-05-10 00:00:00		2017-10-26 00:00:00		2017-10-26 00:00:00		2019-07-25 00:00:00		2019-12-31 00:00:00		2018-05-24 00:00:00		2019-10-30 00:00:00		2018-08-17 00:00:00		2016-02-01 00:00:00		2016-04-01 00:00:00		2016-04-27 00:00:00		2016-04-15 00:00:00		2016-04-27 00:00:00		2016-02-01 00:00:00		2016-06-02 00:00:00		2016-05-26 00:00:00		2016-06-07 00:00:00		2016-07-26 00:00:00		2016-08-24 00:00:00		2016-08-19 00:00:00		2016-09-29 00:00:00		2016-07-26 00:00:00		2016-10-14 00:00:00		2016-09-29 00:00:00		2016-10-27 00:00:00		2016-10-19 00:00:00		2016-10-19 00:00:00		2016-10-27 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2017-07-14 00:00:00		2017-07-14 00:00:00		2020-01-29 00:00:00		2019-07-26 00:00:00		2020-07-31 00:00:00		2018-04-13 00:00:00		2018-04-13 00:00:00		2018-07-25 00:00:00		2018-03-28 00:00:00		2018-04-26 00:00:00		2018-09-27 00:00:00		2021-02-01 00:00:00		2018-08-09 00:00:00		2018-10-31 00:00:00		2019-01-30 00:00:00		2018-09-04 00:00:00		2018-09-27 00:00:00		2018-01-29 00:00:00		2020-01-30 00:00:00		2018-07-25 00:00:00		2021-01-30 00:00:00		2019-10-30 00:00:00		2020-07-30 00:00:00		2021-10-14 00:00:00		2022-01-31 00:00:00		2022-07-30 00:00:00		2021-07-27 00:00:00		2022-01-31 00:00:00		2021-10-14 00:00:00		2021-07-26 00:00:00		2022-07-29 00:00:00
stmnt_type		10005		10006		10005		10001		10005		10002		10001		10005		10005		10001		10001		10001		10001		10001		10001		10002		10001		10006		10005		10005		10002		10001		10005		10001		10001		10005		10006		10005		10005		10005		10006		10006		10005		10005		10005		10001		10005		10002		10006		10001		10002		10002		10001		10001		10001		10001		10005		10005		10005		10005		10001		10001		10005		10005		10001		10006		10001		10001		10005		10002		10001		10001		10005		10001		10005		10005		10001		10005		10001		10001		10001		10001		10005		10005		10001		10005		10001		10001		10005		10001		10002		10005		10001		10002		10006		10005		10001		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10002		10005		10001		10005		10001		10001		10001		10005		10001		10001		10005		10001		10001		10005		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10005		10001		10002		10006		10005		10001		10005		10001		10005		10001		10005		10005		10002		10006		10005		10001		10005		10005		10005		10001		10001		10005		10001		10001		10001		10005		10001		10001		10005		10001		10006		10005		10001		10005		10001		10002		10001		10005
stmnt_status		11003		11003		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11003		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003
session_id		2009		2009		2013		2015		2015		2015		2015		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2015		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2013		2011		2009		2011		2013		2013		2013		2013		2011		2013		2013		2013		2011		2013		2013		2013		2013		2013		2013		2013		2011		2015		2015		2017		2017		2017		2017		2017		2017		2017		2019		2019		2017		2019		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2019		2019		2019		2017		2017		2017		2017		2017		2017		2021		2017		2017		2017		2017		2017		2017		2019		2017		2019		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021
user_id		NLANDERS		NLANDERS		MDIGRAZIA		CAFILER		GPEREZ		TRAMON		WBROWN		MPACHECO		MDIGRAZIA		WBROWN		MDIGRAZIA		WBROWN		WBROWN		CAFILER		CAFILER		TRAMON		MDIGRAZIA		TRAMON		MPACHECO		GPEREZ		TRAMON		WBROWN		SMCCONNAN		WBROWN		CAFILER		ACASTILLO		EMCENTEE		GKURIMOT		GKURIMOT		RGEREMIA		RGEREMIA		RGEREMIA		EMCENTEE		GKURIMOT		CPON		CPON		CPON		*		RGEREMIA		*		*		*		CPON		MMORENO		MMORENO		MMORENO		MMORENO		SARRIAGA		MPACHECO		SMCCONNAN		WBROWN		WBROWN		MMORENO		MMORENO		MMORENO		MPACHECO		SARRIAGA		WBROWN		GKURIMOT		MMORENO		SMCCONNAN		SARRIAGA		SARRIAGA		CPON		CPON		SARRIAGA		SARRIAGA		MDIGRAZIA		MDIGRAZIA		PBANFORD		SARRIAGA		CPON		CPON		SARRIAGA		WBROWN		MPACHECO		MDIGRAZIA		WBROWN		MDIGRAZIA		CPON		CAFILER		CPON		CAFILER		TRAMON		TRAMON		JINGRAM		CAFILER		WBROWN		SMCCONNAN		WBROWN		MDIGRAZIA		JINGRAM		WBROWN		MDIGRAZIA		WBROWN		WBROWN		WBROWN		JINGRAM		MPACHECO		MDIGRAZIA		MDIGRAZIA		HSTOVALL		LPHEAV		RPOOJA		HSTOVALL		CAFILER		LBARTHOL		LBARTHOL		YMORA		CAFILER		RPOOJA		LPHEAV		CAFILER		SARRIAGA		KBANH		SARRIAGA		KBANH		SARRIAGA		CAFILER		KBANH		RGEREMIA		KBANH		CAFILER		PDEO		PDEO		SARRIAGA		SMCCONNAN		PDEO		SARRIAGA		GPEREZ		TRAMON		TRAMON		GPEREZ		CPON		CPON		BSINGH		BSINGH		SUSHAKOV		YMORA		KRUSSELL		TRAMON		TRAMON		CSAGABAEN		PBANFORD		HSTOVALL		RPOOJA		AXIONG		CAFILER		CAFILER		LPHEAV		CAFILER		RPOOJA		HSTOVALL		SUSHAKOV		CSAGABAEN		AXIONG		LPHEAV		KRUSSELL		IMEDINA		KRUSSELL		CAFILER		KRUSSELL		KRUSSELL		IMEDINA		KRUSSELL		JMAVES
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11003		11003		11001		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11001		11001		11001		11003		11003		11003		11001		11001		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11003		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		2009-01-01 00:00:00		2010-07-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-02-11 00:00:00		2015-03-11 00:00:00		2014-05-18 00:00:00		2014-03-18 00:00:00		2014-05-12 00:00:00		2014-03-18 00:00:00		2014-05-27 00:00:00		2014-04-14 00:00:00		2014-05-18 00:00:00		2013-07-01 00:00:00		2013-10-23 00:00:00		2013-01-01 00:00:00		None		2013-07-01 00:00:00		2014-10-19 00:00:00		None		2014-10-29 00:00:00		2014-07-01 00:00:00		2014-10-10 00:00:00		2014-10-01 00:00:00		None		None		2008-01-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2008-07-01 00:00:00		None		None		2008-10-19 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2010-04-09 00:00:00		None		2010-04-09 00:00:00		2010-04-09 00:00:00		2010-04-09 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-03-18 00:00:00		2010-05-23 00:00:00		2010-01-01 00:00:00		2010-03-18 00:00:00		None		2010-07-01 00:00:00		2010-10-20 00:00:00		2010-10-20 00:00:00		2010-05-23 00:00:00		2010-10-01 00:00:00		2010-10-01 00:00:00		2010-07-01 00:00:00		2010-10-22 00:00:00		2010-10-28 00:00:00		None		2010-07-01 00:00:00		2010-07-01 00:00:00		2010-10-17 00:00:00		2010-10-17 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-05-25 00:00:00		2012-03-18 00:00:00		2012-05-20 00:00:00		2012-05-20 00:00:00		2012-03-18 00:00:00		2014-03-17 00:00:00		2013-10-01 00:00:00		2013-10-01 00:00:00		2014-03-12 00:00:00		2014-01-01 00:00:00		2012-07-01 00:00:00		2010-07-01 00:00:00		2012-07-01 00:00:00		2014-10-19 00:00:00		2014-11-06 00:00:00		None		2014-10-01 00:00:00		2012-10-31 00:00:00		2014-09-29 00:00:00		2014-07-01 00:00:00		2014-09-09 00:00:00		2012-10-01 00:00:00		2013-01-31 00:00:00		2014-04-21 00:00:00		2014-01-01 00:00:00		2014-04-01 00:00:00		2014-03-27 00:00:00		2014-04-01 00:00:00		None		2012-10-01 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2018-01-01 00:00:00		2018-09-23 00:00:00		2018-04-22 00:00:00		2017-10-01 00:00:00		2018-05-10 00:00:00		2017-07-01 00:00:00		2017-07-01 00:00:00		2019-01-01 00:00:00		2019-12-31 00:00:00		2018-04-22 00:00:00		2019-07-01 00:00:00		2018-08-17 00:00:00		2015-10-01 00:00:00		2016-04-01 00:00:00		2016-01-01 00:00:00		2016-04-15 00:00:00		2016-01-01 00:00:00		2015-10-01 00:00:00		2016-06-02 00:00:00		2016-05-26 00:00:00		2016-06-07 00:00:00		2016-04-24 00:00:00		2016-08-24 00:00:00		2016-08-19 00:00:00		2016-07-01 00:00:00		2016-04-24 00:00:00		2016-10-13 00:00:00		2016-07-01 00:00:00		2016-09-25 00:00:00		2016-10-19 00:00:00		None		2016-09-25 00:00:00		2016-10-23 00:00:00		2016-10-23 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2019-10-01 00:00:00		2019-01-01 00:00:00		2020-01-01 00:00:00		2018-04-12 00:00:00		None		2018-05-20 00:00:00		2018-03-28 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2020-07-01 00:00:00		2018-08-09 00:00:00		2018-10-31 00:00:00		2018-09-23 00:00:00		2018-09-04 00:00:00		2018-07-01 00:00:00		2017-10-01 00:00:00		2019-10-01 00:00:00		2018-05-20 00:00:00		2020-07-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		None		2021-07-01 00:00:00		2022-01-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2021-09-20 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00
rpt_end		2010-12-31 00:00:00		2010-09-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		2015-02-11 00:00:00		2015-03-11 00:00:00		2014-06-30 00:00:00		2014-05-17 00:00:00		2014-05-12 00:00:00		2014-05-17 00:00:00		2014-05-27 00:00:00		2014-04-14 00:00:00		2014-06-30 00:00:00		2013-09-30 00:00:00		2013-10-23 00:00:00		2013-06-30 00:00:00		None		2013-09-30 00:00:00		2014-12-31 00:00:00		None		2014-10-29 00:00:00		2014-09-30 00:00:00		2014-10-10 00:00:00		2014-10-18 00:00:00		None		None		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-10-18 00:00:00		2008-09-30 00:00:00		None		None		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2010-04-09 00:00:00		None		2010-04-09 00:00:00		2010-04-09 00:00:00		2010-04-09 00:00:00		2009-12-31 00:00:00		2010-03-17 00:00:00		2010-05-22 00:00:00		2010-06-30 00:00:00		2010-03-17 00:00:00		2010-05-22 00:00:00		None		2010-09-30 00:00:00		2010-10-20 00:00:00		2010-10-20 00:00:00		2010-06-30 00:00:00		2010-10-16 00:00:00		2010-10-16 00:00:00		2010-09-30 00:00:00		2010-10-22 00:00:00		2010-10-28 00:00:00		None		2010-09-30 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-03-17 00:00:00		2012-03-17 00:00:00		2012-05-25 00:00:00		2012-05-19 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		2012-05-19 00:00:00		2014-03-17 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2014-03-12 00:00:00		2014-03-17 00:00:00		2012-09-30 00:00:00		2010-09-30 00:00:00		2012-09-30 00:00:00		2014-12-31 00:00:00		2014-11-06 00:00:00		None		2014-10-18 00:00:00		2012-10-31 00:00:00		2014-09-29 00:00:00		2014-09-30 00:00:00		2014-09-09 00:00:00		2012-12-31 00:00:00		2013-01-31 00:00:00		2014-04-21 00:00:00		2014-03-17 00:00:00		2014-04-01 00:00:00		2014-03-27 00:00:00		2014-04-01 00:00:00		None		2012-12-31 00:00:00		2015-09-30 00:00:00		2015-09-30 00:00:00		2018-04-21 00:00:00		2018-12-31 00:00:00		2018-05-19 00:00:00		2017-12-31 00:00:00		2018-05-10 00:00:00		2017-09-30 00:00:00		2017-09-30 00:00:00		2019-06-30 00:00:00		2019-12-31 00:00:00		2018-05-19 00:00:00		2019-09-30 00:00:00		2018-08-17 00:00:00		2015-12-31 00:00:00		2016-04-01 00:00:00		2016-04-23 00:00:00		2016-04-15 00:00:00		2016-04-23 00:00:00		2015-12-31 00:00:00		2016-06-02 00:00:00		2016-05-26 00:00:00		2016-06-07 00:00:00		2016-06-30 00:00:00		2016-08-24 00:00:00		2016-08-19 00:00:00		2016-09-24 00:00:00		2016-06-30 00:00:00		2016-10-13 00:00:00		2016-09-24 00:00:00		2016-10-22 00:00:00		2016-10-19 00:00:00		None		2016-10-22 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2019-12-31 00:00:00		2019-06-30 00:00:00		2020-06-30 00:00:00		2018-04-12 00:00:00		None		2018-06-30 00:00:00		2018-03-28 00:00:00		2018-04-21 00:00:00		2018-09-22 00:00:00		2020-12-31 00:00:00		2018-08-09 00:00:00		2018-10-31 00:00:00		2018-12-31 00:00:00		2018-09-04 00:00:00		2018-09-22 00:00:00		2017-12-31 00:00:00		2019-12-31 00:00:00		2018-06-30 00:00:00		2020-12-31 00:00:00		2019-09-30 00:00:00		2020-06-30 00:00:00		None		2021-12-31 00:00:00		2022-06-30 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2021-09-20 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00
rpt_date		None		None		None		2015-07-27 00:00:00		None		None		2015-03-11 00:00:00		None		None		2014-05-12 00:00:00		2014-05-22 00:00:00		2014-05-27 00:00:00		2014-04-14 00:00:00		2014-07-28 00:00:00		2013-10-24 00:00:00		None		2013-07-22 00:00:00		None		None		None		None		2014-10-29 00:00:00		None		2014-10-10 00:00:00		2014-10-23 00:00:00		None		None		None		None		None		None		None		None		None		None		2009-07-27 00:00:00		None		None		None		None		None		None		2010-01-27 00:00:00		2010-03-22 00:00:00		2010-05-26 00:00:00		2010-07-28 00:00:00		None		None		None		None		2010-10-20 00:00:00		2010-10-20 00:00:00		None		None		2010-10-21 00:00:00		None		2010-10-22 00:00:00		2010-10-28 00:00:00		None		2010-10-22 00:00:00		2010-10-05 00:00:00		2011-01-26 00:00:00		None		2011-07-27 00:00:00		None		None		2012-01-27 00:00:00		None		2012-03-22 00:00:00		2012-05-25 00:00:00		2012-05-24 00:00:00		2012-07-26 00:00:00		None		None		2014-03-17 00:00:00		None		2014-01-24 00:00:00		2014-03-12 00:00:00		None		2012-10-05 00:00:00		2012-10-05 00:00:00		None		2015-01-27 00:00:00		None		None		None		2012-10-31 00:00:00		2014-09-29 00:00:00		2014-10-06 00:00:00		2014-09-09 00:00:00		2013-01-31 00:00:00		None		2014-04-21 00:00:00		2014-03-21 00:00:00		2014-04-01 00:00:00		2014-03-27 00:00:00		2014-04-01 00:00:00		None		None		2015-10-27 00:00:00		None		2018-04-25 00:00:00		2019-01-29 00:00:00		2018-05-24 00:00:00		None		2018-05-10 00:00:00		2017-10-23 00:00:00		None		2019-07-23 00:00:00		2019-12-31 00:00:00		None		2019-10-21 00:00:00		2018-08-17 00:00:00		None		2016-04-01 00:00:00		2016-04-27 00:00:00		2016-04-15 00:00:00		None		2016-02-01 00:00:00		2016-06-02 00:00:00		2016-05-26 00:00:00		2016-06-07 00:00:00		2016-07-26 00:00:00		2016-08-24 00:00:00		2016-08-19 00:00:00		2016-09-28 00:00:00		None		2016-10-13 00:00:00		None		2016-10-26 00:00:00		None		None		None		2017-01-31 00:00:00		None		2017-07-13 00:00:00		None		2020-01-29 00:00:00		None		None		None		None		None		2018-03-28 00:00:00		None		None		None		2018-08-09 00:00:00		2018-10-31 00:00:00		None		2018-09-04 00:00:00		2018-09-26 00:00:00		2018-01-29 00:00:00		None		2018-07-24 00:00:00		2021-01-29 00:00:00		None		2020-07-30 00:00:00		None		None		2022-07-15 00:00:00		None		2022-01-26 00:00:00		None		2021-07-14 00:00:00		None
filing_type		None		None		None		22001		None		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		None		None		None		None		22001		None		22001		22001		None		None		None		None		None		None		None		None		None		None		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		None		None		None		None		22001		22001		None		None		22001		None		22001		22001		None		22001		22001		22001		None		22001		None		None		22001		None		22001		22001		22001		22001		None		None		22001		None		22001		22001		None		22001		22001		None		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		None		22001		22001		22001		None		22001		22001		None		22001		22001		None		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		None		22001		22001		None		None		22001		None		22001		None		22001		None		None		22001		None		None		22001		None		None		None		22001		22001		None		22001		22001		22001		None		22001		22001		None		22001		None		None		22001		None		22001		22001		22001		None

Table: filer_to_filer_type

filer_id		1305799		1305799
filer_type		16		16
active		Y		Y
race		0		0
session_id		2007		2007
category		0		0
category_type		40502		40502
sub_category		40103		40103
effect_dt		2008-06-20 00:00:00		2008-04-04 00:00:00
sub_category_type		0		0
election_type		0		0
sub_category_a		S		S
nyq_dt		2008-06-11 00:00:00		None
party_cd		0		0
county_cd		18004		18004
district_cd		0		0

Table: filer_xref

filer_id		1305799
xref_id		1305799
effect_dt		2008-04-04 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1305799		1305799		1305799		1305799		1305799		1305799		1305799
filer_id		1305799		1305799		1305799		1305799		1305799		1305799		1305799
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2008-06-20 00:00:00		2008-06-20 00:00:00		2008-06-20 00:00:00		2008-06-20 00:00:00		2008-06-20 00:00:00		2008-06-20 00:00:00		2008-06-20 00:00:00
naml		ALLIANCE OF AUTOMOBILE MANUFACTURERS CALIFORNIA PAC		ALLIANCE OF AUTOMOBILE MANUFACTURERS CALIFORNIA PAC		ALLIANCE OF AUTOMOBILE MANUFACTURERS CALIFORNIA PAC		ALLIANCE OF AUTOMOBILE MANUFACTURERS CALIFORNIA PAC		ALLIANCE OF AUTOMOBILE MANUFACTURERS CALIFORNIA PAC		ALLIANCE OF AUTOMOBILE MANUFACTURERS CALIFORNIA PAC		ALLIANCE OF AUTOMOBILE MANUFACTURERS CALIFORNIA PAC
namf		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None
city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		CA		CA		CA		CA		CA		CA		CA
zip4		95814		95814		95814		95814		95814		95814		95814
phon		9164422952		9164422952				9164422952		9164422952		9164422952		9164422952
fax		None		None		None		None		None		None		None
email		None		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1305799

Table: received_filings

filer_id		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799		1305799
filing_file_name		1849220_0.cal		1829403_0.cal		1834774_0.cal		1838353_0.cal		1835099_0.cal		1834281_0.cal		1532969_0.cal		105598.cal		1827701_0.cal		1839756_0.cal		1855321_0.cal		2050081_0.cal		2047044_0.cal		2048984_0.cal		1883561_0.cal		2025484_0.cal		2028966_0.cal		1889155_0.cal		1896538_0.cal		2088874_0.cal		1908940_0.cal		2070349_0.cal		2071507_0.cal		1953140_0.cal		2248120_0.cal		2427567_0.cal		2284338_0.cal		2226032_0.cal		2281958_0.cal		2320759_0.cal		2288695_0.cal
received_date		2014-05-12 00:00:00		2014-03-17 00:00:00		2014-04-01 00:00:00		2014-04-14 00:00:00		2014-04-01 00:00:00		2014-03-27 00:00:00		2010-10-22 00:00:00		2012-10-05 00:00:00		2014-03-12 00:00:00		2014-04-21 00:00:00		2014-05-27 00:00:00		2016-06-07 00:00:00		2016-05-26 00:00:00		2016-06-02 00:00:00		2014-09-09 00:00:00		2016-04-01 00:00:00		2016-04-15 00:00:00		2014-09-29 00:00:00		2014-10-10 00:00:00		2016-10-14 00:00:00		2014-10-29 00:00:00		2016-08-19 00:00:00		2016-08-24 00:00:00		2015-03-11 00:00:00		2018-05-10 00:00:00		2019-12-31 00:00:00		2018-08-17 00:00:00		2018-03-28 00:00:00		2018-08-09 00:00:00		2018-10-31 00:00:00		2018-09-04 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		1849220		1829403		1834774		1838353		1835099		1834281		1532969		None		1827701		1839756		1855321		2050081		2047044		2048984		1883561		2025484		2028966		1889155		1896538		2088874		1908940		2070349		2071507		1953140		2248120		2427567		2284338		2226032		2281958		2320759		2288695
form_id		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted