filing_id | 1799401 | 1780022 | 1815988 | 1870536 | 1844011 | 1909873 | 1981661 | 1962783 | 1936673 | 2007155 | 1997133 | 2063879 | 2038276 | 2102590 | 2158079 | 2131257 | 2184706 | 2177280 | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 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 | ||||||||||||||||||
form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||
sender_id | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | E00246 | E00246 | E00246 | E00246 | E00246 | E00246 | E00246 | ||||||||||||||||||
filer_id | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | ||||||||||||||||||
entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | LBY | LBY | LBY | LBY | LBY | LBY | LBY | ||||||||||||||||||
filer_naml | FRANCIS | FRANCIS | FRANCIS | FRANCIS | FRANCIS | FRANCIS | FRANCIS | FRANCIS | FRANCIS | FRANCIS | FRANCIS | Francis | Francis | Francis | Francis | Francis | Francis | Francis | ||||||||||||||||||
filer_namf | LISHAUN | LISHAUN | LISHAUN F. | LISHAUN F. | LISHAUN F. | LISHAUN F. | LISHAUN | LISHAUN | LISHAUN | LISHAUN | LISHAUN | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | ||||||||||||||||||
filer_namt | 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 | ||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | ||||||||||||||||||
rpt_date | 2013-10-30 00:00:00 | 2013-07-29 00:00:00 | 2014-01-30 00:00:00 | 2014-07-30 00:00:00 | 2014-04-29 00:00:00 | 2014-10-30 00:00:00 | 2015-07-31 00:00:00 | 2015-04-27 00:00:00 | 2015-02-02 00:00:00 | 2016-01-26 00:00:00 | 2015-10-30 00:00:00 | 2016-08-01 00:00:00 | 2016-04-29 00:00:00 | 2016-10-31 00:00:00 | 2017-05-01 00:00:00 | 2017-01-31 00:00:00 | 2017-07-14 00:00:00 | 2017-07-28 00:00:00 | ||||||||||||||||||
from_date | 2013-07-01 00:00:00 | 2013-06-01 00:00:00 | 2013-10-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-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-10-01 00:00:00 | 2015-07-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2016-07-01 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | ||||||||||||||||||
thru_date | 2013-09-30 00:00:00 | 2013-06-30 00:00:00 | 2013-12-31 00:00:00 | 2014-06-30 00:00:00 | 2014-03-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-12-31 00:00:00 | 2015-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2016-09-30 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 2017-07-14 00:00:00 | 2017-06-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 | ||||||||||||||||||
firm_id | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | E00246 | E00246 | E00246 | E00246 | E00246 | E00246 | E00246 | ||||||||||||||||||
firm_name | California Medical Association | California Medical Association | CALIFORNIA MEDICAL ASSOCIATION | California Medical Association | California Medical Association | California Medical Association | California Medical Association | California Medical Association | California Medical Association | California Medical Association | California Medical Association | California Medical Association | California Medical Association | California Medical Association | California Medical Association | California Medical Association | California Medical Association | California Medical Association | ||||||||||||||||||
firm_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | ||||||||||||||||||
firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||
firm_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||
firm_phon | 9164445532 | 9164445532 | 9165512554 | 9165512554 | 9165512554 | 9165512554 | 9165512554 | 9165512554 | 9165512554 | 9165512554 | 9165512554 | 916-551-2554 | 916-551-2554 | 916-551-2554 | 916-551-2554 | 916-551-2554 | 916-551-2554 | 916-551-2554 | ||||||||||||||||||
mail_city | 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 | ||||||||||||||||||
mail_zip4 | 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 | ||||||||||||||||||
sig_date | 2013-10-30 00:00:00 | 2013-07-29 00:00:00 | 2014-01-30 00:00:00 | 2014-07-30 00:00:00 | 2014-04-29 00:00:00 | 2014-10-30 00:00:00 | 2015-07-31 00:00:00 | 2015-04-27 00:00:00 | 2015-02-02 00:00:00 | 2016-01-26 00:00:00 | 2015-10-30 00:00:00 | 2016-08-01 00:00:00 | 2016-04-29 00:00:00 | 2016-10-31 00:00:00 | 2017-04-28 00:00:00 | 2017-01-31 00:00:00 | 2017-09-06 00:00:00 | 2017-07-28 00:00:00 | ||||||||||||||||||
sig_loc | Sacramento, CA | Sacramento, CA | SACRAMENTO, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, Ca | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | ||||||||||||||||||
sig_naml | Francis | Francis | FRANCIS | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | ||||||||||||||||||
sig_namf | Lishaun | Lishaun | LISHAUN | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | ||||||||||||||||||
sig_namt | 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 | ||||||||||||||||||
prn_naml | Francis | Francis | FRANCIS | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | Francis | ||||||||||||||||||
prn_namf | Lishaun | Lishaun | LISHAUN | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | Lishaun | ||||||||||||||||||
prn_namt | 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 | ||||||||||||||||||
sig_title | Associate Director | Associate Director | ASSOCIATE DIRECTOR | Associate Director | Associate Director | Associate Director | Associate Director | Associate Director | Associate Director | Associate Director | Associate Director | 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 | ||||||||||||||||||
nopart2_cb | 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 | ||||||||||||||||||
part1_2_cb | 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 | ||||||||||||||||||
ctrib_y_cb | 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 | ||||||||||||||||||
lobby_n_cb | 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 | ||||||||||||||||||
major_naml | 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 | ||||||||||||||||||
major_namt | 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 | ||||||||||||||||||
rcpcmte_nm | 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 |
filing_id | 2112744 | 2112744 | 2184703 | |||
---|---|---|---|---|---|---|
amend_id | 0 | 1 | 0 | |||
rec_type | CVR | CVR | CVR | |||
form_type | F604 | F604 | F606 | |||
sender_id | E00246 | E00246 | E00246 | |||
filer_id | 1358450 | 1358450 | 1358450 | |||
entity_cd | LBY | LBY | LBY | |||
filer_naml | Francis | Francis | Francis | |||
filer_namf | Lishaun | Lishaun | Lishaun | |||
filer_namt | None | None | None | |||
filer_nams | None | None | None | |||
report_num | 000 | 001 | 000 | |||
rpt_date | 2018-12-31 00:00:00 | 2017-02-10 00:00:00 | 2017-07-14 00:00:00 | |||
ls_beg_yr | 2017 | 2017 | 2017 | |||
ls_end_yr | 2018 | 2018 | 2018 | |||
qual_date | None | None | None | |||
eff_date | None | None | 2017-07-14 00:00:00 | |||
bus_city | Sacramento | Sacramento | Sacramento | |||
bus_st | CA | CA | CA | |||
bus_zip4 | 95814 | 95814 | 95814 | |||
bus_phon | 916-551-2554 | 916-551-2554 | 916-551-2554 | |||
bus_fax | None | None | None | |||
bus_email | None | None | None | |||
mail_city | None | None | None | |||
mail_st | None | None | None | |||
mail_zip4 | None | None | None | |||
mail_phon | None | None | None | |||
sig_date | 2016-12-09 00:00:00 | 2017-02-02 00:00:00 | 2017-09-06 00:00:00 | |||
sig_loc | Sacramento CA | Sacramento CA | Sacramento CA | |||
sig_naml | Francis | Francis | Francis | |||
sig_namf | Lishaun | Lishaun | Lishaun | |||
sig_namt | None | None | None | |||
sig_nams | None | None | None | |||
prn_naml | Francis | Francis | Francis | |||
prn_namf | Lishaun | Lishaun | Lishaun | |||
prn_namt | None | None | None | |||
prn_nams | None | None | None | |||
sig_title | None | None | Lobbyist | |||
stmt_firm | None | None | None | |||
ind_cb | None | None | None | |||
bus_cb | None | None | None | |||
trade_cb | None | None | None | |||
oth_cb | None | None | None | |||
a_b_name | None | None | None | |||
a_b_city | None | None | None | |||
a_b_st | None | None | None | |||
a_b_zip4 | None | None | None | |||
descrip_1 | None | None | None | |||
descrip_2 | None | None | None | |||
c_less50 | None | None | None | |||
c_more50 | None | None | None | |||
ind_class | None | None | None | |||
ind_descr | None | None | None | |||
bus_class | None | None | None | |||
bus_descr | None | None | None | |||
auth_name | None | None | None | |||
auth_city | None | None | None | |||
auth_st | None | None | None | |||
auth_zip4 | None | None | None | |||
lobby_int | None | None | None | |||
influen_yn | None | None | None | |||
firm_name | California Medical Association | California Medical Association | California Medical Association | |||
newcert_cb | None | None | None | |||
rencert_cb | X | None | None | |||
complet_dt | None | 2017-02-02 00:00:00 | None | |||
lby_reg_cb | X | X | None | |||
lby_604_cb | None | None | None | |||
st_leg_yn | None | None | None | |||
st_agency | None | None | None | |||
lobby_cb | None | None | None | |||
l_firm_cb | None | None | None |
filer_id | 1358450 | 1358450 | 1358450 | |||
---|---|---|---|---|---|---|
adrid | 2410546 | 2289998 | 2339579 | |||
effect_dt | 2017-01-01 00:00:00 | 2013-06-01 00:00:00 | 2015-01-01 00:00:00 | |||
add_type | 7051 | 7051 | 7051 | |||
session_id | 2017 | 2013 | 2015 |
filer_id | 1358450 | 1358450 | 1358450 | |||
---|---|---|---|---|---|---|
session_id | 2013 | 2015 | 2017 | |||
ethics_date | 2014-01-23 00:00:00 | 2014-01-23 00:00:00 | 2017-02-02 00:00:00 |
filer_id | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1771805 | 1780022 | 1981661 | 1962783 | 1870536 | 1936673 | 1909873 | 1815988 | 1814033 | 1799401 | 1924852 | 1844011 | 1997133 | 2007155 | 2038276 | 2063879 | 2102590 | 2112744 | 2115128 | 2112744 | 2131257 | 2133817 | 2177280 | 2158079 | 2184837 | 2184703 | 2184706 | |||||||||||||||||||||||||||
period_id | None | 214 | 222 | 221 | 218 | 220 | 219 | 216 | None | 215 | None | 217 | 223 | 224 | 225 | 226 | 227 | 236 | None | 229 | 228 | None | 230 | 229 | None | 231 | 229 | |||||||||||||||||||||||||||
form_id | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F604 | F615 | F615 | F606 | F606 | F615 | |||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
filing_date | 2013-06-14 00:00:00 | 2013-07-29 00:00:00 | 2015-07-31 00:00:00 | 2015-04-27 00:00:00 | 2014-07-30 00:00:00 | 2015-02-02 00:00:00 | 2014-10-30 00:00:00 | 2014-01-30 00:00:00 | 2014-01-23 00:00:00 | 2013-10-30 00:00:00 | 2014-12-23 00:00:00 | 2014-04-29 00:00:00 | 2015-10-30 00:00:00 | 2016-01-26 00:00:00 | 2016-05-02 00:00:00 | 2016-08-01 00:00:00 | 2016-10-31 00:00:00 | 2016-12-21 00:00:00 | 2016-12-20 00:00:00 | 2017-02-16 00:00:00 | 2017-01-31 00:00:00 | 2017-02-02 00:00:00 | 2017-07-31 00:00:00 | 2017-05-01 00:00:00 | 2017-09-19 00:00:00 | 2017-09-19 00:00:00 | 2017-09-19 00:00:00 | |||||||||||||||||||||||||||
stmnt_type | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10006 | 10001 | 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 | |||||||||||||||||||||||||||
session_id | 2013 | 2013 | 2015 | 2015 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2013 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | |||||||||||||||||||||||||||
user_id | YRODRIGU | AGLADNEY | JINGRAM | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GKURIMOT | AGLADNEY | JINGRAM | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | YRODRIGU | GPEREZ | AGLADNEY | KBANH | AGLADNEY | AGLADNEY | GPEREZ | GPEREZ | 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 | |||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | |||||||||||||||||||||||||||
rpt_start | 1900-01-01 00:00:00 | 2013-06-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-04-01 00:00:00 | 2014-10-01 00:00:00 | 2014-07-01 00:00:00 | 2013-10-01 00:00:00 | 1900-01-01 00:00:00 | 2013-07-01 00:00:00 | 1900-01-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 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-02-10 00:00:00 | 2016-10-01 00:00:00 | None | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-07-14 00:00:00 | 2017-01-01 00:00:00 | |||||||||||||||||||||||||||
rpt_end | 1900-01-01 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-06-30 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2013-12-31 00:00:00 | 1900-01-01 00:00:00 | 2013-09-30 00:00:00 | 1900-01-01 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 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-02-10 00:00:00 | 2016-12-31 00:00:00 | None | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-07-14 00:00:00 | 2017-07-14 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 | |||||||||||||||||||||||||||
filing_type | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 |
filer_id | 1358450 | 1358450 | 1358450 | 1358450 | ||||
---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | ||||
active | Y | T | Y | Y | ||||
race | 0 | None | None | None | ||||
session_id | 2013 | 2017 | 2015 | 2017 | ||||
category | 0 | None | None | None | ||||
category_type | 0 | None | None | None | ||||
sub_category | 0 | None | None | None | ||||
effect_dt | 2013-06-01 00:00:00 | 2017-07-14 00:00:00 | 2015-01-01 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 |
filer_id | 1358450 | |
---|---|---|
xref_id | 1358450 | |
effect_dt | 2013-06-17 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | |||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | |||||||||
status | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | |||||||||
effect_dt | 2017-07-14 00:00:00 | 2017-07-14 00:00:00 | 2017-07-14 00:00:00 | 2017-07-14 00:00:00 | 2017-07-14 00:00:00 | 2017-07-14 00:00:00 | 2017-07-14 00:00:00 | 2017-07-14 00:00:00 | 2017-07-14 00:00:00 | |||||||||
naml | FRANCIS | FRANCIS | FRANCIS | FRANCIS | FRANCIS | FRANCIS | FRANCIS | FRANCIS | FRANCIS | |||||||||
namf | LISHAUN | LISHAUN | LISHAUN | LISHAUN | LISHAUN | LISHAUN | LISHAUN F. | LISHAUN F. | LISHAUN F. | |||||||||
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 | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||
zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||
phon | 9165512554 | 9165512554 | 9165512554 | 9165512554 | 9165512554 | 9165512554 | 9165512554 | 9165512554 | 9165512554 | |||||||||
fax | None | 9165512035 | None | 9165512035 | None | 9165512035 | ||||||||||||
None | [email protected] | None | None | [email protected] | None | None | [email protected] | None |
filer_id | 1358450 |
---|
filer_id | 1358450 | 1358450 | 1358450 | |||
---|---|---|---|---|---|---|
change_no | 0 | 1 | 2 | |||
session_id | 2013 | 2017 | 2017 | |||
log_dt | 2013-06-14 00:00:00 | 2017-09-19 00:00:00 | 2017-09-19 00:00:00 | |||
filer_type | 4 | 4 | 4 | |||
correction_flg | None | Y | None | |||
action | ADDED | TERMINATED | TERMINATED | |||
attribute_changed | EMPLOYER | EMPLOYER | ||||
ethics_dt | None | None | None | |||
interests | None | None | None | |||
filer_full_name | LISHAUN FRANCIS | FRANCIS, LISHAUN | FRANCIS, LISHAUN | |||
filer_city | None | None | None | |||
filer_st | None | None | None | |||
filer_zip | None | None | None | |||
filer_phone | None | None | None | |||
entity_type | 2 | 2 | 4 | |||
entity_name | CALIFORNIA MEDICAL ASSOCIATION | CALIFORNIA MEDICAL ASSOCIATION | None | |||
entity_city | None | None | None | |||
entity_st | None | None | None | |||
entity_zip | None | None | None | |||
entity_phone | None | None | None | |||
entity_id | 1146797 | 1146797 | 0 | |||
responsible_officer | None | None | None | |||
effect_dt | 2013-06-01 00:00:00 | 2017-07-14 00:00:00 | 2017-07-14 00:00:00 |
filer_id | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | 1358450 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 2177280_0.cal | 2112744_1.cal | 2102590_0.cal | 2131257_0.cal | 2112744_0.cal | 2063879_0.cal | 2038276_0.cal | 2158079_0.cal | 2184703_0.cal | 2184706_0.cal | ||||||||||
received_date | 2017-07-31 00:00:00 | 2017-02-16 00:00:00 | 2016-10-31 00:00:00 | 2017-01-31 00:00:00 | 2016-12-21 00:00:00 | 2016-08-01 00:00:00 | 2016-05-02 00:00:00 | 2017-05-01 00:00:00 | 2017-09-19 00:00:00 | 2017-09-19 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 | ||||||||||
filing_id | 2177280 | 2112744 | 2102590 | 2131257 | 2112744 | 2063879 | 2038276 | 2158079 | 2184703 | 2184706 | ||||||||||
form_id | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F606 | F615 | ||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |