filing_id | 1335312 | 1368106 | 1395514 | 1350094 | 1395514 | 2038629 | 2064943 | 2135807 | 2229384 | 2309148 | 2267961 | 2311821 | 2341766 | 2502482 | 2511510 | 2554199 | 2602297 | 2639212 | 2602297 | 2702405 | 2700876 | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | |||||||||||||||||||||
form_type | F497 | F497 | F461 | F461 | F461 | F497 | F461 | F461 | F497 | F497 | F461 | F497 | F461 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F497 | |||||||||||||||||||||
filer_id | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | |||||||||||||||||||||
entity_cd | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | |||||||||||||||||||||
filer_naml | Thomas Coates | Thomas Coates and Affiliated Entities | Thomas Coates and Affiliated Entities | Thomas Coates and Affiliated Entities (see attached) | Thomas Coates and Affiliated Entities | THOMAS COATES | THOMAS COATES | THOMAS COATES | THOMAS COATES | THOMAS COATES | THOMAS COATES | THOMAS COATES | THOMAS COATES | THOMAS COATES | THOMAS COATES | THOMAS COATES | THOMAS COATES | THOMAS COATES | THOMAS COATES | THOMAS COATES | THOMAS COATES | |||||||||||||||||||||
filer_namf | 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 | |||||||||||||||||||||
filer_nams | 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 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | |||||||||||||||||||||
rpt_date | 2008-05-22 00:00:00 | 2008-10-21 00:00:00 | 2009-02-12 00:00:00 | 2008-07-31 00:00:00 | 2009-01-30 00:00:00 | 2016-05-02 00:00:00 | 2016-08-01 00:00:00 | 2017-02-09 00:00:00 | 2018-04-09 00:00:00 | 2018-10-19 00:00:00 | 2018-07-31 00:00:00 | 2018-10-24 00:00:00 | 2019-01-28 00:00:00 | 2020-09-16 00:00:00 | 2020-10-07 00:00:00 | 2021-01-22 00:00:00 | 2021-08-01 00:00:00 | 2022-01-27 00:00:00 | 2022-01-27 00:00:00 | 2022-07-20 00:00:00 | 2022-07-22 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 | |||||||||||||||||||||
late_rptno | 001 | 002 | None | None | None | P16-CTS-01 | None | None | G18-CTS-01 | G18-CTS-02 | None | G18-CTS-03 | None | G20-CTS-01 | G20-CTS-02 | None | None | None | None | None | P22-CTS-01 | |||||||||||||||||||||
from_date | None | None | 2008-07-01 00:00:00 | 2008-01-01 00:00:00 | 2008-07-01 00:00:00 | None | 2016-01-01 00:00:00 | 2016-07-01 00:00:00 | None | None | 2018-01-01 00:00:00 | None | 2018-07-01 00:00:00 | None | None | 2020-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | None | |||||||||||||||||||||
thru_date | None | None | 2008-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-12-31 00:00:00 | None | 2016-06-30 00:00:00 | 2016-12-31 00:00:00 | None | None | 2018-06-30 00:00:00 | None | 2018-12-31 00:00:00 | None | None | 2020-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | None | |||||||||||||||||||||
elect_date | 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 | |||||||||||||||||||||
filer_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||
filer_zip4 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | 94111 | |||||||||||||||||||||
filer_phon | None | None | None | None | None | 415/273-2139 | 415/273-2139 | 415/273-2139 | 415/273-2139 | 415/273-2139 | 415/273-2139 | 415/273-2139 | 415/273-2139 | 415/273-2139 | 415/273-2139 | 415/273-2139 | 415/273-2139 | 415/273-2139 | 415/273-2139 | 415/273-2139 | 415/273-2139 | |||||||||||||||||||||
filer_fax | 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 | |||||||||||||||||||||
mail_city | 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 | |||||||||||||||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||
tres_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||
tres_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | |||||||||||||||||||||
tres_nams | 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 | |||||||||||||||||||||
tres_st | 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 | |||||||||||||||||||||
tres_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | |||||||||||||||||||||
tres_email | 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 | |||||||||||||||||||||
control_yn | None | None | N | N | N | None | N | N | None | None | N | None | N | None | None | N | N | N | N | N | None | |||||||||||||||||||||
sponsor_yn | None | None | N | N | N | None | N | N | None | None | N | None | N | None | None | N | N | N | N | N | None | |||||||||||||||||||||
primfrm_yn | None | None | N | N | N | None | N | N | None | None | N | None | N | None | None | N | N | N | N | N | None | |||||||||||||||||||||
brdbase_yn | None | None | N | N | N | None | N | N | None | None | N | None | N | None | None | N | N | N | N | N | None | |||||||||||||||||||||
amendexp_1 | None | None | Add contributions | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | UPDATED PART V | 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 | |||||||||||||||||||||
amendexp_3 | 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 | |||||||||||||||||||||
cmtte_id | 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 | |||||||||||||||||||||
rptfromdt | 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 | |||||||||||||||||||||
emplbus_cb | None | None | X | X | X | None | X | X | None | None | X | None | X | None | None | X | X | X | X | X | None | |||||||||||||||||||||
bus_name | None | None | Jackson Square Properties | Jackson Square Properties | Jackson Square Properties | None | JACKSON SQUARE PROPERTIES | JACKSON SQUARE PROPERTIES | None | None | JACKSON SQUARE PROPERTIES | None | JACKSON SQUARE PROPERTIES | None | None | JACKSON SQUARE PROPERTIES | JACKSON SQUARE PROPERTIES | JACKSON SQUARE PROPERTIES | JACKSON SQUARE PROPERTIES | JACKSON SQUARE PROPERTIES | None | |||||||||||||||||||||
bus_city | None | None | San Francisco | San Francisco | San Francisco | None | SAN FRANCISCO | SAN FRANCISCO | None | None | SAN FRANCISCO | None | SAN FRANCISCO | None | None | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | None | |||||||||||||||||||||
bus_st | None | None | CA | CA | CA | None | CA | CA | None | None | CA | None | CA | None | None | CA | CA | CA | CA | CA | None | |||||||||||||||||||||
bus_zip4 | None | None | 94111 | 94111 | 94111 | None | 94111 | 94111 | None | None | 94111 | None | 94111 | None | None | 94111 | 94111 | 94111 | 94111 | 94111 | None | |||||||||||||||||||||
bus_inter | None | None | Real Estate | Real Estate | Real Estate | None | REAL ESTATE | REAL ESTATE | None | None | REAL ESTATE | None | REAL ESTATE | None | None | REAL ESTATE | REAL ESTATE | REAL ESTATE | REAL ESTATE | REAL ESTATE | None | |||||||||||||||||||||
busact_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||
busactvity | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | |||||||||||||||||||||
assoc_int | 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 | |||||||||||||||||||||
other_int | 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 | |||||||||||||||||||||
cand_namf | 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 | |||||||||||||||||||||
cand_nams | 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 | |||||||||||||||||||||
cand_st | 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 | |||||||||||||||||||||
cand_phon | 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 | |||||||||||||||||||||
cand_email | 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 | |||||||||||||||||||||
bal_num | 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 | |||||||||||||||||||||
office_cd | 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 | |||||||||||||||||||||
juris_cd | 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 | |||||||||||||||||||||
dist_no | 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 | |||||||||||||||||||||
sup_opp_cd | 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 | |||||||||||||||||||||
occupation | 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 | |||||||||||||||||||||
bal_id | 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 |
filer_id | 1263889 | 1263889 | 1263889 | 1263889 | ||||
---|---|---|---|---|---|---|---|---|
adrid | 2064784 | 2399398 | 2476324 | 2283363 | ||||
effect_dt | 2004-01-29 00:00:00 | 2016-06-02 00:00:00 | 2019-03-08 00:00:00 | 2013-01-31 00:00:00 | ||||
add_type | 7051 | 7051 | 7051 | 7051 | ||||
session_id | 2003 | 2015 | 2019 | 2011 |
filer_id | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1006576 | 1350094 | 1335312 | 1336328 | 1368106 | 1354945 | 1369404 | 1381500 | 1395514 | 1402370 | 1425376 | 1395514 | 1402370 | 1747209 | 2366052 | 2341766 | 2309148 | 2038629 | 2064943 | 2049750 | 2076685 | 2135807 | 2140941 | 2229384 | 2267961 | 2269302 | 2502482 | 2311821 | 2511510 | 2602297 | 2700876 | 2554199 | 2610013 | 2639212 | 2602297 | 2610013 | 2651821 | 2568050 | 2702405 | 2711403 | ||||||||||||||||||||||||||||||||||||||||
period_id | None | 193 | 194 | None | 196 | None | None | None | 195 | None | None | 195 | None | None | None | 235 | 236 | 226 | 225 | None | None | 227 | None | 234 | 233 | None | 243 | 236 | 244 | 245 | 251 | 241 | None | 247 | 245 | None | None | None | 249 | None | ||||||||||||||||||||||||||||||||||||||||
form_id | F461 | F461 | F497 | F497 | F497 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F461 | F497 | F497 | F497 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | ||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
filing_date | 2004-01-29 00:00:00 | 2008-07-31 00:00:00 | 2008-05-22 00:00:00 | 2008-05-22 00:00:00 | 2008-10-21 00:00:00 | 2008-07-31 00:00:00 | 2008-10-21 00:00:00 | 2008-11-12 00:00:00 | 2009-02-13 00:00:00 | 2009-02-02 00:00:00 | 2009-05-29 00:00:00 | 2009-01-30 00:00:00 | 2009-02-17 00:00:00 | 2013-01-31 00:00:00 | 2019-01-29 00:00:00 | 2019-01-28 00:00:00 | 2018-10-19 00:00:00 | 2016-05-02 00:00:00 | 2016-08-01 00:00:00 | 2016-06-02 00:00:00 | 2016-08-01 00:00:00 | 2017-02-09 00:00:00 | 2017-01-31 00:00:00 | 2018-04-09 00:00:00 | 2018-07-23 00:00:00 | 2018-07-24 00:00:00 | 2020-09-17 00:00:00 | 2018-10-24 00:00:00 | 2020-10-07 00:00:00 | 2021-08-01 00:00:00 | 2022-07-25 00:00:00 | 2021-02-01 00:00:00 | 2021-08-02 00:00:00 | 2022-01-27 00:00:00 | 2022-01-27 00:00:00 | 2022-01-28 00:00:00 | 2022-01-28 00:00:00 | 2021-02-01 00:00:00 | 2022-07-27 00:00:00 | 2022-07-28 00:00:00 | ||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10002 | 10005 | 10005 | 10001 | 10006 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10006 | 10005 | 10005 | 10001 | 10005 | ||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11002 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | ||||||||||||||||||||||||||||||||||||||||
session_id | 2003 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2007 | 2009 | 2011 | 2019 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||
user_id | DHORRELL | SMCCABE | DHORRELL | LHOANG | DHORRELL | SMCCABE | YRODRIGU | JINGRAM | * | JINGRAM | JINGRAM | JINGRAM | JVAZQUEZ | JINGRAM | GTAYLOR | GTAYLOR | CAFILER | KBANH | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | CAFILER | LPALMER | LPALMER | CAFILER | CAFILER | CAFILER | GTAYLOR | RGEREMIA | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | ||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||
fine_audit | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | ||||||||||||||||||||||||||||||||||||||||
rpt_start | 2003-01-01 00:00:00 | 2008-01-01 00:00:00 | 2008-05-22 00:00:00 | None | 2008-10-21 00:00:00 | 2008-01-01 00:00:00 | None | 2008-07-01 00:00:00 | 2008-07-01 00:00:00 | 2008-07-01 00:00:00 | 2009-05-26 00:00:00 | 2008-07-01 00:00:00 | 2008-07-01 00:00:00 | 2012-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-07-01 00:00:00 | 2018-10-19 00:00:00 | 2016-05-02 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-07-01 00:00:00 | 2016-07-01 00:00:00 | 2018-04-09 00:00:00 | 2018-01-01 00:00:00 | 2018-01-01 00:00:00 | 2020-09-16 00:00:00 | 2018-10-24 00:00:00 | 2020-10-07 00:00:00 | 2021-01-01 00:00:00 | 2022-07-22 00:00:00 | 2020-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2020-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||
rpt_end | 2003-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-05-22 00:00:00 | None | 2008-10-21 00:00:00 | 2008-06-30 00:00:00 | None | 2008-11-07 00:00:00 | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-05-26 00:00:00 | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | 2012-12-31 00:00:00 | 2018-12-31 00:00:00 | 2018-12-31 00:00:00 | 2018-10-19 00:00:00 | 2016-05-02 00:00:00 | 2016-06-30 00:00:00 | 2016-01-01 00:00:00 | 2016-06-30 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2018-04-09 00:00:00 | 2018-06-30 00:00:00 | 2018-06-30 00:00:00 | 2020-09-16 00:00:00 | 2018-10-24 00:00:00 | 2020-10-07 00:00:00 | 2021-06-30 00:00:00 | 2022-07-22 00:00:00 | 2020-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2020-12-31 00:00:00 | 2022-06-30 00:00:00 | 2022-06-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||
rpt_date | None | 2008-07-31 00:00:00 | 2008-05-22 00:00:00 | None | 2008-10-21 00:00:00 | None | None | None | 2009-02-12 00:00:00 | None | None | 2009-01-30 00:00:00 | None | None | None | 2019-01-28 00:00:00 | 2018-10-19 00:00:00 | 2016-05-02 00:00:00 | 2016-08-01 00:00:00 | None | None | 2017-02-09 00:00:00 | None | 2018-04-09 00:00:00 | 2018-07-31 00:00:00 | None | 2020-09-16 00:00:00 | 2018-10-24 00:00:00 | 2020-10-07 00:00:00 | 2021-08-01 00:00:00 | 2022-07-22 00:00:00 | 2021-01-22 00:00:00 | None | 2022-01-27 00:00:00 | 2022-01-27 00:00:00 | None | None | None | 2022-07-20 00:00:00 | None | ||||||||||||||||||||||||||||||||||||||||
filing_type | None | 22001 | 22001 | None | 22001 | None | None | None | 22001 | None | None | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | None | None | 22001 | None |
filer_id | 1263889 | |
---|---|---|
filer_type | 10 | |
active | Y | |
race | 0 | |
session_id | 2003 | |
category | 0 | |
category_type | 40502 | |
sub_category | 0 | |
effect_dt | 2004-01-29 00:00:00 | |
sub_category_type | 0 | |
election_type | 0 | |
sub_category_a | None | |
nyq_dt | None | |
party_cd | 0 | |
county_cd | 18043 | |
district_cd | 0 |
filer_id | 1263889 | |
---|---|---|
xref_id | 1263889 | |
effect_dt | 2004-03-16 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | ||||||||||||
filer_type | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | ||||||||||||
status | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ||||||||||||
effect_dt | 2004-01-29 00:00:00 | 2004-01-29 00:00:00 | 2004-01-29 00:00:00 | 2004-01-29 00:00:00 | 2004-01-29 00:00:00 | 2004-01-29 00:00:00 | 2004-01-29 00:00:00 | 2004-01-29 00:00:00 | 2004-01-29 00:00:00 | 2004-01-29 00:00:00 | 2004-01-29 00:00:00 | 2004-01-29 00:00:00 | ||||||||||||
naml | COATES, THOMAS | COATES, THOMAS | COATES, THOMAS | COATES, THOMAS | COATES, THOMAS, AND AFFILIATED ENTITIES | COATES, THOMAS, AND AFFILIATED ENTITIES | COATES, THOMAS, AND AFFILIATED ENTITIES | COATES, THOMAS, AND AFFILIATED ENTITIES | COATES, THOMAS J. | COATES, THOMAS J. | COATES, THOMAS J. | COATES, THOMAS J. | ||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
nams | 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 | ||||||||||||
adr2 | 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 | ||||||||||||
st | 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 | ||||||||||||
phon | 4154457800 | 4152732139 | 4152732128 | 4152732139 | 4154457800 | 4152732139 | 4152732128 | 4152732139 | 4154457800 | 4152732139 | 4152732128 | 4152732139 | ||||||||||||
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 |
filer_id | 1263889 |
---|
filer_id | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | 1263889 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 434261.cal | 434299.cal | 1395514_1.cal | 1395514_0.cal | 1350094_0.cal | 1368106_0.cal | 28259.cal | 2309148_0.cal | 2311821_0.cal | 2511510_0.cal | ||||||||||
received_date | 2009-02-13 00:00:00 | 2009-02-13 00:00:00 | 2009-02-13 00:00:00 | 2009-01-30 00:00:00 | 2008-07-31 00:00:00 | 2008-10-21 00:00:00 | 2016-05-02 00:00:00 | 2018-10-19 00:00:00 | 2018-10-24 00:00:00 | 2020-10-07 00:00:00 | ||||||||||
filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||
filing_id | None | None | 1395514 | 1395514 | 1350094 | 1368106 | None | 2309148 | 2311821 | 2511510 | ||||||||||
form_id | None | None | F461 | F461 | F461 | F497 | None | F497 | F497 | F497 | ||||||||||
receive_comment | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted |