Home

Filer ID: 1010356

Table: filer_address

filer_id		1010356		1010356
adrid		1009652		2514129
effect_dt		2008-01-30 00:00:00		2021-03-04 00:00:00
add_type		7051		7051
session_id		2007		2021

Table: filer_filings

filer_id		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356
filing_id		65112		65113		65114		65115		65116		65111		824698		832551		843108		917483		954368		1007369		1038457		1095494		1137749		1188488		1202806		1185630		1211740		1253892		1236240		1274765		1784274		1312884		1547674		1572946		1814544		1827037		1933515		1889563		2520231		2182078		2463368		2582786		2221204		2514754		2438915		2516771		2563225		2580118		2553606		2421597		2600327		2648241		2716708		2713256		2716139		2643970		2684601		2721976		2607753		2711047		2740014		2744445		2711047		2736735
period_id		127		130		130		129		131		121		None		None		None		None		None		None		None		None		None		185		None		None		188		None		187		None		None		None		None		None		215		None		None		219		244		None		None		None		None		244		240		None		None		245		243		None		246		None		251		251		251		247		250		251		None		None		252		252		None		252
form_id		F777		F497		F497		F461		F461		F461		F497		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F497		F461		F461		F497		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F497		F461		F497		F497		F461		F461		F497		F497		F461		F497
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		0		0		0		0		0		0		0		0		1		0
filing_date		1991-07-12 00:00:00		1992-05-19 00:00:00		1992-05-21 00:00:00		1992-07-31 00:00:00		1993-01-29 00:00:00		1991-01-31 00:00:00		2002-02-20 00:00:00		2002-02-28 00:00:00		2002-02-28 00:00:00		2003-01-31 00:00:00		2003-07-31 00:00:00		2004-01-12 00:00:00		2004-08-02 00:00:00		2005-01-27 00:00:00		2005-10-31 00:00:00		2006-07-27 00:00:00		2006-07-27 00:00:00		2006-01-31 00:00:00		2006-10-25 00:00:00		2007-01-30 00:00:00		2007-01-30 00:00:00		2006-10-25 00:00:00		2013-07-26 00:00:00		2008-01-30 00:00:00		2010-10-23 00:00:00		2011-01-25 00:00:00		2014-01-28 00:00:00		2014-01-28 00:00:00		2015-01-27 00:00:00		2014-09-29 00:00:00		2020-10-21 00:00:00		2017-07-28 00:00:00		2020-01-29 00:00:00		2021-04-28 00:00:00		2018-01-24 00:00:00		2020-10-13 00:00:00		2020-01-29 00:00:00		2020-07-28 00:00:00		2021-02-01 00:00:00		2021-04-30 00:00:00		2021-02-01 00:00:00		2019-10-30 00:00:00		2021-07-30 00:00:00		2022-01-31 00:00:00		2022-09-01 00:00:00		2022-08-22 00:00:00		2022-08-31 00:00:00		2022-01-31 00:00:00		2022-05-20 00:00:00		2022-09-20 00:00:00		2021-07-30 00:00:00		2022-07-27 00:00:00		2022-10-24 00:00:00		2022-10-27 00:00:00		2022-10-26 00:00:00		2022-10-19 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10001		10005		10005		10001		10005		10001		10005		10005		10005		10005		10005		10001		10005		10005		10001		10001		10005		10005		10005		10005		10001		10001		10005		10005		10001		10001		10005		10001		10005		10001		10001		10001		10001		10001		10001		10005		10005		10001		10001		10006		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11001		11001		11003		11003		11001		11003
session_id		1991		1991		1991		1991		1991		1989		2001		2001		2001		2001		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2013		2007		2009		2009		2013		2013		2013		2013		2019		2017		2019		2021		2017		2019		2019		2019		2021		2021		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		BINTHAVO		RALLMOND		RALLMOND		DHORRELL		GGILMORE		DHORRELL		DHORRELL		DHORRELL		DHORRELL		*		JMARTIN		KVANG		DHORRELL		JMARTIN		SMCCABE		CFLAGG		JINGRAM		SMCCABE		MPACHECO		JINGRAM		JINGRAM		JINGRAM		JINGRAM		CAFILER		CAFILER		LPALMER		GTAYLOR		GTAYLOR		DMCCASTL		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		CAFILER		CAFILER		GTAYLOR		CAFILER		CAFILER		GTAYLOR		GTAYLOR		CAFILER		CAFILER		GTAYLOR		CAFILER
special_audit		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
fine_audit		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11001		11001		11003		11003		11001		11003
rpt_start		None		None		None		1992-01-01 00:00:00		1992-07-01 00:00:00		1990-01-01 00:00:00		None		None		None		2002-01-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		2005-01-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2005-10-01 00:00:00		2006-10-25 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		None		2013-01-01 00:00:00		2007-01-01 00:00:00		2010-10-22 00:00:00		2010-01-01 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2014-01-01 00:00:00		2014-09-29 00:00:00		2020-10-21 00:00:00		2017-01-01 00:00:00		2019-10-01 00:00:00		2021-01-01 00:00:00		2017-07-01 00:00:00		2020-10-13 00:00:00		2019-10-01 00:00:00		2020-01-01 00:00:00		2020-07-01 00:00:00		2021-01-01 00:00:00		2020-07-01 00:00:00		2019-01-01 00:00:00		2021-04-01 00:00:00		2021-07-01 00:00:00		2022-09-01 00:00:00		2022-08-22 00:00:00		2022-08-31 00:00:00		2021-07-01 00:00:00		2022-05-20 00:00:00		2022-09-20 00:00:00		2021-04-01 00:00:00		2022-01-01 00:00:00		2022-10-24 00:00:00		2022-10-27 00:00:00		2022-01-01 00:00:00		2022-10-19 00:00:00
rpt_end		None		None		None		1992-06-30 00:00:00		1992-12-31 00:00:00		1990-12-31 00:00:00		None		None		None		2002-12-31 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-12-31 00:00:00		2005-09-30 00:00:00		2006-06-30 00:00:00		2006-06-30 00:00:00		2005-12-31 00:00:00		2006-10-25 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		None		2013-06-30 00:00:00		2007-12-31 00:00:00		2010-10-22 00:00:00		2010-12-31 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2014-12-31 00:00:00		2014-09-29 00:00:00		2020-10-21 00:00:00		2017-06-30 00:00:00		2019-12-31 00:00:00		2021-03-31 00:00:00		2017-12-31 00:00:00		2020-10-13 00:00:00		2019-12-31 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		2021-03-31 00:00:00		2020-12-31 00:00:00		2019-09-30 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2022-09-01 00:00:00		2022-08-22 00:00:00		2022-08-31 00:00:00		2021-12-31 00:00:00		2022-05-20 00:00:00		2022-09-20 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00		2022-10-24 00:00:00		2022-10-27 00:00:00		2022-06-30 00:00:00		2022-10-19 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2006-07-27 00:00:00		None		None		2006-10-25 00:00:00		None		2007-01-30 00:00:00		None		None		None		None		None		2014-01-28 00:00:00		None		None		2014-09-29 00:00:00		2020-10-21 00:00:00		None		None		None		None		2020-10-13 00:00:00		2020-01-28 00:00:00		None		None		2021-04-27 00:00:00		2021-01-29 00:00:00		None		2021-07-21 00:00:00		None		2022-09-01 00:00:00		2022-08-22 00:00:00		2022-08-31 00:00:00		2022-01-26 00:00:00		2022-05-20 00:00:00		2022-09-20 00:00:00		None		None		2022-10-24 00:00:00		2022-10-27 00:00:00		None		2022-10-19 00:00:00
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		None		22001		None		22001		None		None		None		None		None		22001		None		None		22001		22001		None		None		None		None		22001		22001		None		None		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		None		None		22001		22001		None		22001

Table: filer_to_filer_type

filer_id		1010356
filer_type		10
active		Y
race		0
session_id		2007
category		0
category_type		40502
sub_category		0
effect_dt		1990-12-01 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		None
party_cd		None
county_cd		18034
district_cd		None

Table: filer_xref

filer_id		1010356
xref_id		484396
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		484396		484396
filer_id		1010356		1010356
filer_type		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status		ACTIVE		ACTIVE
effect_dt		1990-12-01 00:00:00		1990-12-01 00:00:00
naml		TSAKOPOULOS, SOFIA		TSAKOPOULOS, SOFIA
namf		None		None
namt		None		None
nams		None		None
adr1		None		None
adr2		None		None
city		SACRAMENTO		SACRAMENTO
st		CA		CA
zip4		958260000		958260000
phon		9163832500		9163832500
fax		None		None
email		None		None

Table: filers

filer_id		1010356

Table: received_filings

filer_id		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356		1010356
filing_file_name		1188488_0.cal		1211740_0.cal		1236240_0.cal		1889563_0.cal		2520231_0.cal		2736735_0.cal		2514754_0.cal		2740014_0.cal		2684601_0.cal		2721976_0.cal		2713256_0.cal		2716708_0.cal		2744445_0.cal		2716139_0.cal
received_date		2006-07-27 00:00:00		2006-10-25 00:00:00		2007-01-30 00:00:00		2014-09-29 00:00:00		2020-10-21 00:00:00		2022-10-19 00:00:00		2020-10-13 00:00:00		2022-10-24 00:00:00		2022-05-20 00:00:00		2022-09-20 00:00:00		2022-08-22 00:00:00		2022-09-01 00:00:00		2022-10-27 00:00:00		2022-08-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
filing_id		1188488		1211740		1236240		1889563		2520231		2736735		2514754		2740014		2684601		2721976		2713256		2716708		2744445		2716139
form_id		F461		F497		F461		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497
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