filing_id | 2658509 | 2674814 | 2661942 | 2668590 | 2663176 | 2673208 | 2672866 | 2666874 | 2666913 | 2658283 | 2672212 | 2730482 | 2706593 | 2711051 | 2720370 | 2715278 | 2681418 | 2689976 | 2687971 | 2718547 | 2727309 | 2727314 | 2710719 | 2729390 | 2688357 | 2683841 | 2718526 | 2727799 | 2686243 | 2686249 | 2687192 | 2680851 | 2718949 | 2687689 | 2682909 | 2715825 | 2722326 | 2713613 | 2725732 | 2678684 | 2689977 | 2679389 | 2722505 | 2745100 | 2746548 | 2731425 | 2731187 | 2743081 | 2740858 | 2744835 | 2744839 | 2739802 | 2752139 | 2750659 | 2752119 | 2742782 | 2744677 | 2740253 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_type | F497 | F497 | F497 | F497 | F497 | F460 | F497 | F497 | F497 | F497 | F497 | F497 | F460 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F460 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F460 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F460 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
entity_cd | CTL | CTL | CTL | CTL | None | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_naml | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | Yoo for Assembly 2022 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2022-03-18 00:00:00 | 2022-04-29 00:00:00 | 2022-03-30 00:00:00 | 2022-04-21 00:00:00 | 2022-04-05 00:00:00 | 2022-04-27 00:00:00 | 2022-04-28 00:00:00 | 2022-04-15 00:00:00 | 2022-04-16 00:00:00 | 2022-03-17 00:00:00 | 2022-04-27 00:00:00 | 2022-10-10 00:00:00 | 2022-07-25 00:00:00 | 2022-08-15 00:00:00 | 2022-09-15 00:00:00 | 2022-08-28 00:00:00 | 2022-05-11 00:00:00 | 2022-06-02 00:00:00 | 2022-05-27 00:00:00 | 2022-09-09 00:00:00 | 2022-10-03 00:00:00 | 2022-10-03 00:00:00 | 2022-08-12 00:00:00 | 2022-10-06 00:00:00 | 2022-05-29 00:00:00 | 2022-05-18 00:00:00 | 2022-09-09 00:00:00 | 2022-10-04 00:00:00 | 2022-05-25 00:00:00 | 2022-05-25 00:00:00 | 2022-05-24 00:00:00 | 2022-05-09 00:00:00 | 2022-09-12 00:00:00 | 2022-05-26 00:00:00 | 2022-05-16 00:00:00 | 2022-08-30 00:00:00 | 2022-09-21 00:00:00 | 2022-08-23 00:00:00 | 2022-09-28 00:00:00 | 2022-05-03 00:00:00 | 2022-06-02 00:00:00 | 2022-05-05 00:00:00 | 2022-09-22 00:00:00 | 2022-10-28 00:00:00 | 2022-10-30 00:00:00 | 2022-10-12 00:00:00 | 2022-10-11 00:00:00 | 2022-10-24 00:00:00 | 2022-10-25 00:00:00 | 2022-10-28 00:00:00 | 2022-10-28 00:00:00 | 2022-10-24 00:00:00 | 2022-11-04 00:00:00 | 2022-11-01 00:00:00 | 2022-11-04 00:00:00 | 2022-10-27 00:00:00 | 2022-10-27 00:00:00 | 2022-10-25 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmt_type | None | None | None | None | None | PE | None | None | None | None | None | None | SA | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | PE | None | None | None | None | None | None | None | PE | None | None | None | None | None | None | None | None | PE | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
late_rptno | 22-2 | 22-10 | 22-3 | 22-7 | 22-4 | None | 22-9 | 22-5 | 22-6 | 22-1 | 22-8 | 22-39 | None | 22-25 | 22-32 | 22-27 | 22-14 | 22-22 | 22-20 | 22-30 | 22-35 | 22-36 | 22-24 | 22-38 | 22-21 | 22-16 | 22-29 | 22-37 | 22-17 | 22-18 | None | 22-13 | 22-31 | 22-19 | 22-15 | 22-28 | 22-33 | 22-26 | None | 22-11 | 22-23 | 22-12 | 22-34 | 22-49 | 22-50 | 22-41 | 22-40 | None | 22-44 | 22-47 | 22-48 | 22-42 | 22-53 | 22-51 | 22-52 | 22-45 | 22-46 | 22-43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
from_date | None | None | None | None | None | 2022-01-01 00:00:00 | None | None | None | None | None | None | 2022-05-22 00:00:00 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 2022-04-24 00:00:00 | None | None | None | None | None | None | None | 2022-07-01 00:00:00 | None | None | None | None | None | None | None | None | 2022-09-25 00:00:00 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
thru_date | None | None | None | None | None | 2022-04-23 00:00:00 | None | None | None | None | None | None | 2022-06-30 00:00:00 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 2022-05-21 00:00:00 | None | None | None | None | None | None | None | 2022-09-24 00:00:00 | None | None | None | None | None | None | None | None | 2022-10-22 00:00:00 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
elect_date | None | 2022-06-07 00:00:00 | None | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | None | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_city | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | Cerritos | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_zip4 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | 90703 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_phon | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | 562-516-6360 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
file_email | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_city | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | Santa Ana | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_zip4 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tres_naml | Ray | None | Ray | None | None | Ray | None | None | None | Ray | None | None | Ray | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Ray | None | None | None | None | None | None | None | Ray | None | None | None | None | None | None | None | None | Ray | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tres_namf | Lysa | None | Lysa | None | None | Lysa | None | None | None | Lysa | None | None | Lysa | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Lysa | None | None | None | None | None | None | None | Lysa | None | None | None | None | None | None | None | None | Lysa | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tres_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tres_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tres_city | Santa Ana | None | Santa Ana | None | None | Santa Ana | None | None | None | Santa Ana | None | None | Santa Ana | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Santa Ana | None | None | None | None | None | None | None | Santa Ana | None | None | None | None | None | None | None | None | Santa Ana | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tres_st | CA | None | CA | None | None | CA | None | None | None | CA | None | None | CA | 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 | CA | None | None | None | None | None | None | None | None | CA | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tres_zip4 | 92704 | None | 92704 | None | None | 92704 | None | None | None | 92704 | None | None | 92704 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 92704 | None | None | None | None | None | None | None | 92704 | None | None | None | None | None | None | None | None | 92704 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tres_phon | 714-540-2295 | None | 714-540-2295 | None | None | 714-540-2295 | None | None | None | 714-540-2295 | None | None | 714-540-2295 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 714-540-2295 | None | None | None | None | None | None | None | 714-540-2295 | None | None | None | None | None | None | None | None | 714-540-2295 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tres_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tres_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cmtte_type | None | None | None | None | None | C | None | None | None | None | None | None | C | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | C | None | None | None | None | None | None | None | C | None | None | None | None | None | None | None | None | C | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
control_yn | None | None | None | None | None | Y | None | None | None | None | None | None | Y | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Y | None | None | None | None | None | None | None | Y | None | None | None | None | None | None | None | None | Y | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sponsor_yn | None | None | None | None | None | N | None | None | None | None | None | None | N | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | N | None | None | None | None | None | None | None | N | None | None | None | None | None | None | None | None | N | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
primfrm_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
brdbase_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
amendexp_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
amendexp_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
amendexp_3 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_att_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cmtte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
reportname | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rptfromdt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rptthrudt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
emplbus_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
bus_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
bus_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
bus_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
bus_inter | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
busact_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
busactvity | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
assoc_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
assoc_int | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
other_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
other_int | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cand_naml | None | None | None | None | None | Yoo | None | None | None | None | None | None | Yoo | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Yoo | None | None | None | None | None | None | None | Yoo | None | None | None | None | None | None | None | None | Yoo | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cand_namf | None | None | None | None | None | Soo | None | None | None | None | None | None | Soo | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Soo | None | None | None | None | None | None | None | Soo | None | None | None | None | None | None | None | None | Soo | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cand_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cand_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cand_city | None | None | None | None | None | Cerritos | None | None | None | None | None | None | Cerritos | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Cerritos | None | None | None | None | None | None | None | Cerritos | None | None | None | None | None | None | None | None | Cerritos | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cand_st | None | None | None | None | None | CA | 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 | None | None | None | None | None | None | None | CA | None | None | None | None | None | None | None | None | CA | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cand_zip4 | None | None | None | None | None | 90703 | None | None | None | None | None | None | 90703 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 90703 | None | None | None | None | None | None | None | 90703 | None | None | None | None | None | None | None | None | 90703 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cand_phon | None | None | None | None | None | 562-405-0797 | None | None | None | None | None | None | 562-405-0797 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 562-405-0797 | None | None | None | None | None | None | None | 562-405-0797 | None | None | None | None | None | None | None | None | 562-405-0797 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cand_fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cand_email | None | None | None | None | None | [email protected] | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
bal_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
bal_num | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
bal_juris | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
office_cd | None | None | None | None | None | ASM | None | None | None | None | None | None | ASM | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ASM | None | None | None | None | None | None | None | ASM | None | None | None | None | None | None | None | None | ASM | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
offic_dscr | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
juris_cd | None | None | None | None | None | ASM | None | None | None | None | None | None | ASM | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ASM | None | None | None | None | None | None | None | ASM | None | None | None | None | None | None | None | None | ASM | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
juris_dscr | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
dist_no | None | None | None | None | None | 67 | None | None | None | None | None | None | 67 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 67 | None | None | None | None | None | None | None | 67 | None | None | None | None | None | None | None | None | 67 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
off_s_h_cd | None | None | None | None | None | S | None | None | None | None | None | None | S | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | S | None | None | None | None | None | None | None | S | None | None | None | None | None | None | None | None | S | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sup_opp_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
employer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
occupation | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
selfemp_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
bal_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cand_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1446114 | 1446114 | ||
---|---|---|---|---|
adrid | 2533147 | 2533148 | ||
effect_dt | 2022-03-16 00:00:00 | 2022-03-16 00:00:00 | ||
add_type | 7051 | 7082 | ||
session_id | 2021 | 2021 |
filer_id | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2658509 | 2687971 | 2689976 | 2674814 | 2673208 | 2688357 | 2687192 | 2687689 | 2663176 | 2682909 | 2706593 | 2666874 | 2666913 | 2711051 | 2658283 | 2672212 | 2681418 | 2710719 | 2663581 | 2715278 | 2718547 | 2683841 | 2718526 | 2722326 | 2720370 | 2668590 | 2661942 | 2693273 | 2657983 | 2686243 | 2686249 | 2695984 | 2715825 | 2680851 | 2713613 | 2718949 | 2679389 | 2672866 | 2678684 | 2689977 | 2722505 | 2745100 | 2731187 | 2745498 | 2746548 | 2729390 | 2752119 | 2725732 | 2742782 | 2750659 | 2740858 | 2743081 | 2744835 | 2731425 | 2730482 | 2739802 | 2727309 | 2727314 | 2744839 | 2752139 | 2727799 | 2740253 | 2744677 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 249 | 250 | 250 | 250 | 249 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 251 | 249 | 250 | 250 | 251 | None | 251 | 251 | 250 | 251 | 251 | 251 | 250 | 249 | None | None | 250 | 250 | None | 251 | 250 | 251 | 251 | 250 | 250 | 250 | 250 | 251 | 252 | 252 | None | 252 | 252 | 252 | 251 | 252 | 252 | 252 | 251 | 252 | 252 | 252 | 252 | 252 | 252 | 252 | 252 | 252 | 252 | 252 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F497 | F497 | F497 | F497 | F460 | F497 | F460 | F497 | F497 | F497 | F460 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F410 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F460 | F410 | F497 | F497 | F460 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F460 | F497 | F497 | F497 | F460 | F497 | F497 | F497 | F460 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2022-03-18 00:00:00 | 2022-05-27 00:00:00 | 2022-06-02 00:00:00 | 2022-04-29 00:00:00 | 2022-04-28 00:00:00 | 2022-05-29 00:00:00 | 2022-05-26 00:00:00 | 2022-05-26 00:00:00 | 2022-04-05 00:00:00 | 2022-05-16 00:00:00 | 2022-08-01 00:00:00 | 2022-04-15 00:00:00 | 2022-04-16 00:00:00 | 2022-08-15 00:00:00 | 2022-03-17 00:00:00 | 2022-04-27 00:00:00 | 2022-05-11 00:00:00 | 2022-08-12 00:00:00 | 2022-04-04 00:00:00 | 2022-08-28 00:00:00 | 2022-09-09 00:00:00 | 2022-05-18 00:00:00 | 2022-09-09 00:00:00 | 2022-09-21 00:00:00 | 2022-09-15 00:00:00 | 2022-04-21 00:00:00 | 2022-03-30 00:00:00 | 2022-04-28 00:00:00 | 2022-03-16 00:00:00 | 2022-05-25 00:00:00 | 2022-05-25 00:00:00 | 2022-05-27 00:00:00 | 2022-08-31 00:00:00 | 2022-05-09 00:00:00 | 2022-08-23 00:00:00 | 2022-09-12 00:00:00 | 2022-05-05 00:00:00 | 2022-04-28 00:00:00 | 2022-05-03 00:00:00 | 2022-06-02 00:00:00 | 2022-09-22 00:00:00 | 2022-10-28 00:00:00 | 2022-10-11 00:00:00 | 2022-08-01 00:00:00 | 2022-10-30 00:00:00 | 2022-10-06 00:00:00 | 2022-11-04 00:00:00 | 2022-09-29 00:00:00 | 2022-10-27 00:00:00 | 2022-11-01 00:00:00 | 2022-10-25 00:00:00 | 2022-10-27 00:00:00 | 2022-10-28 00:00:00 | 2022-10-12 00:00:00 | 2022-10-10 00:00:00 | 2022-10-24 00:00:00 | 2022-10-03 00:00:00 | 2022-10-03 00:00:00 | 2022-10-28 00:00:00 | 2022-11-04 00:00:00 | 2022-10-04 00:00:00 | 2022-10-25 00:00:00 | 2022-10-27 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | CAFILER | CAFILER | CAFILER | CAFILER | KRUSSELL | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | RGEREMIA | CAFILER | CAFILER | IMEDINA | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | KRUSSELL | DCODY | CAFILER | CAFILER | JMAVES | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | RGEREMIA | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 2022-03-18 00:00:00 | 2022-05-27 00:00:00 | 2022-06-02 00:00:00 | 2022-04-29 00:00:00 | 2022-01-01 00:00:00 | 2022-05-29 00:00:00 | 2022-04-24 00:00:00 | 2022-05-26 00:00:00 | 2022-04-05 00:00:00 | 2022-05-16 00:00:00 | 2022-05-22 00:00:00 | 2022-04-15 00:00:00 | 2022-04-16 00:00:00 | 2022-08-15 00:00:00 | 2022-03-17 00:00:00 | 2022-04-27 00:00:00 | 2022-05-11 00:00:00 | 2022-08-12 00:00:00 | None | 2022-08-28 00:00:00 | 2022-09-09 00:00:00 | 2022-05-18 00:00:00 | 2022-09-09 00:00:00 | 2022-09-21 00:00:00 | 2022-09-15 00:00:00 | 2022-04-21 00:00:00 | 2022-03-30 00:00:00 | 2022-01-01 00:00:00 | None | 2022-05-25 00:00:00 | 2022-05-25 00:00:00 | 2022-04-24 00:00:00 | 2022-08-30 00:00:00 | 2022-05-09 00:00:00 | 2022-08-23 00:00:00 | 2022-09-12 00:00:00 | 2022-05-05 00:00:00 | 2022-04-28 00:00:00 | 2022-05-03 00:00:00 | 2022-06-02 00:00:00 | 2022-09-22 00:00:00 | 2022-10-28 00:00:00 | 2022-10-11 00:00:00 | 2022-05-22 00:00:00 | 2022-10-30 00:00:00 | 2022-10-06 00:00:00 | 2022-11-04 00:00:00 | 2022-07-01 00:00:00 | 2022-10-27 00:00:00 | 2022-11-01 00:00:00 | 2022-10-25 00:00:00 | 2022-09-25 00:00:00 | 2022-10-28 00:00:00 | 2022-10-12 00:00:00 | 2022-10-10 00:00:00 | 2022-10-24 00:00:00 | 2022-10-03 00:00:00 | 2022-10-03 00:00:00 | 2022-10-28 00:00:00 | 2022-11-04 00:00:00 | 2022-10-04 00:00:00 | 2022-10-25 00:00:00 | 2022-10-27 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 2022-03-18 00:00:00 | 2022-05-27 00:00:00 | 2022-06-02 00:00:00 | 2022-04-29 00:00:00 | 2022-04-23 00:00:00 | 2022-05-29 00:00:00 | 2022-05-21 00:00:00 | 2022-05-26 00:00:00 | 2022-04-05 00:00:00 | 2022-05-16 00:00:00 | 2022-06-30 00:00:00 | 2022-04-15 00:00:00 | 2022-04-16 00:00:00 | 2022-08-15 00:00:00 | 2022-03-17 00:00:00 | 2022-04-27 00:00:00 | 2022-05-11 00:00:00 | 2022-08-12 00:00:00 | None | 2022-08-28 00:00:00 | 2022-09-09 00:00:00 | 2022-05-18 00:00:00 | 2022-09-09 00:00:00 | 2022-09-21 00:00:00 | 2022-09-15 00:00:00 | 2022-04-21 00:00:00 | 2022-03-30 00:00:00 | 2022-04-23 00:00:00 | None | 2022-05-25 00:00:00 | 2022-05-25 00:00:00 | 2022-05-21 00:00:00 | 2022-08-30 00:00:00 | 2022-05-09 00:00:00 | 2022-08-23 00:00:00 | 2022-09-12 00:00:00 | 2022-05-05 00:00:00 | 2022-04-28 00:00:00 | 2022-05-03 00:00:00 | 2022-06-02 00:00:00 | 2022-09-22 00:00:00 | 2022-10-28 00:00:00 | 2022-10-11 00:00:00 | 2022-06-30 00:00:00 | 2022-10-30 00:00:00 | 2022-10-06 00:00:00 | 2022-11-04 00:00:00 | 2022-09-24 00:00:00 | 2022-10-27 00:00:00 | 2022-11-01 00:00:00 | 2022-10-25 00:00:00 | 2022-10-22 00:00:00 | 2022-10-28 00:00:00 | 2022-10-12 00:00:00 | 2022-10-10 00:00:00 | 2022-10-24 00:00:00 | 2022-10-03 00:00:00 | 2022-10-03 00:00:00 | 2022-10-28 00:00:00 | 2022-11-04 00:00:00 | 2022-10-04 00:00:00 | 2022-10-25 00:00:00 | 2022-10-27 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2022-03-18 00:00:00 | 2022-05-27 00:00:00 | 2022-06-02 00:00:00 | 2022-04-29 00:00:00 | 2022-04-27 00:00:00 | 2022-05-29 00:00:00 | 2022-05-24 00:00:00 | 2022-05-26 00:00:00 | 2022-04-05 00:00:00 | 2022-05-16 00:00:00 | 2022-07-25 00:00:00 | 2022-04-15 00:00:00 | 2022-04-16 00:00:00 | 2022-08-15 00:00:00 | 2022-03-17 00:00:00 | 2022-04-27 00:00:00 | 2022-05-11 00:00:00 | 2022-08-12 00:00:00 | None | 2022-08-28 00:00:00 | 2022-09-09 00:00:00 | 2022-05-18 00:00:00 | 2022-09-09 00:00:00 | 2022-09-21 00:00:00 | 2022-09-15 00:00:00 | 2022-04-21 00:00:00 | 2022-03-30 00:00:00 | None | None | 2022-05-25 00:00:00 | 2022-05-25 00:00:00 | None | 2022-08-30 00:00:00 | 2022-05-09 00:00:00 | 2022-08-23 00:00:00 | 2022-09-12 00:00:00 | 2022-05-05 00:00:00 | 2022-04-28 00:00:00 | 2022-05-03 00:00:00 | 2022-06-02 00:00:00 | 2022-09-22 00:00:00 | 2022-10-28 00:00:00 | 2022-10-11 00:00:00 | None | 2022-10-30 00:00:00 | 2022-10-06 00:00:00 | 2022-11-04 00:00:00 | 2022-09-28 00:00:00 | 2022-10-27 00:00:00 | 2022-11-01 00:00:00 | 2022-10-25 00:00:00 | 2022-10-24 00:00:00 | 2022-10-28 00:00:00 | 2022-10-12 00:00:00 | 2022-10-10 00:00:00 | 2022-10-24 00:00:00 | 2022-10-03 00:00:00 | 2022-10-03 00:00:00 | 2022-10-28 00:00:00 | 2022-11-04 00:00:00 | 2022-10-04 00:00:00 | 2022-10-25 00:00:00 | 2022-10-27 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
filer_id | 1446114 | 1446114 | ||
---|---|---|---|---|
filer_type | 16 | 16 | ||
active | Y | Y | ||
race | 0 | 0 | ||
session_id | 2021 | 2021 | ||
category | 40002 | 40002 | ||
category_type | 40502 | 40502 | ||
sub_category | 0 | 0 | ||
effect_dt | 2022-03-16 00:00:00 | 2022-04-04 00:00:00 | ||
sub_category_type | 0 | 0 | ||
election_type | 0 | 0 | ||
sub_category_a | None | None | ||
nyq_dt | None | 2022-03-17 00:00:00 | ||
party_cd | 16002 | 16002 | ||
county_cd | 18026 | 18026 | ||
district_cd | 0 | 0 |
filer_id | 1446114 | |
---|---|---|
xref_id | 1446114 | |
effect_dt | 2022-03-16 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1446114 | 1446114 | ||
---|---|---|---|---|
filer_id | 1446114 | 1446114 | ||
filer_type | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | ||
status | ACTIVE | ACTIVE | ||
effect_dt | 2022-04-04 00:00:00 | 2022-04-04 00:00:00 | ||
naml | YOO FOR ASSEMBLY 2022 | YOO FOR ASSEMBLY 2022 | ||
namf | None | None | ||
namt | None | None | ||
nams | None | None | ||
adr1 | None | None | ||
adr2 | None | None | ||
city | CERRITOS | SANTA ANA | ||
st | CA | CA | ||
zip4 | 90703 | 92704 | ||
phon | 5625166360 | None | ||
fax | None | None | ||
[email protected] | None |
filer_id | 1446114 |
---|
filer_id | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | 1446114 | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 2689976_0.cal | 2720370_0.cal | 306916.cal | 507472.cal | 2722326_0.cal | 2687689_0.cal | 2666913_0.cal | 2658283_0.cal | 2666874_0.cal | 2672212_0.cal | 2681418_0.cal | 59879.cal | 2740253_0.cal | 2710719_0.cal | 2668590_0.cal | 44745.cal | 2672866_0.cal | 519384.cal | 519398.cal | 519440.cal | 2678684_0.cal | 2744677_0.cal | 2740858_0.cal | 2742782_0.cal | 206048.cal | 2658509_0.cal | 2718547_0.cal | 523618.cal | 2722505_0.cal | 2731425_0.cal | 2715278_0.cal | 2744839_0.cal | 2730482_0.cal | 2683841_0.cal | 137175.cal | 2686249_0.cal | 2715825_0.cal | 2679389_0.cal | 2750659_0.cal | |||||||||||||||||||||||||||||||||||||||
received_date | 2022-06-02 00:00:00 | 2022-09-15 00:00:00 | 2022-04-21 00:00:00 | 2022-04-05 00:00:00 | 2022-09-21 00:00:00 | 2022-05-26 00:00:00 | 2022-04-16 00:00:00 | 2022-03-17 00:00:00 | 2022-04-15 00:00:00 | 2022-04-27 00:00:00 | 2022-05-11 00:00:00 | 2022-03-18 00:00:00 | 2022-10-25 00:00:00 | 2022-08-12 00:00:00 | 2022-04-21 00:00:00 | 2022-03-17 00:00:00 | 2022-04-28 00:00:00 | 2022-04-28 00:00:00 | 2022-04-28 00:00:00 | 2022-04-28 00:00:00 | 2022-05-03 00:00:00 | 2022-10-27 00:00:00 | 2022-10-25 00:00:00 | 2022-10-27 00:00:00 | 2022-04-16 00:00:00 | 2022-03-18 00:00:00 | 2022-09-09 00:00:00 | 2022-04-28 00:00:00 | 2022-09-22 00:00:00 | 2022-10-12 00:00:00 | 2022-08-28 00:00:00 | 2022-10-28 00:00:00 | 2022-10-10 00:00:00 | 2022-05-18 00:00:00 | 2022-05-18 00:00:00 | 2022-05-25 00:00:00 | 2022-08-31 00:00:00 | 2022-05-05 00:00:00 | 2022-11-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||
filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/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/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||||||||||||||||
filing_id | 2689976 | 2720370 | None | None | 2722326 | 2687689 | 2666913 | 2658283 | 2666874 | 2672212 | 2681418 | None | 2740253 | 2710719 | 2668590 | None | 2672866 | None | None | None | 2678684 | 2744677 | 2740858 | 2742782 | None | 2658509 | 2718547 | None | 2722505 | 2731425 | 2715278 | 2744839 | 2730482 | 2683841 | None | 2686249 | 2715825 | 2679389 | 2750659 | |||||||||||||||||||||||||||||||||||||||
form_id | F497 | F497 | None | None | F497 | F497 | F497 | F497 | F497 | F497 | F497 | None | F497 | F497 | F497 | None | F497 | None | None | None | F497 | F497 | F497 | F497 | None | F497 | F497 | None | F497 | F497 | F497 | F497 | F497 | F497 | None | F497 | F497 | F497 | F497 | |||||||||||||||||||||||||||||||||||||||
receive_comment | 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 accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing accepted | Filing passed validation, but failed DB constraints | Filing 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 passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted |