Home

Filer ID: 1306019

Table: cvr_lobby_disclosure

filing_id		1351484		1329788		1422241		1453065		1378890		1436946		1395131		1540905		1506526		1484962		1463507		1590835		1609489		1609489		1621339		1571901		1635672		1707327		1678216		1658164		1739906		1799245		1780487		1764836		1815004		1871689		1907698		1845850		1982330		1934296		1963711		1998183		2063732		2037747		2012931		2095072		2175694		2175694		2126567		2157855		2126567		2191640		2209860		2191640		2260926		2271814		2319148		2380654		2342765		2391879		2417072		2472124		2472125		2481842		2472125		2526608		2550751		2577714		2597731		2621302		2621302		2668041		2638855		2740314		2597731		2638855		2703632
amend_id		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		1		0		1		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		1		0		0		0		1		1		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
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		F635		F635		F635		F635		F635		F635		F635
sender_id		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019
filer_id		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019
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		LEM		LEM		LEM		LEM		LEM		LEM		LEM
filer_naml		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION
filer_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
report_num		000		000		000		000		000		000		000		000		000		000		000		000		1		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		1		000		1		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		001		000		000		000		001		001		000
rpt_date		2008-07-31 00:00:00		2008-04-30 00:00:00		2009-04-30 00:00:00		2009-11-02 00:00:00		2008-10-31 00:00:00		2009-07-30 00:00:00		2009-01-30 00:00:00		2010-11-01 00:00:00		2010-07-30 00:00:00		2010-04-30 00:00:00		2010-01-29 00:00:00		2011-04-29 00:00:00		2011-10-06 00:00:00		2011-08-02 00:00:00		2011-10-28 00:00:00		2011-01-31 00:00:00		2012-01-31 00:00:00		2012-10-30 00:00:00		2012-07-31 00:00:00		2012-04-30 00:00:00		2013-01-31 00:00:00		2013-10-30 00:00:00		2013-07-30 00:00:00		2013-04-30 00:00:00		2014-01-29 00:00:00		2014-07-31 00:00:00		2014-10-28 00:00:00		2014-04-30 00:00:00		2015-07-31 00:00:00		2015-01-30 00:00:00		2015-04-29 00:00:00		2015-11-02 00:00:00		2016-08-01 00:00:00		2016-05-02 00:00:00		2016-02-01 00:00:00		2016-10-25 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-03-10 00:00:00		2017-05-01 00:00:00		2017-01-30 00:00:00		2017-10-30 00:00:00		2018-01-31 00:00:00		2017-10-31 00:00:00		2018-06-15 00:00:00		2018-07-30 00:00:00		2018-10-31 00:00:00		2019-04-30 00:00:00		2019-01-29 00:00:00		2019-07-22 00:00:00		2019-10-29 00:00:00		2020-05-05 00:00:00		2020-05-05 00:00:00		2020-07-28 00:00:00		2020-07-28 00:00:00		2020-10-29 00:00:00		2021-01-29 00:00:00		2021-04-27 00:00:00		2021-07-28 00:00:00		2021-10-28 00:00:00		2022-04-20 00:00:00		2022-04-20 00:00:00		2022-01-27 00:00:00		2022-10-25 00:00:00		2022-04-20 00:00:00		2022-04-20 00:00:00		2022-07-29 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		2009-04-01 00:00:00		2008-10-01 00:00:00		2010-07-01 00:00:00		2010-04-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2010-10-01 00:00:00		2011-10-01 00:00:00		2012-07-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2012-10-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-04-01 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2015-04-01 00:00:00		2014-10-01 00:00:00		2015-01-01 00:00:00		2015-07-01 00:00:00		2016-04-01 00:00:00		2016-01-01 00:00:00		2015-10-01 00:00:00		2016-07-01 00:00:00		2017-04-01 00:00:00		2017-04-01 00:00:00		2016-10-01 00:00:00		2017-01-01 00:00:00		2016-10-01 00:00:00		2017-07-01 00:00:00		2017-10-01 00:00:00		2017-07-01 00:00:00		2018-01-01 00:00:00		2018-04-01 00:00:00		2018-07-01 00:00:00		2019-01-01 00:00:00		2018-10-01 00:00:00		2019-04-01 00:00:00		2019-07-01 00:00:00		2019-10-01 00:00:00		2020-01-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-01-01 00:00:00		2021-04-01 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2021-10-01 00:00:00		2022-07-01 00:00:00		2021-04-01 00:00:00		2021-10-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		2009-06-30 00:00:00		2008-12-31 00:00:00		2010-09-30 00:00:00		2010-06-30 00:00:00		2010-03-31 00:00:00		2009-12-31 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2010-12-31 00:00:00		2011-12-31 00:00:00		2012-09-30 00:00:00		2012-06-30 00:00:00		2012-03-31 00:00:00		2012-12-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-06-30 00:00:00		2014-09-30 00:00:00		2014-03-31 00:00:00		2015-06-30 00:00:00		2014-12-31 00:00:00		2015-03-31 00:00:00		2015-09-30 00:00:00		2016-06-30 00:00:00		2016-03-31 00:00:00		2015-12-31 00:00:00		2016-09-30 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		2016-12-31 00:00:00		2017-09-30 00:00:00		2017-12-31 00:00:00		2017-09-30 00:00:00		2018-03-31 00:00:00		2018-06-30 00:00:00		2018-09-30 00:00:00		2019-03-31 00:00:00		2018-12-31 00:00:00		2019-06-30 00:00:00		2019-09-30 00:00:00		2019-12-31 00:00:00		2020-03-31 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-03-31 00:00:00		2021-06-30 00:00:00		2021-09-30 00:00:00		2021-09-30 00:00:00		2022-03-31 00:00:00		2021-12-31 00:00:00		2022-09-30 00:00:00		2021-06-30 00:00:00		2021-12-31 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		2009-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		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-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		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		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		2017-01-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2017-07-01 00:00:00		2017-07-01 00:00:00		2017-07-01 00:00:00		2017-07-01 00:00:00		2017-07-01 00:00:00		2017-07-01 00:00:00		2019-01-01 00:00:00		2017-07-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		2021-01-01 00:00:00		2021-01-01 00:00:00
firm_id		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		None		None		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		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		None		None		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		Rialto		Rialto		Rialto		Rialto		Rialto		Rialto		Rialto		Rialto		Rialto		Rialto		Rialto		Rialto		Rialto		Rialto		Rialto		Rialto		Rialto		Rialto		Rialto		Rialto		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE		GREENWOOD VILLAGE
firm_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO
firm_zip4		92376		92376		92376		92376		92376		92376		92376		92376		92376		92376		92376		92376		92376		92376		92376		92376		92376		92376		92376		92376		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		80112-4133		801124133		801124133		801124133		801124133		801124133		801124133		80111		80111		80111		80111		80111		80111		80111		80111		80111		80111		80111		80111		80111		80111		80111		80111		80111		80111		80111		80111
firm_phon		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		909-841-2092		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		303-792-7509		3037927509		3037927509		3037927509		3037927509		3037927509		3037927509		3037927509		3037927509		3037927509		3037927509		3037927509		3037927509		3037927509		3037927509		3037927509		3037927509		3037927509		3037927509		3037927509		3037927400		3037927400		3037927400		3037927400		3037927400		3037927400		3037927400
mail_city		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD		ENGLEWOOD
mail_st		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO		CO
mail_zip4		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112		80112
mail_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_date		2008-07-31 00:00:00		2008-04-30 00:00:00		2009-04-30 00:00:00		2009-10-30 00:00:00		2008-10-31 00:00:00		2009-07-30 00:00:00		2009-01-29 00:00:00		2010-10-30 00:00:00		2010-07-30 00:00:00		2010-04-30 00:00:00		2010-01-29 00:00:00		2011-04-29 00:00:00		2011-09-01 00:00:00		2011-08-01 00:00:00		2011-10-10 00:00:00		2011-01-31 00:00:00		2012-01-30 00:00:00		2012-10-30 00:00:00		2012-07-30 00:00:00		2012-04-30 00:00:00		2013-01-31 00:00:00		2013-10-30 00:00:00		2013-07-30 00:00:00		2013-04-30 00:00:00		2014-01-29 00:00:00		2014-07-31 00:00:00		2014-10-28 00:00:00		2014-04-30 00:00:00		2015-07-31 00:00:00		2015-01-30 00:00:00		2015-04-28 00:00:00		2015-10-31 00:00:00		2016-07-31 00:00:00		2016-04-29 00:00:00		2016-02-01 00:00:00		2016-10-25 00:00:00		2017-07-25 00:00:00		2017-07-25 00:00:00		2017-01-05 00:00:00		2017-04-25 00:00:00		2017-01-05 00:00:00		2017-10-30 00:00:00		2018-01-31 00:00:00		2017-10-31 00:00:00		2018-06-15 00:00:00		2018-07-30 00:00:00		2019-10-31 00:00:00		2019-04-30 00:00:00		2018-01-29 00:00:00		2019-07-22 00:00:00		2019-10-29 00:00:00		2020-05-05 00:00:00		2020-05-05 00:00:00		2020-07-28 00:00:00		2020-07-28 00:00:00		2020-10-29 00:00:00		2021-01-29 00:00:00		2021-04-27 00:00:00		2021-07-28 00:00:00		2021-10-28 00:00:00		2022-04-20 00:00:00		2022-04-20 00:00:00		2022-01-27 00:00:00		2022-10-25 00:00:00		2022-04-20 00:00:00		2022-04-20 00:00:00		2022-07-29 00:00:00
sig_loc		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood , CO		Greenwood Village, CO		Englewood, CO		Greenwood Village		Greenwood Village, CO		Greenwood Village, CO		Greenwood Village, CO		Greenwood Village, CO		Greenwood Village, CO		Greenwood Village		Greenwood Village		Greenwood Village		Greenwood Village		Greenwood Village		Greenwood Village		Greenwood Village		Greenwood Village		Greenwood Village		Greenwood Village		Greenwood Village, CO		Greenwood Village, CO		Greenwood Village		Greenwood Village		Greenwood Village, CO		Greenwood Village, CO		Greenwood Village
sig_naml		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Yale		Yale		Yale		Yale		Yale		Yale		Yale		Yale		Collier		Collier		Collier		Collier		Collier		Collier		Collier		Collier		Hicks Mayle		Hicks Mayle		Hicks Mayle		Hicks Mayle		Hicks Mayle		Mayle		Mayle		Mayle		May		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Flanders		Flanders		Mayle		Flanders		Flanders		Flanders		Flanders
sig_namf		David		David		David		David		David		David		David		David		David		David		David		David		David		David		David		David		David		David		David		David		Craig M.		Craig M.		Craig M.		Craig M.		Craig M.		Craig M.		Craig M.		Craig M.		Jonathan		Jonathan		Jonathan		Jonathan		Jonathan		Jonathan		Jonathan		Jonathan		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Doug		Doug		Carolyn		Doug		Doug		Doug		Doug
sig_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
prn_naml		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Dolstein		Yale		Yale		Yale		Yale		Yale		Yale		Yale		Yale		Collier		Collier		Collier		Collier		Collier		Collier		Collier		Collier		Hicks Mayle		Hicks Mayle		Hicks Mayle		Hicks Mayle		Hicks Mayle		Mayle		Mayle		Mayle		May		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Mayle		Flanders		Flanders		Mayle		Flanders		Flanders		Flanders		Flanders
prn_namf		David		David		David		David		David		David		David		David		David		David		David		David		David		David		David		David		David		David		David		David		Craig M.		Craig M.		Craig M.		Craig M.		Craig M.		Craig M.		Craig M.		Craig M.		Jonathan		Jonathan		Jonathan		Jonathan		Jonathan		Jonathan		Jonathan		Jonathan		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Carolyn		Doug		Doug		Carolyn		Doug		Doug		Doug		Doug
prn_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_title		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		Sr. Vice President		VP Corporate Development		VP Corporate Development		VP Corporate Development		VP Corporate Development		VP Corporate Development		VP Corporate Development		VP Corporate Development		VP Corporate Development		SVP Operations		SVP Operations		SVP Operations		SVP Operations		SVP Operations		SVP Operations		SVP Operations		SVP Operations		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		VP, Government Affairs, Air Methods		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, Government Affairs		Vice President, State Government Affairs		Vice President, State Government Affairs		Vice President, Government Affairs		Vice President, State Government Affairs		Vice President, State Government Affairs		Vice President, State Government Affairs		Vice President, State Government Affairs
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		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		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		None		None		None		None		None		None		None
part1_2_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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		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		None		None		None		None		None		None		None
lby_actvty		AB 1203, AB 2257, SB 1141 State Budget		AB 2257, SB 1141, State Budget & Dept. of Health Services.		AB 1153, Department of Health Care Services regarding Air Ambulance.		AB 511		AB 1203, AB 2257, SB 1141, State Budget		AB 511, AB 1153, AB 1271		California State Budget with Legislative members.		AB 511, AB 1272, AB 1660, AB 2173, AB 2248, AB 2456, Division of Workers Compensation, Governor's Office		AB 511, AB 1272, AB 1660, AB 2173, AB 2248, AB 2456, Division of Workers Compensation.		AB 511, AB 2248, AB 1660, AB 2173, AB 2456		Nothing to report.		AB 215		AB 210, AB 215, Department of Healthcare Services.		AB 210, AB 215, Department of Healthcare Services.		AB 210, AB 215, Department of Healthcare Services-implementation		Nothing to report.		Nothing to report.		AB 511, AB 1245, AB 1387, AB 1742, AB 1760, AB 1944, AB 2394, SB 1365, DHCS		AB 511, AB 1245, AB 1387, AB 1742, AB 1760, AB 1944, AB 2394, SB 1365		AB 2394, SB 1365		Nothing to report.		AB 867, SB 535, Budget Committee EMATA Funds		AB 867, SB 525, Budget Committee EMATA funds.		AB 867, SB 535, Department of Transportation, DCA, EMS Commission, DHCS		Nothing to report.		AB 1621, EMATA Fund		AB 1621, State Budget and Governor's Office.		AB 1621, EMMA		AB 503, SB 326, SB 1129		Nothing to report.		SB 326		AB 503, AB 1129, SB 326		AB 2260, AB 1680, SB 867		AB 2260		AB 503, AB 1129, SB 326		AB 2260, AB 1680, SB 867		AB 583, AB 1410		AB 583, AB 1410		None to report		CA Legislature, AB 583, AB 263		None		AB 1419 -- Legislature		AB 1410 -- Legislature AB -- Legislative		AB 1410 -- Legislature		AB 2593,CalFire Helicopter Contract -- Legislature. Payments partially for 4th Quarter,2017		AB 2593; CalFire Helicopter Contract ? Legislature, CalFire		AB 2593; CalFire Helicopter Contract ? Legislature, Governor, Dept. of Health Care Services		AB 651, Budget Appropriation ? Legislature, Governor, CalFire		Medical Reimbursements, Balanced Billing - Legislature, Governor		AB 651, Budget Appropriation - Legislature, Governor, CalFire		AB 651, Budget Appropriation - Legislature, Governor, CalFire		AB 651, Budget Appropriation - Legislature, Governor, CalFire		None This Period		None This Period		None This Period		None This Period		Cal-Fire, Firehawk Remuneration - Legislature		AB 1104 - Legislature		AB 1104 - Legislature		None This Period		None This Period		Sikorsky S-70i Procurement ? Legislature, Department of Government Services, Cal Fire		DGS and Cal Fire, Sikorsky S-70i Procurement - Legislature		AB 2648 ? Legislature, Governor; Contract Issues -- Cal Fire		AB 1104 - Legislature		DGS and Cal Fire, Sikorsky S-70i Procurement - Legislature		AB 178, AB 180, AB 2648, SB 178, SB 180 ? Legislature, Cal Fire
lobby_n_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lobby_y_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpcmte_nm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpcmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: cvr_registration

filing_id		1576939		1577155		1721948		1925951		1938806		2121445
amend_id		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F602		F602		F602		F602		F602		F602
sender_id		1304270		1304270		1304270		1304270		1304270		1304270
filer_id		1306019		1306019		1306019		1306019		1306019		1306019
entity_cd		LEM		LEM		LEM		LEM		LEM		LEM
filer_naml		Mercy Air Service, Inc.		Mercy Air Service, Inc.		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation		Air Methods Corporation
filer_namf		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None
report_num		000		000		000		000		000		000
rpt_date		2011-02-14 00:00:00		2011-02-15 00:00:00		2012-12-31 00:00:00		2015-01-15 00:00:00		2015-02-06 00:00:00		2017-01-20 00:00:00
ls_beg_yr		2011		2011		2013		2015		2015		2017
ls_end_yr		2012		2012		2014		2016		2016		2018
qual_date		2008-03-25 00:00:00		2008-03-25 00:00:00		2008-03-25 00:00:00		2008-03-25 00:00:00		2008-03-25 00:00:00		2008-03-25 00:00:00
eff_date		2010-12-01 00:00:00		2010-12-01 00:00:00		2012-12-01 00:00:00		2014-12-01 00:00:00		2014-12-01 00:00:00		2016-12-01 00:00:00
bus_city		Rialto		Rialto		Englewood		Englewood		Englewood		Englewood
bus_st		CA		CA		CO		CO		CO		CO
bus_zip4		92376		92376		80112-4133		80112-4133		80112-4133		80112-4133
bus_phon		909-841-2092		909-841-2092		303-792-7509		303-792-7509		303-792-7509		303-792-7509
bus_fax		None		None		None		None		None		None
bus_email		None		None		None		None		None		None
mail_city		Englewood		Englewood		Englewood		Englewood		Englewood		Englewood
mail_st		CO		CO		CO		CO		CO		CO
mail_zip4		80112		80112		80112		80112		80112		80112
mail_phon		None		None		None		None		None		None
sig_date		2010-12-30 00:00:00		2010-12-30 00:00:00		2012-12-27 00:00:00		2014-12-22 00:00:00		2014-12-01 00:00:00		2016-12-05 00:00:00
sig_loc		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO		Englewood, CO
sig_naml		Dolstein		Dolstein		Yale		Collier		Collier		Hicks Mayle
sig_namf		David		David		Craig M.		Jonathan		Jonathan		Carolyn
sig_namt		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None
prn_naml		Dolstein		Dolstein		Yale		Collier		Collier		Hicks Mayle
prn_namf		David		David		Craig M.		Jonathan		Jonathan		Carolyn
prn_namt		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None
sig_title		Sr. Vice President		Sr. Vice President		VP Corporate Development		SVP Operations		SVP Operations		Vice President, Government Affairs
stmt_firm		None		None		None		None		None		None
ind_cb		None		None		None		None		None		None
bus_cb		X		X		X		X		X		X
trade_cb		None		None		None		None		None		None
oth_cb		None		None		None		None		None		None
a_b_name		None		None		None		None		None		None
a_b_city		None		None		None		None		None		None
a_b_st		None		None		None		None		None		None
a_b_zip4		None		None		None		None		None		None
descrip_1		None		None		None		Air and ground ambulance services.		Air and ground ambulance services.		Air and ground ambulance services.
descrip_2		None		None		None		None		None		None
c_less50		None		None		None		None		None		None
c_more50		None		None		None		None		None		None
ind_class		HEA		HEA		HEA		HEA		HEA		HEA
ind_descr		None		None		None		None		None		None
bus_class		TRN		TRN		TRN		TRN		TRN		TRN
bus_descr		None		None		None		None		None		None
auth_name		Sierra Health Group		Sierra Health Group		Sierra Health Group		Sierra Health Group		Sierra Health Group		Sierra Health Group
auth_city		Golden		Golden		Golden		Golden		Golden		Golden
auth_st		CO		CO		CO		CO		CO		CO
auth_zip4		80403		80403		80403		80403		80403		80403
lobby_int		None		None		None		None		None		None
influen_yn		None		None		None		None		None		None
firm_name		None		None		None		None		None		None
newcert_cb		None		None		None		None		None		None
rencert_cb		None		None		None		None		None		None
complet_dt		None		None		None		None		None		None
lby_reg_cb		None		None		None		None		None		None
lby_604_cb		None		None		None		None		None		None
st_leg_yn		None		None		None		None		None		None
st_agency		None		None		None		None		None		None
lobby_cb		None		None		None		None		None		None
l_firm_cb		None		None		None		None		None		None

Table: filer_address

filer_id		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019
adrid		2136280		2136284		2164907		2164908		2207073		2207074		2415072		2471107		2471108		2547696		2547697		2269338		2344774		2506616		2506617
effect_dt		2008-03-25 00:00:00		2008-03-25 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		2017-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2021-03-08 00:00:00		2021-01-01 00:00:00
add_type		7051		7082		7051		7082		7051		7082		7051		7051		7082		7051		7082		7051		7051		7051		7082
session_id		2007		2007		2009		2009		2011		2011		2017		2019		2019		2023		2023		2013		2015		2021		2021

Table: filer_filings

filer_id		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019
filing_id		1780487		1982330		1963711		1871689		1799245		1950701		1938806		1323872		1323874		1351484		1329788		1378890		1395131		1415872		1422241		1436946		1463507		1453065		1484962		1506526		1540905		1557597		1571901		1576939		1577155		1590835		1609489		1609489		1635672		1621339		1658164		1678216		1815004		1907698		1934296		1925951		1707327		1721948		1731707		1739906		1845850		1764836		1998183		2319148		2209860		2550751		2472125		2260926		2380654		2191640		2012931		2037747		2063732		2095072		2121445		2126567		2134210		2126567		2175694		2175694		2157855		2166749		2376265		2271814		2526608		2472124		2391879		2342765		2481842		2417072		2191640		2472125		2597731		2621302		2638855		2597731		2638855		2703632		2577714		2668041		2621302		2633746		2740314
period_id		214		222		221		218		215		None		221		None		None		194		193		195		196		None		197		198		200		199		201		202		203		None		204		205		205		205		206		206		208		207		209		210		216		219		220		221		211		212		None		212		217		213		223		235		232		244		241		233		237		231		224		225		226		227		229		228		None		228		230		230		229		None		None		234		243		240		238		236		242		239		231		241		246		247		248		246		248		250		245		249		247		None		251
form_id		F635		F635		F635		F635		F635		F602		F602		F602		F999		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		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		1		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		1		0		1		0		0		0		0		0		0		0		0		0		0		0		1		0		1		0		1		1		0		0		0		0		0		0
filing_date		2013-07-30 00:00:00		2015-07-31 00:00:00		2015-04-29 00:00:00		2014-07-31 00:00:00		2013-10-30 00:00:00		2014-12-29 00:00:00		2015-02-06 00:00:00		2008-04-01 00:00:00		2008-04-09 00:00:00		2008-07-31 00:00:00		2008-04-30 00:00:00		2008-10-31 00:00:00		2009-01-30 00:00:00		2009-01-05 00:00:00		2009-04-30 00:00:00		2009-07-30 00:00:00		2010-01-29 00:00:00		2009-11-02 00:00:00		2010-04-30 00:00:00		2010-07-30 00:00:00		2010-11-01 00:00:00		2010-12-31 00:00:00		2011-01-31 00:00:00		2011-02-14 00:00:00		2011-02-15 00:00:00		2011-04-29 00:00:00		2011-10-06 00:00:00		2011-08-02 00:00:00		2012-01-31 00:00:00		2011-10-28 00:00:00		2012-04-30 00:00:00		2012-07-31 00:00:00		2014-01-29 00:00:00		2014-10-28 00:00:00		2015-01-30 00:00:00		2015-01-15 00:00:00		2012-10-30 00:00:00		2012-12-31 00:00:00		2012-12-28 00:00:00		2013-01-31 00:00:00		2014-04-30 00:00:00		2013-04-30 00:00:00		2015-11-02 00:00:00		2018-10-31 00:00:00		2018-01-31 00:00:00		2021-01-29 00:00:00		2020-05-05 00:00:00		2018-06-15 00:00:00		2019-04-30 00:00:00		2017-10-31 00:00:00		2016-02-01 00:00:00		2016-05-02 00:00:00		2016-08-01 00:00:00		2016-10-25 00:00:00		2017-01-20 00:00:00		2017-01-30 00:00:00		2017-01-05 00:00:00		2017-03-10 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-05-01 00:00:00		2017-07-11 00:00:00		2019-02-01 00:00:00		2018-07-30 00:00:00		2020-10-29 00:00:00		2020-05-05 00:00:00		2019-07-22 00:00:00		2019-01-29 00:00:00		2020-07-28 00:00:00		2019-10-29 00:00:00		2017-10-30 00:00:00		2020-07-28 00:00:00		2021-07-28 00:00:00		2022-04-20 00:00:00		2022-01-27 00:00:00		2022-04-20 00:00:00		2022-04-20 00:00:00		2022-07-29 00:00:00		2021-04-27 00:00:00		2022-04-20 00:00:00		2021-10-28 00:00:00		2021-03-09 00:00:00		2022-10-25 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10005		10001		10005		10005		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10005		10002		10001		10002		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10002		10001		10002		10001		10002		10002		10001		10001		10001		10001		10005		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11001		11001		11003
session_id		2013		2015		2015		2013		2013		2015		2015		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2011		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2015		2011		2013		2013		2011		2013		2013		2015		2017		2017		2019		2019		2017		2019		2017		2015		2015		2015		2015		2017		2015		2017		2015		2017		2017		2017		2017		2019		2017		2019		2019		2019		2017		2019		2019		2017		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		PBANFORD		YRODRIGU		YRODRIGU		LTHIBAUL		LTHIBAUL		MGUERRA		MGUERRA		SARRIAGA		MGUERRA		MGUERRA		MGUERRA		MGUERRA		ASAETERN		ASAETERN		ASAETERN		PBANFORD		AGLADNEY		PBANFORD		PBANFORD		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		ASAETERN		AGLADNEY		AGLADNEY		MPACHECO		PBANFORD		AGLADNEY		PBANFORD		PBANFORD		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		GTAYLOR		VUKSTINA		SARRIAGA		GTAYLOR		AGLADNEY		AGLADNEY		JINGRAM		AGLADNEY		AGLADNEY		PBANFORD		AGLADNEY		PBANFORD		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		GPEREZ		DMCCASTL		AGLADNEY		GTAYLOR		GTAYLOR		SUSHAKOV		AGLADNEY		GTAYLOR		AGLADNEY		AGLADNEY		GTAYLOR		GTAYLOR		CHATRIDGE		CHATRIDGE		CAFILER		CHATRIDGE		CAFILER		GTAYLOR		CAFILER		CHATRIDGE		CVANLIEW		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
fine_audit		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11001		11003		11003
rpt_start		2013-04-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2014-04-01 00:00:00		2013-07-01 00:00:00		1900-01-01 00:00:00		2015-02-06 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-04-01 00:00:00		2008-01-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		1900-01-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2009-10-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		2011-02-14 00:00:00		2011-02-15 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-04-01 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2013-10-01 00:00:00		2014-07-01 00:00:00		2014-10-01 00:00:00		2015-01-15 00:00:00		2012-07-01 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2018-07-01 00:00:00		2017-10-01 00:00:00		2020-10-01 00:00:00		2020-01-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2017-07-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2017-01-20 00:00:00		2016-10-01 00:00:00		1900-01-01 00:00:00		2016-10-01 00:00:00		2017-04-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-04-01 00:00:00		2020-07-01 00:00:00		2019-10-01 00:00:00		2019-04-01 00:00:00		2018-10-01 00:00:00		2020-04-01 00:00:00		2019-07-01 00:00:00		2017-07-01 00:00:00		2020-01-01 00:00:00		2021-04-01 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2021-04-01 00:00:00		2021-10-01 00:00:00		2022-04-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		1900-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		2015-03-31 00:00:00		2014-06-30 00:00:00		2013-09-30 00:00:00		1900-01-01 00:00:00		2015-02-06 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-06-30 00:00:00		2008-03-31 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		1900-01-01 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-09-30 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2011-02-14 00:00:00		2011-02-15 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2014-09-30 00:00:00		2014-12-31 00:00:00		2015-01-15 00:00:00		2012-09-30 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2018-09-30 00:00:00		2017-12-31 00:00:00		2020-12-31 00:00:00		2020-03-31 00:00:00		2018-03-31 00:00:00		2019-03-31 00:00:00		2017-09-30 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2017-01-20 00:00:00		2016-12-31 00:00:00		1900-01-01 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-06-30 00:00:00		2020-09-30 00:00:00		2019-12-31 00:00:00		2019-06-30 00:00:00		2018-12-31 00:00:00		2020-06-30 00:00:00		2019-09-30 00:00:00		2017-09-30 00:00:00		2020-03-31 00:00:00		2021-06-30 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00		2021-03-31 00:00:00		2022-03-31 00:00:00		2021-09-30 00:00:00		1900-01-01 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filing_type		22001		22001		22001		22001		22001		None		22001		None		None		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22006		22006		22006		22006		22006		22006		22006		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006

Table: filer_interests

filer_id		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019
session_id		2009		2011		2007		2013		2017		2019		2015		2021		2023
interest_cd		40318		40318		40318		40306		40306		40306		40306		40306		40306
effect_date		2009-01-01 00:00:00		2011-01-01 00:00:00		2008-03-25 00:00:00		2013-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2015-01-01 00:00:00		2021-03-08 00:00:00		2023-01-01 00:00:00

Table: filer_to_filer_type

filer_id		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019
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		2013		2011		2007		2009		2015		2019		2021		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		2013-01-01 00:00:00		2011-01-01 00:00:00		2008-03-25 00:00:00		2009-01-01 00:00:00		2015-01-01 00:00:00		2019-01-01 00:00:00		2021-03-08 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		1306019
xref_id		1306019
effect_dt		2008-04-09 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019
filer_id		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019
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		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		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00
naml		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		AIR METHODS CORPORATION		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.		MERCY AIR SERVICE, INC.
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		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		ENGLEWOOD		GOLDEN		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		ENGLEWOOD		GOLDEN		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		ENGLEWOOD		GOLDEN		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		ENGLEWOOD		GOLDEN		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		ENGLEWOOD		GOLDEN		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		ENGLEWOOD		GOLDEN		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		ENGLEWOOD		GOLDEN		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		ENGLEWOOD		GOLDEN		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		RIALTO		ENGLEWOOD		ENGLEWOOD		GOLDEN		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD		GREENWOOD VILLAGE		ENGLEWOOD
st		CA		CO		CA		CO		CA		CO		CA		CO		CO		CO		CO		CO		CO		CO		CO		CA		CO		CA		CO		CA		CO		CA		CO		CO		CO		CO		CO		CO		CO		CO		CA		CO		CA		CO		CA		CO		CA		CO		CO		CO		CO		CO		CO		CO		CO		CA		CO		CA		CO		CA		CO		CA		CO		CO		CO		CO		CO		CO		CO		CO		CA		CO		CA		CO		CA		CO		CA		CO		CO		CO		CO		CO		CO		CO		CO		CA		CO		CA		CO		CA		CO		CA		CO		CO		CO		CO		CO		CO		CO		CO		CA		CO		CA		CO		CA		CO		CA		CO		CO		CO		CO		CO		CO		CO		CO		CA		CO		CA		CO		CA		CO		CA		CO		CO		CO		CO		CO		CO		CO		CO		CA		CO		CA		CO		CA		CO		CA		CO		CO		CO		CO		CO		CO		CO		CO
zip4		92376		80112		92376		80112		92376		80112		801124133		80112		801124133		80111		80112		80111		80112		80111		80112		92376		80112		92376		80112		92376		80112		801124133		80112		801124133		80111		80112		80111		80112		80111		80112		92376		80112		92376		80112		92376		80112		801124133		80112		801124133		80111		80112		80111		80112		80111		80112		92376		80112		92376		80112		92376		80112		801124133		80112		801124133		80111		80112		80111		80112		80111		80112		92376		80112		92376		80112		92376		80112		801124133		80112		801124133		80111		80112		80111		80112		80111		80112		92376		80112		92376		80112		92376		80112		801124133		80112		801124133		80111		80112		80111		80112		80111		80112		92376		80112		92376		80112		92376		80112		801124133		80112		801124133		80111		80112		80111		80112		80111		80112		92376		80112		92376		80112		92376		80112		801124133		80112		801124133		80111		80112		80111		80112		80111		80112		92376		80112		92376		80112		92376		80112		801124133		80112		801124133		80111		80112		80111		80112		80111		80112
phon		9098412092		9098412092		9098412092				9098412092				3037927509		3037927509		3037927509		3037927509				3037927400				3037927400				9098412092		9098412092		9098412092				9098412092				3037927509		3037927509		3037927509		3037927509				3037927400				3037927400				9098412092		9098412092		9098412092				9098412092				3037927509		3037927509		3037927509		3037927509				3037927400				3037927400				9098412092		9098412092		9098412092				9098412092				3037927509		3037927509		3037927509		3037927509				3037927400				3037927400				9098412092		9098412092		9098412092				9098412092				3037927509		3037927509		3037927509		3037927509				3037927400				3037927400				9098412092		9098412092		9098412092				9098412092				3037927509		3037927509		3037927509		3037927509				3037927400				3037927400				9098412092		9098412092		9098412092				9098412092				3037927509		3037927509		3037927509		3037927509				3037927400				3037927400				9098412092		9098412092		9098412092				9098412092				3037927509		3037927509		3037927509		3037927509				3037927400				3037927400				9098412092		9098412092		9098412092				9098412092				3037927509		3037927509		3037927509		3037927509				3037927400				3037927400
fax		None		None		None		None		None		None		None		None		None				None				None				None		None		None		None		None		None		None		None		None		None				None				None				None		None		None		None		None		None		None		None		None		None				None				None				None		None		None		None		None		None		None		None		None		None				None				None				None		None		None		None		None		None		None		None		None		None				None				None				None		None		None		None		None		None		None		None		None		None				None				None				None		None		None		None		None		None		None		None		None		None				None				None				None		None		None		None		None		None		None		None		None		None				None				None				None		None		None		None		None		None		None		None		None		None				None				None				None
email		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None

Table: filers

filer_id		1306019

Table: lobbying_chg_log

filer_id		1306019		1306019
change_no		0		1
session_id		2007		2017
log_dt		2008-04-01 00:00:00		2017-07-11 00:00:00
filer_type		1		2
correction_flg		Y		Y
action		ADDED		ADDED
attribute_changed		FIRM		FIRM
ethics_dt		None		None
interests		None		None
filer_full_name		MERCY AIR SERVICE, INC.		AIR METHODS CORPORATION
filer_city		None		RIALTO
filer_st		None		CA
filer_zip		None		92376
filer_phone		None		9098412092
entity_type		3		3
entity_name		SIERRA HEALTH GROUP		DI MARE, BROWN, HICKS & KESSLER, LLC
entity_city		None		None
entity_st		None		None
entity_zip		None		None
entity_phone		None		None
entity_id		1304270		None
responsible_officer		None		None
effect_dt		2008-03-25 00:00:00		2017-07-11 00:00:00

Table: received_filings

filer_id		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019		1306019
filing_file_name		1329788_0.cal		1506526_0.cal		1395131_0.cal		1351484_0.cal		1484962_0.cal		1463507_0.cal		1453065_0.cal		1378890_0.cal		1436946_0.cal		1422241_0.cal		1845850_0.cal		1739906_0.cal		1678216_0.cal		1799245_0.cal		1571901_0.cal		1540905_0.cal		1609489_0.cal		1577155_0.cal		1576939_0.cal		1815004_0.cal		1609489_1.cal		1590835_0.cal		1780487_0.cal		1764836_0.cal		1635672_0.cal		1621339_0.cal		1658164_0.cal		1721948_0.cal		1707327_0.cal		1871689_0.cal		2121445_0.cal		2126567_0.cal		2126567_1.cal		1998183_0.cal		2012931_0.cal		2095072_0.cal		1925951_0.cal		1907698_0.cal		2063732_0.cal		2037747_0.cal		1938806_0.cal		1963711_0.cal		1982330_0.cal		1934296_0.cal		2157855_0.cal		2175694_1.cal		2175694_0.cal		341982.cal
received_date		2008-04-30 00:00:00		2010-07-30 00:00:00		2009-01-30 00:00:00		2008-07-31 00:00:00		2010-04-30 00:00:00		2010-01-29 00:00:00		2009-11-02 00:00:00		2008-10-31 00:00:00		2009-07-30 00:00:00		2009-04-30 00:00:00		2014-04-30 00:00:00		2013-01-31 00:00:00		2012-07-31 00:00:00		2013-10-30 00:00:00		2011-01-31 00:00:00		2010-11-01 00:00:00		2011-08-02 00:00:00		2011-02-15 00:00:00		2011-02-14 00:00:00		2014-01-29 00:00:00		2011-10-06 00:00:00		2011-04-29 00:00:00		2013-07-30 00:00:00		2013-04-30 00:00:00		2012-01-31 00:00:00		2011-10-28 00:00:00		2012-04-30 00:00:00		2012-12-31 00:00:00		2012-10-30 00:00:00		2014-07-31 00:00:00		2017-01-20 00:00:00		2017-01-30 00:00:00		2017-03-10 00:00:00		2015-11-02 00:00:00		2016-02-01 00:00:00		2016-10-25 00:00:00		2015-01-15 00:00:00		2014-10-28 00:00:00		2016-08-01 00:00:00		2016-05-02 00:00:00		2015-02-06 00:00:00		2015-04-29 00:00:00		2015-07-31 00:00:00		2015-01-30 00:00:00		2017-05-01 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-10-31 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp
filing_id		1329788		1506526		1395131		1351484		1484962		1463507		1453065		1378890		1436946		1422241		1845850		1739906		1678216		1799245		1571901		1540905		1609489		1577155		1576939		1815004		1609489		1590835		1780487		1764836		1635672		1621339		1658164		1721948		1707327		1871689		2121445		2126567		2126567		1998183		2012931		2095072		1925951		1907698		2063732		2037747		1938806		1963711		1982330		1934296		2157855		2175694		2175694		None
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F602		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		None
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints