Home

Filer ID: 1368026

Table: cvr_lobby_disclosure
filing_id   1980058   1980058   1964919   1933201   1933200   1933201   1933200   1995126   2009800   2272619   2391784   2313972   2378599   2343418   2469199   2417830   2440793   2527209   2484103   2546194
amend_id   0   1   0   1   0   0   1   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
form_type   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635
sender_id   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026
filer_id   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026
entity_cd   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM
filer_naml   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.
filer_namf   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
filer_nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
report_num   000   001   000   001   000   000   001   000   000   000   000   000   000   000   000   000   000   000   000   000
rpt_date   2015-07-30 00:00:00   2015-08-26 00:00:00   2015-04-30 00:00:00   2015-02-03 00:00:00   2015-01-30 00:00:00   2015-01-30 00:00:00   2015-02-04 00:00:00   2015-10-28 00:00:00   2016-01-29 00:00:00   2018-07-30 00:00:00   2019-07-22 00:00:00   2018-10-26 00:00:00   2019-04-29 00:00:00   2019-01-29 00:00:00   2020-04-29 00:00:00   2019-10-30 00:00:00   2020-01-30 00:00:00   2020-10-30 00:00:00   2020-07-30 00:00:00   2021-01-22 00:00:00
from_date   2015-04-01 00:00:00   2015-04-01 00:00:00   2015-01-01 00:00:00   2014-10-01 00:00:00   2014-07-01 00:00:00   2014-10-01 00:00:00   2014-07-01 00:00:00   2015-07-01 00:00:00   2015-10-01 00:00:00   2018-05-01 00:00:00   2019-04-01 00:00:00   2018-07-01 00:00:00   2019-01-01 00:00:00   2018-10-01 00:00:00   2020-01-01 00:00:00   2019-07-01 00:00:00   2019-10-01 00:00:00   2020-07-01 00:00:00   2020-04-01 00:00:00   2020-10-01 00:00:00
thru_date   2015-06-30 00:00:00   2015-06-30 00:00:00   2015-03-31 00:00:00   2014-12-31 00:00:00   2014-09-30 00:00:00   2014-12-31 00:00:00   2014-09-30 00:00:00   2015-09-30 00:00:00   2015-12-31 00:00:00   2018-06-30 00:00:00   2019-06-30 00:00:00   2018-09-30 00:00:00   2019-03-31 00:00:00   2018-12-31 00:00:00   2020-03-31 00:00:00   2019-09-30 00:00:00   2019-12-31 00:00:00   2020-09-30 00:00:00   2020-06-30 00:00:00   2020-12-31 00:00:00
cum_beg_dt   None   2015-01-01 00:00:00   2015-01-01 00:00:00   2014-08-01 00:00:00   2014-09-05 00:00:00   2014-09-05 00:00:00   2014-08-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2018-05-01 00:00:00   2019-01-01 00:00:00   2018-05-01 00:00:00   2019-01-01 00:00:00   2018-05-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
firm_name   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
firm_city   LONDON W1G 6AL UK   LONDON W1G 6AL UK   LONDON UK W1G OTT   LONDON UK W1G OTT   LONDON UK W1G OTT   LONDON UK W1G OTT   LONDON UK W1G OTT   LONDON UK W1G 0TT   LONDON UK W1G 0TT   LONDON W1K 6AF   LONDON W1K 6AF   LONDON W1K 6AF   LONDON W1K 6AF   LONDON W1K 6AF   LONDON W1K 6AF   LONDON W1K 6AF   LONDON W1K 6AF   LONDON W1K 6AF   LONDON W1K 6AF   LONDON W1K 6AF
firm_st   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
firm_zip4   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
firm_phon   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
mail_city   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
mail_zip4   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
sig_date   2015-07-30 00:00:00   2015-08-26 00:00:00   2015-04-30 00:00:00   2015-02-03 00:00:00   2015-01-30 00:00:00   2015-01-30 00:00:00   2015-02-04 00:00:00   2015-10-28 00:00:00   2016-01-29 00:00:00   2018-07-30 00:00:00   2019-07-16 00:00:00   2018-10-24 00:00:00   2019-04-29 00:00:00   2019-01-25 00:00:00   2020-04-29 00:00:00   2019-10-28 00:00:00   2020-01-28 00:00:00   2020-10-29 00:00:00   2020-07-30 00:00:00   2021-01-12 00:00:00
sig_loc   London, England   London   London, UK   London   London   London   London   London   London, UK   London, UK   London, UK   London, UK   London, UK   London, UK   London, UK   London, UK   London, UK   London, UK   London, UK   London, UK
sig_naml   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld
sig_namf   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank
sig_namt   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
prn_naml   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld
prn_namf   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank
prn_namt   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
sig_title   Head of Legal and Compliance   Partner, Legal and Compliance   Head of Legal and Compliance   Head of Legal & Compliance   Head of Legal & Compliance   Head of Legal & Compliance   Head of Legal & Compliance   Partner, Legal and Compliance   Partner, Legal and Compliance   Partner, Legal and Compliance   Partner, Legal and Compliance   Partner, Legal and Compliance   Partner, Legal and Compliance   Head of Legal and Compliance   Partner, Legal and Compliance   Partner, Legal and Compliance   Partner, Legal and Compliance   Partner, Legal and Compliance   Partner, Legal and Compliance   Partner, Legal and Compliance
nopart1_cb   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
part1_1_cb   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
ctrib_n_cb   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   None   None   None   None   None   None   None   None   None   None
lby_actvty   Investoment in Coller International Partners VII by California State Teachers' Retirement System   Investoment in Coller International Partners VII by California State Teachers' Retirement System   Investoment in Coller International Partners VII by California State Teachers' Retirement System   None   None   None   None   None   Investment in Coller International Partners VII by California State Teachers' Retirement System   Investment in Coller International Partners VIII by California State Teachers' Retirement System and California Public Employees' Retirement System.   Investment in Coller International Partners VIII by California State Teachers' Retirement System, California Public Employees' Retirement System, and Board of Regents, University of California.   Investment in Coller International Partners VIII by California State Teachers' Retirement System, California Public Employees' Retirement System and UC Regents.   Investment in Coller International Partners VIII by California State Teachers' Retirement System, California Public Employees' Retirement System, and Board of Regents, University of California.   Investment in Coller International Partners VIII by California State Teachers' Retirement System and California Public Employees' Retirement System.   Investment in Coller International Partners VIII by California Public Employees' Retirement System and UC Regents.   Investment in Coller International Partners VIII by California State Teachers' Retirement System and California Public Employees' Retirement System.   Investment in Coller International Partners VIII by California State Teachers' Retirement System, California Public Employees' Retirement System and UC Regents.   Investment in Coller International Partners VIII by UC Regents. Investor relations call with California State Teachers' Retirement System.   Investment in Coller International Partners VIII by UC Regents.   Investor relations call with California Public Employees' Retirement System.
lobby_n_cb   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
major_naml   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
major_namt   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
rcpcmte_nm   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
Table: cvr_registration
filing_id   1862237   1915873   2016626   2016626   2231971   2231971   2333753   2333753
amend_id   0   0   0   1   0   1   0   1
rec_type   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR
form_type   F603   F603   F606   F606   F603   F603   F603   F603
sender_id   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026
filer_id   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026
entity_cd   LEM   LEM   LBY   LBY   LEM   LEM   LEM   LEM
filer_naml   COLLER CAPITAL LIMITED   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.
filer_namf   None   None   None   None   None   None   None   None
filer_namt   None   None   None   None   None   None   None   None
filer_nams   None   None   None   None   None   None   None   None
report_num   000   000   000   001   000   001   000   001
rpt_date   2014-07-11 00:00:00   2014-11-20 00:00:00   2016-02-23 00:00:00   2016-04-15 00:00:00   2018-04-17 00:00:00   2018-09-05 00:00:00   2019-01-10 00:00:00   2019-07-22 00:00:00
ls_beg_yr   2013   2015   2015   2015   2017   2017   2019   2019
ls_end_yr   2014   2016   2016   2016   2018   2018   2020   2020
qual_date   2014-08-01 00:00:00   2014-09-05 00:00:00   None   None   None   None   None   None
eff_date   None   None   2016-01-28 00:00:00   2015-12-31 00:00:00   None   None   None   None
bus_city   LONDON   LONDON W1G 6AL   LONDON UK W1G 0TT   LONDON UK W1G 0TT   LONDON, UK, W1K 6AF   LONDON, UK, W1K 6AF   LONDON W1K 6AF   LONDON W1K 6AF
bus_st   XX   UK   None   None   XX   XX   XX   XX
bus_zip4   00000   00000   None   None   00000   00000   00000   00000
bus_phon   442076318574   None   None   None   None   None   None   None
bus_fax   442076318555   None   None   None   None   None   None   None
bus_email   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None
mail_city   None   None   None   None   None   None   None   None
mail_st   None   None   None   None   None   None   None   None
mail_zip4   None   None   None   None   None   None   None   None
mail_phon   None   None   None   None   None   None   None   None
sig_date   2014-07-11 00:00:00   2014-11-20 00:00:00   2016-02-23 00:00:00   2016-04-15 00:00:00   2018-04-13 00:00:00   2018-09-05 00:00:00   2019-01-10 00:00:00   2019-07-18 00:00:00
sig_loc   None   None   None   None   None   None   None   None
sig_naml   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld
sig_namf   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank
sig_namt   None   None   None   None   None   None   None   None
sig_nams   None   None   None   None   None   None   None   None
prn_naml   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld   Ochsenfeld
prn_namf   Frank   Frank   Frank   Frank   Frank   Frank   Frank   Frank
prn_namt   None   None   None   None   None   None   None   None
prn_nams   None   None   None   None   None   None   None   None
sig_title   Head of Legal & Compliance   Head of Legal & Compliance   Head of Legal and Compliance   Head of Legal and Compliance   Head of Legal & Compliance   Head of Legal & Compliance   Head of Legal & Compliance   Head of Legal & Compliance
stmt_firm   None   None   None   None   None   None   None   None
ind_cb   None   None   None   None   None   None   None   None
bus_cb   X   X   None   None   X   X   X   X
trade_cb   None   None   None   None   None   None   None   None
oth_cb   None   None   None   None   None   None   None   None
a_b_name   None   None   None   None   None   None   None   None
a_b_city   None   None   None   None   None   None   None   None
a_b_st   None   None   None   None   None   None   None   None
a_b_zip4   None   None   None   None   None   None   None   None
descrip_1   None   None   None   None   None   None   None   None
descrip_2   Coller Capital is a global investor in private equity secondaries   Coller Capital is a global investor in private equity secondaries   None   None   Coller Capital is a global investor in private equity secondaries.   Coller Capital is a global investor in private equity secondaries.   Coller Capital is a global investor in private equity secondaries.   Coller Capital is a global investor in private equity secondaries.
c_less50   None   None   None   None   None   None   None   None
c_more50   None   None   None   None   None   None   None   None
ind_class   None   None   None   None   None   None   None   None
ind_descr   None   None   None   None   None   None   None   None
bus_class   FIN   FIN   None   None   FIN   FIN   FIN   FIN
bus_descr   None   None   None   None   None   None   None   None
auth_name   None   None   None   None   None   None   None   None
auth_city   None   None   None   None   None   None   None   None
auth_st   None   None   None   None   None   None   None   None
auth_zip4   None   None   None   None   None   None   None   None
lobby_int   Coller Capital is a global investor in private equity secondaries. The procurement of investments in Coller funds.   Coller Capital is a global investor in private equity secondaries. The procurement of investments in Coller funds.   None   None   Coller Capital is a global investor in private equity secondaries. The procurement of investments in Coller funds.   Coller Capital is a global investor in private equity secondaries. The procurement of investments in Coller funds.   Coller Capital is a global investor in private equity secondaries. The procurement of investments in Coller funds.   Coller Capital is a global investor in private equity secondaries. The procurement of investments in Coller funds.
influen_yn   None   None   None   None   Y   Y   None   None
firm_name   None   None   None   None   None   None   None   None
newcert_cb   None   None   None   None   None   None   None   None
rencert_cb   None   None   None   None   None   None   None   None
complet_dt   None   None   None   None   None   None   None   None
lby_reg_cb   None   None   None   None   None   None   None   None
lby_604_cb   None   None   None   None   None   None   None   None
st_leg_yn   None   None   None   None   None   None   None   None
st_agency   None   None   None   None   None   None   None   None
lobby_cb   None   None   None   None   None   None   None   None
l_firm_cb   None   None   None   None   None   None   None   None
Table: filer_address
filer_id   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026
adrid   2466169   2451147   2451148   2507761   2322738   2321949   2340321   2361616
effect_dt   2019-01-01 00:00:00   2018-04-18 00:00:00   2018-05-01 00:00:00   2021-01-01 00:00:00   2014-08-01 00:00:00   2014-08-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00
add_type   7051   7051   7050   7051   7050   7051   7051   7050
session_id   2019   2017   2017   2021   2013   2013   2015   2015
Table: filer_filings
filer_id   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026
filing_id   1980058   1964919   1966867   1866157   1933201   1933200   1933200   1933201   1915873   1862237   1887741   1995126   1980058   2231971   2391784   2313972   2378599   2333753   2484103   2417830   2016626   2009800   2026969   2033659   2016626   2034242   2231971   2235220   2469199   2410086   2287620   2527209   2355285   2333753   2272619   2343418   2440793   2546194
period_id   222   221   None   None   220   219   219   220   220   219   None   223   222   234   238   235   237   237   242   239   225   224   None   None   226   None   235   None   241   None   None   243   None   239   234   236   240   244
form_id   F635   F635   F603   F603   F635   F635   F635   F635   F603   F603   F605   F635   F635   F603   F635   F635   F635   F603   F635   F635   F606   F635   F606   F606   F606   F888   F603   F603   F635   F605   F605   F635   F603   F603   F635   F635   F635   F635
filing_sequence   0   0   0   0   1   1   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   1   0   1   0   0   0   0   0   0   1   0   0   0   0
filing_date   2015-07-30 00:00:00   2015-04-30 00:00:00   2015-04-30 00:00:00   2014-07-24 00:00:00   2015-02-03 00:00:00   2015-02-04 00:00:00   2015-01-30 00:00:00   2015-01-30 00:00:00   2014-11-20 00:00:00   2014-07-11 00:00:00   2014-09-22 00:00:00   2015-10-28 00:00:00   2015-08-26 00:00:00   2018-04-17 00:00:00   2019-07-22 00:00:00   2018-10-26 00:00:00   2019-04-29 00:00:00   2019-01-10 00:00:00   2020-07-30 00:00:00   2019-10-30 00:00:00   2016-02-23 00:00:00   2016-01-29 00:00:00   2016-02-29 00:00:00   2016-04-25 00:00:00   2016-04-15 00:00:00   2016-04-26 00:00:00   2018-09-05 00:00:00   2018-04-18 00:00:00   2020-04-29 00:00:00   2019-07-22 00:00:00   2018-08-29 00:00:00   2020-10-30 00:00:00   2019-01-11 00:00:00   2019-07-22 00:00:00   2018-07-30 00:00:00   2019-01-29 00:00:00   2020-01-30 00:00:00   2021-01-22 00:00:00
stmnt_type   10001   10001   10005   10005   10002   10002   10001   10001   10001   10001   10006   10001   10002   10001   10001   10001   10001   10001   10001   10001   10001   10001   10003   10003   10002   10005   10002   10005   10001   10005   10005   10001   10005   10002   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   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001
session_id   2015   2015   2015   2013   2013   2013   2013   2013   2015   2013   2013   2015   2015   2017   2019   2017   2019   2019   2019   2019   2015   2015   2015   2015   2015   2015   2017   2017   2019   2019   2017   2019   2019   2019   2017   2017   2019   2019
user_id   MPACHECO   AGLADNEY   YRODRIGU   YRODRIGU   AGLADNEY   AGLADNEY   GCLARA   AGLADNEY   YRODRIGU   YRODRIGU   YRODRIGU   JINGRAM   MPACHECO   GPEREZ   VUKSTINA   AGLADNEY   VUKSTINA   YRODRIGU   MMERCHANT   VUKSTINA   YRODRIGU   AGLADNEY   YRODRIGU   YRODRIGU   YRODRIGU   YRODRIGU   YRODRIGU   GPEREZ   VUKSTINA   SARRIAGA   GPEREZ   GTAYLOR   YRODRIGU   SARRIAGA   AGLADNEY   AGLADNEY   VUKSTINA   GTAYLOR
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
fine_audit   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11003   11003   11001   11003   11003   11001   11001   11001   11001
rpt_start   2015-04-01 00:00:00   2015-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2014-10-01 00:00:00   2014-07-01 00:00:00   2014-07-01 00:00:00   2014-10-01 00:00:00   2014-11-20 00:00:00   2014-07-11 00:00:00   1900-01-01 00:00:00   2015-07-01 00:00:00   2015-04-01 00:00:00   2018-04-17 00:00:00   2019-04-01 00:00:00   2018-07-01 00:00:00   2019-01-01 00:00:00   2019-01-10 00:00:00   2020-04-01 00:00:00   2019-07-01 00:00:00   2016-02-23 00:00:00   2015-10-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2016-04-15 00:00:00   None   2018-09-05 00:00:00   1900-01-01 00:00:00   2020-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2020-07-01 00:00:00   1900-01-01 00:00:00   2019-07-22 00:00:00   2018-05-01 00:00:00   2018-10-01 00:00:00   2019-10-01 00:00:00   2020-10-01 00:00:00
rpt_end   2015-06-30 00:00:00   2015-03-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2014-12-31 00:00:00   2014-09-30 00:00:00   2014-09-30 00:00:00   2014-12-31 00:00:00   2014-11-20 00:00:00   2014-07-11 00:00:00   1900-01-01 00:00:00   2015-09-30 00:00:00   2015-06-30 00:00:00   2018-04-17 00:00:00   2019-06-30 00:00:00   2018-09-30 00:00:00   2019-03-31 00:00:00   2019-01-10 00:00:00   2020-06-30 00:00:00   2019-09-30 00:00:00   2016-02-23 00:00:00   2015-12-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2016-04-15 00:00:00   None   2018-09-05 00:00:00   1900-01-01 00:00:00   2020-03-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2020-09-30 00:00:00   1900-01-01 00:00:00   2019-07-22 00:00:00   2018-06-30 00:00:00   2018-12-31 00:00:00   2019-12-31 00:00:00   2020-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
filing_type   22006   22006   None   None   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   None   None   22006   None   22006   None   22006   None   None   22006   None   22006   22006   22006   22006   22006
Table: filer_interests
filer_id   1368026   1368026   1368026   1368026   1368026
session_id   2015   2017   2019   2013   2021
interest_cd   40304   40304   40304   40304   40304
effect_date   2015-01-01 00:00:00   2018-05-01 00:00:00   2019-01-01 00:00:00   2014-08-01 00:00:00   2021-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1368026   1368026   1368026   1368026   1368026   1368026
filer_type   2   2   2   2   2   2
active   Y   N   Y   Y   T   Y
race   0   None   None   None   None   None
session_id   2013   2021   2015   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   2014-08-01 00:00:00   2021-01-01 00:00:00   2015-01-01 00:00:00   2019-01-01 00:00:00   2015-12-31 00:00:00   2018-05-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
Table: filer_xref
filer_id   1368026
xref_id   1368026
effect_dt   2014-07-10 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026
filer_id   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026   1368026
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   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER
status   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE
effect_dt   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00
naml   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.
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   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   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   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   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
city   LONDON UK W1G 0TT   None   LONDON UK W1G 0TT   None   LONDON W1K 6AF   None   LONDON W1K 6AF   LONDON W1K 6AF   LONDON UK W1G 0TT   None   LONDON UK W1G 0TT   None   LONDON W1K 6AF   None   LONDON W1K 6AF   LONDON W1K 6AF   LONDON UK W1G 0TT   None   LONDON UK W1G 0TT   None   LONDON W1K 6AF   None   LONDON W1K 6AF   LONDON W1K 6AF   LONDON UK W1G 0TT   None   LONDON UK W1G 0TT   None   LONDON W1K 6AF   None   LONDON W1K 6AF   LONDON W1K 6AF   LONDON UK W1G 0TT   None   LONDON UK W1G 0TT   None   LONDON W1K 6AF   None   LONDON W1K 6AF   LONDON W1K 6AF
st                                                                                                                        
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   None   None   None   None
phon                                                                                                                        
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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
email   [email protected]   None   [email protected]   None   None   None   None   None   [email protected]   None   [email protected]   None   None   None   None   None   [email protected]   None   [email protected]   None   None   None   None   None   [email protected]   None   [email protected]   None   None   None   None   None   [email protected]   None   [email protected]   None   None   None   None   None
Table: filers
filer_id   1368026
Table: lobbying_chg_log
filer_id   1368026   1368026   1368026   1368026   1368026   1368026   1368026
change_no   0   1   2   3   4   5   6
session_id   2013   2013   2013   2013   2015   2017   2017
log_dt   2014-07-24 00:00:00   2014-07-24 00:00:00   2014-07-24 00:00:00   2014-09-22 00:00:00   2015-04-30 00:00:00   2018-04-18 00:00:00   2018-04-18 00:00:00
filer_type   2   2   2   2   2   2   2
correction_flg   None   None   None   None   Y   Y   Y
action   ADDED   SET ACTIVE   SET ACTIVE   DELETED   ADDED   ADDED   ADDED
attribute_changed   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST
ethics_dt   None   None   None   None   None   None   None
interests   None   None   None   None   None   None   None
filer_full_name   COLLER CAPITAL LIMITED   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.   COLLER CAPITAL LIMITED AND ITS AFFILIATE COLLER CAPITAL, INC.
filer_city   None   None   None   None   None   None   LONDON W1K 6AF
filer_st   None   None   None   None      None   
filer_zip   None   None   None   None   None   None   None
filer_phone   None   None   None   None      None   
entity_type   4   4   4   4   4   4   4
entity_name   SUSAN D. L. FLYNN   SUSAN D. L. FLYNN   ASHLEY JOHANSEN   SUSAN D. L. FLYNN   JOHANSEN, ASHLEY   KATARINCIC, JIM D.   ZIFF, STEPHEN
entity_city   None   None   None   None   None   None   None
entity_st   None   None   None   None   None   None   None
entity_zip   None   None   None   None   None   None   None
entity_phone   None   None   None   None   None   None   None
entity_id   1368505   1368505   1368504   1368505   None   0   None
responsible_officer   None   None   None   None   None   None   None
effect_dt   2014-08-01 00:00:00   2014-08-01 00:00:00   2014-08-01 00:00:00   2014-08-01 00:00:00   2015-01-01 00:00:00   2018-05-01 00:00:00   2018-05-01 00:00:00