filer_id | 1012880 | 1012880 | ||
---|---|---|---|---|
adrid | 1012419 | 1130585 | ||
effect_dt | 2008-01-29 00:00:00 | 2000-03-02 00:00:00 | ||
add_type | 7051 | 7082 | ||
session_id | 2007 | 1999 |
filer_id | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 74626 | 74627 | 74628 | 74629 | 685984 | 685984 | 600436 | 604496 | 675575 | 761046 | 1938460 | 1896456 | 1899446 | 1899446 | 1315341 | 1392596 | 1460192 | 1567287 | 1576840 | 1928467 | 1896456 | 2464374 | 2437579 | 2084586 | 2603106 | 2550403 | 2569185 | 2655964 | 2643965 | 2704788 | 2713793 | 2722954 | 2607992 | 2721567 | ||||||||||||||||||||||||||||||||||
period_id | 138 | 137 | 137 | 137 | None | None | None | 161 | None | None | None | 220 | 220 | 220 | None | None | None | 201 | None | 217 | 220 | None | 237 | 228 | 245 | 241 | None | None | 247 | 249 | None | 251 | None | 251 | ||||||||||||||||||||||||||||||||||
form_id | F497 | F461 | F461 | F405 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F497 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F497 | ||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
filing_date | 1994-04-04 00:00:00 | 1994-08-01 00:00:00 | 1995-01-27 00:00:00 | 1995-07-27 00:00:00 | 2000-09-01 00:00:00 | 2000-09-08 00:00:00 | 2000-03-01 00:00:00 | 2000-03-04 00:00:00 | 2000-07-20 00:00:00 | 2001-01-31 00:00:00 | 2015-01-26 00:00:00 | 2014-10-10 00:00:00 | 2014-10-16 00:00:00 | 2014-10-24 00:00:00 | 2008-01-29 00:00:00 | 2009-01-22 00:00:00 | 2010-01-21 00:00:00 | 2011-01-27 00:00:00 | 2011-01-27 00:00:00 | 2015-01-22 00:00:00 | 2014-10-24 00:00:00 | 2020-01-29 00:00:00 | 2020-01-29 00:00:00 | 2016-10-03 00:00:00 | 2021-08-02 00:00:00 | 2021-01-29 00:00:00 | 2021-01-29 00:00:00 | 2022-01-31 00:00:00 | 2022-01-31 00:00:00 | 2022-07-29 00:00:00 | 2022-07-29 00:00:00 | 2022-09-23 00:00:00 | 2021-08-02 00:00:00 | 2022-09-19 00:00:00 | ||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10002 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | ||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | ||||||||||||||||||||||||||||||||||
session_id | 1993 | 1993 | 1993 | 1993 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2013 | 2013 | 2013 | 2013 | 2007 | 2007 | 2009 | 2009 | 2009 | 2013 | 2013 | 2019 | 2019 | 2015 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | BSMITH | BSMITH | BSMITH | BSMITH | EMCENTEE | EMCENTEE | JINGRAM | CAFILER | CAFILER | CAFILER | SMCCABE | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | CAFILER | GTAYLOR | GTAYLOR | PDEO | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | CAFILER | GTAYLOR | RGEREMIA | ||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | ||||||||||||||||||||||||||||||||||
rpt_start | None | 1994-01-01 00:00:00 | 1994-01-01 00:00:00 | 1994-01-01 00:00:00 | 1998-01-01 00:00:00 | 1998-07-01 00:00:00 | None | 2000-03-01 00:00:00 | 2000-01-01 00:00:00 | 2000-07-01 00:00:00 | 2014-01-01 00:00:00 | 2014-10-10 00:00:00 | 2014-10-16 00:00:00 | 2014-10-24 00:00:00 | 2007-01-01 00:00:00 | 2008-01-01 00:00:00 | 2009-01-01 00:00:00 | 2010-01-01 00:00:00 | 2010-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-10-24 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2016-10-03 00:00:00 | 2021-01-01 00:00:00 | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-09-23 00:00:00 | 2021-01-01 00:00:00 | 2022-09-19 00:00:00 | ||||||||||||||||||||||||||||||||||
rpt_end | None | 1994-06-30 00:00:00 | 1994-12-31 00:00:00 | 1994-12-31 00:00:00 | 1998-12-31 00:00:00 | 1998-12-31 00:00:00 | None | 2000-03-01 00:00:00 | 2000-06-30 00:00:00 | 2000-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-10-10 00:00:00 | 2014-10-16 00:00:00 | 2014-10-24 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-10-24 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2016-10-03 00:00:00 | 2021-06-30 00:00:00 | 2020-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2022-06-30 00:00:00 | 2022-09-23 00:00:00 | 2021-06-30 00:00:00 | 2022-09-19 00:00:00 | ||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | 2000-03-01 00:00:00 | None | None | None | 2014-10-10 00:00:00 | 2014-10-16 00:00:00 | 2014-10-24 00:00:00 | None | None | None | 2011-01-18 00:00:00 | None | 2015-01-21 00:00:00 | 2014-10-24 00:00:00 | None | 2020-01-28 00:00:00 | 2016-10-03 00:00:00 | 2021-07-20 00:00:00 | 2021-01-28 00:00:00 | None | None | 2022-01-31 00:00:00 | 2022-07-08 00:00:00 | None | 2022-09-23 00:00:00 | None | 2022-09-19 00:00:00 | ||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | 22001 | 22001 | 22001 | None | None | None | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | None | 22001 | None | 22001 |
filer_id | 1012880 | |
---|---|---|
filer_type | 10 | |
active | Y | |
race | 0 | |
session_id | 2007 | |
category | 0 | |
category_type | 40502 | |
sub_category | 0 | |
effect_dt | 1994-04-05 00:00:00 | |
sub_category_type | 0 | |
election_type | 0 | |
sub_category_a | None | |
nyq_dt | None | |
party_cd | 0 | |
county_cd | 18001 | |
district_cd | 0 |
filer_id | 1012880 | |
---|---|---|
xref_id | 494078 | |
effect_dt | 1999-12-07 00:00:00 | |
migration_source | IDENTFIX |
xref_filer_id | 494078 | 494078 | 494078 | 494078 | ||||
---|---|---|---|---|---|---|---|---|
filer_id | 1012880 | 1012880 | 1012880 | 1012880 | ||||
filer_type | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | ||||
status | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ||||
effect_dt | 1994-04-05 00:00:00 | 1994-04-05 00:00:00 | 1994-04-05 00:00:00 | 1994-04-05 00:00:00 | ||||
naml | OAKS CLUB ROOM | OAKS CLUB ROOM | OAKS CARD CLUB | OAKS CARD CLUB | ||||
namf | None | None | None | None | ||||
namt | None | None | None | None | ||||
nams | None | None | None | None | ||||
adr1 | None | None | None | None | ||||
adr2 | None | None | None | None | ||||
city | EMERYVILLE | SACRAMENTO | EMERYVILLE | SACRAMENTO | ||||
st | CA | CA | CA | CA | ||||
zip4 | 946080000 | 95814 | 946080000 | 95814 | ||||
phon | 5106537093 | 9164483381 | 5106537093 | 9164483381 | ||||
fax | None | None | None | None | ||||
None | None | None | None |
filer_id | 1012880 |
---|
filer_id | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | 1012880 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 1567287_0.cal | 1896456_0.cal | 430378.cal | 430520.cal | 430631.cal | 1896456_1.cal | 1899446_0.cal | 431074.cal | 1899446_1.cal | 2084586_0.cal | 2722954_0.cal | 2721567_0.cal | ||||||||||||
received_date | 2011-01-27 00:00:00 | 2014-10-10 00:00:00 | 2014-10-24 00:00:00 | 2014-10-24 00:00:00 | 2014-10-24 00:00:00 | 2014-10-24 00:00:00 | 2014-10-16 00:00:00 | 2014-10-24 00:00:00 | 2014-10-24 00:00:00 | 2016-10-03 00:00:00 | 2022-09-23 00:00:00 | 2022-09-19 00:00:00 | ||||||||||||
filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||
filing_id | 1567287 | 1896456 | None | None | None | 1896456 | 1899446 | None | 1899446 | 2084586 | 2722954 | 2721567 | ||||||||||||
form_id | F461 | F497 | None | None | None | F497 | F497 | None | F497 | F497 | F497 | F497 | ||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted |