Home
Filing ID: 2743784
PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2743784&amendid=0
Table: cvr2_campaign_disclosure
filing_id |
| 2743784 |
| 2743784 |
| 2743784 |
amend_id |
| 0 |
| 0 |
| 0 |
line_item |
| 1 |
| 2 |
| 3 |
rec_type |
| CVR2 |
| CVR2 |
| CVR2 |
form_type |
| F460 |
| F460 |
| F460 |
tran_id |
| OFC1 |
| NIC1 |
| NIC2 |
entity_cd |
| ATR |
| COM |
| COM |
title |
| None |
| None |
| None |
mail_city |
| None |
| None |
| None |
mail_st |
| None |
| None |
| None |
mail_zip4 |
| None |
| None |
| None |
f460_part |
| 3 |
| 5b |
| 5b |
cmte_id |
| None |
| 1450646 |
| Pending |
enty_naml |
| Stephen |
| Dr. Sion Roy for College Board of Trustees 2022 |
| Dr. Sion Roy for State Senate 2026 |
enty_namf |
| Ashley Ann |
| None |
| None |
enty_namt |
| None |
| None |
| None |
enty_nams |
| None |
| None |
| None |
enty_city |
| Sacramento |
| Sacramento |
| Sacramento |
enty_st |
| CA |
| CA |
| CA |
enty_zip4 |
| 95814 |
| 95814 |
| 95814 |
enty_phon |
| 916-706-2677 |
| 9167062677 |
| 9167062677 |
enty_fax |
| None |
| None |
| None |
enty_email |
| [email protected] |
| None |
| None |
tres_naml |
| None |
| Stephen |
| Stephen |
tres_namf |
| None |
| Laura |
| Laura |
tres_namt |
| None |
| None |
| None |
tres_nams |
| None |
| None |
| None |
control_yn |
| None |
| Y |
| Y |
office_cd |
| None |
| None |
| None |
offic_dscr |
| None |
| None |
| None |
juris_cd |
| None |
| None |
| None |
juris_dscr |
| None |
| None |
| None |
dist_no |
| None |
| None |
| None |
off_s_h_cd |
| None |
| None |
| None |
bal_name |
| None |
| None |
| None |
bal_num |
| None |
| None |
| None |
bal_juris |
| None |
| None |
| None |
sup_opp_cd |
| None |
| None |
| None |
|
Table: cvr3_verification_info
filing_id |
| 2743784 |
| 2743784 |
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-27 00:00:00 |
| 2022-10-27 00:00:00 |
sig_loc |
| None |
| None |
sig_naml |
| Laura Ann Stephen |
| Sion Roy |
sig_namf |
| None |
| None |
sig_namt |
| None |
| None |
sig_nams |
| None |
| None |
|
Table: cvr_campaign_disclosure
filing_id |
| 2743784 |
amend_id |
| 0 |
rec_type |
| CVR |
form_type |
| F460 |
filer_id |
| 1450646 |
entity_cd |
| CTL |
filer_naml |
| Dr. Sion Roy for College Board of Trustees 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 |
| Sacramento |
filer_st |
| CA |
filer_zip4 |
| 95814 |
filer_phon |
| 916-706-2677 |
filer_fax |
| None |
file_email |
| [email protected] |
mail_city |
| None |
mail_st |
| None |
mail_zip4 |
| None |
tres_naml |
| Stephen |
tres_namf |
| Laura Ann |
tres_namt |
| None |
tres_nams |
| None |
tres_city |
| Sacramento |
tres_st |
| CA |
tres_zip4 |
| 95814 |
tres_phon |
| 916-706-2677 |
tres_fax |
| None |
tres_email |
| None |
cmtte_type |
| C |
control_yn |
| N |
sponsor_yn |
| N |
primfrm_yn |
| None |
brdbase_yn |
| None |
amendexp_1 |
| None |
amendexp_2 |
| None |
amendexp_3 |
| None |
rpt_att_cb |
| None |
cmtte_id |
| None |
reportname |
| None |
rptfromdt |
| None |
rptthrudt |
| None |
emplbus_cb |
| None |
bus_name |
| None |
bus_city |
| None |
bus_st |
| None |
bus_zip4 |
| None |
bus_inter |
| None |
busact_cb |
| None |
busactvity |
| None |
assoc_cb |
| None |
assoc_int |
| None |
other_cb |
| None |
other_int |
| None |
cand_naml |
| Roy |
cand_namf |
| Sion |
cand_namt |
| None |
cand_nams |
| None |
cand_city |
| Sacramento |
cand_st |
| CA |
cand_zip4 |
| 95814 |
cand_phon |
| (916) 706-2677 |
cand_fax |
| None |
cand_email |
| [email protected] |
bal_name |
| None |
bal_num |
| None |
bal_juris |
| None |
office_cd |
| CCB |
offic_dscr |
| None |
juris_cd |
| OTH |
juris_dscr |
| SM Community College |
dist_no |
| None |
off_s_h_cd |
| H |
sup_opp_cd |
| None |
employer |
| None |
occupation |
| None |
selfemp_cb |
| None |
bal_id |
| None |
cand_id |
| None |
|
Table: expn
filing_id |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
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 |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| G |
| G |
| G |
tran_id |
| EXP71 |
| EXP72 |
| EXP93 |
| EXP94 |
| EXP96 |
| EXP97 |
| EXP98 |
| EXP99 |
| EXP86 |
| EXP85 |
| EXP82 |
| EDT1 |
| EDT2 |
| EDT3 |
entity_cd |
| COM |
| COM |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
payee_naml |
| 13 Stars Media |
| 13 Stars Media |
| eFundraising Connections |
| eFundraising Connections |
| eFundraising Connections |
| eFundraising Connections |
| eFundraising Connections |
| eFundraising Connections |
| Resonance Campaigns, LLC |
| Resonance Campaigns, LLC |
| Resonance Campaigns, LLC |
| United States Postal Service |
| United States Postal Service |
| Uplift |
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 |
| Atascadero |
| Atascadero |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Washington |
| Washington |
| Washington |
| Santa Monica |
| Santa Monica |
| Berkeley |
payee_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| DC |
| DC |
| DC |
| CA |
| CA |
| CA |
payee_zip4 |
| 93422 |
| 93422 |
| 95816 |
| 95816 |
| 95816 |
| 95816 |
| 95816 |
| 95816 |
| 20001 |
| 20001 |
| 20001 |
| 90401 |
| 90401 |
| 94704 |
expn_date |
| 2022-10-07 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-09-29 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-21 00:00:00 |
amount |
| 617 |
| 1234 |
| 30 |
| 6 |
| 5 |
| 1 |
| 20 |
| 129 |
| 11251 |
| 13198 |
| 5000 |
| 4168 |
| 4879 |
| 4250 |
cum_ytd |
| 1851 |
| 1851 |
| 509 |
| 509 |
| 509 |
| 509 |
| 509 |
| 509 |
| 29449 |
| 29449 |
| 29449 |
| 9047 |
| 9047 |
| 4250 |
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 |
| PRT |
| PRT |
| OFC |
| OFC |
| OFC |
| OFC |
| OFC |
| OFC |
| None |
| None |
| None |
| POS |
| POS |
| None |
expn_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Mailer. See Schedule G |
| Mailer divided between Sion Roy, Tom Peters, Barry Snell and Nancy Greenstein. See Schedule G |
| Digital Ads. See Schedule G |
| None |
| None |
| Digital Ads |
agent_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Resonance Campaigns, LLC |
| Resonance Campaigns, LLC |
| Resonance Campaigns, LLC |
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 |
| 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 |
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 |
| 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 |
| E |
| E |
| E |
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 |
| 1450646 |
filing_id |
| 2743784 |
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 |
| 2743784 |
filing_type |
| 22001 |
|
Table: hdr
filing_id |
| 2743784 |
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: loan
filing_id |
| 2743784 |
amend_id |
| 0 |
line_item |
| 1 |
rec_type |
| LOAN |
form_type |
| B1 |
tran_id |
| PAY37 |
loan_type |
| None |
entity_cd |
| IND |
lndr_naml |
| Roy |
lndr_namf |
| Sion |
lndr_namt |
| None |
lndr_nams |
| None |
loan_city |
| Malibu |
loan_st |
| CA |
loan_zip4 |
| 90265 |
loan_date1 |
| 2022-09-09 00:00:00 |
loan_date2 |
| None |
loan_amt1 |
| 0 |
loan_amt2 |
| 5000 |
loan_amt3 |
| 5000 |
loan_amt4 |
| 5000 |
loan_rate |
| 0.00 |
loan_emp |
| LA County |
loan_occ |
| Physician |
loan_self |
| None |
cmte_id |
| None |
tres_naml |
| None |
tres_namf |
| None |
tres_namt |
| None |
tres_nams |
| None |
tres_city |
| None |
tres_st |
| None |
tres_zip4 |
| None |
intr_naml |
| None |
intr_namf |
| None |
intr_namt |
| None |
intr_nams |
| None |
intr_city |
| None |
intr_st |
| None |
intr_zip4 |
| None |
memo_code |
| None |
memo_refno |
| None |
bakref_tid |
| None |
xref_schnm |
| None |
xref_match |
| None |
loan_amt5 |
| 0 |
loan_amt6 |
| 0 |
loan_amt7 |
| 0 |
loan_amt8 |
| 5000 |
|
Table: rcpt
filing_id |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
amend_id |
| 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 |
rec_type |
| 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 |
| C |
| I |
| I |
| I |
| I |
tran_id |
| INC66 |
| INC78 |
| INC81 |
| INC84 |
| INC74 |
| INC70 |
| INC77 |
| INC65 |
| INC68 |
| INC69 |
| INC75 |
| INC73 |
| NON60 |
| INC105 |
| INC102 |
| INC104 |
| INC103 |
entity_cd |
| IND |
| COM |
| COM |
| COM |
| IND |
| IND |
| IND |
| SCC |
| IND |
| COM |
| IND |
| SCC |
| IND |
| IND |
| COM |
| COM |
| COM |
ctrib_naml |
| Aoki |
| Building California Together PAC |
| California Medical Association PAC |
| California Permanente Medical Groups PAC |
| Cummings |
| Foster |
| Glatis |
| Laborers' Local 300 Small Contributor Committee (All Purpose Account) |
| Rajasekhar |
| Santa Monica College Faculty Association PAC |
| Torosis |
| Union of American Physicians and Dentists |
| Ruchalski |
| Greenstein |
| Peters 4 Santa Monica College Trustee 2022 |
| Re-Elect Nancy Greenstein for College Board 2022 |
| Snell 4 Santa Monica College 2022 |
ctrib_namf |
| Dennis |
| None |
| None |
| None |
| Susan |
| Anastasia |
| Christopher |
| None |
| Damodara |
| None |
| James |
| None |
| Kathleen |
| Nancy |
| Tom |
| None |
| Barry |
ctrib_namt |
| 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 |
ctrib_city |
| Los Angeles |
| Sacramento |
| Sacramento |
| Oakland |
| Los Altos |
| Santa Monica |
| Malibu |
| Los Angeles |
| Apple Valley |
| Santa Monica |
| Los Altos |
| Sacramento |
| Los Angeles |
| Santa Monica |
| Inglewood |
| Santa Monica |
| Inglewood |
ctrib_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
ctrib_zip4 |
| 90025 |
| 95814 |
| 95814 |
| 94612 |
| 94024 |
| 90403 |
| 90265 |
| 90006 |
| 92308 |
| 90405 |
| 94024 |
| 95814 |
| 90095 |
| 90403 |
| 90301 |
| 90405 |
| 90301 |
ctrib_emp |
| Retired |
| None |
| None |
| None |
| Retired |
| Assisted Living Santa Monica |
| Christopher Glatis |
| None |
| Damodara Rajasekhar, MD |
| None |
| James Torosis, MD |
| None |
| UCLA |
| Retired |
| None |
| None |
| None |
ctrib_occ |
| Retired |
| None |
| None |
| None |
| Retired |
| Healthcare |
| Writer/Director |
| None |
| Physician |
| None |
| Physician |
| None |
| Physician |
| Retired |
| None |
| None |
| None |
ctrib_self |
| 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 |
rcpt_date |
| 2022-10-04 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-22 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-09-25 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-20 00:00:00 |
date_thru |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
amount |
| 100 |
| 2500 |
| 10000 |
| 1000 |
| 100 |
| 100 |
| 100 |
| 1500 |
| 250 |
| 10000 |
| 150 |
| 1000 |
| 330 |
| 98 |
| 3300 |
| 3202 |
| 3300 |
cum_ytd |
| 200 |
| 2500 |
| 10000 |
| 1000 |
| 100 |
| 100 |
| 100 |
| 1500 |
| 250 |
| 10000 |
| 150 |
| 1000 |
| 877 |
| 0 |
| 0 |
| 0 |
| 0 |
cum_oth |
| 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 |
| Nation Builder |
| Reimbursement for Mailer. See Schedule E |
| Reimbursement for Mailer. See Schedule E |
| Reimbursement for Mailer. See Schedule E |
| Reimbursement for Mailer. See Schedule E |
cmte_id |
| None |
| 1404097 |
| 742617 |
| 992303 |
| None |
| None |
| None |
| 950674 |
| None |
| 1359280 |
| None |
| 1356185 |
| None |
| None |
| 1450111 |
| 1410340 |
| 1368125 |
tres_naml |
| 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 |
tres_namt |
| 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 |
tres_city |
| 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 |
tres_zip4 |
| 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 |
intr_namf |
| 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 |
intr_nams |
| 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 |
intr_st |
| 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 |
intr_emp |
| 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 |
intr_self |
| 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 |
cand_namf |
| 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 |
cand_nams |
| 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 |
offic_dscr |
| 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 |
juris_dscr |
| 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 |
off_s_h_cd |
| 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 |
bal_num |
| 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 |
sup_opp_cd |
| 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 |
memo_refno |
| 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 |
xref_schnm |
| 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 |
int_rate |
| 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 |
|
Table: smry
filing_id |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
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 |
| 26935 |
| 0 |
| 26935 |
| 330 |
| 27265 |
| 31500 |
| 0 |
| 31500 |
| 0 |
| 330 |
| 31830 |
| 1199 |
| 26935 |
| 9899 |
| 31500 |
| 6533 |
| 0 |
| 0 |
| 5000 |
| 26800 |
| 135 |
| 26935 |
| 0 |
| 0 |
| 0 |
| 330 |
| 0 |
| 330 |
| 0 |
| 0 |
| 0 |
| 31489 |
| 11 |
| 0 |
| 31500 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 9899 |
| 0 |
| 0 |
| 9899 |
amount_b |
| 30410 |
| 5000 |
| 35410 |
| 877 |
| 36287 |
| 38776 |
| 0 |
| 38776 |
| 0 |
| 877 |
| 39653 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
|
Table: splt
filing_id |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
| 2743784 |
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 |
pform_type |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| B1 |
| C |
ptran_id |
| INC66 |
| INC78 |
| INC81 |
| INC84 |
| INC74 |
| INC70 |
| INC77 |
| INC65 |
| INC68 |
| INC69 |
| INC75 |
| INC73 |
| PAY37 |
| NON60 |
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 |
elec_amount |
| 200 |
| 2500 |
| 10000 |
| 1000 |
| 100 |
| 100 |
| 100 |
| 1500 |
| 250 |
| 10000 |
| 150 |
| 1000 |
| 5000 |
| 300 |
elec_code |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
|