| filing_id | 2390826 | 2376532 | 2432188 | 2413247 | 2471943 | 2479811 | 2547825 | 2527180 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||
| rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||
| form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | ||||||||
| sender_id | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | ||||||||
| filer_id | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | ||||||||
| entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | ||||||||
| filer_naml | NEWBERRY | NEWBERRY | NEWBERRY | NEWBERRY | NEWBERRY | NEWBERRY | NEWBERRY | NEWBERRY | ||||||||
| filer_namf | MAX | MAX | MAX | MAX | MAX | MAX | MAX | MAX | ||||||||
| 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 | 000 | 000 | 000 | 000 | 000 | ||||||||
| rpt_date | 2019-07-18 00:00:00 | 2019-04-24 00:00:00 | 2020-01-20 00:00:00 | 2019-10-16 00:00:00 | 2020-05-01 00:00:00 | 2020-07-22 00:00:00 | 2021-01-27 00:00:00 | 2020-10-30 00:00:00 | ||||||||
| from_date | 2019-04-01 00:00:00 | 2019-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-04-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | ||||||||
| thru_date | 2019-06-30 00:00:00 | 2019-03-31 00:00:00 | 2019-12-31 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | ||||||||
| cum_beg_dt | None | None | None | None | None | None | None | None | ||||||||
| firm_id | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | ||||||||
| firm_name | HgCapital LLP | HgCapital LLP | HgCapital LLP | HgCapital LLP | HgCapital LLP | HgCapital LLP | HgCapital LLP | HgCapital LLP | ||||||||
| firm_city | LONDON SE1 2AP UNITED KINGDOM | LONDON SE1 2AP UNITED KINGDOM | LONDON SE1 2AP UNITED KINGDOM | LONDON SE1 2AP UNITED KINGDOM | LONDON SE1 2AP UNITED KINGDOM | LONDON SE1 2AP UNITED KINGDOM | LONDON SE1 2AP UNITED KINGDOM | LONDON SE1 2AP UNITED KINGDOM | ||||||||
| firm_st | None | None | None | None | None | None | None | None | ||||||||
| firm_zip4 | None | None | None | None | None | None | None | None | ||||||||
| firm_phon | 2070897920 | 2070897920 | 2070897920 | 2070897920 | 2070897920 | 2070897920 | 2070897920 | 2070897920 | ||||||||
| 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 | 2019-07-18 00:00:00 | 2019-04-24 00:00:00 | 2020-01-17 00:00:00 | 2019-10-10 00:00:00 | 2020-05-01 00:00:00 | 2020-07-22 00:00:00 | 2021-01-27 00:00:00 | 2020-10-30 00:00:00 | ||||||||
| sig_loc | London | London | London | London | London | London | London | London | ||||||||
| sig_naml | Newberry | Newberry | Newberry | Newberry | Newberry | Newberry | Newberry | Newberry | ||||||||
| sig_namf | Max | Max | Max | Max | Max | Max | Max | Max | ||||||||
| sig_namt | None | None | None | None | None | None | None | None | ||||||||
| sig_nams | None | None | None | None | None | None | None | None | ||||||||
| prn_naml | Newberry | Newberry | Newberry | Newberry | Newberry | Newberry | Newberry | Newberry | ||||||||
| prn_namf | Max | Max | Max | Max | Max | Max | Max | Max | ||||||||
| prn_namt | None | None | None | None | None | None | None | None | ||||||||
| prn_nams | None | None | None | None | None | None | None | None | ||||||||
| sig_title | Associate | Associate | Associate | None | None | Senior Associate | Senior Associate | Senior Associate | ||||||||
| nopart1_cb | X | X | X | X | X | X | X | X | ||||||||
| nopart2_cb | X | X | X | X | X | X | X | X | ||||||||
| part1_1_cb | None | None | None | None | None | None | None | None | ||||||||
| part1_2_cb | None | None | None | None | None | None | None | None | ||||||||
| ctrib_n_cb | None | None | None | None | None | None | None | None | ||||||||
| ctrib_y_cb | None | None | None | None | None | None | None | None | ||||||||
| lby_actvty | None | None | None | None | None | None | None | None | ||||||||
| lobby_n_cb | None | None | None | None | None | None | None | None | ||||||||
| lobby_y_cb | None | None | None | None | None | None | None | None | ||||||||
| major_naml | None | None | None | None | None | None | None | None | ||||||||
| major_namf | None | None | None | None | None | None | None | None | ||||||||
| major_namt | None | None | None | None | None | None | None | None | ||||||||
| major_nams | None | None | None | None | None | None | None | None | ||||||||
| rcpcmte_nm | None | None | None | None | None | None | None | None | ||||||||
| rcpcmte_id | None | None | None | None | None | None | None | None |
| filing_id | 2326019 | 2326019 | 2538778 | |||
|---|---|---|---|---|---|---|
| amend_id | 0 | 1 | 0 | |||
| rec_type | CVR | CVR | CVR | |||
| form_type | F604 | F604 | F606 | |||
| sender_id | 1338040 | 1338040 | 1338040 | |||
| filer_id | 1414213 | 1414213 | 1414213 | |||
| entity_cd | LBY | LBY | LBY | |||
| filer_naml | NEWBERRY | NEWBERRY | NEWBERRY | |||
| filer_namf | MAX | MAX | MAX | |||
| filer_namt | None | None | None | |||
| filer_nams | None | None | None | |||
| report_num | 000 | 001 | 000 | |||
| rpt_date | 2018-11-20 00:00:00 | 2019-06-04 00:00:00 | 2020-12-29 00:00:00 | |||
| ls_beg_yr | 2019 | 2019 | 2019 | |||
| ls_end_yr | 2020 | 2020 | 2020 | |||
| qual_date | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | None | |||
| eff_date | None | None | 2020-12-31 00:00:00 | |||
| bus_city | LONDON | LONDON | LONDON SE1 2AP UNITED KINGDOM | |||
| bus_st | XX | XX | UK | |||
| bus_zip4 | 00000 | 00000 | 00000 | |||
| bus_phon | 2070897920 | 2070897920 | None | |||
| bus_fax | None | None | None | |||
| bus_email | [email protected] | [email protected] | None | |||
| mail_city | None | None | None | |||
| mail_st | None | None | None | |||
| mail_zip4 | None | None | None | |||
| mail_phon | None | None | None | |||
| sig_date | 2018-11-20 00:00:00 | 2019-06-04 00:00:00 | 2020-12-29 00:00:00 | |||
| sig_loc | None | None | None | |||
| sig_naml | NEWBERRY | NEWBERRY | Newberry | |||
| sig_namf | MAX | MAX | Max | |||
| sig_namt | None | None | None | |||
| sig_nams | None | None | None | |||
| prn_naml | NEWBERRY | NEWBERRY | Newberry | |||
| prn_namf | MAX | MAX | Max | |||
| prn_namt | None | None | None | |||
| prn_nams | None | None | None | |||
| sig_title | None | None | Mr | |||
| stmt_firm | None | None | None | |||
| ind_cb | None | None | None | |||
| bus_cb | None | None | None | |||
| trade_cb | None | None | None | |||
| oth_cb | None | None | None | |||
| a_b_name | None | None | None | |||
| a_b_city | None | None | None | |||
| a_b_st | None | None | None | |||
| a_b_zip4 | None | None | None | |||
| descrip_1 | None | None | None | |||
| descrip_2 | None | None | None | |||
| c_less50 | None | None | None | |||
| c_more50 | None | None | None | |||
| ind_class | None | None | None | |||
| ind_descr | None | None | None | |||
| bus_class | None | None | None | |||
| bus_descr | None | None | None | |||
| auth_name | None | None | None | |||
| auth_city | None | None | None | |||
| auth_st | None | None | None | |||
| auth_zip4 | None | None | None | |||
| lobby_int | None | None | None | |||
| influen_yn | None | None | None | |||
| firm_name | HgCapital LLP | HgCapital LLP | HG CAPITAL LLP | |||
| newcert_cb | X | None | None | |||
| rencert_cb | None | None | None | |||
| complet_dt | None | 2019-05-23 00:00:00 | None | |||
| lby_reg_cb | X | X | None | |||
| lby_604_cb | None | None | None | |||
| st_leg_yn | N | N | None | |||
| st_agency | None | None | None | |||
| lobby_cb | None | None | None | |||
| l_firm_cb | None | None | None |
| filer_id | 1414213 | 1414213 | ||
|---|---|---|---|---|
| adrid | 2465274 | 2505065 | ||
| effect_dt | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | ||
| add_type | 7051 | 7051 | ||
| session_id | 2019 | 2021 |
| filer_id | 1414213 | |
|---|---|---|
| session_id | 2019 | |
| ethics_date | 2019-05-23 00:00:00 |
| filer_id | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | 1414213 | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 2432188 | 2479811 | 2388612 | 2413247 | 2527180 | 2335877 | 2326019 | 2326019 | 2376532 | 2471943 | 2390826 | 2538778 | 2571732 | 2547825 | ||||||||||||||
| period_id | 240 | 242 | None | 239 | 243 | None | 238 | 236 | 237 | 241 | 238 | 244 | None | 244 | ||||||||||||||
| form_id | F615 | F615 | F604 | F615 | F615 | F604 | F604 | F604 | F615 | F615 | F615 | F606 | F606 | F615 | ||||||||||||||
| filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
| filing_date | 2020-01-20 00:00:00 | 2020-07-22 00:00:00 | 2019-06-10 00:00:00 | 2019-10-16 00:00:00 | 2020-10-30 00:00:00 | 2018-12-07 00:00:00 | 2019-06-04 00:00:00 | 2018-11-20 00:00:00 | 2019-04-24 00:00:00 | 2020-05-01 00:00:00 | 2019-07-18 00:00:00 | 2020-12-29 00:00:00 | 2020-12-30 00:00:00 | 2021-01-27 00:00:00 | ||||||||||||||
| stmnt_type | 10001 | 10001 | 10006 | 10001 | 10001 | 10005 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10003 | 10001 | ||||||||||||||
| stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||
| session_id | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2019 | ||||||||||||||
| user_id | GTAYLOR | CVANLIEW | SUSHAKOV | GTAYLOR | MKIRKHAM | PBANFORD | CAFILER | PBANFORD | VUKSTINA | GTAYLOR | GTAYLOR | MMERCHANT | MMERCHANT | CAFILER | ||||||||||||||
| special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||
| fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | ||||||||||||||
| rpt_start | 2019-10-01 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2020-07-01 00:00:00 | 1900-01-01 00:00:00 | 2019-06-04 00:00:00 | 2018-11-20 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 | 2019-04-01 00:00:00 | 2020-12-29 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | ||||||||||||||
| rpt_end | 2019-12-31 00:00:00 | 2020-06-30 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2020-09-30 00:00:00 | 1900-01-01 00:00:00 | 2019-06-04 00:00:00 | 2018-11-20 00:00:00 | 2019-03-31 00:00:00 | 2020-03-31 00:00:00 | 2019-06-30 00:00:00 | 2020-12-29 00:00:00 | 1900-01-01 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 | ||||||||||||||
| filing_type | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 |
| filer_id | 1414213 | 1414213 | 1414213 | |||
|---|---|---|---|---|---|---|
| filer_type | 4 | 4 | 4 | |||
| active | Y | T | N | |||
| race | 0 | None | None | |||
| session_id | 2019 | 2019 | 2021 | |||
| category | 0 | None | None | |||
| category_type | 0 | None | None | |||
| sub_category | 0 | None | None | |||
| effect_dt | 2019-01-01 00:00:00 | 2020-12-31 00:00:00 | 2021-01-01 00:00:00 | |||
| sub_category_type | 0 | None | None | |||
| election_type | 0 | None | None | |||
| sub_category_a | None | None | None | |||
| nyq_dt | None | None | None | |||
| party_cd | 0 | None | None | |||
| county_cd | 0 | None | None | |||
| district_cd | 0 | None | None |
| filer_id | 1414213 | |
|---|---|---|
| xref_id | 1414213 | |
| effect_dt | 2018-11-19 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1414213 | 1414213 | 1414213 | 1414213 | ||||
|---|---|---|---|---|---|---|---|---|
| filer_id | 1414213 | 1414213 | 1414213 | 1414213 | ||||
| filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||
| status | 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 | ||||
| naml | NEWBERRY | NEWBERRY | NEWBERRY | NEWBERRY | ||||
| namf | MAX | MAX | MAX | MAX | ||||
| namt | None | None | None | None | ||||
| nams | None | None | None | None | ||||
| adr1 | None | None | None | None | ||||
| adr2 | None | None | None | None | ||||
| city | LONDON SE1 2AP UNITED KINGDOM | LONDON SE1 2AP UNITED KINGDOM | LONDON SE1 2AP UNITED KINGDOM | LONDON SE1 2AP UNITED KINGDOM | ||||
| st | None | None | None | None | ||||
| zip4 | ||||||||
| phon | 2070897920 | 2070897920 | 2070897920 | 2070897920 | ||||
| fax | None | None | None | None | ||||
| [email protected] | [email protected] | [email protected] | [email protected] |
| filer_id | 1414213 |
|---|
| filer_id | 1414213 | 1414213 | 1414213 | |||
|---|---|---|---|---|---|---|
| filing_file_name | 44913.cal | 44933.cal | 43449.cal | |||
| received_date | 2019-05-29 00:00:00 | 2019-05-29 00:00:00 | 2019-05-29 00:00:00 | |||
| filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | |||
| filing_id | None | None | None | |||
| form_id | None | None | None | |||
| receive_comment | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints |