Home
Filing ID: 2742422
PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2742422&amendid=0
Table: cvr2_campaign_disclosure
| filing_id |
| 2742422 |
| 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 |
| Titus |
| enty_namf |
| Ashlee N. |
| enty_namt |
| None |
| enty_nams |
| None |
| enty_city |
| Sacramento |
| enty_st |
| CA |
| enty_zip4 |
| 95814 |
| enty_phon |
| (916) 442-7757 |
| enty_fax |
| None |
| enty_email |
| None |
| 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 |
| 2742422 |
| amend_id |
| 0 |
| line_item |
| 1 |
| rec_type |
| CVR3 |
| form_type |
| F460 |
| tran_id |
| VER_1.1 |
| entity_cd |
| TRE |
| sig_date |
| 2022-10-27 00:00:00 |
| sig_loc |
| None |
| sig_naml |
| Thomas W. Hiltachk |
| sig_namf |
| None |
| sig_namt |
| None |
| sig_nams |
| None |
|
Table: cvr_campaign_disclosure
| filing_id |
| 2742422 |
| amend_id |
| 0 |
| rec_type |
| CVR |
| form_type |
| F460 |
| filer_id |
| 1438408 |
| entity_cd |
| RCP |
| filer_naml |
| Golden State Communities Project |
| filer_namf |
| None |
| filer_namt |
| None |
| filer_nams |
| None |
| report_num |
| 000 |
| rpt_date |
| 2022-10-27 00:00:00 |
| stmt_type |
| PE |
| late_rptno |
| None |
| from_date |
| 2022-07-01 00:00:00 |
| thru_date |
| 2022-10-22 00:00:00 |
| elect_date |
| 2022-11-08 00:00:00 |
| filer_city |
| Sacramento |
| filer_st |
| CA |
| filer_zip4 |
| 95814 |
| filer_phon |
| (916) 442-7757 |
| filer_fax |
| (916) 442-7759 |
| file_email |
| [email protected] |
| mail_city |
| None |
| mail_st |
| None |
| mail_zip4 |
| None |
| tres_naml |
| Hiltachk |
| tres_namf |
| Thomas W. |
| tres_namt |
| None |
| tres_nams |
| None |
| tres_city |
| Sacramento |
| tres_st |
| CA |
| tres_zip4 |
| 95814 |
| tres_phon |
| (916) 442-7757 |
| tres_fax |
| None |
| tres_email |
| None |
| cmtte_type |
| G |
| control_yn |
| N |
| sponsor_yn |
| N |
| primfrm_yn |
| N |
| 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 |
| None |
| cand_namf |
| None |
| cand_namt |
| None |
| cand_nams |
| None |
| cand_city |
| None |
| cand_st |
| None |
| cand_zip4 |
| None |
| cand_phon |
| None |
| cand_fax |
| None |
| cand_email |
| None |
| bal_name |
| None |
| bal_num |
| None |
| bal_juris |
| None |
| office_cd |
| None |
| offic_dscr |
| None |
| juris_cd |
| None |
| juris_dscr |
| None |
| dist_no |
| None |
| off_s_h_cd |
| None |
| sup_opp_cd |
| None |
| employer |
| None |
| occupation |
| None |
| selfemp_cb |
| None |
| bal_id |
| None |
| cand_id |
| None |
|
Table: debt
| filing_id |
| 2742422 |
| 2742422 |
| 2742422 |
| amend_id |
| 0 |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| 3 |
| rec_type |
| DEBT |
| DEBT |
| DEBT |
| form_type |
| F |
| F |
| F |
| tran_id |
| PAY135 |
| PAY152 |
| PAY181 |
| entity_cd |
| OTH |
| OTH |
| OTH |
| payee_naml |
| Bell, McAndrews & Hiltachk, LLP |
| Neptune Ops LLC |
| Neptune Ops LLC |
| payee_namf |
| None |
| None |
| None |
| payee_namt |
| None |
| None |
| None |
| payee_nams |
| None |
| None |
| None |
| payee_city |
| Sacramento |
| Lafayette |
| Lafayette |
| payee_st |
| CA |
| CA |
| CA |
| payee_zip4 |
| 95814 |
| 94549 |
| 94549 |
| beg_bal |
| 188 |
| 0 |
| 0 |
| amt_incur |
| 0 |
| 2000 |
| 30000 |
| amt_paid |
| 188 |
| 0 |
| 0 |
| end_bal |
| 0 |
| 2000 |
| 30000 |
| expn_code |
| PRO |
| IND |
| IND |
| expn_dscr |
| None |
| WEB; Oppose; Pamela Price; Alameda County District Attorney |
| WEB; Oppose; Pamela Price; Alameda County District Attorney |
| cmte_id |
| None |
| None |
| None |
| tres_naml |
| None |
| None |
| None |
| tres_namf |
| None |
| None |
| None |
| tres_namt |
| None |
| None |
| None |
| tres_nams |
| None |
| None |
| None |
| tres_city |
| None |
| None |
| None |
| tres_st |
| None |
| None |
| None |
| tres_zip4 |
| None |
| None |
| None |
| memo_code |
| None |
| None |
| None |
| memo_refno |
| None |
| None |
| None |
| bakref_tid |
| None |
| None |
| None |
| xref_schnm |
| None |
| None |
| None |
| xref_match |
| None |
| None |
| None |
|
Table: expn
| filing_id |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 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 |
| 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 |
| 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 |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| form_type |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| 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 |
| G |
| G |
| G |
| G |
| tran_id |
| PDT9 |
| EDT35 |
| EDT37 |
| EDT38 |
| EDT41 |
| EDT42 |
| EDT45 |
| EDT46 |
| EXP134 |
| EXP136 |
| EXP138 |
| EXP142 |
| EXP143 |
| EXP149 |
| EXP150 |
| EXP155 |
| EXP156 |
| EXP157 |
| EXP165 |
| EXP166 |
| EXP167 |
| EXP170 |
| EXP173 |
| EXP177 |
| EXP175 |
| EXP176 |
| EDT32 |
| EDT30 |
| EDT31 |
| EDT33 |
| EDT34 |
| EDT36 |
| EDT39 |
| EDT40 |
| EDT47 |
| EDT48 |
| PDT10 |
| entity_cd |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| payee_naml |
| Pamela Price G2022 (I) |
| Pamela Price G2022 (I) |
| Pamela Price G2022 (I) |
| Pamela Price G2022 (I) |
| Pamela Price G2022 (I) |
| Pamela Price G2022 (I) |
| John Hamasaki G2022 (I) |
| John Hamasaki G2022 (I) |
| E-Fundraising Connections |
| Bell, McAndrews & Hiltachk, LLP |
| Neptune Ops LLC |
| E-Fundraising Connections |
| Bell, McAndrews & Hiltachk, LLP |
| E-Fundraising Connections |
| Bell, McAndrews & Hiltachk, LLP |
| Neptune Ops LLC |
| Neptune Ops LLC |
| Neptune Ops LLC |
| E-Fundraising Connections |
| Neptune Ops LLC |
| Bell, McAndrews & Hiltachk, LLP |
| Neptune Ops LLC |
| E-Fundraising Connections |
| E-Fundraising Connections |
| Neptune Ops LLC |
| Neptune Ops LLC |
| Amobee Inc. |
| IVC Media, LLC |
| Mailchimp |
| IVC Media, LLC |
| IVC Media, LLC |
| Simplifi Holdings, Inc. |
| Simplifi Holdings, Inc. |
| Simplifi Holdings, Inc. |
| Simplifi Holdings, Inc. |
| Simplifi Holdings, Inc. |
| Simplifi Holdings, Inc. |
| payee_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 |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Sacramento |
| Sacramento |
| Lafayette |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
| Lafayette |
| Lafayette |
| Lafayette |
| Sacramento |
| Lafayette |
| Sacramento |
| Lafayette |
| Sacramento |
| Sacramento |
| Lafayette |
| Lafayette |
| Redwood City |
| San Diego |
| Atlanta |
| San Diego |
| San Diego |
| Fort Worth |
| Fort Worth |
| Fort Worth |
| Fort Worth |
| Fort Worth |
| Fort Worth |
| payee_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| GA |
| CA |
| CA |
| TX |
| TX |
| TX |
| TX |
| TX |
| TX |
| payee_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 95816 |
| 95814 |
| 94549 |
| 95816 |
| 95814 |
| 95816 |
| 95814 |
| 94549 |
| 94549 |
| 94549 |
| 95816 |
| 94549 |
| 95814 |
| 94549 |
| 95816 |
| 95816 |
| 94549 |
| 94549 |
| 94065 |
| 92116 |
| 30308 |
| 92116 |
| 92116 |
| 76164 |
| 76164 |
| 76164 |
| 76164 |
| 76164 |
| 76164 |
| expn_date |
| 2022-09-29 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-07-11 00:00:00 |
| 2022-07-22 00:00:00 |
| 2022-07-26 00:00:00 |
| 2022-08-10 00:00:00 |
| 2022-08-11 00:00:00 |
| 2022-09-09 00:00:00 |
| 2022-09-13 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-07-26 00:00:00 |
| 2022-07-26 00:00:00 |
| 2022-07-26 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-19 00:00:00 |
| 2022-10-21 00:00:00 |
| amount |
| 2000 |
| 25000 |
| 10000 |
| 20000 |
| 15000 |
| 25000 |
| 10000 |
| 10000 |
| 3 |
| 188 |
| 17200 |
| 3 |
| 1114 |
| 3 |
| 184 |
| 10000 |
| 10000 |
| 25000 |
| 2 |
| 20000 |
| 701 |
| 15000 |
| 181 |
| 158 |
| 10000 |
| 25000 |
| 5000 |
| 10700 |
| 1500 |
| 10000 |
| 10000 |
| 25000 |
| 20000 |
| 15000 |
| 10000 |
| 25000 |
| 30000 |
| cum_ytd |
| 97000 |
| 97000 |
| 97000 |
| 97000 |
| 97000 |
| 97000 |
| 20000 |
| 20000 |
| 3174 |
| 11225 |
| 421700 |
| 3174 |
| 11225 |
| 3174 |
| 11225 |
| 421700 |
| 421700 |
| 421700 |
| 3174 |
| 421700 |
| 11225 |
| 421700 |
| 3174 |
| 3174 |
| 421700 |
| 421700 |
| 55000 |
| 238200 |
| 1500 |
| 238200 |
| 238200 |
| 125000 |
| 125000 |
| 125000 |
| 125000 |
| 125000 |
| 125000 |
| 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 |
| 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 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| expn_code |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| OFC |
| PRO |
| WEB |
| OFC |
| PRO |
| OFC |
| PRO |
| IND |
| IND |
| IND |
| OFC |
| IND |
| PRO |
| IND |
| OFC |
| OFC |
| IND |
| IND |
| WEB |
| WEB |
| WEB |
| WEB |
| WEB |
| WEB |
| WEB |
| WEB |
| WEB |
| WEB |
| WEB |
| expn_dscr |
| WEB |
| WEB |
| WEB |
| WEB |
| WEB |
| WEB |
| WEB |
| WEB |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| WEB; Oppose; John Hamasaki; City and County of San Francisco; District Attorney |
| WEB; Oppose; Pamela Price; Alameda County District Attorney |
| WEB; Oppose; Pamela Price; Alameda County District Attorney |
| None |
| WEB; Oppose; Pamela Price; Alameda County District Attorney |
| None |
| WEB; Oppose; Pamela Price; Alameda County District Attorney |
| None |
| None |
| WEB; Oppose; John Hamasaki; City and County of San Francisco; District Attorney |
| WEB; Oppose; Pamela Price; Alameda County District Attorney |
| 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 |
| None |
| None |
| None |
| Neptune Ops LLC |
| Neptune Ops LLC |
| Neptune Ops LLC |
| Neptune Ops LLC |
| Neptune Ops LLC |
| Neptune Ops LLC |
| Neptune Ops LLC |
| Neptune Ops LLC |
| Neptune Ops LLC |
| Neptune Ops LLC |
| Neptune Ops LLC |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| cand_naml |
| Pamela Price |
| Pamela Price |
| Pamela Price |
| Pamela Price |
| Pamela Price |
| Pamela Price |
| John Hamasaki |
| John Hamasaki |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 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 |
| 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 |
| office_cd |
| DAT |
| DAT |
| DAT |
| DAT |
| DAT |
| DAT |
| DAT |
| DAT |
| None |
| None |
| None |
| None |
| None |
| 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 |
| juris_cd |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| 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 |
| juris_dscr |
| Alameda County |
| Alameda County |
| Alameda County |
| Alameda County |
| Alameda County |
| Alameda County |
| City and County of San Francisco |
| City and County of San Francisco |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| sup_opp_cd |
| O |
| O |
| O |
| O |
| O |
| O |
| O |
| O |
| None |
| None |
| None |
| None |
| None |
| 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 |
| 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 |
| 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 |
| 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 |
| None |
| None |
| None |
| E |
| E |
| E |
| E |
| 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 |
| 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 |
|
Table: filer_filings
| filer_id |
| 1438408 |
| filing_id |
| 2742422 |
| 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-07-01 00:00:00 |
| rpt_end |
| 2022-10-22 00:00:00 |
| rpt_date |
| 2022-10-27 00:00:00 |
| filing_type |
| 22001 |
|
Table: filings
| filing_id |
| 2742422 |
| filing_type |
| 22001 |
|
Table: hdr
| filing_id |
| 2742422 |
| 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: rcpt
| filing_id |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 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 |
| 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 |
| 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 |
| 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 |
| tran_id |
| INC133 |
| INC132 |
| INC141 |
| INC140 |
| INC144 |
| INC145 |
| INC148 |
| INC147 |
| INC151 |
| INC153 |
| INC154 |
| INC164 |
| INC163 |
| INC158 |
| INC159 |
| INC160 |
| INC161 |
| INC162 |
| INC169 |
| INC172 |
| INC168 |
| INC171 |
| INC174 |
| INC180 |
| INC178 |
| INC179 |
| entity_cd |
| IND |
| IND |
| IND |
| IND |
| COM |
| COM |
| IND |
| IND |
| COM |
| OTH |
| COM |
| IND |
| IND |
| OTH |
| COM |
| OTH |
| COM |
| COM |
| COM |
| IND |
| OTH |
| IND |
| IND |
| IND |
| COM |
| COM |
| ctrib_naml |
| Barnes |
| Siddall |
| Barnes |
| Siddall |
| California District Attorneys Association Political Action Committee |
| Public Safety Advocates to Stop Tori Verber Salazar for District Attorney 2022 |
| Barnes |
| Siddall |
| Dan Dow for District Attorney 2022 |
| Deputy Sheriffs' Association of Alameda County |
| Fremont Police Association PAC Sponsored by the Fremont Police Association |
| Barnes |
| Siddall |
| Triton Management Services, LLC(Herbert G. Mutter) |
| Berkeley Police Association PAC |
| Gotham Bail Bonds Inc. |
| Re-Elect Maggie Fleming District Attorney 2018 |
| Stephan for District Attorney 2022 |
| California Correctional Peace Officers Association Political Action Committee |
| Chuang |
| Exit Bail Bonds Inc. |
| Lee |
| Young |
| Conway |
| Union City Police Officer's Association PAC |
| Fremont Police Association PAC Sponsored by the Fremont Police Association |
| ctrib_namf |
| Cyndi |
| Eric |
| Cyndi |
| Eric |
| None |
| None |
| Cyndi |
| Eric |
| None |
| None |
| None |
| Cyndi |
| Eric |
| None |
| None |
| None |
| None |
| None |
| None |
| Wen Hao |
| None |
| Francis |
| Wilson |
| Ronald |
| None |
| 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 |
| 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 |
| ctrib_city |
| Palos Verdes Peninsula |
| Los Angeles |
| Palos Verdes Peninsula |
| Los Angeles |
| Sacramento |
| Sacramento |
| Palos Verdes Peninsula |
| Los Angeles |
| Irvine |
| Pleasanton |
| Sacramento |
| Palos Verdes Peninsula |
| Los Angeles |
| Carlsbad |
| Berkeley |
| Los Angeles |
| Eureka |
| Encinitas |
| Sacramento |
| San Francisco |
| Riverside |
| San Lorenzo |
| Castro Valley |
| Belvedere Tiburon |
| Sacramento |
| Sacramento |
| 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 |
| ctrib_zip4 |
| 90274 |
| 90012 |
| 90274 |
| 90012 |
| 95814 |
| 95814 |
| 90274 |
| 90012 |
| 92618 |
| 94588 |
| 95841 |
| 90274 |
| 90012 |
| 92011 |
| 94703 |
| 90012 |
| 95502 |
| 92024 |
| 95814 |
| 94132 |
| 92507 |
| 94580 |
| 94546 |
| 94920 |
| 95814 |
| 95841 |
| ctrib_emp |
| Los Angeles County |
| Los Angeles County |
| Los Angeles County |
| Los Angeles County |
| None |
| None |
| Los Angeles County |
| Los Angeles County |
| None |
| None |
| None |
| Los Angeles County |
| Los Angeles County |
| None |
| None |
| None |
| None |
| None |
| None |
| Western Digital |
| None |
| GyroPalm |
| Clement Holdings, LLC |
| SV Angel Investing |
| None |
| None |
| ctrib_occ |
| Attorney |
| Deputy District Attorney |
| Attorney |
| Deputy District Attorney |
| None |
| None |
| Attorney |
| Deputy District Attorney |
| None |
| None |
| None |
| Attorney |
| Deputy District Attorney |
| None |
| None |
| None |
| None |
| None |
| None |
| Program Manager |
| None |
| Vice President |
| Managing Partner |
| Founder and Managing Drirector |
| None |
| 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 |
| 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 |
| rcpt_date |
| 2022-07-07 00:00:00 |
| 2022-07-07 00:00:00 |
| 2022-08-07 00:00:00 |
| 2022-08-07 00:00:00 |
| 2022-08-11 00:00:00 |
| 2022-08-18 00:00:00 |
| 2022-09-07 00:00:00 |
| 2022-09-07 00:00:00 |
| 2022-09-15 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-21 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 |
| amount |
| 10 |
| 10 |
| 10 |
| 10 |
| 977 |
| 1354 |
| 10 |
| 10 |
| 5000 |
| 2500 |
| 50000 |
| 10 |
| 10 |
| 5000 |
| 7500 |
| 1000 |
| 1500 |
| 10000 |
| 50000 |
| 3000 |
| 2500 |
| 1000 |
| 3500 |
| 5000 |
| 5000 |
| 15000 |
| cum_ytd |
| 100 |
| 100 |
| 100 |
| 100 |
| 977 |
| 1354 |
| 100 |
| 100 |
| 5000 |
| 2500 |
| 65000 |
| 100 |
| 100 |
| 5000 |
| 7500 |
| 1000 |
| 1500 |
| 10000 |
| 150000 |
| 3000 |
| 2500 |
| 1000 |
| 3500 |
| 5000 |
| 5000 |
| 65000 |
| 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 |
| 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 |
| cmte_id |
| None |
| None |
| None |
| None |
| 1436158 |
| 1447641 |
| None |
| None |
| 1361413 |
| None |
| 1291122 |
| None |
| None |
| None |
| 1364286 |
| None |
| 1362721 |
| 1436174 |
| 830349 |
| None |
| None |
| None |
| None |
| None |
| 1417324 |
| 1291122 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
|
Table: smry
| filing_id |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 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 |
| 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 |
| 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 |
| 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 |
| D |
| D |
| D |
| E |
| E |
| E |
| E |
| F |
| F |
| F |
| B1 |
| B1 |
| B1 |
| H |
| H |
| H |
| amount_a |
| 169941 |
| 0 |
| 169941 |
| 0 |
| 169941 |
| 134736 |
| 0 |
| 134736 |
| 31812 |
| 0 |
| 166548 |
| 23428 |
| 169941 |
| 0 |
| 134736 |
| 58633 |
| 0 |
| 0 |
| 32000 |
| 169911 |
| 30 |
| 169941 |
| 117000 |
| 0 |
| 117000 |
| 134736 |
| 0 |
| 0 |
| 134736 |
| 32000 |
| 188 |
| 31812 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| amount_b |
| 482321 |
| 0 |
| 482321 |
| 0 |
| 482321 |
| 426648 |
| 0 |
| 426648 |
| 32000 |
| 0 |
| 458648 |
| None |
| None |
| None |
| 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 |
| 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 |
|
Table: splt
| filing_id |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| 2742422 |
| amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| pform_type |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| D |
| ptran_id |
| PDT9 |
| EDT35 |
| EDT37 |
| EDT38 |
| EDT41 |
| EDT42 |
| EDT45 |
| EDT46 |
| 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 |
| elec_amount |
| 97000 |
| 97000 |
| 97000 |
| 97000 |
| 97000 |
| 97000 |
| 20000 |
| 20000 |
| elec_code |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
|