| filing_id | 1997584 | 2061581 | 2036214 | 2011602 | 2011602 | 2102068 | 2156767 | 2174791 | 2128231 | 2192862 | 2208917 | 2273344 | 2239298 | 2348163 | 2348163 | 2395672 | 2317988 | 2375820 | 2415813 | 2470425 | 2438965 | 2554586 | 2529529 | 2484702 | 2618468 | 2638462 | 2602176 | 2580897 | 2676134 | 2704888 | 2749015 | |||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||||||||||||||||||||||
| form_type | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | |||||||||||||||||||||||||||||||
| sender_id | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | |||||||||||||||||||||||||||||||
| filer_id | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | |||||||||||||||||||||||||||||||
| 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 | FRM | FRM | FRM | FRM | FRM | FRM | FRM | |||||||||||||||||||||||||||||||
| filer_naml | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | |||||||||||||||||||||||||||||||
| filer_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 | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||
| 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 | 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 | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||
| report_num | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||||||||||||||||||||
| rpt_date | 2015-10-31 00:00:00 | 2016-07-31 00:00:00 | 2016-04-30 00:00:00 | 2016-02-01 00:00:00 | 2016-04-01 00:00:00 | 2016-10-31 00:00:00 | 2017-04-30 00:00:00 | 2017-07-31 00:00:00 | 2017-01-31 00:00:00 | 2017-10-31 00:00:00 | 2018-01-31 00:00:00 | 2018-07-19 00:00:00 | 2018-04-30 00:00:00 | 2019-01-24 00:00:00 | 2019-01-24 00:00:00 | 2019-07-25 00:00:00 | 2018-10-15 00:00:00 | 2019-04-30 00:00:00 | 2019-10-21 00:00:00 | 2020-04-18 00:00:00 | 2040-01-28 00:00:00 | 2021-01-30 00:00:00 | 2020-10-12 00:00:00 | 2020-07-28 00:00:00 | 2021-10-14 00:00:00 | 2022-01-25 00:00:00 | 2021-07-22 00:00:00 | 2021-04-24 00:00:00 | 2022-04-28 00:00:00 | 2022-07-20 00:00:00 | 2022-10-20 00:00:00 | |||||||||||||||||||||||||||||||
| from_date | 2015-07-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2015-10-01 00:00:00 | 2015-10-01 00:00:00 | 2016-07-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2016-10-01 00:00:00 | 2017-07-01 00:00:00 | 2017-10-01 00:00:00 | 2018-04-01 00:00:00 | 2018-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-10-01 00:00:00 | 2019-04-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2019-10-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||
| thru_date | 2015-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2015-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-09-30 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2016-12-31 00:00:00 | 2017-09-30 00:00:00 | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 2018-03-31 00:00:00 | 2018-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||
| cum_beg_dt | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-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 | |||||||||||||||||||||||||||||||
| firm_id | 1376914 | None | None | 1376914 | 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 | |||||||||||||||||||||||||||||||
| firm_name | None | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | None | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | |||||||||||||||||||||||||||||||
| firm_city | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | |||||||||||||||||||||||||||||||
| 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 | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||||||||
| firm_zip4 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | |||||||||||||||||||||||||||||||
| firm_phon | 9163167459 | (916) 316-7459 | (916) 316-7459 | 9163167459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | |||||||||||||||||||||||||||||||
| 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 | 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 | 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 | 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 | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||
| sig_date | 2015-10-31 00:00:00 | 2016-07-18 00:00:00 | 2016-04-11 00:00:00 | 2016-02-01 00:00:00 | 2016-04-01 00:00:00 | 2016-10-26 00:00:00 | 2017-04-21 00:00:00 | 2017-07-18 00:00:00 | 2017-01-26 00:00:00 | 2017-10-23 00:00:00 | 2018-01-26 00:00:00 | 2018-07-19 00:00:00 | 2018-04-23 00:00:00 | 2019-02-10 00:00:00 | 2019-01-24 00:00:00 | 2019-07-25 00:00:00 | 2018-10-15 00:00:00 | 2019-04-14 00:00:00 | 2019-10-21 00:00:00 | 2020-04-18 00:00:00 | 2020-01-28 00:00:00 | 2021-01-30 00:00:00 | 2020-10-12 00:00:00 | 2020-07-28 00:00:00 | 2021-10-14 00:00:00 | 2022-01-25 00:00:00 | 2021-07-22 00:00:00 | 2021-04-24 00:00:00 | 2022-04-28 00:00:00 | 2022-07-20 00:00:00 | 2022-10-20 00:00:00 | |||||||||||||||||||||||||||||||
| sig_loc | Loomis, CA | LOOMIS, CA | LOOMIS, CA | Loomis | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | |||||||||||||||||||||||||||||||
| sig_naml | Ayers | AYERS | AYERS | Ayers | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | |||||||||||||||||||||||||||||||
| sig_namf | Glen | GLEN | GLEN | Glen | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | |||||||||||||||||||||||||||||||
| 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 | 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 | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||
| prn_naml | Ayers | AYERS | AYERS | Ayers | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | |||||||||||||||||||||||||||||||
| prn_namf | Glen | GLEN | GLEN | Glen | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | |||||||||||||||||||||||||||||||
| 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 | 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 | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||
| sig_title | Manager | OWNER 464800LAS | OWNER 464800LAS | Owner | OWNER | OWNER 464800LAS | OWNER 464800LAS | OWNER 464800LAS | OWNER 464800LAS | OWNER 464800LAS | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | OWNER | |||||||||||||||||||||||||||||||
| nopart1_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 | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||
| nopart2_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 | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||
| part1_1_cb | None | X | X | X | None | X | X | 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_2_cb | None | None | None | None | X | 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 | |||||||||||||||||||||||||||||||
| ctrib_n_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 | X | X | X | X | X | X | X | |||||||||||||||||||||||||||||||
| 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 | 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 | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||
| lobby_n_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 | X | X | X | X | X | X | X | |||||||||||||||||||||||||||||||
| 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 | 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 | 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 | 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 | 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 | 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 | 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 | None | None | None | None | None | None | None |
| filing_id | 2020111 | 2024027 | 2117069 | 2118970 | 2118970 | 2118970 | 2118970 | 2118970 | 2118970 | 2118970 | 2118970 | 2118970 | 2118970 | 2331246 | 2329109 | 2329109 | 2329109 | 2329109 | 2329109 | 2329109 | 2541169 | 2540794 | 2541169 | 2541169 | 2541169 | 2541169 | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 1 | 0 | 3 | 4 | 2 | 7 | 6 | 5 | 9 | 8 | 0 | 0 | 1 | 3 | 2 | 5 | 4 | 0 | 0 | 1 | 2 | 4 | 3 | ||||||||||||||||||||||||||
| 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 | CVR | CVR | ||||||||||||||||||||||||||
| form_type | F601 | F602 | F602 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F602 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F602 | F601 | F601 | F601 | F601 | ||||||||||||||||||||||||||
| sender_id | 1376914 | 1377383 | 1377383 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1377383 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1377383 | 1376914 | 1376914 | 1376914 | 1376914 | ||||||||||||||||||||||||||
| filer_id | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | ||||||||||||||||||||||||||
| entity_cd | FRM | LEM | LEM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | LEM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | LEM | FRM | FRM | FRM | FRM | ||||||||||||||||||||||||||
| filer_naml | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | ||||||||||||||||||||||||||
| filer_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 | None | None | ||||||||||||||||||||||||||
| 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 | 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 | None | None | ||||||||||||||||||||||||||
| report_num | 000 | 000 | 000 | 001 | 000 | 003 | 004 | 002 | 007 | 006 | 005 | 009 | 008 | 000 | 000 | 001 | 003 | 002 | 005 | 004 | 000 | 000 | 001 | 002 | 004 | 003 | ||||||||||||||||||||||||||
| rpt_date | 2016-03-08 00:00:00 | 2016-03-25 00:00:00 | 2016-12-31 00:00:00 | 2017-03-06 00:00:00 | 2016-12-31 00:00:00 | 2017-04-10 00:00:00 | 2017-06-12 00:00:00 | 2017-03-17 00:00:00 | 2017-12-06 00:00:00 | 2017-09-08 00:00:00 | 2017-09-08 00:00:00 | 2018-03-05 00:00:00 | 2018-02-09 00:00:00 | 2018-12-30 00:00:00 | 2018-12-30 00:00:00 | 2019-02-28 00:00:00 | 2019-12-06 00:00:00 | 2019-08-14 00:00:00 | 2020-10-11 00:00:00 | 2020-02-03 00:00:00 | 2020-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-02-03 00:00:00 | 2021-04-24 00:00:00 | 2022-03-22 00:00:00 | 2021-04-24 00:00:00 | ||||||||||||||||||||||||||
| ls_beg_yr | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||
| ls_end_yr | 2016 | 2016 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | ||||||||||||||||||||||||||
| qual_date | 2015-03-31 00:00:00 | None | None | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||
| eff_date | None | 2016-03-25 00:00:00 | 2017-01-01 00:00:00 | None | None | None | None | None | None | None | None | None | None | 2019-01-01 00:00:00 | None | None | None | None | None | None | None | 2021-01-01 00:00:00 | None | None | None | None | ||||||||||||||||||||||||||
| bus_city | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | ||||||||||||||||||||||||||
| bus_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 | CA | CA | ||||||||||||||||||||||||||
| bus_zip4 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | ||||||||||||||||||||||||||
| bus_phon | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | (916) 316-7459 | ||||||||||||||||||||||||||
| bus_fax | 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 | ||||||||||||||||||||||||||
| bus_email | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | ||||||||||||||||||||||||||
| 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 | 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 | 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 | 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 | None | None | ||||||||||||||||||||||||||
| sig_date | 2016-03-08 00:00:00 | 2016-03-25 00:00:00 | 2016-12-01 00:00:00 | 2017-03-06 00:00:00 | 2016-12-01 00:00:00 | 2017-04-10 00:00:00 | 2017-06-12 00:00:00 | 2017-03-17 00:00:00 | 2017-12-06 00:00:00 | 2017-10-12 00:00:00 | 2017-09-08 00:00:00 | 2018-03-05 00:00:00 | 2018-02-09 00:00:00 | 2018-12-15 00:00:00 | 2018-12-15 00:00:00 | 2019-02-28 00:00:00 | 2019-12-06 00:00:00 | 2019-08-14 00:00:00 | 2020-10-11 00:00:00 | 2020-02-03 00:00:00 | 2020-12-30 00:00:00 | 2020-11-17 00:00:00 | 2021-02-03 00:00:00 | 2021-04-24 00:00:00 | 2022-03-22 00:00:00 | 2021-04-24 00:00:00 | ||||||||||||||||||||||||||
| sig_loc | LOOMIS, CA | SACRAMENTO, CA | SACRAMENTO, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | SACRAMENTO, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | SACRAMENTO, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | LOOMIS, CA | ||||||||||||||||||||||||||
| sig_naml | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | ||||||||||||||||||||||||||
| sig_namf | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN V. | GLEN | GLEN | GLEN | GLEN | ||||||||||||||||||||||||||
| 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 | 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 | None | None | ||||||||||||||||||||||||||
| prn_naml | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | AYERS | ||||||||||||||||||||||||||
| prn_namf | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN | GLEN V. | GLEN | GLEN | GLEN | GLEN | ||||||||||||||||||||||||||
| 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 | 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 | None | None | ||||||||||||||||||||||||||
| sig_title | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | MANAGER | ||||||||||||||||||||||||||
| stmt_firm | GENTLE RIVERS CONSULTING LLC | None | None | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | None | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | None | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | ||||||||||||||||||||||||||
| ind_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 | None | None | ||||||||||||||||||||||||||
| bus_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 | None | None | ||||||||||||||||||||||||||
| trade_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 | None | None | ||||||||||||||||||||||||||
| oth_cb | None | X | X | None | None | None | None | None | None | None | None | None | None | X | None | None | None | None | None | None | None | X | None | None | None | None | ||||||||||||||||||||||||||
| a_b_name | 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 | ||||||||||||||||||||||||||
| a_b_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 | None | None | ||||||||||||||||||||||||||
| a_b_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 | None | None | ||||||||||||||||||||||||||
| a_b_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 | None | None | ||||||||||||||||||||||||||
| descrip_1 | 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 | ||||||||||||||||||||||||||
| descrip_2 | 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 | ||||||||||||||||||||||||||
| c_less50 | 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 | ||||||||||||||||||||||||||
| c_more50 | 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 | ||||||||||||||||||||||||||
| ind_class | 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 | ||||||||||||||||||||||||||
| ind_descr | 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 | ||||||||||||||||||||||||||
| bus_class | 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 | ||||||||||||||||||||||||||
| bus_descr | 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 | ||||||||||||||||||||||||||
| auth_name | None | BRYANT GOVERNMENT AFFAIRS | BRYANT GOVERNMENT AFFAIRS | None | None | None | None | None | None | None | None | None | None | BRYANT GOVERNMENT AFFAIRS | None | None | None | None | None | None | None | BRYANT GOVERNMENT AFFAIRS | None | None | None | None | ||||||||||||||||||||||||||
| auth_city | None | SACRAMENTO | SACRAMENTO | None | None | None | None | None | None | None | None | None | None | SACRAMENTO | None | None | None | None | None | None | None | SACRAMENTO | None | None | None | None | ||||||||||||||||||||||||||
| auth_st | None | CA | CA | None | None | None | None | None | None | None | None | None | None | CA | None | None | None | None | None | None | None | CA | None | None | None | None | ||||||||||||||||||||||||||
| auth_zip4 | None | 95814 | 95814 | None | None | None | None | None | None | None | None | None | None | 95814 | None | None | None | None | None | None | None | 95814 | None | None | None | None | ||||||||||||||||||||||||||
| lobby_int | 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 | ||||||||||||||||||||||||||
| influen_yn | 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 | ||||||||||||||||||||||||||
| firm_name | 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 | ||||||||||||||||||||||||||
| newcert_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 | None | None | ||||||||||||||||||||||||||
| rencert_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 | None | None | ||||||||||||||||||||||||||
| complet_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 | None | None | ||||||||||||||||||||||||||
| lby_reg_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 | None | None | ||||||||||||||||||||||||||
| lby_604_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 | None | None | ||||||||||||||||||||||||||
| st_leg_yn | 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 | ||||||||||||||||||||||||||
| st_agency | 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 | ||||||||||||||||||||||||||
| lobby_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 | None | None | ||||||||||||||||||||||||||
| l_firm_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 | None | None |
| filer_id | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| adrid | 2502924 | 2412456 | 2546914 | 2507067 | 2467855 | 2360668 | ||||||
| effect_dt | 2020-10-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-03-31 00:00:00 | ||||||
| add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||
| session_id | 2019 | 2017 | 2023 | 2021 | 2019 | 2015 |
| filer_id | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 1968459 | 1971795 | 1960059 | 1990808 | 1984711 | 2329109 | 2415813 | 2329109 | 2424302 | 2198597 | 2438965 | 2192862 | 2239298 | 2118970 | 2362952 | 2208917 | 2446283 | 2118970 | 2219997 | 2375489 | 2408231 | 2118970 | 1997584 | 2020877 | 2024027 | 2011602 | 2011602 | 2026426 | 2020111 | 2036214 | 2061581 | 2102068 | 2117069 | 2118970 | 2128231 | 2148105 | 2118970 | 2118970 | 2150618 | 2131940 | 2118970 | 2134602 | 2174791 | 2148320 | 2156767 | 2118970 | 2163907 | 2189329 | 2331246 | 2529529 | 2348163 | 2484702 | 2118970 | 2541169 | 2470425 | 2329109 | 2329109 | 2541169 | 2183777 | 2339355 | 2348163 | 2395672 | 2540794 | 2118970 | 2329109 | 2317988 | 2215701 | 2273344 | 2375820 | 2595863 | 2602176 | 2566202 | 2329109 | 2541169 | 2541169 | 2522853 | 2664412 | 2704888 | 2638462 | 2554586 | 2623092 | 2717948 | 2618468 | 2676134 | 2541169 | 2580897 | 2570275 | 2612040 | 2749015 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| period_id | None | None | None | None | None | 237 | 239 | 236 | None | None | 240 | 231 | 233 | 233 | None | 232 | None | 232 | None | None | None | 231 | 223 | None | 225 | 224 | 224 | None | 225 | 225 | 226 | 227 | 228 | 228 | 228 | None | 230 | 229 | None | None | 229 | None | 230 | None | 229 | 230 | None | None | 236 | 243 | 236 | 242 | 231 | 244 | 241 | 239 | 241 | 246 | None | None | 236 | 238 | 244 | 233 | 240 | 235 | None | 234 | 237 | None | 246 | None | 244 | 245 | 246 | None | None | 250 | 248 | 244 | None | None | 247 | 249 | 249 | 245 | None | None | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F625 | F605 | F601 | F605 | F625 | F601 | F625 | F601 | F605 | F605 | F625 | F625 | F625 | F601 | F601 | F625 | F605 | F601 | F605 | F605 | F605 | F601 | F625 | F605 | F602 | F625 | F625 | F602 | F601 | F625 | F625 | F625 | F602 | F601 | F625 | F605 | F601 | F601 | F605 | F601 | F601 | F602 | F625 | F605 | F625 | F601 | F605 | F605 | F602 | F625 | F625 | F625 | F601 | F601 | F625 | F601 | F601 | F601 | F605 | F602 | F625 | F625 | F602 | F601 | F601 | F625 | F605 | F625 | F625 | F605 | F625 | F602 | F601 | F601 | F601 | F605 | F605 | F625 | F625 | F625 | F605 | F605 | F625 | F625 | F601 | F625 | F601 | F605 | F625 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 7 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 2 | 4 | 3 | 0 | 0 | 1 | 0 | 0 | 8 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_date | 2015-04-29 00:00:00 | 2015-06-19 00:00:00 | 2015-04-13 00:00:00 | 2015-08-31 00:00:00 | 2015-07-30 00:00:00 | 2019-03-04 00:00:00 | 2019-10-26 00:00:00 | 2018-12-20 00:00:00 | 2019-12-09 00:00:00 | 2017-12-15 00:00:00 | 2020-01-29 00:00:00 | 2017-10-30 00:00:00 | 2018-04-27 00:00:00 | 2018-03-05 00:00:00 | 2018-12-21 00:00:00 | 2018-01-30 00:00:00 | 2020-02-04 00:00:00 | 2017-12-15 00:00:00 | 2018-03-05 00:00:00 | 2019-03-04 00:00:00 | 2019-08-16 00:00:00 | 2017-10-19 00:00:00 | 2015-10-31 00:00:00 | 2016-03-11 00:00:00 | 2016-03-28 00:00:00 | 2016-04-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-29 00:00:00 | 2016-03-11 00:00:00 | 2016-04-29 00:00:00 | 2016-07-29 00:00:00 | 2016-10-31 00:00:00 | 2017-01-04 00:00:00 | 2017-01-11 00:00:00 | 2017-01-30 00:00:00 | 2017-03-06 00:00:00 | 2017-04-10 00:00:00 | 2017-04-10 00:00:00 | 2017-04-10 00:00:00 | 2017-01-11 00:00:00 | 2017-03-06 00:00:00 | 2017-01-04 00:00:00 | 2017-07-30 00:00:00 | 2017-03-20 00:00:00 | 2017-04-30 00:00:00 | 2017-06-12 00:00:00 | 2017-06-12 00:00:00 | 2017-10-19 00:00:00 | 2018-12-31 00:00:00 | 2020-11-01 00:00:00 | 2019-01-31 00:00:00 | 2020-07-30 00:00:00 | 2017-09-08 00:00:00 | 2020-12-30 00:00:00 | 2020-04-30 00:00:00 | 2019-08-16 00:00:00 | 2020-02-04 00:00:00 | 2021-08-19 00:00:00 | 2017-09-11 00:00:00 | 2018-12-31 00:00:00 | 2019-02-21 00:00:00 | 2019-07-29 00:00:00 | 2020-12-30 00:00:00 | 2018-02-13 00:00:00 | 2019-12-09 00:00:00 | 2018-10-30 00:00:00 | 2018-02-14 00:00:00 | 2018-07-30 00:00:00 | 2019-04-22 00:00:00 | 2021-02-11 00:00:00 | 2021-08-01 00:00:00 | 2020-12-31 00:00:00 | 2020-10-15 00:00:00 | 2021-02-10 00:00:00 | 2021-05-06 00:00:00 | 2020-10-16 00:00:00 | 2022-03-30 00:00:00 | 2022-07-29 00:00:00 | 2022-01-26 00:00:00 | 2021-02-01 00:00:00 | 2021-08-19 00:00:00 | 2022-08-30 00:00:00 | 2021-10-23 00:00:00 | 2022-05-02 00:00:00 | 2022-03-30 00:00:00 | 2021-04-30 00:00:00 | 2020-12-31 00:00:00 | 2021-05-06 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_type | 10005 | 10006 | 10005 | 10006 | 10005 | 10002 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10005 | 10002 | 10005 | 10005 | 10005 | 10002 | 10001 | 10005 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10002 | 10005 | 10005 | 10002 | 10005 | 10001 | 10005 | 10001 | 10002 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10002 | 10002 | 10005 | 10001 | 10002 | 10001 | 10001 | 10002 | 10002 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10005 | 10002 | 10002 | 10002 | 10002 | 10002 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10002 | 10001 | 10005 | 10002 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| session_id | 2015 | 2015 | 2015 | 2015 | 2015 | 2019 | 2019 | 2019 | 2019 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2021 | 2019 | 2019 | 2019 | 2021 | 2017 | 2019 | 2017 | 2019 | 2021 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| user_id | AGLADNEY | YRODRIGU | YRODRIGU | YRODRIGU | AGLADNEY | GPEREZ | AGLADNEY | GPEREZ | GPEREZ | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | GPEREZ | AGLADNEY | GPEREZ | GPEREZ | GPEREZ | GPEREZ | SARRIAGA | YRODRIGU | AGLADNEY | GPEREZ | GPEREZ | AGLADNEY | AGLADNEY | GPEREZ | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | GPEREZ | AGLADNEY | SARRIAGA | GPEREZ | SARRIAGA | SARRIAGA | SARRIAGA | SARRIAGA | YRODRIGU | AGLADNEY | SARRIAGA | AGLADNEY | GPEREZ | GPEREZ | YRODRIGU | CAFILER | CHARTRIDGE | AGLADNEY | MKIRKHAM | GPEREZ | SARRIAGA | MKIRKHAM | SARRIAGA | GPEREZ | MKIRKHAM | GPEREZ | MXIONG | AGLADNEY | AGLADNEY | SARRIAGA | GPEREZ | GPEREZ | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | MMERCHANT | CHATRIDGE | SARRIAGA | AROJAS | MMERCHANT | MMERCHANT | AROJAS | MMERCHANT | CAFILER | CHATRIDGE | MKIRKHAM | MKIRKHAM | CVANLIEW | CHATRIDGE | CAFILER | MMERCHANT | MKIRKHAM | SARRIAGA | MMERCHANT | 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 | 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 | 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 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_start | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-04-01 00:00:00 | 2019-02-28 00:00:00 | 2019-07-01 00:00:00 | 2018-12-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-10-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-03-05 00:00:00 | 1900-01-01 00:00:00 | 2017-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-12-06 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-09-08 00:00:00 | 2015-07-01 00:00:00 | 1900-01-01 00:00:00 | 2016-03-25 00:00:00 | 2015-10-01 00:00:00 | 2015-10-01 00:00:00 | 1900-01-01 00:00:00 | 2016-03-08 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-10 00:00:00 | 2017-03-17 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-03-06 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-06-12 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-12-30 00:00:00 | 2020-07-01 00:00:00 | 2018-10-01 00:00:00 | 2020-04-01 00:00:00 | 2017-09-08 00:00:00 | 2020-12-31 00:00:00 | 2020-01-01 00:00:00 | 2019-08-14 00:00:00 | 2020-02-03 00:00:00 | 2021-04-24 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-04-01 00:00:00 | 2020-12-31 00:00:00 | 2018-02-09 00:00:00 | 2019-12-06 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2018-04-01 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-11 00:00:00 | 2021-02-03 00:00:00 | 2021-04-24 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2020-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 2022-03-22 00:00:00 | 2021-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_end | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-06-30 00:00:00 | 2019-02-28 00:00:00 | 2019-09-30 00:00:00 | 2018-12-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-12-31 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | 2018-03-05 00:00:00 | 1900-01-01 00:00:00 | 2017-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-12-06 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-09-08 00:00:00 | 2015-09-30 00:00:00 | 1900-01-01 00:00:00 | 2016-03-25 00:00:00 | 2015-12-31 00:00:00 | 2015-12-31 00:00:00 | 1900-01-01 00:00:00 | 2016-03-08 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-04-10 00:00:00 | 2017-03-17 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-03-06 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2017-06-12 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-12-30 00:00:00 | 2020-09-30 00:00:00 | 2018-12-31 00:00:00 | 2020-06-30 00:00:00 | 2017-09-08 00:00:00 | 2020-12-31 00:00:00 | 2020-03-31 00:00:00 | 2019-08-14 00:00:00 | 2020-02-03 00:00:00 | 2021-04-24 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | 2020-12-31 00:00:00 | 2018-02-09 00:00:00 | 2019-12-06 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2018-06-30 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 2020-10-11 00:00:00 | 2021-02-03 00:00:00 | 2021-04-24 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-09-30 00:00:00 | 2022-03-31 00:00:00 | 2022-03-22 00:00:00 | 2021-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 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 | 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 | 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 | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_type | None | None | None | None | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | None | None | None | 22001 | 22006 | None | 22001 | 22001 | 22006 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | None | 22001 | None | 22001 | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 |
| filer_id | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| filer_type | 3 | 3 | 3 | 3 | 3 | |||||
| active | Y | Y | Y | Y | N | |||||
| race | None | 0 | None | None | None | |||||
| session_id | 2019 | 2015 | 2021 | 2017 | 2023 | |||||
| category | None | 0 | None | None | None | |||||
| category_type | None | 0 | None | None | None | |||||
| sub_category | None | 0 | None | None | None | |||||
| effect_dt | 2019-01-01 00:00:00 | 2015-03-31 00:00:00 | 2021-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||
| sub_category_type | None | 0 | None | None | None | |||||
| election_type | None | 0 | None | None | None | |||||
| sub_category_a | None | None | None | None | None | |||||
| nyq_dt | None | None | None | None | None | |||||
| party_cd | None | 0 | None | None | None | |||||
| county_cd | None | 0 | None | None | None | |||||
| district_cd | None | 0 | None | None | None |
| filer_id | 1376914 | |
|---|---|---|
| xref_id | 1376914 | |
| effect_dt | 2015-04-21 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | ||||||||||||||||||||||||||||||
| filer_type | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | ||||||||||||||||||||||||||||||
| status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | 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 | 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 | 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 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||||||||||||||||
| naml | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | ||||||||||||||||||||||||||||||
| 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 | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
| 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 | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
| 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 | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
| adr1 | 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 | ||||||||||||||||||||||||||||||
| adr2 | 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 | ||||||||||||||||||||||||||||||
| city | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | ||||||||||||||||||||||||||||||
| 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 | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||
| zip4 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | 95650 | ||||||||||||||||||||||||||||||
| phon | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | ||||||||||||||||||||||||||||||
| fax | 9166525725 | 9166525725 | 9166525725 | 9166525725 | 9166525725 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
| [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
| filer_id | 1376914 |
|---|
| filer_id | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| change_no | 0 | 2 | 3 | 1 | 4 | 5 | 6 | 7 | 8 | 9 | 11 | 10 | 12 | 13 | 16 | 17 | 14 | 15 | ||||||||||||||||||
| session_id | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||
| log_dt | 2015-04-13 00:00:00 | 2015-04-13 00:00:00 | 2015-06-19 00:00:00 | 2015-08-31 00:00:00 | 2016-03-11 00:00:00 | 2017-03-06 00:00:00 | 2017-03-20 00:00:00 | 2017-04-10 00:00:00 | 2017-06-12 00:00:00 | 2017-09-11 00:00:00 | 2018-03-05 00:00:00 | 2017-12-15 00:00:00 | 2018-02-14 00:00:00 | 2020-10-16 00:00:00 | 2021-08-19 00:00:00 | 2021-08-19 00:00:00 | 2021-02-11 00:00:00 | 2021-02-11 00:00:00 | ||||||||||||||||||
| filer_type | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | ||||||||||||||||||
| correction_flg | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | None | Y | None | None | None | None | None | ||||||||||||||||||
| action | ADDED | ADDED | DELETED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | DELETED | DELETED | DELETED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ||||||||||||||||||
| attribute_changed | LOBBYIST | / FIRM | / FIRM | EMPLOYER | EMPLOYER | / FIRM | EMPLOYER | EMPLOYER | / FIRM | EMPLOYER | EMPLOYER | FIRM | EMPLOYER | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | ||||||||||||||||||
| ethics_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||
| interests | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||
| filer_full_name | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | GENTLE RIVERS CONSULTING LLC | ||||||||||||||||||
| filer_city | None | LOOMIS | LOOMIS | None | LOOMIS | LOOMIS | LOOMIS | LOOMIS | LOOMIS | None | None | None | LOOMIS | None | None | None | None | None | ||||||||||||||||||
| filer_st | None | CA | CA | None | CA | CA | CA | CA | CA | None | None | None | CA | None | None | None | None | None | ||||||||||||||||||
| filer_zip | None | 95650 | 95650 | None | 95650 | 95650 | 95650 | 95650 | 95650 | None | None | None | 95650 | None | None | None | None | None | ||||||||||||||||||
| filer_phone | None | 9163167459 | 9163167459 | None | 9163167459 | 9163167459 | 9163167459 | 9163167459 | 9163167459 | None | None | None | 9163167459 | None | None | None | None | None | ||||||||||||||||||
| entity_type | 4 | 1 | 1 | 2 | 2 | 1 | 2 | 2 | 1 | 2 | 2 | 3 | 2 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||||
| entity_name | AYERS, GLEN V. | HOWARD ADVOCACY, INC. | HOWARD ADVOCACY, INC. | CALIFORNIA ASSOCIATION FOR LICENSED PROFESSIONAL CLINICAL COUNSELORS | SICPA PRODUCT SECURITY LLC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | INTERNATIONAL HEMP SOLUTIONS (IHS) PBC | AMERICAN SOCIETY OF APPRAISERS, LOS ANGELES CHAPTER | CALIFORNIA ADVOCATES, INC. | AMERICAN SOCIETY OF APPRAISERS, LOS ANGELES CHAPTER | INTERNATIONAL HEMP SOLUTIONS (IHS) PBC | EDELSTEIN, GILBERT, ROBSON & SMITH, LLC | HOLLYWOOD FOREVER | CALIFORNIA NEURODIAGNOSTIC SOCIETY | SICPA PRODUCT SECURITY | CALIFORNIA ASSOCIATION OF LICENSED REPOSSESSORS | ANIMAL PHYSICAL THERAPY COALITION | ASSOCIATION OF ENVIRONMENTAL AND ENGINEERING GEOLOGISTS | ||||||||||||||||||
| entity_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||
| entity_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||
| entity_zip | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||
| entity_phone | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||
| entity_id | 1376915 | None | None | 1380446 | None | None | None | None | None | 1395790 | 1395445 | 1147328 | None | 1434109 | 1257717 | 1143173 | 1384216 | 1143389 | ||||||||||||||||||
| responsible_officer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||
| effect_dt | 2015-03-31 00:00:00 | 2015-03-31 00:00:00 | 2015-04-30 00:00:00 | 2015-08-24 00:00:00 | 2016-03-07 00:00:00 | 2017-01-01 00:00:00 | 2017-03-15 00:00:00 | 2017-04-07 00:00:00 | 2017-06-12 00:00:00 | 2017-09-01 00:00:00 | 2018-03-05 00:00:00 | 2017-12-01 00:00:00 | 2018-02-09 00:00:00 | 2020-10-12 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 |
| filer_id | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | 1376914 | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 448629.cal | 2118970_2.cal | 2118970_1.cal | 2118970_3.cal | 2118970_0.cal | 2020111_0.cal | 2118970_4.cal | 2329109_0.cal | 56743.cal | 56774.cal | 56816.cal | 2118970_9.cal | 2118970_7.cal | 2118970_6.cal | 2118970_5.cal | 471586.cal | 2118970_8.cal | 56662.cal | 2541169_0.cal | 498744.cal | 446896.cal | 498864.cal | 498920.cal | 2541169_1.cal | 382054.cal | 2541169_3.cal | 2541169_2.cal | 2541169_4.cal | ||||||||||||||||||||||||||||
| received_date | 2017-04-10 00:00:00 | 2017-04-10 00:00:00 | 2017-03-06 00:00:00 | 2017-04-10 00:00:00 | 2017-01-11 00:00:00 | 2016-03-11 00:00:00 | 2017-06-12 00:00:00 | 2018-12-20 00:00:00 | 2017-10-19 00:00:00 | 2017-10-19 00:00:00 | 2017-10-19 00:00:00 | 2018-03-05 00:00:00 | 2017-12-15 00:00:00 | 2017-10-19 00:00:00 | 2017-09-08 00:00:00 | 2018-02-13 00:00:00 | 2018-02-13 00:00:00 | 2017-10-19 00:00:00 | 2020-12-30 00:00:00 | 2020-12-30 00:00:00 | 2020-12-30 00:00:00 | 2020-12-30 00:00:00 | 2020-12-30 00:00:00 | 2021-02-10 00:00:00 | 2020-11-01 00:00:00 | 2021-08-19 00:00:00 | 2021-05-06 00:00:00 | 2022-03-30 00:00:00 | ||||||||||||||||||||||||||||
| filing_directory | /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/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||||||||
| filing_id | None | 2118970 | 2118970 | 2118970 | 2118970 | 2020111 | 2118970 | 2329109 | None | None | None | 2118970 | 2118970 | 2118970 | 2118970 | None | 2118970 | None | 2541169 | None | None | None | None | 2541169 | None | 2541169 | 2541169 | 2541169 | ||||||||||||||||||||||||||||
| form_id | None | F601 | F601 | F601 | F601 | F601 | F601 | F601 | None | None | None | F601 | F601 | F601 | F601 | None | F601 | None | F601 | None | None | None | None | F601 | None | F601 | F601 | F601 | ||||||||||||||||||||||||||||
| receive_comment | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing did not pass validation | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted |