filing_id | 2085544 | 2053308 | 2026908 | 2018455 | 2149134 | 2117764 | 2186720 | 2186718 | 2199814 | 2262395 | 2228281 | 2302685 | 2389166 | 2389166 | 2333028 | 2370286 | 2413139 | 2436171 | 2467252 | 2545993 | 2481329 | 2524928 | 2621958 | 2597399 | 2545993 | 2578590 | 2699161 | 2671427 | 2640858 | 2744932 | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | ||||||||||||||||||||||||||||||
form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||
sender_id | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | ||||||||||||||||||||||||||||||
filer_id | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | ||||||||||||||||||||||||||||||
entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | ||||||||||||||||||||||||||||||
filer_naml | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ||||||||||||||||||||||||||||||
filer_namf | JENNIFER J. | JENNIFER J. | JENNIFER J. | JENNIFER J. | JENNIFER | JENNIFER J. | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | ||||||||||||||||||||||||||||||
rpt_date | 2016-10-05 00:00:00 | 2016-07-05 00:00:00 | 2016-04-08 00:00:00 | 2016-03-03 00:00:00 | 2017-04-03 00:00:00 | 2017-01-06 00:00:00 | 2017-10-06 00:00:00 | 2017-10-06 00:00:00 | 2018-01-03 00:00:00 | 2018-07-03 00:00:00 | 2018-04-04 00:00:00 | 2018-10-05 00:00:00 | 2019-07-09 00:00:00 | 2019-07-09 00:00:00 | 2019-01-09 00:00:00 | 2019-04-04 00:00:00 | 2019-10-15 00:00:00 | 2020-01-27 00:00:00 | 2020-04-24 00:00:00 | 2021-01-22 00:00:00 | 2020-07-27 00:00:00 | 2020-10-28 00:00:00 | 2021-10-29 00:00:00 | 2021-07-27 00:00:00 | 2021-10-11 00:00:00 | 2021-04-29 00:00:00 | 2022-07-19 00:00:00 | 2022-04-27 00:00:00 | 2022-01-28 00:00:00 | 2022-10-28 00:00:00 | ||||||||||||||||||||||||||||||
from_date | 2016-07-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2015-12-09 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-07-01 00:00:00 | 2017-04-01 00:00:00 | 2017-10-01 00:00:00 | 2018-04-01 00:00:00 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2019-04-01 00:00:00 | 2019-04-01 00:00:00 | 2018-10-01 00:00:00 | 2019-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2020-10-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||
thru_date | 2016-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2015-12-31 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 2017-09-30 00:00:00 | 2017-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 2018-03-31 00:00:00 | 2018-09-30 00:00:00 | 2019-06-30 00:00:00 | 2019-06-30 00:00:00 | 2018-12-31 00:00:00 | 2019-03-31 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||
cum_beg_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
firm_id | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | ||||||||||||||||||||||||||||||
firm_name | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo, LLC | Thoma Bravo, L.P. | Thoma Bravo, LLC | Thoma Bravo, L.P. | Thoma Bravo, LP | Thoma Bravo, LP | Thoma Bravo, L.P. | Thoma Bravo, LLC | Jennifer James Alper | Thoma Bravo, LP | Thoma Bravo, LP | THOMA BRAVO, LP | ||||||||||||||||||||||||||||||
firm_city | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | ||||||||||||||||||||||||||||||
firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||
firm_zip4 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | ||||||||||||||||||||||||||||||
firm_phon | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
sig_date | 2016-10-05 00:00:00 | 2016-07-05 00:00:00 | 2016-04-08 00:00:00 | 2016-03-03 00:00:00 | 2017-04-03 00:00:00 | 2017-01-06 00:00:00 | 2017-10-06 00:00:00 | 2017-07-13 00:00:00 | 2018-01-03 00:00:00 | 2018-07-03 00:00:00 | 2018-04-04 00:00:00 | 2018-10-05 00:00:00 | 2019-07-09 00:00:00 | 2019-07-09 00:00:00 | 2019-01-09 00:00:00 | 2019-04-04 00:00:00 | 2019-10-15 00:00:00 | 2020-01-27 00:00:00 | 2020-04-24 00:00:00 | 2021-01-22 00:00:00 | 2020-07-27 00:00:00 | 2020-10-28 00:00:00 | 2021-10-29 00:00:00 | 2021-07-27 00:00:00 | 2021-10-11 00:00:00 | 2021-04-29 00:00:00 | 2022-07-19 00:00:00 | 2022-04-27 00:00:00 | 2022-01-28 00:00:00 | 2022-10-28 00:00:00 | ||||||||||||||||||||||||||||||
sig_loc | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | SAN FRANCISCO, CA | SAN FRANCISCO, CA | San Francisco, CA | SAN FRANCISCO | San Francisco, CA | San Francisco, CA | San Francisco, CA | SAN FRANCISCO | San Francisco, CA | SAN FRANCISCO | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | SAN FRANCISCO, CA | ||||||||||||||||||||||||||||||
sig_naml | Alper | Alper | James Alper | Alper | James Alper | James Alper | Alper | Alper | James Alper | James Alper | James Alper | Alper | Yates | Alper | Alper | Alper | Alper | Alper | Alper | Alper | Alper | ALPER | Alper | Alper | Alper | Alper | Alper | Alper | Alper | ALPER | ||||||||||||||||||||||||||||||
sig_namf | Jennifer J. | Jennifer J. | Jennifer | Jennifer | Jennifer | Jennifer | Jennifer James | Jennifer James | Jennifer | Jennifer | Jennifer | Jennifer | Elizabeth | Jennifer | Jennifer | Jennifer | Jennifer | Jennifer | Jennifer | Jennifer | Jennifer | JENNIFER | Jennifer | Jennifer | Jennifer | Jennifer | Jennifer James | Jennifer | Jennifer | JENNIFER | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
prn_naml | Alper | Alper | James Alper | Alper | James Alper | James Alper | Alper | Alper | James Alper | James Alper | James Alper | Alper | Yates | Alper | Alper | Alper | Alper | Alper | Alper | Alper | Alper | ALPER | Alper | Alper | Alper | Alper | Alper | Alper | Alper | ALPER | ||||||||||||||||||||||||||||||
prn_namf | Jennifer J. | Jennifer J. | Jennifer | Jennifer | Jennifer | Jennifer | Jennifer James | Jennifer James | Jennifer | Jennifer | Jennifer | Jennifer | Elizabeth | Jennifer | Jennifer | Jennifer | Jennifer | Jennifer | Jennifer | Jennifer | Jennifer | JENNIFER | Jennifer | Jennifer | Jennifer | Jennifer | Jennifer James | Jennifer | Jennifer | JENNIFER | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
sig_title | Director, Investor Relations | Director of Investor Relations | Director, Head of Investor Relations | Director | Managing Director, Investor Relations | Director, Investor Relations | Managing Director, Investor Relations | Managing Director | Managing Director, Investor Relations | Managing Director, Investor Relations | Managing Director, Investor Relations | Managing Director, Investor Relations | Vice President, Investor Relations | Managing Dir., Investor Relations & Marketing | Managing Dir., Investor Relations & Marketing | Managing Dir., Investor Relations & Marketing | None | None | Managing Director, Investor Relations | MANAGING DIRECTOR,HEAD OF IR & MARKETING, COO | Head of Investor Relations and Marketing | MANAGING DIRECTOR,HEAD OF IR & MARKETING | Managing Director, Investor Relations | Managing Director, Investor Relations | Managing Director, Investor Relations | Managing Director, Investor Relations | Managing Director, COO | Managing Director, Investor Relations | Managing Director, Investor Relations | MANAGING DIRECTOR, HEAD OF INVESTOR RELATIONS | ||||||||||||||||||||||||||||||
nopart1_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||||||||||||||||||||||
nopart2_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
ctrib_n_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
ctrib_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
lby_actvty | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 |
filing_id | 2001499 | 2110530 | ||
---|---|---|---|---|
amend_id | 0 | 0 | ||
rec_type | CVR | CVR | ||
form_type | F604 | F604 | ||
sender_id | 1381474 | 1381474 | ||
filer_id | 1381636 | 1381636 | ||
entity_cd | LBY | LBY | ||
filer_naml | ALPER | Alper | ||
filer_namf | JENNIFER JAMES | Jennifer | ||
filer_namt | None | None | ||
filer_nams | None | None | ||
report_num | 000 | 000 | ||
rpt_date | 2015-12-16 00:00:00 | 2016-12-13 00:00:00 | ||
ls_beg_yr | 2015 | 2017 | ||
ls_end_yr | 2016 | 2018 | ||
qual_date | 2015-12-15 00:00:00 | None | ||
eff_date | None | None | ||
bus_city | SAN FRANCISCO | SAN FRANCISCO | ||
bus_st | CA | CA | ||
bus_zip4 | 94111 | 94111 | ||
bus_phon | 3122543327 | 4152496717 | ||
bus_fax | None | None | ||
bus_email | None | None | ||
mail_city | None | None | ||
mail_st | None | None | ||
mail_zip4 | None | None | ||
mail_phon | None | None | ||
sig_date | 2015-12-08 00:00:00 | 2016-12-13 00:00:00 | ||
sig_loc | None | None | ||
sig_naml | ALPER | Alper | ||
sig_namf | JENNIFER JAMES | Jennifer | ||
sig_namt | None | None | ||
sig_nams | None | None | ||
prn_naml | ALPER | Alper | ||
prn_namf | JENNIFER JAMES | Jennifer | ||
prn_namt | None | None | ||
prn_nams | None | None | ||
sig_title | None | None | ||
stmt_firm | None | None | ||
ind_cb | None | None | ||
bus_cb | None | None | ||
trade_cb | None | None | ||
oth_cb | None | None | ||
a_b_name | None | None | ||
a_b_city | None | None | ||
a_b_st | None | None | ||
a_b_zip4 | None | None | ||
descrip_1 | None | None | ||
descrip_2 | None | None | ||
c_less50 | None | None | ||
c_more50 | None | None | ||
ind_class | None | None | ||
ind_descr | None | None | ||
bus_class | None | None | ||
bus_descr | None | None | ||
auth_name | None | None | ||
auth_city | None | None | ||
auth_st | None | None | ||
auth_zip4 | None | None | ||
lobby_int | None | None | ||
influen_yn | None | None | ||
firm_name | Thoma Bravo, LLC | Thoma Bravo, LLC | ||
newcert_cb | X | None | ||
rencert_cb | None | None | ||
complet_dt | None | 2016-11-17 00:00:00 | ||
lby_reg_cb | X | X | ||
lby_604_cb | None | None | ||
st_leg_yn | N | N | ||
st_agency | None | None | ||
lobby_cb | None | None | ||
l_firm_cb | None | None |
filer_id | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | |||||
---|---|---|---|---|---|---|---|---|---|---|
adrid | 2409789 | 2507996 | 2467402 | 2546627 | 2377040 | |||||
effect_dt | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | 2015-12-09 00:00:00 | |||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | |||||
session_id | 2017 | 2021 | 2019 | 2023 | 2015 |
filer_id | 1381636 | 1381636 | 1381636 | |||
---|---|---|---|---|---|---|
session_id | 2017 | 2019 | 2021 | |||
ethics_date | 2016-11-17 00:00:00 | 2019-06-27 00:00:00 | 2021-04-15 00:00:00 |
filer_id | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | ||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2481329 | 2467252 | 2186720 | 2262395 | 2018455 | 2001499 | 2005077 | 2026908 | 2085544 | 2053308 | 2117764 | 2110530 | 2113317 | 2149134 | 2333028 | 2336020 | 2389166 | 2436171 | 2199814 | 2413139 | 2389166 | 2186718 | 2400502 | 2302685 | 2228281 | 2370286 | 2597399 | 2591473 | 2545993 | 2524928 | 2671427 | 2640858 | 2621958 | 2583614 | 2545993 | 2578590 | 2699161 | 2744932 | ||||||||||||||||||||||||||||||||||||||
period_id | 242 | 241 | 231 | 234 | 224 | 224 | None | 225 | 227 | 226 | 228 | 228 | None | 229 | 236 | None | 238 | 240 | 232 | 239 | 238 | 230 | None | 235 | 233 | 237 | 246 | None | 244 | 243 | 249 | 248 | 247 | None | 244 | 245 | 250 | 251 | ||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
filing_date | 2020-07-27 00:00:00 | 2020-04-24 00:00:00 | 2017-10-06 00:00:00 | 2018-07-03 00:00:00 | 2016-03-03 00:00:00 | 2015-12-16 00:00:00 | 2015-12-23 00:00:00 | 2016-04-08 00:00:00 | 2016-10-05 00:00:00 | 2016-07-05 00:00:00 | 2017-01-06 00:00:00 | 2016-12-13 00:00:00 | 2016-12-19 00:00:00 | 2017-04-03 00:00:00 | 2019-01-09 00:00:00 | 2018-12-24 00:00:00 | 2019-07-09 00:00:00 | 2020-01-27 00:00:00 | 2018-01-03 00:00:00 | 2019-10-15 00:00:00 | 2019-07-09 00:00:00 | 2017-10-06 00:00:00 | 2019-07-02 00:00:00 | 2018-10-05 00:00:00 | 2018-04-04 00:00:00 | 2019-04-04 00:00:00 | 2021-07-27 00:00:00 | 2021-06-23 00:00:00 | 2021-10-11 00:00:00 | 2020-10-28 00:00:00 | 2022-04-27 00:00:00 | 2022-01-28 00:00:00 | 2021-10-29 00:00:00 | 2021-01-11 00:00:00 | 2021-01-22 00:00:00 | 2021-04-29 00:00:00 | 2022-07-19 00:00:00 | 2022-10-28 00:00:00 | ||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||
stmnt_status | 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 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||
session_id | 2019 | 2019 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2017 | 2019 | 2021 | 2021 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||
user_id | VUKSTINA | SUSHAKOV | AGLADNEY | AGLADNEY | DWALKER | YRODRIGU | YRODRIGU | AGLADNEY | JINGRAM | AGLADNEY | AGLADNEY | CAFILER | SARRIAGA | JINGRAM | AGLADNEY | DMCCASTL | VUKSTINA | VUKSTINA | AGLADNEY | GTAYLOR | VUKSTINA | KBANH | VUKSTINA | JFRONEFIELD | AGLADNEY | SUSHAKOV | CHATRIDGE | MMERCHANT | CAFILER | GTAYLOR | CAFILER | RATTIYEH | GTAYLOR | JMENDOZA | MKIRKHAM | GTAYLOR | CAFILER | 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 | ||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||
rpt_start | 2020-04-01 00:00:00 | 2020-01-01 00:00:00 | 2017-07-01 00:00:00 | 2018-04-01 00:00:00 | 2015-12-09 00:00:00 | 2015-12-16 00:00:00 | 1900-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-07-01 00:00:00 | 2016-04-01 00:00:00 | 2016-10-01 00:00:00 | 2016-12-13 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2018-10-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2019-10-01 00:00:00 | 2017-10-01 00:00:00 | 2019-07-01 00:00:00 | 2019-04-01 00:00:00 | 2017-04-01 00:00:00 | 1900-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-07-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||
rpt_end | 2020-06-30 00:00:00 | 2020-03-31 00:00:00 | 2017-09-30 00:00:00 | 2018-06-30 00:00:00 | 2015-12-31 00:00:00 | 2015-12-16 00:00:00 | 1900-01-01 00:00:00 | 2016-03-31 00:00:00 | 2016-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-12-31 00:00:00 | 2016-12-13 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 2019-12-31 00:00:00 | 2017-12-31 00:00:00 | 2019-09-30 00:00:00 | 2019-06-30 00:00:00 | 2017-06-30 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 2018-03-31 00:00:00 | 2019-03-31 00:00:00 | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2022-03-31 00:00:00 | 2021-12-31 00:00:00 | 2021-09-30 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 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 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 |
filer_id | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | |||||
---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | |||||
active | Y | Y | Y | Y | N | |||||
race | None | None | 0 | None | None | |||||
session_id | 2019 | 2021 | 2015 | 2017 | 2023 | |||||
category | None | None | 0 | None | None | |||||
category_type | None | None | 0 | None | None | |||||
sub_category | None | None | 0 | None | None | |||||
effect_dt | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-12-09 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||
sub_category_type | None | None | 0 | None | None | |||||
election_type | None | None | 0 | None | None | |||||
sub_category_a | None | None | None | None | None | |||||
nyq_dt | None | None | None | None | None | |||||
party_cd | None | None | 0 | None | None | |||||
county_cd | None | None | 0 | None | None | |||||
district_cd | None | None | 0 | None | None |
filer_id | 1381636 | |
---|---|---|
xref_id | 1381636 | |
effect_dt | 2015-12-16 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | |||||||||||||||||||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||||||||||||||
naml | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | ALPER | |||||||||||||||||||||||||
namf | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER | JENNIFER J. | JENNIFER J. | JENNIFER J. | JENNIFER J. | JENNIFER J. | |||||||||||||||||||||||||
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 | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | |||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||
zip4 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | |||||||||||||||||||||||||
phon | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | 4152496717 | |||||||||||||||||||||||||
fax | ||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 1381636 |
---|
filer_id | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | 1381636 | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 349214.cal | 349208.cal | 349356.cal | 2001499_0.cal | 2110530_0.cal | 388636.cal | 96792.cal | 96668.cal | 96710.cal | 96663.cal | 349685.cal | 336634.cal | 363538.cal | 84362.cal | 260679.cal | 140029.cal | 363434.cal | 84235.cal | 479533.cal | 363506.cal | ||||||||||||||||||||
received_date | 2016-07-05 00:00:00 | 2016-07-05 00:00:00 | 2016-07-05 00:00:00 | 2015-12-16 00:00:00 | 2016-12-13 00:00:00 | 2016-10-05 00:00:00 | 2020-07-27 00:00:00 | 2020-07-27 00:00:00 | 2020-07-27 00:00:00 | 2020-07-27 00:00:00 | 2018-10-05 00:00:00 | 2020-04-24 00:00:00 | 2021-10-11 00:00:00 | 2020-10-28 00:00:00 | 2021-07-27 00:00:00 | 2021-07-27 00:00:00 | 2021-10-11 00:00:00 | 2020-10-28 00:00:00 | 2022-01-28 00:00:00 | 2021-10-11 00:00:00 | ||||||||||||||||||||
filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | ||||||||||||||||||||
filing_id | None | None | None | 2001499 | 2110530 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||
form_id | None | None | None | F604 | F604 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||
receive_comment | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation |