Home

Filer ID: 1396292

Table: filer_address

filer_id		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292
adrid		2431941		2516645		2479149		2480421		2480420		2453583		2453582		2451616		2451615		2439852
effect_dt		2017-05-01 00:00:00		2021-03-04 00:00:00		2019-02-28 00:00:00		2019-05-09 00:00:00		2019-05-09 00:00:00		2018-05-07 00:00:00		2018-05-07 00:00:00		2018-03-29 00:00:00		2018-03-19 00:00:00		2017-08-15 00:00:00
add_type		7051		7051		7082		7051		7082		7082		7051		7082		7082		7051
session_id		2017		2021		2019		2019		2019		2017		2017		2017		2017		2017

Table: filer_filings

filer_id		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292
filing_id		2367305		2321404		2371452		2367915		2378694		2158378		2226626		2181612		2365725		2383992		2228003		2421941		2396354		2248491		2224270		2633106		2563480
period_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
form_id		F460		F460		F450		F460		F460		F410		F450		F410		F410		F410		F410		F460		F410		F410		F410		F450		F410
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		2019-02-27 00:00:00		2018-10-25 00:00:00		2019-02-27 00:00:00		2019-02-27 00:00:00		2019-04-24 00:00:00		2017-05-01 00:00:00		2018-03-26 00:00:00		2017-08-15 00:00:00		2019-02-28 00:00:00		2019-05-09 00:00:00		2018-03-29 00:00:00		2019-10-28 00:00:00		2019-07-26 00:00:00		2018-05-07 00:00:00		2018-03-19 00:00:00		2018-03-19 00:00:00		2021-03-04 00:00:00
stmnt_type		10005		10005		10005		10005		10005		10005		10005		10006		10006		10006		10006		10005		10006		10006		10006		10005		10006
stmnt_status		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001
session_id		2017		2017		2017		2017		2019		2017		2017		2017		2019		2019		2017		2019		2019		2017		2017		2017		2021
user_id		LPHEAV		LPHEAV		CSAGABAEN		LPHEAV		JFONSECA		CPON		CPON		TRAMON		TRAMON		TRAMON		TRAMON		LPHEAV		TRAMON		TRAMON		TRAMON		SBURHAN		IMEDINA
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003
rpt_start		2018-01-01 00:00:00		2018-03-16 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2019-01-01 00:00:00		None		2017-04-24 00:00:00		None		None		None		None		2019-07-01 00:00:00		None		None		None		None		None
rpt_end		2018-06-30 00:00:00		2018-10-25 00:00:00		2018-12-31 00:00:00		2018-12-31 00:00:00		2019-03-31 00:00:00		None		2018-03-15 00:00:00		None		None		None		None		2019-09-30 00:00:00		None		None		None		None		None
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_to_filer_type

filer_id		1396292		1396292		1396292
filer_type		16		16		16
active		Y		Y		Y
race		0		0		0
session_id		2017		2019		2017
category		0		0		0
category_type		40502		40505		40502
sub_category		40103		40103		40103
effect_dt		2017-05-01 00:00:00		2019-05-09 00:00:00		2017-08-15 00:00:00
sub_category_type		0		0		0
election_type		0		0		0
sub_category_a		None		None		None
nyq_dt		None		2017-04-24 00:00:00		2017-04-24 00:00:00
party_cd		0		0		0
county_cd		18044		18044		18044
district_cd		0		0		0

Table: filer_xref

filer_id		1396292
xref_id		1396292
effect_dt		2017-05-02 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292
filer_id		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292		1396292
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2019-05-09 00:00:00		2019-05-09 00:00:00		2019-05-09 00:00:00		2019-05-09 00:00:00		2019-05-09 00:00:00		2019-05-09 00:00:00		2019-05-09 00:00:00		2019-05-09 00:00:00		2019-05-09 00:00:00		2019-05-09 00:00:00
naml		DEMOCRATIC CLUB OF MANTECA; THE		DEMOCRATIC CLUB OF MANTECA; THE		DEMOCRATIC CLUB OF MANTECA; THE		DEMOCRATIC CLUB OF MANTECA; THE		DEMOCRATIC CLUB OF MANTECA; THE		DEMOCRATIC CLUB OF MANTECA; THE		DEMOCRATIC CLUB OF MANTECA; THE		DEMOCRATIC CLUB OF MANTECA; THE		DEMOCRATIC CLUB OF MANTECA; THE		DEMOCRATIC CLUB OF MANTECA; THE
namf		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None
city		MANTECA		RIPON		MANTECA		MANTECA		MANTECA		MANTECA		MANTECA		MANTECA		MANTECA		MANTECA
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		95337		95366		95336		95336		95336		95336		95336		95336		95336		95336
phon		2095708797		2095996217				2092759537		2096472744				2092759537		2092759537		2092759537		5597322554
fax		None		None		None		None		None		None		None		None		None		None
email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1396292