Home
Filing ID: 2723971
PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2723971&amendid=0
Table: cvr2_campaign_disclosure
| filing_id |
| 2723971 |
| amend_id |
| 0 |
| line_item |
| 1 |
| rec_type |
| CVR2 |
| form_type |
| F460 |
| tran_id |
| OFC1 |
| entity_cd |
| ATR |
| title |
| None |
| mail_city |
| None |
| mail_st |
| None |
| mail_zip4 |
| None |
| f460_part |
| 3 |
| cmte_id |
| None |
| enty_naml |
| ORELLANA |
| enty_namf |
| INGRID |
| enty_namt |
| None |
| enty_nams |
| None |
| enty_city |
| Norwalk |
| enty_st |
| CA |
| enty_zip4 |
| 90650 |
| enty_phon |
| 213-489-4792 |
| enty_fax |
| 213-489-4818 |
| enty_email |
| [email protected] |
| tres_naml |
| None |
| tres_namf |
| None |
| tres_namt |
| None |
| tres_nams |
| None |
| control_yn |
| None |
| office_cd |
| None |
| offic_dscr |
| None |
| juris_cd |
| None |
| juris_dscr |
| None |
| dist_no |
| None |
| off_s_h_cd |
| None |
| bal_name |
| None |
| bal_num |
| None |
| bal_juris |
| None |
| sup_opp_cd |
| None |
|
Table: cvr3_verification_info
| filing_id |
| 2723971 |
| 2723971 |
| 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-09-26 00:00:00 |
| 2022-09-26 00:00:00 |
| sig_loc |
| None |
| None |
| sig_naml |
| DAVID L. GOULD |
| RICHARD BLOOM |
| sig_namf |
| None |
| None |
| sig_namt |
| None |
| None |
| sig_nams |
| None |
| None |
|
Table: cvr_campaign_disclosure
| filing_id |
| 2723971 |
| amend_id |
| 0 |
| rec_type |
| CVR |
| form_type |
| F460 |
| filer_id |
| 1434945 |
| entity_cd |
| CTL |
| filer_naml |
| BLOOM FOR ASSEMBLY 2022 |
| filer_namf |
| None |
| filer_namt |
| None |
| filer_nams |
| None |
| report_num |
| 000 |
| rpt_date |
| 2022-09-26 00:00:00 |
| stmt_type |
| PE |
| late_rptno |
| None |
| from_date |
| 2022-07-01 00:00:00 |
| thru_date |
| 2022-09-24 00:00:00 |
| elect_date |
| 2022-11-01 00:00:00 |
| filer_city |
| Norwalk |
| filer_st |
| CA |
| filer_zip4 |
| 90650 |
| filer_phon |
| 213-489-4792 |
| filer_fax |
| 213-489-4818 |
| file_email |
| [email protected] |
| mail_city |
| None |
| mail_st |
| None |
| mail_zip4 |
| None |
| tres_naml |
| GOULD |
| tres_namf |
| DAVID L. |
| tres_namt |
| None |
| tres_nams |
| None |
| tres_city |
| Norwalk |
| tres_st |
| CA |
| tres_zip4 |
| 90650 |
| tres_phon |
| 213-489-4792 |
| tres_fax |
| None |
| tres_email |
| None |
| cmtte_type |
| C |
| control_yn |
| Y |
| sponsor_yn |
| N |
| primfrm_yn |
| N |
| brdbase_yn |
| N |
| amendexp_1 |
| None |
| amendexp_2 |
| None |
| amendexp_3 |
| None |
| rpt_att_cb |
| None |
| cmtte_id |
| None |
| reportname |
| None |
| rptfromdt |
| None |
| rptthrudt |
| None |
| emplbus_cb |
| None |
| bus_name |
| None |
| bus_city |
| None |
| bus_st |
| None |
| bus_zip4 |
| None |
| bus_inter |
| None |
| busact_cb |
| None |
| busactvity |
| None |
| assoc_cb |
| None |
| assoc_int |
| None |
| other_cb |
| None |
| other_int |
| None |
| cand_naml |
| BLOOM |
| cand_namf |
| RICHARD |
| cand_namt |
| None |
| cand_nams |
| None |
| cand_city |
| Norwalk |
| cand_st |
| CA |
| cand_zip4 |
| 90650 |
| cand_phon |
| 213-489-4792 |
| cand_fax |
| 213-489-4818 |
| cand_email |
| [email protected] |
| bal_name |
| None |
| bal_num |
| None |
| bal_juris |
| None |
| office_cd |
| ASM |
| offic_dscr |
| None |
| juris_cd |
| ASM |
| juris_dscr |
| None |
| dist_no |
| 50 |
| off_s_h_cd |
| H |
| sup_opp_cd |
| None |
| employer |
| None |
| occupation |
| None |
| selfemp_cb |
| None |
| bal_id |
| None |
| cand_id |
| None |
|
Table: debt
| filing_id |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| rec_type |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| form_type |
| F |
| F |
| F |
| F |
| F |
| tran_id |
| PAY8 |
| PAY9 |
| PAY10 |
| PAY130 |
| PAY156 |
| entity_cd |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| payee_naml |
| Gould & Orellana LLC |
| Gould & Orellana LLC |
| Gould & Orellana LLC |
| Chase |
| Chase |
| payee_namf |
| None |
| None |
| None |
| None |
| None |
| payee_namt |
| None |
| None |
| None |
| None |
| None |
| payee_nams |
| None |
| None |
| None |
| None |
| None |
| payee_city |
| Norwalk |
| Norwalk |
| Norwalk |
| Carol Stream |
| Carol Stream |
| payee_st |
| CA |
| CA |
| CA |
| IL |
| IL |
| payee_zip4 |
| 90650 |
| 90650 |
| 90650 |
| 60197 |
| 60197 |
| beg_bal |
| 250 |
| 2500 |
| 750 |
| 195 |
| 2187 |
| amt_incur |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| amt_paid |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| end_bal |
| 250 |
| 2500 |
| 750 |
| 195 |
| 2187 |
| expn_code |
| PRO |
| PRO |
| PRO |
| CMP |
| CMP |
| expn_dscr |
| Set up Fee Per Contract |
| Deposit/Retainer per Contract |
| Prof Servs thru 12/31/20 |
| Credit Card Charges |
| Credit Card Charges |
| cmte_id |
| None |
| None |
| None |
| None |
| None |
| tres_naml |
| None |
| None |
| None |
| None |
| None |
| tres_namf |
| None |
| None |
| None |
| None |
| None |
| tres_namt |
| None |
| None |
| None |
| None |
| None |
| tres_nams |
| None |
| None |
| None |
| None |
| None |
| tres_city |
| None |
| None |
| None |
| None |
| None |
| tres_st |
| None |
| None |
| None |
| None |
| None |
| tres_zip4 |
| None |
| None |
| None |
| None |
| None |
| memo_code |
| None |
| None |
| None |
| None |
| None |
| memo_refno |
| None |
| None |
| None |
| None |
| None |
| bakref_tid |
| None |
| None |
| None |
| None |
| None |
| xref_schnm |
| None |
| None |
| None |
| None |
| None |
| xref_match |
| None |
| None |
| None |
| None |
| None |
|
Table: expn
| filing_id |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| amend_id |
| 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 |
| rec_type |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| form_type |
| D |
| D |
| D |
| D |
| D |
| D |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| tran_id |
| EXP161 |
| EXP159 |
| EXP163 |
| EXP160 |
| EXP164 |
| EXP162 |
| EXP149 |
| EXP151 |
| EXP165 |
| EXP157 |
| EXP161 |
| EXP158 |
| EXP159 |
| EXP163 |
| EXP160 |
| EXP164 |
| EXP162 |
| EXP168 |
| EXP167 |
| entity_cd |
| COM |
| COM |
| COM |
| COM |
| COM |
| COM |
| OTH |
| OTH |
| OTH |
| OTH |
| COM |
| OTH |
| COM |
| COM |
| COM |
| COM |
| COM |
| OTH |
| OTH |
| payee_naml |
| Brian Maienschein for Assembly 2022 |
| California Democratic Party |
| Christy Holstege for Assembly 2022 |
| Re-Elect Ken Cooley for Assembly 2022 |
| Schiavo for Assembly 2022 |
| Soria For Assembly 2022 |
| Gould & Orellana LLC |
| Brian Ross Adams-Trusted Messenger Marketing |
| Chase |
| Gould & Orellana LLC |
| Brian Maienschein for Assembly 2022 |
| Brian Ross Adams-Trusted Messenger Marketing |
| California Democratic Party |
| Christy Holstege for Assembly 2022 |
| Re-Elect Ken Cooley for Assembly 2022 |
| Schiavo for Assembly 2022 |
| Soria For Assembly 2022 |
| Chase |
| Brian Ross Adams-Trusted Messenger Marketing |
| payee_namf |
| None |
| 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 |
| None |
| payee_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_city |
| La Mesa |
| Sacramento |
| Palm Springs |
| Sacramento |
| San Francisco |
| Sacramento |
| Norwalk |
| Los Alamos |
| Carol Stream |
| Norwalk |
| La Mesa |
| Los Alamos |
| Sacramento |
| Palm Springs |
| Sacramento |
| San Francisco |
| Sacramento |
| Carol Stream |
| Los Alamos |
| payee_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| IL |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| IL |
| CA |
| payee_zip4 |
| 91942 |
| 95811 |
| 92262 |
| 95841 |
| 94114 |
| 95815 |
| 90650 |
| 93440 |
| 60197 |
| 90650 |
| 91942 |
| 93440 |
| 95811 |
| 92262 |
| 95841 |
| 94114 |
| 95815 |
| 60197 |
| 93440 |
| expn_date |
| 2022-08-05 00:00:00 |
| 2022-08-05 00:00:00 |
| 2022-08-05 00:00:00 |
| 2022-08-05 00:00:00 |
| 2022-08-05 00:00:00 |
| 2022-08-05 00:00:00 |
| 2022-07-01 00:00:00 |
| 2022-07-12 00:00:00 |
| 2022-07-18 00:00:00 |
| 2022-08-01 00:00:00 |
| 2022-08-05 00:00:00 |
| 2022-08-05 00:00:00 |
| 2022-08-05 00:00:00 |
| 2022-08-05 00:00:00 |
| 2022-08-05 00:00:00 |
| 2022-08-05 00:00:00 |
| 2022-08-05 00:00:00 |
| 2022-08-16 00:00:00 |
| 2022-09-16 00:00:00 |
| amount |
| 4900 |
| 40500 |
| 4900 |
| 4900 |
| 4400 |
| 4900 |
| 750 |
| 1000 |
| 2452 |
| 750 |
| 4900 |
| 1000 |
| 40500 |
| 4900 |
| 4900 |
| 4400 |
| 4900 |
| 5046 |
| 1000 |
| cum_ytd |
| 4900 |
| 40650 |
| 4900 |
| 4900 |
| 4900 |
| 4900 |
| 6000 |
| 3000 |
| 24699 |
| 6000 |
| 4900 |
| 3000 |
| 40650 |
| 4900 |
| 4900 |
| 4900 |
| 4900 |
| 24699 |
| 3000 |
| cum_oth |
| 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 |
| expn_code |
| MON |
| MON |
| MON |
| MON |
| MON |
| MON |
| PRO |
| CNS |
| CMP |
| PRO |
| CTB |
| CNS |
| CTB |
| CTB |
| CTB |
| CTB |
| CTB |
| CMP |
| CNS |
| expn_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| Prof Servs Thru 7/31/22 |
| June 2022 General consulting |
| Credit Card Charges |
| Prof Servs Thru 8/31/22 |
| None |
| July 2022 General Consulting |
| None |
| None |
| None |
| None |
| None |
| Credit Card Charges |
| August 2022 General Consulting |
| agent_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| agent_namf |
| 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 |
| agent_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cmte_id |
| 1435006 |
| 1276582 |
| 1439961 |
| 1435371 |
| 1438397 |
| 1443835 |
| None |
| None |
| None |
| None |
| 1435006 |
| None |
| 1276582 |
| 1439961 |
| 1435371 |
| 1438397 |
| 1443835 |
| None |
| None |
| tres_naml |
| 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 |
| tres_namt |
| 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 |
| tres_city |
| 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 |
| tres_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cand_naml |
| Brian Maienschein |
| None |
| Christy Holstege |
| Ken Cooley |
| Pilar Schiavo |
| Esmeralda Soria |
| 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 |
| cand_namt |
| 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 |
| office_cd |
| ASM |
| None |
| ASM |
| ASM |
| ASM |
| ASM |
| 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 |
| juris_cd |
| ASM |
| None |
| ASM |
| ASM |
| ASM |
| ASM |
| 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 |
| dist_no |
| 77 |
| None |
| 47 |
| 8 |
| 40 |
| 27 |
| 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 |
| bal_name |
| 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 |
| bal_juris |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| sup_opp_cd |
| S |
| S |
| S |
| S |
| S |
| S |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 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 |
| memo_refno |
| 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 |
| g_from_e_f |
| 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 |
| xref_match |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: filer_filings
| filer_id |
| 1434945 |
| filing_id |
| 2723971 |
| period_id |
| 251 |
| form_id |
| F460 |
| filing_sequence |
| 0 |
| filing_date |
| 2022-09-26 00:00:00 |
| stmnt_type |
| 10001 |
| stmnt_status |
| 11003 |
| session_id |
| 2021 |
| user_id |
| CAFILER |
| special_audit |
| 11003 |
| fine_audit |
| 11003 |
| rpt_start |
| 2022-07-01 00:00:00 |
| rpt_end |
| 2022-09-24 00:00:00 |
| rpt_date |
| 2022-09-26 00:00:00 |
| filing_type |
| 22001 |
|
Table: filings
| filing_id |
| 2723971 |
| filing_type |
| 22001 |
|
Table: hdr
| filing_id |
| 2723971 |
| 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 |
| 2723971 |
| amend_id |
| 0 |
| line_item |
| 1 |
| rec_type |
| LOAN |
| form_type |
| B1 |
| tran_id |
| PAY78 |
| loan_type |
| None |
| entity_cd |
| IND |
| lndr_naml |
| Bloom |
| lndr_namf |
| Richard |
| lndr_namt |
| None |
| lndr_nams |
| None |
| loan_city |
| Sacramento |
| loan_st |
| CA |
| loan_zip4 |
| 94249-0050 |
| loan_date1 |
| 2021-08-13 00:00:00 |
| loan_date2 |
| None |
| loan_amt1 |
| 0 |
| loan_amt2 |
| 5000 |
| loan_amt3 |
| 0 |
| loan_amt4 |
| 5000 |
| loan_rate |
| 0.00 |
| loan_emp |
| California State Assembly |
| loan_occ |
| Assemblymember |
| loan_self |
| None |
| cmte_id |
| None |
| tres_naml |
| None |
| tres_namf |
| None |
| tres_namt |
| None |
| tres_nams |
| None |
| tres_city |
| None |
| tres_st |
| None |
| tres_zip4 |
| None |
| intr_naml |
| None |
| intr_namf |
| None |
| intr_namt |
| None |
| intr_nams |
| None |
| intr_city |
| None |
| intr_st |
| None |
| intr_zip4 |
| None |
| memo_code |
| None |
| memo_refno |
| None |
| bakref_tid |
| None |
| xref_schnm |
| None |
| xref_match |
| None |
| loan_amt5 |
| 0 |
| loan_amt6 |
| 0 |
| loan_amt7 |
| 0 |
| loan_amt8 |
| 5000 |
|
Table: smry
| filing_id |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| 2723971 |
| amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 4 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| rec_type |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| form_type |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| D |
| D |
| D |
| E |
| E |
| E |
| E |
| F |
| F |
| F |
| B1 |
| B1 |
| B1 |
| H |
| H |
| H |
| amount_a |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 76580 |
| 0 |
| 76580 |
| 0 |
| 0 |
| 76580 |
| 100738 |
| 0 |
| 0 |
| 76580 |
| 24158 |
| 0 |
| 0 |
| 10883 |
| 64500 |
| 0 |
| 64500 |
| 76498 |
| 82 |
| 0 |
| 76580 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| amount_b |
| 7000 |
| 5000 |
| 12000 |
| 0 |
| 12000 |
| 106128 |
| 0 |
| 106128 |
| 5883 |
| 0 |
| 112011 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| amount_c |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| elec_dt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: splt
| filing_id |
| 2723971 |
| amend_id |
| 0 |
| line_item |
| 1 |
| pform_type |
| B1 |
| ptran_id |
| PAY78 |
| elec_date |
| 2022-01-01 00:00:00 |
| elec_amount |
| 5000 |
| elec_code |
| P |
|