filing_id | 2227740 | 2253969 | 2238360 | 2251735 | 2212436 | 2234225 | 2259092 | 2211460 | 2240815 | 2238360 | 2250161 | 2238360 | 2244336 | 2238360 | 2211460 | 2253969 | 2231353 | 2232665 | 2253969 | 2234085 | 2255540 | 2248706 | 2254597 | 2263199 | 2297790 | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 0 | 2 | 0 | 1 | 0 | 0 | 2 | 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 | |||||||||||||||||||||||||
form_type | F497 | F460 | F460 | F497 | F497 | F497 | F497 | F460 | F497 | F460 | F497 | F460 | F497 | F460 | F460 | F460 | F497 | F497 | F460 | F497 | F497 | F497 | F497 | F460 | F460 | |||||||||||||||||||||||||
filer_id | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | |||||||||||||||||||||||||
entity_cd | RCP | CAO | CAO | CAO | RCP | CAO | CAO | RCP | CAO | CAO | CAO | CAO | CAO | CAO | RCP | CAO | RCP | RCP | CAO | CAO | CAO | CAO | CAO | CAO | RCP | |||||||||||||||||||||||||
filer_naml | MC LAUGHLIN FOR LIEUTENANT GOVERNOR 2018; GAYLE | Gayle McLaughlin For Lieutenant Governor 2018 | Gayle McLaughlin For Lieutenant Governor 2018 | Gayle McLaughlin For Lieutenant Governor 2018 | MC LAUGHLIN FOR LIEUTENANT GOVERNOR 2018; GAYLE | Gayle McLaughlin For Lieutenant Governor 2018 | Gayle McLaughlin For Lieutenant Governor 2018 | MC LAUGHLIN FOR LIEUTENANT GOVERNOR 2018; GAYLE | Gayle McLaughlin For Lieutenant Governor 2018 | Gayle McLaughlin For Lieutenant Governor 2018 | Gayle McLaughlin For Lieutenant Governor 2018 | Gayle McLaughlin For Lieutenant Governor 2018 | Gayle McLaughlin For Lieutenant Governor 2018 | Gayle McLaughlin For Lieutenant Governor 2018 | MC LAUGHLIN FOR LIEUTENANT GOVERNOR 2018; GAYLE | Gayle McLaughlin For Lieutenant Governor 2018 | MC LAUGHLIN FOR LIEUTENANT GOVERNOR 2018; GAYLE | MC LAUGHLIN FOR LIEUTENANT GOVERNOR 2018; GAYLE | Gayle McLaughlin For Lieutenant Governor 2018 | Gayle McLaughlin For Lieutenant Governor 2018 | Gayle McLaughlin For Lieutenant Governor 2018 | Gayle McLaughlin For Lieutenant Governor 2018 | Gayle McLaughlin For Lieutenant Governor 2018 | Gayle McLaughlin For Lieutenant Governor 2018 | MC LAUGHLIN FOR LIEUTENANT GOVERNOR 2018; GAYLE | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
report_num | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 003 | 000 | 002 | 000 | 001 | 000 | 000 | 002 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||||||||||||||
rpt_date | 2018-04-03 00:00:00 | 2018-05-24 00:00:00 | 2018-05-11 00:00:00 | 2018-05-22 00:00:00 | 2018-02-01 00:00:00 | 2018-04-23 00:00:00 | 2018-06-04 00:00:00 | 2018-04-05 00:00:00 | 2018-04-30 00:00:00 | 2018-04-26 00:00:00 | 2018-05-17 00:00:00 | 2018-06-05 00:00:00 | 2018-05-01 00:00:00 | 2018-06-05 00:00:00 | 2018-01-31 00:00:00 | 2018-06-05 00:00:00 | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 | 2018-07-07 00:00:00 | 2018-04-23 00:00:00 | 2018-05-27 00:00:00 | 2018-05-11 00:00:00 | 2018-05-25 00:00:00 | 2018-07-09 00:00:00 | 2018-09-28 00:00:00 | |||||||||||||||||||||||||
stmt_type | None | PE | PE | None | None | None | None | SA | None | PE | None | PE | None | PE | SA | PE | None | None | PE | None | None | None | None | SA | TS | |||||||||||||||||||||||||
late_rptno | 1-A | None | None | 338 | 001 | 205 | 396 | None | 248 | None | 324 | None | 257 | None | None | None | 2 | 3 | None | 199 | 373 | 305 | 360 | None | None | |||||||||||||||||||||||||
from_date | None | 2018-04-22 00:00:00 | 2018-01-01 00:00:00 | None | None | None | None | 2017-07-01 00:00:00 | None | 2018-01-01 00:00:00 | None | 2018-01-01 00:00:00 | None | 2018-04-22 00:00:00 | 2017-07-01 00:00:00 | 2018-04-22 00:00:00 | None | None | 2018-04-22 00:00:00 | None | None | None | None | 2018-05-20 00:00:00 | 2018-07-01 00:00:00 | |||||||||||||||||||||||||
thru_date | None | 2018-05-19 00:00:00 | 2018-04-21 00:00:00 | None | None | None | None | 2017-12-31 00:00:00 | None | 2018-04-21 00:00:00 | None | 2018-04-21 00:00:00 | None | 2018-05-19 00:00:00 | 2017-12-31 00:00:00 | 2018-05-19 00:00:00 | None | None | 2018-05-19 00:00:00 | None | None | None | None | 2018-06-30 00:00:00 | 2018-09-28 00:00:00 | |||||||||||||||||||||||||
elect_date | None | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | None | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | None | None | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | 2018-06-05 00:00:00 | None | 2018-06-05 00:00:00 | |||||||||||||||||||||||||
filer_city | RICHMOND | Richmond | Richmond | Richmond | RICHMOND | Richmond | Richmond | RICHMOND | Richmond | Richmond | Richmond | Richmond | Richmond | Richmond | RICHMOND | Richmond | RICHMOND | RICHMOND | Richmond | Richmond | Richmond | Richmond | Richmond | Richmond | RICHMOND | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
filer_zip4 | 94804 | 94805 | 94805 | 94805 | 94804 | 94805 | 94805 | 94804 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94804 | 94805 | 94804 | 94804 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94804 | |||||||||||||||||||||||||
filer_phon | 5102364344 | None | None | None | 5102364344 | None | None | 5102364344 | None | None | None | None | None | None | 5102364344 | None | 5102364344 | 5102364344 | None | None | None | None | None | None | 5102364344 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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] | |||||||||||||||||||||||||
mail_city | RICHMOND | Richmond | Richmond | Richmond | RICHMOND | Richmond | Richmond | RICHMOND | Richmond | Richmond | Richmond | Richmond | Richmond | Richmond | RICHMOND | Richmond | RICHMOND | RICHMOND | Richmond | Richmond | Richmond | Richmond | Richmond | Richmond | RICHMOND | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
mail_zip4 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | 94805 | |||||||||||||||||||||||||
tres_naml | None | Kilkenny | Kilkenny | None | None | None | None | Kilkenny | None | Kilkenny | None | Kilkenny | None | Kilkenny | Kilkenny | Kilkenny | None | None | Kilkenny | None | None | None | None | Kilkenny | Kilkenny | |||||||||||||||||||||||||
tres_namf | None | Paul | Paul | None | None | None | None | Paul | None | Paul | None | Paul | None | Paul | Paul | Paul | None | None | Paul | None | None | None | None | Paul | Paul | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
tres_city | None | Richmond | Richmond | None | None | None | None | Richmond | None | Richmond | None | Richmond | None | Richmond | Richmond | Richmond | None | None | Richmond | None | None | None | None | Richmond | Richmond | |||||||||||||||||||||||||
tres_st | None | CA | CA | None | None | None | None | CA | None | CA | None | CA | None | CA | CA | CA | None | None | CA | None | None | None | None | CA | CA | |||||||||||||||||||||||||
tres_zip4 | None | 94804 | 94804 | None | None | None | None | 94804 | None | 94804 | None | 94804 | None | 94804 | 94804 | 94804 | None | None | 94804 | None | None | None | None | 94804 | 94804 | |||||||||||||||||||||||||
tres_phon | None | 510-260-4923 | 510-260-4923 | None | None | None | None | 5102604923 | None | 510-260-4923 | None | 510-260-4923 | None | 510-260-4923 | 5102604923 | 510-260-4923 | None | None | 510-260-4923 | None | None | None | None | 510-260-4923 | 5102604923 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
tres_email | None | kilkennygreen@yahoo,com | kilkennygreen@yahoo,com | None | None | None | None | [email protected] | None | kilkennygreen@yahoo,com | None | kilkennygreen@yahoo,com | None | kilkennygreen@yahoo,com | [email protected] | kilkennygreen@yahoo,com | None | None | kilkennygreen@yahoo,com | None | None | None | None | kilkennygreen@yahoo,com | [email protected] | |||||||||||||||||||||||||
cmtte_type | None | C | C | None | None | None | None | C | None | C | None | C | None | C | C | C | None | None | C | None | None | None | None | C | C | |||||||||||||||||||||||||
control_yn | None | Y | Y | None | None | None | None | Y | None | Y | None | Y | None | Y | Y | Y | None | None | Y | None | None | None | None | Y | Y | |||||||||||||||||||||||||
sponsor_yn | None | N | N | None | None | None | None | N | None | N | None | N | None | N | N | N | None | None | N | None | None | None | None | N | N | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
amendexp_1 | None | None | See Additional Notes | None | None | None | None | Unitemized Monetary Contributions correction | None | None | None | See Additional Notes | None | See Additional Notes | None | See Additional Notes | None | None | See Additional Notes | 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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
cand_naml | None | McLaughlin | McLaughlin | None | None | None | None | McLaughlin | None | McLaughlin | None | McLaughlin | None | McLaughlin | McLaughlin | McLaughlin | None | None | McLaughlin | None | None | None | None | McLaughlin | McLaughlin | |||||||||||||||||||||||||
cand_namf | None | Gayle | Gayle | None | None | None | None | Gayle | None | Gayle | None | Gayle | None | Gayle | Gayle | Gayle | None | None | Gayle | None | None | None | None | Gayle | Gayle | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
cand_city | None | Richmond | Richmond | None | None | None | None | Richmond | None | Richmond | None | Richmond | None | Richmond | Richmond | Richmond | None | None | Richmond | None | None | None | None | Richmond | Richmond | |||||||||||||||||||||||||
cand_st | None | CA | CA | None | None | None | None | CA | None | CA | None | CA | None | CA | CA | CA | None | None | CA | None | None | None | None | CA | CA | |||||||||||||||||||||||||
cand_zip4 | None | 94804 | 94804 | None | None | None | None | 94804 | None | 94804 | None | 94804 | None | 94804 | 94804 | 94804 | None | None | 94804 | None | None | None | None | 94804 | 94804 | |||||||||||||||||||||||||
cand_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
cand_email | None | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | None | [email protected] | None | [email protected] | None | [email protected] | None | None | [email protected] | None | None | None | None | [email protected] | 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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
office_cd | None | LTG | LTG | None | None | None | None | LTG | None | LTG | None | LTG | None | LTG | LTG | LTG | None | None | LTG | None | None | None | None | LTG | LTG | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
juris_cd | None | STW | STW | None | None | None | None | STW | None | STW | None | STW | None | STW | STW | STW | None | None | STW | None | None | None | None | STW | STW | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
dist_no | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||
off_s_h_cd | None | S | S | None | None | None | None | None | None | S | None | S | None | S | None | S | None | None | S | None | None | None | None | S | 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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 |
filer_id | 1396385 | 1396385 | 1396385 | |||
---|---|---|---|---|---|---|
adrid | 2432105 | 2436196 | 2436195 | |||
effect_dt | 2017-05-05 00:00:00 | 2017-05-30 00:00:00 | 2017-05-30 00:00:00 | |||
add_type | 7051 | 7082 | 7051 | |||
session_id | 2017 | 2017 | 2017 |
filer_id | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2238360 | 2250161 | 2251735 | 2301407 | 2238360 | 2259092 | 2238360 | 2248706 | 2231353 | 2232665 | 2254597 | 2211460 | 2253969 | 2212436 | 2261299 | 2261300 | 2240815 | 2211460 | 2158945 | 2161642 | 2163597 | 2162806 | 2261300 | 2244336 | 2263199 | 2169205 | 2302657 | 2253969 | 2234225 | 2255540 | 2227740 | 2297790 | 2238360 | 2261299 | 2267636 | 2214742 | 2234085 | 2253969 | 2613422 | |||||||||||||||||||||||||||||||||||||||
period_id | 233 | 234 | 234 | None | 233 | 234 | 233 | 234 | 234 | 234 | 234 | 231 | 234 | 233 | None | None | 234 | 231 | None | None | None | None | None | 234 | 234 | None | None | 234 | 234 | 234 | 234 | 235 | 234 | None | None | None | 234 | 234 | None | |||||||||||||||||||||||||||||||||||||||
form_id | F460 | F497 | F497 | F460 | F460 | F497 | F460 | F497 | F497 | F497 | F497 | F460 | F460 | F497 | F460 | F460 | F497 | F460 | F410 | F410 | F410 | F410 | F460 | F497 | F460 | F460 | F410 | F460 | F497 | F497 | F497 | F460 | F460 | F460 | F460 | F460 | F497 | F460 | F666 | |||||||||||||||||||||||||||||||||||||||
filing_sequence | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 2 | 0 | |||||||||||||||||||||||||||||||||||||||
filing_date | 2018-05-11 00:00:00 | 2018-05-17 00:00:00 | 2018-05-22 00:00:00 | 2018-09-28 00:00:00 | 2018-04-26 00:00:00 | 2018-06-04 00:00:00 | 2018-06-05 00:00:00 | 2018-05-11 00:00:00 | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 | 2018-05-25 00:00:00 | 2018-01-31 00:00:00 | 2018-05-24 00:00:00 | 2018-02-01 00:00:00 | 2018-06-15 00:00:00 | 2018-06-15 00:00:00 | 2018-04-30 00:00:00 | 2018-04-05 00:00:00 | 2017-05-05 00:00:00 | 2017-05-17 00:00:00 | 2017-06-12 00:00:00 | 2017-05-30 00:00:00 | 2018-06-18 00:00:00 | 2018-05-01 00:00:00 | 2018-07-09 00:00:00 | 2017-07-17 00:00:00 | 2018-10-01 00:00:00 | 2018-06-05 00:00:00 | 2018-04-23 00:00:00 | 2018-05-27 00:00:00 | 2018-04-03 00:00:00 | 2018-09-28 00:00:00 | 2018-06-05 00:00:00 | 2018-07-12 00:00:00 | 2018-07-12 00:00:00 | 2018-01-31 00:00:00 | 2018-04-23 00:00:00 | 2018-07-07 00:00:00 | 2021-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||
stmnt_type | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10005 | 10001 | 10002 | 10005 | 10006 | 10006 | 10006 | 10006 | 10001 | 10001 | 10005 | 10003 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10005 | 10005 | 10001 | 10002 | 10005 | |||||||||||||||||||||||||||||||||||||||
stmnt_status | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||
session_id | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | |||||||||||||||||||||||||||||||||||||||
user_id | CAFILER | RGEREMIA | RGEREMIA | LBARTHOL | KBANH | RGEREMIA | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | HSTOVALL | KBANH | RGEREMIA | SARRIAGA | SARRIAGA | CAFILER | CAFILER | CPON | TRAMON | LPALMER | TRAMON | SARRIAGA | CAFILER | HSTOVALL | SARRIAGA | TRAMON | CAFILER | CAFILER | CAFILER | CAFILER | LBARTHOL | CAFILER | HSTOVALL | HSTOVALL | HSTOVALL | CAFILER | CAFILER | AROBERTS | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
fine_audit | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||
rpt_start | 2018-01-01 00:00:00 | 2018-05-17 00:00:00 | 2018-05-22 00:00:00 | 2018-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-06-04 00:00:00 | 2018-01-01 00:00:00 | 2018-05-11 00:00:00 | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 | 2018-05-25 00:00:00 | 2017-07-01 00:00:00 | 2018-04-22 00:00:00 | 2018-02-01 00:00:00 | 2018-04-22 00:00:00 | 2018-01-01 00:00:00 | 2018-04-30 00:00:00 | 2017-07-01 00:00:00 | None | None | None | None | 2018-01-01 00:00:00 | 2018-05-01 00:00:00 | 2018-05-20 00:00:00 | 2017-01-01 00:00:00 | None | 2018-04-22 00:00:00 | 2018-04-23 00:00:00 | 2018-05-27 00:00:00 | 2018-04-03 00:00:00 | 2018-07-01 00:00:00 | 2018-04-22 00:00:00 | 2018-04-22 00:00:00 | 2018-05-20 00:00:00 | 2017-07-01 00:00:00 | 2018-04-23 00:00:00 | 2018-04-22 00:00:00 | 2017-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||
rpt_end | 2018-04-21 00:00:00 | 2018-05-17 00:00:00 | 2018-05-22 00:00:00 | 2018-09-28 00:00:00 | 2018-04-21 00:00:00 | 2018-06-04 00:00:00 | 2018-04-21 00:00:00 | 2018-05-11 00:00:00 | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 | 2018-05-25 00:00:00 | 2017-12-31 00:00:00 | 2018-05-19 00:00:00 | 2018-02-01 00:00:00 | 2018-05-19 00:00:00 | 2018-04-21 00:00:00 | 2018-04-30 00:00:00 | 2017-12-31 00:00:00 | None | None | None | None | 2018-04-21 00:00:00 | 2018-05-01 00:00:00 | 2018-06-30 00:00:00 | 2017-06-30 00:00:00 | None | 2018-05-19 00:00:00 | 2018-04-23 00:00:00 | 2018-05-27 00:00:00 | 2018-04-03 00:00:00 | 2018-09-28 00:00:00 | 2018-05-19 00:00:00 | 2018-05-19 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-04-23 00:00:00 | 2018-05-19 00:00:00 | 2018-06-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||
rpt_date | 2018-05-11 00:00:00 | 2018-05-17 00:00:00 | 2018-05-22 00:00:00 | None | 2018-04-26 00:00:00 | 2018-06-04 00:00:00 | 2018-06-05 00:00:00 | 2018-05-11 00:00:00 | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 | 2018-05-25 00:00:00 | 2018-01-31 00:00:00 | 2018-05-24 00:00:00 | 2018-02-01 00:00:00 | None | None | 2018-04-30 00:00:00 | 2018-04-05 00:00:00 | None | None | None | None | None | 2018-05-01 00:00:00 | 2018-07-09 00:00:00 | None | None | 2018-06-05 00:00:00 | 2018-04-23 00:00:00 | 2018-05-27 00:00:00 | 2018-04-03 00:00:00 | 2018-09-28 00:00:00 | 2018-06-05 00:00:00 | None | None | None | 2018-04-23 00:00:00 | 2018-07-07 00:00:00 | None | |||||||||||||||||||||||||||||||||||||||
filing_type | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22006 | 22006 | 22001 | 22006 | 22001 | 22006 | None | None | 22001 | 22006 | None | None | None | None | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22006 | 22006 | 22001 | None | None | None | 22001 | 22001 | None |
filer_id | 1396385 | 1396385 | 1396385 | |||
---|---|---|---|---|---|---|
filer_type | 16 | 16 | 16 | |||
active | T | Y | Y | |||
race | 0 | 0 | 0 | |||
session_id | 2017 | 2017 | 2017 | |||
category | 40002 | 40002 | 40002 | |||
category_type | 40502 | 40502 | 40502 | |||
sub_category | 0 | 0 | 0 | |||
effect_dt | 2018-09-28 00:00:00 | 2017-05-30 00:00:00 | 2017-05-05 00:00:00 | |||
sub_category_type | 0 | 0 | 0 | |||
election_type | 0 | 0 | 0 | |||
sub_category_a | None | None | None | |||
nyq_dt | 2017-05-18 00:00:00 | 2017-05-18 00:00:00 | None | |||
party_cd | 16012 | 16012 | 16012 | |||
county_cd | 18015 | 18015 | 18015 | |||
district_cd | 0 | 0 | 0 |
filer_id | 1396385 | |
---|---|---|
xref_id | 1396385 | |
effect_dt | 2017-05-08 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | ||||||
filer_type | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | ||||||
status | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | ||||||
effect_dt | 2018-09-28 00:00:00 | 2018-09-28 00:00:00 | 2018-09-28 00:00:00 | 2018-09-28 00:00:00 | 2018-09-28 00:00:00 | 2018-09-28 00:00:00 | ||||||
naml | MC LAUGHLIN FOR LIEUTENANT GOVERNOR 2018; GAYLE | MC LAUGHLIN FOR LIEUTENANT GOVERNOR 2018; GAYLE | MC LAUGHLIN FOR LIEUTENANT GOVERNOR 2018; GAYLE | MC LAUGHLIN FOR LIEUTENANT GOVERNOR 2018 EXPLORATORY COMMITTEE; GAYLE | MC LAUGHLIN FOR LIEUTENANT GOVERNOR 2018 EXPLORATORY COMMITTEE; GAYLE | MC LAUGHLIN FOR LIEUTENANT GOVERNOR 2018 EXPLORATORY COMMITTEE; GAYLE | ||||||
namf | None | None | None | None | None | None | ||||||
namt | None | None | None | None | None | None | ||||||
nams | None | None | None | None | None | None | ||||||
adr1 | None | None | None | None | None | None | ||||||
adr2 | None | None | None | None | None | None | ||||||
city | RICHMOND | RICHMOND | RICHMOND | RICHMOND | RICHMOND | RICHMOND | ||||||
st | CA | CA | CA | CA | CA | CA | ||||||
zip4 | 94804 | 94804 | 94805 | 94804 | 94804 | 94805 | ||||||
phon | 5102364344 | 5102364344 | 5102364344 | 5102364344 | ||||||||
fax | None | None | None | None | None | None | ||||||
[email protected] | [email protected] | None | [email protected] | [email protected] | None |
filer_id | 1396385 |
---|
filer_id | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | 1396385 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 134670.cal | 2231353_0.cal | 2232665_0.cal | 2212436_0.cal | 133531.cal | 2227740_0.cal | ||||||
received_date | 2018-06-05 00:00:00 | 2018-04-14 00:00:00 | 2018-04-18 00:00:00 | 2018-02-01 00:00:00 | 2018-06-05 00:00:00 | 2018-04-03 00:00:00 | ||||||
filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | ||||||
filing_id | None | 2231353 | 2232665 | 2212436 | None | 2227740 | ||||||
form_id | None | F497 | F497 | F497 | None | F497 | ||||||
receive_comment | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted |