Home
Filing ID: 2743235
PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2743235&amendid=0
Table: cvr2_campaign_disclosure
| filing_id |
| 2743235 |
| amend_id |
| 0 |
| line_item |
| 1 |
| rec_type |
| CVR2 |
| form_type |
| F460 |
| tran_id |
| 1 |
| entity_cd |
| CAO |
| title |
| None |
| mail_city |
| None |
| mail_st |
| None |
| mail_zip4 |
| None |
| f460_part |
| 5A |
| cmte_id |
| None |
| enty_naml |
| GUERRERO |
| enty_namf |
| JACK |
| enty_namt |
| None |
| enty_nams |
| None |
| enty_city |
| CUDAHY |
| enty_st |
| CA |
| enty_zip4 |
| 90201 |
| enty_phon |
| None |
| enty_fax |
| None |
| enty_email |
| None |
| tres_naml |
| None |
| tres_namf |
| None |
| tres_namt |
| None |
| tres_nams |
| None |
| control_yn |
| N |
| office_cd |
| TRE |
| offic_dscr |
| None |
| juris_cd |
| STW |
| juris_dscr |
| None |
| dist_no |
| None |
| off_s_h_cd |
| None |
| bal_name |
| None |
| bal_num |
| None |
| bal_juris |
| None |
| sup_opp_cd |
| None |
|
Table: cvr3_verification_info
| filing_id |
| 2743235 |
| 2743235 |
| amend_id |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| rec_type |
| CVR3 |
| CVR3 |
| form_type |
| F460 |
| F460 |
| tran_id |
| 44 |
| 45 |
| entity_cd |
| TRE |
| CAO |
| sig_date |
| 2022-10-27 00:00:00 |
| 2022-10-27 00:00:00 |
| sig_loc |
| None |
| None |
| sig_naml |
| GUERRERO |
| GUERRERO |
| sig_namf |
| JACK |
| JACK |
| sig_namt |
| None |
| None |
| sig_nams |
| None |
| None |
|
Table: cvr_campaign_disclosure
| filing_id |
| 2743235 |
| amend_id |
| 0 |
| rec_type |
| CVR |
| form_type |
| F460 |
| filer_id |
| 1445421 |
| entity_cd |
| RCP |
| filer_naml |
| GUERRERO FOR TREASURER 2022 |
| filer_namf |
| None |
| filer_namt |
| None |
| filer_nams |
| None |
| report_num |
| 000 |
| rpt_date |
| 2022-10-27 00:00:00 |
| stmt_type |
| PE |
| late_rptno |
| None |
| from_date |
| 2022-09-25 00:00:00 |
| thru_date |
| 2022-10-22 00:00:00 |
| elect_date |
| 2022-11-08 00:00:00 |
| filer_city |
| CUDAHY |
| filer_st |
| CA |
| filer_zip4 |
| 90201 |
| filer_phon |
| 3238212670 |
| filer_fax |
| None |
| file_email |
| jack4treasurer@gmail.com |
| mail_city |
| CUDAHY |
| mail_st |
| CA |
| mail_zip4 |
| 90201 |
| tres_naml |
| GUERRERO |
| tres_namf |
| JACK |
| tres_namt |
| None |
| tres_nams |
| None |
| tres_city |
| CUDAHY |
| tres_st |
| CA |
| tres_zip4 |
| 90201 |
| tres_phon |
| 3238212670 |
| tres_fax |
| None |
| tres_email |
| jack4treasurer@gmail.com |
| cmtte_type |
| C |
| control_yn |
| Y |
| sponsor_yn |
| N |
| primfrm_yn |
| None |
| brdbase_yn |
| None |
| amendexp_1 |
| None |
| amendexp_2 |
| None |
| amendexp_3 |
| None |
| rpt_att_cb |
| None |
| cmtte_id |
| None |
| reportname |
| None |
| rptfromdt |
| None |
| rptthrudt |
| None |
| emplbus_cb |
| None |
| bus_name |
| None |
| bus_city |
| None |
| bus_st |
| None |
| bus_zip4 |
| None |
| bus_inter |
| None |
| busact_cb |
| None |
| busactvity |
| None |
| assoc_cb |
| None |
| assoc_int |
| None |
| other_cb |
| None |
| other_int |
| None |
| cand_naml |
| GUERRERO |
| cand_namf |
| JACK |
| cand_namt |
| None |
| cand_nams |
| None |
| cand_city |
| CUDAHY |
| cand_st |
| CA |
| cand_zip4 |
| 90201 |
| cand_phon |
| None |
| cand_fax |
| None |
| cand_email |
| None |
| bal_name |
| None |
| bal_num |
| None |
| bal_juris |
| None |
| office_cd |
| TRE |
| offic_dscr |
| None |
| juris_cd |
| STW |
| juris_dscr |
| None |
| dist_no |
| None |
| off_s_h_cd |
| None |
| sup_opp_cd |
| None |
| employer |
| None |
| occupation |
| None |
| selfemp_cb |
| None |
| bal_id |
| None |
| cand_id |
| None |
|
Table: debt
| filing_id |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| rec_type |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| form_type |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| tran_id |
| 36 |
| 37 |
| 38 |
| 39 |
| 40 |
| 41 |
| 42 |
| 43 |
| entity_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_naml |
| GUERRERO |
| GUERRERO |
| GUERRERO |
| GUERRERO |
| GUERRERO |
| GUERRERO |
| GUERRERO |
| GUERRERO |
| payee_namf |
| JACK |
| JACK |
| JACK |
| JACK |
| JACK |
| JACK |
| JACK |
| JACK |
| payee_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_city |
| CUDAHY |
| CUDAHY |
| CUDAHY |
| CUDAHY |
| CUDAHY |
| CUDAHY |
| CUDAHY |
| CUDAHY |
| payee_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| payee_zip4 |
| 90201 |
| 90201 |
| 90201 |
| 90201 |
| 90201 |
| 90201 |
| 90201 |
| 90201 |
| beg_bal |
| 0 |
| 440 |
| 0 |
| 2892 |
| 3475 |
| 3497 |
| 0 |
| 0 |
| amt_incur |
| 733 |
| 212 |
| 47 |
| 0 |
| 0 |
| 0 |
| 132 |
| 11 |
| amt_paid |
| 733 |
| 77 |
| 47 |
| 0 |
| 0 |
| 0 |
| 132 |
| 11 |
| end_bal |
| 0 |
| 574 |
| 0 |
| 2892 |
| 3475 |
| 3497 |
| 0 |
| 0 |
| expn_code |
| TRC |
| TRS |
| WEB |
| CMP |
| FIL |
| FIL |
| MTG |
| POS |
| expn_dscr |
| LODGING, TRAVEL, MEALS, PARKING |
| MEALS - STAFF & VOLUNTEERS |
| WEBSITE AND DESIGN |
| PRINTING, BANNERS & SIGNS |
| BALLOT STATEMENT - VIG |
| INITIAL CANDIDATE FILING |
| Registration for events/ conferences |
| Postage, US Postal Service |
| cmte_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| memo_code |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| memo_refno |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bakref_tid |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| xref_schnm |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| xref_match |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: expn
| filing_id |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| rec_type |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| form_type |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| tran_id |
| 25 |
| 26 |
| 27 |
| 28 |
| 29 |
| 30 |
| 31 |
| 32 |
| 33 |
| 34 |
| 35 |
| entity_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_naml |
| BANK OF AMERICA |
| CASA DEL SOL COCINA MEXICANA |
| NEXTDAY FLYERS |
| 10/22/2022 |
| SOUTHWEST AIRLINES |
| GUERRERO |
| GUERRERO |
| GUERRERO |
| GUERRERO |
| GUERRERO |
| NATIONBUILDER |
| payee_namf |
| None |
| None |
| None |
| NEXTDAYFLYERS |
| None |
| JACK |
| JACK |
| JACK |
| JACK |
| JACK |
| None |
| payee_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_city |
| DOWNEY |
| Tustin |
| VAN NUYS |
| VAN NUYS |
| LOS ANGELES |
| CUDAHY |
| CUDAHY |
| CUDAHY |
| CUDAHY |
| CUDAHY |
| LOS ANGELES |
| payee_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| payee_zip4 |
| 90242 |
| 92782 |
| 91406 |
| 91406 |
| 90045 |
| 90201 |
| 90201 |
| 90201 |
| 90201 |
| 90201 |
| 90071 |
| expn_date |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| amount |
| 16 |
| 1003 |
| 718 |
| 737 |
| 134 |
| 733 |
| 47 |
| 132 |
| 11 |
| 77 |
| 104 |
| cum_ytd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cum_oth |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| expn_chkno |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| expn_code |
| PRO |
| FND |
| LIT |
| CMP |
| TRC |
| TRC |
| WEB |
| MTG |
| POS |
| TRS |
| PRO |
| expn_dscr |
| BANK FEES |
| Restaurant - fundraising event |
| CAMPAIGN LITERATURE |
| CAMPAIGN POSTERS |
| AIRFARE TO BAY AREA FOR CAPMAIGN EVENT |
| REIMBURSEMENT FOR ACCRUED EXPENSES |
| Reimbursement for accrued expenses |
| Reimbursement for accrued expenses |
| Reimbursement for accrued expenses |
| Reimbursement for accrued expenses |
| PAYMENT PROCESSING FEE (CREDIT CARD CONTRIBUTIONS) |
| agent_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| agent_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| agent_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| agent_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cmte_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| office_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| offic_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| juris_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| juris_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| dist_no |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| off_s_h_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bal_name |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bal_num |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bal_juris |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| sup_opp_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| memo_code |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| memo_refno |
| None |
| 26 |
| 27 |
| 28 |
| 29 |
| 30 |
| 31 |
| 32 |
| 33 |
| 34 |
| None |
| bakref_tid |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| g_from_e_f |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| xref_schnm |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| xref_match |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: filer_filings
| filer_id |
| 1445421 |
| filing_id |
| 2743235 |
| period_id |
| 251 |
| form_id |
| F460 |
| filing_sequence |
| 0 |
| filing_date |
| 2022-10-27 00:00:00 |
| stmnt_type |
| 10001 |
| stmnt_status |
| 11003 |
| session_id |
| 2021 |
| user_id |
| CAFILER |
| special_audit |
| 11003 |
| fine_audit |
| 11003 |
| rpt_start |
| 2022-09-25 00:00:00 |
| rpt_end |
| 2022-10-22 00:00:00 |
| rpt_date |
| 2022-10-27 00:00:00 |
| filing_type |
| 22006 |
|
Table: filings
| filing_id |
| 2743235 |
| filing_type |
| 22001 |
|
Table: hdr
| filing_id |
| 2743235 |
| amend_id |
| 0 |
| rec_type |
| HDR |
| ef_type |
| CAL |
| state_cd |
| CA |
| cal_ver |
| 2.01 |
| soft_name |
| CAL-ACCESS OBJECT MODEL |
| soft_ver |
| 1.00 |
| hdrcomment |
| None |
|
Table: rcpt
| filing_id |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 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 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| rec_type |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| form_type |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| tran_id |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| 24 |
| entity_cd |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| RCP |
| RCP |
| RCP |
| IND |
| IND |
| ctrib_naml |
| NEEDS |
| SHIELDS |
| CRAMER |
| ACKER |
| WALLACE |
| LARKIN |
| CASTILLO |
| BARON |
| REYEZ |
| PEEK-JOVANOVIC |
| MONTANO |
| DWYER |
| HANSEN |
| YBANEZ |
| DILLBERG |
| WIDLING |
| LAPEE |
| GREEN |
| LONG BEACH AREA REPUBLICANS |
| SANTA BARBARA REPUBLICAN CLUB |
| ELECT ROBERT HOWELL INSURANCE COMMISSIONER 2022 |
| VASQUEZ |
| MARIN-STEELE |
| ctrib_namf |
| SANDRA |
| ALEXANDRA ZIA |
| MARY |
| DIANA |
| SUSAN |
| KEVIN |
| LETICIA |
| MICHAEL |
| LIZ |
| KIMBER |
| CLAUDIA |
| WALTER |
| DAWN |
| ANA MARIA |
| KENNETH |
| CHARLOTTE |
| PHILLIP |
| ROBERT M |
| None |
| None |
| None |
| SERGIO |
| GLORIA |
| ctrib_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| ctrib_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| ctrib_city |
| ALHAMBRA |
| MONTROSE |
| ANAHEIM |
| NEWPORT BEACH |
| SAN CLEMENTE |
| PEBBLE BEACH |
| CORONA |
| GLENDORA |
| MONTEBELLO |
| LAGUNA NIGUEL |
| NEWPORT BEACH |
| BIG BEAR LAKE |
| SANTA ROSA |
| COVINA |
| TEMECULA |
| SANTA BARBARA |
| ORANGE |
| SAN DIMAS |
| LONG BEACH |
| SANTA BARBARA |
| SAN JOSE |
| DOWNEY |
| TEMPLE CITY |
| ctrib_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| ctrib_zip4 |
| 91801 |
| 91020 |
| 92817 |
| 92663 |
| 92674 |
| 93953 |
| 92879 |
| 91741 |
| 90640 |
| 92677 |
| 92662 |
| 92315 |
| 95404 |
| 91722 |
| 92592 |
| 93111 |
| 92567 |
| 91773 |
| 90803 |
| 93111 |
| 951201783 |
| 90240 |
| 91780 |
| ctrib_emp |
| RETIRED |
| ALEXANDRA ZIA SHIELDS |
| FAMILY CORNER LLC |
| DIANA ACKER |
| SUSAN WALLACE |
| WESTEK ELECTRONICS |
| COUNTY OF RIVERSIDE |
| MICHAEL BARON |
| LOS ANGELES COUNTY |
| PEEK PRODUCTIONS |
| OUR LADY QUEEN OF ANGELS |
| DWYER REAL ESTATE & AMP |
| RETIRED |
| RETIRED |
| RETIRED |
| WIDLING INVESTMENTS |
| RETIRED |
| RETIRED |
| None |
| None |
| None |
| AMIGOS NURSERY |
| RETIRED |
| ctrib_occ |
| RETIRED |
| ARTIST |
| PROPERTY MANAGER |
| BUSINESS OWNER |
| REAL ESTATE AGENT |
| CEO |
| CLINICAL THERAPIST II |
| REAL ESTATE |
| SOCIAL WORKER |
| OWNER |
| LEADER-PRO VIDA |
| BROKER |
| RETIRED |
| RETIRED |
| RETIRED |
| OWNER |
| RETIRED |
| RETIRED |
| None |
| None |
| None |
| OPERATIONS MANAGER |
| RETIRED |
| ctrib_self |
| None |
| X |
| None |
| X |
| X |
| None |
| None |
| X |
| None |
| X |
| None |
| X |
| None |
| None |
| None |
| X |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tran_type |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| rcpt_date |
| 2022-09-26 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-08 00:00:00 |
| 2022-10-09 00:00:00 |
| 2022-10-09 00:00:00 |
| 2022-10-16 00:00:00 |
| 2022-10-22 00:00:00 |
| 2022-10-22 00:00:00 |
| 2022-10-22 00:00:00 |
| 2022-10-22 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-17 00:00:00 |
| date_thru |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| amount |
| 250 |
| 200 |
| 100 |
| 200 |
| 200 |
| 1250 |
| 100 |
| 100 |
| 100 |
| 100 |
| 300 |
| 100 |
| 100 |
| 100 |
| 100 |
| 100 |
| 500 |
| 500 |
| 500 |
| 250 |
| 200 |
| 200 |
| 100 |
| cum_ytd |
| 250 |
| 200 |
| 100 |
| 200 |
| 200 |
| 1250 |
| 100 |
| 100 |
| 100 |
| 100 |
| 300 |
| 100 |
| 100 |
| 100 |
| 100 |
| 100 |
| 1000 |
| 500 |
| 1000 |
| 250 |
| 200 |
| 200 |
| 100 |
| cum_oth |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| ctrib_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cmte_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 1405347 |
| 901559 |
| 1445405 |
| None |
| None |
| tres_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 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 |
| tres_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_emp |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_occ |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_self |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 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 |
| office_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| juris_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 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 |
| off_s_h_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 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 |
| 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 |
| 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 |
| memo_code |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| memo_refno |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bakref_tid |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| xref_schnm |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| xref_match |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| int_rate |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_cmteid |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: smry
| filing_id |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 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 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22A |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 4 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 4 |
| rec_type |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| form_type |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| A |
| A |
| A |
| B1 |
| B1 |
| B1 |
| C |
| C |
| C |
| D |
| D |
| D |
| E |
| E |
| E |
| E |
| F |
| F |
| F |
| H |
| H |
| H |
| I |
| I |
| I |
| I |
| amount_a |
| 6558 |
| 0 |
| 6558 |
| 0 |
| 6558 |
| 3712 |
| 0 |
| 3712 |
| 134 |
| 0 |
| 3846 |
| 4017 |
| 6558 |
| 0 |
| 3712 |
| 6864 |
| 0 |
| 0 |
| 10438 |
| 1955 |
| 11931 |
| 28584 |
| 5650 |
| 908 |
| 6558 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 3712 |
| 0 |
| 0 |
| 3712 |
| 1134 |
| 1000 |
| 134 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| amount_b |
| 22881 |
| 0 |
| 22881 |
| 2129 |
| 25010 |
| 16017 |
| 0 |
| 16017 |
| 10438 |
| 2129 |
| 28584 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 23055 |
| 16653 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| amount_c |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| elec_dt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 2022-11-08 00:00:00 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: splt
| filing_id |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 2743235 |
| 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 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| pform_type |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| ptran_id |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| 24 |
| elec_date |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| elec_amount |
| 250 |
| 200 |
| 100 |
| 200 |
| 200 |
| 1250 |
| 100 |
| 100 |
| 100 |
| 100 |
| 300 |
| 100 |
| 100 |
| 100 |
| 100 |
| 100 |
| 1000 |
| 500 |
| 1000 |
| 250 |
| 200 |
| 200 |
| 100 |
| elec_code |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
|