Home
Filing ID: 2742888
PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2742888&amendid=0
Table: cvr3_verification_info
| filing_id |
| 2742888 |
| 2742888 |
| 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 |
| Kristie Bruce-Lane |
| sig_namf |
| None |
| None |
| sig_namt |
| None |
| None |
| sig_nams |
| None |
| None |
|
Table: cvr_campaign_disclosure
| filing_id |
| 2742888 |
| amend_id |
| 0 |
| rec_type |
| CVR |
| form_type |
| F460 |
| filer_id |
| 1439314 |
| entity_cd |
| CTL |
| filer_naml |
| Bruce-Lane for Assembly 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 |
| San Diego |
| filer_st |
| CA |
| filer_zip4 |
| 92127 |
| filer_phon |
| 714-540-2295 |
| filer_fax |
| None |
| file_email |
| lysaray.campaignservices@gmail.com |
| mail_city |
| Santa Ana |
| mail_st |
| CA |
| mail_zip4 |
| 92704 |
| tres_naml |
| Ray |
| tres_namf |
| Lysa |
| tres_namt |
| None |
| tres_nams |
| None |
| tres_city |
| lysaray.campaignservices@gmail |
| tres_st |
| CA |
| tres_zip4 |
| 92704 |
| tres_phon |
| 7145402295 |
| 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 |
| Bruce-Lane |
| cand_namf |
| Kristie |
| cand_namt |
| None |
| cand_nams |
| None |
| cand_city |
| Sant Dieco |
| cand_st |
| CA |
| cand_zip4 |
| 92127 |
| cand_phon |
| 805-427-2084 |
| cand_fax |
| None |
| cand_email |
| kristie@kristiebrucelane.com |
| bal_name |
| None |
| bal_num |
| None |
| bal_juris |
| None |
| office_cd |
| ASM |
| offic_dscr |
| None |
| juris_cd |
| ASM |
| juris_dscr |
| None |
| dist_no |
| 76 |
| off_s_h_cd |
| S |
| sup_opp_cd |
| None |
| employer |
| None |
| occupation |
| None |
| selfemp_cb |
| None |
| bal_id |
| None |
| cand_id |
| None |
|
Table: expn
| filing_id |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 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 |
| 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 |
| rec_type |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| form_type |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| tran_id |
| EXP684 |
| EXP688 |
| EXP691 |
| EXP695 |
| EXP704 |
| EXP712 |
| EXP720 |
| EXP725 |
| EXP726 |
| EXP732 |
| EXP744 |
| EXP742 |
| EXP745 |
| EXP697 |
| EXP683 |
| EXP675 |
| EXP698 |
| EXP735 |
| EXP733 |
| EXP737 |
| EXP694 |
| EXP699 |
| EXP734 |
| EDT48 |
| EDT51 |
| EDT47 |
| EDT50 |
| EDT49 |
| EDT45 |
| EDT46 |
| entity_cd |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| IND |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| payee_naml |
| Anedot |
| Anedot |
| Anedot |
| Anedot |
| Anedot |
| Anedot |
| Anedot |
| Anedot |
| Anedot |
| Anedot |
| Anedot |
| Anedot |
| Bank of America |
| Huntoon |
| Lysa Ray Campaign Services |
| Pacific Political,Inc. |
| Pacific Political,Inc. |
| Pacific Political,Inc. |
| Pacific Political,Inc. |
| Pacific Political,Inc. |
| Strategic Media Services |
| Wendy Warfield & Assoc. |
| Wendy Warfield & Assoc. |
| Meta, Inc. |
| Meta, Inc. |
| USPS |
| USPS |
| USPS |
| Cox Media San Diego |
| Zeta Global |
| payee_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Melinda |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_city |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Baton Rouge |
| Santa Ana |
| San Diego |
| Santa Ana |
| Vista |
| Vista |
| Vista |
| Vista |
| Vista |
| Arlington |
| Sacramento |
| Sacramento |
| Menlo Park |
| Menlo Park |
| Santa Ana |
| Santa Ana |
| Santa Ana |
| San Diego |
| New York |
| payee_st |
| LA |
| LA |
| LA |
| LA |
| LA |
| LA |
| LA |
| LA |
| LA |
| LA |
| LA |
| LA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| VA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| NY |
| payee_zip4 |
| 70808 |
| 70808 |
| 70808 |
| 70808 |
| 70808 |
| 70808 |
| 70808 |
| 70808 |
| 70808 |
| 70808 |
| 70808 |
| 70808 |
| 92704 |
| 92128 |
| 92704 |
| 92081 |
| 92081 |
| 92081 |
| 92081 |
| 92081 |
| 22203 |
| 95814 |
| 95814 |
| 94025 |
| 94025 |
| 92705 |
| 92705 |
| 92705 |
| 92111 |
| 10016 |
| expn_date |
| 2022-09-28 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-10-01 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-08 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-10-16 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-22 00:00:00 |
| 2022-10-22 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-09-26 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-09-27 00:00:00 |
| amount |
| 2 |
| 7 |
| 84 |
| 10 |
| 122 |
| 7 |
| 2 |
| 1 |
| 15 |
| 6 |
| 2 |
| 65 |
| 110 |
| 1837 |
| 750 |
| 2073 |
| 18751 |
| 64214 |
| 18251 |
| 5000 |
| 12690 |
| 1501 |
| 1504 |
| 3000 |
| 5000 |
| 7967 |
| 32529 |
| 7967 |
| 8300 |
| 4300 |
| cum_ytd |
| 2981 |
| 2981 |
| 2981 |
| 2981 |
| 2981 |
| 2981 |
| 2981 |
| 2981 |
| 2981 |
| 2981 |
| 2981 |
| 2981 |
| 110 |
| 5392 |
| 8250 |
| 343868 |
| 343868 |
| 343868 |
| 343868 |
| 343868 |
| 93929 |
| 13506 |
| 13506 |
| 8000 |
| 8000 |
| 177409 |
| 177409 |
| 177409 |
| 58054 |
| 30100 |
| 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 |
| expn_chkno |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| expn_code |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| CMP |
| PRO |
| CMP |
| LIT |
| LIT |
| LIT |
| CMP |
| TEL |
| FND |
| FND |
| CMP |
| CMP |
| POS |
| POS |
| POS |
| TEL |
| TEL |
| expn_dscr |
| cc processing |
| cc processing |
| cc processing |
| cc processing |
| cc processing |
| cc processing |
| cc processing |
| cc processing |
| cc processing |
| cc processing |
| cc processing |
| cc processing |
| Bank fees |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| Pacific Political,Inc. |
| Pacific Political,Inc. |
| Pacific Political,Inc. |
| Pacific Political,Inc. |
| Pacific Political,Inc. |
| Strategic Media Services |
| Strategic Media Services |
| agent_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 |
| agent_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 |
| agent_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 |
| cmte_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| g_from_e_f |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| 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 |
| 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 |
|
Table: filer_filings
| filer_id |
| 1439314 |
| filing_id |
| 2742888 |
| 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 |
| 2742888 |
| filing_type |
| 22001 |
|
Table: hdr
| filing_id |
| 2742888 |
| 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 |
| 2742888 |
| 2742888 |
| 2742888 |
| amend_id |
| 0 |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| 3 |
| rec_type |
| LOAN |
| LOAN |
| LOAN |
| form_type |
| B1 |
| B1 |
| B1 |
| tran_id |
| PAY2 |
| PAY264 |
| PAY579 |
| loan_type |
| None |
| None |
| None |
| entity_cd |
| IND |
| IND |
| IND |
| lndr_naml |
| Bruce-Lane |
| Bruce-Lane |
| Bruce-Lane |
| lndr_namf |
| Kristie |
| Kristie |
| Kristie |
| lndr_namt |
| None |
| None |
| None |
| lndr_nams |
| None |
| None |
| None |
| loan_city |
| San Diego |
| San Diego |
| San Diego |
| loan_st |
| CA |
| CA |
| CA |
| loan_zip4 |
| 92127 |
| 92127 |
| 92127 |
| loan_date1 |
| 2021-07-07 00:00:00 |
| 2021-12-31 00:00:00 |
| 2022-08-19 00:00:00 |
| loan_date2 |
| None |
| None |
| None |
| loan_amt1 |
| 0 |
| 0 |
| 0 |
| loan_amt2 |
| 5000 |
| 75000 |
| 20000 |
| loan_amt3 |
| 297100 |
| 297100 |
| 297100 |
| loan_amt4 |
| 5000 |
| 75000 |
| 20000 |
| loan_rate |
| 0.00 |
| 0.00 |
| 0.00 |
| loan_emp |
| None |
| None |
| None |
| loan_occ |
| Candidate |
| Candidate |
| Candidate |
| loan_self |
| None |
| None |
| None |
| 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 |
| intr_naml |
| None |
| None |
| None |
| intr_namf |
| None |
| None |
| None |
| intr_namt |
| None |
| None |
| None |
| intr_nams |
| None |
| None |
| None |
| intr_city |
| None |
| None |
| None |
| intr_st |
| None |
| None |
| None |
| intr_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 |
| loan_amt5 |
| 0 |
| 0 |
| 0 |
| loan_amt6 |
| 0 |
| 0 |
| 0 |
| loan_amt7 |
| 0 |
| 0 |
| 0 |
| loan_amt8 |
| 5000 |
| 75000 |
| 20000 |
|
Table: rcpt
| filing_id |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 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 |
| 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 |
| 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 |
| 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 |
| C |
| tran_id |
| INC682 |
| INC724 |
| INC707 |
| INC721 |
| INC703 |
| INC709 |
| INC702 |
| INC738 |
| INC708 |
| INC687 |
| INC696 |
| INC692 |
| INC728 |
| INC676 |
| INC689 |
| INC730 |
| INC741 |
| INC686 |
| INC701 |
| INC678 |
| INC677 |
| INC710 |
| INC723 |
| INC680 |
| INC693 |
| INC705 |
| INC727 |
| INC681 |
| INC706 |
| INC700 |
| INC736 |
| INC714 |
| NON679 |
| entity_cd |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| OTH |
| COM |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| COM |
| COM |
| OTH |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| OTH |
| OTH |
| COM |
| IND |
| PTY |
| ctrib_naml |
| Bruce-Lane |
| Casserly |
| Cihak |
| Colapinto |
| Constantine |
| Doheny |
| DWO Enterprises Inc |
| Equal Rights for All PAC |
| Farrell |
| Giglio |
| Hochberg |
| Kaagan |
| Kaagan |
| Kahn |
| Klink |
| Lindstrom |
| Marymee |
| Mikita-Gomez |
| Milk Producers Council |
| New Majority PAC |
| Pavement Recycling Systems |
| Pavlicek |
| Petersen |
| Ralphs |
| Reese |
| Reichel |
| Schlaerli |
| Schmidt |
| Tomasco Inc. |
| Tri-Cal Inc |
| United Agricultural PAC |
| Walker |
| Ca Republican Party |
| ctrib_namf |
| Kristie |
| Chris |
| John |
| Perry |
| Thomas |
| E. L. Sean |
| None |
| None |
| Thomas |
| Bobbi |
| Jason |
| Eliot |
| Eliot |
| Samuel |
| Kathleen |
| Brita |
| Brett |
| Kathleen |
| None |
| None |
| None |
| Adam |
| Robert |
| Thomas |
| Dran |
| Suzie |
| Heather |
| Mark |
| None |
| None |
| None |
| Tory |
| None |
| 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 |
| 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 |
| ctrib_city |
| San Diego |
| Escondido |
| San Diego |
| San Diego |
| Poway |
| San Diego |
| Rancho Santa Fe |
| Cupertino |
| Del Mar |
| San Diego |
| La Jolla |
| Escondido |
| Escondido |
| Solana Beach |
| Rancho Santa Fe |
| San Diego |
| Santa Ynez |
| San Diego |
| Ontario |
| San Rafael |
| Mira Loma |
| San Diego |
| Poway |
| San Diego |
| Vista |
| Del Mar |
| Santee |
| San Diego |
| Escondido |
| Corona |
| Irvine |
| Murrieta |
| Sacramento |
| ctrib_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| None |
| CA |
| None |
| None |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| None |
| CA |
| CA |
| CA |
| None |
| CA |
| CA |
| ctrib_zip4 |
| 92127 |
| 92027 |
| 92131 |
| 92130 |
| 92064 |
| 92130 |
| 92067 |
| 95014 |
| 92014 |
| 92128 |
| 92037 |
| 92029 |
| 92029 |
| 92075 |
| 92091 |
| 92109 |
| 93460 |
| 92128 |
| 91762 |
| 94901 |
| 91752 |
| 92129 |
| 92064 |
| 92127 |
| 92081 |
| 92014 |
| 92071 |
| 92131 |
| 92025 |
| 92882 |
| 92606 |
| 92562 |
| 95814 |
| ctrib_emp |
| None |
| Abbott Labs |
| None |
| None |
| Axos Bank |
| Self |
| None |
| None |
| ASMG Inc. |
| None |
| Self |
| 24 Hr Fitness |
| 24 Hr Fitness |
| Great Western Mortgage |
| None |
| None |
| SYRWCD |
| None |
| None |
| None |
| None |
| Monoceros Biosystems LLC |
| None |
| None |
| Salt and Light Council |
| Advanced Nursing & Home Health |
| Servicenow |
| Liberty National Corporation |
| None |
| None |
| None |
| Tory Walker Engineering |
| None |
| ctrib_occ |
| Candidate |
| Engineer |
| Retired |
| Retired |
| EVP |
| Attorney |
| None |
| None |
| Anesthesiologist |
| Retired |
| Real Estate |
| Manager |
| Manager |
| Investor |
| Retired |
| Retired |
| Director |
| Retired |
| None |
| None |
| None |
| Owner |
| Retired |
| Retired |
| President |
| Owner |
| Administrative Assistant |
| Realtor |
| None |
| None |
| None |
| Civil Engineer |
| None |
| 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 |
| 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 |
| rcpt_date |
| 2022-10-11 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-22 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-09-29 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-01 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-10-02 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-10-16 00:00:00 |
| 2022-10-22 00:00:00 |
| 2022-09-29 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-08 00:00:00 |
| 2022-10-10 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 |
| amount |
| 50000 |
| 25 |
| 100 |
| 100 |
| 1000 |
| 500 |
| 3900 |
| 1500 |
| 500 |
| 125 |
| 250 |
| 76 |
| 76 |
| 2000 |
| 100 |
| 150 |
| 50 |
| 199 |
| 2000 |
| 4900 |
| 1000 |
| 100 |
| 100 |
| 990 |
| 500 |
| 500 |
| 250 |
| 4900 |
| 250 |
| 1000 |
| 4900 |
| 100 |
| 15900 |
| cum_ytd |
| 297100 |
| 250 |
| 100 |
| 100 |
| 1000 |
| 500 |
| 3900 |
| 2000 |
| 500 |
| 125 |
| 250 |
| 380 |
| 380 |
| 2000 |
| 200 |
| 350 |
| 200 |
| 199 |
| 2000 |
| 4900 |
| 2500 |
| 100 |
| 100 |
| 990 |
| 500 |
| 500 |
| 250 |
| 8800 |
| 250 |
| 1000 |
| 4900 |
| 200 |
| 43900 |
| 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 |
| 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 |
| POL |
| cmte_id |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 744692 |
| 992074 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 810163 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
|
Table: smry
| filing_id |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 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 |
| 82506 |
| 0 |
| 82506 |
| 15900 |
| 98406 |
| 127002 |
| 0 |
| 127002 |
| 0 |
| 15900 |
| 142902 |
| 65096 |
| 82506 |
| 0 |
| 127002 |
| 20601 |
| 0 |
| 0 |
| 100000 |
| 82141 |
| 365 |
| 82506 |
| 0 |
| 0 |
| 0 |
| 15900 |
| 0 |
| 15900 |
| 0 |
| 0 |
| 0 |
| 127002 |
| 0 |
| 0 |
| 127002 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| amount_b |
| 433572 |
| 100000 |
| 533572 |
| 48513 |
| 582085 |
| 547281 |
| 0 |
| 547281 |
| 0 |
| 48513 |
| 595794 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 2742888 |
| 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 |
| 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 |
| 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 |
| B1 |
| B1 |
| B1 |
| B1 |
| B1 |
| B1 |
| C |
| ptran_id |
| INC682 |
| INC682 |
| INC724 |
| INC724 |
| INC707 |
| INC721 |
| INC703 |
| INC709 |
| INC702 |
| INC738 |
| INC738 |
| INC708 |
| INC687 |
| INC696 |
| INC692 |
| INC728 |
| INC676 |
| INC689 |
| INC730 |
| INC730 |
| INC741 |
| INC741 |
| INC686 |
| INC701 |
| INC678 |
| INC677 |
| INC677 |
| INC710 |
| INC723 |
| INC680 |
| INC680 |
| INC693 |
| INC705 |
| INC727 |
| INC681 |
| INC681 |
| INC706 |
| INC700 |
| INC736 |
| INC714 |
| INC714 |
| PAY2 |
| PAY2 |
| PAY264 |
| PAY264 |
| PAY579 |
| PAY579 |
| NON679 |
| 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 |
| elec_amount |
| 129450 |
| 250000 |
| 150 |
| 100 |
| 100 |
| 100 |
| 1000 |
| 500 |
| 3900 |
| 500 |
| 1500 |
| 500 |
| 125 |
| 250 |
| 380 |
| 380 |
| 2000 |
| 200 |
| 250 |
| 150 |
| 200 |
| 100 |
| 199 |
| 2000 |
| 4900 |
| 1000 |
| 1500 |
| 100 |
| 100 |
| 250 |
| 990 |
| 500 |
| 500 |
| 250 |
| 4900 |
| 4900 |
| 250 |
| 1000 |
| 4900 |
| 100 |
| 100 |
| 129450 |
| 250000 |
| 129450 |
| 250000 |
| 129450 |
| 250000 |
| 43900 |
| elec_code |
| P |
| G |
| P |
| G |
| G |
| G |
| G |
| G |
| G |
| P |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| P |
| G |
| P |
| G |
| G |
| G |
| G |
| P |
| G |
| G |
| G |
| P |
| G |
| G |
| G |
| G |
| P |
| G |
| G |
| G |
| G |
| P |
| G |
| P |
| G |
| P |
| G |
| P |
| G |
| G |
|