Home
Filing ID: 2743786
PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2743786&amendid=0
Table: cvr2_campaign_disclosure
| filing_id |
| 2743786 |
| amend_id |
| 0 |
| line_item |
| 1 |
| rec_type |
| CVR2 |
| form_type |
| F460 |
| tran_id |
| OFC5 |
| entity_cd |
| ATR |
| title |
| None |
| mail_city |
| None |
| mail_st |
| None |
| mail_zip4 |
| None |
| f460_part |
| 3 |
| cmte_id |
| None |
| enty_naml |
| Tratten |
| enty_namf |
| Lea-Ann |
| enty_namt |
| None |
| enty_nams |
| None |
| enty_city |
| Sacramento |
| enty_st |
| CA |
| enty_zip4 |
| 95814 |
| enty_phon |
| (916) 442-6902 |
| enty_fax |
| None |
| enty_email |
| None |
| tres_naml |
| None |
| tres_namf |
| None |
| tres_namt |
| None |
| tres_nams |
| None |
| control_yn |
| 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 |
|
Table: cvr3_verification_info
| filing_id |
| 2743786 |
| 2743786 |
| amend_id |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| rec_type |
| CVR3 |
| CVR3 |
| form_type |
| F460 |
| F460 |
| tran_id |
| olsonlobby.1 |
| olsonlobby.2 |
| entity_cd |
| ATR |
| OFF |
| sig_date |
| 2022-10-26 00:00:00 |
| 2022-10-26 00:00:00 |
| sig_loc |
| None |
| None |
| sig_naml |
| Lea-Ann Tratten |
| Lea-Ann Tratten |
| sig_namf |
| None |
| None |
| sig_namt |
| None |
| None |
| sig_nams |
| None |
| None |
|
Table: cvr_campaign_disclosure
| filing_id |
| 2743786 |
| amend_id |
| 0 |
| rec_type |
| CVR |
| form_type |
| F460 |
| filer_id |
| 962871 |
| entity_cd |
| RCP |
| filer_naml |
| Consumer Attorneys of California Independent Campaign Committee |
| filer_namf |
| None |
| filer_namt |
| None |
| filer_nams |
| None |
| report_num |
| 000 |
| rpt_date |
| 2022-10-25 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 |
| Sacramento |
| filer_st |
| CA |
| filer_zip4 |
| 95814 |
| filer_phon |
| (916) 442-6902 |
| filer_fax |
| (916) 442-7734 |
| file_email |
| [email protected] |
| mail_city |
| Sacramento |
| mail_st |
| CA |
| mail_zip4 |
| 95815 |
| tres_naml |
| Rizio |
| tres_namf |
| Greg |
| tres_namt |
| None |
| tres_nams |
| None |
| tres_city |
| Sacramento |
| tres_st |
| CA |
| tres_zip4 |
| 95814 |
| tres_phon |
| (916) 442-6902 |
| tres_fax |
| None |
| tres_email |
| None |
| cmtte_type |
| G |
| control_yn |
| Y |
| sponsor_yn |
| N |
| 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: debt
| filing_id |
| 2743786 |
| 2743786 |
| amend_id |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| rec_type |
| DEBT |
| DEBT |
| form_type |
| F |
| F |
| tran_id |
| PAY7640 |
| PAY7729 |
| entity_cd |
| OTH |
| OTH |
| payee_naml |
| Consumer Attorneys of California |
| Consumer Attorneys of California |
| payee_namf |
| None |
| None |
| payee_namt |
| None |
| None |
| payee_nams |
| None |
| None |
| payee_city |
| Sacramento |
| Sacramento |
| payee_st |
| CA |
| CA |
| payee_zip4 |
| 95814 |
| 95814 |
| beg_bal |
| 234 |
| 0 |
| amt_incur |
| 0 |
| 1427 |
| amt_paid |
| 234 |
| 0 |
| end_bal |
| 0 |
| 1427 |
| expn_code |
| OFC |
| OFC |
| expn_dscr |
| September Credit Card Fees 2022 |
| October Credit Card Fees 2022 |
| 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 |
| memo_code |
| None |
| None |
| memo_refno |
| None |
| None |
| bakref_tid |
| None |
| None |
| xref_schnm |
| None |
| None |
| xref_match |
| None |
| None |
|
Table: expn
| filing_id |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| amend_id |
| 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 |
| rec_type |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| form_type |
| D |
| D |
| D |
| D |
| D |
| D |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| G |
| tran_id |
| EDT65 |
| EXP7641 |
| EXP7646 |
| EDT64 |
| EXP7701 |
| EXP7702 |
| EXP7641 |
| EXP7646 |
| EXP7643 |
| EXP7645 |
| EXP7701 |
| EXP7702 |
| EXP7642 |
| PDT28 |
| entity_cd |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| OTH |
| OTH |
| COM |
| COM |
| OTH |
| OTH |
| payee_naml |
| American Federation of State, County and Municipal Employees Local 3299 PAC |
| California Alliance, a Coalition of Consumer Attorneys, Conservationists and Food and Commercial Workers |
| Californians Allied to Support Caroline Menjivar for Senate 2022 |
| Californians Allied to Support Caroline Menjivar for Senate 2022 |
| Golden State Alliance - California |
| Sacramento County Democratic Central Committee |
| California Alliance, a Coalition of Consumer Attorneys, Conservationists and Food and Commercial Workers |
| Californians Allied to Support Caroline Menjivar for Senate 2022 |
| Consumer Attorneys of California |
| Deane & Company |
| Golden State Alliance - California |
| Sacramento County Democratic Central Committee |
| Tulchin Research |
| Priority Payment Systems |
| payee_namf |
| 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 |
| payee_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_city |
| Sacramento |
| Sacramento |
| Los Angeles |
| Los Angeles |
| Sacramento |
| Sacramento |
| Sacramento |
| Los Angeles |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| San Francisco |
| Alpharetta |
| payee_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| GA |
| payee_zip4 |
| 95814 |
| 95814 |
| 90010 |
| 90010 |
| 95814 |
| 95814 |
| 95814 |
| 90010 |
| 95814 |
| 95815 |
| 95814 |
| 95814 |
| 94104 |
| 30004 |
| expn_date |
| 2022-09-29 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-09 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-22 00:00:00 |
| amount |
| 19000 |
| 300000 |
| 100000 |
| 19000 |
| 25000 |
| 45000 |
| 300000 |
| 100000 |
| 234 |
| 579 |
| 25000 |
| 45000 |
| 19000 |
| 1427 |
| cum_ytd |
| 19000 |
| 900000 |
| 119000 |
| 119000 |
| 25000 |
| 45000 |
| 900000 |
| 119000 |
| 3984 |
| 5156 |
| 25000 |
| 45000 |
| 19000 |
| 3250 |
| cum_oth |
| 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 |
| expn_code |
| IKD |
| MON |
| MON |
| IKD |
| MON |
| MON |
| CTB |
| CTB |
| OFC |
| PRO |
| CTB |
| CTB |
| CTB |
| OFC |
| expn_dscr |
| Polling |
| None |
| None |
| Polling |
| None |
| None |
| None |
| None |
| September Credit Card Fees 2022 |
| None |
| None |
| None |
| Polling - In-Kind to American Federation of State, County and Municipal Employees Local 3299 PAC (ID# 1312649) & Californians Allied to Support Caroline Menjivar for Senate 2022 (ID# 1455274) |
| October Credit Card Fees 2022 |
| agent_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Consumer Attorneys of California |
| agent_namf |
| 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 |
| agent_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cmte_id |
| None |
| None |
| None |
| None |
| None |
| None |
| 1240727 |
| 1455274 |
| None |
| None |
| 1442715 |
| 741817 |
| 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 |
| cand_naml |
| None |
| California Alliance, a Coalition of Consumer Attorneys, Conservationists and Food and Commercial Workers |
| 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 |
| S |
| S |
| S |
| S |
| S |
| S |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bakref_tid |
| 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 |
| F |
| 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 |
|
Table: filer_filings
| filer_id |
| 1069624 |
| filing_id |
| 2743786 |
| 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-25 00:00:00 |
| filing_type |
| 22001 |
|
Table: filings
| filing_id |
| 2743786 |
| filing_type |
| 22001 |
|
Table: hdr
| filing_id |
| 2743786 |
| 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 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 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 |
| 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 |
| 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 |
| 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 |
| tran_id |
| INC7728 |
| INC7704 |
| INC7647 |
| INC7717 |
| INC7648 |
| INC7718 |
| INC7706 |
| INC7720 |
| INC7721 |
| INC7672 |
| INC7651 |
| INC7711 |
| INC7725 |
| INC7655 |
| INC7727 |
| INC7678 |
| INC7692 |
| INC7656 |
| INC7738 |
| INC7739 |
| INC7740 |
| INC7715 |
| INC7716 |
| INC7684 |
| entity_cd |
| OTH |
| OTH |
| OTH |
| IND |
| OTH |
| IND |
| OTH |
| IND |
| IND |
| IND |
| OTH |
| OTH |
| IND |
| OTH |
| IND |
| IND |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| IND |
| ctrib_naml |
| Agnew Brusavich |
| Berding & Weil, LLP |
| Bisnar Chase, Personal Injury Attorneys, LLP |
| Blatt |
| Blumenthal, Nordrehaug & Bhowmik |
| de Bartolomeo |
| Genie Harrison Law Firm |
| Halbany |
| Hanumadass |
| Johnson |
| Law Office of Marshall Silberberg, Professional Corporation |
| Lieff, Cabraser, Heimann & Bernstein, LLP |
| McKibben |
| Nelson & Fraenkel, LLP |
| Pantone |
| Paul |
| Rouda, Feder, Tietjen & McGuinn, A Professional Corporation |
| Taylor and Ring, LLP |
| The Veen Firm, Professional Corporation |
| The Veen Firm, Professional Corporation |
| The Veen Firm, Professional Corporation |
| Walter Clark Legal Group, A Professional Corporation |
| Walter Clark Legal Group, A Professional Corporation |
| Wells |
| ctrib_namf |
| None |
| None |
| None |
| Gayle Meryl |
| None |
| A.J. |
| None |
| Laurel |
| Srinivas |
| Casey |
| None |
| None |
| Molly |
| None |
| Boyden James |
| Gary M. |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Geoffrey |
| 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 |
| 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 |
| ctrib_city |
| Torrance |
| Alamo |
| Newport Beach |
| San Diego |
| Los Angeles |
| New York |
| Los Angeles |
| Oakland |
| San Diego |
| Riverside |
| Irvine |
| San Francisco |
| Santa Monica |
| Los Angeles |
| Riverside |
| El Segundo |
| San Francisco |
| Los Angeles |
| San Francisco |
| San Francisco |
| San Francisco |
| Rancho Mirage |
| Rancho Mirage |
| Santa Monica |
| ctrib_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| NY |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| ctrib_zip4 |
| 90503 |
| 94507 |
| 92660 |
| 92101 |
| 90067 |
| 10119 |
| 90014 |
| 94607 |
| 92101 |
| 92504 |
| 92612 |
| 94111 |
| 90401 |
| 90017 |
| 92506 |
| 90245 |
| 94104 |
| 90024 |
| 94102 |
| 94102 |
| 94102 |
| 92270 |
| 92270 |
| 90401 |
| ctrib_emp |
| None |
| None |
| None |
| Casey, Gerry, Schenk, LLP |
| None |
| Tadler Law, LLP |
| None |
| Kazan, McClain, Satterley & Greenwood, APLC |
| Panish, Shea, Boyle & Ravipudi, LLC |
| Aitken, Aitken, Cohn |
| None |
| None |
| Greene, Broillet & Wheeler, LLP |
| None |
| Pantone Law |
| Waters, Kraus & Paul |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Greene, Broillet & Wheeler |
| ctrib_occ |
| None |
| None |
| None |
| Attorney |
| None |
| Attorney |
| None |
| Attorney |
| Attorney |
| Attorney |
| None |
| None |
| Attorney |
| None |
| Attorney |
| Attorney |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Attorney |
| 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 |
| 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 |
| rcpt_date |
| 2022-10-13 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-08 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-08 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-08 00:00:00 |
| 2022-09-29 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-08 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 |
| amount |
| 4200 |
| 25 |
| 16700 |
| 100 |
| 25000 |
| 25 |
| 1700 |
| 25 |
| 25 |
| 100 |
| 16700 |
| 41700 |
| 25 |
| 1000 |
| 25 |
| 30 |
| 1700 |
| 16700 |
| 10700 |
| 19000 |
| 12000 |
| 1700 |
| 1200 |
| 100 |
| cum_ytd |
| 4200 |
| 16725 |
| 16700 |
| 1000 |
| 25000 |
| 275 |
| 1700 |
| 250 |
| 225 |
| 1000 |
| 16700 |
| 41700 |
| 250 |
| 2500 |
| 250 |
| 300 |
| 1725 |
| 16700 |
| 41700 |
| 41700 |
| 41700 |
| 2900 |
| 2900 |
| 1000 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
|
Table: smry
| filing_id |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 2743786 |
| 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 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 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 |
| form_type |
| 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 |
| 172280 |
| 0 |
| 172280 |
| 0 |
| 172280 |
| 489813 |
| 0 |
| 489813 |
| 1193 |
| 0 |
| 491006 |
| 434558 |
| 172280 |
| 0 |
| 489813 |
| 117025 |
| 0 |
| 0 |
| 1427 |
| 170480 |
| 1800 |
| 172280 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 508000 |
| 0 |
| 508000 |
| 489813 |
| 0 |
| 0 |
| 489813 |
| 1427 |
| 234 |
| 1193 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| amount_b |
| 1219815 |
| 0 |
| 1219815 |
| 0 |
| 1219815 |
| 1141186 |
| 0 |
| 1141186 |
| 1427 |
| 0 |
| 1142613 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 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 |
|