filing_id | 1981288 | 1966276 | 1997690 | 2061000 | 2010549 | 2036652 | 2101576 | 2061000 | 2129297 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||
form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||
sender_id | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | |||||||||
filer_id | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | |||||||||
entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | |||||||||
filer_naml | ROBINSON | ROBINSON | ROBINSON | ROBINSON | ROBINSON | ROBINSON | ROBINSON | ROBINSON | ROBINSON | |||||||||
filer_namf | KATERINA | KATERINA | KATERINA | KATERINA | KATERINA | KATERINA | KATERINA | KATERINA | KATERINA | |||||||||
filer_namt | None | None | None | None | None | None | None | None | None | |||||||||
filer_nams | None | None | None | None | None | None | None | None | None | |||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | |||||||||
rpt_date | 2015-07-30 00:00:00 | 2015-04-30 00:00:00 | 2015-11-01 00:00:00 | 2016-07-29 00:00:00 | 2016-01-29 00:00:00 | 2016-04-29 00:00:00 | 2016-10-31 00:00:00 | 2017-01-16 00:00:00 | 2017-01-31 00:00:00 | |||||||||
from_date | 2015-04-01 00:00:00 | 2015-01-31 00:00:00 | 2015-07-01 00:00:00 | 2016-04-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-07-01 00:00:00 | 2016-04-01 00:00:00 | 2016-10-01 00:00:00 | |||||||||
thru_date | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2015-09-30 00:00:00 | 2106-06-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-12-31 00:00:00 | |||||||||
cum_beg_dt | None | None | None | None | None | None | None | None | None | |||||||||
firm_id | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | |||||||||
firm_name | ENVIRONMENTAL AND ENERGY CONSULTING | ENVIRONMENTAL AND ENERGY CONSULTING | ENVIRONMENTAL AND ENERGY CONSULTING | Environmental & Energy Consulting | Environmental and Energy Consulting | Environmental & Energy Consulting | Environmental and Energy Consulting | Environmental & Energy Consulting | Environmental and Energy Consulting | |||||||||
firm_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||||||
firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||
firm_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||
firm_phon | 9164269170 | 9164269170 | 9164269170 | 9164269170 | 9164269170 | 9164269170 | 9164269170 | 9164269170 | 9164269170 | |||||||||
mail_city | None | None | None | None | None | None | None | None | None | |||||||||
mail_st | None | None | None | None | None | None | None | None | None | |||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | |||||||||
mail_phon | None | None | None | None | None | None | None | None | None | |||||||||
sig_date | 2015-07-30 00:00:00 | 2015-04-30 00:00:00 | 2015-11-01 00:00:00 | 2016-07-29 00:00:00 | 2016-01-29 00:00:00 | 2016-04-29 00:00:00 | 2016-10-31 00:00:00 | 2017-01-16 00:00:00 | 2017-01-31 00:00:00 | |||||||||
sig_loc | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | |||||||||
sig_naml | Robinson | Robinson | Robinson | Robinson | Robinson | Robinson | Robinson | Robinson | Robinson | |||||||||
sig_namf | Katerina | Katerina | Katerina | Katerina | Katerina | Katerina | Katerina | Katerina | Katerina | |||||||||
sig_namt | None | None | None | None | None | None | None | None | None | |||||||||
sig_nams | None | None | None | None | None | None | None | None | None | |||||||||
prn_naml | Robinson | Robinson | Robinson | Robinson | Robinson | Robinson | Robinson | Robinson | Robinson | |||||||||
prn_namf | Katerina | Katerina | Katerina | Katerina | Katerina | Katerina | Katerina | Katerina | Katerina | |||||||||
prn_namt | None | None | None | None | None | None | None | None | None | |||||||||
prn_nams | None | None | None | None | None | None | None | None | None | |||||||||
sig_title | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | |||||||||
nopart1_cb | X | X | X | X | X | X | X | X | X | |||||||||
nopart2_cb | X | X | X | X | X | X | X | X | X | |||||||||
part1_1_cb | None | None | None | None | None | None | None | None | None | |||||||||
part1_2_cb | None | None | None | None | None | None | None | None | None | |||||||||
ctrib_n_cb | None | None | None | None | None | None | None | None | None | |||||||||
ctrib_y_cb | None | None | None | None | None | None | None | None | None | |||||||||
lby_actvty | None | None | None | None | None | None | None | None | None | |||||||||
lobby_n_cb | None | None | None | None | None | None | None | None | None | |||||||||
lobby_y_cb | None | None | None | None | None | None | None | None | None | |||||||||
major_naml | None | None | None | None | None | None | None | None | None | |||||||||
major_namf | None | None | None | None | None | None | None | None | None | |||||||||
major_namt | None | None | None | None | None | None | None | None | None | |||||||||
major_nams | None | None | None | None | None | None | None | None | None | |||||||||
rcpcmte_nm | None | None | None | None | None | None | None | None | None | |||||||||
rcpcmte_id | None | None | None | None | None | None | None | None | None |
filing_id | 1923021 | 2132827 | 2118899 | |||
---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | |||
rec_type | CVR | CVR | CVR | |||
form_type | F604 | F606 | F604 | |||
sender_id | 1371848 | 1371848 | 1371848 | |||
filer_id | 1374077 | 1374077 | 1374077 | |||
entity_cd | LBY | LBY | LBY | |||
filer_naml | ROBINSON | ROBINSON | ROBINSON | |||
filer_namf | KATERINA | KATERINA | KATERINA | |||
filer_namt | None | None | None | |||
filer_nams | None | None | None | |||
report_num | 000 | 000 | 000 | |||
rpt_date | 2015-01-05 00:00:00 | 2017-02-03 00:00:00 | 2017-01-11 00:00:00 | |||
ls_beg_yr | 2015 | 2017 | 2017 | |||
ls_end_yr | 2016 | 2018 | 2018 | |||
qual_date | 2015-01-05 00:00:00 | None | None | |||
eff_date | None | 2017-01-25 00:00:00 | None | |||
bus_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||
bus_st | CA | CA | CA | |||
bus_zip4 | 95814 | 95814 | 95814 | |||
bus_phon | 9164269170 | None | 9164269170 | |||
bus_fax | 9164269170 | None | 9164269170 | |||
bus_email | [email protected] | None | [email protected] | |||
mail_city | None | None | None | |||
mail_st | None | None | None | |||
mail_zip4 | None | None | None | |||
mail_phon | None | None | None | |||
sig_date | 2015-01-05 00:00:00 | 2017-01-25 00:00:00 | 2017-01-11 00:00:00 | |||
sig_loc | None | None | None | |||
sig_naml | ROBINSON | Robinson | ROBINSON | |||
sig_namf | KATERINA | Katerina | KATERINA | |||
sig_namt | None | None | None | |||
sig_nams | None | None | None | |||
prn_naml | ROBINSON | Robinson | ROBINSON | |||
prn_namf | KATERINA | Katerina | KATERINA | |||
prn_namt | None | None | None | |||
prn_nams | None | None | None | |||
sig_title | None | Lobbyist | None | |||
stmt_firm | None | None | None | |||
ind_cb | None | None | None | |||
bus_cb | None | None | None | |||
trade_cb | None | None | None | |||
oth_cb | None | None | None | |||
a_b_name | None | None | None | |||
a_b_city | None | None | None | |||
a_b_st | None | None | None | |||
a_b_zip4 | None | None | None | |||
descrip_1 | None | None | None | |||
descrip_2 | None | None | None | |||
c_less50 | None | None | None | |||
c_more50 | None | None | None | |||
ind_class | None | None | None | |||
ind_descr | None | None | None | |||
bus_class | None | None | None | |||
bus_descr | None | None | None | |||
auth_name | None | None | None | |||
auth_city | None | None | None | |||
auth_st | None | None | None | |||
auth_zip4 | None | None | None | |||
lobby_int | None | None | None | |||
influen_yn | None | None | None | |||
firm_name | Environmental and Energy Consulting | Environmental and Energy Consulting | Environmental and Energy Consulting | |||
newcert_cb | X | None | None | |||
rencert_cb | None | None | X | |||
complet_dt | None | None | None | |||
lby_reg_cb | X | None | X | |||
lby_604_cb | None | None | None | |||
st_leg_yn | Y | None | Y | |||
st_agency | None | None | None | |||
lobby_cb | None | None | None | |||
l_firm_cb | None | None | None |
filer_id | 1374077 | 1374077 | ||
---|---|---|---|---|
adrid | 2411650 | 2347116 | ||
effect_dt | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | ||
add_type | 7051 | 7051 | ||
session_id | 2017 | 2015 |
filer_id | 1374077 | |
---|---|---|
session_id | 2015 | |
ethics_date | 2015-04-09 00:00:00 |
filer_id | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | 1374077 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1981288 | 1966276 | 1957501 | 1948837 | 1923021 | 1997690 | 2010549 | 2036652 | 2061000 | 2101576 | 2061000 | 2129297 | 2118899 | 2132827 | 2135322 | 2137866 | ||||||||||||||||
period_id | 222 | 221 | None | None | 221 | 223 | 224 | 225 | 226 | 227 | 226 | 228 | 229 | 229 | None | None | ||||||||||||||||
form_id | F615 | F615 | F604 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F606 | F604 | F606 | ||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
filing_date | 2015-07-30 00:00:00 | 2015-04-30 00:00:00 | 2015-04-09 00:00:00 | 2015-01-09 00:00:00 | 2015-01-05 00:00:00 | 2015-11-01 00:00:00 | 2016-01-29 00:00:00 | 2016-04-29 00:00:00 | 2016-07-29 00:00:00 | 2016-10-31 00:00:00 | 2017-01-16 00:00:00 | 2017-01-31 00:00:00 | 2017-01-11 00:00:00 | 2017-02-03 00:00:00 | 2017-01-25 00:00:00 | 2017-02-15 00:00:00 | ||||||||||||||||
stmnt_type | 10001 | 10001 | 10006 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10005 | ||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | ||||||||||||||||
session_id | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | ||||||||||||||||
user_id | JINGRAM | JINGRAM | PBANFORD | YRODRIGU | YRODRIGU | JINGRAM | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | CAFILER | CAFILER | SARRIAGA | SARRIAGA | ||||||||||||||||
special_audit | 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 | 11001 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||
rpt_start | 2015-04-01 00:00:00 | 2015-01-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-05 00:00:00 | 2015-07-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-04-01 00:00:00 | 2016-10-01 00:00:00 | 2017-01-11 00:00:00 | 2017-02-03 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | ||||||||||||||||
rpt_end | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-05 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2106-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-12-31 00:00:00 | 2017-01-11 00:00:00 | 2017-02-03 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | ||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
filing_type | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None |
filer_id | 1374077 | 1374077 | 1374077 | |||
---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | |||
active | T | Y | Y | |||
race | None | 0 | None | |||
session_id | 2017 | 2015 | 2017 | |||
category | None | 0 | None | |||
category_type | None | 0 | None | |||
sub_category | None | 0 | None | |||
effect_dt | 2017-01-25 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | |||
sub_category_type | None | 0 | None | |||
election_type | None | 0 | None | |||
sub_category_a | None | None | None | |||
nyq_dt | None | None | None | |||
party_cd | None | 0 | None | |||
county_cd | None | 0 | None | |||
district_cd | None | 0 | None |
filer_id | 1374077 | |
---|---|---|
xref_id | 1374077 | |
effect_dt | 2014-12-15 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1374077 | 1374077 | 1374077 | 1374077 | ||||
---|---|---|---|---|---|---|---|---|
filer_id | 1374077 | 1374077 | 1374077 | 1374077 | ||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||
status | TERMINATED | TERMINATED | TERMINATED | TERMINATED | ||||
effect_dt | 2017-01-25 00:00:00 | 2017-01-25 00:00:00 | 2017-01-25 00:00:00 | 2017-01-25 00:00:00 | ||||
naml | ROBINSON | ROBINSON | ROBINSON | ROBINSON | ||||
namf | KATERINA | KATERINA | KATERINA | KATERINA | ||||
namt | None | None | None | None | ||||
nams | None | None | None | None | ||||
adr1 | None | None | None | None | ||||
adr2 | None | None | None | None | ||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||
st | CA | CA | CA | CA | ||||
zip4 | 95814 | 95814 | 95814 | 95814 | ||||
phon | 9164269170 | 9164269170 | 9164269170 | 9164269170 | ||||
fax | 9164269170 | 9164269170 | 9164269170 | 9164269170 | ||||
[email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1374077 |
---|
filer_id | 1374077 | 1374077 | ||
---|---|---|---|---|
filing_file_name | 2118899_0.cal | 1923021_0.cal | ||
received_date | 2017-01-11 00:00:00 | 2015-01-05 00:00:00 | ||
filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||
filing_id | 2118899 | 1923021 | ||
form_id | F604 | F604 | ||
receive_comment | Filing accepted | Filing accepted |