| filing_id | 1379547 | 1396600 | 1348539 | 1370406 | 1351017 | 1351017 | 2086457 | 2089480 | 2131475 | 2275614 | 2314367 | 2320985 | 2419168 | 2275614 | 2349591 | 2349591 | 2314367 | 2314367 | 2485112 | 2485112 | 2442135 | 2496052 | 2501160 | 2517106 | 2513834 | 2554224 | 2506238 | 2752511 | 2734215 | 2734262 | 2752536 | |||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 2 | 1 | 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 | CVR | CVR | CVR | CVR | |||||||||||||||||||||||||||||||
| form_type | F497 | F461 | F497 | F497 | F461 | F461 | F497 | F497 | F461 | F461 | F497 | F497 | F497 | F461 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F497 | F497 | F497 | F497 | F461 | F497 | F497 | F497 | F497 | F497 | |||||||||||||||||||||||||||||||
| filer_id | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | |||||||||||||||||||||||||||||||
| 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 | MDI | MDI | MDI | MDI | |||||||||||||||||||||||||||||||
| filer_naml | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | The San Francisco Foundation | |||||||||||||||||||||||||||||||
| 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 | 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 | 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 | None | |||||||||||||||||||||||||||||||
| report_num | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 001 | 000 | 002 | 001 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||||||||||||||||||||
| rpt_date | 2008-11-03 00:00:00 | 2009-01-26 00:00:00 | 2008-07-30 00:00:00 | 2008-10-23 00:00:00 | 2008-08-07 00:00:00 | 2008-07-22 00:00:00 | 2016-10-07 00:00:00 | 2016-10-15 00:00:00 | 2017-01-27 00:00:00 | 2018-07-31 00:00:00 | 2018-10-26 00:00:00 | 2018-10-31 00:00:00 | 2019-10-31 00:00:00 | 2019-03-29 00:00:00 | 2019-03-29 00:00:00 | 2019-01-30 00:00:00 | 2018-10-31 00:00:00 | 2018-10-31 00:00:00 | 2020-08-21 00:00:00 | 2020-07-30 00:00:00 | 2020-01-20 00:00:00 | 2020-08-28 00:00:00 | 2020-09-14 00:00:00 | 2020-10-16 00:00:00 | 2020-10-12 00:00:00 | 2021-01-20 00:00:00 | 2020-09-25 00:00:00 | 2022-11-04 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-11-04 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 | None | None | None | None | |||||||||||||||||||||||||||||||
| late_rptno | LCM-81101 | 003070 | LCM-80530 | LCM-81023 | 002919 | 002909 | LCM-20161006 | LCM-20161014 | None | None | LCM-20181025 | LCM-20181030 | LCM-20191021 | None | None | None | LCM-20181030-2 | LCM-20181030-1 | None | None | None | LCM-20200827 | LCM-20200910 | LCM-20201015 | LCM-20200917 | None | LCM-20200924 | LCM-220399 | LCR220279M | MO-LCR269M | LCR220412M | |||||||||||||||||||||||||||||||
| from_date | 2008-11-01 00:00:00 | 2008-07-01 00:00:00 | 2008-05-30 00:00:00 | 2008-10-23 00:00:00 | 2008-01-01 00:00:00 | 2008-01-01 00:00:00 | 2016-10-06 00:00:00 | 2016-10-14 00:00:00 | 2016-01-01 00:00:00 | 2018-01-01 00:00:00 | None | None | None | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-07-01 00:00:00 | None | None | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 2019-01-01 00:00:00 | None | None | None | None | 2020-07-01 00:00:00 | None | None | None | None | None | |||||||||||||||||||||||||||||||
| thru_date | 2008-11-01 00:00:00 | 2008-12-31 00:00:00 | 2008-05-30 00:00:00 | 2008-10-23 00:00:00 | 2008-06-30 00:00:00 | 2008-06-30 00:00:00 | 2016-10-06 00:00:00 | 2016-10-14 00:00:00 | 2016-12-31 00:00:00 | 2018-06-30 00:00:00 | None | None | None | 2018-06-30 00:00:00 | 2018-12-31 00:00:00 | 2018-12-31 00:00:00 | None | None | 2020-06-30 00:00:00 | 2020-06-30 00:00:00 | 2019-12-31 00:00:00 | None | None | None | None | 2020-12-31 00:00:00 | None | None | None | None | None | |||||||||||||||||||||||||||||||
| elect_date | None | 2008-11-04 00:00:00 | 2008-06-03 00:00:00 | None | 2008-06-03 00:00:00 | 2008-06-03 00:00:00 | 2016-11-08 00:00:00 | 2016-11-08 00:00:00 | None | None | 2018-11-06 00:00:00 | 2018-11-06 00:00:00 | 2019-11-05 00:00:00 | None | None | None | 2018-11-06 00:00:00 | 2018-11-06 00:00:00 | None | None | None | 2020-11-03 00:00:00 | 2020-11-03 00:00:00 | 2020-11-03 00:00:00 | 2020-11-03 00:00:00 | None | 2020-11-03 00:00:00 | 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 | 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 | CA | CA | CA | CA | |||||||||||||||||||||||||||||||
| filer_zip4 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | 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 | |||||||||||||||||||||||||||||||
| filer_phon | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | (650)401-8735 | (415)733-8525 | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | (415)733-8525 | (415)733-8525 | (415)733-8525 | (415) 733-8525 | (415) 733-8525 | (415)733-8525 | (415)733-8525 | (415)733-8525 | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | (415)733-8525 | (415) 733-8525 | (415) 733-8504 | (415) 733-8504 | (415) 733-8504 | (415) 733-8504 | |||||||||||||||||||||||||||||||
| filer_fax | ( ) | ( ) | ( ) | ( ) | ( ) | 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 | 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 | 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 | 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 | None | |||||||||||||||||||||||||||||||
| tres_naml | Pressley | Pressley | Pressley | Pressley | Pressley | Pressley | Pressley | Pressley | Miller | Pressley | None | None | None | Pressley | Pressley | Pressley | None | None | Pressley | Pressley | Pressley | None | None | None | None | Pressley | None | None | None | None | None | |||||||||||||||||||||||||||||||
| tres_namf | Monica | Monica | Monica | Monica | Monica | Monica | Monica | Monica | Russell | Monica | None | None | None | Monica | Monica | Monica | None | None | Monica | Monica | Monica | None | None | None | None | Monica | None | None | None | None | None | |||||||||||||||||||||||||||||||
| tres_namt | None | None | None | None | None | None | CA | None | CA | 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 | 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 | 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 | 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 | None | None | None | None | |||||||||||||||||||||||||||||||
| tres_phon | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | (650)401-8735 | (415) 733-8525 | None | None | None | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | None | None | (415) 733-8525 | (415) 733-8525 | (415) 733-8525 | None | None | None | None | (415) 733-8525 | 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 | |||||||||||||||||||||||||||||||
| 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 | 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 | None | None | None | None | |||||||||||||||||||||||||||||||
| control_yn | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||
| sponsor_yn | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||
| primfrm_yn | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||
| brdbase_yn | None | None | None | None | None | None | None | 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_1 | None | None | American Institute for Social Justice was the wrong committee name on original paper filing. | None | Filer was not aware that the grants made on 3/27/2008 to ACORN were | None | None | None | None | None | None | None | None | Update Part 5 | Update to Section 3 | None | Update Recipient Name | Revised Date of Contribution | Update Schedule D and Schedule E. | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||
| amendexp_2 | None | None | None | None | reportable campaign contributions at the time of the original filing. | None | None | 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 | Correct name and address reported here. Both were unknown to filer at time of original filing. | None | None | None | None | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | None | None | None | None | |||||||||||||||||||||||||||||||
| busact_cb | None | X | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||
| busactvity | None | Community Foundation | None | None | None | None | None | 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_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 | 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 | None | None | None | None | |||||||||||||||||||||||||||||||
| other_cb | None | None | None | None | X | X | None | None | X | X | None | None | None | X | X | X | None | None | X | X | X | None | None | None | None | X | None | None | None | None | None | |||||||||||||||||||||||||||||||
| other_int | None | None | None | None | Community Foundation | Community Foundation | None | None | Community Foundation | Community | None | None | None | Community | Community | Community | None | None | Community | Community | Community | None | None | None | None | Community | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | None | None | None | None |
| filer_id | 1307803 | 1307803 | ||
|---|---|---|---|---|
| adrid | 2138980 | 2426181 | ||
| effect_dt | 2008-06-02 00:00:00 | 2017-01-31 00:00:00 | ||
| add_type | 7051 | 7051 | ||
| session_id | 2007 | 2015 |
| filer_id | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | |||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 1351017 | 1341048 | 1348539 | 1371608 | 1353738 | 1357625 | 1353738 | 1370406 | 1351017 | 1380162 | 1379547 | 1396600 | 1402688 | 2419168 | 2320985 | 2349591 | 2519633 | 2314367 | 2086457 | 2089480 | 2137730 | 2131475 | 2368822 | 2314367 | 2485112 | 2275614 | 2282996 | 2368822 | 2517106 | 2275614 | 2349591 | 2506238 | 2554224 | 2368822 | 2314367 | 2442135 | 2485112 | 2496052 | 2513834 | 2282996 | 2501160 | 2584067 | 2464013 | 2734262 | 2734215 | 2752511 | 2752536 | |||||||||||||||||||||||||||||||||||||||||||||||
| period_id | 193 | None | 195 | None | None | None | None | 196 | 193 | None | 196 | 195 | None | 240 | 236 | 235 | None | 236 | 228 | 228 | None | 225 | None | 236 | 241 | 233 | None | None | 244 | 233 | 235 | 243 | 243 | None | 236 | 237 | 241 | 243 | 244 | None | 243 | None | None | 252 | 252 | 252 | 252 | |||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F461 | F497 | F497 | F497 | F461 | F497 | F461 | F497 | F461 | F497 | F497 | F461 | F461 | F497 | F497 | F461 | F461 | F497 | F497 | F497 | F461 | F461 | F461 | F497 | F461 | F461 | F461 | F461 | F497 | F461 | F461 | F497 | F461 | F461 | F497 | F461 | F461 | F497 | F497 | F461 | F497 | F461 | F461 | F497 | F497 | F497 | F497 | |||||||||||||||||||||||||||||||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||
| filing_date | 2008-07-31 00:00:00 | 2008-06-02 00:00:00 | 2008-07-30 00:00:00 | 2008-10-23 00:00:00 | 2008-07-31 00:00:00 | 2008-07-30 00:00:00 | 2008-08-20 00:00:00 | 2008-10-23 00:00:00 | 2008-08-07 00:00:00 | 2008-11-03 00:00:00 | 2008-11-03 00:00:00 | 2009-01-31 00:00:00 | 2009-02-02 00:00:00 | 2019-10-31 00:00:00 | 2018-10-31 00:00:00 | 2019-01-31 00:00:00 | 2020-07-31 00:00:00 | 2018-10-31 00:00:00 | 2016-10-07 00:00:00 | 2016-10-15 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2019-05-31 00:00:00 | 2018-10-26 00:00:00 | 2020-07-31 00:00:00 | 2018-07-31 00:00:00 | 2019-04-02 00:00:00 | 2019-04-02 00:00:00 | 2020-10-16 00:00:00 | 2019-03-29 00:00:00 | 2019-03-29 00:00:00 | 2020-09-25 00:00:00 | 2021-02-01 00:00:00 | 2019-01-31 00:00:00 | 2018-10-31 00:00:00 | 2020-01-31 00:00:00 | 2020-08-22 00:00:00 | 2020-08-28 00:00:00 | 2020-10-12 00:00:00 | 2018-07-31 00:00:00 | 2020-09-14 00:00:00 | 2021-02-01 00:00:00 | 2020-01-31 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-11-04 00:00:00 | 2022-11-04 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_type | 10001 | 10005 | 10001 | 10005 | 10005 | 10006 | 10006 | 10001 | 10002 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10001 | 10005 | 10001 | 10006 | 10001 | 10001 | 10001 | 10006 | 10006 | 10001 | 10002 | 10002 | 10001 | 10001 | 10005 | 10002 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||
| session_id | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2019 | 2017 | 2017 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2019 | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2017 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||
| user_id | MGUERRA | DHORRELL | DHORRELL | YRODRIGU | MGUERRA | RGEREMIA | JVAZQUEZ | DHORRELL | MGUERRA | DHORRELL | DHORRELL | JINGRAM | JINGRAM | RGEREMIA | CAFILER | GTAYLOR | GTAYLOR | CAFILER | GKURIMOT | GKURIMOT | JINGRAM | JINGRAM | GTAYLOR | CAFILER | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | CAFILER | GTAYLOR | GTAYLOR | CAFILER | GTAYLOR | GTAYLOR | CAFILER | GTAYLOR | CAFILER | CAFILER | RGEREMIA | GTAYLOR | RGEREMIA | GTAYLOR | GTAYLOR | CAFILER | CAFILER | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||
| fine_audit | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||
| rpt_start | 2008-01-01 00:00:00 | None | 2008-07-30 00:00:00 | None | 2008-01-01 00:00:00 | None | 2008-01-01 00:00:00 | 2008-10-23 00:00:00 | 2008-01-01 00:00:00 | None | 2008-11-03 00:00:00 | 2008-07-01 00:00:00 | 2008-07-01 00:00:00 | 2019-10-31 00:00:00 | 2018-10-31 00:00:00 | 2018-07-01 00:00:00 | 2020-01-01 00:00:00 | 2018-10-31 00:00:00 | 2016-10-07 00:00:00 | 2016-10-15 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-10-26 00:00:00 | 2020-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2020-10-16 00:00:00 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2020-09-25 00:00:00 | 2020-07-01 00:00:00 | 2018-07-01 00:00:00 | 2018-10-31 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 | 2020-08-28 00:00:00 | 2020-10-12 00:00:00 | 2018-01-01 00:00:00 | 2020-09-14 00:00:00 | 2020-07-01 00:00:00 | 2019-01-01 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-11-04 00:00:00 | 2022-11-04 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||
| rpt_end | 2008-06-30 00:00:00 | None | 2008-07-30 00:00:00 | None | 2008-06-30 00:00:00 | None | 2008-06-30 00:00:00 | 2008-10-23 00:00:00 | 2008-06-30 00:00:00 | None | 2008-11-03 00:00:00 | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | 2019-10-31 00:00:00 | 2018-10-31 00:00:00 | 2018-12-31 00:00:00 | 2020-06-30 00:00:00 | 2018-10-31 00:00:00 | 2016-10-07 00:00:00 | 2016-10-15 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2018-12-31 00:00:00 | 2018-10-26 00:00:00 | 2020-06-30 00:00:00 | 2018-06-30 00:00:00 | 2018-06-30 00:00:00 | 2018-12-31 00:00:00 | 2020-10-16 00:00:00 | 2018-06-30 00:00:00 | 2018-12-31 00:00:00 | 2020-09-25 00:00:00 | 2020-12-31 00:00:00 | 2018-12-31 00:00:00 | 2018-10-31 00:00:00 | 2019-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-08-28 00:00:00 | 2020-10-12 00:00:00 | 2018-06-30 00:00:00 | 2020-09-14 00:00:00 | 2020-12-31 00:00:00 | 2019-12-31 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-11-04 00:00:00 | 2022-11-04 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||
| rpt_date | 2008-07-22 00:00:00 | None | 2008-07-30 00:00:00 | None | None | None | None | 2008-10-23 00:00:00 | 2008-08-07 00:00:00 | None | 2008-11-03 00:00:00 | 2009-01-26 00:00:00 | None | 2019-10-31 00:00:00 | 2018-10-31 00:00:00 | 2019-01-30 00:00:00 | None | 2018-10-31 00:00:00 | 2016-10-07 00:00:00 | 2016-10-15 00:00:00 | None | 2017-01-27 00:00:00 | None | 2018-10-26 00:00:00 | 2020-07-30 00:00:00 | 2018-07-31 00:00:00 | None | None | 2020-10-16 00:00:00 | 2019-03-29 00:00:00 | 2019-03-29 00:00:00 | 2020-09-25 00:00:00 | 2021-01-20 00:00:00 | None | 2018-10-31 00:00:00 | 2020-01-20 00:00:00 | 2020-08-21 00:00:00 | 2020-08-28 00:00:00 | 2020-10-12 00:00:00 | None | 2020-09-14 00:00:00 | None | None | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-11-04 00:00:00 | 2022-11-04 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||
| filing_type | 22001 | None | 22001 | None | None | None | None | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 |
| filer_id | 1307803 | |
|---|---|---|
| filer_type | 10 | |
| active | Y | |
| race | 0 | |
| session_id | 2007 | |
| category | 0 | |
| category_type | 0 | |
| sub_category | 0 | |
| effect_dt | 2008-06-02 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 | 1307803 | |
|---|---|---|
| xref_id | 1307803 | |
| effect_dt | 2008-06-18 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1307803 | 1307803 | ||
|---|---|---|---|---|
| filer_id | 1307803 | 1307803 | ||
| filer_type | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | ||
| status | ACTIVE | ACTIVE | ||
| effect_dt | 2008-06-02 00:00:00 | 2008-06-02 00:00:00 | ||
| naml | SAN FRANCISCO FOUNDATION, THE | SAN FRANCISCO FOUNDATION, THE | ||
| namf | None | None | ||
| namt | None | None | ||
| nams | None | None | ||
| adr1 | None | None | ||
| adr2 | None | None | ||
| city | SAN FRANCISCO | SAN FRANCISCO | ||
| st | CA | CA | ||
| zip4 | 94104 | 94111 | ||
| phon | 4157338500 | 4157338525 | ||
| fax | None | None | ||
| None | None |
| filer_id | 1307803 |
|---|
| filer_id | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | 1307803 | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 1396600_0.cal | 1348539_0.cal | 1370406_0.cal | 1379547_0.cal | 2131475_0.cal | 2089480_0.cal | 2086457_0.cal | 254447.cal | 2320985_0.cal | 2349591_0.cal | 2314367_2.cal | 2419168_0.cal | 2314367_0.cal | 339780.cal | 339833.cal | 339638.cal | 2275614_0.cal | 2442135_0.cal | 2485112_0.cal | 339545.cal | 2314367_1.cal | 2485112_1.cal | 2496052_0.cal | 2275614_1.cal | 2349591_1.cal | 2517106_0.cal | 2752511_0.cal | 2506238_0.cal | 2554224_0.cal | 2734262_0.cal | 2501160_0.cal | 2513834_0.cal | ||||||||||||||||||||||||||||||||
| received_date | 2009-01-31 00:00:00 | 2008-07-30 00:00:00 | 2008-10-23 00:00:00 | 2008-11-03 00:00:00 | 2017-01-31 00:00:00 | 2016-10-15 00:00:00 | 2016-10-07 00:00:00 | 2015-02-02 00:00:00 | 2018-10-31 00:00:00 | 2019-01-31 00:00:00 | 2018-10-31 00:00:00 | 2019-10-31 00:00:00 | 2018-10-26 00:00:00 | 2020-08-22 00:00:00 | 2020-08-22 00:00:00 | 2020-08-22 00:00:00 | 2018-07-31 00:00:00 | 2020-01-31 00:00:00 | 2020-07-31 00:00:00 | 2020-08-22 00:00:00 | 2018-10-31 00:00:00 | 2020-08-22 00:00:00 | 2020-08-28 00:00:00 | 2019-03-29 00:00:00 | 2019-03-29 00:00:00 | 2020-10-16 00:00:00 | 2022-11-04 00:00:00 | 2020-09-25 00:00:00 | 2021-02-01 00:00:00 | 2022-10-14 00:00:00 | 2020-09-14 00:00:00 | 2020-10-12 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/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /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 | /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 | 1396600 | 1348539 | 1370406 | 1379547 | 2131475 | 2089480 | 2086457 | None | 2320985 | 2349591 | 2314367 | 2419168 | 2314367 | None | None | None | 2275614 | 2442135 | 2485112 | None | 2314367 | 2485112 | 2496052 | 2275614 | 2349591 | 2517106 | 2752511 | 2506238 | 2554224 | 2734262 | 2501160 | 2513834 | ||||||||||||||||||||||||||||||||
| form_id | F461 | F497 | F497 | F497 | F461 | F497 | F497 | None | F497 | F461 | F497 | F497 | F497 | None | None | None | F461 | F461 | F461 | None | F497 | F461 | F497 | F461 | F461 | F497 | F497 | F497 | F461 | F497 | F497 | F497 | ||||||||||||||||||||||||||||||||
| receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |