PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2740855&amendid=0
filing_id | 2740855 | |
---|---|---|
amend_id | 0 | |
line_item | 1 | |
rec_type | CVR3 | |
form_type | F460 | |
tran_id | VER_1.1 | |
entity_cd | TRE | |
sig_date | 2022-10-23 00:00:00 | |
sig_loc | None | |
sig_naml | DAVID BAUER | |
sig_namf | None | |
sig_namt | None | |
sig_nams | None |
filing_id | 2740855 | |
---|---|---|
amend_id | 0 | |
rec_type | CVR | |
form_type | F460 | |
filer_id | 761102 | |
entity_cd | RCP | |
filer_naml | Build Jobs PAC, Sponsored by Building Industry Assoc. of the Bay Area | |
filer_namf | None | |
filer_namt | None | |
filer_nams | None | |
report_num | 000 | |
rpt_date | 2022-10-27 00:00:00 | |
stmt_type | PE | |
late_rptno | None | |
from_date | 2022-09-25 00:00:00 | |
thru_date | 2022-10-22 00:00:00 | |
elect_date | None | |
filer_city | Concord | |
filer_st | CA | |
filer_zip4 | 94520 | |
filer_phon | 925-951-6842 | |
filer_fax | None | |
file_email | david@theagency.us | |
mail_city | Granite Bay | |
mail_st | CA | |
mail_zip4 | 95746 | |
tres_naml | Bauer | |
tres_namf | David | |
tres_namt | None | |
tres_nams | None | |
tres_city | Granite Bay | |
tres_st | CA | |
tres_zip4 | 95746 | |
tres_phon | 916/473-4298 | |
tres_fax | None | |
tres_email | None | |
cmtte_type | G | |
control_yn | Y | |
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 |
filing_id | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
rec_type | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | EXPN | |||||||||||||||||||||||||||||||||||||||
form_type | D | D | D | D | D | D | D | D | D | D | D | D | D | E | E | E | E | E | E | E | E | E | E | E | E | E | E | G | G | G | G | G | G | G | G | G | G | G | G | |||||||||||||||||||||||||||||||||||||||
tran_id | EXP8312 | EXP8315 | EXP8310 | EXP8309 | EXP8313 | EXP8308 | EXP8311 | EXP8314 | EDT59 | EDT69 | EDT70 | EDT64 | EDT71 | EXP8312 | EXP8315 | EXP8310 | EXP8309 | EXP8313 | EXP8308 | EXP8311 | EXP8314 | EXP8397 | EXP8398 | EXP8399 | EXP8400 | EXP8401 | EXP8403 | EDT60 | EDT66 | EDT62 | EDT68 | EDT63 | EDT65 | EDT61 | EDT67 | EDT73 | EDT76 | EDT75 | EDT74 | |||||||||||||||||||||||||||||||||||||||
entity_cd | COM | COM | COM | COM | COM | COM | COM | COM | COM | COM | COM | COM | COM | COM | COM | COM | COM | COM | COM | COM | COM | OTH | OTH | OTH | IND | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | |||||||||||||||||||||||||||||||||||||||
payee_naml | Anthony Phan for Mayor of Milpitas 2022 | Cindy Silva for Walnut Creek City Council 2018 | Hon Lien for Milpitas City Council 20222 | Hugh Henderson for Oakley City Council 2022 | Julie Roche for City Council 2022 | Matt francois for Walnut Creek City Council 2022 | Peter Ortiz for San Jose City Council 2022 | San Jose Together, Supporting Cindy Chavex for Mayor 2022 | Mike Menesini for Mayor 2022 | Mike Menesini for Mayor 2022 | Mike Menesini for Mayor 2022 | Mike Menesini for Mayor 2022 | Mike Menesini for Mayor 2022 | Anthony Phan for Mayor of Milpitas 2022 | Cindy Silva for Walnut Creek City Council 2018 | Hon Lien for Milpitas City Council 20222 | Hugh Henderson for Oakley City Council 2022 | Julie Roche for City Council 2022 | Matt francois for Walnut Creek City Council 2022 | Peter Ortiz for San Jose City Council 2022 | San Jose Together, Supporting Cindy Chavex for Mayor 2022 | Rossi Communications | Rossi Communications | Rossi Communications | Bauer | Political Data Inc. | Rossi Communications | JB Services | JB Services | Klein Graphics LLC | Klein Graphics LLC | Spotlight Printing | Spotlight Printing | U.S. Postal Service | U.S. Postal Service | JB Services | Klein Graphics LLC | Spotlight Printing | U.S. Postal Service | |||||||||||||||||||||||||||||||||||||||
payee_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | David | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||
payee_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||
payee_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||
payee_city | MILPITAS | WALNUT CREEK | MILPITAS | OAKLEY | HAYWARD | WALNUT CREEK | SAN JOSE | SACRAMENTO | None | None | None | None | None | MILPITAS | WALNUT CREEK | MILPITAS | OAKLEY | HAYWARD | WALNUT CREEK | SAN JOSE | SACRAMENTO | CONCORD | CONCORD | CONCORD | Granite Bay | Long Beach | CONCORD | MARTINEZ | MARTINEZ | CONCORD | CONCORD | SAN FRANCISCO | SAN FRANCISCO | Oakland | Oakland | MARTINEZ | CONCORD | SAN FRANCISCO | Oakland | |||||||||||||||||||||||||||||||||||||||
payee_st | CA | CA | CA | CA | CA | CA | CA | CA | None | None | None | None | None | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||||||||||||||||
payee_zip4 | 95035 | 94598 | 95053 | 94561 | 94544 | 94596 | 95127 | 95815 | None | None | None | None | None | 95035 | 94598 | 95053 | 94561 | 94544 | 94596 | 95127 | 95815 | 94521 | 94521 | 94521 | 95746 | 90806 | 94521 | 94553 | 94553 | 94519 | 94519 | 94107 | 94107 | 94615 | 94615 | 94553 | 94519 | 94107 | 94615 | |||||||||||||||||||||||||||||||||||||||
expn_date | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 2022-10-11 00:00:00 | 2022-10-11 00:00:00 | 2022-10-13 00:00:00 | 2022-10-13 00:00:00 | 2022-10-14 00:00:00 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2022-10-15 00:00:00 | 2022-10-15 00:00:00 | 2022-10-19 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2022-10-19 00:00:00 | 2022-10-19 00:00:00 | 2022-10-19 00:00:00 | 2022-10-19 00:00:00 | |||||||||||||||||||||||||||||||||||||||
amount | 250 | 215 | 250 | 1000 | 500 | 215 | 500 | 10000 | 8781 | 2500 | 2500 | 5290 | 457 | 250 | 215 | 250 | 1000 | 500 | 215 | 500 | 10000 | 8781 | 5290 | 5000 | 406 | 457 | 8542 | 1095 | 548 | 1450 | 1000 | 2968 | 1795 | 2984 | 1775 | 1095 | 1500 | 2962 | 2984 | |||||||||||||||||||||||||||||||||||||||
cum_ytd | 250 | 215 | 250 | 1000 | 500 | 215 | 500 | 10000 | 19529 | 19529 | 19529 | 19529 | 19529 | 250 | 215 | 250 | 1000 | 500 | 215 | 500 | 10000 | 27613 | 27613 | 27613 | 2374 | 457 | 27613 | 2738 | 2738 | 3950 | 3950 | 7725 | 7725 | 7743 | 7743 | 2738 | 3950 | 7725 | 7743 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
expn_chkno | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||
expn_code | MON | MON | MON | MON | MON | MON | MON | MON | IND | IND | IKD | IND | IND | CTB | CTB | CTB | CTB | CTB | CTB | CTB | CTB | IND | IND | IND | PRO | LIT | IND | IND | IND | IND | IND | IND | IND | IND | IND | IND | IND | IND | IND | |||||||||||||||||||||||||||||||||||||||
expn_dscr | None | None | None | None | None | None | None | None | Mass mail | Mass mail | Mass mail | Mass mail | mass mail | None | None | None | None | None | None | None | None | Mass mail | Mass mail | Mass mail | None | None | Mass mail | Mass mail | Mass mail | Mass mail | Mass mail | Mass mail | Mass mail | Mass mail | Mass mail | Mass mail | Mass mail | Mass mail | Mass mail | |||||||||||||||||||||||||||||||||||||||
agent_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Rossi Communications | Rossi Communications | Rossi Communications | Rossi Communications | Rossi Communications | Rossi Communications | Rossi Communications | Rossi Communications | Rossi Communications | Rossi Communications | Rossi Communications | Rossi Communications | |||||||||||||||||||||||||||||||||||||||
agent_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||
agent_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||
agent_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||
cmte_id | 1449084 | 1365770 | 2559866 | 1453556 | 1443783 | 1448176 | 1439023 | 1444739 | None | None | None | None | None | 1449084 | 1365770 | 2559866 | 1453556 | 1443783 | 1448176 | 1439023 | 1444739 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||
tres_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
cand_naml | Anthony Phan | Cindy Silva | Hon Lien | Hugh Henderson | Julie Roche | Matt Francois | Peter Ortiz | Cindy Chavez | Mike Menesini | Mike Menesini | Mike Menesini | Mike Menesini | Mike Menesini | None | None | 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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
office_cd | MAY | CCM | CCM | CCM | CCM | CCM | CCM | MAY | MAY | MAY | MAY | MAY | MAY | None | None | 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 | |||||||||||||||||||||||||||||||||||||||
juris_cd | CIT | OTH | CIT | CIT | CIT | CIT | CIT | CIT | CIT | CIT | CIT | CIT | CIT | None | None | 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 | Milpitas | Walnut Creek | Milpitas | Oakley | Milpitas | Walnut Creek | Milpitas | San Jose | Martinez | Martinez | Martinez | Martinez | Martinez | None | None | 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 | 2 | None | None | None | None | None | None | None | None | None | None | None | 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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
sup_opp_cd | S | S | S | S | S | S | S | S | S | S | S | S | S | None | None | 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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
g_from_e_f | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | E | E | E | E | E | E | E | E | E | E | E | E | |||||||||||||||||||||||||||||||||||||||
xref_schnm | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 |
filer_id | 1021807 | |
---|---|---|
filing_id | 2740855 | |
period_id | 251 | |
form_id | F460 | |
filing_sequence | 0 | |
filing_date | 2022-10-25 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-27 00:00:00 | |
filing_type | 22001 |
filing_id | 2740855 | |
---|---|---|
filing_type | 22001 |
filing_id | 2740855 | |
---|---|---|
amend_id | 0 | |
rec_type | HDR | |
ef_type | CAL | |
state_cd | CA | |
cal_ver | 2.01 | |
soft_name | NETFILE | |
soft_ver | 2022451 | |
hdrcomment | None |
filing_id | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | A | A | A | A | A | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tran_id | EXP8395 | INC8331 | INC8351 | INC8380 | INC8352 | INC8317 | INC8353 | INC8391 | INC8354 | INC8381 | INC8350 | INC8327 | INC8382 | INC8383 | INC8318 | INC8332 | INC8355 | INC8346 | INC8356 | INC8357 | INC8333 | INC8319 | INC8384 | INC8329 | INC8347 | INC8343 | INC8358 | INC8344 | INC8316 | INC8385 | INC8334 | INC8359 | INC8335 | INC8392 | INC8386 | INC8360 | INC8361 | INC8362 | INC8393 | INC8387 | INC8326 | INC8336 | INC8376 | INC8363 | INC8364 | INC8365 | INC8377 | INC8388 | INC8337 | INC8389 | INC8366 | INC8320 | INC8323 | INC8345 | INC8367 | INC8368 | INC8369 | INC8338 | INC8339 | INC8378 | INC8321 | INC8348 | INC8330 | INC8322 | INC8370 | INC8371 | INC8340 | INC8390 | INC8394 | INC8328 | INC8374 | INC8341 | INC8372 | INC8379 | INC8373 | INC8324 | INC8342 | INC8375 | INC8349 | INC8325 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
entity_cd | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_naml | 6 Degrees Group | 6 Degrees Group | Accurate Firestop, Inc. | ADI Consultants | Advanced Automatic Sprinkler | Alcal Specialty Contracting Inc. | Amerisink | Atlantic & Pacific Build Group | Bassenian/ Lagoni Architects | Bay Interior Design | BNH Builders | Brookfield Residential | Builders First Source | BW Plastering Inc. | Capital City Drywall, Inc. | Capital One Spark Business | Carlson, Barbee & Gibson, Inc. | Caron Kavanagh Coaching | CBC Framing | Citibank | Civil Engineering Associates, Inc. | Clapp, Maroney, Vucinich, Beeman & Scheley | Constructo | Cornerstone Building Brands | Creative Mines | CRINNION CONSTRUCTION, INC. | D.H. Smith Company, Inc. | DeNova Homes, Inc. | DeNova Homes, Inc. | dk Engineering | Dryden Construction, Inc. | Eagle Roofing Products | Electrolux | Encore Capital Management | Fennemore Craig, P.C. | Gauger & Associates | Gouvis Engineering Consulting Group, Inc. | Graphic Language, Inc. | Greenberg Construction Inc. | Greystone Plastering, Inc. | Grupe Companies | Inman Law Group, LLP | Integral Communities | Janco Industries, Inc. | KPS Alarms | Landcastle Real Estate, Inc | Lennar Homes | Lubin Olson & Niewiadomski LLP | Marketshare, Inc. | Mayberry Workshop, LLC(Adam Mayberry) | MCH Electric | Milgard Windows | New Image Landscape Co. & Sansei Gardens, Inc. | O'BRIEN HOMES | OJ Insulation, LP | Old Republic Title Company | Osborne Company, Inc. | Pacific Dimensions, Inc. | Pacific Rim Plumbing | River Islands Development LLC(Susan Dell'Osso) | Rutan & Tucker, LLP | S & H Develop Group, Inc. | San Francisco Fire Credit Union | Sanco Pipelines Inc. | SDG Architects, Inc. | Sherwin Williams | SJA, Inc. | Spectraturf | Square 1 Homes | Steve Hanley Construction, Inc. | Stone Group, Inc. | Sukut Construction | Tarrar Utility Consultants | The Hanover Co. | The Ryness Company | Thorpe Design | Trinity Framing & Construction, Inc. | TruTeam of Calif. | Verdura Construction, LLC(James Verdura) | Wells Fargo Home Mortgage | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_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 | The | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | The | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_city | None | None | Pleasanton | Walnut Creek | San Ramon | Fremont | SAN LEANDRO | Walnut Creek | Newport Beach | Antioch | TRACY | Fremont | Woodland | Concord | North Highlands | PLEASAANT HILL | San Ramon | San Ramon | Canoga Park | None | San Jose | PLEASANTON | Campbell | West Sacramento | Carlsbad | Walnut Creek | San Jose | Concord | Concord | Walnut Creek | Livermore | Stockton | Alamo | Corte Madera | Walnut Creek | San Francisco | Palm Springs | Oakland | Palo Alto | San Jose | Stockton | Sacramento | San Ramon | Tracy | ONTARIO | Danville | San Ramon | San Francisco | San Jose | San Jose | Livermore | Sacramento | FREMONT | San Mateo | Gilroy | Concord | Livermore | El Segundo | Livermore | LATHROP | San Francisco | San Jose | San Francisco | LOS GATOS | Brentwood | Walnut Creek | SANTA CRUZ | Corona | Santa Clara | Fairfield | Pleasanton | SANTA ANA | Brentwood | DANVILLE | Danville | BRENTWOOD | TURLOCK | Livermore | HALF MOON BAY | San Francisco | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_st | None | None | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | None | 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_zip4 | None | None | 94566 | 94597 | 94583 | 94539 | 94577 | 94596 | 92660 | 94531 | 95376 | 94539 | 95776 | 94518 | 95660 | 94523 | 94583 | 94583 | 91304 | None | 95110 | 94588 | 95008 | 95691 | 92008 | 94596 | 95138 | 94520 | 94520 | 94596 | 94551 | 95206 | 94507 | 94925 | 94596 | 94111 | 92262 | 94605 | 94303 | 95125 | 95661 | 95814 | 94583 | 94536 | 91761 | 94526 | 94583 | 94111 | 95131 | 95112 | 94551 | 95828 | 94539 | 94403 | 95020 | 94520 | 94550 | 90245 | 94551 | 95330 | 94107 | 95125 | 94118 | 95032 | 94513 | 94598 | 95062 | 92879 | 95054 | 94534 | 94566 | 92704 | 94513 | 94526 | 94526 | 94513 | 95380 | 94550 | 94019 | 94105 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_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 | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_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 | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_self | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | R | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 2022-10-06 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 | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
amount | -625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 650 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 650 | 625 | 650 | 10000 | 625 | 625 | 625 | 625 | 650 | 625 | 625 | 625 | 625 | 650 | 625 | 650 | 625 | 650 | 625 | 625 | 625 | 650 | 625 | 625 | 625 | 625 | 625 | 625 | 650 | 625 | 625 | 625 | 625 | 625 | 650 | 625 | 650 | 625 | 625 | 625 | 625 | 625 | 625 | 650 | 650 | 625 | 625 | 625 | 650 | 625 | 625 | 625 | 625 | 650 | 625 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cum_ytd | 0 | 0 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 650 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 625 | 650 | 625 | 10650 | 10650 | 625 | 625 | 625 | 625 | 650 | 625 | 625 | 625 | 625 | 650 | 625 | 650 | 625 | 650 | 625 | 625 | 625 | 650 | 625 | 625 | 625 | 625 | 625 | 625 | 650 | 625 | 625 | 625 | 625 | 625 | 650 | 625 | 650 | 625 | 625 | 625 | 625 | 625 | 625 | 650 | 650 | 625 | 625 | 625 | 650 | 625 | 625 | 625 | 625 | 650 | 625 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cmte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tres_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
memo_refno | None | INC8331 | INC8351 | INC8380 | INC8352 | INC8317 | INC8353 | INC8391 | INC8354 | INC8381 | None | INC8327 | INC8382 | INC8383 | INC8318 | INC8332 | INC8355 | INC8346 | INC8356 | INC8357 | INC8333 | INC8319 | INC8384 | INC8329 | INC8347 | INC8343 | INC8358 | INC8344 | None | INC8385 | INC8334 | INC8359 | INC8335 | INC8392 | INC8386 | INC8360 | INC8361 | INC8362 | INC8393 | INC8387 | INC8326 | INC8336 | INC8376 | INC8363 | INC8364 | INC8365 | INC8377 | INC8388 | INC8337 | INC8389 | INC8366 | INC8320 | INC8323 | INC8345 | INC8367 | INC8368 | INC8369 | INC8338 | INC8339 | INC8378 | INC8321 | INC8348 | INC8330 | INC8322 | INC8370 | INC8371 | INC8340 | INC8390 | INC8394 | INC8328 | INC8374 | INC8341 | INC8372 | INC8379 | INC8373 | INC8324 | INC8342 | INC8375 | None | INC8325 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | 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 | None | None | None | None |
filing_id | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
line_item | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 1 | 2 | 3 | |||||||||||||||||||||||||||||||||||
rec_type | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | SMRY | |||||||||||||||||||||||||||||||||||
form_type | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | A | A | A | D | D | D | E | E | E | E | B1 | B1 | B1 | H | H | H | |||||||||||||||||||||||||||||||||||
amount_a | 58500 | 0 | 58500 | 0 | 58500 | 41441 | 0 | 41441 | 0 | 0 | 41441 | 172255 | 58500 | 0 | 41441 | 189314 | 0 | 0 | 0 | 58500 | 0 | 58500 | 32459 | 0 | 32459 | 41406 | 35 | 0 | 41441 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
amount_b | 58500 | 0 | 58500 | 0 | 58500 | 131709 | 0 | 131709 | 0 | 0 | 131709 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||
amount_c | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||
elec_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filing_id | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | 2740855 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 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 | |||||||||||||
pform_type | D | D | D | D | D | D | D | D | D | D | D | D | D | |||||||||||||
ptran_id | EXP8312 | EXP8315 | EXP8310 | EXP8309 | EXP8313 | EXP8308 | EXP8311 | EXP8314 | EDT59 | EDT69 | EDT70 | EDT64 | EDT71 | |||||||||||||
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 | |||||||||||||
elec_amount | 250 | 215 | 250 | 1000 | 500 | 215 | 500 | 10000 | 19529 | 19529 | 19529 | 19529 | 19529 | |||||||||||||
elec_code | G | G | G | G | G | G | G | G | G | G | G | G | G |