Home

Filer ID: 1358698

Table: cvr_lobby_disclosure

filing_id		1798103		1779026		1779026		1865703		1845619		1818652		1910108		1980319		1964082		1934403		1996781		2061277		2035972		2012408		2102096		2174045		2155879		2127814		2211060		2193496
amend_id		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615
sender_id		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212
filer_id		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698
entity_cd		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY
filer_naml		Ortega		Ortega		Ortega		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro
filer_namf		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth
filer_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
report_num		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2013-10-15 00:00:00		2013-08-29 00:00:00		2013-07-13 00:00:00		2014-07-16 00:00:00		2014-04-21 00:00:00		2014-01-23 00:00:00		2014-10-27 00:00:00		2015-07-23 00:00:00		2015-04-23 00:00:00		2015-01-13 00:00:00		2015-10-28 00:00:00		2016-07-28 00:00:00		2016-04-22 00:00:00		2016-01-28 00:00:00		2016-10-19 00:00:00		2017-07-25 00:00:00		2017-04-20 00:00:00		2017-01-26 00:00:00		2018-01-25 00:00:00		2017-10-26 00:00:00
from_date		2013-07-01 00:00:00		2013-06-05 00:00:00		2013-06-05 00:00:00		2014-04-01 00:00:00		2014-01-01 00:00:00		2013-10-01 00:00:00		2014-07-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2014-10-01 00:00:00		2015-07-01 00:00:00		2016-04-01 00:00:00		2016-01-01 00:00:00		2015-10-01 00:00:00		2016-07-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2016-10-01 00:00:00		2017-10-01 00:00:00		2017-07-01 00:00:00
thru_date		2013-09-30 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2014-06-30 00:00:00		2014-03-31 00:00:00		2013-12-31 00:00:00		2014-09-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2014-12-31 00:00:00		2015-09-30 00:00:00		2016-06-30 00:00:00		2016-03-31 00:00:00		2015-12-31 00:00:00		2016-09-30 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2016-12-31 00:00:00		2017-12-31 00:00:00		2017-09-30 00:00:00
cum_beg_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
firm_id		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212		1297212
firm_name		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299
firm_city		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland
firm_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
firm_zip4		94612		94612		94612		94612		94612		94612		94612		94612		94612		94612		94612		94612		94612		94612		94612		94612		94612		94612		94612		94612
firm_phon		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160
mail_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_date		2013-10-15 00:00:00		2013-07-13 00:00:00		2013-07-13 00:00:00		2014-07-16 00:00:00		2014-04-21 00:00:00		2014-01-23 00:00:00		2014-10-27 00:00:00		2015-07-23 00:00:00		2015-04-23 00:00:00		2015-01-13 00:00:00		2015-10-28 00:00:00		2016-07-28 00:00:00		2016-04-22 00:00:00		2016-01-28 00:00:00		2016-10-19 00:00:00		2017-07-25 00:00:00		2017-04-20 00:00:00		2017-01-26 00:00:00		2018-01-25 00:00:00		2017-10-26 00:00:00
sig_loc		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA
sig_naml		Ortega		Ortega		Lybarger		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro
sig_namf		Elizabeth		Elizabeth		Kathryn		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth
sig_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
prn_naml		Ortega		Ortega		Lybarger		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro
prn_namf		Elizabeth		Elizabeth		Kathryn		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth
prn_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_title		Lobbyist		Lobbyist		President		Lobbyist		Lobbyist		Lobbyist		Lobbyist		Lobbyist		Lobbyist		Lobbyist		Lobbyist		Lobbyist		Lobbyist		Lobbyist		Lobbyist		Lobbyist		Lobbyist		Lobbyist		Lobbyist		Lobbyist
nopart1_cb		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
nopart2_cb		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
part1_1_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
part1_2_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_n_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_y_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lby_actvty		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lobby_n_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lobby_y_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpcmte_nm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpcmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: cvr_registration

filing_id		1773025		1773025		1922345		1922345		2111349		2111349		2211589
amend_id		1		0		0		1		0		1		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F604		F604		F604		F604		F604		F604		F606
sender_id		1297212		1297212		1297212		1297212		1297212		1297212		1297212
filer_id		1358698		1358698		1358698		1358698		1358698		1358698		1358698
entity_cd		LBY		LBY		LBY		LBY		LBY		LBY		LBY
filer_naml		Ortega-Toro		Ortega		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro
filer_namf		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth
filer_namt		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None
report_num		001		000		000		001		000		001		000
rpt_date		2013-11-22 00:00:00		2013-06-06 00:00:00		2015-01-01 00:00:00		2015-02-27 00:00:00		2018-12-31 00:00:00		2017-06-30 00:00:00		2018-01-22 00:00:00
ls_beg_yr		2013		2013		2015		2015		2017		2017		2017
ls_end_yr		2014		2014		2016		2016		2018		2018		2018
qual_date		2013-06-05 00:00:00		2013-06-05 00:00:00		None		None		None		None		None
eff_date		None		None		None		None		None		None		2017-12-31 00:00:00
bus_city		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland		Oakland
bus_st		CA		CA		CA		CA		CA		CA		CA
bus_zip4		94612		94612		94612		94612		94612		94612		94612
bus_phon		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160		510 844-1160
bus_fax		None		None		None		None		None		None		None
bus_email		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
mail_city		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None
sig_date		2013-11-22 00:00:00		2013-06-27 00:00:00		2014-11-13 00:00:00		2015-02-27 00:00:00		2016-11-17 00:00:00		2017-06-30 00:00:00		2018-01-22 00:00:00
sig_loc		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA		Oakland CA
sig_naml		Ortega-Toro		Ortega		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro
sig_namf		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth
sig_namt		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None
prn_naml		Ortega-Toro		Ortega		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro		Ortega-Toro
prn_namf		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth		Elizabeth
prn_namt		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None
sig_title		None		None		None		None		None		None		Lobbyist
stmt_firm		None		None		None		None		None		None		None
ind_cb		None		None		None		None		None		None		None
bus_cb		None		None		None		None		None		None		None
trade_cb		None		None		None		None		None		None		None
oth_cb		None		None		None		None		None		None		None
a_b_name		None		None		None		None		None		None		None
a_b_city		None		None		None		None		None		None		None
a_b_st		None		None		None		None		None		None		None
a_b_zip4		None		None		None		None		None		None		None
descrip_1		None		None		None		None		None		None		None
descrip_2		None		None		None		None		None		None		None
c_less50		None		None		None		None		None		None		None
c_more50		None		None		None		None		None		None		None
ind_class		None		None		None		None		None		None		None
ind_descr		None		None		None		None		None		None		None
bus_class		None		None		None		None		None		None		None
bus_descr		None		None		None		None		None		None		None
auth_name		None		None		None		None		None		None		None
auth_city		None		None		None		None		None		None		None
auth_st		None		None		None		None		None		None		None
auth_zip4		None		None		None		None		None		None		None
lobby_int		None		None		None		None		None		None		None
influen_yn		None		None		None		None		None		None		None
firm_name		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299		American Federation of State, County and Municipal Employees Local 3299
newcert_cb		None		X		None		None		None		None		None
rencert_cb		None		None		X		None		X		None		None
complet_dt		2013-11-14 00:00:00		None		None		2015-02-26 00:00:00		None		2017-06-22 00:00:00		None
lby_reg_cb		X		X		X		X		X		X		None
lby_604_cb		None		None		None		None		None		None		None
st_leg_yn		None		None		None		None		None		None		None
st_agency		None		None		None		None		None		None		None
lobby_cb		None		None		None		None		None		None		None
l_firm_cb		None		None		None		None		None		None		None

Table: filer_address

filer_id		1358698		1358698		1358698
adrid		2411486		2290615		2337251
effect_dt		2017-01-01 00:00:00		2013-06-05 00:00:00		2015-01-01 00:00:00
add_type		7051		7051		7051
session_id		2017		2013		2015

Table: filer_ethics_class

filer_id		1358698		1358698		1358698
session_id		2013		2015		2017
ethics_date		2013-11-14 00:00:00		2015-02-26 00:00:00		2017-06-22 00:00:00

Table: filer_filings

filer_id		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698
filing_id		1779026		1779026		1980319		1922345		1964082		1865703		1803630		1798103		1773025		1773115		1922345		1952291		1910108		1773025		1818652		1926292		1934403		1845619		1996781		2012408		2035972		2061277		2102096		2127814		2111961		2111349		2155879		2174045		2111349		2164230		2211589		2212421		2211060		2193496
period_id		214		214		222		221		221		218		None		215		214		None		221		None		219		216		216		None		220		217		223		224		225		226		227		228		None		236		229		230		230		None		233		None		232		231
form_id		F615		F615		F615		F604		F615		F615		F604		F615		F604		F604		F604		F604		F615		F604		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F604		F615		F615		F604		F604		F606		F606		F615		F615
filing_sequence		0		1		0		1		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0
filing_date		2013-07-26 00:00:00		2013-08-29 00:00:00		2015-07-30 00:00:00		2015-03-25 00:00:00		2015-04-29 00:00:00		2014-07-23 00:00:00		2013-11-14 00:00:00		2013-10-28 00:00:00		2013-06-27 00:00:00		2013-06-27 00:00:00		2014-12-31 00:00:00		2015-02-26 00:00:00		2014-10-30 00:00:00		2013-11-22 00:00:00		2014-01-31 00:00:00		2014-12-31 00:00:00		2015-01-30 00:00:00		2014-04-30 00:00:00		2015-10-30 00:00:00		2016-02-01 00:00:00		2016-04-29 00:00:00		2016-07-29 00:00:00		2016-10-31 00:00:00		2017-01-30 00:00:00		2016-12-15 00:00:00		2016-12-15 00:00:00		2017-04-28 00:00:00		2017-07-28 00:00:00		2017-07-06 00:00:00		2017-06-22 00:00:00		2018-01-31 00:00:00		2018-01-31 00:00:00		2018-01-31 00:00:00		2017-10-31 00:00:00
stmnt_type		10001		10002		10001		10002		10001		10001		10006		10001		10001		10005		10001		10006		10001		10002		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10002		10006		10001		10005		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001
session_id		2013		2013		2015		2015		2015		2013		2013		2013		2013		2013		2015		2015		2013		2013		2013		2015		2013		2013		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017
user_id		AGLADNEY		AGLADNEY		JINGRAM		GPEREZ		MPACHECO		AGLADNEY		SMCCONNAN		AGLADNEY		YRODRIGU		YRODRIGU		GPEREZ		ASAETERN		AGLADNEY		PBANFORD		ASAETERN		ASAETERN		MPACHECO		AGLADNEY		JINGRAM		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		SARRIAGA		GPEREZ		SMCCONNAN		SMCCONNAN		PBANFORD		PBANFORD		GPEREZ		GPEREZ		AGLADNEY		AGLADNEY
special_audit		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		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11003		11001		11001
rpt_start		2013-06-05 00:00:00		2013-06-05 00:00:00		2015-04-01 00:00:00		2015-02-27 00:00:00		2015-01-01 00:00:00		2014-04-01 00:00:00		1900-01-01 00:00:00		2013-07-01 00:00:00		2013-06-06 00:00:00		1900-01-01 00:00:00		2015-01-01 00:00:00		None		2014-07-01 00:00:00		2013-11-22 00:00:00		2013-10-01 00:00:00		1900-01-01 00:00:00		2014-10-01 00:00:00		2014-01-01 00:00:00		2015-07-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		1900-01-01 00:00:00		2018-12-31 00:00:00		2017-01-01 00:00:00		2017-04-01 00:00:00		2017-06-30 00:00:00		1900-01-01 00:00:00		2018-01-22 00:00:00		1900-01-01 00:00:00		2017-10-01 00:00:00		2017-07-01 00:00:00
rpt_end		2013-06-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2015-02-27 00:00:00		2015-03-31 00:00:00		2014-06-30 00:00:00		1900-01-01 00:00:00		2013-09-30 00:00:00		2013-06-06 00:00:00		1900-01-01 00:00:00		2015-01-01 00:00:00		None		2014-09-30 00:00:00		2013-11-22 00:00:00		2013-12-31 00:00:00		1900-01-01 00:00:00		2014-12-31 00:00:00		2014-03-31 00:00:00		2015-09-30 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		1900-01-01 00:00:00		2018-12-31 00:00:00		2017-03-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		1900-01-01 00:00:00		2018-01-22 00:00:00		1900-01-01 00:00:00		2017-12-31 00:00:00		2017-09-30 00:00:00
rpt_date		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		None		None		None		None		None		None
filing_type		22001		22001		22001		22001		22001		22001		None		22001		22001		None		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		22001		None		22001		22001

Table: filer_to_filer_type

filer_id		1358698		1358698		1358698		1358698
filer_type		4		4		4		4
active		Y		Y		T		Y
race		0		None		None		None
session_id		2013		2015		2017		2017
category		0		None		None		None
category_type		0		None		None		None
sub_category		0		None		None		None
effect_dt		2013-06-05 00:00:00		2015-01-01 00:00:00		2017-12-31 00:00:00		2017-01-01 00:00:00
sub_category_type		0		None		None		None
election_type		0		None		None		None
sub_category_a		None		None		None		None
nyq_dt		None		None		None		None
party_cd		0		None		None		None
county_cd		0		None		None		None
district_cd		0		None		None		None

Table: filer_xref

filer_id		1358698
xref_id		1358698
effect_dt		2013-06-27 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698
filer_id		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698
filer_type		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST
status		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED
effect_dt		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00
naml		ORTEGA-TORO		ORTEGA-TORO		ORTEGA-TORO		ORTEGA-TORO		ORTEGA-TORO		ORTEGA-TORO		ORTEGA		ORTEGA		ORTEGA
namf		ELIZABETH		ELIZABETH		ELIZABETH		ELIZABETH		ELIZABETH		ELIZABETH		ELIZABETH		ELIZABETH		ELIZABETH
namt		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None
city		OAKLAND		OAKLAND		OAKLAND		OAKLAND		OAKLAND		OAKLAND		OAKLAND		OAKLAND		OAKLAND
st		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		94612		94612		94612		94612		94612		94612		94612		94612		94612
phon		5108441160		5108441160		5108441160		5108441160		5108441160		5108441160		5108441160		5108441160		5108441160
fax		None		None		None		None		None		None		None		None		None
email		None		[email protected]		[email protected]		None		[email protected]		[email protected]		None		[email protected]		[email protected]

Table: filers

filer_id		1358698

Table: lobbying_chg_log

filer_id		1358698		1358698		1358698		1358698
change_no		1		2		3		5
session_id		2013		2017		2017		2017
log_dt		2013-07-19 00:00:00		2016-12-15 00:00:00		2016-12-15 00:00:00		2018-01-31 00:00:00
filer_type		4		4		4		4
correction_flg		None		None		None		Y
action		SET ACTIVE		REVOKE		IN SUSPENSE		TERMINATED
attribute_changed		EMPLOYER				EMPLOYER		EMPLOYER
ethics_dt		None		None		None		None
interests		None		None		None		None
filer_full_name		ELIZABETH ORTEGA		ORTEGA-TORO, ELIZABETH		ORTEGA-TORO, ELIZABETH		ORTEGA-TORO, ELIZABETH
filer_city		None		None		None		None
filer_st		None		None		None		None
filer_zip		None		None		None		None
filer_phone		None		None		None		None
entity_type		2		4		2		2
entity_name		AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES LOCAL 3299		None		AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES LOCAL 3299		AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES LOCAL 3299
entity_city		None		None		None		None
entity_st		None		None		None		None
entity_zip		None		None		None		None
entity_phone		None		None		None		None
entity_id		1297212		0		1297212		1297212
responsible_officer		None		None		None		None
effect_dt		2013-06-05 00:00:00		2017-07-01 00:00:00		2017-07-01 00:00:00		2017-12-31 00:00:00

Table: received_filings

filer_id		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698		1358698
filing_file_name		1845619_0.cal		1779026_1.cal		1773025_1.cal		1798103_0.cal		1818652_0.cal		1773025_0.cal		1779026_0.cal		1865703_0.cal		2127814_0.cal		2174045_0.cal		2111349_1.cal		2155879_0.cal		1996781_0.cal		2012408_0.cal		2102096_0.cal		2111349_0.cal		1910108_0.cal		1964082_0.cal		1922345_0.cal		1922345_1.cal		2035972_0.cal		2061277_0.cal		1934403_0.cal		1980319_0.cal		2211589_0.cal		2211060_0.cal		2193496_0.cal
received_date		2014-04-30 00:00:00		2013-08-29 00:00:00		2013-11-22 00:00:00		2013-10-28 00:00:00		2014-01-31 00:00:00		2013-06-27 00:00:00		2013-07-26 00:00:00		2014-07-23 00:00:00		2017-01-30 00:00:00		2017-07-28 00:00:00		2017-07-06 00:00:00		2017-04-28 00:00:00		2015-10-30 00:00:00		2016-02-01 00:00:00		2016-10-31 00:00:00		2016-12-15 00:00:00		2014-10-30 00:00:00		2015-04-29 00:00:00		2014-12-31 00:00:00		2015-03-25 00:00:00		2016-04-29 00:00:00		2016-07-29 00:00:00		2015-01-30 00:00:00		2015-07-30 00:00:00		2018-01-31 00:00:00		2018-01-31 00:00:00		2017-10-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		/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		1845619		1779026		1773025		1798103		1818652		1773025		1779026		1865703		2127814		2174045		2111349		2155879		1996781		2012408		2102096		2111349		1910108		1964082		1922345		1922345		2035972		2061277		1934403		1980319		2211589		2211060		2193496
form_id		F615		F615		F604		F615		F615		F604		F615		F615		F615		F615		F604		F615		F615		F615		F615		F604		F615		F615		F604		F604		F615		F615		F615		F615		F606		F615		F615
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		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