filing_id | 2395028 | 2377406 | 2416145 | 2438691 | 2467422 | 2527448 | 2548967 | 2576979 | 2483567 | 2597819 | 2621078 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||
form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||||
sender_id | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | |||||||||||
filer_id | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | |||||||||||
entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | |||||||||||
filer_naml | MC GREW | MC GREW | MC GREW | MC GREW | MC GREW | MC GREW | MC GREW | MC GREW | MC GREW | MC GREW | MC GREW | |||||||||||
filer_namf | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | |||||||||||
filer_namt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
filer_nams | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||
rpt_date | 2019-07-29 00:00:00 | 2019-04-25 00:00:00 | 2019-10-28 00:00:00 | 2020-01-29 00:00:00 | 2020-04-24 00:00:00 | 2020-10-30 00:00:00 | 2021-01-28 00:00:00 | 2021-04-26 00:00:00 | 2020-07-30 00:00:00 | 2021-07-28 00:00:00 | 2021-10-28 00:00:00 | |||||||||||
from_date | 2019-04-01 00:00:00 | 2019-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2021-01-01 00:00:00 | 2020-04-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | |||||||||||
thru_date | 2019-06-30 00:00:00 | 2019-03-31 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2020-06-30 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | |||||||||||
cum_beg_dt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
firm_id | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | |||||||||||
firm_name | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | |||||||||||
firm_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||||||||
firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||
firm_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||||
firm_phon | 9165547389 | 9165547389 | 9165547389 | 9165547389 | 9165547389 | 9165547389 | 9165547389 | 9165547389 | 9165547389 | 9165547389 | 9165547389 | |||||||||||
mail_city | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
mail_st | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
mail_phon | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
sig_date | 2019-07-22 00:00:00 | 2019-04-17 00:00:00 | 2019-10-18 00:00:00 | 2020-01-20 00:00:00 | 2020-04-21 00:00:00 | 2020-10-15 00:00:00 | 2021-01-19 00:00:00 | 2021-04-16 00:00:00 | 2020-07-17 00:00:00 | 2021-07-16 00:00:00 | 2021-10-01 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 | |||||||||||
sig_naml | MCGREW | MCGREW | MCGREW | MCGREW | MCGREW | MCGREW | MCGREW | MCGREW | MCGREW | MCGREW | MCGREW | |||||||||||
sig_namf | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | |||||||||||
sig_namt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
sig_nams | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
prn_naml | MCGREW | MCGREW | MCGREW | MCGREW | MCGREW | MCGREW | MCGREW | MCGREW | MCGREW | MCGREW | MCGREW | |||||||||||
prn_namf | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | |||||||||||
prn_namt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
prn_nams | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
sig_title | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | |||||||||||
nopart1_cb | X | X | X | X | X | X | X | X | X | X | X | |||||||||||
nopart2_cb | 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 | |||||||||||
part1_2_cb | 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 | |||||||||||
ctrib_y_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
lby_actvty | 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 | |||||||||||
lobby_y_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
major_naml | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
major_namf | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
major_namt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
major_nams | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
rcpcmte_nm | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
rcpcmte_id | None | None | None | None | None | None | None | None | None | None | None |
filing_id | 2350978 | 2350978 | 2535464 | 2535464 | 2613287 | |||||
---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 1 | 0 | 1 | 0 | |||||
rec_type | CVR | CVR | CVR | CVR | CVR | |||||
form_type | F604 | F604 | F604 | F604 | F606 | |||||
sender_id | E24727 | E24727 | E24727 | E24727 | E24727 | |||||
filer_id | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | |||||
entity_cd | LBY | LBY | LBY | LBY | LBY | |||||
filer_naml | MCGREW | MCGREW | MC GREW | MC GREW | MC GREW | |||||
filer_namf | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | |||||
filer_namt | None | None | None | None | None | |||||
filer_nams | None | None | None | None | None | |||||
report_num | 000 | 001 | 000 | 001 | 000 | |||||
rpt_date | 2019-02-01 00:00:00 | 2019-06-28 00:00:00 | 2020-11-19 00:00:00 | 2021-01-18 00:00:00 | 2021-09-30 00:00:00 | |||||
ls_beg_yr | 2019 | 2019 | 2021 | 2021 | 2021 | |||||
ls_end_yr | 2020 | 2020 | 2022 | 2022 | 2022 | |||||
qual_date | 2019-02-01 00:00:00 | 2019-02-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | None | |||||
eff_date | None | None | None | None | 2021-09-30 00:00:00 | |||||
bus_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||
bus_st | CA | CA | CA | CA | CA | |||||
bus_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||
bus_phon | 9165547389 | 9165547389 | 9165547389 | 9165547389 | None | |||||
bus_fax | None | None | None | None | None | |||||
bus_email | [email protected] | [email protected] | [email protected] | [email protected] | None | |||||
mail_city | None | None | None | None | None | |||||
mail_st | None | None | None | None | None | |||||
mail_zip4 | None | None | None | None | None | |||||
mail_phon | None | None | None | None | None | |||||
sig_date | 2019-02-01 00:00:00 | 2019-06-27 00:00:00 | 2020-11-11 00:00:00 | 2021-01-15 00:00:00 | 2021-09-30 00:00:00 | |||||
sig_loc | None | None | None | None | None | |||||
sig_naml | MCGREW | MCGREW | MC GREW | MC GREW | MCGREW | |||||
sig_namf | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | |||||
sig_namt | None | None | None | None | None | |||||
sig_nams | None | None | None | None | None | |||||
prn_naml | MCGREW | MCGREW | MC GREW | MC GREW | MCGREW | |||||
prn_namf | DHARIA | DHARIA | DHARIA | DHARIA | DHARIA | |||||
prn_namt | None | None | None | None | None | |||||
prn_nams | None | None | None | None | None | |||||
sig_title | None | None | None | None | SENIOR LEGISLATIVE ADVOCATE | |||||
stmt_firm | None | None | None | None | None | |||||
ind_cb | None | None | None | None | None | |||||
bus_cb | None | None | None | None | None | |||||
trade_cb | None | None | None | None | None | |||||
oth_cb | None | None | None | None | None | |||||
a_b_name | None | None | None | None | None | |||||
a_b_city | None | None | None | None | None | |||||
a_b_st | None | None | None | None | None | |||||
a_b_zip4 | None | None | None | None | None | |||||
descrip_1 | None | None | None | None | None | |||||
descrip_2 | None | None | None | None | None | |||||
c_less50 | None | None | None | None | None | |||||
c_more50 | None | None | None | None | None | |||||
ind_class | None | None | None | None | None | |||||
ind_descr | None | None | None | None | None | |||||
bus_class | None | None | None | None | None | |||||
bus_descr | None | None | None | None | None | |||||
auth_name | None | None | None | None | None | |||||
auth_city | None | None | None | None | None | |||||
auth_st | None | None | None | None | None | |||||
auth_zip4 | None | None | None | None | None | |||||
lobby_int | None | None | None | None | None | |||||
influen_yn | None | None | None | None | None | |||||
firm_name | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | CALIFORNIA DENTAL ASSOCIATION AND ITS WHOLLY OWNED SUBSIDIARIES | |||||
newcert_cb | X | None | None | None | None | |||||
rencert_cb | None | None | X | None | None | |||||
complet_dt | None | 2019-06-27 00:00:00 | None | 2021-01-15 00:00:00 | None | |||||
lby_reg_cb | X | X | X | X | None | |||||
lby_604_cb | None | None | None | None | None | |||||
st_leg_yn | Y | Y | Y | Y | None | |||||
st_agency | None | None | None | None | None | |||||
lobby_cb | None | None | None | None | None | |||||
l_firm_cb | None | None | None | None | None |
filer_id | 1415488 | 1415488 | ||
---|---|---|---|---|
adrid | 2474247 | 2507310 | ||
effect_dt | 2019-02-01 00:00:00 | 2021-01-01 00:00:00 | ||
add_type | 7051 | 7051 | ||
session_id | 2019 | 2021 |
filer_id | 1415488 | 1415488 | ||
---|---|---|---|---|
session_id | 2019 | 2021 | ||
ethics_date | 2019-06-27 00:00:00 | 2021-01-15 00:00:00 |
filer_id | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | 1415488 | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2377406 | 2375668 | 2467422 | 2416145 | 2395028 | 2350978 | 2350978 | 2483567 | 2589862 | 2400472 | 2438691 | 2535464 | 2535464 | 2527448 | 2613287 | 2576979 | 2617325 | 2537005 | 2597819 | 2548967 | 2621078 | |||||||||||||||||||||
period_id | 237 | None | 241 | 239 | 238 | 237 | 238 | 242 | None | None | 240 | 245 | 244 | 243 | 247 | 245 | None | None | 246 | 244 | 247 | |||||||||||||||||||||
form_id | F615 | F604 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F604 | F615 | F604 | F604 | F615 | F606 | F615 | F606 | F604 | F615 | F615 | F615 | |||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
filing_date | 2019-04-25 00:00:00 | 2019-02-01 00:00:00 | 2020-04-24 00:00:00 | 2019-10-28 00:00:00 | 2019-07-29 00:00:00 | 2019-02-01 00:00:00 | 2019-06-28 00:00:00 | 2020-07-30 00:00:00 | 2021-01-29 00:00:00 | 2019-07-01 00:00:00 | 2020-01-29 00:00:00 | 2021-01-18 00:00:00 | 2020-11-19 00:00:00 | 2020-10-30 00:00:00 | 2021-09-30 00:00:00 | 2021-04-26 00:00:00 | 2021-10-04 00:00:00 | 2020-11-23 00:00:00 | 2021-07-28 00:00:00 | 2021-01-28 00:00:00 | 2021-10-28 00:00:00 | |||||||||||||||||||||
stmnt_type | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10005 | 10001 | 10002 | 10001 | 10001 | 10003 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | |||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | |||||||||||||||||||||
session_id | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2019 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | |||||||||||||||||||||
user_id | VUKSTINA | YRODRIGU | VUKSTINA | VUKSTINA | VUKSTINA | YRODRIGU | CAFILER | CVANLIEW | MMERCHANT | VUKSTINA | GTAYLOR | MMERCHANT | MMERCHANT | MKIRKHAM | JMENDOZA | CAFILER | JMENDOZA | MMERCHANT | CAFILER | CHARTRIDGE | CAFILER | |||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||
fine_audit | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | |||||||||||||||||||||
rpt_start | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-04-01 00:00:00 | 2019-02-01 00:00:00 | 2019-06-28 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-10-01 00:00:00 | 2021-01-18 00:00:00 | 2020-11-19 00:00:00 | 2020-07-01 00:00:00 | 2021-09-30 00:00:00 | 2021-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2020-10-01 00:00:00 | 2021-07-01 00:00:00 | |||||||||||||||||||||
rpt_end | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2020-03-31 00:00:00 | 2019-09-30 00:00:00 | 2019-06-30 00:00:00 | 2019-02-01 00:00:00 | 2019-06-28 00:00:00 | 2020-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-12-31 00:00:00 | 2021-01-18 00:00:00 | 2020-11-19 00:00:00 | 2020-09-30 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-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 | |||||||||||||||||||||
filing_type | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 |
filer_id | 1415488 | 1415488 | 1415488 | |||
---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | |||
active | Y | Y | T | |||
race | None | 0 | None | |||
session_id | 2021 | 2019 | 2021 | |||
category | None | 0 | None | |||
category_type | None | 0 | None | |||
sub_category | None | 0 | None | |||
effect_dt | 2021-01-01 00:00:00 | 2019-02-01 00:00:00 | 2021-09-30 00:00:00 | |||
sub_category_type | None | 0 | None | |||
election_type | None | 0 | None | |||
sub_category_a | None | None | None | |||
nyq_dt | None | None | None | |||
party_cd | None | 0 | None | |||
county_cd | None | 0 | None | |||
district_cd | None | 0 | None |
filer_id | 1415488 | |
---|---|---|
xref_id | 1415488 | |
effect_dt | 2019-01-30 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1415488 | 1415488 | 1415488 | 1415488 | ||||
---|---|---|---|---|---|---|---|---|
filer_id | 1415488 | 1415488 | 1415488 | 1415488 | ||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||
status | TERMINATED | TERMINATED | TERMINATED | TERMINATED | ||||
effect_dt | 2021-09-30 00:00:00 | 2021-09-30 00:00:00 | 2021-09-30 00:00:00 | 2021-09-30 00:00:00 | ||||
naml | MC GREW | MC GREW | MC GREW | MC GREW | ||||
namf | DHARIA | DHARIA | DHARIA | DHARIA | ||||
namt | None | None | None | None | ||||
nams | None | None | None | None | ||||
adr1 | None | None | None | None | ||||
adr2 | None | None | None | None | ||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||
st | CA | CA | CA | CA | ||||
zip4 | 95814 | 95814 | 95814 | 95814 | ||||
phon | 9165547389 | 9165547389 | 9165547389 | 9165547389 | ||||
fax | None | None | None | None | ||||
[email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1415488 |
---|
filer_id | 1415488 | 1415488 | 1415488 | 1415488 | ||||
---|---|---|---|---|---|---|---|---|
filing_file_name | 2350978_0.cal | 2350978_1.cal | 2535464_1.cal | 2535464_0.cal | ||||
received_date | 2019-02-01 00:00:00 | 2019-06-28 00:00:00 | 2021-01-18 00:00:00 | 2020-11-19 00:00:00 | ||||
filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||
filing_id | 2350978 | 2350978 | 2535464 | 2535464 | ||||
form_id | F604 | F604 | F604 | F604 | ||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted |