Home

Filer ID: 1014967

Table: filer_address

filer_id		1014967		1014967
adrid		1014254		2529540
effect_dt		1998-05-23 00:00:00		2022-01-19 00:00:00
add_type		7051		7051
session_id		1997		2021

Table: filer_filings

filer_id		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967
filing_id		78363		78364		78365		78366		78367		78368		78369		78370		78360		78361		78362		205433		205434		205435		587791		593396		679330		673089		719708		762736		788002		792666		785783		805449		811789		856997		865470		888687		911374		885841		922826		963245		979797		964609		986998		1066900		1058444		1080803		1096487		1119647		1185534		1203564		1253027		1354919		1402924		2321019		2503815		2518210		2576811		2641588		2503815		2604983		2702860		2503815		2576811		2723745		2702860		2604983		2719230		2576811		2720139		2717879		2668435		2720968		2753375		2753379		2733342		2753382		2745680		2717879
period_id		156		156		156		153		156		156		155		157		154		153		155		156		156		156		None		None		None		None		163		None		None		None		167		168		None		169		None		None		171		172		None		173		176		None		None		None		180		177		None		None		None		None		None		None		None		236		None		244		None		247		None		247		249		None		None		251		249		247		251		None		251		None		None		251		252		252		252		252		252		None
form_id		F497		F497		F497		F465		F497		F497		F461		F461		F497		F461		F888		F497		F497		F465		F461		F465		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F497		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F497		F461		F461		F461		F497		F461		F461		F461		F497		F461		F497		F497		F461		F497		F461		F461		F497		F496		F496		F497		F496		F497		F461
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		0		0		0		0		2		2		0		1		1		0		0		0		0		0		0		0		0		0		0		0		1
filing_date		1998-10-21 00:00:00		1998-10-27 00:00:00		1998-10-30 00:00:00		1998-10-23 00:00:00		1998-10-28 00:00:00		1998-10-23 00:00:00		1999-02-01 00:00:00		1999-07-22 00:00:00		1998-05-22 00:00:00		1998-07-30 00:00:00		1998-09-22 00:00:00		1998-10-22 00:00:00		1998-10-29 00:00:00		1999-02-01 00:00:00		2000-01-22 00:00:00		2000-02-25 00:00:00		2000-10-27 00:00:00		2000-07-28 00:00:00		2001-01-31 00:00:00		2001-01-31 00:00:00		2001-10-10 00:00:00		2001-07-31 00:00:00		2001-10-10 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-07-31 00:00:00		2002-07-31 00:00:00		2002-10-31 00:00:00		2003-01-31 00:00:00		2002-10-31 00:00:00		2003-01-31 00:00:00		2003-10-10 00:00:00		2004-01-12 00:00:00		2003-10-14 00:00:00		2004-01-15 00:00:00		2004-10-30 00:00:00		2004-10-30 00:00:00		2005-01-31 00:00:00		2005-01-31 00:00:00		2005-08-01 00:00:00		2006-02-03 00:00:00		2006-07-31 00:00:00		2007-02-01 00:00:00		2008-07-31 00:00:00		2009-02-02 00:00:00		2018-10-31 00:00:00		2020-09-18 00:00:00		2020-10-19 00:00:00		2021-07-06 00:00:00		2022-01-28 00:00:00		2020-07-31 00:00:00		2021-08-05 00:00:00		2022-07-28 00:00:00		2020-12-17 00:00:00		2021-08-19 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2021-08-06 00:00:00		2022-09-12 00:00:00		2021-02-01 00:00:00		2022-09-14 00:00:00		2022-08-01 00:00:00		2022-01-27 00:00:00		2022-09-16 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-10-14 00:00:00		2022-11-08 00:00:00		2022-10-28 00:00:00		2022-09-30 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10005		10001		10005		10005		10005		10001		10001		10005		10001		10005		10005		10001		10001		10005		10001		10001		10005		10005		10005		10001		10001		10005		10005		10005		10005		10005		10005		10005		10001		10006		10001		10006		10001		10005		10001		10001		10006		10006		10001		10002		10002		10001		10005		10001		10005		10005		10001		10001		10001		10001		10001		10001		10006
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11003		11003		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11001
session_id		1997		1997		1997		1997		1997		1997		1997		1999		1997		1997		1997		1997		1997		1997		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2007		2007		2017		2019		2019		2021		2021		2019		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		BSMITH		TTHAM		BSMITH		ERUTH		*		ERUTH		DBARRICK		DBARRICK		*		*		LTHIBAUL		*		LTHIBAUL		KLARRY		COMPLETED		*		DBARRICK		COMPLETED		COMPLETED		DHORRELL		GKURIMOT		EMCENTEE		GKURIMOT		COMPLETED		DHORRELL		DHORRELL		KVANG		JMARTIN		JMARTIN		MGUERRA		JINGRAM		RGEREMIA		GTAYLOR		RGEREMIA		GTAYLOR		LPHEAV		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		GTAYLOR		CAFILER		CAFILER		GTAYLOR		CAFILER		GTAYLOR		LPHEAV		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		GTAYLOR
special_audit		11001		11001		11001		11001		11001		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11003		11003		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11001
rpt_start		None		None		None		1998-01-01 00:00:00		None		None		1998-07-01 00:00:00		1999-01-01 00:00:00		None		1998-01-01 00:00:00		None		None		None		1998-10-18 00:00:00		1999-07-01 00:00:00		2000-01-01 00:00:00		None		2000-01-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		None		2002-07-01 00:00:00		2002-10-31 00:00:00		2002-07-01 00:00:00		2003-01-01 00:00:00		2003-10-01 00:00:00		2003-01-01 00:00:00		2003-10-01 00:00:00		None		2004-10-30 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-07-01 00:00:00		2008-01-01 00:00:00		2008-07-01 00:00:00		2018-10-31 00:00:00		2020-01-01 00:00:00		2020-10-19 00:00:00		2020-07-01 00:00:00		2021-07-01 00:00:00		2020-01-01 00:00:00		2021-08-05 00:00:00		2022-01-01 00:00:00		2020-01-01 00:00:00		2020-07-01 00:00:00		2022-09-26 00:00:00		2022-01-01 00:00:00		2021-08-06 00:00:00		2022-09-12 00:00:00		2020-07-01 00:00:00		2022-09-14 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		2022-09-16 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-10-14 00:00:00		2022-11-08 00:00:00		2022-10-28 00:00:00		2022-01-01 00:00:00
rpt_end		None		None		None		1998-10-17 00:00:00		None		None		1998-12-31 00:00:00		1999-06-30 00:00:00		None		1998-06-30 00:00:00		None		None		None		1998-12-31 00:00:00		1999-12-31 00:00:00		2000-02-19 00:00:00		None		2000-06-30 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		None		2002-12-31 00:00:00		2002-10-31 00:00:00		2002-12-31 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		None		2004-10-30 00:00:00		2004-12-31 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-12-31 00:00:00		2008-06-30 00:00:00		2008-12-31 00:00:00		2018-10-31 00:00:00		2020-06-30 00:00:00		2020-10-19 00:00:00		2020-12-31 00:00:00		2021-12-31 00:00:00		2020-06-30 00:00:00		2021-08-05 00:00:00		2022-06-30 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		2022-09-26 00:00:00		2022-06-30 00:00:00		2021-08-06 00:00:00		2022-09-12 00:00:00		2020-12-31 00:00:00		2022-09-14 00:00:00		2022-06-30 00:00:00		2021-12-31 00:00:00		2022-09-16 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-10-14 00:00:00		2022-11-08 00:00:00		2022-10-28 00:00:00		2022-06-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2000-10-27 00:00:00		None		2001-01-31 00:00:00		None		None		None		2001-10-10 00:00:00		2002-01-10 00:00:00		None		2002-07-31 00:00:00		None		None		2003-01-24 00:00:00		2002-10-31 00:00:00		None		2003-10-04 00:00:00		2004-01-12 00:00:00		None		None		None		2004-10-30 00:00:00		2005-01-25 00:00:00		None		None		None		None		None		None		None		2018-10-31 00:00:00		None		2020-10-19 00:00:00		None		2022-01-28 00:00:00		None		2021-08-05 00:00:00		2022-07-28 00:00:00		None		None		2022-09-26 00:00:00		2022-09-26 00:00:00		2021-08-06 00:00:00		2022-09-12 00:00:00		None		2022-09-14 00:00:00		None		None		2022-09-16 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-10-14 00:00:00		2022-11-08 00:00:00		2022-10-28 00:00:00		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		None		22001		22001		None		None		None		22001		22001		None		None		None		None		None		None		None		22001		None		22006		None		22006		None		22006		22006		None		None		22006		22006		22006		22006		None		22006		None		None		22006		22006		22006		22006		22006		22006		None

Table: filer_to_filer_type

filer_id		1014967
filer_type		10
active		Y
race		0
session_id		1997
category		0
category_type		40502
sub_category		0
effect_dt		1998-05-23 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		None
party_cd		0
county_cd		18039
district_cd		0

Table: filer_xref

filer_id		1014967
xref_id		498479
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		498479		498479		498479		498479
filer_id		1014967		1014967		1014967		1014967
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		1998-05-23 00:00:00		1998-05-23 00:00:00		1998-05-23 00:00:00		1998-05-23 00:00:00
naml		TWENTY-NINE PALMS BAND OF MISSION INDIANS		TWENTY-NINE PALMS BAND OF MISSION INDIANS		TWENTY NINE PALMS BAND OF MISSION INDIANS		TWENTY NINE PALMS BAND OF MISSION INDIANS
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		COACHELLA		COACHELLA		COACHELLA		COACHELLA
st		CA		CA		CA		CA
zip4		922360000		92236-0000		922360000		92236-0000
phon		7607755566		7607755566		7607755566		7607755566
fax		None		None		None		None
email		None		None		None		None

Table: filers

filer_id		1014967

Table: received_filings

filer_id		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967		1014967
filing_file_name		719708_0.cal		29801.cal		30398.cal		30710.cal		785783_0.cal		805449_0.cal		856997_0.cal		885841_0.cal		911374_0.cal		963245_0.cal		979797_0.cal		1058444_0.cal		1080803_0.cal
received_date		2001-01-31 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-10-10 00:00:00		2002-01-10 00:00:00		2002-07-31 00:00:00		2002-10-31 00:00:00		2003-01-31 00:00:00		2003-10-10 00:00:00		2004-01-12 00:00:00		2004-10-30 00:00:00		2005-01-31 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		/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
filing_id		719708		None		None		None		785783		805449		856997		885841		911374		963245		979797		1058444		1080803
form_id		F461		None		None		None		F461		F461		F461		F497		F461		F461		F461		F497		F461
receive_comment		Filing accepted, but with warnings		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted