| filing_id | 2276797 | 2276797 | 2319271 | 2349251 | 2381029 | 2381029 | 2319271 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 1 | 0 | 0 | 0 | 1 | 1 | |||||||
| rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||
| form_type | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||
| sender_id | F00799 | 1408245 | F00799 | F00799 | F00799 | F00799 | 1408245 | |||||||
| filer_id | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | |||||||
| entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | |||||||
| filer_naml | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | Non-Profit Housing Association of Northern California and Affiliated Entity NPH Action | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | |||||||
| filer_namf | None | None | None | None | None | None | None | |||||||
| filer_namt | None | None | None | None | None | None | None | |||||||
| filer_nams | None | None | None | None | None | None | None | |||||||
| report_num | 000 | 001 | 000 | 000 | 000 | 001 | 001 | |||||||
| rpt_date | 2018-07-31 00:00:00 | 2018-08-10 00:00:00 | 2018-10-30 00:00:00 | 2019-01-29 00:00:00 | 2019-04-18 00:00:00 | 2019-04-18 00:00:00 | 2018-12-21 00:00:00 | |||||||
| from_date | 2018-04-01 00:00:00 | 2018-04-01 00:00:00 | 2018-07-01 00:00:00 | 2018-10-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2018-07-01 00:00:00 | |||||||
| thru_date | 2018-06-30 00:00:00 | 2018-06-30 00:00:00 | 2018-09-30 00:00:00 | 2018-12-31 00:00:00 | 2019-03-31 00:00:00 | 2019-03-31 00:00:00 | 2018-09-30 00:00:00 | |||||||
| cum_beg_dt | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2018-01-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2018-01-01 00:00:00 | |||||||
| firm_id | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | None | |||||||
| firm_name | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | Non-Profit Housing Association of Northern California and Affiliated Entity NPH Action | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | None | |||||||
| firm_city | SAN FRANCISCO | San Francisco | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | |||||||
| firm_st | CA | CA | CA | CA | CA | CA | CA | |||||||
| firm_zip4 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | |||||||
| firm_phon | 415-989-8160 | (415) 989-8160 | 415-989-8160 | 415-989-8160 | 415-989-8160 | 415-989-8160 | 4159898160 | |||||||
| mail_city | None | None | None | None | None | None | None | |||||||
| mail_st | None | None | None | None | None | None | None | |||||||
| mail_zip4 | None | None | None | None | None | None | None | |||||||
| mail_phon | None | None | None | None | None | None | None | |||||||
| sig_date | 2018-07-30 00:00:00 | 2018-08-10 00:00:00 | 2018-10-31 00:00:00 | 2019-01-31 00:00:00 | 2017-07-03 00:00:00 | 2019-04-30 00:00:00 | 2018-12-21 00:00:00 | |||||||
| sig_loc | SAN FRANCISCO CA | San Francisco, CA | SAN FRANCISCO CA | SAN FRANCISCO CA | SAN FRANCISCO CA | SAN FRANCISCO CA | San Francisco, CA | |||||||
| sig_naml | STARRET | Fishman | FISHMAN | STARRETT | STARRETT | FISHMAN | Fishman | |||||||
| sig_namf | JR | Amie | AMIE | JR | JR | AMIE | Amie | |||||||
| sig_namt | None | None | None | None | None | MS. | None | |||||||
| sig_nams | None | None | None | None | None | None | None | |||||||
| prn_naml | STARRET | Fishman | FISHMAN | STARRETT | STARRETT | FISHMAN | Fishman | |||||||
| prn_namf | JR | Amie | AMIE | JR | JR | AMIE | Amie | |||||||
| prn_namt | None | None | None | None | None | MS. | None | |||||||
| prn_nams | None | None | None | None | None | None | None | |||||||
| sig_title | Director of Advocacy and Community Engagement | Executive Director | EXECUTIVE DIRECTOR | Director of Advocacy and Community Engagement | Director of Advocacy and Community Engagement | EXECUTIVE DIRECTOR | Executive Director | |||||||
| nopart1_cb | None | None | None | None | None | None | None | |||||||
| nopart2_cb | None | None | None | None | None | None | None | |||||||
| part1_1_cb | None | None | None | None | None | None | None | |||||||
| part1_2_cb | None | None | None | None | None | None | None | |||||||
| ctrib_n_cb | X | X | X | X | X | X | X | |||||||
| ctrib_y_cb | None | None | None | None | None | None | None | |||||||
| lby_actvty | GOVERNOR'S OFFICE RE AB 863 | AB 1792, 2035, 2065, 2562, 2923, 3194; SB 827, 828 | GOVERNOR'S OFFICE RE AB 863 | NONE | NONE - CLIENT NO LONGER REGISTERED. PAYMENT FOR WORK DONE IN PREVIOUS QUARTER 2018 | NONE - CLIENT NO LONGER REGISTERED. PAYMENT FOR WORK DONE IN PREVIOUS QUARTER 2018 | GOVERNOR'S OFFICE RE AB 863 | |||||||
| lobby_n_cb | None | None | None | None | None | None | None | |||||||
| lobby_y_cb | None | None | None | None | None | None | None | |||||||
| major_naml | None | None | None | None | None | None | None | |||||||
| major_namf | None | None | None | None | None | None | None | |||||||
| major_namt | None | None | None | None | None | None | None | |||||||
| major_nams | None | None | None | None | None | None | None | |||||||
| rcpcmte_nm | None | None | None | None | None | None | None | |||||||
| rcpcmte_id | None | None | None | None | None | None | None |
| filing_id | 2292589 | 2292589 | 2292589 | 2368224 | 2385104 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 1 | 0 | 2 | 0 | 0 | |||||
| rec_type | CVR | CVR | CVR | CVR | CVR | |||||
| form_type | F603 | F603 | F603 | F606 | F602 | |||||
| sender_id | 1408245 | 1408245 | 1408245 | 1408245 | 1402149 | |||||
| filer_id | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | |||||
| entity_cd | LEM | LEM | LEM | LEM | LEM | |||||
| filer_naml | Non-Profit Housing Association of Northern California and Affiliated Entity NPH Action | Non-Profit Housing Association of Northern California and Affiliated Entity NPH Action | Non-Profit Housing Association of Northern California and Affiliated Entity NPH Action | Non-Profit Housing Association of Northern California and Affiliated Entity NPH Action | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | |||||
| filer_namf | None | None | None | None | None | |||||
| filer_namt | None | None | None | None | None | |||||
| filer_nams | None | None | None | None | None | |||||
| report_num | 001 | 000 | 002 | 000 | 000 | |||||
| rpt_date | 2018-10-28 00:00:00 | 2018-08-09 00:00:00 | 2018-12-21 00:00:00 | 2018-12-31 00:00:00 | 2019-04-03 00:00:00 | |||||
| ls_beg_yr | 2018 | 2018 | 2018 | 2018 | 2019 | |||||
| ls_end_yr | 2018 | 2018 | 2018 | 2018 | 2020 | |||||
| qual_date | 2018-06-30 00:00:00 | 2018-06-30 00:00:00 | None | None | None | |||||
| eff_date | None | None | None | 2018-12-31 00:00:00 | 2019-04-01 00:00:00 | |||||
| bus_city | San Francisco | San Francisco | San Francisco | San Francisco | SAN FRANCISCO | |||||
| bus_st | CA | CA | CA | CA | CA | |||||
| bus_zip4 | 94104 | 94104 | 94104 | 94104 | 94104 | |||||
| bus_phon | (415) 989-8160 | (415) 989-8160 | (415) 989-8160 | (415) 989-8160 | (415) 989-8160 | |||||
| bus_fax | None | None | None | None | None | |||||
| bus_email | [email protected] | [email protected] | [email protected] | [email protected] | None | |||||
| mail_city | None | None | None | None | None | |||||
| mail_st | None | None | None | None | None | |||||
| mail_zip4 | None | None | None | None | None | |||||
| mail_phon | None | None | None | None | None | |||||
| sig_date | 2018-10-28 00:00:00 | 2018-08-09 00:00:00 | 2019-01-29 00:00:00 | 2019-01-29 00:00:00 | 2019-04-03 00:00:00 | |||||
| sig_loc | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | SAN FRANCISCO, CA | |||||
| sig_naml | Fishman | Fishman | Fishman | Fishman | FISHMAN | |||||
| sig_namf | Amie | Amie | Amie | Amie | AMIE | |||||
| sig_namt | None | None | None | None | None | |||||
| sig_nams | None | None | None | None | None | |||||
| prn_naml | Fishman | Fishman | Fishman | Fishman | FISHMAN | |||||
| prn_namf | Amie | Amie | Amie | Amie | AMIE | |||||
| prn_namt | None | None | None | None | None | |||||
| prn_nams | None | None | None | None | None | |||||
| sig_title | Executive Director | Executive Director | Executive Director | Executive Director | EXECUTIVE DIRECTOR | |||||
| stmt_firm | None | None | None | None | None | |||||
| ind_cb | None | None | None | None | None | |||||
| bus_cb | None | None | None | None | None | |||||
| trade_cb | X | X | X | None | None | |||||
| oth_cb | None | None | None | None | X | |||||
| a_b_name | None | None | None | None | None | |||||
| a_b_city | None | None | None | None | None | |||||
| a_b_st | None | None | None | None | None | |||||
| a_b_zip4 | None | None | None | None | None | |||||
| descrip_1 | Representing members affiliated with affordable housing industry. | Representing members affiliated with affordable housing industry. | Representing members affiliated with affordable housing industry. | None | NON-PROFIT HOUSING ORGANIZATION | |||||
| descrip_2 | Representing members affiliated with affordable housing industry. | Representing members affiliated with affordable housing industry. | Representing members affiliated with affordable housing industry. | None | NON-PROFIT ORGANIZATION | |||||
| c_less50 | None | None | None | None | None | |||||
| c_more50 | X | X | X | None | None | |||||
| ind_class | OTH | OTH | OTH | None | None | |||||
| ind_descr | Affordable Housing | Affordable Housing | Affordable Housing | None | None | |||||
| bus_class | None | None | None | None | OTH | |||||
| bus_descr | None | None | None | None | NON-PROFIT | |||||
| auth_name | None | None | None | None | LIGHTHOUSE PUBLIC AFFAIRS, LLC | |||||
| auth_city | None | None | None | None | SACRAMENTO | |||||
| auth_st | None | None | None | None | CA | |||||
| auth_zip4 | None | None | None | None | 95814 | |||||
| lobby_int | Production and preservation of affordable housing. | Production and preservation of affordable housing. | Production and preservation of affordable housing. | None | None | |||||
| influen_yn | Y | Y | Y | None | None | |||||
| firm_name | None | None | None | None | None | |||||
| newcert_cb | None | None | None | None | None | |||||
| rencert_cb | None | None | None | None | None | |||||
| complet_dt | None | None | None | None | None | |||||
| lby_reg_cb | None | None | None | None | None | |||||
| lby_604_cb | None | None | None | None | None | |||||
| st_leg_yn | None | None | None | None | None | |||||
| st_agency | None | None | None | None | None | |||||
| lobby_cb | None | None | None | None | None | |||||
| l_firm_cb | None | None | None | None | None |
| acronym | NPH | |
|---|---|---|
| filer_id | 1408245 |
| filer_id | 1408245 | |
|---|---|---|
| adrid | 2456357 | |
| effect_dt | 2018-06-26 00:00:00 | |
| add_type | 7051 | |
| session_id | 2017 |
| filer_id | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 2292589 | 2349251 | 2306577 | 2368719 | 2283524 | 2292589 | 2319271 | 2385104 | 2292589 | 2368224 | 2319271 | 2293989 | 2276797 | 2276797 | 2381029 | 2325042 | 2381029 | |||||||||||||||||
| period_id | 235 | 236 | None | None | None | 236 | 235 | 238 | 236 | 236 | 235 | None | 234 | 234 | 237 | None | 237 | |||||||||||||||||
| form_id | F603 | F635 | F603 | F605 | F602 | F603 | F635 | F602 | F603 | F606 | F635 | F603 | F635 | F635 | F635 | F605 | F635 | |||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | |||||||||||||||||
| filing_date | 2018-09-17 00:00:00 | 2019-01-31 00:00:00 | 2018-10-11 00:00:00 | 2019-03-21 00:00:00 | 2018-08-10 00:00:00 | 2018-11-07 00:00:00 | 2018-10-31 00:00:00 | 2019-05-30 00:00:00 | 2019-03-20 00:00:00 | 2019-03-20 00:00:00 | 2018-12-21 00:00:00 | 2018-09-14 00:00:00 | 2018-07-31 00:00:00 | 2018-09-22 00:00:00 | 2019-06-17 00:00:00 | 2018-11-06 00:00:00 | 2019-04-30 00:00:00 | |||||||||||||||||
| stmnt_type | 10001 | 10001 | 10005 | 10005 | 10005 | 10002 | 10001 | 10001 | 10002 | 10001 | 10002 | 10005 | 10001 | 10002 | 10002 | 10005 | 10001 | |||||||||||||||||
| stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | |||||||||||||||||
| session_id | 2018 | 2017 | 2017 | 2017 | 2017 | 2018 | 2017 | 2019 | 2018 | 2018 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | |||||||||||||||||
| user_id | YRODRIGU | AGLADNEY | YRODRIGU | GPEREZ | YRODRIGU | GPEREZ | AGLADNEY | GPEREZ | CAFILER | CAFILER | AGLADNEY | YRODRIGU | YRODRIGU | AGLADNEY | SUSHAKOV | GPEREZ | SUSHAKOV | |||||||||||||||||
| special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||
| fine_audit | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | |||||||||||||||||
| rpt_start | 2018-08-09 00:00:00 | 2018-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-28 00:00:00 | 2018-07-01 00:00:00 | 2019-04-03 00:00:00 | 2018-12-21 00:00:00 | 2018-12-31 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2018-04-01 00:00:00 | 2018-04-01 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-01-01 00:00:00 | |||||||||||||||||
| rpt_end | 2018-08-09 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-28 00:00:00 | 2018-09-30 00:00:00 | 2019-04-03 00:00:00 | 2018-12-21 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2018-06-30 00:00:00 | 2018-06-30 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-03-31 00:00:00 | |||||||||||||||||
| rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||
| filing_type | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | None | 22001 | 22001 | 22001 | None | 22001 |
| filer_id | 1408245 | |
|---|---|---|
| session_id | 2017 | |
| interest_cd | 40312 | |
| effect_date | 2018-06-26 00:00:00 |
| filer_id | 1408245 | 1408245 | 1408245 | |||
|---|---|---|---|---|---|---|
| filer_type | 2 | 1 | 2 | |||
| active | Y | Y | N | |||
| race | 0 | 0 | None | |||
| session_id | 2017 | 2017 | 2019 | |||
| category | 0 | 0 | None | |||
| category_type | 0 | 0 | None | |||
| sub_category | 0 | 0 | None | |||
| effect_dt | 2018-06-30 00:00:00 | 2018-06-26 00:00:00 | 2019-01-01 00:00:00 | |||
| sub_category_type | 0 | 0 | None | |||
| election_type | 0 | 0 | None | |||
| sub_category_a | None | None | None | |||
| nyq_dt | None | None | None | |||
| party_cd | 0 | 0 | None | |||
| county_cd | 0 | 0 | None | |||
| district_cd | 0 | 0 | None |
| filer_id | 1408245 | |
|---|---|---|
| xref_id | 1408245 | |
| effect_dt | 2018-07-31 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1408245 | 1408245 | ||
|---|---|---|---|---|
| filer_id | 1408245 | 1408245 | ||
| filer_type | EMPLOYER | EMPLOYER | ||
| status | INACTIVE | INACTIVE | ||
| effect_dt | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | ||
| naml | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA | ||
| namf | None | None | ||
| namt | None | None | ||
| nams | None | None | ||
| adr1 | None | None | ||
| adr2 | None | None | ||
| city | SAN FRANCISCO | SAN FRANCISCO | ||
| st | CA | CA | ||
| zip4 | 94104 | 94104 | ||
| phon | 4159898160 | 4159898160 | ||
| fax | None | None | ||
| [email protected] | [email protected] |
| filer_id | 1408245 |
|---|
| filer_id | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| change_no | 4 | 0 | 2 | 1 | 3 | |||||
| session_id | 2019 | 2019 | 2017 | 2017 | 2017 | |||||
| log_dt | 2019-05-01 00:00:00 | 2019-05-01 00:00:00 | 2018-10-11 00:00:00 | 2018-08-10 00:00:00 | 2019-03-21 00:00:00 | |||||
| filer_type | 2 | 1 | 2 | 2 | 2 | |||||
| correction_flg | None | None | Y | Y | None | |||||
| action | SET ACTIVE | ADDED | ADDED | ADDED | DELETED | |||||
| attribute_changed | FIRM | LOBBYIST | FIRM | LOBBYIST | ||||||
| ethics_dt | None | None | None | None | None | |||||
| interests | None | None | None | None | None | |||||
| filer_full_name | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | NON-PROFIT HOUSING ASSOCIATION OF NORTHERN CALIFORNIA AND AFFILIATED ENTITY NPH ACTION | |||||
| filer_city | None | None | SAN FRANCISCO | SAN FRANCISCO | None | |||||
| filer_st | None | None | CA | CA | None | |||||
| filer_zip | None | None | 94104 | 94104 | None | |||||
| filer_phone | None | None | 4159898160 | 4159898160 | None | |||||
| entity_type | 2 | 3 | 4 | 3 | 4 | |||||
| entity_name | None | LIGHTHOUSE PUBLIC AFFAIRS, LLC | LANE, MICHAEL | SACRAMENTO ADVOCATES INC. | MICHAEL LANE | |||||
| entity_city | None | None | None | None | None | |||||
| entity_st | None | None | None | None | None | |||||
| entity_zip | None | None | None | None | None | |||||
| entity_phone | None | None | None | None | None | |||||
| entity_id | 0 | 1402149 | None | None | 1411874 | |||||
| responsible_officer | None | None | None | None | None | |||||
| effect_dt | 2019-04-01 00:00:00 | 2019-04-01 00:00:00 | 2018-06-30 00:00:00 | 2018-06-26 00:00:00 | 2018-12-31 00:00:00 |
| filer_id | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | 1408245 | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 424797.cal | 439952.cal | 2349251_0.cal | 2381029_0.cal | 2319271_0.cal | 440037.cal | 316608.cal | 316679.cal | 2381029_1.cal | 220687.cal | 2276797_0.cal | 335052.cal | 33710.cal | 130285.cal | 130322.cal | |||||||||||||||
| received_date | 2018-09-22 00:00:00 | 2018-11-07 00:00:00 | 2019-01-31 00:00:00 | 2019-04-30 00:00:00 | 2018-10-31 00:00:00 | 2018-11-07 00:00:00 | 2018-09-17 00:00:00 | 2018-09-17 00:00:00 | 2019-06-17 00:00:00 | 2019-03-20 00:00:00 | 2018-07-31 00:00:00 | 2018-09-18 00:00:00 | 2019-04-30 00:00:00 | 2018-10-31 00:00:00 | 2018-10-31 00:00:00 | |||||||||||||||
| filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /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/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | |||||||||||||||
| filing_id | None | None | 2349251 | 2381029 | 2319271 | None | None | None | 2381029 | None | 2276797 | None | None | None | None | |||||||||||||||
| form_id | None | None | F635 | F635 | F635 | None | None | None | F635 | None | F635 | None | None | None | None | |||||||||||||||
| receive_comment | Filing passed validation, but failed DB constraints | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints |