filing_id | 2464998 | 2526305 | 2526305 | 2479865 | 2548249 | 2620597 | 2579942 | 2594866 | 2739730 | 2671310 | 2671310 | 2700120 | 2639304 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | |||||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||||
form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||||||
sender_id | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | |||||||||||||
filer_id | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | |||||||||||||
entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | |||||||||||||
filer_naml | ROMO | ROMO | ROMO | ROMO | ROMO | ROMO | ROMO | ROMO | ROMO | ROMO | ROMO | ROMO | ROMO | |||||||||||||
filer_namf | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | |||||||||||||
filer_namt | 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 | |||||||||||||
report_num | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | |||||||||||||
rpt_date | 2020-04-06 00:00:00 | 2020-12-24 00:00:00 | 2020-10-29 00:00:00 | 2020-07-22 00:00:00 | 2021-01-27 00:00:00 | 2021-10-27 00:00:00 | 2021-04-30 00:00:00 | 2021-07-20 00:00:00 | 2022-10-24 00:00:00 | 2022-04-27 00:00:00 | 2022-04-27 00:00:00 | 2022-07-22 00:00:00 | 2022-01-27 00:00:00 | |||||||||||||
from_date | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2020-10-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-07-01 00:00:00 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | |||||||||||||
thru_date | 2020-03-31 00:00:00 | 2020-09-30 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2022-09-30 00:00:00 | 2022-03-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | |||||||||||||
cum_beg_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
firm_id | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | |||||||||||||
firm_name | League of California Cities | League of California Cities | League of California Cities | League of California Cities | League of California Cities | League of California Cities | League of California Cities | League of California Cities | League of California Cities | League of California Cities | League of California Cities | League of California Cities | League of California Cities | |||||||||||||
firm_city | 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 | |||||||||||||
firm_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 95814 | 95819 | 95819 | 95819 | 95819 | 95819 | 95819 | |||||||||||||
firm_phon | 9166588200 | 9166588200 | 9166588200 | 9166588200 | 9166588200 | 9166588200 | 9166588200 | 9166588200 | 9166588200 | 9166588200 | 9166588200 | 9166588200 | 9166588200 | |||||||||||||
mail_city | 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 | |||||||||||||
mail_zip4 | 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 | |||||||||||||
sig_date | 2020-04-06 00:00:00 | 2020-12-24 00:00:00 | 2020-10-29 00:00:00 | 2020-07-23 00:00:00 | 2021-01-27 00:00:00 | 2021-10-27 00:00:00 | 2021-04-30 00:00:00 | 2021-07-20 00:00:00 | 2022-10-24 00:00:00 | 2022-04-27 00:00:00 | 2022-04-27 00:00:00 | 2022-07-22 00:00:00 | 2022-01-27 00:00:00 | |||||||||||||
sig_loc | Sacramento, CA | Sacramento, CA | Sacramento | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento | Sacramento, CA | Sacramento, CA | Sacramento, CA | |||||||||||||
sig_naml | Romo | Romo | Romo | Romo | Romo | Romo | Romo | Romo | Romo | Romo | Romo | Romo | Romo | |||||||||||||
sig_namf | Nicholas | Nicolas | Nicholas | Nicholas | Nicholas | Nicholas | Nicholas | Nicholas | Nicholas | Nicholas | Nicholas | Nicholas | Nicholas | |||||||||||||
sig_namt | 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 | |||||||||||||
prn_naml | Romo | Romo | Romo | Romo | Romo | Romo | Romo | Romo | Romo | Romo | Romo | Romo | Romo | |||||||||||||
prn_namf | Nicholas | Nicolas | Nicholas | Nicholas | Nicholas | Nicholas | Nicholas | Nicholas | Nicholas | Nicholas | Nicholas | Nicholas | Nicholas | |||||||||||||
prn_namt | 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 | |||||||||||||
sig_title | Legislative Representative | Legislative Representative | Legislative Representative | Legislative Representative | Legislative Representative | Legislative Representative | Legislative Representative | Legislative Representative | Legislative Representative | Legislative Representative | Legislative Representative | Legislative Representative | Legislative Representative | |||||||||||||
nopart1_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||
nopart2_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||
part1_1_cb | 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 | |||||||||||||
ctrib_n_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
ctrib_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
lby_actvty | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
lobby_n_cb | 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 | |||||||||||||
major_naml | 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 | |||||||||||||
major_namt | 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 | |||||||||||||
rcpcmte_nm | 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 |
filing_id | 2461130 | 2461130 | 2538348 | 2550521 | ||||
---|---|---|---|---|---|---|---|---|
amend_id | 0 | 1 | 0 | 0 | ||||
rec_type | CVR | CVR | CVR | CVR | ||||
form_type | F604 | F604 | F604 | F604 | ||||
sender_id | E00559 | E00559 | E00559 | E00559 | ||||
filer_id | 1425604 | 1425604 | 1425604 | 1425604 | ||||
entity_cd | LBY | LBY | LBY | LBY | ||||
filer_naml | Romo | Romo | ROMO | ROMO | ||||
filer_namf | Nicholas | Nicholas | NICHOLAS | NICHOLAS | ||||
filer_namt | None | None | None | None | ||||
filer_nams | None | None | None | None | ||||
report_num | 000 | 001 | 000 | 000 | ||||
rpt_date | 2020-03-04 00:00:00 | 2020-08-18 00:00:00 | 2020-12-24 00:00:00 | 2021-01-29 00:00:00 | ||||
ls_beg_yr | 2019 | 2019 | 2021 | 2021 | ||||
ls_end_yr | 2020 | 2020 | 2022 | 2022 | ||||
qual_date | 2020-03-02 00:00:00 | 2020-03-02 00:00:00 | 2020-12-24 00:00:00 | None | ||||
eff_date | None | None | None | None | ||||
bus_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||
bus_st | CA | CA | CA | CA | ||||
bus_zip4 | 95814 | 95814 | 95814 | 95814 | ||||
bus_phon | 9166588200 | 9166588200 | 9166588200 | 9166588200 | ||||
bus_fax | 9166588240 | 9166588240 | 9166588240 | 9166588240 | ||||
bus_email | [email protected] | [email protected] | [email protected] | [email protected] | ||||
mail_city | None | None | None | None | ||||
mail_st | None | None | None | None | ||||
mail_zip4 | None | None | None | None | ||||
mail_phon | None | None | None | None | ||||
sig_date | 2020-03-04 00:00:00 | 2020-08-18 00:00:00 | 2020-12-24 00:00:00 | 2021-01-29 00:00:00 | ||||
sig_loc | None | None | None | None | ||||
sig_naml | Romo | Romo | ROMO | ROMO | ||||
sig_namf | Nicholas | Nicholas | NICHOLAS | NICHOLAS | ||||
sig_namt | None | None | None | None | ||||
sig_nams | None | None | None | None | ||||
prn_naml | Romo | Romo | ROMO | ROMO | ||||
prn_namf | Nicholas | Nicholas | NICHOLAS | NICHOLAS | ||||
prn_namt | None | None | None | None | ||||
prn_nams | None | None | None | None | ||||
sig_title | None | None | None | None | ||||
stmt_firm | None | None | None | None | ||||
ind_cb | None | None | None | None | ||||
bus_cb | None | None | None | None | ||||
trade_cb | None | None | None | None | ||||
oth_cb | None | None | None | None | ||||
a_b_name | None | None | None | None | ||||
a_b_city | None | None | None | None | ||||
a_b_st | None | None | None | None | ||||
a_b_zip4 | None | None | None | None | ||||
descrip_1 | None | None | None | None | ||||
descrip_2 | None | None | None | None | ||||
c_less50 | None | None | None | None | ||||
c_more50 | None | None | None | None | ||||
ind_class | None | None | None | None | ||||
ind_descr | None | None | None | None | ||||
bus_class | None | None | None | None | ||||
bus_descr | None | None | None | None | ||||
auth_name | None | None | None | None | ||||
auth_city | None | None | None | None | ||||
auth_st | None | None | None | None | ||||
auth_zip4 | None | None | None | None | ||||
lobby_int | None | None | None | None | ||||
influen_yn | None | None | None | None | ||||
firm_name | League of California Ciies | League of California Cities | League of California Cities | League of California Cities | ||||
newcert_cb | X | None | None | None | ||||
rencert_cb | None | None | X | None | ||||
complet_dt | None | 2020-07-30 00:00:00 | None | 2020-07-30 00:00:00 | ||||
lby_reg_cb | X | X | X | X | ||||
lby_604_cb | None | None | None | None | ||||
st_leg_yn | Y | Y | Y | Y | ||||
st_agency | None | None | None | None | ||||
lobby_cb | None | None | None | None | ||||
l_firm_cb | None | None | None | None |
filer_id | 1425604 | 1425604 | 1425604 | |||
---|---|---|---|---|---|---|
adrid | 2554192 | 2491515 | 2505186 | |||
effect_dt | 2023-01-01 00:00:00 | 2020-03-02 00:00:00 | 2021-01-01 00:00:00 | |||
add_type | 7051 | 7051 | 7051 | |||
session_id | 2023 | 2019 | 2021 |
filer_id | 1425604 | 1425604 | ||
---|---|---|---|---|
session_id | 2019 | 2021 | ||
ethics_date | 2020-07-30 00:00:00 | 2020-07-30 00:00:00 |
filer_id | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2464998 | 2461809 | 2461928 | 2550521 | 2579942 | 2526305 | 2479865 | 2461130 | 2497338 | 2605722 | 2461130 | 2526305 | 2639304 | 2538348 | 2620597 | 2700120 | 2583647 | 2548249 | 2594866 | 2671310 | 2671310 | 2739730 | ||||||||||||||||||||||
period_id | 241 | None | None | 245 | 245 | 243 | 242 | 241 | None | None | 243 | 243 | 248 | 244 | 247 | 250 | None | 244 | 246 | 249 | 249 | 251 | ||||||||||||||||||||||
form_id | F615 | F604 | F999 | F604 | F615 | F615 | F615 | F604 | F604 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ||||||||||||||||||||||
filing_date | 2020-04-06 00:00:00 | 2020-03-05 00:00:00 | 2020-03-06 00:00:00 | 2021-01-29 00:00:00 | 2021-04-30 00:00:00 | 2020-10-29 00:00:00 | 2020-07-22 00:00:00 | 2020-03-04 00:00:00 | 2020-08-17 00:00:00 | 2021-03-11 00:00:00 | 2020-08-18 00:00:00 | 2020-12-24 00:00:00 | 2022-01-27 00:00:00 | 2020-12-24 00:00:00 | 2021-10-27 00:00:00 | 2022-07-22 00:00:00 | 2021-01-11 00:00:00 | 2021-01-27 00:00:00 | 2021-07-20 00:00:00 | 2022-04-27 00:00:00 | 2022-04-27 00:00:00 | 2022-10-24 00:00:00 | ||||||||||||||||||||||
stmnt_type | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10006 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | ||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | ||||||||||||||||||||||
session_id | 2019 | 2019 | 2019 | 2021 | 2021 | 2019 | 2019 | 2019 | 2019 | 2021 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||
user_id | VUKSTINA | GPEREZ | GPEREZ | CAFILER | CHARTRIDGE | GTAYLOR | VUKSTINA | GPEREZ | AROJAS | JMENDOZA | AROJAS | GTAYLOR | RATTIYEH | JMENDOZA | GTAYLOR | CAFILER | JMENDOZA | MLUONG | CHATRIDGE | CAFILER | CAFILER | 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 | ||||||||||||||||||||||
fine_audit | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | ||||||||||||||||||||||
rpt_start | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-29 00:00:00 | 2021-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2020-03-04 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-08-18 00:00:00 | 2020-07-01 00:00:00 | 2021-10-01 00:00:00 | 2020-12-24 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||
rpt_end | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-29 00:00:00 | 2021-03-31 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-03-04 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-08-18 00:00:00 | 2020-09-30 00:00:00 | 2021-12-31 00:00:00 | 2020-12-24 00:00:00 | 2021-09-30 00:00:00 | 2022-06-30 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 2022-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 | ||||||||||||||||||||||
filing_type | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1425604 | 1425604 | 1425604 | |||
---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | |||
active | Y | Y | N | |||
race | 0 | None | None | |||
session_id | 2019 | 2021 | 2023 | |||
category | 0 | None | None | |||
category_type | 0 | None | None | |||
sub_category | 0 | None | None | |||
effect_dt | 2020-03-02 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | |||
sub_category_type | 0 | None | None | |||
election_type | 0 | None | None | |||
sub_category_a | None | None | None | |||
nyq_dt | None | None | None | |||
party_cd | 0 | None | None | |||
county_cd | 0 | None | None | |||
district_cd | 0 | None | None |
filer_id | 1425604 | |
---|---|---|
xref_id | 1425604 | |
effect_dt | 2020-03-03 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | |||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | |||||||||
status | 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 | |||||||||
naml | ROMO | ROMO | ROMO | ROMO | ROMO | ROMO | ROMO | ROMO | ROMO | |||||||||
namf | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | NICHOLAS | |||||||||
namt | None | None | None | None | None | None | None | None | None | |||||||||
nams | None | None | None | None | None | None | None | None | None | |||||||||
adr1 | None | None | None | None | None | None | None | None | None | |||||||||
adr2 | None | None | None | None | None | None | None | None | None | |||||||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||
zip4 | 95814 | 95819 | 95819 | 95814 | 95819 | 95819 | 95814 | 95819 | 95819 | |||||||||
phon | 9166588200 | 9166588200 | 9166588200 | 9166588200 | 9166588200 | 9166588200 | 9166588200 | 9166588200 | 9166588200 | |||||||||
fax | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | |||||||||
[email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1425604 |
---|
filer_id | 1425604 | 1425604 | ||
---|---|---|---|---|
change_no | 1 | 0 | ||
session_id | 2019 | 2019 | ||
log_dt | 2020-03-05 00:00:00 | 2020-03-05 00:00:00 | ||
filer_type | 4 | 4 | ||
correction_flg | None | None | ||
action | SET ACTIVE | ADDED | ||
attribute_changed | EMPLOYER | |||
ethics_dt | None | None | ||
interests | None | None | ||
filer_full_name | ROMO, NICHOLAS | ROMO, NICHOLAS | ||
filer_city | None | None | ||
filer_st | None | None | ||
filer_zip | None | None | ||
filer_phone | None | None | ||
entity_type | 4 | 2 | ||
entity_name | None | LEAGUE OF CALIFORNIA CITIES | ||
entity_city | None | None | ||
entity_st | None | None | ||
entity_zip | None | None | ||
entity_phone | None | None | ||
entity_id | 0 | 1146828 | ||
responsible_officer | None | None | ||
effect_dt | 2020-03-02 00:00:00 | 2020-03-02 00:00:00 |
filer_id | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | 1425604 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 268346.cal | 2461130_1.cal | 268212.cal | 268186.cal | 2461130_0.cal | 2550521_0.cal | 2538348_0.cal | |||||||
received_date | 2020-08-18 00:00:00 | 2020-08-18 00:00:00 | 2020-08-18 00:00:00 | 2020-08-18 00:00:00 | 2020-03-04 00:00:00 | 2021-01-29 00:00:00 | 2020-12-24 00:00:00 | |||||||
filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||
filing_id | None | 2461130 | None | None | 2461130 | 2550521 | 2538348 | |||||||
form_id | None | F604 | None | None | F604 | F604 | F604 | |||||||
receive_comment | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted |