Home
Filing ID: 2743030
PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2743030&amendid=0
Table: cvr3_verification_info
| filing_id |
| 2743030 |
| 2743030 |
| 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-24 00:00:00 |
| 2022-10-24 00:00:00 |
| sig_loc |
| None |
| None |
| sig_naml |
| Lysa Ray |
| Peggy Huang |
| sig_namf |
| None |
| None |
| sig_namt |
| None |
| None |
| sig_nams |
| None |
| None |
|
Table: cvr_campaign_disclosure
| filing_id |
| 2743030 |
| amend_id |
| 0 |
| rec_type |
| CVR |
| form_type |
| F460 |
| filer_id |
| 1446077 |
| entity_cd |
| CTL |
| filer_naml |
| Huang for Judge 2022 |
| filer_namf |
| None |
| filer_namt |
| None |
| filer_nams |
| None |
| report_num |
| 000 |
| rpt_date |
| 2022-10-24 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-06-07 00:00:00 |
| filer_city |
| Santa Ana |
| filer_st |
| CA |
| filer_zip4 |
| 92704 |
| filer_phon |
| 714-696-8848 |
| filer_fax |
| None |
| file_email |
| lysaray.campaignservices@gmail.com |
| mail_city |
| None |
| mail_st |
| None |
| mail_zip4 |
| None |
| tres_naml |
| Ray |
| tres_namf |
| Lysa |
| tres_namt |
| None |
| tres_nams |
| None |
| tres_city |
| Santa Ana |
| tres_st |
| CA |
| tres_zip4 |
| 92704 |
| tres_phon |
| 714-540-2295 |
| tres_fax |
| None |
| tres_email |
| None |
| cmtte_type |
| C |
| control_yn |
| Y |
| 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 |
| Huang |
| cand_namf |
| Peggy |
| cand_namt |
| None |
| cand_nams |
| None |
| cand_city |
| Yorba Linda |
| cand_st |
| CA |
| cand_zip4 |
| 92886 |
| cand_phon |
| 714-696-8848 |
| cand_fax |
| None |
| cand_email |
| lysaray.campaignservices@gmail.com |
| bal_name |
| None |
| bal_num |
| None |
| bal_juris |
| None |
| office_cd |
| SCJ |
| offic_dscr |
| None |
| juris_cd |
| STW |
| juris_dscr |
| None |
| dist_no |
| 30 |
| off_s_h_cd |
| S |
| sup_opp_cd |
| None |
| employer |
| None |
| occupation |
| None |
| selfemp_cb |
| None |
| bal_id |
| None |
| cand_id |
| None |
|
Table: debt
| filing_id |
| 2743030 |
| amend_id |
| 0 |
| line_item |
| 1 |
| rec_type |
| DEBT |
| form_type |
| F |
| tran_id |
| PAY18 |
| entity_cd |
| IND |
| payee_naml |
| Huang |
| payee_namf |
| Peggy |
| payee_namt |
| None |
| payee_nams |
| None |
| payee_city |
| Yorba Linda |
| payee_st |
| CA |
| payee_zip4 |
| 92886 |
| beg_bal |
| 11825 |
| amt_incur |
| 0 |
| amt_paid |
| 0 |
| end_bal |
| 11825 |
| expn_code |
| FIL |
| expn_dscr |
| 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 |
| memo_code |
| None |
| memo_refno |
| None |
| bakref_tid |
| None |
| xref_schnm |
| None |
| xref_match |
| None |
|
Table: expn
| filing_id |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| amend_id |
| 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 |
| rec_type |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| form_type |
| D |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| G |
| tran_id |
| EXP237 |
| EXP208 |
| EXP211 |
| EXP212 |
| EXP224 |
| EXP229 |
| EXP240 |
| EXP239 |
| EXP276 |
| EXP277 |
| EXP221 |
| EXP235 |
| EXP236 |
| EXP207 |
| EXP237 |
| EXP274 |
| EXP220 |
| EDT9 |
| entity_cd |
| None |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| COM |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| payee_naml |
| Republican Party of OC |
| Anedot |
| Anedot |
| Anedot |
| Anedot |
| Anedot |
| Anedot |
| Anedot |
| Anedot |
| Anedot |
| Christopher Jones Consulting |
| Christopher Jones Consulting |
| Educate your Vote |
| Lysa Ray Campaign Services |
| Republican Party of OC |
| Senior Advocate |
| VBS Television |
| Minuteman Press |
| payee_namf |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| payee_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_city |
| Tustin |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Newcastle |
| Newcastle |
| Encino |
| Santa Ana |
| Tustin |
| Torrance |
| Westminster |
| Rancho Cucamonga |
| payee_st |
| CA |
| LA |
| LA |
| LA |
| LA |
| LA |
| LA |
| LA |
| LA |
| LA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| payee_zip4 |
| 92780 |
| 70818 |
| 70818 |
| 70818 |
| 70818 |
| 70818 |
| 70818 |
| 70818 |
| 70818 |
| 70818 |
| 95658 |
| 95658 |
| 91436 |
| 92704 |
| 92780 |
| 90505 |
| 92683 |
| 91730 |
| expn_date |
| 2022-10-20 00:00:00 |
| 2022-09-26 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-10-02 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-15 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-05 00:00:00 |
| amount |
| 20000 |
| 12 |
| 61 |
| 1 |
| 41 |
| 172 |
| 2 |
| 1441 |
| 10 |
| 65 |
| 6720 |
| 5000 |
| 5000 |
| 600 |
| 20000 |
| 8907 |
| 1000 |
| 4220 |
| cum_ytd |
| 20000 |
| 4181 |
| 4181 |
| 4181 |
| 4181 |
| 4181 |
| 4181 |
| 4181 |
| 4181 |
| 4181 |
| 39504 |
| 39504 |
| 14996 |
| 5600 |
| 20000 |
| 8907 |
| 1000 |
| 8285 |
| cum_oth |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| expn_code |
| MON |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| CNS |
| LIT |
| LIT |
| PRO |
| CTB |
| LIT |
| TEL |
| LIT |
| expn_dscr |
| None |
| cc processing |
| cc processing |
| cc processing |
| cc processing |
| cc processing |
| cc processing |
| cc processing |
| cc processing |
| cc processing |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| agent_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Christopher Jones Consulting |
| agent_namf |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| agent_nams |
| 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 |
| 1345655 |
| None |
| None |
| 1439476 |
| None |
| None |
| tres_naml |
| 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 |
| tres_namt |
| 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 |
| tres_city |
| 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 |
| tres_zip4 |
| 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 |
| cand_namf |
| 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 |
| cand_nams |
| 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 |
| offic_dscr |
| 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 |
| juris_dscr |
| 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 |
| off_s_h_cd |
| 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 |
| bal_num |
| 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 |
| sup_opp_cd |
| S |
| 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 |
| memo_refno |
| 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 |
| g_from_e_f |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| E |
| xref_schnm |
| 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 |
|
Table: filer_filings
| filer_id |
| 1446077 |
| filing_id |
| 2743030 |
| 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-24 00:00:00 |
| filing_type |
| 22001 |
|
Table: filings
| filing_id |
| 2743030 |
| filing_type |
| 22001 |
|
Table: hdr
| filing_id |
| 2743030 |
| 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 |
| 2743030 |
| amend_id |
| 0 |
| line_item |
| 1 |
| rec_type |
| LOAN |
| form_type |
| B1 |
| tran_id |
| PAY7 |
| loan_type |
| None |
| entity_cd |
| IND |
| lndr_naml |
| Huang |
| lndr_namf |
| Peggy |
| lndr_namt |
| None |
| lndr_nams |
| None |
| loan_city |
| Yorba Linda |
| loan_st |
| CA |
| loan_zip4 |
| 92886 |
| loan_date1 |
| 2022-03-18 00:00:00 |
| loan_date2 |
| None |
| loan_amt1 |
| 0 |
| loan_amt2 |
| 100 |
| loan_amt3 |
| 100 |
| loan_amt4 |
| 100 |
| loan_rate |
| 0.00 |
| loan_emp |
| None |
| loan_occ |
| None |
| 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 |
| 100 |
|
Table: rcpt
| filing_id |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 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 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| 24 |
| 25 |
| 26 |
| 27 |
| 28 |
| 29 |
| 30 |
| 31 |
| 32 |
| 33 |
| 34 |
| 35 |
| 36 |
| 37 |
| 38 |
| 39 |
| 40 |
| 41 |
| 42 |
| 43 |
| 44 |
| 45 |
| 46 |
| 47 |
| 48 |
| 49 |
| 50 |
| 51 |
| 52 |
| 53 |
| 54 |
| 55 |
| 56 |
| 57 |
| 58 |
| 59 |
| 60 |
| 61 |
| 62 |
| 63 |
| 64 |
| 65 |
| 66 |
| 67 |
| 68 |
| 69 |
| 70 |
| 71 |
| rec_type |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| form_type |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| C |
| tran_id |
| INC278 |
| INC190 |
| INC202 |
| INC245 |
| INC273 |
| INC246 |
| INC223 |
| INC230 |
| INC194 |
| INC191 |
| INC232 |
| INC256 |
| INC219 |
| INC243 |
| INC242 |
| INC275 |
| INC198 |
| INC201 |
| INC195 |
| INC267 |
| INC281 |
| INC206 |
| INC252 |
| INC228 |
| INC215 |
| INC254 |
| INC218 |
| INC225 |
| INC266 |
| INC268 |
| INC260 |
| INC263 |
| INC264 |
| INC193 |
| INC210 |
| INC227 |
| INC226 |
| INC222 |
| INC248 |
| INC271 |
| INC199 |
| INC253 |
| INC272 |
| INC255 |
| INC213 |
| INC205 |
| INC279 |
| INC196 |
| INC247 |
| INC244 |
| INC251 |
| INC250 |
| INC269 |
| INC258 |
| INC265 |
| INC261 |
| INC257 |
| INC200 |
| INC238 |
| INC270 |
| INC231 |
| INC262 |
| INC233 |
| INC214 |
| INC203 |
| INC204 |
| INC249 |
| INC259 |
| INC234 |
| INC217 |
| NON197 |
| entity_cd |
| IND |
| OTH |
| IND |
| IND |
| IND |
| IND |
| OTH |
| IND |
| SCC |
| COM |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| OTH |
| IND |
| IND |
| IND |
| IND |
| IND |
| COM |
| IND |
| IND |
| OTH |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| OTH |
| IND |
| IND |
| IND |
| OTH |
| IND |
| IND |
| OTH |
| IND |
| IND |
| OTH |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| OTH |
| OTH |
| IND |
| OTH |
| OTH |
| OTH |
| IND |
| IND |
| IND |
| OTH |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| ctrib_naml |
| Alapati |
| American Auto Parking Building |
| Assaf |
| Awwad |
| Baqai |
| Bashir |
| Brighton Management |
| Byrne |
| California Real Estate PAC |
| Californians for A Better Future |
| Campbell |
| Campbell |
| Chan |
| Chen |
| Chen |
| Chiou |
| Chiu |
| CodeFour |
| Desagani |
| Dwyer |
| Edwards |
| Fan |
| Farooqi |
| Garden Grove Police Association PAC |
| Gogo |
| Hassan |
| Interstate Management Trust Account for Hotel Owners |
| Kao |
| Kelter |
| Kim |
| Kupferstein |
| Larkin |
| Lavenau |
| Law Offices for Kermit Marsh |
| Leong |
| Levine |
| Liao |
| Louis Matzo Movie Management Inc |
| Malik |
| Maloney |
| MKGates Properties HB LLC( ) |
| Monis |
| Nelson |
| New Heritage Recruiters, Inc, |
| Palmer |
| Pang |
| Peterson |
| Reddy |
| Rehman |
| Rizvi |
| Saghir |
| Singh |
| Spicy Tribe, Inc. |
| Su Kings Enterprise |
| Sundstedt |
| Surf City Auto Group Inc. |
| Sweetwater Senior Care LLC(Saleem Moosani) |
| Tommy T's Body Piercing |
| Tran |
| Tsai |
| Twining |
| U. S. Wheel |
| Wang |
| Wang |
| Wonderly |
| Wonderly |
| Yeldram |
| Yen |
| Yoh |
| Young |
| Fan |
| ctrib_namf |
| Raja |
| None |
| Elias |
| Ahmad |
| Imad |
| Iqbal |
| None |
| Chris |
| CREPAC |
| None |
| Heather |
| Lynn |
| Peter |
| Jiawen |
| Rebecca |
| Allen |
| Chue Huang |
| None |
| Kishore |
| J. Devin |
| Rosemary |
| Xinjin |
| Najma |
| None |
| Johnny |
| Mubashir |
| None |
| John |
| Kevin |
| Chin |
| Ronald |
| William |
| Sean |
| None |
| Calvin |
| Arthur |
| Benson |
| None |
| Navaz |
| Kyungja |
| None |
| Sayed |
| Richard |
| None |
| Peggy |
| Simon |
| Jay |
| Mandeep |
| Ahsan |
| Syed |
| Syed |
| Shivinderitt |
| None |
| None |
| Michael |
| None |
| None |
| None |
| Luong |
| Mandy |
| Edward |
| None |
| Coleen |
| John |
| Chandler |
| Chandler |
| Ahmed |
| George |
| Joshua |
| William |
| Joseph |
| ctrib_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| ctrib_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| Anaheim |
| Yorba Linda |
| Huntington Beach |
| Yorba Linda |
| Corona |
| Anaheim |
| Diamond Bar |
| Huntington Beach |
| Los Angeles |
| Irvine |
| Huntington Beach |
| Yorba Linda |
| Monterey Park |
| Yorba Linda |
| Irvine |
| Orange |
| Irvine |
| Huntington Beach |
| Irvine |
| Huntington Beach |
| Anaheim |
| Yorba Linda |
| Yorba Linda |
| Garden Grove |
| San Jose |
| Anaheim |
| Plano |
| Rowland Heights |
| Huntington Beach |
| Orange |
| Huntington Beach |
| Huntington Beach |
| Rancho Santa Margarita |
| Fountain Valley |
| Diamond Bar |
| Mission Viejo |
| Rowland Heights |
| Yorba Linda |
| Yorba Linda |
| Fullerton |
| Huntington Beach |
| Anaheim |
| Tustin |
| Brea |
| Laguna Niguel |
| Torrance |
| Santa Ana |
| Irvine |
| Yorba Linda |
| Yorba Linda |
| Yorba Linda |
| Yorba Linda |
| Los Angeles |
| Riverside |
| Huntington Beach |
| Huntington Beach |
| Yorba Linda |
| Huntington Beach |
| El Monte |
| Irvine |
| Long Beach |
| Huntington Beach |
| Huntington Beach |
| Yorba Linda |
| Newport Beach |
| Newport Beach |
| Yorba Linda |
| Yorba Linda |
| Anaheim |
| Yorba Linda |
| Newport Beach |
| ctrib_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| TX |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| ctrib_zip4 |
| 92807 |
| 92886 |
| 92648 |
| 92886 |
| 92883 |
| 92808 |
| 91765 |
| 92648 |
| 90071 |
| 92618 |
| 92648 |
| 92886 |
| 91755 |
| 92887 |
| 92620 |
| 92869 |
| 92602 |
| 92649 |
| 92603 |
| 92648 |
| 92807 |
| 92886 |
| 92887 |
| 92840 |
| 95136 |
| 92807 |
| 75024 |
| 91748 |
| 92649 |
| 92869 |
| 92648 |
| 92649 |
| 92688 |
| 92708 |
| 91765 |
| 92692 |
| 91748 |
| 92886 |
| 92886 |
| 92835 |
| 92648 |
| 92807 |
| 92780 |
| 92821 |
| 92607 |
| 90505 |
| 92705 |
| 92618 |
| 92887 |
| 92886 |
| 92886 |
| 92886 |
| 90006 |
| 92506 |
| 92648 |
| 92647 |
| 92886 |
| 92648 |
| 91731 |
| 92620 |
| 90806 |
| 92649 |
| 92646 |
| 92887 |
| 92660 |
| 92660 |
| 92887 |
| 92886 |
| 92807 |
| 92886 |
| 92660 |
| ctrib_emp |
| Seacrest Medical Billing |
| None |
| Nations Insurance |
| Castlerock Environmental |
| None |
| None |
| None |
| None |
| None |
| None |
| Coldwell Banker |
| Self |
| Council member |
| None |
| Self |
| Self |
| Win Time LLC |
| None |
| Self |
| John Dwyer Construction |
| TOwn & Country Design |
| Fannet Technologies |
| Sk8 ASR. Development |
| None |
| State of California |
| Victoria Hospice |
| None |
| Mirage Entertainment Design |
| Kelter Bros LLC |
| Meridian Sports Med & Pain |
| None |
| None |
| Bayley Construction |
| None |
| C & L Accountancy Corp. |
| None |
| Self |
| None |
| None |
| Shin Imaging |
| None |
| Self |
| None |
| None |
| None |
| Royal Business Bank |
| Microscale Industries |
| Self |
| LA Cafe |
| Self |
| Self |
| II Software Dev. |
| None |
| None |
| Sundslept & Goodman |
| None |
| None |
| None |
| Evergreen Auto Parts |
| PA College Prep |
| None |
| None |
| Huntington Christian School |
| Self |
| Self |
| Self |
| NTT Data |
| None |
| None |
| JBY Enterprise Inc, |
| Brighton Management |
| ctrib_occ |
| Secretary |
| None |
| President |
| Executive |
| Retired |
| Retired |
| None |
| Retired |
| None |
| None |
| Real Estate |
| Realtor |
| City of Monterey Park |
| Retired |
| Real Estate |
| Doctor |
| Owner |
| None |
| Physician |
| President |
| Owner |
| CEO |
| Sr. Dev. |
| None |
| Judge |
| CEO |
| None |
| Manager |
| RE Investment |
| Physician |
| Retired |
| Retired |
| Cons. |
| None |
| CPA |
| Retired |
| Financial Advisor |
| None |
| Retired |
| Owner |
| None |
| Physician |
| Retired |
| None |
| Retired |
| Bank Officer |
| Shipping Manager |
| Psychiatrist |
| CEO |
| Physician |
| Real Estate |
| Engineer |
| None |
| None |
| Owner |
| None |
| None |
| None |
| President |
| Math Tutor |
| Retired |
| None |
| Educator |
| Manager |
| Real Estate |
| Real Estate |
| Director |
| Retired |
| Retired |
| CEO |
| President |
| ctrib_self |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tran_type |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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-20 00:00:00 |
| 2022-09-28 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-22 00:00:00 |
| 2022-10-16 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-09 00:00:00 |
| 2022-09-26 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-10-16 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-10-16 00:00:00 |
| 2022-10-16 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-13 00:00:00 |
| date_thru |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 500 |
| 4900 |
| 1000 |
| 150 |
| 200 |
| 150 |
| 3000 |
| 500 |
| 5000 |
| 1000 |
| 500 |
| 150 |
| 150 |
| 300 |
| 150 |
| 250 |
| 1000 |
| 1000 |
| 1000 |
| 150 |
| 100 |
| 1000 |
| 150 |
| 500 |
| 500 |
| 300 |
| 500 |
| 500 |
| 400 |
| 100 |
| 150 |
| 500 |
| 500 |
| 1000 |
| 250 |
| 100 |
| 500 |
| 4900 |
| 500 |
| 500 |
| 1000 |
| 500 |
| 500 |
| 100 |
| 500 |
| 5000 |
| 100 |
| 1500 |
| 150 |
| 150 |
| 150 |
| 150 |
| 100 |
| 100 |
| 500 |
| 500 |
| 150 |
| 1000 |
| 1000 |
| 100 |
| 500 |
| 700 |
| 250 |
| 500 |
| 20000 |
| 10000 |
| 150 |
| 500 |
| 200 |
| 200 |
| 2200 |
| cum_ytd |
| 500 |
| 4900 |
| 1000 |
| 150 |
| 200 |
| 150 |
| 3000 |
| 500 |
| 5000 |
| 1000 |
| 500 |
| 150 |
| 150 |
| 300 |
| 150 |
| 250 |
| 2000 |
| 1000 |
| 1000 |
| 150 |
| 100 |
| 1000 |
| 150 |
| 500 |
| 500 |
| 300 |
| 500 |
| 500 |
| 400 |
| 100 |
| 150 |
| 500 |
| 500 |
| 1000 |
| 250 |
| 100 |
| 500 |
| 4900 |
| 500 |
| 500 |
| 1000 |
| 500 |
| 500 |
| 100 |
| 500 |
| 7500 |
| 100 |
| 1500 |
| 150 |
| 150 |
| 150 |
| 150 |
| 100 |
| 100 |
| 500 |
| 500 |
| 150 |
| 1000 |
| 1000 |
| 100 |
| 500 |
| 700 |
| 250 |
| 1000 |
| 30000 |
| 30000 |
| 150 |
| 1000 |
| 200 |
| 200 |
| 2200 |
| cum_oth |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| ctrib_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| TV Ads |
| cmte_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 890106 |
| 1420444 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 960881 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_emp |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_occ |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_self |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| office_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| offic_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| juris_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| juris_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| dist_no |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| off_s_h_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bal_name |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bal_num |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bal_juris |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| sup_opp_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| memo_code |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| memo_refno |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| bakref_tid |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| xref_schnm |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| xref_match |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| int_rate |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| intr_cmteid |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 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 |
| 80375 |
| 0 |
| 80375 |
| 2200 |
| 82575 |
| 49032 |
| 0 |
| 49032 |
| 0 |
| 2200 |
| 51232 |
| 7389 |
| 80375 |
| 0 |
| 49032 |
| 38732 |
| 0 |
| 0 |
| 11925 |
| 80250 |
| 125 |
| 80375 |
| 0 |
| 0 |
| 0 |
| 2200 |
| 0 |
| 2200 |
| 20000 |
| 0 |
| 20000 |
| 49032 |
| 0 |
| 0 |
| 49032 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| amount_b |
| 235203 |
| 100 |
| 235303 |
| 3800 |
| 239103 |
| 217571 |
| 0 |
| 217571 |
| 11825 |
| 3800 |
| 233195 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 2743030 |
| 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 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| 24 |
| 25 |
| 26 |
| 27 |
| 28 |
| 29 |
| 30 |
| 31 |
| 32 |
| 33 |
| 34 |
| 35 |
| 36 |
| 37 |
| 38 |
| 39 |
| 40 |
| 41 |
| 42 |
| 43 |
| 44 |
| 45 |
| 46 |
| 47 |
| 48 |
| 49 |
| 50 |
| 51 |
| 52 |
| 53 |
| 54 |
| 55 |
| 56 |
| 57 |
| 58 |
| 59 |
| 60 |
| 61 |
| 62 |
| 63 |
| 64 |
| 65 |
| 66 |
| 67 |
| 68 |
| 69 |
| 70 |
| 71 |
| 72 |
| 73 |
| 74 |
| 75 |
| 76 |
| 77 |
| pform_type |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| B1 |
| C |
| D |
| ptran_id |
| INC278 |
| INC190 |
| INC202 |
| INC245 |
| INC273 |
| INC246 |
| INC223 |
| INC230 |
| INC194 |
| INC191 |
| INC232 |
| INC256 |
| INC219 |
| INC243 |
| INC242 |
| INC275 |
| INC198 |
| INC198 |
| INC201 |
| INC195 |
| INC267 |
| INC281 |
| INC206 |
| INC252 |
| INC228 |
| INC215 |
| INC254 |
| INC218 |
| INC225 |
| INC266 |
| INC268 |
| INC260 |
| INC263 |
| INC264 |
| INC193 |
| INC210 |
| INC227 |
| INC226 |
| INC222 |
| INC248 |
| INC271 |
| INC199 |
| INC253 |
| INC272 |
| INC255 |
| INC213 |
| INC205 |
| INC205 |
| INC279 |
| INC196 |
| INC247 |
| INC244 |
| INC251 |
| INC250 |
| INC269 |
| INC258 |
| INC265 |
| INC261 |
| INC257 |
| INC200 |
| INC238 |
| INC270 |
| INC231 |
| INC262 |
| INC233 |
| INC214 |
| INC214 |
| INC203 |
| INC204 |
| INC249 |
| INC259 |
| INC259 |
| INC234 |
| INC217 |
| PAY7 |
| NON197 |
| EXP237 |
| elec_date |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 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 |
| 500 |
| 4900 |
| 1000 |
| 150 |
| 200 |
| 150 |
| 3000 |
| 500 |
| 5000 |
| 1000 |
| 500 |
| 150 |
| 150 |
| 300 |
| 150 |
| 250 |
| 1000 |
| 1000 |
| 1000 |
| 1000 |
| 150 |
| 100 |
| 1000 |
| 150 |
| 500 |
| 500 |
| 300 |
| 500 |
| 500 |
| 400 |
| 100 |
| 150 |
| 500 |
| 500 |
| 1000 |
| 250 |
| 100 |
| 500 |
| 4900 |
| 500 |
| 500 |
| 1000 |
| 500 |
| 500 |
| 100 |
| 500 |
| 2500 |
| 5000 |
| 100 |
| 1500 |
| 150 |
| 150 |
| 150 |
| 150 |
| 100 |
| 100 |
| 500 |
| 500 |
| 150 |
| 1000 |
| 1000 |
| 100 |
| 500 |
| 700 |
| 250 |
| 500 |
| 500 |
| 30000 |
| 30000 |
| 150 |
| 500 |
| 500 |
| 200 |
| 200 |
| 100 |
| 2200 |
| 20000 |
| elec_code |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| P |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| P |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| P |
| G |
| G |
| G |
| G |
| P |
| G |
| G |
| G |
| P |
| G |
| G |
|