filing_id | 1619111 | 1607941 | 1634552 | 1709409 | 1680615 | 1680626 | 1740694 | 1795521 | 1762043 | 1778848 | 1762043 | 1814426 | 1906345 | 1865206 | 1839462 | 1931569 | 1975037 | 1964146 | 1995309 | 2057374 | 2036426 | 2007978 | 2131131 | 2093702 | 2171335 | 2155857 | 2241675 | 2212119 | 2193450 | 2276839 | 2318315 | 2379975 | 2346756 | 2413445 | 2399939 | 2444257 | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | CVR | CVR | ||||||||||||||||||||||||||||||||||||
form_type | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||
sender_id | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | ||||||||||||||||||||||||||||||||||||
filer_id | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | ||||||||||||||||||||||||||||||||||||
entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | ||||||||||||||||||||||||||||||||||||
filer_naml | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | ||||||||||||||||||||||||||||||||||||
filer_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 | None | None | ||||||||||||||||||||||||||||||||||||
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 | 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 | None | None | ||||||||||||||||||||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | ||||||||||||||||||||||||||||||||||||
rpt_date | 2011-10-24 00:00:00 | 2011-08-01 00:00:00 | 2012-01-30 00:00:00 | 2012-10-31 00:00:00 | 2012-06-30 00:00:00 | 2012-06-30 00:00:00 | 2012-12-31 00:00:00 | 2013-10-15 00:00:00 | 2013-07-11 00:00:00 | 2013-07-15 00:00:00 | 2013-04-25 00:00:00 | 2014-01-13 00:00:00 | 2014-10-11 00:00:00 | 2014-07-17 00:00:00 | 2014-04-15 00:00:00 | 2015-01-09 00:00:00 | 2015-07-09 00:00:00 | 2015-04-17 00:00:00 | 2015-09-29 00:00:00 | 2016-07-08 00:00:00 | 2016-04-18 00:00:00 | 2016-01-16 00:00:00 | 2017-01-17 00:00:00 | 2016-10-08 00:00:00 | 2017-07-25 00:00:00 | 2017-04-18 00:00:00 | 2018-04-18 00:00:00 | 2018-01-31 00:00:00 | 2017-10-31 00:00:00 | 2018-07-12 00:00:00 | 2018-10-10 00:00:00 | 2019-04-01 00:00:00 | 2019-01-12 00:00:00 | 2019-10-16 00:00:00 | 2019-07-11 00:00:00 | 2020-01-31 00:00:00 | ||||||||||||||||||||||||||||||||||||
from_date | 2011-07-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2012-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-10-01 00:00:00 | 2013-07-01 00:00:00 | 2013-01-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-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-07-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-10-01 00:00:00 | 2016-07-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2018-01-01 00:00:00 | 2017-10-01 00:00:00 | 2017-07-01 00:00:00 | 2018-04-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-07-01 00:00:00 | 2019-04-01 00:00:00 | 2019-10-01 00:00:00 | ||||||||||||||||||||||||||||||||||||
thru_date | 2011-09-30 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2012-09-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-12-31 00:00:00 | 2013-09-30 00:00:00 | 2013-03-31 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-06-30 00:00:00 | 2015-03-31 00:00:00 | 2015-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2016-09-30 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2018-03-31 00:00:00 | 2017-12-31 00:00:00 | 2017-09-30 00:00:00 | 2018-06-30 00:00:00 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2018-12-31 00:00:00 | 2019-09-30 00:00:00 | 2019-06-30 00:00:00 | 2019-12-31 00:00:00 | ||||||||||||||||||||||||||||||||||||
cum_beg_dt | 2011-04-01 00:00:00 | 2011-04-01 00:00:00 | 2011-04-01 00:00:00 | 2011-04-01 00:00:00 | 2011-04-01 00:00:00 | 2011-04-01 00:00:00 | 2011-04-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||
firm_id | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | ||||||||||||||||||||||||||||||||||||
firm_name | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | ||||||||||||||||||||||||||||||||||||
firm_city | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Darien | Darien | Darien | Darien | Darien | Darien | Darien | Darien | Darien | Darien | Darien | Darien | Darien | Darien | Darien | Darien | Darien | Darien | Darien | Darien | Darien | ||||||||||||||||||||||||||||||||||||
firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | ||||||||||||||||||||||||||||||||||||
firm_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | ||||||||||||||||||||||||||||||||||||
firm_phon | (916) 442-2952 | (916) 442-2952 | (916) 442-2952 | (916) 442-2952 | (916) 442-2952 | (916) 442-2952 | (916) 442-2952 | 916 442-2952 | 916 442-2952 | 916 442-2952 | 916 442-2952 | 916 442-2952 | 916 442-2952 | 916 442-2952 | 916 442-2952 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | ||||||||||||||||||||||||||||||||||||
mail_city | 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 | ||||||||||||||||||||||||||||||||||||
mail_st | 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 | ||||||||||||||||||||||||||||||||||||
mail_zip4 | 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 | ||||||||||||||||||||||||||||||||||||
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 | None | None | ||||||||||||||||||||||||||||||||||||
sig_date | 2011-10-17 00:00:00 | 2011-08-01 00:00:00 | 2012-01-30 00:00:00 | 2012-10-26 00:00:00 | 2012-07-31 00:00:00 | 2012-07-31 00:00:00 | 2013-01-31 00:00:00 | 2013-10-15 00:00:00 | 2013-04-25 00:00:00 | 2013-07-15 00:00:00 | 2013-04-25 00:00:00 | 2014-01-13 00:00:00 | 2014-10-11 00:00:00 | 2014-07-17 00:00:00 | 2014-04-15 00:00:00 | 2015-01-09 00:00:00 | 2015-07-09 00:00:00 | 2015-04-17 00:00:00 | 2015-09-29 00:00:00 | 2016-07-08 00:00:00 | 2016-04-18 00:00:00 | 2016-01-16 00:00:00 | 2017-01-17 00:00:00 | 2016-10-08 00:00:00 | 2017-06-30 00:00:00 | 2017-04-18 00:00:00 | 2018-04-18 00:00:00 | 2018-01-31 00:00:00 | 2017-10-31 00:00:00 | 2018-07-12 00:00:00 | 2018-10-10 00:00:00 | 2019-04-01 00:00:00 | 2019-01-12 00:00:00 | 2019-10-16 00:00:00 | 2019-07-11 00:00:00 | 2020-01-31 00:00:00 | ||||||||||||||||||||||||||||||||||||
sig_loc | London, UK | Freeport,Grand Baham | London, England | Darien, CT | Darien, CT | Darien, CT | Darien, CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | ||||||||||||||||||||||||||||||||||||
sig_naml | Miles | Miles | Miles | Spillane | Spillane | Spillane | Miles | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | ||||||||||||||||||||||||||||||||||||
sig_namf | Bill | Bill | Bill | Paul | Paul | Paul | Bill | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | ||||||||||||||||||||||||||||||||||||
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 | 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 | None | None | ||||||||||||||||||||||||||||||||||||
prn_naml | Miles | Miles | Miles | Spillane | Spillane | Spillane | Miles | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | ||||||||||||||||||||||||||||||||||||
prn_namf | Bill | Bill | Bill | Paul | Paul | Paul | Bill | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | ||||||||||||||||||||||||||||||||||||
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 | 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 | None | None | ||||||||||||||||||||||||||||||||||||
sig_title | Managing Director, Investor Relations | Managing Director, Investor Relations | Managing Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Managing Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | ||||||||||||||||||||||||||||||||||||
nopart1_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 | None | None | ||||||||||||||||||||||||||||||||||||
nopart2_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 | None | None | ||||||||||||||||||||||||||||||||||||
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 | 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 | None | None | ||||||||||||||||||||||||||||||||||||
ctrib_n_cb | X | X | X | X | X | X | X | X | X | X | None | 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 | ||||||||||||||||||||||||||||||||||||
ctrib_y_cb | None | None | None | None | None | None | None | None | None | None | X | 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 | CalPERS, CalSTRS: Investments in Terra Firma Infrastructure Fund for Global Renewable Energy | UC Regents, CalPERS, CalSTRS: Investments in Terra Firma Infrastructure Fund for Global Renewable Energy | UC Regents, CalPERS, CalSTRS: Investments in Terra Firma Infrastructure Fund for Global Renewable Energy | UC Regents, CalPERS, CalSTRS: Investments in Terra Firma Infrastructure Fund for Global Renewable Energy | UC Regents, CalPERS, CalSTRS: potential investment in new infrastructure renewable energy fund | CalPERS, CalSTRS: potential investment in new infrastructure renewable energy fund | CalPERS, CalSTRS: potential investment in new infrastructure renewable energy fund | UC Regents, CalPERS, CalSTRS: potential investment in new infrastructure renewable energy fund | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | None | None |
filing_id | 1597739 | 1597739 | 1597739 | 1597739 | 1716595 | 1917483 | 2111954 | 2328360 | 2328360 | 2328360 | 2444254 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 1 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | |||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||
form_type | F603 | F603 | F603 | F603 | F603 | F603 | F603 | F603 | F603 | F603 | F606 | |||||||||||
sender_id | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | |||||||||||
filer_id | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | |||||||||||
entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | |||||||||||
filer_naml | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | Terra Firma Capital Advisers Limited | |||||||||||
filer_namf | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
filer_namt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
filer_nams | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
report_num | 000 | 001 | 002 | 003 | 000 | 000 | 000 | 000 | 001 | 002 | 000 | |||||||||||
rpt_date | 2011-06-23 00:00:00 | 2012-03-16 00:00:00 | 2012-04-01 00:00:00 | 2012-08-29 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2018-12-31 00:00:00 | 2020-12-31 00:00:00 | 2020-01-27 00:00:00 | 2019-12-31 00:00:00 | 2020-01-27 00:00:00 | |||||||||||
ls_beg_yr | 2011 | 2011 | 2011 | 2011 | 2013 | 2015 | 2017 | 2019 | 2019 | 2019 | 2019 | |||||||||||
ls_end_yr | 2012 | 2012 | 2012 | 2012 | 2014 | 2016 | 2018 | 2020 | 2020 | 2020 | 2020 | |||||||||||
qual_date | 2011-06-14 00:00:00 | None | None | None | None | None | None | None | None | None | None | |||||||||||
eff_date | None | None | None | None | None | None | None | None | None | None | 2019-12-31 00:00:00 | |||||||||||
bus_city | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Darien | Darien | Darien | Darien | Darien | Darien | |||||||||||
bus_st | CA | CA | CA | CA | CA | CT | CT | CT | CT | CT | CT | |||||||||||
bus_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 06820 | 06820 | 06820 | 06820 | 06820 | 06820 | |||||||||||
bus_phon | (916) 442-2952 | (916) 442-2952 | (916) 442-2952 | (916) 442-2952 | 916 442-2952 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | 203 940-2519 | |||||||||||
bus_fax | (916) 442-1280 | (916) 442-1280 | (916) 442-1280 | (916) 442-1280 | 916 442-1280 | None | None | None | None | None | None | |||||||||||
bus_email | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | |||||||||||
mail_city | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
mail_st | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
mail_phon | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
sig_date | 2011-06-15 00:00:00 | 2012-07-31 00:00:00 | 2012-07-31 00:00:00 | 2012-08-24 00:00:00 | 2012-11-26 00:00:00 | 2014-11-20 00:00:00 | 2016-11-17 00:00:00 | 2018-11-29 00:00:00 | 2020-01-27 00:00:00 | 2020-02-10 00:00:00 | 2020-01-27 00:00:00 | |||||||||||
sig_loc | None | None | None | None | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | Darien CT | |||||||||||
sig_naml | Miles | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | |||||||||||
sig_namf | Bill | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | |||||||||||
sig_namt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
sig_nams | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
prn_naml | Miles | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | Spillane | |||||||||||
prn_namf | Bill | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | Paul | |||||||||||
prn_namt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
prn_nams | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
sig_title | Managing Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | Director, Investor Relations | |||||||||||
stmt_firm | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
ind_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
bus_cb | X | X | X | X | X | X | X | X | X | X | None | |||||||||||
trade_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
oth_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
a_b_name | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
a_b_city | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
a_b_st | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
a_b_zip4 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
descrip_1 | Private Equity Firm | Private Equity Firm | Private Equity Firm | Private Equity Firm | Private Equity Firm | Private Equity Firm | Private Equity Firm | Private Equity Firm | Private Equity Firm | Private Equity Firm | None | |||||||||||
descrip_2 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
c_less50 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
c_more50 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
ind_class | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
ind_descr | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
bus_class | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | None | |||||||||||
bus_descr | Private Equity | Private Equity | Private Equity | Private Equity | Private Equity | Private Equity | Private Equity | Private Equity | Private Equity | Private Equity | None | |||||||||||
auth_name | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
auth_city | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
auth_st | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
auth_zip4 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
lobby_int | Solicit investment in potential offering of securities by affiliate(s) of filer. | Solicit investment in potential offering of securities by affiliate(s) of filer. | Solicit investment in potential offering of securities by affiliate(s) of filer. | Solicit investment in potential offering of securities by affiliate(s) of filer. | Solicit investment in potential offering of securities by affiliate(s) of filer. | Solicit investment in potential offering of securities by affiliate(s) of filer. | Solicit investment in potential offering of securities by affiliate(s) of filer. | Solicit investment in potential offering of securities by affiliate(s) of filer. | Solicit investment in potential offering of securities by affiliate(s) of filer. | Solicit investment in potential offering of securities by affiliate(s) of filer. | None | |||||||||||
influen_yn | N | Y | Y | N | N | N | N | N | N | N | None | |||||||||||
firm_name | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
newcert_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
rencert_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
complet_dt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
lby_reg_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
lby_604_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
st_leg_yn | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
st_agency | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
lobby_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
l_firm_cb | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | |||||
---|---|---|---|---|---|---|---|---|---|---|
adrid | 2216588 | 2413771 | 2467399 | 2278221 | 2340061 | |||||
effect_dt | 2011-06-14 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | |||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | |||||
session_id | 2011 | 2017 | 2019 | 2013 | 2015 |
filer_id | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1762043 | 1778848 | 1975037 | 1964146 | 1865206 | 1795521 | 1906345 | 1597739 | 1597724 | 1607941 | 1619111 | 1634552 | 1814426 | 1597739 | 1686140 | 1680626 | 1680615 | 1597739 | 1597739 | 1686142 | 1920084 | 1931569 | 1917483 | 1719145 | 1688384 | 1709409 | 1740694 | 1716595 | 1839462 | 1762043 | 1995309 | 2413445 | 2212119 | 2318315 | 2007978 | 2036426 | 2057374 | 2093702 | 2111954 | 2155857 | 2131131 | 2112546 | 2171335 | 2328360 | 2346756 | 2328360 | 2399939 | 2193450 | 2347658 | 2241675 | 2328360 | 2457447 | 2276839 | 2379975 | 2444254 | 2444257 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 213 | 214 | 222 | 221 | 218 | 215 | 219 | 206 | None | 206 | 207 | 208 | 216 | 211 | None | 210 | 209 | 209 | 210 | None | None | 220 | 221 | None | None | 211 | 212 | 213 | 217 | 213 | 223 | 239 | 232 | 235 | 224 | 225 | 226 | 227 | 236 | 229 | 228 | None | 230 | 244 | 236 | 241 | 238 | 231 | None | 233 | 240 | None | 234 | 237 | 241 | 240 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F603 | F603 | F635 | F635 | F635 | F635 | F603 | F605 | F635 | F635 | F603 | F603 | F605 | F603 | F635 | F603 | F603 | F605 | F635 | F635 | F603 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F603 | F635 | F635 | F603 | F635 | F603 | F635 | F603 | F635 | F635 | F603 | F635 | F603 | F605 | F635 | F635 | F606 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2013-07-11 00:00:00 | 2013-07-26 00:00:00 | 2015-07-17 00:00:00 | 2015-04-29 00:00:00 | 2014-07-22 00:00:00 | 2013-10-18 00:00:00 | 2014-10-27 00:00:00 | 2011-06-23 00:00:00 | 2011-06-15 00:00:00 | 2011-08-01 00:00:00 | 2011-10-24 00:00:00 | 2012-01-30 00:00:00 | 2014-01-28 00:00:00 | 2012-08-29 00:00:00 | 2012-08-01 00:00:00 | 2012-07-31 00:00:00 | 2012-07-31 00:00:00 | 2012-08-02 00:00:00 | 2012-08-02 00:00:00 | 2012-08-01 00:00:00 | 2014-12-08 00:00:00 | 2015-01-28 00:00:00 | 2014-12-08 00:00:00 | 2012-12-07 00:00:00 | 2012-08-29 00:00:00 | 2012-10-31 00:00:00 | 2013-01-31 00:00:00 | 2012-12-07 00:00:00 | 2014-04-18 00:00:00 | 2013-04-25 00:00:00 | 2015-10-28 00:00:00 | 2019-10-17 00:00:00 | 2018-01-31 00:00:00 | 2018-10-31 00:00:00 | 2016-01-27 00:00:00 | 2016-04-29 00:00:00 | 2016-07-22 00:00:00 | 2016-10-22 00:00:00 | 2016-12-19 00:00:00 | 2017-04-28 00:00:00 | 2017-01-31 00:00:00 | 2016-12-09 00:00:00 | 2017-07-25 00:00:00 | 2018-12-17 00:00:00 | 2019-01-31 00:00:00 | 2020-01-31 00:00:00 | 2019-07-31 00:00:00 | 2017-10-31 00:00:00 | 2018-12-27 00:00:00 | 2018-04-30 00:00:00 | 2020-02-24 00:00:00 | 2020-02-24 00:00:00 | 2018-07-31 00:00:00 | 2019-04-30 00:00:00 | 2020-01-31 00:00:00 | 2020-01-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10006 | 10001 | 10001 | 10002 | 10002 | 10006 | 10005 | 10001 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2013 | 2013 | 2015 | 2015 | 2013 | 2013 | 2013 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2015 | 2013 | 2015 | 2013 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2019 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2015 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | ASAETERN | AGLADNEY | YRODRIGU | YRODRIGU | AGLADNEY | ASAETERN | ASAETERN | AGLADNEY | YRODRIGU | YRODRIGU | AGLADNEY | AGLADNEY | YRODRIGU | YRODRIGU | YRODRIGU | GKURIMOT | MPACHECO | CAFILER | SARRIAGA | YRODRIGU | AGLADNEY | AGLADNEY | SARRIAGA | AGLADNEY | AGLADNEY | AGLADNEY | GTAYLOR | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | CAFILER | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | SARRIAGA | AGLADNEY | GPEREZ | SUSHAKOV | AGLADNEY | SARRIAGA | AGLADNEY | GPEREZ | GPEREZ | AGLADNEY | SUSHAKOV | GPEREZ | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 2013-01-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 2014-07-01 00:00:00 | 2011-06-23 00:00:00 | 1900-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2013-10-01 00:00:00 | 2012-08-29 00:00:00 | 1900-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-01-01 00:00:00 | 2012-03-16 00:00:00 | 2012-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 2013-01-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2019-07-01 00:00:00 | 2017-10-01 00:00:00 | 2018-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 | 2018-12-31 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2020-12-31 00:00:00 | 2018-10-01 00:00:00 | 2020-01-27 00:00:00 | 2019-04-01 00:00:00 | 2017-07-01 00:00:00 | 1900-01-01 00:00:00 | 2018-01-01 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-04-01 00:00:00 | 2019-01-01 00:00:00 | 2020-01-27 00:00:00 | 2019-10-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 2013-03-31 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 2014-09-30 00:00:00 | 2011-06-23 00:00:00 | 1900-01-01 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2013-12-31 00:00:00 | 2012-08-29 00:00:00 | 1900-01-01 00:00:00 | 2012-06-30 00:00:00 | 2012-03-31 00:00:00 | 2012-03-16 00:00:00 | 2012-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00 | 2013-01-01 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2019-09-30 00:00:00 | 2017-12-31 00:00:00 | 2018-09-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2018-12-31 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2020-12-31 00:00:00 | 2018-12-31 00:00:00 | 2020-01-27 00:00:00 | 2019-06-30 00:00:00 | 2017-09-30 00:00:00 | 1900-01-01 00:00:00 | 2018-03-31 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-06-30 00:00:00 | 2019-03-31 00:00:00 | 2020-01-27 00:00:00 | 2019-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 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 |
filer_id | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | |||||
---|---|---|---|---|---|---|---|---|---|---|
session_id | 2011 | 2013 | 2017 | 2019 | 2015 | |||||
interest_cd | 40312 | 40312 | 40312 | 40312 | 40312 | |||||
effect_date | 2011-06-14 00:00:00 | 2013-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 |
filer_id | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 2 | 2 | 2 | 2 | 2 | 2 | ||||||
active | Y | Y | Y | T | Y | Y | ||||||
race | 0 | None | None | None | None | None | ||||||
session_id | 2011 | 2013 | 2019 | 2019 | 2015 | 2017 | ||||||
category | 0 | None | None | None | None | None | ||||||
category_type | 0 | None | None | None | None | None | ||||||
sub_category | 0 | None | None | None | None | None | ||||||
effect_dt | 2011-06-14 00:00:00 | 2013-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | ||||||
sub_category_type | 0 | None | None | None | None | None | ||||||
election_type | 0 | None | None | None | None | None | ||||||
sub_category_a | None | None | None | None | None | None | ||||||
nyq_dt | None | None | None | None | None | None | ||||||
party_cd | 0 | None | None | None | None | None | ||||||
county_cd | 0 | None | None | None | None | None | ||||||
district_cd | 0 | None | None | None | None | None |
filer_id | 1339280 | |
---|---|---|
xref_id | 1339280 | |
effect_dt | 2011-06-15 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | |||||||||||||||||||||||||
filer_type | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | |||||||||||||||||||||||||
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 | TERMINATED | |||||||||||||||||||||||||
effect_dt | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | |||||||||||||||||||||||||
naml | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | 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 | None | |||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | DARIEN | DARIEN | DARIEN | SACRAMENTO | SACRAMENTO | DARIEN | DARIEN | DARIEN | SACRAMENTO | SACRAMENTO | DARIEN | DARIEN | DARIEN | SACRAMENTO | SACRAMENTO | DARIEN | DARIEN | DARIEN | SACRAMENTO | SACRAMENTO | DARIEN | DARIEN | DARIEN | |||||||||||||||||||||||||
st | CA | CA | CT | CT | CT | CA | CA | CT | CT | CT | CA | CA | CT | CT | CT | CA | CA | CT | CT | CT | CA | CA | CT | CT | CT | |||||||||||||||||||||||||
zip4 | 95814 | 95814 | 06820 | 06820 | 06820 | 95814 | 95814 | 06820 | 06820 | 06820 | 95814 | 95814 | 06820 | 06820 | 06820 | 95814 | 95814 | 06820 | 06820 | 06820 | 95814 | 95814 | 06820 | 06820 | 06820 | |||||||||||||||||||||||||
phon | 9164422952 | 9164422952 | 2039402519 | 2039402519 | 2039402519 | 9164422952 | 9164422952 | 2039402519 | 2039402519 | 2039402519 | 9164422952 | 9164422952 | 2039402519 | 2039402519 | 2039402519 | 9164422952 | 9164422952 | 2039402519 | 2039402519 | 2039402519 | 9164422952 | 9164422952 | 2039402519 | 2039402519 | 2039402519 | |||||||||||||||||||||||||
fax | 9164421280 | 9164421280 | 9164421280 | 9164421280 | 9164421280 | 9164421280 | 9164421280 | 9164421280 | 9164421280 | 9164421280 | ||||||||||||||||||||||||||||||||||||||||
None | None | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] |
filer_id | 1339280 |
---|
filer_id | 1339280 | 1339280 | 1339280 | 1339280 | ||||
---|---|---|---|---|---|---|---|---|
change_no | 0 | 1 | 2 | 3 | ||||
session_id | 2011 | 2011 | 2019 | 2019 | ||||
log_dt | 2011-06-15 00:00:00 | 2012-08-01 00:00:00 | 2020-02-24 00:00:00 | 2020-02-24 00:00:00 | ||||
filer_type | 2 | 2 | 2 | 2 | ||||
correction_flg | Y | None | None | None | ||||
action | ADDED | DELETED | DELETED | TERMINATED | ||||
attribute_changed | LOBBYIST | LOBBYIST | LOBBYIST | |||||
ethics_dt | None | None | None | None | ||||
interests | None | None | None | None | ||||
filer_full_name | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | TERRA FIRMA CAPITAL ADVISERS LIMITED | ||||
filer_city | None | None | None | None | ||||
filer_st | None | None | None | None | ||||
filer_zip | None | None | None | None | ||||
filer_phone | None | None | None | None | ||||
entity_type | 4 | 4 | 4 | 2 | ||||
entity_name | MILES, BILL | BILL MILES | PAUL SPILLANE | None | ||||
entity_city | None | None | None | None | ||||
entity_st | None | None | None | None | ||||
entity_zip | None | None | None | None | ||||
entity_phone | None | None | None | None | ||||
entity_id | 1339467 | 1339467 | 1349211 | 0 | ||||
responsible_officer | None | None | None | None | ||||
effect_dt | 2011-06-14 00:00:00 | 2012-03-16 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 |
filer_id | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | 1339280 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 1740694_0.cal | 1680615_0.cal | 1680626_0.cal | 1607941_0.cal | 1619111_0.cal | 1634552_0.cal | 1709409_0.cal | 419730.cal | ||||||||
received_date | 2013-01-31 00:00:00 | 2012-07-31 00:00:00 | 2012-07-31 00:00:00 | 2011-08-01 00:00:00 | 2011-10-24 00:00:00 | 2012-01-30 00:00:00 | 2012-10-31 00:00:00 | 2017-07-25 00:00:00 | ||||||||
filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | ||||||||
filing_id | 1740694 | 1680615 | 1680626 | 1607941 | 1619111 | 1634552 | 1709409 | None | ||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | ||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints |