filing_id | 2394450 | 2379307 | 2470327 | 2436243 | 2418956 | 2548680 | 2483627 | 2526099 | 2483627 | 2483627 | 2596655 | 2616409 | 2577433 | 2640482 | 2735394 | 2699020 | 2672374 | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 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 | |||||||||||||||||
form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||||||||||
sender_id | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | |||||||||||||||||
filer_id | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | |||||||||||||||||
entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | |||||||||||||||||
filer_naml | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | |||||||||||||||||
filer_namf | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | |||||||||||||||||
filer_namt | 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 | |||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 002 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||||||
rpt_date | 2019-07-28 00:00:00 | 2019-04-29 00:00:00 | 2020-04-30 00:00:00 | 2020-01-27 00:00:00 | 2019-10-31 00:00:00 | 2021-01-28 00:00:00 | 2021-01-28 00:00:00 | 2020-10-29 00:00:00 | 2020-10-16 00:00:00 | 2020-07-30 00:00:00 | 2021-07-26 00:00:00 | 2021-10-18 00:00:00 | 2021-04-27 00:00:00 | 2022-01-28 00:00:00 | 2022-10-18 00:00:00 | 2022-07-19 00:00:00 | 2022-04-28 00:00:00 | |||||||||||||||||
from_date | 2019-04-01 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2020-04-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | |||||||||||||||||
thru_date | 2019-06-30 00:00:00 | 2019-03-31 00:00:00 | 2020-03-31 00:00:00 | 2019-12-31 00:00:00 | 2019-09-30 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-06-30 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 00:00:00 | |||||||||||||||||
cum_beg_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||
firm_id | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | |||||||||||||||||
firm_name | Bay Area Air Quality Management District | Bay Area Air Quality Management District | Bay Area Air Quality Management District | Bay Area Air Quality Management District | Bay Area Air Quality Management District | Bay Area Air Quality Management District | Bay Area Air Quality Management District | Bay Area Air Quality Management District | Bay Area Air Quality Management District | Bay Area AQMD | Bay Area Air Quality Management District | Bay Area Air Quality Management District | Bay Area Air Quality Management District | Bay Area Air Quality Management District | Bay Area Air Quality Management District | Bay Area Air Quality Management District | Bay Area Air Quality Management District | |||||||||||||||||
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 | |||||||||||||||||
firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||
firm_zip4 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | |||||||||||||||||
firm_phon | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | |||||||||||||||||
mail_city | 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 | |||||||||||||||||
mail_zip4 | 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 | |||||||||||||||||
sig_date | 2019-07-28 00:00:00 | 2019-04-29 00:00:00 | 2020-04-30 00:00:00 | 2020-01-27 00:00:00 | 2019-10-31 00:00:00 | 2021-01-28 00:00:00 | 2021-01-28 00:00:00 | 2020-10-29 00:00:00 | 2020-10-16 00:00:00 | 2020-07-30 00:00:00 | 2021-07-26 00:00:00 | 2021-10-18 00:00:00 | 2021-04-27 00:00:00 | 2022-01-28 00:00:00 | 2022-10-18 00:00:00 | 2022-07-19 00:00:00 | 2022-04-28 00:00:00 | |||||||||||||||||
sig_loc | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | |||||||||||||||||
sig_naml | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | |||||||||||||||||
sig_namf | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | |||||||||||||||||
sig_namt | 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 | |||||||||||||||||
prn_naml | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | Abbs | |||||||||||||||||
prn_namf | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | Alan | |||||||||||||||||
prn_namt | 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 | |||||||||||||||||
sig_title | Legislative Officer | Legislative Officer | Legislative Officer | Legislative Officer | Legislative Officer | Legislative Officer | Legislative Officer | Legislative Officer | Legislative Officer | Legislative Officer | Legislative Officer | Legislative Officer | Legislative Officer | Legislative Officer | Legislative Officer | Legislative Officer | Legislative Officer | |||||||||||||||||
nopart1_cb | 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 | |||||||||||||||||
part1_1_cb | 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 | |||||||||||||||||
ctrib_n_cb | 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 | |||||||||||||||||
lby_actvty | 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 | |||||||||||||||||
lobby_y_cb | 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 | |||||||||||||||||
major_namf | 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 | |||||||||||||||||
major_nams | 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 | |||||||||||||||||
rcpcmte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1418336 | 1418336 | 1418336 | |||
---|---|---|---|---|---|---|
adrid | 2544835 | 2507096 | 2479074 | |||
effect_dt | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-28 00:00:00 | |||
add_type | 7051 | 7051 | 7051 | |||
session_id | 2023 | 2021 | 2019 |
filer_id | 1418336 | 1418336 | ||
---|---|---|---|---|
session_id | 2019 | 2021 | ||
ethics_date | 2019-02-07 00:00:00 | 2021-06-10 00:00:00 |
filer_id | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2379307 | 2470327 | 2436243 | 2483627 | 2394450 | 2548680 | 2483627 | 2526099 | 2379276 | 2382637 | 2418956 | 2483627 | 2566511 | 2616409 | 2640482 | 2596655 | 2577433 | 2699020 | 2672374 | 2590978 | 2735394 | |||||||||||||||||||||
period_id | 237 | 241 | 240 | 242 | 238 | 244 | 242 | 243 | None | None | 239 | 242 | None | 247 | 248 | 246 | 245 | 250 | 249 | None | 251 | |||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | |||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
filing_date | 2019-04-29 00:00:00 | 2020-04-30 00:00:00 | 2020-01-27 00:00:00 | 2020-07-30 00:00:00 | 2019-07-28 00:00:00 | 2021-01-28 00:00:00 | 2021-01-28 00:00:00 | 2020-10-29 00:00:00 | 2019-02-07 00:00:00 | 2019-02-19 00:00:00 | 2019-10-31 00:00:00 | 2020-10-16 00:00:00 | 2020-12-31 00:00:00 | 2021-10-18 00:00:00 | 2022-01-28 00:00:00 | 2021-07-26 00:00:00 | 2021-04-27 00:00:00 | 2022-07-19 00:00:00 | 2022-04-28 00:00:00 | 2021-06-16 00:00:00 | 2022-10-18 00:00:00 | |||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10006 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | |||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | |||||||||||||||||||||
session_id | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||
user_id | GTAYLOR | VUKSTINA | GTAYLOR | CVANLIEW | GTAYLOR | GTAYLOR | CAFILER | GTAYLOR | YRODRIGU | SUSHAKOV | AROJAS | GTAYLOR | CVANLIEW | GTAYLOR | RATTIYEH | CHATRIDGE | GTAYLOR | CAFILER | CAFILER | MMERCHANT | CAFILER | |||||||||||||||||||||
special_audit | 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 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||
rpt_start | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 | 2019-10-01 00:00:00 | 2020-04-01 00:00:00 | 2019-04-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||
rpt_end | 2019-03-31 00:00:00 | 2020-03-31 00:00:00 | 2019-12-31 00:00:00 | 2020-06-30 00:00:00 | 2019-06-30 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2020-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 00:00:00 | 1900-01-01 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 | |||||||||||||||||||||
filing_type | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 |
filer_id | 1418336 | 1418336 | 1418336 | |||
---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | |||
active | Y | Y | N | |||
race | None | 0 | None | |||
session_id | 2021 | 2019 | 2023 | |||
category | None | 0 | None | |||
category_type | None | 0 | None | |||
sub_category | None | 0 | None | |||
effect_dt | 2021-01-01 00:00:00 | 2019-01-28 00:00:00 | 2023-01-01 00:00:00 | |||
sub_category_type | None | 0 | None | |||
election_type | None | 0 | None | |||
sub_category_a | None | None | None | |||
nyq_dt | None | None | None | |||
party_cd | None | 0 | None | |||
county_cd | None | 0 | None | |||
district_cd | None | 0 | None |
filer_id | 1418336 | |
---|---|---|
xref_id | 1418336 | |
effect_dt | 2019-04-29 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | 1418336 | |||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | |||||||||
status | 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 | |||||||||
naml | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | ABBS | |||||||||
namf | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | ALAN W. | |||||||||
namt | None | None | None | None | None | None | None | None | None | |||||||||
nams | None | None | None | None | None | None | None | None | None | |||||||||
adr1 | None | None | None | None | None | None | None | None | None | |||||||||
adr2 | 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 | |||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||
zip4 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | |||||||||
phon | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | 9167697769 | |||||||||
fax | None | None | None | None | None | None | None | None | None | |||||||||
[email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1418336 |
---|