Home

Filer ID: 1012094

Table: filer_address

filer_id		1012094		1012094		1012094
adrid		1011478		2213888		2360002
effect_dt		1990-12-05 00:00:00		2011-01-20 00:00:00		2015-01-28 00:00:00
add_type		7051		7051		7051
session_id		1989		2009		2013

Table: filer_filings

filer_id		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094
filing_id		72195		72196		72197		72198		72199		72200		72201		72202		670171		747487		811206		805248		824711		821811		858273		854664		854664		907608		916676		916677		1023863		1027938		1027938		1023863		1075345		1113395		1096018		1112708		1142082		1182818		1187234		1179939		1218768		1231118		1273820		1244802		1861434		1810378		1956395		1562364		1575604		1632020		1635954		1671365		1822064		1923498		1931583		1923498		1862846		1742276		1733595		1751165		2004563		2334332		2263964		2480848		2533689		2005250		2058589		2055928		2102020		2120787		2120115		2507267		2265124		2342165		2561970		2308424		2203902		2200679		2453939		2550916		2591389		2663839		2637549		2593847
period_id		121		123		145		145		147		145		153		155		None		None		None		165		None		169		None		169		169		171		None		None		177		None		None		177		179		None		None		181		183		185		None		None		188		187		None		None		217		213		None		201		None		205		None		209		None		221		219		221		None		None		211		None		221		235		233		241		None		None		None		225		228		None		227		243		None		None		None		236		None		229		241		243		245		None		247		None
form_id		F461		F461		F497		F461		F461		F405		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F497		F461		F461		F461		F497		F461		F461		F497		F461		F461		F461		F461		F461
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1990-11-19 00:00:00		1991-01-30 00:00:00		1996-03-13 00:00:00		1996-07-22 00:00:00		1997-01-23 00:00:00		1997-01-23 00:00:00		1998-07-20 00:00:00		1999-02-01 00:00:00		2000-07-31 00:00:00		2001-01-19 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-02-20 00:00:00		2002-02-21 00:00:00		2002-07-31 00:00:00		2002-07-30 00:00:00		2003-01-28 00:00:00		2003-01-28 00:00:00		2003-01-29 00:00:00		2003-01-29 00:00:00		2004-07-19 00:00:00		2004-07-22 00:00:00		2004-08-27 00:00:00		2004-08-27 00:00:00		2005-01-25 00:00:00		2005-07-20 00:00:00		2005-01-27 00:00:00		2005-07-19 00:00:00		2006-01-17 00:00:00		2006-07-06 00:00:00		2006-07-10 00:00:00		2006-01-18 00:00:00		2006-11-02 00:00:00		2007-01-24 00:00:00		2006-11-02 00:00:00		2007-01-24 00:00:00		2014-07-07 00:00:00		2014-01-16 00:00:00		2015-01-28 00:00:00		2011-01-20 00:00:00		2010-01-20 00:00:00		2012-01-26 00:00:00		2012-01-26 00:00:00		2012-07-13 00:00:00		2014-01-21 00:00:00		2015-01-28 00:00:00		2015-01-28 00:00:00		2015-01-07 00:00:00		2014-07-10 00:00:00		2013-01-31 00:00:00		2013-01-28 00:00:00		2012-07-17 00:00:00		2016-01-19 00:00:00		2019-01-15 00:00:00		2018-07-12 00:00:00		2020-07-24 00:00:00		2020-07-24 00:00:00		2016-01-19 00:00:00		2016-07-18 00:00:00		2016-07-18 00:00:00		2016-10-31 00:00:00		2017-01-17 00:00:00		2017-01-17 00:00:00		2020-09-30 00:00:00		2018-07-12 00:00:00		2019-01-22 00:00:00		2021-02-01 00:00:00		2018-10-18 00:00:00		2018-01-09 00:00:00		2018-01-09 00:00:00		2020-02-18 00:00:00		2021-01-29 00:00:00		2021-07-07 00:00:00		2022-01-25 00:00:00		2022-01-25 00:00:00		2021-07-07 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10001		10005		10001		10005		10001		10002		10001		10006		10005		10001		10005		10006		10002		10001		10005		10005		10001		10001		10001		10005		10005		10001		10001		10005		10005		10001		10001		10005		10001		10005		10001		10005		10001		10005		10002		10001		10001		10005		10005		10001		10005		10001		10001		10001		10001		10005		10005		10005		10001		10001		10005		10001		10001		10005		10005		10005		10001		10005		10001		10001		10001		10001		10005		10001		10005
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		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		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001
session_id		1989		1989		1995		1995		1995		1995		1997		1997		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2005		2003		2005		2005		2005		2005		2005		2005		2005		2007		2005		2013		2013		2013		2009		2009		2011		2011		2011		2013		2015		2013		2015		2013		2011		2011		2011		2015		2017		2017		2019		2019		2015		2015		2015		2015		2015		2015		2019		2017		2019		2021		2017		2017		2017		2019		2019		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		EMCENTEE		EMCENTEE		LTHIBAUL		*		BINTHAVO		*		LTHIBAUL		*		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		DHORRELL		DHORRELL		COMPLETED		COMPLETED		DHORRELL		DHORRELL		*		*		*		JMARTIN		RFARAIMO		*		*		CFLAGG		JMARTIN		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		RGEREMIA		WBROWN		JINGRAM		WBROWN		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		JINGRAM		JINGRAM		JINGRAM		GCLARA		JINGRAM		JINGRAM		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		LPALMER		LPALMER		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001
rpt_start		1990-01-01 00:00:00		1990-07-01 00:00:00		None		1996-01-01 00:00:00		1996-07-01 00:00:00		1996-01-01 00:00:00		1998-01-01 00:00:00		1998-07-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		None		2002-02-20 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		2005-01-01 00:00:00		2004-07-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2005-07-01 00:00:00		2006-11-02 00:00:00		2006-07-01 00:00:00		None		2006-07-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		2014-07-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2012-01-01 00:00:00		2013-01-01 00:00:00		2015-01-28 00:00:00		2014-07-01 00:00:00		2015-01-07 00:00:00		2014-01-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2012-01-01 00:00:00		2015-01-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2020-01-01 00:00:00		2020-01-01 00:00:00		2015-01-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-10-31 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2020-09-30 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2020-07-01 00:00:00		2018-10-18 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2020-02-18 00:00:00		2020-07-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00
rpt_end		1990-06-30 00:00:00		1990-12-31 00:00:00		None		1996-06-30 00:00:00		1996-12-31 00:00:00		1996-06-30 00:00:00		1998-06-30 00:00:00		1998-12-31 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		None		2002-02-20 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-12-31 00:00:00		2002-06-30 00:00:00		2002-12-31 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-06-30 00:00:00		2005-12-31 00:00:00		2006-11-02 00:00:00		2006-12-31 00:00:00		None		2006-12-31 00:00:00		2014-06-30 00:00:00		2013-12-31 00:00:00		2014-12-31 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2015-01-28 00:00:00		2014-12-31 00:00:00		2015-01-07 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		2012-06-30 00:00:00		2015-12-31 00:00:00		2018-12-31 00:00:00		2018-06-30 00:00:00		2020-06-30 00:00:00		2020-06-30 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-10-31 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2020-09-30 00:00:00		2018-06-30 00:00:00		2018-12-31 00:00:00		2020-12-31 00:00:00		2018-10-18 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2020-02-18 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2021-06-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		2002-01-10 00:00:00		None		2002-02-20 00:00:00		None		2002-07-16 00:00:00		2003-01-17 00:00:00		2003-01-27 00:00:00		None		None		2004-07-16 00:00:00		None		None		2004-08-26 00:00:00		2005-01-21 00:00:00		None		None		2005-07-18 00:00:00		2006-01-12 00:00:00		2006-06-30 00:00:00		None		None		2006-11-02 00:00:00		2007-01-15 00:00:00		None		None		2014-06-23 00:00:00		2014-01-09 00:00:00		None		2011-01-19 00:00:00		None		2012-01-24 00:00:00		None		2012-07-06 00:00:00		None		2015-01-28 00:00:00		2015-01-28 00:00:00		2015-01-07 00:00:00		None		None		2013-01-21 00:00:00		None		2016-01-13 00:00:00		2019-01-15 00:00:00		2018-07-09 00:00:00		2020-07-11 00:00:00		None		None		None		2016-07-12 00:00:00		2016-10-31 00:00:00		None		2017-01-17 00:00:00		2020-09-30 00:00:00		None		None		None		2018-10-18 00:00:00		None		2018-01-05 00:00:00		2020-02-18 00:00:00		2021-01-27 00:00:00		2021-07-01 00:00:00		None		2022-01-24 00:00:00		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		22001		None		None		22001		None		None		22001		22001		None		None		22001		22001		22001		None		None		22001		22001		None		None		22001		22001		None		22001		None		22001		None		22001		None		22001		22001		22001		None		None		22001		None		22001		22001		22001		22001		None		None		None		22001		22001		None		22001		22001		None		None		None		22001		None		22001		22001		22001		22001		None		22001		None

Table: filer_to_filer_type

filer_id		1012094
filer_type		10
active		Y
race		0
session_id		1989
category		0
category_type		40502
sub_category		0
effect_dt		1990-12-05 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		None
party_cd		None
county_cd		18026
district_cd		None

Table: filer_xref

filer_id		1012094
xref_id		490394
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		490394		490394		490394		490394
filer_id		1012094		1012094		1012094		1012094
filer_type		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		1990-12-05 00:00:00		1990-12-05 00:00:00		1990-12-05 00:00:00		1990-12-05 00:00:00
naml		CATERPILLAR, INC. AND AFFILIATED ENTITIES		CATERPILLAR, INC. AND AFFILIATED ENTITIES		CATERPILLAR, INC., INCLUDING AGGREGATED CONTRIBUTIONS		CATERPILLAR, INC., INCLUDING AGGREGATED CONTRIBUTIONS
namf		None		None		None		None
namt		None		None		None		None
nams		None		None		None		None
adr1		None		None		None		None
adr2		None		None		None		None
city		PEORIA		SPRINGFIELD		PEORIA		SPRINGFIELD
st		IL		IL		IL		IL
zip4		61629		62704		61629		62704
phon		3096755248		2177538050		3096755248		2177538050
fax		None		None		None		None
email		None		None		None		None

Table: filers

filer_id		1012094

Table: received_filings

filer_id		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094		1012094
filing_file_name		805248_0.cal		46522.cal		42923.cal		53072.cal		821811_0.cal		854664_0.cal		854664_1.cal		907608_0.cal		1023863_0.cal		1023863_1.cal		1075345_0.cal		1112708_0.cal		1142082_0.cal		1182818_0.cal		1218768_0.cal		1231118_0.cal		1671365_0.cal		1733595_0.cal		1562364_0.cal		1632020_0.cal		463723.cal		463852.cal		1923498_1.cal		1923498_0.cal		2453939_0.cal		2308424_0.cal		2507267_0.cal
received_date		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-02-21 00:00:00		2002-07-30 00:00:00		2003-01-28 00:00:00		2003-01-28 00:00:00		2004-07-19 00:00:00		2004-08-27 00:00:00		2005-01-25 00:00:00		2005-07-19 00:00:00		2006-01-17 00:00:00		2006-07-06 00:00:00		2006-11-02 00:00:00		2007-01-24 00:00:00		2012-07-13 00:00:00		2013-01-28 00:00:00		2011-01-20 00:00:00		2012-01-26 00:00:00		2015-01-28 00:00:00		2015-01-28 00:00:00		2015-01-28 00:00:00		2015-01-07 00:00:00		2020-02-18 00:00:00		2018-10-18 00:00:00		2020-09-30 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		805248		None		None		None		821811		854664		854664		907608		1023863		1023863		1075345		1112708		1142082		1182818		1218768		1231118		1671365		1733595		1562364		1632020		None		None		1923498		1923498		2453939		2308424		2507267
form_id		F461		None		None		None		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		None		None		F497		F497		F497		F497		F497
receive_comment		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted