filing_id | 2193092 | 2205930 | 2236743 | 2271600 | 2378255 | 2316716 | 2344686 | 2400831 | 2417798 | 2438540 | 2438540 | 2468602 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ||||||||||||
rec_type | 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 | ||||||||||||
sender_id | E00052 | E00052 | E00052 | E00052 | E00052 | E00052 | E00052 | E00052 | E00052 | E00052 | E00052 | E00052 | ||||||||||||
filer_id | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | ||||||||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | ||||||||||||
filer_naml | BORCHARD | BORCHARD | BORCHARD | BORCHARD | BORCHARD | BORCHARD | BORCHARD | BORCHARD | BORCHARD | BORCHARD | BORCHARD | BORCHARD | ||||||||||||
filer_namf | ADAM | ADAM | ADAM | ADAM | ADAM | ADAM | ADAM | ADAM | ADAM | ADAM | ADAM | ADAM | ||||||||||||
filer_namt | 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 | ||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | ||||||||||||
rpt_date | 2017-10-31 00:00:00 | 2018-01-26 00:00:00 | 2018-04-26 00:00:00 | 2018-07-30 00:00:00 | 2019-04-29 00:00:00 | 2018-10-30 00:00:00 | 2019-01-30 00:00:00 | 2019-08-01 00:00:00 | 2019-10-30 00:00:00 | 2020-01-29 00:00:00 | 2020-01-29 00:00:00 | 2020-04-29 00:00:00 | ||||||||||||
from_date | 2017-07-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2019-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-10-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | ||||||||||||
thru_date | 2017-09-30 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2019-03-31 00:00:00 | 2018-09-30 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | ||||||||||||
cum_beg_dt | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
firm_id | E00052 | E00052 | E00052 | E00052 | E00052 | E00052 | E00052 | E00052 | E00052 | E00052 | E00052 | E00052 | ||||||||||||
firm_name | Association of CA Water Agencies | Association of CA Water Agencies | Association of CA Water Agencies | Association of CA Water Agencies | Association of CA Water Agencies | Association of CA Water Agencies | Association of CA Water Agencies | Association of CA Water Agencies | Association of CA Water Agencies | Association of CA Water Agencies | Association of CA Water Agencies | Association of CA Water Agencies | ||||||||||||
firm_city | 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 | ||||||||||||
firm_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||
firm_phon | 916-441-4545 | 916-441-4545 | 916-441-4545 | 916-441-4545 | 916-441-4545 | 916-441-4545 | 916-441-4545 | 916-441-4545 | 916-441-4545 | 916-441-4545 | 916-441-4545 | 916-441-4545 | ||||||||||||
mail_city | 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 | ||||||||||||
mail_zip4 | 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 | ||||||||||||
sig_date | 2017-10-31 00:00:00 | 2018-01-26 00:00:00 | 2018-04-26 00:00:00 | 2018-07-30 00:00:00 | 2019-04-29 00:00:00 | 2018-10-30 00:00:00 | 2019-01-30 00:00:00 | 2019-08-01 00:00:00 | 2019-10-30 00:00:00 | 2020-01-30 00:00:00 | 2020-01-29 00:00:00 | 2020-04-29 00:00:00 | ||||||||||||
sig_loc | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento | Sacramento CA | Sacramento CA | Sacramento CA | ||||||||||||
sig_naml | Borchard | Borchard | Borchard | Borchard | Borchard | Borchard | Borchard | Borchard | Borchard | Borchard | Borchard | Borchard | ||||||||||||
sig_namf | Adam | Adam | Adam | Adam | Adam | Adam | Adam | Adam | Adam | Adam | Adam | Adam | ||||||||||||
sig_namt | 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 | ||||||||||||
prn_naml | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
prn_namf | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
prn_namt | 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 | ||||||||||||
sig_title | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
nopart1_cb | 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 | ||||||||||||
part1_1_cb | 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 | ||||||||||||
ctrib_n_cb | 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 | ||||||||||||
lby_actvty | 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 | ||||||||||||
lobby_y_cb | 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 | ||||||||||||
major_namf | 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 | ||||||||||||
major_nams | 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 | ||||||||||||
rcpcmte_id | None | None | None | None | None | None | None | None | None | None | None | None |
filing_id | 2166318 | 2315231 | 2315231 | |||
---|---|---|---|---|---|---|
amend_id | 0 | 0 | 1 | |||
rec_type | CVR | CVR | CVR | |||
form_type | F604 | F604 | F604 | |||
sender_id | E00052 | E00052 | E00052 | |||
filer_id | 1397203 | 1397203 | 1397203 | |||
entity_cd | LBY | LBY | LBY | |||
filer_naml | BORCHARD | BORCHARD | BORCHARD | |||
filer_namf | ADAM | ADAM | ADAM | |||
filer_namt | None | None | None | |||
filer_nams | None | None | None | |||
report_num | 000 | 000 | 001 | |||
rpt_date | 2017-07-10 00:00:00 | 2018-10-29 00:00:00 | 2018-10-29 00:00:00 | |||
ls_beg_yr | 2017 | 2019 | 2019 | |||
ls_end_yr | 2018 | 2020 | 2020 | |||
qual_date | 2017-05-01 00:00:00 | None | None | |||
eff_date | None | None | None | |||
bus_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||
bus_st | CA | CA | CA | |||
bus_zip4 | 95814 | 95814 | 95814 | |||
bus_phon | 916-441-4545 | 9164414545 | 9164414545 | |||
bus_fax | None | None | None | |||
bus_email | [email protected] | None | None | |||
mail_city | None | None | None | |||
mail_st | None | None | None | |||
mail_zip4 | None | None | None | |||
mail_phon | None | None | None | |||
sig_date | 2017-07-10 00:00:00 | 2018-10-29 00:00:00 | 2018-10-29 00:00:00 | |||
sig_loc | None | None | None | |||
sig_naml | Borchard | Borchard | Borchard | |||
sig_namf | Adam | Adam | Adam | |||
sig_namt | Mr. | None | None | |||
sig_nams | None | None | None | |||
prn_naml | None | None | None | |||
prn_namf | None | None | None | |||
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 | ASSOCIATION OF CALIFORNIA WATER AGENCIES | ASSOCIATION OF CALIFORNIA WATER AGENCIES | ASSOCIATION OF CALIFORNIA WATER AGENCIES | |||
newcert_cb | None | None | None | |||
rencert_cb | None | X | None | |||
complet_dt | 2017-06-22 00:00:00 | None | 2019-01-10 00:00:00 | |||
lby_reg_cb | X | X | X | |||
lby_604_cb | None | None | None | |||
st_leg_yn | Y | N | N | |||
st_agency | None | None | None | |||
lobby_cb | None | None | None | |||
l_firm_cb | None | None | None |
filer_id | 1397203 | 1397203 | ||
---|---|---|---|---|
adrid | 2436617 | 2465439 | ||
effect_dt | 2017-05-01 00:00:00 | 2019-01-01 00:00:00 | ||
add_type | 7051 | 7051 | ||
session_id | 2017 | 2019 |
filer_id | 1397203 | 1397203 | ||
---|---|---|---|---|
session_id | 2017 | 2019 | ||
ethics_date | 2017-06-22 00:00:00 | 2019-01-10 00:00:00 |
filer_id | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2193092 | 2378255 | 2344686 | 2236743 | 2438540 | 2417798 | 2400831 | 2166318 | 2327671 | 2438540 | 2334219 | 2315231 | 2181280 | 2181282 | 2379442 | 2205930 | 2315231 | 2316716 | 2468602 | 2271600 | ||||||||||||||||||||
period_id | 231 | 237 | 236 | 233 | 240 | 239 | 238 | 231 | None | 240 | None | 236 | None | None | None | 232 | 236 | 235 | 241 | 234 | ||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F604 | F604 | F999 | F604 | F615 | F604 | F615 | F615 | F615 | ||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | ||||||||||||||||||||
filing_date | 2017-10-31 00:00:00 | 2019-04-29 00:00:00 | 2019-01-30 00:00:00 | 2018-04-26 00:00:00 | 2020-01-29 00:00:00 | 2019-10-30 00:00:00 | 2019-08-01 00:00:00 | 2017-07-10 00:00:00 | 2018-10-31 00:00:00 | 2020-01-30 00:00:00 | 2019-01-11 00:00:00 | 2018-10-29 00:00:00 | 2017-08-18 00:00:00 | 2017-08-18 00:00:00 | 2019-04-17 00:00:00 | 2018-01-26 00:00:00 | 2019-01-11 00:00:00 | 2018-10-30 00:00:00 | 2020-04-29 00:00:00 | 2018-07-30 00:00:00 | ||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10006 | 10001 | 10005 | 10005 | 10006 | 10001 | 10002 | 10001 | 10001 | 10001 | ||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | ||||||||||||||||||||
session_id | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2017 | 2017 | 2019 | 2017 | 2019 | 2017 | 2019 | 2017 | ||||||||||||||||||||
user_id | AGLADNEY | JFRONEFIELD | JFRONEFIELD | AGLADNEY | VUKSTINA | AGLADNEY | VUKSTINA | YRODRIGU | GPEREZ | GTAYLOR | YRODRIGU | GPEREZ | YRODRIGU | YRODRIGU | YRODRIGU | AGLADNEY | YRODRIGU | JFRONEFIELD | VUKSTINA | JFRONEFIELD | ||||||||||||||||||||
special_audit | 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 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | ||||||||||||||||||||
rpt_start | 2017-07-01 00:00:00 | 2019-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2019-04-01 00:00:00 | 2017-07-10 00:00:00 | 1900-01-01 00:00:00 | 2019-10-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-29 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-10-01 00:00:00 | 2018-10-29 00:00:00 | 2018-07-01 00:00:00 | 2020-01-01 00:00:00 | 2018-04-01 00:00:00 | ||||||||||||||||||||
rpt_end | 2017-09-30 00:00:00 | 2019-03-31 00:00:00 | 2018-12-31 00:00:00 | 2018-03-31 00:00:00 | 2019-12-31 00:00:00 | 2019-09-30 00:00:00 | 2019-06-30 00:00:00 | 2017-07-10 00:00:00 | 1900-01-01 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-10-29 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-12-31 00:00:00 | 2018-10-29 00:00:00 | 2018-09-30 00:00:00 | 2020-03-31 00:00:00 | 2018-06-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 | ||||||||||||||||||||
filing_type | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 |
filer_id | 1397203 | 1397203 | ||
---|---|---|---|---|
filer_type | 4 | 4 | ||
active | Y | Y | ||
race | 0 | None | ||
session_id | 2017 | 2019 | ||
category | 0 | None | ||
category_type | 0 | None | ||
sub_category | 0 | None | ||
effect_dt | 2017-05-01 00:00:00 | 2019-01-01 00:00:00 | ||
sub_category_type | 0 | None | ||
election_type | 0 | None | ||
sub_category_a | None | None | ||
nyq_dt | None | None | ||
party_cd | 0 | None | ||
county_cd | 0 | None | ||
district_cd | 0 | None |
filer_id | 1397203 | |
---|---|---|
xref_id | 1397203 | |
effect_dt | 2017-06-23 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1397203 | 1397203 | 1397203 | 1397203 | ||||
---|---|---|---|---|---|---|---|---|
filer_id | 1397203 | 1397203 | 1397203 | 1397203 | ||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||
status | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ||||
effect_dt | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | ||||
naml | BORCHARD | BORCHARD | BORCHARD | BORCHARD | ||||
namf | ADAM | ADAM | ADAM | ADAM | ||||
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 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | ||||
fax | 9163252306 | 9163252306 | ||||||
[email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1397203 |
---|
filer_id | 1397203 | 1397203 | ||
---|---|---|---|---|
change_no | 1 | 2 | ||
session_id | 2019 | 2019 | ||
log_dt | 2018-10-31 00:00:00 | 2018-10-31 00:00:00 | ||
filer_type | 4 | 4 | ||
correction_flg | None | None | ||
action | SET ACTIVE | SET ACTIVE | ||
attribute_changed | EMPLOYER | |||
ethics_dt | None | None | ||
interests | None | None | ||
filer_full_name | BORCHARD, ADAM | BORCHARD, ADAM | ||
filer_city | None | None | ||
filer_st | None | None | ||
filer_zip | None | None | ||
filer_phone | None | None | ||
entity_type | 4 | 2 | ||
entity_name | None | ASSOCIATION OF CALIFORNIA WATER AGENCIES | ||
entity_city | None | None | ||
entity_st | None | None | ||
entity_zip | None | None | ||
entity_phone | None | None | ||
entity_id | 0 | 1146771 | ||
responsible_officer | None | None | ||
effect_dt | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 |
filer_id | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | 1397203 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 2166318_0.cal | 2193092_0.cal | 2344686_0.cal | 2236743_0.cal | 2378255_0.cal | 2438540_0.cal | 2315231_0.cal | 2468602_0.cal | 2438540_1.cal | 2417798_0.cal | 2205930_0.cal | 2400831_0.cal | 2316716_0.cal | 2315231_1.cal | 2271600_0.cal | |||||||||||||||
received_date | 2017-07-10 00:00:00 | 2017-10-31 00:00:00 | 2019-01-30 00:00:00 | 2018-04-26 00:00:00 | 2019-04-29 00:00:00 | 2020-01-29 00:00:00 | 2018-10-29 00:00:00 | 2020-04-29 00:00:00 | 2020-01-30 00:00:00 | 2019-10-30 00:00:00 | 2018-01-26 00:00:00 | 2019-08-01 00:00:00 | 2018-10-30 00:00:00 | 2019-01-11 00:00:00 | 2018-07-30 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 | |||||||||||||||
filing_id | 2166318 | 2193092 | 2344686 | 2236743 | 2378255 | 2438540 | 2315231 | 2468602 | 2438540 | 2417798 | 2205930 | 2400831 | 2316716 | 2315231 | 2271600 | |||||||||||||||
form_id | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | 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 |