Home
Filing ID: 2741947
PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2741947&amendid=0
Table: cvr2_campaign_disclosure
| filing_id |
| 2741947 |
| amend_id |
| 0 |
| line_item |
| 1 |
| rec_type |
| CVR2 |
| form_type |
| F460 |
| tran_id |
| OFC4 |
| entity_cd |
| ATR |
| title |
| None |
| mail_city |
| None |
| mail_st |
| None |
| mail_zip4 |
| None |
| f460_part |
| 3 |
| cmte_id |
| None |
| enty_naml |
| CRANE |
| enty_namf |
| CATHERINE |
| enty_namt |
| None |
| enty_nams |
| None |
| enty_city |
| SAN FRANCISCO |
| enty_st |
| CA |
| enty_zip4 |
| 94108 |
| enty_phon |
| 4157327700 |
| 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 |
| 2741947 |
| amend_id |
| 0 |
| line_item |
| 1 |
| rec_type |
| CVR3 |
| form_type |
| F460 |
| tran_id |
| S10229.1 |
| entity_cd |
| TRE |
| sig_date |
| 2022-07-19 00:00:00 |
| sig_loc |
| None |
| sig_naml |
| JAMES R. SUTTON |
| sig_namf |
| None |
| sig_namt |
| None |
| sig_nams |
| None |
|
Table: cvr_campaign_disclosure
| filing_id |
| 2741947 |
| amend_id |
| 0 |
| rec_type |
| CVR |
| form_type |
| F460 |
| filer_id |
| 1435733 |
| entity_cd |
| RCP |
| filer_naml |
| NAIOP SAN DIEGO PAC |
| filer_namf |
| None |
| filer_namt |
| None |
| filer_nams |
| None |
| report_num |
| 000 |
| rpt_date |
| 2022-07-19 00:00:00 |
| stmt_type |
| SA |
| late_rptno |
| None |
| from_date |
| 2022-01-01 00:00:00 |
| thru_date |
| 2022-06-30 00:00:00 |
| elect_date |
| None |
| filer_city |
| DEL MAR |
| filer_st |
| CA |
| filer_zip4 |
| 92014 |
| filer_phon |
| 4157327700 |
| filer_fax |
| None |
| file_email |
| CAMPAIGN@CAMPAIGNLAWYERS.COM |
| mail_city |
| None |
| mail_st |
| None |
| mail_zip4 |
| None |
| tres_naml |
| SUTTON |
| tres_namf |
| JAMES |
| tres_namt |
| None |
| tres_nams |
| None |
| tres_city |
| SAN FRANCISCO |
| tres_st |
| CA |
| tres_zip4 |
| 94108 |
| tres_phon |
| 4157327700 |
| 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 |
| 2741947 |
| 2741947 |
| amend_id |
| 0 |
| 0 |
| line_item |
| 1 |
| 2 |
| rec_type |
| DEBT |
| DEBT |
| form_type |
| F |
| F |
| tran_id |
| PAY184 |
| PAY290 |
| entity_cd |
| OTH |
| OTH |
| payee_naml |
| THE SUTTON LAW FIRM |
| THE SUTTON LAW FIRM |
| payee_namf |
| None |
| None |
| payee_namt |
| None |
| None |
| payee_nams |
| None |
| None |
| payee_city |
| SAN FRANCISCO |
| SAN FRANCISCO |
| payee_st |
| CA |
| CA |
| payee_zip4 |
| 94108 |
| 94108 |
| beg_bal |
| 556 |
| 0 |
| amt_incur |
| 0 |
| 1049 |
| amt_paid |
| 556 |
| 0 |
| end_bal |
| 0 |
| 1049 |
| expn_code |
| PRO |
| PRO |
| expn_dscr |
| None |
| None |
| cmte_id |
| None |
| None |
| tres_naml |
| None |
| None |
| tres_namf |
| None |
| None |
| tres_namt |
| None |
| None |
| tres_nams |
| None |
| None |
| tres_city |
| None |
| None |
| tres_st |
| None |
| None |
| tres_zip4 |
| None |
| None |
| memo_code |
| None |
| None |
| memo_refno |
| None |
| None |
| bakref_tid |
| None |
| None |
| xref_schnm |
| None |
| None |
| xref_match |
| None |
| None |
|
Table: expn
| filing_id |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| amend_id |
| 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 |
| rec_type |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| EXPN |
| form_type |
| D |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| tran_id |
| EXP274 |
| EXP200 |
| EXP234 |
| EXP236 |
| EXP238 |
| EXP268 |
| EXP270 |
| EXP273 |
| EXP274 |
| EXP286 |
| EXP287 |
| EXP275 |
| EXP280 |
| EXP281 |
| EXP289 |
| entity_cd |
| COM |
| OTH |
| OTH |
| OTH |
| COM |
| OTH |
| OTH |
| OTH |
| COM |
| OTH |
| OTH |
| COM |
| OTH |
| COM |
| OTH |
| payee_naml |
| COMMUNITY VOICES SAN DIEGO |
| THE SUTTON LAW FIRM |
| THE SUTTON LAW FIRM |
| THE SUTTON LAW FIRM |
| PUBLIC DYNAMICS |
| EFUNDRAISING CONNECTIONS |
| EFUNDRAISING CONNECTIONS |
| EFUNDRAISING CONNECTIONS |
| COMMUNITY VOICES SAN DIEGO |
| EFUNDRAISING CONNECTIONS |
| EFUNDRAISING CONNECTIONS |
| PUBLIC DYNAMICS |
| SCOTT & CRONIN LLP |
| PUBLIC DYNAMICS |
| EFUNDRAISING CONNECTIONS |
| payee_namf |
| 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 |
| payee_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| payee_city |
| SAN DIEGO |
| SAN FRANCISCO |
| SAN FRANCISCO |
| SAN FRANCISCO |
| SAN DIEGO |
| SACRAMENTO |
| SACRAMENTO |
| SACRAMENTO |
| SAN DIEGO |
| SACRAMENTO |
| SACRAMENTO |
| SAN DIEGO |
| DEL MAR |
| SAN DIEGO |
| SACRAMENTO |
| payee_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| payee_zip4 |
| 92120 |
| 94108 |
| 94108 |
| 94108 |
| 92120 |
| 95816 |
| 95816 |
| 95816 |
| 92120 |
| 95816 |
| 95816 |
| 92120 |
| 92014 |
| 92120 |
| 95816 |
| expn_date |
| 2022-05-24 00:00:00 |
| 2022-01-26 00:00:00 |
| 2022-03-18 00:00:00 |
| 2022-03-18 00:00:00 |
| 2022-03-25 00:00:00 |
| 2022-05-06 00:00:00 |
| 2022-05-09 00:00:00 |
| 2022-05-12 00:00:00 |
| 2022-05-24 00:00:00 |
| 2022-05-25 00:00:00 |
| 2022-05-31 00:00:00 |
| 2022-06-06 00:00:00 |
| 2022-06-15 00:00:00 |
| 2022-06-16 00:00:00 |
| 2022-06-21 00:00:00 |
| amount |
| 5000 |
| 556 |
| 494 |
| 1126 |
| 500 |
| 66 |
| 651 |
| 131 |
| 5000 |
| 131 |
| 131 |
| 3500 |
| 965 |
| 1000 |
| 66 |
| cum_ytd |
| 5000 |
| 3224 |
| 3224 |
| 3224 |
| 5000 |
| 1175 |
| 1175 |
| 1175 |
| 5000 |
| 1175 |
| 1175 |
| 5000 |
| 965 |
| 5000 |
| 1175 |
| cum_oth |
| 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 |
| expn_code |
| MON |
| PRO |
| PRO |
| PRO |
| CNS |
| OFC |
| OFC |
| OFC |
| CTB |
| OFC |
| OFC |
| CNS |
| PRO |
| CNS |
| OFC |
| expn_dscr |
| 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 |
| agent_namf |
| 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 |
| agent_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| cmte_id |
| 1421730 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 1421730 |
| None |
| None |
| None |
| None |
| None |
| None |
| tres_naml |
| 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 |
| tres_namt |
| 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 |
| tres_city |
| 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 |
| tres_zip4 |
| 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 |
| cand_namf |
| 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 |
| cand_nams |
| 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 |
| offic_dscr |
| 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 |
| juris_dscr |
| 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 |
| off_s_h_cd |
| 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 |
| bal_num |
| 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 |
| sup_opp_cd |
| S |
| 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 |
| memo_refno |
| 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 |
| g_from_e_f |
| 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 |
| xref_match |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: filer_filings
| filer_id |
| 1435733 |
| filing_id |
| 2741947 |
| period_id |
| 249 |
| form_id |
| F460 |
| filing_sequence |
| 0 |
| filing_date |
| 2022-10-26 00:00:00 |
| stmnt_type |
| 10001 |
| stmnt_status |
| 11003 |
| session_id |
| 2021 |
| user_id |
| CAFILER |
| special_audit |
| 11003 |
| fine_audit |
| 11003 |
| rpt_start |
| 2022-01-01 00:00:00 |
| rpt_end |
| 2022-06-30 00:00:00 |
| rpt_date |
| 2022-07-19 00:00:00 |
| filing_type |
| 22001 |
|
Table: filings
| filing_id |
| 2741947 |
| filing_type |
| 22001 |
|
Table: hdr
| filing_id |
| 2741947 |
| 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 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 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 |
| line_item |
| 1 |
| 2 |
| 3 |
| 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 |
| 4 |
| 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 |
| 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 |
| tran_id |
| INC187 |
| INC185 |
| INC208 |
| INC206 |
| INC217 |
| INC218 |
| INC219 |
| INC249 |
| INC250 |
| INC251 |
| INC252 |
| INC254 |
| INC253 |
| INC264 |
| INC263 |
| INC265 |
| INC262 |
| INC267 |
| INC269 |
| INC271 |
| INC272 |
| INC266 |
| INC282 |
| INC283 |
| INC284 |
| INC285 |
| INC279 |
| INC288 |
| INC207 |
| entity_cd |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| IND |
| IND |
| OTH |
| IND |
| OTH |
| IND |
| IND |
| OTH |
| OTH |
| OTH |
| IND |
| IND |
| OTH |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| OTH |
| ctrib_naml |
| BLACK DIAMOND COMMERCIAL CONSTRUCTION, INC. |
| MICHAEL BURTON INC |
| CBRE GROUP |
| CBRE GROUP |
| CBRE GROUP |
| CBRE GROUP |
| CBRE GROUP |
| BEDINGFIELD |
| STOKE |
| BUILDING CAREERS, LLC(CARLY GLOVA) |
| YAGHDJIAN |
| BLACK DIAMOND COMMERCIAL CONSTRUCTION, INC. |
| RICHARD LA DOW |
| ARDUINO |
| CANTAMAR, LLC(GARY KATZ) |
| R. MICHAEL MURPHY TRUST |
| RI PROPERTIES INC. DBA RETAIL INSITE |
| HULSE |
| MOFALT |
| DEMPSEY CONSTRUCTION, INC. |
| MAJCHER |
| BURGER |
| LANDA |
| SCHERTZER |
| BOYLE |
| CAMBRA |
| LACHANCE |
| STANTON |
| CBRE GROUP |
| ctrib_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| SCOTT |
| JEFFREY |
| None |
| JOANNE |
| None |
| None |
| KAITLIN |
| None |
| None |
| None |
| DEREK |
| SCOTT |
| None |
| JAMES |
| JACK |
| FERNANDO |
| BRENT |
| JOHN |
| LAWRENCE |
| RANDALL |
| BRIAN |
| 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 |
| 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 |
| ctrib_city |
| SAN DIEGO |
| LA JOLLA |
| SAN DIEGO |
| SAN DIEGO |
| SAN DIEGO |
| SAN DIEGO |
| SAN DIEGO |
| LA JOLLA |
| DEL MAR |
| SAN DIEGO |
| SAN DIEGO |
| SAN DIEGO |
| SAN DIEGO |
| LA JOLLA |
| SAN DIEGO |
| HAILEY |
| SOLANA BEACH |
| SAN DIEGO |
| SAN DIEGO |
| CARLSBAD |
| ENCINITAS |
| SOLANA BEACH |
| SAN DIEGO |
| LOS ANGELES |
| ENCINITAS |
| CARLSBAD |
| ENCINITAS |
| ENCINITAS |
| SAN DIEGO |
| ctrib_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| ID |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| ctrib_zip4 |
| 92108 |
| 92037 |
| 92122 |
| 92122 |
| 92122 |
| 92122 |
| 92122 |
| 92037 |
| 92014 |
| 92115 |
| 92109 |
| 92108 |
| 92106 |
| 92037 |
| 92130 |
| 83333 |
| 92075 |
| 92116 |
| 92130 |
| 92008 |
| 92024 |
| 92075 |
| 92130 |
| 90026 |
| 92024 |
| 92011 |
| 92024 |
| 92024 |
| 92122 |
| ctrib_emp |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| CAVIGNAC |
| PROCOPIO |
| None |
| RANCHO BERNARDO COURTYARD |
| None |
| COLLIERS |
| MURPHY DEVELOPMENT COMPANY |
| MURPHY DEVELOPMENT |
| None |
| None |
| PALISADES COMMERICAL |
| LINCOLN PROPERTY COMPANY |
| None |
| LOWE |
| BURGER CONSTRUCTION |
| HARVEST LLP |
| HOLLAND PARTNER GROUP |
| STOS PARTNERS |
| CUSHMAN & WAKEFIELD |
| SELF EMPLOYED/SAME NAME |
| BYCOR GENERAL CONTRACTORS |
| None |
| ctrib_occ |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| INSURANCE |
| PARTNER |
| None |
| ASSET MANAGER |
| None |
| COMMERCIAL REAL ESTATE BROKER |
| PRESIDENT |
| CHAIRMAN |
| None |
| None |
| COMMERICAL REAL ESTATE AGENT |
| REAL ESTATE |
| None |
| COMMERCIAL REAL ESTATE EXECUTIVE |
| PRESIDENT |
| ATTORNEY |
| MANAGING DIRECTOR |
| REAL ESTATE |
| MANAGER |
| REAL ESTATE AGENT |
| VICE PRESIDENT/SENIOR ESTIMATOR |
| 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 |
| 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 |
| rcpt_date |
| 2022-01-12 00:00:00 |
| 2022-01-12 00:00:00 |
| 2022-02-04 00:00:00 |
| 2022-02-04 00:00:00 |
| 2022-02-08 00:00:00 |
| 2022-02-28 00:00:00 |
| 2022-02-28 00:00:00 |
| 2022-04-20 00:00:00 |
| 2022-04-20 00:00:00 |
| 2022-04-21 00:00:00 |
| 2022-04-21 00:00:00 |
| 2022-04-25 00:00:00 |
| 2022-04-25 00:00:00 |
| 2022-05-04 00:00:00 |
| 2022-05-04 00:00:00 |
| 2022-05-04 00:00:00 |
| 2022-05-04 00:00:00 |
| 2022-05-06 00:00:00 |
| 2022-05-09 00:00:00 |
| 2022-05-12 00:00:00 |
| 2022-05-12 00:00:00 |
| 2022-05-16 00:00:00 |
| 2022-05-25 00:00:00 |
| 2022-05-25 00:00:00 |
| 2022-05-31 00:00:00 |
| 2022-05-31 00:00:00 |
| 2022-06-06 00:00:00 |
| 2022-06-21 00:00:00 |
| 2022-02-04 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 |
| amount |
| 50 |
| 1000 |
| 50 |
| 50 |
| 50 |
| 50 |
| 50 |
| 2000 |
| 1000 |
| 1000 |
| 1000 |
| 2000 |
| 1000 |
| 1000 |
| 1000 |
| 2500 |
| 1000 |
| 1000 |
| 10000 |
| 1000 |
| 1000 |
| 1000 |
| 1000 |
| 1000 |
| 1000 |
| 1000 |
| 1000 |
| 1000 |
| 50 |
| cum_ytd |
| 2050 |
| 1000 |
| 300 |
| 300 |
| 300 |
| 300 |
| 300 |
| 2000 |
| 1000 |
| 1000 |
| 1000 |
| 2050 |
| 1000 |
| 1000 |
| 1000 |
| 2500 |
| 1000 |
| 1000 |
| 10000 |
| 1000 |
| 1000 |
| 1000 |
| 1000 |
| 1000 |
| 1000 |
| 1000 |
| 1000 |
| 1000 |
| 300 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| memo_refno |
| INC187 |
| INC185 |
| INC208 |
| INC206 |
| INC217 |
| INC218 |
| INC219 |
| None |
| None |
| None |
| None |
| INC254 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| INC207 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
|
Table: smry
| filing_id |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 2741947 |
| 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 |
| 37595 |
| 0 |
| 37595 |
| 0 |
| 37595 |
| 14315 |
| 0 |
| 14315 |
| 493 |
| 0 |
| 14808 |
| 12247 |
| 37595 |
| 0 |
| 14315 |
| 35527 |
| 0 |
| 0 |
| 1049 |
| 34850 |
| 2745 |
| 37595 |
| 5000 |
| 0 |
| 5000 |
| 14315 |
| 0 |
| 0 |
| 14315 |
| 1049 |
| 556 |
| 493 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| amount_b |
| 37595 |
| 0 |
| 37595 |
| 0 |
| 37595 |
| 14315 |
| 0 |
| 14315 |
| 1049 |
| 0 |
| 15364 |
| None |
| None |
| None |
| 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 |
|