Home

Filer ID: 1402491

Table: filer_address

filer_id		1402491		1402491		1402491
adrid		2451579		2446055		2446057
effect_dt		2018-03-16 00:00:00		2018-02-12 00:00:00		2018-02-12 00:00:00
add_type		7051		7051		7082
session_id		2017		2017		2017

Table: filer_filings

filer_id		1402491		1402491		1402491		1402491
filing_id		2216442		2215965		2352604		2224253
period_id		None		None		None		None
form_id		F999		F410		F410		F410
filing_sequence		0		0		0		0
filing_date		2018-02-12 00:00:00		2018-02-12 00:00:00		2019-01-30 00:00:00		2018-03-16 00:00:00
stmnt_type		10005		10005		10003		10006
stmnt_status		11001		11001		11001		11001
session_id		2017		2017		2019		2017
user_id		GPEREZ		GPEREZ		PADAMS		TRAMON
special_audit		11003		11003		11003		11003
fine_audit		11003		11003		11003		11003
rpt_start		1900-01-01 00:00:00		None		None		None
rpt_end		1900-01-01 00:00:00		None		None		None
rpt_date		None		None		None		None
filing_type		None		None		None		None

Table: filer_to_filer_type

filer_id		1402491		1402491		1402491
filer_type		16		16		16
active		Y		T		Y
race		0		0		0
session_id		2017		2017		2017
category		40002		40002		40002
category_type		40503		40503		40503
sub_category		0		0		0
effect_dt		2018-02-12 00:00:00		2018-12-28 00:00:00		2018-03-16 00:00:00
sub_category_type		0		0		0
election_type		0		0		0
sub_category_a		None		None		None
nyq_dt		None		2018-03-06 00:00:00		2018-03-06 00:00:00
party_cd		0		0		0
county_cd		18005		18005		18005
district_cd		0		0		0

Table: filer_xref

filer_id		1402491
xref_id		1402491
effect_dt		2018-02-15 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1402491		1402491		1402491
filer_id		1402491		1402491		1402491
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		TERMINATED		TERMINATED		TERMINATED
effect_dt		2018-12-28 00:00:00		2018-12-28 00:00:00		2018-12-28 00:00:00
naml		GREENE SHASTA COUNTY SHERIFF 2018, COMMITTEE TO ELECT JOHN		GREENE SHASTA COUNTY SHERIFF 2018, COMMITTEE TO ELECT JOHN		GREENE SHASTA COUNTY SHERIFF 2018, COMMITTEE TO ELECT JOHN
namf		None		None		None
namt		None		None		None
nams		None		None		None
adr1		None		None		None
adr2		None		None		None
city		ANDERSON		ANDERSON		ANDERSON
st		CA		CA		CA
zip4		96007		96007		96007
phon		5304101557				5304101557
fax		None		None		None
email		[email protected]		None		[email protected]

Table: filers

filer_id		1402491