Home

Filer ID: 1339224

Table: cvr_lobby_disclosure

filing_id		1621954		1606257		1636195		1678865		1708717		1636195		1657182		1736139		1798867		1764522		1781567		1764522		1816656		1868829		1843609		1909485		1964363		1980833		1993699		1934626		2060376		2099944		2035497		2008584		2174660		2156511		2126708		2189663		2240565		2240565		2273321		2205888		2377595		2394095		2317964		2344156		2438976		2438976		2468028		2416659		2468028		2438976		2486360		2486360		2468028		2530053		2551418		2624136		2603835		2578441		2578441		2706631		2645080		2675609		2746403
amend_id		0		0		0		0		0		1		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		1		0		0		1		2		1		0		2		0		0		0		0		0		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		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		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625
sender_id		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224
filer_id		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224
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		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM
filer_naml		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, 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
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
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
report_num		000		000		000		000		000		001		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		001		000		000		001		002		001		000		002		000		000		000		000		000		001		000		000		000		000
rpt_date		2011-10-25 00:00:00		2011-07-20 00:00:00		2012-01-30 00:00:00		2012-07-16 00:00:00		2012-10-11 00:00:00		2012-04-12 00:00:00		2012-04-24 00:00:00		2013-01-24 00:00:00		2013-10-25 00:00:00		2013-07-23 00:00:00		2013-07-23 00:00:00		2013-04-23 00:00:00		2014-01-21 00:00:00		2014-07-10 00:00:00		2014-04-22 00:00:00		2014-10-21 00:00:00		2015-04-16 00:00:00		2015-07-15 00:00:00		2015-10-12 00:00:00		2015-01-19 00:00:00		2016-07-16 00:00:00		2016-10-19 00:00:00		2016-04-11 00:00:00		2016-01-15 00:00:00		2017-07-14 00:00:00		2017-04-13 00:00:00		2017-01-13 00:00:00		2017-10-12 00:00:00		2018-07-19 00:00:00		2018-04-13 00:00:00		2018-07-19 00:00:00		2017-01-19 00:00:00		2019-04-19 00:00:00		2019-07-23 00:00:00		2018-10-19 00:00:00		2019-01-16 00:00:00		2020-01-01 00:00:00		2020-02-05 00:00:00		2020-04-11 00:00:00		2019-10-14 00:00:00		2020-04-30 00:00:00		2020-10-15 00:00:00		2020-10-15 00:00:00		2020-04-30 00:00:00		2020-10-15 00:00:00		2020-10-15 00:00:00		2020-10-15 00:00:00		2021-10-27 00:00:00		2021-07-22 00:00:00		2021-04-27 00:00:00		2021-07-22 00:00:00		2022-07-21 00:00:00		2022-01-19 00:00:00		2022-04-26 00:00:00		2022-10-16 00:00:00
from_date		2011-07-01 00:00:00		2011-04-01 00:00:00		2011-10-01 00:00:00		2012-04-01 00:00:00		2012-07-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		2012-10-01 00:00:00		2013-07-01 00:00:00		2013-01-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-01-01 00:00:00		2015-04-01 00:00:00		2015-07-01 00:00:00		2014-10-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-01-01 00:00:00		2015-10-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2016-10-01 00:00:00		2017-07-01 00:00:00		2018-01-01 00:00:00		2018-01-01 00:00:00		2018-04-01 00:00:00		2017-10-01 00:00:00		2019-01-01 00:00:00		2019-04-01 00:00:00		2018-07-01 00:00:00		2018-10-01 00:00:00		2019-10-01 00:00:00		2019-10-01 00:00:00		2020-01-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2019-10-01 00:00:00		2020-04-01 00:00:00		2020-04-01 00:00:00		2020-01-01 00:00:00		2020-07-01 00:00:00		2020-10-01 00:00:00		2021-07-01 00:00:00		2021-04-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2022-04-01 00:00:00		2021-10-01 00:00:00		2022-01-01 00:00:00		2022-07-01 00:00:00
thru_date		2011-09-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2012-09-30 00:00:00		2011-12-31 00:00:00		2012-03-31 00:00:00		2012-12-31 00:00:00		2013-09-30 00:00:00		2013-03-31 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-03-31 00:00:00		2015-06-30 00:00:00		2015-09-30 00:00:00		2014-12-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-03-31 00:00:00		2015-12-31 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2016-12-31 00:00:00		2017-09-30 00:00:00		2018-03-31 00:00:00		2018-03-31 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2019-03-31 00:00:00		2019-06-30 00:00:00		2018-09-30 00:00:00		2018-12-31 00:00:00		2019-12-31 00:00:00		2019-12-31 00:00:00		2020-03-31 00:00:00		2019-09-30 00:00:00		2020-03-31 00:00:00		2019-12-31 00:00:00		2020-06-30 00:00:00		2020-06-30 00:00:00		2020-03-31 00:00:00		2020-09-30 00:00:00		2020-12-31 00:00:00		2021-09-30 00:00:00		2021-06-30 00:00:00		2021-03-31 00:00:00		2021-03-31 00:00:00		2022-06-30 00:00:00		2021-12-31 00:00:00		2022-03-31 00:00:00		2022-09-30 00:00:00
cum_beg_dt		2011-04-01 00:00:00		2011-04-01 00:00:00		2011-04-01 00:00:00		2011-04-01 00:00:00		2011-04-01 00:00:00		2011-04-01 00:00:00		2011-04-01 00:00:00		2011-04-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		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		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		2019-01-01 00:00:00		2019-01-01 00:00:00		2017-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		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
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None
firm_name		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, 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		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
firm_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
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		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
firm_phon		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591
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
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
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
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
sig_date		2011-10-25 00:00:00		2011-07-20 00:00:00		2012-01-30 00:00:00		2012-07-16 00:00:00		2012-10-11 00:00:00		2012-04-12 00:00:00		2012-04-24 00:00:00		2013-01-24 00:00:00		2013-10-25 00:00:00		2013-07-23 00:00:00		2013-07-23 00:00:00		2013-04-23 00:00:00		2014-01-21 00:00:00		2014-07-10 00:00:00		2014-04-22 00:00:00		2014-10-21 00:00:00		2015-04-16 00:00:00		2015-07-15 00:00:00		2015-10-12 00:00:00		2015-01-19 00:00:00		2016-07-16 00:00:00		2016-10-19 00:00:00		2016-04-11 00:00:00		2016-01-15 00:00:00		2017-07-14 00:00:00		2017-04-13 00:00:00		2017-01-13 00:00:00		2017-10-12 00:00:00		2018-07-19 00:00:00		2018-04-13 00:00:00		2018-07-19 00:00:00		2018-01-19 00:00:00		2019-04-19 00:00:00		2019-07-23 00:00:00		2018-10-19 00:00:00		2019-01-16 00:00:00		2020-01-12 00:00:00		2020-02-05 00:00:00		2020-04-11 00:00:00		2019-10-14 00:00:00		2020-04-30 00:00:00		2020-10-15 00:00:00		2020-10-15 00:00:00		2020-07-15 00:00:00		2020-10-15 00:00:00		2020-10-15 00:00:00		2021-01-18 00:00:00		2021-10-27 00:00:00		2021-07-22 00:00:00		2021-04-27 00:00:00		2021-07-22 00:00:00		2022-07-21 00:00:00		2022-01-19 00:00:00		2022-04-26 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		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA
sig_naml		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV
sig_namf		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.
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
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
prn_naml		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV
prn_namf		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.
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
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
sig_title		OWNER 4525KAH		OWNER 4525KAH		OWNER 4525KAH		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAH		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER		OWNER		OWNER		OWNER 4525KAU		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER
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		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		None		None		None		None		None		None		None		None		None		None		None
part1_1_cb		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
part1_2_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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		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		None		None		None		None		None		None		None		None		None		None		None
lby_actvty		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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		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		None		None		None		None		None		None		None		None		None		None		None
major_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpcmte_nm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpcmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: cvr_registration

filing_id		1598227		1598227		1598227		1598227		1668964		1668963		1598227		1726161		1726169		1731548		1726161		1726161		1726161		1731548		1726161		1918102		1918112		1726161		1918102		1918102		1918102		1918102		1918102		1918102		1918102		1918102		2116673		2116645		2116645		2116645		2116645		2116645		2116645		2116645		2293020		2116645		2329176		2329176		2329176		2329176		2329176		2329176		2543868		2543868		2329176		2543868		2543868		2543868
amend_id		0		3		2		1		0		0		4		0		0		0		3		1		2		1		4		0		0		5		3		2		1		7		4		6		5		8		0		0		1		2		6		4		3		5		0		7		0		2		1		4		5		3		0		1		6		3		2		4
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
form_type		F601		F601		F601		F601		F602		F602		F601		F601		F602		F602		F601		F601		F601		F602		F601		F601		F602		F601		F601		F601		F601		F601		F601		F601		F601		F601		F602		F601		F601		F601		F601		F601		F601		F601		F602		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601
sender_id		1339224		1339224		1339224		1339224		1346470		1346471		1339224		1339224		1346471		1340042		1339224		1339224		1339224		1340042		1339224		1339224		1346471		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1346471		1339224		1339224		1339224		1339224		1339224		1339224		1339224		F00515		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224
filer_id		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224
entity_cd		FRM		FRM		FRM		FRM		LCO		LEM		FRM		FRM		LEM		LEM		FRM		FRM		FRM		LEM		FRM		FRM		LEM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		LEM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		LEM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM
filer_naml		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		DIESEL RETROFIT COALITION		TRUECAR, INC.		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		TRUECAR, INC.		CAPITOL STRATEGIC ADVISORS LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		TRUECAR, INC.		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		TRUECAR, INC.		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, 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
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
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
report_num		000		003		002		001		000		000		004		000		000		000		003		001		002		001		004		000		000		005		003		002		001		007		004		006		005		008		000		000		001		002		006		004		003		005		000		007		000		002		001		004		005		003		000		001		006		003		002		004
rpt_date		2011-06-01 00:00:00		2012-03-19 00:00:00		2012-03-02 00:00:00		2012-03-01 00:00:00		2012-03-27 00:00:00		2012-02-27 00:00:00		2012-10-11 00:00:00		2012-12-18 00:00:00		2012-12-18 00:00:00		2012-12-28 00:00:00		2013-08-29 00:00:00		2013-04-19 00:00:00		2013-08-15 00:00:00		2013-08-14 00:00:00		2014-05-14 00:00:00		2014-11-10 00:00:00		2014-11-10 00:00:00		2014-10-27 00:00:00		2015-04-28 00:00:00		2015-01-27 00:00:00		2014-12-29 00:00:00		2016-01-01 00:00:00		2015-10-16 00:00:00		2015-12-01 00:00:00		2015-10-22 00:00:00		2016-03-25 00:00:00		2016-11-10 00:00:00		2016-11-10 00:00:00		2017-01-24 00:00:00		2017-03-20 00:00:00		2018-01-02 00:00:00		2017-09-12 00:00:00		2017-08-04 00:00:00		2017-11-02 00:00:00		2018-09-14 00:00:00		2018-12-12 00:00:00		2018-11-15 00:00:00		2019-11-13 00:00:00		2019-05-21 00:00:00		2020-05-22 00:00:00		2020-10-24 00:00:00		2020-01-28 00:00:00		2020-12-28 00:00:00		2020-12-28 00:00:00		2021-01-15 00:00:00		2021-04-26 00:00:00		2021-04-12 00:00:00		2021-10-27 00:00:00
ls_beg_yr		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2013		2013		2013		2013		2015		2015		2013		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2019		2019		2019		2019		2019		2019		2021		2021		2019		2021		2021		2021
ls_end_yr		2011		2012		2012		2012		2012		2012		2012		2014		2014		2014		2014		2014		2014		2014		2014		2016		2016		2014		2016		2016		2016		2016		2016		2016		2016		2016		2018		2018		2018		2018		2018		2018		2018		2018		2018		2018		2020		2020		2020		2020		2020		2020		2022		2022		2020		2022		2022		2022
qual_date		2011-06-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
eff_date		None		None		None		None		2012-03-15 00:00:00		2012-03-01 00:00:00		None		None		2013-01-01 00:00:00		2013-01-01 00:00:00		None		None		None		2013-08-14 00:00:00		None		None		2015-01-01 00:00:00		None		None		None		None		None		None		None		None		None		2017-01-01 00:00:00		None		None		None		None		None		None		None		2018-09-14 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		ARLINGTON		SANTA MONICA		SACRAMENTO		SACRAMENTO		SANTA MONICA		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SANTA MONICA		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SANTA MONICA		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		VA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		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		22201		90401		95814		95814		90401		95814		95814		95814		95814		95814		95814		95814		90401		95814		95814		95814		95814		95814		95814		95814		95814		95814		90401		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
bus_phon		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(202) 296-8086		(800) 200-2000		(916) 325-8591		(916) 325-8591		(800) 200-2000		916-325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		916-325-8591		(916) 325-8591		(916) 325-8591		(800) 200-2000		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(800) 200-2000		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591		(916) 325-8591
bus_fax		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		None		(310) 496-0948		(916) 443-1856		(916) 443-1856		(310) 496-0948		None		(916) 443-1856		(916) 443-1856		(916) 443-1856		None		(916) 443-1856		(916) 443-1856		(310) 496-0948		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(310) 496-0948		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		None		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856		(916) 443-1856
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
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
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
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
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
sig_date		2011-05-17 00:00:00		2012-03-19 00:00:00		2012-03-02 00:00:00		2012-03-01 00:00:00		2012-03-19 00:00:00		2012-02-27 00:00:00		2012-10-11 00:00:00		2012-12-18 00:00:00		2012-12-18 00:00:00		2013-12-28 00:00:00		2013-08-29 00:00:00		2013-04-19 00:00:00		2013-08-15 00:00:00		2013-08-14 00:00:00		2014-05-14 00:00:00		2014-11-10 00:00:00		2014-11-10 00:00:00		2014-10-27 00:00:00		2015-04-28 00:00:00		2015-01-27 00:00:00		2014-12-29 00:00:00		2016-01-01 00:00:00		2015-10-16 00:00:00		2015-12-01 00:00:00		2015-10-22 00:00:00		2016-03-25 00:00:00		2016-11-10 00:00:00		2016-11-10 00:00:00		2017-01-24 00:00:00		2017-03-20 00:00:00		2018-01-23 00:00:00		2017-09-11 00:00:00		2017-08-04 00:00:00		2017-11-02 00:00:00		2018-09-14 00:00:00		2018-12-12 00:00:00		2018-11-15 00:00:00		2019-11-13 00:00:00		2019-05-21 00:00:00		2020-05-22 00:00:00		2020-10-24 00:00:00		2020-01-28 00:00:00		2020-12-28 00:00:00		2020-12-28 00:00:00		2021-01-15 00:00:00		2021-04-26 00:00:00		2021-04-12 00:00:00		2021-10-27 00:00:00
sig_loc		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		ARLINGTON, VA		SANTA MONICA, CA		SACRAMENTO, CA		SACRAMENTO, CA		SANTA MONICA, CA		Sacramento CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		Sacramento CA		SACRAMENTO, CA		SACRAMENTO, CA		SANTA MONICA, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SANTA MONICA, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACDRAMENTO, 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		JACK IV		JACK IV		JACK IV		JACK IV		MICHAELS		PAINTER		JACK IV		JACK IV		PAINTER		Jack IV		JACK IV		JACK IV		JACK IV		Jack IV		JACK IV		JACK IV		PAINTER		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		GUTHRIE		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV
sig_namf		JAMES C.		JAMES C.		JAMES C.		JAMES C.		TED		SCOTT		JAMES C.		JAMES C.		SCOTT		James		JAMES C.		JAMES C.		JAMES C.		James C.		JAMES C.		JAMES C.		SCOTT		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		MICHAEL		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.
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
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
prn_naml		JACK IV		JACK IV		JACK IV		JACK IV		MICHAELS		PAINTER		JACK IV		JACK IV		PAINTER		None		JACK IV		JACK IV		JACK IV		None		JACK IV		JACK IV		PAINTER		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		GUTHRIE		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV		JACK IV
prn_namf		JAMES C.		JAMES C.		JAMES C.		JAMES C.		TED		SCOTT		JAMES C.		JAMES C.		SCOTT		None		JAMES C.		JAMES C.		JAMES C.		None		JAMES C.		JAMES C.		SCOTT		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		MICHAEL		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.		JAMES C.
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
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
sig_title		OWNER 4525KAH		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		VICE PRESIDENT OF AJW		FOUNDER AND CEO 4525KAU		OWNER 4525KAU		OWNER 4525KAU		FOUNDER AND CEO 4525KAU		Owner		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		Owner		OWNER 4525KAU		OWNER 4525KAU		FOUNDER AND CEO 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		CFO 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 4525KAU		OWNER 402800jh		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER		OWNER
stmt_firm		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		None		None		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		None		None		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		None		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		None		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		None		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		None		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, 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
bus_cb		None		None		None		None		None		X		None		None		X		None		None		None		None		None		None		None		X		None		None		None		None		None		None		None		None		None		X		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
oth_cb		None		None		None		None		X		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		X		None		None		None		None		None		None		None		None		None		None		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
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
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
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
descrip_1		None		None		None		None		MANUFACTURING AND INSTALLATION OF DIESEL RETROFIT DEVICES ON HEAVY DUTY DIESEL VEHICLES		NEW AND USED CAR SALES		None		None		NEW AND USED CAR SALES		None		None		None		None		None		None		None		NEW AND USED CAR SALES		None		None		None		None		None		None		None		None		None		AUTOMOTIVE INFORMATION AND RELATED WEB-BASED AND MOBILE-BASED SERVICES		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		MANUFACTURERS		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
ind_class		None		None		None		None		OTH		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		HEA		None		None		None		None		None		None		None		None		None		None		None		None		None
ind_descr		None		None		None		None		MANUFACTURING		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		TRN		None		None		TRN		None		None		None		None		None		None		None		TRN		None		None		None		None		None		None		None		None		None		TRN		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
auth_name		None		None		None		None		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		None		None		CAPITOL STRATEGIC ADVISORS, LLC		The Crane Group Inc.		None		None		None		The Crane Group Inc.		None		None		CAPITOL STRATEGIC ADVISORS, LLC		None		None		None		None		None		None		None		None		None		CAPITOL STRATEGIC ADVISORS, LLC		None		None		None		None		None		None		None		FRED J. HIESTAND, APC		None		None		None		None		None		None		None		None		None		None		None		None		None
auth_city		None		None		None		None		SACRAMENTO		SACRAMENTO		None		None		SACRAMENTO		McLean		None		None		None		McLean		None		None		SACRAMENTO		None		None		None		None		None		None		None		None		None		SACRAMENTO		None		None		None		None		None		None		None		SACRAMENTO		None		None		None		None		None		None		None		None		None		None		None		None		None
auth_st		None		None		None		None		CA		CA		None		None		CA		VA		None		None		None		VA		None		None		CA		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None
auth_zip4		None		None		None		None		95814		95814		None		None		95814		22102		None		None		None		22102		None		None		95814		None		None		None		None		None		None		None		None		None		95814		None		None		None		None		None		None		None		95817		None		None		None		None		None		None		None		None		None		None		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
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
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
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
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
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
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
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
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
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
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
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

Table: filer_address

filer_id		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224
adrid		2216512		2412340		2544797		2276029		2228648		2341400		2467807		2505136
effect_dt		2011-06-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00		2013-01-01 00:00:00		2012-03-01 00:00:00		2015-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051
session_id		2011		2017		2023		2013		2011		2015		2019		2021

Table: filer_filings

filer_id		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224
filing_id		1772787		1731548		1726161		1764522		1781567		1971040		1918102		1964363		1857580		1868829		1798867		1726161		1790355		1790359		1790348		1726161		1790235		1958352		1918102		1948778		1948849		1909485		1596759		1598140		1598227		1621954		1606257		1636195		1598227		1650082		1649769		1598227		1657182		1668963		1668964		1636195		1653728		1678865		1598227		1816656		1691582		1934626		1918102		1918112		1726161		1916389		1918102		1713110		1598227		1708717		1743455		1742091		1726161		1726169		1731548		1736139		1843609		1726161		1764522		1993699		2000497		2000499		1918102		1918102		1980833		2240565		2116645		2240565		2534076		2116645		2273321		2329176		2438976		2486360		2543868		2185994		2189663		2329176		2293020		2205888		2328444		2194906		2116645		2001191		2008584		2016214		1918102		1918102		1918102		2026697		2035497		2060376		2099944		2116645		2126708		2116645		2116673		2154415		2156511		2142316		2142347		2116645		2174660		2317964		2341115		2468028		2293367		2551418		2329176		2386827		2468028		2530053		2329176		2377595		2116645		2438976		2438976		2180887		2468028		2543868		2474758		2202700		2116645		2207156		2329176		2416659		2344156		2394095		2441792		2329176		2329176		2422221		2543868		2486360		2543868		2595698		2573449		2585615		2653292		2645080		2706631		2603835		2675609		2624136		2717505		2717529		2543868		2628863		2612218		2578441		2578441		2746403
period_id		None		215		215		213		214		None		222		221		None		218		215		215		None		None		None		214		None		None		221		None		None		219		None		None		206		207		206		208		209		None		None		209		209		209		209		208		None		210		209		216		None		220		220		220		220		None		220		None		212		211		None		None		212		212		212		212		217		218		213		223		None		None		224		225		222		233		233		233		None		231		234		244		240		242		244		None		231		245		235		232		None		None		236		None		224		None		224		224		225		None		225		226		227		229		228		228		228		None		229		None		None		229		230		235		None		241		None		244		238		None		241		243		242		237		231		240		240		None		241		246		None		None		232		None		236		239		236		238		None		241		240		None		244		242		246		None		None		None		None		248		250		246		249		247		None		None		248		None		None		245		245		251
form_id		F605		F602		F601		F625		F625		F605		F601		F625		F605		F625		F625		F601		F605		F602		F605		F601		F602		F605		F601		F601		F605		F625		F601		F999		F601		F625		F625		F625		F601		F605		F605		F601		F625		F602		F602		F625		F605		F625		F601		F625		F602		F625		F601		F602		F601		F605		F601		F605		F601		F625		F601		F602		F601		F602		F602		F625		F625		F601		F625		F625		F605		F605		F601		F601		F625		F625		F601		F625		F605		F601		F625		F601		F625		F625		F601		F605		F625		F601		F602		F625		F605		F605		F601		F605		F625		F605		F601		F601		F601		F605		F625		F625		F625		F601		F625		F601		F602		F605		F625		F601		F605		F601		F625		F625		F601		F625		F602		F625		F601		F605		F625		F625		F601		F625		F601		F625		F625		F605		F625		F601		F605		F602		F601		F605		F601		F625		F625		F625		F605		F601		F601		F605		F601		F625		F601		F605		F605		F601		F605		F625		F625		F625		F625		F625		F605		F605		F601		F605		F605		F625		F625		F625
filing_sequence		0		1		3		1		0		0		3		0		0		0		0		2		0		0		0		1		0		0		2		0		0		0		0		0		0		0		0		0		2		0		0		3		0		0		0		1		0		0		1		0		0		0		0		0		5		0		1		0		4		0		0		0		0		0		0		0		0		4		0		0		0		0		6		7		0		1		6		0		0		3		0		5		2		1		0		0		0		6		0		0		0		0		7		0		0		0		5		4		8		0		0		0		0		1		0		0		0		0		0		0		0		2		0		0		0		1		0		0		1		0		2		0		4		0		4		1		0		0		0		2		0		0		5		0		0		0		0		0		0		3		2		0		1		0		3		0		0		0		0		0		0		0		0		0		0		0		4		0		0		0		1		0
filing_date		2013-04-23 00:00:00		2013-08-19 00:00:00		2013-09-04 00:00:00		2013-07-31 00:00:00		2013-07-31 00:00:00		2015-05-08 00:00:00		2015-05-14 00:00:00		2015-04-29 00:00:00		2014-05-15 00:00:00		2014-07-29 00:00:00		2013-10-29 00:00:00		2013-08-21 00:00:00		2013-09-05 00:00:00		2013-08-19 00:00:00		2013-08-21 00:00:00		2013-07-15 00:00:00		2013-08-15 00:00:00		2015-02-02 00:00:00		2015-02-02 00:00:00		2014-12-15 00:00:00		2015-01-08 00:00:00		2014-10-30 00:00:00		2011-06-01 00:00:00		2011-06-27 00:00:00		2011-06-27 00:00:00		2011-10-31 00:00:00		2011-07-29 00:00:00		2012-01-31 00:00:00		2012-03-06 00:00:00		2012-03-01 00:00:00		2012-03-06 00:00:00		2012-04-10 00:00:00		2012-04-30 00:00:00		2012-06-19 00:00:00		2012-06-19 00:00:00		2012-04-13 00:00:00		2012-04-10 00:00:00		2012-07-31 00:00:00		2012-03-01 00:00:00		2014-01-30 00:00:00		2012-09-07 00:00:00		2015-01-30 00:00:00		2014-12-12 00:00:00		2014-12-12 00:00:00		2014-11-05 00:00:00		2014-11-04 00:00:00		2015-01-08 00:00:00		2012-10-24 00:00:00		2012-10-24 00:00:00		2012-10-31 00:00:00		2013-01-15 00:00:00		2012-12-31 00:00:00		2013-01-15 00:00:00		2013-01-15 00:00:00		2013-01-24 00:00:00		2013-01-30 00:00:00		2014-04-29 00:00:00		2014-05-15 00:00:00		2013-04-30 00:00:00		2015-10-23 00:00:00		2015-10-21 00:00:00		2015-10-22 00:00:00		2015-12-08 00:00:00		2016-01-11 00:00:00		2015-07-30 00:00:00		2018-07-30 00:00:00		2018-01-26 00:00:00		2018-04-30 00:00:00		2020-11-03 00:00:00		2017-08-15 00:00:00		2018-07-30 00:00:00		2020-11-03 00:00:00		2020-11-02 00:00:00		2020-11-02 00:00:00		2021-01-13 00:00:00		2017-09-29 00:00:00		2017-10-23 00:00:00		2021-02-02 00:00:00		2018-09-18 00:00:00		2018-01-26 00:00:00		2018-12-13 00:00:00		2017-11-02 00:00:00		2018-12-13 00:00:00		2015-12-08 00:00:00		2016-01-28 00:00:00		2016-01-11 00:00:00		2015-10-22 00:00:00		2015-10-21 00:00:00		2016-03-31 00:00:00		2016-04-01 00:00:00		2016-04-29 00:00:00		2016-07-28 00:00:00		2016-10-29 00:00:00		2017-01-25 00:00:00		2017-01-30 00:00:00		2017-01-03 00:00:00		2017-01-03 00:00:00		2017-03-20 00:00:00		2017-04-29 00:00:00		2017-01-03 00:00:00		2017-01-25 00:00:00		2017-03-20 00:00:00		2017-07-30 00:00:00		2018-10-30 00:00:00		2018-12-21 00:00:00		2020-04-30 00:00:00		2018-09-18 00:00:00		2021-01-29 00:00:00		2019-05-21 00:00:00		2019-05-21 00:00:00		2020-11-02 00:00:00		2020-11-02 00:00:00		2020-06-03 00:00:00		2019-04-25 00:00:00		2017-09-29 00:00:00		2020-02-05 00:00:00		2020-01-29 00:00:00		2017-08-16 00:00:00		2020-04-28 00:00:00		2021-04-19 00:00:00		2020-06-04 00:00:00		2018-01-16 00:00:00		2017-11-02 00:00:00		2018-01-26 00:00:00		2018-12-21 00:00:00		2019-10-28 00:00:00		2019-01-29 00:00:00		2019-07-26 00:00:00		2020-01-30 00:00:00		2020-02-14 00:00:00		2019-11-14 00:00:00		2019-11-14 00:00:00		2021-02-10 00:00:00		2020-07-31 00:00:00		2021-04-28 00:00:00		2021-02-11 00:00:00		2021-02-03 00:00:00		2021-01-13 00:00:00		2021-04-29 00:00:00		2022-01-31 00:00:00		2022-08-01 00:00:00		2021-08-02 00:00:00		2022-05-01 00:00:00		2021-11-01 00:00:00		2022-08-30 00:00:00		2022-08-30 00:00:00		2021-11-08 00:00:00		2021-11-08 00:00:00		2021-04-19 00:00:00		2021-04-28 00:00:00		2021-08-02 00:00:00		2022-10-29 00:00:00
stmnt_type		10006		10002		10002		10002		10001		10006		10002		10001		10006		10001		10001		10002		10006		10005		10006		10002		10005		10005		10002		10005		10005		10001		10005		10005		10001		10001		10001		10001		10002		10005		10006		10002		10001		10001		10001		10002		10006		10001		10002		10001		10005		10001		10001		10001		10002		10006		10002		10006		10002		10001		10005		10005		10001		10001		10001		10001		10001		10002		10001		10001		10006		10006		10002		10002		10001		10002		10002		10001		10005		10002		10001		10002		10002		10002		10001		10005		10001		10002		10001		10001		10005		10005		10002		10006		10001		10006		10002		10002		10002		10006		10001		10001		10001		10002		10001		10001		10001		10005		10001		10005		10006		10002		10001		10001		10001		10002		10005		10001		10002		10005		10002		10001		10002		10001		10002		10002		10001		10005		10001		10002		10005		10005		10002		10005		10001		10001		10001		10001		10005		10002		10002		10002		10002		10001		10002		10002		10005		10005		10002		10001		10001		10001		10001		10001		10002		10005		10002		10002		10002		10001		10002		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		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		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003
session_id		2013		2013		2013		2013		2013		2015		2015		2015		2013		2013		2013		2013		2013		2013		2013		2013		2013		2015		2015		2015		2015		2013		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2011		2013		2015		2015		2013		2013		2015		2011		2011		2011		2013		2013		2013		2013		2013		2011		2013		2013		2013		2015		2015		2015		2015		2015		2015		2017		2017		2017		2019		2017		2017		2019		2019		2019		2021		2017		2017		2019		2017		2017		2017		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2015		2017		2017		2017		2017		2017		2017		2017		2017		2017		2019		2019		2017		2019		2019		2019		2019		2019		2019		2019		2017		2019		2019		2017		2019		2021		2019		2017		2017		2017		2019		2019		2017		2019		2019		2019		2019		2019		2021		2019		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		YRODRIGU		YRODRIGU		YRODRIGU		ASAETERN		ASAETERN		YRODRIGU		YRODRIGU		AGLADNEY		YRODRIGU		ASAETERN		ASAETERN		PBANFORD		PBANFORD		GPEREZ		PBANFORD		YRODRIGU		ASAETERN		SARRIAGA		YRODRIGU		GPEREZ		GPEREZ		ASAETERN		ASAETERN		ASAETERN		YRODRIGU		ASAETERN		ASAETERN		ASAETERN		YRODRIGU		SARRIAGA		CFLAGG		YRODRIGU		ASAETERN		YRODRIGU		YRODRIGU		ASAETERN		YRODRIGU		AGLADNEY		YRODRIGU		ASAETERN		YRODRIGU		AGLADNEY		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		ASAETERN		GPEREZ		GPEREZ		YRODRIGU		YRODRIGU		YRODRIGU		ASAETERN		ASAETERN		YRODRIGU		ASAETERN		AGLADNEY		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		AGLADNEY		AGLADNEY		GPEREZ		AGLADNEY		GPEREZ		GPEREZ		AGLADNEY		GPEREZ		CAFILER		CAFILER		MKIRKHAM		GPEREZ		AGLADNEY		MMERCHANT		GPEREZ		AGLADNEY		GPEREZ		GPEREZ		GPEREZ		YRODRIGU		AGLADNEY		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		AGLADNEY		YRODRIGU		GPEREZ		SARRIAGA		AGLADNEY		YRODRIGU		YRODRIGU		SARRIAGA		AGLADNEY		AGLADNEY		YRODRIGU		CAFILER		GPEREZ		CHARTRIDGE		SARRIAGA		SARRIAGA		CAFILER		CHARTRIDGE		SARRIAGA		AGLADNEY		GPEREZ		AGLADNEY		AGLADNEY		GPEREZ		MKIRKHAM		MKIRKHAM		SARRIAGA		YRODRIGU		GPEREZ		GPEREZ		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		GPEREZ		CAFILER		AROJAS		AROJAS		MMERCHANT		MKIRKHAM		MKIRKHAM		MMERCHANT		CVANLIEW		MKIRKHAM		MKIRKHAM		MKIRKHAM		CAFILER		CHATRIDGE		CAFILER		CHATRIDGE		CVANLIEW		CVANLIEW		MKIRKHAM		MKIRKHAM		MKIRKHAM		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
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11003		11003		11001		11003		11003		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		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		11003		11003		11003		11001		11003		11003		11003		11001		11003		11001		11003		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11001		11003		11001		11003		11003		11003		11003		11003		11001		11001		11003
rpt_start		1900-01-01 00:00:00		2013-08-14 00:00:00		2013-08-29 00:00:00		2013-01-01 00:00:00		2013-04-01 00:00:00		1900-01-01 00:00:00		2015-04-28 00:00:00		2015-01-01 00:00:00		1900-01-01 00:00:00		2014-04-01 00:00:00		2013-07-01 00:00:00		2013-08-15 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-04-19 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-01-27 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2011-06-01 00:00:00		2011-07-01 00:00:00		2011-04-01 00:00:00		2011-10-01 00:00:00		2012-03-02 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-03-19 00:00:00		2012-01-01 00:00:00		2012-02-27 00:00:00		2012-03-27 00:00:00		2011-10-01 00:00:00		1900-01-01 00:00:00		2012-04-01 00:00:00		2012-03-01 00:00:00		2013-10-01 00:00:00		1900-01-01 00:00:00		2014-10-01 00:00:00		2014-11-10 00:00:00		2014-11-10 00:00:00		2014-10-27 00:00:00		1900-01-01 00:00:00		2014-12-29 00:00:00		1900-01-01 00:00:00		2012-10-11 00:00:00		2012-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-12-18 00:00:00		2012-12-18 00:00:00		2012-12-28 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		2014-05-14 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-12-01 00:00:00		2016-01-01 00:00:00		2015-04-01 00:00:00		2018-01-01 00:00:00		2018-01-02 00:00:00		2018-01-01 00:00:00		1900-01-01 00:00:00		2017-08-04 00:00:00		2018-04-01 00:00:00		2020-10-24 00:00:00		2019-10-01 00:00:00		2020-04-01 00:00:00		2020-12-28 00:00:00		1900-01-01 00:00:00		2017-07-01 00:00:00		2021-01-15 00:00:00		2018-09-14 00:00:00		2017-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-12-12 00:00:00		1900-01-01 00:00:00		2015-10-01 00:00:00		1900-01-01 00:00:00		2015-10-22 00:00:00		2015-10-16 00:00:00		2016-03-25 00:00:00		1900-01-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2017-01-24 00:00:00		2016-10-01 00:00:00		2016-11-10 00:00:00		2016-11-10 00:00:00		1900-01-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-03-20 00:00:00		2017-04-01 00:00:00		2018-07-01 00:00:00		1900-01-01 00:00:00		2020-01-01 00:00:00		1900-01-01 00:00:00		2020-10-01 00:00:00		2019-05-21 00:00:00		1900-01-01 00:00:00		2020-01-01 00:00:00		2020-07-01 00:00:00		2020-05-22 00:00:00		2019-01-01 00:00:00		2017-09-12 00:00:00		2019-10-01 00:00:00		2019-10-01 00:00:00		1900-01-01 00:00:00		2020-01-01 00:00:00		2021-04-12 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-11-02 00:00:00		1900-01-01 00:00:00		2018-11-15 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		2020-01-28 00:00:00		2019-11-13 00:00:00		1900-01-01 00:00:00		2020-12-28 00:00:00		2020-04-01 00:00:00		2021-04-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		2021-10-01 00:00:00		2022-04-01 00:00:00		2021-04-01 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-10-27 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2022-07-01 00:00:00
rpt_end		1900-01-01 00:00:00		2013-08-14 00:00:00		2013-08-29 00:00:00		2013-03-31 00:00:00		2013-06-30 00:00:00		1900-01-01 00:00:00		2015-04-28 00:00:00		2015-03-31 00:00:00		1900-01-01 00:00:00		2014-06-30 00:00:00		2013-09-30 00:00:00		2013-08-15 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-04-19 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-01-27 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2011-06-01 00:00:00		2011-09-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2012-03-02 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-03-19 00:00:00		2012-03-31 00:00:00		2012-02-27 00:00:00		2012-03-27 00:00:00		2011-12-31 00:00:00		1900-01-01 00:00:00		2012-06-30 00:00:00		2012-03-01 00:00:00		2013-12-31 00:00:00		1900-01-01 00:00:00		2014-12-31 00:00:00		2014-11-10 00:00:00		2014-11-10 00:00:00		2014-10-27 00:00:00		1900-01-01 00:00:00		2014-12-29 00:00:00		1900-01-01 00:00:00		2012-10-11 00:00:00		2012-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-12-18 00:00:00		2012-12-18 00:00:00		2012-12-28 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		2014-05-14 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-12-01 00:00:00		2016-01-01 00:00:00		2015-06-30 00:00:00		2018-03-31 00:00:00		2018-01-02 00:00:00		2018-03-31 00:00:00		1900-01-01 00:00:00		2017-08-04 00:00:00		2018-06-30 00:00:00		2020-10-24 00:00:00		2019-12-31 00:00:00		2020-06-30 00:00:00		2020-12-28 00:00:00		1900-01-01 00:00:00		2017-09-30 00:00:00		2021-01-15 00:00:00		2018-09-14 00:00:00		2017-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-12-12 00:00:00		1900-01-01 00:00:00		2015-12-31 00:00:00		1900-01-01 00:00:00		2015-10-22 00:00:00		2015-10-16 00:00:00		2016-03-25 00:00:00		1900-01-01 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2017-01-24 00:00:00		2016-12-31 00:00:00		2016-11-10 00:00:00		2016-11-10 00:00:00		1900-01-01 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-03-20 00:00:00		2017-06-30 00:00:00		2018-09-30 00:00:00		1900-01-01 00:00:00		2020-03-31 00:00:00		1900-01-01 00:00:00		2020-12-31 00:00:00		2019-05-21 00:00:00		1900-01-01 00:00:00		2020-03-31 00:00:00		2020-09-30 00:00:00		2020-05-22 00:00:00		2019-03-31 00:00:00		2017-09-12 00:00:00		2019-12-31 00:00:00		2019-12-31 00:00:00		1900-01-01 00:00:00		2020-03-31 00:00:00		2021-04-12 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-11-02 00:00:00		1900-01-01 00:00:00		2018-11-15 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		2020-01-28 00:00:00		2019-11-13 00:00:00		1900-01-01 00:00:00		2020-12-28 00:00:00		2020-06-30 00:00:00		2021-04-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		2021-12-31 00:00:00		2022-06-30 00:00:00		2021-06-30 00:00:00		2022-03-31 00:00:00		2021-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-10-27 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-03-31 00:00:00		2021-03-31 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		22001		22001		22001		22001		None		22001		22001		None		22001		22001		22001		None		None		None		22001		None		None		22001		None		None		22001		None		None		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		None		22001		None		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		None		22001		None		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		None		None		22001		22001		22001		None		22001		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		None		None		22001		None		22001		22001		22001		22001		None		22001		22001		None		22001		22001		22001		None		None		None		None		22001		22001		22001		22001		22001		None		None		22001		None		None		22001		22001		22001

Table: filer_to_filer_type

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

Table: filer_xref

filer_id		1339224
xref_id		1339224
effect_dt		2011-06-14 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224
filer_id		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224
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		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		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00
naml		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, 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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
phon		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591		9163258591
fax		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856		9164431856
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

Table: filers

filer_id		1339224

Table: lobbying_chg_log

filer_id		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224
change_no		1		2		3		4		5		6		7		0		8		9		10		11		12		13		14		16		17		15		18		21		19		20		22		23		24		25		26		27		28		29		30
session_id		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2019		2021		2021		2021		2021		2021
log_dt		2011-06-01 00:00:00		2011-06-01 00:00:00		2011-06-01 00:00:00		2011-06-01 00:00:00		2011-06-01 00:00:00		2011-06-01 00:00:00		2011-06-01 00:00:00		2011-06-01 00:00:00		2012-04-10 00:00:00		2012-10-24 00:00:00		2013-04-23 00:00:00		2013-08-21 00:00:00		2014-05-01 00:00:00		2014-11-04 00:00:00		2015-02-02 00:00:00		2015-12-08 00:00:00		2015-12-08 00:00:00		2015-05-08 00:00:00		2016-01-11 00:00:00		2017-11-02 00:00:00		2017-03-20 00:00:00		2017-09-29 00:00:00		2018-01-26 00:00:00		2018-01-26 00:00:00		2018-12-13 00:00:00		2020-11-03 00:00:00		2021-02-11 00:00:00		2021-02-11 00:00:00		2021-02-11 00:00:00		2021-04-19 00:00:00		2021-04-19 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
correction_flg		None		None		None		None		None		None		None		None		None		None		Y		Y		None		None		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		None		None		None		None		None		None		None
action		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		DELETED		ADDED		ADDED		DELETED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		DELETED		DELETED		ADDED		DELETED		DELETED		DELETED		DELETED		ADDED		ADDED		ADDED		ADDED		ADDED
attribute_changed		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT/FIRM		CLIENT		CLIENT		EMPLOYER		/ FIRM		FIRM		CLIENT		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		LOBBYIST		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		LOBBYIST		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		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
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
filer_full_name		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC		CAPITOL STRATEGIC ADVISORS, LLC
filer_city		None		None		None		None		None		None		None		None		None		None		SACRAMENTO		SACRAMENTO		None		None		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		None		SACRAMENTO		SACRAMENTO		None		None		None		None		None		None		None		None		None
filer_st		None		None		None		None		None		None		None		None		None		None		CA		CA		None		None		CA		CA		CA		CA		CA		None		CA		CA		None		None		None		None		None		None		None		None		None
filer_zip		None		None		None		None		None		None		None		None		None		None		95814		95814		None		None		95814		95814		95814		95814		95814		None		95814		95814		None		None		None		None		None		None		None		None		None
filer_phone		None		None		None		None		None		None		None		None		None		None		9163258591		9163258591		None		None		9163258591		9163258591		9163258591		9163258591		9163258591		None		9163258591		9163258591		None		None		None		None		None		None		None		None		None
entity_type		1		1		1		1		1		1		1		3		1		1		2		1		3		1		2		2		2		2		4		2		2		2		2		2		4		1		1		1		1		1		1
entity_name		22ND DISTRICT AGRICULTURAL DISTRICT		CALIFORNIA ASSOCIATION OF COMPETITIVE TELECOMMUNICATIONS COMPANIES (CALTEL)		CIGAR ASSOCIATION OF AMERICA		EMISSIONS CONTROL TECHNOLOGY ASSOCIATION		GTECH CORPORATION		RETAIL INDUSTRY LEADERS ASSOCIATION		SYCUAN BAND OF THE KUMEYAAY NATION		CALIFORNIA STRATEGIES & ADVOCACY, LLC		DIESEL RETROFIT COALITION		EMISSIONS CONTROL TECHNOLOGY ASSOCIATION		SANTA YNEZ BAND OF CHUMASH INDIANS		MC GANN, INC.; TERRY M.		CRANE GROUP INC; THE		CONTINENTAL CORPORATION		LIBERTY TIRE RECYCLING		FUTURE INCOME PAYMENTS		AMERICAN ADDICTION CENTERS, INC.		CIGNA COMPANIES		BAROWITZ, KITTY		FIP, LLC		22ND DISTRICT AGRICULTURAL DISTRICT		JUUL LABS		RETAIL INDUSTRY LEADERS ASSOCIATION (RILA)		TRUECAR, INC.		KITTY BAROWITZ		LIL' DRUG STORE PRODUCTS, INC.		LKQ CORPORATION		NATIONAL VISION, INC., FIRSTSIGHT VISION SERVICES, INC. & AFFILIATES		SANTA YNEZ BAND OF CHUMASH INDIANS		RENAISSANCE LEARNING, INC.		COALITION OF IGNITION INTERLOCK MANUFACTURERS
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
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
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
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
entity_id		1238788		1146055		1145763		1324181		1143344		1337586		1144053		1273600		1346470		1324181		None		None		1340042		1373758		None		None		None		None		None		1381584		None		None		1337586		1346471		1382999		1418742		1318418		1243421		1144260		1437900		1375435
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
effect_dt		2011-06-01 00:00:00		2011-06-01 00:00:00		2011-06-01 00:00:00		2011-06-01 00:00:00		2011-06-01 00:00:00		2011-06-01 00:00:00		2011-06-01 00:00:00		2011-06-01 00:00:00		2012-03-15 00:00:00		2012-06-30 00:00:00		2013-04-22 00:00:00		2013-08-15 00:00:00		2014-03-31 00:00:00		2014-11-01 00:00:00		2015-01-27 00:00:00		2015-12-01 00:00:00		2015-12-01 00:00:00		2015-04-27 00:00:00		2016-01-01 00:00:00		2017-10-31 00:00:00		2017-03-20 00:00:00		2017-09-16 00:00:00		2018-01-31 00:00:00		2018-01-31 00:00:00		2018-12-14 00:00:00		2020-05-15 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-03-01 00:00:00		2021-01-01 00:00:00

Table: received_filings

filer_id		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224		1339224
filing_file_name		1726161_0.cal		39709.cal		82709.cal		1726161_3.cal		39636.cal		53403.cal		1726161_2.cal		1598227_4.cal		1598227_0.cal		1726161_1.cal		1598227_3.cal		1598227_1.cal		436877.cal		1598227_2.cal		1918102_3.cal		2116645_1.cal		2116645_2.cal		1918102_5.cal		407204.cal		1918102_4.cal		1661.cal		1918102_6.cal		469940.cal		2116645_0.cal		1918102_8.cal		1918102_1.cal		1918102_0.cal		25975.cal		1726161_5.cal		439347.cal		1918102_2.cal		2116645_6.cal		150090.cal		2116645_3.cal		2329176_3.cal		333757.cal		2116645_7.cal		2329176_2.cal		2116645_4.cal		433883.cal		2116645_5.cal		2329176_0.cal		2329176_1.cal		2329176_4.cal		2329176_5.cal		2543868_2.cal		2329176_6.cal		2543868_1.cal		348861.cal		2543868_3.cal		2543868_0.cal		2543868_4.cal
received_date		2013-01-15 00:00:00		2013-08-15 00:00:00		2013-08-19 00:00:00		2013-09-04 00:00:00		2013-08-15 00:00:00		2013-08-16 00:00:00		2013-08-21 00:00:00		2012-10-24 00:00:00		2011-06-27 00:00:00		2013-07-15 00:00:00		2012-04-10 00:00:00		2012-03-01 00:00:00		2012-03-01 00:00:00		2012-03-06 00:00:00		2015-05-14 00:00:00		2017-01-25 00:00:00		2017-03-20 00:00:00		2015-10-22 00:00:00		2016-01-29 00:00:00		2015-10-21 00:00:00		2016-01-11 00:00:00		2015-12-08 00:00:00		2015-12-08 00:00:00		2017-01-03 00:00:00		2016-03-31 00:00:00		2015-01-08 00:00:00		2014-12-12 00:00:00		2014-12-12 00:00:00		2014-11-05 00:00:00		2014-11-05 00:00:00		2015-02-02 00:00:00		2018-01-26 00:00:00		2018-07-30 00:00:00		2017-08-15 00:00:00		2020-02-14 00:00:00		2018-09-18 00:00:00		2018-12-13 00:00:00		2019-11-14 00:00:00		2017-09-29 00:00:00		2018-01-26 00:00:00		2017-11-02 00:00:00		2018-12-21 00:00:00		2019-05-21 00:00:00		2020-06-03 00:00:00		2020-11-03 00:00:00		2021-04-19 00:00:00		2021-02-02 00:00:00		2021-02-10 00:00:00		2021-04-19 00:00:00		2021-04-28 00:00:00		2021-01-13 00:00:00		2021-11-08 00:00:00
filing_directory		/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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/temp		/cafiler/disclose/ca99/cal		/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		1726161		None		None		1726161		None		None		1726161		1598227		1598227		1726161		1598227		1598227		None		1598227		1918102		2116645		2116645		1918102		None		1918102		None		1918102		None		2116645		1918102		1918102		1918102		None		1726161		None		1918102		2116645		None		2116645		2329176		None		2116645		2329176		2116645		None		2116645		2329176		2329176		2329176		2329176		2543868		2329176		2543868		None		2543868		2543868		2543868
form_id		F601		None		None		F601		None		None		F601		F601		F601		F601		F601		F601		None		F601		F601		F601		F601		F601		None		F601		None		F601		None		F601		F601		F601		F601		None		F601		None		F601		F601		None		F601		F601		None		F601		F601		F601		None		F601		F601		F601		F601		F601		F601		F601		F601		None		F601		F601		F601
receive_comment		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 accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing did not pass validation		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		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 accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted