PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2744175&amendid=0
filing_id | 2744175 | |
---|---|---|
amend_id | 0 | |
line_item | 1 | |
rec_type | CVR2 | |
form_type | F460 | |
tran_id | OFC1 | |
entity_cd | ATR | |
title | None | |
mail_city | None | |
mail_st | None | |
mail_zip4 | None | |
f460_part | 3 | |
cmte_id | None | |
enty_naml | Deane | |
enty_namf | Shawnda | |
enty_namt | None | |
enty_nams | None | |
enty_city | Sacramento | |
enty_st | CA | |
enty_zip4 | 95815 | |
enty_phon | (916) 285-5733 | |
enty_fax | None | |
enty_email | None | |
tres_naml | None | |
tres_namf | None | |
tres_namt | None | |
tres_nams | None | |
control_yn | None | |
office_cd | None | |
offic_dscr | None | |
juris_cd | None | |
juris_dscr | None | |
dist_no | None | |
off_s_h_cd | None | |
bal_name | None | |
bal_num | None | |
bal_juris | None | |
sup_opp_cd | None |
filing_id | 2744175 | 2744175 | ||
---|---|---|---|---|
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 | ATR | CAO | ||
sig_date | 2022-10-26 00:00:00 | 2022-10-26 00:00:00 | ||
sig_loc | None | None | ||
sig_naml | Shawnda Deane | Diane Papan | ||
sig_namf | None | None | ||
sig_namt | None | None | ||
sig_nams | None | None |
filing_id | 2744175 | |
---|---|---|
amend_id | 0 | |
rec_type | CVR | |
form_type | F460 | |
filer_id | 1442617 | |
entity_cd | CTL | |
filer_naml | Papan for Assembly 2022 | |
filer_namf | None | |
filer_namt | None | |
filer_nams | None | |
report_num | 000 | |
rpt_date | 2022-10-25 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 | Sacramento | |
filer_st | CA | |
filer_zip4 | 95815 | |
filer_phon | (916) 285-5733 | |
filer_fax | (916) 333-1344 | |
file_email | [email protected] | |
mail_city | None | |
mail_st | None | |
mail_zip4 | None | |
tres_naml | Papan | |
tres_namf | Diane | |
tres_namt | None | |
tres_nams | None | |
tres_city | Sacramento | |
tres_st | CA | |
tres_zip4 | 95815 | |
tres_phon | (916) 285-5733 | |
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 | Papan | |
cand_namf | Diane | |
cand_namt | None | |
cand_nams | None | |
cand_city | San Mateo | |
cand_st | CA | |
cand_zip4 | 94402 | |
cand_phon | (415) 377-4462 | |
cand_fax | None | |
cand_email | None | |
bal_name | None | |
bal_num | None | |
bal_juris | None | |
office_cd | ASM | |
offic_dscr | None | |
juris_cd | OTH | |
juris_dscr | None | |
dist_no | 21 | |
off_s_h_cd | S | |
sup_opp_cd | None | |
employer | None | |
occupation | None | |
selfemp_cb | None | |
bal_id | None | |
cand_id | None |
filing_id | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | |||||
---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | |||||
line_item | 1 | 2 | 3 | 4 | 5 | |||||
rec_type | DEBT | DEBT | DEBT | DEBT | DEBT | |||||
form_type | F | F | F | F | F | |||||
tran_id | PAY876 | PAY983 | PAY839 | PAY979 | PAY980 | |||||
entity_cd | OTH | OTH | OTH | IND | IND | |||||
payee_naml | Barclays | Barclays | Political Data, Inc. | Sawyer | Sawyer | |||||
payee_namf | None | None | None | Abigail | Abigail | |||||
payee_namt | None | None | None | None | None | |||||
payee_nams | None | None | None | None | None | |||||
payee_city | San Francisco | San Francisco | Long Beach | San Francisco | San Francisco | |||||
payee_st | CA | CA | CA | CA | CA | |||||
payee_zip4 | 94104 | 94104 | 90806 | 94109 | 94109 | |||||
beg_bal | 513 | 0 | 210 | 2775 | 0 | |||||
amt_incur | 0 | 1263 | 0 | 0 | 225 | |||||
amt_paid | 0 | 0 | 210 | 0 | 0 | |||||
end_bal | 513 | 1263 | 0 | 2775 | 225 | |||||
expn_code | None | None | OFC | None | None | |||||
expn_dscr | Credit Card Payment | Credit Card Payment | None | Administrative Services | Administrative Services | |||||
cmte_id | None | None | None | None | None | |||||
tres_naml | None | None | None | None | None | |||||
tres_namf | None | None | None | None | None | |||||
tres_namt | None | None | None | None | None | |||||
tres_nams | None | None | None | None | None | |||||
tres_city | None | None | None | None | None | |||||
tres_st | None | None | None | None | None | |||||
tres_zip4 | None | None | None | None | None | |||||
memo_code | None | None | None | None | None | |||||
memo_refno | None | None | None | None | None | |||||
bakref_tid | None | None | None | None | None | |||||
xref_schnm | None | None | None | None | None | |||||
xref_match | None | None | None | None | None |
filing_id | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
form_type | D | D | D | E | E | E | E | 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 | ||||||||||||||||||||||||||||||||
tran_id | EXP959 | EXP927 | EXP902 | EXP879 | EXP909 | EXP918 | EXP963 | EXP906 | EXP907 | EXP910 | EXP897 | EXP916 | EXP922 | EXP959 | EXP898 | EXP927 | EXP902 | EXP915 | EXP975 | EXP941 | EXP943 | EXP947 | EXP949 | EXP950 | EXP952 | EXP900 | EDT28 | PDT29 | PDT31 | PDT27 | PDT30 | EDT29 | ||||||||||||||||||||||||||||||||
entity_cd | COM | COM | COM | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | IND | OTH | COM | OTH | COM | COM | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | ||||||||||||||||||||||||||||||||
payee_naml | Esmeralda Soria for Assembly 2022 | Re-Elect Ken Cooley for Assembly 2022 | San Mateo County API Caucus | ActBlue Technical Services | ActBlue Technical Services | ActBlue Technical Services | ActBlue Technical Services | Admail Express, Inc. | Admail Express, Inc. | Bertolina & Barnato, Inc. | Brian Ross Adams dba Trusted Messenger Marketing | Brooks | Deane & Company | Esmeralda Soria for Assembly 2022 | Political Data, Inc. | Re-Elect Ken Cooley for Assembly 2022 | San Mateo County API Caucus | Stripe, Inc. | Stripe, Inc. | Stripe, Inc. | Stripe, Inc. | Stripe, Inc. | Stripe, Inc. | Stripe, Inc. | Stripe, Inc. | Yvonne Stamatakis dba Stella's Cuisine | U.S. Postmaster | Edmond's Plaza Florist | Ella Dining Room and Bar | Jack's Restaurant | Political Data, Inc. | Political Data, Inc. | ||||||||||||||||||||||||||||||||
payee_namf | None | None | None | None | None | None | None | None | None | None | None | Jesse | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||
payee_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
payee_city | Sacramento | Sacramento | Redwood City | Somerville | Somerville | Somerville | Somerville | Hayward | Hayward | Sacramento | Los Angeles | San Francisco | Sacramento | Sacramento | Long Beach | Sacramento | Redwood City | South San Francisco | South San Francisco | South San Francisco | South San Francisco | South San Francisco | South San Francisco | South San Francisco | South San Francisco | San Francisco | Hayward | San Mateo | Sacramento | Pleasant Hill | Long Beach | Long Beach | ||||||||||||||||||||||||||||||||
payee_st | CA | CA | CA | MA | MA | MA | MA | 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 | 95815 | 95841 | 94065 | 02144 | 02144 | 02144 | 02144 | 94544 | 94544 | 95814 | 90067 | 94118 | 95815 | 95815 | 90806 | 95841 | 94065 | 94080 | 94080 | 94080 | 94080 | 94080 | 94080 | 94080 | 94080 | 94124 | 94544 | 94401 | 95814 | 94523 | 90806 | 90806 | ||||||||||||||||||||||||||||||||
expn_date | 2022-10-17 00:00:00 | 2022-10-14 00:00:00 | 2022-10-06 00:00:00 | 2022-09-25 00:00:00 | 2022-09-30 00:00:00 | 2022-10-09 00:00:00 | 2022-10-16 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2022-10-09 00:00:00 | 2022-10-05 00:00:00 | 2022-10-11 00:00:00 | 2022-10-12 00:00:00 | 2022-10-17 00:00:00 | 2022-10-05 00:00:00 | 2022-10-14 00:00:00 | 2022-10-06 00:00:00 | 2022-09-26 00:00:00 | 2022-09-29 00:00:00 | 2022-10-02 00:00:00 | 2022-10-03 00:00:00 | 2022-10-06 00:00:00 | 2022-10-09 00:00:00 | 2022-10-10 00:00:00 | 2022-10-11 00:00:00 | 2022-10-05 00:00:00 | 2022-10-07 00:00:00 | 2022-10-06 00:00:00 | 2022-09-29 00:00:00 | 2022-09-28 00:00:00 | 2022-10-16 00:00:00 | 2022-10-11 00:00:00 | ||||||||||||||||||||||||||||||||
amount | 4900 | 4900 | 300 | 69 | 4 | 16 | 1 | 18505 | 15019 | 3000 | 1300 | 987 | 2939 | 4900 | 210 | 4900 | 300 | 30 | 9750 | 25 | 10 | 45 | 20 | 39 | 5 | 2700 | 18505 | 314 | 568 | 326 | 55 | 987 | ||||||||||||||||||||||||||||||||
cum_ytd | 4900 | 4900 | 750 | 4502 | 4502 | 4502 | 4502 | 188192 | 188192 | 33282 | 52350 | 15403 | 24918 | 4900 | 13896 | 4900 | 750 | 12825 | 12825 | 12825 | 12825 | 12825 | 12825 | 12825 | 12825 | 5800 | 84546 | 314 | 568 | 326 | 13896 | 13896 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
expn_code | MON | MON | MON | OFC | OFC | OFC | OFC | POS | LIT | FND | None | OFC | PRO | CTB | OFC | CTB | CTB | OFC | OFC | OFC | OFC | OFC | OFC | OFC | OFC | FND | POS | OFC | FND | FND | OFC | OFC | ||||||||||||||||||||||||||||||||
expn_dscr | None | None | None | None | None | None | None | None | None | None | Social Media Marketing Management | None | None | None | None | None | None | None | Disputed | None | None | None | None | None | None | None | None | 10/6/22, Thank You Flowers, 1, Suzanne Roche | Appetizers Only | Appetizers Only | None | None | ||||||||||||||||||||||||||||||||
agent_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Admail Express, Inc. | Barclays | Barclays | Barclays | Barclays | Brooks | ||||||||||||||||||||||||||||||||
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 | Jesse | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
cmte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | 1443835 | None | 1435371 | 1417433 | 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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
cand_naml | Esmeralda Soria | Ken Cooley | None | None | None | None | None | None | 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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
office_cd | ASM | ASM | None | None | None | None | None | None | 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 | ||||||||||||||||||||||||||||||||
juris_cd | ASM | ASM | None | None | None | None | None | None | 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 | ||||||||||||||||||||||||||||||||
dist_no | 27 | 8 | None | None | None | None | None | None | 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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
sup_opp_cd | 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 | 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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
g_from_e_f | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | E | F | F | F | F | 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 | ||||||||||||||||||||||||||||||||
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 |
filer_id | 1442617 | |
---|---|---|
filing_id | 2744175 | |
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-25 00:00:00 | |
filing_type | 22001 |
filing_id | 2744175 | |
---|---|---|
filing_type | 22001 |
filing_id | 2744175 | |
---|---|---|
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 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | I | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tran_id | INC967 | INC890 | INC974 | INC880 | INC875 | INC913 | IDT289 | INC888 | INC891 | INC937 | INC970 | INC972 | INC881 | INC953 | INC892 | INC925 | INC968 | INC921 | INC920 | INC954 | INC955 | INC923 | INC957 | IDT295 | INC874 | INC930 | INC960 | INC944 | INC977 | INC969 | INC904 | INC978 | INC882 | INC911 | INC901 | INC914 | INC885 | INC951 | INC948 | INC934 | INC905 | INC938 | INC883 | INC919 | IDT297 | INC964 | INC924 | INC958 | INC893 | INC939 | INC889 | INC903 | INC884 | INC931 | INC935 | INC940 | INC896 | INC942 | INC936 | INC945 | INC886 | INC956 | IDT298 | INC928 | INC973 | INC887 | INC933 | INC976 | INC912 | INC971 | INC929 | INC894 | INC926 | IDT290 | INC895 | IDT291 | INC946 | INC932 | INC961 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
entity_cd | OTH | COM | OTH | COM | OTH | OTH | IND | OTH | OTH | IND | COM | SCC | SCC | COM | COM | COM | COM | COM | SCC | COM | SCC | SCC | SCC | OTH | COM | IND | COM | IND | OTH | COM | OTH | COM | OTH | COM | IND | COM | COM | IND | IND | IND | IND | IND | IND | COM | IND | COM | OTH | SCC | SCC | IND | SCC | IND | COM | COM | IND | IND | COM | IND | IND | IND | SCC | SCC | IND | IND | COM | OTH | IND | COM | COM | COM | IND | SCC | OTH | IND | COM | IND | IND | IND | OTH | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_naml | 1-800 Contacts, Inc. | 21st Century Alliance Good Government PAC | Agua Caliente Band of Cahuilla Indians | American Property Casualty Insurance Association California PAC | Anheuser Busch Companies | Artichoke Joe's, Inc. | Ashroff | AstraZeneca Pharmaceuticals, LP/ Zeneca, Inc. | AT&T Services Inc. and its Affiliates | Buchwald | California Academy of Eye Physicians & Surgeons PAC | California Association of Highway Patrolmen PAC Small Contributor Committee | California Association of Professional Scientists (CAPS PAC) Small Contributor Committee | California Cattlemen's Association PAC (CATTLE-PAC) | California Defense Counsel PAC | California Farm Bureau Fund to Protect the Family Farm (FARM PAC) | California Hospital Association PAC Sponsored by California Association of Hospitals and Health System | California New Car Dealers Association PAC | California Professional Firefighters PAC Small Contributor Committee | California Seed Association PAC | California State Association of Electrical Workers Small Contributor Committee | California State Council of Laborers PAC Small Contributor Committee | California State Pipe Trades Council PAC Small Contributor Committee | California Water Service (Cal Water) | Californians Allied for Patient Protection PAC | Canzian | Consumer Attorneys of California PAC | Derwin | Edison International and Affiliated Entities | FairPAC, Sponsored by the Civil Justice Association of California | Flux-Tronics Communications, Inc. | Ford Motor Company Civic Action Fund (FEC ID# C00046474) | Genentech USA | General Motors Company PAC (FED PAC ID C00076810) | Griffin | International Brotherhood of Electrical Workers (IBEW) Local Union No. 617 PAC | Jim Wood for Assembly 2022 | Johnson | Josefowitz | Kimura | Lam | Lewis | Majer | Milk Producers Council PAC | Miller | National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy | NextEra Energy Resources Development, LLC | Operating Engineers Local No. 3 Statewide PAC Small Contributor Committee | Peace Officers Research Association of California PAC - Small Contributor Committee | Peterson | Professional Engineers in California Government (PECG-PAC) PAC Small Contributor Committee | Ram | Resource Recovery Coalition of California PAC | Reuben Holober for City Council 2018 | Rosas | Rowinski | San Francisco Laborer's Local 261 PAC | Scarabosio | Sell | Selman | Service Employees International Union United Healthcare Workers West (SEIU) PAC Small Contributor Committee | Southern California Pipe Trades District Council #16 PAC Small Contributor Committee | Spanos | Stamatakis | State Coalition of Probation Organizations PAC | Sysco Corporation | Taylor | The California Women's List | The Caterpillar Employee PAC (FEC ID C00148031) | The Hartford Financial Services GRP, Inc. PAC (AKA The Hartford Advocates Fund) (Fed PAC ID#C00168864) | Tom | UFCW Western States Council Candidate PAC - Small Contributor Committee | Universal Music Group, Inc. O/B/O Uni Music Investments, Inc. | Van Rensselaer | Western United Dairies PAC | Wolff | Zografos | Zou | Employment Development Department (EDD) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_namf | None | None | None | None | None | None | Mohamed | None | None | Gerald J. | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Sheila A. | None | Maryann Moise | None | None | None | None | None | None | Ralph A. | None | None | Jennifer | Nicholas | Kathleen M. | Alex | Elizabeth A. | Sol C. | None | Jennifer | None | None | None | None | Don | None | Jagdev | None | None | Joan Patricia | Susan | None | Raymond | James E. | Jeffrey | None | None | George | Yvonne | None | None | Margaret A. | None | None | None | Maeley | None | None | Janelle | None | Jonathan | Anastasios (Taso) | Qinghong | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_city | Draper | Oakland | Palm Springs | Chicago | St. Louis | San Bruno | Millbrae | Wilmington | Sacramento | Hillsborough | San Francisco | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Pasadena | Sacramento | Sacramento | San Jose | Sacramento | San Mateo | Sacramento | Portola Valley | Sacramento | Sacramento | Hayward | Dearborn | South San Francisco | Washington | San Mateo | San Mateo | Sacramento | Burlingame | San Francisco | Millbrae | Millbrae | Atherton | Los Angeles | Ontario | San Mateo | Sacramento | Juno Beach | Alameda | Sacramento | Los Gatos | Sacramento | San Bruno | Sacramento | Millbrae | San Mateo | San Mateo | San Francisco | Millbrae | San Mateo | Belmont | Los Angeles | Los Angeles | Walnut Creek | San Bruno | Sacramento | Houston | San Mateo | Oakland | Deerfield | Hartford | San Francisco | Buena Park | Woodland Hills | Burlingame | Turlock | Lafayette | San Mateo | Sunnyvale | Sacramento | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_st | UT | CA | CA | IL | MO | CA | CA | DE | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | MI | CA | DC | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | FL | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | TX | CA | CA | IL | CT | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_zip4 | 84020 | 94607 | 92264 | 60631 | 63118 | 94066 | 94030 | 19850 | 95814 | 94010 | 94131 | 95818 | 95814 | 95814 | 95814 | 95833 | 95814 | 95814 | 95833 | 95814 | 91101 | 95814 | 95814 | 95112 | 95814 | 94402 | 95814 | 94028 | 95814 | 95815 | 94541 | 48126 | 94080 | 20001 | 94403 | 94402 | 95815 | 94010 | 94115 | 94030 | 94030 | 94027 | 90036 | 91762 | 94402 | 95815 | 33408 | 94502 | 95834 | 95032 | 95814 | 94066 | 95814 | 94030 | 94403 | 94403 | 94110 | 94030 | 94402 | 94002 | 90017 | 90020 | 94595 | 94066 | 95826 | 77077 | 94402 | 94607 | 60015 | 06115 | 95831 | 90620 | 91367 | 94010 | 95380 | 94549 | 94402 | 94085 | 95814 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_emp | None | None | None | None | None | None | n/a | None | None | City of San Mateo | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | City of San Mateo | None | Town of Portola Valley | None | None | None | None | None | None | Jafec USA, Inc. | None | None | 454Marketing | SPUR | n/a | LF George Properties Corporation | Orchard Commercial, Inc. | Pasadena Park Healthcare | None | n/a | None | None | None | None | Prometheus | None | Jagdev Ram | None | None | n/a | Sue Rowinski Group, LLC | None | Jackson Group Property Management, Inc. | Partner | DLA Piper, LLP | None | None | Judicial Council of California | Stella's Cuisine | None | None | n/a | None | None | None | n/a | None | None | n/a | None | California Department of Justice | ZDEVCO | n/a | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_occ | None | None | None | None | None | None | Not Employed | None | None | Judge | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Director of Parks and Recreation | None | Town Council Member | None | None | None | None | None | None | Vice President | None | None | Consultant | Executive | Retired | Manager | Commercial Real Estate | Chief Executive Officer | None | Not Employed | None | None | None | None | Senior Vice President of Development | None | Real Estate | None | None | Not Employed | President & Chief Executive Officer | None | Real Estate Management | Tyson & Mendes | Attorney | None | None | Assigned Judge | Owner | None | None | Retired | None | None | None | Retired | None | None | Not Employed | None | Attorney | Chief Executive Officer | Not Employed | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tran_type | None | None | None | None | None | None | I | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | I | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | I | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | I | None | None | None | None | None | None | None | None | None | None | I | None | I | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rcpt_date | 2022-10-19 00:00:00 | 2022-09-30 00:00:00 | 2022-10-20 00:00:00 | 2022-09-28 00:00:00 | 2022-09-26 00:00:00 | 2022-10-07 00:00:00 | 2022-09-29 00:00:00 | 2022-09-29 00:00:00 | 2022-10-03 00:00:00 | 2022-10-07 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 00:00:00 | 2022-09-28 00:00:00 | 2022-10-14 00:00:00 | 2022-10-03 00:00:00 | 2022-10-13 00:00:00 | 2022-10-19 00:00:00 | 2022-10-11 00:00:00 | 2022-10-11 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-13 00:00:00 | 2022-10-14 00:00:00 | 2022-10-18 00:00:00 | 2022-09-26 00:00:00 | 2022-10-07 00:00:00 | 2022-10-17 00:00:00 | 2022-10-05 00:00:00 | 2022-10-21 00:00:00 | 2022-10-20 00:00:00 | 2022-10-06 00:00:00 | 2022-10-21 00:00:00 | 2022-09-28 00:00:00 | 2022-10-07 00:00:00 | 2022-09-30 00:00:00 | 2022-10-09 00:00:00 | 2022-09-29 00:00:00 | 2022-10-10 00:00:00 | 2022-10-05 00:00:00 | 2022-10-07 00:00:00 | 2022-10-06 00:00:00 | 2022-10-07 00:00:00 | 2022-09-28 00:00:00 | 2022-10-11 00:00:00 | 2022-10-22 00:00:00 | 2022-10-18 00:00:00 | 2022-10-13 00:00:00 | 2022-10-14 00:00:00 | 2022-10-03 00:00:00 | 2022-09-30 00:00:00 | 2022-09-30 00:00:00 | 2022-10-06 00:00:00 | 2022-09-29 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2022-09-30 00:00:00 | 2022-10-04 00:00:00 | 2022-10-02 00:00:00 | 2022-10-07 00:00:00 | 2022-10-05 00:00:00 | 2022-09-29 00:00:00 | 2022-10-14 00:00:00 | 2022-10-18 00:00:00 | 2022-10-07 00:00:00 | 2022-10-20 00:00:00 | 2022-09-29 00:00:00 | 2022-10-07 00:00:00 | 2022-10-21 00:00:00 | 2022-10-07 00:00:00 | 2022-10-20 00:00:00 | 2022-10-07 00:00:00 | 2022-10-03 00:00:00 | 2022-10-13 00:00:00 | 2022-10-03 00:00:00 | 2022-10-03 00:00:00 | 2022-10-04 00:00:00 | 2022-10-05 00:00:00 | 2022-10-07 00:00:00 | 2022-10-14 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
amount | 1000 | 1500 | 1500 | 2500 | 2000 | 1000 | 100 | 2500 | 1500 | 850 | 2000 | 2500 | 1500 | 2500 | 1000 | 1500 | 2000 | 2000 | 1000 | 1500 | 7500 | 4900 | 5000 | 2500 | 1000 | 250 | 4900 | 125 | 4900 | 1500 | 1500 | 1200 | 4900 | 1500 | 300 | 4900 | 4900 | 125 | 500 | 200 | 3000 | 200 | 2500 | 2000 | 50 | 2500 | 1500 | 4900 | 2000 | 500 | 1500 | 1000 | 4900 | 125 | 500 | 125 | 4900 | 250 | 200 | 500 | 2000 | 5000 | 100 | 125 | 1000 | 2000 | 500 | 500 | 1500 | 1000 | 250 | 2500 | 1000 | 200 | 2500 | 100 | 500 | 125 | 226 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cum_ytd | 1000 | 3000 | 1500 | 4500 | 6900 | 4000 | 100 | 2500 | 1500 | 1400 | 5000 | 12200 | 1500 | 2500 | 1000 | 1500 | 2000 | 2000 | 10700 | 1500 | 7500 | 4900 | 5000 | 2500 | 1000 | 250 | 9800 | 125 | 4900 | 1500 | 1500 | 1200 | 7400 | 1500 | 300 | 9800 | 4900 | 1125 | 500 | 300 | 3000 | 2200 | 2500 | 2000 | 150 | 2500 | 1500 | 9800 | 2000 | 2500 | 1500 | 1000 | 4900 | 125 | 750 | 325 | 4900 | 250 | 200 | 500 | 2000 | 5000 | 200 | 125 | 1000 | 6900 | 1250 | 1000 | 1500 | 1000 | 250 | 2500 | 1000 | 200 | 2500 | 100 | 1000 | 125 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | Refund | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cmte_id | None | 1439959 | None | 830078 | None | None | None | None | None | None | 980331 | 802001 | 860894 | 760980 | 850665 | 760960 | 790773 | 741623 | 744058 | 970787 | 743107 | 902770 | 743895 | None | 920780 | None | 760231 | None | None | 1311499 | None | 761070 | None | 790461 | None | 990208 | 1434721 | None | None | None | None | None | None | 744692 | None | 13818200 | None | 981697 | 810830 | None | 822501 | None | 923445 | 1359615 | None | None | 981076 | None | None | None | 747285 | 760715 | None | None | 911856 | None | None | 1379150 | 1307878 | 930174 | None | 910874 | None | None | 771500 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
intr_naml | None | None | None | None | None | None | ActBlue | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ActBlue | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ActBlue | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ActBlue | None | None | None | None | None | None | None | None | None | None | ActBlue | None | ActBlue | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
intr_city | None | None | None | None | None | None | Somerville | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Somerville | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Somerville | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Somerville | None | None | None | None | None | None | None | None | None | None | Somerville | None | Somerville | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
intr_st | None | None | None | None | None | None | MA | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | MA | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | MA | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | MA | None | None | None | None | None | None | None | None | None | None | MA | None | MA | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
intr_zip4 | None | None | None | None | None | None | 02144 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 02144 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 02144 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 02144 | None | None | None | None | None | None | None | None | None | None | 02144 | None | 02144 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | INC924 | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 |
filing_id | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | |||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||||||||||||||||
line_item | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 22A | 22B | 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 | SMRY | SMRY | |||||||||||||||||||||||||||||||||||||||||||||||
form_type | F460 | F460 | 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 | 138770 | 0 | 138770 | 0 | 138770 | 64775 | 0 | 64775 | 1278 | 0 | 66052 | 259367 | 138770 | 226 | 64775 | 333588 | 0 | 0 | 4775 | 147474 | 512259 | 138600 | 170 | 138770 | 0 | 0 | 0 | 0 | 0 | 0 | 10100 | 0 | 10100 | 64775 | 0 | 0 | 64775 | 1488 | 210 | 1278 | 0 | 0 | 0 | 226 | 0 | 0 | 226 | |||||||||||||||||||||||||||||||||||||||||||||||
amount_b | 908821 | 0 | 908821 | 2372 | 911193 | 701268 | 0 | 701268 | 4775 | 2372 | 708416 | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | |||||||||||||||||||||||||||||||||||||||||||||||
elec_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | None | None | 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 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | 2744175 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | D | D | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ptran_id | INC967 | INC890 | INC890 | INC974 | INC880 | INC880 | INC875 | INC875 | INC913 | INC913 | IDT289 | INC888 | INC891 | INC937 | INC937 | INC970 | INC970 | INC972 | INC972 | INC881 | INC953 | INC892 | INC925 | INC968 | INC921 | INC920 | INC920 | INC954 | INC955 | INC923 | INC957 | IDT295 | INC874 | INC930 | INC960 | INC960 | INC944 | INC977 | INC969 | INC904 | INC978 | INC882 | INC882 | INC911 | INC901 | INC914 | INC914 | INC885 | INC951 | INC951 | INC948 | INC934 | INC934 | INC905 | INC938 | INC938 | INC883 | INC919 | IDT297 | IDT297 | INC964 | INC924 | INC958 | INC958 | INC893 | INC939 | INC889 | INC903 | INC884 | INC931 | INC935 | INC935 | INC940 | INC940 | INC896 | INC896 | INC942 | INC936 | INC945 | INC886 | INC956 | IDT298 | IDT298 | INC928 | INC973 | INC887 | INC887 | INC933 | INC933 | INC976 | INC912 | INC971 | INC929 | INC929 | INC894 | INC926 | IDT290 | INC895 | IDT291 | INC946 | INC946 | INC932 | EXP959 | EXP927 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
elec_amount | 1000 | 1500 | 1500 | 1500 | 2000 | 2500 | 4900 | 2000 | 3000 | 1000 | 100 | 2500 | 1500 | 550 | 850 | 3000 | 2000 | 9700 | 2500 | 1500 | 2500 | 1000 | 1500 | 2000 | 2000 | 9700 | 1000 | 1500 | 7500 | 4900 | 5000 | 2500 | 1000 | 250 | 4900 | 4900 | 125 | 4900 | 1500 | 1500 | 1200 | 2500 | 4900 | 1500 | 300 | 4900 | 4900 | 4900 | 1000 | 125 | 500 | 100 | 200 | 3000 | 1000 | 1200 | 2500 | 2000 | 150 | 50 | 2500 | 1500 | 4900 | 4900 | 2000 | 2500 | 1500 | 1000 | 4900 | 125 | 500 | 500 | 100 | 225 | 500 | 4900 | 250 | 200 | 500 | 2000 | 5000 | 100 | 100 | 125 | 1000 | 4900 | 2000 | 1250 | 500 | 1000 | 1500 | 1000 | 100 | 250 | 2500 | 1000 | 200 | 2500 | 100 | 500 | 500 | 125 | 4900 | 4900 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
elec_code | G | P | G | G | P | G | P | G | P | G | G | G | G | P | G | P | G | P | G | G | G | G | G | G | G | P | G | G | G | G | G | G | G | G | P | G | G | G | G | G | G | P | G | G | G | P | G | G | P | G | G | P | G | G | P | G | G | G | P | G | G | G | P | G | G | G | G | G | G | G | P | G | P | G | P | G | G | G | G | G | G | P | G | G | G | P | G | P | G | G | G | G | P | G | G | G | G | G | G | P | G | G | G | G |