| filing_id | 2212297 | 2308734 | 2297406 | 2324629 | 2350377 | 2443818 | 2443818 | 2509280 | 2552057 | 2512171 | 2512660 | 2531656 | 2670456 | 2639231 | 2552057 | 2585496 | 2585497 | 2681242 | 2712899 | 2722756 | 2723904 | 2720645 | 2712707 | 2712077 | 2707715 | 2740835 | 2751764 | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | |||||||||||||||||||||||||||
| form_type | F461 | F497 | F497 | F497 | F461 | F461 | F461 | F497 | F461 | F497 | F497 | F497 | F497 | F461 | F461 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F461 | F497 | F497 | |||||||||||||||||||||||||||
| filer_id | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | |||||||||||||||||||||||||||
| entity_cd | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | |||||||||||||||||||||||||||
| filer_naml | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | LIGHTHOUSE PUBLIC AFFAIRS | |||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||
| report_num | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||||||||||||||||
| rpt_date | 2018-01-31 00:00:00 | 2018-10-18 00:00:00 | 2018-09-27 00:00:00 | 2018-11-06 00:00:00 | 2019-01-29 00:00:00 | 2020-01-15 00:00:00 | 2020-05-14 00:00:00 | 2020-10-02 00:00:00 | 2021-01-30 00:00:00 | 2020-10-07 00:00:00 | 2020-10-09 00:00:00 | 2020-11-02 00:00:00 | 2022-04-25 00:00:00 | 2022-01-25 00:00:00 | 2021-05-25 00:00:00 | 2021-05-25 00:00:00 | 2021-05-25 00:00:00 | 2022-05-10 00:00:00 | 2022-08-19 00:00:00 | 2022-09-22 00:00:00 | 2022-09-26 00:00:00 | 2022-09-15 00:00:00 | 2022-08-18 00:00:00 | 2022-08-17 00:00:00 | 2022-08-01 00:00:00 | 2022-10-24 00:00:00 | 2022-11-03 00:00:00 | |||||||||||||||||||||||||||
| stmt_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| late_rptno | None | G18-LPA-02 | G18-LPA-01 | G18-LPA-03 | None | None | None | G20-LPA-02 | None | G20-LPA-03 | G20-LPA-04 | G20-LPA-05 | P22-LPA-01 | None | None | G20-LPA-06 | G20-LPA-07 | P22-LHP-02 | G22-LHP-03 | G22-LHP-05 | G22-LHP-06 | G22-LHP-04 | G22-LHP-02 | G22-LHP-01 | None | G22-LHP-07 | G22-LHP-08 | |||||||||||||||||||||||||||
| from_date | 2017-07-01 00:00:00 | None | None | None | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | None | 2020-01-01 00:00:00 | None | None | None | None | 2021-01-01 00:00:00 | 2020-01-01 00:00:00 | None | None | None | None | None | None | None | None | None | 2022-01-01 00:00:00 | None | None | |||||||||||||||||||||||||||
| thru_date | 2017-12-31 00:00:00 | None | None | None | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | None | 2020-12-31 00:00:00 | None | None | None | None | 2021-12-31 00:00:00 | 2020-12-31 00:00:00 | None | None | None | None | None | None | None | None | None | 2022-06-30 00:00:00 | None | None | |||||||||||||||||||||||||||
| elect_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 | |||||||||||||||||||||||||||
| filer_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 | |||||||||||||||||||||||||||
| filer_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 | |||||||||||||||||||||||||||
| filer_zip4 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | 94133 | |||||||||||||||||||||||||||
| filer_phon | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | (415) 364-0000 | |||||||||||||||||||||||||||
| filer_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 | |||||||||||||||||||||||||||
| file_email | None | None | None | 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_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 | |||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||
| tres_naml | ALVAREZ, ATTORNEY/AGENT FOR FILER | ALVAREZ, ATTORNEY/AGENT FOR FILER | ALVAREZ, ATTORNEY/AGENT FOR FILER | ALVAREZ, ATTORNEY/AGENT FOR FILER | ALVAREZ, ATTORNEY/AGENT FOR FILER | ALVAREZ, ATTORNEY/AGENT FOR FILER | ALVAREZ, ATTORNEY/AGENT FOR FILER | ALVAREZ, ATTORNEY/AGENT FOR FILER | PETERSON | ALVAREZ, ATTORNEY/AGENT FOR FILER | ALVAREZ, ATTORNEY/AGENT FOR FILER | ALVAREZ, ATTORNEY/AGENT FOR FILER | None | PETERSON | PETERSON | ALVAREZ, ATTORNEY/AGENT FOR FILER | ALVAREZ, ATTORNEY/AGENT FOR FILER | None | None | None | None | None | None | None | ALVAREZ | None | None | |||||||||||||||||||||||||||
| tres_namf | MATTHEW | MATTHEW | MATTHEW | MATTHEW | MATTHEW | MATTHEW | MATTHEW | MATTHEW | RICH | MATTHEW | MATTHEW | MATTHEW | None | RICH | RICH | MATTHEW | MATTHEW | None | None | None | None | None | None | None | MATTHEW | None | None | |||||||||||||||||||||||||||
| tres_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 | |||||||||||||||||||||||||||
| tres_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 | |||||||||||||||||||||||||||
| tres_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 | |||||||||||||||||||||||||||
| tres_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 | |||||||||||||||||||||||||||
| tres_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 | |||||||||||||||||||||||||||
| tres_phon | (415) 732-7700 | (415) 732-7700 | (415) 732-7700 | (415) 732-7700 | (415) 732-7700 | (415) 732-7700 | (415) 732-7700 | (415) 732-7700 | (415) 732-7700 | (415) 732-7700 | (415) 732-7700 | (415) 732-7700 | None | (415) 732-7700 | (415) 732-7700 | (415) 732-7700 | (415) 732-7700 | None | None | None | None | None | None | None | (415) 732-7700 | None | None | |||||||||||||||||||||||||||
| tres_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 | |||||||||||||||||||||||||||
| tres_email | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| cmtte_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| control_yn | N | None | None | None | N | N | N | None | N | None | None | None | None | N | N | None | None | None | None | None | None | None | None | None | N | None | None | |||||||||||||||||||||||||||
| sponsor_yn | N | None | None | None | N | N | N | None | N | None | None | None | None | N | N | None | None | None | None | None | None | None | None | None | N | None | None | |||||||||||||||||||||||||||
| primfrm_yn | N | None | None | None | N | N | N | None | N | None | None | None | None | N | N | None | None | None | None | None | None | None | None | None | N | None | None | |||||||||||||||||||||||||||
| brdbase_yn | N | None | None | None | N | N | N | None | N | None | None | None | None | N | N | None | None | None | None | None | None | None | None | None | N | None | None | |||||||||||||||||||||||||||
| amendexp_1 | None | None | None | None | None | None | UPDATED PART V | None | None | None | None | None | None | None | UPDATED PART V | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| amendexp_2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| amendexp_3 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| rpt_att_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 | |||||||||||||||||||||||||||
| cmtte_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 | |||||||||||||||||||||||||||
| reportname | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| rptfromdt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| rptthrudt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| emplbus_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 | |||||||||||||||||||||||||||
| bus_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| bus_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 | |||||||||||||||||||||||||||
| bus_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 | |||||||||||||||||||||||||||
| bus_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 | |||||||||||||||||||||||||||
| bus_inter | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| busact_cb | X | None | None | None | X | X | X | None | X | None | None | None | None | X | X | None | None | None | None | None | None | None | None | None | X | None | None | |||||||||||||||||||||||||||
| busactvity | PUBLIC AFFAIRS FIRM | None | None | None | PUBLIC AFFAIRS FIRM | PUBLIC AFFAIRS FIRM | PUBLIC AFFAIRS FIRM | None | PUBLIC AFFAIRS FIRM | None | None | None | None | PUBLIC AFFAIRS FIRM | PUBLIC AFFAIRS FIRM | None | None | None | None | None | None | None | None | None | PUBLIC AFFAIRS FIRM | None | None | |||||||||||||||||||||||||||
| assoc_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 | |||||||||||||||||||||||||||
| assoc_int | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| other_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 | |||||||||||||||||||||||||||
| other_int | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| cand_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 | |||||||||||||||||||||||||||
| cand_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 | |||||||||||||||||||||||||||
| cand_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 | |||||||||||||||||||||||||||
| cand_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 | |||||||||||||||||||||||||||
| cand_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 | |||||||||||||||||||||||||||
| cand_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 | |||||||||||||||||||||||||||
| cand_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 | |||||||||||||||||||||||||||
| cand_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 | |||||||||||||||||||||||||||
| cand_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 | |||||||||||||||||||||||||||
| cand_email | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| bal_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| bal_num | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| bal_juris | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| office_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| offic_dscr | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| juris_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| juris_dscr | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| dist_no | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| off_s_h_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| sup_opp_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| employer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| occupation | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||
| selfemp_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 | |||||||||||||||||||||||||||
| bal_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 | |||||||||||||||||||||||||||
| cand_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 |
| filer_id | 1398195 | |
|---|---|---|
| adrid | 2438343 | |
| effect_dt | 2017-07-31 00:00:00 | |
| add_type | 7051 | |
| session_id | 2017 |
| filer_id | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | |||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 2212297 | 2512171 | 2324629 | 2297406 | 2180567 | 2443818 | 2509280 | 2229580 | 2180567 | 2363673 | 2512660 | 2443818 | 2552057 | 2308734 | 2463182 | 2531656 | 2350377 | 2463182 | 2585496 | 2585497 | 2681242 | 2639231 | 2552057 | 2573065 | 2670456 | 2712077 | 2712707 | 2723904 | 2720645 | 2720072 | 2712899 | 2722756 | 2651804 | 2707715 | 2573065 | 2740835 | 2751764 | |||||||||||||||||||||||||||||||||||||
| period_id | 231 | 244 | 236 | 235 | None | 237 | 244 | None | None | None | 244 | 237 | 241 | 236 | None | 244 | 233 | None | 246 | 246 | 250 | 245 | 241 | None | 250 | 251 | 251 | 251 | 251 | None | 251 | 251 | None | 249 | None | 252 | 252 | |||||||||||||||||||||||||||||||||||||
| form_id | F461 | F497 | F497 | F497 | F461 | F461 | F497 | F461 | F461 | F461 | F497 | F461 | F461 | F497 | F461 | F497 | F461 | F461 | F497 | F497 | F497 | F461 | F461 | F461 | F497 | F497 | F497 | F497 | F497 | F461 | F497 | F497 | F461 | F461 | F461 | F497 | F497 | |||||||||||||||||||||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||
| filing_date | 2018-01-31 00:00:00 | 2020-10-08 00:00:00 | 2018-11-06 00:00:00 | 2018-09-27 00:00:00 | 2017-08-29 00:00:00 | 2020-01-31 00:00:00 | 2020-10-02 00:00:00 | 2018-01-31 00:00:00 | 2017-07-31 00:00:00 | 2019-01-31 00:00:00 | 2020-10-09 00:00:00 | 2020-05-28 00:00:00 | 2021-05-28 00:00:00 | 2018-10-18 00:00:00 | 2020-05-29 00:00:00 | 2020-11-02 00:00:00 | 2019-01-31 00:00:00 | 2020-01-31 00:00:00 | 2021-05-25 00:00:00 | 2021-05-25 00:00:00 | 2022-05-10 00:00:00 | 2022-01-27 00:00:00 | 2021-01-30 00:00:00 | 2021-01-28 00:00:00 | 2022-04-25 00:00:00 | 2022-08-17 00:00:00 | 2022-08-18 00:00:00 | 2022-09-26 00:00:00 | 2022-09-15 00:00:00 | 2022-08-02 00:00:00 | 2022-08-19 00:00:00 | 2022-09-22 00:00:00 | 2022-01-28 00:00:00 | 2022-08-01 00:00:00 | 2021-06-01 00:00:00 | 2022-10-25 00:00:00 | 2022-11-03 00:00:00 | |||||||||||||||||||||||||||||||||||||
| stmnt_type | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10002 | 10002 | 10001 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10006 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||
| stmnt_status | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||
| session_id | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||
| user_id | DMCCASTL | CAFILER | RGEREMIA | RGEREMIA | LPALMER | GTAYLOR | CAFILER | GTAYLOR | LPALMER | GTAYLOR | CAFILER | GTAYLOR | GTAYLOR | RGEREMIA | GTAYLOR | CAFILER | GTAYLOR | GTAYLOR | RGEREMIA | RGEREMIA | CAFILER | GTAYLOR | GTAYLOR | GTAYLOR | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | GTAYLOR | CAFILER | CAFILER | GTAYLOR | GTAYLOR | 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 | |||||||||||||||||||||||||||||||||||||
| fine_audit | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||
| rpt_start | 2017-07-01 00:00:00 | 2020-10-07 00:00:00 | 2018-11-06 00:00:00 | 2018-09-27 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-10-02 00:00:00 | 2017-07-01 00:00:00 | 2017-01-01 00:00:00 | 2018-01-01 00:00:00 | 2020-10-09 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 | 2018-10-18 00:00:00 | 2019-01-01 00:00:00 | 2020-11-02 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-05-25 00:00:00 | 2021-05-25 00:00:00 | 2022-05-10 00:00:00 | 2021-01-01 00:00:00 | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 2022-04-25 00:00:00 | 2022-08-17 00:00:00 | 2022-08-18 00:00:00 | 2022-09-26 00:00:00 | 2022-09-15 00:00:00 | 2022-01-01 00:00:00 | 2022-08-19 00:00:00 | 2022-09-22 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2020-01-01 00:00:00 | 2022-10-24 00:00:00 | 2022-11-03 00:00:00 | |||||||||||||||||||||||||||||||||||||
| rpt_end | 2017-12-31 00:00:00 | 2020-10-07 00:00:00 | 2018-11-06 00:00:00 | 2018-09-27 00:00:00 | 2017-06-30 00:00:00 | 2019-12-31 00:00:00 | 2020-10-02 00:00:00 | 2017-12-31 00:00:00 | 2017-06-30 00:00:00 | 2018-12-31 00:00:00 | 2020-10-09 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2018-10-18 00:00:00 | 2019-12-31 00:00:00 | 2020-11-02 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2021-05-25 00:00:00 | 2021-05-25 00:00:00 | 2022-05-10 00:00:00 | 2021-12-31 00:00:00 | 2020-12-31 00:00:00 | 2020-12-31 00:00:00 | 2022-04-25 00:00:00 | 2022-08-17 00:00:00 | 2022-08-18 00:00:00 | 2022-09-26 00:00:00 | 2022-09-15 00:00:00 | 2022-06-30 00:00:00 | 2022-08-19 00:00:00 | 2022-09-22 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2020-12-31 00:00:00 | 2022-10-24 00:00:00 | 2022-11-03 00:00:00 | |||||||||||||||||||||||||||||||||||||
| rpt_date | 2018-01-31 00:00:00 | 2020-10-07 00:00:00 | 2018-11-06 00:00:00 | 2018-09-27 00:00:00 | None | 2020-01-15 00:00:00 | 2020-10-02 00:00:00 | None | None | None | 2020-10-09 00:00:00 | 2020-05-14 00:00:00 | 2021-05-25 00:00:00 | 2018-10-18 00:00:00 | None | 2020-11-02 00:00:00 | 2019-01-29 00:00:00 | None | 2021-05-25 00:00:00 | 2021-05-25 00:00:00 | 2022-05-10 00:00:00 | 2022-01-25 00:00:00 | 2021-01-30 00:00:00 | None | 2022-04-25 00:00:00 | 2022-08-17 00:00:00 | 2022-08-18 00:00:00 | 2022-09-26 00:00:00 | 2022-09-15 00:00:00 | None | 2022-08-19 00:00:00 | 2022-09-22 00:00:00 | None | 2022-08-01 00:00:00 | None | 2022-10-24 00:00:00 | 2022-11-03 00:00:00 | |||||||||||||||||||||||||||||||||||||
| filing_type | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | None | 22001 | 22001 |
| filer_id | 1398195 | |
|---|---|---|
| filer_type | 10 | |
| active | Y | |
| race | 0 | |
| session_id | 2017 | |
| category | 0 | |
| category_type | 0 | |
| sub_category | 0 | |
| effect_dt | 2017-07-31 00:00:00 | |
| sub_category_type | 0 | |
| election_type | 0 | |
| sub_category_a | None | |
| nyq_dt | None | |
| party_cd | 0 | |
| county_cd | 0 | |
| district_cd | 0 |
| filer_id | 1398195 | |
|---|---|---|
| xref_id | 1398195 | |
| effect_dt | 2017-08-15 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1398195 | |
|---|---|---|
| filer_id | 1398195 | |
| filer_type | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | |
| status | ACTIVE | |
| effect_dt | 2017-07-31 00:00:00 | |
| naml | LIGHTHOUSE PUBLIC AFFAIRS | |
| namf | None | |
| namt | None | |
| nams | None | |
| adr1 | None | |
| adr2 | None | |
| city | SAN FRANCISCO | |
| st | CA | |
| zip4 | 94133 | |
| phon | 4153640000 | |
| fax | None | |
| None |
| filer_id | 1398195 |
|---|
| filer_id | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | 1398195 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 2324629_0.cal | 2723904_0.cal | 2670456_0.cal | 2740835_0.cal | 2512660_0.cal | 2751764_0.cal | 2681242_0.cal | 2720645_0.cal | 2722756_0.cal | |||||||||
| received_date | 2018-11-06 00:00:00 | 2022-09-26 00:00:00 | 2022-04-25 00:00:00 | 2022-10-25 00:00:00 | 2020-10-09 00:00:00 | 2022-11-03 00:00:00 | 2022-05-10 00:00:00 | 2022-09-15 00:00:00 | 2022-09-22 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/cal | /cafiler/disclose/ca99/cal | |||||||||
| filing_id | 2324629 | 2723904 | 2670456 | 2740835 | 2512660 | 2751764 | 2681242 | 2720645 | 2722756 | |||||||||
| form_id | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | |||||||||
| receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |