filing_id | 2152335 | 2171425 | 2152335 | 2152335 | 2190963 | 2171425 | 2210791 | 2190963 | 2210791 | 2270182 | 2210791 | 2236539 | 2350120 | 2377889 | 2311918 | 2377889 | 2378117 | 2400782 | 2378117 | 2417983 | 2470848 | 2437878 | 2378117 | 2438042 | 2417972 | 2400782 | 2470848 | 2437878 | 2378117 | 2528385 | 2417972 | 2378117 | 2551075 | 2486749 | 2528385 | 2486749 | 2551075 | 2601252 | 2623078 | 2580803 | 2673559 | 2580803 | 2644750 | 2703155 | 2748193 | |||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 2 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 1 | 1 | 3 | 1 | 1 | 4 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 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 | F635 | F625 | F635 | F625 | F625 | F625 | F635 | F625 | F625 | F625 | F635 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | |||||||||||||||||||||||||||||||||||||||||||||
sender_id | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | |||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | |||||||||||||||||||||||||||||||||||||||||||||
entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | LEM | FRM | LEM | FRM | FRM | FRM | LEM | FRM | FRM | FRM | LEM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | |||||||||||||||||||||||||||||||||||||||||||||
filer_naml | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | |||||||||||||||||||||||||||||||||||||||||||||
filer_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | |||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||
report_num | 002 | 000 | 000 | 001 | 000 | 001 | 001 | 001 | 000 | 000 | 002 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 002 | 000 | 000 | 001 | 001 | 001 | 003 | 001 | 001 | 004 | 001 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | |||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2017-04-20 00:00:00 | 2017-07-25 00:00:00 | 2017-04-20 00:00:00 | 2017-04-20 00:00:00 | 2017-10-26 00:00:00 | 2017-10-26 00:00:00 | 2018-02-02 00:00:00 | 2017-10-26 00:00:00 | 2018-01-31 00:00:00 | 2018-07-26 00:00:00 | 2018-02-02 00:00:00 | 2018-04-25 00:00:00 | 2019-01-31 00:00:00 | 2019-07-31 00:00:00 | 2018-10-24 00:00:00 | 2019-04-26 00:00:00 | 2019-04-28 00:00:00 | 2019-08-01 00:00:00 | 2019-07-31 00:00:00 | 2019-10-30 00:00:00 | 2020-04-30 00:00:00 | 2020-01-29 00:00:00 | 2019-08-01 00:00:00 | 2020-01-29 00:00:00 | 2019-10-30 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | 2021-04-01 00:00:00 | 2020-11-04 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | 2020-10-30 00:00:00 | 2020-07-31 00:00:00 | 2021-01-29 00:00:00 | 2021-07-30 00:00:00 | 2021-10-29 00:00:00 | 2021-04-30 00:00:00 | 2022-04-28 00:00:00 | 2022-02-24 00:00:00 | 2022-01-31 00:00:00 | 2022-07-28 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||
from_date | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-07-01 00:00:00 | 2017-04-01 00:00:00 | 2017-10-01 00:00:00 | 2017-07-01 00:00:00 | 2017-10-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-04-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-04-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2019-04-01 00:00:00 | 2020-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-01-01 00:00:00 | 2020-07-01 00:00:00 | 2019-07-01 00:00:00 | 2019-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-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-07-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||
thru_date | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2017-03-31 00:00:00 | 2017-09-30 00:00:00 | 2017-06-30 00:00:00 | 2017-12-31 00:00:00 | 2017-09-30 00:00:00 | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2019-03-31 00:00:00 | 2019-06-30 00:00:00 | 2019-06-30 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2019-12-31 00:00:00 | 2019-03-31 00:00:00 | 2019-12-31 00:00:00 | 2019-09-30 00:00:00 | 2019-06-30 00:00:00 | 2020-03-31 00:00:00 | 2019-12-31 00:00:00 | 2019-03-31 00:00:00 | 2020-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-03-31 00:00:00 | 2020-12-21 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-12-21 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2022-03-31 00:00:00 | 2021-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||
cum_beg_dt | 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 | 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 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||
firm_id | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | |||||||||||||||||||||||||||||||||||||||||||||
firm_name | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | |||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||||||||||||||||||||||||||||||||||||||
firm_phon | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 9168346344 | 916-769-6820 | 9168346344 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 9168346344 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 9168346344 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | 916-769-6820 | |||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||
sig_date | 2017-04-20 00:00:00 | 2017-07-25 00:00:00 | 2017-04-21 00:00:00 | 2017-04-21 00:00:00 | 2017-10-26 00:00:00 | 2017-10-26 00:00:00 | 2018-02-02 00:00:00 | 2017-12-20 00:00:00 | 2018-01-31 00:00:00 | 2018-07-26 00:00:00 | 2018-04-25 00:00:00 | 2018-04-25 00:00:00 | 2019-01-31 00:00:00 | 2020-07-31 00:00:00 | 2018-10-24 00:00:00 | 2019-04-26 00:00:00 | 2019-04-28 00:00:00 | 2019-08-01 00:00:00 | 2019-07-31 00:00:00 | 2019-10-30 00:00:00 | 2020-04-30 00:00:00 | 2020-01-29 00:00:00 | 2019-08-01 00:00:00 | 2020-01-29 00:00:00 | 2019-10-30 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | 2021-04-01 00:00:00 | 2020-11-05 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | 2020-10-30 00:00:00 | 2020-07-31 00:00:00 | 2021-01-29 00:00:00 | 2021-07-30 00:00:00 | 2021-10-29 00:00:00 | 2021-04-30 00:00:00 | 2022-04-28 00:00:00 | 2022-02-24 00:00:00 | 2022-01-31 00:00:00 | 2022-07-28 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||
sig_loc | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento | Sacramento CA | Sacramenro CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento CA | SACRAMENTO CA | Sacramento CA | SACRAMENTO CA | Sacramento | Sacramento CA | Sacramento | Sacramento CA | SACRAMENTO CA | SACRAMENTO CA | SACRAMENTO CA | Sacramento CA | SACRAMENTO CA | SACRAMENTO CA | SACRAMENTO CA | SACRAMENTO CA | SACRAMENTO CA | Sacramento California | Sacramento CA | Sacramento | Sacramento CA | Sacramento | Sacramento | Sacramento CA | Saramento CA | Sacramento CA | Sacramento CA | Sacramento CA | |||||||||||||||||||||||||||||||||||||||||||||
sig_naml | Price | Price | Taylor | Taylor | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | PRICE | Price | PRICE | Price | Price | Price | Price | PRICE | PRICE | PRICE | Price | PRICE | PRICE | PRICE | PRICE | PRICE | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | |||||||||||||||||||||||||||||||||||||||||||||
sig_namf | Jena | Jena | Heather | Heather | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | JENA | Jena | JENA | Jena | Jena | Jena | Jena | JENA | JENA | JENA | Jena | JENA | JENA | JENA | JENA | JENA | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | |||||||||||||||||||||||||||||||||||||||||||||
sig_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | MS. | None | None | 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 | |||||||||||||||||||||||||||||||||||||||||||||
prn_naml | Price | Price | Taylor | Taylor | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | PRICE | Price | PRICE | Price | Price | Price | Price | PRICE | PRICE | PRICE | Price | PRICE | PRICE | PRICE | PRICE | PRICE | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | |||||||||||||||||||||||||||||||||||||||||||||
prn_namf | Jena | Jena | Heather | Heather | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | JENA | Jena | JENA | Jena | Jena | Jena | Jena | JENA | JENA | JENA | Jena | JENA | JENA | JENA | JENA | JENA | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | |||||||||||||||||||||||||||||||||||||||||||||
prn_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | MS. | None | None | 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 | |||||||||||||||||||||||||||||||||||||||||||||
sig_title | Principal | Principal | Bookkeeper | Bookkeeper | Principal | Principal | Principal | Principal | Principal | Partner | Principal | Principal | Partner | Partner | Partner | Partner | Partner | Partner | PRINCIPAL | Partner | PRINCIPAL | Partner | Partner | Partner | Partner | PRINCIPAL | PRINCIPAL | PRINCIPAL | Partner | PRINCIPAL | PRINCIPAL | PRINCIPAL | PRINCIPAL | PRINCIPAL | Responsible Officer | Responsible Officer | Responsible Officer | Responsible Officer | Responsible Officer | Responsible Officer | Responsible Officer | Responsible Officer | Responsible Officer | Responsible Officer | Responsible Officer | |||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | None | X | None | X | X | X | None | X | X | X | None | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | TYPE ACTIONS LOBBIED HERE: SB 56; AB 1799 | None | None | None | NONE | None | 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 | None | X | None | X | X | X | None | X | X | X | None | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | 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 | 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 | 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 | None | None | None | None | None | None | None | None | None | None |
filing_id | 2147424 | 2148952 | 2147424 | 2148952 | 2147424 | 2148952 | 2148952 | 2148952 | 2148952 | 2148952 | 2148952 | 2148952 | 2148952 | 2148952 | 2148952 | 2148952 | 2148952 | 2148952 | 2148952 | 2148952 | 2148952 | 2208795 | 2148952 | 2148952 | 2148952 | 2329641 | 2359779 | 2359779 | 2359779 | 2359779 | 2359779 | 2359779 | 2368488 | 2359779 | 2359779 | 2359779 | 2359779 | 2359779 | 2359779 | 2359779 | 2359779 | 2540917 | 2540917 | 2540917 | 2540917 | 2540917 | 2540917 | 2540917 | 2540917 | 2540917 | 2681041 | 2681041 | 2540917 | 2540917 | 2540917 | 2540917 | 2540917 | 2670984 | 2540917 | 2540917 | 2670984 | 2540917 | 2681041 | 2540917 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 2 | 3 | 1 | 2 | 0 | 1 | 0 | 9 | 8 | 4 | 7 | 10 | 5 | 6 | 16 | 14 | 18 | 17 | 12 | 11 | 15 | 0 | 19 | 13 | 20 | 0 | 0 | 2 | 1 | 3 | 5 | 4 | 0 | 10 | 9 | 7 | 8 | 6 | 11 | 12 | 13 | 0 | 4 | 5 | 2 | 3 | 1 | 15 | 7 | 13 | 1 | 0 | 6 | 8 | 11 | 12 | 10 | 1 | 16 | 9 | 0 | 14 | 2 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | F602 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F602 | F602 | F601 | F601 | F601 | F601 | F601 | F602 | F601 | F601 | F602 | F601 | F602 | F601 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sender_id | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | F24529 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1444509 | 1444509 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1445903 | 1394663 | 1394663 | 1445903 | 1394663 | 1444509 | 1394663 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | LEM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | LEM | LEM | FRM | FRM | FRM | FRM | FRM | LEM | FRM | FRM | LEM | FRM | LEM | FRM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_naml | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
report_num | 002 | 003 | 001 | 002 | 000 | 001 | 000 | 009 | 008 | 004 | 007 | 010 | 005 | 006 | 016 | 014 | 018 | 017 | 012 | 011 | 015 | 000 | 019 | 013 | 020 | 000 | 000 | 002 | 001 | 003 | 005 | 004 | 000 | 010 | 009 | 007 | 008 | 006 | 011 | 012 | 013 | 000 | 004 | 005 | 002 | 003 | 001 | 015 | 007 | 013 | 001 | 000 | 006 | 008 | 011 | 012 | 010 | 001 | 016 | 009 | 000 | 014 | 002 | 017 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2017-03-21 00:00:00 | 2017-05-23 00:00:00 | 2017-03-16 00:00:00 | 2017-05-10 00:00:00 | 2017-03-16 00:00:00 | 2017-03-16 00:00:00 | 2017-03-16 00:00:00 | 2017-10-18 00:00:00 | 2017-10-11 00:00:00 | 2017-09-06 00:00:00 | 2017-09-26 00:00:00 | 2017-12-19 00:00:00 | 2017-09-12 00:00:00 | 2017-09-26 00:00:00 | 2018-07-03 00:00:00 | 2018-03-14 00:00:00 | 2018-08-09 00:00:00 | 2018-08-09 00:00:00 | 2018-02-02 00:00:00 | 2018-01-31 00:00:00 | 2018-04-25 00:00:00 | 2018-01-30 00:00:00 | 2018-10-09 00:00:00 | 2018-02-02 00:00:00 | 2018-12-26 00:00:00 | 2018-12-26 00:00:00 | 2019-01-14 00:00:00 | 2019-01-19 00:00:00 | 2019-01-14 00:00:00 | 2019-01-19 00:00:00 | 2019-03-28 00:00:00 | 2019-01-19 00:00:00 | 2019-03-14 00:00:00 | 2019-11-07 00:00:00 | 2019-11-07 00:00:00 | 2019-04-25 00:00:00 | 2019-04-25 00:00:00 | 2019-04-16 00:00:00 | 2020-02-20 00:00:00 | 2020-03-16 00:00:00 | 2020-07-22 00:00:00 | 2020-12-30 00:00:00 | 2021-05-19 00:00:00 | 2021-05-24 00:00:00 | 2021-03-11 00:00:00 | 2021-03-16 00:00:00 | 2021-01-25 00:00:00 | 2022-05-12 00:00:00 | 2022-01-19 00:00:00 | 2022-03-22 00:00:00 | 2022-05-03 00:00:00 | 2021-12-27 00:00:00 | 2021-10-06 00:00:00 | 2022-01-24 00:00:00 | 2022-02-25 00:00:00 | 2022-02-25 00:00:00 | 2022-02-04 00:00:00 | 2022-04-27 00:00:00 | 2022-05-12 00:00:00 | 2022-02-02 00:00:00 | 2022-04-26 00:00:00 | 2022-04-27 00:00:00 | 2022-05-03 00:00:00 | 2022-11-02 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ls_beg_yr | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 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 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ls_end_yr | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2020 | 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 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
qual_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 2019-02-01 00:00:00 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 2022-05-01 00:00:00 | 2022-01-01 00:00:00 | None | None | None | None | None | 2022-02-02 00:00:00 | None | None | 2022-02-01 00:00:00 | None | 2022-05-01 00:00:00 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
bus_phon | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | (916) 834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 916-834-6344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | (916) 834-6344 | (916) 834-6344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 916-538-6880 | 9168346344 | 9168346344 | 916-538-6880 | 9168346344 | (916) 834-6344 | 9168346344 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
bus_email | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_date | 2017-03-21 00:00:00 | 2017-05-10 00:00:00 | 2017-03-21 00:00:00 | 2017-05-10 00:00:00 | 2017-03-21 00:00:00 | 2017-04-25 00:00:00 | 2017-03-21 00:00:00 | 2017-10-18 00:00:00 | 2017-09-26 00:00:00 | 2017-09-06 00:00:00 | 2017-09-26 00:00:00 | 2017-12-19 00:00:00 | 2017-09-06 00:00:00 | 2017-09-26 00:00:00 | 2018-04-25 00:00:00 | 2018-03-14 00:00:00 | 2018-08-09 00:00:00 | 2018-08-09 00:00:00 | 2018-02-02 00:00:00 | 2017-01-31 00:00:00 | 2018-04-25 00:00:00 | 2017-01-30 00:00:00 | 2018-08-09 00:00:00 | 2018-02-02 00:00:00 | 2018-12-26 00:00:00 | 2018-12-26 00:00:00 | 2019-02-15 00:00:00 | 2019-02-19 00:00:00 | 2019-02-19 00:00:00 | 2019-02-19 00:00:00 | 2019-03-28 00:00:00 | 2019-02-19 00:00:00 | 2019-03-14 00:00:00 | 2019-11-07 00:00:00 | 2019-11-07 00:00:00 | 2019-04-25 00:00:00 | 2019-04-25 00:00:00 | 2019-04-17 00:00:00 | 2020-02-20 00:00:00 | 2020-03-16 00:00:00 | 2020-07-22 00:00:00 | 2020-12-30 00:00:00 | 2021-05-19 00:00:00 | 2021-05-24 00:00:00 | 2021-03-11 00:00:00 | 2021-03-16 00:00:00 | 2021-01-25 00:00:00 | 2022-05-12 00:00:00 | 2022-01-21 00:00:00 | 2022-03-22 00:00:00 | 2022-05-03 00:00:00 | 2021-12-27 00:00:00 | 2021-10-06 00:00:00 | 2022-01-24 00:00:00 | 2022-02-25 00:00:00 | 2022-02-25 00:00:00 | 2022-02-04 00:00:00 | 2022-04-27 00:00:00 | 2022-05-12 00:00:00 | 2022-02-02 00:00:00 | 2022-02-17 00:00:00 | 2022-04-27 00:00:00 | 2022-07-15 00:00:00 | 2022-11-02 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_naml | Taylor | Price | Taylor | Taylor | Taylor | Taylor | Taylor | Price | Price | Tratten | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | Price | PRICE | Price | Price | Price | Price | Price | Price | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | PRICE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namf | Heather | Jena | Heather | Heather | Heather | Heather | Heather | Jena | Jena | Lea-Ann | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | Jena | JENA | Jena | Jena | Jena | Jena | Jena | Jena | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | JENA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | PRICE | PRICE | None | None | None | None | None | None | None | None | None | None | PRICE | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_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 | JENA | JENA | None | None | None | None | None | None | None | None | None | None | JENA | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_title | None | Principal | None | Bookkeeper | None | Bookkeeper | Bookkeeper | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Principal | Partner | Principal | None | Partner | Partner | Partner | Partner | Partner | Partner | PARTNER | PARTNER | PARTNER | PARTNER | PARTNER | PARTNER | PARTNER | PARTNER | PARTNER | PARTNER | PARTNER | PARTNER | PARTNER | PARTNER | PARTNER | PARTNER | PARTNER | PARTNER | None | PARTNER | PARTNER | None | PARTNER | PARTNER | PARTNER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmt_firm | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | TrattenPrice Consulting | None | TrattenPrice ConsultingLLC | TrattenPrice ConsultingLLC | TrattenPrice ConsultingLLC | TrattenPrice ConsultingLLC | TrattenPrice Consulting | TrattenPrice ConsultingLLC | TrattenPrice Consulting LLC | TrattenPrice Consulting LLC | TrattenPrice Consulting LLC | TrattenPrice Consulting LLC | TrattenPrice Consulting LLC | TrattenPrice Consulting LLC | TrattenPrice Consulting LLC | TrattenPrice Consulting LLC | TrattenPrice Consulting LLC | TrattenPrice Consulting LLC | TrattenPrice Consulting LLC | None | None | TrattenPrice Consulting LLC | TrattenPrice Consulting LLC | TrattenPrice Consulting LLC | TrattenPrice Consulting LLC | TrattenPrice Consulting LLC | None | TrattenPrice Consulting LLC | TrattenPrice Consulting LLC | None | TrattenPrice Consulting LLC | None | TrattenPrice Consulting LLC | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ind_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | X | X | None | None | None | None | None | None | None | None | None | None | X | 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 | 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 | 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 | 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 | 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | CONSERVATION STRATEGY GROUP LLC | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | REGENERATIVE STRATEGIES CONSULTING LLC | REGENERATIVE STRATEGIES CONSULTING LLC | None | None | None | None | None | LEUMER CONSULTING INC. | None | None | LEUMER CONSULTING INC. | None | REGENERATIVE STRATEGIES CONSULTING LLC | 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 | SACRAMENTO | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | WEST SACRAMENTO | WEST SACRAMENTO | None | None | None | None | None | SAN FRANCISCO | None | None | SAN FRANCISCO | None | WEST SACRAMENTO | 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 | CA | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | CA | CA | None | None | None | None | None | CA | None | None | CA | None | CA | 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 | 95814 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 95691 | 95691 | None | None | None | None | None | 94134 | None | None | 94134 | None | 95691 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 |
filer_id | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2440256 | 2466201 | 2427890 | 2507380 | 2457492 | 2545572 | ||||||
effect_dt | 2017-09-26 00:00:00 | 2019-01-01 00:00:00 | 2017-02-02 00:00:00 | 2021-01-01 00:00:00 | 2018-08-01 00:00:00 | 2023-01-01 00:00:00 | ||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||
session_id | 2017 | 2019 | 2017 | 2021 | 2017 | 2023 |
filer_id | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2377889 | 2210791 | 2148952 | 2359779 | 2359779 | 2377889 | 2359779 | 2385624 | 2385960 | 2385986 | 2528385 | 2183593 | 2148952 | 2148952 | 2240886 | 2240904 | 2332876 | 2359779 | 2378117 | 2184278 | 2184278 | 2202212 | 2437878 | 2359779 | 2359779 | 2307194 | 2417972 | 2400782 | 2208795 | 2283648 | 2359779 | 2417983 | 2311918 | 2359779 | 2359779 | 2359779 | 2147424 | 2148952 | 2152335 | 2148952 | 2140610 | 2152052 | 2147424 | 2152094 | 2152335 | 2147424 | 2148952 | 2171425 | 2159238 | 2152335 | 2160730 | 2148952 | 2163038 | 2378117 | 2189548 | 2210791 | 2359779 | 2236539 | 2148952 | 2470848 | 2421356 | 2148952 | 2378117 | 2262638 | 2359779 | 2438042 | 2148952 | 2148952 | 2350120 | 2148952 | 2348121 | 2187878 | 2210791 | 2148952 | 2528385 | 2270182 | 2368488 | 2359779 | 2190963 | 2148952 | 2148952 | 2586560 | 2367490 | 2367495 | 2148952 | 2148952 | 2190963 | 2218340 | 2540917 | 2148952 | 2148952 | 2148952 | 2378117 | 2359779 | 2400782 | 2470848 | 2148952 | 2171425 | 2215090 | 2215091 | 2456700 | 2185706 | 2329641 | 2500074 | 2464702 | 2540917 | 2417972 | 2378117 | 2551075 | 2681041 | 2540917 | 2540917 | 2540917 | 2540917 | 2673559 | 2670984 | 2486749 | 2613173 | 2540917 | 2681041 | 2540917 | 2486749 | 2605642 | 2437878 | 2601252 | 2666256 | 2666257 | 2703155 | 2540917 | 2540917 | 2540917 | 2715289 | 2688881 | 2628062 | 2540917 | 2692615 | 2652593 | 2652594 | 2652595 | 2652626 | 2623078 | 2684472 | 2540917 | 2551075 | 2679596 | 2580803 | 2670984 | 2644750 | 2540917 | 2540917 | 2540917 | 2580803 | 2540917 | 2605856 | 2613444 | 2582108 | 2681041 | 2648029 | 2748193 | 2540917 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 238 | 232 | 233 | 237 | 237 | 237 | 241 | None | None | None | 243 | None | 233 | 235 | None | None | None | 240 | 237 | None | None | None | 240 | 241 | 237 | None | 239 | 238 | 233 | None | 243 | 239 | 235 | 240 | 237 | 237 | 229 | 229 | 229 | 229 | None | None | 229 | None | 229 | 229 | 230 | 230 | None | 229 | None | 230 | None | 237 | None | 232 | 238 | 233 | 236 | 241 | None | 231 | 237 | None | 238 | 240 | 232 | 232 | 236 | 234 | None | None | 232 | 233 | 243 | 234 | 237 | 237 | 231 | 236 | 235 | None | None | None | 231 | 231 | 231 | None | 244 | 232 | 233 | 231 | 238 | 238 | 238 | 241 | 235 | 230 | None | None | None | None | 236 | None | None | 249 | 239 | 237 | 244 | 248 | 246 | 250 | 245 | 249 | 249 | 250 | 242 | None | 245 | 250 | 250 | 242 | None | 240 | 246 | None | None | 250 | 249 | 246 | 249 | None | None | None | 249 | None | None | None | None | None | 247 | None | 245 | 244 | None | 245 | 250 | 248 | 249 | 250 | 248 | 245 | 249 | None | None | None | 250 | None | 251 | 252 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F625 | F601 | F601 | F601 | F635 | F601 | F605 | F605 | F605 | F625 | F605 | F601 | F601 | F605 | F605 | F605 | F601 | F625 | F605 | F605 | F605 | F625 | F601 | F601 | F605 | F625 | F625 | F601 | F605 | F601 | F635 | F625 | F601 | F601 | F601 | F601 | F601 | F625 | F601 | F601 | F605 | F601 | F605 | F625 | F601 | F601 | F625 | F605 | F625 | F605 | F601 | F605 | F625 | F605 | F625 | F601 | F625 | F601 | F625 | F605 | F601 | F625 | F605 | F601 | F635 | F601 | F601 | F625 | F601 | F601 | F605 | F625 | F601 | F625 | F625 | F602 | F601 | F625 | F601 | F601 | F605 | F605 | F605 | F601 | F601 | F625 | F605 | F601 | F601 | F601 | F601 | F625 | F601 | F625 | F625 | F601 | F625 | F605 | F605 | F605 | F605 | F601 | F605 | F605 | F601 | F625 | F625 | F625 | F602 | F601 | F601 | F601 | F601 | F625 | F602 | F625 | F605 | F601 | F602 | F601 | F625 | F605 | F625 | F625 | F605 | F605 | F625 | F601 | F601 | F601 | F602 | F602 | F605 | F601 | F605 | F605 | F605 | F605 | F605 | F625 | F605 | F601 | F625 | F602 | F625 | F602 | F625 | F601 | F601 | F601 | F625 | F601 | F605 | F605 | F601 | F602 | F602 | F625 | F601 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 1 | 1 | 12 | 2 | 3 | 0 | 12 | 0 | 0 | 0 | 1 | 0 | 11 | 16 | 0 | 0 | 0 | 10 | 0 | 0 | 1 | 0 | 0 | 11 | 4 | 0 | 0 | 0 | 0 | 0 | 13 | 0 | 0 | 9 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 2 | 0 | 0 | 2 | 0 | 3 | 0 | 2 | 0 | 2 | 7 | 0 | 19 | 0 | 0 | 7 | 3 | 0 | 6 | 0 | 9 | 10 | 0 | 15 | 0 | 0 | 0 | 13 | 0 | 0 | 0 | 5 | 1 | 20 | 18 | 0 | 0 | 0 | 4 | 5 | 0 | 0 | 0 | 8 | 14 | 6 | 1 | 8 | 1 | 1 | 17 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 1 | 4 | 1 | 0 | 5 | 14 | 1 | 9 | 0 | 0 | 0 | 0 | 2 | 1 | 16 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 11 | 4 | 7 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 1 | 0 | 10 | 15 | 6 | 0 | 13 | 0 | 0 | 0 | 2 | 0 | 0 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2019-07-31 00:00:00 | 2018-02-02 00:00:00 | 2018-02-02 00:00:00 | 2019-02-19 00:00:00 | 2019-02-19 00:00:00 | 2019-04-26 00:00:00 | 2020-03-27 00:00:00 | 2019-04-10 00:00:00 | 2019-04-26 00:00:00 | 2019-04-23 00:00:00 | 2021-03-31 00:00:00 | 2017-09-07 00:00:00 | 2018-01-31 00:00:00 | 2018-07-03 00:00:00 | 2018-04-26 00:00:00 | 2018-04-26 00:00:00 | 2018-12-28 00:00:00 | 2019-11-07 00:00:00 | 2019-04-28 00:00:00 | 2017-09-13 00:00:00 | 2017-09-14 00:00:00 | 2018-01-09 00:00:00 | 2020-01-29 00:00:00 | 2020-02-20 00:00:00 | 2019-02-19 00:00:00 | 2018-10-10 00:00:00 | 2019-10-30 00:00:00 | 2019-08-01 00:00:00 | 2018-01-30 00:00:00 | 2018-08-09 00:00:00 | 2020-07-22 00:00:00 | 2019-10-30 00:00:00 | 2018-10-24 00:00:00 | 2019-11-07 00:00:00 | 2019-02-15 00:00:00 | 2019-02-19 00:00:00 | 2017-03-21 00:00:00 | 2017-04-25 00:00:00 | 2017-04-21 00:00:00 | 2017-03-30 00:00:00 | 2017-02-10 00:00:00 | 2017-03-21 00:00:00 | 2017-03-21 00:00:00 | 2017-03-21 00:00:00 | 2017-04-21 00:00:00 | 2017-03-21 00:00:00 | 2017-05-10 00:00:00 | 2017-07-25 00:00:00 | 2017-04-27 00:00:00 | 2017-05-24 00:00:00 | 2017-05-10 00:00:00 | 2017-05-24 00:00:00 | 2017-05-24 00:00:00 | 2019-08-01 00:00:00 | 2017-10-20 00:00:00 | 2018-04-25 00:00:00 | 2019-04-25 00:00:00 | 2018-04-25 00:00:00 | 2018-10-09 00:00:00 | 2020-04-30 00:00:00 | 2019-11-08 00:00:00 | 2017-09-26 00:00:00 | 2020-11-04 00:00:00 | 2018-07-03 00:00:00 | 2019-04-17 00:00:00 | 2020-01-29 00:00:00 | 2017-10-18 00:00:00 | 2017-12-19 00:00:00 | 2019-01-31 00:00:00 | 2018-04-25 00:00:00 | 2018-12-28 00:00:00 | 2017-10-13 00:00:00 | 2018-01-31 00:00:00 | 2018-02-02 00:00:00 | 2020-10-30 00:00:00 | 2018-07-26 00:00:00 | 2019-03-22 00:00:00 | 2019-03-28 00:00:00 | 2017-12-20 00:00:00 | 2018-12-26 00:00:00 | 2018-08-09 00:00:00 | 2021-01-28 00:00:00 | 2019-02-19 00:00:00 | 2019-02-19 00:00:00 | 2017-09-06 00:00:00 | 2017-09-12 00:00:00 | 2017-10-26 00:00:00 | 2018-02-21 00:00:00 | 2020-12-30 00:00:00 | 2017-10-11 00:00:00 | 2018-03-13 00:00:00 | 2017-09-26 00:00:00 | 2019-07-31 00:00:00 | 2019-04-25 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | 2018-08-09 00:00:00 | 2017-10-26 00:00:00 | 2018-02-13 00:00:00 | 2018-02-13 00:00:00 | 2020-02-21 00:00:00 | 2017-09-27 00:00:00 | 2018-12-26 00:00:00 | 2020-08-03 00:00:00 | 2020-03-30 00:00:00 | 2022-02-25 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | 2022-05-10 00:00:00 | 2021-05-24 00:00:00 | 2022-04-27 00:00:00 | 2021-01-25 00:00:00 | 2022-02-02 00:00:00 | 2022-04-28 00:00:00 | 2022-04-26 00:00:00 | 2020-07-31 00:00:00 | 2021-05-26 00:00:00 | 2021-03-11 00:00:00 | 2022-06-02 00:00:00 | 2022-05-12 00:00:00 | 2021-03-31 00:00:00 | 2021-03-24 00:00:00 | 2021-04-01 00:00:00 | 2021-07-30 00:00:00 | 2022-04-06 00:00:00 | 2022-04-06 00:00:00 | 2022-07-28 00:00:00 | 2022-02-25 00:00:00 | 2021-05-19 00:00:00 | 2022-01-21 00:00:00 | 2022-08-22 00:00:00 | 2022-05-20 00:00:00 | 2021-10-13 00:00:00 | 2022-01-24 00:00:00 | 2022-05-26 00:00:00 | 2022-02-14 00:00:00 | 2022-02-14 00:00:00 | 2022-02-14 00:00:00 | 2022-02-14 00:00:00 | 2021-10-29 00:00:00 | 2022-05-06 00:00:00 | 2021-03-18 00:00:00 | 2021-01-29 00:00:00 | 2022-04-07 00:00:00 | 2022-02-24 00:00:00 | 2022-05-11 00:00:00 | 2022-01-31 00:00:00 | 2022-02-04 00:00:00 | 2022-05-12 00:00:00 | 2021-10-06 00:00:00 | 2021-04-30 00:00:00 | 2022-03-22 00:00:00 | 2021-03-22 00:00:00 | 2021-06-01 00:00:00 | 2021-01-04 00:00:00 | 2022-08-22 00:00:00 | 2022-01-24 00:00:00 | 2022-10-31 00:00:00 | 2022-11-02 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10002 | 10002 | 10002 | 10002 | 10002 | 10001 | 10002 | 10005 | 10005 | 10005 | 10002 | 10006 | 10002 | 10002 | 10005 | 10005 | 10005 | 10002 | 10001 | 10006 | 10006 | 10006 | 10001 | 10002 | 10002 | 10006 | 10001 | 10001 | 10001 | 10006 | 10002 | 10001 | 10001 | 10002 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10005 | 10005 | 10002 | 10005 | 10002 | 10002 | 10002 | 10001 | 10005 | 10002 | 10005 | 10002 | 10005 | 10002 | 10005 | 10002 | 10002 | 10001 | 10002 | 10001 | 10005 | 10002 | 10002 | 10006 | 10002 | 10001 | 10002 | 10002 | 10001 | 10002 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10002 | 10002 | 10002 | 10002 | 10005 | 10005 | 10005 | 10002 | 10002 | 10001 | 10006 | 10001 | 10002 | 10002 | 10002 | 10002 | 10002 | 10002 | 10002 | 10002 | 10002 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10002 | 10002 | 10002 | 10002 | 10001 | 10002 | 10002 | 10002 | 10002 | 10001 | 10001 | 10001 | 10005 | 10002 | 10002 | 10002 | 10002 | 10005 | 10002 | 10001 | 10005 | 10005 | 10001 | 10002 | 10002 | 10002 | 10005 | 10005 | 10002 | 10002 | 10002 | 10002 | 10002 | 10002 | 10002 | 10001 | 10005 | 10002 | 10001 | 10005 | 10002 | 10002 | 10001 | 10002 | 10002 | 10002 | 10001 | 10002 | 10002 | 10002 | 10005 | 10002 | 10005 | 10001 | 10002 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2019 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2017 | 2017 | 2021 | 2019 | 2019 | 2017 | 2017 | 2017 | 2017 | 2021 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2021 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2019 | 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 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | AGLADNEY | AGLADNEY | GPEREZ | CAFILER | CAFILER | VUKSTINA | GPEREZ | SARRIAGA | SARRIAGA | SARRIAGA | CAFILER | YRODRIGU | GPEREZ | YRODRIGU | GPEREZ | GPEREZ | GPEREZ | GPEREZ | AGLADNEY | YRODRIGU | YRODRIGU | YRODRIGU | AGLADNEY | GPEREZ | CAFILER | YRODRIGU | AGLADNEY | AGLADNEY | GPEREZ | YRODRIGU | CAFILER | SUSHAKOV | AGLADNEY | GPEREZ | CAFILER | CAFILER | GPEREZ | GPEREZ | AGLADNEY | GPEREZ | PBANFORD | GPEREZ | GPEREZ | GPEREZ | AGLADNEY | GPEREZ | GPEREZ | AGLADNEY | GPEREZ | AGLADNEY | GPEREZ | GPEREZ | GPEREZ | AGLADNEY | GPEREZ | AGLADNEY | SARRIAGA | AGLADNEY | YRODRIGU | MKIRKHAM | GPEREZ | GPEREZ | CAFILER | YRODRIGU | SARRIAGA | MMERCHANT | GPEREZ | YRODRIGU | AGLADNEY | GPEREZ | SARRIAGA | GPEREZ | AGLADNEY | GPEREZ | MKIRKHAM | AGLADNEY | CAFILER | CAFILER | AGLADNEY | GPEREZ | YRODRIGU | SARRIAGA | SARRIAGA | SARRIAGA | YRODRIGU | YRODRIGU | AGLADNEY | YRODRIGU | MMERCHANT | GPEREZ | GPEREZ | GPEREZ | AGLADNEY | SARRIAGA | CAFILER | CAFILER | YRODRIGU | AGLADNEY | GPEREZ | GPEREZ | GPEREZ | GPEREZ | SARRIAGA | SARRIAGA | GPEREZ | SARRIAGA | CAFILER | CAFILER | CAFILER | SARRIAGA | SARRIAGA | CVANLIEW | SARRIAGA | CVANLIEW | CAFILER | CVANLIEW | MKIRKHAM | SARRIAGA | SARRIAGA | CAFILER | SARRIAGA | CAFILER | SARRIAGA | CAFILER | CHATRIDGE | SARRIAGA | SARRIAGA | CAFILER | CAFILER | SARRIAGA | CVANLIEW | CVANLIEW | SARRIAGA | MMERCHANT | CVANLIEW | MMERCHANT | CVANLIEW | CVANLIEW | CVANLIEW | CVANLIEW | CHATRIDGE | SARRIAGA | CAFILER | MKIRKHAM | CVANLIEW | CAFILER | CAFILER | MKIRKHAM | CVANLIEW | SARRIAGA | MMERCHANT | MKIRKHAM | SARRIAGA | CVANLIEW | MKIRKHAM | MMERCHANT | CVANLIEW | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 2019-04-01 00:00:00 | 2017-10-01 00:00:00 | 2018-02-02 00:00:00 | 2019-01-19 00:00:00 | 2019-01-19 00:00:00 | 2019-01-01 00:00:00 | 2020-03-16 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-07-01 00:00:00 | 1900-01-01 00:00:00 | 2018-01-31 00:00:00 | 2018-07-03 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-11-07 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-10-01 00:00:00 | 2020-02-20 00:00:00 | 2019-01-19 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-04-01 00:00:00 | 2018-01-30 00:00:00 | 1900-01-01 00:00:00 | 2020-07-22 00:00:00 | 2019-07-01 00:00:00 | 2018-07-01 00:00:00 | 2019-11-07 00:00:00 | 2019-01-14 00:00:00 | 2019-01-14 00:00:00 | 2017-03-16 00:00:00 | 2017-03-16 00:00:00 | 2017-01-01 00:00:00 | 2017-03-16 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-03-21 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-03-16 00:00:00 | 2017-05-10 00:00:00 | 2017-04-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-05-23 00:00:00 | 1900-01-01 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-10-01 00:00:00 | 2019-04-25 00:00:00 | 2018-01-01 00:00:00 | 2018-10-09 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-09-26 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-16 00:00:00 | 2019-10-01 00:00:00 | 2017-10-18 00:00:00 | 2017-12-19 00:00:00 | 2018-10-01 00:00:00 | 2018-04-25 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-10-01 00:00:00 | 2018-02-02 00:00:00 | 2020-07-01 00:00:00 | 2018-04-01 00:00:00 | 2019-03-14 00:00:00 | 2019-03-28 00:00:00 | 2017-07-01 00:00:00 | 2018-12-26 00:00:00 | 2018-08-09 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-09-06 00:00:00 | 2017-09-12 00:00:00 | 2017-07-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-30 00:00:00 | 2017-10-11 00:00:00 | 2018-03-14 00:00:00 | 2017-09-26 00:00:00 | 2019-04-01 00:00:00 | 2019-04-25 00:00:00 | 2019-04-01 00:00:00 | 2020-01-01 00:00:00 | 2018-08-09 00:00:00 | 2017-04-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 | 2018-12-26 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-02-25 00:00:00 | 2019-07-01 00:00:00 | 2019-01-01 00:00:00 | 2020-10-01 00:00:00 | 2021-12-27 00:00:00 | 2021-05-24 00:00:00 | 2022-04-27 00:00:00 | 2021-01-25 00:00:00 | 2022-02-02 00:00:00 | 2022-01-01 00:00:00 | 2022-04-26 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-03-11 00:00:00 | 2022-05-03 00:00:00 | 2022-05-12 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2019-10-01 00:00:00 | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-02-25 00:00:00 | 2021-05-19 00:00:00 | 2022-01-19 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-01-24 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 | 2021-07-01 00:00:00 | 1900-01-01 00:00:00 | 2021-03-16 00:00:00 | 2020-10-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-27 00:00:00 | 2021-10-01 00:00:00 | 2022-02-04 00:00:00 | 2022-05-12 00:00:00 | 2021-10-06 00:00:00 | 2021-01-01 00:00:00 | 2022-03-22 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-05-03 00:00:00 | 1900-01-01 00:00:00 | 2022-07-01 00:00:00 | 2022-11-02 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 2019-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-02-02 00:00:00 | 2019-01-19 00:00:00 | 2019-01-19 00:00:00 | 2019-03-31 00:00:00 | 2020-03-16 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-09-30 00:00:00 | 1900-01-01 00:00:00 | 2018-01-31 00:00:00 | 2018-07-03 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-11-07 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-12-31 00:00:00 | 2020-02-20 00:00:00 | 2019-01-19 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2019-06-30 00:00:00 | 2018-01-30 00:00:00 | 1900-01-01 00:00:00 | 2020-07-22 00:00:00 | 2019-09-30 00:00:00 | 2018-09-30 00:00:00 | 2019-11-07 00:00:00 | 2019-01-14 00:00:00 | 2019-01-14 00:00:00 | 2017-03-16 00:00:00 | 2017-03-16 00:00:00 | 2017-03-31 00:00:00 | 2017-03-16 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-03-21 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2017-03-16 00:00:00 | 2017-05-10 00:00:00 | 2017-06-30 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-05-23 00:00:00 | 1900-01-01 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-12-31 00:00:00 | 2019-04-25 00:00:00 | 2018-03-31 00:00:00 | 2018-10-09 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-09-26 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-04-16 00:00:00 | 2019-12-31 00:00:00 | 2017-10-18 00:00:00 | 2017-12-19 00:00:00 | 2018-12-31 00:00:00 | 2018-04-25 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-12-31 00:00:00 | 2018-02-02 00:00:00 | 2020-09-30 00:00:00 | 2018-06-30 00:00:00 | 2019-03-14 00:00:00 | 2019-03-28 00:00:00 | 2017-09-30 00:00:00 | 2018-12-26 00:00:00 | 2018-08-09 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-09-06 00:00:00 | 2017-09-12 00:00:00 | 2017-09-30 00:00:00 | 1900-01-01 00:00:00 | 2020-12-30 00:00:00 | 2017-10-11 00:00:00 | 2018-03-14 00:00:00 | 2017-09-26 00:00:00 | 2019-06-30 00:00:00 | 2019-04-25 00:00:00 | 2019-06-30 00:00:00 | 2020-03-31 00:00:00 | 2018-08-09 00:00:00 | 2017-06-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 | 2018-12-26 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-02-25 00:00:00 | 2019-09-30 00:00:00 | 2019-03-31 00:00:00 | 2020-12-21 00:00:00 | 2021-12-27 00:00:00 | 2021-05-24 00:00:00 | 2022-04-27 00:00:00 | 2021-01-25 00:00:00 | 2022-02-02 00:00:00 | 2022-03-31 00:00:00 | 2022-04-26 00:00:00 | 2020-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-03-11 00:00:00 | 2022-05-03 00:00:00 | 2022-05-12 00:00:00 | 2020-06-30 00:00:00 | 1900-01-01 00:00:00 | 2019-12-31 00:00:00 | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-06-30 00:00:00 | 2022-02-25 00:00:00 | 2021-05-19 00:00:00 | 2022-01-19 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-01-24 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 | 2021-09-30 00:00:00 | 1900-01-01 00:00:00 | 2021-03-16 00:00:00 | 2020-12-21 00:00:00 | 1900-01-01 00:00:00 | 2021-03-31 00:00:00 | 2022-04-27 00:00:00 | 2021-12-31 00:00:00 | 2022-02-04 00:00:00 | 2022-05-12 00:00:00 | 2021-10-06 00:00:00 | 2021-03-31 00:00:00 | 2022-03-22 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-05-03 00:00:00 | 1900-01-01 00:00:00 | 2022-09-30 00:00:00 | 2022-11-02 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | 22001 | None | 22001 | 22001 | None | None | None | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | None | None | 22001 | None | None | None | None | None | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | 22001 | None | 22001 | 22001 |
filer_id | 1394663 | 1394663 | 1394663 | 1394663 | ||||
---|---|---|---|---|---|---|---|---|
filer_type | 3 | 3 | 3 | 3 | ||||
active | Y | Y | Y | N | ||||
race | 0 | None | None | None | ||||
session_id | 2017 | 2021 | 2019 | 2023 | ||||
category | 0 | None | None | None | ||||
category_type | 0 | None | None | None | ||||
sub_category | 0 | None | None | None | ||||
effect_dt | 2017-02-02 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||
sub_category_type | 0 | None | None | None | ||||
election_type | 0 | None | None | None | ||||
sub_category_a | None | None | None | None | ||||
nyq_dt | None | None | None | None | ||||
party_cd | 0 | None | None | None | ||||
county_cd | 0 | None | None | None | ||||
district_cd | 0 | None | None | None |
filer_id | 1394663 | |
---|---|---|
xref_id | 1394663 | |
effect_dt | 2017-02-22 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | ||||||||||||||||||||||||||||||||||||
filer_type | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | ||||||||||||||||||||||||||||||||||||
status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | ||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 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 | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE | TRATTENPRICE | TRATTENPRICE | TRATTENPRICE | TRATTENPRICE | TRATTENPRICE | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 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 | 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 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||
phon | 9167696820 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9167696820 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9167696820 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9167696820 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9167696820 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9167696820 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | 9168346344 | ||||||||||||||||||||||||||||||||||||
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 |
filer_id | 1394663 |
---|
filer_id | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 3 | 0 | 7 | 4 | 5 | 6 | 12 | 10 | 8 | 9 | 11 | 16 | 14 | 13 | 15 | 20 | 21 | 22 | 18 | 19 | 17 | |||||||||||||||||||||||
session_id | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||
log_dt | 2017-02-10 00:00:00 | 2017-02-10 00:00:00 | 2017-02-10 00:00:00 | 2017-03-16 00:00:00 | 2017-10-20 00:00:00 | 2017-05-24 00:00:00 | 2017-09-14 00:00:00 | 2017-10-20 00:00:00 | 2018-01-09 00:00:00 | 2018-02-21 00:00:00 | 2018-02-13 00:00:00 | 2018-02-13 00:00:00 | 2018-04-26 00:00:00 | 2020-03-30 00:00:00 | 2018-07-03 00:00:00 | 2018-04-26 00:00:00 | 2018-12-28 00:00:00 | 2021-06-01 00:00:00 | 2021-10-13 00:00:00 | 2022-05-26 00:00:00 | 2021-01-04 00:00:00 | 2021-01-04 00:00:00 | 2021-01-04 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 | |||||||||||||||||||||||
correction_flg | None | None | None | None | Y | Y | Y | Y | Y | Y | Y | Y | Y | None | Y | Y | None | None | None | None | None | None | None | |||||||||||||||||||||||
action | SET ACTIVE | SET ACTIVE | SET ACTIVE | ADDED | DELETED | ADDED | ADDED | DELETED | ADDED | ADDED | ADDED | ADDED | ADDED | DELETED | ADDED | ADDED | DELETED | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | |||||||||||||||||||||||
attribute_changed | EMPLOYER | LOBBYIST | LOBBYISTS | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | CLIENT | EMPLOYER | EMPLOYER | 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 | |||||||||||||||||||||||
interests | 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 | TRATTENPRICE | TRATTENPRICE | TRATTENPRICE | TRATTENPRICE | TRATTENPRICE CONSULTING | TRATTENPRICE | TRATTENPRICE | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | TRATTENPRICE CONSULTING LLC | |||||||||||||||||||||||
filer_city | None | None | None | None | None | None | SACRAMENTO | None | SACRAMENTO | SACRAMENTO | None | None | SACRAMENTO | None | SACRAMENTO | SACRAMENTO | None | None | None | None | None | None | None | |||||||||||||||||||||||
filer_st | None | None | None | None | None | None | CA | None | CA | CA | None | None | CA | None | CA | CA | None | None | None | None | None | None | None | |||||||||||||||||||||||
filer_zip | None | None | None | None | None | None | 95814 | None | 95814 | 95814 | None | None | 95814 | None | 95814 | 95814 | None | None | None | None | None | None | None | |||||||||||||||||||||||
filer_phone | None | None | None | None | None | None | 9168346344 | None | 9168346344 | 9168346344 | None | None | 9168346344 | None | 9168346344 | 9168346344 | None | None | None | None | None | None | None | |||||||||||||||||||||||
entity_type | 3 | 2 | 4 | 4 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||||||||||||||
entity_name | None | CONSUMER ATTORNEYS OF CALIFORNIA | TRATTEN, LEA-ANN | PRICE, JENA E. | VOTE SOLAR | CENTER FOR RESPONSIBLE LENDING | CLEAN POWER CAMPAIGN | CENTER FOR RESPONSIBLE LENDING | VOTE SOLAR | BLACK WOMEN FOR WELLNESS ACTION PROJECT | ENVIRONMENTAL DEFENSE FUND, INCORPORATED | CENTER FOR COMMUNITY ACTION AND ENVIRONMENTAL JUSTICE | NEXTGEN CLIMATE ACTION | CONSERVATION STRATEGY GROUP | CENTER FOR COMMUNITY ACTION & ENVIRONMENTAL JUSTICE | WATER FOUNDATION | CLEAN POWER CAMPAIGN | ASIAN PACIFIC ENVIRONMENTAL NETWORK | DEWEY SQUARE GROUP | SIERRA FUND; THE | WATER FOUNDATION | NEXTGEN CLIMATE AMERCIA, INC. | CONSUMER ATTORNEYS OF CALIFORNIA | |||||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | |||||||||||||||||||||||
entity_id | 0 | 1146762 | 1149037 | 1334279 | 1395525 | 1303345 | None | 1303345 | None | None | 1144706 | 1396423 | None | 1363291 | None | None | 1144107 | 1438370 | 1244123 | 1245790 | 1393794 | 1435198 | 1146762 | |||||||||||||||||||||||
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 | |||||||||||||||||||||||
effect_dt | 2017-02-02 00:00:00 | 2017-02-02 00:00:00 | 2017-02-02 00:00:00 | 2017-02-01 00:00:00 | 2017-09-15 00:00:00 | 2017-04-01 00:00:00 | 2017-07-01 00:00:00 | 2017-09-15 00:00:00 | 2018-01-01 00:00:00 | 2018-01-01 00:00:00 | 2017-11-15 00:00:00 | 2018-01-01 00:00:00 | 2018-02-26 00:00:00 | 2020-03-16 00:00:00 | 2018-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-09-30 00:00:00 | 2021-04-01 00:00:00 | 2021-09-22 00:00:00 | 2022-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 |
filer_id | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | 1394663 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 2148952_0.cal | 2148952_1.cal | 2147424_1.cal | 53171.cal | 53180.cal | 53220.cal | 2147424_2.cal | 2152335_0.cal | 2152335_1.cal | 2147424_0.cal | 2152335_2.cal | 2148952_3.cal | 2148952_2.cal | 2171425_0.cal | 413208.cal | 2210791_1.cal | 2148952_12.cal | 2359779_2.cal | 2359779_3.cal | 2359779_8.cal | 29303.cal | 379423.cal | 365506.cal | 377039.cal | 2148952_16.cal | 2148952_11.cal | 511057.cal | 380202.cal | 380858.cal | 2359779_10.cal | 2359779_4.cal | 121392.cal | 73004.cal | 73039.cal | 73066.cal | 2208795_0.cal | 29507.cal | 325306.cal | 2311918_0.cal | 25274.cal | 38995.cal | 39091.cal | 2359779_0.cal | 2359779_1.cal | 399485.cal | 401971.cal | 2210791_2.cal | 129460.cal | 73340.cal | 73387.cal | 2377889_0.cal | 28616.cal | 30533.cal | 32911.cal | 33254.cal | 2377889_1.cal | 378349.cal | 2148952_19.cal | 2148952_7.cal | 38732.cal | 38866.cal | 2236539_0.cal | 2148952_15.cal | 2148952_9.cal | 25295.cal | 2359779_12.cal | 321002.cal | 2359779_13.cal | 2148952_10.cal | 33181.cal | 73319.cal | 2270182_0.cal | 2190963_1.cal | 2148952_13.cal | 2210791_0.cal | 382996.cal | 2359779_7.cal | 49765.cal | 413267.cal | 2359779_11.cal | 2148952_18.cal | 2148952_20.cal | 126481.cal | 49775.cal | 2359779_9.cal | 2438042_0.cal | 2148952_4.cal | 2148952_5.cal | 2190963_0.cal | 92318.cal | 73238.cal | 2359779_6.cal | 399366.cal | 399421.cal | 2148952_8.cal | 126580.cal | 2359779_5.cal | 2148952_14.cal | 30883.cal | 321374.cal | 2148952_6.cal | 413043.cal | 413066.cal | 383714.cal | 2148952_17.cal | 380460.cal | 2171425_1.cal | 29031.cal | 25355.cal | 2417983_0.cal | 2329641_0.cal | 28487.cal | 2540917_4.cal | 2540917_17.cal | 2540917_2.cal | 2540917_1.cal | 2540917_16.cal | 408116.cal | 2540917_7.cal | 84828.cal | 84897.cal | 2540917_11.cal | 2540917_0.cal | 2540917_15.cal | 2540917_13.cal | 180515.cal | 406782.cal | 2540917_12.cal | 2540917_14.cal | 2540917_9.cal | 2540917_3.cal | 9551.cal | 2540917_8.cal | 2540917_5.cal | 2540917_10.cal | 168385.cal | 2540917_6.cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2017-03-30 00:00:00 | 2017-04-25 00:00:00 | 2017-03-21 00:00:00 | 2017-03-21 00:00:00 | 2017-03-21 00:00:00 | 2017-03-21 00:00:00 | 2017-03-21 00:00:00 | 2017-04-21 00:00:00 | 2017-04-21 00:00:00 | 2017-03-21 00:00:00 | 2017-05-24 00:00:00 | 2017-05-24 00:00:00 | 2017-05-10 00:00:00 | 2017-07-25 00:00:00 | 2018-04-25 00:00:00 | 2018-02-02 00:00:00 | 2018-02-02 00:00:00 | 2019-02-19 00:00:00 | 2019-02-19 00:00:00 | 2019-04-25 00:00:00 | 2018-01-30 00:00:00 | 2019-07-31 00:00:00 | 2019-07-31 00:00:00 | 2019-07-31 00:00:00 | 2018-07-03 00:00:00 | 2018-01-31 00:00:00 | 2018-12-12 00:00:00 | 2019-07-31 00:00:00 | 2019-07-31 00:00:00 | 2019-11-07 00:00:00 | 2019-02-19 00:00:00 | 2018-07-03 00:00:00 | 2019-02-08 00:00:00 | 2019-02-08 00:00:00 | 2019-02-08 00:00:00 | 2018-01-30 00:00:00 | 2018-01-30 00:00:00 | 2018-02-02 00:00:00 | 2018-10-24 00:00:00 | 2018-08-09 00:00:00 | 2018-01-30 00:00:00 | 2018-01-30 00:00:00 | 2019-02-15 00:00:00 | 2019-02-19 00:00:00 | 2019-04-26 00:00:00 | 2019-04-26 00:00:00 | 2018-04-25 00:00:00 | 2019-01-30 00:00:00 | 2019-02-08 00:00:00 | 2019-02-08 00:00:00 | 2019-04-26 00:00:00 | 2018-01-30 00:00:00 | 2018-01-30 00:00:00 | 2018-01-30 00:00:00 | 2018-01-30 00:00:00 | 2019-07-31 00:00:00 | 2019-07-31 00:00:00 | 2018-10-09 00:00:00 | 2017-09-26 00:00:00 | 2018-01-30 00:00:00 | 2018-01-30 00:00:00 | 2018-04-25 00:00:00 | 2018-04-25 00:00:00 | 2017-10-18 00:00:00 | 2018-08-09 00:00:00 | 2020-03-27 00:00:00 | 2020-04-23 00:00:00 | 2020-07-22 00:00:00 | 2017-12-19 00:00:00 | 2018-01-30 00:00:00 | 2019-02-08 00:00:00 | 2018-07-26 00:00:00 | 2017-12-20 00:00:00 | 2018-02-02 00:00:00 | 2018-01-31 00:00:00 | 2019-07-31 00:00:00 | 2019-04-25 00:00:00 | 2019-08-01 00:00:00 | 2018-04-25 00:00:00 | 2020-02-20 00:00:00 | 2018-08-09 00:00:00 | 2018-12-26 00:00:00 | 2019-02-12 00:00:00 | 2019-08-01 00:00:00 | 2019-11-07 00:00:00 | 2020-01-29 00:00:00 | 2017-09-06 00:00:00 | 2017-09-12 00:00:00 | 2017-10-26 00:00:00 | 2018-01-31 00:00:00 | 2019-02-08 00:00:00 | 2019-04-17 00:00:00 | 2019-04-26 00:00:00 | 2019-04-26 00:00:00 | 2017-10-11 00:00:00 | 2019-02-12 00:00:00 | 2019-03-28 00:00:00 | 2018-03-13 00:00:00 | 2018-01-30 00:00:00 | 2020-04-23 00:00:00 | 2017-09-26 00:00:00 | 2018-04-25 00:00:00 | 2018-04-25 00:00:00 | 2019-07-31 00:00:00 | 2018-08-09 00:00:00 | 2019-07-31 00:00:00 | 2017-10-26 00:00:00 | 2018-01-30 00:00:00 | 2018-08-09 00:00:00 | 2019-10-30 00:00:00 | 2018-12-26 00:00:00 | 2018-01-30 00:00:00 | 2021-05-19 00:00:00 | 2022-11-02 00:00:00 | 2021-03-11 00:00:00 | 2021-01-25 00:00:00 | 2022-05-12 00:00:00 | 2021-07-30 00:00:00 | 2022-01-21 00:00:00 | 2022-06-02 00:00:00 | 2022-06-02 00:00:00 | 2022-02-25 00:00:00 | 2020-12-30 00:00:00 | 2022-05-12 00:00:00 | 2022-03-22 00:00:00 | 2021-04-08 00:00:00 | 2021-07-30 00:00:00 | 2022-02-25 00:00:00 | 2022-04-27 00:00:00 | 2022-02-02 00:00:00 | 2021-03-18 00:00:00 | 2022-04-06 00:00:00 | 2022-01-24 00:00:00 | 2021-05-24 00:00:00 | 2022-02-04 00:00:00 | 2021-10-29 00:00:00 | 2021-10-06 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/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/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /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/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/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/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/temp | /cafiler/disclose/ca99/temp | /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/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /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 | /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/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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 2148952 | 2148952 | 2147424 | None | None | None | 2147424 | 2152335 | 2152335 | 2147424 | 2152335 | 2148952 | 2148952 | 2171425 | None | 2210791 | 2148952 | 2359779 | 2359779 | 2359779 | None | None | None | None | 2148952 | 2148952 | None | None | None | 2359779 | 2359779 | None | None | None | None | 2208795 | None | None | 2311918 | None | None | None | 2359779 | 2359779 | None | None | 2210791 | None | None | None | 2377889 | None | None | None | None | 2377889 | None | 2148952 | 2148952 | None | None | 2236539 | 2148952 | 2148952 | None | 2359779 | None | 2359779 | 2148952 | None | None | 2270182 | 2190963 | 2148952 | 2210791 | None | 2359779 | None | None | 2359779 | 2148952 | 2148952 | None | None | 2359779 | 2438042 | 2148952 | 2148952 | 2190963 | None | None | 2359779 | None | None | 2148952 | None | 2359779 | 2148952 | None | None | 2148952 | None | None | None | 2148952 | None | 2171425 | None | None | 2417983 | 2329641 | None | 2540917 | 2540917 | 2540917 | 2540917 | 2540917 | None | 2540917 | None | None | 2540917 | 2540917 | 2540917 | 2540917 | None | None | 2540917 | 2540917 | 2540917 | 2540917 | None | 2540917 | 2540917 | 2540917 | None | 2540917 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F601 | F601 | F601 | None | None | None | F601 | F625 | F625 | F601 | F625 | F601 | F601 | F625 | None | F625 | F601 | F601 | F601 | F601 | None | None | None | None | F601 | F601 | None | None | None | F601 | F601 | None | None | None | None | F601 | None | None | F625 | None | None | None | F601 | F601 | None | None | F625 | None | None | None | F635 | None | None | None | None | F635 | None | F601 | F601 | None | None | F625 | F601 | F601 | None | F601 | None | F601 | F601 | None | None | F625 | F625 | F601 | F625 | None | F601 | None | None | F601 | F601 | F601 | None | None | F601 | F635 | F601 | F601 | F625 | None | None | F601 | None | None | F601 | None | F601 | F601 | None | None | F601 | None | None | None | F601 | None | F625 | None | None | F635 | F601 | None | F601 | F601 | F601 | F601 | F601 | None | F601 | None | None | F601 | F601 | F601 | F601 | None | None | F601 | F601 | F601 | F601 | None | F601 | F601 | F601 | None | F601 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing passed validation, but failed DB constraints | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing did not pass validation | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | 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 accepted | 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 accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | 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 did not pass validation | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing did not pass validation | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing did not pass validation | 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 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 passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted |