Home
Filing ID: 2741605
PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2741605&amendid=0
Table: cvr2_campaign_disclosure
| filing_id |
| 2741605 |
| amend_id |
| 0 |
| line_item |
| 1 |
| rec_type |
| CVR2 |
| form_type |
| F460 |
| tran_id |
| OFC1 |
| entity_cd |
| ATR |
| title |
| None |
| mail_city |
| None |
| mail_st |
| None |
| mail_zip4 |
| None |
| f460_part |
| 3 |
| cmte_id |
| None |
| enty_naml |
| Gould |
| enty_namf |
| David |
| enty_namt |
| None |
| enty_nams |
| None |
| enty_city |
| Norwalk |
| enty_st |
| CA |
| enty_zip4 |
| 90650 |
| enty_phon |
| 213 489-4792 |
| enty_fax |
| 213 489-4818 |
| enty_email |
| dlgould@gouldorellana.com |
| 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 |
| 2741605 |
| 2741605 |
| 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 |
| ATR |
| CAO |
| sig_date |
| 2022-10-26 00:00:00 |
| 2022-10-26 00:00:00 |
| sig_loc |
| None |
| None |
| sig_naml |
| David L. Gould |
| Peter Singer |
| sig_namf |
| None |
| None |
| sig_namt |
| None |
| None |
| sig_nams |
| None |
| None |
|
Table: cvr_campaign_disclosure
| filing_id |
| 2741605 |
| amend_id |
| 0 |
| rec_type |
| CVR |
| form_type |
| F460 |
| filer_id |
| 1445626 |
| entity_cd |
| CTL |
| filer_naml |
| Singer for Judge 2022 |
| filer_namf |
| None |
| filer_namt |
| None |
| filer_nams |
| None |
| report_num |
| 000 |
| rpt_date |
| 2022-10-26 00:00:00 |
| stmt_type |
| PE |
| late_rptno |
| None |
| from_date |
| 2022-09-25 00:00:00 |
| thru_date |
| 2022-10-22 00:00:00 |
| elect_date |
| 2022-11-08 00:00:00 |
| filer_city |
| San Diego |
| filer_st |
| CA |
| filer_zip4 |
| 92131 |
| filer_phon |
| 213 489-4792 |
| filer_fax |
| 213 489-4818 |
| file_email |
| dlgould@gouldorellana.com |
| mail_city |
| Norwalk |
| mail_st |
| CA |
| mail_zip4 |
| 90650 |
| tres_naml |
| Singer |
| tres_namf |
| Peter |
| tres_namt |
| None |
| tres_nams |
| None |
| tres_city |
| San Diego |
| tres_st |
| CA |
| tres_zip4 |
| 92131 |
| tres_phon |
| 619 299-8234 |
| tres_fax |
| None |
| tres_email |
| None |
| cmtte_type |
| C |
| control_yn |
| N |
| sponsor_yn |
| N |
| primfrm_yn |
| N |
| brdbase_yn |
| N |
| amendexp_1 |
| None |
| amendexp_2 |
| None |
| amendexp_3 |
| None |
| rpt_att_cb |
| None |
| cmtte_id |
| None |
| reportname |
| None |
| rptfromdt |
| None |
| rptthrudt |
| None |
| emplbus_cb |
| None |
| bus_name |
| None |
| bus_city |
| None |
| bus_st |
| None |
| bus_zip4 |
| None |
| bus_inter |
| None |
| busact_cb |
| None |
| busactvity |
| None |
| assoc_cb |
| None |
| assoc_int |
| None |
| other_cb |
| None |
| other_int |
| None |
| cand_naml |
| Singer |
| cand_namf |
| Peter |
| cand_namt |
| None |
| cand_nams |
| None |
| cand_city |
| San Diego |
| cand_st |
| CA |
| cand_zip4 |
| 92131 |
| cand_phon |
| 619 299-8234 |
| cand_fax |
| 213 489-4818 |
| cand_email |
| gotocourt@gmail.com |
| bal_name |
| None |
| bal_num |
| None |
| bal_juris |
| None |
| office_cd |
| SCJ |
| offic_dscr |
| None |
| juris_cd |
| OTH |
| juris_dscr |
| San Diego |
| 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 |
| 2741605 |
| 2741605 |
| 2741605 |
| amend_id |
| 0 |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| 3 |
| rec_type |
| DEBT |
| DEBT |
| DEBT |
| form_type |
| F |
| F |
| F |
| tran_id |
| PAY175 |
| PAY154 |
| PAY192 |
| entity_cd |
| IND |
| IND |
| OTH |
| payee_naml |
| Singer |
| Singer |
| Barclays |
| payee_namf |
| Peter W. |
| Peter W. |
| None |
| payee_namt |
| None |
| None |
| None |
| payee_nams |
| None |
| None |
| None |
| payee_city |
| San Diego |
| San Diego |
| Wilmington |
| payee_st |
| CA |
| CA |
| DE |
| payee_zip4 |
| 92131 |
| 92131 |
| 19899 |
| beg_bal |
| 16075 |
| 16003 |
| 0 |
| amt_incur |
| 0 |
| 0 |
| 1644 |
| amt_paid |
| 0 |
| 0 |
| 0 |
| end_bal |
| 16075 |
| 16003 |
| 1644 |
| expn_code |
| OFC |
| OFC |
| CMP |
| expn_dscr |
| None |
| None |
| Credit Card Payment |
| cmte_id |
| None |
| None |
| None |
| tres_naml |
| None |
| None |
| None |
| tres_namf |
| None |
| None |
| None |
| tres_namt |
| None |
| None |
| None |
| tres_nams |
| None |
| None |
| None |
| tres_city |
| None |
| None |
| None |
| tres_st |
| None |
| None |
| None |
| tres_zip4 |
| None |
| None |
| None |
| memo_code |
| None |
| None |
| None |
| memo_refno |
| None |
| None |
| None |
| bakref_tid |
| None |
| None |
| None |
| xref_schnm |
| None |
| None |
| None |
| xref_match |
| None |
| None |
| None |
|
Table: expn
| filing_id |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| amend_id |
| 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 |
| rec_type |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| form_type |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| G |
| G |
| G |
| tran_id |
| EXP176 |
| EXP178 |
| EXP180 |
| EXP177 |
| EXP181 |
| EXP183 |
| EXP186 |
| EXP188 |
| EXP191 |
| PDT5 |
| PDT6 |
| PDT7 |
| entity_cd |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| payee_naml |
| Budget Watchdogs Newsletter |
| California Voter Guide |
| eFundraising Connections |
| Senior Advocate-A Project of the Coalition for California |
| Gould & Orellana, LLC |
| eFundraising Connections |
| eFundraising Connections |
| eFundraising Connections |
| eFundraising Connections |
| Amazon.com |
| Futura Color Inc. |
| Amazon.com |
| payee_namf |
| 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 |
| payee_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_city |
| Torrance |
| Torrance |
| Sacramento |
| Torrance |
| Norwalk |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| North Seattle |
| Poway |
| North Seattle |
| payee_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| WA |
| CA |
| WA |
| payee_zip4 |
| 90505 |
| 90505 |
| 95814 |
| 90505 |
| 90650 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| 98109 |
| 92064 |
| 98109 |
| expn_date |
| 2022-09-30 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-22 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-09-29 00:00:00 |
| 2022-09-30 00:00:00 |
| amount |
| 18580 |
| 1143 |
| 5 |
| 6277 |
| 300 |
| 12 |
| 23 |
| 12 |
| 73 |
| 168 |
| 1082 |
| 118 |
| cum_ytd |
| 18580 |
| 1143 |
| 1337 |
| 6277 |
| 2950 |
| 1337 |
| 1337 |
| 1337 |
| 1337 |
| 286 |
| 2127 |
| 286 |
| cum_oth |
| 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 |
| expn_code |
| LIT |
| LIT |
| CMP |
| LIT |
| PRO |
| CMP |
| CMP |
| CMP |
| CMP |
| CMP |
| LIT |
| CMP |
| expn_dscr |
| None |
| None |
| Credit Card Processing Fee |
| None |
| None |
| Credit Card Processing Fee |
| Credit Card Processing Fee |
| Credit Card Processing Fee |
| Credit Card Processing Fee |
| None |
| None |
| None |
| agent_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Barclays |
| Barclays |
| Barclays |
| agent_namf |
| 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 |
| agent_nams |
| 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 |
| tres_naml |
| 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 |
| tres_namt |
| 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 |
| tres_city |
| 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 |
| tres_zip4 |
| 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 |
| cand_namf |
| 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 |
| cand_nams |
| 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 |
| offic_dscr |
| 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 |
| juris_dscr |
| 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 |
| off_s_h_cd |
| 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 |
| bal_num |
| 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 |
| sup_opp_cd |
| 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 |
| memo_refno |
| 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 |
| g_from_e_f |
| 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 |
| xref_match |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: filer_filings
| filer_id |
| 1445626 |
| filing_id |
| 2741605 |
| period_id |
| 251 |
| form_id |
| F460 |
| filing_sequence |
| 0 |
| filing_date |
| 2022-10-26 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-26 00:00:00 |
| filing_type |
| 22001 |
|
Table: filings
| filing_id |
| 2741605 |
| filing_type |
| 22001 |
|
Table: hdr
| filing_id |
| 2741605 |
| 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 |
| 2741605 |
| amend_id |
| 0 |
| line_item |
| 1 |
| rec_type |
| LOAN |
| form_type |
| B1 |
| tran_id |
| PAY3 |
| loan_type |
| None |
| entity_cd |
| IND |
| lndr_naml |
| Singer |
| lndr_namf |
| Peter W. |
| lndr_namt |
| None |
| lndr_nams |
| None |
| loan_city |
| San Diego |
| loan_st |
| CA |
| loan_zip4 |
| 92131 |
| loan_date1 |
| 2022-03-02 00:00:00 |
| loan_date2 |
| None |
| loan_amt1 |
| 0 |
| loan_amt2 |
| 20000 |
| loan_amt3 |
| 20000 |
| loan_amt4 |
| 20000 |
| loan_rate |
| 0.00 |
| loan_emp |
| San Diego Superior Court |
| loan_occ |
| Superior Court Commissioner |
| 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 |
| 20000 |
|
Table: rcpt
| filing_id |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| rec_type |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| form_type |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| tran_id |
| IDT70 |
| IDT71 |
| IDT72 |
| IDT73 |
| INC189 |
| IDT76 |
| IDT75 |
| IDT74 |
| IDT77 |
| entity_cd |
| IND |
| IND |
| IND |
| IND |
| COM |
| IND |
| IND |
| IND |
| IND |
| ctrib_naml |
| Crocker |
| Harkavy |
| Levin |
| Olson |
| East County Democratic Club |
| Beacham |
| Rice |
| Walsh |
| Stalnaker |
| ctrib_namf |
| Janice |
| Jeffrey |
| Adrienne |
| Gayle |
| None |
| David |
| Colin |
| Timothy |
| Patrick |
| ctrib_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| ctrib_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| ctrib_city |
| Del Mar |
| San Fernando |
| San Diego |
| Poway |
| El Cajon |
| Carlsbad |
| San Diego |
| San Diego |
| San Diego |
| ctrib_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| ctrib_zip4 |
| 92014 |
| 91340 |
| 92127 |
| 92064 |
| 92020 |
| 92009 |
| 92115 |
| 92116 |
| 92115 |
| ctrib_emp |
| San Dieguito Unified School District |
| County of Los Angeles |
| Rakuten |
| None |
| None |
| DAL Development |
| RAHD Group |
| Sinergia Housing, LLC |
| None |
| ctrib_occ |
| Teacher |
| Superior Court Commissioner |
| Product Designer |
| Retired |
| None |
| Affordable Housing |
| Affordable Housing Professional |
| Affordable Housing |
| Retired |
| ctrib_self |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tran_type |
| I |
| I |
| I |
| I |
| None |
| I |
| I |
| I |
| I |
| rcpt_date |
| 2022-09-28 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-22 00:00:00 |
| date_thru |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| amount |
| 100 |
| 250 |
| 500 |
| 250 |
| 200 |
| 500 |
| 500 |
| 500 |
| 100 |
| cum_ytd |
| 100 |
| 250 |
| 500 |
| 250 |
| 200 |
| 500 |
| 500 |
| 500 |
| 200 |
| cum_oth |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| ctrib_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cmte_id |
| None |
| None |
| None |
| None |
| 1296992 |
| None |
| None |
| None |
| None |
| tres_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_naml |
| eFundraising Connections |
| eFundraising Connections |
| eFundraising Connections |
| eFundraising Connections |
| None |
| eFundraising Connections |
| eFundraising Connections |
| eFundraising Connections |
| eFundraising Connections |
| intr_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_city |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| None |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| intr_st |
| CA |
| CA |
| CA |
| CA |
| None |
| CA |
| CA |
| CA |
| CA |
| intr_zip4 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| None |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
| intr_emp |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_occ |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_self |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| office_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| offic_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| juris_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| juris_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| dist_no |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| off_s_h_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bal_name |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bal_num |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bal_juris |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| sup_opp_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| memo_code |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| memo_refno |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bakref_tid |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| xref_schnm |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| xref_match |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| int_rate |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_cmteid |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: smry
| filing_id |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 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 |
| 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 |
| 4 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| rec_type |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| form_type |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| A |
| A |
| A |
| E |
| E |
| E |
| E |
| F |
| F |
| F |
| B1 |
| B1 |
| B1 |
| H |
| H |
| H |
| amount_a |
| 2900 |
| 0 |
| 2900 |
| 0 |
| 2900 |
| 26453 |
| 0 |
| 26453 |
| 1644 |
| 0 |
| 28097 |
| 40293 |
| 2900 |
| 0 |
| 26453 |
| 16740 |
| 0 |
| 0 |
| 53722 |
| 2900 |
| 0 |
| 2900 |
| 26424 |
| 29 |
| 0 |
| 26453 |
| 1644 |
| 0 |
| 1644 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| amount_b |
| 32974 |
| 20000 |
| 52974 |
| 1829 |
| 54803 |
| 36234 |
| 0 |
| 36234 |
| 33722 |
| 1829 |
| 71785 |
| 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 |
| 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 |
|
Table: splt
| filing_id |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| 2741605 |
| amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| pform_type |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| B1 |
| ptran_id |
| IDT70 |
| IDT71 |
| IDT72 |
| IDT73 |
| INC189 |
| IDT76 |
| IDT75 |
| IDT74 |
| IDT77 |
| IDT77 |
| PAY3 |
| 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 |
| elec_amount |
| 100 |
| 250 |
| 500 |
| 250 |
| 200 |
| 500 |
| 500 |
| 500 |
| 100 |
| 100 |
| 20000 |
| elec_code |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| P |
| G |
| P |
|