filing_id | 2241875 | 2418305 | 2447329 | 2409401 | 2409403 | 2409396 | 2472235 | 2409395 | 2409402 | 2551465 | 2482434 | 2551465 | 2551462 | 2580333 | 2599756 | 2551462 | 2551465 | 2638375 | 2622317 | 2622317 | 2678372 | 2703497 | 2678372 | 2747009 | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | ||||||||||||||||||||||||
rec_type | CVR | CVR | CVR | CVR | 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 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||
sender_id | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | ||||||||||||||||||||||||
filer_id | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | ||||||||||||||||||||||||
entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | ||||||||||||||||||||||||
filer_naml | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | ||||||||||||||||||||||||
filer_namf | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | ||||||||||||||||||||||||
filer_namt | None | None | None | None | 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 | None | None | None | None | ||||||||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 001 | 002 | 000 | 000 | 001 | 000 | 000 | 001 | 000 | ||||||||||||||||||||||||
rpt_date | 2018-04-30 00:00:00 | 2019-10-30 00:00:00 | 2020-02-06 00:00:00 | 2019-09-11 00:00:00 | 2019-09-11 00:00:00 | 2019-09-11 00:00:00 | 2020-05-05 00:00:00 | 2019-09-11 00:00:00 | 2019-09-11 00:00:00 | 2021-01-29 00:00:00 | 2020-07-28 00:00:00 | 2021-01-29 00:00:00 | 2021-01-29 00:00:00 | 2021-04-30 00:00:00 | 2021-07-29 00:00:00 | 2021-05-19 00:00:00 | 2021-05-19 00:00:00 | 2022-01-26 00:00:00 | 2021-10-29 00:00:00 | 2022-07-28 00:00:00 | 2022-05-02 00:00:00 | 2022-07-28 00:00:00 | 2022-11-10 00:00:00 | 2022-10-30 00:00:00 | ||||||||||||||||||||||||
from_date | 2018-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2018-10-01 00:00:00 | 2019-04-01 00:00:00 | 2018-07-01 00:00:00 | 2020-01-01 00:00:00 | 2018-04-01 00:00:00 | 2019-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2021-10-01 00:00:00 | 2021-07-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||
thru_date | 2018-03-31 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | 2018-09-30 00:00:00 | 2020-03-31 00:00:00 | 2018-06-30 00:00:00 | 2019-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-12-30 00:00:00 | 2020-09-30 00:00:00 | 2001-03-31 00:00:00 | 2021-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2021-09-30 00:00:00 | 2021-09-30 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 00:00:00 | 2022-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 | None | None | None | None | ||||||||||||||||||||||||
firm_id | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | ||||||||||||||||||||||||
firm_name | California Coalition of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | None | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | ||||||||||||||||||||||||
firm_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | 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 | 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 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||
firm_phon | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | ||||||||||||||||||||||||
mail_city | None | None | None | None | 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 | 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 | 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 | None | None | None | None | ||||||||||||||||||||||||
sig_date | 2018-04-30 00:00:00 | 2019-10-30 00:00:00 | 2020-02-06 00:00:00 | 2019-01-29 00:00:00 | 2019-09-11 00:00:00 | 2018-10-31 00:00:00 | 2020-05-05 00:00:00 | 2018-07-26 00:00:00 | 2019-09-11 00:00:00 | 2021-01-29 00:00:00 | 2020-07-28 00:00:00 | 2021-01-29 00:00:00 | 2021-01-29 00:00:00 | 2021-04-30 00:00:00 | 2021-07-29 00:00:00 | 2021-05-19 00:00:00 | 2021-05-19 00:00:00 | 2022-01-26 00:00:00 | 2021-10-29 00:00:00 | 2022-07-28 00:00:00 | 2022-05-02 00:00:00 | 2022-07-28 00:00:00 | 2022-11-10 00:00:00 | 2022-10-30 00:00:00 | ||||||||||||||||||||||||
sig_loc | Sacramento, CA | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento, CA | Sacramento | Sacramento | Sacramento | Sacramento, CA | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento, CA | Sacramento, CA | Sacramento | Sacramento | Sacramento, CA | Sacramento | Sacramento, CA | Sacramento, California | Sacramento, California | ||||||||||||||||||||||||
sig_naml | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | ||||||||||||||||||||||||
sig_namf | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | ||||||||||||||||||||||||
sig_namt | None | None | None | None | 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 | None | None | None | None | ||||||||||||||||||||||||
prn_naml | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | Clark Harvey | ||||||||||||||||||||||||
prn_namf | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | Le Ondra | ||||||||||||||||||||||||
prn_namt | None | None | None | None | 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 | None | None | None | None | ||||||||||||||||||||||||
sig_title | Director of Policy and Legislative Affairs | Director of Policy and Legislative Affairs | Director of Policy and Legislative Affairs | Director of Policy and Legislative Affairs | Director of Policy and Legislative Affairs | Director of Policy and Legislative Affairs | Director of Policy and Legislative Affairs | Director of Policy and Legislative Affairs | Director of Policy and Legislative Affairs | Chief Executive Officer | Director of Policy and Legislative Affairs | Chief Executive Officer | Chief Executive Officer | Chief Executive Officer | Chief Executive Officer | Chief Executive Officer | Chief Executive Officer | Chief Executive Officer | Chief Executive Officer | Chief Executive Officer | Chief Executive Officer | Chief Executive Officer | Chief Executive Officer | Chief Executive Officer | ||||||||||||||||||||||||
nopart1_cb | X | X | X | X | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | None | None | None | None |
filing_id | 2527836 | 2527836 | 2606825 | |||
---|---|---|---|---|---|---|
amend_id | 1 | 0 | 0 | |||
rec_type | CVR | CVR | CVR | |||
form_type | F604 | F604 | F604 | |||
sender_id | C01273 | C01273 | C01273 | |||
filer_id | 1403000 | 1403000 | 1403000 | |||
entity_cd | LBY | LBY | LBY | |||
filer_naml | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | |||
filer_namf | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | |||
filer_namt | None | None | None | |||
filer_nams | None | None | None | |||
report_num | 001 | 000 | 000 | |||
rpt_date | 2020-10-30 00:00:00 | 2020-10-30 00:00:00 | 2021-08-16 00:00:00 | |||
ls_beg_yr | 2019 | 2019 | 2021 | |||
ls_end_yr | 2020 | 2020 | 2022 | |||
qual_date | None | None | 2021-08-12 00:00:00 | |||
eff_date | None | None | None | |||
bus_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||
bus_st | CA | CA | CA | |||
bus_zip4 | 95814 | 95814 | 95814 | |||
bus_phon | 9165571166 | 9165571166 | 9165571166 | |||
bus_fax | None | None | None | |||
bus_email | [email protected] | [email protected] | [email protected] | |||
mail_city | None | None | None | |||
mail_st | None | None | None | |||
mail_zip4 | None | None | None | |||
mail_phon | None | None | None | |||
sig_date | 2020-10-30 00:00:00 | 2020-10-30 00:00:00 | 2021-08-16 00:00:00 | |||
sig_loc | None | None | None | |||
sig_naml | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | |||
sig_namf | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | |||
sig_namt | None | None | None | |||
sig_nams | None | None | None | |||
prn_naml | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | |||
prn_namf | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | |||
prn_namt | None | None | None | |||
prn_nams | None | None | None | |||
sig_title | None | None | None | |||
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 Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | California Council of Community Behavioral Health Agencies | |||
newcert_cb | None | None | None | |||
rencert_cb | X | None | None | |||
complet_dt | None | 2018-11-15 00:00:00 | 2021-08-12 00:00:00 | |||
lby_reg_cb | X | X | X | |||
lby_604_cb | None | None | None | |||
st_leg_yn | Y | Y | Y | |||
st_agency | None | None | None | |||
lobby_cb | None | None | None | |||
l_firm_cb | None | None | None |
filer_id | 1403000 | 1403000 | 1403000 | |||
---|---|---|---|---|---|---|
adrid | 2446876 | 2507306 | 2465790 | |||
effect_dt | 2018-02-26 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | |||
add_type | 7051 | 7051 | 7051 | |||
session_id | 2017 | 2021 | 2019 |
filer_id | 1403000 | 1403000 | ||
---|---|---|---|---|
session_id | 2019 | 2021 | ||
ethics_date | 2018-11-15 00:00:00 | 2021-08-12 00:00:00 |
filer_id | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | |||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2218954 | 2335729 | 2241875 | 2409401 | 2409403 | 2527836 | 2409396 | 2527836 | 2472235 | 2382552 | 2418305 | 2482434 | 2551462 | 2409395 | 2409402 | 2551465 | 2551465 | 2599756 | 2551462 | 2551465 | 2447329 | 2606825 | 2626613 | 2638375 | 2614571 | 2537791 | 2703497 | 2580333 | 2622317 | 2678372 | 2622317 | 2747009 | 2678372 | |||||||||||||||||||||||||||||||||
period_id | None | None | 233 | 236 | 238 | 244 | 235 | 244 | 241 | None | 239 | 242 | 243 | 234 | 237 | 244 | 244 | 246 | 243 | 244 | 240 | 247 | None | 248 | None | None | 250 | 232 | 247 | 249 | 247 | 251 | 249 | |||||||||||||||||||||||||||||||||
form_id | F604 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | |||||||||||||||||||||||||||||||||
filing_date | 2018-02-26 00:00:00 | 2018-11-14 00:00:00 | 2018-04-30 00:00:00 | 2019-09-11 00:00:00 | 2019-09-11 00:00:00 | 2020-10-30 00:00:00 | 2019-09-11 00:00:00 | 2020-10-30 00:00:00 | 2020-05-05 00:00:00 | 2019-03-18 00:00:00 | 2019-10-30 00:00:00 | 2020-07-28 00:00:00 | 2021-05-19 00:00:00 | 2019-09-11 00:00:00 | 2019-09-11 00:00:00 | 2021-05-19 00:00:00 | 2021-01-29 00:00:00 | 2021-07-29 00:00:00 | 2021-01-29 00:00:00 | 2021-01-29 00:00:00 | 2020-02-06 00:00:00 | 2021-08-16 00:00:00 | 2021-10-20 00:00:00 | 2022-01-26 00:00:00 | 2021-08-23 00:00:00 | 2020-11-02 00:00:00 | 2022-07-28 00:00:00 | 2021-04-30 00:00:00 | 2022-07-28 00:00:00 | 2022-05-02 00:00:00 | 2021-10-29 00:00:00 | 2022-10-30 00:00:00 | 2022-11-10 00:00:00 | |||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10006 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10002 | |||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||
session_id | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2021 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||
user_id | YRODRIGU | PBANFORD | YRODRIGU | AGLADNEY | KBANH | AROJAS | AGLADNEY | AROJAS | VUKSTINA | VUKSTINA | AGLADNEY | VUKSTINA | LPHEAV | AGLADNEY | KBANH | CAFILER | GTAYLOR | GTAYLOR | LPHEAV | GTAYLOR | DWALKER | JMENDOZA | JMENDOZA | RATTIYEH | JMENDOZA | AROJAS | CAFILER | CHATRIDGE | CAFILER | CHATRIDGE | CHATRIDGE | CAFILER | CAFILER | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
fine_audit | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||
rpt_start | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-04-01 00:00:00 | 2020-10-30 00:00:00 | 2018-07-01 00:00:00 | 2020-10-30 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2018-04-01 00:00:00 | 2019-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-10-01 00:00:00 | 2021-04-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2019-10-01 00:00:00 | 2021-08-16 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | 2022-01-01 00:00:00 | |||||||||||||||||||||||||||||||||
rpt_end | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-03-31 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | 2020-10-30 00:00:00 | 2018-09-30 00:00:00 | 2020-10-30 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2018-06-30 00:00:00 | 2019-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-12-30 00:00:00 | 2021-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2019-12-31 00:00:00 | 2021-08-16 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-06-30 00:00:00 | 2001-03-31 00:00:00 | 2021-09-30 00:00:00 | 2022-03-31 00:00:00 | 2021-09-30 00:00:00 | 2022-09-30 00:00:00 | 2022-03-31 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 | |||||||||||||||||||||||||||||||||
filing_type | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1403000 | 1403000 | 1403000 | |||
---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | |||
active | Y | Y | Y | |||
race | 0 | None | None | |||
session_id | 2017 | 2021 | 2019 | |||
category | 0 | None | None | |||
category_type | 0 | None | None | |||
sub_category | 0 | None | None | |||
effect_dt | 2018-02-26 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | |||
sub_category_type | 0 | None | None | |||
election_type | 0 | None | None | |||
sub_category_a | None | None | None | |||
nyq_dt | None | None | None | |||
party_cd | 0 | None | None | |||
county_cd | 0 | None | None | |||
district_cd | 0 | None | None |
filer_id | 1403000 | |
---|---|---|
xref_id | 1403000 | |
effect_dt | 2018-02-27 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | |||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | |||||||||
status | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | |||||||||
effect_dt | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | |||||||||
naml | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | CLARK HARVEY | |||||||||
namf | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | LE ONDRA L. | |||||||||
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 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | 9165571166 | |||||||||
fax | None | None | None | None | None | None | None | None | None | |||||||||
[email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1403000 |
---|
filer_id | 1403000 | |
---|---|---|
change_no | 1 | |
session_id | 2017 | |
log_dt | 2018-02-26 00:00:00 | |
filer_type | 4 | |
correction_flg | Y | |
action | ADDED | |
attribute_changed | EMPLOYER | |
ethics_dt | None | |
interests | None | |
filer_full_name | CLARK HARVEY, LE ONDRA L. | |
filer_city | SACRAMENTO | |
filer_st | CA | |
filer_zip | 95814 | |
filer_phone | 9165571166 | |
entity_type | 2 | |
entity_name | CALIFORNIA COUNCIL OF COMMUNITY BEHAVORAL HEALTH AGENCIES | |
entity_city | None | |
entity_st | None | |
entity_zip | None | |
entity_phone | None | |
entity_id | None | |
responsible_officer | None | |
effect_dt | 2018-02-26 00:00:00 |
filer_id | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | 1403000 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 132530.cal | 2527836_0.cal | 132779.cal | 133370.cal | 2527836_1.cal | 427168.cal | 132700.cal | 2606825_0.cal | 132309.cal | 132798.cal | 132736.cal | 133331.cal | ||||||||||||
received_date | 2022-10-30 00:00:00 | 2020-10-30 00:00:00 | 2022-10-30 00:00:00 | 2022-10-30 00:00:00 | 2020-10-30 00:00:00 | 2022-11-02 00:00:00 | 2022-10-30 00:00:00 | 2021-08-16 00:00:00 | 2022-10-30 00:00:00 | 2022-10-30 00:00:00 | 2022-10-30 00:00:00 | 2022-10-30 00:00:00 | ||||||||||||
filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | ||||||||||||
filing_id | None | 2527836 | None | None | 2527836 | None | None | 2606825 | None | None | None | None | ||||||||||||
form_id | None | F604 | None | None | F604 | None | None | F604 | None | None | None | None | ||||||||||||
receive_comment | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints |