filing_id | 2500378 | 2500383 | 2501076 | 2533996 | 2533998 | 2555430 | 2553266 | 2505717 | 2535824 | 2514467 | 2533994 | 2545900 | 2677315 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 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 | |||||||||||||
form_type | F497 | F497 | F497 | F497 | F497 | F497 | F460 | F497 | F497 | F497 | F497 | F497 | F460 | |||||||||||||
filer_id | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | |||||||||||||
entity_cd | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | CTL | RCP | |||||||||||||
filer_naml | Major Williams for Governor 2022 | Major Williams for Governor 2022 | Major Williams for Governor 2022 | Major Williams for Governor 2022 | Major Williams for Governor 2022 | Major Williams for Governor 2022 | Major Williams for Governor 2022 | Major Williams for Governor 2022 | Major Williams for Governor 2022 | Major Williams for Governor 2022 | Major Williams for Governor 2022 | Major Williams for Governor 2022 | WILLIAMS FOR GOVERNOR 2022; MAJOR | |||||||||||||
filer_namf | 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 | |||||||||||||
filer_nams | 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 | |||||||||||||
rpt_date | 2020-09-08 00:00:00 | 2020-09-10 00:00:00 | 2020-09-14 00:00:00 | 2020-11-06 00:00:00 | 2020-11-06 00:00:00 | 2021-02-02 00:00:00 | 2021-02-01 00:00:00 | 2020-09-24 00:00:00 | 2020-11-25 00:00:00 | 2020-10-13 00:00:00 | 2020-11-06 00:00:00 | 2021-01-22 00:00:00 | 2022-05-02 00:00:00 | |||||||||||||
stmt_type | None | None | None | None | None | None | SA | None | None | None | None | None | QT | |||||||||||||
late_rptno | 20-1 | 20-2 | 20-3 | 20-7 | 20-8 | 21-2 | None | 20-4 | 20-9 | 20-5 | 20-6 | 21-1 | None | |||||||||||||
from_date | None | None | None | None | None | None | 2020-01-01 00:00:00 | None | None | None | None | None | 2022-01-01 00:00:00 | |||||||||||||
thru_date | None | None | None | None | None | None | 2020-12-31 00:00:00 | None | None | None | None | None | 2022-04-23 00:00:00 | |||||||||||||
elect_date | None | None | None | None | None | None | 2022-11-08 00:00:00 | None | None | None | None | None | 2022-06-07 00:00:00 | |||||||||||||
filer_city | Pasadena | Pasadena | Pasadena | Pasadena | Pasadena | Pasadena | Pasadena | Pasadena | Pasadena | Pasadena | Pasadena | Pasadena | PASADENA | |||||||||||||
filer_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||
filer_zip4 | 91107 | 91107 | 91107 | 91107 | 91107 | 91107 | 91107 | 91107 | 91107 | 91107 | 91107 | 91107 | 91107 | |||||||||||||
filer_phon | 626-623-3753 | 626-623-3753 | 626-623-3753 | 626-623-3753 | 626-623-3753 | 626-623-3753 | 626-623-3753 | 626-623-3753 | 626-623-3753 | 626-623-3753 | 626-623-3753 | 626-623-3753 | None | |||||||||||||
filer_fax | 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] | None | |||||||||||||
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 | |||||||||||||
mail_st | 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 | |||||||||||||
tres_naml | Ray | Ray | Ray | Ray | Ray | Ray | Ray | Ray | Ray | Ray | Ray | Ray | Williams | |||||||||||||
tres_namf | Lysa | Lysa | Lysa | Lysa | Lysa | Lysa | Lysa | Lysa | Lysa | Lysa | Lysa | Lysa | Major | |||||||||||||
tres_namt | 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 | |||||||||||||
tres_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 | Murrieta | |||||||||||||
tres_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | Ca | |||||||||||||
tres_zip4 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92704 | 92562 | |||||||||||||
tres_phon | 714-540-2295 | 714-540-2295 | 714-540-2295 | 714-540-2295 | 714-540-2295 | 714-540-2295 | 714-540-2295 | 714-540-2295 | 714-540-2295 | 714-540-2295 | 714-540-2295 | 714-540-2295 | 6266233753 | |||||||||||||
tres_fax | 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 | [email protected] | |||||||||||||
cmtte_type | None | None | None | None | None | None | C | None | None | None | None | None | C | |||||||||||||
control_yn | None | None | None | None | None | None | Y | None | None | None | None | None | Y | |||||||||||||
sponsor_yn | None | None | None | None | None | None | N | None | None | None | None | None | N | |||||||||||||
primfrm_yn | None | None | None | None | None | None | N | None | None | None | None | None | None | |||||||||||||
brdbase_yn | None | None | None | None | None | None | N | None | None | None | None | None | None | |||||||||||||
amendexp_1 | 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 | |||||||||||||
amendexp_3 | 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 | |||||||||||||
cmtte_id | 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 | |||||||||||||
rptfromdt | 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 | |||||||||||||
emplbus_cb | 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 | |||||||||||||
bus_city | 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 | |||||||||||||
bus_zip4 | 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 | |||||||||||||
busact_cb | 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 | |||||||||||||
assoc_cb | 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 | |||||||||||||
other_cb | 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 | |||||||||||||
cand_naml | None | None | None | None | None | None | Williams | None | None | None | None | None | Williams | |||||||||||||
cand_namf | None | None | None | None | None | None | Major | None | None | None | None | None | Major | |||||||||||||
cand_namt | 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 | |||||||||||||
cand_city | None | None | None | None | None | None | Pasadena | None | None | None | None | None | Murrieta | |||||||||||||
cand_st | None | None | None | None | None | None | CA | None | None | None | None | None | Ca | |||||||||||||
cand_zip4 | None | None | None | None | None | None | 91107 | None | None | None | None | None | 92562 | |||||||||||||
cand_phon | None | None | None | None | None | None | 626-623-3753 | None | None | None | None | None | None | |||||||||||||
cand_fax | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
cand_email | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | |||||||||||||
bal_name | 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 | |||||||||||||
bal_juris | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
office_cd | None | None | None | None | None | None | GOV | None | None | None | None | None | GOV | |||||||||||||
offic_dscr | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
juris_cd | None | None | None | None | None | None | STW | None | None | None | None | None | STW | |||||||||||||
juris_dscr | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
dist_no | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
off_s_h_cd | None | None | None | None | None | None | S | None | None | None | None | None | None | |||||||||||||
sup_opp_cd | 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 | |||||||||||||
occupation | 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 | |||||||||||||
bal_id | 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 |
filer_id | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | |||||
---|---|---|---|---|---|---|---|---|---|---|
adrid | 2506128 | 2506129 | 2495091 | 2495092 | 2520345 | |||||
effect_dt | 2020-08-20 00:00:00 | 2020-08-20 00:00:00 | 2020-07-14 00:00:00 | 2020-07-14 00:00:00 | 2021-07-02 00:00:00 | |||||
add_type | 7051 | 7082 | 7051 | 7082 | 7051 | |||||
session_id | 2019 | 2019 | 2019 | 2019 | 2021 |
filer_id | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2555430 | 2535824 | 2545900 | 2498917 | 2505717 | 2533996 | 2533998 | 2496853 | 2514467 | 2500378 | 2533994 | 2584804 | 2501076 | 2553266 | 2479144 | 2500383 | 2560820 | 2591065 | 2677315 | 2631449 | ||||||||||||||||||||
period_id | 245 | 244 | 245 | None | 243 | 244 | 244 | None | 244 | 243 | 244 | None | 243 | 241 | None | 243 | None | None | 249 | None | ||||||||||||||||||||
form_id | F497 | F497 | F497 | F888 | F497 | F497 | F497 | F410 | F497 | F497 | F497 | F410 | F497 | F460 | F410 | F497 | F460 | F410 | F460 | F410 | ||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
filing_date | 2021-02-02 00:00:00 | 2020-11-25 00:00:00 | 2021-01-22 00:00:00 | 2020-07-31 00:00:00 | 2020-09-24 00:00:00 | 2020-11-06 00:00:00 | 2020-11-06 00:00:00 | 2020-08-20 00:00:00 | 2020-10-13 00:00:00 | 2020-09-10 00:00:00 | 2020-11-06 00:00:00 | 2021-05-18 00:00:00 | 2020-09-14 00:00:00 | 2021-02-01 00:00:00 | 2020-07-14 00:00:00 | 2020-09-10 00:00:00 | 2021-02-01 00:00:00 | 2021-07-02 00:00:00 | 2022-05-02 00:00:00 | 2021-07-19 00:00:00 | ||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10005 | 10001 | 10005 | 10006 | 10001 | 10006 | ||||||||||||||||||||
stmnt_status | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11002 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | ||||||||||||||||||||
session_id | 2021 | 2019 | 2021 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||
user_id | CAFILER | RGEREMIA | CAFILER | TRAMON | RGEREMIA | RGEREMIA | RGEREMIA | KWHELAN | RGEREMIA | RGEREMIA | RGEREMIA | IMEDINA | RGEREMIA | SUSHAKOV | PADAMS | CAFILER | SUSHAKOV | IMEDINA | CAFILER | IMEDINA | ||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||
fine_audit | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||
rpt_start | 2021-02-02 00:00:00 | 2020-11-25 00:00:00 | 2021-01-22 00:00:00 | None | 2020-09-24 00:00:00 | 2020-11-06 00:00:00 | 2020-11-06 00:00:00 | None | 2020-10-13 00:00:00 | 2020-09-08 00:00:00 | 2020-11-06 00:00:00 | None | 2020-09-14 00:00:00 | 2020-01-01 00:00:00 | None | 2020-09-10 00:00:00 | 2020-01-01 00:00:00 | None | 2022-01-01 00:00:00 | None | ||||||||||||||||||||
rpt_end | 2021-02-02 00:00:00 | 2020-11-25 00:00:00 | 2021-01-22 00:00:00 | None | 2020-09-24 00:00:00 | 2020-11-06 00:00:00 | 2020-11-06 00:00:00 | None | 2020-10-13 00:00:00 | 2020-09-08 00:00:00 | 2020-11-06 00:00:00 | None | 2020-09-14 00:00:00 | 2020-12-31 00:00:00 | None | 2020-09-10 00:00:00 | 2020-12-31 00:00:00 | None | 2022-04-23 00:00:00 | None | ||||||||||||||||||||
rpt_date | 2021-02-02 00:00:00 | 2020-11-25 00:00:00 | 2021-01-22 00:00:00 | None | 2020-09-24 00:00:00 | 2020-11-06 00:00:00 | 2020-11-06 00:00:00 | None | 2020-10-13 00:00:00 | 2020-09-08 00:00:00 | 2020-11-06 00:00:00 | None | 2020-09-14 00:00:00 | 2021-02-01 00:00:00 | None | 2020-09-10 00:00:00 | None | None | 2022-05-02 00:00:00 | None | ||||||||||||||||||||
filing_type | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | None | None | 22006 | None |
filer_id | 1428025 | 1428025 | ||
---|---|---|---|---|
filer_type | 16 | 16 | ||
active | Y | Y | ||
race | 0 | 0 | ||
session_id | 2019 | 2019 | ||
category | 40002 | 40002 | ||
category_type | 40502 | 40502 | ||
sub_category | 0 | 0 | ||
effect_dt | 2020-08-20 00:00:00 | 2020-07-14 00:00:00 | ||
sub_category_type | 0 | 0 | ||
election_type | 0 | 0 | ||
sub_category_a | None | None | ||
nyq_dt | 2020-08-15 00:00:00 | None | ||
party_cd | 16002 | 16002 | ||
county_cd | 18026 | 18026 | ||
district_cd | 0 | 0 |
filer_id | 1428025 | |
---|---|---|
xref_id | 1428025 | |
effect_dt | 2020-07-17 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | |||||
---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | |||||
filer_type | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | |||||
status | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | |||||
effect_dt | 2020-08-20 00:00:00 | 2020-08-20 00:00:00 | 2020-08-20 00:00:00 | 2020-08-20 00:00:00 | 2020-08-20 00:00:00 | |||||
naml | WILLIAMS FOR GOVERNOR 2022; MAJOR | WILLIAMS FOR GOVERNOR 2022; MAJOR | WILLIAMS FOR GOVERNOR 2022; MAJOR | WILLIAMS FOR GOVERNOR 2022; MAJOR | WILLIAMS FOR GOVERNOR 2022; MAJOR | |||||
namf | None | None | None | None | None | |||||
namt | None | None | None | None | None | |||||
nams | None | None | None | None | None | |||||
adr1 | None | None | None | None | None | |||||
adr2 | None | None | None | None | None | |||||
city | PASADENA | SAN RAFAEL | PASADENA | SANTA ANA | PASADENA | |||||
st | CA | CA | CA | CA | CA | |||||
zip4 | 91107 | 949135703 | 91107 | 92704 | 91107 | |||||
phon | 4152504036 | None | 6266233753 | 6266233753 | ||||||
fax | None | None | None | None | None | |||||
[email protected] | None | [email protected] | [email protected] | None |
filer_id | 1428025 |
---|
filer_id | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | 1428025 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 481861.cal | 2533996_0.cal | 2505717_0.cal | 2533994_0.cal | 2500378_0.cal | 2514467_0.cal | 2501076_0.cal | 279626.cal | 2555430_0.cal | |||||||||
received_date | 2021-02-01 00:00:00 | 2020-11-06 00:00:00 | 2020-09-24 00:00:00 | 2020-11-06 00:00:00 | 2020-09-10 00:00:00 | 2020-10-13 00:00:00 | 2020-09-14 00:00:00 | 2020-09-10 00:00:00 | 2021-02-02 00:00:00 | |||||||||
filing_directory | /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 | |||||||||
filing_id | None | 2533996 | 2505717 | 2533994 | 2500378 | 2514467 | 2501076 | None | 2555430 | |||||||||
form_id | None | F497 | F497 | F497 | F497 | F497 | F497 | None | F497 | |||||||||
receive_comment | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted |