Home
Filing ID: 2739847
PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2739847&amendid=1
Table: cvr2_campaign_disclosure
| filing_id |
| 2739847 |
| 2739847 |
| amend_id |
| 0 |
| 1 |
| line_item |
| 1 |
| 1 |
| rec_type |
| CVR2 |
| CVR2 |
| form_type |
| F460 |
| F460 |
| tran_id |
| 1 |
| 1 |
| entity_cd |
| CAO |
| CAO |
| title |
| None |
| None |
| mail_city |
| None |
| None |
| mail_st |
| None |
| None |
| mail_zip4 |
| None |
| None |
| f460_part |
| 5A |
| 5A |
| cmte_id |
| None |
| None |
| enty_naml |
| Clemmons |
| Clemmons |
| enty_namf |
| Mitchell |
| Mitchell |
| enty_namt |
| None |
| None |
| enty_nams |
| None |
| None |
| enty_city |
| Whittier |
| Whittier |
| enty_st |
| CA |
| CA |
| enty_zip4 |
| 90603 |
| 90603 |
| enty_phon |
| None |
| None |
| enty_fax |
| None |
| None |
| enty_email |
| None |
| None |
| tres_naml |
| None |
| None |
| tres_namf |
| None |
| None |
| tres_namt |
| None |
| None |
| tres_nams |
| None |
| None |
| control_yn |
| N |
| N |
| office_cd |
| SEN |
| SEN |
| offic_dscr |
| None |
| None |
| juris_cd |
| SEN |
| SEN |
| juris_dscr |
| None |
| None |
| dist_no |
| 30 |
| 30 |
| 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 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| amend_id |
| 0 |
| 0 |
| 1 |
| 1 |
| line_item |
| 1 |
| 2 |
| 1 |
| 2 |
| rec_type |
| CVR3 |
| CVR3 |
| CVR3 |
| CVR3 |
| form_type |
| F460 |
| F460 |
| F460 |
| F460 |
| tran_id |
| 15 |
| 16 |
| 17 |
| 18 |
| entity_cd |
| TRE |
| CAO |
| TRE |
| CAO |
| sig_date |
| 2022-10-24 00:00:00 |
| 2022-10-24 00:00:00 |
| 2022-10-26 00:00:00 |
| 2022-10-26 00:00:00 |
| sig_loc |
| None |
| None |
| None |
| None |
| sig_naml |
| Clemmons |
| Clemmons |
| Clemmons |
| Clemmons |
| sig_namf |
| Mitchell |
| Mitchell |
| Mietchell |
| Mitchell |
| sig_namt |
| None |
| None |
| None |
| None |
| sig_nams |
| None |
| None |
| None |
| None |
|
Table: cvr_campaign_disclosure
| filing_id |
| 2739847 |
| 2739847 |
| amend_id |
| 1 |
| 0 |
| rec_type |
| CVR |
| CVR |
| form_type |
| F460 |
| F460 |
| filer_id |
| 1446749 |
| 1446749 |
| entity_cd |
| RCP |
| RCP |
| filer_naml |
| CLEMMONS FOR SENATE 2022; MITCH |
| CLEMMONS FOR SENATE 2022; MITCH |
| filer_namf |
| None |
| None |
| filer_namt |
| None |
| None |
| filer_nams |
| None |
| None |
| report_num |
| 001 |
| 000 |
| rpt_date |
| 2022-10-26 00:00:00 |
| 2022-10-24 00:00:00 |
| stmt_type |
| PE |
| PE |
| late_rptno |
| None |
| None |
| from_date |
| 2022-09-24 00:00:00 |
| 2022-09-24 00:00:00 |
| thru_date |
| 2022-10-22 00:00:00 |
| 2022-10-22 00:00:00 |
| elect_date |
| 2022-11-08 00:00:00 |
| 2022-11-08 00:00:00 |
| filer_city |
| WHITTIER |
| WHITTIER |
| filer_st |
| CA |
| CA |
| filer_zip4 |
| 90603 |
| 90603 |
| filer_phon |
| 5625479981 |
| 5625479981 |
| filer_fax |
| None |
| None |
| file_email |
| electmitchclemmons@gmail.com |
| electmitchclemmons@gmail.com |
| mail_city |
| None |
| None |
| mail_st |
| None |
| None |
| mail_zip4 |
| None |
| None |
| tres_naml |
| Clemmons |
| Clemmons |
| tres_namf |
| Mitchell |
| Mitchell |
| tres_namt |
| None |
| None |
| tres_nams |
| None |
| None |
| tres_city |
| Whittier |
| Whittier |
| tres_st |
| CA |
| CA |
| tres_zip4 |
| 90603 |
| 90603 |
| tres_phon |
| 5625479981 |
| 5625479981 |
| tres_fax |
| None |
| None |
| tres_email |
| None |
| None |
| cmtte_type |
| C |
| C |
| control_yn |
| Y |
| Y |
| sponsor_yn |
| N |
| N |
| primfrm_yn |
| None |
| None |
| brdbase_yn |
| None |
| None |
| amendexp_1 |
| LINE 20 and Line 21 on the Summary page are year to date total instead of the last six month of the |
| None |
| amendexp_2 |
| year |
| None |
| amendexp_3 |
| None |
| None |
| rpt_att_cb |
| None |
| None |
| cmtte_id |
| None |
| None |
| reportname |
| None |
| None |
| rptfromdt |
| None |
| None |
| rptthrudt |
| None |
| None |
| emplbus_cb |
| None |
| None |
| bus_name |
| None |
| None |
| bus_city |
| None |
| None |
| bus_st |
| None |
| None |
| bus_zip4 |
| None |
| None |
| bus_inter |
| None |
| None |
| busact_cb |
| None |
| None |
| busactvity |
| None |
| None |
| assoc_cb |
| None |
| None |
| assoc_int |
| None |
| None |
| other_cb |
| None |
| None |
| other_int |
| None |
| None |
| cand_naml |
| Clemmons |
| Clemmons |
| cand_namf |
| Mitchell |
| Mitchell |
| cand_namt |
| None |
| None |
| cand_nams |
| None |
| None |
| cand_city |
| Whittier |
| Whittier |
| cand_st |
| CA |
| CA |
| cand_zip4 |
| 90603 |
| 90603 |
| cand_phon |
| None |
| None |
| cand_fax |
| None |
| None |
| cand_email |
| None |
| None |
| bal_name |
| None |
| None |
| bal_num |
| None |
| None |
| bal_juris |
| None |
| None |
| office_cd |
| SEN |
| SEN |
| offic_dscr |
| None |
| None |
| juris_cd |
| SEN |
| SEN |
| juris_dscr |
| None |
| None |
| dist_no |
| 30 |
| 30 |
| off_s_h_cd |
| None |
| None |
| sup_opp_cd |
| None |
| None |
| employer |
| None |
| None |
| occupation |
| None |
| None |
| selfemp_cb |
| None |
| None |
| bal_id |
| None |
| None |
| cand_id |
| None |
| None |
|
Table: expn
| filing_id |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| amend_id |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| rec_type |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| form_type |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| tran_id |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| entity_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_naml |
| Just Deliver It |
| Technicolor Printing |
| LA County Register-Recorder |
| Trey Taylor Music |
| University Printing |
| Just Deliver It |
| Technicolor Printing |
| LA County Register-Recorder |
| Trey Taylor Music |
| University Printing |
| payee_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_city |
| Mesa |
| Santa Fe Springs |
| Norwalk |
| South Vienna |
| La Habra |
| Mesa |
| Santa Fe Springs |
| Norwalk |
| South Vienna |
| La Habra |
| payee_st |
| AZ |
| CA |
| CA |
| OH |
| CA |
| AZ |
| CA |
| CA |
| OH |
| CA |
| payee_zip4 |
| 85203 |
| 90670 |
| 90650 |
| 45369 |
| 90631 |
| 85203 |
| 90670 |
| 90650 |
| 45369 |
| 90631 |
| expn_date |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| amount |
| 620 |
| 606 |
| 473 |
| 4000 |
| 341 |
| 620 |
| 606 |
| 473 |
| 4000 |
| 341 |
| cum_ytd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cum_oth |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| expn_chkno |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| expn_code |
| MBR |
| CMP |
| VOT |
| FND |
| LIT |
| MBR |
| CMP |
| VOT |
| FND |
| LIT |
| expn_dscr |
| Marketing |
| Printing Flyers |
| List of Voters |
| Music Event |
| Printing |
| Marketing |
| Printing Flyers |
| List of Voters |
| Music Event |
| Printing |
| agent_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| agent_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| agent_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| agent_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cmte_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| office_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| offic_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| juris_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| juris_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| dist_no |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| off_s_h_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bal_name |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bal_num |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bal_juris |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| sup_opp_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| memo_code |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| memo_refno |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| None |
| None |
| None |
| None |
| None |
| bakref_tid |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| g_from_e_f |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| xref_schnm |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| xref_match |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: filer_filings
| filer_id |
| 1446749 |
| 1446749 |
| filing_id |
| 2739847 |
| 2739847 |
| period_id |
| 251 |
| 251 |
| form_id |
| F460 |
| F460 |
| filing_sequence |
| 0 |
| 1 |
| filing_date |
| 2022-10-24 00:00:00 |
| 2022-10-26 00:00:00 |
| stmnt_type |
| 10001 |
| 10002 |
| stmnt_status |
| 11003 |
| 11003 |
| session_id |
| 2021 |
| 2021 |
| user_id |
| CAFILER |
| CAFILER |
| special_audit |
| 11003 |
| 11003 |
| fine_audit |
| 11003 |
| 11003 |
| rpt_start |
| 2022-09-24 00:00:00 |
| 2022-09-24 00:00:00 |
| rpt_end |
| 2022-10-22 00:00:00 |
| 2022-10-22 00:00:00 |
| rpt_date |
| 2022-10-24 00:00:00 |
| 2022-10-26 00:00:00 |
| filing_type |
| 22006 |
| 22006 |
|
Table: filings
| filing_id |
| 2739847 |
| filing_type |
| 22001 |
|
Table: hdr
| filing_id |
| 2739847 |
| 2739847 |
| amend_id |
| 1 |
| 0 |
| rec_type |
| HDR |
| HDR |
| ef_type |
| CAL |
| CAL |
| state_cd |
| CA |
| CA |
| cal_ver |
| 2.01 |
| 2.01 |
| soft_name |
| CAL-ACCESS OBJECT MODEL |
| CAL-ACCESS OBJECT MODEL |
| soft_ver |
| 1.00 |
| 1.00 |
| hdrcomment |
| None |
| None |
|
Table: loan
| filing_id |
| 2739847 |
| 2739847 |
| amend_id |
| 0 |
| 1 |
| line_item |
| 1 |
| 1 |
| rec_type |
| LOAN |
| LOAN |
| form_type |
| B1 |
| B1 |
| tran_id |
| 9 |
| 9 |
| loan_type |
| None |
| None |
| entity_cd |
| IND |
| IND |
| lndr_naml |
| Clemmons |
| Clemmons |
| lndr_namf |
| Mitchell |
| Mitchell |
| lndr_namt |
| None |
| None |
| lndr_nams |
| None |
| None |
| loan_city |
| Whittier |
| Whittier |
| loan_st |
| CA |
| CA |
| loan_zip4 |
| 90603 |
| 90603 |
| loan_date1 |
| 2022-03-24 00:00:00 |
| 2022-03-24 00:00:00 |
| loan_date2 |
| None |
| None |
| loan_amt1 |
| 2900 |
| 2900 |
| loan_amt2 |
| 3900 |
| 3900 |
| loan_amt3 |
| 3900 |
| 3900 |
| loan_amt4 |
| 1000 |
| 1000 |
| loan_rate |
| 0% |
| 0% |
| loan_emp |
| Clemmons Services |
| Clemmons Services |
| loan_occ |
| Plumber |
| Plumber |
| loan_self |
| X |
| X |
| cmte_id |
| None |
| None |
| tres_naml |
| None |
| None |
| tres_namf |
| None |
| None |
| tres_namt |
| None |
| None |
| tres_nams |
| None |
| None |
| tres_city |
| None |
| None |
| tres_st |
| None |
| None |
| tres_zip4 |
| None |
| None |
| intr_naml |
| None |
| None |
| intr_namf |
| None |
| None |
| intr_namt |
| None |
| None |
| intr_nams |
| None |
| None |
| intr_city |
| None |
| None |
| intr_st |
| None |
| None |
| intr_zip4 |
| None |
| None |
| memo_code |
| None |
| None |
| memo_refno |
| None |
| 9 |
| bakref_tid |
| None |
| None |
| xref_schnm |
| None |
| None |
| xref_match |
| None |
| None |
| loan_amt5 |
| 0 |
| 0 |
| loan_amt6 |
| 0 |
| 0 |
| loan_amt7 |
| 0 |
| 0 |
| loan_amt8 |
| 1000 |
| 1000 |
|
Table: rcpt
| filing_id |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| rec_type |
| 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 |
| tran_id |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| entity_cd |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| ctrib_naml |
| Bracey |
| Palmquist |
| Padilla |
| Lin |
| Quasny |
| Wan |
| Heibert |
| Bracey |
| Palmquist |
| Padilla |
| Lin |
| Quasny |
| Wan |
| Heibert |
| ctrib_namf |
| Patricia |
| Jennifer |
| Sandi |
| Linda Guang |
| Dale |
| Zhixia |
| Charlyn |
| Patricia |
| Jennifer |
| Sandi |
| Linda Guang |
| Dale |
| Zhixia |
| Charlyn |
| ctrib_namt |
| 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 |
| ctrib_city |
| La Mirada |
| La Habra Heights |
| Downey |
| Alhambra |
| Covina |
| Claremont |
| Los Angeles |
| La Mirada |
| La Habra Heights |
| Downey |
| Alhambra |
| Covina |
| Claremont |
| Los Angeles |
| ctrib_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| ctrib_zip4 |
| 90638 |
| 90631 |
| 90241 |
| 91803 |
| 91723 |
| 91711 |
| 90041 |
| 90638 |
| 90631 |
| 90241 |
| 91803 |
| 91723 |
| 91711 |
| 90041 |
| ctrib_emp |
| Bracey Tax and Finance |
| Retired |
| Homemaker |
| Retired |
| Retired |
| Fuller Enterprises USA |
| Charagape Miinistry |
| Bracey Tax and Finance |
| Retired |
| Homemaker |
| Retired |
| Retired |
| Fuller Enterprises USA |
| Charagape Miinistry |
| ctrib_occ |
| Office Administrator |
| Retired |
| Homemaker |
| Retired |
| Retired |
| CIO |
| President |
| Office Administrator |
| Retired |
| Homemaker |
| Retired |
| Retired |
| CIO |
| President |
| ctrib_self |
| 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 |
| rcpt_date |
| 2022-09-27 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-09-28 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-09 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-09-28 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-09 00:00:00 |
| date_thru |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| amount |
| 500 |
| 250 |
| 100 |
| 100 |
| 200 |
| 500 |
| 250 |
| 500 |
| 250 |
| 100 |
| 100 |
| 200 |
| 500 |
| 250 |
| cum_ytd |
| 500 |
| 250 |
| 100 |
| 100 |
| 200 |
| 500 |
| 250 |
| 500 |
| 250 |
| 100 |
| 100 |
| 200 |
| 500 |
| 250 |
| cum_oth |
| 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 |
| cmte_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_naml |
| 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 |
| tres_namt |
| 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 |
| tres_city |
| 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 |
| tres_zip4 |
| 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 |
| intr_namf |
| 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 |
| intr_nams |
| 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 |
| intr_st |
| 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 |
| intr_emp |
| 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 |
| intr_self |
| 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 |
| cand_namf |
| 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 |
| cand_nams |
| 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 |
| offic_dscr |
| 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 |
| juris_dscr |
| 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 |
| off_s_h_cd |
| 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 |
| bal_num |
| 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 |
| sup_opp_cd |
| 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 |
| memo_refno |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| bakref_tid |
| 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 |
| xref_match |
| 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 |
| intr_cmteid |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: smry
| filing_id |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| 2739847 |
| amend_id |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 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 |
| 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 |
| 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 |
| 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 |
| 2168 |
| 2900 |
| 5068 |
| 0 |
| 5068 |
| 6119 |
| 0 |
| 6119 |
| 0 |
| 0 |
| 6119 |
| 3728 |
| 5068 |
| 0 |
| 6119 |
| 2677 |
| 0 |
| 0 |
| 3900 |
| 12293 |
| 10178 |
| 23817 |
| 1900 |
| 268 |
| 2168 |
| 2900 |
| 0 |
| 2900 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 6040 |
| 79 |
| 0 |
| 6119 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 2168 |
| 2900 |
| 5068 |
| 0 |
| 5068 |
| 6119 |
| 0 |
| 6119 |
| 0 |
| 0 |
| 6119 |
| 3728 |
| 5068 |
| 0 |
| 6119 |
| 2677 |
| 0 |
| 0 |
| 3900 |
| 12293 |
| 10178 |
| 23817 |
| 1900 |
| 268 |
| 2168 |
| 2900 |
| 0 |
| 2900 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 6040 |
| 79 |
| 0 |
| 6119 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| amount_b |
| 22594 |
| 3900 |
| 26494 |
| 0 |
| 26494 |
| 23817 |
| 0 |
| 23817 |
| 0 |
| 0 |
| 23817 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 14301 |
| 13639 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 22594 |
| 3900 |
| 26494 |
| 0 |
| 26494 |
| 23817 |
| 0 |
| 23817 |
| 0 |
| 0 |
| 23817 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 26594 |
| 23817 |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 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 |
|