PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2740000&amendid=1
filing_id | 2740000 | 2740000 | 2740000 | 2740000 | ||||
---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 1 | 1 | ||||
line_item | 1 | 2 | 1 | 2 | ||||
rec_type | CVR2 | CVR2 | CVR2 | CVR2 | ||||
form_type | F460 | F460 | F460 | F460 | ||||
tran_id | 1 | 2 | 1 | 2 | ||||
entity_cd | ATR | CAO | ATR | CAO | ||||
title | None | None | None | None | ||||
mail_city | None | None | None | None | ||||
mail_st | None | None | None | None | ||||
mail_zip4 | None | None | None | None | ||||
f460_part | 3 | 5A | 3 | 5A | ||||
cmte_id | None | None | None | None | ||||
enty_naml | Brenner | Berman | Brenner | Berman | ||||
enty_namf | Julie | Marc | Julie | Marc | ||||
enty_namt | None | None | None | None | ||||
enty_nams | None | None | None | None | ||||
enty_city | Menlo Park | Sacramento | Menlo Park | Sacramento | ||||
enty_st | CA | CA | CA | CA | ||||
enty_zip4 | 94025 | 95814 | 94025 | 95814 | ||||
enty_phon | 6502088000 | None | 6502088000 | None | ||||
enty_fax | None | None | None | None | ||||
enty_email | [email protected] | None | [email protected] | None | ||||
tres_naml | None | None | None | None | ||||
tres_namf | None | None | None | None | ||||
tres_namt | None | None | None | None | ||||
tres_nams | None | None | None | None | ||||
control_yn | N | N | N | N | ||||
office_cd | None | ASM | None | ASM | ||||
offic_dscr | None | None | None | None | ||||
juris_cd | None | ASM | None | ASM | ||||
juris_dscr | None | None | None | None | ||||
dist_no | None | 23 | None | 23 | ||||
off_s_h_cd | None | None | None | None | ||||
bal_name | None | None | None | None | ||||
bal_num | None | None | None | None | ||||
bal_juris | None | None | None | None | ||||
sup_opp_cd | None | None | None | None |
filing_id | 2740000 | 2740000 | 2740000 | 2740000 | ||||
---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 1 | 1 | ||||
line_item | 1 | 2 | 1 | 2 | ||||
rec_type | CVR3 | CVR3 | CVR3 | CVR3 | ||||
form_type | F460 | F460 | F460 | F460 | ||||
tran_id | 87 | 88 | 90 | 91 | ||||
entity_cd | ATR | CAO | ATR | CAO | ||||
sig_date | 2022-10-24 00:00:00 | 2022-10-24 00:00:00 | 2022-11-12 00:00:00 | 2022-11-12 00:00:00 | ||||
sig_loc | None | None | None | None | ||||
sig_naml | Brenner | Berman | Brenner | Berman | ||||
sig_namf | Julie | Marc | Julie | Marc | ||||
sig_namt | None | None | None | None | ||||
sig_nams | None | None | None | None |
filing_id | 2740000 | 2740000 | ||
---|---|---|---|---|
amend_id | 0 | 1 | ||
rec_type | CVR | CVR | ||
form_type | F460 | F460 | ||
filer_id | 1435363 | 1435363 | ||
entity_cd | RCP | RCP | ||
filer_naml | BERMAN FOR ASSEMBLY 2022; MARC | BERMAN FOR ASSEMBLY 2022; MARC | ||
filer_namf | None | None | ||
filer_namt | None | None | ||
filer_nams | None | None | ||
report_num | 000 | 001 | ||
rpt_date | 2022-10-24 00:00:00 | 2022-11-12 00:00:00 | ||
stmt_type | PE | PE | ||
late_rptno | None | None | ||
from_date | 2022-09-25 00:00:00 | 2022-09-25 00:00:00 | ||
thru_date | 2022-10-22 00:00:00 | 2022-10-22 00:00:00 | ||
elect_date | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | ||
filer_city | SACRAMENTO | SACRAMENTO | ||
filer_st | CA | CA | ||
filer_zip4 | 95814 | 95814 | ||
filer_phon | 6502088000 | 6502088000 | ||
filer_fax | None | None | ||
file_email | [email protected] | [email protected] | ||
mail_city | MENLO PARK | MENLO PARK | ||
mail_st | CA | CA | ||
mail_zip4 | 940267176 | 940267176 | ||
tres_naml | Berman | Berman | ||
tres_namf | Marc | Marc | ||
tres_namt | None | None | ||
tres_nams | None | None | ||
tres_city | Sacramento | Sacramento | ||
tres_st | CA | CA | ||
tres_zip4 | 95814 | 95814 | ||
tres_phon | 6502088000 | 6502088000 | ||
tres_fax | None | None | ||
tres_email | None | None | ||
cmtte_type | C | C | ||
control_yn | Y | Y | ||
sponsor_yn | N | N | ||
primfrm_yn | None | None | ||
brdbase_yn | None | None | ||
amendexp_1 | None | Update Schedule A. | ||
amendexp_2 | None | None | ||
amendexp_3 | None | None | ||
rpt_att_cb | None | None | ||
cmtte_id | None | None | ||
reportname | None | None | ||
rptfromdt | None | None | ||
rptthrudt | None | None | ||
emplbus_cb | None | None | ||
bus_name | None | None | ||
bus_city | None | None | ||
bus_st | None | None | ||
bus_zip4 | None | None | ||
bus_inter | None | None | ||
busact_cb | None | None | ||
busactvity | None | None | ||
assoc_cb | None | None | ||
assoc_int | None | None | ||
other_cb | None | None | ||
other_int | None | None | ||
cand_naml | Berman | Berman | ||
cand_namf | Marc | Marc | ||
cand_namt | None | None | ||
cand_nams | None | None | ||
cand_city | Sacramento | Sacramento | ||
cand_st | CA | CA | ||
cand_zip4 | 95814 | 95814 | ||
cand_phon | None | None | ||
cand_fax | None | None | ||
cand_email | None | None | ||
bal_name | None | None | ||
bal_num | None | None | ||
bal_juris | None | None | ||
office_cd | ASM | ASM | ||
offic_dscr | None | None | ||
juris_cd | ASM | ASM | ||
juris_dscr | None | None | ||
dist_no | 23 | 23 | ||
off_s_h_cd | None | None | ||
sup_opp_cd | None | None | ||
employer | None | None | ||
occupation | None | None | ||
selfemp_cb | None | None | ||
bal_id | None | None | ||
cand_id | None | None |
filing_id | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | E | E | E | E | E | E | E | E | E | E | E | E | E | E | E | E | E | E | E | E | E | E | 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 | E | E | E | E | E | E | E | E | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tran_id | 58 | 59 | 60 | 61 | 62 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 63 | 64 | 65 | 66 | 67 | 84 | 85 | 86 | 58 | 59 | 60 | 61 | 62 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 63 | 64 | 65 | 66 | 67 | 84 | 85 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
entity_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
payee_naml | None | None | None | None | None | None | None | None | None | None | None | None | Truman National Security Project | LaSalle | Brenner | Brenner | Bertolina & Barnato, Inc. | Charles Stone for San Mateo County Board of Supervisors 2022 | Democrats for Israel California | Cantrell | Sturken | Yebri | California Democratic Party | Democratic Leadership Coalition PAC | San Mateo County Community Colleges Foundation | Stripe | Menlo Park Neighbors for Affordable Homes | Forssell | Southwest Airlines | Garcia | Comcast | United Airlines | American Airlines | Californians Building Bridges | None | None | None | None | None | None | None | None | None | None | None | None | Truman National Security Project | LaSalle | Brenner | Brenner | Bertolina & Barnato, Inc. | Charles Stone for San Mateo County Board of Supervisors 2022 | Democrats for Israel California | Cantrell | Sturken | Yebri | California Democratic Party | Democratic Leadership Coalition PAC | San Mateo County Community Colleges Foundation | Stripe | Menlo Park Neighbors for Affordable Homes | Forssell | Southwest Airlines | Garcia | Comcast | United Airlines | American Airlines | Californians Building Bridges | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
payee_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | Isabelle | Julie | Julie | None | None | None | Chuck | Chris | Sam | None | None | None | None | None | Lisa | None | Leticia | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Isabelle | Julie | Julie | None | None | None | Chuck | Chris | Sam | None | None | None | None | None | Lisa | None | Leticia | 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 | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
payee_city | None | None | None | None | None | None | None | None | None | None | None | None | Washington | Sacramento | Menlo Park | Menlo Park | Sacramento | Belmont | Norwalk | San Jose | Redwood City | Encino | Sacramento | Sacramento | San Mateo | San Francisco | Sacramento | Palo Alto | Dallas | Sacramento | Philadelphia | Chicago | Fort Worth | Sacramento | None | None | None | None | None | None | None | None | None | None | None | None | Washington | Sacramento | Menlo Park | Menlo Park | Sacramento | Belmont | Norwalk | San Jose | Redwood City | Encino | Sacramento | Sacramento | San Mateo | San Francisco | Sacramento | Palo Alto | Dallas | Sacramento | Philadelphia | Chicago | Fort Worth | Sacramento | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
payee_st | None | None | None | None | None | None | None | None | None | None | None | None | DC | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | TX | CA | PA | IL | TX | CA | None | None | None | None | None | None | None | None | None | None | None | None | DC | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | TX | CA | PA | IL | TX | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
payee_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | 20005 | 95864 | 94025 | 94025 | 95814 | 94002 | 90650 | 95125 | 94063 | 91436 | 95811 | 95815 | 94402 | 94103 | 95814 | 94301 | 75235 | 95841 | 19103 | 60606 | 76155 | 95814 | None | None | None | None | None | None | None | None | None | None | None | None | 20005 | 95864 | 94025 | 94025 | 95814 | 94002 | 90650 | 95125 | 94063 | 91436 | 95811 | 95815 | 94402 | 94103 | 95814 | 94301 | 75235 | 95841 | 19103 | 60606 | 76155 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
expn_date | 2022-10-10 00:00:00 | 2022-10-10 00:00:00 | 2022-10-10 00:00:00 | 2022-10-10 00:00:00 | 2022-10-10 00:00:00 | 2022-10-10 00:00:00 | 2022-10-11 00:00:00 | 2022-10-11 00:00:00 | 2022-10-19 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 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 | 2022-10-10 00:00:00 | 2022-10-10 00:00:00 | 2022-10-10 00:00:00 | 2022-10-10 00:00:00 | 2022-10-10 00:00:00 | 2022-10-10 00:00:00 | 2022-10-11 00:00:00 | 2022-10-11 00:00:00 | 2022-10-19 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
amount | 500 | 250 | 100 | 500 | 250 | 1000 | 800 | 20000 | 500 | 20000 | 5000 | 20000 | 250 | 156 | 28 | 3081 | 2500 | 500 | 500 | 250 | 100 | 800 | 45000 | 20000 | 100 | 225 | 1000 | 250 | 516 | 500 | 236 | 802 | 1037 | 7890 | 500 | 250 | 100 | 500 | 250 | 1000 | 800 | 20000 | 500 | 20000 | 5000 | 20000 | 250 | 156 | 28 | 3081 | 2500 | 500 | 500 | 250 | 100 | 800 | 45000 | 20000 | 100 | 225 | 1000 | 250 | 516 | 500 | 236 | 802 | 1037 | 7890 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cum_ytd | 500 | 750 | 100 | 500 | 250 | 1000 | 800 | 144200 | 500 | 20000 | 149200 | 169200 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 500 | 750 | 100 | 500 | 250 | 1000 | 800 | 144200 | 500 | 20000 | 149200 | 169200 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | 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 | MON | MON | MON | MON | CVC | MTG | POS | PRO | CNS | CTB | CTB | CTB | CTB | CTB | CTB | CTB | CVC | FND | CTB | CTB | FND | CTB | OFC | None | None | None | MON | MON | MON | MON | MON | MON | MON | MON | MON | MON | MON | MON | CVC | MTG | POS | PRO | CNS | CTB | CTB | CTB | CTB | CTB | CTB | CTB | CVC | FND | CTB | CTB | FND | CTB | OFC | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
expn_dscr | None | None | None | None | None | None | None | None | None | None | None | None | None | reimbursement: supplies Mt. View Health Fair | reimbursement: postage | None | None | None | None | None | None | None | None | None | None | credit card donation fees | None | None | fundraising event in Los Angeles | None | None | $401.15 each: Candidate Travel & Spouse Travel | $518.60 each: Candidate Travel & Spouse Travel | $3945.00 each: Candidate Travel & Spouse Travel | None | None | None | None | None | None | None | None | None | None | None | None | None | reimbursement: supplies Mt. View Health Fair | reimbursement: postage | None | None | None | None | None | None | None | None | None | None | credit card donation fees | None | None | fundraising event in Los Angeles | None | None | $401.15 each: Candidate Travel & Spouse Travel | $518.60 each: Candidate Travel & Spouse Travel | $3945.00 each: Candidate Travel & Spouse Travel | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | 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 | None | None | None | None | None | 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 | 1416286 | 1342901 | 1449174 | 1451623 | 1449136 | 741666 | 1449276 | None | None | 1450186 | 1447743 | None | 1445674 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 1416286 | 1342901 | 1449174 | 1451623 | 1449136 | 741666 | 1449276 | None | None | 1450186 | 1447743 | None | 1445674 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cand_naml | Stone | Cantrell | Sturken | Democrats for Israel California | Forssell | Menlo Park Neighbors for Affordable Homes | Yebri | California Democratic Party | Garcia | Democratic Leadership Coalition PAC | California Democratic Party | California Democratic Party | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Stone | Cantrell | Sturken | Democrats for Israel California | Forssell | Menlo Park Neighbors for Affordable Homes | Yebri | California Democratic Party | Garcia | Democratic Leadership Coalition PAC | California Democratic Party | California Democratic Party | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cand_namf | Charles | Chuck | Chris | None | Lisa | None | Sam | None | Leticia | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Charles | Chuck | Chris | None | Lisa | None | Sam | None | Leticia | None | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
office_cd | OTH | OTH | OTH | None | OTH | None | OTH | None | 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 | OTH | OTH | OTH | None | OTH | None | OTH | None | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
offic_dscr | Board of Supervisors | Water Board | City Council | None | City Council | None | City Council | None | School Board | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Board of Supervisors | Water Board | City Council | None | City Council | None | City Council | None | School Board | None | 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 | CTY | CTY | CIT | None | CIT | None | CIT | None | 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 | CTY | CTY | CIT | None | CIT | None | CIT | None | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
juris_dscr | San Mateo County - District 2 | Santa Clara County | Redwood City | None | Palo Alto | None | Los Angeles | None | Sacramento | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | San Mateo County - District 2 | Santa Clara County | Redwood City | None | Palo Alto | None | Los Angeles | None | Sacramento | None | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sup_opp_cd | 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
memo_refno | 58 | 59 | 60 | 61 | 62 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 63 | 64 | 65 | 66 | 67 | 84 | 85 | 86 | None | None | None | None | None | None | None | None | None | None | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 |
filer_id | 1435363 | 1435363 | ||
---|---|---|---|---|
filing_id | 2740000 | 2740000 | ||
period_id | 251 | 251 | ||
form_id | F460 | F460 | ||
filing_sequence | 0 | 1 | ||
filing_date | 2022-10-24 00:00:00 | 2022-11-12 00:00:00 | ||
stmnt_type | 10001 | 10002 | ||
stmnt_status | 11003 | 11003 | ||
session_id | 2021 | 2021 | ||
user_id | CAFILER | CAFILER | ||
special_audit | 11003 | 11003 | ||
fine_audit | 11003 | 11003 | ||
rpt_start | 2022-09-25 00:00:00 | 2022-09-25 00:00:00 | ||
rpt_end | 2022-10-22 00:00:00 | 2022-10-22 00:00:00 | ||
rpt_date | 2022-10-24 00:00:00 | 2022-11-12 00:00:00 | ||
filing_type | 22006 | 22006 |
filing_id | 2740000 | |
---|---|---|
filing_type | 22001 |
filing_id | 2740000 | 2740000 | ||
---|---|---|---|---|
amend_id | 0 | 1 | ||
rec_type | HDR | HDR | ||
ef_type | CAL | CAL | ||
state_cd | CA | CA | ||
cal_ver | 2.01 | 2.01 | ||
soft_name | CAL-ACCESS OBJECT MODEL | CAL-ACCESS OBJECT MODEL | ||
soft_ver | 1.00 | 1.00 | ||
hdrcomment | None | None |
filing_id | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tran_id | 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 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 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 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 89 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
entity_cd | RCP | RCP | RCP | OTH | RCP | OTH | RCP | SCC | OTH | RCP | SCC | OTH | RCP | OTH | OTH | OTH | OTH | OTH | OTH | SCC | OTH | OTH | IND | RCP | OTH | SCC | SCC | IND | RCP | SCC | RCP | RCP | RCP | OTH | OTH | IND | IND | IND | IND | IND | RCP | IND | IND | IND | RCP | SCC | IND | IND | IND | IND | RCP | RCP | RCP | OTH | RCP | OTH | RCP | SCC | OTH | RCP | SCC | OTH | RCP | OTH | OTH | OTH | OTH | OTH | OTH | SCC | OTH | OTH | IND | RCP | OTH | SCC | SCC | IND | RCP | SCC | RCP | RCP | RCP | OTH | OTH | IND | IND | IND | IND | IND | RCP | IND | IND | IND | RCP | SCC | IND | IND | IND | IND | IND | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_naml | California Defense Counsel PAC | AIACC Architects for Livable Communities PAC | California Cable & Telecommunications Association PAC | Anheuser Busch Companies | General Motors Company PAC | The Dentists Insurance Company | Cummins Inc. PAC | Northern California Carpenters Regional Council | Sysco Corporation | 21st Century Alliance Good Government PAC | Cal Fire Local 2881 Small Contributor PAC | Deloitte Services LP | California New Car Dealers Association PAC | Agua Caliente Band of Cahuilla Indians | AmerisourceBergen | Paramount Pictures | Aya Healthcare, Inc. | Amazon.com Services LLC | Pechanga Band of Indians | Operating Engineers Local No. 3 Statewide PAC | Zuffa, LLC (dba UFC) | Ring Central, Inc. | Braden | Sheet Metal Workers Local Union 104 Political Committee | Barona Band of Mission Indians | California State Association of Electrical Workers Political Account | Plumbers & Steamfitters Local 467 State Political Action Fund SCC | Kremen | San Francisco Laborer's Local 261 PAC | California State Council of Service Employees SCC | Lockheed Martin Employees' PAC | Nat'l Union of Healthcare Workers Cand. Comm. Quality Patient Care & Union Democracy | AT&T Services Inc. and its Affiliates | Salesforce | DoorDash, Inc. | Richardson | Wheeler | Holzberg | Curtis | Borges | International Brotherhood of Electrical Workers Local Union 1245 | Miller | Johnston | Plaska | UPS PAC | California Association of Highway Patrolmen PAC | Lauder | Lauder | Hunt | Berman | California Defense Counsel PAC | AIACC Architects for Livable Communities PAC | California Cable & Telecommunications Association PAC | Anheuser Busch Companies | General Motors Company PAC | The Dentists Insurance Company | Cummins Inc. PAC | Northern California Carpenters Regional Council | Sysco Corporation | 21st Century Alliance Good Government PAC | Cal Fire Local 2881 Small Contributor PAC | Deloitte Services LP | California New Car Dealers Association PAC | Agua Caliente Band of Cahuilla Indians | AmerisourceBergen | Paramount Pictures | Aya Healthcare, Inc. | Amazon.com Services LLC | Pechanga Band of Indians | Operating Engineers Local No. 3 Statewide PAC | Zuffa, LLC (dba UFC) | Ring Central, Inc. | Braden | Sheet Metal Workers Local Union 104 Political Committee | Barona Band of Mission Indians | California State Association of Electrical Workers Political Account | Plumbers & Steamfitters Local 467 State Political Action Fund SCC | Kremen | San Francisco Laborer's Local 261 PAC | California State Council of Service Employees SCC | Lockheed Martin Employees' PAC | Nat'l Union of Healthcare Workers Cand. Comm. Quality Patient Care & Union Democracy | AT&T Services Inc. and its Affiliates | Salesforce | DoorDash, Inc. | Richardson | Wheeler | Holzberg | Curtis | Borges | International Brotherhood of Electrical Workers Local Union 1245 | Miller | Johnston | Plaska | UPS PAC | California Association of Highway Patrolmen PAC | Lauder | Lauder | Hunt | Berman | Tan | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Barry | None | None | None | None | Gary | None | None | None | None | None | None | None | Susie | Jackie | Lorri | Carolyn | Jessica | None | D. John | A.C. | Judy | None | None | Laura | Gary | Leannah | Karen | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Barry | None | None | None | None | Gary | None | None | None | None | None | None | None | Susie | Jackie | Lorri | Carolyn | Jessica | None | D. John | A.C. | Judy | None | None | Laura | Gary | Leannah | Karen | Jinzheng 'Roy' | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_city | Sacramento | Sacramento | Sacramento | St. Louis | Washington | Sacramento | Washington | Oakland | Houston | Oakland | Sacramento | Hermitage | Sacramento | Palm Springs | Conshohocken | Los Angeles | San Diego | Seattle | Temecula | Alameda | Las Vegas | Belmont | Berkeley | Livermore | Lakeside | Pasadena | Burlingame | Menlo Park | San Francisco | Sacramento | Arlington | Sacramento | Sacramento | San Francisco | San Francisco | Palo Alto | Palo Alto | Menlo Park | Palo Alto | Sunnyvale | Vacaville | San Jose | Palo Alto | Mountain View | Atlanta | Sacramento | Atherton | Atherton | Palo Alto | Sarasota | Sacramento | Sacramento | Sacramento | St. Louis | Washington | Sacramento | Washington | Oakland | Houston | Oakland | Sacramento | Hermitage | Sacramento | Palm Springs | Conshohocken | Los Angeles | San Diego | Seattle | Temecula | Alameda | Las Vegas | Belmont | Berkeley | Livermore | Lakeside | Pasadena | Burlingame | Menlo Park | San Francisco | Sacramento | Arlington | Sacramento | Sacramento | San Francisco | San Francisco | Palo Alto | Palo Alto | Menlo Park | Palo Alto | Sunnyvale | Vacaville | San Jose | Palo Alto | Mountain View | Atlanta | Sacramento | Atherton | Atherton | Palo Alto | Sarasota | Daly City | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_st | CA | CA | CA | MO | DC | CA | DC | CA | TX | CA | CA | TN | CA | CA | PA | CA | CA | WA | CA | CA | NV | CA | CA | CA | CA | CA | CA | CA | CA | CA | VA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | GA | CA | CA | CA | CA | FL | CA | CA | CA | MO | DC | CA | DC | CA | TX | CA | CA | TN | CA | CA | PA | CA | CA | WA | CA | CA | NV | CA | CA | CA | CA | CA | CA | CA | CA | CA | VA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | GA | CA | CA | CA | CA | FL | CA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_zip4 | 95814 | 95814 | 95814 | 63118 | 20001 | 95814 | 20004 | 94621 | 77077 | 94607 | 95814 | 37076 | 95814 | 92264 | 19428 | 90038 | 92121 | 98109 | 92592 | 94502 | 89118 | 94002 | 94710 | 94551 | 92040 | 91101 | 94010 | 94025 | 94110 | 95814 | 22202 | 95815 | 95814 | 94105 | 94107 | 94301 | 94306 | 94025 | 94306 | 94086 | 95687 | 95113 | 94304 | 94043 | 30328 | 95818 | 94027 | 94027 | 94301 | 34236 | 95814 | 95814 | 95814 | 63118 | 20001 | 95814 | 20004 | 94621 | 77077 | 94607 | 95814 | 37076 | 95814 | 92264 | 19428 | 90038 | 92121 | 98109 | 92592 | 94502 | 89118 | 94002 | 94710 | 94551 | 92040 | 91101 | 94010 | 94025 | 94110 | 95814 | 22202 | 95815 | 95814 | 94105 | 94107 | 94301 | 94306 | 94025 | 94306 | 94086 | 95687 | 95113 | 94304 | 94043 | 30328 | 95818 | 94027 | 94027 | 94301 | 34236 | 94015 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_emp | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Fieldwork Brewing | None | None | None | None | Dogpatch LLC | None | None | None | None | None | None | None | N/A | Self - no separate business name | N/A | N/A | Lockheed Martin Space | None | DJM Capital Partners | N/A | N/A | None | None | Lauder Partners, LLC | Lauder Partners, LLC | Christie's International Sereno | N/A - Retired | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Fieldwork Brewing | None | None | None | None | Dogpatch LLC | None | None | None | None | None | None | None | N/A | Self - no separate business name | N/A | N/A | Lockheed Martin Space | None | DJM Capital Partners | N/A | N/A | None | None | Lauder Partners, LLC | Lauder Partners, LLC | Christie's International Sereno | N/A - Retired | New York Life Insurance Company | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_occ | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | CEO | None | None | None | None | Entrepreuner | None | None | None | None | None | None | None | Retired | Consultant | Retired Dietitian | Retired | Government Relations | None | Founder & CEO | None | None | None | None | General Partner | Managing Director | Realtor | Homemaker | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | CEO | None | None | None | None | Entrepreuner | None | None | None | None | None | None | None | Retired | Consultant | Retired Dietitian | Retired | Government Relations | None | Founder & CEO | None | None | None | None | General Partner | Managing Director | Realtor | Homemaker | Insurance Agent | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
tran_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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-09-26 00:00:00 | 2022-09-26 00:00:00 | 2022-09-26 00:00:00 | 2022-09-26 00:00:00 | 2022-09-26 00:00:00 | 2022-09-26 00:00:00 | 2022-09-28 00:00:00 | 2022-09-28 00:00:00 | 2022-09-29 00:00:00 | 2022-09-29 00:00:00 | 2022-09-30 00:00:00 | 2022-10-03 00:00:00 | 2022-10-03 00:00:00 | 2022-10-03 00:00:00 | 2022-10-04 00:00:00 | 2022-10-04 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2022-10-10 00:00:00 | 2022-10-11 00:00:00 | 2022-10-11 00:00:00 | 2022-10-12 00:00:00 | 2022-10-12 00:00:00 | 2022-11-12 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-16 00:00:00 | 2022-10-17 00:00:00 | 2022-10-17 00:00:00 | 2022-10-17 00:00:00 | 2022-10-18 00:00:00 | 2022-10-18 00:00:00 | 2022-10-18 00:00:00 | 2022-10-19 00:00:00 | 2022-10-19 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 00:00:00 | 2022-10-22 00:00:00 | 2022-10-22 00:00:00 | 2022-10-22 00:00:00 | 2022-10-22 00:00:00 | 2022-09-26 00:00:00 | 2022-09-26 00:00:00 | 2022-09-26 00:00:00 | 2022-09-26 00:00:00 | 2022-09-26 00:00:00 | 2022-09-26 00:00:00 | 2022-09-28 00:00:00 | 2022-09-28 00:00:00 | 2022-09-29 00:00:00 | 2022-09-29 00:00:00 | 2022-09-30 00:00:00 | 2022-10-03 00:00:00 | 2022-10-03 00:00:00 | 2022-10-03 00:00:00 | 2022-10-04 00:00:00 | 2022-10-04 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 2022-10-10 00:00:00 | 2022-10-11 00:00:00 | 2022-10-11 00:00:00 | 2022-10-12 00:00:00 | 2022-10-12 00:00:00 | 2022-11-12 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-16 00:00:00 | 2022-10-17 00:00:00 | 2022-10-17 00:00:00 | 2022-10-17 00:00:00 | 2022-10-18 00:00:00 | 2022-10-18 00:00:00 | 2022-10-18 00:00:00 | 2022-10-19 00:00:00 | 2022-10-19 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 00:00:00 | 2022-10-20 00:00:00 | 2022-10-22 00:00:00 | 2022-10-22 00:00:00 | 2022-10-22 00:00:00 | 2022-10-22 00:00:00 | 2022-10-15 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
amount | 2000 | 2000 | 1000 | 1250 | 2000 | 4900 | 2000 | 5000 | 2000 | 1000 | 4000 | 4000 | 1000 | 3000 | 1000 | 1000 | 1000 | 4900 | 2500 | 4900 | 2000 | 2000 | 500 | 4900 | 3000 | 7500 | 5000 | 2000 | 2450 | 9700 | 1000 | 4900 | 1500 | 1500 | 2000 | 100 | 100 | 250 | 100 | 100 | 1000 | 2500 | 250 | 100 | 2500 | 2500 | 1000 | 1000 | 500 | 100 | 2000 | 2000 | 1000 | 1250 | 2000 | 4900 | 2000 | 5000 | 2000 | 1000 | 4000 | 4000 | 1000 | 3000 | 1000 | 1000 | 1000 | 4900 | 2500 | 4900 | 2000 | 2000 | 500 | 4900 | 3000 | 7500 | 5000 | 2000 | 2450 | 9700 | 1000 | 4900 | 1500 | 1500 | 2000 | 100 | 100 | 250 | 100 | 100 | 1000 | 2500 | 250 | 100 | 2500 | 2500 | 1000 | 1000 | 500 | 100 | 150 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cum_ytd | 2000 | 2000 | 4000 | 1250 | 2000 | 9800 | 2000 | 5000 | 2000 | 2500 | 4000 | 4000 | 1000 | 3000 | 1000 | 1000 | 1000 | 4900 | 4900 | 4900 | 2000 | 2000 | 500 | 4900 | 4900 | 12500 | 5000 | 2000 | 2450 | 19400 | 1000 | 9800 | 1500 | 1500 | 2000 | 100 | 100 | 250 | 100 | 100 | 1000 | 2500 | 250 | 100 | 5000 | 4000 | 1000 | 1000 | 500 | 100 | 2000 | 2000 | 4000 | 1250 | 2000 | 9800 | 2000 | 5000 | 2000 | 2500 | 4000 | 4000 | 1000 | 3000 | 1000 | 1000 | 1000 | 4900 | 4900 | 4900 | 2000 | 2000 | 500 | 4900 | 4900 | 12500 | 5000 | 2000 | 2450 | 19400 | 1000 | 9800 | 1500 | 1500 | 2000 | 100 | 100 | 250 | 100 | 100 | 1000 | 2500 | 250 | 100 | 5000 | 4000 | 1000 | 1000 | 500 | 100 | 150 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cmte_id | 850665 | 791819 | 745932 | None | C00076810 | None | 1392347 | 972104 | None | 1439959 | 790318 | None | 741623 | None | None | None | None | None | None | 981697 | None | None | None | 850381 | None | 743107 | 782481 | None | 981076 | 831628 | 1431455 | 1318200 | 478036 | None | None | None | None | None | None | None | 742993 | None | None | None | 1377592 | 802001 | None | None | None | None | 850665 | 791819 | 745932 | None | C00076810 | None | 1392347 | 972104 | None | 1439959 | 790318 | None | 741623 | None | None | None | None | None | None | 981697 | None | None | None | 850381 | None | 743107 | 782481 | None | 981076 | 831628 | 1431455 | 1318200 | 478036 | None | None | None | None | None | None | None | 742993 | None | None | None | 1377592 | 802001 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 34 | None | None | 37 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 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 | 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 | 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 | 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 | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filing_id | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
line_item | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 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 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 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 | 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 | 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 | 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 | F460 | F460 | 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 | 112500 | 0 | 112500 | 0 | 112500 | 86070 | 0 | 86070 | 0 | 0 | 86070 | 965257 | 112500 | 0 | 86070 | 991687 | 0 | 0 | 0 | 322100 | 184833 | 158610 | 33005 | 112500 | 0 | 112500 | 0 | 0 | 0 | 0 | 0 | 0 | 68900 | 0 | 68900 | 85721 | 349 | 0 | 86070 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 112650 | 0 | 112650 | 0 | 112650 | 86070 | 0 | 86070 | 0 | 0 | 86070 | 965257 | 112650 | 0 | 86070 | 991837 | 0 | 0 | 0 | 322100 | 184833 | 158610 | 33005 | 112650 | 0 | 112650 | 0 | 0 | 0 | 0 | 0 | 0 | 68900 | 0 | 68900 | 85721 | 349 | 0 | 86070 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
amount_b | 576788 | 0 | 576788 | 4962 | 581750 | 426700 | 0 | 426700 | 0 | 4962 | 431662 | None | None | None | None | None | None | None | None | 259650 | 241866 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 576938 | 0 | 576938 | 4962 | 581900 | 426700 | 0 | 426700 | 0 | 4962 | 431662 | None | None | None | None | None | None | None | None | 259800 | 241866 | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 2022-06-07 00:00:00 | 2022-11-08 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 2022-06-07 00:00:00 | 2022-11-08 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 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | 2740000 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | D | D | D | D | D | D | D | D | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | 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 | D | D | D | D | D | D | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ptran_id | 17 | 17 | 18 | 19 | 20 | 20 | 21 | 21 | 22 | 22 | 23 | 24 | 24 | 25 | 26 | 26 | 27 | 28 | 29 | 29 | 30 | 31 | 32 | 33 | 34 | 34 | 35 | 35 | 36 | 36 | 37 | 38 | 39 | 40 | 40 | 41 | 41 | 42 | 42 | 43 | 44 | 44 | 45 | 45 | 46 | 46 | 47 | 48 | 48 | 49 | 50 | 51 | 51 | 52 | 53 | 53 | 54 | 54 | 55 | 55 | 56 | 57 | 68 | 68 | 69 | 69 | 70 | 70 | 71 | 71 | 72 | 72 | 73 | 73 | 74 | 75 | 76 | 76 | 58 | 58 | 59 | 60 | 62 | 78 | 78 | 80 | 17 | 17 | 18 | 19 | 20 | 20 | 21 | 21 | 22 | 22 | 23 | 24 | 24 | 25 | 26 | 26 | 27 | 28 | 29 | 29 | 30 | 31 | 32 | 33 | 34 | 34 | 35 | 35 | 36 | 36 | 37 | 38 | 39 | 40 | 40 | 41 | 41 | 42 | 42 | 43 | 44 | 44 | 45 | 45 | 46 | 46 | 47 | 48 | 48 | 49 | 50 | 51 | 51 | 52 | 53 | 53 | 54 | 54 | 55 | 55 | 56 | 57 | 68 | 68 | 69 | 69 | 70 | 70 | 71 | 71 | 72 | 72 | 73 | 73 | 74 | 75 | 76 | 76 | 89 | 58 | 58 | 59 | 60 | 62 | 78 | 78 | 80 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
elec_date | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | 2022-06-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
elec_amount | 1000 | 2000 | 2000 | 4000 | 4900 | 1250 | 1500 | 2000 | 4900 | 4900 | 2000 | 4850 | 5000 | 2000 | 1500 | 1000 | 4000 | 4000 | 3500 | 1000 | 3000 | 1000 | 1000 | 1000 | 4900 | 4900 | 4900 | 4900 | 2000 | 4900 | 2000 | 2000 | 500 | 4900 | 4900 | 4900 | 3000 | 5000 | 7500 | 5000 | 1550 | 2000 | 4900 | 2450 | 9700 | 9700 | 1000 | 4900 | 4900 | 1500 | 1500 | 2500 | 2000 | 100 | 100 | 100 | 250 | 250 | 100 | 100 | 100 | 1000 | 2500 | 2500 | 500 | 250 | 100 | 100 | 2500 | 2500 | 1500 | 2500 | 4900 | 1000 | 1000 | 500 | 100 | 100 | 500 | 500 | 750 | 100 | 250 | 800 | 800 | 500 | 1000 | 2000 | 2000 | 4000 | 4900 | 1250 | 1500 | 2000 | 4900 | 4900 | 2000 | 4850 | 5000 | 2000 | 1500 | 1000 | 4000 | 4000 | 3500 | 1000 | 3000 | 1000 | 1000 | 1000 | 4900 | 4900 | 4900 | 4900 | 2000 | 4900 | 2000 | 2000 | 500 | 4900 | 4900 | 4900 | 3000 | 5000 | 7500 | 5000 | 1550 | 2000 | 4900 | 2450 | 9700 | 9700 | 1000 | 4900 | 4900 | 1500 | 1500 | 2500 | 2000 | 100 | 100 | 100 | 250 | 250 | 100 | 100 | 100 | 1000 | 2500 | 2500 | 500 | 250 | 100 | 100 | 2500 | 2500 | 1500 | 2500 | 4900 | 1000 | 1000 | 500 | 100 | 100 | 150 | 500 | 500 | 750 | 100 | 250 | 800 | 800 | 500 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
elec_code | P | G | G | G | P | G | P | G | P | G | G | P | G | G | P | G | G | G | P | G | G | G | G | G | P | G | P | G | P | G | G | G | G | P | G | P | G | P | G | G | P | G | P | G | P | G | G | P | G | G | G | P | G | G | P | G | P | G | P | G | G | G | P | G | P | G | P | G | P | G | P | G | P | G | G | G | P | G | P | G | G | G | G | P | G | G | P | G | G | G | P | G | P | G | P | G | G | P | G | G | P | G | G | G | P | G | G | G | G | G | P | G | P | G | P | G | G | G | G | P | G | P | G | P | G | G | P | G | P | G | P | G | G | P | G | G | G | P | G | G | P | G | P | G | P | G | G | G | P | G | P | G | P | G | P | G | P | G | P | G | G | G | P | G | G | P | G | G | G | G | P | G | G |