| filing_id | 2438532 | 2400908 | 2417794 | 2468593 | 2438532 | 2482573 | 2526527 | 2546673 | 2620279 | 2578869 | 2600407 | 2638337 | 2739796 | 2673162 | 2701018 | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 0 | 1 | 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 | |||||||||||||||
| form_type | F615 | F615 | F615 | 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 | E00052 | E00052 | E00052 | |||||||||||||||
| filer_id | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | |||||||||||||||
| entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | |||||||||||||||
| filer_naml | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | |||||||||||||||
| filer_namf | JULIA | JULIA | JULIA | JULIA | JULIA | JULIA | JULIA | JULIA | JULIA | JULIA | JULIA | JULIA | JULIA | JULIA | JULIA | |||||||||||||||
| filer_namt | 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 | |||||||||||||||
| report_num | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||||
| rpt_date | 2020-01-29 00:00:00 | 2019-08-01 00:00:00 | 2019-10-30 00:00:00 | 2020-04-29 00:00:00 | 2020-01-29 00:00:00 | 2020-07-29 00:00:00 | 2020-10-29 00:00:00 | 2021-01-25 00:00:00 | 2021-10-27 00:00:00 | 2021-04-29 00:00:00 | 2021-07-30 00:00:00 | 2022-01-26 00:00:00 | 2022-10-24 00:00:00 | 2022-04-28 00:00:00 | 2022-07-26 00:00:00 | |||||||||||||||
| from_date | 2019-10-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2019-10-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | |||||||||||||||
| thru_date | 2019-12-31 00:00:00 | 2019-06-30 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2019-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | |||||||||||||||
| cum_beg_dt | None | None | None | 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 | E00052 | E00052 | E00052 | |||||||||||||||
| firm_name | Association of California Water Agencies | Association of California Water Agencies | Association of California Water Agencies | Association of California Water Agencies | Association of California Water Agencies | Association of California Water Agencies | Association of California Water Agencies | Association of California Water Agencies | Association of California Water Agencies | Association of California Water Agencies | Association of California Water Agencies | Association of California Water Agencies | Association of California Water Agencies | Association of California Water Agencies | Association of California Water Agencies | |||||||||||||||
| firm_city | 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 | |||||||||||||||
| firm_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||||||||
| firm_phon | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | |||||||||||||||
| mail_city | 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 | |||||||||||||||
| mail_zip4 | 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 | |||||||||||||||
| sig_date | 2020-01-29 00:00:00 | 2019-08-01 00:00:00 | 2019-10-30 00:00:00 | 2020-04-29 00:00:00 | 2020-01-30 00:00:00 | 2020-07-29 00:00:00 | 2020-10-29 00:00:00 | 2021-01-25 00:00:00 | 2021-10-27 00:00:00 | 2021-04-29 00:00:00 | 2021-07-30 00:00:00 | 2022-01-26 00:00:00 | 2022-10-24 00:00:00 | 2022-04-28 00:00:00 | 2022-07-26 00:00:00 | |||||||||||||||
| sig_loc | Sacramento CA | Sacramento CA | Sacramento | Sacramento CA | Sacramento CA | Sacramento | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | |||||||||||||||
| sig_naml | Bishop | Bishop | Bishop | Bishop | Bishop | Bishop | Bishop | Bishop | Bishop | Bishop | Bishop | Bishop | Bishop | Bishop | Bishop | |||||||||||||||
| sig_namf | Julia | Julia | Julia | Julia | Julia | Julia | Julia | Julia | Julia | Julia | Julia | Julia | Julia | Julia | Julia | |||||||||||||||
| sig_namt | 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 | |||||||||||||||
| prn_naml | None | None | None | 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 | None | None | None | |||||||||||||||
| prn_namt | 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 | |||||||||||||||
| sig_title | None | None | None | 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 | X | X | X | |||||||||||||||
| nopart2_cb | 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 | |||||||||||||||
| part1_2_cb | 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 | |||||||||||||||
| ctrib_y_cb | 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 | |||||||||||||||
| lobby_n_cb | 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 | |||||||||||||||
| major_naml | 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 | |||||||||||||||
| major_namt | 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 | |||||||||||||||
| rcpcmte_nm | 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 |
| filing_id | 2400907 | 2547069 | ||
|---|---|---|---|---|
| amend_id | 0 | 0 | ||
| rec_type | CVR | CVR | ||
| form_type | F604 | F604 | ||
| sender_id | E00052 | E00052 | ||
| filer_id | 1419821 | 1419821 | ||
| entity_cd | LBY | LBY | ||
| filer_naml | BISHOP | BISHOP | ||
| filer_namf | JULIA | JULIA | ||
| filer_namt | None | None | ||
| filer_nams | None | None | ||
| report_num | 000 | 000 | ||
| rpt_date | 2019-08-01 00:00:00 | 2020-12-22 00:00:00 | ||
| ls_beg_yr | 2019 | 2021 | ||
| ls_end_yr | 2020 | 2022 | ||
| qual_date | None | None | ||
| eff_date | None | None | ||
| bus_city | SACRAMENTO | SACRAMENTO | ||
| bus_st | CA | CA | ||
| bus_zip4 | 95814 | 95814 | ||
| bus_phon | 916-441-4545 | 9164414545 | ||
| bus_fax | None | None | ||
| bus_email | None | [email protected] | ||
| mail_city | None | None | ||
| mail_st | None | None | ||
| mail_zip4 | None | None | ||
| mail_phon | None | None | ||
| sig_date | 2019-08-01 00:00:00 | 2020-12-22 00:00:00 | ||
| sig_loc | None | None | ||
| sig_naml | Bishop | Julia | ||
| sig_namf | Julia | Hall | ||
| sig_namt | None | None | ||
| sig_nams | None | None | ||
| prn_naml | None | None | ||
| prn_namf | None | None | ||
| prn_namt | None | None | ||
| prn_nams | None | None | ||
| sig_title | None | None | ||
| stmt_firm | None | None | ||
| ind_cb | None | None | ||
| bus_cb | None | None | ||
| trade_cb | None | None | ||
| oth_cb | None | None | ||
| a_b_name | None | None | ||
| a_b_city | None | None | ||
| a_b_st | None | None | ||
| a_b_zip4 | None | None | ||
| descrip_1 | None | None | ||
| descrip_2 | None | None | ||
| c_less50 | None | None | ||
| c_more50 | None | None | ||
| ind_class | None | None | ||
| ind_descr | None | None | ||
| bus_class | None | None | ||
| bus_descr | None | None | ||
| auth_name | None | None | ||
| auth_city | None | None | ||
| auth_st | None | None | ||
| auth_zip4 | None | None | ||
| lobby_int | None | None | ||
| influen_yn | None | None | ||
| firm_name | ASSOCIATION OF CALIFORNIA WATER AGENCIES | ASSOCIATION OF CALIFORNIA WATER AGENCIES | ||
| newcert_cb | None | None | ||
| rencert_cb | None | None | ||
| complet_dt | 2019-06-27 00:00:00 | 2020-11-19 00:00:00 | ||
| lby_reg_cb | X | None | ||
| lby_604_cb | None | X | ||
| st_leg_yn | Y | Y | ||
| st_agency | None | None | ||
| lobby_cb | None | None | ||
| l_firm_cb | None | None |
| filer_id | 1419821 | 1419821 | 1419821 | |||
|---|---|---|---|---|---|---|
| adrid | 2544760 | 2506486 | 2482060 | |||
| effect_dt | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-04-29 00:00:00 | |||
| add_type | 7051 | 7051 | 7051 | |||
| session_id | 2023 | 2021 | 2019 |
| filer_id | 1419821 | 1419821 | ||
|---|---|---|---|---|
| session_id | 2019 | 2021 | ||
| ethics_date | 2019-06-27 00:00:00 | 2020-11-19 00:00:00 |
| filer_id | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 2400907 | 2400908 | 2417794 | 2438532 | 2468593 | 2578869 | 2556785 | 2547069 | 2526527 | 2482573 | 2391729 | 2391734 | 2438532 | 2600407 | 2673162 | 2701018 | 2546673 | 2620279 | 2638337 | 2739796 | ||||||||||||||||||||
| period_id | 239 | 238 | 239 | 240 | 241 | 245 | None | 244 | 243 | 242 | None | None | 240 | 246 | 249 | 250 | 244 | 247 | 248 | 251 | ||||||||||||||||||||
| form_id | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
| filing_date | 2019-08-01 00:00:00 | 2019-08-01 00:00:00 | 2019-10-30 00:00:00 | 2020-01-30 00:00:00 | 2020-04-29 00:00:00 | 2021-04-29 00:00:00 | 2020-12-28 00:00:00 | 2021-01-25 00:00:00 | 2020-10-29 00:00:00 | 2020-07-29 00:00:00 | 2019-05-02 00:00:00 | 2019-07-02 00:00:00 | 2020-01-29 00:00:00 | 2021-07-30 00:00:00 | 2022-04-28 00:00:00 | 2022-07-26 00:00:00 | 2021-01-25 00:00:00 | 2021-10-27 00:00:00 | 2022-01-26 00:00:00 | 2022-10-24 00:00:00 | ||||||||||||||||||||
| stmnt_type | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||
| stmnt_status | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||
| session_id | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | ||||||||||||||||||||
| user_id | CAFILER | VUKSTINA | AGLADNEY | GTAYLOR | VUKSTINA | CHARTRIDGE | SARRIAGA | SARRIAGA | MKIRKHAM | CVANLIEW | SARRIAGA | SARRIAGA | VUKSTINA | GTAYLOR | CAFILER | CAFILER | GTAYLOR | CHATRIDGE | RATTIYEH | CAFILER | ||||||||||||||||||||
| special_audit | 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 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||
| rpt_start | 2019-08-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2021-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-22 00:00:00 | 2020-07-01 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-04-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2020-10-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||
| rpt_end | 2019-08-01 00:00:00 | 2019-06-30 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2021-03-31 00:00:00 | 1900-01-01 00:00:00 | 2020-12-22 00:00:00 | 2020-09-30 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-06-30 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-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 | ||||||||||||||||||||
| filing_type | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
| filer_id | 1419821 | 1419821 | 1419821 | |||
|---|---|---|---|---|---|---|
| filer_type | 4 | 4 | 4 | |||
| active | Y | Y | N | |||
| race | None | 0 | None | |||
| session_id | 2021 | 2019 | 2023 | |||
| category | None | 0 | None | |||
| category_type | None | 0 | None | |||
| sub_category | None | 0 | None | |||
| effect_dt | 2021-01-01 00:00:00 | 2019-04-29 00:00:00 | 2023-01-01 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 | 1419821 | |
|---|---|---|
| xref_id | 1419821 | |
| effect_dt | 2019-07-22 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | |||||||||
| filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | |||||||||
| status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | |||||||||
| effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||
| naml | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | BISHOP | |||||||||
| namf | JULIA | JULIA | JULIA | JULIA | JULIA | JULIA | JULIA | JULIA | JULIA | |||||||||
| 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 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | 9164414545 | |||||||||
| 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 | 1419821 |
|---|
| filer_id | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | 1419821 | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 440805.cal | 442756.cal | 2438532_0.cal | 2400907_0.cal | 2400908_0.cal | 2468593_0.cal | 2482573_0.cal | 2417794_0.cal | 2438532_1.cal | 439949.cal | 440207.cal | 440282.cal | 2600407_0.cal | 2578869_0.cal | 2546673_0.cal | 2673162_0.cal | 2526527_0.cal | 2620279_0.cal | 2701018_0.cal | 2739796_0.cal | 2638337_0.cal | |||||||||||||||||||||
| received_date | 2020-04-29 00:00:00 | 2020-04-29 00:00:00 | 2020-01-29 00:00:00 | 2019-08-01 00:00:00 | 2019-08-01 00:00:00 | 2020-04-29 00:00:00 | 2020-07-29 00:00:00 | 2019-10-30 00:00:00 | 2020-01-30 00:00:00 | 2020-04-29 00:00:00 | 2020-04-29 00:00:00 | 2020-04-29 00:00:00 | 2021-07-30 00:00:00 | 2021-04-29 00:00:00 | 2021-01-25 00:00:00 | 2022-04-28 00:00:00 | 2020-10-29 00:00:00 | 2021-10-27 00:00:00 | 2022-07-26 00:00:00 | 2022-10-24 00:00:00 | 2022-01-26 00:00:00 | |||||||||||||||||||||
| filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /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/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /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 | None | None | 2438532 | 2400907 | 2400908 | 2468593 | 2482573 | 2417794 | 2438532 | None | None | None | 2600407 | 2578869 | 2546673 | 2673162 | 2526527 | 2620279 | 2701018 | 2739796 | 2638337 | |||||||||||||||||||||
| form_id | None | None | F615 | F604 | F615 | F615 | F615 | F615 | F615 | None | None | None | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||||||||||||||
| receive_comment | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |