OpenCalAccess

Filer ID: 1268678

Table: cvr_lobby_disclosure
filing_id	1056126	1081063	1173345	1144309	1130826	1105421	1116012	1274131	1277653	1238356	1216668	1191629	1371039	1311525	1311525	1346666	1296938	1327500	1451776	1421118	1430227	1397819	1507478	1483280	1503355	1464562	1539531	1567768	1592022	1604838	1619065	1636120	1657551	1708436	1680514	1732766	1763177	1797152	1780206	1763177	1780206	1811068	1841168	1866946	1909939	1932408	1993821	1978401	1962793	2060957	2037389	2008626	2101729	2151768	2127494	2192258	2176486	2241164	2277111	2207225	2319193	2349385	2396137	2381478	2419389	2444247	2471473	2555269	2532009	2485228	2602963	2578261	2622155	2644744	2703074	2677309	2745004
amend_id	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	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
form_type	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615
sender_id	E00234	E00234	E00234	E00234	E00234	1268678	1268678	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00913	E00234	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913
filer_id	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678
entity_cd	LBY	LBY	LBY	LBY	LBY	FRM	FRM	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY
filer_naml	Smith	Smith	Smith	Smith	Smith	SMITH	SMITH	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith
filer_namf	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	JEREMY	JEREMY	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy L.	Jeremy	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.
filer_namt	Mr.	Mr.	Mr.	Mr.	Mr.	None	None	None	None	None	Mr.	Mr.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
report_num	000	000	000	000	000	000	000	000	000	000	000	000	000	001	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	001	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	2004-10-31 00:00:00	2005-01-31 00:00:00	2006-05-24 00:00:00	2006-01-31 00:00:00	2005-10-31 00:00:00	2005-05-02 00:00:00	2005-07-28 00:00:00	2007-06-18 00:00:00	2007-07-17 00:00:00	2007-01-31 00:00:00	2006-10-31 00:00:00	2006-07-31 00:00:00	2008-10-24 00:00:00	2008-01-31 00:00:00	2008-01-31 00:00:00	2008-07-28 00:00:00	2007-10-31 00:00:00	2008-04-28 00:00:00	2009-10-30 00:00:00	2009-04-30 00:00:00	2009-07-13 00:00:00	2009-02-02 00:00:00	2010-08-02 00:00:00	2010-04-28 00:00:00	2010-07-26 00:00:00	2010-02-01 00:00:00	2010-10-30 00:00:00	2011-01-27 00:00:00	2011-05-02 00:00:00	2011-07-27 00:00:00	2011-10-24 00:00:00	2012-01-31 00:00:00	2012-04-30 00:00:00	2012-10-31 00:00:00	2012-07-31 00:00:00	2013-01-25 00:00:00	2013-04-29 00:00:00	2013-10-21 00:00:00	2013-08-22 00:00:00	2013-08-20 00:00:00	2013-07-23 00:00:00	2014-01-13 00:00:00	2014-04-12 00:00:00	2014-07-16 00:00:00	2014-10-22 00:00:00	2015-01-14 00:00:00	2015-10-07 00:00:00	2015-07-22 00:00:00	2015-04-17 00:00:00	2016-07-01 00:00:00	2016-04-21 00:00:00	2016-01-21 00:00:00	2016-10-12 00:00:00	2017-04-03 00:00:00	2017-01-26 00:00:00	2017-10-27 00:00:00	2017-07-28 00:00:00	2018-04-09 00:00:00	2018-07-31 00:00:00	2018-01-09 00:00:00	2018-10-31 00:00:00	2019-01-28 00:00:00	2019-07-24 00:00:00	2019-04-30 00:00:00	2019-10-18 00:00:00	2020-01-30 00:00:00	2020-04-30 00:00:00	2021-02-01 00:00:00	2020-11-02 00:00:00	2020-07-28 00:00:00	2021-07-27 00:00:00	2021-04-28 00:00:00	2021-10-28 00:00:00	2022-01-28 00:00:00	2022-07-15 00:00:00	2022-05-02 00:00:00	2022-10-24 00:00:00
from_date	2004-07-01 00:00:00	2004-10-01 00:00:00	2006-01-01 00:00:00	2005-10-01 00:00:00	2005-07-01 00:00:00	2005-01-01 00:00:00	2005-04-01 00:00:00	2007-01-01 00:00:00	2007-04-01 00:00:00	2006-10-01 00:00:00	2006-07-01 00:00:00	2006-04-01 00:00:00	2008-07-01 00:00:00	2007-09-01 00:00:00	2007-09-01 00:00:00	2008-04-01 00:00:00	2007-07-01 00:00:00	2008-01-01 00:00:00	2009-07-01 00:00:00	2009-01-01 00:00:00	2009-04-01 00:00:00	2008-10-01 00:00:00	2010-04-01 00:00:00	2010-01-01 00:00:00	2010-06-07 00:00:00	2009-10-01 00:00:00	2010-07-01 00:00:00	2010-10-01 00:00:00	2011-01-01 00:00:00	2011-04-01 00:00:00	2011-07-01 00:00:00	2011-10-01 00:00:00	2012-01-01 00:00:00	2012-07-01 00:00:00	2012-04-01 00:00:00	2012-10-01 00:00:00	2013-01-01 00:00:00	2013-07-01 00:00:00	2013-04-01 00:00:00	2013-01-01 00:00:00	2013-04-01 00:00:00	2013-10-01 00:00:00	2014-01-01 00:00:00	2014-04-01 00:00:00	2014-07-01 00:00:00	2014-10-01 00:00:00	2015-07-01 00:00:00	2015-04-01 00:00:00	2015-01-01 00:00:00	2016-04-01 00:00:00	2016-01-01 00:00:00	2015-10-01 00:00:00	2016-07-01 00:00:00	2017-01-01 00:00:00	2016-10-01 00:00:00	2017-07-01 00:00:00	2017-04-01 00:00:00	2018-01-01 00:00:00	2018-04-01 00:00:00	2017-10-01 00:00:00	2018-07-01 00:00:00	2018-10-01 00:00:00	2019-04-01 00:00:00	2019-01-01 00:00:00	2019-07-01 00:00:00	2019-10-01 00:00:00	2020-01-01 00:00:00	2020-10-01 00:00:00	2020-07-01 00:00:00	2020-04-01 00:00:00	2021-04-01 00:00:00	2021-01-01 00:00:00	2021-07-01 00:00:00	2021-10-01 00:00:00	2022-04-01 00:00:00	2022-01-01 00:00:00	2022-07-01 00:00:00
thru_date	2004-09-30 00:00:00	2004-12-31 00:00:00	2006-03-31 00:00:00	2005-12-31 00:00:00	2005-09-30 00:00:00	2005-03-31 00:00:00	2005-06-30 00:00:00	2007-03-31 00:00:00	2007-06-30 00:00:00	2006-12-31 00:00:00	2006-09-30 00:00:00	2006-06-30 00:00:00	2008-09-30 00:00:00	2007-12-31 00:00:00	2007-12-31 00:00:00	2008-06-30 00:00:00	2007-09-30 00:00:00	2008-03-31 00:00:00	2009-09-30 00:00:00	2009-03-31 00:00:00	2009-06-30 00:00:00	2008-12-31 00:00:00	2010-06-30 00:00:00	2010-03-31 00:00:00	2010-06-30 00:00:00	2009-12-31 00:00:00	2010-09-30 00:00:00	2010-12-31 00:00:00	2011-03-31 00:00:00	2011-06-30 00:00:00	2011-09-30 00:00:00	2011-12-31 00:00:00	2012-03-31 00:00:00	2012-09-30 00:00:00	2012-06-30 00:00:00	2012-12-31 00:00:00	2013-03-31 00:00:00	2013-09-30 00:00:00	2013-06-30 00:00:00	2013-03-31 00:00:00	2013-06-30 00:00:00	2013-12-31 00:00:00	2014-03-31 00:00:00	2014-06-30 00:00:00	2014-09-30 00:00:00	2014-12-31 00:00:00	2015-09-30 00:00:00	2015-06-30 00:00:00	2015-03-31 00:00:00	2016-06-30 00:00:00	2016-03-31 00:00:00	2015-12-31 00:00:00	2016-09-30 00:00:00	2017-03-31 00:00:00	2016-12-31 00:00:00	2017-09-30 00:00:00	2017-06-30 00:00:00	2018-03-31 00:00:00	2018-06-30 00:00:00	2017-12-31 00:00:00	2018-09-30 00:00:00	2018-12-31 00:00:00	2019-06-30 00:00:00	2019-03-31 00:00:00	2019-09-30 00:00:00	2019-12-31 00:00:00	2020-03-31 00:00:00	2020-12-31 00:00:00	2020-09-30 00:00:00	2020-06-30 00:00:00	2021-06-30 00:00:00	2021-03-31 00:00:00	2021-09-30 00:00:00	2021-12-31 00:00:00	2022-06-30 00:00:00	2022-03-31 00:00:00	2022-09-30 00:00:00
cum_beg_dt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
firm_id	E00234	E00234	E00234	E00234	E00234	1268678	1268678	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00234	E00913	E00234	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913
firm_name	California Labor Federation, AFL-CIO	California Labor Federation, AFL-CIO	California Labor Federation, AFL-CIO	California Labor Federation, AFL-CIO	California Labor Federation, AFL-CIO	California Labor Federation, AFL-CIO	CALIFORNIA LABOR FEDERATION	CALIFORNIA LABOR FEDERATION, AFL-CIO	CALIFORNIA LABOR FEDERATION, AFL-CIO	California Labor Federation, AFL-CIO	California Labor Federation, AFL-CIO	California Labor Federation, AFL-CIO	CALIFORNIA LABOR FEDERATION, AFL-CIO	CALIFORNIA LABOR FEDERATION, AFL-CIO	CALIFORNIA LABOR FEDERATION, AFL-CIO	CALIFORNIA LABOR FEDERATION, AFL-CIO	CALIFORNIA LABOR FEDERATION, AFL-CIO	CALIFORNIA LABOR FEDERATION, AFL-CIO	CALIFORNIA LABOR FEDERATION, AFL-CIO	CALIFORNIA LABOR FEDERATION, AFL-CIO	CALIFORNIA LABOR FEDERATION, AFL-CIO	CALIFORNIA LABOR FEDERATION, AFL-CIO	CALIFORNIA LABOR FEDERATION, AFL-CIO	CALIFORNIA LABOR FEDERATION, AFL-CIO	State Building and Construction Trades Council of California	CALIFORNIA LABOR FEDERATION, AFL-CIO	State Building and Construction Trades Council of California	State Building and Construction Trades Council of California	State Building and Construction Trades Council of California	State Building and Construction Trades Council of California	State Building and Construction Trades Council of California	State Building and Construction Trades Council of California	State Building and Construction Trades Council of California	State Building and Construction Trades Council of California	State Building and Construction Trades Council of California	State Building and Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California
firm_city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	SACRAMENTO	SACRAMENTO	SAN FRANCISCO	SAN FRANCISCO	SACRAMENTO	SACRAMENTO	Sacramento	SAN FRANCISCO	SAN FRANCISCO	SAN FRANCISCO	SAN FRANCISCO	SAN FRANCISCO	SAN FRANCISCO	SAN FRANCISCO	SAN FRANCISCO	SAN FRANCISCO	SAN FRANCISCO	SAN FRANCISCO	SAN FRANCISCO	Sacramento	SAN FRANCISCO	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
firm_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
firm_zip4	95814	95814	95814	95814	95814	95814	95814	94104	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
firm_phon	(916) 444-3676	(916) 444-3676	(916) 444-3676	(916) 444-3676	(916) 444-3676	9164443676	9164443676	916 444 3676	916 444 3676	(916) 444-3676	(916) 444-3676	(916) 444-3676	916 444 3676	916 444 3676	916 444 3676	916 444 3676	916 444 3676	916 444 3676	916 444 3676	916 444 3676	916 444 3676	916 444 3676	916 444 3676	916 444 3676	(916) 443-3302	916 444 3676	(916) 443-3302	(916) 443-3302	(916) 443-3302	(916) 443-3302	(916) 443-3302	(916) 443-3302	(916) 443-3302	(916) 443-3302	(916) 443-3302	(916) 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302
mail_city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	None	None	None	None	SACRAMENTO	SACRAMENTO	Sacramento	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_st	CA	CA	CA	CA	CA	None	None	None	None	CA	CA	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_zip4	95814	95814	95814	95814	95814	None	None	None	None	95814	95814	95814	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_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
sig_date	2004-10-29 00:00:00	2005-01-31 00:00:00	2006-05-24 00:00:00	2006-01-16 00:00:00	2005-10-31 00:00:00	2005-05-02 00:00:00	2005-07-28 00:00:00	2007-06-18 00:00:00	2007-07-17 00:00:00	2007-01-31 00:00:00	2006-10-31 00:00:00	2006-07-31 00:00:00	2008-10-24 00:00:00	2008-01-31 00:00:00	2008-01-31 00:00:00	2008-07-28 00:00:00	2007-10-31 00:00:00	2008-04-28 00:00:00	2009-10-30 00:00:00	2009-04-30 00:00:00	2009-07-13 00:00:00	2009-02-02 00:00:00	2010-08-02 00:00:00	2010-04-28 00:00:00	2010-07-14 00:00:00	2010-02-01 00:00:00	2010-10-19 00:00:00	2011-01-19 00:00:00	2011-04-22 00:00:00	2011-07-27 00:00:00	2011-10-13 00:00:00	2012-01-30 00:00:00	2012-04-26 00:00:00	2012-10-29 00:00:00	2012-07-26 00:00:00	2013-01-18 00:00:00	2013-04-29 00:00:00	2013-10-21 00:00:00	2013-07-23 00:00:00	2013-04-29 00:00:00	2013-07-23 00:00:00	2014-01-13 00:00:00	2014-04-12 00:00:00	2014-07-16 00:00:00	2014-10-22 00:00:00	2015-01-14 00:00:00	2015-10-07 00:00:00	2015-07-22 00:00:00	2015-04-17 00:00:00	2016-07-01 00:00:00	2016-04-21 00:00:00	2016-01-21 00:00:00	2016-10-12 00:00:00	2017-04-03 00:00:00	2017-01-26 00:00:00	2017-10-27 00:00:00	2017-07-28 00:00:00	2018-04-09 00:00:00	2018-06-29 00:00:00	2018-01-09 00:00:00	2018-10-31 00:00:00	2019-01-28 00:00:00	2019-07-24 00:00:00	2019-04-29 00:00:00	2019-10-18 00:00:00	2020-01-30 00:00:00	2020-04-30 00:00:00	2021-02-01 00:00:00	2020-11-02 00:00:00	2020-07-28 00:00:00	2021-07-27 00:00:00	2021-04-28 00:00:00	2021-10-28 00:00:00	2022-01-28 00:00:00	2022-07-15 00:00:00	2022-05-02 00:00:00	2022-10-24 00:00:00
sig_loc	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	OAKLAND, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	Sacramento, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	Sacramento, CA	SACRAMENTO, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA
sig_naml	Smith	Smith	Smith	Smith	Smith	Smith	SMITH	SMITH	SMITH	SMITH	SMITH	Smith	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	Smith	SMITH	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Baca	Smith	Smith	Smith	Baca	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith
sig_namf	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	Jeremy	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	Jeremy L.	JEREMY	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	J. Tom	Jeremy L.	Jeremy L.	Jeremy L.	J. Tom	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.
sig_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
sig_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
prn_naml	Smith	Smith	Smith	Smith	Smith	None	None	SMITH	SMITH	SMITH	SMITH	Smith	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	None	SMITH	None	None	None	None	None	None	None	None	None	None	Baca	Smith	Smith	Smith	Baca	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith
prn_namf	Jeremy	Jeremy	Jeremy	Jeremy	Jeremy	None	None	JEREMY	JEREMY	JEREMY	JEREMY	Jeremy	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	None	JEREMY	None	None	None	None	None	None	None	None	None	None	J. Tom	Jeremy L.	Jeremy L.	Jeremy L.	J. Tom	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.
prn_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
prn_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
sig_title	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Secretary/Treasurer	Lobbyist	Lobbyist	Lobbyist	Secretary/Treasurer	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist
nopart1_cb	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X
nopart2_cb	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X
part1_1_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
part1_2_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
ctrib_n_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
ctrib_y_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
lby_actvty	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lobby_n_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
lobby_y_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
major_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
major_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
major_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
major_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
rcpcmte_nm	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rcpcmte_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

Table: cvr_registration
filing_id	1551608	1498361	1715521	1715521	1917179	2111800	2329003	2541129
amend_id	0	0	0	1	0	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F604	F604	F604	F604	F604	F604	F604	F604
sender_id	E00913	E00913	E00913	E00913	E00913	E00913	E00913	E00913
filer_id	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678
entity_cd	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY
filer_naml	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith
filer_namf	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.
filer_namt	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None
report_num	000	000	000	001	000	000	000	000
rpt_date	2010-12-17 00:00:00	2010-06-23 00:00:00	2013-01-01 00:00:00	2013-03-01 00:00:00	2015-01-01 00:00:00	2018-12-31 00:00:00	2020-12-31 00:00:00	2022-12-31 00:00:00
ls_beg_yr	2011	2009	2013	2013	2015	2017	2019	2021
ls_end_yr	2012	2010	2014	2014	2016	2018	2020	2022
qual_date	None	None	None	None	None	None	None	None
eff_date	None	None	None	None	None	None	None	None
bus_city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
bus_st	CA	CA	CA	CA	CA	CA	CA	CA
bus_zip4	95814	95814	95814	95814	95814	95814	95814	95814
bus_phon	916 443-3302	(916) 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302	916 443-3302
bus_fax	916 443-8204	(916) 443-8204	916 443-8204	916 443-8204	916 443-8204	916 443-8204	916 443-8204	916 443-8204
bus_email	None	None	None	None	None	[email protected]	[email protected]	[email protected]
mail_city	None	None	None	None	None	None	None	None
mail_st	None	None	None	None	None	None	None	None
mail_zip4	None	None	None	None	None	None	None	None
mail_phon	None	None	None	None	None	None	None	None
sig_date	2010-12-13 00:00:00	2010-06-07 00:00:00	2012-11-20 00:00:00	2013-05-15 00:00:00	2014-11-20 00:00:00	2016-12-14 00:00:00	2018-12-20 00:00:00	2020-12-22 00:00:00
sig_loc	None	None	Concord CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA
sig_naml	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith
sig_namf	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.
sig_namt	None	None	None	None	None	None	None	None
sig_nams	None	None	None	None	None	None	None	None
prn_naml	Smith	None	Smith	Smith	Smith	Smith	Smith	Smith
prn_namf	Jeremy L.	None	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.	Jeremy L.
prn_namt	None	None	None	None	None	None	None	None
prn_nams	None	None	None	None	None	None	None	None
sig_title	Lobbyist	None	None	None	None	None	None	None
stmt_firm	None	None	None	None	None	None	None	None
ind_cb	None	None	None	None	None	None	None	None
bus_cb	None	None	None	None	None	None	None	None
trade_cb	None	None	None	None	None	None	None	None
oth_cb	None	None	None	None	None	None	None	None
a_b_name	None	None	None	None	None	None	None	None
a_b_city	None	None	None	None	None	None	None	None
a_b_st	None	None	None	None	None	None	None	None
a_b_zip4	None	None	None	None	None	None	None	None
descrip_1	None	None	None	None	None	None	None	None
descrip_2	None	None	None	None	None	None	None	None
c_less50	None	None	None	None	None	None	None	None
c_more50	None	None	None	None	None	None	None	None
ind_class	None	None	None	None	None	None	None	None
ind_descr	None	None	None	None	None	None	None	None
bus_class	None	None	None	None	None	None	None	None
bus_descr	None	None	None	None	None	None	None	None
auth_name	None	None	None	None	None	None	None	None
auth_city	None	None	None	None	None	None	None	None
auth_st	None	None	None	None	None	None	None	None
auth_zip4	None	None	None	None	None	None	None	None
lobby_int	None	None	None	None	None	None	None	None
influen_yn	None	None	None	None	None	None	None	None
firm_name	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California	State Building & Construction Trades Council of California
newcert_cb	None	None	None	None	None	None	None	None
rencert_cb	None	None	X	None	None	None	None	None
complet_dt	2010-11-17 00:00:00	2009-01-16 00:00:00	None	2013-02-28 00:00:00	2014-11-13 00:00:00	2016-11-17 00:00:00	2018-11-15 00:00:00	2020-12-11 00:00:00
lby_reg_cb	X	X	X	X	X	X	X	X
lby_604_cb	None	None	None	None	None	None	None	None
st_leg_yn	None	None	None	None	None	None	None	None
st_agency	None	None	None	None	None	None	None	None
lobby_cb	None	None	None	None	None	None	None	None
l_firm_cb	None	None	None	None	None	None	None	None

Table: filer_address
filer_id	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678
adrid	2189964	2081421	2071996	2113391	2160989	2204408	2411844	2506668	2467308	2278053	2546460	2339145
effect_dt	2010-06-07 00:00:00	2005-01-01 00:00:00	2004-08-02 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2017-01-01 00:00:00	2021-01-01 00:00:00	2019-01-01 00:00:00	2013-01-01 00:00:00	2023-01-01 00:00:00	2015-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	2009	2005	2003	2007	2009	2011	2017	2021	2019	2013	2023	2015

Table: filer_ethics_class
filer_id	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678
session_id	2005	2011	2009	2007	2015	2013	2019	2021
ethics_date	2004-11-17 00:00:00	2010-11-17 00:00:00	2009-01-16 00:00:00	2007-04-19 00:00:00	2014-11-13 00:00:00	2013-02-28 00:00:00	2018-11-15 00:00:00	2020-12-11 00:00:00

Table: filer_filings
filer_id	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678
filing_id	1039003	1039005	1073651	1061984	1105421	1056126	1093805	1081063	1116012	1144309	1130826	1173345	1191629	1216668	1228625	1265635	1274131	1238356	1277653	1296938	1763177	1780206	1978401	1962793	1866946	1780206	1797152	1811068	1909939	1311525	1311525	1346666	1327500	1371039	1406513	1406513	1421118	1397819	1430227	1464562	1451776	1483280	1503355	1498539	1507478	1498361	1539531	1551463	1567768	1551608	1592022	1619065	1604838	1636120	1657551	1680514	1922683	1932408	1917179	1718888	1708436	1715521	1732766	1841168	1751866	1763177	1715521	2396137	2419389	2192258	2555269	2319193	2349385	2329003	2241164	2008626	1993821	2037389	2060957	2101729	2112053	2111800	2127494	2151768	2176486	2335844	2277111	2444247	2485228	2207225	2563796	2532009	2471473	2541129	2381478	2602963	2644744	2703074	2578261	2622155	2677309	2745004
period_id	None	None	None	None	181	179	None	180	182	184	183	185	186	187	None	None	189	188	190	191	213	214	222	221	218	214	215	216	219	191	191	194	193	195	None	None	197	196	198	200	199	201	202	None	202	202	203	None	204	204	205	207	206	208	209	210	None	220	221	None	211	213	212	217	None	213	213	238	239	231	244	235	236	244	233	224	223	225	226	227	None	236	228	229	230	None	234	240	242	232	None	243	241	252	237	246	248	250	245	247	249	251
form_id	F604	F999	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F604	F615	F615	F615	F615	F615	F615	F615	F604	F615	F604	F615	F604	F615	F604	F615	F615	F615	F615	F615	F615	F604	F615	F604	F604	F615	F604	F615	F615	F604	F615	F604	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F604	F604	F615	F615	F615	F604	F615	F615	F615	F615	F604	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
filing_date	2004-08-20 00:00:00	2004-08-25 00:00:00	2004-12-30 00:00:00	2004-11-01 00:00:00	2005-05-02 00:00:00	2004-10-28 00:00:00	2004-01-31 00:00:00	2005-01-31 00:00:00	2005-07-28 00:00:00	2006-01-25 00:00:00	2005-10-26 00:00:00	2006-05-24 00:00:00	2006-07-31 00:00:00	2006-10-31 00:00:00	2007-01-04 00:00:00	2007-04-19 00:00:00	2007-06-18 00:00:00	2007-01-31 00:00:00	2007-07-17 00:00:00	2007-10-31 00:00:00	2013-08-29 00:00:00	2013-08-29 00:00:00	2015-07-28 00:00:00	2015-04-27 00:00:00	2014-07-25 00:00:00	2013-07-29 00:00:00	2013-10-25 00:00:00	2014-01-17 00:00:00	2014-10-30 00:00:00	2008-01-31 00:00:00	2008-02-07 00:00:00	2008-07-28 00:00:00	2008-04-28 00:00:00	2008-10-24 00:00:00	2008-12-23 00:00:00	2009-01-16 00:00:00	2009-04-30 00:00:00	2009-02-02 00:00:00	2009-07-13 00:00:00	2010-02-01 00:00:00	2009-10-30 00:00:00	2010-04-28 00:00:00	2010-07-26 00:00:00	2010-06-22 00:00:00	2010-08-02 00:00:00	2010-06-23 00:00:00	2010-10-30 00:00:00	2010-12-16 00:00:00	2011-01-27 00:00:00	2010-12-17 00:00:00	2011-05-02 00:00:00	2011-10-24 00:00:00	2011-07-27 00:00:00	2012-01-31 00:00:00	2012-04-30 00:00:00	2012-07-31 00:00:00	2014-12-05 00:00:00	2015-01-29 00:00:00	2014-12-05 00:00:00	2012-11-30 00:00:00	2012-10-31 00:00:00	2012-11-30 00:00:00	2013-01-25 00:00:00	2014-04-24 00:00:00	2013-02-28 00:00:00	2013-04-29 00:00:00	2013-05-15 00:00:00	2019-07-30 00:00:00	2019-10-31 00:00:00	2017-10-30 00:00:00	2021-02-01 00:00:00	2018-10-31 00:00:00	2019-01-31 00:00:00	2018-12-20 00:00:00	2018-04-30 00:00:00	2016-01-28 00:00:00	2015-10-23 00:00:00	2016-05-02 00:00:00	2016-07-29 00:00:00	2016-10-31 00:00:00	2016-12-16 00:00:00	2016-12-19 00:00:00	2017-01-30 00:00:00	2017-04-19 00:00:00	2017-07-31 00:00:00	2018-12-19 00:00:00	2018-07-31 00:00:00	2020-01-31 00:00:00	2020-07-31 00:00:00	2018-01-29 00:00:00	2020-12-30 00:00:00	2020-11-02 00:00:00	2020-04-30 00:00:00	2020-12-30 00:00:00	2019-04-30 00:00:00	2021-08-02 00:00:00	2022-01-31 00:00:00	2022-07-28 00:00:00	2021-04-28 00:00:00	2021-10-29 00:00:00	2022-05-02 00:00:00	2022-10-28 00:00:00
stmnt_type	10005	10005	10005	10005	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10005	10006	10001	10001	10001	10001	10002	10002	10001	10001	10001	10001	10001	10001	10001	10001	10002	10001	10001	10001	10005	10006	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10005	10001	10001	10001	10001	10006	10001	10002	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001
stmnt_status	11001	11001	11003	11001	11001	11003	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	11001	11001	11003	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	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11003
session_id	2003	2003	2005	2003	2005	2003	2003	2003	2005	2005	2005	2005	2005	2005	2007	2007	2007	2005	2007	2007	2013	2013	2015	2015	2013	2013	2013	2013	2013	2007	2007	2007	2007	2007	2009	2009	2009	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2009	2011	2011	2011	2011	2011	2011	2011	2015	2013	2015	2013	2011	2013	2011	2013	2013	2013	2013	2019	2019	2017	2019	2017	2017	2019	2017	2015	2015	2015	2015	2015	2017	2017	2015	2017	2017	2019	2017	2019	2019	2017	2021	2019	2019	2021	2019	2021	2021	2021	2021	2021	2021	2021
user_id	SARRIAGA	SARRIAGA	EMCENTEE	LTHIBAUL	LTHIBAUL	COMPLETED	LTHIBAUL	COMPLETED	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	SARRIAGA	SARRIAGA	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	ASAETERN	AGLADNEY	JINGRAM	JINGRAM	ASAETERN	AGLADNEY	ASAETERN	AGLADNEY	AGLADNEY	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	JINGRAM	JVAZQUEZ	JVAZQUEZ	MGUERRA	JINGRAM	MGUERRA	WBROWN	MGUERRA	JINGRAM	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	ASAETERN	PBANFORD	ASAETERN	PBANFORD	JINGRAM	JINGRAM	ASAETERN	ASAETERN	ASAETERN	AGLADNEY	YRODRIGU	AGLADNEY	YRODRIGU	SARRIAGA	ASAETERN	SARRIAGA	ASAETERN	AGLADNEY	SMCCONNAN	AGLADNEY	YRODRIGU	VUKSTINA	GTAYLOR	SMCCONNAN	CHARTRIDGE	JFRONEFIELD	AGLADNEY	SARRIAGA	AGLADNEY	AGLADNEY	JINGRAM	AGLADNEY	AGLADNEY	AGLADNEY	GPEREZ	CAFILER	AGLADNEY	SMCCONNAN	SMCCONNAN	DMCCASTL	AGLADNEY	VUKSTINA	MMERCHANT	AGLADNEY	CVANLIEW	MKIRKHAM	VUKSTINA	CVANLIEW	VUKSTINA	MKIRKHAM	RATTIYEH	CAFILER	CHARTRIDGE	GTAYLOR	CAFILER	CAFILER
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
fine_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11001	11001	11001	11003	11001	11001	11003	11003
rpt_start	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2004-07-01 00:00:00	2005-01-01 00:00:00	2004-07-01 00:00:00	2004-10-01 00:00:00	2004-10-01 00:00:00	2005-04-01 00:00:00	2005-10-01 00:00:00	2005-07-01 00:00:00	2006-01-01 00:00:00	2006-04-01 00:00:00	2006-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-01-01 00:00:00	2006-10-01 00:00:00	2007-04-01 00:00:00	2007-07-01 00:00:00	2013-01-01 00:00:00	2013-04-01 00:00:00	2015-04-01 00:00:00	2015-01-01 00:00:00	2014-04-01 00:00:00	2013-04-01 00:00:00	2013-07-01 00:00:00	2013-10-01 00:00:00	2014-07-01 00:00:00	2007-09-01 00:00:00	2007-09-01 00:00:00	2008-04-01 00:00:00	2008-01-01 00:00:00	2008-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-01-01 00:00:00	2008-10-01 00:00:00	2009-04-01 00:00:00	2009-10-01 00:00:00	2009-07-01 00:00:00	2010-01-01 00:00:00	2010-06-07 00:00:00	1900-01-01 00:00:00	2010-04-01 00:00:00	2010-06-23 00:00:00	2010-07-01 00:00:00	1900-01-01 00:00:00	2010-10-01 00:00:00	2010-12-17 00:00:00	2011-01-01 00:00:00	2011-07-01 00:00:00	2011-04-01 00:00:00	2011-10-01 00:00:00	2012-01-01 00:00:00	2012-04-01 00:00:00	1900-01-01 00:00:00	2014-10-01 00:00:00	2015-01-01 00:00:00	1900-01-01 00:00:00	2012-07-01 00:00:00	2013-01-01 00:00:00	2012-10-01 00:00:00	2014-01-01 00:00:00	1900-01-01 00:00:00	2013-01-01 00:00:00	2013-03-01 00:00:00	2019-04-01 00:00:00	2019-07-01 00:00:00	2017-07-01 00:00:00	2020-10-01 00:00:00	2018-07-01 00:00:00	2018-10-01 00:00:00	2020-12-31 00:00:00	2018-01-01 00:00:00	2015-10-01 00:00:00	2015-07-01 00:00:00	2016-01-01 00:00:00	2016-04-01 00:00:00	2016-07-01 00:00:00	1900-01-01 00:00:00	2018-12-31 00:00:00	2016-10-01 00:00:00	2017-01-01 00:00:00	2017-04-01 00:00:00	1900-01-01 00:00:00	2018-04-01 00:00:00	2019-10-01 00:00:00	2020-04-01 00:00:00	2017-10-01 00:00:00	1900-01-01 00:00:00	2020-07-01 00:00:00	2020-01-01 00:00:00	2022-12-31 00:00:00	2019-01-01 00:00:00	2021-04-01 00:00:00	2021-10-01 00:00:00	2022-04-01 00:00:00	2021-01-01 00:00:00	2021-07-01 00:00:00	2022-01-01 00:00:00	2022-07-01 00:00:00
rpt_end	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2004-09-30 00:00:00	2005-03-31 00:00:00	2004-09-30 00:00:00	2004-12-31 00:00:00	2004-12-31 00:00:00	2005-06-30 00:00:00	2005-12-31 00:00:00	2005-09-30 00:00:00	2006-03-31 00:00:00	2006-06-30 00:00:00	2006-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-03-31 00:00:00	2006-12-31 00:00:00	2007-06-30 00:00:00	2007-09-30 00:00:00	2013-03-31 00:00:00	2013-06-30 00:00:00	2015-06-30 00:00:00	2015-03-31 00:00:00	2014-06-30 00:00:00	2013-06-30 00:00:00	2013-09-30 00:00:00	2013-12-31 00:00:00	2014-09-30 00:00:00	2007-12-31 00:00:00	2007-12-31 00:00:00	2008-06-30 00:00:00	2008-03-31 00:00:00	2008-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-03-31 00:00:00	2008-12-31 00:00:00	2009-06-30 00:00:00	2009-12-31 00:00:00	2009-09-30 00:00:00	2010-03-31 00:00:00	2010-06-30 00:00:00	1900-01-01 00:00:00	2010-06-30 00:00:00	2010-06-23 00:00:00	2010-09-30 00:00:00	1900-01-01 00:00:00	2010-12-31 00:00:00	2010-12-17 00:00:00	2011-03-31 00:00:00	2011-09-30 00:00:00	2011-06-30 00:00:00	2011-12-31 00:00:00	2012-03-31 00:00:00	2012-06-30 00:00:00	1900-01-01 00:00:00	2014-12-31 00:00:00	2015-01-01 00:00:00	1900-01-01 00:00:00	2012-09-30 00:00:00	2013-01-01 00:00:00	2012-12-31 00:00:00	2014-03-31 00:00:00	1900-01-01 00:00:00	2013-03-31 00:00:00	2013-03-01 00:00:00	2019-06-30 00:00:00	2019-09-30 00:00:00	2017-09-30 00:00:00	2020-12-31 00:00:00	2018-09-30 00:00:00	2018-12-31 00:00:00	2020-12-31 00:00:00	2018-03-31 00:00:00	2015-12-31 00:00:00	2015-09-30 00:00:00	2016-03-31 00:00:00	2016-06-30 00:00:00	2016-09-30 00:00:00	1900-01-01 00:00:00	2018-12-31 00:00:00	2016-12-31 00:00:00	2017-03-31 00:00:00	2017-06-30 00:00:00	1900-01-01 00:00:00	2018-06-30 00:00:00	2019-12-31 00:00:00	2020-06-30 00:00:00	2017-12-31 00:00:00	1900-01-01 00:00:00	2020-09-30 00:00:00	2020-03-31 00:00:00	2022-12-31 00:00:00	2019-03-31 00:00:00	2021-06-30 00:00:00	2021-12-31 00:00:00	2022-06-30 00:00:00	2021-03-31 00:00:00	2021-09-30 00:00:00	2022-03-31 00:00:00	2022-09-30 00:00:00
rpt_date	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filing_type	None	None	None	None	22006	22001	None	22001	22006	22001	22001	22001	22001	22001	None	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	None	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	None	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	None	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001

Table: filer_to_filer_type
filer_id	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678
filer_type	4	4	4	4	4	4	4	4	4	4	4
active	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	N
race	0	0	0	None	None	None	None	None	None	None	None
session_id	2005	2003	2007	2011	2013	2009	2019	2015	2021	2017	2023
category	0	0	0	None	None	None	None	None	None	None	None
category_type	0	0	0	None	None	None	None	None	None	None	None
sub_category	0	0	0	None	None	None	None	None	None	None	None
effect_dt	2005-01-01 00:00:00	2004-08-02 00:00:00	2007-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2009-01-01 00:00:00	2019-01-01 00:00:00	2015-01-01 00:00:00	2021-01-01 00:00:00	2017-01-01 00:00:00	2023-01-01 00:00:00
sub_category_type	0	0	0	None	None	None	None	None	None	None	None
election_type	0	0	0	None	None	None	None	None	None	None	None
sub_category_a	None	None	None	None	None	None	None	None	None	None	None
nyq_dt	2004-07-01 00:00:00	None	2004-07-01 00:00:00	None	None	None	None	None	None	None	None
party_cd	0	0	0	None	None	None	None	None	None	None	None
county_cd	0	0	0	None	None	None	None	None	None	None	None
district_cd	0	0	0	None	None	None	None	None	None	None	None

Table: filer_xref
filer_id		1268678
xref_id		1268678
effect_dt		2004-08-25 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678
filer_id	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678
filer_type	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST
status	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE
effect_dt	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00
naml	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH	SMITH
namf	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.	JEREMY L.
namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
city	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	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
st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
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	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
phon	9164443676	9164443676	9164443676	9164443676	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164443676	9164443676	9164443676	9164443676	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164443676	9164443676	9164443676	9164443676	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164443676	9164443676	9164443676	9164443676	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164443676	9164443676	9164443676	9164443676	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164443676	9164443676	9164443676	9164443676	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164443676	9164443676	9164443676	9164443676	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164443676	9164443676	9164443676	9164443676	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164443676	9164443676	9164443676	9164443676	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164443676	9164443676	9164443676	9164443676	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164443676	9164443676	9164443676	9164443676	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302	9164433302
fax	None	None	9164447693	9164447693	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	None	None	9164447693	9164447693	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	None	None	9164447693	9164447693	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	None	None	9164447693	9164447693	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	None	None	9164447693	9164447693	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	None	None	9164447693	9164447693	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	None	None	9164447693	9164447693	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	None	None	9164447693	9164447693	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	None	None	9164447693	9164447693	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	None	None	9164447693	9164447693	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	None	None	9164447693	9164447693	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204	9164438204
email	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]

Table: filers
filer_id		1268678

Table: lobbying_chg_log
filer_id	1268678	1268678	1268678
change_no	0	2	1
session_id	2003	2009	2009
log_dt	2004-08-20 00:00:00	2010-06-22 00:00:00	2010-06-16 00:00:00
filer_type	4	4	4
correction_flg	None	Y	Y
action	ADDED	ADDED	DELETED
attribute_changed	EMPLOYER	EMPLOYER	EMPLOYER
ethics_dt	None	None	None
interests	None	None	None
filer_full_name	SMITH, JEREMY L.	SMITH, JEREMY L.	SMITH, JEREMY L.
filer_city	None	SACRAMENTO	None
filer_st	None	CA	None
filer_zip	None	95814	None
filer_phone	None	9164433302	None
entity_type	2	2	2
entity_name	CALIFORNIA LABOR FEDERATION, AFL-CIO	STATE BUILDING & CONSTRUCTION TRADES COUNCIL OF CALIFORNIA	CALIFORNIA LABOR FEDERATION, AFL-CIO
entity_city	None	None	None
entity_st	None	None	None
entity_zip	None	None	None
entity_phone	None	None	None
entity_id	1146794	None	1146794
responsible_officer	None	None	None
effect_dt	2004-08-02 00:00:00	2010-06-07 00:00:00	2010-05-25 00:00:00

Table: received_filings
filer_id	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678	1268678
filing_file_name	1056126_0.cal	1081063_0.cal	1130826_0.cal	1144309_0.cal	1173345_0.cal	330963.cal	1191629_0.cal	1327500_0.cal	1503355_0.cal	1498361_0.cal	1421118_0.cal	1397819_0.cal	1371039_0.cal	1346666_0.cal	1507478_0.cal	1483280_0.cal	1451776_0.cal	1216668_0.cal	1238356_0.cal	1464562_0.cal	1274131_0.cal	1277653_0.cal	1430227_0.cal	143972.cal	1296938_0.cal	1311525_0.cal	1311525_1.cal	1732766_0.cal	1680514_0.cal	1841168_0.cal	1763177_1.cal	1780206_1.cal	1551608_0.cal	1539531_0.cal	1592022_0.cal	1567768_0.cal	1811068_0.cal	1604838_0.cal	1619065_0.cal	1715521_1.cal	1797152_0.cal	1780206_0.cal	1763177_0.cal	1636120_0.cal	1715521_0.cal	1708436_0.cal	1657551_0.cal	1866946_0.cal	1978401_0.cal	2151768_0.cal	2127494_0.cal	2008626_0.cal	1993821_0.cal	2101729_0.cal	1917179_0.cal	1909939_0.cal	2060957_0.cal	2037389_0.cal	1932408_0.cal	1962793_0.cal	2111800_0.cal	2176486_0.cal	2192258_0.cal	2319193_0.cal	2329003_0.cal	2349385_0.cal	2241164_0.cal	2381478_0.cal	2277111_0.cal	2207225_0.cal	2471473_0.cal	2485228_0.cal	2444247_0.cal	2396137_0.cal	2419389_0.cal	2602963_0.cal	2578261_0.cal	2541129_0.cal	2532009_0.cal	2555269_0.cal	2644744_0.cal	2745004_0.cal	2622155_0.cal	2677309_0.cal	2703074_0.cal
received_date	2004-10-28 00:00:00	2005-01-31 00:00:00	2005-10-26 00:00:00	2006-01-25 00:00:00	2006-05-24 00:00:00	2006-07-31 00:00:00	2006-07-31 00:00:00	2008-04-28 00:00:00	2010-07-26 00:00:00	2010-06-23 00:00:00	2009-04-30 00:00:00	2009-02-02 00:00:00	2008-10-24 00:00:00	2008-07-28 00:00:00	2010-08-02 00:00:00	2010-04-28 00:00:00	2009-10-30 00:00:00	2006-10-31 00:00:00	2007-01-31 00:00:00	2010-02-01 00:00:00	2007-06-18 00:00:00	2007-07-17 00:00:00	2009-07-13 00:00:00	2009-04-30 00:00:00	2007-10-31 00:00:00	2008-01-31 00:00:00	2008-02-07 00:00:00	2013-01-25 00:00:00	2012-07-31 00:00:00	2014-04-24 00:00:00	2013-08-29 00:00:00	2013-08-29 00:00:00	2010-12-17 00:00:00	2010-10-30 00:00:00	2011-05-02 00:00:00	2011-01-27 00:00:00	2014-01-17 00:00:00	2011-07-27 00:00:00	2011-10-24 00:00:00	2013-05-15 00:00:00	2013-10-25 00:00:00	2013-07-29 00:00:00	2013-04-29 00:00:00	2012-01-31 00:00:00	2012-11-30 00:00:00	2012-10-31 00:00:00	2012-04-30 00:00:00	2014-07-25 00:00:00	2015-07-28 00:00:00	2017-04-19 00:00:00	2017-01-30 00:00:00	2016-01-28 00:00:00	2015-10-23 00:00:00	2016-10-31 00:00:00	2014-12-05 00:00:00	2014-10-30 00:00:00	2016-07-29 00:00:00	2016-05-02 00:00:00	2015-01-29 00:00:00	2015-04-27 00:00:00	2016-12-19 00:00:00	2017-07-31 00:00:00	2017-10-30 00:00:00	2018-10-31 00:00:00	2018-12-20 00:00:00	2019-01-31 00:00:00	2018-04-30 00:00:00	2019-04-30 00:00:00	2018-07-31 00:00:00	2018-01-29 00:00:00	2020-04-30 00:00:00	2020-07-31 00:00:00	2020-01-31 00:00:00	2019-07-30 00:00:00	2019-10-31 00:00:00	2021-08-02 00:00:00	2021-04-28 00:00:00	2020-12-30 00:00:00	2020-11-02 00:00:00	2021-02-01 00:00:00	2022-01-31 00:00:00	2022-10-28 00:00:00	2021-10-29 00:00:00	2022-05-02 00:00:00	2022-07-28 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/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/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	/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	/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	1056126	1081063	1130826	1144309	1173345	None	1191629	1327500	1503355	1498361	1421118	1397819	1371039	1346666	1507478	1483280	1451776	1216668	1238356	1464562	1274131	1277653	1430227	None	1296938	1311525	1311525	1732766	1680514	1841168	1763177	1780206	1551608	1539531	1592022	1567768	1811068	1604838	1619065	1715521	1797152	1780206	1763177	1636120	1715521	1708436	1657551	1866946	1978401	2151768	2127494	2008626	1993821	2101729	1917179	1909939	2060957	2037389	1932408	1962793	2111800	2176486	2192258	2319193	2329003	2349385	2241164	2381478	2277111	2207225	2471473	2485228	2444247	2396137	2419389	2602963	2578261	2541129	2532009	2555269	2644744	2745004	2622155	2677309	2703074
form_id	F615	F615	F615	F615	F615	None	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	None	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F604	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615
receive_comment	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 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	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	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