| filing_id | 2177436 | 2183913 | 2210915 | 2273992 | 2399265 | 2347249 | 2442393 | 2485364 | 2553589 | 2644166 | 2600950 | 2705970 | 2726591 | 2726591 | 2744668 | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||||||||||||
| rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||||||
| form_type | F460 | F497 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | |||||||||||||||
| filer_id | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | |||||||||||||||
| entity_cd | RCP | RCP | RCP | RCP | RCP | RCP | RCP | RCP | RCP | RCP | RCP | RCP | RCP | RCP | RCP | |||||||||||||||
| filer_naml | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | |||||||||||||||
| filer_namf | 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 | |||||||||||||||
| filer_nams | 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 | 001 | 000 | |||||||||||||||
| rpt_date | 2017-07-28 00:00:00 | 2017-09-12 00:00:00 | 2018-01-30 00:00:00 | 2018-07-31 00:00:00 | 2019-07-30 00:00:00 | 2019-01-31 00:00:00 | 2020-01-29 00:00:00 | 2020-07-29 00:00:00 | 2021-01-26 00:00:00 | 2022-01-31 00:00:00 | 2021-07-26 00:00:00 | 2022-08-01 00:00:00 | 2022-09-29 00:00:00 | 2022-10-27 00:00:00 | 2022-10-27 00:00:00 | |||||||||||||||
| stmt_type | SA | None | SA | SA | SA | SA | SA | SA | SA | SA | SA | SA | PE | PE | PE | |||||||||||||||
| late_rptno | None | 09122017-1 | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| from_date | 2017-01-01 00:00:00 | None | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2018-07-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-07-01 00:00:00 | 2022-07-01 00:00:00 | 2022-09-25 00:00:00 | |||||||||||||||
| thru_date | 2017-06-30 00:00:00 | None | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 2019-06-30 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | 2022-09-24 00:00:00 | 2022-09-24 00:00:00 | 2022-10-22 00:00:00 | |||||||||||||||
| elect_date | None | None | None | None | None | None | None | None | None | None | None | None | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | |||||||||||||||
| filer_city | Sacramento | Sacramento | Sacramento | Sacramento | Roseville | Sacramento | Roseville | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | |||||||||||||||
| filer_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||
| filer_zip4 | 95841 | 95841 | 95841 | 95841 | 95661 | 95841 | 95661 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | |||||||||||||||
| filer_phon | 916-348-9100 | 916-348-9100 | 916-348-9100 | 916-348-9100 | 916-749-3533 | 916-348-9100 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | |||||||||||||||
| filer_fax | 916-348-9111 | 916-348-9111 | 916-348-9111 | 916-348-9111 | 916-865-4657 | 916-348-9111 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | |||||||||||||||
| file_email | [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] | |||||||||||||||
| mail_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| mail_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| mail_zip4 | 95841 | 95841 | 95841 | 95841 | None | 95841 | None | None | None | None | None | None | None | None | None | |||||||||||||||
| tres_naml | Copeland | Copeland | Copeland | Copeland | Johnson | Lewis | Johnson | Johnson | Johnson | Johnson | Johnson | Johnson | Johnson | Johnson | Johnson | |||||||||||||||
| tres_namf | Rita | Rita | Rita | Rita | Chelsea | Denise | Chelsea | Chelsea | Chelsea | Chelsea | Chelsea | Chelsea | Chelsea | Chelsea | Chelsea | |||||||||||||||
| tres_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| tres_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| tres_city | Sacramento | Sacramento | Sacramento | Sacramento | Roseville | Sacramento | Roseville | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | |||||||||||||||
| tres_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||
| tres_zip4 | 95841 | 95841 | 95841 | 95841 | 95661 | 95841 | 95661 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | |||||||||||||||
| tres_phon | 916-348-9100 | 916-348-9100 | 916-348-9100 | 916-348-9100 | 916-749-3533 | 916-348-9100 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | |||||||||||||||
| tres_fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| tres_email | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| cmtte_type | G | None | G | G | G | G | G | G | G | G | G | G | G | G | G | |||||||||||||||
| control_yn | N | None | N | N | N | N | N | N | N | N | N | N | N | N | N | |||||||||||||||
| sponsor_yn | N | None | N | N | N | N | N | N | N | N | N | N | N | N | N | |||||||||||||||
| primfrm_yn | N | None | N | N | N | N | N | N | N | N | N | N | N | N | N | |||||||||||||||
| brdbase_yn | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| amendexp_1 | None | None | None | None | None | None | None | None | None | None | None | None | None | Amend Schedules A and E and Update Summary Page | None | |||||||||||||||
| amendexp_2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| amendexp_3 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| rpt_att_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| cmtte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| reportname | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| rptfromdt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| rptthrudt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| emplbus_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| bus_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| bus_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| bus_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| bus_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| bus_inter | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| busact_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| busactvity | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| assoc_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| assoc_int | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| other_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| other_int | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| cand_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| cand_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| cand_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| cand_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| cand_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| cand_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| cand_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| cand_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| cand_fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| cand_email | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| bal_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| bal_num | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| bal_juris | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| office_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| offic_dscr | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| juris_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| juris_dscr | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| dist_no | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| off_s_h_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| sup_opp_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| employer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| occupation | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| selfemp_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| bal_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
| cand_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
| filing_id | 2184727 | 2184727 | 2184727 | 2184727 | 2184727 | 2184727 | 2184727 | 2184727 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 1 | 0 | 2 | 3 | 5 | 6 | 7 | 4 | ||||||||
| rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||
| form_type | F410 | F410 | F410 | F410 | F410 | F410 | F410 | F410 | ||||||||
| filer_id | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | ||||||||
| entity_cd | RCP | RCP | RCP | RCP | RCP | RCP | RCP | RCP | ||||||||
| filer_naml | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | Sierra Forward | ||||||||
| filer_namf | None | None | None | None | None | None | None | None | ||||||||
| filer_namt | None | None | None | None | None | None | None | None | ||||||||
| filer_nams | None | None | None | None | None | None | None | None | ||||||||
| report_num | 001 | 000 | 002 | 003 | 005 | 006 | 007 | 004 | ||||||||
| rpt_date | 2017-09-19 00:00:00 | 2017-06-14 00:00:00 | 2018-01-12 00:00:00 | 2018-10-15 00:00:00 | 2019-05-10 00:00:00 | 2019-09-04 00:00:00 | 2020-07-29 00:00:00 | 2019-03-12 00:00:00 | ||||||||
| qual_cb | X | None | X | X | X | X | X | X | ||||||||
| qualfy_dt | 2017-08-08 00:00:00 | None | 2017-08-08 00:00:00 | 2017-08-08 00:00:00 | 2017-08-08 00:00:00 | 2017-08-08 00:00:00 | 2017-08-08 00:00:00 | 2017-08-08 00:00:00 | ||||||||
| term_date | None | None | None | None | None | None | None | None | ||||||||
| city | Sacramento | Sacramento | Sacramento | Sacramento | Roseville | Roseville | Antelope | Sacramento | ||||||||
| st | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||
| zip4 | 95841 | 95841 | 95841 | 95841 | 95661 | 95661 | 95843 | 95841 | ||||||||
| phone | 916-348-9100 | 916-348-9100 | 916-348-9100 | 916-348-9100 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-348-9100 | ||||||||
| county_res | Sacramento | Sacramento | Sacramento | Sacramento | Placer | Placer | Placer | Sacramento | ||||||||
| county_act | None | None | None | None | None | None | None | None | ||||||||
| mail_city | None | None | None | None | None | None | None | None | ||||||||
| mail_st | None | None | None | None | None | None | None | None | ||||||||
| mail_zip4 | 95841 | 95841 | 95841 | 95841 | None | None | None | 95841 | ||||||||
| cmte_fax | 916-348-9111 | 916-348-9111 | 916-348-9111 | 916-348-9111 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-348-9111 | ||||||||
| cmte_email | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | ||||||||
| tres_naml | Copeland | Copeland | Copeland | Lewis | Johnson | Johnson | Johnson | Lewis | ||||||||
| tres_namf | Rita | Rita | Rita | Denise | Chelsea | Chelsea | Chelsea | Denise | ||||||||
| tres_namt | None | None | None | None | None | None | None | None | ||||||||
| tres_nams | None | None | None | None | None | None | None | None | ||||||||
| tres_city | Sacramento | Sacramento | Sacramento | Sacramento | Roseville | Roseville | Antelope | Sacramento | ||||||||
| tres_st | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||
| tres_zip4 | 95841 | 95841 | 95841 | 95841 | 95661 | 95661 | 95843 | 95841 | ||||||||
| tres_phon | 916-348-9100 | 916-348-9100 | 916-348-9100 | 916-348-9100 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-348-9100 | ||||||||
| actvty_lvl | ST | ST | ST | ST | ST | ST | ST | ST | ||||||||
| com82013yn | None | None | None | None | None | None | None | None | ||||||||
| com82013nm | None | None | None | None | None | None | None | None | ||||||||
| com82013id | None | None | None | None | None | None | None | None | ||||||||
| control_cb | None | None | None | None | None | None | None | None | ||||||||
| bank_nam | Community 1st Bank | Community 1st Bank | First Foundation Bank | First Foundation Bank | First Foundation Bank | First Foundation Bank | First Foundation Bank | First Foundation Bank | ||||||||
| bank_adr1 | 2250 Douglas Boulevard, Suite 190 | 2250 Douglas Boulevard, Suite 190 | 2250 Douglas Boulevard, Suite 190 | 2233 Douglas Boulevard, Suite 300 | 2233 Douglas Boulevard, Suite 300 | 2233 Douglas Boulevard, Suite 300 | 2233 Douglas Boulevard, Suite 300 | 2233 Douglas Boulevard, Suite 300 | ||||||||
| bank_adr2 | None | None | None | None | None | None | None | None | ||||||||
| bank_city | Roseville | Roseville | Roseville | Roseville | Roseville | Roseville | Roseville | Roseville | ||||||||
| bank_st | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||
| bank_zip4 | 95661 | 95661 | 95661 | 95661 | 95661 | 95661 | 95661 | 95661 | ||||||||
| bank_phon | 916-724-2424 | 916-724-2424 | 916-724-2424 | 916-724-2424 | 916-724-2424 | 916-724-2424 | 916-724-2424 | 916-724-2424 | ||||||||
| acct_opendt | None | None | None | None | None | None | None | None | ||||||||
| surplusdsp | None | None | None | None | None | None | None | None | ||||||||
| primfc_cb | None | None | None | None | None | None | None | None | ||||||||
| genpurp_cb | X | X | X | X | X | X | X | X | ||||||||
| gpc_descr | To support or oppose state and local candidates | To support or oppose state and local candidates | To support or oppose state and local candidates | To support or oppose state and local candidates | To support or oppose state and local candidates | To support or oppose state and local candidates | To support or oppose state and local candidates | To support or oppose state and local candidates | ||||||||
| sponsor_cb | None | None | None | None | None | None | None | None | ||||||||
| brdbase_cb | None | None | None | None | None | None | None | None | ||||||||
| smcont_qualdt | None | None | None | None | None | None | None | None |
| filer_id | 1397131 | 1397131 | 1397131 | |||
|---|---|---|---|---|---|---|
| adrid | 2480820 | 2436515 | 2503586 | |||
| effect_dt | 2019-05-24 00:00:00 | 2017-06-19 00:00:00 | 2020-07-31 00:00:00 | |||
| add_type | 7051 | 7051 | 7051 | |||
| session_id | 2019 | 2017 | 2019 |
| filer_id | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | 1397131 | ||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 2314162 | 2386841 | 2492093 | 2184727 | 2184727 | 2485364 | 2183913 | 2370480 | 2347249 | 2279747 | 2213874 | 2185162 | 2411275 | 2177436 | 2178736 | 2163795 | 2216908 | 2273992 | 2402893 | 2184727 | 2489400 | 2184727 | 2442393 | 2184727 | 2210915 | 2448135 | 2184727 | 2184727 | 2360109 | 2184727 | 2399265 | 2644166 | 2568341 | 2705970 | 2553589 | 2651958 | 2620091 | 2600950 | 2726591 | 2726591 | 2733918 | 2744668 | ||||||||||||||||||||||||||||||||||||||||||
| period_id | None | None | None | 238 | 243 | 241 | 231 | None | 235 | None | None | None | None | 229 | None | None | None | 233 | None | 231 | None | 237 | 239 | 233 | 231 | None | 230 | 236 | None | 239 | 237 | 247 | None | 249 | 243 | None | None | 245 | 251 | 251 | None | 251 | ||||||||||||||||||||||||||||||||||||||||||
| form_id | F410 | F410 | F460 | F410 | F410 | F460 | F497 | F410 | F460 | F460 | F410 | F410 | F410 | F460 | F460 | F410 | F460 | F460 | F460 | F410 | F410 | F410 | F460 | F410 | F460 | F460 | F410 | F410 | F460 | F410 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | ||||||||||||||||||||||||||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 5 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 4 | 0 | 2 | 0 | 0 | 0 | 3 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
| filing_date | 2018-10-23 00:00:00 | 2019-05-24 00:00:00 | 2020-07-31 00:00:00 | 2019-05-16 00:00:00 | 2020-07-31 00:00:00 | 2020-07-31 00:00:00 | 2017-09-12 00:00:00 | 2019-03-14 00:00:00 | 2019-01-31 00:00:00 | 2018-07-31 00:00:00 | 2018-02-01 00:00:00 | 2017-09-20 00:00:00 | 2019-09-27 00:00:00 | 2017-07-31 00:00:00 | 2017-07-31 00:00:00 | 2017-06-19 00:00:00 | 2018-01-31 00:00:00 | 2018-07-31 00:00:00 | 2019-07-31 00:00:00 | 2017-09-19 00:00:00 | 2020-07-31 00:00:00 | 2019-03-13 00:00:00 | 2020-01-31 00:00:00 | 2018-01-31 00:00:00 | 2018-01-31 00:00:00 | 2020-01-31 00:00:00 | 2017-09-19 00:00:00 | 2019-01-24 00:00:00 | 2019-01-31 00:00:00 | 2019-09-26 00:00:00 | 2019-07-31 00:00:00 | 2022-01-31 00:00:00 | 2021-02-01 00:00:00 | 2022-08-01 00:00:00 | 2021-02-01 00:00:00 | 2022-01-31 00:00:00 | 2021-08-02 00:00:00 | 2021-07-30 00:00:00 | 2022-09-29 00:00:00 | 2022-10-27 00:00:00 | 2022-08-02 00:00:00 | 2022-10-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||
| stmnt_type | 10006 | 10006 | 10005 | 10002 | 10002 | 10001 | 10001 | 10006 | 10001 | 10005 | 10006 | 10006 | 10006 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10002 | 10006 | 10002 | 10001 | 10002 | 10001 | 10005 | 10001 | 10002 | 10005 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10002 | 10005 | 10001 | ||||||||||||||||||||||||||||||||||||||||||
| stmnt_status | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||
| session_id | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2019 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2019 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||
| user_id | TRAMON | JFRONEFIELD | KRUSSELL | JFRONEFIELD | CAFILER | KRUSSELL | GKURIMOT | TRAMON | CSAGABAEN | SARRIAGA | RSAGARIO | TRAMON | TRAMON | LBARTHOL | LBARTHOL | CPON | CSAGABAEN | SARRIAGA | HCOURSEY | TRAMON | KWHELAN | TRAMON | LFEDOROV | RSAGARIO | CSAGABAEN | LFEDOROV | CAFILER | CAFILER | CSAGABAEN | TRAMON | HCOURSEY | KRUSSELL | AXIONG | CAFILER | AXIONG | KRUSSELL | DCODY | DCODY | CAFILER | CAFILER | RGEREMIA | 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 | ||||||||||||||||||||||||||||||||||||||||||
| fine_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 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 | ||||||||||||||||||||||||||||||||||||||||||
| rpt_start | None | None | 2020-01-01 00:00:00 | 2019-05-10 00:00:00 | 2020-07-29 00:00:00 | 2020-01-01 00:00:00 | 2017-09-12 00:00:00 | None | 2018-07-01 00:00:00 | 2018-01-01 00:00:00 | None | None | None | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | None | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-09-19 00:00:00 | None | 2019-03-12 00:00:00 | 2019-07-01 00:00:00 | 2018-01-12 00:00:00 | 2017-07-01 00:00:00 | 2019-07-01 00:00:00 | 2017-06-14 00:00:00 | 2018-10-15 00:00:00 | 2018-07-01 00:00:00 | 2019-09-04 00:00:00 | 2019-01-01 00:00:00 | 2021-07-01 00:00:00 | 2020-07-01 00:00:00 | 2022-01-01 00:00:00 | 2020-07-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-07-01 00:00:00 | 2022-07-01 00:00:00 | 2022-01-01 00:00:00 | 2022-09-25 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||
| rpt_end | None | None | 2020-06-30 00:00:00 | 2019-05-10 00:00:00 | 2020-07-29 00:00:00 | 2020-06-30 00:00:00 | 2017-09-12 00:00:00 | None | 2018-12-31 00:00:00 | 2018-06-30 00:00:00 | None | None | None | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | None | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 2019-06-30 00:00:00 | 2017-09-19 00:00:00 | None | 2019-03-12 00:00:00 | 2019-12-31 00:00:00 | 2018-01-12 00:00:00 | 2017-12-31 00:00:00 | 2019-12-31 00:00:00 | 2017-06-14 00:00:00 | 2018-10-15 00:00:00 | 2018-12-31 00:00:00 | 2019-09-04 00:00:00 | 2019-06-30 00:00:00 | 2021-12-31 00:00:00 | 2020-12-31 00:00:00 | 2022-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-06-30 00:00:00 | 2022-09-24 00:00:00 | 2022-09-24 00:00:00 | 2022-06-30 00:00:00 | 2022-10-22 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||
| rpt_date | None | None | None | None | None | 2020-07-29 00:00:00 | 2017-09-12 00:00:00 | None | 2019-01-31 00:00:00 | None | None | None | None | 2017-07-28 00:00:00 | None | None | None | 2018-07-31 00:00:00 | None | None | None | None | 2020-01-29 00:00:00 | None | 2018-01-30 00:00:00 | None | None | None | None | None | 2019-07-30 00:00:00 | 2022-01-31 00:00:00 | None | 2022-08-01 00:00:00 | 2021-01-26 00:00:00 | None | None | 2021-07-26 00:00:00 | 2022-09-29 00:00:00 | 2022-10-27 00:00:00 | None | 2022-10-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||
| filing_type | None | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | None | None | None | 22001 | None | None | None | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | 22001 |
| filer_id | 1397131 | 1397131 | ||
|---|---|---|---|---|
| filer_type | 16 | 16 | ||
| active | Y | Y | ||
| race | 0 | 0 | ||
| session_id | 2017 | 2017 | ||
| category | 0 | 0 | ||
| category_type | 40502 | 40502 | ||
| sub_category | 40103 | 40103 | ||
| effect_dt | 2017-09-20 00:00:00 | 2017-06-19 00:00:00 | ||
| sub_category_type | 0 | 0 | ||
| election_type | 0 | 0 | ||
| sub_category_a | None | None | ||
| nyq_dt | 2017-08-08 00:00:00 | None | ||
| party_cd | 0 | 0 | ||
| county_cd | 18004 | 18004 | ||
| district_cd | 0 | 0 |
| filer_id | 1397131 | |
|---|---|---|
| xref_id | 1397131 | |
| effect_dt | 2017-06-21 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1397131 | 1397131 | 1397131 | |||
|---|---|---|---|---|---|---|
| filer_id | 1397131 | 1397131 | 1397131 | |||
| filer_type | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | |||
| status | ACTIVE | ACTIVE | ACTIVE | |||
| effect_dt | 2017-09-20 00:00:00 | 2017-09-20 00:00:00 | 2017-09-20 00:00:00 | |||
| naml | SIERRA FORWARD | SIERRA FORWARD | SIERRA FORWARD | |||
| namf | None | None | None | |||
| namt | None | None | None | |||
| nams | None | None | None | |||
| adr1 | None | None | None | |||
| adr2 | None | None | None | |||
| city | SACRAMENTO | ROSEVILLE | ANTELOPE | |||
| st | CA | CA | CA | |||
| zip4 | 95841 | 95661 | 95843 | |||
| phon | 9163489100 | 9167493533 | 9167493533 | |||
| fax | 9163489111 | 9168654657 | 9168654657 | |||
| [email protected] | [email protected] | [email protected] |
| filer_id | 1397131 |
|---|
| filer_id | 1397131 | |
|---|---|---|
| filing_file_name | 346206.cal | |
| received_date | 2019-01-24 00:00:00 | |
| filing_directory | /cafiler/disclose/ca99/temp | |
| filing_id | None | |
| form_id | None | |
| receive_comment | Filing passed validation, but failed DB constraints |