| filing_id | 1981150 | 1963877 | 1998106 | 2064822 | 2064822 | 2038177 | 2012567 | 2012567 | 2101790 | 2175761 | 2157776 | 2129676 | 2193814 | 2208029 | 2269368 | 2241170 | 2396096 | 2348181 | 2318513 | 2380055 | 2441877 | 2419122 | 2471569 | 2529778 | 2487762 | 2555340 | 2601842 | 2579797 | 2555340 | 2623695 | 2677802 | 2708710 | 2643594 | 2677802 | 2748856 | |||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 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 | 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 | F625 | F625 | F625 | F625 | |||||||||||||||||||||||||||||||||||
| sender_id | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | |||||||||||||||||||||||||||||||||||
| filer_id | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | |||||||||||||||||||||||||||||||||||
| 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 | FRM | FRM | FRM | FRM | |||||||||||||||||||||||||||||||||||
| filer_naml | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | |||||||||||||||||||||||||||||||||||
| 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 | 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 | 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 | None | None | None | None | |||||||||||||||||||||||||||||||||||
| report_num | 000 | 000 | 000 | 000 | 001 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 001 | 000 | 000 | 000 | 000 | |||||||||||||||||||||||||||||||||||
| rpt_date | 2015-07-28 00:00:00 | 2015-04-27 00:00:00 | 2015-11-02 00:00:00 | 2016-08-01 00:00:00 | 2016-10-18 00:00:00 | 2016-05-02 00:00:00 | 2016-04-29 00:00:00 | 2016-02-01 00:00:00 | 2016-10-21 00:00:00 | 2017-07-20 00:00:00 | 2017-04-28 00:00:00 | 2017-01-31 00:00:00 | 2017-10-30 00:00:00 | 2018-01-29 00:00:00 | 2018-07-23 00:00:00 | 2018-04-21 00:00:00 | 2019-07-25 00:00:00 | 2019-01-29 00:00:00 | 2018-10-29 00:00:00 | 2019-04-23 00:00:00 | 2020-01-31 00:00:00 | 2019-10-23 00:00:00 | 2020-04-27 00:00:00 | 2020-11-01 00:00:00 | 2020-07-25 00:00:00 | 2021-01-31 00:00:00 | 2021-07-26 00:00:00 | 2021-04-26 00:00:00 | 2021-05-20 00:00:00 | 2021-10-28 00:00:00 | 2022-04-30 00:00:00 | 2022-07-31 00:00:00 | 2022-01-31 00:00:00 | 2022-04-30 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||
| from_date | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-07-01 00:00:00 | 2016-04-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-04-01 00:00:00 | 2017-01-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 | 2019-04-01 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2020-10-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2020-10-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-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 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2015-09-30 00:00:00 | 2016-06-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-06-30 00:00:00 | 2017-03-31 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 | 2019-06-30 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2019-12-31 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2020-12-31 00:00:00 | 2021-09-30 00:00:00 | 2022-03-31 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 | 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 | 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 | 2019-01-01 00:00:00 | 2017-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 | 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 | |||||||||||||||||||||||||||||||||||
| firm_id | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | F24851 | F24851 | F24851 | F24851 | F24851 | |||||||||||||||||||||||||||||||||||
| firm_name | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | |||||||||||||||||||||||||||||||||||
| firm_city | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | |||||||||||||||||||||||||||||||||||
| firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||||||||||||
| firm_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||||||||||||||||||||||||||||
| firm_phon | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | (916) 661-5365 | (916) 661-5365 | (916) 661-5365 | (916) 661-5365 | (916) 661-5365 | |||||||||||||||||||||||||||||||||||
| 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 | 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 | 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 | 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 | None | None | None | None | |||||||||||||||||||||||||||||||||||
| sig_date | 2015-07-28 00:00:00 | 2015-04-27 00:00:00 | 2015-11-02 00:00:00 | 2016-08-01 00:00:00 | 2016-10-18 00:00:00 | 2016-05-02 00:00:00 | 2016-04-29 00:00:00 | 2016-02-01 00:00:00 | 2016-10-21 00:00:00 | 2017-07-20 00:00:00 | 2017-04-27 00:00:00 | 2017-01-30 00:00:00 | 2017-10-30 00:00:00 | 2018-01-17 00:00:00 | 2018-07-23 00:00:00 | 2018-04-21 00:00:00 | 2019-07-25 00:00:00 | 2019-01-29 00:00:00 | 2018-10-29 00:00:00 | 2019-04-23 00:00:00 | 2020-01-29 00:00:00 | 2019-10-23 00:00:00 | 2020-04-27 00:00:00 | 2020-11-01 00:00:00 | 2020-07-25 00:00:00 | 2021-01-31 00:00:00 | 2021-07-25 00:00:00 | 2021-04-26 00:00:00 | 2021-05-20 00:00:00 | 2021-10-28 00:00:00 | 2022-06-24 00:00:00 | 2022-07-30 00:00:00 | 2022-01-20 00:00:00 | 2022-04-24 00:00:00 | 2022-10-17 00:00:00 | |||||||||||||||||||||||||||||||||||
| sig_loc | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | |||||||||||||||||||||||||||||||||||
| sig_naml | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Niemela | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Pappas | |||||||||||||||||||||||||||||||||||
| sig_namf | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Erin | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Emily | |||||||||||||||||||||||||||||||||||
| 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 | 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 | None | None | None | None | |||||||||||||||||||||||||||||||||||
| prn_naml | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Niemela | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Pappas | |||||||||||||||||||||||||||||||||||
| prn_namf | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Erin | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Emily | |||||||||||||||||||||||||||||||||||
| 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 | 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 | None | None | None | None | |||||||||||||||||||||||||||||||||||
| sig_title | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | |||||||||||||||||||||||||||||||||||
| 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | None | None | None | None |
| filing_id | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 2116927 | 1920568 | 2130797 | 2130797 | 2130797 | 2130797 | 2130797 | 2130797 | 2130797 | 2130797 | 2130797 | 2198604 | 2130797 | 2130797 | 2130797 | 2130797 | 2130797 | 2130797 | 2130797 | 2130797 | 2130797 | 2130797 | 2130797 | 2333767 | 2130797 | 2333767 | 2333767 | 2333767 | 2333767 | 2333767 | 2333767 | 2333767 | 2333767 | 2333767 | 2333767 | 2333767 | 2333767 | 2333767 | 2333767 | 2333767 | 2541534 | 2541534 | 2541534 | 2541534 | 2541534 | 2541534 | 2541534 | 2541534 | 2541534 | 2541534 | 2541534 | 2541534 | 2541534 | 2541534 | 2541534 | 2541534 | 2541534 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 1 | 2 | 16 | 15 | 19 | 18 | 20 | 13 | 12 | 17 | 14 | 22 | 32 | 24 | 27 | 25 | 33 | 37 | 26 | 38 | 21 | 28 | 29 | 30 | 31 | 23 | 41 | 34 | 35 | 36 | 40 | 42 | 43 | 44 | 39 | 45 | 0 | 46 | 0 | 2 | 1 | 5 | 6 | 4 | 3 | 7 | 9 | 0 | 10 | 8 | 18 | 11 | 13 | 14 | 15 | 17 | 16 | 12 | 19 | 0 | 20 | 7 | 2 | 8 | 9 | 6 | 1 | 4 | 3 | 5 | 14 | 10 | 15 | 12 | 11 | 13 | 0 | 2 | 1 | 4 | 8 | 3 | 11 | 12 | 10 | 13 | 9 | 7 | 5 | 6 | 14 | 15 | 16 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | 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 | 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 | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| form_type | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F602 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| sender_id | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1398918 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filer_id | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | 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 | None | 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 | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filer_naml | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | NIEMELA, PAPPAS AND ASSOCIATES | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 003 | 004 | 005 | 006 | 007 | 008 | 009 | 010 | 011 | 001 | 002 | 016 | 015 | 019 | 018 | 020 | 013 | 012 | 017 | 014 | 022 | 032 | 024 | 027 | 025 | 033 | 037 | 026 | 038 | 021 | 028 | 029 | 030 | 031 | 023 | 041 | 034 | 035 | 036 | 040 | 042 | 043 | 044 | 039 | 045 | 000 | 046 | 000 | 002 | 001 | 005 | 006 | 004 | 003 | 007 | 009 | 000 | 010 | 008 | 018 | 011 | 013 | 014 | 015 | 017 | 016 | 012 | 019 | 000 | 020 | 007 | 002 | 008 | 009 | 006 | 001 | 004 | 003 | 005 | 014 | 010 | 015 | 012 | 011 | 013 | 000 | 002 | 001 | 004 | 008 | 003 | 011 | 012 | 010 | 013 | 009 | 007 | 005 | 006 | 014 | 015 | 016 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_date | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-05 00:00:00 | 2015-01-22 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-02-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-04-03 00:00:00 | 2015-06-04 00:00:00 | 2015-01-01 00:00:00 | 2015-06-16 00:00:00 | 2015-03-13 00:00:00 | 2015-02-20 00:00:00 | 2016-05-06 00:00:00 | 2015-04-01 00:00:00 | 2015-07-31 00:00:00 | 2015-11-04 00:00:00 | 2015-08-01 00:00:00 | 2015-09-14 00:00:00 | 2015-08-01 00:00:00 | 2015-12-31 00:00:00 | 2015-12-31 00:00:00 | 2015-07-20 00:00:00 | 2016-02-01 00:00:00 | 2015-06-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-07-01 00:00:00 | 2015-11-03 00:00:00 | 2015-07-31 00:00:00 | 2016-07-21 00:00:00 | 2015-03-23 00:00:00 | 2015-11-04 00:00:00 | 2016-01-07 00:00:00 | 2016-04-29 00:00:00 | 2016-04-01 00:00:00 | 2016-07-20 00:00:00 | 2016-10-01 00:00:00 | 2016-03-21 00:00:00 | 2016-10-15 00:00:00 | 2018-12-31 00:00:00 | 2016-09-30 00:00:00 | 2018-12-31 00:00:00 | 2017-01-01 00:00:00 | 2017-02-08 00:00:00 | 2017-04-26 00:00:00 | 2017-04-01 00:00:00 | 2017-03-20 00:00:00 | 2017-03-17 00:00:00 | 2017-07-02 00:00:00 | 2017-08-10 00:00:00 | 2017-12-13 00:00:00 | 2017-10-20 00:00:00 | 2017-06-30 00:00:00 | 2018-09-30 00:00:00 | 2018-01-01 00:00:00 | 2018-03-13 00:00:00 | 2018-03-27 00:00:00 | 2018-04-21 00:00:00 | 2018-06-08 00:00:00 | 2018-05-11 00:00:00 | 2018-02-09 00:00:00 | 2018-11-21 00:00:00 | 2020-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-10-15 00:00:00 | 2019-04-01 00:00:00 | 2019-12-10 00:00:00 | 2019-12-31 00:00:00 | 2019-09-01 00:00:00 | 2019-01-31 00:00:00 | 2019-04-01 00:00:00 | 2019-06-03 00:00:00 | 2019-07-01 00:00:00 | 2020-08-24 00:00:00 | 2020-02-25 00:00:00 | 2020-09-21 00:00:00 | 2020-03-11 00:00:00 | 2020-02-28 00:00:00 | 2020-07-14 00:00:00 | 2022-12-31 00:00:00 | 2021-04-06 00:00:00 | 2021-03-01 00:00:00 | 2021-08-26 00:00:00 | 2022-01-10 00:00:00 | 2021-07-31 00:00:00 | 2022-05-20 00:00:00 | 2022-04-12 00:00:00 | 2022-03-13 00:00:00 | 2022-06-29 00:00:00 | 2022-01-25 00:00:00 | 2021-12-03 00:00:00 | 2021-11-18 00:00:00 | 2021-11-08 00:00:00 | 2022-08-03 00:00:00 | 2022-09-07 00:00:00 | 2022-10-05 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ls_beg_yr | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ls_end_yr | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2018 | 2016 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2020 | 2018 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| qual_date | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 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 | 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 | 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 | 2019-01-01 00:00:00 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| eff_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 | 2017-12-01 00:00:00 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_city | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | SACRAMENTO | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | 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 | 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 | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| bus_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| bus_phon | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | (916) 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | 916 661-5365 | (916) 661-5365 | 916 661-5365 | (916) 661-5365 | (916) 661-5365 | (916) 661-5365 | (916) 661-5365 | (916) 661-5365 | (916) 661-5365 | 916 661-5365 | (916) 661-5365 | (916) 661-5365 | (916) 661-5365 | (916) 661-5365 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 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] | [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] | [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] | [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] | [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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 2014-12-22 00:00:00 | 2015-01-21 00:00:00 | 2015-01-21 00:00:00 | 2015-01-22 00:00:00 | 2015-01-28 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-01-21 00:00:00 | 2015-01-21 00:00:00 | 2015-05-08 00:00:00 | 2015-04-18 00:00:00 | 2015-06-04 00:00:00 | 2015-05-26 00:00:00 | 2015-06-17 00:00:00 | 2015-03-16 00:00:00 | 2015-02-20 00:00:00 | 2015-05-21 00:00:00 | 2015-04-01 00:00:00 | 2015-07-31 00:00:00 | 2015-11-17 00:00:00 | 2015-08-19 00:00:00 | 2015-09-29 00:00:00 | 2015-08-24 00:00:00 | 2015-12-16 00:00:00 | 2016-02-01 00:00:00 | 2015-08-24 00:00:00 | 2016-02-04 00:00:00 | 2015-07-22 00:00:00 | 2015-11-03 00:00:00 | 2015-11-06 00:00:00 | 2015-11-06 00:00:00 | 2015-11-06 00:00:00 | 2015-08-03 00:00:00 | 2016-08-02 00:00:00 | 2016-01-08 00:00:00 | 2016-01-15 00:00:00 | 2016-01-20 00:00:00 | 2016-04-29 00:00:00 | 2016-07-29 00:00:00 | 2016-07-26 00:00:00 | 2016-10-21 00:00:00 | 2016-03-21 00:00:00 | 2016-10-18 00:00:00 | 2016-12-28 00:00:00 | 2017-01-23 00:00:00 | 2017-01-23 00:00:00 | 2017-02-23 00:00:00 | 2017-02-08 00:00:00 | 2017-04-26 00:00:00 | 2017-06-07 00:00:00 | 2017-03-23 00:00:00 | 2017-03-17 00:00:00 | 2017-07-13 00:00:00 | 2017-08-10 00:00:00 | 2017-12-13 00:00:00 | 2017-10-27 00:00:00 | 2017-07-24 00:00:00 | 2018-10-16 00:00:00 | 2018-01-16 00:00:00 | 2018-03-09 00:00:00 | 2018-03-27 00:00:00 | 2018-04-19 00:00:00 | 2018-05-24 00:00:00 | 2018-05-15 00:00:00 | 2018-02-09 00:00:00 | 2018-11-27 00:00:00 | 2018-12-05 00:00:00 | 2019-02-16 00:00:00 | 2019-10-17 00:00:00 | 2019-04-01 00:00:00 | 2019-12-12 00:00:00 | 2019-12-12 00:00:00 | 2019-08-23 00:00:00 | 2019-01-26 00:00:00 | 2019-04-01 00:00:00 | 2019-05-15 00:00:00 | 2019-07-25 00:00:00 | 2020-08-24 00:00:00 | 2020-01-17 00:00:00 | 2020-09-17 00:00:00 | 2020-03-24 00:00:00 | 2020-01-29 00:00:00 | 2020-07-14 00:00:00 | 2020-12-31 00:00:00 | 2021-04-06 00:00:00 | 2021-03-01 00:00:00 | 2021-08-26 00:00:00 | 2022-01-10 00:00:00 | 2021-07-31 00:00:00 | 2022-05-20 00:00:00 | 2022-04-12 00:00:00 | 2022-03-13 00:00:00 | 2022-06-29 00:00:00 | 2022-01-25 00:00:00 | 2021-12-03 00:00:00 | 2021-11-18 00:00:00 | 2021-11-05 00:00:00 | 2022-08-03 00:00:00 | 2022-09-07 00:00:00 | 2022-10-05 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| sig_loc | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | SACRAMENTO, CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento, CA | Sacramento CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| sig_naml | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | PAPPAS | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Niemela | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Niemela | Pappas | Pappas | Pappas | Niemela | Pappas | Pappas | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Pappas | Pappas | Pappas | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| sig_namf | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | EMILY | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Erin | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Erin | Emily | Emily | Emily | Erin | Emily | Emily | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Emily | Emily | Emily | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | PAPPAS | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Niemela | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Pappas | Niemela | Pappas | Pappas | Pappas | Niemela | Pappas | Pappas | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Niemela | Pappas | Pappas | Pappas | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| prn_namf | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | EMILY | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Erin | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Emily | Erin | Emily | Emily | Emily | Erin | Emily | Emily | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Erin | Emily | Emily | Emily | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | PARTNER | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Managing Partner | Partner | Managing Partner | Partner | Partner | Managing Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | Partner | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmt_firm | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | None | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | Niemela, Pappas and Associates | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | NIEMELA, PAPPAS AND ASSOCIATES | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | SACRAMENTO | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | CA | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 95814 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | GOVERNMENT RELATIONS | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | GOVERNMENT RELATIONS | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | KIDANE & ASSOCIATES | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | SACRAMENTO | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | CA | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 95814 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| adrid | 2412611 | 2504444 | 2547339 | 2336559 | 2467494 | |||||
| effect_dt | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | |||||
| add_type | 7051 | 7051 | 7051 | 7051 | 7051 | |||||
| session_id | 2017 | 2021 | 2023 | 2015 | 2019 |
| filer_id | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 1920568 | 1959702 | 1959712 | 1959717 | 1959721 | 1959726 | 1959730 | 1959748 | 1959752 | 1959756 | 1959760 | 1920568 | 1920568 | 1970444 | 1920568 | 1979747 | 1981150 | 1920568 | 1963877 | 1966937 | 1971681 | 1971683 | 1971685 | 1920568 | 1972783 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1951112 | 1959738 | 1959740 | 1959744 | 1920568 | 1920568 | 1951232 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1990866 | 1920568 | 1920568 | 1983307 | 2000653 | 2000655 | 1920568 | 1920568 | 1998106 | 1920568 | 1920568 | 1920568 | 1987578 | 1990859 | 1990871 | 1990878 | 1920568 | 1920568 | 2000657 | 2000659 | 2000661 | 1920568 | 2333767 | 2333767 | 2333767 | 2228612 | 2198604 | 2341464 | 2428973 | 2130797 | 2487762 | 2193814 | 2260323 | 2404534 | 2426479 | 2500576 | 2333767 | 2241170 | 2198572 | 2408206 | 2333767 | 2130797 | 2196519 | 2396096 | 2333767 | 2209119 | 1920568 | 1920568 | 2012567 | 1920568 | 1920568 | 1920568 | 2026159 | 1920568 | 1920568 | 2014781 | 1920568 | 1920568 | 1920568 | 2016977 | 2023794 | 2023806 | 2014790 | 2014792 | 1920568 | 2012567 | 2038177 | 1920568 | 1920568 | 2065402 | 2064822 | 2073550 | 1920568 | 2069861 | 1920568 | 2103698 | 2064822 | 2101790 | 2102931 | 2102932 | 1920568 | 2102988 | 2109749 | 2129676 | 2146685 | 2130797 | 2130797 | 2150592 | 2152520 | 2130797 | 2142558 | 2130797 | 1920568 | 2137748 | 2138364 | 2130797 | 2116927 | 2175761 | 2177538 | 2130797 | 2157776 | 2137814 | 2159482 | 2130797 | 2164243 | 2168382 | 2318513 | 2130797 | 2248385 | 2348181 | 2130797 | 2162487 | 2225494 | 2329051 | 2130797 | 2411742 | 2214522 | 2333767 | 2333767 | 2471569 | 2248529 | 2130797 | 2333767 | 2130797 | 2333767 | 2460375 | 2130797 | 2489316 | 2130797 | 2208029 | 2405340 | 2130797 | 2333767 | 2529778 | 2316229 | 2380055 | 2419122 | 2333767 | 2180770 | 2404505 | 2541534 | 2333767 | 2333767 | 2420680 | 2555340 | 2372607 | 2372609 | 2130797 | 2465206 | 2333767 | 2513087 | 2130797 | 2130797 | 2215733 | 2435393 | 2130797 | 2441877 | 2333767 | 2269368 | 2661229 | 2665578 | 2601842 | 2541534 | 2541534 | 2567353 | 2605321 | 2541534 | 2696587 | 2677802 | 2541534 | 2579797 | 2541534 | 2541534 | 2541534 | 2541534 | 2708710 | 2541534 | 2647151 | 2618826 | 2709059 | 2620900 | 2643594 | 2638120 | 2541534 | 2541534 | 2555340 | 2541534 | 2695744 | 2612190 | 2541534 | 2712822 | 2596432 | 2541534 | 2541534 | 2623695 | 2677802 | 2632952 | 2734793 | 2748856 | 2541534 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| period_id | 222 | None | None | None | None | None | None | None | None | None | None | 223 | 221 | None | 222 | None | 222 | 221 | 221 | None | None | None | None | 226 | None | 222 | 221 | 221 | 221 | 221 | 221 | None | None | None | None | 221 | 221 | None | 221 | 221 | 221 | 221 | 221 | 221 | None | 222 | 223 | None | None | None | 221 | 224 | 223 | 223 | 222 | 223 | None | None | None | None | 223 | 224 | None | None | None | 223 | 238 | 240 | 238 | None | 232 | None | None | 233 | 242 | 231 | None | None | None | None | 238 | 233 | None | None | 240 | 232 | None | 238 | 241 | None | 224 | 225 | 224 | 224 | 223 | 224 | None | 225 | 225 | None | 224 | 221 | 224 | None | None | None | None | None | 226 | 224 | 225 | 226 | 227 | None | 226 | None | 227 | None | 228 | None | 226 | 227 | None | None | 228 | None | None | 228 | None | 229 | 236 | None | None | 229 | None | 229 | 227 | None | None | 229 | 236 | 230 | None | 230 | 229 | None | None | 230 | None | None | 235 | 231 | None | 236 | 231 | None | None | None | 230 | None | None | 243 | 237 | 241 | None | 235 | 241 | 234 | 243 | None | 234 | None | 234 | 232 | None | 236 | 243 | 243 | None | 237 | 239 | 244 | None | None | 252 | 241 | 240 | None | 244 | None | None | 233 | None | 239 | None | 233 | 233 | None | None | 236 | 240 | 239 | 234 | None | None | 246 | 249 | 245 | None | None | 249 | None | 249 | 246 | 245 | 247 | 250 | 248 | 250 | 250 | 247 | None | None | None | None | 248 | None | 249 | 250 | 244 | 251 | None | None | 251 | None | None | 248 | 248 | 247 | 249 | None | None | 251 | 252 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F601 | F605 | F605 | F605 | F605 | F605 | F605 | F605 | F605 | F605 | F605 | F601 | F601 | F605 | F601 | F605 | F625 | F601 | F625 | F605 | F605 | F605 | F605 | F601 | F605 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F605 | F605 | F605 | F601 | F601 | F605 | F601 | F601 | F601 | F601 | F601 | F601 | F605 | F601 | F601 | F605 | F605 | F605 | F601 | F601 | F625 | F601 | F601 | F601 | F605 | F605 | F605 | F605 | F601 | F601 | F605 | F605 | F605 | F601 | F601 | F601 | F601 | F605 | F602 | F601 | F605 | F601 | F625 | F625 | F605 | F605 | F605 | F605 | F601 | F625 | F602 | F605 | F601 | F601 | F605 | F625 | F601 | F602 | F601 | F601 | F625 | F601 | F601 | F601 | F605 | F601 | F601 | F605 | F601 | F601 | F601 | F605 | F605 | F605 | F605 | F605 | F601 | F625 | F625 | F601 | F601 | F605 | F625 | F605 | F601 | F605 | F601 | F605 | F625 | F625 | F605 | F605 | F601 | F605 | F605 | F625 | F605 | F601 | F601 | F605 | F605 | F601 | F605 | F601 | F601 | F605 | F605 | F601 | F601 | F625 | F605 | F601 | F625 | F601 | F605 | F601 | F605 | F605 | F625 | F601 | F605 | F625 | F601 | F888 | F605 | F605 | F601 | F605 | F605 | F601 | F601 | F625 | F605 | F601 | F601 | F601 | F601 | F605 | F601 | F605 | F601 | F625 | F605 | F601 | F601 | F625 | F605 | F625 | F625 | F601 | F605 | F605 | F601 | F601 | F601 | F605 | F625 | F605 | F605 | F601 | F605 | F601 | F605 | F601 | F601 | F605 | F605 | F601 | F625 | F601 | F625 | F605 | F605 | F625 | F601 | F601 | F601 | F605 | F601 | F605 | F625 | F601 | F625 | F601 | F601 | F601 | F601 | F625 | F601 | F605 | F605 | F605 | F605 | F625 | F605 | F601 | F601 | F625 | F601 | F605 | F605 | F601 | F605 | F605 | F601 | F601 | F625 | F625 | F605 | F605 | F625 | F601 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_sequence | 21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 18 | 0 | 20 | 0 | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 17 | 0 | 14 | 7 | 8 | 9 | 10 | 11 | 0 | 0 | 0 | 0 | 12 | 13 | 0 | 5 | 2 | 3 | 4 | 6 | 0 | 0 | 19 | 23 | 0 | 0 | 0 | 1 | 32 | 0 | 26 | 15 | 24 | 0 | 0 | 0 | 0 | 27 | 33 | 0 | 0 | 0 | 25 | 2 | 9 | 3 | 0 | 0 | 0 | 0 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 8 | 10 | 0 | 0 | 10 | 0 | 37 | 38 | 0 | 29 | 30 | 31 | 0 | 39 | 36 | 0 | 28 | 34 | 35 | 0 | 0 | 0 | 0 | 0 | 40 | 1 | 0 | 42 | 41 | 0 | 0 | 0 | 43 | 0 | 44 | 0 | 1 | 0 | 0 | 0 | 45 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 1 | 0 | 4 | 46 | 0 | 0 | 2 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 9 | 0 | 0 | 7 | 0 | 0 | 0 | 6 | 0 | 0 | 14 | 1 | 0 | 0 | 18 | 11 | 17 | 13 | 0 | 15 | 0 | 16 | 0 | 0 | 20 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 7 | 0 | 0 | 0 | 0 | 12 | 0 | 5 | 0 | 14 | 11 | 0 | 0 | 19 | 0 | 6 | 0 | 0 | 0 | 0 | 10 | 1 | 0 | 0 | 9 | 0 | 0 | 2 | 0 | 4 | 12 | 7 | 11 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 13 | 1 | 15 | 0 | 0 | 14 | 0 | 0 | 5 | 6 | 0 | 1 | 0 | 0 | 0 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_date | 2015-07-27 00:00:00 | 2015-01-27 00:00:00 | 2015-01-21 00:00:00 | 2015-01-21 00:00:00 | 2015-01-21 00:00:00 | 2015-01-21 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-27 00:00:00 | 2015-03-27 00:00:00 | 2015-04-06 00:00:00 | 2015-07-31 00:00:00 | 2015-05-26 00:00:00 | 2015-06-05 00:00:00 | 2015-06-23 00:00:00 | 2015-07-27 00:00:00 | 2015-07-30 00:00:00 | 2015-05-12 00:00:00 | 2015-04-29 00:00:00 | 2015-04-30 00:00:00 | 2015-05-12 00:00:00 | 2015-05-21 00:00:00 | 2015-05-26 00:00:00 | 2015-05-21 00:00:00 | 2015-06-23 00:00:00 | 2015-04-06 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2014-12-23 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-27 00:00:00 | 2015-03-27 00:00:00 | 2015-01-16 00:00:00 | 2015-01-22 00:00:00 | 2015-01-21 00:00:00 | 2015-01-21 00:00:00 | 2015-01-21 00:00:00 | 2015-01-28 00:00:00 | 2014-12-23 00:00:00 | 2015-08-24 00:00:00 | 2015-06-05 00:00:00 | 2015-08-10 00:00:00 | 2015-07-31 00:00:00 | 2015-11-06 00:00:00 | 2015-11-06 00:00:00 | 2015-01-21 00:00:00 | 2015-11-18 00:00:00 | 2015-11-02 00:00:00 | 2015-08-24 00:00:00 | 2015-04-30 00:00:00 | 2015-08-24 00:00:00 | 2015-08-10 00:00:00 | 2015-08-24 00:00:00 | 2015-08-24 00:00:00 | 2015-09-29 00:00:00 | 2015-09-29 00:00:00 | 2016-01-05 00:00:00 | 2015-11-06 00:00:00 | 2015-11-06 00:00:00 | 2015-11-18 00:00:00 | 2015-08-24 00:00:00 | 2019-06-03 00:00:00 | 2020-01-10 00:00:00 | 2019-06-03 00:00:00 | 2018-04-04 00:00:00 | 2017-12-18 00:00:00 | 2019-01-11 00:00:00 | 2020-01-03 00:00:00 | 2018-03-26 00:00:00 | 2020-07-31 00:00:00 | 2017-10-31 00:00:00 | 2018-06-06 00:00:00 | 2019-05-24 00:00:00 | 2019-12-19 00:00:00 | 2020-09-03 00:00:00 | 2019-07-23 00:00:00 | 2018-04-30 00:00:00 | 2017-12-15 00:00:00 | 2019-08-13 00:00:00 | 2019-12-19 00:00:00 | 2017-11-20 00:00:00 | 2017-11-17 00:00:00 | 2019-07-30 00:00:00 | 2020-03-12 00:00:00 | 2018-01-29 00:00:00 | 2016-02-01 00:00:00 | 2016-02-11 00:00:00 | 2016-02-01 00:00:00 | 2015-11-06 00:00:00 | 2015-11-06 00:00:00 | 2015-11-06 00:00:00 | 2016-03-28 00:00:00 | 2016-03-28 00:00:00 | 2016-01-20 00:00:00 | 2016-01-20 00:00:00 | 2015-11-06 00:00:00 | 2016-01-15 00:00:00 | 2016-01-15 00:00:00 | 2016-02-11 00:00:00 | 2016-01-04 00:00:00 | 2016-02-01 00:00:00 | 2016-01-15 00:00:00 | 2016-01-15 00:00:00 | 2016-05-02 00:00:00 | 2016-05-02 00:00:00 | 2016-05-02 00:00:00 | 2016-08-09 00:00:00 | 2016-08-02 00:00:00 | 2016-08-02 00:00:00 | 2016-08-01 00:00:00 | 2016-08-25 00:00:00 | 2016-08-29 00:00:00 | 2016-08-09 00:00:00 | 2016-10-31 00:00:00 | 2016-11-01 00:00:00 | 2016-10-31 00:00:00 | 2016-10-31 00:00:00 | 2016-10-31 00:00:00 | 2016-10-31 00:00:00 | 2016-11-03 00:00:00 | 2016-10-31 00:00:00 | 2016-12-05 00:00:00 | 2017-01-31 00:00:00 | 2017-02-16 00:00:00 | 2017-03-21 00:00:00 | 2017-01-31 00:00:00 | 2017-03-21 00:00:00 | 2017-04-03 00:00:00 | 2017-02-16 00:00:00 | 2017-02-24 00:00:00 | 2017-04-04 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2017-02-24 00:00:00 | 2017-01-03 00:00:00 | 2017-07-31 00:00:00 | 2017-07-31 00:00:00 | 2017-07-31 00:00:00 | 2017-05-01 00:00:00 | 2017-01-03 00:00:00 | 2017-05-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-20 00:00:00 | 2017-07-14 00:00:00 | 2018-10-31 00:00:00 | 2017-08-15 00:00:00 | 2018-05-10 00:00:00 | 2019-01-31 00:00:00 | 2017-07-14 00:00:00 | 2017-06-07 00:00:00 | 2018-03-26 00:00:00 | 2018-12-14 00:00:00 | 2017-06-20 00:00:00 | 2019-09-27 00:00:00 | 2018-02-12 00:00:00 | 2020-09-03 00:00:00 | 2019-04-16 00:00:00 | 2020-04-30 00:00:00 | 2018-05-10 00:00:00 | 2018-10-23 00:00:00 | 2020-03-12 00:00:00 | 2018-06-08 00:00:00 | 2020-07-28 00:00:00 | 2020-02-28 00:00:00 | 2018-05-10 00:00:00 | 2020-07-28 00:00:00 | 2018-05-15 00:00:00 | 2018-01-29 00:00:00 | 2019-05-24 00:00:00 | 2019-03-20 00:00:00 | 2020-09-28 00:00:00 | 2020-11-01 00:00:00 | 2018-10-23 00:00:00 | 2019-04-30 00:00:00 | 2019-10-31 00:00:00 | 2019-01-10 00:00:00 | 2017-08-15 00:00:00 | 2019-05-24 00:00:00 | 2020-12-31 00:00:00 | 2020-03-26 00:00:00 | 2019-11-01 00:00:00 | 2019-11-01 00:00:00 | 2021-02-02 00:00:00 | 2019-02-12 00:00:00 | 2019-03-11 00:00:00 | 2018-02-15 00:00:00 | 2020-04-07 00:00:00 | 2019-08-14 00:00:00 | 2020-09-28 00:00:00 | 2018-04-05 00:00:00 | 2018-02-09 00:00:00 | 2018-02-14 00:00:00 | 2020-01-21 00:00:00 | 2018-12-17 00:00:00 | 2020-01-31 00:00:00 | 2019-10-07 00:00:00 | 2018-07-25 00:00:00 | 2022-03-15 00:00:00 | 2022-04-04 00:00:00 | 2021-07-31 00:00:00 | 2022-04-04 00:00:00 | 2021-03-09 00:00:00 | 2020-12-31 00:00:00 | 2021-03-09 00:00:00 | 2022-03-15 00:00:00 | 2022-06-27 00:00:00 | 2022-05-02 00:00:00 | 2021-04-19 00:00:00 | 2021-04-29 00:00:00 | 2021-09-02 00:00:00 | 2022-06-27 00:00:00 | 2022-01-05 00:00:00 | 2022-06-22 00:00:00 | 2022-08-01 00:00:00 | 2021-08-16 00:00:00 | 2022-01-26 00:00:00 | 2021-08-16 00:00:00 | 2022-07-25 00:00:00 | 2021-09-02 00:00:00 | 2022-01-31 00:00:00 | 2022-01-05 00:00:00 | 2022-01-26 00:00:00 | 2022-07-25 00:00:00 | 2021-05-31 00:00:00 | 2022-09-27 00:00:00 | 2022-06-22 00:00:00 | 2021-04-19 00:00:00 | 2022-08-10 00:00:00 | 2022-08-10 00:00:00 | 2021-02-11 00:00:00 | 2021-12-16 00:00:00 | 2021-12-22 00:00:00 | 2021-10-31 00:00:00 | 2022-06-24 00:00:00 | 2021-12-16 00:00:00 | 2022-09-27 00:00:00 | 2022-10-31 00:00:00 | 2022-11-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_type | 10002 | 10006 | 10006 | 10006 | 10006 | 10006 | 10006 | 10006 | 10006 | 10006 | 10006 | 10002 | 10002 | 10006 | 10002 | 10006 | 10001 | 10002 | 10001 | 10005 | 10006 | 10006 | 10006 | 10002 | 10006 | 10002 | 10002 | 10002 | 10002 | 10002 | 10002 | 10005 | 10006 | 10006 | 10006 | 10002 | 10002 | 10005 | 10002 | 10002 | 10002 | 10002 | 10002 | 10001 | 10006 | 10002 | 10002 | 10006 | 10006 | 10006 | 10002 | 10002 | 10001 | 10002 | 10002 | 10002 | 10006 | 10006 | 10006 | 10006 | 10002 | 10002 | 10006 | 10006 | 10006 | 10002 | 10002 | 10002 | 10002 | 10005 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10006 | 10005 | 10002 | 10005 | 10002 | 10001 | 10005 | 10005 | 10002 | 10002 | 10005 | 10001 | 10002 | 10005 | 10002 | 10002 | 10001 | 10002 | 10002 | 10002 | 10005 | 10002 | 10002 | 10005 | 10002 | 10002 | 10002 | 10005 | 10005 | 10005 | 10005 | 10005 | 10002 | 10002 | 10001 | 10002 | 10002 | 10005 | 10001 | 10005 | 10002 | 10005 | 10002 | 10005 | 10002 | 10001 | 10005 | 10005 | 10002 | 10005 | 10005 | 10001 | 10006 | 10002 | 10001 | 10005 | 10005 | 10002 | 10005 | 10002 | 10002 | 10005 | 10005 | 10002 | 10001 | 10001 | 10005 | 10002 | 10001 | 10005 | 10005 | 10002 | 10005 | 10005 | 10001 | 10002 | 10006 | 10001 | 10002 | 10005 | 10005 | 10006 | 10002 | 10005 | 10005 | 10002 | 10002 | 10001 | 10005 | 10002 | 10002 | 10002 | 10002 | 10005 | 10002 | 10005 | 10002 | 10001 | 10005 | 10002 | 10002 | 10001 | 10006 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10002 | 10002 | 10005 | 10001 | 10006 | 10006 | 10002 | 10005 | 10002 | 10005 | 10002 | 10002 | 10005 | 10002 | 10002 | 10001 | 10002 | 10001 | 10005 | 10005 | 10001 | 10002 | 10002 | 10005 | 10002 | 10002 | 10005 | 10001 | 10002 | 10001 | 10002 | 10002 | 10002 | 10002 | 10001 | 10002 | 10005 | 10002 | 10002 | 10005 | 10001 | 10002 | 10002 | 10002 | 10002 | 10002 | 10005 | 10002 | 10002 | 10005 | 10002 | 10002 | 10002 | 10001 | 10002 | 10005 | 10002 | 10001 | 10002 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | 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 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11002 | 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 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| session_id | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2019 | 2019 | 2019 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2017 | 2017 | 2019 | 2019 | 2017 | 2017 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2021 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| user_id | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | AGLADNEY | YRODRIGU | AGLADNEY | GPEREZ | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | ASAETERN | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | ASAETERN | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | ASAETERN | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | AGLADNEY | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | SARRIAGA | AROJAS | GPEREZ | GPEREZ | GPEREZ | PBANFORD | AROJAS | GPEREZ | MKIRKHAM | AGLADNEY | YRODRIGU | JBEAUDOIN | AROJAS | GPEREZ | GPEREZ | AGLADNEY | GPEREZ | GPEREZ | AROJAS | GPEREZ | GPEREZ | AGLADNEY | GPEREZ | YRODRIGU | YRODRIGU | YRODRIGU | AGLADNEY | YRODRIGU | YRODRIGU | YRODRIGU | GPEREZ | YRODRIGU | YRODRIGU | GPEREZ | YRODRIGU | YRODRIGU | YRODRIGU | GPEREZ | GPEREZ | GPEREZ | GPEREZ | GPEREZ | GPEREZ | AGLADNEY | AGLADNEY | YRODRIGU | YRODRIGU | GPEREZ | AGLADNEY | GPEREZ | YRODRIGU | GPEREZ | YRODRIGU | GPEREZ | AGLADNEY | AGLADNEY | GPEREZ | GPEREZ | YRODRIGU | GPEREZ | GPEREZ | AGLADNEY | YRODRIGU | GPEREZ | YRODRIGU | GPEREZ | GPEREZ | YRODRIGU | GPEREZ | GPEREZ | YRODRIGU | GPEREZ | GPEREZ | YRODRIGU | YRODRIGU | AGLADNEY | GPEREZ | GPEREZ | AGLADNEY | GPEREZ | GPEREZ | GPEREZ | GPEREZ | GPEREZ | AGLADNEY | GPEREZ | YRODRIGU | AGLADNEY | GPEREZ | YRODRIGU | GPEREZ | YRODRIGU | GPEREZ | SARRIAGA | GPEREZ | GPEREZ | GPEREZ | MKIRKHAM | GPEREZ | YRODRIGU | GPEREZ | YRODRIGU | GPEREZ | GPEREZ | YRODRIGU | GPEREZ | YRODRIGU | AGLADNEY | JBEAUDOIN | CAFILER | GPEREZ | CHARTRIDGE | YRODRIGU | AGLADNEY | AGLADNEY | PBANFORD | GPEREZ | SARRIAGA | SARRIAGA | GPEREZ | GPEREZ | GPEREZ | LPHEAV | PBANFORD | PBANFORD | GPEREZ | GPEREZ | GPEREZ | GPEREZ | YRODRIGU | GPEREZ | GPEREZ | AROJAS | YRODRIGU | AGLADNEY | GPEREZ | AGLADNEY | SARRIAGA | CVANLIEW | CHATRIDGE | CVANLIEW | MMERCHANT | SARRIAGA | KWHELAN | SARRIAGA | CVANLIEW | CAFILER | MKIRKHAM | CHATRIDGE | SARRIAGA | CVANLIEW | MMERCHANT | CVANLIEW | CAFILER | MMERCHANT | SARRIAGA | MMERCHANT | MMERCHANT | SARRIAGA | MKIRKHAM | MMERCHANT | SARRIAGA | MMERCHANT | CAFILER | MMERCHANT | CVANLIEW | MKIRKHAM | SARRIAGA | SARRIAGA | MMERCHANT | SARRIAGA | MMERCHANT | CHATRIDGE | CAFILER | SARRIAGA | MMERCHANT | CAFILER | 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 | 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 | 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 | 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 | 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 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_start | 2015-06-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-07-31 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-06-16 00:00:00 | 1900-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-05-06 00:00:00 | 1900-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-02-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-02-20 00:00:00 | 2015-03-13 00:00:00 | 1900-01-01 00:00:00 | 2015-01-05 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-22 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-06-04 00:00:00 | 2015-07-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-11-04 00:00:00 | 2015-07-01 00:00:00 | 2015-07-20 00:00:00 | 2015-04-03 00:00:00 | 2015-08-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-09-14 00:00:00 | 2015-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-08-01 00:00:00 | 2019-04-01 00:00:00 | 2019-12-31 00:00:00 | 2019-06-03 00:00:00 | 1900-01-01 00:00:00 | 2017-12-13 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-03-13 00:00:00 | 2020-04-01 00:00:00 | 2017-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2018-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-12-10 00:00:00 | 2017-10-20 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2020-02-25 00:00:00 | 1900-01-01 00:00:00 | 2015-12-31 00:00:00 | 2016-02-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-07-01 00:00:00 | 2015-11-03 00:00:00 | 1900-01-01 00:00:00 | 2016-03-21 00:00:00 | 2016-01-07 00:00:00 | 1900-01-01 00:00:00 | 2015-10-01 00:00:00 | 2015-03-23 00:00:00 | 2015-11-04 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-04-29 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-21 00:00:00 | 1900-01-01 00:00:00 | 2016-04-01 00:00:00 | 1900-01-01 00:00:00 | 2016-07-20 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-10-15 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-03-17 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-02-08 00:00:00 | 1900-01-01 00:00:00 | 2017-03-20 00:00:00 | 2016-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2018-12-31 00:00:00 | 2017-04-01 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-26 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-07-01 00:00:00 | 2017-08-10 00:00:00 | 1900-01-01 00:00:00 | 2018-10-01 00:00:00 | 2017-07-02 00:00:00 | None | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-08-24 00:00:00 | 2019-01-31 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 2020-02-28 00:00:00 | 2018-06-08 00:00:00 | 2020-07-14 00:00:00 | 1900-01-01 00:00:00 | 2018-04-21 00:00:00 | 1900-01-01 00:00:00 | 2018-05-11 00:00:00 | 2017-10-01 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2020-09-21 00:00:00 | 2020-07-01 00:00:00 | 1900-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-07-01 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-12-31 00:00:00 | 2020-03-11 00:00:00 | 2019-10-15 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-02-09 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 1900-01-01 00:00:00 | 2018-03-27 00:00:00 | 2018-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-11-21 00:00:00 | 2019-10-01 00:00:00 | 2019-09-01 00:00:00 | 2018-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-03-13 00:00:00 | 2021-03-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-01-25 00:00:00 | 1900-01-01 00:00:00 | 2022-01-01 00:00:00 | 2021-04-06 00:00:00 | 2021-01-01 00:00:00 | 2021-08-26 00:00:00 | 2022-04-12 00:00:00 | 2021-12-03 00:00:00 | 2022-05-20 00:00:00 | 2022-04-01 00:00:00 | 2021-07-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 1900-01-01 00:00:00 | 2022-01-10 00:00:00 | 2022-06-29 00:00:00 | 2020-10-01 00:00:00 | 2022-09-07 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-08-03 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-11-18 00:00:00 | 2021-11-08 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-07-01 00:00:00 | 2022-10-05 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_end | 2015-06-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-07-31 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-06-16 00:00:00 | 1900-01-01 00:00:00 | 2015-06-30 00:00:00 | 2015-01-01 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-05-06 00:00:00 | 1900-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-02-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-02-20 00:00:00 | 2015-03-13 00:00:00 | 1900-01-01 00:00:00 | 2015-01-05 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-22 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-06-04 00:00:00 | 2015-07-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-11-04 00:00:00 | 2015-09-30 00:00:00 | 2015-07-20 00:00:00 | 2015-04-03 00:00:00 | 2015-08-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-09-14 00:00:00 | 2015-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-08-01 00:00:00 | 2019-04-01 00:00:00 | 2019-12-31 00:00:00 | 2019-06-03 00:00:00 | 1900-01-01 00:00:00 | 2017-12-13 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-03-13 00:00:00 | 2020-06-30 00:00:00 | 2017-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2018-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-12-10 00:00:00 | 2017-10-20 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 2020-02-25 00:00:00 | 1900-01-01 00:00:00 | 2015-12-31 00:00:00 | 2016-02-01 00:00:00 | 2015-12-31 00:00:00 | 2015-11-01 00:00:00 | 2015-07-01 00:00:00 | 2015-11-03 00:00:00 | 1900-01-01 00:00:00 | 2016-03-21 00:00:00 | 2016-01-07 00:00:00 | 1900-01-01 00:00:00 | 2015-10-01 00:00:00 | 2015-03-23 00:00:00 | 2015-11-04 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-04-29 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-04-01 00:00:00 | 2016-07-21 00:00:00 | 1900-01-01 00:00:00 | 2016-06-30 00:00:00 | 1900-01-01 00:00:00 | 2016-07-20 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-10-15 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-03-17 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-02-08 00:00:00 | 1900-01-01 00:00:00 | 2017-03-20 00:00:00 | 2016-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2018-12-31 00:00:00 | 2017-06-30 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-26 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 2017-08-10 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2017-07-02 00:00:00 | None | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-08-24 00:00:00 | 2019-01-31 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 2020-02-28 00:00:00 | 2018-06-08 00:00:00 | 2020-07-14 00:00:00 | 1900-01-01 00:00:00 | 2018-04-21 00:00:00 | 1900-01-01 00:00:00 | 2018-05-11 00:00:00 | 2017-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2020-09-21 00:00:00 | 2020-09-30 00:00:00 | 1900-01-01 00:00:00 | 2019-03-31 00:00:00 | 2019-09-30 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-12-31 00:00:00 | 2020-03-11 00:00:00 | 2019-10-15 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-02-09 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 1900-01-01 00:00:00 | 2018-03-27 00:00:00 | 2018-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-11-21 00:00:00 | 2019-12-31 00:00:00 | 2019-09-01 00:00:00 | 2018-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2022-03-13 00:00:00 | 2021-03-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-01-25 00:00:00 | 1900-01-01 00:00:00 | 2022-03-31 00:00:00 | 2021-04-06 00:00:00 | 2021-03-31 00:00:00 | 2021-08-26 00:00:00 | 2022-04-12 00:00:00 | 2021-12-03 00:00:00 | 2022-05-20 00:00:00 | 2022-06-30 00:00:00 | 2021-07-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 1900-01-01 00:00:00 | 2022-01-10 00:00:00 | 2022-06-29 00:00:00 | 2020-12-31 00:00:00 | 2022-09-07 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-08-03 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-11-18 00:00:00 | 2021-11-08 00:00:00 | 2021-09-30 00:00:00 | 2022-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-09-30 00:00:00 | 2022-10-05 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 22001 | None | None | None | None | None | None | None | None | None | None | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | None | None | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | None | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | None | None | None | None | 22001 | 22001 | None | None | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | None | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | None | 22001 | None | 22001 | 22001 | None | None | 22001 | None | None | 22001 | None | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | None | 22001 | None | None | 22001 | 22001 | None | 22001 | 22001 | None | None | None | 22001 | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | 22001 | None | None | 22001 | None | 22001 | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 |
| filer_id | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| filer_type | 3 | 3 | 3 | 3 | 3 | |||||
| active | Y | Y | Y | Y | N | |||||
| race | None | None | 0 | None | None | |||||
| session_id | 2019 | 2021 | 2015 | 2017 | 2023 | |||||
| category | None | None | 0 | None | None | |||||
| category_type | None | None | 0 | None | None | |||||
| sub_category | None | None | 0 | None | None | |||||
| effect_dt | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||
| sub_category_type | None | None | 0 | None | None | |||||
| election_type | None | None | 0 | None | None | |||||
| sub_category_a | None | None | None | None | None | |||||
| nyq_dt | None | None | None | None | None | |||||
| party_cd | None | None | 0 | None | None | |||||
| county_cd | None | None | 0 | None | None | |||||
| district_cd | None | None | 0 | None | None |
| filer_id | 1373846 | |
|---|---|---|
| xref_id | 1373846 | |
| effect_dt | 2014-12-03 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| naml | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||||||||||||||||||
| phon | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| [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 | 1373846 |
|---|
| filer_id | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| change_no | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 12 | 13 | 11 | 14 | 22 | 23 | 24 | 25 | 17 | 18 | 19 | 15 | 26 | 20 | 0 | 21 | 16 | 33 | 32 | 28 | 30 | 27 | 29 | 31 | 36 | 34 | 35 | 37 | 38 | 41 | 39 | 40 | 45 | 42 | 48 | 47 | 52 | 46 | 43 | 44 | 51 | 50 | 49 | 62 | 63 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| session_id | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| log_dt | 2015-01-27 00:00:00 | 2015-01-21 00:00:00 | 2015-01-21 00:00:00 | 2015-01-21 00:00:00 | 2015-01-21 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-03-27 00:00:00 | 2015-04-06 00:00:00 | 2015-02-27 00:00:00 | 2015-06-05 00:00:00 | 2015-08-10 00:00:00 | 2016-02-11 00:00:00 | 2015-11-06 00:00:00 | 2015-11-18 00:00:00 | 2015-08-24 00:00:00 | 2015-08-24 00:00:00 | 2015-08-24 00:00:00 | 2015-05-21 00:00:00 | 2016-01-04 00:00:00 | 2015-09-29 00:00:00 | 2016-01-20 00:00:00 | 2015-06-23 00:00:00 | 2015-07-27 00:00:00 | 2017-07-31 00:00:00 | 2017-04-03 00:00:00 | 2016-03-28 00:00:00 | 2017-01-31 00:00:00 | 2016-05-02 00:00:00 | 2016-10-31 00:00:00 | 2017-02-16 00:00:00 | 2017-11-17 00:00:00 | 2017-07-14 00:00:00 | 2017-08-15 00:00:00 | 2018-02-12 00:00:00 | 2018-02-14 00:00:00 | 2018-05-10 00:00:00 | 2018-03-26 00:00:00 | 2018-06-06 00:00:00 | 2019-11-01 00:00:00 | 2018-04-04 00:00:00 | 2020-01-21 00:00:00 | 2020-01-03 00:00:00 | 2020-09-28 00:00:00 | 2019-12-19 00:00:00 | 2019-02-12 00:00:00 | 2019-02-12 00:00:00 | 2020-09-03 00:00:00 | 2020-07-28 00:00:00 | 2020-02-28 00:00:00 | 2022-01-05 00:00:00 | 2022-07-25 00:00:00 | 2021-02-11 00:00:00 | 2021-02-11 00:00:00 | 2021-02-11 00:00:00 | 2021-02-11 00:00:00 | 2021-02-11 00:00:00 | 2021-02-11 00:00:00 | 2021-02-11 00:00:00 | 2021-02-11 00:00:00 | 2021-04-19 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filer_type | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 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 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | None | Y | Y | None | Y | None | Y | Y | Y | Y | Y | Y | Y | Y | Y | None | Y | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| action | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | DELETED | TERMINATED | DELETED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | DELETED | ADDED | ADDED | ADDED | DELETED | DELETED | ADDED | ADDED | DELETED | DELETED | DELETED | DELETED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | DELETED | ADDED | DELETED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | DELETED | DELETED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| attribute_changed | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | LOBBYIST | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | CLIENT | EMPLOYER | EMPLOYER | CLIENT | EMPLOYER | CLIENT | EMPLOYER | EMPLOYER | / FIRM | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | ETHICS | CLIENT | EMPLOYER | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | FIRM | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_full_name | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | NIEMELA, PAPPAS AND ASSOCIATES | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filer_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | SACRAMENTO | None | SACRAMENTO | SACRAMENTO | None | None | None | None | None | None | None | SACRAMENTO | None | None | SACRAMENTO | SACRAMENTO | None | None | None | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | None | SACRAMENTO | None | SACRAMENTO | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filer_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | CA | None | CA | CA | None | None | None | None | None | None | None | CA | None | None | CA | CA | None | None | None | CA | CA | CA | CA | CA | CA | CA | None | CA | None | CA | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filer_zip | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 95814 | None | 95814 | 95814 | None | None | None | None | None | None | None | 95814 | None | None | 95814 | 95814 | None | None | None | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | None | 95814 | None | 95814 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filer_phone | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 9166615365 | None | 9166615365 | 9166615365 | None | None | None | None | None | None | None | 9166615365 | None | None | 9166615365 | 9166615365 | None | None | None | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | 9166615365 | None | 9166615365 | None | 9166615365 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| entity_type | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 1 | 2 | 1 | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| entity_name | TOBACCO-FREE KIDS ACTION FUND | BIG HEART PET BRANDS | DEERE & COMPANY | LAUREATE EDUCATION INC | SALESFORCE.COM | ANIMAL HEALTH INSTITUTE | CALIFORNIA INFILL BUILDERS FEDERATION | E.I. DU PONT DE NEMOURS AND COMPANY | NEXTGEN CLIMATE ACTION | SHORENSTEIN PROPERTIES LLC | WOUNDED WARRIOR PROJECT, INC. | LAND O'LAKES, INC. | HEWLETT-PACKARD COMPANY | TOBACCO-FREE KIDS ACTION FUND | WHITEN, TIFFANY J. | CALIFORNIA INFILL FEDERATION | HEWLETT PACKARD ENTERPRISE | J.M. SMUCKER COMPANY AND ITS DIVISION BIG HEART PET BRANDS; THE | NATERA, INC. | CAWELO WATER DISTRICT | PAYPAL | ECOLAB, INC. | DYNEGY INC. | RELAYRIDES | UNITED ANIMAL NATIONS D.B.A. REDROVER | BLUE DIAMOND GROWERS | WOUNDED WARRIOR PROJECT, INC. | NATERA, INC. | UNIVERSAL PARAGON CORPORATION | NEL ASA/H2 LOGIC | BROOKFIELD POWER US ASSET MANAGEMENT LLC | ANIMAL HEALTH INSTITUTE | UNITED ANIMAL NATIONS D.B.A. REDROVER | ANIMAL RESCUE MEDIA AND EDUCATION (ARME) | RECOVERY REFORM NOW | SMITH, WATTS & HARTMANN | TOBACCO-FREE KIDS ACTION FUND | TURLOCK IRRIGATION DISTRICT | WEWORK | ANIMAL HEALTH INSTITUTE | LARGE-SCALE SOLAR ASSOCIATION | LENDINGTREE, LLC | REPLANET LLC | EVERBRIDGE, INC. | J P MORGAN CHASE HOLDINGS LLC | UNIVERSITY OF ST AGUSTINE FOR HEALTH SCIENCE, LLC | EYESAFE | BUMBLE TRADING, INC. | BLOCKCHAIN ADVOCACY COALITION | NOTARIZE, INC. | STUBHUB, INC. | LENDING TREE, LLC | PLATINUM ADVISORS, LLC | MONTEREY ONE WATER | DEERE & COMPANY | UNION PACIFIC RAILROAD COMPANY | TURLOCK IRRIGATION DISTRICT | PACIFIC DENTAL SERVICES | HEWLETT PACKARD ENTERPRISE COMPANY | HP, INC. | CALIFORNIA COURT APPOINTED SPECIAL ADVOCATE ASSN | BLOCKCHAIN ADVOCACY COALITION | ALIGN TECHNOLOGY, INC | STUBHUB | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| entity_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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| entity_id | 1374676 | 1326816 | 1224150 | 1318840 | 1337918 | 1374904 | 1327315 | 1146862 | 1364969 | 1373990 | 1376381 | 1370814 | 1143350 | 1374676 | None | 1327315 | None | None | 1379413 | 1379414 | 1379412 | 1143856 | 1146674 | 1380318 | 1382092 | None | 1376381 | 1379413 | None | None | 1387649 | 1374904 | 1382092 | None | None | None | None | None | None | None | 1316264 | None | 1348869 | None | 1393266 | 1423850 | 1433252 | 1423545 | 1417813 | 1405824 | 1287333 | 1406568 | 1147749 | 1443994 | 1224150 | 1146885 | 1144982 | 1265801 | 1380985 | 1143350 | 1438044 | 1417813 | 1439775 | 1287333 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| responsible_officer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| effect_dt | 2015-01-22 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-02-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-03-12 00:00:00 | 2015-04-01 00:00:00 | 2015-02-20 00:00:00 | 2015-06-04 00:00:00 | 2015-07-31 00:00:00 | 2016-02-01 00:00:00 | 2015-11-01 00:00:00 | 2015-11-04 00:00:00 | 2015-08-01 00:00:00 | 2015-08-01 00:00:00 | 2015-07-20 00:00:00 | 2015-05-06 00:00:00 | 2015-12-31 00:00:00 | 2015-09-14 00:00:00 | 2016-01-07 00:00:00 | 2015-06-16 00:00:00 | 2015-05-31 00:00:00 | 2017-06-30 00:00:00 | 2017-03-20 00:00:00 | 2016-03-08 00:00:00 | 2016-09-30 00:00:00 | 2015-12-31 00:00:00 | 2016-06-30 00:00:00 | 2017-01-01 00:00:00 | 2017-10-20 00:00:00 | 2017-07-01 00:00:00 | 2017-08-09 00:00:00 | 2018-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2018-03-01 00:00:00 | 2018-05-23 00:00:00 | 2019-10-15 00:00:00 | 2018-03-27 00:00:00 | 2020-01-01 00:00:00 | 2019-11-01 00:00:00 | 2020-09-21 00:00:00 | 2019-12-09 00:00:00 | 2019-01-27 00:00:00 | 2019-01-01 00:00:00 | 2020-08-20 00:00:00 | 2019-12-31 00:00:00 | 2019-11-30 00:00:00 | 2021-10-01 00:00:00 | 2022-06-22 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 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 |
| filer_id | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | 1373846 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 1920568_27.cal | 1920568_22.cal | 1920568_19.cal | 454325.cal | 1920568_18.cal | 1920568_15.cal | 1920568_17.cal | 1981150_0.cal | 1920568_24.cal | 1920568_25.cal | 161950.cal | 1920568_26.cal | 1920568_20.cal | 1920568_16.cal | 1920568_21.cal | 2130797_4.cal | 1920568_46.cal | 2130797_1.cal | 2130797_3.cal | 2130797_0.cal | 1920568_29.cal | 1920568_30.cal | 1920568_31.cal | 1920568_28.cal | 1920568_36.cal | 1920568_33.cal | 1920568_32.cal | 1920568_34.cal | 1920568_35.cal | 1998106_0.cal | 2012567_0.cal | 1920568_37.cal | 2130797_2.cal | 2116927_0.cal | 2064822_1.cal | 1920568_39.cal | 1920568_38.cal | 2064822_0.cal | 1920568_42.cal | 1920568_13.cal | 1920568_0.cal | 1920568_5.cal | 1920568_1.cal | 1920568_2.cal | 1920568_3.cal | 1920568_4.cal | 1963877_0.cal | 2038177_0.cal | 1920568_40.cal | 1920568_7.cal | 1920568_8.cal | 1920568_9.cal | 1920568_10.cal | 1920568_11.cal | 1920568_23.cal | 1920568_6.cal | 1920568_14.cal | 1920568_12.cal | 2130797_7.cal | 2175761_0.cal | 2130797_8.cal | 2130797_6.cal | 2130797_5.cal | 2157776_0.cal | 472413.cal | 347127.cal | 2130797_20.cal | 2193814_0.cal | 2487762_0.cal | 2396096_0.cal | 2130797_13.cal | 2241170_0.cal | 2333767_7.cal | 2333767_9.cal | 2333767_5.cal | 2130797_10.cal | 2419122_0.cal | 60977.cal | 2348181_0.cal | 2318513_0.cal | 2130797_9.cal | 2471569_0.cal | 2333767_3.cal | 2333767_2.cal | 272471.cal | 2130797_17.cal | 2333767_13.cal | 2130797_18.cal | 2130797_16.cal | 2333767_4.cal | 2130797_15.cal | 2208029_0.cal | 2333767_6.cal | 2333767_14.cal | 2333767_0.cal | 119622.cal | 2333767_8.cal | 2130797_12.cal | 2333767_1.cal | 2333767_10.cal | 2333767_12.cal | 2130797_11.cal | 2130797_14.cal | 2441877_0.cal | 2130797_19.cal | 2269368_0.cal | 2333767_11.cal | 2541534_15.cal | 155699.cal | 2541534_7.cal | 2677802_1.cal | 2541534_12.cal | 2541534_1.cal | 2541534_0.cal | 71659.cal | 2541534_6.cal | 2541534_5.cal | 2529778_0.cal | 439941.cal | 2333767_15.cal | 155722.cal | 454411.cal | 2541534_14.cal | 2677802_0.cal | 2601842_0.cal | 2541534_13.cal | 438923.cal | 438162.cal | 2579797_0.cal | 87959.cal | 2541534_16.cal | 393318.cal | 2541534_8.cal | 2643594_0.cal | 439677.cal | 2541534_2.cal | 2748856_0.cal | 2555340_0.cal | 2623695_0.cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| received_date | 2015-09-29 00:00:00 | 2015-07-31 00:00:00 | 2015-06-05 00:00:00 | 2015-05-26 00:00:00 | 2015-05-26 00:00:00 | 2015-04-30 00:00:00 | 2015-05-21 00:00:00 | 2015-07-30 00:00:00 | 2015-08-24 00:00:00 | 2015-08-24 00:00:00 | 2015-08-24 00:00:00 | 2015-08-24 00:00:00 | 2015-06-23 00:00:00 | 2015-05-12 00:00:00 | 2015-07-27 00:00:00 | 2017-04-04 00:00:00 | 2017-01-31 00:00:00 | 2017-02-16 00:00:00 | 2017-03-21 00:00:00 | 2017-01-31 00:00:00 | 2015-11-06 00:00:00 | 2015-11-06 00:00:00 | 2015-11-06 00:00:00 | 2015-11-06 00:00:00 | 2016-01-20 00:00:00 | 2016-01-05 00:00:00 | 2015-11-18 00:00:00 | 2016-01-15 00:00:00 | 2016-01-15 00:00:00 | 2015-11-02 00:00:00 | 2016-02-01 00:00:00 | 2016-02-01 00:00:00 | 2017-02-24 00:00:00 | 2017-01-03 00:00:00 | 2016-10-31 00:00:00 | 2016-03-28 00:00:00 | 2016-02-11 00:00:00 | 2016-08-01 00:00:00 | 2016-08-09 00:00:00 | 2015-03-27 00:00:00 | 2014-12-23 00:00:00 | 2015-01-22 00:00:00 | 2015-01-21 00:00:00 | 2015-01-21 00:00:00 | 2015-01-21 00:00:00 | 2015-01-21 00:00:00 | 2015-04-29 00:00:00 | 2016-05-02 00:00:00 | 2016-05-02 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-08-10 00:00:00 | 2015-01-28 00:00:00 | 2015-04-06 00:00:00 | 2015-02-27 00:00:00 | 2017-07-14 00:00:00 | 2017-07-31 00:00:00 | 2017-07-31 00:00:00 | 2017-06-20 00:00:00 | 2017-05-01 00:00:00 | 2017-05-01 00:00:00 | 2018-05-10 00:00:00 | 2017-10-31 00:00:00 | 2019-03-20 00:00:00 | 2017-10-31 00:00:00 | 2020-07-31 00:00:00 | 2019-07-30 00:00:00 | 2018-03-26 00:00:00 | 2018-04-30 00:00:00 | 2019-11-01 00:00:00 | 2020-01-10 00:00:00 | 2019-08-14 00:00:00 | 2017-11-20 00:00:00 | 2019-10-31 00:00:00 | 2018-05-16 00:00:00 | 2019-01-31 00:00:00 | 2018-10-31 00:00:00 | 2017-08-15 00:00:00 | 2020-04-30 00:00:00 | 2019-06-03 00:00:00 | 2019-06-03 00:00:00 | 2019-06-03 00:00:00 | 2018-06-08 00:00:00 | 2020-07-28 00:00:00 | 2018-10-23 00:00:00 | 2018-05-15 00:00:00 | 2019-07-23 00:00:00 | 2018-05-10 00:00:00 | 2018-01-29 00:00:00 | 2019-10-07 00:00:00 | 2020-09-03 00:00:00 | 2019-01-10 00:00:00 | 2020-03-12 00:00:00 | 2019-12-19 00:00:00 | 2018-02-15 00:00:00 | 2019-04-16 00:00:00 | 2020-03-12 00:00:00 | 2020-03-26 00:00:00 | 2018-02-09 00:00:00 | 2018-04-05 00:00:00 | 2020-01-31 00:00:00 | 2018-12-17 00:00:00 | 2018-07-25 00:00:00 | 2020-03-12 00:00:00 | 2022-09-27 00:00:00 | 2020-09-28 00:00:00 | 2022-01-05 00:00:00 | 2022-06-24 00:00:00 | 2022-06-27 00:00:00 | 2021-03-09 00:00:00 | 2020-12-31 00:00:00 | 2022-01-31 00:00:00 | 2021-12-22 00:00:00 | 2021-12-16 00:00:00 | 2020-11-01 00:00:00 | 2022-08-01 00:00:00 | 2020-09-28 00:00:00 | 2020-09-28 00:00:00 | 2022-08-01 00:00:00 | 2022-08-10 00:00:00 | 2022-05-02 00:00:00 | 2021-07-31 00:00:00 | 2022-07-25 00:00:00 | 2022-08-01 00:00:00 | 2022-08-01 00:00:00 | 2021-04-29 00:00:00 | 2022-08-10 00:00:00 | 2022-11-01 00:00:00 | 2022-01-26 00:00:00 | 2022-01-26 00:00:00 | 2022-01-31 00:00:00 | 2022-08-01 00:00:00 | 2021-04-19 00:00:00 | 2022-10-31 00:00:00 | 2021-02-02 00:00:00 | 2021-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /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/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /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/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /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/temp | /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/temp | /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/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_id | 1920568 | 1920568 | 1920568 | None | 1920568 | 1920568 | 1920568 | 1981150 | 1920568 | 1920568 | None | 1920568 | 1920568 | 1920568 | 1920568 | 2130797 | 1920568 | 2130797 | 2130797 | 2130797 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1998106 | 2012567 | 1920568 | 2130797 | 2116927 | 2064822 | 1920568 | 1920568 | 2064822 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1963877 | 2038177 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 1920568 | 2130797 | 2175761 | 2130797 | 2130797 | 2130797 | 2157776 | None | None | 2130797 | 2193814 | 2487762 | 2396096 | 2130797 | 2241170 | 2333767 | 2333767 | 2333767 | 2130797 | 2419122 | None | 2348181 | 2318513 | 2130797 | 2471569 | 2333767 | 2333767 | None | 2130797 | 2333767 | 2130797 | 2130797 | 2333767 | 2130797 | 2208029 | 2333767 | 2333767 | 2333767 | None | 2333767 | 2130797 | 2333767 | 2333767 | 2333767 | 2130797 | 2130797 | 2441877 | 2130797 | 2269368 | 2333767 | 2541534 | None | 2541534 | 2677802 | 2541534 | 2541534 | 2541534 | None | 2541534 | 2541534 | 2529778 | None | 2333767 | None | None | 2541534 | 2677802 | 2601842 | 2541534 | None | None | 2579797 | None | 2541534 | None | 2541534 | 2643594 | None | 2541534 | 2748856 | 2555340 | 2623695 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F601 | F601 | F601 | None | F601 | F601 | F601 | F625 | F601 | F601 | None | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F625 | F625 | F601 | F601 | F601 | F625 | F601 | F601 | F625 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F625 | F625 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F625 | F601 | F601 | F601 | F625 | None | None | F601 | F625 | F625 | F625 | F601 | F625 | F601 | F601 | F601 | F601 | F625 | None | F625 | F625 | F601 | F625 | F601 | F601 | None | F601 | F601 | F601 | F601 | F601 | F601 | F625 | F601 | F601 | F601 | None | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F625 | F601 | F625 | F601 | F601 | None | F601 | F625 | F601 | F601 | F601 | None | F601 | F601 | F625 | None | F601 | None | None | F601 | F625 | F625 | F601 | None | None | F625 | None | F601 | None | F601 | F625 | None | F601 | F625 | F625 | F625 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing accepted | Filing passed validation, but failed DB constraints | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted |