Home

Filer ID: 1403261

Table: cvr_lobby_disclosure
filing_id   2277425   2243237   2350488   2321309   2382128   2400294   2444422   2420200   2471779   2531256   2484385   2555080   2604129   2581907   2625246   2678383   2645959   2708517   2749603
amend_id   0   0   0   0   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
form_type   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635
sender_id   1252620   1252620   1252620   1252620   1252620   1252620   1252620   1252620   1252620   1252620   1252620   1252620   1252620   1252620   1252620   1252620   1252620   1252620   1252620
filer_id   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261
entity_cd   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM
filer_naml   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN
filer_namf   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
filer_nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
report_num   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000
rpt_date   2018-07-31 00:00:00   2018-04-30 00:00:00   2019-01-31 00:00:00   2018-10-31 00:00:00   2019-04-30 00:00:00   2019-07-31 00:00:00   2020-01-31 00:00:00   2019-10-31 00:00:00   2020-04-30 00:00:00   2020-11-02 00:00:00   2020-07-30 00:00:00   2021-02-01 00:00:00   2021-08-02 00:00:00   2021-04-30 00:00:00   2021-11-01 00:00:00   2022-05-02 00:00:00   2022-01-31 00:00:00   2022-08-01 00:00:00   2022-10-31 00:00:00
from_date   2018-04-01 00:00:00   2018-01-01 00:00:00   2018-10-01 00:00:00   2018-07-01 00:00:00   2019-01-01 00:00:00   2019-04-01 00:00:00   2019-10-01 00:00:00   2019-07-01 00:00:00   2020-01-01 00:00:00   2020-07-01 00:00:00   2020-04-01 00:00:00   2020-10-01 00:00:00   2021-04-01 00:00:00   2021-01-01 00:00:00   2021-07-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   2018-06-30 00:00:00   2018-03-31 00:00:00   2018-12-31 00:00:00   2018-09-30 00:00:00   2019-03-31 00:00:00   2019-06-30 00:00:00   2019-12-31 00:00:00   2019-09-30 00:00:00   2020-03-31 00:00:00   2020-09-30 00:00:00   2020-06-30 00:00:00   2020-12-31 00:00:00   2021-06-30 00:00:00   2021-03-31 00:00:00   2021-09-30 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   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   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   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261
firm_name   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN
firm_city   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES
firm_st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
firm_zip4   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049
firm_phon   800-485-9196   800-485-9196   800-485-9196   800-485-9196   800-485-9196   800-485-9196   800-485-9196   800-485-9196   800-485-9196   800-485-9196   800-485-9196   800-485-9196   800-485-9196   800-485-9196   800-485-9196   800-485-9196   800-485-9196   800-485-9196   800-485-9196
mail_city   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
mail_zip4   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
sig_date   2018-07-31 00:00:00   2018-04-30 00:00:00   2019-01-31 00:00:00   2018-10-31 00:00:00   2019-04-30 00:00:00   2019-07-31 00:00:00   2020-01-31 00:00:00   2019-10-31 00:00:00   2020-04-30 00:00:00   2020-11-02 00:00:00   2020-07-30 00:00:00   2021-02-01 00:00:00   2021-08-02 00:00:00   2021-04-30 00:00:00   2021-11-01 00:00:00   2022-05-02 00:00:00   2022-01-31 00:00:00   2022-08-01 00:00:00   2022-10-31 00:00:00
sig_loc   Los Angeles CA   Los Angeles CA   LOS ANGELES CA   LOS ANGELES CA   LOS ANGELES CA   LOS ANGELES CA   Los Angeles CA   LOS ANGELES CA   LOS ANGELES CA   Los Angeles CA   LOS ANGELES CALIFORNIA   LOS ANGELES CA   LOS ANGELES CALIFORNIA   LOS ANGELES CA   LOS ANGELES CALIFORNIA   LOS ANGELES CALIFORNIA   LOS ANGELES CALIFORNIA   LOS ANGELES CALIFORNIA   LOS ANGELES CA
sig_naml   Hollister   Hollister   ANN   HOLLISTER   HOLLISTER   HOLLISTER   Hollister   HOLLISTER   HOLLISTER   Hollister   HOLLISTER   HOLLISTER   HOLLISTER   HOLLISTER   HOLLISTER   HOLLISTER   ANN   HOLLISTER   HOLLISTER
sig_namf   Ann   Ann   HOLLISTER   ANN   ANN   ANN   Ann   ANN   ANN   Ann   ANN   ANN   ANN   ANN   ANN   ANN   HOLLISTER   ANN   ANN
sig_namt   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
prn_naml   Hollister   Hollister   ANN   HOLLISTER   HOLLISTER   HOLLISTER   Hollister   HOLLISTER   HOLLISTER   Hollister   HOLLISTER   HOLLISTER   HOLLISTER   HOLLISTER   HOLLISTER   HOLLISTER   ANN   HOLLISTER   HOLLISTER
prn_namf   Ann   Ann   HOLLISTER   ANN   ANN   ANN   Ann   ANN   ANN   Ann   ANN   ANN   ANN   ANN   ANN   ANN   HOLLISTER   ANN   ANN
prn_namt   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
sig_title   Executive Director   Executive Director   EXECUTIVE DIRECTOR   EXECUTIVE DIRECTOR   EXECUTIVE DIRECTOR   EXECUTIVE DIRECTOR   Executive Director   EXECUTIVE DIRECTOR   EXECUTIVE DIRECTOR   Executive Director   EXECUTIVE DIRECTOR   EXECUTIVE DIRECTOR   PRESIDENT   EXECUTIVE DIRECTOR   PRESIDENT   PRESIDENT   PRESIDENT   PRESIDENT   PRESIDENT
nopart1_cb   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
part1_1_cb   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
ctrib_n_cb   X   None   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X
ctrib_y_cb   None   X   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
lby_actvty   Legislature: AB 2904 SB 839   Legislature: Budget appropriation for mobile optometry services to students in low-income communities.   None this period.   Legislature: AB 2904   None this period.   Legislature: AB 714   Legislature: AB 896   Legislature: AB 896   Legislature: AB 896   Legislature: AB 896   Legislature: AB 896   Legislature: AB 896   Legislature regarding medical billing issues   Legislature regarding medical billing issues   Legislature regarding AB 134   None this period   None this period   None this period   None this period
lobby_n_cb   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
major_naml   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
major_namt   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
rcpcmte_nm   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
Table: cvr_registration
filing_id   2586528
amend_id   0
rec_type   CVR
form_type   F602
sender_id   F00933
filer_id   1403261
entity_cd   LEM
filer_naml   VISION TO LEARN
filer_namf   None
filer_namt   None
filer_nams   None
report_num   000
rpt_date   2021-06-03 00:00:00
ls_beg_yr   2021
ls_end_yr   2022
qual_date   None
eff_date   2021-05-28 00:00:00
bus_city   LOS ANGELES
bus_st   CA
bus_zip4   90025
bus_phon   800 485-9196
bus_fax   None
bus_email   None
mail_city   None
mail_st   None
mail_zip4   None
mail_phon   None
sig_date   2021-05-28 00:00:00
sig_loc   LOS ANGELES, CA
sig_naml   HOLLISTER
sig_namf   ANN
sig_namt   None
sig_nams   None
prn_naml   HOLLISTER
prn_namf   ANN
prn_namt   None
prn_nams   None
sig_title   PRESIDENT
stmt_firm   None
ind_cb   None
bus_cb   None
trade_cb   None
oth_cb   X
a_b_name   None
a_b_city   None
a_b_st   None
a_b_zip4   None
descrip_1   NON-PROFIT
descrip_2   ORGANIZATION FOUNDED TO MAKE SURE EVERY CHILD HAS GLASSES THEY NEED TO SUCCEED IN SCHOOL AND IN LIFE
c_less50   None
c_more50   None
ind_class   HEA
ind_descr   None
bus_class   None
bus_descr   None
auth_name   NIELSEN MERKSAMER PARRINELLO GROSS & LEONI, LLP
auth_city   SACRAMENTO
auth_st   CA
auth_zip4   95814
lobby_int   None
influen_yn   None
firm_name   None
newcert_cb   None
rencert_cb   None
complet_dt   None
lby_reg_cb   None
lby_604_cb   None
st_leg_yn   None
st_agency   None
lobby_cb   None
l_firm_cb   None
Table: filer_address
filer_id   1403261   1403261   1403261   1403261
adrid   2504809   2470288   2447256   2548221
effect_dt   2021-01-01 00:00:00   2019-01-02 00:00:00   2018-02-14 00:00:00   2023-01-01 00:00:00
add_type   7051   7051   7051   7051
session_id   2021   2019   2017   2023
Table: filer_filings
filer_id   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261
filing_id   2420200   2243237   2471779   2277425   2484385   2531256   2321309   2350488   2400294   2555080   2581907   2220349   2220351   2382128   2366374   2604129   2645959   2444422   2586528   2584241   2708517   2678383   2613646   2625246   2749603
period_id   239   233   241   234   242   243   235   236   238   244   245   None   None   237   None   246   248   240   246   None   250   249   None   247   251
form_id   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F999   F635   F602   F635   F635   F635   F602   F602   F635   F635   F602   F635   F635
filing_sequence   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
filing_date   2019-10-31 00:00:00   2018-04-30 00:00:00   2020-04-30 00:00:00   2018-07-31 00:00:00   2020-07-30 00:00:00   2020-11-02 00:00:00   2018-10-31 00:00:00   2019-01-31 00:00:00   2019-07-31 00:00:00   2021-02-01 00:00:00   2021-05-01 00:00:00   2018-03-07 00:00:00   2018-03-07 00:00:00   2019-04-30 00:00:00   2019-02-15 00:00:00   2021-08-02 00:00:00   2022-01-31 00:00:00   2020-01-31 00:00:00   2021-06-03 00:00:00   2021-01-21 00:00:00   2022-08-01 00:00:00   2022-05-02 00:00:00   2021-06-03 00:00:00   2021-11-01 00:00:00   2022-10-31 00:00:00
stmnt_type   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10005   10001   10005   10001   10001   10001   10001   10005   10001   10001   10005   10001   10001
stmnt_status   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11001   11003
session_id   2019   2017   2019   2017   2019   2019   2017   2017   2019   2019   2021   2017   2017   2019   2019   2021   2021   2019   2021   2021   2021   2021   2021   2021   2021
user_id   SUSHAKOV   AGLADNEY   GTAYLOR   AGLADNEY   GTAYLOR   GTAYLOR   AGLADNEY   AGLADNEY   VUKSTINA   GTAYLOR   GTAYLOR   GPEREZ   GPEREZ   VUKSTINA   SARRIAGA   MKIRKHAM   CHATRIDGE   AGLADNEY   MKIRKHAM   MKIRKHAM   CAFILER   CAFILER   MKIRKHAM   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
fine_audit   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11003   11001   11001   11001   11003   11003   11003   11003   11003   11001   11003
rpt_start   2019-07-01 00:00:00   2018-01-01 00:00:00   2020-01-01 00:00:00   2018-04-01 00:00:00   2020-04-01 00:00:00   2020-07-01 00:00:00   2018-07-01 00:00:00   2018-10-01 00:00:00   2019-04-01 00:00:00   2020-10-01 00:00:00   2021-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2019-01-01 00:00:00   1900-01-01 00:00:00   2021-04-01 00:00:00   2021-10-01 00:00:00   2019-10-01 00:00:00   2021-06-03 00:00:00   1900-01-01 00:00:00   2022-04-01 00:00:00   2022-01-01 00:00:00   1900-01-01 00:00:00   2021-07-01 00:00:00   2022-07-01 00:00:00
rpt_end   2019-09-30 00:00:00   2018-03-31 00:00:00   2020-03-31 00:00:00   2018-06-30 00:00:00   2020-06-30 00:00:00   2020-09-30 00:00:00   2018-09-30 00:00:00   2018-12-31 00:00:00   2019-06-30 00:00:00   2020-12-31 00:00:00   2021-03-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2019-03-31 00:00:00   1900-01-01 00:00:00   2021-06-30 00:00:00   2021-12-31 00:00:00   2019-12-31 00:00:00   2021-06-03 00:00:00   1900-01-01 00:00:00   2022-06-30 00:00:00   2022-03-31 00:00:00   1900-01-01 00:00:00   2021-09-30 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
filing_type   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   None   22001   None   22001   22001   22001   22001   None   22001   22001   None   22001   22001
Table: filer_interests
filer_id   1403261   1403261   1403261   1403261
session_id   2017   2019   2021   2023
interest_cd   40306   40306   40306   40306
effect_date   2018-02-14 00:00:00   2019-01-02 00:00:00   2021-01-01 00:00:00   2023-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1403261   1403261   1403261   1403261
filer_type   1   1   1   1
active   Y   Y   Y   N
race   None   0   None   None
session_id   2021   2017   2019   2023
category   None   0   None   None
category_type   None   0   None   None
sub_category   None   0   None   None
effect_dt   2021-01-01 00:00:00   2018-02-14 00:00:00   2019-01-02 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   1403261
xref_id   1403261
effect_dt   2018-03-05 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261
filer_id   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261
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   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN
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   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES
st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
zip4   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049   90049
phon   8004859196   8004859196   8004859196   8004859196   8004859196   8004859196   8004859196   8004859196   8004859196   8004859196   8004859196   8004859196   8004859196   8004859196   8004859196   8004859196
fax   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
email   None   None   [email protected]   [email protected]   None   None   [email protected]   [email protected]   None   None   [email protected]   [email protected]   None   None   [email protected]   [email protected]
Table: filers
filer_id   1403261
Table: lobbying_chg_log
filer_id   1403261   1403261   1403261
change_no   2   1   0
session_id   2017   2017   2017
log_dt   2018-03-07 00:00:00   2018-03-07 00:00:00   2018-03-07 00:00:00
filer_type   2   1   1
correction_flg   Y   None   None
action   ADDED   SET ACTIVE   ADDED
attribute_changed   FIRM      FIRM
ethics_dt   None   None   None
interests   None   None   None
filer_full_name   VISION TO LEARN   VISION TO LEARN   VISION TO LEARN
filer_city   LOS ANGELES   None   None
filer_st   CA   None   None
filer_zip   90049   None   None
filer_phone   8004859196   None   None
entity_type   3   1   3
entity_name   KESTER/PAHOS   None   KESTER/PAHOS
entity_city   None   None   None
entity_st   None   None   None
entity_zip   None   None   None
entity_phone   None   None   None
entity_id   None   0   1252620
responsible_officer   None   None   None
effect_dt   2018-02-14 00:00:00   2018-02-14 00:00:00   2018-02-14 00:00:00
Table: received_filings
filer_id   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261   1403261
filing_file_name   2243237_0.cal   2471779_0.cal   2382128_0.cal   2277425_0.cal   2484385_0.cal   2350488_0.cal   2321309_0.cal   2444422_0.cal   2420200_0.cal   2400294_0.cal   2645959_0.cal   2749603_0.cal   2678383_0.cal   2531256_0.cal   432580.cal   2581907_0.cal   2708517_0.cal   2555080_0.cal   2604129_0.cal   2625246_0.cal
received_date   2018-04-30 00:00:00   2020-04-30 00:00:00   2019-04-30 00:00:00   2018-07-31 00:00:00   2020-07-30 00:00:00   2019-01-31 00:00:00   2018-10-31 00:00:00   2020-01-31 00:00:00   2019-10-31 00:00:00   2019-07-31 00:00:00   2022-01-31 00:00:00   2022-10-31 00:00:00   2022-05-02 00:00:00   2020-11-02 00:00:00   2020-11-02 00:00:00   2021-05-01 00:00:00   2022-08-01 00:00:00   2021-02-01 00:00:00   2021-08-02 00:00:00   2021-11-01 00:00:00
filing_directory   /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/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   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal
filing_id   2243237   2471779   2382128   2277425   2484385   2350488   2321309   2444422   2420200   2400294   2645959   2749603   2678383   2531256   None   2581907   2708517   2555080   2604129   2625246
form_id   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   None   F635   F635   F635   F635   F635
receive_comment   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing passed validation, but failed DB constraints   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted