Home
Filing ID: 2739904
PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2739904&amendid=0
Table: cvr3_verification_info
filing_id |
| 2739904 |
amend_id |
| 0 |
line_item |
| 1 |
rec_type |
| CVR3 |
form_type |
| F460 |
tran_id |
| 30 |
entity_cd |
| TRE |
sig_date |
| 2022-10-24 00:00:00 |
sig_loc |
| None |
sig_naml |
| LOPEZ |
sig_namf |
| JONHENRY |
sig_namt |
| None |
sig_nams |
| None |
|
Table: cvr_campaign_disclosure
filing_id |
| 2739904 |
amend_id |
| 0 |
rec_type |
| CVR |
form_type |
| F460 |
filer_id |
| 870601 |
entity_cd |
| RCP |
filer_naml |
| PLUMBERS AND PIPEFITTERS U.A. LOCAL #246 COPE COMMITTEE |
filer_namf |
| None |
filer_namt |
| None |
filer_nams |
| None |
report_num |
| 000 |
rpt_date |
| 2022-10-24 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 |
| FRESNO |
filer_st |
| CA |
filer_zip4 |
| 93727 |
filer_phon |
| 5592525367 |
filer_fax |
| 5592521155 |
file_email |
| johnhenry@ualocal246.com |
mail_city |
| None |
mail_st |
| None |
mail_zip4 |
| None |
tres_naml |
| LOPEZ |
tres_namf |
| JONHENRY |
tres_namt |
| None |
tres_nams |
| None |
tres_city |
| FRESNO |
tres_st |
| CA |
tres_zip4 |
| 93727 |
tres_phon |
| 5592525367 |
tres_fax |
| 5592521155 |
tres_email |
| jonhenry@ualocal246.com |
cmtte_type |
| G |
control_yn |
| N |
sponsor_yn |
| Y |
primfrm_yn |
| N |
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 |
| None |
cand_namf |
| None |
cand_namt |
| None |
cand_nams |
| None |
cand_city |
| None |
cand_st |
| None |
cand_zip4 |
| None |
cand_phon |
| None |
cand_fax |
| None |
cand_email |
| None |
bal_name |
| None |
bal_num |
| None |
bal_juris |
| None |
office_cd |
| None |
offic_dscr |
| None |
juris_cd |
| None |
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: expn
filing_id |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
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 |
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 |
| 24 |
| 25 |
| 26 |
| 27 |
| 28 |
rec_type |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
form_type |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
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 |
| 25 |
| 26 |
| 27 |
| 28 |
| 29 |
entity_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 |
| None |
| None |
| None |
payee_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| WAMHOFF FOR SUPERVISOR 2022 |
| DESTINY RODRIGUEZ FOR SCCCD AREA 1 |
| ANNA CABALLERO FOR SENATE 2022 |
| SORIA FOR ASSEMBLY 2022 |
| EDDIE VALERO FOR TULARE COUNTY SUPERVISOR 2022 |
| SIGALA FOR ASSEMBLY 2022 |
| SUSAN WITTRUP FOR FRESNO UNIFIED TRUSTEE AREA 7 |
| TIM ROBERTSON FOR SENATE 2022 |
| DELRAY SHELTON FOR CITY COUNCIL 2022 |
| GILBERT FELIX FOR SCCCD TRUSTEE AREA 5, 2022 |
| ROB FUENTES FOR STATE CENTER COMMUNITY COLLEGE DISTRICT 2022 |
| TRUJILLO FOR SELMA CITY COUNCIL 2022 |
| LOUIS FRANCO FOR SELMA CITY COUNCIL DISTRICT 3, 2022 |
| FIX FRESNO ROADS |
payee_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 |
| None |
| None |
| None |
payee_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 |
| None |
| None |
| None |
payee_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 |
| None |
| None |
| None |
payee_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Fresno |
| Fresno |
| FRESNO |
| SACRAMENTO |
| FRESNO |
| TULARE |
| FRESNO |
| SACRAMENTO |
| MERCED |
| FRESNO |
| SACRAMENTO |
| SELMA |
| SELMA |
| SACRAMENTO |
payee_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
payee_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 93721 |
| 93721 |
| 97310 |
| 95815 |
| 93710 |
| 93274 |
| 93704 |
| 95841 |
| 95340 |
| 93744 |
| 95841 |
| 93662 |
| 93662 |
| 95814 |
expn_date |
| 2022-09-27 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-09-28 00:00:00 |
| 2022-09-28 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-19 00:00:00 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
amount |
| 750 |
| 1500 |
| 3000 |
| 2700 |
| 2500 |
| 3000 |
| 1000 |
| 1500 |
| 2867 |
| 750 |
| 750 |
| 500 |
| 500 |
| 2000 |
| 750 |
| 1500 |
| 3000 |
| 2700 |
| 2500 |
| 3000 |
| 1000 |
| 1500 |
| 2867 |
| 750 |
| 750 |
| 500 |
| 500 |
| 2000 |
cum_ytd |
| 750 |
| 2500 |
| 3000 |
| 14700 |
| 2500 |
| 6000 |
| 1000 |
| 11300 |
| 2867 |
| 750 |
| 750 |
| 500 |
| 500 |
| 2000 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
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 |
| None |
| None |
| None |
| None |
| None |
expn_chkno |
| 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 |
expn_code |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
expn_dscr |
| CAMPAIGN CONTRIBUTION |
| CAMPAIGN CONTRIBUTION |
| CAMPAIGN CONTRIBUTION |
| CAMPAIGN CONTRIBUTION |
| CAMPAIGN CONTRIBUTION |
| CAMPAIGN CONTRIBUTION |
| CAMPAIGN CONTRIBUTION |
| CAMPAIGN CONTRIBUTION |
| CAMPAIGN CONTRIBUTION |
| CAMPAIGN CONTRIBUTION |
| CAMPAIGN CONTRIBUTION |
| CAMPAIGN CONTRIBUTION |
| CAMPAIGN CONTRIBUTION |
| CONTRIBUTION |
| MONETARY |
| MONETARY |
| MONETARY |
| MONETARY |
| MONETARY |
| MONETARY |
| MONETARY |
| MONETARY |
| MONETARY |
| MONETARY |
| MONETARY |
| MONETARY |
| MONETARY |
| MONETARY |
agent_naml |
| 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 |
agent_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 |
| None |
| None |
| None |
agent_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 |
| None |
| None |
| None |
agent_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 |
| None |
| None |
| None |
cmte_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 1444749 |
| 1441602 |
| 1414451 |
| 1443835 |
| 1399840 |
| 1443815 |
| 1439677 |
| 1444255 |
| 1411157 |
| 1441511 |
| 1447653 |
| PENDING |
| 1449388 |
| 1452297 |
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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
cand_naml |
| WAMHOFF |
| RODRIGUEZ |
| CABALLERO |
| SORIA |
| VALERO |
| SIGALA |
| WITTRUP |
| ROBERTSON |
| SHELTON |
| FELIX |
| FUENTES |
| TRUJILLO |
| FRANCO |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cand_namf |
| JORDAN |
| DESTINY |
| ANNA |
| ESMERALDA |
| EDDIE |
| JOSE |
| SUSAN |
| TIM |
| DELRAY |
| GILBERT |
| ROB |
| JOHN |
| LOUIS |
| 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 |
| 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 |
| None |
| None |
| None |
office_cd |
| OTH |
| OTH |
| SEN |
| ASM |
| OTH |
| ASM |
| OTH |
| SEN |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
offic_dscr |
| SUPERVISOR |
| STATE CENTER COMMUNITY COLLEGE TRUSTEE |
| None |
| None |
| SUPERVISOR |
| None |
| SCHOOL BOARD TRUSTEE |
| None |
| CITY COUNCIL |
| STATE CENTER COMMUNITY COLLEGE TRUSTEE |
| STATE CENTER COMMUNITY COLLEGE TRUSTEE |
| CITY COUNCIL |
| CITY COUNCIL |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
juris_cd |
| STW |
| LOC |
| SEN |
| ASM |
| CTY |
| ASM |
| STW |
| SEN |
| STW |
| STW |
| STW |
| STW |
| STW |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
juris_dscr |
| None |
| SCCCD AREA 1 |
| None |
| None |
| TULARE DISTRICT 4 |
| 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 |
| 14 |
| 27 |
| None |
| 33 |
| None |
| 4 |
| 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 |
| None |
| None |
| None |
| None |
| None |
bal_name |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| FRESNO COUNTY ROAD REPAIR/TRANSPORTATION IMPROVEMENT |
| 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 |
| C |
| 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 |
| FRESNO COUNTY |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
sup_opp_cd |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| S |
| 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 |
| None |
| None |
| None |
| None |
| None |
memo_refno |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| 24 |
| 25 |
| 26 |
| 27 |
| 28 |
| 29 |
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 |
| None |
| None |
| None |
| None |
| None |
g_from_e_f |
| 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 |
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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
|
Table: filer_filings
filer_id |
| 1043772 |
filing_id |
| 2739904 |
period_id |
| 251 |
form_id |
| F460 |
filing_sequence |
| 0 |
filing_date |
| 2022-10-24 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-24 00:00:00 |
filing_type |
| 22006 |
|
Table: filings
filing_id |
| 2739904 |
filing_type |
| 22001 |
|
Table: hdr
filing_id |
| 2739904 |
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 |
| 2739904 |
amend_id |
| 0 |
line_item |
| 1 |
rec_type |
| RCPT |
form_type |
| A |
tran_id |
| 1 |
entity_cd |
| OTH |
ctrib_naml |
| UA LOCAL #246 PLUMBERS AND PIPEFITTERS |
ctrib_namf |
| None |
ctrib_namt |
| None |
ctrib_nams |
| None |
ctrib_city |
| FRESNO |
ctrib_st |
| CA |
ctrib_zip4 |
| 93727 |
ctrib_emp |
| None |
ctrib_occ |
| None |
ctrib_self |
| None |
tran_type |
| None |
rcpt_date |
| 2022-10-17 00:00:00 |
date_thru |
| None |
amount |
| 5000 |
cum_ytd |
| 45000 |
cum_oth |
| None |
ctrib_dscr |
| None |
cmte_id |
| None |
tres_naml |
| None |
tres_namf |
| None |
tres_namt |
| None |
tres_nams |
| None |
tres_city |
| None |
tres_st |
| None |
tres_zip4 |
| None |
intr_naml |
| None |
intr_namf |
| None |
intr_namt |
| None |
intr_nams |
| None |
intr_city |
| None |
intr_st |
| None |
intr_zip4 |
| None |
intr_emp |
| None |
intr_occ |
| None |
intr_self |
| None |
cand_naml |
| None |
cand_namf |
| None |
cand_namt |
| None |
cand_nams |
| None |
office_cd |
| None |
offic_dscr |
| None |
juris_cd |
| None |
juris_dscr |
| None |
dist_no |
| None |
off_s_h_cd |
| None |
bal_name |
| None |
bal_num |
| None |
bal_juris |
| None |
sup_opp_cd |
| None |
memo_code |
| None |
memo_refno |
| 1 |
bakref_tid |
| None |
xref_schnm |
| None |
xref_match |
| None |
int_rate |
| None |
intr_cmteid |
| None |
|
Table: smry
filing_id |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
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 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 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 |
form_type |
| 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 |
| 5000 |
| 0 |
| 5000 |
| 0 |
| 5000 |
| 23327 |
| 0 |
| 23327 |
| 0 |
| 0 |
| 23327 |
| 39024 |
| 5000 |
| 0 |
| 23327 |
| 20696 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 5000 |
| 0 |
| 5000 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 23317 |
| 10 |
| 23327 |
| 23317 |
| 10 |
| 0 |
| 23327 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
amount_b |
| 45000 |
| 0 |
| 45000 |
| 0 |
| 45000 |
| 74537 |
| 0 |
| 74537 |
| 0 |
| 0 |
| 74537 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 0 |
| 0 |
| 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 |
elec_dt |
| 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 |
|
Table: splt
filing_id |
| 2739904 |
| 2739904 |
| 2739904 |
| 2739904 |
amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
pform_type |
| D |
| D |
| D |
| D |
ptran_id |
| 4 |
| 5 |
| 7 |
| 9 |
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 |
elec_amount |
| 3000 |
| 9700 |
| 3000 |
| 6400 |
elec_code |
| G |
| G |
| G |
| G |
|