Home
Filing ID: 2743872
PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2743872&amendid=0
Table: cvr2_campaign_disclosure
filing_id |
| 2743872 |
amend_id |
| 0 |
line_item |
| 1 |
rec_type |
| CVR2 |
form_type |
| F460 |
tran_id |
| NIC5 |
entity_cd |
| COM |
title |
| None |
mail_city |
| None |
mail_st |
| None |
mail_zip4 |
| None |
f460_part |
| 5b |
cmte_id |
| 1374577 |
enty_naml |
| Pat Bates for Senate 2018 |
enty_namf |
| None |
enty_namt |
| None |
enty_nams |
| None |
enty_city |
| Laguna Niguel |
enty_st |
| CA |
enty_zip4 |
| 92677 |
enty_phon |
| 949-858-7448 |
enty_fax |
| None |
enty_email |
| None |
tres_naml |
| Slater |
tres_namf |
| Jen |
tres_namt |
| None |
tres_nams |
| None |
control_yn |
| Y |
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 |
| 2743872 |
| 2743872 |
amend_id |
| 0 |
| 0 |
line_item |
| 1 |
| 2 |
rec_type |
| CVR3 |
| CVR3 |
form_type |
| F460 |
| F460 |
tran_id |
| VER_1.1 |
| VER_2.2 |
entity_cd |
| TRE |
| CAO |
sig_date |
| 2022-10-25 00:00:00 |
| 2022-10-25 00:00:00 |
sig_loc |
| None |
| None |
sig_naml |
| Jen Slater |
| Pat Bates |
sig_namf |
| None |
| None |
sig_namt |
| None |
| None |
sig_nams |
| None |
| None |
|
Table: cvr_campaign_disclosure
filing_id |
| 2743872 |
amend_id |
| 0 |
rec_type |
| CVR |
form_type |
| F460 |
filer_id |
| 1265511 |
entity_cd |
| CTL |
filer_naml |
| Pat Bates for Supervisor 2022 |
filer_namf |
| None |
filer_namt |
| None |
filer_nams |
| None |
report_num |
| 000 |
rpt_date |
| 2022-10-26 00:00:00 |
stmt_type |
| PE |
late_rptno |
| None |
from_date |
| 2022-09-25 00:00:00 |
thru_date |
| 2022-10-22 00:00:00 |
elect_date |
| 2022-11-08 00:00:00 |
filer_city |
| Laguna Niguel |
filer_st |
| CA |
filer_zip4 |
| 92677 |
filer_phon |
| 949-858-7448 |
filer_fax |
| 949-858-6807 |
file_email |
| [email protected] |
mail_city |
| Laguna Niguel |
mail_st |
| CA |
mail_zip4 |
| 92677 |
tres_naml |
| Slater |
tres_namf |
| Jen |
tres_namt |
| None |
tres_nams |
| None |
tres_city |
| Irvine |
tres_st |
| CA |
tres_zip4 |
| 92618 |
tres_phon |
| 949-858-7448 |
tres_fax |
| None |
tres_email |
| None |
cmtte_type |
| C |
control_yn |
| N |
sponsor_yn |
| N |
primfrm_yn |
| None |
brdbase_yn |
| None |
amendexp_1 |
| None |
amendexp_2 |
| None |
amendexp_3 |
| None |
rpt_att_cb |
| None |
cmtte_id |
| None |
reportname |
| None |
rptfromdt |
| None |
rptthrudt |
| None |
emplbus_cb |
| None |
bus_name |
| None |
bus_city |
| None |
bus_st |
| None |
bus_zip4 |
| None |
bus_inter |
| None |
busact_cb |
| None |
busactvity |
| None |
assoc_cb |
| None |
assoc_int |
| None |
other_cb |
| None |
other_int |
| None |
cand_naml |
| Bates |
cand_namf |
| Patricia |
cand_namt |
| None |
cand_nams |
| None |
cand_city |
| Laguna Niguel |
cand_st |
| CA |
cand_zip4 |
| 92677 |
cand_phon |
| None |
cand_fax |
| None |
cand_email |
| None |
bal_name |
| None |
bal_num |
| None |
bal_juris |
| None |
office_cd |
| OTH |
offic_dscr |
| Board of Supervisors |
juris_cd |
| OTH |
juris_dscr |
| County of Orange |
dist_no |
| 5 |
off_s_h_cd |
| S |
sup_opp_cd |
| None |
employer |
| None |
occupation |
| None |
selfemp_cb |
| None |
bal_id |
| None |
cand_id |
| None |
|
Table: debt
filing_id |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
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 |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
| DEBT |
form_type |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
| F |
tran_id |
| PAY6066 |
| PAY5478 |
| PAY5989 |
| PAY6112 |
| PAY6113 |
| PAY6117 |
| PAY6119 |
| PAY6222 |
| PAY6111 |
| PAY6180 |
| PAY6019 |
| PAY6020 |
| PAY5964 |
| PAY6179 |
| PAY6109 |
| PAY6027 |
| PAY6128 |
| PAY6177 |
| PAY6232 |
entity_cd |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| IND |
| OTH |
| OTH |
| OTH |
| OTH |
payee_naml |
| Cardmember Services |
| Gilliard Blanning & Associates Inc |
| Gilliard Blanning & Associates Inc |
| Gilliard Blanning & Associates Inc |
| Gilliard Blanning & Associates Inc |
| Gilliard Blanning & Associates Inc |
| Gilliard Blanning & Associates Inc |
| Gilliard Blanning & Associates Inc |
| Laguna Niguel Investors No 1 LLC |
| Monaco Inc. |
| Quimby Group Consulting |
| Quimby Group Consulting |
| Stacy Davis |
| Stacy Davis |
| Swallow |
| Wendy Warfield & Associates |
| Wendy Warfield & Associates |
| Wendy Warfield & Associates |
| Wendy Warfield & Associates |
payee_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Suzette |
| 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 |
| Carol Stream |
| Rocklin |
| Rocklin |
| Rocklin |
| Rocklin |
| Rocklin |
| Rocklin |
| Rocklin |
| Laguna Niguel |
| Santa Ana |
| Tustin |
| Tustin |
| Lake Forest |
| Lake Forest |
| Laguna Beach |
| Sacramento |
| Sacramento |
| Sacramento |
| Sacramento |
payee_st |
| IL |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
payee_zip4 |
| 60197 |
| 95765 |
| 95765 |
| 95765 |
| 95765 |
| 95765 |
| 95765 |
| 95765 |
| 92677 |
| 92705 |
| 92780 |
| 92780 |
| 92630 |
| 92630 |
| 92651 |
| 95814 |
| 95814 |
| 95814 |
| 95814 |
beg_bal |
| 1608 |
| 3000 |
| 4000 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 6000 |
| 14390 |
| 367 |
| 0 |
| 0 |
| 743 |
| 0 |
| 0 |
| 0 |
amt_incur |
| 0 |
| 0 |
| 0 |
| 4000 |
| 1194 |
| 15000 |
| 2600 |
| 1750 |
| 1000 |
| 4037 |
| 0 |
| 0 |
| 0 |
| 3240 |
| 5000 |
| 0 |
| 470 |
| 374 |
| 220 |
amt_paid |
| 1608 |
| 0 |
| 4000 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 6000 |
| 14390 |
| 367 |
| 0 |
| 0 |
| 743 |
| 0 |
| 0 |
| 0 |
end_bal |
| 0 |
| 3000 |
| 0 |
| 4000 |
| 1194 |
| 15000 |
| 2600 |
| 1750 |
| 1000 |
| 4037 |
| 0 |
| 0 |
| 0 |
| 3240 |
| 5000 |
| 0 |
| 470 |
| 374 |
| 220 |
expn_code |
| FND |
| CNS |
| CNS |
| CNS |
| CNS |
| WEB |
| TEL |
| LIT |
| OFC |
| LIT |
| CNS |
| CNS |
| OFC |
| FND |
| CNS |
| CNS |
| CNS |
| CNS |
| CNS |
expn_dscr |
| 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 |
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 |
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 |
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: expn
filing_id |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
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 |
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 |
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 |
form_type |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| E |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
tran_id |
| EXP6091 |
| EXP6086 |
| EXP6125 |
| EXP6174 |
| EXP6172 |
| EXP6097 |
| EXP6099 |
| EXP6110 |
| EXP6118 |
| EXP6138 |
| EXP6145 |
| EXP6147 |
| EXP6148 |
| EXP6164 |
| EXP6087 |
| EXP6089 |
| EXP6093 |
| EXP6108 |
| EXP6095 |
| EDT124 |
| EDT123 |
| PDT251 |
| PDT253 |
| PDT252 |
| PDT254 |
| EDT126 |
| EDT121 |
| EDT122 |
entity_cd |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| IND |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
| OTH |
payee_naml |
| Campaign Compliance Group, Inc. |
| Capitol Tech Solutions/eFundraising Solutions LLC |
| Capitol Tech Solutions/eFundraising Solutions LLC |
| Cardmember Services |
| Cardmember Services |
| Gilliard Blanning & Associates Inc |
| Gilliard Blanning & Associates Inc |
| Laguna Niguel Investors No 1 LLC |
| Monaco Inc. |
| Monaco Inc. |
| Monaco Inc. |
| Monaco Inc. |
| Monaco Inc. |
| Monaco Inc. |
| Quimby Group Consulting |
| Quimby Group Consulting |
| Stacy Davis |
| Swallow |
| Wendy Warfield & Associates |
| Campaign Sidekick |
| Campaign Sidekick |
| COGS South Signs |
| Facebook Inc |
| Google |
| Media Services 55 |
| US Postmaster |
| US Postmaster |
| US Postmaster |
payee_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Suzette |
| 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 |
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 |
payee_city |
| Irvine |
| Sacramento |
| Sacramento |
| Carol Stream |
| Carol Stream |
| Rocklin |
| Rocklin |
| Laguna Niguel |
| Santa Ana |
| Santa Ana |
| Santa Ana |
| Santa Ana |
| Santa Ana |
| Santa Ana |
| Tustin |
| Tustin |
| Lake Forest |
| Laguna Beach |
| Sacramento |
| Aledo |
| Aledo |
| Santa Ana |
| Menlo Park |
| Mountain View |
| Laguna Woods |
| Laguna Niguel |
| Laguna Niguel |
| Laguna Niguel |
payee_st |
| CA |
| CA |
| CA |
| IL |
| IL |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| TX |
| TX |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
payee_zip4 |
| 92614 |
| 95816 |
| 95816 |
| 60197 |
| 60197 |
| 95765 |
| 95765 |
| 92677 |
| 92705 |
| 92705 |
| 92705 |
| 92705 |
| 92705 |
| 92705 |
| 92780 |
| 92780 |
| 92630 |
| 92651 |
| 95814 |
| 76008 |
| 76008 |
| 92707 |
| 94025 |
| 94043 |
| 92637 |
| 92607 |
| 92607 |
| 92607 |
expn_date |
| 2022-09-29 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-10-22 00:00:00 |
| 2022-10-01 00:00:00 |
| 2022-10-01 00:00:00 |
| 2022-09-29 00:00:00 |
| 2022-09-29 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-09-29 00:00:00 |
| 2022-09-29 00:00:00 |
| 2022-09-29 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-09-29 00:00:00 |
| 2022-09-29 00:00:00 |
| 2022-10-01 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-10-02 00:00:00 |
| 2022-10-02 00:00:00 |
| 2022-10-02 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-11 00:00:00 |
amount |
| 1926 |
| 578 |
| 1441 |
| 701 |
| 1608 |
| 4000 |
| 6082 |
| 1000 |
| 2941 |
| 6986 |
| 11013 |
| 8164 |
| 7152 |
| 2782 |
| 14390 |
| 6000 |
| 367 |
| 5000 |
| 743 |
| 275 |
| 275 |
| 6082 |
| 15000 |
| 144 |
| 2600 |
| 2941 |
| 6986 |
| 11013 |
cum_ytd |
| 11019 |
| 17292 |
| 17292 |
| 10259 |
| 10259 |
| 273633 |
| 273633 |
| 4500 |
| 154483 |
| 154483 |
| 154483 |
| 154483 |
| 154483 |
| 154483 |
| 26065 |
| 26065 |
| 3607 |
| 30913 |
| 1807 |
| 3825 |
| 3825 |
| 29267 |
| 33000 |
| 348 |
| 14375 |
| 49599 |
| 49599 |
| 49599 |
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 |
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 |
expn_code |
| PRO |
| OFC |
| OFC |
| FND |
| FND |
| CNS |
| CMP |
| OFC |
| POS |
| POS |
| POS |
| LIT |
| LIT |
| LIT |
| CNS |
| CNS |
| OFC |
| CNS |
| CNS |
| CMP |
| CMP |
| CMP |
| WEB |
| WEB |
| TEL |
| POS |
| POS |
| POS |
expn_dscr |
| None |
| None |
| None |
| None |
| See Schedule G for Details |
| None |
| Outdoor Signs - See Schedule G for Details |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| See Schedule G for Details |
| None |
| None |
| None |
| None |
| Outdoor Signs |
| 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 |
| Cardmember Services |
| Cardmember Services |
| Gilliard Blanning & Associates Inc |
| Gilliard Blanning & Associates Inc |
| Gilliard Blanning & Associates Inc |
| Gilliard Blanning & Associates Inc |
| Monaco Inc. |
| Monaco Inc. |
| Monaco Inc. |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
g_from_e_f |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| E |
| E |
| E |
| F |
| F |
| F |
| 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 |
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 |
|
Table: filer_filings
filer_id |
| 1265511 |
filing_id |
| 2743872 |
period_id |
| 251 |
form_id |
| F460 |
filing_sequence |
| 0 |
filing_date |
| 2022-10-27 00:00:00 |
stmnt_type |
| 10001 |
stmnt_status |
| 11003 |
session_id |
| 2021 |
user_id |
| CAFILER |
special_audit |
| 11003 |
fine_audit |
| 11003 |
rpt_start |
| 2022-09-25 00:00:00 |
rpt_end |
| 2022-10-22 00:00:00 |
rpt_date |
| 2022-10-26 00:00:00 |
filing_type |
| 22001 |
|
Table: filings
filing_id |
| 2743872 |
filing_type |
| 22001 |
|
Table: hdr
filing_id |
| 2743872 |
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 |
| 2743872 |
| 2743872 |
| 2743872 |
amend_id |
| 0 |
| 0 |
| 0 |
line_item |
| 1 |
| 2 |
| 3 |
rec_type |
| LOAN |
| LOAN |
| LOAN |
form_type |
| B1 |
| B1 |
| B1 |
tran_id |
| PAY1638 |
| PAY1935 |
| PAY2213 |
loan_type |
| None |
| None |
| None |
entity_cd |
| IND |
| IND |
| IND |
lndr_naml |
| Bates |
| Bates |
| Bates |
lndr_namf |
| Patricia |
| Patricia |
| Patricia |
lndr_namt |
| None |
| None |
| None |
lndr_nams |
| None |
| None |
| None |
loan_city |
| Laguna Niguel |
| Laguna Niguel |
| Laguna Niguel |
loan_st |
| CA |
| CA |
| CA |
loan_zip4 |
| 92677 |
| 92677 |
| 92677 |
loan_date1 |
| 2006-03-17 00:00:00 |
| 2006-05-19 00:00:00 |
| 2006-06-30 00:00:00 |
loan_date2 |
| 2007-03-17 00:00:00 |
| None |
| None |
loan_amt1 |
| 0 |
| 0 |
| 0 |
loan_amt2 |
| 87000 |
| 150000 |
| 200000 |
loan_amt3 |
| 0 |
| 0 |
| 0 |
loan_amt4 |
| 87000 |
| 150000 |
| 200000 |
loan_rate |
| 0.00 |
| 0.00 |
| 0.00 |
loan_emp |
| State of CA |
| State of CA |
| State of CA |
loan_occ |
| Senator |
| Senator |
| Senator |
loan_self |
| None |
| None |
| None |
cmte_id |
| None |
| None |
| None |
tres_naml |
| None |
| None |
| None |
tres_namf |
| None |
| None |
| None |
tres_namt |
| None |
| None |
| None |
tres_nams |
| None |
| None |
| None |
tres_city |
| None |
| None |
| None |
tres_st |
| None |
| None |
| None |
tres_zip4 |
| None |
| None |
| None |
intr_naml |
| None |
| None |
| None |
intr_namf |
| None |
| None |
| None |
intr_namt |
| None |
| None |
| None |
intr_nams |
| None |
| None |
| None |
intr_city |
| None |
| None |
| None |
intr_st |
| None |
| None |
| None |
intr_zip4 |
| None |
| None |
| None |
memo_code |
| None |
| None |
| None |
memo_refno |
| None |
| None |
| None |
bakref_tid |
| None |
| None |
| None |
xref_schnm |
| None |
| None |
| None |
xref_match |
| None |
| None |
| None |
loan_amt5 |
| 0 |
| 0 |
| 0 |
loan_amt6 |
| 0 |
| 0 |
| 0 |
loan_amt7 |
| 0 |
| 0 |
| 0 |
loan_amt8 |
| 128000 |
| 150000 |
| 200000 |
|
Table: rcpt
filing_id |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| 24 |
| 25 |
| 26 |
| 27 |
| 28 |
| 29 |
| 30 |
| 31 |
| 32 |
| 33 |
| 34 |
| 35 |
| 36 |
| 37 |
| 38 |
| 39 |
| 40 |
| 41 |
| 42 |
| 43 |
| 44 |
| 45 |
| 46 |
| 47 |
| 48 |
| 49 |
| 50 |
| 51 |
| 52 |
| 53 |
| 54 |
| 55 |
| 56 |
| 57 |
| 58 |
| 59 |
| 60 |
| 61 |
| 62 |
| 63 |
| 64 |
| 65 |
| 66 |
| 67 |
| 68 |
| 69 |
| 70 |
| 71 |
| 72 |
| 73 |
| 74 |
| 75 |
| 76 |
rec_type |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
| RCPT |
form_type |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| C |
tran_id |
| INC6176 |
| INC6146 |
| INC6080 |
| INC6167 |
| INC6104 |
| INC6127 |
| INC6199 |
| INC6120 |
| INC6225 |
| INC6122 |
| INC6223 |
| INC6215 |
| INC6231 |
| INC6115 |
| INC6175 |
| INC6188 |
| INC6178 |
| INC6212 |
| INC6185 |
| INC6121 |
| INC6114 |
| INC6154 |
| INC6166 |
| INC6194 |
| INC6208 |
| INC6203 |
| INC6204 |
| INC6214 |
| INC6206 |
| INC6219 |
| INC6209 |
| INC6197 |
| INC6129 |
| INC6230 |
| INC6196 |
| INC6226 |
| INC6116 |
| INC6191 |
| INC6250 |
| INC6213 |
| INC6159 |
| INC6101 |
| INC6218 |
| INC6137 |
| INC6136 |
| INC6192 |
| INC6102 |
| INC6193 |
| INC6155 |
| INC6201 |
| INC6139 |
| INC6149 |
| INC6195 |
| INC6160 |
| INC6211 |
| INC6141 |
| INC6142 |
| INC6161 |
| INC6162 |
| INC6157 |
| INC6205 |
| INC6187 |
| INC6207 |
| INC6144 |
| INC6190 |
| INC6126 |
| INC6189 |
| INC6143 |
| INC6227 |
| INC6130 |
| INC6186 |
| INC6198 |
| INC6216 |
| INC6105 |
| INC6229 |
| NON6131 |
entity_cd |
| IND |
| IND |
| OTH |
| COM |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| COM |
| COM |
| COM |
| COM |
| OTH |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| OTH |
| SCC |
| SCC |
| IND |
| OTH |
| IND |
| IND |
| OTH |
| COM |
| IND |
| IND |
| IND |
| IND |
| OTH |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| OTH |
| IND |
| IND |
| COM |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| IND |
| OTH |
| IND |
| IND |
| IND |
| IND |
| IND |
| OTH |
| COM |
| OTH |
| IND |
| OTH |
| IND |
| IND |
| OTH |
| IND |
| IND |
| IND |
| IND |
| IND |
| OTH |
ctrib_naml |
| Abrams |
| Albrecht |
| AnheuserBusch Companies, Inc. |
| Assoc. Builders & Contractors of Southern CA PAC |
| Avetoom |
| Barth |
| Bauer |
| Bengard |
| Bergen |
| Bombard |
| Bradley |
| Business for a Better San Clemente |
| CA Academy of Eye Physicians & Surgeons PAC |
| CA Assoc of Oral & Maxillofacial Surgeons PAC |
| CA Optometric PAC |
| Cabco Yellow Inc. |
| Cabral |
| Capata |
| Capouya |
| Carruth |
| Caskey |
| Christensen |
| Clarey |
| Cope |
| CR&R Incorporated |
| CREPAC - California Real Estate PAC |
| CREPAC - California Real Estate PAC |
| Cvengros |
| DeNault's Hardware - Home Centers, Inc |
| Dodson |
| Donchak |
| Duty Free Holdings, LLC-Philippe Dray |
| Engineering Contractors' Association PAC |
| Feinberg |
| Frieden |
| Hofer |
| Horowitz |
| Intratek Computer, Inc. |
| Iselin |
| Jackson |
| Johns |
| Kalez |
| Kaufman |
| Kling |
| Konopisos |
| LAZ Parking Inc |
| Luckey |
| Mackaig |
| Manufactured Housing Educational Trust PAC / MHET PAC |
| Maseeh |
| Matranga |
| Miller |
| Morris |
| Morrison |
| Munson |
| Nordstrom |
| Nossaman, Inc. |
| Paulsen |
| Paulsen |
| Probolsky |
| Rains |
| Rochford |
| Silver-Bronze Corporation |
| South Orange County Economic Coalition PAC |
| Team Martinez-Sanchez LLC-Tricia Sanchez |
| Thacker |
| The Diamond Group |
| Tomlinson |
| Tucker |
| VCS Environmental - Julie Beeman |
| Villasenor |
| Walters |
| Williams |
| Zdrakas |
| Zdrakas |
| Delta Ventures Inc. |
ctrib_namf |
| Daniel |
| Richard |
| None |
| None |
| Alex |
| Mike |
| Cord |
| Kim C. |
| Ronald |
| Greg |
| Robert |
| None |
| None |
| None |
| None |
| None |
| Anna |
| Gary |
| Lynn E. |
| Melody |
| Susan |
| Karen |
| John |
| Alissa |
| None |
| None |
| None |
| William |
| None |
| Karen |
| Lori |
| None |
| None |
| Sheri |
| Jeffrey P. |
| Paul |
| David L. |
| None |
| Tiffani |
| Patrick |
| Elizabeth Colleen |
| Donna |
| Harold R. |
| Christopher |
| Nick |
| None |
| Palmer |
| Richard |
| None |
| Fariborz |
| Douglas |
| Jim |
| Brook |
| Theresa |
| Thomas |
| Richard M. |
| None |
| Liddy |
| Scott |
| Brian |
| Sandy |
| John |
| None |
| None |
| None |
| Cynthia |
| None |
| John |
| Thomas |
| None |
| Isabelle |
| Mike |
| John S. |
| Steve |
| Steve |
| None |
ctrib_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
ctrib_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
ctrib_city |
| Laguna Niguel |
| Laguna Hills |
| Sacramento |
| San Diego |
| Santa Ana |
| Orange |
| San Clemente |
| San Clemente |
| Newport Beach |
| Rancho Palos Verdes |
| Newport Beach |
| San Clemente |
| San Francisco |
| Roseville |
| Sacramento |
| Santa Ana |
| San Clemente |
| Laguna Niguel |
| Newport Beach |
| Laguna Hills |
| Laguna Hills |
| Laguna Beach |
| Newport Beach |
| Laguna Niguel |
| Stanton |
| Los Angeles |
| Los Angeles |
| San Juan Capistrano |
| Rancho Sta Margari |
| Laguna Woods |
| San Clemente |
| Miami |
| Sacramento |
| Laguna Hills |
| Irvine |
| Ontario |
| Laguna Niguel |
| Huntington Beach |
| Lake Forest |
| Laguna Beach |
| Newport Beach |
| Dana Point |
| Las Vegas |
| Laguna Beach |
| Placentia |
| Hartford |
| Vista |
| Dana Point |
| Laguna Hills |
| Newport Beach |
| Laguna Niguel |
| Dana Point |
| Irvine |
| Tustin |
| Trabuco Canyon |
| West Covina |
| Los Angeles |
| Newport Beach |
| Newport Beach |
| Aliso Viejo |
| Laguna Niguel |
| Irvine |
| Newport Beach |
| Irvine |
| Newport Beach |
| Buena Park |
| Irvine |
| Brea |
| Newport Beach |
| San Juan Capistrano |
| Corona Del Mar |
| Beaverton |
| Mission Viejo |
| San Clemente |
| San Clemente |
| Newport Beach |
ctrib_st |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| Ca |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| FL |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| CA |
| NV |
| CA |
| CA |
| CT |
| 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 |
| OR |
| CA |
| CA |
| CA |
| CA |
ctrib_zip4 |
| 92677 |
| 92653 |
| 95841 |
| 92119 |
| 92705 |
| 92868 |
| 92673 |
| 92672 |
| 92660 |
| 90275 |
| 92660 |
| 92672 |
| 94131 |
| 95661 |
| 95816 |
| 92707 |
| 92673 |
| 92677 |
| 92660 |
| 92653 |
| 92653 |
| 92651 |
| 92662 |
| 92677 |
| 90680 |
| 90071 |
| 90071 |
| 92675 |
| 92688 |
| 92637 |
| 92672 |
| 33126 |
| 95814 |
| 92653 |
| 92612 |
| 91761 |
| 92677 |
| 92649 |
| 92630 |
| 92651 |
| 92660 |
| 92629 |
| 89131 |
| 92651 |
| 92870 |
| 06103 |
| 92084 |
| 92629 |
| 92653 |
| 92660 |
| 92677 |
| 92629 |
| 92603 |
| 92780 |
| 92679 |
| 91791 |
| 90071 |
| 92660 |
| 92660 |
| 92656 |
| 92677 |
| 92604 |
| 92660 |
| 92618 |
| 92663 |
| 90621 |
| 92618 |
| 92821 |
| 92660 |
| 92675 |
| 92625 |
| 97008 |
| 92691 |
| 92672 |
| 92672 |
| 92660 |
ctrib_emp |
| Abrams California Health Insurance |
| Albrecht & Barney |
| None |
| None |
| Para Bellum Strategies |
| J&M Contractors |
| Time Zone Consulting Corp. |
| Kim Bengard |
| Retired |
| Catalina Express |
| Dahn Corporation |
| None |
| None |
| None |
| None |
| None |
| Anna Cabral |
| Gary Capata |
| Lynn E. Capouya |
| Retired |
| Retired |
| Retired |
| Clarey Capital |
| Alissa Cope |
| None |
| None |
| None |
| Retired |
| None |
| Vail Dunlap & Associates |
| Retired |
| None |
| None |
| Printex Printing And Graphics Inc |
| Auction.com |
| Hofer Ranch Company |
| Horowitz Management, Inc. |
| None |
| IMS Cost Containment |
| None |
| None |
| Dana Wharf Sportfishing |
| EPS Settlements Group |
| Laguna Corporate Car Service |
| Theopacific Holdings, LLC |
| None |
| Anduril Industries, Inc. |
| Retired |
| None |
| Kids Institute for Development & Advancement LLC |
| Douglas Landscape |
| Coffee Management Inc. |
| Prism Realty |
| Cagney Enterprises, LLC |
| C12 Orange County |
| Retired |
| None |
| Retired |
| Retired |
| Moulton Niguel Water |
| Visions LLC |
| Snyder Langston |
| None |
| None |
| None |
| Retired |
| None |
| Tomlinson Management, Inc. |
| Retired |
| None |
| Dejon Enterprises, Inc. |
| Action1 |
| None |
| Proud Mary's Restaurant |
| Proud Mary's Restaurant |
| None |
ctrib_occ |
| Insurance |
| Attorney |
| None |
| None |
| Consultant |
| CEO |
| Designer |
| Investor |
| Retired |
| President |
| Real Estate Executive |
| None |
| None |
| None |
| None |
| None |
| Professional Services |
| CPA |
| Landscape Architect |
| Retired |
| Retired |
| Retired |
| CEO |
| Environmental Planner |
| None |
| None |
| None |
| Retired |
| None |
| Accts Manager |
| Retired |
| None |
| None |
| Owner |
| President |
| Farmer |
| Executive |
| None |
| CFO |
| Retired |
| Retired |
| Owner |
| Settlement Broker |
| Owner |
| Principal - Development & Acquisitions |
| None |
| Founder |
| Retired |
| None |
| President |
| Commercial Landscaper |
| Restaurant |
| Exec |
| Real Estate Investor |
| Owner |
| Retired |
| None |
| Retired |
| Retired |
| Director |
| Owner |
| Contractor |
| None |
| None |
| None |
| Retired |
| None |
| Property Manager |
| Retired |
| None |
| President & CEO |
| President |
| Retired |
| Manager |
| Manager |
| None |
ctrib_self |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
tran_type |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
rcpt_date |
| 2022-10-14 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-09-27 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-04 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-14 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-13 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-06 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-20 00:00:00 |
| 2022-10-03 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-09-29 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-10 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-08 00:00:00 |
| 2022-10-08 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-12 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-05 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-11 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-07 00:00:00 |
| 2022-10-17 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-10-18 00:00:00 |
| 2022-09-30 00:00:00 |
| 2022-10-21 00:00:00 |
| 2022-10-06 00:00:00 |
date_thru |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
amount |
| 250 |
| 250 |
| 2200 |
| 2200 |
| 25 |
| 250 |
| 100 |
| 1000 |
| 250 |
| 1000 |
| 1000 |
| 500 |
| 2200 |
| 1500 |
| 2200 |
| 1000 |
| 100 |
| 250 |
| 250 |
| 500 |
| 1000 |
| 250 |
| 2200 |
| 250 |
| 2200 |
| 1100 |
| 1100 |
| 250 |
| 250 |
| 500 |
| 250 |
| 500 |
| 2200 |
| 100 |
| 1000 |
| 2200 |
| 2200 |
| 250 |
| 500 |
| 525 |
| 1000 |
| 1000 |
| 99 |
| 250 |
| 1100 |
| 1000 |
| 2200 |
| 156 |
| 500 |
| 2200 |
| 50 |
| 500 |
| 2200 |
| 1000 |
| 100 |
| 100 |
| 250 |
| 125 |
| 125 |
| 99 |
| 500 |
| 250 |
| 2200 |
| 2200 |
| 250 |
| 400 |
| 500 |
| 250 |
| 500 |
| 250 |
| 500 |
| 500 |
| 500 |
| 1000 |
| 1000 |
| 1433 |
cum_ytd |
| 2700 |
| 2250 |
| 2200 |
| 3200 |
| 124 |
| 250 |
| 100 |
| 1500 |
| 250 |
| 4200 |
| 1500 |
| 2700 |
| 2200 |
| 3700 |
| 4400 |
| 1000 |
| 100 |
| 2500 |
| 250 |
| 500 |
| 1000 |
| 250 |
| 2200 |
| 250 |
| 3200 |
| 2200 |
| 2200 |
| 1350 |
| 1550 |
| 500 |
| 500 |
| 500 |
| 2350 |
| 100 |
| 1000 |
| 4400 |
| 4400 |
| 250 |
| 2700 |
| 525 |
| 1000 |
| 3200 |
| 199 |
| 1250 |
| 1100 |
| 1000 |
| 2200 |
| 774 |
| 500 |
| 2200 |
| 899 |
| 2700 |
| 2200 |
| 1500 |
| 100 |
| 100 |
| 250 |
| 125 |
| 375 |
| 399 |
| 550 |
| 250 |
| 2200 |
| 2200 |
| 250 |
| 400 |
| 500 |
| 2250 |
| 1000 |
| 1000 |
| 500 |
| 600 |
| 500 |
| 2000 |
| 2000 |
| 1933 |
cum_oth |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
ctrib_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| Event Costs - Reception Only |
cmte_id |
| None |
| None |
| None |
| 1282257 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 882300 |
| 980331 |
| 1235948 |
| 745825 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 890106 |
| 890106 |
| None |
| None |
| None |
| None |
| None |
| 790729 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 820165 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| 1351921 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
tres_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
tres_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
tres_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
tres_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
tres_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
tres_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
tres_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
intr_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
intr_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
intr_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
intr_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
intr_city |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
intr_st |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
intr_zip4 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
intr_emp |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
intr_occ |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
intr_self |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cand_naml |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cand_namf |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cand_namt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
cand_nams |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
office_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
offic_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
juris_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
juris_dscr |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
dist_no |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
off_s_h_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
bal_name |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
bal_num |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
bal_juris |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
sup_opp_cd |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
memo_code |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
memo_refno |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| NON6131 |
bakref_tid |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
xref_schnm |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
xref_match |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
int_rate |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
intr_cmteid |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: smry
filing_id |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 4 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 1 |
| 2 |
| 3 |
| 4 |
rec_type |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
| SMRY |
form_type |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| F460 |
| A |
| A |
| A |
| B1 |
| B1 |
| B1 |
| C |
| C |
| C |
| D |
| D |
| D |
| E |
| E |
| E |
| E |
| F |
| F |
| F |
| H |
| H |
| H |
| I |
| I |
| I |
| I |
amount_a |
| 61257 |
| 0 |
| 61257 |
| 1433 |
| 62690 |
| 82875 |
| 0 |
| 82875 |
| 11776 |
| 1433 |
| 96084 |
| 133136 |
| 61257 |
| 0 |
| 82875 |
| 111518 |
| 0 |
| 0 |
| 478885 |
| 60704 |
| 553 |
| 61257 |
| 0 |
| 0 |
| 0 |
| 1433 |
| 0 |
| 1433 |
| 0 |
| 0 |
| 0 |
| 82875 |
| 0 |
| 0 |
| 82875 |
| 38885 |
| 27109 |
| 11776 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
amount_b |
| 688607 |
| 437000 |
| 1125607 |
| 5018 |
| 1130625 |
| 612056 |
| 0 |
| 612056 |
| 41885 |
| 5018 |
| 658959 |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
amount_c |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
elec_dt |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
| None |
|
Table: splt
filing_id |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
| 2743872 |
amend_id |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
line_item |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| 24 |
| 25 |
| 26 |
| 27 |
| 28 |
| 29 |
| 30 |
| 31 |
| 32 |
| 33 |
| 34 |
| 35 |
| 36 |
| 37 |
| 38 |
| 39 |
| 40 |
| 41 |
| 42 |
| 43 |
| 44 |
| 45 |
| 46 |
| 47 |
| 48 |
| 49 |
| 50 |
| 51 |
| 52 |
| 53 |
| 54 |
| 55 |
| 56 |
| 57 |
| 58 |
| 59 |
| 60 |
| 61 |
| 62 |
| 63 |
| 64 |
| 65 |
| 66 |
| 67 |
| 68 |
| 69 |
| 70 |
| 71 |
| 72 |
| 73 |
| 74 |
| 75 |
| 76 |
| 77 |
| 78 |
| 79 |
| 80 |
| 81 |
| 82 |
| 83 |
| 84 |
| 85 |
| 86 |
| 87 |
| 88 |
| 89 |
| 90 |
| 91 |
| 92 |
| 93 |
| 94 |
| 95 |
| 96 |
| 97 |
| 98 |
| 99 |
| 100 |
| 101 |
| 102 |
| 103 |
| 104 |
| 105 |
| 106 |
| 107 |
pform_type |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| A |
| C |
ptran_id |
| INC6176 |
| INC6176 |
| INC6146 |
| INC6146 |
| INC6080 |
| INC6167 |
| INC6167 |
| INC6104 |
| INC6104 |
| INC6127 |
| INC6199 |
| INC6120 |
| INC6120 |
| INC6225 |
| INC6122 |
| INC6122 |
| INC6223 |
| INC6215 |
| INC6215 |
| INC6231 |
| INC6115 |
| INC6115 |
| INC6175 |
| INC6175 |
| INC6188 |
| INC6178 |
| INC6212 |
| INC6212 |
| INC6185 |
| INC6121 |
| INC6114 |
| INC6154 |
| INC6166 |
| INC6194 |
| INC6208 |
| INC6208 |
| INC6203 |
| INC6203 |
| INC6204 |
| INC6204 |
| INC6214 |
| INC6214 |
| INC6206 |
| INC6206 |
| INC6219 |
| INC6209 |
| INC6209 |
| INC6197 |
| INC6129 |
| INC6129 |
| INC6230 |
| INC6196 |
| INC6226 |
| INC6226 |
| INC6116 |
| INC6116 |
| INC6191 |
| INC6250 |
| INC6250 |
| INC6213 |
| INC6159 |
| INC6101 |
| INC6101 |
| INC6218 |
| INC6218 |
| INC6137 |
| INC6137 |
| INC6136 |
| INC6192 |
| INC6102 |
| INC6193 |
| INC6193 |
| INC6155 |
| INC6201 |
| INC6139 |
| INC6139 |
| INC6149 |
| INC6149 |
| INC6195 |
| INC6160 |
| INC6160 |
| INC6211 |
| INC6141 |
| INC6142 |
| INC6161 |
| INC6162 |
| INC6157 |
| INC6157 |
| INC6205 |
| INC6205 |
| INC6187 |
| INC6207 |
| INC6144 |
| INC6190 |
| INC6126 |
| INC6189 |
| INC6143 |
| INC6143 |
| INC6227 |
| INC6130 |
| INC6130 |
| INC6186 |
| INC6198 |
| INC6216 |
| INC6105 |
| INC6229 |
| NON6131 |
elec_date |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
| 2022-01-01 00:00:00 |
elec_amount |
| 2200 |
| 500 |
| 2000 |
| 250 |
| 2200 |
| 1000 |
| 2200 |
| 99 |
| 25 |
| 250 |
| 100 |
| 500 |
| 1000 |
| 250 |
| 2200 |
| 2000 |
| 1500 |
| 2200 |
| 500 |
| 2200 |
| 2200 |
| 1500 |
| 2200 |
| 2200 |
| 1000 |
| 100 |
| 1250 |
| 1250 |
| 250 |
| 500 |
| 1000 |
| 250 |
| 2200 |
| 250 |
| 1000 |
| 2200 |
| 1000 |
| 2200 |
| 1000 |
| 2200 |
| 1100 |
| 250 |
| 1300 |
| 250 |
| 500 |
| 250 |
| 250 |
| 500 |
| 150 |
| 2200 |
| 100 |
| 1000 |
| 2200 |
| 2200 |
| 2200 |
| 2200 |
| 250 |
| 2200 |
| 500 |
| 525 |
| 1000 |
| 2200 |
| 1000 |
| 100 |
| 99 |
| 500 |
| 750 |
| 1100 |
| 1000 |
| 2200 |
| 305 |
| 469 |
| 500 |
| 2200 |
| 849 |
| 50 |
| 2200 |
| 500 |
| 2200 |
| 500 |
| 1000 |
| 100 |
| 100 |
| 250 |
| 125 |
| 375 |
| 300 |
| 99 |
| 50 |
| 500 |
| 250 |
| 2200 |
| 2200 |
| 250 |
| 400 |
| 500 |
| 2000 |
| 250 |
| 1000 |
| 750 |
| 250 |
| 500 |
| 600 |
| 500 |
| 2000 |
| 2000 |
| 1933 |
elec_code |
| P |
| G |
| P |
| G |
| G |
| P |
| G |
| P |
| G |
| G |
| G |
| P |
| G |
| G |
| P |
| G |
| G |
| P |
| G |
| G |
| P |
| G |
| P |
| G |
| G |
| G |
| P |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| P |
| G |
| P |
| G |
| P |
| G |
| P |
| G |
| P |
| G |
| G |
| P |
| G |
| G |
| P |
| G |
| G |
| G |
| P |
| G |
| P |
| G |
| G |
| P |
| G |
| G |
| G |
| P |
| G |
| P |
| G |
| P |
| G |
| G |
| G |
| G |
| P |
| G |
| G |
| G |
| P |
| G |
| P |
| G |
| G |
| P |
| G |
| G |
| G |
| G |
| G |
| G |
| P |
| G |
| P |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
| P |
| G |
| G |
| P |
| G |
| G |
| G |
| G |
| G |
| G |
| G |
|