Home

Filer ID: 1304591

Table: cvr_lobby_disclosure

filing_id		1346527		1328078		1417476		1448119		1375601		1391649		1430735		1458797		1527673		1500098		1480684		1559900		1618324		1586524		1601296		1628663		1698814		1731834		1672184		1653150		1795495		1776476		1756499		1811251		1900116		1864287		1929253		1839528		1992550		1973818		1959179		2004258		2089516		2055211		2028496		2167292		2151317		2120718		2120718		2187791		2267220		2202913		2233625		2306378		2336461		2391395		2372522		2465901		2431599		2413603		2544711		2478650		2509791		2574180		2637850		2614991		2593140		2671311		2733261		2698442
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
sender_id		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591
filer_id		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591
entity_cd		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM
filer_naml		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC
filer_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
report_num		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2008-07-26 00:00:00		2008-04-26 00:00:00		2009-04-15 00:00:00		2009-10-16 00:00:00		2008-10-24 00:00:00		2009-01-25 00:00:00		2009-07-14 00:00:00		2010-01-20 00:00:00		2010-10-15 00:00:00		2010-07-12 00:00:00		2010-04-19 00:00:00		2011-01-13 00:00:00		2011-10-19 00:00:00		2011-04-15 00:00:00		2011-07-19 00:00:00		2012-01-16 00:00:00		2012-10-16 00:00:00		2013-01-24 00:00:00		2012-07-17 00:00:00		2012-04-20 00:00:00		2013-10-18 00:00:00		2013-07-18 00:00:00		2013-04-15 00:00:00		2014-01-19 00:00:00		2014-10-17 00:00:00		2014-07-18 00:00:00		2015-01-23 00:00:00		2014-04-18 00:00:00		2015-10-19 00:00:00		2015-07-12 00:00:00		2015-04-18 00:00:00		2016-01-15 00:00:00		2016-10-16 00:00:00		2016-07-14 00:00:00		2016-04-14 00:00:00		2017-07-13 00:00:00		2017-04-16 00:00:00		2017-01-18 00:00:00		2017-01-18 00:00:00		2017-10-14 00:00:00		2018-07-20 00:00:00		2018-01-18 00:00:00		2018-04-21 00:00:00		2018-10-13 00:00:00		2019-01-18 00:00:00		2019-07-19 00:00:00		2019-04-14 00:00:00		2020-04-16 00:00:00		2020-01-17 00:00:00		2019-10-17 00:00:00		2021-01-16 00:00:00		2020-07-15 00:00:00		2020-10-05 00:00:00		2021-04-14 00:00:00		2022-01-25 00:00:00		2021-10-09 00:00:00		2021-07-14 00:00:00		2022-04-27 00:00:00		2022-10-14 00:00:00		2022-07-15 00:00:00
from_date		2008-04-01 00:00:00		2008-01-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2009-04-01 00:00:00		2009-10-01 00:00:00		2010-07-01 00:00:00		2010-04-01 00:00:00		2010-01-01 00:00:00		2010-10-01 00:00:00		2011-07-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-10-01 00:00:00		2012-07-01 00:00:00		2012-10-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2013-10-01 00:00:00		2014-07-01 00:00:00		2014-04-01 00:00:00		2014-10-01 00:00:00		2014-01-01 00:00:00		2015-07-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2015-10-01 00:00:00		2016-07-01 00:00:00		2016-04-01 00:00:00		2016-01-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2016-10-01 00:00:00		2016-10-01 00:00:00		2017-07-01 00:00:00		2018-04-01 00:00:00		2017-10-01 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2018-10-01 00:00:00		2019-04-01 00:00:00		2019-01-01 00:00:00		2020-01-01 00:00:00		2019-10-01 00:00:00		2019-07-01 00:00:00		2020-10-01 00:00:00		2020-04-01 00:00:00		2020-07-01 00:00:00		2021-01-01 00:00:00		2021-10-01 00:00:00		2021-07-01 00:00:00		2021-04-01 00:00:00		2022-01-01 00:00:00		2022-07-01 00:00:00		2022-04-01 00:00:00
thru_date		2008-06-30 00:00:00		2008-03-31 00:00:00		2009-03-31 00:00:00		2009-09-30 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2010-09-30 00:00:00		2010-06-30 00:00:00		2010-03-31 00:00:00		2010-12-31 00:00:00		2011-09-30 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2012-09-30 00:00:00		2012-12-31 00:00:00		2012-06-30 00:00:00		2012-03-31 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2013-12-31 00:00:00		2014-09-30 00:00:00		2014-06-30 00:00:00		2014-12-31 00:00:00		2014-03-31 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2015-12-31 00:00:00		2016-09-30 00:00:00		2016-06-30 00:00:00		2016-03-31 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-09-30 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2018-03-31 00:00:00		2018-09-30 00:00:00		2018-12-31 00:00:00		2019-06-30 00:00:00		2019-03-31 00:00:00		2020-03-31 00:00:00		2019-12-31 00:00:00		2019-09-30 00:00:00		2020-12-31 00:00:00		2020-06-30 00:00:00		2020-09-30 00:00:00		2021-03-31 00:00:00		2021-12-31 00:00:00		2021-09-30 00:00:00		2021-06-30 00:00:00		2022-03-31 00:00:00		2022-09-30 00:00:00		2022-06-30 00:00:00
cum_beg_dt		2007-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-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		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		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		2015-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		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
firm_id		1304591		1304591		1304591		None		1304591		1304591		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		APPRISS		APPRISS		APPRISS		None		APPRISS		APPRISS		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_city		Louisville		Louisville		Louisville		LOUISVILLE		Louisville		Louisville		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE
firm_st		KY		KY		KY		KN		KY		KY		KN		KN		KY		KN		KN		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY
firm_zip4		40223		40223		40223		402233842		40223		40223		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		40223		40223		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		402233842		40223		40223		40223
firm_phon		502-815-3907		502-815-3907		502-815-3907		5028153907		502-815-3907		502-815-3907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028153907		5028155744		5028155744		5028155744		5028155744		5028153907		5028153907		5028155744		5028153805		5028153805		5028153907		5028153907		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805
mail_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_date		2008-07-26 00:00:00		2008-04-28 00:00:00		2009-04-15 00:00:00		2009-10-16 00:00:00		2008-10-24 00:00:00		2009-01-26 00:00:00		2009-07-15 00:00:00		2010-01-20 00:00:00		2010-10-15 00:00:00		2010-07-12 00:00:00		2010-04-19 00:00:00		2011-01-13 00:00:00		2011-10-19 00:00:00		2011-04-15 00:00:00		2011-07-19 00:00:00		2012-01-16 00:00:00		2012-10-16 00:00:00		2013-01-25 00:00:00		2012-07-20 00:00:00		2012-04-20 00:00:00		2013-10-18 00:00:00		2013-07-18 00:00:00		2013-04-15 00:00:00		2014-01-19 00:00:00		2014-10-17 00:00:00		2014-07-18 00:00:00		2015-01-23 00:00:00		2014-04-18 00:00:00		2015-10-19 00:00:00		2015-07-12 00:00:00		2015-04-18 00:00:00		2016-01-15 00:00:00		2016-10-16 00:00:00		2016-07-14 00:00:00		2016-04-14 00:00:00		2017-07-13 00:00:00		2017-04-16 00:00:00		2017-01-18 00:00:00		2017-01-18 00:00:00		2017-10-14 00:00:00		2018-07-20 00:00:00		2018-01-19 00:00:00		2018-04-21 00:00:00		2018-10-13 00:00:00		2019-01-18 00:00:00		2019-07-19 00:00:00		2019-04-14 00:00:00		2020-04-16 00:00:00		2020-01-17 00:00:00		2019-10-17 00:00:00		2021-01-16 00:00:00		2020-07-15 00:00:00		2020-10-16 00:00:00		2021-04-14 00:00:00		2022-01-25 00:00:00		2021-10-09 00:00:00		2021-07-14 00:00:00		2022-04-27 00:00:00		2022-10-14 00:00:00		2022-07-15 00:00:00
sig_loc		LOUISVILLE, KY		LOUISVILLE, KN		LOUISVILLE, KY		Louisville, KY		LOUISVILLE, KY		LOUISVILLE, KY		Louisville, KY		LOUISVILLE, KN		LOUISVILLE, KY		LOUISVILLE, KY		LOUISVILLE, KN		LOUISVILLE, KY		Louisville, KY		LOUISVILLE, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, Ky		Louisville, Ky		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Lousiville, KY		Lousiville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY		Louisville, KY
sig_naml		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Acquisto		Acquisto		Acquisto		Acquisto		Acquisto		Acquisto		Acquisto		Acquisto		Acquisto		Seigle		Seigle		Seigle		Bruner		Bruner		Seigle		Bruner		Bruner		Brunner		Bruner		Bruner		Bruner		Bruner		Brunner		Bruner		Bruner		Bruner		Bruner		Matthews		Bruner		Bruner		Matthews		Matthews		Matthews		Matthews		Matthews		Matthews		Matthews
sig_namf		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas R.		Thomas		Thomas		Thomas R.		Thomas R.		Thomas R.		James		James		James		James		James		James		James		James		James		Thomas R.		Thomas R.		Thomas R.		Joshua P.		Joshua P.		Thomas R.		Joshua P.		Joshua P.		Joshua P.		Joshua P.		Joshua P.		Joshua P.		Joshua P.		Johsua P.		Joshua P.		Joshua P.		Joshua P.		Joshua P.		Brian		Joshua P.		Joshua P.		Brian		Brian		Brian		Brian		Brian		Brian		Brian
sig_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
prn_naml		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Siegle		Acquisto		Acquisto		Acquisto		Acquisto		Acquisto		Acquisto		Acquisto		Acquisto		Acquisto		Seigle		Seigle		Seigle		Bruner		Bruner		Seigle		Bruner		Bruner		Brunner		Bruner		Bruner		Bruner		Bruner		Brunner		Bruner		Bruner		Bruner		Bruner		Matthews		Bruner		Bruner		Matthews		Matthews		Matthews		Matthews		Matthews		Matthews		Matthews
prn_namf		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas		Thomas R.		Thomas		Thomas		Thomas R.		Thomas R.		Thomas R.		James		James		James		James		James		James		James		James		James		Thomas R.		Thomas R.		Thomas R.		Joshua P.		Joshua P.		Thomas R.		Joshua P.		Joshua P.		Joshua P.		Joshua P.		Joshua P.		Joshua P.		Joshua P.		Johsua P.		Joshua P.		Joshua P.		Joshua P.		Joshua P.		Brian		Joshua P.		Joshua P.		Brian		Brian		Brian		Brian		Brian		Brian		Brian
prn_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_title		Vice President		Vice President		Executive Vice President		Executive Vice President		Executive Vice President		Executive Vice President		Executive Vice President		Executive Vice President		Executive Vice President		Executive Vice President		Executive Vice President		President, Public Safety Services		President, Public Safety Services		President, Public Safety Services		President, Public Safety Services		President, Public Safety Services		President Public Safety Services		President, Public Safety Services		President, Public Safety Services		President, Public Safety Services		President, Public Safety Services		President, Public Safety Services		President, Public Safety Services		VP, Government Affairs Services		VP, Government Affairs		VP, Government Affairs		VP, Government Affairs		VP, Government Affairs		VP Government Affairs		VP, Government Affairs		VP Government Affairs		VP Government Affairs		Executive Vice President		Executive Vice President		Executive Vice President		President		President		Executive Vice President		President		President		President		President		President		President		President		President		President		Executive Vice President		Executive Vice President		Executive Vice President		President		Executive Vice President		Executive Vice President		President		SVP & GM, Appriss Insights LLC		President		President		SVP & GM, Appriss Insights LLC		SVP & GM, Appriss Insights		SVP & GM, Appriss Insights
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		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		None		None		None		None		None
part1_1_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
part1_2_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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		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		None		None		None		None		None
lby_actvty		NONE		NONE		NONE		NONE		Budget issues		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		Budget		Budget		NONE		Budget		NONE		NONE		NONE		NONE		VINE & SB 506.		SB 506 & Victim Information and Notification Everyday (VINE).		SB 506 & Victim Information and Notification Everyday (VINE).		SB 506 & Victim Information and Notification Everyday (VINE).		SB 506 & Victim's Information (VINE).		Victim Information and Notification Everyday (VINE).		NONE		NONE		Victim Information and Notification Everyday (VINE).		Victim Information and Notification Everyday (VINE).		Victim Information and Notification Everyday (VINE).		Victim Information and Notification Everyday (VINE).		Victim Information and Notification Everyday (VINE) at CDCR & Cal EOS.		Victim Information and Notification Everyday (VINE) at CDCR & Cal EOS .		Victim Information and Notification Everyday (VINE).		Victim Information and Notification Everyday (VINE).		AB 1120 & Victim Information and Notification Everyday (VINE) at CDCR & Cal EOS.		NONE		AB 40, & AB 1120 & Victim Information and Notification Everyday (VINE) at CDCR & Cal EOS.		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE
lobby_n_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lobby_y_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpcmte_nm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpcmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: cvr_registration

filing_id		1386101
amend_id		0
rec_type		CVR
form_type		F602
sender_id		F24865
filer_id		1304591
entity_cd		LEM
filer_naml		APPRISS
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2008-12-24 00:00:00
ls_beg_yr		2009
ls_end_yr		2010
qual_date		None
eff_date		2009-01-01 00:00:00
bus_city		Louisville
bus_st		KY
bus_zip4		40223
bus_phon		502-815-3907
bus_fax		502-815-5897
bus_email		[email protected]
mail_city		None
mail_st		None
mail_zip4		None
mail_phon		None
sig_date		2008-12-15 00:00:00
sig_loc		LOUISVILLE, KY
sig_naml		Siegle
sig_namf		Thomas
sig_namt		None
sig_nams		None
prn_naml		Siegle
prn_namf		Thomas
prn_namt		None
prn_nams		None
sig_title		Executive Vice President
stmt_firm		None
ind_cb		None
bus_cb		X
trade_cb		None
oth_cb		None
a_b_name		None
a_b_city		None
a_b_st		None
a_b_zip4		None
descrip_1		Information Technology Services Managment (ITSM) for maintaining and tracking criminal justice data.
descrip_2		None
c_less50		None
c_more50		None
ind_class		OTH
ind_descr		Data Managment
bus_class		OTH
bus_descr		criminal justice data managment
auth_name		WARNER & PANK, LLC
auth_city		Sacramento
auth_st		CA
auth_zip4		95814
lobby_int		None
influen_yn		None
firm_name		None
newcert_cb		None
rencert_cb		None
complet_dt		None
lby_reg_cb		None
lby_604_cb		None
st_leg_yn		None
st_agency		None
lobby_cb		None
l_firm_cb		None

Table: filer_address

filer_id		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591
adrid		2133997		2162511		2205220		2529243		2415284		2471332		2455796		2276967		2510205		2551772		2344721
effect_dt		2008-02-11 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2022-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2017-04-01 00:00:00		2013-01-01 00:00:00		2021-01-01 00:00:00		2023-01-01 00:00:00		2015-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		2007		2009		2011		2021		2017		2019		2017		2013		2021		2023		2015

Table: filer_filings

filer_id		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591
filing_id		1776476		1973818		1839528		1864287		1811251		1795495		1959179		1945152		1328078		1346527		1317184		1317186		1386101		1391649		1375601		1412455		1430735		1417476		1448119		1480684		1458797		1500098		1527673		1559900		1555050		1586524		1628663		1601296		1618324		1653150		1698814		1672184		1929253		1900116		1726520		1731834		1756499		1992550		2004258		2391395		2413603		2267220		2028496		2055211		2089516		2120718		2120718		2151317		2141785		2167292		2465901		2478650		2544711		2372522		2346857		2336461		2306378		2187791		2431599		2233625		2202913		2509791		2671311		2561789		2614991		2593140		2698442		2637850		2574180		2733261
period_id		214		222		217		218		216		215		221		None		193		194		None		None		196		196		195		None		198		197		199		201		200		202		203		204		None		205		208		206		207		209		211		210		220		219		None		212		213		223		224		238		239		234		225		226		227		228		228		229		None		230		241		242		244		237		None		236		235		231		240		233		232		243		249		None		247		246		250		248		245		251
form_id		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F602		F999		F602		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		2013-07-18 00:00:00		2015-07-12 00:00:00		2014-04-18 00:00:00		2014-07-18 00:00:00		2014-01-19 00:00:00		2013-10-18 00:00:00		2015-04-18 00:00:00		2014-12-23 00:00:00		2008-04-29 00:00:00		2008-07-28 00:00:00		2008-03-06 00:00:00		2008-03-06 00:00:00		2008-12-29 00:00:00		2009-01-25 00:00:00		2008-10-29 00:00:00		2008-12-23 00:00:00		2009-07-14 00:00:00		2009-04-15 00:00:00		2009-10-16 00:00:00		2010-04-19 00:00:00		2010-01-20 00:00:00		2010-07-12 00:00:00		2010-10-15 00:00:00		2011-01-13 00:00:00		2010-12-16 00:00:00		2011-04-15 00:00:00		2012-01-16 00:00:00		2011-07-19 00:00:00		2011-10-19 00:00:00		2012-04-20 00:00:00		2012-10-16 00:00:00		2012-07-17 00:00:00		2015-01-23 00:00:00		2014-10-17 00:00:00		2012-12-10 00:00:00		2013-01-24 00:00:00		2013-04-15 00:00:00		2015-10-19 00:00:00		2016-01-15 00:00:00		2019-07-19 00:00:00		2019-10-17 00:00:00		2018-07-20 00:00:00		2016-04-14 00:00:00		2016-07-14 00:00:00		2016-10-16 00:00:00		2017-01-18 00:00:00		2017-01-18 00:00:00		2017-04-16 00:00:00		2016-12-19 00:00:00		2017-07-13 00:00:00		2020-04-16 00:00:00		2020-07-15 00:00:00		2021-01-16 00:00:00		2019-04-14 00:00:00		2018-12-17 00:00:00		2019-01-18 00:00:00		2018-10-13 00:00:00		2017-10-14 00:00:00		2020-01-17 00:00:00		2018-04-21 00:00:00		2018-01-18 00:00:00		2020-10-05 00:00:00		2022-04-27 00:00:00		2020-12-18 00:00:00		2021-10-09 00:00:00		2021-07-14 00:00:00		2022-07-15 00:00:00		2022-01-25 00:00:00		2021-04-14 00:00:00		2022-10-14 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10005		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11003
session_id		2013		2015		2013		2013		2013		2013		2015		2015		2007		2007		2007		2007		2009		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2011		2013		2015		2015		2019		2019		2017		2015		2015		2015		2015		2015		2017		2017		2017		2019		2019		2019		2019		2019		2017		2017		2017		2019		2017		2017		2019		2021		2021		2021		2021		2021		2021		2021		2021
user_id		AGLADNEY		MPACHECO		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		LTHIBAUL		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		JGRISSUM		YRODRIGU		CFLAGG		JGRISSUM		JGRISSUM		MGUERRA		ASAETERN		WBROWN		ASAETERN		ASAETERN		AGLADNEY		SARRIAGA		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		MPACHECO		AGLADNEY		PBANFORD		ASAETERN		AGLADNEY		MPACHECO		AGLADNEY		SUSHAKOV		GTAYLOR		AGLADNEY		JINGRAM		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		AGLADNEY		SUSHAKOV		VUKSTINA		GTAYLOR		GTAYLOR		GPEREZ		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		GTAYLOR		CAFILER		MMERCHANT		CHATRIDGE		GTAYLOR		CAFILER		CHATRIDGE		CHARTRIDGE		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
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11001		11003
rpt_start		2013-04-01 00:00:00		2015-04-01 00:00:00		2014-01-01 00:00:00		2014-04-01 00:00:00		2013-10-01 00:00:00		2013-07-01 00:00:00		2015-01-01 00:00:00		1900-01-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-12-24 00:00:00		2008-10-01 00:00:00		2008-07-01 00:00:00		1900-01-01 00:00:00		2009-04-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		1900-01-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-07-01 00:00:00		2012-04-01 00:00:00		2014-10-01 00:00:00		2014-07-01 00:00:00		1900-01-01 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2015-10-01 00:00:00		2019-04-01 00:00:00		2019-07-01 00:00:00		2018-04-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2016-10-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2020-01-01 00:00:00		2020-04-01 00:00:00		2020-10-01 00:00:00		2019-01-01 00:00:00		1900-01-01 00:00:00		2018-10-01 00:00:00		2018-07-01 00:00:00		2017-07-01 00:00:00		2019-10-01 00:00:00		2018-01-01 00:00:00		2017-10-01 00:00:00		2020-07-01 00:00:00		2022-01-01 00:00:00		1900-01-01 00:00:00		2021-07-01 00:00:00		2021-04-01 00:00:00		2022-04-01 00:00:00		2021-10-01 00:00:00		2021-01-01 00:00:00		2022-07-01 00:00:00
rpt_end		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-03-31 00:00:00		2014-06-30 00:00:00		2013-12-31 00:00:00		2013-09-30 00:00:00		2015-03-31 00:00:00		1900-01-01 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-12-24 00:00:00		2008-12-31 00:00:00		2008-09-30 00:00:00		1900-01-01 00:00:00		2009-06-30 00:00:00		2009-03-31 00:00:00		2009-09-30 00:00:00		2010-03-31 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		1900-01-01 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2012-03-31 00:00:00		2012-09-30 00:00:00		2012-06-30 00:00:00		2014-12-31 00:00:00		2014-09-30 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2015-12-31 00:00:00		2019-06-30 00:00:00		2019-09-30 00:00:00		2018-06-30 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2020-03-31 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		2019-03-31 00:00:00		1900-01-01 00:00:00		2018-12-31 00:00:00		2018-09-30 00:00:00		2017-09-30 00:00:00		2019-12-31 00:00:00		2018-03-31 00:00:00		2017-12-31 00:00:00		2020-09-30 00:00:00		2022-03-31 00:00:00		1900-01-01 00:00:00		2021-09-30 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00		2021-12-31 00:00:00		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
filing_type		22006		22006		22006		22006		22006		22006		22006		None		22001		22001		None		None		22001		22001		22001		None		22006		22001		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006

Table: filer_interests

filer_id		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591
session_id		2009		2013		2011		2007		2015		2021		2017		2019		2023
interest_cd		40312		40312		40312		40312		40312		40312		40312		40312		40312
effect_date		2009-01-01 00:00:00		2013-01-01 00:00:00		2011-01-01 00:00:00		2008-02-11 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00

Table: filer_to_filer_type

filer_id		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591
filer_type		1		1		1		1		1		1		1		1		1
active		Y		Y		Y		Y		Y		Y		Y		Y		N
race		None		None		0		None		None		None		None		None		None
session_id		2011		2013		2007		2009		2015		2021		2019		2017		2023
category		None		None		0		None		None		None		None		None		None
category_type		None		None		0		None		None		None		None		None		None
sub_category		None		None		0		None		None		None		None		None		None
effect_dt		2011-01-01 00:00:00		2013-01-01 00:00:00		2008-02-11 00:00:00		2009-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		None		None		0		None		None		None		None		None		None
election_type		None		None		0		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		None		None		None		None		None
party_cd		None		None		0		None		None		None		None		None		None
county_cd		None		None		0		None		None		None		None		None		None
district_cd		None		None		0		None		None		None		None		None		None

Table: filer_xref

filer_id		1304591
xref_id		1304591
effect_dt		2008-03-06 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591
filer_id		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591		1304591
filer_type		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00
naml		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS INSIGHTS LLC		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS		APPRISS
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE		LOUISVILLE
st		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY		KY
zip4		402233842		402233842		402233842		402233842		402233842		402233842		40223		402233842		402233842		40223		40223		402233842		402233842		402233842		402233842		402233842		402233842		40223		402233842		402233842		40223		40223		402233842		402233842		402233842		402233842		402233842		402233842		40223		402233842		402233842		40223		40223		402233842		402233842		402233842		402233842		402233842		402233842		40223		402233842		402233842		40223		40223		402233842		402233842		402233842		402233842		402233842		402233842		40223		402233842		402233842		40223		40223		402233842		402233842		402233842		402233842		402233842		402233842		40223		402233842		402233842		40223		40223		402233842		402233842		402233842		402233842		402233842		402233842		40223		402233842		402233842		40223		40223		402233842		402233842		402233842		402233842		402233842		402233842		40223		402233842		402233842		40223		40223		402233842		402233842		402233842		402233842		402233842		402233842		40223		402233842		402233842		40223		40223		402233842		402233842		402233842		402233842		402233842		402233842		40223		402233842		402233842		40223		40223
phon		5028153907		5028153907		5028153907		5028153907		5028153907		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153907		5028153907		5028153907		5028153907		5028153907		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153907		5028153907		5028153907		5028153907		5028153907		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153907		5028153907		5028153907		5028153907		5028153907		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153907		5028153907		5028153907		5028153907		5028153907		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153907		5028153907		5028153907		5028153907		5028153907		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153907		5028153907		5028153907		5028153907		5028153907		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153907		5028153907		5028153907		5028153907		5028153907		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153907		5028153907		5028153907		5028153907		5028153907		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805		5028153907		5028153907		5028153907		5028153907		5028153907		5028153805		5028153805		5028153805		5028153805		5028153805		5028153805
fax		None		5028155897																				None		5028155897																				None		5028155897																				None		5028155897																				None		5028155897																				None		5028155897																				None		5028155897																				None		5028155897																				None		5028155897																				None		5028155897
email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1304591

Table: lobbying_chg_log

filer_id		1304591		1304591
change_no		0		1
session_id		2007		2021
log_dt		2008-03-06 00:00:00		2020-12-18 00:00:00
filer_type		1		1
correction_flg		Y		None
action		ADDED		CHANGED
attribute_changed		FIRM		RESPONSIBLE OFFICER
ethics_dt		None		None
interests		None		None
filer_full_name		APPRISS		APPRISS
filer_city		None		None
filer_st		None		None
filer_zip		None		None
filer_phone		None		None
entity_type		3		20
entity_name		WARNER & PANK, LLC		PRESIDENT BRIAN MATTHEWS
entity_city		None		None
entity_st		None		None
entity_zip		None		None
entity_phone		None		None
entity_id		1147735		1436504
responsible_officer		None		None
effect_dt		2008-02-11 00:00:00		2021-01-01 00:00:00

Table: received_filings

filer_id		1304591		1304591		1304591		1304591		1304591		1304591
filing_file_name		1328078_0.cal		1417476_0.cal		1391649_0.cal		1346527_0.cal		1375601_0.cal		1386101_0.cal
received_date		2008-04-29 00:00:00		2009-04-15 00:00:00		2009-01-25 00:00:00		2008-07-28 00:00:00		2008-10-29 00:00:00		2008-12-29 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		1328078		1417476		1391649		1346527		1375601		1386101
form_id		F635		F635		F635		F635		F635		F602
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted