| filing_id | 2183479 | 2189605 | 2207423 | 2235655 | 2273042 | 2395586 | 2318763 | 2375374 | 2345108 | 2418813 | 2438040 | 2467271 | 2527278 | 2548836 | 2484046 | 2599826 | 2578719 | 2621972 | 2703405 | 2643886 | 2673307 | 2747364 | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 0 | 0 | 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 | ||||||||||||||||||||||
| form_type | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | ||||||||||||||||||||||
| sender_id | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | ||||||||||||||||||||||
| filer_id | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | ||||||||||||||||||||||
| entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | ||||||||||||||||||||||
| filer_naml | LYON CONSULTING, RJ | LYON CONSULTING, RJ | LYON CONSULTING, RJ | LYON CONSULTING, RJ | LYON CONSULTING, RJ | LYON CONSULTING; RJ | LYON CONSULTING, RJ | LYON CONSULTING; RJ | LYON CONSULTING, RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | ||||||||||||||||||||||
| filer_namf | 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 | ||||||||||||||||||||||
| filer_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
| report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | ||||||||||||||||||||||
| rpt_date | 2017-09-08 00:00:00 | 2017-10-23 00:00:00 | 2018-01-29 00:00:00 | 2018-04-25 00:00:00 | 2018-07-30 00:00:00 | 2019-07-29 00:00:00 | 2018-10-31 00:00:00 | 2019-04-22 00:00:00 | 2019-01-30 00:00:00 | 2019-10-31 00:00:00 | 2020-01-29 00:00:00 | 2020-04-24 00:00:00 | 2020-10-30 00:00:00 | 2021-01-28 00:00:00 | 2020-07-30 00:00:00 | 2021-07-29 00:00:00 | 2021-04-29 00:00:00 | 2021-10-29 00:00:00 | 2022-07-28 00:00:00 | 2022-01-31 00:00:00 | 2022-04-28 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||||||
| from_date | 2017-04-01 00:00:00 | 2017-07-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2019-04-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||
| thru_date | 2017-06-30 00:00:00 | 2017-09-30 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2019-06-30 00:00:00 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2018-12-31 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2021-09-30 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||
| cum_beg_dt | 2017-04-01 00:00:00 | 2017-04-01 00:00:00 | 2017-04-01 00:00:00 | 2017-04-01 00:00:00 | 2017-04-01 00:00:00 | 2019-01-01 00:00:00 | 2017-04-01 00:00:00 | 2019-01-01 00:00:00 | 2017-04-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 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | ||||||||||||||||||||||
| firm_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
| firm_city | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | ||||||||||||||||||||||
| firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||
| firm_zip4 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | ||||||||||||||||||||||
| firm_phon | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | ||||||||||||||||||||||
| mail_city | 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 | ||||||||||||||||||||||
| mail_zip4 | 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 | ||||||||||||||||||||||
| sig_date | 2017-09-07 00:00:00 | 2017-10-12 00:00:00 | 2018-01-24 00:00:00 | 2018-04-19 00:00:00 | 2018-07-24 00:00:00 | 2019-07-17 00:00:00 | 2018-10-28 00:00:00 | 2019-04-17 00:00:00 | 2019-01-23 00:00:00 | 2019-10-18 00:00:00 | 2020-01-17 00:00:00 | 2020-04-17 00:00:00 | 2020-10-26 00:00:00 | 2021-01-14 00:00:00 | 2020-07-15 00:00:00 | 2021-07-20 00:00:00 | 2021-04-15 00:00:00 | 2021-10-13 00:00:00 | 2022-07-22 00:00:00 | 2022-01-14 00:00:00 | 2022-04-19 00:00:00 | 2022-10-14 00:00:00 | ||||||||||||||||||||||
| sig_loc | SACRAMENTO, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | EL DORADO HILLS, CA | ||||||||||||||||||||||
| sig_naml | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | ||||||||||||||||||||||
| sig_namf | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | ||||||||||||||||||||||
| sig_namt | 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 | ||||||||||||||||||||||
| prn_naml | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | LYON | ||||||||||||||||||||||
| prn_namf | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | RICHARD | ||||||||||||||||||||||
| prn_namt | 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 | ||||||||||||||||||||||
| sig_title | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | ||||||||||||||||||||||
| nopart1_cb | 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 | ||||||||||||||||||||||
| part1_1_cb | 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 | 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 | ||||||||||||||||||||||
| 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 | ||||||||||||||||||||||
| lby_actvty | 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 | ||||||||||||||||||||||
| 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 | ||||||||||||||||||||||
| major_naml | 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 | ||||||||||||||||||||||
| major_namt | 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 | ||||||||||||||||||||||
| rcpcmte_nm | 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 |
| filing_id | 2154881 | 2330835 | 2535833 | |||
|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | |||
| rec_type | CVR | CVR | CVR | |||
| form_type | F601 | F601 | F601 | |||
| sender_id | 1396031 | 1396031 | 1396031 | |||
| filer_id | 1396031 | 1396031 | 1396031 | |||
| entity_cd | FRM | FRM | FRM | |||
| filer_naml | LYON CONSULTING, RJ | RJ LYON CONSULTING | LYON CONSULTING; RJ | |||
| filer_namf | None | None | None | |||
| filer_namt | None | None | None | |||
| filer_nams | None | None | None | |||
| report_num | 000 | 000 | 000 | |||
| rpt_date | 2017-04-27 00:00:00 | 2018-12-28 00:00:00 | 2020-11-25 00:00:00 | |||
| ls_beg_yr | 2017 | 2019 | 2021 | |||
| ls_end_yr | 2018 | 2020 | 2022 | |||
| qual_date | 2017-05-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | |||
| eff_date | None | None | None | |||
| bus_city | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | |||
| bus_st | CA | CA | CA | |||
| bus_zip4 | 95762 | 95762 | 95762 | |||
| bus_phon | 9167165484 | 9167165484 | 9167165484 | |||
| bus_fax | None | None | None | |||
| bus_email | [email protected] | [email protected] | [email protected] | |||
| mail_city | None | None | None | |||
| mail_st | None | None | None | |||
| mail_zip4 | None | None | None | |||
| mail_phon | None | None | None | |||
| sig_date | 2017-04-21 00:00:00 | 2018-12-11 00:00:00 | 2020-11-19 00:00:00 | |||
| sig_loc | None | None | None | |||
| sig_naml | LYON | LYON | LYON | |||
| sig_namf | RICHARD | RICHARD | RICHARD | |||
| sig_namt | None | None | None | |||
| sig_nams | None | None | None | |||
| prn_naml | LYON | LYON | LYON | |||
| prn_namf | RICHARD | RICHARD | RICHARD | |||
| prn_namt | None | None | None | |||
| prn_nams | None | None | None | |||
| sig_title | PRESIDENT | PRESIDENT | PRESIDENT | |||
| stmt_firm | RJ LYON CONSULTING | RJ LYON CONSULTING | RJ LYON CONSULTING | |||
| ind_cb | None | None | None | |||
| bus_cb | None | None | None | |||
| trade_cb | None | None | None | |||
| oth_cb | None | None | None | |||
| a_b_name | None | None | None | |||
| a_b_city | None | None | None | |||
| a_b_st | None | None | None | |||
| a_b_zip4 | None | None | None | |||
| descrip_1 | None | None | None | |||
| descrip_2 | None | None | None | |||
| c_less50 | None | None | None | |||
| c_more50 | None | None | None | |||
| ind_class | None | None | None | |||
| ind_descr | None | None | None | |||
| bus_class | None | None | None | |||
| bus_descr | None | None | None | |||
| auth_name | None | None | None | |||
| auth_city | None | None | None | |||
| auth_st | None | None | None | |||
| auth_zip4 | None | None | None | |||
| lobby_int | None | None | None | |||
| influen_yn | None | None | None | |||
| firm_name | None | None | None | |||
| newcert_cb | None | None | None | |||
| rencert_cb | None | None | None | |||
| complet_dt | None | None | None | |||
| lby_reg_cb | None | None | None | |||
| lby_604_cb | None | None | None | |||
| st_leg_yn | None | None | None | |||
| st_agency | None | None | None | |||
| lobby_cb | None | None | None | |||
| l_firm_cb | None | None | None |
| filer_id | 1396031 | 1396031 | 1396031 | 1396031 | ||||
|---|---|---|---|---|---|---|---|---|
| adrid | 2505728 | 2431484 | 2545062 | 2465726 | ||||
| effect_dt | 2021-01-01 00:00:00 | 2017-05-01 00:00:00 | 2023-01-01 00:00:00 | 2019-01-01 00:00:00 | ||||
| add_type | 7051 | 7051 | 7051 | 7051 | ||||
| session_id | 2021 | 2017 | 2023 | 2019 |
| filer_id | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 2189605 | 2438040 | 2343396 | 2235655 | 2154881 | 2158796 | 2345108 | 2318763 | 2207423 | 2375374 | 2484046 | 2183479 | 2599826 | 2535833 | 2527278 | 2418813 | 2273042 | 2330835 | 2395586 | 2673307 | 2467271 | 2578719 | 2548836 | 2547405 | 2643886 | 2703405 | 2621972 | 2747364 | ||||||||||||||||||||||||||||
| period_id | 231 | 240 | None | 233 | 230 | None | 236 | 235 | 232 | 237 | 242 | 230 | 246 | 244 | 243 | 239 | 234 | 236 | 238 | 249 | 241 | 245 | 244 | None | 248 | 250 | 247 | 251 | ||||||||||||||||||||||||||||
| form_id | F625 | F625 | F601 | F625 | F601 | F601 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F601 | F625 | F625 | F625 | F601 | F625 | F625 | F625 | F625 | F625 | F601 | F625 | F625 | F625 | F625 | ||||||||||||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
| filing_date | 2017-10-23 00:00:00 | 2020-01-29 00:00:00 | 2018-12-21 00:00:00 | 2018-04-25 00:00:00 | 2017-04-27 00:00:00 | 2017-04-27 00:00:00 | 2019-01-30 00:00:00 | 2018-10-31 00:00:00 | 2018-01-29 00:00:00 | 2019-04-22 00:00:00 | 2020-07-30 00:00:00 | 2017-09-08 00:00:00 | 2021-07-29 00:00:00 | 2020-11-25 00:00:00 | 2020-10-30 00:00:00 | 2019-10-31 00:00:00 | 2018-07-30 00:00:00 | 2018-12-28 00:00:00 | 2019-07-29 00:00:00 | 2022-04-28 00:00:00 | 2020-04-24 00:00:00 | 2021-04-29 00:00:00 | 2021-01-28 00:00:00 | 2020-11-30 00:00:00 | 2022-01-31 00:00:00 | 2022-07-28 00:00:00 | 2021-10-29 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||||||||||||
| stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||
| stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||
| session_id | 2017 | 2019 | 2019 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2021 | 2021 | 2019 | 2019 | 2017 | 2019 | 2019 | 2021 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||
| user_id | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | GPEREZ | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | MKIRKHAM | KBANH | MKIRKHAM | MMERCHANT | MKIRKHAM | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | CHATRIDGE | MKIRKHAM | MKIRKHAM | MKIRKHAM | MMERCHANT | CHATRIDGE | CAFILER | CHATRIDGE | 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 | ||||||||||||||||||||||||||||
| fine_audit | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||
| rpt_start | 2017-07-01 00:00:00 | 2019-10-01 00:00:00 | 1900-01-01 00:00:00 | 2018-01-01 00:00:00 | 2017-04-27 00:00:00 | 1900-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2017-10-01 00:00:00 | 2019-01-01 00:00:00 | 2020-04-01 00:00:00 | 2017-04-01 00:00:00 | 2021-04-01 00:00:00 | 2020-11-25 00:00:00 | 2020-07-01 00:00:00 | 2019-07-01 00:00:00 | 2018-04-01 00:00:00 | 2018-12-28 00:00:00 | 2019-04-01 00:00:00 | 2022-01-01 00:00:00 | 2020-01-01 00:00:00 | 2021-01-01 00:00:00 | 2020-10-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||
| rpt_end | 2017-09-30 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-03-31 00:00:00 | 2017-04-27 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2017-12-31 00:00:00 | 2019-03-31 00:00:00 | 2020-06-30 00:00:00 | 2017-06-30 00:00:00 | 2021-06-30 00:00:00 | 2020-11-25 00:00:00 | 2020-09-30 00:00:00 | 2019-09-30 00:00:00 | 2018-06-30 00:00:00 | 2018-12-28 00:00:00 | 2019-06-30 00:00:00 | 2022-03-31 00:00:00 | 2020-03-31 00:00:00 | 2021-03-31 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2021-09-30 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 | ||||||||||||||||||||||||||||
| filing_type | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 |
| filer_id | 1396031 | 1396031 | 1396031 | 1396031 | ||||
|---|---|---|---|---|---|---|---|---|
| filer_type | 3 | 3 | 3 | 3 | ||||
| active | Y | Y | Y | N | ||||
| race | 0 | None | None | None | ||||
| session_id | 2017 | 2021 | 2019 | 2023 | ||||
| category | 0 | None | None | None | ||||
| category_type | 0 | None | None | None | ||||
| sub_category | 0 | None | None | None | ||||
| effect_dt | 2017-05-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||
| sub_category_type | 0 | None | None | None | ||||
| election_type | 0 | None | None | None | ||||
| sub_category_a | None | None | None | None | ||||
| nyq_dt | None | None | None | None | ||||
| party_cd | 0 | None | None | None | ||||
| county_cd | 0 | None | None | None | ||||
| district_cd | 0 | None | None | None |
| filer_id | 1396031 | |
|---|---|---|
| xref_id | 1396031 | |
| effect_dt | 2017-04-21 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | 1396031 | ||||||||||||||||
| filer_type | 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| naml | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | LYON CONSULTING; RJ | ||||||||||||||||
| namf | 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 | ||||||||||||||||
| nams | 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 | ||||||||||||||||
| adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
| city | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | EL DORADO HILLS | ||||||||||||||||
| st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||
| zip4 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | 95762 | ||||||||||||||||
| phon | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | 9167165484 | ||||||||||||||||
| fax | None | None | None | None | None | None | None | 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] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
| filer_id | 1396031 |
|---|
| filer_id | 1396031 | 1396031 | ||
|---|---|---|---|---|
| change_no | 1 | 0 | ||
| session_id | 2017 | 2017 | ||
| log_dt | 2017-04-27 00:00:00 | 2017-04-27 00:00:00 | ||
| filer_type | 3 | 3 | ||
| correction_flg | Y | Y | ||
| action | ADDED | ADDED | ||
| attribute_changed | EMPLOYER | LOBBYIST | ||
| ethics_dt | None | None | ||
| interests | None | None | ||
| filer_full_name | LYON CONSULTING, RJ | LYON CONSULTING, RJ | ||
| filer_city | None | None | ||
| filer_st | None | None | ||
| filer_zip | None | None | ||
| filer_phone | None | None | ||
| entity_type | 2 | 4 | ||
| entity_name | CALIFORNIA BUILDING INDUSTRY ASSOCIATION | LYON, RICHARD | ||
| entity_city | None | None | ||
| entity_st | None | None | ||
| entity_zip | None | None | ||
| entity_phone | None | None | ||
| entity_id | 0 | 1148326 | ||
| responsible_officer | None | None | ||
| effect_dt | 2017-05-01 00:00:00 | 2017-05-01 00:00:00 |
| filer_id | 1396031 | 1396031 | 1396031 | |||
|---|---|---|---|---|---|---|
| filing_file_name | 2154881_0.cal | 2330835_0.cal | 2535833_0.cal | |||
| received_date | 2017-04-27 00:00:00 | 2018-12-28 00:00:00 | 2020-11-25 00:00:00 | |||
| filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||
| filing_id | 2154881 | 2330835 | 2535833 | |||
| form_id | F601 | F601 | F601 | |||
| receive_comment | Filing accepted | Filing accepted | Filing accepted |