Home

Filer ID: 1385723

Table: cvr_campaign_disclosure
filing_id   2042876
amend_id   0
rec_type   CVR
form_type   F497
filer_id   1385723
entity_cd   MDI
filer_naml   JOHN GRASSI
filer_namf   None
filer_namt   None
filer_nams   None
report_num   000
rpt_date   2016-05-13 00:00:00
stmt_type   None
late_rptno   LCR #396
from_date   None
thru_date   None
elect_date   None
filer_city   SAN FRANCISCO
filer_st   CA
filer_zip4   94118
filer_phon   None
filer_fax   None
file_email   None
mail_city   None
mail_st   None
mail_zip4   None
tres_naml   None
tres_namf   None
tres_namt   None
tres_nams   None
tres_city   None
tres_st   None
tres_zip4   None
tres_phon   None
tres_fax   None
tres_email   None
cmtte_type   None
control_yn   None
sponsor_yn   None
primfrm_yn   None
brdbase_yn   None
amendexp_1   None
amendexp_2   None
amendexp_3   None
rpt_att_cb   None
cmtte_id   None
reportname   None
rptfromdt   None
rptthrudt   None
emplbus_cb   None
bus_name   None
bus_city   None
bus_st   None
bus_zip4   None
bus_inter   None
busact_cb   None
busactvity   None
assoc_cb   None
assoc_int   None
other_cb   None
other_int   None
cand_naml   None
cand_namf   None
cand_namt   None
cand_nams   None
cand_city   None
cand_st   None
cand_zip4   None
cand_phon   None
cand_fax   None
cand_email   None
bal_name   None
bal_num   None
bal_juris   None
office_cd   None
offic_dscr   None
juris_cd   None
juris_dscr   None
dist_no   None
off_s_h_cd   None
sup_opp_cd   None
employer   None
occupation   None
selfemp_cb   None
bal_id   None
cand_id   None
Table: filer_address
filer_id   1385723
adrid   2396225
effect_dt   2016-05-13 00:00:00
add_type   7051
session_id   2015
Table: filer_filings
filer_id   1385723   1385723   1385723   1385723   1385723
filing_id   2042876   2074939   2573738   2573738   2573738
period_id   226   None   None   None   None
form_id   F497   F461   F461   F461   F461
filing_sequence   0   0   2   1   0
filing_date   2016-05-13 00:00:00   2016-08-02 00:00:00   2021-06-01 00:00:00   2021-05-14 00:00:00   2021-02-01 00:00:00
stmnt_type   10001   10005   10006   10006   10005
stmnt_status   11001   11001   11001   11001   11001
session_id   2015   2015   2021   2021   2021
user_id   KBANH   GCLARA   GTAYLOR   GTAYLOR   GTAYLOR
special_audit   11003   11003   11003   11003   11003
fine_audit   11001   11001   11001   11001   11001
rpt_start   2016-05-13 00:00:00   2016-01-01 00:00:00   2020-01-01 00:00:00   2020-01-01 00:00:00   2020-01-01 00:00:00
rpt_end   2016-05-13 00:00:00   2016-06-30 00:00:00   2020-12-31 00:00:00   2020-12-31 00:00:00   2020-12-31 00:00:00
rpt_date   2016-05-13 00:00:00   None   None   None   None
filing_type   22001   None   None   None   None
Table: filer_to_filer_type
filer_id   1385723
filer_type   10
active   Y
race   0
session_id   2015
category   0
category_type   40502
sub_category   0
effect_dt   2016-05-13 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
Table: filer_xref
filer_id   1385723
xref_id   1385723
effect_dt   2016-05-13 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1385723
filer_id   1385723
filer_type   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status   ACTIVE
effect_dt   2016-05-13 00:00:00
naml   GRASSI, JOHN
namf   None
namt   None
nams   None
adr1   None
adr2   None
city   SAN FRANCISCO
st   CA
zip4   94118
phon   None
fax   None
email   None
Table: filers
filer_id   1385723