Home

Filer ID: 1397939

Table: cvr_lobby_disclosure
filing_id   2191934   2276899   2211241   2276899   2242025   2317668   2349894   2381055   2317668   2317668   2398857   2416813   2471119   2440993   2552625   2530781   2484943   2623194   2599879   2579107   2675279   2641902   2703544   2746545
amend_id   0   0   0   1   0   2   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
rec_type   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR
form_type   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635
sender_id   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939
filer_id   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939
entity_cd   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM
filer_naml   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES
filer_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
filer_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
filer_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
report_num   000   000   000   001   000   002   000   000   001   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000
rpt_date   2017-10-30 00:00:00   2018-07-31 00:00:00   2018-01-31 00:00:00   2018-08-02 00:00:00   2018-04-30 00:00:00   2018-11-06 00:00:00   2019-01-31 00:00:00   2019-04-30 00:00:00   2018-10-30 00:00:00   2018-10-30 00:00:00   2019-07-31 00:00:00   2019-10-29 00:00:00   2020-04-30 00:00:00   2020-01-30 00:00:00   2021-02-01 00:00:00   2020-11-02 00:00:00   2020-07-31 00:00:00   2021-10-30 00:00:00   2021-07-29 00:00:00   2021-04-29 00:00:00   2022-04-29 00:00:00   2022-01-29 00:00:00   2022-07-29 00:00:00   2022-10-30 00:00:00
from_date   2017-07-01 00:00:00   2018-04-01 00:00:00   2017-10-01 00:00:00   2018-04-01 00:00:00   2018-01-01 00:00:00   2018-07-01 00:00:00   2018-10-01 00:00:00   2019-01-01 00:00:00   2018-07-01 00:00:00   2018-07-01 00:00:00   2019-04-01 00:00:00   2019-07-01 00:00:00   2020-01-01 00:00:00   2019-10-01 00:00:00   2020-10-01 00:00:00   2020-07-01 00:00:00   2020-04-01 00:00:00   2021-07-01 00:00:00   2021-04-01 00:00:00   2021-01-01 00:00:00   2022-01-01 00:00:00   2021-10-01 00:00:00   2022-04-01 00:00:00   2022-07-01 00:00:00
thru_date   2017-09-30 00:00:00   2018-06-30 00:00:00   2017-12-31 00:00:00   2018-06-30 00:00:00   2018-03-31 00:00:00   2018-09-30 00:00:00   2018-12-31 00:00:00   2019-03-31 00:00:00   2018-09-30 00:00:00   2018-09-30 00:00:00   2019-06-30 00:00:00   2019-09-30 00:00:00   2020-03-31 00:00:00   2019-12-31 00:00:00   2020-12-31 00:00:00   2020-09-30 00:00:00   2020-06-30 00:00:00   2021-09-30 00:00:00   2021-06-30 00:00:00   2021-03-31 00:00:00   2022-03-31 00:00:00   2021-12-31 00:00:00   2022-06-30 00:00:00   2022-09-30 00:00:00
cum_beg_dt   2017-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2019-01-01 00:00:00   2017-01-01 00:00:00   2018-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00
firm_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
firm_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
firm_city   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO
firm_st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
firm_zip4   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811
firm_phon   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222
mail_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
mail_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
mail_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
mail_phon   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
sig_date   2017-10-18 00:00:00   2018-07-23 00:00:00   2018-01-22 00:00:00   2018-08-02 00:00:00   2018-04-18 00:00:00   2018-11-06 00:00:00   2019-01-24 00:00:00   2019-04-30 00:00:00   2018-10-30 00:00:00   2018-10-23 00:00:00   2019-07-19 00:00:00   2019-10-18 00:00:00   2020-04-20 00:00:00   2020-01-20 00:00:00   2021-01-24 00:00:00   2020-10-19 00:00:00   2020-07-17 00:00:00   2021-10-19 00:00:00   2021-07-13 00:00:00   2021-04-15 00:00:00   2022-04-19 00:00:00   2022-01-19 00:00:00   2022-07-19 00:00:00   2022-10-20 00:00:00
sig_loc   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA
sig_naml   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana
sig_namf   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph
sig_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
sig_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
prn_naml   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana   Quintana
prn_namf   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph   Joseph
prn_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
prn_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
sig_title   Chief Operating Officer   COO   Chief Operating Officer   COO   COO   COO   COO   COO   COO   COO   COO   COO   COO   COO   COO   COO   COO   COO   COO   COO   COO   COO   COO   COO
nopart1_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
nopart2_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
part1_1_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
part1_2_cb   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_n_cb   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X
ctrib_y_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
lby_actvty   Administration, Go-Biz re: Apprenticeship Programs   Administration, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs; education and support for legislative and budgetary efforts, engage in community outreach and legislative advocacy for the online community college   Administration, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs   Administration, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs; Legislature, Department of Finance re: education and support for legislative and budgetary efforts, engage in community outreach and legislative advocacy for the online community college   Administration, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs; education and support for legislative and budgetary efforts, engage in community outreach and legislative advocacy for the online community college   Administration, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs   Administration, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs   Legislature, Administration, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs and Financial Aid Programs   Administration, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs   Administration, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs   Legislature, Administration, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs and Financial Aid Programs   Legislature, Administration, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs and Financial Aid Programs   Legislature, Administration, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs and Financial Aid Programs, Energy Commission.   Legislature, Administration, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs and Financial Aid Programs   Legislature, Governor's Office, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs and Financial Aid Programs, Energy Commission.   Legislature, Governor's Office, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs and Financial Aid Programs, Energy Commission.   Legislature, Administration, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs and Financial Aid Programs, Energy Commission.   Legislature, Governor's Office, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs and Financial Aid Programs, Energy Commission.   Legislature, Governor's Office, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs and Financial Aid Programs, Energy Commission.   Legislature, Governor's Office, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs and Financial Aid Programs, Energy Commission.   Legislature, Governor's Office, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs and Financial Aid Programs, Energy Commission.   Legislature, Governor's Office, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs and Financial Aid Programs, Energy Commission.   Legislature, Governor's Office, Go-Biz; Bureau of Automotive Repair re: Apprenticeship Programs and Financial Aid Programs, Energy Commission.   Legislature, Governor's Office, Go-Biz; Bureau of Automotive Repair, California Energy Commission re: Apprenticeship Programs and Financial Aid Programs
lobby_n_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
lobby_y_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
major_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
major_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
major_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
major_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
rcpcmte_nm   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
rcpcmte_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: cvr_registration
filing_id   2180350   2557367
amend_id   0   0
rec_type   CVR   CVR
form_type   F602   F602
sender_id   1273600   1273600
filer_id   1397939   1397939
entity_cd   LEM   LEM
filer_naml   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES
filer_namf   None   None
filer_namt   None   None
filer_nams   None   None
report_num   000   000
rpt_date   2017-08-11 00:00:00   2021-02-11 00:00:00
ls_beg_yr   2017   2021
ls_end_yr   2018   2022
qual_date   None   None
eff_date   2017-08-01 00:00:00   2021-01-01 00:00:00
bus_city   SACRAMENTO   SACRAMENTO
bus_st   CA   CA
bus_zip4   95811   95811
bus_phon   8663253222   8663253222
bus_fax   None   None
bus_email   None   None
mail_city   None   None
mail_st   None   None
mail_zip4   None   None
mail_phon   None   None
sig_date   2017-08-01 00:00:00   2020-12-22 00:00:00
sig_loc   None   None
sig_naml   Quintana   Quintana
sig_namf   Joseph   Joseph
sig_namt   None   None
sig_nams   None   None
prn_naml   Quintana   Quintana
prn_namf   Joseph   Joseph
prn_namt   None   None
prn_nams   None   None
sig_title   Chief Operating Officer   Chief Operating Officer
stmt_firm   None   None
ind_cb   None   None
bus_cb   X   X
trade_cb   None   None
oth_cb   None   None
a_b_name   None   None
a_b_city   None   None
a_b_st   None   None
a_b_zip4   None   None
descrip_1   Support all 114 Community Colleges throughout the state through innovative, diverse and far-reaching programs.   Support all 115 Community Colleges throughout the state through innovative, diverse and far-reaching programs.
descrip_2   None   None
c_less50   None   None
c_more50   None   None
ind_class   EDU   EDU
ind_descr   None   None
bus_class   None   None
bus_descr   None   None
auth_name   California Strategies & Advocacy, LLC   California Strategies & Advocacy, LLC
auth_city   Sacramento   Sacramento
auth_st   CA   CA
auth_zip4   95814   95814
lobby_int   None   None
influen_yn   None   None
firm_name   None   None
newcert_cb   None   None
rencert_cb   None   None
complet_dt   None   None
lby_reg_cb   None   None
lby_604_cb   None   None
st_leg_yn   None   None
st_agency   None   None
lobby_cb   None   None
l_firm_cb   None   None
Table: filer_address
filer_id   1397939   1397939   1397939   1397939
adrid   2437920   2519177   2553077   2467091
effect_dt   2017-08-01 00:00:00   2021-01-01 00:00:00   2023-01-01 00:00:00   2019-01-01 00:00:00
add_type   7051   7051   7051   7051
session_id   2017   2021   2023   2019
Table: filer_filings
filer_id   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939
filing_id   2398857   2276899   2211241   2349894   2242025   2381055   2416813   2178508   2178510   2180350   2191934   2317668   2530781   2440993   2325048   2252778   2364217   2552625   2317668   2276899   2317668   2557367   2484943   2471119   2675279   2599879   2623194   2587149   2703544   2641902   2579107   2746545
period_id   238   234   232   236   233   237   239   None   None   231   231   235   243   240   None   None   None   244   235   234   235   245   242   241   249   246   247   None   250   248   245   251
form_id   F635   F635   F635   F635   F635   F635   F635   F602   F999   F602   F635   F635   F635   F635   F605   F602   F602   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635
filing_sequence   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   2   0   1   0   0   0   0   0   0   0   0   0   0   0
filing_date   2019-07-31 00:00:00   2018-08-02 00:00:00   2018-01-31 00:00:00   2019-01-31 00:00:00   2018-04-30 00:00:00   2019-04-30 00:00:00   2019-10-29 00:00:00   2017-08-02 00:00:00   2017-08-02 00:00:00   2017-08-11 00:00:00   2017-10-30 00:00:00   2018-10-30 00:00:00   2020-11-02 00:00:00   2020-01-30 00:00:00   2018-10-31 00:00:00   2018-05-21 00:00:00   2019-01-16 00:00:00   2021-02-01 00:00:00   2018-11-06 00:00:00   2018-07-31 00:00:00   2018-10-30 00:00:00   2021-02-11 00:00:00   2020-07-31 00:00:00   2020-04-30 00:00:00   2022-04-29 00:00:00   2021-07-29 00:00:00   2021-10-30 00:00:00   2021-01-21 00:00:00   2022-07-29 00:00:00   2022-01-29 00:00:00   2021-04-29 00:00:00   2022-10-30 00:00:00
stmnt_type   10001   10002   10001   10001   10001   10001   10001   10005   10005   10001   10001   10001   10001   10001   10006   10005   10001   10001   10002   10001   10002   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001
stmnt_status   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11003   11001   11001   11003
session_id   2019   2017   2017   2017   2017   2019   2019   2017   2017   2017   2017   2017   2019   2019   2017   2017   2019   2019   2017   2017   2017   2021   2019   2019   2021   2021   2021   2021   2021   2021   2021   2021
user_id   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   SUSHAKOV   SUSHAKOV   GPEREZ   GPEREZ   YRODRIGU   AGLADNEY   AGLADNEY   GTAYLOR   GTAYLOR   YRODRIGU   YRODRIGU   YRODRIGU   GTAYLOR   AGLADNEY   AGLADNEY   AGLADNEY   AROJAS   GTAYLOR   GTAYLOR   CAFILER   CHATRIDGE   GTAYLOR   AROJAS   CAFILER   CHATRIDGE   GTAYLOR   CAFILER
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
fine_audit   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11001   11001   11001   11001   11003   11003   11003   11001   11001   11001   11001   11003   11001   11001   11003   11001   11001   11003   11003   11001   11001   11003
rpt_start   2019-04-01 00:00:00   2018-04-01 00:00:00   2017-10-01 00:00:00   2018-10-01 00:00:00   2018-01-01 00:00:00   2019-01-01 00:00:00   2019-07-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2017-08-11 00:00:00   2017-07-01 00:00:00   2018-07-01 00:00:00   2020-07-01 00:00:00   2019-10-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2020-10-01 00:00:00   2018-07-01 00:00:00   2018-04-01 00:00:00   2018-07-01 00:00:00   2021-02-11 00:00:00   2020-04-01 00:00:00   2020-01-01 00:00:00   2022-01-01 00:00:00   2021-04-01 00:00:00   2021-07-01 00:00:00   1900-01-01 00:00:00   2022-04-01 00:00:00   2021-10-01 00:00:00   2021-01-01 00:00:00   2022-07-01 00:00:00
rpt_end   2019-06-30 00:00:00   2018-06-30 00:00:00   2017-12-31 00:00:00   2018-12-31 00:00:00   2018-03-31 00:00:00   2019-03-31 00:00:00   2019-09-30 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2017-08-11 00:00:00   2017-09-30 00:00:00   2018-09-30 00:00:00   2020-09-30 00:00:00   2019-12-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2020-12-31 00:00:00   2018-09-30 00:00:00   2018-06-30 00:00:00   2018-09-30 00:00:00   2021-02-11 00:00:00   2020-06-30 00:00:00   2020-03-31 00:00:00   2022-03-31 00:00:00   2021-06-30 00:00:00   2021-09-30 00:00:00   1900-01-01 00:00:00   2022-06-30 00:00:00   2021-12-31 00:00:00   2021-03-31 00:00:00   2022-09-30 00:00:00
rpt_date   None   None   None   None   None   None   None   None   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_type   22006   22006   22006   22006   22006   22006   22006   None   None   22006   22006   22006   22006   22006   None   None   None   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   22006
Table: filer_interests
filer_id   1397939   1397939   1397939   1397939
session_id   2017   2019   2023   2021
interest_cd   40302   40302   40302   40302
effect_date   2017-08-01 00:00:00   2019-01-01 00:00:00   2023-01-01 00:00:00   2021-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1397939   1397939   1397939   1397939
filer_type   1   1   1   1
active   Y   Y   Y   N
race   None   0   None   None
session_id   2019   2017   2021   2023
category   None   0   None   None
category_type   None   0   None   None
sub_category   None   0   None   None
effect_dt   2019-01-01 00:00:00   2017-08-01 00:00:00   2021-01-01 00:00:00   2023-01-01 00:00:00
sub_category_type   None   0   None   None
election_type   None   0   None   None
sub_category_a   None   None   None   None
nyq_dt   None   None   None   None
party_cd   None   0   None   None
county_cd   None   0   None   None
district_cd   None   0   None   None
Table: filer_xref
filer_id   1397939
xref_id   1397939
effect_dt   2017-08-03 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939
filer_id   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939   1397939
filer_type   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT
status   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE
effect_dt   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00
naml   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES
namf   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
adr1   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
adr2   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
city   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO
st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
zip4   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811
phon   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222   8663253222
fax   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
email   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: filers
filer_id   1397939
Table: lobbying_chg_log
filer_id   1397939   1397939
change_no   0   1
session_id   2017   2017
log_dt   2017-08-02 00:00:00   2018-05-01 00:00:00
filer_type   2   2
correction_flg   Y   Y
action   ADDED   ADDED
attribute_changed   FIRM   FIRM
ethics_dt   None   None
interests   None   None
filer_full_name   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES   FOUNDATION FOR CALIFORNIA COMMUNITY COLLEGES
filer_city   None   SACRAMENTO
filer_st   None   CA
filer_zip   None   95811
filer_phone   None   8663253222
entity_type   3   3
entity_name   CALIFORNIA STRATEGIES & ADVOCACY, LLC   ZAMARRIPA CONSULTING; KAREN
entity_city   None   None
entity_st   None   None
entity_zip   None   None
entity_phone   None   None
entity_id   1273600   None
responsible_officer   None   None
effect_dt   2017-08-01 00:00:00   2018-02-01 00:00:00