OpenCalAccess

Filer ID: 1354236

Table: cvr_lobby_disclosure
filing_id	1798875	1783283	1763870	1817567	1867918	1843649	1909722	1980615	1993660	1964781	1934706	2060100	2036087	2008389	2099975	2174676	2126744	2156570	2126744	2192717	2210805	2242478	2242478	2275651	2344868	2398015	2319373	2380431	2440216	2419577	2470068	2528258	2550764	2486705	2624802	2599508	2580615	2599508	2599508	2624802	2644940	2677444	2707463	2746658
amend_id	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	2	1	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
form_type	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625
sender_id	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236
filer_id	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236
entity_cd	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM
filer_naml	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC
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
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
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
report_num	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	000	000	000	000	000	001	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	002	001	000	000	000	000
rpt_date	2013-10-23 00:00:00	2013-07-30 00:00:00	2013-04-16 00:00:00	2014-01-28 00:00:00	2014-07-22 00:00:00	2014-04-17 00:00:00	2014-10-10 00:00:00	2015-07-24 00:00:00	2015-10-07 00:00:00	2015-04-21 00:00:00	2015-01-16 00:00:00	2016-07-22 00:00:00	2016-04-26 00:00:00	2016-01-15 00:00:00	2016-10-21 00:00:00	2017-07-13 00:00:00	2017-02-16 00:00:00	2017-04-26 00:00:00	2017-01-16 00:00:00	2017-10-11 00:00:00	2018-01-13 00:00:00	2018-04-17 00:00:00	2018-07-10 00:00:00	2018-07-10 00:00:00	2019-01-10 00:00:00	2019-07-10 00:00:00	2018-10-15 00:00:00	2019-04-11 00:00:00	2020-01-08 00:00:00	2019-10-11 00:00:00	2020-04-14 00:00:00	2020-10-09 00:00:00	2021-01-13 00:00:00	2020-07-14 00:00:00	2021-10-13 00:00:00	2021-07-12 00:00:00	2021-04-13 00:00:00	2021-10-29 00:00:00	2022-01-31 00:00:00	2022-01-31 00:00:00	2022-01-11 00:00:00	2022-04-20 00:00:00	2022-07-31 00:00:00	2022-10-16 00:00:00
from_date	2013-07-01 00:00:00	2013-04-01 00:00:00	2013-01-01 00:00:00	2013-10-01 00:00:00	2014-04-01 00:00:00	2014-01-01 00:00:00	2014-07-01 00:00:00	2015-04-01 00:00:00	2015-07-01 00:00:00	2015-01-01 00:00:00	2014-10-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-04-01 00:00:00	2016-10-01 00:00:00	2017-01-01 00:00:00	2016-10-01 00:00:00	2017-07-01 00:00:00	2017-10-01 00:00:00	2018-01-01 00:00:00	2018-01-01 00:00:00	2018-04-01 00:00:00	2018-10-01 00:00:00	2019-04-01 00:00:00	2018-07-01 00:00:00	2019-01-01 00:00:00	2019-10-01 00:00:00	2019-07-01 00:00:00	2020-01-01 00:00:00	2020-07-01 00:00:00	2020-10-01 00:00:00	2020-04-01 00:00:00	2021-07-01 00:00:00	2021-04-01 00:00:00	2021-01-01 00:00:00	2021-04-01 00:00:00	2021-04-01 00:00:00	2021-07-01 00:00:00	2021-10-01 00:00:00	2022-01-01 00:00:00	2022-04-01 00:00:00	2022-07-01 00:00:00
thru_date	2013-09-30 00:00:00	2013-06-30 00:00:00	2013-03-31 00:00:00	2013-12-31 00:00:00	2014-06-30 00:00:00	2014-03-31 00:00:00	2014-09-30 00:00:00	2015-06-30 00:00:00	2015-09-30 00:00:00	2015-03-31 00:00:00	2014-12-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-06-30 00:00:00	2016-12-31 00:00:00	2017-03-31 00:00:00	2016-12-31 00:00:00	2017-09-30 00:00:00	2017-12-31 00:00:00	2018-03-31 00:00:00	2018-03-31 00:00:00	2018-06-30 00:00:00	2018-12-31 00:00:00	2019-06-30 00:00:00	2018-09-30 00:00:00	2019-03-31 00:00:00	2019-12-31 00:00:00	2019-09-30 00:00:00	2020-03-31 00:00:00	2020-09-30 00:00:00	2020-12-31 00:00:00	2020-06-30 00:00:00	2021-09-30 00:00:00	2021-06-30 00:00:00	2021-03-31 00:00:00	2021-06-30 00:00:00	2021-06-30 00:00:00	2021-09-30 00:00:00	2021-12-31 00:00:00	2022-03-31 00:00:00	2022-06-30 00:00:00	2022-09-30 00:00:00
cum_beg_dt	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2017-01-01 00:00:00	2015-01-01 00:00:00	2017-01-01 00:00:00	2015-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00
firm_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	1354236	1354236	1354236
firm_name	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC
firm_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
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
firm_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
firm_phon	(916) 479-7400	(916) 441-1011	(916) 441-1011	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400
mail_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
mail_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
mail_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
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
sig_date	2013-10-23 00:00:00	2013-07-30 00:00:00	2013-04-16 00:00:00	2014-01-28 00:00:00	2014-07-22 00:00:00	2014-04-17 00:00:00	2014-10-10 00:00:00	2015-07-24 00:00:00	2015-10-07 00:00:00	2015-04-21 00:00:00	2015-01-16 00:00:00	2016-07-22 00:00:00	2016-04-26 00:00:00	2016-01-15 00:00:00	2016-10-21 00:00:00	2017-07-13 00:00:00	2017-02-16 00:00:00	2017-04-26 00:00:00	2017-01-16 00:00:00	2017-10-11 00:00:00	2018-01-13 00:00:00	2018-04-17 00:00:00	2018-07-10 00:00:00	2018-07-10 00:00:00	2019-01-10 00:00:00	2019-07-10 00:00:00	2018-10-15 00:00:00	2019-04-11 00:00:00	2020-01-08 00:00:00	2019-10-11 00:00:00	2020-04-14 00:00:00	2020-10-09 00:00:00	2021-01-13 00:00:00	2020-07-14 00:00:00	2021-10-13 00:00:00	2021-07-12 00:00:00	2021-04-13 00:00:00	2021-10-29 00:00:00	2022-01-31 00:00:00	2022-01-31 00:00:00	2022-01-11 00:00:00	2022-04-20 00:00:00	2022-07-31 00:00:00	2022-10-16 00:00:00
sig_loc	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	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	ALCALA	ALCALA	ALCALA	ALCALA	KIRKLAND	LEWIS	MAIN	LEWIS	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND
sig_namf	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	AMANDA	AMANDA	AMANDA	AMANDA	MONICA	HEIDI	FRED	HEIDI	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA
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
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
prn_naml	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	ALCALA	ALCALA	ALCALA	ALCALA	KIRKLAND	LEWIS	MAIN	LEWIS	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND
prn_namf	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	AMANDA	AMANDA	AMANDA	AMANDA	MONICA	HEIDI	FRED	HEIDI	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA
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
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
sig_title	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	MANAGING PARTNER 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT
nopart1_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
nopart2_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
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
part1_2_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
ctrib_n_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
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
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
lobby_n_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
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
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
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
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
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
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
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

Table: cvr_registration
filing_id	1720603	1720634	1720640	1720640	1720640	1720640	1758996	1759000	1720640	1759001	1720640	1720640	1720640	1720640	1720640	1720640	1790342	1720640	1720640	1720640	1720640	1720640	1720640	1918096	1928329	1923108	1937107	1937172	1923118	1923118	1938020	1923118	1923118	1953674	1953675	1923118	1923118	2013505	1923118	2015707	2015707	2015707	1923118	1923118	2039150	2039150	2039150	2013505	2013505	2084415	1923118	2109452	2109451	2109451	2109451	1953675	2115323	2115333	2115315	2115263	2115263	2115263	2115315	2115333	2115323	2115263	2115263	2115263	2115263	2115263	2115263	2115263	2334294	2334330	2334275	2363612	2363615	2363618	2334275	2334327	2334275	2334275	2334275	2334275	2537888	2537894	2543140	2542142	2543140	2543140	2543140	2543140	2584410	2537894	2560023	2563887	2560024	2543140	2543140	2559753	2543140	2543140	2560024	2543140	2543140	2543140
amend_id	0	0	0	4	10	7	0	0	6	0	3	1	2	5	8	11	0	9	13	16	14	12	15	0	0	0	0	0	1	0	0	3	2	0	0	5	4	0	6	0	1	2	9	8	0	1	2	2	1	0	7	0	0	1	2	1	0	0	0	0	2	1	1	1	1	4	3	7	6	9	5	8	0	0	1	0	0	0	0	0	3	2	4	5	0	0	0	0	4	6	3	2	0	1	0	0	0	5	1	0	7	11	1	9	10	8
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	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F602	F602	F601	F601	F601	F601	F602	F602	F601	F602	F601	F601	F601	F601	F601	F601	F602	F601	F601	F601	F601	F601	F601	F602	F602	F602	F602	F602	F601	F601	F602	F601	F601	F602	F602	F601	F601	F602	F601	F602	F602	F602	F601	F601	F602	F602	F602	F602	F602	F602	F601	F602	F602	F602	F602	F602	F602	F602	F602	F601	F601	F601	F602	F602	F602	F601	F601	F601	F601	F601	F601	F601	F602	F602	F601	F602	F602	F602	F601	F602	F601	F601	F601	F601	F602	F602	F601	F602	F601	F601	F601	F601	F602	F602	F602	F602	F602	F601	F601	F602	F601	F601	F602	F601	F601	F601
sender_id	1241801	1223222	1354236	1354236	1354236	1354236	1356868	1356868	1354236	1356868	1354236	1354236	1354236	1354236	1354236	1354236	F00515	1354236	1354236	1354236	1354236	1354236	1354236	1241801	1223222	F23923	1223222	F23923	1354236	1354236	1241801	1354236	1354236	F23923	1241801	1354236	1354236	F23923	1354236	F23923	1223222	1241801	1354236	1354236	F23923	1223222	1241801	1241801	1223222	1384776	1354236	F23923	F23923	1223222	1241801	1223222	F23923	1241801	1223222	1354236	1354236	1354236	1223222	1241801	1356868	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1241801	F23923	1354236	1241801	1398525	1223222	1354236	1223222	1354236	1354236	1354236	1354236	1398525	1241801	1354236	1354236	1354236	1354236	1354236	1354236	1223222	1241801	1435932	1435932	1435932	1354236	1354236	1435932	1354236	1354236	1435932	1354236	1354236	1354236
filer_id	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236
entity_cd	LEM	LEM	FRM	FRM	FRM	FRM	LEM	LEM	FRM	LEM	FRM	FRM	FRM	FRM	FRM	FRM	LEM	FRM	FRM	FRM	FRM	FRM	FRM	LEM	LEM	LEM	LEM	LEM	FRM	FRM	LEM	FRM	FRM	LEM	LEM	FRM	FRM	LEM	FRM	LEM	LEM	LEM	FRM	FRM	LEM	LEM	LEM	LEM	LEM	LEM	FRM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	FRM	FRM	FRM	LEM	LEM	LEM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	LEM	LEM	FRM	LEM	LEM	LEM	FRM	LEM	FRM	FRM	FRM	FRM	LEM	LEM	FRM	LEM	FRM	FRM	FRM	FRM	LEM	LEM	LEM	LEM	LEM	FRM	FRM	LEM	FRM	FRM	LEM	FRM	FRM	FRM
filer_naml	ClearAdvocacy, LLC	ClearAdvocacy, LLC	ClearAdvocacy, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY	CLEAR ADVOCACY	CLEAR ADVOCACY	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY	CLEAR ADVOCACY	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC
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	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	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	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	004	010	007	000	000	006	000	003	001	002	005	008	011	000	009	013	016	014	012	015	000	000	000	000	000	001	000	000	003	002	000	000	005	004	000	006	000	001	002	009	008	000	001	002	002	001	000	007	000	000	001	002	001	000	000	000	000	002	001	001	001	001	004	003	007	006	009	005	008	000	000	001	000	000	000	000	000	003	002	004	005	000	000	000	000	004	006	003	002	000	001	000	000	000	005	001	000	007	011	001	009	010	008
rpt_date	2012-12-13 00:00:00	2012-12-14 00:00:00	2012-12-14 00:00:00	2013-03-04 00:00:00	2013-11-20 00:00:00	2013-04-16 00:00:00	2013-04-16 00:00:00	2013-04-16 00:00:00	2013-03-27 00:00:00	2013-04-16 00:00:00	2013-02-11 00:00:00	2013-01-10 00:00:00	2013-01-17 00:00:00	2013-03-18 00:00:00	2013-08-16 00:00:00	2014-01-06 00:00:00	2013-09-03 00:00:00	2013-08-16 00:00:00	2014-05-22 00:00:00	2014-08-26 00:00:00	2014-06-25 00:00:00	2014-04-30 00:00:00	2014-08-05 00:00:00	2014-11-17 00:00:00	2014-11-17 00:00:00	2014-11-17 00:00:00	2015-01-22 00:00:00	2015-01-22 00:00:00	2015-01-22 00:00:00	2014-09-02 00:00:00	2015-01-22 00:00:00	2015-04-28 00:00:00	2015-03-02 00:00:00	2015-03-02 00:00:00	2015-03-02 00:00:00	2016-01-28 00:00:00	2016-01-21 00:00:00	2016-01-25 00:00:00	2016-02-09 00:00:00	2016-02-09 00:00:00	2016-02-09 00:00:00	2016-02-09 00:00:00	2016-05-03 00:00:00	2016-05-02 00:00:00	2016-05-02 00:00:00	2016-05-01 00:00:00	2016-05-01 00:00:00	2016-01-25 00:00:00	2016-01-25 00:00:00	2016-08-30 00:00:00	2016-03-08 00:00:00	2015-03-02 00:00:00	2016-05-02 00:00:00	2016-05-02 00:00:00	2016-05-02 00:00:00	2015-03-02 00:00:00	2016-12-29 00:00:00	2016-12-29 00:00:00	2016-12-29 00:00:00	2016-11-22 00:00:00	2017-04-11 00:00:00	2017-03-06 00:00:00	2017-03-06 00:00:00	2017-03-06 00:00:00	2017-03-06 00:00:00	2018-01-17 00:00:00	2017-12-19 00:00:00	2018-08-01 00:00:00	2018-03-19 00:00:00	2018-09-04 00:00:00	2018-02-27 00:00:00	2018-08-10 00:00:00	2018-11-08 00:00:00	2018-11-08 00:00:00	2019-01-22 00:00:00	2019-01-22 00:00:00	2019-01-22 00:00:00	2019-01-22 00:00:00	2018-11-08 00:00:00	2018-11-08 00:00:00	2020-01-13 00:00:00	2019-12-10 00:00:00	2020-04-20 00:00:00	2020-10-26 00:00:00	2020-12-09 00:00:00	2020-12-09 00:00:00	2020-12-09 00:00:00	2020-12-09 00:00:00	2021-02-22 00:00:00	2021-03-22 00:00:00	2021-02-03 00:00:00	2021-02-02 00:00:00	2021-04-22 00:00:00	2021-04-22 00:00:00	2021-02-03 00:00:00	2021-02-22 00:00:00	2021-02-03 00:00:00	2021-03-22 00:00:00	2021-01-20 00:00:00	2021-01-19 00:00:00	2021-05-11 00:00:00	2022-05-09 00:00:00	2021-09-27 00:00:00	2022-02-08 00:00:00	2022-05-03 00:00:00	2021-07-26 00:00:00
ls_beg_yr	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2015	2015	2015	2015	2015	2015	2013	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2019	2019	2019	2019	2019	2019	2019	2019	2019	2019	2019	2019	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021
ls_end_yr	2014	2014	2014	2014	2014	2014	2014	2014	2014	2014	2014	2014	2014	2014	2014	2014	2014	2014	2014	2014	2014	2014	2014	2016	2016	2016	2016	2016	2016	2014	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2016	2018	2018	2018	2018	2018	2018	2018	2018	2018	2018	2018	2018	2018	2018	2018	2018	2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2020	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022
qual_date	None	None	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	None	None	2013-01-01 00:00:00	None	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	None	2013-01-01 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
eff_date	2013-01-01 00:00:00	2013-01-01 00:00:00	None	None	None	None	2013-01-01 00:00:00	2013-01-01 00:00:00	None	2013-03-01 00:00:00	None	None	None	None	None	None	2013-09-03 00:00:00	None	None	None	None	None	None	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-22 00:00:00	2015-01-22 00:00:00	None	None	2015-01-22 00:00:00	None	None	2015-03-02 00:00:00	2015-03-02 00:00:00	None	None	None	None	None	2016-01-25 00:00:00	2016-01-25 00:00:00	None	None	2016-05-01 00:00:00	2016-05-01 00:00:00	2016-05-01 00:00:00	2016-01-01 00:00:00	2016-01-01 00:00:00	2016-08-29 00:00:00	None	2015-03-02 00:00:00	2016-04-18 00:00:00	2016-04-18 00:00:00	2016-04-18 00:00:00	2015-03-02 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	None	None	None	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	None	None	None	None	None	None	None	2019-01-01 00:00:00	2019-01-01 00:00:00	None	2019-01-22 00:00:00	2019-01-22 00:00:00	2019-01-22 00:00:00	None	2019-01-01 00:00:00	None	None	None	None	2021-01-01 00:00:00	2021-01-01 00:00:00	None	2021-01-01 00:00:00	None	None	None	None	2021-02-01 00:00:00	2021-02-01 00:00:00	2021-02-01 00:00:00	2021-03-01 00:00:00	2021-02-01 00:00:00	None	None	2021-01-01 00:00:00	None	None	2021-07-15 00:00:00	None	None	None
bus_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
bus_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
bus_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
bus_phon	(916) 441-1011	(916) 441-1011	(916) 441-1011	(916) 441-1011	(916) 479-7400	(916) 441-1011	(916) 441-1011	(916) 441-1011	(916) 441-1011	(916) 441-1011	(916) 441-1011	(916) 441-1011	(916) 441-1011	(916) 441-1011	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 474-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 474-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 474-7400	(916) 474-7400	(916) 474-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 474-7400	(916) 474-7400	(916) 479-7400	(916) 474-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400	(916) 474-7400	None	(916) 474-7400	(916) 474-7400	(916) 474-7400	(916) 479-7400	(916) 479-7400	(916) 474-7400	(916) 479-7400	(916) 479-7400	(916) 474-7400	(916) 479-7400	(916) 479-7400	(916) 479-7400
bus_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]
mail_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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	None	None	None	None	None	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	2012-12-13 00:00:00	2012-12-14 00:00:00	2012-12-14 00:00:00	2013-03-04 00:00:00	2013-11-20 00:00:00	2013-04-16 00:00:00	2013-04-16 00:00:00	2013-04-16 00:00:00	2013-03-27 00:00:00	2013-04-16 00:00:00	2013-02-11 00:00:00	2013-01-10 00:00:00	2013-01-17 00:00:00	2013-03-18 00:00:00	2013-08-16 00:00:00	2014-01-06 00:00:00	2013-09-03 00:00:00	2013-08-16 00:00:00	2014-05-22 00:00:00	2014-08-26 00:00:00	2014-06-25 00:00:00	2014-04-30 00:00:00	2014-08-13 00:00:00	2014-11-17 00:00:00	2014-11-17 00:00:00	2014-11-17 00:00:00	2015-01-22 00:00:00	2015-01-22 00:00:00	2015-01-22 00:00:00	2014-09-02 00:00:00	2015-01-22 00:00:00	2015-04-28 00:00:00	2015-03-02 00:00:00	2015-03-02 00:00:00	2015-03-02 00:00:00	2016-01-28 00:00:00	2016-01-21 00:00:00	2016-01-25 00:00:00	2016-02-09 00:00:00	2016-02-09 00:00:00	2016-02-09 00:00:00	2016-02-09 00:00:00	2016-05-03 00:00:00	2016-05-02 00:00:00	2016-05-02 00:00:00	2016-05-01 00:00:00	2016-05-01 00:00:00	2016-01-25 00:00:00	2016-01-25 00:00:00	2016-08-29 00:00:00	2016-03-08 00:00:00	2015-03-02 00:00:00	2016-05-02 00:00:00	2016-05-02 00:00:00	2016-05-02 00:00:00	2015-03-02 00:00:00	2016-12-29 00:00:00	2016-12-29 00:00:00	2016-12-29 00:00:00	2016-11-22 00:00:00	2017-04-13 00:00:00	2017-03-06 00:00:00	2017-03-06 00:00:00	2017-03-06 00:00:00	2017-03-06 00:00:00	2018-01-17 00:00:00	2017-12-19 00:00:00	2018-08-01 00:00:00	2018-03-19 00:00:00	2018-09-04 00:00:00	2018-02-27 00:00:00	2018-08-10 00:00:00	2018-11-08 00:00:00	2018-11-08 00:00:00	2019-01-22 00:00:00	2019-01-22 00:00:00	2019-01-22 00:00:00	2019-01-22 00:00:00	2018-11-08 00:00:00	2018-11-08 00:00:00	2020-01-02 00:00:00	2019-12-10 00:00:00	2020-04-20 00:00:00	2020-10-26 00:00:00	2020-12-09 00:00:00	2020-12-09 00:00:00	2020-12-09 00:00:00	2020-12-09 00:00:00	2021-02-22 00:00:00	2021-03-22 00:00:00	2021-02-03 00:00:00	2021-02-02 00:00:00	2021-04-22 00:00:00	2021-04-22 00:00:00	2021-02-03 00:00:00	2021-02-22 00:00:00	2021-02-03 00:00:00	2021-03-22 00:00:00	2021-01-20 00:00:00	2021-01-19 00:00:00	2021-05-11 00:00:00	2022-05-09 00:00:00	2021-07-26 00:00:00	2022-02-08 00:00:00	2022-05-03 00:00:00	2021-07-26 00:00:00
sig_loc	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	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	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	HAMMONDS	ALCALA	ALCALA	ALCALA	HAMMONDS	LEWIS	LEWIS	LEWIS	LEWIS	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND
sig_namf	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	KELLY	AMANDA	AMANDA	AMANDA	KELLY	HEIDI	HEIDI	HEIDI	HEIDI	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA
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	None	None	None	None	None	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	None	None	None	None	None	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	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	HAMMONDS	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	ALCALA	HAMMONDS	ALCALA	ALCALA	ALCALA	HAMMONDS	LEWIS	LEWIS	LEWIS	LEWIS	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND	KIRKLAND
prn_namf	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	KELLY	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	AMANDA	KELLY	AMANDA	AMANDA	AMANDA	KELLY	HEIDI	HEIDI	HEIDI	HEIDI	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA	MONICA
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	None	None	None	None	None	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	None	None	None	None	None	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	ADMINISTRATIVE ASSISTANT	ADMINISTRATIVE ASSISTANT	ADMINISTRATIVE ASSISTANT	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT	ADMINISTRATIVE ASSISTANT	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ADMINISTRATOR	EXECUTIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	ADMINISTRATIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ADMINISTRATOR	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ADMINISTRATOR	ADMINISTRATIVE ASSISTANT (465400MM)	ADMINISTRATIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ADMINISTRATOR	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ADMINISTRATOR	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ADMINISTRATOR	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ADMINISTRATOR	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565KAU	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565SSB	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT 4565	EXECUTIVE ASSISTANT	EXECUTIVE ASSISTANT 4565
stmt_firm	None	None	ClearAdvocacy, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	None	None	CLEAR ADVOCACY, LLC	None	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	None	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	None	None	None	None	None	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	None	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	None	None	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	None	CLEAR ADVOCACY, LLC	None	None	None	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	None	None	None	None	None	None	CLEAR ADVOCACY, LLC	None	None	None	None	None	None	None	None	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	None	None	None	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	None	None	CLEAR ADVOCACY, LLC	None	None	None	CLEAR ADVOCACY, LLC	None	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	None	None	CLEAR ADVOCACY, LLC	None	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	None	None	None	None	None	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	None	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	None	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC
ind_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
trade_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
oth_cb	X	X	None	None	None	None	X	X	None	X	None	None	None	None	None	None	X	None	None	None	None	None	None	X	X	X	X	X	None	None	X	None	None	X	X	None	None	X	None	X	X	X	None	None	X	X	X	X	X	X	None	X	X	X	X	X	X	X	X	None	None	None	X	X	X	None	None	None	None	None	None	None	X	X	None	X	X	X	None	X	None	None	None	None	X	X	None	X	None	None	None	None	X	X	X	X	X	None	None	X	None	None	X	None	None	None
a_b_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
a_b_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
a_b_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
a_b_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
descrip_1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
descrip_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
c_less50	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
c_more50	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ind_class	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ind_descr	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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_class	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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_descr	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
auth_name	JK PEDROTTI, INC. GOVERNMENT RELATIONS	KELLISON COMPANY, INC.	None	None	None	None	MAIN ADVOCACY	MAIN ADVOCACY	None	MAIN ADVOCACY	None	None	None	None	None	None	FRED J. HIESTAND, APC	None	None	None	None	None	None	JK PEDROTTI, INC. GOVERNMENT RELATIONS	KELLISON COMPANY, INC.	MAIN ADVOCACY LLC	KELLISON COMPANY, INC.	MAIN ADVOCACY LLC	None	None	JK PEDROTTI, INC. GOVERNMENT RELATIONS	None	None	MAIN ADVOCACY LLC	JK PEDROTTI, INC. GOVERNMENT RELATIONS	None	None	MAIN ADVOCACY LLC	None	MAIN ADVOCACY LLC	KELLISON COMPANY, INC.	JK PEDROTTI, INC. GOVERNMENT RELATIONS	None	None	MAIN ADVOCACY LLC	KELLISON COMPANY, INC.	JK PEDROTTI, INC. GOVERNMENT RELATIONS	JK PEDROTTI, INC. GOVERNMENT RELATIONS	KELLISON COMPANY, INC.	SACRAMENTO ADVISORS, LLC	None	MAIN ADVOCACY LLC	MAIN ADVOCACY LLC	KELLISON COMPANY, INC.	JK PEDROTTI, INC. GOVERNMENT RELATIONS	KELLISON COMPANY, INC.	MAIN ADVOCACY LLC	JK PEDROTTI, INC. GOVERNMENT RELATIONS	KELLISON COMPANY, INC.	None	None	None	KELLISON COMPANY, INC.	JK PEDROTTI, INC. GOVERNMENT RELATIONS	MAIN ADVOCACY LLC	None	None	None	None	None	None	None	JK PEDROTTI, INC. GOVERNMENT RELATIONS	MAIN ADVOCACY LLC	None	JK PEDROTTI, INC. GOVERNMENT RELATIONS	MAIN ADVOCACY LLC	KELLISON COMPANY, INC.	None	KELLISON COMPANY, INC.	None	None	None	None	MAIN ADVOCACY LLC	JK PEDROTTI, INC. GOVERNMENT RELATIONS	None	KELLISON COMPANY, INC.	None	None	None	None	KELLISON COMPANY	JK PEDROTTI, INC.	CE STRATEGIES, LLC	CE STRATEGIES, LLC	CE STRATEGIES, LLC	None	None	CE STRATEGIES, LLC	None	None	CE STRATEGIES, LLC	None	None	None
auth_city	SACRAMENTO	SACRAMENTO	None	None	None	None	SACRAMENTO	SACRAMENTO	None	SACRAMENTO	None	None	None	None	None	None	SACRAMENTO	None	None	None	None	None	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	None	SACRAMENTO	None	None	SACRAMENTO	SACRAMENTO	None	None	SACRAMENTO	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	None	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	None	None	None	None	None	None	SACRAMENTO	SACRAMENTO	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	SACRAMENTO	None	None	None	None	SACRAMENTO	SACRAMENTO	None	SACRAMENTO	None	None	None	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	None	SACRAMENTO	None	None	SACRAMENTO	None	None	None
auth_st	CA	CA	None	None	None	None	CA	CA	None	CA	None	None	None	None	None	None	CA	None	None	None	None	None	None	CA	CA	CA	CA	CA	None	None	CA	None	None	CA	CA	None	None	CA	None	CA	CA	CA	None	None	CA	CA	CA	CA	CA	CA	None	CA	CA	CA	CA	CA	CA	CA	CA	None	None	None	CA	CA	CA	None	None	None	None	None	None	None	CA	CA	None	CA	CA	CA	None	CA	None	None	None	None	CA	CA	None	CA	None	None	None	None	CA	CA	CA	CA	CA	None	None	CA	None	None	CA	None	None	None
auth_zip4	95814	95814	None	None	None	None	95814	95814	None	95814	None	None	None	None	None	None	95817	None	None	None	None	None	None	95814	95814	95814	95814	95814	None	None	95814	None	None	95814	95814	None	None	95814	None	95814	95814	95814	None	None	95814	95814	95814	95814	95814	95814	None	95814	95814	95814	95814	95814	95814	95814	95814	None	None	None	95814	95814	95814	None	None	None	None	None	None	None	95814	95814	None	95814	95814	95814	None	95814	None	None	None	None	95814	95814	None	95814	None	None	None	None	95814	95814	95814	95814	95814	None	None	95814	None	None	95814	None	None	None
lobby_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
influen_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
firm_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
newcert_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rencert_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
complet_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	None	None	None	None	None	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_reg_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lby_604_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
st_leg_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
st_agency	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
l_firm_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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: filer_address
filer_id	1354236	1354236	1354236	1354236	1354236	1354236	1354236
adrid	2504352	2412352	2545057	2282378	2531826	2338537	2465024
effect_dt	2021-01-01 00:00:00	2017-01-01 00:00:00	2023-01-01 00:00:00	2013-01-01 00:00:00	2021-02-07 00:00:00	2015-01-01 00:00:00	2019-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051
session_id	2021	2017	2023	2013	2021	2015	2019

Table: filer_filings
filer_id	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236
filing_id	1760043	1760057	1720640	1789814	1720640	1957594	1980615	1962012	1962016	1962036	1962038	1923118	1971771	1953780	1965638	1971047	1964781	1868823	1720640	1860754	1867918	1798875	1792202	1806308	1783283	1720640	1720640	1790342	1791804	1720640	1959115	1938020	1923118	1959122	1937172	1937107	1946551	1923118	1954074	1953674	1953675	1909722	1720640	1812849	1817567	1818045	1928329	1934706	1918096	1923108	1923118	1720603	1720634	1720640	1720640	1720640	1882494	1884498	1884507	1884513	1884467	1742628	1723614	1720640	1720640	1734902	1843649	1720640	1849860	1764397	1766409	1720640	1720640	1720640	1751952	1751967	1759989	1720640	1758996	1759000	1759001	1763870	1765861	2115263	2495487	2495552	2334275	2584410	2426335	2242478	2334294	2564948	2354273	2354877	2223042	2334327	2334275	2115263	2440216	2115263	2115263	2115263	2015981	2016492	1923118	2016277	2016279	1923118	2015707	2015707	2015707	2008389	1923118	2025374	2016205	1993660	2018776	2018565	2018881	2018885	2045921	2013505	2041248	2036087	2041544	2042008	1923118	2013505	2053147	2053636	2049787	2049799	2053640	1923118	2039150	2039150	2039150	2013505	1923118	2060100	2075714	2073562	2084415	2073329	2075705	2075715	2099975	2126744	2109451	2109451	2109451	1953675	2115263	2109452	2148471	2148477	2115263	2115315	2156570	2139173	2115333	2115323	2132215	2126744	2115315	2115323	2115333	2142120	2141393	2174676	2158773	2157038	2158627	2158763	2157010	2115263	2158771	2161558	2242478	2275651	2115263	2543140	2115263	2334275	2419577	2344868	2398015	2293374	2534563	2334275	2537894	2192717	2542142	2223534	2537894	2203570	2528258	2543140	2580615	2372404	2198958	2430353	2430376	2543140	2563887	2334275	2363612	2363615	2363618	2210805	2351958	2334330	2470068	2283840	2319373	2537888	2280375	2380431	2543140	2560023	2584510	2334275	2559753	2543140	2604631	2605313	2560024	2605428	2543140	2631134	2597589	2606394	2704275	2704276	2486705	2560024	2605786	2655956	2612454	2599508	2599508	2550764	2543140	2694806	2543140	2624802	2543140	2624802	2599508	2707463	2644940	2653802	2652866	2543140	2543140	2624365	2688722	2613676	2613682	2543140	2571819	2677444	2626758	2626772	2746658
period_id	None	None	213	None	215	None	222	None	None	None	None	222	None	None	None	None	221	None	218	None	218	215	None	None	214	216	217	215	None	215	None	221	221	None	221	221	None	221	None	221	221	219	219	None	216	None	220	220	220	220	219	212	212	212	219	218	None	None	None	None	None	None	None	213	213	None	217	218	None	None	None	213	213	213	None	None	None	214	214	214	214	213	None	232	None	None	242	246	None	233	236	None	None	None	None	236	241	233	240	233	233	235	None	None	225	None	None	225	225	225	225	224	225	None	None	223	None	None	None	None	None	225	None	225	None	None	225	225	None	None	None	None	None	226	226	226	226	225	226	226	None	None	227	None	None	None	227	228	226	226	226	221	228	221	None	None	229	229	229	None	229	229	None	228	228	228	228	None	None	230	None	None	None	None	None	230	None	None	233	234	235	244	235	236	239	236	238	None	None	244	244	231	244	None	246	None	243	245	245	None	None	None	None	245	245	237	237	237	237	232	None	236	241	None	235	244	None	237	245	245	None	240	245	245	None	None	247	None	250	None	None	None	None	None	242	245	None	None	None	246	246	244	245	None	246	247	249	247	246	250	248	None	None	245	247	None	None	None	None	250	None	249	None	None	251
form_id	F605	F605	F601	F605	F601	F602	F625	F602	F602	F602	F602	F601	F602	F602	F602	F605	F625	F605	F601	F605	F625	F625	F605	F605	F625	F601	F601	F602	F602	F601	F605	F602	F601	F605	F602	F602	F602	F601	F601	F602	F602	F625	F601	F605	F625	F605	F602	F625	F602	F602	F601	F602	F602	F601	F601	F601	F605	F602	F602	F602	F605	F602	F602	F601	F601	F601	F625	F601	F605	F605	F602	F601	F601	F601	F605	F605	F605	F601	F602	F602	F602	F625	F602	F601	F605	F602	F601	F602	F605	F625	F602	F602	F602	F602	F605	F602	F601	F601	F625	F601	F601	F601	F605	F605	F601	F602	F602	F601	F602	F602	F602	F625	F601	F605	F602	F625	F602	F605	F602	F602	F602	F602	F605	F625	F602	F602	F601	F602	F888	F602	F602	F605	F602	F601	F602	F602	F602	F602	F601	F625	F602	F602	F602	F605	F602	F602	F625	F625	F602	F602	F602	F602	F601	F602	F602	F602	F601	F602	F625	F602	F602	F602	F602	F625	F602	F602	F602	F602	F601	F625	F602	F602	F602	F605	F602	F601	F605	F605	F625	F625	F601	F601	F601	F601	F625	F625	F625	F605	F605	F601	F602	F625	F602	F605	F602	F605	F625	F601	F625	F602	F605	F605	F602	F601	F602	F601	F602	F602	F602	F625	F602	F602	F625	F605	F625	F602	F605	F625	F601	F602	F601	F601	F602	F601	F605	F605	F602	F605	F601	F602	F605	F605	F602	F602	F625	F602	F605	F602	F602	F625	F625	F625	F601	F605	F601	F625	F601	F625	F625	F625	F625	F605	F605	F601	F601	F605	F605	F602	F602	F601	F602	F625	F605	F602	F625
filing_sequence	0	0	6	0	8	0	0	0	0	0	0	3	0	0	0	0	0	0	13	0	0	0	0	0	0	10	11	0	0	9	0	0	1	0	0	0	0	2	0	0	0	0	16	0	0	0	0	0	0	0	0	0	0	0	15	14	0	0	0	0	0	0	0	1	2	0	0	12	0	0	0	5	3	4	0	0	0	7	0	0	0	0	0	3	0	0	4	0	0	0	0	0	0	0	0	0	3	6	0	4	5	8	0	0	5	0	0	6	0	1	2	0	7	0	0	0	0	0	0	0	0	1	0	0	0	0	4	0	0	0	0	0	0	8	0	1	2	2	9	0	0	0	0	0	0	0	0	0	0	1	2	1	0	0	0	0	1	1	0	0	1	1	0	1	0	0	0	0	0	0	0	0	0	0	0	2	0	0	1	0	7	0	9	0	0	0	0	0	0	5	0	0	0	0	1	0	0	1	0	0	0	0	0	3	0	1	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	2	0	6	0	0	1	0	11	0	0	0	0	0	0	0	0	0	0	1	2	0	5	0	7	0	9	1	0	0	0	0	0	4	8	0	0	0	0	10	0	0	0	0	0
filing_date	2013-03-08 00:00:00	2013-03-28 00:00:00	2013-03-27 00:00:00	2013-08-30 00:00:00	2013-08-30 00:00:00	2015-02-02 00:00:00	2015-07-30 00:00:00	2015-02-03 00:00:00	2015-03-17 00:00:00	2015-03-17 00:00:00	2015-02-02 00:00:00	2015-05-28 00:00:00	2015-05-28 00:00:00	2014-12-15 00:00:00	2015-03-17 00:00:00	2015-05-28 00:00:00	2015-04-30 00:00:00	2014-07-08 00:00:00	2014-05-27 00:00:00	2014-05-23 00:00:00	2014-07-28 00:00:00	2013-10-29 00:00:00	2013-09-24 00:00:00	2013-11-26 00:00:00	2013-07-31 00:00:00	2013-11-22 00:00:00	2014-01-07 00:00:00	2013-09-06 00:00:00	2013-09-06 00:00:00	2013-09-24 00:00:00	2015-02-02 00:00:00	2015-02-03 00:00:00	2015-02-02 00:00:00	2015-03-17 00:00:00	2015-02-02 00:00:00	2015-02-02 00:00:00	2014-12-18 00:00:00	2015-03-17 00:00:00	2015-01-08 00:00:00	2015-03-17 00:00:00	2015-03-17 00:00:00	2014-10-30 00:00:00	2014-09-03 00:00:00	2013-03-19 00:00:00	2014-01-31 00:00:00	2014-01-08 00:00:00	2015-01-22 00:00:00	2015-01-30 00:00:00	2014-12-12 00:00:00	2015-01-06 00:00:00	2015-01-06 00:00:00	2012-12-27 00:00:00	2012-12-27 00:00:00	2012-12-27 00:00:00	2014-08-19 00:00:00	2014-08-05 00:00:00	2014-08-26 00:00:00	2014-08-19 00:00:00	2014-08-19 00:00:00	2014-08-19 00:00:00	2014-08-19 00:00:00	2012-12-27 00:00:00	2012-12-27 00:00:00	2013-01-15 00:00:00	2013-01-17 00:00:00	2012-12-27 00:00:00	2014-04-29 00:00:00	2014-05-05 00:00:00	2014-05-05 00:00:00	2013-04-18 00:00:00	2013-04-18 00:00:00	2013-03-19 00:00:00	2013-02-27 00:00:00	2013-03-06 00:00:00	2013-01-15 00:00:00	2013-01-17 00:00:00	2013-03-05 00:00:00	2013-04-17 00:00:00	2013-04-17 00:00:00	2013-04-17 00:00:00	2013-04-17 00:00:00	2013-04-29 00:00:00	2013-04-18 00:00:00	2017-12-19 00:00:00	2020-08-14 00:00:00	2020-08-14 00:00:00	2020-08-11 00:00:00	2021-05-18 00:00:00	2019-12-20 00:00:00	2018-04-30 00:00:00	2019-01-14 00:00:00	2020-12-29 00:00:00	2019-01-14 00:00:00	2019-01-14 00:00:00	2018-03-15 00:00:00	2019-01-15 00:00:00	2020-01-14 00:00:00	2018-03-21 00:00:00	2020-01-30 00:00:00	2018-01-17 00:00:00	2018-03-19 00:00:00	2018-08-14 00:00:00	2016-02-03 00:00:00	2016-02-09 00:00:00	2016-02-10 00:00:00	2016-02-03 00:00:00	2016-02-03 00:00:00	2016-02-12 00:00:00	2016-02-12 00:00:00	2016-02-12 00:00:00	2016-02-12 00:00:00	2016-01-28 00:00:00	2016-03-16 00:00:00	2016-03-17 00:00:00	2016-02-03 00:00:00	2015-10-23 00:00:00	2016-02-17 00:00:00	2016-02-17 00:00:00	2016-02-17 00:00:00	2016-02-17 00:00:00	2016-05-05 00:00:00	2016-05-03 00:00:00	2016-05-05 00:00:00	2016-04-29 00:00:00	2016-05-05 00:00:00	2016-05-05 00:00:00	2016-02-02 00:00:00	2016-02-02 00:00:00	2016-06-30 00:00:00	2016-06-01 00:00:00	2016-06-01 00:00:00	2016-06-01 00:00:00	2016-06-01 00:00:00	2016-05-03 00:00:00	2016-05-03 00:00:00	2016-05-03 00:00:00	2016-05-03 00:00:00	2016-05-03 00:00:00	2016-05-31 00:00:00	2016-07-28 00:00:00	2016-08-25 00:00:00	2016-08-30 00:00:00	2016-10-03 00:00:00	2016-08-25 00:00:00	2016-08-25 00:00:00	2016-08-25 00:00:00	2016-10-29 00:00:00	2017-01-30 00:00:00	2016-12-02 00:00:00	2016-12-02 00:00:00	2016-12-02 00:00:00	2016-12-02 00:00:00	2016-12-29 00:00:00	2016-12-02 00:00:00	2017-03-15 00:00:00	2017-03-15 00:00:00	2017-04-13 00:00:00	2017-04-13 00:00:00	2017-04-29 00:00:00	2016-12-29 00:00:00	2017-04-13 00:00:00	2017-04-13 00:00:00	2016-12-29 00:00:00	2017-02-22 00:00:00	2016-12-29 00:00:00	2016-12-29 00:00:00	2016-12-29 00:00:00	2016-12-29 00:00:00	2016-12-29 00:00:00	2017-07-30 00:00:00	2017-03-15 00:00:00	2017-04-25 00:00:00	2017-04-25 00:00:00	2017-03-15 00:00:00	2017-04-25 00:00:00	2017-05-01 00:00:00	2017-03-15 00:00:00	2017-04-25 00:00:00	2018-07-31 00:00:00	2018-07-31 00:00:00	2018-08-02 00:00:00	2021-01-10 00:00:00	2018-09-18 00:00:00	2019-01-14 00:00:00	2019-10-31 00:00:00	2019-01-30 00:00:00	2019-07-31 00:00:00	2018-09-18 00:00:00	2020-11-05 00:00:00	2020-11-03 00:00:00	2020-12-22 00:00:00	2017-10-30 00:00:00	2021-01-05 00:00:00	2018-03-19 00:00:00	2021-06-02 00:00:00	2018-01-17 00:00:00	2020-10-30 00:00:00	2021-02-02 00:00:00	2021-04-30 00:00:00	2019-02-27 00:00:00	2017-12-19 00:00:00	2020-01-13 00:00:00	2020-01-13 00:00:00	2021-02-22 00:00:00	2021-03-08 00:00:00	2019-02-27 00:00:00	2019-02-27 00:00:00	2019-02-27 00:00:00	2019-02-27 00:00:00	2018-01-31 00:00:00	2019-01-14 00:00:00	2019-01-15 00:00:00	2020-04-30 00:00:00	2018-08-15 00:00:00	2018-10-31 00:00:00	2020-12-22 00:00:00	2018-08-03 00:00:00	2019-04-30 00:00:00	2021-02-03 00:00:00	2021-02-22 00:00:00	2021-01-12 00:00:00	2019-12-20 00:00:00	2021-02-19 00:00:00	2021-03-29 00:00:00	2021-02-25 00:00:00	2021-03-10 00:00:00	2021-09-27 00:00:00	2021-03-11 00:00:00	2022-06-13 00:00:00	2021-07-08 00:00:00	2021-02-04 00:00:00	2021-03-25 00:00:00	2022-07-20 00:00:00	2022-07-20 00:00:00	2020-07-31 00:00:00	2021-02-22 00:00:00	2021-03-25 00:00:00	2021-03-10 00:00:00	2021-06-30 00:00:00	2021-11-09 00:00:00	2022-03-08 00:00:00	2021-01-29 00:00:00	2021-03-22 00:00:00	2022-06-14 00:00:00	2021-08-19 00:00:00	2021-11-01 00:00:00	2022-02-14 00:00:00	2022-03-08 00:00:00	2021-07-29 00:00:00	2022-08-01 00:00:00	2022-01-31 00:00:00	2022-02-18 00:00:00	2022-02-16 00:00:00	2021-03-08 00:00:00	2021-09-24 00:00:00	2021-08-23 00:00:00	2022-05-12 00:00:00	2021-06-03 00:00:00	2021-06-03 00:00:00	2022-05-12 00:00:00	2020-12-29 00:00:00	2022-05-02 00:00:00	2021-09-29 00:00:00	2021-09-29 00:00:00	2022-10-30 00:00:00
stmnt_type	10005	10005	10002	10006	10002	10005	10001	10005	10005	10005	10005	10002	10005	10005	10005	10006	10001	10006	10002	10006	10001	10001	10006	10006	10001	10002	10002	10001	10005	10002	10005	10001	10002	10005	10001	10001	10005	10002	10005	10001	10001	10001	10002	10006	10001	10006	10001	10001	10001	10001	10001	10001	10001	10001	10002	10002	10005	10005	10005	10005	10006	10005	10005	10002	10002	10005	10001	10002	10006	10006	10005	10002	10002	10002	10006	10006	10005	10002	10001	10001	10001	10001	10005	10002	10005	10005	10002	10001	10005	10001	10001	10005	10001	10001	10006	10001	10002	10002	10001	10002	10002	10002	10005	10006	10002	10005	10005	10002	10001	10002	10002	10001	10002	10005	10005	10001	10005	10005	10005	10005	10005	10002	10005	10001	10005	10005	10002	10001	10005	10005	10005	10006	10005	10002	10001	10002	10002	10002	10002	10001	10005	10005	10001	10005	10005	10005	10001	10001	10001	10002	10002	10002	10001	10001	10005	10005	10002	10002	10001	10005	10002	10002	10005	10002	10001	10001	10001	10005	10005	10001	10005	10005	10005	10006	10005	10002	10006	10006	10002	10001	10002	10001	10002	10001	10001	10001	10001	10005	10002	10002	10001	10001	10001	10006	10002	10006	10001	10002	10001	10005	10006	10005	10005	10002	10001	10002	10001	10001	10001	10001	10005	10001	10001	10006	10001	10001	10005	10001	10002	10001	10005	10002	10001	10002	10005	10002	10002	10005	10002	10005	10005	10005	10005	10005	10001	10001	10005	10005	10005	10002	10002	10001	10002	10005	10002	10001	10002	10002	10001	10001	10001	10002	10005	10002	10002	10002	10002	10005	10005	10002	10005	10001	10002	10005	10001
stmnt_status	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	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	11001	11001	11001	11001	11001	11001	11003	11001	11003	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	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	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	11003	11001	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003
session_id	2013	2013	2013	2013	2013	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2013	2013	2013	2013	2013	2015	2013	2015	2015	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2017	2019	2019	2019	2021	2019	2017	2019	2021	2019	2019	2017	2019	2019	2017	2019	2017	2017	2017	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2017	2015	2017	2017	2017	2017	2017	2017	2017	2017	2017	2015	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2021	2017	2019	2019	2017	2019	2017	2019	2019	2021	2017	2021	2017	2021	2017	2019	2021	2021	2019	2017	2019	2019	2021	2021	2019	2019	2019	2019	2017	2019	2019	2019	2017	2017	2021	2017	2019	2021	2021	2021	2019	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2019	2021	2021	2021	2021	2021	2021	2019	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021
user_id	SARRIAGA	SARRIAGA	YRODRIGU	YRODRIGU	YRODRIGU	SARRIAGA	AGLADNEY	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	SARRIAGA	GPEREZ	YRODRIGU	AGLADNEY	YRODRIGU	YRODRIGU	YRODRIGU	ASAETERN	ASAETERN	YRODRIGU	YRODRIGU	ASAETERN	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	SARRIAGA	YRODRIGU	SARRIAGA	SARRIAGA	SARRIAGA	YRODRIGU	PBANFORD	SARRIAGA	GPEREZ	YRODRIGU	YRODRIGU	ASAETERN	YRODRIGU	PBANFORD	ASAETERN	YRODRIGU	PBANFORD	AGLADNEY	YRODRIGU	SARRIAGA	SARRIAGA	PBANFORD	SARRIAGA	YRODRIGU	YRODRIGU	YRODRIGU	SARRIAGA	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	SARRIAGA	PBANFORD	YRODRIGU	YRODRIGU	GPEREZ	ASAETERN	YRODRIGU	SMCCONNAN	PBANFORD	PBANFORD	YRODRIGU	YRODRIGU	SARRIAGA	GPEREZ	GPEREZ	SARRIAGA	YRODRIGU	PBANFORD	PBANFORD	PBANFORD	ASAETERN	PBANFORD	YRODRIGU	GPEREZ	GPEREZ	GPEREZ	MKIRKHAM	SARRIAGA	AGLADNEY	CAFILER	MKIRKHAM	SUSHAKOV	SUSHAKOV	YRODRIGU	CAFILER	GPEREZ	GPEREZ	AGLADNEY	YRODRIGU	YRODRIGU	YRODRIGU	GPEREZ	YRODRIGU	YRODRIGU	GPEREZ	GPEREZ	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	AGLADNEY	YRODRIGU	GPEREZ	GPEREZ	AGLADNEY	GPEREZ	GPEREZ	GPEREZ	GPEREZ	GPEREZ	YRODRIGU	GPEREZ	AGLADNEY	GPEREZ	GPEREZ	YRODRIGU	YRODRIGU	YRODRIGU	GPEREZ	GPEREZ	YRODRIGU	GPEREZ	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	AGLADNEY	GPEREZ	GPEREZ	GPEREZ	GPEREZ	GPEREZ	GPEREZ	AGLADNEY	AGLADNEY	GPEREZ	GPEREZ	GPEREZ	GPEREZ	YRODRIGU	GPEREZ	SARRIAGA	SARRIAGA	GPEREZ	SARRIAGA	AGLADNEY	SARRIAGA	SARRIAGA	GPEREZ	GPEREZ	AGLADNEY	SARRIAGA	GPEREZ	SARRIAGA	SARRIAGA	YRODRIGU	AGLADNEY	YRODRIGU	SARRIAGA	GPEREZ	YRODRIGU	SARRIAGA	GPEREZ	YRODRIGU	YRODRIGU	AGLADNEY	AGLADNEY	GPEREZ	MKIRKHAM	GPEREZ	CAFILER	AGLADNEY	AGLADNEY	AGLADNEY	GPEREZ	MMERCHANT	MMERCHANT	CVANLIEW	AGLADNEY	MKIRKHAM	YRODRIGU	CAFILER	YRODRIGU	MKIRKHAM	CAFILER	MKIRKHAM	PBANFORD	YRODRIGU	GPEREZ	GPEREZ	SARRIAGA	MKIRKHAM	GPEREZ	GPEREZ	PBANFORD	GPEREZ	AGLADNEY	PBANFORD	PBANFORD	MKIRKHAM	YRODRIGU	AGLADNEY	MKIRKHAM	GPEREZ	AGLADNEY	CAFILER	CAFILER	MKIRKHAM	SARRIAGA	CAFILER	SARRIAGA	SARRIAGA	CVANLIEW	CAFILER	CVANLIEW	SARRIAGA	SARRIAGA	CVANLIEW	SARRIAGA	MMERCHANT	MMERCHANT	MKIRKHAM	CAFILER	SARRIAGA	MKIRKHAM	CVANLIEW	CHATRIDGE	CHATRIDGE	CHARTRIDGE	SARRIAGA	SARRIAGA	MMERCHANT	MKIRKHAM	SARRIAGA	MKIRKHAM	CHATRIDGE	CAFILER	MKIRKHAM	CVANLIEW	SARRIAGA	CAFILER	MKIRKHAM	MMERCHANT	CVANLIEW	MKIRKHAM	MKIRKHAM	CVANLIEW	CVANLIEW	CAFILER	MKIRKHAM	MKIRKHAM	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	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	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11003	11003	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11003	11001	11001	11001	11003	11001	11001	11003	11001	11001	11001	11001	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11003	11003	11001	11003	11003	11003	11003	11003	11001	11003	11001	11003	11003	11001	11001	11001	11003	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11001	11001	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11001	11003	11003	11003	11003	11001	11001	11001	11003	11003	11001	11003	11003	11001	11001	11001	11001	11003	11003	11003	11003	11001	11001	11001	11003	11003	11003	11003	11001	11003	11003	11003	11003	11001	11003	11001	11001	11003	11003	11003	11003	11003	11003	11003	11001	11003	11001	11001	11001	11001	11003	11001	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11001	11001	11001	11003	11003	11003	11001	11003	11001	11001	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
rpt_start	1900-01-01 00:00:00	1900-01-01 00:00:00	2013-03-27 00:00:00	1900-01-01 00:00:00	2013-08-16 00:00:00	1900-01-01 00:00:00	2015-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-04-28 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-01-01 00:00:00	1900-01-01 00:00:00	2014-05-22 00:00:00	1900-01-01 00:00:00	2014-04-01 00:00:00	2013-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2013-04-01 00:00:00	2013-11-20 00:00:00	2014-01-06 00:00:00	2013-09-03 00:00:00	1900-01-01 00:00:00	2013-08-16 00:00:00	1900-01-01 00:00:00	2015-01-22 00:00:00	2015-01-22 00:00:00	1900-01-01 00:00:00	2015-01-22 00:00:00	2015-01-22 00:00:00	1900-01-01 00:00:00	2015-03-02 00:00:00	1900-01-01 00:00:00	2015-03-02 00:00:00	2015-03-02 00:00:00	2014-07-01 00:00:00	2014-08-26 00:00:00	1900-01-01 00:00:00	2013-10-01 00:00:00	1900-01-01 00:00:00	2014-11-17 00:00:00	2014-10-01 00:00:00	2014-11-17 00:00:00	2014-11-17 00:00:00	2014-09-02 00:00:00	2012-12-13 00:00:00	2012-12-14 00:00:00	2012-12-14 00:00:00	2014-08-05 00:00:00	2014-06-25 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2013-01-10 00:00:00	2013-01-17 00:00:00	1900-01-01 00:00:00	2014-01-01 00:00:00	2014-04-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2013-03-18 00:00:00	2013-02-11 00:00:00	2013-03-04 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2013-04-16 00:00:00	2013-04-16 00:00:00	2013-04-16 00:00:00	2013-04-16 00:00:00	2013-01-01 00:00:00	1900-01-01 00:00:00	2017-12-19 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2020-04-20 00:00:00	2021-04-22 00:00:00	1900-01-01 00:00:00	2018-01-01 00:00:00	2018-11-08 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-11-08 00:00:00	2020-01-13 00:00:00	2018-03-19 00:00:00	2019-10-01 00:00:00	2018-01-17 00:00:00	2018-02-27 00:00:00	2018-08-10 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-01-28 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-02-09 00:00:00	2016-02-09 00:00:00	2016-02-09 00:00:00	2016-02-09 00:00:00	2015-10-01 00:00:00	2016-03-08 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-01-25 00:00:00	1900-01-01 00:00:00	2016-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-01-21 00:00:00	2016-01-25 00:00:00	None	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-05-02 00:00:00	2016-05-02 00:00:00	2016-05-01 00:00:00	2016-05-01 00:00:00	2016-01-25 00:00:00	2016-05-03 00:00:00	2016-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-08-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-07-01 00:00:00	2016-10-01 00:00:00	2016-05-02 00:00:00	2016-05-02 00:00:00	2016-05-02 00:00:00	2015-03-02 00:00:00	2016-11-22 00:00:00	2015-03-02 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-03-06 00:00:00	2017-03-06 00:00:00	2017-01-01 00:00:00	1900-01-01 00:00:00	2017-03-06 00:00:00	2017-03-06 00:00:00	1900-01-01 00:00:00	2016-10-01 00:00:00	2016-12-29 00:00:00	2016-12-29 00:00:00	2016-12-29 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-04-11 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-01-01 00:00:00	2018-04-01 00:00:00	2018-08-01 00:00:00	2020-12-09 00:00:00	2018-09-04 00:00:00	2018-11-08 00:00:00	2019-07-01 00:00:00	2018-10-01 00:00:00	2019-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2020-10-26 00:00:00	2020-12-09 00:00:00	2017-07-01 00:00:00	2020-12-09 00:00:00	1900-01-01 00:00:00	2021-04-22 00:00:00	1900-01-01 00:00:00	2020-07-01 00:00:00	2021-01-20 00:00:00	2021-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-02-03 00:00:00	2021-02-22 00:00:00	2019-01-22 00:00:00	2019-01-22 00:00:00	2019-01-22 00:00:00	2019-01-22 00:00:00	2017-10-01 00:00:00	1900-01-01 00:00:00	2018-11-08 00:00:00	2020-01-01 00:00:00	1900-01-01 00:00:00	2018-07-01 00:00:00	2020-12-09 00:00:00	1900-01-01 00:00:00	2019-01-01 00:00:00	2021-02-02 00:00:00	2021-02-03 00:00:00	1900-01-01 00:00:00	2019-12-10 00:00:00	2021-01-19 00:00:00	2021-03-22 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-09-27 00:00:00	1900-01-01 00:00:00	2022-05-09 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2020-04-01 00:00:00	2021-02-03 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-04-01 00:00:00	2021-04-01 00:00:00	2020-10-01 00:00:00	2021-03-22 00:00:00	1900-01-01 00:00:00	2021-05-11 00:00:00	2021-07-01 00:00:00	2022-02-08 00:00:00	2021-07-01 00:00:00	2021-04-01 00:00:00	2022-04-01 00:00:00	2021-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-02-22 00:00:00	2021-07-26 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2022-05-03 00:00:00	1900-01-01 00:00:00	2022-01-01 00:00:00	1900-01-01 00:00:00	1900-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	2013-03-27 00:00:00	1900-01-01 00:00:00	2013-08-16 00:00:00	1900-01-01 00:00:00	2015-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-04-28 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-03-31 00:00:00	1900-01-01 00:00:00	2014-05-22 00:00:00	1900-01-01 00:00:00	2014-06-30 00:00:00	2013-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2013-06-30 00:00:00	2013-11-20 00:00:00	2014-01-06 00:00:00	2013-09-03 00:00:00	1900-01-01 00:00:00	2013-08-16 00:00:00	1900-01-01 00:00:00	2015-01-22 00:00:00	2015-01-22 00:00:00	1900-01-01 00:00:00	2015-01-22 00:00:00	2015-01-22 00:00:00	1900-01-01 00:00:00	2015-03-02 00:00:00	1900-01-01 00:00:00	2015-03-02 00:00:00	2015-03-02 00:00:00	2014-09-30 00:00:00	2014-08-26 00:00:00	1900-01-01 00:00:00	2013-12-31 00:00:00	1900-01-01 00:00:00	2014-11-17 00:00:00	2014-12-31 00:00:00	2014-11-17 00:00:00	2014-11-17 00:00:00	2014-09-02 00:00:00	2012-12-13 00:00:00	2012-12-14 00:00:00	2012-12-14 00:00:00	2014-08-05 00:00:00	2014-06-25 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2013-01-10 00:00:00	2013-01-17 00:00:00	1900-01-01 00:00:00	2014-03-31 00:00:00	2014-04-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2013-03-18 00:00:00	2013-02-11 00:00:00	2013-03-04 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2013-04-16 00:00:00	2013-04-16 00:00:00	2013-04-16 00:00:00	2013-04-16 00:00:00	2013-03-31 00:00:00	1900-01-01 00:00:00	2017-12-19 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2020-04-20 00:00:00	2021-04-22 00:00:00	1900-01-01 00:00:00	2018-03-31 00:00:00	2018-11-08 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-11-08 00:00:00	2020-01-13 00:00:00	2018-03-19 00:00:00	2019-12-31 00:00:00	2018-01-17 00:00:00	2018-02-27 00:00:00	2018-08-10 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-01-28 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-02-09 00:00:00	2016-02-09 00:00:00	2016-02-09 00:00:00	2016-02-09 00:00:00	2015-12-31 00:00:00	2016-03-08 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-01-25 00:00:00	1900-01-01 00:00:00	2016-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-01-21 00:00:00	2016-01-25 00:00:00	None	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-05-02 00:00:00	2016-05-02 00:00:00	2016-05-01 00:00:00	2016-05-01 00:00:00	2016-01-25 00:00:00	2016-05-03 00:00:00	2016-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-08-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-09-30 00:00:00	2016-12-31 00:00:00	2016-05-02 00:00:00	2016-05-02 00:00:00	2016-05-02 00:00:00	2015-03-02 00:00:00	2016-11-22 00:00:00	2015-03-02 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-03-06 00:00:00	2017-03-06 00:00:00	2017-03-31 00:00:00	1900-01-01 00:00:00	2017-03-06 00:00:00	2017-03-06 00:00:00	1900-01-01 00:00:00	2016-12-31 00:00:00	2016-12-29 00:00:00	2016-12-29 00:00:00	2016-12-29 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-04-11 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-03-31 00:00:00	2018-06-30 00:00:00	2018-08-01 00:00:00	2020-12-09 00:00:00	2018-09-04 00:00:00	2018-11-08 00:00:00	2019-09-30 00:00:00	2018-12-31 00:00:00	2019-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2020-10-26 00:00:00	2020-12-09 00:00:00	2017-09-30 00:00:00	2020-12-09 00:00:00	1900-01-01 00:00:00	2021-04-22 00:00:00	1900-01-01 00:00:00	2020-09-30 00:00:00	2021-01-20 00:00:00	2021-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-02-03 00:00:00	2021-02-22 00:00:00	2019-01-22 00:00:00	2019-01-22 00:00:00	2019-01-22 00:00:00	2019-01-22 00:00:00	2017-12-31 00:00:00	1900-01-01 00:00:00	2018-11-08 00:00:00	2020-03-31 00:00:00	1900-01-01 00:00:00	2018-09-30 00:00:00	2020-12-09 00:00:00	1900-01-01 00:00:00	2019-03-31 00:00:00	2021-02-02 00:00:00	2021-02-03 00:00:00	1900-01-01 00:00:00	2019-12-10 00:00:00	2021-01-19 00:00:00	2021-03-22 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-09-27 00:00:00	1900-01-01 00:00:00	2022-05-09 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2020-06-30 00:00:00	2021-02-03 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-06-30 00:00:00	2021-06-30 00:00:00	2020-12-31 00:00:00	2021-03-22 00:00:00	1900-01-01 00:00:00	2021-05-11 00:00:00	2021-09-30 00:00:00	2022-02-08 00:00:00	2021-09-30 00:00:00	2021-06-30 00:00:00	2022-06-30 00:00:00	2021-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-02-22 00:00:00	2021-07-26 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2022-05-03 00:00:00	1900-01-01 00:00:00	2022-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	22001	None	22001	None	22001	None	None	None	None	22001	None	None	None	None	22001	None	22001	None	22001	22001	None	None	22001	22001	22001	22001	None	22001	None	22001	22001	None	22001	22001	None	22001	None	22001	22001	22001	22001	None	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	None	None	None	None	None	None	22001	22001	None	22001	22001	None	None	None	22001	22001	22001	None	None	None	22001	22001	22001	22001	22001	None	22001	None	None	22001	22001	None	22001	22001	None	None	None	None	22001	22001	22001	22001	22001	22001	22001	None	None	22001	None	None	22001	22001	22001	22001	22001	22001	None	None	22001	None	None	None	None	None	22001	None	22001	None	None	22001	22001	None	None	None	None	None	22001	22001	22001	22001	22001	22001	22001	None	None	22001	None	None	None	22001	22001	22001	22001	22001	22001	22001	22001	None	None	22001	22001	22001	None	22001	22001	None	22001	22001	22001	22001	None	None	22001	None	None	None	None	None	22001	None	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	None	22001	22001	22001	22001	None	22001	None	22001	22001	22001	None	None	None	None	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	None	22001	22001	None	22001	22001	22001	None	22001	22001	22001	None	None	22001	None	22001	None	None	None	None	None	22001	22001	None	None	None	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	None	None	22001	22001	None	None	None	None	22001	None	22001	None	None	22001

Table: filer_to_filer_type
filer_id	1354236	1354236	1354236	1354236	1354236	1354236
filer_type	3	3	3	3	3	3
active	Y	Y	Y	Y	Y	N
race	0	None	None	None	None	None
session_id	2013	2021	2019	2015	2017	2023
category	0	None	None	None	None	None
category_type	0	None	None	None	None	None
sub_category	0	None	None	None	None	None
effect_dt	2013-01-01 00:00:00	2021-01-01 00:00:00	2019-01-01 00:00:00	2015-01-01 00:00:00	2017-01-01 00:00:00	2023-01-01 00:00:00
sub_category_type	0	None	None	None	None	None
election_type	0	None	None	None	None	None
sub_category_a	None	None	None	None	None	None
nyq_dt	None	None	None	None	None	None
party_cd	0	None	None	None	None	None
county_cd	0	None	None	None	None	None
district_cd	0	None	None	None	None	None

Table: filer_xref
filer_id		1354236
xref_id		1354236
effect_dt		2012-12-26 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236
filer_id	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236
filer_type	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM
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
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
naml	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC
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
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
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
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
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
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
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
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
phon	9164797400	9164747400	9164797400	9164797400	9164797400	9164797400	9164797400	9164797400	9164747400	9164797400	9164797400	9164797400	9164797400	9164797400	9164797400	9164747400	9164797400	9164797400	9164797400	9164797400	9164797400	9164797400	9164747400	9164797400	9164797400	9164797400	9164797400	9164797400	9164797400	9164747400	9164797400	9164797400	9164797400	9164797400	9164797400	9164797400	9164747400	9164797400	9164797400	9164797400	9164797400	9164797400
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
email	None	None	None	None	[email protected]	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]

Table: filers
filer_id		1354236

Table: lobbying_chg_log
filer_id	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236
change_no	0	4	1	2	3	10	11	13	5	12	9	6	7	8	16	14	15	17	18	19	21	22	20	25	26	24	23	30	27	29	28	31	32	33	34
session_id	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2015	2015	2015	2015	2015	2015	2015	2015	2015	2017	2017	2017	2017	2017	2017	2017	2017	2017	2019	2019	2021
log_dt	2013-02-12 00:00:00	2014-01-08 00:00:00	2013-09-24 00:00:00	2013-09-24 00:00:00	2013-11-26 00:00:00	2014-05-23 00:00:00	2014-07-08 00:00:00	2014-08-19 00:00:00	2014-05-05 00:00:00	2013-08-30 00:00:00	2013-03-28 00:00:00	2013-03-05 00:00:00	2013-03-05 00:00:00	2013-03-08 00:00:00	2015-05-28 00:00:00	2015-02-02 00:00:00	2015-03-17 00:00:00	2016-02-03 00:00:00	2016-02-03 00:00:00	2016-02-17 00:00:00	2016-02-09 00:00:00	2016-06-01 00:00:00	2016-05-05 00:00:00	2017-04-25 00:00:00	2017-12-19 00:00:00	2017-03-15 00:00:00	2017-04-11 00:00:00	2018-08-03 00:00:00	2018-01-17 00:00:00	2018-03-19 00:00:00	2018-03-15 00:00:00	2018-09-18 00:00:00	2020-08-14 00:00:00	2020-08-14 00:00:00	2021-09-29 00:00:00
filer_type	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3
correction_flg	None	None	None	None	None	None	None	None	None	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	None	None	None
action	ADDED	DELETED	DELETED	ADDED	DELETED	ADDED	ADDED	ADDED	DELETED	ADDED	ADDED	ADDED	ADDED	ADDED	ADDED	ADDED	ADDED	ADDED	DELETED	ADDED	ADDED	ADDED	ADDED	ADDED	DELETED	ADDED	ADDED	DELETED	DELETED	ADDED	ADDED	ADDED	SET ACTIVE	DELETED	ADDED
attribute_changed	FIRM	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	/ FIRM	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	CLIENT	FIRM	CLIENT
ethics_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
interests	None	None	None	None	None	None	None	None	None	None	None	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_full_name	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC	CLEAR ADVOCACY, LLC
filer_city	None	None	None	None	None	None	None	None	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	None	None	None
filer_st	None	None	None	None	None	None	None	None	None	CA	CA	CA	CA	CA	CA	CA	CA	None	None	CA	CA	CA	CA	CA	CA	CA	CA	None	CA	CA	CA	None	None	None	None
filer_zip	None	None	None	None	None	None	None	None	None	95814	95814	95814	95814	95814	95814	95814	95814	None	None	95814	95814	95814	95814	95814	95814	95814	95814	None	95814	95814	95814	None	None	None	None
filer_phone	None	None	None	None	None	None	None	None	None	9164797400	9164797400	9164797400	9164797400	9164797400	9164797400	9164797400	9164797400	None	None	9164797400	9164797400	9164797400	9164797400	9164797400	9164797400	9164797400	9164797400	None	9164797400	9164797400	9164797400	None	None	None	None
entity_type	3	1	1	1	1	1	1	1	1	1	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	1	3	1
entity_name	MAIN ADVOCACY LLC	NEUROMODULATION THERAPY ACCESS COALITION	CALIFORNIA ACUPUNCTURE COALITION	PUBLIC CONSULTING GROUP	FANTASIA HEALTHCARE	CALIFORNIA ASSOCIATION FOR HEALTH SERVICES AT HOME	STANBRIDGE COLLEGE	RYDER SYSTEM, INC.	PUBLIC CONSULTING GROUP	MANATT, PHELPS & PHILLIPS, LLP	CALIFORNIA ACUPUNCTURE COALITION	UNITED RENTALS, INC.	CALPACE	CIGNA COMPANIES	ERICKSON LIVING MANAGEMENT LLC	TOGETHER WE GROW	LIFEMAP ASSURANCE COMPANY	WORD & BROWN	CARCO GROUP, INC.	MISSEL	CALBX, THE FEDERATION OF CALIFORNIA BUILDERS EXCHANGES	CALIFORNIA BIRTH CENTER ASSOCIATION	CALIFORNIA SOCIETY FOR ALLERGY, ASTHMA AND IMMUNOLOGY (CSAAI)	NATIONAL CONFECTIONERS ASSOCIATION	LIFEMAP ASSURANCE COMPANY	U.S. RENAL CARE	FMR LLC	CALIFORNIA NURSE MIDWIVES ASSOCIATION (CNMA)	PEER SERVICES, INC.	ACCREDITED HOME CARE	PEDIATRIC DAY HEALTH CARE PROVIDERS COALITION	PEDIATRIC DAY HEALTH CARE COALITION	NATIONAL FEDERATION OF INDEPENDENT BUSINESS	JK PEDROTTI., INC. GOVERNMENT RELATIONS	UNIVERSAL HYDROGEN CO.
entity_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
entity_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
entity_zip	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_phone	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_id	1356868	1332379	1348635	1360920	1339664	1147158	1285956	1371044	1360920	None	None	None	None	None	None	None	None	1144903	1317934	None	None	None	None	None	None	None	None	1145466	None	None	None	1403931	1146834	1241801	1440516
responsible_officer	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
effect_dt	2013-01-01 00:00:00	2013-06-30 00:00:00	2013-09-13 00:00:00	2013-08-15 00:00:00	2013-09-30 00:00:00	2014-05-22 00:00:00	2014-05-21 00:00:00	2014-07-30 00:00:00	2014-03-31 00:00:00	2013-05-01 00:00:00	2013-03-18 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-03-01 00:00:00	2015-04-01 00:00:00	2015-01-22 00:00:00	2015-03-02 00:00:00	2016-01-01 00:00:00	2015-12-31 00:00:00	2016-02-01 00:00:00	2016-01-25 00:00:00	2016-04-18 00:00:00	2016-05-01 00:00:00	2017-04-11 00:00:00	2017-09-30 00:00:00	2017-03-01 00:00:00	2017-03-01 00:00:00	2018-07-31 00:00:00	2017-12-31 00:00:00	2018-02-26 00:00:00	2018-02-26 00:00:00	2018-07-01 00:00:00	2020-01-01 00:00:00	2020-01-01 00:00:00	2021-07-15 00:00:00

Table: received_filings
filer_id	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236	1354236
filing_file_name	1720640_12.cal	1720640_5.cal	1720640_1.cal	1720640_2.cal	1720640_6.cal	1720640_8.cal	1720640_11.cal	1720640_9.cal	27018.cal	1720640_7.cal	26830.cal	1720640_0.cal	1720640_10.cal	1720640_13.cal	476779.cal	1923118_3.cal	476778.cal	1923118_9.cal	109015.cal	425748.cal	426091.cal	499250.cal	2115263_1.cal	425543.cal	425789.cal	1720640_15.cal	1720640_14.cal	1720640_16.cal	117978.cal	159527.cal	1923118_4.cal	355687.cal	1923118_7.cal	159411.cal	1923118_5.cal	296031.cal	296189.cal	1923118_6.cal	2115263_0.cal	318804.cal	1923118_0.cal	1923118_8.cal	61490.cal	61599.cal	1923118_2.cal	123591.cal	124308.cal	124342.cal	232721.cal	233338.cal	1923118_1.cal	2115263_2.cal	481771.cal	481618.cal	481665.cal	481716.cal	481791.cal	223515.cal	2115263_3.cal	142994.cal	2115263_6.cal	93459.cal	2115263_8.cal	2115263_4.cal	2115263_5.cal	2115263_7.cal	2115263_9.cal	496370.cal	521336.cal	2334275_0.cal	2334275_3.cal	2334275_4.cal	142734.cal	143174.cal	2334275_1.cal	328620.cal	52131.cal	52121.cal	2334275_2.cal	117977.cal	117934.cal	521311.cal	342801.cal	342933.cal	40748.cal	2543140_0.cal	335722.cal	335733.cal	515500.cal	362379.cal	324453.cal	324745.cal	2543140_7.cal	405324.cal	5290.cal	43778.cal	2543140_4.cal	40412.cal	39612.cal	33858.cal	334986.cal	335093.cal	335700.cal	407075.cal	4812.cal	5239.cal	5294.cal	2543140_5.cal	407117.cal	40925.cal	2334275_5.cal	2543140_11.cal	113036.cal	2543140_6.cal	2543140_3.cal	2543140_2.cal	2543140_9.cal	335195.cal	335281.cal	335290.cal	5371.cal	2543140_8.cal	15820.cal	2543140_10.cal	2543140_1.cal
received_date	2014-05-05 00:00:00	2013-03-19 00:00:00	2013-01-15 00:00:00	2013-01-17 00:00:00	2013-03-27 00:00:00	2013-08-30 00:00:00	2014-01-07 00:00:00	2013-09-24 00:00:00	2013-04-17 00:00:00	2013-04-17 00:00:00	2013-04-17 00:00:00	2012-12-27 00:00:00	2013-11-22 00:00:00	2014-05-27 00:00:00	2015-05-28 00:00:00	2015-05-28 00:00:00	2015-05-28 00:00:00	2016-05-31 00:00:00	2016-05-31 00:00:00	2016-12-02 00:00:00	2016-12-02 00:00:00	2017-04-13 00:00:00	2017-04-13 00:00:00	2016-12-02 00:00:00	2016-12-02 00:00:00	2014-08-19 00:00:00	2014-08-05 00:00:00	2014-09-03 00:00:00	2014-09-03 00:00:00	2016-02-02 00:00:00	2016-02-02 00:00:00	2016-03-16 00:00:00	2016-03-16 00:00:00	2016-02-02 00:00:00	2016-02-10 00:00:00	2016-02-12 00:00:00	2016-02-12 00:00:00	2016-02-12 00:00:00	2016-12-29 00:00:00	2016-12-29 00:00:00	2015-01-06 00:00:00	2016-05-03 00:00:00	2016-05-03 00:00:00	2016-05-03 00:00:00	2015-03-17 00:00:00	2015-03-17 00:00:00	2015-03-17 00:00:00	2015-03-17 00:00:00	2015-03-25 00:00:00	2015-03-25 00:00:00	2015-02-02 00:00:00	2017-05-01 00:00:00	2017-05-01 00:00:00	2017-05-01 00:00:00	2017-05-01 00:00:00	2017-05-01 00:00:00	2017-05-01 00:00:00	2017-12-19 00:00:00	2017-12-19 00:00:00	2020-08-11 00:00:00	2018-03-21 00:00:00	2018-03-21 00:00:00	2018-08-14 00:00:00	2018-01-17 00:00:00	2018-03-19 00:00:00	2018-08-02 00:00:00	2018-09-18 00:00:00	2020-08-31 00:00:00	2019-06-20 00:00:00	2019-01-14 00:00:00	2020-01-14 00:00:00	2020-08-11 00:00:00	2020-08-11 00:00:00	2020-08-11 00:00:00	2019-02-27 00:00:00	2019-02-27 00:00:00	2020-01-14 00:00:00	2020-01-14 00:00:00	2019-12-20 00:00:00	2018-03-22 00:00:00	2018-03-22 00:00:00	2019-06-20 00:00:00	2021-03-22 00:00:00	2021-03-22 00:00:00	2021-09-27 00:00:00	2021-01-10 00:00:00	2021-06-02 00:00:00	2021-06-02 00:00:00	2021-09-23 00:00:00	2021-02-22 00:00:00	2021-02-19 00:00:00	2021-02-19 00:00:00	2021-08-19 00:00:00	2021-08-19 00:00:00	2021-09-24 00:00:00	2021-09-27 00:00:00	2021-03-08 00:00:00	2021-09-27 00:00:00	2021-09-27 00:00:00	2021-09-27 00:00:00	2021-06-02 00:00:00	2021-06-02 00:00:00	2021-06-02 00:00:00	2021-08-19 00:00:00	2021-05-18 00:00:00	2021-09-24 00:00:00	2021-09-24 00:00:00	2021-03-22 00:00:00	2021-08-19 00:00:00	2021-09-27 00:00:00	2020-11-03 00:00:00	2022-06-13 00:00:00	2021-06-24 00:00:00	2021-03-29 00:00:00	2021-02-22 00:00:00	2021-02-03 00:00:00	2022-02-14 00:00:00	2021-06-02 00:00:00	2021-06-02 00:00:00	2021-06-02 00:00:00	2021-09-24 00:00:00	2021-09-24 00:00:00	2022-05-12 00:00:00	2022-05-12 00:00:00	2021-02-02 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/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/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/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/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/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal
filing_id	1720640	1720640	1720640	1720640	1720640	1720640	1720640	1720640	None	1720640	None	1720640	1720640	1720640	None	1923118	None	1923118	None	None	None	None	2115263	None	None	1720640	1720640	1720640	None	None	1923118	None	1923118	None	1923118	None	None	1923118	2115263	None	1923118	1923118	None	None	1923118	None	None	None	None	None	1923118	2115263	None	None	None	None	None	None	2115263	None	2115263	None	2115263	2115263	2115263	2115263	2115263	None	None	2334275	2334275	2334275	None	None	2334275	None	None	None	2334275	None	None	None	None	None	None	2543140	None	None	None	None	None	None	2543140	None	None	None	2543140	None	None	None	None	None	None	None	None	None	None	2543140	None	None	2334275	2543140	None	2543140	2543140	2543140	2543140	None	None	None	None	2543140	None	2543140	2543140
form_id	F601	F601	F601	F601	F601	F601	F601	F601	None	F601	None	F601	F601	F601	None	F601	None	F601	None	None	None	None	F601	None	None	F601	F601	F601	None	None	F601	None	F601	None	F601	None	None	F601	F601	None	F601	F601	None	None	F601	None	None	None	None	None	F601	F601	None	None	None	None	None	None	F601	None	F601	None	F601	F601	F601	F601	F601	None	None	F601	F601	F601	None	None	F601	None	None	None	F601	None	None	None	None	None	None	F601	None	None	None	None	None	None	F601	None	None	None	F601	None	None	None	None	None	None	None	None	None	None	F601	None	None	F601	F601	None	F601	F601	F601	F601	None	None	None	None	F601	None	F601	F601
receive_comment	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 passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing did not pass validation	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing did not pass validation	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing did not pass validation	Filing passed validation, but failed DB constraints	Filing accepted	Filing did not pass validation	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing did not pass validation	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing did not pass validation	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing did not pass validation	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing did not pass validation	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing did not pass validation	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing did not pass validation	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted