Home
Filing ID: 2743659
PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2743659&amendid=0
Table: cvr2_campaign_disclosure
| filing_id |
| 2743659 |
| 2743659 |
| amend_id |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| rec_type |
| CVR2 |
| CVR2 |
| form_type |
| F460 |
| F460 |
| tran_id |
| NIC1 |
| OFC1 |
| entity_cd |
| COM |
| ATR |
| title |
| None |
| None |
| mail_city |
| None |
| None |
| mail_st |
| None |
| None |
| mail_zip4 |
| None |
| None |
| f460_part |
| 5b |
| 3 |
| cmte_id |
| 1422784 |
| None |
| enty_naml |
| Friends of Joe Rubay for Assembly 2020 |
| Copp |
| enty_namf |
| None |
| Logan |
| enty_namt |
| None |
| None |
| enty_nams |
| None |
| None |
| enty_city |
| San Ramon |
| Wilton |
| enty_st |
| CA |
| CA |
| enty_zip4 |
| 94583 |
| 95693 |
| enty_phon |
| 925-914-0181 |
| 916-686-1815 |
| enty_fax |
| None |
| None |
| enty_email |
| None |
| copp.logan@gmail.com |
| tres_naml |
| Copp |
| None |
| tres_namf |
| Vona |
| None |
| tres_namt |
| None |
| None |
| tres_nams |
| None |
| None |
| control_yn |
| Y |
| None |
| office_cd |
| None |
| None |
| offic_dscr |
| None |
| None |
| juris_cd |
| None |
| None |
| juris_dscr |
| None |
| None |
| dist_no |
| None |
| None |
| off_s_h_cd |
| None |
| None |
| bal_name |
| None |
| None |
| bal_num |
| None |
| None |
| bal_juris |
| None |
| None |
| sup_opp_cd |
| None |
| None |
|
Table: cvr3_verification_info
| filing_id |
| 2743659 |
| 2743659 |
| amend_id |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| rec_type |
| CVR3 |
| CVR3 |
| form_type |
| F460 |
| F460 |
| tran_id |
| VER_1.1 |
| VER_2.2 |
| entity_cd |
| TRE |
| CAO |
| sig_date |
| 2022-10-25 00:00:00 |
| 2022-10-22 00:00:00 |
| sig_loc |
| None |
| None |
| sig_naml |
| Vona L. Copp |
| Joseph A. Rubay |
| sig_namf |
| None |
| None |
| sig_namt |
| None |
| None |
| sig_nams |
| None |
| None |
|
Table: cvr_campaign_disclosure
| filing_id |
| 2743659 |
| amend_id |
| 0 |
| rec_type |
| CVR |
| form_type |
| F460 |
| filer_id |
| 1445207 |
| entity_cd |
| CTL |
| filer_naml |
| Friends of Joe Rubay for Assembly 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 |
| San Ramon |
| filer_st |
| CA |
| filer_zip4 |
| 94583 |
| filer_phon |
| 925-914-0181 |
| filer_fax |
| None |
| file_email |
| vonac@comcast.net |
| mail_city |
| Wilton |
| mail_st |
| CA |
| mail_zip4 |
| 95693 |
| tres_naml |
| Copp |
| tres_namf |
| Vona L. |
| tres_namt |
| None |
| tres_nams |
| None |
| tres_city |
| Wilton |
| tres_st |
| CA |
| tres_zip4 |
| 95624 |
| tres_phon |
| 916-686-1815 |
| tres_fax |
| None |
| tres_email |
| None |
| cmtte_type |
| C |
| control_yn |
| Y |
| sponsor_yn |
| N |
| primfrm_yn |
| N |
| brdbase_yn |
| N |
| 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 |
| Rubay |
| cand_namf |
| Joseph A. |
| cand_namt |
| None |
| cand_nams |
| None |
| cand_city |
| San Ramon |
| cand_st |
| CA |
| cand_zip4 |
| 94583 |
| cand_phon |
| 925-914-0181 |
| cand_fax |
| None |
| cand_email |
| rubay@usa.com |
| bal_name |
| None |
| bal_num |
| None |
| bal_juris |
| None |
| office_cd |
| ASM |
| offic_dscr |
| None |
| juris_cd |
| ASM |
| juris_dscr |
| None |
| dist_no |
| 16 |
| off_s_h_cd |
| S |
| sup_opp_cd |
| None |
| employer |
| None |
| occupation |
| None |
| selfemp_cb |
| None |
| bal_id |
| None |
| cand_id |
| None |
|
Table: debt
| filing_id |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| rec_type |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| form_type |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| tran_id |
| PAY24 |
| PAY46 |
| PAY47 |
| PAY48 |
| PAY80 |
| PAY81 |
| PAY82 |
| PAY118 |
| PAY119 |
| entity_cd |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| payee_naml |
| Copp |
| Copp |
| Copp |
| Copp |
| Copp |
| Copp |
| Copp |
| Copp |
| Copp |
| payee_namf |
| Vona |
| Vona |
| Vona |
| Vona |
| Vona |
| Vona |
| Vona |
| Vona |
| Vona |
| payee_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_city |
| Wilton |
| Wilton |
| Wilton |
| Wilton |
| Wilton |
| Wilton |
| Wilton |
| Wilton |
| Wilton |
| payee_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| payee_zip4 |
| 95693 |
| 95693 |
| 95693 |
| 95693 |
| 95693 |
| 95693 |
| 95693 |
| 95693 |
| 95693 |
| beg_bal |
| 458 |
| 305 |
| 154 |
| 200 |
| 307 |
| 101 |
| 200 |
| 0 |
| 0 |
| amt_incur |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 380 |
| 200 |
| amt_paid |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| end_bal |
| 458 |
| 305 |
| 154 |
| 200 |
| 307 |
| 101 |
| 200 |
| 380 |
| 200 |
| expn_code |
| PRO |
| PRO |
| PRO |
| PRO |
| PRO |
| PRO |
| PRO |
| PRO |
| PRO |
| expn_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cmte_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| memo_code |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| memo_refno |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bakref_tid |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| xref_schnm |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| xref_match |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: filer_filings
| filer_id |
| 1445207 |
| filing_id |
| 2743659 |
| 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 |
| 22001 |
|
Table: filings
| filing_id |
| 2743659 |
| filing_type |
| 22001 |
|
Table: hdr
| filing_id |
| 2743659 |
| amend_id |
| 0 |
| rec_type |
| HDR |
| ef_type |
| CAL |
| state_cd |
| CA |
| cal_ver |
| 2.01 |
| soft_name |
| NETFILE |
| soft_ver |
| 2022451 |
| hdrcomment |
| None |
|
Table: rcpt
| filing_id |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 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 |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| 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 |
| A |
| A |
| A |
| A |
| A |
| tran_id |
| INC91 |
| INC85 |
| INC95 |
| INC87 |
| INC93 |
| INC96 |
| INC94 |
| INC89 |
| INC90 |
| INC98 |
| INC92 |
| INC86 |
| INC88 |
| INC99 |
| INC100 |
| INC101 |
| INC102 |
| INC103 |
| INC112 |
| INC117 |
| INC111 |
| INC110 |
| INC116 |
| INC105 |
| INC114 |
| INC115 |
| INC122 |
| INC123 |
| entity_cd |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| COM |
| ctrib_naml |
| Barber |
| Chuckovich |
| Elder |
| Fernwood |
| Fishman |
| Gordon-Ramek |
| Hacker |
| Harris |
| Jean |
| Knudson |
| Lewis |
| Miller |
| Scott |
| Hites |
| Bleeg |
| Vallone |
| Follmer |
| Rubay |
| Baker |
| DeLuca-Kelly |
| Doty |
| Jacobson |
| Marvel |
| Smith |
| Summer |
| Thompson |
| Lee |
| Alameda County Republican Party |
| ctrib_namf |
| Cheryl L. |
| Carole |
| Kim Nyquist |
| Mark |
| Joanne |
| Eve M. |
| Kelly C. |
| Anne |
| Shannon |
| Betty J. |
| Cecilia W. |
| Christie |
| Patricia |
| Edith |
| Paul |
| Kyle |
| Jean |
| Joseph |
| Joanne |
| Cristina |
| Carol L. |
| Jo Ann |
| Greg A. |
| Roger F. |
| Elizabeth (Liz) |
| Terry |
| Valerie B. |
| None |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
| ctrib_city |
| Walnut Creek |
| Walnut Creek |
| Moraga |
| Danville |
| Lafayette |
| Orinda |
| Orinda |
| Alameda |
| Lafayette |
| Lafayette |
| Lafayette |
| Orinda |
| Walnut Creek |
| Lafayette |
| Alamo |
| SAN RAMON |
| Lafayette |
| Alamo |
| Danville |
| Alamo |
| Alamo |
| Alamo |
| Danville |
| Alamo |
| Pleasant Hill |
| Alamo |
| Hayward |
| San Leandro |
| 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 |
| CA |
| CA |
| CA |
| CA |
| CA |
| ctrib_zip4 |
| 94595 |
| 94595 |
| 94556 |
| 94526 |
| 94549 |
| 94563 |
| 94563 |
| 94501 |
| 94549 |
| 94549 |
| 94549 |
| 94563 |
| 94598 |
| 94549 |
| 94507 |
| 94583 |
| 94549 |
| 94507 |
| 94526 |
| 94507 |
| 94507 |
| 94507 |
| 94526 |
| 94507 |
| 94523 |
| 94507 |
| 94542 |
| 94577 |
| ctrib_emp |
| n/a |
| n/a |
| n/a |
| n/a |
| Coldwell Banker Realty |
| n/a |
| n/a |
| n/a |
| n/a |
| n/a |
| n/a |
| Sew Special Sewing |
| n/a |
| n/a |
| Eisner Advisory Group LLC |
| Vallone Insurance Agency Inc |
| Retired |
| Rubay & Rubay |
| n/a |
| n/a |
| n/a |
| Coldwell Banker Realty |
| Persens Association |
| The Benefits Store Insurance Services Inc. |
| n/a |
| Law Office of Terry L. Thompson |
| n/a |
| None |
| ctrib_occ |
| Retired |
| Retired |
| Retired |
| Retired |
| Realtor |
| Retired |
| Retired |
| Retired |
| Retired |
| Retired |
| Retired |
| Sewing Teacher |
| Retired |
| Homemaker |
| CPA |
| Business owner |
| Retired |
| Real Estate Appraiser |
| Retired |
| Homemaker |
| Retired |
| Realtor |
| President |
| Principal |
| Retired |
| Attorney |
| Retired |
| None |
| ctrib_self |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
| rcpt_date |
| 2022-09-26 00:00:00 |
| 2022-09-26 00:00:00 |
| 2022-09-26 00:00:00 |
| 2022-09-26 00:00:00 |
| 2022-09-26 00:00:00 |
| 2022-09-26 00:00:00 |
| 2022-09-26 00:00:00 |
| 2022-09-26 00:00:00 |
| 2022-09-26 00:00:00 |
| 2022-09-26 00:00:00 |
| 2022-09-26 00:00:00 |
| 2022-09-26 00:00:00 |
| 2022-09-26 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-08 00:00:00 |
| 2022-10-09 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-13 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 |
| None |
| None |
| None |
| None |
| None |
| amount |
| 100 |
| 50 |
| 200 |
| 200 |
| 100 |
| 200 |
| 100 |
| 100 |
| 250 |
| 100 |
| 100 |
| 250 |
| 100 |
| 200 |
| 150 |
| 25 |
| 150 |
| 25 |
| 500 |
| 100 |
| 100 |
| 250 |
| 250 |
| 2000 |
| 200 |
| 100 |
| 140 |
| 450 |
| cum_ytd |
| 100 |
| 100 |
| 200 |
| 450 |
| 100 |
| 200 |
| 200 |
| 100 |
| 250 |
| 100 |
| 100 |
| 250 |
| 100 |
| 200 |
| 150 |
| 100 |
| 150 |
| 150 |
| 500 |
| 100 |
| 100 |
| 250 |
| 250 |
| 2000 |
| 350 |
| 200 |
| 140 |
| 450 |
| 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 |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 743270 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
|
Table: smry
| filing_id |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 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 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22A |
| 22B |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 4 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 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 |
| form_type |
| F460 |
| 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 |
| E |
| E |
| E |
| E |
| F |
| F |
| F |
| B1 |
| B1 |
| B1 |
| H |
| H |
| H |
| amount_a |
| 6795 |
| 0 |
| 6795 |
| 0 |
| 6795 |
| 34 |
| 0 |
| 34 |
| 580 |
| 0 |
| 615 |
| 4783 |
| 6795 |
| 0 |
| 34 |
| 11543 |
| 0 |
| 0 |
| 2305 |
| 4860 |
| 1156 |
| 1703 |
| 9 |
| 6490 |
| 305 |
| 6795 |
| 0 |
| 34 |
| 0 |
| 34 |
| 580 |
| 0 |
| 580 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| amount_b |
| 13255 |
| 0 |
| 13255 |
| 0 |
| 13255 |
| 1712 |
| 0 |
| 1712 |
| 2305 |
| 0 |
| 4017 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 8395 |
| 2861 |
| 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 |
| 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 |
| 2022-06-07 00:00:00 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: splt
| filing_id |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 2743659 |
| 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 |
| 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 |
| 29 |
| 30 |
| 31 |
| 32 |
| 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 |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| ptran_id |
| INC91 |
| INC85 |
| INC95 |
| INC87 |
| INC87 |
| INC93 |
| INC96 |
| INC94 |
| INC89 |
| INC90 |
| INC98 |
| INC92 |
| INC86 |
| INC88 |
| INC99 |
| INC100 |
| INC101 |
| INC102 |
| INC103 |
| INC103 |
| INC112 |
| INC117 |
| INC111 |
| INC110 |
| INC116 |
| INC105 |
| INC114 |
| INC114 |
| INC115 |
| INC115 |
| INC122 |
| INC123 |
| elec_date |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| elec_amount |
| 100 |
| 100 |
| 200 |
| 250 |
| 200 |
| 100 |
| 200 |
| 200 |
| 100 |
| 250 |
| 100 |
| 100 |
| 250 |
| 100 |
| 200 |
| 150 |
| 100 |
| 150 |
| 25 |
| 125 |
| 500 |
| 100 |
| 100 |
| 250 |
| 250 |
| 2000 |
| 50 |
| 300 |
| 100 |
| 100 |
| 140 |
| 450 |
| elec_code |
| G |
| G |
| G |
| P |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| P |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| P |
| G |
| P |
| G |
| G |
| G |
|