filing_id | 1622952 | 1630956 | 1693442 | 1653655 | 1622952 | 1622952 | 1726368 | 1630956 | 1693442 | 1717410 | 1792537 | 1791357 | 1761953 | 1808536 | 1888869 | 1860567 | 1835160 | 1922353 | 1990133 | 1972637 | 1955532 | 2002509 | 2060855 | 2025244 | 2101142 | 2174892 | 2156817 | 2131604 | 2212428 | 2212428 | 2194221 | 2241361 | 2263005 | 2318575 | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 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 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||
sender_id | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | ||||||||||||||||||||||||||||||||||
filer_id | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | ||||||||||||||||||||||||||||||||||
entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | ||||||||||||||||||||||||||||||||||
filer_naml | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ||||||||||||||||||||||||||||||||||
filer_namf | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | ||||||||||||||||||||||||||||||||||
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 | 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 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 001 | 002 | 000 | 001 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | ||||||||||||||||||||||||||||||||||
rpt_date | 2011-10-31 00:00:00 | 2012-01-24 00:00:00 | 2012-10-03 00:00:00 | 2012-04-23 00:00:00 | 2012-04-23 00:00:00 | 2012-11-14 00:00:00 | 2013-01-15 00:00:00 | 2013-01-17 00:00:00 | 2013-01-17 00:00:00 | 2012-12-14 00:00:00 | 2013-10-02 00:00:00 | 2013-09-16 00:00:00 | 2013-04-25 00:00:00 | 2014-01-02 00:00:00 | 2014-09-26 00:00:00 | 2014-06-30 00:00:00 | 2014-04-01 00:00:00 | 2014-12-31 00:00:00 | 2015-09-30 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 2016-01-05 00:00:00 | 2016-07-28 00:00:00 | 2016-03-31 00:00:00 | 2016-10-31 00:00:00 | 2017-07-30 00:00:00 | 2017-04-30 00:00:00 | 2017-01-31 00:00:00 | 2018-02-01 00:00:00 | 2018-03-05 00:00:00 | 2017-10-31 00:00:00 | 2018-04-30 00:00:00 | 2018-07-06 00:00:00 | 2018-10-31 00:00:00 | ||||||||||||||||||||||||||||||||||
from_date | 2011-09-06 00:00:00 | 2011-10-31 00:00:00 | 2012-04-24 00:00:00 | 2012-01-01 00:00:00 | 2011-09-06 00:00:00 | 2011-09-06 00:00:00 | 2012-10-01 00:00:00 | 2011-10-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2013-07-01 00:00:00 | 2013-04-01 00:00:00 | 2013-01-01 00:00:00 | 2013-10-01 00:00:00 | 2014-07-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2014-10-01 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2016-07-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2018-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||
thru_date | 2011-10-31 00:00:00 | 2012-01-31 00:00:00 | 2012-07-23 00:00:00 | 2012-03-31 00:00:00 | 2011-09-30 00:00:00 | 2011-09-30 00:00:00 | 2012-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2013-09-30 00:00:00 | 2013-06-30 00:00:00 | 2013-03-31 00:00:00 | 2013-12-31 00:00:00 | 2014-09-30 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2014-12-31 00:00:00 | 2015-09-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2016-09-30 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2017-12-31 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2018-08-08 00:00:00 | ||||||||||||||||||||||||||||||||||
cum_beg_dt | 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 | None | None | ||||||||||||||||||||||||||||||||||
firm_id | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | ||||||||||||||||||||||||||||||||||
firm_name | Coalition For Renewable Natural Gas | Coalition For Renewable Natural Gas | Coalition For Renewable Natural Gas | Coalition For Renewable Natural Gas | Coalition For Renewable Natural Gas | Coalition For Renewable Natural Gas | Coalition For Renewable Natural Gas, Inc. | Coalition For Renewable Natural Gas | Coalition For Renewable Natural Gas | Coalition For Renewable Natural Gas | Coalition For Renewable Natural Gas, Inc. | Coalition For Renewable Natural Gas, Inc. | Coalition For Renewable Natural Gas, Inc. | Coalition For Renewable Natural Gas | Coalition For Renewable Natural Gas, Inc. | Coalition For Renewable Natural Gas, Inc. | Coalition For Renewable Natural Gas | Coalition For Renewable Natural Gas, Inc. | Coalition For Renewable Natural Gas, Inc. | Coalition For Renewable Natural Gas, Inc. | Coalition For Renewable Natural Gas, Inc. | Coalition for Renewable Natural Gas | Coalition For Renewable Natural Gas, Inc. | Coalition for Renewable Natural Gas | The Coalition for Renewable Natural Gas | The Coalition for Renewable Natural Gas | The Coalition for Renewable Natural Gas | The Coalition for Renewable Natural Gas | The Coalition for Renewable Natural Gas | The Coalition for Renewable Natural Gas | The Coalition for Renewable Natural Gas | The Coalition for Renewable Natural Gas | The Coalition for Renewable Natural Gas | The Coalition for Renewable Natural Gas | ||||||||||||||||||||||||||||||||||
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 | 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 | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||
firm_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||
firm_phon | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9164791342 | 9165883033 | 9165883033 | 9165883033 | 9165883033 | 9165883033 | 9165883033 | 9165883033 | 9165883033 | 9165883033 | ||||||||||||||||||||||||||||||||||
mail_city | None | None | None | None | None | None | None | None | None | None | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | PALO ALTO | ||||||||||||||||||||||||||||||||||
mail_st | None | None | None | None | None | None | None | None | None | None | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | None | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | 94303 | ||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||
sig_date | 2011-10-31 00:00:00 | 2012-01-24 00:00:00 | 2012-10-03 00:00:00 | 2012-04-23 00:00:00 | 2012-04-23 00:00:00 | 2012-11-14 00:00:00 | 2013-01-15 00:00:00 | 2013-01-17 00:00:00 | 2013-01-17 00:00:00 | 2012-12-14 00:00:00 | 2013-10-02 00:00:00 | 2013-09-16 00:00:00 | 2013-04-25 00:00:00 | 2014-01-02 00:00:00 | 2014-09-26 00:00:00 | 2014-06-30 00:00:00 | 2014-04-01 00:00:00 | 2014-12-31 00:00:00 | 2015-09-30 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 2016-01-05 00:00:00 | 2016-07-28 00:00:00 | 2016-03-31 00:00:00 | 2016-10-31 00:00:00 | 2017-07-30 00:00:00 | 2017-04-30 00:00:00 | 2016-01-31 00:00:00 | 2017-02-01 00:00:00 | 2018-03-05 00:00:00 | 2017-10-31 00:00:00 | 2018-04-30 00:00:00 | 2018-06-06 00:00:00 | 2018-10-31 00:00:00 | ||||||||||||||||||||||||||||||||||
sig_loc | Sacramento, CA | Sacramento, CA | Palo Alto, CA | Sacramento, CA | Sacramento, CA | Sacramento | Palo Alto, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA | Palo Alto, CA 94303 | Palo Alto, CA | ||||||||||||||||||||||||||||||||||
sig_naml | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | ||||||||||||||||||||||||||||||||||
sig_namf | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes D. | Johannes D. | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | ||||||||||||||||||||||||||||||||||
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 | 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 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||
prn_naml | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | Escudero | ||||||||||||||||||||||||||||||||||
prn_namf | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes D. | Johannes D. | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | Johannes | ||||||||||||||||||||||||||||||||||
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 | 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 | 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 | Executive Director | Executive Director | Executive Director | Executive Director | Executive Director | CEO/Executive Director | CEO/ Executive Director | Executive Director | CEO / Executive Director | CEO & Executive Director | CEO and Executive Director | CEO/Executive Director | CEO Executive Director | CEO & Executive Director | CEO Executive Director | CEO/Executive Director | CEO & Executive Director | CEO & Executive Director | CEO & Executive Director | CEO & Executive Director | CEO & Executive Director | CEO/Executive Diretor | ||||||||||||||||||||||||||||||||||
nopart1_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 | 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 | X | X | X | X | X | X | X | X | 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 | 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 | 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 | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | None | None | None | None | None | None | None | None | None | None |
filing_id | 1728643 | 1914145 | ||
---|---|---|---|---|
amend_id | 0 | 0 | ||
rec_type | CVR | CVR | ||
form_type | F604 | F604 | ||
sender_id | 1341727 | 1341727 | ||
filer_id | 1341730 | 1341730 | ||
entity_cd | LBY | LBY | ||
filer_naml | Escudero | ESCUDERO | ||
filer_namf | Johannes D. | JOHANNES D. | ||
filer_namt | None | None | ||
filer_nams | None | None | ||
report_num | 000 | 000 | ||
rpt_date | 2013-01-17 00:00:00 | 2014-11-05 00:00:00 | ||
ls_beg_yr | 2013 | 2015 | ||
ls_end_yr | 2014 | 2016 | ||
qual_date | 2013-01-02 00:00:00 | 2011-10-31 00:00:00 | ||
eff_date | 2012-11-08 00:00:00 | None | ||
bus_city | Sacramento | SACRAMENTO | ||
bus_st | CA | CA | ||
bus_zip4 | 95814 | 95814 | ||
bus_phon | 916-479-1342 | 9164791342 | ||
bus_fax | None | None | ||
bus_email | None | [email protected] | ||
mail_city | Palo Alto | PALO ALTO | ||
mail_st | CA | CA | ||
mail_zip4 | 94303 | 94303 | ||
mail_phon | None | None | ||
sig_date | 2013-01-15 00:00:00 | 2014-11-05 00:00:00 | ||
sig_loc | Sacramento, CA | None | ||
sig_naml | Escudero | ESCUDERO | ||
sig_namf | Johannes D. | JOHANNES D. | ||
sig_namt | None | None | ||
sig_nams | None | None | ||
prn_naml | None | ESCUDERO | ||
prn_namf | None | JOHANNES D. | ||
prn_namt | None | None | ||
prn_nams | None | None | ||
sig_title | None | None | ||
stmt_firm | None | None | ||
ind_cb | None | None | ||
bus_cb | None | None | ||
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 | None | None | ||
descrip_2 | None | None | ||
c_less50 | None | None | ||
c_more50 | None | None | ||
ind_class | None | None | ||
ind_descr | None | None | ||
bus_class | None | None | ||
bus_descr | None | None | ||
auth_name | None | None | ||
auth_city | None | None | ||
auth_st | None | None | ||
auth_zip4 | None | None | ||
lobby_int | None | None | ||
influen_yn | None | None | ||
firm_name | Coalition for Renewable Gas | Coalition For Renewable Natural Gas, Inc. | ||
newcert_cb | None | None | ||
rencert_cb | None | X | ||
complet_dt | 2012-11-08 00:00:00 | None | ||
lby_reg_cb | X | X | ||
lby_604_cb | None | None | ||
st_leg_yn | Y | Y | ||
st_agency | None | None | ||
lobby_cb | None | None | ||
l_firm_cb | None | None |
filer_id | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2220864 | 2410462 | 2286588 | 2277651 | 2340264 | 2340265 | ||||||
effect_dt | 2011-09-06 00:00:00 | 2017-01-01 00:00:00 | 2013-02-19 00:00:00 | 2013-02-19 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | ||||||
add_type | 7051 | 7051 | 7082 | 7051 | 7051 | 7082 | ||||||
session_id | 2011 | 2017 | 2013 | 2013 | 2015 | 2015 |
filer_id | 1341730 | 1341730 | 1341730 | |||
---|---|---|---|---|---|---|
session_id | 2013 | 2015 | 2017 | |||
ethics_date | 2012-11-08 00:00:00 | 2015-02-26 00:00:00 | 2017-05-16 00:00:00 |
filer_id | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1772373 | 1972637 | 1860567 | 1792537 | 1791357 | 1952314 | 1920863 | 1922353 | 1955532 | 1616187 | 1630956 | 1622952 | 1622952 | 1653655 | 1808536 | 1693442 | 1914145 | 1717410 | 1622952 | 1888869 | 1728643 | 1726368 | 1630956 | 1693442 | 1835160 | 1761953 | 1760599 | 2002509 | 1990133 | 2194221 | 2241361 | 2282867 | 2318575 | 2025244 | 2060855 | 2101142 | 2119112 | 2131604 | 2174892 | 2162923 | 2156817 | 2212428 | 2263005 | 2212428 | ||||||||||||||||||||||||||||||||||||||||||||
period_id | None | 222 | 218 | 215 | 214 | None | None | 220 | 221 | None | 208 | 207 | 207 | 209 | 216 | 210 | 220 | 211 | 207 | 219 | 213 | 212 | 208 | 210 | 217 | 213 | None | 224 | 223 | 231 | 233 | None | 235 | 225 | 226 | 227 | None | 228 | 230 | None | 229 | 232 | 234 | 231 | ||||||||||||||||||||||||||||||||||||||||||||
form_id | F604 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F606 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2013-06-13 00:00:00 | 2015-07-01 00:00:00 | 2014-06-30 00:00:00 | 2013-10-02 00:00:00 | 2013-09-16 00:00:00 | 2015-02-26 00:00:00 | 2014-11-10 00:00:00 | 2014-12-31 00:00:00 | 2015-04-01 00:00:00 | 2011-09-14 00:00:00 | 2012-01-24 00:00:00 | 2011-10-31 00:00:00 | 2012-04-23 00:00:00 | 2012-04-23 00:00:00 | 2014-01-02 00:00:00 | 2012-10-03 00:00:00 | 2014-11-05 00:00:00 | 2012-12-14 00:00:00 | 2012-11-14 00:00:00 | 2014-09-26 00:00:00 | 2013-01-17 00:00:00 | 2013-01-15 00:00:00 | 2013-01-17 00:00:00 | 2013-01-17 00:00:00 | 2014-04-01 00:00:00 | 2013-04-25 00:00:00 | 2013-02-19 00:00:00 | 2016-01-05 00:00:00 | 2015-09-30 00:00:00 | 2017-10-31 00:00:00 | 2018-04-30 00:00:00 | 2018-08-13 00:00:00 | 2018-10-31 00:00:00 | 2016-03-31 00:00:00 | 2016-07-28 00:00:00 | 2016-10-31 00:00:00 | 2016-12-30 00:00:00 | 2017-01-31 00:00:00 | 2017-07-30 00:00:00 | 2017-06-09 00:00:00 | 2017-04-30 00:00:00 | 2018-03-05 00:00:00 | 2018-07-06 00:00:00 | 2018-02-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10001 | 10001 | 10001 | 10001 | 10006 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10003 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10006 | 10001 | 10002 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | ||||||||||||||||||||||||||||||||||||||||||||
session_id | 2013 | 2015 | 2013 | 2013 | 2013 | 2015 | 2015 | 2013 | 2015 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2015 | 2011 | 2011 | 2013 | 2013 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | ||||||||||||||||||||||||||||||||||||||||||||
user_id | YRODRIGU | JINGRAM | AGLADNEY | AGLADNEY | RGEREMIA | ASAETERN | GKURIMOT | AGLADNEY | AGLADNEY | YRODRIGU | ASAETERN | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | CAFILER | ASAETERN | ASAETERN | AGLADNEY | YRODRIGU | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | YRODRIGU | AGLADNEY | JINGRAM | AGLADNEY | AGLADNEY | YRODRIGU | CAFILER | AGLADNEY | AGLADNEY | JINGRAM | PBANFORD | AGLADNEY | SMCCONNAN | PBANFORD | JINGRAM | AGLADNEY | CAFILER | KBANH | ||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | ||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1900-01-01 00:00:00 | 2015-04-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 2013-04-01 00:00:00 | None | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-10-31 00:00:00 | 2011-09-06 00:00:00 | 2011-09-06 00:00:00 | 2012-01-01 00:00:00 | 2013-10-01 00:00:00 | 2012-04-24 00:00:00 | 2014-11-05 00:00:00 | 2012-07-01 00:00:00 | 2011-09-06 00:00:00 | 2014-07-01 00:00:00 | 2013-01-17 00:00:00 | 2012-10-01 00:00:00 | 2011-10-01 00:00:00 | 2012-04-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-10-01 00:00:00 | 2015-07-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-07-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-04-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-10-01 00:00:00 | 2018-04-01 00:00:00 | 2017-09-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1900-01-01 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 2013-06-30 00:00:00 | None | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 2012-01-31 00:00:00 | 2011-10-31 00:00:00 | 2011-09-30 00:00:00 | 2012-03-31 00:00:00 | 2013-12-31 00:00:00 | 2012-07-23 00:00:00 | 2014-11-05 00:00:00 | 2012-09-30 00:00:00 | 2011-09-30 00:00:00 | 2014-09-30 00:00:00 | 2013-01-17 00:00:00 | 2012-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-06-30 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 1900-01-01 00:00:00 | 2015-12-31 00:00:00 | 2015-09-30 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | 1900-01-01 00:00:00 | 2018-08-08 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 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 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 |
filer_id | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | |||||
---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | |||||
active | Y | Y | Y | T | Y | |||||
race | 0 | None | None | None | None | |||||
session_id | 2011 | 2013 | 2015 | 2017 | 2017 | |||||
category | 0 | None | None | None | None | |||||
category_type | 0 | None | None | None | None | |||||
sub_category | 0 | None | None | None | None | |||||
effect_dt | 2011-09-06 00:00:00 | 2013-02-19 00:00:00 | 2015-01-01 00:00:00 | 2018-08-08 00:00:00 | 2017-01-01 00:00:00 | |||||
sub_category_type | 0 | None | None | None | None | |||||
election_type | 0 | None | None | None | None | |||||
sub_category_a | None | None | None | None | None | |||||
nyq_dt | None | None | None | None | None | |||||
party_cd | 0 | None | None | None | None | |||||
county_cd | 0 | None | None | None | None | |||||
district_cd | 0 | None | None | None | None |
filer_id | 1341730 | |
---|---|---|
xref_id | 1341730 | |
effect_dt | 2011-09-21 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | 1341730 | ||||||||||||||||||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||||||||||||||||||||||
status | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | ||||||||||||||||||||||||
effect_dt | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | 2018-08-08 00:00:00 | ||||||||||||||||||||||||
naml | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ESCUDERO | ||||||||||||||||||||||||
namf | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | JOHANNES D. | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | PALO ALTO | SACRAMENTO | PALO ALTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | PALO ALTO | SACRAMENTO | PALO ALTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | PALO ALTO | SACRAMENTO | PALO ALTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | PALO ALTO | SACRAMENTO | PALO ALTO | SACRAMENTO | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
zip4 | 95814 | 95814 | 94303 | 95814 | 94303 | 95814 | 95814 | 95814 | 94303 | 95814 | 94303 | 95814 | 95814 | 95814 | 94303 | 95814 | 94303 | 95814 | 95814 | 95814 | 94303 | 95814 | 94303 | 95814 | ||||||||||||||||||||||||
phon | 9164791342 | 9164791342 | None | 9164791342 | None | 9165883033 | 9164791342 | 9164791342 | None | 9164791342 | None | 9165883033 | 9164791342 | 9164791342 | None | 9164791342 | None | 9165883033 | 9164791342 | 9164791342 | None | 9164791342 | None | 9165883033 | ||||||||||||||||||||||||
fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||
[email protected] | [email protected] | None | [email protected] | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | [email protected] |
filer_id | 1341730 |
---|
filer_id | 1341730 | 1341730 | ||
---|---|---|---|---|
change_no | 0 | 1 | ||
session_id | 2011 | 2017 | ||
log_dt | 2011-09-14 00:00:00 | 2018-08-13 00:00:00 | ||
filer_type | 4 | 4 | ||
correction_flg | Y | Y | ||
action | ADDED | TERMINATED | ||
attribute_changed | EMPLOYER | EMPLOYER | ||
ethics_dt | None | None | ||
interests | None | None | ||
filer_full_name | ESCUDERO, JOHANEES D. | ESCUDERO, JOHANNES D. | ||
filer_city | None | SACRAMENTO | ||
filer_st | None | CA | ||
filer_zip | None | 95814 | ||
filer_phone | None | 9164791342 | ||
entity_type | 2 | 2 | ||
entity_name | COALITION FOR RENEWABLE NATURAL GAS | COALITION FOR RENEWABLE NATURAL GAS; THE | ||
entity_city | None | None | ||
entity_st | None | None | ||
entity_zip | None | None | ||
entity_phone | None | None | ||
entity_id | 1341727 | None | ||
responsible_officer | None | None | ||
effect_dt | 2011-09-06 00:00:00 | 2018-08-08 00:00:00 |
filer_id | 1341730 | 1341730 | 1341730 | |||
---|---|---|---|---|---|---|
filing_file_name | 224937.cal | 1728643_0.cal | 1914145_0.cal | |||
received_date | 2013-01-17 00:00:00 | 2013-01-17 00:00:00 | 2014-11-05 00:00:00 | |||
filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||
filing_id | None | 1728643 | 1914145 | |||
form_id | None | F604 | F604 | |||
receive_comment | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted |