filing_id | 2563869 | 2553493 | 2590690 | 2645021 | 2587030 | 2583714 | 2673621 | 2600971 | 2609233 | 2658291 | 2681560 | 2708188 | 2726541 | 2687244 | 2743199 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 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 | |||||||||||||||
form_type | F497 | F460 | F497 | F460 | F497 | F497 | F460 | F460 | F497 | F497 | F497 | F460 | F497 | F460 | F460 | |||||||||||||||
filer_id | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | |||||||||||||||
entity_cd | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | |||||||||||||||
filer_naml | Jim Frazier for Assembly 2022 | Jim Frazier for Assembly 2022 | Jim Frazier for Assembly 2022 | Jim Frazier for Assembly 2022 | Jim Frazier for Assembly 2022 | Jim Frazier for Assembly 2022 | Jim Frazier for Assembly 2022 | Jim Frazier for Assembly 2022 | Jim Frazier for Assembly 2022 | Jim Frazier for Assembly 2022 | Jim Frazier for Assembly 2022 | Jim Frazier for Assembly 2022 | Jim Frazier for Assembly 2022 | Jim Frazier for Assembly 2022 | Jim Frazier for Assembly 2022 | |||||||||||||||
filer_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
filer_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
filer_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||||
rpt_date | 2021-03-08 00:00:00 | 2021-01-25 00:00:00 | 2021-07-02 00:00:00 | 2022-01-21 00:00:00 | 2021-06-07 00:00:00 | 2021-05-11 00:00:00 | 2022-04-28 00:00:00 | 2021-07-25 00:00:00 | 2021-08-27 00:00:00 | 2022-03-17 00:00:00 | 2022-05-11 00:00:00 | 2022-07-31 00:00:00 | 2022-09-29 00:00:00 | 2022-05-26 00:00:00 | 2022-10-27 00:00:00 | |||||||||||||||
stmt_type | None | SA | None | SA | None | None | PE | SA | None | None | None | SA | None | PE | PE | |||||||||||||||
late_rptno | 03082021-1 | None | 07022021-1 | None | 06072021-1 | 05112021-1 | None | None | 08272021-1 | 03172022-1 | 05112022-1 | None | 09292022-1 | None | None | |||||||||||||||
from_date | None | 2020-01-01 00:00:00 | None | 2021-07-01 00:00:00 | None | None | 2022-01-01 00:00:00 | 2021-01-01 00:00:00 | None | None | None | 2022-05-22 00:00:00 | None | 2022-04-24 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||
thru_date | None | 2020-12-31 00:00:00 | None | 2021-12-31 00:00:00 | None | None | 2022-04-23 00:00:00 | 2021-06-30 00:00:00 | None | None | None | 2022-06-30 00:00:00 | None | 2022-05-21 00:00:00 | 2022-10-22 00:00:00 | |||||||||||||||
elect_date | None | 2022-06-07 00:00:00 | None | 2022-06-07 00:00:00 | None | None | 2022-06-07 00:00:00 | 2022-06-07 00:00:00 | None | 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 | |||||||||||||||
filer_city | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | |||||||||||||||
filer_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||
filer_zip4 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | |||||||||||||||
filer_phon | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | |||||||||||||||
filer_fax | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | 916-865-4657 | |||||||||||||||
file_email | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | |||||||||||||||
mail_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
mail_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
tres_naml | Johnson | Johnson | Johnson | Johnson | Johnson | Johnson | Johnson | Johnson | Johnson | Johnson | None | Johnson | None | Johnson | Johnson | |||||||||||||||
tres_namf | Chelsea | Chelsea | Chelsea | Chelsea | Chelsea | Chelsea | Chelsea | Chelsea | Chelsea | Chelsea | None | Chelsea | None | Chelsea | Chelsea | |||||||||||||||
tres_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
tres_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
tres_city | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | Antelope | None | Antelope | None | Antelope | Antelope | |||||||||||||||
tres_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | None | CA | None | CA | CA | |||||||||||||||
tres_zip4 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | 95843 | None | 95843 | None | 95843 | 95843 | |||||||||||||||
tres_phon | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | 916-749-3533 | None | 916-749-3533 | None | 916-749-3533 | 916-749-3533 | |||||||||||||||
tres_fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
tres_email | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
cmtte_type | None | C | None | C | None | None | C | C | None | None | None | C | None | C | C | |||||||||||||||
control_yn | None | Y | None | Y | None | None | Y | Y | None | None | None | Y | None | Y | Y | |||||||||||||||
sponsor_yn | None | N | None | N | None | None | N | N | None | None | None | N | None | N | N | |||||||||||||||
primfrm_yn | None | N | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
brdbase_yn | None | N | 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 | |||||||||||||||
amendexp_2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
amendexp_3 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
rpt_att_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
cmtte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
reportname | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
rptfromdt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
rptthrudt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
emplbus_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
bus_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
bus_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
bus_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
bus_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
bus_inter | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
busact_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
busactvity | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
assoc_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
assoc_int | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
other_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
other_int | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
cand_naml | None | Frazier, Jr. | None | Frazier, Jr. | None | None | Frazier, Jr. | Frazier, Jr. | None | None | None | Frazier, Jr. | None | Frazier, Jr. | Frazier, Jr. | |||||||||||||||
cand_namf | None | James L | None | James L | None | None | James L | James L | None | None | None | James L | None | James L | James L | |||||||||||||||
cand_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
cand_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
cand_city | None | Fairfield | None | Fairfield | None | None | Fairfield | Fairfield | None | None | None | Fairfield | None | Fairfield | Fairfield | |||||||||||||||
cand_st | None | CA | None | CA | None | None | CA | CA | None | None | None | CA | None | CA | CA | |||||||||||||||
cand_zip4 | None | 94534 | None | 94534 | None | None | 94534 | 94534 | None | None | None | 94534 | None | 94534 | 94534 | |||||||||||||||
cand_phon | None | 925-250-6831 | None | 925-250-6831 | None | None | 925-250-6831 | 925-250-6831 | None | None | None | 925-250-6831 | None | 925-250-6831 | 925-250-6831 | |||||||||||||||
cand_fax | None | 916-865-4657 | None | 916-865-4657 | None | None | 916-865-4657 | 916-865-4657 | None | None | None | 916-865-4657 | None | 916-865-4657 | 916-865-4657 | |||||||||||||||
cand_email | None | [email protected] | None | [email protected] | None | None | [email protected] | [email protected] | None | None | None | [email protected] | None | [email protected] | [email protected] | |||||||||||||||
bal_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
bal_num | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
bal_juris | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
office_cd | None | ASM | None | ASM | None | None | ASM | ASM | None | None | None | ASM | None | ASM | ASM | |||||||||||||||
offic_dscr | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
juris_cd | None | ASM | None | ASM | None | None | ASM | ASM | None | None | None | ASM | None | ASM | ASM | |||||||||||||||
juris_dscr | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
dist_no | None | 11 | None | 11 | None | None | 11 | 11 | None | None | None | 11 | None | 11 | 11 | |||||||||||||||
off_s_h_cd | None | H | None | H | None | None | H | H | None | None | None | H | None | H | H | |||||||||||||||
sup_opp_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
employer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
occupation | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
selfemp_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
bal_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
cand_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1435037 | |
---|---|---|
adrid | 2506510 | |
effect_dt | 2020-12-02 00:00:00 | |
add_type | 7051 | |
session_id | 2019 |
filer_id | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2563869 | 2536127 | 2583714 | 2590690 | 2587030 | 2553493 | 2560102 | 2690178 | 2607526 | 2558035 | 2673621 | 2687244 | 2708188 | 2600971 | 2645021 | 2653076 | 2681560 | 2658291 | 2609233 | 2694910 | 2726541 | 2743199 | 2738973 | |||||||||||||||||||||||
period_id | 245 | None | 246 | 247 | 246 | 241 | None | None | None | None | 249 | 250 | 250 | 245 | 247 | None | 250 | 249 | 247 | None | 251 | 251 | None | |||||||||||||||||||||||
form_id | F497 | F410 | F497 | F497 | F497 | F460 | F460 | F460 | F460 | F410 | F460 | F460 | F460 | F460 | F460 | F460 | F497 | F497 | F497 | F460 | F497 | F460 | F460 | |||||||||||||||||||||||
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 | |||||||||||||||||||||||
filing_date | 2021-03-08 00:00:00 | 2020-12-02 00:00:00 | 2021-05-11 00:00:00 | 2021-07-02 00:00:00 | 2021-06-07 00:00:00 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 2022-04-28 00:00:00 | 2021-08-02 00:00:00 | 2021-02-02 00:00:00 | 2022-04-28 00:00:00 | 2022-05-26 00:00:00 | 2022-08-01 00:00:00 | 2021-07-30 00:00:00 | 2022-01-31 00:00:00 | 2022-01-31 00:00:00 | 2022-05-11 00:00:00 | 2022-03-17 00:00:00 | 2021-08-27 00:00:00 | 2022-05-27 00:00:00 | 2022-09-29 00:00:00 | 2022-10-27 00:00:00 | 2022-08-02 00:00:00 | |||||||||||||||||||||||
stmnt_type | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | |||||||||||||||||||||||
stmnt_status | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||
session_id | 2021 | 2019 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||
user_id | CAFILER | PADAMS | RGEREMIA | RGEREMIA | RGEREMIA | SUSHAKOV | SUSHAKOV | KRUSSELL | KRUSSELL | IMEDINA | KRUSSELL | CAFILER | CAFILER | KRUSSELL | JMENDOZA | JMENDOZA | CAFILER | CAFILER | RGEREMIA | JMAVES | CAFILER | CAFILER | RGEREMIA | |||||||||||||||||||||||
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 | |||||||||||||||||||||||
fine_audit | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||
rpt_start | 2021-03-08 00:00:00 | None | 2021-05-11 00:00:00 | 2021-07-02 00:00:00 | 2021-06-07 00:00:00 | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 2022-01-01 00:00:00 | 2021-01-01 00:00:00 | None | 2022-01-01 00:00:00 | 2022-04-24 00:00:00 | 2022-05-22 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-07-01 00:00:00 | 2022-05-11 00:00:00 | 2022-03-17 00:00:00 | 2021-08-27 00:00:00 | 2022-04-24 00:00:00 | 2022-09-29 00:00:00 | 2022-07-01 00:00:00 | 2022-05-22 00:00:00 | |||||||||||||||||||||||
rpt_end | 2021-03-08 00:00:00 | None | 2021-05-11 00:00:00 | 2021-07-02 00:00:00 | 2021-06-07 00:00:00 | 2020-12-31 00:00:00 | 2020-12-31 00:00:00 | 2022-04-23 00:00:00 | 2021-06-30 00:00:00 | None | 2022-04-23 00:00:00 | 2022-05-21 00:00:00 | 2022-06-30 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-05-11 00:00:00 | 2022-03-17 00:00:00 | 2021-08-27 00:00:00 | 2022-05-21 00:00:00 | 2022-09-29 00:00:00 | 2022-10-22 00:00:00 | 2022-06-30 00:00:00 | |||||||||||||||||||||||
rpt_date | 2021-03-08 00:00:00 | None | 2021-05-11 00:00:00 | 2021-07-02 00:00:00 | 2021-06-07 00:00:00 | 2021-01-25 00:00:00 | None | None | None | None | 2022-04-28 00:00:00 | 2022-05-26 00:00:00 | 2022-07-31 00:00:00 | 2021-07-25 00:00:00 | 2022-01-21 00:00:00 | None | 2022-05-11 00:00:00 | 2022-03-17 00:00:00 | 2021-08-27 00:00:00 | None | 2022-09-29 00:00:00 | 2022-10-27 00:00:00 | None | |||||||||||||||||||||||
filing_type | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | None |
filer_id | 1435037 | 1435037 | ||
---|---|---|---|---|
filer_type | 16 | 16 | ||
active | Y | Y | ||
race | 0 | 0 | ||
session_id | 2019 | 2021 | ||
category | 40002 | 40002 | ||
category_type | 40502 | 40502 | ||
sub_category | 0 | 0 | ||
effect_dt | 2020-12-02 00:00:00 | 2021-02-02 00:00:00 | ||
sub_category_type | 0 | 0 | ||
election_type | 0 | 0 | ||
sub_category_a | None | None | ||
nyq_dt | None | 2020-12-31 00:00:00 | ||
party_cd | 16001 | 16001 | ||
county_cd | 18015 | 18015 | ||
district_cd | 0 | 0 |
filer_id | 1435037 | |
---|---|---|
xref_id | 1435037 | |
effect_dt | 2020-12-03 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1435037 | |
---|---|---|
filer_id | 1435037 | |
filer_type | RECIPIENT COMMITTEE | |
status | ACTIVE | |
effect_dt | 2021-02-02 00:00:00 | |
naml | FRAZIER FOR ASSEMBLY 2022; JIM | |
namf | None | |
namt | None | |
nams | None | |
adr1 | None | |
adr2 | None | |
city | ANTELOPE | |
st | CA | |
zip4 | 95843 | |
phon | 9167493533 | |
fax | None | |
[email protected] |
filer_id | 1435037 |
---|
filer_id | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | 1435037 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 2583714_0.cal | 2658291_0.cal | 2590690_0.cal | 2587030_0.cal | 2726541_0.cal | 433821.cal | 2563869_0.cal | 2681560_0.cal | 128803.cal | |||||||||
received_date | 2021-05-11 00:00:00 | 2022-03-17 00:00:00 | 2021-07-02 00:00:00 | 2021-06-07 00:00:00 | 2022-09-29 00:00:00 | 2021-05-11 00:00:00 | 2021-03-08 00:00:00 | 2022-05-11 00:00:00 | 2022-01-31 00:00:00 | |||||||||
filing_directory | /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/temp | |||||||||
filing_id | 2583714 | 2658291 | 2590690 | 2587030 | 2726541 | None | 2563869 | 2681560 | None | |||||||||
form_id | F497 | F497 | F497 | F497 | F497 | None | F497 | F497 | None | |||||||||
receive_comment | Filing accepted | 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 |