filing_id | 1135437 | 1148528 | 1148528 | 1128785 | 1752202 | 1848783 | 1862621 | 1929552 | 2046105 | 2078421 | 2056629 | 2120038 | 2452515 | 2445743 | 2485413 | 2512466 | 2550312 | 2609154 | 2635123 | 2616838 | 2609154 | 2609154 | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | ||||||||||||||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||||||||||||||||
form_type | F497 | F460 | F460 | F461 | F497 | F497 | F461 | F461 | F497 | F497 | F461 | F461 | F497 | F497 | F461 | F497 | F461 | F496 | F461 | F461 | F496 | F496 | ||||||||||||||||||||||
filer_id | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | ||||||||||||||||||||||
entity_cd | None | CTL | CTL | None | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | ||||||||||||||||||||||
filer_naml | CALIFORNIA STATE PIPE TRADES COUNCIL OF THE UNITED ASSOCIATION | CALIFORNIA STATE PIPE TRADES COUNCIL OF THE UNITED ASSOCIATION | CALIFORNIA STATE PIPE TRADES COUNCIL OF THE UNITED ASSOCIATION | CALIFORNIA STATE PIPE TRADES COUNCIL OF THE UNITED ASSOCIATION | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | California State Pipe Trades Council of the United Association | ||||||||||||||||||||||
filer_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
filer_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
filer_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
report_num | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 002 | ||||||||||||||||||||||
rpt_date | 2005-11-03 00:00:00 | 2006-01-31 00:00:00 | 2006-01-31 00:00:00 | 2005-10-19 00:00:00 | 2013-03-06 00:00:00 | 2014-05-09 00:00:00 | 2014-07-08 00:00:00 | 2015-01-11 00:00:00 | 2016-05-25 00:00:00 | 2016-09-16 00:00:00 | 2016-07-13 00:00:00 | 2017-01-12 00:00:00 | 2020-02-13 00:00:00 | 2020-02-04 00:00:00 | 2020-07-31 00:00:00 | 2020-10-09 00:00:00 | 2021-01-19 00:00:00 | 2021-08-30 00:00:00 | 2022-01-12 00:00:00 | 2021-10-15 00:00:00 | 2021-08-26 00:00:00 | 2021-08-31 00:00:00 | ||||||||||||||||||||||
stmt_type | None | SA | SA | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
late_rptno | 11-3-2005 | None | None | None | LCR - SE13 | P14.1 | None | None | P16-1 | G16-1 | None | None | P20-2 | P20-1 | None | GE.11320.1 | None | 496-1 | None | None | 496-1 | 496-1 | ||||||||||||||||||||||
from_date | None | 2005-10-01 00:00:00 | 2005-10-01 00:00:00 | 2005-07-01 00:00:00 | None | None | 2014-01-01 00:00:00 | 2014-07-01 00:00:00 | None | None | 2016-01-01 00:00:00 | 2016-07-01 00:00:00 | None | None | 2020-01-01 00:00:00 | None | 2020-07-01 00:00:00 | None | 2021-10-01 00:00:00 | 2021-01-01 00:00:00 | None | None | ||||||||||||||||||||||
thru_date | None | 2005-12-31 00:00:00 | 2005-12-31 00:00:00 | 2005-09-30 00:00:00 | None | None | 2014-06-30 00:00:00 | 2014-12-31 00:00:00 | None | None | 2016-06-30 00:00:00 | 2016-12-31 00:00:00 | None | None | 2020-06-30 00:00:00 | None | 2020-12-31 00:00:00 | None | 2021-12-31 00:00:00 | 2021-09-30 00:00:00 | None | None | ||||||||||||||||||||||
elect_date | None | None | None | 2005-11-07 00:00:00 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
filer_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | ||||||||||||||||||||||
filer_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||
filer_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||
filer_phon | 9164467311 | None | None | 9164467311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | ||||||||||||||||||||||
filer_fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
file_email | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
mail_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
mail_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
tres_naml | None | REED | REED | REED | Cameron | Cameron | Cameron | Cameron | Cameron | Partch | Partch | Partch | Partch | Partch | J. Richard Eichman, Agent for Filer | J. Richard Eichman, Agent for Filer | Stockwell | Stockwell | Hartley | Stockwell | Stockwell | Stockwell | ||||||||||||||||||||||
tres_namf | None | TED | TED | TED | Rodney L. | Rodney L. | Rodney L. | Rodney L. | Rodney L. | Gregory A. | Gregory A. | Gregory A. | Gregory A. | Gregory A. | Aaron Stockwell; | Aaron Stockwell; | Aaron | Aaron | Mike | Aaron | Aaron | Aaron | ||||||||||||||||||||||
tres_namt | 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 | ||||||||||||||||||||||
tres_city | None | SACRAMENTO | SACRAMENTO | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
tres_st | None | CA | CA | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
tres_zip4 | None | 95814 | 95814 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
tres_phon | None | None | None | None | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | (916) 446-7311 | ||||||||||||||||||||||
tres_fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
tres_email | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
cmtte_type | None | G | G | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
control_yn | None | N | Y | None | None | None | N | N | None | None | N | N | None | None | N | None | N | None | N | N | None | None | ||||||||||||||||||||||
sponsor_yn | None | Y | N | None | None | None | N | N | None | None | N | N | None | None | N | None | N | None | N | N | None | None | ||||||||||||||||||||||
primfrm_yn | None | N | N | None | None | None | N | N | None | None | N | N | None | None | N | None | N | None | N | N | None | None | ||||||||||||||||||||||
brdbase_yn | None | None | None | None | None | None | N | N | None | None | N | N | None | None | N | None | N | None | N | N | None | None | ||||||||||||||||||||||
amendexp_1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Amending the amount of the expenditure | None | None | None | Amending the amount of the expenditure | ||||||||||||||||||||||
amendexp_2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
amendexp_3 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
rpt_att_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
cmtte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
reportname | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
rptfromdt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
rptthrudt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
emplbus_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
bus_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
bus_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
bus_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
bus_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
bus_inter | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
busact_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
busactvity | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
assoc_cb | None | None | None | X | None | None | X | X | None | None | X | X | None | None | X | None | X | None | X | X | None | None | ||||||||||||||||||||||
assoc_int | None | None | None | STATE BUILDING TRADES | None | None | Union | Union | None | None | Union, Investment Income | Union, Investment Income | None | None | Union, Investment Income | None | Union, Investment Income | None | Union, Investment Income | Union, Investment Income | None | None | ||||||||||||||||||||||
other_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
other_int | 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 | Recall of Governor Gavin Newsom | None | None | Recall of Governor Gavin Newsom | Recall of Governor Gavin Newsom | ||||||||||||||||||||||
cand_namf | 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 | ||||||||||||||||||||||
cand_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
cand_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
cand_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
cand_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
cand_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
cand_fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
cand_email | 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 | ||||||||||||||||||||||
bal_num | 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 | ||||||||||||||||||||||
office_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | GOV | None | None | GOV | GOV | ||||||||||||||||||||||
offic_dscr | 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 | STW | None | None | STW | STW | ||||||||||||||||||||||
juris_dscr | 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 | ||||||||||||||||||||||
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 | ||||||||||||||||||||||
sup_opp_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | S | None | None | O | O | ||||||||||||||||||||||
employer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
occupation | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
selfemp_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
bal_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
cand_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1225486 | 1225486 | ||
---|---|---|---|---|
adrid | 2003201 | 2094252 | ||
effect_dt | 2000-07-31 00:00:00 | 2005-10-19 00:00:00 | ||
add_type | 7051 | 7051 | ||
session_id | 1999 | 2005 |
filer_id | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 669218 | 747595 | 669218 | 1135437 | 1138845 | 1128785 | 1130723 | 1148528 | 1148528 | 1864564 | 1862621 | 1936163 | 1929552 | 1848783 | 1752202 | 2452515 | 2046105 | 2056629 | 2064031 | 2078421 | 2121230 | 2120038 | 2512466 | 2445743 | 2550312 | 2504162 | 2485413 | 2652411 | 2609154 | 2609154 | 2617526 | 2609154 | 2635123 | 2569133 | 2616838 | |||||||||||||||||||||||||||||||||||
period_id | None | None | None | 184 | None | 183 | None | 184 | 184 | None | 217 | None | 219 | 218 | 213 | 241 | 226 | 225 | None | 227 | None | 227 | 244 | 241 | 243 | None | 241 | None | 247 | 247 | None | 247 | 248 | None | 245 | |||||||||||||||||||||||||||||||||||
form_id | F461 | F461 | F461 | F497 | F497 | F461 | F461 | F460 | F460 | F461 | F461 | F461 | F461 | F497 | F497 | F497 | F497 | F461 | F461 | F497 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F461 | F496 | F496 | F461 | F496 | F461 | F461 | F461 | |||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
filing_date | 2000-07-31 00:00:00 | 2001-01-31 00:00:00 | 2000-08-21 00:00:00 | 2005-11-03 00:00:00 | 2005-11-03 00:00:00 | 2005-10-19 00:00:00 | 2005-10-24 00:00:00 | 2006-01-31 00:00:00 | 2006-01-31 00:00:00 | 2014-07-15 00:00:00 | 2014-07-14 00:00:00 | 2015-01-26 00:00:00 | 2015-01-26 00:00:00 | 2014-05-09 00:00:00 | 2013-03-07 00:00:00 | 2020-02-13 00:00:00 | 2016-05-25 00:00:00 | 2016-07-20 00:00:00 | 2016-07-20 00:00:00 | 2016-09-16 00:00:00 | 2017-01-18 00:00:00 | 2017-01-17 00:00:00 | 2020-10-09 00:00:00 | 2020-02-04 00:00:00 | 2021-01-29 00:00:00 | 2020-07-31 00:00:00 | 2020-07-31 00:00:00 | 2022-01-18 00:00:00 | 2021-08-31 00:00:00 | 2021-08-30 00:00:00 | 2021-10-19 00:00:00 | 2021-08-26 00:00:00 | 2022-01-18 00:00:00 | 2021-01-29 00:00:00 | 2021-10-19 00:00:00 | |||||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10005 | 10006 | 10001 | 10005 | 10001 | 10005 | 10001 | 10002 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10002 | 10002 | 10005 | 10001 | 10001 | 10005 | 10001 | |||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1999 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||
user_id | EMCENTEE | EMCENTEE | EMCENTEE | DMCCASTL | KVANG | * | DHORRELL | * | * | JINGRAM | JINGRAM | JINGRAM | JINGRAM | KBANH | WBROWN | RGEREMIA | KBANH | JINGRAM | JINGRAM | PDEO | JINGRAM | JINGRAM | CAFILER | CAFILER | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | CAFILER | CAFILER | GTAYLOR | CAFILER | GTAYLOR | GTAYLOR | GTAYLOR | |||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||
fine_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||
rpt_start | 2000-01-01 00:00:00 | 2000-07-01 00:00:00 | 2000-01-01 00:00:00 | 2005-11-03 00:00:00 | None | 2005-07-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2005-10-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-07-01 00:00:00 | 2014-07-01 00:00:00 | 2014-05-09 00:00:00 | 2013-03-06 00:00:00 | 2020-02-13 00:00:00 | 2016-05-25 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-09-16 00:00:00 | 2016-07-01 00:00:00 | 2016-07-01 00:00:00 | 2020-10-09 00:00:00 | 2020-02-04 00:00:00 | 2020-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-08-31 00:00:00 | 2021-08-30 00:00:00 | 2021-01-01 00:00:00 | 2021-08-26 00:00:00 | 2021-10-01 00:00:00 | 2020-07-01 00:00:00 | 2021-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||
rpt_end | 2000-06-30 00:00:00 | 2000-12-31 00:00:00 | 2000-06-30 00:00:00 | 2005-11-03 00:00:00 | None | 2005-09-30 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2005-12-31 00:00:00 | 2014-06-30 00:00:00 | 2014-06-30 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-05-09 00:00:00 | 2013-03-06 00:00:00 | 2020-02-13 00:00:00 | 2016-05-25 00:00:00 | 2016-06-30 00:00:00 | 2016-06-30 00:00:00 | 2016-09-16 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2020-10-09 00:00:00 | 2020-02-04 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-08-31 00:00:00 | 2021-08-30 00:00:00 | 2021-09-30 00:00:00 | 2021-08-26 00:00:00 | 2021-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | 2005-11-03 00:00:00 | None | 2005-10-19 00:00:00 | None | 2006-01-31 00:00:00 | 2006-01-31 00:00:00 | None | 2014-07-08 00:00:00 | None | 2015-01-11 00:00:00 | 2014-05-09 00:00:00 | 2013-03-06 00:00:00 | 2020-02-13 00:00:00 | 2016-05-25 00:00:00 | 2016-07-13 00:00:00 | None | 2016-09-16 00:00:00 | None | 2017-01-12 00:00:00 | 2020-10-09 00:00:00 | 2020-02-04 00:00:00 | 2021-01-19 00:00:00 | None | 2020-07-31 00:00:00 | None | 2021-08-31 00:00:00 | 2021-08-30 00:00:00 | None | 2021-08-26 00:00:00 | 2022-01-12 00:00:00 | None | 2021-10-15 00:00:00 | |||||||||||||||||||||||||||||||||||
filing_type | None | None | None | 22006 | None | 22006 | None | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | None | 22001 |
filer_id | 1225486 | |
---|---|---|
filer_type | 10 | |
active | Y | |
race | 0 | |
session_id | 1999 | |
category | 0 | |
category_type | 40502 | |
sub_category | 0 | |
effect_dt | 2000-07-31 00:00:00 | |
sub_category_type | 0 | |
election_type | 0 | |
sub_category_a | None | |
nyq_dt | None | |
party_cd | 0 | |
county_cd | 18004 | |
district_cd | 0 |
filer_id | 1225486 | |
---|---|---|
xref_id | 1225486 | |
effect_dt | 2000-08-01 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1225486 | 1225486 | ||
---|---|---|---|---|
filer_id | 1225486 | 1225486 | ||
filer_type | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | ||
status | ACTIVE | ACTIVE | ||
effect_dt | 2000-07-31 00:00:00 | 2000-07-31 00:00:00 | ||
naml | CALIFORNIA STATE PIPE TRADES COUNCIL OF THE UNITED ASSOCIATION | CALIFORNIA STATE PIPE TRADES COUNCIL OF THE UNITED ASSOCIATION | ||
namf | None | None | ||
namt | None | None | ||
nams | None | None | ||
adr1 | None | None | ||
adr2 | None | None | ||
city | SACRAMENTO | SACRAMENTO | ||
st | CA | CA | ||
zip4 | 95814 | 95814 | ||
phon | 9164467311 | 9164467311 | ||
fax | None | None | ||
None | None |
filer_id | 1225486 |
---|
filer_id | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | 1225486 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 252008.cal | 252092.cal | 252687.cal | 1848783_0.cal | 1752202_0.cal | 2046105_0.cal | 2078421_0.cal | 2452515_0.cal | 2445743_0.cal | 2512466_0.cal | 59309.cal | |||||||||||
received_date | 2006-01-31 00:00:00 | 2006-01-31 00:00:00 | 2006-01-31 00:00:00 | 2014-05-09 00:00:00 | 2013-03-07 00:00:00 | 2016-05-25 00:00:00 | 2016-09-16 00:00:00 | 2020-02-13 00:00:00 | 2020-02-04 00:00:00 | 2020-10-09 00:00:00 | 2021-08-31 00:00:00 | |||||||||||
filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | |||||||||||
filing_id | None | None | None | 1848783 | 1752202 | 2046105 | 2078421 | 2452515 | 2445743 | 2512466 | None | |||||||||||
form_id | None | None | None | F497 | F497 | F497 | F497 | F497 | F497 | F497 | None | |||||||||||
receive_comment | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints |