| filing_id | 2252167 | 2225602 | 2236790 | 2218843 | 2228640 | 2234497 | 2253919 | 2223163 | 2250585 | 2231090 | 2236790 | 2276254 | 2276223 | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 1 | 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 | F460 | F497 | F497 | F497 | F460 | F497 | F497 | F497 | F460 | F460 | F460 | |||||||||||||
| filer_id | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | |||||||||||||
| entity_cd | CAO | CAO | CAO | CAO | CAO | CAO | CAO | CAO | CAO | CAO | CAO | CAO | CAO | |||||||||||||
| filer_naml | Lydia Ortega for Lt Governor 2018 | Lydia Ortega for Lt Governor 2018 | Lydia Ortega for Lt Governor 2018 | Lydia Ortega for Lt Governor 2018 | Lydia Ortega for Lt Governor 2018 | Lydia Ortega for Lt Governor 2018 | Lydia Ortega for Lt Governor 2018 | Lydia Ortega for Lt Governor 2018 | Lydia Ortega for Lt Governor 2018 | Lydia Ortega for Lt Governor 2018 | Lydia Ortega for Lt Governor 2018 | Lydia Ortega for Lt Governor 2018 | Lydia Ortega for Lt Governor 2018 | |||||||||||||
| 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 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||
| rpt_date | 2018-05-22 00:00:00 | 2018-03-27 00:00:00 | 2018-05-23 00:00:00 | 2018-02-27 00:00:00 | 2018-04-05 00:00:00 | 2018-04-23 00:00:00 | 2018-05-23 00:00:00 | 2018-03-18 00:00:00 | 2018-05-18 00:00:00 | 2018-04-13 00:00:00 | 2018-04-24 00:00:00 | 2018-07-20 00:00:00 | 2018-07-20 00:00:00 | |||||||||||||
| stmt_type | None | None | PE | None | None | None | PE | None | None | None | PE | TS | SA | |||||||||||||
| late_rptno | 38 | 9 | None | 7 | 13 | 17 | None | 8 | 33 | 14 | None | None | None | |||||||||||||
| from_date | None | None | 2018-01-01 00:00:00 | None | None | None | 2018-04-22 00:00:00 | None | None | None | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-05-20 00:00:00 | |||||||||||||
| thru_date | None | None | 2018-04-21 00:00:00 | None | None | None | 2018-05-19 00:00:00 | None | None | None | 2018-04-21 00:00:00 | 2018-07-20 00:00:00 | 2018-06-30 00:00:00 | |||||||||||||
| elect_date | 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 | |||||||||||||
| filer_city | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | |||||||||||||
| filer_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||
| filer_zip4 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | |||||||||||||
| filer_phon | 209-656-1542 | 209-656-1542 | 209-656-1542 | 209-656-1542 | 209-656-1542 | 209-656-1542 | 209-656-1542 | 209-656-1542 | 209-656-1542 | 209-656-1542 | 209-656-1542 | 209-656-1542 | 209-656-1542 | |||||||||||||
| 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] | [email protected] | |||||||||||||
| mail_city | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | Hilmar | |||||||||||||
| mail_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||
| mail_zip4 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | 95324 | |||||||||||||
| tres_naml | None | None | Lawler | None | None | None | Lawler | None | None | None | Lawler | Lawler | Lawler | |||||||||||||
| tres_namf | None | None | Kelly | None | None | None | Kelly | None | None | None | Kelly | Kelly | Kelly | |||||||||||||
| 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 | None | None | Hilmar | None | None | None | Hilmar | None | None | None | Hilmar | Hilmar | Hilmar | |||||||||||||
| tres_st | None | None | CA | None | None | None | CA | None | None | None | CA | CA | CA | |||||||||||||
| tres_zip4 | None | None | 95324 | None | None | None | 95324 | None | None | None | 95324 | 95324 | 95324 | |||||||||||||
| tres_phon | None | None | 209-656-1542 | None | None | None | 209-656-1542 | None | None | None | 209-656-1542 | 209-656-1542 | 209-656-1542 | |||||||||||||
| 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 | None | |||||||||||||
| cmtte_type | None | None | C | None | None | None | C | None | None | None | C | C | C | |||||||||||||
| control_yn | None | None | Y | None | None | None | Y | None | None | None | Y | Y | Y | |||||||||||||
| sponsor_yn | None | None | N | None | None | None | N | None | None | None | N | N | N | |||||||||||||
| primfrm_yn | 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 | |||||||||||||
| amendexp_1 | None | None | See Additional Notes | 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 | Ortega | None | None | None | Ortega | None | None | None | Ortega | Ortega | Ortega | |||||||||||||
| cand_namf | None | None | Lydia | None | None | None | Lydia | None | None | None | Lydia | Lydia | Lydia | |||||||||||||
| 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 | Sunnyvale | None | None | None | Sunnyvale | None | None | None | Sunnyvale | Sunnyvale | Sunnyvale | |||||||||||||
| cand_st | None | None | CA | None | None | None | CA | None | None | None | CA | CA | CA | |||||||||||||
| cand_zip4 | None | None | 94087 | None | None | None | 94087 | None | None | None | 94087 | 94087 | 94087 | |||||||||||||
| cand_phon | 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 | |||||||||||||
| cand_email | None | None | None | 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 | |||||||||||||
| 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 | LTG | None | None | None | LTG | None | None | None | LTG | LTG | LTG | |||||||||||||
| offic_dscr | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
| juris_cd | None | None | STW | None | None | None | STW | None | None | None | STW | STW | 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 | S | None | None | None | S | None | None | None | S | S | S | |||||||||||||
| 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 |
| filing_id | 2276257 | |
|---|---|---|
| amend_id | 0 | |
| rec_type | CVR | |
| form_type | F410 | |
| filer_id | 1401626 | |
| entity_cd | COM | |
| filer_naml | Lydia Ortega for Lt Governor 2018 | |
| filer_namf | None | |
| filer_namt | None | |
| filer_nams | None | |
| report_num | 000 | |
| rpt_date | 2018-07-20 00:00:00 | |
| qual_cb | X | |
| qualfy_dt | 2018-01-02 00:00:00 | |
| term_date | 2018-07-20 00:00:00 | |
| city | Hilmar | |
| st | CA | |
| zip4 | 95324 | |
| phone | 209-656-1542 | |
| county_res | Santa Clara | |
| county_act | None | |
| mail_city | Hilmar | |
| mail_st | CA | |
| mail_zip4 | 95324 | |
| cmte_fax | None | |
| cmte_email | [email protected]; | |
| tres_naml | Lawler | |
| tres_namf | Kelly | |
| tres_namt | None | |
| tres_nams | None | |
| tres_city | Hilmar | |
| tres_st | CA | |
| tres_zip4 | 95324 | |
| tres_phon | 209-656-1542 | |
| actvty_lvl | None | |
| com82013yn | None | |
| com82013nm | None | |
| com82013id | None | |
| control_cb | None | |
| bank_nam | None | |
| bank_adr1 | None | |
| bank_adr2 | None | |
| bank_city | None | |
| bank_st | None | |
| bank_zip4 | None | |
| bank_phon | None | |
| acct_opendt | None | |
| surplusdsp | None | |
| primfc_cb | X | |
| genpurp_cb | None | |
| gpc_descr | None | |
| sponsor_cb | None | |
| brdbase_cb | None | |
| smcont_qualdt | None |
| filer_id | 1401626 | 1401626 | ||
|---|---|---|---|---|
| adrid | 2461001 | 2444375 | ||
| effect_dt | 2018-08-02 00:00:00 | 2018-01-22 00:00:00 | ||
| add_type | 7051 | 7051 | ||
| session_id | 2017 | 2017 |
| filer_id | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | 1401626 | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 2218843 | 2250585 | 2252167 | 2236790 | 2276254 | 2244644 | 2281262 | 2281266 | 2223163 | 2276223 | 2204793 | 2236790 | 2276257 | 2231090 | 2228640 | 2234497 | 2253919 | 2256142 | 2244644 | 2280908 | 2225602 | 2613429 | ||||||||||||||||||||||
| period_id | 233 | 234 | 234 | 233 | 235 | None | None | None | 233 | 234 | None | 233 | 235 | 234 | 234 | 234 | 234 | None | None | None | 233 | None | ||||||||||||||||||||||
| form_id | F497 | F497 | F497 | F460 | F460 | F460 | F460 | F460 | F497 | F460 | F410 | F460 | F410 | F497 | F497 | F497 | F460 | F460 | F460 | F410 | F497 | F666 | ||||||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
| filing_date | 2018-02-27 00:00:00 | 2018-05-18 00:00:00 | 2018-05-22 00:00:00 | 2018-05-24 00:00:00 | 2018-07-31 00:00:00 | 2018-05-30 00:00:00 | 2018-07-31 00:00:00 | 2018-07-31 00:00:00 | 2018-03-18 00:00:00 | 2018-07-31 00:00:00 | 2018-01-22 00:00:00 | 2018-04-26 00:00:00 | 2018-07-31 00:00:00 | 2018-04-13 00:00:00 | 2018-04-05 00:00:00 | 2018-04-24 00:00:00 | 2018-05-24 00:00:00 | 2018-05-24 00:00:00 | 2018-04-25 00:00:00 | 2018-08-02 00:00:00 | 2018-03-27 00:00:00 | 2021-09-30 00:00:00 | ||||||||||||||||||||||
| stmnt_type | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10003 | 10001 | 10005 | ||||||||||||||||||||||
| stmnt_status | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 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 | ||||||||||||||||||||||
| user_id | CAFILER | CAFILER | CAFILER | CAFILER | HSTOVALL | HSTOVALL | HSTOVALL | HSTOVALL | CAFILER | HSTOVALL | PADAMS | LBARTHOL | CAFILER | CAFILER | CAFILER | CAFILER | HSTOVALL | HSTOVALL | LBARTHOL | TRAMON | 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 | ||||||||||||||||||||||
| fine_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||
| rpt_start | 2018-02-27 00:00:00 | 2018-05-18 00:00:00 | 2018-05-22 00:00:00 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-05-20 00:00:00 | 2018-03-18 00:00:00 | 2018-05-20 00:00:00 | None | 2018-01-01 00:00:00 | 2018-07-20 00:00:00 | 2018-04-13 00:00:00 | 2018-04-05 00:00:00 | 2018-04-23 00:00:00 | 2018-04-22 00:00:00 | 2018-04-22 00:00:00 | 2018-01-01 00:00:00 | None | 2018-03-27 00:00:00 | 2018-01-01 00:00:00 | ||||||||||||||||||||||
| rpt_end | 2018-02-27 00:00:00 | 2018-05-18 00:00:00 | 2018-05-22 00:00:00 | 2018-04-21 00:00:00 | 2018-07-20 00:00:00 | 2018-04-21 00:00:00 | 2018-07-20 00:00:00 | 2018-06-30 00:00:00 | 2018-03-18 00:00:00 | 2018-06-30 00:00:00 | None | 2018-04-21 00:00:00 | 2018-07-20 00:00:00 | 2018-04-13 00:00:00 | 2018-04-05 00:00:00 | 2018-04-23 00:00:00 | 2018-05-19 00:00:00 | 2018-05-19 00:00:00 | 2018-04-21 00:00:00 | None | 2018-03-27 00:00:00 | 2018-07-20 00:00:00 | ||||||||||||||||||||||
| rpt_date | 2018-02-27 00:00:00 | 2018-05-18 00:00:00 | 2018-05-22 00:00:00 | 2018-05-23 00:00:00 | 2018-07-20 00:00:00 | None | None | None | 2018-03-18 00:00:00 | 2018-07-20 00:00:00 | None | 2018-04-24 00:00:00 | None | 2018-04-13 00:00:00 | 2018-04-05 00:00:00 | 2018-04-23 00:00:00 | 2018-05-23 00:00:00 | None | None | None | 2018-03-27 00:00:00 | None | ||||||||||||||||||||||
| filing_type | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | 22001 | None |
| filer_id | 1401626 | 1401626 | ||
|---|---|---|---|---|
| filer_type | 16 | 16 | ||
| active | T | Y | ||
| race | 0 | 0 | ||
| session_id | 2017 | 2017 | ||
| category | 40002 | 40002 | ||
| category_type | 40502 | 40502 | ||
| sub_category | 0 | 0 | ||
| effect_dt | 2018-07-20 00:00:00 | 2018-01-22 00:00:00 | ||
| sub_category_type | 0 | 0 | ||
| election_type | 0 | 0 | ||
| sub_category_a | None | None | ||
| nyq_dt | 2018-01-02 00:00:00 | 2018-01-02 00:00:00 | ||
| party_cd | 16002 | 16002 | ||
| county_cd | 18030 | 18030 | ||
| district_cd | 0 | 0 |
| filer_id | 1401626 | |
|---|---|---|
| xref_id | 1401626 | |
| effect_dt | 2018-01-24 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1401626 | 1401626 | ||
|---|---|---|---|---|
| filer_id | 1401626 | 1401626 | ||
| filer_type | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | ||
| status | TERMINATED | TERMINATED | ||
| effect_dt | 2018-07-20 00:00:00 | 2018-07-20 00:00:00 | ||
| naml | ORTEGA FOR LT GOVERNOR 2018; LYDIA | ORTEGA FOR LT GOVERNOR 2018; LYDIA | ||
| namf | None | None | ||
| namt | None | None | ||
| nams | None | None | ||
| adr1 | None | None | ||
| adr2 | None | None | ||
| city | HILMAR | HILMAR | ||
| st | CA | CA | ||
| zip4 | 95324 | 95324 | ||
| phon | 2096561542 | 2096561542 | ||
| fax | None | None | ||
| [email protected] | [email protected] |
| filer_id | 1401626 |
|---|